{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CALCULADORA","ESTRUTURA TARIFÁRIA ATUAL"],"not_rendered":{"charts":0,"images":1,"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":"CALCULADORA","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[17,1,17,2]]}
[]
[null,"CALCULADORA CASAN COMERCIAL"]
[null,"DIGITE O VOLUME CONSUMIDO EM m³"]
[null,0]
[null,"DIGITE O NÚMERO DE UNIDADES CONSUMIDORAS"]
[null,0]
[]
[]
[null,"FATURA ATUAL COM NOVA ESTRUTURA (R$)"]
[null,0,null,462.8]
[null,"Tarifa fixa (TFDI) + Volume medido"]
[null,"FATURA NO CASO DE APLICAÇÃO DA DECISÃO JUDICIAL (R$)",null,462.8]
[null,0,null,462.8]
[null,"FATURA ANTERIOR (somente água)",null,92.56]
[null,0,null,92.56]
[null,null,null,324.5]
[null,"CALCULADORA COM RESULTADOS PARA SOMENTE ÁGUA.\n* CASO SUA RESIDÊNCIA/CONDOMÍNIO POSSUA O SERVIÇO DE COLETA E TRATAMENTO DE ESGOTO, O VALOR CALCULADO DEVERÁ SER MULTIPLICADO POR 2.",null,324.5]

