{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Front page","Introduction","User Interface","Results","Finance","Technical data","CAPEX & OPEX","Exchange rate","Inflation","Sensitivity","Result tables","Data transformation ","Lists","Abbreviations"],"not_rendered":{"charts":15,"images":5,"macros":1,"external_links":0,"defined_names":144,"comments":0,"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":"Front page","index":0,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[48,4,49,9],[51,4,52,9],[32,4,33,9],[18,4,19,9],[21,4,22,9],[24,4,25,9],[29,4,30,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Navigation "]
[]
[null,"Main interface and output"]
[]
[null,null,null,null,"Gives an introduction to the model"]
[]
[]
[null,null,null,null,"Offers the user a variety of options for customizing input parameters and main results "]
[]
[]
[null,null,null,null,"Offers a variety of plots of sensitivity runs"]
[]
[]
[null,null,null,null,"A full financial model based annual figures including cash flows, profit loss statement and balance sheet"]
[]
[]
[null,"Input data"]
[]
[null,null,null,null,"Annual gross energy production and choice of technology"]
[]
[]
[null,null,null,null,"CAPEX and OPEX estimates and tax rates differentiable by CAPEX categories"]
[]
[]
[null,null,null,null,"Time series of exchange rate"]
[]
[]
[null,null,null,null,"Time series of projected inflation"]
[]
[]
[null,"Auxilliary input"]
[]
[null,null,null,null,"Definition of sensitivity runs and output from sensitivity runs"]
[]
[]
[null,"Data  transfomation sheets"]
[]
[null,null,null,null,"Tables with results from sensitivity anyses, organized for use in charts"]
[]
[]
[null,null,null,null,"Utility sheet which transform inputs for use in financial modelling. Sensitivity parameters are also included here"]

{"sheet":"Introduction","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Introduction"}]
[]
[]
[null,null,null,"Introduction to the spreadsheet/model"]
[]
[]
[]
[]
[]
[]
[]
[null,"Standards for cells"]
[]
[]
[null,null,null,"Text"]
[null,null,null,"Input data"]
[null,null,null,"Link to other cells"]
[null,null,null,"Formulas"]
[null,null,null,"Tentative data"]
[]
[]
[null,"Standards for sheets"]
[]
[]
[null,null,null,"Light blue sheets indicate that the user can enter data or verify existing data."]
[null,null,null,"Dark blue sheets indicate a user interface"]
[null,null,null,"White sheets are informational sheets for the user regarding the model."]
[null,null,null,"Orange sheets are the primary results."]
[null,null,null,"Black sheets are the secondary results."]
[null,null,null,"Neutral sheets are calculation sheets."]
[null,null,null,"Green sheets are modules with extra functionalities that can be used if desired."]

{"sheet":"User Interface","index":2,"n_rows":205,"n_cols":7,"rows_kept":205,"cut":false,"hidden":false,"merged":[[157,3,157,4],[163,3,163,4],[141,3,141,4],[142,3,142,4],[146,3,146,4],[145,3,145,4],[147,3,147,4],[75,3,75,4],[131,3,131,4],[132,3,132,4],[137,3,137,4],[140,3,140,4],[104,3,104,4],[89,3,89,4],[81,3,81,4],[82,3,82,4],[80,3,80,4],[88,3,88,4],[87,3,87,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[25,3,25,4],[64,3,64,4],[65,3,65,4],[70,3,70,4],[26,3,26,4],[20,3,20,4],[21,3,21,4],[28,3,28,4],[27,3,27,4]]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"User Interface"}]
[]
[]
[]
[]
[null,"Generation technology"]
[]
[null,"Technology",null,"Energy Production "]
[null,2,null,1]
[]
[null,"Dimensioning and timing"]
[]
[null,"Nominal capacity","MW",500]
[null,"1 st year of construction","Year",2025]
[null,"Construction time","Years",4]
[null,"Technical life","Years",{"$f":"'Technical data'!K13","v":27}]
[]
[]
[null,"Annual variation in AEP"]
[]
[null,"Annual variation in AEP",false,{"$f":"IF(C21=TRUE,\"Annual variation included\",\"Annual variation excluded\")","v":"Annual variation excluded"}]
[]
[]
[null,"Generation data check"]
[]
[null,"Net AEP after wake loss only","GWh",{"$f":"'Technical data'!I32*Nom_cap","v":2576.4299999999998}]
[null,"Capacity factor after wake loss only","%",{"$f":"Capacity_factor","v":0.58782340862422999}]
[null,"Net AEP after all losses","GWh",{"$f":"'Technical data'!$P$32","v":2344.5513000000001}]
[null,"Capacity factor after all losses","%",{"$f":"Capacity_factorall","v":0.53491930184804937}]
[]
[]
[null,"Investment expenditure"]
[]
[null,null,"Include","mINR","mUSD"]
[null,{"$f":"'CAPEX & OPEX'!D10","v":"DEVEX"},true,{"$f":"E35*Exchangerate","v":2875.5421523738414},{"$f":"'CAPEX & OPEX'!S10*C35","v":39.491769039010045}]
[null,{"$f":"'CAPEX & OPEX'!D11","v":"PM"},true,2703.102833673951,{"$f":"'CAPEX & OPEX'!S11*C36","v":37.123543018842504}]
[null,{"$f":"'CAPEX & OPEX'!D12","v":"Foundation"},true,6368.6034865783686,{"$f":"'CAPEX & OPEX'!S12*C37","v":87.464347474565997}]
[null,{"$f":"'CAPEX & OPEX'!D13","v":"WTG"},true,46651.826491510779,{"$f":"'CAPEX & OPEX'!S13*C38","v":640.70114761829916}]
[null,{"$f":"'CAPEX & OPEX'!D14","v":"Array cabling"},true,10253.148679452919,{"$f":"'CAPEX & OPEX'!S14*C39","v":140.81343903698883}]
[null,{"$f":"'CAPEX & OPEX'!D15","v":"Export system"},true,18036.220631583084,{"$f":"'CAPEX & OPEX'!S15*C40","v":247.7036404877939}]
[null,{"$f":"'CAPEX & OPEX'!D16","v":"Installation"},true,16871.09009982707,{"$f":"'CAPEX & OPEX'!S16*C41","v":231.70211332449972}]
[]
[null,"Total CAPEX (including VAT and duties)",null,{"$f":"E43*Exchangerate","v":103759.53437500002},{"$f":"SUM(E35:E41)","v":1425.0000000000002}]
[]
[]
[null,"Operational expenditure"]
[]
[null,null,"Include","INR/unit","USD/unit"]
[null,{"$f":"'CAPEX & OPEX'!D22","v":"USD/MWh"},false,{"$f":"E49*Exchangerate","v":0},{"$f":"'CAPEX & OPEX'!S22*C49","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D23","v":"USD/MWh"},false,0,{"$f":"'CAPEX & OPEX'!S23*C50","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D24","v":"USD/MWh"},false,0,{"$f":"'CAPEX & OPEX'!S24*C51","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D25","v":"USD/MW"},true,4638233.2208333332,{"$f":"'CAPEX & OPEX'!S25*C52","v":63700}]
[null,{"$f":"'CAPEX & OPEX'!D26","v":"USD/MW"},false,0,{"$f":"'CAPEX & OPEX'!S26*C53","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D27","v":"USD/MW"},false,0,{"$f":"'CAPEX & OPEX'!S27*C54","v":0}]
[]
[null,"Total variable OPEX",null,null,{"$f":"SUM(E49:E51)","v":0}]
[null,"Total fixed OPEX",null,{"$f":"E57*Exchangerate","v":4638233.2208333332},{"$f":"SUM(E52:E54)","v":63700}]
[]
[]
[null,"PPA contract"]
[]
[]
[null,"Indexing"]
[null,null,"Include",null,"level (% p.a.)"]
[null,"Indexing",false,0.03]
[null,"Duration of indexing (years)",null,15]
[]
[]
[null,"Payment schedule"]
[null,null,"Include"]
[null,"Time from delivery to payment (months)",false,12]
[]
[]
[null,"Curtailment"]
[]
[null,"Level of curtailment (% of Net AEP)",false,0.05]
[]
[]
[null,"Over-/underproduction "]
[null,null,"Include"]
[null,"Committed AEP (GWh)",null,{"$f":"'Technical data'!$P$28","v":2344.5513000000001}]
[null,"Percentage penalty for underproduction (% of Net AEP)",false,0.25]
[null,"Percentage penalty for overproduction (% of Net AEP)",false,0.25]
[]
[]
[null,"Late commissioning"]
[]
[null,"Delay in commissioning (months)",false,6]
[null,"Probability of delay (%)",null,0.5]
[null,"Expected delay in months",null,{"$f":"D88*D89*C88","v":0}]
[null,null,null,"Years             &","Months"]
[null,"Responding to",null,{"$f":"(Com_delay-E92)/12","v":0},{"$f":"ROUND(MOD(D90,12),0)","v":0}]
[]
[]
[null,"Government incentives"]
[]
[null,"Tax incentives"]
[]
[null,"VAT",false,{"$f":"IF(C99,B99&\" included\",B99&\" excluded\")","v":"VAT excluded"}]
[null,"Duties",false,{"$f":"IF(C100,B100&\" included\",B100&\" excluded\")","v":"Duties excluded"}]
[]
[]
[null,"Viability gap funding"]
[]
[null,{"$f":"B13&\" (\"&C13&\")\"","v":"Nominal capacity (MW)"},null,{"$f":"D13","v":500}]
[]
[null,null,null,"(INR/KWh)","(USD/KWh)"]
[null,"Set LCOE target",null,3,{"$f":"GS_Goal/Exchangerate","v":4.1201033001455195E-2}]
[]
[null,null,null,"(mINR)","(mUSD)"]
[null,"Investment subsidy",false,150341.5178374594,{"$f":"D111/Exchangerate","v":2064.74194597001}]
[null,"Subsidy share of CAPEX",null,null,{"$f":"IF(UF_Subsidy=TRUE,E111/Total_capex,\"\")","v":""}]
[]
[null,null,null,"(INR/MWh)","(USD/MWh)"]
[null,"GBI",false,3899.3525193154087,{"$f":"D115/Exchangerate","v":53.552450610873869}]
[]
[null,null,null,"(mINR)","(mUSD)"]
[null,"Max. annual subsidy budget for GBI",null,27460,{"$f":"D118/Exchangerate","v":377.12678873998658}]
[null,"Limit GBI commitment (years)",false,50]
[]
[null,"Find the goverment subsidy ",null,null,null,null,{"$f":"Lists!Q9","v":"Finance!K71"}]
[null,"Find the GBI ",null,null,null,null,{"$f":"Lists!Q5","v":"Results!C11"}]
[]
[null,"Fixed subsidy levels: ",null,null,null,null,{"$f":"Lists!Q8","v":"'User Interface'!D13"}]
[null,null,null,null,null,null,{"$f":"Lists!Q4","v":"'User Interface'!D111"}]
[null,null,null,null,null,null,{"$f":"Lists!Q12","v":"'User Interface'!D115"}]
[]
[null,"Financing"]
[]
[null,"Equity financing"]
[]
[null,"Cost of equity",null,0.1]
[null,"Equity share",null,0.25,null,null,{"$f":"IF(SUM(D133,D141,D146)=1,\"\",\"Financing shares do not sum to 100%\")","v":""}]
[]
[]
[null,"Loan financing"]
[]
[null,"Interest during construction",null,0.05]
[]
[null,"Senior"]
[null,"Financing share",null,0.75,null,null,{"$f":"G133","v":""}]
[null,"Interest rate",null,0.08]
[null,"Loan Tenor (years)",null,15]
[]
[null,"Subordinate"]
[null,"Financing share",null,null,null,null,{"$f":"G141","v":""}]
[null,"Interest rate",null,0.15]
[null,"Loan Tenor (years)",null,25]
[null,"Simple WACC",null,null,{"$f":"(D132*D133+D141*D142+D146*D147)","v":8.4999999999999992E-2}]
[null,"Time variant WACC",null,null,{"$f":"Finance!E20","v":9.0857725703423098E-2}]
[null,"Choice of WACC for NPV calculation",true,{"$f":"IF(C151,B149,B150)","v":"Simple WACC"}]
[]
[]
[]
[null,"Exchange rate"]
[]
[null,null,"Include","Percentage change"]
[null,"Exchange rate uncertainty",false,-0.08]
[]
[]
[]
[null,"Cash reserves"]
[]
[null,"Cash Reserve (% of CAPEX)",false,0.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1]

