{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["TUTORIAL","SIMULADOR","Base de dados Indústria","Base de dados Irrigação","Base de Dados Saneamento","Receita e Custo. San.","Receita e Custo Ind.","Receita e Custo Irrig."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":10,"comments":0,"pivot_tables":3},"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":"TUTORIAL","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,16],[19,2,19,16],[20,2,20,16],[0,2,2,15],[6,2,6,15],[16,2,16,16],[17,2,17,16],[18,2,18,16],[8,2,8,16],[9,4,10,4],[9,5,10,5],[9,6,9,9],[15,2,15,16]]}
[null,null,"SIMULADOR DE APOIO À COBRANÇA - BACIA DO DOCE"]
[]
[]
[]
[]
[]
[null,null,"INSTRUÇÕES PARA O USO"]
[]
[null,null,"Este simulador é composto de um arquivo Excel com 08 planilhas, sendo 02 aparentes e 06 de suporte à simulação dos dados. Esta planiha faz uma breve apresentação do sistema. Na planilha SIMULADOR os dados serão fornecidos e poderão ser alterados para efeito de novas simulações. A Deliberação CBH-Doce nº 26, de 31 de março de 2011 dispôs sobre mecanismos e valores de cobrança pelo uso de recursos hídricos na bacia hidrográfica do rio Doce, sugerindo valores de cobrança pelo uso destes recursos e pela metodologia sugerida neste trabalho para o caso de lançamento, conforme discriminado abaixo:"]
[null,null,null,null,"Tipo de Uso","Unidade","Valor"]
[null,null,null,null,null,null,"2011/2012",2013,2014,2015]
[null,null,null,null,"Captação de Água Superficial","R$/m³",1.7999999999999999E-2,2.1000000000000001E-2,2.4E-2,0.03]
[null,null,null,null,"Lançamento de Carga Orgânica","R$/hab",1.5640000000000001,1.825,2.0859999999999999,2.6070000000000002]
[null,null,null,null,"Transposição de Água","R$/m³",2.1999999999999999E-2,2.7E-2,3.1E-2,0.04]
[]
[null,null,"Para o setor industrial, além da evolução dos preços públicos, foi adotado a proposta estabelecida neste trabalho, além de simulações considerando a metodologia proposta neste trabalho, criando-se diferentes cenários, assim definidos:"]
[null,null,"Cenário 1: Valor da arrecadação pela cobrança dos recursos hídricos para cada usuário outorgado no domínio da União (ANA) e estadual (IGAM e IEMA), atualmente praticada, ou seja com o valor de Kcap igual a unidade."]
[null,null,"Cenário 2: Valor da arrecadação pela cobrança dos recursos hídricos para cada usuário outorgado no domínio da União (ANA) e estadual (IGAM e IEMA), de acordo com a proposta que considera o consumo, sendo este função da tipologia de atividade econômica. Considerou-se o limite inferior do consumo apresentado na Matriz de Coeficientes Técnicos (MMA, 2011), ou seja, o menor valor do FPUA_seg proposto"]
[null,null,"Cenário 3: Valor da arrecadação pela cobrança dos recursos hídricos para cada usuário outorgado no domínio da União (ANA) e estadual (IGAM e IEMA), de acordo com a proposta que considera o consumo, sendo este função da tipologia de atividade econômica. Considerou-se o limite superior do consumo apresentado na Matriz de Coeficientes Técnicos (MMA, 2011), ou seja, o maior valor do FPUA_seg proposto."]
[null,null,"Cenário 4: Valor da arrecadação pela cobrança dos recursos hídricos para cada usuário outorgado no domínio da União (ANA) e estadual (IGAM e IEMA), de acordo com a proposta que considera as práticas de uso e conservação da água no setor industrial, ou seja, a captação de água de chuva e o reuso, juntamente com o consumo, sendo este função da tipologia de atividade econômica. Considerou-se o limite inferior do consumo apresentado na Matriz de Coeficientes Técnicos (MMA, 2011), ou seja, o menor valor do FPUA_seg proposto. Nesse caso o Kcap é a multiplicação do Kt e FPUA_seg."]
[null,null,"Cenário 5: Valor da arrecadação pela cobrança dos recursos hídricos para cada usuário outorgado no domínio da União (ANA) e estadual (IGAM e IEMA), de acordo com a proposta que considera as práticas de uso e conservação da água no setor industrial, ou seja, a captação de água de chuva e o reuso, juntamente com o consumo, sendo este função da tipologia de atividade econômica. Considerou-se o limite inferior do consumo apresentado na Matriz de Coeficientes Técnicos (MMA, 2011), ou seja, o maior valor do FPUA_seg proposto. Nesse caso o Kcap é a multiplicação do Kt e FPUA_seg."]
[null,null,"Obs: O fator de segurança refere-se ao nível de inadiplência previsto e deve ser informado em percentual."]

