{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Consolidado 2010-2020","Ger Centralizada 2010-2020","transmissao 2010-2020","dist 2010-2020","mmgd 2010-2020","pee 2008-2020","p&d 2008-2020","IPCA","Base de dados nominais"],"not_rendered":{"charts":23,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Consolidado 2010-2020","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[11,1,12,1],[27,1,28,1],[11,2,11,7],[27,2,27,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANO","Investimentos Anuais (R$ milhões)"]
[null,null,"Distribuição","MMGD","P&D","Eficiência Energética","Transmissão","Geração Centralizada","Total"]
[null,2010,{"$f":"'dist 2010-2020'!F13","v":18767.500488350939},null,{"$f":"'p&d 2008-2020'!C16","v":670.38929003195051},{"$f":"'pee 2008-2020'!D16","v":1014.1669619769078},{"$f":"'transmissao 2010-2020'!E13","v":7915.7115642168646},{"$f":"'Ger Centralizada 2010-2020'!I14","v":33585.870401256579},{"$f":"SUM(C14:H14)","v":61953.638705833248}]
[null,2011,{"$f":"'dist 2010-2020'!F14","v":17211.918908012682},null,{"$f":"'p&d 2008-2020'!C17","v":592.06595913952924},{"$f":"'pee 2008-2020'!D17","v":802.79946474773556},{"$f":"'transmissao 2010-2020'!E14","v":8937.9931560302757},{"$f":"'Ger Centralizada 2010-2020'!I15","v":31148.265997042698},{"$f":"SUM(C15:H15)","v":58693.043484972921}]
[null,2012,{"$f":"'dist 2010-2020'!F15","v":18241.324048050497},null,{"$f":"'p&d 2008-2020'!C18","v":939.26523552403341},{"$f":"'pee 2008-2020'!D18","v":769.36538627465404},{"$f":"'transmissao 2010-2020'!E15","v":10235.095249179767},{"$f":"'Ger Centralizada 2010-2020'!I16","v":36808.075266386404},66993.125185415352]
[null,2013,{"$f":"'dist 2010-2020'!F16","v":15875.268097389784},{"$f":"'mmgd 2010-2020'!G16","v":20.83410829291795},{"$f":"'p&d 2008-2020'!C19","v":552.11451080284064},{"$f":"'pee 2008-2020'!D19","v":626.06188587476254},{"$f":"'transmissao 2010-2020'!E16","v":8397.1455544838573},{"$f":"'Ger Centralizada 2010-2020'!I17","v":40997.334465742475},66468.75862258664]
[null,2014,{"$f":"'dist 2010-2020'!F17","v":14179.635986465049},{"$f":"'mmgd 2010-2020'!G17","v":38.245716061969809},{"$f":"'p&d 2008-2020'!C20","v":742.23446747055073},{"$f":"'pee 2008-2020'!D20","v":676.4936003320114},{"$f":"'transmissao 2010-2020'!E17","v":8719.4485658157901},{"$f":"'Ger Centralizada 2010-2020'!I18","v":40200.601213445669},64556.659549591044]
[null,2015,{"$f":"'dist 2010-2020'!F18","v":14366.954141396831},{"$f":"'mmgd 2010-2020'!G18","v":102.18930256624749},{"$f":"'p&d 2008-2020'!C21","v":570.80625044522242},{"$f":"'pee 2008-2020'!D21","v":710.03405221287414},{"$f":"'transmissao 2010-2020'!E18","v":11448.196278260762},{"$f":"'Ger Centralizada 2010-2020'!I19","v":36853.688707052941},64051.868731934876]
[null,2016,{"$f":"'dist 2010-2020'!F19","v":16049.285343777876},{"$f":"'mmgd 2010-2020'!G19","v":607.67456228615754},{"$f":"'p&d 2008-2020'!C22","v":545.92631422072998},{"$f":"'pee 2008-2020'!D22","v":599.05083018754317},{"$f":"'transmissao 2010-2020'!E19","v":21824.139005246339},{"$f":"'Ger Centralizada 2010-2020'!I20","v":36094.302681383218},75720.378737101855]
[null,2017,{"$f":"'dist 2010-2020'!F20","v":17732.449003246238},{"$f":"'mmgd 2010-2020'!G20","v":1057.1752971214771},{"$f":"'p&d 2008-2020'!C23","v":625.88604281717323},{"$f":"'pee 2008-2020'!D23","v":614.94992175327377},{"$f":"'transmissao 2010-2020'!E20","v":22933.801729104576},{"$f":"'Ger Centralizada 2010-2020'!I21","v":28119.990946734248},71084.252940776991]
[null,2018,{"$f":"'dist 2010-2020'!F21","v":16706.163898345494},{"$f":"'mmgd 2010-2020'!G21","v":2347.4239588795717},{"$f":"'p&d 2008-2020'!C24","v":949.54756703608598},{"$f":"'pee 2008-2020'!D24","v":554.15528713454864},{"$f":"'transmissao 2010-2020'!E21","v":23344.963973886577},{"$f":"'Ger Centralizada 2010-2020'!I22","v":17987.372224166698},61889.626909448976]
[null,2019,{"$f":"'dist 2010-2020'!F22","v":18569.896671795497},{"$f":"'mmgd 2010-2020'!G22","v":6729.6930526845708},{"$f":"'p&d 2008-2020'!C25","v":1102.2771546661604},{"$f":"'pee 2008-2020'!D25","v":717.03796082751182},{"$f":"'transmissao 2010-2020'!E22","v":21494.450569934161},{"$f":"'Ger Centralizada 2010-2020'!I23","v":22663.196532245416},71276.551942153324]
[null,2020,{"$f":"'dist 2010-2020'!F23","v":19262.157999999999},{"$f":"'mmgd 2010-2020'!G23","v":10409.400180073206},{"$f":"'p&d 2008-2020'!C26","v":888.448894},{"$f":"'pee 2008-2020'!D26","v":605.01196900000002},{"$f":"'transmissao 2010-2020'!E23","v":17291.57577361101},{"$f":"'Ger Centralizada 2010-2020'!I24","v":29144.921487176165},{"$f":"SUM(C24:H24)","v":77601.516303860379}]
[null,"Total",{"$f":"SUM(C14:C24)","v":186962.55458683087},{"$f":"SUM(D14:D24)","v":21312.636177966117},8178.9616861542763,7689.1273203218234,162542.52141976997,353603.61992263247,740289.42111367546]
[]
[]
[null,null,"Investimentos Anuais (R$ bilhões)"]
[null,null,"Distribuição","MMGD","P&D","Eficiência Energética","Transmissão","Geração Centralizada","Total"]
[null,2010,{"$f":"C14/1000","v":18.76750048835094},{"$f":"D14/1000","v":0},{"$f":"E14/1000","v":0.67038929003195047},1.0141669619769078,7.9157115642168643,33.585870401256578,61.953638705833249]
[null,2011,17.211918908012681,{"$f":"D15/1000","v":0},0.5920659591395292,0.80279946474773556,{"$f":"G15/1000","v":8.9379931560302754},31.148265997042696,58.693043484972918]
[null,2012,18.241324048050497,0,0.9392652355240334,0.76936538627465401,10.235095249179768,36.808075266386403,66.993125185415352]
[null,2013,15.875268097389784,2.0834108292917951E-2,0.55211451080284069,0.62606188587476252,8.397145554483858,40.997334465742476,66.468758622586634]
[null,2014,14.179635986465049,3.824571606196981E-2,0.74223446747055077,0.67649360033201145,8.7194485658157905,40.200601213445665,64.556659549591046]
[null,2015,14.36695414139683,0.10218930256624749,0.57080625044522237,0.71003405221287419,11.448196278260763,36.853688707052939,64.051868731934874]
[null,2016,16.049285343777875,0.60767456228615757,0.54592631422073001,0.59905083018754313,21.824139005246341,36.094302681383219,75.720378737101854]
[null,2017,17.732449003246238,1.0571752971214772,0.62588604281717319,0.61494992175327379,22.933801729104577,28.119990946734248,71.084252940776992]
[null,2018,16.706163898345494,2.3474239588795718,0.949547567036086,0.55415528713454865,23.344963973886578,17.987372224166698,61.889626909448978]
[null,2019,18.569896671795497,6.7296930526845706,1.1022771546661605,0.71703796082751181,21.494450569934159,22.663196532245415,71.276551942153318]
[null,2020,19.262157999999999,10.409400180073206,0.88844889400000004,0.60501196899999998,17.291575773611012,29.144921487176166,77.601516303860379]
[null,"Total",{"$f":"SUM(C30:C40)","v":186.96255458683089},{"$f":"SUM(D30:D40)","v":21.31263617796612},8.1789616861542775,7.6891273203218233,162.54252141977,353.6036199226325,740.28942111367576]
[null,null,{"$f":"C41/$I$41","v":0.25255332475988701},{"$f":"D41/$I$41","v":2.8789599810711653E-2},1.104832981923478E-2,1.0386650276258794E-2,0.21956618152836016,0.47765591380554739,1]

