Spreadsheet: 151243d1334839503-find-text-string-then-sum-formula-new-take-off-sheet-test
Sheet: RAW Data

12 NC | Part Number | Price | Install Time | Supply/Draw | Product Group | Dali Calculation??????????
[PHONE] |  |  | 0 | 200 | Ballast Controllers
[PHONE] |  |  | 0 | 200 | Ballast Controllers
[PHONE] |  |  | 0 | 200 | Ballast Controllers
[PHONE] |  |  | 36 | 180 | Ballast Controllers
[PHONE] |  |  | 36 | 180 | Ballast Controllers
[PHONE] |  |  | 36 | 90 | Ballast Controllers
[PHONE] |  |  | 36 | 90 | Ballast Controllers
[PHONE] |  |  | 36 | 120 | Ballast Controllers
913703038109 |  |  | 36 | 120 | Ballast Controllers
913703051009 |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 120 | Relay Controllers
[PHONE] |  |  | 36 | 200 | Relay Controllers
913703057909 |  |  | 36 | 200 | Relay Controllers
[PHONE] |  |  | 60 | 400 | Ecolinx LCM
[PHONE] |  |  | 60 | 400 | Ecolinx LCM
[PHONE] |  |  | 0 |  | Ecolinx LCM
[PHONE] |  |  | 0 |  | Ecolinx LCM
[PHONE] |  |  | 0 |  | Ecolinx LCM
919913994329 |  |  | 0 |  | Ecolinx LCM
[PHONE] |  |  | 50 | 120 | Multi-Purpose Controllers
[PHONE] |  |  | 50 | 120 | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
913703025509 |  |  | 0 |  | Multi-Purpose Controllers
913703026009 |  |  | 50 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 |  | Multi-Purpose Controllers
[PHONE] |  |  | 36 | 120 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 120 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 120 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 120 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 120 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 36 | 200 | Leading & Trailing Edge Dimming Controllers
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 15 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 10 | -50 | DR2PE
[PHONE] |  |  | 7 | -50 | DR2PE
913703200009 |  |  | 0 | -20 | DPNE
913703200309 |  |  | 15 | -20 | DPNE
913703200409 |  |  | 15 | -20 | DPNE
913703200609 |  |  | 10 | -20 | DPNE
913703201809 |  |  | 10 | -20 | DPNE
913703201909 |  |  | 10 | -20 | DPNE
913703202109 |  |  | 5 | -20 | DPNE
913703202509 |  |  | 10 | -20 | DPNE
913703202609 |  |  | 5 | -20 | DPNE
913703202909 |  |  | 7 | -20 | DPNE
913703203009 |  |  | 7 | -20 | DPNE
913703203109 |  |  | 7 | -20 | DPNE
913703203209 |  |  | 7 | -20 | DPNE
[PHONE] |  |  | 15 | -35 | DPWE
[PHONE] |  |  | 10 | -35 | DPWE
[PHONE] |  |  | 10 | -35 | DPWE
[PHONE] |  |  | 10 | -35 | DPWE
[PHONE] |  |  | 10 | -35 | DPWE
[PHONE] |  |  | 10 | -35 | DPWE
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 0 |  | TouchScreens
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 1 |  | TouchScreens
[PHONE] |  |  | 0 |  | TouchScreens
[PHONE] |  |  | 2 | -20 | Timeclocks
[PHONE] |  |  | 2 | -50 | Timeclocks
[PHONE] |  |  | 20 | -20 | Sensors
[PHONE] |  |  | 20 | -20 | Sensors
913703070409 |  |  | 20 | -80 | Sensors
[PHONE] |  |  | 20 | -20 | Sensors
[PHONE] |  |  | 20 | -20 | Sensors
[PHONE] |  |  | 6 | -20 | Sensors
[PHONE] |  |  | 6 | -20 | Sensors
913703080009 |  |  | 0 | -50 | System Integration
913703080109 |  |  | 0 |  | System Integration
[PHONE] |  |  | 10 | -200 | System Integration
[PHONE] |  |  | 20 | -50 | System Integration
[PHONE] |  |  | 15 | -20 | System Integration
[PHONE] |  |  | ? | 120 | System Integration
[PHONE] |  |  | 4 | -70 | System Integration
[PHONE] |  |  | 7 | -375 | System Integration
913703081709 |  |  | 10 | 90 | System Integration
[PHONE] |  |  | 0 | -100 | System Integration
913703081409 |  |  | #N/A | -50 | System Integration
[PHONE] |  |  | 10 | 90 | System Integration
[PHONE] |  |  | 10 | 90 | System Integration
[PHONE] |  |  | 0 | 90 | System Integration
[PHONE] |  |  | 7 | 375 | System Integration
[PHONE] |  |  | 0 | 1500 | NetworkAcessories
[PHONE] |  |  | 1 | -50 | NetworkAcessories
[PHONE] |  |  | 0 |  | NetworkAcessories
[PHONE] |  |  | 0 |  | Software
SW913703092009 | DLIII Server (inc. 10 device/area licenses) | 78 | dependant on Job |  | Software
SW913703092209 | DLIII Server additional device/area license | 8 | dependant on Job |  | Software
SW913703092309 | DLIII [NAME] | 786 | dependant on Job |  | Software
[PHONE] |  | 80.31 | 10 |  | RemoteControls
[PHONE] |  | 80.31 | 10 |  | RemoteControls
[PHONE] |  | 80.31 | 10 |  | RemoteControls
[PHONE] |  | 80.31 | 10 |  | RemoteControls
[PHONE] |  | 80.31 | 10 |  | RemoteControls
[PHONE] |  | 97.75 | 20 |  | FixtureCouplers
[PHONE] |  | 138.65 | 20 |  | FixtureCouplers
[PHONE] | LRM1070/00 | 39.98 | 0 |  | Occu_Series
[PHONE] | LRM1080/00 | 57.9 | 0 |  | Occu_Series
[PHONE] | LRH1070/00 | 9.9 | 0 |  | Occu_Series
[PHONE] | LCC1070/00 | 17 | 0 |  | Occu_Series
[PHONE] | LRM2070/00 | 28.59 | 0 |  | Occu_Series
[PHONE] | LCC2070/00 | 29 | 0 |  | Occu_Series
[PHONE] | LRM2080/00 | 32.14 | 0 |  | Occu_Series
[PHONE] | LRM2080/00 | 31 | 0 |  | Occu_Series
[PHONE] | LRM2090/00 | 99.9 | 0 |  | Occu_Series
[PHONE] | LRH2070/00 | 9.9 | 0 |  | Occu_Series
[PHONE] | IRT8097/00 | 50 | 0 |  | Occu_Series
[PHONE] | IRT8099/10 | 59.9 | 0 |  | Occu_Series
[PHONE] | LBC5006/10 | 8737.64 | #N/A |  | Light_Master_Modular
[PHONE] | LBC5007/00 | 10557.99 | #N/A |  | Light_Master_Modular
[PHONE] | LBC5008/10 | 8776.94 | #N/A |  | Light_Master_Modular
[PHONE] | LCN5009/00 | 1348.76 | #N/A |  | Light_Master_Modular
[PHONE] | LCN8605/38 | 312.81 | #N/A |  | Light_Master_Modular
[PHONE] | LFC5089/10 | 1392.43 | #N/A |  | Light_Master_Modular
[PHONE] | LFC5089/20 | 1423.03 | #N/A |  | Light_Master_Modular
[PHONE] | LCNBACOM | 2805.28 | #N/A |  | Light_Master_Modular
[PHONE] | LCN5232/00 | 1532.28 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5914/10 | 289.28 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5924/10 | 335.94 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5934/10 | 318.86 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5944/10 | 332.56 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5414/10 | 343.88 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5423/10 | 265.48 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5059/10 | 238.78 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5141/10 | 269.16 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5143/10 | 247.92 | #N/A |  | Light_Master_Modular
[PHONE] | LCC5301/00 | 67.88 | #N/A |  | Light_Master_Modular
[PHONE] | LRC5501/00 | 560 | #N/A |  | Light_Master_Modular
 | LRC5502/00 | #N/A | #N/A |  | Light_Master_Modular
