Spreadsheet: 154767d1336559861-sumif-adding-associated-values-new-take-off-sheet
Sheet: Take-Off

 | Project | xxx
 | CRM | 2440
 | Equipment |  |  |  |  | System_Integration | Ballast_Controllers | Sensors | Relay_Controllers | Leading_Trailing_Edge_Controllers | DR2PE_Scene_Plates | DPNE_Scene_Plates | DPWE_Scene_Plates | Timeclocks
 | Drawing Number | Revision | Level |  |  | DNG100BT | DDBC1200-MO | DUS804C | DDRC1220FR-GL | DLE405-NB | DR2PE AXX-X-S-SS-P-BO-X-S | DPNE981DN-SF | DPWE970-WE-SS-ENG | DDTC001
 | xxxxx | xx | Basement |  |  | 1 |  |  | 2
 | xxxxx | xx | Ground Floor |  |  | 1 | 3 | 52 | 3 | 1 | 5 | 2 | 6 | 1
 | xxxxx | xx | 1st Floor |  |  |  |  |  |  |  |  | 6
 | xxxxx | xx | 2nd Floor |  |  |  | 2 | 3 | 3 |  | 4 |  | 7 | 5
 | xxxxx | xx | 3rd Floor |  |  |  |  |  |  | 3 |  | 6
 | xxxxx | xx | 4th Floor |  |  | 1
 | xxxxx | xx | 5th Floor |  |  |  |  |  |  |  | 56 |  | 5
 | xxxxx | xx | 6th Floor
 | xxxxx | xx | 7th Floor
 | Totals
 | Need More Power
 | Equipment |  |  |  |  | Touchscreens | Timeclocks | Sensors | System_Integration | Network_Acessories | Ballast_Controllers | Remote_Controls | Fixture_Couplers | Network_Acessories
 | Drawing Number | Revision | Level |  |  | DTP100-BG | DDTC001 | DUS704W | DMNG232 | DTK622-USB-J | DDBC320-DALI | DTK510 | DMRC210 | DDNP1501
 |  |  |  |  |  | 6 |  | 10 |  | 1
 |  |  |  |  |  |  | 4 | 6 | 3
 |  |  |  |  |  |  |  |  |  |  | 6 | 4 | 6 | 5
 |  |  |  |  |  | 6 |  | 5 |  | 3
 |  |  |  |  |  |  | 3 |  | 6 |  | 4 | 56
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | Totals
 |  | Days |  | Product Code | Part Number | Quantity | Ind. Com | Total Commisioin | Trade Price | Total Price | Please add the following Equipment
 | Configuration & Programming | 0
 | Separate Training | 0
 | Applications | 1
 | Other Engineering | 0
 | [NAME] (Y/N)
 | [NAME] (Y/N)
 | DALI emergency feedback (Y/N)
 | Dynalite non-DALI commissioning
 | Dynalite DALI commissioning
 | Total Days
 | Total Cost
 | Total Sell
 | DALI calculator
 | No. of ballasts
 | No. of universes
 | Configuration Cost / Day | 270
 | Configuration Sell / Day | 500 |  | Total Equipment Sell Price
 | Out of hours (type no. of days) | 0 |  | Total Inc Commissioning
 |  |  |  | Inc VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  |  | sub total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of ballasts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No universes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | No of days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commissioning costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baseline Commissioning costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The greater of the two total costs/days should
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | be charged
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Dali |  | Value | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total commisioning days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value ex. DALI |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greater should be
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | charged