{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Index","Data Input","Calculations","Results"],"not_rendered":{"images":6,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"merged":[[0,0,0,16],[1,0,1,16],[3,0,6,18]]}
["Electricity Pricing and Tariff Determination Model for Exempted Persons"]
[{"$f":"\"Exempted Person: \"&'Data Input'!D4","v":"Exempted Person: "}]
[]
["Exempted persons shall use this Model to calculate the electricity sales tariff to be charged from the consumers in their premises. The Model calculates the approximate cost of delivery of electricity to consumer installations in the exempted persons' premises on monthly basis and uses that to propose a sales tariff for its consumer installations."]

{"sheet":"Data Input","index":1,"n_rows":121,"n_cols":16,"rows_kept":121,"merged":[[0,2,1,2],[0,3,0,10],[1,3,1,10],[3,3,3,7],[4,3,4,7],[5,3,5,7],[6,3,6,7],[37,6,37,11],[42,3,42,5],[42,6,42,11],[44,5,44,9],[59,3,59,6],[60,11,61,14]]}
[null,null,"Data Input",{"$f":"\"Exempted Person: \"&'Data Input'!D4","v":"Exempted Person: "}]
[{"$nulls":3},{"$f":"\"Exemption Number:\"&D6","v":"Exemption Number:"}]
[]
[null,null,"Name of the Exempted Person"]
[null,null,"Address"]
[null,null,"Exemption Number"]
[null,null,"Date"]
[]
[null,null,"Electricity Purchase tariff"]
[null,null,"Select Tariff Category",null,"GP3"]
[null,null,"Maximum demand charge","Rs/kVA",{"$f":"IF(E10=\"GP1\",E62,IF(E10=\"GP2\",F62,IF(E10=\"GP3\",G62,IF(E10=\"I2\",I62,IF(E10=\"I3\",J62,IF(E10=\"I1\",H62))))))","v":{"v":1000,"d":"1,000"}}]
[null,null,"Energy charge -Peak","Rs/kWh",{"$f":"IF(E10=\"GP1\",E63,IF(E10=\"GP2\",F63,IF(E10=\"GP3\",G63,IF(E10=\"I2\",I63,IF(E10=\"I3\",J63,IF(E10=\"I1\",H63,))))))","v":{"v":25.5,"d":"25.50"}}]
[null,null,"Energy charge -Day","Rs/kWh",{"$f":"IF(E10=\"GP1\",E64,IF(E10=\"GP2\",F64,IF(E10=\"GP3\",G64,IF(E10=\"I2\",I64,IF(E10=\"I3\",J64,IF(E10=\"I1\",H64,))))))","v":{"v":20.7,"d":"20.70"}}]
[null,null,"Energy charge -Off-peak","Rs/kWh",{"$f":"IF(E10=\"GP1\",E65,IF(E10=\"GP2\",F65,IF(E10=\"GP3\",G65,IF(E10=\"I2\",I65,IF(E10=\"I3\",J65,IF(E10=\"I1\",H65,))))))","v":14.35}]
[null,null,"Fixed charge","Rs/Month",{"$f":"IF(E10=\"GP1\",E66,IF(E10=\"GP2\",F66,IF(E10=\"GP3\",G66,IF(E10=\"I2\",I66,IF(E10=\"I3\",J66,IF(E10=\"I1\",H66,))))))","v":{"v":3000,"d":"3,000"}}]
[]
[null,null,"Exemption processing fee paid to PUCSL","Rs"]
[]
[{"$nulls":4},"Jan","Feb","March","April","May","June","July","August","September","October","November","December"]
[null,null,"Maximum demand","kVA"]
[null,null,"Time at which maximum demand is recorded","Hrs"]
[null,null,"Total energy purchased from the grid","kWh",{"$f":"SUM(E23:E25)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Peak","kWh"]
[null,null,"Day","kWh"]
[null,null,"Off-peak","kWh"]
[null,null,"Total Number of customers (Occupied and unoccupied)",null,{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(P27:P29)","v":0}]
[null,null,"Residential","No"]
[null,null,"Commercial","No"]
[null,null,"Industrial","No"]
[null,null,"Total energy sales","kWh",{"$f":"SUM(E31:E33)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy sales-Residential","kWh"]
[null,null,"Energy sales-Commercial","kWh"]
[null,null,"Energy sales-Industrial","kWh"]
[null,null,"Share of energy use","Peak","Day","Off-peak"]
[null,null,"Residential"]
[null,null,"Commercial"]
[null,null,"Industrial"]
[{"$nulls":6},"Please adjust the respective percentages of energy use "]
[null,null,"Load characteristics ","Load factor ","Power factor ","Contribution to peak factor"]
[null,null,"Residential"]
[null,null,"Commercial"]
[null,null,"Industrial"]
[{"$nulls":6},"Please adjust the Load factor and Peak contributory factor  "]
[null,null,"Distribution system"]
[null,null,"Transformer energy  losses","%",null,"If you are a GP1, GP2, I1, or I2 customer please enter 0%"]
[null,null,"Technical losses","%"]
[null,null,"Non technical losses","%"]
[null,null,"Total O&M, billing  cost per annum","Rs"]
[null,null,"Standby generator "]
[null,null,"Voltage at which standby generator is connected"]
[null,null,"Total capacity of standby generators","kVA"]
[null,null,"Total no of units generated ","kWh"]
[null,null,"Total operation and maintance cost per annum","Rs"]
[null,null,"Standard fuel consumption","l/kWh"]
[null,null,"Price of Diesel","Rs/l"]
[null,null,"Fuel cost ","Rs/kWh",{"$f":"IFERROR(+E54*E55,0)","v":0},{"$f":"IFERROR(+F54*F55,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(+P54*P55,0)","v":0}]
[null,null,"Operation and maintenance cost","Rs/kWh",{"$f":"IFERROR($E$53/SUM($E$52:$P$52),0)","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,null,"Can your consumer electricity meters measure grid electricity and electricity from the standby generator seperately?  ","Yes"]
[]
[null,null,"Electricity Purchase Tariff","Update only in End Use Tariff Revisions"]
[null,null,"Tariff Category",null,"GP1","GP2","GP3","I1","I2","I3"]
[null,null,"Maximum demand charge","Rs/kVA",0,{"v":1100,"d":"1,100"},{"v":1000,"d":"1,000"},0,{"v":1100,"d":"1,100"},{"v":1000,"d":"1,000"}]
[null,null,"Energy charge -Peak","Rs/kWh",22.85,{"v":26.6,"d":"26.60"},{"v":25.5,"d":"25.50"},{"v":12.2,"d":"12.20"},{"v":20.5,"d":"20.50"},{"v":23.5,"d":"23.50"}]
[null,null,"Energy charge -Day","Rs/kWh",22.85,{"v":21.8,"d":"21.80"},{"v":20.7,"d":"20.70"},{"v":12.2,"d":"12.20"},{"v":11,"d":"11.00"},10.25]
[null,null,"Energy charge -Off-peak","Rs/kWh",22.85,{"v":15.4,"d":"15.40"},14.35,{"v":12.2,"d":"12.20"},6.85,{"v":5.9,"d":"5.90"}]
[null,null,"Fixed charge","Rs/Month",240,{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},600,{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"}]
{"$rows_empty":54}
[{"$nulls":4}," "]

{"sheet":"Calculations","index":2,"n_rows":102,"n_cols":17,"rows_kept":102,"merged":[[0,2,1,2],[0,3,0,10],[1,3,1,10],[4,2,4,3],[10,2,10,3],[14,2,14,3],[18,2,18,3],[23,2,23,3],[36,2,36,3],[40,2,40,3],[45,2,45,3],[49,2,49,3],[53,2,53,3],[57,2,57,3],[61,2,61,3],[69,2,69,3],[73,2,73,3],[77,2,77,3],[81,2,81,3],[96,0,96,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[100,0,100,1]]}
[null,null,"Calculations",{"$f":"\"Exempted Person: \"&'Data Input'!D4","v":"Exempted Person: "}]
[{"$nulls":3},{"$f":"\"Exemption Number:\"&'Data Input'!D6","v":"Exemption Number:"}]
[]
[{"$nulls":3},"Unit","Jan","Feb","March","April","May","June","July","August","September","October","November","December"]
[null,null,"Applicable purchase tariff"]
[null,null,"Fixed charge","Rs/Month",{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}},{"$f":"'Data Input'!$E$15","v":{"v":3000,"d":"3,000"}}]
[null,null,"Demand charge","Rs/kVA/Month",{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}},{"$f":"'Data Input'!$E$11","v":{"v":1000,"d":"1,000"}}]
[null,null,"Energy charge - Peak","Rs/kWh",{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}},{"$f":"'Data Input'!$E$12","v":{"v":25.5,"d":"25.50"}}]
[null,null,"Energy charge - Day","Rs/kWh",{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}},{"$f":"'Data Input'!$E$13","v":{"v":20.7,"d":"20.70"}}]
[null,null,"Energy charge - Off-peak","Rs/kWh",{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35},{"$f":"'Data Input'!$E$14","v":14.35}]
[null,null,"Total sales",null,{"$f":"SUM(E12:E14)","v":0},{"$f":"SUM(F12:F14)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Residential customers","kWh",{"$f":"'Data Input'!E31","v":0},{"$f":"'Data Input'!F31","v":0},{"$f":"'Data Input'!G31","v":0},{"$f":"'Data Input'!H31","v":0},{"$f":"'Data Input'!I31","v":0},{"$f":"'Data Input'!J31","v":0},{"$f":"'Data Input'!K31","v":0},{"$f":"'Data Input'!L31","v":0},{"$f":"'Data Input'!M31","v":0},{"$f":"'Data Input'!N31","v":0},{"$f":"'Data Input'!O31","v":0},{"$f":"'Data Input'!P31","v":0}]
[null,null,"Commercial customers","kWh",{"$f":"+'Data Input'!E32","v":0},{"$f":"+'Data Input'!F32","v":0},{"$f":"+'Data Input'!G32","v":0},{"$f":"+'Data Input'!H32","v":0},{"$f":"+'Data Input'!I32","v":0},{"$f":"+'Data Input'!J32","v":0},{"$f":"+'Data Input'!K32","v":0},{"$f":"+'Data Input'!L32","v":0},{"$f":"+'Data Input'!M32","v":0},{"$f":"+'Data Input'!N32","v":0},{"$f":"+'Data Input'!O32","v":0},{"$f":"+'Data Input'!P32","v":0}]
[null,null,"Industrial customers","kWh",{"$f":"+'Data Input'!E33","v":0},{"$f":"+'Data Input'!F33","v":0},{"$f":"+'Data Input'!G33","v":0},{"$f":"+'Data Input'!H33","v":0},{"$f":"+'Data Input'!I33","v":0},{"$f":"+'Data Input'!J33","v":0},{"$f":"+'Data Input'!K33","v":0},{"$f":"+'Data Input'!L33","v":0},{"$f":"+'Data Input'!M33","v":0},{"$f":"+'Data Input'!N33","v":0},{"$f":"+'Data Input'!O33","v":0},{"$f":"+'Data Input'!P33","v":0}]
[null,null,"Total energy required to meet the customer usage"]
[null,null,"Residential customers","kWh",{"$f":"'Data Input'!E31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!F31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!G31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!H31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!I31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!J31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!K31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!L31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!M31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!N31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!O31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!P31/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0}]
[null,null,"Commercial customers","kWh",{"$f":"'Data Input'!E32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!F32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!G32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!H32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!I32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!J32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!K32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!L32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!M32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!N32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!O32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!P32/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0}]
[null,null,"Industrial customers","kWh",{"$f":"'Data Input'!E33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!F33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!G33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!H33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!I33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!J33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!K33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!L33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!M33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!N33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!O33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0},{"$f":"'Data Input'!P33/(1-('Data Input'!$E$45+'Data Input'!$E$46+'Data Input'!$E$47))","v":0}]
[null,null,"Energy supplied by the grid (less SBG)"]
[null,null,"Total","kWh",{"$f":"SUM(E21:E23)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F21:F23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Residential customers","kWh",{"$f":"E16-E64","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Commercial customers","kWh",{"$f":"E17-E65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Industrial customers","kWh",{"$f":"E18-E66","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Usage of grid energy in TOU intervals"]
[null,null,"Residential - Total","kWh",{"$f":"SUM(E26:E28)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26:F28)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Residential -Peak","kWh",{"$f":"+E21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+F21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+G21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+H21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+I21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+J21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+K21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+L21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+M21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+N21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+O21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}},{"$f":"+P21*'Data Input'!$D$35","v":{"$error":"#DIV/0!"}}]
[null,null,"Residential - Day","kWh",{"$f":"+E21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+F21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+G21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+H21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+I21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+J21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+K21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+L21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+M21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+N21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+O21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}},{"$f":"+P21*'Data Input'!$E$35","v":{"$error":"#DIV/0!"}}]
[null,null,"Residential - Off-peak","kWh",{"$f":"+E21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+F21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+G21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+H21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+I21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+J21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+K21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+L21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+M21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+N21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+O21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}},{"$f":"+P21*'Data Input'!$F$35","v":{"$error":"#DIV/0!"}}]
[null,null,"Commercial - Total","kWh",{"$f":"SUM(E30:E32)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F30:F32)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Commercial - Peak","kWh",{"$f":"+E22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+F22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+G22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+H22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+I22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+J22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+K22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+L22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+M22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+N22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+O22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}},{"$f":"+P22*'Data Input'!$D$36","v":{"$error":"#DIV/0!"}}]
[null,null,"Commercial -Day","kWh",{"$f":"+E22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+F22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+G22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+H22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+I22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+J22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+K22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+L22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+M22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+N22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+O22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}},{"$f":"+P22*'Data Input'!$E$36","v":{"$error":"#DIV/0!"}}]
[null,null,"Commercial - Off-peak","kWh",{"$f":"+E22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+F22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+G22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+H22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+I22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+J22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+K22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+L22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+M22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+N22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+O22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}},{"$f":"+P22*'Data Input'!$F$36","v":{"$error":"#DIV/0!"}}]
[null,null,"Industrial - Total","kWh",{"$f":"SUM(E34:E36)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F34:F36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Industrial - Peak","kWh",{"$f":"+E23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+F23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+G23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+H23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+I23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+J23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+K23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+L23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+M23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+N23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+O23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}},{"$f":"+P23*'Data Input'!$D$37","v":{"$error":"#DIV/0!"}}]
[null,null,"Industrial - Day","kWh",{"$f":"+E23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+F23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+G23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+H23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+I23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+J23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+K23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+L23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+M23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+N23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+O23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}},{"$f":"+P23*'Data Input'!$E$37","v":{"$error":"#DIV/0!"}}]
[null,null,"Industrial - Off-peak","kWh",{"$f":"+E23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+F23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+G23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+H23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+I23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+J23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+K23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+L23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+M23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+N23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+O23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}},{"$f":"+P23*'Data Input'!$F$37","v":{"$error":"#DIV/0!"}}]
[null,null,"TOU Total calculated grid purchases"]
[null,null,"Peak","kWh",{"$f":"SUM(E26,E30,E34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26,F30,F34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Day","kWh",{"$f":"SUM(E27,E31,E35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F27,F31,F35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Off-peak","kWh",{"$f":"SUM(E28,E32,E36)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F28,F32,F36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Total actual grid purchases"]
[null,null,"Peak","kWh",{"$f":"'Data Input'!E23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!F23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!G23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!H23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!I23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!J23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!K23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!L23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!M23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!N23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!O23","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!P23","v":{"v":0,"d":"0 "}}]
[null,null,"Day","kWh",{"$f":"'Data Input'!E24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!F24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!G24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!H24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!I24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!J24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!K24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!L24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!M24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!N24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!O24","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!P24","v":{"v":0,"d":"0 "}}]
[null,null,"Off-peak","kWh",{"$f":"'Data Input'!E25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!F25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!G25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!H25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!I25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!J25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!K25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!L25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!M25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!N25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!O25","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!P25","v":{"v":0,"d":"0 "}}]
[null,null,"Maximum Demand","kVA",{"$f":"'Data Input'!E20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!F20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!G20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!H20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!I20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!J20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!K20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!L20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!M20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!N20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!O20","v":{"v":0,"d":"0 "}},{"$f":"'Data Input'!P20","v":{"v":0,"d":"0 "}}]
[null,null,"Individual peak demand of the customers "]
[null,null,"Residential customers","kVA",{"$f":"IF('Data Input'!E31=0,0,(E25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!F31=0,0,(F25/('Data Input'!$E$40*'Data Input'!$D$40*28*24)))","v":0},{"$f":"IF('Data Input'!G31=0,0,(G25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!H31=0,0,(H25/('Data Input'!$E$40*'Data Input'!$D$40*30*24)))","v":0},{"$f":"IF('Data Input'!I31=0,0,(I25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!J31=0,0,(J25/('Data Input'!$E$40*'Data Input'!$D$40*30*24)))","v":0},{"$f":"IF('Data Input'!K31=0,0,(K25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!L31=0,0,(L25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!M31=0,0,(M25/('Data Input'!$E$40*'Data Input'!$D$40*30*24)))","v":0},{"$f":"IF('Data Input'!N31=0,0,(N25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0},{"$f":"IF('Data Input'!O31=0,0,(O25/('Data Input'!$E$40*'Data Input'!$D$40*30*24)))","v":0},{"$f":"IF('Data Input'!P31=0,0,(P25/('Data Input'!$E$40*'Data Input'!$D$40*31*24)))","v":0}]
[null,null,"Commercial customers","kVA",{"$f":"IF('Data Input'!E32=0,0,(E29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!F32=0,0,(F29/('Data Input'!$D$41*'Data Input'!$E$41*24*28)))","v":0},{"$f":"IF('Data Input'!G32=0,0,(G29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!H32=0,0,(H29/('Data Input'!$D$41*'Data Input'!$E$41*24*30)))","v":0},{"$f":"IF('Data Input'!I32=0,0,(I29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!J32=0,0,(J29/('Data Input'!$D$41*'Data Input'!$E$41*24*30)))","v":0},{"$f":"IF('Data Input'!K32=0,0,(K29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!L32=0,0,(L29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!M32=0,0,(M29/('Data Input'!$D$41*'Data Input'!$E$41*24*30)))","v":0},{"$f":"IF('Data Input'!N32=0,0,(N29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0},{"$f":"IF('Data Input'!O32=0,0,(O29/('Data Input'!$D$41*'Data Input'!$E$41*24*30)))","v":0},{"$f":"IF('Data Input'!P32=0,0,(P29/('Data Input'!$D$41*'Data Input'!$E$41*24*31)))","v":0}]
[null,null,"Industrial customers","kVA",{"$f":"IF('Data Input'!E33=0,0,(E33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!F33=0,0,(F33/('Data Input'!$D$42*'Data Input'!$E$42*24*28)))","v":0},{"$f":"IF('Data Input'!G33=0,0,(G33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!H33=0,0,(H33/('Data Input'!$D$42*'Data Input'!$E$42*24*30)))","v":0},{"$f":"IF('Data Input'!I33=0,0,(I33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!J33=0,0,(J33/('Data Input'!$D$42*'Data Input'!$E$42*24*30)))","v":0},{"$f":"IF('Data Input'!K33=0,0,(K33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!L33=0,0,(L33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!M33=0,0,(M33/('Data Input'!$D$42*'Data Input'!$E$42*24*30)))","v":0},{"$f":"IF('Data Input'!N33=0,0,(N33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0},{"$f":"IF('Data Input'!O33=0,0,(O33/('Data Input'!$D$42*'Data Input'!$E$42*24*30)))","v":0},{"$f":"IF('Data Input'!P33=0,0,(P33/('Data Input'!$D$42*'Data Input'!$E$42*24*31)))","v":0}]
[null,null,"Customer's peak coincident with EP peak",null,{"$f":"SUM(E51:E53)","v":0},{"$f":"SUM(F51:F53)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Residential customers","kVA",{"$f":"+E47*'Data Input'!$F$40","v":0},{"$f":"+F47*'Data Input'!$F$40","v":0},{"$f":"+G47*'Data Input'!$F$40","v":0},{"$f":"+H47*'Data Input'!$F$40","v":0},{"$f":"+I47*'Data Input'!$F$40","v":0},{"$f":"+J47*'Data Input'!$F$40","v":0},{"$f":"+K47*'Data Input'!$F$40","v":0},{"$f":"+L47*'Data Input'!$F$40","v":0},{"$f":"+M47*'Data Input'!$F$40","v":0},{"$f":"+N47*'Data Input'!$F$40","v":0},{"$f":"+O47*'Data Input'!$F$40","v":0},{"$f":"+P47*'Data Input'!$F$40","v":0}]
[null,null,"Commercial customers","kVA",{"$f":"+E48*'Data Input'!$F$41","v":0},{"$f":"+F48*'Data Input'!$F$41","v":0},{"$f":"+G48*'Data Input'!$F$41","v":0},{"$f":"+H48*'Data Input'!$F$41","v":0},{"$f":"+I48*'Data Input'!$F$41","v":0},{"$f":"+J48*'Data Input'!$F$41","v":0},{"$f":"+K48*'Data Input'!$F$41","v":0},{"$f":"+L48*'Data Input'!$F$41","v":0},{"$f":"+M48*'Data Input'!$F$41","v":0},{"$f":"+N48*'Data Input'!$F$41","v":0},{"$f":"+O48*'Data Input'!$F$41","v":0},{"$f":"+P48*'Data Input'!$F$41","v":0}]
[null,null,"Industrial customers","kVA",{"$f":"+E49*'Data Input'!$F$42","v":0},{"$f":"+F49*'Data Input'!$F$42","v":0},{"$f":"+G49*'Data Input'!$F$42","v":0},{"$f":"+H49*'Data Input'!$F$42","v":0},{"$f":"+I49*'Data Input'!$F$42","v":0},{"$f":"+J49*'Data Input'!$F$42","v":0},{"$f":"+K49*'Data Input'!$F$42","v":0},{"$f":"+L49*'Data Input'!$F$42","v":0},{"$f":"+M49*'Data Input'!$F$42","v":0},{"$f":"+N49*'Data Input'!$F$42","v":0},{"$f":"+O49*'Data Input'!$F$42","v":0},{"$f":"+P49*'Data Input'!$F$42","v":0}]
[null,null,"Energy (from grid) cost calculation"]
[null,null,"Residential ","Rs",{"$f":"(E26*E8)+(E27*E9)+(E28*E10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Commercial","Rs",{"$f":"(E30*E8)+(E31*E9)+(E32*E10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Industrial","Rs",{"$f":"(E34*E8)+(E35*E9)+(E36*E10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Demand cost calculation "]
[null,null,"Residential customers","Rs",{"$f":"+E51*E$7","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Commercial customers","Rs",{"$f":"+E52*E$7","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Industrial customers","Rs",{"$f":"+E53*E$7","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Standby generation (SBG) cost calculation"]
[null,null,"Standby generation/(total purchases+standby gen)",null,{"$f":"+'Data Input'!E52/('Data Input'!E22+'Data Input'!E52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!F52/('Data Input'!F22+'Data Input'!F52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!G52/('Data Input'!G22+'Data Input'!G52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!H52/('Data Input'!H22+'Data Input'!H52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!I52/('Data Input'!I22+'Data Input'!I52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!J52/('Data Input'!J22+'Data Input'!J52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!K52/('Data Input'!K22+'Data Input'!K52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!L52/('Data Input'!L22+'Data Input'!L52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!M52/('Data Input'!M22+'Data Input'!M52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!N52/('Data Input'!N22+'Data Input'!N52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!O52/('Data Input'!O22+'Data Input'!O52)","v":{"$error":"#DIV/0!"}},{"$f":"+'Data Input'!P52/('Data Input'!P22+'Data Input'!P52)","v":{"$error":"#DIV/0!"}}]
[null,null,"SBG Units - Residential","kWh",{"$f":"E63*E16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"SBG  Units - Commercial","kWh",{"$f":"E63*E17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"SBG Units - Industrial","kWh",{"$f":"E63*E18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"SBG Energy Cost - Residential ","Rs",{"$f":"+E64*('Data Input'!E$56+'Data Input'!E57)","v":{"$error":"#DIV/0!"}},{"$f":"+F64*('Data Input'!F$56+'Data Input'!F57)","v":{"$error":"#DIV/0!"}},{"$f":"+G64*('Data Input'!G$56+'Data Input'!G57)","v":{"$error":"#DIV/0!"}},{"$f":"+H64*('Data Input'!H$56+'Data Input'!H57)","v":{"$error":"#DIV/0!"}},{"$f":"+I64*('Data Input'!I$56+'Data Input'!I57)","v":{"$error":"#DIV/0!"}},{"$f":"+J64*('Data Input'!J$56+'Data Input'!J57)","v":{"$error":"#DIV/0!"}},{"$f":"+K64*('Data Input'!K$56+'Data Input'!K57)","v":{"$error":"#DIV/0!"}},{"$f":"+L64*('Data Input'!L$56+'Data Input'!L57)","v":{"$error":"#DIV/0!"}},{"$f":"+M64*('Data Input'!M$56+'Data Input'!M57)","v":{"$error":"#DIV/0!"}},{"$f":"+N64*('Data Input'!N$56+'Data Input'!N57)","v":{"$error":"#DIV/0!"}},{"$f":"+O64*('Data Input'!O$56+'Data Input'!O57)","v":{"$error":"#DIV/0!"}},{"$f":"+P64*('Data Input'!P$56+'Data Input'!P57)","v":{"$error":"#DIV/0!"}}]
[null,null,"SBG Energy Cost -Commercial ","Rs",{"$f":"+E65*('Data Input'!E$56+'Data Input'!E57)","v":{"$error":"#DIV/0!"}},{"$f":"+F65*('Data Input'!F$56+'Data Input'!F57)","v":{"$error":"#DIV/0!"}},{"$f":"+G65*('Data Input'!G$56+'Data Input'!G57)","v":{"$error":"#DIV/0!"}},{"$f":"+H65*('Data Input'!H$56+'Data Input'!H57)","v":{"$error":"#DIV/0!"}},{"$f":"+I65*('Data Input'!I$56+'Data Input'!I57)","v":{"$error":"#DIV/0!"}},{"$f":"+J65*('Data Input'!J$56+'Data Input'!J57)","v":{"$error":"#DIV/0!"}},{"$f":"+K65*('Data Input'!K$56+'Data Input'!K57)","v":{"$error":"#DIV/0!"}},{"$f":"+L65*('Data Input'!L$56+'Data Input'!L57)","v":{"$error":"#DIV/0!"}},{"$f":"+M65*('Data Input'!M$56+'Data Input'!M57)","v":{"$error":"#DIV/0!"}},{"$f":"+N65*('Data Input'!N$56+'Data Input'!N57)","v":{"$error":"#DIV/0!"}},{"$f":"+O65*('Data Input'!O$56+'Data Input'!O57)","v":{"$error":"#DIV/0!"}},{"$f":"+P65*('Data Input'!P$56+'Data Input'!P57)","v":{"$error":"#DIV/0!"}}]
[null,null,"SBG Energy Cost - Industrial ","Rs",{"$f":"+E66*('Data Input'!E$56+'Data Input'!E57)","v":{"$error":"#DIV/0!"}},{"$f":"+F66*('Data Input'!F$56+'Data Input'!F57)","v":{"$error":"#DIV/0!"}},{"$f":"+G66*('Data Input'!G$56+'Data Input'!G57)","v":{"$error":"#DIV/0!"}},{"$f":"+H66*('Data Input'!H$56+'Data Input'!H57)","v":{"$error":"#DIV/0!"}},{"$f":"+I66*('Data Input'!I$56+'Data Input'!I57)","v":{"$error":"#DIV/0!"}},{"$f":"+J66*('Data Input'!J$56+'Data Input'!J57)","v":{"$error":"#DIV/0!"}},{"$f":"+K66*('Data Input'!K$56+'Data Input'!K57)","v":{"$error":"#DIV/0!"}},{"$f":"+L66*('Data Input'!L$56+'Data Input'!L57)","v":{"$error":"#DIV/0!"}},{"$f":"+M66*('Data Input'!M$56+'Data Input'!M57)","v":{"$error":"#DIV/0!"}},{"$f":"+N66*('Data Input'!N$56+'Data Input'!N57)","v":{"$error":"#DIV/0!"}},{"$f":"+O66*('Data Input'!O$56+'Data Input'!O57)","v":{"$error":"#DIV/0!"}},{"$f":"+P66*('Data Input'!P$56+'Data Input'!P57)","v":{"$error":"#DIV/0!"}}]
[null,null,"Overall fixed charge calculation"]
[null,null,"Residential customers","Rs",{"$f":"(+'Data Input'!$E$48/12*E47/E45)+((E6+('Data Input'!$E$17/12))*'Data Input'!E27/'Data Input'!E26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*F47/F45)+((F6+('Data Input'!$E$17/12))*'Data Input'!F27/'Data Input'!F26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*G47/G45)+((G6+('Data Input'!$E$17/12))*'Data Input'!G27/'Data Input'!G26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*H47/H45)+((H6+('Data Input'!$E$17/12))*'Data Input'!H27/'Data Input'!H26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*I47/I45)+((I6+('Data Input'!$E$17/12))*'Data Input'!I27/'Data Input'!I26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*J47/J45)+((J6+('Data Input'!$E$17/12))*'Data Input'!J27/'Data Input'!J26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*K47/K45)+((K6+('Data Input'!$E$17/12))*'Data Input'!K27/'Data Input'!K26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*L47/L45)+((L6+('Data Input'!$E$17/12))*'Data Input'!L27/'Data Input'!L26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*M47/M45)+((M6+('Data Input'!$E$17/12))*'Data Input'!M27/'Data Input'!M26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*N47/N45)+((N6+('Data Input'!$E$17/12))*'Data Input'!N27/'Data Input'!N26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*O47/O45)+((O6+('Data Input'!$E$17/12))*'Data Input'!O27/'Data Input'!O26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*P47/P45)+((P6+('Data Input'!$E$17/12))*'Data Input'!P27/'Data Input'!P26)","v":{"$error":"#DIV/0!"}}]
[null,null,"Commercial customers","Rs",{"$f":"(+'Data Input'!$E$48/12*E48/E45)+((E6+('Data Input'!$E$17/12))*'Data Input'!E28/'Data Input'!E26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*F48/F45)+((F6+('Data Input'!$E$17/12))*'Data Input'!F28/'Data Input'!F26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*G48/G45)+((G6+('Data Input'!$E$17/12))*'Data Input'!G28/'Data Input'!G26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*H48/H45)+((H6+('Data Input'!$E$17/12))*'Data Input'!H28/'Data Input'!H26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*I48/I45)+((I6+('Data Input'!$E$17/12))*'Data Input'!I28/'Data Input'!I26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*J48/J45)+((J6+('Data Input'!$E$17/12))*'Data Input'!J28/'Data Input'!J26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*K48/K45)+((K6+('Data Input'!$E$17/12))*'Data Input'!K28/'Data Input'!K26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*L48/L45)+((L6+('Data Input'!$E$17/12))*'Data Input'!L28/'Data Input'!L26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*M48/M45)+((M6+('Data Input'!$E$17/12))*'Data Input'!M28/'Data Input'!M26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*N48/N45)+((N6+('Data Input'!$E$17/12))*'Data Input'!N28/'Data Input'!N26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*O48/O45)+((O6+('Data Input'!$E$17/12))*'Data Input'!O28/'Data Input'!O26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*P48/P45)+((P6+('Data Input'!$E$17/12))*'Data Input'!P28/'Data Input'!P26)","v":{"$error":"#DIV/0!"}}]
[null,null,"Industrial customers","Rs",{"$f":"(+'Data Input'!$E$48/12*E49/E45)+((E8+('Data Input'!$E$17/12))*'Data Input'!E29/'Data Input'!E26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*F49/F45)+((F8+('Data Input'!$E$17/12))*'Data Input'!F29/'Data Input'!F26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*G49/G45)+((G8+('Data Input'!$E$17/12))*'Data Input'!G29/'Data Input'!G26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*H49/H45)+((H8+('Data Input'!$E$17/12))*'Data Input'!H29/'Data Input'!H26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*I49/I45)+((I8+('Data Input'!$E$17/12))*'Data Input'!I29/'Data Input'!I26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*J49/J45)+((J8+('Data Input'!$E$17/12))*'Data Input'!J29/'Data Input'!J26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*K49/K45)+((K8+('Data Input'!$E$17/12))*'Data Input'!K29/'Data Input'!K26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*L49/L45)+((L8+('Data Input'!$E$17/12))*'Data Input'!L29/'Data Input'!L26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*M49/M45)+((M8+('Data Input'!$E$17/12))*'Data Input'!M29/'Data Input'!M26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*N49/N45)+((N8+('Data Input'!$E$17/12))*'Data Input'!N29/'Data Input'!N26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*O49/O45)+((O8+('Data Input'!$E$17/12))*'Data Input'!O29/'Data Input'!O26)","v":{"$error":"#DIV/0!"}},{"$f":"(+'Data Input'!$E$48/12*P49/P45)+((P8+('Data Input'!$E$17/12))*'Data Input'!P29/'Data Input'!P26)","v":{"$error":"#DIV/0!"}}]
[null,null,"Overall grid energy cost calculation"]
[null,null,"Residential customers","Rs",{"$f":"SUM(E55,E59)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F55,F59)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Commercial customers","Rs",{"$f":"SUM(E56,E60)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Industrial customers","Rs",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Overall energy cost calculation"]
[null,null,"Residential customers","Rs",{"$f":"+E55+E59+E67","v":{"$error":"#DIV/0!"}},{"$f":"+F55+F59+F67","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Commercial customers","Rs",{"$f":"+E56+E60+E68","v":{"$error":"#DIV/0!"}},{"$f":"+F56+F60+F68","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Industrial customers","Rs",{"$f":"+E57+E61+E69","v":{"$error":"#DIV/0!"}},{"$f":"+F57+F61+F69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Tariff proposed for customers",{"$nulls":13},"Average"]
[null,null,"Fixed charge - Residential","Rs/Month",{"$f":"IFERROR(E71/'Data Input'!E27,0)","v":0},{"$f":"IFERROR(F71/'Data Input'!F27,0)","v":0},{"$f":"IFERROR(G71/'Data Input'!G27,0)","v":0},{"$f":"IFERROR(H71/'Data Input'!H27,0)","v":0},{"$f":"IFERROR(I71/'Data Input'!I27,0)","v":0},{"$f":"IFERROR(J71/'Data Input'!J27,0)","v":0},{"$f":"IFERROR(K71/'Data Input'!K27,0)","v":0},{"$f":"IFERROR(L71/'Data Input'!L27,0)","v":0},{"$f":"IFERROR(M71/'Data Input'!M27,0)","v":0},{"$f":"IFERROR(N71/'Data Input'!N27,0)","v":0},{"$f":"IFERROR(O71/'Data Input'!O27,0)","v":0},{"$f":"IFERROR(P71/'Data Input'!P27,0)","v":0},{"$f":"+AVERAGE((E83:P83))","v":0}]
[null,null,"Fixed charge - Commercial","Rs/Month",{"$f":"IFERROR(E72/'Data Input'!E28,0)","v":0},{"$f":"IFERROR(F72/'Data Input'!F28,0)","v":0},{"$f":"IFERROR(G72/'Data Input'!G28,0)","v":0},{"$f":"IFERROR(H72/'Data Input'!H28,0)","v":0},{"$f":"IFERROR(I72/'Data Input'!I28,0)","v":0},{"$f":"IFERROR(J72/'Data Input'!J28,0)","v":0},{"$f":"IFERROR(K72/'Data Input'!K28,0)","v":0},{"$f":"IFERROR(L72/'Data Input'!L28,0)","v":0},{"$f":"IFERROR(M72/'Data Input'!M28,0)","v":0},{"$f":"IFERROR(N72/'Data Input'!N28,0)","v":0},{"$f":"IFERROR(O72/'Data Input'!O28,0)","v":0},{"$f":"IFERROR(P72/'Data Input'!P28,0)","v":0},0]
[null,null,"Fixed charge - Industrial","Rs/Month",{"$f":"IFERROR(E73/'Data Input'!E29,0)","v":0},{"$f":"IFERROR(F73/'Data Input'!F29,0)","v":0},{"$f":"IFERROR(G73/'Data Input'!G29,0)","v":0},{"$f":"IFERROR(H73/'Data Input'!H29,0)","v":0},{"$f":"IFERROR(I73/'Data Input'!I29,0)","v":0},{"$f":"IFERROR(J73/'Data Input'!J29,0)","v":0},{"$f":"IFERROR(K73/'Data Input'!K29,0)","v":0},{"$f":"IFERROR(L73/'Data Input'!L29,0)","v":0},{"$f":"IFERROR(M73/'Data Input'!M29,0)","v":0},{"$f":"IFERROR(N73/'Data Input'!N29,0)","v":0},{"$f":"IFERROR(O73/'Data Input'!O29,0)","v":0},{"$f":"IFERROR(P73/'Data Input'!P29,0)","v":0},0]
[null,null,"Energy charge - Residential","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",E79/E12,IF('Data Input'!$D$58=\"Yes\", E75/(E12-E64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",F79/F12,IF('Data Input'!$D$58=\"Yes\", F75/(F12-F64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",G79/G12,IF('Data Input'!$D$58=\"Yes\", G75/(G12-G64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",H79/H12,IF('Data Input'!$D$58=\"Yes\", H75/(H12-H64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",I79/I12,IF('Data Input'!$D$58=\"Yes\", I75/(I12-I64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",J79/J12,IF('Data Input'!$D$58=\"Yes\", J75/(J12-J64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",K79/K12,IF('Data Input'!$D$58=\"Yes\", K75/(K12-K64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",L79/L12,IF('Data Input'!$D$58=\"Yes\", L75/(L12-L64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",M79/M12,IF('Data Input'!$D$58=\"Yes\", M75/(M12-M64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",N79/N12,IF('Data Input'!$D$58=\"Yes\", N75/(N12-N64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",O79/O12,IF('Data Input'!$D$58=\"Yes\", O75/(O12-O64))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",P79/P12,IF('Data Input'!$D$58=\"Yes\", P75/(P12-P64))),0)","v":0},{"$f":"IF(OR(C97=1,C98=1,C99=1,C100=1,C101=1,C102=1),0,+AVERAGE((E86:P86)))","v":{"$error":"#DIV/0!"}}]
[null,null,"Energy charge - Commercial ","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",E80/E13,IF('Data Input'!$D$58=\"Yes\", E76/(E13-E65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",F80/F13,IF('Data Input'!$D$58=\"Yes\", F76/(F13-F65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",G80/G13,IF('Data Input'!$D$58=\"Yes\", G76/(G13-G65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",H80/H13,IF('Data Input'!$D$58=\"Yes\", H76/(H13-H65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",I80/I13,IF('Data Input'!$D$58=\"Yes\", I76/(I13-I65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",J80/J13,IF('Data Input'!$D$58=\"Yes\", J76/(J13-J65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",K80/K13,IF('Data Input'!$D$58=\"Yes\", K76/(K13-K65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",L80/L13,IF('Data Input'!$D$58=\"Yes\", L76/(L13-L65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",M80/M13,IF('Data Input'!$D$58=\"Yes\", M76/(M13-M65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",N80/N13,IF('Data Input'!$D$58=\"Yes\", N76/(N13-N65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",O80/O13,IF('Data Input'!$D$58=\"Yes\", O76/(O13-O65))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",P80/P13,IF('Data Input'!$D$58=\"Yes\", P76/(P13-P65))),0)","v":0},{"$f":"IF(OR(C97=1,C98=1,C99=1,C100=1,C101=1,C102=1),0,+AVERAGE((E87:P87)))","v":{"$error":"#DIV/0!"}}]
[null,null,"Energy charge - Industrial ","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",E81/E14,IF('Data Input'!$D$58=\"Yes\", E77/(E14-E66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",F81/F14,IF('Data Input'!$D$58=\"Yes\", F77/(F14-F66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",G81/G14,IF('Data Input'!$D$58=\"Yes\", G77/(G14-G66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",H81/H14,IF('Data Input'!$D$58=\"Yes\", H77/(H14-H66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",I81/I14,IF('Data Input'!$D$58=\"Yes\", I77/(I14-I66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",J81/J14,IF('Data Input'!$D$58=\"Yes\", J77/(J14-J66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",K81/K14,IF('Data Input'!$D$58=\"Yes\", K77/(K14-K66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",L81/L14,IF('Data Input'!$D$58=\"Yes\", L77/(L14-L66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",M81/M14,IF('Data Input'!$D$58=\"Yes\", M77/(M14-M66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",N81/N14,IF('Data Input'!$D$58=\"Yes\", N77/(N14-N66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",O81/O14,IF('Data Input'!$D$58=\"Yes\", O77/(O14-O66))),0)","v":0},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",P81/P14,IF('Data Input'!$D$58=\"Yes\", P77/(P14-P66))),0)","v":0},{"$f":"IF(OR(C97=1,C98=1,C99=1,C100=1,C101=1,C102=1),0,+AVERAGE((E88:P88)))","v":{"$error":"#DIV/0!"}}]
[null,null,"Energy charge SBG","Rs/kWh",{"$f":"IF('Data Input'!D58=\"No\",0,'Data Input'!E57+'Data Input'!E56)","v":0},{"$f":"IF('Data Input'!E58=\"No\",0,'Data Input'!F57+'Data Input'!F56)","v":0},{"$f":"IF('Data Input'!F58=\"No\",0,'Data Input'!G57+'Data Input'!G56)","v":0},{"$f":"IF('Data Input'!G58=\"No\",0,'Data Input'!H57+'Data Input'!H56)","v":0},{"$f":"IF('Data Input'!H58=\"No\",0,'Data Input'!I57+'Data Input'!I56)","v":0},{"$f":"IF('Data Input'!I58=\"No\",0,'Data Input'!J57+'Data Input'!J56)","v":0},{"$f":"IF('Data Input'!J58=\"No\",0,'Data Input'!K57+'Data Input'!K56)","v":0},{"$f":"IF('Data Input'!K58=\"No\",0,'Data Input'!L57+'Data Input'!L56)","v":0},{"$f":"IF('Data Input'!L58=\"No\",0,'Data Input'!M57+'Data Input'!M56)","v":0},{"$f":"IF('Data Input'!M58=\"No\",0,'Data Input'!N57+'Data Input'!N56)","v":0},{"$f":"IF('Data Input'!N58=\"No\",0,'Data Input'!O57+'Data Input'!O56)","v":0},{"$f":"IF('Data Input'!O58=\"No\",0,'Data Input'!P57+'Data Input'!P56)","v":0},{"$f":"AVERAGE(E89:P89)","v":{"v":0,"d":"0.00"}}]
[null,null,"Comparison",{"$nulls":13},"Average"]
[null,null,"Average price of grid electricity","Rs/kWh",{"$f":"((E42*E8)+(E43*E9)+(E44*E10)+(E45*E7)+E6)/SUM(E42:E44)","v":{"$error":"#DIV/0!"}},{"$f":"((F42*F8)+(F43*F9)+(F44*F10)+(F45*F7)+F6)/SUM(F42:F44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGE(E91:P91)","v":{"$error":"#DIV/0!"}}]
[null,null,"Average supply tariff-Residential","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(E83*'Data Input'!E27/E12)+E86,(((E83*'Data Input'!E27)+(E86*(E12-E64))+(E$89*E64))/E12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(F83*'Data Input'!F27/F12)+F86,(((F83*'Data Input'!F27)+(F86*(F12-F64))+(F$89*F64))/F12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(G83*'Data Input'!G27/G12)+G86,(((G83*'Data Input'!G27)+(G86*(G12-G64))+(G$89*G64))/G12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(H83*'Data Input'!H27/H12)+H86,(((H83*'Data Input'!H27)+(H86*(H12-H64))+(H$89*H64))/H12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(I83*'Data Input'!I27/I12)+I86,(((I83*'Data Input'!I27)+(I86*(I12-I64))+(I$89*I64))/I12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(J83*'Data Input'!J27/J12)+J86,(((J83*'Data Input'!J27)+(J86*(J12-J64))+(J$89*J64))/J12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(K83*'Data Input'!K27/K12)+K86,(((K83*'Data Input'!K27)+(K86*(K12-K64))+(K$89*K64))/K12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(L83*'Data Input'!L27/L12)+L86,(((L83*'Data Input'!L27)+(L86*(L12-L64))+(L$89*L64))/L12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(M83*'Data Input'!M27/M12)+M86,(((M83*'Data Input'!M27)+(M86*(M12-M64))+(M$89*M64))/M12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(N83*'Data Input'!N27/N12)+N86,(((N83*'Data Input'!N27)+(N86*(N12-N64))+(N$89*N64))/N12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(O83*'Data Input'!O27/O12)+O86,(((O83*'Data Input'!O27)+(O86*(O12-O64))+(O$89*O64))/O12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(P83*'Data Input'!P27/P12)+P86,(((P83*'Data Input'!P27)+(P86*(P12-P64))+(P$89*P64))/P12)),0)","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E92:P92)","v":{"v":0,"d":"0.00"}}]
[null,null,"Average supply tariff-Commercial","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(E84*'Data Input'!E28/E13)+E87,(((E84*'Data Input'!E28)+(E87*(E13-E65))+(E$89*E65))/E13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(F84*'Data Input'!F28/F13)+F87,(((F84*'Data Input'!F28)+(F87*(F13-F65))+(F$89*F65))/F13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(G84*'Data Input'!G28/G13)+G87,(((G84*'Data Input'!G28)+(G87*(G13-G65))+(G$89*G65))/G13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(H84*'Data Input'!H28/H13)+H87,(((H84*'Data Input'!H28)+(H87*(H13-H65))+(H$89*H65))/H13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(I84*'Data Input'!I28/I13)+I87,(((I84*'Data Input'!I28)+(I87*(I13-I65))+(I$89*I65))/I13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(J84*'Data Input'!J28/J13)+J87,(((J84*'Data Input'!J28)+(J87*(J13-J65))+(J$89*J65))/J13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(K84*'Data Input'!K28/K13)+K87,(((K84*'Data Input'!K28)+(K87*(K13-K65))+(K$89*K65))/K13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(L84*'Data Input'!L28/L13)+L87,(((L84*'Data Input'!L28)+(L87*(L13-L65))+(L$89*L65))/L13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(M84*'Data Input'!M28/M13)+M87,(((M84*'Data Input'!M28)+(M87*(M13-M65))+(M$89*M65))/M13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(N84*'Data Input'!N28/N13)+N87,(((N84*'Data Input'!N28)+(N87*(N13-N65))+(N$89*N65))/N13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(O84*'Data Input'!O28/O13)+O87,(((O84*'Data Input'!O28)+(O87*(O13-O65))+(O$89*O65))/O13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(P84*'Data Input'!P28/P13)+P87,(((P84*'Data Input'!P28)+(P87*(P13-P65))+(P$89*P65))/P13)),0)","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E93:P93)","v":{"v":0,"d":"0.00"}}]
[null,null,"Average supply tariff-Industrial","Rs/kWh",{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(E85*'Data Input'!E29/E14)+E88,(((E85*'Data Input'!E29)+(E88*(E14-E66))+(E$89*E66))/E14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(F85*'Data Input'!F29/F14)+F88,(((F85*'Data Input'!F29)+(F88*(F14-F66))+(F$89*F66))/F14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(G85*'Data Input'!G29/G14)+G88,(((G85*'Data Input'!G29)+(G88*(G14-G66))+(G$89*G66))/G14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(H85*'Data Input'!H29/H14)+H88,(((H85*'Data Input'!H29)+(H88*(H14-H66))+(H$89*H66))/H14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(I85*'Data Input'!I29/I14)+I88,(((I85*'Data Input'!I29)+(I88*(I14-I66))+(I$89*I66))/I14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(J85*'Data Input'!J29/J14)+J88,(((J85*'Data Input'!J29)+(J88*(J14-J66))+(J$89*J66))/J14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(K85*'Data Input'!K29/K14)+K88,(((K85*'Data Input'!K29)+(K88*(K14-K66))+(K$89*K66))/K14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(L85*'Data Input'!L29/L14)+L88,(((L85*'Data Input'!L29)+(L88*(L14-L66))+(L$89*L66))/L14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(M85*'Data Input'!M29/M14)+M88,(((M85*'Data Input'!M29)+(M88*(M14-M66))+(M$89*M66))/M14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(N85*'Data Input'!N29/N14)+N88,(((N85*'Data Input'!N29)+(N88*(N14-N66))+(N$89*N66))/N14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(O85*'Data Input'!O29/O14)+O88,(((O85*'Data Input'!O29)+(O88*(O14-O66))+(O$89*O66))/O14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF('Data Input'!$D$58=\"No\",(P85*'Data Input'!P29/P14)+P88,(((P85*'Data Input'!P29)+(P88*(P14-P66))+(P$89*P66))/P14)),0)","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E94:P94)","v":{"v":0,"d":"0.00"}}]
[]
[]
["Total Data Validity",null,{"$f":"IF(OR((E38:P38)>(E42:P42),(E39:P39)>(E43:P43),(E40:P40)>(E44:P44),(E50:P50)>(E45:P45)),1,0)","v":{"$error":"#DIV/0!"}}]
["Peak",null,{"$f":"IF(OR(E38:P38>E42:P42),1,0)","v":{"$error":"#DIV/0!"}}]
["Day",null,{"$f":"IF(OR(E39:P39>E43:P43),1,0)","v":{"$error":"#DIV/0!"}}]
["Off-peak",null,{"$f":"IF(OR(E40:P40>E44:P44),1,0)","v":{"$error":"#DIV/0!"}}]
["Demand",null,{"$f":"IF(OR((E50:P50)>E45:P45),1,0)","v":0}]
[null,null,{"$f":"IF(OR(AND(SUM('Data Input'!D35:F35)<1,SUM('Data Input'!D35:F35)>0),1<SUM('Data Input'!D35:F35),AND(SUM('Data Input'!D36:F36)<1,SUM('Data Input'!D36:F36)>0),1<SUM('Data Input'!D36:F36),AND(SUM('Data Input'!D37:F37)<1,SUM('Data Input'!D37:F37)>0),1<SUM('Data Input'!D37:F37)),1,0)","v":0}]

{"sheet":"Results","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"merged":[[0,2,1,2],[0,3,0,9],[1,3,1,9],[3,3,3,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[12,6,14,9]]}
[null,null,"Results",{"$f":"\"Exempted Person: \"&'Data Input'!D4","v":"Exempted Person: "}]
[{"$nulls":3},{"$f":"\"Exemption Number:\"& 'Data Input'!D6","v":"Exemption Number:"}]
[]
[null,null,{"$f":"'Data Input'!C4","v":"Name of the Exempted Person"},{"$f":"'Data Input'!D4:H4","v":0}]
[null,null,{"$f":"'Data Input'!C5","v":"Address"},{"$f":"'Data Input'!D5:H5","v":0}]
[null,null,{"$f":"'Data Input'!C6","v":"Exemption Number"},{"$f":"'Data Input'!D6:E6","v":0}]
[null,null,{"$f":"'Data Input'!C7","v":"Date"},{"$f":"'Data Input'!D7:E7","v":"00:00:00"}]
[]
[null,null,{"$f":"+Calculations!C82","v":"Tariff proposed for customers"}]
[null,null,{"$f":"+Calculations!C83","v":"Fixed charge - Residential"},{"$f":"+Calculations!D83","v":"Rs/Month"},{"$f":"+Calculations!Q83","v":0}]
[null,null,{"$f":"+Calculations!C84","v":"Fixed charge - Commercial"},{"$f":"+Calculations!D84","v":"Rs/Month"},{"$f":"+Calculations!Q84","v":0}]
[null,null,{"$f":"+Calculations!C85","v":"Fixed charge - Industrial"},{"$f":"+Calculations!D85","v":"Rs/Month"},{"$f":"+Calculations!Q85","v":0}]
[null,null,{"$f":"+Calculations!C86","v":"Energy charge - Residential"},{"$f":"+Calculations!D86","v":"Rs/kWh"},{"$f":"+Calculations!Q86","v":{"$error":"#DIV/0!"}},null,"There is a problem with the data you have input. Please re-check the \"Data Input\" sheet"]
[null,null,{"$f":"+Calculations!C87","v":"Energy charge - Commercial "},{"$f":"+Calculations!D87","v":"Rs/kWh"},{"$f":"+Calculations!Q87","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"+Calculations!C88","v":"Energy charge - Industrial "},{"$f":"+Calculations!D88","v":"Rs/kWh"},{"$f":"+Calculations!Q88","v":{"$error":"#DIV/0!"}}]
[null,null,"SBG Energy charge - All","Rs/kWh",{"$f":"Calculations!Q89","v":0}]
[]
[null,null,{"$f":"Calculations!C90","v":"Comparison"}]
[null,null,{"$f":"Calculations!C91","v":"Average price of grid electricity"},{"$f":"Calculations!D91","v":"Rs/kWh"},{"$f":"Calculations!Q91","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"Calculations!C92","v":"Average supply tariff-Residential"},{"$f":"Calculations!D92","v":"Rs/kWh"},{"$f":"Calculations!Q92","v":0}]
[null,null,{"$f":"Calculations!C93","v":"Average supply tariff-Commercial"},{"$f":"Calculations!D93","v":"Rs/kWh"},{"$f":"Calculations!Q93","v":0}]
[null,null,{"$f":"Calculations!C94","v":"Average supply tariff-Industrial"},{"$f":"Calculations!D94","v":"Rs/kWh"},{"$f":"Calculations!Q94","v":0}]
[]
[null,null,{"$f":"+Calculations!C5","v":"Applicable purchase tariff"}]
[null,null,{"$f":"+Calculations!C6","v":"Fixed charge"},{"$f":"+Calculations!D6","v":"Rs/Month"},{"$f":"+Calculations!E6","v":{"v":3000,"d":"3,000"}}]
[null,null,{"$f":"+Calculations!C7","v":"Demand charge"},{"$f":"+Calculations!D7","v":"Rs/kVA/Month"},{"$f":"+Calculations!E7","v":{"v":1000,"d":"1,000"}}]
[null,null,{"$f":"+Calculations!C8","v":"Energy charge - Peak"},{"$f":"+Calculations!D8","v":"Rs/kWh"},{"$f":"+Calculations!E8","v":{"v":25.5,"d":"25.50"}}]
[null,null,{"$f":"+Calculations!C9","v":"Energy charge - Day"},{"$f":"+Calculations!D9","v":"Rs/kWh"},{"$f":"+Calculations!E9","v":{"v":20.7,"d":"20.70"}}]
[null,null,{"$f":"+Calculations!C10","v":"Energy charge - Off-peak"},{"$f":"+Calculations!D10","v":"Rs/kWh"},{"$f":"+Calculations!E10","v":14.35}]
[]
[null,null,"Purchase  data",null,{"$f":"+'Data Input'!E19","v":"Jan"},{"$f":"+'Data Input'!F19","v":"Feb"},{"$f":"+'Data Input'!G19","v":"March"},{"$f":"+'Data Input'!H19","v":"April"},{"$f":"+'Data Input'!I19","v":"May"},{"$f":"+'Data Input'!J19","v":"June"},{"$f":"+'Data Input'!K19","v":"July"},{"$f":"+'Data Input'!L19","v":"August"},{"$f":"+'Data Input'!M19","v":"September"},{"$f":"+'Data Input'!N19","v":"October"},{"$f":"+'Data Input'!O19","v":"November"},{"$f":"+'Data Input'!P19","v":"December"}]
[null,null,{"$f":"+'Data Input'!C20","v":"Maximum demand"},{"$f":"+'Data Input'!D20","v":"kVA"},{"$f":"+'Data Input'!E20","v":0},{"$f":"+'Data Input'!F20","v":0},{"$f":"+'Data Input'!G20","v":0},{"$f":"+'Data Input'!H20","v":0},{"$f":"+'Data Input'!I20","v":0},{"$f":"+'Data Input'!J20","v":0},{"$f":"+'Data Input'!K20","v":0},{"$f":"+'Data Input'!L20","v":0},{"$f":"+'Data Input'!M20","v":0},{"$f":"+'Data Input'!N20","v":0},{"$f":"+'Data Input'!O20","v":0},{"$f":"+'Data Input'!P20","v":0}]
[null,null,{"$f":"+'Data Input'!C21","v":"Time at which maximum demand is recorded"},{"$f":"+'Data Input'!D21","v":"Hrs"},{"$f":"+'Data Input'!E21","v":"00:00:00"}]
[null,null,{"$f":"+'Data Input'!C22","v":"Total energy purchased from the grid"},{"$f":"+'Data Input'!D22","v":"kWh"},{"$f":"+'Data Input'!E22","v":0},{"$f":"+'Data Input'!F22","v":0},{"$f":"+'Data Input'!G22","v":0},{"$f":"+'Data Input'!H22","v":0},{"$f":"+'Data Input'!I22","v":0},{"$f":"+'Data Input'!J22","v":0},{"$f":"+'Data Input'!K22","v":0},{"$f":"+'Data Input'!L22","v":0},{"$f":"+'Data Input'!M22","v":0},{"$f":"+'Data Input'!N22","v":0},{"$f":"+'Data Input'!O22","v":0},{"$f":"+'Data Input'!P22","v":0}]
[null,null,{"$f":"+'Data Input'!C23","v":"Peak"},{"$f":"+'Data Input'!D23","v":"kWh"},{"$f":"+'Data Input'!E23","v":0},{"$f":"+'Data Input'!F23","v":0},{"$f":"+'Data Input'!G23","v":0},{"$f":"+'Data Input'!H23","v":0},{"$f":"+'Data Input'!I23","v":0},{"$f":"+'Data Input'!J23","v":0},{"$f":"+'Data Input'!K23","v":0},{"$f":"+'Data Input'!L23","v":0},{"$f":"+'Data Input'!M23","v":0},{"$f":"+'Data Input'!N23","v":0},{"$f":"+'Data Input'!O23","v":0},{"$f":"+'Data Input'!P23","v":0}]
[null,null,{"$f":"+'Data Input'!C24","v":"Day"},{"$f":"+'Data Input'!D24","v":"kWh"},{"$f":"+'Data Input'!E24","v":0},{"$f":"+'Data Input'!F24","v":0},{"$f":"+'Data Input'!G24","v":0},{"$f":"+'Data Input'!H24","v":0},{"$f":"+'Data Input'!I24","v":0},{"$f":"+'Data Input'!J24","v":0},{"$f":"+'Data Input'!K24","v":0},{"$f":"+'Data Input'!L24","v":0},{"$f":"+'Data Input'!M24","v":0},{"$f":"+'Data Input'!N24","v":0},{"$f":"+'Data Input'!O24","v":0},{"$f":"+'Data Input'!P24","v":0}]
[null,null,{"$f":"+'Data Input'!C25","v":"Off-peak"},{"$f":"+'Data Input'!D25","v":"kWh"},{"$f":"+'Data Input'!E25","v":0},{"$f":"+'Data Input'!F25","v":0},{"$f":"+'Data Input'!G25","v":0},{"$f":"+'Data Input'!H25","v":0},{"$f":"+'Data Input'!I25","v":0},{"$f":"+'Data Input'!J25","v":0},{"$f":"+'Data Input'!K25","v":0},{"$f":"+'Data Input'!L25","v":0},{"$f":"+'Data Input'!M25","v":0},{"$f":"+'Data Input'!N25","v":0},{"$f":"+'Data Input'!O25","v":0},{"$f":"+'Data Input'!P25","v":0}]
[]
[null,null,{"$f":"+'Data Input'!C26","v":"Total Number of customers (Occupied and unoccupied)"},null,{"$f":"+E31","v":"Jan"},"Feb","March","April","May","June","July","August","September","October","November","December"]
[null,null,{"$f":"+'Data Input'!C27","v":"Residential"},{"$f":"+'Data Input'!D27","v":"No"},{"$f":"+'Data Input'!E27","v":0},{"$f":"+'Data Input'!F27","v":0},{"$f":"+'Data Input'!G27","v":0},{"$f":"+'Data Input'!H27","v":0},{"$f":"+'Data Input'!I27","v":0},{"$f":"+'Data Input'!J27","v":0},{"$f":"+'Data Input'!K27","v":0},{"$f":"+'Data Input'!L27","v":0},{"$f":"+'Data Input'!M27","v":0},{"$f":"+'Data Input'!N27","v":0},{"$f":"+'Data Input'!O27","v":0},{"$f":"+'Data Input'!P27","v":0}]
[null,null,{"$f":"+'Data Input'!C28","v":"Commercial"},{"$f":"+'Data Input'!D28","v":"No"},{"$f":"+'Data Input'!E28","v":0},{"$f":"+'Data Input'!F28","v":0},{"$f":"+'Data Input'!G28","v":0},{"$f":"+'Data Input'!H28","v":0},{"$f":"+'Data Input'!I28","v":0},{"$f":"+'Data Input'!J28","v":0},{"$f":"+'Data Input'!K28","v":0},{"$f":"+'Data Input'!L28","v":0},{"$f":"+'Data Input'!M28","v":0},{"$f":"+'Data Input'!N28","v":0},{"$f":"+'Data Input'!O28","v":0},{"$f":"+'Data Input'!P28","v":0}]
[null,null,{"$f":"+'Data Input'!C29","v":"Industrial"},{"$f":"+'Data Input'!D29","v":"No"},{"$f":"+'Data Input'!E29","v":0},{"$f":"+'Data Input'!F29","v":0},{"$f":"+'Data Input'!G29","v":0},{"$f":"+'Data Input'!H29","v":0},{"$f":"+'Data Input'!I29","v":0},{"$f":"+'Data Input'!J29","v":0},{"$f":"+'Data Input'!K29","v":0},{"$f":"+'Data Input'!L29","v":0},{"$f":"+'Data Input'!M29","v":0},{"$f":"+'Data Input'!N29","v":0},{"$f":"+'Data Input'!O29","v":0},{"$f":"+'Data Input'!P29","v":0}]
[]
[null,null,"Energy sales",null,{"$f":"+E39","v":"Jan"},"Feb","March","April","May","June","July","August","September","October","November","December"]
[null,null,{"$f":"+'Data Input'!C30","v":"Total energy sales"},{"$f":"+'Data Input'!D30","v":"kWh"},{"$f":"+'Data Input'!E30","v":0},{"$f":"+'Data Input'!F30","v":0},{"$f":"+'Data Input'!G30","v":0},{"$f":"+'Data Input'!H30","v":0},{"$f":"+'Data Input'!I30","v":0},{"$f":"+'Data Input'!J30","v":0},{"$f":"+'Data Input'!K30","v":0},{"$f":"+'Data Input'!L30","v":0},{"$f":"+'Data Input'!M30","v":0},{"$f":"+'Data Input'!N30","v":0},{"$f":"+'Data Input'!O30","v":0},{"$f":"+'Data Input'!P30","v":0}]
[null,null,{"$f":"+'Data Input'!C31","v":"Energy sales-Residential"},{"$f":"+'Data Input'!D31","v":"kWh"},{"$f":"+'Data Input'!E31","v":0},{"$f":"+'Data Input'!F31","v":0},{"$f":"+'Data Input'!G31","v":0},{"$f":"+'Data Input'!H31","v":0},{"$f":"+'Data Input'!I31","v":0},{"$f":"+'Data Input'!J31","v":0},{"$f":"+'Data Input'!K31","v":0},{"$f":"+'Data Input'!L31","v":0},{"$f":"+'Data Input'!M31","v":0},{"$f":"+'Data Input'!N31","v":0},{"$f":"+'Data Input'!O31","v":0},{"$f":"+'Data Input'!P31","v":0}]
[null,null,{"$f":"+'Data Input'!C32","v":"Energy sales-Commercial"},{"$f":"+'Data Input'!D32","v":"kWh"},{"$f":"+'Data Input'!E32","v":0},{"$f":"+'Data Input'!F32","v":0},{"$f":"+'Data Input'!G32","v":0},{"$f":"+'Data Input'!H32","v":0},{"$f":"+'Data Input'!I32","v":0},{"$f":"+'Data Input'!J32","v":0},{"$f":"+'Data Input'!K32","v":0},{"$f":"+'Data Input'!L32","v":0},{"$f":"+'Data Input'!M32","v":0},{"$f":"+'Data Input'!N32","v":0},{"$f":"+'Data Input'!O32","v":0},{"$f":"+'Data Input'!P32","v":0}]
[null,null,{"$f":"+'Data Input'!C33","v":"Energy sales-Industrial"},{"$f":"+'Data Input'!D33","v":"kWh"},{"$f":"+'Data Input'!E33","v":0},{"$f":"+'Data Input'!F33","v":0},{"$f":"+'Data Input'!G33","v":0},{"$f":"+'Data Input'!H33","v":0},{"$f":"+'Data Input'!I33","v":0},{"$f":"+'Data Input'!J33","v":0},{"$f":"+'Data Input'!K33","v":0},{"$f":"+'Data Input'!L33","v":0},{"$f":"+'Data Input'!M33","v":0},{"$f":"+'Data Input'!N33","v":0},{"$f":"+'Data Input'!O33","v":0},{"$f":"+'Data Input'!P33","v":0}]