{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Instructions","1-Customer Information","2-Lighting Equipment Entry","Lighting Equipment Savings","LED in Ref. Cases Entry","LED in Ref. Cases Savings","Occup. Sensors-Photocells Entry","Occup. Snsrs-Photocells Savings","Financial Summary","Terms and Conditions","Modification Instructions","Revision Log","Rebate Tables","Results","Rebate Questions","Dropdown Menus","Compatibility Report"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":2,"defined_names":219,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1-Customer Information","index":1,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[58,1,58,7],[55,8,55,11],[58,8,58,11],[43,1,43,7],[43,8,43,11],[55,1,55,7],[49,1,49,11],[52,1,52,5],[52,6,52,8],[52,10,52,11],[24,6,24,8],[23,1,24,1],[27,10,27,11],[33,1,33,7],[36,1,36,7],[33,8,33,11],[36,8,36,11],[22,10,22,11],[18,1,18,5],[9,1,9,5],[9,6,9,11],[12,1,12,5],[12,6,12,8],[15,1,15,5],[15,6,15,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Account Name",null,null,null,null,"Doing Business As (if different from Account Name)"]
[]
[]
[null,"Installation Address",null,null,null,null,"City",null,null,"State","Zip Code"]
[]
[]
[null,"Mailing Address (if different from above) (check mailed here)",null,null,null,null,"City",null,null,"State","Zip Code"]
[]
[]
[null,"Account Number "]
[]
[null,"Type of Business"]
[]
[]
[]
[]
[null,"How did you hear about CONSERVE & SAVE?"]
[]
[]
[]
[]
[]
[]
[]
[null,"Contact Name (check will be mailed to contact)",null,null,null,null,null,null,"Daytime Phone Number"]
[]
[]
[null,"Email"]
[]
[]
[]
[]
[]
[]
[null,"Customer's Signature",null,null,null,null,null,null,"Date "]
[]
[]
[]
[]
[]
[null,"Company Name"]
[]
[]
[null,"Address",null,null,null,null,"City",null,null,"State","Zip Code"]
[]
[]
[null,"Contact Name",null,null,null,null,null,null,"Daytime Phone Number"]
[]
[]
[null,"Email"]

{"sheet":"2-Lighting Equipment Entry","index":2,"n_rows":101,"n_cols":256,"rows_kept":101,"cut":false,"hidden":false,"merged":[[7,13,7,14],[21,13,21,14],[42,12,42,13],[38,4,38,5],[37,4,37,5],[7,3,7,12],[36,12,36,13],[37,12,37,13],[21,0,22,4],[31,4,31,5],[23,8,27,11],[32,4,32,5],[23,12,27,13],[21,10,21,11],[37,0,37,1],[31,0,31,1],[38,0,38,1],[41,12,41,13],[4,1,4,3],[33,4,33,5],[5,1,5,3],[39,0,39,1],[39,4,39,5],[36,4,36,5],[35,0,35,1],[34,4,34,5],[36,0,36,1],[35,4,35,5],[7,0,7,2],[34,0,34,1],[32,0,32,1],[33,0,33,1]]}
["REBATE INFORMATION "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Form Revision Date:","9.19.2023"]
["LIGHTING EQUIPMENT:"]
[]
["Project Type:",null,null,null,null,"Rebate Code Finder Enabled:","Yes",null,null,null,null,null,"Demand","Energy"]
[null,null,null,null,null,null,null,null,null,null,null,"Rate:",15.52,5.9799999999999999E-2]
[]
["OLD SYSTEM",null,null,"NEW SYSTEM",null,null,null,null,null,null,null,null,null,"REBATE"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
["Old Equipment Code*","Old Equipment Description","Qty.","New Equipment Code*","Match w/line item # from the Invoice ","New Equipment Description (Please submit cut sheet and invoice noting manufacturer and model #)","LED or CFL Bulb/Fixture Wattage\n(if applicable)","Qty.","Annual Hours of Operation *","Is This Space Air Conditioned?   (Select from dropdown menu)","Space Type (Select from dropdown menu)","Is Space Heated by Natural Gas?    (Select from dropdown menu)","Total Equipment Cost\n(not including labor)\n(Unit Cost x H)","Rebate Amount per Equipment*","Total Rebate Amount $\n(H x N) not to exceed (M)"]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A11,Code,0))),\"\",INDEX(Description,MATCH(A11,Code,0)))","v":""},null,null,1,{"$f":"IF(ISERROR(INDEX(Description,MATCH(D11,Code,0))),\"\",INDEX(Description,MATCH(D11,Code,0)))","v":""},null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O12<1,0,(IF((M11/H11/2)>P11,P11,M11/H11*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N12<0,\"No Savings\",IF(ISERROR(H11*N11),\"\",IF(H11*N11>M11,M11,H11*N11)))","v":""},{"$f":"IF(ISERROR(INDEX(Rebate,MATCH(D11,Code,0))),\"\",INDEX(Rebate,MATCH(D11,Code,0)))","v":""}]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A12,Code,0))),\"\",INDEX(Description,MATCH(A12,Code,0)))","v":""},null,null,2,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O13<1,0,(IF((M12/H12/2)>P12,P12,M12/H12*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N13<0,\"No Savings\",IF(ISERROR(H12*N12),\"\",IF(H12*N12>M12,M12,H12*N12)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A13,Code,0))),\"\",INDEX(Description,MATCH(A13,Code,0)))","v":""},null,null,3,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O14<1,0,(IF((M13/H13/2)>P13,P13,M13/H13*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N14<0,\"No Savings\",IF(ISERROR(H13*N13),\"\",IF(H13*N13>M13,M13,H13*N13)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A14,Code,0))),\"\",INDEX(Description,MATCH(A14,Code,0)))","v":""},null,null,4,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O15<1,0,(IF((M14/H14/2)>P14,P14,M14/H14*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N15<0,\"No Savings\",IF(ISERROR(H14*N14),\"\",IF(H14*N14>M14,M14,H14*N14)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A15,Code,0))),\"\",INDEX(Description,MATCH(A15,Code,0)))","v":""},null,null,5,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O16<1,0,(IF((M15/H15/2)>P15,P15,M15/H15*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N16<0,\"No Savings\",IF(ISERROR(H15*N15),\"\",IF(H15*N15>M15,M15,H15*N15)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A16,Code,0))),\"\",INDEX(Description,MATCH(A16,Code,0)))","v":""},null,null,6,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O17<1,0,(IF((M16/H16/2)>P16,P16,M16/H16*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N17<0,\"No Savings\",IF(ISERROR(H16*N16),\"\",IF(H16*N16>M16,M16,H16*N16)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A17,Code,0))),\"\",INDEX(Description,MATCH(A17,Code,0)))","v":""},null,null,7,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O18<1,0,(IF((M17/H17/2)>P17,P17,M17/H17*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N18<0,\"No Savings\",IF(ISERROR(H17*N17),\"\",IF(H17*N17>M17,M17,H17*N17)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A18,Code,0))),\"\",INDEX(Description,MATCH(A18,Code,0)))","v":""},null,null,8,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O19<1,0,(IF((M18/H18/2)>P18,P18,M18/H18*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N19<0,\"No Savings\",IF(ISERROR(H18*N18),\"\",IF(H18*N18>M18,M18,H18*N18)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A19,Code,0))),\"\",INDEX(Description,MATCH(A19,Code,0)))","v":""},null,null,9,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O20<1,0,(IF((M19/H19/2)>P19,P19,M19/H19*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N20<0,\"No Savings\",IF(ISERROR(H19*N19),\"\",IF(H19*N19>M19,M19,H19*N19)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A20,Code,0))),\"\",INDEX(Description,MATCH(A20,Code,0)))","v":""},null,null,10,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O21<1,0,(IF((M20/H20/2)>P20,P20,M20/H20*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N21<0,\"No Savings\",IF(ISERROR(H20*N20),\"\",IF(H20*N20>M20,M20,H20*N20)))","v":""},""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A21,Code,0))),\"\",INDEX(Description,MATCH(A21,Code,0)))","v":""},null,null,11,"",null,null,null,null,null,null,null,{"$f":"IF('Lighting Equipment Savings'!O22<1,0,(IF((M21/H21/2)>P21,P21,M21/H21*0.5)))","v":{"$error":"#DIV/0!"}},{"$f":"IF('Lighting Equipment Savings'!N22<0,\"No Savings\",IF(ISERROR(H21*N21),\"\",IF(H21*N21>M21,M21,H21*N21)))","v":""},""]
["*Enter equipment codes from the Rebate Table or use the Rebate Code Finder window to select.  Item description and rebate amount will be automatically entered based on the equipment code.",null,null,null,null,null,null,null,"LIGHTING EQUIPMENT SUBTOTAL",null,"REBATE IS LIMITED TO 50% OF NEW EQUIPMENT COST UP TO TABLE MAX",null,{"$f":"SUM(M11:M21)","v":0},{"$f":"SUM(O11:O21)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL LABOR/OTHER COST FOR ALL LIGHTING IMPROVEMENTS\nThis is the total labor & other cost (wire, misc, etc.) for installation of ALL equipment listed on pages 2, 3 and 4 - Lighting Equipment, LED in enclosed refrigerated cases, Occupancy Sensors, and Photocells"]
["Definitions:"]
["CFL – Compact Fluorescent Lamp ",null,"HPS – High Pressure Sodium",null,null,"RLO – Reduced Light Output"]
["HBF – High Ballast Factor",null,"LEC – Light Emitting Capacitor",null,null,"VHO – Very High Output"]
["HID – High Intensity Discharge",null,"LED – Light Emitting Diode"]
["HO – High Output ",null,"MH – Metal Halide"]
[]
["* Guidelines for Annual Hours of Operation if Actual Hours are Unknown:"]
["Building Type",null,"Hours",null,"Building Type",null,"Hours"]
["24-Hour Facility/Exits",null,8766,null,"Other/Miscellaneous",null,4576]
["Exterior Lighting",null,4383,null,"Restaurant",null,3673]
["Grocery/Supermarket",null,5802,null,"Retail",null,4719]
["Health",null,5095,null,"Safety or Code Required",null,8766]
["Hospital",null,6038,null,"School - College",null,3540,null,null,null,null,"Customer:",{"$f":"CustomerName","v":0}]
["Hotel/Motel",null,3044,null,"School - Elementary",null,2422,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2023-09-19"}]
["Manufacturing",null,5200,null,"School - Secondary",null,4311]
["Office",null,4439,null,"Warehouse",null,4746]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0},null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0},null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Result282\",ResultTable,2,0)","v":130}]

{"sheet":"Lighting Equipment Savings","index":3,"n_rows":98,"n_cols":256,"rows_kept":98,"cut":false,"hidden":false,"merged":[[8,0,8,3],[8,7,8,13],[0,0,0,15],[4,0,4,15],[5,1,5,7],[6,8,6,12],[6,1,6,5],[6,13,6,15],[8,14,8,15],[25,4,25,5],[25,14,25,15],[23,4,23,5],[23,11,23,12],[28,14,28,15],[27,14,27,15]]}
["ENERGY & COST SAVINGS"]
[null,null,"Demand","Energy",null,null,null,null,null,null,null,null,null,null,"Form Revision Date:","2014-02-13"]
[null,"Rate",{"$f":"Demand","v":15.52},{"$f":"Energy","v":5.9799999999999999E-2}]
[]
["LIGHTING EQUIPMENT:"]
[]
[null,"OLD SYSTEM",null,null,null,null,null,null,"NEW SYSTEM",null,null,null,null,"SAVINGS"]
[]
["OLD SYSTEM",null,null,null,null,null,null,"NEW SYSTEM",null,null,null,null,null,null,"REBATE  "]
["A"]
["Old Equipment Code*","Old Equipment Description","Old Equipment Fixture Watts","Qty.","Old Equipment kW","Old Equipment kWh","Annual Hours of Operation","New Equipment Code*","New Equipment Description*","New Equipment Fixture Watts","Qty.","New Equipment kW","New Equipment kWh","kW","kWh","$"]
[{"$f":"'2-Lighting Equipment Entry'!A11","v":0},{"$f":"'2-Lighting Equipment Entry'!B11","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH(A12,Code,0))),\"\",INDEX(Watts,MATCH(A12,Code,0)))","v":""},{"$f":"'2-Lighting Equipment Entry'!C11","v":0},{"$f":"IF(ISERROR(C12*D12/1000),\"\",C12*D12/1000)","v":""},{"$f":"IF(ISERROR(E12*G12),\"\",E12*G12)","v":""},{"$f":"'2-Lighting Equipment Entry'!I11","v":0},{"$f":"'2-Lighting Equipment Entry'!D11","v":0},{"$f":"'2-Lighting Equipment Entry'!F11","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H12,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G11,INDEX(Watts,MATCH(H12,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H12,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G11,INDEX(Watts,MATCH(H12,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H11","v":0},{"$f":"IF(ISERROR(J12*K12/1000),\"\",J12*K12/1000)","v":""},{"$f":"IF(ISERROR(L12*G12),\"\",L12*G12)","v":""},{"$f":"IF(ISERROR(E12-L12),\"\",E12-L12)","v":""},{"$f":"IF(ISERROR(F12-M12),\"\",F12-M12)","v":""},{"$f":"IF(ISERROR(12*N12*Demand+O12*Energy),\"\",12*N12*Demand+O12*Energy)","v":""}]
[{"$f":"'2-Lighting Equipment Entry'!A12","v":0},{"$f":"'2-Lighting Equipment Entry'!B12","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C12","v":0},{"$f":"IF(ISERROR(C13*D13/1000),\"\",C13*D13/1000)","v":""},"",{"$f":"'2-Lighting Equipment Entry'!I12","v":0},{"$f":"'2-Lighting Equipment Entry'!D12","v":0},{"$f":"'2-Lighting Equipment Entry'!F12","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H13,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G12,INDEX(Watts,MATCH(H13,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H13,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G12,INDEX(Watts,MATCH(H13,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H12","v":0},{"$f":"IF(ISERROR(J13*K13/1000),\"\",J13*K13/1000)","v":""},{"$f":"IF(ISERROR(L13*G13),\"\",L13*G13)","v":""},{"$f":"IF(ISERROR(E13-L13),\"\",E13-L13)","v":""},{"$f":"IF(ISERROR(F13-M13),\"\",F13-M13)","v":""},""]
[{"$f":"'2-Lighting Equipment Entry'!A13","v":0},{"$f":"'2-Lighting Equipment Entry'!B13","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C13","v":0},{"$f":"IF(ISERROR(C14*D14/1000),\"\",C14*D14/1000)","v":""},"",{"$f":"'2-Lighting Equipment Entry'!I13","v":0},{"$f":"'2-Lighting Equipment Entry'!D13","v":0},{"$f":"'2-Lighting Equipment Entry'!F13","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H14,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G13,INDEX(Watts,MATCH(H14,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H14,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G13,INDEX(Watts,MATCH(H14,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H13","v":0},"","","",{"$f":"IF(ISERROR(F14-M14),\"\",F14-M14)","v":""},""]
[{"$f":"'2-Lighting Equipment Entry'!A14","v":0},{"$f":"'2-Lighting Equipment Entry'!B14","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C14","v":0},{"$f":"IF(ISERROR(C15*D15/1000),\"\",C15*D15/1000)","v":""},"",{"$f":"'2-Lighting Equipment Entry'!I14","v":0},{"$f":"'2-Lighting Equipment Entry'!D14","v":0},{"$f":"'2-Lighting Equipment Entry'!F14","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H15,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G14,INDEX(Watts,MATCH(H15,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H15,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G14,INDEX(Watts,MATCH(H15,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H14","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A15","v":0},{"$f":"'2-Lighting Equipment Entry'!B15","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C15","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I15","v":0},{"$f":"'2-Lighting Equipment Entry'!D15","v":0},{"$f":"'2-Lighting Equipment Entry'!F15","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H16,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G15,INDEX(Watts,MATCH(H16,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H16,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G15,INDEX(Watts,MATCH(H16,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H15","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A16","v":0},{"$f":"'2-Lighting Equipment Entry'!B16","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C16","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I16","v":0},{"$f":"'2-Lighting Equipment Entry'!D16","v":0},{"$f":"'2-Lighting Equipment Entry'!F16","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H17,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G16,INDEX(Watts,MATCH(H17,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H17,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G16,INDEX(Watts,MATCH(H17,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H16","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A17","v":0},{"$f":"'2-Lighting Equipment Entry'!B17","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C17","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I17","v":0},{"$f":"'2-Lighting Equipment Entry'!D17","v":0},{"$f":"'2-Lighting Equipment Entry'!F17","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H18,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G17,INDEX(Watts,MATCH(H18,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H18,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G17,INDEX(Watts,MATCH(H18,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H17","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A18","v":0},{"$f":"'2-Lighting Equipment Entry'!B18","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C18","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I18","v":0},{"$f":"'2-Lighting Equipment Entry'!D18","v":0},{"$f":"'2-Lighting Equipment Entry'!F18","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H19,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G18,INDEX(Watts,MATCH(H19,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H19,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G18,INDEX(Watts,MATCH(H19,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H18","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A19","v":0},{"$f":"'2-Lighting Equipment Entry'!B19","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C19","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I19","v":0},{"$f":"'2-Lighting Equipment Entry'!D19","v":0},{"$f":"'2-Lighting Equipment Entry'!F19","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H20,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G19,INDEX(Watts,MATCH(H20,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H20,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G19,INDEX(Watts,MATCH(H20,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H19","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A20","v":0},{"$f":"'2-Lighting Equipment Entry'!B20","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C20","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I20","v":0},{"$f":"'2-Lighting Equipment Entry'!D20","v":0},{"$f":"'2-Lighting Equipment Entry'!F20","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H21,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G20,INDEX(Watts,MATCH(H21,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H21,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G20,INDEX(Watts,MATCH(H21,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H20","v":0},"","","","",""]
[{"$f":"'2-Lighting Equipment Entry'!A21","v":0},{"$f":"'2-Lighting Equipment Entry'!B21","v":""},"",{"$f":"'2-Lighting Equipment Entry'!C21","v":0},"","",{"$f":"'2-Lighting Equipment Entry'!I21","v":0},{"$f":"'2-Lighting Equipment Entry'!D21","v":0},{"$f":"'2-Lighting Equipment Entry'!F21","v":""},{"$f":"IF(ISERROR(IF(INDEX(Watts,MATCH(H22,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G21,INDEX(Watts,MATCH(H22,Code,0)))),\"\",(IF(INDEX(Watts,MATCH(H22,Code,0))=\"N/A\",'2-Lighting Equipment Entry'!G21,INDEX(Watts,MATCH(H22,Code,0)))))","v":""},{"$f":"'2-Lighting Equipment Entry'!H21","v":0},"","","","",""]
[null,null,null,"TOTAL DEMAND AND ENERGY ",{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},null,null,null,null,"TOTAL DEMAND AND ENERGY",{"$f":"SUM(L12:L22)","v":0},{"$f":"SUM(M12:M22)","v":0},{"$f":"SUM(N12:N22)","v":0},{"$f":"SUM(O12:O22)","v":0}]
[null,null,null,"ANNUAL ENERGY COST - OLD SYSTEM",{"$f":"E23*12*Demand+F23*Energy","v":0},null,null,null,null,null,"ANNUAL ENERGY COST - NEW SYSTEM",{"$f":"L23*12*Demand+M23*Energy","v":0}]
[null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGHTING EQUIPMENT ANNUAL SAVINGS",{"$f":"E24-L24","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer:",{"$f":"CustomerName","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2023-09-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]

{"sheet":"LED in Ref. Cases Entry","index":4,"n_rows":99,"n_cols":256,"rows_kept":99,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,2,11],[5,1,5,3],[7,0,7,2],[7,10,7,11],[7,3,7,4],[7,5,7,9],[9,0,9,1],[8,0,8,1],[21,0,21,1],[22,0,22,1],[27,10,27,11],[26,10,26,11],[18,0,18,4],[18,10,18,11],[19,0,19,9],[20,8,24,9],[20,10,24,11]]}
["REBATE INFORMATION "]
[null,null,null,null,null,null,null,null,null,"Form Revision Date:","2014-02-13"]
["LIGHTING EQUIPMENT:"]
[]
["Project Type:",null,null,null,null,"Rebate Code Finder Enabled:","Yes"]
[]
[]
["CASE INFORMATION",null,null,"EXISTING LIGHTING",null,"LED LIGHTING",null,null,null,null,"REBATE"]
["A",null,"B","C","D","E","F","G","H","I","J","K"]
["Case Manufacturer/Description           (ex. \"Zero Zone - pizza case #1\")",null,"Case Door Quantity (converted to LED)","Code                (from Lighting Tables)*","Qty.","Code                (from Lighting Tables)*","LED Wattage per strip (watts)","Qty.","Annual Hours of Operation#","Total Equipment Cost\n(excluding labor)\n(Unit Cost x G)","Rebate Amount per Equipment*","Total Rebate Amount $\n(B x J)"]
[1,{"$f":"IF(ISERROR(INDEX(Description,MATCH(F11,Code,0))),\"\",INDEX(Description,MATCH(F11,Code,0)))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Rebate,MATCH(F11,Code,0))),\"\",INDEX(Rebate,MATCH(F11,Code,0)))","v":""},{"$f":"IF('LED in Ref. Cases Savings'!P11<0,\"No Savings\",IF(ISERROR(C11*K11),\"\",IF(C11*K11>J11,J11,C11*K11)))","v":""}]
[2,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P12<0,\"No Savings\",IF(ISERROR(C12*K12),\"\",IF(C12*K12>J12,J12,C12*K12)))","v":""}]
[3,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P13<0,\"No Savings\",IF(ISERROR(C13*K13),\"\",IF(C13*K13>J13,J13,C13*K13)))","v":""}]
[4,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P14<0,\"No Savings\",IF(ISERROR(C14*K14),\"\",IF(C14*K14>J14,J14,C14*K14)))","v":""}]
[5,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P15<0,\"No Savings\",IF(ISERROR(C15*K15),\"\",IF(C15*K15>J15,J15,C15*K15)))","v":""}]
[6,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P16<0,\"No Savings\",IF(ISERROR(C16*K16),\"\",IF(C16*K16>J16,J16,C16*K16)))","v":""}]
[7,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P17<0,\"No Savings\",IF(ISERROR(C17*K17),\"\",IF(C17*K17>J17,J17,C17*K17)))","v":""}]
[8,"",null,null,null,null,null,null,null,null,"",{"$f":"IF('LED in Ref. Cases Savings'!P18<0,\"No Savings\",IF(ISERROR(C18*K18),\"\",IF(C18*K18>J18,J18,C18*K18)))","v":""}]
["*Enter equipment codes from rebate table or use the Rebate Code Finder window to select.  Rebate amount will be automatically entered based on the equipment code.",null,null,null,null,null,null,"LED LIGHTING IN ENCLOSED REFRIGERATED DISPLAY CASES SUBTOTAL",null,null,{"$f":"SUM(L11:L18)","v":0}]
[]
["#Guidelines for Annual Hours of Operation if Actual Hours are Unknown.",null,null,null,null,null,null,null,"TOTAL LABOR/OTHER COST FOR ALL LIGHTING IMPROVEMENTS\nThis is the total labor & other cost (wire, misc, etc.) for installation of ALL equipment listed on pages 2, 3 and 4 - Lighting Equipment, LED in enclosed refrigerated cases, Occupancy Sensors, and Photocells",null,{"$f":"'2-Lighting Equipment Entry'!M24","v":0}]
["Building Type",null,"Hours"]
["Food Service",null,6205]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Customer:",{"$f":"CustomerName","v":0}]
[null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2023-09-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Result487\",ResultTable,2,0)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Result282\",ResultTable,2,0)","v":130}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]

