{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Discussion","General Inputs","Original FM","Actual Financial Data","Change Analysis","Revised Forecast","Graph Data from Match","Graph Actual vs FM","Actual vs FM","FM Comparison Chart","FM with History","IRR and Growth","Data from PDF","Reformatted Data","Tenaga Chart","Waterfall Chart1","Waterfall Chartdata1"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Actual vs FM","index":8,"reason":"not_a_worksheet"},{"sheet":"FM Comparison Chart","index":9,"reason":"not_a_worksheet"},{"sheet":"FM with History","index":10,"reason":"not_a_worksheet"},{"sheet":"Tenaga Chart","index":14,"reason":"not_a_worksheet"},{"sheet":"Waterfall Chart1","index":15,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Discussion","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Comparison of Actuals and Projections"]
[]
[null,"Step 1: Introduction Analysis of Project Finance Model"]
[null,null,"Financial Model and ROE, ROIC"]
[null,null,"Presentation Issues"]
[null,null,"Forecasting Methods"]
[]
[null,"Step 2: Optional, Compute Economic Depreciation"]
[null,null,"PPMT Function without inflation"]
[null,null,"PPMT Function with Remaining Life"]
[null,null,"PPMT Function with Inflation"]
[]
[null,"Step 3: Enter the Actuals in New Sheet"]
[null,null,"Compare Actual and Financial Model"]
[null,null,"Compute Waterfall Chart"]
[null,null,"Use Match and Index to Find Data and Graph"]
[null,null,"Make Chart in terms % of Revenue or % of Units Sold etc."]
[null,null,"Adjusted Min or Max on Chart"]
[]
[null,"Step 4: Compute Generation, Revenues, Expenses and Cap Exp in Actual/Forecast Sheet"]
[null,null,"Present Average and Last Data"]
[null,null,"Use Match for Forecast Method"]
[null,null,"Use Choose for Alternative Forecasts"]
[]
[null,"Step 5: Add Scenario Page"]
[null,null,"Create Standard Scenario Page with Code Number and Index"]
[null,null,"Demonstrate the effect of different forecasts"]
[]
[]
[]
[null,"Step 5: Graph Actual/Forecast"]

{"sheet":"General Inputs","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Last Year of Actuals",null,null,2013]

{"sheet":"Original FM","index":2,"n_rows":84,"n_cols":23,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
["Financial Model"]
[null,null,null,null,null,2008,{"$f":"F3+1","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Production"]
[null,null,"Gross Energy","MWH",null,null,150000,{"$f":"G5*0.985","v":147750},{"$f":"H5*0.985","v":145533.75},143350.74374999999,141200.48259375,139082.47535484374,136996.23822452108,134941.29465115326,132917.17523138598,130923.41760291519,128959.56633887146,127025.17284378839,125119.79525113155,123242.99832236458,121394.35334752912,119573.43804731619,117779.83647660645]
[null,null,"Energy for Outage","MWH",null,null,{"$f":"G5*0.08","v":12000},{"$f":"H5*0.08","v":11820},11642.7,11468.059499999999,11296.038607500001,11126.5980283875,10959.699057961687,10795.303572092262,10633.374018510878,10473.873408233216,10316.765307109717,10162.013827503071,10009.583620090525,9859.439865789167,9711.5482678023291,9565.8750437852959,9422.3869181285154]
[null,null,"Net Energy","MWH",null,null,{"$f":"G5-G6","v":138000},135930,133891.04999999999,131882.68424999999,129904.44398625,127955.87732645625,126036.53916655939,124145.991079061,122283.8012128751,120449.54419468198,118642.80103176174,116863.15901628531,115110.21163104102,113383.55845657541,111682.80507972679,110007.56300353089,108357.44955847794]
[]
[null,"Revenue and Expense"]
[null,null,"Price of Energy","RM/MWH",null,null,150,{"$f":"G10*1.02","v":153},{"$f":"H10*1.02","v":156.06},159.18120000000002,162.36482400000003,165.61212048000004,168.92436288960005,172.30285014739206,175.7489071503399,179.2638852933467,182.84916299921363,186.50614625919792,190.23626918438188,194.04099456806952,197.92181445943092,201.88025074861955,205.91785576359194]
[null,null,"Revenue","RM 000's",null,null,{"$f":"G10*G7/1000","v":20700},{"$f":"H10*H7/1000","v":20797.29},20895.037263000002,20993.2439381361,21091.912184645342,21191.044171913178,21290.642079521167,21390.708097294919,21491.244425352208,21592.253274151364,21693.736864539875,21795.69742780321,21898.137205713887,22001.058450580742,22104.463425298476,22208.354403397378,22312.733669093348]
[]
[null,null,"Royalty Expense","RM 000's",null,null,{"$f":"G11*0.09","v":1863},{"$f":"H11*0.09","v":1871.7561000000001},1880.5533536700002,1889.3919544322489,1898.2720966180807,1907.1939754721859,1916.157787156905,1925.1637287565427,1934.2119982816987,1943.3027946736227,1952.4363178085887,1961.6127685022889,1970.8323485142498,1980.0952605522666,1989.4017082768628,1998.7518963057639,2008.1460302184012]
[null,null,"Labour at Plant - Operations","RM 000's",null,null,3200,{"$f":"G14*1.015","v":3247.9999999999995},{"$f":"H14*1.015","v":3296.7199999999993},3346.170799999999,3396.3633619999987,3447.3088124299984,3499.0184446164481,3551.5037212856946,3604.7762771049797,3658.8479212615539,3713.7306400804769,3769.4365996816837,3825.9781486769084,3883.3678209070617,3941.6183382206673,4000.7426132939768,4060.7537524933859]
[null,null,"Materials for Maintenance","RM 000's",null,null,800,{"$f":"G15*0.98","v":784},{"$f":"H15*0.98","v":768.31999999999994},752.95359999999994,737.89452799999992,723.13663743999996,708.67390469119994,694.50042659737596,680.61041806542846,666.99820970411986,653.65824551003743,640.58508059983672,627.77337898783992,615.21791140808307,602.91355317992145,590.855282116323,579.03817647399649]
[null,null,"Labour for Maintenance","RM 000's",null,null,2500,{"$f":"G16*1.01","v":2525},{"$f":"H16*1.01","v":2550.25},2575.7525000000001,2601.510025,2627.5251252500002,2653.8003765025001,2680.3383802675253,2707.1417640702007,2734.2131817109025,2761.5553135280115,2789.1708666632917,2817.0625753299246,2845.2332010832238,2873.6855330940562,2902.4223884249968,2931.446612309247]
[null,null,"Other Admin Expense","RM 000's",null,null,750,{"$f":"G17*1.005","v":753.74999999999989},{"$f":"H17*1.005","v":757.51874999999984},761.30634374999977,765.11287546874973,768.93843984609339,772.78313204532378,776.64704770555034,780.53028294407795,784.43293435879821,788.3550990305921,792.29687452574501,796.25835889837367,800.23965069286544,804.24084894632972,808.26205319106123,812.30336345701642]
[null,null,"Insurance Expense","RM 000's",null,null,1300,{"$f":"G18","v":1300},{"$f":"H18","v":1300},1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300]
[null,null,"Total Expense","RM 000's",null,null,{"$f":"SUM(G13:G18)","v":10413},{"$f":"SUM(H13:H18)","v":10482.506099999999},10553.362103669999,10625.575198182249,10699.152887086828,10774.102990438278,10850.433645012377,10928.153304612688,11007.270740466385,11087.795041708998,11169.735615957707,11253.102189972848,11337.904810407297,11424.153844643501,11511.859981717836,11601.034233332122,11691.687934952048]
[]
[null,null,"EBITDA",null,null,null,{"$f":"G11-G19","v":10287},{"$f":"H11-H19","v":10314.783900000002},10341.675159330003,10367.668739953851,10392.759297558514,10416.9411814749,10440.20843450879,10462.554792682231,10483.973684885823,10504.458232442366,10524.001248582168,10542.595237830363,10560.23239530659,10576.904605937241,10592.60344358064,10607.320170065255,10621.0457341413]
[null,null,"Initial Capital Expenditure","RM 000's",null,100000]
[null,null,"On-Going Capital Expenditure","RM 000's",null,null,0,{"$f":"G23","v":0},{"$f":"H23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Project Cash Flow",null,null,{"$f":"F21-F22","v":-100000},{"$f":"G21-G23","v":10287},{"$f":"H21-H23","v":10314.783900000002},10341.675159330003,10367.668739953851,10392.759297558514,10416.9411814749,10440.20843450879,10462.554792682231,10483.973684885823,10504.458232442366,10524.001248582168,10542.595237830363,10560.23239530659,10576.904605937241,10592.60344358064,10607.320170065255,10621.0457341413]
[null,null,"Pre-Tax Project IRR",null,null,{"$f":"IRR(24:24)","v":7.2741274128157229E-2}]
[]
[null,null,"Debt %",null,null,0.8]
[null,null,"Interest  Rate",null,null,3.5999999999999997E-2]
[null,null,"Debt Tenure",null,null,15]
[]
["Debt Schedule"]
[null,null,"Debt Financing","RM 000's",null,{"$f":"F27*F22","v":80000}]
[]
[null,null,"Opening balance","RM 000's",null,null,{"$f":"F36","v":80000},74666.666666666672,69333.333333333343,64000.000000000007,58666.666666666672,53333.333333333336,48000,42666.666666666664,37333.333333333328,31999.999999999996,26666.666666666664,21333.333333333332,16000,10666.666666666668,5333.3333333333348,0,0]
[null,null,"Debt Repayment","RM 000's",null,null,{"$f":"MIN($F$36/$F$29,G34)","v":5333.333333333333},5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,5333.333333333333,0,0]
[null,null,"Closing balance","RM 000's",null,{"$f":"F32","v":80000},{"$f":"G34-G35","v":74666.666666666672},69333.333333333343,64000.000000000007,58666.666666666672,53333.333333333336,48000,42666.666666666664,37333.333333333328,31999.999999999996,26666.666666666664,21333.333333333332,16000,10666.666666666668,5333.3333333333348,0,0,0]
[]
[null,null,"Interest expense","RM 000's",null,null,{"$f":"G34*$F$28","v":2880},2688,2496,2304,2112,1920,1727.9999999999998,1535.9999999999998,1343.9999999999998,1151.9999999999998,959.99999999999989,767.99999999999989,576,384,192.00000000000003,0,0]
[]
["Accounting Analysis"]
[null,"Profit and Loss"]
[null,null,"EBITDA","RM 000's",null,null,{"$f":"G21","v":10287},10314.783900000002,10341.675159330003,10367.668739953851,10392.759297558514,10416.9411814749,10440.20843450879,10462.554792682231,10483.973684885823,10504.458232442366,10524.001248582168,10542.595237830363,10560.23239530659,10576.904605937241,10592.60344358064,10607.320170065255,10621.0457341413]
[null,null,"Depreciation","RM 000's",null,null,{"$f":"$F$22/17","v":5882.3529411764703},5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703,5882.3529411764703]
[null,null,"EBIT ",null,null,null,{"$f":"G42-G43","v":4404.6470588235297},4432.4309588235319,4459.322218153533,4485.3157987773811,4510.4063563820437,4534.5882402984298,4557.8554933323194,4580.2018515057607,4601.6207437093526,4622.1052912658961,4641.6483074056978,4660.2422966538925,4677.8794541301195,4694.551664760771,4710.2505024041693,4724.967228888785,4738.69279296483]
[null,null,"Interest","RM 000's",null,null,{"$f":"G38","v":2880},2688,2496,2304,2112,1920,1727.9999999999998,1535.9999999999998,1343.9999999999998,1151.9999999999998,959.99999999999989,767.99999999999989,576,384,192.00000000000003,0,0]
[null,null,"EBT=PAT","RM 000's",null,null,{"$f":"G44-G45","v":1524.6470588235297},1744.4309588235319,1963.322218153533,2181.3157987773811,2398.4063563820437,2614.5882402984298,2829.8554933323194,3044.2018515057607,3257.6207437093526,3470.1052912658961,3681.6483074056978,3892.2422966538925,4101.8794541301195,4310.551664760771,4518.2505024041693,4724.967228888785,4738.69279296483]
[]
[null,"Cashflow Statement"]
[null,null,"EBITDA","RM 000's",null,null,{"$f":"G42","v":10287},10314.783900000002,10341.675159330003,10367.668739953851,10392.759297558514,10416.9411814749,10440.20843450879,10462.554792682231,10483.973684885823,10504.458232442366,10524.001248582168,10542.595237830363,10560.23239530659,10576.904605937241,10592.60344358064,10607.320170065255,10621.0457341413]
[null,null,"Debt Service","RM 000's",null,null,{"$f":"G35+G45","v":8213.3333333333321},8021.333333333333,7829.333333333333,7637.333333333333,7445.333333333333,7253.333333333333,7061.333333333333,6869.333333333333,6677.333333333333,6485.333333333333,6293.333333333333,6101.333333333333,5909.333333333333,5717.333333333333,5525.333333333333,0,0]
[null,null,"Dividend",null,null,null,{"$f":"G49-G50","v":2073.6666666666679},2293.4505666666691,2512.3418259966702,2730.3354066205184,2947.4259642251809,3163.607848141567,3378.8751011754566,3593.221459348898,3806.6403515524898,4019.1248991090333,4230.667915248835,4441.2619044970297,4650.8990619732567,4859.5712726039083,5067.2701102473065,10607.320170065255,10621.0457341413]
[null,null,"Equity Cashflow","RM 000's",null,{"$f":"-F22+F36","v":-20000},{"$f":"G51","v":2073.6666666666679},2293.4505666666691,2512.3418259966702,2730.3354066205184,2947.4259642251809,3163.607848141567,3378.8751011754566,3593.221459348898,3806.6403515524898,4019.1248991090333,4230.667915248835,4441.2619044970297,4650.8990619732567,4859.5712726039083,5067.2701102473065,10607.320170065255,10621.0457341413]
[null,null,"Equity IRR",null,null,{"$f":"IRR(52:52)","v":0.15021954324622699}]
[]
["Accounting  Analysis - B&S"]
[null,"Assets"]
[null,null,"Net Plant Balance","RM 000's",null,{"$f":"F22","v":100000},{"$f":"F57-G43","v":94117.647058823524},88235.294117647049,82352.941176470573,76470.588235294097,70588.235294117621,64705.882352941153,58823.529411764684,52941.176470588216,47058.823529411748,41176.470588235279,35294.117647058811,29411.764705882342,23529.411764705874,17647.058823529405,11764.705882352935,5882.3529411764648,0]
[]
[null,"Liability & Capital"]
[null,null,"Borrowings","RM 000's",null,{"$f":"F36","v":80000},74666.666666666672,69333.333333333343,64000.000000000007,58666.666666666672,53333.333333333336,48000,42666.666666666664,37333.333333333328,31999.999999999996,26666.666666666664,21333.333333333332,16000,10666.666666666668,5333.3333333333348,0,0,0]
[null,null,"Equity Capital","RM 000's",null,{"$f":"F22-F36","v":20000},{"$f":"F61+G46-G51","v":19450.980392156864},18901.960784313724,18352.941176470587,17803.921568627451,17254.901960784311,16705.882352941175,16156.862745098035,15607.843137254898,15058.823529411758,14509.803921568622,13960.784313725482,13411.764705882346,12862.74509803921,12313.725490196073,11764.705882352937,5882.3529411764666,0]
[null,null,"Total liabilities & Capital","RM 000's",null,{"$f":"SUM(F60:F61)","v":100000},94117.647058823539,88235.294117647063,82352.941176470602,76470.588235294126,70588.23529411765,64705.882352941175,58823.529411764699,52941.176470588223,47058.823529411755,41176.470588235286,35294.117647058811,29411.764705882346,23529.411764705877,17647.058823529409,11764.705882352937,5882.3529411764666,0]
[]
[null,null,null,null,null,{"$f":"F57-F62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Balance Test",null,null,{"$f":"ROUND(F64,2)=0","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]
[null,null,"Aggregate Test",null,null,{"$f":"AND(F65:W65)","v":true}]
[]
[null,null,"Return on Assets (ROA)",null,null,null,{"$f":"G44/F57","v":4.4046470588235298E-2},4.7094578937500027E-2,5.0538985139073379E-2,5.4464548985153925E-2,5.8982236968072893E-2,6.4240000070894449E-2,7.0439584896954052E-2,7.7863431475597961E-2,8.6919502936732243E-2,9.8219737439400323E-2,0.11272574460842413,0.13204019840519368,0.15904790144042413,0.19951844575233285,0.26691419513623638,0.40162221445554691,0.80557777480402193]
[null,null,"Return on Equity (ROE)",null,null,null,{"$f":"G46/F61","v":7.6232352941176487E-2},8.9683446471774314E-2,0.10386870656206451,0.11885374544620346,0.13471225129458617,0.15152727301729538,0.16939275840369519,0.18841540585775951,0.20871690694620229,0.23043667949812602,0.25373522118606845,0.27879825439515254,0.30584188912373717,0.33511910808353573,0.36692798666021137,0.40162221445554686,0.8055777748040216]
[null,null,"DSCR"]
[]
["Alternative Accounting",null,null,null,null,null,1,{"$f":"G72+1","v":2},{"$f":"H72+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,null,"Depreciation PPMT",null,{"$f":"F25","v":7.2741274128157229E-2},null,{"$f":"PPMT($E$73,G72,17,-1)","v":3.1636997605359062E-2},{"$f":"PPMT($E$73,H72,17,-1)","v":3.3938313120762335E-2},3.6407029258926943E-2,3.9055322954442397E-2,4.1896256907635196E-2,4.4943844016297189E-2,4.82131164942598E-2,5.1720200017741538E-2,5.5482393265195197E-2,5.9518253242984979E-2,6.3847686817762039E-2,6.849204890702161E-2,7.347424781216641E-2,7.8818858213631354E-2,8.4552242385417462E-2,9.0702680226925514E-2,9.7300508753470905E-2]
[null,null,"Alternative Deprecation",null,null,{"$f":"F57","v":100000},{"$f":"$F$74*G73","v":3163.6997605359061},{"$f":"$F$74*H73","v":3393.8313120762336},3640.7029258926941,3905.5322954442395,4189.6256907635197,4494.3844016297189,4821.3116494259802,5172.0200017741536,5548.2393265195196,5951.8253242984983,6384.7686817762042,6849.2048907021608,7347.4247812166413,7881.8858213631356,8455.2242385417467,9070.2680226925513,9730.0508753470913]
[]
[null,null,"EBIT",null,null,null,{"$f":"G49-G74","v":7123.3002394640935},{"$f":"H49-H74","v":6920.9525879237681},6700.9722334373091,6462.1364445096115,6203.1336067949942,5922.5567798451812,5618.8967850828094,5290.5347909080774,4935.7343583663032,4552.632908143868,4139.2325668059639,3693.3903471282019,3212.8076140899484,2695.0187845741057,2137.3792050388929,1537.052147372704,890.99485879420899]
[null,null,"Net Plant",null,null,{"$f":"F74","v":100000},{"$f":"F77-G74","v":96836.300239464093},93442.468927387861,89801.766001495169,85896.233706050931,81706.608015287406,77212.223613657683,72390.911964231709,67218.89196245755,61670.65263593803,55718.827311639528,49334.058629863328,42484.853739161168,35137.428957944525,27255.543136581389,18800.318898039644,9730.0508753470931,0]
[]
[null,null,"Return on Capital",null,null,null,{"$f":"G76/F77","v":7.1233002394640935E-2},{"$f":"H76/G77","v":7.14706424224089E-2},7.1712277194264748E-2,7.1960015178343148E-2,7.2216595992124585E-2,7.2485652307792095E-2,7.2772114596747747E-2,7.3082858709144688E-2,7.3427785169725229E-2,7.3821707952720139E-2,7.4287862227518348E-2,7.4864919889086251E-2,7.5622423789315912E-2,7.6699373417438543E-2,7.8419982105224717E-2,8.1756706134010107E-2,9.1571449133088442E-2]
[]
[null,null,null,null,null,null,0,{"$f":"G81+1","v":1},{"$f":"H81+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,null,null,null,null,17,{"$f":"G82-1","v":16},{"$f":"H82-1","v":15},14,13,12,11,10,9,8,7,6,5,4,3,2,1]
[null,null,"Depreciation Rate on Remaining Balance",null,null,null,null,{"$f":"PPMT($E$73,H72-H81,H82,-1)","v":3.5047098078754675E-2},{"$f":"PPMT($E$73,I72-I81,I82,-1)","v":3.8961972727002823E-2},4.349059566800962E-2,4.8775429492066112E-2,5.5006375993344556E-2,6.2442336508142765E-2,7.1445708603997765E-2,8.2539880746892849E-2,9.6509848200149004E-2,0.11458907141145881,0.138833193151397,0.17294221668566137,0.22431595182438788,0.31022035393576347,0.48245288135183345,0.99999999999999989]
[null,null,"Economic Depreciation",null,null,null,null,{"$f":"H83*G77","v":3393.8313120762327},{"$f":"I83*H77","v":3640.7029258926946},3905.5322954442395,4189.6256907635197,4494.3844016297189,4821.3116494259802,5172.0200017741545,5548.2393265195205,5951.8253242984983,6384.7686817762033,6849.204890702159,7347.4247812166413,7881.8858213631356,8455.2242385417467,9070.2680226925531,9730.0508753470913]

{"sheet":"Actual Financial Data","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
["Actual"]
[null,"Last Year Actual",null,null,{"$f":"'General Inputs'!E3","v":2013}]
[]
[null,"Year",null,null,null,2008,{"$f":"F5+1","v":2009},{"$f":"G5+1","v":2010},{"$f":"H5+1","v":2011},{"$f":"I5+1","v":2012},{"$f":"J5+1","v":2013}]
[null,"Switch",null,null,null,null,{"$f":"G5<=$E$3","v":true},{"$f":"H5<=$E$3","v":true},true,true,true]
[]
[null,{"$f":"'Original FM'!C5","v":"Gross Energy"},null,"MWH",null,null,135000,140000,138000,136000,135500]
[null,null,{"$f":"'Original FM'!C6","v":"Energy for Outage"},"MWH",null,null,11000,12000,12000,11500,12000]
[null,{"$f":"'Original FM'!C7","v":"Net Energy"},null,"MWH",null,null,{"$f":"G8-G9","v":124000},{"$f":"H8-H9","v":128000},126000,124500,123500]
[]
[null,"Revenue and Expense"]
[null,{"$f":"'Original FM'!C10","v":"Price of Energy"},null,"RM/MWH",null,null,150,{"$f":"G13*1.02","v":153},{"$f":"H13*1.02","v":156.06},159.18120000000002,162.36482400000003]
[null,"Revenue",null,"RM 000's",null,null,{"$f":"G13*G10/1000","v":18600},{"$f":"H13*H10/1000","v":19584},19663.560000000001,19818.059400000002,20052.055764000001]
[]
[null,{"$f":"'Original FM'!C13","v":"Royalty Expense"},null,"RM 000's",null,null,1500,1400,1350,1400,1340]
[null,{"$f":"'Original FM'!C14","v":"Labour at Plant - Operations"},null,"RM 000's",null,null,3100,3500,2800,3005,3030]
[null,{"$f":"'Original FM'!C15","v":"Materials for Maintenance"},null,"RM 000's",null,null,905,700,650,400,450]
[null,{"$f":"'Original FM'!C16","v":"Labour for Maintenance"},null,"RM 000's",null,null,3040,2700,2600,3100,3500]
[null,{"$f":"'Original FM'!C17","v":"Other Admin Expense"},null,"RM 000's",null,null,650,630,640,800,620]
[null,{"$f":"'Original FM'!C18","v":"Insurance Expense"},null,"RM 000's",null,null,1250,1500,1400,1305,1402]
[null,"Total Expense",null,"RM 000's",null,null,{"$f":"SUM(G16:G21)","v":10445},{"$f":"SUM(H16:H21)","v":10430},9440,10010,10342]
[]
[null,"EBITDA",null,null,null,null,{"$f":"G14-G22","v":8155},{"$f":"H14-H22","v":9154},10223.560000000001,9808.0594000000019,9710.0557640000006]
[]
[null,"On-Going Capital Expenditure",null,"RM 000's",null,null,30,0,450,470,700]
[null,"Remaining Life",null,null,null,null,17,{"$f":"G27-1","v":16},{"$f":"H27-1","v":15},14,13]
[null,"Depreciation Rate",null,null,null,null,{"$f":"1/G27","v":5.8823529411764705E-2},{"$f":"1/H27","v":6.25E-2},6.6666666666666666E-2,7.1428571428571425E-2,7.6923076923076927E-2]
[null,"Depreciaiton Expense",null,null,null,null,{"$f":"G28*F32","v":6764.7058823529414},{"$f":"H28*G32","v":6764.7058823529414},6764.7058823529414,6764.7058823529414,6764.7058823529433]
[]
["Balance Sheet"]
[null,"Net plant balance",null,null,null,115000,{"$f":"F32-G29","v":108235.29411764706},{"$f":"G32-H29","v":101470.58823529413},94705.882352941189,87941.176470588252,81176.470588235316]
[null,"Debt",null,null,null,80000,74666.666666666672,69333.333333333343,64000.000000000007,58666.666666666672,53333.333333333336]
[null,"Equity balance",null,null,null,{"$f":"F32-F33","v":35000},{"$f":"G32-G33","v":33568.627450980392},32137.254901960783,30705.882352941182,29274.509803921581,27843.13725490198]

{"sheet":"Change Analysis","index":4,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Year",2011]
[null,null,"Match",{"$f":"MATCH(D3,F6:J6,0)","v":3}]
[null,null,null,null,null,"Actual vs Financial Model Forecast"]
[null,null,null,{"$f":"INDEX(F6:J6,$D$4)","v":2011},null,{"$f":"'Original FM'!G3","v":2009},{"$f":"'Original FM'!H3","v":2010},{"$f":"'Original FM'!I3","v":2011},{"$f":"'Original FM'!J3","v":2012},{"$f":"'Original FM'!K3","v":2013}]
[null,null,"EBITDA in FM",{"$f":"INDEX(F7:J7,$D$4)","v":10341.675159330003},null,{"$f":"'Original FM'!G21","v":10287},{"$f":"'Original FM'!H21","v":10314.783900000002},{"$f":"'Original FM'!I21","v":10341.675159330003},{"$f":"'Original FM'!J21","v":10367.668739953851},{"$f":"'Original FM'!K21","v":10392.759297558514}]
[null,null,"Reduced Revenue",{"$f":"INDEX(F8:J8,$D$4)","v":-1231.4772630000007},null,{"$f":"'Actual Financial Data'!G14-'Original FM'!G11","v":-2100},{"$f":"'Actual Financial Data'!H14-'Original FM'!H11","v":-1213.2900000000009},{"$f":"'Actual Financial Data'!I14-'Original FM'!I11","v":-1231.4772630000007},{"$f":"'Actual Financial Data'!J14-'Original FM'!J11","v":-1175.1845381360981},{"$f":"'Actual Financial Data'!K14-'Original FM'!K11","v":-1039.8564206453411}]
[null,null,"Sub Total"]
[null,null,"Royalty Expense",{"$f":"INDEX(F10:J10,$D$4)","v":530.55335367000021},null,{"$f":"'Original FM'!G13-'Actual Financial Data'!G16","v":363},{"$f":"'Original FM'!H13-'Actual Financial Data'!H16","v":471.75610000000006},{"$f":"'Original FM'!I13-'Actual Financial Data'!I16","v":530.55335367000021},{"$f":"'Original FM'!J13-'Actual Financial Data'!J16","v":489.39195443224889},{"$f":"'Original FM'!K13-'Actual Financial Data'!K16","v":558.2720966180807}]
[null,null,"Labour at Plant - Operations",496.71999999999935,null,{"$f":"'Original FM'!G14-'Actual Financial Data'!G17","v":100},{"$f":"'Original FM'!H14-'Actual Financial Data'!H17","v":-252.00000000000045},{"$f":"'Original FM'!I14-'Actual Financial Data'!I17","v":496.71999999999935},{"$f":"'Original FM'!J14-'Actual Financial Data'!J17","v":341.17079999999896},{"$f":"'Original FM'!K14-'Actual Financial Data'!K17","v":366.36336199999869}]
[null,null,"Materials for Maintenance",118.31999999999994,null,{"$f":"'Original FM'!G15-'Actual Financial Data'!G18","v":-105},{"$f":"'Original FM'!H15-'Actual Financial Data'!H18","v":84},{"$f":"'Original FM'!I15-'Actual Financial Data'!I18","v":118.31999999999994},{"$f":"'Original FM'!J15-'Actual Financial Data'!J18","v":352.95359999999994},{"$f":"'Original FM'!K15-'Actual Financial Data'!K18","v":287.89452799999992}]
[null,null,"Labour for Maintenance",-49.75,null,{"$f":"'Original FM'!G16-'Actual Financial Data'!G19","v":-540},{"$f":"'Original FM'!H16-'Actual Financial Data'!H19","v":-175},{"$f":"'Original FM'!I16-'Actual Financial Data'!I19","v":-49.75},{"$f":"'Original FM'!J16-'Actual Financial Data'!J19","v":-524.24749999999995},{"$f":"'Original FM'!K16-'Actual Financial Data'!K19","v":-898.48997499999996}]
[null,null,"Other Admin Expense",117.51874999999984,null,{"$f":"'Original FM'!G17-'Actual Financial Data'!G20","v":100},{"$f":"'Original FM'!H17-'Actual Financial Data'!H20","v":123.74999999999989},{"$f":"'Original FM'!I17-'Actual Financial Data'!I20","v":117.51874999999984},{"$f":"'Original FM'!J17-'Actual Financial Data'!J20","v":-38.693656250000231},{"$f":"'Original FM'!K17-'Actual Financial Data'!K20","v":145.11287546874973}]
[null,null,"Insurance Expense",-100,null,{"$f":"'Original FM'!G18-'Actual Financial Data'!G21","v":50},{"$f":"'Original FM'!H18-'Actual Financial Data'!H21","v":-200},{"$f":"'Original FM'!I18-'Actual Financial Data'!I21","v":-100},{"$f":"'Original FM'!J18-'Actual Financial Data'!J21","v":-5},{"$f":"'Original FM'!K18-'Actual Financial Data'!K21","v":-102}]
[null,null,"EBITDA Actual",null,null,{"$f":"SUM(F7:F15)","v":8155},{"$f":"SUM(G7:G15)","v":9154.0000000000018},10223.560000000001,9808.0594000000019,9710.0557640000006]
[]
[null,null,"Check",null,null,{"$f":"F16='Actual Financial Data'!G24","v":true},{"$f":"G16='Actual Financial Data'!H24","v":true},{"$f":"H16='Actual Financial Data'!I24","v":true},{"$f":"I16='Actual Financial Data'!J24","v":true},{"$f":"J16='Actual Financial Data'!K24","v":true}]
[]
[]
[null,null,"Comparison of Financial Model with Actuals for",null,null,{"$f":"D3","v":2011}]

{"sheet":"Revised Forecast","index":5,"n_rows":69,"n_cols":28,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"Last Year Actual",null,null,null,null,null,null,null,null,null,{"$f":"'Original FM'!G3","v":2009},{"$f":"'Original FM'!H3","v":2010},{"$f":"'Original FM'!I3","v":2011},{"$f":"'Original FM'!J3","v":2012},{"$f":"'Original FM'!K3","v":2013},{"$f":"'Original FM'!L3","v":2014},{"$f":"'Original FM'!M3","v":2015},{"$f":"'Original FM'!N3","v":2016},{"$f":"'Original FM'!O3","v":2017},{"$f":"'Original FM'!P3","v":2018},{"$f":"'Original FM'!Q3","v":2019},{"$f":"'Original FM'!R3","v":2020},{"$f":"'Original FM'!S3","v":2021},{"$f":"'Original FM'!T3","v":2022},{"$f":"'Original FM'!U3","v":2023},{"$f":"'Original FM'!V3","v":2024},{"$f":"'Original FM'!W3","v":2025}]
[null,"Historic Switch",null,2013,null,null,null,null,null,null,null,{"$f":"L1<=$D$2","v":true},true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false]
[]
["Production, Revenues and Expense"]
[null,null,null,null,null,"Code","Avg Hist","Last His","Input","Growth"]
[null,"Gross Energy",null,"MWH","Financial Model ",{"$f":"MATCH(E6,'Graph Data from Match'!$C$113:$C$117,0)","v":3},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!8:8)","v":136900},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!8:8)","v":135500},136000,-0.01,null,{"$f":"IF(L$2,'Actual Financial Data'!G8,CHOOSE($F6,$G6,$H6,'Original FM'!G5,$I6,L61)*(1+$J6))","v":135000},{"$f":"IF(M2,'Actual Financial Data'!H8,CHOOSE($F6,$G6,$H$6,'Original FM'!H5,$I6,M61))","v":140000},{"$f":"IF(N2,'Actual Financial Data'!I8,CHOOSE($F6,$G6,$H$6,'Original FM'!I5,$I6,N61))","v":138000},{"$f":"IF(O2,'Actual Financial Data'!J8,CHOOSE($F6,$G6,$H$6,'Original FM'!J5,$I6,O61))","v":136000},{"$f":"IF(P2,'Actual Financial Data'!K8,CHOOSE($F6,$G6,$H$6,'Original FM'!K5,$I6,P61))","v":135500},{"$f":"IF(Q2,'Actual Financial Data'!L8,CHOOSE($F6,$G6,$H$6,'Original FM'!L5,$I6,Q61))","v":139082.47535484374},{"$f":"IF(R2,'Actual Financial Data'!M8,CHOOSE($F6,$G6,$H$6,'Original FM'!M5,$I6,R61))","v":136996.23822452108},{"$f":"IF(S2,'Actual Financial Data'!N8,CHOOSE($F6,$G6,$H$6,'Original FM'!N5,$I6,S61))","v":134941.29465115326},{"$f":"IF(T2,'Actual Financial Data'!O8,CHOOSE($F6,$G6,$H$6,'Original FM'!O5,$I6,T61))","v":132917.17523138598},{"$f":"IF(U2,'Actual Financial Data'!P8,CHOOSE($F6,$G6,$H$6,'Original FM'!P5,$I6,U61))","v":130923.41760291519},{"$f":"IF(V2,'Actual Financial Data'!Q8,CHOOSE($F6,$G6,$H$6,'Original FM'!Q5,$I6,V61))","v":128959.56633887146},{"$f":"IF(W2,'Actual Financial Data'!R8,CHOOSE($F6,$G6,$H$6,'Original FM'!R5,$I6,W61))","v":127025.17284378839},{"$f":"IF(X2,'Actual Financial Data'!S8,CHOOSE($F6,$G6,$H$6,'Original FM'!S5,$I6,X61))","v":125119.79525113155},{"$f":"IF(Y2,'Actual Financial Data'!T8,CHOOSE($F6,$G6,$H$6,'Original FM'!T5,$I6,Y61))","v":123242.99832236458},{"$f":"IF(Z2,'Actual Financial Data'!U8,CHOOSE($F6,$G6,$H$6,'Original FM'!U5,$I6,Z61))","v":121394.35334752912},{"$f":"IF(AA2,'Actual Financial Data'!V8,CHOOSE($F6,$G6,$H$6,'Original FM'!V5,$I6,AA61))","v":119573.43804731619},{"$f":"IF(AB2,'Actual Financial Data'!W8,CHOOSE($F6,$G6,$H$6,'Original FM'!W5,$I6,AB61))","v":117779.83647660645}]
[null,"Energy for Outage",null,"MWH","Last History",{"$f":"MATCH(E7,'Graph Data from Match'!$C$113:$C$117,0)","v":2},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!9:9)","v":11700},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!9:9)","v":12000},11600,-5.0000000000000001E-3,null,{"$f":"IF(L$2,'Actual Financial Data'!G9,CHOOSE($F7,$G7,$H7,'Original FM'!G6,$I7,L62)*(1+$J7))","v":11000},{"$f":"IF(M$2,'Actual Financial Data'!H9,CHOOSE($F7,$G7,$H7,'Original FM'!H6,$I7,M62)*(1+$J7))","v":12000},{"$f":"IF(N$2,'Actual Financial Data'!I9,CHOOSE($F7,$G7,$H7,'Original FM'!I6,$I7,N62)*(1+$J7))","v":12000},{"$f":"IF(O$2,'Actual Financial Data'!J9,CHOOSE($F7,$G7,$H7,'Original FM'!J6,$I7,O62)*(1+$J7))","v":11500},{"$f":"IF(P$2,'Actual Financial Data'!K9,CHOOSE($F7,$G7,$H7,'Original FM'!K6,$I7,P62)*(1+$J7))","v":12000},{"$f":"IF(Q$2,'Actual Financial Data'!L9,CHOOSE($F7,$G7,$H7,'Original FM'!L6,$I7,Q62)*(1+$J7))","v":11940},{"$f":"IF(R$2,'Actual Financial Data'!M9,CHOOSE($F7,$G7,$H7,'Original FM'!M6,$I7,R62)*(1+$J7))","v":11940},{"$f":"IF(S$2,'Actual Financial Data'!N9,CHOOSE($F7,$G7,$H7,'Original FM'!N6,$I7,S62)*(1+$J7))","v":11940},{"$f":"IF(T$2,'Actual Financial Data'!O9,CHOOSE($F7,$G7,$H7,'Original FM'!O6,$I7,T62)*(1+$J7))","v":11940},{"$f":"IF(U$2,'Actual Financial Data'!P9,CHOOSE($F7,$G7,$H7,'Original FM'!P6,$I7,U62)*(1+$J7))","v":11940},{"$f":"IF(V$2,'Actual Financial Data'!Q9,CHOOSE($F7,$G7,$H7,'Original FM'!Q6,$I7,V62)*(1+$J7))","v":11940},{"$f":"IF(W$2,'Actual Financial Data'!R9,CHOOSE($F7,$G7,$H7,'Original FM'!R6,$I7,W62)*(1+$J7))","v":11940},{"$f":"IF(X$2,'Actual Financial Data'!S9,CHOOSE($F7,$G7,$H7,'Original FM'!S6,$I7,X62)*(1+$J7))","v":11940},{"$f":"IF(Y$2,'Actual Financial Data'!T9,CHOOSE($F7,$G7,$H7,'Original FM'!T6,$I7,Y62)*(1+$J7))","v":11940},{"$f":"IF(Z$2,'Actual Financial Data'!U9,CHOOSE($F7,$G7,$H7,'Original FM'!U6,$I7,Z62)*(1+$J7))","v":11940},{"$f":"IF(AA$2,'Actual Financial Data'!V9,CHOOSE($F7,$G7,$H7,'Original FM'!V6,$I7,AA62)*(1+$J7))","v":11940},{"$f":"IF(AB$2,'Actual Financial Data'!W9,CHOOSE($F7,$G7,$H7,'Original FM'!W6,$I7,AB62)*(1+$J7))","v":11940}]
[null,"Net Energy",null,"MWH",null,null,null,null,null,null,null,{"$f":"L6-L7","v":124000},128000,126000,124500,123500,127142.47535484374,125056.23822452108,123001.29465115326,120977.17523138598,118983.41760291519,117019.56633887146,115085.17284378839,113179.79525113155,111302.99832236458,109454.35334752912,107633.43804731619,105839.83647660645]
[]
[null,"Revenue and Expense"]
[null,"Price of Energy",null,"RM/MWH","Last History",{"$f":"MATCH(E11,'Graph Data from Match'!$C$113:$C$117,0)","v":2},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!13:13)","v":156.12120480000002},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!13:13)","v":162.36482400000003},null,null,null,{"$f":"IF(L$2,'Actual Financial Data'!G13,CHOOSE($F11,$G11,$H11,'Original FM'!G10,$I11,L66)*(1+$J11))","v":150},{"$f":"IF(M$2,'Actual Financial Data'!H13,CHOOSE($F11,$G11,$H11,'Original FM'!H10,$I11,M66)*(1+$J11))","v":153},{"$f":"IF(N$2,'Actual Financial Data'!I13,CHOOSE($F11,$G11,$H11,'Original FM'!I10,$I11,N66)*(1+$J11))","v":156.06},{"$f":"IF(O$2,'Actual Financial Data'!J13,CHOOSE($F11,$G11,$H11,'Original FM'!J10,$I11,O66)*(1+$J11))","v":159.18120000000002},{"$f":"IF(P$2,'Actual Financial Data'!K13,CHOOSE($F11,$G11,$H11,'Original FM'!K10,$I11,P66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(Q$2,'Actual Financial Data'!L13,CHOOSE($F11,$G11,$H11,'Original FM'!L10,$I11,Q66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(R$2,'Actual Financial Data'!M13,CHOOSE($F11,$G11,$H11,'Original FM'!M10,$I11,R66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(S$2,'Actual Financial Data'!N13,CHOOSE($F11,$G11,$H11,'Original FM'!N10,$I11,S66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(T$2,'Actual Financial Data'!O13,CHOOSE($F11,$G11,$H11,'Original FM'!O10,$I11,T66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(U$2,'Actual Financial Data'!P13,CHOOSE($F11,$G11,$H11,'Original FM'!P10,$I11,U66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(V$2,'Actual Financial Data'!Q13,CHOOSE($F11,$G11,$H11,'Original FM'!Q10,$I11,V66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(W$2,'Actual Financial Data'!R13,CHOOSE($F11,$G11,$H11,'Original FM'!R10,$I11,W66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(X$2,'Actual Financial Data'!S13,CHOOSE($F11,$G11,$H11,'Original FM'!S10,$I11,X66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(Y$2,'Actual Financial Data'!T13,CHOOSE($F11,$G11,$H11,'Original FM'!T10,$I11,Y66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(Z$2,'Actual Financial Data'!U13,CHOOSE($F11,$G11,$H11,'Original FM'!U10,$I11,Z66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(AA$2,'Actual Financial Data'!V13,CHOOSE($F11,$G11,$H11,'Original FM'!V10,$I11,AA66)*(1+$J11))","v":162.36482400000003},{"$f":"IF(AB$2,'Actual Financial Data'!W13,CHOOSE($F11,$G11,$H11,'Original FM'!W10,$I11,AB66)*(1+$J11))","v":162.36482400000003}]
[null,"Revenue",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L11*L8/1000","v":18600},19584,19663.560000000001,19818.059400000002,20052.055764000001,20643.465633913547,20304.734109426437,19971.083557806644,19642.437764461145,19318.721658015827,18999.861293167192,18685.783833791287,18376.417536306013,18071.691733283023,17771.536817305379,17475.884225067399,17184.666421712987]
[]
[null,"Royalty Expense",null,"RM 000's","Simple Input",{"$f":"MATCH(E14,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!16:16)","v":1398},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!16:16)","v":1340},1360,-8.0000000000000002E-3,null,{"$f":"IF(L$2,'Actual Financial Data'!G16,CHOOSE($F14,$G14,$H14,'Original FM'!G13,$I14,L63)*(1+$J14))","v":1500},{"$f":"IF(M$2,'Actual Financial Data'!H16,CHOOSE($F14,$G14,$H14,'Original FM'!H13,$I14,M63)*(1+$J14))","v":1400},{"$f":"IF(N$2,'Actual Financial Data'!I16,CHOOSE($F14,$G14,$H14,'Original FM'!I13,$I14,N63)*(1+$J14))","v":1350},{"$f":"IF(O$2,'Actual Financial Data'!J16,CHOOSE($F14,$G14,$H14,'Original FM'!J13,$I14,O63)*(1+$J14))","v":1400},{"$f":"IF(P$2,'Actual Financial Data'!K16,CHOOSE($F14,$G14,$H14,'Original FM'!K13,$I14,P63)*(1+$J14))","v":1340},{"$f":"IF(Q$2,'Actual Financial Data'!L16,CHOOSE($F14,$G14,$H14,'Original FM'!L13,$I14,Q63)*(1+$J14))","v":1349.12},{"$f":"IF(R$2,'Actual Financial Data'!M16,CHOOSE($F14,$G14,$H14,'Original FM'!M13,$I14,R63)*(1+$J14))","v":1349.12},{"$f":"IF(S$2,'Actual Financial Data'!N16,CHOOSE($F14,$G14,$H14,'Original FM'!N13,$I14,S63)*(1+$J14))","v":1349.12},{"$f":"IF(T$2,'Actual Financial Data'!O16,CHOOSE($F14,$G14,$H14,'Original FM'!O13,$I14,T63)*(1+$J14))","v":1349.12},{"$f":"IF(U$2,'Actual Financial Data'!P16,CHOOSE($F14,$G14,$H14,'Original FM'!P13,$I14,U63)*(1+$J14))","v":1349.12},{"$f":"IF(V$2,'Actual Financial Data'!Q16,CHOOSE($F14,$G14,$H14,'Original FM'!Q13,$I14,V63)*(1+$J14))","v":1349.12},{"$f":"IF(W$2,'Actual Financial Data'!R16,CHOOSE($F14,$G14,$H14,'Original FM'!R13,$I14,W63)*(1+$J14))","v":1349.12},{"$f":"IF(X$2,'Actual Financial Data'!S16,CHOOSE($F14,$G14,$H14,'Original FM'!S13,$I14,X63)*(1+$J14))","v":1349.12},{"$f":"IF(Y$2,'Actual Financial Data'!T16,CHOOSE($F14,$G14,$H14,'Original FM'!T13,$I14,Y63)*(1+$J14))","v":1349.12},{"$f":"IF(Z$2,'Actual Financial Data'!U16,CHOOSE($F14,$G14,$H14,'Original FM'!U13,$I14,Z63)*(1+$J14))","v":1349.12},{"$f":"IF(AA$2,'Actual Financial Data'!V16,CHOOSE($F14,$G14,$H14,'Original FM'!V13,$I14,AA63)*(1+$J14))","v":1349.12},{"$f":"IF(AB$2,'Actual Financial Data'!W16,CHOOSE($F14,$G14,$H14,'Original FM'!W13,$I14,AB63)*(1+$J14))","v":1349.12}]
[null,"Labour at Plant - Operations",null,"RM 000's","Simple Input",{"$f":"MATCH(E15,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!17:17)","v":3087},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!17:17)","v":3030},3040,1.4999999999999999E-2,null,{"$f":"IF(L$2,'Actual Financial Data'!G17,CHOOSE($F15,$G15,$H15,'Original FM'!G14,$I15,L64)*(1+$J15))","v":3100},{"$f":"IF(M$2,'Actual Financial Data'!H17,CHOOSE($F15,$G15,$H15,'Original FM'!H14,$I15,M64)*(1+$J15))","v":3500},{"$f":"IF(N$2,'Actual Financial Data'!I17,CHOOSE($F15,$G15,$H15,'Original FM'!I14,$I15,N64)*(1+$J15))","v":2800},{"$f":"IF(O$2,'Actual Financial Data'!J17,CHOOSE($F15,$G15,$H15,'Original FM'!J14,$I15,O64)*(1+$J15))","v":3005},{"$f":"IF(P$2,'Actual Financial Data'!K17,CHOOSE($F15,$G15,$H15,'Original FM'!K14,$I15,P64)*(1+$J15))","v":3030},{"$f":"IF(Q$2,'Actual Financial Data'!L17,CHOOSE($F15,$G15,$H15,'Original FM'!L14,$I15,Q64)*(1+$J15))","v":3085.6},{"$f":"IF(R$2,'Actual Financial Data'!M17,CHOOSE($F15,$G15,$H15,'Original FM'!M14,$I15,R64)*(1+$J15))","v":3085.6},{"$f":"IF(S$2,'Actual Financial Data'!N17,CHOOSE($F15,$G15,$H15,'Original FM'!N14,$I15,S64)*(1+$J15))","v":3085.6},{"$f":"IF(T$2,'Actual Financial Data'!O17,CHOOSE($F15,$G15,$H15,'Original FM'!O14,$I15,T64)*(1+$J15))","v":3085.6},{"$f":"IF(U$2,'Actual Financial Data'!P17,CHOOSE($F15,$G15,$H15,'Original FM'!P14,$I15,U64)*(1+$J15))","v":3085.6},{"$f":"IF(V$2,'Actual Financial Data'!Q17,CHOOSE($F15,$G15,$H15,'Original FM'!Q14,$I15,V64)*(1+$J15))","v":3085.6},{"$f":"IF(W$2,'Actual Financial Data'!R17,CHOOSE($F15,$G15,$H15,'Original FM'!R14,$I15,W64)*(1+$J15))","v":3085.6},{"$f":"IF(X$2,'Actual Financial Data'!S17,CHOOSE($F15,$G15,$H15,'Original FM'!S14,$I15,X64)*(1+$J15))","v":3085.6},{"$f":"IF(Y$2,'Actual Financial Data'!T17,CHOOSE($F15,$G15,$H15,'Original FM'!T14,$I15,Y64)*(1+$J15))","v":3085.6},{"$f":"IF(Z$2,'Actual Financial Data'!U17,CHOOSE($F15,$G15,$H15,'Original FM'!U14,$I15,Z64)*(1+$J15))","v":3085.6},{"$f":"IF(AA$2,'Actual Financial Data'!V17,CHOOSE($F15,$G15,$H15,'Original FM'!V14,$I15,AA64)*(1+$J15))","v":3085.6},{"$f":"IF(AB$2,'Actual Financial Data'!W17,CHOOSE($F15,$G15,$H15,'Original FM'!W14,$I15,AB64)*(1+$J15))","v":3085.6}]
[null,"Materials for Maintenance",null,"RM 000's","Simple Input",{"$f":"MATCH(E16,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!18:18)","v":621},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!18:18)","v":450},860,0,null,{"$f":"IF(L$2,'Actual Financial Data'!G18,CHOOSE($F16,$G16,$H16,'Original FM'!G15,$I16,L65)*(1+$J16))","v":905},{"$f":"IF(M$2,'Actual Financial Data'!H18,CHOOSE($F16,$G16,$H16,'Original FM'!H15,$I16,M65)*(1+$J16))","v":700},{"$f":"IF(N$2,'Actual Financial Data'!I18,CHOOSE($F16,$G16,$H16,'Original FM'!I15,$I16,N65)*(1+$J16))","v":650},{"$f":"IF(O$2,'Actual Financial Data'!J18,CHOOSE($F16,$G16,$H16,'Original FM'!J15,$I16,O65)*(1+$J16))","v":400},{"$f":"IF(P$2,'Actual Financial Data'!K18,CHOOSE($F16,$G16,$H16,'Original FM'!K15,$I16,P65)*(1+$J16))","v":450},{"$f":"IF(Q$2,'Actual Financial Data'!L18,CHOOSE($F16,$G16,$H16,'Original FM'!L15,$I16,Q65)*(1+$J16))","v":860},{"$f":"IF(R$2,'Actual Financial Data'!M18,CHOOSE($F16,$G16,$H16,'Original FM'!M15,$I16,R65)*(1+$J16))","v":860},{"$f":"IF(S$2,'Actual Financial Data'!N18,CHOOSE($F16,$G16,$H16,'Original FM'!N15,$I16,S65)*(1+$J16))","v":860},{"$f":"IF(T$2,'Actual Financial Data'!O18,CHOOSE($F16,$G16,$H16,'Original FM'!O15,$I16,T65)*(1+$J16))","v":860},{"$f":"IF(U$2,'Actual Financial Data'!P18,CHOOSE($F16,$G16,$H16,'Original FM'!P15,$I16,U65)*(1+$J16))","v":860},{"$f":"IF(V$2,'Actual Financial Data'!Q18,CHOOSE($F16,$G16,$H16,'Original FM'!Q15,$I16,V65)*(1+$J16))","v":860},{"$f":"IF(W$2,'Actual Financial Data'!R18,CHOOSE($F16,$G16,$H16,'Original FM'!R15,$I16,W65)*(1+$J16))","v":860},{"$f":"IF(X$2,'Actual Financial Data'!S18,CHOOSE($F16,$G16,$H16,'Original FM'!S15,$I16,X65)*(1+$J16))","v":860},{"$f":"IF(Y$2,'Actual Financial Data'!T18,CHOOSE($F16,$G16,$H16,'Original FM'!T15,$I16,Y65)*(1+$J16))","v":860},{"$f":"IF(Z$2,'Actual Financial Data'!U18,CHOOSE($F16,$G16,$H16,'Original FM'!U15,$I16,Z65)*(1+$J16))","v":860},{"$f":"IF(AA$2,'Actual Financial Data'!V18,CHOOSE($F16,$G16,$H16,'Original FM'!V15,$I16,AA65)*(1+$J16))","v":860},{"$f":"IF(AB$2,'Actual Financial Data'!W18,CHOOSE($F16,$G16,$H16,'Original FM'!W15,$I16,AB65)*(1+$J16))","v":860}]
[null,"Labour for Maintenance",null,"RM 000's","Simple Input",{"$f":"MATCH(E17,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!19:19)","v":2988},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!19:19)","v":3500},3440,1.2999999999999999E-2,null,{"$f":"IF(L$2,'Actual Financial Data'!G19,CHOOSE($F17,$G17,$H17,'Original FM'!G16,$I17,L66)*(1+$J17))","v":3040},{"$f":"IF(M$2,'Actual Financial Data'!H19,CHOOSE($F17,$G17,$H17,'Original FM'!H16,$I17,M66)*(1+$J17))","v":2700},{"$f":"IF(N$2,'Actual Financial Data'!I19,CHOOSE($F17,$G17,$H17,'Original FM'!I16,$I17,N66)*(1+$J17))","v":2600},{"$f":"IF(O$2,'Actual Financial Data'!J19,CHOOSE($F17,$G17,$H17,'Original FM'!J16,$I17,O66)*(1+$J17))","v":3100},{"$f":"IF(P$2,'Actual Financial Data'!K19,CHOOSE($F17,$G17,$H17,'Original FM'!K16,$I17,P66)*(1+$J17))","v":3500},{"$f":"IF(Q$2,'Actual Financial Data'!L19,CHOOSE($F17,$G17,$H17,'Original FM'!L16,$I17,Q66)*(1+$J17))","v":3484.72},{"$f":"IF(R$2,'Actual Financial Data'!M19,CHOOSE($F17,$G17,$H17,'Original FM'!M16,$I17,R66)*(1+$J17))","v":3484.72},{"$f":"IF(S$2,'Actual Financial Data'!N19,CHOOSE($F17,$G17,$H17,'Original FM'!N16,$I17,S66)*(1+$J17))","v":3484.72},{"$f":"IF(T$2,'Actual Financial Data'!O19,CHOOSE($F17,$G17,$H17,'Original FM'!O16,$I17,T66)*(1+$J17))","v":3484.72},{"$f":"IF(U$2,'Actual Financial Data'!P19,CHOOSE($F17,$G17,$H17,'Original FM'!P16,$I17,U66)*(1+$J17))","v":3484.72},{"$f":"IF(V$2,'Actual Financial Data'!Q19,CHOOSE($F17,$G17,$H17,'Original FM'!Q16,$I17,V66)*(1+$J17))","v":3484.72},{"$f":"IF(W$2,'Actual Financial Data'!R19,CHOOSE($F17,$G17,$H17,'Original FM'!R16,$I17,W66)*(1+$J17))","v":3484.72},{"$f":"IF(X$2,'Actual Financial Data'!S19,CHOOSE($F17,$G17,$H17,'Original FM'!S16,$I17,X66)*(1+$J17))","v":3484.72},{"$f":"IF(Y$2,'Actual Financial Data'!T19,CHOOSE($F17,$G17,$H17,'Original FM'!T16,$I17,Y66)*(1+$J17))","v":3484.72},{"$f":"IF(Z$2,'Actual Financial Data'!U19,CHOOSE($F17,$G17,$H17,'Original FM'!U16,$I17,Z66)*(1+$J17))","v":3484.72},{"$f":"IF(AA$2,'Actual Financial Data'!V19,CHOOSE($F17,$G17,$H17,'Original FM'!V16,$I17,AA66)*(1+$J17))","v":3484.72},{"$f":"IF(AB$2,'Actual Financial Data'!W19,CHOOSE($F17,$G17,$H17,'Original FM'!W16,$I17,AB66)*(1+$J17))","v":3484.72}]
[null,"Other Admin Expense",null,"RM 000's","Simple Input",{"$f":"MATCH(E18,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!20:20)","v":668},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!20:20)","v":620},625,5.0000000000000001E-3,null,{"$f":"IF(L$2,'Actual Financial Data'!G20,CHOOSE($F18,$G18,$H18,'Original FM'!G17,$I18,L67)*(1+$J18))","v":650},{"$f":"IF(M$2,'Actual Financial Data'!H20,CHOOSE($F18,$G18,$H18,'Original FM'!H17,$I18,M67)*(1+$J18))","v":630},{"$f":"IF(N$2,'Actual Financial Data'!I20,CHOOSE($F18,$G18,$H18,'Original FM'!I17,$I18,N67)*(1+$J18))","v":640},{"$f":"IF(O$2,'Actual Financial Data'!J20,CHOOSE($F18,$G18,$H18,'Original FM'!J17,$I18,O67)*(1+$J18))","v":800},{"$f":"IF(P$2,'Actual Financial Data'!K20,CHOOSE($F18,$G18,$H18,'Original FM'!K17,$I18,P67)*(1+$J18))","v":620},{"$f":"IF(Q$2,'Actual Financial Data'!L20,CHOOSE($F18,$G18,$H18,'Original FM'!L17,$I18,Q67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(R$2,'Actual Financial Data'!M20,CHOOSE($F18,$G18,$H18,'Original FM'!M17,$I18,R67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(S$2,'Actual Financial Data'!N20,CHOOSE($F18,$G18,$H18,'Original FM'!N17,$I18,S67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(T$2,'Actual Financial Data'!O20,CHOOSE($F18,$G18,$H18,'Original FM'!O17,$I18,T67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(U$2,'Actual Financial Data'!P20,CHOOSE($F18,$G18,$H18,'Original FM'!P17,$I18,U67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(V$2,'Actual Financial Data'!Q20,CHOOSE($F18,$G18,$H18,'Original FM'!Q17,$I18,V67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(W$2,'Actual Financial Data'!R20,CHOOSE($F18,$G18,$H18,'Original FM'!R17,$I18,W67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(X$2,'Actual Financial Data'!S20,CHOOSE($F18,$G18,$H18,'Original FM'!S17,$I18,X67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(Y$2,'Actual Financial Data'!T20,CHOOSE($F18,$G18,$H18,'Original FM'!T17,$I18,Y67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(Z$2,'Actual Financial Data'!U20,CHOOSE($F18,$G18,$H18,'Original FM'!U17,$I18,Z67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(AA$2,'Actual Financial Data'!V20,CHOOSE($F18,$G18,$H18,'Original FM'!V17,$I18,AA67)*(1+$J18))","v":628.12499999999989},{"$f":"IF(AB$2,'Actual Financial Data'!W20,CHOOSE($F18,$G18,$H18,'Original FM'!W17,$I18,AB67)*(1+$J18))","v":628.12499999999989}]
[null,"Insurance Expense",null,"RM 000's","Simple Input",{"$f":"MATCH(E19,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!21:21)","v":1371.4},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!21:21)","v":1402},1320,0,null,{"$f":"IF(L$2,'Actual Financial Data'!G21,CHOOSE($F19,$G19,$H19,'Original FM'!G18,$I19,L68)*(1+$J19))","v":1250},{"$f":"IF(M$2,'Actual Financial Data'!H21,CHOOSE($F19,$G19,$H19,'Original FM'!H18,$I19,M68)*(1+$J19))","v":1500},{"$f":"IF(N$2,'Actual Financial Data'!I21,CHOOSE($F19,$G19,$H19,'Original FM'!I18,$I19,N68)*(1+$J19))","v":1400},{"$f":"IF(O$2,'Actual Financial Data'!J21,CHOOSE($F19,$G19,$H19,'Original FM'!J18,$I19,O68)*(1+$J19))","v":1305},{"$f":"IF(P$2,'Actual Financial Data'!K21,CHOOSE($F19,$G19,$H19,'Original FM'!K18,$I19,P68)*(1+$J19))","v":1402},{"$f":"IF(Q$2,'Actual Financial Data'!L21,CHOOSE($F19,$G19,$H19,'Original FM'!L18,$I19,Q68)*(1+$J19))","v":1320},{"$f":"IF(R$2,'Actual Financial Data'!M21,CHOOSE($F19,$G19,$H19,'Original FM'!M18,$I19,R68)*(1+$J19))","v":1320},{"$f":"IF(S$2,'Actual Financial Data'!N21,CHOOSE($F19,$G19,$H19,'Original FM'!N18,$I19,S68)*(1+$J19))","v":1320},{"$f":"IF(T$2,'Actual Financial Data'!O21,CHOOSE($F19,$G19,$H19,'Original FM'!O18,$I19,T68)*(1+$J19))","v":1320},{"$f":"IF(U$2,'Actual Financial Data'!P21,CHOOSE($F19,$G19,$H19,'Original FM'!P18,$I19,U68)*(1+$J19))","v":1320},{"$f":"IF(V$2,'Actual Financial Data'!Q21,CHOOSE($F19,$G19,$H19,'Original FM'!Q18,$I19,V68)*(1+$J19))","v":1320},{"$f":"IF(W$2,'Actual Financial Data'!R21,CHOOSE($F19,$G19,$H19,'Original FM'!R18,$I19,W68)*(1+$J19))","v":1320},{"$f":"IF(X$2,'Actual Financial Data'!S21,CHOOSE($F19,$G19,$H19,'Original FM'!S18,$I19,X68)*(1+$J19))","v":1320},{"$f":"IF(Y$2,'Actual Financial Data'!T21,CHOOSE($F19,$G19,$H19,'Original FM'!T18,$I19,Y68)*(1+$J19))","v":1320},{"$f":"IF(Z$2,'Actual Financial Data'!U21,CHOOSE($F19,$G19,$H19,'Original FM'!U18,$I19,Z68)*(1+$J19))","v":1320},{"$f":"IF(AA$2,'Actual Financial Data'!V21,CHOOSE($F19,$G19,$H19,'Original FM'!V18,$I19,AA68)*(1+$J19))","v":1320},{"$f":"IF(AB$2,'Actual Financial Data'!W21,CHOOSE($F19,$G19,$H19,'Original FM'!W18,$I19,AB68)*(1+$J19))","v":1320}]
[null,"Total Expense",null,"RM 000's",null,null,{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!22:22)","v":10133.4},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!22:22)","v":10342},null,null,null,{"$f":"SUM(L14:L19)","v":10445},10430,9440,10010,10342,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999,10727.564999999999]
[]
[null,"EBITDA",null,null,null,null,null,null,null,null,null,{"$f":"L12-L20","v":8155},9154,10223.560000000001,9808.0594000000019,9710.0557640000006,9915.9006339135485,9577.1691094264388,9243.5185578066448,8914.8727644611463,8591.1566580158287,8272.2962931671937,7958.2188337912885,7648.8525363060144,7344.1267332830248,7043.9718173053807,6748.3192250674001,6457.1014217129887]
[]
[null,"On-Going Capital Expenditure",null,"RM 000's","Simple Input",{"$f":"MATCH(E24,'Graph Data from Match'!$C$113:$C$117,0)","v":4},{"$f":"AVERAGEIF('Actual Financial Data'!$6:$6,TRUE,'Actual Financial Data'!26:26)","v":330},{"$f":"SUMIF('Actual Financial Data'!$5:$5,'Actual Financial Data'!$E$3,'Actual Financial Data'!26:26)","v":700},1200,0,null,{"$f":"IF(L$2,'Actual Financial Data'!G26,CHOOSE($F24,$G24,$H24,'Original FM'!G23,$I24,#REF!)*(1+$J24))","v":30},{"$f":"IF(M$2,'Actual Financial Data'!H26,CHOOSE($F24,$G24,$H24,'Original FM'!H23,$I24,#REF!)*(1+$J24))","v":0},{"$f":"IF(N$2,'Actual Financial Data'!I26,CHOOSE($F24,$G24,$H24,'Original FM'!I23,$I24,#REF!)*(1+$J24))","v":450},{"$f":"IF(O$2,'Actual Financial Data'!J26,CHOOSE($F24,$G24,$H24,'Original FM'!J23,$I24,#REF!)*(1+$J24))","v":470},{"$f":"IF(P$2,'Actual Financial Data'!K26,CHOOSE($F24,$G24,$H24,'Original FM'!K23,$I24,#REF!)*(1+$J24))","v":700},{"$f":"IF(Q$2,'Actual Financial Data'!L26,CHOOSE($F24,$G24,$H24,'Original FM'!L23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(R$2,'Actual Financial Data'!M26,CHOOSE($F24,$G24,$H24,'Original FM'!M23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(S$2,'Actual Financial Data'!N26,CHOOSE($F24,$G24,$H24,'Original FM'!N23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(T$2,'Actual Financial Data'!O26,CHOOSE($F24,$G24,$H24,'Original FM'!O23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(U$2,'Actual Financial Data'!P26,CHOOSE($F24,$G24,$H24,'Original FM'!P23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(V$2,'Actual Financial Data'!Q26,CHOOSE($F24,$G24,$H24,'Original FM'!Q23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(W$2,'Actual Financial Data'!R26,CHOOSE($F24,$G24,$H24,'Original FM'!R23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(X$2,'Actual Financial Data'!S26,CHOOSE($F24,$G24,$H24,'Original FM'!S23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(Y$2,'Actual Financial Data'!T26,CHOOSE($F24,$G24,$H24,'Original FM'!T23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(Z$2,'Actual Financial Data'!U26,CHOOSE($F24,$G24,$H24,'Original FM'!U23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(AA$2,'Actual Financial Data'!V26,CHOOSE($F24,$G24,$H24,'Original FM'!V23,$I24,#REF!)*(1+$J24))","v":1200},{"$f":"IF(AB$2,'Actual Financial Data'!W26,CHOOSE($F24,$G24,$H24,'Original FM'!W23,$I24,#REF!)*(1+$J24))","v":1200}]
[null,"Remaining Life",null,null,null,null,null,null,null,null,null,17,{"$f":"L25-1","v":16},15,14,13,12,11,10,9,8,7,6,5,4,3,2,1]
[null,"Depreciation Rate",null,null,null,null,null,null,null,null,null,{"$f":"1/L25","v":5.8823529411764705E-2},6.25E-2,6.6666666666666666E-2,7.1428571428571425E-2,7.6923076923076927E-2,8.3333333333333329E-2,9.0909090909090912E-2,0.1,0.1111111111111111,0.125,0.14285714285714285,0.16666666666666666,0.2,0.25,0.33333333333333331,0.5,1]
[null,"Depreciaiton Expense",null,null,"Last History",{"$f":"MATCH(E27,'Graph Data from Match'!$C$113:$C$117,0)","v":2},null,null,null,null,null,{"$f":"IF(L2,'Actual Financial Data'!G29,L26*K46)","v":6764.7058823529414},{"$f":"IF(M2,'Actual Financial Data'!H29,M26*L46)","v":6764.7058823529414},{"$f":"IF(N2,'Actual Financial Data'!I29,N26*M46)","v":6764.7058823529414},{"$f":"IF(O2,'Actual Financial Data'!J29,O26*N46)","v":6764.7058823529414},{"$f":"IF(P2,'Actual Financial Data'!K29,P26*O46)","v":6764.7058823529433},{"$f":"IF(Q2,'Actual Financial Data'!L29,Q26*P46)","v":6764.7058823529424},{"$f":"IF(R2,'Actual Financial Data'!M29,R26*Q46)","v":6873.7967914438532},{"$f":"IF(S2,'Actual Financial Data'!N29,S26*R46)","v":6993.7967914438532},{"$f":"IF(T2,'Actual Financial Data'!O29,T26*S46)","v":7127.1301247771853},{"$f":"IF(U2,'Actual Financial Data'!P29,U26*T46)","v":7277.1301247771862},{"$f":"IF(V2,'Actual Financial Data'!Q29,V26*U46)","v":7448.5586962057578},{"$f":"IF(W2,'Actual Financial Data'!R29,W26*V46)","v":7648.5586962057578},{"$f":"IF(X2,'Actual Financial Data'!S29,X26*W46)","v":7888.5586962057587},{"$f":"IF(Y2,'Actual Financial Data'!T29,Y26*X46)","v":8188.5586962057587},{"$f":"IF(Z2,'Actual Financial Data'!U29,Z26*Y46)","v":8588.5586962057587},{"$f":"IF(AA2,'Actual Financial Data'!V29,AA26*Z46)","v":9188.5586962057605},{"$f":"IF(AB2,'Actual Financial Data'!W29,AB26*AA46)","v":10388.55869620576}]
[]
["Profit and Loss"]
[null,"EBITDA",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L22","v":8155},9154,10223.560000000001,9808.0594000000019,9710.0557640000006,9915.9006339135485,9577.1691094264388,9243.5185578066448,8914.8727644611463,8591.1566580158287,8272.2962931671937,7958.2188337912885,7648.8525363060144,7344.1267332830248,7043.9718173053807,6748.3192250674001,6457.1014217129887]
[null,"Depreciation",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L27","v":6764.7058823529414},6764.7058823529414,6764.7058823529414,6764.7058823529414,6764.7058823529433,6764.7058823529424,6873.7967914438532,6993.7967914438532,7127.1301247771853,7277.1301247771862,7448.5586962057578,7648.5586962057578,7888.5586962057587,8188.5586962057587,8588.5586962057587,9188.5586962057605,10388.55869620576]
[null,"EBIT ",null,null,null,null,null,null,null,null,null,{"$f":"L30-L31","v":1390.2941176470586},2389.2941176470586,3458.8541176470599,3043.3535176470605,2945.3498816470574,3151.1947515606062,2703.3723179825856,2249.7217663627916,1787.742639683961,1314.0265332386425,823.73759696143588,309.66013758553072,-239.70615989974431,-844.43196292273387,-1544.586878900378,-2440.2394711383604,-3931.4572744927718]
[null,"Interest",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"'Original FM'!G45","v":2880},{"$f":"'Original FM'!H45","v":2688},{"$f":"'Original FM'!I45","v":2496},{"$f":"'Original FM'!J45","v":2304},{"$f":"'Original FM'!K45","v":2112},{"$f":"'Original FM'!L45","v":1920},{"$f":"'Original FM'!M45","v":1727.9999999999998},{"$f":"'Original FM'!N45","v":1535.9999999999998},{"$f":"'Original FM'!O45","v":1343.9999999999998},{"$f":"'Original FM'!P45","v":1151.9999999999998},{"$f":"'Original FM'!Q45","v":959.99999999999989},{"$f":"'Original FM'!R45","v":767.99999999999989},{"$f":"'Original FM'!S45","v":576},{"$f":"'Original FM'!T45","v":384},{"$f":"'Original FM'!U45","v":192.00000000000003},{"$f":"'Original FM'!V45","v":0},{"$f":"'Original FM'!W45","v":0}]
[null,"EBT=PAT",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L32-L33","v":-1489.7058823529414},-298.70588235294144,962.85411764705987,739.35351764706047,833.34988164705737,1231.1947515606062,975.37231798258586,713.72176636279187,443.74263968396122,162.02653323864274,-136.262403038564,-458.33986241446917,-815.70615989974431,-1228.4319629227339,-1736.586878900378,-2440.2394711383604,-3931.4572744927718]
[]
["Cashflow Statement"]
[null,"EBITDA",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L30","v":8155},9154,10223.560000000001,9808.0594000000019,9710.0557640000006,9915.9006339135485,9577.1691094264388,9243.5185578066448,8914.8727644611463,8591.1566580158287,8272.2962931671937,7958.2188337912885,7648.8525363060144,7344.1267332830248,7043.9718173053807,6748.3192250674001,6457.1014217129887]
[null,"Less: On-Going Cap Exp",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L24","v":30},0,450,470,700,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
[null,"Debt Service",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"'Original FM'!G50","v":8213.3333333333321},{"$f":"'Original FM'!H50","v":8021.333333333333},{"$f":"'Original FM'!I50","v":7829.333333333333},{"$f":"'Original FM'!J50","v":7637.333333333333},{"$f":"'Original FM'!K50","v":7445.333333333333},{"$f":"'Original FM'!L50","v":7253.333333333333},{"$f":"'Original FM'!M50","v":7061.333333333333},{"$f":"'Original FM'!N50","v":6869.333333333333},{"$f":"'Original FM'!O50","v":6677.333333333333},{"$f":"'Original FM'!P50","v":6485.333333333333},{"$f":"'Original FM'!Q50","v":6293.333333333333},{"$f":"'Original FM'!R50","v":6101.333333333333},{"$f":"'Original FM'!S50","v":5909.333333333333},{"$f":"'Original FM'!T50","v":5717.333333333333},{"$f":"'Original FM'!U50","v":5525.333333333333},{"$f":"'Original FM'!V50","v":0},{"$f":"'Original FM'!W50","v":0}]
[null,"Dividend",null,null,null,null,null,null,null,null,null,{"$f":"L37-L38-L39","v":-88.333333333332121},1132.666666666667,1944.2266666666683,1700.7260666666689,1564.7224306666676,1462.5673005802155,1315.8357760931058,1174.1852244733118,1037.5394311278133,905.8233246824957,778.96295983386062,656.88550045795546,539.51920297268134,426.79339994969177,318.63848397204765,5548.3192250674001,5257.1014217129887]
[null,"Equity Cashflow",null,"RM 000's",null,null,null,null,null,null,null,{"$f":"L40","v":-88.333333333332121},1132.666666666667,1944.2266666666683,1700.7260666666689,1564.7224306666676,1462.5673005802155,1315.8357760931058,1174.1852244733118,1037.5394311278133,905.8233246824957,778.96295983386062,656.88550045795546,539.51920297268134,426.79339994969177,318.63848397204765,5548.3192250674001,5257.1014217129887]
[]
[]
["Balance Sheet"]
[null,"Assets"]
[null,null,"Net Plant Balance",null,null,null,null,null,null,null,{"$f":"'Actual Financial Data'!F32","v":115000},{"$f":"IF(L2,'Actual Financial Data'!G32,'Revised Forecast'!K46+'Revised Forecast'!L24-'Revised Forecast'!L27)","v":108235.29411764706},{"$f":"IF(M2,'Actual Financial Data'!H32,'Revised Forecast'!L46+'Revised Forecast'!M24-'Revised Forecast'!M27)","v":101470.58823529413},{"$f":"IF(N2,'Actual Financial Data'!I32,'Revised Forecast'!M46+'Revised Forecast'!N24-'Revised Forecast'!N27)","v":94705.882352941189},{"$f":"IF(O2,'Actual Financial Data'!J32,'Revised Forecast'!N46+'Revised Forecast'!O24-'Revised Forecast'!O27)","v":87941.176470588252},{"$f":"IF(P2,'Actual Financial Data'!K32,'Revised Forecast'!O46+'Revised Forecast'!P24-'Revised Forecast'!P27)","v":81176.470588235316},{"$f":"IF(Q2,'Actual Financial Data'!L32,'Revised Forecast'!P46+'Revised Forecast'!Q24-'Revised Forecast'!Q27)","v":75611.764705882379},{"$f":"IF(R2,'Actual Financial Data'!M32,'Revised Forecast'!Q46+'Revised Forecast'!R24-'Revised Forecast'!R27)","v":69937.96791443853},{"$f":"IF(S2,'Actual Financial Data'!N32,'Revised Forecast'!R46+'Revised Forecast'!S24-'Revised Forecast'!S27)","v":64144.171122994674},{"$f":"IF(T2,'Actual Financial Data'!O32,'Revised Forecast'!S46+'Revised Forecast'!T24-'Revised Forecast'!T27)","v":58217.04099821749},{"$f":"IF(U2,'Actual Financial Data'!P32,'Revised Forecast'!T46+'Revised Forecast'!U24-'Revised Forecast'!U27)","v":52139.910873440305},{"$f":"IF(V2,'Actual Financial Data'!Q32,'Revised Forecast'!U46+'Revised Forecast'!V24-'Revised Forecast'!V27)","v":45891.352177234548},{"$f":"IF(W2,'Actual Financial Data'!R32,'Revised Forecast'!V46+'Revised Forecast'!W24-'Revised Forecast'!W27)","v":39442.793481028792},{"$f":"IF(X2,'Actual Financial Data'!S32,'Revised Forecast'!W46+'Revised Forecast'!X24-'Revised Forecast'!X27)","v":32754.234784823035},{"$f":"IF(Y2,'Actual Financial Data'!T32,'Revised Forecast'!X46+'Revised Forecast'!Y24-'Revised Forecast'!Y27)","v":25765.676088617278},{"$f":"IF(Z2,'Actual Financial Data'!U32,'Revised Forecast'!Y46+'Revised Forecast'!Z24-'Revised Forecast'!Z27)","v":18377.117392411521},{"$f":"IF(AA2,'Actual Financial Data'!V32,'Revised Forecast'!Z46+'Revised Forecast'!AA24-'Revised Forecast'!AA27)","v":10388.55869620576},{"$f":"IF(AB2,'Actual Financial Data'!W32,'Revised Forecast'!AA46+'Revised Forecast'!AB24-'Revised Forecast'!AB27)","v":1200}]
[]
[null,"Liabilities and Capital",null,null,null,null,null,null,null,null,{"$f":"'Original FM'!F60","v":80000},{"$f":"'Original FM'!G60","v":74666.666666666672},{"$f":"'Original FM'!H60","v":69333.333333333343},{"$f":"'Original FM'!I60","v":64000.000000000007},{"$f":"'Original FM'!J60","v":58666.666666666672},{"$f":"'Original FM'!K60","v":53333.333333333336},{"$f":"'Original FM'!L60","v":48000},{"$f":"'Original FM'!M60","v":42666.666666666664},{"$f":"'Original FM'!N60","v":37333.333333333328},{"$f":"'Original FM'!O60","v":31999.999999999996},{"$f":"'Original FM'!P60","v":26666.666666666664},{"$f":"'Original FM'!Q60","v":21333.333333333332},{"$f":"'Original FM'!R60","v":16000},{"$f":"'Original FM'!S60","v":10666.666666666668},{"$f":"'Original FM'!T60","v":5333.3333333333348},{"$f":"'Original FM'!U60","v":0},{"$f":"'Original FM'!V60","v":0},{"$f":"'Original FM'!W60","v":0}]
[null,null,"Debt",null,null,null,null,null,null,null,{"$f":"K46-K48","v":35000},33568.627450980392,32137.254901960783,30705.882352941182,29274.509803921581,27843.13725490198,27611.764705882379,27271.301247771866,26810.837789661346,26217.040998217493,25473.244206773641,24558.018843901216,23442.793481028792,22087.568118156367,20432.342755283942,18377.117392411521,10388.55869620576,1200]
[null,null,"Equity",null,null,null,null,null,null,null,{"$f":"SUM(K48:K49)","v":115000},108235.29411764706,101470.58823529413,94705.882352941189,87941.176470588252,81176.470588235316,75611.764705882379,69937.96791443853,64144.171122994674,58217.04099821749,52139.910873440305,45891.352177234548,39442.793481028792,32754.234784823035,25765.676088617278,18377.117392411521,10388.55869620576,1200]
[]
[]
["Ratios"]
[null,"Return on Assets (ROA)",null,null,null,null,null,null,null,null,null,{"$f":"L32/K46","v":1.2089514066496162E-2},2.2074999999999997E-2,3.4087257971014501E-2,3.2134788695652186E-2,3.349227290167222E-2,3.8819065780094412E-2,3.5753329240472961E-2,3.2167388236316513E-2,2.7870695160375741E-2,2.2571166632788429E-2,1.5798600019875406E-2,6.7476795277160015E-3,-6.0773119433094481E-3,-2.5780848445099654E-2,-5.994746163803337E-2,-0.13278684676335639,-0.37844107055280612]
[null,"Return on Equity (ROE)",null,null,null,null,null,null,null,null,null,{"$f":"L34/K49","v":-4.2563025210084038E-2},-8.8983644859813166E-3,2.996068334350217E-2,2.407856283524909E-2,2.8466740766242404E-2,4.4218966429289346E-2,3.5324519398602351E-2,2.6171166526976954E-2,1.655086809167429E-2,6.1801991021663725E-3,-5.3492363176234218E-3,-1.866355202868061E-2,-3.4795604054604627E-2,-5.5616442532346572E-2,-8.4992058898937808E-2,-0.13278684676335639,-0.37844107055280612]
[null,"DSCR"]
[]
[]
["Detailed Forecast/Graph List"]
[]
[null,"Gross Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,136000,{"$f":"Q61*1.01","v":137360},{"$f":"R61*0.98","v":134612.79999999999},{"$f":"S61*0.98","v":131920.54399999999},{"$f":"T61*0.98","v":129282.13312},{"$f":"U61*0.99","v":127989.3117888},126709.418670912,125442.32448420288,124187.90123936084,122946.02222696724,121716.56200469757,120499.39638465059]
[null,"Energy for Outage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q61*0.085","v":11560},11675.6,11442.088,11213.24624,10988.981315200001,10879.091502048001,10770.300587027521,10662.597581157246,10555.971605345672,10450.411889292216,10345.907770399293,10242.448692695301]
[null,"Royalty Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1349.12,{"$f":"Q63","v":1349.12},1349.12,1349.12,1349.12,1349.12,1349.12,1349.12,1349.12,1349.12,1349.12,1349.12]
[null,"Labour at Plant - Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3085.6,{"$f":"Q64","v":3085.6},3085.6,3085.6,3085.6,3085.6,3085.6,3085.6,3085.6,3085.6,3085.6,3085.6]
[null,"Materials for Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,860,{"$f":"Q65","v":860},860,860,860,860,860,860,860,860,860,860]
[null,"Labour for Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3484.72,{"$f":"Q66","v":3484.72},3484.72,3484.72,3484.72,3484.72,3484.72,3484.72,3484.72,3484.72,3484.72,3484.72]
[null,"Other Admin Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,628.12499999999989,{"$f":"Q67","v":628.12499999999989},628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989,628.12499999999989]
[null,"Insurance Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1320,{"$f":"Q68","v":1320},1320,1320,1320,1320,1320,1320,1320,1320,1320,1320]
[null,"On-Going Capital Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,0,1200,3000,0,20,6000,0,{"$f":"X69","v":0},{"$f":"Y69","v":0},{"$f":"Z69","v":0},{"$f":"AA69","v":0}]

{"sheet":"Graph Data from Match","index":6,"n_rows":123,"n_cols":32,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["Detailed Forecast/Graph List",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw Data"]
[null,null,null,"FM Row",null,"Actual Col B","Actual Col C","Final Match Actual",null,null,null,null,null,null,null,"Pct of Energy"]
[null,"Gross Energy",null,{"$f":"MATCH(B3,'Original FM'!C:C,0)","v":5},null,{"$f":"MATCH(B3,'Actual Financial Data'!B:B,0)","v":8},{"$f":"MATCH(B3,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},{"$f":"na_sum(F3:G3)","v":8},null,null,null,null,null,null,null,"Pct of Revenue"]
[null,"Energy for Outage",null,{"$f":"MATCH(B4,'Original FM'!C:C,0)","v":6},null,{"$f":"MATCH(B4,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B4,'Actual Financial Data'!C:C,0)","v":9},{"$f":"na_sum(F4:G4)","v":9},null,null,null,null,null,null,null,"Pct of Expense",null,1]
[null,"Royalty Expense",null,{"$f":"MATCH(B5,'Original FM'!C:C,0)","v":13},null,{"$f":"MATCH(B5,'Actual Financial Data'!B:B,0)","v":16},{"$f":"MATCH(B5,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},16]
[null,"Labour at Plant - Operations",null,{"$f":"MATCH(B6,'Original FM'!C:C,0)","v":14},null,{"$f":"MATCH(B6,'Actual Financial Data'!B:B,0)","v":17},{"$f":"MATCH(B6,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},17,null,null,"Code Number",null,3]
[null,"Materials for Maintenance",null,{"$f":"MATCH(B7,'Original FM'!C:C,0)","v":15},null,{"$f":"MATCH(B7,'Actual Financial Data'!B:B,0)","v":18},{"$f":"MATCH(B7,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},18,null,null,null,null,null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,"Labour for Maintenance",null,{"$f":"MATCH(B8,'Original FM'!C:C,0)","v":16},null,{"$f":"MATCH(B8,'Actual Financial Data'!B:B,0)","v":19},{"$f":"MATCH(B8,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},19]
[null,"Other Admin Expense",null,{"$f":"MATCH(B9,'Original FM'!C:C,0)","v":17},null,{"$f":"MATCH(B9,'Actual Financial Data'!B:B,0)","v":20},{"$f":"MATCH(B9,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},20,null,null,"FM Row/Col",null,{"$f":"INDEX($D$3:$D$22,M6)","v":13},null,{"$f":"MATCH(O7,'Original FM'!3:3,0)","v":7},{"$f":"MATCH(P7,'Original FM'!3:3,0)","v":8},{"$f":"MATCH(Q7,'Original FM'!3:3,0)","v":9},{"$f":"MATCH(R7,'Original FM'!3:3,0)","v":10},{"$f":"MATCH(S7,'Original FM'!3:3,0)","v":11},{"$f":"MATCH(T7,'Original FM'!3:3,0)","v":12},{"$f":"MATCH(U7,'Original FM'!3:3,0)","v":13},{"$f":"MATCH(V7,'Original FM'!3:3,0)","v":14},{"$f":"MATCH(W7,'Original FM'!3:3,0)","v":15},{"$f":"MATCH(X7,'Original FM'!3:3,0)","v":16},{"$f":"MATCH(Y7,'Original FM'!3:3,0)","v":17},{"$f":"MATCH(Z7,'Original FM'!3:3,0)","v":18}]
[null,"Insurance Expense",null,{"$f":"MATCH(B10,'Original FM'!C:C,0)","v":18},null,{"$f":"MATCH(B10,'Actual Financial Data'!B:B,0)","v":21},{"$f":"MATCH(B10,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},21,null,null,"Acutal/Col",null,{"$f":"INDEX($H$3:$H$22,M6)","v":16},null,{"$f":"MATCH(O7,'Actual Financial Data'!5:5,0)","v":7},{"$f":"MATCH(P7,'Actual Financial Data'!5:5,0)","v":8},{"$f":"MATCH(Q7,'Actual Financial Data'!5:5,0)","v":9},{"$f":"MATCH(R7,'Actual Financial Data'!5:5,0)","v":10},{"$f":"MATCH(S7,'Actual Financial Data'!5:5,0)","v":11},{"$f":"MATCH(T7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(U7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(V7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(W7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(X7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(Y7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(Z7,'Actual Financial Data'!5:5,0)","v":{"$error":"#N/A"}}]
[null,"On-Going Capital Expenditure",null,{"$f":"MATCH(B11,'Original FM'!C:C,0)","v":23},null,{"$f":"MATCH(B11,'Actual Financial Data'!B:B,0)","v":26},{"$f":"MATCH(B11,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},26]
[null,"Revenue",null,{"$f":"MATCH(B12,'Original FM'!C:C,0)","v":11},null,{"$f":"MATCH(B12,'Actual Financial Data'!B:B,0)","v":14},{"$f":"MATCH(B12,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},14,null,null,{"$f":"INDEX(B3:B22,$M$6)","v":"Royalty Expense"}]
[null,{"$f":"'Original FM'!C19","v":"Total Expense"},null,{"$f":"MATCH(B13,'Original FM'!C:C,0)","v":19},null,{"$f":"MATCH(B13,'Actual Financial Data'!B:B,0)","v":22},{"$f":"MATCH(B13,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},{"$f":"na_sum(F13:G13)","v":22},null,null,null,null,null,null,{"$f":"O7","v":2009},{"$f":"P7","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,"EBITDA",null,{"$f":"MATCH(B14,'Original FM'!C:C,0)","v":21},null,{"$f":"MATCH(B14,'Actual Financial Data'!B:B,0)","v":24},{"$f":"MATCH(B14,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},{"$f":"na_sum(F14:G14)","v":24},null,null,"Financial Model",null,null,null,{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!O9)","v":1863},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!P9)","v":1871.7561000000001},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!Q9)","v":1880.5533536700002},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!R9)","v":1889.3919544322489},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!S9)","v":1898.2720966180807},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!T9)","v":1907.1939754721859},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!U9)","v":1916.157787156905},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!V9)","v":1925.1637287565427},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!W9)","v":1934.2119982816987},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!X9)","v":1943.3027946736227},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!Y9)","v":1952.4363178085887},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$9,'Graph Data from Match'!Z9)","v":1961.6127685022889}]
[null,"Return on Assets (ROA)",null,{"$f":"MATCH(B15,'Original FM'!C:C,0)","v":68},null,{"$f":"MATCH(B15,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B15,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0,null,null,"Actual",null,null,null,{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!O10)","v":1500},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!P10)","v":1400},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!Q10)","v":1350},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!R10)","v":1400},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!S10)","v":1340},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!T10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!U10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!V10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!W10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!X10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!Y10)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$10,'Graph Data from Match'!Z10)","v":{"$error":"#N/A"}}]
[null,"Return on Equity (ROE)",null,{"$f":"MATCH(B16,'Original FM'!C:C,0)","v":69},null,{"$f":"MATCH(B16,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B16,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0]
[null,"Depreciation",null,{"$f":"MATCH(B17,'Original FM'!C:C,0)","v":43},null,{"$f":"MATCH(B17,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B17,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0,null,null,{"$f":"B3","v":"Gross Energy"},null,{"$f":"MATCH(K17,B3:B22,0)","v":1}]
[null,"EBIT ",null,{"$f":"MATCH(B18,'Original FM'!C:C,0)","v":44},null,{"$f":"MATCH(B18,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B18,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0]
[null,"Interest",null,{"$f":"MATCH(B19,'Original FM'!C:C,0)","v":45},null,{"$f":"MATCH(B19,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B19,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0,null,null,{"$f":"\"FM Row/Col - \"&$K$17","v":"FM Row/Col - Gross Energy"},null,{"$f":"MATCH(K17,'Original FM'!C:C,0)","v":5},null,{"$f":"O9","v":7},{"$f":"P9","v":8},9,10,11,12,13,14,15,16,17,18]
[null,"EBT=PAT",null,{"$f":"MATCH(B20,'Original FM'!C:C,0)","v":46},null,{"$f":"MATCH(B20,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B20,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0,null,null,{"$f":"\"Actual \"&$K$17","v":"Actual Gross Energy"},null,{"$f":"MATCH(K17,'Actual Financial Data'!B:B)","v":8},null,{"$f":"O10","v":7},{"$f":"P10","v":8},9,10,11,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Dividend",null,{"$f":"MATCH(B21,'Original FM'!C:C,0)","v":51},null,{"$f":"MATCH(B21,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B21,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0]
[null,"DSCR",null,{"$f":"MATCH(B22,'Original FM'!C:C,0)","v":70},null,{"$f":"MATCH(B22,'Actual Financial Data'!B:B,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(B22,'Actual Financial Data'!C:C,0)","v":{"$error":"#N/A"}},0,null,null,"Financial Model",null,null,null,{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!O19)","v":150000},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!P19)","v":147750},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!Q19)","v":145533.75},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!R19)","v":143350.74374999999},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!S19)","v":141200.48259375},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!T19)","v":139082.47535484374},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!U19)","v":136996.23822452108},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!V19)","v":134941.29465115326},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!W19)","v":132917.17523138598},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!X19)","v":130923.41760291519},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!Y19)","v":128959.56633887146},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$19,'Graph Data from Match'!Z19)","v":127025.17284378839}]
[null,null,null,null,null,null,null,null,null,null,"Actual",null,null,null,{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!O20)","v":135000},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!P20)","v":140000},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!Q20)","v":138000},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!R20)","v":136000},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!S20)","v":135500},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!T20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!U20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!V20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!W20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!X20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!Y20)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$20,'Graph Data from Match'!Z20)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,"Pct of Gross Energy"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K22","v":"Financial Model"},null,null,null,{"$f":"O14/O22","v":1.242E-2},{"$f":"P14/P22","v":1.26684E-2},1.2921768000000002E-2,1.318020336E-2,1.3443807427200001E-2,1.3712683575744003E-2,1.3986937247258883E-2,1.4266675992204061E-2,1.4552009512048145E-2,1.4843049702289108E-2,1.5139910696334889E-2,1.5442708910261586E-2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K23","v":"Actual"},null,null,null,{"$f":"O15/O23","v":1.1111111111111112E-2},{"$f":"P15/P23","v":0.01},9.7826086956521747E-3,1.0294117647058823E-2,9.8892988929889306E-3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B12","v":"Revenue"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"FM Row/Col - \"&$K$29","v":"FM Row/Col - Revenue"},null,{"$f":"MATCH(K29,'Original FM'!C:C,0)","v":11},null,{"$f":"O19","v":7},{"$f":"P19","v":8},9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Actual \"&$K$29","v":"Actual Revenue"},null,{"$f":"MATCH(K29,'Actual Financial Data'!B:B,0)","v":14},null,{"$f":"O20","v":7},{"$f":"P20","v":8},9,10,11,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K26","v":"Financial Model"},null,null,null,{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!O31)","v":20700},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!P31)","v":20797.29},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!Q31)","v":20895.037263000002},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!R31)","v":20993.2439381361},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!S31)","v":21091.912184645342},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!T31)","v":21191.044171913178},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!U31)","v":21290.642079521167},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!V31)","v":21390.708097294919},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!W31)","v":21491.244425352208},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!X31)","v":21592.253274151364},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!Y31)","v":21693.736864539875},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$31,'Graph Data from Match'!Z31)","v":21795.69742780321}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K27","v":"Actual"},null,null,null,{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!O32)","v":18600},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!P32)","v":19584},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!Q32)","v":19663.560000000001},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!R32)","v":19818.059400000002},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!S32)","v":20052.055764000001},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!T32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!U32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!V32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!W32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!X32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!Y32)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$32,'Graph Data from Match'!Z32)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,"Pct of Revenue",null,null,null,{"$f":"O14/O33","v":0.09},0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09]
[null,null,null,null,null,null,null,null,null,null,"Financial Model",null,null,null,{"$f":"O15/O34","v":8.0645161290322578E-2},7.1486928104575159E-2,6.8654912945570384E-2,7.0642638198975219E-2,6.6826065904212098E-2,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,"Actual"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":"Total Expense"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"FM Row/Col - \"&$K$40","v":"FM Row/Col - Total Expense"},null,{"$f":"MATCH(K40,'Original FM'!C:C,0)","v":19},null,{"$f":"O31","v":7},{"$f":"P31","v":8},9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Actual \"&$K$40","v":"Actual Total Expense"},null,{"$f":"MATCH(K40,'Actual Financial Data'!B:B,0)","v":22},null,{"$f":"O32","v":7},{"$f":"P32","v":8},9,10,11,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K33","v":"Financial Model"},null,null,null,{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!O41)","v":10413},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!P41)","v":10482.506099999999},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!Q41)","v":10553.362103669999},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!R41)","v":10625.575198182249},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!S41)","v":10699.152887086828},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!T41)","v":10774.102990438278},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!U41)","v":10850.433645012377},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!V41)","v":10928.153304612688},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!W41)","v":11007.270740466385},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!X41)","v":11087.795041708998},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!Y41)","v":11169.735615957707},{"$f":"INDEX('Original FM'!$1:$1048576,'Graph Data from Match'!$M$41,'Graph Data from Match'!Z41)","v":11253.102189972848}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K34","v":"Actual"},null,null,null,{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!O42)","v":10445},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!P42)","v":10430},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!Q42)","v":9440},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!R42)","v":10010},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!S42)","v":10342},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!T42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!U42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!V42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!W42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!X42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!Y42)","v":{"$error":"#N/A"}},{"$f":"INDEX('Actual Financial Data'!$1:$1048576,'Graph Data from Match'!$M$42,'Graph Data from Match'!Z42)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,"Pct of Expense"]
[null,null,null,null,null,null,null,null,null,null,"Financial Model",null,null,null,{"$f":"O14/O44","v":0.17891097666378566},{"$f":"P14/P44","v":0.17855998194935468},0.17819471512457871,0.1778154988499327,0.17742265361112561,0.17701649753717488,0.1765973462302777,0.17616551260714344,0.17572130675144498,0.17526503577704075,0.17479700370161219,0.17431751133035983]
[null,null,null,null,null,null,null,null,null,null,"Actual",null,null,null,{"$f":"O15/O45","v":0.14360938247965535},{"$f":"P15/P45","v":0.13422818791946309},0.14300847457627119,0.13986013986013987,0.12956874879133629,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Final Graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O13","v":2009},{"$f":"P13","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,null,null,null,null,null,null,null,null,null,"Financial Model",null,null,null,{"$f":"CHOOSE($R$4,O14,O26,O36,O48)","v":1863},{"$f":"CHOOSE($R$4,P14,P26,P36,P48)","v":1871.7561000000001},1880.5533536700002,1889.3919544322489,1898.2720966180807,1907.1939754721859,1916.157787156905,1925.1637287565427,1934.2119982816987,1943.3027946736227,1952.4363178085887,1961.6127685022889]
[null,null,null,null,null,null,null,null,null,null,"Actual",null,null,null,{"$f":"CHOOSE($R$4,O15,O27,O37,O49)","v":1500},1400,1350,1400,1340,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Chart Title",null,null,{"$f":"K12","v":"Royalty Expense"},null,{"$f":"INDEX(P1:P4,R4)","v":"Raw Data"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Switch for Min/Max",false,"reset"]
[null,null,null,null,null,null,null,null,null,null,"Scale Type Close",true,"scale type",null,null,null,{"$f":"IF(scale_type,1,0)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,"Min with NA",{"$f":"adj_min(O54:Z55)","v":1340}]
[null,null,null,null,null,null,null,null,null,null,"Max with NA",{"$f":"adj_max(O54:Z55)","v":1961.6127685022889}]
[]
[null,null,null,null,null,null,null,null,null,null,"Round Factor",{"$f":"SUMPRODUCT(LEN(ROUND(L62,0)))","v":4}]
[null,null,null,null,null,null,null,null,null,null,"Round Factor Logs",{"$f":"LOG(L62)/LOG(10)","v":3.1271047983648077},{"$f":"_xlfn.FORMULATEXT(L66)","v":"=LOG(L62)/LOG(10)"}]
[null,null,null,null,null,null,null,null,null,null,"Adjusted Round Factor",{"$f":"-ROUNDUP(L66,Q60)","v":-3.2},{"$f":"_xlfn.FORMULATEXT(L67)","v":"=-ROUNDUP(L66,Q60)"}]
[null,null,null,null,null,null,null,null,null,null,"Second Adjustment",{"$f":"IF(L67<0,L67+1,L67)","v":-2.2000000000000002},"=IF(L67<0,L67+1,L67)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Adj Min for Round",{"$f":"ROUNDDOWN(L62,L68)","v":1300},"min adj"]
[null,"Code Number",null,4,null,null,null,null,null,null,"Adj Max for Round",{"$f":"ROUNDUP(L63,L68)","v":2000},"max adj"]
[]
[]
[null,{"$f":"INDEX(B3:B22,$D$71)","v":"Labour at Plant - Operations"}]
[]
["Financial Model Comparison"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revised Forecast'!L1","v":2009},{"$f":"'Revised Forecast'!M1","v":2010},{"$f":"'Revised Forecast'!N1","v":2011},{"$f":"'Revised Forecast'!O1","v":2012},{"$f":"'Revised Forecast'!P1","v":2013},{"$f":"'Revised Forecast'!Q1","v":2014},{"$f":"'Revised Forecast'!R1","v":2015},{"$f":"'Revised Forecast'!S1","v":2016},{"$f":"'Revised Forecast'!T1","v":2017},{"$f":"'Revised Forecast'!U1","v":2018},{"$f":"'Revised Forecast'!V1","v":2019},{"$f":"'Revised Forecast'!W1","v":2020},{"$f":"'Revised Forecast'!X1","v":2021},{"$f":"'Revised Forecast'!Y1","v":2022},{"$f":"'Revised Forecast'!Z1","v":2023},{"$f":"'Revised Forecast'!AA1","v":2024},{"$f":"'Revised Forecast'!AB1","v":2025}]
[null,"Financial Model",null,{"$f":"INDEX('Graph Data from Match'!D3:D22,'Graph Data from Match'!D71)","v":14},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX('Original FM'!G:G,'Graph Data from Match'!$D$78)","v":3200},{"$f":"INDEX('Original FM'!H:H,'Graph Data from Match'!$D$78)","v":3247.9999999999995},{"$f":"INDEX('Original FM'!I:I,'Graph Data from Match'!$D$78)","v":3296.7199999999993},{"$f":"INDEX('Original FM'!J:J,'Graph Data from Match'!$D$78)","v":3346.170799999999},{"$f":"INDEX('Original FM'!K:K,'Graph Data from Match'!$D$78)","v":3396.3633619999987},{"$f":"INDEX('Original FM'!L:L,'Graph Data from Match'!$D$78)","v":3447.3088124299984},{"$f":"INDEX('Original FM'!M:M,'Graph Data from Match'!$D$78)","v":3499.0184446164481},{"$f":"INDEX('Original FM'!N:N,'Graph Data from Match'!$D$78)","v":3551.5037212856946},{"$f":"INDEX('Original FM'!O:O,'Graph Data from Match'!$D$78)","v":3604.7762771049797},{"$f":"INDEX('Original FM'!P:P,'Graph Data from Match'!$D$78)","v":3658.8479212615539},{"$f":"INDEX('Original FM'!Q:Q,'Graph Data from Match'!$D$78)","v":3713.7306400804769},{"$f":"INDEX('Original FM'!R:R,'Graph Data from Match'!$D$78)","v":3769.4365996816837},{"$f":"INDEX('Original FM'!S:S,'Graph Data from Match'!$D$78)","v":3825.9781486769084},{"$f":"INDEX('Original FM'!T:T,'Graph Data from Match'!$D$78)","v":3883.3678209070617},{"$f":"INDEX('Original FM'!U:U,'Graph Data from Match'!$D$78)","v":3941.6183382206673},{"$f":"INDEX('Original FM'!V:V,'Graph Data from Match'!$D$78)","v":4000.7426132939768},{"$f":"INDEX('Original FM'!W:W,'Graph Data from Match'!$D$78)","v":4060.7537524933859}]
[null,"Actual/Forecast",null,{"$f":"INDEX('Graph Data from Match'!G3:G22,'Graph Data from Match'!D71)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(P$76:P$135,$D$79)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"History",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Revised Forecast'!L2,MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!M2,MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!N2,MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!O2,MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!P2,MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!Q2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!R2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!S2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!T2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!U2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!V2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!W2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!X2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!Y2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!Z2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!AA2,MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF('Revised Forecast'!AB2,MAX($P$78:$AF$79),\"\")","v":""}]
[null,"Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT('Revised Forecast'!L2),MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF(NOT('Revised Forecast'!M2),MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF(NOT('Revised Forecast'!N2),MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF(NOT('Revised Forecast'!O2),MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF(NOT('Revised Forecast'!P2),MAX($P$78:$AF$79),\"\")","v":""},{"$f":"IF(NOT('Revised Forecast'!Q2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!R2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!S2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!T2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!U2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!V2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!W2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!X2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Y2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Z2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AA2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AB2),MAX($P$78:$AF$79),\"\")","v":{"$error":"#N/A"}}]
[]
[null,"Raw data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P77","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"History",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Revised Forecast'!L2,P79)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!M2,Q79)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!N2,R79)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!O2,S79)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!P2,T79)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!Q2,U79)","v":false},{"$f":"IF('Revised Forecast'!R2,V79)","v":false},{"$f":"IF('Revised Forecast'!S2,W79)","v":false},{"$f":"IF('Revised Forecast'!T2,X79)","v":false},{"$f":"IF('Revised Forecast'!U2,Y79)","v":false},{"$f":"IF('Revised Forecast'!V2,Z79)","v":false},{"$f":"IF('Revised Forecast'!W2,AA79)","v":false},{"$f":"IF('Revised Forecast'!X2,AB79)","v":false},{"$f":"IF('Revised Forecast'!Y2,AC79)","v":false},{"$f":"IF('Revised Forecast'!Z2,AD79)","v":false},{"$f":"IF('Revised Forecast'!AA2,AE79)","v":false},{"$f":"IF('Revised Forecast'!AB2,AF79)","v":false}]
[null,"Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT('Revised Forecast'!L2),P79)","v":false},{"$f":"IF(NOT('Revised Forecast'!M2),Q79)","v":false},{"$f":"IF(NOT('Revised Forecast'!N2),R79)","v":false},{"$f":"IF(NOT('Revised Forecast'!O2),S79)","v":false},{"$f":"IF(NOT('Revised Forecast'!P2),T79)","v":false},{"$f":"IF(NOT('Revised Forecast'!Q2),U79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!R2),V79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!S2),W79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!T2),X79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!U2),Y79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!V2),Z79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!W2),AA79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!X2),AB79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Y2),AC79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Z2),AD79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AA2),AE79)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AB2),AF79)","v":{"$error":"#N/A"}}]
[]
[null,"Generation Percent"]
[null,"Generation  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revised Forecast'!L6","v":135000},{"$f":"'Revised Forecast'!M6","v":140000},{"$f":"'Revised Forecast'!N6","v":138000},{"$f":"'Revised Forecast'!O6","v":136000},{"$f":"'Revised Forecast'!P6","v":135500},{"$f":"'Revised Forecast'!Q6","v":139082.47535484374},{"$f":"'Revised Forecast'!R6","v":136996.23822452108},{"$f":"'Revised Forecast'!S6","v":134941.29465115326},{"$f":"'Revised Forecast'!T6","v":132917.17523138598},{"$f":"'Revised Forecast'!U6","v":130923.41760291519},{"$f":"'Revised Forecast'!V6","v":128959.56633887146},{"$f":"'Revised Forecast'!W6","v":127025.17284378839},{"$f":"'Revised Forecast'!X6","v":125119.79525113155},{"$f":"'Revised Forecast'!Y6","v":123242.99832236458},{"$f":"'Revised Forecast'!Z6","v":121394.35334752912},{"$f":"'Revised Forecast'!AA6","v":119573.43804731619},{"$f":"'Revised Forecast'!AB6","v":117779.83647660645}]
[null,{"$f":"B85","v":"History"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Revised Forecast'!L2,P85/P89)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!M2,Q85/Q89)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!N2,R85/R89)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!O2,S85/S89)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!P2,T85/T89)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!Q2,U85/U89)","v":false},{"$f":"IF('Revised Forecast'!R2,V85/V89)","v":false},{"$f":"IF('Revised Forecast'!S2,W85/W89)","v":false},{"$f":"IF('Revised Forecast'!T2,X85/X89)","v":false},{"$f":"IF('Revised Forecast'!U2,Y85/Y89)","v":false},{"$f":"IF('Revised Forecast'!V2,Z85/Z89)","v":false},{"$f":"IF('Revised Forecast'!W2,AA85/AA89)","v":false},{"$f":"IF('Revised Forecast'!X2,AB85/AB89)","v":false},{"$f":"IF('Revised Forecast'!Y2,AC85/AC89)","v":false},{"$f":"IF('Revised Forecast'!Z2,AD85/AD89)","v":false},{"$f":"IF('Revised Forecast'!AA2,AE85/AE89)","v":false},{"$f":"IF('Revised Forecast'!AB2,AF85/AF89)","v":false}]
[null,{"$f":"B86","v":"Forecast"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT('Revised Forecast'!L2),P79/P89)","v":false},{"$f":"IF(NOT('Revised Forecast'!M2),Q79/Q89)","v":false},{"$f":"IF(NOT('Revised Forecast'!N2),R79/R89)","v":false},{"$f":"IF(NOT('Revised Forecast'!O2),S79/S89)","v":false},{"$f":"IF(NOT('Revised Forecast'!P2),T79/T89)","v":false},{"$f":"IF(NOT('Revised Forecast'!Q2),U79/U89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!R2),V79/V89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!S2),W79/W89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!T2),X79/X89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!U2),Y79/Y89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!V2),Z79/Z89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!W2),AA79/AA89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!X2),AB79/AB89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Y2),AC79/AC89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Z2),AD79/AD89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AA2),AE79/AE89)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AB2),AF79/AF89)","v":{"$error":"#N/A"}}]
[]
[null,"Revenue Percent"]
[null,"Revenue  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revised Forecast'!L12","v":18600},{"$f":"'Revised Forecast'!M12","v":19584},{"$f":"'Revised Forecast'!N12","v":19663.560000000001},{"$f":"'Revised Forecast'!O12","v":19818.059400000002},{"$f":"'Revised Forecast'!P12","v":20052.055764000001},{"$f":"'Revised Forecast'!Q12","v":20643.465633913547},{"$f":"'Revised Forecast'!R12","v":20304.734109426437},{"$f":"'Revised Forecast'!S12","v":19971.083557806644},{"$f":"'Revised Forecast'!T12","v":19642.437764461145},{"$f":"'Revised Forecast'!U12","v":19318.721658015827},{"$f":"'Revised Forecast'!V12","v":18999.861293167192},{"$f":"'Revised Forecast'!W12","v":18685.783833791287},{"$f":"'Revised Forecast'!X12","v":18376.417536306013},{"$f":"'Revised Forecast'!Y12","v":18071.691733283023},{"$f":"'Revised Forecast'!Z12","v":17771.536817305379},{"$f":"'Revised Forecast'!AA12","v":17475.884225067399},{"$f":"'Revised Forecast'!AB12","v":17184.666421712987}]
[null,{"$f":"B90","v":"History"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Revised Forecast'!L2,P79/P94)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!M2,Q79/Q94)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!N2,R79/R94)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!O2,S79/S94)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!P2,T79/T94)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!Q2,U79/U94)","v":false},{"$f":"IF('Revised Forecast'!R2,V79/V94)","v":false},{"$f":"IF('Revised Forecast'!S2,W79/W94)","v":false},{"$f":"IF('Revised Forecast'!T2,X79/X94)","v":false},{"$f":"IF('Revised Forecast'!U2,Y79/Y94)","v":false},{"$f":"IF('Revised Forecast'!V2,Z79/Z94)","v":false},{"$f":"IF('Revised Forecast'!W2,AA79/AA94)","v":false},{"$f":"IF('Revised Forecast'!X2,AB79/AB94)","v":false},{"$f":"IF('Revised Forecast'!Y2,AC79/AC94)","v":false},{"$f":"IF('Revised Forecast'!Z2,AD79/AD94)","v":false},{"$f":"IF('Revised Forecast'!AA2,AE79/AE94)","v":false},{"$f":"IF('Revised Forecast'!AB2,AF79/AF94)","v":false}]
[null,{"$f":"B91","v":"Forecast"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT('Revised Forecast'!L2),P79/P94)","v":false},{"$f":"IF(NOT('Revised Forecast'!M2),Q79/Q94)","v":false},{"$f":"IF(NOT('Revised Forecast'!N2),R79/R94)","v":false},{"$f":"IF(NOT('Revised Forecast'!O2),S79/S94)","v":false},{"$f":"IF(NOT('Revised Forecast'!P2),T79/T94)","v":false},{"$f":"IF(NOT('Revised Forecast'!Q2),U79/U94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!R2),V79/V94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!S2),W79/W94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!T2),X79/X94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!U2),Y79/Y94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!V2),Z79/Z94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!W2),AA79/AA94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!X2),AB79/AB94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Y2),AC79/AC94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Z2),AD79/AD94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AA2),AE79/AE94)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AB2),AF79/AF94)","v":{"$error":"#N/A"}}]
[]
[null,"Expense Percent"]
[null,"Expense  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revised Forecast'!L20","v":10445},{"$f":"'Revised Forecast'!M20","v":10430},{"$f":"'Revised Forecast'!N20","v":9440},{"$f":"'Revised Forecast'!O20","v":10010},{"$f":"'Revised Forecast'!P20","v":10342},{"$f":"'Revised Forecast'!Q20","v":10727.564999999999},{"$f":"'Revised Forecast'!R20","v":10727.564999999999},{"$f":"'Revised Forecast'!S20","v":10727.564999999999},{"$f":"'Revised Forecast'!T20","v":10727.564999999999},{"$f":"'Revised Forecast'!U20","v":10727.564999999999},{"$f":"'Revised Forecast'!V20","v":10727.564999999999},{"$f":"'Revised Forecast'!W20","v":10727.564999999999},{"$f":"'Revised Forecast'!X20","v":10727.564999999999},{"$f":"'Revised Forecast'!Y20","v":10727.564999999999},{"$f":"'Revised Forecast'!Z20","v":10727.564999999999},{"$f":"'Revised Forecast'!AA20","v":10727.564999999999},{"$f":"'Revised Forecast'!AB20","v":10727.564999999999}]
[null,{"$f":"B95","v":"History"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Revised Forecast'!L2,P79/P99)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!M2,Q79/Q99)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!N2,R79/R99)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!O2,S79/S99)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!P2,T79/T99)","v":{"$error":"#N/A"}},{"$f":"IF('Revised Forecast'!Q2,U79/U99)","v":false},{"$f":"IF('Revised Forecast'!R2,V79/V99)","v":false},{"$f":"IF('Revised Forecast'!S2,W79/W99)","v":false},{"$f":"IF('Revised Forecast'!T2,X79/X99)","v":false},{"$f":"IF('Revised Forecast'!U2,Y79/Y99)","v":false},{"$f":"IF('Revised Forecast'!V2,Z79/Z99)","v":false},{"$f":"IF('Revised Forecast'!W2,AA79/AA99)","v":false},{"$f":"IF('Revised Forecast'!X2,AB79/AB99)","v":false},{"$f":"IF('Revised Forecast'!Y2,AC79/AC99)","v":false},{"$f":"IF('Revised Forecast'!Z2,AD79/AD99)","v":false},{"$f":"IF('Revised Forecast'!AA2,AE79/AE99)","v":false},{"$f":"IF('Revised Forecast'!AB2,AF79/AF99)","v":false}]
[null,{"$f":"B96","v":"Forecast"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT('Revised Forecast'!L2),P79/P99)","v":false},{"$f":"IF(NOT('Revised Forecast'!M2),Q79/Q99)","v":false},{"$f":"IF(NOT('Revised Forecast'!N2),R79/R99)","v":false},{"$f":"IF(NOT('Revised Forecast'!O2),S79/S99)","v":false},{"$f":"IF(NOT('Revised Forecast'!P2),T79/T99)","v":false},{"$f":"IF(NOT('Revised Forecast'!Q2),U79/U99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!R2),V79/V99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!S2),W79/W99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!T2),X79/X99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!U2),Y79/Y99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!V2),Z79/Z99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!W2),AA79/AA99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!X2),AB79/AB99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Y2),AC79/AC99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!Z2),AD79/AD99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AA2),AE79/AE99)","v":{"$error":"#N/A"}},{"$f":"IF(NOT('Revised Forecast'!AB2),AF79/AF99)","v":{"$error":"#N/A"}}]
[]
[]
[null,{"$f":"CHOOSE($K$120,B83,B88,B93,B98)","v":"Revenue Percent"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($K$120,P83,P88,P93,P98)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revised Forecast'!L1","v":2009},{"$f":"'Revised Forecast'!M1","v":2010},{"$f":"'Revised Forecast'!N1","v":2011},{"$f":"'Revised Forecast'!O1","v":2012},{"$f":"'Revised Forecast'!P1","v":2013},{"$f":"'Revised Forecast'!Q1","v":2014},{"$f":"'Revised Forecast'!R1","v":2015},{"$f":"'Revised Forecast'!S1","v":2016},{"$f":"'Revised Forecast'!T1","v":2017},{"$f":"'Revised Forecast'!U1","v":2018},{"$f":"'Revised Forecast'!V1","v":2019},{"$f":"'Revised Forecast'!W1","v":2020},{"$f":"'Revised Forecast'!X1","v":2021},{"$f":"'Revised Forecast'!Y1","v":2022},{"$f":"'Revised Forecast'!Z1","v":2023},{"$f":"'Revised Forecast'!AA1","v":2024},{"$f":"'Revised Forecast'!AB1","v":2025}]
[null,{"$f":"CHOOSE($K$120,B85,B90,B95,B100)","v":"History"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($K$120,P85,P90,P95,P100)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},false,false,false,false,false,false,false,false,false,false,false,false]
[null,{"$f":"CHOOSE($K$120,B86,B91,B96,B101)","v":"Forecast"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($K$120,P86,P91,P96,P101)","v":false},false,false,false,false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Titles and Misc"]
[]
[null,null,{"$f":"'Graph Data from Match'!B74","v":"Labour at Plant - Operations"},null,null,null,{"$f":"B104","v":"Revenue Percent"}]
[]
[null,null,"Average of History"]
[null,null,"Last History"]
[null,null,"Financial Model "]
[null,null,"Simple Input"]
[null,null,"Detailed Input"]
[]
[]
[null,null,"Raw Data",null,null,null,null,null,null,null,3]
[null,null,"Generation Percent"]
[null,null,"Revenue Percent"]
[null,null,"Expense Percent"]

{"sheet":"Graph Actual vs FM","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"IRR and Growth","index":11,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"One Year Case",null,null,"Two Year Case",null,null,"Three Year Case"]
[]
[null,"Cash Outflow",-100,100,null,-100,100,null,-100,100]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,"Cash Inflow",110,110,null,110,110,null,110,110]
[]
[null,"IRR",{"$f":"IRR(C3:C6)","v":0.10000000000000009},null,null,{"$f":"IRR(F3:F6)","v":4.8808848169907604E-2},null,null,{"$f":"IRR(I3:I6)","v":3.2280115456367664E-2}]
[null,"Growth Rate",null,{"$f":"D6/D3-1","v":0.10000000000000009},null,null,{"$f":"(G6/G3)^(1/2)-1","v":4.8808848170151631E-2},null,null,{"$f":"(J6/J3)^(1/3)-1","v":3.228011545636722E-2}]

{"sheet":"Data from PDF","index":12,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["five-year"]
["group financial"]
["summary"]
["Group"]
["Year Ended 31 August"]
[2011]
["(Restated)"]
[2012]
["(Restated)"]
[2013]
["(Restated)"]
["2014 2015"]
["OPERATING RESULTS (RM MILLION)1"]
["Revenue 32,241.2 35,848.4 37,130.7 42,792.4 43,286.8"]
["Operating Profit 1,816.8 6,680.8 5,906.9 7,181.0 8,627.6"]
["Profit before taxation and zakat 1,156.7 5,821.1 5,925.1 7,114.7 7,133.7"]
["Net profit attributable to owners of the Company 965.4 4,410.5 5,356.2 6,467.0 6,118.4"]
["KEY BALANCE SHEET DATA (RM MILLION)2"]
["Property, plant and equipment 61,861.4 64,769.9 75,460.5 83,045.1 90,300.3"]
["Total assets 79,064.3 88,469.1 99,999.3 110,665.4 117,135.0"]
["Total borrowings 19,054.1 23,071.8 22,888.4 25,456.0 24,698.9"]
["Total liabilities 48,286.4 53,311.8 62,028.6 67,206.2 69,668.1"]
["Share capital 5,456.6 5,501.6 5,643.6 5,643.6 5,643.6"]
["Shareholders’ equity 30,547.3 34,897.7 37,693.1 43,222.0 47,208.0"]
["SHARE INFORMATION"]
["Per share (sen)"]
["Basic earnings 17.71 80.71 96.13 114.59 108.41"]
["Diluted earnings 17.67 80.51 95.96 114.59 108.41"]
["Gross dividend 4.50 20.09 25.00 29.00 29.00"]
["Net Assets 559.80 634.3 667.9 765.9 836.5"]
["Share price as @ 31 August (RM) 5.25 6.84 8.73 12.38 11.18"]
["FINANCIAL RATIOS3"]
["Return on assets (%) 4.1 4.5 5.6 6.2 6.6"]
["Return on shareholders’ equity (%) 10.1 11.4 14.7 15.8 16.3"]
["Gearing (%) 38.2 39.6 37.6 36.9 34.2"]
["EBITDA margin (%) 23.3 25.9 28.1 28.2 32.2"]
["Effective weighted average cost of funds (%) 5.1 4.9 4.7 4.9 4.8"]
["Interest coverage (%) 8.5 11.3 11.7 13.8 14.7"]
["Currency mix (RM:Foreign) 56:44 65:35 71:29 77:23 78:22"]
["Debt-equity (net of cash) ratio4 0.47 0.41 0.35 0.32 0.33"]

{"sheet":"Reformatted Data","index":13,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,2011,2012,2013,2014,2015]
["OPERATING RESULTS RM MILLION Revenue",32241.200000000001,35848.400000000001,37130.699999999997,42792.4,43286.8]
["Operating Profit",1816.8,6680.8,5906.9,7181,8627.6]
["Profit before taxation and zakat",1156.7,5821.1,5925.1,7114.7,7133.7]
["Net profit attributable to owners of the Company",965.4,4410.5,5356.2,6467,6118.4]
["KEY BALANCE SHEET DATA RM MILLION Property plant and equipment",61861.4,64769.9,75460.5,83045.100000000006,90300.3]
["Total assets",79064.3,88469.1,99999.3,110665.4,117135]
["Total borrowings",19054.099999999999,23071.8,22888.400000000001,25456,24698.9]
["Total liabilities",48286.400000000001,53311.8,62028.6,67206.2,69668.100000000006]
["Share capital",5456.6,5501.6,5643.6,5643.6,5643.6]
["Shareholders’ equity",30547.3,34897.699999999997,37693.1,43222,47208]
["SHARE INFORMATION"]
["Per share sen Basic earnings",17.71,80.709999999999994,96.13,114.59,108.41]
["Diluted earnings",17.670000000000002,80.510000000000005,95.96,114.59,108.41]
["Gross dividend",4.5,20.09,25,29,29]
["Net Assets",559.79999999999995,634.29999999999995,667.9,765.9,836.5]
["Share price as @ August RM",5.25,6.84,8.73,12.38,11.18]
["FINANCIAL RATIOS Return on assets",4.0999999999999996,4.5,5.6,6.2,6.6]
["Return on shareholders’ equity",10.1,11.4,14.7,15.8,16.3]
["Gearing",38.200000000000003,39.6,37.6,36.9,34.200000000000003]
["EBITDA margin",23.3,25.9,28.1,28.2,32.200000000000003]
["Effective weighted average cost of funds",5.0999999999999996,4.9000000000000004,4.7,4.9000000000000004,4.8]
["Interest coverage",8.5,11.3,11.7,13.8,14.7]
["Currency mix RM:Foreign",2.3638888888888889,2.7326388888888888,2.9784722222222224,3.224305555555556,3.2652777777777775]
["Debt equity net of cash ratio",0.47,0.41,0.35,0.32,0.33]
[]
[]
[]
["Row number:",12]
[null,2011,2012,2013,2014,2015]
[{"$f":"INDEX(A2:A25,$B$29)","v":"Per share sen Basic earnings"},{"$f":"INDEX(B2:B25,$B$29)","v":17.71},80.709999999999994,96.13,114.59,108.41]

{"sheet":"Waterfall Chartdata1","index":16,"n_rows":20,"n_cols":86,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["EBITDA in FM \r 10,314.78",10314.783900000002,null,null,687.65226000000018,10314.783900000002,null,null,null,null,null,null,10314.783900000002,{"$f":"M1","v":10314.783900000002},null,{"$f":"N1","v":10314.783900000002},{"$f":"ABS(O1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"waterfall_graph_data1","v":"EBITDA in FM"},10341.675159330003,{"$f":"BA1","v":10341.675159330003},null,{"$f":"BB1","v":10341.675159330003},{"$f":"ABS(BC1)","v":0},687.65226000000018,{"$f":"BD1","v":10341.675159330003},{"$f":"IF(BC1>=0,0,BF1)","v":0},{"$f":"IF(BC1<0,0,BF1)","v":687.65226000000018},{"$f":"BA1","v":10341.675159330003},null,null,null,null,null,null,{"$f":"AZ1","v":"EBITDA in FM"}," \n",{"$f":"BB1","v":10341.675159330003},{"$f":"BQ1&BR1&TEXT(BS1,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"EBITDA in FM \n10,341.68"},{"$f":"BG1","v":10341.675159330003},{"$f":"BH1","v":0},{"$f":"BE1","v":0},{"$f":"BI1","v":687.65226000000018},{"$f":"BB1","v":10341.675159330003}]
["Reduced Revenue \r 9,101.49",8413.8416400000006,687.65226000000018,1213.2900000000009,null,10314.783900000002,9101.4939000000013,null,null,null,null,null,-1213.2900000000009,{"$f":"IF(M2<>0,N1+M2,N1)","v":9101.4939000000013},{"$f":"N2-N1","v":-1213.2900000000009},{"$f":"IF(O2>=0,N2-O2,N1+O2)","v":9101.4939000000013},1213.2900000000009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduced Revenue",-1231.4772630000007,{"$f":"IF(BA2<>0,BB1+BA2,BB1)","v":9110.1978963300025},{"$f":"BB2-BB1","v":-1231.4772630000007},{"$f":"IF(BC2>=0,BB2-BC2,BB1+BC2)","v":9110.1978963300025},1231.4772630000007,687.65226000000018,{"$f":"IF(BC2>=0,BD2,BD2-BF2)","v":8422.5456363300018},687.65226000000018,0,{"$f":"IF(BC2<>0,BC2,BB2)","v":-1231.4772630000007},null,null,null,null,null,null,"Reduced Revenue"," \n",9110.1978963300025,"Reduced Revenue \n9,110.20",8422.5456363300018,687.65226000000018,1231.4772630000007,0,{"$f":"BB1","v":10341.675159330003},{"$f":"BB2","v":9110.1978963300025}]
["Sub Total \r 9,101.49",9101.4939000000013,null,0,687.65226000000018,null,9101.4939000000013,9101.4939000000013,null,null,null,null,null,9101.4939000000013,0,9101.4939000000013,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub Total",0,9110.1978963300025,0,9110.1978963300025,0,687.65226000000018,9110.1978963300025,0,687.65226000000018,9110.1978963300025,null,null,null,null,null,null,"Sub Total"," \n",9110.1978963300025,"Sub Total \n9,110.20",9110.1978963300025,0,0,687.65226000000018,null,{"$f":"BB2","v":9110.1978963300025},{"$f":"BB3","v":9110.1978963300025}]
["Royalty Expense \r 9,573.25",9101.4939000000013,null,471.75610000000052,687.65226000000018,null,null,9101.4939000000013,9573.2500000000018,null,null,null,471.75610000000006,9573.2500000000018,471.75610000000052,9101.4939000000013,471.75610000000052,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Royalty Expense",530.55335367000021,9640.751250000003,530.55335367000043,9110.1978963300025,530.55335367000043,687.65226000000018,9110.1978963300025,0,687.65226000000018,530.55335367000043,null,null,null,null,null,null,"Royalty Expense"," \n",9640.751250000003,"Royalty Expense \n9,640.75",9110.1978963300025,0,530.55335367000043,687.65226000000018,null,null,{"$f":"BB3","v":9110.1978963300025},{"$f":"BB4","v":9640.751250000003}]
["Labour at Plant - Operations \r 9,321.25",8633.5977400000011,687.65226000000018,252,null,null,null,null,9573.2500000000018,9321.2500000000018,null,null,-252.00000000000045,9321.2500000000018,-252,9321.2500000000018,252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour at Plant - Operations",496.71999999999935,10137.471250000002,496.71999999999935,9640.751250000003,496.71999999999935,687.65226000000018,9640.751250000003,0,687.65226000000018,496.71999999999935,null,null,null,null,null,null,"Labour at Plant - Operations"," \n",10137.471250000002,"Labour at Plant - Operations \n10,137.47",9640.751250000003,0,496.71999999999935,687.65226000000018,null,null,null,{"$f":"BB4","v":9640.751250000003},{"$f":"BB5","v":10137.471250000002}]
["Materials for Maintenance \r 9,405.25",9321.2500000000018,null,84,687.65226000000018,null,null,null,null,9321.2500000000018,9405.2500000000018,null,84,9405.2500000000018,84,9321.2500000000018,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Materials for Maintenance",118.31999999999994,10255.791250000002,118.31999999999971,10137.471250000002,118.31999999999971,687.65226000000018,10137.471250000002,0,687.65226000000018,118.31999999999971,null,null,null,null,null,null,"Materials for Maintenance"," \n",10255.791250000002,"Materials for Maintenance \n10,255.79",10137.471250000002,0,118.31999999999971,687.65226000000018,null,null,null,null,{"$f":"BB5","v":10137.471250000002},{"$f":"BB6","v":10255.791250000002}]
["Labour for Maintenance \r 9,230.25",8542.5977400000011,687.65226000000018,175,null,null,null,null,null,null,9405.2500000000018,9230.2500000000018,-175,9230.2500000000018,-175,9230.2500000000018,175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour for Maintenance",-49.75,10206.041250000002,-49.75,10206.041250000002,49.75,687.65226000000018,9518.3889900000013,687.65226000000018,0,-49.75,null,null,null,null,null,null,"Labour for Maintenance"," \n",10206.041250000002,"Labour for Maintenance \n10,206.04",9518.3889900000013,687.65226000000018,49.75,0,null,null,null,null,null,{"$f":"BB6","v":10255.791250000002},{"$f":"BB7","v":10206.041250000002}]
["Other Admin Expense \r 9,354.00",9230.2500000000018,null,123.75,687.65226000000018,null,null,null,null,null,null,9230.2500000000018,123.74999999999989,9354.0000000000018,123.75,9230.2500000000018,123.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Admin Expense",117.51874999999984,10323.560000000001,117.51874999999927,10206.041250000002,117.51874999999927,687.65226000000018,10206.041250000002,0,687.65226000000018,117.51874999999927,null,null,null,null,null,null,"Other Admin Expense"," \n",10323.560000000001,"Other Admin Expense \n10,323.56",10206.041250000002,0,117.51874999999927,687.65226000000018,null,null,null,null,null,null,{"$f":"BB7","v":10206.041250000002},{"$f":"BB8","v":10323.560000000001}]
["Insurance Expense \r 9,154.00",8466.3477400000011,687.65226000000018,200,null,null,null,null,null,null,null,null,-200,9154.0000000000018,-200,9154.0000000000018,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insurance Expense",-100,10223.560000000001,-100,10223.560000000001,100,687.65226000000018,9535.9077400000006,687.65226000000018,0,-100,null,null,null,null,null,null,"Insurance Expense"," \n",10223.560000000001,"Insurance Expense \n10,223.56",9535.9077400000006,687.65226000000018,100,0,null,null,null,null,null,null,null,{"$f":"BB8","v":10323.560000000001},{"$f":"BB9","v":10223.560000000001}]
["EBITDA Actual \r 9,154.00",9154.0000000000018,null,0,687.65226000000018,null,null,null,null,null,null,null,0,9154.0000000000018,0,9154.0000000000018,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBITDA Actual",0,10223.560000000001,0,10223.560000000001,0,687.65226000000018,10223.560000000001,0,687.65226000000018,10223.560000000001,null,null,null,null,null,null,"EBITDA Actual"," \n",10223.560000000001,"EBITDA Actual \n10,223.56",10223.560000000001,0,0,687.65226000000018,null,null,null,null,null,null,null,null,{"$f":"BB9","v":10223.560000000001}]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":54},{"$f":"COLUMN()","v":55},{"$f":"COLUMN()","v":56},{"$f":"COLUMN()","v":57},{"$f":"COLUMN()","v":58},{"$f":"COLUMN()","v":59},{"$f":"COLUMN()","v":60},{"$f":"COLUMN()","v":61},{"$f":"COLUMN()","v":62},{"$f":"COLUMN()","v":63},{"$f":"COLUMN()","v":64},{"$f":"COLUMN()","v":65},{"$f":"COLUMN()","v":66},{"$f":"COLUMN()","v":67},{"$f":"COLUMN()","v":68},{"$f":"COLUMN()","v":69},{"$f":"COLUMN()","v":70},{"$f":"COLUMN()","v":71},{"$f":"COLUMN()","v":72},{"$f":"COLUMN()","v":73},{"$f":"COLUMN()","v":74},{"$f":"COLUMN()","v":75},{"$f":"COLUMN()","v":76},{"$f":"COLUMN()","v":77},{"$f":"COLUMN()","v":78},{"$f":"COLUMN()","v":79},{"$f":"COLUMN()","v":80},{"$f":"COLUMN()","v":81},{"$f":"COLUMN()","v":82},{"$f":"COLUMN()","v":83},{"$f":"COLUMN()","v":84},{"$f":"COLUMN()","v":85},{"$f":"COLUMN()","v":86}]
[" Fixed Graph: Graph Titles ",null,null," Fixed Graph: Increment (absolute Value) ",null," Fixed Graph: Connectors ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: BASE VALUE: If not zero accumulate; if zero Last Value ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Link to the Title "]
[null," Fixed Graph: Base of Stacked Bar",null,null," Fixed Graph: Space for Increment ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: ACCUMULATED VALUE:  Formula is accumulation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Adjusted Base of Stack from calculation  "]
[null,null," Fixed Graph: Space for Negative Label (Not Graphed ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: INCREMENT: Formula is difference between accumulated value ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Space for Value in Negative Case  "]
[" TO MAKE GRAPH BY YOURSELF ",null,null,null,null,null,null,null,null,null,null,"   Chart Title",{"$f":"AZ1","v":"EBITDA in FM"},{"$f":"TEXT(BB1,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"10,341.68"},"Bulid-up Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: BASE OF STACK BAR WITHOUT ADJUSTMENT:  Base of Stacked Bar: Formula depends on the increment.  If positive then ACC - Incr if negative Last ACC + Incr ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Absolute Value of Increment  "]
["    1. PRESS ALT F1 on the yellow AREA  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: ABS VALUE OF INCREMENT: This is enough to make graph without fancy stuff ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Space for Value in Positive Case  "]
["    2. CHANGE TO STACKED BAR  AND SWITCH AROUND ROW AND COLUMN  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," INPUT: LABEL SPACE: This is enough to make graph without fancy stuff "]
["    3. SELECT DATA SERIES AND NO FILL EVERYTHING EXCEPT INCREMENTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: ADJUSTED BASE VALUE: This is base of the stacked bar minus the label space if the increment is negative "]
["    4. SELECT DATA PONTS FOR BASE BAR AND FILL STARTING, ENDING AND SUBTOTALS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: NEGATIVE SPACE: This is the label space if the increment is negative "]
["   5. CHANGE THE SERIES CHART TYPE OF THE CONNECTOR LINES -- SERIES 5 FORWARD ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: POSITIVE SPACE: This is label space if the increment is positive "]