{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Painel","Tutorial","Tabela de Tarifas"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Painel","index":0,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[30,3,30,4],[39,1,39,2],[38,5,38,6],[38,10,38,11],[38,8,38,9],[10,1,10,3],[10,4,10,5],[10,7,10,8],[2,2,2,12],[4,1,4,3],[4,4,4,6],[6,1,6,3],[9,1,9,3],[9,4,9,5],[9,7,9,8],[9,9,9,10],[9,11,9,12],[10,9,10,10],[10,11,10,12],[12,4,12,5],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,4,11,5],[11,7,11,8],[11,9,11,10],[11,11,11,12],[13,4,13,5],[13,7,13,8],[13,9,13,10],[13,11,13,12],[14,4,14,5],[14,7,14,8],[14,9,14,10],[14,11,14,12],[24,2,24,6],[15,4,15,5],[15,7,15,8],[15,9,15,10],[15,11,15,12],[17,2,20,5],[21,2,22,12],[23,2,23,12]]}
[]
[]
[null,null,"Simulador de Faturas (Tarifas vigentes a partir de 29/10/2023)"]
[]
[null,"   1 - Digite o volume total consumido (m³)"]
[]
[null,"   2 - Clique no serviço oferecido"]
[]
[]
[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,"        relativas a cada categoria ",null,null,"ResidencialSocial",null,null,{"$f":"IF(G11>0,Painel!D33*G11,Painel!D33)","v":0},null,{"$f":"IF(G11>0,Painel!E33*G11,Painel!E33)","v":0},null,{"$f":"H11+J11","v":0}]
[null,null,null,null,"Residencial",null,null,{"$f":"IF(G12>0,Painel!D34*G12,Painel!D34)","v":0},null,{"$f":"IF(G12>0,Painel!E34*G12,Painel!E34)","v":0},null,{"$f":"H12+J12","v":0}]
[null,null,null,null,"Comercial",null,null,{"$f":"IF(G13>0,Painel!D35*G13,Painel!D35)","v":0},null,{"$f":"IF(G13>0,Painel!E35*G13,Painel!E35)","v":0},null,0]
[null,null,null,null,"Industrial",null,null,{"$f":"IF(G14>0,Painel!D36*G14,Painel!D36)","v":0},null,{"$f":"IF(G14>0,Painel!E36*G14,Painel!E36)","v":0},null,0]
[null,null,null,null,"Pública",null,null,{"$f":"IF(G15>0,Painel!D37*G15,Painel!D37)","v":0},null,{"$f":"IF(G15>0,Painel!E37*G15,Painel!E37)","v":0},null,0]
[null,null,null,null,"Valor Total",null,{"$f":"SUM(G11:G15)","v":0},0,0,0,0,0,0]
[]
[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,"Agência Reguladora de Serviços de Abastecimento de Água e Esgotamento Sanitário do Estado de MG - ARSAE"]
[]
[]
[]
[null,"Serviços","Volume/Economias"]
[null,"Só Água",{"$f":"IFERROR(Painel!E5/Painel!G16,0)","v":0}]
[]
[null,null,null,"Sem multiplicar pelas economias"]
[null,"Categoria","N° economias","Valor Água","Valor Esgoto"]
[null,{"$f":"Painel!E11","v":"ResidencialSocial"},{"$f":"Painel!G11","v":0},{"$f":"IF(C33>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$M$45,Painel!$K$44,IF(AND($C$29>Painel!$C$44,$C$29<=Painel!$C$49),INDEX(Painel!$C$45:$K$49,MATCH(ROUNDUP($C$29,0),Painel!$C$45:$C$49,0),9),IF(AND($C$29>Painel!$M$50,$C$29<=Painel!$N$50),Painel!K50,IF(AND($C$29>Painel!$M$51,$C$29<=Painel!$N$51),Painel!$K$51,IF(AND($C$29>Painel!$M$52,$C$29<=Painel!$N$52),Painel!$K$52,IF($C$29>Painel!$M$53,Painel!$K$53,\"Erro\")))))),0),0)","v":0},{"$f":"IF(C33>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$44,Painel!$L$44,IF(AND($C$29>Painel!$C$44,$C$29<Painel!$B$50),INDEX(Painel!$C$45:$L$49,MATCH(ROUNDUP($C$29,0),Painel!$C$45:$C$49,0),10),IF(AND($C$29>Painel!C49,$C$29<Painel!B51),Painel!$L$50,IF(AND($C$29>Painel!$C$50,$C$29<Painel!$B$52),Painel!$L$51,IF(AND($C$29>Painel!$C$51,$C$29<Painel!$B$53),Painel!$L$52,IF($C$29>Painel!$C$52,Painel!$L$53,\"Erro\")))))),0),0)","v":0}]
[null,{"$f":"Painel!E12","v":"Residencial"},{"$f":"Painel!G12","v":0},{"$f":"IF(C34>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$56,Painel!K56,IF(AND($C$29>Painel!$M$58,$C$29<=Painel!$N$58),Painel!K58,IF(AND($C$29>Painel!$M$59,$C$29<=Painel!$N$59),Painel!K59,IF(AND($C$29>Painel!$M$60,$C$29<=Painel!$N$60),Painel!K60,IF(AND($C$29>Painel!$M$61,$C$29<Painel!$N$61),Painel!K61,IF($C$29>Painel!$M$62,Painel!K62,\"Erro\")))))),0),0)","v":0},{"$f":"IF(C34>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$56,Painel!L56,IF(AND($C$29>Painel!$M$58,$C$29<=Painel!$N$58),Painel!L58,IF(AND($C$29>Painel!$M$59,$C$29<=Painel!$N$59),Painel!L59,IF(AND($C$29>Painel!$M$60,$C$29<=Painel!$N$60),Painel!L60,IF(AND($C$29>Painel!$M$61,$C$29<Painel!$N$61),Painel!L61,IF($C$29>Painel!$M$62,Painel!L62,\"Erro\")))))),0),0)","v":0}]
[null,{"$f":"Painel!E13","v":"Comercial"},{"$f":"Painel!G13","v":0},{"$f":"IF(C35>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$65,Painel!F65,IF(AND($C$29>Painel!$M$67,$C$29<=Painel!$N$67),Painel!K67,IF($C$29>Painel!$M$68,Painel!K68,\"Erro\"))),0),0)","v":0},{"$f":"IF(C35>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$65,Painel!G65,IF(AND($C$29>Painel!$M$67,$C$29<=Painel!$N$67),Painel!L67,IF($C$29>Painel!$M$68,Painel!L68,\"Erro\"))),0),0)","v":0}]
[null,{"$f":"Painel!E14","v":"Industrial"},{"$f":"Painel!G14","v":0},{"$f":"IF(C36>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$71,Painel!F71,IF(AND($C$29>Painel!$M$73,$C$29<=Painel!$N$73),Painel!K73,IF(AND($C$29>Painel!$M$74,$C$29<=Painel!$N$74),Painel!K74,IF($C$29>Painel!$M$75,Painel!K75,\"Erro\")))),0),0)","v":0},{"$f":"IF(C36>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$71,Painel!G71,IF(AND($C$29>Painel!$M$73,$C$29<=Painel!$N$73),Painel!L73,IF(AND($C$29>Painel!$M$74,$C$29<=Painel!$N$74),Painel!L74,IF($C$29>Painel!$M$75,Painel!L75,\"Erro\")))),0),0)","v":0}]
[null,{"$f":"Painel!E15","v":"Pública"},{"$f":"Painel!G15","v":0},{"$f":"IF(C37>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$78,Painel!F78,IF(AND($C$29>Painel!$M$80,$C$29<=Painel!$N$80),Painel!K80,IF($C$29>Painel!$M$81,Painel!K81,\"Erro\"))),0),0)","v":0},{"$f":"IF(C37>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=Painel!$C$78,Painel!G78,IF(AND($C$29>Painel!$M$80,$C$29<=Painel!$N$80),Painel!L80,IF($C$29>Painel!$M$81,Painel!L81,\"Erro\"))),0),0)","v":0}]
[]
[null,null,null,"3: Aplicação",null,"Teto Por Faixa",null,null,"Acumulado",null,"Cálculos"]
["Tipo","Consumo m³",null,null,"Valor m³","Água","Esgoto","Total","Água","Esgoto","Água","Esgoto","Referência Min.","Referência Max."]
[null,null,null,"CATEGORIA  RESIDENCIAL - R2",null,null,null,null,null,null,null,null,"-","-"]
[null,null,10,"SERVIÇO ESTIMADO",1.8339156936417875,18.34,9.18,27.52,null,null,null,null,"-","-"]
[null,null,10,"CONSUMO MÍNIMO 10m³",1.8390091783342837,18.39,9.1999999999999993,27.59,null,null,null,null,"-","-"]
["Residencial Social",1,10,"CONSUMO EXCEDENTE AO MÍNIMO",1.8390091783342837,18.39,9.1999999999999993,27.59,{"$f":"F44","v":18.39},{"$f":"G44","v":9.1999999999999993},{"$f":"E44*C44","v":18.390091783342836},{"$f":"IFERROR(K44/2,\"Fora da faixa\")","v":9.1950458916714179},"-","-"]
["Residencial Social","-",11,null,5.5366178607432204,5.54,2.77,8.3000000000000007,{"$f":"F45+I44","v":23.93},{"$f":"G45+J44","v":11.969999999999999},{"$f":"IF(Painel!$C$29=N45,E45+I44,IF(AND(Painel!$C$29>M45,Painel!$C$29<N45),I44+((Painel!$C$29-M45)*E45),\"Fora da faixa\"))","v":"Fora da faixa"},{"$f":"IFERROR(K45/2,\"Fora da faixa\")","v":"Fora da faixa"},10,11]
["Residencial Social","-",12,null,6.2985509298719915,6.3,3.15,9.4499999999999993,{"$f":"F46+I45","v":30.23},{"$f":"G46+J45","v":15.12},{"$f":"IF(Painel!$C$29=N46,E46+I45,IF(AND(Painel!$C$29>M46,Painel!$C$29<N46),I45+((Painel!$C$29-M46)*E46),\"Fora da faixa\"))","v":"Fora da faixa"},{"$f":"IFERROR(K46/2,\"Fora da faixa\")","v":"Fora da faixa"},11,12]
["Residencial Social","-",13,null,4.5206635678476594,4.53,2.27,6.8,{"$f":"F47+I46","v":34.76},{"$f":"G47+J46","v":17.39},{"$f":"IF(Painel!$C$29=N47,E47+I46,IF(AND(Painel!$C$29>M47,Painel!$C$29<N47),I46+((Painel!$C$29-M47)*E47),\"Fora da faixa\"))","v":"Fora da faixa"},{"$f":"IFERROR(K47/2,\"Fora da faixa\")","v":"Fora da faixa"},12,13]
["Residencial Social","-",14,null,4.825750240711014,4.82,2.42,7.24,{"$f":"F48+I47","v":39.58},{"$f":"G48+J47","v":19.810000000000002},{"$f":"IF(Painel!$C$29=N48,E48+I47,IF(AND(Painel!$C$29>M48,Painel!$C$29<N48),I47+((Painel!$C$29-M48)*E48),\"Fora da faixa\"))","v":"Fora da faixa"},{"$f":"IFERROR(K48/2,\"Fora da faixa\")","v":"Fora da faixa"},13,14]
["Residencial Social","-",15,null,5.5879445141829889,5.59,2.8,8.39,{"$f":"F49+I48","v":45.17},{"$f":"G49+J48","v":22.610000000000003},{"$f":"IF(Painel!$C$29=N49,E49+I48,IF(AND(Painel!$C$29>M49,Painel!$C$29<N49),I48+((Painel!$C$29-M49)*E49),\"Fora da faixa\"))","v":"Fora da faixa"},{"$f":"IFERROR(K49/2,\"Fora da faixa\")","v":"Fora da faixa"},14,15]
["Residencial Social",16,25,null,5.5354424411987999,55.36,27.68,83.04,{"$f":"F50+I49","v":100.53},{"$f":"G50+J49","v":50.290000000000006},{"$f":"IF(AND(Painel!$C$29>M50,Painel!$C$29<=N50),I49+((Painel!$C$29-M50)*E50),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K50/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C49","v":15},{"$f":"C50","v":25}]
["Residencial Social",26,40,null,7.061006407687171,105.92,52.97,158.88999999999999,{"$f":"F51+I50","v":206.45},{"$f":"G51+J50","v":103.26},{"$f":"IF(AND(Painel!$C$29>M51,Painel!$C$29<=N51),I50+((Painel!$C$29-M51)*E51),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K51/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C50","v":25},{"$f":"C51","v":40}]
["Residencial Social",41,100,null,11.291602552405759,677.49,338.75,1016.24,{"$f":"F52+I51","v":883.94},{"$f":"G52+J51","v":442.01},{"$f":"IF(AND(Painel!$C$29>M52,Painel!$C$29<=N52),I51+((Painel!$C$29-M52)*E52),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K52/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C51","v":40},{"$f":"C52","v":100}]
["Residencial Social",101,9999,null,15.717057137155225,155583.14000000001,77791.58,233374.72,null,null,{"$f":"IF(Painel!$C$29>M53,I52+((Painel!$C$29-M53)*E53),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K53/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C52","v":100}]
[null,null,null,"CATEGORIA  RESIDENCIAL - R2",null,null,null,null,null,null,null,null,"-","-"]
[null,null,20,"SERVIÇO ESTIMADO",1.8750553776965637,37.5,18.75,56.26,null,null,null,null,"-","-"]
["Residencial",null,10,"CONSUMO MÍNIMO 10m³",3.8517192448998436,38.51,19.260000000000002,57.78,null,null,{"$f":"$C$56*$E$56","v":38.517192448998436},{"$f":"IFERROR(K56/2,\"Fora da faixa\")","v":19.258596224499218},"-","-"]
["Residencial",1,10,"CONSUMO EXCEDENTE AO MÍNIMO",4.2857102611348283,42.86,21.43,64.290000000000006,{"$f":"F57","v":42.86},{"$f":"G57","v":21.43},{"$f":"$C$57*$E$57","v":42.857102611348282},{"$f":"IFERROR(K57/2,\"Fora da faixa\")","v":21.428551305674141},"-","-"]
["Residencial",11,15,null,4.9952718594510115,24.98,12.49,37.47,{"$f":"I57+F58","v":67.84},{"$f":"G58+J57","v":33.92},{"$f":"IF(AND(Painel!$C$29>M58,Painel!$C$29<=N58),I57+((Painel!$C$29-M58)*E58),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K58/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C57","v":10},{"$f":"C58","v":15}]
["Residencial",16,25,null,5.5354424411987999,55.36,27.68,83.04,{"$f":"I58+F59","v":123.2},{"$f":"G59+J58","v":61.6},{"$f":"IF(AND(Painel!$C$29>M59,Painel!$C$29<=N59),I58+((Painel!$C$29-M59)*E59),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K59/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C58","v":15},{"$f":"C59","v":25}]
["Residencial",26,40,null,7.061006407687171,105.92,52.97,158.88999999999999,{"$f":"I59+F60","v":229.12},{"$f":"G60+J59","v":114.57},{"$f":"IF(AND(Painel!$C$29>M60,Painel!$C$29<=N60),I59+((Painel!$C$29-M60)*E60),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K60/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C59","v":25},{"$f":"C60","v":40}]
["Residencial",41,100,null,11.291602552405759,677.49,338.75,1016.24,{"$f":"I60+F61","v":906.61},{"$f":"G61+J60","v":453.32},{"$f":"IF(AND(Painel!$C$29>M61,Painel!$C$29<=N61),I60+((Painel!$C$29-M61)*E61),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K61/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C60","v":40},{"$f":"C61","v":100}]
["Residencial",101,9999,null,15.717057137155225,155583.14000000001,77791.58,233374.72,null,null,{"$f":"IF(Painel!$C$29>M62,I61+((Painel!$C$29-M62)*E62),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K62/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C61","v":100}]
[null,null,null,"CATEGORIA  COMERCIAL - C",null,null,null,null,null,null,null,null,"-","-"]
[null,null,20,"SERVIÇO ESTIMADO",1.8750553776965637,37.5,18.75,56.26,null,null,null,null,"-","-"]
[null,null,10,"CONSUMO MÍNIMO 10m³",5.8359580380560665,58.35,29.18,87.53,null,null,null,null,"-","-"]
["Comercial",1,10,"CONSUMO EXCEDENTE AO MÍNIMO",5.8359580380560665,58.35,29.18,87.53,{"$f":"F66","v":58.35},{"$f":"G66","v":29.18},{"$f":"$C$66*$E$66","v":58.359580380560665},{"$f":"IFERROR(K66/2,\"Fora da faixa\")","v":29.179790190280332},"-","-"]
["Comercial",11,30,null,7.8023043337027511,156.05000000000001,78.03,234.08,{"$f":"I66+F67","v":214.4},{"$f":"G67+J66","v":107.21000000000001},{"$f":"IF(AND(Painel!$C$29>M67,Painel!$C$29<=N67),I66+((Painel!$C$29-M67)*E67),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K67/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C66","v":10},{"$f":"C67","v":30}]
["Comercial",31,9999,null,8.6774694856108567,86505.7,43252.85,129758.54,null,null,{"$f":"IF(Painel!$C$29>M68,I67+((Painel!$C$29-M68)*E68),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K68/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C67","v":30}]
[null,null,null,"CATEGORIA  INDUSTRIAL - I",null,null,null,null,null,null,null,null,"-","-"]
[null,null,20,"SERVIÇO ESTIMADO",3.2506880511853082,65.010000000000005,32.51,97.53,null,null,null,null,"-","-"]
[null,null,10,"CONSUMO MÍNIMO 10m³",6.5022903175718341,65.02,32.51,97.54,null,null,null,null,"-","-"]
[null,1,10,"CONSUMO EXCEDENTE AO MÍNIMO",6.5022903175718341,65.02,32.51,97.54,{"$f":"F72","v":65.02},{"$f":"G72","v":32.51},{"$f":"C72*E72","v":65.022903175718341},{"$f":"IFERROR(K72/2,\"Fora da faixa\")","v":32.51145158785917},"-","-"]
["Industrial",11,30,null,7.8023043337027511,156.05000000000001,78.03,234.08,{"$f":"I72+F73","v":221.07},{"$f":"G73+J72","v":110.53999999999999},{"$f":"IF(AND(Painel!$C$29>M73,Painel!$C$29<=N73),I72+((Painel!$C$29-M73)*E73),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K73/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C72","v":10},{"$f":"C73","v":30}]
["Industrial",31,60,null,8.6774694856108567,260.33,130.16,390.49,{"$f":"I73+F74","v":481.4},{"$f":"G74+J73","v":240.7},{"$f":"IF(AND(Painel!$C$29>M74,Painel!$C$29<=N74),I73+((Painel!$C$29-M74)*E74),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K74/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C73","v":30},{"$f":"C74","v":60}]
["Industrial",61,9999,null,10.757439670551685,106918.19,53459.09,160377.28,null,null,{"$f":"IF(Painel!$C$29>M75,I74+((Painel!$C$29-M75)*E75),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K75/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C74","v":60}]
[null,null,null,"CATEGORIA  PÚBLICA - P",null,null,null,null,null,null,null,null,"-","-"]
[null,null,20,"SERVIÇO ESTIMADO",4.3636797575815001,87.27,43.64,130.91,null,null,null,null,"-","-"]
[null,null,15,"CONSUMO MÍNIMO 15m³",5.8243344447834478,87.36,43.69,131.05000000000001,null,null,null,null,"-","-"]
["Pública",1,15,"CONSUMO EXCEDENTE AO MÍNIMO",5.8243344447834478,87.36,43.69,131.05000000000001,{"$f":"F79","v":87.36},{"$f":"G79","v":43.69},{"$f":"$C$79*$E$79","v":87.365016671751718},{"$f":"IFERROR(K79/2,\"Fora da faixa\")","v":43.682508335875859},"-","-"]
["Pública",16,30,null,9.0530813311395413,135.80000000000001,67.91,203.71,{"$f":"I79+F80","v":223.16000000000003},{"$f":"G80+J79","v":111.6},{"$f":"IF(AND(Painel!$C$29>M80,Painel!$C$29<=N80),I79+((Painel!$C$29-M80)*E80),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K80/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C79","v":15},{"$f":"C80","v":30}]
["Pública",31,9999,null,9.3454995933574558,93165.29,46582.65,139747.93,null,null,{"$f":"IF(Painel!$C$29>M81,I80+((Painel!$C$29-M81)*E81),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IFERROR(K81/2,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"C80","v":30}]

{"sheet":"Tutorial","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Exemplo de uso do simulador"]

{"sheet":"Tabela de Tarifas","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[39,1,44,1],[2,5,2,8],[26,2,26,8],[32,2,32,8],[39,2,39,8],[26,1,31,1],[32,1,38,1],[1,1,1,8],[2,1,3,1],[2,2,3,3],[17,1,25,1],[4,2,4,8],[4,1,16,1],[17,2,17,8]]}
[]
[null,"Vigência a partir de 29 de Outubro de 2023"]
[null,"Tipo","Faixa de consumo m³",null,null,"Teto Por Faixa"]
[null,null,null,null,null,"Valor m³","Água","Esgoto","Total"]
[null,"Residencial Social","CATEGORIA  RESIDENCIAL - R2"]
[null,null,null,10,"SERVIÇO ESTIMADO",1.8339156936417875,18.34,9.18,27.52]
[null,null,null,10,"CONSUMO MÍNIMO 10m³",1.8390091783342837,18.39,9.1999999999999993,27.59]
[null,null,1,10,"CONSUMO EXCEDENTE AO MÍNIMO",1.8390091783342837,18.39,9.1999999999999993,27.59]
[null,null,"-",11,null,5.5366178607432204,5.54,2.77,8.3000000000000007]
[null,null,"-",12,null,6.2985509298719915,6.3,3.15,9.4499999999999993]
[null,null,"-",13,null,4.5206635678476594,4.53,2.27,6.8]
[null,null,"-",14,null,4.825750240711014,4.82,2.42,7.24]
[null,null,"-",15,null,5.5879445141829889,5.59,2.8,8.39]
[null,null,16,25,null,5.5354424411987999,55.36,27.68,83.04]
[null,null,26,40,null,7.061006407687171,105.92,52.97,158.88999999999999]
[null,null,41,100,null,11.291602552405759,677.49,338.75,1016.24]
[null,null,101,"-",null,15.717057137155225,155583.14000000001,77791.58,233374.72]
[null,"Residencial","CATEGORIA  RESIDENCIAL - R2"]
[null,null,null,20,"SERVIÇO ESTIMADO",1.8750553776965637,37.5,18.75,56.26]
[null,null,null,10,"CONSUMO MÍNIMO 10m³",3.8517192448998436,38.51,19.260000000000002,57.78]
[null,null,1,10,"CONSUMO EXCEDENTE AO MÍNIMO",4.2857102611348283,42.86,21.43,64.290000000000006]
[null,null,11,15,null,4.9952718594510115,24.98,12.49,37.47]
[null,null,16,25,null,5.5354424411987999,55.36,27.68,83.04]
[null,null,26,40,null,7.061006407687171,105.92,52.97,158.88999999999999]
[null,null,41,100,null,11.291602552405759,677.49,338.75,1016.24]
[null,null,101,"-",null,15.717057137155225,155583.14000000001,77791.58,233374.72]
[null,"Comercial","CATEGORIA  COMERCIAL - C"]
[null,null,null,20,"SERVIÇO ESTIMADO",1.8750553776965637,37.5,18.75,56.26]
[null,null,null,10,"CONSUMO MÍNIMO 10m³",5.8359580380560665,58.35,29.18,87.53]
[null,null,1,10,"CONSUMO EXCEDENTE AO MÍNIMO",5.8359580380560665,58.35,29.18,87.53]
[null,null,11,30,null,7.8023043337027511,156.05000000000001,78.03,234.08]
[null,null,31,"-",null,8.6774694856108567,86505.7,43252.85,129758.54]
[null,"Industrial","CATEGORIA  INDUSTRIAL - I"]
[null,null,null,20,"SERVIÇO ESTIMADO",3.2506880511853082,65.010000000000005,32.51,97.53]
[null,null,null,10,"CONSUMO MÍNIMO 10m³",6.5022903175718341,65.02,32.51,97.54]
[null,null,1,10,"CONSUMO EXCEDENTE AO MÍNIMO",6.5022903175718341,65.02,32.51,97.54]
[null,null,11,30,null,7.8023043337027511,156.05000000000001,78.03,234.08]
[null,null,31,60,null,8.6774694856108567,260.33,130.16,390.49]
[null,null,61,"-",null,10.757439670551685,106918.19,53459.09,160377.28]
[null,"Pública","CATEGORIA  PÚBLICA - P"]
[null,null,null,20,"SERVIÇO ESTIMADO",4.3636797575815001,87.27,43.64,130.91]
[null,null,null,15,"CONSUMO MÍNIMO 15m³",5.8243344447834478,87.36,43.69,131.05000000000001]
[null,null,1,15,"CONSUMO EXCEDENTE AO MÍNIMO",5.8243344447834478,87.36,43.69,131.05000000000001]
[null,null,16,30,null,9.0530813311395413,135.80000000000001,67.91,203.71]
[null,null,31,"-",null,9.3454995933574558,93165.29,46582.65,139747.93]