{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Coal Requirement 2020","Disclaimer","Model","Assumptions and Results","Your Result","Sensitivity Analysis","Power Demand Projections","Calculations ","Plants Breakdown","Import analysis","Power Capacity Projections","Coal Quality","Efficiency Calculation","Railway in cotext of coal","Additional Information "],"not_rendered":{"charts":15,"images":10,"macros":1,"external_links":0,"defined_names":0,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coal Requirement 2020","index":0,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,16,32,16]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal Requirement in 2020: A bottom up analysis, Accompanying Excel Model\n\nThis Model accompanies the research paper \"Coal Requirement in 2020: A Bottom-up Analysis\" by Rahul Tongia & Anurag Sehgal\n\nThe study examines coal demand in 2020, the year of the 1,500 MT tonnes production target, based on various ranges of demand by the power and other sectors.  This detailed model considers multiple variables, uncertainty, and choices which can impact coal demand. \nWe are sharing this model for end-users to examine the and even change assumptions for the calculations.  The aim is to increase the transparency of the analysis and broaden meaningful debate on such issues.  The model remains the intellectual property of the authors/Brookings India, and should not be re-used without permission.  \n\nBelow are the links for the research Paper \"Coal Requirement in 2020: A Bottom-up Analysis\" and the accompanying \"Excel Model\" for downloading and sharing.\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model (Click to see key scenarios and change assumptions)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumptions and results"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensitivity Analysis"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Link to paper: http://www.brookings.in/impact-series-post/paper-coal-requirement-in-2020-a-bottom-up-analysis/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Share Model with others by this link"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.brookings.in/coal-requirement-in-2020-a-bottom-up-analysis/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended citation:  Tongia, Rahul; Sehgal, Anurag; Mishra, Abhishek (2016). “Coal Requirement in 2020: A Bottom-up Analysis Excel Model,” Brookings India, Accompanying Excel Model for Research Paper No. 072016-2."]