[PHONE] | TSU9600 | 1726.28 | #N/A |  | LMM Scene Setting
[PHONE] | TSU9400 | 964.34 | #N/A |  | LMM Scene Setting
[PHONE] | LXS8806/VC | 292.87 | #N/A |  | LMM Scene Setting
[PHONE] | LXS8808/VC | 422.22 | #N/A |  | LMM Scene Setting
[PHONE] | LCP5780/TSA | 5093.52 | #N/A |  | LMM Panels & Additional Products
[PHONE] | LRD8000/10 | 229.73 | #N/A |  | General_Purpose
[PHONE] | LRD8010/10 | 224.01 | #N/A |  | General_Purpose
[PHONE] | LRD9087/00 | 165.22 | #N/A |  | General_Purpose
[PHONE] | LRM8114/00 | 50.96 | #N/A |  | General_Purpose
[PHONE] | LRM8115/00 | 73.34 | #N/A |  | General_Purpose
[PHONE] | LRM8116/00 | 72.29 | #N/A |  | General_Purpose
[PHONE] | LRM8117/00 | 73.35 | #N/A |  | General_Purpose
[PHONE] | LRI8134/00 | 79.3 | #N/A |  | General_Purpose
[PHONE] | LRL8102/10 | 60.73 | #N/A |  | General_Purpose
[PHONE] | IRR8125/10 | 24.12 | #N/A |  | General_Purpose
[PHONE] | LRL1220/05 | 10.49 | #N/A |  | General_Purpose
[PHONE] | LRL1220/08 | 10.49 | #N/A |  | General_Purpose
[PHONE] | LCU8020/00 | 81.32 | #N/A |  | General_Purpose
[PHONE] | LRL5002/10 | 79.09 | #N/A |  | General_Purpose
[PHONE] | IRT8050/00 | 49.71 | #N/A |  | General_Purpose
[PHONE] | IRT8055/00 | 61.2 | #N/A |  | General_Purpose
[PHONE] | IRT8010/00 | 49.61 | #N/A |  | General_Purpose
[PHONE] | IRT8030/00 | 127.54 | #N/A |  | General_Purpose
[PHONE] | IRT8040/00 | 97.53 | #N/A |  | General_Purpose
[PHONE] | IRT8080/00 | 97.53 | #N/A |  | General_Purpose
[PHONE] | IRT7090/00 | 107.98 | #N/A |  | General_Purpose
[PHONE] | IRT8080/P | 98.89 | #N/A |  | General_Purpose
[PHONE] | LRH5100/10 | 46.54 | #N/A |  | General_Purpose
[PHONE] | LRH8010/00 | 1.89 | #N/A |  | General_Purpose
[PHONE] | LRH8100/00 | 1.42 | #N/A |  | General_Purpose
[PHONE] | LCC8011/00 | 5.98 | #N/A |  | General_Purpose
[PHONE] | LCC8012/00 | 10.05 | #N/A |  | General_Purpose
[PHONE] | LCC8013/00 | 26.6 | #N/A |  | General_Purpose
[PHONE] | LCC8014/00 | 8.97 | #N/A |  | General_Purpose
[PHONE] | LCC8015/00 | 12.4 | #N/A |  | General_Purpose
[PHONE] | LCC8016/00 | 22.52 | #N/A |  | General_Purpose
[PHONE] | LCC8016/10 | 35.74 | #N/A |  | General_Purpose
[PHONE] | LCC8016/20 | 34.59 | #N/A |  | General_Purpose
[PHONE] | LCC8024/00 | 10.53 | #N/A |  | General_Purpose
[PHONE] | LCC8025/00 | 10.28 | #N/A |  | General_Purpose
 | LRC9611/00 | #N/A | #N/A |  | [NAME]
