{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Form 120P-PAC","Summary","Multiple Sites","Option to Assign Payment","Lodging and Foodservice","Grocery","Computer","HVAC and Water Heating","Insulation","Service Shops and Warehouses","Admin Tools","Lookups","Showerhead-wand Lookup","Bathroom Aerator Lookup","Kitchen Aerator Lookup","Laundry Lookup","Vent Hood Lookup","Dish Under Counter Lookup","Dish Single Upright Lookup","Dish Single Conveyor Lookup","Dish Multi Conveyor Lookup","Dish Pot Pan Lookup","Add Doors Lookup","New Doors Lookup","Eligible Spaces"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":70,"comments":0,"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":"Form 120P-PAC","index":0,"n_rows":133,"n_cols":43,"rows_kept":133,"cut":false,"hidden":false,"merged":[[18,21,18,38],[15,21,15,38],[11,34,11,38],[11,25,11,31],[21,21,21,29],[21,31,21,38],[27,21,27,28],[27,30,27,38],[24,30,24,33],[24,21,24,29],[24,37,24,38],[24,34,24,35],[69,1,69,38],[70,2,70,38],[67,33,67,38],[55,1,56,8],[55,15,56,16],[63,1,63,6],[63,7,63,9],[57,30,57,38],[57,1,57,9],[57,11,57,19],[65,1,65,6],[65,7,65,9],[67,1,67,6],[67,7,67,9],[61,1,61,39],[58,1,59,9],[72,2,72,15],[72,17,72,32],[72,34,72,37],[107,1,108,21],[108,23,108,38],[140,23,143,38],[144,23,146,38],[76,1,89,21],[76,23,86,38],[87,23,92,38],[90,1,98,21],[93,23,96,38],[97,23,100,38],[99,1,102,21],[101,23,104,38],[103,1,106,21],[105,23,107,38],[35,21,35,38],[58,11,59,19],[52,1,52,19],[54,30,54,38],[54,18,54,19],[55,18,56,19],[55,11,56,14],[44,24,44,38],[49,24,49,31],[49,32,49,35],[49,36,49,38],[54,1,54,10],[54,11,54,15],[47,32,47,38]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[null,"To be completed by Participant"]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Use Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",null,null,null,null,null,null,null,null,null,null,"PT ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Participant Information"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal Business Name (must match Participant's submitted W-9)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumed Business Name or DBA"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name",null,null,null,null,null,null,null,null,null,"Title"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Participant Mailing Address",null,null,null,null,null,null,null,null,"City",null,null,null,null,"State",null,"Zip"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Phone",null,null,null,null,null,null,null,null,"Email Address"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Role:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Type:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business/Project Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Information "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric Utility:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(AP43,Lookups!A33:B36,2)","v":"(select)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Utility:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(AP47,Lookups!A39:B43,2)","v":"(select)"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:",null,null,null,null,null,null,null,null,null,null,"Rate Schedule:"]
[]
[]
[null,"Project and Site Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Space Heating Fuel Source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP($AP55,Lookups!$A$2:$B$5,2)","v":"None"}]
[null,"Site Address*",null,null,null,null,null,null,null,null,null,"City",null,null,null,"State",null,null,"Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Heating Fuel Source"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP($AP58,Lookups!$A$2:$B$5,2)","v":"None"}]
[null,"Contact name for Site Visit",null,null,null,null,null,null,null,null,null,"Phone number for Site Visit"]
[]
[]
[]
[]
[null,"Project Square Footage",null,null,null,null,null,null,null,null,null,"Building Use Type:"]
[]
[null,"Building Square Footage"]
[]
[null,"Year Built"]
[]
[null,"Participant Signature"]
[]
[]
[null,null,{"$f":"IF(ContactName=\"\",\"\",ContactName)","v":""}]
[null,null,"Authorized Representative Name (printed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,"TERMS AND CONDITIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TERMS AND CONDITIONS CONTINUED"]

{"sheet":"Summary","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,1,10,6],[20,1,21,4],[30,2,30,6],[16,1,16,4],[17,1,17,4],[27,5,27,6],[27,1,27,4],[33,2,33,6],[34,1,35,6],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[28,1,28,4],[28,5,28,6],[29,1,29,4],[29,5,29,6],[31,1,31,4],[31,5,31,6],[32,1,32,4],[32,5,32,6]]}
[]
[null,"Standard Incentives Summary"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"INCENTIVE TOTALS REQUESTED PER THIS APPLICATION \n(Actual incentives payable will depend on applicable per site, per year limits)"]
[null,"EQUIPMENT",null,null,null,"REQUESTED\nINCENTIVES","INSTALLED\nCOST"]
[null,"Lodging and Foodservice",null,null,null,{"$f":"TOTAL_LODGING_INCENTIVES","v":0},{"$f":"TOTAL_LODGING_INSTALLED_COST","v":0}]
[null,"Grocery",null,null,null,{"$f":"TOTAL_GROCERY_INCENTIVES","v":0},{"$f":"TOTAL_GROCERY_INSTALLED_COST","v":0}]
[null,"Computer",null,null,null,{"$f":"TOTAL_COMPUTER_INCENTIVES","v":0},{"$f":"TOTAL_COMPUTER_INSTALLED_COST","v":0}]
[null,"HVAC and Water Heating",null,null,null,{"$f":"TOTAL_HVAC_INCENTIVES","v":0},{"$f":"TOTAL_HVAC_INSTALLED_COST","v":0}]
[null,"Insulation",null,null,null,{"$f":"TOTAL_INSULATION_INCENTIVES","v":0},{"$f":"TOTAL_INSULATION_INSTALLED_COST","v":0}]
[null,"Service Shops and Warehouses",null,null,null,{"$f":"TOTAL_SERVICE_INCENTIVES","v":0},{"$f":"TOTAL_SERVICE_INSTALLED_COST","v":0}]
[]
[]
[null,"COMBINED TOTALS REQUESTED FOR ALL INCENTIVES",null,null,null,"TOTAL REQUESTED \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,{"$f":"SUM(F13:F18)","v":0},{"$f":"SUM(G13:G18)","v":0}]
[]
[null," "]
[]
[]
[]
[null,"SITES SERVED BY AN ELECTRIC UTILITY",null,null,null,"INCENTIVE CAP"]
[null,"Site served by Portland General Electric",null,null,null,12000]
[null,"Site served by Pacific Power (and not served by Cascade Natural Gas)",null,null,null,6000]
[]
[null,"For Program Use Only",null,null,null,"TOTAL INCENTIVES"]
[null,"Combined Total Incentive Approved"]

{"sheet":"Multiple Sites","index":2,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":true,"merged":[[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[7,12,7,13],[7,9,7,10],[10,7,10,8],[10,11,10,12],[9,11,9,12],[9,7,9,8],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[17,11,17,12],[89,7,89,8],[90,7,90,8],[83,7,83,8],[84,7,84,8],[85,7,85,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[80,7,80,8],[81,7,81,8],[82,7,82,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[95,7,95,8],[96,7,96,8],[97,7,97,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[74,7,74,8],[75,7,75,8],[76,7,76,8],[65,7,65,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[59,7,59,8],[60,7,60,8],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[48,11,48,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[78,11,78,12],[79,11,79,12],[80,11,80,12],[81,11,81,12],[82,11,82,12],[83,11,83,12],[72,11,72,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[76,11,76,12],[77,11,77,12],[96,11,96,12],[97,11,97,12],[90,11,90,12],[91,11,91,12],[92,11,92,12],[93,11,93,12],[94,11,94,12],[95,11,95,12],[84,11,84,12],[85,11,85,12],[86,11,86,12],[87,11,87,12],[88,11,88,12],[89,11,89,12]]}
[]
["Standard Incentives for Pacific Power Customers"]
["Existing Buildings | Incentive Application | Form 120P"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Program Use Only",null,null,null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},null,"PT ID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
["Multiple Sites"]
["Location\n(Bldg Name / Store #)","Site Address","City","State","Zip","Electric \nUtility","Electric \nAccount Number","Gas \nUtility",null,"Gas Account Number","Gas Rate Schedule","Primary Heating \nFuel Source",null,"Water Heating \nFuel Source"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]
[null,null,null,null,null,"(select)",null,"(select)",null,null,null,"(select)",null,"(select)"]

{"sheet":"Option to Assign Payment","index":3,"n_rows":30,"n_cols":33,"rows_kept":30,"cut":false,"hidden":true,"merged":[[27,26,27,27],[29,22,30,31],[28,6,28,12],[29,1,30,3],[29,4,30,9],[29,20,30,21],[27,1,28,5],[15,1,16,32],[9,15,9,17],[9,18,9,23],[9,24,9,26],[9,27,9,32],[11,1,12,32],[17,1,17,32],[18,1,19,7],[18,8,18,16],[18,18,18,27],[18,29,18,31],[19,8,19,16],[19,18,19,27],[19,29,19,31],[20,8,20,31],[25,8,25,31],[26,8,26,32],[25,1,26,7],[27,19,27,25],[27,6,27,18],[23,1,24,7],[23,8,23,16],[23,18,23,27],[23,29,23,31],[24,8,24,16],[24,18,24,27],[24,29,24,31],[21,8,21,32],[20,1,21,7],[27,29,27,31]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Option to Assign Payment | Form 120P"]
[]
[null,"To be completed by Participant"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Use Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",null,null,{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},null,null,null,null,null,"PT ID",null,null,{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"Option to Assign Incentive Payment\nPLEASE NOTE: The Energy Trust incentive payment will be made to Participant unless Participant and its designated Payee complete the section below to assign the payment to Payee. A complete, accurate and verifiable IRS Form W-9 (Request for Taxpayer Identification Number and Certification) for the Payee named below must be attached if this option is selected."]
[]
[]
[null,"PARTICIPANT AND PAYEE"]
[null,"Both Participant and Payee understand and agree that if this Option to Assign Incentive Payment is selected the incentive check will be issued to the Payee named below at the address listed below and Energy Trust is not responsible for any tax liabilities that may be associated with the incentive payment. In addition, Participant understands that, notwithstanding this assignment, responsibility for complying with the terms and conditions of this incentive agreement shall continue to be the obligation of Participant, and Energy Trust's sole responsibility under this incentive agreement shall be to Participant. Accordingly, Payee understands that it shall have no rights against Energy Trust or the PMC with respect to such assignment or the payment of the incentive, and in the event that Energy Trust does not pay the incentive as a result of Participant's failure to comply with this agreement, Payee's sole recourse shall be against Participant. Participant directs Energy Trust to pay any incentive to which it is entitled to the Payee named below and waives all rights to directly receive the Energy Trust incentives for the identified energy-efficiency project. "]
[]
[null,"SIGNATURES: By my signature below, I represent to Energy Trust that I have read this agreement and am duly authorized to sign this Option to Assign Incentive Payment on behalf of the party for whom I am signing."]
[null,"On behalf of Participant\n(Authorized Representative)",null,null,null,null,null,null,{"$f":"IF(ContactName=\"\",\"\",ContactName)","v":""}]
[null,null,null,null,null,null,null,null,"(printed)",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,"Date"]
[null,"Participant ",null,null,null,null,null,null,{"$f":"IF(BusinessName=\"\",\"\",BusinessName)","v":""}]
[null,null,null,null,null,null,null,null,"(Legal business name as shown on W9)"]
[]
[null,"On behalf of Payee\n(Authorized Representative)"]
[null,null,null,null,null,null,null,null,"(printed)",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,"Date"]
[null,"Payee Name"]
[null,null,null,null,null,null,null,null,"\n(must match submitted IRS Form W-9)"]
[null,"Mailing Address                                        (for check)"]
[null,null,null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,"Zip"]
[null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email"]

{"sheet":"Lodging and Foodservice","index":4,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[80,1,80,17],[77,2,77,13],[63,5,63,6],[62,5,62,6],[61,5,61,6],[63,3,63,4],[75,2,75,13],[68,2,68,13],[54,2,54,13],[61,3,61,4],[73,2,73,13],[61,7,61,9],[60,7,60,9],[62,10,62,11],[59,7,59,9],[72,1,72,17],[61,10,61,11],[60,10,60,11],[59,10,59,11],[63,7,63,9],[62,7,62,9],[56,2,56,13],[63,10,63,11],[58,1,64,1],[10,1,10,17],[42,2,42,13],[43,2,43,13],[47,2,47,13],[21,1,26,1],[26,2,26,13],[27,1,29,1],[27,2,27,13],[28,2,28,13],[29,2,29,13],[12,17,15,17],[34,1,37,1],[11,2,11,13],[16,2,16,13],[12,2,12,13],[12,14,15,14],[12,16,15,16],[19,2,19,13],[21,14,26,14],[16,1,18,1],[12,1,15,1],[38,14,38,17],[12,15,15,15],[25,7,25,10],[84,1,84,17],[58,2,58,13],[57,2,57,13],[21,17,26,17],[58,17,64,17],[48,2,48,13],[66,2,66,13],[55,2,55,13],[51,2,51,13],[67,2,67,13],[74,2,74,13],[62,3,62,4],[59,3,59,4],[65,2,65,13],[59,5,59,6],[60,5,60,6],[60,3,60,4],[58,14,64,14],[81,1,82,15],[76,2,76,13],[78,2,78,13],[69,2,69,13],[58,15,64,15],[58,16,64,16],[53,1,53,17],[36,2,36,13],[34,14,34,17],[25,4,25,6],[24,4,24,6],[23,4,23,6],[27,14,27,17],[38,1,41,1],[41,2,41,13],[40,2,40,13],[39,2,39,13],[38,2,38,13],[45,2,45,13],[46,2,46,13],[44,2,44,13],[32,1,32,17],[33,2,33,13],[24,7,24,10],[13,2,13,8],[13,9,13,12],[14,2,14,9],[14,10,14,12],[50,2,50,13],[20,2,20,13],[16,17,18,17],[37,2,37,13],[35,2,35,13],[34,2,34,13],[22,4,22,6],[21,2,21,13],[15,7,15,13],[17,2,18,6],[17,7,17,12],[18,7,18,13],[21,15,26,15],[21,16,26,16],[22,7,22,10],[16,15,18,15],[16,16,18,16],[16,14,18,14],[49,2,49,13],[23,7,23,10]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"LODGING AND FOODSERVICE"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Ductless Heat\n Pump (DHP) ",null,null,null,null,null,null,null,null,null,null,null,null,200,null,{"$f":"P13*O13","v":0}]
[null,null,"   \u009f\u009f Total lodging rooms on site:"]
[null,null,"   \u009f\u009f Is baseboard heating present at this site?"]
[]
[null," Packaged Terminal \n Heat Pump ",null,null,null,null,null,null,null,null,null,null,null,null,40,null,{"$f":"O17*P17","v":0}]
[null,null,"   \u009f\u009f Total lodging rooms on site:"]
[]
[null," Spa Cover ",null,null,null,null,null,null,null,null,null,null,null,null,100,null,{"$f":"O20*P20","v":0}]
[null,"Commercial Pool Cover  ",null,null,null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"O21*P21","v":0}]
[null," Commercial Pool\n Pump  ",null,null,null,null,null,null,null,null,null,null,null,null,230,null,{"$f":"P22*O22","v":0}]
[null,null,null,null," Total HP",null,null," Minimum WEF"]
[null,null,null,null," > 0 to < 1 hp",null,null," > 8.33 hp"]
[null,null,null,null," > 1 to < 2 hp",null,null," > 6.81 hp"]
[null,null,null,null," > 2 to < 2.5 hp",null,null," > 5.85 hp"]
[]
[null," Commercial\n Condensing Pool\n Heater"]
[null,null," Indoor pool surface area must be a minimum of 1,350 sq ft",null,null,null,null,null,null,null,null,null,null,null,2.35,null,{"$f":"P29*O29","v":0}]
[null,null," Outdoor pool surface area must be a minimum of 900 sq ft",null,null,null,null,null,null,null,null,null,null,null,3.5,null,{"$f":"P30*O30","v":0}]
[]
[]
[null,"LODGING AND FOODSERVICE continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Commercial \n Laundry Washer "]
[null,null,"Site has electric or gas water heating with electric dryer",null,null,null,null,null,null,null,null,null,null,null,200,null,{"$f":"P36*O36","v":0}]
[null,null,"Site has electric or gas water heating with a gas dryer",null,null,null,null,null,null,null,null,null,null,null,180,null,{"$f":"P37*O37","v":0}]
[null,null,"Site has gas water heating and electricity from a non-participating utility",null,null,null,null,null,null,null,null,null,null,null,65,null,{"$f":"P38*O38","v":0}]
[null," Gas-fired Automatic\n Conveyor Broiler "]
[null,null," Total conveyor belt width < 22”",null,null,null,null,null,null,null,null,null,null,null,2015,null,{"$f":"P40*O40","v":0}]
[null,null," Total conveyor belt width ≥ 22” to ≤ 28”",null,null,null,null,null,null,null,null,null,null,null,2515,null,0]
[null,null," Total conveyor belt width > 28”",null,null,null,null,null,null,null,null,null,null,null,2925,null,0]
[null," Electric Griddle ",null,null,null,null,null,null,null,null,null,null,null,null,400,null,0]
[null," Gas Combination\n Oven",null,null,null,null,null,null,null,null,null,null,null,null,750,null,0]
[null," Electric Combination Oven ",null,null,null,null,null,null,null,null,null,null,null,null,1000,null,0]
[null," Gas Convection\n Oven",null,null,null,null,null,null,null,null,null,null,null,null,315,null,0]
[null," Electric Convection Oven  ",null,null,null,null,null,null,null,null,null,null,null,null,315,null,{"$f":"P47*O47","v":0}]
[null," Gas Single Rack\n Oven",null,null,null,null,null,null,null,null,null,null,null,null,2500,null,{"$f":"P48*O48","v":0}]
[null," Gas Double Rack\n Oven",null,null,null,null,null,null,null,null,null,null,null,null,5000,null,0]
[null," Gas Fryer",null,null,null,null,null,null,null,null,null,null,null,null,1000,null,0]
[null," Electric Fryer ",null,null,null,null,null,null,null,null,null,null,null,null,225,null,{"$f":"P51*O51","v":0}]
[null,"Commercial Ice Maker ",null,null,null,null,null,null,null,null,null,null,null,null,150,null,0]
[]
[null,"LODGING AND FOODSERVICE continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Electric Hot Food\n Cabinet ",null,null,null,null,null,null,null,null,null,null,null,null,350,null,{"$f":"P56*O56","v":0}]
[null," Gas Steam\n Cooker",null,null,null,null,null,null,null,null,null,null,null,null,1850,null,{"$f":"P57*O57","v":0}]
[null," Electric Steam\n Cooker ",null,null,null,null,null,null,null,null,null,null,null,null,2500,null,{"$f":"P58*O58","v":0}]
[null," Commercial\n Vent Hood with\n Demand Controlled \n Ventilation  ",null,null,null,null,null,null,null,null,null,null,null,null,750,null,{"$f":"P59*O59","v":0}]
[null,null,null," Heating\n Fuel ",null," Participating\n Electric\n Utility",null," Participating\n Gas Utility",null,null," Total Controlled HP"]
[null,null,null," Electric",null," Yes",null,"N/A",null,null," > 1 hp"]
[null,null,null," Gas",null," Yes",null," Yes",null,null," > 3 hp"]
[null,null,null," Gas",null," No",null," Yes",null,null," > 4 hp"]
[null,null,null," Gas or Other",null," Yes",null," No",null,null," > 3 hp"]
[]
[null," Pre-Rinse Spray \n Valve ",null,null,null,null,null,null,null,null,null,null,null,null,30,null,{"$f":"O66*P66","v":0}]
[null," Dishwasher,\n Under Counter,\n Low Temp ",null,null,null,null,null,null,null,null,null,null,null,null,195,null,{"$f":"P67*O67","v":0}]
[null," Dishwasher,\n Under Counter, \n High Temp ",null,null,null,null,null,null,null,null,null,null,null,null,600,null,0]
[null," Dishwasher,\n Single Tank,\n Door/Upright,\n Low Temp ",null,null,null,null,null,null,null,null,null,null,null,null,550,null,0]
[null," Dishwasher,\n Single Tank,\n Door/Upright,\n High Temp ",null,null,null,null,null,null,null,null,null,null,null,null,825,null,0]
[]
[]
[null,"LODGING AND FOODSERVICE continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Dishwasher,\n Single Tank,\n Conveyor,\n Low Temp ",null,null,null,null,null,null,null,null,null,null,null,null,900,null,{"$f":"P75*O75","v":0}]
[null," Dishwasher,\n Single Tank,\n Conveyor,\n High Temp ",null,null,null,null,null,null,null,null,null,null,null,null,900,null,{"$f":"P76*O76","v":0}]
[null," Dishwasher,\n Multi-Tank,\n Conveyor,\n Low Temp ",null,null,null,null,null,null,null,null,null,null,null,null,800,null,0]
[null," Dishwasher,\n Multi-Tank,\n Conveyor,\n High Temp ",null,null,null,null,null,null,null,null,null,null,null,null,800,null,0]
[null," Dishwasher,\n Pot, Pan and\n Utensil,\n High Temp ",null,null,null,null,null,null,null,null,null,null,null,null,350,null,0]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR LODGING AND FOODSERVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL REQUESTED\nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q13:Q27,Q29:Q30,Q40:Q43,Q36:Q38,Q44:Q58,Q59:Q76,Q77:Q79)","v":0},{"$f":"SUM(R13:R27,R29:R30,R40:R43,R36:R38,R44:R58,R59:R76,R77:R79)","v":0}]

{"sheet":"Grocery","index":5,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,14,0],[12,2,12,10],[20,2,20,10],[18,0,20,0],[19,2,19,10],[17,2,17,10],[14,2,14,10],[13,2,13,10],[12,1,14,1],[10,1,10,14],[11,2,11,10],[12,16,14,16],[12,15,14,15],[12,11,12,14],[18,16,20,16],[16,1,16,14],[18,1,20,1],[18,15,20,15],[27,1,27,14],[24,1,25,12],[21,2,21,10],[18,2,18,10],[18,11,18,14],[23,1,23,14]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"GROCERY - Refrigeration"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Strip Curtains ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Walk-in cooler for grocery stores and warehouses",null,null,null,null,null,null,null,null,6,null,{"$f":"M14*L14","v":0}]
[null,null," Walk-in freezer for grocery stores and restaurants",null,null,null,null,null,null,null,null,6,null,{"$f":"M15*L15","v":0}]
[]
[null,"GROCERY - Packaging"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,"INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Variable Frequency\n Drive (VFD) ",null,null,null,null,null,null,null,null,null,{"$f":"IF(Q19=0,\"\",IF(ELE_NUM=0,\"\",IF(ELE_NUM=3,\"Does Not Qualify - Site must receive electricity from a participating utility\",#REF!*M19)))","v":""},null,null,null,null,0]
[null,null,"Air Cooled Condenser",null,null,null,null,null,null,null,null,300,null,{"$f":"M20*L20","v":0}]
[null,null,"Evaporatively Cooled Condenser",null,null,null,null,null,null,null,null,300,null,{"$f":"M21*L21","v":0}]
[null," On-Demand\n Overwrapper ",null,null,null,null,null,null,null,null,null,275,null,{"$f":"M22*L22","v":0}]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR GROCERY",null,null,null,null,null,null,null,null,null,null,null,"TOTAL REQUESTED\nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N14:N15,N20:N21,N22:N22)","v":0},{"$f":"SUM(O14:O15,O20:O21,O22:O22)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"Computer","index":6,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,17,4],[10,1,10,6],[27,2,27,6],[28,2,28,6],[15,1,15,6],[29,1,30,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"COMPUTER"]
[null,"EQUIPMENT","REQUIREMENTS","INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Server/Telecom\n Room - \n Mini-Split Air\n Conditioner ",null,200,null,{"$f":"D13*E13","v":0}]
[]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR COMPUTER",null,null,null,"TOTAL REQUESTED \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,{"$f":"SUM(F13:F13)","v":0},{"$f":"SUM(G13:G13)","v":0}]
[]
[null," "]

{"sheet":"HVAC and Water Heating","index":7,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":false,"merged":[[86,1,88,1],[87,2,87,11],[88,2,88,3],[86,12,88,12],[86,13,88,13],[86,14,88,14],[86,15,88,15],[97,1,98,13],[86,2,86,11],[90,1,92,1],[90,2,90,11],[90,12,90,15],[91,2,91,11],[92,2,92,11],[96,1,96,15],[85,2,85,11],[66,14,69,14],[53,8,54,11],[68,5,68,7],[68,8,68,9],[72,2,72,11],[78,2,78,11],[73,1,81,1],[81,2,81,11],[80,2,80,11],[66,1,69,1],[79,2,79,11],[84,1,84,15],[71,2,71,11],[64,1,64,15],[65,2,65,11],[60,1,60,15],[67,2,67,11],[66,15,69,15],[66,12,69,12],[59,2,59,11],[53,13,54,13],[12,0,14,0],[18,0,20,0],[15,0,17,0],[73,0,77,0],[78,0,81,0],[66,0,68,0],[50,0,52,0],[15,2,15,11],[46,2,46,6],[46,7,47,11],[47,2,47,6],[48,2,48,6],[48,7,49,11],[49,2,49,6],[22,2,22,11],[22,0,24,0],[22,1,24,1],[16,2,16,11],[15,1,17,1],[77,2,77,11],[76,2,76,11],[75,2,75,11],[73,2,73,11],[74,2,74,11],[55,0,58,0],[55,2,55,11],[55,12,55,15],[56,2,56,11],[57,2,57,11],[58,2,58,11],[53,14,54,14],[50,1,54,1],[40,1,49,1],[41,2,41,4],[53,15,54,15],[50,2,50,11],[51,2,51,11],[40,12,43,15],[22,12,22,15],[43,7,43,11],[44,2,44,6],[44,7,45,11],[45,2,45,6],[40,2,40,11],[52,2,52,11],[55,1,58,1],[35,1,35,15],[26,2,26,4],[25,12,28,15],[32,2,32,6],[39,2,39,11],[25,1,34,1],[78,17,81,17],[73,16,77,16],[73,17,77,17],[66,16,68,16],[66,17,68,17],[78,16,81,16],[43,2,43,6],[24,2,24,11],[23,2,23,11],[68,2,69,3],[28,2,28,6],[29,2,29,6],[30,2,30,6],[34,2,34,6],[28,7,28,11],[78,12,78,15],[70,2,70,11],[73,12,74,15],[66,13,69,13],[66,2,66,11],[50,12,52,12],[50,13,52,13],[50,14,52,14],[50,15,52,15],[12,16,14,16],[12,17,14,17],[15,17,17,17],[18,16,20,16],[18,17,20,17],[22,16,24,16],[22,17,24,17],[15,16,17,16],[55,16,58,16],[55,17,58,17],[50,16,52,16],[50,17,52,17],[10,1,10,15],[38,1,38,15],[12,12,12,15],[14,2,14,11],[12,1,14,1],[33,2,33,6],[31,2,31,6],[29,7,30,11],[31,7,32,11],[33,7,34,11],[29,13,30,15],[12,2,12,11],[11,2,11,11],[13,2,13,11],[17,2,17,11],[25,2,25,11],[18,12,18,15],[20,2,20,11],[19,2,19,11],[18,2,18,11],[18,1,21,1],[21,2,21,11],[21,12,21,15],[15,12,15,15]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"HVAC AND WATER HEATING"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Infrared Radiant\n Heater"]
[null,null,"Non-Modulating",null,null,null,null,null,null,null,null,null,5.5,null,{"$f":"M14*N14","v":0}]
[null,null,"Modulating",null,null,null,null,null,null,null,null,null,7,null,{"$f":"M15*N15","v":0}]
[null," New Rooftop Unit\n (RTU) with\n Economizer "]
[null,null,"Space heated by electric heat pump ",null,null,null,null,null,null,null,null,null,30]
[null,null,"Space heated by gas furnace",null,null,null,null,null,null,null,null,null,30,null,{"$f":"M18*N18","v":0}]
[null," New RTU with\n Demand Control\n Ventilation (DCV) "]
[null,null,"Space heated by electric heat pump ",null,null,null,null,null,null,null,null,null,29,null,{"$f":"M20*N20","v":0}]
[null,null,"Space heated by gas furnace",null,null,null,null,null,null,null,null,null,29,null,{"$f":"M21*N21","v":0}]
[null,null,"*Describe the space that the RTU will serve:\n (contact Energy Trust for eligible space types)"]
[null," New RTU with \n Variable Speed\n Supply Fan "]
[null,null,"Space heated by electric heat pump ",null,null,null,null,null,null,null,null,null,100,null,{"$f":"M24*N24","v":0}]
[null,null,"Space heated by gas furnace",null,null,null,null,null,null,null,null,null,100,null,{"$f":"M25*N25","v":0}]
[null," Advanced Rooftop \n Controls (ARC) - \n Lite Retrofit "]
[null,null,"Annual operating hours:"]
[]
[null,null,"Rooftop Unit Heating Fuel",null,null,null,null,"Participating Utilities"]
[null,null,"Electric Heat",null,null,null,null,"Gas Only",null,null,null,null,"Not eligible"]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,"Not eligible"]
[null,null,"Electric Heat ",null,null,null,null,"Electric Only ",null,null,null,null,100,null,{"$f":"M32*N32","v":0}]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,100,null,{"$f":"M33*N33","v":0}]
[null,null,"Electric Heat",null,null,null,null,"Gas and Electric",null,null,null,null,100,null,{"$f":"M34*N34","v":0}]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,100,null,{"$f":"M35*N35","v":0}]
[]
[]
[]
[null,"HVAC AND WATER HEATING continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," ARC - Full Retrofit "]
[null,null,"Annual operating hours:"]
[]
[null,null,"Rooftop Unit Heating Fuel",null,null,null,null,"Participating Utilities"]
[null,null,"Electric Heat",null,null,null,null,"Gas Only",null,null,null,null,"Not eligible"]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,50,null,{"$f":"M46*N46","v":0}]
[null,null,"Electric Heat ",null,null,null,null,"Electric Only",null,null,null,null,200,null,{"$f":"M47*N47","v":0}]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,200,null,0]
[null,null,"Electric Heat",null,null,null,null,"Gas and Electric",null,null,null,null,200,null,0]
[null,null,"Gas Heat",null,null,null,null,null,null,null,null,null,200,null,0]
[null," Air-Cooled\n Variable\n Refrigerant Flow\n (VRF) Multi-Split\n Heat Pump ",null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"M51*N51","v":0}]
[null,null,"Standard DOAS: \nMinimum fan efficiency 40% or minimum fan efficiency index target 0.82  "]
[null,null,"High Efficiency DOAS: \nMinimum fan efficiency 65% or minimum fan efficiency index target 1.55 "]
[null,null,"\n",null,null,null,null,null,"Ducted heat pump\n for office building",null,null,null,"Bonus incentive:",null,{"$f":"N54*M55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,4]
[null," Steam Trap"]
[null,null,"Low pressure (£ 15 psig)",null,null,null,null,null,null,null,null,null,0.9,null,{"$f":"M57*N57","v":0}]
[null,null,"Medium pressure (> 15 psig and £ 100 psig)",null,null,null,null,null,null,null,null,null,0.5,null,{"$f":"M58*N58","v":0}]
[null,null,"*Dry cleaners (pre-testing is not required)",null,null,null,null,null,null,null,null,null,0.4,null,{"$f":"M59*N59","v":0}]
[null," Commercial Tank \n Water Heater",null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"M60*N60","v":0}]
[]
[]
[]
[]
[null,"HVAC AND WATER HEATING continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Commercial\n Tankless\n Water Heater\n < 200 kBtu/h input ",null,null,null,null,null,null,null,null,null,null,165,null,{"$f":"M67*N67","v":0},null,null,0]
[null,null,"   \u009f Is there an existing water storage tank attached?"]
[null,null,null,null,null,"If yes, what is the capacity?"]
[]
[null," Commercial\n Tankless Water\n Heater/Boiler\n ≥ 200 kBtu/h input ",null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"M71*N71","v":0}]
[null," Commercial\n Condensing\n HVAC Boiler",null,null,null,null,null,null,null,null,null,null,3.25,null,{"$f":"M72*N72","v":0}]
[null," Modulating\n Boiler Burner",null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"M73*N73","v":0}]
[null," Hydronic Heating\n Circulator Pumps "]
[null,null,"Single Speed ECM"]
[null,null,"< 3/4 HP",null,null,null,null,null,null,null,null,null,100,null,{"$f":"M76*N76","v":0}]
[null,null," ≥ 3/4 HP to < 2 HP",null,null,null,null,null,null,null,null,null,200,null,0]
[null,null,"≥ 2 HP",null,null,null,null,null,null,null,null,null,300,null,0]
[null,null,"Variable Speed ECM"]
[null,null,"< 3/4 HP",null,null,null,null,null,null,null,null,null,150,null,{"$f":"M80*N80","v":0}]
[null,null," ≥ 3/4 HP to < 2 HP",null,null,null,null,null,null,null,null,null,400,null,0]
[null,null,"≥ 2 HP",null,null,null,null,null,null,null,null,null,750,null,0]
[]
[]
[null,"HVAC AND WATER HEATING continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,null,null,null,null,null,null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Commercial \n Air-Source Heat \n Pump - Retrofit  ",null,null,null,null,null,null,null,null,null,null,500,null,{"$f":"N87*M87","v":0}]
[null,null,"   \u009f Did the space served have existing cooling capabilities?"]
[]
[null," Commercial \n Air-Source Heat \n Pump - New or \n Replacement ",null,null,null,null,null,null,null,null,null,null,150,null,{"$f":"N90*M90","v":0}]
[null," Commercial Heat \n Pump Water \n Heater (HPWH) "]
[null,null,"Ducted HPWH",null,null,null,null,null,null,null,null,null,500,null,{"$f":"M92*N92","v":0}]
[null,null,"Non-ducted HPWH",null,null,null,null,null,null,null,null,null,500,null,{"$f":"M93*N93","v":0}]
[null,"⁷ NEEA Advanced Water Heater Specification Version 7.0: https://neea.org/img/documents/Advanced-Water-Heating-Specification.pdf; "]
[]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR HVAC AND WATER HEATING",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL REQUESTED\nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:O15,O17:O18,O20:O21,O24:O25,O32:O35,O46:O50,O51:O55,O57:O60,O67:O73,O76:O78,O80:O82,O87:O90,O92:O93)","v":0},{"$f":"SUM(P14:P15,P17:P18,P20:P21,P24:P25,P32:P35,P46:P50,P51:P55,P57:P60,P67:P73,P76:P78,P80:P82,P87:P90,P92:P93)","v":0}]