{"sheet":"Ger Centralizada 2010-2020","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,1,44,8],[11,1,11,8],[27,1,27,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investimentos em Geração Centralizada (milhões de reais)"]
[null,"Ano","Eólica","PCH","Fotovoltaica","UHE","Biomassa","UTE Fóssil","Total Geral"]
[null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C79,'Base de dados nominais'!C79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":3415.9150955031182},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D79,'Base de dados nominais'!D79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":3788.3394383917876},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E79,'Base de dados nominais'!E79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F79,'Base de dados nominais'!F79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":16946.11582438197},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G79,'Base de dados nominais'!G79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":2817.3579646550884},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H79,'Base de dados nominais'!H79*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":6618.1420783246131},{"$f":"SUM(C14:H14)","v":33585.870401256579}]
[null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C80,'Base de dados nominais'!C80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":2633.5291517733781},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D80,'Base de dados nominais'!D80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":2654.2200499652304},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E80,'Base de dados nominais'!E80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F80,'Base de dados nominais'!F80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":16733.10556408043},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G80,'Base de dados nominais'!G80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":3377.9696075135953},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H80,'Base de dados nominais'!H80*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":5749.4416237100686},{"$f":"SUM(C15:H15)","v":31148.265997042698}]
[null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C81,'Base de dados nominais'!C81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":6212.2296096062018},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D81,'Base de dados nominais'!D81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":1637.6541204935518},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E81,'Base de dados nominais'!E81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F81,'Base de dados nominais'!F81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":18368.13253962847},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G81,'Base de dados nominais'!G81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":4228.8573731963261},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H81,'Base de dados nominais'!H81*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":6361.201623461855},36808.075266386404]
[null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C82,'Base de dados nominais'!C82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":15693.608359597405},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D82,'Base de dados nominais'!D82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":1344.2366668417897},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E82,'Base de dados nominais'!E82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F82,'Base de dados nominais'!F82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":17855.620865750156},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G82,'Base de dados nominais'!G82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":3280.6363977327378},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H82,'Base de dados nominais'!H82*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":2823.2321758203934},40997.334465742475]
[null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C83,'Base de dados nominais'!C83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":15330.804894071072},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D83,'Base de dados nominais'!D83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":1579.3091403135361},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E83,'Base de dados nominais'!E83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F83,'Base de dados nominais'!F83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":17275.38176947449},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G83,'Base de dados nominais'!G83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":3346.0534401374698},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H83,'Base de dados nominais'!H83*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":2669.0519694491004},40200.601213445669]
[null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C84,'Base de dados nominais'!C84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":14034.742866038065},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D84,'Base de dados nominais'!D84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":1581.2963725582615},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E84,'Base de dados nominais'!E84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F84,'Base de dados nominais'!F84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":16065.444193142288},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G84,'Base de dados nominais'!G84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":2911.9350802725157},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H84,'Base de dados nominais'!H84*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":2260.2701950418095},36853.688707052941]
[null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C85,'Base de dados nominais'!C85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":12449.704499110161},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D85,'Base de dados nominais'!D85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":1426.2364453634941},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E85,'Base de dados nominais'!E85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":5601.5271687752111},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F85,'Base de dados nominais'!F85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":13497.403993315749},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G85,'Base de dados nominais'!G85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":1710.3754380758592},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H85,'Base de dados nominais'!H85*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":1409.0551367427395},36094.302681383218]
[null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C86,'Base de dados nominais'!C86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":9851.007580647467},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D86,'Base de dados nominais'!D86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":1354.9150349451402},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E86,'Base de dados nominais'!E86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":4786.3388462821822},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F86,'Base de dados nominais'!F86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":8793.6993586496992},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G86,'Base de dados nominais'!G86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":725.82965635289372},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H86,'Base de dados nominais'!H86*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":2608.2004698568662},28119.990946734248]
[null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C87,'Base de dados nominais'!C87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":6426.8845461076044},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D87,'Base de dados nominais'!D87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":1184.9928744297347},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E87,'Base de dados nominais'!E87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":3366.3633081157059},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F87,'Base de dados nominais'!F87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":2289.6255217097146},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G87,'Base de dados nominais'!G87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":951.64354712250372},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H87,'Base de dados nominais'!H87*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":3767.8624266814359},17987.372224166698]
[null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C88,'Base de dados nominais'!C88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":11310.248021094691},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D88,'Base de dados nominais'!D88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":1100.1103340079906},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E88,'Base de dados nominais'!E88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":3463.9510969523913},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F88,'Base de dados nominais'!F88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":388.01637195745178},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G88,'Base de dados nominais'!G88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":1481.4898063037749},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H88,'Base de dados nominais'!H88*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":4919.3809019291193},{"$f":"SUM(C23:H23)","v":22663.196532245416}]
[null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C89,'Base de dados nominais'!C89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":15611.409357999999},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D89,'Base de dados nominais'!D89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":1287.8191079868643},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E89,'Base de dados nominais'!E89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":4997.3056969866657},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F89,'Base de dados nominais'!F89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":387.18301583674264},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!G89,'Base de dados nominais'!G89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":2378.7571022666666},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!H89,'Base de dados nominais'!H89*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":4482.4472060992284},29144.921487176165]
[null,"Total Geral",{"$f":"SUM(C14:C24)","v":112970.08398154916},{"$f":"SUM(D14:D24)","v":18939.129585297382},22215.486117112156,128599.72901792717,27210.905413629433,{"$f":"SUM(H14:H24)","v":43668.28580711723},353603.61992263247]
[]
[]
[null,"Investimentos em Geração Centralizada (bilhões de reais)"]
[null,"Ano","Eólica","PCH","Fotovoltaica","UHE","Biomassa","UTE Fóssil","Total Geral"]
[null,2010,{"$f":"C14/1000","v":3.4159150955031183},{"$f":"D14/1000","v":3.7883394383917874},0,{"$f":"F14/1000","v":16.94611582438197},2.8173579646550886,6.6181420783246132,{"$f":"SUM(C30:H30)","v":33.585870401256571}]
[null,2011,{"$f":"C15/1000","v":2.6335291517733781},2.6542200499652302,0,{"$f":"F15/1000","v":16.733105564080429},3.3779696075135952,5.7494416237100685,{"$f":"SUM(C31:H31)","v":31.148265997042703}]
[null,2012,6.2122296096062017,1.6376541204935517,0,{"$f":"F16/1000","v":18.368132539628469},4.2288573731963259,6.3612016234618549,36.808075266386403]
[null,2013,15.693608359597405,1.3442366668417896,0,{"$f":"F17/1000","v":17.855620865750154},3.2806363977327377,2.8232321758203933,40.997334465742483]
[null,2014,15.330804894071072,1.5793091403135362,0,{"$f":"F18/1000","v":17.275381769474489},3.34605344013747,2.6690519694491006,40.200601213445665]
[null,2015,14.034742866038064,1.5812963725582616,0,{"$f":"F19/1000","v":16.065444193142287},2.9119350802725159,2.2602701950418096,36.853688707052939]
[null,2016,12.449704499110162,1.4262364453634941,5.6015271687752115,{"$f":"F20/1000","v":13.49740399331575},1.7103754380758591,1.4090551367427395,36.094302681383212]
[null,2017,9.8510075806474671,1.3549150349451402,4.7863388462821819,{"$f":"F21/1000","v":8.7936993586496985},0.72582965635289376,2.6082004698568664,28.119990946734248]
[null,2018,6.4268845461076047,1.1849928744297347,3.3663633081157061,{"$f":"F22/1000","v":2.2896255217097146},0.95164354712250376,3.767862426681436,17.987372224166698]
[null,2019,11.31024802109469,1.1001103340079905,3.4639510969523912,{"$f":"F23/1000","v":0.38801637195745176},1.4814898063037749,4.9193809019291193,22.663196532245415]
[null,2020,15.611409358,1.2878191079868644,4.9973056969866656,{"$f":"F24/1000","v":0.38718301583674264},2.3787571022666665,4.4824472060992289,29.14492148717617]
[null,"Total Geral",{"$f":"SUM(C30:C40)","v":112.97008398154917},{"$f":"SUM(D30:D40)","v":18.93912958529738},22.215486117112157,{"$f":"SUM(F30:F40)","v":128.59972901792716},27.210905413629433,43.668285807117236,353.6036199226325]
[]
[]
[]
[null,"Investimentos Acumulados (R$ bilhões)"]
[null,"Ano","Eólica","PCH","Fotovoltaica","UHE","Biomassa","UTE Fóssil","Total Geral"]
[null,2010,{"$f":"C30","v":3.4159150955031183},{"$f":"D30","v":3.7883394383917874},0,{"$f":"F30","v":16.94611582438197},2.8173579646550886,6.6181420783246132,33.585870401256571]
[null,2011,{"$f":"C31+C47","v":6.0494442472764964},{"$f":"D31+D47","v":6.4425594883570181},0,{"$f":"F31+F47","v":33.679221388462395},{"$f":"G31+G47","v":6.1953275721686838},12.367583702034683,64.73413639829927,{"$f":"(I48-I47)/I47","v":0.92742172898628605}]
[null,2012,{"$f":"C32+C48","v":12.261673856882698},8.0802136088505705,0,52.047353928090864,10.42418494536501,18.728785325496538,101.54221166468568,{"$f":"(I49-I48)/I48","v":0.56860378950468937}]
[null,2013,27.955282216480104,9.4244502756923598,0,69.902974793841025,13.704821343097748,21.552017501316932,142.53954613042816,0.4037467157119301]
[null,2014,43.286087110551179,11.003759416005895,0,87.178356563315518,17.050874783235219,24.221069470766032,182.74014734387384,0.28203121382651847]
[null,2015,57.320829976589245,12.585055788564157,0,103.2438007564578,19.962809863507736,26.481339665807841,219.59383605092677,0.20167264414919714]
[null,2016,69.770534475699407,14.011292233927652,5.6015271687752115,116.74120474977354,21.673185301583594,27.890394802550581,255.68813873230999,0.16436846921792683]
[null,2017,79.621542056346868,15.366207268872792,10.387866015057394,125.53490410842325,22.399014957936487,30.498595272407449,283.80812967904421,0.10997769034634082]
[null,2018,86.04842660245447,16.551200143302527,13.754229323173099,127.82452963013296,23.350658505058991,34.266457699088889,301.79550190321089,6.3378636279758496E-2]
[null,2019,97.358674623549163,17.651310477310517,17.218180420125492,128.21254600209042,24.832148311362765,39.185838601018006,324.45869843545631,7.5094547100021905E-2]
[null,2020,112.97008398154917,18.93912958529738,22.215486117112157,128.59972901792716,27.210905413629433,43.668285807117236,353.6036199226325,8.9826291074066894E-2]

