Spreadsheet: 156712d1337420594-conditional-formatting-general-prob-and-how-to-change-colour-of-a-cell-if-text-is-in-it-0ls
Sheet: Take-Off

 | Project | xxx
 | CRM | 2440
 | Equipment |  |  |  |  | Ballast_Controllers | Relay_Controllers | Sensors | DR2PE_Scene_Plates | Network_Acessories | System_Integration | Ecolinx_LCM | Ecolinx_LCM
 | Drawing Number | Revision | Level |  |  | DDBC1200 | DDRC1220FR-GL | DUS804C | DR2PE CXX-X-C-SS-P-BW-X-S | DDNP1501 | DNG100BT | DBC905W | DBC905C
 | xxxxx | xx | Basement |  |  | 1 | 1 | 32 | 1 | 1 | 1 | 23 | 1 |  |  | 1200
 | xxxxx | xx | Ground Floor |  |  | 2 | 2 | 12 | 3 |  | 1 | 21 | 2 |  |  | 300
 | xxxxx | xx | 1st Floor |  |  | 3 | 2 | 23 | 12 | 1 | 2 | 12 | 2 |  |  | 1400
 | xxxxx | xx | 2nd Floor |  |  | 1 | 2 | 1000 | 6 | 1 | 1 | 222 | 3 |  |  | -18290
 | xxxxx | xx | 3rd Floor |  |  | 2 | 1 | 32 | 5 | 1 | 2 | 21 | 2222 |  |  | 1270
 | xxxxx | xx | 4th Floor |  |  | 4 | 3 | 12 | 3 |  | 1 | 26 | 1 |  |  | 780
 | xxxxx | xx | 5th Floor |  |  | 1 | 2 | 12 | 7 | 1 | 1 | 23 | 2 |  |  | 1420
 | xxxxx | xx | 6th Floor |  |  | 1 | 1 | 34 | 5 | 1 | 1 | 16 | 1 |  |  | 960
 | xxxxx | xx | 7th Floor |  |  | 2 | 1 | 53 | 3 | 1 | 1 | 8 | 2 |  |  | 860
 | Totals |  |  |  |  | 17 | 15 | 1210 | 45 | 7 | 11 | 372 | 2236 | 0
 | Equipment |  |  |  |  | Sensors
 | Drawing Number | Revision | Level |  |  | DUS804C-RJ
 | xxxxx | xx | Basement |  |  | 2 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | Ground Floor |  |  | 3 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 1st Floor |  |  | 5 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 2nd Floor |  |  | 4 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 3rd Floor |  |  | 1 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 4th Floor |  |  | 2 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 5th Floor |  |  | 4 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 6th Floor |  |  | 3 |  |  |  |  |  |  |  |  |  | 0
 | xxxxx | xx | 7th Floor |  |  | 2 |  |  |  |  |  |  |  |  |  | 0
 | Totals |  |  |  |  | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Equipment
 | Drawing Number | Revision | Level
 | xxxxx | xx | Basement |  |  |  |  |  |  |  |  |  |  |  | 1200 | 0
 | xxxxx | xx | Ground Floor |  |  |  |  |  |  |  |  |  |  |  | 300 | 0
 | xxxxx | xx | 1st Floor |  |  |  |  |  |  |  |  |  |  |  | 1400 | 0
 | xxxxx | xx | 2nd Floor |  |  |  |  |  |  |  |  |  |  |  | -18290 | 0
 | xxxxx | xx | 3rd Floor |  |  |  |  |  |  |  |  |  |  |  | 1270 | 0
 | xxxxx | xx | 4th Floor |  |  |  |  |  |  |  |  |  |  |  | 780 | 0
 | xxxxx | xx | 5th Floor |  |  |  |  |  |  |  |  |  |  |  | 1420 | 0
 | xxxxx | xx | 6th Floor |  |  |  |  |  |  |  |  |  |  |  | 960 | 0
 | xxxxx | xx | 7th Floor |  |  |  |  |  |  |  |  |  |  |  | 860 | 0
 | Totals |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | Need More Power
 |  | Days |  | Product Code | Part Number | Quantity | Ind. Com | Total Commisioin | Trade Price | Total Price | Please add the following Equipment
 | Configuration & Programming | 0 |  | DDBC1200 | 913703031309 | 17 | 0.3333333333333333 | 5.666666666666666 | 433.43 | 7368.31 | #N/A | #N/A | #N/A | #N/A
 | Separate Training | 3 |  | DDRC1220FR-GL | 913703053009 | 15 | 0.3333333333333333 | 5 | 514.94 | 7724.1 | #N/A | #N/A | #N/A | #N/A
 | Applications | 1 |  | DUS804C | 913703071009 | 1210 | 0.05 | 60.5 | 95.65 | 115736.5 | #N/A | #N/A | #N/A | #N/A
 | Dynalite non-DALI commissioning | #N/A |  | DR2PE CXX-X-C-SS-P-BW-X-S | 913703130109 | 45 | 0.06666666666666667 | 3 | 189.04 | 8506.8 | #N/A | #N/A | #N/A | #N/A
 | Dynalite DALI commissioning | 0 |  | DDNP1501 | 913703090309 | 7 | 0 | 0 | 160.65 | 1124.55 | #N/A | #N/A | #N/A | #N/A
 | Total Days | #N/A |  | DNG100BT | 913703082009 | 11 | 0.1 | 1.1 | 664.99 | 7314.89 | #N/A | #N/A | #N/A | #N/A
 | Total Cost | #N/A |  | DBC905W | 913703040009 | 372 | 0.15 | 55.8 | 383.98 | 142840.56 | #N/A | #N/A | thj | #N/A
 | Total Sell | #N/A |  | DBC905C | 913703040509 | 2236 | 0.15 | 335.4 | 243 | 543348 | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
 | DALI calculator |  |  | DUS804C-RJ | 913703071209 | 26 | 0.05 | 1.3 | 95.65 | 2486.9 |  |  |  | #N/A
 | No. of ballasts | 0 |  |  |  |  |  |  |  |  | Commissioing Questions
 | No. of universes | 0 |  |  |  |  |  |  |  |  | 1) DBC905W’s control type?
 |  |  |  |  |  |  |  |  |  |  | i) If DALI, then please specify the following
 | Configuration Cost / Day NWH | 270 |  |  |  |  |  |  |  |  | ii) Are there any DALI emergencies luminaires?
 | Configuration Sell / Day NWH | 500 |  |  |  |  |  |  |  |  | iii) What is the average No. of switch inputs per DBC905W?
 | Configuration Sell / Day OOH | 540 |  |  |  |  |  |  |  |  | 2) Sensors | Daylight (%) | Motion (%) | Both (%)
 | Configuration Sell / Day OOH | 1000
 | Out of hours (type no. of days) | 3 |  |  |  |  |  |  |  |  | 3) How many channels on DMX controllers?
 |  |  |  | Total Equipment Sell Price |  |  |  |  |  | 836450.61
 |  |  |  | Total Inc Commissioning |  |  |  |  |  | #N/A
 |  |  |  | Inc VAT |  |  |  |  |  | #N/A
 |  | #N/A
 | [NAME]: |  |  | sub total
 |  | No of ballasts | 0 | 0
 |  | No universes | 0 | 0
 |  |  |  | Total | No of days
 |  | Commissioning costs |  | 0 | 0
 |  | Baseline Commissioning costs |  | 0 | 0
 |  | The greater of the two total costs/days should |  | 0 | 0
 |  | be charged
 | Non-Dali |  | Value | Days
 |  | Total commisioning days |  | 0
 |  | Total Value ex. DALI | 0 | 0 | 0
 |  | Greater should be
 |  | charged |  | 0