{"sheet":"LED in Ref. Cases Savings","index":5,"n_rows":89,"n_cols":256,"rows_kept":89,"cut":false,"hidden":false,"merged":[[24,14,24,16],[19,4,19,5],[19,10,19,11],[21,4,21,5],[21,15,21,16],[21,9,21,14],[23,14,23,16],[1,10,1,12],[0,0,0,16],[6,0,6,16],[9,0,9,1],[8,7,8,11],[8,0,8,5],[8,12,8,16]]}
["ENERGY COSTS & SAVINGS"]
[null,null,"Demand","Energy",null,null,null,null,null,null,"Form Revision Date:",null,null,null,"2014-02-13"]
[null,"Rate",{"$f":"Demand","v":15.52},{"$f":"Energy","v":5.9799999999999999E-2}]
[]
[]
[]
["LIGHTING EQUIPMENT:"]
[]
["EXISTING LIGHTING",null,null,null,null,null,null,"LED LIGHTING",null,null,null,null,"SAVINGS"]
["Old Equipment Description",null,"Old Equipment Fixture Watts","Qty","Old Equipment kW","Old Equipment kWh","Annual Hours of Operation","Case Manufacturer/Description           (ex. \"Zero Zone - pizza case #1\")","LED Wattage Per Strip","Qty","New Equipment kW","New Equipment kWh","Lighting kW","Lighting kWh","kW","kWh","$"]
[1,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D11,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D11,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D11,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D11,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E11","v":0},{"$f":"IF(ISERROR(C11*D11/1000),\"\",C11*D11/1000)","v":""},{"$f":"IF(ISERROR(E11*G11),\"\",E11*G11)","v":""},{"$f":"'LED in Ref. Cases Entry'!I11","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F11,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F11,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G11","v":0},{"$f":"'LED in Ref. Cases Entry'!H11","v":0},{"$f":"IF(ISERROR(I11*J11/1000),\"\",I11*J11/1000)","v":0},{"$f":"IF(ISERROR(K11*G11),\"\",K11*G11)","v":0},{"$f":"(IF(ISERROR(E11-K11),\"\",E11-K11))","v":""},{"$f":"IF(ISERROR(F11-L11),\"\",F11-L11)","v":""},{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F11=1508,'LED in Ref. Cases Entry'!F11=1509),(M11)+((M11)*(0.79)/2.5),(M11)+((M11)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F11=1508,'LED in Ref. Cases Entry'!F11=1509),(M11)+((M11)*(0.79)/2.5),(M11)+((M11)*(0.79)/1.3)))","v":""},{"$f":"IF(ISERROR(O11*G11), \"\", (O11*G11))","v":""},{"$f":"IF(ISERROR(12*O11*Demand+P11*Energy),\"\",12*O11*Demand+P11*Energy)","v":""}]
[2,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D12,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D12,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D12,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D12,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E12","v":0},{"$f":"IF(ISERROR(C12*D12/1000),\"\",C12*D12/1000)","v":""},{"$f":"IF(ISERROR(E12*G12),\"\",E12*G12)","v":""},{"$f":"'LED in Ref. Cases Entry'!I12","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F12,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F12,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G12","v":0},{"$f":"'LED in Ref. Cases Entry'!H12","v":0},{"$f":"IF(ISERROR(I12*J12/1000),\"\",I12*J12/1000)","v":0},{"$f":"IF(ISERROR(K12*G12),\"\",K12*G12)","v":0},{"$f":"IF(ISERROR(E12-K12),\"\",E12-K12)","v":""},{"$f":"IF(ISERROR(F12-L12),\"\",F12-L12)","v":""},{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F12=1508,'LED in Ref. Cases Entry'!F12=1509),(M12)+((M12)*(0.79)/2.5),(M12)+((M12)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F12=1508,'LED in Ref. Cases Entry'!F12=1509),(M12)+((M12)*(0.79)/2.5),(M12)+((M12)*(0.79)/1.3)))","v":""},{"$f":"IF(ISERROR(O12*G12), \"\", (O12*G12))","v":""},""]
[3,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D13,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D13,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D13,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D13,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E13","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I13","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F13,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F13,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G13","v":0},{"$f":"'LED in Ref. Cases Entry'!H13","v":0},0,0,{"$f":"IF(ISERROR(E13-K13),\"\",E13-K13)","v":""},"",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F13=1508,'LED in Ref. Cases Entry'!F13=1509),(M13)+((M13)*(0.79)/2.5),(M13)+((M13)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F13=1508,'LED in Ref. Cases Entry'!F13=1509),(M13)+((M13)*(0.79)/2.5),(M13)+((M13)*(0.79)/1.3)))","v":""},"",""]
[4,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D14,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D14,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D14,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D14,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E14","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I14","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F14,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F14,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G14","v":0},{"$f":"'LED in Ref. Cases Entry'!H14","v":0},0,0,"","",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F14=1508,'LED in Ref. Cases Entry'!F14=1509),(M14)+((M14)*(0.79)/2.5),(M14)+((M14)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F14=1508,'LED in Ref. Cases Entry'!F14=1509),(M14)+((M14)*(0.79)/2.5),(M14)+((M14)*(0.79)/1.3)))","v":""},"",""]
[5,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D15,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D15,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D15,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D15,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E15","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I15","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F15,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F15,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G15","v":0},{"$f":"'LED in Ref. Cases Entry'!H15","v":0},0,0,"","",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F15=1508,'LED in Ref. Cases Entry'!F15=1509),(M15)+((M15)*(0.79)/2.5),(M15)+((M15)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F15=1508,'LED in Ref. Cases Entry'!F15=1509),(M15)+((M15)*(0.79)/2.5),(M15)+((M15)*(0.79)/1.3)))","v":""},"",""]
[6,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D16,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D16,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D16,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D16,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E16","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I16","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F16,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F16,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G16","v":0},{"$f":"'LED in Ref. Cases Entry'!H16","v":0},0,0,"","",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F16=1508,'LED in Ref. Cases Entry'!F16=1509),(M16)+((M16)*(0.79)/2.5),(M16)+((M16)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F16=1508,'LED in Ref. Cases Entry'!F16=1509),(M16)+((M16)*(0.79)/2.5),(M16)+((M16)*(0.79)/1.3)))","v":""},"",""]
[7,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D17,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D17,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D17,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D17,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E17","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I17","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F17,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F17,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G17","v":0},{"$f":"'LED in Ref. Cases Entry'!H17","v":0},0,0,"","",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F17=1508,'LED in Ref. Cases Entry'!F17=1509),(M17)+((M17)*(0.79)/2.5),(M17)+((M17)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F17=1508,'LED in Ref. Cases Entry'!F17=1509),(M17)+((M17)*(0.79)/2.5),(M17)+((M17)*(0.79)/1.3)))","v":""},"",""]
[8,{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!D18,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!D18,Code,0)))","v":""},{"$f":"IF(ISERROR(INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D18,Code,0))),\"\",INDEX(Watts,MATCH('LED in Ref. Cases Entry'!D18,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!E18","v":0},"","",{"$f":"'LED in Ref. Cases Entry'!I18","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH('LED in Ref. Cases Entry'!F18,Code,0))),\"\",INDEX(Description,MATCH('LED in Ref. Cases Entry'!F18,Code,0)))","v":""},{"$f":"'LED in Ref. Cases Entry'!G18","v":0},{"$f":"'LED in Ref. Cases Entry'!H18","v":0},0,0,"","",{"$f":"IF(ISERROR(IF(OR('LED in Ref. Cases Entry'!F18=1508,'LED in Ref. Cases Entry'!F18=1509),(M18)+((M18)*(0.79)/2.5),(M18)+((M18)*(0.79)/1.3))), \"\", IF(OR('LED in Ref. Cases Entry'!F18=1508,'LED in Ref. Cases Entry'!F18=1509),(M18)+((M18)*(0.79)/2.5),(M18)+((M18)*(0.79)/1.3)))","v":""},"",""]
[null,null,null,"TOTAL DEMAND AND ENERGY ",{"$f":"SUM(E11:E18)","v":0},{"$f":"SUM(F11:F18)","v":0},null,null,null,"TOTAL DEMAND AND ENERGY",{"$f":"SUM(K11:K18)","v":0},{"$f":"SUM(L11:L18)","v":0},null,null,{"$f":"SUM(O11:O18)","v":0},{"$f":"SUM(P11:P18)","v":0}]
[null,null,null,"ANNUAL ENERGY COST - OLD SYSTEM",{"$f":"E19*12*Demand+F19*Energy","v":0},null,null,null,null,"ANNUAL ENERGY COST - NEW SYSTEM",{"$f":"K19*12*Demand+L19*Energy","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"LIGHTING EQUIPMENT ANNUAL SAVINGS",null,null,null,null,null,{"$f":"E20-K20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer:",{"$f":"CustomerName","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2023-09-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Result487\",ResultTable,2,0)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Result282\",ResultTable,2,0)","v":130}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]