[PHONE] | LRC9610/00 | #N/A | #N/A |  | [NAME]
[PHONE] | LRC9600/00 | #N/A | #N/A |  | [NAME]
[PHONE] | LRC7500/00 | 5459.53 | #N/A |  | [NAME]
[PHONE] | LCN7211/00 | 797.56 | #N/A |  | [NAME]
[PHONE] | LRC7106/00 | 672.44 | #N/A |  | [NAME]
[PHONE] | [NAME] | 118.96 | #N/A |  | [NAME]
[PHONE] | LCA9109/15 | 101.68 | #N/A |  | [NAME]
[PHONE] | LCT7200/00 | #N/A | #N/A |  | [NAME]
[PHONE] | LTC9100/00 | #N/A | #N/A |  | [NAME]
[PHONE] | LCP7706/00 | 7324.38 | #N/A |  | [NAME]
[PHONE] | LCC9511/63 | 15.52 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9511/65 | 20.3 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9512/63 | 12.64 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9512/65 | 17.31 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9513/43 | 9.77 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9513/45 | 12.89 | #N/A |  | LMM Leads & Plugs
[PHONE] | [NAME] | 15.5 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9515/45 | 18.43 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9516/33 | 5.48 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9516/35 | 11.52 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9517/53 | 12.14 | #N/A |  | LMM Leads & Plugs
[PHONE] | [NAME] | 16.25 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9517/33 | 6.07 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9517/35 | 9.73 | #N/A |  | LMM Leads & Plugs
[PHONE] | [NAME] | 1.78 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9528/30 | 1.48 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9531/20 | 1.36 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9531/21 | 1.36 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCA9532/30 | 0.85 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCA9533/20 | 3.04 | #N/A |  | LMM Leads & Plugs
[PHONE] | LCC9526/40 | 1.99 | #N/A |  | LMM Leads & Plugs
[PHONE] | LRC1030/10 | 138.6 | #N/A |  | Trios
[PHONE] | LRC1035/10 | 135.51 | #N/A |  | Trios
[PHONE] | LRC1020/20 | 117.4 | #N/A |  | Trios
[PHONE] | LRC1010/20 | 117.13 | #N/A |  | Trios
[PHONE] | LRC1015/20 | 109.5 | #N/A |  | Trios