Holarch

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.

  1. Open Plan → Spreadsheets and click + New Spreadsheet. Type Mass Budget and press Enter.
  2. 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").
  3. In D2 type =B2*(1+C2). Select D2:D4 and press ⌘D / Ctrl+D to fill the formula down.
  4. In D6 type =SUM(D2:D4), in D7 the allocation, in D8 =(D7-D6)/D7, and click %.
  5. With D8 selected, click Conditional ▾ → Highlight Cells Rules → Less Than, type 0.1 and click OK. The margin is highlighted when it falls below 10 %.
  6. 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

Spreadsheets · Track Budgets and TPMs · Budgets & TPMs