{"sheet":"transmissao 2010-2020","index":2,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[43,1,43,4],[10,1,10,6],[26,1,26,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investimentos em Transmissão (milhões de reais)"]
[null,"Ano","LT","SE","Total Geral","%LT/Total"]
[null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C30,'Base de dados nominais'!C30*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":4268.9146782930802},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D30,'Base de dados nominais'!D30*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":3646.7968859237844},{"$f":"SUM(C13:D13)","v":7915.7115642168646},{"$f":"C13/E13","v":0.53929639093859816}]
[null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C31,'Base de dados nominais'!C31*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":4696.7240409304504},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D31,'Base de dados nominais'!D31*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":4241.2691150998253},8937.9931560302757,{"$f":"C14/E14","v":0.5254785899854566}]
[null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C32,'Base de dados nominais'!C32*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":5471.556203619908},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D32,'Base de dados nominais'!D32*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":4763.539045559859},10235.095249179767,0.53458771710584663]
[null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C33,'Base de dados nominais'!C33*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":4587.7632258809417},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D33,'Base de dados nominais'!D33*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":3809.3823286029165},8397.1455544838573,0.54634794599114644]
[null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C34,'Base de dados nominais'!C34*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":4769.0351380871198},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D34,'Base de dados nominais'!D34*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":3950.4134277286698},8719.4485658157901,0.5469422867845003]
[null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C35,'Base de dados nominais'!C35*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":6169.9394182368078},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D35,'Base de dados nominais'!D35*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":5278.2568600239538},11448.196278260762,0.53894423787553714]
[null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C36,'Base de dados nominais'!C36*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":13724.636693726132},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D36,'Base de dados nominais'!D36*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":8099.5023115202057},21824.139005246339,0.62887414208766013]
[null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C37,'Base de dados nominais'!C37*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":14392.08962377645},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D37,'Base de dados nominais'!D37*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":8541.7121053281244},22933.801729104576,0.62754923033593224]
[null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C38,'Base de dados nominais'!C38*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":15316.27466955423},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D38,'Base de dados nominais'!D38*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":8028.6893043323471},23344.963973886577,0.6560847421605297]
[null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C39,'Base de dados nominais'!C39*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":14478.533776784452},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D39,'Base de dados nominais'!D39*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":7015.9167931497068},21494.450569934161,0.67359403906032478]
[null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C40,'Base de dados nominais'!C40*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":12552.002020416399},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D40,'Base de dados nominais'!D40*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":4739.5737531946097},17291.57577361101,0.7259027277069936]
[null,"Total Geral",{"$f":"SUM(C13:C23)","v":100427.46948930596},{"$f":"SUM(D13:D23)","v":62115.051930463989},162542.52141976997]
[]
[]
[null,"Investimentos em Transmissão (bilhões de reais)"]
[null,"Ano","LT","SE","Total Geral"]
[null,2010,{"$f":"C13/1000","v":4.26891467829308},{"$f":"D13/1000","v":3.6467968859237843},{"$f":"SUM(C29:D29)","v":7.9157115642168643}]
[null,2011,{"$f":"C14/1000","v":4.6967240409304507},4.2412691150998256,8.9379931560302772]
[null,2012,5.4715562036199081,4.7635390455598587,10.235095249179768]
[null,2013,{"$f":"C16/1000","v":4.5877632258809413},3.8093823286029163,8.397145554483858]
[null,2014,4.7690351380871201,3.95041342772867,8.7194485658157905]
[null,2015,{"$f":"C18/1000","v":6.1699394182368081},5.2782568600239541,11.448196278260763]
[null,2016,13.724636693726131,8.0995023115202063,21.824139005246337]
[null,2017,14.39208962377645,8.5417121053281235,22.933801729104573]
[null,2018,15.316274669554231,8.0286893043323477,23.344963973886578]
[null,2019,14.478533776784452,7.0159167931497066,21.494450569934159]
[null,2020,12.552002020416399,4.7395737531946098,17.291575773611008]
[null,"Total Geral",{"$f":"SUM(C29:C39)","v":100.42746948930598},{"$f":"SUM(D29:D39)","v":62.115051930464006},162.54252141977]
[]
[]
[]
[null,"Investimentos Acumulados (R$ bilhões)"]
[null,"Ano","LT","SE","Total Geral","Acum(n)/Acum(n-1)"]
[null,2010,{"$f":"C29","v":4.26891467829308},{"$f":"D29","v":3.6467968859237843},7.9157115642168643]
[null,2011,{"$f":"C30+C46","v":8.9656387192235307},{"$f":"D30+D46","v":7.8880660010236099},16.853704720247141,{"$f":"(E47-E46)/E46","v":1.129145887077879}]
[null,2012,{"$f":"C31+C47","v":14.437194922843439},12.65160504658347,27.088799969426908,{"$f":"(E48-E47)/E47","v":0.60729052864465294}]
[null,2013,19.02495814872438,16.460987375186384,35.485945523910765,0.3099858821343538]
[null,2014,23.793993286811499,20.411400802915054,44.205394089726553,0.24571554842579979]
[null,2015,29.963932705048308,25.689657662939009,55.65359036798732,0.25897736043306435]
[null,2016,43.68856939877444,33.789159974459217,77.477729373233657,0.39214251696867825]
[null,2017,58.08065902255089,42.330872079787341,100.41153110233823,0.29600508319785046]
[null,2018,73.396933692105122,50.359561384119687,123.75649507622481,0.23249285931208111]
[null,2019,87.875467468889582,57.375478177269393,145.25094564615898,0.17368341400340392]
[null,2020,100.42746948930598,62.115051930464006,162.54252141977,0.11904621823071948]

