{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Formulário","TiposBiodigestor","FactSheet 1-2","Metodologia","FluxoDeCaixa","FatorEmissao","SeriePreçoDiesel","PreçoDiesel"],"not_rendered":{"charts":3,"images":25,"macros":1,"external_links":0,"defined_names":40,"comments":3,"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":"Formulário","index":0,"n_rows":54,"n_cols":30,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,26,1,28],[10,10,11,10],[7,17,7,19],[53,26,53,27],[14,1,32,1],[32,10,33,10],[51,1,56,1],[53,2,55,2],[48,21,48,22],[46,17,47,17],[23,13,29,13],[28,21,29,22],[16,21,16,22],[16,14,16,16],[18,14,18,16],[29,8,30,9],[27,8,28,10],[1,1,12,1],[35,1,49,1],[5,13,5,14],[31,3,33,4],[20,14,20,18],[52,26,52,27],[9,16,10,18],[11,16,11,18],[29,14,29,16],[31,14,31,16],[46,13,47,16],[46,19,47,19],[46,21,47,22],[46,18,47,18],[6,13,9,14],[10,13,11,14],[26,21,27,22],[30,21,31,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUADRO DE DADOS AUXILIARES"]
[null,"QUANTO SE USA ?"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"- \",ROUND((I6*I12/($AA$24/100))/1000,1))","v":"- 917,7"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,8650]
[]
[null,null,null,"Distância média anual","[km/ano]",null,null,null,{"$f":"$AB$4*10","v":86500},null,null,null,null,{"$f":"CONCATENATE(\"- \",ROUND(FatorEmissao!$S$19*(I6*I12/($AA$24/100))/1000,0),\" kg/ano\")","v":"- 929 kg/ano"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,301]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"- \",ROUND(FatorEmissao!$S$26*(I6*I12/($AA$24/100))/1000,0),\" kg/ano\")","v":"- 1368 kg/ano"}]
[null,null,null,"Dias de operação/ano","[dias/ano]",null,null,null,{"$f":"$AA$8","v":290},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,290]
[]
[null,null,null,"Distância diária média","[km/dia]",null,null,null,{"$f":"CONCATENATE(TRUNC($I$6/DiasDeOperacaoNoAno,0),\" km/dia\")","v":"298 km/dia"},null,{"$f":"CONCATENATE(\"- \",TRUNC(IF(OR(TipoBiodigestor=1,TipoBiodigestor=3),FatorEmissao!$R$35+FatorEmissao!$R$8*((I6*I12)/($AA$24/100))*FatorEmissao!$R$11/1000000,FatorEmissao!$R$8*((I6*I12)/($AA$24/100))*FatorEmissao!$R$11/1000000),1))","v":"- 16932"},null,null,null,null,null,"Rio de Janeiro",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"TiposBiodigestor!$D$7/((DistAnualAux*10)/DiasDeOperacaoNoAno)","v":16.76300578034682}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"- \",ROUND(FatorEmissao!$S$30*(I6*I12/($AA$24/100))/1000,0),\" kg/ano\")","v":"- 4439 kg/ano"}]
[null,null,null,"Qte. ônibus biometano","[unidade]",null,null,null,{"$f":"AD10+FrotaMinimaBiometano","v":16.76300578034682},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-06-11"},null,null,null,null,null,null,null,null,null,1,null,2]
[]
[]
[null,"QUANTO CUSTA ?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Comprar ônibus novo (R$)",null,null,{"$f":"AA17*1000","v":510000},null,{"$f":"CustoBiometanoNovo*1000","v":550000},null,"Custo de Conversão (R$)",null,null,null,null,510,1500,550,1]
[]
[null,null,null,"Preço do diesel (R$/l):",{"$f":"AC6/100","v":3.01},null,null,null,"Preço biometano (R$/m³)",null,{"$f":"PrecoBiometano/100","v":2.4900000000000002},null,null,null,"      Comprar ônibus usado (R$)",null,null,{"$f":"$R$17*$E$49","v":153000},{"$f":"\"+\"&(W19)&\" =\"","v":"+150000 ="},{"$f":"$R$19+$W$19","v":303000},null,null,{"$f":"AB17*100","v":150000},null,null,null,60,1610,{"$f":"$K$19*$I$12","v":41.739884393063583}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Se já possui ônibus, o custo é apenas do \"kit gás\" (R$)",null,null,null,null,{"$f":"$W$19","v":150000},null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Custo Operacional (R$/km)",null,null,{"$f":"IFERROR($E$19/($AA$24/100),\" Custo Diesel\")","v":1.9050632911392402},null,{"$f":"IFERROR($K$19/(SpinnerS25/100),\"NA\")","v":1.5562500000000001},null,{"$f":"IF(CapexNovoUsado=3,\"Se você já possui ônibus...\",IF(CapexNovoUsado=2,\"Atenção: ônibus usado!\",\"\"))","v":""},null,null,null,null,158,{"$f":"$I$12*PotDoCarregador*$AB$22","v":6034.6820809248547},15]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(TarifaBiometano,\" R$/m³\")","v":"1,45 R$/m³"},null,null,null,{"$f":"CONCATENATE(\"     \",CHAR(149),\" Rendimento\")","v":"     • Rendimento"},null,null,{"$f":"CONCATENATE(TRUNC(AA24/100,2),\" km/l\")","v":"1,58 km/l"},null,{"$f":"CONCATENATE(TRUNC(AB26/100,2),\" km/m³\")","v":"1,6 km/m³"},null,{"$f":"IF(CapexNovoUsado=3,\"Pague apenas pelo kit gás\",IF(CapexNovoUsado=2,CONCATENATE(CHAR(149),\" Avalie bem os parâmetros\"),\"\"))","v":""},null,null,null,null,false,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=3,\"para converter o ônibus a\",IF(CapexNovoUsado=2,CONCATENATE(CHAR(149),\" Rendimento menor\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Capacidade: \",TiposBiodigestor!$D$7,\" m³/dia\")","v":"Capacidade: 5000 m³/dia"},null,null,null,null,null,{"$f":"CONCATENATE(\"     \",CHAR(149),\" Custo do combustível\")","v":"     • Custo do combustível"},null,null,{"$f":"CONCATENATE(E19,\" R$/l\")","v":"3,01 R$/l"},null,{"$f":"IFERROR(CONCATENATE($K$19,\" R$/m³\"),\"NA\")","v":"2,49 R$/m³"},null,null,null,null,null,null,null,{"$f":"TiposBiodigestor!F7","v":1.45},249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=3,\"diesel que você já possui\",IF(CapexNovoUsado=2,CONCATENATE(CHAR(149),\" Custo de Manutenção maior\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,"Frota mínima (ônibus)",null,null,null,null,null," Custo de Manutenção (R$/km)",null,null,{"$f":"AA30/100","v":0.77},null,{"$f":"AB30/100","v":0.76},null,null,null,null,null,null,77,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=3,CONCATENATE(CHAR(149),\" Use a 3ª opção do CAPEX\"),\"\")","v":""}]
[null,null,null,{"$f":"IF(EstadoPrecoDieselANP=1,\"preço nacional (média simples)\",\"\")","v":""},null,null,null,null,{"$f":"CONCATENATE(TEXT((TiposBiodigestor!$D$7/((DistAnualAux*10)/DiasDeOperacaoNoAno)),\"#.##0; #.##0\"),\" ônibus\")","v":"17 ônibus"},null,null,null,null,null," Custo Var. Anual (R$/ano)",null,null,{"$f":"(IFERROR($E$19/($AA$24/100),\" Custo Diesel\")+(AA30/100))*$I$6","v":231392.97468354431},null,{"$f":"IFERROR((T24+T30)*$I$6,\" Custo Elétrico\")","v":200355.625},null,null,null,null,null,null,1]
[]
[]
[]
[null,"COMO PAGAR ?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=3,\"FINANCIAMENTO DO KIT GÁS\",\"FINANCIAMENTO-BIOMETANO\")","v":"FINANCIAMENTO-BIOMETANO"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=3,\"      (Atenção às taxas de financiamento do kit gás)\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUADRO GERAL DE \nINFORMAÇÕES"]
[null,null,null,"Custo Capital Próprio",{"$f":"FluxoDeCaixa!B21","v":0.14000000000000001},null,null,null,"Custo Capital Próprio",null,{"$f":"FluxoDeCaixa!B52","v":0.14499999999999999},null,null,{"$f":"IFERROR(FluxoDeCaixa!B70,\"TIR:\")","v":0.21619318928259701},{"$f":"IFERROR(CONCATENATE(\"Taxa Interna de Retorno (TIR): \",TRUNC(FluxoDeCaixa!B70,4)*100,\"%\"),\"Taxa indefinida (problema de cálculo)\")","v":"Taxa Interna de Retorno (TIR): 21,61%"}]
[]
[null,null,null,"Custo Financiamento",{"$f":"FluxoDeCaixa!B22","v":0.09},null,null,null,"Custo Financiamento",null,{"$f":"FluxoDeCaixa!B53","v":0.09},null,null,{"$f":"FluxoDeCaixa!B69","v":-27442.576298054846},{"$f":"IFERROR(CONCATENATE(\"Valor Presente Líquido (VPL): \",TEXT(FluxoDeCaixa!B69,\"R$ #.##0;-R$ #.##0\")),\"Valor indefinido (problema de cálculo)\")","v":"Valor Presente Líquido (VPL): -R$ 27.443"}]
[]
[null,null,null,"Percentual financiado",{"$f":"FluxoDeCaixa!B23","v":0.8},null,null,null,"Percentual financiado",null,{"$f":"FluxoDeCaixa!B54","v":0.8},null,null,{"$f":"FluxoDeCaixa!$P$68","v":-27442.576298054832},{"$f":"IFERROR(FluxoDeCaixa!A71, \"Valor indefinido (problema de cálculo)\")","v":"Estimativa de Payback > 10 anos"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CapexNovoUsado=1,$AA$38,\"\")","v":"QUADRO GERAL DE \nINFORMAÇÕES"}]
[]
[null,null,null,"Custo Pond. de Capital",{"$f":"FluxoDeCaixa!B25","v":7.551999999999999E-2},null,null,null,"Custo Pond. de Capital",null,{"$f":"FluxoDeCaixa!B56","v":7.6519999999999977E-2},null,null,null,"Premissas da estimativa de payback"]
[]
[null,null,null,"Prazo financiamento",{"$f":"FluxoDeCaixa!B26","v":5},null,null,null,"Prazo financiamento",null,{"$f":"FluxoDeCaixa!B57","v":5},null,null,null,null,null,null,"DIESEL",null,"ELÉTRICO",null,"DIFERENÇA DE TCO10",null,null,null,null,{"$f":"(T49-R49)/(-K10*10)","v":-1.5968196127772454}]
[]
[null,null,null,"Valor de revenda (%)",{"$f":"FluxoDeCaixa!B20","v":0.3},null,null,null,"Valor de revenda (%)",null,{"$f":"FluxoDeCaixa!B51","v":0},null,null,"Custo Total em 10 anos (TCO10)",null,null,null,{"$f":"IF(CapexNovoUsado=3,(R32*10),IF(CapexNovoUsado=1,(R32*10+R17),(R32*10+R19)))","v":2823929.7468354432},null,{"$f":"IF(CapexNovoUsado=3,(T32*10+T21),IF(CapexNovoUsado=1,(T32*10+T17),(T32*10+T19)))","v":2553556.25},null,{"$f":"R49-T49","v":270373.49683544319}]
[]
[]
[null,"CONSIDERAÇÕES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUSTO DE ABATIMENTO (R$/ ton CO2)",null,{"$f":"(T49-R49)/(((3070*(I6*I12/10000)*0.848/1000)/I12)*10)","v":-1200.6426947205405}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AC$53<0,\"(Solução custo-efetiva)\",\"(Solução Custo-negativa)\")","v":"(Solução custo-efetiva)"}]

{"sheet":"TiposBiodigestor","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Índice","Tipo","Descrição","Capacidade","Custo","Preço"]
[1,"ATERRO","-",5000,"-",1.45]
[2,"RURAL C/ ADUBO","-",5000,"-",1.75]
[3,"URBANO","-",5000,"-",1.9]
[4,"RURAL","sem recursos de terceiros e TIR de 15%",5000,"-",2.37]
[]
[{"$f":"Formulário!AA12","v":1},{"$f":"VLOOKUP($A$7,TiposBiodigestor!$A$2:$F$5,2,0)","v":"ATERRO"},{"$f":"VLOOKUP($A$7,TiposBiodigestor!$A$2:$F$5,3,0)","v":"-"},{"$f":"VLOOKUP($A$7,TiposBiodigestor!$A$2:$F$5,4,0)","v":5000},{"$f":"VLOOKUP($A$7,TiposBiodigestor!$A$2:$F$5,5,0)","v":"-"},{"$f":"VLOOKUP($A$7,TiposBiodigestor!$A$2:$F$5,6,0)","v":1.45}]

