{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Application","Sizing Calculator","Startup Checklist","Error Messages","Photo Requirements","Process & Requirements","LookUps","WSEC Comparison","Area Calculator","Calcs_Heat Loss","Insulation Tables","City Temp Data","NOAA Temp Data"],"not_rendered":{"charts":0,"images":18,"macros":1,"external_links":0,"defined_names":274,"comments":11,"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":"Application","index":0,"n_rows":61,"n_cols":50,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,47],[24,43,24,46],[22,4,22,16],[22,17,22,29],[22,30,22,37],[22,38,22,42],[22,43,22,46],[33,4,33,16],[37,43,37,46],[33,17,33,29],[25,39,25,42],[23,4,23,46],[37,23,37,27],[37,29,37,33],[37,35,37,38],[33,30,33,37],[13,44,13,46],[13,19,13,21],[15,35,15,42],[14,43,14,46],[15,43,15,46],[15,29,15,33],[15,23,15,28],[14,23,14,28],[25,4,25,15],[15,4,15,7],[14,4,14,7],[15,8,15,11],[14,8,14,11],[14,12,14,14],[15,12,15,14],[32,3,32,47],[25,43,25,46],[15,15,15,17],[14,15,14,17],[21,3,21,47],[16,4,16,5],[25,35,25,38],[25,17,25,33],[14,19,14,22],[15,19,15,22],[17,4,17,46],[14,29,14,33],[33,38,33,42],[33,43,33,46],[35,43,35,46],[27,43,27,46],[28,4,28,15],[28,17,28,33],[28,35,28,38],[28,39,28,42],[28,43,28,46],[36,17,36,21],[37,39,37,42],[35,4,35,16],[35,30,35,37],[35,38,35,42],[43,31,43,38],[48,3,48,47],[42,4,42,15],[43,4,43,15],[43,25,43,30],[43,16,43,24],[42,39,42,46],[43,39,43,46],[42,31,42,38],[60,27,60,35],[36,43,36,46],[34,4,34,46],[53,8,53,16],[53,17,53,35],[53,36,53,38],[54,8,55,46],[53,39,53,42],[56,27,56,35],[57,27,57,35],[59,27,59,35],[56,37,57,46],[37,4,37,15],[37,17,37,21],[49,4,50,46],[51,4,51,46],[1,45,1,48],[11,35,11,41],[13,22,13,24],[11,26,11,34],[13,4,13,12],[13,13,13,18],[13,26,13,34],[13,35,13,40],[13,41,13,43],[4,3,5,21],[2,3,2,47],[9,3,9,47],[11,42,11,46],[11,4,11,12],[11,20,11,24],[11,13,11,19]]}
[]
[null,"Heating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Sept 2024"]
[null,null,null,"Energy Services  ●  ce@snopud.com  ●  www.snopud.com/TAResources"]
[]
[null,null,null,"Rebate Application"]
[]
[null,null,null,"For Heating Rebates in Single Family Homes"]
[]
[null,null,null,null,"Customer Information"]
[]
[null,null,null,null,"Homeowner Name",null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,"Phone",null,null,null,null,null,"Contact (if not homeowner)",null,null,null,null,null,null,null,null,"Contact Email",null,null,null,null,null,null,"Contact Phone",null,null,null,null,null,1]
[]
[null,null,null,null,"Installation Address",null,null,null,null,null,null,null,null,"City/Town",null,null,null,null,null,"State",null,null,"ZIP",null,null,null,"Mailing Address (If not home address)",null,null,null,null,null,null,null,null,"City/Town",null,null,null,null,null,"State",null,null,"ZIP",null,null,null,null,"Lake Stevens Test 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=IF(AppInstallCity<>\"\",IF(AppInstallCity=\"lake stevens\", TRUE,FALSE),\"\")"]
[null,null,null,null,"Total \nSqFt",null,null,null,"\nTreated Area SqFt",null,null,null,"# of Dwellings",null,null,"Year \nBuilt",null,null,null,"Residence \nType",null,null,null,"Home Type",null,null,null,null,null,"Foundation",null,null,null,null,null,"Primary Heat Source",null,null,null,null,null,null,null,"Water Heater",null,null,null,null,null,"Lake Stevens Test 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"=IF(AX14=FALSE, IF('Sizing Calculator'!E14<>\"Select City\",IF(SCDesignCity=\"Lake Stevens\", TRUE, FALSE),FALSE),IF(Application!AX14=TRUE,TRUE,\"\"))"]
[null,null,null,null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplier"]
[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,null,null,null,null,null,null,"=IF(OR(AX14=TRUE,AX16=TRUE),1.25,1)"]
[]
[]
[null,null,null,null,"Heat Pump Rebate"]
[]
[]
[null,null,null,null,"Heat Pump rebates are available to PUD customers who replace their primary electric resistance heating system (e.g., baseboard, wall heaters, electric furnace) with an efficient electric heat pump. Homes with an existing gas, oil, or propane furnace or boiler are not eligible. Only one (1) heat pump rebate per home. For more information on this program visit our\nHeating Page Please provide: 1) a PUD Startup Checklist, 2) a PUD Sizing Calculator with balance point, 3) an itemized invoice, and 4) verification photos. "]
[null,null,null,null,"Heat Pump",null,null,null,null,null,null,null,null,null,null,null,null,"Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Install Date",null,null,null,"Installed Cost",null,null,null,"Rebate Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AppHeatingRebate<>\"\",VLOOKUP(AppHeatingRebate,HP_Lookup,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(AppHeatingRebate)=0,SUM(AppHeatingRebateCost)=0),\"\",\nMIN(AppHeatingRebateCost,VLOOKUP(AppHeatingRebate,HP_Lookup,2,FALSE)))","v":""}]
[]
[null,null,null,null,"Thermostat",null,null,null,null,null,null,null,null,null,null,null,null,"Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Install Date",null,null,null,"Installed Cost",null,null,null,"Rebate Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E29<>\"\",VLOOKUP(E29,LookUps!C29:E29,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(E29)=0,SUM(AN29)=0),\"\",\nMIN(AN29,VLOOKUP(E29,LookUps!C29:E29,2,FALSE)))","v":""}]
[]
[]
[null,null,null,null,"Duct Sealing & Insulation Rebate"]
[]
[]
[null,null,null,null,"Must be sealed with mastic and insulated to a minimum of R-8. Please complete all applicable fields and provide: 1) an itemized invoice and 2) verification photos. \n    *Linear feet required only for Standard Construction homes. "]
[]
[null,null,null,null,"Home Type",null,null,null,null,null,null,null,null,null,null,null,null,"Linear Ft.*",null,null,null,null,null,"Old R-Value",null,null,null,null,null,"New R-Value",null,null,null,null,null,"Install Date",null,null,null,"Installed Cost",null,null,null,"Rebate Amount"]
[null,{"$f":"IF(E38=\"Standard Construction Home\",TRUE,FALSE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AppDSRebateCost<>\"\",IF(AppDSRebate<>\"\",VLOOKUP(AppDSRebate,DS_Lookup,2,FALSE),\"\")>AppDSRebateCost),AppDSRebateCost,\nIF(AppDSRebate<>\"\",VLOOKUP(E38,DS_Lookup,2,FALSE),\"\"))","v":""}]
[]
[]
[null,null,null,null,"PUD Registered Trade Ally Information"]
[]
[null,null,null,null,"Trade Ally Company Name",null,null,null,null,null,null,null,null,null,null,null,"Representative Name",null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,"Email Address",null,null,null,null,null,null,null,"Project Development Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(_AppHeatingRebateAmount)<=0,SUM(_AppDSRebateAmount)<=0),\"\",IF(LEFT(E52,1)=\"C\", \"Not Eligible\", 175))","v":""}]
[]
[]
[]
[null,null,null,null,"Signature"]
[]
[null,null,null,null,"I, the homeowner, request one or more rebates for measure(s) installed in the home located at the address above. Attached are legible copies of the itemized invoice(s) and other required documentation. I understand and agree to the terms of the Energy Efficiency Rebate Agreement, the Additional Conditions, and the conditions for participation in Residential Energy Efficiency Programs (\"Programs\"). I also understand that: \n    (i) the Public Utility District No. 1 of Snohomish County (\"PUD\") will make the final determination of any rebate I may be eligible to receive; \n    (ii) Program(s) are subject to change without notice; and \n    (iii) rebate applications must be submitted within 90 days of installation of the energy-efficiency measure(s). \n\nI agree to receive my rebate via (select one):"]
[]
[null,0,null,null,"Instant Rebate (provided on the PUD Registered Trade Ally's invoice) and authorize the PUD to pay the PUD Registered Trade Ally, in my name, the rebate(s) due to me"]
[]
[null,null,null,null,null,null,null,null,"Homeowner Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,true]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duct Sealing & Insulation Rebate:","$",{"$f":"_AppDSRebateAmount","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(_AppDSRebate=\"\",TRUE)","v":true},"When you have completed this workbook, click the button below to check that the application is complete. When complete, attach this workbook, verification photos, and the invoice to an email to ce@snopud.com."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heating Rebate:","$",{"$f":"_AppHeatingRebateAmount","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(_AppHeatingRebate=\"\",TRUE)","v":true}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Rebate:","$",{"$f":"IF(AK57=FALSE,SUM(AB57:AJ58),IF(AK58=TRUE,\"\",SUM(AB57:AJ58)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Development Incentive:","$",{"$f":"IF(OR(_AppTotalRebate=\"\",_AppTotalRebate=0),\"\",IF(AppORebateType=2, \"Not Eligible\", 150))","v":""}]

{"sheet":"Sizing Calculator","index":1,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[26,2,26,11],[4,3,5,6],[60,3,61,10],[56,5,56,6],[7,3,8,10],[55,7,56,10],[49,8,49,10],[50,8,50,10],[55,5,55,6],[32,2,32,11],[48,2,48,11],[54,2,54,11],[49,3,49,4],[49,5,49,6],[50,3,50,4],[50,5,50,6],[1,10,1,12],[2,2,2,11],[5,9,5,11],[11,2,11,11],[18,2,18,11],[12,8,12,9],[13,8,13,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Application!AT2","v":"V Sept 2024"}]
[null,null,{"$f":"BannerText","v":"Energy Services  ●  ce@snopud.com  ●  www.snopud.com/TAResources"}]
[]
[null,null,null,"Sizing Calculator "]
[null,null,null,null,null,null,null,null,"Homeowner Name:",{"$f":"IF(AppHOName<>\"\",AppHOName,\"\")","v":""}]
[null,null,null,"For Heat Pumps"]
[null,null,null,"This calculator is based on industry standard practices and ACCA Manuals J and S. Please note, this calculator will calculate heating loads only. Fill out all applicable information denoted by the the white input fields. As you work through this form, some values will be automatically calculated for you. If you have any issues filling out this form, please call (425) 229-5598 for assistance. "]
[]
[]
[null,null,null,"Home Information"]
[]
[null,null,null,"Design City","Design Delta T","Treated Area (ft2)","Avg Ceiling Height (ft)","Heated Volume (ft3)","% Ducts in Unheated Area",null,"Infiltration Level"]
[null,null,null,{"$f":"IF(AppInstallCity=\"\",\"\",AppInstallCity)","v":""},{"$f":"IF(D14<>\"\",IF(ISNA(VLOOKUP(D14,Cities_Lookup,2,FALSE)),\"Select City\",'Calcs_Heat Loss'!B12-VLOOKUP(D14,Cities_Lookup,2,TRUE)),\"\")","v":""},null,null,{"$f":"IFERROR(IF(F14=\"\",\"\",IF(G14=\"\",\"\",F14*G14)),\"\")","v":""}]
[]
[]
[]
[null,null,null,"Windows & Skylights"]
[]
[null,null,null,"Window Type","Area (sqft)","U-Factor","UA","Window Type","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D21<>\"\",VLOOKUP(D21,Windows_Lookup,2,0),\"\")","v":""},{"$f":"IF(E21<>\"\", IF(F21<>\"\",E21*F21,\"\"),\"\")","v":""},null,null,{"$f":"IF(H21<>\"\",VLOOKUP(H21,Windows_Lookup,2,0),\"\")","v":""},{"$f":"IF(J21<>\"\", IF(I21<>\"\", (J21*I21),\"\"),\"\")","v":""}]
[null,null,null,"Skylight","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D23<>\"\",INDEX(SkylightLookup,MATCH(D23,SkylightLookup),2),\"\")","v":""},{"$f":"IF(E23<>\"\", IF(F23<>\"\",E23*F23,\"\"),\"\")","v":""}]
[]
[]
[null,null,null,"Doors",null,null,""]
[]
[null,null,null,"Door Type","Area (sqft)","U-Factor","UA","Door Type","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D29<>\"\",VLOOKUP(D29,Doors_Lookup,2,0),\"\")","v":""},"",null,null,{"$f":"IF(H29<>\"\",VLOOKUP(H29,Doors_Lookup,2,0),\"\")","v":""},{"$f":"IF(I29<>\"\", IF(J29<>\"\",  (J29*I29),\"\"),\"\")","v":""}]
[]
[]
[null,null,null,"Insulation (Ceiling, Walls, Floors)"]
[]
[null,null,null,"Attic/Ceiling","Area (sqft)","U-Factor","UA","Attic/Ceiling","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D35<>\"\",VLOOKUP(D35,Attic_Lookup,2,0),\"\")","v":""},{"$f":"IF(E35<>\"\", IF(F35<>\"\",E35*F35,\"\"),\"\")","v":""},null,null,{"$f":"IF(H35<>\"\",VLOOKUP(H35,Attic_Lookup,2,0),\"\")","v":""},{"$f":"IF(I35<>\"\", IF(J35<>\"\",I35*J35,\"\"),\"\")","v":""}]
[null,null,null,"Above Grade Walls","Area (sqft)","U-Factor","UA","Above Grade Walls","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D37<>\"\",VLOOKUP(D37,AGW_Lookup,2,0),\"\")","v":""},{"$f":"IF(E37<>\"\", IF(F37<>\"\",E37*F37,\"\"),\"\")","v":""},null,null,{"$f":"IF(H37<>\"\",VLOOKUP(H37,AGW_Lookup,2,0),\"\")","v":""},{"$f":"IF(I37<>\"\", IF(J37<>\"\",I37*J37,\"\"),\"\")","v":""}]
[null,null,null,"Floors","Area (sqft)","U-Factor","UA","Floors","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D39<>\"\",VLOOKUP(D39,Floors_Lookup,2,0),\"\")","v":""},"",null,null,{"$f":"IF(H39<>\"\",VLOOKUP(H39,Floors_Lookup,2,0),\"\")","v":""},{"$f":"IF(I39<>\"\", IF(J39<>\"\",I39*J39,\"\"),\"\")","v":""}]
[null,null,null,"Below Grade Walls","Area (sqft)","U-Factor","UA","Below Grade Walls","Area (sqft)","U-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D41<>\"\",VLOOKUP(D41,BelowGrade_Lookup,2,0),\"\")","v":""},"",null,null,{"$f":"IF(H41<>\"\",VLOOKUP(H41,BelowGrade_Lookup,2,0),\"\")","v":""},{"$f":"IF(I41<>\"\", IF(J41<>\"\",I41*J41,\"\"),\"\")","v":""}]
[null,null,null,"Slab Below Grade","Length (ft)","F-Factor","UA","Slab Below Grade","Length (ft)","F-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D43<>\"\",VLOOKUP(D43,SlabBelowGrade_Lookup,2,0),\"\")","v":""},"",null,null,{"$f":"IF(H43<>\"\",VLOOKUP(H43,SlabBelowGrade_Lookup,2,0),\"\")","v":""},{"$f":"IF(I43<>\"\", IF(J43<>\"\",I43*J43,\"\"),\"\")","v":""}]
[null,null,null,"Slab On Grade","Length (ft)","F-Factor","UA"]
[null,null,null,null,null,{"$f":"IF(D45<>\"\",VLOOKUP(D45,SlabOnGrade_Lookup,2,0),\"\")","v":""},""]
[]
[]
[null,null,null,"Heat Pump Unit"]
[]
[null,null,null,"Manufacturer",null,"Outdoor Unit Model #",null,"Capacity at 17°F (BTU)","Capacity at 47°F (BTU)"]
[]
[]
[]
[null,null,null,"Results"]
[]
[null,null,null,"Balance Point (°F)","Minimum Auxiliary Heat Required (kW)","Design Heat Load (BTU)",null,{"$f":"IF(_SCBalancePoint=\"\",\"\",IF(_SCBalancePoint<=20,_SCBelow20,IF(_SCBalancePoint<=24,_SCBelow24,IF(_SCBalancePoint<=30,_SCBelow30,IF(_SCBalancePoint>30,_SCAbove35,\"\")))))","v":""},null,null,null,null,null,"The Balance Point is above 30°F and does not meet PUD requirements. Please select a different heat pump unit."]
[null,null,null,{"$f":"IFERROR(ROUND(IF(SCLowCapacity<>\"\",IF(SCMrgHighCapacity<>\"\",('Calcs_Heat Loss'!B27-'Calcs_Heat Loss'!B17)/('Calcs_Heat Loss'!B16-'Calcs_Heat Loss'!B26),\"\"),\"\"),0),\"\")","v":""},{"$f":"IFERROR(IF(_SCMrgDesignHeatLoad/3412<10,10,_SCMrgDesignHeatLoad/3412),\"\")","v":""},{"$f":"IFERROR('Calcs_Heat Loss'!B7,\"\")","v":""},null,null,null,null,null,null,null,"Balance Point is 30°F or below and meets PUD requirements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance Point is 24°F or below and meets PUD requirements if the Heat Pump is 2-Stage or Inverter Driven."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance Point is 20°F or below and meets PUD requirements if the Heat Pump is Inverter Driven."]
[null,null,null,"Notes"]
[]
[]
[]
[null,null,null,{"$f":"_xlfn.IFNA(\"\",'Calcs_Heat Loss'!B38)","v":""}]

{"sheet":"Startup Checklist","index":2,"n_rows":68,"n_cols":48,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,2,2,46],[9,2,9,46],[24,2,24,46],[37,2,37,46],[42,2,42,46],[49,2,49,46],[54,2,54,46],[4,2,5,34],[5,41,5,45],[25,3,25,14],[26,3,26,14],[25,15,25,45],[26,15,26,45],[34,31,34,36],[33,25,33,30],[34,25,34,30],[32,19,32,24],[34,19,34,24],[33,19,33,24],[38,43,38,45],[32,3,32,18],[33,3,33,18],[34,3,34,18],[10,28,10,33],[65,4,65,45],[59,7,59,15],[59,16,59,34],[59,35,59,37],[59,38,59,45],[43,28,43,37],[44,28,44,37],[44,38,44,45],[45,3,46,6],[45,18,45,27],[46,7,46,17],[46,18,46,27],[45,7,45,17],[46,40,46,45],[43,38,43,45],[45,40,45,45],[45,36,45,39],[46,36,46,39],[56,3,56,27],[56,28,56,45],[57,3,57,27],[57,28,57,45],[55,3,55,45],[45,28,45,35],[12,40,12,45],[13,40,13,45],[12,16,12,27],[13,16,13,27],[12,3,12,15],[13,3,13,15],[10,3,10,11],[29,2,29,46],[39,3,39,12],[39,13,39,18],[38,13,38,18],[39,19,39,25],[38,19,38,25],[39,26,39,31],[39,32,39,37],[39,43,39,45],[39,38,39,42],[38,26,38,37],[34,43,34,45],[31,19,31,24],[33,43,33,45],[32,43,32,45],[34,40,34,42],[34,37,34,39],[11,3,11,11],[10,34,10,39],[11,34,11,39],[11,28,11,33],[10,23,10,27],[11,23,11,27],[12,28,12,33],[12,34,12,39],[13,28,13,33],[13,34,13,39],[11,12,11,16],[10,12,10,16],[10,17,10,22],[11,17,11,22],[46,28,46,35],[50,3,50,15],[50,16,50,38],[43,7,43,16],[43,18,43,27],[44,7,44,17],[44,18,44,27],[43,3,44,6],[16,2,16,46],[19,19,19,28],[20,19,20,28],[21,19,21,28],[20,29,20,37],[21,29,21,37],[20,38,20,41],[21,38,21,41],[33,31,33,36],[18,19,18,28],[1,45,1,47],[51,16,51,28],[51,29,51,38],[51,3,51,15],[50,39,50,45],[51,39,51,45],[18,3,18,18],[32,39,32,42],[31,39,31,45],[31,31,31,38],[32,31,32,38],[32,25,32,30],[31,25,31,30],[33,40,33,42],[33,37,33,39],[31,3,31,18],[30,3,30,45],[17,42,21,45],[18,38,18,41],[19,38,19,41],[18,29,18,37],[19,29,19,37],[10,40,10,45],[11,40,11,45]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Application!AT2","v":"V Sept 2024"}]
[null,null,{"$f":"BannerText","v":"Energy Services  ●  ce@snopud.com  ●  www.snopud.com/TAResources"}]
[]
[null,null,"Heat Pump Start-Up Checklist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeowner Name:",{"$f":"IF(AppHOName<>\"\",AppHOName,\"\")","v":""}]
[]
[null,null,null,"All applicable sections must be filled out by the contractor at the time of installation. This completed form must be signed by the contractor. Submittal required to receive PUD funding. Keep a copy for your records. "]
[null,null,null,"New Heat Pump Equipment"]
[]
[null,null,null,"AHRI #",null,null,null,null,null,null,null,null,"HSPF 2",null,null,null,null,"SEER 2",null,null,null,null,null,"Balance Point",null,null,null,null,"Outdoor Unit Make",null,null,null,null,null,"Outdoor Unit Model #",null,null,null,null,null,"No. of Stages or Check for Inverter Driven"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(_SCBalancePoint<>\"\",_SCBalancePoint,\"\")","v":""},null,null,null,null,{"$f":"IF(SCMrgHPManufacturer<>\"\",SCMrgHPManufacturer,\"\")","v":""},null,null,null,null,null,{"$f":"IF(SCMrgHPModelNo<>\"\",SCMrgHPModelNo,\"\")","v":""}]
[null,null,null,"Backup/Auxiliary Heat Type",null,null,null,null,null,null,null,null,null,null,null,null,"Backup/Auxiliary Heat Capacity (kW)",null,null,null,null,null,null,null,null,null,null,null,"Indoor Unit Make",null,null,null,null,null,"Indoor Unit Model #",null,null,null,null,null,"Outdoor Unit Capacity (Tons)",null,null,null,null,null,null,false]
[null,{"$f":"SCMrgHPManufacturer","v":0},null,"Electric"]
[]
[null,null,null,"External Static Pressure test"]
[]
[null,null,null,"CHECK IN FULL CAPACITY UNLESS CONDITIONS DO NOT PERMIT. ATTACH ADDITIONAL SHEETS AS NEEDED IF TEST MUST BE RE-RUN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE: External Static Pressure of 200 Pa (0.8 inches H20) or more in Step 4 can result in excessive fan energy use and early fan failure."]
[null,null,null,"1. Expected CFM/Ton based on fan wiring board settings ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Heating CFM/Ton Setting",null,null,null,null,null,null,null,null,null,"1. Cooling CFM/Ton Setting",null,null,null,null,null,null,null,null,"Units (PA or in. H2O)"]
[null,null,null,"2. Measure return static pressure"]
[null,null,null,"3. Measure supply plenum static pressure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Return Static Pressure",null,null,null,null,null,null,null,null,null,"3. Supply Plenum Static Pressure",null,null,null,null,null,null,null,null,"4. External Static Pressure"]
[null,null,null,"4. External Static Pressure = #2 + #3 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(T22=\"\",AD22=\"\"),\"\",T22+AD22)","v":""},null,null,null,null,null,null,null,null,1]
[]
[null,null,null,"Air Flow"]
[]
[null,null,null,"Total CFM",null,null,null,null,null,null,null,null,null,null,null,"How was this verified?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,"TrueFlow Test"]
[]
[null,null,null,"CHECK IN FULL CAPACITY UNLESS CONDITIONS DO NOT PERMIT. ATTACH ADDITIONAL SHEETS AS NEEDED IF TEST MUST BE RE-RUN."]
[null,null,null,"1. Measure Normal System Operation Pressure (NSOP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. NSOP",null,null,null,null,null,"2. Units (PA or in. H2O)",null,null,null,null,null,"3. Plate Size (#14 or #20)",null,null,null,null,null,null,null,"4. TrueFlow Plate Location"]
[null,null,null,"5. Measure Supply Pressure with TrueFlow plate in (TFSOP)"]
[null,null,null,"6. Calculate Correction Factor [SQRT(NSOP/TFSOP)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. TFSOP",null,null,null,null,null,"6. Correction Factor",null,null,null,null,null,"7. Plate Pressure",null,null,null,null,null,"8. Raw CFM",null,null,"9. Corrected CFM",null,null,"10. CFM/Ton"]
[null,null,null,"9. Calculate Corrected CFM (Raw Flow x Correction Factor) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUNSOP<>\"\",T35<>\"\"),SQRT(SUNSOP/T35),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Z35<>\"\",AL35<>\"\"),ROUND(Z35,2)*AL35,\"\")","v":""},null,null,{"$f":"IF(AND(AO35<>\"\",AO14<>\"\"),AO35/AO14,\"\")","v":""},null,null,null,false]
[]
[null,null,null,"Refrigerant Charge Information/Testing"]
[]
[null,null,null,"ECM Blower on Indoor Unit? (Y/N)",null,null,null,null,null,null,null,null,null,"OD Air Temp (°F)",null,null,null,null,null,"Testing Mode ",null,null,null,null,null,null,"Stage/Capacity Tested (High/Low/Other)",null,null,null,null,null,null,null,null,null,null,null,"Total Lineset Length (ft)",null,null,null,null,"Units (PA or in. H2O)"]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N40<>\"\",IF(N40>65,\"Cooling\", IF(OR(N40=65,N40<65),\"Heating\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUOutdoorTemp<>\"\",IF(SUOutdoorTemp<=65,1,IF(SUOutdoorTemp>65,2,0)),0)","v":0}]
[null,{"$f":"IF(SUStageCapacity=3,TRUE,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Performance Check: Run unit for at least 15 minutes in compressor-only mode before taking readings"]
[]
[null,null,null,"Heating Mode:",null,null,null,"Supply Air (SA) Temperature",null,null,null,null,null,null,null,null,null,null,"Return Air (RA) Temperature\t\t\t\t\t\t\t\t",null,null,null,null,null,null,null,null,null,"Temperature Split (SA-RA)",null,null,null,null,null,null,null,null,null,"Is expected temp split from charge acceptable? (Y/N)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H45<>\"\",S45<>\"\"),H45-S45,\"\")","v":""}]
[null,null,null,"Cooling Mode:",null,null,null,"Discharge Pressure (PSI)",null,null,null,null,null,null,null,null,null,null,"Discharge Temperature [A]",null,null,null,null,null,null,null,null,null,"Liquid Line Temperature [B]",null,null,null,null,null,null,null,"Subcooling [A]-[B]",null,null,null,"Is subcooling [A]-[B] acceptable? (Y/N)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S47<>\"\",AC47<>\"\"),S47-AC47,\"\")","v":""}]
[]
[null,null,null,"Controls"]
[]
[null,null,null,"Make/Model of Indoor Thermostat",null,null,null,null,null,null,null,null,null,null,null,null,"Auxiliary (Strip) Heat Lockout Temperature (30°F/35°F/Other)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Thermostat Location"]
[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,null,null,null,null,{"$f":"IF(SULockoutTemp=3,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Required Technician Signature"]
[]
[null,null,null,"By signing below, technician certifies that this form and any accompanying documentation are complete and accurate, and that all measure associated with this project meet program requirements and were completed as of the signature date below. "]
[null,null,null,"Contractor Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technician Name"]
[]
[]
[null,null,null,null,null,null,null,"Technician Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,true]
[]
[null,null,null,"CONTRACTOR: Please remember to do the following"]
[null,null,null,null,"Provide warranty information and review it with the customer"]
[null,null,null,null,"Provide the heat pump manufacturer's owner manual to the customer"]
[null,null,null,null,"Explain the different operating modes (e.g. heating, emergency heat, defrosting) of the heat pump system as well as the effects of obstructing registers/return-air grilles to the customer"]
[null,null,null,null,"Demonstrate how to clean or replace the filter to the customer"]
[null,null,null,null,"Review and explain operation of the indoor thermostat and indicator lights with the customer"]

{"sheet":"Error Messages","index":3,"n_rows":107,"n_cols":11,"rows_kept":107,"cut":false,"hidden":true,"merged":[[0,4,0,6],[0,8,0,10]]}
["These Items Need to be Completed",null,"Checked?",null,"Filter Range",null,null,null,"Filter Results"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K2<>\"\",$K2,I2),\"\")","v":""},null,false,null,"Section","Value","Message",null,{"$f":"_xlfn._xlws.FILTER(E3:G106,F3:F106=0,G107)","v":"Name"},0,"Application - Homeowner Name missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K3<>0,$K3,\"\"),\"\")","v":""},null,null,null,"Name",{"$f":"AppHOName","v":0},"Application - Homeowner Name missing",null,"Email",0,"Application - Homeowner Email Address missing"]
["",null,null,null,"Email",{"$f":"AppHOEmail","v":0},"Application - Homeowner Email Address missing",null,"Phone",0,"Application - Homeowner Phone Number missing"]
["",null,null,null,"Phone",{"$f":"AppHOPhone","v":0},"Application - Homeowner Phone Number missing",null,"Address",0,"Application - Home Installation Address missing"]
["",null,null,null,"Address",{"$f":"AppInstallAddress","v":0},"Application - Home Installation Address missing",null,"City",0,"Application - Home Installation City missing"]
["",null,null,null,"City",{"$f":"AppInstallCity","v":0},"Application - Home Installation City missing",null,"Zip Code",0,"Application - Home Installation Zip Code missing"]
["",null,null,null,"Zip Code",{"$f":"AppInstallZip","v":0},"Application - Home Installation Zip Code missing",null,"Total Sqft",0,"Application - Total Square Footage missing"]
["",null,null,null,"Total Sqft",{"$f":"AppAreaTotal","v":0},"Application - Total Square Footage missing",null,"Treated Sqft",0,"Application - Treated Square Footage missing"]
["",null,null,null,"Treated Sqft",{"$f":"AppAreaTreated","v":0},"Application - Treated Square Footage missing",null,"No. Dwellings",0,"Application - Number of Dwellings missing"]
["",null,null,null,"Treated vs. Total",{"$f":"IF(AppAreaTreated>AppAreaTotal,0,\"N/A\")","v":"N/A"},"Application - Treated Square Footage cannot be greater than Total Square Footage",null,"Year Built",0,"Application - Year Built missing"]
["",null,null,null,"No. Dwellings",{"$f":"AppNoDwellings","v":0},"Application - Number of Dwellings missing",null,"Residence Type",0,"Application - Residence Type missing"]
["",null,null,null,"Year Built",{"$f":"AppYearBuilt","v":0},"Application - Year Built missing",null,"Home Type",0,"Application - Home Type missing"]
["",null,null,null,"Residence Type",{"$f":"Application!T16","v":0},"Application - Residence Type missing",null,"Electric  Heat Type",0,"Application - Electric Heat Type missing"]
["",null,null,null,"Home Type",{"$f":"Application!X16","v":0},"Application - Home Type missing",null,"Rebate Selection",0,"Application - No Heat Pump selected"]
["",null,null,null,"Electric  Heat Type",{"$f":"Application!AJ16","v":0},"Application - Electric Heat Type missing",null,"TA Company Name",0,"Application - Trade Ally Company Name missing"]
["",null,null,null,"Rebate Selection",{"$f":"AppHeatingRebate","v":0},"Application - No Heat Pump selected",null,"TA Rep Name",0,"Application - Trade Ally Representative Name missing"]
["",null,null,null,"HP Install Date",{"$f":"IF(AppHeatingRebate<>\"\",AppHeatingRebateDate,\"N/A\")","v":"N/A"},"Application - Heat Pump Rebate Install Date missing",null,"TA Phone",0,"Application - Trade Ally Phone Number missing"]
["",null,null,null,"HP Installed Cost",{"$f":"IF(AppHeatingRebate<>\"\",AppHeatingRebateCost,\"N/A\")","v":"N/A"},"Application - Heat Pump Rebate Installed Cost missing",null,"TA Email",0,"Application - Trade Ally Email Address missing"]
["",null,null,null,"DS/I Linear Feet",{"$f":"IF(AND(AppDSRebate<>\"\", AND(AppDSRebate<>\"\",AppDSRebate=\"Standard\")),AppDSRebateLinearFt,\"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate Linear Feet missing",null,"Signature",0,"Application - Homeowner Signature missing"]
["",null,null,null,"DS/I Old R Value",{"$f":"IF(AppDSRebate<>\"\",AppDSRebateOldR,\"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate Old R Value missing",null,"Signature Date",0,"Application - Homeowner Signature Date missing"]
["",null,null,null,"DS/I New R Value",{"$f":"IF(AppDSRebate<>\"\",AppDSRebateNewR,\"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate New R Value missing",null,"Sizing Treated Sqft",0,"Sizing Calculator - Treated Square Footage missing"]
["",null,null,null,"DS/I Min R Value",{"$f":"IF(AppDSRebateNewR<>\"\", IF(AppDSRebateNewR<8,0,\"N/A\"), \"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate New R Value must be a minimum R-8",null,"Ceiling Height",0,"Sizing Calculator - Ceiling Height missing"]
["",null,null,null,"DS/I Install Date",{"$f":"IF(AppDSRebate<>\"\",AppDSRebateDate,\"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate Install Date missing",null,"% Unheated Ducts",0,"Sizing Calculator - % Unheated Ducts missing"]
["",null,null,null,"DS/I Install Cost",{"$f":"IF(AppDSRebate<>\"\",AppDSRebateCost,\"N/A\")","v":"N/A"},"Application - Duct Sealing/Insulation Rebate Installed Cost missing",null,"Infiltration Level",0,"Sizing Calculator - Infiltration Level missing"]
["",null,null,null,"TA Company Name",{"$f":"AppTACompanyName","v":0},"Application - Trade Ally Company Name missing",null,"Windows",0,"Sizing Calculator - Windows Entry missing"]
["",null,null,null,"TA Rep Name",{"$f":"AppTARepName","v":0},"Application - Trade Ally Representative Name missing",null,"Doors",0,"Sizing Calculator - Doors Entry missing"]
["",null,null,null,"TA Phone",{"$f":"AppTAPhone","v":0},"Application - Trade Ally Phone Number missing",null,"Attic/Ceiling",0,"Sizing Calculator - Attic/Ceiling Entry missing"]
["",null,null,null,"TA Email",{"$f":"AppTAEmail","v":0},"Application - Trade Ally Email Address missing",null,"Above Grade Walls",0,"Sizing Calculator - Above Grade Walls Entry missing"]
["",null,null,null,"Instant Rebate",{"$f":"Application!E52","v":"Instant Rebate (provided on the PUD Registered Trade Ally's invoice) and authorize the PUD to pay the PUD Registered Trade Ally, in my name, the rebate(s) due to me"},"Application - Instant Rebate or Credit field missing",null,"Floor",0,"Sizing Calculator - Floor Selection [Floors, Slab Below Grade, or Slab on Grade] missing"]
["",null,null,null,"Signature",{"$f":"AppHomeownerSignature","v":0},"Application - Homeowner Signature missing",null,"HP Manufacturer",0,"Sizing Calculator - Heat Pump Manufacturer missing"]
["",null,null,null,"Signature Date",{"$f":"AppSignatureDate","v":0},"Application - Homeowner Signature Date missing",null,"HP Model No",0,"Sizing Calculator - Heat Pump Model Number missing"]
["",null,null,null,"Electronic Signature",{"$f":"IF(Application!$B$55=FALSE,0,\"N/A\")","v":"N/A"},"Application - Electronic Signature Checkbox missing",null,"17F Capacity",0,"Sizing Calculator - 17F Capacity of Heat Pump missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K34<>0,$K34,\"\"),\"\")","v":""},null,null,null,"Sizing Treated Sqft",{"$f":"SCTreatedArea","v":0},"Sizing Calculator - Treated Square Footage missing",null,"47F Capacity",0,"Sizing Calculator - 47F Capacity of Heat Pump missing"]
["",null,null,null,"SC Treated Sqft Match",{"$f":"IF(AND(SCTreatedArea<>0, AppAreaTreated<>0),IF(AppAreaTreated<>SCTreatedArea,0,\"N/A\"),\"N/A\")","v":"N/A"},"Application/Sizing Calculator - Treated Square Footage doesn't match",null,"AHRI #",0,"Startup Checklist - AHRI # missing"]
["",null,null,null,"Ceiling Height",{"$f":"SCCeilingHt","v":0},"Sizing Calculator - Ceiling Height missing",null,"HSPF Rating",0," Startup Checklist - HSPF Rating missing"]
["",null,null,null,"% Unheated Ducts",{"$f":"IF(SCMrgUnheatedDucts=\"\",0,\"N/A\")","v":0},"Sizing Calculator - % Unheated Ducts missing",null,"SEER Rating",0,"Startup Checklist - SEER Rating missing"]
["",null,null,null,"Infiltration Level",{"$f":"SCInfiltration","v":0},"Sizing Calculator - Infiltration Level missing",null,"Outdoor Unit Make",0,"Startup Checklist - Outdoor Unit Make missing"]
["",null,null,null,"Windows",{"$f":"IF(OR(SCWindowType1=\"\",SCWindowArea1=\"\"),0,\"N/A\")","v":0},"Sizing Calculator - Windows Entry missing",null,"Outdoor Unit Model",0,"Startup Checklist - Outdoor Unit Model # missing"]
["",null,null,null,"Doors",{"$f":"IF(OR(SCDoorType1=\"\",SCDoorArea1=\"\"),0,\"N/A\")","v":0},"Sizing Calculator - Doors Entry missing",null,"# of Compressor stages",0,"Startup Checklist - # of Compressor Stages missing"]
["",null,null,null,"Attic/Ceiling",{"$f":"IF(OR(SCAtticType1=\"\",SCAtticArea1=\"\"),0,\"N/A\")","v":0},"Sizing Calculator - Attic/Ceiling Entry missing",null,"Indoor Unit Make",0,"Startup Checklist - Indoor Unit Make missing"]
["",null,null,null,"Above Grade Walls",{"$f":"IF(OR(SCAGWType1=\"\",SCAGWArea1=\"\"),0,\"N/A\")","v":0},"Sizing Calculator - Above Grade Walls Entry missing",null,"Indoor Unit Model",0,"Startup Checklist - Indoor Unit Model Number missing"]
["",null,null,null,"Floor",{"$f":"IF(OR(SCFloorsType1=\"\",SCFloorsArea1=\"\"),0,\"N/A\")","v":0},"Sizing Calculator - Floor Selection [Floors, Slab Below Grade, or Slab on Grade] missing",null,"Outdoor Unit Capacity ",0,"Startup Checlist - Outdoor Unit Capacity (tons) missing"]
["",null,null,null,"Windows Area 1",{"$f":"IF(SCWindowArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Window Area 1 cannot be greater than Total Treated Area",null,"Backup/Auxiliary Heat Capacity",0,"Startup Checklist - Backup/Auxiliary Heat Capacity (kW) missing"]
["",null,null,null,"Windows Area 2",{"$f":"IF(SCWindowArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Window Area 2 cannot be greater than Total Treated Area",null,"Heating or Cooling CFM/Ton",0,"Startup Checklist - Heating or Cooling CFM/Ton Setting missing"]
["",null,null,null,"Skylight Area",{"$f":"IF(SCSkylightArea>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Skylight Area cannot be greater than Total Treated Area",null,"Return Static Pressure",0,"Startup Checklist - Return Static Pressure missing"]
["",null,null,null,"Doors Area 1",{"$f":"IF(SCDoorArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Doors Area 1 cannot be greater than Total Treated Area",null,"Supply Plenum Static Pressure",0,"Startup Checklist - Supply Plenum Static Pressure missing"]
["",null,null,null,"Doors Area 2",{"$f":"IF(SCDoorArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Doors Area 2 cannot be greater than Total Treated Area",null,"Pressure Test Units",0,"Startup Checklist - Pressure Test Units missing"]
["",null,null,null,"Attic Area 1",{"$f":"IF(SCAtticArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Attic Area 1 cannot be greater than Total Treated Area",null,"External Static Pressure",0,"Startup Checklist - External Static Pressure missing"]
["",null,null,null,"Attic Area 2",{"$f":"IF(SCAtticArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Attic Area 2 cannot be greater than Total Treated Area",null,"Total CFM",0,"Startup Checklist - Total CFM missing"]
["",null,null,null,"AGW Area 1",{"$f":"IF(SCAGWArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Above Grade Walls Area 1 cannot be greater than Total Treated Area",null,"ECM Blower",0,"Startup Checklist - ECM Blower missing"]
["",null,null,null,"AGW Area 2",{"$f":"IF(SCAGWArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Above Grade Walls Area 2 cannot be greater than Total Treated Area",null,"Outdoor Air Temperatures",0,"Startup Checklist - Outdoor Air Temperatures missing"]
["",null,null,null,"Floors Area 1",{"$f":"IF(SCFloorsArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Floors Area 1 cannot be greater than Total Treated Area",null,"Fridge Unit Heating/CoolingTesting Mode",0,"Startup Checklist - Unit Testing Mode missing"]
["",null,null,null,"Floors Area 2",{"$f":"IF(SCFloorsArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Floors Area 2 cannot be greater than Total Treated Area",null,"Total Lineset Length",0,"Startup Checklist - Total Lineset Length missing"]
["",null,null,null,"BGW Area 1",{"$f":"IF(SCBGWArea1>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Below Grade Walls Area 1 cannot be greater than Total Treated Area",null,"Refrigerant Units",0,"Startup Checklist - Refrigerant Units missing"]
["",null,null,null,"BGW Area 2",{"$f":"IF(SCBGWArea2>SCTreatedArea,0,\"N/A\")","v":"N/A"},"Sizing Calculator - Below Grade Walls Area 2 cannot be greater than Total Treated Area",null,"Indoor Thermostat Make/Model",0,"Startup Checklist - Make/Model of Indoor Thermostat missing"]
["",null,null,null,"HP Manufacturer",{"$f":"SCMrgHPManufacturer","v":0},"Sizing Calculator - Heat Pump Manufacturer missing",null,"Outdoor Thermostat Location",0,"Startup Checklist - Outdoor Thermostat Location missing "]
["",null,null,null,"HP Model No",{"$f":"SCMrgHPModelNo","v":0},"Sizing Calculator - Heat Pump Model Number missing",null,"Aux Heat Lockout",0,"Startup Checklist - Auxiliary Heat Lockout missing"]
["",null,null,null,"17F Capacity",{"$f":"SCLowCapacity","v":0},"Sizing Calculator - 17F Capacity of Heat Pump missing",null,"Contractor Name",0,"Startup Checklist - Contractor Name missing"]
["",null,null,null,"47F Capacity",{"$f":"SCMrgHighCapacity","v":0},"Sizing Calculator - 47F Capacity of Heat Pump missing",null,"Technician Name",0,"Startup Checklist - Technician Name missing"]
["",null,null,null,"BGW Completeness",{"$f":"IF(OR(SCBelowGradeWalls<>\"\",SCBGWArea1<>\"\"),IF(OR(SCBelowGradeWalls=\"\",SCBGWArea1=\"\"),0,\"N/A\"),\"N/A\")","v":"N/A"},"Sizing Calculator - Below Grade Walls Entry incomplete",null,"Technician Signature",0,"Startup Checklist - Technician Signature missing"]
["",null,null,null,"Slab Below Grade Completeness",{"$f":"IF(OR(SCSlabBelow<>\"\",SCSlabBelowLength1<>\"\"),IF(OR(SCSlabBelow=\"\",SCSlabBelowLength1=\"\"),0,\"N/A\"),\"N/A\")","v":"N/A"},"Sizing Calculator - Slab Below Grade Entry incomplete",null,"Technician Signature Date",0,"Startup Checklist - Technician Signature Date missing"]
["",null,null,null,"Slab On Grade Completeness",{"$f":"IF(OR(SCSOGType<>\"\",SCSOGLength<>\"\"),IF(OR(SCSOGType=\"\",SCSOGLength=\"\"),0,\"N/A\"),\"N/A\")","v":"N/A"},"Sizing Calculator - Slab on Grade Entry incomplete"]
["",null,null,null,"Supply Air Size",{"$f":"IF(AND(_SCBalancePoint>30,_SCBalancePoint<36),SCSupply,\"N/A\")","v":"N/A"},"Sizing Calculator - Supply Air Size missing"]
["",null,null,null,"Return Air Size",{"$f":"IF(AND(_SCBalancePoint>30,_SCBalancePoint<36),SCReturn,\"N/A\")","v":"N/A"},"Sizing Calculator - Return Air Size missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K66<>0,$K66,\"\"),\"\")","v":""},null,null,null,"AHRI #",{"$f":"SUAHRI","v":0},"Startup Checklist - AHRI # missing"]
["",null,null,null,"HSPF Rating",{"$f":"SUHSPF","v":0}," Startup Checklist - HSPF Rating missing"]
["",null,null,null,"SEER Rating",{"$f":"SUSEER","v":0},"Startup Checklist - SEER Rating missing"]
["",null,null,null,"Outdoor Unit Make",{"$f":"IF(SUODUnitMake=\"\",0,SUODUnitMake)","v":0},"Startup Checklist - Outdoor Unit Make missing"]
["",null,null,null,"Outdoor Unit Model",{"$f":"IF('Startup Checklist'!AI12=\"\",0,\"N/A\")","v":0},"Startup Checklist - Outdoor Unit Model # missing"]
["",null,null,null,"# of Compressor stages",{"$f":"IF(AND('Startup Checklist'!$AV$13<>TRUE,'Startup Checklist'!$AO$12:$AT$12=\"\"),0,\"N/A\")","v":0},"Startup Checklist - # of Compressor Stages missing"]
["",null,null,null,"2-Stage vs. Inverter","N/A","Startup Checklist - Heat Pump must be 2-Stage or Inverter Driven if Balance Point is 24F or below"]
["",null,null,null,"Indoor Unit Make",{"$f":"SUIDMake","v":0},"Startup Checklist - Indoor Unit Make missing"]
["",null,null,null,"Indoor Unit Model",{"$f":"SUIDModelNo","v":0},"Startup Checklist - Indoor Unit Model Number missing"]
["",null,null,null,"Outdoor Unit Capacity ",{"$f":"SUODCapacity","v":0},"Startup Checlist - Outdoor Unit Capacity (tons) missing"]
["",null,null,null,"Auxiliary Heat Type",{"$f":"SUAuxHeatType","v":"Electric"},"Startup Checklist - Auxiliary Heat Type missing"]
["",null,null,null,"Backup/Auxiliary Heat Capacity",{"$f":"SUAuxHeatCapacity","v":0},"Startup Checklist - Backup/Auxiliary Heat Capacity (kW) missing"]
["",null,null,null,"Heating or Cooling CFM/Ton",{"$f":"IF(AND('Startup Checklist'!T20:AC20=\"\",'Startup Checklist'!AD20:AL20=\"\"),0,\"N/A\")","v":0},"Startup Checklist - Heating or Cooling CFM/Ton Setting missing"]
["",null,null,null,"Return Static Pressure",{"$f":"SUReturnSP","v":0},"Startup Checklist - Return Static Pressure missing"]
["",null,null,null,"Supply Plenum Static Pressure",{"$f":"SUSupplySP","v":0},"Startup Checklist - Supply Plenum Static Pressure missing"]
["",null,null,null,"Pressure Test Units",{"$f":"SUESPTPressureUnits","v":0},"Startup Checklist - Pressure Test Units missing"]
["",null,null,null,"External Static Pressure",{"$f":"IF(_SUExtSP=\"\",0,\"N/A\")","v":0},"Startup Checklist - External Static Pressure missing"]
["",null,null,null,"Total CFM",{"$f":"SUTotalCFM","v":0},"Startup Checklist - Total CFM missing"]
["",null,null,null,"Air Flow Verification Setting",{"$f":"'Startup Checklist'!$AV$26","v":1},"Startup  Checklist - Air Flow Verification Setting missing"]
["",null,null,null,"ECM Blower",{"$f":"SUECMBlower","v":0},"Startup Checklist - ECM Blower missing"]
["",null,null,null,"Outdoor Air Temperatures",{"$f":"SUOutdoorTemp","v":0},"Startup Checklist - Outdoor Air Temperatures missing"]
["",null,null,null,"Fridge Unit Heating/CoolingTesting Mode",{"$f":"IF(AND(F86=0,SURefriTestingMode=\"\"),0,SURefriTestingMode)","v":0},"Startup Checklist - Unit Testing Mode missing"]
["",null,null,null,"Total Lineset Length",{"$f":"SULinesetLength","v":0},"Startup Checklist - Total Lineset Length missing"]
["",null,null,null,"Refrigerant Units",{"$f":"SURefriUnits","v":0},"Startup Checklist - Refrigerant Units missing"]
["",null,null,null,"Supply Air Temperature Difference",{"$f":"IF(AND(SUSATemp<>\"\",AND(SURATemp<>\"\",(SUSATemp-SURATemp)<0)),0,\"N/A\")","v":"N/A"},"Startup Checklist - Return Air Temperature cannot be greater than Supply Air Temperature "]
["",null,null,null,"Supply Air Temperature",{"$f":"IF(AND(SUOutdoorTemp<>\"\",SUOutdoorTemp<65), SUSATemp, \"N/A\")","v":"N/A"},"Startup Checklist - Supply Air Temperature missing"]
["",null,null,null,"Return Air Temperature",{"$f":"IF(AND(SUOutdoorTemp<>\"\",SUOutdoorTemp<65), SURATemp, \"N/A\")","v":"N/A"},"Startup Checklist - Return Air Temperature missing"]
["",null,null,null,"Temp Split Acceptable",{"$f":"IF(AND(SUOutdoorTemp<>\"\",SUOutdoorTemp<65),SUTempSplit,\"N/A\")","v":"N/A"},"Startup Checklist - Temp Split Acceptable Y/N missing"]
["",null,null,null,"Discharge Pressure",{"$f":"IF(SUOutdoorTemp>65,SUDischargeP,\"N/A\")","v":"N/A"},"Startup Checklist - Discharge Pressure missing"]
["",null,null,null,"Discharge Temperature",{"$f":"IF(SUOutdoorTemp>65,SUDischargeT,\"N/A\")","v":"N/A"},"Startup Checklist - Discharge Temperature [A] missing"]
["",null,null,null,"Liquid Line Temperature",{"$f":"IF(SUOutdoorTemp>65,SULiqLineT,\"N/A\")","v":"N/A"},"Startup Checklist - Liquid Line Temperature [B] missing"]
["",null,null,null,"Subcooling Acceptable",{"$f":"IF(SUOutdoorTemp>65,SUSubcoolingYN,\"N/A\")","v":"N/A"},"Startup Checklist - Subcooling [A] - [B] Acceptable Y/N missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K98<>0,$K98,\"\"),\"\")","v":""},null,null,null,"Indoor Thermostat Make/Model",{"$f":"SUMakeModelIDThermostat","v":0},"Startup Checklist - Make/Model of Indoor Thermostat missing"]
["",null,null,null,"Outdoor Thermostat Location",{"$f":"SUODThermLocation","v":0},"Startup Checklist - Outdoor Thermostat Location missing "]
["",null,null,null,"Aux Heat Lockout",{"$f":"SUAuxHeatLockout","v":0},"Startup Checklist - Auxiliary Heat Lockout missing"]
["",null,null,null,"Aux Heat Lockout Other",{"$f":"IF(SUAuxHeatLockout=\"Other\",SUAuxHeatLockoutOther,\"N/A\")","v":"N/A"},"Startup Checklist - Auxiliary Heat Lockout Other entry missing"]
["",null,null,null,"Contractor Name",{"$f":"SUContractorName","v":0},"Startup Checklist - Contractor Name missing"]
["",null,null,null,"Technician Name",{"$f":"SUTechnicianName","v":0},"Startup Checklist - Technician Name missing"]
["",null,null,null,"Technician Signature",{"$f":"SUTechnicianSignature","v":0},"Startup Checklist - Technician Signature missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K105<>0,$K105,\"\"),\"\")","v":""},null,null,null,"Technician Signature Date",{"$f":"SUCTechSigDate","v":0},"Startup Checklist - Technician Signature Date missing"]
[{"$f":"IF(SubmitCheckTest=TRUE,IF($K106<>0,$K106,\"\"),\"\")","v":""},null,null,null,"Electronic Signature Box",{"$f":"IF('Startup Checklist'!$B$61=FALSE,0)","v":false},"Startup Checklist - Electronic Signature Checkbox missing"]
[null,null,null,null,"Complete",null,"No items missing - you're good to go! Please send this workbook, verification photos and invoice to ce.@snopud.com"]

{"sheet":"Photo Requirements","index":4,"n_rows":114,"n_cols":6,"rows_kept":114,"cut":false,"hidden":false,"merged":[[90,2,90,6],[111,2,111,6],[2,2,2,6],[4,3,5,3],[10,2,10,6],[33,2,33,6]]}
[]
[]
[null,null,{"$f":"_xlfn.SINGLE(BannerText)","v":"Energy Services  ●  ce@snopud.com  ●  www.snopud.com/TAResources"}]
[]
[null,null,null,"Photo Requirements"]
[]
[null,null,null,"For Heating Rebates in Single Family Homes"]
[]
[null,null,null,"Heat Pumps"]
[null,null,"Nameplates for indoor and outdoor installed equipment (outdoor unit, air handler, indoor units)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Installed air handler showing filter (and condensate pump if applicable)"]
[]
[]
[null,null,null,"Installed Air Handler",null,"Installed outdoor unit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Filter grill(s) showing installed filter size and MERV rating (if applicable)"," Air filter and location\t\tInstalled outdoor unit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Condensate Drain - OD condensate termination",null," [If Mitsubishi] Auxiliary Lockout Controller located on air handler"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Air Source thermostat showing outdoor temperature and auxiliary lock out control screen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Duct sealing and insulation [Need PRE and POST condition photos]"]
[]
[]
[null,null,null,"Pre-insulation locations of sealed ducts. (Dovetails, Elbows, Ys)",null,"Two or three locations of insulated ducts wrapped with twine."]

{"sheet":"Process & Requirements","index":5,"n_rows":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[2,2,2,17],[4,2,5,8],[79,2,79,16],[81,2,81,16],[96,2,96,17]]}
[]
[]
[null,null,{"$f":"_xlfn.SINGLE(BannerText)","v":"Energy Services  ●  ce@snopud.com  ●  www.snopud.com/TAResources"}]
[]
[null,null,"Process & Requirements"]
[]
[null,null,"For Window Rebates in Single Family Homes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"If you have questions, please contact Snohomish PUD at CE@SNOPUD.COM"]

{"sheet":"LookUps","index":6,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":true,"merged":[[9,4,9,5],[0,16,0,17],[0,18,0,20],[0,4,0,5],[0,2,0,3],[0,8,0,9],[0,10,0,11],[0,12,0,13],[0,14,0,15]]}
["City","Outdoor Design T","Windows",null,"Doors",null,"Attic/Ceiling",null,"Above Grade Walls",null,"Floors",null,"Below Grade Walls",null,"Slab Below Grade",null,"Slab On Grade",null,"Duct Sizing"]
["Arlington",19,"R-Value","U-Factor","R-Value","U-Factor","R-Value","U-Factor","R-Value","U-Factor","R-Value","U-Factor","R-Value","U-Factor","R-Value","F-Factor","R-Value","F-Factor","Size","Supply Side CFM","Return Side CFM"]
["Bothell",21,"Single Pane - Wood Frame",0.96,"Wood Slab in Wood Frame",0.46,"Attic R-7",0.108,"R-0",0.217,"Vented Crawlspace R-0",0.13400000000000001,"2' Below Grade Uninsulated",0.35,{"$f":"M3","v":"2' Below Grade Uninsulated"},0.59,"R-10 ",0.54,"Round 6\"",100,80]
["Brier",21,"Single Pane - Metal Frame",1.1000000000000001,"Wood 25% Glazed-Single",0.57999999999999996,"Attic R-11",8.3000000000000004E-2,"R-7",9.8000000000000004E-2,"Vented Crawlspace R-7",6.9000000000000006E-2,"2' Below Grade R-11 Interior",6.6000000000000003E-2,{"$f":"M4","v":"2' Below Grade R-11 Interior"},0.68,"Uninsulated",0.73,"Round 8\"",200,160]
["Camano Island",22,"Double Pane - Metal Frame",0.75,"Wood 25% Glazed-Double",0.48,"Attic R-15",6.9000000000000006E-2,"R-11",8.3000000000000004E-2,"Vented Crawlspace R-11",5.6000000000000001E-2,"2' Below Grade R-19 Interior",4.2999999999999997E-2,"2' Below Grade R-19 Interior",0.69,null,null,"Round 10\"",360,290]
["Darrington",15,"Double Pane Vinyl or Wood Frame-Clear Glass",0.55000000000000004,"Steel 25% Glazed-Single",0.39,"Attic R-19",4.9000000000000002E-2,"R-19",5.3999999999999999E-2,"Vented Crawlspace R-19",4.1000000000000002E-2,"2' Below Grade R-21 Interior",0.04,"2' Below Grade R-21 Interior",0.68,null,null,"Round 12\"",600,460]
["Edmonds",21,"Double Pane Vinyl or Wood Frame-Low E Glass",0.4,"Steel 25% Glazed-Double",0.28000000000000003,"Attic R-30",3.5999999999999997E-2,"R-21",5.6000000000000001E-2,"Vented Crawlspace R-22",3.6999999999999998E-2,"3.5' Below Grade Uninsulated",0.27800000000000002,"3.5' Below Grade Uninsulated",0.53,null,null,"Round 14\"",900,700]
["Everett",22,"NFRC Rated .22",0.22,"Steel Panel ",0.19,"Attic R-38",3.1E-2,null,null,"Vented Crawlspace R-25",3.4000000000000002E-2,"3.5' Below Grade R-11 Interior",6.2E-2,"3.5' Below Grade R-11 Interior",0.63,null,null,"Round 16\"",1300,1000]
["Everett South (Paine Field)",21,"NFRC Rated .25",0.25,null,null,"Attic R-49",2.7E-2,null,null,"Vented Crawlspace R-30",2.9000000000000001E-2,"3.5' Below Grade R-19 Interior",4.1000000000000002E-2,"3.5' Below Grade R-19 Interior",0.64,null,null,"Round 18\"",1700,1300]
["Gold Bar",21,"NFRC Rated .30",0.3,"Skylights",null,"Attic R-60",2.5000000000000001E-2,null,null,"Vented Crawlspace R-38",2.5000000000000001E-2,"3.5' Below Grade R-21 Interior",3.7999999999999999E-2,"3.5' Below Grade R-21 Interior",0.63,null,null,"Round 20\"",2300,1800]
["Granite Falls",21,null,null,"Standard Skylight",0.5,"Scissors Truss R-11 (4/12 roof pitch)",6.9000000000000006E-2,null,null,"Exposed R-11 ",8.7999999999999995E-2,"7' Below Grade Uninsulated",0.193,"7' Below Grade Uninsulated",0.46,null,null,"7x10",300,230]
["Index",21,"Heating System Type","?",null,null,"Scissors Truss R-19 (4/12 roof pitch)",4.7E-2,null,null,"Exposed R-15 ",7.5999999999999998E-2,"7' Below Grade R-11 Interior",5.3999999999999999E-2,"7' Below Grade R-11 Interior",0.56000000000000005,null,null,"7x12",360,290]
["Lake Stevens",21,"Forced Air Furnace",1.4,null,null,"Scissors Truss R-30 (4/12 roof pitch)",4.2999999999999997E-2,null,null,"Exposed R-19 ",6.2E-2,"7' Below Grade R-19 Interior",3.6999999999999998E-2,"7' Below Grade R-19 Interior",0.56999999999999995,null,null,"7x14",440,320]
["Lynnwood",21,"Heat Pump",1.25,null,null,"Scissors Truss R-38 (4/12 roof pitch)",0.04,null,null,"Exposed R-21 ",5.7000000000000002E-2,"7' Below Grade R-21 Interior",3.5000000000000003E-2,"7' Below Grade R-21 Interior",0.56000000000000005,null,null,"7x16",520,420]
["Marysville",21,null,null,null,null,"Scissors Truss R-49 (4/12 roof pitch)",3.7999999999999999E-2,null,null,"Exposed R-25 ",5.0999999999999997E-2,null,null,null,null,null,null,"7x18",600,460]
["Mill Creek",21,"Heat Pump Rebate","Amount","Requirement",null,"Scissors Truss R-11 (5/12 roof pitch)",6.7000000000000004E-2,null,null,"Exposed R-30 ",0.04,null,null,"From original form",null,null,null,"7x20",670,520]
["Monroe",20,"Inverter-Driven Ducted Heat Pump/Conversion - Sized",2500,"Must have minimum HSPF 2 8.5 and SEER 2 13.8. ",null,"Scissors Truss R-19 (5/12 roof pitch)",4.4999999999999998E-2,null,null,"Exposed R-38 ",3.4000000000000002E-2,null,null,"  2' Depth",0.59,null,null,"8x10",360,290]
["Mountlake Terrace",21,"Ducted Heat Pump/Conversion - Sized",1800,"Must have minimum HSPF 2 7.5 and SEER 2 13.8.",null,"Scissors Truss R-30 (5/12 roof pitch)",3.7999999999999999E-2,null,null,"Unheated Bsmt and FOG use Vented Crawlspace Values","-",null,null,"3.5' Depth",0.64,null,null,"8x12",440,320]
["Mukilteo",21,null,null,null,null,"Scissors Truss R-38 (5/12 roof pitch)",3.5000000000000003E-2,null,null,"Heated Plen= Heated Bsmt, add vol & BG walls to load calc","-",null,null,"7' Depth",0.56999999999999995,null,null,"8x14",520,420]
["Oso",19,"Duct Sealing/Insulation Rebate","Amount",null,null,"Scissors Truss R-49 (5/12 roof pitch)",3.2000000000000001E-2,null,null,null,null,null,null,null,null,null,null,"8x16",600,460]
["Snohomish",21,"Standard Construction Home",{"$f":"IF(Application!R38*5>450,450,Application!R38*5)","v":0},null,null,"Vault Vented R-11 2x8 joist",0.06,null,null,null,null,null,null,null,null,null,null,"8x18",720,580]
["Stanwood",19,"Manufactured Home: Single Wide",200,null,null,"Vault Vented R-19 2x10 joist",4.9000000000000002E-2,null,null,null,null,null,null,null,null,null,null,"8x20",800,640]
["Startup",21,"Manufactured Home: Double/Triple Wide",400,null,null,"Vault Vented R-30 2x12 joist",3.4000000000000002E-2,null,null,null,null,null,null,null,null,null,null,"10x10",480,360]
["Sultan",21,null,null,null,null,"Vault Vented R-38 2x14 joist",2.7E-2,null,null,null,null,null,null,null,null,null,null,"10x12",600,460]
["Woodway",21,"City N/A Checker for Sizing Calculator",null,null,null,"Vault Unvented R-30 2x10 joist",3.4000000000000002E-2,null,null,null,null,null,null,null,null,null,null,"10x14",720,580]
[null,null,{"$f":"VLOOKUP(SCDesignCity,Cities_Lookup,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Vault Unvented R-38 2x12 joist",2.9000000000000001E-2,null,null,null,null,null,null,null,null,null,null,"10x16",900,700]
["Infiltration Level","U-Factor",null,null,null,null,"Vault Unvented R-21 + R-21 2x12 joist",2.5999999999999999E-2,null,null,null,null,null,null,null,null,null,null,"10x18",1000,780]
["Tight",0.35,"Thermostat Rebate",null,null,null,"Roof Deck R-12.5",6.4000000000000001E-2,null,null,null,null,null,null,null,null,null,null,"10x20",1120,880]
["Normal",0.5,"Advanced Smart Thermostat Direct Install",200,"Must be on Residential Advanced Smart Thermostat Qualified Products List",null,"Roof Deck R-21.9",0.04,null,null,null,null,null,null,null,null,null,null,"12x12",780,600]
["Leaky",0.65,null,null,null,null,"Roof Deck R-37",2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,"12x14",600,460]
["Very Leaky",0.75,null,null,null,null,"Roof Deck R-50",1.9E-2,null,null,null,null,null,null,null,null,null,null,"12x16",1120,880]
[null,null,"Rebate Options",null,"Startup Checklist",null,null,null,null,null,null,null,null,null,null,null,null,null,"12x18",1300,1000]
["% Ducts in Unheated Space",null,"Instant Rebate (provided on the PUD Registered Trade Ally's invoice) and authorize the PUD to pay the PUD Registered Trade Ally, in my name, the rebate(s) due to me",null,"Units",null,null,null,null,null,null,null,null,null,null,null,null,null,"12x20",1500,1125]
[0,null,"Credit to my PUD utility account, which may take up to six (6) weeks for processing",null,"PA",null,null,null,null,null,null,null,null,null,null,null,null,null,"12x24",1700,1300]
[0.25,null,null,null,"inches H2O"]
[0.5]
[0.75,null,null,null,"Metering Plate Size"]
[1,null,null,null,"#14"]
[null,null,null,null,"#20"]
[]
[null,null,null,null,"Filter Location"]
[null,null,null,null,"Air Handler"]
[null,null,null,null,"Return Grille"]
[null,null,null,null,"Other"]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[]
[null,null,null,null,"Testing Mode"]
[null,null,null,null,"Heating"]
[null,null,null,null,"Cooling"]
[]
[null,null,null,null,"Stage/Capacity Tested"]
[null,null,null,null,"High"]
[null,null,null,null,"Low"]
[null,null,null,null,"Other (specify)"]
[]
[null,null,null,null,"Lockout Temperature"]
[null,null,null,null,"30°F"]
[null,null,null,null,"35°F"]
[null,null,null,null,"Other (specify)"]

{"sheet":"WSEC Comparison","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Windows","Original (2015)",2018]
["R-Value","U-Factor","U-Factor"]
["Single Pane - Wood Frame",0.96,1.18]
["Single Pane - Metal Frame",1.1000000000000001,1.58]
["Double Pane - Metal Frame",0.75,1.05]
["Double Pane Vinyl or Wood Frame-Clear Glass",0.55000000000000004,0.84,0.67]
["Double Pane Vinyl or Wood Frame-Low E Glass",0.4,0.73,0.56000000000000005]
["NFRC Rated .22",0.22,"-","-"]
["NFRC Rated .25",0.25,"-","-"]
["NFRC Rated .30",0.3,"-","-"]

{"sheet":"Area Calculator","index":8,"n_rows":32,"n_cols":46,"rows_kept":32,"cut":false,"hidden":true,"merged":[[40,15,40,18],[41,15,41,18],[42,15,42,18],[43,15,43,18],[44,15,44,18],[0,0,2,3],[23,0,24,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[43,0,43,3],[44,0,44,3],[5,0,5,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[31,15,31,18],[32,15,32,18],[33,15,33,18],[34,15,34,18],[35,15,35,18],[36,15,36,18],[37,15,37,18],[38,15,38,18],[39,15,39,18],[31,5,31,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[35,5,35,7],[36,10,36,13],[37,10,37,13],[38,10,38,13],[39,10,39,13],[31,10,31,13],[32,10,32,13],[33,10,33,13],[34,10,34,13],[35,10,35,13],[36,5,36,7],[37,5,37,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[40,10,40,13],[46,10,46,13],[47,10,47,13],[48,10,48,13],[41,10,41,13],[42,10,42,13],[43,10,43,13],[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[41,5,41,7],[42,5,42,7],[43,5,43,7],[44,10,44,13],[45,10,45,13],[46,15,46,18],[47,15,47,18],[48,15,48,18],[45,15,45,18],[47,5,47,7],[48,5,48,7],[44,5,44,7],[45,5,45,7],[46,5,46,7],[35,25,35,26],[36,25,36,26],[37,25,37,26],[38,25,38,26],[39,25,39,26],[30,25,30,26],[31,25,31,26],[32,25,32,26],[33,25,33,26],[34,25,34,26],[45,25,45,26],[46,25,46,26],[47,25,47,26],[48,25,48,26],[40,25,40,26],[41,25,41,26],[42,25,42,26],[43,25,43,26],[44,25,44,26],[19,36,19,37],[20,36,20,37],[21,36,21,37],[15,36,15,37],[16,36,16,37],[20,33,20,34],[21,33,21,34],[30,5,30,7],[30,10,30,13],[30,15,30,18],[5,39,5,41],[5,43,5,45],[15,33,15,34],[16,33,16,34],[17,33,17,34],[18,33,18,34],[19,33,19,34],[10,33,10,34],[11,33,11,34],[12,33,12,34],[13,33,13,34],[14,33,14,34],[5,36,5,37],[6,36,6,37],[7,36,7,37],[8,36,8,37],[9,36,9,37],[10,36,10,37],[11,36,11,37],[12,36,12,37],[13,36,13,37],[14,36,14,37],[17,36,17,37],[18,36,18,37],[5,15,5,18],[5,20,5,23],[5,5,5,8],[5,10,5,13],[5,33,5,34],[6,33,6,34],[7,33,7,34],[8,33,8,34],[9,33,9,34],[5,25,5,27],[5,29,5,31]]}
["Above Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ceiling Ht (ft)",null,null,"Ceiling Ht (ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Windows Area (ft2)",null,null,"Windows Area (ft2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight Area (ft2)",null,null,null,"Skylight Area (ft2)",null,null,null,"Doors Area (ft2)",null,null,"Doors Area (ft2)"]
["Windows 1 Area (ft2)",{"$f":"IF(SUM(D8:D22)=0,\"\",ROUND(SUM(D8:D22),0))","v":""},null,null,null,"Windows 2 Area (ft2)",{"$f":"IF(SUM(I7:I22)=0,\"\",ROUND(SUM(I7:I22),0))","v":""},null,null,null,"Skylight Area (ft2)",{"$f":"IF(SUM(N7:N22)=0,\"\",ROUND(SUM(N7:N22),0))","v":""},null,null,null,"Doors 1 Area (ft2)",{"$f":"IF(SUM(S7:S22)=0,\"\",ROUND(SUM(S7:S22),0))","v":""},null,null,null,"Doors 2 Area (ft2)",{"$f":"IF(SUM(X7:X22)=0,\"\",ROUND(SUM(X7:X22),0))","v":""},null,null,null,"Attic 1 Area (ft2)",{"$f":"IF(SUM(AB7:AB22)=0,\"\",ROUND(SUM(AB7:AB22)-AA4,0))","v":""},null,null,"Attic 2 Area (ft2)",{"$f":"IF(SUM(AF7:AF22)=0,\"\",ROUND(SUM(AF7:AF22)-AE4,0))","v":""},null,null,"Above Grade Walls 1 Area (ft2)",{"$f":"IF(SUM(AH8:AH22)=0,\"\",ROUND((SUM(AH8:AH22)*AI2)-AI3-AI4,0))","v":""},null,"Above Grade Walls 2 Area (ft2)",{"$f":"IF(SUM(AK8:AK22)=0,\"\",ROUND((SUM(AK8:AK22)*AL2)-AL3-AL4,0))","v":""},null,"Floors 1 Area (ft2)",{"$f":"IF(SUM(AP7:AP22)=0,\"\",ROUND(SUM(AP7:AP22),0))","v":""},null,null,"Floors 2 Area (ft2)",{"$f":"IF(SUM(AT7:AT22)=0,\"\",ROUND(SUM(AT7:AT22),0))","v":""}]
["Windows Type 1",null,null,null,null,"Windows Type 2",null,null,null,null,"Skylight",null,null,null,null,"Doors Type 1",null,null,null,null,"Doors Type 2",null,null,null,null,"Attic Type 1",null,null,null,"Attic Type 2",null,null,null,"Above Grade Walls Type 1",null,null,"Above Grade Walls Type 2",null,null,"Floors Type 1",null,null,null,"Floors Type 2"]
["Width (ft)","Height (ft)","Qty","Area (ft2)",null,"Width (ft)","Height (ft)","Qty","Area (ft2)",null,"Width (ft)","Height (ft)","Qty","Area (ft2)",null,"Width (ft)","Height (ft)","Qty","Area (ft2)",null,"Width (ft)","Height (ft)","Qty","Area (ft2)",null,"Length 1 (ft)","Length 2 (ft)","Area (ft2)",null,"Length 1 (ft)","Length 2 (ft)","Area (ft2)",null,"Wall Perimeter (ft)",null,null,"Wall Perimeter (ft)",null,null,"Length 1 (ft)","Length 2 (ft)","Area (ft2)",null,"Length 1 (ft)","Length 2 (ft)","Area (ft2)"]
[null,null,null,{"$f":"IF(OR(A8=0,OR(B8=0,C8=\"\")),\"\",A8*B8*C8)","v":""},null,null,null,null,{"$f":"IF(OR(F8=0,OR(G8=0,H8=\"\")),\"\",F8*G8*H8)","v":""},null,null,null,null,{"$f":"IF(OR(K8=0,OR(L8=0,M8=\"\")),\"\",K8*L8*M8)","v":""},null,null,null,null,{"$f":"IF(OR(P8=0,OR(Q8=0,R8=\"\")),\"\",P8*Q8*R8)","v":""},null,null,null,null,{"$f":"IF(OR(U8=0,OR(V8=0,W8=\"\")),\"\",U8*V8*W8)","v":""},null,null,null,{"$f":"IF(OR(Z8=0,AA8=0),\"\",Z8*AA8)","v":""},null,null,null,{"$f":"IF(OR(AD8=0,AE8=0),\"\",AD8*AE8)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AN8=0,AO8=0),\"\",AN8*AO8)","v":""},null,null,null,{"$f":"IF(OR(AR8=0,AS8=0),\"\",AR8*AS8)","v":""}]
[null,null,null,{"$f":"IF(OR(A9=0,OR(B9=0,C9=\"\")),\"\",A9*B9*C9)","v":""},null,null,null,null,{"$f":"IF(OR(F9=0,OR(G9=0,H9=\"\")),\"\",F9*G9*H9)","v":""},null,null,null,null,{"$f":"IF(OR(K9=0,OR(L9=0,M9=\"\")),\"\",K9*L9*M9)","v":""},null,null,null,null,{"$f":"IF(OR(P9=0,OR(Q9=0,R9=\"\")),\"\",P9*Q9*R9)","v":""},null,null,null,null,{"$f":"IF(OR(U9=0,OR(V9=0,W9=\"\")),\"\",U9*V9*W9)","v":""},null,null,null,{"$f":"IF(OR(Z9=0,AA9=0),\"\",Z9*AA9)","v":""},null,null,null,{"$f":"IF(OR(AD9=0,AE9=0),\"\",AD9*AE9)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AN9=0,AO9=0),\"\",AN9*AO9)","v":""},null,null,null,{"$f":"IF(OR(AR9=0,AS9=0),\"\",AR9*AS9)","v":""}]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[]
["Below Grade"]
[]
[]
["Ceiling Ht (ft)",null,null,null,null,"Ceiling Ht (ft)"]
["Windows Area (ft2)",null,null,null,null,"Windows Area (ft2)"]
["Doors Area (ft2)",null,null,null,null,"Doors Area (ft2)"]
["Below Grade Walls 1 Area (ft2)",{"$f":"IF(SUM(A33:A49)=0,\"\",ROUND((SUM(A33:A49)*B27)-B28-B29,0))","v":""},null,null,null,"Below Grade Walls 2 Area (ft2)",{"$f":"IF(SUM(F33:F49)=0,\"\",ROUND((SUM(F33:F49)*G27)-G28-G29,0))","v":""},null,null,null,"Slab Below Grade 1 Length (ft)",{"$f":"IF(SUM(K33:L49)=0,\"\",SUM(K33:L49))","v":""},null,null,null,"Slab Below Grade 2 Length (ft)",{"$f":"IF(SUM(P33:Q49)=0,\"\",SUM(P33:Q49))","v":""},null,null,null,null,null,null,null,null,"Slab on Grade Length (ft)",{"$f":"IF(SUM(Z33:AA49)=0,\"\",SUM(Z33:AA49))","v":""}]
["Below Grade Walls Type 1",null,null,null,null,"Below Grade Walls Type 2",null,null,null,null,"Slab Below Grade Type 1",null,null,null,null,"Slab Below Grade Type 2",null,null,null,null,null,null,null,null,null,"Slab on Grade"]
["Wall Perimeter (ft)",null,null,null,null,"Wall Perimeter (ft)",null,null,null,null,"Wall Perimeter (ft)",null,null,null,null,"Wall Perimeter (ft)",null,null,null,null,null,null,null,null,null,"Wall Perimeter (ft)"]

{"sheet":"Calcs_Heat Loss","index":9,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[8,0,8,2],[18,0,18,2],[0,0,0,3]]}
["System Info"]
["UA Sum",{"$f":"SUM('Sizing Calculator'!G21:G45) +SUM('Sizing Calculator'!K21:K43)","v":0}]
["Envelope Heat Load ",{"$f":"B2*'Sizing Calculator'!E14","v":{"$error":"#VALUE!"}},"BTU","[UA Sum *Delta T)"]
["Air Leakage Heat Load",{"$f":"'Sizing Calculator'!H14*VLOOKUP('Sizing Calculator'!K14, Infiltration_Lookup,2,0)*'Sizing Calculator'!E14*0.018","v":{"$error":"#VALUE!"}},"BTU","[Delta T*Volume*Infiltration U-Factor*0.018)"]
["Building Heat Load",{"$f":"B4+B3","v":{"$error":"#VALUE!"}},"BTU","[Air Leakage + Envelope Heat Load]"]
["Duct Heat Load",{"$f":"B5*0.08*'Sizing Calculator'!I14","v":{"$error":"#VALUE!"}},"BTU","[Building Heat Load *.08*Ducts in Unconditioned Space ]"]
["Design Heat Load",{"$f":"B6+B5","v":{"$error":"#VALUE!"}},"BTU","[Building and Duct Heat Loss *1.25 for Heat Pump]"]
[]
["Design Heat"]
["Design Heat T1",20,"°F"]
["Design Heat BTU1",{"$f":"B7","v":{"$error":"#VALUE!"}},"BTU"]
["Design Heat Max T2",70,"°F","*Indoor Design Temperature"]
["Design Heat BTU2",0,"BTU"]
["Design Heat Delta BTU (∆Y)",{"$f":"B13-B11","v":{"$error":"#VALUE!"}},"BTU"]
["Design Heat Delta T (∆X)",{"$f":"B12-B10","v":50},"°F"]
["Design Heat Slope (∆Y/∆X)",{"$f":"B14/B15","v":{"$error":"#VALUE!"}},"BTU/°F"]
["Y Intercept (b)",{"$f":"B11-(B16*B10)","v":{"$error":"#VALUE!"}}]
[]
["Heat Pump"]
["Heat Pump T1",17,"°F"]
["Heat Pump BTU1",{"$f":"'Sizing Calculator'!H51","v":0},"BTU"]
["Heat Pump Max T2",47,"°F"]
["Heat Pump Max BTU2",{"$f":"'Sizing Calculator'!I51","v":0},"BTU"]
["Heat Pump Delta BTU (∆Y)",{"$f":"B23-B21","v":0},"BTU"]
["Heat Pump Delta T (∆X)",{"$f":"B22-B20","v":30},"°F"]
["Heat Pump Slope (∆Y/∆X)",{"$f":"B24/B25","v":0},"BTU/°F"]
["Y Intercept (b)",{"$f":"B21-(B26*B20)","v":0}]
[]
["Balance Point",{"$f":"(B27-B17)/(B16-B26)","v":{"$error":"#VALUE!"}}]

{"sheet":"Insulation Tables","index":10,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,1,24,3],[3,1,3,8],[5,3,5,5],[14,1,14,8],[15,6,22,8]]}
[]
[]
[]
[null,"SITE BUILT HOMES"]
[null,"Year Built","Glazing U-Value","Ceiling","Vaulted Ceiling","Wall Above Grade","Wall Below Grade","Floor","Slab on Grade"]
[null,"Pre-1970",1.2,"Need to verify",null,null,"R-0","R-0","R-0"]
[null,"1970-1977",1.2,"R-11","R-11","R-7","R-0","R-0","R-0"]
[null,"1977-1980",1.2,"R-19","R-11","R-11","R-0","R-0","R-0"]
[null,"1980-1986",0.75,"R-30","R-19","R-11","R-11","R-11","R-0"]
[null,"1987-1990",0.5,"R-38","R-30","R-19","R-19","R-19","R-0"]
[null,"1991-2002",0.4,"R-38","R-30","R-19","R-19","R-30","R-10"]
[null,"2003-2011",0.4,"R-38","R-30","R-21","R-21","R-30","R-10"]
[null,"2012-current",0.3,"R-49","R-49","R-21","R-21","R-30","R-10"]
[]
[null,"MANUFACTURED HOMES"]
[null,"Year Built","Glazing U-Value","Ceiling","Wall","Floor"," The insulation tables are based on the age of the home, but note that these are guidelines only, and may not accurately reflect your customer’s home. All insulation levels should be verified."]
[null,1968,1.2,"R-7","R-7","R-7"]
[null,1978,1.2,"R-11","R-7","R-7"]
[null,1984,1.2,"R-15","R-11","R-11"]
[null,1988,0.75,"R-19","R-11","R-11"]
[null,1991,0.75,"R-30","R-19","R-19"]
[null,1997,0.5,"R-30","R-19","R-19"]
[null,"ENERGY STAR",0.35,"R-49","R-21","R-38"]
[]
[null,"Revision Date 08/22/2022"]

{"sheet":"City Temp Data","index":11,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["City Name","Source Location Name","Design Temp","Source",null,"ASHRAE Location","2017 99% Heating Temp","Source"]
["Arlington","Arlington",19,"NOAA",null,"Arlington Municipal",24.5,"ASHRAE climatic design conditions 2009/2013/2017 (ashrae-meteo.info)"]
["Bothell","Bothell 2 N",21,"NOAA",null,"Darrington 21 NNE",24.7,"ASHRAE climatic design conditions 2009/2013/2017 (ashrae-meteo.info)"]
["Brier","Snohomish County",21,"SBCC",null,"Paine Field (Everett)",28.9,"ASHRAE climatic design conditions 2009/2013/2017 (ashrae-meteo.info)"]
["Camano Island","Coupeville 1 S",22,"NOAA"]
["Darrington","Darrington RS",15,"NOAA",null,"SBCC Location","2018 99% Heating Temp","Source"]
["Edmonds","Snohomish County",21,"SBCC",null,"Snohomish County ",21,"2018 WSEC_R Final package2.pdf (wa.gov)"]
["Everett","Everett JC",22,"NOAA",null,"Darrington RS",13]
["Everett South (Paine Field)","Everett Paine AFB",21,"SBCC",null,"Edmonds",24,"state building code council"]
["Gold Bar","Startup",21,"NOAA",null,"Everett Paine AFB",21]
["Granite Falls","Snohomish County",21,"SBCC",null,"Marysville",23]
["Index","Baring/Startup",21,"NOAA"]
["Lynnwood","Snohomish County",21,"SBCC",null,"Energy Star Location","2019 99% Heating Temp","Source"]
["Marysville","Snohomish County",21,"SBCC",null,"Snohomish County",24,"Design Temperature Limit Reference Guide (2019 Edition)_ENERGY STAR Single-Family New Homes_Rev11"]
["Monroe","Monroe",20,"NOAA"]
["Mountlake Terrace","Snohomish County",21,"SBCC"]
["Oso","Arlington",19,"NOAA",null,"NOAA Location","Avg Extreme Minimum Dec/Jan/Feb"]
["Snohomish","Snohomish County",21,"SBCC",null,"Arlington",18.663333333333334,"https://wrcc.dri.edu/cgi-bin/cliMAIN.pl?wa0257"]
["Stanwood","Arlington",19,"NOAA",null,"Darrington RS",14.833333333333334,"https://wrcc.dri.edu/cgi-bin/cliMAIN.pl?wa1992"]
["Startup","Startup",21,"NOAA",null,"Everett JC",21.526666666666671]
["Sultan","Startup",21,"NOAA",null,"Bothell 2 N",16.98]
[null,null,null,null,null,"Coupeville 1 S",22.290000000000003]
[null,null,null,null,null,"Monroe",19.959999999999997]
[null,null,null,null,null,"Startup",21.393333333333334]
[null,null,null,null,null,"Index","-"]
[]
[null,null,null,null,null,null,"= source used in table"]

{"sheet":"NOAA Temp Data","index":12,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual","Lowest Extreme Min","Average Extreme Min"]
["Arlington",17.53,20.53,24.36,29.29,33.44,39.200000000000003,43.13,43.81,36.380000000000003,28.94,20.53,17.93,12.3,{"$f":"MIN(B2:C2,M2)","v":17.53},{"$f":"AVERAGE(B2,C2,M2)","v":18.663333333333334}]
["Darrington RS",12.5,18.14,23.08,28.12,32,38.56,41.16,41.42,35.799999999999997,28.46,21.34,13.86,7.47,12.5,14.833333333333334]
["Everett JC",19.8,23.32,27.32,31.58,36.51,43.18,46.02,45.45,38.58,31.65,25.49,21.46,14.52,19.8,21.526666666666671]
["Bothell 2 N",13.32,18.399999999999999,22.96,26.7,30.6,36.32,39.22,39.17,32.33,28.57,22.08,19.22,6.83,13.32,16.98]
["Coupeville 1 S",20.57,23.64,27.35,31.7,36.78,41.49,44.54,44.27,38.549999999999997,32.590000000000003,25.78,22.66,15.54,20.57,22.290000000000003]
["Monroe",18.2,21.48,25.35,30.04,34.880000000000003,41.18,44.31,44.03,37.94,30.62,23.56,20.2,12.63,18.2,19.959999999999997]
["Startup",20.09,22.94,26.45,30.14,33.96,39.340000000000003,42.48,42.1,37.479999999999997,30.36,24.93,21.15,14.91,20.09,21.393333333333334]
["Index","-","-",null,null,null,null,null,null,null,null,null,"-",null,"-","-"]