{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":63,"n_cols":7,"rows_kept":63,"merged":[[55,4,55,5],[56,4,56,5]]}
[null,"Energy Saving Payback Calculation "]
["Client ",{"$nulls":4},"Date"]
[]
[]
[]
[]
["Quantity ","Existing lighting ","Energy (Watts) ","Total Watts","Unit Cost","Cost to maintain","Annual Running Cost"]
[{"$nulls":3},{"$f":"A8*C8","v":0},null,{"$f":"E8*A8","v":0},{"$f":"C8/1000*A8*C26*C28","v":0}]
[{"$nulls":3},{"$f":"A9*C9","v":0},null,0,{"$f":"C9/1000*A9*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C10/1000*A10*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C11/1000*A11*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C12/1000*A12*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C13/1000*A13*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C14/1000*A14*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C15/1000*A15*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C16/1000*A16*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C17/1000*A17*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C18/1000*A18*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C19/1000*A19*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C20/1000*A20*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C21/1000*A21*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C22/1000*A22*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C23/1000*A23*C26*C28","v":0}]
[null,"Totals",{"$f":"SUM(C8:C23)","v":0},{"$f":"SUM(D8:D23)","v":0},{"$f":"SUM(E8:E23)","v":0},{"$f":"SUM(F8:F23)","v":0},{"$f":"SUM(G8:G23)","v":0}]
[{"$nulls":3},{"$f":"D24*C28/1000","v":0}]
[null,"Site Energy prices per kwh",{"v":0.22,"d":"£0.22"}]
[]
[null,"Site operating hour Annual",3500]
[]
["Quantity ","Proposed Lighting ","Energy (Watts) ","Total Watts","Unit Cost","Purchase Price","Annual Running Cost"]
[{"$nulls":3},{"$f":"A31*C31","v":0},null,{"$f":"E31*A31","v":0},{"$f":"C31/1000*A31*C26*C28","v":0}]
[{"$nulls":3},{"$f":"A32*C32","v":0},null,0,{"$f":"C32/1000*A32*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C33/1000*A33*C26*C28","v":0}]
[{"$nulls":3},0,null,{"$f":"E34*A34","v":0},{"$f":"C34/1000*A34*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C35/1000*A35*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C36/1000*A36*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C37/1000*A37*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C38/1000*A38*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C39/1000*A39*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C40/1000*A40*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C41/1000*A41*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C42/1000*A42*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C43/1000*A43*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C44/1000*A44*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C45/1000*A45*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C46/1000*A46*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C47/1000*A47*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C48/1000*A48*C26*C28","v":0}]
[{"$nulls":3},0,null,0,{"$f":"C49/1000*A49*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C50/1000*A50*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C51/1000*A51*C26*C28","v":0}]
[{"$nulls":5},0,{"$f":"C52/1000*A52*C26*C28","v":0}]
[null,"Totals",{"$f":"SUM(C31:C52)","v":0},{"$f":"SUM(D31:D52)","v":0},null,{"$f":"SUM(F31:F52)","v":0},{"$f":"SUM(G31:G52)","v":0}]
[{"$nulls":3},{"$f":"D53*C28/1000","v":0}]
[null,"Existing Running Cost Per Annum",{"$f":"G24","v":0}]
[null,"Cost to Maintain",{"$f":"F24","v":0},null,"Existing Power (watts)",null,{"$f":"D24","v":0}]
[null,"Proposed Running Cost per Annum",{"$f":"G53","v":0},null,"Proposed Power (Watts)",null,{"$f":"D53","v":0}]
[null,"Proposed Capital investment",{"$f":"F53","v":0}]
[null,"ECA Tax Off Set",{"$f":"F53*D59","v":0},null,null,"Savings"]
[null,"Energy Saved per Annum",{"$f":"C55+C56-C57","v":0}]
[null,"Payback Period in years",{"$f":"C58/C60","v":{"$error":"#DIV/0!"}},null,null,"£",{"$f":"M36-M56","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"kWh",{"$f":"D25-D54","v":0}]
[{"$nulls":5},"tC02",{"$f":"G62*0.54418/1000","v":{"v":0,"d":"0.0"}}]