{"sheet":"dist 2010-2020","index":3,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[43,1,43,5],[10,1,10,5],[26,1,26,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investimentos em distribuição de energia elétrica (milhões de reais)"]
[null,"Ano","Total",null,null,{"$f":"C12","v":"Total"}]
[null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C2,'Base de dados nominais'!$C2*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":18767.500488350939},null,null,{"$f":"C13","v":18767.500488350939},{"$f":"C13/F13","v":1}]
[null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C3,'Base de dados nominais'!$C3*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":17211.918908012682},null,null,17211.918908012682,{"$f":"C14/F14","v":1}]
[null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C4,'Base de dados nominais'!$C4*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":18241.324048050497},null,null,18241.324048050497,1]
[null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C5,'Base de dados nominais'!$C5*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":15875.268097389784},null,null,15875.268097389784,1]
[null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C6,'Base de dados nominais'!$C6*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":14179.635986465049},null,null,14179.635986465049,1]
[null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C7,'Base de dados nominais'!$C7*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":14366.954141396831},null,null,14366.954141396831,1]
[null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C8,'Base de dados nominais'!$C8*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":16049.285343777876},null,null,16049.285343777876,1]
[null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C9,'Base de dados nominais'!$C9*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":17732.449003246238},null,null,17732.449003246238,1]
[null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C10,'Base de dados nominais'!$C10*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":16706.163898345494},null,null,16706.163898345494,1]
[null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C11,'Base de dados nominais'!$C11*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":18569.896671795497},null,null,18569.896671795497,1]
[null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!$C12,'Base de dados nominais'!$C12*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":19262.157999999999},null,null,19262.157999999999,1]
[null,"Total Geral",{"$f":"SUM(C13:C23)","v":186962.55458683087},null,null,186962.55458683087]
[]
[]
[null,"Investimentos em distribuição de energia elétrica (bilhões de reais)"]
[null,"Ano","Total",null,null,"Total Geral"]
[null,2010,{"$f":"C13/1000","v":18.76750048835094},null,null,{"$f":"SUM(C29:E29)","v":18.76750048835094}]
[null,2011,{"$f":"C14/1000","v":17.211918908012681},null,null,{"$f":"SUM(C30:E30)","v":17.211918908012681}]
[null,2012,{"$f":"C15/1000","v":18.241324048050497},null,null,18.241324048050497]
[null,2013,{"$f":"C16/1000","v":15.875268097389784},null,null,15.875268097389784]
[null,2014,{"$f":"C17/1000","v":14.179635986465049},null,null,14.179635986465049]
[null,2015,{"$f":"C18/1000","v":14.36695414139683},null,null,14.36695414139683]
[null,2016,{"$f":"C19/1000","v":16.049285343777875},null,null,16.049285343777875]
[null,2017,{"$f":"C20/1000","v":17.732449003246238},null,null,17.732449003246238]
[null,2018,{"$f":"C21/1000","v":16.706163898345494},null,null,16.706163898345494]
[null,2019,{"$f":"C22/1000","v":18.569896671795497},null,null,18.569896671795497]
[null,2020,{"$f":"C23/1000","v":19.262157999999999},null,null,19.262157999999999]
[null,"Total Geral",{"$f":"SUM(C29:C39)","v":186.96255458683089},null,null,{"$f":"SUM(F29:F39)","v":186.96255458683089}]
[]
[]
[]
[null,"Investimentos Acumulados (R$ bilhões)"]
[null,"Ano","Total",null,null,"Total"]
[null,2010,{"$f":"C29","v":18.76750048835094},null,null,{"$f":"F29","v":18.76750048835094}]
[null,2011,{"$f":"C30+C46","v":35.979419396363625},null,null,{"$f":"F30+F46","v":35.979419396363625}]
[null,2012,{"$f":"C31+C47","v":54.220743444414126},null,null,{"$f":"F31+F47","v":54.220743444414126}]
[null,2013,70.096011541803904,null,null,70.096011541803904]
[null,2014,84.275647528268948,null,null,84.275647528268948]
[null,2015,98.64260166966578,null,null,98.64260166966578]
[null,2016,114.69188701344365,null,null,114.69188701344365]
[null,2017,132.42433601668989,null,null,132.42433601668989]
[null,2018,149.13049991503539,null,null,149.13049991503539]
[null,2019,167.70039658683089,null,null,167.70039658683089]
[null,2020,186.96255458683089,null,null,186.96255458683089]

{"sheet":"mmgd 2010-2020","index":4,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[43,1,43,6],[10,1,10,6],[26,1,26,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investimentos em geração distribuída (milhões de reais)"]
[null,"Ano","Eólica","Fotovoltaica","Hidro","Termelétrica","Total Geral"]
[null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C16,'Base de dados nominais'!C16*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D16,'Base de dados nominais'!D16*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E16,'Base de dados nominais'!E16*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F16,'Base de dados nominais'!F16*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B13,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"SUM(C13:F13)","v":0}]
[null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C17,'Base de dados nominais'!C17*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D17,'Base de dados nominais'!D17*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E17,'Base de dados nominais'!E17*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F17,'Base de dados nominais'!F17*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"SUM(C14:F14)","v":0}]
[null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C18,'Base de dados nominais'!C18*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D18,'Base de dados nominais'!D18*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E18,'Base de dados nominais'!E18*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F18,'Base de dados nominais'!F18*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},0]
[null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C19,'Base de dados nominais'!C19*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":0.20440184293086683},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D19,'Base de dados nominais'!D19*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":20.629706449987083},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E19,'Base de dados nominais'!E19*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F19,'Base de dados nominais'!F19*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":0},{"$f":"SUM(C16:F16)","v":20.83410829291795}]
[null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C20,'Base de dados nominais'!C20*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":0.30320641875581916},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D20,'Base de dados nominais'!D20*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":28.03651111740275},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E20,'Base de dados nominais'!E20*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":8.474713567709232},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F20,'Base de dados nominais'!F20*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":1.4312849581020033},38.245716061969809]
[null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C21,'Base de dados nominais'!C21*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":0.53261704347932537},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D21,'Base de dados nominais'!D21*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":93.115729574562337},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E21,'Base de dados nominais'!E21*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":8.353563853582216E-2},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F21,'Base de dados nominais'!F21*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":8.4574203096700096},102.18930256624749]
[null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C22,'Base de dados nominais'!C22*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":40.339951434606455},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D22,'Base de dados nominais'!D22*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":448.91304605621212},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E22,'Base de dados nominais'!E22*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":2.8436938997424468},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F22,'Base de dados nominais'!F22*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":115.57787089559646},607.67456228615754]
[null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C23,'Base de dados nominais'!C23*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":39.792288630310217},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D23,'Base de dados nominais'!D23*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":797.24564220933007},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E23,'Base de dados nominais'!E23*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":95.1664295194103},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F23,'Base de dados nominais'!F23*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":124.97093676242665},1057.1752971214771]
[null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C24,'Base de dados nominais'!C24*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":0.21585591135177951},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D24,'Base de dados nominais'!D24*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":2119.1043854827622},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E24,'Base de dados nominais'!E24*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":42.410780764457591},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F24,'Base de dados nominais'!F24*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":185.69293672100005},2347.4239588795717]
[null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C25,'Base de dados nominais'!C25*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":0.31947067165546733},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D25,'Base de dados nominais'!D25*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":6429.1376028558643},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E25,'Base de dados nominais'!E25*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":26.252172233447673},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F25,'Base de dados nominais'!F25*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":273.9838069236032},6729.6930526845708]
[null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C26,'Base de dados nominais'!C26*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":31.762431249999999},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!D26,'Base de dados nominais'!D26*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":10107.381488823206},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!E26,'Base de dados nominais'!E26*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":15},{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!F26,'Base de dados nominais'!F26*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":255.25626},10409.400180073206]
[null,"Total Geral",{"$f":"SUM(C13:C23)","v":113.47022320308992},{"$f":"SUM(D13:D23)","v":20043.564112569329},190.23132562330306,965.37051657039831,21312.636177966117]
[]
[]
[null,"Investimentos em geração distribuída (bilhões de reais)"]
[null,"Ano","Eólica","Fotovoltaica","Hidro","Termelétrica","Total Geral"]
[null,2010,{"$f":"C13/1000","v":0},{"$f":"D13/1000","v":0},0,0,{"$f":"SUM(C29:F29)","v":0}]
[null,2011,{"$f":"C14/1000","v":0},0,0,0,{"$f":"SUM(C30:F30)","v":0}]
[null,2012,0,0,0,0,0]
[null,2013,2.0440184293086684E-4,2.0629706449987083E-2,0,0,2.0834108292917951E-2]
[null,2014,3.0320641875581917E-4,2.8036511117402751E-2,8.4747135677092321E-3,1.4312849581020032E-3,3.8245716061969803E-2]
[null,2015,5.3261704347932538E-4,9.3115729574562336E-2,8.3535638535822164E-5,8.4574203096700103E-3,0.10218930256624749]
[null,2016,4.0339951434606454E-2,0.44891304605621213,2.8436938997424468E-3,0.11557787089559646,0.60767456228615746]
[null,2017,3.9792288630310216E-2,0.79724564220933003,9.5166429519410303E-2,0.12497093676242664,1.0571752971214772]
[null,2018,2.1585591135177951E-4,2.1191043854827623,4.241078076445759E-2,0.18569293672100004,2.3474239588795713]
[null,2019,3.1947067165546733E-4,6.4291376028558647,2.6252172233447675E-2,0.27398380692360319,6.7296930526845706]
[null,2020,3.1762431250000001E-2,10.107381488823206,1.4999999999999999E-2,0.25525626000000001,10.409400180073206]
[null,"Total Geral",{"$f":"SUM(C29:C39)","v":0.11347022320308993},{"$f":"SUM(D29:D39)","v":20.043564112569328},0.19023132562330308,0.96537051657039841,21.31263617796612]
[]
[]
[]
[null,"Investimentos Acumulados (R$ bilhões)"]
[null,"Ano","Eólica","Fotovoltaica","Hidro","Termelétrica","Total Geral"]
[null,2010,{"$f":"C29","v":0},{"$f":"D29","v":0},{"$f":"E29","v":0},0,0]
[null,2011,{"$f":"C30+C46","v":0},{"$f":"D30+D46","v":0},0,0,0]
[null,2012,{"$f":"C31+C47","v":0},0,0,0,0]
[null,2013,2.0440184293086684E-4,2.0629706449987083E-2,0,0,2.0834108292917951E-2]
[null,2014,5.0760826168668599E-4,4.8666217567389834E-2,8.4747135677092321E-3,1.4312849581020032E-3,5.9079824354887754E-2,{"$f":"(G50-G49)/G49","v":1.8357260855253645}]
[null,2015,1.0402253051660115E-3,0.14178194714195216,8.5582492062450544E-3,9.888705267772014E-3,0.16126912692113524,{"$f":"(G51-G50)/G50","v":1.7296818953354456}]
[null,2016,4.1380176739772463E-2,0.59069499319816432,1.1401943105987501E-2,0.12546657616336848,0.76894368920729272,3.7680774608727559]
[null,2017,8.1172465370082686E-2,1.3879406354074943,0.10656837262539781,0.25043751292579514,1.8261189863287699,1.3748409824538954]
[null,2018,8.1388321281434459E-2,3.5070450208902564,0.1489791533898554,0.43613044964679515,4.1735429452083412,1.2854715253789859]
[null,2019,8.1707791953089928E-2,9.9361826237461202,0.17523132562330307,0.71011425657039839,10.903235997892912,1.6124652701635558]
[null,2020,0.11347022320308993,20.043564112569328,0.19023132562330308,0.96537051657039841,21.31263617796612,0.95470740815707011,{"$f":"(G56-G54)/G54","v":4.1066052171417651}]

