{"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":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[33,13,34,13],[33,14,34,14],[10,1,10,3],[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],[11,4,11,5],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,4,10,5],[10,7,10,8],[10,9,10,10],[10,11,10,12],[12,4,12,5],[12,7,12,8],[12,9,12,10],[12,11,12,12],[13,4,13,5],[13,7,13,8],[13,9,13,10],[13,11,13,12],[23,2,23,6],[14,4,14,5],[14,7,14,8],[14,9,14,10],[14,11,14,12],[16,2,19,5],[20,2,21,12],[22,2,22,12],[26,6,26,7],[33,3,34,3],[33,11,33,12],[33,9,33,10],[33,4,34,4],[33,5,34,5],[33,6,33,8],[35,4,40,4],[53,4,59,4],[41,4,45,4],[46,4,52,4],[33,1,34,1],[33,2,34,2]]}
[]
[]
[null,null,"Simulador de Faturas (Tarifas vigentes a partir de 23/02/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,"Residencial",null,null,{"$f":"IF(G11>0,Painel!G29*G11,Painel!G29)","v":0},null,{"$f":"IF(G11>0,Painel!H29*G11,Painel!H29)","v":0},null,{"$f":"H11+J11","v":0}]
[null,null,null,null,"Comercial",null,null,{"$f":"IF(G12>0,Painel!G30*G12,Painel!G30)","v":0},null,{"$f":"IF(G12>0,Painel!H30*G12,Painel!H30)","v":0},null,0]
[null,null,null,null,"Industrial",null,null,{"$f":"IF(G13>0,Painel!G31*G13,Painel!G31)","v":0},null,{"$f":"IF(G13>0,Painel!H31*G13,Painel!H31)","v":0},null,0]
[null,null,null,null,"Pública",null,null,{"$f":"IF(G14>0,Painel!G32*G14,Painel!G32)","v":0},null,{"$f":"IF(G14>0,Painel!H32*G14,Painel!H32)","v":0},null,0]
[null,null,null,null,"Valor Total",null,{"$f":"SUM(G11:G14)","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,"Serviço","Volume/Economias",null,"Categoria","N° economias","Valor Água","Valor Esgoto"]
[null,"Água e Esgoto",{"$f":"IFERROR(Painel!E5/Painel!G15,0)","v":0},null,{"$f":"Painel!E11","v":"Residencial"},{"$f":"Painel!G11","v":0},{"$f":"IF($F29>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O36,L36,IF(AND($C$29>$N37,$C$29<=$O37),L37,IF(AND($C$29>$N38,$C$29<=$O38),L38,IF(AND($C$29>$N39,$C$29<=$O39),L39,IF(AND($C$29>$N40,$C$29<=$O40),L40,IF($C$29>$N41,L41,\"Erro\")))))),0),0)","v":0},{"$f":"IF($F29>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O36,M36,IF(AND($C$29>$N37,$C$29<=$O37),M37,IF(AND($C$29>$N38,$C$29<=$O38),M38,IF(AND($C$29>$N39,$C$29<=$O39),M39,IF(AND($C$29>$N40,$C$29<=$O40),M40,IF($C$29>$N41,M41,\"Erro\")))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E12","v":"Comercial"},{"$f":"Painel!G12","v":0},{"$f":"IF($F30>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O42,L42,IF(AND($C$29>$N43,$C$29<=$O43),L43,IF(AND($C$29>$N44,$C$29<=$O44),L44,IF(AND($C$29>$N45,$C$29<=$O45),L45,IF($C$29>$N46,L46,\"Erro\"))))),0),0)","v":0},{"$f":"IF($F30>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O42,M42,IF(AND($C$29>$N43,$C$29<=$O43),M43,IF(AND($C$29>$N44,$C$29<=$O44),M44,IF(AND($C$29>$N45,$C$29<=$O45),M45,IF($C$29>$N46,M46,\"Erro\"))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E13","v":"Industrial"},{"$f":"Painel!G13","v":0},{"$f":"IF($F31>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O47,L47,IF(AND($C$29>$N48,$C$29<=$O48),L48,IF(AND($C$29>$N49,$C$29<=$O49),L49,IF(AND($C$29>$N50,$C$29<=$O50),L50,IF(AND($C$29>$N51,$C$29<=$O51),L51,IF(AND($C$29>$N52,$C$29<=$O52),L52,IF($C$29>$N53,L53,\"Erro\"))))))),0),0)","v":0},{"$f":"IF($F31>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O47,M47,IF(AND($C$29>$N48,$C$29<=$O48),M48,IF(AND($C$29>$N49,$C$29<=$O49),M49,IF(AND($C$29>$N50,$C$29<=$O50),M50,IF(AND($C$29>$N51,$C$29<=$O51),M51,IF(AND($C$29>$N52,$C$29<=$O52),M52,IF($C$29>$N53,M53,\"Erro\"))))))),0),0)","v":0}]
[null,null,null,null,{"$f":"Painel!E14","v":"Pública"},{"$f":"Painel!G14","v":0},{"$f":"IF($F32>0,IF(OR($B$29=\"Só Água\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O54,L54,IF(AND($C$29>$N55,$C$29<=$O55),L55,IF(AND($C$29>$N56,$C$29<=$O56),L56,IF(AND($C$29>$N57,$C$29<=$O57),L57,IF(AND($C$29>$N58,$C$29<=$O58),L58,IF(AND($C$29>$N59,$C$29<=$O59),L59,IF($C$29>$N60,L60,\"Erro\"))))))),0),0)","v":0},{"$f":"IF($F32>0,IF(OR($B$29=\"Esgoto\",$B$29=\"Água e Esgoto\"),IF($C$29<=$O54,M54,IF(AND($C$29>$N55,$C$29<=$O55),M55,IF(AND($C$29>$N56,$C$29<=$O56),M56,IF(AND($C$29>$N57,$C$29<=$O57),M57,IF(AND($C$29>$N58,$C$29<=$O58),M58,IF(AND($C$29>$N59,$C$29<=$O59),M59,IF($C$29>$N60,M60,\"Erro\"))))))),0),0)","v":0}]
[]
[null,"Min","Max","Intervalo","Categorias","Faixas","Tarifas",null,null,"Acumulado",null,"Cálculos",null,"Referência Min.","Referência Max."]
[null,null,null,null,null,null,"Água","Esgoto","unidade","Água","Esgoto","Água","Esgoto"]
[null,0,6,{"$f":"C36-B36","v":6},"Residencial","0 a 6m³",6.6539479210005821,6.6539479210005821,"R$/m³",{"$f":"G36*D36","v":39.923687526003491},{"$f":"J36","v":39.923687526003491},{"$f":"IF($C$29<=O36,J36,\"Fora da faixa\")","v":39.923687526003491},{"$f":"L36","v":39.923687526003491},{"$f":"B36","v":0},{"$f":"C36","v":6}]
[null,6,10,{"$f":"C37-B37","v":4},null,"> 6 a 10m³",1.1801062177320547,1.1801062177320547,"R$/m³",{"$f":"J36+(D37*G37)","v":44.64411239693171},{"$f":"J37","v":44.64411239693171},{"$f":"IF(AND($C$29>N37,$C$29<=O37),(G37*($C$29-N37))+J36,\"Fora da faixa\")","v":"Fora da faixa"},{"$f":"L37","v":"Fora da faixa"},{"$f":"B37","v":6},{"$f":"C37","v":10}]
[null,10,15,{"$f":"C38-B38","v":5},null,"> 10 a 15m³",8.2224479203920993,8.2224479203920993,"R$/m³",{"$f":"J37+(D38*G38)","v":85.7563519988922},85.7563519988922,{"$f":"IF(AND($C$29>N38,$C$29<=O38),(G38*($C$29-N38))+J37,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",10,15]
[null,15,20,{"$f":"C39-B39","v":5},null,"> 15 a 20m³",8.2954525305282676,8.2954525305282676,"R$/m³",{"$f":"J38+(D39*G39)","v":127.23361465153354},127.23361465153354,{"$f":"IF(AND($C$29>N39,$C$29<=O39),(G39*($C$29-N39))+J38,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",15,20]
[null,20,40,{"$f":"C40-B40","v":20},null,"> 20 a 40m³",8.3682257472884114,8.3682257472884114,"R$/m³",{"$f":"J39+(D40*G40)","v":294.59812959730175},294.59812959730175,{"$f":"IF(AND($C$29>N40,$C$29<=O40),(G40*($C$29-N40))+J39,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",20,40]
[null,40,null,null,null,"> 40 m³",15.42063306180558,15.42063306180558,"R$/m³",null,null,{"$f":"IF($C$29>N41,(G41*($C$29-N41))+J40,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",40]
[null,0,6,{"$f":"C42-B42","v":6},"Comercial","0 a 6m³",9.6929528250366488,9.6929528250366488,"R$/m³",{"$f":"D42*G42","v":58.157716950219893},58.157716950219893,{"$f":"IF($C$29<=O42,J42,\"Fora da faixa\")","v":58.157716950219893},58.157716950219893,0,6]
[null,6,10,4,null,"> 6 a 10m³",1.2258064094971688,1.2258064094971688,"R$/m³",{"$f":"J42+(D43*G43)","v":63.060942588208569},63.060942588208569,{"$f":"IF(AND($C$29>N43,$C$29<=O43),(G43*($C$29-N43))+J42,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",6,10]
[null,10,40,30,null,"> 10 a 40m³",12.089609717224837,12.089609717224837,"R$/m³",{"$f":"J43+(D44*G44)","v":425.74923410495364},425.74923410495364,{"$f":"IF(AND($C$29>N44,$C$29<=O44),(G44*($C$29-N44))+J43,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",10,40]
[null,40,100,60,null,"> 40 a 100m³",12.110203727691141,12.110203727691141,"R$/m³",1152.3614577664221,1152.3614577664221,{"$f":"IF(AND($C$29>N45,$C$29<=O45),(G45*($C$29-N45))+J44,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",40,100]
[null,100,null,null,null,"> 100m³",12.206463372117913,12.206463372117913,"R$/m³",null,null,{"$f":"IF($C$29>N46,(G46*($C$29-N46))+J45,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",100]
[null,0,6,6,"Industrial","0 a 6m³",10.820069959658774,10.820069959658774,"R$/m³",{"$f":"D47*G47","v":64.920419757952644},64.920419757952644,{"$f":"IF($C$29<=O47,J47,\"Fora da faixa\")","v":64.920419757952644},64.920419757952644,0,6]
[null,6,10,4,null,"> 6 a 10m³",1.177445193907757,1.177445193907757,"R$/m³",69.630200533583675,69.630200533583675,"Fora da faixa","Fora da faixa",6,10]
[null,10,20,10,null,"> 10 a 20m³",12.206463372117913,12.206463372117913,"R$/m³",191.69483425476278,191.69483425476278,"Fora da faixa","Fora da faixa",10,20]
[null,20,40,20,null,"> 20 a 40m³",12.254246104267258,12.254246104267258,"R$/m³",436.77975634010795,436.77975634010795,"Fora da faixa","Fora da faixa",20,40]
[null,40,100,60,null,"> 40 a 100m³",12.368901522088089,12.368901522088089,"R$/m³",1178.9138476653934,1178.9138476653934,"Fora da faixa","Fora da faixa",40,100]
[null,100,600,500,null,"> 100 a 600m³",12.982903845372798,12.982903845372798,"R$/m³",7670.365770351792,7670.365770351792,{"$f":"IF(AND($C$29>N52,$C$29<=O52),(G52*($C$29-N52))+J51,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",100,600]
[null,600,null,null,null,"> 600m³",13.150085559551504,13.150085559551504,"R$/m³",null,null,{"$f":"IF($C$29>N53,(G53*($C$29-N53))+J52,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",600]
[null,0,6,6,"Pública","0 a 6m³",9.6680780371138653,9.6680780371138653,"R$/m³",{"$f":"D54*G54","v":58.008468222683192},58.008468222683192,{"$f":"IF($C$29<=O54,J54,\"Fora da faixa\")","v":58.008468222683192},58.008468222683192,0,6]
[null,6,10,4,null,"> 6 a 10m³",1.389748616411514,1.389748616411514,"R$/m³",63.56746268832925,63.56746268832925,"Fora da faixa","Fora da faixa",6,10]
[null,10,20,10,null,"> 10 a 20m³",10.931601566903254,10.931601566903254,"R$/m³",172.88347835736178,172.88347835736178,"Fora da faixa","Fora da faixa",10,20]
[null,20,40,20,null,"> 20 a 40m³",13.784797589990529,13.784797589990529,"R$/m³",448.5794301571724,448.5794301571724,"Fora da faixa","Fora da faixa",20,40]
[null,40,100,60,null,"> 40 a 100m³",13.921782468597858,13.921782468597858,"R$/m³",1283.8863782730439,1283.8863782730439,"Fora da faixa","Fora da faixa",40,100]
[null,100,300,200,null,"> 100 a 300m³",13.969796594123231,13.969796594123231,"R$/m³",4077.8456970976904,4077.8456970976904,"Fora da faixa","Fora da faixa",100,300]
[null,300,null,null,null,"> 300m³",15.14932432841522,15.14932432841522,"R$/m³",null,null,{"$f":"IF($C$29>N60,(G60*($C$29-N60))+J59,\"Fora da faixa\")","v":"Fora da faixa"},"Fora da faixa",300]

{"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":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,5],[30,4,30,10],[31,4,31,10],[3,1,8,1],[9,1,15,1],[16,1,20,1],[21,1,27,1],[29,1,29,2]]}
[]
[null,"RESOLUÇÃO ARSAE-MG Nº 175, DE 15 DE DEZEMBRO DE 2022"]
[null,"Categorias","Faixas","Água"," Esgoto","Unidade"]
[null,"Residencial","0 a 6m³",6.6539479210005821,6.6539479210005821,"R$/m³"]
[null,null,"> 6 a 10m³",1.1801062177320547,1.1801062177320547,"R$/m³"]
[null,null,"> 10 a 15m³",8.2224479203920993,8.2224479203920993,"R$/m³"]
[null,null,"> 15 a 20m³",8.2954525305282676,8.2954525305282676,"R$/m³"]
[null,null,"> 20 a 40m³",8.3682257472884114,8.3682257472884114,"R$/m³"]
[null,null,"> 40 m³",15.42063306180558,15.42063306180558,"R$/m³"]
[null,"Pública","0 a 6m³",9.6680780371138653,9.6680780371138653,"R$/m³"]
[null,null,"> 6 a 10m³",1.389748616411514,1.389748616411514,"R$/m³"]
[null,null,"> 10 a 20m³",10.931601566903254,10.931601566903254,"R$/m³"]
[null,null,"> 20 a 40m³",13.784797589990529,13.784797589990529,"R$/m³"]
[null,null,"> 40 a 100m³",13.921782468597858,13.921782468597858,"R$/m³"]
[null,null,"> 100 a 300m³",13.969796594123231,13.969796594123231,"R$/m³"]
[null,null,"> 300m³",15.14932432841522,15.14932432841522,"R$/m³"]
[null,"Comercial","0 a 6m³",9.6929528250366488,9.6929528250366488,"R$/m³"]
[null,null,"> 6 a 10m³",1.2258064094971688,1.2258064094971688,"R$/m³"]
[null,null,"> 10 a 40m³",12.089609717224837,12.089609717224837,"R$/m³"]
[null,null,"> 40 a 100m³",12.110203727691141,12.110203727691141,"R$/m³"]
[null,null,"> 100m³",12.206463372117913,12.206463372117913,"R$/m³"]
[null,"Industrial","0 a 6m³",10.820069959658774,10.820069959658774,"R$/m³"]
[null,null,"> 6 a 10m³",1.177445193907757,1.177445193907757,"R$/m³"]
[null,null,"> 10 a 20m³",12.206463372117913,12.206463372117913,"R$/m³"]
[null,null,"> 20 a 40m³",12.254246104267258,12.254246104267258,"R$/m³"]
[null,null,"> 40 a 100m³",12.368901522088089,12.368901522088089,"R$/m³"]
[null,null,"> 100 a 600m³",12.982903845372798,12.982903845372798,"R$/m³"]
[null,null,"> 600m³",13.150085559551504,13.150085559551504,"R$/m³"]
[]
[null,"Tarifas mínimas*"]
[null,"Categorias","Valor (R$)",null,"* -> As tarifas mínimas são equivalentes ao preço do consumo"]
[null,"Residencial",79.842284397734417,null,"         de 6m³ de água e/ou esgoto para todas as categorias."]
[null,"Comercial",116.30988045941517]
[null,"Industrial",129.8348232881286]
[null,"Pública",116.0206387393828]