{"sheet":"FactSheet 1-2","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,12,0,14]]}
[]
[]
[]
[null,null,null,1]

{"sheet":"Metodologia","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FluxoDeCaixa","index":4,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[[64,12,64,13],[70,0,72,0],[0,0,0,11],[33,0,33,11],[49,0,49,1],[18,0,18,1],[64,0,64,11]]}
["Análise financeira por ônibus: Diesel Padron LE"]
["Ciclo de Avaliação de 10 anos",null,10]
["Vida útil do ônibus a diesel 5 anos"]
["Período",0,1,2,3,4,5,6,7,8,9,10]
["Custo de Aquisição",{"$f":"IF(CapexNovoUsado=3,0,IF(CapexNovoUsado=1,Formulário!R17,Formulário!R19))","v":510000},0,0,0,0,{"$f":"B5","v":510000},0,0,0,0,0]
["Custo de Infraestrutura de recarga",null,0,0,0,0,0,0,0,0,0,0]
["Custo Variável Anual",null,{"$f":"SUM(C8:C10)","v":349712.97468354425},{"$f":"SUM(D8:D10)","v":342368.97468354425},{"$f":"SUM(E8:E10)","v":335024.97468354425},{"$f":"SUM(F8:F10)","v":327680.97468354425},320336.97468354425,349712.97468354425,342368.97468354425,335024.97468354425,327680.97468354425,320336.97468354425]
["Custo Operacional",null,{"$f":"IF(C4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(D4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(E4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(F4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(G4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(H4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(I4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(J4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(K4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428},{"$f":"IF(L4<=$C$2,Formulário!$R$24*Formulário!$I$6,\"\")","v":164787.97468354428}]
["Custo de Manutenção",null,{"$f":"IF(C4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(D4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(E4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(F4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(G4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(H4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(I4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(J4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(K4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605},{"$f":"IF(L4<=$C$2,Formulário!$R$30*Formulário!$I$6,\"\")","v":66605}]
["Custo de Financiamento",null,{"$f":"C32","v":118320},{"$f":"D32","v":110976},{"$f":"E32","v":103632},{"$f":"F32","v":96288},{"$f":"G32","v":88944},{"$f":"C10","v":118320},{"$f":"D10","v":110976},{"$f":"E10","v":103632},{"$f":"F10","v":96288},{"$f":"G10","v":88944}]
["Entradas de Caixa (financiamento)",{"$f":"B$5*$B$23","v":408000},0,0,0,0,{"$f":"B11","v":408000},0,0,0,0,0]
["Entradas de Caixa (valor de revenda)",null,0,0,0,0,{"$f":"$B$5*$B$20","v":153000},0,0,0,0,{"$f":"G12","v":153000}]
["Saídas de Caixa",{"$f":"B5","v":510000},{"$f":"C7","v":349712.97468354425},{"$f":"D7","v":342368.97468354425},{"$f":"E7","v":335024.97468354425},{"$f":"F7","v":327680.97468354425},{"$f":"G7+G5","v":830336.97468354425},{"$f":"H7","v":349712.97468354425},342368.97468354425,335024.97468354425,327680.97468354425,320336.97468354425]
["Fluxo de Caixa Anual",{"$f":"(B11+B12)-B13","v":-102000},-349712.97468354425,-342368.97468354425,-335024.97468354425,-327680.97468354425,-269336.97468354425,{"$f":"(H11+H12)-H13","v":-349712.97468354425},-342368.97468354425,-335024.97468354425,-327680.97468354425,-167336.97468354425]
["Fluxo de Caixa Acumulado",{"$f":"B14","v":-102000},{"$f":"B15+C14","v":-451712.97468354425},-794081.9493670885,-1129106.9240506329,-1456787.898734177,-1726124.8734177211,-2075837.8481012653,-2418206.8227848094,-2753231.7974683535,-3080912.7721518977,-3248249.7468354418]
["Fluxo YTD",null,{"$f":"C14/((1+$B$25)^(FluxoDeCaixa!C4))","v":-325157.10975485743},{"$f":"D14/((1+$B$25)^(FluxoDeCaixa!D4))","v":-295976.62977123144},{"$f":"E14/((1+$B$25)^(FluxoDeCaixa!E4))","v":-269290.92039630871},{"$f":"F14/((1+$B$25)^(FluxoDeCaixa!F4))","v":-244893.50306752778},{"$f":"G14/((1+$B$25)^(FluxoDeCaixa!G4))","v":-187155.90046515837},{"$f":"H14/((1+$B$25)^(FluxoDeCaixa!H4))","v":-225943.99354310692},{"$f":"I14/((1+$B$25)^(FluxoDeCaixa!I4))","v":-205667.16740827053},{"$f":"J14/((1+$B$25)^(FluxoDeCaixa!J4))","v":-187123.89842901769},{"$f":"K14/((1+$B$25)^(FluxoDeCaixa!K4))","v":-170170.70953040032},{"$f":"L14/((1+$B$25)^(FluxoDeCaixa!L4))","v":-80799.189642344354}]
["VP do Custo Anual Total em 10 anos",{"$f":"SUM(C16:L16)-$B$5","v":-2702179.022008223}]
[]
["Linha de financiamento para ônibus a diesel"]
["Valor de revenda (% aquisição)",{"$f":"C20/100","v":0.3},30,null,"Depreciação anual",{"$f":"(1-B20)/5","v":0.13999999999999999}]
["Custo de Capital Próprio",{"$f":"C21/1000","v":0.14000000000000001},140]
["Custo de Financiamento",{"$f":"C22/1000","v":0.09},90]
["Percentual Financiado (%)",{"$f":"C23/1000","v":0.8},800]
["Fator de Tributos no K de Terceiros (T)",0.34]
["Custo Médio Ponderado de Capital",{"$f":"(1-$B$23)*$B$21+$B$23*$B$22*(1-B24)","v":7.551999999999999E-2}]
["Nº de períodos financiamento (anos)",5]
[]
["Financiamento",null,{"$f":"$B$5*$B$23","v":408000}]
["Dívida",null,{"$f":"C28","v":408000},{"$f":"C29-C30","v":326400},{"$f":"D29-D30","v":244800},163200,81600,0,0,0,0,0]
["Amortização",null,{"$f":"IF(C$4<=$B$26,$C$28/$B$26,0)","v":81600},81600,81600,81600,81600,0,0,0,0,0]
["Despesa financeira",null,{"$f":"C29*$B$22","v":36720},{"$f":"D29*$B$22","v":29376},22032,14688,7344,0,0,0,0,0]
["Parcela Financiamento",null,{"$f":"C31+C30","v":118320},{"$f":"D31+D30","v":110976},{"$f":"E31+E30","v":103632},96288,88944,0,0,0,0,0]
[]
["Análise financeira por ônibus: Biometano"]
["Período",0,1,2,3,4,5,6,7,8,9,10]
["Custo de Aquisição",{"$f":"IF(CapexNovoUsado=3,Formulário!T21,IF(CapexNovoUsado=1,Formulário!T17,Formulário!T19))","v":550000},null,0,0,0,{"$f":"IF(CapexNovoUsado=3,0,B36)","v":550000},0,0,0,0,0]
["Custo de Infraestrutura de recarga",null,null,0,0,0,0,0,0,0,0,0]
["Custo Variável Anual",null,{"$f":"SUM(C39:C41)","v":327955.625},{"$f":"SUM(D39:D41)","v":320035.625},{"$f":"SUM(E39:E41)","v":312115.625},304195.625,296275.625,327955.625,320035.625,312115.625,304195.625,296275.625]
["Custo Operacional",null,{"$f":"IF(C35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(D35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(E35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(F35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(G35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(H35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(I35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(J35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(K35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625},{"$f":"IF(L35<=$C$2,Formulário!$T$24*Formulário!$I$6,\"\")","v":134615.625}]
["Custo de Manutenção",null,{"$f":"IF(C35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(D35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(E35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(F35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(G35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(H35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(I35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(J35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(K35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740},{"$f":"IF(L35<=$C$2,Formulário!$T$30*Formulário!$I$6,\"\")","v":65740}]
["Custo de Financiamento",null,{"$f":"C63","v":127600},{"$f":"D63","v":119680},111760,103840,95920,{"$f":"C41","v":127600},{"$f":"D41","v":119680},{"$f":"E41","v":111760},{"$f":"F41","v":103840},{"$f":"G41","v":95920}]
["Entradas de Caixa (financiamento)",{"$f":"B$36*$B$54","v":440000},0,0,0,0,{"$f":"B42","v":440000},0,0,0,0,0]
["Entradas de Caixa (valor de revenda)",null,0,0,0,0,{"$f":"$B$36*$B$51","v":0},0,0,0,0,{"$f":"$B$36*$B$51","v":0}]
["Saídas de Caixa",{"$f":"B36","v":550000},{"$f":"C38","v":327955.625},{"$f":"D38","v":320035.625},{"$f":"E38","v":312115.625},{"$f":"F38","v":304195.625},{"$f":"G38+G36","v":846275.625},{"$f":"H38","v":327955.625},{"$f":"I38","v":320035.625},312115.625,304195.625,296275.625]
["Fluxo de Caixa Anual",{"$f":"(B42+B43)-B44","v":-110000},{"$f":"(C42+C43)-C44","v":-327955.625},-320035.625,-312115.625,-304195.625,-406275.625,-327955.625,-320035.625,-312115.625,-304195.625,-296275.625]
["Fluxo de Caixa Acumulado",{"$f":"B45","v":-110000},{"$f":"B46+C45","v":-437955.625},-757991.25,-1070106.875,-1374302.5,-1780578.125,-2108533.75,-2428569.375,-2740685,-3044880.625,-3341156.25]
["Fluxo YTD",null,{"$f":"C45/((1+$B$56)^(FluxoDeCaixa!C35))","v":-304644.24720395351},{"$f":"D45/((1+$B$56)^(FluxoDeCaixa!D35))","v":-276155.76845292241},{"$f":"E45/((1+$B$56)^(FluxoDeCaixa!E35))","v":-250178.04965131433},{"$f":"F45/((1+$B$56)^(FluxoDeCaixa!F35))","v":-226498.09453258049},{"$f":"G45/((1+$B$56)^(FluxoDeCaixa!G35))","v":-281002.54512933089},{"$f":"H45/((1+$B$56)^(FluxoDeCaixa!H35))","v":-210708.70009324324},{"$f":"I45/((1+$B$56)^(FluxoDeCaixa!I35))","v":-191004.50288499921},{"$f":"J45/((1+$B$56)^(FluxoDeCaixa!J35))","v":-173036.88521188399},{"$f":"K45/((1+$B$56)^(FluxoDeCaixa!K35))","v":-156658.52715283842},{"$f":"L45/((1+$B$56)^(FluxoDeCaixa!L35))","v":-141734.2779932119}]
["VP do Custo Anual Total em 10 anos",{"$f":"SUM(C47:L47)-$B$36","v":-2761621.5983062782}]
[]
["Linha de financiamento para ônibus a biometano"]
["Valor de revenda (% aquisição)",{"$f":"C51/100","v":0},0,null,"Depreciação anual",{"$f":"(1-B51)/5","v":0.2}]
["Custo de Capital Próprio",{"$f":"C52/1000","v":0.14499999999999999},145]
["Custo de Financiamento",{"$f":"C53/1000","v":0.09},90]
["Percentual Financiado (%)",{"$f":"C54/1000","v":0.8},800]
["Fator de Tributos no K de Terceiros (T)",0.34]
["Custo Médio Ponderado de Capital",{"$f":"(1-$B$54)*$B$52+$B$54*$B$53*(1-$B$55)","v":7.6519999999999977E-2}]
["Nº de períodos financiamento (anos)",5]
[]
["Financiamento",null,{"$f":"$B$36*$B$54","v":440000}]
["Dívida",null,{"$f":"C59","v":440000},{"$f":"C60-C61","v":352000},264000,176000,88000,0,0,0,0,0]
["Amortização",null,{"$f":"IF(C$35<=$B$57,$C$59/$B$57,0)","v":88000},{"$f":"IF(D$35<=$B$57,$C$59/$B$57,0)","v":88000},88000,88000,88000,0,0,0,0,0]
["Despesa financeira",null,{"$f":"C60*$B$53","v":39600},{"$f":"D60*$B$53","v":31680},{"$f":"E60*$B$53","v":23760},15840,7920,0,0,0,0,0]
["Parcela Financiamento",null,{"$f":"C62+C61","v":127600},{"$f":"D62+D61","v":119680},{"$f":"E62+E61","v":111760},103840,95920,0,0,0,0,0]
[]
["Análise financeira comparativa dos ônibus: Fluxo(Biometano) - Fluxo (Diesel)"]
["Período",null,1,2,3,4,5,6,7,8,9,10,null,"FLUXO > 0","FLUXO < 0","PAYBACK"]
["Fluxo de Caixa Anual",{"$f":"(B45)-(B14)","v":-8000},{"$f":"(C45)-(C14)","v":21757.349683544249},22333.349683544249,22909.349683544249,23485.349683544249,-136938.65031645575,21757.349683544249,22333.349683544249,22909.349683544249,23485.349683544249,-128938.65031645575,null,{"$f":"SUMIF(B67:L67,\">0\",B67:L67)","v":180970.79746835399},{"$f":"SUMIF(B67:L67,\"<0\",B67:L67)","v":-273877.3006329115},{"$f":"N67+O67","v":-92906.503164557507}]
["Fluxo YTD",{"$f":"B67","v":-8000},{"$f":"(C47)-(C16)","v":20512.862550903927},19820.861318309035,19112.870744994376,18395.408534947288,-93846.64466417252,15235.293449863675,14662.66452327132,14087.013217133703,13512.182377561898,-60935.088350867547,null,{"$f":"SUMIF(B68:L68,\">0\",B68:L68)","v":135339.15671698522},{"$f":"SUMIF(B68:L68,\"<0\",B68:L68)","v":-162781.73301504005},{"$f":"N68+O68","v":-27442.576298054832}]
["VPL",{"$f":"SUM(C68:L68)+B67","v":-27442.576298054846}]
["TIR",{"$f":"IRR(B67:L67,0.2)","v":0.21619318928259701}]
[{"$f":"IF($P$68<0,\"Estimativa de Payback > 10 anos\",CONCATENATE(\"Estimativa de Payback de \",IFERROR(LARGE(C73:L73,1),0),\" anos\"))","v":"Estimativa de Payback > 10 anos"},{"$f":"O68","v":-162781.73301504005},{"$f":"IF(C68>=0,C68,0)","v":20512.862550903927},19820.861318309035,19112.870744994376,18395.408534947288,0,15235.293449863675,14662.66452327132,14087.013217133703,13512.182377561898,0]
[null,{"$f":"B71","v":-162781.73301504005},{"$f":"B72+C71","v":-142268.87046413613},{"$f":"C72+D71","v":-122448.00914582709},-103335.13840083271,-84939.729865885427,-84939.729865885427,-69704.436416021752,-55041.771892750432,-40954.758675616729,-27442.576298054832,-27442.576298054832]
[null,{"$f":"IF($P$68<0,\"> 10\",IF(B$72<0,0,\"\"))","v":"> 10"},{"$f":"IF($P$68<0,\"> 10\",IF(C$72<0,C$66,\"\"))","v":"> 10"},{"$f":"IF($P$68<0,\"> 10\",IF(D$72<0,D$66,\"\"))","v":"> 10"},"> 10","> 10","> 10","> 10","> 10","> 10","> 10","> 10"]

{"sheet":"FatorEmissao","index":5,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,15,9,17],[2,15,2,17],[13,15,13,16],[20,15,20,18],[27,15,27,18],[16,15,16,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fatores de emissão utilizados para o óleo diesel"]
[null,"Abril","Outubro",null,null,null,null,null,null,null,null,null,null,null,null,"Decisão em 13/08: corrigir a fórmula para o cálculo de emissões de CO2-eq",null,null,null,null,"campos para alteração"]
[1995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fator de emissão CO2-eq = FE(CO2) + FE(CH4) + FE(N2O)"]
[1996,4.46,4.37,null,null,null,null,null,null,null,null,null,null,null,null,"Poluente","Unidade"]
[1997,3.93,4,null,null,null,null,null,null,null,null,null,null,null,null,"CO2","tCO2-eq/10³tep",3070]
[1998,4.4000000000000004,4.3600000000000003,null,"Idade média da frota de ônibus urbanos municipais nas princpais capitais",null,null,null,null,null,null,null,null,null,null,"CH4","tCO2-eq/10³tep",2.6379999999999999]
[1999,4.33,4.83,null,"Fonte: Anuário NTU (2018) - pág. 52",null,null,null,null,null,null,null,null,null,null,"N2O","tCO2-eq/10³tep",7.7880000000000003]
[2000,4.83,5.15,null,null,null,null,null,null,null,null,null,null,null,null,"Total","tCO2-eq/10³tep",{"$f":"SUM(R5:R7)","v":3080.4259999999999}]
[2001,4.92,5.09]
[2002,5.6,5.69,null,null,null,null,null,null,null,null,null,null,null,null,"Fator de conversão"]
[2003,5.73,5.6,null,null,null,null,null,null,null,null,null,null,null,null,"diesel","tep/m³",0.84799999999999998]
[2004,5.44,5.32]
[2005,5.4,5.38,null,null,null,null,null,null,null,null,null,null,null,null,"Tabela 5 e Tabela 19 - MMA(2014): Inventário Nacional de Emissões Atmosféricas por Veículos Automotores Rodoviários 2013"]
[2006,5.53,5.39,null,null,null,null,null,null,null,null,null,null,null,null,"Rendimento dos ônibus"]
[2007,5.24,5.07,null,null,null,null,null,null,null,null,null,null,null,null,"km/Ldiesel",2.2999999999999998]
[2008,5.0999999999999996,5.07]
[2009,4.59,4.62,null,null,null,null,null,null,null,null,null,null,null,null,"Fator emissão CO"]
[2010,4.8499999999999996,4.6100000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g/km","g/L"]
[2011,4.22,4.2,null,null,null,null,null,null,null,null,null,null,null,null,"CO","Tabela 19",0.44,{"$f":"R19*Q15","v":1.012}]
[2012,4.24,4.25]
[2013,4.42,4.47,null,null,null,null,null,null,null,null,null,null,null,null,"Fator emissão MP = MP10(pneus, freios) + MP10pista + MPcomb"]
[2014,4.63,4.67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g/km","g/L"]
[2015,4.66,4.83,null,null,null,null,null,null,null,null,null,null,null,null,"MPcomb","Tabela 19",0.02,{"$f":"R23*$Q$15","v":4.5999999999999999E-2}]
[2016,5.01,5.03,null,null,null,null,null,null,null,null,null,null,null,null,"MP10(pneu, freios)","Tabela 05",0.59,{"$f":"R24*$Q$15","v":1.3569999999999998}]
[2017,5.42,5.58,null,null,null,null,null,null,null,null,null,null,null,null,"MP10pista","Tabela 05",3.7999999999999999E-2,{"$f":"R25*$Q$15","v":8.7399999999999992E-2}]
["Média",{"$f":"AVERAGE(B4:B25)","v":4.8613636363636354},{"$f":"AVERAGE(C4:C25)","v":4.8900000000000006},{"$f":"AVERAGE(B26:C26)","v":4.8756818181818176},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R23:R25)","v":0.64800000000000002},{"$f":"SUM(S23:S25)","v":1.4903999999999997}]
["Desvio Padrão",{"$f":"_xlfn.STDEV.S(B4:B25)","v":0.51616069345879534},{"$f":"_xlfn.STDEV.S(C4:C25)","v":0.4927860542244426}]
["Variância",{"$f":"_xlfn.VAR.S(B4:B25)","v":0.26642186147186447},{"$f":"_xlfn.VAR.S(C4:C25)","v":0.24283809523809527},null,null,null,null,null,null,null,null,null,null,null,null,"Fator de emissão NOX"]
["Menor",{"$f":"SMALL(B4:B25,1)","v":3.93},{"$f":"SMALL(C4:C25,1)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g/km","g/L"]
["Maior",{"$f":"LARGE(B4:B25,1)","v":5.73},{"$f":"LARGE(C4:C25,1)","v":5.69},null,null,null,null,null,null,null,null,null,null,null,null,"NOX","Tabela 19",2.1030000000000002,{"$f":"R30*2.3","v":4.8369}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fator de emissão usado para o biometano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fator do CH4","Kg CO₂-eq/m³ CH4",16.038399999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumo CH4","(m³)/ano",{"$f":"Formulário!$I$6/(SpinnerS25/100)*Formulário!$I$12","v":906250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissões","ton CO₂-eq/ano CH4",{"$f":"R34*R33/1000","v":14534.8}]

{"sheet":"SeriePreçoDiesel","index":6,"n_rows":66,"n_cols":87,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,0,65,1]]}
[null,"Rótulos de Linha","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01","2013-07-01","2013-08-01","2013-09-01","2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","2014-07-01","2014-08-01","2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01"]
[null,"ACRE",2.286,2.3199999999999998,2.3330000000000002,2.3959999999999999,2.4089999999999998,2.387,2.3849999999999998,2.4049999999999998,2.4009999999999998,2.415,2.4409999999999998,2.5099999999999998,2.5720000000000001,2.5720000000000001,2.5720000000000001,2.6019999999999999,2.5750000000000002,2.5720000000000001,2.5630000000000002,2.569,2.5609999999999999,2.5489999999999999,2.6160000000000001,2.69,2.71,2.7930000000000001,2.851,2.859,2.8690000000000002,2.87,2.88,2.9159999999999999,2.8980000000000001,2.968,3.0830000000000002,3.0920000000000001,3.1040000000000001,3.097,3.08,3.0680000000000001,3.073,3.0659999999999998,3.0640000000000001,3.0489999999999999,3.0640000000000001,3.0739999999999998,3.0459999999999998,3.0150000000000001,3.1269999999999998,3.0910000000000002,3.0009999999999999,2.952,2.96,2.9119999999999999,2.8839999999999999,3.1030000000000002,3.1749999999999998,3.2509999999999999,3.3180000000000001,3.3780000000000001,3.5009999999999999,3.4529999999999998,3.4180000000000001,3.6379999999999999,3.8109999999999999,3.7149999999999999,3.6389999999999998,3.6230000000000002,3.71,3.8639999999999999,3.9409999999999998,3.8650000000000002,3.8109999999999999,3.8010000000000002,3.9249999999999998,3.8839999999999999,3.9350000000000001,3.9369999999999998,3.9089999999999998,3.8519999999999999,3.915,3.9409999999999998,3.9239999999999999,3.948,3.988]
[null,"ALAGOAS",1.917,1.956,2.0209999999999999,2.0590000000000002,2.0590000000000002,2.0590000000000002,2.0550000000000002,2.056,2.0590000000000002,2.052,2.0550000000000002,2.1349999999999998,2.1829999999999998,2.1850000000000001,2.1890000000000001,2.1869999999999998,2.1840000000000002,2.2000000000000002,2.2000000000000002,2.206,2.2090000000000001,2.206,2.2519999999999998,2.3119999999999998,2.3239999999999998,2.41,2.488,2.4910000000000001,2.4980000000000002,2.5030000000000001,2.5110000000000001,2.5230000000000001,2.5299999999999998,2.5920000000000001,2.6440000000000001,2.661,2.6970000000000001,2.722,2.7440000000000002,2.7389999999999999,2.7360000000000002,2.7210000000000001,2.7160000000000002,2.722,2.7120000000000002,2.7040000000000002,2.637,2.6659999999999999,2.7410000000000001,2.7450000000000001,2.67,2.6379999999999999,2.6360000000000001,2.62,2.5489999999999999,2.7090000000000001,2.786,2.907,2.9470000000000001,2.9660000000000002,3.081,3.081,3.0619999999999998,3.1669999999999998,3.4159999999999999,3.234,3.1629999999999998,3.1680000000000001,3.371,3.4990000000000001,3.4780000000000002,3.3250000000000002,3.198,3.254,3.3919999999999999,3.3679999999999999,3.3690000000000002,3.39,3.2970000000000002,3.2490000000000001,3.3879999999999999,3.5070000000000001,3.4910000000000001,3.5619999999999998,3.544]
[null,"AMAPA",2.008,2.048,2.1280000000000001,2.125,2.13,2.1520000000000001,2.1419999999999999,2.133,2.129,2.1309999999999998,2.1339999999999999,2.218,2.294,2.3050000000000002,2.3079999999999998,2.3069999999999999,2.3180000000000001,2.34,2.3490000000000002,2.355,2.3580000000000001,2.355,2.4020000000000001,2.4660000000000002,2.4910000000000001,2.6019999999999999,2.6579999999999999,2.6560000000000001,2.6389999999999998,2.6429999999999998,2.7069999999999999,2.738,2.798,2.871,2.9159999999999999,2.9260000000000002,2.9319999999999999,3.0910000000000002,3.2269999999999999,3.2650000000000001,3.2850000000000001,3.2690000000000001,3.2690000000000001,3.27,3.286,3.31,3.3029999999999999,3.2989999999999999,3.3420000000000001,3.2989999999999999,3.1509999999999998,3.1469999999999998,3.1320000000000001,2.9980000000000002,2.9580000000000002,3.0990000000000002,3.25,3.351,3.427,3.5819999999999999,3.629,3.6219999999999999,3.585,3.7149999999999999,3.8959999999999999,3.7050000000000001,3.3980000000000001,3.3690000000000002,3.5790000000000002,3.6659999999999999,3.59,3.448,3.617,3.7330000000000001,3.6819999999999999,3.706,3.8359999999999999,3.6840000000000002,3.63,3.6640000000000001,3.7229999999999999,3.9620000000000002,3.9470000000000001,3.9630000000000001,3.964]
[null,"AMAZONAS",2.0110000000000001,2.0750000000000002,2.12,2.1459999999999999,2.145,2.145,2.1379999999999999,2.1339999999999999,2.14,2.1379999999999999,2.1379999999999999,2.2429999999999999,2.3050000000000002,2.3220000000000001,2.3210000000000002,2.3220000000000001,2.3170000000000002,2.3170000000000002,2.323,2.33,2.3279999999999998,2.3250000000000002,2.383,2.4340000000000002,2.448,2.54,2.605,2.6139999999999999,2.6259999999999999,2.633,2.6469999999999998,2.6560000000000001,2.66,2.7229999999999999,2.8,2.82,2.8420000000000001,2.8639999999999999,2.8620000000000001,2.87,2.8530000000000002,2.8540000000000001,2.86,2.843,2.8519999999999999,2.8479999999999999,2.8380000000000001,2.8170000000000002,2.9350000000000001,2.8540000000000001,2.774,2.738,2.7120000000000002,2.6469999999999998,2.6160000000000001,2.81,2.9889999999999999,2.9820000000000002,3.032,3.0409999999999999,3.129,3.1539999999999999,3.129,3.2069999999999999,3.3330000000000002,3.2650000000000001,3.15,3.1589999999999998,3.3210000000000002,3.4750000000000001,3.46,3.2949999999999999,3.2280000000000002,3.2669999999999999,3.3490000000000002,3.3490000000000002,3.45,3.3919999999999999,3.347,3.3130000000000002,3.4209999999999998,3.532,3.484,3.5169999999999999,3.5310000000000001]
[null,"BAHIA",1.865,1.9510000000000001,2.0110000000000001,2.0449999999999999,2.0369999999999999,2.0310000000000001,2.0339999999999998,2.0270000000000001,2.0209999999999999,2.0169999999999999,2.0219999999999998,2.1309999999999998,2.1749999999999998,2.1760000000000002,2.1709999999999998,2.165,2.1640000000000001,2.16,2.1619999999999999,2.16,2.16,2.157,2.1890000000000001,2.2679999999999998,2.2759999999999998,2.387,2.4500000000000002,2.4409999999999998,2.4279999999999999,2.4319999999999999,2.4449999999999998,2.4569999999999999,2.4710000000000001,2.5720000000000001,2.645,2.6560000000000001,2.6659999999999999,2.6789999999999998,2.6680000000000001,2.66,2.67,2.6589999999999998,2.661,2.6619999999999999,2.6539999999999999,2.6440000000000001,2.5920000000000001,2.5819999999999999,2.6789999999999998,2.65,2.5579999999999998,2.5169999999999999,2.5920000000000001,2.544,2.4740000000000002,2.6850000000000001,2.754,2.8290000000000002,2.883,2.923,3.0219999999999998,3.0089999999999999,2.984,3.089,3.2789999999999999,3.169,3.0979999999999999,3.089,3.2909999999999999,3.4049999999999998,3.2829999999999999,3.0880000000000001,3.0249999999999999,3.0950000000000002,3.1720000000000002,3.1930000000000001,3.2989999999999999,3.238,3.15,3.117,3.2069999999999999,3.359,3.359,3.375,3.4249999999999998]
[null,"CEARA",1.944,1.99,2.04,2.0579999999999998,2.0550000000000002,2.0339999999999998,2.06,2.0649999999999999,2.0659999999999998,2.0609999999999999,2.0590000000000002,2.1269999999999998,2.2189999999999999,2.2170000000000001,2.2130000000000001,2.2200000000000002,2.242,2.2290000000000001,2.2519999999999998,2.2759999999999998,2.2869999999999999,2.2799999999999998,2.2890000000000001,2.3410000000000002,2.3559999999999999,2.4060000000000001,2.5169999999999999,2.5270000000000001,2.5640000000000001,2.5670000000000002,2.573,2.5720000000000001,2.5590000000000002,2.6179999999999999,2.738,2.7370000000000001,2.7610000000000001,2.7770000000000001,2.79,2.7789999999999999,2.7749999999999999,2.7770000000000001,2.8050000000000002,2.8149999999999999,2.81,2.7879999999999998,2.7730000000000001,2.786,2.8460000000000001,2.8380000000000001,2.7919999999999998,2.6960000000000002,2.7330000000000001,2.698,2.6549999999999998,2.7559999999999998,2.7930000000000001,2.875,2.9209999999999998,2.9820000000000002,3.0430000000000001,3.069,3.073,3.133,3.2869999999999999,3.181,3.1309999999999998,3.137,3.2709999999999999,3.4289999999999998,3.4740000000000002,3.3460000000000001,3.1970000000000001,3.2349999999999999,3.3050000000000002,3.3519999999999999,3.4350000000000001,3.403,3.3340000000000001,3.319,3.3380000000000001,3.4769999999999999,3.508,3.5110000000000001,3.5649999999999999]
[null,"DISTRITO FEDERAL",1.95,2.0510000000000002,2.1779999999999999,2.137,2.1190000000000002,2.113,2.117,2.1190000000000002,2.121,2.1259999999999999,2.1269999999999998,2.2240000000000002,2.2309999999999999,2.2400000000000002,2.262,2.2709999999999999,2.2709999999999999,2.27,2.2719999999999998,2.274,2.2799999999999998,2.2890000000000001,2.3370000000000002,2.375,2.375,2.504,2.492,2.4860000000000002,2.488,2.4910000000000001,2.4940000000000002,2.5019999999999998,2.5419999999999998,2.601,2.653,2.65,2.7690000000000001,2.8079999999999998,2.798,2.8159999999999998,2.798,2.786,2.774,2.7839999999999998,2.786,2.7730000000000001,2.7469999999999999,2.7160000000000002,2.903,2.91,2.794,2.758,2.8130000000000002,2.7450000000000001,2.6579999999999999,2.8959999999999999,3.1110000000000002,3.13,3.2040000000000002,3.1739999999999999,3.2370000000000001,3.1850000000000001,3.2090000000000001,3.3769999999999998,3.5550000000000002,3.2559999999999998,3.226,3.2309999999999999,3.4140000000000001,3.5459999999999998,3.4510000000000001,3.1850000000000001,3.198,3.254,3.3519999999999999,3.359,3.4750000000000001,3.34,3.2690000000000001,3.2759999999999998,3.407,3.5019999999999998,3.49,3.5129999999999999,3.5790000000000002]
[null,"ESPIRITO SANTO",1.9219999999999999,2.0289999999999999,2.0310000000000001,2.085,2.09,2.09,2.0680000000000001,2.0630000000000002,2.0489999999999999,2.0430000000000001,2.0499999999999998,2.15,2.1779999999999999,2.2109999999999999,2.2069999999999999,2.2160000000000002,2.2240000000000002,2.2170000000000001,2.1739999999999999,2.1720000000000002,2.1869999999999998,2.19,2.2189999999999999,2.2519999999999998,2.266,2.4060000000000001,2.4740000000000002,2.4550000000000001,2.4740000000000002,2.4670000000000001,2.4710000000000001,2.4809999999999999,2.4870000000000001,2.5750000000000002,2.6269999999999998,2.641,2.653,2.6589999999999998,2.6549999999999998,2.6509999999999998,2.6509999999999998,2.653,2.657,2.6579999999999999,2.6869999999999998,2.6619999999999999,2.613,2.625,2.7280000000000002,2.7050000000000001,2.6440000000000001,2.601,2.6509999999999998,2.6110000000000002,2.5630000000000002,2.8079999999999998,2.8570000000000002,2.911,2.931,2.9279999999999999,2.9409999999999998,2.9550000000000001,2.9729999999999999,3.0019999999999998,3.1749999999999998,2.9710000000000001,2.9089999999999998,2.9140000000000001,3.1419999999999999,3.238,3.2080000000000002,3.0030000000000001,2.96,3.0289999999999999,3.1110000000000002,3.177,3.2989999999999999,3.1970000000000001,3.117,3.089,3.1779999999999999,3.3380000000000001,3.3090000000000002,3.347,3.3860000000000001]
[null,"GOIAS",1.952,2.0009999999999999,2.0190000000000001,2.0710000000000002,2.0750000000000002,2.0830000000000002,2.0840000000000001,2.0920000000000001,2.1019999999999999,2.113,2.113,2.2349999999999999,2.2450000000000001,2.254,2.2629999999999999,2.2759999999999998,2.2850000000000001,2.2730000000000001,2.2709999999999999,2.2829999999999999,2.282,2.294,2.3170000000000002,2.3660000000000001,2.3719999999999999,2.4460000000000002,2.4940000000000002,2.5419999999999998,2.556,2.5710000000000002,2.5830000000000002,2.5939999999999999,2.6259999999999999,2.7050000000000001,2.7269999999999999,2.7280000000000002,2.754,2.7770000000000001,2.7749999999999999,2.7589999999999999,2.738,2.754,2.7389999999999999,2.738,2.74,2.7410000000000001,2.7269999999999999,2.7210000000000001,2.8109999999999999,2.863,2.8380000000000001,2.8119999999999998,2.794,2.7719999999999998,2.7360000000000002,2.87,2.86,2.8969999999999998,2.9329999999999998,2.948,3.0019999999999998,2.996,3.004,3.0430000000000001,3.1920000000000002,3.2149999999999999,3.1560000000000001,3.1709999999999998,3.367,3.4660000000000002,3.379,3.12,3.0859999999999999,3.1429999999999998,3.238,3.2519999999999998,3.3660000000000001,3.3069999999999999,3.222,3.2029999999999998,3.33,3.4209999999999998,3.4340000000000002,3.4980000000000002,3.5350000000000001]
[null,"MARANHAO",1.946,2.012,2.0310000000000001,2.0230000000000001,2.073,2.0699999999999998,2.0670000000000002,2.073,2.0670000000000002,2.0609999999999999,2.0649999999999999,2.1190000000000002,2.1619999999999999,2.1760000000000002,2.1890000000000001,2.2069999999999999,2.2149999999999999,2.222,2.2269999999999999,2.206,2.2040000000000002,2.2090000000000001,2.2650000000000001,2.3090000000000002,2.3319999999999999,2.4209999999999998,2.5009999999999999,2.5030000000000001,2.492,2.5150000000000001,2.5310000000000001,2.552,2.5630000000000002,2.6259999999999999,2.6909999999999998,2.7160000000000002,2.7650000000000001,2.7869999999999999,2.7869999999999999,2.7919999999999998,2.7850000000000001,2.7789999999999999,2.774,2.7719999999999998,2.7650000000000001,2.7679999999999998,2.7010000000000001,2.74,2.8,2.7440000000000002,2.66,2.5470000000000002,2.5920000000000001,2.544,2.4950000000000001,2.65,2.7610000000000001,2.7850000000000001,2.8359999999999999,2.9180000000000001,2.976,3.0329999999999999,2.976,3.0550000000000002,3.2,3.13,3.177,3.0790000000000002,3.145,3.1920000000000002,3.1280000000000001,3.1070000000000002,3.069,3.1440000000000001,3.2109999999999999,3.1989999999999998,3.35,3.3149999999999999,3.2679999999999998,3.238,3.25,3.3889999999999998,3.399,3.4289999999999998,3.41]
[null,"MATO GROSSO",2.1669999999999998,2.2160000000000002,2.2610000000000001,2.2650000000000001,2.2509999999999999,2.2530000000000001,2.2530000000000001,2.254,2.238,2.2490000000000001,2.2400000000000002,2.3159999999999998,2.3809999999999998,2.3969999999999998,2.407,2.395,2.403,2.4089999999999998,2.407,2.411,2.4260000000000002,2.411,2.4700000000000002,2.5209999999999999,2.5430000000000001,2.613,2.6859999999999999,2.6840000000000002,2.7109999999999999,2.7240000000000002,2.7389999999999999,2.7610000000000001,2.766,2.85,2.9039999999999999,2.9169999999999998,2.9529999999999998,2.9420000000000002,2.9430000000000001,2.931,2.9279999999999999,2.9249999999999998,2.91,2.931,2.931,2.907,2.8639999999999999,2.8330000000000002,2.9409999999999998,2.9359999999999999,2.863,2.8210000000000002,2.84,2.7730000000000001,2.7229999999999999,2.9729999999999999,3.08,3.157,3.214,3.1909999999999998,3.2549999999999999,3.2320000000000002,3.198,3.278,3.5009999999999999,3.3530000000000002,3.331,3.323,3.5059999999999998,3.657,3.5659999999999998,3.35,3.3170000000000002,3.343,3.4380000000000002,3.4470000000000001,3.504,3.4289999999999998,3.355,3.3519999999999999,3.476,3.6120000000000001,3.573,3.6190000000000002,3.661]
[null,"MATO GROSSO DO SUL",2.0640000000000001,2.1309999999999998,2.1800000000000002,2.1989999999999998,2.1859999999999999,2.1789999999999998,2.1800000000000002,2.1840000000000002,2.177,2.1739999999999999,2.1779999999999999,2.274,2.327,2.3380000000000001,2.3380000000000001,2.3330000000000002,2.3250000000000002,2.3260000000000001,2.3239999999999998,2.331,2.3210000000000002,2.3290000000000002,2.399,2.4470000000000001,2.4620000000000002,2.5680000000000001,2.7130000000000001,2.72,2.7269999999999999,2.7280000000000002,2.6320000000000001,2.597,2.5990000000000002,2.6640000000000001,2.714,2.7080000000000002,2.831,2.9319999999999999,2.9089999999999998,2.9239999999999999,2.919,2.9169999999999998,2.9159999999999999,2.9089999999999998,2.9239999999999999,2.9020000000000001,2.8879999999999999,2.8809999999999998,3.0049999999999999,3.02,2.9660000000000002,2.8980000000000001,2.8740000000000001,2.8319999999999999,2.7669999999999999,2.9740000000000002,3.0409999999999999,3.0710000000000002,3.2050000000000001,3.2690000000000001,3.3119999999999998,3.3,3.29,3.331,3.4460000000000002,3.1749999999999998,3.085,3.12,3.3029999999999999,3.359,3.2610000000000001,3.0379999999999998,3.07,3.1280000000000001,3.2040000000000002,3.2090000000000001,3.2909999999999999,3.1949999999999998,3.1030000000000002,3.1150000000000002,3.2149999999999999,3.3410000000000002,3.335,3.3780000000000001,3.4220000000000002]
[null,"MINAS GERAIS",1.966,2.0209999999999999,2.0760000000000001,2.105,2.1059999999999999,2.0979999999999999,2.1019999999999999,2.0939999999999999,2.0990000000000002,2.1,2.0950000000000002,2.1840000000000002,2.242,2.254,2.2519999999999998,2.25,2.2480000000000002,2.242,2.2490000000000001,2.2519999999999998,2.25,2.25,2.2909999999999999,2.3420000000000001,2.3570000000000002,2.4470000000000001,2.508,2.5139999999999998,2.5139999999999998,2.5179999999999998,2.528,2.556,2.5830000000000002,2.657,2.68,2.6989999999999998,2.7130000000000001,2.7210000000000001,2.7240000000000002,2.722,2.7109999999999999,2.7090000000000001,2.7050000000000001,2.7010000000000001,2.71,2.6949999999999998,2.657,2.6469999999999998,2.7589999999999999,2.7530000000000001,2.6579999999999999,2.625,2.6720000000000002,2.613,2.5739999999999998,2.7919999999999998,2.8759999999999999,2.956,3.028,3.04,3.117,3.0939999999999999,3.101,3.2069999999999999,3.4060000000000001,3.1779999999999999,3.1520000000000001,3.1560000000000001,3.3439999999999999,3.4449999999999998,3.34,3.105,3.12,3.1859999999999999,3.2669999999999999,3.2749999999999999,3.37,3.294,3.19,3.1970000000000001,3.302,3.4369999999999998,3.4079999999999999,3.4489999999999998,3.516]
[null,"PARA",2.0289999999999999,2.097,2.13,2.1429999999999998,2.1440000000000001,2.1389999999999998,2.137,2.141,2.141,2.1360000000000001,2.1539999999999999,2.2509999999999999,2.2890000000000001,2.331,2.3319999999999999,2.3290000000000002,2.3260000000000001,2.3140000000000001,2.3290000000000002,2.3380000000000001,2.35,2.3610000000000002,2.3969999999999998,2.4409999999999998,2.4489999999999998,2.6080000000000001,2.63,2.61,2.63,2.609,2.6440000000000001,2.6579999999999999,2.7029999999999998,2.7690000000000001,2.7759999999999998,2.8140000000000001,2.843,2.8460000000000001,2.8559999999999999,2.859,2.855,2.8559999999999999,2.86,2.8610000000000002,2.8679999999999999,2.8450000000000002,2.81,2.8370000000000002,2.907,2.819,2.714,2.6739999999999999,2.7149999999999999,2.6469999999999998,2.536,2.7040000000000002,2.7879999999999998,2.9289999999999998,3.05,3.069,3.1789999999999998,3.1030000000000002,3.1219999999999999,3.2109999999999999,3.4060000000000001,3.2349999999999999,3.2160000000000002,3.194,3.4089999999999998,3.5209999999999999,3.5129999999999999,3.2570000000000001,3.226,3.2810000000000001,3.3540000000000001,3.38,3.4220000000000002,3.415,3.3519999999999999,3.4089999999999998,3.5209999999999999,3.641,3.6040000000000001,3.6720000000000002,3.6829999999999998]
[null,"PARAIBA",1.9079999999999999,1.9590000000000001,2.0150000000000001,2.0430000000000001,2.0550000000000002,2.0470000000000002,2.0489999999999999,2.0459999999999998,2.0339999999999998,2.0379999999999998,2.0419999999999998,2.117,2.169,2.177,2.1739999999999999,2.1749999999999998,2.173,2.1930000000000001,2.1970000000000001,2.1920000000000002,2.2000000000000002,2.2040000000000002,2.2490000000000001,2.3159999999999998,2.3279999999999998,2.415,2.4750000000000001,2.4910000000000001,2.4980000000000002,2.4940000000000002,2.508,2.512,2.5249999999999999,2.5840000000000001,2.6440000000000001,2.6579999999999999,2.702,2.7290000000000001,2.7360000000000002,2.7309999999999999,2.7280000000000002,2.7149999999999999,2.7,2.706,2.7010000000000001,2.681,2.6349999999999998,2.61,2.6869999999999998,2.6859999999999999,2.5840000000000001,2.569,2.621,2.56,2.5249999999999999,2.661,2.7469999999999999,2.8250000000000002,2.8740000000000001,2.9079999999999999,3,3.0190000000000001,3.0129999999999999,3.0739999999999998,3.2679999999999998,3.14,3.0830000000000002,3.0910000000000002,3.2789999999999999,3.4260000000000002,3.39,3.2069999999999999,3.0990000000000002,3.12,3.1720000000000002,3.2250000000000001,3.339,3.2709999999999999,3.1680000000000001,3.17,3.27,3.3969999999999998,3.3879999999999999,3.415,3.45]
[null,"PARANA",1.885,1.9410000000000001,2.0030000000000001,2.024,2.0169999999999999,2.0169999999999999,2.0209999999999999,2.012,2.02,2.0150000000000001,2.0089999999999999,2.1240000000000001,2.1680000000000001,2.165,2.1579999999999999,2.16,2.161,2.161,2.1549999999999998,2.16,2.1579999999999999,2.161,2.1989999999999998,2.2490000000000001,2.2610000000000001,2.3639999999999999,2.423,2.4159999999999999,2.4180000000000001,2.4159999999999999,2.4319999999999999,2.444,2.4470000000000001,2.5379999999999998,2.56,2.5649999999999999,2.5790000000000002,2.5920000000000001,2.5880000000000001,2.5910000000000002,2.5750000000000002,2.573,2.5720000000000001,2.5539999999999998,2.5449999999999999,2.5310000000000001,2.476,2.48,2.5910000000000002,2.5630000000000002,2.448,2.3940000000000001,2.4049999999999998,2.3199999999999998,2.254,2.536,2.6680000000000001,2.7240000000000002,2.7730000000000001,2.786,2.8420000000000001,2.7930000000000001,2.78,2.9249999999999998,3.1160000000000001,2.8959999999999999,2.8730000000000002,2.8679999999999999,3.0409999999999999,3.173,3.0790000000000002,2.8740000000000001,2.8610000000000002,2.9239999999999999,3.004,3.0129999999999999,3.1110000000000002,3.0390000000000001,2.9489999999999998,2.9550000000000001,3.05,3.194,3.1680000000000001,3.2040000000000002,3.2469999999999999]
[null,"PERNAMBUCO",1.9039999999999999,1.948,2.0169999999999999,2.0350000000000001,2.0409999999999999,2.0419999999999998,2.04,2.0409999999999999,2.032,2.0259999999999998,2.0230000000000001,2.1179999999999999,2.169,2.1930000000000001,2.1930000000000001,2.181,2.1819999999999999,2.1779999999999999,2.1840000000000002,2.1909999999999998,2.1890000000000001,2.194,2.2530000000000001,2.2989999999999999,2.3130000000000002,2.407,2.4660000000000002,2.4700000000000002,2.4769999999999999,2.488,2.4969999999999999,2.516,2.5659999999999998,2.6059999999999999,2.6789999999999998,2.6909999999999998,2.6960000000000002,2.7280000000000002,2.72,2.714,2.746,2.718,2.71,2.694,2.6739999999999999,2.6579999999999999,2.6110000000000002,2.5859999999999999,2.6760000000000002,2.657,2.577,2.508,2.556,2.4740000000000002,2.4359999999999999,2.5379999999999998,2.6659999999999999,2.774,2.7810000000000001,2.863,3.0190000000000001,3.012,2.9409999999999998,3.0590000000000002,3.2839999999999998,3.1709999999999998,3.1520000000000001,3.181,3.3420000000000001,3.4849999999999999,3.4350000000000001,3.302,3.2120000000000002,3.2360000000000002,3.2919999999999998,3.3010000000000002,3.3849999999999998,3.3370000000000002,3.2469999999999999,3.2570000000000001,3.2509999999999999,3.4449999999999998,3.423,3.4769999999999999,3.51]
[null,"PIAUI",1.9770000000000001,2.0289999999999999,2.08,2.11,2.109,2.1030000000000002,2.1019999999999999,2.0990000000000002,2.1030000000000002,2.101,2.1030000000000002,2.1869999999999998,2.2360000000000002,2.2360000000000002,2.2389999999999999,2.2330000000000001,2.2349999999999999,2.2389999999999999,2.2469999999999999,2.2509999999999999,2.2530000000000001,2.2589999999999999,2.3140000000000001,2.379,2.3809999999999998,2.4750000000000001,2.5419999999999998,2.5459999999999998,2.5329999999999999,2.5419999999999998,2.5619999999999998,2.5659999999999998,2.6110000000000002,2.6560000000000001,2.7280000000000002,2.8050000000000002,2.819,2.883,2.8170000000000002,2.802,2.77,2.782,2.786,2.786,2.8180000000000001,2.8119999999999998,2.8029999999999999,2.7160000000000002,2.879,2.831,2.7210000000000001,2.5920000000000001,2.6760000000000002,2.62,2.5390000000000001,2.714,2.847,2.8929999999999998,2.98,3.0230000000000001,3.07,3.0720000000000001,3.0649999999999999,3.1869999999999998,3.423,3.3319999999999999,3.19,3.1869999999999998,3.387,3.5750000000000002,3.4369999999999998,3.2280000000000002,3.1890000000000001,3.202,3.24,3.222,3.36,3.2749999999999999,3.198,3.23,3.3639999999999999,3.4969999999999999,3.4950000000000001,3.5230000000000001,3.5739999999999998]
[null,"RIO DE JANEIRO",1.881,1.9339999999999999,1.9770000000000001,2.0059999999999998,2.0089999999999999,2.0070000000000001,2,1.998,1.9930000000000001,1.9930000000000001,1.998,2.0779999999999998,2.1269999999999998,2.1379999999999999,2.1419999999999999,2.14,2.14,2.137,2.1389999999999998,2.141,2.1440000000000001,2.153,2.2000000000000002,2.262,2.274,2.3620000000000001,2.4329999999999998,2.427,2.4239999999999999,2.4239999999999999,2.4319999999999999,2.4449999999999998,2.4769999999999999,2.5470000000000002,2.5979999999999999,2.609,2.6190000000000002,2.633,2.637,2.7040000000000002,2.718,2.7210000000000001,2.7130000000000001,2.7050000000000001,2.706,2.702,2.649,2.6360000000000001,2.7349999999999999,2.73,2.67,2.6379999999999999,2.6869999999999998,2.6349999999999998,2.5760000000000001,2.7919999999999998,2.8780000000000001,2.9489999999999998,3.008,3.0430000000000001,3.0960000000000001,3.077,3.0550000000000002,3.181,3.3530000000000002,3.13,3.0230000000000001,3.0150000000000001,3.165,3.2519999999999998,3.206,3.0190000000000001,2.9740000000000002,3.0310000000000001,3.117,3.1259999999999999,3.2029999999999998,3.1389999999999998,3.0539999999999998,3.0590000000000002,3.149,3.2919999999999998,3.2759999999999998,3.302,3.3610000000000002]
[null,"RIO GRANDE DO NORTE",1.905,1.9410000000000001,1.9830000000000001,1.988,1.988,1.9870000000000001,2.008,2.0249999999999999,2.0099999999999998,2.0249999999999999,2.0539999999999998,2.0819999999999999,2.1459999999999999,2.1720000000000002,2.177,2.1659999999999999,2.1989999999999998,2.2349999999999999,2.25,2.254,2.2549999999999999,2.2480000000000002,2.2930000000000001,2.3290000000000002,2.3450000000000002,2.4350000000000001,2.492,2.4929999999999999,2.528,2.5179999999999998,2.5259999999999998,2.5459999999999998,2.56,2.6240000000000001,2.6429999999999998,2.706,2.7360000000000002,2.7440000000000002,2.7450000000000001,2.7810000000000001,2.8069999999999999,2.758,2.7959999999999998,2.7810000000000001,2.7570000000000001,2.7719999999999998,2.7759999999999998,2.7810000000000001,2.82,2.8109999999999999,2.774,2.7229999999999999,2.694,2.6579999999999999,2.625,2.6829999999999998,2.8029999999999999,2.8849999999999998,2.91,2.9780000000000002,3.0419999999999998,3.0670000000000002,3.11,3.169,3.2850000000000001,3.181,3.1059999999999999,3.0920000000000001,3.2639999999999998,3.415,3.4529999999999998,3.2629999999999999,3.1869999999999998,3.1640000000000001,3.2250000000000001,3.282,3.3660000000000001,3.335,3.2669999999999999,3.2610000000000001,3.3140000000000001,3.411,3.4180000000000001,3.4590000000000001,3.4990000000000001]
[null,"RIO GRANDE DO SUL",1.9079999999999999,1.9710000000000001,2.008,2.0230000000000001,2.0209999999999999,2.0179999999999998,2.012,2.0019999999999998,2.004,2,2.0030000000000001,2.089,2.1190000000000002,2.129,2.125,2.12,2.1150000000000002,2.0979999999999999,2.101,2.0979999999999999,2.1,2.097,2.1389999999999998,2.198,2.2029999999999998,2.3090000000000002,2.37,2.3660000000000001,2.3650000000000002,2.3570000000000002,2.3769999999999998,2.3929999999999998,2.3820000000000001,2.4660000000000002,2.4980000000000002,2.492,2.528,2.54,2.5350000000000001,2.5369999999999999,2.528,2.5299999999999998,2.5299999999999998,2.5219999999999998,2.5110000000000001,2.5009999999999999,2.4630000000000001,2.456,2.5430000000000001,2.5449999999999999,2.4929999999999999,2.4630000000000001,2.4750000000000001,2.399,2.33,2.536,2.6320000000000001,2.7570000000000001,2.7919999999999998,2.8380000000000001,2.9119999999999999,2.8359999999999999,2.859,2.9460000000000002,3.1629999999999998,3.008,2.94,2.9369999999999998,3.0920000000000001,3.2360000000000002,3.1589999999999998,2.9319999999999999,2.8889999999999998,2.948,3.03,3.0419999999999998,3.153,3.1030000000000002,2.9940000000000002,2.9950000000000001,3.0329999999999999,3.18,3.2029999999999998,3.2320000000000002,3.2949999999999999]
[null,"RONDONIA",2.0529999999999999,2.1059999999999999,2.1579999999999999,2.194,2.2040000000000002,2.1970000000000001,2.218,2.2080000000000002,2.2149999999999999,2.2109999999999999,2.2069999999999999,2.2789999999999999,2.3130000000000002,2.319,2.3650000000000002,2.403,2.4020000000000001,2.4020000000000001,2.391,2.3940000000000001,2.3929999999999998,2.4009999999999998,2.407,2.452,2.5150000000000001,2.5590000000000002,2.66,2.6459999999999999,2.649,2.68,2.6819999999999999,2.7010000000000001,2.7330000000000001,2.758,2.8180000000000001,2.86,2.8730000000000002,2.8730000000000002,2.8780000000000001,2.89,2.891,2.9060000000000001,2.895,2.887,2.8719999999999999,2.8889999999999998,2.8620000000000001,2.8519999999999999,2.9510000000000001,2.91,2.8119999999999998,2.742,2.7229999999999999,2.6459999999999999,2.5950000000000002,2.7759999999999998,2.927,2.9790000000000001,3.044,3.0649999999999999,3.1909999999999998,3.1720000000000002,3.1749999999999998,3.2360000000000002,3.45,3.2610000000000001,3.2170000000000001,3.2280000000000002,3.3769999999999998,3.5609999999999999,3.4780000000000002,3.3,3.302,3.3610000000000002,3.3690000000000002,3.39,3.484,3.4039999999999999,3.319,3.3079999999999998,3.411,3.5289999999999999,3.53,3.5630000000000002,3.5950000000000002]
[null,"RORAIMA",2.0369999999999999,2.093,2.1539999999999999,2.1789999999999998,2.157,2.1659999999999999,2.161,2.15,2.161,2.153,2.1659999999999999,2.2669999999999999,2.327,2.331,2.3620000000000001,2.3479999999999999,2.3450000000000002,2.347,2.3199999999999998,2.3359999999999999,2.335,2.3490000000000002,2.3940000000000001,2.448,2.4489999999999998,2.5670000000000002,2.625,2.6440000000000001,2.6440000000000001,2.6509999999999998,2.6579999999999999,2.673,2.6640000000000001,2.7370000000000001,2.802,2.827,2.8519999999999999,2.8570000000000002,2.85,2.8730000000000002,2.8420000000000001,2.8279999999999998,2.84,2.8620000000000001,2.859,2.8650000000000002,2.7919999999999998,2.827,2.895,2.8140000000000001,2.7040000000000002,2.581,2.5920000000000001,2.5129999999999999,2.4239999999999999,2.5920000000000001,2.726,2.8170000000000002,2.911,2.93,3.0630000000000002,3.0569999999999999,2.98,3.0310000000000001,3.2690000000000001,3.12,3.0680000000000001,3.085,3.27,3.4289999999999998,3.3410000000000002,3.1379999999999999,3.0640000000000001,3.0459999999999998,3.141,3.173,3.2480000000000002,3.258,3.1629999999999998,3.1589999999999998,3.2440000000000002,3.4510000000000001,3.4430000000000001,3.47,3.512]
[null,"SANTA CATARINA",1.925,1.97,2.0350000000000001,2.0470000000000002,2.0489999999999999,2.0430000000000001,2.0339999999999998,2.028,2.0459999999999998,2.0449999999999999,2.0529999999999999,2.1520000000000001,2.1949999999999998,2.1850000000000001,2.202,2.1800000000000002,2.1789999999999998,2.1720000000000002,2.1659999999999999,2.1680000000000001,2.1680000000000001,2.1520000000000001,2.21,2.2690000000000001,2.2629999999999999,2.3919999999999999,2.4159999999999999,2.4159999999999999,2.419,2.42,2.431,2.4510000000000001,2.4830000000000001,2.5350000000000001,2.6030000000000002,2.6110000000000002,2.6230000000000002,2.61,2.593,2.6110000000000002,2.6150000000000002,2.605,2.569,2.585,2.5950000000000002,2.5739999999999998,2.5299999999999998,2.5630000000000002,2.6160000000000001,2.6429999999999998,2.4940000000000002,2.52,2.4889999999999999,2.4369999999999998,2.3530000000000002,2.5569999999999999,2.6339999999999999,2.714,2.8029999999999999,2.8290000000000002,2.899,2.8290000000000002,2.79,2.95,3.137,2.9910000000000001,2.915,2.9220000000000002,3.1,3.2210000000000001,3.1859999999999999,3.0030000000000001,2.8849999999999998,2.9580000000000002,3.0089999999999999,3.0409999999999999,3.133,3.069,2.9489999999999998,2.9329999999999998,2.9580000000000002,3.0750000000000002,3.1619999999999999,3.1850000000000001,3.2589999999999999]
[null,"SAO PAULO",1.865,1.9379999999999999,1.986,2.0059999999999998,2.0030000000000001,2,1.998,1.99,1.9890000000000001,1.986,1.9850000000000001,2.0830000000000002,2.1269999999999998,2.1259999999999999,2.1269999999999998,2.1280000000000001,2.125,2.1230000000000002,2.1240000000000001,2.125,2.1230000000000002,2.1240000000000001,2.181,2.2229999999999999,2.2360000000000002,2.335,2.3929999999999998,2.39,2.3969999999999998,2.4,2.419,2.4289999999999998,2.452,2.5179999999999998,2.5680000000000001,2.5859999999999999,2.6,2.6040000000000001,2.6030000000000002,2.6,2.5920000000000001,2.585,2.5790000000000002,2.5739999999999998,2.577,2.5670000000000002,2.5150000000000001,2.5230000000000001,2.6240000000000001,2.617,2.5390000000000001,2.5030000000000001,2.5409999999999999,2.4830000000000001,2.4289999999999998,2.653,2.738,2.827,2.8919999999999999,2.8780000000000001,2.9159999999999999,2.89,2.867,2.996,3.1909999999999998,2.9660000000000002,2.9340000000000002,2.9550000000000001,3.137,3.2480000000000002,3.1629999999999998,2.9009999999999998,2.8929999999999998,2.98,3.0649999999999999,3.0779999999999998,3.1869999999999998,3.1080000000000001,3.0230000000000001,3.0179999999999998,3.1269999999999998,3.2629999999999999,3.2440000000000002,3.2669999999999999,3.3050000000000002]
[null,"SERGIPE",1.9630000000000001,2.04,2.1,2.117,2.1190000000000002,2.113,2.101,2.1019999999999999,2.0819999999999999,2.0739999999999998,2.08,2.1800000000000002,2.2149999999999999,2.2160000000000002,2.1960000000000002,2.2109999999999999,2.198,2.1880000000000002,2.2000000000000002,2.1819999999999999,2.1880000000000002,2.1840000000000002,2.254,2.282,2.306,2.4390000000000001,2.5070000000000001,2.5,2.5179999999999998,2.5270000000000001,2.528,2.5489999999999999,2.5409999999999999,2.64,2.6880000000000002,2.702,2.738,2.7349999999999999,2.7130000000000001,2.7370000000000001,2.69,2.6909999999999998,2.67,2.6680000000000001,2.669,2.68,2.6539999999999999,2.6549999999999998,2.7650000000000001,2.7,2.6110000000000002,2.59,2.6120000000000001,2.5739999999999998,2.5390000000000001,2.762,2.851,2.875,2.964,2.9710000000000001,3.089,3.056,3.0569999999999999,3.1880000000000002,3.41,3.1920000000000002,3.2170000000000001,3.1829999999999998,3.3460000000000001,3.4569999999999999,3.367,3.226,3.133,3.1509999999999998,3.206,3.29,3.3889999999999998,3.3290000000000002,3.22,3.1739999999999999,3.246,3.4990000000000001,3.46,3.5150000000000001,3.5]
[null,"TOCANTINS",1.8979999999999999,1.944,1.9490000000000001,1.9790000000000001,2,1.9810000000000001,1.9930000000000001,1.948,1.982,1.968,1.956,2.0720000000000001,2.1240000000000001,2.1539999999999999,2.1440000000000001,2.1459999999999999,2.1480000000000001,2.165,2.1539999999999999,2.173,2.1859999999999999,2.1840000000000002,2.246,2.3180000000000001,2.3140000000000001,2.4089999999999998,2.472,2.4950000000000001,2.5219999999999998,2.5489999999999999,2.5230000000000001,2.5419999999999998,2.5739999999999998,2.6509999999999998,2.6819999999999999,2.6720000000000002,2.7040000000000002,2.714,2.7250000000000001,2.7360000000000002,2.7360000000000002,2.73,2.7250000000000001,2.6930000000000001,2.6680000000000001,2.6869999999999998,2.601,2.556,2.702,2.6379999999999999,2.512,2.5049999999999999,2.4620000000000002,2.4409999999999998,2.375,2.5939999999999999,2.7160000000000002,2.7850000000000001,2.8570000000000002,2.8769999999999998,3.024,3.0379999999999998,2.9350000000000001,3.0419999999999998,3.2709999999999999,3.0779999999999998,3.056,3.036,3.2749999999999999,3.4009999999999998,3.2719999999999998,3.085,2.956,3.0470000000000002,3.1190000000000002,3.145,3.2240000000000002,3.1640000000000001,3.1059999999999999,3.1360000000000001,3.2349999999999999,3.3559999999999999,3.3479999999999999,3.363,3.3860000000000001]
[null,"Média do mês no Brasil",{"$f":"AVERAGE(C2:C28)","v":1.9680000000000002},{"$f":"AVERAGE(D2:D28)","v":2.0263703703703708},2.0749629629629625,2.0965925925925926,2.0981851851851854,2.0945925925925928,2.0947777777777774,2.0921851851851847,2.0918888888888891,2.0907777777777774,2.0944444444444446,2.1831481481481485,2.2310370370370372,2.2414444444444439,2.2454814814814816,2.2470740740740731,2.2481111111111116,2.249222222222222,2.2492592592592593,2.2528888888888887,2.2553703703703709,2.2561111111111112,2.3024074074074075,2.3551111111111109,2.3684814814814819,2.4673703703703702,2.5311481481481484,2.5334074074074073,2.5410370370370368,2.5458148148148152,2.5540740740740739,2.5677777777777782,2.585185185185185,2.6537407407407407,2.7077407407407406,2.7240370370370366,2.7537777777777768,2.7757037037037038,2.7762222222222217,2.7830370370370372,2.7783333333333333,2.7728518518518523,2.7701851851851851,2.767851851851852,2.7681851851851857,2.7622222222222224,2.7245555555555558,2.7187407407407402,2.8151111111111109,2.791555555555556,2.7045185185185185,2.6574814814814811,2.6758888888888888,2.6191111111111107,2.5625185185185186,2.7490000000000001,2.8501481481481474,2.9198148148148153,2.9821481481481475,3.0147407407407409,3.095814814814815,3.0816296296296293,3.0648518518518522,3.1643333333333334,3.3527037037037037,{"$f":"AVERAGE(BP2:BP28)","v":3.1943703703703701},3.1335185185185188,3.1301111111111104,3.3054814814814812,3.4311481481481487,3.3717777777777789,3.1855555555555553,3.1394814814814818,3.1874444444444441,3.2588518518518521,3.2769629629629633,3.36974074074074,3.3098888888888887,3.2296296296296285,3.2240000000000002,3.3082592592592586,3.4462222222222221,3.4378888888888892,3.4724444444444447,3.5074814814814812]
[null,"IPCA (mensal) (%)",0.86,0.6,0.47,0.55000000000000004,0.37,0.26,0.03,0.24,0.35,0.56999999999999995,0.54,0.92,0.55000000000000004,0.69,0.92,0.67,0.46,0.4,0.01,0.25,0.56999999999999995,0.42,0.51,0.78,1.24,1.22,1.32,0.71,0.74,0.79,0.62,0.22,0.54,0.82,1.01,0.96,1.27,0.9,0.43,0.61,0.78,0.35,0.52,0.44,0.08,0.26,0.18,0.3,0.38,0.33,0.25,0.14000000000000001,0.31,-0.23,0.24,0.19,0.16,0.42,0.28000000000000003,0.44,0.28999999999999998,0.32,0.09,0.22,0.4,1.26,0.33,-0.09,0.48,0.45,-0.21,0.15,0.32,0.43,0.75,0.56999999999999995,0.13,0.01,0.19,0.11,-0.04,0.1,0.51,1.1499999999999999,0.21]
[null,"1+ IPCA (mensal)",{"$f":"1+C30/100","v":1.0085999999999999},{"$f":"1+D30/100","v":1.006},1.0046999999999999,1.0055000000000001,{"$f":"1+G30/100","v":1.0037},1.0025999999999999,1.0003,1.0024,{"$f":"1+K30/100","v":1.0035000000000001},1.0057,1.0054000000000001,1.0092000000000001,1.0055000000000001,1.0068999999999999,1.0092000000000001,1.0066999999999999,1.0045999999999999,1.004,1.0001,1.0024999999999999,1.0057,1.0042,1.0051000000000001,1.0078,1.0124,1.0122,1.0132000000000001,1.0071000000000001,1.0074000000000001,1.0079,1.0062,1.0022,1.0054000000000001,1.0082,1.0101,1.0096000000000001,1.0126999999999999,1.0089999999999999,1.0043,1.0061,1.0078,1.0035000000000001,1.0052000000000001,1.0044,1.0007999999999999,1.0025999999999999,1.0018,1.0029999999999999,1.0038,1.0033000000000001,1.0024999999999999,1.0014000000000001,1.0031000000000001,0.99770000000000003,1.0024,1.0019,1.0016,1.0042,1.0027999999999999,1.0044,1.0028999999999999,1.0032000000000001,1.0008999999999999,1.0022,1.004,{"$f":"1+BP30/100","v":1.0125999999999999},1.0033000000000001,0.99909999999999999,1.0047999999999999,1.0044999999999999,0.99790000000000001,1.0015000000000001,1.0032000000000001,1.0043,1.0075000000000001,1.0057,1.0013000000000001,1.0001,1.0019,1.0011000000000001,0.99960000000000004,1.0009999999999999,1.0051000000000001,1.0115000000000001,1.0021]
[null,"Multiplicador IPCA 2019",{"$f":"C31*D32","v":1.420407717002883},{"$f":"D31*E32","v":1.408296368236053},1.3998969863181441,{"$f":"F31*G32","v":1.3933482495452814},{"$f":"G31*H32","v":1.3857267524070425},1.3806184640899097,1.3770381648612706,{"$f":"J31*K32","v":1.3766251773080782},1.3733291872586575,1.3685392997096735,{"$f":"M31*N32","v":1.3607828375357198},1.3534740775171272,1.3411356297236694,1.333799731202058,1.3246595800993723,1.3125838090560564,1.3038480272733253,1.2978777894418927,1.2927069615955107,1.2925777038251283,1.2893543180300533,1.2820466521130092,1.276684576890071,1.2702065236196107,1.2603755939865158,1.2449383583430618,1.2299331736248387,1.2139095673360034,1.2053515711806209,1.1964974897564233,1.1871192476995964,1.1798044600473032,1.177214587953805,1.1708917723829371,1.1613685502707172,1.1497560145240244,1.1388233107409116,1.1245416320143298,1.1145110327198513,1.1097391543561199,1.1030107885459894,1.0944738921869313,1.0906565941075548,1.0850145186107787,1.0802613685889872,1.0793978503087402,1.0765986937051071,1.0746642979687633,1.0714499481243902,1.0673938514887329,1.063883037465098,1.0612299625587014,1.0597463177139019,1.0564712568177668,1.0589067423251144,1.056371450843091,1.0543681513555156,1.0526838571840211,1.0482810766620405,1.0453540852234151,1.0407746766461721,1.0377651576888745,1.0344549020024665,1.0335247297456955,{"$f":"BO31*BP32","v":1.0312559666191334},1.0271473771106907,1.0143663609625624,1.011029962087673,1.0119407087255261,1.00710659705964,{"$f":"BU31*BV32","v":1.0025949199200002},{"$f":"BV31*BW31","v":1.0047048000000001},{"$f":"BW31*BX31","v":1.0075137600000001},1.0118322500000001,1.0132427500000001,1.0070074100000002,1.0014001300000002,1.00200019,1.0030020900000001,1.0006995600000002,1.0005995999999999,1.0061051000000001,1.0166586500000001,1.0136241500000001,{"$f":"CI31","v":1.0021}]
[null,"Meses de 2013 a 2019","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01","2013-07-01","2013-08-01","2013-09-01","2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","2014-07-01","2014-08-01","2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01"]
[1,"Escolha o Estado",{"$f":"C62","v":2.7953623870616742},2.8537300332937381,2.904734398573618,2.9212836188984928,2.9075113426152361,2.8918332080792872,2.8845889469032815,2.8801548015168907,2.8728520676131941,2.8613115558485473,2.8500840541720351,2.9548344258980395,2.9921232616034961,2.9896379975043459,2.9744985563801754,2.9494730473792594,2.9311952373134655,2.9192155657413594,2.9076331028776061,2.912033946973144,2.9079715257940784,2.8924396967949608,2.9394480267544907,2.9914774971823639,2.9851762540682847,3.0717240183132013,3.1131430747664854,3.0753274898117522,3.0628429850207417,3.0460610353106397,3.0319904933838586,3.0294756746325753,3.0433177125620596,3.1072431993707341,3.1446849385830324,3.1319779671195365,3.1360663259336405,3.1213943729511819,3.0941302959486894,3.0884451680232434,3.0645316408436081,3.0348139587540364,3.0213207391212795,3.0031594446229897,2.9903635166559068,2.9815367287416983,2.9332529520381034,2.9217336095072235,3.0162506539643941,2.979689236089214,2.8772913763620891,2.8201989730930346,2.8357633966115441,2.7670156073009333,2.7134681365922235,2.9039651183676569,3.00510543405231,3.0736419215223085,3.1261294715064509,3.1514715492227987,3.2220456628453178,3.1980078585313008,3.1704510220594861,3.2704167531586288,{"$f":"BO62","v":3.4574956987505114},3.2810891474460315,3.1785357766384288,3.1646361179968712,3.3449512730494728,3.4555319354889669,3.380527271099147,3.2005429573333335,{"$f":"BW62","v":3.1630707918577787},{"$f":"BX62","v":3.2251590839722231},3.3020080122129634,3.29992598599926,3.3744588158440751,3.316509295545556,3.2393252684444436,3.2262553814400006,3.3102428915111108,3.4672617535111119,3.4951594766277774,3.5197535484222224,3.5148471925925917]
[2,"ACRE",{"$f":"C$32*C2","v":3.2470520410685908},{"$f":"D$32*D2","v":3.2672475743076426},{"$f":"E$32*E2","v":3.2659596690802304},3.3384624059104939,3.3382157465485651,3.2955362737826146,3.2842360231941301,3.3107835514259278,3.2973633786080363,3.3050224087988616,3.3216709064246919,3.397219934567989,3.4494008396492779,3.4305329086516934,3.4070244400155856,3.4153430711638588,3.3574086702288128,3.338141674444548,3.313207942569294,3.3206321211267547,3.3020364084749665,3.2679369162360601,3.3398068531444256,3.4168555485367529,3.4156178597034579,3.4771128348521718,3.5065394780044152,3.4705674530136337,3.4581536577172014,3.4339477956009352,3.4189034333748376,3.440309805497936,{"$f":"AI$32*AI2","v":3.4115678758901269},3.4752067804325573,3.5804992404846212,3.5550455969082835,3.5349075565397898,3.4827054343483792,3.4326939807771422,3.4046797255645758,3.3895521532018256,3.355656953445131,3.341771804345548,3.3082092672442642,3.309920833356657,3.3180689918490676,3.2793196210257558,3.2401128583758214,3.3504239877849677,3.2993143949516734,3.1927129954327591,3.1327508494732865,3.1368491004331496,3.0764442998533368,3.0538870448656299,3.2779206119661115,3.3476188805537621,3.4222752197052526,3.4781966123646506,3.5312060998846961,3.6437521429382485,3.5834030894996833,3.5357668550444306,3.7599629668148404,{"$f":"BO$32*BO2","v":3.9301164887855173},3.8158525059662156,3.6912791875427642,3.6629615526436394,3.7543000293717017,3.891459891038449,3.9512265794047203,3.8831840520000003,3.8396349393600007,{"$f":"BX$32*BX2","v":3.8459743822500005},3.9769777937500002,3.9112167804400007,3.9405095115500006,3.9448747480299997,3.9207351698099999,3.8546947051200005,3.9173474339999999,3.9650601991000003,3.9893685426000003,4.0017881441999998,3.9963747999999999]
[3,"ALAGOAS",{"$f":"C$32*C3","v":2.7229215934945268},2.7546276962697194,2.829191809348969,2.8689040458137347,2.8532113832061006,2.8426934175611245,2.8298134287899113,2.8303413645454087,2.8276847965655758,2.8082426430042502,2.7964087311359043,2.8896671554990663,2.9276990796867701,2.9143524126764966,2.8996798208375263,2.8706207904055954,2.8476040915649428,2.8553311367721643,2.8439553155101236,2.8514264146382331,2.8481836885283878,2.8281949145612981,2.8750936671564395,2.9367174826085396,2.9291128804246624,3.0003014436067792,3.0600737359785986,3.0238487322339846,3.0109682248091914,2.9948332168603278,2.9808564309736867,2.9766466526993463,{"$f":"AI$32*AI3","v":2.9783529075231265},3.0349514740165731,3.0706584469157763,3.059500754648429,3.0714064690682386,3.0610023223430054,3.0582182737832722,3.0395755437814125,3.0178375174618273,2.97806346064064,2.9622233095961188,2.9534095196585395,2.9296688316133337,2.9186917872348337,2.8389907553003675,2.865055018384723,2.9368443078089537,2.929996122336572,2.8405677100318116,2.799524641229854,2.7934912934938456,2.7679546928625491,2.6991532861867165,2.8617102603339335,2.9374696696764668,3.0601519728339492,3.0892843329230333,3.1005202167726496,3.2066267787468563,3.197354450839422,3.1675009099315523,3.2731728191046177,{"$f":"BO$32*BO3","v":3.5227703819709597},3.3217946175759736,3.2084407997245847,3.2029429198937485,3.4112521291137483,3.5238659831116803,3.4870251314817606,3.3406434600000003,3.2220290044800004,{"$f":"BX$32*BX3","v":3.2925021415000004},3.4369194080000001,3.3916009568800005,3.3737170379700006,3.3967806441000001,3.3068978907300002,3.2512728704400007,3.3900314447999995,3.5284105857000005,3.5491553471500006,3.6105292222999998,3.5514424]
[4,"AMAPA",{"$f":"C$32*C4","v":2.8521786957417889},2.8841909621474366,2.9789807868850109,2.9608650302837227,2.9515979826270002,2.9710909347214858,2.9496157491328416,2.9363415031981308,2.9238178396736818,2.9163572476813138,2.903910575301226,3.0020055039329883,3.0765651345860978,3.0744083804207438,3.057314310869351,3.0281308474923221,3.0223197272195681,3.0370340272940286,3.0365686527878548,3.0440204925081771,3.0402974819148656,3.0192198657261367,3.0665963536899508,3.1323292872459603,3.139595604620411,3.2393296084086467,3.2691623754948211,3.2241438108444251,3.1809227963456581,3.1623428654262264,3.2135318035228075,3.2303046116095162,{"$f":"AI$32*AI4","v":3.2938464170947461},3.3616302785114125,3.3865506925894113,3.3641860984972958,3.3390299470923526,3.4759581845562937,3.5965271025869598,3.6232983389727318,3.6233904403735755,3.5778351535590782,3.5653564061375969,3.5479974758572461,3.5497388571834123,3.5728068845219303,3.5560054853079688,3.5453175189989499,3.5807857266317122,3.5213323160613297,3.3522954510525236,3.3396906921722329,3.319125467079941,3.1673008279396648,3.1322461437976887,3.2736951261627394,3.4266964919054259,3.5275436054236549,3.5924592497208128,3.7444583332702726,3.7769713015489583,3.7587854011491033,3.7085208236788425,3.8395443710052586,{"$f":"BO$32*BO4","v":4.0177732459481437},3.8055810321951093,3.4468168945507873,3.4061599422733706,3.6217357965286583,3.6920527848206404,3.5993157625128003,3.4642221504000004,3.6441772699200006,{"$f":"BX$32*BX4","v":3.7771697892500007},3.7307598055000004,3.7319694614600007,3.8413708986800006,3.6913686999599999,3.6408975867,3.6665631878400009,3.7252323107999996,3.9861884062000006,4.0127516915500001,4.0169925064500003,3.9723243999999998]
[5,"AMAZONAS",{"$f":"C$32*C5","v":2.8564399188927978},2.9222149640898101,2.9677816109944657,2.9901253435241735,2.972383883913106,2.9614266054728562,2.9441075964733963,2.9377181283754386,2.9389244607335274,2.9259370227792818,2.9093537066513688,3.035842355870916,3.091317626513058,3.0970829758511789,3.0745348854106433,3.0478196046281631,3.0210158791922948,3.0071828381368655,3.0029582717863712,3.011706049912549,3.0016168523739637,2.9807584661627464,3.0423393467290389,3.0916826784901326,3.0853994540789906,3.1621434301913771,3.2039759172927047,3.173159609016313,3.1652532259203103,3.1503778905286626,3.1423046486608315,3.1335606458856375,{"$f":"AI$32*AI5","v":3.1313908039571214},3.1883382961987374,3.2518319407580081,3.2423119609577489,3.2365358491256706,3.2206872340890405,3.1897305756442145,3.1849513730020642,3.1468897797217079,3.123628488301502,3.1192778591476067,3.084696276410444,3.0809054232157913,3.0741250776792919,3.0553870927350939,3.0273293273780064,3.1447055977450855,3.0463420521488436,2.951211545928182,2.9056476374857243,2.8740320136401021,2.7964794167966285,2.7701000379224991,2.9684037768690859,3.1515064044016361,3.139103262122751,3.1783882244393067,3.1789217731644053,3.2565839632258724,3.2731113073507099,3.2368093883657174,3.3145138082944454,{"$f":"BO$32*BO5","v":3.4371761367415719},3.3536361862664053,3.1952540370320714,3.193843650234959,3.3606550936774724,3.4996954247822489,3.4689784229232004,3.310502316,3.2522544172800005,{"$f":"BX$32*BX5","v":3.3056559607500002},3.3933499697500005,3.3724678160900008,3.4548304485000005,3.3987846444799996,3.3570479952300003,3.3153176422800006,3.4230512315999997,3.5535632132000003,3.5420387366000003,3.5649161355500003,3.5384150999999999]
[6,"BAHIA",{"$f":"C$32*C6","v":2.649060392210377},2.7475862144285395,2.8151928394857877,2.8493971703201004,2.8227253946531454,2.804036100566607,2.800895627327824,2.7904192344034748,2.7754982874497465,2.7603437675144114,2.7515028974972253,2.884253259188998,2.9169699946489809,2.9023482150956785,2.875835948395737,2.8417439466063623,2.8215271310194763,2.8034160251944882,2.7948324509694942,2.7919678402622772,2.7850053269449151,2.765374628607761,2.7946625388123656,2.8808283955692771,2.8686148519133097,2.9716678613648884,3.0133362753808548,2.9631532538671843,2.9265936148265475,2.9098818950876213,2.9025065606255129,2.8987795583362237,{"$f":"AI$32*AI6","v":2.9088972468338521},3.0115336385689142,3.0718198154660468,3.053751974575809,3.0361029464352702,3.0126470321663894,2.9735154352965636,2.9519061505872792,2.9450388054177918,2.9102060793250502,2.9022371969202032,2.888308648541893,2.867013672235172,2.8539279162163091,2.7905438140836378,2.7747832173553468,2.8704144110252412,2.8285937064451421,2.7214128098357206,2.6711158157602513,2.7468624555144339,2.6876628773443989,2.6197352805123333,2.8363573455136994,2.90372988883309,2.978042631973596,3.022194344016663,3.0555699911080425,3.1452210728247318,3.1226353594858232,3.0868134275753598,3.1925578901844536,{"$f":"BO$32*BO6","v":3.3814883145441383},3.2550300380637789,3.1425069862620183,3.1230715528888218,3.3302968724157065,3.429197962988074,3.2915191220973603,3.1025284224000003,3.0477291240000004,{"$f":"BX$32*BX6","v":3.1316208137500006},3.2140060030000006,3.2153746601300006,3.3036190288700005,3.24447661522,3.1594565834999999,3.1191805285200003,3.2089229171999998,3.3795070309000002,3.4149564053500003,3.4209815062500004,3.4321924999999998]
[7,"CEARA",{"$f":"C$32*C7","v":2.7612726018536047},2.8025097727897452,2.8557898520890141,2.8675106975641889,2.8476684761964726,2.8081779559588762,2.8366986196142174,2.8427309911411816,2.837298100876386,2.820559496701637,2.8018518624860476,2.8788393628789293,2.9759799623568224,2.9570340040749628,2.931471650759911,2.9139360561044456,2.9232272771467951,2.8929695926659789,2.9111760775130899,2.9419068539059916,2.948753325334732,2.9230663668176606,2.9223309965013726,2.973553471793509,2.9694448994322311,2.995321690173407,3.095741798013719,3.0675494766580806,3.0905214285071119,3.0714090562047387,3.0544578243310614,3.0344570712416639,{"$f":"AI$32*AI7","v":3.0124921305737873},3.0653946600985291,3.1798270906412238,3.146882211752255,3.1442911609556572,3.1228521121037938,3.1094857812883854,3.0839651099556571,3.0608549382151207,3.0393539986031084,3.0592917464716911,3.0543158698893418,3.0355344457350544,3.0093612066607678,2.985408177644262,2.9940147341409746,3.0493465523620147,3.0292637505250242,2.9703614406025536,2.8610759790582589,2.8962866863120942,2.8503594508943348,2.8113974008731786,2.9113597185235585,2.9448502467359554,3.0264660894040607,3.0620290249298203,3.1172458821362241,3.1670773410343016,3.1849012689471556,3.1788799138535793,3.2380329782932642,{"$f":"BO$32*BO7","v":3.3897383622770914},3.2673558065891073,3.1759810761737826,3.1716009910690302,3.3100580582411956,3.4533685213175054,3.4830147518020809,3.3617422608000003,3.2210214907200005,{"$f":"BX$32*BX7","v":3.2732773287500003},3.3487672887500004,3.3754888383200004,3.4398094465500004,3.4098066465699999,3.3440089680600003,3.3213218396400004,3.3400014647999998,3.4982274327000003,3.5664385442000004,3.5588343906500004,3.5724865000000001]
[8,"DISTRITO FEDERAL",{"$f":"C$32*C8","v":2.7697950481556219},2.888415851252145,3.0489756362009177,2.9775852092782662,2.9363549883505233,2.9172468146219792,2.9151897950113099,2.9170687507158179,2.9128312061756128,2.9095145511827658,2.8943850954384756,3.0101263483980913,2.9920735899135065,2.98771139789261,2.9963799701847802,2.9808778303663042,2.9610388699377217,2.9461825820330962,2.9370302167450002,2.9393216984983419,2.9397278451085214,2.9346047866866782,2.9836118561920961,3.0167404935965756,2.9933920357179749,3.1173256492910268,3.064993468673098,3.0177791843973045,2.9989147090973849,2.9804752469832505,2.9606754037627936,2.9518707590383522,{"$f":"AI$32*AI8","v":2.9924794825785721},3.0454894999680193,3.0811107638682125,3.0468534384886645,3.1534017474415843,3.1577129026962378,3.1184018695501439,3.1250254586668333,3.0862241863516786,3.0492042636327903,3.0254813920543571,3.0206804198124075,3.0096081728889184,2.9931702389061368,2.957416611607929,2.9187882332831614,3.1104191994051047,3.106116107832213,2.972489206677484,2.9268722367368984,2.9810663917292062,2.9000135999647698,2.8145741211001538,3.0592517216415915,3.2801393188670094,3.2949004729859861,3.3586925696251781,3.3179538664991193,3.3689876283036591,3.3052820272390653,3.3195657805259149,3.4902130123512136,{"$f":"BO$32*BO8","v":3.6661149613310196},3.3443918598724087,3.2723458804652261,3.2666378075052713,3.4547655795889463,3.5711999931734835,3.4599550686439207,3.1999847880000001,3.2220290044800004,{"$f":"BX$32*BX8","v":3.2925021415000004},3.3963896980000001,3.3825378901900005,3.4798654517500007,3.3466806345999998,3.2788138322100004,3.2782917585600004,3.4090428371999999,3.5233800602000001,3.5481386885000008,3.5608616389500001,3.5865159000000002]
[9,"ESPIRITO SANTO",{"$f":"C$32*C9","v":2.7300236320795412},2.8574333311509514,2.8431907792121507,2.9051311003019116,2.8961689125307184,2.8854925899479111,2.8477149249331077,2.8399777407865656,2.813951504692989,2.795925789306863,2.7896048169482253,2.9099692666618235,2.9209934015381518,2.9490312056877501,2.9235236932793147,2.9086857208682213,2.8997580126558757,2.877395059192676,2.81034493450864,2.8074787727081789,2.8198178935317264,2.8076821681274899,2.8329630761190674,2.8605050911913632,2.8560110959734448,2.995321690173407,3.0428546715478513,2.9801479878098887,2.9820397871008564,2.9517593072290964,2.9333716610657028,2.927094865377359,{"$f":"AI$32*AI9","v":2.927732680241113},3.0150463138860633,3.0509151815611739,3.0365056343579484,3.0212982433956386,2.9901561995261026,2.9590267918712052,2.9419184981980737,2.924081600435418,2.9036392359719287,2.897874570543773,2.8839685904674495,2.9026622973986087,2.8733570775218666,2.8131523866514447,2.8209937821680038,2.9229154584833368,2.8873003682770224,2.8129067510577195,2.7602591326151824,2.8093874882595538,2.7584464515511891,2.7139779805792683,2.9662910339673996,3.0123298084227086,3.0643627082626854,3.0725118356964409,3.0607967615341596,3.060918324016392,3.0665960409706239,3.0754344236533329,3.1026412386965778,{"$f":"BO$32*BO9","v":3.2742376940157483},3.0516548573958624,2.9507917440400937,2.9461413095234792,3.1795177068156031,3.2610111612791144,3.2163245031033605,3.0171285144000004,2.9822407296000004,{"$f":"BX$32*BX9","v":3.0648398852500001},3.1521981952500004,3.1992625415700005,3.3036190288700005,3.2033946074299999,3.12635751453,3.0911609408400005,3.1799055287999995,3.3583788238000003,3.3641234728500007,3.3926000300500001,3.3931106]
[10,"GOIAS",{"$f":"C$32*C10","v":2.7726358635896275},2.8180010328403418,2.8263920153763329,2.8856242248082777,2.8753830112446135,2.8758282606992824,2.8697475355708879,2.8798998709284995,2.8867379516176981,2.8917235402865402,2.875334135712976,3.025014563250779,3.010849488729638,3.0063845941294387,2.9977046297648795,2.9874407494115842,2.9792927423195485,2.9500762154014222,2.9357375097834049,2.9509548978327675,2.9423065537445816,2.9410150199472431,2.9580781646542946,3.005308634883999,2.9896109089360152,3.0451192245071295,3.0674533350203479,3.0857581201681206,3.0808786159376669,3.0761950461637646,3.0663290168080577,3.0604127693627046,{"$f":"AI$32*AI10","v":3.0913655079666915},3.1672622442958449,3.1670520365882457,3.1365344076215389,3.1363193977804706,3.1228521121037938,3.0927681157975875,3.0617703268685346,3.0200435390389191,3.0141810990828088,2.9873084112605923,2.9707697519563121,2.9599161499338251,2.9586295076962572,2.9358846377338268,2.9241615547730051,3.011845804177661,3.0559485968122422,3.0193000603259486,2.9841786547150679,2.9609312116926421,2.9285383238988492,2.8971688470015131,3.0317860639196712,3.0154929128767747,3.0496251342621088,3.0746083978497647,3.0817038432386279,3.1244055792918082,3.1091444124358678,3.1075025256154092,3.1450157526161515,{"$f":"BO$32*BO10","v":3.291769045448274},3.3022788174108704,3.2013402351978471,3.2059760097800112,3.4072043662788465,3.4906314654087125,3.3877682344096804,3.1346789760000004,3.1091874633600005,{"$f":"BX$32*BX10","v":3.1801887617500002},3.2808800245,3.2747880973200001,3.3707128375800006,3.3136146283299999,3.23167273398,3.2052406906800002,3.3319966679999999,3.4418855471000001,3.4912058041000007,3.5456572767000005,3.5424234999999999]
[11,"MARANHAO",{"$f":"C$32*C11","v":2.7641134172876103},2.8334922928909387,2.8431907792121507,2.8187435088301043,2.8726115577397988,2.8578802206661131,2.8463378867682465,2.8537439925596462,2.8386714300636453,2.820559496701637,2.8100165595112614,2.8680115702587927,2.8995352314625733,2.9023482150956785,2.8996798208375263,2.8968724665867165,2.8880233804104152,2.8838844481398853,2.8788584034732021,2.8514264146382331,2.8417369169382378,2.8320410545176373,2.8916905666560111,2.9329068630376813,2.9391958851765545,3.0139957655485525,3.0760628672357213,3.0384156470420165,3.0037361153821074,3.009191186737405,3.0045988159276789,3.0108609820407177,{"$f":"AI$32*AI11","v":3.0172009889256022},3.0747617942775927,3.1252427687784996,3.1227373354472507,3.1488464541986207,3.1340975284239372,3.1061422481902254,3.0983917189622865,3.0718850461005807,3.0415429463874819,3.0254813920543571,3.0076602455890784,2.9869226841485497,2.9877732496545928,2.9078930716974942,2.9445801764344117,3.0000598547482924,2.9289287284850833,2.8299288796571611,2.7029527146370125,2.7468624555144339,2.6876628773443989,2.6419723221011604,2.7993843447341913,2.911110465892579,2.9317245422574989,2.9729251334135469,3.0503432206819254,3.0973454376990079,3.147541723270356,3.0785377883593403,3.1574180493731001,{"$f":"BO$32*BO11","v":3.300019093181227},3.2149712903564618,3.2226419287780605,3.1129612532679456,3.1825535289417797,3.2146842578143713,3.1361169095097607,3.1216178136000003,3.0920597294400003,{"$f":"BX$32*BX11","v":3.1812005940000003},3.2535224702500001,3.2214167045900002,3.3546904355000007,3.32163062985,3.27781083012,3.2402651752800007,3.2519486999999998,3.4096901839,3.4556227513500004,3.47571721035,3.4171610000000001]
[12,"MATO GROSSO",{"$f":"C$32*C12","v":3.0780235227452475},3.1207847520110938,3.165167086065324,3.1559337852200624,3.1192709196682524,3.110533399594567,3.1024669854324429,3.1029131496524083,3.0735107210848756,3.0778448850470559,3.0481535560800128,3.1346459635296666,3.1932439343720564,3.1971179556913327,3.1884556092991891,3.1436382226892552,3.1331468095378008,3.1265875947655193,3.1115456565603941,3.1164048439223841,3.1279735755409095,3.0910144782444653,3.1534109049184758,3.2021906460450387,3.2051351355077098,3.2530239303504205,3.3036005043563166,3.2581332787298334,3.267708109470663,3.2592591620964972,3.2515196194491947,3.2574401141906044,{"$f":"AI$32*AI12","v":3.2561755502802243},3.3370415512913709,3.3726142699861628,3.3538382943665792,3.3629452366179118,3.3084014813861584,3.2800059692945225,3.2526454614177873,3.2296155888626572,3.2013361346467737,3.1738106888529845,3.1801775540481922,3.1662460713343217,3.1378095508475079,3.0833786587714265,3.0445239561455066,3.1511342974338312,3.1338683479709197,3.0458971362625755,2.9937297243780967,3.0096795423074814,2.9295947951556673,2.8834030593512865,3.1405923233565094,3.2474539061749881,3.3233229371299546,3.3691753803917983,3.3357248859479176,3.3877215724832901,3.3540569896504424,3.3081867766038879,3.3878940641063902,{"$f":"BO$32*BO12","v":3.610427139133586},3.4440251554521462,3.3788543483662954,3.3596525640173374,3.5478641247916944,3.6829888254471035,3.5752534844347204,3.3657610800000004,3.3419231419200006,{"$f":"BX$32*BX12","v":3.3825552117500002},3.4835285745000006,3.4711545422700008,3.5089060555200007,3.4358586515099998,3.3650720119500002,3.3543449251200004,3.4780842095999995,3.6340516212000002,3.6325213564500003,3.6683057988500005,3.6686880999999998]
[13,"MATO GROSSO DO SUL",{"$f":"C$32*C13","v":2.9317215278939508},3.0010795607110285,3.0517754301735542,3.0639728007500735,3.0291986807617945,3.0083676332519129,3.0019431993975703,3.0065493872408431,2.9897376406620975,2.9752044375688302,2.9637850201527978,3.0778000522739473,3.1208226103669787,3.1184237715504115,3.0970540982723325,3.0622580265277799,3.0314466634104815,3.0188637382418424,3.0042509787479665,3.012998627616374,2.9925913721477539,2.9858866527711987,3.0627662999592804,3.1081953632971877,3.103044712394802,3.1970017042249825,3.3368087000441875,3.3018340231539294,3.286993734609553,3.2640451520555231,3.1244978599453379,3.0639521827428466,{"$f":"AI$32*AI13","v":3.0595807140919393},3.1192556816281445,3.1519542454347262,3.1135392873310583,3.2240087927075205,3.297156065066015,3.2421125941820472,3.2448772873372946,3.2196884917657433,3.1925803435092783,3.1803546284176298,3.1563072346387551,3.1586842417541985,3.1324125615959644,3.1092170274203492,3.0961078424480069,3.2197070941137924,3.2235294314959733,3.1554770891214812,3.0754444314951166,3.0457109171097541,2.9919265993079152,2.9299949560135916,3.141648694807353,3.2063335482721231,3.232792125412129,3.35974085070184,3.4172625045953442,3.4470457290521219,3.4246250203732855,3.4033566275881149,3.442670874782912,{"$f":"BO$32*BO13","v":3.5537080609695342},3.2611929223264426,3.129320223569505,3.1544134817135401,3.3424401609204129,3.3828710595233309,3.2694620338591207,3.0522931824000001,3.0930672432000001,{"$f":"BX$32*BX13","v":3.1650112780000006},3.2464297710000003,3.2314867786900008,3.2956078278300005,3.2013906070499996,3.1123154852700003,3.1171791294000006,3.2169277139999997,3.3613971391000006,3.3905565977500003,3.4240223787000001,3.4291862000000002]
[14,"MINAS GERAIS",{"$f":"C$32*C14","v":2.7925215716276681},2.8461669602050628,2.9061861435964671,2.9329980652928174,2.9183405405692313,2.8965375376606306,2.8945342225383905,2.8826531212831155,2.8826179640559224,2.8739325293903146,2.8508400446373332,2.9559873852974059,3.0068260818404666,3.0063845941294387,2.9831333743837862,2.9533135703761269,2.9310503653104356,2.9098420039287234,2.9072979566283035,2.9108849890141886,2.9010472155676199,2.8846049672542708,2.9248843656551524,2.9748236783171285,2.970705275026218,3.0463641628654723,3.0846723994510956,3.0517686522827123,3.0302538499480804,3.0127806792066738,3.0010374581845798,3.0155801998809069,{"$f":"AI$32*AI14","v":3.0407452806846784},3.1110594392214637,3.1124677147255224,3.1031914832003418,3.0896276420400932,3.0598777807109916,3.0359280531288753,3.0207099781573583,2.9902622477481771,2.9649297739343967,2.9502260870609356,2.9306242147677133,2.9275083088761553,2.9089772065820547,2.8605227291744697,2.8446363967233164,2.9561304068751926,2.938535273148482,2.8278011135822307,2.7857286517165911,2.8316421609315463,2.7605593940648245,2.7256259547448445,2.9493890907539098,3.0323628032984629,3.1117334818359663,3.1741951001326587,3.1778764190791819,3.2440946671061184,3.2108453978893774,3.2078446511096486,3.3145138082944454,{"$f":"BO$32*BO14","v":3.5124578223047687},3.264274364457775,3.1972827697539969,3.1908105603486963,3.383929729978159,3.4694822268704595,3.3486670325328003,3.1196084040000001,3.1434429312000005,{"$f":"BX$32*BX14","v":3.2236975485000001},3.3102640642500001,3.2979492677500004,3.3747184381000008,3.3005886258599997,3.1995766671000001,3.1992364933200004,3.3039798791999999,3.4579832287000003,3.4647726792000002,3.4959896933499999,3.5233835999999998]
[15,"PARA",{"$f":"C$32*C15","v":2.8820072577988496},2.9531974841910031,2.9817805808576465,2.9859452987755377,2.9709981571606994,2.9531428946883165,2.9427305583085355,2.9473545046165954,2.9402977899207858,2.9231999441798626,2.9311262320519402,3.0466701484910534,3.0698594564374795,3.1090871734319969,3.0891061407917362,3.0570076912915556,3.0327505114377549,3.0032892047685396,3.0107145135559445,3.02204667154315,3.0299826473706255,3.0269121456388151,3.0602129308054997,3.1005741241554694,3.086659829672977,3.246799238558705,3.2347242466333257,3.1683039707469689,3.1700746322050328,3.1216619507745085,3.1387432909177333,3.1359202548057317,{"$f":"AI$32*AI15","v":3.1820110312391345},3.2421993177283528,3.2239590955515105,3.2354134248706048,3.2376746724364116,3.2004454847127826,3.183043509447895,3.1727442423041468,3.1490958012987997,3.1258174360858755,3.1192778591476067,3.1042265377454381,3.0981896051132152,3.0708868841283663,3.0252423293113511,3.0488226133373817,3.1147049991976026,3.0089832673467378,2.8873785636802762,2.8377289198819673,2.8772112525932436,2.7964794167966285,2.6853874985364903,2.8564284030797182,2.9395784059791774,3.0833110176919978,3.1972572838192233,3.2081916875506611,3.3086226970581807,3.2201852843085774,3.2295682040517004,3.3186479072134283,{"$f":"BO$32*BO15","v":3.5124578223047687},3.3228217649530842,3.2622022168556009,3.2292296989080276,3.4497058760453183,3.5460223282469925,3.5221159536789606,3.2723235336000003,3.2502393897600004,{"$f":"BX$32*BX15","v":3.3198216122500006},3.3984161835000002,3.4036850458000005,3.4267912448600009,3.4218306488499999,3.36206300568,3.4113848000400004,3.5231111915999995,3.6632286691000004,3.6640377746000006,3.7220278788000005,3.6907342999999999]
[16,"PARAIBA",{"$f":"C$32*C16","v":2.7101379240415007},2.7588525853744277,2.8207924274310603,2.8466104738210101,2.8476684761964726,2.8261259959920455,2.8215511998007434,2.8165751127723277,2.7933515668841089,2.7890830928083141,2.7787185542479396,2.8653046221037584,2.9089231808706391,2.90368201482688,2.8798099271360353,2.8548697846969224,2.833261763264936,2.8462459922460708,2.8400771946253371,2.8333303267846812,2.8365794996661173,2.8256308212570724,2.8712636134257696,2.9417983087030182,2.9341543828006085,3.0065261353984942,3.0440846047214758,3.0238487322339846,3.0109682248091914,2.9840647394525202,2.9772950732305881,2.9636688036388259,{"$f":"AI$32*AI16","v":2.9724668345833574},3.0255843398375095,3.0706584469157763,3.0560514866048569,3.0771005856219431,3.0688741137671061,3.0493021855215132,3.0306976305465634,3.0090134311534595,2.9714966172875181,2.9447728040903982,2.9360492873607669,2.9177859565588546,2.8938656366777327,2.8368375579129568,2.8048738176984722,2.8789860106102365,2.8670198850987365,2.7490737688098132,2.7262997738133037,2.777595098728137,2.7045664174534831,2.6737395243709137,2.8110044306934654,2.8963493117736014,2.9738318965448598,3.0127598143267047,3.0398896798296908,3.1223240299385164,3.1330130110627121,3.1168126197334316,3.1770550192382681,{"$f":"BO$32*BO16","v":3.3701444989113281},3.2252427641275689,3.12729149084758,3.1250936128129974,3.3181535839110001,3.450347201526327,3.3987967785288005,3.2220882936000002,3.1222851422400009,{"$f":"BX$32*BX16","v":3.1569166200000005},3.2140060030000006,3.2475988972500005,3.3436750340700003,3.2775426214899999,3.1775106211200002,3.1722176052000006,3.2719606919999999,3.4177390246999999,3.4444395062000002,3.4615264722500001,3.4572450000000003]
[17,"PARANA",{"$f":"C$32*C17","v":2.6774685465504344},2.7335032507461787,2.8039936635952429,2.8201368570796497,2.7950108596050045,2.7847074420693478,2.7829941311846276,2.7697698567438533,2.7741249582624881,2.7576066889149922,2.7338127206092611,2.8747789406463782,2.9075820452409156,2.8876764180524557,2.8586153738544455,2.8351810275610823,2.8176155869376558,2.8047139029839303,2.7857835022383255,2.7919678402622772,2.7824266183088548,2.7705028152162128,2.8074293845812659,2.8566944716205045,2.8497092180035124,2.943034279122998,2.9801280796929843,2.9328055146837841,2.9145400991147414,2.8907379352515186,2.8870740104054184,2.8834421003556092,{"$f":"AI$32*AI17","v":2.880644096722961},2.9717233183078942,2.9731034886930359,2.9491241772541228,2.9370253184008113,2.9148119101811427,2.8843545526789751,2.875334148936707,2.840252780505923,2.8160813245969742,2.8051687600446309,2.7711270805319286,2.7492651830589723,2.7319559591314215,2.6656583656138451,2.6651674589625327,2.7761268155902954,2.7357304413656225,2.60438567571456,2.5405845303655314,2.5486898941019338,2.4510133158172187,2.3867757972008077,2.678957999338079,2.813054227816516,2.8675108269692737,2.9068834255838385,2.9123564814324343,2.9578816310284211,2.8984780854250265,2.8757846275668566,3.0230598345061592,{"$f":"BO$32*BO17","v":3.2133935919852199},2.9746188041125601,2.9142745550454419,2.899633931267446,3.0773116952343247,3.1955492324702379,3.0869897584336807,2.8875215952000004,2.8824968673600004,{"$f":"BX$32*BX17","v":2.9585974990000001},3.0437812210000001,3.0341133263300004,3.1153558044300009,3.04507857741,2.9578531634100003,2.9570671998000004,3.0518287799999997,3.2134996894000003,3.2207746032000006,3.2476517766000002,3.2538187000000001]
[18,"PERNAMBUCO",{"$f":"C$32*C18","v":2.704456293173489},2.7433613253238311,2.8235922214036964,2.8354636878246477,2.8282683016627734,2.8192229036715952,2.8091578563169923,2.8096919868857877,2.7906049085095921,2.7726606212117981,2.7528636803347615,2.8666580961812751,2.9089231808706391,2.9250228105261131,2.9049784591579235,2.8627452875512591,2.8449963955103956,2.826777825404442,2.8232720041245956,2.8320377490808557,2.8223966021677867,2.8128103547359422,2.8763703517333301,2.9202047978014849,2.9152487488908112,2.9965666285317498,3.0330152061588525,2.9983566313199286,2.9856558418143977,2.9768857545139813,2.9642367615058922,2.968388021479015,{"$f":"AI$32*AI18","v":3.0207326326894632},3.0513439588299338,3.111306346175251,3.0939934350841494,3.070267645757498,3.0677495721350918,3.0314700089979958,3.0118320649225092,3.0288676253472868,2.9747800389640791,2.9556793700314734,2.9230291131374377,2.8886188996069517,2.8690394861206316,2.8109991892640349,2.7790818745472219,2.8672000611808683,2.8360654634055633,2.7416265875475578,2.6615647460972229,2.7087115880767332,2.6137098893671551,2.5794968243039786,2.6810707422397648,2.8109454915138046,2.9201450198284746,2.9152696741971349,2.9928487459946376,3.1420987487947936,3.12574865495889,3.0423318667892536,3.161552148292083,{"$f":"BO$32*BO18","v":3.3866445943772341},3.2570843328180001,3.1972827697539969,3.2160863094008878,3.3819058485607085,3.5097664907528454,3.4439135499252007,3.3175352496000001,3.2361341971200006,{"$f":"BX$32*BX18","v":3.2742891610000004},3.335595133,3.3241314604100007,3.3897394400500005,3.3436746340300001,3.2567477862300001,3.2592784669200006,3.2529492995999996,3.4660320695000002,3.4800225589500005,3.5243711695500002,3.5173709999999998]
[19,"PIAUI",{"$f":"C$32*C19","v":2.8081460565146998},2.8574333311509514,2.9117857315417397,2.9399648065405435,2.9224977208264526,2.9034406299810804,2.8945342225383905,2.8895362471696564,2.8881112808049569,2.8753010686900238,2.8617263073376189,2.960047807529957,2.9987792680621252,2.9823761989678017,2.9659127998424943,2.9309996456221743,2.9141003409558817,2.9059483705603975,2.9047125427051124,2.9095924113103635,2.9049152785217101,2.8961433871232876,2.9542481109236243,3.0218213196910537,3.0009542892818937,3.0812224368990782,3.1264901273543395,3.0906137584374647,3.0531555298005126,3.0414966189608279,3.041399512606366,3.0273782444813797,{"$f":"AI$32*AI19","v":3.0737072891473849},3.1098885474490809,3.1682134051385167,3.2250656207398887,3.2103429129786298,3.2420535250973126,3.1395775791718212,3.109489110505848,3.0553398842723909,3.0448263680640428,3.0385692711836478,3.0228504488496295,3.0441765366837661,3.0352667550681773,3.0177061384554151,2.9187882332831614,3.0847044006501192,3.0217919935646029,2.8948257449425321,2.7507080629521541,2.8358811462024018,2.7679546928625491,2.6885642187634655,2.8669921175881492,3.001786126909153,3.0454143988333731,3.1238776084528808,3.1601053996303841,3.1951782573037479,3.1880145644202225,3.1706042746375598,3.2938433136995315,{"$f":"BO$32*BO19","v":3.5299891737372939},3.4224550605328212,3.2358286914705738,3.2221524891734137,3.4274431804533569,3.6004060844882133,3.4459187397650406,3.2431870944000005,3.2129613806400004,{"$f":"BX$32*BX19","v":3.2398868645000003},3.2829065100000006,3.2445778750200005,3.3647044368000003,3.2815506222499997,3.20760068382,3.2322595788000004,3.3660170543999994,3.5183495347,3.5532219817500006,3.5709978804500002,3.5815053999999997]
[20,"RIO DE JANEIRO",{"$f":"C$32*C20","v":2.6717869156824232},2.7236451761685263,2.7675963419509708,2.7950565885878342,2.783925045585748,2.7709012574284491,2.7540763297225412,2.75049710426154,2.7370450702065043,2.7274988243213794,2.7188441093963682,2.8125191330805901,2.8525954844222445,2.8516638253099997,2.8374208205728553,2.8089293513799611,2.7902347783649164,2.7735648360373246,2.765100190852797,2.7674088638895995,2.7643756578564345,2.7602464419993087,2.8087060691581565,2.8732071564275596,2.8660941007253369,2.9405444024063119,2.9924274114292322,2.9461585199244804,2.921772208541825,2.9003099151695699,2.8870740104054184,2.8846219048156563,{"$f":"AI$32*AI20","v":2.9159605343615747},2.9822613442593409,3.017235493603323,2.9997134418931797,2.9825782508304477,2.9609181170937302,2.9389655932822478,3.0007346733789486,2.9979833232679991,2.97806346064064,2.9589513398137961,2.9349642728421563,2.9231872634017995,2.9165329915342162,2.8519099396248286,2.8328150894456603,2.9304156081202071,2.9139852145642409,2.8405677100318116,2.799524641229854,2.8475383556972544,2.7838017617148152,2.7277437682294949,2.9493890907539098,3.0344715396011743,3.1043646948356782,3.1532294785994179,3.1810124813348524,3.2222383988965486,3.1932033902086667,3.1602597256175353,3.2876421653210577,{"$f":"BO$32*BO20","v":3.4578012560739548},3.2149712903564618,3.0664295091898262,3.0482553356943343,3.2027923431162901,3.2751106536379493,3.2143193132635206,3.0332037912000005,2.9963459222400006,{"$f":"BX$32*BX20","v":3.0668635497500003},3.1582776517500002,3.1479051636600004,3.2074846163900004,3.1452785964099998,3.0631683828599998,3.0611399540400006,3.1508881403999998,3.3120979892000002,3.3305737374,3.3469869433000001,3.3680581000000003]
[21,"RIO GRANDE DO NORTE",{"$f":"C$32*C21","v":2.7058767008904923},2.7335032507461787,2.7759957238688799,2.7699763200960192,2.7548247837852005,2.7432888881466506,2.7650926350414315,2.7876659840488585,2.7603916663899013,2.7712920819120885,2.7950479482983681,2.8179330293906588,2.8780770613869944,2.8970130161708703,2.8837839058763337,2.8430565304154181,2.8671618119740421,2.9007568594026298,2.9085906635898988,2.9134701444218392,2.9074939871577699,2.8820408739500447,2.9274377348089331,2.9583109935100738,2.9555807678983799,3.0314249025653557,3.064993468673098,3.0262765513686563,3.0471287719446094,3.0127806792066738,2.9986632196891803,3.0037821552804336,{"$f":"AI$32*AI21","v":3.0136693451617407},3.0724200107328268,3.0694970783655053,3.11123977530201,3.1158205781871344,3.0857422382473212,3.0593327848159921,3.0861845882643695,3.0961512834485925,3.0185589946515563,3.049475837124723,3.0174253762565755,2.978280593199838,2.9920908410558278,2.988637973725377,2.9886414126511309,3.02148885371078,3.0004441165348279,2.951211545928182,2.8897291880473439,2.854956579921252,2.808100600621624,2.7796301986034253,2.8342446026120132,2.9553939282495101,3.0369929279759007,3.0504979330865378,3.1130644657953304,3.1660365663576551,3.1828257386317782,3.2171547452276705,3.2752398685641091,{"$f":"BO$32*BO21","v":3.3876758503438533},3.2673558065891073,3.1506219171497185,3.1261046427750849,3.3029744732801172,3.4392690289586705,3.4619602584837605,3.2783517624000003,3.2109463531200002,{"$f":"BX$32*BX21","v":3.2014372390000005},3.2677078687500005,3.3049983196200006,3.3707128375800006,3.3416706336499997,3.2768078280299999,3.2632812651600007,3.3159870743999997,3.4318244961000004,3.4749392657000007,3.5061259348500005,3.5063479000000002]
[22,"RIO GRANDE DO SUL",{"$f":"C$32*C22","v":2.7101379240415007},2.7757521417932605,2.8109931485268334,2.8187435088301043,2.8005537666146325,2.7860880605334377,2.7706007877008765,2.7560036049707723,2.7521516912663495,2.7370785994193469,2.7256480235840468,2.8274073479332786,2.8418663993844557,2.8396596277291812,2.8149016077111662,2.7826776751988396,2.7576385776830832,2.7229476022490906,2.715977326312168,2.7118280226251188,2.7076440678631122,2.68845182948098,2.7308283099678614,2.7919139389159042,2.7766074335522939,2.87456266941413,2.9149416214908679,2.8721100363169842,2.8506564658421687,2.8201445833558902,2.8217824517819405,2.8232720728931961,{"$f":"AI$32*AI22","v":2.8041251485059635},2.8874191106963232,2.9010986385762516,2.8651919881938688,2.8789453295530247,2.8563357453163976,2.8252854679448234,2.8154082346014762,2.7884112734442614,2.7690189472329361,2.7593611830921132,2.7364066159363838,2.7125362965269471,2.699574023622159,2.6516625825956788,2.6393755158112824,2.7246972180803244,2.7165173520388253,2.6522604124004894,2.6138093977820818,2.6228721363419072,2.5344745451058226,2.4672527096175165,2.678957999338079,2.7750969743677172,2.9022493942563465,2.9268007660404169,2.9667148938640522,3.030735858393653,2.9431019872056479,2.9575065648250516,3.044763853830819,{"$f":"BO$32*BO22","v":3.2618626224163187},3.0896593103489578,2.9822371012299334,2.9693949986514956,3.1289206713793267,3.2589969480849952,3.1671973520272805,2.9457944735999999,2.9107072526400004,{"$f":"BX$32*BX22","v":2.9828814730000004},3.0701255325000001,3.0633165412200003,3.1574146098900004,3.1092065895700003,3.0029882574600006,2.9970951822000007,3.0348185867999997,3.1994142180000003,3.25635765595,3.2760332528000005,3.3019194999999999]
[23,"RONDONIA",{"$f":"C$32*C23","v":2.9160970430069186},2.9658721515051272,3.0209776964745547,3.0570060595023474,3.0541417623051217,3.0332187656055316,3.054270649662298,3.0395883914962369,3.0419241497779264,3.0258403916580878,3.0032477224413334,3.0845674226615327,3.1020467115508477,3.0930815766575726,3.132819906935016,3.1541388931617038,3.1318429615105274,3.1175024502394266,3.090862345174866,3.0944310229573571,3.0854248830459174,3.0781940117233346,3.0729797765744009,3.1145463959152853,3.1698446188760872,3.1857972589998953,3.2716222418420711,3.2120047151710649,3.1929763120574646,3.206613272547215,3.1838538223303177,3.186651846587766,{"$f":"AI$32*AI23","v":3.2173274688777491},3.2293195082321406,3.2727365746628809,3.2883022015387096,3.2718393717586394,3.2308081087771696,3.2075627521677323,3.2071461560891867,3.1888041896864556,3.1805411306952225,3.157450839941371,3.1324369152293179,3.1025106505875715,3.1183803895419504,3.0812254613840167,3.0649425778069128,3.1618487969150757,3.106116107832213,2.9916391013518555,2.9098925573359593,2.8856892231349547,2.7954229455398107,2.747862996333672,2.9324871475404204,3.0861355790175944,3.1359452105511991,3.1909675973592515,3.2040102712097673,3.3211119931779347,3.2917910801891099,3.2843943138578311,3.344486025457071,{"$f":"BO$32*BO23","v":3.5578330848360107},3.3495275967579623,3.2632165832165634,3.2636047176190086,3.4173237733661015,3.586306592129378,3.4870251314817606,3.3155258399999998,3.3268104355200006,{"$f":"BX$32*BX23","v":3.4007681922500006},3.4136148247500007,3.4137551199000007,3.4888780529200005,3.4108086467599996,3.3289639367100001,3.3103141444800004,3.4130452355999998,3.5505448979000001,3.5888050345,3.6115428464500003,3.6025495000000003]
[24,"RORAIMA",{"$f":"C$32*C24","v":2.8933705195348725},2.947564298718059,3.0153781085292821,3.0361058357591677,2.9890126049419905,2.9904195932187445,2.9757794742652059,2.9597441312123682,2.9677643736659589,2.946465112274927,2.9474556261023692,3.0683257337313274,3.1208226103669787,3.1090871734319969,3.1288459281947176,3.0819467836636205,3.057523623955948,3.0461191718201222,2.9990801509015848,3.0194615161354994,3.0106423326001743,3.0115275858134587,3.0563828770748303,3.1094655698208071,3.086659829672977,3.1957567658666397,3.2285745807652013,3.2095768960363933,3.1869495542015618,3.1719148453442778,3.1553629603855273,3.1536173217064416,{"$f":"AI$32*AI24","v":3.1360996623089368},3.2047307810120991,3.2541546778585495,3.2503602530594171,3.2479240822330797,3.2128154426649402,3.1763564432515765,3.1882805904651326,3.1347566610477022,3.0951721671046415,3.0974647272654554,3.1053115522640486,3.0884672527959145,3.0924748411345409,3.0058635528246587,3.0380759703576938,3.1018475998201098,3.0036462980892944,2.8767397333056253,2.7390345333640083,2.7468624555144339,2.6549122683830477,2.5667899433960772,2.7381148005852922,2.8742075805951357,2.9654104256873879,3.0515462141632002,3.0628874697046062,3.1878928345672253,3.1724480870548892,3.0826756079673503,3.1326134558592034,{"$f":"BO$32*BO24","v":3.3711757548779473},3.2046998165853551,3.1120759954331416,3.1190274330404715,3.3090461175324704,3.4533685213175054,3.3496696274527209,3.1527636623999999,3.0870221606400006,{"$f":"BX$32*BX24","v":3.0820410334999999},3.1825954777500001,3.1952345119300007,3.2525476222400007,3.2645166190199997,3.17249561067,3.1612099100400002,3.2459451023999999,3.4720687001000003,3.5003557319500005,3.5172758005000002,3.5193751999999998]
[25,"SANTA CATARINA",{"$f":"C$32*C25","v":2.7342848552305501},2.7743438454250242,2.8487903671574233,2.8521838668191912,2.8393541156820299,2.820603522135686,2.800895627327824,2.7917958595807826,2.8098315171312129,2.7986628679062822,2.7936871654608328,2.9126762148168579,2.9437927072434542,2.9143524126764966,2.9169003953788177,2.8614327037422034,2.8410848514285756,2.818990558667791,2.800003278815876,2.8023084618928782,2.7953201614891556,2.7589643953471961,2.8214729149270568,2.8820986020928969,2.8522299691914852,2.9778925531566038,2.97151854747761,2.9328055146837841,2.9157454506859217,2.8955239252105445,2.8858868911577189,2.8917007315759404,{"$f":"AI$32*AI25","v":2.9230238218892977},2.9682106429907456,3.0230423363546772,3.002012953922228,2.9871335440734113,2.9350536595574006,2.8899271078425746,2.8975289320238296,2.8843732120477625,2.8511044891469557,2.8018967902623082,2.8047625306088628,2.8032782514884222,2.7783700666946971,2.7237946950739209,2.7543645956939407,2.802913064293405,2.8211219494847208,2.6533242954379546,2.6742995056479275,2.6377085847899018,2.5746204528648975,2.4916075646909945,2.7011417998057836,2.7772057106704282,2.8569839883974333,2.9383318578836994,2.9573067070970414,3.0172057875972529,2.9358376311018262,2.8861291765868815,3.0488979527498019,{"$f":"BO$32*BO25","v":3.2350499672842217},3.0721978049380758,2.9568779422058693,2.9542295492201807,3.1370161970491308,3.2438903491291007,3.1942674148651204,3.0171285144000004,2.9066771976000001,{"$f":"BX$32*BX25","v":2.9929997955000003},3.0488474347500003,3.0623095338100006,3.1373866072900007,3.0751385831099998,2.9578531634100003,2.9350518094800004,2.9597736168000002,3.0937731825000006,3.2146746513000002,3.2283929177500004,3.2658438999999997]
[26,"SAO PAULO",{"$f":"C$32*C26","v":2.649060392210377},2.7292783616414704,2.7801954148278343,2.7950565885878342,2.7756106850713063,2.7612369281798195,2.7513222533928188,2.7394841028430754,2.7315517534574698,2.7179190492234113,2.701153932508404,2.8192865034681764,2.8525954844222445,2.8356582285355749,2.8175509268713648,2.7931783456712882,2.7706770579558162,2.7553945469851384,2.7457095864288648,2.7467276206283975,2.7372992171778034,2.7230670890880315,2.7844490621972451,2.8236691020063946,2.8181998281538494,2.9069310667310493,2.9432300844842385,2.9012438659330484,2.8892277161199478,2.8715939754154158,2.871641460185324,2.8657450334548993,{"$f":"AI$32*AI26","v":2.8865301696627297},2.9483054828602353,2.9823944370952016,2.9732690535591271,2.96094060792637,2.9283064097653146,2.901072218169773,2.8853218013259121,2.8590039639112046,2.8292150113032171,2.8128033562033838,2.7928273709041442,2.78383354685382,2.7708142817425365,2.7076457146683444,2.7113780237751901,2.8114846638783999,2.7933697093460141,2.7011990321238839,2.6562585962844296,2.6928153933110246,2.6232181306785152,2.5720844771077025,2.8025534590867207,2.8868599984114018,2.9759372642592279,3.0316288737066213,3.0085290572729888,3.0348989571002378,2.9991413057208471,2.9657822040410715,3.096440090318104,{"$f":"BO$32*BO26","v":3.2907377894816547},3.0465191205103088,2.9761509030641582,2.9875935379690741,3.1744580032719756,3.2710822272497109,3.1712077317069602,2.9146486247999999,2.9147373076800003,{"$f":"BX$32*BX26","v":3.0152601050000003},3.1055890287500003,3.0995688079800003,3.1914622143100004,3.1142165905199999,3.0320753180700004,3.0201112720800003,3.1288749491999996,3.2829209413,3.2980406606000008,3.3115100980500003,3.3119405]
[27,"SERGIPE",{"$f":"C$32*C27","v":2.7882603484766597},2.872924591201548,2.9397836712681027,2.9497182442873608,2.9363549883505233,2.9172468146219792,2.8931571843735298,2.8936661227015801,2.8592713678725246,2.8383505075978626,2.8304283020742975,2.9505734889873376,2.9706154198379275,2.9557002043437608,2.9089524378982219,2.9021228018229404,2.8658579639467687,2.8397566032988615,2.8439553155101236,2.8204045497464296,2.8211072478497567,2.7999898882148124,2.8776470363102198,2.8986112868999516,2.9064261197329055,3.0364046559987279,3.0834424662774707,3.0347739183400084,3.0350752562328029,3.0235491566144819,3.0010374581845798,3.0073215686605757,{"$f":"AI$32*AI27","v":2.9913022679906183},3.0911542790909539,3.1217586631276881,3.1066407512439138,3.118098224808616,3.0756213635591916,3.0236684317689568,3.0373560654727005,2.9670990211887114,2.9452292438750316,2.9120531062671713,2.8948187356535575,2.8832175927640069,2.8927862388274241,2.8572929330933543,2.8532337111070665,2.9625591065639392,2.881963399019579,2.777798610821371,2.7485856030270366,2.768057381868712,2.7193570150489315,2.6885642187634655,2.9176979472286173,3.0060035995145751,3.0264660894040607,3.107105111226288,3.1057469871987662,3.2149529761600255,3.1714103218972003,3.1623286354215399,3.2948768384292775,{"$f":"BO$32*BO27","v":3.5165828461712452},3.2786544277373251,3.2632165832165634,3.2181083693250629,3.3859536113956104,3.4815675060351752,3.3757370953706407,3.2411776848000002,3.1565406100800004,{"$f":"BX$32*BX27","v":3.1882834197500003},3.2484562565000004,3.3130543789000004,3.3937450405700003,3.3356586325099999,3.2296667298000004,3.1762204034400003,3.2479463015999999,3.5203617449000002,3.5176389290000003,3.5628888872500002,3.5073499999999997]
[28,"TOCANTINS",{"$f":"C$32*C28","v":2.6959338468714718},2.737728139850887,2.7283992263340631,2.757436185850112,2.7714535048140849,2.7350051773621114,2.7444370625685126,2.6816658453961364,2.7219384491466592,2.6932853418286373,2.6616912302198679,2.8043982886154879,2.8485720775330741,2.8730046210092328,2.8400701397330543,2.8168048542342969,2.8006655625831027,2.8099054141416979,2.7844907952767297,2.808771350412004,2.8185285392136965,2.7999898882148124,2.8674335596950993,2.9443387217502579,2.9165091244847976,2.9990565052484355,3.0403948052006013,3.0287043705033287,3.0398966625175254,3.049872101389123,2.9951018619460821,2.9990629374402444,3.0301503493930939,3.104034088587166,3.1147904518260634,3.0721480708081934,3.0793782322434251,3.0520059892868909,3.0370425641615948,3.0362463263183441,3.0178375174618273,2.9879137256703223,2.9720392189430869,2.9219440986188272,2.8821373313954179,2.9003420237795847,2.8002332023269836,2.7468419456081592,2.8950577598321021,2.8157849802272774,2.6724741901123261,2.6583810562095467,2.6090954342116266,2.5788463378921684,2.5149035130221469,2.7402275434869781,2.8636638990815806,2.9317245422574989,2.99493903602345,3.007483703187765,3.1473026221780245,3.1527305490588002,3.0361251373772391,3.1439822278864056,{"$f":"BO$32*BO28","v":3.3732382668111853},3.1615596267467057,3.0999035991015909,3.0694869648981755,3.3141058210760979,3.4251695365998356,3.2804905779782403,3.0995143080000003,2.9782106745600005,{"$f":"BX$32*BX28","v":3.0830528657500005},3.1603041372500003,3.1670383044500006,3.2285140191200008,3.17032860116,3.11532449154,3.1381938201600006,3.2369397059999998,3.3764887156000003,3.4037731602000001,3.4088180164500002,3.3931106]
[null,"Média do mês no Brasil",{"$f":"AVERAGE(C35:C61)","v":2.7953623870616742},{"$f":"AVERAGE(D35:D61)","v":2.8537300332937381},2.904734398573618,2.9212836188984928,2.9075113426152361,2.8918332080792872,2.8845889469032815,2.8801548015168907,2.8728520676131941,2.8613115558485473,2.8500840541720351,2.9548344258980395,2.9921232616034961,2.9896379975043459,2.9744985563801754,2.9494730473792594,2.9311952373134655,2.9192155657413594,2.9076331028776061,2.912033946973144,2.9079715257940784,2.8924396967949608,2.9394480267544907,2.9914774971823639,2.9851762540682847,3.0717240183132013,3.1131430747664854,3.0753274898117522,3.0628429850207417,3.0460610353106397,3.0319904933838586,3.0294756746325753,3.0433177125620596,3.1072431993707341,3.1446849385830324,3.1319779671195365,3.1360663259336405,3.1213943729511819,3.0941302959486894,3.0884451680232434,3.0645316408436081,3.0348139587540364,3.0213207391212795,3.0031594446229897,2.9903635166559068,2.9815367287416983,2.9332529520381034,2.9217336095072235,3.0162506539643941,2.979689236089214,2.8772913763620891,2.8201989730930346,2.8357633966115441,2.7670156073009333,2.7134681365922235,2.9039651183676569,3.00510543405231,3.0736419215223085,3.1261294715064509,3.1514715492227987,3.2220456628453178,3.1980078585313008,3.1704510220594861,3.2704167531586288,3.4574956987505114,{"$f":"AVERAGE(BP35:BP61)","v":3.2810891474460315},3.1785357766384288,3.1646361179968712,3.3449512730494728,3.4555319354889669,3.380527271099147,3.2005429573333335,3.1630707918577787,{"$f":"AVERAGE(BX35:BX61)","v":3.2251590839722231},3.3020080122129634,3.29992598599926,3.3744588158440751,3.316509295545556,3.2393252684444436,3.2262553814400006,3.3102428915111108,3.4672617535111119,3.4951594766277774,3.5197535484222224,3.5148471925925917]
[]
[null,null,{"$f":"C33","v":"2013-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"O33","v":"2014-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA33","v":"2015-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM33","v":"2016-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY33","v":"2017-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK33","v":"2018-01-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BW33","v":"2019-01-01"},null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
[{"$f":"Formulário!AC12","v":2},{"$f":"VLOOKUP($A$65,$A$34:$BW$61,2,0)","v":"ACRE"},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,C66,0)","v":3.2470520410685908},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,D66,0)","v":3.2672475743076426},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,E66,0)","v":3.2659596690802304},3.3384624059104939,3.3382157465485651,3.2955362737826146,3.2842360231941301,3.3107835514259278,3.2973633786080363,3.3050224087988616,3.3216709064246919,3.397219934567989,3.4494008396492779,3.4305329086516934,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,Q66,0)","v":3.4070244400155856},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,R66,0)","v":3.4153430711638588},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,S66,0)","v":3.3574086702288128},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,T66,0)","v":3.338141674444548},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,U66,0)","v":3.313207942569294},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,V66,0)","v":3.3206321211267547},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,W66,0)","v":3.3020364084749665},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,X66,0)","v":3.2679369162360601},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,Y66,0)","v":3.3398068531444256},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,Z66,0)","v":3.4168555485367529},3.4156178597034579,3.4771128348521718,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AC66,0)","v":3.5065394780044152},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AD66,0)","v":3.4705674530136337},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AE66,0)","v":3.4581536577172014},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AF66,0)","v":3.4339477956009352},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AG66,0)","v":3.4189034333748376},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AH66,0)","v":3.440309805497936},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AI66,0)","v":3.4115678758901269},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AJ66,0)","v":3.4752067804325573},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AK66,0)","v":3.5804992404846212},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AL66,0)","v":3.5550455969082835},3.5349075565397898,3.4827054343483792,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AO66,0)","v":3.4326939807771422},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AP66,0)","v":3.4046797255645758},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AQ66,0)","v":3.3895521532018256},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AR66,0)","v":3.355656953445131},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AS66,0)","v":3.341771804345548},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AT66,0)","v":3.3082092672442642},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AU66,0)","v":3.309920833356657},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AV66,0)","v":3.3180689918490676},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AW66,0)","v":3.2793196210257558},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,AX66,0)","v":3.2401128583758214},3.3504239877849677,3.2993143949516734,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BA66,0)","v":3.1927129954327591},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BB66,0)","v":3.1327508494732865},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BC66,0)","v":3.1368491004331496},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BD66,0)","v":3.0764442998533368},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BE66,0)","v":3.0538870448656299},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BF66,0)","v":3.2779206119661115},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BG66,0)","v":3.3476188805537621},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BH66,0)","v":3.4222752197052526},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BI66,0)","v":3.4781966123646506},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BJ66,0)","v":3.5312060998846961},3.6437521429382485,3.5834030894996833,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BM66,0)","v":3.5357668550444306},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BN66,0)","v":3.7599629668148404},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BO66,0)","v":3.9301164887855173},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BP66,0)","v":3.8158525059662156},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BQ66,0)","v":3.6912791875427642},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BR66,0)","v":3.6629615526436394},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BS66,0)","v":3.7543000293717017},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BT66,0)","v":3.891459891038449},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BU66,0)","v":3.9512265794047203},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BV66,0)","v":3.8831840520000003},3.8396349393600007,3.8459743822500005,{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BY66,0)","v":3.9769777937500002},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,BZ66,0)","v":3.9112167804400007},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CA66,0)","v":3.9405095115500006},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CB66,0)","v":3.9448747480299997},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CC66,0)","v":3.9207351698099999},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CD66,0)","v":3.8546947051200005},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CE66,0)","v":3.9173474339999999},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CF66,0)","v":3.9650601991000003},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CG66,0)","v":3.9893685426000003},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CH66,0)","v":4.0017881441999998},{"$f":"VLOOKUP($A$65,$A$34:$CI$61,CI66,0)","v":3.9963747999999999}]
["Linha auxiliar de dados do PROCV",null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87]