{"sheet":"pee 2008-2020","index":5,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[11,2,11,3],[29,2,29,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Investimentos do PEE (milhões)"]
[null,null,"Ano","PEE"]
[null,null,2008,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C46,'Base de dados nominais'!C46*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C14,12,1),IPCA!$B$4:$D$46,2,0)))","v":266.66090886318034}]
[null,null,2009,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C47,'Base de dados nominais'!C47*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C15,12,1),IPCA!$B$4:$D$46,2,0)))","v":593.43552252856421}]
[null,null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C48,'Base de dados nominais'!C48*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C16,12,1),IPCA!$B$4:$D$46,2,0)))","v":1014.1669619769078}]
[null,null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C49,'Base de dados nominais'!C49*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C17,12,1),IPCA!$B$4:$D$46,2,0)))","v":802.79946474773556}]
[null,null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C50,'Base de dados nominais'!C50*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C18,12,1),IPCA!$B$4:$D$46,2,0)))","v":769.36538627465404}]
[null,null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C51,'Base de dados nominais'!C51*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C19,12,1),IPCA!$B$4:$D$46,2,0)))","v":626.06188587476254}]
[null,null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C52,'Base de dados nominais'!C52*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C20,12,1),IPCA!$B$4:$D$46,2,0)))","v":676.4936003320114}]
[null,null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C53,'Base de dados nominais'!C53*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C21,12,1),IPCA!$B$4:$D$46,2,0)))","v":710.03405221287414}]
[null,null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C54,'Base de dados nominais'!C54*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C22,12,1),IPCA!$B$4:$D$46,2,0)))","v":599.05083018754317}]
[null,null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C55,'Base de dados nominais'!C55*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C23,12,1),IPCA!$B$4:$D$46,2,0)))","v":614.94992175327377}]
[null,null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C56,'Base de dados nominais'!C56*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C24,12,1),IPCA!$B$4:$D$46,2,0)))","v":554.15528713454864}]
[null,null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C57,'Base de dados nominais'!C57*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C25,12,1),IPCA!$B$4:$D$46,2,0)))","v":717.03796082751182}]
[null,null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C58,'Base de dados nominais'!C58*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($C26,12,1),IPCA!$B$4:$D$46,2,0)))","v":605.01196900000002}]
[null,null,"Total Geral",{"$f":"SUM(D14:D26)","v":8549.2237517135673}]
[]
[]
[null,null,"Investimentos Acumulados (R$ bilhões)"]
[null,null,"Ano","PEE","Acum(n)/Acum(n-1)"]
[null,null,2008,{"$f":"D14/1000","v":0.26666090886318033}]
[null,null,2009,{"$f":"(D15/1000)+D32","v":0.86009643139174452},{"$f":"(D33-D32)/D32","v":2.2254312604666282}]
[null,null,2010,1.8742633933686523,{"$f":"(D34-D33)/D33","v":1.1791316937984009}]
[null,null,2011,2.677062858116388,0.4283279861241101]
[null,null,2012,3.4464282443910421,0.28739160305559219]
[null,null,2013,4.0724901302658045,0.1816552794603106]
[null,null,2014,4.748983730597816,0.16611301162020442]
[null,null,2015,5.4590177828106903,0.14951284158716061]
[null,null,2016,6.0580686129982331,0.10973601003349523]
[null,null,2017,6.673018534751507,0.10150923686038041]
[null,null,2018,7.2271738218860557,8.3044170228006822E-2]
[null,null,2019,7.9442117827135679,9.9214157359285529E-2]
[null,null,2020,8.5492237517135674,{"$f":"(D44-D43)/D43","v":7.6157583099243711E-2}]