{"sheet":"Occup. Sensors-Photocells Entry","index":6,"n_rows":101,"n_cols":256,"rows_kept":101,"cut":false,"hidden":false,"merged":[[2,0,2,13],[0,0,0,13],[25,7,29,11],[23,0,23,5],[7,0,7,5],[28,0,28,1],[27,0,27,1],[26,0,26,1],[25,0,25,1],[25,2,25,3],[23,7,23,11],[32,12,32,13],[31,12,31,13],[24,0,24,5],[7,6,7,10],[7,11,7,13],[22,12,22,13],[23,12,23,13],[25,12,29,13],[30,0,30,1],[29,0,29,1],[30,2,30,3],[22,7,22,10],[29,2,29,3],[28,2,28,3],[27,2,27,3],[26,2,26,3]]}
["REBATE INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2-Lighting Equipment Entry'!L2","v":0},"2017-05-25"]
["OCCUPANCY SENSORS/PHOTOCELLS:"]
["Project Type:"]
[null,null,null,null,null,"Rebate Code Finder Enabled:","Yes"]
[null,null,null,null,null,"Is equipment to be controlled new equipment included in the Lighting Equipment Entry sheet?","Yes"]
[]
["CONTROLLED EQUIPMENT",null,null,null,null,null,"OCCUPANCY SENSORS/PHOTOCELLS",null,null,null,null,"REBATE  "]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N"]
["Equipment Code*","Controlled Equipment Description","Average Wattage (total wattage/ # fixtures)","Low-Wattage Fluorescent Lamps?             (if applicable)","Qty. Controlled by Sensors/ Photocells","Annual Hours of Operation","Equipment Code","Sensor/Photocell Description","Qty.","Is This Space Air Conditioned?","% of Time Lights Off**","Total Cost of Sensors/ Photocells","Rebate Amount per Sensor /Photocell","Total Rebate Amount\n( I x M )"]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A11,Code,0))),\"\",INDEX(Description,MATCH(A11,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G11,Code,0))),\"\",INDEX(Description,MATCH(G11,Code,0)))","v":""},null,null,null,null,{"$f":"IF(ISERROR(INDEX(Rebate,MATCH(G11,Code,0))),\"\",INDEX(Rebate,MATCH(G11,Code,0)))","v":""},{"$f":"IF(ISERROR(I11*M11),\"\",IF(I11*M11>L11,L11,I11*M11))","v":""}]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A12,Code,0))),\"\",INDEX(Description,MATCH(A12,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G12,Code,0))),\"\",INDEX(Description,MATCH(G12,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A13,Code,0))),\"\",INDEX(Description,MATCH(A13,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G13,Code,0))),\"\",INDEX(Description,MATCH(G13,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A14,Code,0))),\"\",INDEX(Description,MATCH(A14,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G14,Code,0))),\"\",INDEX(Description,MATCH(G14,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A15,Code,0))),\"\",INDEX(Description,MATCH(A15,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G15,Code,0))),\"\",INDEX(Description,MATCH(G15,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A16,Code,0))),\"\",INDEX(Description,MATCH(A16,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G16,Code,0))),\"\",INDEX(Description,MATCH(G16,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A17,Code,0))),\"\",INDEX(Description,MATCH(A17,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G17,Code,0))),\"\",INDEX(Description,MATCH(G17,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A18,Code,0))),\"\",INDEX(Description,MATCH(A18,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G18,Code,0))),\"\",INDEX(Description,MATCH(G18,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A19,Code,0))),\"\",INDEX(Description,MATCH(A19,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G19,Code,0))),\"\",INDEX(Description,MATCH(G19,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A20,Code,0))),\"\",INDEX(Description,MATCH(A20,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G20,Code,0))),\"\",INDEX(Description,MATCH(G20,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A21,Code,0))),\"\",INDEX(Description,MATCH(A21,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G21,Code,0))),\"\",INDEX(Description,MATCH(G21,Code,0)))","v":""},null,null,null,null,"",""]
[null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(A22,Code,0))),\"\",INDEX(Description,MATCH(A22,Code,0)))","v":""},null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(Description,MATCH(G22,Code,0))),\"\",INDEX(Description,MATCH(G22,Code,0)))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,"OCCUPANCY SENSORS/PHOTOCELLS SUBTOTAL",null,null,null,{"$f":"SUM(L11:L22)","v":0},{"$f":"SUM(N11:N22)","v":0}]
["*Enter equipment codes from rebate table or use the Rebate Code Finder window to select.  Rebate amount will be automatically entered based on the equipment code.",null,null,null,null,null,null,"TOTAL REBATE AMOUNT:                                                                                                      (LIGHTING EQUIPMENT SUBTOTAL + LED IN ENCLOSED REFRIGERATED CASES SUBTOTAL + OCCUPANCY SENSORS/PHOTOCELLS SUBTOTAL)",null,null,null,null,{"$f":"OccSensorRebateTotal+'2-Lighting Equipment Entry'!N22+'LED in Ref. Cases Entry'!K19","v":0}]
["**Guidelines for % of Time Lights Are Off:"]
["Sensor Type",null,"% of Time Lights Are Off",null,null,null,null,"TOTAL LABOR COST FOR ALL LIGHTING IMPROVEMENTS\n(This is the total labor cost for installation of ALL equipment listed on pages 2, 3 and 4 - Lighting Equipment, LED in enclosed refrigerated cases Occupancy Sensors, and Photocells)",null,null,null,null,{"$f":"LightingEquipmentEntryLabor","v":0}]
["Occupancy Sensor - Wall Mount",null,0.3]
["Occupancy Sensor - Ceiling Mount",null,0.3]
["Photocell - Continuous Dimming",null,0.43]
["Photocell - Multiple Step Dimming",null,0.35]
["Photocell - On/Off",null,0.27]
[null,null,null,null,null,null,null,null,null,null,null,"Customer:",{"$f":"CustomerName","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2023-09-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]

{"sheet":"Occup. Snsrs-Photocells Savings","index":7,"n_rows":101,"n_cols":254,"rows_kept":101,"cut":false,"hidden":false,"merged":[[24,14,24,15],[25,14,25,15],[0,0,0,15],[6,0,6,3],[4,0,4,15],[6,14,6,15],[6,4,6,7]]}
["ENERGY & COST SAVINGS"]
[null,"Demand","Energy"]
["Rate",{"$f":"Demand","v":15.52},{"$f":"Energy","v":5.9799999999999999E-2}]
[]
["OCCUPANCY SENSORS/PHOTOCELLS:"]
[]
["CONTROLLED EQUIPMENT",null,null,null,"OCCUPANCY SENSORS/PHOTOCELLS",null,null,null,null,null,null,null,null,null,"SAVINGS"]
["A","B","C","D","E","F","G","H",null,null,null,null,null,null,"I","J"]
["Equipment Code*","Controlled Equipment Description","Qty. Controlled by Sensors/ Photocells","Annual Hours of Operation","Equipment Code","Sensor/Photocell Description","Qty.","% of Time Lights Off","Equipment Watts (Hidden)","Existing KW\n(Hidden)","Existing kWh\n(Hidden)","Existing $\n(Hidden)","New kWh\n(Hidden)","New $\n(Hidden)","kWh","$"]
[{"$f":"'Occup. Sensors-Photocells Entry'!A11","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A10,Code,0))),\"\",INDEX(Description,MATCH(A10,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E11","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F11","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G11","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E10,Code,0))),\"\",INDEX(Description,MATCH(E10,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I11","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K11","v":0},{"$f":"IF(INDEX(Watts,MATCH(A10,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C11,INDEX(Watts,MATCH(A10,Code,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(C10*I10/1000),\"\",C10*I10/1000)","v":""},{"$f":"IF(ISERROR(C10*I10*D10/1000),\"\",C10*I10*D10/1000)","v":""},{"$f":"IF(ISERROR(K10*Energy),\"\",K10*Energy)","v":""},{"$f":"IF(ISERROR((1-H10)*K10),\"\",(1-H10)*K10)","v":""},{"$f":"IF(ISERROR(M10*Energy),\"\",M10*Energy)","v":""},{"$f":"IF(ISERROR(C10*D10*I10/1000*H10),\"\",C10*D10*I10/1000*H10)","v":""},{"$f":"IF(ISERROR(O10*Energy),\"\",O10*Energy)","v":""}]
[{"$f":"'Occup. Sensors-Photocells Entry'!A12","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A11,Code,0))),\"\",INDEX(Description,MATCH(A11,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E12","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F12","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G12","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E11,Code,0))),\"\",INDEX(Description,MATCH(E11,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I12","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K12","v":0},{"$f":"IF(INDEX(Watts,MATCH(A11,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C12,INDEX(Watts,MATCH(A11,Code,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(C11*I11/1000),\"\",C11*I11/1000)","v":""},{"$f":"IF(ISERROR(C11*I11*D11/1000),\"\",C11*I11*D11/1000)","v":""},"",{"$f":"IF(ISERROR((1-H11)*K11),\"\",(1-H11)*K11)","v":""},"",{"$f":"IF(ISERROR(C11*D11*I11/1000*H11),\"\",C11*D11*I11/1000*H11)","v":""},""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A13","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A12,Code,0))),\"\",INDEX(Description,MATCH(A12,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E13","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F13","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G13","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E12,Code,0))),\"\",INDEX(Description,MATCH(E12,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I13","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K13","v":0},{"$f":"IF(INDEX(Watts,MATCH(A12,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C13,INDEX(Watts,MATCH(A12,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A14","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A13,Code,0))),\"\",INDEX(Description,MATCH(A13,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E14","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F14","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G14","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E13,Code,0))),\"\",INDEX(Description,MATCH(E13,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I14","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K14","v":0},{"$f":"IF(INDEX(Watts,MATCH(A13,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C14,INDEX(Watts,MATCH(A13,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A15","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A14,Code,0))),\"\",INDEX(Description,MATCH(A14,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E15","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F15","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G15","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E14,Code,0))),\"\",INDEX(Description,MATCH(E14,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I15","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K15","v":0},{"$f":"IF(INDEX(Watts,MATCH(A14,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C15,INDEX(Watts,MATCH(A14,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A16","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A15,Code,0))),\"\",INDEX(Description,MATCH(A15,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E16","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F16","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G16","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E15,Code,0))),\"\",INDEX(Description,MATCH(E15,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I16","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K16","v":0},{"$f":"IF(INDEX(Watts,MATCH(A15,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C16,INDEX(Watts,MATCH(A15,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A17","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A16,Code,0))),\"\",INDEX(Description,MATCH(A16,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E17","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F17","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G17","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E16,Code,0))),\"\",INDEX(Description,MATCH(E16,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I17","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K17","v":0},{"$f":"IF(INDEX(Watts,MATCH(A16,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C17,INDEX(Watts,MATCH(A16,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A18","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A17,Code,0))),\"\",INDEX(Description,MATCH(A17,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E18","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F18","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G18","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E17,Code,0))),\"\",INDEX(Description,MATCH(E17,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I18","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K18","v":0},{"$f":"IF(INDEX(Watts,MATCH(A17,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C18,INDEX(Watts,MATCH(A17,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A19","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A18,Code,0))),\"\",INDEX(Description,MATCH(A18,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E19","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F19","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G19","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E18,Code,0))),\"\",INDEX(Description,MATCH(E18,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I19","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K19","v":0},{"$f":"IF(INDEX(Watts,MATCH(A18,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C19,INDEX(Watts,MATCH(A18,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A20","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A19,Code,0))),\"\",INDEX(Description,MATCH(A19,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E20","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F20","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G20","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E19,Code,0))),\"\",INDEX(Description,MATCH(E19,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I20","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K20","v":0},{"$f":"IF(INDEX(Watts,MATCH(A19,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C20,INDEX(Watts,MATCH(A19,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A21","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A20,Code,0))),\"\",INDEX(Description,MATCH(A20,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E21","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F21","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G21","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E20,Code,0))),\"\",INDEX(Description,MATCH(E20,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I21","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K21","v":0},{"$f":"IF(INDEX(Watts,MATCH(A20,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C21,INDEX(Watts,MATCH(A20,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[{"$f":"'Occup. Sensors-Photocells Entry'!A22","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(A21,Code,0))),\"\",INDEX(Description,MATCH(A21,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!E22","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!F22","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!G22","v":0},{"$f":"IF(ISERROR(INDEX(Description,MATCH(E21,Code,0))),\"\",INDEX(Description,MATCH(E21,Code,0)))","v":""},{"$f":"'Occup. Sensors-Photocells Entry'!I22","v":0},{"$f":"'Occup. Sensors-Photocells Entry'!K22","v":0},{"$f":"IF(INDEX(Watts,MATCH(A21,Code,0))=\"N/A\",'Occup. Sensors-Photocells Entry'!C22,INDEX(Watts,MATCH(A21,Code,0)))","v":{"$error":"#N/A"}},"","","","","","",""]
[null,null,null,null,null,null,null,null,"Totals (Hidden)",{"$f":"SUM(J10:J21)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCCUPANCY SENSOR/PHOTOCELLS ANNUAL SAVINGS",{"$f":"SUM(P10:P21)","v":0}]
[]
[null,null,null,null,null,null,null,"Customer:",null,null,null,null,null,null,{"$f":"CustomerName","v":0}]
[null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-09-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Node1\",QuestionTable,6,0)","v":0}]

{"sheet":"Financial Summary","index":8,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,1,36,8],[3,3,3,4],[5,3,5,4],[7,1,7,8],[27,1,27,8]]}
[]
[]
[]
[null,null,null,{"$f":"CustomerName","v":0}]
[]
[null,null,null,{"$f":"CustomerInstallAddress","v":0}]
[]
[null,"ENERGY SAVINGS SUMMARY:"]
[null,null,null,"Current System","Proposed System","Savings"]
[null,null,"Annual Energy Cost",{"$f":"IF(Included=\"No\",OldLightingEnergyCost+OldSensorEnergyCost+OldLEDLightingEnergyCost,OldLightingEnergyCost+OldLEDLightingEnergyCost)","v":0},{"$f":"IF(Included=\"No\",NewLightingEnergyCost+NewSensorEnergyCost+NewLEDLightingCost,NewLightingEnergyCost+NewLEDLightingCost)","v":0},{"$f":"D10-E10","v":0}]
[null,null,"Annual  kW",{"$f":"IF(Included=\"No\",OldLightingKW+OldSensorKW+OldLEDLightingKW,OldLightingKW+OldLEDLightingKW)","v":0},{"$f":"IF(Included=\"No\",NewLightingKW+OldSensorKW+NewLEDLightingKW,NewLightingKW+NewLEDLightingKW)","v":0},{"$f":"D11-E11","v":0}]
[null,null,"Annual kWh",{"$f":"IF(Included=\"No\",OldLightingKWH+OldSensorKWH+OldLEDLightingKWH,OldLightingKWH+OldLEDLightingKWH)","v":0},{"$f":"IF(Included=\"No\",NewLightingKWH+NewSensorKWH+NewLEDLightingKWH,NewLightingKWH-SensorKWHSavings+NewLEDLightingKWH)","v":0},{"$f":"D12-E12","v":0}]
[]
[null,null,null,null,0,{"$f":"-F32","v":0}]
[null,null,null,{"$f":"F15","v":0},"Year 1",{"$f":"F10","v":0}]
[null,null,null,{"$f":"D15+F16","v":0},"Year 2",{"$f":"F15","v":0}]
[null,null,null,{"$f":"D16+F17","v":0},"Year 3",0]
[null,null,null,{"$f":"D17+F18","v":0},"Year 4",0]
[null,null,null,{"$f":"D18+F19","v":0},"Year 5",0]
[null,null,null,null,6,0]
[null,null,null,null,7,0]
[null,null,null,null,8,0]
[null,null,null,null,9,0]
[null,null,null,null,10,0]
[]
[]
[]
[null,"INVESTMENT SUMMARY:"]
[]
[null,null,"Investment",null,null,{"$f":"LightingEquipSubTotal+LightingLabor+SensorSubTotal","v":0}]
[null,null,"Utility Rebate",null,null,{"$f":"-TotalRebate","v":0}]
[null,null,"Net Investment",null,null,{"$f":"F30+F31","v":0}]
[null,null,"Simple Payback (years)",null,null,{"$f":"IF(ISERROR(F32/F10),\"\",F32/F10)","v":""}]
[null,null,"Return on Investment (IRR at 10 Years)",null,null,{"$f":"IF(ISERROR(IRR(F14:F24)),\"\",IRR(F14:F24))","v":""}]
[]
[]
[null,"ENVIRONMENTAL IMPACT:"]
[]
[null,null,null,"The project is estimated to reduce the emission of",{"$f":"F12*1.55","v":0},"pounds of CO2 annually. "]
[]
[null,"This is equivalent to:"]
[null,null,{"$f":"E39*0.05","v":0},"gallons of gasoline not burned"]
[null,null,{"$f":"C42/522","v":0},"passenger cars removed from the roads for one year"]
[null,null,{"$f":"E39/269433","v":0},"acres of trees planted"]
[]
[]
[]
[null,"Prepared by:",{"$f":"ContractorContact","v":0},null,null,null,"Demand","Energy"]
[null,null,{"$f":"ContractorName","v":0},null,null,null,"($/kW)","($/kWh)"]
[null,null,{"$f":"ContractorAddress","v":0},null,null,"* Current Energy Prices:",{"$f":"Demand","v":15.52},{"$f":"Energy","v":5.9799999999999999E-2}]
[null,null,{"$f":"ContractorCity&\", \"&ContractorState&\"  \"&ContractorZip","v":",   "}]
[null,null,{"$f":"ContractorPhone","v":0},null,null,"Summary Printed:",{"$f":"TODAY()","v":"2023-09-19"}]
[null,null,{"$f":"ContractorEmail","v":0}]

{"sheet":"Terms and Conditions","index":9,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,2,3],[3,0,3,2]]}
["SECTION G.  TERMS AND CONDITIONS"]
["1.   ELIGIBILITY\nRebates are available to non-residential electric customers of Austin Utilities, Owatonna Public Utilities, and Rochester Public Utilities (herein referred to as The Utility). All products must be in use in facilities in The Utility service territory. Rebates are for installed equipment only. For lighting retrofit systems to be eligible, they must show a net reduction in kWh usage from that of the existing lighting system.\n2.   APPLICATION\nProgram is offered January 1 through December 31 of the respective calendar year. Due  to  limited  funding,  this  rebate  offer  can  be  changed  or withdrawn at any time without notice and is available on a first-come, first-served basis. The entire rebate application must be read and filled out completely or application will be returned.\n3.   INSPECTION AND VERIFICATION\nThe Utility reserves the right to inspect the customer’s facility through on-site visits before and after new equipment installation to verify rebate eligibility. The Utility reminds you to follow all local permitting and building code ordinances.\n4.   INSTALLATION AND REBATE AMOUNTS\nQualifying energy-efficient equipment installed and operational within six (6) months of the date of purchase are eligible for rebate. Additional time may be granted subject to the Utility’s pre-approval. In no case will the rebate paid by The Utility exceed the purchase price of the equipment. The maximum rebate amount is $100,000 per customer location per technology per year.\n5.   INVOICE AND PAYMENT\nFollowing inspection and verification (see #3) and completed installation, the customer must notify The Utility and submit original invoices specifying the quantity, model number and individual price of all materials purchased, the date ordered, installation costs, and applicable taxes. After satisfactory review of the application and invoices, a rebate check or bill credit will be issued to the customer. Vendors or contractors are not eligible to receive their customer’s rebate. Please allow 6-10 weeks from the date of application submission for delivery of rebate check or bill credit. The Utility reserves the right to apply the rebate to past due accounts.\n6.   QUALIFYING EQUIPMENT Exit Signs:\nOnly new exit signs that replace incandescent or CFL exit signs qualify. All new exit signs must meet UL-924 requirements. Exit signs must have a usage level less than 5 watts. New exit signs must meet local fire codes. Retrofit kits are not eligible.\nLED Lighting in Enclosed Refrigerated Display Cases:\n• Applicable to low and medium temperature enclosed display cases with access by customers (open display cases and closed rear-entry deli cases excluded from this prescriptive program).\n• For existing case lighting replacement, LED lighting system must replace a fluorescent lighting system and the existing fluorescent fixture end connectors and ballasts must be permanently removed and properly disposed of.\n• For new cases, LED lighting system must be installed in lieu of a fluorescent lighting system.\n• LED lighting system must be a permanently installed luminaire.\n• LED lighting system color rendering index (CRI) must be equal to or greater than 70.\n• LEDs must maintain no less than 70% of initial lumen output at 50,000 hours of operation.\n• Manufacturer’s warranty must be a minimum of 3 years and must include luminaires, mounting hardware, power supplies, and LEDs.\n• The power supply must meet the following requirements:\n– Efficiency of at least 85% at 120 volts.\n– Power factor of at least 0.9.\n– Total harmonic distortion (THD) of 20% or less.\nLED or Fluorescent Lamps and Fixtures with Integrated Occupancy Sensors:\nTo qualify, the occupancy sensor must be permanently integrated into the lamp or fixture by the manufacturer (non-removable). Integrated occupancy sensor rebates apply to sensors permanently integrated to LED or fluorescent lamps and fixtures only. Only retrofit projects qualify for additional integrated occupancy sensor rebates. Occupancy sensors are required for new construction by code.\nOccupancy Sensors and Photocells:\nOnly photocells are eligible for new construction rebates. Occupancy sensors are required for new construction by code.\n7.   TAX INFORMATION\nThe Utility will not be responsible for any tax liability imposed as a result of the rebate payment(s). Customers are advised to consult their tax advisors for details.\n8.   DISCLAIMER\nThe Utility does not guarantee that the implementation of energy-efficient measures or use of the equipment purchased or installed pursuant to this program will result in energy or cost savings. The Utility makes no warranties, expressed or implied, with respect to any equipment purchased or installed including, but not limited to, any warrant of merchantability or fitness for purpose. In no event shall The Utility be liable for any incidental or consequential damages. Customers are solely responsible for the proper disposal of existing equipment. Consult the Minnesota Pollution Control Agency (MPCA) office for details at 800.657.3864.\n9.   ENDORSEMENT\nThe Utility does not endorse any particular vendor, manufacturer, product, or system in promoting this rebate program. Listing a vendor or product does not constitute an endorsement, nor does it imply that unlisted vendors or products are deficient or defective in any way.\n10. PRIVACY\nInformation contained in this rebate application may be shared with the Minnesota Department of Commerce and our co-op partners and also may be used in our advertising efforts with your permission as granted in Section B of this rebate application."]

