{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Interior Relamping","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":"Interior Relamping","index":0,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[28,1,28,2],[28,3,28,4],[28,5,28,12],[26,1,26,2],[26,3,26,4],[26,5,26,12],[27,1,27,2],[27,3,27,4],[27,5,27,12],[24,1,24,2],[24,3,24,4],[24,5,24,12],[25,1,25,2],[25,3,25,4],[25,5,25,12],[54,0,54,13],[55,0,55,13],[51,6,51,9],[51,10,52,10],[51,11,52,12],[51,13,52,13],[23,1,23,2],[23,3,23,4],[23,5,23,12],[52,6,52,9],[22,1,22,2],[22,3,22,4],[22,5,22,12],[51,0,52,0],[51,1,52,4],[51,5,52,5],[21,1,21,2],[21,3,21,4],[21,5,21,12],[20,1,20,2],[20,3,20,4],[20,5,20,12],[49,0,50,0],[49,1,50,4],[49,5,50,5],[47,10,48,10],[47,11,48,12],[47,13,48,13],[19,1,19,2],[19,3,19,4],[19,5,19,12],[18,1,18,2],[18,3,18,4],[18,5,18,12],[47,0,48,0],[47,1,48,4],[47,5,48,5],[49,6,50,9],[49,10,50,10],[49,11,50,12],[49,13,50,13],[45,6,46,9],[45,10,46,10],[45,11,46,12],[45,13,46,13],[17,1,17,2],[17,3,17,4],[17,5,17,12],[43,13,44,13],[15,1,15,2],[15,3,15,4],[15,5,15,12],[16,1,16,2],[16,3,16,4],[16,5,16,12],[45,0,46,0],[45,1,46,4],[45,5,46,5],[43,0,44,0],[43,1,44,4],[43,5,44,5],[43,6,44,9],[43,10,44,10],[43,11,44,12],[47,6,48,9],[14,5,14,12],[39,13,40,13],[12,0,12,4],[12,5,12,12],[41,0,42,0],[41,1,42,4],[41,5,42,5],[41,10,42,10],[41,11,42,12],[41,13,42,13],[37,10,38,10],[37,11,38,12],[37,13,38,13],[9,0,9,13],[10,0,10,8],[39,0,40,0],[39,1,40,4],[39,5,40,5],[39,6,40,9],[39,10,40,10],[39,11,40,12],[33,10,34,10],[33,11,34,12],[33,13,34,13],[4,0,4,13],[5,0,5,13],[35,0,36,0],[35,1,36,4],[35,5,36,5],[35,6,35,9],[35,10,36,10],[35,11,36,12],[35,13,36,13],[36,6,36,9],[0,0,0,13],[30,0,30,13],[1,0,1,13],[31,0,32,0],[31,1,32,4],[31,5,32,5],[31,6,31,9],[31,10,32,10],[31,11,32,12],[31,13,32,13],[29,1,29,2],[29,3,29,4],[29,5,29,12],[6,0,6,13],[41,6,41,9],[42,6,42,9],[32,6,32,9],[3,0,3,3],[3,4,3,13],[33,0,34,0],[33,1,34,4],[33,5,34,5],[33,6,34,9],[7,0,7,13],[8,0,8,13],[37,0,38,0],[37,1,38,4],[37,5,38,5],[37,6,38,9],[13,1,13,2],[13,3,13,4],[13,5,13,12],[14,1,14,2],[14,3,14,4]]}
["Interior Fixture Relamping/Replacing"]
["(Electric Cooling and Gas Heating)"]
[]
["Description of UCRM:",null,null,null,"(Data needed: area of building, use, typical existing light level at table height, type of"]
["existing lamp and ballast, type of replacement lamp and ballast, estimated light level after conversion1, and"]
["recommended light level)"]
[]
[]
[]
[]
["1Assume that lumens before/lumens after = fc before/fc after"]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"hrs/yr",null,"Summer Operating Hours"]
["B)",null,null,"hrs/yr",null,"Winter Operating Hours"]
["C)",null,null,"Lamps",null,"Total Number of Lamps - Old"]
["D)",null,null,"Lamps",null,"Total Number of Lamps - New"]
["E)",null,null,"Watts/Fixture",null,"Old Lamp and Ballast Wattage",null,null,null,null,null,null,null,"Table 12"]
["F)",null,null,"Watts/Fixture",null,"New Lamp and Ballast Wattage",null,null,null,null,null,null,null,"Table 12"]
["G)",null,null,"Btuh/Watt",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1"]
["H)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["I)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["J)",null,null,"$/kW",null,"Electrical Energy Rate - Summer"]
["K)",null,null,"$/kW",null,"Electrical Energy Rate - Winter"]
["L)",null,null,"%",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3"]
["M)",null,null,"$/Mcf",null,"Natural Gas Rate"]
["N)",null,null,null,null,"Seasonal Heating Factor",null,null,null,null,null,null,null,"Table 4"]
["O)",null,null,null,null,"Seasonal Cooling Factor",null,null,null,null,null,null,null,"Table 4"]
["P)",null,null,"$/Lamp",null,"New Lamp Cost"]
["Q)",null,null,"$/Lamp",null,"Labor Cost for Lamp Replacement"]
["Calculations"]
["R)","Lighting Electrical Demand Reduction",null,null,null,"=","(C * E) - (D * F)",null,null,null,"=",{"$f":"((B16*B18)-(B17*B19))/1000","v":0},null,"kW/mo"]
[null,null,null,null,null,null,1000]
["S)","Lighting Electrical Energy Savings",null,null,null,"=","R * (A + B)",null,null,null,"=",{"$f":"L32*(B14+B15)","v":0},null,"kWh/yr"]
[]
["T)","Cooling Electrical Energy Savings",null,null,null,"=","S * 3,413 Btu/kWh * O * 0.801",null,null,null,"=",{"$f":"(L34*3413*B28*0.8)/(B20*1000)","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,"G * 1000"]
["U)","Annual Electrical Energy Savings",null,null,null,"=","S + T",null,null,null,"=",{"$f":"L34+L36","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[]
["V)","Annual Electrical Cost Savings",null,null,null,"=","U * (H + I)/2 +12 * R * (J + K)/2",null,null,null,"=",{"$f":"L38*(B21+B22)/2+12*L32*(B23+B24)/2","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["W)","Natural Gas Heating Energy Cost Penalty",null,null,null,"=","S * 3,413Btu/kWh * N * M * 0.801",null,null,null,"=",{"$f":"(L34*3413*B27*B26*0.8)/((B25/100)*1030000)","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[null,null,null,null,null,null,"L * 1,030,000 Btu/Mcf"]
["X)","Annual Cost Savings",null,null,null,"=","V - W",null,null,null,"=",{"$f":"L40-L42","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["Y)","Lamp Cost",null,null,null,"=","P * D",null,null,null,"=",{"$f":"B29*B17","v":0},null,"$"]
[]
["Z)","Labor Cost",null,null,null,"=","Q * D",null,null,null,"=",{"$f":"B30*B17","v":0},null,"$"]
[]
["AA","Implementation Cost",null,null,null,"=","Y + Z",null,null,null,"=",{"$f":"L46+L48","v":0},null,"$"]
[]
["BB)","Simple Payback",null,null,null,"=","AA",null,null,null,"=",{"$f":"L50/L44","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"X"]
[]
["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":[]}