{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Builder Rebate Summary "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Builder Rebate Summary ","index":0,"n_rows":80,"n_cols":22,"rows_kept":80,"cut":false,"hidden":false,"merged":[[6,17,6,18],[6,3,6,15],[0,2,0,21],[3,17,3,21],[1,2,1,21],[2,2,2,21],[5,17,5,18],[5,3,5,15],[14,4,14,6],[7,17,7,18],[8,17,8,18],[9,17,9,18],[10,17,10,18],[11,17,11,18],[12,17,12,18],[7,3,7,15],[8,3,8,15],[10,3,10,15],[9,3,9,15],[12,3,12,15]]}
[null,null,"All highlighted fields are required. If submitting applications for multiple installation addresses, only one builder summary sheet is necessary."]
[]
[null,null,"Builder Rebate Summary Sheet"]
[null,null,"Energy Efficiency Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TGS Employee Use Only:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verification Checklist (Reviewer/Manager Initials)"]
[null,null,"Builder Name:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Eligible premises"]
[null,null,"Subdivision Name:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"  Equipment invoices & specs"]
[null,null,"Date of Rebate Submission:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  W-9 on file"]
[null,null,"Mailing Address 1:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"  Submitted within 180 days"]
[null,null,"Mailing Address 2:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"  Permits pulled"]
[null,null,"ZIP:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Manager approval"]
[]
[null,null,"Rebate Total:  ",{"$f":"$V$74","v":0}]
[]
[null,"Builder","Installation Address","Zipcode","Account",null,null,"Jurisdiction","I/S or O/S","Plumbing Contractor Name","Mechanical Contractor Name"," Building Permit #","Final Insp/\nCOO Date","Days Elapsed","Eligible?","Freestanding Range","Range Stub","Tankless (UEF>.81)","H.E. Water Heater (UEF .70 - .81)","Dryer w/ Moisture Sensor","Dryer Stub","Total Rebate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,100,400,100,225,225]
[null,null,"SAMPLE",78504,111111111,{"$f":"IF(C17=\"\",\"\",\"-\")","v":"-"},1111111,"MERC","I/S","Plumbing Inc.","Mechanical Inc.","2017-111111 BP","2018-07-05",180,{"$f":"IF(N17<>\"\",IF(N17>180,\"N\",\"Y\"),\"\")","v":"Y"},1,1,2,1,1,1,{"$f":"IF(AND(SUM(P17:U17)>0,O17=\"Y\"),(P17*$P$16)+ (Q17*$Q$16)+(R17*$R$16)+(S17*$S$16)+(T17*$T$16)+(U17*$U$16),\"\")","v":1550}]
[1,{"$f":"$E$6","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M18<>\"\",$D$8-M18,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(P18:U18)>0,O18=\"Y\"),(P18*$P$16)+(Q18*$Q$16)+(R18*$R$16)+(S18*$S$16)+(T18*$T$16)+(U18*$U$16),\"\")","v":""}]
[2,{"$f":"IF(SUM(P19:U19)>0,E7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N19>=0,IF(N19<>\"\",IF(N19>180,\"N\",\"Y\"),\"\"),\"N\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(SUM(P19:U19)>0,O19=\"Y\"),(P19*$P$16)+(Q19*$Q$16)+(R19*$R$16)+(S19*$S$16)+(T19*$T$16)+(U19*$U$16),\"\")","v":""}]
[3,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[4,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[5,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[6,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[7,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[8,{"$f":"IF(SUM(P25:U25)>0,D13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[9,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[10,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[29,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[30,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[31,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[32,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[33,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[34,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[35,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[36,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[37,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[38,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[39,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[40,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[41,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[42,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[43,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[44,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[45,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[46,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[47,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[48,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[49,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[50,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[51,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[52,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[53,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[54,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
[55,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,""]
["#",{"$f":"IF(SUM(P73:U73)>0,#REF!,\"\")","v":""},null,null,null,{"$f":"IF(C73=\"\",\"\",\"-\")","v":""},null,null,null,null,null,null,null,"",{"$f":"IF(N73>=0,IF(N73<>\"\",IF(N73>180,\"N\",\"Y\"),\"\"),\"N\")","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(P18:P73)*P16","v":0},null,{"$f":"SUM(R18:R73)*R16","v":0},{"$f":"SUM(S18:S73)*S16","v":0},{"$f":"SUM(T18:T73)*T16","v":0},{"$f":"SUM(U18:U73)*U16","v":0},{"$f":"SUM(V18:V73)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"            "]