{"sheet":"SIMULADOR","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,1,6,6],[1,1,1,3],[24,10,24,11],[15,7,15,11],[24,7,24,8],[1,4,2,4],[19,10,19,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[15,1,16,1],[23,10,23,11],[20,10,20,11],[21,10,21,11],[21,7,21,8],[22,7,22,8],[12,0,14,12],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[15,2,15,4],[22,10,22,11],[36,1,37,1],[36,2,37,2],[36,3,37,3],[36,4,37,4],[27,1,28,1],[27,9,27,11],[23,7,23,8],[27,4,28,4],[27,2,27,3],[27,6,27,8]]}
[]
[null,"PREÇO PÚBLICO",null,null,"Fator de Segurança"]
[null,"Captação","Lançamento","Transposição"]
[null,2.1000000000000001E-2,1.825,2.7E-2,0]
[]
[]
[null,"Selecione o Cenários da Indústria a ser utilizado na simulação"]
[null,null,"Cenário 1","Cenário 2","Cenário 3","Cenário 4","Cenário 5"]
[null,"Descrição","Atual","FPua Mínimo","FPua Máximo","Fpua Mín e Kt","Fpua Máx e Kt"]
[null,"Arrecadação",{"$f":"'Base de dados Indústria'!M14","v":14930130.727041001},{"$f":"'Base de dados Indústria'!N14","v":13247586.009887911},{"$f":"'Base de dados Indústria'!O14","v":15589077.94605927},{"$f":"'Base de dados Indústria'!P14","v":12021861.418899776},{"$f":"'Base de dados Indústria'!Q14","v":13873573.554817282}]
[]
[]
["VALORES ARRECADADOS NA BACIA DO RIO DOCE"]
[]
[]
[null,"SUB-BACIA","TIPO DE USO",null,null,null,"SUB-BACIA","SETORES"]
[null,null,"Captação","Lançamento","Transposição",null,null,"Indústria",null,"Irrigação","Saneamento"]
[null,"TOTAL",{"$f":"SUM(C19:C25)","v":21183308.947532047},{"$f":"SUM(D19:D25)","v":5158678.1081891004},{"$f":"SUM(E19:E25)","v":4683096},null,"TOTAL",{"$f":"SUM(H19:H25)","v":14930130.727041001},null,{"$f":"SUM(J19:J25)","v":1079415.3777068465},{"$f":"SUM(K19:K25)","v":10332440.9509733}]
[null,"DO1",{"$f":"'Base de dados Indústria'!E20+'Base de dados Irrigação'!G6+'Base de Dados Saneamento'!F5","v":2459269.8770385273},{"$f":"'Base de Dados Saneamento'!G5","v":1078254.3349428002},0,null,null,{"$f":"'Base de dados Indústria'!E20","v":1461119.0531700007},null,{"$f":"'Base de dados Irrigação'!G6","v":38538.049279527004},{"$f":"'Base de Dados Saneamento'!F5+'Base de Dados Saneamento'!G5","v":2037867.1095317998}]
[null,"DO2",{"$f":"'Base de dados Indústria'!E21+'Base de dados Irrigação'!G7+'Base de Dados Saneamento'!F6","v":8880416.6662084796},{"$f":"'Base de Dados Saneamento'!G6","v":2162324.4486866998},0,null,"DO2",{"$f":"'Base de dados Indústria'!E21","v":6731132.5459350012},null,{"$f":"'Base de dados Irrigação'!G7","v":25179.070912077601},{"$f":"'Base de Dados Saneamento'!F6+'Base de Dados Saneamento'!G6","v":4286429.4980480997}]
[null,"DO3",{"$f":"'Base de dados Indústria'!E22+'Base de dados Irrigação'!G8+'Base de Dados Saneamento'!F7","v":2027706.6780552161},{"$f":"'Base de Dados Saneamento'!G7","v":360040.56991279998},0,null,"DO3",{"$f":"'Base de dados Indústria'!E22","v":1683162.3699029998},null,{"$f":"'Base de dados Irrigação'!G8","v":4032.4972122162003},{"$f":"'Base de Dados Saneamento'!F7+'Base de Dados Saneamento'!G7","v":700552.38085279986}]
[null,"DO4",{"$f":"'Base de dados Indústria'!E23+'Base de dados Irrigação'!G9+'Base de Dados Saneamento'!F8","v":1140094.2214551794},{"$f":"'Base de Dados Saneamento'!G8","v":952201.42844359996},0,null,"DO4",{"$f":"'Base de dados Indústria'!E23","v":97314.986139000001},null,{"$f":"'Base de dados Irrigação'!G9","v":14353.656380179198},{"$f":"'Base de Dados Saneamento'!F8+'Base de Dados Saneamento'!G8","v":1980627.0073796003}]
[null,"DO5",{"$f":"'Base de dados Indústria'!E24+'Base de dados Irrigação'!G10+'Base de Dados Saneamento'!F9","v":276166.71244412882},{"$f":"'Base de Dados Saneamento'!G9","v":124586.99762919999},0,null,"DO5",{"$f":"'Base de dados Indústria'!E24","v":21028.250859000003},null,{"$f":"'Base de dados Irrigação'!G10","v":33394.4040123288},{"$f":"'Base de Dados Saneamento'!F9+'Base de Dados Saneamento'!G9","v":346331.05520200002}]
[null,"DO6",{"$f":"'Base de dados Indústria'!E25+'Base de dados Irrigação'!G11+'Base de Dados Saneamento'!F10","v":262175.6710252848},{"$f":"'Base de Dados Saneamento'!G10","v":113326.09453399999},0,null,"DO6",{"$f":"'Base de dados Indústria'!E25","v":11500.930875000002},null,{"$f":"'Base de dados Irrigação'!G11","v":64932.007856284792},{"$f":"'Base de Dados Saneamento'!F10+'Base de Dados Saneamento'!G10","v":299068.82682800002}]
[null,"DO-ES",{"$f":"'Base de dados Indústria'!E26+'Base de dados Irrigação'!G12+'Base de Dados Saneamento'!F11","v":6137479.1213052319},{"$f":"'Base de Dados Saneamento'!G11","v":367944.23403999995},{"$f":"'Base de dados Indústria'!I155*D4*IF(ISBLANK(E4),1,IF(E4=0,1,1-E4))","v":4683096},null,"DO-ES",{"$f":"'Base de dados Indústria'!E26","v":4924872.5901599992},null,{"$f":"'Base de dados Irrigação'!G12","v":898985.69205423293},{"$f":"'Base de Dados Saneamento'!F11+'Base de Dados Saneamento'!G11","v":681565.07313099992}]
[]
[]
[null,"SUB-BACIA","DOMINIALIDADE",null,"Total",null,"IMPACTO SOBRE USUÁRIOS",null,null,"RECURSOS PARA CUSTEIO"]
[null,null,"Estadual","Federal",null,null,null,"INDÚSTRIA",null,"Custeio Total",{"$f":"(J18+K18+'Base de dados Indústria'!M14+E25)*0.075","v":2326881.2291790862}]
[null,"TOTAL",{"$f":"SUM(C31:C37)","v":20084086.266341649},{"$f":"SUM(D31:D38)","v":6257900.7893795008},{"$f":"SUM(C18:D18)","v":26341987.055721149},null,"Receita",{"$f":"(H18+E25)/'Receita e Custo Ind.'!E4","v":1.0644638349117119E-3},null,"Custeio Estadual",{"$f":"('Base de dados Indústria'!C14+'Base de dados Irrigação'!G13+'Base de Dados Saneamento'!B12+'Base de Dados Saneamento'!D12)*0.075","v":1506306.4699756233}]
[null,"DO1",{"$f":"'Base de dados Indústria'!C20+'Base de dados Irrigação'!G6+'Base de Dados Saneamento'!B5+'Base de Dados Saneamento'!D5","v":3533182.6081413273},{"$f":"'Base de dados Indústria'!D20+'Base de Dados Saneamento'!C5+'Base de Dados Saneamento'!E5","v":4341.6038400000007},{"$f":"SUM(H19:K19)","v":3537524.2119813273},null,"Custo",{"$f":"(H18+E25)/'Receita e Custo Ind.'!F4","v":1.0651961308796309E-3},null,"Custeio Federal",{"$f":"K29-K30","v":820574.75920346286}]
[null,"DO2",{"$f":"'Base de dados Indústria'!C21+'Base de dados Irrigação'!G7+'Base de Dados Saneamento'!B6+'Base de Dados Saneamento'!D6","v":6795421.2219751794},{"$f":"'Base de dados Indústria'!D21+'Base de Dados Saneamento'!C6+'Base de Dados Saneamento'!E6","v":4247319.8929200005},11042741.11489518,null,null,"IRRIGAÇÃO"]
[null,"DO3",{"$f":"'Base de dados Indústria'!C22+'Base de dados Irrigação'!G8+'Base de Dados Saneamento'!B7+'Base de Dados Saneamento'!D7","v":2385454.6023680163},{"$f":"'Base de dados Indústria'!D22+'Base de Dados Saneamento'!C7+'Base de Dados Saneamento'!E7","v":2292.6455999999998},2387747.2479680162,null,"Receita",{"$f":"J18/'Receita e Custo Irrig.'!F4","v":1.0790781561994438E-3}]
[null,"DO4",{"$f":"'Base de dados Indústria'!C23+'Base de dados Irrigação'!G9+'Base de Dados Saneamento'!B8+'Base de Dados Saneamento'!D8","v":720986.65473877918},{"$f":"'Base de dados Indústria'!D23+'Base de Dados Saneamento'!C8+'Base de Dados Saneamento'!E8","v":1371308.9951600002},2092295.6498987796,null,"Custo",{"$f":"J18/'Receita e Custo Irrig.'!E4","v":1.5643453674899202E-3}]
[null,"DO5",{"$f":"'Base de dados Indústria'!C24+'Base de dados Irrigação'!G10+'Base de Dados Saneamento'!B9+'Base de Dados Saneamento'!D9","v":380938.9500733288},{"$f":"'Base de dados Indústria'!D24+'Base de Dados Saneamento'!C9+'Base de Dados Saneamento'!E9","v":19814.760000000002},400753.71007332881,null,null,"SANEAMENTO"]
[null,"DO6",{"$f":"'Base de dados Indústria'!C25+'Base de dados Irrigação'!G11+'Base de Dados Saneamento'!B10+'Base de Dados Saneamento'!D10","v":370164.14732228481},{"$f":"'Base de dados Indústria'!D25+'Base de Dados Saneamento'!C10+'Base de Dados Saneamento'!E10","v":5337.6182369999997},375501.76555928483,null,"Receita",{"$f":"K18/'Receita e Custo. San.'!D3","v":2.9469981972318128E-2}]
[null,"DO-ES",{"$f":"'Base de dados Indústria'!C26+'Base de dados Irrigação'!G12+'Base de Dados Saneamento'!B11+'Base de Dados Saneamento'!D11","v":5897938.0817227326},{"$f":"'Base de dados Indústria'!D26+'Base de Dados Saneamento'!C11+'Base de Dados Saneamento'!E11","v":607485.27362250001},6505423.3553452315,null,"Custo",{"$f":"K18/'Receita e Custo. San.'!E3","v":2.9288978561424327E-2}]

{"sheet":"Base de dados Indústria","index":2,"n_rows":233,"n_cols":23,"rows_kept":233,"cut":false,"hidden":false,"merged":[[17,2,17,4]]}
[]
[]
[]
[null,null,"Rótulos de Coluna"]
[null,null,"Soma de Arrecadação Atual",null,"Soma de Arrecadação_mín",null,"Soma de Arrecadação_máx",null,"Soma de Arrecadação Kt e FPua Mín.",null,"Soma de Arrecadação Kt e FPua Máx.",null,"Total Soma de Arrecadação Atual","Total Soma de Arrecadação_mín","Total Soma de Arrecadação_máx","Total Soma de Arrecadação Kt e FPua Mín.","Total Soma de Arrecadação Kt e FPua Máx."]
[null,"Rótulos de Linha","Estadual","Federal","Estadual","Federal","Estadual","Federal","Estadual","Federal","Estadual","Federal"]
[null,"DO1",1456777.4493300007,4341.6038400000007,1247851.9315273196,1582.8624,1980587.93331357,1775.8944000000001,1018382.9091573858,1582.8624,1597244.3505685234,1775.8944000000001,1461119.0531700007,1249434.7939273196,1982363.8277135701,1019965.7715573858,1599020.2449685235]
[null,"DO2",4430308.1179350009,2300824.4280000003,3824305.7690436905,1818101.4919200002,4528481.0867801411,1818382.2199200001,3119904.7742939619,1691468.0253576003,3677650.025074278,1691748.7533576002,6731132.5459350012,5642407.2609636905,6346863.3067001412,4811372.7996515622,5369398.7784318784]
[null,"DO3",1680869.7243029999,2292.6455999999998,1350258.1976625,60.7194,2246425.3720944002,60.7194,1104508.9519594284,60.7194,1811741.2792687195,60.7194,1683162.3699029998,1350318.9170625,2246486.0914944001,1104569.6713594284,1811801.9986687195]
[null,"DO4",39672.070178999995,57642.915960000006,34200.403005300002,52309.908504000006,34508.073585300001,55216.894824000003,34740.728805300001,52345.725264000008,34508.073585300001,55252.711584000004,97314.986139000001,86510.311509300009,89724.968409299996,87086.454069300002,89760.785169300012]
[null,"DO5",1213.490859,19814.760000000002,1002.5503322100001,22541.198400000001,1002.5503322100001,24809.198399999997,1353.8383322100001,22541.198400000001,1353.8383322100001,24809.198399999997,21028.250859000003,23543.748732210002,25811.748732209999,23895.036732210003,26163.036732209999]
[null,"DO6",6163.3126380000012,5337.6182369999997,4532.0922672900006,1311.7857984,4867.7906560500005,1444.9083264000001,4862.7364272900004,5499.8001954000001,5198.4348160500003,5632.9227234,11500.930875000002,5843.8780656900008,6312.6989824500006,10362.536622690001,10831.35753945]
[null,"DO-ES",4896388.7899199994,28483.800239999997,4865964.2194752004,23562.880152000005,4866113.2270751996,25402.076952000003,4935328.9129152,29280.235992000002,4935477.9205152001,31119.432792,4924872.5901599992,4889527.0996272005,4891515.3040271997,4964609.1489072004,4966597.3533071997]
[null,"Total geral",12511392.955164,2418737.7718769996,11328115.16331351,1919470.8465744003,13661986.033836871,1927091.9122224003,10219082.851890776,1802778.5670090003,12063173.922160281,1810399.6326570003,14930130.727041001,13247586.009887911,15589077.94605927,12021861.418899776,13873573.554817282]
[]
[null,null,"Cenário Escolhido",1]
[]
[null,null,"DOMINIALIDADE"]
[null,null,"Estadual","Federal","Total"]
[null,null,{"$f":"IF($D$16=1,C7,IF($D$16=2,E7,IF($D$16=3,G7,IF($D$16=4,I7,IF($D$16=5,K7,0)))))","v":1456777.4493300007},{"$f":"IF($D$16=1,D7,IF($D$16=2,F7,IF($D$16=3,H7,IF($D$16=4,J7,IF($D$16=5,L7,0)))))","v":4341.6038400000007},{"$f":"D20+C20","v":1461119.0531700007}]
[null,null,{"$f":"IF($D$16=1,C8,IF($D$16=2,E8,IF($D$16=3,G8,IF($D$16=4,I8,IF($D$16=5,K8,0)))))","v":4430308.1179350009},2300824.4280000003,{"$f":"D21+C21","v":6731132.5459350012}]
[null,null,{"$f":"IF($D$16=1,C9,IF($D$16=2,E9,IF($D$16=3,G9,IF($D$16=4,I9,IF($D$16=5,K9,0)))))","v":1680869.7243029999},2292.6455999999998,1683162.3699029998]
[null,null,{"$f":"IF($D$16=1,C10,IF($D$16=2,E10,IF($D$16=3,G10,IF($D$16=4,I10,IF($D$16=5,K10,0)))))","v":39672.070178999995},57642.915960000006,97314.986139000001]
[null,null,{"$f":"IF($D$16=1,C11,IF($D$16=2,E11,IF($D$16=3,G11,IF($D$16=4,I11,IF($D$16=5,K11,0)))))","v":1213.490859},19814.760000000002,21028.250859000003]
[null,null,{"$f":"IF($D$16=1,C12,IF($D$16=2,E12,IF($D$16=3,G12,IF($D$16=4,I12,IF($D$16=5,K12,0)))))","v":6163.3126380000012},5337.6182369999997,11500.930875000002]
[null,null,{"$f":"IF($D$16=1,C13,IF($D$16=2,E13,IF($D$16=3,G13,IF($D$16=4,I13,IF($D$16=5,K13,0)))))","v":4896388.7899199994},28483.800239999997,4924872.5901599992]
[null,null,{"$f":"IF($D$16=1,C14,IF($D$16=2,E14,IF($D$16=3,G14,IF($D$16=4,I14,IF($D$16=5,K14,0)))))","v":12511392.955164},2418737.7718769996,14930130.727041001]
[]
["PPU Captação"]
[{"$f":"SIMULADOR!B4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2}]
["Orgão Gestor","Municipio","Razão Social","Domínio","UF","Domínio 1.0","UPGRH","UPGRH 1.0","Q TRANSPOSIÇÃO","Q Captação (m³/ano)","Finalidade","CNAE - Classe","FPUA_Seg mín","FPUA_Seg max","% reuso","Kreuso","Kchuva","Kt","Arrecadação_mín","Arrecadação_máx","Arrecadação Atual","Arrecadação Kt e FPua Mín.","Arrecadação Kt e FPua Máx."]
["IEMA","AFONSO CLÁUDIO","ARNËBIO TEIXEIRA","Estadual","Espírito Santo",{"$f":"IF(D32=\"estadual\",E32,D32)","v":"Espírito Santo"},"Guandu","DO-ES",null,37843.199999999997,"Indústria",null,null,null,null,null,null,1,null,null,{"$f":"J32*A$30","v":794.70719999999994},{"$f":"R32*IF(ISBLANK(S32),U32,S32)","v":794.70719999999994},{"$f":"R32*IF(ISBLANK(T32),U32,T32)","v":794.70719999999994}]
["IEMA","AFONSO CLÁUDIO","AUGUSTO REETZ","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,{"$f":"R33*IF(ISBLANK(S33),U33,S33)","v":331.12800000000004},{"$f":"R33*IF(ISBLANK(T33),U33,T33)","v":331.12800000000004}]
["IEMA","AFONSO CLÁUDIO","DAIDE DAVEL DELPUPO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,26805.599999999999,"Indústria",null,null,null,null,null,null,1,null,null,562.91759999999999,562.91759999999999,562.91759999999999]
["IEMA","AFONSO CLÁUDIO","DEIDSON DELPUPO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,43519.68,"Indústria",null,null,null,null,null,null,1,null,null,913.9132800000001,913.9132800000001,913.9132800000001]
["IEMA","AFONSO CLÁUDIO","F.M MINERAÃ├O LTDA ME","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,47304,"Indústria","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M36*$A$30*J36","v":1221.8623200000002},{"$f":"$A$30*N36*J36","v":1370.8699199999999},993.38400000000001,1221.8623200000002,1370.8699199999999]
["IEMA","AFONSO CLÁUDIO","JO├O TURRA NUNES","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,69379.199999999997,"Indústria",null,null,null,null,null,null,1,null,null,1456.9632000000001,1456.9632000000001,1456.9632000000001]
["IEMA","AFONSO CLÁUDIO","JOEL DE VARGAS","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,63072,"Indústria",null,null,null,null,null,null,1,null,null,1324.5120000000002,1324.5120000000002,1324.5120000000002]
["IEMA","AFONSO CLÁUDIO","JORGE LUIZ DIAS DA SILVA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,47304,"Indústria",null,null,null,null,null,null,1,null,null,993.38400000000001,993.38400000000001,993.38400000000001]
["IEMA","AFONSO CLÁUDIO","JOS╔ SERGIO HADDAD FAF┴","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IEMA","AFONSO CLÁUDIO","JOSE BARBOSA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,34689.599999999999,"Indústria",null,null,null,null,null,null,1,null,null,728.48160000000007,728.48160000000007,728.48160000000007]
["IEMA","AFONSO CLÁUDIO","M┴RIO C╔SAR DELATORRE","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,63072,"Indústria",null,null,null,null,null,null,1,null,null,1324.5120000000002,1324.5120000000002,1324.5120000000002]
["IEMA","AFONSO CLÁUDIO","MARCIO EUT═MEO VICENTE","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,129297.59999999999,"Indústria",null,null,null,null,null,null,1,null,null,2715.2496000000001,2715.2496000000001,2715.2496000000001]
["IEMA","AFONSO CLÁUDIO","PAULO ROBERTO DIAS SOARES","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,220752,"Indústria",null,null,null,null,null,null,1,null,null,4635.7920000000004,4635.7920000000004,4635.7920000000004]
["IEMA","AFONSO CLÁUDIO","RODOLFO FERREIRA KIEFFER","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,43519.68,"Indústria",null,null,null,null,null,null,1,null,null,913.9132800000001,913.9132800000001,913.9132800000001]
["IEMA","AFONSO CLÁUDIO","SEBASTI├O DE VARGAS COUTINHO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,40996.800000000003,"Indústria",null,null,null,null,null,null,1,null,null,860.93280000000016,860.93280000000016,860.93280000000016]
["IEMA","AFONSO CLÁUDIO","VALTER JOS╔DE VARGAS","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,94608,"Indústria",null,null,null,null,null,null,1,null,null,1986.768,1986.768,1986.768]
["IEMA","ÁGUIA BRANCA","LATICINIOS REZENDE LTDA - ME","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,11037.6,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M48*$A$30*J48","v":162.25272000000001},{"$f":"$A$30*N48*J48","v":162.25272000000001},231.78960000000004,162.25272000000001,162.25272000000001]
["IEMA","ÁGUIA BRANCA","MINERAÃ├O PANCIERI LTDA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,122990.39999999999,"Indústria","2391-5 - APARELHAMENTO E OUTROS TRABALHOS EM PEDRAS",0.84,0.84,null,null,null,1,{"$f":"M49*$A$30*J49","v":2169.5506559999999},{"$f":"$A$30*N49*J49","v":2169.5506559999999},2582.7984000000001,2169.5506559999999,2169.5506559999999]
["IGAM","Aimorés","DIAS E SIQUEIRA COMERCIAL LTDA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,21960,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"M50*J50*$A$30","v":364.31640000000004},{"$f":"J50*N50*$A$30","v":364.31640000000004},461.16,364.31640000000004,364.31640000000004]
["ANA","Aimorés","BONICENHA LOCADORA LTDA ME","Federal","Minas Gerais","Federal","DO6","DO6",null,84480,"Extração de Areia",null,null,null,null,null,null,1,null,null,1774.0800000000002,1774.0800000000002,1774.0800000000002]
["IGAM","Antônio Dias","PETRA MINERAÇÃO COMÉRCIO E EXPORTAÇÃO LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,158111.99900000001,"Indústria","0899-1 - EXTRAÇÃO DE MINERAIS NÃO-METÁLICOS NÃO ESPECIFICADOS ANTERIORMENTE",0.84,0.84,null,null,null,1,{"$f":"$A$30*M52*J52","v":2789.09566236},{"$f":"$A$30*N52*J52","v":2789.09566236},3320.3519790000005,2789.09566236,2789.09566236]
["IGAM","Antônio Dias","ALEXANDRITA MINERAÇÃO COMÉRCIO E EXPORTAÇÃO LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,60756,"Mineração",null,null,null,null,null,null,1,null,null,1275.876,1275.876,1275.876]
["ANA","Antônio Dias","CELULOSE NIPO-BRASILEIRA S.A - CENIBRA","Federal","Minas Gerais","Federal","DO2","DO2",null,109451448,"Indústria","1710-9 - FABRICAÇÃO DE CELULOSE E OUTRAS PASTAS PARA A FABRICAÇÃO DE PAPEL",0.79,0.79,28,0.1,0,0.93,{"$f":"$A$30*M54*J54","v":1815799.52232},{"$f":"$A$30*N54*J54","v":1815799.52232},2298480.4080000003,1688693.5557576001,1688693.5557576001]
["ANA","Baixo Guandu","CAPIXABA COUROS LTDA","Federal","Espírito Santo","Federal","Guandu","DO-ES",null,0,"Indústria","1510-6 - CURTIMENTO E OUTRAS PREPARAÇÕES DE COURO",0.7,0.7,null,null,null,1,{"$f":"M55*$A$30*J55","v":0},{"$f":"$A$30*N55*J55","v":0},0,0,0]
["IEMA","BAIXO GUANDÚ","CAPIXABA COUROS LTDA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,220752,"Indústria","1510-6 - CURTIMENTO E OUTRAS PREPARAÇÕES DE COURO",0.7,0.7,null,null,null,1,{"$f":"M56*$A$30*J56","v":3245.0544},{"$f":"$A$30*N56*J56","v":3245.0544},4635.7920000000004,3245.0544,3245.0544]
["IGAM","Barão de Cocais","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,9395366.4000000004,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"73 - 80",0.3,0,0.79,{"$f":"$A$30*M57*J57","v":161788.209408},{"$f":"$A$30*N57*J57","v":270304.69132800004},197302.69440000001,127812.68543232,213540.70614912006]
["IGAM","Barão de Cocais","GERDAU AÇOS LONGOS S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,3952800,"Indústria","2423-7 - PRODUÇÃO DE LAMINADOS LONGOS DE AÇO",0.88,0.88,97,0.3,0,0.79,{"$f":"$A$30*M58*J58","v":73047.744000000006},{"$f":"$A$30*N58*J58","v":73047.744000000006},83008.800000000003,57707.717760000007,57707.717760000007]
["IGAM","Belo Oriente","ANACLETO JOSÉ BAIÃO","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,3660,"Indústria",null,null,null,null,null,null,1,null,null,76.86,76.86,76.86]
["IGAM","Belo Oriente","MÁRMORES E GRANITOS DO VALE LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,8564.3989999999994,"Indústria",null,null,null,null,null,null,1,null,null,179.85237900000001,179.85237900000001,179.85237900000001]
["ANA","Belo Oriente","Ione Ferreira Alves Ramos","Federal","Minas Gerais","Federal","DO3","DO3",null,32313.599999999999,"Extração de Areia",null,null,null,null,null,null,1,{"$f":"$A$30*J61*M61","v":0},{"$f":"$A$30*N61*J61","v":0},678.5856,0,0]
["IEMA","BREJETUBA","ANDREA VIVACQUA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,31536,"Indústria",null,null,null,null,null,null,1,null,null,662.25600000000009,662.25600000000009,662.25600000000009]
["IEMA","BREJETUBA","ANGEO MARCOS ULIANA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IEMA","BREJETUBA","ANTÈNIO MARINO RONCETE","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IEMA","BREJETUBA","ANTÈNIO ZUCON SOBRINHO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,31536,"Indústria",null,null,null,null,null,null,1,null,null,662.25600000000009,662.25600000000009,662.25600000000009]
["IEMA","BREJETUBA","ASSSOCIAÃ├O DE PRODUTORES E MORADORS DE BEJAUBINHA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,31536,"Indústria",null,null,null,null,null,null,1,null,null,662.25600000000009,662.25600000000009,662.25600000000009]
["IEMA","BREJETUBA","BELLARMINO ULYANA","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,132451.20000000001,"Indústria",null,null,null,null,null,null,1,null,null,2781.4752000000003,2781.4752000000003,2781.4752000000003]
["IEMA","BREJETUBA","C╔RGIO ADALBERTO CÈCO E IRM├OS","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,10406.879999999999,"Indústria",null,null,null,null,null,null,1,null,null,218.54447999999999,218.54447999999999,218.54447999999999]
["IEMA","BREJETUBA","HENRIQUE DUFFLES TEIXEIRA LOTT COCO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,274363.19999999972,"Indústria",null,null,null,null,null,null,1,null,null,5761.6271999999944,5761.6271999999944,5761.6271999999944]
["IEMA","BREJETUBA","JOSE FORTUNATO GIOVANI","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IEMA","BREJETUBA","JUC╔RIO CÈCO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,31536,"Indústria",null,null,null,null,null,null,1,null,null,662.25600000000009,662.25600000000009,662.25600000000009]
["IEMA","BREJETUBA","MOACYR P┴GIO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IEMA","BREJETUBA","SEBASTI├O FRANCISCO FILHO","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,15768,"Indústria",null,null,null,null,null,null,1,null,null,331.12800000000004,331.12800000000004,331.12800000000004]
["IGAM","Caranaíba","Cimento Tupi S.A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,4428600,"Indústria","2320-6 - FABRICAÇÃO DE CIMENTO",1.4,1.4,null,null,null,1,{"$f":"M74*$A$30*J74","v":130200.84},{"$f":"$A$30*N74*J74","v":130200.84},93000.6,130200.84,130200.84]
["IGAM","Caratinga","CENTRALBETON LTDA","Estadual","Minas Gerais","Minas Gerais","DO5","DO5",null,15000,"Indústria",null,null,null,null,null,null,1,null,null,315,315,315]
["IGAM","Caratinga","FRICAL ALIMENTOS LTDA","Estadual","Minas Gerais","Minas Gerais","DO5","DO5",null,15966.718999999999,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"M76*J76*$A$30","v":264.88786821000002},{"$f":"N76*$A$30*J76","v":264.88786821000002},335.30109900000002,264.88786821000002,264.88786821000002]
["IGAM","Caratinga","AREAL JACUTINGA LTDA ME","Estadual","Minas Gerais","Minas Gerais","DO5","DO5",null,25090.560000000001,"Mineração","2330-3 - FABRICAÇÃO DE ARTEFATOS DE CONCRETO, CIMENTO, FIBROCIMENTO, GESSO E MATERIAIS SEMELHANTES",1.4,1.4,null,null,null,1,{"$f":"M77*J77*$A$30","v":737.662464},{"$f":"N77*$A$30*J77","v":737.662464},526.90176000000008,737.662464,737.662464]
["ANA","Caratinga","Areal Naque LTDA - ME","Federal","Minas Gerais","Federal","DO5","DO5",null,355200,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M78*J78*$A$30","v":9174.8160000000007},{"$f":"N78*$A$30*J78","v":10293.696},7459.2000000000007,9174.8160000000007,10293.696]
["ANA","Caratinga","Empresa Fornecedora de Materiais Ltda - ME","Federal","Minas Gerais","Federal","DO5","DO5",null,223560,"Extração de Areia","0899-1 - EXTRAÇÃO DE MINERAIS NÃO-METÁLICOS NÃO ESPECIFICADOS ANTERIORMENTE",0.84,0.84,null,null,null,1,{"$f":"M79*J79*$A$30","v":3943.5984000000003},{"$f":"N79*$A$30*J79","v":3943.5983999999999},4694.76,3943.5984000000003,3943.5983999999999]
["ANA","Caratinga","MARETEX EXTRAÇÃO E COMÉRCIO DE AREIA LTDA","Federal","Minas Gerais","Federal","DO5","DO5",null,172800,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M80*J80*$A$30","v":4463.424},{"$f":"N80*$A$30*J80","v":5007.7439999999997},3628.8,4463.424,5007.7439999999997]
["ANA","Colatina","ZACCHE & CIA LTDA.","Federal","Espírito Santo","Federal","São José","DO-ES",null,55296,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M81*$A$30*J81","v":1428.2956800000002},{"$f":"$A$30*N81*J81","v":1602.4780799999999},1161.2160000000001,1428.2956800000002,1602.4780799999999]
["ANA","Colatina","A C DAL COL ME","Federal","Espírito Santo","Federal","São José","DO-ES",null,161280,"Extração de Areia",null,null,null,null,null,null,1,null,null,3386.88,3386.88,3386.88]
["ANA","Colatina","Frisa Frigorífico Rio Doce S.A","Federal","Espírito Santo","Federal","São José","DO-ES",null,184320,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"M83*$A$30*J83","v":3057.8688000000002},{"$f":"$A$30*N83*J83","v":3057.8688000000002},3870.7200000000003,3057.8688000000002,3057.8688000000002]
["ANA","Colatina","Latícinios Colatina Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,30390,"Indústria","1051-1 - PREPARAÇÃO DO LEITE",0.7,0.7,null,null,null,1,{"$f":"M84*$A$30*J84","v":446.733},{"$f":"$A$30*N84*J84","v":446.733},638.19000000000005,446.733,446.733]
["ANA","Colatina","Confecções Merpa São Paulo Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,69300,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M85*$A$30*J85","v":1207.8990000000001},{"$f":"$A$30*N85*J85","v":1207.8990000000001},1455.3000000000002,1207.8990000000001,1207.8990000000001]
["ANA","Colatina","Larou´s Ind. e Comércio de Confecções Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,28512,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M86*$A$30*J86","v":496.96416000000005},{"$f":"$A$30*N86*J86","v":496.96416000000005},598.75200000000007,496.96416000000005,496.96416000000005]
["ANA","Colatina","Irmãos Gomes da Costa Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,30240,"Extração de Areia",null,null,null,null,null,null,1,null,null,635.04000000000008,635.04000000000008,635.04000000000008]
["ANA","Colatina","ARETEC - Extração e Comércio de Areia LTDA - ME","Federal","Espírito Santo","Federal","São José","DO-ES",null,103680,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M88*$A$30*J88","v":2678.0544000000004},{"$f":"$A$30*N88*J88","v":3004.6464000000001},2177.2800000000002,2678.0544000000004,3004.6464000000001]
["ANA","Colatina","PW BRASIL EXPORT S/A","Federal","Espírito Santo","Federal","São José","DO-ES",null,43780,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M89*$A$30*J89","v":763.08540000000005},{"$f":"$A$30*N89*J89","v":763.08540000000005},919.38000000000011,763.08540000000005,763.08540000000005]
["ANA","Colatina","Irmãos Nardi Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,150336,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M90*$A$30*J90","v":3883.1788800000004},{"$f":"$A$30*N90*J90","v":4356.7372799999994},3157.056,3883.1788800000004,4356.7372799999994]
["ANA","Colatina","DOIS IRMÃOS BENEFICIAMENTO DE AREIA LTDA.","Federal","Espírito Santo","Federal","São José","DO-ES",null,45000,"Extração de Areia",null,null,null,null,null,null,1,null,null,945.00000000000011,945.00000000000011,945.00000000000011]
["ANA","Colatina","MINERACAO RIO DOCE LTDA","Federal","Espírito Santo","Federal","São José","DO-ES",null,26880,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M92*$A$30*J92","v":694.31040000000007},{"$f":"$A$30*N92*J92","v":778.98239999999998},564.48,694.31040000000007,778.98239999999998]
["ANA","Colatina","M & M INDUSTRIAL LTDA","Federal","Espírito Santo","Federal","São José","DO-ES",null,0,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,null,null,0,0,0]
["ANA","Colatina","FAFUS CONFECÇÕES LTDA","Federal","Espírito Santo","Federal","São José","DO-ES",null,0,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,null,null,0,0,0]
["ANA","Colatina","DIAN CONFECÇÕES LTDA","Federal","Espírito Santo","Federal","São José","DO-ES",null,0,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,null,null,0,0,0]
["ANA","Colatina","C & C Mineração Ltda Me","Federal","Espírito Santo",{"$f":"IF(D96=\"estadual\",E96,D96)","v":"Federal"},"São José","DO-ES",null,35735.040000000001,"Extração de Areia",null,null,null,null,null,null,1,null,null,{"$f":"J96*A$30","v":750.4358400000001},750.4358400000001,750.4358400000001]
["ANA","Colatina","Ana Mercedes Broetto Giacomin-Me","Federal","Espírito Santo","Federal","São José","DO-ES",null,126720,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M97*$A$30*J97","v":3273.1776000000004},{"$f":"$A$30*N97*J97","v":3672.3455999999996},2661.1200000000003,{"$f":"R97*IF(ISBLANK(S97),U97,S97)","v":3273.1776000000004},{"$f":"R97*IF(ISBLANK(T97),U97,T97)","v":3672.3455999999996}]
["ANA","Colatina","Confecções Mimo S.A.","Federal","Espírito Santo","Federal","São José","DO-ES",null,67910.399999999994,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M98*$A$30*J98","v":1183.6782719999999},{"$f":"$A$30*N98*J98","v":1183.6782719999999},1426.1184000000001,1183.6782719999999,1183.6782719999999]
["ANA","Colatina","Togo Confecções Ltda - ME","Federal","Espírito Santo","Federal","São José","DO-ES",null,76032,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M99*$A$30*J99","v":1325.23776},{"$f":"$A$30*N99*J99","v":1325.23776},1596.672,1325.23776,1325.23776]
["IEMA","COLATINA","K V MACHADO CONFECÃıES -  ME","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,611798.39999999676,"Indústria","1412-6 - CONFECÇÃO DE PEÇAS DE VESTUÁRIO, EXCETO ROUPAS ÍNTIMAS",0.83,0.83,null,null,null,1,{"$f":"M100*$A$30*J100","v":10663.646111999944},{"$f":"$A$30*N100*J100","v":10663.646111999944},12847.766399999933,10663.646111999944,10663.646111999944]
["ANA","Conceição de Ipanema","PAPIRE´S MODAS LTDA","Federal","Minas Gerais","Federal","DO6","DO6",null,9968.64,"Extração de Areia",null,null,null,null,null,null,1,null,null,209.34144000000001,209.34144000000001,209.34144000000001]
["IGAM","Conceição do Mato Dentro","ANGLO FERROUS MINAS RIO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,34593924.718999997,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"80 - 90",0.3,0,0.79,{"$f":"$A$30*J102*M102","v":595707.38366117992},{"$f":"$A$30*N102*J102","v":995267.21416563005},726472.41909899993,470608.83309233218,786261.09919084783]
["IGAM","Conceição do Mato Dentro","NOVA ERA SILICON S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,64355.567999999999,"indústria","2412-1 - PRODUÇÃO DE FERROLIGAS",0.84,0.84,null,null,null,1,{"$f":"$A$30*J103*M103","v":1135.2322195199999},{"$f":"$A$30*N103*J103","v":1135.2322195199999},1351.4669280000001,1135.2322195199999,1135.2322195199999]
["IGAM","Conceição do Mato Dentro","ODILON SIMÕES FILHO - ME","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,14222.88,"Mineração",null,null,null,null,null,null,1,null,null,298.68047999999999,298.68047999999999,298.68047999999999]
["IGAM","Conceição do Mato Dentro","REYNALDO COSTA FERREIRA-ME","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,1555200,"Mineração",null,null,null,null,null,null,1,null,null,32659.200000000001,32659.200000000001,32659.200000000001]
["ANA","Conselheiro Pena","COOPERATIVA MISTA DOS PRODUTORES RURAIS DE CONSELHEIRO PENA - COOPMISTA","Federal","Minas Gerais","Federal","DO4","DO4",null,153134.39999999999,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M106*$A$30*J106","v":2251.0756799999999},{"$f":"N106*$A$30*J106","v":2251.0756799999999},3215.8224,2251.0756799999999,2251.0756799999999]
["IGAM","Coronel Fabriciano","MAGNESITA INSIDER REFRATÁRIOS LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,7246.8,"Indústria","2341-9 - FABRICAÇÃO DE PRODUTOS CERÂMICOS REFRATÁRIOS",0.84,0.84,null,null,null,1,{"$f":"$A$30*M107*J107","v":127.833552},{"$f":"$A$30*N107*J107","v":127.833552},152.18280000000001,127.833552,127.833552]
["IGAM","Dores de Guanhães","MONTE SANTO MINERADORA E EXPORTADORA S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,45021.66,"Mineração","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"$A$30*J108*M108","v":1162.9094778000001},{"$f":"$A$30*N108*J108","v":1304.7277068000001},945.45486000000017,1162.9094778000001,1304.7277068000001]
["ANA","Galiléia","ANA MARIA DA FONSECA SANTOS","Federal","Minas Gerais","Federal","DO4","DO4",null,1705.56,"Extração de Areia",null,null,null,null,null,null,1,null,null,35.816760000000002,35.816760000000002,35.816760000000002]
["IGAM","Governador Valadares","BARBOSA & MARQUES S.A","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,0,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M110*$A$30*J110","v":0},{"$f":"N110*$A$30*J110","v":0},0,0,0]
["IGAM","Governador Valadares","Mafrial Matadouro e Frigorífico Ltda.","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,0,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"M111*$A$30*J111","v":0},0,0,0,0]
["IGAM","Governador Valadares","LATICINIO BELA VISTA LTDA","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,0,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M112*$A$30*J112","v":0},0,0,0,0]
["IGAM","Governador Valadares","COMPANHIA DE ALIMENTOS IBITURUNA S/A","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,377456.39899999998,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M113*$A$30*J113","v":5548.6090652999992},5548.6090652999992,7926.5843789999999,5548.6090652999992,5548.6090652999992]
["IGAM","Governador Valadares","SANTHER - FÁBRICA DE PAPEL SANTA TEREZINHA S/A","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,1465098,"Indústria","1742-7 - FABRICAÇÃO DE PRODUTOS DE PAPEL PARA USOS DOMÉSTICO E HIGIÊNICO-SANITÁRIO",0.92,0.93,null,null,null,1,{"$f":"M114*$A$30*J114","v":28305.693360000001},28613.363940000003,30767.058000000001,28305.693360000001,28613.363940000003]
["IGAM","Governador Valadares","INDUSTRIAS TUDOR Minas Gerais DE BATERIAS LTDA","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,25729.8,"Indústria","2722-8 - FABRICAÇÃO DE BATERIAS E ACUMULADORES PARA VEÍCULOS AUTOMOTORES",0,0,null,null,null,1,null,0,540.32580000000007,540.32580000000007,0]
["IGAM","Governador Valadares","MATADOURO SÃO GERALDO LTDA","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,20862,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"M116*$A$30*J116","v":346.10058000000004},346.10058000000004,438.10200000000003,346.10058000000004,346.10058000000004]
["IGAM","Governador Valadares","MATADOURO SÃO GERALDO LTDA","Estadual","Minas Gerais","Minas Gerais","DO4","DO4",null,0,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,0,0,0,0,0]
["ANA","Governador Valadares","PEDRO GLÓRIA - FIRMA INDIVIDUAL","Federal","Minas Gerais","Federal","DO4","DO4",null,202752,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,5237.0841600000003,5875.7529599999998,4257.7920000000004,5237.0841600000003,5875.7529599999998]
["ANA","Governador Valadares","Colodetti & Lopes Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,36864,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,952.19712000000004,1068.31872,774.14400000000001,952.19712000000004,1068.31872]
["ANA","Governador Valadares","Areal Mônica Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,12672,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,327.31776000000002,367.23455999999999,266.11200000000002,327.31776000000002,367.23455999999999]
["ANA","Governador Valadares","Areal Rio Doce LTDA","Federal","Minas Gerais","Federal","DO4","DO4",null,74880,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,1934.1504000000002,2170.0223999999998,1572.48,1934.1504000000002,2170.0223999999998]
["ANA","Governador Valadares","BARBOSA & MARQUES S.A","Federal","Minas Gerais","Federal","DO4","DO4",null,292800,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,4304.16,4304.16,6148.8,4304.16,4304.16]
["ANA","Governador Valadares","Samuel Santos - ME","Federal","Minas Gerais","Federal","DO4","DO4",null,64800,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,1673.7840000000001,1877.904,1360.8000000000002,1673.7840000000001,1877.904]
["ANA","Governador Valadares","Areal Torres & Carvalho Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,71280,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,1841.1624000000002,2065.6943999999999,1496.88,1841.1624000000002,2065.6943999999999]
["ANA","Governador Valadares","Areal Bela Vista Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,92160,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,2380.4928,2670.7968000000001,1935.3600000000001,2380.4928,2670.7968000000001]
["ANA","Governador Valadares","ANDERSON EMERICK DE OLIVEIRA","Federal","Minas Gerais","Federal","DO4","DO4",null,89812.800000000003,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,2319.8646240000003,2602.7749439999998,1886.0688000000002,2319.8646240000003,2602.7749439999998]
["ANA","Governador Valadares","Areal e Material de Construção São Jorge Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,202752,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,5237.0841600000003,5875.7529599999998,4257.7920000000004,5237.0841600000003,5875.7529599999998]
["ANA","Governador Valadares","LATICINIO BELA VISTA LTDA","Federal","Minas Gerais","Federal","DO4","DO4",null,221356.79999999999,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,3253.9449599999998,3253.9449599999998,4648.4928,3253.9449599999998,3253.9449599999998]
["ANA","Governador Valadares","Mafrial Matadouro e Frigorífico Ltda.","Federal","Minas Gerais","Federal","DO4","DO4",null,906660,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,15041.4894,15041.4894,19039.86,15041.4894,15041.4894]
["IGAM","Inhapim","Areal Rocha Oliveira Ltda ME","Estadual","Minas Gerais","Minas Gerais","DO5","DO5",null,1728,"Mineração",null,null,null,null,null,null,1,null,null,36.288000000000004,36.288000000000004,36.288000000000004]
["ANA","Ipaba","PORTO DE AREIA MAX LTDA - ME","Federal","Minas Gerais","Federal","DO5","DO5",null,192000,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M131*J131*$A$30","v":4959.3600000000006},{"$f":"N131*$A$30*J131","v":5564.16},4032.0000000000005,4959.3600000000006,5564.16]
["IGAM","Ipanema","Aterro e Desaterro Três Irmãos","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,0,"Mineração","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M132*J132*$A$30","v":0},{"$f":"J132*N132*$A$30","v":0},0,0,0]
["ANA","Ipanema","Fernando Francisco de Oliveira","Federal","Minas Gerais","Federal","DO6","DO6",null,17568,"Extração de Areia",null,null,null,null,null,null,1,null,null,368.928,368.928,368.928]
["ANA","Ipanema","CLAROFILITO SANTA CLARA LTDA","Federal","Minas Gerais","Federal","DO6","DO6",null,12481.92,"Extração de Areia","2349-4 - FABRICAÇÃO DE PRODUTOS CERÂMICOS NÃO-REFRATÁRIOS NÃO ESPECIFICADOS ANTERIORMENTE",0.84,0.84,null,null,null,1,{"$f":"M134*J134*$A$30","v":220.18106880000002},{"$f":"J134*N134*$A$30","v":220.18106880000002},262.12031999999999,220.18106880000002,220.18106880000002]
["ANA","Ipanema","GLEDSMAR ALVES DE CARVALHO","Federal","Minas Gerais","Federal","DO6","DO6",null,12503.04,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M135*J135*$A$30","v":322.95352320000001},{"$f":"J135*N135*$A$30","v":362.33809919999999},262.56384000000003,322.95352320000001,362.33809919999999]
["ANA","Ipanema","CARLOS ALVES CALDEIRA","Federal","Minas Gerais","Federal","DO6","DO6",null,5005.4399999999996,"Extração de Areia",null,null,null,null,null,null,1,null,null,105.11424,105.11424,105.11424]
["ANA","Ipanema","Aterro e Desaterro Três Irmãos","Federal","Minas Gerais","Federal","DO6","DO6",null,59136,"Extração de Areia",null,null,null,null,null,null,1,null,null,1241.856,1241.856,1241.856]
["IGAM","Ipatinga","CENTRALBETON LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,4646.3999999999996,"Indústria",null,null,null,null,null,null,1,null,null,97.574399999999997,97.574399999999997,97.574399999999997]
["IGAM","Ipatinga","CIPALAM INDÚSTRIA E COMÉRCIO DE LAMINADOS LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,28438.2,"Indústria","2424-5 - PRODUÇÃO DE RELAMINADOS, TREFILADOS E PERFILADOS DE AÇO",0.88,0.88,null,null,null,1,{"$f":"$A$30*M139*J139","v":525.53793600000006},{"$f":"$A$30*N139*J139","v":525.53793600000006},597.20220000000006,525.53793600000006,525.53793600000006]
["IGAM","Ipatinga","USINAS SIDERÚRGICAS DE MINAS GERAIS S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,95011392,"Indústria","2422-9 - PRODUÇÃO DE LAMINADOS PLANOS DE AÇO",0.88,0.88,93,0.3,0,0.79,{"$f":"$A$30*M140*J140","v":1755810.52416},1755810.52416,1995239.2320000001,1387090.3140864,1387090.3140864]
["IGAM","Itabira","BELMONT MINERAÇÃO LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,501566.4,"Mineração","0893-2 - EXTRAÇÃO DE GEMAS (PEDRAS PRECIOSAS E SEMIPRECIOSAS)",0.84,0.84,null,null,null,1,{"$f":"$A$30*J141*M141","v":8847.6312960000014},8847.6312959999996,10532.894400000001,8847.6312960000014,8847.6312959999996]
["IGAM","Itabira","FRIGORÍFICO MILLENIUM INDÚSTRIA E COMÉRCIO LTDA - EPP","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,19491.839,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"$A$30*J142*M142","v":323.36960901000003},323.36960901000003,409.328619,323.36960901000003,323.36960901000003]
["IGAM","Itabira","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,29323444.199000001,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"78 - 80",0.3,0,0.79,{"$f":"$A$30*J143*M143","v":504949.70910678001},843635.48960523016,615792.32817900006,398910.27019435621,666472.03678813181]
["IGAM","Itabira","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,13660584,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"79 - 80",0.3,0,0.79,{"$f":"$A$30*J144*M144","v":235235.25648000001},393015.00168000004,286872.26400000002,185835.85261920001,310481.85132720007]
["IGAM","Itabirito/Santa Barbara","MINERAÇÃO SERRAS DO OESTE","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,800149.2,"Mineração","0724-3 - EXTRAÇÃO DE MINÉRIO DE METAIS PRECIOSOS",0.95,1.36,null,null,null,1,{"$f":"$A$30*M145*J145","v":15962.976539999998},22852.261152000003,16803.1332,15962.976539999998,22852.261152000003]
["IEMA","ITAGUAÇÚ","ZILDA ANTONIA SARNAGLIA","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,113529.60000000001,"Indústria",null,null,null,null,null,null,1,null,null,2384.1216000000004,2384.1216000000004,2384.1216000000004]
["IEMA","ITARANA","JERRY ADRIANY DELBONI","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,9460.7999999999993,"Indústria",null,null,null,null,null,null,1,null,null,198.67679999999999,198.67679999999999,198.67679999999999]
["IGAM","Jaguaraçu","MATADOURO E FRIGORÍFICO PALADAR LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,0,"Indústria","1013-9 - FABRICAÇÃO DE PRODUTOS DE CARNE",0.79,0.79,null,null,null,1,{"$f":"$A$30*M148*J148","v":0},{"$f":"$A$30*N148*J148","v":0},0,0,0]
["IEMA","JAGUARÉ","ARACRUZ CELULOSE SA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,0,"Indústria",null,null,null,null,null,null,1,null,null,0,0,0]
["IEMA","JAGUARÉ","CALIXTO DAGOSTINI","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,0,"Indústria",null,null,null,null,null,null,1,null,null,0,0,0]
["IGAM","João Monlevade","ARCELOR MITTAL BRASIL S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,28143936,"Indústria","2423-7 - PRODUÇÃO DE LAMINADOS LONGOS DE AÇO",0.88,0.88,"93 - 98",0,0,0.79,{"$f":"$A$30*M151*J151","v":520099.93728000001},{"$f":"$A$30*N151*J151","v":520099.93728000001},591022.65600000008,410878.95045120001,410878.95045120001]
["IEMA","LARANJA DA TERRA","CERAMICA MODELO LTDA - ME","Estadual","Espírito Santo","Espírito Santo","Guandu","DO-ES",null,59287.68,"Indústria","2342-7 - FABRICAÇÃO DE PRODUTOS CERÂMICOS NÃO-REFRATÁRIOS PARA USO ESTRUTURAL NA CONSTRUÇÃO",0.84,0.84,null,null,null,1,{"$f":"M152*$A$30*J152","v":1045.8346752},{"$f":"$A$30*N152*J152","v":1045.8346752},1245.0412800000001,1045.8346752,1045.8346752]
["ANA","Linhares","Arebrita Santa Luzia Ltda","Federal","Espírito Santo","Federal","São José","DO-ES",null,120960,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M153*$A$30*J153","v":3124.3968000000004},{"$f":"$A$30*N153*J153","v":3505.4207999999999},2540.1600000000003,3124.3968000000004,3505.4207999999999]
["ANA","Linhares","Laticínios Limilk LTDA EPP","Federal","Espírito Santo","Federal","São José","DO-ES",null,0,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M154*$A$30*J154","v":0},{"$f":"$A$30*N154*J154","v":0},0,0,0]
["IEMA","LINHARES","ARACRUZ CELULOSE SA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",173448000,0,"Indústria",null,null,null,null,null,null,1,{"$f":"$I$155*SIMULADOR!$D$4","v":4683096},{"$f":"$I$155*SIMULADOR!$D$4","v":4683096},{"$f":"$I$155*SIMULADOR!$D$4","v":4683096},{"$f":"R155*IF(ISBLANK(S155),#REF!,S155)","v":4683096},{"$f":"R155*IF(ISBLANK(U155),#REF!,U155)","v":4683096}]
["IEMA","LINHARES","LASA LINHARES AGROINDUSTRIAL S/A","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,5257051.2,"Indústria","1931-4 - FABRICAÇÃO DE ALCOOL",1.4,1.4,null,null,null,1,{"$f":"M156*$A$30*J156","v":154557.30528},{"$f":"$A$30*N156*J156","v":154557.30528},110398.07520000001,154557.30528,154557.30528]
["IGAM","Manhuaçu","FERTILIZANTES HERINGER LTDA","Estadual","Minas Gerais",{"$f":"IF(D157=\"estadual\",E157,D157)","v":"Minas Gerais"},"DO6","DO6",null,8783.9989999999998,"Indústria"," 2013-4 - FABRICAÇÃO DE ADUBOS E FERTILIZANTES ",0.88,1.17,null,null,null,1,{"$f":"M157*J157*$A$30","v":162.32830152},{"$f":"J157*N157*$A$30","v":215.82285543},184.46397899999999,162.32830152,215.82285543]
["IGAM","Manhuaçu","CENTRALBETON LTDA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,5616,"Indústria",null,null,null,null,null,null,1,null,null,117.93600000000001,{"$f":"R158*IF(ISBLANK(S158),U158,S158)","v":117.93600000000001},{"$f":"R158*IF(ISBLANK(T158),U158,T158)","v":117.93600000000001}]
["IGAM","Mariana","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,18384912,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"71 - 80",0.3,0,0.79,{"$f":"M159*$A$30*J159","v":316588.18463999999},{"$f":"$A$30*N159*J159","v":528933.91824000003},386083.152,250104.66586559999,417857.79540960002]
["IGAM","Mariana","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,6756740.6380000003,"Indústria","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"74 - 80",0.3,0,0.79,{"$f":"M160*$A$30*J160","v":116351.07378635999},{"$f":"$A$30*N160*J160","v":194391.42815526004},{"$f":"J160*A$30","v":141891.55339800002},91917.348291224393,153569.22824265543]
["IGAM","Mariana","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,320616,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"75 - 80",0.3,0,0.79,{"$f":"M161*$A$30*J161","v":5521.0075200000001},{"$f":"$A$30*N161*J161","v":9224.1223200000004},6732.9360000000006,4361.5959407999999,7287.0566328000004]
["IGAM","Mariana","SAMARCO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,24579842.640000001,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,90,0.3,0,0.79,{"$f":"M162*$A$30*J162","v":423264.89026079996},{"$f":"$A$30*N162*J162","v":707162.07275280007},516176.69544000004,334379.26330603199,558658.03747471212]
["IGAM","Martins Soares","DALTON DIAS HERINGER","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,35100,"Indústria"," 2013-4 - FABRICAÇÃO DE ADUBOS E FERTILIZANTES ",0.88,1.17,null,null,null,1,{"$f":"M163*J163*$A$30","v":648.64800000000002},{"$f":"J163*N163*$A$30","v":862.40700000000004},737.1,648.64800000000002,862.40700000000004]
["IGAM","Mutum","LATICINIOS PORTO ALEGRE INDÚSTRIA E COMÉRCIO LTDA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,180072,"Indústria","1051-1 - PREPARAÇÃO DO LEITE",0.7,0.7,null,null,null,1,{"$f":"M164*J164*$A$30","v":2647.0583999999999},{"$f":"J164*N164*$A$30","v":2647.0583999999999},3781.5120000000002,2647.0583999999999,2647.0583999999999]
["IGAM","Mutum","TRANSPORTADORA CARMO LTDA ME","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,10454.4,"Mineração","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M165*J165*$A$30","v":270.03715200000005},{"$f":"J165*N165*$A$30","v":302.96851199999998},219.54240000000001,270.03715200000005,302.96851199999998]
["IGAM","Mutum","CARLOS LUIZ CHARPINEL DE SOUZA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,6888.96,"Indústria",null,null,null,null,null,null,1,null,null,144.66816,144.66816,144.66816]
["IGAM","Mutum","AGRODEMELLO LATICÍNIOS LTDA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,10101.6,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M167*J167*$A$30","v":148.49352000000002},{"$f":"J167*N167*$A$30","v":148.49352000000002},212.13360000000003,148.49352000000002,148.49352000000002]
["IGAM","Mutum","ICE MINERAÇÃO LTDA","Estadual","Espírito Santo","Espírito Santo","DO6","DO6",null,4942.08,"Mineração","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M168*J168*$A$30","v":127.6539264},{"$f":"J168*N168*$A$30","v":143.2214784},103.78368,127.6539264,143.2214784]
["IGAM","Ouro Preto","TOPÁZIO IMPERIAL MINERAÇÃO COMÉRCIO E INDÚSTRIA LTDA","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,507276,"Indústria","0899-1 - EXTRAÇÃO DE MINERAIS NÃO-METÁLICOS NÃO ESPECIFICADOS ANTERIORMENTE",0.84,0.84,null,null,null,1,{"$f":"M169*$A$30*J169","v":8948.3486400000002},{"$f":"$A$30*N169*J169","v":8948.3486400000002},10652.796,8948.3486400000002,8948.3486400000002]
["IGAM","Ouro Preto","VALE MANGANÊS S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,276556.91800000001,"Indústria","2412-1 - PRODUÇÃO DE FERROLIGAS",0.84,0.84,"70 - 80",0.3,0,0.79,{"$f":"M170*$A$30*J170","v":4878.4640335200002},{"$f":"$A$30*N170*J170","v":4878.4640335200002},5807.6952780000001,3853.9865864808003,3853.9865864808003]
["IGAM","Ouro Preto","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,13140864,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"72 - 80",0.3,0,0.79,{"$f":"M171*$A$30*J171","v":226285.67807999998},{"$f":"$A$30*N171*J171","v":378062.65728000004},275958.14400000003,178765.68568319999,298669.49925120006]
["IGAM","Ouro Preto","BEMIL - Beneficiamento de Minérios Ltda","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,189734.399,"Indústria","0899-1 - EXTRAÇÃO DE MINERAIS NÃO-METÁLICOS NÃO ESPECIFICADOS ANTERIORMENTE",0.84,0.84,null,null,null,1,{"$f":"M172*$A$30*J172","v":3346.9147983600001},{"$f":"$A$30*N172*J172","v":3346.9147983600001},3984.4223790000005,3346.9147983600001,3346.9147983600001]
["IEMA","PANCAS","JULIO CESAR BALMANT E ITALO GILBERTO LOOSE","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,104068.8,"Indústria",null,null,null,null,null,null,1,null,null,2185.4448000000002,2185.4448000000002,2185.4448000000002]
["ANA","Pocrane","NILTON MARQUES DE LIMA","Federal","Minas Gerais","Federal","DO6","DO6",null,12503.04,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M174*J174*$A$30","v":322.95352320000001},{"$f":"J174*N174*$A$30","v":362.33809919999999},262.56384000000003,322.95352320000001,362.33809919999999]
["IGAM","Ponte Nova","FRIGORÍFICO INDUSTRIAL VALE DO PIRANGA","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,442603.2,"Indústria","1012-1 - ABATE DE SUÍNOS, AVES E OUTROS PEQUENOS ANIMAIS",0.79,0.79,null,null,null,1,{"$f":"M175*$A$30*J175","v":7342.787088},{"$f":"$A$30*N175*J175","v":7342.787088},9294.6672000000017,7342.787088,7342.787088]
["IGAM","Reduto","PEDREIRA BOM JARDIM INDÚSTRIA E COMÉRCIO LTDA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,6332.0389999999998,"Mineração","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M176*J176*$A$30","v":163.55656736999998},{"$f":"J176*N176*$A$30","v":183.50249022},132.97281900000002,163.55656736999998,183.50249022]
["ANA","Resplendor","Gonçalo Alves Filho - ME","Federal","Minas Gerais","Federal","DO4","DO4",null,74880,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M177*$A$30*J177","v":1934.1504000000002},{"$f":"N177*$A$30*J177","v":2170.0223999999998},1572.48,1934.1504000000002,2170.0223999999998]
["ANA","Resplendor","Cooperativa Agropecuária de Resplendor Ltda","Federal","Minas Gerais","Federal","DO4","DO4",null,246391.2,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M178*$A$30*J178","v":3621.95064},{"$f":"N178*$A$30*J178","v":3621.95064},5174.2152000000006,3621.95064,3621.95064]
["IEMA","RIO BANANAL","ARACRUZ CELULOSE SA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,0,"Indústria",null,null,null,null,null,null,1,null,null,0,0,0]
["IGAM","Rio Casca","SOCIEDADE BRASILEIRA DE FERRO LIGAS LTDA","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,13267.5,"indústria","2412-1 - PRODUÇÃO DE FERROLIGAS",0.84,0.84,null,null,null,1,{"$f":"M180*$A$30*J180","v":234.03870000000001},{"$f":"$A$30*N180*J180","v":234.03870000000001},278.61750000000001,234.03870000000001,234.03870000000001]
["ANA","Rio Doce","AREIAL CANDONGA LTDA","Federal","Minas Gerais","Federal","DO1","DO1",null,12000,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M181*$A$30*J181","v":309.96000000000004},347.76,252.00000000000003,309.96000000000004,347.76]
["IGAM","Rio Piracicaba","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,7655548.7999999998,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"76 - 80",0.3,0,0.79,{"$f":"$A$30*M182*J182","v":131828.55033599999},220250.13897600002,160766.52480000001,104144.55476544,173997.60979104001]
["IGAM","Santa Bárbara","ANGLOGOLD ASHANTI CÓRREGO DO SÍTIO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,2043158.398,"Mineração","0724-3 - EXTRAÇÃO DE MINÉRIO DE METAIS PRECIOSOS",0.95,0.95,null,null,null,1,{"$f":"$A$30*M183*J183","v":40761.010040100002},40761.010040100002,42906.326358000006,40761.010040100002,40761.010040100002]
["IGAM","Santa Bárbara","ANGLOGOLD ASHANTI CÓRREGO DO SÍTIO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,962726.39899999998,"Mineração","0724-3 - EXTRAÇÃO DE MINÉRIO DE METAIS PRECIOSOS",0.95,0.95,null,null,null,1,{"$f":"$A$30*M184*J184","v":19206.391660049998},19206.391660049998,20217.254379000002,19206.391660049998,19206.391660049998]
["IGAM","Santa Bárbara","MINERAÇÃO SERRAS DO OESTE LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,1753110.72,"Mineração","0724-3 - EXTRAÇÃO DE MINÉRIO DE METAIS PRECIOSOS",0.95,0.95,null,null,null,1,{"$f":"$A$30*M185*J185","v":34974.558863999999},34974.558863999999,36815.325120000001,34974.558863999999,34974.558863999999]
["IGAM","Santa Bárbara","SAMARCO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,20978300.159000002,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,90,0.3,0,0.79,{"$f":"$A$30*M186*J186","v":361246.32873797999},603545.69557443017,440544.30333900009,285384.59970300418,476801.09950379987]
["ANA","Santa Cruz do Escalvado","José Geraldo Lima Lana-ME","Federal","Minas Gerais","Federal","DO1","DO1",null,40320,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M187*$A$30*J187","v":1041.4656},1168.4736,846.72,1041.4656,1168.4736]
["ANA","Santa Cruz do Escalvado","Alex Rodrigues Soares","Federal","Minas Gerais","Federal","DO1","DO1",null,8960,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M188*$A$30*J188","v":231.43680000000003},259.66079999999999,188.16000000000003,231.43680000000003,259.66079999999999]
["IEMA","SANTA TERESA","ROSANY ZANOTTI ROLDI","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,113529.60000000001,"Indústria",null,null,null,null,null,null,1,null,null,2384.1216000000004,2384.1216000000004,2384.1216000000004]
["IGAM","Santana do Paraíso","MATADOURO RIO DOCE LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,89304,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"$A$30*J190*M190","v":1481.5533600000001},{"$f":"$A$30*N190*J190","v":1481.5533600000001},1875.384,1481.5533600000001,1481.5533600000001]
["IGAM","Santana do Paraíso","LUMAR METALURGICA LIDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,11206.92,"Indústria","2452-1 - FUNDIÇÃO DE METAIS NÃO-FERROSOS E SUAS LIGAS",0.84,0.84,null,null,null,1,{"$f":"$A$30*J191*M191","v":197.69006880000001},197.69006880000001,235.34532000000002,197.69006880000001,197.69006880000001]
["IGAM","Santana do Paraíso","FRIGORÍFICO PARAÍSO LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,42602.398999999998,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"$A$30*J192*M192","v":706.77379941000004},706.77379941000004,894.65037900000004,706.77379941000004,706.77379941000004]
["IGAM","Santana do Paraíso","ORTHOFLEX INDÚSTRIA E COMÉRCIO DE COLCHÕES LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,10980,"Indústria","3104-7 - FABRICAÇÃO DE COLCHÕES",0,0,null,null,null,1,null,0,230.58,230.58,0]
["IGAM","Santana do Paraíso","PRESERVAR MADEIRA REFLORESTADA LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,17568,"Indústria","1610-2 - DESDOBRAMENTO DE MADEIRA",0,0,null,null,null,1,null,0,368.928,368.928,0]
["IGAM","Santana do Paraíso","USINAS SIDERÚRGICAS DE MINAS GERAIS S/A USIMINAS","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,9150,"Indústria","3031-8 - FABRICAÇÃO DE LOCOMOTIVAS, VAGÕES E OUTROS MATERIAIS RODANTES",0,0,93,0.3,0,0.79,null,0,192.15,151.79850000000002,0]
["IGAM","Santana do Paraíso","USIMINAS MECÂNICA S/A","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,1098,"Indústria","3031-8 - FABRICAÇÃO DE LOCOMOTIVAS, VAGÕES E OUTROS MATERIAIS RODANTES",0,0,93,0.3,0,0.79,null,0,23.058,18.215820000000001,0]
["IGAM","Santana do Paraíso","LAMINAÇÃO PARAÍSO LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,38287.26,"Indústria",null,null,null,null,null,null,1,null,null,804.03246000000013,804.03246000000013,804.03246000000013]
["ANA","Santana do Paraíso","MATADOURO RIO DOCE LTDA","Federal","Minas Gerais","Federal","DO3","DO3",null,3660,"Indústria","1011-2 - ABATE DE RESES, EXCETO SUÍNOS",0.79,0.79,null,null,null,1,{"$f":"$A$30*J198*M198","v":60.7194},{"$f":"$A$30*N198*J198","v":60.7194},76.86,60.7194,60.7194]
["ANA","Santana do Paraíso","INTERCEMENT BRASIL S/A","Federal","Minas Gerais","Federal","DO3","DO3",null,73200,"Indústria",null,null,null,null,null,null,1,{"$f":"$A$30*J199*M199","v":0},{"$f":"$A$30*N199*J199","v":0},1537.2,0,0]
["IGAM","Santo Antônio do Grama","ANGLO FERROUS MINAS RIO MINERAÇÃO S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,257371.19699999999,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"80 - 90",0.3,0,0.79,{"$f":"M200*$A$30*J200","v":4431.9320123399993},{"$f":"$A$30*N200*J200","v":7404.5693376900008},5404.7951370000001,3501.2262897485998,5849.6097767751007]
["IEMA","SÃO DOMINGOS DO NORTE","AVELINO LEOPOLDINO","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,173448,"Indústria",null,null,null,null,null,null,1,null,null,3642.4080000000004,3642.4080000000004,3642.4080000000004]
["IEMA","SÃO DOMINGOS DO NORTE","G3 LAVANDERIA LTDA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,189216,"Indústria",null,null,null,null,null,null,1,null,null,3973.5360000000001,3973.5360000000001,3973.5360000000001]
["IEMA","SÃO DOMINGOS DO NORTE","INDUSTRIA DE CACHAÃA BOA SORTE - ME","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,34689.599999999999,"Indústria","1111-9 - FABRICAÇÃO DE AGUARDENTES E OUTRAS BEBIDAS DESTILADAS",0.97,0.97,null,null,null,1,{"$f":"M203*$A$30*J203","v":706.62715199999991},{"$f":"$A$30*N203*J203","v":706.62715199999991},728.48160000000007,706.62715199999991,706.62715199999991]
["IGAM","São Domingos do Prata","FAZENDA SEARA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,480,"Mineração",null,null,null,null,null,null,1,null,null,10.08,10.08,10.08]
["ANA","São Domingos do Prata","Transgraças Ltda","Federal","Minas Gerais","Federal","DO2","DO2",null,22500,"Extração de Areia",null,null,null,null,null,null,1,null,null,472.50000000000006,472.50000000000006,472.50000000000006]
["ANA","São Domingos do Prata","Paulo Cezar Lopes Correa & Cia Ltda","Federal","Minas Gerais","Federal","DO2","DO2",null,69120,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"$A$30*M206*J206","v":1785.3696000000002},{"$f":"$A$30*N206*J206","v":2003.0975999999998},1451.52,1785.3696000000002,2003.0975999999998]
["ANA","São Domingos do Prata","Mineração E & E Ltda - ME","Federal","Minas Gerais","Federal","DO2","DO2",null,20000,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"$A$30*M207*J207","v":516.6},{"$f":"$A$30*N207*J207","v":579.6},420,516.6,579.6]
["IEMA","SÃO GABRIEL DA PALHA","LAVANDERIA COMBONI - LTDA - ME","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,362664,"Indústria",null,null,null,null,null,null,1,null,null,7615.9440000000004,7615.9440000000004,7615.9440000000004]
["IEMA","SÃO GABRIEL DA PALHA","LAVANDERIA REAL LTDA - ME","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,116683.2,"Indústria",null,null,null,null,null,null,1,null,null,2450.3472000000002,2450.3472000000002,2450.3472000000002]
["IEMA","SÃO GABRIEL DA PALHA","VALDIR PINTO CEZAR","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,94608,"Indústria",null,null,null,null,null,null,1,null,null,1986.768,1986.768,1986.768]
["IGAM","São Geraldo","LATICÍNIO MONTE CELESTE LTDA","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,4392,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M211*$A$30*J211","v":64.562399999999997},{"$f":"$A$30*N211*J211","v":64.562399999999997},92.231999999999999,64.562399999999997,64.562399999999997]
["IGAM","São Gonçalo do Rio Abaixo","VALE S/A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,22341869.760000002,"Mineração","0710-3 - EXTRAÇÃO DE MINÉRIO DE FERRO",0.82,1.37,"77 - 80",0.3,0,0.79,{"$f":"$A$30*M212*J212","v":384726.99726720003},{"$f":"$A$30*N212*J212","v":642775.59299520019},469179.26496000006,303934.32784108806,507792.7184662082]
["IGAM","São João do Manhuaçu","JOÃO ALVES COSTA","Estadual","Minas Gerais","Minas Gerais","DO6","DO6",null,3240,"Indústria",null,null,null,null,null,null,1,null,null,68.040000000000006,68.040000000000006,68.040000000000006]
["ANA","São José do Mantimento","EXTRAÇÃO DE AREIA GOMES E GOMES LTDA","Federal","Minas Gerais","Federal","DO6","DO6",null,12503.04,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M214*J214*$A$30","v":322.95352320000001},{"$f":"J214*N214*$A$30","v":362.33809919999999},262.56384000000003,322.95352320000001,362.33809919999999]
["IEMA","SÃO MATEUS","PETRËLEO BRASILEIRO S.A - PETROBRAS","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,132451.20000000001,"Mineração","0600-0 - EXTRAÇÃO DE PETRÓLEO E GÁS NATURAL",0,0,null,null,null,1,null,null,2781.4752000000003,2781.4752000000003,2781.4752000000003]
["IEMA","SÃO MATEUS","PETRËLEO BRASILEIRO S.A - PETROBRAS","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,132451.20000000001,"Mineração","0600-0 - EXTRAÇÃO DE PETRÓLEO E GÁS NATURAL",0,0,null,null,null,1,null,null,2781.4752000000003,2781.4752000000003,2781.4752000000003]
["IEMA","SÃO ROQUE DO CANAÃ","AGUARDENTE GUARACY LTDA","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,173448,"Indústria","1111-9 - FABRICAÇÃO DE AGUARDENTES E OUTRAS BEBIDAS DESTILADAS",0.97,0.97,null,null,null,1,{"$f":"M217*$A$30*J217","v":3533.1357599999997},{"$f":"$A$30*N217*J217","v":3533.1357599999997},3642.4080000000004,3533.1357599999997,3533.1357599999997]
["IEMA","SÃO ROQUE DO CANAÃ","ALCEBIADES CALCCI","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,69379.199999999997,"Indústria",null,null,null,null,null,null,1,null,null,1456.9632000000001,1456.9632000000001,1456.9632000000001]
["IEMA","SÃO ROQUE DO CANAÃ","CERAMICA SANTA MARIA LTDA- EPP","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,315360,"Indústria","2342-7 - FABRICAÇÃO DE PRODUTOS CERÂMICOS NÃO-REFRATÁRIOS PARA USO ESTRUTURAL NA CONSTRUÇÃO",0.84,0.84,null,null,null,1,{"$f":"M219*$A$30*J219","v":5562.9503999999997},{"$f":"$A$30*N219*J219","v":5562.9503999999997},6622.56,5562.9503999999997,5562.9503999999997]
["IEMA","SÃO ROQUE DO CANAÃ","JO├O CALSSE-ME","Estadual","Espírito Santo","Espírito Santo","DO-ES","DO-ES",null,122990.39999999999,"Indústria",null,null,null,null,null,null,1,null,null,2582.7984000000001,2582.7984000000001,2582.7984000000001]
["ANA","Sem-Peixe","R & C Autolocmaq Comércio Extração e Serviços Ltda","Federal","Minas Gerais",{"$f":"IF(D221=\"estadual\",E221,D221)","v":"Federal"},"DO1","DO1",null,145463.04000000001,"Extração de Areia",null,null,null,null,null,null,1,{"$f":"M221*$A$30*J221","v":0},{"$f":"$A$30*N221*J221","v":0},3054.7238400000006,0,0]
["IGAM","Serro","COOPERATIVA DOS PRODUTORES RURAIS DO SERRO LTDA","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,21960,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"$A$30*J222*M222","v":322.81200000000001},{"$f":"$A$30*N222*J222","v":322.81200000000001},461.16,{"$f":"R222*IF(ISBLANK(S222),U222,S222)","v":322.81200000000001},{"$f":"R222*IF(ISBLANK(T222),U222,T222)","v":322.81200000000001}]
["IGAM","Serro","CACHAÇA VELHA SERRANA LTDA ME","Estadual","Minas Gerais","Minas Gerais","DO3","DO3",null,9223.2000000000007,"Indústria","1111-9 - FABRICAÇÃO DE AGUARDENTES E OUTRAS BEBIDAS DESTILADAS",0.97,0.97,null,null,null,1,{"$f":"$A$30*J223*M223","v":187.87658400000001},{"$f":"$A$30*N223*J223","v":187.87658400000001},193.68720000000002,187.87658400000001,187.87658400000001]
["ANA","Taparuba","CERÂMICA DUARTE E OLIVEIRA LTDA.","Federal","Minas Gerais","Federal","DO6","DO6",null,10771.2,"Mineração",null,null,null,null,null,null,1,null,null,{"$f":"J224*A$30","v":226.19520000000003},226.19520000000003,226.19520000000003]
["ANA","Taparuba","JGA Extração e Comércio de Areia Ltda","Federal","Minas Gerais","Federal","DO6","DO6",null,12499.977000000001,"Extração de Areia",null,null,null,null,null,null,1,null,null,262.49951700000003,262.49951700000003,262.49951700000003]
["ANA","Taparuba","Evaldo Lúcio de Souza","Federal","Minas Gerais","Federal","DO6","DO6",null,4752,"Extração de Areia","0810-0 - EXTRAÇÃO DE PEDRA, AREIA E ARGILA",1.23,1.38,null,null,null,1,{"$f":"M226*J226*$A$30","v":122.74416000000001},{"$f":"J226*N226*$A$30","v":137.71295999999998},99.792000000000002,122.74416000000001,137.71295999999998]
["IGAM","Timóteo","HARSCO MINERAIS LTDA","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,276696,"Mineração",null,null,null,null,null,null,1,null,null,5810.616,5810.616,5810.616]
["IGAM","Timóteo","APERAM INOX AMÉRICA DO SUL S.A","Estadual","Minas Gerais","Minas Gerais","DO2","DO2",null,17392320,"Indústria","2422-9 - PRODUÇÃO DE LAMINADOS PLANOS DE AÇO",0.88,0.88,null,null,null,1,{"$f":"$A$30*M228*J228","v":321410.0736},{"$f":"$A$30*N228*J228","v":321410.0736},365238.72000000003,321410.0736,321410.0736]
["IGAM","Viçosa","INDÚSTRIA DE COSMETICO HASKELL LTDA","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,11214.237999999999,"Indústria"," 2063-1 - FABRICAÇÃO DE COSMÉTICOS, PRODUTOS DE PERFUMARIA E DE HIGIENE PESSOAL ",1.03,1.03,null,null,null,1,{"$f":"M229*$A$30*J229","v":242.56396794000003},{"$f":"$A$30*N229*J229","v":242.56396794000003},235.498998,242.56396794000003,242.56396794000003]
["IGAM","Viçosa","LATICÍNIOS MINAS COLONIAL LTDA ME","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,10248,"Indústria","1052-0 - FABRICAÇÃO DE LATICÍNIOS",0.7,0.7,null,null,null,1,{"$f":"M230*$A$30*J230","v":150.6456},{"$f":"$A$30*N230*J230","v":150.6456},215.20800000000003,150.6456,150.6456]
["IGAM","Viçosa","RIO DA MATA EMPREENDIMENTOS E PARTICIPAÇÕES S/A","Estadual","Minas Gerais","Minas Gerais","DO1","DO1",null,46116,"Indústria",null,null,null,null,null,null,1,null,null,968.43600000000004,968.43600000000004,968.43600000000004]
["IEMA","VILA VALÉRIO","ARACRUZ CELULOSE SA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,0,"Indústria",null,null,null,null,null,null,1,null,null,0,0,0]
["IEMA","VILA VALÉRIO","ARACRUZ CELULOSE SA","Estadual","Espírito Santo","Espírito Santo","São José","DO-ES",null,0,"Indústria",null,null,null,null,null,null,1,null,null,0,0,0]

{"sheet":"Base de dados Irrigação","index":3,"n_rows":71,"n_cols":27,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,2,6],[36,14,36,26],[37,14,37,26],[62,0,62,12],[17,1,17,2],[30,0,30,12],[31,0,31,12],[41,0,41,12],[51,0,51,12],[52,0,52,12],[57,14,57,26],[58,14,58,26]]}
[null,"OS VALORES DE ARRECADAÇÃO DESTA PLANILHA DEPENDEM DO PPu DE CAPTAÇÃO INFORMADO NA PLANILHA SIMULADOR"]
[]
[]
[]
[null,"Coeficiente multiplicador","UPGRH","Arrecadação Total com Fator Multiplicador",null,"Rótulos de Linha","Soma de Arrecadação Total com Fator Multiplicador"]
[null,1.4,"DO1",{"$f":"(H19+J19)*B$6","v":38538.049279527004},null,"DO1",38538.049279527004]
[null,null,"DO2",{"$f":"(H20+J20)*B$6","v":25179.070912077601},null,"DO2",25179.070912077601]
[null,null,"DO3",{"$f":"(H21+J21)*B$6","v":4032.4972122162003},null,"DO3",4032.4972122162003]
[null,null,"DO4",{"$f":"(H22+J22)*B$6","v":14353.656380179198},null,"DO4",14353.656380179198]
[null,null,"DO5",{"$f":"(H23+J23)*B$6","v":33394.4040123288},null,"DO5",33394.4040123288]
[null,null,"DO6",{"$f":"(H24+J24)*B$6","v":64932.007856284792},null,"DO6",64932.007856284792]
[null,null,"DO-ES",{"$f":"(H25+J25+H26+J26+H27+J27)*B$6","v":898985.69205423293},null,"DO-ES",898985.69205423293]
[null,null,null,null,null,"Total geral",1079415.3777068465]
[]
[]
[]
[]
["PPU","Kt",null,"Nsi","Área Perm","Área Temp","Área Total","Perm Super     ","Perm sub","Temp Super     ","Temp sub","Arrec. Doce Superficial","Arrec. Doce Subterrânea"]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO1",1.4999999999999999E-2,2052000,25,10282,null,{"$f":"SUM(P40*D19*P40/B34,Q40*D19*Q40/C34,R40*D19*R40/D34,S40*D19*S40/E34,T40*D19*T40/F34,U40*D19*U40/G34,V40*D19*V40/H34,W40*D19*W40/I34,X40*D19*X40/J34,Y40*D19*Y40/K34,Z40*D19*Z40/L34,AA40*D19*AA40/M34)*(A19*C19*E19)/1000","v":42.317690625000004},{"$f":"SUM(P40*D19*P40/B44,Q40*D19*Q40/C44,R40*D19*R40/D44,S40*D19*S40/E44,T40*D19*T40/F44,U40*D19*U40/G44,V40*D19*V40/H44,W40*D19*W40/I44,X40*D19*X40/J44,Y40*D19*Y40/K44,Z40*D19*Z40/L44,AA40*D19*AA40/M44)*(A19*C19*E19)/1000","v":48.809769750000001},{"$f":"SUM(P61*D19*P61/B55,Q61*D19*Q61/C55,R61*D19*R61/D55,S61*D19*S61/E55,T61*D19*T61/F55,U61*D19*U61/G55,V61*D19*V61/H55,W61*D19*W61/I55,X61*D19*X61/J55,Y61*D19*Y61/K55,Z61*D19*Z61/L55,AA61*D19*AA61/M55)*(A19*C19*F19)/1000","v":27484.860366180004},{"$f":"SUM(P61*D19*P61/B65,Q61*D19*Q61/C65,R61*D19*R61/D65,S61*D19*S61/E65,T61*D19*T61/F65,U61*D19*U61/G65,V61*D19*V61/H65,W61*D19*W61/I65,X61*D19*X61/J65,Y61*D19*Y61/K65,Z61*D19*Z61/L65,AA61*D19*AA61/M65)*(A19*C19*F19)/1000","v":28299.005063280001},{"$f":"SUM(H29,J29)","v":771010.98407631903},{"$f":"SUM(I29,K29)","v":800558.52012485988}]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO2",2.9000000000000001E-2,2052000,1,3483,{"$f":"E20+F20","v":3484},3.3981597090000006,3.7852443720000006,17981.652491775003,18674.803029582003]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO3",1.2999999999999999E-2,2052000,321,971,1292,523.55441993399995,581.18766451200008,2356.8007316490002,2431.7298876780001]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO4",1.4E-2,2052000,60,3336,3396,124.86251736000003,132.13817064000003,10127.749182768001,10353.660026976]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO5",1.4E-2,2052000,191,7654,7845,403.98939604800006,425.30657752800005,23449.156327044002,24032.124078984005]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"DO6",3.3000000000000002E-2,2052000,1344,5552,6896,6602.2969985279997,6947.2715558399996,39777.708613103998,40869.212253407997]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"Guandu",2.7E-2,2052000,29187,75407,104594,{"$f":"SUM($P$46*D25*$P$46/$B$40,$Q$46*D25*$Q$46/$C$40,$R$46*D25*$R$46/$D$40,$S$46*D25*$S$46/$E$40,$T$46*D25*$T$46/$F$40,$U$46*D25*$U$46/$G$40,$V$46*D25*$V$46/$H$40,$W$46*D25*$W$46/$I$40,$X$46*D25*$X$46/$J$40,$Y$46*D25*$Y$46/$K$40,$Z$46*D25*$Z$46/$L$40,$AA$46*D25*$AA$46/$M$40)*(A25*C25*E25)/1000","v":119738.05007320801},{"$f":"SUM($P$46*D25*$P$46/$B$50,$Q$46*D25*$Q$46/$C$50,$R$46*D25*$R$46/$D$50,$S$46*D25*$S$46/$E$50,$T$46*D25*$T$46/$F$50,$U$46*D25*$U$46/$G$50,$V$46*D25*$V$46/$H$50,$W$46*D25*$W$46/$I$50,$X$46*D25*$X$46/$J$50,$Y$46*D25*$Y$46/$K$50,$Z$46*D25*$Z$46/$L$50,$AA$46*D25*$AA$46/$M$50)*(A25*C25*E25)/1000","v":129467.19112425001},{"$f":"SUM($P$67*D25*$P$67/$B$61,$Q$67*D25*$Q$67/$C$61,$R$67*D25*$R$67/$D$61,$S$67*D25*$S$67/$E$61,$T$67*D25*$T$67/$F$61,$U$67*D25*$U$67/$G$61,$V$67*D25*$V$67/$H$61,$W$67*D25*$W$67/$I$61,$X$67*D25*$X$67/$J$61,$Y$67*D25*$Y$67/$K$61,$Z$67*D25*$Z$67/$L$61,$AA$67*D25*$AA$67/$M$61)*(A25*C25*F25)/1000","v":465937.79084477102},{"$f":"SUM($P$67*D25*$P$67/$B$71,$Q$67*D25*$Q$67/$C$71,$R$67*D25*$R$67/$D$71,$S$67*D25*$S$67/$E$71,$T$67*D25*$T$67/$F$71,$U$67*D25*$U$67/$G$71,$V$67*D25*$V$67/$H$71,$W$67*D25*$W$67/$I$71,$X$67*D25*$X$67/$J$71,$Y$67*D25*$Y$67/$K$71,$Z$67*D25*$Z$67/$L$71,$AA$67*D25*$AA$67/$M$71)*(A25*C25*F25)/1000","v":479646.35928039596}]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"Sta Maria do Doce",1.2E-2,2052000,1418,9189,10607,{"$f":"SUM($P$46*D26*$P$46/$B$40,$Q$46*D26*$Q$46/$C$40,$R$46*D26*$R$46/$D$40,$S$46*D26*$S$46/$E$40,$T$46*D26*$T$46/$F$40,$U$46*D26*$U$46/$G$40,$V$46*D26*$V$46/$H$40,$W$46*D26*$W$46/$I$40,$X$46*D26*$X$46/$J$40,$Y$46*D26*$Y$46/$K$40,$Z$46*D26*$Z$46/$L$40,$AA$46*D26*$AA$46/$M$40)*(A26*C26*E26)/1000","v":2585.451742272},{"$f":"SUM($P$46*D26*$P$46/$B$50,$Q$46*D26*$Q$46/$C$50,$R$46*D26*$R$46/$D$50,$S$46*D26*$S$46/$E$50,$T$46*D26*$T$46/$F$50,$U$46*D26*$U$46/$G$50,$V$46*D26*$V$46/$H$50,$W$46*D26*$W$46/$I$50,$X$46*D26*$X$46/$J$50,$Y$46*D26*$Y$46/$K$50,$Z$46*D26*$Z$46/$L$50,$AA$46*D26*$AA$46/$M$50)*(A26*C26*E26)/1000","v":2795.5288619999997},{"$f":"SUM($P$67*D26*$P$67/$B$61,$Q$67*D26*$Q$67/$C$61,$R$67*D26*$R$67/$D$61,$S$67*D26*$S$67/$E$61,$T$67*D26*$T$67/$F$61,$U$67*D26*$U$67/$G$61,$V$67*D26*$V$67/$H$61,$W$67*D26*$W$67/$I$61,$X$67*D26*$X$67/$J$61,$Y$67*D26*$Y$67/$K$61,$Z$67*D26*$Z$67/$L$61,$AA$67*D26*$AA$67/$M$61)*(A26*C26*F26)/1000","v":25234.924314852},{"$f":"SUM($P$67*D26*$P$67/$B$71,$Q$67*D26*$Q$67/$C$71,$R$67*D26*$R$67/$D$71,$S$67*D26*$S$67/$E$71,$T$67*D26*$T$67/$F$71,$U$67*D26*$U$67/$G$71,$V$67*D26*$V$67/$H$71,$W$67*D26*$W$67/$I$71,$X$67*D26*$X$67/$J$71,$Y$67*D26*$Y$67/$K$71,$Z$67*D26*$Z$67/$L$71,$AA$67*D26*$AA$67/$M$71)*(A26*C26*F26)/1000","v":25977.372542351997}]
[{"$f":"SIMULADOR!$B$4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},"São José",1.2E-2,2052000,4170,7659,11829,{"$f":"SUM($P$46*D27*$P$46/$B$40,$Q$46*D27*$Q$46/$C$40,$R$46*D27*$R$46/$D$40,$S$46*D27*$S$46/$E$40,$T$46*D27*$T$46/$F$40,$U$46*D27*$U$46/$G$40,$V$46*D27*$V$46/$H$40,$W$46*D27*$W$46/$I$40,$X$46*D27*$X$46/$J$40,$Y$46*D27*$Y$46/$K$40,$Z$46*D27*$Z$46/$L$40,$AA$46*D27*$AA$46/$M$40)*(A27*C27*E27)/1000","v":7603.1972956799991},{"$f":"SUM($P$46*D27*$P$46/$B$50,$Q$46*D27*$Q$46/$C$50,$R$46*D27*$R$46/$D$50,$S$46*D27*$S$46/$E$50,$T$46*D27*$T$46/$F$50,$U$46*D27*$U$46/$G$50,$V$46*D27*$V$46/$H$50,$W$46*D27*$W$46/$I$50,$X$46*D27*$X$46/$J$50,$Y$46*D27*$Y$46/$K$50,$Z$46*D27*$Z$46/$L$50,$AA$46*D27*$AA$46/$M$50)*(A27*C27*E27)/1000","v":8220.9840299999996},{"$f":"SUM($P$67*D27*$P$67/$B$61,$Q$67*D27*$Q$67/$C$61,$R$67*D27*$R$67/$D$61,$S$67*D27*$S$67/$E$61,$T$67*D27*$T$67/$F$61,$U$67*D27*$U$67/$G$61,$V$67*D27*$V$67/$H$61,$W$67*D27*$W$67/$I$61,$X$67*D27*$X$67/$J$61,$Y$67*D27*$Y$67/$K$61,$Z$67*D27*$Z$67/$L$61,$AA$67*D27*$AA$67/$M$61)*(A27*C27*F27)/1000","v":21033.222910811997},{"$f":"SUM($P$67*D27*$P$67/$B$71,$Q$67*D27*$Q$67/$C$71,$R$67*D27*$R$67/$D$71,$S$67*D27*$S$67/$E$71,$T$67*D27*$T$67/$F$71,$U$67*D27*$U$67/$G$71,$V$67*D27*$V$67/$H$71,$W$67*D27*$W$67/$I$71,$X$67*D27*$X$67/$J$71,$Y$67*D27*$Y$67/$K$71,$Z$67*D27*$Z$67/$L$71,$AA$67*D27*$AA$67/$M$71)*(A27*C27*F27)/1000","v":21652.050963312002}]
[null,null,null,null,{"$f":"SUM(E19:E27)","v":36717},{"$f":"SUM(F19:F27)","v":123533}]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H27)","v":137627.11829336401},{"$f":"SUM(I19:I27)","v":148622.202998892},{"$f":"SUM(J19:J27)","v":633383.86578295496},{"$f":"SUM(K19:K27)","v":651936.31712596794}]
[]
["Culturas Permanentes"]
["Equação - Café (L s-1 ha-1) *         Captação Superficial (0,4)"]
[1.1000000000000001,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez"]
["DO1",0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.48,0.4,0.4,0.4,0.4]
["DO2",0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.49,0.44,0.4,0.4,0.4]
["DO3",0.4,0.4,0.4,0.4,0.4,0.4,0.42,0.52,0.49,0.4,0.4,0.4]
["DO4",0.4,0.4,0.4,0.42,0.4,0.4,0.41,0.51,0.5,0.4,0.4,0.4,null,"Culturas Permanentes - q outorgada"]
["DO5",0.4,0.4,0.4,0.41,0.4,0.4,0.41,0.5,0.49,0.4,0.4,0.4,null,"Equação - Café (L s-1 ha-1) "]
["DO6",0.4,0.41,0.4,0.4,0.4,0.4,0.41,0.49,0.48,0.4,0.4,0.4,null,1.1000000000000001,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez"]
["DO-ES",0.4,0.47,0.4,0.42,0.4,0.4,0.4,0.46,0.46,0.4,0.4,0.4,null,"DO1",0,0.22,0.19,0.36,0.34,0.36,0.39,0.48,0.4,0.28999999999999998,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO2",0,0.17,0.17,0.36,0.35,0.37,0.4,0.49,0.44,0.33,0,0]
["Equação - Café (L s-1 ha-1) *        Captação Subterrânea (0,2)",null,null,null,null,null,null,null,null,null,null,null,null,null,"DO3",0,0.2,0.18,0.34,0.37,0.39,0.42,0.52,0.49,0.34,0,0]
[1.1000000000000001,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez",null,"DO4",0.09,0.36,0.28000000000000003,0.42,0.4,0.39,0.41,0.51,0.5,0.34,0,0]
["DO1",0.2,0.22,0.2,0.36,0.34,0.36,0.39,0.48,0.4,0.28999999999999998,0.2,0.2,null,"DO5",0.11,0.38,0.31,0.41,0.38,0.37,0.41,0.5,0.49,0.38,0.01,0]
["DO2",0.2,0.2,0.2,0.36,0.35,0.37,0.4,0.49,0.44,0.33,0.2,0.2,null,"DO6",0.09,0.41,0.28000000000000003,0.4,0.38,0.38,0.41,0.49,0.48,0.36,0.03,0]
["DO3",0.2,0.2,0.2,0.34,0.37,0.39,0.42,0.52,0.49,0.34,0.2,0.2,null,"DO-ES",0.2,0.47,0.32,0.42,0.39,0.37,0.37,0.46,0.46,0.34,0.05,0]
["DO4",0.2,0.36,0.28000000000000003,0.42,0.4,0.39,0.41,0.51,0.5,0.34,0.2,0.2]
["DO5",0.2,0.38,0.31,0.41,0.38,0.37,0.41,0.5,0.49,0.38,0.2,0.2]
["DO6",0.2,0.41,0.28000000000000003,0.4,0.38,0.38,0.41,0.49,0.48,0.36,0.2,0.2]
["DO-ES",0.2,0.47,0.32,0.42,0.39,0.37,0.37,0.46,0.46,0.34,0.2,0.2]
[]
["Culturas Temporárias"]
["Equação - Cana (L s-1 ha-1) *        Captação Superficial (0,4)"]
[1.25,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez"]
["DO1",0.4,0.4,0.4,0.5,0.46,0.48,0.52,0.64,0.55000000000000004,0.43,0.4,0.4]
["DO2",0.4,0.4,0.4,0.5,0.47,0.49,0.53,0.65,0.6,0.47,0.4,0.4]
["DO3",0.4,0.4,0.4,0.47,0.5,0.51,0.55000000000000004,0.68,0.66,0.48,0.4,0.4]
["DO4",0.4,0.52,0.42,0.56999999999999995,0.53,0.52,0.54,0.67,0.67,0.48,0.4,0.4,null,"Culturas Temporarias - q outorgada"]
["DO5",0.4,0.54,0.45,0.56000000000000005,0.51,0.49,0.54,0.65,0.66,0.53,0.4,0.4,null,"Equação - Cana (L s-1 ha-1) "]
["DO6",0.4,0.57999999999999996,0.42,0.55000000000000004,0.51,0.5,0.54,0.65,0.65,0.5,0.4,0.4,null,1.25,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez"]
["DO-ES",0.4,0.66,0.47,0.57999999999999996,0.53,0.5,0.49,0.61,0.62,0.48,0.4,0.4,null,"DO1",0,0.35,0.31,0.5,0.46,0.48,0.52,0.64,0.55000000000000004,0.43,0.06,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO2",0,0.3,0.28000000000000003,0.5,0.47,0.49,0.53,0.65,0.6,0.47,0.01,0]
["Equação - Cana (L s-1 ha-1) *        Captação Subterrânea (0,2)",null,null,null,null,null,null,null,null,null,null,null,null,null,"DO3",0.01,0.33,0.28999999999999998,0.47,0.5,0.51,0.55000000000000004,0.68,0.66,0.48,0,0]
[1.25,"jan","fev","mar","abr","mai","jun","jul","ago","set","out","nov","dez",null,"DO4",0.2,0.52,0.42,0.56999999999999995,0.53,0.52,0.54,0.67,0.67,0.48,7.0000000000000007E-2,0]
["DO1",0.2,0.35,0.31,0.5,0.46,0.48,0.52,0.64,0.55000000000000004,0.43,0.2,0.2,null,"DO5",0.22,0.54,0.45,0.56000000000000005,0.51,0.49,0.54,0.65,0.66,0.53,0.1,0.03]
["DO2",0.2,0.3,0.28000000000000003,0.5,0.47,0.49,0.53,0.65,0.6,0.47,0.2,0.2,null,"DO6",0.2,0.57999999999999996,0.42,0.55000000000000004,0.51,0.5,0.54,0.65,0.65,0.5,0.12,0.03]
["DO3",0.2,0.33,0.28999999999999998,0.47,0.5,0.51,0.55000000000000004,0.68,0.66,0.48,0.2,0.2,null,"DO-ES",0.33,0.66,0.47,0.57999999999999996,0.53,0.5,0.49,0.61,0.62,0.48,0.15,0.13]
["DO4",0.2,0.52,0.42,0.56999999999999995,0.53,0.52,0.54,0.67,0.67,0.48,0.2,0.2]
["DO5",0.22,0.54,0.45,0.56000000000000005,0.51,0.49,0.54,0.65,0.66,0.53,0.2,0.2]
["DO6",0.2,0.57999999999999996,0.42,0.55000000000000004,0.51,0.5,0.54,0.65,0.65,0.5,0.2,0.2]
["DO-ES",0.33,0.66,0.47,0.57999999999999996,0.53,0.5,0.49,0.61,0.62,0.48,0.2,0.2]

{"sheet":"Base de Dados Saneamento","index":4,"n_rows":290,"n_cols":22,"rows_kept":290,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"Rótulos de Coluna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"Soma de CAPTAÇÃO DE ÁGUA 1.0 (R$)",null,"Soma de LANÇAMENTO ESGOTO 1.0 (R$)",null,"Total Soma de CAPTAÇÃO DE ÁGUA 1.0 (R$)","Total Soma de LANÇAMENTO ESGOTO 1.0 (R$)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Rótulos de Linha","Estadual","Federal","Estadual","Federal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO1",959612.77458899969,null,1078254.3349428002,null,959612.77458899969,1078254.3349428002,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO2",1159670.6884013999,964434.36095999996,1180263.3447266999,982061.10395999986,2124105.0493613998,2162324.4486866998,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO3",340511.81093999994,null,360040.56991279998,null,340511.81093999994,360040.56991279998,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO4",367066.79973600013,661358.77920000011,299894.12844359991,652307.30000000005,1028425.5789360002,952201.42844359996,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO5",221744.05757280003,null,124586.99762919999,null,221744.05757280003,124586.99762919999,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["DO6",185742.73229400002,null,113326.09453399999,null,185742.73229400002,113326.09453399999,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["ES",41583.909748500009,272036.92934249999,60979.689999999995,306964.54403999995,313620.83909100003,367944.23403999995,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Total geral",3275932.7732817,1897830.0695024999,3217345.1601891005,1941332.9479999999,5173762.8427841989,5158678.1081891004,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Ppu Captação","Ppu Lançamento",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[{"$f":"SIMULADOR!B4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":2.1000000000000001E-2},{"$f":"SIMULADOR!C4*IF(ISBLANK(SIMULADOR!$E$4),1,IF(SIMULADOR!$E$4=0,1,1-SIMULADOR!$E$4))","v":1.825},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"ORIGINAL (Multiplicado por 0,021)","ORIGINAL (Multiplicado por 1,825)"]
["MUNICÍPIO","Código Cidades","Domiialidade","UPGRH","CONCESSIONÁRIA","CNPJ","POPULAÇÃO (IBGE, 2011)","% ATENDIDA (SNIS, 2012)","IARAQUANT","CAPTAÇÃO DE ÁGUA (R$)","LANÇAMENTO ESGOTO (R$)","CAPTAÇÃO DE ÁGUA 1.0 (R$)","LANÇAMENTO ESGOTO 1.0 (R$)",{"$f":"SUM(J21:J172)","v":5173762.842784198},{"$f":"SUM(K21:K172)","v":5158678.1081890939}]
["ABRE CAMPO",310030,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE ABRE CAMPO","20.516.886/0001-38",13311,54.7,"E",26562.815999999999,28881.792000000001,{"$f":"(J21/0.021)*$A$18","v":26562.815999999995},{"$f":"(K21/1.825)*$B$18","v":28881.792000000001},{"$f":"J21/N$20","v":5.1341386930881319E-3},{"$f":"K21/O$20","v":5.5986807849382732E-3},null,null,null,null,null,"",""]
["AIMORÉS",310110,"Estadual","DO6","SERVIÇO AUTÔNOMO DE AGUA E ESGOTO - SAAEAIM / AIMORÉS","",24959,72.8,"D",42249.211830000015,32405.27,{"$f":"(J22/0.021)*$A$18","v":42249.211830000015},32405.269999999997,{"$f":"J22/N$20","v":8.1660511147944523E-3},{"$f":"K22/O$20","v":6.2817003349285479E-3},null,null,null,null,null,"",""]
["BAIXO GUANDU",320080,"Estadual","ES","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO - BAIXO GUANDU-ES","",29081,94,"B",41583.909748500009,60979.69,41583.909748500009,60979.689999999995,8.0374595844679517E-3,1.1820797638681581E-2,null,null,null,null,null,"",""]
["BARÃO DE COCAIS",310540,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",28442,90.7,"D",60812.246880000013,7039.9368000000004,60812.246880000006,7039.9368000000004,1.1753968770488645E-2,1.3646784413287041E-3,null,null,null,null,null,"",""]
["CARATINGA",311340,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",85239,82.7,"C",149614.00045199998,213147.62496000002,149614.00045199998,213147.62496000002,2.8917831179808583E-2,4.1318264192844456E-2,null,null,null,null,null,"",""]
["CARMÉSIA",311380,"Estadual","DO3","PREFEITURA MUNICIPAL DE CARMÉSIA","18.303.172/0001-08",2446,57,"B",1904.2218720000005,3670.3944000000001,1904.2218720000005,3670.3944000000001,3.6805356756075558E-4,7.1149901641923889E-4,null,null,null,null,null,"",""]
["COLATINA",320150,"Federal","ES","SERVIÇO COLATINENSE DE MEIO AMBIENTE E SANEAMENTO AMBIENTAL SANEAR","",111788,91.4,"B",124579.28422799999,208060.21763999996,124579.28422799999,208060.21763999996,2.407904807653672E-2,4.0332079900414174E-2,null,null,null,null,null,"",""]
["CONCEIÇÃO DO MATO DENTRO",311750,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",17908,67.5,"D",28270.880820000006,31192.335360000001,28270.880820000006,31192.335360000001,5.4642784524669809E-3,6.0465752477333349E-3,null,null,null,null,null,"",""]
["CONSELHEIRO PENA",311840,"Estadual","DO4","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO - SAAE","",22242,85.4,"B",23767.033500000001,46710.281520000004,23767.033500000001,46710.281520000004,4.5937616822053755E-3,9.0546997778074619E-3,null,null,null,null,null,"",""]
["DESTERRO DO MELO",312150,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG DESTERRO DO MELO","17.281.106/0001-03",3015,46.1,"E",6375.0758399999995,7851.2490000000016,6375.0758399999995,7851.2490000000016,1.2321932863411514E-3,1.5219497777030537E-3,null,null,null,null,null,"",""]
["GALILÉIA",312730,"Estadual","DO4","GALILÉIA SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO","",6951,100,"B",9778.4366399999999,16456.6044,9778.4366399999999,16456.6044,1.8900048063930685E-3,3.19008165558462E-3,null,null,null,null,null,"",""]
["GOVERNADOR VALADARES",312770,"Federal","DO4","SERVIÇO AUTÔNOMO DE ÁGUA E ESGÔTO - SAAE","20.607.735/0001-95",263689,99.4,"D",661358.77920000011,652307.30000000005,661358.77920000011,652307.30000000005,0.12782935733561723,0.1264485370708634,null,null,null,null,null,"",""]
["GUANHÃES",312800,"Estadual","DO3","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE GUANHÃES","21.250.048/0001-28",31262,71.3,"B",31426.199532000002,63016.459920000001,31426.199532000002,63016.459920000001,6.0741476729707176E-3,1.2215621637637194E-2,null,null,null,null,null,"",""]
["GUARACIABA",312820,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG GUARACIABA","17.281.106/0001-03",10223,30.7,"C",5656.3579799999998,8682.5887199999997,5656.3579799999989,8682.5887199999997,1.0932773982651471E-3,1.6831034109720683E-3,null,null,null,null,null,"",""]
["IPATINGA",313130,"Federal","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG IPATINGA / CORONEL FABRICIANO","17.281.106/0001-03",239468,99,"E",964434.36096000008,982061.10395999998,964434.36095999996,982061.10395999986,0.186408691365722,0.19037068864619339,null,null,null,null,null,"",""]
["ITABIRA",313170,"Estadual","DO2","SERVIÇO AUTÔNOMO DE AGUA E ESGOTO DE ITABIRA","20.959.219/0001-20",109783,100,"B",155751.92284049999,203161.07340000002,155751.92284049999,203161.07340000002,3.01041867540809E-2,3.9382390050174659E-2,null,null,null,null,null,"",""]
["JEQUERI",313550,"Estadual","DO1","DEPARTAMENTO MUNICIPAL DE ÁGUA E ESGOTO - DEMAE","26.151.886/0001-68",12848,40.200000000000003,"E",22135.68,6931.6300799999999,22135.68,6931.6300799999999,4.2784489109067769E-3,1.3436833883851854E-3,null,null,null,null,null,"",""]
["JOÃO MONLEVADE",313620,"Estadual","DO2","DEPARTAMENTO MUNICIPAL DE ÁGUA E ESGOTO DE JOÃO MONLEVADE","",73610,99.6,"D",185956.02476639999,190479.028464,185956.02476640002,190479.028464,3.5942123830772651E-2,3.6923999611766026E-2,null,null,null,null,null,"",""]
["LINHARES",320320,"Federal","ES","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE LINHARES","",141306,83.1,"B",147457.64511449999,98904.326400000005,147457.64511449999,98904.326400000005,2.8501044519301438E-2,1.9172416717180955E-2,null,null,null,null,null,"",""]
["MALACACHETA",313920,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",18776,62.9,"A",3098.9952000000003,17893.8315,3098.9952000000003,17893.8315,5.9898284752694876E-4,3.4686854121784823E-3,null,null,null,null,null,"",""]
["MANHUAÇU",313940,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE MANHUAÇU","22.050.561/0001-38",79574,81.5,"D",176363.73971999998,249639.76915199999,176363.73971999998,249639.76915199999,3.4088098948325964E-2,4.8392197364613962E-2,null,null,null,null,null,"",""]
["MARIANA",314000,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE MARIANA","07.711.512/0001-05",54219,95.8,"B",88525.730865599995,4846.7257199999995,88525.730865599995,4846.7257199999995,1.7110511934087986E-2,9.3952861922245382E-4,null,null,null,null,null,"",""]
["MARLIÉRIA",314030,"Estadual","DO2","SUB PREFEITURA MUNICIPAL DE MARLIÉRIA","16.796.872/0001-48",4012,100,"A",2258.3927519999997,4208.9194800000005,2258.3927519999997,4208.9194800000005,4.365087501352638E-4,8.1589108522173376E-4,null,null,null,null,null,"",""]
["MESQUITA",314170,"Estadual","DO2","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE MESQUITA","05.109.788/0001-92",6069,82.6,"E",13613.443199999998,740.09591999999998,13613.443199999998,740.09591999999998,2.6312460802076672E-3,1.4346619511404325E-4,null,null,null,null,null,"",""]
["NOVA ERA",314470,"Estadual","DO2","PREFEITURA MUNICIPAL DE NOVA ERA","16.819.831/0001-20",17528,62,"B",12351.709439999999,13863.26016,12351.709439999999,13863.26016,2.3873744922859809E-3,2.6873667767703707E-3,null,null,null,null,null,"",""]
["OURO PRETO",314610,"Estadual","DO2","SERVIÇO MUNICIPAL DE ÁGUA E ESGOTO DE OURO PRETO MG"," 07.758.228/0001-94",70281,89.2,"C",133057.56871050003,217184.63759350003,133057.56871050003,217184.63759350003,2.5717755674880664E-2,4.2100831460821789E-2,null,null,null,null,null,"",""]
["PONTE NOVA",315210,"Estadual","DO1","DEPARTAMENTO MUNICIPAL DE ÁGUA, ESGOTO E SANEAMENTO DE PONTE NOVA - DMAES","23.802.507/0001-64",57390,98.2,"C",113366.95050240001,174620.51784000001,113366.95050240001,174620.51784000001,2.1911895451588375E-2,3.3849857304102837E-2]
["RAUL SOARES",315400,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO - SAAE","24.089.583/0001-37",23818,63.1,"B",17127.131918399999,28261.465800000002,17127.131918399999,28261.465800000002,3.3103821027063622E-3,5.4784317236496322E-3,null,null,null,null,null,"",""]
["RESPLENDOR",315430,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",17089,75.099999999999994,"E",58344.753600000004,14634.671039999999,58344.753600000004,14634.671039999999,1.1277044459309325E-2,2.8369033176868183E-3,null,null,null,null,null,"",""]
["RIO CASCA",315490,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG RIO CASCA","17.281.106/0001-03",14201,79.8,"D",26120.701151999998,36391.057919999999,26120.701151999998,36391.057919999999,5.0486854434061102E-3,7.0543377890222234E-3,null,null,null,null,null,"",""]
["RIO DOCE",315500,"Estadual","DO1","PREFEITURA MUNICIPAL DE RIO DOCE","18.316.265/0001-69",2465,100,"A",1025.250912,1910.4102,1025.250912,1910.4102,1.9816349205683219E-4,3.7032940608706282E-4,null,null,null,null,null,"",""]
["RIO PIRACICABA",315570,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",14149,79.7,"E",38225.416320000004,49874.58,38225.416320000004,49874.58,7.3883201610821141E-3,9.6680930567904742E-3,null,null,null,null,null,"",""]
["SABINÓPOLIS",315680,"Estadual","DO3","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE SABINÓPOLIS","21.072.657/0001-34",15704,64.5,"B",13381.018560000002,17329.075199999999,13381.018560000002,{"$f":"(K53/1.825)*$B$18","v":17329.075199999999},2.5863223666431467E-3,3.3592084709629633E-3,null,null,null,null,null,"",""]
["SANTA MARIA DO SUAÇUÍ",315820,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",14395,74.5,"E",28776.383999999995,32636.42496,28776.383999999998,32636.42496,5.5619835841788081E-3,6.3265092869802479E-3,null,null,null,null,null,"",""]
["SANTANA DO PARAÍSO",315895,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",27265,92.6,"E",78126.340320000003,100580.84064000001,78126.340320000003,100580.84064000001,1.510048734239184E-2,1.9497405833547535E-2,null,null,null,null,null,"",""]
["SÃO JOÃO DO MANHUAÇU",316255,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10245,42.7,"D",9418.7318399999986,13285.624320000001,9418.7318399999986,13285.624320000001,1.8204800115908331E-3,2.5753931610716057E-3,null,null,null,null,null,"",""]
["SÃO JOSÉ DO JACURI",316350,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6553,30.6,"E",6336.3384000000005,5045.2880399999995,6336.3384000000005,5045.2880399999995,1.2247060007470648E-3,9.7801954961890432E-4,null,null,null,null,null,"",""]
["SÃO SEBASTIÃO DO MARANHÃO",316450,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10647,27.3,"B",4117.2364800000014,6931.6300799999999,4117.2364800000014,6931.6300799999999,7.9579149742866066E-4,1.3436833883851854E-3,null,null,null,null,null,"",""]
["SENADOR FIRMINO",316570,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE SENADOR FIRMINO","",7230,64.8,"C",7526.1312000000007,12274.7616,7526.1312000000007,12274.7616,1.4546726297083041E-3,2.3794393335987659E-3,null,null,null,null,null,"",""]
["SENHORA DO PORTO",316610,"Estadual","DO3","PREFEITURA MUNICIPAL DE SENHORA DO PORTO","18.307.504/0001-14",3497,36.799999999999997,"E",6566.9184000000005,1510.2770399999999,6566.9184000000005,1510.2770399999999,1.2692731769023437E-3,2.9276434937906381E-4,null,null,null,null,null,"",""]
["SERRA AZUL DE MINAS",316650,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4220,40.5,"B",2391.7375440000001,3249.2015999999994,2391.7375440000001,3249.2015999999994,4.6228202116680621E-4,6.298515883055556E-4,null,null,null,null,null,"",""]
["SERRO",316710,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",20835,59.2,"B",18527.564159999994,18942.696,18527.564159999994,18942.696,3.5810617384289707E-3,3.6720058128708591E-3,null,null,null,null,null,"",""]
["TAPARUBA",316805,"Estadual","DO6","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO","",3137,45.2,"E",5976.6336000000001,6498.4031999999988,5976.6336000000001,6498.4031999999988,1.1551812059448297E-3,1.2597031766111112E-3,null,null,null,null,null,"",""]
["VERMELHO NOVO",317115,"Estadual","DO1","PREFEITURA MUNICIPAL DE VERMELHO NOVO","01.620.744/0001-71",4689,39.5,"E",6640.7039999999997,4693.2911999999997,6640.7039999999988,4693.2911999999997,1.283534673272033E-3,9.0978562755246928E-4,null,null,null,null,null,"",""]
["VIÇOSA",317130,"Estadual","DO1","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE VIÇOSA","25.947.276/0001-02",72220,100,"B",96533.827298999997,180547.30223999999,96533.827298999997,180547.30223999999,1.8658340212411337E-2,3.4998753256845379E-2]
["AÇUCENA",310050,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG AÇUCENA","17.281.106/0001-03",10276,58,"A",4741.4626559999988,{"$f":"G66*(H66/100)*0.976*1.825","v":10616.094495999998},4741.4626559999988,10616.094495999998,9.1644375671623131E-4,2.0579098508099547E-3]
["ÁGUA BOA",310060,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",15195,39.5,"E",17273.823840000001,10690.806930000001,17273.823840000001,10690.806930000001,3.3387351459473356E-3,2.0723927149145015E-3]
["ALTO JEQUITIBÁ",315350,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",8318,59,"D",11056.772159999997,8741.4527440000002,11056.772159999997,8741.4527440000002,2.1370852309979343E-3,1.6945140907558209E-3]
["ALTO RIO DOCE",310210,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",12159,58,"D",15612.5718,12561.414263999999,15612.5718,12561.414263999999,3.0176434974739357E-3,2.4350064106654578E-3,null,null,null,null,null,"",""]
["ALVARENGA",310220,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4444,47.7,"E",6640.7039999999997,3775.7663855999995,6640.7039999999988,3775.7663855999995,1.283534673272033E-3,7.3192517664674511E-4,null,null,null,null,null,"",""]
["ALVINÓPOLIS",310230,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",15261,69.900000000000006,"A",9916.7846399999999,19000.8423468,9916.7846399999999,19000.8423468,1.9167451120862358E-3,3.6832773722859924E-3,null,null,null,null,null,"",""]
["AMPARO DO SERRA",310250,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG AMPARO DA SERRA","17.281.106/0001-03",5053,59,"A",2169.29664,5310.2381240000004,2169.29664,5310.2381240000004,4.1928799326886409E-4,1.0293796225762399E-3,null,null,null,null,null,"",""]
["ANTÔNIO DIAS",310300,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG ANTÔNIO DIAS","17.281.106/0001-03",9565,44.7,"E",13281.407999999999,7615.6185659999992,13281.407999999998,7615.6185659999992,2.567069346544066E-3,1.4762732634762885E-3,null,null,null,null,null,"",""]
["ARAPONGA",310370,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG ARAPONGA","17.281.106/0001-03",8152,100,"A",5307.0292800000007,14520.3424,5307.0292800000007,14520.3424,1.0257581263898997E-3,2.8147409269343288E-3,null,null,null,null,null,"",""]
["BARRA LONGA",310570,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6143,59,"E",9961.0560000000005,6455.727844,9961.0560000000005,6455.727844,1.9253020099080495E-3,1.2514306395182745E-3,null,null,null,null,null,"",""]
["BELA VISTA DE MINAS",310600,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10004,93.7,"E",33203.519999999997,16696.519937600002,33203.519999999997,16696.519937600002,6.417673366360164E-3,3.2365888290442606E-3,null,null,null,null,null,"",""]
["BOM JESUS DO AMPARO",310770,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5491,45.8,"D",5400.4141800000007,4479.5006935999991,5400.4141800000007,4479.5006935999991,1.0438078327327878E-3,8.6834274200769739E-4,null,null,null,null,null,"",""]
["BOM JESUS DO GALHO",310780,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",15364,63,"E",31393.236419999997,17240.804783999996,31393.236419999997,17240.804783999996,6.0677764663650694E-3,3.3420974176759056E-3,null,null,null,null,null,"",""]
["BRAÚNAS",310880,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5030,31.7,"D",3357.982656000001,2840.1412119999995,3357.982656000001,2840.1412119999995,6.4904069978455824E-4,5.5055600532458984E-4,null,null,null,null,null,"",""]
["BUGRE",310925,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",3992,35.700000000000003,"A",929.69856000000016,2538.4664928000007,929.69856000000027,2538.4664928000007,1.7969485425808464E-4,4.920769312530542E-4,null,null,null,null,null,"",""]
["CAJURI",311020,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG CAJURI","17.281.106/0001-03",4047,51.8,"D",4504.6108800000011,3734.0114951999999,4504.6108800000011,3734.0114951999999,8.7066435336952922E-4,7.2383107007054374E-4,null,null,null,null,null,"",""]
["CAMPANÁRIO",311080,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG CAMPANÁRIO","17.281.106/0001-03",3564,74.400000000000006,"D",5374.8198000000002,4723.0584192000006,5374.8198000000002,4723.0584192000006,1.0388608761795516E-3,9.1555594672643496E-4,null,null,null,null,null,"",""]
["CANAÃ",311170,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG CANAÃ","17.281.106/0001-03",4628,40.200000000000003,"E",5147.7753599999996,3313.8442272000002,5147.7753599999996,3313.8442272000002,9.9497706339198694E-4,6.4238243939653266E-4,null,null,null,null,null,"",""]
["CANTAGALO",311205,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS","17.281.106/0001-03",4195,56,"B",2894.9319,4184.3950400000003,2894.9319,4184.3950400000003,5.5954089662952689E-4,8.1113706888544235E-4,null,null,null,null,null,"",""]
["CAPELA NOVA",311220,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG CAPELA NOVA","17.281.106/0001-03",4755,44.8,"B",2573.2728000000002,3794.3834879999995,2573.2728000000002,{"$f":"(K85/1.825)*$B$18","v":3794.3834879999995},4.9736968589291278E-4,7.3553406675571438E-4,null,null,null,null,null,"",""]
["CAPUTIRA",311290,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",9030,41.8,"B",5146.5456000000004,6723.2106479999993,{"$f":"(J86/0.021)*$A$18","v":5146.5456000000004},6723.2106479999993,{"$f":"J86/N$20","v":9.9473937178582556E-4},{"$f":"K86/O$20","v":1.3032816754600957E-3},null,null,null,null,null,"",""]
["CIPOTÂNEA",311630,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6547,46,"E",8854.2720000000008,5364.297544,8854.2720000000008,5364.297544,1.7113795643627107E-3,1.0398589389565705E-3,null,null,null,null,null,"",""]
["COIMBRA",311670,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7054,73.099999999999994,"B",6175.8547199999994,9184.7114887999996,6175.8547199999994,9184.7114887999996,1.1936872461429905E-3,1.7804389605584846E-3,null,null,null,null,null,"",""]
["COLUNA",311680,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",9024,42.3,"E",14973.545454000001,6799.1111424000001,14973.545454000003,6799.1111424000001,2.894130618082635E-3,1.3179948428274323E-3,null,null,null,null,null,"",""]
["CONGONHAS DO NORTE",311810,"Estadual","DO3","PREFEITURA MUNICIPAL DE CONGONHAS DO NORTE","18.303.180/0001-46",4943,69.7,"A",215.208,6136.7167051999995,215.20800000000003,6136.7167051999995,4.1596031078260326E-5,1.1895909332777185E-3,null,null,null,null,null,"",""]
["COROACI",311920,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG COROACI","17.281.106/0001-03",10270,50.4,"D",11302.478207999999,9219.6336960000008,11302.478207999999,9219.6336960000008,2.184576013909E-3,1.7872085644119531E-3,null,null,null,null,null,"",""]
["CÓRREGO NOVO",312000,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG CÓRREGO NOVO","17.281.106/0001-03",3127,65.2,"D",4545.5618880000011,3631.5176848000001,4545.5618880000011,3631.5176848000001,8.7857948385470673E-4,7.0396283866504142E-4,null,null,null,null,null,"",""]
["CUPARAQUE",312083,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4680,19.2,"B",1157.9727599999997,1600.5150720000001,1157.9727599999997,1600.5150720000001,2.2381635865181067E-4,3.1025682130840417E-4,null,null,null,null,null,"",""]
["DIONÍSIO",312180,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",8739,70.5,"B",8234.4729600000028,10973.964293999999,8234.4729600000028,10973.964293999999,1.5915829948573213E-3,2.1272822346832389E-3,null,null,null,null,null,"",""]
["DIVINÉSIA",312190,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",3293,66,"C",3763.0656000000004,3871.2244559999999,3763.0656000000004,3871.2244559999999,7.2733631485415206E-4,7.504295431526658E-4,null,null,null,null,null,"",""]
["DIVINO DAS LARANJEIRAS",312210,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG DIVINO DAS LARANJEIRAS","17.281.106/0001-03",4937,83.2,"E",13591.307520000002,7316.4286208000003,13591.307520000004,7316.4286208000003,2.6269676312967614E-3,1.4182758581477697E-3,null,null,null,null,null,"",""]
["DOM CAVATI",312250,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5209,88.4,"E",19922.112000000001,8201.9913872000016,19922.112000000001,8201.9913872000016,3.8506040198160989E-3,1.5899405264654582E-3,null,null,null,null,null,"",""]
["DOM JOAQUIM",312260,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4535,64.400000000000006,"B",4117.2364800000014,{"$f":"G98*(H98/100)*0.976*1.825","v":5202.0658480000002},4117.2364800000014,5202.0658480000002,7.9579149742866066E-4,1.0084106313479864E-3,null,null,null,null,null,"",""]
["DOM SILVÉRIO",312270,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5196,78.099999999999994,"C",7079.2671600000003,7228.2449711999989,7079.2671600000012,7228.2449711999989,1.3683014423193736E-3,1.4011816243633406E-3,null,null,null,null,null,"",""]
["DORES DO TURVO",312330,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4462,41.8,"B",2648.3265900000001,3322.1446191999999,2648.3265900000001,3322.1446191999999,5.1187630173145609E-4,6.4399145469578602E-4,null,null,null,null,null,"",""]
["DURANDÉ",312352,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7423,31.5,"C",3763.0656000000004,4164.8819939999994,3763.0656000000004,4164.8819939999994,7.2733631485415206E-4,8.0735450180318433E-4,null,null,null,null,null,"",""]
["ENGENHEIRO CALDAS",312370,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10280,78.900000000000006,"D",18669.7920528,14447.170704,18669.7920528,14447.170704,3.6085519611395787E-3,2.8005567319786782E-3,null,null,null,null,null,"",""]
["ENTRE FOLHAS",312385,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5175,75.099999999999994,"E",9961.0560000000005,6922.5002099999983,9961.0560000000005,6922.5002099999983,1.9253020099080495E-3,1.3419135803435654E-3,null,null,null,null,null,"",""]
["ERVÁLIA",312400,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",17946,52.8,"B",12727.216655999997,16877.739225599998,12727.216655999999,16877.739225599998,2.4599536242273911E-3,3.2717178454704497E-3,null,null,null,null,null,"",""]
["FERNANDES TOURINHO",312580,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",3030,65.599999999999994,"E",5091.2063999999991,3540.4556159999997,5091.2063999999991,3540.4556159999997,9.8404324950855833E-4,6.8631062875966953E-4,null,null,null,null,null,"",""]
["FERROS",312590,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10837,34.4,"C",6020.9049599999998,6640.1853535999999,6020.9049599999989,6640.1853535999999,1.1637381037666432E-3,1.2871873790805247E-3,null,null,null,null,null,"",""]
["FRANCISCÓPOLIS",312675,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5800,37.5,"C",3556.0969920000002,3874.1099999999992,3556.0969920000002,3874.1099999999992,6.8733281753717373E-4,7.5098890040262069E-4,null,null,null,null,null,"",""]
["FREI INOCÊNCIO",312690,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG - FREI INOCÊNCIO / MATHIAS LOBATO","17.281.106/0001-03",8920,75.8,"E",66407.039999999994,12043.334432,66407.039999999994,12043.334432,1.2835346732720328E-2,2.334577614540811E-3,null,null,null,null,null,"",""]
["IAPU",312930,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10315,69.5,"E",27979.499520000005,12769.289209999997,27979.499520000005,12769.289209999997,5.4079594233861668E-3,2.47530257600867E-3,null,null,null,null,null,"",""]
["IMBÉ DE MINAS",313055,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6424,29.2,"D",3849.3947520000006,3341.1892095999997,3849.3947520000006,3341.1892095999997,7.4402226560668855E-4,6.4768321254548937E-4,null,null,null,null,null,"",""]
["INHAPIM",313090,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",24294,51.6,"D",27641.930400000001,22328.595964799995,27641.930400000001,22328.595964799995,5.3427130774948376E-3,4.3283561207966594E-3,null,null,null,null,null,"",""]
["IPABA",313115,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",16708,89.9,"D",33170.316480000001,26754.500350399998,33170.316480000001,26754.500350399998,6.411255692993805E-3,5.1863093198098219E-3,null,null,null,null,null,"",""]
["ITANHOMI",313320,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",11856,72.3,"E",41836.4352,15268.246905599997,41836.4352,15268.246905599997,8.0862684416138069E-3,2.9597208016066299E-3,null,null,null,null,null,"",""]
["ITAVERAVA",313390,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5799,59,"B",3450.0916799999995,6094.2154919999994,3450.0916799999995,6094.2154919999994,6.6684380108605337E-4,1.1813521534374855E-3,null,null,null,null,null,"",""]
["ITUETA",313410,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5830,56.6,"E",10907.356320000001,5877.5681359999999,10907.356320000001,5877.5681359999999,2.1082057008493145E-3,1.1393554729979586E-3,null,null,null,null,null,"",""]
["JAGUARAÇU",313500,"Estadual","DO2","PREFEITURA MUNICIPAL DE JAGUARAÇÚ","16.816.522/0001-04",2990,57,"A",26.901,3035.6991600000001,26.901000000000003,3035.6991600000001,5.1995038847825408E-6,5.8846454388790197E-4,null,null,null,null,null,"",""]
["JOSÉ RAYDAN",313655,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4376,57,"A",1952.1948095999999,4442.8827839999994,1952.1948095999999,{"$f":"(K117/1.825)*$B$18","v":4442.8827839999994},3.7732591711711508E-4,8.612444294493173E-4,null,null,null,null,null,"",""]
["MARILAC",314010,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4219,57,"E",9961.0560000000005,4283.4831959999992,9961.0560000000005,4283.4831959999992,1.9253020099080495E-3,8.3034512062309628E-4,null,null,null,null,null,"",""]
["MARTINS SOARES",314053,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7173,36.799999999999997,"B",3448.1855520000008,4701.7695167999991,3448.1855520000008,4701.7695167999991,6.6647537909650324E-4,9.1142913323787739E-4,null,null,null,null,null,"",""]
["MATERLÂNDIA",314060,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4595,43.8,"C",3386.7590399999995,3584.8609319999991,3386.7590399999995,3584.8609319999991,6.5460268336873671E-4,6.9491851532842229E-4,null,null,null,null,null,"",""]
["MATIPÓ",314090,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",17639,78.400000000000006,"C",26830.657728000002,24632.172051199999,26830.657728000002,24632.172051199999,5.1859079249101043E-3,4.7748999907743601E-3,null,null,null,null,null,"",""]
["MUTUM",314400,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",26661,51.7,"D",32351.296320000001,24551.5923444,32351.296320000001,24551.5923444,6.2529530832902544E-3,4.7592797669282387E-3,null,null,null,null,null,"",""]
["NACIP RAYDAN",314420,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",3154,57,"E",9739.5762240000004,3202.2057359999994,9739.5762240000004,3202.2057359999994,1.8824937516383655E-3,6.2074152890382694E-4,null,null,null,null,null,"",""]
["NAQUE",314435,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG NAQUE","17.281.106/0001-03",6341,94,"E",26562.815999999999,10616.913848,26562.815999999995,10616.913848,5.1341386930881319E-3,2.0580686806463623E-3,null,null,null,null,null,"",""]
["PAULA CÂNDIDO",314830,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",9271,53.2,"E",12263.166719999999,8785.1847664000015,12263.166719999999,8785.1847664000015,2.3702606966423539E-3,1.7029914606329177E-3,null,null,null,null,null,"",""]
["PAULISTAS",314840,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4918,57,"A",2324.2463999999995,4993.1667119999993,2324.2463999999995,4993.1667119999993,4.4923713564521143E-4,9.6791592870926462E-4,null,null,null,null,null,"",""]
["PEÇANHA",314860,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",17260,62,"E",41670.279251999993,19060.977439999999,41670.279251999993,19060.977439999999,8.0541533344763126E-3,3.6949344464315059E-3,null,null,null,null,null,"",""]
["PEDRA DO ANTA",314880,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",3365,65.099999999999994,"A",1626.9724799999999,3901.9234379999994,1626.9724799999999,3901.9234379999994,3.1446599495164808E-4,7.5638048278413197E-4,null,null,null,null,null,"",""]
["PERIQUITO",314995,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7036,75.2,"E",25151.666399999998,9424.4574463999998,25151.666399999998,9424.4574463999998,4.8613875750178242E-3,1.8269132612556763E-3,null,null,null,null,null,"",""]
["PIEDADE DE CARATINGA",315015,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7110,59.9,"B",6072.9238080000005,{"$f":"G130*(H130/100)*0.976*1.825","v":7585.9348679999994},6072.9238080000005,7585.9348679999994,1.1737924587072743E-3,1.4705191347290656E-3,null,null,null,null,null,"",""]
["PIEDADE DE PONTE NOVA",315020,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4062,78.2,"E",8854.0875360000009,5657.9533007999999,8854.0875360000009,5657.9533007999999,1.7113439106217865E-3,1.0967835523248361E-3,null,null,null,null,null,"",""]
["PINGO D'ÁGUA",315053,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4420,57,"E",6640.7039999999997,4487.5552799999996,6640.7039999999988,4487.5552799999996,1.283534673272033E-3,8.6990410835602891E-4,null,null,null,null,null,"",""]
["PIRANGA",315080,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS","17.281.106/0001-03",17232,33.6,"E",19922.112000000001,10313.0625024,19922.112000000001,10313.0625024,3.8506040198160989E-3,1.9991676716615888E-3,null,null,null,null,null,"",""]
["PORTO FIRME",315230,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10417,46.4,"B",6233.03856,8609.4088255999995,6233.03856,8609.4088255999995,1.2047399058294998E-3,1.6689176267720748E-3,null,null,null,null,null,"",""]
["REDUTO",315415,"Estadual","DO6","SERVIÇO AUTÔNOMO DE ÁGUA E ESGOTO DE REDUTO","",6569,65.5,"E",12241.03104,7663.9603340000003,12241.03104,7663.9603340000003,2.3659822477314473E-3,1.485644223824301E-3,null,null,null,null,null,"",""]
["RIO ESPERA",315520,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6070,59,"B",4374.5637600000009,6379.011559999999,4374.5637600000009,6379.011559999999,8.4552846601795189E-4,1.236559332879037E-3,null,null,null,null,null,"",""]
["RIO VERMELHO",315600,"Estadual","DO3","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",13645,40.200000000000003,"A",4648.4927999999991,9770.3985479999992,4648.4927999999991,9770.3985479999992,8.9847427129042287E-4,1.8939732898802261E-3]
["SANTA BÁRBARA",315720,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",27876,88.9,"B",27791.346239999999,44141.278036799995,27791.346239999999,44141.278036799995,5.3715926076434578E-3,8.5567033086883914E-3,null,null,null,null,null,"",""]
["SANTA BÁRBARA DO LESTE",315725,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7682,49.4,"B",5146.5456000000004,6759.4901295999998,5146.5456000000004,6759.4901295999998,9.9473937178582556E-4,1.3103143843903949E-3,null,null,null,null,null,"",""]
["SANTA CRUZ DO ESCALVADO",315740,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4992,28.4,"E",6591.5135999999993,2525.2571135999997,6591.5136000000002,2525.2571135999997,1.2740270090255733E-3,4.8951631806437091E-4,null,null,null,null,null,"",""]
["SANTA EFIGÊNIA DE MINAS",315750,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4600,66.400000000000006,"B",3206.5838279999998,5440.4972799999996,3206.5838280000003,5440.4972799999996,6.1977789192100186E-4,1.0546301137424206E-3,null,null,null,null,null,"",""]
["SANTA MARGARIDA",315790,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",15011,50.8,"C",13490.433381600002,13582.6973456,13490.433381600002,13582.6973456,2.6074703830723496E-3,2.6329802055372049E-3,null,null,null,null,null,"",""]
["SANTA MARIA DE ITABIRA",315800,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",10552,60,"E",20397.484800000002,11277.13344,20397.484800000002,11277.13344,3.9424854636404905E-3,2.186051000565091E-3,null,null,null,null,null,"",""]
["SANTA RITA DE MINAS",315935,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS - COPASA MG","17.281.106/0001-03",6547,59,"E",16291.860479999998,6880.2946759999995,16291.860479999999,6880.2946759999995,3.148938398427387E-3,1.3337321173573404E-3,null,null,null,null,null,"",""]
["SANTA RITA DO ITUETO",315950,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5697,33.6,"A",929.69856000000016,3409.5587903999999,929.69856000000027,3409.5587903999999,1.7969485425808464E-4,6.6093652654689364E-4,null,null,null,null,null,"",""]
["SANTANA DO MANHUAÇU",315890,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",8582,48.3,"E",13281.407999999999,7383.2628071999998,13281.407999999998,7383.2628071999998,2.567069346544066E-3,1.4312315388470373E-3,null,null,null,null,null,"",""]
["SANTO ANTÔNIO DO GRAMA",316010,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG SANTO ANTONIO DO GRAMA","17.281.106/0001-03",4085,82.4,"C",5644.5983999999999,5995.5904480000008,5644.5983999999999,5995.5904480000008,1.091004472281228E-3,1.1622338750856267E-3,null,null,null,null,null,"",""]
["SÃO DOMINGOS DAS DORES",316095,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5408,36.299999999999997,"E",7481.8598400000001,3496.6808447999997,7481.8598400000001,3496.6808447999997,1.4461157318864904E-3,6.7782497210849954E-4,null,null,null,null,null,"",""]
["SÃO DOMINGOS DO PRATA",316100,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG SÃO DOMINGOS DO PRATA","17.281.106/0001-03",17357,55.6,"E",26589.578400000002,17189.4563504,26589.578400000006,{"$f":"(K149/1.825)*$B$18","v":17189.4563504},5.1393114079599251E-3,3.3321436208847309E-3,null,null,null,null,null,"",""]
["SÃO JOÃO DO ORIENTE",316260,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7874,80.3,"E",23242.464,11262.210546399998,{"$f":"(J150/0.021)*$A$18","v":23242.464},11262.210546399998,{"$f":"J150/N$20","v":4.4923713564521154E-3},{"$f":"K150/O$20","v":2.1831582258489651E-3},null,null,null,null,null,"",""]
["SÃO JOÃO EVANGELISTA",316280,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",15553,65,"E",27226.886399999996,18006.95234,27226.886399999996,18006.95234,5.2624921604153344E-3,3.4906136731840346E-3,null,null,null,null,null,"",""]
["SÃO JOSÉ DA SAFIRA",316300,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",4075,72.3,"A",464.84928000000008,5247.8159699999997,464.84928000000014,5247.8159699999997,8.9847427129042322E-5,1.0172792060177984E-3,null,null,null,null,null,"",""]
["SÃO JOSÉ DO GOIABAL",316340,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG SÃO JOSÉ DO GOIABAL","17.281.106/0001-03",5636,65.5,"E",9739.6992000000009,6575.4422959999993,9739.6992000000009,6575.4422959999993,1.8825175207989818E-3,1.274637059746348E-3,null,null,null,null,null,"",""]
["SÃO JOSÉ DO MANTIMENTO",316360,"Estadual","DO6","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",2592,55.9,"D",3030.3745919999997,2580.8305535999993,3030.3745919999997,2580.8305535999993,5.8571965590313764E-4,5.0028912435980154E-4,null,null,null,null,null,"",""]
["SÃO MIGUEL DO ANTA",316380,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6760,59,"C",7337.9779200000012,7104.1380799999997,7337.9779200000012,7104.1380799999997,1.4183058139655967E-3,1.3771237380992244E-3,null,null,null,null,null,"",""]
["SÃO PEDRO DO SUAÇUÍ",316410,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5570,41.3,"E",7055.5635360000006,4097.4902919999995,7055.5635360000006,4097.4902919999995,1.3637199366106109E-3,7.9429074775870935E-4,null,null,null,null,null,"",""]
["SÃO PEDRO DOS FERROS",316400,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG SÃO PEDRO DOS FERROS","17.281.106/0001-03",8356,81.2,"B",7081.2655199999999,12085.570246399999,7081.2655199999999,12085.570246399999,1.3686876911793858E-3,2.3427649473253382E-3,null,null,null,null,null,"",""]
["SÃO SEBASTIÃO DO ANTA",316447,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5739,62.4,"B",4803.4425600000004,6378.7194431999997,4803.4425600000004,6378.7194431999997,9.2842341366677059E-4,1.2365027065895356E-3,null,null,null,null,null,"",""]
["SÃO SEBASTIÃO DO RIO PRETO",316480,"Estadual","DO3","PREFEITURA MUNICIPAL DE SÃO SEBASTIÃO DO RIO PRETO","",1613,54.3,"B",953.06399999999996,1560.0800507999998,953.06399999999985,1560.0800507999998,1.8421099477515288E-4,3.0241856888171907E-4,null,null,null,null,null,"",""]
["SARDOÁ",316550,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5594,35.700000000000003,"B",2230.1697599999998,3557.1597096000005,2230.1697599999998,3557.1597096000005,4.3105372777385771E-4,6.8954868572885402E-4,null,null,null,null,null,"",""]
["SERICITA",316630,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",7128,49.4,"E",9961.0560000000005,6272.0184383999995,9961.0560000000005,6272.0184383999995,1.9253020099080495E-3,1.2158189185023085E-3,null,null,null,null,null,"",""]
["SIMONÉSIA",316760,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",18298,62,"B",12866.364,{"$f":"G162*(H162/100)*0.976*1.825","v":20207.286511999999},12866.364000000001,20207.286511999999,2.4868484294645636E-3,3.9171442932099476E-3,null,null,null,null,null,"",""]
["SOBRÁLIA",316770,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",5830,69.400000000000006,"B",5146.5456000000004,7206.7708240000011,5146.5456000000004,7206.7708240000011,9.9473937178582556E-4,1.3970189015204656E-3,null,null,null,null,null,"",""]
["TARUMIRIM",316840,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",14293,56.1,"E",40598.374320000003,14282.325987600001,40598.374320000003,14282.325987600001,7.8469724171107303E-3,2.7686018953048575E-3,null,null,null,null,null,"",""]
["TEIXEIRAS",316850,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",11355,67.099999999999994,"E",25234.675199999998,13571.327945999998,25234.675199999994,13571.327945999998,4.8774317584337245E-3,2.6307762689159308E-3,null,null,null,null,null,"",""]
["TIMÓTEO",316870,"Estadual","DO2","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",81243,99.9,"E",264829.55184000003,144565.32156840002,264829.55184000003,144565.32156840002,5.1187029612181682E-2,2.8023714319160793E-2,null,null,null,null,null,"",""]
["TUMIRITINGA",316950,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6293,68.7,"E",16601.759999999998,7700.6459292,16601.759999999998,7700.6459292,3.208836683180082E-3,1.4927556571082976E-3,null,null,null,null,null,"",""]
["UBAPORANGA",317005,"Estadual","DO5","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",12040,50.4,"E",20054.926079999997,10808.606592,20054.926079999997,10808.606592,3.8762747132815392E-3,2.0952279567205368E-3,null,null,null,null,null,"",""]
["URUCÂNIA",317050,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG URUCANIA","17.281.106/0001-03",10291,77.2,"B",9521.1093600000022,14151.014142399999,9521.1093600000022,14151.014142399999,1.8402678378037778E-3,2.7431473423271185E-3,null,null,null,null,null,"",""]
["VARGEM ALEGRE",317057,"Estadual","DO1","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG","17.281.106/0001-03",6461,73.8,"E",16601.759999999998,8493.1499015999998,16601.759999999998,8493.1499015999998,3.208836683180082E-3,1.6463810541149351E-3,null,null,null,null,null,"",""]
["VIRGINÓPOLIS",317180,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG - VIRGINÓPOLIS","17.281.106/0001-03",10572,58.7,"B",6518.9577600000002,11053.706836800002,6518.9577600000002,11053.706836800002,1.2600032042620456E-3,2.1427401758704234E-3,null,null,null,null,null,"",""]
["VIRGOLÂNDIA",317190,"Estadual","DO4","COMPANHIA DE SANEAMENTO DE MINAS GERAIS COPASA MG VIRGOLÂNDIA","17.281.106/0001-03",5658,60.1,"B",4563.1274723999995,6056.8957896000002,4563.1274723999995,6056.8957896000002,8.8197461133421567E-4,1.1741177996714002E-3,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,"","","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Receita e Custo. San.","index":5,"n_rows":205,"n_cols":6,"rows_kept":205,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,4]]}
["Arrecadação Total","Despesas Totais com Serviço","IGP-M Dez 2010 - Set 2013","Valores Corrigidos Inflação"]
[null,null,null,"Arrecadação Total","Despesas Totais com Serviço"]
[{"$f":"SUM(E6:E149)","v":298386616.65999997},{"$f":"SUM(F6:F149)","v":300230620.72000003},1.1750158413187017,{"$f":"A3*$C$3","v":350609001.41299081},{"$f":"B3*$C$3","v":352775735.39494687}]
[]
["Código","Município","UPGRH","Prestador","Arrecadação Total","Despesas Totais"]
[310030,"Abre Campo (MG)","DO1",{"$f":"VLOOKUP(A6,Dados,6,0)","v":"SAAE"},918374.84,857612.11]
[310040,"Acaiaca (MG)","DO1","PMA",14632,163082.68]
[310050,"Açucena (MG)","DO3","COPASA",409243.67,491370.73]
[320010,"Afonso Claúdio (ES)","ES","CESAN",1748434.75,1521160.58]
[310060,"Água Boa (MG)","DO4","COPASA",628346.04,868016.62]
[320030,"Águia Branca (ES)","ES","SAAE",651453.72,552782.12]
[310110,"Aimorés (MG)","DO5","SAAE",3327749,3066137]
[310180,"Alpercata (MG)","DO4","COPASA",651480.92000000004,846062.36]
[315350,"Alto Jequitibá (MG)","DO5","PMAJ",15000,14250]
[310210,"Alto Rio Doce (MG)","DO1","PMARD",0,89807.79]
[320050,"Alto Rio Novo (ES)","ES","CESAN",570420.29,449882.01]
[310220,"Alvarenga (MG)","DO5","COPASA",336380.2,371660.74]
[310230,"Alvinópolis (MG)","DO1","COPASA",1095470.25,1143731.83]
[310240,"Alvorada de Minas (MG)","DO3","COPASA",126850.73,213317.94]
[310250,"Amparo do Serra (MG)","DO1","COPASA",312808.15999999997,395334.56]
[310300,"Antônio Dias (MG)","DO2","COPASA",507403.65,582767.02]
[310370,"Araponga (MG)","DO1","COPASA",309290.19,359851.05]
[320080,"Baixo Guandu (ES)","ES","SAAE",3480764.7,2839447.59]
[310540,"Barão de Cocais (MG)","DO2","COPASA",3493642.57,3213073.9]
[310570,"Barra Longa (MG)","DO1","COPASA",304703.78000000003,448011]
[310600,"Bela Vista de Minas (MG)","DO2","COPASA",1074642.67,1306616.45]
[310770,"Bom Jesus do Amparo (MG)","DO2","COPASA",434490.21,447576.46]
[310780,"Bom Jesus do Galho (MG)","DO1","COPASA",1091999.8899999999,1412679.65]
[310870,"Brás Pires (MG)","DO1","PMBP",0,284000]
[310880,"Braúnas (MG)","DO3","COPASA",221786.98,232483.08]
[320115,"Brejetuba (ES)","ES","CESAN",212598.69,197641.52]
[310925,"Bugre (MG)","DO4","COPASA",135254.89000000001,139944.26999999999]
[311020,"Cajuri (MG)","DO1","COPASA",251168.45,273804.45]
[311080,"Campanário (MG)","DO4","COPASA",353232.89,338887.63]
[311170,"Canaã (MG)","DO1","COPASA",197779.28,238082.74]
[311205,"Cantagalo (MG)","DO4","COPASA",161253.32,190773.6]
[311220,"Capela Nova (MG)","DO1","COPASA",282829.77,314798.28000000003]
[311265,"Capitão Andrade (MG)","DO4",{"$f":"VLOOKUP(A38,Dados,6,0)","v":"PMCA"},47396.18,161100]
[311290,"Caputira (MG)","DO1","COPASA",450113.95,532056.37]
[311320,"Carandaí (MG)","DO1","COPASA",2376879.23,2860749.57]
[311340,"Caratinga (MG)","DO5","COPASA",12717741.310000001,13477320.93]
[311535,"Catas Altas (MG)","DO2","PMCA",15724.72,25579.8]
[311540,"Catas Altas da Noruega (MG)","DO1","PMCAN",0,21200]
[311630,"Cipotânea (MG)","DO1","PMC",0,48729.4]
[311670,"Coimbra (MG)","DO1","COPASA",535791.56000000006,649085.68999999994]
[320150,"Colatina (ES)","ES","SANEAR",16518845.300000001,9646578.5500000007]
[311680,"Coluna (MG)","DO4","COPASA",461043.15,563803.89]
[311740,"Conceição de Ipanema (MG)","DO5","PMCI",2625,96638.5]
[311750,"Conceição do Mato Dentro (MG)","DO3","COPASA",1858479.19,2591435.13]
[311810,"Congonhas do Norte (MG)","DO3","PMCN",0,50400]
[311840,"Conselheiro Pena (MG)","DO5","SAAE",2859851.18,2709401.14]
[311920,"Coroaci (MG)","DO4","COPASA",511428.07,626157.41]
[311940,"Coronel Fabriciano (MG)","DO2","COPASA",20086840.239999998,21017045.449999999]
[312000,"Córrego Novo (MG)","DO1","COPASA",281154.96000000002,289443.01]
[312083,"Cuparaque (MG)","DO5","COPASA",113682.47,130779.57]
[312150,"Desterro do Melo (MG)","DO1","COPASA",265267.90999999997,346487.93]
[312180,"Dionísio (MG)","DO1","COPASA",473689.39,569586.54]
[312190,"Divinésia (MG)","DO1","COPASA",298326.59000000003,351188.01]
[312210,"Divino das Laranjeiras (MG)","DO4","COPASA",482865.04,656621.67000000004]
[312250,"Dom Cavati (MG)","DO5","COPASA",609625.71,689266.68]
[312260,"Dom Joaquim (MG)","DO3","COPASA",411838.25,369882.39]
[312270,"Dom Silvério (MG)","DO1","PMDS",8000,49600]
[312310,"Dores de Guanhães (MG)","DO3","PMD",208255.94,208850.83]
[312330,"Dores do Turvo (MG)","DO1","COPASA",198482.04,237682.43]
[312352,"Durandé (MG)","DO5","COPASA",223036.21,272912.7]
[312370,"Engenheiro Caldas (MG)","DO4","COPASA",830942.28,930443.87]
[312385,"Entre Folhas (MG)","DO1","COPASA",504456.7,536980.41]
[312400,"Ervália (MG)","DO1","COPASA",1272403.3500000001,1300539.99]
[312580,"Fernandes Tourinho (MG)","DO4","COPASA",213675.55,314242.88]
[312590,"Ferros (MG)","DO3",{"$f":"VLOOKUP(A70,Dados,6,0)","v":"COPASA"},542661.74,456566.29]
[312675,"Franciscópolis (MG)","DO4","COPASA",170627.28,175679.2]
[312690,"Frei Inocêncio (MG)","DO4","COPASA",941950.24,895949.09]
[312737,"Goiabeira (MG)","DO5","PMG",0,222501.84]
[312750,"Gonzaga (MG)","DO4","PMG",208882,171994]
[312770,"Governador Valadares (MG)","DO4","SAAE",33790439.140000001,39939762.600000001]
[312800,"Guanhães (MG)","DO4","SAAE",3315135.09,2523128.65]
[312820,"Guaraciaba (MG)","DO1","COPASA",408040.68,579358.47]
[312930,"Iapu (MG)","DO4","COPASA",801185.61,892660.69]
[320245,"Ibatiba (ES)","ES","CESAN",982069.13,1046220.7]
[313055,"Imbé de Minas (MG)","DO5","COPASA",182777.62,177745.76]
[313090,"Inhapim (MG)","DO5","COPASA",1768907.01,1577011.46]
[313115,"Ipaba (MG)","DO5","PMI",540,77140.600000000006]
[313120,"Ipanema (MG)","DO5","SAAE",1469460.49,1227638.1499999999]
[313130,"Ipatinga (MG)","DO2","COPASA",59418551.009999998,56300821.200000003]
[313170,"Itabira (MG)","DO3","SAAE-Itabira",15882410.630000001,16744088.470000001]
[320270,"Itaguaçu (ES)","ES","SAAE",774687,661156.04]
[313270,"Itambacuri (MG)","DO4","SAAE",1680787,1311937.8799999999]
[313320,"Itanhomi (MG)","DO5","COPASA",1352060.88,1228420.79]
[313390,"Itaverava (MG)","DO1","COPASA",230989.39,248024.73]
[313410,"Itueta (MG)","DO5","COPASA",472679.74,517123.25]
[320305,"Jaguaré (ES)","ES","SAAE",1375387.59,1595477.86]
[313550,"Jequeri (MG)","DO1","DEMAE",559129.63,508787.28]
[313610,"Joanésia (MG)","DO3","PM",0,82665.240000000005]
[313620,"João Monlevade (MG)","DO2","DAE",9609102.5299999993,7295505.8700000001]
[320313,"João Neiva (ES)","ES","SAAE",1552304,1122166]
[313655,"José Raydan (MG)","DO4","COPASA",221254.92,212058.55]
[313770,"Lajinha (MG)","DO5","SAAE",1110301.22,740534.4]
[313790,"Lamim (MG)","DO1","PML",0,98320]
[320316,"Laranja da Terra (ES)","ES","CESAN",389161.8,177696.21]
[320320,"Linhares (ES)","ES","SAAE",10652670.74,8484228]
[313920,"Malacacheta (MG)","DO4","COPASA",1796023.91,1915231.98]
[313940,"Manhuaçu (MG)","DO5",{"$f":"VLOOKUP(A102,Dados,6,0)","v":"SAAE"},6672539.4400000004,5450937.3499999996]
[313950,"Manhumirim (MG)","DO5","S A A E",692728.38,764181.48]
[320330,"Mantenópolis (ES)","ES","CESAN",1182037.04,796410.76]
[314000,"Mariana (MG)","DO1","SAAE",0,3486145.37]
[314010,"Marilac (MG)","DO4","COPASA",404924.36,528135.76]
[320335,"Marilândia (ES)","ES","SAAE",598415.88,549664.49]
[314030,"Marliéria (MG)","DO2","PM",0,207942]
[314053,"Martins Soares (MG)","DO5","COPASA",278507.86,306126.57]
[314060,"Materlândia (MG)","DO4","COPASA",258452.14,390409.59]
[317150,"Mathias Lobato (MG)","DO4","COPASA",328652.40999999997,303533.98]
[314090,"Matipó (MG)","DO1","COPASA",1531996.15,1531360.85]
[314160,"Mercês (MG)","DO1","COPASA",881740.9,739534.94]
[314400,"Mutum (MG)","DO5","COPASA",1744727.73,1628291.47]
[314420,"Nacip Raydan (MG)","DO4","COPASA",239681.39,298790.51]
[314435,"Naque (MG)","DO4","COPASA",744513.99,728778.13]
[320390,"Nova Venécia (ES)","ES","CESAN",3663150.64,3333660.58]
[314590,"Ouro Branco (MG)","DO1","COPASA",8925086.4399999995,9065378.8399999999]
[314610,"Ouro Preto (MG)","DO1","SEMAE-OP",872090.74,5607536]
[320400,"Pancas (ES)","ES","CESAN",922514.9,757155.72]
[314830,"Paula Cândido (MG)","DO1","COPASA",499379.29,538188.29]
[314840,"Paulistas (MG)","DO4","COPASA",262406.06,454400.88]
[314860,"Peçanha (MG)","DO4","COPASA",1101558.51,1158397.24]
[314875,"Pedra Bonita (MG)","DO1","PMPB",0,51083.7]
[314880,"Pedra do Anta (MG)","DO1","COPASA",228995.1,259338.82]
[314995,"Periquito (MG)","DO4","COPASA",798648.07,986125.46]
[315015,"Piedade de Caratinga (MG)","DO5","COPASA",418758.57,510369.32]
[315020,"Piedade de Ponte Nova (MG)","DO1","COPASA",373160.72,391269.87]
[315053,"Pingo d'Água (MG)","DO1","COPASA",494583.52,525191.23]
[315080,"Piranga (MG)","DO1","COPASA",735414.5,790466.93]
[315190,"Pocrane (MG)","DO5","PMP",0,174520]
[315210,"Ponte Nova (MG)","DO1","DMAES",7648378.8600000003,6101079.4699999997]
[315230,"Porto Firme (MG)","DO1","COPASA",549873.82999999996,563752.06000000006]
[315310,"Presidente Bernardes (MG)","DO1",{"$f":"VLOOKUP(A134,Dados,6,0)","v":"PMPB"},5000,11642.55]
[315400,"Raul Soares (MG)","DO1","SAAE",2251052,1839134]
[315415,"Reduto (MG)","DO5","PMR",39309.629999999997,42685.71]
[315430,"Resplendor (MG)","DO5","COPASA",2434727.7400000002,2373356.92]
[315440,"Ressaquinha (MG)","DO1","COPASA",292178.26,405244.07]
[320435,"Rio Bananal (ES)","ES","SAAE",948249.68,848374.15]
[315490,"Rio Casca (MG)","DO1","COPASA",1945490.05,2540433.6800000002]
[315500,"Rio Doce (MG)","DO1","PMRD",9784.26,102100.84]
[315520,"Rio Espera (MG)","DO1","COPASA",224763.67,288396.03000000003]
[315570,"Rio Piracicaba (MG)","DO2","COPASA",1772532.82,1789843.54]
[315600,"Rio Vermelho (MG)","DO4","COPASA",542469.92000000004,641435.48]
[315680,"Sabinópolis (MG)","DO4","SAAE",1032400.78,1150585.24]
[315720,"Santa Bárbara (MG)","DO2","COPASA",3161824.55,2886304.77]
[315725,"Santa Bárbara do Leste (MG)","DO5","COPASA",375346.21,383498.38]
[315740,"Santa Cruz do Escalvado (MG)","DO1","COPASA",191109.08,192692.95]
[315750,"Santa Efigênia de Minas (MG)","DO4","COPASA",289334.59999999998,352695]
[315790,"Santa Margarida (MG)","DO1","COPASA",878865,829910.22]
[315800,"Santa Maria de Itabira (MG)","DO3","COPASA",936892.54,906958.6]
[315820,"Santa Maria do Suaçuí (MG)","DO4","COPASA",1152843.43,1412644.25]
[315935,"Santa Rita de Minas (MG)","DO5","COPASA",510652.28,541694.01]
[315950,"Santa Rita do Itueto (MG)","DO5","PMSRI",0,65000]
[320460,"Santa Teresa (ES)","ES","CESAN",1863602.01,1345270.79]
[315890,"Santana do Manhuaçu (MG)","DO5","COPASA",401344.53,481596.77]
[315895,"Santana do Paraíso (MG)","DO3","COPASA",3987327.06,4300926.7300000004]
[316010,"Santo Antônio do Grama (MG)","DO1","COPASA",407986.01,441174.45]
[316095,"São Domingos das Dores (MG)","DO5","COPASA",184427.47,207773.59]
[320465,"São Domingos do Norte (ES)","ES","PMSDN",388039.03,382998.72]
[316100,"São Domingos do Prata (MG)","DO2","PMSDP",0,291534.07]
[320470,"São Gabriel da Palha (ES)","ES","CESAN",2925387.12,3029892.62]
[316150,"São Geraldo (MG)","DO1","COPASA",776425.61,811438.77]
[316160,"São Geraldo da Piedade (MG)","DO4","PMSGP",0,71424.399999999994]
[316165,"São Geraldo do Baixio (MG)","DO5","PMSGB",96000,141000]
[316255,"São João do Manhuaçu (MG)","DO5",{"$f":"VLOOKUP(A166,Dados,6,0)","v":"COPASA"},610874.39,810542.53]
[316260,"São João do Oriente (MG)","DO4","COPASA",731667.64,767967.4]
[316280,"São João Evangelista (MG)","DO4","PMSJE",0,62000]
[316300,"São José da Safira (MG)","DO4","COPASA",271084.69,396570.34]
[316340,"São José do Goiabal (MG)","DO1","COPASA",488200.87,494344.8]
[316350,"São José do Jacuri (MG)","DO4","COPASA",354036.47999999998,616243.14]
[316360,"São José do Mantimento (MG)","DO5","COPASA",206801.26,210188.85]
[320490,"São Mateus (ES)","ES","SAAE",8671547,8017414]
[316380,"São Miguel do Anta (MG)","DO1","COPASA",405359.65,408612.97]
[316410,"São Pedro do Suaçuí (MG)","DO4","COPASA",358831.03,449522.87]
[316400,"São Pedro dos Ferros (MG)","DO1","COPASA",789244.06,884527.43]
[320495,"São Roque do Canaã (ES)","ES","CESAN",569043.85,564537.12]
[316447,"São Sebastião do Anta (MG)","DO5","COPASA",322326.90000000002,343364.84]
[316450,"São Sebastião do Maranhão (MG)","DO4","COPASA",424152.83,576266.34]
[316480,"São Sebastião do Rio Preto (MG)","DO3","PMSSRP",19272,51208.32]
[316550,"Sardoá (MG)","DO4","COPASA",278219.08,251086.64]
[316570,"Senador Firmino (MG)","DO1","SAAE",604649,464661]
[316600,"Senhora de Oliveira (MG)","DO1","SAAE",200854.65,201638.25]
[316610,"Senhora do Porto (MG)","DO3","COPASA",147513.4,202430.13]
[316620,"Senhora dos Remédios (MG)","DO1","PMSR",0,270698.40999999997]
[316630,"Sericita (MG)","DO1","COPASA",352688.51,395984.17]
[316650,"Serra Azul de Minas (MG)","DO4","COPASA",281954.98,346947.57]
[316710,"Serro (MG)","DO3","COPASA",1753030.82,2184320.61]
[316760,"Simonésia (MG)","DO5","COPASA",730474.37,782435.6]
[316770,"Sobrália (MG)","DO4","COPASA",474276.75,526617.22]
[320501,"Sooretama (ES)","ES","SAAE",973238.36,913808.07]
[316805,"Taparuba (MG)","DO5","SAAE",133210.31,110029.95]
[316840,"Tarumirim (MG)","DO5","COPASA",1110338.05,1232069.45]
[316850,"Teixeiras (MG)","DO1","COPASA",958480.04,1181539.03]
[316870,"Timóteo (MG)","DO2","COPASA",11513184.1,11813458.75]
[316950,"Tumiritinga (MG)","DO5","COPASA",699852.17,786577.93]
[316990,"Ubá (MG)","DO1","COPASA",13154921.18,12483358.949999999]
[317005,"Ubaporanga (MG)","DO5",{"$f":"VLOOKUP(A198,Dados,6,0)","v":"COPASA"},636189.77,729262.13]
[317050,"Urucânia (MG)","DO1","COPASA",810987.87,1019749.35]
[317057,"Vargem Alegre (MG)","DO5","COPASA",709653.25,667510.66]
[317115,"Vermelho Novo (MG)","DO1","SAAE",229613,137314]
[317130,"Viçosa (MG)","DO1","SAAE",11094734,6114362]
[320517,"Vila Valério (ES)","ES","CESAN",433218.45,502242.72]
[317180,"Virginópolis (MG)","DO4","COPASA",843929.39,877495.55]
[317190,"Virgolândia (MG)","DO4","COPASA",416863.97,536351.41]

{"sheet":"Receita e Custo Ind.","index":6,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,4,1,5],[1,1,2,1],[1,2,2,2],[1,3,2,3]]}
[]
[null,"Receita Total","Custo Total","IGP-M dez 2009 - set 2013","Valores Corrigidos Inflação"]
[null,null,null,null,"Receita Total","Custo Total"]
[null,{"$f":"SUM(D9:D33)","v":14086188720},{"$f":"SUM(B8:B33)","v":14076504814},1.3080508739335901,{"$f":"B4*$D$4","v":18425451465.589478},{"$f":"C4*$D$4","v":18412784423.883087}]
[]
[null,{"$f":"SUM(B8:B33)","v":14076504814},{"$f":"SUM(C8:C33)","v":15813048418},{"$f":"SUM(D8:D33)","v":14861469018}]
[null,"Custos e Despesas","Valor Bruto da Produção Industrial","Receita líquida de vendas"]
["Frabric. de estru. metálicas para edifícios, pontes, torres de transmissao, andaimes e outros fins",598831989,781720043,775280298]
["Fabricação de móveis com predominância de madeira",700168127,653916228,651172157]
["Abate de reses, preparação de produtos de carne",454394749,478839854,489615965]
["Fab. Laticínios",295243631,315088553,250678015]
["Fab. Gases Ind.",201149196,301114235,306952617]
["Prod. Ferro Gusa",268555195,269141049,280430865]
["serv. Usinagem",89053307,267018878,267013023]
["Prep. Leite (laticínio)",242560871,251041083,241675010]
["Prod. Ferro Ligas",198725841,236760318,260071883]
["Trab. com pedras (não associado à extr.)",162354076,213845539,202835884]
["Fab. Cimento",215597937,182619941,128876477]
["Prod. Relaminados e perfilados de aço",169996984,179174724,180356972]
["Fab. Fert Fosfatados",166178239,166774464,178377120]
["Extração de Pedra areia e argila",126124337,130832193,127864593]
["Confecção de peças de vestuário",131877581,130648537,129341636]
["Fabricação de colchões",122177641,121696515,121007738]
["Fab outras máq. e equip",99364886,117129510,116717638]
["fab artefatos concreto",80683934,89397064,90164563]
["Man e reparaçao de maq e equip",74873429,84902941,85991300]
["reciclagem sucatas",69060494,80685566,88904554]
["abate de aves",60469281,61930159,67276849]
["Extração Min Ferro",9355300917,10502904924,9662679991]
["Extração Pedra Areia e Argila",126124337,130832193,127864593]
["Extração Min ñ metalico",30195498,33105384,30319277]
["Extração Min Metais Precisos",25860113,22191680]
["Extração Alumínio",11582224,9736843]

{"sheet":"Receita e Custo Irrig.","index":7,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,4,1,5],[1,2,2,2],[1,3,2,3]]}
[]
[null,"Custo","Receita","IGP-M Dez 2009 - Set 2013","Valores Atualizados Inflação"]
[null,null,null,null,"Custo","Receita"]
[null,{"$f":"SUM(F7:F15)","v":527510763.0052219},{"$f":"SUM(G7:G15)","v":764735171.09706962},1.3080508739335901,{"$f":"B4*$D4","v":690010914.55835545},{"$f":"C4*$D4","v":1000312508.8812754}]
[]
[]
[null,"Culturas Permanentes","Custo (R$/ha/ano)","Receita (R$/ha/ano)","Área Irrigada","Custo","Receita"]
[null,"Café Robusta",10015.788699999999,15273.4287,45552.583072022586,{"$f":"AVERAGE(C8:C9)*E8","v":390837885.24960166},{"$f":"AVERAGE(D8:D9)*E8","v":648290229.59212744}]
[null,"Café Arábica",7144.0673999999999,13189.950800000001]
[null,"Mamão",15420.666800000001,32314.615300000001,491.36376836080012,{"$f":"C10*$E10","v":7577156.9494842812},{"$f":"D10*$E10","v":15878231.146937568}]
[null,"Culturas Temporárias","Custo (R$/ha/safra)","Receita (R$/ha/safra)","Área Irrigada","Custo","Receita"]
[null,"Cana-de-açúcar",4158.1306999999997,2985.3643999999999,5913.2056833916486,{"$f":"C12*$E12","v":24587882.087525293},{"$f":"D12*$E12","v":17653073.737075098}]
[null,"Feijão",4060.5173,3224.3905,8436.9154816861137,34258241.272024296,27203910.12845163]
[null,"Milho",3310.8096,2147.9774000000002,17581.44896412078,58208830.012321137,37764555.034184851]
[null,"Batata",15860.145399999999,23637.449199999999,759.18392490053918,{"$f":"C15*$E15","v":12040767.434265232},{"$f":"D15*$E15","v":17945171.45829311}]