{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Form 120NWN","Summary","Multiple Sites","Option to Assign Payment","Lodging and Foodservice","Grocery","HVAC and Water Heating","Insulation","Admin Tools","Lookups","Eligible Spaces"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":43,"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 120NWN","index":0,"n_rows":142,"n_cols":48,"rows_kept":142,"cut":false,"hidden":false,"merged":[[33,21,33,38],[126,1,127,21],[127,23,127,38],[84,1,84,6],[91,2,91,15],[91,17,91,32],[91,34,91,37],[84,7,84,9],[86,1,86,6],[86,7,86,9],[80,1,80,39],[88,1,88,38],[89,2,89,38],[86,33,86,38],[82,1,82,6],[82,7,82,9],[149,23,152,38],[153,23,155,38],[95,1,108,21],[95,23,105,38],[106,23,111,38],[109,1,117,21],[112,23,115,38],[116,23,119,38],[118,1,121,21],[120,23,123,38],[122,1,125,21],[124,23,126,38],[25,21,25,28],[25,30,25,38],[22,30,22,33],[22,21,22,29],[22,37,22,38],[22,34,22,35],[16,21,16,38],[13,21,13,38],[9,34,9,38],[9,25,9,31],[19,21,19,29],[19,31,19,38],[52,30,52,38],[40,34,40,38],[42,24,42,38],[47,24,47,31],[47,32,47,35],[47,36,47,38],[60,37,60,38],[61,37,62,38],[60,35,60,36],[60,21,60,29],[55,30,55,38],[60,30,60,34],[66,21,66,38],[70,21,70,38],[61,21,62,29],[63,21,63,29],[63,31,63,38],[64,31,64,38],[61,30,62,33],[61,35,62,36],[77,21,77,29],[77,31,77,38],[73,35,73,38],[74,35,75,36],[73,21,73,31],[73,32,73,33]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[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":"v2022.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,"Trade Ally/Contractor/Installer Company Name (if applicable)"]
[]
[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,"Electric Utility:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(AP41,Lookups!A7:B10,2)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Gas Utility:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(AP46,Lookups!A13:B17,2)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:",null,null,null,null,null,null,null,null,null,null,"Rate Schedule:"]
[]
[]
[null,null,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,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($AP53,Lookups!$A$2:$B$5,2)","v":"None"}]
[]
[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,null,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($AP56,Lookups!$A$2:$B$5,2)","v":"None"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project and Site Information"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site 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,"Contact name for Site Visit",null,null,null,null,null,null,null,null,null,"Phone number for Site Visit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project and Site 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,{"$f":"VLOOKUP(AP71,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,"Site Address*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AP74,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,"City",null,null,null,null,null,null,null,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,"Contact name for Site Visit",null,null,null,null,null,null,null,null,null,"Phone number for Site Visit",null,null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP($AP79,Lookups!$A$2:$B$5,2)","v":"None"}]
[]
[null,"*(If requesting incentives for multiple locations,use the Multiple Sites tab (in this Excel workbook) to list each location's site address, utility infomation, and heating fuel sources)"]
[]
[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":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":true,"merged":[[33,1,33,4],[33,5,33,6],[34,2,34,6],[35,2,35,6],[36,1,37,6],[32,1,32,4],[32,5,32,6],[25,1,25,4],[25,5,25,6],[26,1,26,4],[26,5,26,6],[27,2,27,6],[28,1,28,4],[28,5,28,6],[29,1,29,4],[29,5,29,6],[30,1,30,4],[30,5,30,6],[31,2,31,6],[15,1,15,4],[17,1,17,6],[18,1,19,4],[24,1,24,4],[24,5,24,6],[10,1,10,6],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4]]}
[]
[null,"Standard Incentives Summary"]
[null,"Existing Buildings | Incentive Application | Form 120P"]
[]
[]
[null,"TRC is a Program Management Contractor for Energy Trust of Oregon."]
[]
[null,null,null,"Program Use Only",null,null,{"$f":"Version","v":"v2022.2"}]
[null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},"PTID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(PTID)=\"\",\"\",PTID))","v":""}]
[]
[null,"INCENTIVES"]
[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,"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,"COMBINED TOTAL REQUESTED INCENTIVES",null,null,null,"TOTAL REQUESTED \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,{"$f":"SUM(F13:F16)","v":0},{"$f":"SUM(G13:G16)","v":0}]
[]
[null," "]
[]
[]
[null,"SITES SERVED BY A PARTICIPATING ELECTRIC UTILITY",null,null,null,"INCENTIVE LIMIT"]
[null,"Site served by Portland General Electric",null,null,null,12000]
[null,"Site served by Pacific Power",null,null,null,6000]
[]
[null,"SITES SERVED BY A GAS UTILITY",null,null,null,"INCENTIVE LIMIT"]
[null,"Site served by NW Natural",null,null,null,12000]
[null,"Site served by Avista (and not Pacific Power)",null,null,null,12000]
[]
[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":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
["Standard Incentives"]
["Existing Buildings | Incentive Application | Form 120NWN"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Program Use Only",null,null,null,null,{"$f":"Version","v":"v2022.2"}]
[null,null,null,null,null,null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},null,"PT ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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)"]
[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":false,"merged":[[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],[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],[15,1,16,32],[9,15,9,17],[9,18,9,23],[9,24,9,26],[9,27,9,32],[11,1,12,32],[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]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[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":"v2022.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",null,null,{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},null,null,null,null,null,"PT ID",null,null,{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,25,15],[12,2,12,13],[10,1,10,17],[11,2,11,13],[27,1,27,17],[17,1,20,1],[17,2,17,13],[17,15,21,15],[17,16,21,16],[17,17,21,17],[13,1,16,1],[13,2,13,13],[13,14,13,17],[14,2,14,13],[15,2,15,13],[16,2,16,13],[17,14,20,14],[18,3,18,4],[18,5,18,6],[18,7,18,9],[18,10,18,11],[19,3,19,4],[19,5,19,6],[19,7,19,9],[19,10,19,11],[20,3,20,4],[20,5,20,6],[20,7,20,9],[20,10,20,11]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[]
[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":"v2022.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},"PTID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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," Gas Fryer",null,null,null,null,null,null,null,null,null,null,null,null,1250,null,{"$f":"P13*O13","v":0}]
[null," Gas-fired Automatic\n Conveyor Broiler "]
[null,null," Total conveyor belt width less than 20”",null,null,null,null,null,null,null,null,null,null,null,2500,null,{"$f":"P15*O15","v":0}]
[null,null," Total conveyor belt width 20” to 26”",null,null,null,null,null,null,null,null,null,null,null,3000,null,{"$f":"P16*O16","v":0}]
[null,null," Total conveyor belt width greater than 26”",null,null,null,null,null,null,null,null,null,null,null,3500,null,{"$f":"P17*O17","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,1100,null,{"$f":"O18*P18","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," Gas",null," Yes",null," Yes",null,null," > 3 hp"]
[null,null,null," Gas",null," No",null," Yes",null,null," > 4 hp"]
[]
[]
[]
[null,"TOTALS FOR LODGING AND FOODSERVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q13,Q15:Q22)","v":0},{"$f":"SUM(R13,R15:R22)","v":0}]

{"sheet":"Grocery","index":5,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,1,10,14],[11,2,11,10],[25,1,25,14],[22,1,23,12],[12,1,16,1],[12,2,12,10],[12,11,13,14],[13,2,13,4],[13,5,13,7],[13,8,13,10],[14,2,14,4],[14,5,14,7],[14,8,14,10],[15,2,15,4],[15,5,15,7],[15,8,15,10],[17,1,20,1],[17,2,17,10],[17,11,18,14],[18,2,18,4],[18,5,18,7],[18,8,18,10],[19,2,19,4],[19,5,19,7],[19,8,19,10],[20,2,20,4],[20,5,20,7],[20,8,20,10]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[]
[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":"v2022.2"}]
[null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},"PTID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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," New Cooler Cases\n with Doors"]
[null,null," Building \nHeating Fuel ",null,null," Participating\n Electric Utility",null,null," Participating\n Gas Utility"]
[null,null,"Gas",null,null,"Yes",null,null,"Yes",null,null,190,null,{"$f":"M15*L15","v":0}]
[null,null,"Gas†",null,null,"No",null,null,"Yes",null,null,190,null,{"$f":"M16*L16","v":0}]
[]
[null," Refrigerated Doors"]
[null,null," Building \nHeating Fuel ",null,null," Participating\n Electric Utility",null,null," Participating\n Gas Utility"]
[null,null,"Gas",null,null,"Yes",null,null,"Yes",null,null,300,null,{"$f":"L20*M20","v":0}]
[null,null,"Gas",null,null,"No",null,null,"Yes",null,null,300,null,{"$f":"L21*M21","v":0}]
[]
[null,"TOTALS FOR GROCERY",null,null,null,null,null,null,null,null,null,null,null,"TOTAL \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N15:N16,N20:N21)","v":0},{"$f":"SUM(O15:O16,O20:O21)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"HVAC and Water Heating","index":6,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,2,17,11],[21,1,22,13],[10,1,10,15],[11,2,11,11],[18,2,18,11],[19,2,19,11],[13,6,13,7],[12,12,14,12],[12,13,14,13],[12,14,14,14],[12,15,14,15],[15,2,16,11],[15,13,16,13],[15,14,16,14],[15,15,16,15],[12,0,14,0],[12,1,14,1],[12,2,12,11],[12,17,14,17],[12,16,14,16],[13,3,13,4],[13,8,13,9]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[]
[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":"v2022.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},"PTID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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," Steam Trap",null,null,null,null,null,null,null,null,null,null,150,null,{"$f":"M13*N13","v":0}]
[null,null,"Psig:",null,null,null,"Occupied 24/7:"]
[]
[null,null,"BONUS INCENTIVE - Limited Time Offer\nPurchased and installed between March 1 – July 31, 2022",null,null,null,null,null,null,null,null,null,"Bonus Incentive:",null,{"$f":"M17*N16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,150]
[null," Commercial Condensing Tank \n Water Heater",null,null,null,null,null,null,null,null,null,null,3.35,null,0]
[null," Modulating\n Boiler Burner",null,null,null,null,null,null,null,null,null,null,9,null,0]
[null,"Commercial Condensing Gas Furnace",null,null,null,null,null,null,null,null,null,null,8,null,0]
[]
[null,"TOTALS FOR HVAC AND WATER HEATING",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O13:O20)","v":0},{"$f":"SUM(P13:P20)","v":0}]

{"sheet":"Insulation","index":7,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,1,22,1],[19,2,19,4],[19,5,20,8],[41,1,42,6],[10,2,10,4],[11,1,14,1],[11,2,11,4],[11,5,12,8],[15,1,18,1],[15,2,15,4],[15,5,16,8],[23,1,25,1],[23,2,23,4],[23,5,24,8],[26,1,29,1],[26,2,26,4],[26,5,27,8],[34,2,34,4],[35,1,39,1],[35,2,35,4],[35,5,35,8],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4]]}
[]
[null,"Limited-time Increased Incentives for NW Natural Customers"]
[null,"Existing Buildings | Incentive Application | Form 120NWN"]
[]
[]
[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":"v2022.2"}]
[null,null,null,null,null,"Reference ID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(ReferenceID)=\"\",\"\",ReferenceID))","v":""},"PTID",{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(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 "," Participating\n Electric Utility"," Participating\n Gas Utility"]
[null,null," Gas"," Yes"," Yes",0.9,null,{"$f":"F14*G14","v":0}]
[null,null," Gas"," No"," Yes",0.9,null,{"$f":"F15*G15","v":0}]
[null," Roof Insulation,\n R-0 to R-15"]
[null,null," Building \nHeating Fuel "," Participating\n Electric Utility"," Participating\n Gas Utility"]
[null,null," Gas"," Yes"," Yes",2,null,{"$f":"F18*G18","v":0}]
[null,null," Gas"," No"," Yes",2,null,{"$f":"F19*G19","v":0}]
[null," Roof Insulation,\n R-0 to R-30"]
[null,null," Building \nHeating Fuel "," Participating\n Electric Utility"," Participating\n Gas Utility"]
[null,null," Gas"," Yes"," Yes",2,null,{"$f":"F22*G22","v":0}]
[null,null," Gas"," No"," Yes",2,null,{"$f":"F23*G23","v":0}]
[null," Roof Insulation,\n R-5 to R-30"]
[null,null," Building \nHeating Fuel "," Participating\n Electric Utility"," Participating\n Gas Utility"]
[null,null," Gas"," Yes"," Yes",2,null,{"$f":"F26*G26","v":0}]
[null," Wall Insulation,\n R-0 to R-20"]
[null,null," Building \nHeating Fuel "," Participating\n Electric Utility"," Participating\n Gas Utility"]
[null,null," Gas"," Yes"," Yes",1.3,null,{"$f":"G29*F29","v":0}]
[null,null," Gas"," No"," Yes",1.3,null,{"$f":"G30*F30","v":0}]
[]
[]
[]
[null,"INSULATION continued"]
[null,"EQUIPMENT","REQUIREMENTS",null,null,"INCENTIVE \nPER UNIT","QUANTITY","INCENTIVE\nTOTAL","INSTALLED\nCOST"]
[null," Pipe Insulation  "]
[null,null,"Piping serving domestic hot water",null,null,15,null,{"$f":"G37*F37","v":0}]
[null,null,"Piping serving medium pressure steam (15-200 psig)",null,null,15,null,{"$f":"G38*F38","v":0}]
[null,null,"Piping serving heating hot water",null,null,15,null,{"$f":"G39*F39","v":0}]
[null,null,"Piping serving low pressure steam (< 15 psig)",null,null,15,null,{"$f":"G40*F40","v":0}]
[]
[null,"TOTALS FOR INSULATION",null,null,null,null,null,"TOTAL \nINCENTIVES","TOTAL\nINSTALLED COST"]
[null,null,null,null,null,null,null,{"$f":"SUM(H14:H15,H18:H19,H22:H23,H26:H26,H29:H30,H37:H40)","v":0},{"$f":"SUM(I14:I15,I18:I19,I22:I23,I26:I26,I29:I30,I37:I40)","v":0}]

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

{"sheet":"Lookups","index":9,"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,"Pacific Power"]
[3,"Other"]
[]
["Gas Utility"]
[0,"(select)"]
[1,"NW Natural"]
[2,"NW Natural"]
[3,"NW Natural"]
[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":{"$error":"#NAME?"}}]
[{"$f":"IF(HEAT_NUM=1,\"Other Electric Heat\",\"Other Heat\")","v":{"$error":"#NAME?"}}]

{"sheet":"Eligible Spaces","index":10,"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"]