Spreadsheet: 888763d1739344142-sum-lookups-across-multiple-tabs-using-dynamic-formulas-demand-planning
Sheet: 9160

 | NAME |  |  | Building Project 3 |  |  |  |  |  | Fund |  |  | Unfunded |  |  | OPP |  |  | 9160 |  |  | VALUE |  |  | 60000
 | [NAME] |  |  |  |  |  |  |  |  | PYRAMID |  |  |  |  |  |  |  |  | PHOTO
 | M2 |  |  | 1200
 | ASM Lead
 | Status
 | High/Low Rise
 | New Build/Retrofit
 | No. Blocks/Houses
 | Houses per Week
 | Access Method
 | [NAME]
 | PROGRAMME (mmm-yy) |  |  | INSTALLER APPOINTMENT |  |  |  | ENABLING |  |  |  | ACCESS INSTALLATION |  |  |  | STRIP OFF |  |  |  | WINDOW REPLACEMENT |  |  |  | EWI START
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-09-01 00:00:00
 | SYSTEM |  |  | FINISH |  |  | INSULATION |  |  | THICKNESS |  |  | SUPPLY SOURCE |  |  | # BOARDS |  |  | SYSTEM TTW/m2 |  |  | DURATION |  |  | BOARDS/MONTH
 | OTHER KML MANUFACTURED COMPONENTS (Estimate Only) |  |  |  |  |  |  |  |  | NOTES on INSULATION AVAILABILITY |  |  |  |  |  |  |  |  | NOTES on FINISHES (Colour References)
 | BASECOATS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 | FINISHES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | Can they take direct shipments? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | Vehicle type required? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 | NOTES on PROGRAMME DELAYS
 | Material Demand Plan - Essential Items
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Item Code |  |  |  | Item Description |  |  |  |  |  |  |  |  |  | Unit of Sale |  |  | Qty in Job |  |  | Start Taking |  |  | Duration |  |  |  | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00
 | Component 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 1000 |  |  | 2025-10-01 00:00:00 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 200 | 200 | 200 | 200 | 200
 | Component 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 300 |  |  | 2025-10-01 00:00:00 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 150 |  | 50
 | Component 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 600 |  |  | 2025-11-01 00:00:00 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 | 100 | 100 | 100 | 100
 | Component 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 200 |  |  | 2026-01-01 00:00:00 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25
 | Component 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Board |  |  | 100 |  |  | 2026-04-01 00:00:00 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50