{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["HOME","Applicant Info","Checklist","Terms","Multi-Facility","Lighting","Lighting SOW","HVAC","Motors & VSDs","Refrigeration & Window Film","Food Service","Custom","Horticulture Lighting"],"not_rendered":{"charts":0,"images":66,"macros":1,"external_links":2,"defined_names":119,"comments":4,"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":"HOME","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,9,27,12],[39,5,39,7],[19,5,19,8],[24,1,28,3],[24,5,24,8],[19,1,21,3],[20,5,22,8],[26,5,34,8],[38,0,38,8],[0,0,1,2],[0,3,0,8],[1,3,1,8],[16,1,16,2],[17,0,17,4],[16,4,16,5],[16,7,16,8],[2,0,15,8],[41,5,41,8],[29,1,33,3],[23,5,23,8],[40,5,40,8],[37,5,37,8],[36,5,36,8],[35,0,35,3],[37,0,37,3],[40,0,41,2],[40,3,41,4]]}
[null,null,null,"2020 v2 Retrofit Application - All Measures"]
[null,null,null,"PNM Business Energy Efficiency Programs",null,null,null,null,null,null,"Add comments below:"]
["Why improve energy efficiency?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Directly improves profitability by cutting operating costs",null,null,"Distinguishes your business as an energy efficiency steward in the community",null,null,"Qualifies your business for rebates that can cover portions of the upgrade cost"]
["Application Process",null,null,null,null,"Click on a quick link below:"]
[]
["1.","Submit a Pre-Notification Application to reserve funding (if required).",null,null,null,"Administrative"]
[]
[]
["2.","Install the qualified technology."]
[]
["3.","Complete, sign and submit Final Application with all required documentation within 6 months of project completion.",null,null,null,"Worksheets"]
[]
[]
[]
[]
["4.","The incentive check will be sent 4 to 6 weeks after approval of the Final Application."]
[]
[]
[]
[]
[]
[]
[]
[]
["Contact Our PNM Business Energy Efficiency Team"]
[]
["320 Gold Avenue SW, Ste 500 Albuquerque, NM 87102",null,null,"(505) 938-9400 Main                                  (505) 938-9401 Fax",null,"energyefficiency@pnm.com"]
[null,null,null,null,null,"www.pnmenergyefficiency.com"]

{"sheet":"Applicant Info","index":1,"n_rows":80,"n_cols":17,"rows_kept":80,"cut":false,"hidden":false,"merged":[[59,0,59,4],[61,0,61,4],[57,7,57,10],[58,7,58,10],[59,7,59,10],[46,4,46,5],[55,0,55,10],[49,5,49,8],[66,1,66,4],[62,0,62,4],[53,0,53,10],[54,0,54,10],[56,0,56,10],[46,8,46,10],[59,5,60,6],[51,0,51,10],[52,0,52,10],[49,0,49,4],[47,0,47,10],[61,7,61,10],[60,7,60,10],[49,9,49,10],[62,7,62,10],[60,0,60,4],[45,0,45,3],[43,0,43,3],[43,4,43,10],[44,0,44,3],[44,4,44,5],[5,2,5,3],[39,4,39,10],[39,0,39,3],[42,3,42,5],[35,0,35,10],[32,0,32,3],[32,4,32,10],[34,6,34,7],[33,0,33,3],[33,4,33,10],[20,0,20,5],[17,0,17,5],[40,6,40,10],[31,0,31,3],[37,7,38,10],[30,4,30,10],[31,9,31,10],[7,7,7,8],[9,0,9,10],[42,8,42,10],[41,0,41,5],[41,6,41,10],[23,0,23,3],[24,0,24,3],[22,6,22,7],[25,4,25,5],[29,0,29,10],[31,4,31,5],[30,0,30,3],[22,8,22,10],[28,4,28,5],[28,0,28,3],[48,9,48,10],[48,0,48,4],[48,5,48,8],[58,0,58,4],[57,0,57,4],[24,4,24,10],[25,0,25,3],[23,4,23,10],[18,0,18,5],[20,6,20,10],[26,0,26,3],[45,4,45,10],[19,6,19,10],[21,6,21,10],[19,0,19,5],[31,6,31,8],[34,0,34,3],[34,4,34,5],[44,6,44,7],[40,0,40,5],[42,6,42,7],[58,5,58,6],[21,0,21,5],[22,3,22,5],[0,3,0,8],[3,0,3,5],[3,6,3,8],[28,8,28,10],[25,6,25,7],[27,0,27,3],[27,4,27,5],[27,6,27,7],[26,4,26,10],[18,6,18,10],[7,0,7,1],[10,0,10,5],[0,9,0,10],[6,7,6,8],[14,6,14,10],[5,7,5,8],[10,6,10,8],[16,0,16,5]]}
[null,null,null,"APPLICANT INFORMATION",null,null,null,null,null,"For office use only:"]
[null,null,null,null,null,null,null,null,null,"Application #","Revision #"]
[]
["Application Type:",null,null,null,null,null,"Check ONE box below:"]
[]
[null,null,"Retrofit",null,null,null,null,"Pre-Notification",null,"Date",null,null,null,null,null,{"$f":"IF(G6>0,\"Yes\",)","v":0}]
[null,null,null,null,null,null,null,"or",null,null,null,null,null,null,"New pre notification checkbox flag:"]
[null,null,null,null,null,null,null,"Final Application",null,"Date",null,null,null,null,false]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifacility checkbox flag:"]
["PNM Account Number where measures installed* ",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"This Application represents multiple accounts / premises",null,null,null,"Enter number of Accounts / Premises ------->",null,null,null,null,null,null,{"$f":"is","v":{"$error":"#NAME?"}},"Lighting Measures flag:",false]
[]
[null,null,"This project includes lighting measures as part of the scope",null,null,null,"2. If yes: Complete Multi-Facility Worksheet -------> CLICK HERE"]
[null,null,"Scope  of Work is REQUIRED for Lighting measures ----> Click Here"]
["Building Type*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Business Type",null,"Tax Status",null,"State"]
["Name of Company*",null,null,null,null,null,"Name Exactly as it Appears on Your Utility Bill*",null,null,null,null,null,"Assembly",null,"Corporation (Inc, PC, etc.)",null,"AL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"College/University",null,"Government Agency",null,"AK"]
["Name of Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,"Grocery",null,"Individual",null,"AZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Heavy Industry",null,"Partnership",null,"AR"]
["Telephone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,"Hotel/Motel Common Areas",null,"Exempt",null,"CA"]
["Email Address*",null,null,null,null,null,null,null,null,null,null,null,"Light Industry",null,null,null,"CO"]
["Address Where Measures Installed*",null,null,null,null,null,null,null,null,null,null,null,"Medical",null,null,null,"CT"]
["City Where Measures Installed*",null,null,null,null,null,"State*",null,{"$f":"IF(E26=\"\",\"\",\"NM\")","v":""},"Zip*",null,null,"Office",null,null,null,"DE"]
["Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,"Restaurant",null,null,null,"FL"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,"Retail/Service",null,null,null,"GA"]
["Taxpayer ID Number (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,"K-12 School",null,null,null,"HI"]
["Contractor Information",null,null,null,null,null,null,null,null,null,null,null,"Warehouse",null,null,null,"ID"]
["Contracting Company*",null,null,null,null,null,null,null,null,null,null,null,"Hotel/Motel or any Dwelling Unit",null,null,null,"IL"]
["Contractor Name*",null,null,null,null,null,"Contractor Phone Number*",null,null,null,null,null,"Parking Garage",null,null,null,"IN"]
["Contractor Email Address*",null,null,null,null,null,null,null,null,null,null,null,"Horticulture",null,null,null,"IA"]
["Contractor Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous",null,null,null,"KS"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"KY"]
["Third Party Payment Release",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,"I request that the incentive check be sent to the third party below",null,null,null,null,"Check here if the third party payee is the contractor (Contractor must be a PNM Authorized Contractor to be eligible for third party payment)",null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
["Name of Third Party*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
["Name of Third Party Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
["Third Party Phone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,null,null,null,null,"MO"]
["Third Party Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
["Third Party City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"NE"]
["Third Party Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
["Third Party Taxpayer ID # (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,null,null,null,null,"NH"]
["Incentive Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
["Total Incentive Requested",null,null,null,null,"Total Project Cost  PRE-TAX * REQUIRED *",null,null,null,{"$f":"IF(O8=TRUE, \"Estimated Project Completion Date\", \"Project Completion Date\")","v":"Project Completion Date"},null,null,null,null,null,null,"NM"]
[{"$f":"MIN(F67, F50*0.5,400000)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
["Incentive requested + 20% Bonus (valid 7/1/2020-12/31/2020 ONLY) \n*Any bonus offers are a limited time only, while funds are available and can be terminated at any time at the Program's discretion. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
[{"$f":"MIN($F$67*1.2, $F$50*0.5,400000)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
["AGREEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
["I understand that in the event funds are reserved based on a pre-notification, the payment of incentives will be based upon the Final Application and program terms and conditions, and that the PNM Business Energy Efficiency program is subject to change or cancellation at any time and without notice. PNM is not responsible for any lost, late, stolen, ineligible, illegible, misdirected or postage-due mail. All completed submissions become the property of PNM and will not be returned. PNM makes no guarantees about the availability of products or rebate forms. By participating in the PNM Business Energy Efficiency program, customers agree to waive any claims and release PNM from any liability for damages of any kind. Rebates are funded by a charge on PNM electric customer bills.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
["I have read and understand the program requirements, measure specifications, and Terms & Conditions set forth in this application and agree to abide by those requirements. Furthermore, I concur that I must meet all eligibility criteria in order to be paid under this program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
["As an eligible customer, I verify that the signature below is my own and that the information is correct. I am requesting consideration for participation under this program. By signing this agreement I attest that I understand and agree to abide by all Program terms and conditions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
["Customer Signature (PNM Customer)",null,null,null,null,null,null,"Third Party Signature",null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,"Please sign by hand or via DocuSign®",null,null,null,null,null,null,null,null,null,null,"SD"]
["Print Customer Name",null,null,null,null,null,null,"Print Third Party Name",null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
["Date",null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,"For Office Use Only",null,null,null,{"$f":"SUM(F68:F80)","v":0},null,null,null,null,null,null,null,null,null,null,"WV"]
[null,"Retrofit Lighting Interior",null,null,null,{"$f":"+Lighting!N17","v":0},null,null,null,null,null,null,null,null,null,null,"WY"]
[null,"Lighting-LED or Fluorescent replacing HID",null,null,null,{"$f":"+Lighting!J30","v":0}]
[null,"Lighting-LED replacing Fluorescent",null,null,null,{"$f":"+Lighting!J74","v":0}]
[null,"Lighting-Controlled LED Fixures",null,null,null,{"$f":"Lighting!F118","v":0}]
[null,"HVAC",null,null,null,{"$f":"+HVAC!H59","v":0}]
[null,"Refrigeration & Window Film",null,null,null,{"$f":"+'Refrigeration & Window Film'!I18+'Refrigeration & Window Film'!I34","v":0}]
[null,"Food Service",null,null,null,{"$f":"'Food Service'!J14","v":0}]
[null,"High Efficiency Ice Makers",null,null,null,{"$f":"+'Food Service'!J26","v":0}]
[null,"Industrial Equipment",null,null,null,{"$f":"'Food Service'!J33","v":0}]
[null,"Motors Incentives",null,null,null,{"$f":"+'Motors & VSDs'!I36","v":0}]
[null,"VSD Incentives",null,null,null,{"$f":"+'Motors & VSDs'!J51","v":0}]
[null,"Custom Incentives",null,null,null,{"$f":"+Custom!I51","v":0}]
[null,"Horticulture Lighting Incentives",null,null,null,{"$f":"+'Horticulture Lighting'!I51","v":0}]

{"sheet":"Checklist","index":2,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,62,9],[0,3,0,6],[49,7,49,8]]}
[null,null,null,"APPLICATION CHECKLIST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"http://www.pnmenergyefficiency.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["APPLICATION CHECKLIST  (CONTINUED)"]

{"sheet":"Terms","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"TERMS & CONDITIONS"]

{"sheet":"Multi-Facility","index":4,"n_rows":401,"n_cols":7,"rows_kept":401,"cut":false,"hidden":false,"merged":[[4,3,4,4],[5,1,5,2],[7,0,7,4],[0,1,0,3]]}
[null,"LIGHTING MULTIPLE FACILITY WORKSHEET"]
["Use this worksheet ONLY if installing the SAME measure in facilities with different service addresses and unique account numbers."]
["If a project encompasses multiple buildings at the same premise, this worksheet is not required."]
["For official use only","Pre-Notification Date:",{"$f":"IF(ISBLANK('Applicant Info'!$K$6),\" \",'Applicant Info'!$K$6)","v":" "},"Final Application Date:",{"$f":"IF(ISBLANK('Applicant Info'!$K$8),\" \",'Applicant Info'!$K$8)","v":" "}]
["Application #",{"$f":"IF('Applicant Info'!J3=\"\",\"\",'Applicant Info'!J3)","v":""},"Business Name:",{"$f":"IF(ISBLANK('Applicant Info'!$A$20),\" \",'Applicant Info'!$A$20)","v":" "}]
["Prepared by:",{"$f":"IF(ISBLANK('Applicant Info'!$A$22),\" \",'Applicant Info'!$A$22)","v":" "},null,"Contact #:",{"$f":"'Applicant Info'!$D$23","v":0}]
[]
["Project Locations "]
["Service Address","Account #","Replacement Equipment Type 1","Replacement Equipment Type 2","Replacement Equipment Qty","Existing Equipment Description","Existing Equipment Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,null,{"$f":"SUM(E10:E34)","v":0},null,{"$f":"SUM(G10:G34)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Measure Type 1"]
["Interior_Lighting"]
["Exterior_Lighting"]
["_24_7_Lighting"]
["Plug_Load_Controls"]
["Custom"]
["HVAC"]
["Envelope"]
["Refrigeration"]
["Food_Service_Equipment"]
["Motors"]
["VSDs"]
[]
["Measure Type 1","Measure Type 2","Unit","Incentive",null,"Measure Type 1"]
["24/7 Lighting","T8, T5 or LED Replacing HID Lamp Only","Watts Reduced",0.25,null,"Interior Lighting"]
["24/7 Lighting","T8, T5 or LED Replacing HID, Entire Fixture","Watts Reduced",0.5,null,"Exterior Lighting"]
["24/7 Lighting","T8, T5 or LED Replacing HID, Retrofit Kit","Watts Reduced",0.3,null,"24/7 Lighting"]
["24/7 Lighting","LED Replacing T5, T8 or T12, Lamp Only","Watts Reduced",0.25,null,"HVAC"]
["24/7 Lighting","LED Replacing T5, T8 or T12, Entire Fixture","Watts Reduced",0.5,null,"Envelope"]
["24/7 Lighting","LED Replacing T5, T8 or T12, Retrofit Kit","Watts Reduced",0.3,null,"Refrigeration"]
["24/7 Lighting","Controls for Existing LED Fixtures","Watts Controlled",0.5,null,"Food Service Equipment"]
["Exterior Lighting","T8, T5 or LED Replacing HID, Lamp Only","Watts Reduced",0.2,null,"Plug Load Controls"]
["Exterior Lighting","T8, T5 or LED Replacing HID, Entire Fixture","Watts Reduced",0.4,null,"Motors"]
["Exterior Lighting","T8, T5 or LED Replacing HID, Retrofit Kit","Watts Reduced",0.25,null,"VSDs"]
["Exterior Lighting","LED Replacing T5, T8 or T12, Lamp Only","Watts Reduced",0.2]
["Exterior Lighting","LED Replacing T5, T8 or T12, Entire Fixture","Watts Reduced",0.4]
["Exterior Lighting","LED Replacing T5, T8 or T12, Retrofit Kit","Watts Reduced",0.25]
["Exterior Lighting","Controls for Existing LED Fixtures","Watts Controlled",0.4]
["Interior Lighting","20W or less LED Lamp replacing Incandescent Lamp ≤ 100W","Lamp",8]
["Interior Lighting","20W or less LED Lamp replacing CFL Lamp ≤ 42W","Lamp",4]
["Interior Lighting","Controls  Occupancy Sensors","Watts Controlled",0.12]
["Interior Lighting","Controls  Daylighting Sensor Controls","Watts Controlled",0.09]
["Interior Lighting","T8, T5 or LED Replacing HID, Lamp Only","Watts Reduced",0.15]
["Interior Lighting","T8, T5 or LED Replacing HID, Entire Fixture","Watts Reduced",0.3]
["Interior Lighting","T8, T5 or LED Replacing HID, Retrofit Kit","Watts Reduced",0.2]
["Interior Lighting","LED Replacing T5, T8 or T12, Lamp Only","Watts Reduced",0.15]
["Interior Lighting","LED Replacing T5, T8 or T12, Entire Fixture","Watts Reduced",0.3]
["Interior Lighting","LED Replacing T5, T8 or T12, Retrofit Kit","Watts Reduced",0.2]
[]
[null,null,"Unit","Incentive"]
["Envelope","Window Film","Sq. Ft. of Glazing",1.2]
[]
[null,null,"Unit","Incentive"]
["Refrigeration","Strip Curtains on Walk-ins and Freezers","Sq. Ft.",3]
["Refrigeration","Night Covers for Displays","Lin. Ft. of Case",10]
["Refrigeration","EC Motor for Reach-in Refrigerator or Freezer Cases","Motor",25]
["Refrigeration","Evaporator Fan Controller - Shade Pole Motor","Motor",40]
["Refrigeration","Anti Sweat Heater Controls","Lin. Ft. of Case",25]
["Refrigeration","LED Refrigeration Case Lighting","Door",40]
["Refrigeration","ENERGY STAR® Solid Door Freezer","Unit",100]
["Refrigeration","ENERGY STAR® Glass Door Freezer","Unit",350]
[]
[null,null,"Unit","Incentive"]
["Food Service Equipment","ENERGY STAR® Steam Cookers","Unit",400]
["Food Service Equipment","Combination Oven","Unit",800]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - 1/2 size","Unit",200]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - 3/4 size","Unit",300]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - Full size","Unit",400]
["Food Service Equipment","ENERGY STAR® Beverage Vending Machine","Unit",80]
["Food Service Equipment","ENERGY STAR® Commercial Vat Fryer","Unit",225]
["Food Service Equipment","ENERGY STAR® Griddle","Unit",125]
[]
[null,null,"Unit","Incentive"]
["High Efficiency Ice Makers","101-200 lbs/24 hours","Unit",100]
["High Efficiency Ice Makers","201-300 lbs/24 hours","Unit",150]
["High Efficiency Ice Makers","301-400 lbs/24 hours","Unit",200]
["High Efficiency Ice Makers","401-500 lbs/24 hours","Unit",250]
["High Efficiency Ice Makers","501-1000 lbs/24 hours","Unit",300]
["High Efficiency Ice Makers","1001-1500 lbs/24 hours","Unit",350]
["High Efficiency Ice Makers",">1500 lbs/24 hours","Unit",400]
[]
[null,null,"Unit","Incentive"]
["Plug Load Controls","Beverage Vending Machine Control","Unit","Contact for offer"]
["Plug Load Controls","Refrigerated Cooler Control","Unit","Contact for offer"]
["Plug Load Controls","Snack Machine Control","Unit","Contact for offer"]
["Plug Load Controls","Plug Load Occupancy Sensors","Unit",25]
[]
[null,null,"Unit","Incentive"]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
[]
[]
[null,null,"Unit","Incentive"]
["VSDs","VSD Size (HP)","Hp",50]
[]
[null,null,"Unit","Incentive"]
["HVAC","HVAC Units, contact for offer","Unit","Contact for offer"]
[]
[null,null,"Unit","Incentive"]
["Custom","Per kWh","kWh",7.4999999999999997E-2]

{"sheet":"Lighting","index":5,"n_rows":320,"n_cols":58,"rows_kept":320,"cut":false,"hidden":false,"merged":[[138,0,139,13],[140,0,141,13],[142,0,143,13],[110,0,110,12],[109,0,109,12],[74,0,74,6],[7,0,7,13],[8,0,8,8],[16,0,16,12],[12,0,12,1],[12,2,12,7],[8,10,8,11],[33,5,33,6],[33,7,33,8],[28,9,28,10],[27,9,27,10],[26,9,26,10],[40,5,40,6],[40,7,40,8],[41,3,41,4],[41,5,41,6],[41,7,41,8],[42,3,42,4],[42,5,42,6],[36,17,36,18],[14,0,14,7],[15,0,15,13],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,1,25,2],[24,9,25,10],[32,3,32,4],[32,5,32,6],[32,7,32,8],[34,3,34,4],[34,5,34,6],[34,7,34,8],[35,3,35,4],[35,5,35,6],[35,7,35,8],[36,3,36,4],[36,5,36,6],[36,7,36,8],[31,7,31,8],[31,5,31,6],[31,3,31,4],[33,3,33,4],[0,12,0,13],[6,0,6,1],[30,0,30,5],[48,0,48,8],[65,0,65,12],[51,3,51,4],[51,5,51,6],[10,0,10,7],[10,10,10,11],[11,0,11,7],[11,10,11,11],[9,0,9,7],[37,3,37,4],[37,5,37,6],[37,7,37,8],[38,3,38,4],[38,5,38,6],[38,7,38,8],[39,3,39,4],[39,5,39,6],[39,7,39,8],[13,10,13,11],[13,0,13,7],[14,10,14,11],[42,7,42,8],[43,3,43,4],[43,5,43,6],[43,7,43,8],[40,3,40,4],[44,3,44,4],[44,5,44,6],[44,7,44,8],[45,3,45,4],[45,5,45,6],[45,7,45,8],[53,5,53,6],[53,7,53,8],[54,3,54,4],[54,5,54,6],[54,7,54,8],[53,3,53,4],[47,0,47,12],[55,5,55,6],[55,7,55,8],[51,7,51,8],[52,3,52,4],[52,5,52,6],[52,7,52,8],[46,3,46,4],[46,5,46,6],[46,7,46,8],[49,3,49,4],[49,5,49,6],[49,7,49,8],[50,3,50,4],[50,5,50,6],[50,7,50,8],[68,1,69,2],[68,3,68,4],[68,5,68,6],[68,7,68,8],[68,9,69,10],[70,1,70,2],[70,9,70,10],[29,9,29,10],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,8],[62,3,62,4],[62,5,62,6],[62,7,62,8],[63,3,63,4],[63,5,63,6],[63,7,63,8],[64,3,64,4],[64,5,64,6],[64,7,64,8],[58,5,58,6],[58,7,58,8],[55,3,55,4],[71,1,71,2],[71,9,71,10],[72,1,72,2],[72,9,72,10],[73,1,73,8],[73,9,73,10],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,3,76,4],[76,5,76,6],[76,7,76,8],[77,3,77,4],[77,5,77,6],[77,7,77,8],[78,3,78,4],[78,5,78,6],[78,7,78,8],[79,3,79,4],[79,5,79,6],[79,7,79,8],[80,3,80,4],[80,5,80,6],[80,7,80,8],[81,3,81,4],[81,5,81,6],[81,7,81,8],[82,3,82,4],[82,5,82,6],[82,7,82,8],[83,3,83,4],[83,5,83,6],[83,7,83,8],[84,3,84,4],[84,5,84,6],[84,7,84,8],[85,3,85,4],[85,5,85,6],[85,7,85,8],[86,3,86,4],[86,5,86,6],[86,7,86,8],[87,3,87,4],[87,5,87,6],[87,7,87,8],[88,3,88,4],[88,5,88,6],[88,7,88,8],[89,3,89,4],[89,5,89,6],[89,7,89,8],[90,3,90,4],[90,5,90,6],[90,7,90,8],[96,7,96,8],[97,3,97,4],[97,5,97,6],[97,7,97,8],[91,0,91,12],[93,3,93,4],[93,5,93,6],[93,7,93,8],[94,3,94,4],[94,5,94,6],[94,7,94,8],[92,0,92,7],[95,3,95,4],[95,5,95,6],[95,7,95,8],[96,3,96,4],[96,5,96,6],[119,3,119,4],[119,5,119,6],[119,7,119,8],[116,1,116,2],[116,5,116,6],[117,5,117,6],[112,1,113,2],[112,3,112,4],[112,5,113,6],[114,1,114,2],[114,5,114,6],[115,1,115,2],[115,5,115,6],[118,0,118,5],[120,3,120,4],[120,5,120,6],[120,7,120,8],[121,3,121,4],[121,5,121,6],[121,7,121,8],[122,3,122,4],[122,5,122,6],[122,7,122,8],[127,3,127,4],[127,5,127,6],[127,7,127,8],[128,3,128,4],[128,5,128,6],[128,7,128,8],[123,3,123,4],[123,5,123,6],[123,7,123,8],[124,3,124,4],[124,5,124,6],[124,7,124,8],[125,3,125,4],[125,5,125,6],[125,7,125,8],[135,0,135,12],[117,1,117,4],[119,12,119,13],[132,3,132,4],[132,5,132,6],[132,7,132,8],[133,3,133,4],[133,5,133,6],[133,7,133,8],[134,3,134,4],[134,5,134,6],[134,7,134,8],[129,3,129,4],[129,5,129,6],[129,7,129,8],[130,3,130,4],[130,5,130,6],[130,7,130,8],[131,3,131,4],[131,5,131,6],[131,7,131,8],[126,3,126,4],[126,5,126,6],[126,7,126,8],[0,0,0,1],[23,0,23,12],[66,0,66,12],[0,3,0,8],[1,3,1,4],[2,3,2,8],[3,3,3,8],[4,3,4,6],[59,3,59,4],[59,5,59,6],[59,7,59,8],[60,3,60,4],[60,5,60,6],[60,7,60,8],[61,3,61,4],[61,5,61,6],[61,7,61,8],[56,3,56,4],[56,5,56,6],[56,7,56,8],[57,3,57,4],[57,5,57,6],[57,7,57,8],[58,3,58,4],[101,3,101,4],[101,5,101,6],[101,7,101,8],[102,3,102,4],[102,5,102,6],[102,7,102,8],[103,3,103,4],[103,5,103,6],[103,7,103,8],[98,3,98,4],[98,5,98,6],[98,7,98,8],[99,3,99,4],[99,5,99,6],[99,7,99,8],[100,3,100,4],[100,5,100,6],[100,7,100,8],[107,3,107,4],[107,5,107,6],[107,7,107,8],[108,3,108,4],[108,5,108,6],[108,7,108,8],[104,3,104,4],[104,5,104,6],[104,7,104,8],[105,3,105,4],[105,5,105,6],[105,7,105,8],[106,3,106,4],[106,7,106,8],[106,5,106,6],[1,0,2,2],[26,16,28,17],[9,16,11,17],[9,19,11,19],[12,19,14,19],[15,19,17,19],[5,2,6,13],[9,23,9,24],[8,23,8,24],[10,23,10,24],[11,23,11,24],[17,23,17,24],[16,23,16,24],[15,23,15,24],[14,23,14,24],[13,23,13,24],[12,23,12,24],[26,20,28,20]]}
[null,null,null,"LIGHTING INCENTIVES FOR RETROFITS"]
["Click a link at right to jump to that section:",null,null,"1. Interior Retrofits"]
[null,null,null,"2. LED Replacing HID (Lamps, Fixtures & Retrofit kits)"]
[null,null,null,"3. LED Replacing T5, T8 or T12 (Lamps, Fixtures & Retrofit Kits)"]
[null,null,null,"4. Controls for Existing LED Fixtures"]
[null,null,"IMPORTANT NOTICE: Only qualified LED lighting is elegible for a rebate. No fluorescent replacements are eligible for rebates."]
["Applicant: fill in gray fields"]
["1. Interior Retrofits"]
["Equipment Type*",null,null,null,null,null,null,null,null,"Incentive","Unit",null,"# of Units","Incentive Subtotal",null,"Cost",null,null,null,{"$f":"1.191","v":1.1910000000000001},null,"Incentive","kWh","Cost/kWh",null,"Proposed","Delta","Incentive W","kWh W"]
["LED Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommend decreasing to these levels",null,null,"Fix to Fix","In",{"$f":"E71*#REF!","v":{"$error":"#REF!"}},{"$f":"E71*3564*T9/1000","v":0},9.4234631038437364E-2,null,{"$f":"V10/W10","v":{"$error":"#REF!"}},{"$f":"X10-Z10","v":{"$error":"#REF!"}},0.29539520823847143,0.28659167344273073]
["20W or less LED Lamp replacing Incandescent Lamp ≤ 100W",null,null,null,null,null,null,null,null,2,"Lamp",null,null,{"$f":"J11*M11","v":0},null,2,null,null,null,null,"Ext",{"$f":"E72*#REF!","v":{"$error":"#REF!"}},{"$f":"E72*4192/1000","v":0},0.11927480916030533,null,{"$error":"#REF!"},{"$error":"#REF!"},0.22773923357591014,0.16414205732482676]
["20W or less LED Lamp replacing CFL Lamp ≤ 42W",null,null,null,null,null,null,null,null,1,"Lamp",null,null,0,null,1,null,null,null,null,24,{"$f":"E73*#REF!","v":{"$error":"#REF!"}},{"$f":"E73*8760/1000","v":0},6.8493150684931503E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},6.0188263316320892E-2,5.9260126587693224E-2]
["Controls                                                                                                                                  ",null,"Watts Controlled Calculator Required - DOWNLOAD HERE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fix to Retro","In",{"$f":"I71*#REF!","v":{"$error":"#REF!"}},{"$f":"I71*3564*T9/1000","v":0},4.7117315519218682E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},4.1395029136537774E-2,5.8900140280927438E-2]
["Occupancy Sensors",null,null,null,null,null,null,null,null,0.15,"Watts Controlled",null,null,{"$f":"J14*M14","v":0},null,0.14234693528845399,null,null,null,null,"Ext",{"$f":"I72*#REF!","v":{"$error":"#REF!"}},{"$f":"I72*4192/1000","v":0},5.9637404580152667E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},5.6339259638688542E-3,5.1853896193481634E-3]
["Daylighting Sensor Controls",null,null,null,null,null,null,null,null,0.09,"Watts Controlled",null,null,{"$f":"J15*M15","v":0},null,null,null,null,null,null,24,{"$f":"I73*#REF!","v":{"$error":"#REF!"}},{"$f":"I73*8760/1000","v":0},3.4246575342465752E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},0.11641011339915397,0.17953448418384541]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L to L","In",{"$f":"G71*#REF!","v":{"$error":"#REF!"}},{"$f":"G71*3564*T9/1000","v":0},3.533798663941401E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},0.12487712779368208,0.16443819468929888]
["Total Retrofit Lighting Incentives (Interior)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N11:N15)","v":0},null,null,{"$f":"N17","v":0},null,null,null,"Ext",{"$f":"G72*#REF!","v":{"$error":"#REF!"}},{"$f":"G72*4192/1000","v":0},4.7709923664122134E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},6.1865669302938655E-3,7.2256297647197388E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"G73*#REF!","v":{"$error":"#REF!"}},{"$f":"G73*8760/1000","v":0},2.8538812785388126E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},2.8818520431191066E-2,5.3394108606867781E-2]
["*Please provide a description of the retrofit, including any lighting layouts, fixture counts or calculation spreadsheets."]
["** A dwelling unit is defined as an interior space that is residential in nature (i.e. hotel rooms, dormitories, retirement and senior"]
[" living communities, etc.). For Multi-family apartments apply through the PNM Multifamily Program."]
["***Watts Reduced = old connected wattage - new connected wattage"]
[]
["2. LED Replacing HID (Lamps, Fixtures & Retrofit kits)"]
[null,"Type of Retrofit",null,"Fixture Replacing Fixture",null,"Lamp Replacing Lamp",null,"Fixture to Retrofit Kit",null,"Total Incentive"]
[null,null,null,"Incentive","Watts Reduced","Incentive","Watts Reduced","Incentive","Watts Reduced"]
[null,"Interior",null,0.4,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B27,$C$33:$C$47,D$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B27,$C$51:$C$65,D$25)","v":0},0.2,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B27,$C$33:$C$47,F$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B27,$C$51:$C$65,F$25)","v":0},0.3,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B27,$C$33:$C$47,H$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B27,$C$51:$C$65,H$25)","v":0},{"$f":"IF(OR(D27*E27+F27*G27+H27*I27<0,$N$66=\"\",$N$66=0), 0, D27*E27+F27*G27+H27*I27)","v":0},null,null,null,null,null,null,"Recommend increasing to these levels"]
[null,"Exterior/12 Hour",null,0.5,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B28,$C$33:$C$47,D$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B28,$C$51:$C$65,D$25)","v":0},0.25,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B28,$C$33:$C$47,F$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B28,$C$51:$C$65,F$25)","v":0},0.35,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B28,$C$33:$C$47,H$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B28,$C$51:$C$65,H$25)","v":0},0]
[null,"24 Hour/Garage/3-Shift",null,1.2,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B29,$C$33:$C$47,D$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B29,$C$51:$C$65,D$25)","v":0},0.6,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B29,$C$33:$C$47,F$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B29,$C$51:$C$65,F$25)","v":0},0.8,{"$f":"SUMIFS($N$33:$N$47,$B$33:$B$47,$B29,$C$33:$C$47,H$25)-SUMIFS($N$51:$N$65,$B$51:$B$65,$B29,$C$51:$C$65,H$25)","v":0},{"$f":"IF(OR(D29*E29+F29*G29+H29*I29<0,$N$66=\"\",$N$66=0), 0, D29*E29+F29*G29+H29*I29)","v":0}]
[null,"TOTAL NEW High Efficiency LED fixture replacing HID Fixture",null,null,null,null,null,null,null,{"$f":"SUM(J27:K29)","v":0},null,null,null,null,null,null,{"$f":"J30","v":0}]
["Existing equipment: HID fixtures and/or lamps being removed"]
["#","Measure Type","Retrofit Type","Fixture Type",null,"Ballast Type",null,"Description",null,"Lamps/ Fixture","Lamp Wattage","Fixture Quantity","Fixture Wattage","Base Watts"]
[1,null,null,null,null,null,null,null,null,{"$f":"IF($H33=\"\",\"\",VLOOKUP($H33,$BB:$BF,3,FALSE))","v":""},{"$f":"IF($H33=\"\",\"\",VLOOKUP($H33,$BB:$BF,4,FALSE))","v":""},null,{"$f":"IF($H33=\"\",\"\",VLOOKUP($H33,$BB:$BF,5,FALSE))","v":""},{"$f":"IF((IF($H33=\"\",\"\",M33*L33))=0,\"Missing Value\",(IF($H33=\"\",\"\",M33*L33)))","v":""}]
[2,null,null,null,null,null,null,null,null,"","",null,"",""]
[3,null,null,null,null,null,null,null,null,"","",null,"",""]
[4,null,null,null,null,null,null,null,null,"","",null,"",""]
[5,null,null,null,null,null,null,null,null,"","",null,"",""]
[6,null,null,null,null,null,null,null,null,"","",null,"",""]
[7,null,null,null,null,null,null,null,null,"","",null,"",{"$f":"IF((IF($H39=\"\",\"\",M39*L39))=0,\"Missing Value\",(IF($H39=\"\",\"\",M39*L39)))","v":""}]
[8,null,null,null,null,null,null,null,null,"","",null,"",""]
[9,null,null,null,null,null,null,null,null,"","",null,"",""]
[10,null,null,null,null,null,null,null,null,"","",null,"",""]
[11,null,null,null,null,null,null,null,null,"","",null,"",""]
[12,null,null,null,null,null,null,null,null,"","",null,"",""]
[13,null,null,null,null,null,null,null,null,"","",null,"",""]
[14,null,null,null,null,null,null,null,null,"","",null,"",""]
[15,null,null,null,null,null,null,null,null,"","",null,"",""]
["Subtotal HID Base Case Wattage",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N33:N47)=0,\"\",SUM(N33:N47))","v":""}]
["Replacement equipment: New LED lamps, fixtures, or fixture retrofit kit being installed"]
["#","Measure Type","Retrofit Type","Fixture Type",null,"Fixture or Ballast   Sub Type",null,"Description (type in model number)",null,"Lamps/ Fixture","Lamp Wattage","Fixture Quantity","Fixture Wattage","Installed Watts"]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H51=\"\",\"\",J51*K51)","v":""},{"$f":"IF((IF($H51=\"\",\"\",M51*L51))=0,\"Missing Value\",(IF($H51=\"\",\"\",M51*L51)))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,"",""]
[3,null,null,null,null,null,null,null,null,null,null,null,"",""]
[4,null,null,null,null,null,null,null,null,null,null,null,"",""]
[5,null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,null,null,null,null,null,null,null,null,null,null,"",""]
[9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H59=\"\",\"\",J59*K59)","v":""},{"$f":"IF((IF($H59=\"\",\"\",M59*L59))=0,\"Missing Value\",(IF($H59=\"\",\"\",M59*L59)))","v":""}]
[10,null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Subtotal Installed T8, T5, or LED Wattage",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N51:N65)=0,\"\",SUM(N51:N65))","v":""}]
["3. LED Replacing T5, T8 or T12 (Lamps, Fixtures & Retrofit Kits)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ranges and lookup values for calculated lighting tables. Use caution when editing ranges that are used for data validation lists"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tips: no symbols allowed, no spaces allowed unless removed with substitute function, any change to a range could delete it, so it must be re-created, use ctrl shift F3 to create a range, range name must begin and end with a letter and no spaces)"]
[null,"Type of Retrofit",null,"Fixture Replacing Fixture",null,"Lamp Replacing Lamp",null,"Fixture to Retrofit Kit",null,"Total Incentive",null,null,null,null,null,null,null,"TABLE 1: EXISTING HID"]
[null,null,null,"Incentive","Watts Reduced","Incentive","Watts Reduced","Incentive","Watts Reduced",null,null,null,null,null,null,null,null,"Measure Type",null,"1. Retrofit Type",null,null,null,null,"2. Fixture Type",null,null,null,null,"3. Ballast Type",null,null,null,null,null,null,null,null,null,"4. Description",null,null,null,null,null,null,null,null,null,null,null,null,"5. Description lookup (all measures)"]
[null,"Interior",null,0.4,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B71,$C$77:$C$91,D$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B71,$C$95:$C$109,D$69)","v":0},0.2,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B71,$C$77:$C$91,F$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B71,$C$95:$C$109,F$69)","v":0},0.3,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B71,$C$77:$C$91,H$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B71,$C$95:$C$109,H$69)","v":0},{"$f":"IF(OR($D71*$E71+$F71*$G71+$H71*$I71<0,$N$110=\"\",$N$110=0), 0,$D71* $E71+$F71*$G71+$H71*$I71)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDFixturereplacingFixture","HIDLampreplacingLamp","HIDFixturetoRetrofitKit",null,null,"CFL","HPS","I/H","MV","MH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE","DESCRIPTION","Ballast Type","LAMP / FIXTURE","WATT / LAMP","WATT / FIXTURE"]
[null,"Exterior/12 Hour",null,0.5,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B72,$C$77:$C$91,D$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B72,$C$95:$C$109,D$69)","v":0},0.25,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B72,$C$77:$C$91,F$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B72,$C$95:$C$109,F$69)","v":0},0.35,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B72,$C$77:$C$91,H$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B72,$C$95:$C$109,H$69)","v":0},{"$f":"IF(OR($D72*$E72+$F72*$G72+$H72*$I72<0,$N$110=\"\",$N$110=0), 0,$D72* $E72+$F72*$G72+$H72*$I72)","v":0},null,null,null,null,null,null,null,"MeasureType",null,"1. Retrofit Type",null,null,null,null,"CFL","CFL","CFL",null,null,"HIDCFL","HIDHighPressureSodium","HIDIncanorHalogen","HIDMercuryVapor","HIDMetalHalide",null,null,null,null,null,"HighPressureSodiumMagnetic","IncanorHalogenNone",null,"MercuryVaporMagnetic","MetalHalideElectronic","MetalHalideMagnetic","FixturetoRetrofitKitFixturetoRetrofitKit","CFLNone",null,null,null,null,null,"CFL","25 Watt Compact Fluorescent","None",1,25,25]
[null,"24 Hour/Garage/3-Shift",null,1.2,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B73,$C$77:$C$91,D$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B73,$C$95:$C$109,D$69)","v":0},0.6,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B73,$C$77:$C$91,F$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B73,$C$95:$C$109,F$69)","v":0},0.8,{"$f":"SUMIFS($N$77:$N$91,$B$77:$B$91,$B73,$C$77:$C$91,H$69)-SUMIFS($N$95:$N$109,$B$95:$B$109,$B73,$C$95:$C$109,H$69)","v":0},0,null,null,null,null,null,null,null,"Interior",null,"Fixture replacing Fixture",null,null,null,null,"High Pressure Sodium","High Pressure Sodium","High Pressure Sodium",null,null,"None","Magnetic","None","Magnetic","Magnetic",null,null,null,null,null,"35 Watt HPS Lamp, Magnetic ballast","110 Watt Incandescent or Halogen Lamp",null,"40 Watt MV Lamp","20 Watt MH Lamp, Electronic Ballast","32 Watt MH Lamp, Magnetic ballast","Fixture to Retrofit Kit","25 Watt Compact Fluorescent",null,null,null,null,null,"CFL","30 Watt Compact Fluorescent","None",1,30,30]
[null,"TOTAL NEW LED replacing T5, T8, or T12 Fixture",null,null,null,null,null,null,null,{"$f":"SUM(J71:K73)","v":0},null,null,null,null,null,null,{"$f":"J74","v":0},"Exterior/12 Hour",null,"Lamp replacing Lamp",null,null,null,null,"Incan or Halogen","Incan or Halogen","Incan or Halogen",null,null,null,null,null,null,"Electronic",null,null,null,null,null,"50 Watt HPS Lamp, Magnetic ballast","116 Watt Incandescent or Halogen Lamp",null,"50 Watt MV Lamp","22 Watt MH Lamp, Electronic Ballast","39 Watt MH Lamp, Magnetic ballast",null,"30 Watt Compact Fluorescent",null,null,null,null,null,"CFL","35 Watt Compact Fluorescent","None",1,35,35]
["Existing equipment: T5, T8 or T12 fixtures and/or lamps being removed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24 Hour/Garage/3-Shift",null,"Fixture to Retrofit Kit",null,null,null,null,"Mercury Vapor","Mercury Vapor","Mercury Vapor",null,null,null,null,null,null,null,null,null,null,null,null,"70 Watt HPS Lamp, Magnetic ballast","120 Watt Incandescent or Halogen Lamp",null,"75 Watt MV Lamp","39 Watt MH Lamp, Electronic Ballast","50 Watt MH Lamp, Magnetic ballast",null,"35 Watt Compact Fluorescent",null,null,null,null,null,"CFL","40 Watt Compact Fluorescent","None",1,40,40]
["#","Measure Type","Retrofit Type","Fixture Type",null,"Ballast Type",null,"Description",null,"Lamps/ Fixture","Lamp Wattage","Fixture Quantity","Fixture Wattage","Base Watts",null,null,null,null,null,null,null,null,null,null,"Metal Halide","Metal Halide","Metal Halide",null,null,null,null,null,null,null,null,null,null,null,null,"100 Watt HPS Lamp, Magnetic ballast","125 Watt Incandescent or Halogen Lamp",null,"100 Watt MV Lamp","50 Watt MH Lamp, Electronic Ballast","70 Watt MH Lamp, Magnetic ballast",null,"40 Watt Compact Fluorescent",null,null,null,null,null,"CFL","45 Watt Compact Fluorescent","None",1,45,45]
[1,null,null,null,null,null,null,null,null,{"$f":"IF($H77=\"\",\"\",VLOOKUP($H77,$BB:$BF,3,FALSE))","v":""},{"$f":"IF($H77=\"\",\"\",VLOOKUP($H77,$BB:$BF,4,FALSE))","v":""},null,{"$f":"IF($H77=\"\",\"\",VLOOKUP($H77,$BB:$BF,5,FALSE))","v":""},{"$f":"IF((IF($H77=\"\",\"\",M77*L77))=0,\"Missing Value\",(IF($H77=\"\",\"\",M77*L77)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 Watt HPS Lamp, Magnetic ballast","130 Watt Incandescent or Halogen Lamp",null,"160 Watt MV self-ballasted Lamp","70 Watt MH Lamp, Electronic Ballast","100 Watt MH Lamp, Magnetic ballast",null,"45 Watt Compact Fluorescent",null,null,null,null,null,"CFL","50 Watt Compact Fluorescent","None",1,50,50]
[2,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 Watt HPS Lamp, Magnetic ballast","135 Watt Incandescent or Halogen Lamp",null,"175 Watt MV Lamp","100 Watt MH Lamp, Electronic Ballast","125 Watt MH Lamp, Magnetic ballast",null,"50 Watt Compact Fluorescent",null,null,null,null,null,"CFL","55 Watt Compact Fluorescent","None",1,55,55]
[3,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"250 Watt HPS Lamp, Magnetic ballast","150 Watt Incandescent or Halogen Lamp",null,"250 Watt MV Lamp","150 Watt MH Lamp, Electronic Ballast","150 Watt MH Lamp, Magnetic Ballast",null,"55 Watt Compact Fluorescent",null,null,null,null,null,"CFL","60 Watt Compact Fluorescent","None",1,60,60]
[4,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"310 Watt HPS Lamp, Magnetic ballast","160 Watt Incandescent or Halogen Lamp",null,"400 Watt MV Lamp","175 Watt MH Lamp, Electronic Ballast","175 Watt MH Lamp, Magnetic ballast",null,"60 Watt Compact Fluorescent",null,null,null,null,null,"CFL","65 Watt Compact Fluorescent","None",1,65,65]
[5,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"360 Watt HPS Lamp, Magnetic ballast","170 Watt Incandescent or Halogen Lamp",null,"700 Watt MV Lamp","200 Watt MH Lamp, Electronic Ballast","200 Watt MH Lamp, Magnetic ballast",null,"65 Watt Compact Fluorescent",null,null,null,null,null,"CFL","70 Watt Compact Fluorescent","None",1,70,70]
[6,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400 Watt HPS Lamp, Magnetic ballast","200 Watt Incandescent or Halogen Lamp",null,"1000 Watt MV Lamp","250 Watt MH Lamp, Electronic Ballast","250 Watt MH Lamp, Magnetic ballast",null,"70 Watt Compact Fluorescent",null,null,null,null,null,"CFL","75 Watt Compact Fluorescent","None",1,75,75]
[7,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 Watt HPS Lamp, Magnetic ballast","250 Watt Incandescent or Halogen Lamp",null,null,"320 Watt MH Lamp, Electronic Ballast","320 Watt MH Lamp, Magnetic ballast",null,"75 Watt Compact Fluorescent",null,null,null,null,null,"CFL","80 Watt Compact Fluorescent","None",1,80,80]
[8,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300 Watt Incandescent or Halogen Lamp",null,null,"350 Watt MH Lamp, Electronic Ballast","350 Watt MH Lamp, Magnetic ballast",null,"80 Watt Compact Fluorescent",null,null,null,null,null,"CFL","85 Watt Compact Fluorescent","None",1,85,85]
[9,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400 Watt Incandescent or Halogen Lamp",null,null,"400 Watt MH Lamp, Electronic Ballast","360 Watt MH Lamp, Magnetic ballast",null,"85 Watt Compact Fluorescent",null,null,null,null,null,"CFL","90 Watt Compact Fluorescent","None",1,90,90]
[10,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"448 Watt Incandescent or Halogen Lamp",null,null,"450 Watt MH Lamp, Electronic Ballast","400 Watt MH Lamp, Magnetic ballast",null,"90 Watt Compact Fluorescent",null,null,null,null,null,"CFL","95 Watt Compact Fluorescent","None",1,95,95]
[11,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500 Watt Incandescent or Halogen Lamp",null,null,null,"450 Watt MH Lamp, Magnetic ballast",null,"95 Watt Compact Fluorescent",null,null,null,null,null,"CFL","100 Watt Compact Fluorescent","None",1,100,100]
[12,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"750 Watt Incandescent or Halogen Lamp",null,null,null,"750 Watt MH Lamp, Magnetic ballast",null,"100 Watt Compact Fluorescent",null,null,null,null,null,"CFL","105 Watt Compact Fluorescent","None",1,105,105]
[13,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,"TABLE 2: REPLACEMENT FROM HID",null,null,null,null,null,null,"2. Fixture Type",null,null,null,null,"3. Ballast Type",null,null,null,null,null,null,null,null,null,null,"1000 Watt Incandescent or Halogen Lamp",null,null,null,"1000 Watt MH Lamp, Magnetic ballast",null,"105 Watt Compact Fluorescent",null,null,null,null,null,"CFL","110 Watt Compact Fluorescent","None",1,110,110]
[14,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,"RFixturereplacingFixture","RLampreplacingLamp","RFixturetoRetrofitKit",null,null,"RT5R","RT8R","RFUTT8R","RLEDR","RRetrofitKitR",null,null,null,null,null,null,"1500 Watt Incandescent or Halogen Lamp",null,null,null,"1500 Watt MH Lamp, Magnetic ballast",null,"110 Watt Compact Fluorescent",null,null,null,null,null,"High Pressure Sodium","35 Watt HPS Lamp, Magnetic ballast","Magnetic",1,35,46]
[15,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,"LED","LED","Retrofit Kit",null,null,"PRS Elec","Electronic HO","Electronic","Flood and Spot LEDs Over 20W","LED Retrofit Kit",null,null,null,null,null,null,"2000 Watt Incandescent or Halogen Lamp",null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","50 Watt HPS Lamp, Magnetic ballast","Magnetic",1,50,66]
["Subtotal HID Base Case Wattage",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N77:N91)=0,\"\",SUM(N77:N91))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic Std","Electronic HO","Downlight Can Fixture Over 20W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","70 Watt HPS Lamp, Magnetic ballast","Magnetic",1,70,95]
["Replacement equipment: LED lamps, fixtures, or fixture retrofit kits being installed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Pole/Arm-Mounted Area LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","100 Watt HPS Lamp, Magnetic ballast","Magnetic",1,100,138]
["#","Measure Type","Retrofit Type","Fixture Type",null,"LED Fixture Sub Type",null,"Description (type in model number)",null,"Lamps/ Fixture","Lamp Wattage","Fixture Quantity","Fixture Wattage","Installed Watts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Wall-Mounted Area LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","150 Watt HPS Lamp, Magnetic ballast","Magnetic",1,150,188]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H95=\"\",\"\",J95*K95)","v":""},{"$f":"IF((IF($H95=\"\",\"\",M95*L95))=0,\"Missing Value\",(IF($H95=\"\",\"\",M95*L95)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Pump Canopy LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","200 Watt HPS Lamp, Magnetic ballast","Magnetic",1,200,250]
[2,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking Garage LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","250 Watt HPS Lamp, Magnetic ballast","Magnetic",1,250,295]
[3,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Bay LEDs ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","310 Watt HPS Lamp, Magnetic ballast","Magnetic",1,310,365]
[4,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low-Bay LEDs ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","360 Watt HPS Lamp, Magnetic ballast","Magnetic",1,360,414]
[5,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indoor Wall-Mounted Area LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","400 Watt HPS Lamp, Magnetic ballast","Magnetic",1,400,465]
[6,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stairwell and Passageway LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure Sodium","1000 Watt HPS Lamp, Magnetic ballast","Magnetic",1,1000,1100]
[7,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","110 Watt Incandescent or Halogen Lamp","None",1,110,110]
[8,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bollards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","116 Watt Incandescent or Halogen Lamp","None",1,116,116]
[9,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Display Case LEDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","120 Watt Incandescent or Halogen Lamp","None",1,120,120]
[10,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1x4 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","125 Watt Incandescent or Halogen Lamp","None",1,125,125]
[11,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x2 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","130 Watt Incandescent or Halogen Lamp","None",1,130,130]
[12,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x4 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","135 Watt Incandescent or Halogen Lamp","None",1,135,135]
[13,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1x8 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","150 Watt Incandescent or Halogen Lamp","None",1,150,150]
[14,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","160 Watt Incandescent or Halogen Lamp","None",1,160,160]
[15,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","170 Watt Incandescent or Halogen Lamp","None",1,170,170]
["Subtotal Installed LED Wattage",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N95:N109)=0,\"\",SUM(N95:N109))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","200 Watt Incandescent or Halogen Lamp","None",1,200,200]
["4. Controls for Existing LED Fixtures (Refer to Section 1 for Interior Controls)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","250 Watt Incandescent or Halogen Lamp","None",1,250,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","300 Watt Incandescent or Halogen Lamp","None",1,300,300]
[null,"Type of Retrofit",null,"Controlled Fixture",null,"Total Incentive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","400 Watt Incandescent or Halogen Lamp","None",1,400,400]
[null,null,null,"Incentive","Watts Reduced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Fixture Type",null,null,null,null,"3. Ballast Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","448 Watt Incandescent or Halogen Lamp","None",1,448,448]
[null,"Interior",null,"NA",null,null,null,null,null,null,null,null,null,null,null,null,null,"TMeasureType",null,"TRetrofitType",null,null,null,null,"TFixturereplacingFixture","TLampreplacingLamp","TFixturetoRetrofitKit",null,null,"FUT12","FUT8","T12","T8","F2RK","T5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incan or Halogen","500 Watt Incandescent or Halogen Lamp","None",1,500,500]
[null,"Exterior/12 Hour",null,0.4,{"$f":"SUMIFS($N$121:$N$135,$B$121:$B$135,$B116,$D$121:$D$135,D$113)","v":0},{"$f":"D116*E116","v":0},null,null,null,null,null,null,null,null,null,null,null,"Interior",null,"Fixture replacing Fixture",null,null,null,null,"T5","T5","T5",null,null,"TFUT12T","TFUT8T","TT12T","TT8T","TFixturetoRetrofitKitT","TT5T",null,null,null,null,"FUT12Magnetic","FUT8Electronic","FUT8ElectronicHO","T12Magnetic","T8ElectronicHO","T8ElectronicStd","T5PRSElec",null,null,null,null,null,null,"Incan or Halogen","750 Watt Incandescent or Halogen Lamp","None",1,750,750]
[null,"24 Hour/Garage/3-Shift",null,0.5,{"$f":"SUMIFS($N$121:$N$135,$B$121:$B$135,$B117,$D$121:$D$135,D$113)","v":0},{"$f":"D117*E117","v":0},null,null,null,null,null,null,null,null,null,null,null,"Exterior/12 Hour",null,"Lamp replacing Lamp",null,null,null,null,"T8","T8","T8",null,null,"Magnetic","Electronic","Magnetic","Electronic HO","Fixture to Retrofit Kit","PRS Elec",null,null,null,null,"(1) U-Tube, T12 STD Lamp, STD Mag Ballast, 34 Watt Lamps","(1) U-Tube, T8 Standard ballast, 32 Watt Lamp","(1) U-Tube, T8 High Output Ballast, 32 Watt Lamp","(1) 24\" T12, STD Lamps, 20 Watt Lamps","(1) 24\", T8, High Output Ballast, 17 Watt Lamps","(1) 24\", T8, Std Elec Ballast, 17 Watt Lamps","(1) 22\" T-5 14W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Incan or Halogen","1000 Watt Incandescent or Halogen Lamp","None",1,1000,1000]
[null,"Controls on Existing LED Fixtures",null,null,null,{"$f":"SUM(F115:G117)","v":0},null,null,null,null,null,null,null,null,null,null,null,"24 Hour/Garage/3-Shift",null,"Fixture to Retrofit Kit",null,null,null,null,"T12","T12","T12",null,null,null,"Electronic HO",null,"Electronic Std",null,null,null,null,null,null,"(1) U-Tube, T12 STD Lamp, STD Mag Ballast, 40 Watt Lamps","(2) U-Tube, T8 Standard ballast, 32 Watt Lamp","(2) U-Tube, T8 High Output Ballast, 32 Watt Lamp","(1) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","(1) 36\", T8, High Output Ballast, 25 Watt Lamps","(1) 36\", T8, Std Elec Ballast, 25 Watt Lamps","(1) 22\" T-5 24W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1)",null,null,null,null,null,null,"Incan or Halogen","1500 Watt Incandescent or Halogen Lamp","None",1,1500,1500]
["Controlled Existing LED Fixture with High and Low Settings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F118","v":0},null,null,null,null,null,null,null,"FUT8","FUT8","FUT8",null,null,null,null,null,null,null,null,null,null,null,null,"(2) U-Tube, T12 STD Lamp, STD Mag Ballast, 34 Watt Lamps",null,null,"(1) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","(1) 48\", T8,  High Output Ballast, 28 Watt Lamps","(1) 48\", T8, Std Ballast, 25 Watt Lamps","(1) 34\" T-5 21W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Incan or Halogen","2000 Watt Incandescent or Halogen Lamp","None",1,2000,2000]
["#","Measure Type","Retrofit Type","Fixture Type",null,"Sub Type",null,"Description (type in)",null,"Fixture Quantity","High Setting Wattage","Low Setting Wattage","Weighted Average Watts Reduced",null,null,null,null,null,null,null,null,null,null,null,"FUT12","FUT12","FUT12",null,null,null,null,null,null,null,null,null,null,null,null,"(2) U-Tube, T12 STD Lamp, STD Mag Ballast, 40 Watt Lamps",null,null,"(1) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","(1) 48\", T8, High Output Ballast, 25 Watt Lamps","(1) 48\", T8, Std Ballast, 28 Watt Lamps","(1) 34\" T-5 39W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","40 Watt MV Lamp","Magnetic",1,40,50]
[1,null,{"$f":"IFERROR(VLOOKUP($B121,$R$170:$U$172,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B121,$R$170:$U$172,4,FALSE),\"\")","v":""},{"$f":"VLOOKUP($B121,$R$170:$U$172,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"IF((IF($H121=\"\",\"\",(ROUND(((K121-L121)*0.85*J121),0))))=0,\"Missing Value\",(IF($H121=\"\",\"\",(ROUND(((K121-L121)*0.85*J121),0)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","(1) 48\", T8, High Output Ballast, 32 Watt Lamps","(1) 48\", T8, Std Ballast, 32 Watt Lamps","(1) 45.8\" T-5 28W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","50 Watt MV Lamp","Magnetic",1,50,74]
[2,null,"","",{"$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,"(1) 48\" T12, HO Lamps, 60 Watt Lamps","(1) 96\", T8, High Output Ballast, 57 Watt Lamps","(1) 96\", T8 Std Ballast, 57 Watt Lamps","(1) 45.8\" T-5 54W HO Lamps (1) Prog RS Ballast, HLO(.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","75 Watt MV Lamp","Magnetic",1,75,93]
[3,null,"","",{"$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,"(1) 72\" T12, HO Lamps, 85 Watt Lamps","(1) 96\", T8, High Output Ballast, 59 Watt Lamps","(1) 96\", T8 Std Ballast, 59 Watt Lamps","(1) 57.6\" T-5 35W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","100 Watt MV Lamp","Magnetic",1,100,125]
[4,null,"","",{"$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,"(1) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","(1) 96\", T8, High Output Ballast, 86 Watt Lamps","(1) 96\", T8 Std Ballast, 86 Watt Lamps","(1) 57.6\" T-5 80W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","160 Watt MV self-ballasted Lamp","Magnetic",1,160,160]
[5,null,"","",{"$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,"(1) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","(2) 24\", T8, High Output Ballast, 17 Watt Lamps","(2) 24\", T8, Std Elec Ballast, 17 Watt Lamps","(10) 45.8\" T-5 54W HO Lamps (5) Prog RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","175 Watt MV Lamp","Magnetic",1,175,205]
[6,null,"","",{"$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,"(1) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","(2) 36\", T8, High Output Ballast, 25 Watt Lamps","(2) 36\", T8, Std Elec Ballast, 25 Watt Lamps","(12) 45.8\" T-5 54W HO Lamps (6) Prog RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","250 Watt MV Lamp","Magnetic",1,250,290]
[7,null,"","",{"$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,"(1) 108\" T12 F108, HO Lamps, 124 Watt Lamps","(2) 48\", T8,  High Output Ballast, 28 Watt Lamps","(2) 48\", T8, Std Ballast, 25 Watt Lamps","(2) 22\" T-5 14W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","400 Watt MV Lamp","Magnetic",1,400,455]
[8,null,"","",{"$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,"(1) 114\" T12 F117, HO Lamps, 132 Watt Lamps","(2) 48\", T8, High Output Ballast, 25 Watt Lamps","(2) 48\", T8, Std Ballast, 28 Watt Lamps","(2) 22\" T-5 24W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1)",null,null,null,null,null,null,"Mercury Vapor","700 Watt MV Lamp","Magnetic",1,700,780]
[9,null,"","",{"$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,"(2) 24\" T12, STD Lamps, 20 Watt Lamps","(2) 48\", T8, High Output Ballast, 32 Watt Lamps","(2) 48\", T8, Std Ballast, 32 Watt Lamps","(2) 34\" T-5 21W Lamps (1) Prog.Start or PRS Ballast HLO (.95<BF<1.1)",null,null,null,null,null,null,"Mercury Vapor","1000 Watt MV Lamp","Magnetic",1,1000,1075]
[10,null,"","",{"$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,"(2) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","(2) 96\", T8, High Output Ballast, 57 Watt Lamps","(2) 96\", T8 Std Ballast, 57 Watt Lamps","(2) 34\" T-5 39W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","20 Watt MH Lamp, Electronic Ballast","Electronic",1,20,24]
[11,null,"","",{"$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,"(2) 40\" T12 F42, HO Lamps, 55 Watt Lamps","(2) 96\", T8, High Output Ballast, 59 Watt Lamps","(2) 96\", T8 Std Ballast, 59 Watt Lamps","(2) 45.8\" T-5 28W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","22 Watt MH Lamp, Electronic Ballast","Electronic",1,22,26]
[12,null,"","",{"$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,"(2) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","(2) 96\", T8, High Output Ballast, 86 Watt Lamps","(2) 96\", T8 Std Ballast, 86 Watt Lamps","(2) 45.8\" T-5 49W HO Lamps, (1) Prog Start or RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","39 Watt MH Lamp, Electronic Ballast","Electronic",1,39,44]
[13,null,"","",{"$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,"(2) 48\" T12, HO Lamps, 60 Watt Lamps","(3) 24\", T8, High Output Ballast, 17 Watt Lamps","(3) 24\", T8, Std Elec Ballast, 17 Watt Lamps","(2) 45.8\" T-5 54W HO Lamps (1) Prog RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","50 Watt MH Lamp, Electronic Ballast","Electronic",1,50,56]
[14,null,"","",{"$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,"(2) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","(3) 36\", T8, High Output Ballast, 25 Watt Lamps","(3) 36\", T8, Std Elec Ballast, 25 Watt Lamps","(2) 57.6\" T-5 35W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","70 Watt MH Lamp, Electronic Ballast","Electronic",1,70,78]
[15,null,"","",{"$error":"#N/A"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"2. Fixture Type",null,null,null,null,"3. Ballast Type",null,null,null,null,null,null,null,null,null,null,null,null,"(2) 72\" T12, HO Lamps, 85 Watt Lamps","(3) 48\", T8,  High Output Ballast, 28 Watt Lamps","(3) 48\", T8, Std Ballast, 25 Watt Lamps","(2) 57.6\" T-5 80W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","100 Watt MH Lamp, Electronic Ballast","Electronic",1,100,109]
["Subtotal Controls on LED Fixtures",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N121:N135)=0,\"\",SUM(N121:N135))","v":""},null,null,null,null,null,null,null,null,null,null,"RTFixturereplacingFixture","RTLampreplacingLamp","RTFixturetoRetrofitKit",null,null,"RTLEDR","RTRetrofitKitR",null,null,null,null,null,null,null,null,null,null,null,"(2) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","(3) 48\", T8, High Output Ballast, 25 Watt Lamps","(3) 48\", T8, Std Ballast, 28 Watt Lamps","(3) 22\" T-5 14W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","150 Watt MH Lamp, Electronic Ballast","Electronic",1,150,163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED","LED","Retrofit Kit",null,null,"Flood and Spot LEDs Over 20W","LED Retrofit Kit",null,null,null,null,null,null,null,null,null,null,null,"(2) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","(3) 48\", T8, High Output Ballast, 32 Watt Lamps","(3) 48\", T8, Std Ballast, 32 Watt Lamps","(3) 22\" T-5 24W HO Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","175 Watt MH Lamp, Electronic Ballast","Electronic",1,175,191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downlight Can Fixture Over 20W",null,null,null,null,null,null,null,null,null,null,null,null,"(2) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","(3) 96\", T8, High Output Ballast, 57 Watt Lamps","(3) 96\", T8 Std Ballast, 57 Watt Lamps","(3) 34\" T-5 21W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","200 Watt MH Lamp, Electronic Ballast","Electronic",1,200,216]
["IMPORTANT NOTICE: Only qualified LED lighting is elegible for a rebate. No fluorescent replacements are eligible for rebates.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking Garage LEDs",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","(4) 36\", T8, High Output Ballast, 25 Watt Lamps","(4) 36\", T8, Std Elec Ballast, 25 Watt Lamps","(3) 45.8\" T-5 54W HO Lamps, Prog RS (2) Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","250 Watt MH Lamp, Electronic Ballast","Electronic",1,250,266]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Bay LEDs ",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","(4) 48\", T8,  High Output Ballast, 28 Watt Lamps","(4) 48\", T8, Std Ballast, 25 Watt Lamps","(3) 57.6\" T-5 35W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","400 Watt MH Lamp, Electronic Ballast","Electronic",1,400,424]
["Lighting Scope of Work is REQUIRED for all lighting measures.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low-Bay LEDs ",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","(4) 48\", T8, High Output Ballast, 25 Watt Lamps","(4) 48\", T8, Std Ballast, 28 Watt Lamps","(4) 22\" T-5 14W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","450 Watt MH Lamp, Electronic Ballast","Electronic",1,450,465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indoor Wall-Mounted Area LEDs",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","(4) 48\", T8, High Output Ballast, 32 Watt Lamps","(4) 48\", T8, Std Ballast, 32 Watt Lamps","(4) 22\" T-5 24W HO Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","32 Watt MH Lamp, Magnetic ballast","Magnetic",1,32,42]
["In no case will the program pay a rebate for lamps and retrofit kits that have been installed in fixtures with cracked, broken or yellowed lenses.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stairwell and Passageway LEDs",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","(4) 96\", T8, High Output Ballast, 57 Watt Lamps","(4) 96\", T8 Std Ballast, 25 Watt Lamps","(4) 34\" T-5 39W HO Lamps (2 )Prog.Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","39 Watt MH Lamp, Magnetic ballast","Magnetic",1,39,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bollards",null,null,null,null,null,null,null,null,null,null,null,null,"(3) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","(4) 96\", T8, High Output Ballast, 59 Watt Lamps","(4) 96\", T8 Std Ballast, 57 Watt Lamps","(4) 34\" T-5 39W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","50 Watt MH Lamp, Magnetic ballast","Magnetic",1,50,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Display Case LEDs",null,null,null,null,null,null,null,null,null,null,null,null,"(4) 24\" T12, STD Lamps, 20 Watt Lamps","(4) 96\", T8, High Output Ballast, 86 Watt Lamps","(4) 96\", T8 Std Ballast, 59 Watt Lamps","(4) 45.8\" T-5 28W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","70 Watt MH Lamp, Magnetic ballast","Magnetic",1,70,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1x4 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,"(4) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","(6) 48\", T8,  High Output Ballast, 28 Watt Lamps","(4) 96\", T8 Std Ballast, 86 Watt Lamps","(4) 45.8\" T-5 49W HO Lamps, (2) Prog Start or RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","100 Watt MH Lamp, Magnetic ballast","Magnetic",1,100,127]
["1. Lighting Retrofit Specifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x2 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,"(4) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","(6) 48\", T8, High Output Ballast, 32 Watt Lamps","(6) 48\", T8, Std Ballast, 28 Watt Lamps","(4) 45.8\" T-5 54W HO Lamps, (2) Prog RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","125 Watt MH Lamp, Magnetic ballast","Magnetic",1,125,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x4 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,"(4) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","(6) 96\", T8, High Output Ballast, 57 Watt Lamps","(6) 48\", T8, Std Ballast, 32 Watt Lamps","(4) 45.8\" T-5 54W HO Lamps, (2) Prog RS Ballast, HLO (.95<BF<1.1), alt 1",null,null,null,null,null,null,"Metal Halide","150 Watt MH Lamp, Magnetic Ballast","Magnetic",1,150,184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1x8 Luminaires",null,null,null,null,null,null,null,null,null,null,null,null,"(4) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","(6) 96\", T8, High Output Ballast, 59 Watt Lamps","(6) 96\", T8 Std Ballast, 57 Watt Lamps","(5) 45.9\" T-5 54W Lamps (2) Prog.Start or PRS Ballasts, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","175 Watt MH Lamp, Magnetic ballast","Magnetic",1,175,209]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(4) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","(6) 96\", T8, High Output Ballast, 86 Watt Lamps","(6) 96\", T8 Std Ballast, 59 Watt Lamps","(6) 45.8\" T-5 54W HO Lamps (3) Prog RS Ballast, HLO(.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","200 Watt MH Lamp, Magnetic ballast","Magnetic",1,200,232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(4) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps",null,"(6) 96\", T8 Std Ballast, 86 Watt Lamps","(6) 45.8\" T-5 54W HO Lamps (3) Prog RS Ballast, HLO(.95<BF<1.1), alt 1",null,null,null,null,null,null,"Metal Halide","250 Watt MH Lamp, Magnetic ballast","Magnetic",1,250,291]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(6) 45.9\" T-5 49W HO Lamps, (3) Prog Start or RS Ballast, HLO (.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","320 Watt MH Lamp, Magnetic ballast","Magnetic",1,320,367]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(8) 45.8\" T-5 49W HO Lamps, (4) Prog Start or RS Ballast, HLO(.95<BF<1.1)",null,null,null,null,null,null,"Metal Halide","350 Watt MH Lamp, Magnetic ballast","Magnetic",1,350,395]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","360 Watt MH Lamp, Magnetic ballast","Magnetic",1,360,418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","400 Watt MH Lamp, Magnetic ballast","Magnetic",1,400,456]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","450 Watt MH Lamp, Magnetic ballast","Magnetic",1,450,507]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","750 Watt MH Lamp, Magnetic ballast","Magnetic",1,750,814]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","1000 Watt MH Lamp, Magnetic ballast","Magnetic",1,1000,1077]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide","1500 Watt MH Lamp, Magnetic ballast","Magnetic",1,1500,1608]
["1a. Interior Retrofits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 24\", T8, Std Elec Ballast, 17 Watt Lamps","Electronic Std",1,17,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 24\", T8, High Output Ballast, 17 Watt Lamps","Electronic HO",1,17,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 36\", T8, Std Elec Ballast, 25 Watt Lamps","Electronic Std",1,25,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 36\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",1,25,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8, Std Ballast, 25 Watt Lamps","Electronic Std",1,25,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",1,25,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8, Std Ballast, 28 Watt Lamps","Electronic Std",1,28,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8,  High Output Ballast, 28 Watt Lamps","Electronic HO",1,28,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8, Std Ballast, 32 Watt Lamps","Electronic Std",1,32,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Fixture Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 48\", T8, High Output Ballast, 32 Watt Lamps","Electronic HO",1,32,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CMeasureType",null,"Retrofit Type","Fixture Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8 Std Ballast, 57 Watt Lamps","Electronic Std",1,57,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exterior/12 Hour",null,"LED","Controlled Fixture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8, High Output Ballast, 57 Watt Lamps","Electronic HO",1,57,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24 Hour/Garage/3-Shift",null,"LED","Controlled Fixture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8 Std Ballast, 59 Watt Lamps","Electronic Std",1,59,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8, High Output Ballast, 59 Watt Lamps","Electronic HO",1,59,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8 Std Ballast, 86 Watt Lamps","Electronic Std",1,86,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(1) 96\", T8, High Output Ballast, 86 Watt Lamps","Electronic HO",1,86,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 24\", T8, Std Elec Ballast, 17 Watt Lamps","Electronic Std",2,17,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 24\", T8, High Output Ballast, 17 Watt Lamps","Electronic HO",2,17,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 36\", T8, Std Elec Ballast, 25 Watt Lamps","Electronic Std",2,25,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 36\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",2,25,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8, Std Ballast, 25 Watt Lamps","Electronic Std",2,25,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",2,25,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8, Std Ballast, 28 Watt Lamps","Electronic Std",2,28,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8,  High Output Ballast, 28 Watt Lamps","Electronic HO",2,28,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8, Std Ballast, 32 Watt Lamps","Electronic Std",2,32,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 48\", T8, High Output Ballast, 32 Watt Lamps","Electronic HO",2,32,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8 Std Ballast, 57 Watt Lamps","Electronic Std",2,57,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8, High Output Ballast, 57 Watt Lamps","Electronic HO",2,57,105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8 Std Ballast, 59 Watt Lamps","Electronic Std",2,59,109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8, High Output Ballast, 59 Watt Lamps","Electronic HO",2,59,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8 Std Ballast, 86 Watt Lamps","Electronic Std",2,86,164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(2) 96\", T8, High Output Ballast, 86 Watt Lamps","Electronic HO",2,86,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 24\", T8, Std Elec Ballast, 17 Watt Lamps","Electronic Std",3,17,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 24\", T8, High Output Ballast, 17 Watt Lamps","Electronic HO",3,17,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 36\", T8, Std Elec Ballast, 25 Watt Lamps","Electronic Std",3,25,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 36\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",3,25,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8, Std Ballast, 25 Watt Lamps","Electronic Std",3,25,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",3,25,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8, Std Ballast, 28 Watt Lamps","Electronic Std",3,28,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8,  High Output Ballast, 28 Watt Lamps","Electronic HO",3,28,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8, Std Ballast, 32 Watt Lamps","Electronic Std",3,32,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 48\", T8, High Output Ballast, 32 Watt Lamps","Electronic HO",3,32,108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8 Std Ballast, 57 Watt Lamps","Electronic Std",3,57,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8, High Output Ballast, 57 Watt Lamps","Electronic HO",3,57,177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8 Std Ballast, 59 Watt Lamps","Electronic Std",3,59,165]
["1b. LED Replacing HID (Lamps, Fixtures & Retrofit Kits)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8, High Output Ballast, 59 Watt Lamps","Electronic HO",3,59,186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8 Std Ballast, 86 Watt Lamps","Electronic Std",3,86,246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(3) 96\", T8, High Output Ballast, 86 Watt Lamps","Electronic HO",3,86,270]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 24\", T8, Std Elec Ballast, 17 Watt Lamps","Electronic Std",4,17,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 24\", T8, High Output Ballast, 17 Watt Lamps","Electronic HO",4,17,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 36\", T8, Std Elec Ballast, 25 Watt Lamps","Electronic Std",4,25,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 36\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",4,25,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8, Std Ballast, 25 Watt Lamps","Electronic Std",4,25,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8, High Output Ballast, 25 Watt Lamps","Electronic HO",4,25,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8, Std Ballast, 28 Watt Lamps","Electronic Std",4,28,100]
["1c. LED Replacing T5, T8, or T12 (Lamps, Fixtures & Retrofit Kits)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8,  High Output Ballast, 28 Watt Lamps","Electronic HO",4,28,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8, Std Ballast, 32 Watt Lamps","Electronic Std",4,32,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 48\", T8, High Output Ballast, 32 Watt Lamps","Electronic HO",4,32,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8 Std Ballast, 25 Watt Lamps","Electronic Std",4,25,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8 Std Ballast, 57 Watt Lamps","Electronic Std",4,57,208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8, High Output Ballast, 57 Watt Lamps","Electronic HO",4,57,236]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8 Std Ballast, 59 Watt Lamps","Electronic Std",4,59,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8, High Output Ballast, 59 Watt Lamps","Electronic HO",4,59,248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8 Std Ballast, 86 Watt Lamps","Electronic Std",4,86,328]
["1d. Controls for New LED Fixtures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(4) 96\", T8, High Output Ballast, 86 Watt Lamps","Electronic HO",4,86,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 48\", T8, Std Ballast, 28 Watt Lamps","Electronic Std",6,28,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 48\", T8,  High Output Ballast, 28 Watt Lamps","Electronic HO",6,28,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 48\", T8, Std Ballast, 32 Watt Lamps","Electronic Std",6,32,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 48\", T8, High Output Ballast, 32 Watt Lamps","Electronic HO",6,32,216]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8 Std Ballast, 57 Watt Lamps","Electronic Std",6,57,312]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8, High Output Ballast, 57 Watt Lamps","Electronic HO",6,57,354]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8 Std Ballast, 59 Watt Lamps","Electronic Std",6,59,330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8, High Output Ballast, 59 Watt Lamps","Electronic HO",6,59,372]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8 Std Ballast, 86 Watt Lamps","Electronic Std",6,86,492]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8","(6) 96\", T8, High Output Ballast, 86 Watt Lamps","Electronic HO",6,86,540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT8","(1) U-Tube, T8 Standard ballast, 32 Watt Lamp","Electronic",1,32,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT8","(1) U-Tube, T8 High Output Ballast, 32 Watt Lamp","Electronic HO",1,32,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT8","(2) U-Tube, T8 Standard ballast, 32 Watt Lamp","Electronic",2,32,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT8","(2) U-Tube, T8 High Output Ballast, 32 Watt Lamp","Electronic HO",2,32,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 24\" T12, STD Lamps, 20 Watt Lamps","Magnetic",1,20,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","Magnetic",1,30,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 40\" T12 F42, HO Lamps, 55 Watt Lamps","Magnetic",1,55,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","Magnetic",1,34,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","Magnetic",1,40,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 48\" T12, HO Lamps, 60 Watt Lamps","Magnetic",1,60,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 72\" T12, HO Lamps, 85 Watt Lamps","Magnetic",1,85,102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","Magnetic",1,60,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps",null,null,null,null,null,"T12","(1) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","Magnetic",1,95,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","Magnetic",1,110,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 108\" T12 F108, HO Lamps, 124 Watt Lamps","Magnetic",1,124,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(1) 114\" T12 F117, HO Lamps, 132 Watt Lamps","Magnetic",1,132,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT12","(1) U-Tube, T12 STD Lamp, STD Mag Ballast, 34 Watt Lamps","Magnetic",1,34,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT12","(1) U-Tube, T12 STD Lamp, STD Mag Ballast, 40 Watt Lamps","Magnetic",1,40,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 24\" T12, STD Lamps, 20 Watt Lamps","Magnetic",2,20,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","Magnetic",2,30,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 40\" T12 F42, HO Lamps, 55 Watt Lamps","Magnetic",1,55,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","Magnetic",2,34,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","Magnetic",2,40,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 48\" T12, HO Lamps, 60 Watt Lamps",null,2,60,136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 72\" T12, HO Lamps, 85 Watt Lamps","Magnetic",2,85,204]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","Magnetic",2,60,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","Magnetic",2,95,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","Magnetic",2,110,276]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 108\" T12 F108, HO Lamps, 124 Watt Lamps","Magnetic",2,124,264]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(2) 114\" T12 F117, HO Lamps, 132 Watt Lamps","Magnetic",2,132,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT12","(2) U-Tube, T12 STD Lamp, STD Mag Ballast, 34 Watt Lamps","Magnetic",2,34,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUT12","(2) U-Tube, T12 STD Lamp, STD Mag Ballast, 40 Watt Lamps","Magnetic",2,40,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 24\" T12, STD Lamps, 20 Watt Lamps","Magnetic",3,20,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","Magnetic",3,30,114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","Magnetic",3,34,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","Magnetic",3,40,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","Magnetic",3,60,225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","Magnetic",3,95,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(3) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","Magnetic",3,110,414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 24\" T12, STD Lamps, 20 Watt Lamps","Magnetic",4,20,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 36\" T12, STD  Lamps Mag-STD, 30 Watt Lamps","Magnetic",4,30,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 48\" T12, ES Lamp, Magnetic Ballast-STD, 34 Watt Lamps","Magnetic",4,34,168]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 48\" T12, STD Lamp, Magnetic Ballast-STD, 40 Watt Lamps","Magnetic",4,40,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 96\" T12, ES Lamps Mag-STD, 60 Watt Lamps","Magnetic",4,60,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 96\" T12, ES HO Lamps Mag-STD, 95 Watt Lamps","Magnetic",4,95,480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T12","(4) 96\" T12, STD HO Lamps Mag-STD, 110 Watt Lamps","PRS Elec",4,110,552]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 22\" T-5 14W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,14,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 22\" T-5 24W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1)","PRS Elec",1,24,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 34\" T-5 21W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,21,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 34\" T-5 39W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,39,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 45.8\" T-5 28W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,28,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 45.8\" T-5 54W HO Lamps (1) Prog RS Ballast, HLO(.95<BF<1.1)","PRS Elec",1,54,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 57.6\" T-5 35W Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,35,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(1) 57.6\" T-5 80W HO Lamp (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",1,80,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 22\" T-5 14W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,14,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 22\" T-5 24W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1)","PRS Elec",2,24,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 34\" T-5 21W Lamps (1) Prog.Start or PRS Ballast HLO (.95<BF<1.1)","PRS Elec",2,21,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 34\" T-5 39W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,39,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 45.8\" T-5 28W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,28,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 45.8\" T-5 49W HO Lamps, (1) Prog Start or RS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,49,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 45.8\" T-5 54W HO Lamps (1) Prog RS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,54,117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 57.6\" T-5 35W Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,35,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(2) 57.6\" T-5 80W HO Lamps (1) Prog Start or PRS Ballast, HLO (.95<BF<1.1)","PRS Elec",2,80,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 22\" T-5 14W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",3,14,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 22\" T-5 24W HO Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",3,24,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 34\" T-5 21W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",3,21,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 34\" T-5 39W HO Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",3,39,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,"T5","(3) 45.8\" T-5 28W Lamps (2) Prog Start or PRS Ballasts, HLO(.95<BF<1.1)","PRS Elec",3,28,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 45.8\" T-5 49W HO Lamps, (1) Prog Start or RS Ballast, HLO (.95<BF<1.1)","PRS Elec",3,49,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 45.8\" T-5 54W HO Lamps, Prog RS (2) Ballast, HLO (.95<BF<1.1)","PRS Elec",3,54,179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(3) 57.6\" T-5 35W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",3,35,118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 22\" T-5 14W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",4,14,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 22\" T-5 24W HO Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",4,24,104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 34\" T-5 39W HO Lamps (2 )Prog.Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",4,39,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 34\" T-5 39W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",4,21,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 45.8\" T-5 28W Lamps (2) Prog Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",4,28,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 45.8\" T-5 49W HO Lamps, (2) Prog Start or RS Ballast, HLO (.95<BF<1.1)","PRS Elec",4,49,196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 45.8\" T-5 54W HO Lamps, (2) Prog RS Ballast, HLO (.95<BF<1.1)","PRS Elec",4,54,234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(4) 45.8\" T-5 54W HO Lamps, (2) Prog RS Ballast, HLO (.95<BF<1.1), alt 1","PRS Elec",4,54,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(5) 45.9\" T-5 54W Lamps (2) Prog.Start or PRS Ballasts, HLO (.95<BF<1.1)","PRS Elec",5,54,296]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(6) 45.8\" T-5 54W HO Lamps (3) Prog RS Ballast, HLO(.95<BF<1.1)","PRS Elec",6,54,351]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(6) 45.8\" T-5 54W HO Lamps (3) Prog RS Ballast, HLO(.95<BF<1.1), alt 1","PRS Elec",6,54,354]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(6) 45.9\" T-5 49W HO Lamps, (3) Prog Start or RS Ballast, HLO (.95<BF<1.1)","PRS Elec",6,49,294]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(8) 45.8\" T-5 49W HO Lamps, (4) Prog Start or RS Ballast, HLO(.95<BF<1.1)","PRS Elec",8,49,392]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(10) 45.8\" T-5 54W HO Lamps (5) Prog RS Ballast, HLO (.95<BF<1.1)","PRS Elec",10,54,585]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5","(12) 45.8\" T-5 54W HO Lamps (6) Prog RS Ballast, HLO (.95<BF<1.1)",null,12,54,702]

{"sheet":"Lighting SOW","index":6,"n_rows":222,"n_cols":20,"rows_kept":222,"cut":false,"hidden":false,"merged":[[5,18,5,19],[3,1,3,4],[3,6,3,8],[0,2,0,5],[1,1,1,4],[1,6,1,8],[2,1,2,4],[2,6,2,8],[4,0,4,7],[5,0,5,7],[5,9,5,17],[4,18,4,19]]}
["App # (office use only):",{"$f":"IF('Applicant Info'!J3=\"\",\"\",'Applicant Info'!J3)","v":""},"Please complete all info in the white spaces below:"]
["Business Name:",{"$f":"IF('Applicant Info'!A20=\"\",\"\",'Applicant Info'!A20)","v":""},null,null,null,"Date:",{"$f":"IF('Applicant Info'!K6=\"\", IF('Applicant Info'!K8=\"\",\"\",'Applicant Info'!K8),'Applicant Info'!K6)","v":""}]
["Prepared by:",null,null,null,null,"Phone:",{"$f":"IF('Applicant Info'!D23=\"\",\"\",'Applicant Info'!D23)","v":""}]
["Address:",{"$f":"IF('Applicant Info'!E25=\"\",\"\",'Applicant Info'!E25 &\" \"&'Applicant Info'!E26 &\" \" &'Applicant Info'!I26 &\" \"&'Applicant Info'!K26)","v":""},null,null,null,"Email:",{"$f":"'Applicant Info'!$E$24","v":0}]
["Lighting Scope of Work / Building Audit Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Savings*"]
["Existing Lighting ",null,null,null,null,null,null,null,null,"Proposed Lighting",null,null,null,null,null,null,null,null,"*calculated per figures entered on this form; savings are NOT guaranteed"]
["LOCATION","Fixture Type ","Lamp ","Ballast","Lamps per Fixture","Watts per Fixture","Fixture Qty","Total W","Operating Hours per Week","New or Retrofit","Fixture Type ","DLC or Energy Star Qualified?","Fixture or Lamp Model Number","Lamps per Fixture","Watts per Fixture","Fixture Qty","Total W","Occupancy Control?\n(Y / N)","Savings (W)","Savings (kWh)"]
[null,null,null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",G8*F8)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(M8=\"\",\"\",O8*P8)","v":""},null,{"$f":"IF(OR(H8=\"\",Q8=\"\"),\"\",H8-Q8)","v":""},{"$f":"IF(OR(I8=\"\",S8=\"\"),\"\",I8*S8*52/1000)","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,{"$f":"IF(OR(H9=\"\",Q9=\"\"),\"\",H9-Q9)","v":""},{"$f":"IF(OR(I9=\"\",S9=\"\"),\"\",I9*S9*52/1000)","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",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":"IF(A73=\"\",\"\",G73*F73)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(M73=\"\",\"\",O73*P73)","v":""},null,{"$f":"IF(OR(H73=\"\",Q73=\"\"),\"\",H73-Q73)","v":""},{"$f":"IF(OR(I73=\"\",S73=\"\"),\"\",I73*S73*52/1000)","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,"",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Type",null,"Ballast",null,"Lamps",null,"New or Retro",null,"Control","DLC Energy Star Qualified?"]
[null,null,null,null,null,null,null,null,null,"DLC"]
["Incandescent",null,"Magnetic",null,1,null,"New Fixture",null,"YES","EnergyStar"]
["Fluorescent",null,"Electronic",null,2,null,"Retrofit",null,"NO","DNQ"]
["LED Screw-in",null,"Pulse-start",null,3,null,"Remove",null,"Ceiling"]
["Screw-in CFL",null,"N/A",null,4,null,null,null,"Wall"]
["Hardwired CFL",null,null,null,5]
["2x4 Troffer",null,null,null,6]
["2x2 Troffer",null,null,null,7]
["2' Strip",null,null,null,8]
["4' Strip",null,null,null,9]
["6' Strip",null,null,null,10]
["8' Strip"]
["Wallpack"]
["Pole"]
["HID"]
["Exit INC"]
["Exit LED"]
["LED Lamp"]
["LED Fixture"]
["LED Sign"]
["HighBay T8"]
["HighBay T5"]
["Other"]
[]
[]
["Type2"]
["LED Screw-in"]
["LED 2x4 Troffer"]
["LED 2x2 Troffer"]
["2' LED Strip"]
["4' LED Strip"]
["6' LED Strip"]
["8' LED Strip"]
["LED Wallpack"]
["LED Pole Fixture"]
["LED Sign"]
["Other"]

{"sheet":"HVAC","index":7,"n_rows":136,"n_cols":19,"rows_kept":136,"cut":false,"hidden":false,"merged":[[26,12,26,14],[27,12,27,14],[27,17,28,17],[28,12,28,14],[29,11,32,11],[29,12,29,14],[30,12,30,14],[30,16,32,16],[30,17,32,17],[31,12,31,14],[32,12,32,14],[19,11,21,11],[19,12,19,14],[19,16,25,16],[19,17,25,17],[20,12,20,14],[21,12,21,14],[22,11,24,11],[22,12,22,14],[23,12,23,14],[24,12,24,14],[25,12,25,14],[12,11,18,11],[12,12,12,14],[12,16,18,16],[12,17,18,17],[13,12,14,14],[13,15,14,15],[15,12,16,14],[15,15,16,15],[17,12,18,14],[17,15,18,15],[2,12,2,14],[3,11,11,11],[3,12,3,14],[3,16,11,16],[3,17,11,17],[4,12,5,14],[4,15,5,15],[6,12,7,14],[6,15,7,15],[8,12,9,14],[8,15,9,15],[10,12,11,14],[10,15,11,15],[0,1,0,5],[1,1,1,5],[47,4,47,5],[45,2,45,3],[46,2,46,3],[47,2,47,3],[2,0,2,2],[37,4,37,5],[38,4,38,5],[12,0,18,2],[19,0,21,2],[17,3,18,5],[13,3,14,5],[29,0,32,2],[29,3,29,5],[30,3,30,5],[32,3,32,5],[27,0,27,2],[28,0,28,2],[15,3,16,5],[25,0,25,2],[26,0,26,2],[4,3,5,5],[22,0,24,2],[17,6,18,6],[15,6,16,6],[28,3,28,5],[6,3,7,5],[8,3,9,5],[24,3,24,5],[19,3,19,5],[23,3,23,5],[20,3,20,5],[21,3,21,5],[70,1,70,8],[64,0,64,8],[55,0,55,1],[45,4,45,5],[52,0,52,1],[58,7,58,8],[53,4,53,5],[51,0,51,8],[52,4,52,5],[58,0,58,6],[54,4,54,5],[55,4,55,5],[56,0,56,7],[53,0,53,1],[54,0,54,1],[59,0,63,8],[45,0,45,1],[49,0,49,7],[46,0,46,1],[47,0,47,1],[48,0,48,1],[48,2,48,3],[68,1,68,8],[69,1,69,8],[4,6,5,6],[10,3,11,5],[65,1,65,8],[66,1,66,8],[30,8,32,8],[35,6,35,7],[35,4,35,5],[33,6,33,7],[33,4,33,5],[34,4,34,5],[34,6,34,7],[30,7,32,7],[37,6,37,7],[38,6,38,7],[25,3,25,5],[6,6,7,6],[8,6,9,6],[10,6,11,6],[36,6,36,7],[36,4,36,5],[26,3,26,5],[27,3,27,5],[31,3,31,5],[22,3,22,5],[1,7,1,8],[19,7,25,7],[19,8,25,8],[3,7,11,7],[3,8,11,8],[12,7,18,7],[12,8,18,8],[27,8,28,8],[67,1,67,8],[39,4,39,5],[44,0,44,8],[41,6,41,7],[39,6,39,7],[42,0,42,7],[41,4,41,5],[48,4,48,5],[46,4,46,5],[40,4,40,5],[40,6,40,7],[2,3,2,5],[13,6,14,6],[12,3,12,5],[3,0,11,2],[3,3,3,5]]}
[null,"HVAC INCENTIVES",null,null,null,null,null,null,null,null,null,"USE THIS SECTION TO REPLACE THE TABLE IN THE SPECS WORKSHEET"]
["Applicant: fill in gray fields at bottom","Click here for instructions to complete this worksheet"]
["Equipment Type",null,null,"Size Category",null,null,"Qualifying Efficiency*","Incentive \n(per ton)","Efficiency Bonus",null,null,"Equipment Type","Size Category",null,null,"Qualifying Efficiency*","Incentive \n(per ton)","Efficiency Bonus"]
["Unitary and Split Air Conditioning Systems",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"14.0 SEER and 12.0 EER",25,15,null,null,"Unitary and Split Air Conditioning Systems","< 65,000 Btu/h (5.4 tons)",null,null,"14.0 SEER and 12.0 EER",25,15]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"12.0 EER**",null,null,null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"12.0 EER**"]
[]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"12.0 EER**",null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"12.0 EER**"]
[]
[null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"10.8 EER**",null,null,null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"10.8 EER**"]
[]
[null,null,null,"≥ 760,000 Btu/h (> 63 tons)",null,null,"10.2 EER**",null,null,null,null,null,"≥ 760,000 Btu/h (> 63 tons)",null,null,"10.2 EER**"]
[]
["Air Source Heat Pumps",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"14 SEER and 12.0 EER and 7.7 HSPF",40,15,null,null,"Air Source Heat Pumps","< 65,000 Btu/h (5.4 tons)",null,null,"14 SEER and 12.0 EER and 7.7 HSPF",40,15]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"11.6 EER** and 3.2 COP",null,null,null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"11.6 EER** and 3.2 COP"]
[]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"11.2 EER** and 3.1 COP",null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"11.2 EER** and 3.1 COP"]
[]
[null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"10.0 EER** and 3.1 COP",null,null,null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"10.0 EER** and 3.1 COP"]
[]
["Chillers: Water-Cooled, Centrifugal***",null,null,"≤ 150 tons",null,null,"0.569 kW/ton-IPLV",20,20,null,null,"Chillers: Water-Cooled, Centrifugal","≤ 150 tons",null,null,"0.569 kW/ton-IPLV",20,20]
[null,null,null,">150 tons and ≤ 300 tons",null,null,"0.507 kW/ton-IPLV",null,null,null,null,null,">150 tons and ≤ 300 tons",null,null,"0.507 kW/ton-IPLV"]
[null,null,null,"> 300 tons",null,null,"0.467 kW/ton-IPLV",null,null,null,null,null,"> 300 tons",null,null,"0.467 kW/ton-IPLV"]
["Chillers: Water Cooled Scroll or Helical-Rotary***",null,null,"≤ 150 tons",null,null,"0.575 kW/ton-IPLV",null,null,null,null,"Chillers: Water Cooled Scroll or Helical-Rotary","≤ 150 tons",null,null,"0.575 kW/ton-IPLV"]
[null,null,null,">150 tons and ≤ 300 tons",null,null,"0.534 kW/ton-IPLV",null,null,null,null,null,">150 tons and ≤ 300 tons",null,null,"0.534 kW/ton-IPLV"]
[null,null,null,"> 300 tons",null,null,"0.486 kW/ton-IPLV",null,null,null,null,null,"> 300 tons",null,null,"0.486 kW/ton-IPLV"]
["Chillers: Water-Cooled Reciprocating, All",null,null,"ALL",null,null,"0.592 kW/ton-IPLV",null,null,null,null,"Chillers: Water-Cooled Reciprocating, All","ALL",null,null,"0.592 kW/ton-IPLV"]
["Chillers: Air-Cooled, All",null,null,"ALL",null,null,"0.867 kW/ton-IPLV",40,20,null,null,"Chillers: Air-Cooled, All","ALL",null,null,"0.867 kW/ton-IPLV",40,20]
["Packaged Terminal AC",null,null,"ALL",null,null,"12.5-(0.213 x Btu/h/1000) EER",50,0,null,null,"Packaged Terminal AC","ALL",null,null,"12.5-(0.213 x Btu/h/1000) EER",50,0]
["Packaged Terminal HP",null,null,"ALL",null,null,"12.3-(0.213 x Btu/h/1000) EER",100,null,null,null,"Packaged Terminal HP","ALL",null,null,"12.3-(0.213 x Btu/h/1000) EER",100]
["Variable Refrigerant Flow HP",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"15.6 SEER and 8.9 HSPF",40,20,null,null,"Variable Refrigerant Flow HP","< 65,000 Btu/h (5.4 tons)",null,null,"15.6 SEER and 8.9 HSPF",40,20]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"14.8 IEER and 4.0 COP",40,25,null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"14.8 IEER and 4.0 COP",40,25]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"14.2 IEER and 3.2 COP",null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"14.2 IEER and 3.2 COP"]
[null,null,null,"≥ 240,000 Btu/h (20 Tons)",null,null,"12.7 IEER and 3.7 COP",null,null,null,null,null,"≥ 240,000 Btu/h (20 Tons)",null,null,"12.7 IEER and 3.7 COP"]
["Equipment Model","Tons","Efficiency Rating","Quantity","Equipment Type",null,"Size Category",null,"Incentive"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E35=\"\",\"\",IF(LEFT(E35,1)<>\"C\",B35*D35*IF(VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,2,FALSE)>C35,0,VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,3,FALSE)+(C35-(VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,2,FALSE)))*(VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,4,FALSE))),B35*D35*IF(VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,2,FALSE)<C35,0,VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,3,FALSE)+((VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,2,FALSE))-C35)*(VLOOKUP(CONCATENATE(E35,G35),$K$108:$N$134,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Total HVAC Incentives",null,null,null,null,null,null,null,{"$f":"SUM(I35:I42)","v":0}]
[]
["Guest Room Energy Management System"]
["Type/ Description",null,"Incentive Unit",null,"Unit Size (tons)",null,"Quantity","Incentive/ Ton","Incentive"]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,60,{"$f":"IF(G47*H47*E47=0,\"\",G47*H47*E47)","v":""}]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,60,{"$f":"IF(G48*H48*E48=0,\"\",G48*H48*E48)","v":""}]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,60,{"$f":"IF(G49*H49*E49=0,\"\",G49*H49*E49)","v":""}]
["Total GREM Incentives",null,null,null,null,null,null,null,{"$f":"IF(SUM(I47:I49)=0,\"\",SUM(I47:I49))","v":""}]
[]
["Indirect Evaporative Cooling"]
["Type/ Description",null,"Number of HMX Units","Tons/ HMX","Equivalent Tons",null,"Quantity","Incentive/ Ton","Incentive"]
[null,null,null,0.66,{"$f":"C54*D54","v":0},null,null,100,{"$f":"IF(G54*H54*E54=0,\"\",G54*H54*E54)","v":""}]
[null,null,null,0.66,{"$f":"C55*D55","v":0},null,null,100,{"$f":"IF(G55*H55*E55=0,\"\",G55*H55*E55)","v":""}]
[null,null,null,0.66,0,null,null,100,{"$f":"IF(G56*H56*E56=0,\"\",G56*H56*E56)","v":""}]
["Total Indirect Evaporative Cooling Incentives",null,null,null,null,null,null,null,{"$f":"IF(SUM(I54:I56)=0,\"\",SUM(I54:I56))","v":""}]
["HMX = Heat Mass Exchange units"]
["Total All HVAC Form Incentives",null,null,null,null,null,null,{"$f":"SUM(I43,I50,I57)","v":0}]
["* Use SEER for Unitary and Split Units less than 5.4 tons and EER for units larger than 5.4 tons; values available from CEE 2012 Tier 2; Use IEER for VRF Units; IPLV values based on ASHRAE 90.1 2010; see specifications page for complete list. Attach AHRI Rating Sheet. \n** Units with electric resistance heating must have EER values 0.2 higher than the efficiencies listed.\n*** Unit efficiency for chillers should be provided in kW per ton – IPLV where IPLV = Integrated Part Load Value; values based on ASHRAE 90.1 2010. Attach manufacturer's rating sheet for credit."]
[]
[]
[]
[]
["INSTRUCTIONS TO COMPLETE THIS WORKSHEET:"]
["Equipment Model:","Enter the equipment model as shown on the invoice; provide the specification sheet(s) that accompany the model"]
["Tons:","Enter the equipment tonnage from the AHRI or manufacturer specification sheet"]
["Efficiency Rating:","Enter the equipment efficiency rating from the AHRI or manufacturer specification sheet; for chillers, kW/ton = 12/IPLV EER"]
["Quantity:","Enter the number of units that fit this size and efficiency rating"]
["Equipment Type:","Enter the equipment type from the drop-down menu"]
["Size Category:","Enter the equipment size from the drop-down menu"]
[]
[]
[" HVAC Specifications"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems"]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Centrifugal"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Scroll or Screw"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Reciprocating"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Air-Cooled"]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal AC"]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal HP"]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"< 65,000 Btu/h (5.4 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 65,000 Btu/h and < 135,000 Btu/h (5.4-11.25 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 760,000 Btu/h (> 63 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≤ 150 tons"]
[null,null,null,null,null,null,null,null,null,null,">150 tons and ≤ 300 tons"]
[null,null,null,null,null,null,null,null,null,null,"> 300 tons"]
[null,null,null,null,null,null,null,null,null,null,"ALL"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Level Normal","Incentive","Bonus","Level 2","Level 3","Level 4","Min","Max"]
[]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems< 65,000 Btu/h (5.4 tons)",14,25,15,{"$f":"L110+1","v":15},{"$f":"O110+1","v":16},17,0,5.4]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems≥ 65,000 Btu/h and < 135,000 Btu/h (5.4-11.25 tons)",12,25,15,{"$f":"L111+1","v":13},14,15]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",12,25,15,{"$f":"L112+1","v":13},14,15,11.25,20]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",10.8,25,15,{"$f":"L110+1","v":15},{"$f":"O110+1","v":16},{"$f":"P110+1","v":17},20,63]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems≥ 760,000 Btu/h (> 63 tons)",10.199999999999999,25,15,{"$f":"L114+1","v":11.2},12.2,13.2,63,100000]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps< 65,000 Btu/h (5.4 tons)",14,40,15,{"$f":"L115+1","v":15},16,17,0,5.4]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps≥ 65,000 Btu/h and < 135,000 Btu/h (5.4-11.25 tons)",11.6,40,15,{"$f":"L116+1","v":12.6},13.6,14.6,5.4,11.25]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",11.2,40,15,{"$f":"L117+1","v":12.2},13.2,14.2,11.25,20]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",10,40,15,{"$f":"L115+1","v":15},{"$f":"O115+1","v":16},{"$f":"P115+1","v":17},20,63]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps≥ 760,000 Btu/h (> 63 tons)",10,40,15,{"$f":"L119+1","v":11},{"$f":"O119+1","v":12},13,63,100000]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Centrifugal≤ 150 tons",0.56899999999999995,20,20,0.54,{"$f":"ROUNDUP(L120/0.9*0.7,2)","v":0.45},{"$f":"ROUNDUP(L120/0.9*0.6,2)","v":0.38},0,150]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Centrifugal>150 tons and ≤ 300 tons",0.50700000000000001,20,20,0.48,0.4,0.34,150,300]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Centrifugal> 300 tons",0.46700000000000003,20,20,0.44,0.37,0.32,300,100000]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: ReciprocatingALL",0.59199999999999997,20,20,0.54,0.47000000000000003,0.4,0,75]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Scroll or Screw≤ 150 tons",0.57499999999999996,20,20,0.54,0.45,0.39,75,150]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Scroll or Screw>150 tons and ≤ 300 tons",0.53400000000000003,20,20,0.5,0.42,0.36,150,300]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Scroll or Screw> 300 tons",0.48599999999999999,20,20,0.46,0.38,0.33,300,100000]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Air-CooledALL",0.86699999999999999,40,20,{"$f":"ROUND(L127/0.9*0.8,2)","v":0.77},0.68,0.57999999999999996,0,150]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Air-Cooled> 150 tons",0.86699999999999999,15,20,{"$f":"ROUND(L128/0.9*0.8,2)","v":0.77},0.68,0.57999999999999996,150,100000]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal ACALL",{"$f":"12.5-(0.213*B35*12000/1000)","v":12.5},50,0,{"$f":"L129+1","v":13.5},{"$f":"O129+1","v":14.5},15.5,0,100000]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal HPALL",{"$f":"12.3-(0.213*B36*12000/1000)","v":12.3},100,0,13.3,14.3,15.3,0,100000]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP≥ 65,000 Btu/h and < 135,000 Btu/h (5.4-11.25 tons)",14.8,40,25,15.8,16.8,17.8,5.4,11.25]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",14.2,40,25,15.2,16.2,17.2,11.25,20]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",12.7,40,25,13.7,14.7,15.7,20,63]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP< 65,000 Btu/h (5.4 tons)",15.6,40,25,16.600000000000001,17.600000000000001,18.600000000000001,63,100000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**used stated values for Level 2, if available.  Else was rounded up to the  10s of watts"]