{"sheet":"p&d 2008-2020","index":6,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[11,1,11,2],[29,1,29,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Investimentos do P&D (milhões)"]
[null,"Ano","P&D"]
[null,2008,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C62,'Base de dados nominais'!C62*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B14,12,1),IPCA!$B$4:$D$46,2,0)))","v":182.35015594589089}]
[null,2009,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C63,'Base de dados nominais'!C63*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B15,12,1),IPCA!$B$4:$D$46,2,0)))","v":462.95241462817347}]
[null,2010,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C64,'Base de dados nominais'!C64*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B16,12,1),IPCA!$B$4:$D$46,2,0)))","v":670.38929003195051}]
[null,2011,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C65,'Base de dados nominais'!C65*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B17,12,1),IPCA!$B$4:$D$46,2,0)))","v":592.06595913952924}]
[null,2012,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C66,'Base de dados nominais'!C66*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B18,12,1),IPCA!$B$4:$D$46,2,0)))","v":939.26523552403341}]
[null,2013,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C67,'Base de dados nominais'!C67*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B19,12,1),IPCA!$B$4:$D$46,2,0)))","v":552.11451080284064}]
[null,2014,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C68,'Base de dados nominais'!C68*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B20,12,1),IPCA!$B$4:$D$46,2,0)))","v":742.23446747055073}]
[null,2015,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C69,'Base de dados nominais'!C69*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B21,12,1),IPCA!$B$4:$D$46,2,0)))","v":570.80625044522242}]
[null,2016,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C70,'Base de dados nominais'!C70*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B22,12,1),IPCA!$B$4:$D$46,2,0)))","v":545.92631422072998}]
[null,2017,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C71,'Base de dados nominais'!C71*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B23,12,1),IPCA!$B$4:$D$46,2,0)))","v":625.88604281717323}]
[null,2018,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C72,'Base de dados nominais'!C72*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B24,12,1),IPCA!$B$4:$D$46,2,0)))","v":949.54756703608598}]
[null,2019,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C73,'Base de dados nominais'!C73*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B25,12,1),IPCA!$B$4:$D$46,2,0)))","v":1102.2771546661604}]
[null,2020,{"$f":"IF('Base de dados nominais'!$N$7=12,'Base de dados nominais'!C74,'Base de dados nominais'!C74*(VLOOKUP(VLOOKUP('Base de dados nominais'!$N$7,'Base de dados nominais'!$K$2:$M$13,3,),IPCA!$B$4:$D$46,2,0)/VLOOKUP(DATE($B26,12,1),IPCA!$B$4:$D$46,2,0)))","v":888.448894}]
[null,"Total Geral",{"$f":"SUM(C14:C25)","v":7935.8153627283409}]
[]
[]
[null,"Investimentos Acumulados (R$ bilhões)"]
[null,"Ano","P&D"]
[null,2008,{"$f":"C14/1000","v":0.18235015594589088}]
[null,2009,{"$f":"(C15/1000)+C32","v":0.64530257057406437},{"$f":"(C33-C32)/C32","v":2.5388100834174567}]
[null,2010,1.3156918606060148,{"$f":"(C34-C33)/C33","v":1.0388759019440583}]
[null,2011,1.907757819745544,0.45000351287939139]
[null,2012,2.8470230552695774,0.49233986924467815]
[null,2013,3.3991375660724179,0.19392695460647127]
[null,2014,4.1413720335429689,0.21835964359870744]
[null,2015,4.7121782839881909,0.13783022771728476]
[null,2016,5.258104598208921,0.11585434194537325]
[null,2017,5.8839906410260943,0.11903263450300516]
[null,2018,6.8335382080621798,0.16137815726887295]
[null,2019,7.9358153627283405,0.16130401573897674]
[null,2020,8.8242642567283411,{"$f":"(C44-C43)/C43","v":0.11195433025984}]

