Plan · How-to
Build a Budget Spreadsheet
Build a mass budget with contingency and a margin check in a spreadsheet, reading item masses from the model.
- Open Plan → Spreadsheets and click + New Spreadsheet. Type
Mass Budgetand press Enter. - In row 1 type the headings
Subsystem,Mass (kg),Contingency,With contingency. In rows 2–4 type a subsystem, its mass and its contingency (10%). To read a mass from the model, type=HOLARCH.VALUE("Payload Camera","Mass"). - In D2 type
=B2*(1+C2). Select D2:D4 and press ⌘D / Ctrl+D to fill the formula down. - In D6 type
=SUM(D2:D4), in D7 the allocation, in D8=(D7-D6)/D7, and click %. - With D8 selected, click Conditional ▾ → Highlight Cells Rules → Less Than, type
0.1and click OK. The margin is highlighted when it falls below 10 %. - For many items, click Model Table…, choose the Asset class and the Mass column, and total it with
=SUM(Parts[Mass]). The table follows the model.
Related
Full documentation: Spreadsheets › Build a budget spreadsheet