{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lighting Controls","Tables"],"not_rendered":{"charts":0,"images":4,"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":"Lighting Controls","index":0,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[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],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[15,0,16,0],[15,1,16,2],[15,5,15,12],[16,6,16,12],[17,1,17,2],[17,3,17,4],[17,5,17,12],[12,1,12,2],[12,3,12,4],[12,5,12,12],[13,0,14,0],[13,1,14,2],[13,5,13,12],[14,6,14,12],[28,13,29,13],[29,6,29,9],[30,0,31,0],[30,1,31,4],[30,5,31,5],[30,10,31,10],[30,11,31,12],[30,13,31,13],[20,1,20,2],[20,3,20,4],[20,5,20,12],[27,0,27,13],[28,0,29,0],[28,1,29,4],[28,5,29,5],[28,6,28,9],[28,10,29,10],[28,11,29,12],[32,13,33,13],[34,0,35,0],[34,1,35,4],[34,5,35,5],[34,10,35,10],[34,11,35,12],[34,13,35,13],[32,0,33,0],[32,1,33,4],[32,5,33,5],[32,6,33,9],[32,10,33,10],[32,11,33,12],[11,1,11,2],[21,3,21,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[18,1,18,2],[18,3,18,4],[19,1,19,2],[19,3,19,4],[11,5,11,12],[21,5,21,12],[22,5,22,12],[23,5,23,12],[24,5,24,12],[25,5,25,12],[13,3,14,4],[15,3,16,4],[11,3,11,4],[22,3,22,4],[18,5,18,12],[19,5,19,12],[38,0,39,0],[38,1,39,4],[38,5,39,5],[38,6,39,9],[38,10,39,10],[38,11,39,12],[38,13,39,13],[36,0,37,0],[36,1,37,4],[36,5,37,5],[36,6,36,9],[36,10,37,10],[36,11,37,12],[13,13,14,13],[45,0,45,13],[46,0,46,13],[30,6,30,9],[31,6,31,9],[34,6,35,9],[15,13,16,13],[40,13,41,13],[42,0,43,0],[42,1,43,4],[42,5,43,5],[42,6,42,9],[42,10,43,10],[42,11,43,12],[42,13,43,13],[43,6,43,9],[40,0,41,0],[40,1,41,4],[40,5,41,5],[40,6,41,9],[40,10,41,10],[40,11,41,12],[36,13,37,13],[37,6,37,9]]}
["Interior Lighting Controls"]
["(Electric Cooling and Gas Heating)"]
[]
["Description of UCRM:",null,null,null,"(Data needed:  type of lamps being controlled, use of space)"]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"Watts/Lamp",null,"Wattage of Lamps + Ballasts",null,null,null,null,null,null,null,"Table 12"]
["B)",null,null,"Lamps/Fixture",null,"Number of Lamps/Fixture",null,null,null,null,null,null,null,"Table 12"]
["C)",null,null,"Fixtures",null,"Total Number of Fixtures Controlled"]
["D)",null,null,"hrs/summer",null,"Reduction in  Summer Operating Hours Due to Controls"]
[null,null,null,null,null,"=","hrs/day * days/yr"]
["E)",null,null,"hrs/winter",null,"Reduction in  Winter Operating Hours Due to Controls"]
[null,null,null,null,null,"=","hrs/day * days/yr"]
["F)",null,null,"Btuh/Watt",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1"]
["G)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["H)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["I)",null,null,"%",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3"]
["J)",null,null,"$/Mcf",null,"Natural Gas Rate"]
["K)",null,null,null,null,"Seasonal Heating Factor",null,null,null,null,null,null,null,"Table 4"]
["L)",null,null,null,null,"Seasonal Cooling Factor",null,null,null,null,null,null,null,"Table 4"]
["M)",null,null,"$/Controller",null,"Installed Cost per Lighting Controller"]
["N)",null,null,"Controllers",null,"Number of Lighting Controllers Required"]
[]
["Calculations"]
["O)","Lighting Electrical Energy Savings",null,null,null,"=","A * B * C * (D + E)",null,null,null,"=",{"$f":"(B11*B12*B13*(B14+B16))/1000","v":0},null,"kWh/yr"]
[null,null,null,null,null,null,1000]
["P)","Cooling Electrical Energy Savings",null,null,null,"=","O * 3,413 Btu/kWh * L * 0.801",null,null,null,"=",{"$f":"(L29*3413*B24*0.8)/(B18*1000)","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,"F * 1000"]
["Q)","Annual Electrical Energy Savings",null,null,null,"=","O + P",null,null,null,"=",{"$f":"L29+L31","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[]
["R)","Annual Electrical Cost Savings",null,null,null,"=","Q * (G + H)/2",null,null,null,"=",{"$f":"L33*(B19+B20)/2","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["S)","Natural Gas Heating Cost Penalty1",null,null,null,"=","O * 3,413 Btu/kWh * J * K * 0.801",null,null,null,"=",{"$f":"(L29*3413*B22*B23*0.8)/((B21/100)*1030000)","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[null,null,null,null,null,null,"I * 1,030,000 Btu/Mcf"]
["T)","Annual Cost Savings",null,null,null,"=","R - S",null,null,null,"=",{"$f":"L35-L37","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["U)","Implementation Cost",null,null,null,"=","M * N",null,null,null,"=",{"$f":"B25*B26","v":0},null,"$"]
[]
["V)","Simple Payback",null,null,null,"=","U",null,null,null,"=",{"$f":"L41/L39","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"T"]
[]
["1Lighting cooling/heating load factor for 10-hour office use derived from data in Table 17B, pg. 26.23, 1981"]
["ASHRAE Handbook of Fundamentals"]

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