{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Temp Control","Tables"],"not_rendered":{"charts":0,"images":5,"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":"Temp Control","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[40,10,41,10],[44,10,45,10],[44,5,45,5],[40,6,41,9],[45,6,45,9],[6,0,6,13],[32,6,32,9],[10,1,10,2],[44,1,45,4],[18,1,18,2],[19,1,19,2],[20,1,20,2],[22,1,22,2],[36,6,36,9],[34,5,35,5],[36,5,37,5],[38,5,39,5],[38,10,39,10],[36,10,37,10],[34,10,35,10],[34,6,35,9],[21,5,21,12],[22,5,22,12],[23,5,23,12],[24,5,24,12],[19,5,19,12],[18,5,18,12],[20,3,20,4],[3,0,3,3],[14,3,14,4],[15,3,15,4],[18,3,18,4],[20,5,20,12],[19,3,19,4],[15,5,15,12],[10,3,10,4],[11,3,11,4],[9,0,9,4],[9,5,9,12],[0,0,0,13],[1,0,1,13],[4,0,4,13],[5,0,5,13],[7,0,7,13],[16,1,16,2],[17,1,17,2],[12,3,12,4],[13,3,13,4],[16,3,16,4],[15,1,15,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[3,4,3,13],[17,3,17,4],[16,5,16,12],[17,5,17,12],[10,5,10,12],[11,5,11,12],[12,5,12,12],[13,5,13,12],[14,5,14,12],[28,1,29,4],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[25,5,25,12],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[21,3,21,4],[27,0,27,13],[28,5,29,5],[28,10,29,10],[30,10,31,10],[30,5,31,5],[32,5,33,5],[32,10,33,10],[28,6,29,9],[30,6,31,9],[36,0,37,0],[38,0,39,0],[40,0,41,0],[44,0,45,0],[30,1,31,4],[32,1,33,4],[34,1,35,4],[36,1,37,4],[38,1,39,4],[40,1,41,4],[43,0,43,7],[33,6,33,9],[37,6,37,9],[38,6,39,9],[44,6,44,9],[40,5,41,5],[38,13,39,13],[40,13,41,13],[44,13,45,13],[28,11,29,12],[30,11,31,12],[32,11,33,12],[34,11,35,12],[36,11,37,12],[38,11,39,12],[40,11,41,12],[44,11,45,12],[28,13,29,13],[30,13,31,13],[32,13,33,13],[34,13,35,13],[36,13,37,13]]}
["Temperature Control"]
["(Electric Cooling and Electric or Gas Heating)"]
[]
["Description of UCRM:"]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"Btu/hr-ft2-°F",null,"U-Value of Walls",null,null,null,null,null,null,null,"Table 18"]
["B)",null,null,"ft2",null,"Wall Area (includes windows and doors)"]
["C)",null,null,"Btu/hr-ft2-°F",null,"U-Value of Roof",null,null,null,null,null,null,null,"Table 18"]
["D)",null,null,"ft2",null,"Roof Area"]
["E)",null,null,"°F",null,"Heating Season Thermostat Setpoint"]
["F)",null,null,"°F",null,"Heating Season Thermostat Setback"]
["G)",null,null,"hrs/yr",null,"Heating Season Hours",null,null,null,null,null,null,null,"Table 16"]
["H)",null,null,"°F",null,"Cooling Season Thermostat Setpoint"]
["I)",null,null,"°F",null,"Cooling Season Thermostat Setback"]
["J)",null,null,"hrs/yr",null,"Cooling Season Hours",null,null,null,null,null,null,null,"Table 15"]
["K)",null,null,"%",null,"Heating Equipment Efficiency",null,null,null,null,null,null,null,"Table 3"]
["L)",null,null,"$/Mcf (or kWh)",null,"Natural Gas Rate (or $/winter kWh for electric heat)"]
["M)",null,null,"Btuh/Watt",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1"]
["N)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["O)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["P)",null,null,"$",null,"Implimentation Cost"]
[]
["Calculations"]
["Q)","Total Envelope UA-Value",null,null,null,"=","A * B + C * D",null,null,null,"=",{"$f":"B11*B12+B13*B14","v":0},null,"Btu/hr-°F"]
[]
["R)","Heating Energy Savings",null,null,null,"=","Q * (E - F) * G",null,null,null,"=",{"$f":"L29*(B15-B16)*B17","v":0},null,"Btu/yr"]
[]
["SG)","Gas Heating Cost Reduction1",null,null,null,"=","R * L",null,null,null,"=",{"$f":"IF(B22>1,(L31*B22)/((B21/100)*1030000),\"\")","v":""},null,"$/yr"]
[null,null,null,null,null,null,"(K * 1,030,000 Btu/Mcf)"]
["T)","Cooling Energy Savings",null,null,null,"=","Q * (H - I) * J",null,null,null,"=",{"$f":"L29*(B18-B19)*B20","v":0},null,"Btu/yr"]
[]
["U)","Cooling Cost Reduction",null,null,null,"=","T * (N + O) / 2",null,null,null,"=",{"$f":"(L35*(B24+B25)/2)/(1000*B23)","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[null,null,null,null,null,null,"1,000 * M"]
["V)","Annual Cost Savings",null,null,null,"=","S + U",null,null,null,"=",{"$f":"IF(L33=\"\",L45+L37,L33+L37)","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["W)","Simple Payback",null,null,null,"=","P / V",null,null,null,"=",{"$f":"B26/L39","v":{"$error":"#DIV/0!"}},null,"yrs"]
[]
[]
["1Use SG for Gas Heating and SE for Electrical Heating"]
["SE)","Electrical Heating Cost Reduction",null,null,null,"=","R * L",null,null,null,"=",{"$f":"IF(B22<1,(L31*B22)/(3413*(B21/100)),\"\")","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[null,null,null,null,null,null,"3,413 Btuh/kW * K"]

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