{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Painel","Tutorial","Tabela de Tarifas"],"not_rendered":{"charts":0,"images":14,"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":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[[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],[65,4,71,4],[27,6,27,7],[37,4,43,4],[35,3,36,3],[35,11,35,12],[35,9,35,10],[35,4,36,4],[35,5,36,5],[35,6,35,8],[35,1,36,1],[35,2,36,2],[44,4,50,4],[51,4,57,4],[58,4,64,4]]}
[]
[]
[null,null,"Simulador de Faturas (Tarifas vigentes a partir de 01/01/2024)"]
[]
[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!G30*G11,Painel!G30)","v":0},null,{"$f":"IF(G11>0,Painel!H30*G11,Painel!H30)","v":0},null,{"$f":"H11+J11","v":0}]
[null,null,null,null,"Residencial",null,null,{"$f":"IF(G12>0,Painel!G31*G12,Painel!G31)","v":0},null,{"$f":"IF(G12>0,Painel!H31*G12,Painel!H31)","v":0},null,{"$f":"H12+J12","v":0}]
[null,null,null,null,"Comercial",null,null,{"$f":"IF(G13>0,Painel!G32*G13,Painel!G32)","v":0},null,{"$f":"IF(G13>0,Painel!H32*G13,Painel!H32)","v":0},null,0]
[null,null,null,null,"Industrial",null,null,{"$f":"IF(G14>0,Painel!G33*G14,Painel!G33)","v":0},null,{"$f":"IF(G14>0,Painel!H33*G14,Painel!H33)","v":0},null,0]
[null,null,null,null,"Pública",null,null,{"$f":"IF(G15>0,Painel!G34*G15,Painel!G34)","v":0},null,{"$f":"IF(G15>0,Painel!H34*G15,Painel!H34)","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,null,null,null,null,null,"Sem multiplicar pelas economias"]
[null,"Água e Esgoto","Volume/Economias",null,"Categoria","N° economias","Valor Água","Valor Esgoto"]
[null,"Água e Esgoto",{"$f":"IFERROR(Painel!E5/Painel!G16,0)","v":0},null,{"$f":"Painel!E11","v":"ResidencialSocial"},{"$f":"Painel!G11","v":0},{"$f":"IF(F30>0,IF(OR($B$30=\"Só Água\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O39,L39,IF(AND($C$30>$N40,$C$30<=$O40),L40,IF(AND($C$30>$N41,$C$30<=$O41),L41,IF(AND($C$30>$N42,$C$30<=$O42),L42,IF(AND($C$30>$N43,$C$30<=$O43),L43,IF($C$30>$N44,L44,\"Erro\")))))),0),0)","v":0},{"$f":"IF(F30>0,IF(OR($B$30=\"Esgoto\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O39,M39,IF(AND($C$30>$N40,$C$30<=$O40),M40,IF(AND($C$30>$N41,$C$30<=$O41),M41,IF(AND($C$30>$N42,$C$30<=$O42),M42,IF(AND($C$30>$N43,$C$30<=$O43),M43,IF($C$30>$N44,M44,\"Erro\")))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E12","v":"Residencial"},{"$f":"Painel!G12","v":0},{"$f":"IF(F31>0,IF(OR($B$30=\"Só Água\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O46,L46,IF(AND($C$30>$N47,$C$30<=$O47),L47,IF(AND($C$30>$N48,$C$30<=$O48),L48,IF(AND($C$30>$N49,$C$30<=$O49),L49,IF(AND($C$30>$N50,$C$30<=$O50),L50,IF($C$30>$N51,L51,\"Erro\")))))),0),0)","v":0},{"$f":"IF(F31>0,IF(OR($B$30=\"Esgoto\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O46,M46,IF(AND($C$30>$N47,$C$30<=$O47),M47,IF(AND($C$30>$N48,$C$30<=$O48),M48,IF(AND($C$30>$N49,$C$30<=$O49),M49,IF(AND($C$30>$N50,$C$30<=$O50),M50,IF($C$30>$N51,M51,\"Erro\")))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E13","v":"Comercial"},{"$f":"Painel!G13","v":0},{"$f":"IF(F32>0,IF(OR($B$30=\"Só Água\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O53,L53,IF(AND($C$30>$N54,$C$30<=$O54),L54,IF(AND($C$30>$N55,$C$30<=$O55),L55,IF(AND($C$30>$N56,$C$30<=$O56),L56,IF(AND($C$30>$N57,$C$30<=$O57),L57,IF($C$30>$N58,L58,\"Erro\")))))),0),0)","v":0},{"$f":"IF(F32>0,IF(OR($B$30=\"Esgoto\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O53,M53,IF(AND($C$30>$N54,$C$30<=$O54),M54,IF(AND($C$30>$N55,$C$30<=$O55),M55,IF(AND($C$30>$N56,$C$30<=$O56),M56,IF(AND($C$30>$N57,$C$30<=$O57),M57,IF($C$30>$N58,M58,\"Erro\")))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E14","v":"Industrial"},{"$f":"Painel!G14","v":0},{"$f":"IF(F33>0,IF(OR($B$30=\"Só Água\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O60,L60,IF(AND($C$30>$N61,$C$30<=$O61),L61,IF(AND($C$30>$N62,$C$30<=$O62),L62,IF(AND($C$30>$N63,$C$30<=$O63),L63,IF(AND($C$30>$N64,$C$30<=$O64),L64,IF($C$30>$N65,L65,\"Erro\")))))),0),0)","v":0},{"$f":"IF(F33>0,IF(OR($B$30=\"Esgoto\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O60,M60,IF(AND($C$30>$N61,$C$30<=$O61),M61,IF(AND($C$30>$N62,$C$30<=$O62),M62,IF(AND($C$30>$N63,$C$30<=$O63),M63,IF(AND($C$30>$N64,$C$30<=$O64),M64,IF($C$30>$N65,M65,\"Erro\")))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E15","v":"Pública"},{"$f":"Painel!G15","v":0},{"$f":"IF(F34>0,IF(OR($B$30=\"Só Água\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O67,L67,IF(AND($C$30>$N68,$C$30<=$O68),L68,IF(AND($C$30>$N69,$C$30<=$O69),L69,IF(AND($C$30>$N70,$C$30<=$O70),L70,IF(AND($C$30>$N71,$C$30<=$O71),L71,IF($C$30>$N72,L72,\"Erro\")))))),0),0)","v":0},{"$f":"IF(F34>0,IF(OR($B$30=\"Esgoto\",$B$30=\"Água e Esgoto\"),IF($C$30<=$O67,M67,IF(AND($C$30>$N68,$C$30<=$O68),M68,IF(AND($C$30>$N69,$C$30<=$O69),M69,IF(AND($C$30>$N70,$C$30<=$O70),M70,IF(AND($C$30>$N71,$C$30<=$O71),M71,IF($C$30>$N72,M72,\"Erro\")))))),0),0)","v":0}]
[]
[null,"Min","Max","Intervalo","Categorias","Faixas","Tarifas",null,null,"Acumulado",null,"Cálculos"]
[null,null,null,null,null,null,"Água","Esgoto","unidade","Água","Esgoto","Água","Esgoto","Referência Min.","Referência Max."]
[null,null,null,null,"Residencial \nTarifa Social","Fixa",9.5399999999999991,7.06,"R$/mês",{"$f":"G38","v":9.5399999999999991},{"$f":"H38","v":7.06}]
[null,0,5,{"$f":"C39-B39","v":5},null,"0 a 5 m³",1.0900000000000001,0.82,"R$/m³",{"$f":"J38+(G39*D39)","v":14.989999999999998},{"$f":"K38+(H39*D39)","v":11.16},{"$f":"IF($C$30<=O39,J38+(G39*($C$30-N39)),\"Fora da faixa\")","v":9.5399999999999991},{"$f":"IF($C$30<=O39,K38+(H39*($C$30-N39)),\"Fora da faixa\")","v":7.06},0,5]
[null,5,10,{"$f":"C40-B40","v":5},null,"> 5 a 10 m³",2.3420000000000001,1.734,"R$/m³",{"$f":"J39+(G40*D40)","v":26.7},{"$f":"K39+(H40*D40)","v":19.829999999999998},{"$f":"IF(AND($C$30<=O40,$C$30>N40),J39+(G40*($C$30-N40)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O40,$C$30>N40),K39+(H40*($C$30-N40)),\"Fora da faixa\")","v":"Fora da faixa"},5,10]
[null,10,15,{"$f":"C41-B41","v":5},null,"> 10 a 15 m³",3.629,2.6859999999999999,"R$/m³",{"$f":"J40+(G41*D41)","v":44.844999999999999},{"$f":"K40+(H41*D41)","v":33.26},{"$f":"IF(AND($C$30<=O41,$C$30>N41),J40+(G41*($C$30-N41)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O41,$C$30>N41),K40+(H41*($C$30-N41)),\"Fora da faixa\")","v":"Fora da faixa"},10,15]
[null,15,20,{"$f":"C42-B42","v":5},null,"> 15 a 20 m³",4.9560000000000004,3.6680000000000001,"R$/m³",{"$f":"J41+(G42*D42)","v":69.625},{"$f":"K41+(H42*D42)","v":51.599999999999994},{"$f":"IF(AND($C$30<=O42,$C$30>N42),J41+(G42*($C$30-N42)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O42,$C$30>N42),K41+(H42*($C$30-N42)),\"Fora da faixa\")","v":"Fora da faixa"},15,20]
[null,20,40,{"$f":"C43-B43","v":20},null,"> 20 a 40 m³",12.606999999999999,9.3290000000000006,"R$/m³",{"$f":"J42+(G43*D43)","v":321.76499999999999},{"$f":"K42+(H43*D43)","v":238.18},{"$f":"IF(AND($C$30<=O43,$C$30>N43),J42+(G43*($C$30-N43)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O43,$C$30>N43),K42+(H43*($C$30-N43)),\"Fora da faixa\")","v":"Fora da faixa"},20,40]
[null,null,null,null,null,"> 40 m³",15.381,11.38,"R$/m³",null,null,{"$f":"IF($C$30>N44,J43+(G44*($C$30-N44)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF($C$30>N44,K43+(H44*($C$30-N44)),\"Fora da faixa\")","v":"Fora da faixa"},40]
[null,null,null,null,"Residencial","Fixa",21.23,15.7,"R$/mês",{"$f":"G45","v":21.23},{"$f":"H45","v":15.7}]
[null,0,5,{"$f":"C46-B46","v":5},null,"0 a 5 m³",2.2000000000000002,1.63,"R$/m³",{"$f":"J45+(D46*G46)","v":32.230000000000004},{"$f":"K45+(D46*H46)","v":23.849999999999998},{"$f":"IF($C$30<=O46,J45+(G46*($C$30-N46)),\"Fora da faixa\")","v":21.23},{"$f":"IF($C$30<=O46,K45+(H46*($C$30-N46)),\"Fora da faixa\")","v":15.7},0,5]
[null,5,10,{"$f":"C47-B47","v":5},null,"> 5 a 10 m³",4.6849999999999996,3.4670000000000001,"R$/m³",{"$f":"J46+(D47*G47)","v":55.655000000000001},{"$f":"K46+(D47*H47)","v":41.185000000000002},{"$f":"IF(AND($C$30<=O47,$C$30>N47),J46+(G47*($C$30-N47)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O47,$C$30>N47),K46+(H47*($C$30-N47)),\"Fora da faixa\")","v":"Fora da faixa"},5,10]
[null,10,15,{"$f":"C48-B48","v":5},null,"> 10 a 15 m³",7.26,5.3719999999999999,"R$/m³",{"$f":"J47+(D48*G48)","v":91.954999999999998},{"$f":"K47+(D48*H48)","v":68.045000000000002},{"$f":"IF(AND($C$30<=O48,$C$30>N48),J47+(G48*($C$30-N48)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O48,$C$30>N48),K47+(H48*($C$30-N48)),\"Fora da faixa\")","v":"Fora da faixa"},10,15]
[null,15,20,{"$f":"C49-B49","v":5},null,"> 15 a 20 m³",9.9109999999999996,7.3339999999999996,"R$/m³",{"$f":"J48+(D49*G49)","v":141.51},{"$f":"K48+(D49*H49)","v":104.715},{"$f":"IF(AND($C$30<=O49,$C$30>N49),J48+(G49*($C$30-N49)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O49,$C$30>N49),K48+(H49*($C$30-N49)),\"Fora da faixa\")","v":"Fora da faixa"},15,20]
[null,20,40,{"$f":"C50-B50","v":20},null,"> 20 a 40 m³",12.606999999999999,9.3290000000000006,"R$/m³",{"$f":"J49+(D50*G50)","v":393.65},{"$f":"K49+(D50*H50)","v":291.29500000000002},{"$f":"IF(AND($C$30<=O50,$C$30>N50),J49+(G50*($C$30-N50)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O50,$C$30>N50),K49+(H50*($C$30-N50)),\"Fora da faixa\")","v":"Fora da faixa"},20,40]
[null,null,null,null,null,"> 40 m³",15.381,11.38,"R$/m³",null,null,{"$f":"IF($C$30>N51,J50+(G51*($C$30-N51)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF($C$30>N51,K50+(H51*($C$30-N51)),\"Fora da faixa\")","v":"Fora da faixa"},40]
[null,null,null,null,"Comercial","Fixa",34.39,25.45,"R$/mês",{"$f":"G52","v":34.39},{"$f":"H52","v":25.45}]
[null,0,5,{"$f":"C53-B53","v":5},null,"0 a 5 m³",4.76,3.52,"R$/m³",{"$f":"J52+(G53*D53)","v":58.19},{"$f":"K52+(H53*D53)","v":43.05},{"$f":"IF($C$30<=O53,J52+(G53*($C$30-N53)),\"Fora da faixa\")","v":34.39},{"$f":"IF($C$30<=O53,K52+(H53*($C$30-N53)),\"Fora da faixa\")","v":25.45},0,5]
[null,5,10,{"$f":"C54-B54","v":5},null,"> 5 a 10 m³",7.1390000000000002,5.2830000000000004,"R$/m³",{"$f":"J53+(G54*D54)","v":93.884999999999991},{"$f":"K53+(H54*D54)","v":69.465000000000003},{"$f":"IF(AND($C$30<=O54,$C$30>N54),J53+(G54*($C$30-N54)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O54,$C$30>N54),K53+(H54*($C$30-N54)),\"Fora da faixa\")","v":"Fora da faixa"},5,10]
[null,10,20,{"$f":"C55-B55","v":10},null,"> 10 a 20 m³",9.6029999999999998,7.1059999999999999,"R$/m³",{"$f":"J54+(G55*D55)","v":189.91499999999999},{"$f":"K54+(H55*D55)","v":140.52500000000001},{"$f":"IF(AND($C$30<=O55,$C$30>N55),J54+(G55*($C$30-N55)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O55,$C$30>N55),K54+(H55*($C$30-N55)),\"Fora da faixa\")","v":"Fora da faixa"},10,20]
[null,20,40,{"$f":"C56-B56","v":20},null,"> 20 a 40 m³",12.098000000000001,8.9529999999999994,"R$/m³",{"$f":"J55+(G56*D56)","v":431.875},{"$f":"K55+(H56*D56)","v":319.58500000000004},{"$f":"IF(AND($C$30<=O56,$C$30>N56),J55+(G56*($C$30-N56)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O56,$C$30>N56),K55+(H56*($C$30-N56)),\"Fora da faixa\")","v":"Fora da faixa"},20,40]
[null,40,200,{"$f":"C57-B57","v":160},null,"> 40 a 200 m³",14.664,10.85,"R$/m³",{"$f":"J56+(G57*D57)","v":2778.1149999999998},{"$f":"K56+(H57*D57)","v":2055.585},{"$f":"IF(AND($C$30<=O57,$C$30>N57),J56+(G57*($C$30-N57)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O57,$C$30>N57),K56+(H57*($C$30-N57)),\"Fora da faixa\")","v":"Fora da faixa"},40,200]
[null,null,null,null,null,"> 200 m³",17.245000000000001,12.760999999999999,"R$/m³",null,null,{"$f":"IF($C$30>N58,J57+(G58*($C$30-N58)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF($C$30>N58,K57+(H58*($C$30-N58)),\"Fora da faixa\")","v":"Fora da faixa"},200]
[null,null,null,null,"Industrial","Fixa",34.39,25.45,"R$/mês",{"$f":"G59","v":34.39},{"$f":"H59","v":25.45}]
[null,0,5,{"$f":"C60-B60","v":5},null,"0 a 5 m³",4.76,3.52,"R$/m³",{"$f":"J59+(G60*D60)","v":58.19},{"$f":"K59+(H60*D60)","v":43.05},{"$f":"IF($C$30<=O60,J59+(G60*($C$30-N60)),\"Fora da faixa\")","v":34.39},{"$f":"IF($C$30<=O60,K59+(H60*($C$30-N60)),\"Fora da faixa\")","v":25.45},0,5]
[null,5,10,{"$f":"C61-B61","v":5},null,"> 5 a 10 m³",7.1390000000000002,5.2830000000000004,"R$/m³",{"$f":"J60+(G61*D61)","v":93.884999999999991},{"$f":"K60+(H61*D61)","v":69.465000000000003},{"$f":"IF(AND($C$30<=O61,$C$30>N61),J60+(G61*($C$30-N61)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O61,$C$30>N61),K60+(H61*($C$30-N61)),\"Fora da faixa\")","v":"Fora da faixa"},5,10]
[null,10,20,{"$f":"C62-B62","v":10},null,"> 10 a 20 m³",9.6029999999999998,7.1059999999999999,"R$/m³",{"$f":"J61+(G62*D62)","v":189.91499999999999},{"$f":"K61+(H62*D62)","v":140.52500000000001},{"$f":"IF(AND($C$30<=O62,$C$30>N62),J61+(G62*($C$30-N62)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O62,$C$30>N62),K61+(H62*($C$30-N62)),\"Fora da faixa\")","v":"Fora da faixa"},10,20]
[null,20,40,{"$f":"C63-B63","v":20},null,"> 20 a 40 m³",12.098000000000001,8.9529999999999994,"R$/m³",{"$f":"J62+(G63*D63)","v":431.875},{"$f":"K62+(H63*D63)","v":319.58500000000004},{"$f":"IF(AND($C$30<=O63,$C$30>N63),J62+(G63*($C$30-N63)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O63,$C$30>N63),K62+(H63*($C$30-N63)),\"Fora da faixa\")","v":"Fora da faixa"},20,40]
[null,40,200,{"$f":"C64-B64","v":160},null,"> 40 a 200 m³",14.664,10.85,"R$/m³",{"$f":"J63+(G64*D64)","v":2778.1149999999998},{"$f":"K63+(H64*D64)","v":2055.585},{"$f":"IF(AND($C$30<=O64,$C$30>N64),J63+(G64*($C$30-N64)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O64,$C$30>N64),K63+(H64*($C$30-N64)),\"Fora da faixa\")","v":"Fora da faixa"},40,200]
[null,null,null,null,null,"> 200 m³",17.245000000000001,12.760999999999999,"R$/m³",null,null,{"$f":"IF($C$30>N65,J64+(G65*($C$30-N65)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF($C$30>N65,K64+(H65*($C$30-N65)),\"Fora da faixa\")","v":"Fora da faixa"},200]
[null,null,null,null,"Pública","Fixa",29.22,21.63,"R$/mês",{"$f":"G66","v":29.22},{"$f":"H66","v":21.63}]
[null,0,5,{"$f":"C67-B67","v":5},null,"0 a 5 m³",4.51,3.33,"R$/m³",{"$f":"J66+(G67*D67)","v":51.769999999999996},{"$f":"K66+(H67*D67)","v":38.28},{"$f":"IF($C$30<=O67,J66+(G67*($C$30-N67)),\"Fora da faixa\")","v":29.22},{"$f":"IF($C$30<=O67,K66+(H67*($C$30-N67)),\"Fora da faixa\")","v":21.63},0,5]
[null,5,10,{"$f":"C68-B68","v":5},null,"> 5 a 10 m³",6.7629999999999999,5.0039999999999996,"R$/m³",{"$f":"J67+(G68*D68)","v":85.584999999999994},{"$f":"K67+(H68*D68)","v":63.3},{"$f":"IF(AND($C$30<=O68,$C$30>N68),J67+(G68*($C$30-N68)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O68,$C$30>N68),K67+(H68*($C$30-N68)),\"Fora da faixa\")","v":"Fora da faixa"},5,10]
[null,10,20,{"$f":"C69-B69","v":10},null,"> 10 a 20 m³",9.0960000000000001,6.7309999999999999,"R$/m³",{"$f":"J68+(G69*D69)","v":176.54500000000002},{"$f":"K68+(H69*D69)","v":130.61000000000001},{"$f":"IF(AND($C$30<=O69,$C$30>N69),J68+(G69*($C$30-N69)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O69,$C$30>N69),K68+(H69*($C$30-N69)),\"Fora da faixa\")","v":"Fora da faixa"},10,20]
[null,20,40,{"$f":"C70-B70","v":20},null,"> 20 a 40 m³",11.462,8.4819999999999993,"R$/m³",{"$f":"J69+(G70*D70)","v":405.78500000000003},{"$f":"K69+(H70*D70)","v":300.25},{"$f":"IF(AND($C$30<=O70,$C$30>N70),J69+(G70*($C$30-N70)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O70,$C$30>N70),K69+(H70*($C$30-N70)),\"Fora da faixa\")","v":"Fora da faixa"},20,40]
[null,40,200,{"$f":"C71-B71","v":160},null,"> 40 a 200 m³",13.893000000000001,10.281000000000001,"R$/m³",{"$f":"J70+(G71*D71)","v":2628.665},{"$f":"K70+(H71*D71)","v":1945.21},{"$f":"IF(AND($C$30<=O71,$C$30>N71),J70+(G71*($C$30-N71)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF(AND($C$30<=O71,$C$30>N71),K70+(H71*($C$30-N71)),\"Fora da faixa\")","v":"Fora da faixa"},40,200]
[null,null,null,null,null,"> 200 m³",16.335999999999999,12.09,"R$/m³",null,null,{"$f":"IF($C$30>N72,J71+(G72*($C$30-N72)),\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"IF($C$30>N72,K71+(H72*($C$30-N72)),\"Fora da faixa\")","v":"Fora da faixa"},200]

{"sheet":"Tutorial","index":1,"n_rows":5,"n_cols":26,"rows_kept":5,"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,null,null,null,null,"Exemplo de uso do simulador"]

{"sheet":"Tabela de Tarifas","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,1,30,1],[31,1,37,1],[1,3,1,5],[3,1,9,1],[10,1,16,1],[17,1,23,1],[1,1,1,2]]}
[]
[null,"De Jan 24 até Dez 24",null,"Tarifas"]
[null,"Categorias","Faixas","Água","Esgoto","Unidade"]
[null,"Residencial \nTarifa Social","Fixa",9.5399999999999991,7.06,"R$/mês"]
[null,null,"0 a 5 m³",1.0900000000000001,0.82,"R$/m³"]
[null,null,"> 5 a 10 m³",2.3420000000000001,1.734,"R$/m³"]
[null,null,"> 10 a 15 m³",3.629,2.6859999999999999,"R$/m³"]
[null,null,"> 15 a 20 m³",4.9560000000000004,3.6680000000000001,"R$/m³"]
[null,null,"> 20 a 40 m³",12.606999999999999,9.3290000000000006,"R$/m³"]
[null,null,"> 40 m³",15.381,11.38,"R$/m³"]
[null,"Residencial","Fixa",21.23,15.7,"R$/mês"]
[null,null,"0 a 5 m³",2.2000000000000002,1.63,"R$/m³"]
[null,null,"> 5 a 10 m³",4.6849999999999996,3.4670000000000001,"R$/m³"]
[null,null,"> 10 a 15 m³",7.26,5.3719999999999999,"R$/m³"]
[null,null,"> 15 a 20 m³",9.9109999999999996,7.3339999999999996,"R$/m³"]
[null,null,"> 20 a 40 m³",12.606999999999999,9.3290000000000006,"R$/m³"]
[null,null,"> 40 m³",15.381,11.38,"R$/m³"]
[null,"Comercial","Fixa",34.39,25.45,"R$/mês"]
[null,null,"0 a 5 m³",4.76,3.52,"R$/m³"]
[null,null,"> 5 a 10 m³",7.1390000000000002,5.2830000000000004,"R$/m³"]
[null,null,"> 10 a 20 m³",9.6029999999999998,7.1059999999999999,"R$/m³"]
[null,null,"> 20 a 40 m³",12.098000000000001,8.9529999999999994,"R$/m³"]
[null,null,"> 40 a 200 m³",14.664,10.85,"R$/m³"]
[null,null,"> 200 m³",17.245000000000001,12.760999999999999,"R$/m³"]
[null,"Industrial","Fixa",34.39,25.45,"R$/mês"]
[null,null,"0 a 5 m³",4.76,3.52,"R$/m³"]
[null,null,"> 5 a 10 m³",7.1390000000000002,5.2830000000000004,"R$/m³"]
[null,null,"> 10 a 20 m³",9.6029999999999998,7.1059999999999999,"R$/m³"]
[null,null,"> 20 a 40 m³",12.098000000000001,8.9529999999999994,"R$/m³"]
[null,null,"> 40 a 200 m³",14.664,10.85,"R$/m³"]
[null,null,"> 200 m³",17.245000000000001,12.760999999999999,"R$/m³"]
[null,"Pública","Fixa",29.22,21.63,"R$/mês"]
[null,null,"0 a 5 m³",4.51,3.33,"R$/m³"]
[null,null,"> 5 a 10 m³",6.7629999999999999,5.0039999999999996,"R$/m³"]
[null,null,"> 10 a 20 m³",9.0960000000000001,6.7309999999999999,"R$/m³"]
[null,null,"> 20 a 40 m³",11.462,8.4819999999999993,"R$/m³"]
[null,null,"> 40 a 200 m³",13.893000000000001,10.281000000000001,"R$/m³"]
[null,null,"> 200 m³",16.335999999999999,12.09,"R$/m³"]