{"sheet":"IPCA","index":7,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,3],[0,0,0,3],[1,0,2,0],[1,1,2,1],[1,2,1,3],[3,0,45,0]]}
["Tabela 1737 - IPCA - Série histórica com número-índice, variação mensal e variações acumuladas em 3 meses, em 6 meses, no ano e em 12 meses (a partir de dezembro/1979)"]
[null,"Mês","Variável"]
[null,null,"IPCA - Número-índice (base: dezembro de 1993 = 100) (Número-índice)","IPCA - Variação acumulada no ano (%)"]
["Brasil","1979-12-01",7.6183000000000005E-9,"..."]
[null,"1980-12-01",1.51795E-8,99.25]
[null,"1981-12-01",2.96946E-8,95.62]
[null,"1982-12-01",6.0811699999999999E-8,104.79]
[null,"1983-12-01",1.605502E-7,164.01]
[null,"1984-12-01",5.0615590000000003E-7,215.26]
[null,"1985-12-01",1.7322163E-6,242.23]
[null,"1986-12-01",3.1121777E-6,79.66]
[null,"1987-12-01",1.44221901E-5,363.41]
[null,"1988-12-01",1.557904426E-4,980.21]
[null,"1989-12-01",3.2293981927000001E-3,1972.91]
[null,"1990-12-01",5.5576860018600002E-2,1620.97]
[null,"1991-12-01",0.31828867732630001,472.7]
[null,"1992-12-01",3.8802596550900001,1119.0999999999999]
[null,"1993-12-01",100,2477.15]
[null,"1994-12-01",1016.46,916.46]
[null,"1995-12-01",1244.23,22.41]
[null,"1996-12-01",1363.24,9.56]
[null,"1997-12-01",1434.46,5.22]
[null,"1998-12-01",1458.2,1.65]
[null,"1999-12-01",1588.56,8.94]
[null,"2000-12-01",1683.47,5.97]
[null,"2001-12-01",1812.65,7.67]
[null,"2002-12-01",2039.78,12.53]
[null,"2003-12-01",2229.4899999999998,9.3000000000000007]
[null,"2004-12-01",2398.92,7.6]
[null,"2005-12-01",2535.4,5.69]
[null,"2006-12-01",2615.0500000000002,3.14]
[null,"2007-12-01",2731.62,4.46]
[null,"2008-12-01",2892.86,5.9]
[null,"2009-12-01",3017.59,4.3099999999999996]
[null,"2010-12-01",3195.89,5.91]
[null,"2011-12-01",3403.73,6.5]
[null,"2012-12-01",3602.46,5.84]
[null,"2013-12-01",3815.39,5.91]
[null,"2014-12-01",4059.86,6.41]
[null,"2015-12-01",4493.17,10.67]
[null,"2016-12-01",4775.7,6.29]
[null,"2017-12-01",4916.46,2.95]
[null,"2018-12-01",5100.6099999999997,3.75]
[null,"2019-12-01",5320.25,4.3099999999999996]
[null,"2020-12-01",5560.59,4.5199999999999996]
[null,"2021-12-01",6120.04,10.06]
["Fonte: IBGE - Índice Nacional de Preços ao Consumidor Amplo"]

