{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Process & Requirements","Application","Photo Requirements","Total Glazing Calculator","Dropdowns"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":33,"comments":2,"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":"Process & Requirements","index":0,"n_rows":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[79,2,79,16],[81,2,81,16],[96,2,96,17],[2,2,2,17],[4,2,5,8]]}
[]
[]
[null,null,{"$f":"BannerText","v":"\nEnergy Services  ●  ce@snopud.com  ●  www.snopud.com"}]
[]
[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":"Application","index":1,"n_rows":56,"n_cols":21,"rows_kept":56,"cut":false,"hidden":false,"merged":[[33,4,34,5],[55,3,56,16],[52,6,52,8],[43,11,43,12],[42,4,42,6],[42,7,42,8],[42,13,42,14],[43,4,43,6],[43,7,43,8],[43,9,43,10],[43,13,43,14],[4,4,5,8],[2,3,2,16],[41,12,41,13],[40,8,40,11],[41,8,41,11],[41,4,41,7],[17,4,17,7],[17,8,17,9],[15,8,15,11],[17,10,17,13],[29,9,29,10],[31,4,31,6],[33,13,33,14],[15,12,15,13],[13,12,13,13],[35,4,36,15],[52,41,52,44],[52,9,52,12],[40,12,40,13],[48,4,49,15],[50,4,50,15],[40,4,40,7],[32,9,32,10],[25,5,25,10],[15,4,15,7],[29,11,29,12],[30,11,30,12],[19,10,19,12],[26,12,26,15],[19,13,19,14],[30,4,30,6],[29,13,29,14],[31,13,31,14],[30,9,30,10],[31,9,31,10],[31,11,31,12],[30,13,30,14],[7,4,7,12],[8,4,8,10],[13,8,13,11],[29,4,29,6],[19,8,19,9],[19,4,19,6],[18,4,18,6],[13,4,13,7],[25,12,25,15],[24,12,24,15],[17,14,17,15]]}
[]
[null,"Windows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V"]
[null,null,null,"\nEnergy Services  ●  ce@snopud.com  ●  www.snopud.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Feb 24"]
[]
[null,null,null,null,"Application"]
[]
[null,null,null,null,"For Window Rebates in Single Family Homes"]
[null,null,null,null,"• $50 per Window (Double Pane Metal Frame to Double Pane)"]
[null,null,null,null,"• $100 per Window (Single Pane to Double Pane)"]
[]
[null,null,null,null,"Customer Information"]
[]
[null,null,null,null,"Homeowner Name",null,null,null,"Installation Address",null,null,null,"City",null,"State","Zip Code"]
[]
[null,null,null,null,"Email Address",null,null,null,"Mailing Address (check if same as above)",null,null,null,"City",null,"State","Zip Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,"Phone Number (with area code)",null,null,null,"Preferred Contact Method",null,"Contact Person (if not homeowner)",null,null,null,"Contact Person Phone Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lake Stevens Test"]
[null,null,null,null,"# of Dwellings",null,null,"Year Built","Residence Type",null,"Home Type",null,null,"Existing Primary Electric Heat Source",null,"Water Heater",null,null,"=IF(M14=\"lake stevens\", TRUE, FALSE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=IF(S19=TRUE,1.25,1)"]
[]
[null,null,null,null,"Pre-Installation Conditions",null,null,null,null,null,null,"Post-Installation Conditions",null,null,null,null,null,null,null,"23-30","22-"]
[null,null,null,null,"• Single Family Home - maximum 4 attached dwellings, includes:",null,null,null,null,null,null,"•","Installation must meet PUD Weatherization Specifications",null,null,null,null,null,"Single Pane to Double Pane",100,130]
[null,null,null,null,"- Townhouses*, ADUs, Manufactured Homes",null,null,null,null,null,null,"• NFRC rated windows must have a U-Value of 0.30 or lower (submit NFRC lable or manufacturer's packing slip to PUD with this application)","NFRC rated windows must have a U-Value of 0.30 or lower (submit NFRC",null,null,null,null,null,"Double Pane Metal Frame to Double Pane",50,65]
[null,null,null,null,null,"*A townhouse shares walls but does not vertically overlap with other units, \nand it is not subject to the number of attached units cap.",null,null,null,null,null,null,"label or manufacturer's packing slip with U-Value listed with this application)"]
[null,null,null,null,"• Permanently installed electric heat",null,null,null,null,null,null,"•","Non-NFRC rated (ex. Skylights and Garden Windows) must have best available U-Value"]
[]
[null,null,null,null,null,"Rebates and Savings",null,null,null,null,null,null,null,null,null,null,null,null,"U Values"]
[null,null,null,null,"Window Type","Column1","Column2","U-Value","No. of Windows","Total Glazing Square Footage",null,"Installed Cost",null,"Rebate per Window",null,{"$f":"IF(S29=TRUE,\"Total Rebate with BONUS*\",\"Total Rebate*\")","v":"Total Rebate*"},null,null,"<= 0.22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E31<>\"\",IF(H31=\"<= 0.22\",IF(LEFT(E31,1) = \"S\",U24,IF(LEFT(E31,1)=\"D\",U25,\"\")),IF(H31=\"0.23-0.30\",IF(LEFT(E31,1)=\"S\", T24, IF(LEFT(E31,1)=\"D\",T25,\"\")),S32)),\"\")","v":""},null,{"$f":"IFERROR(IF(J31=\"\",\"\",I31*N31),\"\")","v":""},null,null,"0.23-0.30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E32<>\"\",IF(H32=\"<= 0.22\",IF(LEFT(E32,1) = \"S\",U24,IF(LEFT(E32,1)=\"D\",U25,\"\")),IF(H32=\"0.23-0.30\",IF(LEFT(E32,1)=\"S\", T24, IF(LEFT(E32,1)=\"D\",T25,\"\")),S33)),\"\")","v":""},null,{"$f":"IFERROR(IF(J32=\"\",\"\",I32*N32),\"\")","v":""},null,null,{"$f":"IF(LEFT(E31,1)=\"S\",100,IF(LEFT(E31,1)=\"D\",50,\"\"))","v":""}]
[null,null,null,null,null,null,null,"Total:",{"$f":"IF(SUM(H31:I32)=0,\"\",SUM(H31:I32))","v":""},{"$f":"IF(SUM(InputTableWindows)=0,\"\",SUM(InputTableWindows))","v":""},null,null,null,null,"Total: ",{"$f":"IF(SUM(InputTableRebates)=0,\"\",IF(N44=\"\",SUM(InputTableRebates),IF(N44<SUM(InputTableRebates),N44,SUM(InputTableRebates))))","v":""},null,null,{"$f":"IF(LEFT(E32,1)=\"S\",100,IF(LEFT(E32,1)=\"D\",50,\"\"))","v":""}]
[null,null,null,null,"Notes:"]
[]
[]
[]
[]
[null,null,null,null,"Installation Company Information",null,null,null,null,null,null,null,null,null,null,"I confirm that the above information is correct to the best of my knowledge."]
[]
[null,null,null,null,"Company Name (as it appears on W9)",null,null,null,"Mailing Address",null,null,null,"City",null,"State","Zip Code"]
[]
[null,null,null,null,"Contact Name",null,null,"Email",null,"Phone",null,"Install Date",null,"Total Installed Cost*",null,"Project Development Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P33)=0,\"\",IF(LEFT(E51,1)=\"I\",MIN(P33,125),0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Including equipment, labor, permit and tax"]
[null,null,false]
[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.\n    (iii) Rebate applications must be submitted within 90 days of installation of the energy-efficiency measure(s). \nI agree to receive my rebate via (select one):"]
[]
[null,null,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,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Homeowner Signature:",null,null,null,null,null,null,"Date:",null,null,null,null,{"$f":"IF(AND(J53<>\"\",O53<>\"\"),TRUE,FALSE)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,"Email this completed workbook, verification photos, invoice, and a copy of the NFRC stickers or manufacturer packing slip with U-Value for each window to ce@snopud.com  "]

{"sheet":"Photo Requirements","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,2,2,6],[4,3,5,3],[9,2,9,6],[27,2,27,6],[46,2,46,6]]}
[]
[]
[null,null,{"$f":"BannerText","v":"\nEnergy Services  ●  ce@snopud.com  ●  www.snopud.com"}]
[]
[null,null,null,"Photo Requirements"]
[]
[null,null,null,"For Window Rebates in Single Family Homes"]
[]
[null,null,"Original Windows or wall shots of multiple windows",null,null,"Safety Glass (when applicable)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"New windows install or wall shots of multiple windows"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Header flashing (when applicable)",null,null,"Threshold support (when applicable)"]

{"sheet":"Total Glazing Calculator","index":3,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,10,16,11],[2,2,2,15],[8,6,8,7],[8,8,8,9],[8,10,8,11],[15,8,15,9],[15,10,15,11],[4,3,5,9],[14,3,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[13,3,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[22,3,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[11,3,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[12,3,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[16,3,16,5],[17,3,17,5],[16,6,16,7],[16,8,16,9],[9,3,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[10,3,10,5],[10,6,10,7],[10,8,10,9],[21,3,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[19,3,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[8,13,8,14],[20,3,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[17,6,17,7],[17,8,17,9],[17,10,17,11],[18,3,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[15,3,15,5],[15,6,15,7],[10,10,10,11],[8,3,8,5]]}
[]
[]
[null,null,"Energy Services  ●  ce@snopud.com  ●  www.snopud.com"]
[]
[null,null,null,"Windows Area Calculator"]
[]
[null,null,null,"For Window Rebates in Single Family Homes"]
[]
[null,null,null,"Window Type","Column1","Column2","Square Footage of Window or \nSliding Glass Door ",null,"No. of Windows",null,"Total Glazing Square Footage",null,null,"Total Glazing by Window Type",null,null,null,"Full Cavity","Err Code"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G10*I10<>0,G10*I10,\"\")","v":""},null,null,"Single Pane to Double Pane",{"$f":"SUMIF(D10:F98,N10,K10:L98)","v":0},null,null,false,{"$f":"IF(AND(I10<>\"\",J10<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D10 = \"Attic\",\nIF(I10>19, \"ER1\",\nIF(J10 <49, IF(R10=FALSE,\"ER2\", IF(R10=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D10 = \"Floor\",\nIF(AND(AND(I10 >10, J10 <30), IF(R10=FALSE, TRUE, FALSE)),\"ER5\", IF(R10 = TRUE, \"ER13\",\nIF(I10>19, \"ER3\",IF(J10 <19,  IF(R10=FALSE, \"ER4\", IF(R10=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D10 = \"Wall\", D10= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I10>0, \"ER6\",IF(J10<11, IF(R10=FALSE, \"ER7\",IF(R10=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D10 = \"Wall (Exposed 2x4)\",\nIF(I10>0, \"ER6\",IF(J10 <13,  IF(R10=FALSE, \"ER11\",IF(R10=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D10 = \"Wall (Exposed 2x6)\",\nIF(I10>0, \"ER6\",IF(J10 <21,  IF(R10=FALSE, \"ER12\",IF(R10=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D10 = \"Ducts\",\nIF(J10<8, IF(R10=FALSE, \"ER10\",IF(R10=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D10 = \"Floor\",\nIF(I10>11,\"ER8\", IF(J10<22, IF(R10=FALSE,\"ER9\",IF(R10=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G11*I11<>0,G11*I11,\"\")","v":""},null,null,"Double Pane Metal Frame to Double Pane",{"$f":"SUMIF(D10:F98,N11,K10:L98)","v":0},null,null,false,{"$f":"IF(AND(I11<>\"\",J11<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D11 = \"Attic\",\nIF(I11>19, \"ER1\",\nIF(J11 <49, IF(R11=FALSE,\"ER2\", IF(R11=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D11 = \"Floor\",\nIF(AND(AND(I11 >10, J11 <30), IF(R11=FALSE, TRUE, FALSE)),\"ER5\", IF(R11 = TRUE, \"ER13\",\nIF(I11>19, \"ER3\",IF(J11 <19,  IF(R11=FALSE, \"ER4\", IF(R11=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D11 = \"Wall\", D11= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I11>0, \"ER6\",IF(J11<11, IF(R11=FALSE, \"ER7\",IF(R11=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D11 = \"Wall (Exposed 2x4)\",\nIF(I11>0, \"ER6\",IF(J11 <13,  IF(R11=FALSE, \"ER11\",IF(R11=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D11 = \"Wall (Exposed 2x6)\",\nIF(I11>0, \"ER6\",IF(J11 <21,  IF(R11=FALSE, \"ER12\",IF(R11=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D11 = \"Ducts\",\nIF(J11<8, IF(R11=FALSE, \"ER10\",IF(R11=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D11 = \"Floor\",\nIF(I11>11,\"ER8\", IF(J11<22, IF(R11=FALSE,\"ER9\",IF(R11=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,false,{"$f":"IF(AND(I12<>\"\",J12<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D12 = \"Attic\",\nIF(I12>19, \"ER1\",\nIF(J12 <49, IF(R12=FALSE,\"ER2\", IF(R12=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D12 = \"Floor\",\nIF(AND(AND(I12 >10, J12 <30), IF(R12=FALSE, TRUE, FALSE)),\"ER5\", IF(R12 = TRUE, \"ER13\",\nIF(I12>19, \"ER3\",IF(J12 <19,  IF(R12=FALSE, \"ER4\", IF(R12=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D12 = \"Wall\", D12= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I12>0, \"ER6\",IF(J12<11, IF(R12=FALSE, \"ER7\",IF(R12=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D12 = \"Wall (Exposed 2x4)\",\nIF(I12>0, \"ER6\",IF(J12 <13,  IF(R12=FALSE, \"ER11\",IF(R12=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D12 = \"Wall (Exposed 2x6)\",\nIF(I12>0, \"ER6\",IF(J12 <21,  IF(R12=FALSE, \"ER12\",IF(R12=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D12 = \"Ducts\",\nIF(J12<8, IF(R12=FALSE, \"ER10\",IF(R12=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D12 = \"Floor\",\nIF(I12>11,\"ER8\", IF(J12<22, IF(R12=FALSE,\"ER9\",IF(R12=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,false,{"$f":"IF(AND(I13<>\"\",J13<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D13 = \"Attic\",\nIF(I13>19, \"ER1\",\nIF(J13 <49, IF(R13=FALSE,\"ER2\", IF(R13=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D13 = \"Floor\",\nIF(AND(AND(I13 >10, J13 <30), IF(R13=FALSE, TRUE, FALSE)),\"ER5\", IF(R13 = TRUE, \"ER13\",\nIF(I13>19, \"ER3\",IF(J13 <19,  IF(R13=FALSE, \"ER4\", IF(R13=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D13 = \"Wall\", D13= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I13>0, \"ER6\",IF(J13<11, IF(R13=FALSE, \"ER7\",IF(R13=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D13 = \"Wall (Exposed 2x4)\",\nIF(I13>0, \"ER6\",IF(J13 <13,  IF(R13=FALSE, \"ER11\",IF(R13=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D13 = \"Wall (Exposed 2x6)\",\nIF(I13>0, \"ER6\",IF(J13 <21,  IF(R13=FALSE, \"ER12\",IF(R13=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D13 = \"Ducts\",\nIF(J13<8, IF(R13=FALSE, \"ER10\",IF(R13=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D13 = \"Floor\",\nIF(I13>11,\"ER8\", IF(J13<22, IF(R13=FALSE,\"ER9\",IF(R13=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,false,{"$f":"IF(AND(I14<>\"\",J14<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D14 = \"Attic\",\nIF(I14>19, \"ER1\",\nIF(J14 <49, IF(R14=FALSE,\"ER2\", IF(R14=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D14 = \"Floor\",\nIF(AND(AND(I14 >10, J14 <30), IF(R14=FALSE, TRUE, FALSE)),\"ER5\", IF(R14 = TRUE, \"ER13\",\nIF(I14>19, \"ER3\",IF(J14 <19,  IF(R14=FALSE, \"ER4\", IF(R14=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D14 = \"Wall\", D14= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I14>0, \"ER6\",IF(J14<11, IF(R14=FALSE, \"ER7\",IF(R14=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D14 = \"Wall (Exposed 2x4)\",\nIF(I14>0, \"ER6\",IF(J14 <13,  IF(R14=FALSE, \"ER11\",IF(R14=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D14 = \"Wall (Exposed 2x6)\",\nIF(I14>0, \"ER6\",IF(J14 <21,  IF(R14=FALSE, \"ER12\",IF(R14=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D14 = \"Ducts\",\nIF(J14<8, IF(R14=FALSE, \"ER10\",IF(R14=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D14 = \"Floor\",\nIF(I14>11,\"ER8\", IF(J14<22, IF(R14=FALSE,\"ER9\",IF(R14=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G15*I15<>0,G15*I15,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I15<>\"\",J15<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D15 = \"Attic\",\nIF(I15>19, \"ER1\",\nIF(J15 <49, IF(R15=FALSE,\"ER2\", IF(R15=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D15 = \"Floor\",\nIF(AND(AND(I15 >10, J15 <30), IF(R15=FALSE, TRUE, FALSE)),\"ER5\", IF(R15 = TRUE, \"ER13\",\nIF(I15>19, \"ER3\",IF(J15 <19,  IF(R15=FALSE, \"ER4\", IF(R15=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D15 = \"Wall\", D15= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I15>0, \"ER6\",IF(J15<11, IF(R15=FALSE, \"ER7\",IF(R15=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D15 = \"Wall (Exposed 2x4)\",\nIF(I15>0, \"ER6\",IF(J15 <13,  IF(R15=FALSE, \"ER11\",IF(R15=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D15 = \"Wall (Exposed 2x6)\",\nIF(I15>0, \"ER6\",IF(J15 <21,  IF(R15=FALSE, \"ER12\",IF(R15=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D15 = \"Ducts\",\nIF(J15<8, IF(R15=FALSE, \"ER10\",IF(R15=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D15 = \"Floor\",\nIF(I15>11,\"ER8\", IF(J15<22, IF(R15=FALSE,\"ER9\",IF(R15=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G16*I16<>0,G16*I16,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I16<>\"\",J16<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D16 = \"Attic\",\nIF(I16>19, \"ER1\",\nIF(J16 <49, IF(R16=FALSE,\"ER2\", IF(R16=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D16 = \"Floor\",\nIF(AND(AND(I16 >10, J16 <30), IF(R16=FALSE, TRUE, FALSE)),\"ER5\", IF(R16 = TRUE, \"ER13\",\nIF(I16>19, \"ER3\",IF(J16 <19,  IF(R16=FALSE, \"ER4\", IF(R16=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D16 = \"Wall\", D16= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I16>0, \"ER6\",IF(J16<11, IF(R16=FALSE, \"ER7\",IF(R16=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D16 = \"Wall (Exposed 2x4)\",\nIF(I16>0, \"ER6\",IF(J16 <13,  IF(R16=FALSE, \"ER11\",IF(R16=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D16 = \"Wall (Exposed 2x6)\",\nIF(I16>0, \"ER6\",IF(J16 <21,  IF(R16=FALSE, \"ER12\",IF(R16=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D16 = \"Ducts\",\nIF(J16<8, IF(R16=FALSE, \"ER10\",IF(R16=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D16 = \"Floor\",\nIF(I16>11,\"ER8\", IF(J16<22, IF(R16=FALSE,\"ER9\",IF(R16=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G17*I17<>0,G17*I17,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I17<>\"\",J17<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D17 = \"Attic\",\nIF(I17>19, \"ER1\",\nIF(J17 <49, IF(R17=FALSE,\"ER2\", IF(R17=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D17 = \"Floor\",\nIF(AND(AND(I17 >10, J17 <30), IF(R17=FALSE, TRUE, FALSE)),\"ER5\", IF(R17 = TRUE, \"ER13\",\nIF(I17>19, \"ER3\",IF(J17 <19,  IF(R17=FALSE, \"ER4\", IF(R17=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D17 = \"Wall\", D17= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I17>0, \"ER6\",IF(J17<11, IF(R17=FALSE, \"ER7\",IF(R17=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D17 = \"Wall (Exposed 2x4)\",\nIF(I17>0, \"ER6\",IF(J17 <13,  IF(R17=FALSE, \"ER11\",IF(R17=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D17 = \"Wall (Exposed 2x6)\",\nIF(I17>0, \"ER6\",IF(J17 <21,  IF(R17=FALSE, \"ER12\",IF(R17=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D17 = \"Ducts\",\nIF(J17<8, IF(R17=FALSE, \"ER10\",IF(R17=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D17 = \"Floor\",\nIF(I17>11,\"ER8\", IF(J17<22, IF(R17=FALSE,\"ER9\",IF(R17=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G18*I18<>0,G18*I18,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I18<>\"\",J18<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D18 = \"Attic\",\nIF(I18>19, \"ER1\",\nIF(J18 <49, IF(R18=FALSE,\"ER2\", IF(R18=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D18 = \"Floor\",\nIF(AND(AND(I18 >10, J18 <30), IF(R18=FALSE, TRUE, FALSE)),\"ER5\", IF(R18 = TRUE, \"ER13\",\nIF(I18>19, \"ER3\",IF(J18 <19,  IF(R18=FALSE, \"ER4\", IF(R18=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D18 = \"Wall\", D18= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I18>0, \"ER6\",IF(J18<11, IF(R18=FALSE, \"ER7\",IF(R18=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D18 = \"Wall (Exposed 2x4)\",\nIF(I18>0, \"ER6\",IF(J18 <13,  IF(R18=FALSE, \"ER11\",IF(R18=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D18 = \"Wall (Exposed 2x6)\",\nIF(I18>0, \"ER6\",IF(J18 <21,  IF(R18=FALSE, \"ER12\",IF(R18=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D18 = \"Ducts\",\nIF(J18<8, IF(R18=FALSE, \"ER10\",IF(R18=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D18 = \"Floor\",\nIF(I18>11,\"ER8\", IF(J18<22, IF(R18=FALSE,\"ER9\",IF(R18=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G19*I19<>0,G19*I19,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I19<>\"\",J19<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D19 = \"Attic\",\nIF(I19>19, \"ER1\",\nIF(J19 <49, IF(R19=FALSE,\"ER2\", IF(R19=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D19 = \"Floor\",\nIF(AND(AND(I19 >10, J19 <30), IF(R19=FALSE, TRUE, FALSE)),\"ER5\", IF(R19 = TRUE, \"ER13\",\nIF(I19>19, \"ER3\",IF(J19 <19,  IF(R19=FALSE, \"ER4\", IF(R19=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D19 = \"Wall\", D19= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I19>0, \"ER6\",IF(J19<11, IF(R19=FALSE, \"ER7\",IF(R19=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D19 = \"Wall (Exposed 2x4)\",\nIF(I19>0, \"ER6\",IF(J19 <13,  IF(R19=FALSE, \"ER11\",IF(R19=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D19 = \"Wall (Exposed 2x6)\",\nIF(I19>0, \"ER6\",IF(J19 <21,  IF(R19=FALSE, \"ER12\",IF(R19=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D19 = \"Ducts\",\nIF(J19<8, IF(R19=FALSE, \"ER10\",IF(R19=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D19 = \"Floor\",\nIF(I19>11,\"ER8\", IF(J19<22, IF(R19=FALSE,\"ER9\",IF(R19=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G20*I20<>0,G20*I20,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I20<>\"\",J20<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D20 = \"Attic\",\nIF(I20>19, \"ER1\",\nIF(J20 <49, IF(R20=FALSE,\"ER2\", IF(R20=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D20 = \"Floor\",\nIF(AND(AND(I20 >10, J20 <30), IF(R20=FALSE, TRUE, FALSE)),\"ER5\", IF(R20 = TRUE, \"ER13\",\nIF(I20>19, \"ER3\",IF(J20 <19,  IF(R20=FALSE, \"ER4\", IF(R20=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D20 = \"Wall\", D20= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I20>0, \"ER6\",IF(J20<11, IF(R20=FALSE, \"ER7\",IF(R20=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D20 = \"Wall (Exposed 2x4)\",\nIF(I20>0, \"ER6\",IF(J20 <13,  IF(R20=FALSE, \"ER11\",IF(R20=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D20 = \"Wall (Exposed 2x6)\",\nIF(I20>0, \"ER6\",IF(J20 <21,  IF(R20=FALSE, \"ER12\",IF(R20=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D20 = \"Ducts\",\nIF(J20<8, IF(R20=FALSE, \"ER10\",IF(R20=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D20 = \"Floor\",\nIF(I20>11,\"ER8\", IF(J20<22, IF(R20=FALSE,\"ER9\",IF(R20=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21*I21<>0,G21*I21,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I21<>\"\",J21<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D21 = \"Attic\",\nIF(I21>19, \"ER1\",\nIF(J21 <49, IF(R21=FALSE,\"ER2\", IF(R21=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D21 = \"Floor\",\nIF(AND(AND(I21 >10, J21 <30), IF(R21=FALSE, TRUE, FALSE)),\"ER5\", IF(R21 = TRUE, \"ER13\",\nIF(I21>19, \"ER3\",IF(J21 <19,  IF(R21=FALSE, \"ER4\", IF(R21=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D21 = \"Wall\", D21= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I21>0, \"ER6\",IF(J21<11, IF(R21=FALSE, \"ER7\",IF(R21=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D21 = \"Wall (Exposed 2x4)\",\nIF(I21>0, \"ER6\",IF(J21 <13,  IF(R21=FALSE, \"ER11\",IF(R21=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D21 = \"Wall (Exposed 2x6)\",\nIF(I21>0, \"ER6\",IF(J21 <21,  IF(R21=FALSE, \"ER12\",IF(R21=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D21 = \"Ducts\",\nIF(J21<8, IF(R21=FALSE, \"ER10\",IF(R21=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D21 = \"Floor\",\nIF(I21>11,\"ER8\", IF(J21<22, IF(R21=FALSE,\"ER9\",IF(R21=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G22*I22<>0,G22*I22,\"\")","v":""},null,null,null,null,null,null,false,{"$f":"IF(AND(I22<>\"\",J22<>\"\"), IF(OR(Home = \"Standard Construction\", Home = \"Townhouse\"),\nIF(D22 = \"Attic\",\nIF(I22>19, \"ER1\",\nIF(J22 <49, IF(R22=FALSE,\"ER2\", IF(R22=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D22 = \"Floor\",\nIF(AND(AND(I22 >10, J22 <30), IF(R22=FALSE, TRUE, FALSE)),\"ER5\", IF(R22 = TRUE, \"ER13\",\nIF(I22>19, \"ER3\",IF(J22 <19,  IF(R22=FALSE, \"ER4\", IF(R22=TRUE,\"ER13\", \"\")),\"\")))),\n\nIF(OR(D22 = \"Wall\", D22= \"Floor (Overhang, Floor Over Garage)\"),\nIF(I22>0, \"ER6\",IF(J22<11, IF(R22=FALSE, \"ER7\",IF(R22=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D22 = \"Wall (Exposed 2x4)\",\nIF(I22>0, \"ER6\",IF(J22 <13,  IF(R22=FALSE, \"ER11\",IF(R22=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D22 = \"Wall (Exposed 2x6)\",\nIF(I22>0, \"ER6\",IF(J22 <21,  IF(R22=FALSE, \"ER12\",IF(R22=TRUE,\"ER13\", \"\")),\"\")),\n\nIF(D22 = \"Ducts\",\nIF(J22<8, IF(R22=FALSE, \"ER10\",IF(R22=TRUE,\"ER13\", \"\")),\"\"),\"\")))))),\n\nIF(Home = \"Manufactured Home\",\nIF(D22 = \"Floor\",\nIF(I22>11,\"ER8\", IF(J22<22, IF(R22=FALSE,\"ER9\",IF(R22=TRUE,\"ER13\", \"\")),\"\")),\"\"),\"\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,false,false]

{"sheet":"Dropdowns","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Preferred Contact Method",null,null,"Home Type","Installation"]
["Phone",null,null,"Standard Construction","Single Pane to Double Pane"]
["Email",null,null,"Manufactured Home","Double Pane Metal Frame to Double Pane"]
["U.S. Mail",null,null,"Townhouse"]
[]
["Residence Type",null,null,"Payment Options"]
["Primary Residence",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"]
["Rental",null,null,"Credit to my PUD utility account, which may take up to six (6) weeks for processing"]
[]
["Home Type"]
["Standard Construction"]
["Manufactured Home"]
["Townhouse"]
[]
["Pre-Existing Primary Electric Heat Source"]
["Electric Furnace"]
["Zonal (Baseboard, Wall Unit)"]
["Ductless Heat Pump"]
["Heat Pump with Electric Furnace"]
[]
["Water Heater"]
["Electric"]
["Non-Electric"]