{"sheet":"Modification Instructions","index":10,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["This page provides some explanation of how to update the tables when rebates, etc. change."]
[]
["If a description, code, rebate $, or watts for an existing measure need to be changed, it can be changed on the \"Results\" sheet.  Use \"find\", filter, or sort to locate the "]
["measure that needs to be changed.  You can change any parameter except for those in the \"result\" column.  This is the designator that the"]
["rebate code finder uses to locate the appropriate item."]
[]
["If an entirely new measure is to be added, it will be necessary to add it to the\"Results\" sheet with a new result### and also add it to the \"Rebate Tables\" sheet.  The rebate finder macro, starts with the values shown in"]
["\"Node1\"; note that selecting an item in Node1 will direct you to another node.  The cells ranges that contain the values to be displayed from each node "]
["are named \"NodeXXXTable\", where XXX is the node number.  The rebate finder continues to branch from node to node based on the selections the user"]
["makes in the window until it eventual reaches a \"Result###\"; this identifier is used to pull up the appropriate measure information from the \"Result\" sheet."]
[]
["If it is necessary to add a new decision point, (For example if previously there was no choice for the number of lamps for a certain technology, but now the user will need"]
["to pick the number of lamps), a new NodeTable will need to be created.  If a new NodeTable is created, you must also add it to the \"Rebate Questions\" sheet so that the"]
["rebate finder knows what captions (\"length\", \"description\", \"number of lamps\", etc.) to display next to each drop down menu in the finder window."]

{"sheet":"Revision Log","index":11,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Date","Initials","Description of Changes"]
["2009-04-09","REW","Corrected problem with Demand and Energy rate shown on the financial Summary Sheet.  Deleted Hours of Operation and Facility Square foot questions from Customer Information Sheet.  Set default Demand and Energy rate = 0, and added comments."]
["2009-06-25","REW","Added Instructions Sheet.  Corrected Simple Payback Formula on Financial Summary Sheet. Corrected description for Code 1407, Cold Cathode Lamps."]
["2009-08-20","VMC","Updated Type of Business list, How Did You Hear List, Account Number format, phone number format and removed fax number. "]
["2009-10-20","REW","Added new lighting codes, and associated data and tables to match those in SMMPA Lighting Table for New Equipment dated 9/3/2009 and SMMPA Lighting Tables for Existing Equipment dated 8/3/2009.  Last Result # used is Result447"]
["2009-10-20","REW","Added new Terms and Conditions page."]
["2009-11-04","REW","Added T12 Bonus Rebate.  When it is removed later, must remember to add that row back to the rebate finder and also add the formulas back in on the lighting savings sheet."]
["2010-03-12","VMC","Updated Low-Wattage 28 w 4' lamp T8 to reflect the changed rebate amount. ($0.75 to $1.00) Updated codes to 475 and 476"]
["2010-03-15","VMC","Added Low-Wattage 25 w 4' lamp T8 to reflect the changed rebate amount. ($0.75 to $1.50) Added codes 477 and 488"]
["2010-04-06","VMC","Added new lighting codes, and associated data and tables to match those in SMMPA Lighting Table for New Equipment dated 2/21/2010 and SMMPA Lighting Tables for Existing Equipment dated 2/21/2010.  Last Result # used is Result465"]
["2010-04-20","VMC","Added new T5 lighting codes, and associated data and tables to match those in SMMPA Lighting Table for New Equipment dated 4/8/2010 and SMMPA Lighting Tables for Existing Equipment dated 4/8/2010.  Last Result # used is Result468"]
["2010-05-13","VMC","Added T8 lighting codes (469-472), and associated data and tables to match those in SMMPA Lighting Table for New Equipment dated 4/8/2010 and SMMPA Lighting Tables for Existing Equipment dated 4/8/2010.  Last Result # used is Result472"]
["2010-05-24","VMC","Corrected code 2052 from 251 watts to 351 watts."]
["2010-05-28","VMC","Added guideline tables and AC column to both occupancy sensors page and lighting equipment page."]
["2010-11-09","VML","Added missing 50w incandescent to node29 - end result 473"]
["2011-02-16","VML","Updated wattage, added LED Rebates - end result 477"]
["2011-03-09","VML","Updated changed lighting codes, wattage, and rebate amounts, to match those in SMMPA Lighting Table for New Equipment dated 2/24/2011.  Added codes 489, 490, 491 and 492. end result 481"]
["2011-03-30","VML","Added lighting codes 987-990 result 485"]
["2011-04-20","VML","Added lighting codes 8102 result 486"]
["2011-07-18","VML","Changed lighting codes 2051 and 2050 to the new codes 2105 and 2104."]
["2011-08-01","VML","Added lighting codes 1270, 1271, 180w CFL, end result 488"]
["2012-01-17","VML","Changed over to 2012 codes and rebate amounts.  Added new 4 lamp super T8 rebate.  End result 490"]
["2012-03-19","VML","Added LED in Refrigerated Cases Entry page, Savings page,  and financial summary, as well as added the associated rebate types.  End result 494"]
["2012-08-20","VML","Added new rebate types for T5s (2160 and 2161), updated rebate amounts for 2145-2148.  End result 496"]
["2013-02-27","VML","Added new CFL Rebate Codes and Amounts, Added DesignLights Rebates, added new MH rebate 993 and 994 .  Updated annual hours guidelines and % of time lights are off guidelines. End result 515"]
["2013-03-11","VML","Changed wattage for codes 127 and 144 from 186W to 221W."]
["2013-03-20","VML","Added new Cold Cathode Rebate codes 1409-1412.  End Result 519"]
["2013-06-11","VML","Corrected DesignLights calculations, cleared out old CFL codes with a 0."]
["2014-01-31","VML","Removed Old LED Codes, Added New, Updated Exit Sign wattages and new codes.  Added 2014 Formatting Changes, Space Type, Heated by Natural Gas, etc. End Result557"]
["2014-08-01","VML","Removed HPS & MH codes that should have been removed during 2014 changes.  Added them to the existing equipment code section."]
["2014-12-30","DRL","Revised with updated LED tables"]
["2015-01-02","DRL","Added logic to columns O to T in Lighting entry for 50% calc, also made rebate $/equipment in column N match calculation in column M, modified question pop up window size"]
["2015-03-19","DRL","Added 5 lamp high bay super T8 codes and rebates.  Also updated rebate total with verbiage \"not to exceed\""]
["2015-04-13","DRL","Added 90 watt incandescent"]
["2015-07-29","DRL","LED less than and equal to didn't read right"]
["2015-08-31","DRL","LED HID to Flourescent non energy star read 15 instead of 18"]
["2015-11-19","DRL","Updated Results table so it included N/A wattages so the savings worksheet would populate correctly"]
["2016-01-01","DRL","Updated for new codes on linears, and 50% on under 25 watt retrofit.  I also updated the logos for Austin Utilities"]
["2016-12-29","DRL","Updated MH rebate amounts, added fixtures with occupancy sensors, and removed HPS and Compact flourescents"]
["2016-12-30","DRL","Fixed Deleted lighting equipment entry on E11"]
["2017-01-09","DRL","Rebates not calcualting 50% cap correctly.  Updated."]
["2017-06-07","DRL","Changed code 918 to 919, and updated occupancy sensor input page"]
["2017-08-18","DRL","Removed 1474 and 1475, because they are old codes"]
["2017-12-29","DRL","Updated for 2018. Moved T8's to existing and deleted rebates from results page. Updated pulldown menu questions. Updated Linear to include PL Description. Corrected some tables for LED to retrofit kits"]
["2018-01-29","DRL","Added wattage to some MH codes"]
["2018-05-07","DRL","Corrected some LED with Occ sensor and 250 w HPS codes"]
["2018-12-11","AB","Updated to 2019. Changed code 1556->1700 @ $5, 1557->1701 @ $5; 1558->1702 @ $7, 1559->1703 @$7; 1566->1708 @$5, 1567->1709 @$5; and 1568->1710 @$7, 1569->1711 @$7; Exterior lighting hours changed to match 2019 TRM (4,383 hours). Tested all new ES/DLC lamp code and it tested good with new codes and amounts. "]
["2018-12-11","AB","Changed code for non ES/DLC lamps as following: 1590->1704 @$4, 1591->1705@$4; 1592->1706@$5, 1593->1707@$5; 1476->1718@$3, 1477->1719@$3; 1478->1720@$5, 1479->1721@$5. Added \"non ES/DLC\" language for code description 1704, 1705, 1706, and 1707. Tested good."]
["2019-01-03","AB","Updated Results table by correcting Result520 to read code 1520 vs 1472 so the HID/Halogen/Incandescent LED Retrofit Kit: Less than 25 watts ES/DLC populates from the pull down menu correctly  "]
["2019-01-03","AB","Updated Terms and Conditions tab with 12/18 image due to change in Inspection and Verification clause: \"The Utility reminds you to follow all local permitting and building code ordinances.\""]
["2019-01-03","AB","Updated \"Office Use Only\" field on Customer Information tab to reflect the new 2018 design. "]
["2020-01-09","AB","zero's out new construction non certified rebate codes: 1705 1707 1595 1597 1599 1599 1719 1721 1489 1491 1493 1495 1497 1499 1541 1543 1543 1545 1547 1549 1551 "]
["2020-01-14","AB","Added VB Module to reflect \"line item #\" column insert, 50% limit note, updated column labels  "]
["2020-02-11","AB","Corrected errors on the savings tab (formulas needed adjusting due to the line item column insertion). "]
["2021-12-09","AB ","Added  “by typing my name in the box below…” above signature box to match other forms. Added “New Construction – Austin and Owatonna only” per Kelly's request. Added check stipulation text, added T&C better resolution image, added model number and individual price. Corrected all codes in Node130 HPS, added missing 1000W Result161"]
["2021-12-14","DA","Added Result800 - 8104 - 750W MH 1-Lamp & 750w 1 Lamp on Node94"]
["2023-09-19","AB ","Added t8 code 8091 to be used in new cost as base for new construction (it was pulling up blank, added as blank node91) "]
[null,null,"Removed old code 1473 and updated with 1521 for node127"]

{"sheet":"Rebate Tables","index":12,"n_rows":225,"n_cols":12,"rows_kept":225,"cut":false,"hidden":true,"merged":[]}
["Node1",null,"Node26",null,"Node51",null,"Node76",null,"Node101",null,"Node130"]
["Existing/Base Incandescent Lamps","Node29","1 Lamp","Result54","LED or Flourescent Lamp Fixture ≥ 15w with Integrated Occupancy Sensor","Result722","1 lamp","Result250","1 Lamp","Result343","35w HPS Fixture","Result141"]
["Existing/Base Compact Fluorescent Lamps (1 piece)","Node53","2 Lamps","Result55","LED or Flourescent Lamp Fixture ≥ 50w with Integrated Occupancy Sensor","Result724","2 lamps","Result251","2 Lamps","Result344","50w HPS Fixture","Result142"]
["Existing T12 Fluorescent Lamps And Fixtures With Electronic Ballasts","Node2",null,null,"LED or Flourescent Lamp Fixture ≥ 100w with Integrated Occupancy Sensor","Result726","3 lamps","Result252","3 Lamps","Result444","70w HPS Fixture","Result143"]
["Existing T8 and Super T8 Fluorescent Lamps and Fixtures with Electronic Ballasts","Node69","Node27",null,null,null,"4 lamps","Result253",null,null,"100w HPS Fixture","Result144"]
["Existing/Base T8 Lamps","Node91","1 Lamp","Result56",null,null,null,null,"Node102",null,"150w HPS Fixture","Result155"]
["Existing/Base T5 Lamps","Result466","2 Lamps","Result57",null,null,"Node77",null,"1 Lamp","Result345","200w HPS Fixture","Result156"]
["Existing/Base Mercury Vapor Fixtures","Node93","3 Lamps","Result58",null,null,"1 lamp","Result254","2 Lamps","Result346","250w HPS Fixture","Result157"]
["Existing/Base Metal Halide Fixtures","Node94",null,null,null,null,"2 lamps","Result255",null,null,"310w HPS Fixture","Result158"]
["Existing/Base Metal Halide Lamps","Node123","Node28",null,"Node52",null,null,null,"Node103",null,"400w HPS Fixture","Result159"]
["Existing/Base High Pressure Sodium (HPS) Fixtures","Node130","1 Lamp","Result59","Retrofit","Node51","Node78",null,"1 Lamp","Result347","600w HPS Fixture","Result160"]
["Existing/Base Exit Signs","Node95","2 Lamps","Result60","New Construction","Node54","1 lamp","Result256","2 Lamps","Result348","750w HPS Fixture","Result150"]
["Existing /Base Traffic Signals","Node110",null,null,null,null,"2 lamps","Result257","3 Lamps","Result349","1000w HPS Fixture","Result161"]
["New LED Bulbs Screw in /Pin Type/Linear","Node131","Node29",null,"Node53",null,"3 lamps","Result258"]
["New LED Fixtures","Node64","6w","Result61","3-20w CFL","Result502","4 lamps","Result259","Node104"]
["New Fixtures and Lamps with Integrated Occupancy Sensors","Node52","40w","Result62","21-35w CFL","Result504",null,null,"1 Lamp","Result350"]
["New T5 Fluorescent Fixtures with Electronic Ballasts","Node30","50w","Result473","36-55w CFL","Result506","Node79",null,"2 Lamps","Result351"]
["New Metal Halide (MH) Fixtures and Lamps","Node39","60w","Result63","56-70w CFL","Result508","1 lamp","Result260","3 Lamps","Result352","Node131"]
["New Ceramic MH Fixtures and Lamps","Node46","65w","Result486","71-85w CFL","Result510","2 lamps","Result261",null,null,"Retrofit","Node132"]
["New Compact Fluorescent Lamps - Hardwired Fixtures","Node55","75w","Result64","86-179-w CFL","Result512","4lamps","Result406","Node105",null,"New Contruction","Node133"]
["New Cold Cathode Lamps","Node58","90w","Result720","180w CFL (400w MH base)","Result514",null,null,"1 Lamp","Result353"]
["New Induction Lamps","Node61","100w","Result65",null,null,"Node80",null,"2 Lamps","Result354","Node132"]
["New Exit Signs, Occupanct Sensors, and Photocells","Node65","150w","Result66","Node54",null,"1 lamp","Result262","3 Lamps","Result355","EnergyStar/DLC","Node134"]
["New LED Traffic Signals","Node111","200w","Result67","LED or Flourescent Lamp Fixture ≥ 15w with Integrated Occupancy Sensor","Result721","2 lamps","Result263","4 Lamps","Result356","Non EnergyStar/non-DLC","Node136"]
[null,null,"300w","Result68","LED or Flourescent Lamp Fixture ≥ 50w with Integrated Occupancy Sensor","Result723","3 lamps","Result264","6 Lamps","Result357"]
["Node2",null,"450w","Result400","LED or Flourescent Lamp Fixture ≥ 100w with Integrated Occupancy Sensor","Result725","4 lamps","Result265",null,null,"Node133"]
["2' Lamp Length","Node3","500w","Result69",null,null,null,null,"Node106",null,"EnergyStar/DLC","Node135"]
["3' Lamp Length","Node5","575w","Result435",null,null,"Node81",null,"1 Lamp","Result358","Non EnergyStar/non-DLC","Node137"]
["4' Lamp Length","Node8","750w","Result70",null,null,"1 lamp","Result266","2 Lamps","Result359"]
["5' Lamp Length","Node14","1000w","Result71",null,null,"2 lamps","Result267","3 Lamps","Result360","Node134"]
["6' Lamp Length","Node18","1500w","Result72",null,null,"3 lamps","Result268","4 Lamps","Result361","Non-Linear LED Light Bulbs <10 watts","Result600"]
["8' Lamp Length","Node22",null,null,"Node55",null,"4 lamps","Result269",null,null,"Non-Linear LED Light Bulbs 10 watts <20 watts","Result602"]
[null,null,"Node30",null,"Retrofit","Node56","5 lamps","Result270","Node107",null,"Non-Linear LED Light Bulbs 20 watts < 100 watts","Result604"]
["Node3",null,"Retrofit","Node31","New Contruction","Node57","6 lamps","Result271","1 Lamp","Result362","Non-Linear LED Light Bulbs 100 watts <200 watts","Result606"]
["F20T12","Node4","New Construction","Node32",null,null,"8 lamps","Result272","2 Lamps","Result363","Non-Linear LED Light Bulbs 200 watts and greater","Result608"]
[null,null,null,null,"Node56",null,null,null,"3 Lamps","Result364","Linear LED Light Bulb < 46 ","Result610"]
["Node4",null,"Node31",null,"3-10w Total","Result204","Node82",null,"4 Lamps","Result365","Linear LED Light Bulb ≥ 46 ","Result612"]
["1 Lamp","Result1","14w T5 HBF","Result454","11-15w Total","Result205","1 lamp","Result273"]
["2 Lamps","Result2","18w T5","Node96","16-20w Total","Result206","2 lamps","Result274","Node108"]
["3 Lamps","Result3","28w T5","Node117","21-25w Total","Result207","3 lamps","Result275","1 Lamp","Result366"]
["4 Lamps","Result4","39w T5","Node97","26-30w Total","Result208","4 lamps","Result276","2 Lamps","Result367"]
[null,null,"40w T5","Node98","31-40w Total","Result209",null,null,"3 Lamps","Result445"]
["Node5",null,"50w T5","Node99","41-50w Total","Result210","Node83",null,null,null,"Node135"]
["F30T12 (30w lamps)","Node6","55w T5","Node100","51-60w Total","Result211","1 lamp","Result277","Node109",null,"Non-Linear LED Light Bulbs <10 watts","Result601"]
["F30T12 (25w lamps)","Node7","24w HO T5","Node101","3 lamp - Industrial Multi-CFL Fixture","Result212","2 lamps","Result278","1 Lamp","Result368","Non-Linear LED Light Bulbs 10 watts <20 watts","Result603"]
[null,null,"24w HO T5/Reflectors","Result495","8 lamp - Industrial Multi-CFL Fixture","Result213",null,null,"2 Lamps","Result369","Non-Linear LED Light Bulbs 20 watts < 100 watts","Result605"]
["Node6",null,"39w HO T5","Node102","9 lamp - Industrial Multi-CFL (400W HID Base)","Result403","Node84",null,null,null,"Non-Linear LED Light Bulbs 100 watts <200 watts","Result607"]
["1 Lamp","Result5","48w HO T5 / Reflectors (400w HID base)","Result73",null,null,"1 lamp","Result407","Node110",null,"Non-Linear LED Light Bulbs 200 watts and greater","Result609"]
["2 Lamps","Result6","49w HO T5, Low-Wattage, Lamps Only","Result467","Node57",null,"2 lamps","Result408","12 inch Ball (any color)","Result370","Linear LED Light Bulb < 46 ","Result611"]
["3 Lamps","Result7","54w HO T5","Node33","3-10w Total","Result214","3 lamps","Result409","8 inch Ball (any color)","Result371","Linear LED Light Bulb ≥ 46 ","Result613"]
["4 Lamps","Result8","54w HO T5 / Reflectors (2-lamp 8' T12 HO base)","Result74","11-15w Total","Result215","4 lamps","Result279","Arrow (any color)","Result372"]
[null,null,"54w HO T5 / Reflectors (400w HID base)","Node34","16-20w Total","Result216","6 lamps","Result280","Pedestrian hand/man combo","Result373"]
["Node7",null,"54w HO T5 / Reflectors (1000w HID base)","Node35","21-25w Total","Result217"]
["1 Lamp","Result9","54w T5 / Reflectors (1000w HID base)","Result75","26-30w Total","Result218","Node85",null,"Node111"]
["2 Lamps","Result10","80w HO T5","Result76","31-40w Total","Result219","1 lamp","Result281","Retrofit","Node112"]
["3 Lamps","Result11",null,null,"41-50w Total","Result220","2 lamps","Result282","New Construction","Node113","Node136"]
["4 Lamps","Result12","Node32",null,"51-60w Total","Result221","3 lamps","Result283",null,null,"Non-Linear LED Light Bulbs <10 watts","Result650"]
[null,null,"14w T5 HBF","Result455","3 lamp - Industrial Multi-CFL Fixture","Result222","4 lamps","Result284","Node112",null,"Non-Linear LED Light Bulbs 10 watts <20 watts","Result652"]
["Node8",null,"18w T5","Node103","8 lamp - Industrial Multi-CFL Fixture","Result223","6 lamps","Result440","12 inch red ball LED","Result374","Non-Linear LED Light Bulbs 20 watts < 100 watts","Result654"]
["F40T12 (40w lamps)","Node9","28w T5","Node118","9 lamp - Industrial Multi-CFL (400W HID Base)","Result404",null,null,"12 inch green ball LED","Result375","Non-Linear LED Light Bulbs 100 watts <200 watts","Result656"]
["F40T12 (34w lamps)","Node10","39w T5","Node104",null,null,"Node86",null,"12 inch yellow ball LED","Result376","Non-Linear LED Light Bulbs 200 watts and greater","Result658"]
["F48T12","Node11","40w T5","Node105","Node58",null,"1 lamp","Result285","8 inch red ball LED","Result377","Linear LED Light Bulb < 46 ","Result660"]
["F48T12 HO","Node12","50w T5","Node106","Retrofit","Node59","2 lamps","Result286","8 inch green ball LED","Result378","Linear LED Light Bulb ≥ 46 ","Result662"]
["F48T12 VHO","Node13","55w T5","Node107","New Contruction","Node60","3 lamps","Result287","8 inch yellow ball LED","Result379"]
[null,null,"24w HO T5","Node108",null,null,"4 lamps","Result288","12 inch red arrow LED","Result380"]
["Node9",null,"24w HO T5/Reflectors","Result496","Node59",null,null,null,"12 inch green arrow LED","Result381"]
["1 Lamp","Result13","39w HO T5","Node109","5-10w Total","Result516","Node87",null,"12 inch yellow arrow LED","Result382"]
["2 Lamps","Result14","48w HO T5 / Reflectors (400w HID base)","Result77","11-15w Total","Result518","1 Lamp","Result290","9 inch hand LED","Result383"]
["3 Lamps","Result15","49w HO T5, Low-Wattage, Lamps Only","Result468",null,null,"2 Lamps","Result291","12 inch hand LED","Result384","Node137"]
["4 Lamps","Result16","54w HO T5","Node36","Node60",null,"3 Lamps","Result292","12 inch man LED","Result385","Non-Linear LED Light Bulbs <10 watts","Result651"]
[null,null,"54w HO T5 / Reflectors (2-lamp 8' T12 HO base)","Result78","5-10w Total","Result226",null,null,"12 inch combo hand/man/countdown LED","Result386","Non-Linear LED Light Bulbs 10 watts <20 watts","Result653"]
["Node10",null,"54w HO T5 / Reflectors (400w HID base)","Node37","11-15w Total","Result227","Node88",null,null,null,"Non-Linear LED Light Bulbs 20 watts < 100 watts","Result655"]
["1 Lamp","Result17","54w HO T5 / Reflectors (1000w HID base)","Node38","5-10w Total","Result517","1 Lamp","Result293","Node113",null,"Non-Linear LED Light Bulbs 100 watts <200 watts","Result657"]
["2 Lamps","Result18","54w T5 / Reflectors (1000w HID base)","Result79","11-15w Total","Result519","2 Lamps","Result294","12 inch red ball LED","Result387","Non-Linear LED Light Bulbs 200 watts and greater","Result659"]
["3 Lamps","Result19","80w HO T5","Result80",null,null,null,null,"12 inch green ball LED","Result388","Linear LED Light Bulb < 46 ","Result661"]
["4 Lamps","Result20",null,null,"Node61",null,"Node89",null,"12 inch yellow ball LED","Result389","Linear LED Light Bulb ≥ 46 ","Result663"]
[null,null,null,null,"Retrofit","Node62","1 Lamp","Result295","8 inch red ball LED","Result390"]
["Node11",null,"Node33",null,"New Contruction","Node63","2 Lamps","Result296","8 inch green ball LED","Result391"]
["1 Lamp","Result21","1 Lamps","Result81",null,null,"6 Lamps","Result297","8 inch yellow ball LED","Result392"]
["2 Lamps","Result22","2 Lamps","Result82","Node62",null,null,null,"12 inch red arrow LED","Result393"]
[null,null,"3 Lamps","Result83","15-22 Watt (70W HID base)","Result228","Node90",null,"12 inch green arrow LED","Result394"]
["Node12",null,"4 Lamps","Result84","23-39 Watt (100W HID base)","Result229","1 Lamp","Result298","12 inch yellow arrow LED","Result395"]
["1 Lamp","Result23",null,null,"40-149 Watt (175W HID base)","Result230","2 Lamps","Result299","9 inch hand LED","Result396"]
["2 Lamps","Result24","Node34",null,"150-199 Watt (250W HID base)","Result429",null,null,"12 inch hand LED","Result397"]
["3 Lamps","Result25","3 Lamps","Result85","200-299 Watt (400W HID base)","Result430","Node91",null,"12 inch man LED","Result398"]
["4 Lamps","Result26","4 Lamps","Result86","300-400 Watt (1000W HID base)","Result431","Retrofit","Result303","12 inch combo hand/man/countdown LED","Result399"]
[null,null,"6 Lamps","Result87",null,null,"New Contruction","Result302"]
["Node13",null,null,null,"Node63",null,null,null,"Node114"]
["1 Lamp","Result27","Node35",null,"15-22 Watt (70W HID base)","Result231"]
["2 Lamps","Result28","8 Lamps","Result88","23-39 Watt (100W HID base)","Result232"]
["3 Lamps","Result29","12 Lamps","Result89","40-149 Watt (175W HID base)","Result233"]
[null,null,null,null,"150-199 Watt (250W HID base)","Result432"]
["Node14",null,"Node36",null,"200-299 Watt (400W HID base)","Result433"]
["F60T12","Node15","1 Lamp","Result90","300-400 Watt (1000W HID base)","Result434"]
["F60T12 HO","Node16","2 Lamps","Result91",null,null,"Node92",null,"Node115"]
["F60T12 VHO","Node17","3 Lamps","Result92","Node64",null,null,null,"1 Lamp","Result470"]
[null,null,"4 Lamps","Result93","Retrofit","Node119",null,null,"2 Lamps","Result469"]
["Node15",null,null,null,"New Contruction","Node120",null,null,"3 Lamps","Result419"]
["1 Lamp","Result30","Node37",null,null,null,null,null,"4 Lamps","Result420"]
["2 Lamps","Result31","3 Lamps","Result94","Node65",null,null,null,"6 Lamps","Result421"]
[null,null,"4 Lamps","Result95","Retrofit","Node66",null,null,"8 Lamps","Result422"]
["Node16",null,"6 Lamps","Result96","New Contruction","Node67","Node93"]
["1 Lamp","Result32",null,null,null,null,"50w 1 Lamp","Result304","Node116"]
["2 Lamps","Result33","Node38",null,"Node66",null,"100w 1 Lamp","Result305"]
["3 Lamps","Result34","8 Lamps","Result97","Exit Sign - LED (incandescent existing)","Result460","175w 1 Lamp","Result306"]
["4 Lamps","Result35","12 Lamps","Result98","Exit Sign - LED (CFL existing)","Result461","250w 1 Lamp","Result307"]
[null,null,null,null,"Exit Sign - LEC/Electroluminescent (incandescent existing)","Result462","400w 1 Lamp","Result308"]
["Node17",null,"Node39",null,"Exit Sign - LEC/Electroluminescent (CFL existing)","Result463","400w 2 Lamps","Result309"]
["1 Lamp","Result36","Retrofit","Node40","Exit Sign - Photoluminescent (incandescent existing)","Result464","500w 1 Lamp","Result310"]
["2 Lamps","Result37","New Construction","Node41","Exit Sign - Photoluminescent (CFL existing)","Result465","700w 1 Lamp","Result311"]
[null,null,null,null,"Wall Mount Occupancy Sensor","Result237","1000w 1 Lamp","Result312","Node117"]
["Node18",null,"Node40",null,"Ceiling Mount Occupancy Sensor","Result238",null,null,"1 Lamp","Result436"]
["F72T12","Node19","100w Pulse-Start MH Fixture","Result498","Photocells","Result239","Node94",null,"2 Lamps","Result438"]
["F72T12 HO","Node20","150w Pulse-Start MH Fixture (magnetic)","Result103","LED or Flourescent Lamp Fixture ≥ 15w with Integrated Occupancy Sensor","Result721","32w 1 Lamp","Result99","3 Lamps","Result440"]
["F72T12 VHO","Node21","150w Pulse-Start MH Fixture (electronic)","Result482","LED or Flourescent Lamp Fixture ≥ 50w with Integrated Occupancy Sensor","Result723","50w 1 Lamp","Result100","4 Lamps","Result442"]
[null,null,"175w Pulse-Start MH Fixture (magnetic)","Result104","LED or Flourescent Lamp Fixture ≥ 100w with Integrated Occupancy Sensor","Result725","70w 1 Lamp","Result101"]
["Node19",null,"200w Pulse-Start MH Fixture (magnetic)","Result105",null,null,"100w 1 Lamp","Result102","Node118"]
["1 Lamp","Result38","250w Pulse-Start MH Fixture (magnetic)","Result106",null,null,"150w 1 Lamp","Result313","1 Lamp","Result437"]
["2 Lamps","Result39","320w Pulse-Start MH Fixture (electronic)","Result484","Node67",null,"175w 1 Lamp","Result314","2 Lamps","Result439"]
[null,null,"320w Pulse-Start MH Fixture (magnetic)","Result107","Photocells","Result242","250w 1 Lamp","Result315","3 Lamps","Result441"]
["Node20",null,"350w Pulse-Start MH Fixture (magnetic)","Result108",null,null,"400w 1 Lamp","Result316","4 Lamps","Result443"]
["1 Lamp","Result40","400w Pulse-Start MH Fixture (magnetic)","Node42",null,null,"400w 2 Lamps","Result317"]
["2 Lamps","Result41","575w Pulse-Start MH Fixture (magnetic)","Result427",null,null,"750w 1 Lamp","Result800","Node119"]
["3 Lamps","Result42","750w Pulse-Start MH Fixture (magnetic)","Result109",null,null,"1000w 1 Lamp","Result318","ENERGY STAR®/DesignLights Consortium qualified LED","Node126"]
["4 Lamps","Result43","875w Pulse-Start MH Fixture (magnetic)","Node43",null,null,"1000w 2 Lamps","Result319","Non-ENERGY STAR®/ Non-DesignLights Consortium qualified LED","Node128"]
[null,null,"360w MH Lamp Only w/Ferro Electric Capacitor","Result110",null,null,"1000w 3 Lamps","Result320"]
["Node21",null,null,null,null,null,null,null,"Node120"]
["1 Lamp","Result44","Node41",null,null,null,"Node95",null,"ENERGY STAR®/DesignLights Consortium qualified LED","Node127"]
["2 Lamps","Result45","100w Pulse-Start MH Fixture","Result499",null,null,"15w 2 Lamps","Result321","Non-ENERGY STAR®/ Non-DesignLights Consortium qualified LED","Node129"]
["3 Lamps","Result46","150w Pulse-Start MH Fixture (magnetic)","Result115",null,null,"20w 2 Lamps","Result322"]
[null,null,"150w Pulse-Start MH Fixture (electronic)","Result483",null,null,null,null,"Node121"]
["Node22",null,"175w Pulse-Start MH Fixture (magnetic)","Result116",null,null,"Node96",null,"4 Lamps","Result489"]
["F96T12 (75w lamps)","Node23","200w Pulse-Start MH Fixture (magnetic)","Result117",null,null,"1 Lamp","Result324","5 Lamps","Result701"]
["F96T12 (60w lamps)","Node24","250w Pulse-Start MH Fixture (magnetic)","Result118",null,null,"2 Lamps","Result325","6 Lamps","Result450"]
["F96T12 HO (110w lamps)","Node25","320w Pulse-Start MH Fixture (electronic)","Result485",null,null,"3 Lamps","Result326","8 Lamps","Result480"]
["F96T12 HO (95w lamps)","Node26","320w Pulse-Start MH Fixture (magnetic)","Result119"]
["F96T12 VHO (215w lamps)","Node27","350w Pulse-Start MH Fixture (magnetic)","Result120",null,null,"Node97",null,"Node122"]
["F96T12 VHO (185w lamps)","Node28","400w Pulse-Start MH Fixture (magnetic)","Node44",null,null,"1 Lamp","Result327"]
[null,null,"575w Pulse-Start MH Fixture (magnetic)","Result428",null,null,"2 Lamps","Result328"]
["Node23",null,"750w Pulse-Start MH Fixture (magnetic)","Result121",null,null,"3 Lamps","Result329"]
["1 Lamp","Result47","875w Pulse-Start MH Fixture (magnetic)","Node45"]
["2 Lamps","Result48","360w MH Lamp Only w/Ferro Electric Capacitor","Result122",null,null,"Node98"]
[null,null,null,null,null,null,"1 Lamp","Result330","Node123"]
["Node24",null,"Node42",null,null,null,"2 Lamps","Result331","250 Watt Metal Halide Lamps Only","Result452"]
["1 Lamp","Result49","1 Lamp","Result123",null,null,"3 Lamps","Result332","400 Watt Metal Halide Lamps Only","Result453"]
["2 Lamps","Result50","2 Lamps","Result124",null,null,"4 Lamps","Result333","1000 Watt Metal Halide Lamps Only","Result497"]
[null,null,null,null,null,null,"6 Lamps","Result334"]
["Node25",null,"Node43",null,null,null,null,null,"Node124"]
["1 Lamp","Result51","1 Lamp","Result125","Node69",null,"Node99",null,"4 Lamps","Result478"]
["2 Lamps","Result52","2 Lamps","Result126","2'","Node70","1 Lamp","Result335"]
["3 Lamps","Result53","3 Lamps","Result127","3'","Node71","2 Lamps","Result336","Node125"]
[null,null,null,null,"4'","Node72","3 Lamps","Result337"]
[null,null,"Node44",null,"5'","Node73","4 Lamps","Result338"]
[null,null,"1 Lamp","Result128","6'","Node74",null,null,"Node126"]
[null,null,"2 Lamps","Result129","8'","Node75","Node100"]
[null,null,null,null,null,null,"1 Lamp","Result339","Flourescent to LED Fixture/Luminaire: Less than 25 watts","Result622"]
[null,null,"Node45",null,"Node70",null,"2 Lamps","Result340","Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts","Result624"]
[null,null,"1 Lamp","Result130","F17T8","Node76","3 Lamps","Result341","Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts","Result626"]
[null,null,"2 Lamps","Result131","F17T8 with Reflectors","Node77","4 Lamps","Result342","Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts","Result628"]
[null,null,"3 Lamps","Result132",null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts","Result630"]
[null,null,null,null,"Node71",null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater","Result632"]
[null,null,"Node46",null,"F25T8","Node78",null,null,"HID, Incandescent, Halogen to LED Retrofit: Less than 25 Watts ES/DSL","Result520"]
[null,null,"Retrofit","Node47","F25T8 with Reflectors","Node79",null,null,"HID, Incandescent, Halogen to LED Fixtures: less than 25 watts  ES/DSL","Result634"]
[null,null,"New Construction","Node48",null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 25 to < 50 watts  ES/DSL","Result636"]
[null,null,null,null,"Node72",null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 50 to < 100 watts ES/DSL","Result638"]
[null,null,"Node47",null,"Low Wattage (28W) T8 Lamps Only","Result401",null,null,"HID, Incandescent, Halogen to LED Fixtures: 100 to < 150 watts ES/DSL","Result640"]
[null,null,"25w Integrated Ceramic MH Lamps","Result133","Low Wattage (25W) T8 Lamps Only","Result448",null,null,"HID, Incandescent, Halogen to LED Fixtures: 150 to < 200 watts ES/DSL","Result642"]
[null,null,"150w or less Ceramic MH Fixture","Result134","F32T8","Node80",null,null,"HID, Incandescent, Halogen to LED Fixtures: 200 watts and greater ES/DSL","Result644"]
[null,null,"151-250w Ceramic MH Fixture","Result135","F32T8 with Reflectors","Node81",null,null,"LED in Enclosed COOLER Display Cases (0F to 45F)  ES/DSL","Result491"]
[null,null,"205W Ceramic Metal Halide Lamp","Result456","F32T8 - RLO","Node82",null,null,"LED in Enclosed FREEZER Display Cases (-35F to 0F) ES/DSL","Result493"]
[null,null,"251w or greater Ceramic MH Fixture","Result136","F32T8 - RLO / Reflectors","Node83"]
[null,null,"330W Ceramic Metal Halide Lamp","Result458","F32T8 - HBF / Reflectors (Hi-bay applications - ceiling height > 15') ","Node84",null,null,"Node127"]
[null,null,"830W Ceramic Metal Halide Lamp","Result556","F32T8 - RLO / Reflectors (Compare to 400w HID base)","Result243"]
[null,null,null,null,"F32 Super T8 (ceiling height ≤ 15')","Node85",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: Less than 25 watts","Result623"]
[null,null,"Node48",null,"F32 Super T8 (ceiling height > 15')","Node124",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts","Result625"]
[null,null,"25w Integrated Ceramic MH Lamps","Result137","F32 Super T8 / Reflectors (ceiling height ≤ 15')","Node115",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts","Result627"]
[null,null,"150w or less Ceramic MH Fixture","Result138","F32 Super T8 / Reflectors (ceiling height > 15')","Node121",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts","Result629"]
[null,null,"151-250w Ceramic MH Fixture","Result139","F36T8","Result244",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts","Result631"]
[null,null,"205W Ceramic Metal Halide Lamp","Result457","F36T8 with Reflectors","Result245",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater","Result633"]
[null,null,"251w or greater Ceramic MH Fixture","Result140","F48T8/HO","Node86",null,null,"HID, Incandescent, Halogen to LED Fixtures: less than 25 watts  ES/DSL","Result635"]
[null,null,"330W Ceramic Metal Halide Lamp","Result459",null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 25 to < 50 watts  ES/DSL","Result637"]
[null,null,"830W Ceramic Metal Halide Lamp","Result557","Node73",null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 50 to < 100 watts ES/DSL","Result639"]
[null,null,null,null,"F40T8","Node87",null,null,"HID, Incandescent, Halogen to LED Fixtures: 100 to < 150 watts ES/DSL","Result641"]
[null,null,"Node49",null,"F40T8 w/Reflectors","Result289",null,null,"HID, Incandescent, Halogen to LED Fixtures: 150 to < 200 watts ES/DSL","Result643"]
[null,null,"Retrofit","Node50",null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 200 watts and greater ES/DSL","Result645"]
[null,null,"New Contruction","Node51","Node74",null,null,null,"LED in Enclosed COOLER Display Cases (0F to 45F)  ES/DSL","Result492"]
[null,null,null,null,"F72T8/HO","Node88",null,null,"LED in Enclosed FREEZER Display Cases (-35F to 0F) ES/DSL","Result494"]
[null,null,"Node50"]
[null,null,null,null,"Node75"]
[null,null,null,null,"F96T8","Node89",null,null,"Node128"]
[null,null,null,null,"F96T8 w/Reflectors","Result246"]
[null,null,null,null,"F96T8 w/Reflectors (From F96T12/HO/VHO)","Result247",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: Less than 25 watts","Result672"]
[null,null,null,null,"F96T8 - RLO","Node90",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts","Result674"]
[null,null,null,null,"F96T8 - RLO / Reflectors","Result248",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts","Result676"]
[null,null,null,null,"F96T8 / HO","Result249",null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts","Result678"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts","Result680"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater","Result682"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: less than 25 watts ","Result684"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 25 to < 50 watts  ","Result686"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 50 to < 100 watts ","Result688"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 100 to < 150 watts ","Result690"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 150 to < 200 watts","Result692"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 200 watts and greater ","Result694"]
[null,null,null,null,null,null,null,null,"LED in Enclosed COOLER Display Cases (0F to 45F)  ","Result552"]
[null,null,null,null,null,null,null,null,"LED in Enclosed FREEZER Display Cases (-35F to 0F)","Result554"]
[]
[null,null,null,null,null,null,null,null,"Node129"]
[]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: Less than 25 watts","Result673"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts","Result675"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts","Result677"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts","Result679"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts","Result681"]
[null,null,null,null,null,null,null,null,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater","Result683"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: less than 25 watts  ","Result685"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 25 to < 50 watts  ","Result687"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 50 to < 100 watts ","Result689"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 100 to < 150 watts ","Result691"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 150 to < 200 watts","Result693"]
[null,null,null,null,null,null,null,null,"HID, Incandescent, Halogen to LED Fixtures: 200 watts and greater ","Result695"]
[null,null,null,null,null,null,null,null,"LED in Enclosed COOLER Display Cases (0F to 45F)  ","Result553"]
[null,null,"32w MH Fixture","Result99",null,null,null,null,"LED in Enclosed FREEZER Display Cases (-35F to 0F)","Result555"]
[null,null,"50w MH Fixture","Result100"]
[null,null,"70w MH Fixture","Result101"]
[null,null,"100w MH Fixture","Result102"]

{"sheet":"Results","index":13,"n_rows":557,"n_cols":5,"rows_kept":557,"cut":false,"hidden":true,"merged":[]}
["Result 520","Code","Description","Wattage","Rebate"]
["Result1",8000,"2' - F20T12 1-Lamp",28]
["Result10",8009,"3' - F30T12 25W 2-Lamp",63]
["Result100",8110,"50W MH 1-Lamp Fixture",62]
["Result101",909,"70W MH 1-Lamp Fixture",92]
["Result102",913,"100W MH 1-Lamp Fixture",129]
["Result103",8119,"150W PS MH 1-Lamp (magnetic ballast)",173,25]
["Result104",8121,"175W PS MH 1-Lamp (magnetic ballast)",189,25]
["Result105",971,"200W PS MH 1-Lamp (magnetic ballast)",232,40]
["Result106",8123,"250W PS MH 1-Lamp (magnetic ballast)",290,40]
["Result107",8125,"320W PS MH 1-Lamp (magnetic ballast)",370,55]
["Result108",8129,"350W PS MH 1-Lamp (magnetic ballast)",410,55]
["Result109",8136,"750W PS MH 1-Lamp",812,65]
["Result11",8010,"3' - F30T12 25W 3-Lamp",103]
["Result110",951,"360W MH Lamp Only w/Ferro Electric Capacitor",418,10]
["Result115",8120,"150W PS MH 1-Lamp (magnetic ballast)",173,6]
["Result116",8122,"175W PS MH 1-Lamp (magnetic ballast)",191,6]
["Result117",972,"200W PS MH 1-Lamp (magnetic ballast)",232,8]
["Result118",8124,"250W PS MH 1-Lamp (magnetic ballast)",290,8]
["Result119",8126,"320W PS MH 1-Lamp (magnetic ballast)",370,12]
["Result12",8011,"3' - F30T12 25W 4-Lamp",125]
["Result120",8130,"350W PS MH 1-Lamp (magnetic ballast)",410,12]
["Result121",8135,"750W PS MH 1-Lamp",812,15]
["Result122",950,"360W MH Lamp Only w/Ferro Electric Capacitor",418,5]
["Result123",8131,"400W PS MH 1-Lamp (magnetic ballast)",425,55]
["Result124",8133,"400W PS MH 2-Lamp (magnetic ballast)",850,110]
["Result125",953,"875W PS MH 1-Lamp (magnetic ballast)",935,65]
["Result126",955,"875W PS MH 2-Lamp (magnetic ballast)",1870,130]
["Result127",957,"875W PS MH 3-Lamp (magnetic ballast)",2805,195]
["Result128",8132,"400W PS MH 1-Lamp (magnetic ballast)",425,12]
["Result129",8134,"400W PS MH 2-Lamp (magnetic ballast)",850,24]
["Result13",8012,"4' - F40T12 40W 1-Lamp",46]
["Result130",952,"875W PS MH 1-Lamp (magnetic ballast)",935,15]
["Result131",954,"875W PS MH 2-Lamp (magnetic ballast)",1870,30]
["Result132",956,"875W PS MH 3-Lamp (magnetic ballast)",2805,45]
["Result133",959,"25W Integrated Ceramic MH Lamp",25,20]
["Result134",961,"150W or less Ceramic MH Fixture",100,50]
["Result135",963,"151-250W Ceramic MH Fixture",200,45]
["Result136",965,"250W or greater Ceramic MH Fixture",300,60]
["Result137",958,"25W Integrated Ceramic MH Lamp",25,8]
["Result138",960,"150W or less Ceramic MH Fixture",100,20]
["Result139",962,"151-250W Ceramic MH Fixture",200,10]
["Result14",8013,"4' - F40T12 40W 2-Lamp",81]
["Result140",964,"250W or greater Ceramic MH Fixture",300,15]
["Result141",8115,"35W HPS 1-Lamp",43]
["Result142",8116,"50W HPS 1-Lamp",64]
["Result143",8117,"70W HPS 1-Lamp",86]
["Result144",8118,"100W HPS 1-Lamp",126]
["Result145"]
["Result145"]
["Result146"]
["Result147"]
["Result148"]
["Result149"]
["Result15",8014,"4' - F40T12 40W 3-Lamp",123]
["Result150",996,"750W HPS 1-Lamp",840]
["Result155",919,"150W HPS 1-Lamp",187]
["Result156",925,"200W HPS 1-Lamp",240]
["Result157",929,"250W HPS 1-Lamp",295]
["Result158",931,"310W HPS 1-Lamp",365]
["Result159",995,"400W HPS 1-Lamp",457]
["Result16",8015,"4' - F40T12 40W 4-Lamp",161]
["Result160",945,"600W HPS 1-Lamp",665]
["Result161",997,"1000W HPS 1-Lamp",1100]
["Result17",8016,"4' - F40T12 34W 1-Lamp",43]
["Result18",8017,"4' - F40T12 34W 2-Lamp",72]
["Result19",8018,"4' - F40T12 34W 3-Lamp",115]
["Result2",8001,"2' - F20T12 2-Lamp",46]
["Result20",8019,"4' - F40T12 34W 4-Lamp",144]
["Result203",1250,"96-100W CFL",108]
["Result204",1253,"3-10W CFL Hard Wire",7,8]
["Result205",1255,"11-15W CFL Hard Wire",15,8]
["Result206",8137,"16-20W CFL Hard Wire",18,10]
["Result207",8138,"21-25W CFL Hard Wire",24,10]
["Result208",8139,"26-30W CFL Hard Wire",31,10]
["Result209",8140,"31-40W CFL Hard Wire",36,16]
["Result21",8020,"4' - F48T12 1-Lamp",55]
["Result210",8141,"41-50W CFL Hard Wire",48,16]
["Result211",8142,"51-60W CFL Hard Wire",60,16]
["Result212",1003,"Indust Multi-CFL Fixture 3-Lamp",165,25]
["Result213",1001,"Indust Multi-CFL Fixture 8-Lamp",310,25]
["Result214",1252,"3-10W CFL Hard Wire",7,3]
["Result215",1254,"11-15W CFL Hard Wire",15,3.75]
["Result216",1256,"16-20W CFL Hard Wire",18,4]
["Result217",1258,"21-25W CFL Hard Wire",24,5]
["Result218",1260,"26-30W CFL Hard Wire",31,5]
["Result219",1262,"31-40W CFL Hard Wire",36,8]
["Result22",8021,"4' - F48T12 2-Lamp",93]
["Result220",1264,"41-50W CFL Hard Wire",48,8]
["Result221",1266,"51-60W CFL Hard Wire",60,8]
["Result222",1002,"Indust Multi-CFL Fixture 3-Lamp",165,15]
["Result223",1000,"Indust Multi-CFL Fixture 8-Lamp",310,15]
["Result228",1603,"15-22W Induction Lamp (70W HID Base)",15,17.5]
["Result229",1601,"23-39W Induction Lamp (100W HID Base)",23,22]
["Result23",8022,"4' - F48T12 HO 1-Lamp",76]
["Result230",1605,"40-149W Induction Lamp (175W HID Base)",80,41]
["Result231",1602,"15-22W Induction Lamp (70W HID Base)",15,8.75]
["Result232",1600,"23-39W Induction Lamp (100W HID Base)",23,11]
["Result233",1604,"40-149W Induction Lamp (175W HID Base)",80,20.5]
["Result237",4001,"Wall Mount Occupancy Sensor",0,12]
["Result238",4003,"Ceiling Mount Occupancy Sensor",0,36]
["Result239",4005,"Photocells",0,12]
["Result24",8023,"4' - F48T12 HO 2-Lamp",130]
["Result240"]
["Result241"]
["Result242",4004,"Photocells",0,6]
["Result243",117,"4' F32T8 RLO w/refl 8-Lamp HID",192]
["Result244",148,"4' F36T8 2-Lamp",74]
["Result245",149,"4' F36T8 w/refl 1-Lamp",37]
["Result246",813,"8' F96T8 w/refl 1-Lamp",58]
["Result247",814,"8' F96T8 w/refl 2-Lamp (from F96T12/HO/VHO)",109]
["Result248",817,"8' F96T8 RLO w/refl 1-Lamp",49]
["Result249",818,"8' F96T8 RLO w/refl 2-Lamp",160]
["Result25",8024,"4' - F48T12 HO 3-Lamp",195]
["Result250",206,"2' F17T8 1-Lamp",18]
["Result251",207,"2' F17T8 2-Lamp",32]
["Result252",208,"2' F17T8 3-Lamp",48]
["Result253",209,"2' F17T8 4-Lamp",57]
["Result254",210,"2' F17T8 w/refl 1-Lamp",18]
["Result255",211,"2' F17T8 w/refl 2-Lamp",32]
["Result256",306,"3' F25T8 1-Lamp",24]
["Result257",307,"3' F25T8 2-Lamp",46]
["Result258",308,"3' F25T8 3-Lamp",66]
["Result259",309,"3' F25T8 4-Lamp",82]
["Result26",8025,"4' - F48T12 HO 4-Lamp",260]
["Result260",310,"3' F25T8 w/refl 1-Lamp",24]
["Result261",311,"3' F25T8 w/refl 2-Lamp",46]
["Result262",100,"4' F32T8 1-Lamp",31]
["Result263",101,"4' F32T8 2-Lamp",58]
["Result264",102,"4' F32T8 3-Lamp",85]
["Result265",103,"4' F32T8 4-Lamp",112]
["Result266",104,"4' F32T8 w/refl 1-Lamp",31]
["Result267",105,"4' F32T8 w/refl 2-Lamp",58]
["Result268",106,"4' F32T8 w/refl 3-Lamp",85]
["Result269",107,"4' F32T8 w/refl 4-Lamp",112]
["Result27",8026,"4' - F48T12 VHO 1-Lamp",134]
["Result270",108,"4' F32T8 w/refl 5-Lamp",148]
["Result271",109,"4' F32T8 w/refl 6-Lamp",170]
["Result272",110,"4' F32T8 w/refl 8-Lamp",224]
["Result273",111,"4' F32T8 RLO 1-Lamp",26]
["Result274",112,"4' F32T8 RLO 2-Lamp",51]
["Result275",113,"4' F32T8 RLO 3-Lamp",74]
["Result276",114,"4' F32T8 RLO 4-Lamp",94]
["Result277",115,"4' F32T8 RLO w/refl 1-Lamp",26]
["Result278",116,"4' F32T8 RLO w/refl 2-Lamp",51]
["Result279",125,"4' F32T8 HBF w/refl 4-Lamp HID",146]
["Result28",8027,"4' - F48T12 VHO 2-Lamp",240]
["Result280",127,"4' F32T8 HBF w/refl 6-Lamp HID",221]
["Result281",129,"4' F32 Super T8 1-Lamp",26]
["Result282",130,"4' F32 Super T8 2-Lamp",53]
["Result283",131,"4' F32 Super T8 3-Lamp",80]
["Result284",132,"4' F32 Super T8 4-Lamp",106]
["Result285",150,"4' F48T8 HO 1-Lamp",40]
["Result286",151,"4' F48T8 HO 2-Lamp",81]
["Result287",152,"4' F48T8 HO 3-Lamp",118]
["Result288",153,"4' F48T8 HO 4-Lamp",149]
["Result289",507,"5' F40T8 w/refl 1-Lamp",46]
["Result29",8028,"4' - F48T12 VHO 3-Lamp",450]
["Result290",504,"5' F40T8 1-Lamp",46]
["Result291",505,"5' F40T8 2-Lamp",71]
["Result292",506,"5' F40T8 3-Lamp",105]
["Result293",602,"6' F72T8 HO 1-Lamp",80]
["Result294",603,"6' F72T8 HO 2-Lamp",147]
["Result295",810,"8' F96T8 1-Lamp",58]
["Result296",811,"8' F96T8 2-Lamp",109]
["Result297",812,"8' F96T8 6-Lamp",324]
["Result298",815,"8' F96T8  RLO 1-Lamp",49]
["Result299",816,"8' F96T8  RLO 2-Lamp",99]
["Result3",8002,"2' - F20T12 3-Lamp",68]
["Result30",8029,"5' - F60T12 1-Lamp",100]
["Result300"]
["Result301"]
["Result302",8091,"4’ 32W T8 Lamps Only - NC",32]
["Result303",90,"4' 32W T8 Lamps Only",29]
["Result304",8108,"50W Merc Vap 1-Lamp",75]
["Result305",8109,"100W Merc Vap 1-Lamp",122]
["Result306",8073,"175W Merc Vap 1-Lamp",205]
["Result307",8074,"250W Merc Vap 1-Lamp",285]
["Result308",8076,"400W Merc Vap 1-Lamp",454]
["Result309",8075,"400W Merc Vap 2-Lamp",880]
["Result31",8030,"5' - F60T12 2-Lamp",135]
["Result310",8077,"500W Merc Vap 1-Lamp",570]
["Result311",8078,"750W Merc Vap 1-Lamp",775]
["Result312",8079,"1000W Merc Vap 1-Lamp",1080]
["Result313",8111,"150W MH 1-Lamp Fixture",185]
["Result314",8112,"175W MH 1-Lamp Fixture",210]
["Result315",8088,"250W MH 1-Lamp",295]
["Result316",8113,"400W MH 1-Lamp",456]
["Result317",8114,"400W MH 2-Lamp Fixture",912]
["Result800",8104,"750W MH 1-Lamp",850]
["Result318",8092,"1000W MH 1-Lamp",1080]
["Result319",8093,"1000W MH 2-Lamp",2160]
["Result32",8031,"5' - F60T12 HO 1-Lamp",126]
["Result320",8094,"1000W MH 3-Lamp",3240]
["Result321",8080,"Exit Sign Incand. 15W 2-Lamp",30]
["Result322",8081,"Exit Sign Incand. 20W 2-Lamp",40]
["Result324",2107,"18W T5 1-Lamp",20,12]
["Result325",2108,"18W T5 2-Lamp",34,12]
["Result326",2109,"18W T5 3-Lamp",50,19]
["Result327",2114,"39W T5 1-Lamp",38,12]
["Result328",2115,"39W T5 2-Lamp",66,12]
["Result329",2116,"39W T5 3-Lamp",104,19]
["Result33",8032,"5' - F60T12 HO 2-Lamp",170]
["Result330",2117,"40W T5 1-Lamp",35,12]
["Result331",2118,"40W T5 2-Lamp",68,12]
["Result332",2119,"40W T5 3-Lamp",98,19]
["Result333",2120,"40W T5 4-Lamp",136,19]
["Result334",2121,"40W T5 6-Lamp",204,24]
["Result335",2122,"50W T5 1-Lamp",50,12]
["Result336",2123,"50W T5 2-Lamp",100,12]
["Result337",2124,"50W T5 3-Lamp",150,19]
["Result338",2125,"50W T5 4-Lamp",200,19]
["Result339",2126,"55W T5 1-Lamp",55,12]
["Result34",8033,"5' - F60T12 HO 3-Lamp",250]
["Result340",2127,"55W T5 2-Lamp",110,12]
["Result341",2128,"55W T5 3-Lamp",165,19]
["Result342",2129,"55W T5 4-Lamp",220,19]
["Result343",2130,"24W T5 HO 1-Lamp",29,5]
["Result344",2131,"24W T5 HO 2-Lamp",55,5]
["Result345",2133,"39W T5 HO 1-Lamp",43,10]
["Result346",2134,"39W T5 HO 2-Lamp",85,10]
["Result347",2000,"18W T5 1-Lamp",20,2]
["Result348",2002,"18W T5 2-Lamp",34,2]
["Result349",2004,"18W T5 3-Lamp",50,2.5]
["Result35",8034,"5' - F60T12 HO 4-Lamp",330]
["Result350",2006,"39W T5 1-Lamp",38,2]
["Result351",2008,"39W T5 2-Lamp",66,2]
["Result352",2010,"39W T5 3-Lamp",104,2.5]
["Result353",2013,"40W T5 1-Lamp",35,2]
["Result354",2014,"40W T5 2-Lamp",68,2]
["Result355",2016,"40W T5 3-Lamp",98,2.5]
["Result356",2018,"40W T5 4-Lamp",136,2.5]
["Result357",2020,"40W T5 6-Lamp",204,3]
["Result358",2022,"50W T5 1-Lamp",50,2]
["Result359",2026,"50W T5 2-Lamp",100,2]
["Result36",8035,"5' - F60T12 VHO 1-Lamp",157]
["Result360",2030,"50W T5 3-Lamp",150,8]
["Result361",2034,"50W T5 4-Lamp",200,8]
["Result362",2024,"55W T5 1-Lamp",55,2]
["Result363",2028,"55W T5 2-Lamp",110,2]
["Result364",2032,"55W T5 3-Lamp",165,8]
["Result365",2036,"55W T5 4-Lamp",220,8]
["Result366",2038,"24W T5 HO 1-Lamp",29,2]
["Result367",2040,"24W T5 HO 2-Lamp",55,2]
["Result368",2042,"39W T5 HO 1-Lamp",43,2]
["Result369",2044,"39W T5 HO 2-Lamp",85,2]
["Result37",8036,"5' - F60T12 VHO 2-Lamp",310]
["Result370",8082,"Traffic Signal 12\" Ball (any color)",150]
["Result371",8083,"Traffic Signal 8\" Ball (any color)",67]
["Result372",8084,"Traffic Signal Arrow (any color)",150]
["Result373",8085,"Traffic Signal hand/man combo",69]
["Result374",5001,"Traffic Signal 12\" red ball LED",17,25]
["Result375",5003,"Traffic Signal 12\" green ball LED",15,65]
["Result376",5005,"Traffic Signal 12\" yellow ball LED",24,25]
["Result377",5007,"Traffic Signal 8\" red ball LED",13,15]
["Result378",5009,"Traffic Signal 8\" green ball LED",12,40]
["Result379",5011,"Traffic Signal 8\" yellow ball LED",10,15]
["Result38",8037,"6' - F72T12 1-Lamp",107]
["Result380",5013,"Traffic Signal 12\" red arrow LED",12,25]
["Result381",5015,"Traffic Signal 12\" green arrow LED",11,65]
["Result382",5017,"Traffic Signal 12\" yellow arrow LED",10,25]
["Result383",5023,"Traffic Singal 9\" hand LED",5,25]
["Result384",5019,"Traffic Singal 12\" hand LED",16,40]
["Result385",5021,"Traffic Singal 12\" man LED",12,40]
["Result386",5025,"Traffic Singal 12\" combo hand/man/cntdwn LED",17,60]
["Result387",5000,"Traffic Signal 12\" red ball LED",17,12.5]
["Result388",5002,"Traffic Signal 12\" green ball LED",15,32.5]
["Result389",5004,"Traffic Signal 12\" yellow ball LED",24,12.5]
["Result39",8038,"6' - F72T12 2-Lamp",145]
["Result390",5006,"Traffic Signal 8\" red ball LED",13,7.5]
["Result391",5008,"Traffic Signal 8\" green ball LED",12,20]
["Result392",5010,"Traffic Signal 8\" yellow ball LED",10,7.5]
["Result393",5012,"Traffic Signal 12\" red arrow LED",12,12.5]
["Result394",5014,"Traffic Signal 12\" green arrow LED",11,32.5]
["Result395",5016,"Traffic Signal 12\" yellow arrow LED",10,12.5]
["Result396",5022,"Traffic Singal 9\" hand LED",5,12.5]
["Result397",5018,"Traffic Singal 12\" hand LED",16,20]
["Result398",5020,"Traffic Singal 12\" man LED",12,20]
["Result399",5024,"Traffic Singal 12\" combo hand/man/cntdwn LED",17,30]
["Result4",8003,"2' - F20T12 4-Lamp",91]
["Result40",8039,"6' - F72T12 HO 1-Lamp",135]
["Result400",8096,"450W Incandescent",450]
["Result401",475,"Low Watt (28W) 4' T8 Lamps Only",28]
["Result402"]
["Result403",1269,"Industrial Multi-CFL 9-Lamp (400W MH base)",318,30]
["Result404",1268,"Industrial Multi-CFL 9-Lamp (400W MH base)",318,15]
["Result405",438,"3' F25T8 4-Lamp",85]
["Result406",439,"3' F258 w/refl 4-Lamp",85]
["Result407",119,"4' F32T8 HBF w/refl  High Bay application 1-Lamp",37]
["Result408",121,"4' F32T8 HBF w/refl  High Bay application 2-Lamp",73]
["Result409",123,"4' F32T8 HBF w/refl  High Bay application 3-Lamp",93]
["Result41",8040,"6' - F72T12 HO 2-Lamp",195]
["Result410"]
["Result411"]
["Result412"]
["Result413",133,"4' F32 Super T8 6-Lamp",159]
["Result414"]
["Result415"]
["Result416"]
["Result417"]
["Result418"]
["Result419",138,"4' F32 Super T8 w/refl 3-Lamp",80]
["Result42",8041,"6' - F72T12 HO 3-Lamp",265]
["Result420",139,"4' F32 Super T8 w/refl 4-Lamp",106]
["Result421",140,"4' F32 Super T8 w/refl 6-Lamp",159]
["Result422",141,"4' F32 Super T8 w/refl 8-Lamp",212]
["Result423"]
["Result424"]
["Result425"]
["Result426"]
["Result427",967,"575W PS MH 1-Lamp",620,85]
["Result428",966,"575W PS MH 1-Lamp",620,20]
["Result429",1607,"150-199W Induction Lamp (250W HID base)",150,60]
["Result43",8042,"6' - F72T12 HO 4-Lamp",330]
["Result430",1609,"200-299W Induction Lamp (400W HID base)",225,100]
["Result431",1611,"300-400W Induction Lamp (1000W HID base)",350,100]
["Result432",1606,"150-199W Induction Lamp (250W HID base)",150,30]
["Result433",1608,"200-299W Induction Lamp (400W HID base)",225,50]
["Result434",1610,"300-400W Induction Lamp (1000W HID base)",350,50]
["Result435",8098,"575W Incandescent",575]
["Result436",2110,"28W T5 1-Lamp",29,12]
["Result437",2085,"28W T5 1-Lamp",29,2]
["Result438",2111,"28W T5 2-Lamp",58,12]
["Result439",2077,"28W T5 2-Lamp",58,2]
["Result44",8043,"6' - F72T12 VHO 1-Lamp",180]
["Result440",2112,"28W T5 3-Lamp",96,19]
["Result441",2079,"28W T5 3-Lamp",96,2.5]
["Result442",2113,"28W T5 4-Lamp",116,19]
["Result443",2081,"28W T5 4-Lamp",116,2.5]
["Result444",2132,"24W HO T5 3-Lamp",82,10]
["Result445",2083,"24W HO T5 3-Lamp",82,4]
["Result448",477,"Low Watt (25W) 4' T8 Lamps Only",25]
["Result449"]
["Result45",8044,"6' - F72T12 VHO 2-Lamp",300]
["Result450",144,"4' F32 Super T8/Reflectors (ceiling height > 15')",221]
["Result451"]
["Result452",8099,"250 Watt Metal Halide Lamps Only",250]
["Result453",8100,"400 Watt Metal Halide Lamps Only",400]
["Result454",2106,"14W T5 HBF (2-lamp F32T8 base)",39,12]
["Result455",2087,"14W T5 HBF (2-lamp F32T8 base)",39,2]
["Result456",983,"205W Ceramic Metal Halide Lamp",205,20]
["Result457",984,"205W Ceramic Metal Halide Lamp",205,8]
["Result458",985,"330W Ceramic Metal Halide Lamp",330,20]
["Result459",986,"330W Ceramic Metal Halide Lamp",330,8]
["Result46",8045,"6' - F72T12 VHO 3-Lamp",450]
["Result460",3007,"Exit Sign - LED (incandescent existing)",2,12]
["Result461",3008,"Exit Sign - LED (CFL existing)",2,6]
["Result462",3009,"Exit Sign - LEC/Electroluminescent (incandescent existing)",0.3,15]
["Result463",3010,"Exit Sign - LEC/Electroluminescent (CFL existing)",0.3,10]
["Result464",3005,"Exit Sign - Photoluminescent (incandescent existing)",0,16]
["Result465",3006,"Exit Sign - Photoluminescent (CFL existing)",0,11]
["Result466",8101,"54 Watt T5 HO Lamps Only",54]
["Result467",2088,"Low-Wattage 49 watt, T5 HO Lamps Only",49,1.2]
["Result468",2089,"Low-Wattage 49 watt, T5 HO Lamps Only",49,1.2]
["Result469",137,"4' F32 Super T8 w/refl 2-Lamp",53]
["Result47",8046,"8' - F96T12 75W 1-Lamp",100]
["Result470",136,"4' F32 Super T8 w/refl 1-Lamp",26]
["Result471"]
["Result472"]
["Result473",8097,"50W Incandescent",50]
["Result478",134,"4' F32 Super T8 4-Lamp",146]
["Result479"]
["Result48",8047,"8' - F96T12 75W 2-Lamp",180]
["Result480",146,"4' F32 Super T8/Reflectors (ceiling height > 15')",292]
["Result481"]
["Result482",987,"150W PS MH 1-Lamp (electronic ballast)",163,26]
["Result483",988,"150W PS MH 1-Lamp (electronic ballast)",163,6.5]
["Result484",8127,"320W PS MH 1-Lamp (electronic ballast)",342,61]
["Result485",8128,"320W PS MH 1-Lamp (electronic ballast)",342,15]
["Result486",8102,"65W Incandescent",65]
["Result489",142,"4' F32 Super T8/Reflectors (ceiling height > 15')",146]
["Result49",8048,"8' - F96T12 60W 1-Lamp",75]
["Result490"]
["Result491",1532,"LED in Enclosed COOLER Display Cases (0F to 45F)  ES/DSL","N/A",50]
["Result492",1533,"LED in Enclosed COOLER Display Cases (0F to 45F) ES/DSL","N/A",40]
["Result493",1534,"LED in Enclosed FREEZER Display Cases (-35F to 0F) ES/DSL","N/A",50]
["Result494",1535,"LED in Enclosed FREEZER Display Cases (-35F to 0F) ES/DSL","N/A",40]
["Result495",2160,"24W HO T5/Reflectors (250 watt MH base)",164,60]
["Result496",2161,"24WHO T5/Reflectors (250 watt MH base)",164,30]
["Result497",8103,"1000W Metal Halide Lamps Only",1000]
["Result498",993,"100W Pulse-Start MH Fixture",129,20]
["Result499",994,"100W Pulse-Start MH Fixture",129,9]
["Result5",8004,"3' - F30T12 30W 1-Lamp",43]
["Result50",8049,"8' - F96T12 60W 2-Lamp",123]
["Result502",1286,"3-20W CFL","N/A"]
["Result503"]
["Result504",1288,"21-35W CFL","N/A"]
["Result505"]
["Result506",1290,"36-55W CFL","N/A"]
["Result507"]
["Result508",1292,"56-70W CFL","N/A"]
["Result509"]
["Result51",8050,"8' - F96T12 HO 110W 1-Lamp",139]
["Result510",1294,"71-85W CFL","N/A"]
["Result511"]
["Result512",1296,"86-179W CFL","N/A"]
["Result513"]
["Result514",1298,"180W CFL",200]
["Result515"]
["Result516",1409,"5-10W Cold Cathode Lamp",7,6]
["Result517",1410,"5-10W Cold Cathode Lamp",7,3]
["Result518",1411,"11-20W Cold Cathode Lamp",14,8]
["Result519",1412,"11-20W Cold Cathode Lamp",14,4]
["Result52",8051,"8' - F96T12 HO 110W 2-Lamp",257]
["Result520",1520,"HID/Halogen/Incandescent LED Retrofit Kit: Less than 25 watts ES/DLC",null,35]
["Result521",1473,"HID/Halogen/Incandescent LED Retrofit Kit: Less than 25 watts ES/DLC",null,35]
["Result522"]
["Result523"]
["Result53",8052,"8' - F96T12 HO 110W 3-Lamp",330]
["Result54",8053,"8' - F96T12 HO 95W 1-Lamp",125]
["Result55",8054,"8' - F96T12 HO 95W 2-Lamp",227]
["Result552",1552,"LED in Enclosed COOLER Display Cases (0F to 45F)","N/A",44]
["Result553",1553,"LED in Enclosed COOLER Display Cases (0F to 45F)","N/A",40]
["Result554",1554,"LED in Enclosed FREEZER Display Cases (-35F to 0F)","N/A",44]
["Result555",1555,"LED in Enclosed FREEZER Display Cases (-35F to 0F)","N/A",40]
["Result556",991,"830W Ceramic Metal Halide Lamp",830,40]
["Result557",992,"830W Ceramic Metal Halide Lamp",830,16]
["Result56",8055,"8' - F96T12 VHO 215W 1-Lamp",230]
["Result57",8056,"8' - F96T12 VHO 215W 2-Lamp",375]
["Result58",8057,"8' - F96T12 VHO 215W 3-Lamp",570]
["Result59",8058,"8' - F96T12 VHO 185W 1-Lamp",200]
["Result6",8005,"3' - F30T12 30W 2-Lamp",70]
["Result60",8059,"8' - F96T12 VHO 185W 2-Lamp",325]
["Result600",1700,"Non-Linear LED Light Bulbs <10 watts ES/DLC","N/A",5]
["Result601",1701,"Non-Linear LED Light Bulbs <10 watts ES/DLC","N/A",5]
["Result602",1702,"Non-Linear LED Light Bulbs 10 watts <20 watts ES/DLC","N/A",7]
["Result603",1703,"Non-Linear LED Light Bulbs 10 watts <20 watts ES/DLC","N/A",7]
["Result604",1560,"Non-Linear LED Light Bulbs 20 watts < 100 watts ES/DLC","N/A",20]
["Result605",1561,"Non-Linear LED Light Bulbs 20 watts < 100 watts ES/DLC","N/A",20]
["Result606",1562,"Non-Linear LED Light Bulbs 100 watts <200 watts ES/DLC","N/A",40]
["Result607",1563,"Non-Linear LED Light Bulbs 100 watts <200 watts ES/DLC","N/A",40]
["Result608",1564,"Non-Linear LED Light Bulbs 200 watts and greater ES/DLC","N/A",60]
["Result609",1565,"Non-Linear LED Light Bulbs 200 watts and greater ES/DLC","N/A",60]
["Result61",8095,"6W Incandescent",6]
["Result610",1708,"Linear LED/PL Light Bulb < 46\" ES/DLC","N/A",5]
["Result611",1709,"Linear LED Light Bulb < 46\" ES/DLC","N/A",5]
["Result612",1710,"Linear LED Light Bulb ≥ 46\" ES/DLC","N/A",7]
["Result613",1711,"Linear LED Light Bulb ≥ 46\" ES/DLC","N/A",7]
["Result614",1570,null,"N/A",0]
["Result615",1571,null,"N/A",0]
["Result616",1572,null,"N/A",0]
["Result617",1573,null,"N/A",0]
["Result618",1574,null,"N/A",0]
["Result62",8060,"40W Incandescent",40]
["Result620",1576,null,"N/A"]
["Result622",1578,"Flourescent to LED Fixture/Luminaire: Less than 25 watts ES/DLC","N/A",25]
["Result623",1579,"Flourescent to LED Fixture/Luminaire: Less than 25 watts ES/DLC","N/A",25]
["Result624",1580,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts ES/DLC","N/A",32]
["Result625",1581,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts ES/DLC","N/A",32]
["Result626",1582,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts ES/DLC","N/A",50]
["Result627",1583,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts ES/DLC","N/A",50]
["Result628",1584,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts ES/DLC","N/A",70]
["Result629",1585,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts ES/DLC","N/A",70]
["Result63",8061,"60W Incandescent",60]
["Result630",1586,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts ES/DLC","N/A",97]
["Result631",1587,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts ES/DLC","N/A",97]
["Result632",1588,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater ES/DLC","N/A",125]
["Result633",1589,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater ES/DLC","N/A",125]
["Result634",1520,"LED Fixtures: less than 25 watts  ES/DSL","N/A",35]
["Result635",1521,"LED Fixtures: less than 25 watts  ES/DSL","N/A",35]
["Result636",1522,"LED Fixtures: 25 to < 50 watts  ES/DSL","N/A",63]
["Result637",1523,"LED Fixtures: 25 to < 50 watts  ES/DSL","N/A",63]
["Result638",1524,"LED Fixtures: 50 to < 100 watts ES/DSL","N/A",100]
["Result639",1525,"LED Fixtures: 50 to < 100 watts ES/DSL","N/A",100]
["Result64",8062,"75W Incandescent",75]
["Result640",1526,"LED Fixtures: 100 to < 150 watts ES/DSL","N/A",139]
["Result641",1527,"LED Fixtures: 100 to < 150 watts ES/DSL","N/A",139]
["Result642",1528,"LED Fixtures: 150 to < 200 watts ES/DSL","N/A",194]
["Result643",1529,"LED Fixtures: 150 to < 200 watts ES/DSL","N/A",194]
["Result644",1530,"LED Fixtures: 200 watts or greater ES/DSL","N/A",249]
["Result645",1531,"LED Fixtures: 200 watts or greater ES/DSL","N/A",249]
["Result65",8063,"100W Incandescent",100]
["Result650",1704,"Non-Linear LED Light Bulbs <10 watts  non ES/DLC","N/A",4]
["Result651",1705,"Non-Linear LED Light Bulbs <10 watts  non ES/DLC","N/A",0]
["Result652",1706,"Non-Linear LED Light Bulbs 10 watts <20 watts  non ES/DLC","N/A",5]
["Result653",1707,"Non-Linear LED Light Bulbs 10 watts <20 watts  non ES/DLC","N/A",0]
["Result654",1594,"Non-Linear LED Light Bulbs 20 watts < 100 watts","N/A",15]
["Result655",1595,"Non-Linear LED Light Bulbs 20 watts < 100 watts","N/A",0]
["Result656",1596,"Non-Linear LED Light Bulbs 100 watts <200 watts","N/A",30]
["Result657",1597,"Non-Linear LED Light Bulbs 100 watts <200 watts","N/A",0]
["Result658",1598,"Non-Linear LED Light Bulbs 200 watts and greater","N/A",50]
["Result659",1599,"Non-Linear LED Light Bulbs 200 watts and greater","N/A",0]
["Result66",8064,"150W Incandescent",150]
["Result660",1718,"Linear/PL LED Light Bulb < 46\" non ES/DLC","N/A",3]
["Result661",1719,"Linear/PL LED Light Bulb < 46\" non ES/DLC","N/A",0]
["Result662",1720,"Linear LED Light Bulb ≥ 46\" Non ES/DLC","N/A",5]
["Result663",1721,"Linear LED Light Bulb ≥ 46\" Non ES/DLC","N/A",0]
["Result67",8065,"200W Incandescent",200]
["Result670",1486,null,"N/A",0]
["Result672",1488,"Flourescent to LED Fixture/Luminaire: Less than 25 watts ","N/A",15]
["Result673",1489,"Flourescent to LED Fixture/Luminaire: Less than 25 watts ","N/A",0]
["Result674",1490,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts","N/A",28]
["Result675",1491,"Flourescent to LED Fixture/Luminaire/Retrofit: 25 to < 50 watts ","N/A",0]
["Result676",1492,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts ","N/A",44]
["Result677",1493,"Flourescent to LED Fixture/Luminaire/Retrofit: 50 to < 100 watts ","N/A",0]
["Result678",1494,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts ","N/A",61]
["Result679",1495,"Flourescent to LED Fixture/Luminaire/Retrofit: 100 to < 150 watts ","N/A",0]
["Result68",8066,"300W Incandescent",300]
["Result680",1496,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts ","N/A",85]
["Result681",1497,"Flourescent to LED Fixture/Luminaire/Retrofit: 150 to < 200 watts ","N/A",0]
["Result682",1498,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater ","N/A",109]
["Result683",1499,"Flourescent to LED Fixture/Luminaire/Retrofit: 200 watts or greater ","N/A",0]
["Result684",1540,"LED Fixtures: less than 25 watts","N/A",18]
["Result685",1541,"LED Fixtures: less than 25 watts","N/A",0]
["Result686",1542,"LED Fixtures: 25 to < 50 watts","N/A",55]
["Result687",1543,"LED Fixtures: 25 to < 50 watts","N/A",0]
["Result688",1544,"LED Fixtures: 50 to < 100 watts","N/A",87]
["Result689",1545,"LED Fixtures: 50 to < 100 watts","N/A",0]
["Result69",8067,"500W Incandescent",500]
["Result690",1546,"LED Fixtures: 100 to < 150 watts","N/A",121]
["Result691",1547,"LED Fixtures: 100 to < 150 watts","N/A",0]
["Result692",1548,"LED Fixtures: 150 to < 200 watts","N/A",169]
["Result693",1549,"LED Fixtures: 150 to < 200 watts","N/A",0]
["Result694",1550,"LED Fixtures: 200 watts or greater","N/A",217]
["Result695",1551,"LED Fixtures: 200 watts or greater","N/A",0]
["Result7",8006,"3' - F30T12 30W 3-Lamp",113]
["Result70",8068,"750W Incandescent",750]
["Result700"]
["Result701",155,"4' F32 Super T8/Reflectors (ceiling height > 15')",177]
["Result71",8069,"1000W Incandescent",1000]
["Result72",8070,"1500W Incandescent",1500]
["Result720",8107,"90W Incandescent",90]
["Result721",4020,"LED or Flourescent Fixture ≥ 15w with integrated occ sensor new construction","N/A",5]
["Result722",4021,"LED or Flourescent Fixture ≥ 15w with integrated occ sensor Retrofit","N/A",5]
["Result723",4022,"LED or Flourescent Fixture ≥ 50w with integrated occ sensor new construction","N/A",10]
["Result724",4023,"LED or Flourescent Fixture ≥ 50w with integrated occ sensor retrofit","N/A",10]
["Result725",4024,"LED or Flourescent Fixture ≥ 100w with integrated occ sensor new construction","N/A",15]
["Result726",4025,"LED or Flourescent Fixture ≥ 100w with integrated occ sensor retrofit","N/A",15]
["Result73",2135,"48W HO T5 w/refl 4-Lamp (400 W HID base)",224,90]
["Result74",2145,"54W HO T5 w/refl 2-Lamp (2-lamp 8' T12 HO base)",117,40]
["Result75",2155,"54W HO T5 w/refl 10-Lamp (1000 watt MH base)",585,165]
["Result76",2159,"80 Watt HO T5 4-Lamp",368,17]
["Result77",2136,"48W HO T5 w/refl 4-Lamp (400 W HID base)",224,45]
["Result78",2146,"54W HO T5 w/refl 2-Lamp (2-lamp 8' T12 HO base)",117,20]
["Result79",2156,"54W HO T5 w/refl 10-Lamp (1000 watt MH base)",585,82.5]
["Result8",8007,"3' - F30T12 30W 4-Lamp",138]
["Result80",2048,"80 Watt HO T5 4-Lamp",368,2]
["Result81",2137,"54 W HO T5 1-Lamp (150 watt MH base)",59,45]
["Result82",2139,"55 W HO T5 2-Lamp (175 watt MH base)",117,40]
["Result83",2141,"56 W HO T5 3-Lamp (250 watt MH base)",179,60]
["Result84",2143,"54 W HO T5 4-Lamp (400 watt MH base)",234,85]
["Result85",2147,"54W HO T5 w/refl 3-Lamp (250 watt MH base)",179,60]
["Result86",2149,"54W HO T5 w/refl 4-Lamp (400 watt MH base)",234,85]
["Result87",2151,"54W HO T5 w/refl 6-Lamp (600 watt HPS base)",351,115]
["Result88",2153,"54W HO T5 w/refl 8-Lamp (750 watt MH base)",468,135]
["Result89",2157,"54W HO T5 w/refl 12-Lamp (1000 watt MH base)",702,145]
["Result9",8008,"3' - F30T12 25W 1-Lamp",40]
["Result90",2138,"54 W HO T5 1-Lamp (150 watt MH base)",59,22.5]
["Result91",2140,"55 W HO T5 2-Lamp (175 watt MH base)",117,20]
["Result92",2142,"56 W HO T5 3-Lamp (250 watt MH base)",179,30]
["Result93",2144,"54 W HO T5 4-Lamp (400 watt MH base)",234,42.5]
["Result94",2148,"54W HO T5 w/refl 3-Lamp (250 watt MH base)",179,30]
["Result95",2150,"54W HO T5 w/refl 4-Lamp (400 W HID base)",234,42.5]
["Result96",2152,"54W HO T5 w/refl 6-Lamp (600 watt HPS base)",351,57.5]
["Result97",2154,"54W HO T5 w/refl 8-Lamp (750 watt MH base)",468,67.5]
["Result98",2158,"54W HO T5 w/refl 12-Lamp (1000 W HID base)",702,72.5]
["Result99",901,"32W MH 1-Lamp Fixture",41]

{"sheet":"Rebate Questions","index":14,"n_rows":138,"n_cols":6,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
["Node","Question 1","Question 2","Question 3","Question 4","Questions 5"]
["Node1","Equipment Category"]
["Node2","Equipment Category","Lamp Length"]
["Node3","Equipment Category","Lamp Length","Description"]
["Node4","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node5","Equipment Category","Lamp Length","Description"]
["Node6","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node7","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node8","Equipment Category","Lamp Length","Description"]
["Node9","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node10","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node11","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node12","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node13","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node14","Equipment Category","Lamp Length","Description"]
["Node15","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node16","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node17","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node18","Equipment Category","Lamp Length","Description"]
["Node19","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node20","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node21","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node22","Equipment Category","Lamp Length","Description"]
["Node23","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node24","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node25","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node26","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node27","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node28","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node29","Equipment Category","Lamp Wattage"]
["Node30","Equipment Category","Retrofit or New Construction"]
["Node31","Equipment Category","Retrofit or New Construction","Description"]
["Node32","Equipment Category","Retrofit or New Construction","Description"]
["Node33","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node34","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node35","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node36","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node37","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node38","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node39","Equipment Category","Retrofit or New Construction"]
["Node40","Equipment Category","Retrofit or New Construction","Description"]
["Node41","Equipment Category","Retrofit or New Construction","Description"]
["Node42","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node43","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node44","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node45","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node46","Equipment Category","Retrofit or New Construction"]
["Node47","Equipment Category","Retrofit or New Construction","Description"]
["Node48","Equipment Category","Retrofit or New Construction","Description"]
["Node49","Equipment Category","Retrofit or New Construction"]
["Node50","Equipment Category","Retrofit or New Construction","Description"]
["Node51","Equipment Category","Retrofit or New Construction","Description"]
["Node52","Equipment Category","Retrofit or New Construction"]
["Node53","Equipment Category","Description"]
["Node54","Equipment Category","Retrofit or New Construction","Description"]
["Node55","Equipment Category","Retrofit or New Construction"]
["Node56","Equipment Category","Retrofit or New Construction","Description"]
["Node57","Equipment Category","Retrofit or New Construction","Description"]
["Node58","Equipment Category","Retrofit or New Construction"]
["Node59","Equipment Category","Retrofit or New Construction","Description"]
["Node60","Equipment Category","Retrofit or New Construction","Description"]
["Node61","Equipment Category","Retrofit or New Construction"]
["Node62","Equipment Category","Retrofit or New Construction","Description"]
["Node63","Equipment Category","Retrofit or New Construction","Description"]
["Node64","Equipment Category","Retrofit or New Construction"]
["Node65","Equipment Category","Retrofit or New Construction"]
["Node66","Equipment Category","Retrofit or New Construction","Description"]
["Node67","Equipment Category","Retrofit or New Construction","Description"]
["Node68","Equipment Category","Retrofit or New Construction"]
["Node69","Equipment Category","Lamp Length"]
["Node70","Equipment Category","Lamp Length","Description"]
["Node71","Equipment Category","Lamp Length","Description"]
["Node72","Equipment Category","Lamp Length","Description"]
["Node73","Equipment Category","Lamp Length","Description"]
["Node74","Equipment Category","Lamp Length","Description"]
["Node75","Equipment Category","Lamp Length","Description"]
["Node76","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node77","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node78","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node79","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node80","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node81","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node82","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node83","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node84","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node85","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node86","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node87","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node88","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node89","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node90","Equipment Category","Lamp Length","Description","Number Of Lamps"]
["Node91","Equipment Category","Retrofit or New Construction","Description"]
["Node92","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node93","Equipment Category","Description"]
["Node94","Equipment Category","Description"]
["Node95","Equipment Category","Description"]
["Node96","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node97","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node98","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node99","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node100","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node101","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node102","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node103","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node104","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node105","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node106","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node107","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node108","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node109","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node110","Equipment Category","Description"]
["Node111","Equipment Category","Retrofit or New Construction"]
["Node112","Equipment Category","Retrofit or New Construction","Description"]
["Node113","Equipment Category","Retrofit or New Construction","Description"]
["Node114","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node115","Equipment Category","Retrofit or New Construction","Lamp Length","Description","Number Of Lamps"]
["Node116","Equipment Category","Retrofit or New Construction","Description","Number Of Lamps"]
["Node117","Equipment Category","Retrofit or New Construction","Description","Number of Lamps"]
["Node118","Equipment Category","Retrofit or New Construction","Description","Number of Lamps"]
["Node119","Equipment Category","Retrofit or New Construction","Description"]
["Node120","Equipment Category","Retrofit or New Construction","Description"]
["Node121","Equipment Category","Retrofit or New Construction","Lamp Length","Description","Number Of Lamps"]
["Node122","Equipment Category","Retrofit or New Construction","Lamp Length","Description","Number Of Lamps"]
["Node123","Equipment Category","Lamp Wattage"]
["Node124","Equipment Category","Retrofit or New Construction","Lamp Length","Description","Number Of Lamps"]
["Node125","Equipment Category","Retrofit or New Construction","Lamp Length","Description","Number Of Lamps"]
["Node126","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node127","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node128","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node129","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node130","Equipment Category","Lamp Wattage"]
["Node131","Equipment Category","Retrofit or New Construction"]
["Node132","Equipment Category","Retrofit or New Construction","Description"]
["Node133","Equipment Category","Retrofit or New Construction","Description"]
["Node134","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node135","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node136","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]
["Node137","Equipment Category","Retrofit or New Construction","Description","Lamp/Fixture Wattage"]

{"sheet":"Dropdown Menus","index":15,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Yes or No","Space Type"]
["Yes","Interior"]
["No","Exterior"]
[null,"Exterior 24/7"]

{"sheet":"Compatibility Report","index":16,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"Compatibility Report for 2018 Interactive Lighting Rebate Application v1.8 05.07.2018.xls"]
[null,"Run on 12/10/2018 11:15"]
[]
[null,"If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences","Version"]
[]
[null,"Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.",null,null,"13\nDefined Names","Excel 97-2003"]
[]
[null,"Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.",null,null,7,"Excel 97-2003"]