{"sheet":"Disclaimer","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,3,18,14]]}
[]
[]
[null,null,"Privious Page",null,null,null,null,null,null,null,null,null,null,null,null,"Next Page"]
[]
[]
[null,null,null,"Acknowledgements and Disclaimers \n\n\nThe authors gratefully acknowledge a range of people who have helped with data, feedback, ideas, etc., including leaders at the Ministry of Coal, participants at a Roundtable discussion held at Brookings India in March 2016, as well as Partha Bhattacharyya, Vivek Sahai, Rohit Chandra, Daljit Singh, and multiple others. We also benefited from detailed feedback from leaders at the Ministry of Power, Ministry of New and Renewable Energy, Central Electricity Authority, Power System Operation Corporation, and other operational and statutory bodies in the sector. We also acknowledge feedback from a number of reviewers. \n\nSupport for this publication was generously provided by Tata Steel Ltd. Brookings India recognises that the value it provides is in its absolute commitment to quality, independence, and impact. Activities supported by its donors reflect this commitment and the analysis and recommendations found in this report are solely determined by the scholar(s)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Model (Click to see key scenarios and change assumptions)"]
[null,null,null,"Assumptions and results"]
[null,null,null,"Sensitivity Analysis"]

{"sheet":"Model","index":2,"n_rows":75,"n_cols":36,"rows_kept":75,"cut":false,"hidden":false,"merged":[[13,12,14,12],[75,13,75,14],[75,15,75,16],[62,13,62,16],[64,13,64,14],[64,15,64,16],[0,11,0,12],[1,1,3,1],[64,1,64,2],[64,3,64,4],[1,2,1,5],[2,2,2,3],[1,10,3,10],[1,9,3,9],[62,5,62,12],[63,5,63,8],[63,9,63,12],[2,4,2,5],[1,6,1,7],[1,11,3,11],[13,11,14,11],[1,12,3,12]]}
[null,null,null,"Privious Page",null,null,null,null,null,null,null,"Select one of below 2 sliders to disable (by sliding all the way up)",null,null,"Next Page"]
[null,"GDP growth rate Range","Thermal Power Plant Efficency ",null,null,null,"Specific Coal Consumption (kg/Kwh)",null,"Slippage","2020 Share of RE in total Generation","% of old plants replaced by New supercritical","Import Scenarios (Scroll to change)","Import share of Utility coal demand"]
[null,null,"Existing Plants",null,"New Plants",null,"Existing  Thermal Plants","New Thermal Plants"]
[null,null,"Sub-Critical","Super Critical","Sub Critical","Super Critical","Sub Critical\nSuper Critical","Sub Critical\nSuper Critical"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'Calculations '!D21","v":0.64547685678589828},{"$f":"'Calculations '!D26","v":0.58852301648126015},null,null,null,{"$f":"VLOOKUP(L16,Model!X64:Y69,2,FALSE)","v":"Import share same as 2014-15"},{"$f":"VLOOKUP(O21,Model!AI62:AJ71,2,FALSE)","v":"Disabled "}]
[null,{"$f":"VLOOKUP(B16,Model!B66:C73,2,FALSE)","v":7.4999999999999997E-2},{"$f":"VLOOKUP(C16,Model!F66:G75,2,FALSE)","v":0.31},{"$f":"VLOOKUP(D16,Model!L66:M75,2,FALSE)","v":0.38},{"$f":"VLOOKUP(E16,Model!L66:M75,2,FALSE)","v":0.34},{"$f":"VLOOKUP(F16,Model!L66:M75,2,FALSE)","v":0.38500000000000001},{"$f":"'Calculations '!D22","v":0.52657322527270645},{"$f":"'Calculations '!D27","v":0.5197346119574765},{"$f":"VLOOKUP(I16,Model!R65:S74,2,FALSE)","v":0.25},{"$f":"0.057+J17","v":0.108},{"$f":"VLOOKUP(K16,Model!V65:W74,2,FALSE)","v":0.05}]
[null,3,6,4,7,3,4,4,4,1,1,1,0]
[null,null,null,null,null,null,4,4,null,{"$f":"VLOOKUP(J16,Model!T65:U74,2,FALSE)","v":5.0999999999999997E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,0.03,30,30,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(M16,Model!AG62:AI71,3,FALSE)","v":"Disabled"},null,null,{"$f":"VLOOKUP(G16,Model!N66:O71,2,FALSE)","v":"G11"},null,{"$f":"VLOOKUP(H16,Model!N66:O71,2,FALSE)","v":"G11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(G17,Model!N66:O71,2,FALSE)","v":"G11"},null,{"$f":"VLOOKUP(H17,Model!N66:O71,2,FALSE)","v":"G11"}]
[null,"GDP ",0.08,null,"GDP ",0.08,null,"GDP ",0.08,0.08,null,null,"GDP ",0.08]
[]
[null,"Efficeicny ",null,null,"Efficeicny ",null,null,"Efficeicny ",null,null,null,null,"Efficeicny "]
[null,"Existing Plants ",null,null,"Existing Plants ",null,null,"Existing Plants ",null,null,null,null,"Existing Plants "]
[null,"Sub-Critical ",0.31,null,"Sub-Critical ",0.31,null,"Sub-Critical ",0.31,0.31,null,null,"Sub-Critical ",0.31]
[null,"Super- Critical ",0.38,null,"Super- Critical ",0.38,null,"Super- Critical ",0.38,0.38,null,null,"Super- Critical ",0.38]
[null,"Future Plants ",null,null,"Future Plants ",null,null,"Future Plants ",null,null,null,null,"Future Plants "]
[null,"Sub-Critical ",0.34,null,"Sub-Critical ",0.34,null,"Sub-Critical ",0.34,0.34,null,null,"Sub-Critical ",0.34]
[null,"Super- Critical ",0.38500000000000001,null,"Super- Critical ",0.38500000000000001,null,"Super- Critical ",0.38500000000000001,0.38500000000000001,null,null,"Super- Critical ",0.38500000000000001]
[]
[]
[null,"Specific Coal  Consumption ","Kg/kwh",null,"Specific Coal  Consumption ","Kg/kwh",null,"Specific Coal  Consumption ","Kg/kwh","Kg/kwh",null,null,"Specific Coal  Consumption ","Kg/kwh"]
[null,"Existing Plants ",null,null,"Existing Plants ",null,null,"Existing Plants ",null,null,null,null,"Existing Plants "]
[null,"Sub-Critical ",0.64549999999999996,null,"Sub-Critical ",0.64549999999999996,null,"Sub-Critical ",0.64549999999999996,0.64549999999999996,null,null,"Sub-Critical ",0.64549999999999996]
[null,"Super- Critical ",0.52659999999999996,null,"Super- Critical ",0.52659999999999996,null,"Super- Critical ",0.52659999999999996,0.52659999999999996,null,null,"Super- Critical ",0.52659999999999996]
[null,"Future Plants ",null,null,"Future Plants ",null,null,"Future Plants ",null,null,null,null,"Future Plants "]
[null,"Sub-Critical ",0.58850000000000002,null,"Sub-Critical ",0.58850000000000002,null,"Sub-Critical ",0.58850000000000002,0.58850000000000002,null,null,"Sub-Critical ",0.58850000000000002]
[null,"Super- Critical ",0.51970000000000005,null,"Super- Critical ",0.51970000000000005,null,"Super- Critical ",0.51970000000000005,0.51970000000000005,null,null,"Super- Critical ",0.51970000000000005]
[]
[null,"2020 Share of RE in total Genration ",5.7000000000000002E-2,null,"2020 Share of RE in total Genration ",5.7000000000000002E-2,null,"2020 Share of RE in total Genration ",5.7000000000000002E-2,0.108,null,null,"2020 Share of RE in total Genration ",8.2000000000000003E-2]
[]
[null,"Import share same as FY'14-15",null,null,"Only coking coal Import ",null,null,"Import share same as FY'14-15",null,null,null,null,"Power sector reduced share by 50%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Domestic","Import","Total"]
[null,null,"Base Value",932,296,1228]
[null,null,"Your Assumption value",{"$f":"IF(L16=1,Z72,IF(L16=2,AA72,IF(L16=3,AB72,IF(L16=4,AC72,IF(L16=5,AD72,IF(L16=0,AH72))))))","v":867.5314950135471},{"$f":"IF(L16=1,Z73,IF(L16=2,AA73,IF(L16=3,AB73,IF(L16=4,AC73,IF(L16=5,AD73,IF(L16=0,AH73))))))","v":271.69754661482364},{"$f":"IF(L16=1,Z74,IF(L16=2,AA74,IF(L16=3,AB74,IF(L16=4,AC74,IF(L16=5,AD74,IF(L16=0,AH74))))))","v":1139.2290416283709}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Import power share "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Disabled","Disabled "]
[null,null,null,null,null,"Efficency ",null,null,null,null,null,null,null,"Type of Coal ",null,null,null,null,null,null,null,null,null,null,"Import",null,null,null,null,null,null,null,1,0.20499999999999999,0,{"$f":"AH63","v":0.20499999999999999}]
[null,null,null,null,null,"Old Plants",null,null,null,"New Plants",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Disable",null,null,null,null,null,null,null,2,0.14349999999999999,0.3,{"$f":"AH64","v":0.14349999999999999}]
[null,"GDP",null,"PLF",null,"Sub-Critical",null,"Super Critical",null,"Sub Critical",null,"Super Critical",null,"Sub Critical",null,null,null,1,0.1,1,5.0999999999999997E-2,1,0.05,1,"Import share same as 2014-15",null,null,null,null,null,null,null,3,0.12299999999999998,0.4,0.12299999999999998]
[null,1,8.5000000000000006E-2,1,0.8,1,0.36,1,0.31,0.4,0.31,1,0.4,1,"G14",null,null,2,0.15,2,4.4999999999999998E-2,2,4.4999999999999998E-2,2,"Power sector reduced share by 50% ",null,null,null,null,null,null,null,4,0.10249999999999999,0.5,0.10249999999999999]
[null,2,0.08,2,0.75,2,0.35,2,0.32,0.39,0.32,2,0.39,2,"G13",null,null,3,0.2,3,4.1000000000000002E-2,3,0.04,3,"No import for Power ",null,null,null,null,null,null,null,5,8.2000000000000003E-2,0.6,8.2000000000000003E-2]
[null,3,7.4999999999999997E-2,3,0.7,3,0.34,3,0.33,0.38,0.33,3,0.38500000000000001,3,"G12",null,null,4,0.25,4,3.5000000000000003E-2,4,3.5000000000000003E-2,4,"No import for power and non-power sector reduced by 50%",null,null,null,null,null,null,null,6,6.1499999999999999E-2,0.7,6.1499999999999999E-2]
[null,4,7.0000000000000007E-2,4,0.64459999999999995,4,0.33,4,0.34,0.37,0.34,4,0.38,4,"G11",null,null,3,0.3,4,3.5000000000000003E-2,1,3.5000000000000003E-2,5,"Only coking coal import",null,null,null,null,null,null,null,7,4.0999999999999981E-2,0.8,4.0999999999999981E-2]
[null,5,6.5000000000000002E-2,5,0.6,5,0.32,5,0.35,0.36,0.35,5,0.36,5,"G10",null,null,3,0.35,6,2.5000000000000001E-2,6,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,8,2.049999999999999E-2,0.9,2.049999999999999E-2]
[null,6,0.06,6,0.55000000000000004,6,0.31,6,0.36,0.35,0.36,6,0.35,6,"G9",null,null,7,0.4,7,0.02,7,0.02,null,null,1,2,3,4,5,null,null,9,0,1,0]
[null,7,5.5E-2,7,0.5,7,0.3,7,0.37,0.34,0.37,7,0.34,null,null,null,null,8,0.45,8,1.4999999999999999E-2,8,1.4999999999999999E-2,null,{"$f":"'Assumptions and Results'!P59","v":867.5314950135471},{"$f":"Y72","v":867.5314950135471},{"$f":"Z72+((Z73-AA73)*1.27158801406235)","v":958.30316218609107},{"$f":"Y72+('Assumptions and Results'!Q56*1.27158801406235)","v":1049.0748293586348},{"$f":"Y72+((Y73-AC73)*1.27158801406235)","v":1122.2471715665595},{"$f":"Y72+((Y73-AD73)*1.27158801406235)","v":1130.4212464786331},null,null,{"$f":"'Assumptions and Results'!P59","v":867.5314950135471},{"$f":"AG72+((AG73-AH73)*1.27158801406235)","v":{"$error":"#VALUE!"}}]
[null,8,0.05,8,0.45,8,0.28999999999999998,8,0.38,0.33,0.38,8,0.33,null,null,null,null,9,0.5,9,0.01,9,0.02,0.01,{"$f":"'Assumptions and Results'!Q59","v":271.69754661482364},{"$f":"Y73","v":271.69754661482364},{"$f":"Z73-('Assumptions and Results'!Q56/2)","v":200.31305244791565},{"$f":"Z73-'Assumptions and Results'!Q56","v":128.9285582810077},{"$f":"Y73-AB73-( (Y73-AB73)/2)","v":71.38449416690797},{"$f":"'Assumptions and Results'!K50","v":64.956252612507242},null,null,{"$f":"'Assumptions and Results'!Q59","v":271.69754661482364},{"$f":"AG73-('Assumptions and Results'!N56*Model!O21)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,9,0.28000000000000003,9,0.39,0.32,0.39,9,0.32,null,null,null,null,10,0.55000000000000004,10,0,10,5.0000000000000001E-3,null,{"$f":"'Assumptions and Results'!P60","v":1139.2290416283709},{"$f":"Y74","v":1139.2290416283709},{"$f":"AA72+AA73","v":1158.6162146340066},{"$f":"AB72+AB73","v":1178.0033876396426},{"$f":"AC72+AC73","v":1193.6316657334673},{"$f":"AD72+AD73","v":1195.3774990911404},null,null,{"$f":"'Assumptions and Results'!S60","v":1139},{"$f":"ROUND((AH72+AH73),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,10,0.27,10,0.4,0.31,0.4,10,0.31]

{"sheet":"Assumptions and Results","index":3,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[[10,1,10,6],[10,8,10,16],[59,15,59,16],[13,9,13,11],[13,12,13,14],[13,15,13,16],[29,1,29,3],[29,5,29,6],[26,1,26,2],[38,1,38,5],[32,5,32,6],[47,15,47,16],[26,5,26,6],[23,5,23,6],[18,1,18,2],[18,5,18,6],[47,9,47,11],[47,12,47,14],[26,15,26,16],[44,15,44,16],[32,9,32,11],[32,12,32,14],[32,15,32,16]]}
[]
[]
[]
[null,null,"Privious Page ",null,null,null,null,null,null,null,null,null,"Next page "]
[]
[]
[]
[]
[]
[]
[null,"Assumptions (Inputs to model)",null,null,null,null,null,null,"Snap Shot"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal"]
[null,null,null,null,null,null,null,null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports"]
[null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,"Steel (+boilers)",22.3,43.7,{"$f":"J17+K17","v":66},0.4,0,{"$f":"M17+N17","v":0.4},{"$f":"J17+M17","v":22.7},{"$f":"K17+N17","v":43.7}]
[null,null,null,null,null,null,null,null,"Sponge Iron",null,null,null,14.7,9.1999999999999993,{"$f":"M18+N18","v":23.9},{"$f":"M18","v":14.7},{"$f":"N18","v":9.1999999999999993}]
[null,"Efficiency ",null,null,null,"GDP",null,null,"Cement",null,null,null,11.4,8.1,{"$f":"M19+N19","v":19.5},{"$f":"M19","v":11.4},{"$f":"N19","v":8.1}]
[null,"Old Plants","Efficiency ",null,null,"Assumed GDP Growth",{"$f":"Model!$B$15","v":7.4999999999999997E-2},null,"Fertilizer",null,null,null,2.2999999999999998,0,{"$f":"M20+N20","v":2.2999999999999998},{"$f":"M20","v":2.2999999999999998},0]
[null,"Sub-Critical",{"$f":"Model!C15","v":0.31},null,null,null,null,null,"Others",null,null,null,85.6,0,{"$f":"M21+N21","v":85.6},{"$f":"M21","v":85.6},0]
[null,"Super Critical",{"$f":"Model!D15","v":0.38},null,6]
[null,"New Plants",null,null,null,null,null,null,"Power (Utility)",null,null,null,418.5,125,{"$f":"M23+N23","v":543.5},{"$f":"M23","v":418.5},125]
[null,"Sub Critical",{"$f":"Model!E15","v":0.34},null,null,"Old  plant Replaced by New Super Critical ",null,null,"Power (Captive)",null,null,null,53.5,26.1,{"$f":"M24+N24","v":79.599999999999994},{"$f":"M24","v":53.5},26.1]
[null,"Super Critical",{"$f":"Model!F15","v":0.38500000000000001},null,null,"% of old plants replaced by New supercritical",{"$f":"Model!K15","v":0.05}]
[null,null,null,null,null,null,null,null,"2014-15",{"$f":"SUM(J17:J25)","v":22.3},43.7,66,586.4,168.4,754.80000000000007,{"$f":"SUM(P17:P24)","v":608.70000000000005},{"$f":"SUM(Q17:Q24)","v":212.1}]
[null,"PLF",null,null,null,"2020 Thermal Power share displacement by RE",null,null,null,null,null,null,null,null,null,{"$f":"P26+Q26","v":820.80000000000007},null,null,{"$f":"ROUND(P27,0)","v":821}]
[null,"PLF ",0.64459999999999995,null,null,"Displacement from Base share",{"$f":"Model!J17","v":5.0999999999999997E-2}]
[]
[null,"Type of Coal ",null,null,null,"Slippage"]
[null,"Old Plants","Type","GCV BOUND",null,"Slippage",{"$f":"Model!I15","v":0.25},null,"Thermal Power Plants Capacity Basis"]
[null,"Domestic Sub critical  ",{"$f":"Model!R21","v":"G11"},2,"Lower",null,null,null,2020]
[null,"Domestic Super Critical ",{"$f":"Model!R22","v":"G11"},2,"Lower","Number of Year to forecast",null,null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal"]
[null,"New Plants ",null,null,null,"No of Year",5,null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports"]
[null,"Domestic Sub critical  ",{"$f":"Model!T21","v":"G11"},{"$f":"D32","v":2},"Lower",null,null,null,"Steel (+boilers)",{"$f":"J17*(1+F41)^G34","v":33.147012202721079},{"$f":"K17*(1+F41)^G34","v":64.956252612507242},{"$f":"J35+K35","v":98.103264815228329},{"$f":"M17*(1+F41)^G34","v":0.59456524130441402},{"$f":"N17*(1+F41)^G34","v":0},{"$f":"M35+N35","v":0.59456524130441402},{"$f":"J35+M35","v":33.741577444025495},{"$f":"K35+N35","v":64.956252612507242}]
[null,"Domestic Super Critical ",{"$f":"Model!T22","v":"G11"},{"$f":"D33","v":2},"Lower",null,null,null,"Sponge Iron",null,null,null,{"$f":"M18*(1+$F$42)^G34","v":21.850272617937215},{"$f":"N18*(1+$F$42)^G34","v":13.675000550001521},{"$f":"M36+N36","v":35.525273167938735},{"$f":"M36","v":21.850272617937215},13.675000550001521]
[null,"Imports ",5500,"N/A",null,null,null,null,"Cement",null,null,null,{"$f":"M19*(1+$F$43)^5","v":19.867467458972634},{"$f":"N19*(1+$F$43)^G34","v":14.116358457691081},{"$f":"M37+N37","v":33.983825916663719},19.867467458972634,14.116358457691081]
[null,null,null,null,null,null,null,null,"Fertilizer",null,null,null,{"$f":"M20*(1+$F$44)^G34","v":3.0562026488402445},{"$f":"N20*(1+$F$44)^G34","v":0},{"$f":"M38+N38","v":3.0562026488402445},3.0562026488402445,0]
[null,"Elasticity ",null,null,null,null,null,null,"Others",null,null,null,{"$f":"M21*(1+$F$45)^G34","v":122.88987032031248},{"$f":"N21*(1+$F$45)^G34","v":0},{"$f":"M39+N39","v":122.88987032031248},122.88987032031248,0]
[null,"Segments","Elasticities","Ft. Growth Rates",null,"ElasticityxGDP"]
[null,"Steel (+boilers)",1.1000000000000001,null,null,{"$f":"C41*$G$20","v":8.2500000000000004E-2},null,null,"Power (Utility)",null,null,null,{"$f":"'Calculations '!I28","v":711.99500837816231},{"$f":"'Calculations '!L28","v":183.38692802628231},{"$f":"M41+N41","v":895.38193640444456},{"$f":"M41","v":711.99500837816231},{"$f":"N41","v":183.38692802628231}]
[null,"Sponge Iron",1.1000000000000001,null,null,{"$f":"C42*$G$20","v":8.2500000000000004E-2},null,null,"Power (Captive)",null,null,null,{"$f":"M24*(1+$F$48)^G34","v":74.164009438820713},{"$f":"N24*(1+$F$48)^G34","v":36.180946660807869},{"$f":"M42+N42","v":110.34495609962858},{"$f":"M42","v":74.164009438820713},{"$f":"N42","v":36.180946660807869}]
[null,"Cement","na",0.11749999999999999,null,{"$f":"D43","v":0.11749999999999999}]
[null,"Fertilizer",0.78,null,null,{"$f":"C44*$G$20","v":5.8499999999999996E-2},null,null,"Capacity 2020",{"$f":"SUM(J35:J43)","v":33.147012202721079},64.956252612507242,98.103264815228329,954.41739610435002,247.35923369478277,1201.7766297991329,{"$f":"SUM(P35:P42)","v":987.56440830707106},{"$f":"SUM(Q35:Q42)","v":312.31548630729003}]
[null,"Others",1,null,null,{"$f":"C45*$G$20","v":7.4999999999999997E-2},null,null,null,null,null,null,null,null,null,{"$f":"P44+Q44","v":1299.8798946143611},null,null,{"$f":"ROUND(P45,0)","v":1300}]
[null,null,null,null,null,null,null,null,"Electricity Demand basis"]
[null,"Power (Utility)",0.9,null,null,{"$f":"C47*$G$20","v":6.7500000000000004E-2},null,null,2020]
[null,"Power (Captive)",0.9,null,null,{"$f":"C48*$G$20","v":6.7500000000000004E-2},null,null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal"]
[null,null,null,null,null,null,null,null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports"]
[null,null,null,null,null,null,null,null,"Steel (+boilers)",{"$f":"J35","v":33.147012202721079},{"$f":"K35","v":64.956252612507242},{"$f":"J50+K50","v":98.103264815228329},{"$f":"M35","v":0.59456524130441402},0,{"$f":"M50+N50","v":0.59456524130441402},{"$f":"J50+M50","v":33.741577444025495},{"$f":"K50+N50","v":64.956252612507242}]
[null,null,null,null,null,null,null,null,"Sponge Iron",null,null,null,21.850272617937215,13.675000550001521,{"$f":"M51+N51","v":35.525273167938735},{"$f":"M51","v":21.850272617937215},13.675000550001521]
[null,null,null,null,null,null,null,null,"Cement",null,null,null,19.867467458972634,14.116358457691081,{"$f":"M52+N52","v":33.983825916663719},19.867467458972634,14.116358457691081]
[null,null,null,null,null,null,null,null,"Fertilizer",null,null,null,3.0562026488402445,0,{"$f":"M53+N53","v":3.0562026488402445},3.0562026488402445,0]
[null,null,null,null,null,null,null,null,"Others",null,null,null,122.88987032031248,0,{"$f":"M54+N54","v":122.88987032031248},122.88987032031248,0]
[]
[null,null,null,null,null,null,null,null,"Power (Utility)",null,null,null,{"$f":"O56-N56","v":591.96209508463835},{"$f":"'Calculations '!K44","v":142.76898833381594},{"$f":"'Calculations '!I46","v":734.73108341845432},{"$f":"M56","v":591.96209508463835},{"$f":"N56","v":142.76898833381594}]
[null,null,null,null,null,null,null,null,"Power (Captive)",null,null,null,{"$f":"M42","v":74.164009438820713},{"$f":"N42","v":36.180946660807869},{"$f":"M57+N57","v":110.34495609962858},{"$f":"M57","v":74.164009438820713},{"$f":"N57","v":36.180946660807869}]
[]
[null,null,null,null,null,null,null,null,"Demand 2020",{"$f":"SUM(J50:J58)","v":33.147012202721079},64.956252612507242,98.103264815228329,834.38448281082606,206.74129400231641,1041.1257768131425,{"$f":"SUM(P50:P57)","v":867.5314950135471},{"$f":"SUM(Q50:Q57)","v":271.69754661482364}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P59+Q59","v":1139.2290416283709},null,null,{"$f":"ROUND(P60,0)","v":1139}]

{"sheet":"Your Result","index":4,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":true,"merged":[[29,12,29,14],[29,15,29,17],[29,18,29,19],[41,18,41,19],[41,8,41,9],[8,11,8,19],[11,12,11,14],[11,15,11,17],[11,18,11,19],[23,18,23,19],[29,2,29,4],[29,5,29,7],[29,8,29,9],[8,1,8,9],[11,2,11,4],[11,5,11,7],[11,8,11,9],[23,8,23,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Snap Shot Base",null,null,null,null,null,null,null,null,null,"Snap Shot Your Assumption"]
[]
[null,"Capacity",null,null,null,null,null,null,null,null,null,"Capacity"]
[null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal",null,null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal"]
[null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports",null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports"]
[null,"Steel (+boilers)",33.997684543481462,66.623265226463673,100.62094976994513,0.6098239379996675,0,0.6098239379996675,34.607508481481126,66.623265226463673,null,"Steel (+boilers)",33.997684543481462,66.623265226463673,100.62094976994513,0.6098239379996675,0,0.6098239379996675,34.607508481481126,66.623265226463673]
[null,"Sponge Iron",null,null,null,22.411029721487779,14.02595057399235,36.436980295480126,22.411029721487779,14.02595057399235,null,"Sponge Iron",null,null,null,22.411029721487779,14.02595057399235,36.436980295480126,22.411029721487779,14.02595057399235]
[null,"Cement",null,null,null,19.867467458972634,14.116358457691081,33.983825916663719,19.867467458972634,14.116358457691081,null,"Cement",null,null,null,19.867467458972634,14.116358457691081,33.983825916663719,19.867467458972634,14.116358457691081]
[null,"Fertilizer",null,null,null,3.1129213360311652,0,3.1129213360311652,3.1129213360311652,0,null,"Fertilizer",null,null,null,3.1129213360311652,0,3.1129213360311652,3.1129213360311652,0]
[null,"Others",null,null,null,125.77448337408002,0,125.77448337408002,125.77448337408002,0,null,"Others",null,null,null,125.77448337408002,0,125.77448337408002,125.77448337408002,0]
[]
[null,"Power (Utility)",null,null,null,714.20133055751808,183.38692802628231,897.58825858380033,714.20133055751808,183.38692802628231,null,"Power (Utility)",null,null,null,714.20133055751808,183.38692802628231,897.58825858380033,714.20133055751808,183.38692802628231]
[null,"Power (Captive)",null,null,null,75.740419954573341,36.949999267558212,112.69041922213155,75.740419954573341,36.949999267558212,null,"Power (Captive)",null,null,null,75.740419954573341,36.949999267558212,112.69041922213155,75.740419954573341,36.949999267558212]
[]
[null,"Capacity 2020",33.997684543481462,66.623265226463673,100.62094976994513,961.71747634066264,248.47923632552394,1210.1967126661866,995.7151608841441,315.10250155198759,null,"Capacity 2020",33.997684543481462,66.623265226463673,100.62094976994513,961.71747634066264,248.47923632552394,1210.1967126661866,995.7151608841441,315.10250155198759]
[null,null,null,null,null,null,null,null,{"$f":"I23+J23","v":1310.8176624361317},null,null,null,null,null,null,null,null,null,{"$f":"S23+T23","v":1310.8176624361317},null,null,{"$f":"ROUND(S24,0)","v":1311}]
[]
[]
[]
[null,"Demand Basis ",null,null,null,null,null,null,null,null,null,"Demand Basis"]
[null,2020,null,null,null,null,null,null,null,null,null,2020]
[null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal",null,null,null,"Coking Coal",null,null,"Non Coking Coal",null,null,"Total Coal"]
[null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports",null,null,"Domestic ","Import","Total ","Domestic ","Import","Total ","Domestic","Imports"]
[null,"Steel (+boilers)",33.997684543481462,66.623265226463673,100.62094976994513,0.6098239379996675,0,0.6098239379996675,34.607508481481126,66.623265226463673,null,"Steel (+boilers)",33.997684543481462,66.623265226463673,100.62094976994513,0.6098239379996675,0,0.6098239379996675,34.607508481481126,66.623265226463673]
[null,"Sponge Iron",null,null,null,22.411029721487779,14.02595057399235,36.436980295480126,22.411029721487779,14.02595057399235,null,"Sponge Iron",null,null,null,22.411029721487779,14.02595057399235,36.436980295480126,22.411029721487779,14.02595057399235]
[null,"Cement",null,null,null,19.867467458972634,14.116358457691081,33.983825916663719,19.867467458972634,14.116358457691081,null,"Cement",null,null,null,19.867467458972634,14.116358457691081,33.983825916663719,19.867467458972634,14.116358457691081]
[null,"Fertilizer",null,null,null,3.1129213360311652,0,3.1129213360311652,3.1129213360311652,0,null,"Fertilizer",null,null,null,3.1129213360311652,0,3.1129213360311652,3.1129213360311652,0]
[null,"Others",null,null,null,125.77448337408002,0,125.77448337408002,125.77448337408002,0,null,"Others",null,null,null,125.77448337408002,0,125.77448337408002,125.77448337408002,0]
[]
[null,"Power (Utility)",null,null,null,647.71544777368911,167.28744409878095,815.00289187247006,647.71544777368911,167.28744409878095,null,"Power (Utility)",null,null,null,647.71544777368911,167.28744409878095,815.00289187247006,647.71544777368911,167.28744409878095]
[null,"Power (Captive)",null,null,null,75.740419954573341,36.949999267558212,112.69041922213155,75.740419954573341,36.949999267558212,null,"Power (Captive)",null,null,null,75.740419954573341,36.949999267558212,112.69041922213155,75.740419954573341,36.949999267558212]
[]
[null,"Demand 2020",33.997684543481462,66.623265226463673,100.62094976994513,895.23159355683367,232.37975239802259,1127.6113459548562,929.22927810031513,299.00301762448629,null,"Demand 2020",33.997684543481462,66.623265226463673,100.62094976994513,895.23159355683367,232.37975239802259,1127.6113459548562,929.22927810031513,299.00301762448629]
[null,null,null,null,null,null,null,null,{"$f":"I41+J41","v":1228.2322957248014},null,null,null,null,null,null,null,null,null,{"$f":"S41+T41","v":1228.2322957248014},null,null,{"$f":"ROUND(S42,0)","v":1228}]

{"sheet":"Sensitivity Analysis","index":5,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[11,1,11,7],[11,9,11,15],[32,1,32,6],[32,9,32,15],[32,17,32,20],[11,17,11,25]]}
[]
[]
[null,null,null,"Privious Page "]
[]
[]
[]
[null,"Sensitivities ( For all the variables) "]
[]
[null,"This sheet contains sensitivity analysis. The analysis is done by changing individual variables to see impact on Coal demand or CAGR or PLF"]
[null,"2020 Coal Demand "]
[]
[null,"Sensitivity Slippage (Capacity)",null,null,null,null,null,null,null,"Sensitivity Analysis Efficiency (Capacity)",null,null,null,null,null,null,null,"Sensitivity Analysis PLF (Capacity)"]
[null,"Slippage",0.5,0.4,0.3,0.25,0.2,0.1,null,"Efficiency values","35% & 40%","35% & 38%","33% & 40%","34% & 38.5%","33%&36%","31%&38%",null,null,0.45,0.5,0.55000000000000004,0.61,0.64459999999999995,0.7,0.75,0.8]
[null,"Capacity coming online",{"$f":"146.7*C13","v":73.349999999999994},{"$f":"146.7*(1-D13)","v":88.02},{"$f":"146.7*(1-E13)","v":102.68999999999998},{"$f":"146.7*(1-F13)","v":110.02499999999999},{"$f":"146.7*(1-G13)","v":117.36},{"$f":"146.7*(1-H13)","v":132.03},null,"Domestic",973.59251202503685,983.41401066966398,1004.2302618275196,995.73129181775698,1024.9645367439543,1048.6427683136594,null,"Domestic",780.09839315641773,835.50252950311324,890.90666584980886,957.39162946584372,995.68587415715979,1057.1190748898957,1112.5232112365914,1167.9273475832872]
[null,"Domestic",912.23,945.63,979.03,995.73,1012.43,1045.83,null,"Total",1282.8468407119151,1296.1024833039182,1320.2902444947738,1310.8305228545521,1348.2743788556704,1375.8206978093606,null,"Imports",259.7360659826312,273.96092853508821,288.18579108754619,305.25562615049517,315.0992310367954,330.86037874491819,345.08524129737617,359.31010384983318]
[null,"Imports",287.81,298.73,309.64,315.10000000000002,320.56,331.47,null,"CAGR (2020)",9.3421205555570541E-2,9.5671585327601782E-2,9.9730862966499911E-2,9.8150439021271074E-2,0.10435369041293607,0.10882982301717448,null,"Total",1039.8344591390489,1109.4634580382015,1179.0924569373551,1262.647255616339,1310.7851051939551,1387.979453634814,1457.6084525339675,1527.2374514331204]
[null,"CAGR",7.9000000000000001E-2,8.6999999999999994E-2,9.4E-2,9.8000000000000004E-2,0.10199999999999999,0.109,null,null,null,null,null,null,null,null,null,"CAGR",4.8444320748681768E-2,6.2123776471746384E-2,7.5132778211935314E-2,8.9955929321637651E-2,9.8142829171744106E-2,0.110782778608294,0.12171029560805224,0.13222787681265746]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sensitivity GDP (Demand)",null,null,null,null,null,null,null,"Sensitivity Analysis Efficiency (Demand)",null,null,null,null,null,null,null,"Renewables Share Impact on PLF (Demand)"]
[null,"GDP Rate ",0.06,7.0000000000000007E-2,7.4999999999999997E-2,0.08,8.5000000000000006E-2,null,null,"Efficiency values","35% & 40%","35% & 38%","33% & 40%","34% & 38.5%","33%&36%","31%&38%",null,"Renewables share increased additional over 2015 in 2020","Thermal share","Thermal BU","PLF"]
[null,"Total coal demand ",1135.9045476215224,1181.2422212381769,1204.5159762699275,1228.2032183049589,1252.300299747269,null,null,"Domestic",926.7442995854999,929.85937126936608,927.04632836576138,929.19683453151015,933.62259080947888,930.50240028540668,null,0.06,0.74366267643058526,1215.3800822920302,0.60592400000000002]
[null,"Domestic coal ",864.1344196654378,896.09853358496423,912.50404216927279,929.19002251224629,946.18068892171607,null,null,"Total",1220.4567709367761,1226.4718770938644,1227.2375581018587,1228.2001879824884,1239.9361155446011,1240.9083917033938,null,7.0000000000000007E-2,0.73575137136217483,1202.4505069484981,0.59947799999999996]
[null,"CAGR ",6.7263624484066309E-2,7.5650373354501532E-2,7.9856017965552306E-2,8.4070149885209222E-2,8.8290998118630615E-2,null,null,"CAGR (2020)",0.08,0.08,0.08,8.3942793506409874E-2,8.6006419489771169E-2,8.6176681022793078E-2,null,0.08,0.7278400662937643,1189.5209316049659,0.593032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,0.71992876122535387,1176.5913562614337,0.58658600000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.71201745615694345,1163.6617809179015,0.5801400000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,0.70410615108853292,1150.7322055743691,0.57369399999999993]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Import Sensitivity "]
[null,"Demand Basis"]
[null,null,"Scenario ","Case","Total coal (MT)","Domestic consumption (MT)","Total import (MT)","Non power imports (MT)","Power imports (MT)"]
[null,"Base Case","Imports grow but remain same % share** as in 2015, for non power sector.  Power sector Imports calculated separately","a",1228.2032183049589,929.19002251224629,299.01319579271257,131.71230301051312,167.30089278219947]
[null,null,"50% import substitution of power sector by domestic coal and non power sector remains as is","b",1250.921676915747,1035.5589275141342,215.36274940161286,131.71230301051312,83.650446391099734]
[null,null,"100% Import substitution of power sector by domestic coal","c",1273.6401355265352,1141.9278325160221,131.71230301051312,131.71230301051312,0]
[null,null,"50% import reduction for the non-power sector and 100% import substitution for power sector by domestic coal","d",1287.4983476890616,1206.8126417482733,80.685705940788324,80.685705940788324,0]
[null,null,"Only coking coal Imports ","e",1291.3175380355347,1224.694272809071,66.623265226463673,66.623265226463673,0]
[]
[]
[]
[]
[null,"Capacity Basis"]
[null,null,"Scenario ","Case","Total coal (MT)","Domestic consumption (MT)","Total import (MT)","Non power imports (MT)","Power imports (MT)"]
[null,"Base Case","Imports grow but remain same % share** as in 2015, for non power sector.  Power sector imports calculated separately","a",1310.7851051939551,995.68587415715979,315.0992310367954,131.71230301051312,183]
[null,null,"50% import substitution of power sector by domestic coal and non power sector remains as is","b",1335.6879509877822,1112.2821839641279,223.40576702365428,131.71230301051312,92]
[null,null,"100% Import substitution of power sector by domestic coal","c",1360.590796781609,1228.8784937710959,131.71230301051312,131.71230301051312,0]
[null,null,"50% import reduction for the non-power sector and 100% import substitution for power sector by domestic coal","d",1374.4490089441354,1293.7633030033471,80.685705940788324,80.685705940788324,0]
[null,null,"Only coking coal Imports ","e",1378.2681992906084,1311.6449340641448,66.623265226463673,66.623265226463673,0]

{"sheet":"Power Demand Projections","index":6,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Power Demand Projections",null,null,"Power Demand projection Y-o-Y "]
[]
["From 2015 to 2020",null,null,null,null,null,null,null,null,null,null,"Commentary and Sources"]
[null,null,{"$f":"'Assumptions and Results'!G20","v":7.4999999999999997E-2},"GDP from assumption sheet"]
[null,null,null,null,null,null,null,null,null,null,null,"2015 data for supply and shortfall from CEA"]
[null,null,null,"units",2015,2016,2017,2018,2019,2020]
[null,null,"Supply (Calculated = output)","BU",{"$f":"'Calculations '!D7","v":1110.21},{"$f":"E7+F11+F14+F17-F19","v":1194.0349100000001},{"$f":"F7+G11+G14+G17-G19","v":1288.214371155},{"$f":"G7+H11+H14+H17-H19","v":1366.7954477954552},{"$f":"H7+I11+I14+I17-I19","v":1457.6873450738528},{"$f":"I7+J11+J14+J17-J19","v":1555.3523971938009},null,"2015 is taken as given (gross)"]
[null,null,"GDP Growth",null,null,{"$f":"C4","v":7.4999999999999997E-2},{"$f":"F8","v":7.4999999999999997E-2},{"$f":"G8","v":7.4999999999999997E-2},{"$f":"H8","v":7.4999999999999997E-2},{"$f":"I8","v":7.4999999999999997E-2},null,"Assume constant (figures are growth into year given)"]
[null,null,"Demand Elasticity",null,null,{"$f":"F26","v":0.9},{"$f":"G26","v":0.9},{"$f":"H26","v":0.9},{"$f":"I26","v":0.9},{"$f":"J26","v":0.9},null,"Electricity to GDP elasticity may vary, but this is somewhat on the high side compared to historical and INDCs - assumes some growth of manufacturing"]
[null,null,"Organic growth",null,null,{"$f":"F9*F8","v":6.7500000000000004E-2},{"$f":"G9*G8","v":6.7500000000000004E-2},{"$f":"H9*H8","v":6.7500000000000004E-2},{"$f":"I9*I8","v":6.7500000000000004E-2},{"$f":"J9*J8","v":6.7500000000000004E-2},null,"Simple multiplication"]
[null,null,"Organic growth","BU",null,{"$f":"F10*E7","v":74.939175000000006},{"$f":"G10*F7","v":80.597356425000015},{"$f":"H10*G7","v":86.954470052962506},{"$f":"I10*H7","v":92.258692726193232},{"$f":"J10*I7","v":98.393895792485068}]
[null,null,"Latent Demand (shortfall) [start of year]",null,3.5999999999999997E-2,0.03,2.5000000000000001E-2,{"$f":"Model!L20","v":0.03},{"$f":"Model!M20","v":0.03},{"$f":"Model!N20","v":0.03},null,"Load-shedding aka shortfall TOTAL in units (not peak shortfall) - per official numbers for start of year"]
[null,null,"Additional demand from meeting shortfall",null,null,{"$f":"E12-F12","v":5.9999999999999984E-3},{"$f":"F12-G12","v":4.9999999999999975E-3},{"$f":"G12-H12","v":-4.9999999999999975E-3},{"$f":"H12-I12","v":0},0]
[null,null,"Additional demand from meeting shortfall","BU",null,{"$f":"F13*E7","v":6.6612599999999986},{"$f":"G13*F7","v":5.9701745499999976},{"$f":"H13*G7","v":-6.4410718557749966},{"$f":"I13*H7","v":0},{"$f":"J13*I7","v":0}]
[null,null,"Unelectrified HouseHolds","million",60,50,30,{"$f":"Model!O20","v":30},{"$f":"Model!P20","v":30},{"$f":"Model!Q20","v":30},null,"Start of year numbers"]
[null,null,"Per HH consumption of new HH","units/yr",500,500,500,500,500,500,null,"about 40 units/month"]
[null,null,"New HH non-organic demand","BU",null,{"$f":"(E15-F15)*1000000*F16/1000000000","v":5},{"$f":"(F15-G15)*1000000*G16/1000000000","v":10},{"$f":"(G15-H15)*1000000*H16/1000000000","v":0},{"$f":"(H15-I15)*1000000*I16/1000000000","v":0},{"$f":"(I15-J15)*1000000*J16/1000000000","v":0}]
[null,null,"Technical Loss reduction","% of supply",null,2.5000000000000001E-3,2E-3,1.5E-3,1E-3,5.0000000000000001E-4,null,"Theft reduction and collection don't reduce the demand! (start of year)"]
[null,null,"Avoided generation from loss reduction","BU",null,{"$f":"F18*E7","v":2.775525},{"$f":"G18*F7","v":2.3880698200000001},{"$f":"H18*G7","v":1.9323215567325001},{"$f":"I18*H7","v":1.3667954477954551},{"$f":"J18*I7","v":0.72884367253692639}]
[null,null,"Coal-based generation","BU",{"$f":"E7*E27","v":878.28713100000004},{"$f":"F7*F31","v":1178.6396931095944},{"$f":"G7*G31","v":1254.9953430023493},{"$f":"H7*H31","v":1313.9273644905115},{"$f":"I7*I31","v":1382.5089306142231},{"$f":"J7*J31","v":1455.0831869082695}]
[null,null,"5 year CAGR","BU",null,null,null,null,null,{"$f":"(J20/E20)^(1/5)-1","v":0.10624229958810938},null,"This is higher than historical due to meeting latent damend"]
[null,null,"coal demand CAGR","coal-based BU"]
[]
[null,null,null,null,null,2016,2017,2018,2019,2020]
[null,null,"GDP growth",null,{"$f":"C4","v":7.4999999999999997E-2},{"$f":"E25","v":7.4999999999999997E-2},{"$f":"F25","v":7.4999999999999997E-2},7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2]
[null,null,"Elasticity of total power",null,0.9,{"$f":"E26","v":0.9},0.9,0.9,0.9,0.9]
[null,null,"Base share of coal",null,0.79110000000000003,{"$f":"E27*F31","v":0.78090000000000004},{"$f":"F27*G31","v":0.76076302616609792},{"$f":"G27*H31","v":0.73133646997764823},{"$f":"H27*I31","v":0.69361869981573698},{"$f":"I27*J31","v":0.64890304605438875}]
[null,null,"2020 total displacement of coal from base share (absolute) due to RE and peakers and other",null,{"$f":"'Assumptions and Results'!G28","v":5.0999999999999997E-2}]
[null,null,"annual reduction","absolute",{"$f":"E28/5","v":1.0199999999999999E-2}]
[null,null,"Absolute reduction from base by year",null,0,{"$f":"$E$29*(F24-2015)","v":1.0199999999999999E-2},{"$f":"$E$29*(G24-2015)","v":2.0399999999999998E-2},{"$f":"$E$29*(H24-2015)","v":3.0599999999999995E-2},{"$f":"$E$29*(I24-2015)","v":4.0799999999999996E-2},{"$f":"$E$29*(J24-2015)","v":5.0999999999999997E-2}]
[null,null,"Normalized to 2015","Coal requirement per electricity",1,{"$f":"($E27-F30)/$E27","v":0.98710656048540013},{"$f":"($E27-G30)/$E27","v":0.97421312097080015},{"$f":"($E27-H30)/$E27","v":0.96131968145620028},{"$f":"($E27-I30)/$E27","v":0.94842624194160041},{"$f":"($E27-J30)/$E27","v":0.93553280242700032}]

{"sheet":"Calculations ","index":7,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":true,"merged":[[12,9,12,11],[16,9,16,11],[40,9,40,10],[32,1,32,2],[51,7,51,10],[51,11,51,14],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14]]}
["Calculations",null,null,null,null,null,"This sheet contains calculation for the thermal coal based on capacity and demand "]
[]
[null,"Constants "]
[null,"Conversion-->","KW","MJ/hr"]
[null,null,1,3.6,null,null,null,null,null,null,null,null,"https://www.unitjuggler.com/convert-energy-from-kWh-to-MJ.html"]
[null,"Hours in one year",null,{"$f":"24*365","v":8760}]
[null,"Total BU Power supply ",null,1110.21,null,null,null,null,null,null,null,null,"CEA Report March'13"]
[null,"Total Thermal (BU)",null,878.3,null,null,null,null,null,null,null,null,"CEA Report March'14"]
[null,"Capacity Commissioned Mar'15 (GW)",null,164.6,null,null,null,null,null,null,null,null,"CEA Report March'15"]
[null,"Capacity Commissioned between March 15 and September 15 (GW)",null,5,null,null,null,null,null,null,null,null,"CEA Report September'15"]
[null,"Calculations ",null,null,null,"Capacity Side"]
[null,"Old Plants","Efficiency ","MJ/KWH"]
[null,"Sub-Critical",{"$f":"'Assumptions and Results'!C21","v":0.31},{"$f":"$D$5/C13","v":11.612903225806452},null,null,null,2015,2020,"Present plant "]
[null,"Super Critical",{"$f":"'Assumptions and Results'!C22","v":0.38},{"$f":"$D$5/C14","v":9.473684210526315},null,null,"Electricity Capacity (GW)",{"$f":"D9","v":164.6},{"$f":"'Plants Breakdown'!G90+'Calculations '!D10","v":115.18775000000001},null,"sub (GW)","sup (GW)"]
[null,"New Plants",null,null,null,null,"Of which",null,{"$f":"K16+L16+K20+L20","v":71.075625000000002},"Domestic",{"$f":"'Plants Breakdown'!C83*(1-'Assumptions and Results'!G25)","v":103.6058125},{"$f":"'Plants Breakdown'!D83","v":16.835000000000001}]
[null,"Sub Critical",{"$f":"'Assumptions and Results'!C24","v":0.34},{"$f":"$D$5/C16","v":10.588235294117647},null,null,"Subcritical",{"$f":"K15+K16","v":132.30206250000001},{"$f":"K19+K20","v":50.273000000000003},"Imported ",{"$f":"'Plants Breakdown'!E83","v":28.696249999999999},{"$f":"'Plants Breakdown'!F83","v":9.9849999999999994}]
[null,"Super Critical",{"$f":"'Assumptions and Results'!C25","v":0.38500000000000001},{"$f":"$D$5/C17","v":9.3506493506493502},null,null,"Supercritical",{"$f":"L15+L16","v":26.82},{"$f":"L19+L20","v":70.408937499999993},"Future Plant "]
[null,null,null,null,null,null,"PLF (from assumptions)",{"$f":"C31","v":0.64459999999999995},{"$f":"C31","v":0.64459999999999995},null,"sub (GW)","sup (GW)"]
[null,"Type of Coal ",null,null,null,null,"Equivalent Capacity",{"$f":"H14*H18","v":106.10115999999999},{"$f":"I18*I14","v":74.250023650000003},"Domestic",{"$f":"'Plants Breakdown'!C90+D10","v":36.257187500000001},{"$f":"'Plants Breakdown'!D90+(109.1-K15)","v":52.030374999999992}]
[null,"Old Plants","Type/GCV","Specific Coal Consumption(kg/KWH)",null,null,null,null,null,"Imported ",{"$f":"'Plants Breakdown'!E90","v":14.015812500000003},{"$f":"'Plants Breakdown'!F90","v":18.378562499999997}]
[null,"Domestic Sub critical  ",{"$f":"'Assumptions and Results'!C32","v":"G11"},{"$f":"'Coal Quality'!C10","v":0.64547685678589828},null,null,"Coal required (KG/hr)","Coal Consumption of  present plant in 2020"]
[null,"Domestic Super Critical ",{"$f":"'Assumptions and Results'!C33","v":"G11"},{"$f":"'Coal Quality'!D10","v":0.52657322527270645},null,null,"Total Coal required (MT)",{"$f":"(D26*$C$31*(K15)*$D$6/1000)+(D27*$C$31*L15*$D$6/1000)+(D28*$C$31*K16*$D$6/1000)+(D29*$C$31*L16*$D$6/1000)","v":491.17832090915135},{"$f":"(D26*$C$31*(K19+5)*$D$6/1000)+(D27*$C$31*L19*$D$6/1000)+(D28*$C$31*K20*$D$6/1000)+(D29*$C$31*L20*$D$6/1000)","v":368.38833803911535}]
[null,"Imported Coal Sub",{"$f":"'Assumptions and Results'!C37","v":5500},{"$f":"'Coal Quality'!K16","v":0.50464554257806582},null,null,"Coal after Leakage (MT)",{"$f":"H22/(1-H24)","v":511.64408428036603},{"$f":"I22/(1-I24)","v":383.73785212407853},null,"Import breakdown 2020","MT"]
[null,"Imported Coal Super",{"$f":"'Assumptions and Results'!C37","v":5500},{"$f":"'Coal Quality'!N16","v":0.41168452157684315},null,null,"Loss/leakage",0.04,0.04,null,"2014-15 Capacity import in future",{"$f":"((D28*$C$31*K16*$D$6/1000)+(D29*$C$31*L16*$D$6/1000))","v":97.467312642070524}]
[null,"New Plants ",null,null,null,null,null,null,null,"CAGR","Coal considering leakage",{"$f":"L24/(1-I24)","v":101.52845066882347}]
[null,"Domestic Sub critical  ",{"$f":"'Assumptions and Results'!C35","v":"G11"},{"$f":"'Coal Quality'!E10","v":0.58852301648126015},null,null,"Total Coal required(MT)",{"$f":"H23","v":511.64408428036603},{"$f":"I23+H23","v":895.38193640444456},{"$f":"((I26/H26) ^(1/5))-1","v":0.11842811109614049},"Projected plant import",{"$f":"(D28*$C$31*K20*$D$6/1000)+(D29*$C$31*L20*$D$6/1000)","v":78.584138263160469}]
[null,"Domestic Super Critical ",{"$f":"'Assumptions and Results'!C36","v":"G11"},{"$f":"'Coal Quality'!F10","v":0.5197346119574765},null,null,null,null,null,null,"Coal considering leakage",{"$f":"L26/(1-I24)","v":81.858477357458824}]
[null,"Imported Coal Sub",{"$f":"'Assumptions and Results'!C37","v":5500},{"$f":"'Coal Quality'!K42","v":0.4601179947035306},null,null,null,"Domestic Coal",{"$f":"I26-L28","v":711.99500837816231},{"$f":"L28/I26","v":0.20481419221243516},"Total Import",{"$f":"L27+L25","v":183.38692802628231}]
[null,"Imported Coal Super",{"$f":"'Assumptions and Results'!C37","v":5500},{"$f":"'Coal Quality'!N42","v":0.40633796934857247}]
[]
[null,"PLF ",{"$f":"'Assumptions and Results'!C28","v":0.64459999999999995},null,null,"Demand Side"]
[null,"Thermal Share ",{"$f":"(D8/D7)-'Assumptions and Results'!G28","v":0.74011159150070693},null,null,null,"BU Produced by Expected future capacity 2020",null,{"$f":"M60","v":681.45421375349974},"Look Detailed Calculation Below"]
[null,"Split, of capacity running on ( March'15)"]
[null,"Domestic coal (GW)","Imported coal (GW)",null,null,null,null,2015,2020,{"$f":"O60/M60","v":0.26842770070707567},"Percentage Share of future imported of total future"]
[null,115.53,49.1,null,null,null,"Electricity Generation (BU)",{"$f":"D7","v":1110.21},{"$f":"'Power Demand Projections'!J7","v":1555.3523971938009},{"$f":"(I36-H36)/I32","v":0.40037075496056024},"% Difference Demand and supply in 2020"]
[null,null,null,null,null,null,"Of which Thermal (BU)",{"$f":"D8","v":878.3},{"$f":"I35*I37","v":1151.1343380315436},{"$f":"'Assumptions and Results'!G28","v":5.0999999999999997E-2},"% of old plants closing replaced by new super critical plants"]
[null,null,null,null,null,null,"Ratio",{"$f":"C32","v":0.74011159150070693},{"$f":"H37","v":0.74011159150070693}]
[]
[null,null,null,null,null,null,"PLF (from assumptions)",{"$f":"'Assumptions and Results'!C28","v":0.64459999999999995},{"$f":"H39","v":0.64459999999999995}]
[null,null,null,null,null,null,"Equivalent Capacity (GW)",{"$f":"(H36*1000)/($D$6*H39)","v":155.54228525849453}]
[]
[null,null,null,null,null,null,"Coal required (MT)",{"$f":"(D21*$H$39*B35*$D$6/1000)+(D23*$H$39*(C35-6)*$D$6/1000)+(D24*$H$39*6*$D$6/1000)","v":557.84992306232948}]
[null,null,null,null,null,null,"Coal after Leakage (MT)",{"$f":"H42/(1-H44)","v":581.09366985659324},{"$f":"I23*J35","v":153.63741356186114}]
[null,null,null,null,null,null,"Loss/leakage",0.04,0.04,"Total Imported",{"$f":"L25+(I43*J34)","v":142.76898833381594}]
[null,null,null,null,null,null,null,null,null,"CAGR"]
[null,null,null,null,null,null,"Total Coal required(MT)",{"$f":"H43","v":581.09366985659324},{"$f":"H43+I43","v":734.73108341845432},{"$f":"((I46/H46) ^(1/5))-1","v":4.8036610261944279E-2}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"D6","v":8760}]
[null,null,null,null,null,null,null,"Old",null,null,null,"New"]
[null,null,null,null,null,null,null,"Domestic (MT)",null,"Imported",null,"Domestic (MT)",null,"Imported future (MT)"]
[null,null,null,null,null,null,{"$f":"'Assumptions and Results'!C28","v":0.64459999999999995}]
[null,null,null,null,null,null,null,"Subcritical ","Supercritical ","Subcritical ","Supercritical ","Subcritical ","Supercritical ","Subcritical ","Supercritical "]
[null,null,null,null,null,null,"Capacity",{"$f":"K15","v":103.6058125},{"$f":"L15","v":16.835000000000001},{"$f":"K16","v":28.696249999999999},{"$f":"L16","v":9.9849999999999994},{"$f":"K19","v":36.257187500000001},{"$f":"L19","v":52.030374999999992},{"$f":"K20","v":14.015812500000003},{"$f":"L20","v":18.378562499999997}]
[null,null,null,null,null,null,"PLF",{"$f":"$G$54","v":0.64459999999999995},0.64459999999999995,0.64459999999999995,0.64459999999999995,0.64459999999999995,0.64459999999999995,0.64459999999999995,0.64459999999999995]
[null,null,null,null,null,null,"Unit generation ",{"$f":"H56*H57*$I$51","v":585030.52702049993},95062.127160000004,162039.00008999999,56382.259559999991,204733.31562749998,293799.71039099991,79143.032380500008,103778.15535449998]
[null,null,null,null,null,null,"total Unit generation ",{"$f":"SUM(H58:O58)","v":1579968.1275840001},null,null,null,"Future",{"$f":"SUM(L58:O58)","v":681454.21375349979},"Imported future",{"$f":"N58+O58","v":182921.18773499998}]
[null,null,null,null,null,null,"total Unit generation (BU)",{"$f":"H59/10^3","v":1579.9681275840001},null,null,null," total future Unit generation (BU)",{"$f":"M59/10^3","v":681.45421375349974},"Total Unit from imported (BU)",{"$f":"O59/10^3","v":182.92118773499999}]

{"sheet":"Plants Breakdown","index":8,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":true,"merged":[[85,2,85,3],[85,4,85,5],[37,1,37,3],[78,2,78,3],[78,4,78,5]]}
[null,"Plants Breakdown"]
[null,"Analysis of plants( Present and Projected for future)  based on their location ( Coastal and non-coastal) and type ( Subcritical and supercritical) ",null,null,null,null,null,null,null,null,null,"Source/ Discriptions "]
[]
[null,"Present Plants "]
[null,null,"Subcritical (within 40 Km)","Super critical  (within 40 KM)","Subcritical (Between 40km and 100 km)","Super critical   (Between 40km and 100 km)","Subcritical (Between 100km and 500 km)","Super critical   (Between 100km and 500 km)","Subcritical (Over  500 km)","Super critical   (Over 500 km)"]
[null,"Andhra Pradesh",2.9,0,0.52500000000000002,0,3.31,2.2599999999999998,0,0,null,"Source: http://www.cea.nic.in/reports/quarterly/tpmii_quarterly_review/2016/tpmii_qr-01.pdf Page 7-8"]
[null,"Gujarat",1.2,7.3,0.5,0,4.59,0,0,0,null,"Plants distance from coast is based on Google map or shortest possible distance"]
[null,"Maharashtra",1.4,0,0,0,1.92,0,11.47,3.96]
[null,"Odisha",0,0,0,0,11.484999999999999,0,0,0]
[null,"Tamil Nadu",6.13,0,3.24,0,0.84,0,0,0]
[null,"West Bengal",0,0,2.0099999999999998,0,11.255000000000001,0,0,0]
[null,"Karnataka ",1.2,0,0,0,3.08,0,0,0]
[null,"Total",{"$f":"SUM(C6:C12)","v":12.829999999999998},{"$f":"SUM(D6:D12)","v":7.3},6.2750000000000004,0,36.479999999999997,2.2599999999999998,11.47,3.96]
[null,"Non- Costal "]
[null,"Super critical ",13.305]
[null,"Subcritical ",70.72]
[]
[null,"Projected Plants "]
[null,"State ","Subcritical (within 40 Km) (GW)","Super critical  (within 40 KM) (GW)","Subcritical (Between 40km and 100 km) (GW)","Super critical   (Between 40km and 100 km)(GW)","Subcritical (Between 100km and 500 km)(GW)","Super critical   (Between 100km and 500 km)(GW)","Subcritical (Over  500 km) (GW)","Super critical   (Over 500 km) (GW)"]
[null,"Andhra Pradesh",2.99,7.54,null,1.6,1.702,0.8,null,null,null,"Brookings Research on power capacities expected by 2020 (IndiaInframonitor database)"]
[null,"Gujarat",1.9610000000000001,2.78,0.03,null,0.1,null,null,null,null,"Plants distance from coast is based on Google map or shortest possible distance"]
[null,"Maharashtra",5.5E-2,2.52,0.38800000000000001,null,3.31,1.32,4.6550000000000002,3.3]
[null,"Odisha",0.06,5.8929999999999998,null,1.32,4.6849999999999996,3.96]
[null,"Tamil Nadu",4.7229999999999999,null,2.9249999999999998,0.6]
[null,"West Bengal",0.6,null,0.45,null,1.63,1.82]
[null,"Karnataka ",1.2,null,null,null,0.5,0.7,null,4]
[null,"Total ",{"$f":"SUM(C20:C26)","v":11.588999999999999},18.733000000000001,3.7930000000000001,3.52,11.927,8.6,4.6550000000000002,7.3]
[null,"Projected plants After Applying 25% Slippage",null,null,null,null,null,null,null,null,null,"Slippage is applied based on our Analysis Power capacity projection "]
[null,null,"Subcritical (within 40 Km) (GW)","Super critical  (within 40 KM) (GW)","Subcritical (Between 40km and 100 km) (GW)","Super critical   (Between 40km and 100 km)(GW)","Subcritical (Between 100km and 500 km)(GW)","Super critical   (Between 100km and 500 km)(GW)","Subcritical (Over  500 km) (GW)","Super critical   (Over 500 km) (GW)"]
[null,"Andhra Pradesh",{"$f":"C20*$G$74","v":2.2425000000000002},5.6550000000000002,0,1.2000000000000002,1.2765,0.60000000000000009,0,0]
[null,"Gujarat",1.47075,2.085,2.2499999999999999E-2,0,7.5000000000000011E-2,0,0,0]
[null,"Maharashtra",4.1250000000000002E-2,1.8900000000000001,0.29100000000000004,0,2.4824999999999999,0.99,3.49125,2.4749999999999996]
[null,"Odisha",4.4999999999999998E-2,4.4197499999999996,0,0.99,3.5137499999999999,2.9699999999999998,0,0]
[null,"Tamil Nadu",{"$f":"C24*$G$74","v":3.5422500000000001},null,{"$f":"E24*$G$74","v":2.1937499999999996},0.44999999999999996,0,0,0,0]
[null,"West Bengal",{"$f":"C25*$G$74","v":0.44999999999999996},null,0.33750000000000002,0,1.2224999999999999,1.365,0,0]
[null,"Karnataka ",{"$f":"C26*$G$74","v":0.89999999999999991},{"$f":"D26*$G$74","v":0},0,0,0.375,0.52499999999999991,0,3]
[null,"Total",{"$f":"SUM(C30:C36)","v":8.6917500000000008},14.04975,2.8447499999999994,2.6400000000000006,8.9452499999999997,6.4499999999999993,3.49125,5.4749999999999996]
[null,"Percentage imports (Import Analysis sheet)"]
[null,null,"Subcritical (within 40 Km) (GW)","Super critical  (within 40 KM) (GW)","Subcritical (Between 40km and 100 km) (GW)","Super critical   (Between 40km and 100 km)(GW)","Subcritical (Between 100km and 500 km)(GW)","Super critical   (Between 100km and 500 km)(GW)","Subcritical (Over  500 km) (GW)","Super critical   (Over 500 km) (GW)",null,"Data From Import Analysis"]
[null,"Andhra Pradesh",{"$f":"'Import analysis'!C57","v":1},{"$f":"'Import analysis'!D57","v":1},{"$f":"'Import analysis'!E57","v":1},{"$f":"'Import analysis'!F57","v":1},{"$f":"'Import analysis'!G57","v":0.5},{"$f":"'Import analysis'!H57","v":0.75},{"$f":"'Import analysis'!I57","v":0},{"$f":"'Import analysis'!J57","v":0}]
[null,"Gujarat",{"$f":"'Import analysis'!C58","v":1},{"$f":"'Import analysis'!D58","v":1},{"$f":"'Import analysis'!E58","v":1},{"$f":"'Import analysis'!F58","v":1},{"$f":"'Import analysis'!G58","v":0.75},{"$f":"'Import analysis'!H58","v":1},{"$f":"'Import analysis'!I58","v":0},{"$f":"'Import analysis'!J58","v":0}]
[null,"Maharashtra",{"$f":"'Import analysis'!C59","v":1},{"$f":"'Import analysis'!D59","v":1},{"$f":"'Import analysis'!E59","v":0.5},{"$f":"'Import analysis'!F59","v":0.75},{"$f":"'Import analysis'!G59","v":0.5},{"$f":"'Import analysis'!H59","v":0.75},{"$f":"'Import analysis'!I59","v":0},{"$f":"'Import analysis'!J59","v":0.25}]
[null,"Odisha",{"$f":"'Import analysis'!C60","v":0.75},{"$f":"'Import analysis'!D60","v":0.75},{"$f":"'Import analysis'!E60","v":0.5},{"$f":"'Import analysis'!F60","v":0.5},{"$f":"'Import analysis'!G60","v":0.25},{"$f":"'Import analysis'!H60","v":0.25},{"$f":"'Import analysis'!I60","v":0},{"$f":"'Import analysis'!J60","v":0.25}]
[null,"Tamil Nadu",{"$f":"'Import analysis'!C61","v":1},{"$f":"'Import analysis'!D61","v":1},{"$f":"'Import analysis'!E61","v":1},{"$f":"'Import analysis'!F61","v":1},{"$f":"'Import analysis'!G61","v":0.75},{"$f":"'Import analysis'!H61","v":0.75},{"$f":"'Import analysis'!I61","v":0},{"$f":"'Import analysis'!J61","v":0}]
[null,"West Bengal",{"$f":"'Import analysis'!C62","v":0.75},{"$f":"'Import analysis'!D62","v":0.75},{"$f":"'Import analysis'!E62","v":0.25},{"$f":"'Import analysis'!F62","v":0.25},{"$f":"'Import analysis'!G62","v":0},{"$f":"'Import analysis'!H62","v":0.25},{"$f":"'Import analysis'!I62","v":0},{"$f":"'Import analysis'!J62","v":0}]
[null,"Karnataka ",{"$f":"'Import analysis'!C63","v":1},{"$f":"'Import analysis'!D63","v":1},{"$f":"'Import analysis'!E63","v":0},{"$f":"'Import analysis'!F63","v":0},{"$f":"'Import analysis'!G63","v":0.5},{"$f":"'Import analysis'!H63","v":0.75},{"$f":"'Import analysis'!I63","v":0},{"$f":"'Import analysis'!J63","v":0}]
[]
[null,"Import Based capacity Present"]
[null,null,"Subcritical (within 40 Km)","Super critical  (within 40 KM)","Subcritical (Between 40km and 100 km)","Super critical   (Between 40km and 100 km)","Subcritical (Between 100km and 500 km)","Super critical   (Between 100km and 500 km)","Subcritical (Over  500 km)","Super critical   (Over 500 km)"]
[null,"Andhra Pradesh",{"$f":"C6*C40","v":2.9},0,0.52500000000000002,0,1.655,1.6949999999999998,0,0]
[null,"Gujarat",1.2,7.3,0.5,0,3.4424999999999999,0,0,0]
[null,"Maharashtra",1.4,0,0,0,0.96,0,0,0.99]
[null,"Odisha",0,0,0,0,2.8712499999999999,0,0,0]
[null,"Tamil Nadu",6.13,0,3.24,0,0.63,0,0,0]
[null,"West Bengal",0,0,0.50249999999999995,0,0,0,0,0]
[null,"Karnataka ",1.2,0,0,0,1.54,0,0,0]
[null,"Total",{"$f":"SUM(C50:C56)","v":12.829999999999998},{"$f":"SUM(D50:D56)","v":7.3},4.7675000000000001,0,11.098750000000003,1.6949999999999998,0,0.99]
[]
[null,"Import Based capacity Projected"]
[null,null,"Subcritical (within 40 Km)","Super critical  (within 40 KM)","Subcritical (Between 40km and 100 km)","Super critical   (Between 40km and 100 km)","Subcritical (Between 100km and 500 km)","Super critical   (Between 100km and 500 km)","Subcritical (Over  500 km)","Super critical   (Over 500 km)"]
[null,"Andhra Pradesh",{"$f":"C30*C40","v":2.2425000000000002},5.6550000000000002,0,1.2000000000000002,0.63824999999999998,0.45000000000000007,0,0]
[null,"Gujarat",1.47075,2.085,2.2499999999999999E-2,0,5.6250000000000008E-2,0,0,0]
[null,"Maharashtra",4.1250000000000002E-2,1.8900000000000001,0.14550000000000002,0,1.24125,0.74249999999999994,0,0.61874999999999991]
[null,"Odisha",3.3750000000000002E-2,3.3148124999999995,0,0.495,0.87843749999999998,0.74249999999999994,0,0]
[null,"Tamil Nadu",3.5422500000000001,0,2.1937499999999996,0.44999999999999996,0,0,0,0]
[null,"West Bengal",0.33749999999999997,0,8.4375000000000006E-2,0,0,0.34125,0,0]
[null,"Karnataka ",0.89999999999999991,0,0,0,0.1875,0.39374999999999993,0,0]
[null,"Total",{"$f":"SUM(C61:C67)","v":8.5680000000000014},12.944812500000001,2.4461249999999999,2.1450000000000005,3.0016875000000001,2.6699999999999995,0,0.61874999999999991]
[]
[null,"Total GW","Present","Projected ","Non-Coastal ","Present","Projected","Projected (After slippage)"]
[null,"Total Coastal Capacity",null,null,"Supercritical",13.3,28.400000000000002,{"$f":"G71*$G$74","v":21.3}]
[null,"Supercritical",{"$f":"D13+F13+H13+J13","v":13.52},{"$f":"D37+F37+H37+J37","v":28.614750000000001},"Subcritical",70.7,48.4,{"$f":"G72*$G$74","v":36.299999999999997}]
[null,"Subcritical",{"$f":"C13+E13+G13+I13","v":67.054999999999993},{"$f":"C37+E37+G37+I37","v":23.972999999999999}]
[null,"Imports only Coastal Capacity ",null,null,null,"1- Slippage ",{"$f":"1-'Assumptions and Results'!G31","v":0.75}]
[null,"Supercritical",{"$f":"D57+F57+H57+J57","v":9.9849999999999994},{"$f":"D68+F68+H68+J68","v":18.378562499999997}]
[null,"Subcritical",{"$f":"C57+E57+G57+I57","v":28.696249999999999},{"$f":"C68+E68+G68+I68","v":14.015812500000003}]
[]
[null,"Remaining Capacity Calculation "]
[null,"Present","Domestic",null,"Imports",null,"Total"]
[null,null,"Sub","Super","Sub","Super"]
[null,"Coastal",{"$f":"C73-C76","v":38.358749999999993},{"$f":"C72-C75","v":3.5350000000000001},{"$f":"C76","v":28.696249999999999},{"$f":"C75","v":9.9849999999999994},{"$f":"SUM(C81:F81)","v":80.575000000000003}]
[null,"Non Coastal",{"$f":"F72","v":70.7},{"$f":"F71","v":13.3},0,0,{"$f":"SUM(C82:F82)","v":84}]
[null,"Grand Total",{"$f":"C81+C82","v":109.05875},{"$f":"D81+D82","v":16.835000000000001},{"$f":"E81+E82","v":28.696249999999999},{"$f":"F81+F82","v":9.9849999999999994},{"$f":"SUM(C83:F83)","v":164.57499999999999}]
[]
[null,"Remaining Capacity Calculation "]
[null,"Projected ","Domestic",null,"Imports",null,"Total"]
[null,null,"Sub","Super","Sub","Super"]
[null,"Coastal",{"$f":"D73-D76","v":9.9571874999999963},{"$f":"D72-D75","v":10.236187500000003},{"$f":"D76","v":14.015812500000003},{"$f":"D75","v":18.378562499999997},{"$f":"SUM(C88:F88)","v":52.58775}]
[null,"Non Coastal",{"$f":"H71","v":21.3},{"$f":"H72","v":36.299999999999997},0,0,{"$f":"SUM(C89:F89)","v":57.599999999999994}]
[null,"Grand Total",{"$f":"C88+C89","v":31.257187499999997},{"$f":"D88+D89","v":46.536187499999997},{"$f":"E88+E89","v":14.015812500000003},{"$f":"F88+F89","v":18.378562499999997},{"$f":"SUM(C90:F90)","v":110.18775000000001}]

{"sheet":"Import analysis","index":9,"n_rows":63,"n_cols":49,"rows_kept":63,"cut":false,"hidden":true,"merged":[[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9]]}
[]
[null,"Import Analysis "]
[null,null,"This sheet contains weightage mechanism to identify what share of the plants in coastal states can probably import coal "]
[null,null,null,null,"Mudra ",null,"Dahej ",null,"Krishnapatnam port",null,"Visakhapatnam port",null,"Paradeep",null,"Gangavaram port",null,"New manglore",null,"Dhamra port",null,"Kamarajar (Ennore) port",null,"Mumbai port",null,"Tuticorin (VOC) port",null,"Haldia Dock System",null,"Hazira port",null,"Goplapur ",null,"Meghavaram port",null,"Sikka Port",null,"Jafrabad Port",null,"Dharamtar port",null,"Jaigarh port",null,"Dabhol port",null,"Nagapattinam port",null,"Cuddalore port"]
[null,null,null,null,0.13561340920482357,null,8.396969071557038E-2,null,5.8802370492673298E-2,null,5.5541468879912737E-2,null,5.5918860748297321E-2,null,4.9839313618539383E-2,null,3.9968157561105055E-2,null,3.9661526668042582E-2,null,3.768611610696701E-2,null,3.2190347023616478E-2,null,3.058643158298199E-2,null,2.2743756818114812E-2,null,1.0095232479287675E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal Provisional Report 2014-15"]
[]
[null,null,null,"Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km",null,null,"plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km","Plants","Km"]
[null,"Andhra Pradesh "]
[null,null,40,null,null,null,null,9,15.9,3,19.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10]
[null,null,"40-100",null,null,null,null,1,71]
[null,null,"100-500",null,null,null,null,2,321.5,1,230]
[null,null,"500+",null,null,null,null,0,0]
[null,"Gujrat"]
[null,null,40,3,28.67,1,4.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15,null,null,null,null,3,23.73,1,125]
[null,null,"40-100",null,null,1,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,75]
[null,null,"100-500",1,167]
[null,null,"500+"]
[null,"Karnataka"]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,1,25]
[null,null,"40-100"]
[null,null,"100-500"]
[null,null,"500+",null,null,null,null,null,null,null,null,null,null,null,null,4,493]
[null,"Maharastra"]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.9,1,2.5]
[null,null,"40-100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,67.599999999999994]
[null,null,"100-500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,302,null,null,null,null,1,275,null,null,null,null,null,null,null,null,null,null,null,null,1,384]
[null,null,"500+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,822.83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,805.33]
[null,"Odisha"]
[null,null,40,null,null,null,null,null,null,null,null,1,26.6]
[null,null,"40-100",null,null,null,null,null,null,null,null,2,94,null,null,null,null,1,84.2]
[null,null,"100-500",null,null,null,null,null,null,null,null,8,214.13]
[null,null,"500+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,414]
[null,"Tamilnadu"]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,13.125,null,null,4,22.55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,25.5,1,30]
[null,null,"40-100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,46.05,null,null,2,62.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,66,1,45]
[null,null,"100-500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,260]
[null,null,"500+"]
[null,"West Bengal"]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,13.6]
[null,null,"40-100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,73.2]
[null,null,"100-500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,307.8]
[null,null,"500+"]
[]
[]
[null,null,40,null,"40-100",null,"100-500",null,"500+",null,null,null,0.25,"Weightage "]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"if the plant have a specific port, very close to port, In close proximity with high share port <100 km"]
[null,null,"Sub ","Super","Sub ","Super","Sub ","Super","Sub ","Super",null,null,3,"close to high share port but distance over 100 km "]
[null,"Andhra Pradesh",4,4,4,4,2,3,null,null,null,null,2,"close to high share port but distance over 500 km or in states away from mines "]
[null,"Gujrat",4,4,4,4,3,4,null,null,null,null,1,"100-500km from a low shared port and closer to mining states (west Bengal, Bihar, Orissa)"]
[null,"Karnataka",4,4,null,null,2,3,null,null,null,null,0,"Far distant from port and possibly closure to port"]
[null,"Maharashtra",4,4,2,{"$f":"2+1","v":3},2,3,0,1,null,null,"+1","For Super critical plant "]
[null,"Odisha",3,3,2,2,1,1,0,1,null,null,"-1","For states with plants close to mine (Odisha, west Bengal)"]
[null,"Tamil nadu",4,4,4,4,3,3]
[null,"West Bengal",3,3,1,1,0,1]
[]
[null,null,"Subcortical (within 40 Km) (GW)","Super critical  (within 40 KM) (GW)","subcortical (Between 40km and 100 km) (GW)","Super critical   (Between 40km and 100 km)(GW)","subcritical (Between 100km and 500 km)(GW)","Super critical   (Between 100km and 500 km)(GW)","subcritical (Over  500 km) (GW)","Super critical   (Over 500 km) (GW)",null,null,null,null,null,"Sub ","Super"]
[null,"Andhra Pradesh",{"$f":"$M$45*C48","v":1},1,1,1,0.5,0.75,0,0,null,"Imported (GW)",null,null,null,30.345484318114799,20]
[null,"Gujarat",1,1,1,1,0.75,1,0,0,null,"Domestic  (GW)",null,null,null,107.45451568188518,6.8000000000000007]
[null,"Maharashtra",{"$f":"$M$45*C51","v":1},1,0.5,0.75,0.5,0.75,0,0.25]
[null,"Odisha",0.75,0.75,0.5,0.5,0.25,0.25,0,0.25,null,"Coastal (GW)",null,null,null,67.054999999999993,13.52]
[null,"Tamil Nadu",1,1,1,1,0.75,0.75,0,0,null,"Non-coastal (GW)",null,null,null,70.72,13.305]
[null,"West Bengal",0.75,0.75,0.25,0.25,0,0.25,0,0]
[null,"Karnataka ",{"$f":"$M$45*C50","v":1},1,0,0,0.5,0.75,0,0]

{"sheet":"Power Capacity Projections","index":10,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[7,4,7,12],[8,13,11,13],[8,16,8,17],[8,18,8,19],[31,8,32,16],[15,16,15,17],[15,18,15,19],[22,16,22,17],[22,18,22,19]]}
["Projections for Power Plants till 2020"]
[null,null,"This sheet contains breakdown for projected plants based on the stage towards commissioning and likely scenario of them coming online "]
[null,null,null,null,null,null,null,"Sources:"]
[null,null,null,null,"Legend",null,null,"Brookings Research on power capacities expected by 2020 (IndiaInframonitor database)"]
[null,null,null,null,1,"Yes"]
[null,null,null,null,0,"No"]
[]
[null,null,"Methodology","Weightage","Project Status",null,null,null,null,null,null,null,null,null,null,"Linked from sheet: Plants Breakdown"]
[null,null,"Environmental Clearance ",0.35,1,1,1,1,1,0,0,0,0,"Total",null,null,{"$f":"'Plants Breakdown'!C86","v":"Domestic"},null,{"$f":"'Plants Breakdown'!E86","v":"Imports"},null,{"$f":"'Plants Breakdown'!G86","v":"Total"}]
[null,null,"Land Acquisition",0.3,1,1,1,0,0,1,1,0,0,null,null,null,{"$f":"'Plants Breakdown'!C87","v":"Sub"},{"$f":"'Plants Breakdown'!D87","v":"Super"},{"$f":"'Plants Breakdown'!E87","v":"Sub"},{"$f":"'Plants Breakdown'!F87","v":"Super"}]
[null,null,"Financial Closure ",0.25,1,1,0,1,0,1,0,1,0,null,null,{"$f":"'Plants Breakdown'!B88","v":"Coastal"},{"$f":"'Plants Breakdown'!C88","v":9.9571874999999963},{"$f":"'Plants Breakdown'!D88","v":10.236187500000003},{"$f":"'Plants Breakdown'!E88","v":14.015812500000003},{"$f":"'Plants Breakdown'!F88","v":18.378562499999997},{"$f":"'Plants Breakdown'!G88","v":52.58775}]
[null,null,"Exogenous supporting variables",0.1,1,0,0,0,0,0,0,0,1,null,null,{"$f":"'Plants Breakdown'!B89","v":"Non Coastal"},{"$f":"'Plants Breakdown'!C89","v":21.3},{"$f":"'Plants Breakdown'!D89","v":36.299999999999997},{"$f":"'Plants Breakdown'!E89","v":0},{"$f":"'Plants Breakdown'!F89","v":0},{"$f":"'Plants Breakdown'!G89","v":57.599999999999994}]
[null,null,"1-Slippage %",{"$f":"SUM(D9:D12)","v":0.99999999999999989},{"$f":"$D$9*E9+$D$10*E10+$D$11*E11+$D$12*E12","v":0.99999999999999989},{"$f":"$D$9*F9+$D$10*F10+$D$11*F11+$D$12*F12","v":0.89999999999999991},0.64999999999999991,0.6,0.35,0.55000000000000004,0.3,0.25,0.1,{"$f":"N18/N15","v":0.74868958336168978},null,{"$f":"'Plants Breakdown'!B90","v":"Grand Total"},{"$f":"'Plants Breakdown'!C90","v":31.257187499999997},{"$f":"'Plants Breakdown'!D90","v":46.536187499999997},{"$f":"'Plants Breakdown'!E90","v":14.015812500000003},{"$f":"'Plants Breakdown'!F90","v":18.378562499999997},{"$f":"'Plants Breakdown'!G90","v":110.18775000000001}]
[null,null,"Slippage",null,{"$f":"$D$13-E13","v":0},{"$f":"$D$13-F13","v":9.9999999999999978E-2},0.35,0.39999999999999991,0.64999999999999991,0.44999999999999984,0.7,0.74999999999999989,0.89999999999999991,{"$f":"N19/N15","v":0.25131041663831}]
[null,null,"Total",null,null,89.873000000000005,14.02,20.29,4.59,7.1849999999999996,4.8600000000000003,1.4,4.72,{"$f":"SUM(F15:M15)","v":146.93800000000002},null,"Linked from sheet: Plants Breakdown"]
[null,null,"Private ",null,null,57.47,5.34,11.77,4.59,5.87,4.8600000000000003,1.4,3.12,{"$f":"SUM(F16:M16)","v":94.420000000000016},null,null,"Domestic",null,"Imports",null,"Total"]
[null,null,"Public",null,null,{"$f":"F15-F16","v":32.403000000000006},8.68,8.52,null,1.32,null,null,1.6,{"$f":"SUM(F17:M17)","v":52.52300000000001},null,null,"Sub","Super","Sub","Super",0]
[null,null,"Possible Online",null,null,{"$f":"F13*F15","v":80.8857},{"$f":"G13*G15","v":9.1129999999999978},12.173999999999999,1.6064999999999998,3.9517500000000001,1.458,0.35,0.47199999999999998,{"$f":"SUM(F18:M18)","v":110.01094999999998},null,"Coastal",{"$f":"'Plants Breakdown'!C81","v":38.358749999999993},{"$f":"'Plants Breakdown'!D81","v":3.5350000000000001},{"$f":"'Plants Breakdown'!E81","v":28.696249999999999},{"$f":"'Plants Breakdown'!F81","v":9.9849999999999994},{"$f":"SUM(Q18:T18)","v":80.575000000000003}]
[null,null,"Probable slippage",null,null,{"$f":"F15-F18","v":8.9873000000000047},{"$f":"G15-G18","v":4.9070000000000018},8.1159999999999997,2.9835000000000003,3.2332499999999995,3.4020000000000001,1.0499999999999998,4.2479999999999993,{"$f":"SUM(F19:M19)","v":36.927050000000001},null,"Non Coastal",{"$f":"'Plants Breakdown'!C82","v":70.7},{"$f":"'Plants Breakdown'!D82","v":13.3},{"$f":"'Plants Breakdown'!E82","v":0},{"$f":"'Plants Breakdown'!F82","v":0},{"$f":"SUM(Q19:T19)","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"'Plants Breakdown'!C83","v":109.05875},{"$f":"'Plants Breakdown'!D83","v":16.835000000000001},{"$f":"'Plants Breakdown'!E83","v":28.696249999999999},{"$f":"'Plants Breakdown'!F83","v":9.9849999999999994},{"$f":"SUM(Q20:T20)","v":164.57499999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Slippage",{"$f":"N19/N15","v":0.25131041663831}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic",null,"Imports",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub","Super","Sub","Super",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coastal",{"$f":"Q11+Q18","v":48.31593749999999},{"$f":"R11+R18","v":13.771187500000003},{"$f":"S11+S18","v":42.712062500000002},28.363562499999997,133.16275000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Coastal",{"$f":"Q12+Q19","v":92},{"$f":"R12+R19","v":49.599999999999994},0,0,141.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(Q25:Q26)","v":140.31593749999999},{"$f":"SUM(R25:R26)","v":63.371187499999998},{"$f":"SUM(S25:S26)","v":42.712062500000002},{"$f":"SUM(T25:T26)","v":28.363562499999997},{"$f":"U25+U26","v":274.76274999999998}]

{"sheet":"Coal Quality","index":11,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":true,"merged":[[11,8,11,10],[11,11,11,13],[37,2,37,4],[37,5,37,7],[37,8,37,10],[37,11,37,13],[4,2,4,3],[4,5,4,6],[5,3,5,4],[5,6,5,7],[11,2,11,4],[11,5,11,7]]}
[null,"Coal Quality and Total coal Consumption Analysis "]
[]
[null,null,null,null,"Coal requirement calculation based on ints GCV to compute total coal demand",null,null,null,null,null,null,null,null,null,null,null,"Source"]
[null,"GCV Values",null,null,null,null,null,null,null,null,"Kilocalorie","Joules","Mega Joules"]
[null,null,"OLD Plants",null,null,"NEW PLANTS ",null,null,null,null,1,4184,{"$f":"L5/1000000","v":4.1840000000000002E-3}]
[null,"Function","Grade of coal","Values (upper/lower/avg)",null,"Grade of coal","Values (upper/lower/avg)",null,null,null,"Linked Cells to Assumption and Result sheet",null,null,null,null,null,"GCV Values","https://www.coalindia.in/en-us/ourbusiness/productsservices.aspx"]
[null,"Subcritical",{"$f":"'Assumptions and Results'!C32","v":"G11"},{"$f":"'Assumptions and Results'!D32","v":2},{"$f":"VLOOKUP(D7,$I$7:$J$8,2,1)","v":"Lower"},{"$f":"'Assumptions and Results'!C35","v":"G11"},{"$f":"'Assumptions and Results'!D35","v":2},{"$f":"VLOOKUP(G7,$I$7:$J$8,2,1)","v":"Lower"},1,"Lower",null,"Old plants (Sub critical)","Old plants (Supercritical)","New Plants (sub critical )","New Plants (Super critical)",null,"GCV range for Lignite","www.dmg-raj.org/docs/vol%252024-1-2-c.doc+&cd=1&hl=en&ct=clnk&gl=in"]
[null,"Supercritical",{"$f":"'Assumptions and Results'!C33","v":"G11"},{"$f":"'Assumptions and Results'!D33","v":2},{"$f":"VLOOKUP(D8,I7:J8,2,1)","v":"Lower"},{"$f":"'Assumptions and Results'!C36","v":"G11"},{"$f":"'Assumptions and Results'!D36","v":2},{"$f":"VLOOKUP(G8,$I$7:$J$8,2,1)","v":"Lower"},3,"Average","India specific system efficiency numbers Present",{"$f":"'Calculations '!C13","v":0.31},{"$f":"'Calculations '!C14","v":0.38},{"$f":"'Calculations '!C16","v":0.34},{"$f":"'Calculations '!C17","v":0.38500000000000001},"Conversion","Calories to joules","Google tables"]
[null,"Output from this sheet","Sub Critical (KG/KWH) actual old","Super Critical (KG/KWH) actual old","Sub Critical (KG/KWH) actual new","Super Critical (KG/KWH) actual new",null,null,null,null," Respective Total MJ/KWH after accounting for system eff.",{"$f":"'Calculations '!D13","v":11.612903225806452},{"$f":"'Calculations '!D14","v":9.473684210526315},{"$f":"'Calculations '!D16","v":10.588235294117647},{"$f":"'Calculations '!D17","v":9.3506493506493502},null,"KW to MJ/hr","https://www.unitjuggler.com/convert-energy-from-kWh-to-MJ.html"]
[null,"Specific Coal Consumption",{"$f":"VLOOKUP($C$7,$B$17:$N$34,IF($D$7=1,8,IF($D$7=2,9,IF($D$7=3,10,0))),0)","v":0.64547685678589828},{"$f":"VLOOKUP($C$8,$B$17:$N$34,IF($D$8=1,11,IF($D$8=2,12,IF($D$8=3,13,0))),0)","v":0.52657322527270645},{"$f":"VLOOKUP($F$7,$B$44:$N$61,IF($G$7=1,8,IF($G$7=2,9,IF($G$7=3,10,0))),0)","v":0.58852301648126015},{"$f":"VLOOKUP($F$8,$B$43:$N$60,IF($G$8=1,11,IF($G$8=2,12,IF($G$8=3,13,0))),0)","v":0.5197346119574765},null,null,null,null,null,null,null,null,null,null,"Import Coal GCV was taken from govt. assumption: ( Source: http://indiaenvironmentportal.org.in/files/India_Energy_Handbook.pdf)"]
[null,"Specific coal Consumption (Sub Critical Plants )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSE report has average values for specific coal consumption of overall power plants (Page 32,33)"]
[null,"Type of Coal","Calorific Value (kcal/Kg)",null,null,"MJ Required (MJoules/Kg)",null,null,"Coal Required for Subcritical (Kg/kwh)",null,null,"Coal Required for Supercritical (Kg/kwh)"]
[null,null,"Lower Bound (kcal/Kg) not including","Upper Bound (kcal/Kg) including","Average (kcal/Kg)","Lower Bound (MJ/Kg) not including","Upper Bound (MJ/Kg) including","Average (MJ/Kg)","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh"]
[null,"Anthracite",7917,7917,7917,{"$f":"C14*$M$5","v":33.124728000000005},33.124728000000005,33.124728000000005,{"$f":"$L$9/F14","v":0.35058108932415838},0.35058108932415838,0.35058108932415838,{"$f":"$M$9/F14","v":0.28600036234339232},0.28600036234339232,0.28600036234339232]
[null,"Bituminous",4792,4792,4792,20.049728000000002,20.049728000000002,20.049728000000002,0.57920502591389023,0.57920502591389023,0.57920502591389023,0.47250936324554199,0.47250936324554199,0.47250936324554199]
[null,"Imports",null,null,{"$f":"'Assumptions and Results'!C37","v":5500},null,null,{"$f":"E16*$M$5","v":23.012},null,null,{"$f":"$L$9/H16","v":0.50464554257806582},null,null,{"$f":"$M$9/H16","v":0.41168452157684315},null,null,"For calrofic Value range of Lignite is below"]
[null,"Lignite",1000,3000,{"$f":"(C17+D17)/2","v":2000},{"$f":"C17*$M$5","v":4.1840000000000002},{"$f":"D17*$M$5","v":12.552000000000001},8.3680000000000003,{"$f":"$L$9/F17","v":2.7755504841793623},{"$f":"$L$9/G17","v":0.925183494726454},1.3877752420896812,{"$f":"$M$9/F17","v":2.2642648686726372},{"$f":"$M$9/G17","v":0.7547549562242124},1.1321324343363186,null,null,"www.dmg-raj.org/docs/vol%252024-1-2-c.doc+&cd=1&hl=en&ct=clnk&gl=in"]
[null,"G1",{"$f":"D19","v":7000},{"$f":"C18+300","v":7300},{"$f":"(C18+D18)/2","v":7150},29.288,30.543200000000002,29.915600000000001,0.39650721202562317,0.38021239509306332,0.38818887890620452,0.32346640981037678,0.31017326968118319,0.31668040121295626]
[null,"G2",{"$f":"D20","v":6700},{"$f":"C19+300","v":7000},{"$f":"(C19+D19)/2","v":6850},28.032800000000002,29.288,28.660400000000003,0.4142612662954272,0.39650721202562317,0.40518985170501637,0.33794998039890106,0.32346640981037678,0.33054961586461856]
[null,"G3",{"$f":"D21","v":6400},6700,{"$f":"(C20+D20)/2","v":6550},26.7776,28.032800000000002,27.405200000000001,0.43367976315302537,0.4142612662954272,0.42374816552356676,0.35379138573009961,0.33794998039890106,0.3456892929271202]
[null,"G4",6100,6400,6250,25.522400000000001,26.7776,26.150000000000002,0.4550082760949774,0.43367976315302537,0.44408807746869794,0.37119096207748153,0.35379138573009961,0.36228237898762194]
[null,"G5",5800,6100,5950,24.267200000000003,25.522400000000001,24.8948,0.47854318692747622,0.4550082760949774,0.46647907297132141,0.39039049459873054,0.37119096207748153,0.38054871742397267]
[null,"G6",5500,5800,5650,23.012,24.267200000000003,23.639600000000002,0.50464554257806582,0.47854318692747622,0.49124787330608177,0.41168452157684315,0.39039049459873054,0.40075484401285616]
[null,"G7",5200,5500,5350,21.756800000000002,23.012,22.384399999999999,0.53375970849603116,0.50464554257806582,0.51879448302417985,0.43543555166781484,0.41168452157684315,0.42322707825656775]
[null,"G8",4900,5200,5050,20.5016,21.756800000000002,21.129200000000001,0.56643887432231887,0.53375970849603116,0.54961395726324003,0.46209487115768111,0.43543555166781484,0.44836928092527473]
[null,"G9",4600,4900,4750,19.246400000000001,20.5016,19.874000000000002,0.60338054003899178,0.56643887432231887,0.58432641772197091,0.49223149318970377,0.46209487115768111,0.47668734077318675]
[null,"G10",4300,4600,4450,17.991199999999999,19.246400000000001,18.6188,0.64547685678589828,0.60338054003899178,0.62371920992794661,0.52657322527270645,0.49223149318970377,0.50882356599385115]
[null,"G11",4000,4300,4150,16.736000000000001,17.991199999999999,17.363600000000002,0.69388762104484059,0.64547685678589828,0.66880734558538846,0.5660662171681593,0.52657322527270645,0.54560599245123786]
[null,"G12",3700,4000,3850,15.4808,16.736000000000001,16.1084,0.75014877950793579,0.69388762104484059,0.72092220368295123,0.61196347801963169,0.5660662171681593,0.58812074510977597]
[null,"G13",3400,3700,3550,14.2256,15.4808,14.853200000000001,0.81633837769981243,0.75014877950793579,0.78184520681108793,0.66596025549195215,0.61196347801963169,0.63782108976694007]
[null,"G14",3100,3400,3250,12.970400000000001,14.2256,13.598000000000001,0.89533886586431033,0.81633837769981243,0.8540155335936499,0.73040802215246359,0.66596025549195215,0.69669688266850383]
[null,"G15",{"$f":"D33","v":2800},3100,2950,11.715200000000001,12.970400000000001,12.3428,0.99126803006405784,0.89533886586431033,0.94086457090825837,0.80866602452594183,0.73040802215246359,0.76754741310936858]
[null,"G16",{"$f":"D34","v":2500},2800,2650,10.46,11.715200000000001,11.0876,1.1102201936717448,0.99126803006405784,1.0473775411997595,0.90570594746905486,0.80866602452594183,0.85443957308401408]
[null,"G17",2200,{"$f":"C34+300","v":2500},2350,9.2048000000000005,10.46,9.8323999999999998,1.2616138564451647,1.1102201936717448,1.18108531241675,1.0292113039421078,0.90570594746905486,0.96351696539261167]
[]
[]
[null,"Specific coal Consumption (Supercritical Critical Plants )"]
[null,"Type of Coal","Calorific Value (kcal/Kg)",null,null,"MJ Required (Joules/Kg)",null,null,"Coal Required for Subcritical (Kg/kwh)",null,null,"Coal Required for Supercritical (Kg/kwh)",null,null,"Source"]
[null,null,"Lower Bound (kcal/Kg) not including","Upper Bound (kcal/Kg) including","Average (kcal/Kg)","Lower Bound (MJ/Kg) not including","Upper Bound (MJ/Kg) including","Average (MJ/Kg)","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh","(mj/kwh)/(mj/kg)=kg/kwh"]
[null,"Anthracite",7917,7917,7917,{"$f":"C40*$M$5","v":33.124728000000005},33.124728000000005,33.124728000000005,{"$f":"$L$9/F40","v":0.35058108932415838},0.35058108932415838,0.35058108932415838,{"$f":"$M$9/F40","v":0.28600036234339232},0.28600036234339232,0.28600036234339232]
[null,"Bituminous",4792,4792,4792,20.049728000000002,20.049728000000002,20.049728000000002,0.57920502591389023,0.57920502591389023,0.57920502591389023,0.47250936324554199,0.47250936324554199,0.47250936324554199]
[null,"Imports",null,null,{"$f":"'Assumptions and Results'!C37","v":5500},null,null,{"$f":"E42*$M$5","v":23.012},null,null,{"$f":"$N$9/H42","v":0.4601179947035306},null,null,{"$f":"$O$9/H42","v":0.40633796934857247}]
[null,"Lignite",1000,3000,{"$f":"(C43+D43)/2","v":2000},{"$f":"C43*$M$5","v":4.1840000000000002},{"$f":"D43*$M$5","v":12.552000000000001},8.3680000000000003,{"$f":"$N$9/F43","v":2.5306489708694184},{"$f":"$N$9/G43","v":0.84354965695647277},1.2653244854347092,{"$f":"$O$9/F43","v":2.2348588314171485},{"$f":"$O$9/G43","v":0.74495294380571619},1.1174294157085742]
[null,"G1",{"$f":"D45","v":7000},{"$f":"C44+300","v":7300},{"$f":"(C44+D44)/2","v":7150},29.288,30.543200000000002,29.915600000000001,0.36152128155277408,0.34666424258485179,0.35393691900271584,0.31926554734530693,0.30614504539960941,0.31256766872967112]
[null,"G2",{"$f":"D46","v":6700},{"$f":"C45+300","v":7000},{"$f":"(C45+D45)/2","v":6850},28.032800000000002,29.288,28.660400000000003,0.37770880162230125,0.36152128155277408,0.36943780596633841,0.3335610196144998,0.31926554734530693,0.32625676371053264]
[null,"G3",{"$f":"D47","v":6400},6700,{"$f":"(C46+D46)/2","v":6550},26.7776,28.032800000000002,27.405200000000001,0.39541390169834661,0.37770880162230125,0.38635862150678141,0.34919669240892948,0.3335610196144998,0.34119982159040435]
[null,"G4",6100,6400,6250,25.522400000000001,26.7776,26.150000000000002,0.41486048702777351,0.39541390169834661,0.4049038353391069,0.36637030023231942,0.34919669240892948,0.35757741302674378]
[null,"G5",5800,6100,5950,24.267200000000003,25.522400000000001,24.8948,0.43631878808093416,0.41486048702777351,0.4253191547679695,0.3853204881753704,0.36637030023231942,0.37560652628859642]
[null,"G6",5500,5800,5650,23.012,24.267200000000003,23.639600000000002,0.4601179947035306,0.43631878808093416,0.44790247272025102,0.40633796934857247,0.3853204881753704,0.39555023564905284]
[null,"G7",5200,5500,5350,21.756800000000002,23.012,22.384399999999999,0.4866632636287343,0.4601179947035306,0.47301849922792871,0.42978054450329778,0.40633796934857247,0.41773062269479416]
[null,"G8",4900,5200,5050,20.5016,21.756800000000002,21.129200000000001,0.51645897364682014,0.4866632636287343,0.50111860809295417,0.45609363906472422,0.42978054450329778,0.44254630325092054]
[null,"G9",4600,4900,4750,19.246400000000001,20.5016,19.874000000000002,0.55014108062378653,0.51645897364682014,0.53276820439356176,0.48583887639503232,0.45609363906472422,0.47049659608782074]
[null,"G10",4300,4600,4450,17.991199999999999,19.246400000000001,18.6188,0.58852301648126015,0.55014108062378653,0.56868516199312769,0.5197346119574765,0.48583887639503232,0.50221546773419068]
[null,"G11",4000,4300,4150,16.736000000000001,17.991199999999999,17.363600000000002,0.63266224271735461,0.58852301648126015,0.60979493273961882,0.55871470785428712,0.5197346119574765,0.53852020034148151]
[null,"G12",3700,4000,3850,15.4808,16.736000000000001,16.1084,0.68395918131605904,0.63266224271735461,0.65731142100504381,0.60401590038301312,0.55871470785428712,0.58048281335510354]
[null,"G13",3400,3700,3550,14.2256,15.4808,14.853200000000001,0.74430852084394661,0.68395918131605904,0.71285886503363893,0.65731142100504369,0.60401590038301312,0.62953769899074608]
[null,"G14",3100,3400,3250,12.970400000000001,14.2256,13.598000000000001,0.81633837769981232,0.74430852084394661,0.77866122180597486,0.72092220368295112,0.65731142100504369,0.68764887120527651]
[null,"G15",{"$f":"D59","v":2800},3100,2950,11.715200000000001,12.970400000000001,12.3428,0.90380320388193502,0.81633837769981232,0.85784710876929438,0.79816386836326736,0.72092220368295112,0.75757926488716898]
[null,"G16",{"$f":"D60","v":2500},2800,2650,10.46,11.715200000000001,11.0876,1.0122595883477672,0.90380320388193502,0.95496187579978054,0.89394353256685943,0.79816386836326736,0.84334295525175418]
[null,"G17",2200,{"$f":"C60+300","v":2500},2350,9.2048000000000005,10.46,9.8323999999999998,1.1502949867588266,1.0122595883477672,1.076871902497625,1.0158449233714311,0.89394353256685943,0.95100375804985049]

{"sheet":"Efficiency Calculation","index":12,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Efficiency Calculation "]
[null,null,"This sheet show the analysis to identify Efficiency of current power plants"]
[]
[null,"Plant type (MW)","Total Number","Average age","Design Efficiency","Operating Efficiency","% dev","Comment (Outliers?)"]
[null,"500 MW",5,14,0.3807115050121509,0.3351145388313882,{"$f":"1-F6/E6","v":0.11976776530382871},"None"]
[null,"250 MW","4/5",8,0.37317047659615432,0.31979199821660576,{"$f":"1-F7/E7","v":0.14304046468637133},"Age outlier (1)"]
[null,"250 MW",1,3,0.37610445280377924,0.3224034495688039,{"$f":"1-F8/E8","v":0.14278215223097124},"OUTLIER"]
[null,"210 MW (till 1989)",27,24,0.36154896765486239,0.31040966962021177,{"$f":"1-F9/E9","v":0.14144501190629488},"None"]
[null,"210 MW (from 1990-1999)",18,14,0.3673339179398773,0.32475097499578687,0.11592434257884165,"None"]
[null,"210 MW ( 2000+ )","3/4",2,0.37224813752856883,0.33663421400708859,9.5672536491191895E-2,"Age outlier (1)"]
[null,"210 MW 2000",1,8,0.36840188517566408,0.31964684014869887,0.13234200743494418,"Age Outlier (1)"]
[null,"195-200 MW","3/5",28,0.35797264703842419,0.30035516589935612,0.16095498249865858,"Age Outlier (1) + Operational Outlier (1)"]
[null,"140 MW","3/4",38,0.35916625366206062,0.30744200496788232,0.14401199490987149,"Age Outlier (1)"]
[null,"120-125 MW","7/9",29,0.35516512408940659,0.29334480520040984,0.17406078101698574,"Age outlier (1) + Operational Outlier (1)"]
[null,"100-110 MW (age 30+)","4/5",33,0.35035582831683215,0.28721452650779511,0.18022049786463779,"Operational Outlier (1)"]
[null,"100-110 MW (age 20s)",3,24,0.36671913934365064,0.30119760067875867,0.17866953653458506,"None"]
[]
[]
[]
[null,{"$f":"B5","v":"Plant type (MW)"},"Total Number","Average age","Design Efficiency","Operating Efficiency","% dev","Comment (Outliers?)","Weights (Age)","Weights (deviation)","Weights (Number)"]
[null,"500 MW",5,14,0.3807115050121509,0.3351145388313882,0.11976776530382871,"None",{"$f":"D22","v":14},{"$f":"1-G22","v":0.88023223469617129},{"$f":"C22","v":5}]
[null,"250 MW","4/5",8,0.37317047659615432,0.31979199821660576,0.14304046468637133,"Age outlier (1)",{"$f":"D23","v":8},{"$f":"1-G23","v":0.85695953531362867},4]
[null,{"$f":"B9","v":"210 MW (till 1989)"},27,24,0.36154896765486239,0.31040966962021177,0.14144501190629488,"None",24,0.85855498809370512,{"$f":"C24","v":27}]
[null,"210 MW (from 1990-1999)",18,14,0.3673339179398773,0.32475097499578687,0.11592434257884165,"None",14,0.88407565742115835,{"$f":"C25","v":18}]
[null,"210 MW ( 2000+ )","3/4",2,0.37224813752856883,0.33663421400708859,9.5672536491191895E-2,"Age outlier (1)",2,0.9043274635088081,3]
[null,{"$f":"B13","v":"195-200 MW"},"3/5",28,0.35797264703842419,0.30035516589935612,0.16095498249865858,"Age Outlier (1) + Operational Outlier (1)",28,0.83904501750134142,3]
[null,"140 MW","3/4",38,0.35916625366206062,0.30744200496788232,0.14401199490987149,"Age Outlier (1)",38,0.85598800509012851,3]
[null,"120-125 MW","7/9",29,0.35516512408940659,0.29334480520040984,0.17406078101698574,"Age outlier (1) + Operational Outlier (1)",29,0.82593921898301426,7]
[null,"100-110 MW (age 30+)","4/5",33,0.35035582831683215,0.28721452650779511,0.18022049786463779,"Operational Outlier (1)",33,0.81977950213536221,4]
[null,"100-110 MW (age 20s)",3,24,0.36671913934365064,0.30119760067875867,0.17866953653458506,"None",24,0.82133046346541494,{"$f":"C31","v":3}]
[null,"Simple Average",null,null,null,{"$f":"AVERAGE(F22:F31)","v":0.31162554989252833},null,null,{"$f":"SUMPRODUCT(F22:F31,I22:I31)/SUM(I22:I31)","v":0.30479493296277288},{"$f":"SUMPRODUCT(F22:F31,J22:J31)/SUM(J22:J31)","v":0.31210967140038059},{"$f":"SUMPRODUCT(F22:F31,K22:K31)/SUM(K22:K31)","v":0.31325296124398122}]

{"sheet":"Railway in cotext of coal","index":13,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[24,2,24,3]]}
[null,"Railway 2014-15 at a glance"]
[null,null,null,null,null,null,null,"Source:"]
[null,"Total Number of Wagon",254006,null,null,null,null,"Annual report Railways 2014-15"]
[null,"BOX'N' Type ",52351,null,null,null,null,"Summary Report Railway 2014-15"]
[null,"BOXNHA",2993,"Specifically designed for coal transpiration; Have higher walls than BOX'N' type "]
[null,"BOBR/N/HS",13572,"Bogie open rapid discharge air brake wagon for coal"]
[null,"Coal Dedicated corridors "]
[null,"The Western DFC","1502 km","Jawahar Lal nehru Port to Dadri  for imported coal from Mumbai and Gujrat port"]
[null,"The Eastern DFC","1840 km","Ludhiana to Dankuni  for coal and steel traffic "]
[]
[null,"Growth (%) in Infrastructure Industries (Base 2004-05=100)"]
[null,"Sectors","Weight","2010-11","2011-12","2012-13","2013-14","2014-15"]
[null,"Coal",4.38,-0.2,1.3,4.5999999999999996,1.3,8.5]
[null,"Steel",6.68,13.2,10.3,4.0999999999999996,11.5,4.2]
[null,"Cement",2.41,4.5,6.7,7.7,3.1,5.6]
[null,"Total",37.9,6.6,5,6.5,4.2,4.4000000000000004]
[]
[null,"Percentage of total availability (production plus imports) of select major\n commodities carried by the Indian Railways"]
[null,null,"Coal","Iron Ore","Cement","Food grains","Fertilizers","Pol Product "]
[]
[null,"2014-15 (P)",0.65749999999999997,0.79979999999999996,0.40360000000000001,0.2195,0.87649999999999995,0.1701]
[]
[]
[]
[null,"Railway transpiration of coal ","Tonnes carried* (Millions)",null,"* Does not include transport from Konkan Railway "]
[null,"Coal","2013-14","2014-15","Absolute Variation over last year","Percentage to total "]
[null," Steel Plants ",50.01,53.91,3.9,4.92]
[null,"Washeries",1.65,0.99,-0.66,0.09]
[null,"Thermal Plants",335.38,367.29,31.91,33.53]
[null,"Other Usage ",121.02,123.62,2.6,11.29]
[null,"Total",{"$f":"SUM(C27:C30)","v":508.05999999999995},{"$f":"SUM(D27:D30)","v":545.80999999999995},{"$f":"SUM(E27:E30)","v":37.75},{"$f":"SUM(F27:F30)","v":49.83}]
[]
[null,"Railway Tonnes Originating, Net Tonne Kms. and Earnings from Coal & total  commodities in 2014-15"]
[null,null,"Quantity ( MT)","% Share ","Travelled  Ton Kilometers (km)","percentage ","Income (Cr)","Revenue percentage "]
[null,"Coal",545.80999999999995,0.49830000000000002,301519,0.44230000000000003,47937.51,0.46500000000000002]
[null,"Total ",1095.26,1,681.69600000000003,1,103100.05,1]

{"sheet":"Additional Information ","index":14,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":true,"merged":[[3,1,3,4],[29,12,29,14],[35,12,35,14],[20,12,20,14],[24,14,27,14]]}
[null,"Additional Information "]
[null,null,null,"Other Relevant Information ",null,null,null,null,null,null,null,null,"Source:"]
[null,null,null,null,null,null,null,"Month ","PLF","12 months moving average ",null,null," CEA reports march'12 to March'15"]
[null,"India total installed power capacity ",null,null,null,null,null,"2012-03-01",75.239999999999995,null,null,null,"India Installed Capacity : CEA reports March, April ( 2014, 2015, 2016)"]
[null,null,2014,2015,2016,null,null,"2012-04-01",74.45]
[null,"Thermal (GW) Coal",145.30000000000001,164.6,185.2,null,null,"2012-05-01",72.239999999999995]
[null,"Thermal (GW) Gas",21.8,23.1,24.5,null,null,"2012-06-01",66.959999999999994]
[null,"Thermal (GW) Diesel",1.2,1.2,1,null,null,"2012-07-01",61.58]
[null,"Nuclear (GW)",4.8,5.8,5.8,null,null,"2012-08-01",61.41]
[null,"Hydro (GW)",40.5,41.3,42.7,null,null,"2012-09-01",71.040000000000006]
[null,"RE (GW)",29.5,31.7,38.799999999999997,null,null,"2012-10-01",71.02]
[null,null,null,null,null,null,null,"2012-11-01",72.41]
[null,null,null,null,null,null,null,"2012-12-01",74.33]
[null,null,null,null,null,null,null,"2013-01-01",70.67]
[null,null,null,null,null,null,null,"2013-02-01",71.959999999999994]
[null,null,null,null,null,null,null,"2013-03-01",69.97,{"$f":"SUM(I4:I15)/12","v":70.275833333333338}]
[null,null,null,null,null,null,null,"2013-04-01",71.55,{"$f":"SUM(I5:I16)/12","v":69.836666666666673}]
[null,null,null,null,null,null,null,"2013-05-01",63.4,69.594999999999999]
[null,null,null,null,null,null,null,"2013-06-01",60.86,68.858333333333334]
[null,null,null,null,null,null,null,"2013-07-01",55.85,68.350000000000009]
[null,null,null,null,null,null,null,"2013-08-01",64.599999999999994,67.872499999999988,null,null,"Genrations breakdown"]
[null,null,null,null,null,null,null,"2013-09-01",61.68,68.138333333333335,null,null,null,2015,2020]
[null,null,null,null,null,null,null,"2013-10-01",65.62,67.358333333333334,null,null,null,"BU","BU"]
[null,null,null,null,null,null,null,"2013-11-01",68.989999999999995,66.908333333333331,null,null,"Thermal",878.32100000000003,1222.5999999999999]
[null,null,null,null,null,null,null,"2013-12-01",69.819999999999993,66.623333333333321,null,null,"Hydro",129.11099999999999,322.8,"Rest  combined calculated based on power demand "]
[null,null,null,null,null,null,null,"2014-01-01",68.44,66.247500000000002,null,null,"RE",61.78]
[null,null,null,null,null,null,null,"2014-02-01",66.58,66.061666666666667,null,null,"Nuclear",35.972999999999999]
[null,"Domestic Coal Requirement (MT)","Imported Coal Requirement (MT)","Additonal RE Capacity (GW)","% of Thermal BUs Displaced by RE in 2020",null,null,"2014-03-01",68.64,65.61333333333333,null,null,"Imports",4.9980000000000002]
[null,929.19683453151015,299.00335345097807,0,0,null,null,"2014-04-01",67.06,65.502499999999998]
[null,921.33168560623369,295.92734922286422,13.023343416128302,1.4999999999999999E-2,null,null,"2014-05-01",66.31,65.12833333333333,null,null,"Thermal Coal"]
[null,918.70996929780813,294.90201448015961,17.36445788817122,0.02,null,null,"2014-06-01",63.8,65.370833333333337,null,null,null,2015,2020]
[null,916.08825298938257,293.87667973745499,21.705572360213989,2.5000000000000001E-2,null,null,"2014-07-01",59.58,65.615833333333327,null,null,null,"Coal (Mt)","Coal (Mt)"]
[null,913.46653668095712,292.85134499475038,26.046686832256757,0.03,null,null,"2014-08-01",59.07,65.926666666666662,null,null,"Imports",125,167]
[null,908.223104064106,290.80067550934115,34.728915776342291,0.04,null,null,"2014-09-01",65.010000000000005,65.465833333333322,null,null,"Domestic",419,648]
[null,902.97967144725487,288.75000602393186,43.411144720427977,0.05,null,null,"2014-10-01",65.69,65.743333333333339]
[null,897.73623883040386,286.69933653852263,52.093373664513514,0.06,null,null,"2014-11-01",65.83,65.749166666666667,null,null,"Power distribution "]
[null,892.49280621355285,284.6486670531134,60.775602608599044,7.0000000000000007E-2,null,null,"2014-12-01",65.44,65.485833333333332,null,null,null,2015,2020]
[null,887.24937359670184,282.59799756770417,69.457831552684581,0.08,null,null,"2015-01-01",66.95,65.120833333333337,null,null,null,"GW","GW"]
[null,882.00594097985083,280.54732808229494,78.140060496770118,0.09,null,null,"2015-02-01",62.99,64.99666666666667,null,null,"Coal",164.6,229]
[null,876.76250836299982,278.49665859688571,86.822289440855656,0.1,null,null,"2015-03-01",62.05,64.697500000000005,null,null,"Gas",23.1,23.1,"Assumed no growth for Gas and Deisel"]
[null,871.51907574614859,276.44598911147648,95.504518384941335,0.11,null,null,"2015-04-01",64.27,64.148333333333326,null,null,"Deisel",1.2,1.2]
[null,null,null,null,null,null,null,"2015-05-01",59.43,63.915833333333325,null,null,"Nuclear",5.8,8.8000000000000007]
[null,null,null,null,null,null,null,"2015-06-01",58.36,63.34249999999998,null,null,"Hydro",41.3,50]
[null,null,null,null,null,null,null,"2015-07-01",57.6,62.889166666666661,null,null,"RES",31.7,58.2]
[null,null,null,null,null,null,null,"2015-08-01",63.63,62.724166666666662]
[null,null,null,null,null,null,null,"2015-09-01",66.86,63.104166666666664]
[null,null,null,null,null,null,null,"2015-10-01",60.34,63.258333333333333]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Source "]
[null,"Year","GDP at Factor Cost - Annual Growth Rate (At Constant Prices 2004-05) ","Energy availability (MU)","generation growth rate","Elasticity Annual Generation","Capacity Installed (MW)","Capacity Growth Rate ","Elasticity Annual Capacity",null,null,null,null,"http://planningcommission.nic.in/data/datatable/data_2312/DatabookDec2014%2010.pdf"]
[null,"1997-98   ",4.3016139579677013,390330,null,null,89102]
[null,"1998-99   ",6.6833892769199874,420235,{"$f":"((D63-D62)/(D62))*100","v":7.6614659390771918},{"$f":"E63/C63","v":1.1463444102432931},93294,{"$f":"((G63-G62)/G62)*100","v":4.7047204327624517},{"$f":"H63/$C$63","v":0.70394230200079011}]
[null,"1999-00   ",8.0042551418292796,450594,7.2242911704165529,0.90255633315125994,97884,4.9199305421570516,0.73614304633537397]
[null,"2000-01   ",4.1481776471412566,467400,3.7297434053715763,0.89912817690967339,101626,3.8228924032528298,0.57199906287885627]
[null,"2001-02   ",5.3856514061642402,483350,3.4124946512623024,0.63362709427432917,105046,3.3652805384448863,0.50352903280171679]
[null,"2002-03   ",3.87775650696859,497890,3.0081721319954484,0.77575065030245205,107877,2.6950098052281857,0.40323998701302194]
[null,"2003-04   ",7.9665180177639652,519398,4.3198296812548955,0.54224815303529328,112684,4.4560008157438569,0.66672770822013028]
[null,"2004-05   ",7.0508896877923766,548115,5.5289007658866609,0.7841422871016086,118426,5.0956657555642328,0.76243737188275074]
[null,"2005-06   ",9.4771129651915675,578819,5.6017441595285664,0.59108129027301659,124287,4.9490821272355729,0.74050484300329988]
[null,"2006-07   ",9.5691366286585016,624495,7.8912406123503196,0.82465544370188326,132329,6.4705077763563361,0.96814767302290716]
[null,"2007-08   ",9.3220557720816384,664660,6.4315967301579677,0.68993330306173184,143061,8.1100892472549475,1.2134695303866019]
[null,"2008-09   ",6.7247749084081754,691038,3.968645623326212,0.59015293112102574,147966,3.4286073772726322,0.51300429096847278]
[null,"2009-10   ",8.5946584922701366,746644,8.0467354906676629,0.93624842661342922,159398,7.7260992390143679,1.1560151472390232]
[null,"2010-11   ",8.9,788355,5.5864642319498978,0.62769261033144919,173626,8.9260843925268833,1.3355625450924553]
[null,"2011-12   ",6.7,857886,8.8197575965142612,1.3163817308230241,199877,15.119279370601177,2.2622173786604325]
[null,"2012-13   ",4.5,908652,5.9175694672718748,1.3150154371715277,223344,11.740720543134026,1.7567015860768009]
[null,"2013-14",4.7,959829,5.632189220955877,1.1983381321182716,243028.95,8.8137357618740655,1.3187524168778988]
[null,"2014-15*",6.9,1048402.51,9.228051038257858,1.3373987011967909,267637.34999999998,10.125707245988579,1.5150557339157371]