{"sheet":"ESTRUTURA TARIFÁRIA ATUAL","index":1,"n_rows":61,"n_cols":122,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,112,0,117],[1,114,1,115],[31,0,31,107],[33,0,43,0],[33,1,33,2],[34,1,34,2],[32,106,32,107],[42,109,43,110],[27,109,27,110],[3,109,12,110],[0,0,0,107],[1,116,1,117],[2,112,12,112],[2,113,2,114],[2,116,2,117],[3,113,3,114],[2,0,12,0],[2,1,2,2],[3,1,3,2],[1,106,1,107],[15,0,15,107],[16,109,26,110],[32,109,41,110],[52,109,58,110],[59,109,60,110],[47,0,47,107],[48,0,48,107],[50,0,60,0],[50,1,50,2],[50,106,50,107],[51,1,51,2],[17,0,27,0],[17,1,17,2],[18,1,18,2],[16,106,16,107],[16,0,16,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDOMÍNIO em FLORIANÓPOLIS (caso real)"]
[null,null,{"$f":"CALCULADORA!B6","v":0}," ECONOMIAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONSUMO:",null,null,null,null,null,null,null,"113 ECONOMIAS",null,"CONSUMO:"]
["COMERCIAL","Consumo Mínimo = ",null,66.7,0,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31,null,32,null,33,null,34,null,35,null,36,null,37,null,38,null,39,null,40,null,41,null,42,null,43,null,44,null,45,null,46,null,47,null,48,null,49,null,50,null,{"$f":"CALCULADORA!B4","v":0}," m³",null,null,null,null,"RESIDENCIAL  ","Consumo Mínimo = 113x",null,46.281999999999996,"1080 m³"]
[null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total",null,"Simulação estrutura tarifária anterior.",null,null,null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total",null,null,"tabela de apoio"]
[null,0,10,6.67,0,{"$f":"E5*$D$20","v":0},1,{"$f":"G5*$D$20","v":6.67},2,{"$f":"I5*$D$20","v":13.34},3,{"$f":"K5*$D$20","v":20.009999999999998},4,{"$f":"M5*$D$20","v":26.68},5,{"$f":"O5*$D$20","v":33.35},6,{"$f":"Q5*$D$20","v":40.019999999999996},7,{"$f":"S5*$D$20","v":46.69},8,{"$f":"U5*$D$20","v":53.36},9,{"$f":"W5*$D$20","v":60.03},10,{"$f":"Y5*$D$20","v":66.7},10,{"$f":"AA5*$D$20","v":66.7},10,{"$f":"AC5*$D$20","v":66.7},10,{"$f":"AE5*$D$20","v":66.7},10,{"$f":"AG5*$D$20","v":66.7},10,{"$f":"AI5*$D$20","v":66.7},10,{"$f":"AK5*$D$20","v":66.7},10,{"$f":"AM5*$D$20","v":66.7},10,{"$f":"AO5*$D$20","v":66.7},10,{"$f":"AQ5*$D$20","v":66.7},10,{"$f":"AS5*$D$20","v":66.7},10,{"$f":"AU5*$D$20","v":66.7},10,{"$f":"AW5*$D$20","v":66.7},10,{"$f":"AY5*$D$20","v":66.7},10,{"$f":"BA5*$D$20","v":66.7},10,{"$f":"BC5*$D$20","v":66.7},10,{"$f":"BE5*$D$20","v":66.7},10,{"$f":"BG5*$D$20","v":66.7},10,{"$f":"BI5*$D$20","v":66.7},10,{"$f":"BK5*$D$20","v":66.7},10,{"$f":"BM5*$D$20","v":66.7},10,{"$f":"BO5*$D$20","v":66.7},10,{"$f":"BQ5*$D$20","v":66.7},10,{"$f":"BS5*$D$20","v":66.7},10,{"$f":"BU5*$D$20","v":66.7},10,{"$f":"BW5*$D$20","v":66.7},10,{"$f":"BY5*$D$20","v":66.7},10,{"$f":"CA5*$D$20","v":66.7},10,{"$f":"CC5*$D$20","v":66.7},10,{"$f":"CE5*$D$20","v":66.7},10,{"$f":"CG5*$D$20","v":66.7},10,{"$f":"CI5*$D$20","v":66.7},10,{"$f":"CK5*$D$20","v":66.7},10,{"$f":"CM5*$D$20","v":66.7},10,{"$f":"CO5*$D$20","v":66.7},10,{"$f":"CQ5*$D$20","v":66.7},10,{"$f":"CS5*$D$20","v":66.7},10,{"$f":"CU5*$D$20","v":66.7},10,{"$f":"CW5*$D$20","v":66.7},10,{"$f":"CY5*$D$20","v":66.7},10,{"$f":"DA5*$D$20","v":66.7},{"$f":"DQ5","v":0},{"$f":"DC5*$D$5","v":0},null,null,null,5,null,0,10,4.6280000000000001,{"$f":"10*113","v":1130},{"$f":"DM5*$D$5","v":7537.1},null,null,{"$f":"C5*C2","v":0},"consumo faixa 01"]
[null,10,25,11.068099999999999,null,{"$f":"E6*$D$21","v":0},null,{"$f":"G6*$D$21","v":0},null,{"$f":"I6*$D$21","v":0},null,{"$f":"K6*$D$21","v":0},null,{"$f":"M6*$D$21","v":0},null,{"$f":"O6*$D$21","v":0},null,{"$f":"Q6*$D$21","v":0},null,{"$f":"S6*$D$21","v":0},null,{"$f":"U6*$D$21","v":0},null,{"$f":"W6*$D$21","v":0},null,{"$f":"Y6*$D$21","v":0},1,{"$f":"AA6*$D$21","v":11.068099999999999},2,{"$f":"AC6*$D$21","v":22.136199999999999},3,{"$f":"AE6*$D$21","v":33.204299999999996},4,{"$f":"AG6*$D$21","v":44.272399999999998},5,{"$f":"AI6*$D$21","v":55.340499999999999},6,{"$f":"AK6*$D$21","v":66.408599999999993},7,{"$f":"AM6*$D$21","v":77.476699999999994},8,{"$f":"AO6*$D$21","v":88.544799999999995},9,{"$f":"AQ6*$D$21","v":99.612899999999996},10,{"$f":"AS6*$D$21","v":110.681},11,{"$f":"AU6*$D$21","v":121.7491},12,{"$f":"AW6*$D$21","v":132.81719999999999},13,{"$f":"AY6*$D$21","v":143.8853},14,{"$f":"BA6*$D$21","v":154.95339999999999},15,{"$f":"BC6*$D$21","v":166.0215},15,{"$f":"BE6*$D$21","v":166.0215},15,{"$f":"BG6*$D$21","v":166.0215},15,{"$f":"BI6*$D$21","v":166.0215},15,{"$f":"BK6*$D$21","v":166.0215},15,{"$f":"BM6*$D$21","v":166.0215},15,{"$f":"BO6*$D$21","v":166.0215},15,{"$f":"BQ6*$D$21","v":166.0215},15,{"$f":"BS6*$D$21","v":166.0215},15,{"$f":"BU6*$D$21","v":166.0215},15,{"$f":"BW6*$D$21","v":166.0215},15,{"$f":"BY6*$D$21","v":166.0215},15,{"$f":"CA6*$D$21","v":166.0215},15,{"$f":"CC6*$D$21","v":166.0215},15,{"$f":"CE6*$D$21","v":166.0215},15,{"$f":"CG6*$D$21","v":166.0215},15,{"$f":"CI6*$D$21","v":166.0215},15,{"$f":"CK6*$D$21","v":166.0215},15,{"$f":"CM6*$D$21","v":166.0215},15,{"$f":"CO6*$D$21","v":166.0215},15,{"$f":"CQ6*$D$21","v":166.0215},15,{"$f":"CS6*$D$21","v":166.0215},15,{"$f":"CU6*$D$21","v":166.0215},15,{"$f":"CW6*$D$21","v":166.0215},15,{"$f":"CY6*$D$21","v":166.0215},15,{"$f":"DA6*$D$21","v":166.0215},{"$f":"IF($DC$3<=$DQ$5,0,IF($DC$3>($DQ$5+$DQ$6),$DQ$6,IF($DC$3>$DQ$5,($DC$3-$DQ$5))))","v":0},{"$f":"DC6*$D$21","v":0},null,null,null,6,null,11,25,8.1217000000000006,null,{"$f":"DM6*$D$21","v":0},null,null,{"$f":"15*C2","v":0},"consumo faixa 02"]
[null,25,50,11.068099999999999,null,{"$f":"E7*$D$22","v":0},null,{"$f":"G7*$D$22","v":0},null,{"$f":"I7*$D$22","v":0},null,{"$f":"K7*$D$22","v":0},null,{"$f":"M7*$D$22","v":0},null,{"$f":"O7*$D$22","v":0},null,{"$f":"Q7*$D$22","v":0},null,{"$f":"S7*$D$22","v":0},null,{"$f":"U7*$D$22","v":0},null,{"$f":"W7*$D$22","v":0},null,{"$f":"Y7*$D$22","v":0},null,{"$f":"AA7*$D$22","v":0},null,{"$f":"AC7*$D$22","v":0},null,{"$f":"AE7*$D$22","v":0},null,{"$f":"AG7*$D$22","v":0},null,{"$f":"AI7*$D$22","v":0},null,{"$f":"AK7*$D$22","v":0},null,{"$f":"AM7*$D$22","v":0},null,{"$f":"AO7*$D$22","v":0},null,{"$f":"AQ7*$D$22","v":0},null,{"$f":"AS7*$D$22","v":0},null,{"$f":"AU7*$D$22","v":0},null,{"$f":"AW7*$D$22","v":0},null,{"$f":"AY7*$D$22","v":0},null,{"$f":"BA7*$D$22","v":0},null,{"$f":"BC7*$D$22","v":0},1,{"$f":"BE7*$D$22","v":11.068099999999999},2,{"$f":"BG7*$D$22","v":22.136199999999999},3,{"$f":"BI7*$D$22","v":33.204299999999996},4,{"$f":"BK7*$D$22","v":44.272399999999998},5,{"$f":"BM7*$D$22","v":55.340499999999999},6,{"$f":"BO7*$D$22","v":66.408599999999993},7,{"$f":"BQ7*$D$22","v":77.476699999999994},8,{"$f":"BS7*$D$22","v":88.544799999999995},9,{"$f":"BU7*$D$22","v":99.612899999999996},10,{"$f":"BW7*$D$22","v":110.681},11,{"$f":"BY7*$D$22","v":121.7491},12,{"$f":"CA7*$D$22","v":132.81719999999999},13,{"$f":"CC7*$D$22","v":143.8853},14,{"$f":"CE7*$D$22","v":154.95339999999999},15,{"$f":"CG7*$D$22","v":166.0215},16,{"$f":"CI7*$D$22","v":177.08959999999999},17,{"$f":"CK7*$D$22","v":188.15769999999998},18,{"$f":"CM7*$D$22","v":199.22579999999999},19,{"$f":"CO7*$D$22","v":210.29389999999998},20,{"$f":"CQ7*$D$22","v":221.36199999999999},21,{"$f":"CS7*$D$22","v":232.43009999999998},22,{"$f":"CU7*$D$22","v":243.4982},23,{"$f":"CW7*$D$22","v":254.56629999999998},24,{"$f":"CY7*$D$22","v":265.63439999999997},25,{"$f":"DA7*$D$22","v":276.70249999999999},{"$f":"IF($DC$3<($DQ$5+$DQ$6),0,IF($DC$3<=$DQ$5,0,IF($DC$3>($DQ$5+$DQ$6+DQ7),DQ7,IF($DC$3>$DQ$6,$DC$3-DQ5-DQ6))))","v":0},{"$f":"DC7*$D$22","v":0},null,null,null,7,null,26,50,11.3741,null,{"$f":"DM7*$D$22","v":0},null,null,{"$f":"25*C2","v":0},"consumo faixa 03"]
[null,51,9999,13.9229,null,{"$f":"E8*$D$23","v":0},null,{"$f":"G8*$D$23","v":0},null,{"$f":"I8*$D$23","v":0},null,{"$f":"K8*$D$23","v":0},null,{"$f":"M8*$D$23","v":0},null,{"$f":"O8*$D$23","v":0},null,{"$f":"Q8*$D$23","v":0},null,{"$f":"S8*$D$23","v":0},null,{"$f":"U8*$D$23","v":0},null,{"$f":"W8*$D$23","v":0},null,{"$f":"Y8*$D$23","v":0},null,{"$f":"AA8*$D$23","v":0},null,{"$f":"AC8*$D$23","v":0},null,{"$f":"AE8*$D$23","v":0},null,{"$f":"AG8*$D$23","v":0},null,{"$f":"AI8*$D$23","v":0},null,{"$f":"AK8*$D$23","v":0},null,{"$f":"AM8*$D$23","v":0},null,{"$f":"AO8*$D$23","v":0},null,{"$f":"AQ8*$D$23","v":0},null,{"$f":"AS8*$D$23","v":0},null,{"$f":"AU8*$D$23","v":0},null,{"$f":"AW8*$D$23","v":0},null,{"$f":"AY8*$D$23","v":0},null,{"$f":"BA8*$D$23","v":0},null,{"$f":"BC8*$D$23","v":0},null,{"$f":"BE8*$D$23","v":0},null,{"$f":"BG8*$D$23","v":0},null,{"$f":"BI8*$D$23","v":0},null,{"$f":"BK8*$D$23","v":0},null,{"$f":"BM8*$D$23","v":0},null,{"$f":"BO8*$D$23","v":0},null,{"$f":"BQ8*$D$23","v":0},null,{"$f":"BS8*$D$23","v":0},null,{"$f":"BU8*$D$23","v":0},null,{"$f":"BW8*$D$23","v":0},null,{"$f":"BY8*$D$23","v":0},null,{"$f":"CA8*$D$23","v":0},null,{"$f":"CC8*$D$23","v":0},null,{"$f":"CE8*$D$23","v":0},null,{"$f":"CG8*$D$23","v":0},null,{"$f":"CI8*$D$23","v":0},null,{"$f":"CK8*$D$23","v":0},null,{"$f":"CM8*$D$23","v":0},null,{"$f":"CO8*$D$23","v":0},null,{"$f":"CQ8*$D$23","v":0},null,{"$f":"CS8*$D$23","v":0},null,{"$f":"CU8*$D$23","v":0},null,{"$f":"CW8*$D$23","v":0},null,{"$f":"CY8*$D$23","v":0},null,{"$f":"DA8*$D$23","v":0},{"$f":"IF($DQ$8>=0,$DQ$8,0)","v":0},{"$f":"DC8*$D$23","v":0},null,null,null,null,null,51,9999,13.6197,null,{"$f":"DM8*$D$23","v":0},null,null,{"$f":"IF(DQ7=0,0,IF((DC3-DQ5-DQ6-DQ7)<=0,0,IF((DC3-DQ5-DQ6-DQ7)>0,(DC3-DQ5-DQ6-DQ7))))","v":0},"consumo acima da faixa 03"]
[null,"SUBTOTAL",null,null,null,{"$f":"SUM(F5:F8)","v":0},null,{"$f":"SUM(H5:H8)","v":6.67},null,{"$f":"SUM(J5:J8)","v":13.34},null,{"$f":"SUM(L5:L8)","v":20.009999999999998},null,{"$f":"SUM(N5:N8)","v":26.68},null,{"$f":"SUM(P5:P8)","v":33.35},null,{"$f":"SUM(R5:R8)","v":40.019999999999996},null,{"$f":"SUM(T5:T8)","v":46.69},null,{"$f":"SUM(V5:V8)","v":53.36},null,{"$f":"SUM(X5:X8)","v":60.03},null,{"$f":"SUM(Z5:Z8)","v":66.7},null,{"$f":"SUM(AB5:AB8)","v":77.768100000000004},null,{"$f":"SUM(AD5:AD8)","v":88.836200000000005},null,{"$f":"SUM(AF5:AF8)","v":99.904300000000006},null,{"$f":"SUM(AH5:AH8)","v":110.97239999999999},null,{"$f":"SUM(AJ5:AJ8)","v":122.04050000000001},null,{"$f":"SUM(AL5:AL8)","v":133.1086},null,{"$f":"SUM(AN5:AN8)","v":144.17669999999998},null,{"$f":"SUM(AP5:AP8)","v":155.2448},null,{"$f":"SUM(AR5:AR8)","v":166.31290000000001},null,{"$f":"SUM(AT5:AT8)","v":177.381},null,{"$f":"SUM(AV5:AV8)","v":188.44909999999999},null,{"$f":"SUM(AX5:AX8)","v":199.5172},null,{"$f":"SUM(AZ5:AZ8)","v":210.58530000000002},null,{"$f":"SUM(BB5:BB8)","v":221.65339999999998},null,{"$f":"SUM(BD5:BD8)","v":232.72149999999999},null,{"$f":"SUM(BF5:BF8)","v":243.78959999999998},null,{"$f":"SUM(BH5:BH8)","v":254.85769999999999},null,{"$f":"SUM(BJ5:BJ8)","v":265.92579999999998},null,{"$f":"SUM(BL5:BL8)","v":276.9939},null,{"$f":"SUM(BN5:BN8)","v":288.06200000000001},null,{"$f":"SUM(BP5:BP8)","v":299.13009999999997},null,{"$f":"SUM(BR5:BR8)","v":310.19819999999999},null,{"$f":"SUM(BT5:BT8)","v":321.2663},null,{"$f":"SUM(BV5:BV8)","v":332.33439999999996},null,{"$f":"SUM(BX5:BX8)","v":343.40249999999997},null,{"$f":"SUM(BZ5:BZ8)","v":354.47059999999999},null,{"$f":"SUM(CB5:CB8)","v":365.53869999999995},null,{"$f":"SUM(CD5:CD8)","v":376.60680000000002},null,{"$f":"SUM(CF5:CF8)","v":387.67489999999998},null,{"$f":"SUM(CH5:CH8)","v":398.74299999999999},null,{"$f":"SUM(CJ5:CJ8)","v":409.81110000000001},null,{"$f":"SUM(CL5:CL8)","v":420.87919999999997},null,{"$f":"SUM(CN5:CN8)","v":431.94729999999998},null,{"$f":"SUM(CP5:CP8)","v":443.0154},null,{"$f":"SUM(CR5:CR8)","v":454.08349999999996},null,{"$f":"SUM(CT5:CT8)","v":465.15159999999997},null,{"$f":"SUM(CV5:CV8)","v":476.21969999999999},null,{"$f":"SUM(CX5:CX8)","v":487.28779999999995},null,{"$f":"SUM(CZ5:CZ8)","v":498.35589999999996},null,{"$f":"SUM(DB5:DB8)","v":509.42399999999998},null,{"$f":"SUM(DD5:DD8)","v":0},null,null,null,null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(DN5:DN8)","v":7537.1}]
[null,"TOTAL",null,null,null,{"$f":"IF((F9<=$D$18),$D$18,F9)","v":66.7},null,{"$f":"IF((H9<=$D$18),$D$18,H9)","v":66.7},null,{"$f":"IF((J9<=$D$18),$D$18,J9)","v":66.7},null,{"$f":"IF((L9<=$D$18),$D$18,L9)","v":66.7},null,{"$f":"IF((N9<=$D$18),$D$18,N9)","v":66.7},null,{"$f":"IF((P9<=$D$18),$D$18,P9)","v":66.7},null,{"$f":"IF((R9<=$D$18),$D$18,R9)","v":66.7},null,{"$f":"IF((T9<=$D$18),$D$18,T9)","v":66.7},null,{"$f":"IF((V9<=$D$18),$D$18,V9)","v":66.7},null,{"$f":"IF((X9<=$D$18),$D$18,X9)","v":66.7},null,{"$f":"IF((Z9<=$D$18),$D$18,Z9)","v":66.7},null,{"$f":"IF((AB9<=$D$18),$D$18,AB9)","v":77.768100000000004},null,{"$f":"IF((AD9<=$D$18),$D$18,AD9)","v":88.836200000000005},null,{"$f":"IF((AF9<=$D$18),$D$18,AF9)","v":99.904300000000006},null,{"$f":"IF((AH9<=$D$18),$D$18,AH9)","v":110.97239999999999},null,{"$f":"IF((AJ9<=$D$18),$D$18,AJ9)","v":122.04050000000001},null,{"$f":"IF((AL9<=$D$18),$D$18,AL9)","v":133.1086},null,{"$f":"IF((AN9<=$D$18),$D$18,AN9)","v":144.17669999999998},null,{"$f":"IF((AP9<=$D$18),$D$18,AP9)","v":155.2448},null,{"$f":"IF((AR9<=$D$18),$D$18,AR9)","v":166.31290000000001},null,{"$f":"IF((AT9<=$D$18),$D$18,AT9)","v":177.381},null,{"$f":"IF((AV9<=$D$18),$D$18,AV9)","v":188.44909999999999},null,{"$f":"IF((AX9<=$D$18),$D$18,AX9)","v":199.5172},null,{"$f":"IF((AZ9<=$D$18),$D$18,AZ9)","v":210.58530000000002},null,{"$f":"IF((BB9<=$D$18),$D$18,BB9)","v":221.65339999999998},null,{"$f":"IF((BD9<=$D$18),$D$18,BD9)","v":232.72149999999999},null,{"$f":"IF((BF9<=$D$18),$D$18,BF9)","v":243.78959999999998},null,{"$f":"IF((BH9<=$D$18),$D$18,BH9)","v":254.85769999999999},null,{"$f":"IF((BJ9<=$D$18),$D$18,BJ9)","v":265.92579999999998},null,{"$f":"IF((BL9<=$D$18),$D$18,BL9)","v":276.9939},null,{"$f":"IF((BN9<=$D$18),$D$18,BN9)","v":288.06200000000001},null,{"$f":"IF((BP9<=$D$18),$D$18,BP9)","v":299.13009999999997},null,{"$f":"IF((BR9<=$D$18),$D$18,BR9)","v":310.19819999999999},null,{"$f":"IF((BT9<=$D$18),$D$18,BT9)","v":321.2663},null,{"$f":"IF((BV9<=$D$18),$D$18,BV9)","v":332.33439999999996},null,{"$f":"IF((BX9<=$D$18),$D$18,BX9)","v":343.40249999999997},null,{"$f":"IF((BZ9<=$D$18),$D$18,BZ9)","v":354.47059999999999},null,{"$f":"IF((CB9<=$D$18),$D$18,CB9)","v":365.53869999999995},null,{"$f":"IF((CD9<=$D$18),$D$18,CD9)","v":376.60680000000002},null,{"$f":"IF((CF9<=$D$18),$D$18,CF9)","v":387.67489999999998},null,{"$f":"IF((CH9<=$D$18),$D$18,CH9)","v":398.74299999999999},null,{"$f":"IF((CJ9<=$D$18),$D$18,CJ9)","v":409.81110000000001},null,{"$f":"IF((CL9<=$D$18),$D$18,CL9)","v":420.87919999999997},null,{"$f":"IF((CN9<=$D$18),$D$18,CN9)","v":431.94729999999998},null,{"$f":"IF((CP9<=$D$18),$D$18,CP9)","v":443.0154},null,{"$f":"IF((CR9<=$D$18),$D$18,CR9)","v":454.08349999999996},null,{"$f":"IF((CT9<=$D$18),$D$18,CT9)","v":465.15159999999997},null,{"$f":"IF((CV9<=$D$18),$D$18,CV9)","v":476.21969999999999},null,{"$f":"IF((CX9<=$D$18),$D$18,CX9)","v":487.28779999999995},null,{"$f":"IF((CZ9<=$D$18),$D$18,CZ9)","v":498.35589999999996},null,{"$f":"IF((DB9<=$D$18),$D$18,DB9)","v":509.42399999999998},null,{"$f":"IF((DD9<=$D$3),$D$3*C2,DD9)","v":0},null,null,null,null,null,"TOTAL",null,null,null,{"$f":"IF((DN9<=$D$18),$D$18,DN9)","v":7537.1}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F10","v":66.7},null,{"$f":"H10","v":66.7},null,{"$f":"J10","v":66.7},null,{"$f":"L10","v":66.7},null,{"$f":"N10","v":66.7},null,{"$f":"P10","v":66.7},null,{"$f":"R10","v":66.7},null,{"$f":"T10","v":66.7},null,{"$f":"V10","v":66.7},null,{"$f":"X10","v":66.7},null,{"$f":"Z10","v":66.7},null,{"$f":"AB10","v":77.768100000000004},null,{"$f":"AD10","v":88.836200000000005},null,{"$f":"AF10","v":99.904300000000006},null,{"$f":"AH10","v":110.97239999999999},null,{"$f":"AJ10","v":122.04050000000001},null,{"$f":"AL10","v":133.1086},null,{"$f":"AN10","v":144.17669999999998},null,{"$f":"AP10","v":155.2448},null,{"$f":"AR10","v":166.31290000000001},null,{"$f":"AT10","v":177.381},null,{"$f":"AV10","v":188.44909999999999},null,{"$f":"AX10","v":199.5172},null,{"$f":"AZ10","v":210.58530000000002},null,{"$f":"BB10","v":221.65339999999998},null,{"$f":"BD10","v":232.72149999999999},null,{"$f":"BF10","v":243.78959999999998},null,{"$f":"BH10","v":254.85769999999999},null,{"$f":"BJ10","v":265.92579999999998},null,{"$f":"BL10","v":276.9939},null,{"$f":"BN10","v":288.06200000000001},null,{"$f":"BP10","v":299.13009999999997},null,{"$f":"BR10","v":310.19819999999999},null,{"$f":"BT10","v":321.2663},null,{"$f":"BV10","v":332.33439999999996},null,{"$f":"BX10","v":343.40249999999997},null,{"$f":"BZ10","v":354.47059999999999},null,{"$f":"CB10","v":365.53869999999995},null,{"$f":"CD10","v":376.60680000000002},null,{"$f":"CF10","v":387.67489999999998},null,{"$f":"CH10","v":398.74299999999999},null,{"$f":"CJ10","v":409.81110000000001},null,{"$f":"CL10","v":420.87919999999997},null,{"$f":"CN10","v":431.94729999999998},null,{"$f":"CP10","v":443.0154},null,{"$f":"CR10","v":454.08349999999996},null,{"$f":"CT10","v":465.15159999999997},null,{"$f":"CV10","v":476.21969999999999},null,{"$f":"CX10","v":487.28779999999995},null,{"$f":"CZ10","v":498.35589999999996},null,{"$f":"DB10","v":509.42399999999998},null,{"$f":"DD10","v":0},null,null,null,null,null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"DN10","v":7537.1}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F11","v":66.7},null,{"$f":"H11","v":66.7},null,{"$f":"J11","v":66.7},null,{"$f":"L11","v":66.7},null,{"$f":"N11","v":66.7},null,{"$f":"P11","v":66.7},null,{"$f":"R11","v":66.7},null,{"$f":"T11","v":66.7},null,66.7,null,66.7,null,66.7,null,77.768100000000004,null,88.836200000000005,null,99.904300000000006,null,{"$f":"AH11","v":110.97239999999999},null,{"$f":"AJ11","v":122.04050000000001},null,{"$f":"AL11","v":133.1086},null,{"$f":"AN11","v":144.17669999999998},null,155.2448,null,166.31290000000001,null,{"$f":"AT11","v":177.381},null,{"$f":"AV11","v":188.44909999999999},null,{"$f":"AX11","v":199.5172},null,{"$f":"AZ11","v":210.58530000000002},null,221.65339999999998,null,232.72149999999999,null,{"$f":"BF11","v":243.78959999999998},null,{"$f":"BH11","v":254.85769999999999},null,{"$f":"BJ11","v":265.92579999999998},null,{"$f":"BL11","v":276.9939},null,288.06200000000001,null,299.13009999999997,null,{"$f":"BR11","v":310.19819999999999},null,{"$f":"BT11","v":321.2663},null,{"$f":"BV11","v":332.33439999999996},null,{"$f":"BX11","v":343.40249999999997},null,354.47059999999999,null,365.53869999999995,null,{"$f":"CD11","v":376.60680000000002},null,{"$f":"CF11","v":387.67489999999998},null,{"$f":"CH11","v":398.74299999999999},null,{"$f":"CJ11","v":409.81110000000001},null,420.87919999999997,null,431.94729999999998,null,{"$f":"CP11","v":443.0154},null,{"$f":"CR11","v":454.08349999999996},null,{"$f":"CT11","v":465.15159999999997},null,{"$f":"CV11","v":476.21969999999999},null,487.28779999999995,null,498.35589999999996,null,{"$f":"DB11","v":509.42399999999998},null,{"$f":"DD11","v":0},null,null,null,null,null,"FATURAMENTO ESGOTO 100%",null,null,null,7537.1]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F11+F12","v":133.4},null,{"$f":"H11+H12","v":133.4},null,{"$f":"J11+J12","v":133.4},null,{"$f":"L11+L12","v":133.4},null,{"$f":"N11+N12","v":133.4},null,{"$f":"P11+P12","v":133.4},null,{"$f":"R11+R12","v":133.4},null,{"$f":"T11+T12","v":133.4},null,{"$f":"V11+V12","v":133.4},null,{"$f":"X11+X12","v":133.4},null,{"$f":"Z11+Z12","v":133.4},null,{"$f":"AB11+AB12","v":155.53620000000001},null,{"$f":"AD11+AD12","v":177.67240000000001},null,{"$f":"AF11+AF12","v":199.80860000000001},null,{"$f":"AH11+AH12","v":221.94479999999999},null,{"$f":"AJ11+AJ12","v":244.08100000000002},null,{"$f":"AL11+AL12","v":266.21719999999999},null,{"$f":"AN11+AN12","v":288.35339999999997},null,{"$f":"AP11+AP12","v":310.4896},null,{"$f":"AR11+AR12","v":332.62580000000003},null,{"$f":"AT11+AT12","v":354.762},null,{"$f":"AV11+AV12","v":376.89819999999997},null,{"$f":"AX11+AX12","v":399.03440000000001},null,{"$f":"AZ11+AZ12","v":421.17060000000004},null,{"$f":"BB11+BB12","v":443.30679999999995},null,{"$f":"BD11+BD12","v":465.44299999999998},null,{"$f":"BF11+BF12","v":487.57919999999996},null,{"$f":"BH11+BH12","v":509.71539999999999},null,{"$f":"BJ11+BJ12","v":531.85159999999996},null,{"$f":"BL11+BL12","v":553.98779999999999},null,{"$f":"BN11+BN12","v":576.12400000000002},null,{"$f":"BP11+BP12","v":598.26019999999994},null,{"$f":"BR11+BR12","v":620.39639999999997},null,{"$f":"BT11+BT12","v":642.5326},null,{"$f":"BV11+BV12","v":664.66879999999992},null,{"$f":"BX11+BX12","v":686.80499999999995},null,{"$f":"BZ11+BZ12","v":708.94119999999998},null,{"$f":"CB11+CB12","v":731.0773999999999},null,{"$f":"CD11+CD12","v":753.21360000000004},null,{"$f":"CF11+CF12","v":775.34979999999996},null,{"$f":"CH11+CH12","v":797.48599999999999},null,{"$f":"CJ11+CJ12","v":819.62220000000002},null,{"$f":"CL11+CL12","v":841.75839999999994},null,{"$f":"CN11+CN12","v":863.89459999999997},null,{"$f":"CP11+CP12","v":886.0308},null,{"$f":"CR11+CR12","v":908.16699999999992},null,{"$f":"CT11+CT12","v":930.30319999999995},null,{"$f":"CV11+CV12","v":952.43939999999998},null,{"$f":"CX11+CX12","v":974.57559999999989},null,{"$f":"CZ11+CZ12","v":996.71179999999993},null,{"$f":"DB11+DB12","v":1018.848},null,{"$f":"DD11+DD12","v":0},null,null,null,null,null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"DN11+DN12","v":15074.2}]
[]
[]
[]
[null,null,{"$f":"CALCULADORA!B6","v":0},"ECONOMIAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONSUMO:",null,null,"Simulação que considera o condomínio uma única unidade.",null,null,null,null,null,null,null,null,null,null,"tabela de apoio"]
["COMERCIAL","Consumo Mínimo",null,66.7,0,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31,null,32,null,33,null,34,null,35,null,36,null,37,null,38,null,39,null,40,null,41,null,42,null,43,null,44,null,45,null,46,null,47,null,48,null,49,null,50,null,{"$f":"CALCULADORA!B4","v":0}," m³",null,null,null,"DQ18",null,null,null,null,null,null,null,null,{"$f":"DC18-DC20","v":0},"consumo menos faixa 01"]
[null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total",null,null,null,"DQ19",null,null,null,null,null,null,null,null,{"$f":"DC18-DC20-DC21","v":0},"consumo menos faixa 01 e 02"]
[null,0,10,6.67,0,{"$f":"E20*$D$20","v":0},1,{"$f":"G20*$D$20","v":6.67},2,{"$f":"I20*$D$20","v":13.34},3,{"$f":"K20*$D$20","v":20.009999999999998},4,{"$f":"M20*$D$20","v":26.68},5,{"$f":"O20*$D$20","v":33.35},6,{"$f":"Q20*$D$20","v":40.019999999999996},7,{"$f":"S20*$D$20","v":46.69},8,{"$f":"U20*$D$20","v":53.36},9,{"$f":"W20*$D$20","v":60.03},10,{"$f":"Y20*$D$20","v":66.7},10,{"$f":"AA20*$D$20","v":66.7},10,{"$f":"AC20*$D$20","v":66.7},10,{"$f":"AE20*$D$20","v":66.7},10,{"$f":"AG20*$D$20","v":66.7},10,{"$f":"AI20*$D$20","v":66.7},10,{"$f":"AK20*$D$20","v":66.7},10,{"$f":"AM20*$D$20","v":66.7},10,{"$f":"AO20*$D$20","v":66.7},10,{"$f":"AQ20*$D$20","v":66.7},10,{"$f":"AS20*$D$20","v":66.7},10,{"$f":"AU20*$D$20","v":66.7},10,{"$f":"AW20*$D$20","v":66.7},10,{"$f":"AY20*$D$20","v":66.7},10,{"$f":"BA20*$D$20","v":66.7},10,{"$f":"BC20*$D$20","v":66.7},10,{"$f":"BE20*$D$20","v":66.7},10,{"$f":"BG20*$D$20","v":66.7},10,{"$f":"BI20*$D$20","v":66.7},10,{"$f":"BK20*$D$20","v":66.7},10,{"$f":"BM20*$D$20","v":66.7},10,{"$f":"BO20*$D$20","v":66.7},10,{"$f":"BQ20*$D$20","v":66.7},10,{"$f":"BS20*$D$20","v":66.7},10,{"$f":"BU20*$D$20","v":66.7},10,{"$f":"BW20*$D$20","v":66.7},10,{"$f":"BY20*$D$20","v":66.7},10,{"$f":"CA20*$D$20","v":66.7},10,{"$f":"CC20*$D$20","v":66.7},10,{"$f":"CE20*$D$20","v":66.7},10,{"$f":"CG20*$D$20","v":66.7},10,{"$f":"CI20*$D$20","v":66.7},10,{"$f":"CK20*$D$20","v":66.7},10,{"$f":"CM20*$D$20","v":66.7},10,{"$f":"CO20*$D$20","v":66.7},10,{"$f":"CQ20*$D$20","v":66.7},10,{"$f":"CS20*$D$20","v":66.7},10,{"$f":"CU20*$D$20","v":66.7},10,{"$f":"CW20*$D$20","v":66.7},10,{"$f":"CY20*$D$20","v":66.7},10,{"$f":"DA20*$D$20","v":66.7},{"$f":"IF(C17=0,0,IF((DC18)<=10, DC18, 10))","v":0},{"$f":"DC20*$D$20","v":0},null,null,null,"DQ20",null,null,null,null,null,null,null,null,{"$f":"DC18-DC22-DC21-DC20","v":0},"consumo menos faixa 01, 02 e 03"]
[null,11,25,11.068099999999999,null,{"$f":"E21*$D$21","v":0},null,{"$f":"G21*$D$21","v":0},null,{"$f":"I21*$D$21","v":0},null,{"$f":"K21*$D$21","v":0},null,{"$f":"M21*$D$21","v":0},null,{"$f":"O21*$D$21","v":0},null,{"$f":"Q21*$D$21","v":0},null,{"$f":"S21*$D$21","v":0},null,{"$f":"U21*$D$21","v":0},null,{"$f":"W21*$D$21","v":0},null,{"$f":"Y21*$D$21","v":0},1,{"$f":"AA21*$D$21","v":11.068099999999999},2,{"$f":"AC21*$D$21","v":22.136199999999999},3,{"$f":"AE21*$D$21","v":33.204299999999996},4,{"$f":"AG21*$D$21","v":44.272399999999998},5,{"$f":"AI21*$D$21","v":55.340499999999999},6,{"$f":"AK21*$D$21","v":66.408599999999993},7,{"$f":"AM21*$D$21","v":77.476699999999994},8,{"$f":"AO21*$D$21","v":88.544799999999995},9,{"$f":"AQ21*$D$21","v":99.612899999999996},10,{"$f":"AS21*$D$21","v":110.681},11,{"$f":"AU21*$D$21","v":121.7491},12,{"$f":"AW21*$D$21","v":132.81719999999999},13,{"$f":"AY21*$D$21","v":143.8853},14,{"$f":"BA21*$D$21","v":154.95339999999999},15,{"$f":"BC21*$D$21","v":166.0215},15,{"$f":"BE21*$D$21","v":166.0215},15,{"$f":"BG21*$D$21","v":166.0215},15,{"$f":"BI21*$D$21","v":166.0215},15,{"$f":"BK21*$D$21","v":166.0215},15,{"$f":"BM21*$D$21","v":166.0215},15,{"$f":"BO21*$D$21","v":166.0215},15,{"$f":"BQ21*$D$21","v":166.0215},15,{"$f":"BS21*$D$21","v":166.0215},15,{"$f":"BU21*$D$21","v":166.0215},15,{"$f":"BW21*$D$21","v":166.0215},15,{"$f":"BY21*$D$21","v":166.0215},15,{"$f":"CA21*$D$21","v":166.0215},15,{"$f":"CC21*$D$21","v":166.0215},15,{"$f":"CE21*$D$21","v":166.0215},15,{"$f":"CG21*$D$21","v":166.0215},15,{"$f":"CI21*$D$21","v":166.0215},15,{"$f":"CK21*$D$21","v":166.0215},15,{"$f":"CM21*$D$21","v":166.0215},15,{"$f":"CO21*$D$21","v":166.0215},15,{"$f":"CQ21*$D$21","v":166.0215},15,{"$f":"CS21*$D$21","v":166.0215},15,{"$f":"CU21*$D$21","v":166.0215},15,{"$f":"CW21*$D$21","v":166.0215},15,{"$f":"CY21*$D$21","v":166.0215},15,{"$f":"DA21*$D$21","v":166.0215},{"$f":"IF(C17=0,0,IF($DC$18<10,0,IF($DQ$18>15,15,IF(15<$DQ$18>10,$DQ$18))))","v":0},{"$f":"DC21*$D$21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"consumo acima da faixa 03"]
[null,26,50,11.068099999999999,null,{"$f":"E22*$D$22","v":0},null,{"$f":"G22*$D$22","v":0},null,{"$f":"I22*$D$22","v":0},null,{"$f":"K22*$D$22","v":0},null,{"$f":"M22*$D$22","v":0},null,{"$f":"O22*$D$22","v":0},null,{"$f":"Q22*$D$22","v":0},null,{"$f":"S22*$D$22","v":0},null,{"$f":"U22*$D$22","v":0},null,{"$f":"W22*$D$22","v":0},null,{"$f":"Y22*$D$22","v":0},null,{"$f":"AA22*$D$22","v":0},null,{"$f":"AC22*$D$22","v":0},null,{"$f":"AE22*$D$22","v":0},null,{"$f":"AG22*$D$22","v":0},null,{"$f":"AI22*$D$22","v":0},null,{"$f":"AK22*$D$22","v":0},null,{"$f":"AM22*$D$22","v":0},null,{"$f":"AO22*$D$22","v":0},null,{"$f":"AQ22*$D$22","v":0},null,{"$f":"AS22*$D$22","v":0},null,{"$f":"AU22*$D$22","v":0},null,{"$f":"AW22*$D$22","v":0},null,{"$f":"AY22*$D$22","v":0},null,{"$f":"BA22*$D$22","v":0},null,{"$f":"BC22*$D$22","v":0},1,{"$f":"BE22*$D$22","v":11.068099999999999},2,{"$f":"BG22*$D$22","v":22.136199999999999},3,{"$f":"BI22*$D$22","v":33.204299999999996},4,{"$f":"BK22*$D$22","v":44.272399999999998},5,{"$f":"BM22*$D$22","v":55.340499999999999},6,{"$f":"BO22*$D$22","v":66.408599999999993},7,{"$f":"BQ22*$D$22","v":77.476699999999994},8,{"$f":"BS22*$D$22","v":88.544799999999995},9,{"$f":"BU22*$D$22","v":99.612899999999996},10,{"$f":"BW22*$D$22","v":110.681},11,{"$f":"BY22*$D$22","v":121.7491},12,{"$f":"CA22*$D$22","v":132.81719999999999},13,{"$f":"CC22*$D$22","v":143.8853},14,{"$f":"CE22*$D$22","v":154.95339999999999},15,{"$f":"CG22*$D$22","v":166.0215},16,{"$f":"CI22*$D$22","v":177.08959999999999},17,{"$f":"CK22*$D$22","v":188.15769999999998},18,{"$f":"CM22*$D$22","v":199.22579999999999},19,{"$f":"CO22*$D$22","v":210.29389999999998},20,{"$f":"CQ22*$D$22","v":221.36199999999999},21,{"$f":"CS22*$D$22","v":232.43009999999998},22,{"$f":"CU22*$D$22","v":243.4982},23,{"$f":"CW22*$D$22","v":254.56629999999998},24,{"$f":"CY22*$D$22","v":265.63439999999997},25,{"$f":"DA22*$D$22","v":276.70249999999999},{"$f":"IF(C17=0,0,IF($DC$18<10,0,IF($DQ$19>25,25,IF(25<$DQ$19>15,$DQ$19))))","v":0},{"$f":"DC22*$D$22","v":0}]
[null,51,9999,13.9229,null,{"$f":"E23*$D$23","v":0},null,{"$f":"G23*$D$23","v":0},null,{"$f":"I23*$D$23","v":0},null,{"$f":"K23*$D$23","v":0},null,{"$f":"M23*$D$23","v":0},null,{"$f":"O23*$D$23","v":0},null,{"$f":"Q23*$D$23","v":0},null,{"$f":"S23*$D$23","v":0},null,{"$f":"U23*$D$23","v":0},null,{"$f":"W23*$D$23","v":0},null,{"$f":"Y23*$D$23","v":0},null,{"$f":"AA23*$D$23","v":0},null,{"$f":"AC23*$D$23","v":0},null,{"$f":"AE23*$D$23","v":0},null,{"$f":"AG23*$D$23","v":0},null,{"$f":"AI23*$D$23","v":0},null,{"$f":"AK23*$D$23","v":0},null,{"$f":"AM23*$D$23","v":0},null,{"$f":"AO23*$D$23","v":0},null,{"$f":"AQ23*$D$23","v":0},null,{"$f":"AS23*$D$23","v":0},null,{"$f":"AU23*$D$23","v":0},null,{"$f":"AW23*$D$23","v":0},null,{"$f":"AY23*$D$23","v":0},null,{"$f":"BA23*$D$23","v":0},null,{"$f":"BC23*$D$23","v":0},null,{"$f":"BE23*$D$23","v":0},null,{"$f":"BG23*$D$23","v":0},null,{"$f":"BI23*$D$23","v":0},null,{"$f":"BK23*$D$23","v":0},null,{"$f":"BM23*$D$23","v":0},null,{"$f":"BO23*$D$23","v":0},null,{"$f":"BQ23*$D$23","v":0},null,{"$f":"BS23*$D$23","v":0},null,{"$f":"BU23*$D$23","v":0},null,{"$f":"BW23*$D$23","v":0},null,{"$f":"BY23*$D$23","v":0},null,{"$f":"CA23*$D$23","v":0},null,{"$f":"CC23*$D$23","v":0},null,{"$f":"CE23*$D$23","v":0},null,{"$f":"CG23*$D$23","v":0},null,{"$f":"CI23*$D$23","v":0},null,{"$f":"CK23*$D$23","v":0},null,{"$f":"CM23*$D$23","v":0},null,{"$f":"CO23*$D$23","v":0},null,{"$f":"CQ23*$D$23","v":0},null,{"$f":"CS23*$D$23","v":0},null,{"$f":"CU23*$D$23","v":0},null,{"$f":"CW23*$D$23","v":0},null,{"$f":"CY23*$D$23","v":0},null,{"$f":"DA23*$D$23","v":0},{"$f":"IF(C17=0,0,IF($DQ$20>=0,$DQ$20))","v":0},{"$f":"DC23*$D$23","v":0}]
[null,"SUBTOTAL",null,null,null,{"$f":"SUM(F20:F23)","v":0},null,{"$f":"SUM(H20:H23)","v":6.67},null,{"$f":"SUM(J20:J23)","v":13.34},null,{"$f":"SUM(L20:L23)","v":20.009999999999998},null,{"$f":"SUM(N20:N23)","v":26.68},null,{"$f":"SUM(P20:P23)","v":33.35},null,{"$f":"SUM(R20:R23)","v":40.019999999999996},null,{"$f":"SUM(T20:T23)","v":46.69},null,{"$f":"SUM(V20:V23)","v":53.36},null,{"$f":"SUM(X20:X23)","v":60.03},null,{"$f":"SUM(Z20:Z23)","v":66.7},null,{"$f":"SUM(AB20:AB23)","v":77.768100000000004},null,{"$f":"SUM(AD20:AD23)","v":88.836200000000005},null,{"$f":"SUM(AF20:AF23)","v":99.904300000000006},null,{"$f":"SUM(AH20:AH23)","v":110.97239999999999},null,{"$f":"SUM(AJ20:AJ23)","v":122.04050000000001},null,{"$f":"SUM(AL20:AL23)","v":133.1086},null,{"$f":"SUM(AN20:AN23)","v":144.17669999999998},null,{"$f":"SUM(AP20:AP23)","v":155.2448},null,{"$f":"SUM(AR20:AR23)","v":166.31290000000001},null,{"$f":"SUM(AT20:AT23)","v":177.381},null,{"$f":"SUM(AV20:AV23)","v":188.44909999999999},null,{"$f":"SUM(AX20:AX23)","v":199.5172},null,{"$f":"SUM(AZ20:AZ23)","v":210.58530000000002},null,{"$f":"SUM(BB20:BB23)","v":221.65339999999998},null,{"$f":"SUM(BD20:BD23)","v":232.72149999999999},null,{"$f":"SUM(BF20:BF23)","v":243.78959999999998},null,{"$f":"SUM(BH20:BH23)","v":254.85769999999999},null,{"$f":"SUM(BJ20:BJ23)","v":265.92579999999998},null,{"$f":"SUM(BL20:BL23)","v":276.9939},null,{"$f":"SUM(BN20:BN23)","v":288.06200000000001},null,{"$f":"SUM(BP20:BP23)","v":299.13009999999997},null,{"$f":"SUM(BR20:BR23)","v":310.19819999999999},null,{"$f":"SUM(BT20:BT23)","v":321.2663},null,{"$f":"SUM(BV20:BV23)","v":332.33439999999996},null,{"$f":"SUM(BX20:BX23)","v":343.40249999999997},null,{"$f":"SUM(BZ20:BZ23)","v":354.47059999999999},null,{"$f":"SUM(CB20:CB23)","v":365.53869999999995},null,{"$f":"SUM(CD20:CD23)","v":376.60680000000002},null,{"$f":"SUM(CF20:CF23)","v":387.67489999999998},null,{"$f":"SUM(CH20:CH23)","v":398.74299999999999},null,409.81110000000001,null,420.87919999999997,null,431.94729999999998,null,443.0154,null,454.08349999999996,null,465.15159999999997,null,{"$f":"SUM(CV20:CV23)","v":476.21969999999999},null,{"$f":"SUM(CX20:CX23)","v":487.28779999999995},null,{"$f":"SUM(CZ20:CZ23)","v":498.35589999999996},null,{"$f":"SUM(DB20:DB23)","v":509.42399999999998},null,0]
[null,"TOTAL",null,null,null,{"$f":"IF((F24<=$D$18),$D$18,F24)","v":66.7},null,{"$f":"IF((H24<=$D$18),$D$18,H24)","v":66.7},null,{"$f":"IF((J24<=$D$18),$D$18,J24)","v":66.7},null,{"$f":"IF((L24<=$D$18),$D$18,L24)","v":66.7},null,{"$f":"IF((N24<=$D$18),$D$18,N24)","v":66.7},null,{"$f":"IF((P24<=$D$18),$D$18,P24)","v":66.7},null,{"$f":"IF((R24<=$D$18),$D$18,R24)","v":66.7},null,{"$f":"IF((T24<=$D$18),$D$18,T24)","v":66.7},null,{"$f":"IF((V24<=$D$18),$D$18,V24)","v":66.7},null,{"$f":"IF((X24<=$D$18),$D$18,X24)","v":66.7},null,{"$f":"IF((Z24<=$D$18),$D$18,Z24)","v":66.7},null,{"$f":"IF((AB24<=$D$18),$D$18,AB24)","v":77.768100000000004},null,{"$f":"IF((AD24<=$D$18),$D$18,AD24)","v":88.836200000000005},null,{"$f":"IF((AF24<=$D$18),$D$18,AF24)","v":99.904300000000006},null,{"$f":"IF((AH24<=$D$18),$D$18,AH24)","v":110.97239999999999},null,{"$f":"IF((AJ24<=$D$18),$D$18,AJ24)","v":122.04050000000001},null,{"$f":"IF((AL24<=$D$18),$D$18,AL24)","v":133.1086},null,{"$f":"IF((AN24<=$D$18),$D$18,AN24)","v":144.17669999999998},null,{"$f":"IF((AP24<=$D$18),$D$18,AP24)","v":155.2448},null,{"$f":"IF((AR24<=$D$18),$D$18,AR24)","v":166.31290000000001},null,{"$f":"IF((AT24<=$D$18),$D$18,AT24)","v":177.381},null,{"$f":"IF((AV24<=$D$18),$D$18,AV24)","v":188.44909999999999},null,{"$f":"IF((AX24<=$D$18),$D$18,AX24)","v":199.5172},null,{"$f":"IF((AZ24<=$D$18),$D$18,AZ24)","v":210.58530000000002},null,{"$f":"IF((BB24<=$D$18),$D$18,BB24)","v":221.65339999999998},null,{"$f":"IF((BD24<=$D$18),$D$18,BD24)","v":232.72149999999999},null,{"$f":"IF((BF24<=$D$18),$D$18,BF24)","v":243.78959999999998},null,{"$f":"IF((BH24<=$D$18),$D$18,BH24)","v":254.85769999999999},null,{"$f":"IF((BJ24<=$D$18),$D$18,BJ24)","v":265.92579999999998},null,{"$f":"IF((BL24<=$D$18),$D$18,BL24)","v":276.9939},null,{"$f":"IF((BN24<=$D$18),$D$18,BN24)","v":288.06200000000001},null,{"$f":"IF((BP24<=$D$18),$D$18,BP24)","v":299.13009999999997},null,{"$f":"IF((BR24<=$D$18),$D$18,BR24)","v":310.19819999999999},null,{"$f":"IF((BT24<=$D$18),$D$18,BT24)","v":321.2663},null,{"$f":"IF((BV24<=$D$18),$D$18,BV24)","v":332.33439999999996},null,{"$f":"IF((BX24<=$D$18),$D$18,BX24)","v":343.40249999999997},null,{"$f":"IF((BZ24<=$D$18),$D$18,BZ24)","v":354.47059999999999},null,{"$f":"IF((CB24<=$D$18),$D$18,CB24)","v":365.53869999999995},null,{"$f":"IF((CD24<=$D$18),$D$18,CD24)","v":376.60680000000002},null,{"$f":"IF((CF24<=$D$18),$D$18,CF24)","v":387.67489999999998},null,{"$f":"IF((CH24<=$D$18),$D$18,CH24)","v":398.74299999999999},null,409.81110000000001,null,420.87919999999997,null,431.94729999999998,null,443.0154,null,454.08349999999996,null,465.15159999999997,null,{"$f":"IF((CV24<=$D$18),$D$18,CV24)","v":476.21969999999999},null,{"$f":"IF((CX24<=$D$18),$D$18,CX24)","v":487.28779999999995},null,{"$f":"IF((CZ24<=$D$18),$D$18,CZ24)","v":498.35589999999996},null,{"$f":"IF((DB24<=$D$18),$D$18,DB24)","v":509.42399999999998},null,{"$f":"IF(C17=0,0,IF((DD24<=$D$18),$D$18,IF(DD24>D18,DD24)))","v":0}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F25","v":66.7},null,{"$f":"H25","v":66.7},null,{"$f":"J25","v":66.7},null,{"$f":"L25","v":66.7},null,{"$f":"N25","v":66.7},null,{"$f":"P25","v":66.7},null,{"$f":"R25","v":66.7},null,{"$f":"T25","v":66.7},null,{"$f":"V25","v":66.7},null,{"$f":"X25","v":66.7},null,{"$f":"Z25","v":66.7},null,{"$f":"AB25","v":77.768100000000004},null,{"$f":"AD25","v":88.836200000000005},null,{"$f":"AF25","v":99.904300000000006},null,{"$f":"AH25","v":110.97239999999999},null,{"$f":"AJ25","v":122.04050000000001},null,{"$f":"AL25","v":133.1086},null,{"$f":"AN25","v":144.17669999999998},null,{"$f":"AP25","v":155.2448},null,{"$f":"AR25","v":166.31290000000001},null,{"$f":"AT25","v":177.381},null,{"$f":"AV25","v":188.44909999999999},null,{"$f":"AX25","v":199.5172},null,{"$f":"AZ25","v":210.58530000000002},null,{"$f":"BB25","v":221.65339999999998},null,{"$f":"BD25","v":232.72149999999999},null,{"$f":"BF25","v":243.78959999999998},null,{"$f":"BH25","v":254.85769999999999},null,{"$f":"BJ25","v":265.92579999999998},null,{"$f":"BL25","v":276.9939},null,{"$f":"BN25","v":288.06200000000001},null,{"$f":"BP25","v":299.13009999999997},null,{"$f":"BR25","v":310.19819999999999},null,{"$f":"BT25","v":321.2663},null,{"$f":"BV25","v":332.33439999999996},null,{"$f":"BX25","v":343.40249999999997},null,{"$f":"BZ25","v":354.47059999999999},null,{"$f":"CB25","v":365.53869999999995},null,{"$f":"CD25","v":376.60680000000002},null,{"$f":"CF25","v":387.67489999999998},null,{"$f":"CH25","v":398.74299999999999},null,409.81110000000001,null,420.87919999999997,null,431.94729999999998,null,443.0154,null,454.08349999999996,null,465.15159999999997,null,{"$f":"CV25","v":476.21969999999999},null,{"$f":"CX25","v":487.28779999999995},null,{"$f":"CZ25","v":498.35589999999996},null,{"$f":"DB25","v":509.42399999999998},null,0]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F26","v":66.7},null,{"$f":"H26","v":66.7},null,{"$f":"J26","v":66.7},null,{"$f":"L26","v":66.7},null,{"$f":"N26","v":66.7},null,{"$f":"P26","v":66.7},null,{"$f":"R26","v":66.7},null,{"$f":"T26","v":66.7},null,66.7,null,66.7,null,66.7,null,77.768100000000004,null,88.836200000000005,null,99.904300000000006,null,110.97239999999999,null,122.04050000000001,null,133.1086,null,144.17669999999998,null,155.2448,null,166.31290000000001,null,177.381,null,188.44909999999999,null,199.5172,null,210.58530000000002,null,221.65339999999998,null,232.72149999999999,null,243.78959999999998,null,254.85769999999999,null,265.92579999999998,null,276.9939,null,288.06200000000001,null,299.13009999999997,null,310.19819999999999,null,321.2663,null,332.33439999999996,null,343.40249999999997,null,354.47059999999999,null,365.53869999999995,null,376.60680000000002,null,387.67489999999998,null,398.74299999999999,null,409.81110000000001,null,{"$f":"CL26","v":420.87919999999997},null,{"$f":"CN26","v":431.94729999999998},null,443.0154,null,454.08349999999996,null,465.15159999999997,null,476.21969999999999,null,{"$f":"CX26","v":487.28779999999995},null,{"$f":"CZ26","v":498.35589999999996},null,509.42399999999998,null,0]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F26+F27","v":133.4},null,{"$f":"H26+H27","v":133.4},null,{"$f":"J26+J27","v":133.4},null,{"$f":"L26+L27","v":133.4},null,{"$f":"N26+N27","v":133.4},null,{"$f":"P26+P27","v":133.4},null,{"$f":"R26+R27","v":133.4},null,{"$f":"T26+T27","v":133.4},null,{"$f":"V26+V27","v":133.4},null,{"$f":"X26+X27","v":133.4},null,{"$f":"Z26+Z27","v":133.4},null,{"$f":"AB26+AB27","v":155.53620000000001},null,{"$f":"AD26+AD27","v":177.67240000000001},null,{"$f":"AF26+AF27","v":199.80860000000001},null,{"$f":"AH26+AH27","v":221.94479999999999},null,{"$f":"AJ26+AJ27","v":244.08100000000002},null,{"$f":"AL26+AL27","v":266.21719999999999},null,{"$f":"AN26+AN27","v":288.35339999999997},null,{"$f":"AP26+AP27","v":310.4896},null,{"$f":"AR26+AR27","v":332.62580000000003},null,{"$f":"AT26+AT27","v":354.762},null,{"$f":"AV26+AV27","v":376.89819999999997},null,{"$f":"AX26+AX27","v":399.03440000000001},null,{"$f":"AZ26+AZ27","v":421.17060000000004},null,{"$f":"BB26+BB27","v":443.30679999999995},null,{"$f":"BD26+BD27","v":465.44299999999998},null,{"$f":"BF26+BF27","v":487.57919999999996},null,{"$f":"BH26+BH27","v":509.71539999999999},null,{"$f":"BJ26+BJ27","v":531.85159999999996},null,{"$f":"BL26+BL27","v":553.98779999999999},null,{"$f":"BN26+BN27","v":576.12400000000002},null,{"$f":"BP26+BP27","v":598.26019999999994},null,{"$f":"BR26+BR27","v":620.39639999999997},null,{"$f":"BT26+BT27","v":642.5326},null,{"$f":"BV26+BV27","v":664.66879999999992},null,{"$f":"BX26+BX27","v":686.80499999999995},null,{"$f":"BZ26+BZ27","v":708.94119999999998},null,{"$f":"CB26+CB27","v":731.0773999999999},null,{"$f":"CD26+CD27","v":753.21360000000004},null,{"$f":"CF26+CF27","v":775.34979999999996},null,{"$f":"CH26+CH27","v":797.48599999999999},null,819.62220000000002,null,841.75839999999994,null,863.89459999999997,null,886.0308,null,908.16699999999992,null,930.30319999999995,null,{"$f":"CV26+CV27","v":952.43939999999998},null,{"$f":"CX26+CX27","v":974.57559999999989},null,{"$f":"CZ26+CZ27","v":996.71179999999993},null,{"$f":"DB26+DB27","v":1018.848},null,0,null,null,null,null,{"$f":"DD28-DD13","v":0}]
[]
[]
[]
[]
[1,"ECONOMIA",{"$f":"CALCULADORA!B6","v":0},"UNIDADES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONSUMO:",null,null,"Simulação nova estrutura tarifária"]
["COMERCIAL","TFDI com RTP",null,29.49,0,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31,null,32,null,33,null,34,null,35,null,36,null,37,null,38,null,39,null,40,null,41,null,42,null,43,null,44,null,45,null,46,null,47,null,48,null,49,null,50,null,{"$f":"CALCULADORA!B4","v":0}," m³"]
[null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total",null,null,null,null,null,null,null,null,null,null,null,null,"tabela de apoio"]
[null,0,10,4.34,0,{"$f":"E36*$D$20","v":0},1,{"$f":"G36*$D$20","v":6.67},2,{"$f":"I36*$D$20","v":13.34},3,{"$f":"K36*$D$20","v":20.009999999999998},4,{"$f":"M36*$D$20","v":26.68},5,{"$f":"O36*$D$20","v":33.35},6,{"$f":"Q36*$D$20","v":40.019999999999996},7,{"$f":"S36*$D$20","v":46.69},8,{"$f":"U36*$D$20","v":53.36},9,{"$f":"W36*$D$20","v":60.03},10,{"$f":"Y36*$D$20","v":66.7},10,{"$f":"AA36*$D$20","v":66.7},10,{"$f":"AC36*$D$20","v":66.7},10,{"$f":"AE36*$D$20","v":66.7},10,{"$f":"AG36*$D$20","v":66.7},10,{"$f":"AI36*$D$20","v":66.7},10,{"$f":"AK36*$D$20","v":66.7},10,{"$f":"AM36*$D$20","v":66.7},10,{"$f":"AO36*$D$20","v":66.7},10,{"$f":"AQ36*$D$20","v":66.7},10,{"$f":"AS36*$D$20","v":66.7},10,{"$f":"AU36*$D$20","v":66.7},10,{"$f":"AW36*$D$20","v":66.7},10,{"$f":"AY36*$D$20","v":66.7},10,{"$f":"BA36*$D$20","v":66.7},10,{"$f":"BC36*$D$20","v":66.7},10,{"$f":"BE36*$D$20","v":66.7},10,{"$f":"BG36*$D$20","v":66.7},10,{"$f":"BI36*$D$20","v":66.7},10,{"$f":"BK36*$D$20","v":66.7},10,{"$f":"BM36*$D$20","v":66.7},10,{"$f":"BO36*$D$20","v":66.7},10,{"$f":"BQ36*$D$20","v":66.7},10,{"$f":"BS36*$D$20","v":66.7},10,{"$f":"BU36*$D$20","v":66.7},10,{"$f":"BW36*$D$20","v":66.7},10,{"$f":"BY36*$D$20","v":66.7},10,{"$f":"CA36*$D$20","v":66.7},10,{"$f":"CC36*$D$20","v":66.7},10,{"$f":"CE36*$D$20","v":66.7},10,{"$f":"CG36*$D$20","v":66.7},10,{"$f":"CI36*$D$20","v":66.7},10,{"$f":"CK36*$D$20","v":66.7},10,{"$f":"CM36*$D$20","v":66.7},10,{"$f":"CO36*$D$20","v":66.7},10,{"$f":"CQ36*$D$20","v":66.7},10,{"$f":"CS36*$D$20","v":66.7},10,{"$f":"CU36*$D$20","v":66.7},10,{"$f":"CW36*$D$20","v":66.7},10,{"$f":"CY36*$D$20","v":66.7},10,{"$f":"DA36*$D$20","v":66.7},{"$f":"IF((DC34)<=DQ36, DC34,DQ36)","v":0},{"$f":"DC36*$D$36","v":0},null,null,null,"DQ 36",null,null,null,null,null,null,null,null,{"$f":"10*C33","v":0},"consumo faixa 01"]
[null,11,25,12.18,null,{"$f":"E37*$D$21","v":0},null,{"$f":"G37*$D$21","v":0},null,{"$f":"I37*$D$21","v":0},null,{"$f":"K37*$D$21","v":0},null,{"$f":"M37*$D$21","v":0},null,{"$f":"O37*$D$21","v":0},null,{"$f":"Q37*$D$21","v":0},null,{"$f":"S37*$D$21","v":0},null,{"$f":"U37*$D$21","v":0},null,{"$f":"W37*$D$21","v":0},null,{"$f":"Y37*$D$21","v":0},1,{"$f":"AA37*$D$21","v":11.068099999999999},2,{"$f":"AC37*$D$21","v":22.136199999999999},3,{"$f":"AE37*$D$21","v":33.204299999999996},4,{"$f":"AG37*$D$21","v":44.272399999999998},5,{"$f":"AI37*$D$21","v":55.340499999999999},6,{"$f":"AK37*$D$21","v":66.408599999999993},7,{"$f":"AM37*$D$21","v":77.476699999999994},8,{"$f":"AO37*$D$21","v":88.544799999999995},9,{"$f":"AQ37*$D$21","v":99.612899999999996},10,{"$f":"AS37*$D$21","v":110.681},11,{"$f":"AU37*$D$21","v":121.7491},12,{"$f":"AW37*$D$21","v":132.81719999999999},13,{"$f":"AY37*$D$21","v":143.8853},14,{"$f":"BA37*$D$21","v":154.95339999999999},15,{"$f":"BC37*$D$21","v":166.0215},15,{"$f":"BE37*$D$21","v":166.0215},15,{"$f":"BG37*$D$21","v":166.0215},15,{"$f":"BI37*$D$21","v":166.0215},15,{"$f":"BK37*$D$21","v":166.0215},15,{"$f":"BM37*$D$21","v":166.0215},15,{"$f":"BO37*$D$21","v":166.0215},15,{"$f":"BQ37*$D$21","v":166.0215},15,{"$f":"BS37*$D$21","v":166.0215},15,{"$f":"BU37*$D$21","v":166.0215},15,{"$f":"BW37*$D$21","v":166.0215},15,{"$f":"BY37*$D$21","v":166.0215},15,{"$f":"CA37*$D$21","v":166.0215},15,{"$f":"CC37*$D$21","v":166.0215},15,{"$f":"CE37*$D$21","v":166.0215},15,{"$f":"CG37*$D$21","v":166.0215},15,{"$f":"CI37*$D$21","v":166.0215},15,{"$f":"CK37*$D$21","v":166.0215},15,{"$f":"CM37*$D$21","v":166.0215},15,{"$f":"CO37*$D$21","v":166.0215},15,{"$f":"CQ37*$D$21","v":166.0215},15,{"$f":"CS37*$D$21","v":166.0215},15,{"$f":"CU37*$D$21","v":166.0215},15,{"$f":"CW37*$D$21","v":166.0215},15,{"$f":"CY37*$D$21","v":166.0215},15,{"$f":"DA37*$D$21","v":166.0215},{"$f":"IF($DC$34<$DQ$36,0,IF($DC$34>($DQ$36+$DQ$37),$DQ$37,IF($DQ$36<$DC$34>$DQ$37,$DC$34-$DQ$36)))","v":0},{"$f":"DC37*$D$37","v":0},null,null,null,"DQ37",null,null,null,null,null,null,null,null,{"$f":"15*C33","v":0},"consumo faixa 02"]
[null,26,50,12.18,null,{"$f":"E38*$D$22","v":0},null,{"$f":"G38*$D$22","v":0},null,{"$f":"I38*$D$22","v":0},null,{"$f":"K38*$D$22","v":0},null,{"$f":"M38*$D$22","v":0},null,{"$f":"O38*$D$22","v":0},null,{"$f":"Q38*$D$22","v":0},null,{"$f":"S38*$D$22","v":0},null,{"$f":"U38*$D$22","v":0},null,{"$f":"W38*$D$22","v":0},null,{"$f":"Y38*$D$22","v":0},null,{"$f":"AA38*$D$22","v":0},null,{"$f":"AC38*$D$22","v":0},null,{"$f":"AE38*$D$22","v":0},null,{"$f":"AG38*$D$22","v":0},null,{"$f":"AI38*$D$22","v":0},null,{"$f":"AK38*$D$22","v":0},null,{"$f":"AM38*$D$22","v":0},null,{"$f":"AO38*$D$22","v":0},null,{"$f":"AQ38*$D$22","v":0},null,{"$f":"AS38*$D$22","v":0},null,{"$f":"AU38*$D$22","v":0},null,{"$f":"AW38*$D$22","v":0},null,{"$f":"AY38*$D$22","v":0},null,{"$f":"BA38*$D$22","v":0},null,{"$f":"BC38*$D$22","v":0},1,{"$f":"BE38*$D$22","v":11.068099999999999},2,{"$f":"BG38*$D$22","v":22.136199999999999},3,{"$f":"BI38*$D$22","v":33.204299999999996},4,{"$f":"BK38*$D$22","v":44.272399999999998},5,{"$f":"BM38*$D$22","v":55.340499999999999},6,{"$f":"BO38*$D$22","v":66.408599999999993},7,{"$f":"BQ38*$D$22","v":77.476699999999994},8,{"$f":"BS38*$D$22","v":88.544799999999995},9,{"$f":"BU38*$D$22","v":99.612899999999996},10,{"$f":"BW38*$D$22","v":110.681},11,{"$f":"BY38*$D$22","v":121.7491},12,{"$f":"CA38*$D$22","v":132.81719999999999},13,{"$f":"CC38*$D$22","v":143.8853},14,{"$f":"CE38*$D$22","v":154.95339999999999},15,{"$f":"CG38*$D$22","v":166.0215},16,{"$f":"CI38*$D$22","v":177.08959999999999},17,{"$f":"CK38*$D$22","v":188.15769999999998},18,{"$f":"CM38*$D$22","v":199.22579999999999},19,{"$f":"CO38*$D$22","v":210.29389999999998},20,{"$f":"CQ38*$D$22","v":221.36199999999999},21,{"$f":"CS38*$D$22","v":232.43009999999998},22,{"$f":"CU38*$D$22","v":243.4982},23,{"$f":"CW38*$D$22","v":254.56629999999998},24,{"$f":"CY38*$D$22","v":265.63439999999997},25,{"$f":"DA38*$D$22","v":276.70249999999999},{"$f":"IF($DC$34<=($DQ$36+$DQ$37),0,IF($DC$34>($DQ$36+$DQ$37+DQ38),DQ38,IF($DC$34>($DQ$36+$DQ$37),$DC$34-($DC$36+$DC$37))))","v":0},{"$f":"DC38*$D$38","v":0},null,null,null,"DQ38",null,null,null,null,null,null,null,null,{"$f":"25*C33","v":0},"consumo faixa 03"]
[null,51,9999,15.32,null,{"$f":"E39*$D$23","v":0},null,{"$f":"G39*$D$23","v":0},null,{"$f":"I39*$D$23","v":0},null,{"$f":"K39*$D$23","v":0},null,{"$f":"M39*$D$23","v":0},null,{"$f":"O39*$D$23","v":0},null,{"$f":"Q39*$D$23","v":0},null,{"$f":"S39*$D$23","v":0},null,{"$f":"U39*$D$23","v":0},null,{"$f":"W39*$D$23","v":0},null,{"$f":"Y39*$D$23","v":0},null,{"$f":"AA39*$D$23","v":0},null,{"$f":"AC39*$D$23","v":0},null,{"$f":"AE39*$D$23","v":0},null,{"$f":"AG39*$D$23","v":0},null,{"$f":"AI39*$D$23","v":0},null,{"$f":"AK39*$D$23","v":0},null,{"$f":"AM39*$D$23","v":0},null,{"$f":"AO39*$D$23","v":0},null,{"$f":"AQ39*$D$23","v":0},null,{"$f":"AS39*$D$23","v":0},null,{"$f":"AU39*$D$23","v":0},null,{"$f":"AW39*$D$23","v":0},null,{"$f":"AY39*$D$23","v":0},null,{"$f":"BA39*$D$23","v":0},null,{"$f":"BC39*$D$23","v":0},null,{"$f":"BE39*$D$23","v":0},null,{"$f":"BG39*$D$23","v":0},null,{"$f":"BI39*$D$23","v":0},null,{"$f":"BK39*$D$23","v":0},null,{"$f":"BM39*$D$23","v":0},null,{"$f":"BO39*$D$23","v":0},null,{"$f":"BQ39*$D$23","v":0},null,{"$f":"BS39*$D$23","v":0},null,{"$f":"BU39*$D$23","v":0},null,{"$f":"BW39*$D$23","v":0},null,{"$f":"BY39*$D$23","v":0},null,{"$f":"CA39*$D$23","v":0},null,{"$f":"CC39*$D$23","v":0},null,{"$f":"CE39*$D$23","v":0},null,{"$f":"CG39*$D$23","v":0},null,{"$f":"CI39*$D$23","v":0},null,{"$f":"CK39*$D$23","v":0},null,{"$f":"CM39*$D$23","v":0},null,{"$f":"CO39*$D$23","v":0},null,{"$f":"CQ39*$D$23","v":0},null,{"$f":"CS39*$D$23","v":0},null,{"$f":"CU39*$D$23","v":0},null,{"$f":"CW39*$D$23","v":0},null,{"$f":"CY39*$D$23","v":0},null,{"$f":"DA39*$D$23","v":0},{"$f":"IF(C33=0,0,IF($DQ$39>=0,$DQ$39,0))","v":0},{"$f":"DC39*$D$39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((DC34-DQ36-DQ37-DQ38)<=0, 0,(DC34-DQ36-DQ37-DQ38))","v":0},"consumo acima da faixa 03"]
[null,"TOTAL CONSUMO",null,null,null,{"$f":"SUM(F36:F39)","v":0},null,{"$f":"SUM(H36:H39)","v":6.67},null,{"$f":"SUM(J36:J39)","v":13.34},null,{"$f":"SUM(L36:L39)","v":20.009999999999998},null,{"$f":"SUM(N36:N39)","v":26.68},null,{"$f":"SUM(P36:P39)","v":33.35},null,{"$f":"SUM(R36:R39)","v":40.019999999999996},null,{"$f":"SUM(T36:T39)","v":46.69},null,{"$f":"SUM(V36:V39)","v":53.36},null,{"$f":"SUM(X36:X39)","v":60.03},null,{"$f":"SUM(Z36:Z39)","v":66.7},null,{"$f":"SUM(AB36:AB39)","v":77.768100000000004},null,{"$f":"SUM(AD36:AD39)","v":88.836200000000005},null,{"$f":"SUM(AF36:AF39)","v":99.904300000000006},null,{"$f":"SUM(AH36:AH39)","v":110.97239999999999},null,{"$f":"SUM(AJ36:AJ39)","v":122.04050000000001},null,{"$f":"SUM(AL36:AL39)","v":133.1086},null,{"$f":"SUM(AN36:AN39)","v":144.17669999999998},null,{"$f":"SUM(AP36:AP39)","v":155.2448},null,{"$f":"SUM(AR36:AR39)","v":166.31290000000001},null,{"$f":"SUM(AT36:AT39)","v":177.381},null,{"$f":"SUM(AV36:AV39)","v":188.44909999999999},null,{"$f":"SUM(AX36:AX39)","v":199.5172},null,{"$f":"SUM(AZ36:AZ39)","v":210.58530000000002},null,{"$f":"SUM(BB36:BB39)","v":221.65339999999998},null,{"$f":"SUM(BD36:BD39)","v":232.72149999999999},null,{"$f":"SUM(BF36:BF39)","v":243.78959999999998},null,{"$f":"SUM(BH36:BH39)","v":254.85769999999999},null,{"$f":"SUM(BJ36:BJ39)","v":265.92579999999998},null,{"$f":"SUM(BL36:BL39)","v":276.9939},null,{"$f":"SUM(BN36:BN39)","v":288.06200000000001},null,{"$f":"SUM(BP36:BP39)","v":299.13009999999997},null,{"$f":"SUM(BR36:BR39)","v":310.19819999999999},null,{"$f":"SUM(BT36:BT39)","v":321.2663},null,{"$f":"SUM(BV36:BV39)","v":332.33439999999996},null,{"$f":"SUM(BX36:BX39)","v":343.40249999999997},null,{"$f":"SUM(BZ36:BZ39)","v":354.47059999999999},null,{"$f":"SUM(CB36:CB39)","v":365.53869999999995},null,{"$f":"SUM(CD36:CD39)","v":376.60680000000002},null,{"$f":"SUM(CF36:CF39)","v":387.67489999999998},null,{"$f":"SUM(CH36:CH39)","v":398.74299999999999},null,{"$f":"SUM(CJ36:CJ39)","v":409.81110000000001},null,{"$f":"SUM(CL36:CL39)","v":420.87919999999997},null,{"$f":"SUM(CN36:CN39)","v":431.94729999999998},null,{"$f":"SUM(CP36:CP39)","v":443.0154},null,{"$f":"SUM(CR36:CR39)","v":454.08349999999996},null,{"$f":"SUM(CT36:CT39)","v":465.15159999999997},null,{"$f":"SUM(CV36:CV39)","v":476.21969999999999},null,{"$f":"SUM(CX36:CX39)","v":487.28779999999995},null,{"$f":"SUM(CZ36:CZ39)","v":498.35589999999996},null,{"$f":"SUM(DB36:DB39)","v":509.42399999999998},null,{"$f":"SUM(DD36:DD39)","v":0}]
[null,"TOTAL TFDI UNIDADES",null,null,null,{"$f":"IF((F40<=$D$18),$D$18,F40)","v":66.7},null,{"$f":"IF((H40<=$D$18),$D$18,H40)","v":66.7},null,{"$f":"IF((J40<=$D$18),$D$18,J40)","v":66.7},null,{"$f":"IF((L40<=$D$18),$D$18,L40)","v":66.7},null,{"$f":"IF((N40<=$D$18),$D$18,N40)","v":66.7},null,{"$f":"IF((P40<=$D$18),$D$18,P40)","v":66.7},null,{"$f":"IF((R40<=$D$18),$D$18,R40)","v":66.7},null,{"$f":"IF((T40<=$D$18),$D$18,T40)","v":66.7},null,{"$f":"IF((V40<=$D$18),$D$18,V40)","v":66.7},null,{"$f":"IF((X40<=$D$18),$D$18,X40)","v":66.7},null,{"$f":"IF((Z40<=$D$18),$D$18,Z40)","v":66.7},null,{"$f":"IF((AB40<=$D$18),$D$18,AB40)","v":77.768100000000004},null,{"$f":"IF((AD40<=$D$18),$D$18,AD40)","v":88.836200000000005},null,{"$f":"IF((AF40<=$D$18),$D$18,AF40)","v":99.904300000000006},null,{"$f":"IF((AH40<=$D$18),$D$18,AH40)","v":110.97239999999999},null,{"$f":"IF((AJ40<=$D$18),$D$18,AJ40)","v":122.04050000000001},null,{"$f":"IF((AL40<=$D$18),$D$18,AL40)","v":133.1086},null,{"$f":"IF((AN40<=$D$18),$D$18,AN40)","v":144.17669999999998},null,{"$f":"IF((AP40<=$D$18),$D$18,AP40)","v":155.2448},null,{"$f":"IF((AR40<=$D$18),$D$18,AR40)","v":166.31290000000001},null,{"$f":"IF((AT40<=$D$18),$D$18,AT40)","v":177.381},null,{"$f":"IF((AV40<=$D$18),$D$18,AV40)","v":188.44909999999999},null,{"$f":"IF((AX40<=$D$18),$D$18,AX40)","v":199.5172},null,{"$f":"IF((AZ40<=$D$18),$D$18,AZ40)","v":210.58530000000002},null,{"$f":"IF((BB40<=$D$18),$D$18,BB40)","v":221.65339999999998},null,{"$f":"IF((BD40<=$D$18),$D$18,BD40)","v":232.72149999999999},null,{"$f":"IF((BF40<=$D$18),$D$18,BF40)","v":243.78959999999998},null,{"$f":"IF((BH40<=$D$18),$D$18,BH40)","v":254.85769999999999},null,{"$f":"IF((BJ40<=$D$18),$D$18,BJ40)","v":265.92579999999998},null,{"$f":"IF((BL40<=$D$18),$D$18,BL40)","v":276.9939},null,{"$f":"IF((BN40<=$D$18),$D$18,BN40)","v":288.06200000000001},null,{"$f":"IF((BP40<=$D$18),$D$18,BP40)","v":299.13009999999997},null,{"$f":"IF((BR40<=$D$18),$D$18,BR40)","v":310.19819999999999},null,{"$f":"IF((BT40<=$D$18),$D$18,BT40)","v":321.2663},null,{"$f":"IF((BV40<=$D$18),$D$18,BV40)","v":332.33439999999996},null,{"$f":"IF((BX40<=$D$18),$D$18,BX40)","v":343.40249999999997},null,{"$f":"IF((BZ40<=$D$18),$D$18,BZ40)","v":354.47059999999999},null,{"$f":"IF((CB40<=$D$18),$D$18,CB40)","v":365.53869999999995},null,{"$f":"IF((CD40<=$D$18),$D$18,CD40)","v":376.60680000000002},null,{"$f":"IF((CF40<=$D$18),$D$18,CF40)","v":387.67489999999998},null,{"$f":"IF((CH40<=$D$18),$D$18,CH40)","v":398.74299999999999},null,{"$f":"IF((CJ40<=$D$18),$D$18,CJ40)","v":409.81110000000001},null,{"$f":"IF((CL40<=$D$18),$D$18,CL40)","v":420.87919999999997},null,{"$f":"IF((CN40<=$D$18),$D$18,CN40)","v":431.94729999999998},null,{"$f":"IF((CP40<=$D$18),$D$18,CP40)","v":443.0154},null,{"$f":"IF((CR40<=$D$18),$D$18,CR40)","v":454.08349999999996},null,{"$f":"IF((CT40<=$D$18),$D$18,CT40)","v":465.15159999999997},null,{"$f":"IF((CV40<=$D$18),$D$18,CV40)","v":476.21969999999999},null,{"$f":"IF((CX40<=$D$18),$D$18,CX40)","v":487.28779999999995},null,{"$f":"IF((CZ40<=$D$18),$D$18,CZ40)","v":498.35589999999996},null,{"$f":"IF((DB40<=$D$18),$D$18,DB40)","v":509.42399999999998},null,{"$f":"D34*C33","v":0}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F41","v":66.7},null,{"$f":"H41","v":66.7},null,{"$f":"J41","v":66.7},null,{"$f":"L41","v":66.7},null,{"$f":"N41","v":66.7},null,{"$f":"P41","v":66.7},null,{"$f":"R41","v":66.7},null,{"$f":"T41","v":66.7},null,{"$f":"V41","v":66.7},null,{"$f":"X41","v":66.7},null,{"$f":"Z41","v":66.7},null,{"$f":"AB41","v":77.768100000000004},null,{"$f":"AD41","v":88.836200000000005},null,{"$f":"AF41","v":99.904300000000006},null,{"$f":"AH41","v":110.97239999999999},null,{"$f":"AJ41","v":122.04050000000001},null,{"$f":"AL41","v":133.1086},null,{"$f":"AN41","v":144.17669999999998},null,{"$f":"AP41","v":155.2448},null,{"$f":"AR41","v":166.31290000000001},null,{"$f":"AT41","v":177.381},null,{"$f":"AV41","v":188.44909999999999},null,{"$f":"AX41","v":199.5172},null,{"$f":"AZ41","v":210.58530000000002},null,{"$f":"BB41","v":221.65339999999998},null,{"$f":"BD41","v":232.72149999999999},null,{"$f":"BF41","v":243.78959999999998},null,{"$f":"BH41","v":254.85769999999999},null,{"$f":"BJ41","v":265.92579999999998},null,{"$f":"BL41","v":276.9939},null,{"$f":"BN41","v":288.06200000000001},null,{"$f":"BP41","v":299.13009999999997},null,{"$f":"BR41","v":310.19819999999999},null,{"$f":"BT41","v":321.2663},null,{"$f":"BV41","v":332.33439999999996},null,{"$f":"BX41","v":343.40249999999997},null,{"$f":"BZ41","v":354.47059999999999},null,{"$f":"CB41","v":365.53869999999995},null,{"$f":"CD41","v":376.60680000000002},null,{"$f":"CF41","v":387.67489999999998},null,{"$f":"CH41","v":398.74299999999999},null,{"$f":"CJ41","v":409.81110000000001},null,{"$f":"CL41","v":420.87919999999997},null,{"$f":"CN41","v":431.94729999999998},null,{"$f":"CP41","v":443.0154},null,{"$f":"CR41","v":454.08349999999996},null,{"$f":"CT41","v":465.15159999999997},null,{"$f":"CV41","v":476.21969999999999},null,{"$f":"CX41","v":487.28779999999995},null,{"$f":"CZ41","v":498.35589999999996},null,{"$f":"DB41","v":509.42399999999998},null,{"$f":"DD40+DD41","v":0}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F42","v":66.7},null,{"$f":"H42","v":66.7},null,{"$f":"J42","v":66.7},null,{"$f":"L42","v":66.7},null,{"$f":"N42","v":66.7},null,{"$f":"P42","v":66.7},null,{"$f":"R42","v":66.7},null,{"$f":"T42","v":66.7},null,66.7,null,66.7,null,66.7,null,77.768100000000004,null,88.836200000000005,null,99.904300000000006,null,{"$f":"AH42","v":110.97239999999999},null,{"$f":"AJ42","v":122.04050000000001},null,{"$f":"AL42","v":133.1086},null,{"$f":"AN42","v":144.17669999999998},null,155.2448,null,166.31290000000001,null,{"$f":"AT42","v":177.381},null,{"$f":"AV42","v":188.44909999999999},null,{"$f":"AX42","v":199.5172},null,{"$f":"AZ42","v":210.58530000000002},null,221.65339999999998,null,232.72149999999999,null,{"$f":"BF42","v":243.78959999999998},null,{"$f":"BH42","v":254.85769999999999},null,{"$f":"BJ42","v":265.92579999999998},null,{"$f":"BL42","v":276.9939},null,288.06200000000001,null,299.13009999999997,null,{"$f":"BR42","v":310.19819999999999},null,{"$f":"BT42","v":321.2663},null,{"$f":"BV42","v":332.33439999999996},null,{"$f":"BX42","v":343.40249999999997},null,354.47059999999999,null,365.53869999999995,null,{"$f":"CD42","v":376.60680000000002},null,{"$f":"CF42","v":387.67489999999998},null,{"$f":"CH42","v":398.74299999999999},null,{"$f":"CJ42","v":409.81110000000001},null,420.87919999999997,null,431.94729999999998,null,{"$f":"CP42","v":443.0154},null,{"$f":"CR42","v":454.08349999999996},null,{"$f":"CT42","v":465.15159999999997},null,{"$f":"CV42","v":476.21969999999999},null,487.28779999999995,null,498.35589999999996,null,{"$f":"DB42","v":509.42399999999998},null,{"$f":"DD42","v":0},null,"Diferença de R$ 819,78 em relação à primeira tabela (atual-sem a jurisprudência)",null,null,{"$f":"DD44-DD13","v":0}]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F42+F43","v":133.4},null,{"$f":"H42+H43","v":133.4},null,{"$f":"J42+J43","v":133.4},null,{"$f":"L42+L43","v":133.4},null,{"$f":"N42+N43","v":133.4},null,{"$f":"P42+P43","v":133.4},null,{"$f":"R42+R43","v":133.4},null,{"$f":"T42+T43","v":133.4},null,{"$f":"V42+V43","v":133.4},null,{"$f":"X42+X43","v":133.4},null,{"$f":"Z42+Z43","v":133.4},null,{"$f":"AB42+AB43","v":155.53620000000001},null,{"$f":"AD42+AD43","v":177.67240000000001},null,{"$f":"AF42+AF43","v":199.80860000000001},null,{"$f":"AH42+AH43","v":221.94479999999999},null,{"$f":"AJ42+AJ43","v":244.08100000000002},null,{"$f":"AL42+AL43","v":266.21719999999999},null,{"$f":"AN42+AN43","v":288.35339999999997},null,{"$f":"AP42+AP43","v":310.4896},null,{"$f":"AR42+AR43","v":332.62580000000003},null,{"$f":"AT42+AT43","v":354.762},null,{"$f":"AV42+AV43","v":376.89819999999997},null,{"$f":"AX42+AX43","v":399.03440000000001},null,{"$f":"AZ42+AZ43","v":421.17060000000004},null,{"$f":"BB42+BB43","v":443.30679999999995},null,{"$f":"BD42+BD43","v":465.44299999999998},null,{"$f":"BF42+BF43","v":487.57919999999996},null,{"$f":"BH42+BH43","v":509.71539999999999},null,{"$f":"BJ42+BJ43","v":531.85159999999996},null,{"$f":"BL42+BL43","v":553.98779999999999},null,{"$f":"BN42+BN43","v":576.12400000000002},null,{"$f":"BP42+BP43","v":598.26019999999994},null,{"$f":"BR42+BR43","v":620.39639999999997},null,{"$f":"BT42+BT43","v":642.5326},null,{"$f":"BV42+BV43","v":664.66879999999992},null,{"$f":"BX42+BX43","v":686.80499999999995},null,{"$f":"BZ42+BZ43","v":708.94119999999998},null,{"$f":"CB42+CB43","v":731.0773999999999},null,{"$f":"CD42+CD43","v":753.21360000000004},null,{"$f":"CF42+CF43","v":775.34979999999996},null,{"$f":"CH42+CH43","v":797.48599999999999},null,{"$f":"CJ42+CJ43","v":819.62220000000002},null,{"$f":"CL42+CL43","v":841.75839999999994},null,{"$f":"CN42+CN43","v":863.89459999999997},null,{"$f":"CP42+CP43","v":886.0308},null,{"$f":"CR42+CR43","v":908.16699999999992},null,{"$f":"CT42+CT43","v":930.30319999999995},null,{"$f":"CV42+CV43","v":952.43939999999998},null,{"$f":"CX42+CX43","v":974.57559999999989},null,{"$f":"CZ42+CZ43","v":996.71179999999993},null,{"$f":"DB42+DB43","v":1018.848},null,{"$f":"DD42+DD43","v":0}]
[]
[]
[]
["CONDOMÍNIO em FLORIANÓPOLIS (caso real)"]
[]
[null,null,"113 ECONOMIAS"]
["RESIDENCIAL  ","TFDI sem RTP",null,28.85,0,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31,null,32,null,33,null,34,null,35,null,36,null,37,null,38,null,39,null,40,null,41,null,42,null,43,null,44,null,45,null,46,null,47,null,48,null,49,null,50,null,"1080 m³"]
[null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total","Consumo \nna Faixa","Valor total"]
[null,0,11,1.93,0,{"$f":"E53*$D$20","v":0},1,{"$f":"G53*$D$20","v":6.67},2,{"$f":"I53*$D$20","v":13.34},3,{"$f":"K53*$D$20","v":20.009999999999998},4,{"$f":"M53*$D$20","v":26.68},5,{"$f":"O53*$D$20","v":33.35},6,{"$f":"Q53*$D$20","v":40.019999999999996},7,{"$f":"S53*$D$20","v":46.69},8,{"$f":"U53*$D$20","v":53.36},9,{"$f":"W53*$D$20","v":60.03},10,{"$f":"Y53*$D$20","v":66.7},10,{"$f":"AA53*$D$20","v":66.7},10,{"$f":"AC53*$D$20","v":66.7},10,{"$f":"AE53*$D$20","v":66.7},10,{"$f":"AG53*$D$20","v":66.7},10,{"$f":"AI53*$D$20","v":66.7},10,{"$f":"AK53*$D$20","v":66.7},10,{"$f":"AM53*$D$20","v":66.7},10,{"$f":"AO53*$D$20","v":66.7},10,{"$f":"AQ53*$D$20","v":66.7},10,{"$f":"AS53*$D$20","v":66.7},10,{"$f":"AU53*$D$20","v":66.7},10,{"$f":"AW53*$D$20","v":66.7},10,{"$f":"AY53*$D$20","v":66.7},10,{"$f":"BA53*$D$20","v":66.7},10,{"$f":"BC53*$D$20","v":66.7},10,{"$f":"BE53*$D$20","v":66.7},10,{"$f":"BG53*$D$20","v":66.7},10,{"$f":"BI53*$D$20","v":66.7},10,{"$f":"BK53*$D$20","v":66.7},10,{"$f":"BM53*$D$20","v":66.7},10,{"$f":"BO53*$D$20","v":66.7},10,{"$f":"BQ53*$D$20","v":66.7},10,{"$f":"BS53*$D$20","v":66.7},10,{"$f":"BU53*$D$20","v":66.7},10,{"$f":"BW53*$D$20","v":66.7},10,{"$f":"BY53*$D$20","v":66.7},10,{"$f":"CA53*$D$20","v":66.7},10,{"$f":"CC53*$D$20","v":66.7},10,{"$f":"CE53*$D$20","v":66.7},10,{"$f":"CG53*$D$20","v":66.7},10,{"$f":"CI53*$D$20","v":66.7},10,{"$f":"CK53*$D$20","v":66.7},10,{"$f":"CM53*$D$20","v":66.7},10,{"$f":"CO53*$D$20","v":66.7},10,{"$f":"CQ53*$D$20","v":66.7},10,{"$f":"CS53*$D$20","v":66.7},10,{"$f":"CU53*$D$20","v":66.7},10,{"$f":"CW53*$D$20","v":66.7},10,{"$f":"CY53*$D$20","v":66.7},10,{"$f":"DA53*$D$20","v":66.7},1080,{"$f":"DC53*$D$53","v":2084.4},null,"Simulação nova estrutura tarifária"]
[null,11,26,8.64,null,{"$f":"E54*$D$21","v":0},null,{"$f":"G54*$D$21","v":0},null,{"$f":"I54*$D$21","v":0},null,{"$f":"K54*$D$21","v":0},null,{"$f":"M54*$D$21","v":0},null,{"$f":"O54*$D$21","v":0},null,{"$f":"Q54*$D$21","v":0},null,{"$f":"S54*$D$21","v":0},null,{"$f":"U54*$D$21","v":0},null,{"$f":"W54*$D$21","v":0},null,{"$f":"Y54*$D$21","v":0},1,{"$f":"AA54*$D$21","v":11.068099999999999},2,{"$f":"AC54*$D$21","v":22.136199999999999},3,{"$f":"AE54*$D$21","v":33.204299999999996},4,{"$f":"AG54*$D$21","v":44.272399999999998},5,{"$f":"AI54*$D$21","v":55.340499999999999},6,{"$f":"AK54*$D$21","v":66.408599999999993},7,{"$f":"AM54*$D$21","v":77.476699999999994},8,{"$f":"AO54*$D$21","v":88.544799999999995},9,{"$f":"AQ54*$D$21","v":99.612899999999996},10,{"$f":"AS54*$D$21","v":110.681},11,{"$f":"AU54*$D$21","v":121.7491},12,{"$f":"AW54*$D$21","v":132.81719999999999},13,{"$f":"AY54*$D$21","v":143.8853},14,{"$f":"BA54*$D$21","v":154.95339999999999},15,{"$f":"BC54*$D$21","v":166.0215},15,{"$f":"BE54*$D$21","v":166.0215},15,{"$f":"BG54*$D$21","v":166.0215},15,{"$f":"BI54*$D$21","v":166.0215},15,{"$f":"BK54*$D$21","v":166.0215},15,{"$f":"BM54*$D$21","v":166.0215},15,{"$f":"BO54*$D$21","v":166.0215},15,{"$f":"BQ54*$D$21","v":166.0215},15,{"$f":"BS54*$D$21","v":166.0215},15,{"$f":"BU54*$D$21","v":166.0215},15,{"$f":"BW54*$D$21","v":166.0215},15,{"$f":"BY54*$D$21","v":166.0215},15,{"$f":"CA54*$D$21","v":166.0215},15,{"$f":"CC54*$D$21","v":166.0215},15,{"$f":"CE54*$D$21","v":166.0215},15,{"$f":"CG54*$D$21","v":166.0215},15,{"$f":"CI54*$D$21","v":166.0215},15,{"$f":"CK54*$D$21","v":166.0215},15,{"$f":"CM54*$D$21","v":166.0215},15,{"$f":"CO54*$D$21","v":166.0215},15,{"$f":"CQ54*$D$21","v":166.0215},15,{"$f":"CS54*$D$21","v":166.0215},15,{"$f":"CU54*$D$21","v":166.0215},15,{"$f":"CW54*$D$21","v":166.0215},15,{"$f":"CY54*$D$21","v":166.0215},15,{"$f":"DA54*$D$21","v":166.0215},null,{"$f":"DC54*$D$37","v":0}]
[null,26,51,12.12,null,{"$f":"E55*$D$22","v":0},null,{"$f":"G55*$D$22","v":0},null,{"$f":"I55*$D$22","v":0},null,{"$f":"K55*$D$22","v":0},null,{"$f":"M55*$D$22","v":0},null,{"$f":"O55*$D$22","v":0},null,{"$f":"Q55*$D$22","v":0},null,{"$f":"S55*$D$22","v":0},null,{"$f":"U55*$D$22","v":0},null,{"$f":"W55*$D$22","v":0},null,{"$f":"Y55*$D$22","v":0},null,{"$f":"AA55*$D$22","v":0},null,{"$f":"AC55*$D$22","v":0},null,{"$f":"AE55*$D$22","v":0},null,{"$f":"AG55*$D$22","v":0},null,{"$f":"AI55*$D$22","v":0},null,{"$f":"AK55*$D$22","v":0},null,{"$f":"AM55*$D$22","v":0},null,{"$f":"AO55*$D$22","v":0},null,{"$f":"AQ55*$D$22","v":0},null,{"$f":"AS55*$D$22","v":0},null,{"$f":"AU55*$D$22","v":0},null,{"$f":"AW55*$D$22","v":0},null,{"$f":"AY55*$D$22","v":0},null,{"$f":"BA55*$D$22","v":0},null,{"$f":"BC55*$D$22","v":0},1,{"$f":"BE55*$D$22","v":11.068099999999999},2,{"$f":"BG55*$D$22","v":22.136199999999999},3,{"$f":"BI55*$D$22","v":33.204299999999996},4,{"$f":"BK55*$D$22","v":44.272399999999998},5,{"$f":"BM55*$D$22","v":55.340499999999999},6,{"$f":"BO55*$D$22","v":66.408599999999993},7,{"$f":"BQ55*$D$22","v":77.476699999999994},8,{"$f":"BS55*$D$22","v":88.544799999999995},9,{"$f":"BU55*$D$22","v":99.612899999999996},10,{"$f":"BW55*$D$22","v":110.681},11,{"$f":"BY55*$D$22","v":121.7491},12,{"$f":"CA55*$D$22","v":132.81719999999999},13,{"$f":"CC55*$D$22","v":143.8853},14,{"$f":"CE55*$D$22","v":154.95339999999999},15,{"$f":"CG55*$D$22","v":166.0215},16,{"$f":"CI55*$D$22","v":177.08959999999999},17,{"$f":"CK55*$D$22","v":188.15769999999998},18,{"$f":"CM55*$D$22","v":199.22579999999999},19,{"$f":"CO55*$D$22","v":210.29389999999998},20,{"$f":"CQ55*$D$22","v":221.36199999999999},21,{"$f":"CS55*$D$22","v":232.43009999999998},22,{"$f":"CU55*$D$22","v":243.4982},23,{"$f":"CW55*$D$22","v":254.56629999999998},24,{"$f":"CY55*$D$22","v":265.63439999999997},25,{"$f":"DA55*$D$22","v":276.70249999999999},null,{"$f":"DC55*$D$38","v":0}]
[null,51,9999,15.19,null,{"$f":"E56*$D$23","v":0},null,{"$f":"G56*$D$23","v":0},null,{"$f":"I56*$D$23","v":0},null,{"$f":"K56*$D$23","v":0},null,{"$f":"M56*$D$23","v":0},null,{"$f":"O56*$D$23","v":0},null,{"$f":"Q56*$D$23","v":0},null,{"$f":"S56*$D$23","v":0},null,{"$f":"U56*$D$23","v":0},null,{"$f":"W56*$D$23","v":0},null,{"$f":"Y56*$D$23","v":0},null,{"$f":"AA56*$D$23","v":0},null,{"$f":"AC56*$D$23","v":0},null,{"$f":"AE56*$D$23","v":0},null,{"$f":"AG56*$D$23","v":0},null,{"$f":"AI56*$D$23","v":0},null,{"$f":"AK56*$D$23","v":0},null,{"$f":"AM56*$D$23","v":0},null,{"$f":"AO56*$D$23","v":0},null,{"$f":"AQ56*$D$23","v":0},null,{"$f":"AS56*$D$23","v":0},null,{"$f":"AU56*$D$23","v":0},null,{"$f":"AW56*$D$23","v":0},null,{"$f":"AY56*$D$23","v":0},null,{"$f":"BA56*$D$23","v":0},null,{"$f":"BC56*$D$23","v":0},null,{"$f":"BE56*$D$23","v":0},null,{"$f":"BG56*$D$23","v":0},null,{"$f":"BI56*$D$23","v":0},null,{"$f":"BK56*$D$23","v":0},null,{"$f":"BM56*$D$23","v":0},null,{"$f":"BO56*$D$23","v":0},null,{"$f":"BQ56*$D$23","v":0},null,{"$f":"BS56*$D$23","v":0},null,{"$f":"BU56*$D$23","v":0},null,{"$f":"BW56*$D$23","v":0},null,{"$f":"BY56*$D$23","v":0},null,{"$f":"CA56*$D$23","v":0},null,{"$f":"CC56*$D$23","v":0},null,{"$f":"CE56*$D$23","v":0},null,{"$f":"CG56*$D$23","v":0},null,{"$f":"CI56*$D$23","v":0},null,{"$f":"CK56*$D$23","v":0},null,{"$f":"CM56*$D$23","v":0},null,{"$f":"CO56*$D$23","v":0},null,{"$f":"CQ56*$D$23","v":0},null,{"$f":"CS56*$D$23","v":0},null,{"$f":"CU56*$D$23","v":0},null,{"$f":"CW56*$D$23","v":0},null,{"$f":"CY56*$D$23","v":0},null,{"$f":"DA56*$D$23","v":0},null,{"$f":"DC56*$D$39","v":0}]
[null,"TOTAL CONSUMO",null,null,null,{"$f":"SUM(F53:F56)","v":0},null,{"$f":"SUM(H53:H56)","v":6.67},null,{"$f":"SUM(J53:J56)","v":13.34},null,{"$f":"SUM(L53:L56)","v":20.009999999999998},null,{"$f":"SUM(N53:N56)","v":26.68},null,{"$f":"SUM(P53:P56)","v":33.35},null,{"$f":"SUM(R53:R56)","v":40.019999999999996},null,{"$f":"SUM(T53:T56)","v":46.69},null,{"$f":"SUM(V53:V56)","v":53.36},null,{"$f":"SUM(X53:X56)","v":60.03},null,{"$f":"SUM(Z53:Z56)","v":66.7},null,{"$f":"SUM(AB53:AB56)","v":77.768100000000004},null,{"$f":"SUM(AD53:AD56)","v":88.836200000000005},null,{"$f":"SUM(AF53:AF56)","v":99.904300000000006},null,{"$f":"SUM(AH53:AH56)","v":110.97239999999999},null,{"$f":"SUM(AJ53:AJ56)","v":122.04050000000001},null,{"$f":"SUM(AL53:AL56)","v":133.1086},null,{"$f":"SUM(AN53:AN56)","v":144.17669999999998},null,{"$f":"SUM(AP53:AP56)","v":155.2448},null,{"$f":"SUM(AR53:AR56)","v":166.31290000000001},null,{"$f":"SUM(AT53:AT56)","v":177.381},null,{"$f":"SUM(AV53:AV56)","v":188.44909999999999},null,{"$f":"SUM(AX53:AX56)","v":199.5172},null,{"$f":"SUM(AZ53:AZ56)","v":210.58530000000002},null,{"$f":"SUM(BB53:BB56)","v":221.65339999999998},null,{"$f":"SUM(BD53:BD56)","v":232.72149999999999},null,{"$f":"SUM(BF53:BF56)","v":243.78959999999998},null,{"$f":"SUM(BH53:BH56)","v":254.85769999999999},null,{"$f":"SUM(BJ53:BJ56)","v":265.92579999999998},null,{"$f":"SUM(BL53:BL56)","v":276.9939},null,{"$f":"SUM(BN53:BN56)","v":288.06200000000001},null,{"$f":"SUM(BP53:BP56)","v":299.13009999999997},null,{"$f":"SUM(BR53:BR56)","v":310.19819999999999},null,{"$f":"SUM(BT53:BT56)","v":321.2663},null,{"$f":"SUM(BV53:BV56)","v":332.33439999999996},null,{"$f":"SUM(BX53:BX56)","v":343.40249999999997},null,{"$f":"SUM(BZ53:BZ56)","v":354.47059999999999},null,{"$f":"SUM(CB53:CB56)","v":365.53869999999995},null,{"$f":"SUM(CD53:CD56)","v":376.60680000000002},null,{"$f":"SUM(CF53:CF56)","v":387.67489999999998},null,{"$f":"SUM(CH53:CH56)","v":398.74299999999999},null,{"$f":"SUM(CJ53:CJ56)","v":409.81110000000001},null,{"$f":"SUM(CL53:CL56)","v":420.87919999999997},null,{"$f":"SUM(CN53:CN56)","v":431.94729999999998},null,{"$f":"SUM(CP53:CP56)","v":443.0154},null,{"$f":"SUM(CR53:CR56)","v":454.08349999999996},null,{"$f":"SUM(CT53:CT56)","v":465.15159999999997},null,{"$f":"SUM(CV53:CV56)","v":476.21969999999999},null,{"$f":"SUM(CX53:CX56)","v":487.28779999999995},null,{"$f":"SUM(CZ53:CZ56)","v":498.35589999999996},null,{"$f":"SUM(DB53:DB56)","v":509.42399999999998},null,{"$f":"SUM(DD53:DD56)","v":2084.4}]
[null,"TOTAL TFDI 113 economias",null,null,null,{"$f":"IF((F57<=$D$18),$D$18,F57)","v":66.7},null,{"$f":"IF((H57<=$D$18),$D$18,H57)","v":66.7},null,{"$f":"IF((J57<=$D$18),$D$18,J57)","v":66.7},null,{"$f":"IF((L57<=$D$18),$D$18,L57)","v":66.7},null,{"$f":"IF((N57<=$D$18),$D$18,N57)","v":66.7},null,{"$f":"IF((P57<=$D$18),$D$18,P57)","v":66.7},null,{"$f":"IF((R57<=$D$18),$D$18,R57)","v":66.7},null,{"$f":"IF((T57<=$D$18),$D$18,T57)","v":66.7},null,{"$f":"IF((V57<=$D$18),$D$18,V57)","v":66.7},null,{"$f":"IF((X57<=$D$18),$D$18,X57)","v":66.7},null,{"$f":"IF((Z57<=$D$18),$D$18,Z57)","v":66.7},null,{"$f":"IF((AB57<=$D$18),$D$18,AB57)","v":77.768100000000004},null,{"$f":"IF((AD57<=$D$18),$D$18,AD57)","v":88.836200000000005},null,{"$f":"IF((AF57<=$D$18),$D$18,AF57)","v":99.904300000000006},null,{"$f":"IF((AH57<=$D$18),$D$18,AH57)","v":110.97239999999999},null,{"$f":"IF((AJ57<=$D$18),$D$18,AJ57)","v":122.04050000000001},null,{"$f":"IF((AL57<=$D$18),$D$18,AL57)","v":133.1086},null,{"$f":"IF((AN57<=$D$18),$D$18,AN57)","v":144.17669999999998},null,{"$f":"IF((AP57<=$D$18),$D$18,AP57)","v":155.2448},null,{"$f":"IF((AR57<=$D$18),$D$18,AR57)","v":166.31290000000001},null,{"$f":"IF((AT57<=$D$18),$D$18,AT57)","v":177.381},null,{"$f":"IF((AV57<=$D$18),$D$18,AV57)","v":188.44909999999999},null,{"$f":"IF((AX57<=$D$18),$D$18,AX57)","v":199.5172},null,{"$f":"IF((AZ57<=$D$18),$D$18,AZ57)","v":210.58530000000002},null,{"$f":"IF((BB57<=$D$18),$D$18,BB57)","v":221.65339999999998},null,{"$f":"IF((BD57<=$D$18),$D$18,BD57)","v":232.72149999999999},null,{"$f":"IF((BF57<=$D$18),$D$18,BF57)","v":243.78959999999998},null,{"$f":"IF((BH57<=$D$18),$D$18,BH57)","v":254.85769999999999},null,{"$f":"IF((BJ57<=$D$18),$D$18,BJ57)","v":265.92579999999998},null,{"$f":"IF((BL57<=$D$18),$D$18,BL57)","v":276.9939},null,{"$f":"IF((BN57<=$D$18),$D$18,BN57)","v":288.06200000000001},null,{"$f":"IF((BP57<=$D$18),$D$18,BP57)","v":299.13009999999997},null,{"$f":"IF((BR57<=$D$18),$D$18,BR57)","v":310.19819999999999},null,{"$f":"IF((BT57<=$D$18),$D$18,BT57)","v":321.2663},null,{"$f":"IF((BV57<=$D$18),$D$18,BV57)","v":332.33439999999996},null,{"$f":"IF((BX57<=$D$18),$D$18,BX57)","v":343.40249999999997},null,{"$f":"IF((BZ57<=$D$18),$D$18,BZ57)","v":354.47059999999999},null,{"$f":"IF((CB57<=$D$18),$D$18,CB57)","v":365.53869999999995},null,{"$f":"IF((CD57<=$D$18),$D$18,CD57)","v":376.60680000000002},null,{"$f":"IF((CF57<=$D$18),$D$18,CF57)","v":387.67489999999998},null,{"$f":"IF((CH57<=$D$18),$D$18,CH57)","v":398.74299999999999},null,{"$f":"IF((CJ57<=$D$18),$D$18,CJ57)","v":409.81110000000001},null,{"$f":"IF((CL57<=$D$18),$D$18,CL57)","v":420.87919999999997},null,{"$f":"IF((CN57<=$D$18),$D$18,CN57)","v":431.94729999999998},null,{"$f":"IF((CP57<=$D$18),$D$18,CP57)","v":443.0154},null,{"$f":"IF((CR57<=$D$18),$D$18,CR57)","v":454.08349999999996},null,{"$f":"IF((CT57<=$D$18),$D$18,CT57)","v":465.15159999999997},null,{"$f":"IF((CV57<=$D$18),$D$18,CV57)","v":476.21969999999999},null,{"$f":"IF((CX57<=$D$18),$D$18,CX57)","v":487.28779999999995},null,{"$f":"IF((CZ57<=$D$18),$D$18,CZ57)","v":498.35589999999996},null,{"$f":"IF((DB57<=$D$18),$D$18,DB57)","v":509.42399999999998},null,{"$f":"D51*113","v":3260.05}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F58","v":66.7},null,{"$f":"H58","v":66.7},null,{"$f":"J58","v":66.7},null,{"$f":"L58","v":66.7},null,{"$f":"N58","v":66.7},null,{"$f":"P58","v":66.7},null,{"$f":"R58","v":66.7},null,{"$f":"T58","v":66.7},null,{"$f":"V58","v":66.7},null,{"$f":"X58","v":66.7},null,{"$f":"Z58","v":66.7},null,{"$f":"AB58","v":77.768100000000004},null,{"$f":"AD58","v":88.836200000000005},null,{"$f":"AF58","v":99.904300000000006},null,{"$f":"AH58","v":110.97239999999999},null,{"$f":"AJ58","v":122.04050000000001},null,{"$f":"AL58","v":133.1086},null,{"$f":"AN58","v":144.17669999999998},null,{"$f":"AP58","v":155.2448},null,{"$f":"AR58","v":166.31290000000001},null,{"$f":"AT58","v":177.381},null,{"$f":"AV58","v":188.44909999999999},null,{"$f":"AX58","v":199.5172},null,{"$f":"AZ58","v":210.58530000000002},null,{"$f":"BB58","v":221.65339999999998},null,{"$f":"BD58","v":232.72149999999999},null,{"$f":"BF58","v":243.78959999999998},null,{"$f":"BH58","v":254.85769999999999},null,{"$f":"BJ58","v":265.92579999999998},null,{"$f":"BL58","v":276.9939},null,{"$f":"BN58","v":288.06200000000001},null,{"$f":"BP58","v":299.13009999999997},null,{"$f":"BR58","v":310.19819999999999},null,{"$f":"BT58","v":321.2663},null,{"$f":"BV58","v":332.33439999999996},null,{"$f":"BX58","v":343.40249999999997},null,{"$f":"BZ58","v":354.47059999999999},null,{"$f":"CB58","v":365.53869999999995},null,{"$f":"CD58","v":376.60680000000002},null,{"$f":"CF58","v":387.67489999999998},null,{"$f":"CH58","v":398.74299999999999},null,{"$f":"CJ58","v":409.81110000000001},null,{"$f":"CL58","v":420.87919999999997},null,{"$f":"CN58","v":431.94729999999998},null,{"$f":"CP58","v":443.0154},null,{"$f":"CR58","v":454.08349999999996},null,{"$f":"CT58","v":465.15159999999997},null,{"$f":"CV58","v":476.21969999999999},null,{"$f":"CX58","v":487.28779999999995},null,{"$f":"CZ58","v":498.35589999999996},null,{"$f":"DB58","v":509.42399999999998},null,{"$f":"DD57+DD58","v":5344.4500000000007}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F59","v":66.7},null,{"$f":"H59","v":66.7},null,{"$f":"J59","v":66.7},null,{"$f":"L59","v":66.7},null,{"$f":"N59","v":66.7},null,{"$f":"P59","v":66.7},null,{"$f":"R59","v":66.7},null,{"$f":"T59","v":66.7},null,66.7,null,66.7,null,66.7,null,77.768100000000004,null,88.836200000000005,null,99.904300000000006,null,110.97239999999999,null,122.04050000000001,null,133.1086,null,144.17669999999998,null,155.2448,null,166.31290000000001,null,177.381,null,188.44909999999999,null,199.5172,null,210.58530000000002,null,221.65339999999998,null,232.72149999999999,null,243.78959999999998,null,254.85769999999999,null,265.92579999999998,null,276.9939,null,288.06200000000001,null,299.13009999999997,null,310.19819999999999,null,321.2663,null,332.33439999999996,null,343.40249999999997,null,354.47059999999999,null,365.53869999999995,null,376.60680000000002,null,387.67489999999998,null,398.74299999999999,null,409.81110000000001,null,420.87919999999997,null,431.94729999999998,null,443.0154,null,454.08349999999996,null,465.15159999999997,null,476.21969999999999,null,487.28779999999995,null,498.35589999999996,null,509.42399999999998,null,{"$f":"DD59","v":5344.4500000000007},null,"Diferença de R$ 735,86",null,null,{"$f":"DD61-DD13","v":10688.900000000001}]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F59+F60","v":133.4},null,{"$f":"H59+H60","v":133.4},null,{"$f":"J59+J60","v":133.4},null,{"$f":"L59+L60","v":133.4},null,{"$f":"N59+N60","v":133.4},null,{"$f":"P59+P60","v":133.4},null,{"$f":"R59+R60","v":133.4},null,{"$f":"T59+T60","v":133.4},null,{"$f":"V59+V60","v":133.4},null,{"$f":"X59+X60","v":133.4},null,{"$f":"Z59+Z60","v":133.4},null,{"$f":"AB59+AB60","v":155.53620000000001},null,{"$f":"AD59+AD60","v":177.67240000000001},null,{"$f":"AF59+AF60","v":199.80860000000001},null,{"$f":"AH59+AH60","v":221.94479999999999},null,{"$f":"AJ59+AJ60","v":244.08100000000002},null,{"$f":"AL59+AL60","v":266.21719999999999},null,{"$f":"AN59+AN60","v":288.35339999999997},null,{"$f":"AP59+AP60","v":310.4896},null,{"$f":"AR59+AR60","v":332.62580000000003},null,{"$f":"AT59+AT60","v":354.762},null,{"$f":"AV59+AV60","v":376.89819999999997},null,{"$f":"AX59+AX60","v":399.03440000000001},null,{"$f":"AZ59+AZ60","v":421.17060000000004},null,{"$f":"BB59+BB60","v":443.30679999999995},null,{"$f":"BD59+BD60","v":465.44299999999998},null,{"$f":"BF59+BF60","v":487.57919999999996},null,{"$f":"BH59+BH60","v":509.71539999999999},null,{"$f":"BJ59+BJ60","v":531.85159999999996},null,{"$f":"BL59+BL60","v":553.98779999999999},null,{"$f":"BN59+BN60","v":576.12400000000002},null,{"$f":"BP59+BP60","v":598.26019999999994},null,{"$f":"BR59+BR60","v":620.39639999999997},null,{"$f":"BT59+BT60","v":642.5326},null,{"$f":"BV59+BV60","v":664.66879999999992},null,{"$f":"BX59+BX60","v":686.80499999999995},null,{"$f":"BZ59+BZ60","v":708.94119999999998},null,{"$f":"CB59+CB60","v":731.0773999999999},null,{"$f":"CD59+CD60","v":753.21360000000004},null,{"$f":"CF59+CF60","v":775.34979999999996},null,{"$f":"CH59+CH60","v":797.48599999999999},null,{"$f":"CJ59+CJ60","v":819.62220000000002},null,{"$f":"CL59+CL60","v":841.75839999999994},null,{"$f":"CN59+CN60","v":863.89459999999997},null,{"$f":"CP59+CP60","v":886.0308},null,{"$f":"CR59+CR60","v":908.16699999999992},null,{"$f":"CT59+CT60","v":930.30319999999995},null,{"$f":"CV59+CV60","v":952.43939999999998},null,{"$f":"CX59+CX60","v":974.57559999999989},null,{"$f":"CZ59+CZ60","v":996.71179999999993},null,{"$f":"DB59+DB60","v":1018.848},null,{"$f":"DD59+DD60","v":10688.900000000001}]