{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Timeclock Control","Tables"],"not_rendered":{"charts":0,"images":2,"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":"Timeclock Control","index":0,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[34,11,35,12],[36,11,37,12],[38,11,39,12],[40,11,41,12],[31,10,32,10],[40,5,41,5],[34,10,35,10],[36,10,37,10],[38,10,39,10],[40,10,41,10],[32,6,32,9],[38,5,39,5],[38,13,39,13],[40,13,41,13],[35,6,35,9],[40,6,40,9],[41,6,41,9],[38,6,39,9],[24,0,24,13],[33,0,33,13],[34,0,35,0],[36,0,37,0],[38,0,39,0],[40,0,41,0],[34,1,35,4],[36,1,37,4],[38,1,39,4],[40,1,41,4],[29,13,30,13],[31,13,32,13],[31,11,32,12],[29,11,30,12],[29,1,30,4],[31,1,32,4],[29,6,30,9],[37,6,37,9],[25,13,26,13],[25,1,26,4],[27,1,28,4],[27,11,28,12],[27,13,28,13],[21,1,21,2],[36,6,36,9],[36,5,37,5],[31,6,31,9],[34,6,34,9],[34,5,35,5],[27,6,27,9],[23,0,23,13],[25,6,25,9],[25,0,26,0],[27,0,28,0],[21,3,21,4],[21,5,21,12],[28,6,28,9],[29,0,30,0],[31,0,32,0],[25,5,26,5],[34,13,35,13],[36,13,37,13],[25,10,26,10],[27,5,28,5],[27,10,28,10],[29,5,30,5],[29,10,30,10],[31,5,32,5],[19,1,19,2],[19,3,19,4],[19,5,19,12],[20,1,20,2],[20,3,20,4],[20,5,20,12],[26,6,26,9],[25,11,26,12],[18,1,18,2],[18,3,18,4],[18,5,18,12],[15,1,15,2],[15,3,15,4],[15,5,15,12],[16,1,16,2],[16,3,16,4],[16,5,16,12],[14,1,14,2],[14,3,14,4],[14,5,14,12],[12,1,12,2],[12,3,12,4],[12,5,12,12],[17,1,17,2],[17,3,17,4],[17,5,17,12],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[13,1,13,2],[13,3,13,4],[13,5,13,12],[11,1,11,2],[11,3,11,4],[11,5,11,12],[6,0,6,13],[7,0,7,13],[9,0,9,4],[9,5,9,12],[10,1,10,2],[10,3,10,4],[10,5,10,12]]}
["Timeclock Control of Air Conditioning/Heating Units"]
["(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,"Tons",null,"Cooling Unit Tonnage"]
["B)",null,null,"hrs/yr",null,"Annual Cooling Operating Hours Unit Will be Shut Off"]
["C)",null,null,"Btuh/Watt",null,"System EER",null,null,null,null,null,null,null,"Table 1"]
["D)",null,null,"%",null,"Estimated Cooling Load/Duty Factor"]
["E)",null,null,"hrs/yr",null,"Annual Heating Operating Hours Unit Will be Shut Off"]
["F)",null,null,"kW",null,"Heating Unit Capacity"]
["G)",null,null,"%",null,"Heating Efficiency",null,null,null,null,null,null,null,"Table 3"]
["H)",null,null,"%",null,"Estimated Heating Load/Duty Factor"]
["I)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["J)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter (Electric Heat Alternative)"]
["K)",null,null,"$/Mcf",null,"Natural Gas Rate"]
["L)",null,null,"$",null,"Implementation Cost"]
[]
["Calculations"]
["Electric Heating Alternative:"]
["M)","Annual Cooling Savings",null,null,null,"=","A * 12,000 Btuh/Ton * B * D",null,null,null,"=",{"$f":"IF(B21=\"\",(B11*12000*B12*(B14/100))/(B13*1000),\"\")","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,"C * 1,000 W/kW"]
["N)","Annual Heating Savings",null,null,null,"=","E * F * H",null,null,null,"=",{"$f":"IF(B21=\"\",(B15*B16*(B18/100))/(B17/100),\"\")","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,"G"]
["O)","Annual Cost Savings",null,null,null,"=","(M + N) * (I + J) / 2",null,null,null,"=",{"$f":"IF(B21=\"\",(L26+L28)*(B19+B20)/2,\"\")","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["P)","Simple Payback",null,null,null,"=","L",null,null,null,"=",{"$f":"IF(B21=\"\",B22/L30,\"\")","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"O"]
["Gas Heating Alternative:"]
["M)","Annual Cooling Savings",null,null,null,"=","A * 12,000 Btuh/Ton * B * D",null,null,null,"=",{"$f":"IF(B21=\"\",\"\",(B11*12000*B12*(B14/100))/(B13*1000))","v":""},null,"kWh/yr"]
[null,null,null,null,null,null,"C * 1,000 W/kW"]
["N)","Annual Heating Savings",null,null,null,"=","E * F * H * 3,413 Btuh/kW",null,null,null,"=",{"$f":"IF(B21=\"\",\"\",(B15*B16*(B18/100)*3413)/((B17/100)*1030000))","v":""},null,"kWh/yr"]
[null,null,null,null,null,null,"G * 1,030,000 Btu/Mcf"]
["O)","Annual Cost Savings",null,null,null,"=","M * (I + J) / 2 + N * K",null,null,null,"=",{"$f":"IF(B21=\"\",\"\",L35*(B19+B20)/2+L37*B21)","v":""},null,"$/yr"]
[]
["P)","Simple Payback",null,null,null,"=","L",null,null,null,"=",{"$f":"IF(B21=\"\",\"\",B22/L39)","v":""},null,"yrs"]
[null,null,null,null,null,null,"O"]

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