{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Cover Page","Control","User Guide","Input Data","New Entrant Model (NEM)","Gen Prices","Basis-2011"],"not_rendered":{"images":2,"macros":1,"external_links":1,"defined_names":213},"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[17,1,17,12],[18,1,18,12],[21,6,21,8],[23,6,23,8],[25,1,25,12],[26,1,26,12]]}
{"$rows_empty":17}
[null,"ENUGU STATE ELECTRICITY REGULATORY COMMISSION "]
[null,"GENERATION PRICE ESTIMATION MODEL"]
[]
[{"$nulls":5},"Version No:",1]
[{"$nulls":5},"Version's Date","2024-10-01"]
[{"$nulls":5},"Version Name","EERCGPEM_01_10_2024"]
[{"$nulls":5},"Today's Date",{"$f":"NOW()","v":"2025-01-30T15:41:21.910"}]
[{"$nulls":5},"Developed by ","S2R Consulting"]

{"sheet":"Control","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[1,1,1,12],[7,2,7,5],[7,8,7,11],[10,2,13,5],[10,8,13,11],[16,2,20,5]]}
[]
[null,"Generation Price Estimator"]
[]
[]
[]
[]
[]
[null,null,"Input",{"$nulls":5},"Output"]
[]
[]
[null,null,"User Guide",{"$nulls":5},"Genco Price"]
[]
[]
[]
[]
[]
[null,null,"Input Data"]

{"sheet":"User Guide","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[3,2,3,15],[16,2,16,15],[31,2,31,11]]}
[]
[]
[]
[null,null,"Table of Content"]
[null,null,"Worksheet Name",null,null,"Description"]
[null,null,"Cover Page",null,null,"Cover Page of the Model, gives general instructions"]
[null,null,"Control",null,null,"This page contains links to other worksheets. "]
[null,null,"User Guide",null,null,"Guide the user of the model on how the model works"]
[null,null,"Input Data",null,null,"This is where the vast majority of the model inputs , not related to  costs  are inserted and changed "]
[null,null,"Fuel Data",null,null,"This page is where you enter your fuel data, after you have finished populating the input data"]
[null,null,"Assumption ",null,null,"This is where the equipment and installation costs of the projects  are inputted"]
[null,null,"New Entrant Model (NEM)",null,null,"This is where the costs assumptions for generation are processed through a DCF calculation to arrive at a tariff figure. "]
[{"$nulls":5},"There is a macro on this page that calculates the tariff for a given year."]
[null,null,"Embedded Gen Prices",null,null,"This worksheet uses the NEM sheet to calculate the embedded generation tariff and displays the main components."]
[]
[]
[null,null,"Instructions"]
[null,null,0,null,null,"Only put data in the Input Worksheets, whose tabs are coloured in aqua."]
[]
[null,null,1,null,null,"Please do not input data into \"Gen Prices\" Worksheets"]
[]
[null,null,2,null,null,"The Input Data sheet should be filled with the project's parameters.  "]
[{"$nulls":5},"Note that the Construction Period (cell F7) should correspond with the Construction Profile (cells I6:L6)."]
[{"$nulls":5},"After completion the button should be clicked."]
[]
[null,null,3,null,null,"The Fuel data should be filled for the relevant years."]
[]
[null,null,4,null,null,"The User should then go to the Gen Prices sheet and click the button there to calculate the tariffs."]
[]
[]
[]
[null,null,"Color Convention"]
[null,null,"Light Orange cells are for regulated inputs inputted by the EERC"]
[null,null,"Aqua cells indicate cells to be inputted by user"]
[null,null,"White Cells are used for calculated results"]

{"sheet":"Input Data","index":3,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[3,3,3,4],[3,7,3,8],[22,3,22,4]]}
[]
[]
[]
[{"$nulls":3},"Generation Assumptions ",{"$nulls":3},"Construction profile"]
[{"$nulls":3},"Assumptions","Units","Value",null,"Year",-4,-3,-2,-1]
[{"$nulls":3},"Economic Life","Years",20,null,"%",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[{"$nulls":3},"Construction Period","Years",2]
[{"$nulls":3},"Starting Year","Years",2028]
[{"$nulls":3},"Installed capacity","MW",100]
[{"$nulls":3},"Auxiliary requirements","%",{"v":0.01,"d":"1.0%"}]
[{"$nulls":3},"Average Degradation","%",{"v":0.01,"d":"1.0%"}]
[{"$nulls":3},"Capacity factor","%",{"v":0.8,"d":"80.0%"}]
[{"$nulls":3},"Station MLF","%",{"v":1,"d":"1.0000"}]
[{"$nulls":3},{"$f":" \"Capital cost\" &   \" (\" & F8-1 & \"  Basis)\"","v":"Capital cost (2027  Basis)"},"US $/kW",350]
[{"$nulls":3},"USD Components Split","%",{"v":1,"d":"100%"}]
[{"$nulls":3},"Naira Components Split","%",{"$f":"1-F15","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Sent out efficiency (HHV)","%",{"v":0.38,"d":"38%"}]
[{"$nulls":3},"Fixed O&M","N/MW/year",{"v":78074168.43749999,"d":"78,074,168"}]
[{"$nulls":3},"Variable O&M (sent out)","N/MWh",{"v":1030.8742573178608,"d":"1,031"}]
[]
[]
[]
[{"$nulls":3},"Financial Assumptions "]
[{"$nulls":3},"Assumptions","Units","Value"]
[{"$nulls":3},"Exchange Rate","Naira/$",1600]
[{"$nulls":3},"Fuel Cost","$/MMBtu",2.6]
[{"$nulls":3},"WACC","%",{"v":0.2,"d":"20%"}]
[{"$nulls":3},"Tax Rate","%",{"v":0.32,"d":"32%"}]

{"sheet":"New Entrant Model (NEM)","index":4,"n_rows":147,"n_cols":55,"rows_kept":147}
[null,"REGULATOR'S VIEW",{"$nulls":6},"REGULATOR'S VIEW",{"$nulls":5},"REGULATOR'S VIEW"]
[null,"ENTER CHANGES IN NEW ENTRANT ASSUMPTIONS ON ASSUMPTIONS SHEET"]
[null,"ASSUMPTIONS",{"$nulls":3},"Construction profile",null,null,"NPV Calculation",null,null,"Construction Period"]
[null,{"$f":"\"Enter Values for 1st Year Power = \" & NEM_year","v":"Enter Values for 1st Year Power = 2027"},"Units","Value",null,"Year","%",{"$nulls":3},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[null,"Installed capacity","MW",{"$f":"'Input Data'!F9","v":100},null,-4,{"$f":"TRANSPOSE('Input Data'!I6:L6)","v":{"v":0,"d":"0%"}}]
[null,"Auxiliary requirements","%",{"$f":"'Input Data'!F10","v":{"v":0.01,"d":"1.0%"}},null,-3,{"v":0,"d":"0%"},null,"Revenue"]
[null,"Average capacity degradation","%",{"$f":"'Input Data'!F11","v":{"v":0.01,"d":"1.0%"}},null,-2,{"v":0.5,"d":"50%"},null,"Sent out generation","GWh",{"$nulls":4},{"$f":"$D$11*O147","v":{"v":687.2544,"d":"687 "}},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":687.2544,"d":"687 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$11*AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capacity factor","%",{"$f":"'Input Data'!F12","v":{"v":0.8,"d":"80.0%"}},null,-1,{"v":0.5,"d":"50%"},null,"Capacity Price","N/MWh",{"$nulls":4},{"$f":"+NECost * IF(D5=0, 0, 1)","v":{"v":25151.15023313271,"d":"25,151 "}},{"$f":"O8*P147","v":{"v":25151.15023313271,"d":"25,151 "}},{"$f":"P8*Q147","v":{"v":25151.15023313271,"d":"25,151 "}},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":25151.15023313271,"d":"25,151 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AQ8*AR147","v":{"v":0,"d":"0 "}},{"$f":"AR8*AS147","v":{"v":0,"d":"0 "}},{"$f":"AS8*AT147","v":{"v":0,"d":"0 "}},{"$f":"AT8*AU147","v":{"v":0,"d":"0 "}},{"$f":"AU8*AV147","v":{"v":0,"d":"0 "}},{"$f":"AV8*AW147","v":{"v":0,"d":"0 "}},{"$f":"AW8*AX147","v":{"v":0,"d":"0 "}},{"$f":"AX8*AY147","v":{"v":0,"d":"0 "}},{"$f":"AY8*AZ147","v":{"v":0,"d":"0 "}},{"$f":"AZ8*BA147","v":{"v":0,"d":"0 "}},{"$f":"BA8*BB147","v":{"v":0,"d":"0 "}},{"$f":"BB8*BC147","v":{"v":0,"d":"0 "}}]
[null,"Station MLF *","%",{"$f":"'Input Data'!F13","v":{"v":1,"d":"100.0%"}},null,null,{"$f":"IF(SUM(G5:G8)<>1, \"Error\", 1)","v":{"v":1,"d":"100%"}},null,"FOM Price","N/MWh",{"$nulls":4},{"$f":"IF(O7=0, 0, O19 / O7)","v":{"v":11360.300994435245,"d":"11,360 "}},{"$f":"IF(P7=0, 0, P19 / P7)","v":{"v":11360.300994435245,"d":"11,360 "}},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":11360.300994435245,"d":"11,360 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR7=0, 0, AR19 / AR7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Energy generated","GWh",{"$f":"D5*8.766*D8","v":{"v":701.2800000000001,"d":"701 "}},{"$nulls":4},"VOM Price","N/MWh",{"$nulls":4},{"$f":"IF(O7=0,0, (O20+O23+O24) / O7)","v":{"v":1030.8742573178608,"d":"1,031 "}},{"$f":"IF(P7=0,0, (P20+P23+P24) / P7)","v":{"v":1030.8742573178608,"d":"1,031 "}},{"$f":"IF(Q7=0,0, (Q20+Q23+Q24) / Q7)","v":{"v":1030.8742573178608,"d":"1,031 "}},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":1030.8742573178608,"d":"1,031 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR7=0,0, (AR20+AR23+AR24) / AR7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Energy sent out *","GWh",{"$f":"D10*(1-D6-D7)","v":{"v":687.2544,"d":"687 "}},{"$nulls":4},"Fuel Price","N/MWh",{"$nulls":4},{"$f":"IF(O7 = 0,0,O21 / O7)","v":{"v":41089.34905263158,"d":"41,089 "}},{"$f":"IF(P7 = 0,0,P21 / P7)","v":{"v":41089.34905263158,"d":"41,089 "}},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":41089.34905263158,"d":"41,089 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR7 = 0,0,AR21 / AR7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Energy sent out (unit conversion) *","GBTU",{"$f":"D11 * 3.41214","v":{"v":2345.0082284160003,"d":"2,345 "}},{"$nulls":4},"Total Price","N/MWh",{"$nulls":4},{"$f":"+O8+O11+O10+O9","v":{"v":78631.67453751739,"d":"78,632 "}},{"$f":"+P8+P11+P10+P9","v":{"v":78631.67453751739,"d":"78,632 "}},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":78631.67453751739,"d":"78,632 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"+AR8+AR11+AR10+AR9","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Sent out efficiency (LHV)","%",{"$f":"'Input Data'!F17","v":{"v":0.38,"d":"38%"}}]
[null,"Fuel Input (LHV)","GBTU",{"$f":"D12/D13","v":{"v":6171.074285305263,"d":"6,171 "}}]
[null,"Fuel cost  (HHV)","$ / Mbtu",{"$f":"'Input Data'!F26","v":{"v":2.6,"d":"2.60"}},{"$nulls":4},"Total revenue","Nk",{"$nulls":4},{"$f":"O12 * O7 * $D9","v":{"v":54039964.305276796,"d":"54,039,964 "}},{"$f":"P12 * P7 * $D9","v":{"v":54039964.305276796,"d":"54,039,964 "}},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR12 * AR7 * $D9","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Forex","N / $",{"$f":"'Input Data'!F25","v":{"v":1600,"d":"1,600"}}]
[null,"Fuel cost  (HHV)","N/MMbtu",{"$f":"D15*D16","v":{"v":4160,"d":"4,160"}},{"$nulls":4},"Costs"]
[null,"HHV to LHV Conversion","ratio",{"v":1.1,"d":"1.10"},{"$nulls":4},"Capex","Nk",{"$f":"$G$5*$D$21","v":{"v":0,"d":"0 "}},{"$f":"$G$6*$D$21","v":{"v":0,"d":"0 "}},{"$f":"$G$7*$D$21","v":{"v":28000000,"d":"28,000,000 "}},{"$f":"$G$8*$D$21","v":{"v":28000000,"d":"28,000,000 "}}]
[null,"Cost of fuel","Nk",{"$f":"D14 * D17 * D18","v":{"v":28238835.929556888,"d":"28,238,836 "}},{"$nulls":4},"Fixed O&M","Nk",{"$nulls":4},{"$f":"$D$23 *  O147","v":{"v":7807416.843749998,"d":"7,807,417 "}},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$23 *  AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital cost","N/kW",{"$f":"'Input Data'!F14*'Input Data'!F25","v":{"v":560000,"d":"560,000"}},{"$nulls":4},"Variable O&M","Nk",{"$nulls":4},{"$f":"$D$25 * O147","v":{"v":708472.8691884321,"d":"708,473 "}},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$25 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total capital cost","N 000",{"$f":"D20*D5","v":{"v":56000000,"d":"56,000,000"}},{"$nulls":4},"Fuel cost","Nk",{"$nulls":4},{"$f":"$D$19 * O147","v":{"v":28238835.929556888,"d":"28,238,836 "}},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$19 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Fixed O&M","N/MW/year",{"$f":"'Input Data'!F18","v":{"v":78074168.43749999,"d":"78,074,168"}},{"$nulls":4},"Taxation","Nk",{"$nulls":4},{"$f":"O97","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"$f":"P97","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"$f":"Q97","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"$f":"R97","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR97","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Fixed O&M (sent out)","Nk/year",{"$f":"+D22*D5/1000","v":{"v":7807416.843749998,"d":"7,807,417"}},{"$nulls":4},"Carbon tax","Nk",{"$nulls":4},{"$f":"$D$26 *O147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$26 *AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Variable O&M","N/MWh",{"$f":"'Input Data'!F19","v":{"v":1030.8742573178608,"d":"1,031"}},{"$nulls":4},"Other costs","Nk",{"$nulls":4},{"$f":"$D$27 * O147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$27 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Variable O&M (sent out)","Nk/year",{"$f":"D24*D11","v":{"v":708472.8691884321,"d":"708,473 "}},{"$nulls":4},"Total costs","Nk",{"$f":"SUM(K18:K24)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":28000000,"d":"28,000,000 "},{"v":28000000,"d":"28,000,000 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"$f":"SUM(V18:V24)","v":{"v":41390002.01458539,"d":"41,390,002 "}},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":41390002.01458539,"d":"41,390,002 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(AR18:AR24)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Carbon Costs","Nk"]
[null,"Other Costs","Nk",{"$nulls":5},"After tax cash flow","Nk",{"$f":"K15-K25","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":-28000000,"d":"(28,000,000)"},{"v":-28000000,"d":"(28,000,000)"},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"$f":"V15-V25","v":{"v":12649962.290691406,"d":"12,649,962 "}},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":12649962.290691406,"d":"12,649,962 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR15-AR25","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Depreciation (straight line)","%",{"$f":"1/'Input Data'!F6","v":{"v":0.05,"d":"5.00%"}}]
[null,"Project Life","Years",{"$f":"'Input Data'!F6","v":20},{"$nulls":4},"NPV",{"$f":"NPV(WACC,L27:BB27) + K27 + (G9*0)","v":{"v":-7.0164484592775508E-8,"d":"-0"}}]
[null,"Pre-Tax Real WACC","%",{"$f":"'Input Data'!F27","v":{"v":0.2,"d":"20.00%"}}]
[null,"Corporate tax rate","%",{"$f":"'Input Data'!F28","v":{"v":0.32,"d":"32%"}}]
[]
[null,"Tariff Summary",{"$nulls":6},"Depreciation"]
[null,"Capacity Payment","N / kWh",{"$f":"O8 * 0.001","v":{"v":25.15115023313271,"d":"25.151"}},{"$nulls":6},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[null,"Fixed O&M","N / kWh",{"$f":"O9 * 0.001","v":{"v":11.360300994435246,"d":"11.360"}},{"$nulls":4},"Depreciation Years",{"$f":"1/D28","v":20}]
[null,"Variable O&M","N / kWh",{"$f":"O10 * 0.001","v":{"v":1.0308742573178609,"d":"1.031"}},{"$nulls":4},"Book value start of period","Nk",{"$nulls":4},{"$f":"SUM(K18:N18)","v":{"v":56000000,"d":"56,000,000 "}},{"$f":"O38","v":{"v":53200000,"d":"53,200,000 "}},{"v":50400000,"d":"50,400,000 "},{"v":47600000,"d":"47,600,000 "},{"v":44800000,"d":"44,800,000 "},{"v":42000000,"d":"42,000,000 "},{"v":39200000,"d":"39,200,000 "},{"v":36400000,"d":"36,400,000 "},{"v":33600000,"d":"33,600,000 "},{"v":30800000,"d":"30,800,000 "},{"v":28000000,"d":"28,000,000 "},{"v":25200000,"d":"25,200,000 "},{"v":22400000,"d":"22,400,000 "},{"v":19600000,"d":"19,600,000 "},{"v":16800000,"d":"16,800,000 "},{"v":14000000,"d":"14,000,000 "},{"v":11200000,"d":"11,200,000 "},{"v":8400000,"d":"8,400,000 "},{"v":5600000,"d":"5,600,000 "},{"v":2800000,"d":"2,800,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AQ38","v":{"v":0,"d":"0 "}},{"$f":"AR38","v":{"v":0,"d":"0 "}},{"$f":"AS38","v":{"v":0,"d":"0 "}},{"$f":"AT38","v":{"v":0,"d":"0 "}},{"$f":"AU38","v":{"v":0,"d":"0 "}},{"$f":"AV38","v":{"v":0,"d":"0 "}},{"$f":"AW38","v":{"v":0,"d":"0 "}},{"$f":"AX38","v":{"v":0,"d":"0 "}},{"$f":"AY38","v":{"v":0,"d":"0 "}},{"$f":"AZ38","v":{"v":0,"d":"0 "}},{"$f":"BA38","v":{"v":0,"d":"0 "}},{"$f":"BB38","v":{"v":0,"d":"0 "}}]
[null,"Fuel","N / kWh",{"$f":"O11 * 0.001","v":{"v":41.08934905263158,"d":"41.089"}},{"$nulls":4},"Depreciation charge","Nk",{"$nulls":4},{"$f":"$D$28*$O$36","v":{"v":2800000,"d":"2,800,000 "}},{"$f":"IF(AND(P34<$J35,P34<$D29), O37, IF(O38>0, O38, 0))","v":{"v":2800000,"d":"2,800,000 "}},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AND(AR34<$J35,AR34<$D29), AQ37, IF(AQ38>0, AQ38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AS34<$J35,AS34<$D29), AR37, IF(AR38>0, AR38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AT34<$J35,AT34<$D29), AS37, IF(AS38>0, AS38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AU34<$J35,AU34<$D29), AT37, IF(AT38>0, AT38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AV34<$J35,AV34<$D29), AU37, IF(AU38>0, AU38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AW34<$J35,AW34<$D29), AV37, IF(AV38>0, AV38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AX34<$J35,AX34<$D29), AW37, IF(AW38>0, AW38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AY34<$J35,AY34<$D29), AX37, IF(AX38>0, AX38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(AZ34<$J35,AZ34<$D29), AY37, IF(AY38>0, AY38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(BA34<$J35,BA34<$D29), AZ37, IF(AZ38>0, AZ38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(BB34<$J35,BB34<$D29), BA37, IF(BA38>0, BA38, 0))","v":{"v":0,"d":"0 "}},{"$f":"IF(AND(BC34<$J35,BC34<$D29), BB37, IF(BB38>0, BB38, 0))","v":{"v":0,"d":"0 "}}]
[null,"Total","N / kWh",{"$f":"+D34+D36+D37+D35","v":{"v":78.6316745375174,"d":"78.632"}},{"$nulls":4},"Book value end of period","Nk",{"$nulls":4},{"$f":"O36-O37","v":{"v":53200000,"d":"53,200,000 "}},{"v":50400000,"d":"50,400,000 "},{"v":47600000,"d":"47,600,000 "},{"v":44800000,"d":"44,800,000 "},{"v":42000000,"d":"42,000,000 "},{"v":39200000,"d":"39,200,000 "},{"v":36400000,"d":"36,400,000 "},{"v":33600000,"d":"33,600,000 "},{"v":30800000,"d":"30,800,000 "},{"v":28000000,"d":"28,000,000 "},{"v":25200000,"d":"25,200,000 "},{"v":22400000,"d":"22,400,000 "},{"v":19600000,"d":"19,600,000 "},{"v":16800000,"d":"16,800,000 "},{"v":14000000,"d":"14,000,000 "},{"$f":"AD36-AD37","v":{"v":11200000,"d":"11,200,000 "}},{"v":8400000,"d":"8,400,000 "},{"v":5600000,"d":"5,600,000 "},{"v":2800000,"d":"2,800,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR36-AR37","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[]
[null,"* Generation revenue is reduced by MLF to allow for transmission loss ",{"$nulls":6},"Net income and tax"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},"EBITDA","Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"O15-SUM(O19,O20,O21,O23,O24)","v":{"v":17285238.662781477,"d":"17,285,239 "}},{"$f":"P15-SUM(P19,P20,P21,P23,P24)","v":{"v":17285238.662781477,"d":"17,285,239 "}},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":17285238.662781477,"d":"17,285,239 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR15-SUM(AR19,AR20,AR21,AR23,AR24)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Depreciation charge","Nk",{"$f":"K37","v":{"v":0,"d":"0 "}},{"$f":"L37","v":{"v":0,"d":"0 "}},{"$f":"M37","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"$f":"AE37","v":{"v":2800000,"d":"2,800,000 "}},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":2800000,"d":"2,800,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR37","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Taxable income","Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"O44-O45","v":{"v":14485238.662781477,"d":"14,485,239 "}},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"$f":"AE44-AE45","v":{"v":14485238.662781477,"d":"14,485,239 "}},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR44-AR45","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Income tax expense","Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$31*O46","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$D$31*AR46","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[]
[{"$nulls":12},"s/b zero"]
[{"$nulls":8},{"$f":"\"Startup Year, \" &NEM_year","v":"Startup Year, 2027"},"N/MWh",{"v":25151.15023313271,"d":"25,151 "},"N/MWh",{"$f":"NPV","v":{"v":-7.0164484592775508E-8,"d":"(0)"}}]
[{"$nulls":8},"Equalized Costs","N/MWh",{"$f":"J109 / D11","v":{"v":786.3167453751659,"d":"786 "}},"N/MWh",{"$f":"J112","v":{"v":125636764.96383658,"d":"125,636,765"}}]
[{"$nulls":8},"Fuel cost","N/MWh",{"$f":"J119 / D11","v":{"v":410.89349052630973,"d":"411"}},{"$f":"K53/$K$52","v":{"v":0.5225546739822577,"d":"52.3%"}},{"$f":"+J122","v":{"v":65652078.75586344,"d":"65,652,079"}}]
[{"$nulls":8},"Fixed O&M","N/MWh",{"$f":"J129 / D11","v":{"v":113.60300994435251,"d":"114"}},{"v":0.1444748704800258,"d":"14.4%"},{"$f":"+J132","v":{"v":18151355.345679533,"d":"18,151,355"}}]
[{"$nulls":8},"Variable O&M","N/MWh",{"$f":"J139 / D11","v":{"v":10.308742573178517,"d":"10"}},{"v":0.013110165380313794,"d":"1.3%"},{"$f":"+J142","v":{"v":1647118.7665235088,"d":"1,647,119"}}]
[{"$nulls":8},"Capital cost","N/MWh",{"$f":"CapexPayment/D11","v":{"v":184.06520628593202,"d":"184"}},{"v":0.23408531913956787,"d":"23.4%"},{"$f":"+J89","v":{"v":42350000.00000001,"d":"42,350,000"}}]
[{"$nulls":8},"Tax cost","N/MWh",{"$f":"TaxPayment/D11","v":{"v":67.44629604539496,"d":"67"}},{"v":0.08577497101783725,"d":"8.6%"},{"$f":"J102","v":{"v":15518145.417908972,"d":"15,518,145"}}]
[{"$nulls":8},"Carbon tax cost","N/MWh",{"$f":"(D26 + D27) / D11","v":0},{"v":0,"d":"0.0%"}]
[{"$nulls":8},"Transmission loss cost","N/MWh",{"$f":"K52-SUM(K53:K58)","v":{"v":-1.9326762412674725E-12,"d":"(0)"}},{"v":-2.4578851367909733E-15,"d":"-0.0%"}]
[{"$nulls":10},{"$f":"SUM(K53:K59)","v":{"v":786.3167453751659,"d":"786"}},{"$f":"SUM(L53:L59)","v":{"v":1,"d":"100.0%"}}]
[]
[]
[]
[]
[]
[{"$nulls":8},"Begin - Backup Calculations"]
[]
[]
[{"$nulls":6},"Need for IPP Calcs",null,"Startup Power Year","yr",2027]
[]
[{"$nulls":8},"Other info"]
[]
[]
[]
[]
[]
[{"$nulls":8},"End - Backup Calculations"]
[]
[]
[{"$nulls":8},"Begin - Equalization Calculations"]
[{"$nulls":8},"Estimated capital cost calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},"Capex","Nk",{"$f":"K18","v":{"v":0,"d":"0 "}},{"$f":"L18","v":{"v":0,"d":"0 "}},{"$f":"M18","v":{"v":28000000,"d":"28,000,000 "}},{"$f":"N18","v":{"v":28000000,"d":"28,000,000 "}}]
[{"$nulls":8},"Capex NPV",{"$f":"NPV(WACC, Capex2Yr)","v":{"v":42777777.77777778,"d":"42,777,778 "}}]
[{"$nulls":8},"Equivalent capex payment",{"v":126499.62290691445,"d":"126,500 "}]
[{"$nulls":8},"Equivalent capex stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J$86 * O147","v":{"v":126499.62290691445,"d":"126,500 "}},{"$f":"$J$86 * P147","v":{"v":126499.62290691445,"d":"126,500 "}},{"$f":"$J$86 * Q147","v":{"v":126499.62290691445,"d":"126,500 "}},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":126499.62290691445,"d":"126,500 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J$86 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, EqCapex2Yr)","v":{"v":427777.7777777783,"d":"427,778 "}}]
[{"$nulls":9},{"$f":"+CapexNPV-EqCapexNPV","v":{"v":42350000.00000001,"d":"42,350,000 "}}]
[]
[{"$nulls":8},"Estimated tax cost calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},"Net Loss",{"$nulls":5},{"$f":"IF(O46<0,O46,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR46<0,AR46,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Net Pre-tax income",{"$nulls":5},{"$f":"IF(O46>0,O46,0)","v":{"v":14485238.662781477,"d":"14,485,239 "}},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR46>0,AR46,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Taxable income",{"$nulls":5},{"$f":"O94+O95+IF(N96<0,N96,0)","v":{"v":14485238.662781477,"d":"14,485,239 "}},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"v":14485238.662781477,"d":"14,485,239 "},{"$f":"AI94+AI95+IF(AH96<0,AH96,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR94+AR95+IF(AQ96<0,AQ96,0)","v":{"v":0,"d":"0 "}},{"$f":"AS94+AS95+IF(AR96<0,AR96,0)","v":{"v":0,"d":"0 "}},{"$f":"AT94+AT95+IF(AS96<0,AS96,0)","v":{"v":0,"d":"0 "}},{"$f":"AU94+AU95+IF(AT96<0,AT96,0)","v":{"v":0,"d":"0 "}},{"$f":"AV94+AV95+IF(AU96<0,AU96,0)","v":{"v":0,"d":"0 "}},{"$f":"AW94+AW95+IF(AV96<0,AV96,0)","v":{"v":0,"d":"0 "}},{"$f":"AX94+AX95+IF(AW96<0,AW96,0)","v":{"v":0,"d":"0 "}},{"$f":"AY94+AY95+IF(AX96<0,AX96,0)","v":{"v":0,"d":"0 "}},{"$f":"AZ94+AZ95+IF(AY96<0,AY96,0)","v":{"v":0,"d":"0 "}},{"$f":"BA94+BA95+IF(AZ96<0,AZ96,0)","v":{"v":0,"d":"0 "}},{"$f":"BB94+BB95+IF(BA96<0,BA96,0)","v":{"v":0,"d":"0 "}},{"$f":"BC94+BC95+IF(BB96<0,BB96,0)","v":{"v":0,"d":"0 "}}]
[{"$nulls":8},"Tax payable",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(O96>0,O96*$D$31,0)","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"$f":"IF(P96>0,P96*$D$31,0)","v":{"v":4635276.372090072,"d":"4,635,276 "}},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":4635276.372090072,"d":"4,635,276 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(AR96>0,AR96*$D$31,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Tax expense NPV",{"$f":"NPV(WACC,TaxNPV2Yr)","v":{"v":15674894.361524213,"d":"15,674,894 "}}]
[{"$nulls":8},"Equivalent tax payment",{"v":46352.763720900286,"d":"46,353 "}]
[{"$nulls":8},"Equivalent tax stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J$99 *O147","v":{"v":46352.763720900286,"d":"46,353 "}},{"$f":"$J$99 *P147","v":{"v":46352.763720900286,"d":"46,353 "}},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":46352.763720900286,"d":"46,353 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J$99 *AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, EqTax2Yr)","v":{"v":156748.94361524074,"d":"156,749 "}}]
[{"$nulls":9},{"$f":"+TaxNPV-EqTaxNPV","v":{"v":15518145.417908972,"d":"15,518,145 "}}]
[]
[{"$nulls":8},"Estimated revenue calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[{"$nulls":8},"Revenue Before Transmission Loss"]
[{"$nulls":10},{"$f":"K15 / $D9","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":54039964.305276796,"d":"54,039,964 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR15 / $D9","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Revenue NPV",{"$f":"NPV(WACC, K107:BB107)","v":{"v":126905823.19579451,"d":"126,905,823 "}}]
[{"$nulls":8},"Equivalent revenue payment",{"v":540399.6430527624,"d":"540,400 "}]
[{"$nulls":8},"Equivalent revenue stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J109 * O147","v":{"v":540399.6430527624,"d":"540,400 "}},{"$f":"$J109 * P147","v":{"v":540399.6430527624,"d":"540,400 "}},{"$f":"$J109 * Q147","v":{"v":540399.6430527624,"d":"540,400 "}},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":540399.6430527624,"d":"540,400 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J109 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, K110:BB110)","v":{"v":1269058.2319579318,"d":"1,269,058 "}}]
[{"$nulls":9},{"$f":"J108-J111","v":{"v":125636764.96383658,"d":"125,636,765 "}}]
[]
[{"$nulls":8},"Estimated fuel calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},{"$f":"I21","v":"Fuel cost"},"Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":28238835.929556888,"d":"28,238,836 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR21","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Fuel NPV",{"$f":"NPV(WACC, K117:AR117)","v":{"v":66315231.06652872,"d":"66,315,231 "}}]
[{"$nulls":8},"Equivalent fuel costs",{"v":282388.3592955647,"d":"282,388 "}]
[{"$nulls":8},"Equivalent fuel stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J119 * O147","v":{"v":282388.3592955647,"d":"282,388 "}},{"$f":"$J119 * P147","v":{"v":282388.3592955647,"d":"282,388 "}},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":282388.3592955647,"d":"282,388 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J119 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, K120:AR120)","v":{"v":663152.3106652774,"d":"663,152 "}}]
[{"$nulls":9},{"$f":"J118-J121","v":{"v":65652078.75586344,"d":"65,652,079 "}}]
[]
[{"$nulls":8},"Estimated FOM calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},{"$f":"I19","v":"Fixed O&M"},"Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":7807416.843749998,"d":"7,807,417 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR19","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"FOM NPV",{"$f":"NPV(WACC, K127:BB127)","v":{"v":18334702.369373266,"d":"18,334,702 "}}]
[{"$nulls":8},"Equivalent FOM costs",{"v":78074.16843750002,"d":"78,074 "}]
[{"$nulls":8},"Equivalent FOM stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J129 * O147","v":{"v":78074.16843750002,"d":"78,074 "}},{"$f":"$J129 * P147","v":{"v":78074.16843750002,"d":"78,074 "}},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":78074.16843750002,"d":"78,074 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J129 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, K130:BB130)","v":{"v":183347.02369373274,"d":"183,347 "}}]
[{"$nulls":9},{"$f":"J128-J131","v":{"v":18151355.345679533,"d":"18,151,355 "}}]
[]
[{"$nulls":8},"Estimated VOM calculation"]
[{"$nulls":10},-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
[]
[{"$nulls":8},{"$f":"I20","v":"Variable O&M"},"Nk",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":708472.8691884321,"d":"708,473 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"AR20","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"VOM NPV",{"$f":"NPV(WACC, K137:BB137)","v":{"v":1663756.3298217258,"d":"1,663,756 "}}]
[{"$nulls":8},"Equivalent VOM costs",{"v":7084.728691884258,"d":"7,085 "}]
[{"$nulls":8},"Equivalent VOM stream",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J139 * O147","v":{"v":7084.728691884258,"d":"7,085 "}},{"$f":"$J139 * P147","v":{"v":7084.728691884258,"d":"7,085 "}},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":7084.728691884258,"d":"7,085 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"$J139 * AR147","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":8},"Equivalent NPV",{"$f":"NPV(WACC, K140:BB140)","v":{"v":16637.563298217116,"d":"16,638 "}}]
[{"$nulls":9},{"$f":"J138-J141","v":{"v":1647118.7665235088,"d":"1,647,119 "}}]
[{"$nulls":8},"End - Equalization Calculations"]
[]
[]
[]
[{"$nulls":14},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Gen Prices","index":5,"n_rows":32,"n_cols":2034,"rows_kept":32}
[]
[]
[]
[null,"First Year Power",null,{"$f":"'Input Data'!F8","v":2028}]
[null,"Forex (N/$)",null,{"$f":"'Input Data'!F25","v":{"v":1600,"d":"1,600 "}}]
[null,"Delivered fuel price ($/MMbtu)",null,{"$f":"'Input Data'!F26","v":{"v":2.6,"d":"2.60"}}]
[null,"Capital cost (N/kW)",null,{"$f":"'Input Data'!F14*'Input Data'!F25","v":{"v":560000,"d":"560,000 "}}]
[null,"Fixed O&M (N/MW/year)",null,{"$f":"'Input Data'!F18","v":{"v":78074168.43749999,"d":"78,074,168 "}}]
[null,"Variable O&M (sent out) (N/MWh)",null,{"$f":"'Input Data'!F19","v":{"v":1030.8742573178608,"d":"1,031 "}}]
[null,"Real Pretax WACC",null,{"$f":"'Input Data'!F27","v":{"v":0.2,"d":"20.0%"}}]
[]
[null,"Fuel cost (N/MWh) (HHV)",null,{"v":41089.3490526316,"d":"41,089 "},{"$nulls":2029},0]
[null,"Fixed O&M (N/MWh)",null,{"v":11360.300994435247,"d":"11,360 "},{"$nulls":2029},0]
[null,"Variable O&M (N/MWh)",null,{"v":1030.8742573178606,"d":"1,031 "},{"$nulls":2029},0]
[null,"Capital cost (N/MWh)",null,{"v":18406.52062859319,"d":"18,407 "},{"$nulls":2029},0]
[null,"Tax cost (N/MWh)",null,{"v":6744.629604539556,"d":"6,745 "},{"$nulls":2029},0]
[null,"Wholesale contract prices (N/MWh)",null,{"$f":"SUM(D12:D16)","v":{"v":78631.67453751745,"d":"78,632 "}}]
{"$rows_empty":8}
[null,null,"Macro Control Section - Do Not Delete"]
[]
[{"$nulls":6},2028,"Enter First Year of Wholesale Prices Calculations"]
[{"$nulls":6},2028,"Enter Last Year of Wholesale Prices Calculations"]
[null,null,"Has the user certified the Fuel Page as correct",{"$nulls":3},"No"]
[]
[null,null,"End of Macro Control Section",{"$nulls":3},"Yes"]

{"sheet":"Basis-2011","index":6,"n_rows":18,"n_cols":8,"rows_kept":18,"hidden":true,"merged":[[2,0,2,2],[2,3,2,4]]}
[null,null,2,1.3,1.5]
[{"$nulls":3},2011,2012]
["Tariff Code",null,null,"Fixed N/month",null,null,"Energy N/Kwh"]
["Residential  R1",null,null,{"v":50,"d":"50.00"},{"$f":"D4*$D$1","v":{"v":65,"d":"65.00"}},null,{"v":2.2,"d":"2.20"},{"$f":"G4*$D$1","v":{"v":2.8600000000000003,"d":"2.86"}}]
["Residential  R2",null,null,{"v":300,"d":"300.00"},{"$f":"D5*$D$1","v":{"v":390,"d":"390.00"}},null,{"v":10,"d":"10.00"},{"$f":"G5*$E$1","v":{"v":15,"d":"15.00"}}]
["Residential  R3",null,null,{"v":12509,"d":"12,509.00"},{"$f":"D6*$C$1","v":{"v":25018,"d":"25,018.00"}},null,{"v":15.6,"d":"15.60"},{"$f":"G6*$E$1","v":{"v":23.4,"d":"23.40"}}]
["Residential  R4",null,null,{"v":78178,"d":"78,178.00"},{"$f":"D7*$E$1","v":{"v":117267,"d":"117,267.00"}},null,{"v":15.6,"d":"15.60"},{"$f":"G7*$E$1","v":{"v":23.4,"d":"23.40"}}]
["Commercial C1",null,null,{"v":272,"d":"272.00"},{"$f":"D8*$D$1","v":{"v":353.6,"d":"353.60"}},null,{"v":14.4,"d":"14.40"},{"$f":"G8*$D$1","v":{"v":18.720000000000002,"d":"18.72"}}]
["Commercial C2",null,null,{"v":11340,"d":"11,340.00"},{"$f":"D9*$C$1","v":{"v":22680,"d":"22,680.00"}},null,{"v":14.5,"d":"14.50"},{"$f":"G9*$E$1","v":21.75}]
["Commercial C3",null,null,{"v":70874,"d":"70,874.00"},{"$f":"D10*$E$1","v":{"v":106311,"d":"106,311.00"}},null,{"v":14.5,"d":"14.50"},{"$f":"G10*$E$1","v":21.75}]
["Industrial 1","D1",null,{"v":201,"d":"201.00"},{"$f":"D11*$D$1","v":{"v":261.3,"d":"261.30"}},null,{"v":11.7,"d":"11.70"},{"$f":"G11*$E$1","v":{"v":17.549999999999997,"d":"17.55"}}]
["Industrial D2",null,null,{"v":69733,"d":"69,733.00"},{"$f":"D12*$E$1","v":{"v":104599.5,"d":"104,599.50"}},null,{"v":15.2,"d":"15.20"},{"v":22.799999999999997,"d":"22.80"}]
["Industrial D3",null,null,{"v":70874,"d":"70,874.00"},{"$f":"D13*$E$1","v":{"v":106311,"d":"106,311.00"}},null,{"v":15.2,"d":"15.20"},{"v":22.799999999999997,"d":"22.80"}]
["Special 1",null,null,{"v":240,"d":"240.00"},{"$f":"D14*$D$1","v":{"v":312,"d":"312.00"}},null,{"v":11.2,"d":"11.20"},{"v":16.799999999999997,"d":"16.80"}]
["Special 2",null,null,{"v":31250,"d":"31,250.00"},{"$f":"D15*$D$1","v":{"v":40625,"d":"40,625.00"}},null,{"v":11.2,"d":"11.20"},{"v":16.799999999999997,"d":"16.80"}]
["Special 3",null,null,{"v":31250,"d":"31,250.00"},{"$f":"D16*$D$1","v":{"v":40625,"d":"40,625.00"}},null,{"v":11.2,"d":"11.20"},{"v":16.799999999999997,"d":"16.80"}]
["Street Lightng S1",null,null,{"v":451,"d":"451.00"},{"$f":"D17*$D$1","v":{"v":586.3000000000001,"d":"586.30"}},null,{"v":8.6,"d":"8.60"},{"v":12.899999999999999,"d":"12.90"}]
[{"$nulls":7}," "]