{"sheet":"PreçoDiesel","index":7,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Chave","UF","SIGLA","Preço Médio Janeiro de 2020"]
[1,"Escolha o Estado","UF",{"$f":"SeriePreçoDiesel!CI34","v":3.5148471925925917}]
[2,"ACRE","AC",{"$f":"SeriePreçoDiesel!CI35","v":3.9963747999999999}]
[3,"ALAGOAS","AL",{"$f":"SeriePreçoDiesel!CI36","v":3.5514424}]
[4,"AMAPA","AP",{"$f":"SeriePreçoDiesel!CI37","v":3.9723243999999998}]
[5,"AMAZONAS","AM",{"$f":"SeriePreçoDiesel!CI38","v":3.5384150999999999},"Voltar ao Formulário"]
[6,"BAHIA","BA",{"$f":"SeriePreçoDiesel!CI39","v":3.4321924999999998}]
[7,"CEARA","CE",{"$f":"SeriePreçoDiesel!CI40","v":3.5724865000000001}]
[8,"DISTRITO FEDERAL","DF",{"$f":"SeriePreçoDiesel!CI41","v":3.5865159000000002}]
[9,"ESPIRITO SANTO","ES",{"$f":"SeriePreçoDiesel!CI42","v":3.3931106}]
[10,"GOIAS","GO",{"$f":"SeriePreçoDiesel!CI43","v":3.5424234999999999}]
[11,"MARANHAO","MA",{"$f":"SeriePreçoDiesel!CI44","v":3.4171610000000001}]
[12,"MATO GROSSO","MT",{"$f":"SeriePreçoDiesel!CI45","v":3.6686880999999998}]
[13,"MATO GROSSO DO SUL","MS",{"$f":"SeriePreçoDiesel!CI46","v":3.4291862000000002}]
[14,"MINAS GERAIS","MG",{"$f":"SeriePreçoDiesel!CI47","v":3.5233835999999998}]
[15,"PARA","PA",{"$f":"SeriePreçoDiesel!CI48","v":3.6907342999999999}]
[16,"PARAIBA","PB",{"$f":"SeriePreçoDiesel!CI49","v":3.4572450000000003}]
[17,"PARANA","PR",{"$f":"SeriePreçoDiesel!CI50","v":3.2538187000000001}]
[18,"PERNAMBUCO","PE",{"$f":"SeriePreçoDiesel!CI51","v":3.5173709999999998}]
[19,"PIAUI","PI",{"$f":"SeriePreçoDiesel!CI52","v":3.5815053999999997}]
[20,"RIO DE JANEIRO","RJ",{"$f":"SeriePreçoDiesel!CI53","v":3.3680581000000003}]
[21,"RIO GRANDE DO NORTE","RN",{"$f":"SeriePreçoDiesel!CI54","v":3.5063479000000002}]
[22,"RIO GRANDE DO SUL","RS",{"$f":"SeriePreçoDiesel!CI55","v":3.3019194999999999}]
[23,"RONDONIA","RN",{"$f":"SeriePreçoDiesel!CI56","v":3.6025495000000003}]
[24,"RORAIMA","RR",{"$f":"SeriePreçoDiesel!CI57","v":3.5193751999999998}]
[25,"SANTA CATARINA","SC",{"$f":"SeriePreçoDiesel!CI58","v":3.2658438999999997}]
[26,"SAO PAULO","SP",{"$f":"SeriePreçoDiesel!CI59","v":3.3119405}]
[27,"SERGIPE","SE",{"$f":"SeriePreçoDiesel!CI60","v":3.5073499999999997}]
[28,"TOCANTINS","TO",{"$f":"SeriePreçoDiesel!CI61","v":3.3931106}]
[]
["Fonte:"]
["Série histórica mensal a partir de 2013 obtida em 19/09/2018"]
["http://www.anp.gov.br/precos-e-defesa/234-precos/levantamento-de-precos/868-serie-historica-do-levantamento-de-precos-e-de-margens-de-comercializacao-de-combustiveis"]