{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Resumo","Calculadora de Tarifas","Tutorial de preenchimento","Quadro Tarifário","Copasa","Copanor","Cesama","Saae Itabira","Saae Passos","Sae Ituiutaba"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Resumo","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"RESUMO"]
[]
[]
[null,"Data:"]
[]
[]
[null,"Resumo:"]
[]
[]
[null,"Objetivo:"]
[]
[]
[]
[]
[null,"Procedimentos:"]
[]
[]
[]
[null,"Conclusão:"]
[]
[]
[null,"ATENÇÃO:"]
[]
[]
[]
[]
[]
[null,"legendas:"]
[null,null,"Dados digitados (entrada manual)"]
[null,null,"Números que merecem cuidado"]
[null,null,"Totais"]
[null,null,"Resultados mais relevantes"]
[null,"A","Previsão ou alteração"]

{"sheet":"Calculadora de Tarifas","index":1,"n_rows":58,"n_cols":40,"rows_kept":58,"cut":false,"hidden":false,"merged":[[17,38,17,40],[16,25,16,26],[11,23,11,24],[12,23,12,24],[13,23,13,24],[14,23,14,24],[12,25,12,26],[12,27,12,28],[3,18,3,28],[5,17,5,19],[7,17,7,19],[9,17,9,19],[10,32,10,34],[9,23,9,24],[10,23,10,24],[9,25,9,26],[10,25,10,26],[10,17,10,19],[9,20,9,21],[10,20,10,21],[20,38,20,40],[15,33,15,34],[16,33,16,34],[17,33,17,34],[18,33,18,34],[19,33,19,34],[20,33,20,34],[15,35,15,36],[15,38,15,40],[16,38,16,40],[18,38,18,40],[16,35,16,36],[17,35,17,36],[18,35,18,36],[19,35,19,36],[19,38,19,40],[5,10,5,14],[8,12,8,14],[9,12,9,14],[22,18,23,28],[9,27,9,28],[10,27,10,28],[11,27,11,28],[13,27,13,28],[14,27,14,28],[15,27,15,28],[16,27,16,28],[18,18,21,21],[15,23,15,24],[16,23,16,24],[14,20,14,21],[15,20,15,21],[23,10,23,14],[12,31,12,33],[13,31,13,33],[10,12,10,14],[11,12,11,14],[14,12,14,13],[13,12,13,13],[16,20,16,21],[13,25,13,26],[14,25,14,26],[15,25,15,26],[13,20,13,21],[11,25,11,26],[11,20,11,21],[12,20,12,21],[29,17,29,22],[27,17,27,29],[28,17,28,21],[20,35,20,36],[5,20,5,22],[24,18,24,28],[25,18,25,22]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simulador de Faturas"]
[]
[null,null,null,null,null,null,null,null,null,null,"Simulador de Faturas",null,null,null,null,null,null,"   1 - Digite o volume total consumido (m³)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   2 - Clique no serviço oferecido",null,null,null,null,null,null,null,null,null,null,null,null,null,"Auxiliar de cálculo das macros"]
[null,null,1,"Volume Consumido",null,null,null,null,null,null,"1 - Digite o volume total consumido (m³)"]
[null,null,2,"Prestador","2.1","Copasa",null,null,null,null,"2 - Seu prestador",null,"Saae Itabira",null,null,null,null,"   3 - Digite o número de economias* ",null,null,"Categorias",null,"Número de economias","Valor Água",null,"Valor Esgoto",null,"Valor Total",null,null,null,1,"Índice Casa/Prédio"]
[null,null,null,null,"2.2","Copanor",null,null,null,null,"3 - Selecione a sua categoria",null,null,null,null,null,null,"        relativas a cada categoria ",null,null,{"$f":"IF($M$10=\"Cesama\",F25,IF($M$10=\"Copanor\",F33,F18))","v":"Residencial Social"},null,null,"",null,"",null,{"$f":"SUM(X11:AA11)","v":0},null,null,null,{"$f":"IF(AF10=1,1,IF(AF10=2,M15,\"Erro\"))","v":1},"Total de Economias Residenciais"]
[null,null,null,null,"2.3","Saae Itabira",null,null,null,null,"4 - Selecione o serviço oferecido",null,{"$f":"IF(AN7=1,\"Só água\",IF(AN7=2,\"Água e esgoto\",IF(AN7=3,\"Só esgoto\",\"\")))","v":"Água e esgoto"},null,null,null,null,null,null,null,"Residencial",null,null,"",null,"",null,0]
[null,null,null,null,"2.4","Saae Passos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comercial",null,null,"",null,"",null,0,null,null,null,{"$f":"U6/W17","v":{"$error":"#DIV/0!"}},null,null,"Volume por Economia"]
[null,null,null,null,"2.5","SAE Ituiutaba",null,null,null,null,"Casa",null,"Quantidade de apartamentos por hidrômetro",null,null,null,null,null,null,null,"Industrial",null,null,"",null,"",null,0,null,null,null,null,null,null,"Valor Original"]
[null,null,null,null,"2.6","Cesama",null,null,null,null,"Prédio",null,1,null,null,null,null,null,null,null,"Pública",null,null,"",null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,0,null,null,null,"","",{"$f":"IFERROR(ROUND(AF16*$W11,2),\"\")","v":""},null,{"$f":"IFERROR(ROUND(AG16*$W11,2),\"\")","v":""},null,null,{"$f":"IF($M$10=\"Cesama\",F25,IF($M$10=\"Copanor\",F33,F18))","v":"Residencial Social"}]
[null,null,3,"Categoria","COPASA, Saae de Passos, Itabira, Sae de Ituiutaba",null,null,null,null,null,"Serviço",null,"Água","Esgoto","Total",null,null,null,null,null,"Valor Total",null,{"$f":"SUM(W11:W16)","v":0},{"$f":"SUM(X11:Y16)","v":0},null,{"$f":"SUM(Z11:AA16)","v":0},null,0,null,null,null,"","",{"$f":"IFERROR(ROUND(AF17*$W12,2),\"\")","v":""},null,{"$f":"IFERROR(ROUND(AG17*$W12,2),\"\")","v":""},null,null,"Residencial"]
[null,null,null,null,"3.1","Residencial Social",null,null,null,null,"Valor",null,{"$f":"IFERROR(IF(OR(M12=F39,M12=F40,M12=F41,M12=F46,M12=F47,M12=F48,M12=F49,M12=F56,M12=F57),INDIRECT(\"'\"&M10&\"'!\"&\"T14\"),\"\")*AF11,\"\")","v":0},{"$f":"IFERROR(IF(OR(M12=F41,M12=F43,M12=F48,M12=F51),INDIRECT(\"'\"&M10&\"'!\"&\"v14\"),IF(OR(M12=F49,M12=F52),INDIRECT(\"'\"&M10&\"'!\"&\"w14\"),IF(OR(M12=F40,M12=F42,M12=F47,M12=F50,M12=F57,M12=F58),INDIRECT(\"'\"&M10&\"'!\"&\"u14\"),\"\")))*AF11,\"\")","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IFERROR(ROUND(AF18*$W13,2),\"\")","v":""},null,{"$f":"IFERROR(ROUND(AG18*$W13,2),\"\")","v":""},null,null,"Comercial"]
[null,null,null,null,"3.2","Residencial",null,null,null,null,null,null,null,null,null,null,null,null,"* Economia faz referência ao número de unidades familiares, comerciais ou produtivas que existem para um mesmo hidrômetro/ligação. Existindo em um mesma construção, com hidrômetro único, três famílias e duas lojas, têm-se 3 economias residenciais e 2 economias comerciais para 1 ligação",null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,null,"Industrial"]
[null,null,null,null,"3.3","Comercial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,null,"Pública"]
[null,null,null,null,"3.4","Industrial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,null,""]
[null,null,null,null,"3.5","Pública"]
[null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,"Cesama",null,null,null,null,null,"Agência Reguladora de Serviços de Abastecimento de Água e Esgotamento Sanitário do Estado de MG - ARSAE"]
[null,null,null,null,"3.1","Residencial Social",null,null,null,null,null,null,null,null,null,null,null,null,"Agência Reguladora de Serviços de Abastecimento de Água e Esgotamento Sanitário do Estado de MG - ARSAE"]
[null,null,null,null,"3.6","Residencial Unifamiliar"]
[null,null,null,null,"3.7","Residencial Multifamiliar"]
[null,null,null,null,"3.3","Comercial",null,null,null,null,null,null,null,null,null,null,null,"Notas: - Esta calculadora não é ajustada para cálculos em meses com mudança de tarifas. Nestas situações o prestador aplicará tanto as tarifas novas quanto as antigas de acordo com o período de leitura do                  "]
[null,null,null,null,"3.4","Industrial",null,null,null,null,null,null,null,null,null,null,null,"                     hidrômetro e com a data da mudança das tarifas, individualizando o cálculo."]
[null,null,null,null,"3.5","Pública",null,null,null,null,null,null,null,null,null,null,null,"                  - Diferenças de poucos centavos podem ocorrer devido a critérios de arredondamentos adotados. "]
[]
[null,null,null,null,"Copanor"]
[null,null,null,null,"3.2","Residencial"]
[null,null,null,null,"3.3","Comercial"]
[null,null,null,null,"3.4","Industrial"]
[null,null,null,null,"3.5","Pública"]
[null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,4,"Serviço oferecido","COPASA",{"$f":"\"\"","v":""}]
[null,null,null,null,"4.10","Só água"]
[null,null,null,null,"4.15","Água e coleta de esgoto"]
[null,null,null,null,"4.20","Água com coleta e tratamento de esgoto"]
[null,null,null,null,"4.25","Só coleta de esgoto"]
[null,null,null,null,"4.30","Só tratamento de esgoto"]
[]
[null,null,null,null,"COPANOR"]
[null,null,null,null,"4.10","Só água"]
[null,null,null,null,"4.15","Água e coleta de esgoto"]
[null,null,null,null,"4.20","Água e tratamento de esgoto"]
[null,null,null,null,"4.25","Água e esgoto estático"]
[null,null,null,null,"4.30","Só coleta de esgoto"]
[null,null,null,null,"4.35","Só tratamento de esgoto"]
[null,null,null,null,"4.40","Só esgoto estático"]
[]
[]
[null,null,null,null,"SAAE de Passos, Itabira, Sae de Ituiutaba e Cesama"]
[null,null,null,null,"4.1","Só água"]
[null,null,null,null,null,"Água e esgoto"]
[null,null,null,null,null,"Só esgoto"]

{"sheet":"Tutorial de preenchimento","index":2,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[7,21,10,32],[20,21,22,32]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPLO DE PREENCHIMENTO DO SIMULADOR"]

{"sheet":"Quadro Tarifário","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[6,15,6,19],[5,4,6,12]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Revisão Específica 2015\nTarifa de Aplicação (Novembro/15 a Outubro/16)"]

{"sheet":"Copasa","index":4,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":true,"merged":[[3,16,3,20],[4,16,5,16],[4,17,5,18],[4,19,5,20],[3,4,3,8],[4,4,4,10],[6,4,6,10],[7,4,7,10],[8,4,8,10],[9,4,9,10],[10,4,10,10],[11,5,14,5],[11,6,14,6],[11,7,11,10],[12,7,12,10],[13,10,14,10],[11,19,11,21],[43,4,49,4],[43,5,49,5],[25,4,30,4],[25,5,30,5],[31,4,35,4],[31,5,35,5],[36,4,42,4],[36,5,42,5],[15,4,16,4],[15,5,16,5],[17,4,22,4],[17,5,22,5],[23,4,24,4],[23,5,24,5],[11,4,14,4]]}
[null,null,null,null,null,"Título"]
[null,null,null,null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Tarifas Aplicáveis aos Usuários"]
[]
[null,null,null,null,"Considerar apenas as colunas correspondentes aos serviços prestados:"]
[null,null,null,null,"- Água: Abastecimento de água"]
[null,null,null,null,"- EDC: esgotamento dinâmico com coleta"]
[null,null,null,null,"- EDT: esgotamento dinâmico com coleta e tratamento"]
[]
[null,null,null,null,"Classe de Consumo","Código Tarifário","Intervalo de Consumo (m³)"," Tarifas de Aplicação",null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,null,"Maio/15 a Abril/16",null,null,null,null,null,null,null,null,null,null,null,"Água","EDC","EDT"]
[null,null,null,null,null,null,null,1,2,3,null,null,null,null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(IF(Q17=\"0\",SUMIFS(H16:H50,C16:C50,\"0\",B16:B50,Q14),SUMIFS(L16:L50,B16:B50,Q14,D16:D50,Q17)+(Q15-Q17)*SUMIFS(H16:H50,B16:B50,Q14,D16:D50,S17)-IF(Q14=\"Residencial Social\",IF(Q15<=10,(L18-L16),0),IF(Q14=\"Residencial\",IF(Q15<=10,(L26-L24),0)))-IF(Q15<=10,IF(Q14=\"Residencial Social\",IF(Q15>6,(Q15-A16)*(H19-H17),0),IF(Q14=\"Residencial\",IF(Q15>6,(Q15-A24)*(H27-H25),0))),0)))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(I16:I50,C16:C50,\"0\",B16:B50,Q14),SUMIFS(M16:M50,B16:B50,Q14,D16:D50,Q17)+(Q15-Q17)*SUMIFS(I16:I50,B16:B50,Q14,D16:D50,S17)-IF(Q14=\"Residencial Social\",IF(Q15<=10,(M18-M16),0),IF(Q14=\"Residencial\",IF(Q15<=10,(M26-M24),0)))-IF(Q15<=10,IF(Q14=\"Residencial Social\",IF(Q15>6,(Q15-A16)*(I19-I17),0),IF(Q14=\"Residencial\",IF(Q15>6,(Q15-A24)*(I27-I25),0))),0)))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(J16:J50,C16:C50,\"0\",B16:B50,Q14),SUMIFS(N16:N50,B16:B50,Q14,D16:D50,Q17)+(Q15-Q17)*SUMIFS(J16:J50,B16:B50,Q14,D16:D50,S17)-IF(Q14=\"Residencial Social\",IF(Q15<=10,(N18-N16),0),IF(Q14=\"Residencial\",IF(Q15<=10,(N26-N24),0)))-IF(Q15<=10,IF(Q14=\"Residencial Social\",IF(Q15>6,(Q15-A16)*(J19-J17),0),IF(Q14=\"Residencial\",IF(Q15>6,(Q15-A24)*(J27-J25),0))),0)))","v":0}]
[null,null,null,null,null,null,null,"Água","EDC","EDT",null,null,null,null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!U6/'Calculadora de Tarifas'!AF11","v":0}]
[6,"Residencial Social",0,"a","Residencial Tarifa Social até 10 m³","ResTS até 10 m³","0 - 6",9.56,4.79,8.6300000000000008,"R$/mês",{"$f":"H16","v":9.56},{"$f":"I16","v":4.79},{"$f":"J16","v":8.6300000000000008}]
[10,"Residencial Social",6,"b",null,null,"> 6 - 10",2.1280000000000001,1.0640000000000001,1.915,"R$/m³",{"$f":"L16+($A17-$A16)*H17","v":18.072000000000003},{"$f":"M16+($A17-$A16)*I17","v":9.0459999999999994},{"$f":"N16+($A17-$A16)*J17","v":16.29},null,null,{"$f":"IFERROR(INDEX(IF(B16:B50=Q14,D16:D50,\"Erro\"),MATCH(Q15,IF(B16:B50=Q14,D16:D50,\"Erro\"),1),),\"0\")","v":"0"},"a",{"$f":"IFERROR(INDEX(IF(B16:B50=Q14,D16:D50,\"Erro\"),MATCH(Q15,IF(B16:B50=Q14,D16:D50,\"Erro\"),1)+1,),\"6\")","v":"6"},"m³"]
[null,"Residencial Social",null,6,"Residencial\n Tarifa Social\n maior que 10 m³","ResTS > 10m³","0 - 6",10.08,5.05,9.06,"R$/mês",{"$f":"H18","v":10.08},{"$f":"I18","v":5.05},{"$f":"J18","v":9.06}]
[null,"Residencial Social",6,10,null,null,"> 6 - 10",2.2410000000000001,1.1220000000000001,2.0169999999999999,"R$/m³",{"$f":"L18+($D19-$D18)*H19","v":19.044},9.5380000000000003,17.128]
[null,"Residencial Social",10,15,null,null,"> 10 - 15",4.9029999999999996,2.4510000000000001,4.4119999999999999,"R$/m³",43.558999999999997,21.792999999999999,39.188000000000002]
[null,"Residencial Social",15,20,null,null,"> 15 - 20",5.4610000000000003,2.7309999999999999,4.9160000000000004,"R$/m³",70.864000000000004,35.448,63.768000000000001]
[null,"Residencial Social",20,40,null,null,"> 20 - 40",5.4870000000000001,2.7440000000000002,4.9390000000000001,"R$/m³",180.60400000000001,90.328000000000003,162.548]
[null,"Residencial Social",40,999999,null,null,"> 40",10.066000000000001,5.0350000000000001,9.06,"R$/m³"]
[6,"Residencial",0,"a","Residencial até 10 m³","Res até 10 m³","0 - 6",15.94,7.97,14.38,"R$/mês",{"$f":"H24","v":15.94},{"$f":"I24","v":7.97},{"$f":"J24","v":14.38}]
[10,"Residencial",6,"b",null,null,"> 6 - 10",2.661,1.33,2.3940000000000001,"R$/m³",{"$f":"L24+($A25-$A24)*H25","v":26.584},{"$f":"M24+($A25-$A24)*I25","v":13.29},{"$f":"N24+($A25-$A24)*J25","v":23.956000000000003}]
[null,"Residencial",null,6,"Residencial maior que 10 m³","Res > 10m³","0 - 6",16.8,8.4,15.1,"R$/mês",{"$f":"H26","v":16.8},{"$f":"I26","v":8.4},{"$f":"J26","v":15.1}]
[null,"Residencial",6,10,null,null,"> 6 - 10",2.8010000000000002,1.401,2.52,"R$/m³",{"$f":"L26+($D27-$D26)*H27","v":28.004000000000001},14.004000000000001,25.18]
[null,"Residencial",10,15,null,null,"> 10 - 15",5.4470000000000001,2.7240000000000002,4.9029999999999996,"R$/m³",55.239000000000004,27.624000000000002,49.694999999999993]
[null,"Residencial",15,20,null,null,"> 15 - 20",5.4610000000000003,2.7309999999999999,4.9160000000000004,"R$/m³",82.544000000000011,41.279000000000003,74.274999999999991]
[null,"Residencial",20,40,null,null,"> 20 - 40",5.4870000000000001,2.7440000000000002,4.9390000000000001,"R$/m³",192.28400000000002,96.159000000000006,173.05500000000001]
[null,"Residencial",40,999999,null,null,"> 40",10.066000000000001,5.0350000000000001,9.06,"R$/m³"]
[null,"Comercial",0,6,"Comercial","Com","0 - 6",25.79,12.9,23.23,"R$/mês",{"$f":"H32","v":25.79},{"$f":"I32","v":12.9},{"$f":"J32","v":23.23}]
[null,"Comercial",6,10,null,null,"> 6 - 10",4.2990000000000004,2.15,3.871,"R$/m³",{"$f":"L32+($D33-$D32)*H33","v":42.986000000000004},21.5,38.713999999999999]
[null,"Comercial",10,40,null,null,"> 10 - 40",8.2210000000000001,4.1109999999999998,7.3979999999999997,"R$/m³",289.61599999999999,144.82999999999998,260.654]
[null,"Comercial",40,100,null,null,"> 40 - 100",8.2880000000000003,4.1420000000000003,7.4589999999999996,"R$/m³",786.89599999999996,393.35,708.19399999999996]
[null,"Comercial",100,999999,null,null,"> 100",8.3290000000000006,4.1639999999999997,7.4960000000000004,"R$/m³"]
[null,"Industrial",0,6,"Industrial","Ind","0 - 6",27.37,13.69,24.64,"R$/mês",{"$f":"H37","v":27.37},{"$f":"I37","v":13.69},{"$f":"J37","v":24.64}]
[null,"Industrial",6,10,null,null,"> 6 - 10",4.5620000000000003,2.2810000000000001,4.1070000000000002,"R$/m³",{"$f":"L37+($D38-$D37)*H38","v":45.618000000000002},22.814,41.067999999999998]
[null,"Industrial",10,20,null,null,"> 10 - 20",7.992,3.996,7.1929999999999996,"R$/m³",125.53800000000001,62.774000000000001,112.99799999999999]
[null,"Industrial",20,40,null,null,"> 20 - 40",8.0169999999999995,4.0090000000000003,7.2149999999999999,"R$/m³",285.87799999999999,142.95400000000001,257.298]
[null,"Industrial",40,100,null,null,"> 40 -100",8.0950000000000006,4.0490000000000004,7.2850000000000001,"R$/m³",771.57799999999997,385.89400000000001,694.39800000000002]
[null,"Industrial",100,600,null,null,"> 100 - 600",8.3160000000000007,4.157,7.484,"R$/m³",4929.5779999999995,2464.3940000000002,4436.3980000000001]
[null,"Industrial",600,999999,null,null,"> 600",8.4049999999999994,4.202,7.5640000000000001,"R$/m³"]
[null,"Pública",0,6,"Pública","Pub","0 - 6",24.28,12.14,21.87,"R$/mês",{"$f":"H44","v":24.28},{"$f":"I44","v":12.14},{"$f":"J44","v":21.87}]
[null,"Pública",6,10,null,null,"> 6 - 10",4.0490000000000004,2.0249999999999999,3.6419999999999999,"R$/m³",{"$f":"L44+($D45-$D44)*H45","v":40.475999999999999},20.240000000000002,36.438000000000002]
[null,"Pública",10,20,null,null,"> 10 - 20",6.9820000000000002,3.49,6.2830000000000004,"R$/m³",110.29600000000001,55.140000000000008,99.268000000000001]
[null,"Pública",20,40,null,null,"> 20 - 40",8.4390000000000001,4.218,7.5949999999999998,"R$/m³",279.07600000000002,139.5,251.16800000000001]
[null,"Pública",40,100,null,null,"> 40 -100",8.5459999999999994,4.274,7.6929999999999996,"R$/m³",791.83600000000001,395.94,712.74800000000005]
[null,"Pública",100,300,null,null,"> 100 - 300",8.5709999999999997,4.2850000000000001,7.7130000000000001,"R$/m³",2506.0360000000001,1252.94,2255.348]
[null,"Pública",300,999999,null,null,"> 300",8.6440000000000001,4.3230000000000004,7.78,"R$/m³"]

{"sheet":"Copanor","index":5,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[[11,19,11,22],[31,4,38,4],[31,5,38,5],[39,4,46,4],[39,5,46,5],[15,4,17,4],[15,5,17,5],[18,4,24,4],[18,5,24,5],[25,4,30,4],[25,5,30,5],[4,4,4,11],[11,4,14,4],[11,5,14,5],[11,6,14,6],[11,7,11,11],[12,7,12,11],[13,7,14,7],[13,8,13,10],[13,11,14,11]]}
[null,null,"Título"]
[null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Tarifas Aplicáveis aos Usuários"]
[null,null,null,null,"Considerar apenas as colunas correspondentes aos serviços prestados:"]
[null,null,null,null,"- Água: Abastecimento de água"]
[null,null,null,null,"- EDT: esgotamento dinâmico com coleta e tratamento"]
[null,null,null,null,"- EDC: esgotamento dinâmico com coleta, sem tratamento"]
[null,null,null,null,"- EE: esgotamento estático (fossa)"]
[]
[null,null,null,null,"Categoria","Código Tarifário","Intervalo de Consumo m³"," Tarifas",null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,null,"R$/m³",null,null,null,null,null,null,null,null,null,null,null,"Água","EDC","EDT","EE"]
[null,null,null,null,null,null,null,"Água","Esgoto",null,null,null,null,null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(IF(Q17=\"0\",SUMIFS(H16:H47,C16:C47,\"0\",B16:B47,Q14),SUMIFS(M16:M47,B16:B47,Q14,D16:D47,Q17)+(Q15-Q17)*SUMIFS(H16:H47,B16:B47,Q14,D16:D47,S17)-IF(Q14=\"Residencial\",IF(Q15<=10,(M19-M16),0))-IF(Q14=\"Residencial\",IF(Q15<=10,IF(Q15>6,(Q15-6)*(H21-H18)+3*(H20-H17),0))))-IF(Q14=\"Residencial\",IF(Q15<=6,IF(Q15>3,(Q15-3)*(H20-H17),0),0),0))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(J16:J47,C16:C47,\"0\",B16:B47,Q14),SUMIFS(O16:O47,B16:B47,Q14,D16:D47,Q17)+(Q15-Q17)*SUMIFS(J16:J47,B16:B47,Q14,D16:D47,S17)-IF(Q14=\"Residencial\",IF(Q15<=10,(O19-O16),0))-IF(Q14=\"Residencial\",IF(Q15<=10,IF(Q15>6,(Q15-6)*(J21-J18)+3*(J20-J17),0))))-IF(Q14=\"Residencial\",IF(Q15<=6,IF(Q15>3,(Q15-3)*(J20-J17),0),0),0))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(I16:I47,C16:C47,\"0\",B16:B47,Q14),SUMIFS(N16:N47,B16:B47,Q14,D16:D47,Q17)+(Q15-Q17)*SUMIFS(I16:I47,B16:B47,Q14,D16:D47,S17)-IF(Q14=\"Residencial\",IF(Q15<=10,(N19-N16),0))-IF(Q14=\"Residencial\",IF(Q15<=10,IF(Q15>6,(Q15-6)*(I21-I18)+3*(I20-I17),0))))-IF(Q14=\"Residencial\",IF(Q15<=6,IF(Q15>3,(Q15-3)*(I20-I17),0),0),0))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(K16:K47,C16:C47,\"0\",B16:B47,Q14),SUMIFS(P16:P47,B16:B47,Q14,D16:D47,Q17)+(Q15-Q17)*SUMIFS(K16:K47,B16:B47,Q14,D16:D47,S17)-IF(Q14=\"Residencial\",IF(Q15<=10,(P19-P16),0))-IF(Q14=\"Residencial\",IF(Q15<=10,IF(Q15>6,(Q15-6)*(K21-K18)+3*(K20-K17),0))))-IF(Q14=\"Residencial\",IF(Q15<=6,IF(Q15>3,(Q15-3)*(K20-K17),0),0),0))","v":0}]
[null,null,null,null,null,null,null,null,"EDT","EDC","EE",null,null,null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!M9/'Calculadora de Tarifas'!AF11","v":0}]
[3,"Residencial",0,"a","Residencial\n até 10 m³","Res até 10 m³","0 - 3",4.1100000000000003,3.71,2.0699999999999998,1.24,"R$/mês",{"$f":"H16","v":4.1100000000000003},{"$f":"I16","v":3.71},{"$f":"J16","v":2.0699999999999998},{"$f":"K16","v":1.24}]
[6,"Residencial",3,"b",null,null,"> 3 - 6",1.37,1.24,0.69,0.42,"R$/m³",{"$f":"M16+($A17-$A16)*H17","v":8.2200000000000006},7.43,4.1399999999999997,2.5,{"$f":"IFERROR(INDEX(IF(B16:B47=Q14,D16:D47,\"Erro\"),MATCH(Q15,IF(B16:B47=Q14,D16:D47,\"Erro\"),1),),\"0\")","v":"0"},"a",{"$f":"IFERROR(INDEX(IF(B16:B47=Q14,D16:D47,\"Erro\"),MATCH(Q15,IF(B16:B47=Q14,D16:D47,\"Erro\"),1)+1,),\"3\")","v":"3"},"m³"]
[10,"Residencial",6,"c",null,null,"> 6 - 10",1.4430000000000001,1.2989999999999999,0.72099999999999997,0.436,"R$/m³",13.992000000000001,12.625999999999999,7.0239999999999991,4.2439999999999998]
[null,"Residencial",null,3,"Residencial\n maior que 10 m³","Res > 10m³","0 - 3",4.3600000000000003,3.92,2.1800000000000002,1.31,"R$/mês",{"$f":"H19","v":4.3600000000000003},{"$f":"I19","v":3.92},{"$f":"J19","v":2.1800000000000002},{"$f":"K19","v":1.31}]
[null,"Residencial",3,6,null,null,"> 3 - 6",1.46,1.31,0.73,0.43,"R$/m³",{"$f":"M19+($D20-$D19)*H20","v":8.74},{"$f":"N19+($D20-$D19)*I20","v":7.85},{"$f":"O19+($D20-$D19)*J20","v":4.37},{"$f":"P19+($D20-$D19)*K20","v":2.6}]
[null,"Residencial",6,10,null,null,"> 6 - 10",1.518,1.367,0.75900000000000001,0.45800000000000002,"R$/m³",{"$f":"M20+($D21-$D20)*H21","v":14.812000000000001},13.318,{"$f":"O20+($D21-$D20)*J21","v":7.4060000000000006},4.4320000000000004]
[null,"Residencial",10,15,null,null,"> 10 - 15",2.9670000000000001,2.67,1.484,0.89500000000000002,"R$/m³",29.647000000000002,26.667999999999999,14.826000000000001,8.907]
[null,"Residencial",15,20,null,null,"> 15 - 20",5.0129999999999999,4.5119999999999996,2.5070000000000001,1.512,"R$/m³",54.712000000000003,49.227999999999994,27.361000000000001,16.466999999999999]
[null,"Residencial",20,40,null,null,"> 20 - 40",5.1890000000000001,4.67,2.5939999999999999,1.5640000000000001,"R$/m³",158.49200000000002,142.62799999999999,79.241,47.747]
[null,"Residencial",40,999999,null,null,"> 40",9.1690000000000005,8.2520000000000007,4.585,2.766,"R$/m³"]
[null,"Comercial",0,3,"Comercial","Com","0 - 3",10.43,9.3800000000000008,5.21,3.15,"R$/mês",{"$f":"H26","v":10.43},{"$f":"I26","v":9.3800000000000008},{"$f":"J26","v":5.21},{"$f":"K26","v":3.15}]
[null,"Comercial",3,6,null,null,"> 3 - 6",3.48,3.12,1.73,1.04,"R$/m³",{"$f":"M26+($D27-$D26)*H27","v":20.869999999999997},18.740000000000002,10.399999999999999,6.27]
[null,"Comercial",6,10,null,null,"> 6 - 10",3.4820000000000002,3.1349999999999998,1.7410000000000001,1.0489999999999999,"R$/m³",34.798000000000002,31.28,17.363999999999997,10.465999999999999]
[null,"Comercial",10,40,null,null,"> 10 - 40",5.9930000000000003,5.3929999999999998,2.9969999999999999,1.8069999999999999,"R$/m³",214.58800000000002,193.07,107.274,64.676000000000002]
[null,"Comercial",40,100,null,null,"> 40 - 100",7.1319999999999997,6.4180000000000001,3.5670000000000002,2.1509999999999998,"R$/m³",642.50800000000004,578.15,321.29399999999998,193.73599999999999]
[null,"Comercial",100,999999,null,null,"> 100",7.21,6.4880000000000004,3.605,2.1739999999999999,"R$/m³"]
[null,"Industrial",0,3,"Industrial","Ind","0 - 3",10.43,9.3800000000000008,5.21,3.15,"R$/mês",{"$f":"H32","v":10.43},{"$f":"I32","v":9.3800000000000008},{"$f":"J32","v":5.21},{"$f":"K32","v":3.15}]
[null,"Industrial",3,6,null,null,"> 3 - 6",3.48,3.12,1.73,1.04,"R$/m³",{"$f":"M32+($D33-$D32)*H33","v":20.869999999999997},{"$f":"N32+($D33-$D32)*I33","v":18.740000000000002},{"$f":"O32+($D33-$D32)*J33","v":10.399999999999999},{"$f":"P32+($D33-$D32)*K33","v":6.27}]
[null,"Industrial",6,10,null,null,"> 6 - 10",3.4820000000000002,3.1349999999999998,1.7410000000000001,1.0489999999999999,"R$/m³",{"$f":"M33+($D34-$D33)*H34","v":34.798000000000002},31.28,{"$f":"O33+($D34-$D33)*J34","v":17.363999999999997},10.465999999999999]
[null,"Industrial",10,20,null,null,"> 10 - 20",5.9930000000000003,5.3929999999999998,2.9969999999999999,1.8069999999999999,"R$/m³",94.728000000000009,85.210000000000008,47.333999999999996,28.536000000000001]
[null,"Industrial",20,40,null,null,"> 20 - 40",5.9930000000000003,5.3929999999999998,2.9969999999999999,1.8069999999999999,"R$/m³",214.58800000000002,193.07,107.274,64.676000000000002]
[null,"Industrial",40,100,null,null,"> 40 -100",7.1319999999999997,6.4180000000000001,3.5670000000000002,2.1509999999999998,"R$/m³",642.50800000000004,578.15,321.29399999999998,193.73599999999999]
[null,"Industrial",100,600,null,null,"> 100 - 600",7.21,6.4880000000000004,3.605,2.1739999999999999,"R$/m³",4247.5079999999998,3822.15,2123.7939999999999,1280.7359999999999]
[null,"Industrial",600,999999,null,null,"> 600",7.21,6.4880000000000004,3.605,2.1739999999999999,"R$/m³"]
[null,"Pública",0,3,"Pública","Pub","0 - 3",9.9,8.91,4.96,2.99,"R$/mês",{"$f":"H40","v":9.9},{"$f":"I40","v":8.91},{"$f":"J40","v":4.96},{"$f":"K40","v":2.99}]
[null,"Pública",3,6,null,null,"> 3 - 6",3.3,2.97,1.65,0.99,"R$/m³",{"$f":"M40+($D41-$D40)*H41","v":19.799999999999997},{"$f":"N40+($D41-$D40)*I41","v":17.82},{"$f":"O40+($D41-$D40)*J41","v":9.91},{"$f":"P40+($D41-$D40)*K41","v":5.96}]
[null,"Pública",6,10,null,null,"> 6 - 10",3.3079999999999998,2.9780000000000002,1.653,0.997,"R$/m³",{"$f":"M41+($D42-$D41)*H42","v":33.031999999999996},29.731999999999999,{"$f":"O41+($D42-$D41)*J42","v":16.521999999999998},9.9480000000000004]
[null,"Pública",10,20,null,null,"> 10 - 20",5.694,5.1239999999999997,2.847,1.7170000000000001,"R$/m³",89.971999999999994,80.971999999999994,44.991999999999997,27.118000000000002]
[null,"Pública",20,40,null,null,"> 20 - 40",5.694,5.1239999999999997,2.847,1.7170000000000001,"R$/m³",203.85199999999998,183.452,101.93199999999999,61.458000000000006]
[null,"Pública",40,100,null,null,"> 40 -100",6.7750000000000004,6.0970000000000004,3.3889999999999998,2.044,"R$/m³",610.35199999999998,549.27200000000005,305.27199999999993,184.09800000000001]
[null,"Pública",100,300,null,null,"> 100 - 300",6.8479999999999999,6.1639999999999997,3.4249999999999998,2.0659999999999998,"R$/m³",1979.9519999999998,1782.0720000000001,990.27199999999993,597.298]
[null,"Pública",300,999999,null,null,"> 300",6.8479999999999999,6.1639999999999997,3.4249999999999998,2.0659999999999998,"R$/m³"]

{"sheet":"Cesama","index":6,"n_rows":46,"n_cols":21,"rows_kept":46,"cut":false,"hidden":true,"merged":[[31,4,35,4],[36,4,40,4],[41,4,45,4],[10,4,10,9],[11,19,11,20],[11,4,12,4],[11,5,12,5],[11,6,11,9],[13,4,18,4],[19,4,24,4],[25,4,30,4]]}
[null,null,"Título"]
[null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Reajuste 2015\nTarifa de Aplicação (abr/15 - mar/16)"]
[null,null,null,null,"Categorias","Faixas","Tarifas",null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,"Água","Esgoto (%)","Esgoto","unidade",null,null,null,null,null,null,null,null,null,"Água","Esgoto"]
[null,"Residencial Social",0,5,"Residencial \nTarifa Social","0 a 5 m³",0.82989999999999997,0.59995180142185811,0.49790000000000001,"R$/m³",{"$f":"G14*5","v":4.1494999999999997},null,{"$f":"I14*5","v":2.4895},null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(IF(Q17=\"0\",SUMIFS(G14:G46,B14:B46,Q14,D14:D46,S17)*S17,SUMIFS(K14:K46,B14:B46,Q14,D14:D46,Q17)+(Q15-Q17)*SUMIFS(G14:G46,B14:B46,Q14,D14:D46,S17)))","v":{"$error":"#VALUE!"}},{"$f":"(IF(Q17=\"0\",SUMIFS(I14:I46,B14:B46,Q14,D14:D46,S17)*S17,SUMIFS(M14:M50,B14:B50,Q14,D14:D50,Q17)+(Q15-Q17)*SUMIFS(I14:I50,B14:B50,Q14,D14:D50,S17)))","v":{"$error":"#VALUE!"}}]
[null,"Residencial Social",5,10,null,"> 5 a 10 m³",1.1067,0.59998192825517305,0.66400000000000003,"R$/m³",{"$f":"K14+($D15-$D14)*G15","v":9.6829999999999998},null,{"$f":"M14+($D15-$D14)*I15","v":5.8094999999999999},null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!U6/'Calculadora de Tarifas'!AF11","v":0}]
[null,"Residencial Social",10,20,null,"> 10 a 20 m³",1.7159,0.79998834430910892,1.3727,"R$/m³",{"$f":"K15+($D16-$D15)*G16","v":26.841999999999999},null,{"$f":"M15+($D16-$D15)*I16","v":19.5365}]
[null,"Residencial Social",20,30,null,"> 20 a 30 m³ ",4.0526,1,4.0526,"R$/m³",{"$f":"K16+($D17-$D16)*G17","v":67.367999999999995},null,{"$f":"M16+($D17-$D16)*I17","v":60.0625},null,null,null,{"$f":"IFERROR(INDEX(IF(B14:B46=Q14,D14:D46,\"Erro\"),MATCH(Q15,IF(B14:B46=Q14,D14:D46,\"Erro\"),1),),\"0\")","v":"0"},"a",{"$f":"IFERROR(INDEX(IF(B14:B46=Q14,D14:D46,\"Erro\"),MATCH(Q15,IF(B14:B46=Q14,D14:D46,\"Erro\"),1)+1,),IF(Q14=\"Residencial Social\",\"5\",IF(Q14=\"Residencial Unifamiliar\",\"5\",IF(Q14=\"Residencial Multifamiliar\",\"5\",IF(Q14=\"Comercial\",\"10\",IF(Q14=\"Industrial\",\"30\",IF(Q14=\"Pública\",\"15\",\"\")))))))","v":""},"m³"]
[null,"Residencial Social",30,50,null,"> 30 a 50 m³",4.2910000000000004,1,4.2910000000000004,"R$/m³",{"$f":"K17+($D18-$D17)*G18","v":153.18799999999999},null,{"$f":"M17+($D18-$D17)*I18","v":145.88249999999999}]
[null,"Residencial Social",50,999999,null,"> 50 m³",5.7213000000000003,1,5.7213000000000003,"R$/m³"]
[null,"Residencial Unifamiliar",0,5,"Residencial Unifamiliar","0 a 5 m³",2.0746000000000002,0.60001928082521916,1.2447999999999999,"R$/m³",{"$f":"G20*5","v":10.373000000000001},null,{"$f":"I20*5","v":6.2239999999999993}]
[null,"Residencial Unifamiliar",5,10,null,"> 5 a 10 m³",2.2132999999999998,0.59996385487733261,1.3279000000000001,"R$/m³",{"$f":"K20+($D21-$D20)*G21","v":21.439500000000002},null,{"$f":"M20+($D21-$D20)*I21","v":12.863499999999998}]
[null,"Residencial Unifamiliar",10,20,null,"> 10 a 20 m³",2.86,0.79996503496503502,2.2879,"R$/m³",{"$f":"K21+($D22-$D21)*G22","v":50.039500000000004},null,{"$f":"M21+($D22-$D21)*I22","v":35.7425}]
[null,"Residencial Unifamiliar",20,30,null,"> 20 a 30 m³ ",4.0526,1,4.0526,"R$/m³",{"$f":"K22+($D23-$D22)*G23","v":90.5655},null,{"$f":"M22+($D23-$D22)*I23","v":76.268499999999989}]
[null,"Residencial Unifamiliar",30,50,null,"> 30 a 50 m³",4.2910000000000004,1,4.2910000000000004,"R$/m³",{"$f":"K23+($D24-$D23)*G24","v":176.38550000000001},null,{"$f":"M23+($D24-$D23)*I24","v":162.08850000000001}]
[null,"Residencial Unifamiliar",50,999999,null,"> 50 m³",5.7213000000000003,1,5.7213000000000003,"R$/m³"]
[null,"Residencial Multifamiliar",0,5,"Residencial Multifamiliar","0 a 5 m³",2.0746000000000002,1,2.0746000000000002,"R$/m³",{"$f":"G26*5","v":10.373000000000001},null,{"$f":"I26*5","v":10.373000000000001}]
[null,"Residencial Multifamiliar",5,10,null,"> 5 a 10 m³",2.2132999999999998,1,2.2132999999999998,"R$/m³",{"$f":"K26+($D27-$D26)*G27","v":21.439500000000002},null,{"$f":"M26+($D27-$D26)*I27","v":21.439500000000002}]
[null,"Residencial Multifamiliar",10,20,null,"> 10 a 20 m³",2.86,1,2.86,"R$/m³",{"$f":"K27+($D28-$D27)*G28","v":50.039500000000004},null,{"$f":"M27+($D28-$D27)*I28","v":50.039500000000004}]
[null,"Residencial Multifamiliar",20,30,null,"> 20 a 30 m³ ",4.0526,1,4.0526,"R$/m³",{"$f":"K28+($D29-$D28)*G29","v":90.5655},null,{"$f":"M28+($D29-$D28)*I29","v":90.5655}]
[null,"Residencial Multifamiliar",30,50,null,"> 30 a 50 m³",4.2910000000000004,1,4.2910000000000004,"R$/m³",{"$f":"K29+($D30-$D29)*G30","v":176.38550000000001},null,{"$f":"M29+($D30-$D29)*I30","v":176.38550000000001}]
[null,"Residencial Multifamiliar",50,999999,null,"> 50 m³",5.7213000000000003,1,5.7213000000000003,"R$/m³"]
[null,"Comercial",0,10,"Comercial","0 a 10 m³",2.9744000000000002,1,2.9744000000000002,"R$/m³",{"$f":"G32*10","v":29.744},null,{"$f":"I32*10","v":29.744}]
[null,"Comercial",10,20,null,"> 10 a 20 m³",4.0609000000000002,1,4.0609000000000002,"R$/m³",{"$f":"K32+($D33-$D32)*G33","v":70.353000000000009},null,{"$f":"M32+($D33-$D32)*I33","v":70.353000000000009}]
[null,"Comercial",20,30,null,"> 20 a 30 m³ ",4.2500999999999998,1,4.2500999999999998,"R$/m³",{"$f":"K33+($D34-$D33)*G34","v":112.85400000000001},null,{"$f":"M33+($D34-$D33)*I34","v":112.85400000000001}]
[null,"Comercial",30,50,null,"> 30 a 50 m³",4.6745999999999999,1,4.6745999999999999,"R$/m³",{"$f":"K34+($D35-$D34)*G35","v":206.346},null,{"$f":"M34+($D35-$D34)*I35","v":206.346}]
[null,"Comercial",50,999999,null,"> 50",5.6658999999999997,1,5.6658999999999997,"R$/m³"]
[null,"Industrial",0,30,"Industrial","0 a 30 m³",2.9744000000000002,1,2.9744000000000002,"R$/m³",{"$f":"G37*30","v":89.231999999999999},null,{"$f":"I37*30","v":89.231999999999999}]
[null,"Industrial",30,50,null,"> 30 a 50 m³",4.0609000000000002,1,4.0609000000000002,"R$/m³",{"$f":"K37+($D38-$D37)*G38","v":170.45},null,{"$f":"M37+($D38-$D37)*I38","v":170.45}]
[null,"Industrial",50,75,null,"> 50 a 75 m³",4.2500999999999998,1,4.2500999999999998,"R$/m³",{"$f":"K38+($D39-$D38)*G39","v":276.70249999999999},null,{"$f":"M38+($D39-$D38)*I39","v":276.70249999999999}]
[null,"Industrial",75,100,null,"> 75 a 100 m³",4.6745999999999999,1,4.6745999999999999,"R$/m³",{"$f":"K39+($D40-$D39)*G40","v":393.5675},null,{"$f":"M39+($D40-$D39)*I40","v":393.5675}]
[null,"Industrial",100,999999,null,"> 100",5.6658999999999997,1,5.6658999999999997,"R$/m³"]
[null,"Pública",0,15,"Pública","0 a 15 m³",2.3372000000000002,1,2.3372000000000002,"R$/m³",{"$f":"G42*15","v":35.058},null,{"$f":"I42*15","v":35.058}]
[null,"Pública",15,20,null,"> 15 a 20 m³",2.4929999999999999,1,2.4929999999999999,"R$/m³",{"$f":"K42+($D43-$D42)*G43","v":47.522999999999996},null,{"$f":"M42+($D43-$D42)*I43","v":47.522999999999996}]
[null,"Pública",20,30,null,"> 20 a 30 m³ ",2.7006999999999999,1,2.7006999999999999,"R$/m³",{"$f":"K43+($D44-$D43)*G44","v":74.53},null,{"$f":"M43+($D44-$D43)*I44","v":74.53}]
[null,"Pública",30,50,null,"> 30 a 50 m³",2.9083999999999999,1,2.9083999999999999,"R$/m³",{"$f":"K44+($D45-$D44)*G45","v":132.69800000000001},null,{"$f":"M44+($D45-$D44)*I45","v":132.69800000000001}]
[null,"Pública",50,999999,null,"> 50",3.1684000000000001,1,3.1684000000000001,"R$/m³"]

{"sheet":"Saae Itabira","index":7,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":true,"merged":[[33,4,38,4],[39,4,44,4],[10,4,10,8],[11,19,11,20],[11,4,12,4],[11,5,12,5],[11,6,11,8],[13,4,19,4],[20,4,26,4],[27,4,32,4]]}
[null,null,"Título"]
[null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Revisão Específica 2015\nTarifa de Aplicação Novembro/15 a Outubro/16)"]
[null,null,null,null,"Categorias","Faixas","Tarifas",null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,"Água","Esgoto","unidade",null,null,null,null,null,null,null,null,null,null,"Água","Esgoto"]
[null,"Residencial Social",null,0,"Residencial\n Tarifa Social","Disponibilidade",8.3935999999999993,5.0339,"R$/mês",null,null,null,null,null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(SUMIFS(J14:J45,B14:B45,Q14,D14:D45,Q17)+(Q15-Q17)*SUMIFS(G14:G45,B14:B45,Q14,D14:D45,S17)+IF(Q17=0,SUMIFS(G14:G45,B14:B45,Q14,D14:D45,Q17),0))","v":0},{"$f":"(SUMIFS(K14:K45,B14:B45,Q14,D14:D45,Q17)+(Q15-Q17)*SUMIFS(H14:H45,B14:B45,Q14,D14:D45,S17)+IF(Q17=0,SUMIFS(H14:H45,B14:B45,Q14,D14:D45,Q17),0))","v":0}]
[null,"Residencial Social",0,5,null,"0 a 5 m³",0.58760000000000001,0.3548,"R$/m³",{"$f":"G14+($D15-$C15)*G15","v":11.3316},{"$f":"H14+($D15-$C15)*H15","v":6.8079000000000001},null,null,null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!U6/'Calculadora de Tarifas'!AF11","v":0}]
[null,"Residencial Social",5,10,null,"> 5 a 10 m³",0.79830000000000001,0.4768,"R$/m³",{"$f":"J15+($D16-$C16)*G16","v":15.3231},9.1919000000000004]
[null,"Residencial Social",10,15,null,"> 10 a 15 m³",0.99790000000000001,0.59870000000000001,"R$/m³",20.3126,12.185400000000001,null,null,null,null,null,{"$f":"IFERROR(INDEX(IF(B14:B45=Q14,D14:D45,\"Erro\"),MATCH(Q15,IF(B14:B45=Q14,D14:D45,\"Erro\"),1),),\"0\")","v":"0"},"a",{"$f":"IFERROR(INDEX(IF(B14:B45=Q14,D14:D45,\"Erro\"),MATCH(Q15,IF(B14:B45=Q14,D14:D45,\"Erro\"),1)+1,),IF(Q14=\"Residencial Social\",\"5\",IF(Q14=\"Residencial\",\"5\",IF(Q14=\"Comercial\",\"10\",IF(Q14=\"Industrial\",\"15\",IF(Q14=\"Pública\",\"10\",\"\"))))))","v":""},"m³"]
[null,"Residencial Social",15,20,null,"> 15 a 20 m³",1.8072999999999999,1.0844,"R$/m³",29.3491,17.607400000000002]
[null,"Residencial Social",20,30,null,"> 20 a 30 m³",2.9937999999999998,1.7963,"R$/m³",59.287099999999995,35.570400000000006]
[null,"Residencial Social",30,999999,null,"> 30 m³",4.6901999999999999,2.8140999999999998,"R$/m³"]
[null,"Residencial",null,0,"Residencial\nNormal","Disponibilidade",13.981999999999999,8.3935999999999993,"R$/mês"]
[null,"Residencial",0,5,null,"0 a 5 m³",0.97570000000000001,0.5766,"R$/m³",{"$f":"G21+($D22-$C22)*G22","v":18.860499999999998},{"$f":"H21+($D22-$C22)*H22","v":11.276599999999998}]
[null,"Residencial",5,10,null,"> 5 a 10 m³",1.0089999999999999,0.60980000000000001,"R$/m³",{"$f":"J22+($D23-$C23)*G23","v":23.905499999999996},14.325599999999998]
[null,"Residencial",10,15,null,"> 10 a 15 m³",1.1088,0.6653,"R$/m³",29.449499999999997,17.652099999999997]
[null,"Residencial",15,20,null,"> 15 a 20 m³",1.8072999999999999,1.0866,"R$/m³",38.485999999999997,23.085099999999997]
[null,"Residencial",20,30,null,"> 20 a 30 m³",2.9937999999999998,1.7963,"R$/m³",68.423999999999992,41.048099999999998]
[null,"Residencial",30,999999,null,"> 30 m³",4.6901999999999999,2.8163,"R$/m³"]
[null,"Comercial",null,0,"Comercial","Disponibilidade",16.787199999999999,10.079000000000001,"R$/mês"]
[null,"Comercial",0,10,null,"0 a 10 m³",1.3971,0.83160000000000001,"R$/m³",{"$f":"G28+($D29-$C29)*G29","v":30.758199999999999},{"$f":"H28+($D29-$C29)*H29","v":18.395000000000003}]
[null,"Comercial",10,20,null,"> 10 a 20 m³",2.3727999999999998,1.4302999999999999,"R$/m³",{"$f":"J29+($D30-$C30)*G30","v":54.486199999999997},32.698]
[null,"Comercial",20,30,null,"> 20 a 30 m³",2.6610999999999998,1.5967,"R$/m³",81.097199999999987,48.664999999999999]
[null,"Comercial",30,60,null,"> 30 a 60 m³",3.3597000000000001,2.0179999999999998,"R$/m³",181.88819999999998,109.20499999999998]
[null,"Comercial",60,999999,null,"> 60 m³",4.5350000000000001,2.7277,"R$/m³"]
[null,"Industrial",null,0,"Industrial","Disponibilidade",20.9785,12.584899999999999,"R$/mês"]
[null,"Industrial",0,15,null,"0 a 15 m³",2.0956000000000001,1.264,"R$/m³",{"$f":"G34+($D35-$C35)*G35","v":52.412500000000001},{"$f":"H34+($D35-$C35)*H35","v":31.544899999999998}]
[null,"Industrial",15,30,null,"> 15 a 30 m³",3.149,1.885,"R$/m³",{"$f":"J35+($D36-$C36)*G36","v":99.647500000000008},59.819899999999997]
[null,"Industrial",30,100,null,"> 30 a 100 m³",3.7366999999999999,2.2397999999999998,"R$/m³",361.2165,216.60589999999996]
[null,"Industrial",100,200,null,"> 100 a 200 m³",4.3353999999999999,2.5945999999999998,"R$/m³",794.75649999999996,476.06589999999994]
[null,"Industrial",200,999999,null,"> 200 m³",4.4905999999999997,2.6943999999999999,"R$/m³"]
[null,"Pública",null,0,"Pública","Disponibilidade",13.981999999999999,8.3935999999999993,"R$/mês"]
[null,"Pública",0,10,null,"0 a 10 m³",1.264,0.7651,"R$/m³",{"$f":"G40+($D41-$C41)*G41","v":26.622},{"$f":"H40+($D41-$C41)*H41","v":16.044599999999999}]
[null,"Pública",10,20,null,"> 10 a 20 m³",1.6742999999999999,1.0089999999999999,"R$/m³",{"$f":"J41+($D42-$C42)*G42","v":43.364999999999995},26.134599999999999]
[null,"Pública",20,50,null,"> 20 a 50 m³",2.7942,1.6742999999999999,"R$/m³",127.19099999999999,76.363599999999991]
[null,"Pública",50,100,null,"> 50 a 100 m³",3.9361999999999999,2.3616999999999999,"R$/m³",324.00099999999998,194.4486]
[null,"Pública",100,999999,null,"> 100 m³",4.1246999999999998,2.4725999999999999,"R$/m³"]
[]
[null,null,null,null,null,null,{"$f":"SUM(G14:G45)-SUM('[1]Quadro Tar. 2015_Aplic'!$D$6:$D$37)","v":0},{"$f":"SUM(H14:H45)-SUM('[1]Quadro Tar. 2015_Aplic'!$F$6:$F$37)","v":0}]

{"sheet":"Saae Passos","index":8,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":true,"merged":[[34,4,40,4],[41,4,47,4],[10,4,10,8],[11,19,11,20],[11,4,12,4],[11,5,12,5],[11,6,11,8],[13,4,19,4],[20,4,26,4],[27,4,33,4]]}
[null,null,"Título"]
[null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Tabela Tarifária II - Reajuste 2014\nTarifa de Aplicação"]
[null,null,null,null,"Categorias","Faixas","Tarifas",null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,"Água","Esgoto","unidade",null,null,null,null,null,null,null,null,null,null,"Água","Esgoto"]
[null,"Residencial Social",null,0,"Residencial\n Tarifa Social","disponibilidade",5.27,2.64,"R$/mês",null,null,null,null,null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(SUMIFS(J14:J48,B14:B48,Q14,D14:D48,Q17)+(Q15-Q17)*SUMIFS(G14:G48,B14:B48,Q14,D14:D48,S17)+IF(Q17=0,SUMIFS(G14:G45,B14:B45,Q14,D14:D45,Q17),0))","v":0},{"$f":"(SUMIFS(K14:K48,B14:B48,Q14,D14:D48,Q17)+(Q15-Q17)*SUMIFS(H14:H48,B14:B48,Q14,D14:D48,S17)+IF(Q17=0,SUMIFS(H14:H45,B14:B45,Q14,D14:D45,Q17),0))","v":0}]
[null,"Residencial Social",0,10,null,"0 a 10 m³",0.46,0.23,"R$/m³",{"$f":"G14+($D15-$C15)*G15","v":9.870000000000001},{"$f":"H14+($D15-$C15)*H15","v":4.9400000000000004},null,null,null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!M9/'Calculadora de Tarifas'!AF11","v":0}]
[null,"Residencial Social",10,15,null,"> 10 a 15 m³",0.65,0.32500000000000001,"R$/m³",{"$f":"J15+($D16-$C16)*G16","v":13.120000000000001},6.5650000000000004]
[null,"Residencial Social",15,30,null,"> 15 a 30 m³",2.1019999999999999,1.0509999999999999,"R$/m³",44.65,22.33,null,null,null,null,null,{"$f":"IFERROR(INDEX(IF(B14:B48=Q14,D14:D48,\"Erro\"),MATCH(Q15,IF(B14:B48=Q14,D14:D48,\"Erro\"),1),),\"0\")","v":"0"},"a",{"$f":"IFERROR(INDEX(IF(B14:B48=Q14,D14:D48,\"Erro\"),MATCH(Q15,IF(B14:B48=Q14,D14:D48,\"Erro\"),1)+1,),IF(Q14=\"Residencial Social\",\"10\",IF(Q14=\"Residencial\",\"15\",IF(Q14=\"Comercial\",\"15\",IF(Q14=\"Industrial\",\"15\",IF(Q14=\"Pública\",\"15\",\"\"))))))","v":""},"m³"]
[null,"Residencial Social",30,60,null,"> 30 a 60 m³",2.4900000000000002,1.2450000000000001,"R$/m³",119.35,59.68]
[null,"Residencial Social",60,100,null,"> 60 a 100 m³",3.1749999999999998,1.5880000000000001,"R$/m³",246.35,123.2]
[null,"Residencial Social",100,999999,null,"> 100 m³",3.6110000000000002,1.806,"R$/m³"]
[null,"Residencial",null,0,"Residencial\nNormal","disponibilidade",7.53,3.77,"R$/mês"]
[null,"Residencial",0,15,null,"0 a 15 m³",0.65,0.33,"R$/m³",{"$f":"G21+($D22-$C22)*G22","v":17.28},{"$f":"H21+($D22-$C22)*H22","v":8.7200000000000006}]
[null,"Residencial",15,30,null,"> 15 a 30 m³",2.1019999999999999,1.0509999999999999,"R$/m³",{"$f":"J22+($D23-$C23)*G23","v":48.81},24.484999999999999]
[null,"Residencial",30,60,null,"> 30 a 60 m³",2.4900000000000002,1.2450000000000001,"R$/m³",123.51,61.835000000000001]
[null,"Residencial",60,100,null,"> 60 a 100 m³",3.1749999999999998,1.5880000000000001,"R$/m³",250.51,125.355]
[null,"Residencial",100,200,null,"> 100 a 200 m³",3.6110000000000002,1.806,"R$/m³",611.61,305.95499999999998]
[null,"Residencial",200,999999,null,"> 200 m³",4.2560000000000002,2.1280000000000001,"R$/m³"]
[null,"Comercial",null,0,"Comercial","disponibilidade",9.0299999999999994,4.5199999999999996,"R$/mês"]
[null,"Comercial",0,15,null,"0 a 15 m³",0.78,0.39,"R$/m³",{"$f":"G28+($D29-$C29)*G29","v":20.73},{"$f":"H28+($D29-$C29)*H29","v":10.370000000000001}]
[null,"Comercial",15,30,null,"> 15 a 30 m³",1.6830000000000001,0.84199999999999997,"R$/m³",{"$f":"J29+($D30-$C30)*G30","v":45.975000000000001},23]
[null,"Comercial",30,60,null,"> 30 a 60 m³",2.5110000000000001,1.256,"R$/m³",121.30500000000001,60.68]
[null,"Comercial",60,100,null,"> 60 a 100 m³",3.3460000000000001,1.673,"R$/m³",255.14500000000001,127.6]
[null,"Comercial",100,200,null,"> 100 a 200 m³",3.4889999999999999,1.7450000000000001,"R$/m³",604.04499999999996,302.10000000000002]
[null,"Comercial",200,999999,null,"> 200 m³",4.0309999999999997,2.016,"R$/m³"]
[null,"Industrial",null,0,"Industrial","disponibilidade",9.0299999999999994,4.5199999999999996,"R$/mês"]
[null,"Industrial",0,15,null,"0 a 15 m³",0.78,0.39,"R$/m³",{"$f":"G35+($D36-$C36)*G36","v":20.73},{"$f":"H35+($D36-$C36)*H36","v":10.370000000000001}]
[null,"Industrial",15,30,null,"> 15 a 30 m³",1.6830000000000001,0.84199999999999997,"R$/m³",{"$f":"J36+($D37-$C37)*G37","v":45.975000000000001},23]
[null,"Industrial",30,60,null,"> 30 a 60 m³",2.5110000000000001,1.256,"R$/m³",121.30500000000001,60.68]
[null,"Industrial",60,100,null,"> 60 a 100 m³",3.3460000000000001,1.673,"R$/m³",255.14500000000001,127.6]
[null,"Industrial",100,200,null,"> 100 a 200 m³",3.4889999999999999,1.7450000000000001,"R$/m³",604.04499999999996,302.10000000000002]
[null,"Industrial",200,999999,null,"> 200 m³",4.0309999999999997,2.016,"R$/m³"]
[null,"Pública",null,0,"Pública","disponibilidade",7.86,3.93,"R$/mês"]
[null,"Pública",0,15,null,"0 a 15 m³",0.67,0.34,"R$/m³",{"$f":"G42+($D43-$C43)*G43","v":17.91},{"$f":"H42+($D43-$C43)*H43","v":9.0300000000000011}]
[null,"Pública",15,30,null,"> 15 a 30 m³",2.1019999999999999,1.0509999999999999,"R$/m³",{"$f":"J43+($D44-$C44)*G44","v":49.44},24.795000000000002]
[null,"Pública",30,60,null,"> 30 a 60 m³",2.4900000000000002,1.2450000000000001,"R$/m³",124.14,62.145000000000003]
[null,"Pública",60,100,null,"> 60 a 100 m³",3.0339999999999998,1.5169999999999999,"R$/m³",245.5,122.82499999999999]
[null,"Pública",100,200,null,"> 100 a 200 m³",3.1320000000000001,1.5660000000000001,"R$/m³",558.70000000000005,279.42499999999995]
[null,"Pública",200,999999,null,"> 200 m³",3.5019999999999998,1.7509999999999999,"R$/m³"]

{"sheet":"Sae Ituiutaba","index":9,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":true,"merged":[[10,4,10,8],[11,19,11,20],[11,5,12,5],[11,6,11,8],[13,4,24,4],[25,4,36,4],[37,4,44,4],[45,4,46,4],[47,4,58,4],[11,4,12,4]]}
[null,null,"Título"]
[null,null,{"$f":"TODAY()","v":"2015-11-13"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Tabela Tarifária - Reajuste 2014\nTarifa de Aplicação (Out/14 - Set/15)"]
[null,null,null,null,"Categorias","Faixas","Tarifas",null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,"Água","Esgoto","unidade",null,null,null,null,null,null,null,null,null,null,"Água","Esgoto"]
[null,"Residencial Social",0,10,"Residencial\n Tarifa Social","Até 10 m³",10.36,7.25,"R$/mês",{"$f":"G14","v":10.36},{"$f":"H14","v":7.25},null,null,null,null,"Categoria",{"$f":"'Calculadora de Tarifas'!M11","v":0},null,null,{"$f":"(IF(Q17=\"0\",SUMIFS(G14:G59,B14:B59,Q14,D14:D59,S17),SUMIFS(J14:J59,B14:B59,Q14,D14:D59,Q17)+(Q15-Q17)*SUMIFS(G14:G59,B14:B59,Q14,D14:D59,S17)))","v":0},{"$f":"(IF(Q17=\"0\",SUMIFS(H14:H59,B14:B59,Q14,D14:D59,S17),SUMIFS(K14:K59,B14:B59,Q14,D14:D59,Q17)+(Q15-Q17)*SUMIFS(H14:H59,B14:B59,Q14,D14:D59,S17)))","v":0}]
[null,"Residencial Social",10,15,null,"> 10 a 15 m³",1.4690000000000001,1.0289999999999999,"R$/m³",{"$f":"J14+($D15-$D14)*G15","v":17.704999999999998},{"$f":"K14+($D15-$D14)*H15","v":12.395},null,null,null,null,"Consumo (m³)",{"$f":"'Calculadora de Tarifas'!U6/'Calculadora de Tarifas'!AF11","v":0}]
[null,"Residencial Social",15,20,null,"> 15 a 20 m³",2.0139999999999998,1.41,"R$/m³",{"$f":"J15+($D16-$D15)*G16","v":27.774999999999999},{"$f":"K15+($D16-$D15)*H16","v":19.445}]
[null,"Residencial Social",20,25,null,"> 20 a 25 m³",2.153,1.5069999999999999,"R$/m³",38.54,26.98,null,null,null,null,null,{"$f":"IFERROR(INDEX(IF(B13:B59=Q14,D13:D59,\"Erro\"),MATCH(Q15,IF(B13:B59=Q14,D13:D59,\"Erro\"),1),),\"0\")","v":0},"a",{"$f":"IFERROR(INDEX(IF(B13:B59=Q14,D13:D59,\"Erro\"),MATCH(Q15,IF(B13:B59=Q14,D13:D59,\"Erro\"),1)+1,),IF(Q14=\"Residencial Social\",\"10\",IF(Q14=\"Residencial\",\"10\",IF(Q14=\"Comercial\",\"30\",IF(Q14=\"Industrial\",\"60\",IF(Q14=\"Pública\",\"10\",\"\"))))))","v":"Erro"},"m³"]
[null,"Residencial Social",25,30,null,"> 25 a 30 m³",2.6619999999999999,1.8640000000000001,"R$/m³",51.849999999999994,36.299999999999997]
[null,"Residencial Social",30,35,null,"> 30 a 35 m³",2.7210000000000001,1.905,"R$/m³",65.454999999999998,45.824999999999996]
[null,"Residencial Social",35,40,null,"> 35 a 40 m³",3.0859999999999999,2.16,"R$/m³",80.884999999999991,56.625]
[null,"Residencial Social",40,45,null,"> 40 a 45 m³",3.528,2.4700000000000002,"R$/m³",98.524999999999991,68.974999999999994]
[null,"Residencial Social",45,50,null,"> 45 a 50 m³",3.6880000000000002,2.581,"R$/m³",116.96499999999999,81.88]
[null,"Residencial Social",50,55,null,"> 50 a 55 m³",3.9550000000000001,2.7690000000000001,"R$/m³",136.73999999999998,95.724999999999994]
[null,"Residencial Social",55,60,null,"> 55 a 60 m³",4.55,3.1850000000000001,"R$/m³",159.48999999999998,111.64999999999999]
[null,"Residencial Social",60,999999,null,"> 60 m³",5.0179999999999998,3.512,"R$/m³"]
[null,"Residencial",0,10,"Residencial\nNormal","Até 10 m³",13.469999999999999,9.43,"R$/mês",{"$f":"G26","v":13.469999999999999},{"$f":"H26","v":9.43}]
[null,"Residencial",10,15,null,"> 10 a 15 m³",1.4690000000000001,1.0289999999999999,"R$/m³",{"$f":"J26+($D27-$D26)*G27","v":20.814999999999998},{"$f":"K26+($D27-$D26)*H27","v":14.574999999999999}]
[null,"Residencial",15,20,null,"> 15 a 20 m³",2.0139999999999998,1.41,"R$/m³",{"$f":"J27+($D28-$D27)*G28","v":30.884999999999998},{"$f":"K27+($D28-$D27)*H28","v":21.625}]
[null,"Residencial",20,25,null,"> 20 a 25 m³",2.153,1.5069999999999999,"R$/m³",41.65,29.16]
[null,"Residencial",25,30,null,"> 25 a 30 m³",2.6619999999999999,1.8640000000000001,"R$/m³",54.959999999999994,38.480000000000004]
[null,"Residencial",30,35,null,"> 30 a 35 m³",2.7210000000000001,1.905,"R$/m³",68.564999999999998,48.005000000000003]
[null,"Residencial",35,40,null,"> 35 a 40 m³",3.0859999999999999,2.16,"R$/m³",83.995000000000005,58.805000000000007]
[null,"Residencial",40,45,null,"> 40 a 45 m³",3.528,2.4700000000000002,"R$/m³",101.63500000000001,71.155000000000001]
[null,"Residencial",45,50,null,"> 45 a 50 m³",3.6880000000000002,2.581,"R$/m³",120.075,84.06]
[null,"Residencial",50,55,null,"> 50 a 55 m³",3.9550000000000001,2.7690000000000001,"R$/m³",139.85,97.905000000000001]
[null,"Residencial",55,60,null,"> 55 a 60 m³",4.55,3.1850000000000001,"R$/m³",162.6,113.83]
[null,"Residencial",60,999999,null,"> 60 m³",5.0179999999999998,3.512,"R$/m³"]
[null,"Comercial",0,30,"Comercial","Até 30 m³",56.19,39.33,"R$/mês",{"$f":"G38","v":56.19},{"$f":"H38","v":39.33}]
[null,"Comercial",30,35,null,"> 30 a 35 m³",2.7210000000000001,1.905,"R$/m³",{"$f":"J38+($D39-$D38)*G39","v":69.795000000000002},48.854999999999997]
[null,"Comercial",35,40,null,"> 35 a 40 m³",3.0859999999999999,2.16,"R$/m³",85.224999999999994,59.655000000000001]
[null,"Comercial",40,45,null,"> 40 a 45 m³",3.528,2.4700000000000002,"R$/m³",102.86499999999999,72.004999999999995]
[null,"Comercial",45,50,null,"> 45 a 50 m³",3.6880000000000002,2.581,"R$/m³",121.30499999999999,84.91]
[null,"Comercial",50,55,null,"> 50 a 55 m³",3.9550000000000001,2.7690000000000001,"R$/m³",141.07999999999998,98.754999999999995]
[null,"Comercial",55,60,null,"> 55 a 60 m³",4.55,3.1850000000000001,"R$/m³",163.82999999999998,114.67999999999999]
[null,"Comercial",60,999999,null,"> 60 m³",5.0179999999999998,3.512,"R$/m³"]
[null,"Industrial",0,60,"Industrial","Até 60 m³",163.85999999999999,114.66,"R$/mês",{"$f":"G46","v":163.85999999999999},{"$f":"H46","v":114.66}]
[null,"Industrial",60,999999,null,"> 60 m³",5.0179999999999998,3.512,"R$/m³"]
[null,"Pública",0,10,"Pública","Até 10 m³",13.469999999999999,9.43,"R$/mês",{"$f":"G48","v":13.469999999999999},{"$f":"H48","v":9.43}]
[null,"Pública",10,15,null,"> 10 a 15 m³",1.4690000000000001,1.0289999999999999,"R$/m³",{"$f":"J48+($D49-$D48)*G49","v":20.814999999999998},{"$f":"K48+($D49-$D48)*H49","v":14.574999999999999}]
[null,"Pública",15,20,null,"> 15 a 20 m³",2.0139999999999998,1.41,"R$/m³",{"$f":"J49+($D50-$D49)*G50","v":30.884999999999998},{"$f":"K49+($D50-$D49)*H50","v":21.625}]
[null,"Pública",20,25,null,"> 20 a 25 m³",2.153,1.5069999999999999,"R$/m³",41.65,29.16]
[null,"Pública",25,30,null,"> 25 a 30 m³",2.6619999999999999,1.8640000000000001,"R$/m³",54.959999999999994,38.480000000000004]
[null,"Pública",30,35,null,"> 30 a 35 m³",2.7210000000000001,1.905,"R$/m³",68.564999999999998,48.005000000000003]
[null,"Pública",35,40,null,"> 35 a 40 m³",3.0859999999999999,2.16,"R$/m³",83.995000000000005,58.805000000000007]
[null,"Pública",40,45,null,"> 40 a 45 m³",3.528,2.4700000000000002,"R$/m³",101.63500000000001,71.155000000000001]
[null,"Pública",45,50,null,"> 45 a 50 m³",3.6880000000000002,2.581,"R$/m³",120.075,84.06]
[null,"Pública",50,55,null,"> 50 a 55 m³",3.9550000000000001,2.7690000000000001,"R$/m³",139.85,97.905000000000001]
[null,"Pública",55,60,null,"> 55 a 60 m³",4.55,3.1850000000000001,"R$/m³",162.6,113.83]
[null,"Pública",60,999999,null,"> 60 m³",5.0179999999999998,3.512,"R$/m³"]