{"sheet":"Insulation","index":8,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[[11,1,17,1],[18,2,18,4],[28,2,28,4],[54,2,54,4],[53,2,53,4],[18,1,24,1],[36,1,42,1],[60,1,61,6],[46,2,46,4],[53,1,57,1],[46,1,52,1],[29,1,35,1],[55,2,55,4],[56,2,56,4],[57,2,57,4],[45,2,45,4],[36,2,36,4],[29,2,29,4],[53,5,53,8],[29,5,30,8],[46,5,47,8],[59,1,59,8],[10,2,10,4],[11,5,12,8],[11,2,11,4],[18,5,19,8],[36,5,37,8]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[null,null,null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"INSULATION"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Attic Insulation,\n R-0 to R-25"]
[null,null," Building \nHeating Fuel ","Pacific Power"," Participating\n Gas Utility"]
[null,null,"Heat Pump"," Yes","N/A",0.6,null,{"$f":"F14*G14","v":0}]
[null,null," Electric resistance"," Yes","N/A",0.6,null,{"$f":"F15*G15","v":0}]
[null,null," Gas"," Yes"," Yes",0.6,null,{"$f":"F16*G16","v":0}]
[null,null," Gas"," No"," Yes",0.6,null,{"$f":"F17*G17","v":0}]
[null,null," Gas or Other"," Yes"," No",0.6,null,{"$f":"F18*G18","v":0}]
[null," Roof Insulation,\n R-0 to R-15"]
[null,null," Building \nHeating Fuel ","Pacific Power"," Participating\n Gas Utility"]
[null,null,"Heat Pump"," Yes","N/A",0.5,null,{"$f":"F21*G21","v":0}]
[null,null," Electric resistance"," Yes","N/A",0.5,null,{"$f":"F22*G22","v":0}]
[null,null," Gas"," Yes"," Yes",0.5,null,{"$f":"F23*G23","v":0}]
[null,null," Gas"," No"," Yes",0.5,null,{"$f":"F24*G24","v":0}]
[null,null," Gas or Other"," Yes"," No",0.5,null,{"$f":"F25*G25","v":0}]
[]
[]
[null,"INSULATION continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Roof Insulation,\n R-0 to R-30"]
[null,null," Building \nHeating Fuel ","Pacific Power"," Participating\n Gas Utility"]
[null,null,"Heat Pump"," Yes","N/A",1,null,{"$f":"F32*G32","v":0}]
[null,null," Electric resistance"," Yes","N/A",1,null,{"$f":"F33*G33","v":0}]
[null,null," Gas"," Yes"," Yes",1,null,{"$f":"F34*G34","v":0}]
[null,null," Gas"," No"," Yes",1,null,{"$f":"F35*G35","v":0}]
[null,null," Gas or Other"," Yes"," No",1,null,{"$f":"F36*G36","v":0}]
[null," Roof Insulation,\n R-5 to R-30"]
[null,null," Building \nHeating Fuel ","Pacific Power"," Participating\n Gas Utility"]
[null,null,"Heat Pump"," Yes","N/A",1,null,{"$f":"F39*G39","v":0}]
[null,null," Electric resistance"," Yes","N/A",1,null,{"$f":"F40*G40","v":0}]
[null,null," Gas"," Yes"," Yes",1,null,{"$f":"F41*G41","v":0}]
[null,null," Gas"," No"," Yes",1,null,{"$f":"F42*G42","v":0}]
[null,null," Gas or Other"," Yes"," No",1,null,{"$f":"F43*G43","v":0}]
[]
[null,"INSULATION continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Wall Insulation,\n R-0 to R-20"]
[null,null," Building \nHeating Fuel ","Pacific Power"," Participating\n Gas Utility"]
[null,null,"Heat Pump"," Yes","N/A",0.6,null,{"$f":"F49*G49","v":0}]
[null,null," Electric resistance"," Yes","N/A",0.6,null,{"$f":"F50*G50","v":0}]
[null,null," Gas"," Yes"," Yes",0.6,null,{"$f":"F51*G51","v":0}]
[null,null," Gas"," No"," Yes",0.6,null,{"$f":"F52*G52","v":0}]
[null,null," Gas or Other"," Yes"," No",0.6,null,{"$f":"F53*G53","v":0}]
[null," Pipe Insulation  "]
[null,null,"Piping serving domestic hot water",null,null,4,null,{"$f":"F55*G55","v":0}]
[null,null,"Piping serving medium pressure steam (15-200 psig)",null,null,12,null,{"$f":"F56*G56","v":0}]
[null,null,"Piping serving heating hot water",null,null,4,null,{"$f":"F57*G57","v":0}]
[null,null,"Piping serving low pressure steam (< 15 psig)",null,null,8,null,{"$f":"F58*G58","v":0}]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR INSULATION",null,null,null,null,null,"TOTAL REQUESTED\nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,{"$f":"SUM(H65:H71)","v":0},{"$f":"SUM(I14:I18,I21:I25,I32:I36,I39:I43,I49:I53,I55:I58)","v":0}]
[]
[]
[null,null,null,null,null,null,"PAC heat subtotal",{"$f":"IF(ELE=\"Pacific Power\",MIN(6000,SUM(H14:H15,H21:H22,H32:H33,H39:H40,H49:H50)),0)","v":0}]
[null,null,null,null,null,null,"PGE heat subtotal",{"$f":"IF(ELE=\"PGE\",0,0)","v":0}]
[null,null,null,null,null,null,"Other heat subtotal",{"$f":"IF(ELE=\"Other\",0,0)","v":0}]
[null,null,null,null,null,null,"GAS heat PAC subtotal",{"$f":"IF(ELE=\"Pacific Power\",MIN(6000,SUM(H16,H23,H34,H41,H51)),0)","v":0}]
[null,null,null,null,null,null,"GAS heat PGE subtotal",{"$f":"IF(ELE=\"PGE\",0,0)","v":0}]
[null,null,null,null,null,null,"GAS heat Other subtotal",{"$f":"IF(ELE=\"Other\",0,0)","v":0}]
[null,null,null,null,null,null,"no cap subtotal",{"$f":"SUM(H17:H18,H24:H25,H35:H36,H42:H43,H52:H53,H55:H58)","v":0}]

{"sheet":"Service Shops and Warehouses","index":9,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,1,32,6],[26,2,26,6],[27,2,27,6],[10,1,10,6],[18,1,19,4],[24,2,24,6],[25,2,25,6],[17,1,17,6]]}
[]
[null,"Standard Incentives for Pacific Power Customers"]
[null,"Existing Buildings | Incentive Application | Form 120P-PAC"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2021.2"}]
[null,null,null,"Reference ID",{"$f":"IF(ReferenceID=\"\",\"\",ReferenceID)","v":""},"PTID",{"$f":"IF(PTID=\"\",\"\",PTID)","v":""}]
[]
[null,"SERVICE SHOPS AND WAREHOUSES"]
[null,"EQUIPMENT","REQUIREMENTS","INCENTIVE PER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null,"Inverter-Driven Welder ",null,700,null,{"$f":"D13*E13","v":0}]
[null,"Forklift Battery Charger ",null,600,null,{"$f":"D14*E14","v":0}]
[]
[]
[]
[null,"Requested incentives are subject to per-site, per-year incentive limits. See Summary page and Terms & Conditions for details"]
[null,"TOTALS FOR SERVICE SHOPS AND WAREHOUSES",null,null,null,"TOTAL REQUESTED \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,{"$f":"SUM(F13:F14)","v":0},{"$f":"SUM(G13:G14)","v":0}]
[]
[null," "]

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

{"sheet":"Lookups","index":11,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Heat"]
[0,"None"]
[1,"Electric"]
[2,"Gas"]
[3,"Other"]
[]
[]
["Building Use Type"]
["(select)"]
["Assembly"]
["Athletic Club"]
["Auto Services"]
["College/University"]
["Data Center"]
["Grocery"]
["Hospital"]
["Laundry / Dry Cleaners"]
["Lodging / Hotel / Motel"]
["Manufacturing"]
["Multifamily / Residential"]
["Office"]
["Other"]
["Parking Structure"]
["Religious / Spiritual"]
["Restaurant"]
["Retail"]
["Retirement Home"]
["Schools K-12"]
["Warehouse",null,null,null,{"$f":"B29&\", \"&C29&\", \"&D29","v":", , "}]
[]
[]
["Electric Utility"]
[0,"(select)"]
[1,"Pacific Power"]
[2,"Other"]
[]
[]
["Gas Utility"]
[0,"(select)"]
[1,"NW Natural"]
[2,"Avista"]
[3,"Other"]
[4,"Other"]
[]
["Fuel Source"]
[0,"(select)"]
[1,"Electric"]
[2,"Gas"]
[3,"Other"]
[]
["Heat Pump"]
["(Select Heat Type)"]
[{"$f":"IF(HEAT_NUM=1,\"Heat Pump\",IF(HEAT_NUM=2,\"Gas Heat\",\"Other Heat\"))","v":"Other Heat"}]
[{"$f":"IF(HEAT_NUM=1,\"Other Electric Heat\",\"Other Heat\")","v":"Other Heat"}]

{"sheet":"Showerhead-wand Lookup","index":12,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Showerhead/Showerwand"]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"},7]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Water Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"}]
["001","No Electric Selection","No Gas Selection","Electric Water Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Water Heating"}]
["002","No Electric Selection","No Gas Selection","Gas Water Heating","No Electric Selection, No Gas Selection, Gas Water Heating"]
["003","No Electric Selection","No Gas Selection","Other Water Heating",{"$f":"B8&\", \"&C8&\", \"&D8","v":"No Electric Selection, No Gas Selection, Other Water Heating"},"Does Not Qualify - Site's water heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Water Heating Selection","No Electric Selection, Qualifying Gas, No Water Heating Selection"]
["011","No Electric Selection","Qualifying Gas","Electric Water Heating","No Electric Selection, Qualifying Gas, Electric Water Heating"]
["012","No Electric Selection","Qualifying Gas","Gas Water Heating","No Electric Selection, Qualifying Gas, Gas Water Heating"]
["013","No Electric Selection","Qualifying Gas","Other Water Heating","No Electric Selection, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Water Heating Selection","No Electric Selection, Other Gas, No Water Heating Selection"]
["021","No Electric Selection","Other Gas","Electric Water Heating","No Electric Selection, Other Gas, Electric Water Heating"]
["022","No Electric Selection","Other Gas","Gas Water Heating","No Electric Selection, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Water Heating","No Electric Selection, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Water Heating Selection","Qualifying Electric, No Gas Selection, No Water Heating Selection"]
["101","Qualifying Electric","No Gas Selection","Electric Water Heating","Qualifying Electric, No Gas Selection, Electric Water Heating",7]
["102","Qualifying Electric","No Gas Selection","Gas Water Heating","Qualifying Electric, No Gas Selection, Gas Water Heating"]
["103","Qualifying Electric","No Gas Selection","Other Water Heating","Qualifying Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Qualifying Electric, Qualifying Gas, No Water Heating Selection"]
["111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Qualifying Electric, Qualifying Gas, Electric Water Heating",7]
["112","Qualifying Electric","Qualifying Gas","Gas Water Heating","Qualifying Electric, Qualifying Gas, Gas Water Heating",7]
["113","Qualifying Electric","Qualifying Gas","Other Water Heating","Qualifying Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Water Heating Selection","Qualifying Electric, Other Gas, No Water Heating Selection"]
["121","Qualifying Electric","Other Gas","Electric Water Heating","Qualifying Electric, Other Gas, Electric Water Heating",7]
["122","Qualifying Electric","Other Gas","Gas Water Heating","Qualifying Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Water Heating","Qualifying Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Water Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Water Heating Selection"}]
["201","Other Electric","No Gas Selection","Electric Water Heating","Other Electric, No Gas Selection, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Water Heating","Other Electric, No Gas Selection, Gas Water Heating"]
["203","Other Electric","No Gas Selection","Other Water Heating","Other Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Water Heating Selection","Other Electric, Qualifying Gas, No Water Heating Selection"]
["211","Other Electric","Qualifying Gas","Electric Water Heating","Other Electric, Qualifying Gas, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Water Heating","Other Electric, Qualifying Gas, Gas Water Heating",7]
["213","Other Electric","Qualifying Gas","Other Water Heating","Other Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Water Heating Selection","Other Electric, Other Gas, No Water Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Water Heating","Other Electric, Other Gas, Electric Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Water Heating","Other Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Water Heating","Other Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Bathroom Aerator Lookup","index":13,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Bathroom Faucet Aerator"]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":0}]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Water Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"}]
["001","No Electric Selection","No Gas Selection","Electric Water Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Water Heating"}]
["002","No Electric Selection","No Gas Selection","Gas Water Heating","No Electric Selection, No Gas Selection, Gas Water Heating"]
["003","No Electric Selection","No Gas Selection","Other Water Heating","No Electric Selection, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Water Heating Selection","No Electric Selection, Qualifying Gas, No Water Heating Selection"]
["011","No Electric Selection","Qualifying Gas","Electric Water Heating","No Electric Selection, Qualifying Gas, Electric Water Heating"]
["012","No Electric Selection","Qualifying Gas","Gas Water Heating","No Electric Selection, Qualifying Gas, Gas Water Heating"]
["013","No Electric Selection","Qualifying Gas","Other Water Heating","No Electric Selection, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Water Heating Selection","No Electric Selection, Other Gas, No Water Heating Selection"]
["021","No Electric Selection","Other Gas","Electric Water Heating","No Electric Selection, Other Gas, Electric Water Heating"]
["022","No Electric Selection","Other Gas","Gas Water Heating","No Electric Selection, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Water Heating","No Electric Selection, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Water Heating Selection","Qualifying Electric, No Gas Selection, No Water Heating Selection"]
["101","Qualifying Electric","No Gas Selection","Electric Water Heating","Qualifying Electric, No Gas Selection, Electric Water Heating",3]
["102","Qualifying Electric","No Gas Selection","Gas Water Heating","Qualifying Electric, No Gas Selection, Gas Water Heating"]
["103","Qualifying Electric","No Gas Selection","Other Water Heating","Qualifying Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Qualifying Electric, Qualifying Gas, No Water Heating Selection"]
["111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Qualifying Electric, Qualifying Gas, Electric Water Heating",3]
["112","Qualifying Electric","Qualifying Gas","Gas Water Heating","Qualifying Electric, Qualifying Gas, Gas Water Heating",3]
["113","Qualifying Electric","Qualifying Gas","Other Water Heating","Qualifying Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Water Heating Selection","Qualifying Electric, Other Gas, No Water Heating Selection"]
["121","Qualifying Electric","Other Gas","Electric Water Heating","Qualifying Electric, Other Gas, Electric Water Heating",3]
["122","Qualifying Electric","Other Gas","Gas Water Heating","Qualifying Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Water Heating","Qualifying Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Water Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Water Heating Selection"}]
["201","Other Electric","No Gas Selection","Electric Water Heating","Other Electric, No Gas Selection, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Water Heating","Other Electric, No Gas Selection, Gas Water Heating"]
["203","Other Electric","No Gas Selection","Other Water Heating","Other Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Water Heating Selection","Other Electric, Qualifying Gas, No Water Heating Selection"]
["211","Other Electric","Qualifying Gas","Electric Water Heating","Other Electric, Qualifying Gas, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Water Heating","Other Electric, Qualifying Gas, Gas Water Heating",3]
["213","Other Electric","Qualifying Gas","Other Water Heating","Other Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Water Heating Selection","Other Electric, Other Gas, No Water Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Water Heating","Other Electric, Other Gas, Electric Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Water Heating","Other Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Water Heating","Other Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Kitchen Aerator Lookup","index":14,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Kitchen Faucet Aerator"]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":0}]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Water Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"}]
["001","No Electric Selection","No Gas Selection","Electric Water Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Water Heating"}]
["002","No Electric Selection","No Gas Selection","Gas Water Heating","No Electric Selection, No Gas Selection, Gas Water Heating"]
["003","No Electric Selection","No Gas Selection","Other Water Heating","No Electric Selection, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Water Heating Selection","No Electric Selection, Qualifying Gas, No Water Heating Selection"]
["011","No Electric Selection","Qualifying Gas","Electric Water Heating","No Electric Selection, Qualifying Gas, Electric Water Heating"]
["012","No Electric Selection","Qualifying Gas","Gas Water Heating","No Electric Selection, Qualifying Gas, Gas Water Heating"]
["013","No Electric Selection","Qualifying Gas","Other Water Heating","No Electric Selection, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Water Heating Selection","No Electric Selection, Other Gas, No Water Heating Selection"]
["021","No Electric Selection","Other Gas","Electric Water Heating","No Electric Selection, Other Gas, Electric Water Heating"]
["022","No Electric Selection","Other Gas","Gas Water Heating","No Electric Selection, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Water Heating","No Electric Selection, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Water Heating Selection","Qualifying Electric, No Gas Selection, No Water Heating Selection"]
["101","Qualifying Electric","No Gas Selection","Electric Water Heating","Qualifying Electric, No Gas Selection, Electric Water Heating",5]
["102","Qualifying Electric","No Gas Selection","Gas Water Heating","Qualifying Electric, No Gas Selection, Gas Water Heating"]
["103","Qualifying Electric","No Gas Selection","Other Water Heating","Qualifying Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Qualifying Electric, Qualifying Gas, No Water Heating Selection"]
["111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Qualifying Electric, Qualifying Gas, Electric Water Heating",5]
["112","Qualifying Electric","Qualifying Gas","Gas Water Heating","Qualifying Electric, Qualifying Gas, Gas Water Heating",5]
["113","Qualifying Electric","Qualifying Gas","Other Water Heating","Qualifying Electric, Qualifying Gas, Other Water Heating",5]
["120","Qualifying Electric","Other Gas","No Water Heating Selection","Qualifying Electric, Other Gas, No Water Heating Selection"]
["121","Qualifying Electric","Other Gas","Electric Water Heating","Qualifying Electric, Other Gas, Electric Water Heating",5]
["122","Qualifying Electric","Other Gas","Gas Water Heating","Qualifying Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Water Heating","Qualifying Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Water Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Water Heating Selection"}]
["201","Other Electric","No Gas Selection","Electric Water Heating","Other Electric, No Gas Selection, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Water Heating","Other Electric, No Gas Selection, Gas Water Heating"]
["203","Other Electric","No Gas Selection","Other Water Heating","Other Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Water Heating Selection","Other Electric, Qualifying Gas, No Water Heating Selection"]
["211","Other Electric","Qualifying Gas","Electric Water Heating","Other Electric, Qualifying Gas, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Water Heating","Other Electric, Qualifying Gas, Gas Water Heating",5]
["213","Other Electric","Qualifying Gas","Other Water Heating","Other Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Water Heating Selection","Other Electric, Other Gas, No Water Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Water Heating","Other Electric, Other Gas, Electric Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Water Heating","Other Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Water Heating","Other Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Laundry Lookup","index":15,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Commercial Laundry Washer"]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":0}]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Water Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"}]
["001","No Electric Selection","No Gas Selection","Electric Water Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Water Heating"}]
["002","No Electric Selection","No Gas Selection","Gas Water Heating","No Electric Selection, No Gas Selection, Gas Water Heating"]
["003","No Electric Selection","No Gas Selection","Other Water Heating","No Electric Selection, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Water Heating Selection","No Electric Selection, Qualifying Gas, No Water Heating Selection"]
["011","No Electric Selection","Qualifying Gas","Electric Water Heating","No Electric Selection, Qualifying Gas, Electric Water Heating"]
["012","No Electric Selection","Qualifying Gas","Gas Water Heating","No Electric Selection, Qualifying Gas, Gas Water Heating"]
["013","No Electric Selection","Qualifying Gas","Other Water Heating","No Electric Selection, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Water Heating Selection","No Electric Selection, Other Gas, No Water Heating Selection"]
["021","No Electric Selection","Other Gas","Electric Water Heating","No Electric Selection, Other Gas, Electric Water Heating"]
["022","No Electric Selection","Other Gas","Gas Water Heating","No Electric Selection, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Water Heating","No Electric Selection, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Water Heating Selection","Qualifying Electric, No Gas Selection, No Water Heating Selection"]
["101","Qualifying Electric","No Gas Selection","Electric Water Heating","Qualifying Electric, No Gas Selection, Electric Water Heating","$200 each"]
["102","Qualifying Electric","No Gas Selection","Gas Water Heating","Qualifying Electric, No Gas Selection, Gas Water Heating"]
["103","Qualifying Electric","No Gas Selection","Other Water Heating","Qualifying Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Qualifying Electric, Qualifying Gas, No Water Heating Selection"]
["111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Qualifying Electric, Qualifying Gas, Electric Water Heating","$200 each"]
["112","Qualifying Electric","Qualifying Gas","Gas Water Heating","Qualifying Electric, Qualifying Gas, Gas Water Heating","$200 each"]
["113","Qualifying Electric","Qualifying Gas","Other Water Heating","Qualifying Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Water Heating Selection","Qualifying Electric, Other Gas, No Water Heating Selection"]
["121","Qualifying Electric","Other Gas","Electric Water Heating","Qualifying Electric, Other Gas, Electric Water Heating","$200 each"]
["122","Qualifying Electric","Other Gas","Gas Water Heating","Qualifying Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Water Heating","Qualifying Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Water Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Water Heating Selection"}]
["201","Other Electric","No Gas Selection","Electric Water Heating","Other Electric, No Gas Selection, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Water Heating","Other Electric, No Gas Selection, Gas Water Heating"]
["203","Other Electric","No Gas Selection","Other Water Heating","Other Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Water Heating Selection","Other Electric, Qualifying Gas, No Water Heating Selection"]
["211","Other Electric","Qualifying Gas","Electric Water Heating","Other Electric, Qualifying Gas, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Water Heating","Other Electric, Qualifying Gas, Gas Water Heating","$65 each"]
["213","Other Electric","Qualifying Gas","Other Water Heating","Other Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Water Heating Selection","Other Electric, Other Gas, No Water Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Water Heating","Other Electric, Other Gas, Electric Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Water Heating","Other Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Water Heating","Other Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Vent Hood Lookup","index":16,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Commercial Vent Hood with VFD"]
["Combined","Electric Utility","Gas Utility","Primary Space Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"HEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selection"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":"Select site's Utility Providers and Primary Space Heating Fuel, on 'Form 120P'"}]
["Combined","Electric Utility","Gas Utility","Primary Space Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Primary Space Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selection"},"Select site's Utility Providers and Primary Space Heating Fuel, on 'Form 120P'"]
["001","No Electric Selection","No Gas Selection","Electric Primary Space Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Primary Space Heating"},"Select site's Electric Utility Provider, on 'Form 120P'"]
["002","No Electric Selection","No Gas Selection","Gas Primary Space Heating","No Electric Selection, No Gas Selection, Gas Primary Space Heating","Select site's Utility Providers, on 'Form 120P'"]
["003","No Electric Selection","No Gas Selection","Other Primary Space Heating","No Electric Selection, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Primary Space Heating Selection","No Electric Selection, Qualifying Gas, No Primary Space Heating Selection","Select site's Electric Utility Provider and Primary Space Heating Fuel, on 'Form 120P'"]
["011","No Electric Selection","Qualifying Gas","Electric Primary Space Heating","No Electric Selection, Qualifying Gas, Electric Primary Space Heating","Select site's Electric Utility Provider, on 'Form 120P'"]
["012","No Electric Selection","Qualifying Gas","Gas Primary Space Heating","No Electric Selection, Qualifying Gas, Gas Primary Space Heating","Select site's Electric Utility provider, on 'Form 120P'"]
["013","No Electric Selection","Qualifying Gas","Other Primary Space Heating","No Electric Selection, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Primary Space Heating Selection","No Electric Selection, Other Gas, No Primary Space Heating Selection","Select site's Electric Utility Provider and Primary Space Heating Fuel, on 'Form 120P'"]
["021","No Electric Selection","Other Gas","Electric Primary Space Heating","No Electric Selection, Other Gas, Electric Primary Space Heating","Select site's Electric Utility Provider, on 'Form 120P'"]
["022","No Electric Selection","Other Gas","Gas Primary Space Heating","No Electric Selection, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Primary Space Heating","No Electric Selection, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Primary Space Heating Selection","Qualifying Electric, No Gas Selection, No Primary Space Heating Selection","Select site's Gas Utility Provider and Primary Space Heating Fuel, on 'Form 120P'"]
["101","Qualifying Electric","No Gas Selection","Electric Primary Space Heating","Qualifying Electric, No Gas Selection, Electric Primary Space Heating",750]
["102","Qualifying Electric","No Gas Selection","Gas Primary Space Heating","Qualifying Electric, No Gas Selection, Gas Primary Space Heating","Select site's Gas Utility Provider, on 'Form 120P'"]
["103","Qualifying Electric","No Gas Selection","Other Primary Space Heating","Qualifying Electric, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Primary Space Heating Selection","Qualifying Electric, Qualifying Gas, No Primary Space Heating Selection","Select site's Primary Space Heating Fuel, on 'Form 120P'"]
["111","Qualifying Electric","Qualifying Gas","Electric Primary Space Heating","Qualifying Electric, Qualifying Gas, Electric Primary Space Heating",750]
["112","Qualifying Electric","Qualifying Gas","Gas Primary Space Heating","Qualifying Electric, Qualifying Gas, Gas Primary Space Heating",750]
["113","Qualifying Electric","Qualifying Gas","Other Primary Space Heating","Qualifying Electric, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Primary Space Heating Selection","Qualifying Electric, Other Gas, No Primary Space Heating Selection","Select site's Primary Space Heating Fuel, on 'Form 120P'"]
["121","Qualifying Electric","Other Gas","Electric Primary Space Heating","Qualifying Electric, Other Gas, Electric Primary Space Heating",750]
["122","Qualifying Electric","Other Gas","Gas Primary Space Heating","Qualifying Electric, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Primary Space Heating","Qualifying Electric, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Primary Space Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Primary Space Heating Selection"},"Does Not Qualify - Site does not receive electricty from a participating utility"]
["201","Other Electric","No Gas Selection","Electric Primary Space Heating","Other Electric, No Gas Selection, Electric Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["202","Other Electric","No Gas Selection","Gas Primary Space Heating","Other Electric, No Gas Selection, Gas Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["203","Other Electric","No Gas Selection","Other Primary Space Heating","Other Electric, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["210","Other Electric","Qualifying Gas","No Primary Space Heating Selection","Other Electric, Qualifying Gas, No Primary Space Heating Selection","Does Not Qualify - Site does not receive electricty from a participating utility"]
["211","Other Electric","Qualifying Gas","Electric Primary Space Heating","Other Electric, Qualifying Gas, Electric Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Primary Space Heating","Other Electric, Qualifying Gas, Gas Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["213","Other Electric","Qualifying Gas","Other Primary Space Heating","Other Electric, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site does not receive electricty from a participating utility"]
["220","Other Electric","Other Gas","No Primary Space Heating Selection","Other Electric, Other Gas, No Primary Space Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Primary Space Heating","Other Electric, Other Gas, Electric Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Primary Space Heating","Other Electric, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Primary Space Heating","Other Electric, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Dish Under Counter Lookup","index":17,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Dishwasher Under Counter"]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3,E3)","v":{"$error":"#NAME?"}},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"TEMPERATURE","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,6)","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,7)","v":{"$error":"#NAME?"}}]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
["0001","No Electric Selection","No Gas Selection","No Water Heating Selection","Low Temp",{"$f":"B5&\", \"&C5&\", \"&D5&\", \"&E5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, Low Temp"}]
["0002","No Electric Selection","No Gas Selection","No Water Heating Selection","High Temp","No Electric Selection, No Gas Selection, No Water Heating Selection, High Temp"]
["0011","No Electric Selection","No Gas Selection","Electric Water Heating","Low Temp","No Electric Selection, No Gas Selection, Electric Water Heating, Low Temp"]
["0012","No Electric Selection","No Gas Selection","Electric Water Heating","High Temp","No Electric Selection, No Gas Selection, Electric Water Heating, High Temp"]
["0021","No Electric Selection","No Gas Selection","Gas Water Heating","Low Temp","No Electric Selection, No Gas Selection, Gas Water Heating, Low Temp"]
["0022","No Electric Selection","No Gas Selection","Gas Water Heating","High Temp","No Electric Selection, No Gas Selection, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["0031","No Electric Selection","No Gas Selection","Other Water Heating","Low Temp","No Electric Selection, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0032","No Electric Selection","No Gas Selection","Other Water Heating","High Temp","No Electric Selection, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0101","No Electric Selection","Qualifying Gas","No Water Heating Selection","Low Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, Low Temp"]
["0102","No Electric Selection","Qualifying Gas","No Water Heating Selection","High Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, High Temp"]
["0111","No Electric Selection","Qualifying Gas","Electric Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, Low Temp"]
["0112","No Electric Selection","Qualifying Gas","Electric Water Heating","High Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, High Temp"]
["0121","No Electric Selection","Qualifying Gas","Gas Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, Low Temp"]
["0122","No Electric Selection","Qualifying Gas","Gas Water Heating","High Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["0131","No Electric Selection","Qualifying Gas","Other Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0132","No Electric Selection","Qualifying Gas","Other Water Heating","High Temp","No Electric Selection, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0201","No Electric Selection","Other Gas","No Water Heating Selection","Low Temp","No Electric Selection, Other Gas, No Water Heating Selection, Low Temp"]
["0202","No Electric Selection","Other Gas","No Water Heating Selection","High Temp","No Electric Selection, Other Gas, No Water Heating Selection, High Temp"]
["0211","No Electric Selection","Other Gas","Electric Water Heating","Low Temp","No Electric Selection, Other Gas, Electric Water Heating, Low Temp"]
["0212","No Electric Selection","Other Gas","Electric Water Heating","High Temp","No Electric Selection, Other Gas, Electric Water Heating, High Temp"]
["0221","No Electric Selection","Other Gas","Gas Water Heating","Low Temp","No Electric Selection, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0222","No Electric Selection","Other Gas","Gas Water Heating","High Temp","No Electric Selection, Other Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["0231","No Electric Selection","Other Gas","Other Water Heating","Low Temp","No Electric Selection, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0232","No Electric Selection","Other Gas","Other Water Heating","High Temp","No Electric Selection, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1001","Qualifying Electric","No Gas Selection","No Water Heating Selection","Low Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["1002","Qualifying Electric","No Gas Selection","No Water Heating Selection","High Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["1011","Qualifying Electric","No Gas Selection","Electric Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, Low Temp",195]
["1012","Qualifying Electric","No Gas Selection","Electric Water Heating","High Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, High Temp",600]
["1021","Qualifying Electric","No Gas Selection","Gas Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["1022","Qualifying Electric","No Gas Selection","Gas Water Heating","High Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["1031","Qualifying Electric","No Gas Selection","Other Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1032","Qualifying Electric","No Gas Selection","Other Water Heating","High Temp","Qualifying Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1101","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["1102","Qualifying Electric","Qualifying Gas","No Water Heating Selection","High Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["1111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, Low Temp",195]
["1112","Qualifying Electric","Qualifying Gas","Electric Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, High Temp",600]
["1121","Qualifying Electric","Qualifying Gas","Gas Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, Low Temp",195]
["1122","Qualifying Electric","Qualifying Gas","Gas Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["1131","Qualifying Electric","Qualifying Gas","Other Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1132","Qualifying Electric","Qualifying Gas","Other Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1201","Qualifying Electric","Other Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Other Gas, No Water Heating Selection, Low Temp"]
["1202","Qualifying Electric","Other Gas","No Water Heating Selection","High Temp","Qualifying Electric, Other Gas, No Water Heating Selection, High Temp"]
["1211","Qualifying Electric","Other Gas","Electric Water Heating","Low Temp","Qualifying Electric, Other Gas, Electric Water Heating, Low Temp",195]
["1212","Qualifying Electric","Other Gas","Electric Water Heating","High Temp","Qualifying Electric, Other Gas, Electric Water Heating, High Temp",600]
["1221","Qualifying Electric","Other Gas","Gas Water Heating","Low Temp","Qualifying Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1222","Qualifying Electric","Other Gas","Gas Water Heating","High Temp","Qualifying Electric, Other Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["1231","Qualifying Electric","Other Gas","Other Water Heating","Low Temp","Qualifying Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1232","Qualifying Electric","Other Gas","Other Water Heating","High Temp","Qualifying Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2001","Other Electric","No Gas Selection","No Water Heating Selection","Low Temp","Other Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["2002","Other Electric","No Gas Selection","No Water Heating Selection","High Temp","Other Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["2011","Other Electric","No Gas Selection","Electric Water Heating","Low Temp","Other Electric, No Gas Selection, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2012","Other Electric","No Gas Selection","Electric Water Heating","High Temp","Other Electric, No Gas Selection, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2021","Other Electric","No Gas Selection","Gas Water Heating","Low Temp","Other Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["2022","Other Electric","No Gas Selection","Gas Water Heating","High Temp","Other Electric, No Gas Selection, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["2031","Other Electric","No Gas Selection","Other Water Heating","Low Temp","Other Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2032","Other Electric","No Gas Selection","Other Water Heating","High Temp","Other Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2101","Other Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Other Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["2102","Other Electric","Qualifying Gas","No Water Heating Selection","High Temp","Other Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["2111","Other Electric","Qualifying Gas","Electric Water Heating","Low Temp","Other Electric, Qualifying Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2112","Other Electric","Qualifying Gas","Electric Water Heating","High Temp","Other Electric, Qualifying Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2121","Other Electric","Qualifying Gas","Gas Water Heating","Low Temp","Other Electric, Qualifying Gas, Gas Water Heating, Low Temp",195]
["2122","Other Electric","Qualifying Gas","Gas Water Heating","High Temp","Other Electric, Qualifying Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["2131","Other Electric","Qualifying Gas","Other Water Heating","Low Temp","Other Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2132","Other Electric","Qualifying Gas","Other Water Heating","High Temp","Other Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2201","Other Electric","Other Gas","No Water Heating Selection","Low Temp",{"$f":"B69&\", \"&C69&\", \"&D69&\", \"&E69","v":"Other Electric, Other Gas, No Water Heating Selection, Low Temp"},"Does Not Qualify - Site's utility providers are not participating utilities"]
["2202","Other Electric","Other Gas","No Water Heating Selection","High Temp","Other Electric, Other Gas, No Water Heating Selection, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2211","Other Electric","Other Gas","Electric Water Heating","Low Temp","Other Electric, Other Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2212","Other Electric","Other Gas","Electric Water Heating","High Temp","Other Electric, Other Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2221","Other Electric","Other Gas","Gas Water Heating","Low Temp","Other Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2222","Other Electric","Other Gas","Gas Water Heating","High Temp","Other Electric, Other Gas, Gas Water Heating, High Temp","High Temp with gas water heating does not qualify"]
["2231","Other Electric","Other Gas","Other Water Heating","Low Temp","Other Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2232","Other Electric","Other Gas","Other Water Heating","High Temp","Other Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Dish Single Upright Lookup","index":18,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Dishwasher, Single Tank Door/Upright"]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3,E3)","v":{"$error":"#NAME?"}},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"TEMPERATURE","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,6)","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,7)","v":{"$error":"#NAME?"}}]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
["0001","No Electric Selection","No Gas Selection","No Water Heating Selection","Low Temp",{"$f":"B5&\", \"&C5&\", \"&D5&\", \"&E5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, Low Temp"}]
["0002","No Electric Selection","No Gas Selection","No Water Heating Selection","High Temp",{"$f":"B6&\", \"&C6&\", \"&D6&\", \"&E6","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, High Temp"}]
["0011","No Electric Selection","No Gas Selection","Electric Water Heating","Low Temp","No Electric Selection, No Gas Selection, Electric Water Heating, Low Temp"]
["0012","No Electric Selection","No Gas Selection","Electric Water Heating","High Temp","No Electric Selection, No Gas Selection, Electric Water Heating, High Temp"]
["0021","No Electric Selection","No Gas Selection","Gas Water Heating","Low Temp","No Electric Selection, No Gas Selection, Gas Water Heating, Low Temp"]
["0022","No Electric Selection","No Gas Selection","Gas Water Heating","High Temp","No Electric Selection, No Gas Selection, Gas Water Heating, High Temp"]
["0031","No Electric Selection","No Gas Selection","Other Water Heating","Low Temp","No Electric Selection, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0032","No Electric Selection","No Gas Selection","Other Water Heating","High Temp","No Electric Selection, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0101","No Electric Selection","Qualifying Gas","No Water Heating Selection","Low Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, Low Temp"]
["0102","No Electric Selection","Qualifying Gas","No Water Heating Selection","High Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, High Temp"]
["0111","No Electric Selection","Qualifying Gas","Electric Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, Low Temp"]
["0112","No Electric Selection","Qualifying Gas","Electric Water Heating","High Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, High Temp"]
["0121","No Electric Selection","Qualifying Gas","Gas Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, Low Temp"]
["0122","No Electric Selection","Qualifying Gas","Gas Water Heating","High Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, High Temp"]
["0131","No Electric Selection","Qualifying Gas","Other Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0132","No Electric Selection","Qualifying Gas","Other Water Heating","High Temp","No Electric Selection, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0201","No Electric Selection","Other Gas","No Water Heating Selection","Low Temp","No Electric Selection, Other Gas, No Water Heating Selection, Low Temp"]
["0202","No Electric Selection","Other Gas","No Water Heating Selection","High Temp","No Electric Selection, Other Gas, No Water Heating Selection, High Temp"]
["0211","No Electric Selection","Other Gas","Electric Water Heating","Low Temp","No Electric Selection, Other Gas, Electric Water Heating, Low Temp"]
["0212","No Electric Selection","Other Gas","Electric Water Heating","High Temp","No Electric Selection, Other Gas, Electric Water Heating, High Temp"]
["0221","No Electric Selection","Other Gas","Gas Water Heating","Low Temp","No Electric Selection, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0222","No Electric Selection","Other Gas","Gas Water Heating","High Temp","No Electric Selection, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0231","No Electric Selection","Other Gas","Other Water Heating","Low Temp","No Electric Selection, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0232","No Electric Selection","Other Gas","Other Water Heating","High Temp","No Electric Selection, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1001","Qualifying Electric","No Gas Selection","No Water Heating Selection","Low Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["1002","Qualifying Electric","No Gas Selection","No Water Heating Selection","High Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["1011","Qualifying Electric","No Gas Selection","Electric Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, Low Temp",550]
["1012","Qualifying Electric","No Gas Selection","Electric Water Heating","High Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, High Temp",825]
["1021","Qualifying Electric","No Gas Selection","Gas Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["1022","Qualifying Electric","No Gas Selection","Gas Water Heating","High Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, High Temp"]
["1031","Qualifying Electric","No Gas Selection","Other Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1032","Qualifying Electric","No Gas Selection","Other Water Heating","High Temp","Qualifying Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1101","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Low Temp",{"$f":"B37&\", \"&C37&\", \"&D37&\", \"&E37","v":"Qualifying Electric, Qualifying Gas, No Water Heating Selection, Low Temp"}]
["1102","Qualifying Electric","Qualifying Gas","No Water Heating Selection","High Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["1111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, Low Temp",550]
["1112","Qualifying Electric","Qualifying Gas","Electric Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, High Temp",825]
["1121","Qualifying Electric","Qualifying Gas","Gas Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, Low Temp",550]
["1122","Qualifying Electric","Qualifying Gas","Gas Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, High Temp",825]
["1131","Qualifying Electric","Qualifying Gas","Other Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1132","Qualifying Electric","Qualifying Gas","Other Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1201","Qualifying Electric","Other Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Other Gas, No Water Heating Selection, Low Temp"]
["1202","Qualifying Electric","Other Gas","No Water Heating Selection","High Temp","Qualifying Electric, Other Gas, No Water Heating Selection, High Temp"]
["1211","Qualifying Electric","Other Gas","Electric Water Heating","Low Temp","Qualifying Electric, Other Gas, Electric Water Heating, Low Temp",550]
["1212","Qualifying Electric","Other Gas","Electric Water Heating","High Temp","Qualifying Electric, Other Gas, Electric Water Heating, High Temp",825]
["1221","Qualifying Electric","Other Gas","Gas Water Heating","Low Temp","Qualifying Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1222","Qualifying Electric","Other Gas","Gas Water Heating","High Temp","Qualifying Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1231","Qualifying Electric","Other Gas","Other Water Heating","Low Temp","Qualifying Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1232","Qualifying Electric","Other Gas","Other Water Heating","High Temp","Qualifying Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2001","Other Electric","No Gas Selection","No Water Heating Selection","Low Temp","Other Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["2002","Other Electric","No Gas Selection","No Water Heating Selection","High Temp","Other Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["2011","Other Electric","No Gas Selection","Electric Water Heating","Low Temp","Other Electric, No Gas Selection, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2012","Other Electric","No Gas Selection","Electric Water Heating","High Temp","Other Electric, No Gas Selection, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2021","Other Electric","No Gas Selection","Gas Water Heating","Low Temp","Other Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["2022","Other Electric","No Gas Selection","Gas Water Heating","High Temp","Other Electric, No Gas Selection, Gas Water Heating, High Temp"]
["2031","Other Electric","No Gas Selection","Other Water Heating","Low Temp","Other Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2032","Other Electric","No Gas Selection","Other Water Heating","High Temp","Other Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2101","Other Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Other Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["2102","Other Electric","Qualifying Gas","No Water Heating Selection","High Temp","Other Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["2111","Other Electric","Qualifying Gas","Electric Water Heating","Low Temp","Other Electric, Qualifying Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2112","Other Electric","Qualifying Gas","Electric Water Heating","High Temp","Other Electric, Qualifying Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2121","Other Electric","Qualifying Gas","Gas Water Heating","Low Temp","Other Electric, Qualifying Gas, Gas Water Heating, Low Temp",550]
["2122","Other Electric","Qualifying Gas","Gas Water Heating","High Temp","Other Electric, Qualifying Gas, Gas Water Heating, High Temp",825]
["2131","Other Electric","Qualifying Gas","Other Water Heating","Low Temp","Other Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2132","Other Electric","Qualifying Gas","Other Water Heating","High Temp","Other Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2201","Other Electric","Other Gas","No Water Heating Selection","Low Temp",{"$f":"B69&\", \"&C69&\", \"&D69&\", \"&E69","v":"Other Electric, Other Gas, No Water Heating Selection, Low Temp"},"Does Not Qualify - Site's utility providers are not participating utilities"]
["2202","Other Electric","Other Gas","No Water Heating Selection","High Temp","Other Electric, Other Gas, No Water Heating Selection, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2211","Other Electric","Other Gas","Electric Water Heating","Low Temp","Other Electric, Other Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2212","Other Electric","Other Gas","Electric Water Heating","High Temp","Other Electric, Other Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2221","Other Electric","Other Gas","Gas Water Heating","Low Temp","Other Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2222","Other Electric","Other Gas","Gas Water Heating","High Temp","Other Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2231","Other Electric","Other Gas","Other Water Heating","Low Temp","Other Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2232","Other Electric","Other Gas","Other Water Heating","High Temp","Other Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Dish Single Conveyor Lookup","index":19,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Dishwasher, Single Tank Conveyor"]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3,E3)","v":{"$error":"#NAME?"}},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"TEMPERATURE","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,6)","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,7)","v":{"$error":"#NAME?"}}]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
["0001","No Electric Selection","No Gas Selection","No Water Heating Selection","Low Temp",{"$f":"B5&\", \"&C5&\", \"&D5&\", \"&E5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, Low Temp"}]
["0002","No Electric Selection","No Gas Selection","No Water Heating Selection","High Temp",{"$f":"B6&\", \"&C6&\", \"&D6&\", \"&E6","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, High Temp"}]
["0011","No Electric Selection","No Gas Selection","Electric Water Heating","Low Temp",{"$f":"B7&\", \"&C7&\", \"&D7&\", \"&E7","v":"No Electric Selection, No Gas Selection, Electric Water Heating, Low Temp"}]
["0012","No Electric Selection","No Gas Selection","Electric Water Heating","High Temp","No Electric Selection, No Gas Selection, Electric Water Heating, High Temp"]
["0021","No Electric Selection","No Gas Selection","Gas Water Heating","Low Temp","No Electric Selection, No Gas Selection, Gas Water Heating, Low Temp"]
["0022","No Electric Selection","No Gas Selection","Gas Water Heating","High Temp","No Electric Selection, No Gas Selection, Gas Water Heating, High Temp"]
["0031","No Electric Selection","No Gas Selection","Other Water Heating","Low Temp","No Electric Selection, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0032","No Electric Selection","No Gas Selection","Other Water Heating","High Temp","No Electric Selection, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0101","No Electric Selection","Qualifying Gas","No Water Heating Selection","Low Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, Low Temp"]
["0102","No Electric Selection","Qualifying Gas","No Water Heating Selection","High Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, High Temp"]
["0111","No Electric Selection","Qualifying Gas","Electric Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, Low Temp"]
["0112","No Electric Selection","Qualifying Gas","Electric Water Heating","High Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, High Temp"]
["0121","No Electric Selection","Qualifying Gas","Gas Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, Low Temp"]
["0122","No Electric Selection","Qualifying Gas","Gas Water Heating","High Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, High Temp"]
["0131","No Electric Selection","Qualifying Gas","Other Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0132","No Electric Selection","Qualifying Gas","Other Water Heating","High Temp","No Electric Selection, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0201","No Electric Selection","Other Gas","No Water Heating Selection","Low Temp","No Electric Selection, Other Gas, No Water Heating Selection, Low Temp"]
["0202","No Electric Selection","Other Gas","No Water Heating Selection","High Temp","No Electric Selection, Other Gas, No Water Heating Selection, High Temp"]
["0211","No Electric Selection","Other Gas","Electric Water Heating","Low Temp","No Electric Selection, Other Gas, Electric Water Heating, Low Temp"]
["0212","No Electric Selection","Other Gas","Electric Water Heating","High Temp","No Electric Selection, Other Gas, Electric Water Heating, High Temp"]
["0221","No Electric Selection","Other Gas","Gas Water Heating","Low Temp","No Electric Selection, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0222","No Electric Selection","Other Gas","Gas Water Heating","High Temp","No Electric Selection, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0231","No Electric Selection","Other Gas","Other Water Heating","Low Temp","No Electric Selection, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0232","No Electric Selection","Other Gas","Other Water Heating","High Temp","No Electric Selection, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1001","Qualifying Electric","No Gas Selection","No Water Heating Selection","Low Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["1002","Qualifying Electric","No Gas Selection","No Water Heating Selection","High Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["1011","Qualifying Electric","No Gas Selection","Electric Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, Low Temp",900]
["1012","Qualifying Electric","No Gas Selection","Electric Water Heating","High Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, High Temp",900]
["1021","Qualifying Electric","No Gas Selection","Gas Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["1022","Qualifying Electric","No Gas Selection","Gas Water Heating","High Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, High Temp"]
["1031","Qualifying Electric","No Gas Selection","Other Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1032","Qualifying Electric","No Gas Selection","Other Water Heating","High Temp","Qualifying Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1101","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["1102","Qualifying Electric","Qualifying Gas","No Water Heating Selection","High Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["1111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, Low Temp",900]
["1112","Qualifying Electric","Qualifying Gas","Electric Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, High Temp",900]
["1121","Qualifying Electric","Qualifying Gas","Gas Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, Low Temp",900]
["1122","Qualifying Electric","Qualifying Gas","Gas Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, High Temp",900]
["1131","Qualifying Electric","Qualifying Gas","Other Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1132","Qualifying Electric","Qualifying Gas","Other Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1201","Qualifying Electric","Other Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Other Gas, No Water Heating Selection, Low Temp"]
["1202","Qualifying Electric","Other Gas","No Water Heating Selection","High Temp","Qualifying Electric, Other Gas, No Water Heating Selection, High Temp"]
["1211","Qualifying Electric","Other Gas","Electric Water Heating","Low Temp","Qualifying Electric, Other Gas, Electric Water Heating, Low Temp",900]
["1212","Qualifying Electric","Other Gas","Electric Water Heating","High Temp","Qualifying Electric, Other Gas, Electric Water Heating, High Temp",900]
["1221","Qualifying Electric","Other Gas","Gas Water Heating","Low Temp","Qualifying Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1222","Qualifying Electric","Other Gas","Gas Water Heating","High Temp","Qualifying Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1231","Qualifying Electric","Other Gas","Other Water Heating","Low Temp","Qualifying Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1232","Qualifying Electric","Other Gas","Other Water Heating","High Temp","Qualifying Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2001","Other Electric","No Gas Selection","No Water Heating Selection","Low Temp","Other Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["2002","Other Electric","No Gas Selection","No Water Heating Selection","High Temp","Other Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["2011","Other Electric","No Gas Selection","Electric Water Heating","Low Temp","Other Electric, No Gas Selection, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2012","Other Electric","No Gas Selection","Electric Water Heating","High Temp","Other Electric, No Gas Selection, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2021","Other Electric","No Gas Selection","Gas Water Heating","Low Temp","Other Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["2022","Other Electric","No Gas Selection","Gas Water Heating","High Temp","Other Electric, No Gas Selection, Gas Water Heating, High Temp"]
["2031","Other Electric","No Gas Selection","Other Water Heating","Low Temp","Other Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2032","Other Electric","No Gas Selection","Other Water Heating","High Temp","Other Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2101","Other Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Other Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["2102","Other Electric","Qualifying Gas","No Water Heating Selection","High Temp","Other Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["2111","Other Electric","Qualifying Gas","Electric Water Heating","Low Temp","Other Electric, Qualifying Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2112","Other Electric","Qualifying Gas","Electric Water Heating","High Temp","Other Electric, Qualifying Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2121","Other Electric","Qualifying Gas","Gas Water Heating","Low Temp","Other Electric, Qualifying Gas, Gas Water Heating, Low Temp",900]
["2122","Other Electric","Qualifying Gas","Gas Water Heating","High Temp","Other Electric, Qualifying Gas, Gas Water Heating, High Temp",900]
["2131","Other Electric","Qualifying Gas","Other Water Heating","Low Temp","Other Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2132","Other Electric","Qualifying Gas","Other Water Heating","High Temp","Other Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2201","Other Electric","Other Gas","No Water Heating Selection","Low Temp","Other Electric, Other Gas, No Water Heating Selection, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2202","Other Electric","Other Gas","No Water Heating Selection","High Temp","Other Electric, Other Gas, No Water Heating Selection, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2211","Other Electric","Other Gas","Electric Water Heating","Low Temp",{"$f":"B71&\", \"&C71&\", \"&D71&\", \"&E71","v":"Other Electric, Other Gas, Electric Water Heating, Low Temp"},"Does Not Qualify - Site's utility providers are not participating utilities"]
["2212","Other Electric","Other Gas","Electric Water Heating","High Temp","Other Electric, Other Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2221","Other Electric","Other Gas","Gas Water Heating","Low Temp","Other Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2222","Other Electric","Other Gas","Gas Water Heating","High Temp","Other Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2231","Other Electric","Other Gas","Other Water Heating","Low Temp","Other Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2232","Other Electric","Other Gas","Other Water Heating","High Temp","Other Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Dish Multi Conveyor Lookup","index":20,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Dishwasher, Multi-Tank Conveyor"]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3,E3)","v":{"$error":"#NAME?"}},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"TEMPERATURE","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,6)","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(A3,A5:G76,7)","v":{"$error":"#NAME?"}}]
["Combined","Electric Utility","Gas Utility","Water Heating","Temp","Combined","Incentive"]
["0001","No Electric Selection","No Gas Selection","No Water Heating Selection","Low Temp",{"$f":"B5&\", \"&C5&\", \"&D5&\", \"&E5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, Low Temp"}]
["0002","No Electric Selection","No Gas Selection","No Water Heating Selection","High Temp",{"$f":"B6&\", \"&C6&\", \"&D6&\", \"&E6","v":"No Electric Selection, No Gas Selection, No Water Heating Selection, High Temp"}]
["0011","No Electric Selection","No Gas Selection","Electric Water Heating","Low Temp",{"$f":"B7&\", \"&C7&\", \"&D7&\", \"&E7","v":"No Electric Selection, No Gas Selection, Electric Water Heating, Low Temp"}]
["0012","No Electric Selection","No Gas Selection","Electric Water Heating","High Temp","No Electric Selection, No Gas Selection, Electric Water Heating, High Temp"]
["0021","No Electric Selection","No Gas Selection","Gas Water Heating","Low Temp","No Electric Selection, No Gas Selection, Gas Water Heating, Low Temp"]
["0022","No Electric Selection","No Gas Selection","Gas Water Heating","High Temp","No Electric Selection, No Gas Selection, Gas Water Heating, High Temp"]
["0031","No Electric Selection","No Gas Selection","Other Water Heating","Low Temp","No Electric Selection, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0032","No Electric Selection","No Gas Selection","Other Water Heating","High Temp","No Electric Selection, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0101","No Electric Selection","Qualifying Gas","No Water Heating Selection","Low Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, Low Temp"]
["0102","No Electric Selection","Qualifying Gas","No Water Heating Selection","High Temp","No Electric Selection, Qualifying Gas, No Water Heating Selection, High Temp"]
["0111","No Electric Selection","Qualifying Gas","Electric Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, Low Temp"]
["0112","No Electric Selection","Qualifying Gas","Electric Water Heating","High Temp","No Electric Selection, Qualifying Gas, Electric Water Heating, High Temp"]
["0121","No Electric Selection","Qualifying Gas","Gas Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, Low Temp"]
["0122","No Electric Selection","Qualifying Gas","Gas Water Heating","High Temp","No Electric Selection, Qualifying Gas, Gas Water Heating, High Temp"]
["0131","No Electric Selection","Qualifying Gas","Other Water Heating","Low Temp","No Electric Selection, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0132","No Electric Selection","Qualifying Gas","Other Water Heating","High Temp","No Electric Selection, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0201","No Electric Selection","Other Gas","No Water Heating Selection","Low Temp","No Electric Selection, Other Gas, No Water Heating Selection, Low Temp"]
["0202","No Electric Selection","Other Gas","No Water Heating Selection","High Temp","No Electric Selection, Other Gas, No Water Heating Selection, High Temp"]
["0211","No Electric Selection","Other Gas","Electric Water Heating","Low Temp","No Electric Selection, Other Gas, Electric Water Heating, Low Temp"]
["0212","No Electric Selection","Other Gas","Electric Water Heating","High Temp","No Electric Selection, Other Gas, Electric Water Heating, High Temp"]
["0221","No Electric Selection","Other Gas","Gas Water Heating","Low Temp","No Electric Selection, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0222","No Electric Selection","Other Gas","Gas Water Heating","High Temp","No Electric Selection, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["0231","No Electric Selection","Other Gas","Other Water Heating","Low Temp","No Electric Selection, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["0232","No Electric Selection","Other Gas","Other Water Heating","High Temp","No Electric Selection, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1001","Qualifying Electric","No Gas Selection","No Water Heating Selection","Low Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["1002","Qualifying Electric","No Gas Selection","No Water Heating Selection","High Temp","Qualifying Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["1011","Qualifying Electric","No Gas Selection","Electric Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, Low Temp",800]
["1012","Qualifying Electric","No Gas Selection","Electric Water Heating","High Temp","Qualifying Electric, No Gas Selection, Electric Water Heating, High Temp",800]
["1021","Qualifying Electric","No Gas Selection","Gas Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["1022","Qualifying Electric","No Gas Selection","Gas Water Heating","High Temp","Qualifying Electric, No Gas Selection, Gas Water Heating, High Temp"]
["1031","Qualifying Electric","No Gas Selection","Other Water Heating","Low Temp","Qualifying Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1032","Qualifying Electric","No Gas Selection","Other Water Heating","High Temp","Qualifying Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1101","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["1102","Qualifying Electric","Qualifying Gas","No Water Heating Selection","High Temp","Qualifying Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["1111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, Low Temp",800]
["1112","Qualifying Electric","Qualifying Gas","Electric Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Electric Water Heating, High Temp",800]
["1121","Qualifying Electric","Qualifying Gas","Gas Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, Low Temp",800]
["1122","Qualifying Electric","Qualifying Gas","Gas Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Gas Water Heating, High Temp",800]
["1131","Qualifying Electric","Qualifying Gas","Other Water Heating","Low Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1132","Qualifying Electric","Qualifying Gas","Other Water Heating","High Temp","Qualifying Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1201","Qualifying Electric","Other Gas","No Water Heating Selection","Low Temp","Qualifying Electric, Other Gas, No Water Heating Selection, Low Temp"]
["1202","Qualifying Electric","Other Gas","No Water Heating Selection","High Temp","Qualifying Electric, Other Gas, No Water Heating Selection, High Temp"]
["1211","Qualifying Electric","Other Gas","Electric Water Heating","Low Temp","Qualifying Electric, Other Gas, Electric Water Heating, Low Temp",800]
["1212","Qualifying Electric","Other Gas","Electric Water Heating","High Temp","Qualifying Electric, Other Gas, Electric Water Heating, High Temp",800]
["1221","Qualifying Electric","Other Gas","Gas Water Heating","Low Temp","Qualifying Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1222","Qualifying Electric","Other Gas","Gas Water Heating","High Temp","Qualifying Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["1231","Qualifying Electric","Other Gas","Other Water Heating","Low Temp","Qualifying Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["1232","Qualifying Electric","Other Gas","Other Water Heating","High Temp","Qualifying Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2001","Other Electric","No Gas Selection","No Water Heating Selection","Low Temp","Other Electric, No Gas Selection, No Water Heating Selection, Low Temp"]
["2002","Other Electric","No Gas Selection","No Water Heating Selection","High Temp","Other Electric, No Gas Selection, No Water Heating Selection, High Temp"]
["2011","Other Electric","No Gas Selection","Electric Water Heating","Low Temp","Other Electric, No Gas Selection, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2012","Other Electric","No Gas Selection","Electric Water Heating","High Temp","Other Electric, No Gas Selection, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2021","Other Electric","No Gas Selection","Gas Water Heating","Low Temp","Other Electric, No Gas Selection, Gas Water Heating, Low Temp"]
["2022","Other Electric","No Gas Selection","Gas Water Heating","High Temp","Other Electric, No Gas Selection, Gas Water Heating, High Temp"]
["2031","Other Electric","No Gas Selection","Other Water Heating","Low Temp","Other Electric, No Gas Selection, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2032","Other Electric","No Gas Selection","Other Water Heating","High Temp","Other Electric, No Gas Selection, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2101","Other Electric","Qualifying Gas","No Water Heating Selection","Low Temp","Other Electric, Qualifying Gas, No Water Heating Selection, Low Temp"]
["2102","Other Electric","Qualifying Gas","No Water Heating Selection","High Temp","Other Electric, Qualifying Gas, No Water Heating Selection, High Temp"]
["2111","Other Electric","Qualifying Gas","Electric Water Heating","Low Temp","Other Electric, Qualifying Gas, Electric Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2112","Other Electric","Qualifying Gas","Electric Water Heating","High Temp","Other Electric, Qualifying Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["2121","Other Electric","Qualifying Gas","Gas Water Heating","Low Temp","Other Electric, Qualifying Gas, Gas Water Heating, Low Temp",800]
["2122","Other Electric","Qualifying Gas","Gas Water Heating","High Temp","Other Electric, Qualifying Gas, Gas Water Heating, High Temp",800]
["2131","Other Electric","Qualifying Gas","Other Water Heating","Low Temp","Other Electric, Qualifying Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2132","Other Electric","Qualifying Gas","Other Water Heating","High Temp","Other Electric, Qualifying Gas, Other Water Heating, High Temp","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["2201","Other Electric","Other Gas","No Water Heating Selection","Low Temp","Other Electric, Other Gas, No Water Heating Selection, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2202","Other Electric","Other Gas","No Water Heating Selection","High Temp","Other Electric, Other Gas, No Water Heating Selection, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2211","Other Electric","Other Gas","Electric Water Heating","Low Temp",{"$f":"B71&\", \"&C71&\", \"&D71&\", \"&E71","v":"Other Electric, Other Gas, Electric Water Heating, Low Temp"},"Does Not Qualify - Site's utility providers are not participating utilities"]
["2212","Other Electric","Other Gas","Electric Water Heating","High Temp","Other Electric, Other Gas, Electric Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2221","Other Electric","Other Gas","Gas Water Heating","Low Temp","Other Electric, Other Gas, Gas Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2222","Other Electric","Other Gas","Gas Water Heating","High Temp","Other Electric, Other Gas, Gas Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2231","Other Electric","Other Gas","Other Water Heating","Low Temp","Other Electric, Other Gas, Other Water Heating, Low Temp","Does Not Qualify - Site's utility providers are not participating utilities"]
["2232","Other Electric","Other Gas","Other Water Heating","High Temp","Other Electric, Other Gas, Other Water Heating, High Temp","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Dish Pot Pan Lookup","index":21,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Dishwasher, Pot, Pan and Utensil"]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":0}]
["Combined","Electric Utility","Gas Utility","Water Heating","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Water Heating Selection",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Water Heating Selection"}]
["001","No Electric Selection","No Gas Selection","Electric Water Heating",{"$f":"B6&\", \"&C6&\", \"&D6","v":"No Electric Selection, No Gas Selection, Electric Water Heating"}]
["002","No Electric Selection","No Gas Selection","Gas Water Heating","No Electric Selection, No Gas Selection, Gas Water Heating"]
["003","No Electric Selection","No Gas Selection","Other Water Heating","No Electric Selection, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Water Heating Selection","No Electric Selection, Qualifying Gas, No Water Heating Selection"]
["011","No Electric Selection","Qualifying Gas","Electric Water Heating","No Electric Selection, Qualifying Gas, Electric Water Heating"]
["012","No Electric Selection","Qualifying Gas","Gas Water Heating","No Electric Selection, Qualifying Gas, Gas Water Heating"]
["013","No Electric Selection","Qualifying Gas","Other Water Heating","No Electric Selection, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Water Heating Selection","No Electric Selection, Other Gas, No Water Heating Selection"]
["021","No Electric Selection","Other Gas","Electric Water Heating","No Electric Selection, Other Gas, Electric Water Heating"]
["022","No Electric Selection","Other Gas","Gas Water Heating","No Electric Selection, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Water Heating","No Electric Selection, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Water Heating Selection","Qualifying Electric, No Gas Selection, No Water Heating Selection"]
["101","Qualifying Electric","No Gas Selection","Electric Water Heating","Qualifying Electric, No Gas Selection, Electric Water Heating",350]
["102","Qualifying Electric","No Gas Selection","Gas Water Heating","Qualifying Electric, No Gas Selection, Gas Water Heating"]
["103","Qualifying Electric","No Gas Selection","Other Water Heating","Qualifying Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Water Heating Selection","Qualifying Electric, Qualifying Gas, No Water Heating Selection"]
["111","Qualifying Electric","Qualifying Gas","Electric Water Heating","Qualifying Electric, Qualifying Gas, Electric Water Heating",350]
["112","Qualifying Electric","Qualifying Gas","Gas Water Heating","Qualifying Electric, Qualifying Gas, Gas Water Heating",350]
["113","Qualifying Electric","Qualifying Gas","Other Water Heating","Qualifying Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Water Heating Selection","Qualifying Electric, Other Gas, No Water Heating Selection"]
["121","Qualifying Electric","Other Gas","Electric Water Heating","Qualifying Electric, Other Gas, Electric Water Heating",350]
["122","Qualifying Electric","Other Gas","Gas Water Heating","Qualifying Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Water Heating","Qualifying Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Water Heating Selection",{"$f":"B29&\", \"&C29&\", \"&D29","v":"Other Electric, No Gas Selection, No Water Heating Selection"}]
["201","Other Electric","No Gas Selection","Electric Water Heating","Other Electric, No Gas Selection, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Water Heating","Other Electric, No Gas Selection, Gas Water Heating"]
["203","Other Electric","No Gas Selection","Other Water Heating","Other Electric, No Gas Selection, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Water Heating Selection","Other Electric, Qualifying Gas, No Water Heating Selection"]
["211","Other Electric","Qualifying Gas","Electric Water Heating","Other Electric, Qualifying Gas, Electric Water Heating","Does Not Qualify - Site's water heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Water Heating","Other Electric, Qualifying Gas, Gas Water Heating",350]
["213","Other Electric","Qualifying Gas","Other Water Heating","Other Electric, Qualifying Gas, Other Water Heating","Does Not Qualify - Site's water heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Water Heating Selection","Other Electric, Other Gas, No Water Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Water Heating","Other Electric, Other Gas, Electric Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Water Heating","Other Electric, Other Gas, Gas Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Water Heating","Other Electric, Other Gas, Other Water Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Add Doors Lookup","index":22,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Add Doors to Open Refrigerated Cases"]
["Combined","Electric Utility","Gas Utility","Primary Space Heatinging","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3)","v":"000"},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"WATERHEAT_NUM","v":0},{"$f":"VLOOKUP(A3,A5:F40,5)","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selected"},{"$f":"VLOOKUP(A3,A5:F40,6)","v":" "}]
["Combined","Electric Utility","Gas Utility","Primary Space Heatinging","Combined","Incentive"]
["000","No Electric Selection","No Gas Selection","No Primary Space Heating Selected",{"$f":"B5&\", \"&C5&\", \"&D5","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selected"}," "]
["001","No Electric Selection","No Gas Selection","Electric Primary Space Heating","No Electric Selection, No Gas Selection, Electric Primary Space Heating"," "]
["002","No Electric Selection","No Gas Selection","Gas Primary Space Heating","No Electric Selection, No Gas Selection, Gas Primary Space Heating"," "]
["003","No Electric Selection","No Gas Selection","Other Primary Space Heating","No Electric Selection, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["010","No Electric Selection","Qualifying Gas","No Primary Space Heating Selection","No Electric Selection, Qualifying Gas, No Primary Space Heating Selection"," "]
["011","No Electric Selection","Qualifying Gas","Electric Primary Space Heating","No Electric Selection, Qualifying Gas, Electric Primary Space Heating"," "]
["012","No Electric Selection","Qualifying Gas","Gas Primary Space Heating","No Electric Selection, Qualifying Gas, Gas Primary Space Heating"," "]
["013","No Electric Selection","Qualifying Gas","Other Primary Space Heating","No Electric Selection, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["020","No Electric Selection","Other Gas","No Primary Space Heating Selection","No Electric Selection, Other Gas, No Primary Space Heating Selection"," "]
["021","No Electric Selection","Other Gas","Electric Primary Space Heating","No Electric Selection, Other Gas, Electric Primary Space Heating"," "]
["022","No Electric Selection","Other Gas","Gas Primary Space Heating","No Electric Selection, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["023","No Electric Selection","Other Gas","Other Primary Space Heating","No Electric Selection, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["100","Qualifying Electric","No Gas Selection","No Primary Space Heating Selection","Qualifying Electric, No Gas Selection, No Primary Space Heating Selection"," "]
["101","Qualifying Electric","No Gas Selection","Electric Primary Space Heating","Qualifying Electric, No Gas Selection, Electric Primary Space Heating",200]
["102","Qualifying Electric","No Gas Selection","Gas Primary Space Heating","Qualifying Electric, No Gas Selection, Gas Primary Space Heating"," "]
["103","Qualifying Electric","No Gas Selection","Other Primary Space Heating","Qualifying Electric, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["110","Qualifying Electric","Qualifying Gas","No Primary Space Heating Selection","Qualifying Electric, Qualifying Gas, No Primary Space Heating Selection"," "]
["111","Qualifying Electric","Qualifying Gas","Electric Primary Space Heating","Qualifying Electric, Qualifying Gas, Electric Primary Space Heating",200]
["112","Qualifying Electric","Qualifying Gas","Gas Primary Space Heating","Qualifying Electric, Qualifying Gas, Gas Primary Space Heating",200]
["113","Qualifying Electric","Qualifying Gas","Other Primary Space Heating","Qualifying Electric, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["120","Qualifying Electric","Other Gas","No Primary Space Heating Selection","Qualifying Electric, Other Gas, No Primary Space Heating Selection"," "]
["121","Qualifying Electric","Other Gas","Electric Primary Space Heating","Qualifying Electric, Other Gas, Electric Primary Space Heating",200]
["122","Qualifying Electric","Other Gas","Gas Primary Space Heating","Qualifying Electric, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["123","Qualifying Electric","Other Gas","Other Primary Space Heating","Qualifying Electric, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["200","Other Electric","No Gas Selection","No Primary Space Heating Selection","Other Electric, No Gas Selection, No Primary Space Heating Selection"," "]
["201","Other Electric","No Gas Selection","Electric Primary Space Heating","Other Electric, No Gas Selection, Electric Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["202","Other Electric","No Gas Selection","Gas Primary Space Heating","Other Electric, No Gas Selection, Gas Primary Space Heating"," "]
["203","Other Electric","No Gas Selection","Other Primary Space Heating","Other Electric, No Gas Selection, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["210","Other Electric","Qualifying Gas","No Primary Space Heating Selection","Other Electric, Qualifying Gas, No Primary Space Heating Selection"," "]
["211","Other Electric","Qualifying Gas","Electric Primary Space Heating","Other Electric, Qualifying Gas, Electric Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["212","Other Electric","Qualifying Gas","Gas Primary Space Heating","Other Electric, Qualifying Gas, Gas Primary Space Heating",100]
["213","Other Electric","Qualifying Gas","Other Primary Space Heating","Other Electric, Qualifying Gas, Other Primary Space Heating","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["220","Other Electric","Other Gas","No Primary Space Heating Selection","Other Electric, Other Gas, No Primary Space Heating Selection","Does Not Qualify - Site's utility providers are not participating utilities"]
["221","Other Electric","Other Gas","Electric Primary Space Heating","Other Electric, Other Gas, Electric Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["222","Other Electric","Other Gas","Gas Primary Space Heating","Other Electric, Other Gas, Gas Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]
["223","Other Electric","Other Gas","Other Primary Space Heating","Other Electric, Other Gas, Other Primary Space Heating","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"New Doors Lookup","index":23,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["New Refrigerated Cases with Doors"]
["Combined","Electric Utility","Gas Utility","Primary Space Heatinging","Store Type (Size)","Combined","Incentive"]
[{"$f":"CONCATENATE(B3,C3,D3,E3)","v":{"$error":"#REF!"}},{"$f":"IF(OR(ELE_NUM=1,ELE_NUM=2),1,IF(ELE_NUM=0,0,2))","v":0},{"$f":"IF(OR(GAS_NUM=1,GAS_NUM=2,GAS_NUM=3),1,(IF(GAS_NUM=0,0,2)))","v":0},{"$f":"HEAT_NUM","v":0},{"$f":"Grocery!#REF!","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(A3,A5:G112,6)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(A3,A5:G112,7)","v":{"$error":"#REF!"}}]
["Combined","Electric Utility","Gas Utility","Primary Space Heatinging","Store Type (Size)","Combined","Incentive"]
["0001","No Electric Selection","No Gas Selection","No Primary Space Heating Selected","Convenience Stores/Small Grocery (< 14,000 sq ft)",{"$f":"B5&\", \"&C5&\", \"&D5&\", \"&E5","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selected, Convenience Stores/Small Grocery (< 14,000 sq ft)"}]
["0002","No Electric Selection","No Gas Selection","No Primary Space Heating Selected","Medium Grocery (> 14,000 and < 75,000 sq ft)",{"$f":"B6&\", \"&C6&\", \"&D6&\", \"&E6","v":"No Electric Selection, No Gas Selection, No Primary Space Heating Selected, Medium Grocery (> 14,000 and < 75,000 sq ft)"}]
["0003","No Electric Selection","No Gas Selection","No Primary Space Heating Selected","Large Grocery (< 75,000 sq ft)","No Electric Selection, No Gas Selection, No Primary Space Heating Selected, Large Grocery (< 75,000 sq ft)"]
["0011","No Electric Selection","No Gas Selection","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, No Gas Selection, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0012","No Electric Selection","No Gas Selection","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, No Gas Selection, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0013","No Electric Selection","No Gas Selection","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, No Gas Selection, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["0021","No Electric Selection","No Gas Selection","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, No Gas Selection, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0022","No Electric Selection","No Gas Selection","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, No Gas Selection, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0023","No Electric Selection","No Gas Selection","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, No Gas Selection, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["0031","No Electric Selection","No Gas Selection","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, No Gas Selection, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0032","No Electric Selection","No Gas Selection","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, No Gas Selection, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0033","No Electric Selection","No Gas Selection","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, No Gas Selection, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0101","No Electric Selection","Qualifying Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Qualifying Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0102","No Electric Selection","Qualifying Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Qualifying Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0103","No Electric Selection","Qualifying Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","No Electric Selection, Qualifying Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["0111","No Electric Selection","Qualifying Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Qualifying Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0112","No Electric Selection","Qualifying Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Qualifying Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0113","No Electric Selection","Qualifying Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Qualifying Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["0121","No Electric Selection","Qualifying Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Qualifying Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0122","No Electric Selection","Qualifying Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Qualifying Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0123","No Electric Selection","Qualifying Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Qualifying Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["0131","No Electric Selection","Qualifying Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Qualifying Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0132","No Electric Selection","Qualifying Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Qualifying Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0133","No Electric Selection","Qualifying Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Qualifying Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0201","No Electric Selection","Other Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Other Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0202","No Electric Selection","Other Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Other Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0203","No Electric Selection","Other Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","No Electric Selection, Other Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["0211","No Electric Selection","Other Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Other Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["0212","No Electric Selection","Other Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Other Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["0213","No Electric Selection","Other Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Other Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["0221","No Electric Selection","Other Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Other Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["0222","No Electric Selection","Other Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Other Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["0223","No Electric Selection","Other Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Other Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["0231","No Electric Selection","Other Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","No Electric Selection, Other Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0232","No Electric Selection","Other Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","No Electric Selection, Other Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["0233","No Electric Selection","Other Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","No Electric Selection, Other Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1001","Qualifying Electric","No Gas Selection","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, No Gas Selection, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["1002","Qualifying Electric","No Gas Selection","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, No Gas Selection, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["1003","Qualifying Electric","No Gas Selection","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Qualifying Electric, No Gas Selection, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["1011","Qualifying Electric","No Gas Selection","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, No Gas Selection, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","$70 per linear ft of door"]
["1012","Qualifying Electric","No Gas Selection","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, No Gas Selection, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","$70 per linear ft of door"]
["1013","Qualifying Electric","No Gas Selection","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, No Gas Selection, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)","$70 per linear ft of door"]
["1021","Qualifying Electric","No Gas Selection","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, No Gas Selection, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["1022","Qualifying Electric","No Gas Selection","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, No Gas Selection, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["1023","Qualifying Electric","No Gas Selection","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, No Gas Selection, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["1031","Qualifying Electric","No Gas Selection","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, No Gas Selection, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1032","Qualifying Electric","No Gas Selection","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, No Gas Selection, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1033","Qualifying Electric","No Gas Selection","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, No Gas Selection, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1101","Qualifying Electric","Qualifying Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Qualifying Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["1102","Qualifying Electric","Qualifying Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Qualifying Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["1103","Qualifying Electric","Qualifying Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Qualifying Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["1111","Qualifying Electric","Qualifying Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Qualifying Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","$70 per linear ft of door"]
["1112","Qualifying Electric","Qualifying Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","$70 per linear ft of door"]
["1113","Qualifying Electric","Qualifying Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)","$70 per linear ft of door"]
["1121","Qualifying Electric","Qualifying Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Qualifying Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","$70 per linear ft of door"]
["1122","Qualifying Electric","Qualifying Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","$70 per linear ft of door"]
["1123","Qualifying Electric","Qualifying Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)","$70 per linear ft of door"]
["1131","Qualifying Electric","Qualifying Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Qualifying Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1132","Qualifying Electric","Qualifying Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1133","Qualifying Electric","Qualifying Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Qualifying Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1201","Qualifying Electric","Other Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Other Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["1202","Qualifying Electric","Other Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Other Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["1203","Qualifying Electric","Other Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Other Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["1211","Qualifying Electric","Other Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Other Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","$70 per linear ft of door"]
["1212","Qualifying Electric","Other Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Other Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","$70 per linear ft of door"]
["1213","Qualifying Electric","Other Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)",{"$f":"B70&\", \"&C70&\", \"&D70&\", \"&E70","v":"Qualifying Electric, Other Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)"},"$70 per linear ft of door"]
["1221","Qualifying Electric","Other Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Other Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["1222","Qualifying Electric","Other Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Other Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["1223","Qualifying Electric","Other Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Other Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["1231","Qualifying Electric","Other Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Qualifying Electric, Other Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1232","Qualifying Electric","Other Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Qualifying Electric, Other Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["1233","Qualifying Electric","Other Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Qualifying Electric, Other Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2001","Other Electric","No Gas Selection","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, No Gas Selection, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["2002","Other Electric","No Gas Selection","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, No Gas Selection, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["2003","Other Electric","No Gas Selection","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Other Electric, No Gas Selection, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["2011","Other Electric","No Gas Selection","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, No Gas Selection, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2012","Other Electric","No Gas Selection","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, No Gas Selection, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2013","Other Electric","No Gas Selection","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, No Gas Selection, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2021","Other Electric","No Gas Selection","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, No Gas Selection, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["2022","Other Electric","No Gas Selection","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, No Gas Selection, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["2023","Other Electric","No Gas Selection","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, No Gas Selection, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)"]
["2031","Other Electric","No Gas Selection","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, No Gas Selection, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2032","Other Electric","No Gas Selection","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, No Gas Selection, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2033","Other Electric","No Gas Selection","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, No Gas Selection, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2101","Other Electric","Qualifying Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Qualifying Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)"]
["2102","Other Electric","Qualifying Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Qualifying Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)"]
["2103","Other Electric","Qualifying Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Other Electric, Qualifying Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)"]
["2111","Other Electric","Qualifying Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Qualifying Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2112","Other Electric","Qualifying Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Qualifying Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2113","Other Electric","Qualifying Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Qualifying Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not provided by a participating utility"]
["2121","Other Electric","Qualifying Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Qualifying Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","$35 per linear ft of door"]
["2122","Other Electric","Qualifying Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Qualifying Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","$35 per linear ft of door"]
["2123","Other Electric","Qualifying Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Qualifying Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)","$35 per linear ft of door"]
["2131","Other Electric","Qualifying Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Qualifying Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2132","Other Electric","Qualifying Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Qualifying Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2133","Other Electric","Qualifying Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Qualifying Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's primary space heating fuel is not electric or gas"]
["2201","Other Electric","Other Gas","No Primary Space Heating Selection","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Other Gas, No Primary Space Heating Selection, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2202","Other Electric","Other Gas","No Primary Space Heating Selection","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Other Gas, No Primary Space Heating Selection, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2203","Other Electric","Other Gas","No Primary Space Heating Selection","Large Grocery (< 75,000 sq ft)","Other Electric, Other Gas, No Primary Space Heating Selection, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2211","Other Electric","Other Gas","Electric Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Other Gas, Electric Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2212","Other Electric","Other Gas","Electric Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Other Gas, Electric Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2213","Other Electric","Other Gas","Electric Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Other Gas, Electric Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2221","Other Electric","Other Gas","Gas Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Other Gas, Gas Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2222","Other Electric","Other Gas","Gas Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Other Gas, Gas Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2223","Other Electric","Other Gas","Gas Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Other Gas, Gas Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2231","Other Electric","Other Gas","Other Primary Space Heating","Convenience Stores/Small Grocery (< 14,000 sq ft)","Other Electric, Other Gas, Other Primary Space Heating, Convenience Stores/Small Grocery (< 14,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2232","Other Electric","Other Gas","Other Primary Space Heating","Medium Grocery (> 14,000 and < 75,000 sq ft)","Other Electric, Other Gas, Other Primary Space Heating, Medium Grocery (> 14,000 and < 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]
["2233","Other Electric","Other Gas","Other Primary Space Heating","Large Grocery (< 75,000 sq ft)","Other Electric, Other Gas, Other Primary Space Heating, Large Grocery (< 75,000 sq ft)","Does Not Qualify - Site's utility providers are not participating utilities"]

{"sheet":"Eligible Spaces","index":24,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["(Select)"]
["Arcade"]
["Art classroom"]
["Bank vaults/safe deposit room"]
["Coin-operated Laundromat"]
["Commercial Laundromat"]
["Computer room (without printing)"]
["Copy/printing room"]
["Grocery Store"]
["Guard Stations"]
["Health club/weight room"]
["Hotel Rooms"]
["Library"]
["Main entry lobby"]
["Medical operating room"]
["Medical procedure room"]
["Office spaces"]
["Other"]
["Patient room"]
["Pet shop (animal areas) "]
["Photo studio"]
["Physical therapy"]
["Recovery and ICU area"]
["Sales floor (except mall common areas)"]
["Wood/metal shop"]