{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Light Conversion","Tables"],"not_rendered":{"charts":0,"images":1,"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":"Light Conversion","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,0,6,13],[26,6,27,9],[30,6,31,9],[32,6,32,9],[33,6,33,9],[30,13,31,13],[32,0,33,0],[32,1,33,4],[32,5,33,5],[32,10,33,10],[32,11,33,12],[32,13,33,13],[30,0,31,0],[30,1,31,4],[30,5,31,5],[30,10,31,10],[24,11,25,12],[24,13,25,13],[30,11,31,12],[26,13,27,13],[28,0,29,0],[28,1,29,4],[28,5,29,5],[28,6,29,9],[28,10,29,10],[28,11,29,12],[28,13,29,13],[26,0,27,0],[26,1,27,4],[26,5,27,5],[26,10,27,10],[26,11,27,12],[24,0,25,0],[24,1,25,4],[24,5,25,5],[24,6,25,9],[24,10,25,10],[21,0,21,13],[22,0,23,0],[22,1,23,4],[22,5,23,5],[22,6,23,9],[22,10,23,10],[22,11,23,12],[22,13,23,13],[19,1,19,2],[19,3,19,4],[19,5,19,12],[17,1,17,2],[17,3,17,4],[17,5,17,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],[13,1,13,2],[13,3,13,4],[13,5,13,12],[14,1,14,2],[14,3,14,4],[14,5,14,12],[7,0,7,13],[8,0,8,13],[11,0,11,4],[11,5,11,12],[12,1,12,2],[12,3,12,4],[12,5,12,12],[9,0,9,13],[5,0,5,13],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13]]}
["Street/Security Lighting Conversion"]
[]
[]
["Description of UCRM:",null,null,null,"(Data needed:  location, use, age of fixtures, type of existing fixture, type of new fixture,"]
["fc, level before conversion, estimated fc level after conversion1)"]
[]
[]
[]
[]
["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,"Luminaires",null,"Total Number of Luminaires Involved"]
["B)",null,null,"$/mo",null,"Existing Monthly Electrical Base Cost per Luminaire"]
["C)",null,null,"$/mo",null,"Replacement Monthly Electrical Base Cost per Luminaire"]
["D)",null,null,"kWh/mo",null,"Existing Monthly Electrical Consumption",null,null,null,null,null,null,null,"Table 12"]
["E)",null,null,"kWh/mo",null,"Replacement Monthly Electrical Consumption",null,null,null,null,null,null,null,"Table 12"]
["F)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["G)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["H)",null,null,"$/Luminaire",null,"Installed Cost per Luminaire/Lamp/Ballast Combination"]
[]
["Calculations"]
["I)","Annual Base Cost Savings",null,null,null,"=","A * 12 mos/yr * (B - C)",null,null,null,"=",{"$f":"B13*12*(B14-B15)","v":0},null,"$/yr"]
[]
["J)","Annual Electrical Energy Savings",null,null,null,"=","A * 12 mos/yr * (D - E)",null,null,null,"=",{"$f":"B13*12*(B16-B17)","v":0},null,"kWh/yr"]
[]
["K)","Annual Electrical Cost Savings",null,null,null,"=","J * (F + G)/2",null,null,null,"=",{"$f":"L25*(B18+B19)/2","v":0},null,"$/yr"]
[]
["L)","Annual Cost Savings",null,null,null,"=","I + K",null,null,null,"=",{"$f":"L23+L27","v":0},null,"$/yr"]
[]
["M)","Implementation Cost",null,null,null,"=","A * H",null,null,null,"=",{"$f":"B13*B20","v":0},null,"$"]
[]
["N)","Simple Payback",null,null,null,"=","M",null,null,null,"=",{"$f":"L31/L29","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"L"]

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