{"sheet":"Motors & VSDs","index":8,"n_rows":118,"n_cols":25,"rows_kept":118,"cut":false,"hidden":false,"merged":[[0,8,0,9],[1,0,1,2],[0,2,0,7],[31,8,31,9],[32,8,32,9],[13,8,13,9],[14,8,14,9],[18,8,18,9],[19,8,19,9],[21,8,21,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[12,8,12,9],[11,8,11,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[24,8,24,9],[20,0,20,1],[15,8,15,9],[16,8,16,9],[17,8,17,9],[20,8,20,9],[19,0,19,1],[17,0,17,1],[15,0,15,1],[16,0,16,1],[18,0,18,1],[22,8,22,9],[23,8,23,9],[24,0,24,1],[34,0,34,1],[28,0,28,1],[29,0,29,1],[26,0,26,1],[7,0,7,1],[12,0,12,1],[11,0,11,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[6,0,6,1],[4,0,5,1],[4,8,5,9],[4,6,4,7],[4,4,4,5],[4,2,4,3],[6,8,6,9],[39,0,39,4],[40,0,40,4],[47,0,47,4],[48,0,48,4],[13,0,13,1],[14,0,14,1],[35,0,35,7],[21,0,21,1],[23,0,23,1],[22,0,22,1],[37,0,38,9],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[27,0,27,1],[51,0,52,9],[50,0,50,8],[41,0,41,4],[42,0,42,4],[46,0,46,4],[43,0,43,4],[45,0,45,4],[49,0,49,4],[44,0,44,4]]}
[null,null,"MOTORS & VARIABLE SPEED DRIVES INCENTIVES"]
["Applicant: fill in gray fields at bottom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation"]
["Premium-Efficiency Motors - Minimum Qualifying Efficiencies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concatenate","Baseline Efficiency"]
["Horsepower",null,"1200 RPM",null,"1800 RPM",null,"3600 RPM",null,"Incentive per 0.1% efficiency improvement over baseline efficiencies",null,null,null,null,null,1,1200,"Open ",null,null,null,1,1200,"Open ","11200Open ",0.82499999999999996]
[null,null,"Open","Closed","Open","Closed","Open","Closed",null,null,null,null,null,null,1.5,1800,"Closed",null,null,null,1.5,1200,"Open ","1.51200Open ",0.86499999999999999]
[1,null,0.82499999999999996,0.85499999999999998,0.77,0.82499999999999996,0.85499999999999998,0.77,2,null,null,null,null,null,2,3600,null,null,null,null,2,1200,"Open ","21200Open ",0.875]
[1.5,null,0.86499999999999999,0.86499999999999999,0.84,0.875,0.86499999999999999,0.84,3,null,null,null,null,null,3,null,null,null,null,null,3,1200,"Open ","31200Open ",0.88500000000000001]
[2,null,0.875,0.86499999999999999,0.85499999999999998,0.88500000000000001,0.86499999999999999,0.85499999999999998,4,null,null,null,null,null,5,null,null,null,null,null,5,1200,"Open ","51200Open ",0.89500000000000002]
[3,null,0.88500000000000001,0.89500000000000002,0.85499999999999998,0.89500000000000002,0.89500000000000002,0.86499999999999999,6,null,null,null,null,null,7.5,null,null,null,null,null,7.5,1200,"Open ","7.51200Open ",0.90200000000000002]
[5,null,0.89500000000000002,0.89500000000000002,0.86499999999999999,0.89500000000000002,0.89500000000000002,0.88500000000000001,10,null,null,null,null,null,10,null,null,null,null,null,10,1200,"Open ","101200Open ",0.91700000000000004]
[7.5,null,0.90200000000000002,0.91,0.88500000000000001,0.91,0.91700000000000004,0.89500000000000002,17,null,null,null,null,null,15,null,null,null,null,null,15,1200,"Open ","151200Open ",0.91700000000000004]
[10,null,0.91700000000000004,0.91700000000000004,0.89500000000000002,0.91,0.91700000000000004,0.90200000000000002,22,null,null,null,null,null,20,null,null,null,null,null,20,1200,"Open ","201200Open ",0.92400000000000004]
[15,null,0.91700000000000004,0.93,0.90200000000000002,0.91700000000000004,0.92400000000000004,0.91,33,null,null,null,null,null,25,null,null,null,null,null,25,1200,"Open ","251200Open ",0.93]
[20,null,0.92400000000000004,0.93,0.91,0.91700000000000004,0.93,0.91,44,null,null,null,null,null,30,null,null,null,null,null,30,1200,"Open ","301200Open ",0.93599999999999994]
[25,null,0.93,0.93599999999999994,0.91700000000000004,0.93,0.93599999999999994,0.91700000000000004,65,null,null,null,null,null,40,null,null,null,null,null,40,1200,"Open ","401200Open ",0.94099999999999995]
[30,null,0.93599999999999994,0.94099999999999995,0.91700000000000004,0.93,0.93599999999999994,0.91700000000000004,77,null,null,null,null,null,50,null,null,null,null,null,50,1200,"Open ","501200Open ",0.94099999999999995]
[40,null,0.94099999999999995,0.94099999999999995,0.92400000000000004,0.94099999999999995,0.94099999999999995,0.92400000000000004,102,null,null,null,null,null,60,null,null,null,null,null,60,1200,"Open ","601200Open ",0.94499999999999995]
[50,null,0.94099999999999995,0.94499999999999995,0.93,0.94099999999999995,0.94499999999999995,0.93,127,null,null,null,null,null,75,null,null,null,null,null,75,1200,"Open ","751200Open ",0.94499999999999995]
[60,null,0.94499999999999995,0.95,0.93599999999999994,0.94499999999999995,0.95,0.93599999999999994,200,null,null,null,null,null,100,null,null,null,null,null,100,1200,"Open ","1001200Open ",0.95]
[75,null,0.94499999999999995,0.95,0.93599999999999994,0.94499999999999995,0.95400000000000007,0.93599999999999994,250,null,null,null,null,null,125,null,null,null,null,null,125,1200,"Open ","1251200Open ",0.95]
[100,null,0.95,0.95400000000000007,0.93599999999999994,0.95,0.95400000000000007,0.94099999999999995,325,null,null,null,null,null,150,null,null,null,null,null,150,1200,"Open ","1501200Open ",0.95400000000000007]
[125,null,0.95,0.95400000000000007,0.94099999999999995,0.95,0.95400000000000007,0.95,400,null,null,null,null,null,200,null,null,null,null,null,200,1200,"Open ","2001200Open ",0.95400000000000007]
[150,null,0.95400000000000007,0.95799999999999996,0.94099999999999995,0.95799999999999996,0.95799999999999996,0.95,475,null,null,null,null,null,null,null,null,null,null,null,1,1200,"Closed","11200Closed",0.85499999999999998]
[200,null,0.95400000000000007,0.95799999999999996,0.95,0.95799999999999996,0.96200000000000008,0.95400000000000007,625,null,null,null,null,null,null,null,null,null,null,null,1.5,1200,"Closed","1.51200Closed",0.86499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1200,"Closed","21200Closed",0.86499999999999999]
["Motor Make/Model",null,"Quantity","Motor Size\n(HP)\n(dropdown)","Motor Speed (rpm)\n(dropdown)","Motor Type\n(open/closed)\n(dropdown)","Baseline  Efficiency","Actual Motor Efficiency","Total\nIncentive",null,null,null,null,null,"Concatenate",null,null,null,null,null,3,1200,"Closed","31200Closed",0.89500000000000002]
[null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(O28,$X$5:$Y$118,2,0))=TRUE,\"\",(VLOOKUP(O28,$X$5:$Y$118,2,0)))","v":""},null,{"$f":"IF(H28=\"\",\"\",IF(OR(ISNA((H28-G28)*1000*VLOOKUP(D28,$A$7:$I$25,8,0)),H28<G28)=TRUE,\"\",((H28-G28)*1000*VLOOKUP(D28,$A$7:$I$25,9,0)*C28)))","v":""},null,null,null,null,null,{"$f":"CONCATENATE(D28,E28,F28)","v":""},null,null,null,null,null,5,1200,"Closed","51200Closed",0.89500000000000002]
[null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(O29,$X$5:$Y$118,2,0))=TRUE,\"\",(VLOOKUP(O29,$X$5:$Y$118,2,0)))","v":""},null,{"$f":"IF(H29=\"\",\"\",IF(OR(ISNA((H29-G29)*1000*VLOOKUP(D29,$A$7:$I$25,8,0)),H29<G29)=TRUE,\"\",((H29-G29)*1000*VLOOKUP(D29,$A$7:$I$25,9,0)*C29)))","v":""},null,null,null,null,null,{"$f":"CONCATENATE(D29,E29,F29)","v":""},null,null,null,null,null,7.5,1200,"Closed","7.51200Closed",0.91]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,10,1200,"Closed","101200Closed",0.91700000000000004]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,15,1200,"Closed","151200Closed",0.93]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,20,1200,"Closed","201200Closed",0.93]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,25,1200,"Closed","251200Closed",0.93599999999999994]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,30,1200,"Closed","301200Closed",0.94099999999999995]
[null,null,null,null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,40,1200,"Closed","401200Closed",0.94099999999999995]
["Total Motors Incentives",null,null,null,null,null,null,null,{"$f":"SUM(I28:J35)","v":0},null,null,{"$f":"I36","v":0},null,null,"",null,null,null,null,null,50,1200,"Closed","501200Closed",0.94499999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,1200,"Closed","601200Closed",0.95]
["Variable Speed Drive on HVAC Motors Incentives (when adding VSDs where none existed before)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,1200,"Closed","751200Closed",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1200,"Closed","1001200Closed",0.95400000000000007]
["VSD Application Description",null,null,null,null,"VSD Size (HP)","Incentive\nUnit","Incentive/ Unit*","Quantity","Incentive ($100/hp)","Recommended increase","kWh","Cost","New",null,null,null,null,null,null,125,1200,"Closed","1251200Closed",0.95400000000000007]
[null,null,null,null,null,null,"per HP",100,null,{"$f":"IF($A41=\"\",\"\",$F41*$I41*$H41)","v":""},70,{"$f":"1757*F41*I41","v":0},{"$f":"J41/L41","v":{"$error":"#VALUE!"}},{"$f":"O41/L41","v":{"$error":"#DIV/0!"}},{"$f":"F41*I41*K41","v":0},null,null,null,null,null,150,1200,"Closed","1501200Closed",0.95799999999999996]
[null,null,null,null,null,null,"per HP",100,null,{"$f":"F42*I42*H42","v":0},70,null,null,null,null,null,null,null,null,null,200,1200,"Closed","2001200Closed",0.95799999999999996]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,1,1800,"Open ","11800Open ",0.77]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,1.5,1800,"Open ","1.51800Open ",0.84]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,2,1800,"Open ","21800Open ",0.85499999999999998]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,3,1800,"Open ","31800Open ",0.85499999999999998]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,5,1800,"Open ","51800Open ",0.86499999999999999]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,7.5,1800,"Open ","7.51800Open ",0.88500000000000001]
[null,null,null,null,null,null,"per HP",100,null,0,70,null,null,null,null,null,null,null,null,null,10,1800,"Open ","101800Open ",0.89500000000000002]
[null,null,null,null,null,null,"per HP",100,null,0,70,{"$f":"J51","v":0},null,null,null,null,null,null,null,null,15,1800,"Open ","151800Open ",0.90200000000000002]
["Total VSD Incentives",null,null,null,null,null,null,null,null,{"$f":"SUM(J41:J50)","v":0},null,{"$f":"L36+L50","v":0},null,null,null,null,null,null,null,null,20,1800,"Open ","201800Open ",0.91]
["*The variable speed drive incentive is calculated based on the horsepower (HP) that is actually being controlled, not necessarily the size of the VSD. This section for HVAC only; for VSD's on non-HVAC equipment, use the Custom tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,1800,"Open ","251800Open ",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,1800,"Open ","301800Open ",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,1800,"Open ","401800Open ",0.92400000000000004]
[" Motors and Variable Speed Drives (VSDs) Specifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,1800,"Open ","501800Open ",0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,1800,"Open ","601800Open ",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,1800,"Open ","751800Open ",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1800,"Open ","1001800Open ",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,1800,"Open ","1251800Open ",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,1800,"Open ","1501800Open ",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,1800,"Open ","2001800Open ",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1800,"Closed","11800Closed",0.82499999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,1800,"Closed","1.51800Closed",0.875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1800,"Closed","21800Closed",0.88500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1800,"Closed","31800Closed",0.89500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1800,"Closed","51800Closed",0.89500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,1800,"Closed","7.51800Closed",0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1800,"Closed","101800Closed",0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,1800,"Closed","151800Closed",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,1800,"Closed","201800Closed",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,1800,"Closed","251800Closed",0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,1800,"Closed","301800Closed",0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,1800,"Closed","401800Closed",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,1800,"Closed","501800Closed",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,1800,"Closed","601800Closed",0.94499999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,1800,"Closed","751800Closed",0.94499999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1800,"Closed","1001800Closed",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,1800,"Closed","1251800Closed",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,1800,"Closed","1501800Closed",0.95799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,1800,"Closed","2001800Closed",0.95799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3600,"Open ","13600Open ",0.85499999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,3600,"Open ","1.53600Open ",0.86499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3600,"Open ","23600Open ",0.86499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3600,"Open ","33600Open ",0.89500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,3600,"Open ","53600Open ",0.89500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,3600,"Open ","7.53600Open ",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3600,"Open ","103600Open ",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3600,"Open ","153600Open ",0.92400000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,3600,"Open ","203600Open ",0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,3600,"Open ","253600Open ",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,3600,"Open ","303600Open ",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,3600,"Open ","403600Open ",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,3600,"Open ","503600Open ",0.94499999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,3600,"Open ","603600Open ",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,3600,"Open ","753600Open ",0.95400000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,3600,"Open ","1003600Open ",0.95400000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,3600,"Open ","1253600Open ",0.95400000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,3600,"Open ","1503600Open ",0.95799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,3600,"Open ","2003600Open ",0.96200000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3600,"Closed","13600Closed",0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,3600,"Closed","1.53600Closed",0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3600,"Closed","23600Closed",0.85499999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3600,"Closed","33600Closed",0.86499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,3600,"Closed","53600Closed",0.88500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,3600,"Closed","7.53600Closed",0.89500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3600,"Closed","103600Closed",0.90200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3600,"Closed","153600Closed",0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,3600,"Closed","203600Closed",0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,3600,"Closed","253600Closed",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,3600,"Closed","303600Closed",0.91700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,3600,"Closed","403600Closed",0.92400000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,3600,"Closed","503600Closed",0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,3600,"Closed","603600Closed",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,3600,"Closed","753600Closed",0.93599999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,3600,"Closed","1003600Closed",0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,3600,"Closed","1253600Closed",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,3600,"Closed","1503600Closed",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,3600,"Closed","2003600Closed",0.95400000000000007]

{"sheet":"Refrigeration & Window Film","index":9,"n_rows":124,"n_cols":36,"rows_kept":124,"cut":false,"hidden":false,"merged":[[1,0,1,2],[3,5,4,6],[3,7,4,7],[6,5,6,6],[5,5,5,6],[33,0,33,7],[17,0,17,7],[16,5,16,6],[11,5,11,6],[15,5,15,6],[12,5,12,6],[14,5,14,6],[13,5,13,6],[3,8,4,8],[18,0,18,8],[3,0,4,1],[31,24,31,28],[32,25,32,28],[7,5,7,6],[10,5,10,6],[8,5,8,6],[9,5,9,6],[34,0,34,8],[2,0,2,8],[20,11,20,14],[3,3,4,4],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[11,3,11,4],[10,3,10,4],[9,3,9,4],[8,3,8,4],[7,3,7,4],[6,3,6,4],[5,3,5,4]]}
[null,"REFRIGERATION INCENTIVES"]
["Applicant: fill in gray fields"]
["Measures for Reach-In Coolers and Freezers"]
["Measures",null,null,"Incentive\nUnit",null,"Incentive/Unit",null,"# of Units","Incentive"]
[]
["Night Covers for Displays",null,null,"Linear Foot of Case",null,10,null,null,{"$f":"F6*ROUND(H6,0)","v":0}]
["EC Motor for Reach-in Refrigerator Cases",null,null,"Motor",null,60,null,null,{"$f":"F7*H7","v":0}]
["EC Motor for Reach-in Freezer Cases",null,null,"Motor",null,70,null,null,{"$f":"F8*H8","v":0}]
["EC Motor for Walk-in Refrigerator Cases",null,null,"Motor",null,110,null,null,{"$f":"F9*H9","v":0}]
["EC Motor for Walk-in Freezer Cases",null,null,"Motor",null,120,null,null,0]
["Evaporator Fan Controller - Electrically Commutated Motor",null,null,"Motor",null,30,null,null,0]
["Anti-Sweat Heater Controls",null,null,"Linear Foot of Case",null,30,null,null,{"$f":"F12*ROUND(H12,0)","v":0}]
["LED Refrigeration Case Lighting",null,null,"Door",null,40,null,null,0]
["ENERGY STAR® Solid Door Freezer",null,null,"Cubic Foot",null,20,null,null,0]
["ENERGY STAR® Glass Door Freezer",null,null,"Cubic Foot",null,40,null,null,0]
["Strip Curtains on Small Walk-in Coolers and Freezers*",null,null,"Square Foot ",null,3,null,null,{"$f":"F16*ROUND(H16,0)","v":0}]
["Strip Curtains on Large Walk-in Coolers and Freezers*",null,null,"Square Foot ",null,5,null,null,{"$f":"F17*ROUND(H17,0)","v":0}]
["Total Refrigeration Incentives",null,null,null,null,null,null,null,{"$f":"SUM(I6:I17)","v":0},null,null,{"$f":"I18","v":0}]
["* A small walk-in cooler and freezer has a doorway that is less than 50 square feet; a large walk-in cooler and freezer has a doorway that is greater than 50 square feet.",null,null,null,null,null,null,null,null,null,null,{"$f":"L18","v":0}]
["Window Film Incentives (Must have 10% lower Shading Coeffient than pre-existing shading type; see spec for details. Pre-application notification is required)"]
["Region","Orientation","Cooling Solar Heat Gain [Btu/ft2-year]","Area of Window Film [ft2]","Incentive/ft2","Existing Shading Type","Pre-Existing Shading Coefficient","New Shading Coefficient","Incentive","$/kWh",null,"Cooling Solar Heat Gain [Btu/ft2-year]",null,null,null,null,null,"Peak Hour Solar Heat Gain [Btu/hr-ft2-year]",null,null,null,null,null,"Shading Type","Shading Coefficient","Source",null,null,null,null,null,"Energy Savings [KWh]","Peak Hour Solar Heat Gain [Btu/hr-ft2-year]","Demand Savings [KW]",null,"Region"]
[null,null,{"$f":"_xlfn.IFNA(INDEX($L$23:$O$30,MATCH(B22,$K$23:$K$30,0),MATCH(A22,$L$22:$O$22,0)),\"\")","v":""},null,1.2,null,{"$f":"_xlfn.IFNA(VLOOKUP($F22,$X$22:$Y$31,2,0),\"\")","v":""},null,{"$f":"IFERROR(IF($H22<=($G22-(0.1*$G22)),IF(OR($D22=0,$AF22=\"\",$AH22=\"\"),\"\",$D22*$E22),0),\"\")","v":""},{"$f":"IFERROR(I22/AF22,\"\")","v":""},"Orientation","Central -NM","South -NM","Roswell","North -NM",null,"Orientation","Central -NM","South -NM","Roswell","North -NM",null,null,"Single-Pane - None",0.93,"Table 10: Based on 1/4\" clear single-pane glass (ID 1b)",null,null,null,null,null,{"$f":"IF(OR(A22=\"\",B22=\"\",D22=\"\",H22=\"\"),\"\",IFERROR((D22*C22*(G22-H22))/($N$33*1000),\"\"))","v":""},{"$f":"_xlfn.IFNA(INDEX($R$23:$U$30,MATCH(B22,$Q$23:$Q$30,0),MATCH(A22,$R$22:$U$22,0)),\"\")","v":""},{"$f":"IF(OR(D22=\"\",H22=\"\"),\"\",IFERROR((D22*AG22*(G22-H22))/($R$33*1000),\"\"))","v":""},null,"North -NM"]
[null,null,"",null,1.2,null,"",null,"","","North",67108,69897,68618,67995,null,"North",37,39,38,37,null,null,"Single-Pane- Roller Shade",0.6,"Table 13G: Based on ID 1b, dark opaque",null,null,null,null,null,"","","",null,"Central -NM"]
[null,null,"",null,1.2,null,"",null,"","","North-East",102259,103459,98399,103426,null,"North-East",55,55,53,56,null,null,"Single-Pane - Louvered Interior shades",0.56000000000000005,"Table 13A: Based on ID 1b, 0.50 reflection, excluded beam",null,null,null,null,null,"","","",null,"South -NM"]
[null,null,"",null,1.2,null,"",null,"","","East",145112,141559,137424,145519,null,"East",71,70,67,73,null,null,"Single-Pane - Draperies -- Open Weave",0.67,"Table 13G: Based on ID 1b, Medium Open Weave",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","","South-East",148340,141019,140248,147647,null,"South-East",64,61,60,65,null,null,"Single-Pane - Draperies -- Closed Weave",0.56000000000000005,"Table 13 GL Based on ID 1b, Medium Closed Weave",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","","South",132595,126016,126800,129217,null,"South",50,46,48,49,null,null,"Double-Pane - None",0.8,"Table 10: Based on 1/4\" clear double-pane glass (ID 1b)",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","","South-West",140262,139677,139550,134108,null,"South-West",58,59,60,54,null,null,"Double-Pane- Roller Shade",0.62,"Table 13G: Based on ID 5b, dark opaque",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","","West",133326,139363,137442,127718,null,"West",63,67,67,58,null,null,"Double-Pane - Louvered Interior shades",0.57999999999999996,"Table 13B: Based on ID 5b, 0.50 reflection, excluded beam",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","","North-West",93741,100581,99132,91707,null,"North-West",49,53,53,46,null,null,"Double-Pane - Draperies -- Open Weave",0.64,"Table 13G: Based on ID 5b, Medium Open Weave",null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,{"$f":"IFERROR(IF($H31<=($G31-(0.1*$G31)),IF(OR($D31=0,$AF31=\"\",$AH31=\"\"),\"\",$D31*$E31),0),\"\")","v":""},{"$f":"IFERROR(I31/AF31,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Double-Pane - Draperies -- Closed Weave",0.57999999999999996,"Table 13G: Based on ID 5b, Medium Closed Weave",null,null,null,null,null,{"$f":"IF(OR(A31=\"\",B31=\"\",D31=\"\",H31=\"\"),\"\",IFERROR((D31*C31*(G31-H31))/($N$33*1000),\"\"))","v":""},"",{"$f":"IF(OR(D31=\"\",H31=\"\"),\"\",IFERROR((D31*AG31*(G31-H31))/($R$33*1000),\"\"))","v":""}]
[null,null,"",null,1.2,null,"",null,"","",null,null,null,"Cooling Efficiency* [SEER]",null,null,null,"Cooling Efficiency* [EER]",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,"",null,1.2,null,"",null,"","",null,null,null,12.64,null,null,null,10.17,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Total Window Film Incentives",null,null,null,null,null,null,null,{"$f":"SUM($I$22:$I$33)","v":0},null,null,null,null,null,null,null,null,null,"Peak Hourly Solar Heat Gain Factors"]
["*Cooling efficiency is a weighted average of HVAC cooling part load system efficiency of commercial buldings."]
[]
["Refrigeration Specifications"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Building Envelope: Window Film Specifications"]

{"sheet":"Food Service","index":10,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,3,6,6],[2,0,4,10],[0,2,0,8],[0,9,0,10],[1,0,1,3]]}
[null,null,"FOOD SERVICE EQUIPMENT INCENTIVES"]
[]
["Update: Starting 2020 Food Service equipment ONLY qualifies under the Distributor Discount Program. For details on how to participate in the program please visit our website (link below). "]
[]
[]
[]
[null,null,null,"Distributor Discount Program"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J35","v":0}]

{"sheet":"Custom","index":11,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[4,0,12,3],[0,3,0,5],[1,0,1,2],[0,8,0,9],[20,4,20,5],[16,7,24,7],[13,0,13,9],[15,0,15,3],[15,4,15,6],[14,0,14,9],[15,8,15,9],[23,4,23,6],[24,4,24,5],[16,0,24,3],[16,8,24,9],[17,4,17,6],[22,4,22,5],[2,0,2,9],[3,0,3,3],[3,4,3,6],[3,8,3,9],[4,7,12,7],[9,4,9,6],[5,4,5,6],[7,4,7,6],[4,4,4,5],[6,4,6,5],[8,4,8,5],[10,4,10,5],[11,4,11,6],[12,4,12,5],[4,8,12,9],[19,4,19,6],[21,4,21,6],[16,4,16,5],[18,4,18,5],[36,4,36,5],[25,0,25,9],[31,4,31,6],[33,4,33,6],[34,4,34,5],[35,4,35,6],[28,8,36,9],[29,4,29,6],[32,4,32,5],[28,7,36,7],[28,0,36,3],[27,0,27,3],[40,4,40,5],[40,7,48,7],[40,8,48,9],[42,4,42,5],[44,4,44,5],[27,4,27,6],[27,8,27,9],[26,0,26,9],[28,4,28,5],[30,4,30,5],[58,0,59,9],[39,0,39,3],[39,4,39,6],[39,8,39,9],[37,0,37,9],[38,0,38,9],[50,8,50,9],[41,4,41,6],[43,4,43,6],[45,4,45,6],[48,4,48,5],[46,4,46,5],[47,4,47,6],[50,0,50,7],[49,0,49,9],[40,0,48,3]]}
[null,null,null,"CUSTOM INCENTIVES"]
["Applicant: fill in gray fields",null,null,"*Please attach supporting documentation as described in the specifications*"]
["Item 1"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G5>0,G11>0,G13>0),MIN(G5*H5,G11,0.5*G13),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I5)=TRUE,I5,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 2"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G17>0,G23>0,G25>0),MIN(G17*H17,G23,0.5*G25),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I17)=TRUE,I17,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 3"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G29>0,G35>0,G37>0),MIN(G29*H29,G35,0.5*G37),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I29)=TRUE,I29,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 4"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G41>0,G47>0,G49>0),MIN(G41*H41,G47,0.5*G49),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I41)=TRUE,I41,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Total Custom Incentives",null,null,null,null,null,null,null,{"$f":"L51","v":0},null,null,{"$f":"L9+L21+L33+L45","v":0}]
[]
["Incremental measure cost (IMC) is the difference between the cost of an energy-efficient piece of equipment and a new"]
["standard-efficiency piece of equipment. The IMC of energy-efficient equipment installed before an old piece of equipment"]
["reaches the end of its life (such as lighting equipment) generally is equal to the total cost of the energy-efficient equipment,"]
["including labor. The IMC of energy-efficient equipment installed at or near the end of life of an old piece of equipment (such as"]
["chillers, motors, air-conditioning units) generally is equal to the difference in cost between the energy-efficient equipment and"]
["the new standard-efficiency piece of equipment, not including labor."]
["The rebate will be shown as 100% of the Incremental Measure Cost or 50% of the Total Project Cost. All Custom measures subject to approval using the Utility Cost Test (UCT). Submit calculations and costs for assistance."]
[]
[]
["Custom Specifications"]

{"sheet":"Horticulture Lighting","index":12,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[34,4,34,5],[29,4,29,6],[30,4,30,5],[31,4,31,6],[32,4,32,5],[33,4,33,6],[50,0,50,7],[50,8,50,9],[56,0,57,9],[40,0,48,3],[40,4,40,5],[40,7,48,7],[40,8,48,9],[41,4,41,6],[42,4,42,5],[43,4,43,6],[44,4,44,5],[45,4,45,6],[46,4,46,5],[9,4,9,6],[10,4,10,5],[47,4,47,6],[48,4,48,5],[49,0,49,9],[35,4,35,6],[36,4,36,5],[37,0,37,9],[38,0,38,9],[39,0,39,3],[39,4,39,6],[39,8,39,9],[28,0,36,3],[28,4,28,5],[28,7,36,7],[28,8,36,9],[22,4,22,5],[11,4,11,6],[12,4,12,5],[13,0,13,9],[14,0,14,9],[15,0,15,3],[15,4,15,6],[15,8,15,9],[4,0,12,3],[4,4,4,5],[4,7,12,7],[4,8,12,9],[5,4,5,6],[6,4,6,5],[7,4,7,6],[8,4,8,5],[23,4,23,6],[24,4,24,5],[25,0,25,9],[26,0,26,9],[27,0,27,3],[27,4,27,6],[27,8,27,9],[16,0,24,3],[16,4,16,5],[16,7,24,7],[16,8,24,9],[17,4,17,6],[18,4,18,5],[19,4,19,6],[20,4,20,5],[21,4,21,6],[0,8,0,9],[1,0,1,2],[2,0,2,9],[3,0,3,3],[3,4,3,6],[3,8,3,9],[0,1,0,7]]}
[null,"HORTICULTURE LIGHTING INCENTIVES"]
["Applicant: fill in gray fields",null,null,"*Please attach supporting documentation as described in the specifications*"]
["Item 1"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.06,{"$f":"IF(AND(G5>0,G11>0,G13>0),MIN(G5*H5,G11,0.5*G13),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I5)=TRUE,I5,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 2"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.06,{"$f":"IF(AND(G17>0,G23>0,G25>0),MIN(G17*H17,G23,0.5*G25),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I17)=TRUE,I17,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 3"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.06,{"$f":"IF(AND(G29>0,G35>0,G37>0),MIN(G29*H29,G35,0.5*G37),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I29)=TRUE,I29,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 4"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.06,{"$f":"IF(AND(G41>0,G47>0,G49>0),MIN(G41*H41,G47,0.5*G49),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(I41)=TRUE,I41,0)","v":0}]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Total Custom Incentives",null,null,null,null,null,null,null,{"$f":"L51","v":0},null,null,{"$f":"L9+L21+L33+L45","v":0}]
[]
["NOTES: Incremental measure cost (IMC) is the difference between the cost of an energy-efficient piece of equipment and a new"]
["standard-efficiency piece of equipment. The IMC of energy-efficient equipment installed before an old piece of equipment"]
["reaches the end of its life, such as lighting equipment generally is equal to the total cost of the energy-efficient equipment, including"]
["labor. "]
["The rebate will be shown as 100% of the Incremental Measure Cost or 50% of the Total Project Cost. All Custom measures subject to approval using the Utility Cost Test (UCT). Submit calculations and costs for assistance. See submission requirements in the "]
[]
["Specs tab of this spreadsheet.   A PRE-APPLICATION IS REQUIRED; THOSE APPLICATIONS SUBMITTED WITHOUT A PRE-"]
["APPLICATION WILL NOT BE ACCEPTED. "]
[]
["Horticulture Lighting Specifications"]