{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Wall Insulation","Tables"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":"Wall Insulation","index":0,"n_rows":47,"n_cols":35,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,13,46,13],[46,6,46,9],[39,6,39,9],[40,6,40,9],[43,6,44,9],[45,0,46,0],[45,1,46,4],[45,5,46,5],[45,6,45,9],[45,10,46,10],[45,11,46,12],[43,13,44,13],[18,1,18,2],[18,3,18,4],[18,5,18,12],[19,1,19,2],[43,0,44,0],[43,1,44,4],[43,5,44,5],[43,10,44,10],[43,11,44,12],[41,0,42,0],[41,1,42,4],[41,5,42,5],[41,6,42,9],[41,10,42,10],[41,11,42,12],[39,0,40,0],[39,1,40,4],[39,5,40,5],[39,10,40,10],[39,11,40,12],[35,10,36,10],[35,11,36,12],[29,0,30,0],[29,1,30,4],[40,29,40,30],[40,31,40,33],[41,14,41,16],[41,17,41,19],[41,22,41,24],[41,26,41,28],[41,31,41,33],[41,13,42,13],[40,14,40,16],[40,17,40,19],[40,20,40,21],[40,22,40,24],[40,26,40,28],[39,13,40,13],[42,14,43,23],[39,14,39,16],[39,17,39,19],[39,20,39,21],[39,22,39,24],[39,26,39,28],[39,29,39,30],[39,31,39,33],[38,14,38,16],[38,17,38,19],[38,20,38,21],[38,22,38,24],[38,26,38,28],[35,1,36,4],[35,5,36,5],[36,29,36,30],[36,31,36,33],[38,6,38,9],[37,14,37,16],[37,17,37,19],[37,20,37,21],[37,22,37,24],[37,26,37,28],[37,29,37,30],[37,31,37,33],[37,13,38,13],[36,14,36,16],[36,17,36,19],[36,20,36,21],[36,22,36,24],[36,26,36,28],[35,6,36,9],[29,5,30,5],[38,29,38,30],[38,31,38,33],[33,29,33,30],[33,31,33,33],[37,0,38,0],[37,1,38,4],[37,5,38,5],[37,6,37,9],[37,10,38,10],[37,11,38,12],[34,29,34,30],[34,31,34,33],[35,14,35,16],[35,17,35,19],[35,20,35,21],[35,22,35,24],[35,26,35,28],[35,29,35,30],[35,31,35,33],[35,13,36,13],[34,14,34,16],[34,17,34,19],[34,20,34,21],[34,26,34,28],[35,0,36,0],[33,13,34,13],[32,14,32,16],[32,17,32,19],[32,20,32,21],[32,22,32,24],[32,26,32,28],[33,0,34,0],[33,1,34,4],[33,5,34,5],[33,6,34,9],[33,10,34,10],[33,11,34,12],[31,0,32,0],[31,1,32,4],[31,5,32,5],[33,14,33,16],[33,17,33,19],[33,20,33,21],[33,22,33,24],[33,26,33,28],[34,22,34,24],[30,29,30,30],[30,31,30,33],[32,6,32,9],[31,14,31,16],[31,17,31,19],[31,20,31,21],[31,22,31,24],[31,26,31,28],[31,29,31,30],[31,31,31,33],[31,13,32,13],[30,14,30,16],[30,17,30,19],[30,20,30,21],[30,22,30,24],[30,26,30,28],[31,6,31,9],[31,10,32,10],[31,11,32,12],[29,13,30,13],[32,29,32,30],[32,31,32,33],[29,14,29,16],[29,17,29,19],[29,6,30,9],[29,10,30,10],[29,11,30,12],[26,29,26,30],[26,31,26,33],[27,14,27,16],[27,17,27,19],[27,20,27,21],[27,22,27,24],[27,26,27,28],[27,29,27,30],[27,31,27,33],[27,13,28,13],[26,14,26,16],[26,17,26,19],[26,20,26,21],[26,22,26,24],[26,26,26,28],[29,20,29,21],[29,22,29,24],[29,26,29,28],[29,29,29,30],[29,31,29,33],[28,26,28,28],[27,0,28,0],[27,1,28,4],[27,5,28,5],[27,6,28,9],[27,10,28,10],[27,11,28,12],[24,31,24,33],[26,0,26,13],[25,14,25,16],[25,17,25,19],[25,20,25,21],[25,22,25,24],[25,26,25,28],[25,29,25,30],[25,31,25,33],[24,1,24,2],[24,3,24,4],[24,5,24,12],[28,29,28,30],[28,31,28,33],[28,14,28,16],[28,17,28,19],[28,20,28,21],[28,22,28,24],[23,26,23,28],[23,29,23,30],[23,31,23,33],[24,14,24,16],[24,17,24,19],[24,20,24,21],[24,22,24,24],[24,26,24,28],[24,29,24,30],[23,14,23,16],[23,17,23,19],[23,20,23,21],[20,1,20,2],[20,3,20,4],[20,5,20,12],[23,1,23,2],[23,3,23,4],[23,5,23,12],[22,14,22,16],[22,20,22,21],[22,22,22,24],[22,1,22,2],[21,1,21,2],[23,22,23,24],[19,17,20,24],[19,26,20,33],[19,3,19,4],[19,5,19,12],[21,17,22,19],[21,20,21,21],[21,22,21,24],[21,26,22,28],[21,29,21,30],[21,31,21,33],[22,29,22,30],[22,31,22,33],[21,3,21,4],[21,5,21,12],[22,3,22,4],[22,5,22,12],[21,14,21,16],[17,15,17,19],[17,20,17,21],[17,24,17,29],[15,24,15,29],[15,30,15,31],[13,1,13,2],[13,3,13,4],[13,5,13,12],[16,15,16,19],[16,20,16,21],[16,24,16,29],[16,30,16,31],[17,30,17,31],[15,1,15,2],[15,3,15,4],[15,5,15,12],[16,1,16,2],[16,3,16,4],[16,5,16,12],[17,1,17,2],[17,3,17,4],[17,5,17,12],[14,15,14,22],[14,24,14,32],[12,3,12,4],[12,5,12,12],[15,15,15,19],[15,20,15,21],[14,1,14,2],[14,3,14,4],[14,5,14,12],[10,1,10,2],[10,3,10,4],[10,5,10,12],[10,31,10,33],[8,1,8,2],[8,3,8,4],[8,5,8,12],[11,14,12,19],[11,21,11,22],[11,24,12,30],[11,32,11,33],[9,1,9,2],[9,3,9,4],[8,31,8,33],[11,1,11,2],[11,3,11,4],[11,5,11,12],[10,14,10,19],[10,20,10,22],[10,24,10,30],[8,14,8,19],[8,20,8,22],[8,24,8,30],[9,5,9,12],[12,21,12,22],[12,32,12,33],[12,1,12,2],[5,14,5,19],[5,20,5,22],[5,24,5,30],[5,31,5,33],[6,0,6,4],[6,5,6,12],[9,14,9,19],[9,20,9,22],[9,24,9,30],[9,31,9,33],[6,14,6,19],[6,20,6,22],[6,24,6,30],[6,31,6,33],[7,14,7,19],[7,20,7,22],[7,24,7,30],[7,31,7,33],[7,1,7,2],[7,3,7,4],[7,5,7,12],[3,14,3,19],[3,20,3,22],[3,24,3,30],[3,31,3,33],[3,0,3,13],[4,14,4,19],[4,20,4,22],[4,24,4,30],[4,31,4,33],[4,0,4,13],[0,0,0,13],[0,14,0,22],[0,24,0,33],[1,0,1,13],[1,14,1,22],[1,24,1,33],[2,14,2,19],[2,20,2,22],[2,24,2,30],[2,31,2,33],[2,0,2,3],[2,4,2,13]]}
["Wall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Table PTR",null,null,null,null,null,null,null,null,null,"Table FTR"]
["(Electric Cooling and Heating)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Present Thermal Resistance)",null,null,null,null,null,null,null,null,null,"(Future Thermal Resistance)"]
["Description of UCRM:",null,null,null,"(Data needed:  area to be treated, how, construction description)",null,null,null,null,null,null,null,null,null,"ELEMENT",null,null,null,null,null,"R(hr-ft2-°F/Btu)",null,null,null,"ELEMENT",null,null,null,null,null,null,"R(hr-ft2-°F/Btu)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outside Skin (ho)",null,null,null,null,null,null,null,null,null,"Outside Skin (ho)"]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",{"$f":"R42","v":0},null,"hrs/yr",null,"Annual Cooling System Operating Hours (Tbl ACT - (A))"]
["B)",{"$f":"W42/R42","v":{"$error":"#DIV/0!"}},null,"°F",null,"Avg Temp Diff Across Wall, Clg Season (Tbl ACT - (B) ΔTcool)"]
["C)",{"$f":"AA42","v":0},null,"hrs/yr",null,"Annual Heating System Operating Hours (Tbl AHT - (C))"]
["D)",{"$f":"AF42/AA42","v":{"$error":"#DIV/0!"}},null,"°F",null,"Avg Temp Diff Across Wall, Htg Season (Tbl AHT - (D) ΔTheat)",null,null,null,null,null,null,null,null,"Inside Skin (hi)",null,null,null,null,null,null,null,null,null,"Inside Skin (hi)"]
["E)",{"$f":"V13","v":{"$error":"#DIV/0!"}},null,"Btu/(hr-ft2-°F)",null,"Present Heat Transfer Coefficient (Uo) (Table PTR)",null,null,null,null,null,null,null,"Table 18","TOTALS:",null,null,null,null,null,"Ro =",{"$f":"SUM(U4:W11)","v":0},null,null,"TOTALS:",null,null,null,null,null,null,"Ro =",{"$f":"SUM(AF4:AH11)","v":0}]
["F)",{"$f":"AG13","v":{"$error":"#DIV/0!"}},null,"Btu/(hr-ft2-°F)",null,"Proposed Heat Transfer Coefficient (Uo) (Table FTR)",null,null,null,null,null,null,null,"Table 18",null,null,null,null,null,null,"Uo =",{"$f":"1/V12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Uo =",{"$f":"1/AG12","v":{"$error":"#DIV/0!"}}]
["G)",null,null,"ft2",null,"Area To Be Treated"]
["H)",null,null,"kW/ton",null,"Performance of Cooling Sytem",null,null,null,null,null,null,null,"Table 1",null,"TABLE ACT - AVG CLG TEMP",null,null,null,null,null,null,null,null,"TABLE AHT - AVG HTG TEMP"]
["I)",null,null,"COP",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3",null,"Temp at which clg is initiated:",null,null,null,null,null,null,"(Tci)",null,"Temp at which htg is initiated:",null,null,null,null,null,null,null,"(Thi)"]
["J)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer",null,null,null,null,null,null,null,null,null,"Temp at which clg is full load:",null,null,null,null,null,null,"(Tcf)",null,"Temp at which htg is full load:",null,null,null,null,null,null,null,"(Thf)"]
["K)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Summer",null,null,null,null,null,null,null,null,null,"Temp of interior, cooling:",null,null,null,null,null,null,"(Tcs)",null,"Temp of interior, heating:",null,null,null,null,null,null,null,"(Ths)"]
["L)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["M)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Winter",null,null,null,null,null,null,null,null,null,null,null,"Table ACT - Average Cooling Temperature",null,null,null,null,null,null,null,null,"Table AHT - Average Heating Temperature"]
["N)",null,null,null,null,"Demand Diversity for Htg Season (0 to 1 with 0.6 as default) "]
["O)",null,null,"$/Mcf",null,"Natural Gas Rate",null,null,null,null,null,null,null,null,"Temp. BIN",null,null,"Cooling BIN Hrs1 (t)",null,null,"Temp Diff",null,"ΔTcool",null,null,null,"Heating BIN Hrs1 (t)",null,null,"Temp Diff",null,"ΔTheat"]
["P)",null,null,"mo/yr",null,"Length of Cooling Season",null,null,null,null,null,null,null,null,"(Midpoint)",null,null,null,null,null,"Tcs - TBIN",null,"t * (Tcs - TBIN)",null,null,null,null,null,null,"Ths - TBIN",null,"t * (Ths - TBIN)"]
["Q)",null,null,"mo/yr",null,"Length of Heating Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O24-$U$18","v":0},null,{"$f":"IF(O24-$U$16<=0,,R24*U24)","v":0},null,null,{"$f":"IF(U24=0,0,W24/U24)","v":0},null,null,null,{"$f":"$AE$18-O24","v":0},null,{"$f":"IF($AE$16-O24<=0,,AA24*AD24)","v":0},null,null,{"$f":"IF(AD24=0,0,AF24/AD24)","v":0}]
["R)",null,null,"$",null,"Cost of Project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O25-$U$18","v":0},null,{"$f":"IF(O25-$U$16<=0,,R25*U25)","v":0},null,null,{"$f":"IF(U25=0,0,W25/U25)","v":0},null,null,null,{"$f":"$AE$18-O25","v":0},null,{"$f":"IF($AE$16-O25<=0,,AA25*AD25)","v":0},null,null,{"$f":"IF(AD25=0,0,AF25/AD25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26-$U$18","v":0},null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["S)","Cooling Energy Savings",null,null,null,"=","(E - F) * G * A * B",null,null,null,"=",{"$f":"(B12-B13)*B14*B8*B9","v":{"$error":"#DIV/0!"}},null,"Btu/yr",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["T)","Cooling Electrical Energy Savings",null,null,null,"=","(S / 12,000 Btuh/Ton) * H",null,null,null,"=",{"$f":"(L28/12000)*B15","v":{"$error":"#DIV/0!"}},null,"kWh/yr",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["U)","Cooling Electrical Demand Reduction",null,null,null,"=","T",null,null,null,"=",{"$f":"L30/B8","v":{"$error":"#DIV/0!"}},null,"kW",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["V)","Annual Cooling Cost Savings",null,null,null,"=","T * J + U * P * K",null,null,null,"=",{"$f":"L30*B17+L32*B23*B18","v":{"$error":"#DIV/0!"}},null,"$/yr",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["W)","Heating Energy Savings",null,null,null,"=","(E - F) * G * C * D",null,null,null,"=",{"$f":"(B12-B13)*B14*B10*B11","v":{"$error":"#DIV/0!"}},null,"Btu/yr",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["X)","Heating Electrical Energy Savings",null,null,null,"=","W / 3,413 Btu/kWH",null,null,null,"=",{"$f":"(L36/3413)/B16","v":{"$error":"#DIV/0!"}},null,"kWh/yr",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,"I",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["Y)","Heating Electrical Demand Savings",null,null,null,"=","X",null,null,null,"=",{"$f":"L38/B10","v":{"$error":"#DIV/0!"}},null,"kW",null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,null,null,null,0,null,0,null,null,0]
["Z)","Annual Heating Cost Savings",null,null,null,"=","X * L + Y * Q * M * N",null,null,null,"=",{"$f":"L38*B19+L40*B24*B20*B21","v":{"$error":"#DIV/0!"}},null,"$/yr","TOTALS",null,null,{"$f":"SUM(Z24:Z41)","v":0},null,null,null,null,{"$f":"SUM(W24:Y41)","v":0},null,null,null,{"$f":"SUM(AI24:AI41)","v":0},null,null,null,null,{"$f":"SUM(AF24:AH41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1Hrs above full load temp (Tcf or Thf) will be combined"]
["AA)","Annual Cost Savings",null,null,null,"=","V + Z",null,null,null,"=",{"$f":"L34+L42","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["BB)","Simple Payback",null,null,null,"=","R",null,null,null,"=",{"$f":"B25/L44","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"AA"]

{"sheet":"Tables","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}