{"sheet":"Base de dados nominais","index":8,"n_rows":89,"n_cols":21,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["aba","Ano","Total",null,null,null,"Deflator","Valor BMP",null,null,null,"Seleção",null,null,null,null,null,null,null,"Ano do Movimento","Aplicações - R$ Mil"]
["Distribuição",2010,10786.421429329601,null,null,null,0.79489663499999996,13569.59,{"$f":"H2*G2","v":10786.42142932965},null,1,2010,"2010-12-01",null,null,null,null,null,null,2011,10535703]
["Distribuição",2011,10535.703,null,null,null,null,null,null,null,2,2011,"2011-12-01",null,null,null,null,null,null,2012,11817746]
["Distribuição",2012,11817.745999999999,null,null,null,null,null,null,null,3,2012,"2012-12-01",null,null,null,null,null,null,2013,10892790]
["Distribuição",2013,10892.79,null,null,null,null,null,null,null,4,2013,"2013-12-01",null,null,null,null,null,null,2014,10352739]
["Distribuição",2014,10352.739,null,null,null,null,null,null,null,5,2014,"2014-12-01",null,null,null,null,null,null,2015,11609050]
["Distribuição",2015,11609.05,null,null,null,null,null,null,null,6,2015,"2015-12-01",11,null,null,null,null,null,2016,13783892]
["Distribuição",2016,13783.892,null,null,null,null,null,null,null,7,2016,"2016-12-01",null,null,null,null,null,null,2017,15678350]
["Distribuição",2017,15678.35,null,null,null,null,null,null,null,8,2017,"2017-12-01",null,null,null,null,null,null,2018,15324206]
["Distribuição",2018,15324.206,null,null,null,null,null,null,null,9,2018,"2018-12-01",null,null,null,null,null,null,2019,17767268]
["Distribuição",2019,17767.268,null,null,null,null,null,null,null,10,2019,"2019-12-01",null,null,null,null,null,null,2020,19262158]
["Distribuição",2020,19262.157999999999,null,null,null,null,null,null,null,11,2020,"2020-12-01",null,null,null,null,null,null,2021,26230021]
[null,null,null,null,null,null,null,null,null,null,12,"Nominal"]
[]
[null,"Ano","Eólica","Fotovoltaica","Hidro","Termelétrica"]
["MMGD",2010]
["MMGD",2011]
["MMGD",2012]
["MMGD",2013,0.14024999999999999,14.155040327054541]
["MMGD",2014,0.22137500000000002,20.469826048152935,6.1875,1.0449999999999999]
["MMGD",2015,0.43037500000000006,75.241081009845402,6.7500000000000004E-2,6.8339199999999991]
["MMGD",2016,34.645875000000004,385.54794258354815,2.4423000000000004,99.26379]
["MMGD",2017,35.182812499999997,704.89396090999026,84.142499999999998,110.49450000000002]
["MMGD",2018,0.19800000000000001,1943.8090237973365,38.902500000000003,170.33215000000001]
["MMGD",2019,0.3056625,6151.2572104028368,25.117499999999996,262.14166999999998]
["MMGD",2020,31.762431249999999,10107.381488823206,15,255.25626]
[]
[]
[null,"Ano","LT","SE"]
["Transmissão",2010,2453.5133378310702,2095.95774904371]
["Transmissão",2011,2874.9432200245301,2596.1516538962101]
["Transmissão",2012,3544.77894635148,3086.08598549211]
["Transmissão",2013,3147.8864534867498,2613.8016366479601]
["Transmissão",2014,3481.9353693968401,2884.2488762340899]
["Transmissão",2015,4985.5477019235504,4265.0339938304796]
["Transmissão",2016,11787.372825226799,6956.2390302336698]
["Transmissão",2017,12724.932597388401,7552.25360930432]
["Transmissão",2018,14049.290406643,7364.5445811632599]
["Transmissão",2019,13852.742123756199,6712.6746116427803]
["Transmissão",2020,12552.002020416399,4739.5737531946097]
[]
[]
[]
[null,"investimento_milhoes"]
["PEE","Ano","PEE"]
["PEE",2008,138.728566]
["PEE",2009,322.042283]
["PEE",2010,582.88168199999996]
["PEE",2011,491.40695899999997]
["PEE",2012,498.43776100000002]
["PEE",2013,429.571369]
["PEE",2014,493.91688799999997]
["PEE",2015,573.73474799999997]
["PEE",2016,514.49343499999998]
["PEE",2017,543.71509000000003]
["PEE",2018,508.31476500000002]
["PEE",2019,686.04612299999997]
["PEE",2020,605.01196900000002]
[]
[]
[null,"Ano","P&D"]
["P&D",2008,94.866456999999997]
["P&D",2009,251.232437]
["P&D",2010,385.29911900000002]
["P&D",2011,362.41346099999998]
["P&D",2012,608.50834899999995]
["P&D",2013,378.83249499999999]
["P&D",2014,541.91516100000001]
["P&D",2015,461.23334399999999]
["P&D",2016,468.86756600000001]
["P&D",2017,553.38438799999994]
["P&D",2018,870.99962700000003]
["P&D",2019,1054.6344959999999]
["P&D",2020,888.448894]
[]
[]
[]
[null,"Ano","Eólica","PCH","Fotovoltaica","UHE","Biomassa","UTE Fóssil"]
["Centralizada",2010,1963.260894,2177.3078266446419,0,9739.5999528798366,1619.246545,3803.7068164883308]
["Centralizada",2011,1612.0271733333332,1624.6924176513919,0,10242.613356069676,2067.7116083333331,3519.3292326660785]
["Centralizada",2012,4024.6284439999999,1060.9635781298748,0,11899.899605745071,2739.6894093333331,4121.1408142762539]
["Centralizada",2013,10768.144459333333,922.34585472072126,0,12251.605907821739,2251.0034556666665,1937.1562750181852]
["Centralizada",2014,11193.222582,1153.0744051248721,0,12612.983771617526,2442.9976889999998,1948.7099981634369]
["Centralizada",2015,11340.610547333332,1277.7481206648222,0,12981.495108486894,2352.955234,1826.3850117084712]
["Centralizada",2016,10692.400226666665,1224.9199081612633,4810.8587937466664,11592.214540341585,1468.9520319999999,1210.1637805596708]
["Centralizada",2017,8709.8823560000001,1197.963808284082,4231.8968821999997,7775.0510555223273,641.75069053333334,2306.0706295613395]
["Centralizada",2018,5895.2434156666659,1086.9685600350051,3087.892895,2100.2244064546726,872.92222459999994,3456.1794291892766]
["Centralizada",2019,10821.396117,1052.5613297340772,3314.23209112,371.24551583674264,1417.4568062000001,4706.7552622092971]
["Centralizada",2020,15611.409357999999,1287.8191079868643,4997.3056969866657,387.18301583674264,2378.7571022666666,4482.4472060992284]