{"sheet":"Results","index":3,"n_rows":154,"n_cols":17,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Results"}]
[]
[null,"Main Results"]
[]
[null,"Key indicators",null,null,null,null,null,null,"Cost year"]
[null,null,"(million INR)","(million USD)",null,null,null,null,{"$f":"'User Interface'!D14","v":2025}]
[null,{"$f":"Finance!D68","v":"CAPEX/MW excl. Taxes"},{"$f":"Finance!F68","v":207.51906875000003},{"$f":"Finance!G68","v":2.85}]
[null,{"$f":"Finance!D69","v":"CAPEX/MW incl. Taxes"},{"$f":"Finance!F69","v":207.51906875000006},{"$f":"Finance!G69","v":2.8500000000000005}]
[null,null,"(INR/KWh)","(USD/KWh)"]
[null,{"$f":"Finance!D70","v":"First year OPEX/MWh"},{"$f":"Finance!F70/1000","v":1.2023199212746056},{"$f":"Finance!G70/1000","v":1.6512274251580677E-2}]
[null,{"$f":"Finance!D74","v":"LCoE (INR/kWh)"},{"$f":"Finance!F74","v":7.4265436059532233},{"$f":"Finance!G74","v":0.10199375606520827}]
[null,"CAPEX share of LCoE",{"$f":"Finance!F85","v":5.5211652687598978},{"$f":"Finance!G85","v":7.5825904148221601E-2}]
[null,"OPEX share of LCoE",{"$f":"Finance!F86","v":1.9053783371933273},{"$f":"Finance!G86","v":2.6167851916986694E-2}]
[null,{"$f":"Finance!D76","v":"Simple WACC"},{"$f":"'User Interface'!E149","v":8.4999999999999992E-2}]
[null,{"$f":"Finance!D81","v":"Mean Net Energy production incl. Curtailment (MWh)"},{"$f":"Finance!E81","v":2344.5513000000001},"(MWh)"]
[null,null,"(million INR)","(million USD)"]
[null,{"$f":"Finance!D82","v":"Total investment subsidy"},{"$f":"Finance!F82","v":0},{"$f":"Finance!G82","v":0}]
[null,{"$f":"Finance!D83","v":"Average annual GBI sudsidy"},{"$f":"Finance!F83","v":0},{"$f":"Finance!G83","v":0}]
[null,{"$f":"Finance!D84","v":"NPV of government funding"},{"$f":"Finance!F84","v":0},{"$f":"Finance!G84","v":0}]
[]
[]
[]
[null,"Plots & Results"]
[]
[null,"Sensitivity scenarios",null,null,null,null,null,null,null,"LCOE sensitivities"]
[]
[]
[null,"Running indicator",{"$f":"Scen","v":1},{"$f":"N_scen","v":96}]
[null,"min/max",1,72,null,null,null,null,null,null,{"$f":"\"LCoE - \"&'Technical data'!E$9","v":"LCoE - Offshore wind Gujarat"}]
[null,null,null," ",null,null,null,null,null,null,{"$f":"\"LCoE - \"&'Technical data'!F$9","v":"LCoE - Offshore wind Tamil Nadu Site B"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"LCoE - \"&'Technical data'!G$9","v":"LCoE - "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"LCoE - \"&'Technical data'!H$9","v":"LCoE - "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Decosting chart"]
[]
[]
[]
[]
[]
[null,null,"Scenario title","PPA tariff",null,"Empty","Filled"]
[null,null,"Worst case LCOE",11.280112638826573,null,{"$f":"0","v":0},{"$f":"D74","v":11.280112638826573}]
[null,null,"No indexing of PPA",10.344436471116616,null,{"$f":"D75","v":10.344436471116616},{"$f":"G74-F75","v":0.93567616770995699}]
[null,null,"Delay in payment",9.4784016383050567,null,{"$f":"D76","v":9.4784016383050567},{"$f":"F75-F76","v":0.86603483281155924}]
[null,null,"Energy commitment",9.0670147100519625,null,9.0670147100519625,{"$f":"F76-F77","v":0.4113869282530942}]
[null,null,"Curtailment",8.6136639745493664,null,{"$f":"D78","v":8.6136639745493664},0.45335073550259608]
[null,null,"Chance of delays",8.437394530542532,null,8.437394530542532,0.17626944400683442]
[null,null,"VAT",8.0356138386119333,null,8.0356138386119333,0.40178069193059862]
[null,null,"Duties",7.3465079360126753,null,7.3465079360126753,0.68910590259925808]
[null,null,"No GBI/subsidy",6.2706871506529618,null,6.2706871506529618,1.0758207853597135]
[null,null,"Decosted LCOE",{"$f":"D82","v":6.2706871506529618},null,0,6.2706871506529618]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Gujarat","Tamil Nadu"]
[null,null,null,14.045062662716772,10.234586153895]
[null,null,null,10.140659677066271,7.1616420192163979]
[null,null,null,9.3678149441720784,6.6158355835717302]
[null,null,null,8.8132666691470583,6.171840668035566]
[null,null,null,8.3726033356897052,5.8632486346337878]
[null,null,null,8.1952466671469573,5.7435075612776716]
[null,null,null,7.8049968258542464,5.4700072012168359]
[null,null,null,7.0517383042083184,4.9533144699644289]
[null,null,null,5.1396205184917285,3.6417098444775529]
[null,null,null,5.1396205184917285,3.6417098444775529]
[]
[]
[null,"Subsidy overview "]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Comparison of subsidy at \"&ROUND(Nom_cap,1)&\" MW capacity\"","v":"Comparison of subsidy at 500 MW capacity"}]
[null,null,null,null,null,null,null,null,null,"LCOE","GBI (NPV)","Investment subsidy (NPV)","LCOE target","LCOE target",null,"LCOE no.",{"$f":"COUNT($J$114:$J$154)","v":41}]
[null,null,"Warning: this may take some time to run",null,null,null,null,null,null,10,-65741.748633159528,-60086.84756752976,3,0,null,"LCOE row",41]
[null,null,null,null,null,null,null,null,null,9.75,-57200.217245002379,-52280.032184852287,3,{"$f":"MAX(K114:L154)","v":275919.50689313182}]
[null,null,null,null,null,null,null,null,null,9.5,-48658.685856844932,-44473.216802174546,3]
[null,null,null,null,null,null,null,null,null,9.25,-40117.154468687826,-36666.401419496848,3,null,null,"INR/KWh"]
[null,null,null,null,null,null,null,null,null,9,-31575.623080530357,-28859.586036819226,3,null,null,"mINR"]
[null,null,null,null,null,null,null,null,null,8.75,-23034.091692373069,-21052.770654141339,3]
[null,null,null,null,null,null,null,null,null,8.5,-14492.560304215893,-13245.955271463799,3]
[null,null,null,null,null,null,null,null,null,8.25,-5951.0289160585971,-5439.1398887863179,3]
[null,null,null,null,null,null,null,null,null,8,2590.5024720984002,2367.6754938915869,3]
[null,null,null,null,null,null,null,null,null,7.75,11132.033860256119,10174.490876569287,3]
[null,null,null,null,null,null,null,null,null,7.5,19673.565248413193,17981.30625924694,3]
[null,null,null,null,null,null,null,null,null,7.25,28215.096636570597,25788.12164192451,3]
[null,null,null,null,null,null,null,null,null,7,36756.628024727775,33594.937024602419,3]
[null,null,null,null,null,null,null,null,null,6.75,45298.159412885267,41401.752407280066,3]
[null,null,null,null,null,null,null,null,null,6.5,53839.690801042634,49208.567789957597,3]
[null,null,null,null,null,null,null,null,null,6.25,62381.222189199594,57015.383172635433,3]
[null,null,null,null,null,null,null,null,null,6,70922.75357735694,64822.198555313022,3]
[null,null,null,null,null,null,null,null,null,5.75,79464.284965514395,72629.013937990734,3]
[null,null,null,null,null,null,null,null,null,5.5,88005.816353671413,80435.829320668287,3]
[null,null,null,null,null,null,null,null,null,5.25,96547.347741828635,88242.644703346043,3]
[null,null,null,null,null,null,null,null,null,5,105088.87912998657,96049.460086023828,3]
[null,null,null,null,null,null,null,null,null,4.75,113630.4105181442,103856.27546870144,3]
[null,null,null,null,null,null,null,null,null,4.5,122171.94190630114,111663.09085137895,3]
[null,null,null,null,null,null,null,null,null,4.25,130713.47329445867,119469.90623405675,3]
[null,null,null,null,null,null,null,null,null,4,139255.0046826154,127276.72161673428,3]
[null,null,null,null,null,null,null,null,null,3.75,147796.5360707728,135083.53699941211,3]
[null,null,null,null,null,null,null,null,null,3.5,156338.0674589299,142890.3523820898,3]
[null,null,null,null,null,null,null,null,null,3.25,164879.5988470875,150697.16776476742,3]
[null,null,null,null,null,null,null,null,null,3,173421.1302352444,158503.98314744511,3]
[null,null,null,null,null,null,null,null,null,2.75,181962.66162340189,166310.79853012267,3]
[null,null,null,null,null,null,null,null,null,2.5,190504.19301155888,174117.61391280053,3]
[null,null,null,null,null,null,null,null,null,2.25,199045.72439971633,181924.42929547807,3]
[null,null,null,null,null,null,null,null,null,2,207587.25578787376,189731.24467815578,3]
[null,null,null,null,null,null,null,null,null,1.75,216128.78717603124,197538.06006083349,3]
[null,null,null,null,null,null,null,null,null,1.5,224670.31856418814,205344.87544351118,3]
[null,null,null,null,null,null,null,null,null,1.25,233211.84995234574,213151.6908261888,3]
[null,null,null,null,null,null,null,null,null,1,241753.38134050288,220958.50620886649,3]
[null,null,null,null,null,null,null,null,null,0.75,250294.91272866013,228765.32159154414,3]
[null,null,null,null,null,null,null,null,null,0.5,258836.44411681732,236572.13697422185,3]
[null,null,null,null,null,null,null,null,null,0.25,267377.9755049746,244378.95235689954,3]
[null,null,null,null,null,null,null,null,null,0,275919.50689313182,252185.76773957713,3]

{"sheet":"Finance","index":4,"n_rows":86,"n_cols":37,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Finance"}]
[]
[null,null,null,"Calender Year",null,{"$f":"[0]!constr_start","v":2025},{"$f":"F3+1","v":2026},{"$f":"G3+1","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056]
[null,null,null,"Project Phase",null,{"$f":"IF(AND(F5=1,delay_months>0)=TRUE,\"Development and market\",IF(F5<=0,INDEX(Phases,1),IF(F5<=T_life,INDEX(Phases,2),IF(F5<=T_life+1,INDEX(Phases,3),\"\"))))","v":"Development"},"Development","Development","Development","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Operation: Market","Liquidation"]
[null,null,null,"Model Period",null,{"$f":"IF(F3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!F3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":-3},{"$f":"IF(G3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!G3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":-2},{"$f":"IF(H3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!H3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":-1},{"$f":"IF(I3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!I3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":0},{"$f":"IF(J3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!J3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":1},{"$f":"IF(K3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!K3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":2},{"$f":"IF(L3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!L3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":3},{"$f":"IF(M3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!M3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":4},{"$f":"IF(N3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!N3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":5},{"$f":"IF(O3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!O3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":6},{"$f":"IF(P3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!P3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":7},{"$f":"IF(Q3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!Q3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":8},{"$f":"IF(R3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!R3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":9},{"$f":"IF(S3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!S3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":10},{"$f":"IF(T3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!T3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":11},{"$f":"IF(U3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!U3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":12},{"$f":"IF(V3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!V3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":13},{"$f":"IF(W3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!W3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":14},{"$f":"IF(X3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!X3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":15},{"$f":"IF(Y3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!Y3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":16},{"$f":"IF(Z3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!Z3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":17},{"$f":"IF(AA3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AA3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":18},{"$f":"IF(AB3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AB3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":19},{"$f":"IF(AC3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AC3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":20},{"$f":"IF(AD3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AD3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":21},{"$f":"IF(AE3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AE3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":22},{"$f":"IF(AF3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AF3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":23},{"$f":"IF(AG3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AG3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":24},{"$f":"IF(AH3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AH3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":25},{"$f":"IF(AI3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AI3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":26},{"$f":"IF(AJ3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AJ3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":27},{"$f":"IF(AK3<=constr_start+constr_dur+T_life+Delay_years,ROUND(Finance!AK3-(constr_start+constr_dur+Delay_years-1),0),\"\")","v":28}]
[null,null,null,"Project Phasing"]
[null,null,null,"Development",null,{"$f":"IF(F$4=$D7,1,0)","v":1},{"$f":"IF(G$4=$D7,1,0)","v":1},1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Operation: Market",null,{"$f":"IF(F$4=$D8,1,0)","v":0},0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[null,null,null,"Liquidation",null,{"$f":"IF(F$4=$D9,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,"Development and market",null,{"$f":"IF(F$4=$D10,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Loan Phasing"]
[null,null,null,"Senior debt repayment schedule dummy",null,{"$f":"IF(AND(F5>0,F5<=S_loan_tenure),1,0)","v":0},{"$f":"IF(AND(G5>0,G5<=S_loan_tenure),1,0)","v":0},0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Senior debt repayment period",null,{"$f":"IF(F12=1,SUM($F$12:F12),0)","v":0},{"$f":"IF(G12=1,SUM($F$12:G12),0)","v":0},{"$f":"IF(H12=1,SUM($F$12:H12),0)","v":0},{"$f":"IF(I12=1,SUM($F$12:I12),0)","v":0},{"$f":"IF(J12=1,SUM($F$12:J12),0)","v":1},{"$f":"IF(K12=1,SUM($F$12:K12),0)","v":2},{"$f":"IF(L12=1,SUM($F$12:L12),0)","v":3},{"$f":"IF(M12=1,SUM($F$12:M12),0)","v":4},{"$f":"IF(N12=1,SUM($F$12:N12),0)","v":5},{"$f":"IF(O12=1,SUM($F$12:O12),0)","v":6},{"$f":"IF(P12=1,SUM($F$12:P12),0)","v":7},{"$f":"IF(Q12=1,SUM($F$12:Q12),0)","v":8},{"$f":"IF(R12=1,SUM($F$12:R12),0)","v":9},{"$f":"IF(S12=1,SUM($F$12:S12),0)","v":10},{"$f":"IF(T12=1,SUM($F$12:T12),0)","v":11},{"$f":"IF(U12=1,SUM($F$12:U12),0)","v":12},{"$f":"IF(V12=1,SUM($F$12:V12),0)","v":13},{"$f":"IF(W12=1,SUM($F$12:W12),0)","v":14},{"$f":"IF(X12=1,SUM($F$12:X12),0)","v":15},{"$f":"IF(Y12=1,SUM($F$12:Y12),0)","v":0},{"$f":"IF(Z12=1,SUM($F$12:Z12),0)","v":0},{"$f":"IF(AA12=1,SUM($F$12:AA12),0)","v":0},{"$f":"IF(AB12=1,SUM($F$12:AB12),0)","v":0},{"$f":"IF(AC12=1,SUM($F$12:AC12),0)","v":0},{"$f":"IF(AD12=1,SUM($F$12:AD12),0)","v":0},{"$f":"IF(AE12=1,SUM($F$12:AE12),0)","v":0},{"$f":"IF(AF12=1,SUM($F$12:AF12),0)","v":0},{"$f":"IF(AG12=1,SUM($F$12:AG12),0)","v":0},{"$f":"IF(AH12=1,SUM($F$12:AH12),0)","v":0},{"$f":"IF(AI12=1,SUM($F$12:AI12),0)","v":0},{"$f":"IF(AJ12=1,SUM($F$12:AJ12),0)","v":0},{"$f":"IF(AK12=1,SUM($F$12:AK12),0)","v":0}]
[null,null,null,"Junior debt repayment schedule dummy",null,{"$f":"IF(AND(F5>0,F5<=J_loan_tenure),1,0)","v":0},0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0]
[null,null,null,"Junior debt repayment period",null,{"$f":"IF(F14=1,SUM($F$14:F14),0)","v":0},{"$f":"IF(G14=1,SUM($F$14:G14),0)","v":0},{"$f":"IF(H14=1,SUM($F$14:H14),0)","v":0},{"$f":"IF(I14=1,SUM($F$14:I14),0)","v":0},{"$f":"IF(J14=1,SUM($F$14:J14),0)","v":1},{"$f":"IF(K14=1,SUM($F$14:K14),0)","v":2},{"$f":"IF(L14=1,SUM($F$14:L14),0)","v":3},{"$f":"IF(M14=1,SUM($F$14:M14),0)","v":4},{"$f":"IF(N14=1,SUM($F$14:N14),0)","v":5},{"$f":"IF(O14=1,SUM($F$14:O14),0)","v":6},{"$f":"IF(P14=1,SUM($F$14:P14),0)","v":7},{"$f":"IF(Q14=1,SUM($F$14:Q14),0)","v":8},{"$f":"IF(R14=1,SUM($F$14:R14),0)","v":9},{"$f":"IF(S14=1,SUM($F$14:S14),0)","v":10},{"$f":"IF(T14=1,SUM($F$14:T14),0)","v":11},{"$f":"IF(U14=1,SUM($F$14:U14),0)","v":12},{"$f":"IF(V14=1,SUM($F$14:V14),0)","v":13},{"$f":"IF(W14=1,SUM($F$14:W14),0)","v":14},{"$f":"IF(X14=1,SUM($F$14:X14),0)","v":15},{"$f":"IF(Y14=1,SUM($F$14:Y14),0)","v":16},{"$f":"IF(Z14=1,SUM($F$14:Z14),0)","v":17},{"$f":"IF(AA14=1,SUM($F$14:AA14),0)","v":18},{"$f":"IF(AB14=1,SUM($F$14:AB14),0)","v":19},{"$f":"IF(AC14=1,SUM($F$14:AC14),0)","v":20},{"$f":"IF(AD14=1,SUM($F$14:AD14),0)","v":21},{"$f":"IF(AE14=1,SUM($F$14:AE14),0)","v":22},{"$f":"IF(AF14=1,SUM($F$14:AF14),0)","v":23},{"$f":"IF(AG14=1,SUM($F$14:AG14),0)","v":24},{"$f":"IF(AH14=1,SUM($F$14:AH14),0)","v":25},{"$f":"IF(AI14=1,SUM($F$14:AI14),0)","v":0},{"$f":"IF(AJ14=1,SUM($F$14:AJ14),0)","v":0},{"$f":"IF(AK14=1,SUM($F$14:AK14),0)","v":0}]
[null,null,null,"Interest and inflation"]
[null,null,null,"Indexing",null,{"$f":"IF(AND(F8+F10=1,Inf_OPEX_factor,F$3<$F$3+constr_dur+indexing_duration),indexing_level,0)","v":0},0,0,{"$f":"IF(AND(I8+I10=1,Inf_OPEX_factor,I$3<$F$3+constr_dur+indexing_duration),indexing_level,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inflation index (CPI) ",null,1,{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,G3-Inflation!$D$4+1)/100*(G7+G10+G8)-G17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,H3-Inflation!$D$4+1)/100*(H7+H10+H8)-H17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,I3-Inflation!$D$4+1)/100*(I7+I10+I8)-I17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,J3-Inflation!$D$4+1)/100*(J7+J10+J8)-J17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,K3-Inflation!$D$4+1)/100*(K7+K10+K8)-K17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,L3-Inflation!$D$4+1)/100*(L7+L10+L8)-L17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,M3-Inflation!$D$4+1)/100*(M7+M10+M8)-M17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,N3-Inflation!$D$4+1)/100*(N7+N10+N8)-N17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,O3-Inflation!$D$4+1)/100*(O7+O10+O8)-O17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,P3-Inflation!$D$4+1)/100*(P7+P10+P8)-P17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,Q3-Inflation!$D$4+1)/100*(Q7+Q10+Q8)-Q17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,R3-Inflation!$D$4+1)/100*(R7+R10+R8)-R17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,S3-Inflation!$D$4+1)/100*(S7+S10+S8)-S17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,T3-Inflation!$D$4+1)/100*(T7+T10+T8)-T17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,U3-Inflation!$D$4+1)/100*(U7+U10+U8)-U17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,V3-Inflation!$D$4+1)/100*(V7+V10+V8)-V17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,W3-Inflation!$D$4+1)/100*(W7+W10+W8)-W17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,X3-Inflation!$D$4+1)/100*(X7+X10+X8)-X17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,Y3-Inflation!$D$4+1)/100*(Y7+Y10+Y8)-Y17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,Z3-Inflation!$D$4+1)/100*(Z7+Z10+Z8)-Z17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AA3-Inflation!$D$4+1)/100*(AA7+AA10+AA8)-AA17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AB3-Inflation!$D$4+1)/100*(AB7+AB10+AB8)-AB17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AC3-Inflation!$D$4+1)/100*(AC7+AC10+AC8)-AC17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AD3-Inflation!$D$4+1)/100*(AD7+AD10+AD8)-AD17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AE3-Inflation!$D$4+1)/100*(AE7+AE10+AE8)-AE17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AF3-Inflation!$D$4+1)/100*(AF7+AF10+AF8)-AF17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AG3-Inflation!$D$4+1)/100*(AG7+AG10+AG8)-AG17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AH3-Inflation!$D$4+1)/100*(AH7+AH10+AH8)-AH17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AI3-Inflation!$D$4+1)/100*(AI7+AI10+AI8)-AI17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AJ3-Inflation!$D$4+1)/100*(AJ7+AJ10+AJ8)-AJ17","v":1.05},{"$f":"1+INDEX(Inflation!$D$4:$BM$5,2,AK3-Inflation!$D$4+1)/100*(AK7+AK10+AK8)-AK17","v":1}]
[null,null,null,"WACC",null,{"$f":"IF(F5<MAX(S_loan_tenure,J_loan_tenure),IF(F$5<1,Const_I*(1-Equity_S)+Equity_I*Equity_S,WACC),Equity_I)*SUM(F7:F10)","v":6.7500000000000004E-2},6.7500000000000004E-2,6.7500000000000004E-2,6.7500000000000004E-2,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.12,0.12,0.12,0.12]
[null,null,null,"Compound WACC",{"$f":"PRODUCT(F20:AK20)^(1/COUNT(F5:AK5))-1","v":9.0857725703423098E-2},{"$f":"1+F19","v":1.0674999999999999},{"$f":"1+G19","v":1.0674999999999999},1.0674999999999999,1.0674999999999999,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,{"$f":"1+W19","v":1.0900000000000001},1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.0900000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001]
[null,null,null,"Discount factor",1,{"$f":"1/(1+E19)*E$21*SUM(F7:F10)","v":1},0.93676814988290402,0.87753456663503893,0.82204643244500142,0.77006691563934559,0.7064834088434363,0.64814991637012498,0.59463295079827971,0.54553481724612818,0.50049065802397075,0.45916574130639515,0.42125297367559184,0.38647061805100164,0.35456020004679045,0.32528458719889031,0.29842622678797276,0.27378552916327775,0.25117938455346583,0.2304398023426292,0.2114126626996598,0.19395657128409155,0.17794180851751518,0.16324936561239922,0.14977006019486166,0.13740372494941436,0.12605846325634343,0.11564996629022332,0.10610088650479203,9.7340262848433057E-2,8.6910948971815227E-2,7.759906158197788E-2,6.928487641248024E-2]
[null,null,null,"GBI"]
[null,null,null,"GBI limit","USD/MWh",{"$f":"IFERROR(IF(GBI_yn>0,IF(GBI_y-F5>=0,GBI,0)*IF(F5<=0,0,1),GBI*IF(F5<=0,0,1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Flows"]
[null,null,null,"Net energy production","MWh",{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(F3,'Technical data'!$K$37:$K$68,0))*1000*(F8+F10)*(1+Sensitivity!$F$8)","v":0},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(G3,'Technical data'!$K$37:$K$68,0))*1000*(G8+G10)*(1+Sensitivity!$F$8)","v":0},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(H3,'Technical data'!$K$37:$K$68,0))*1000*(H8+H10)*(1+Sensitivity!$F$8)","v":0},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(I3,'Technical data'!$K$37:$K$68,0))*1000*(I8+I10)*(1+Sensitivity!$F$8)","v":0},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(J3,'Technical data'!$K$37:$K$68,0))*1000*(J8+J10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(K3,'Technical data'!$K$37:$K$68,0))*1000*(K8+K10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(L3,'Technical data'!$K$37:$K$68,0))*1000*(L8+L10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(M3,'Technical data'!$K$37:$K$68,0))*1000*(M8+M10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(N3,'Technical data'!$K$37:$K$68,0))*1000*(N8+N10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(O3,'Technical data'!$K$37:$K$68,0))*1000*(O8+O10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(P3,'Technical data'!$K$37:$K$68,0))*1000*(P8+P10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(Q3,'Technical data'!$K$37:$K$68,0))*1000*(Q8+Q10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(R3,'Technical data'!$K$37:$K$68,0))*1000*(R8+R10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(S3,'Technical data'!$K$37:$K$68,0))*1000*(S8+S10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(T3,'Technical data'!$K$37:$K$68,0))*1000*(T8+T10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(U3,'Technical data'!$K$37:$K$68,0))*1000*(U8+U10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(V3,'Technical data'!$K$37:$K$68,0))*1000*(V8+V10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(W3,'Technical data'!$K$37:$K$68,0))*1000*(W8+W10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(X3,'Technical data'!$K$37:$K$68,0))*1000*(X8+X10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(Y3,'Technical data'!$K$37:$K$68,0))*1000*(Y8+Y10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(Z3,'Technical data'!$K$37:$K$68,0))*1000*(Z8+Z10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AA3,'Technical data'!$K$37:$K$68,0))*1000*(AA8+AA10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AB3,'Technical data'!$K$37:$K$68,0))*1000*(AB8+AB10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AC3,'Technical data'!$K$37:$K$68,0))*1000*(AC8+AC10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AD3,'Technical data'!$K$37:$K$68,0))*1000*(AD8+AD10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AE3,'Technical data'!$K$37:$K$68,0))*1000*(AE8+AE10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AF3,'Technical data'!$K$37:$K$68,0))*1000*(AF8+AF10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AG3,'Technical data'!$K$37:$K$68,0))*1000*(AG8+AG10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AH3,'Technical data'!$K$37:$K$68,0))*1000*(AH8+AH10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AI3,'Technical data'!$K$37:$K$68,0))*1000*(AI8+AI10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AJ3,'Technical data'!$K$37:$K$68,0))*1000*(AJ8+AJ10)*(1+Sensitivity!$F$8)","v":2344551.3000000003},{"$f":"INDEX('Technical data'!$P$37:$P$68,MATCH(AK3,'Technical data'!$K$37:$K$68,0))*1000*(AK8+AK10)*(1+Sensitivity!$F$8)","v":0}]
[null,null,null,"Net energy production inkl. Late comisisoning","MWh",{"$f":"F25*(12-delay_months)/12+IFERROR(E25*delay_months/12,0)","v":0},0,0,0,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,0]
[null,null,null,"Comitted AEP","Mwh",{"$f":"IFERROR(_xlfn.IFS(F8=1,Comitted_AEP,F10=1,(12-delay_months)/12*Comitted_AEP,F9=1,(delay_months)/12*Comitted_AEP),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total overproduction","MWh",{"$f":"IF(F26>F27,(F26-F27)*Over_penalty,0)","v":0},0,0,{"$f":"IF(I26>I27,(I26-I27)*Over_penalty,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Z26>Z27,(Z26-Z27)*Over_penalty,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total underproduction","MWh",{"$f":"IF(F26<>0,(IF(F26<F27,(F27-F26)*Under_penalty,0)),0)","v":0},{"$f":"IF(G26<>0,(IF(G26<G27,(G27-G26)*Under_penalty,0)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Net energy production corrected for over and underproduction","Mwh",{"$f":"F26-F28-F29","v":0},{"$f":"G26-G28-G29","v":0},0,{"$f":"I26-I28-I29","v":0},2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,{"$f":"Z26-Z28-Z29","v":2344551.3000000003},{"$f":"AA26-AA28-AA29","v":2344551.3000000003},2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,0]
[null,null,null,"Net energy production incl. Curtailment","MWh",{"$f":"F30*(1-Level_curtailment)","v":0},{"$f":"G30*(1-Level_curtailment)","v":0},0,0,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,0]
[null,null,null,"Net energy production including payment lag","MWh",{"$f":"(F31*((12-Payment_lag)/12)+IFERROR(E31*(Payment_lag/12),0))","v":0},0,0,0,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,2344551.3000000003,0]
[]
[null,"Operating Cash Flow"]
[]
[]
[null,null,null,"Operating Costs"]
[null,null,null,"Variable OPEX",{"$f":"intl_currency","v":"USD"},{"$f":"-Total_var_opex*PRODUCT($F$18:F$18)*F26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:G$18)*G26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:H$18)*H26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:I$18)*I26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:J$18)*J26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:K$18)*K26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:L$18)*L26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:M$18)*M26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:N$18)*N26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:O$18)*O26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:P$18)*P26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:Q$18)*Q26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:R$18)*R26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:S$18)*S26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:T$18)*T26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:U$18)*U26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:V$18)*V26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:W$18)*W26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:X$18)*X26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:Y$18)*Y26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:Z$18)*Z26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AA$18)*AA26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AB$18)*AB26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AC$18)*AC26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AD$18)*AD26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AE$18)*AE26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AF$18)*AF26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AG$18)*AG26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AH$18)*AH26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AI$18)*AI26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AJ$18)*AJ26*(1+P_90_low*Exchange_choice)","v":0},{"$f":"-Total_var_opex*PRODUCT($F$18:AK$18)*AK26*(1+P_90_low*Exchange_choice)","v":0}]
[null,null,null,"GBI","USD",{"$f":"F23*F26*(1+P_90_low*Exchange_choice)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Fixed OPEX",{"$f":"intl_currency","v":"USD"},{"$f":"(-Total_fix_opex*NCAP*SUM(F8:F8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:F18)","v":0},{"$f":"(-Total_fix_opex*NCAP*SUM(G8:G8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:G18)","v":0},{"$f":"(-Total_fix_opex*NCAP*SUM(H8:H8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:H18)","v":0},{"$f":"(-Total_fix_opex*NCAP*SUM(I8:I8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:I18)","v":0},{"$f":"(-Total_fix_opex*NCAP*SUM(J8:J8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:J18)","v":-38713874.062500007},{"$f":"(-Total_fix_opex*NCAP*SUM(K8:K8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:K18)","v":-40649567.765625015},{"$f":"(-Total_fix_opex*NCAP*SUM(L8:L8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:L18)","v":-42682046.153906263},{"$f":"(-Total_fix_opex*NCAP*SUM(M8:M8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:M18)","v":-44816148.461601578},{"$f":"(-Total_fix_opex*NCAP*SUM(N8:N8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:N18)","v":-47056955.884681657},{"$f":"(-Total_fix_opex*NCAP*SUM(O8:O8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:O18)","v":-49409803.678915739},{"$f":"(-Total_fix_opex*NCAP*SUM(P8:P8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:P18)","v":-51880293.862861529},{"$f":"(-Total_fix_opex*NCAP*SUM(Q8:Q8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:Q18)","v":-54474308.556004606},{"$f":"(-Total_fix_opex*NCAP*SUM(R8:R8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:R18)","v":-57198023.983804844},{"$f":"(-Total_fix_opex*NCAP*SUM(S8:S8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:S18)","v":-60057925.182995088},{"$f":"(-Total_fix_opex*NCAP*SUM(T8:T8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:T18)","v":-63060821.442144848},{"$f":"(-Total_fix_opex*NCAP*SUM(U8:U8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:U18)","v":-66213862.514252096},{"$f":"(-Total_fix_opex*NCAP*SUM(V8:V8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:V18)","v":-69524555.6399647},{"$f":"(-Total_fix_opex*NCAP*SUM(W8:W8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:W18)","v":-73000783.421962947},{"$f":"(-Total_fix_opex*NCAP*SUM(X8:X8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:X18)","v":-76650822.59306109},{"$f":"(-Total_fix_opex*NCAP*SUM(Y8:Y8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:Y18)","v":-80483363.722714141},{"$f":"(-Total_fix_opex*NCAP*SUM(Z8:Z8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:Z18)","v":-84507531.908849865},{"$f":"(-Total_fix_opex*NCAP*SUM(AA8:AA8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AA18)","v":-88732908.504292369},{"$f":"(-Total_fix_opex*NCAP*SUM(AB8:AB8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AB18)","v":-93169553.929506987},{"$f":"(-Total_fix_opex*NCAP*SUM(AC8:AC8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AC18)","v":-97828031.625982344},{"$f":"(-Total_fix_opex*NCAP*SUM(AD8:AD8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AD18)","v":-102719433.20728147},{"$f":"(-Total_fix_opex*NCAP*SUM(AE8:AE8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AE18)","v":-107855404.86764553},{"$f":"(-Total_fix_opex*NCAP*SUM(AF8:AF8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AF18)","v":-113248175.11102781},{"$f":"(-Total_fix_opex*NCAP*SUM(AG8:AG8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AG18)","v":-118910583.8665792},{"$f":"(-Total_fix_opex*NCAP*SUM(AH8:AH8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AH18)","v":-124856113.05990818},{"$f":"(-Total_fix_opex*NCAP*SUM(AI8:AI8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AI18)","v":-131098918.71290359},{"$f":"(-Total_fix_opex*NCAP*SUM(AJ8:AJ8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AJ18)","v":-137653864.64854878},{"$f":"(-Total_fix_opex*NCAP*SUM(AK8:AK8))*(1+P_90_low*Exchange_choice)*PRODUCT($F$18:AK18)","v":0}]
[null,null,null,"Total Operation Costs",null,{"$f":"SUM(F38:F40)","v":0},0,0,{"$f":"SUM(I38:I40)","v":0},-38713874.062500007,-40649567.765625015,-42682046.153906263,-44816148.461601578,-47056955.884681657,-49409803.678915739,-51880293.862861529,-54474308.556004606,-57198023.983804844,-60057925.182995088,-63060821.442144848,-66213862.514252096,-69524555.6399647,-73000783.421962947,-76650822.59306109,-80483363.722714141,-84507531.908849865,-88732908.504292369,-93169553.929506987,-97828031.625982344,-102719433.20728147,-107855404.86764553,-113248175.11102781,-118910583.8665792,-124856113.05990818,-131098918.71290359,-137653864.64854878,0]
[null,null,null,"First year of operation ","USD/MWh",{"$f":"IFERROR((F38+F40)/F32,0)","v":0},{"$f":"IFERROR((G38+G40)/G32,0)","v":0},0,0,-16.512274251580678,-17.337887964159712,-18.204782362367698,-19.115021480486085,-20.070772554510388,-21.074311182235906,-22.128026741347703,-23.234428078415089,-24.396149482335847,-25.615956956452639,-26.896754804275275,-28.241592544489041,-29.653672171713492,-31.136355780299173,-32.693173569314126,-34.327832247779831,-36.044223860168835,-37.846435053177281,-39.73875680583614,-41.725694646127955,-43.811979378434351,-46.002578347356071,-48.302707264723871,-50.717842627960067,-53.253734759358075,-55.916421497325977,-58.712242572192288,0]
[null,null,null,"First year of operation ","INR/MWh",{"$f":"F42*Exchangerate","v":0},0,0,0,-1202.3199212746056,-1262.4359173383359,-1325.5577132052526,-1391.8355988655155,-1461.427378808791,-1534.4987477492305,-1611.2236851366922,-1691.7848693935268,-1776.3741128632034,-1865.1928185063637,-1958.4524594316822,-2056.3750824032663,-2159.1938365234296,-2267.1535283496014,-2380.5112047670814,-2499.536765005435,-2624.5136032557079,-2755.7392834184934,-2893.5262475894178,-3038.2025599688895,-3190.1126879673338,-3349.6183223657004,-3517.0992384839851,-3692.9542004081845,-3877.6019104285942,-4071.4820059500239,-4275.0561062475263,0]
[]
[null,"Investing Cash Flow"]
[]
[null,null,null,"Investment Costs"]
[null,null,null,"Development dummie (incl. Delayed commision)",null,{"$f":"IF(F5<=0,1,IF(AND(F5=1,delay_months>0),1,0))","v":1},1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CAPEX",{"$f":"intl_currency","v":"USD"},{"$f":"-(IF(F5<=0,Total_capex/constr_dur,0)-IF(F5<=0,ITC_PCT/constr_dur,0))*10^6","v":-356250000.00000006},-356250000.00000006,-356250000.00000006,-356250000.00000006,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CAPEX incl. Delayed commision","USD",{"$f":"IF(F7=1,F49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:E50))","v":-356250000.00000006},{"$f":"IF(G7=1,G49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:F50))","v":-356250000.00000006},{"$f":"IF(H7=1,H49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:G50))","v":-356250000.00000006},{"$f":"IF(I7=1,I49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:H50))","v":-356250000.00000006},{"$f":"IF(J7=1,J49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:I50))","v":0},{"$f":"IF(K7=1,K49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:J50))","v":0},{"$f":"IF(L7=1,L49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:K50))","v":0},{"$f":"IF(M7=1,M49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:L50))","v":0},{"$f":"IF(N7=1,N49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:M50))","v":0},{"$f":"IF(O7=1,O49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:N50))","v":0},{"$f":"IF(P7=1,P49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:O50))","v":0},{"$f":"IF(Q7=1,Q49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:P50))","v":0},{"$f":"IF(R7=1,R49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:Q50))","v":0},{"$f":"IF(S7=1,S49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:R50))","v":0},{"$f":"IF(T7=1,T49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:S50))","v":0},{"$f":"IF(U7=1,U49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:T50))","v":0},{"$f":"IF(V7=1,V49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:U50))","v":0},{"$f":"IF(W7=1,W49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:V50))","v":0},{"$f":"IF(X7=1,X49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:W50))","v":0},{"$f":"IF(Y7=1,Y49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:X50))","v":0},{"$f":"IF(Z7=1,Z49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:Y50))","v":0},{"$f":"IF(AA7=1,AA49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:Z50))","v":0},{"$f":"IF(AB7=1,AB49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AA50))","v":0},{"$f":"IF(AC7=1,AC49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AB50))","v":0},{"$f":"IF(AD7=1,AD49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AC50))","v":0},{"$f":"IF(AE7=1,AE49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AD50))","v":0},{"$f":"IF(AF7=1,AF49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AE50))","v":0},{"$f":"IF(AG7=1,AG49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AF50))","v":0},{"$f":"IF(AH7=1,AH49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AG50))","v":0},{"$f":"IF(AI7=1,AI49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AH50))","v":0},{"$f":"IF(AJ7=1,AJ49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AI50))","v":0},{"$f":"IF(AK7=1,AK49*constr_dur*12/(constr_dur*12+delay_months),SUM($F$49:$AK$49)-SUM($E$50:AJ50))","v":0}]
[null,null,null,"Interest during construction","USD",{"$f":"IFERROR((SUM($F$50:F50)*(1-Equity_S)+SUM($E$51:E51))*Const_I,0)*F48","v":-13359375.000000004},{"$f":"IFERROR((SUM($F$50:G50)*(1-Equity_S)+SUM($E$51:F51))*Const_I,0)*G48","v":-27386718.750000007},{"$f":"IFERROR((SUM($F$50:H50)*(1-Equity_S)+SUM($E$51:G51))*Const_I,0)*H48","v":-42115429.687500015},{"$f":"IFERROR((SUM($F$50:I50)*(1-Equity_S)+SUM($E$51:H51))*Const_I,0)*I48","v":-57580576.171875015},{"$f":"IFERROR((SUM($F$50:J50)*(1-Equity_S)+SUM($E$51:I51))*Const_I,0)*J48","v":0},{"$f":"IFERROR((SUM($F$50:K50)*(1-Equity_S)+SUM($E$51:J51))*Const_I,0)*K48","v":0},{"$f":"IFERROR((SUM($F$50:L50)*(1-Equity_S)+SUM($E$51:K51))*Const_I,0)*L48","v":0},{"$f":"IFERROR((SUM($F$50:M50)*(1-Equity_S)+SUM($E$51:L51))*Const_I,0)*M48","v":0},{"$f":"IFERROR((SUM($F$50:N50)*(1-Equity_S)+SUM($E$51:M51))*Const_I,0)*N48","v":0},{"$f":"IFERROR((SUM($F$50:O50)*(1-Equity_S)+SUM($E$51:N51))*Const_I,0)*O48","v":0},{"$f":"IFERROR((SUM($F$50:P50)*(1-Equity_S)+SUM($E$51:O51))*Const_I,0)*P48","v":0},{"$f":"IFERROR((SUM($F$50:Q50)*(1-Equity_S)+SUM($E$51:P51))*Const_I,0)*Q48","v":0},{"$f":"IFERROR((SUM($F$50:R50)*(1-Equity_S)+SUM($E$51:Q51))*Const_I,0)*R48","v":0},{"$f":"IFERROR((SUM($F$50:S50)*(1-Equity_S)+SUM($E$51:R51))*Const_I,0)*S48","v":0},{"$f":"IFERROR((SUM($F$50:T50)*(1-Equity_S)+SUM($E$51:S51))*Const_I,0)*T48","v":0},{"$f":"IFERROR((SUM($F$50:U50)*(1-Equity_S)+SUM($E$51:T51))*Const_I,0)*U48","v":0},{"$f":"IFERROR((SUM($F$50:V50)*(1-Equity_S)+SUM($E$51:U51))*Const_I,0)*V48","v":0},{"$f":"IFERROR((SUM($F$50:W50)*(1-Equity_S)+SUM($E$51:V51))*Const_I,0)*W48","v":0},{"$f":"IFERROR((SUM($F$50:X50)*(1-Equity_S)+SUM($E$51:W51))*Const_I,0)*X48","v":0},{"$f":"IFERROR((SUM($F$50:Y50)*(1-Equity_S)+SUM($E$51:X51))*Const_I,0)*Y48","v":0},{"$f":"IFERROR((SUM($F$50:Z50)*(1-Equity_S)+SUM($E$51:Y51))*Const_I,0)*Z48","v":0},{"$f":"IFERROR((SUM($F$50:AA50)*(1-Equity_S)+SUM($E$51:Z51))*Const_I,0)*AA48","v":0},{"$f":"IFERROR((SUM($F$50:AB50)*(1-Equity_S)+SUM($E$51:AA51))*Const_I,0)*AB48","v":0},{"$f":"IFERROR((SUM($F$50:AC50)*(1-Equity_S)+SUM($E$51:AB51))*Const_I,0)*AC48","v":0},{"$f":"IFERROR((SUM($F$50:AD50)*(1-Equity_S)+SUM($E$51:AC51))*Const_I,0)*AD48","v":0},{"$f":"IFERROR((SUM($F$50:AE50)*(1-Equity_S)+SUM($E$51:AD51))*Const_I,0)*AE48","v":0},{"$f":"IFERROR((SUM($F$50:AF50)*(1-Equity_S)+SUM($E$51:AE51))*Const_I,0)*AF48","v":0},{"$f":"IFERROR((SUM($F$50:AG50)*(1-Equity_S)+SUM($E$51:AF51))*Const_I,0)*AG48","v":0},{"$f":"IFERROR((SUM($F$50:AH50)*(1-Equity_S)+SUM($E$51:AG51))*Const_I,0)*AH48","v":0},{"$f":"IFERROR((SUM($F$50:AI50)*(1-Equity_S)+SUM($E$51:AH51))*Const_I,0)*AI48","v":0},{"$f":"IFERROR((SUM($F$50:AJ50)*(1-Equity_S)+SUM($E$51:AI51))*Const_I,0)*AJ48","v":0},{"$f":"IFERROR((SUM($F$50:AK50)*(1-Equity_S)+SUM($E$51:AJ51))*Const_I,0)*AK48","v":0}]
[null,null,null,"Initial funding of DSRA","USD",{"$f":"F49*Cash_percentage","v":0},{"$f":"G49*Cash_percentage","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Investment Costs","USD",{"$f":"SUM(F50:F52)","v":-369609375.00000006},{"$f":"SUM(G50:G52)","v":-383636718.75000006},-398365429.68750006,-413830576.17187506,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total costs",null,{"$f":"F41+F53","v":-369609375.00000006},{"$f":"G41+G53","v":-383636718.75000006},-398365429.68750006,-413830576.17187506,-38713874.062500007,-40649567.765625015,-42682046.153906263,-44816148.461601578,-47056955.884681657,-49409803.678915739,-51880293.862861529,-54474308.556004606,-57198023.983804844,-60057925.182995088,-63060821.442144848,-66213862.514252096,-69524555.6399647,-73000783.421962947,-76650822.59306109,-80483363.722714141,-84507531.908849865,-88732908.504292369,-93169553.929506987,-97828031.625982344,-102719433.20728147,-107855404.86764553,-113248175.11102781,-118910583.8665792,-124856113.05990818,-131098918.71290359,-137653864.64854878,0]
[]
[null,"Public funding"]
[]
[null,null,null,"Funding cash flow"]
[null,null,null,"Investment subsidy",null,{"$f":"IF(F5<=0,ITC_PCT/constr_dur,0)*10^6","v":0},{"$f":"IF(G5<=0,ITC_PCT/constr_dur,0)*10^6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"GBI",null,{"$f":"F23*F26*(1+P_90_low*Exchange_choice)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",null,{"$f":"SUM(F60:F61)","v":0},{"$f":"SUM(G60:G61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Outputs and Charts"]
[]
[null,null,null,"Key indicators",null,"INR","USD",null,null,"Capacity macro support","mINR","mUSD"]
[null,null,null,"NPV Net energy production (MWh)",{"$f":"IF(WACC_choice,(NPV(WACC,F32:AK32)),SUMPRODUCT($F$32:$AK$32,$F$21:$AK$21))","v":16653540.130725892},null,null,"(MWh)",null,"Subsidy max",{"$f":"L67*Exchangerate","v":27460.000000000004},{"$f":"'User Interface'!E118","v":377.12678873998658}]
[null,null,null,"CAPEX/MW excl. Taxes",null,{"$f":"G68*Exchangerate","v":207.51906875000003},{"$f":"'CAPEX & OPEX'!I17","v":2.85},"(currency/MW)"]
[null,null,null,"CAPEX/MW incl. Taxes",null,{"$f":"G69*Exchangerate","v":207.51906875000006},{"$f":"'CAPEX & OPEX'!S17","v":2.8500000000000005},"(currency/MW)"]
[null,null,null,"First year OPEX/MWh",null,{"$f":"-INDEX(F43:AK43,MATCH(1,F5:AK5,1))","v":1202.3199212746056},{"$f":"-INDEX(F42:AK42,MATCH(1,F5:AK5,1))","v":16.512274251580678},"(currency/MWh)"]
[null,null,null,"NPV Total operating cost (million currency)",null,{"$f":"-IF(WACC_choice,(NPV(WACC,F41:AK41)),SUMPRODUCT($F$41:$AK$41,$F$21:$AK$21))*Exchangerate/10^6","v":31731.294602664842},{"$f":"-IF(WACC_choice,(NPV(WACC,F41:AK41)),SUMPRODUCT($F$41:$AK$41,$F$21:$AK$21))/10^6","v":435.7873720344304},"(million currency)",null,"Average annual subsidy",{"$f":"L71*Exchangerate","v":0},{"$f":"IFERROR(AVERAGEIFS(F62:AK62,F62:AK62,\">0\")/1000000,0)","v":0}]
[null,null,null,"NPV investment cost (million currency)",null,{"$f":"-IF(WACC_choice,(NPV(WACC,F53:AK53)),SUMPRODUCT($F$53:$AK$53,$F$21:$AK$21))*Exchangerate/10^6","v":91946.947371662958},{"$f":"-IF(WACC_choice,(NPV(WACC,F53:AK53)),SUMPRODUCT($F$53:$AK$53,$F$21:$AK$21))/10^6","v":1262.7697376809833},"(million currency)"]
[null,null,null,"NPV total cost (million currency)",null,{"$f":"-IF(WACC_choice,(NPV(WACC,F55:AK55)),SUMPRODUCT($F$55:$AK$55,$F$21:$AK$21))*Exchangerate/10^6","v":123678.24197432777},{"$f":"-IF(WACC_choice,(NPV(WACC,F55:AK55)),SUMPRODUCT($F$55:$AK$55,$F$21:$AK$21))/10^6","v":1698.5571097154134},"(million currency)",null,"Comparison chart macro support"]
[null,null,null,"LCoE (INR/kWh)",null,{"$f":"F73*10^6/E67/1000","v":7.4265436059532233},{"$f":"G73*10^6/E67/1000","v":0.10199375606520827},"(currency/KWh)",null,{"$f":"D84","v":"NPV of government funding"},{"$f":"(F84)","v":0}]
[null,null,null,"Compound WACC",{"$f":"$E$20","v":9.0857725703423098E-2},null,null,"(%)"]
[null,null,null,"Simple WACC",{"$f":"WACC","v":0.09},null,null,"(%)"]
[null,null,null,{"$f":"D28&\" \"&H77","v":"Total overproduction (MWh)"},{"$f":"SUMIFS(F28:AK28,($F$5:$AK$5),\"<>\"\"\",F28:AK28,\"<>0\")","v":0},null,null,"(MWh)"]
[null,null,null,{"$f":"D29&\" \"&H78","v":"Total underproduction (MWh)"},{"$f":"SUMIFS(F29:AK29,($F$5:$AK$5),\"<>\"\"\",F29:AK29,\"<>0\")","v":0},null,null,"(MWh)"]
[null,null,null,"Average Net Energy production (MWh)",{"$f":"AVERAGEIFS(F25:AK25,($F$5:$AK$5),\"<>\"\"\",F25:AK25,\"<>0\")","v":2344551.2999999989},null,null,"(MWh)"]
[null,null,null,"Average Net Energy production corrected for over- and underproduction (MWh)",{"$f":"AVERAGEIFS(F30:AK30,($F$5:$AK$5),\"<>\"\"\",F30:AK30,\"<>0\")","v":2344551.2999999989},null,null,"(MWh)"]
[null,null,null,"Mean Net Energy production incl. Curtailment (MWh)",{"$f":"'Technical data'!$P$32*(1-Level_curtailment)","v":2344.5513000000001},null,null,"(MWh)"]
[null,null,null,"Total investment subsidy",null,{"$f":"SUM(F60:AK60)*Exchangerate/10^6","v":0},{"$f":"SUM(F60:AK60)/10^6","v":0},"(million currency)"]
[null,null,null,"Average annual GBI sudsidy",null,{"$f":"AVERAGE(F61:AK61)*Exchangerate/10^6","v":0},{"$f":"AVERAGE(F61:AK61)/10^6","v":0},"(million currency)"]
[null,null,null,"NPV of government funding",null,{"$f":"IF(WACC_choice,(NPV(WACC,F62:AK62)),SUMPRODUCT($F$62:$AK$62,$F$21:$AK$21))*Exchangerate/10^6","v":0},{"$f":"IF(WACC_choice,(NPV(WACC,F62:AK62)),SUMPRODUCT($F$62:$AK$62,$F$21:$AK$21))/10^6","v":0},"(million currency)"]
[null,null,null,"CAPEX share of LCoE",null,{"$f":"(F72/F73)*F74","v":5.5211652687598978},{"$f":"(G72/G73)*G74","v":7.5825904148221601E-2},"(currency/KWh)"]
[null,null,null,"OPEX share of LCoE",null,{"$f":"(F71/F73)*F74","v":1.9053783371933273},{"$f":"(G71/G73)*G74","v":2.6167851916986694E-2},"(currency/KWh)"]

{"sheet":"Technical data","index":5,"n_rows":69,"n_cols":25,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Technical data"}]
[]
[null,null,null,null,"Value","Index"]
[null,null,null,"Chosen Tech",{"$f":"INDEX($E$9:$H$9,F4)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"Tech_choice","v":2}]
[null,null,null,"Chosen P",null,{"$f":"P_choice","v":1}]
[null,null,null,"Capacity",{"$f":"NCAP","v":500}]
[]
[null,null,null,"Gross AEP"]
[null,null,null,"GWh/MW","Offshore wind Gujarat","Offshore wind Tamil Nadu Site B",null,null,null,"Technical lifetime"]
[null,null,null,2020,3.73,5.0960000000000001,null,null,null,2020,25]
[null,null,null,2025,3.7869999999999999,5.7253999999999996,null,null,null,2025,27]
[null,null,null,2030,3.7869999999999999,5.7253999999999996,null,null,null,2030,30]
[null,null,null,"P50",{"$f":"INDEX(E10:E12,MATCH('User Interface'!$D$14,$D$10:$D$12,0))","v":3.7869999999999999},{"$f":"INDEX(F10:F12,MATCH('User Interface'!$D$14,$D$10:$D$12,0))","v":5.7253999999999996},{"$f":"INDEX(G10:G12,MATCH('User Interface'!$D$14,$D$10:$D$12,0))","v":0},{"$f":"INDEX(H10:H12,MATCH('User Interface'!$D$14,$D$10:$D$12,0))","v":0},null,null,{"$f":"INDEX(K10:K12,MATCH('User Interface'!D14,J10:J12,0))","v":27}]
[]
[null,null,null,null,{"$f":"E9","v":"Offshore wind Gujarat"},{"$f":"F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G9","v":0},{"$f":"H9","v":0}]
[null,null,null,"Wake loss",9.5000000000000001E-2,0.1,null,null,null,"Wake loss only"]
[null,null,null,"Estimated uncertainty",0.2,0.2]
[null,null,null,"Variation status",{"$f":"E17*AnnualVariation","v":0},{"$f":"F17*AnnualVariation","v":0},{"$f":"G17*AnnualVariation","v":0},{"$f":"H17*AnnualVariation","v":0}]
[]
[null,null,null,"Probability",null,null,null,null,null,null,"Capacity factor at chosen Pxx"]
[null,null,null,"%",{"$f":"E9","v":"Offshore wind Gujarat"},{"$f":"F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G9","v":0},{"$f":"H9","v":0},null,null,"%",{"$f":"E9","v":"Offshore wind Gujarat"},{"$f":"F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G9","v":0},{"$f":"H9","v":0},"Chosen Tech",null,null,null,null,"Site","Wake loss","Electrical losses and planned outages","AEP (GWh)","CF"]
[null,null,null,75,{"$f":"NORMSINV($D22/100)","v":0.67448975019608193},{"$f":"NORMSINV($D22/100)","v":0.67448975019608193},0.67448975019608193,0.67448975019608193,null,null,"Before electrical losses",{"$f":"INDEX(E28:E31,$F$5)*1000/(24*365.25)","v":0.39096908510152867},{"$f":"INDEX(F28:F31,$F$5)*1000/(24*365.25)","v":0.58782340862422999},{"$f":"INDEX(G28:G31,$F$5)*1000/(24*365.25)","v":0},{"$f":"INDEX(H28:H31,$F$5)*1000/(24*365.25)","v":0},{"$f":"INDEX($L22:$O22,1,$F$4)","v":0.58782340862422999},null,null,null,null,{"$f":"TRANSPOSE(E9:G9)","v":"Offshore wind Gujarat"},{"$f":"TRANSPOSE(E16:G16)","v":9.5000000000000001E-2},{"$f":"TRANSPOSE(E32:G32)","v":0.09},{"$f":"TRANSPOSE(L28:N28)","v":1559.3919250000001},{"$f":"TRANSPOSE(L23:N23)","v":0.3557818674423911}]
[null,null,null,90,1.2815515655446006,1.2815515655446006,1.2815515655446006,1.2815515655446006,null,null,"After electrical losses",{"$f":"L22*(1-E$32)","v":0.3557818674423911},{"$f":"M22*(1-F$32)","v":0.53491930184804937},0,0,{"$f":"INDEX($L23:$O23,1,$F$4)","v":0.53491930184804937},null,null,null,null,"Offshore wind Tamil Nadu Site B",0.1,0.09,2344.5513000000001,0.53491930184804937]
[null,null,null,95,1.6448536269514715,1.6448536269514715,1.6448536269514715,1.6448536269514715,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0.09,0,0]
[]
[null,null,null,"Net AEP before electrical losses and forced outages",null,null,null,null,null,null,"Net AEP after all losses"]
[null,null,null,"GWh/MW",{"$f":"E21","v":"Offshore wind Gujarat"},{"$f":"F21","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G21","v":0},{"$f":"H21","v":0},"Chosen tech",null,"GWh",{"$f":"E27","v":"Offshore wind Gujarat"},{"$f":"F27","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G27","v":0},{"$f":"H27","v":0},"Chosen Tech",null,null,null,null,null,"GJ","TN C","TN B"]
[null,null,null,{"$f":"D13","v":"P50"},{"$f":"E13*(1-E16)","v":3.427235},{"$f":"F13*(1-F16)","v":5.1528599999999996},0,{"$f":"H13*(1-H16)","v":0},{"$f":"INDEX(E28:H28,($F$4))","v":5.1528599999999996},null,{"$f":"D28","v":"P50"},{"$f":"E28*$E$6*(1-E$32)","v":1559.3919250000001},2344.5513000000001,0,0,{"$f":"INDEX(L28:O28,($F$4))","v":2344.5513000000001},null,null,null,null,null,178,160,114]
[null,null,null,"P75",{"$f":"E$28*(1-E22*E$18)","v":3.427235},{"$f":"F$28*(1-F22*F$18)","v":5.1528599999999996},0,0,{"$f":"INDEX(E29:H29,($F$4))","v":5.1528599999999996},null,{"$f":"D29","v":"P75"},1559.3919250000001,2344.5513000000001,0,0,{"$f":"INDEX(L29:O29,($F$4))","v":2344.5513000000001},null,null,null,null,"mUSD/y",{"$f":"V28*L32/1000","v":277.57176265000004},{"$f":"W28*M32/1000","v":375.12820799999997},{"$f":"X28*N32/1000","v":0}]
[null,null,null,"P90",{"$f":"E$28*(1-E23*E$18)","v":3.427235},{"$f":"F$28*(1-F23*F$18)","v":5.1528599999999996},0,0,5.1528599999999996,null,{"$f":"D30","v":"P90"},1559.3919250000001,2344.5513000000001,0,0,{"$f":"INDEX(L30:O30,($F$4))","v":2344.5513000000001},null,null,null,null,"mINR/y",{"$f":"V29*'CAPEX & OPEX'!$G$49","v":0},{"$f":"W29*'CAPEX & OPEX'!$G$49","v":0},{"$f":"X29*'CAPEX & OPEX'!$G$49","v":0}]
[null,null,null,"P95",{"$f":"E$28*(1-E24*E$18)","v":3.427235},{"$f":"F$28*(1-F24*F$18)","v":5.1528599999999996},0,0,5.1528599999999996,null,{"$f":"D31","v":"P95"},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,"Electrical losses and forced outages",0.09,0.09,0.09,null,{"$f":"INDEX($I$28:$I$31,$F$5)","v":5.1528599999999996},null,"Chosen P",{"$f":"INDEX(L$28:L$31,$F$5)","v":1559.3919250000001},{"$f":"INDEX(M$28:M$31,$F$5)","v":2344.5513000000001},{"$f":"INDEX(N$28:N$31,$F$5)","v":0},{"$f":"INDEX(O$28:O$31,$F$5)","v":0},{"$f":"INDEX(L32:O32,($F$4))","v":2344.5513000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Net AEP timeseries"]
[null,null,null,null,null,null,null,null,null,null,"GWh",{"$f":"L27","v":"Offshore wind Gujarat"},{"$f":"M27","v":"Offshore wind Tamil Nadu Site B"},0,0,"Chosen tech"]
[null,null,null,null,null,null,null,null,0.40491118215270039,1,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J37)","v":2025},{"$f":"L$32*(1+NORMSINV($I37)*E$18)","v":1559.3919250000001},{"$f":"M$32*(1+NORMSINV($I37)*F$18)","v":2344.5513000000001},{"$f":"N$32*(1+NORMSINV($I37)*G$18)","v":0},{"$f":"O$32*(1+NORMSINV($I37)*H$18)","v":0},{"$f":"INDEX($L37:$O37,1,$F$4)","v":2344.5513000000001}]
[null,null,null,null,null,null,null,null,0.43282198985649412,2,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J38)","v":2026},{"$f":"L$32*(1+NORMSINV($I38)*E$18)","v":1559.3919250000001},{"$f":"M$32*(1+NORMSINV($I38)*F$18)","v":2344.5513000000001},{"$f":"N$32*(1+NORMSINV($I38)*G$18)","v":0},{"$f":"O$32*(1+NORMSINV($I38)*H$18)","v":0},{"$f":"INDEX($L38:$O38,1,$F$4)","v":2344.5513000000001}]
[null,null,null,null,null,null,null,null,0.16291863915776206,3,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J39)","v":2027},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.37905521012539756,4,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J40)","v":2028},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.22296120926205054,5,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J41)","v":2029},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.26426990731701439,6,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J42)","v":2030},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.1929888873892579,7,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J43)","v":2031},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.98859773294945008,8,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J44)","v":2032},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,1.1202738146611435E-2,9,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J45)","v":2033},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.60873137468934835,10,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J46)","v":2034},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.98612309599544035,11,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J47)","v":2035},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.47557704130077427,12,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J48)","v":2036},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.36703743952941781,13,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J49)","v":2037},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.75709103885284368,14,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J50)","v":2038},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.46108233651186759,15,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J51)","v":2039},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,2.8167863504713342E-3,16,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J52)","v":2040},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.27817330212378233,17,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J53)","v":2041},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.41484700613014791,18,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J54)","v":2042},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.33221793536702282,19,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J55)","v":2043},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.38804582468201376,20,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J56)","v":2044},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.92588204997089152,21,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J57)","v":2045},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.98989670886324266,22,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J58)","v":2046},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.30564374740769384,23,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J59)","v":2047},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.7328805928719847,24,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J60)","v":2048},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.83200024475208589,25,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J61)","v":2049},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.17015818369020341,26,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J62)","v":2050},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,8.4406352215334879E-3,27,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J63)","v":2051},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.74119229201201742,28,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J64)","v":2052},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.92390533423963506,29,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J65)","v":2053},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.59614310652873881,30,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J66)","v":2054},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,2.6020277818090576E-2,31,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J67)","v":2055},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,0.61989317508967068,32,{"$f":"INDEX(Finance!$F$3:$AK$3,1,'Technical data'!$J68)","v":2056},1559.3919250000001,2344.5513000000001,0,0,2344.5513000000001]
[null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(L37:L68)","v":1559.3919250000013},{"$f":"AVERAGE(M37:M68)","v":2344.5513000000005},{"$f":"AVERAGE(N37:N68)","v":0},0,{"$f":"AVERAGE(P37:P68)","v":2344.5513000000005}]

{"sheet":"CAPEX & OPEX","index":6,"n_rows":44,"n_cols":32,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"CAPEX & OPEX"}]
[]
[null,null,null,null,"Value","Index"]
[null,null,null,"Chosen Tech",{"$f":"INDEX($E$9:$H$9,1,F4)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"Tech_choice","v":2}]
[null,null,null,"Capacity",{"$f":"Nom_cap","v":500}]
[null,null,null,"AEP (MWh)",{"$f":"Net_AEP","v":2344.5513000000001}]
[]
[null,null,null,"CAPEX","Offshore wind Gujarat","Offshore wind Tamil Nadu Site B",null,null,null,null,"Taxes",null,null,null,null,"CAPEX",null,null,null,null,"Export system",null,null,null,null,null,null,"Cost development"]
[null,null,null,"mUSD/MW",{"$f":"'Technical data'!E9","v":"Offshore wind Gujarat"},{"$f":"'Technical data'!F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"'Technical data'!G9","v":0},{"$f":"'Technical data'!H9","v":0},"Chosen",null,"%","VAT","Duties","Total",null,"mUSD","CAPEX","Taxes","Total",null,null,"% of CAPEX","Include in Export system",null,"Included","Not included",null,null,{"$f":"E9","v":"Offshore wind Gujarat"},{"$f":"F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G9","v":0},{"$f":"H9","v":0}]
[null,null,null,"DEVEX",9.6443057021582401E-2,9.2840299144339389E-2,null,null,{"$f":"INDEX($E10:$H10,1,$F$4)*(1+$E$37)","v":7.8983538078020082E-2},null,{"$f":"D10","v":"DEVEX"},0.05,0.13,{"$f":"(1+L10*VAT_choice)*(1+M10*Duties_choice)-1","v":0},null,{"$f":"K10","v":"DEVEX"},{"$f":"I10*$E$5","v":39.491769039010045},{"$f":"Q10*N10","v":0},{"$f":"(Q10+R10)","v":39.491769039010045},null,"OSS",7.1999999999999995E-2,"Yes",{"$f":"V10/SUM($V$10:$V$12)","v":0.41379310344827586},{"$f":"$X10*IF($W10=\"Yes\",1,0)","v":0.41379310344827586},{"$f":"$X10*IF($W10=\"No\",1,0)","v":0},null,2020,0,0]
[null,null,null,"PM",9.0659599793383797E-2,8.7272890605699927E-2,null,null,{"$f":"INDEX($E11:$H11,1,$F$4)*(1+$E$37)","v":7.4247086037685012E-2},null,"PM",0.05,0.13,{"$f":"(1+L11*VAT_choice)*(1+M11*Duties_choice)-1","v":0},null,{"$f":"K11","v":"PM"},37.123543018842504,{"$f":"Q11*N11","v":0},{"$f":"(Q11+R11)","v":37.123543018842504},null,"Export cable",7.4999999999999997E-2,"Yes",{"$f":"V11/SUM($V$10:$V$12)","v":0.43103448275862072},{"$f":"$X11*IF($W11=\"Yes\",1,0)","v":0.43103448275862072},{"$f":"$X11*IF($W11=\"No\",1,0)","v":0},null,2025,-0.18103448275862077,-0.14925373134328357]
[null,null,null,"Foundation",0.21359714330630855,0.20561793967704989,null,null,0.17492869494913199,null,"Foundation",0.05,0.13,0,null,"Foundation",87.464347474565997,0,87.464347474565997,null,"ONSS",2.7E-2,"Yes",{"$f":"V12/SUM($V$10:$V$12)","v":0.15517241379310345},0.15517241379310345,0,null,2030,-0.4224137931034484,-0.40000000000000008]
[null,null,null,"WTG",1.5646596447099512,1.5062097154535452,null,null,1.2814022952365982,null,"WTG",0.05,0.13,0,null,"WTG",640.70114761829916,0,640.70114761829916,null,null,null,null,null,{"$f":"SUM(Y10:Y12)","v":1},{"$f":"SUM(Z10:Z12)","v":0}]
[null,null,null,"Array cabling",0.34388124059559366,0.33103510229748245,null,null,{"$f":"(INDEX($E14:$H14,1,$F$4)+INDEX($E15:$H15,1,$F$4)*$Z$13)*(1+$E$37)","v":0.28162687807397763},null,"Array cabling",0.05,0.13,0,null,"Array cabling",140.81343903698883,0,140.81343903698883]
[null,null,null,"Export system",0.60491836413861244,0.58232083904148046,null,null,{"$f":"INDEX($E15:$H15,1,$F$4)*(1+$E$37)*$Y$13","v":0.49540728097558784},null,"Export system",0.05,0.13,0,null,"Export system",{"$f":"I15*$E$5","v":247.7036404877939},{"$f":"Q15*N15","v":0},{"$f":"(Q15+R15)","v":247.7036404877939}]
[null,null,null,"Installation",0.56584095043456784,0.54470321378040287,null,null,0.46340422664899944,null,"Installation",0.05,0.13,0,null,"Installation",231.70211332449972,0,231.70211332449972]
[null,null,null,"With cost development",null,null,null,null,{"$f":"SUM(I10:I16)","v":2.85},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S10:S16)/E5","v":2.8500000000000005}]
[null,null,null,"Without cost development",{"$f":"SUM(E10:E16)","v":3.4800000000000004},{"$f":"SUM(F10:F16)","v":3.35},{"$f":"SUM(G10:G16)","v":0},{"$f":"SUM(H10:H16)","v":0},{"$f":"INDEX($E18:$H18,1,$F$4)","v":3.35}]
[]
[null,null,null,"OPEX",null,null,null,null,null,null,"Taxes",null,null,null,null,"OPEX"]
[null,null,null,null,{"$f":"E9","v":"Offshore wind Gujarat"},{"$f":"F9","v":"Offshore wind Tamil Nadu Site B"},{"$f":"G9","v":0},{"$f":"H9","v":0},"Chosen",null,"%","VAT","Duties","Total",null,null,"OPEX","Taxes","Total"]
[null,null,null,"USD/MWh",null,null,null,null,{"$f":"INDEX($E22:$H22,1,$F$4)*(1+$E$44)","v":0},null,{"$f":"D22","v":"USD/MWh"},0.05,0,{"$f":"(1+L22*VAT_choice)*(1+M22*Duties_choice)-1","v":0},null,{"$f":"K22","v":"USD/MWh"},{"$f":"I22","v":0},{"$f":"Q22*N22","v":0},{"$f":"(Q22+R22)","v":0}]
[null,null,null,"USD/MWh",null,null,null,null,{"$f":"INDEX($E23:$H23,1,$F$4)*(1+$E$44)","v":0},null,{"$f":"D23","v":"USD/MWh"},null,null,0,null,{"$f":"K23","v":"USD/MWh"},{"$f":"I23","v":0},{"$f":"Q23*N23","v":0},{"$f":"(Q23+R23)","v":0}]
[null,null,null,"USD/MWh",null,null,null,null,0,null,"USD/MWh",null,null,0,null,"USD/MWh",0,0,0]
[null,null,null,"USD/MW",98000,98000,null,null,63700,null,"USD/MW",0.05,null,0,null,"USD/MW",{"$f":"I25","v":63700},0,63700]
[null,null,null,"USD/MW",null,null,null,null,0,null,"USD/MW",null,null,0,null,"USD/MW",{"$f":"I26","v":0},0,0]
[null,null,null,"USD/MW",null,null,null,null,0,null,"USD/MW",null,null,0,null,"USD/MW",0,0,0]
[null,null,null,"With cost development",null,null,null,null,{"$f":"SUM(I25:I27)","v":63700}]
[null,null,null,"Without cost development",null,null,null,null,{"$f":"I28/(1+$E$44)","v":98000}]
[]
[null,null,null,"Cost Development",null,null,null,null,{"$f":"D31","v":"Cost Development"},{"$f":"G33","v":"(mINR/MW)"},{"$f":"G40","v":"(INR/MW)"}]
[null,null,null,null,null,null,null,null,"Year",{"$f":"D33","v":"CAPEX "},{"$f":"D40","v":"OPEX "}]
[null,null,null,"CAPEX ",null,"(mUSD/MW)","(mINR/MW)",null,{"$f":"D34","v":2020},{"$f":"G34","v":243.92592291666668},{"$f":"G41","v":7135743.416666667}]
[null,null,null,2020,{"$f":"INDEX(AC10:AF10,$F$4)","v":0},{"$f":"(1+E34)*$I$18","v":3.35},{"$f":"F34*Exchangerate","v":243.92592291666668},null,{"$f":"D35","v":2025},{"$f":"G35","v":207.51906875000003},{"$f":"G42","v":4638233.2208333332}]
[null,null,null,2025,{"$f":"INDEX(AC11:AF11,$F$4)","v":-0.14925373134328357},{"$f":"(1+E35)*$I$18","v":2.85},{"$f":"F35*Exchangerate","v":207.51906875000003},null,{"$f":"D36","v":2030},146.35555374999998,3853301.4450000003]
[null,null,null,2030,{"$f":"INDEX(AC12:AF12,$F$4)","v":-0.40000000000000008},2.0099999999999998,{"$f":"F36*Exchangerate","v":146.35555374999998}]
[null,null,null,{"$f":"'User Interface'!D14","v":2025},{"$f":"INDEX(E34:E36,MATCH(D37,D34:D36,0))","v":-0.14925373134328357}]
[]
[]
[null,null,null,"OPEX ",null,"(USD/MW)","(INR/MW)"]
[null,null,null,2020,0,{"$f":"(1+E41)*$I$29","v":98000},{"$f":"F41*Exchangerate","v":7135743.416666667}]
[null,null,null,2025,-0.35,{"$f":"(1+E42)*$I$29","v":63700},{"$f":"F42*Exchangerate","v":4638233.2208333332}]
[null,null,null,2030,-0.46,52920,{"$f":"F43*Exchangerate","v":3853301.4450000003}]
[null,null,null,{"$f":"'User Interface'!D14","v":2025},{"$f":"INDEX(E41:E43,MATCH(D44,D41:D43,0))","v":-0.35}]

{"sheet":"Exchange rate","index":7,"n_rows":594,"n_cols":12,"rows_kept":594,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Exchange rate"}]
[]
[]
[null,"Date","Indian Rupee/USD",null,null,null,null,null,null,null,null,"INR"]
[null,"1973-01-01",8.0040999999999993,null,{"$f":"B592-B5","v":17866},"Days",null,null,null,null,null,"USD"]
[null,"1973-02-01",7.7538,null,{"$f":"E5/365.25","v":48.91444216290212},"Years"]
[null,"1973-03-01",7.5465]
[null,"1973-04-01",7.5461999999999998]
[null,"1973-05-01",7.4927000000000001]
[null,"1973-06-01",7.2718999999999996,null,"2019-01-01","Startdate"]
[null,"1973-07-01",7.351,null,{"$f":"MATCH(E10,B5:B592,0)","v":553},"Index observation"]
[null,"1973-08-01",7.5643000000000002,null,{"$f":"COUNT(C5:C592)","v":588},"Index last observation"]
[null,"1973-09-01",7.7,null,{"$f":"AVERAGE(OFFSET(C5,E11-1,0,E12-E11+1))","v":72.813708333333338},"Mean"]
[null,"1973-10-01",7.7271000000000001,null,{"$f":"_xlfn.STDEV.P(OFFSET(C5,E11-1,0,E12-E11+1))","v":2.0336155677587042},"Standard deviation"]
[null,"1973-11-01",7.8339999999999996]
[null,"1973-12-01",8.11,null,{"$f":"IF(I20=1,E13,IF(G26=\"\",0,G26))","v":72.813708333333338},"P50 exchange rate"]
[null,"1974-01-01",8.4376999999999995,null,{"$f":"E16/INDEX($C$5:$C$592,E12)-1","v":-3.4234345958430334E-2},"P50 exchange rate fall"]
[null,"1974-02-01",8.2444000000000006]
[null,"1974-03-01",8.0566999999999993,null,{"$f":"INDEX($C$5:$C$592,E12)","v":75.394800000000004},"Most current exchange rate"]
[null,"1974-04-01",7.8654999999999999,null,null,null,null,null,1]
[null,"1974-05-01",7.7854999999999999]
[null,"1974-06-01",7.8490000000000002]
[null,"1974-07-01",7.8345000000000002]
[null,"1974-08-01",7.9840999999999998,null,"Define exchange rate "]
[null,"1974-09-01",8.1210000000000004,null,null,"Empirical exchange rate",{"$f":"E13","v":72.813708333333338}]
[null,"1974-10-01",8.0504999999999995,null,null,"User defined exchange rate "]
[null,"1974-11-01",8.0643999999999991]
[null,"1974-12-01",8.0952000000000002,null,null,{"$f":"IF(I20=2,IF(G26=\"\",\"Please define exchange rate\",\"\"),\"\")","v":""}]
[null,"1975-01-01",8.1300000000000008]
[null,"1975-02-01",7.9717000000000002]
[null,"1975-03-01",7.75]
[null,"1975-04-01",7.8841000000000001]
[null,"1975-05-01",8.07]
[null,"1975-06-01",8.1913999999999998]
[null,"1975-07-01",8.4894999999999996]
[null,"1975-08-01",8.7895000000000003]
[null,"1975-09-01",8.8648000000000007]
[null,"1975-10-01",8.8945000000000007]
[null,"1975-11-01",8.8994]
[null,"1975-12-01",8.9826999999999995]
[null,"1976-01-01",8.9471000000000007]
[null,"1976-02-01",8.9389000000000003]
[null,"1976-03-01",8.9648000000000003]
[null,"1976-04-01",8.9917999999999996]
[null,"1976-05-01",9.0265000000000004]
[null,"1976-06-01",9.1109000000000009]
[null,"1976-07-01",8.9232999999999993]
[null,"1976-08-01",8.9755000000000003]
[null,"1976-09-01",9.0614000000000008]
[null,"1976-10-01",8.8960000000000008]
[null,"1976-11-01",8.9657999999999998]
[null,"1976-12-01",8.8535000000000004]
[null,"1977-01-01",8.9052000000000007]
[null,"1977-02-01",8.8626000000000005]
[null,"1977-03-01",8.8416999999999994]
[null,"1977-04-01",8.8429000000000002]
[null,"1977-05-01",8.8338000000000001]
[null,"1977-06-01",8.8605]
[null,"1977-07-01",8.8163]
[null,"1977-08-01",8.7212999999999994]
[null,"1977-09-01",8.73]
[null,"1977-10-01",8.6150000000000002]
[null,"1977-11-01",8.6404999999999994]
[null,"1977-12-01",8.5371000000000006]
[null,"1978-01-01",8.2010000000000005]
[null,"1978-02-01",8.1094000000000008]
[null,"1978-03-01",8.2078000000000007]
[null,"1978-04-01",8.4649999999999999]
[null,"1978-05-01",8.5827000000000009]
[null,"1978-06-01",8.4040999999999997]
[null,"1978-07-01",8.1664999999999992]
[null,"1978-08-01",8.0138999999999996]
[null,"1978-09-01",8.0365000000000002]
[null,"1978-10-01",7.9109999999999996]
[null,"1978-11-01",8.0335000000000001]
[null,"1978-12-01",8.2159999999999993]
[null,"1979-01-01",8.2090999999999994]
[null,"1979-02-01",8.25]
[null,"1979-03-01",8.2417999999999996]
[null,"1979-04-01",8.2062000000000008]
[null,"1979-05-01",8.2890999999999995]
[null,"1979-06-01",8.1189999999999998]
[null,"1979-07-01",7.9066999999999998]
[null,"1979-08-01",8.0113000000000003]
[null,"1979-09-01",8.1357999999999997]
[null,"1979-10-01",8.2258999999999993]
[null,"1979-11-01",8.1926000000000005]
[null,"1979-12-01",8.0995000000000008]
[null,"1980-01-01",7.9882]
[null,"1980-02-01",7.9816000000000003]
[null,"1980-03-01",8.1518999999999995]
[null,"1980-04-01",8.07]
[null,"1980-05-01",7.8586]
[null,"1980-06-01",7.8423999999999996]
[null,"1980-07-01",7.7664]
[null,"1980-08-01",7.7824]
[null,"1980-09-01",7.7495000000000003]
[null,"1980-10-01",7.7323000000000004]
[null,"1980-11-01",7.7712000000000003]
[null,"1980-12-01",7.9314]
[null,"1981-01-01",7.9576000000000002]
[null,"1981-02-01",8.2210999999999999]
[null,"1981-03-01",8.2431999999999999]
[null,"1981-04-01",8.2918000000000003]
[null,"1981-05-01",8.4045000000000005]
[null,"1981-06-01",8.5564]
[null,"1981-07-01",8.9064999999999994]
[null,"1981-08-01",9.0604999999999993]
[null,"1981-09-01",9.1151999999999997]
[null,"1981-10-01",9.1348000000000003]
[null,"1981-11-01",9.1349999999999998]
[null,"1981-12-01",9.1304999999999996]
[null,"1982-01-01",9.1524999999999999]
[null,"1982-02-01",9.2143999999999995]
[null,"1982-03-01",9.2934999999999999]
[null,"1982-04-01",9.3923000000000005]
[null,"1982-05-01",9.2965]
[null,"1982-06-01",9.4667999999999992]
[null,"1982-07-01",9.5632999999999999]
[null,"1982-08-01",9.5740999999999996]
[null,"1982-09-01",9.6494999999999997]
[null,"1982-10-01",9.7004999999999999]
[null,"1982-11-01",9.7967999999999993]
[null,"1982-12-01",9.6926000000000005]
[null,"1983-01-01",9.7937999999999992]
[null,"1983-02-01",9.9184000000000001]
[null,"1983-03-01",9.9651999999999994]
[null,"1983-04-01",9.9824000000000002]
[null,"1983-05-01",9.9894999999999996]
[null,"1983-06-01",10.049099999999999]
[null,"1983-07-01",10.0875]
[null,"1983-08-01",10.1874]
[null,"1983-09-01",10.2005]
[null,"1983-10-01",10.228999999999999]
[null,"1983-11-01",10.378399999999999]
[null,"1983-12-01",10.4895]
[null,"1984-01-01",10.715199999999999]
[null,"1984-02-01",10.7437]
[null,"1984-03-01",10.714499999999999]
[null,"1984-04-01",10.82]
[null,"1984-05-01",11.0168]
[null,"1984-06-01",11.063800000000001]
[null,"1984-07-01",11.3714]
[null,"1984-08-01",11.556100000000001]
[null,"1984-09-01",11.8584]
[null,"1984-10-01",12.0268]
[null,"1984-11-01",12.0784]
[null,"1984-12-01",12.2925]
[null,"1985-01-01",12.6119]
[null,"1985-02-01",12.9217]
[null,"1985-03-01",12.8614]
[null,"1985-04-01",12.400499999999999]
[null,"1985-05-01",12.500500000000001]
[null,"1985-06-01",12.4405]
[null,"1985-07-01",12.0314]
[null,"1985-08-01",11.8977]
[null,"1985-09-01",12.125500000000001]
[null,"1985-10-01",12.033200000000001]
[null,"1985-11-01",12.101100000000001]
[null,"1985-12-01",12.1524]
[null,"1986-01-01",12.2433]
[null,"1986-02-01",12.37]
[null,"1986-03-01",12.289]
[null,"1986-04-01",12.3932]
[null,"1986-05-01",12.4657]
[null,"1986-06-01",12.598599999999999]
[null,"1986-07-01",12.5077]
[null,"1986-08-01",12.566700000000001]
[null,"1986-09-01",12.675700000000001]
[null,"1986-10-01",12.848599999999999]
[null,"1986-11-01",13.0761]
[null,"1986-12-01",13.1486]
[null,"1987-01-01",13.029500000000001]
[null,"1987-02-01",13.062099999999999]
[null,"1987-03-01",12.9236]
[null,"1987-04-01",12.814500000000001]
[null,"1987-05-01",12.666]
[null,"1987-06-01",12.8368]
[null,"1987-07-01",13.012600000000001]
[null,"1987-08-01",13.0852]
[null,"1987-09-01",12.9933]
[null,"1987-10-01",13.042899999999999]
[null,"1987-11-01",12.972099999999999]
[null,"1987-12-01",12.9345]
[null,"1988-01-01",13.0395]
[null,"1988-02-01",13.065]
[null,"1988-03-01",12.979100000000001]
[null,"1988-04-01",13.1576]
[null,"1988-05-01",13.3157]
[null,"1988-06-01",13.7859]
[null,"1988-07-01",14.079499999999999]
[null,"1988-08-01",14.217000000000001]
[null,"1988-09-01",14.4895]
[null,"1988-10-01",14.72]
[null,"1988-11-01",14.965999999999999]
[null,"1988-12-01",15.019]
[null,"1989-01-01",15.092499999999999]
[null,"1989-02-01",15.240500000000001]
[null,"1989-03-01",15.4674]
[null,"1989-04-01",15.718]
[null,"1989-05-01",16.101800000000001]
[null,"1989-06-01",16.419499999999999]
[null,"1989-07-01",16.416]
[null,"1989-08-01",16.609100000000002]
[null,"1989-09-01",16.745000000000001]
[null,"1989-10-01",16.818999999999999]
[null,"1989-11-01",16.924800000000001]
[null,"1989-12-01",16.931999999999999]
[null,"1990-01-01",16.9633]
[null,"1990-02-01",16.9895]
[null,"1990-03-01",17.116399999999999]
[null,"1990-04-01",17.2943]
[null,"1990-05-01",17.3245]
[null,"1990-06-01",17.420999999999999]
[null,"1990-07-01",17.411899999999999]
[null,"1990-08-01",17.346499999999999]
[null,"1990-09-01",17.859500000000001]
[null,"1990-10-01",18.073599999999999]
[null,"1990-11-01",18.0975]
[null,"1990-12-01",18.127199999999998]
[null,"1991-01-01",18.338999999999999]
[null,"1991-02-01",18.86]
[null,"1991-03-01",19.242899999999999]
[null,"1991-04-01",19.906400000000001]
[null,"1991-05-01",20.518599999999999]
[null,"1991-06-01",21.062000000000001]
[null,"1991-07-01",25.6127]
[null,"1991-08-01",25.845700000000001]
[null,"1991-09-01",25.833500000000001]
[null,"1991-10-01",25.7973]
[null,"1991-11-01",25.802099999999999]
[null,"1991-12-01",25.818000000000001]
[null,"1992-01-01",25.8629]
[null,"1992-02-01",25.992100000000001]
[null,"1992-03-01",28.377700000000001]
[null,"1992-04-01",28.8962]
[null,"1992-05-01",28.541499999999999]
[null,"1992-06-01",28.518599999999999]
[null,"1992-07-01",28.5639]
[null,"1992-08-01",28.4635]
[null,"1992-09-01",28.4757]
[null,"1992-10-01",28.476700000000001]
[null,"1992-11-01",28.473700000000001]
[null,"1992-12-01",28.9786]
[null,"1993-01-01",29.043199999999999]
[null,"1993-02-01",30.042100000000001]
[null,"1993-03-01",31.9391]
[null,"1993-04-01",31.609500000000001]
[null,"1993-05-01",31.612500000000001]
[null,"1993-06-01",31.668199999999999]
[null,"1993-07-01",31.6]
[null,"1993-08-01",31.612300000000001]
[null,"1993-09-01",31.5776]
[null,"1993-10-01",31.504999999999999]
[null,"1993-11-01",31.433499999999999]
[null,"1993-12-01",31.44]
[null,"1994-01-01",31.44]
[null,"1994-02-01",31.448899999999998]
[null,"1994-03-01",31.4147]
[null,"1994-04-01",31.391400000000001]
[null,"1994-05-01",31.375399999999999]
[null,"1994-06-01",31.384499999999999]
[null,"1994-07-01",31.3764]
[null,"1994-08-01",31.372699999999998]
[null,"1994-09-01",31.372299999999999]
[null,"1994-10-01",31.372599999999998]
[null,"1994-11-01",31.393999999999998]
[null,"1994-12-01",31.389399999999998]
[null,"1995-01-01",31.3736]
[null,"1995-02-01",31.3795]
[null,"1995-03-01",31.586500000000001]
[null,"1995-04-01",31.407299999999999]
[null,"1995-05-01",31.417899999999999]
[null,"1995-06-01",31.403700000000001]
[null,"1995-07-01",31.385300000000001]
[null,"1995-08-01",31.592300000000002]
[null,"1995-09-01",33.309800000000003]
[null,"1995-10-01",34.656399999999998]
[null,"1995-11-01",34.71]
[null,"1995-12-01",34.966299999999997]
[null,"1996-01-01",35.811700000000002]
[null,"1996-02-01",36.594499999999996]
[null,"1996-03-01",34.485199999999999]
[null,"1996-04-01",34.319499999999998]
[null,"1996-05-01",35.024999999999999]
[null,"1996-06-01",35.099499999999999]
[null,"1996-07-01",35.667299999999997]
[null,"1996-08-01",35.799999999999997]
[null,"1996-09-01",35.869999999999997]
[null,"1996-10-01",35.803600000000003]
[null,"1996-11-01",35.839199999999998]
[null,"1996-12-01",35.881500000000003]
[null,"1997-01-01",35.903700000000001]
[null,"1997-02-01",35.890500000000003]
[null,"1997-03-01",35.884799999999998]
[null,"1997-04-01",35.828099999999999]
[null,"1997-05-01",35.824800000000003]
[null,"1997-06-01",35.8202]
[null,"1997-07-01",35.747399999999999]
[null,"1997-08-01",36.008499999999998]
[null,"1997-09-01",36.4756]
[null,"1997-10-01",36.302]
[null,"1997-11-01",37.288899999999998]
[null,"1997-12-01",39.4]
[null,"1998-01-01",39.390999999999998]
[null,"1998-02-01",39.007899999999999]
[null,"1998-03-01",39.568600000000004]
[null,"1998-04-01",39.7029]
[null,"1998-05-01",40.468699999999998]
[null,"1998-06-01",42.366799999999998]
[null,"1998-07-01",42.611800000000002]
[null,"1998-08-01",42.8429]
[null,"1998-09-01",42.579000000000001]
[null,"1998-10-01",42.394300000000001]
[null,"1998-11-01",42.428400000000003]
[null,"1998-12-01",42.590899999999998]
[null,"1999-01-01",42.545299999999997]
[null,"1999-02-01",42.531599999999997]
[null,"1999-03-01",42.516100000000002]
[null,"1999-04-01",42.796799999999998]
[null,"1999-05-01",42.859000000000002]
[null,"1999-06-01",43.212699999999998]
[null,"1999-07-01",43.356699999999996]
[null,"1999-08-01",43.5032]
[null,"1999-09-01",43.598100000000002]
[null,"1999-10-01",43.552799999999998]
[null,"1999-11-01",43.457999999999998]
[null,"1999-12-01",43.523899999999998]
[null,"2000-01-01",43.589500000000001]
[null,"2000-02-01",43.654000000000003]
[null,"2000-03-01",43.638300000000001]
[null,"2000-04-01",43.684699999999999]
[null,"2000-05-01",44.075899999999997]
[null,"2000-06-01",44.7605]
[null,"2000-07-01",44.840499999999999]
[null,"2000-08-01",45.768700000000003]
[null,"2000-09-01",45.968000000000004]
[null,"2000-10-01",46.425199999999997]
[null,"2000-11-01",46.821399999999997]
[null,"2000-12-01",46.784500000000001]
[null,"2001-01-01",46.613799999999998]
[null,"2001-02-01",46.561599999999999]
[null,"2001-03-01",46.653199999999998]
[null,"2001-04-01",46.788600000000002]
[null,"2001-05-01",46.947299999999998]
[null,"2001-06-01",47.042400000000001]
[null,"2001-07-01",47.178100000000001]
[null,"2001-08-01",47.166499999999999]
[null,"2001-09-01",47.751100000000001]
[null,"2001-10-01",48.051400000000001]
[null,"2001-11-01",48.042999999999999]
[null,"2001-12-01",47.9345]
[null,"2002-01-01",48.353299999999997]
[null,"2002-02-01",48.716799999999999]
[null,"2002-03-01",48.7667]
[null,"2002-04-01",48.938600000000001]
[null,"2002-05-01",49.016800000000003]
[null,"2002-06-01",48.984000000000002]
[null,"2002-07-01",48.787700000000001]
[null,"2002-08-01",48.615000000000002]
[null,"2002-09-01",48.462499999999999]
[null,"2002-10-01",48.388199999999998]
[null,"2002-11-01",48.285299999999999]
[null,"2002-12-01",48.149500000000003]
[null,"2003-01-01",47.957099999999997]
[null,"2003-02-01",47.747399999999999]
[null,"2003-03-01",47.676699999999997]
[null,"2003-04-01",47.390900000000002]
[null,"2003-05-01",47.11]
[null,"2003-06-01",46.6995]
[null,"2003-07-01",46.22]
[null,"2003-08-01",45.9557]
[null,"2003-09-01",45.846699999999998]
[null,"2003-10-01",45.403599999999997]
[null,"2003-11-01",45.554400000000001]
[null,"2003-12-01",45.574100000000001]
[null,"2004-01-01",45.456000000000003]
[null,"2004-02-01",45.272599999999997]
[null,"2004-03-01",44.969299999999997]
[null,"2004-04-01",43.891800000000003]
[null,"2004-05-01",45.1755]
[null,"2004-06-01",45.502699999999997]
[null,"2004-07-01",46.055700000000002]
[null,"2004-08-01",46.322000000000003]
[null,"2004-09-01",46.0548]
[null,"2004-10-01",45.735500000000002]
[null,"2004-11-01",45.032499999999999]
[null,"2004-12-01",43.847000000000001]
[null,"2005-01-01",43.615000000000002]
[null,"2005-02-01",43.575800000000001]
[null,"2005-03-01",43.586100000000002]
[null,"2005-04-01",43.6419]
[null,"2005-05-01",43.409500000000001]
[null,"2005-06-01",43.524500000000003]
[null,"2005-07-01",43.433999999999997]
[null,"2005-08-01",43.55]
[null,"2005-09-01",43.846200000000003]
[null,"2005-10-01",44.7575]
[null,"2005-11-01",45.631500000000003]
[null,"2005-12-01",45.563299999999998]
[null,"2006-01-01",44.201000000000001]
[null,"2006-02-01",44.23]
[null,"2006-03-01",44.337800000000001]
[null,"2006-04-01",44.8245]
[null,"2006-05-01",45.195900000000002]
[null,"2006-06-01",45.888599999999997]
[null,"2006-07-01",46.3675]
[null,"2006-08-01",46.446100000000001]
[null,"2006-09-01",46.0105]
[null,"2006-10-01",45.355200000000004]
[null,"2006-11-01",44.725700000000003]
[null,"2006-12-01",44.483499999999999]
[null,"2007-01-01",44.206200000000003]
[null,"2007-02-01",44.019500000000001]
[null,"2007-03-01",43.793599999999998]
[null,"2007-04-01",42.017600000000002]
[null,"2007-05-01",40.568600000000004]
[null,"2007-06-01",40.590499999999999]
[null,"2007-07-01",40.273800000000001]
[null,"2007-08-01",40.679099999999998]
[null,"2007-09-01",40.173499999999997]
[null,"2007-10-01",39.366100000000003]
[null,"2007-11-01",39.326700000000002]
[null,"2007-12-01",39.375]
[null,"2008-01-01",39.267600000000002]
[null,"2008-02-01",39.673499999999997]
[null,"2008-03-01",40.145200000000003]
[null,"2008-04-01",39.966799999999999]
[null,"2008-05-01",42.001899999999999]
[null,"2008-06-01",42.763300000000001]
[null,"2008-07-01",42.7027]
[null,"2008-08-01",42.905700000000003]
[null,"2008-09-01",45.53]
[null,"2008-10-01",48.615499999999997]
[null,"2008-11-01",48.851700000000001]
[null,"2008-12-01",48.513199999999998]
[null,"2009-01-01",48.6995]
[null,"2009-02-01",49.248399999999997]
[null,"2009-03-01",51.129100000000001]
[null,"2009-04-01",49.965499999999999]
[null,"2009-05-01",48.51]
[null,"2009-06-01",47.6736]
[null,"2009-07-01",48.362400000000001]
[null,"2009-08-01",48.242600000000003]
[null,"2009-09-01",48.292400000000001]
[null,"2009-10-01",46.6524]
[null,"2009-11-01",46.530500000000004]
[null,"2009-12-01",46.527299999999997]
[null,"2010-01-01",45.894399999999997]
[null,"2010-02-01",46.273200000000003]
[null,"2010-03-01",45.450899999999997]
[null,"2010-04-01",44.444000000000003]
[null,"2010-05-01",45.768999999999998]
[null,"2010-06-01",46.4983]
[null,"2010-07-01",46.761699999999998]
[null,"2010-08-01",46.460500000000003]
[null,"2010-09-01",45.872900000000001]
[null,"2010-10-01",44.353999999999999]
[null,"2010-11-01",44.9315]
[null,"2010-12-01",45.1]
[null,"2011-01-01",45.375]
[null,"2011-02-01",45.3795]
[null,"2011-03-01",44.914299999999997]
[null,"2011-04-01",44.301000000000002]
[null,"2011-05-01",44.9024]
[null,"2011-06-01",44.810899999999997]
[null,"2011-07-01",44.396000000000001]
[null,"2011-08-01",45.313499999999998]
[null,"2011-09-01",47.6905]
[null,"2011-10-01",49.201999999999998]
[null,"2011-11-01",50.6785]
[null,"2011-12-01",52.382399999999997]
[null,"2012-01-01",51.0015]
[null,"2012-02-01",49.181199999999997]
[null,"2012-03-01",50.363500000000002]
[null,"2012-04-01",51.69]
[null,"2012-05-01",54.331400000000002]
[null,"2012-06-01",55.942399999999999]
[null,"2012-07-01",55.424799999999998]
[null,"2012-08-01",55.493499999999997]
[null,"2012-09-01",54.35]
[null,"2012-10-01",53.099499999999999]
[null,"2012-11-01",54.784500000000001]
[null,"2012-12-01",54.646999999999998]
[null,"2013-01-01",54.228999999999999]
[null,"2013-02-01",53.807899999999997]
[null,"2013-03-01",54.422899999999998]
[null,"2013-04-01",54.323599999999999]
[null,"2013-05-01",54.984499999999997]
[null,"2013-06-01",58.383499999999998]
[null,"2013-07-01",59.760899999999999]
[null,"2013-08-01",62.810899999999997]
[null,"2013-09-01",63.648000000000003]
[null,"2013-10-01",61.605899999999998]
[null,"2013-11-01",62.517899999999997]
[null,"2013-12-01",61.811]
[null,"2014-01-01",62.105699999999999]
[null,"2014-02-01",62.164200000000001]
[null,"2014-03-01",60.947600000000001]
[null,"2014-04-01",60.346400000000003]
[null,"2014-05-01",59.284300000000002]
[null,"2014-06-01",59.736699999999999]
[null,"2014-07-01",60.095599999999997]
[null,"2014-08-01",60.873800000000003]
[null,"2014-09-01",60.897599999999997]
[null,"2014-10-01",61.366799999999998]
[null,"2014-11-01",61.6828]
[null,"2014-12-01",62.707099999999997]
[null,"2015-01-01",62.13]
[null,"2015-02-01",61.990499999999997]
[null,"2015-03-01",62.480499999999999]
[null,"2015-04-01",62.641399999999997]
[null,"2015-05-01",63.715000000000003]
[null,"2015-06-01",63.780900000000003]
[null,"2015-07-01",63.604500000000002]
[null,"2015-08-01",65.097099999999998]
[null,"2015-09-01",66.166700000000006]
[null,"2015-10-01",65.026200000000003]
[null,"2015-11-01",66.099999999999994]
[null,"2015-12-01",66.502300000000005]
[null,"2016-01-01",67.333200000000005]
[null,"2016-02-01",68.239500000000007]
[null,"2016-03-01",66.890900000000002]
[null,"2016-04-01",66.421899999999994]
[null,"2016-05-01",66.889499999999998]
[null,"2016-06-01",67.265500000000003]
[null,"2016-07-01",67.158000000000001]
[null,"2016-08-01",66.903499999999994]
[null,"2016-09-01",66.713800000000006]
[null,"2016-10-01",66.741500000000002]
[null,"2016-11-01",67.639499999999998]
[null,"2016-12-01",67.805199999999999]
[null,"2017-01-01",68.047399999999996]
[null,"2017-02-01",66.9726]
[null,"2017-03-01",65.800899999999999]
[null,"2017-04-01",64.536000000000001]
[null,"2017-05-01",64.419499999999999]
[null,"2017-06-01",64.4482]
[null,"2017-07-01",64.424000000000007]
[null,"2017-08-01",63.968299999999999]
[null,"2017-09-01",64.477500000000006]
[null,"2017-10-01",65.035700000000006]
[null,"2017-11-01",64.843500000000006]
[null,"2017-12-01",64.244500000000002]
[null,"2018-01-01",63.645200000000003]
[null,"2018-02-01",64.430000000000007]
[null,"2018-03-01",65.045500000000004]
[null,"2018-04-01",65.672899999999998]
[null,"2018-05-01",67.510000000000005]
[null,"2018-06-01",67.790000000000006]
[null,"2018-07-01",68.686700000000002]
[null,"2018-08-01",69.631699999999995]
[null,"2018-09-01",72.277900000000002]
[null,"2018-10-01",73.560900000000004]
[null,"2018-11-01",71.738]
[null,"2018-12-01",70.833100000000002]
[null,"2019-01-01",70.709999999999994]
[null,"2019-02-01",71.173900000000003]
[null,"2019-03-01",69.489500000000007]
[null,"2019-04-01",69.406800000000004]
[null,"2019-05-01",69.782700000000006]
[null,"2019-06-01",69.388000000000005]
[null,"2019-07-01",68.739099999999993]
[null,"2019-08-01",71.189099999999996]
[null,"2019-09-01",71.311000000000007]
[null,"2019-10-01",71.008600000000001]
[null,"2019-11-01",71.494200000000006]
[null,"2019-12-01",71.156700000000001]
[null,"2020-01-01",71.278999999999996]
[null,"2020-02-01",71.529499999999999]
[null,"2020-03-01",74.548199999999994]
[null,"2020-04-01",76.168199999999999]
[null,"2020-05-01",75.657499999999999]
[null,"2020-06-01",75.707700000000003]
[null,"2020-07-01",74.928600000000003]
[null,"2020-08-01",74.565700000000007]
[null,"2020-09-01",73.523300000000006]
[null,"2020-10-01",73.564800000000005]
[null,"2020-11-01",74.231099999999998]
[null,"2020-12-01",73.619500000000002]
[null,"2021-01-01",73.110600000000005]
[null,"2021-02-01",72.805300000000003]
[null,"2021-03-01",72.819599999999994]
[null,"2021-04-01",74.518600000000006]
[null,"2021-05-01",73.206500000000005]
[null,"2021-06-01",73.578199999999995]
[null,"2021-07-01",74.539000000000001]
[null,"2021-08-01",74.115499999999997]
[null,"2021-09-01",73.6357]
[null,"2021-10-01",74.92]
[null,"2021-11-01",74.477000000000004]
[null,"2021-12-01",75.394800000000004]
[]
[null,"Source: https://fred.stlouisfed.org/series/EXINUS"]

{"sheet":"Inflation","index":8,"n_rows":29,"n_cols":65,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,2,16,4]]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Inflation"}]
[]
[null,"Inflation - Projection"]
[null,"Inflation, consumer prices (annual %)",null,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061]
[null,null,null,{"$f":"IF(AND(D$4>$K$22,$N$29=2),$F$16,IF(D$4>$K$22,$K$24,INDEX($F$11:$AC$11,MATCH(D$4,$F$10:$AC$10,0))))","v":3.7383199999999999},4.27928,4.1036700000000002,3.7344400000000002,4,4.2307699999999997,6.2,6.4,9.0225600000000004,12.241379999999999,10.44547,10.44547,9.8972700000000007,12.2,5.7932263810000002,4.8862679020000002,4.5783132530000001,3.6866359449999999,3.4,4.8,6.5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"IF(AND(AJ$4>$K$22,$N$29=2),$F$16,IF(AJ$4>$K$22,$K$24,INDEX($F$11:$AC$11,MATCH(AJ$4,$F$10:$AC$10,0))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[]
[]
[null,null,null,null,null,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,"India","Price Indexes (% annual change)","Consumer price index (national)",null,3.7383199999999999,4.27928,4.1036700000000002,3.7344400000000002,4,4.2307699999999997,6.2,6.4,9.0225600000000004,12.241379999999999,10.44547,{"$f":"P11","v":10.44547},9.8972700000000007,12.2,5.7932263810000002,4.8862679020000002,4.5783132530000001,3.6866359449999999,3.4,4.8,6.5]
[null,"Source: https://data.adb.org/dataset/india-key-indicators",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value not included in source"]
[]
[null,"Define exchange rate "]
[null,null,{"$f":"\"Average inflation of the period \"&K20&\"-\"&K22","v":"Average inflation of the period 2015-2020"}]
[null,null,"User defined exchange rate ",null,null,5]
[null,null,{"$f":"IF(AND(N29=2,F16=\"\"),\"Please define inflation rate\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,"From year",{"$f":"K22-5","v":2015}]
[null,null,null,null,null,null,null,null,null,"First year",{"$f":"MIN(F10:BJ10)","v":2000}]
[null,null,null,null,null,null,null,null,null,"Last year",{"$f":"MAX(F10:BJ10)","v":2020}]
[]
[null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(OFFSET($F$11,0,K20-K21+1,1,K22-K20))","v":4.5929898395999995}]
[null,null,null,null,null,null,null,null,null,"Minimum",{"$f":"MIN(OFFSET($F$11,0,K20-K21+1,1,K22-K20))","v":3.4}]
[null,null,null,null,null,null,null,null,null,"Maximum",{"$f":"MAX(OFFSET($F$11,0,K20-K21+1,1,K22-K20))","v":6.5}]
[null,null,null,null,null,null,null,null,null,"stdev",{"$f":"_xlfn.STDEV.P(OFFSET($F$11,0,K20-K21+1,1,K22-K20))","v":1.0885273078997435}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]

{"sheet":"Sensitivity","index":9,"n_rows":117,"n_cols":24,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,"Sensitivity"]
[]
[null,null,"No. of scens",{"$f":"MAX(C9:C117)","v":96}]
[null,null,"Active scen",1]
[]
[null,null,"Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[null,null,null,"CAPEX Total","OPEX Total","Net AEP","Lifetime extension","Construction rate","Senior rate","Senior tenor","Junior Tenor","Junior rate","Cost of Equity","Inflation rate ","Technology","Uncertainty",null,null,null,null,"Scen","Technology ","Uncertainty","LCOE"]
[null,null,"Chosen sensitivity",{"$f":"INDEX(D9:D117,Scen)","v":0},{"$f":"INDEX(E9:E117,Scen)","v":0},{"$f":"INDEX(F9:F117,Scen)","v":0},0,0,0,0,{"$f":"INDEX(K9:K117,Scen)","v":0},0,{"$f":"INDEX(M9:M117,Scen)","v":0},{"$f":"INDEX(N9:N117,Scen)*100","v":0},{"$f":"IF(INDEX($O$9:$O$117,Scen)>0,INDEX($O$9:$O$117,Scen),Tech_choice)","v":2},{"$f":"IF(INDEX($P$9:$P$117,Scen)>0,INDEX($P$9:$P$117,Scen),P_choice)","v":1},null,null,null,"Scenario",{"$f":"Scen","v":1},{"$f":"INDEX(Lists!$B$4:$B$7,scen_technology,1)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!D4:D8,Scen_uncertainty,1)","v":"P50"},{"$f":"Results!$C$11","v":7.4265436059532233}]
[null,"Base",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"Offshore wind Gujarat","P50",13.711062574423666]
[null,null,{"$f":"C9+1","v":2},null,null,-0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,{"$f":"T9+1","v":2},2,"Offshore wind Gujarat","P50",15.234513971581846]
[null,null,{"$f":"C10+1","v":3},null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,{"$f":"T10+1","v":3},3,"Offshore wind Gujarat","P50",13.711062574423666]
[null,null,4,null,null,0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,4,4,"Offshore wind Gujarat","P50",12.464602340385152]
[null,null,5,null,null,0.2,null,null,null,null,null,null,null,null,1,null,null,null,null,5,5,"Offshore wind Gujarat","P50",11.425885478686389]
[null,null,6,-0.3,null,-0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,6,6,"Offshore wind Gujarat","P50",12.008883047218688]
[null,null,7,-0.3,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,7,7,"Offshore wind Gujarat","P50",10.807994742496826]
[null,null,8,-0.3,null,0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,8,8,"Offshore wind Gujarat","P50",9.825449765906205]
[null,null,9,-0.3,null,0.2,null,null,null,null,null,null,null,null,1,null,null,null,null,9,9,"Offshore wind Gujarat","P50",9.0066622854140199]
[null,null,10,-0.4,null,-0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,10,10,"Offshore wind Gujarat","P50",10.933672739097638]
[null,null,11,-0.4,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,11,11,"Offshore wind Gujarat","P50",9.8403054651878783]
[null,null,12,-0.4,null,0.1,null,null,null,null,null,null,null,null,1,null,null,null,null,12,12,"Offshore wind Gujarat","P50",8.9457322410798898]
[null,null,13,-0.4,null,0.2,null,null,null,null,null,null,null,null,1,null,null,null,null,13,13,"Offshore wind Gujarat","P50",8.2002545543232319]
[null,null,14,null,null,-0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,14,14,"Offshore wind Tamil Nadu Site B","P50",10.917173994130133]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,15,15,"Offshore wind Tamil Nadu Site B","P50",9.8254565947171209]
[null,null,16,null,null,0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,16,16,"Offshore wind Tamil Nadu Site B","P50",8.9322332679246532]
[null,null,17,null,null,0.2,null,null,null,null,null,null,null,null,2,null,null,null,null,17,17,"Offshore wind Tamil Nadu Site B","P50",11.425885478686389]
[null,null,18,-0.3,null,-0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,18,18,"Offshore wind Tamil Nadu Site B","P50",8.6317555950853624]
[null,null,19,-0.3,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,19,19,"Offshore wind Tamil Nadu Site B","P50",7.768580035576826]
[null,null,20,-0.3,null,0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,20,20,"Offshore wind Tamil Nadu Site B","P50",7.062345486888022]
[null,null,21,-0.3,null,0.2,null,null,null,null,null,null,null,null,2,null,null,null,null,21,21,"Offshore wind Tamil Nadu Site B","P50",6.4738166963140236]
[null,null,22,-0.4,null,-0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,22,22,"Offshore wind Tamil Nadu Site B","P50",7.8699494620704362]
[null,null,23,-0.4,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,23,23,"Offshore wind Tamil Nadu Site B","P50",7.0829545158633938]
[null,null,24,-0.4,null,0.1,null,null,null,null,null,null,null,null,2,null,null,null,null,24,24,"Offshore wind Tamil Nadu Site B","P50",6.4390495598758104]
[null,null,25,-0.4,null,0.2,null,null,null,null,null,null,null,null,2,null,null,null,null,25,25,"Offshore wind Tamil Nadu Site B","P50",5.9024620965528305]
[null,null,26,null,null,-0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,26,26,"IREDA input","P50",10.917173994130133]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,27,27,"IREDA input","P50",10.309855194120932]
[null,null,28,null,null,0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,28,28,"IREDA input","P50",12.464602340385152]
[null,null,29,null,null,0.2,null,null,null,null,null,null,null,null,3,null,null,null,null,29,29,"IREDA input","P50",8.5915459951007787]
[null,null,30,-0.3,null,-0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,30,30,"IREDA input","P50",8.6449416613680068]
[null,null,31,-0.3,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,31,31,"IREDA input","P50",7.780447495231205]
[null,null,32,-0.3,null,0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,32,32,"IREDA input","P50",7.0731340865738259]
[null,null,33,-0.3,null,0.2,null,null,null,null,null,null,null,null,3,null,null,null,null,33,33,"IREDA input","P50",6.4837062460260046]
[null,null,34,-0.4,null,-0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,34,34,"IREDA input","P50",7.708123995112552]
[null,null,35,-0.4,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,35,35,"IREDA input","P50",6.9373115956012956]
[null,null,36,-0.4,null,0.1,null,null,null,null,null,null,null,null,3,null,null,null,null,36,36,"IREDA input","P50",6.306646905092089]
[null,null,37,-0.4,null,0.2,null,null,null,null,null,null,null,null,3,null,null,null,null,37,37,"IREDA input","P50",5.7810929963344133]
[null,null,38,null,null,-0.1,null,null,null,null,null,null,null,null,4,null,null,null,null,38,38,0,"P50",{"$error":"#DIV/0!"}]
[null,null,39,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,39,39,0,"P50",{"$error":"#DIV/0!"}]
[null,null,40,null,null,0.1,null,null,null,null,null,null,null,null,4,null,null,null,null,40,40,0,"P50",{"$error":"#DIV/0!"}]
[null,null,41,null,null,0.2,null,null,null,null,null,null,null,null,4,null,null,null,null,41,41,0,"P50",{"$error":"#DIV/0!"}]
[null,null,42,-0.3,null,-0.1,null,null,null,null,null,null,null,null,4,null,null,null,null,42,42,0,"P50",{"$error":"#DIV/0!"}]
[null,null,43,-0.3,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,43,43,0,"P50",{"$error":"#DIV/0!"}]
[null,null,44,-0.3,null,0.1,null,null,null,null,null,null,null,null,4,null,null,null,null,44,44,0,"P50",{"$error":"#DIV/0!"}]
[null,null,45,-0.3,null,0.2,null,null,null,null,null,null,null,null,4,null,null,null,null,45,45,0,"P50",{"$error":"#DIV/0!"}]
[null,null,46,-0.4,null,-0.1,null,null,null,null,null,null,null,null,4,null,null,null,1,46,46,0,"P50",{"$error":"#DIV/0!"}]
[null,null,47,-0.4,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,47,47,0,"P50",{"$error":"#DIV/0!"}]
[null,null,48,-0.4,null,0.1,null,null,null,null,null,null,null,null,4,null,null,null,null,48,48,0,"P50",{"$error":"#DIV/0!"}]
[null,null,49,-0.4,null,0.2,null,null,null,null,null,null,null,null,4,null,null,null,null,49,49,0,"P50",{"$error":"#DIV/0!"}]
[null,null,50,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,50,50,"Offshore wind Gujarat","P50",13.551057123990473]
[null,null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,51,"Offshore wind Gujarat","P50",13.711062574423666]
[null,null,52,null,-0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,52,"Offshore wind Gujarat","P50",13.307645594290255]
[null,null,53,null,-0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,53,"Offshore wind Gujarat","P50",12.904228614156839]
[null,null,54,null,-0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,54,"Offshore wind Gujarat","P50",12.500811634023421]
[null,null,55,null,null,null,null,null,null,null,null,null,null,null,1,1,2020,null,null,55,55,"Offshore wind Gujarat","P50",13.711062574423666]
[null,null,56,-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,1,1,2025,null,null,56,56,"Offshore wind Gujarat","P50",11.42872502361956]
[null,null,57,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,1,1,2030,null,null,57,57,"Offshore wind Gujarat","P50",8.097771630071847]
[null,null,58,null,null,null,null,null,null,null,null,null,null,null,2,1,2020,null,null,58,58,"Offshore wind Tamil Nadu Site B","P50",9.8254565947171209]
[null,null,59,-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,2,1,2025,null,null,59,59,"Offshore wind Tamil Nadu Site B","P50",8.1743654991018158]
[null,null,60,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,2,1,2030,null,null,60,60,"Offshore wind Tamil Nadu Site B","P50",5.804293496115509]
[null,null,61,null,null,null,null,null,null,null,null,null,null,null,1,3,2020,null,null,61,61,"Offshore wind Gujarat","P90",13.711062574423666]
[null,null,62,-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,1,3,2025,null,null,62,62,"Offshore wind Gujarat","P90",11.42872502361956]
[null,null,63,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,1,3,2030,null,null,63,63,"Offshore wind Gujarat","P90",8.097771630071847]
[null,null,64,null,null,null,null,null,null,null,null,null,null,null,2,3,2020,null,null,64,64,"Offshore wind Tamil Nadu Site B","P90",9.8254565947171209]
[null,null,65,-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,2,3,2025,null,null,65,65,"Offshore wind Tamil Nadu Site B","P90",8.1743654991018158]
[null,null,66,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,2,3,2030,null,null,66,66,"Offshore wind Tamil Nadu Site B","P90",5.804293496115509]
[null,null,67,null,null,null,null,null,null,null,null,null,null,null,3,1,2020,null,null,{"$f":"T74+1","v":67},67,"IREDA input","P50",10.309855194120932]
[null,null,{"$f":"C75+1","v":68},-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,3,1,2025,null,null,68,68,"IREDA input","P50",8.8230945026101271]
[null,null,69,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,3,1,2030,null,null,69,69,"IREDA input","P50",6.0688626664301228]
[null,null,70,null,null,null,null,null,null,null,null,null,null,null,3,3,2020,null,null,70,70,"IREDA input","P90",10.309855194120932]
[null,null,71,-0.15,-0.3,null,null,null,null,null,null,null,0.2,null,3,3,2025,null,null,71,71,"IREDA input","P90",8.8230945026101271]
[null,null,72,-0.4,-0.4,null,null,null,-0.25,0.33,null,null,0.5,null,3,3,2030,null,null,72,72,"IREDA input","P90",6.0688626664301228]
[null,null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,73,"Offshore wind Gujarat","P50",13.711062574423666]
["MNRE sensitivites ","Tamil Nadu",74,-0.27905856371442483,-0.56509835326110258,null,null,7.0000000000000007E-2,null,7.0000000000000007E-2,null,7.0000000000000007E-2,0.1,0.06,2,null,"Construction year must be set to 2020",null,null,74,74,"Offshore wind Tamil Nadu Site B","P50",6.8070473025596607]
[null,null,75,-0.15183360436991156,-0.56509835326110258,null,null,7.0000000000000007E-2,null,7.0000000000000007E-2,null,7.0000000000000007E-2,0.1,0.06,2,null,"Construction year must be set to 2020",null,null,75,75,"Offshore wind Tamil Nadu Site B","P50",7.7336058564482899]
[null,null,76,-2.4608645025398279E-2,-0.6375819610509188,null,null,0.06,null,0.06,null,0.06,0.1,0.05,2,null,"Construction year must be set to 2020",null,null,76,76,"Offshore wind Tamil Nadu Site B","P50",8.1076808721563491]
["MNRE sensitivites ","Gujarat",77,-0.30599028403543782,-0.56509835326110258,null,null,7.0000000000000007E-2,null,7.0000000000000007E-2,null,7.0000000000000007E-2,0.1,0.06,1,null,"Construction year must be set to 2020",null,null,77,77,"Offshore wind Gujarat","P50",9.2485422802896124]
[null,null,78,-0.22434208215725393,-0.56509835326110258,null,null,7.0000000000000007E-2,null,7.0000000000000007E-2,null,7.0000000000000007E-2,0.1,0.06,1,null,"Construction year must be set to 2020",null,null,78,78,"Offshore wind Gujarat","P50",10.087801514620738]
[null,null,79,-6.1045678400886372E-2,-0.6375819610509188,null,null,0.06,null,0.06,null,0.06,0.1,0.05,1,null,"Construction year must be set to 2020",null,null,79,79,"Offshore wind Gujarat","P50",11.015676255553117]
[null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[null,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,null,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,null,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[null,null,95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109]

{"sheet":"Result tables","index":10,"n_rows":119,"n_cols":26,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Result tables"}]
[]
[]
[]
[null,"LCOE sensitivitu chart"]
[]
[null,"Technology ",{"$f":"'Technical data'!E9","v":"Offshore wind Gujarat"},1,null,null,null,"Technology ",{"$f":"'Technical data'!G9","v":0},3]
[null,"CAPEX base",null,null,null,null,null,"CAPEX base"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"Sensitivity!F10","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F10)","v":15.234513971581846},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C10)","v":1403.4527325000001},2,null,1,{"$f":"C10","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L10)","v":10.917173994130133},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I10)","v":0},26]
[null,2,{"$f":"Sensitivity!F11","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F11)","v":13.711062574423666},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C11)","v":1559.3919250000001},3,null,2,{"$f":"C11","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L11)","v":10.309855194120932},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I11)","v":0},27]
[null,3,{"$f":"Sensitivity!F12","v":0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F12)","v":12.464602340385152},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C12)","v":1715.3311175000003},4,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L12)","v":12.464602340385152},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I12)","v":0},28]
[null,4,{"$f":"Sensitivity!F13","v":0.2},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F13)","v":11.425885478686389},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C13)","v":1871.2703100000001},5,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L13)","v":8.5915459951007787},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I13)","v":0},29]
[]
[null,"CAPEX - 40 %",null,null,null,null,null,"CAPEX - 40 %"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"C10","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F17)","v":10.933672739097638},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C17)","v":1403.4527325000001},10,null,1,{"$f":"I10","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L17)","v":7.708123995112552},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I17)","v":0},34]
[null,2,{"$f":"C11","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F18)","v":9.8403054651878783},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C18)","v":1559.3919250000001},11,null,2,{"$f":"I11","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L18)","v":6.9373115956012956},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I18)","v":0},35]
[null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F19)","v":8.9457322410798898},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C19)","v":1715.3311175000003},12,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L19)","v":6.306646905092089},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I19)","v":0},36]
[null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F20)","v":8.2002545543232319},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C20)","v":1871.2703100000001},13,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L20)","v":5.7810929963344133},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I20)","v":0},37]
[]
[null,"CAPEX - 30 %",null,null,null,null,null,"CAPEX - 30 %"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"C17","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F24)","v":12.008883047218688},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C24)","v":1403.4527325000001},6,null,1,{"$f":"I17","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L24)","v":8.6449416613680068},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I24)","v":0},30]
[null,2,{"$f":"C18","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F25)","v":10.807994742496826},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C25)","v":1559.3919250000001},7,null,2,{"$f":"I18","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L25)","v":7.780447495231205},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I25)","v":0},31]
[null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F26)","v":9.825449765906205},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C26)","v":1715.3311175000003},8,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L26)","v":7.0731340865738259},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I26)","v":0},32]
[null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F27)","v":9.0066622854140199},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$7)*(1+C27)","v":1871.2703100000001},9,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L27)","v":6.4837062460260046},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$7)*(1+I27)","v":0},33]
[]
[null,"Technology ",{"$f":"'Technical data'!F9","v":"Offshore wind Tamil Nadu Site B"},2,null,null,null,"Technology ",{"$f":"'Technical data'!H9","v":0},4]
[null,"CAPEX base",null,null,null,null,null,"CAPEX base"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"C24","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F32)","v":10.917173994130133},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C32)","v":2110.0961700000003},14,null,1,{"$f":"I24","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L32)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I32)","v":0},38]
[null,2,{"$f":"C25","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F33)","v":9.8254565947171209},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C33)","v":2344.5513000000001},15,null,2,{"$f":"I25","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L33)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I33)","v":0},39]
[null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F34)","v":8.9322332679246532},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C34)","v":2579.0064300000004},16,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L34)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I34)","v":0},40]
[null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F35)","v":11.425885478686389},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C35)","v":2813.4615600000002},17,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L35)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I35)","v":0},41]
[]
[null,"CAPEX + 10 %",null,null,null,null,null,"CAPEX + 10 %"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"C32","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F39)","v":7.8699494620704362},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C39)","v":2110.0961700000003},22,null,1,{"$f":"I32","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L39)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I39)","v":0},46]
[null,2,{"$f":"C33","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F40)","v":7.0829545158633938},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C40)","v":2344.5513000000001},23,null,2,{"$f":"I33","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L40)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I40)","v":0},47]
[null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F41)","v":6.4390495598758104},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C41)","v":2579.0064300000004},24,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L41)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I41)","v":0},48]
[null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F42)","v":5.9024620965528305},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C42)","v":2813.4615600000002},25,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L42)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I42)","v":0},49]
[]
[null,"CAPEX - 10 %",null,null,null,null,null,"CAPEX - 10 %"]
[null,null,null,"LCOE","AEP","Scenario",null,null,null,"LCOE","AEP","Scenario"]
[null,1,{"$f":"C39","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F46)","v":8.6317555950853624},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C46)","v":2110.0961700000003},18,null,1,{"$f":"I39","v":-0.1},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L46)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I46)","v":0},42]
[null,2,{"$f":"C40","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F47)","v":7.768580035576826},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C47)","v":2344.5513000000001},19,null,2,{"$f":"I40","v":0},{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L47)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I47)","v":0},43]
[null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F48)","v":7.062345486888022},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C48)","v":2579.0064300000004},20,null,3,0.1,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L48)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I48)","v":0},44]
[null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!F49)","v":6.4738166963140236},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$D$29)*(1+C49)","v":2813.4615600000002},21,null,4,0.2,{"$f":"INDEX(Sensitivity!$X$9:$X$117,'Result tables'!L49)","v":{"$error":"#DIV/0!"}},{"$f":"INDEX('Technical data'!$L$28:$O$28,,$J$29)*(1+I49)","v":0},45]
[]
[null,"LCOE sensitivity chart 2"]
[]
[null,"Main result",{"$f":"Results!C11","v":7.4265436059532233}]
[null,"Lifetime extended 5 years",{"$f":"Sensitivity!X58","v":13.551057123990473}]
[null,"Construction time halved",{"$f":"Sensitivity!X59","v":13.711062574423666}]
[null,"OPEX reduced 10%",{"$f":"Sensitivity!X60","v":13.307645594290255}]
[null,"OPEX reduced 20%",{"$f":"Sensitivity!X61","v":12.904228614156839}]
[null,"OPEX reduced 30%",{"$f":"Sensitivity!X62","v":12.500811634023421}]
[]
[null,null,"Gujarat",null,"Tamil Nadu Site C",null,null,null,null,null,null,null,"Site B",null,"Site C East"]
[null,null,"P50","P90","P50","P90","Blank","Red","Blank","Grey",null,null,"P50","P90","P50","P90","Blank","Red","Blank","Grey"]
[null,"2020-2022",{"$f":"Sensitivity!X63","v":13.711062574423666},{"$f":"Sensitivity!X69","v":13.711062574423666},null,null,{"$f":"E62","v":0},{"$f":"F62-E62","v":0},{"$f":"C62-F62","v":13.711062574423666},{"$f":"D62-C62","v":0},null,"2020-2022",{"$f":"Sensitivity!X75","v":10.309855194120932},{"$f":"Sensitivity!X78","v":10.309855194120932},{"$f":"Sensitivity!X66","v":9.8254565947171209},{"$f":"Sensitivity!X72","v":9.8254565947171209},{"$f":"MIN(M62:P62)","v":9.8254565947171209},{"$f":"N62-M62","v":0},{"$f":"O62-N62","v":-0.48439859940381069},{"$f":"P62-O62","v":0}]
[null,2025,{"$f":"Sensitivity!X64","v":11.42872502361956},{"$f":"Sensitivity!X70","v":11.42872502361956},null,null,{"$f":"E63","v":0},{"$f":"F63-E63","v":0},{"$f":"C63-F63","v":11.42872502361956},{"$f":"D63-C63","v":0},null,2025,{"$f":"Sensitivity!X76","v":8.8230945026101271},{"$f":"Sensitivity!X79","v":8.8230945026101271},{"$f":"Sensitivity!X67","v":8.1743654991018158},{"$f":"Sensitivity!X73","v":8.1743654991018158},{"$f":"MIN(M63:P63)","v":8.1743654991018158},{"$f":"N63-M63","v":0},{"$f":"O63-N63","v":-0.64872900350831131},{"$f":"P63-O63","v":0}]
[null,2030,{"$f":"Sensitivity!X65","v":8.097771630071847},{"$f":"Sensitivity!X71","v":8.097771630071847},null,null,{"$f":"E64","v":0},{"$f":"F64-E64","v":0},{"$f":"C64-F64","v":8.097771630071847},{"$f":"D64-C64","v":0},null,2030,{"$f":"Sensitivity!X77","v":6.0688626664301228},{"$f":"Sensitivity!X80","v":6.0688626664301228},{"$f":"Sensitivity!X68","v":5.804293496115509},{"$f":"Sensitivity!X74","v":5.804293496115509},5.804293496115509,0,-0.2645691703146138,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Opening","High","Low","Close",null,null,"2020 P50",null,"2020 P90",null,"2025 P50",null,"2025 P90",null,"2030 P50",null,"2030 P90",null,"2020 P50","2020 P90","2025 P50","2025 P90","2030 P50","2030 P90"]
["Gujarat","2020-01-12",{"$f":"C62","v":13.711062574423666},{"$f":"I87","v":20.278048160998594},{"$f":"I96","v":12.296182506658811},{"$f":"D62","v":13.711062574423666},null,null,"Gujarat","Tamil Nadu Site C","Gujarat","Tamil Nadu Site C","Gujarat","Tamil Nadu Site C","Gujarat","Tamil Nadu Site C","Gujarat","Tamil Nadu Site C","Gujarat","Tamil Nadu Site C","Tamil Nadu Site B","Tamil Nadu Site B","Tamil Nadu Site B","Tamil Nadu Site B","Tamil Nadu Site B","Tamil Nadu Site B"]
[null,"2025-01-13",{"$f":"C63","v":11.42872502361956},{"$f":"M87","v":17.741490437848981},{"$f":"M96","v":10.623100733107036},{"$f":"D63","v":11.42872502361956},null,null,20.278048160998594,18.742952911560607,28.310619970176155,26.119338872529521,17.741490437848981,16.385253201784799,24.799751831730731,22.8632962673477,11.993992540324163,11.090610653704932,16.73454465371756,15.445166144066034,14.599674827075855,20.204991243515074,12.747315764716202,17.66899544330261,8.6444711125417033,11.95384115437861]
[null,"2030-01-01",{"$f":"C64","v":8.097771630071847},{"$f":"Q87","v":11.993992540324163},{"$f":"Q96","v":6.8853961600420996},{"$f":"D64","v":8.097771630071847},null,null,18.440859890033373,16.984912046145777,25.855519359384608,23.777217709608617,16.220979687083155,14.930253881506346,22.767285331716582,20.924367955730517,10.876887495805656,10.021628773138231,15.241917878888751,14.021224577934637,13.158475410903696,18.315147344125922,11.554570607201979,16.104517500148393,7.7681350035274939,10.804858962011711]
["Tamil Nadu Site C",{"$f":"B86","v":"2020-01-12"},{"$f":"O62","v":9.8254565947171209},{"$f":"J87","v":18.742952911560607},{"$f":"J96","v":11.271359721235365},{"$f":"P62","v":9.8254565947171209},null,null,16.996184230445511,15.654296816724216,23.829971759801488,21.914486368302875,14.88163274044326,13.697480625235178,20.887417735519801,19.196667849294055,10.04793302152947,9.2578556795734244,14.080293652553117,12.95263240455856,12.127627106823684,16.880320132834949,10.60052349284585,14.774786697383837,7.1761062388244738,9.9813939602879511]
[null,"2025-01-13",{"$f":"O63","v":8.1743654991018158},{"$f":"N87","v":16.385253201784799},{"$f":"N96","v":9.7200904447370995},{"$f":"P63","v":8.1743654991018158},null,null,16.307113620319459,15.019629899000901,21.537469288240903,19.806258349037559,14.27845576966341,13.142299280893054,18.873471070281216,17.345741818689806,9.6405137864344059,8.8824721582551085,12.727243493472331,11.707945200728473,11.635940779082503,15.256391409153565,10.170866897993951,13.350214604481852,6.885132591954191,9.0222288307051119]
[null,"2030-01-01",{"$f":"O64","v":5.804293496115509},{"$f":"R87","v":11.090610653704932},{"$f":"R96","v":6.2815305451890291},{"$f":"P64","v":5.804293496115509},null,null,15.491757939303479,14.268648404050852,20.460595823828868,18.815945431585671,13.564532981180243,12.4851843168484,17.929797516767156,16.478454727755317,9.1584880971126896,8.4383485503423525,12.090881318798717,11.122547940692046,11.054143740128376,14.493571838695889,9.6623235530942555,12.682703874257765,6.5408759623564805,8.5711173891698529]
["Tamil Nadu Site B","2020-01-12",{"$f":"M62","v":10.309855194120932},{"$f":"U87","v":14.599674827075855},{"$f":"U96","v":8.5365146384254338},{"$f":"N62","v":10.309855194120932},null,null,15.167001276682278,13.975357910031219,20.030322827833263,18.427983320299436,13.273536668591273,12.222454980412492,17.543839130391557,16.130505442018464,8.9687898526137211,8.2670055898682779,11.839693449566191,10.896041446431409,10.827777036967785,14.195598592441232,9.4598365810405891,12.415759294440777,6.4085283513310216,8.3970458689796903]
[null,"2025-01-13",{"$f":"M63","v":8.8230945026101271},{"$f":"W87","v":12.747315764716202},{"$f":"W96","v":7.323088175828385},{"$f":"N63","v":8.8230945026101271},null,null,14.444763120649789,13.309864676220213,19.07649793126977,17.550460305047075,12.641463493896442,11.640433314678548,16.708418219420519,15.362386135255681,8.5417046215368835,7.8733386570174089,11.275898523396375,10.377182329934673,10.312168606635989,13.519617707086891,9.0093681724196024,11.824532661372164,6.1033603346009748,7.9971865418854202]
[null,"2030-01-01",{"$f":"M64","v":6.0688626664301228},{"$f":"Y87","v":8.6444711125417033},{"$f":"Y96","v":4.6655733815844265},{"$f":"N64","v":6.0688626664301228},null,null,13.255803958739111,12.230981173315664,17.4777677312034,16.099742993886402,11.582722185187334,10.679711896817397,15.284785046376165,14.070555100355426,7.8450176121224047,7.2411519972693297,10.339100525931993,9.5271145249192895,9.4961360905057344,12.422342149129925,8.2827096279086891,10.847433533443368,5.6251948336647306,7.3542228039651478]
[null,null,null,null,null,null,null,null,12.296182506658811,11.271359721235365,16.518146279123105,15.140121541806099,10.623100733107036,9.7200904447370995,14.325163594295867,13.110933648275124,6.8853961600420996,6.2815305451890291,9.3794790738516856,8.5674930728389871,8.5365146384254338,11.462720697049624,7.323088175828385,9.8878120813630694,4.6655733815844265,6.3946013518848508]
[null,null,null,null,null,null,null,null,12.296182506658811,11.271359721235365,16.518146279123105,15.140121541806099,10.623100733107036,9.7200904447370995,14.325163594295867,13.110933648275124,6.8853961600420996,6.2815305451890291,9.3794790738516856,8.5674930728389871,8.5365146384254338,11.462720697049624,7.323088175828385,9.8878120813630694,4.6655733815844265,6.3946013518848508]
[null,null,null,null,null,null,null,null,"Copied from results, requires many successive runs of the decosting chart macro"]
[]
[]
[null,null,null,null,null,null,null,"Scen",18]
[null,null,null,null,null,null,null,"p",1,1,3,3,1,1,3,3,1,1,3,3,1,3,1,3,1,3]
[null,null,null,null,null,null,null,"Site",1,2,1,2,1,2,1,2,1,2,1,2,3,3,3,3,3,3]
[null,null,null,null,null,null,null,null,2020,2020,2020,2020,2025,2025,2025,2025,2030,2030,2030,2030,2020,2020,2025,2025,2030,2030]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!I101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!J101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!K101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!L101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!M101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!N101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!O101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!P101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!Q101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!R101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!S101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!T101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!U101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!V101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!W101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!X101)","v":"P90"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!Y101)","v":"P50"},{"$f":"INDEX(Lists!$D$4:$D$7,'Result tables'!Z101)","v":"P90"}]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!I102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!J102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!K102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!L102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!M102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!N102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!O102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!P102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!Q102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!R102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!S102)","v":"Offshore wind Gujarat"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!T102)","v":"Offshore wind Tamil Nadu Site B"},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!U102)","v":0},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!V102)","v":0},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!W102)","v":0},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!X102)","v":0},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!Y102)","v":0},{"$f":"INDEX(Lists!$B$4:$B$7,'Result tables'!Z102)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Opening","High","Low","Close"]
["Gujarat",2020,{"$f":"C88","v":8.097771630071847},{"$f":"D88","v":11.993992540324163},6.8853961600420996,8.097771630071847]
["Tamil Nadu Site C",2020,{"$f":"C91","v":5.804293496115509},{"$f":"D91","v":11.090610653704932},6.2815305451890291,5.804293496115509]
["Tamil Nadu Site B",2020,{"$f":"C94","v":6.0688626664301228},{"$f":"D94","v":8.6444711125417033},4.6655733815844265,6.0688626664301228]

{"sheet":"Data transformation ","index":11,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Data transformation "}]
[]
[null,{"$f":"'User Interface'!B6","v":"Generation technology"}]
[]
[null,{"$f":"'User Interface'!B8","v":"Technology"},null,{"$f":"'User Interface'!D8","v":"Energy Production "}]
[null,{"$f":"'User Interface'!B9","v":2},null,{"$f":"'User Interface'!D9","v":1}]
[]
[null,{"$f":"'User Interface'!B11","v":"Dimensioning and timing"}]
[]
[null,{"$f":"'User Interface'!B13","v":"Nominal capacity"},{"$f":"'User Interface'!C13","v":"MW"},{"$f":"'User Interface'!D13","v":500}]
[null,{"$f":"'User Interface'!B14","v":"1 st year of construction"},{"$f":"'User Interface'!C14","v":"Year"},{"$f":"'User Interface'!D14","v":2025}]
[null,{"$f":"'User Interface'!B15","v":"Construction time"},{"$f":"'User Interface'!C15","v":"Years"},{"$f":"'User Interface'!D15","v":4}]
[null,{"$f":"'User Interface'!B16","v":"Technical life"},{"$f":"'User Interface'!C16","v":"Years"},{"$f":"'User Interface'!D16+Sensitivity!$G$8","v":27}]
[]
[]
[null,{"$f":"'User Interface'!B24","v":"Generation data check"}]
[]
[null,{"$f":"'User Interface'!B26","v":"Net AEP after wake loss only"},{"$f":"'User Interface'!C26","v":"GWh"},{"$f":"'Technical data'!P32*(1+Sensitivity!$F$8)","v":2344.5513000000001}]
[null,{"$f":"'User Interface'!B27","v":"Capacity factor after wake loss only"},{"$f":"'User Interface'!C27","v":"%"},{"$f":"'User Interface'!D27","v":0.58782340862422999}]
[]
[null,{"$f":"'User Interface'!B19","v":"Annual variation in AEP"}]
[]
[null,{"$f":"'User Interface'!B21","v":"Annual variation in AEP"},{"$f":"'User Interface'!C21","v":false},{"$f":"C23*1","v":0}]
[]
[null,{"$f":"'User Interface'!B32","v":"Investment expenditure"}]
[]
[null,null,{"$f":"'User Interface'!C34","v":"Include"},{"$f":"'User Interface'!E34","v":"mUSD"}]
[null,{"$f":"'User Interface'!B35","v":"DEVEX"},{"$f":"'User Interface'!C35","v":true},{"$f":"'User Interface'!E35","v":39.491769039010045}]
[null,{"$f":"'User Interface'!B36","v":"PM"},{"$f":"'User Interface'!C36","v":true},{"$f":"'User Interface'!E36","v":37.123543018842504}]
[null,{"$f":"'User Interface'!B37","v":"Foundation"},{"$f":"'User Interface'!C37","v":true},{"$f":"'User Interface'!E37","v":87.464347474565997}]
[null,{"$f":"'User Interface'!B38","v":"WTG"},{"$f":"'User Interface'!C38","v":true},{"$f":"'User Interface'!E38","v":640.70114761829916}]
[null,{"$f":"'User Interface'!B39","v":"Array cabling"},{"$f":"'User Interface'!C39","v":true},{"$f":"'User Interface'!E39","v":140.81343903698883}]
[null,{"$f":"'User Interface'!B40","v":"Export system"},{"$f":"'User Interface'!C40","v":true},{"$f":"'User Interface'!E40","v":247.7036404877939}]
[null,{"$f":"'User Interface'!B41","v":"Installation"},{"$f":"'User Interface'!C41","v":true},{"$f":"'User Interface'!E41","v":231.70211332449972}]
[]
[null,{"$f":"'User Interface'!B43","v":"Total CAPEX (including VAT and duties)"},null,{"$f":"(SUM(D28:D34))*(1+Sensitivity!D8)","v":1425.0000000000002}]
[]
[]
[null,{"$f":"'User Interface'!B46","v":"Operational expenditure"}]
[]
[null,null,{"$f":"'User Interface'!C48","v":"Include"},{"$f":"'User Interface'!E48","v":"USD/unit"}]
[null,{"$f":"'CAPEX & OPEX'!D22","v":"USD/MWh"},{"$f":"'User Interface'!C49","v":false},{"$f":"'User Interface'!E49","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D23","v":"USD/MWh"},{"$f":"'User Interface'!C50","v":false},{"$f":"'User Interface'!E50","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D24","v":"USD/MWh"},{"$f":"'User Interface'!C51","v":false},{"$f":"'User Interface'!E51","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D25","v":"USD/MW"},{"$f":"'User Interface'!C52","v":true},{"$f":"'User Interface'!E52","v":63700}]
[null,{"$f":"'CAPEX & OPEX'!D26","v":"USD/MW"},{"$f":"'User Interface'!C53","v":false},{"$f":"'User Interface'!E53","v":0}]
[null,{"$f":"'CAPEX & OPEX'!D27","v":"USD/MW"},{"$f":"'User Interface'!C54","v":false},{"$f":"'User Interface'!E54","v":0}]
[]
[null,{"$f":"'User Interface'!B56","v":"Total variable OPEX"},null,{"$f":"SUM(D42:D44)*(1+Sensitivity!E8)","v":0}]
[null,{"$f":"'User Interface'!B57","v":"Total fixed OPEX"},null,{"$f":"SUM(D45:D47)*(1+Sensitivity!E8)","v":63700}]
[]
[]
[null,{"$f":"'User Interface'!B60","v":"PPA contract"}]
[]
[null,{"$f":"'User Interface'!B63","v":"Indexing"}]
[null,{"$f":"'User Interface'!B65","v":"Indexing"},{"$f":"'User Interface'!C65","v":false},{"$f":"'User Interface'!D65","v":0.03}]
[null,{"$f":"'User Interface'!B66","v":"Duration of indexing (years)"},null,{"$f":"'User Interface'!D66","v":15}]
[]
[null,{"$f":"'User Interface'!B69","v":"Payment schedule"}]
[]
[null,{"$f":"'User Interface'!B71","v":"Time from delivery to payment (months)"},{"$f":"'User Interface'!C71","v":false},{"$f":"'User Interface'!D71*C61","v":0}]
[]
[]
[null,{"$f":"'User Interface'!B74","v":"Curtailment"}]
[null,{"$f":"'User Interface'!B76","v":"Level of curtailment (% of Net AEP)"},{"$f":"'User Interface'!$C$76","v":false},{"$f":"'User Interface'!D76*C65","v":0}]
[]
[]
[null,{"$f":"'User Interface'!B79","v":"Over-/underproduction "}]
[null,{"$f":"'User Interface'!B81","v":"Committed AEP (GWh)"},null,{"$f":"'User Interface'!D81","v":2344.5513000000001}]
[null,"Comitted AEP (MWh)",null,{"$f":"CONVERT(D69,\"Gwh\",\"Mwh\")","v":2344551.3000000003}]
[null,{"$f":"'User Interface'!B82","v":"Percentage penalty for underproduction (% of Net AEP)"},{"$f":"'User Interface'!C82","v":false},{"$f":"'User Interface'!D82*Under_penalty_choice","v":0}]
[null,{"$f":"'User Interface'!B83","v":"Percentage penalty for overproduction (% of Net AEP)"},{"$f":"'User Interface'!C83","v":false},{"$f":"'User Interface'!D83*Over_penalty_choice","v":0}]
[]
[null,{"$f":"'User Interface'!B86","v":"Late commissioning"}]
[]
[null,{"$f":"'User Interface'!B88","v":"Delay in commissioning (months)"},{"$f":"'User Interface'!C88","v":false},{"$f":"'User Interface'!D88*C76","v":0}]
[null,{"$f":"'User Interface'!B89","v":"Probability of delay (%)"},null,{"$f":"'User Interface'!D89","v":0.5}]
[null,"Delay in commissioning (months)",null,{"$f":"ROUND(Prob_delay*Delay,0)","v":0}]
[null,{"$f":"'User Interface'!D91","v":"Years             &"},null,{"$f":"'User Interface'!D92","v":0}]
[null,{"$f":"'User Interface'!E91","v":"Months"},null,{"$f":"'User Interface'!E92","v":0}]
[]
[null,{"$f":"'User Interface'!B95","v":"Government incentives"}]
[]
[null,{"$f":"'User Interface'!B97","v":"Tax incentives"}]
[]
[null,{"$f":"'User Interface'!B99","v":"VAT"},{"$f":"'User Interface'!C99","v":false},{"$f":"'User Interface'!D99","v":"VAT excluded"}]
[null,{"$f":"'User Interface'!B100","v":"Duties"},{"$f":"'User Interface'!C100","v":false},{"$f":"'User Interface'!D100","v":"Duties excluded"}]
[]
[null,{"$f":"'User Interface'!B103","v":"Viability gap funding"}]
[]
[null,{"$f":"'User Interface'!B115","v":"GBI"},{"$f":"'User Interface'!C115","v":false},{"$f":"'User Interface'!E115*C91","v":0}]
[null,"GBI timeframe (years)",{"$f":"'User Interface'!C119*1","v":0},{"$f":"'User Interface'!D119","v":50}]
[null,{"$f":"'User Interface'!B111","v":"Investment subsidy"},{"$f":"'User Interface'!C111","v":false},{"$f":"'User Interface'!E111*Choice_ITC","v":0}]
[]
[null,{"$f":"'User Interface'!B128","v":"Financing"}]
[]
[null,{"$f":"'User Interface'!B130","v":"Equity financing"}]
[null,null,null,null,null,2020,2025,2030,{"$f":"Results!$I$6","v":2025}]
[null,{"$f":"'User Interface'!B132","v":"Cost of equity"},null,{"$f":"'User Interface'!D132*(1+Sensitivity!M8)*(1+I99)","v":0.12},null,null,0.2,0.5,{"$f":"INDEX(F99:H99,MATCH(I98,F98:H98,0))","v":0.2}]
[null,{"$f":"'User Interface'!B133","v":"Equity share"},null,{"$f":"'User Interface'!D133","v":0.25}]
[]
[null,{"$f":"'User Interface'!B136","v":"Loan financing"}]
[]
[null,{"$f":"'User Interface'!B138","v":"Interest during construction"},null,{"$f":"IF(Sensitivity!H8>0,Sensitivity!H8,'User Interface'!D138)","v":0.05}]
[]
[null,{"$f":"'User Interface'!B140","v":"Senior"}]
[null,{"$f":"'User Interface'!B141","v":"Financing share"},null,{"$f":"'User Interface'!D141","v":0.75},null,2020,2025,2030,{"$f":"Results!$I$6","v":2025}]
[null,{"$f":"'User Interface'!B142","v":"Interest rate"},null,{"$f":"'User Interface'!D142*(1+Sensitivity!I8)*(1+I108)","v":0.08},null,0,0,-0.25,{"$f":"INDEX(F108:H108,MATCH(I107,F107:H107,0))","v":0}]
[null,{"$f":"'User Interface'!B143","v":"Loan Tenor (years)"},null,{"$f":"ROUNDUP('User Interface'!D143*(1+Sensitivity!J8)*(1+I109),0)","v":15},null,0,0,0.33,{"$f":"INDEX(F109:H109,MATCH(I107,F107:H107,0))","v":0}]
[]
[null,{"$f":"'User Interface'!B145","v":"Subordinate"}]
[null,{"$f":"'User Interface'!B146","v":"Financing share"},null,{"$f":"'User Interface'!D146","v":0}]
[null,{"$f":"'User Interface'!B147","v":"Interest rate"},null,{"$f":"'User Interface'!D147*(1+Sensitivity!L8)","v":0.15}]
[null,{"$f":"'User Interface'!B148","v":"Loan Tenor (years)"},null,{"$f":"'User Interface'!D148*(1+Sensitivity!K8)","v":25}]
[null,{"$f":"'User Interface'!B149","v":"Simple WACC"},null,{"$f":"(D99*D100+D107*D108+D112*D113)","v":0.09}]
[null,{"$f":"'User Interface'!B150","v":"Time variant WACC"},null,{"$f":"'User Interface'!E150","v":9.0857725703423098E-2}]
[null,{"$f":"'User Interface'!B151","v":"Choice of WACC for NPV calculation"},{"$f":"'User Interface'!C151","v":true},{"$f":"'User Interface'!D151","v":"Simple WACC"}]
[]
[]
[null,{"$f":"'User Interface'!B155","v":"Exchange rate"}]
[]
[null,null,{"$f":"'User Interface'!C157","v":"Include"},{"$f":"'User Interface'!D157","v":"Percentage change"}]
[null,{"$f":"'User Interface'!B158","v":"Exchange rate uncertainty"},{"$f":"'User Interface'!C158","v":false},{"$f":"'User Interface'!D158","v":-0.08}]
[]
[]
[]
[null,{"$f":"'User Interface'!B162","v":"Cash reserves"}]
[]
[null,{"$f":"'User Interface'!B164","v":"Cash Reserve (% of CAPEX)"},{"$f":"'User Interface'!C164","v":false},{"$f":"'User Interface'!D164*C129","v":0}]

{"sheet":"Lists","index":12,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Lists"}]
[]
[null,"Technologies",null,"Uncertainty","No","PPA tariff","Monthly","Yes","Decreasing value","Cost of Equity",{"$f":"ADDRESS(ROW('User Interface'!$D$132),COLUMN('User Interface'!$D$132),4,1,\"User Interface\")","v":"'User Interface'!D132"},null,"LCOE",null,"CAPEX",null,"Subsidy goalseek ",null,2020]
[null,{"$f":"TRANSPOSE('Technical data'!$E$9:$H$9)","v":"Offshore wind Gujarat"},null,{"$f":"'Technical data'!D28","v":"P50"},"Yes","User defined","Annually","No","Straight line","Senior Debt rate",{"$f":"ADDRESS(ROW('User Interface'!$D$142),COLUMN('User Interface'!$D$142),4,1,\"User Interface\")","v":"'User Interface'!D142"},null,null,null,"OPEX",null,{"$f":"ADDRESS(ROW('User Interface'!D111),COLUMN('User Interface'!D111),4,1,\"User Interface\")","v":"'User Interface'!D111"},null,2025]
[null,"Offshore wind Tamil Nadu Site B",null,{"$f":"'Technical data'!D29","v":"P75"},null,"No compensation",null,null,"Digit sum","SNR Loan Tenure",{"$f":"ADDRESS(ROW('User Interface'!$D$143),COLUMN('User Interface'!$D$143),4,1,\"User Interface\")","v":"'User Interface'!D143"},null,null,null,"WACC",null,{"$f":"ADDRESS(ROW(Results!C11),COLUMN(Results!C11),4,1,\"Results\")","v":"Results!C11"},null,2030]
[null,0,null,{"$f":"'Technical data'!D30","v":"P90"},null,null,null,null,null,null,null,null,null,null,"Equity share"]
[null,0,null,{"$f":"'Technical data'!D31","v":"P95"},null,null,null,null,null,null,null,null,null,null,"PPA tariff",null,"Capacity goalseek "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Senior rate",null,{"$f":"ADDRESS(ROW(Nom_cap),COLUMN(Nom_cap),4,1,\"User Interface\")","v":"'User Interface'!D13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Senior Tenor",null,{"$f":"ADDRESS(ROW(Finance!$K$71),COLUMN(Finance!$K$71),4,1,\"Finance\")","v":"Finance!K71"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Equity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GBI goalseek"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ADDRESS(ROW('User Interface'!$D$115),COLUMN('User Interface'!$D$115),4,1,\"User Interface\")","v":"'User Interface'!D115"}]

{"sheet":"Abbreviations","index":13,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Abbreviations"}]
[]
[]
[null,"AEP","Annual electricty production"]
[null,"CAPEX","Capital Expenditures"]
[null,"DSRA","Debt-Service reserve account"]
[null,"LCOE","Levelized Cost of Energy"]
[null,"NPV","Net Present Value"]
[null,"OPEX","Operating Expenditures"]
[null,"PPA","Power Purchase Agreement"]
[null,"PTC","Production Tax Credit"]
[null,"PV","Present Value"]
[null,"VAT","Value-Added tax"]
[null,"WACC","Weighted Average Cost of Capital"]