{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ESTRUTURA TARIFÁRIA ATUAL","CALCULADORA"],"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":"ESTRUTURA TARIFÁRIA ATUAL","index":0,"n_rows":59,"n_cols":122,"rows_kept":59,"cut":false,"hidden":false,"merged":[[16,109,26,110],[32,109,39,110],[50,109,56,110],[57,109,58,110],[45,0,45,107],[46,0,46,107],[48,0,58,0],[48,1,48,2],[48,106,48,107],[49,1,49,2],[17,0,27,0],[17,1,17,2],[18,1,18,2],[16,106,16,107],[16,0,16,1],[37,1,37,2],[2,0,12,0],[2,1,2,2],[3,1,3,2],[1,106,1,107],[15,0,15,107],[0,112,0,117],[1,114,1,115],[31,0,31,107],[33,0,41,0],[33,1,33,2],[34,1,34,2],[32,106,32,107],[40,109,41,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]]}
["CONDOMÍNIO em BALNEÁRIO CAMBORIÚ (caso real)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:"]
["RESIDENCIAL  ","Consumo Mínimo = ",null,19.670000000000002,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 atual.",null,null,null,"Faixa",null,"Valor/m³","Consumo \nna Faixa","Valor total",null,null,"tabela de apoio"]
[null,0,10,1.9670000000000001,0,{"$f":"E5*$D$20","v":0},1,{"$f":"G5*$D$20","v":1.9670000000000001},2,{"$f":"I5*$D$20","v":3.9340000000000002},3,{"$f":"K5*$D$20","v":5.9009999999999998},4,{"$f":"M5*$D$20","v":7.8680000000000003},5,{"$f":"O5*$D$20","v":9.8350000000000009},6,{"$f":"Q5*$D$20","v":11.802},7,{"$f":"S5*$D$20","v":13.769},8,{"$f":"U5*$D$20","v":15.736000000000001},9,{"$f":"W5*$D$20","v":17.702999999999999},10,{"$f":"Y5*$D$20","v":19.670000000000002},10,{"$f":"AA5*$D$20","v":19.670000000000002},10,{"$f":"AC5*$D$20","v":19.670000000000002},10,{"$f":"AE5*$D$20","v":19.670000000000002},10,{"$f":"AG5*$D$20","v":19.670000000000002},10,{"$f":"AI5*$D$20","v":19.670000000000002},10,{"$f":"AK5*$D$20","v":19.670000000000002},10,{"$f":"AM5*$D$20","v":19.670000000000002},10,{"$f":"AO5*$D$20","v":19.670000000000002},10,{"$f":"AQ5*$D$20","v":19.670000000000002},10,{"$f":"AS5*$D$20","v":19.670000000000002},10,{"$f":"AU5*$D$20","v":19.670000000000002},10,{"$f":"AW5*$D$20","v":19.670000000000002},10,{"$f":"AY5*$D$20","v":19.670000000000002},10,{"$f":"BA5*$D$20","v":19.670000000000002},10,{"$f":"BC5*$D$20","v":19.670000000000002},10,{"$f":"BE5*$D$20","v":19.670000000000002},10,{"$f":"BG5*$D$20","v":19.670000000000002},10,{"$f":"BI5*$D$20","v":19.670000000000002},10,{"$f":"BK5*$D$20","v":19.670000000000002},10,{"$f":"BM5*$D$20","v":19.670000000000002},10,{"$f":"BO5*$D$20","v":19.670000000000002},10,{"$f":"BQ5*$D$20","v":19.670000000000002},10,{"$f":"BS5*$D$20","v":19.670000000000002},10,{"$f":"BU5*$D$20","v":19.670000000000002},10,{"$f":"BW5*$D$20","v":19.670000000000002},10,{"$f":"BY5*$D$20","v":19.670000000000002},10,{"$f":"CA5*$D$20","v":19.670000000000002},10,{"$f":"CC5*$D$20","v":19.670000000000002},10,{"$f":"CE5*$D$20","v":19.670000000000002},10,{"$f":"CG5*$D$20","v":19.670000000000002},10,{"$f":"CI5*$D$20","v":19.670000000000002},10,{"$f":"CK5*$D$20","v":19.670000000000002},10,{"$f":"CM5*$D$20","v":19.670000000000002},10,{"$f":"CO5*$D$20","v":19.670000000000002},10,{"$f":"CQ5*$D$20","v":19.670000000000002},10,{"$f":"CS5*$D$20","v":19.670000000000002},10,{"$f":"CU5*$D$20","v":19.670000000000002},10,{"$f":"CW5*$D$20","v":19.670000000000002},10,{"$f":"CY5*$D$20","v":19.670000000000002},10,{"$f":"DA5*$D$20","v":19.670000000000002},{"$f":"IF((DC3)<=DQ5, DC3,DQ5)","v":0},{"$f":"DC5*$D$5","v":0},null,null,null,null,null,0,10,4.6280000000000001,{"$f":"10*113","v":1130},{"$f":"DM5*$D$5","v":2222.71},null,null,{"$f":"C5","v":10},"consumo faixa 01"]
[null,11,25,3.4329999999999998,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":3.4329999999999998},2,{"$f":"AC6*$D$21","v":6.8659999999999997},3,{"$f":"AE6*$D$21","v":10.298999999999999},4,{"$f":"AG6*$D$21","v":13.731999999999999},5,{"$f":"AI6*$D$21","v":17.164999999999999},6,{"$f":"AK6*$D$21","v":20.597999999999999},7,{"$f":"AM6*$D$21","v":24.030999999999999},8,{"$f":"AO6*$D$21","v":27.463999999999999},9,{"$f":"AQ6*$D$21","v":30.896999999999998},10,{"$f":"AS6*$D$21","v":34.33},11,{"$f":"AU6*$D$21","v":37.762999999999998},12,{"$f":"AW6*$D$21","v":41.195999999999998},13,{"$f":"AY6*$D$21","v":44.628999999999998},14,{"$f":"BA6*$D$21","v":48.061999999999998},15,{"$f":"BC6*$D$21","v":51.494999999999997},15,{"$f":"BE6*$D$21","v":51.494999999999997},15,{"$f":"BG6*$D$21","v":51.494999999999997},15,{"$f":"BI6*$D$21","v":51.494999999999997},15,{"$f":"BK6*$D$21","v":51.494999999999997},15,{"$f":"BM6*$D$21","v":51.494999999999997},15,{"$f":"BO6*$D$21","v":51.494999999999997},15,{"$f":"BQ6*$D$21","v":51.494999999999997},15,{"$f":"BS6*$D$21","v":51.494999999999997},15,{"$f":"BU6*$D$21","v":51.494999999999997},15,{"$f":"BW6*$D$21","v":51.494999999999997},15,{"$f":"BY6*$D$21","v":51.494999999999997},15,{"$f":"CA6*$D$21","v":51.494999999999997},15,{"$f":"CC6*$D$21","v":51.494999999999997},15,{"$f":"CE6*$D$21","v":51.494999999999997},15,{"$f":"CG6*$D$21","v":51.494999999999997},15,{"$f":"CI6*$D$21","v":51.494999999999997},15,{"$f":"CK6*$D$21","v":51.494999999999997},15,{"$f":"CM6*$D$21","v":51.494999999999997},15,{"$f":"CO6*$D$21","v":51.494999999999997},15,{"$f":"CQ6*$D$21","v":51.494999999999997},15,{"$f":"CS6*$D$21","v":51.494999999999997},15,{"$f":"CU6*$D$21","v":51.494999999999997},15,{"$f":"CW6*$D$21","v":51.494999999999997},15,{"$f":"CY6*$D$21","v":51.494999999999997},15,{"$f":"DA6*$D$21","v":51.494999999999997},{"$f":"IF($DC$3<$DQ$5,0,IF($DC$3>($DQ$5+$DQ$6),$DQ$6,IF($DQ$5<$DC$3>$DQ$6,$DC$3-$DQ$5)))","v":0},{"$f":"DC6*$D$21","v":0},null,null,null,null,null,11,25,8.1217000000000006,null,{"$f":"DM6*$D$21","v":0},null,null,15,"consumo faixa 02"]
[null,26,50,4.05,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":4.05},2,{"$f":"BG7*$D$22","v":8.1},3,{"$f":"BI7*$D$22","v":12.149999999999999},4,{"$f":"BK7*$D$22","v":16.2},5,{"$f":"BM7*$D$22","v":20.25},6,{"$f":"BO7*$D$22","v":24.299999999999997},7,{"$f":"BQ7*$D$22","v":28.349999999999998},8,{"$f":"BS7*$D$22","v":32.4},9,{"$f":"BU7*$D$22","v":36.449999999999996},10,{"$f":"BW7*$D$22","v":40.5},11,{"$f":"BY7*$D$22","v":44.55},12,{"$f":"CA7*$D$22","v":48.599999999999994},13,{"$f":"CC7*$D$22","v":52.65},14,{"$f":"CE7*$D$22","v":56.699999999999996},15,{"$f":"CG7*$D$22","v":60.75},16,{"$f":"CI7*$D$22","v":64.8},17,{"$f":"CK7*$D$22","v":68.849999999999994},18,{"$f":"CM7*$D$22","v":72.899999999999991},19,{"$f":"CO7*$D$22","v":76.95},20,{"$f":"CQ7*$D$22","v":81},21,{"$f":"CS7*$D$22","v":85.05},22,{"$f":"CU7*$D$22","v":89.1},23,{"$f":"CW7*$D$22","v":93.149999999999991},24,{"$f":"CY7*$D$22","v":97.199999999999989},25,{"$f":"DA7*$D$22","v":101.25},{"$f":"IF($DC$3<35,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,null,null,26,50,11.3741,null,{"$f":"DM7*$D$22","v":0},null,null,25,"consumo faixa 03"]
[null,51,9999,4.6900000000000004,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)","v":false},{"$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((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":1.9670000000000001},null,{"$f":"SUM(J5:J8)","v":3.9340000000000002},null,{"$f":"SUM(L5:L8)","v":5.9009999999999998},null,{"$f":"SUM(N5:N8)","v":7.8680000000000003},null,{"$f":"SUM(P5:P8)","v":9.8350000000000009},null,{"$f":"SUM(R5:R8)","v":11.802},null,{"$f":"SUM(T5:T8)","v":13.769},null,{"$f":"SUM(V5:V8)","v":15.736000000000001},null,{"$f":"SUM(X5:X8)","v":17.702999999999999},null,{"$f":"SUM(Z5:Z8)","v":19.670000000000002},null,{"$f":"SUM(AB5:AB8)","v":23.103000000000002},null,{"$f":"SUM(AD5:AD8)","v":26.536000000000001},null,{"$f":"SUM(AF5:AF8)","v":29.969000000000001},null,{"$f":"SUM(AH5:AH8)","v":33.402000000000001},null,{"$f":"SUM(AJ5:AJ8)","v":36.835000000000001},null,{"$f":"SUM(AL5:AL8)","v":40.268000000000001},null,{"$f":"SUM(AN5:AN8)","v":43.701000000000001},null,{"$f":"SUM(AP5:AP8)","v":47.134},null,{"$f":"SUM(AR5:AR8)","v":50.567},null,{"$f":"SUM(AT5:AT8)","v":54},null,{"$f":"SUM(AV5:AV8)","v":57.433},null,{"$f":"SUM(AX5:AX8)","v":60.866},null,{"$f":"SUM(AZ5:AZ8)","v":64.299000000000007},null,{"$f":"SUM(BB5:BB8)","v":67.731999999999999},null,{"$f":"SUM(BD5:BD8)","v":71.164999999999992},null,{"$f":"SUM(BF5:BF8)","v":75.214999999999989},null,{"$f":"SUM(BH5:BH8)","v":79.264999999999986},null,{"$f":"SUM(BJ5:BJ8)","v":83.314999999999998},null,{"$f":"SUM(BL5:BL8)","v":87.364999999999995},null,{"$f":"SUM(BN5:BN8)","v":91.414999999999992},null,{"$f":"SUM(BP5:BP8)","v":95.464999999999989},null,{"$f":"SUM(BR5:BR8)","v":99.514999999999986},null,{"$f":"SUM(BT5:BT8)","v":103.565},null,{"$f":"SUM(BV5:BV8)","v":107.61499999999998},null,{"$f":"SUM(BX5:BX8)","v":111.66499999999999},null,{"$f":"SUM(BZ5:BZ8)","v":115.71499999999999},null,{"$f":"SUM(CB5:CB8)","v":119.76499999999999},null,{"$f":"SUM(CD5:CD8)","v":123.815},null,{"$f":"SUM(CF5:CF8)","v":127.86499999999998},null,{"$f":"SUM(CH5:CH8)","v":131.91499999999999},null,{"$f":"SUM(CJ5:CJ8)","v":135.96499999999997},null,{"$f":"SUM(CL5:CL8)","v":140.01499999999999},null,{"$f":"SUM(CN5:CN8)","v":144.065},null,{"$f":"SUM(CP5:CP8)","v":148.11500000000001},null,{"$f":"SUM(CR5:CR8)","v":152.16499999999999},null,{"$f":"SUM(CT5:CT8)","v":156.21499999999997},null,{"$f":"SUM(CV5:CV8)","v":160.26499999999999},null,{"$f":"SUM(CX5:CX8)","v":164.315},null,{"$f":"SUM(CZ5:CZ8)","v":168.36499999999998},null,{"$f":"SUM(DB5:DB8)","v":172.41499999999999},null,{"$f":"SUM(DD5:DD8)","v":0},null,null,null,null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(DN5:DN8)","v":2222.71}]
[null,"TOTAL",null,null,null,{"$f":"IF((F9<=$D$18),$D$18,F9)","v":19.670000000000002},null,{"$f":"IF((H9<=$D$18),$D$18,H9)","v":19.670000000000002},null,{"$f":"IF((J9<=$D$18),$D$18,J9)","v":19.670000000000002},null,{"$f":"IF((L9<=$D$18),$D$18,L9)","v":19.670000000000002},null,{"$f":"IF((N9<=$D$18),$D$18,N9)","v":19.670000000000002},null,{"$f":"IF((P9<=$D$18),$D$18,P9)","v":19.670000000000002},null,{"$f":"IF((R9<=$D$18),$D$18,R9)","v":19.670000000000002},null,{"$f":"IF((T9<=$D$18),$D$18,T9)","v":19.670000000000002},null,{"$f":"IF((V9<=$D$18),$D$18,V9)","v":19.670000000000002},null,{"$f":"IF((X9<=$D$18),$D$18,X9)","v":19.670000000000002},null,{"$f":"IF((Z9<=$D$18),$D$18,Z9)","v":19.670000000000002},null,{"$f":"IF((AB9<=$D$18),$D$18,AB9)","v":23.103000000000002},null,{"$f":"IF((AD9<=$D$18),$D$18,AD9)","v":26.536000000000001},null,{"$f":"IF((AF9<=$D$18),$D$18,AF9)","v":29.969000000000001},null,{"$f":"IF((AH9<=$D$18),$D$18,AH9)","v":33.402000000000001},null,{"$f":"IF((AJ9<=$D$18),$D$18,AJ9)","v":36.835000000000001},null,{"$f":"IF((AL9<=$D$18),$D$18,AL9)","v":40.268000000000001},null,{"$f":"IF((AN9<=$D$18),$D$18,AN9)","v":43.701000000000001},null,{"$f":"IF((AP9<=$D$18),$D$18,AP9)","v":47.134},null,{"$f":"IF((AR9<=$D$18),$D$18,AR9)","v":50.567},null,{"$f":"IF((AT9<=$D$18),$D$18,AT9)","v":54},null,{"$f":"IF((AV9<=$D$18),$D$18,AV9)","v":57.433},null,{"$f":"IF((AX9<=$D$18),$D$18,AX9)","v":60.866},null,{"$f":"IF((AZ9<=$D$18),$D$18,AZ9)","v":64.299000000000007},null,{"$f":"IF((BB9<=$D$18),$D$18,BB9)","v":67.731999999999999},null,{"$f":"IF((BD9<=$D$18),$D$18,BD9)","v":71.164999999999992},null,{"$f":"IF((BF9<=$D$18),$D$18,BF9)","v":75.214999999999989},null,{"$f":"IF((BH9<=$D$18),$D$18,BH9)","v":79.264999999999986},null,{"$f":"IF((BJ9<=$D$18),$D$18,BJ9)","v":83.314999999999998},null,{"$f":"IF((BL9<=$D$18),$D$18,BL9)","v":87.364999999999995},null,{"$f":"IF((BN9<=$D$18),$D$18,BN9)","v":91.414999999999992},null,{"$f":"IF((BP9<=$D$18),$D$18,BP9)","v":95.464999999999989},null,{"$f":"IF((BR9<=$D$18),$D$18,BR9)","v":99.514999999999986},null,{"$f":"IF((BT9<=$D$18),$D$18,BT9)","v":103.565},null,{"$f":"IF((BV9<=$D$18),$D$18,BV9)","v":107.61499999999998},null,{"$f":"IF((BX9<=$D$18),$D$18,BX9)","v":111.66499999999999},null,{"$f":"IF((BZ9<=$D$18),$D$18,BZ9)","v":115.71499999999999},null,{"$f":"IF((CB9<=$D$18),$D$18,CB9)","v":119.76499999999999},null,{"$f":"IF((CD9<=$D$18),$D$18,CD9)","v":123.815},null,{"$f":"IF((CF9<=$D$18),$D$18,CF9)","v":127.86499999999998},null,{"$f":"IF((CH9<=$D$18),$D$18,CH9)","v":131.91499999999999},null,{"$f":"IF((CJ9<=$D$18),$D$18,CJ9)","v":135.96499999999997},null,{"$f":"IF((CL9<=$D$18),$D$18,CL9)","v":140.01499999999999},null,{"$f":"IF((CN9<=$D$18),$D$18,CN9)","v":144.065},null,{"$f":"IF((CP9<=$D$18),$D$18,CP9)","v":148.11500000000001},null,{"$f":"IF((CR9<=$D$18),$D$18,CR9)","v":152.16499999999999},null,{"$f":"IF((CT9<=$D$18),$D$18,CT9)","v":156.21499999999997},null,{"$f":"IF((CV9<=$D$18),$D$18,CV9)","v":160.26499999999999},null,{"$f":"IF((CX9<=$D$18),$D$18,CX9)","v":164.315},null,{"$f":"IF((CZ9<=$D$18),$D$18,CZ9)","v":168.36499999999998},null,{"$f":"IF((DB9<=$D$18),$D$18,DB9)","v":172.41499999999999},null,{"$f":"IF(C2=0,0,IF((DD9<=$D$3),$D$3,IF(DD9>D3,DD9)))","v":0},null,null,null,null,null,"TOTAL",null,null,null,{"$f":"IF((DN9<=$D$18),$D$18,DN9)","v":2222.71}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F10","v":19.670000000000002},null,{"$f":"H10","v":19.670000000000002},null,{"$f":"J10","v":19.670000000000002},null,{"$f":"L10","v":19.670000000000002},null,{"$f":"N10","v":19.670000000000002},null,{"$f":"P10","v":19.670000000000002},null,{"$f":"R10","v":19.670000000000002},null,{"$f":"T10","v":19.670000000000002},null,{"$f":"V10","v":19.670000000000002},null,{"$f":"X10","v":19.670000000000002},null,{"$f":"Z10","v":19.670000000000002},null,{"$f":"AB10","v":23.103000000000002},null,{"$f":"AD10","v":26.536000000000001},null,{"$f":"AF10","v":29.969000000000001},null,{"$f":"AH10","v":33.402000000000001},null,{"$f":"AJ10","v":36.835000000000001},null,{"$f":"AL10","v":40.268000000000001},null,{"$f":"AN10","v":43.701000000000001},null,{"$f":"AP10","v":47.134},null,{"$f":"AR10","v":50.567},null,{"$f":"AT10","v":54},null,{"$f":"AV10","v":57.433},null,{"$f":"AX10","v":60.866},null,{"$f":"AZ10","v":64.299000000000007},null,{"$f":"BB10","v":67.731999999999999},null,{"$f":"BD10","v":71.164999999999992},null,{"$f":"BF10","v":75.214999999999989},null,{"$f":"BH10","v":79.264999999999986},null,{"$f":"BJ10","v":83.314999999999998},null,{"$f":"BL10","v":87.364999999999995},null,{"$f":"BN10","v":91.414999999999992},null,{"$f":"BP10","v":95.464999999999989},null,{"$f":"BR10","v":99.514999999999986},null,{"$f":"BT10","v":103.565},null,{"$f":"BV10","v":107.61499999999998},null,{"$f":"BX10","v":111.66499999999999},null,{"$f":"BZ10","v":115.71499999999999},null,{"$f":"CB10","v":119.76499999999999},null,{"$f":"CD10","v":123.815},null,{"$f":"CF10","v":127.86499999999998},null,{"$f":"CH10","v":131.91499999999999},null,{"$f":"CJ10","v":135.96499999999997},null,{"$f":"CL10","v":140.01499999999999},null,{"$f":"CN10","v":144.065},null,{"$f":"CP10","v":148.11500000000001},null,{"$f":"CR10","v":152.16499999999999},null,{"$f":"CT10","v":156.21499999999997},null,{"$f":"CV10","v":160.26499999999999},null,{"$f":"CX10","v":164.315},null,{"$f":"CZ10","v":168.36499999999998},null,{"$f":"DB10","v":172.41499999999999},null,{"$f":"DD10","v":0},null,null,null,null,null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"DN10","v":2222.71}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F11","v":19.670000000000002},null,{"$f":"H11","v":19.670000000000002},null,{"$f":"J11","v":19.670000000000002},null,{"$f":"L11","v":19.670000000000002},null,{"$f":"N11","v":19.670000000000002},null,{"$f":"P11","v":19.670000000000002},null,{"$f":"R11","v":19.670000000000002},null,{"$f":"T11","v":19.670000000000002},null,19.670000000000002,null,19.670000000000002,null,19.670000000000002,null,23.103000000000002,null,26.536000000000001,null,29.969000000000001,null,{"$f":"AH11","v":33.402000000000001},null,{"$f":"AJ11","v":36.835000000000001},null,{"$f":"AL11","v":40.268000000000001},null,{"$f":"AN11","v":43.701000000000001},null,47.134,null,50.567,null,{"$f":"AT11","v":54},null,{"$f":"AV11","v":57.433},null,{"$f":"AX11","v":60.866},null,{"$f":"AZ11","v":64.299000000000007},null,67.731999999999999,null,71.164999999999992,null,{"$f":"BF11","v":75.214999999999989},null,{"$f":"BH11","v":79.264999999999986},null,{"$f":"BJ11","v":83.314999999999998},null,{"$f":"BL11","v":87.364999999999995},null,91.414999999999992,null,95.464999999999989,null,{"$f":"BR11","v":99.514999999999986},null,{"$f":"BT11","v":103.565},null,{"$f":"BV11","v":107.61499999999998},null,{"$f":"BX11","v":111.66499999999999},null,115.71499999999999,null,119.76499999999999,null,{"$f":"CD11","v":123.815},null,{"$f":"CF11","v":127.86499999999998},null,{"$f":"CH11","v":131.91499999999999},null,{"$f":"CJ11","v":135.96499999999997},null,140.01499999999999,null,144.065,null,{"$f":"CP11","v":148.11500000000001},null,{"$f":"CR11","v":152.16499999999999},null,{"$f":"CT11","v":156.21499999999997},null,{"$f":"CV11","v":160.26499999999999},null,164.315,null,168.36499999999998,null,{"$f":"DB11","v":172.41499999999999},null,{"$f":"DD11*0.8","v":0},null,null,null,null,null,"FATURAMENTO ESGOTO 100%",null,null,null,2222.71]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F11+F12","v":39.340000000000003},null,{"$f":"H11+H12","v":39.340000000000003},null,{"$f":"J11+J12","v":39.340000000000003},null,{"$f":"L11+L12","v":39.340000000000003},null,{"$f":"N11+N12","v":39.340000000000003},null,{"$f":"P11+P12","v":39.340000000000003},null,{"$f":"R11+R12","v":39.340000000000003},null,{"$f":"T11+T12","v":39.340000000000003},null,{"$f":"V11+V12","v":39.340000000000003},null,{"$f":"X11+X12","v":39.340000000000003},null,{"$f":"Z11+Z12","v":39.340000000000003},null,{"$f":"AB11+AB12","v":46.206000000000003},null,{"$f":"AD11+AD12","v":53.072000000000003},null,{"$f":"AF11+AF12","v":59.938000000000002},null,{"$f":"AH11+AH12","v":66.804000000000002},null,{"$f":"AJ11+AJ12","v":73.67},null,{"$f":"AL11+AL12","v":80.536000000000001},null,{"$f":"AN11+AN12","v":87.402000000000001},null,{"$f":"AP11+AP12","v":94.268000000000001},null,{"$f":"AR11+AR12","v":101.134},null,{"$f":"AT11+AT12","v":108},null,{"$f":"AV11+AV12","v":114.866},null,{"$f":"AX11+AX12","v":121.732},null,{"$f":"AZ11+AZ12","v":128.59800000000001},null,{"$f":"BB11+BB12","v":135.464},null,{"$f":"BD11+BD12","v":142.32999999999998},null,{"$f":"BF11+BF12","v":150.42999999999998},null,{"$f":"BH11+BH12","v":158.52999999999997},null,{"$f":"BJ11+BJ12","v":166.63},null,{"$f":"BL11+BL12","v":174.73},null,{"$f":"BN11+BN12","v":182.82999999999998},null,{"$f":"BP11+BP12","v":190.92999999999998},null,{"$f":"BR11+BR12","v":199.02999999999997},null,{"$f":"BT11+BT12","v":207.13},null,{"$f":"BV11+BV12","v":215.22999999999996},null,{"$f":"BX11+BX12","v":223.32999999999998},null,{"$f":"BZ11+BZ12","v":231.42999999999998},null,{"$f":"CB11+CB12","v":239.52999999999997},null,{"$f":"CD11+CD12","v":247.63},null,{"$f":"CF11+CF12","v":255.72999999999996},null,{"$f":"CH11+CH12","v":263.83},null,{"$f":"CJ11+CJ12","v":271.92999999999995},null,{"$f":"CL11+CL12","v":280.02999999999997},null,{"$f":"CN11+CN12","v":288.13},null,{"$f":"CP11+CP12","v":296.23},null,{"$f":"CR11+CR12","v":304.33},null,{"$f":"CT11+CT12","v":312.42999999999995},null,{"$f":"CV11+CV12","v":320.52999999999997},null,{"$f":"CX11+CX12","v":328.63},null,{"$f":"CZ11+CZ12","v":336.72999999999996},null,{"$f":"DB11+DB12","v":344.83},null,{"$f":"DD11+DD12","v":0},null,null,null,null,null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"DN11+DN12","v":4445.42}]
[]
[]
["CONDOMÍNIO em BALNEÁRIO CAMBORIÚ (caso real)"]
[null,null,{"$f":"CALCULADORA!B6","v":0},"ECONOMIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["RESIDENCIAL  ","Consumo Mínimo",null,19.670000000000002,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,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,null,null,null,null,null,null,null,null,null,{"$f":"DC18-DC20-DC21","v":0},"consumo menos faixa 01 e 02"]
[null,0,10,1.9670000000000001,0,{"$f":"E20*$D$20","v":0},1,{"$f":"G20*$D$20","v":1.9670000000000001},2,{"$f":"I20*$D$20","v":3.9340000000000002},3,{"$f":"K20*$D$20","v":5.9009999999999998},4,{"$f":"M20*$D$20","v":7.8680000000000003},5,{"$f":"O20*$D$20","v":9.8350000000000009},6,{"$f":"Q20*$D$20","v":11.802},7,{"$f":"S20*$D$20","v":13.769},8,{"$f":"U20*$D$20","v":15.736000000000001},9,{"$f":"W20*$D$20","v":17.702999999999999},10,{"$f":"Y20*$D$20","v":19.670000000000002},10,{"$f":"AA20*$D$20","v":19.670000000000002},10,{"$f":"AC20*$D$20","v":19.670000000000002},10,{"$f":"AE20*$D$20","v":19.670000000000002},10,{"$f":"AG20*$D$20","v":19.670000000000002},10,{"$f":"AI20*$D$20","v":19.670000000000002},10,{"$f":"AK20*$D$20","v":19.670000000000002},10,{"$f":"AM20*$D$20","v":19.670000000000002},10,{"$f":"AO20*$D$20","v":19.670000000000002},10,{"$f":"AQ20*$D$20","v":19.670000000000002},10,{"$f":"AS20*$D$20","v":19.670000000000002},10,{"$f":"AU20*$D$20","v":19.670000000000002},10,{"$f":"AW20*$D$20","v":19.670000000000002},10,{"$f":"AY20*$D$20","v":19.670000000000002},10,{"$f":"BA20*$D$20","v":19.670000000000002},10,{"$f":"BC20*$D$20","v":19.670000000000002},10,{"$f":"BE20*$D$20","v":19.670000000000002},10,{"$f":"BG20*$D$20","v":19.670000000000002},10,{"$f":"BI20*$D$20","v":19.670000000000002},10,{"$f":"BK20*$D$20","v":19.670000000000002},10,{"$f":"BM20*$D$20","v":19.670000000000002},10,{"$f":"BO20*$D$20","v":19.670000000000002},10,{"$f":"BQ20*$D$20","v":19.670000000000002},10,{"$f":"BS20*$D$20","v":19.670000000000002},10,{"$f":"BU20*$D$20","v":19.670000000000002},10,{"$f":"BW20*$D$20","v":19.670000000000002},10,{"$f":"BY20*$D$20","v":19.670000000000002},10,{"$f":"CA20*$D$20","v":19.670000000000002},10,{"$f":"CC20*$D$20","v":19.670000000000002},10,{"$f":"CE20*$D$20","v":19.670000000000002},10,{"$f":"CG20*$D$20","v":19.670000000000002},10,{"$f":"CI20*$D$20","v":19.670000000000002},10,{"$f":"CK20*$D$20","v":19.670000000000002},10,{"$f":"CM20*$D$20","v":19.670000000000002},10,{"$f":"CO20*$D$20","v":19.670000000000002},10,{"$f":"CQ20*$D$20","v":19.670000000000002},10,{"$f":"CS20*$D$20","v":19.670000000000002},10,{"$f":"CU20*$D$20","v":19.670000000000002},10,{"$f":"CW20*$D$20","v":19.670000000000002},10,{"$f":"CY20*$D$20","v":19.670000000000002},10,{"$f":"DA20*$D$20","v":19.670000000000002},{"$f":"IF((DC18)<=10, DC18, 10)","v":0},{"$f":"DC20*$D$20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DC18-DC22-DC21-DC20","v":0},"consumo-faixa 01, 02 e 03"]
[null,11,25,3.4329999999999998,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":3.4329999999999998},2,{"$f":"AC21*$D$21","v":6.8659999999999997},3,{"$f":"AE21*$D$21","v":10.298999999999999},4,{"$f":"AG21*$D$21","v":13.731999999999999},5,{"$f":"AI21*$D$21","v":17.164999999999999},6,{"$f":"AK21*$D$21","v":20.597999999999999},7,{"$f":"AM21*$D$21","v":24.030999999999999},8,{"$f":"AO21*$D$21","v":27.463999999999999},9,{"$f":"AQ21*$D$21","v":30.896999999999998},10,{"$f":"AS21*$D$21","v":34.33},11,{"$f":"AU21*$D$21","v":37.762999999999998},12,{"$f":"AW21*$D$21","v":41.195999999999998},13,{"$f":"AY21*$D$21","v":44.628999999999998},14,{"$f":"BA21*$D$21","v":48.061999999999998},15,{"$f":"BC21*$D$21","v":51.494999999999997},15,{"$f":"BE21*$D$21","v":51.494999999999997},15,{"$f":"BG21*$D$21","v":51.494999999999997},15,{"$f":"BI21*$D$21","v":51.494999999999997},15,{"$f":"BK21*$D$21","v":51.494999999999997},15,{"$f":"BM21*$D$21","v":51.494999999999997},15,{"$f":"BO21*$D$21","v":51.494999999999997},15,{"$f":"BQ21*$D$21","v":51.494999999999997},15,{"$f":"BS21*$D$21","v":51.494999999999997},15,{"$f":"BU21*$D$21","v":51.494999999999997},15,{"$f":"BW21*$D$21","v":51.494999999999997},15,{"$f":"BY21*$D$21","v":51.494999999999997},15,{"$f":"CA21*$D$21","v":51.494999999999997},15,{"$f":"CC21*$D$21","v":51.494999999999997},15,{"$f":"CE21*$D$21","v":51.494999999999997},15,{"$f":"CG21*$D$21","v":51.494999999999997},15,{"$f":"CI21*$D$21","v":51.494999999999997},15,{"$f":"CK21*$D$21","v":51.494999999999997},15,{"$f":"CM21*$D$21","v":51.494999999999997},15,{"$f":"CO21*$D$21","v":51.494999999999997},15,{"$f":"CQ21*$D$21","v":51.494999999999997},15,{"$f":"CS21*$D$21","v":51.494999999999997},15,{"$f":"CU21*$D$21","v":51.494999999999997},15,{"$f":"CW21*$D$21","v":51.494999999999997},15,{"$f":"CY21*$D$21","v":51.494999999999997},15,{"$f":"DA21*$D$21","v":51.494999999999997},{"$f":"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,4.05,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":4.05},2,{"$f":"BG22*$D$22","v":8.1},3,{"$f":"BI22*$D$22","v":12.149999999999999},4,{"$f":"BK22*$D$22","v":16.2},5,{"$f":"BM22*$D$22","v":20.25},6,{"$f":"BO22*$D$22","v":24.299999999999997},7,{"$f":"BQ22*$D$22","v":28.349999999999998},8,{"$f":"BS22*$D$22","v":32.4},9,{"$f":"BU22*$D$22","v":36.449999999999996},10,{"$f":"BW22*$D$22","v":40.5},11,{"$f":"BY22*$D$22","v":44.55},12,{"$f":"CA22*$D$22","v":48.599999999999994},13,{"$f":"CC22*$D$22","v":52.65},14,{"$f":"CE22*$D$22","v":56.699999999999996},15,{"$f":"CG22*$D$22","v":60.75},16,{"$f":"CI22*$D$22","v":64.8},17,{"$f":"CK22*$D$22","v":68.849999999999994},18,{"$f":"CM22*$D$22","v":72.899999999999991},19,{"$f":"CO22*$D$22","v":76.95},20,{"$f":"CQ22*$D$22","v":81},21,{"$f":"CS22*$D$22","v":85.05},22,{"$f":"CU22*$D$22","v":89.1},23,{"$f":"CW22*$D$22","v":93.149999999999991},24,{"$f":"CY22*$D$22","v":97.199999999999989},25,{"$f":"DA22*$D$22","v":101.25},{"$f":"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,4.6900000000000004,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($DQ$20>0,$DQ$20)","v":false},{"$f":"DC23*$D$23","v":0}]
[null,"SUBTOTAL",null,null,null,{"$f":"SUM(F20:F23)","v":0},null,{"$f":"SUM(H20:H23)","v":1.9670000000000001},null,{"$f":"SUM(J20:J23)","v":3.9340000000000002},null,{"$f":"SUM(L20:L23)","v":5.9009999999999998},null,{"$f":"SUM(N20:N23)","v":7.8680000000000003},null,{"$f":"SUM(P20:P23)","v":9.8350000000000009},null,{"$f":"SUM(R20:R23)","v":11.802},null,{"$f":"SUM(T20:T23)","v":13.769},null,{"$f":"SUM(V20:V23)","v":15.736000000000001},null,{"$f":"SUM(X20:X23)","v":17.702999999999999},null,{"$f":"SUM(Z20:Z23)","v":19.670000000000002},null,{"$f":"SUM(AB20:AB23)","v":23.103000000000002},null,{"$f":"SUM(AD20:AD23)","v":26.536000000000001},null,{"$f":"SUM(AF20:AF23)","v":29.969000000000001},null,{"$f":"SUM(AH20:AH23)","v":33.402000000000001},null,{"$f":"SUM(AJ20:AJ23)","v":36.835000000000001},null,{"$f":"SUM(AL20:AL23)","v":40.268000000000001},null,{"$f":"SUM(AN20:AN23)","v":43.701000000000001},null,{"$f":"SUM(AP20:AP23)","v":47.134},null,{"$f":"SUM(AR20:AR23)","v":50.567},null,{"$f":"SUM(AT20:AT23)","v":54},null,{"$f":"SUM(AV20:AV23)","v":57.433},null,{"$f":"SUM(AX20:AX23)","v":60.866},null,{"$f":"SUM(AZ20:AZ23)","v":64.299000000000007},null,{"$f":"SUM(BB20:BB23)","v":67.731999999999999},null,{"$f":"SUM(BD20:BD23)","v":71.164999999999992},null,{"$f":"SUM(BF20:BF23)","v":75.214999999999989},null,{"$f":"SUM(BH20:BH23)","v":79.264999999999986},null,{"$f":"SUM(BJ20:BJ23)","v":83.314999999999998},null,{"$f":"SUM(BL20:BL23)","v":87.364999999999995},null,{"$f":"SUM(BN20:BN23)","v":91.414999999999992},null,{"$f":"SUM(BP20:BP23)","v":95.464999999999989},null,{"$f":"SUM(BR20:BR23)","v":99.514999999999986},null,{"$f":"SUM(BT20:BT23)","v":103.565},null,{"$f":"SUM(BV20:BV23)","v":107.61499999999998},null,{"$f":"SUM(BX20:BX23)","v":111.66499999999999},null,{"$f":"SUM(BZ20:BZ23)","v":115.71499999999999},null,{"$f":"SUM(CB20:CB23)","v":119.76499999999999},null,{"$f":"SUM(CD20:CD23)","v":123.815},null,{"$f":"SUM(CF20:CF23)","v":127.86499999999998},null,{"$f":"SUM(CH20:CH23)","v":131.91499999999999},null,135.96499999999997,null,140.01499999999999,null,144.065,null,148.11500000000001,null,152.16499999999999,null,156.21499999999997,null,{"$f":"SUM(CV20:CV23)","v":160.26499999999999},null,{"$f":"SUM(CX20:CX23)","v":164.315},null,{"$f":"SUM(CZ20:CZ23)","v":168.36499999999998},null,{"$f":"SUM(DB20:DB23)","v":172.41499999999999},null,0]
[null,"TOTAL",null,null,null,{"$f":"IF((F24<=$D$18),$D$18,F24)","v":19.670000000000002},null,{"$f":"IF((H24<=$D$18),$D$18,H24)","v":19.670000000000002},null,{"$f":"IF((J24<=$D$18),$D$18,J24)","v":19.670000000000002},null,{"$f":"IF((L24<=$D$18),$D$18,L24)","v":19.670000000000002},null,{"$f":"IF((N24<=$D$18),$D$18,N24)","v":19.670000000000002},null,{"$f":"IF((P24<=$D$18),$D$18,P24)","v":19.670000000000002},null,{"$f":"IF((R24<=$D$18),$D$18,R24)","v":19.670000000000002},null,{"$f":"IF((T24<=$D$18),$D$18,T24)","v":19.670000000000002},null,{"$f":"IF((V24<=$D$18),$D$18,V24)","v":19.670000000000002},null,{"$f":"IF((X24<=$D$18),$D$18,X24)","v":19.670000000000002},null,{"$f":"IF((Z24<=$D$18),$D$18,Z24)","v":19.670000000000002},null,{"$f":"IF((AB24<=$D$18),$D$18,AB24)","v":23.103000000000002},null,{"$f":"IF((AD24<=$D$18),$D$18,AD24)","v":26.536000000000001},null,{"$f":"IF((AF24<=$D$18),$D$18,AF24)","v":29.969000000000001},null,{"$f":"IF((AH24<=$D$18),$D$18,AH24)","v":33.402000000000001},null,{"$f":"IF((AJ24<=$D$18),$D$18,AJ24)","v":36.835000000000001},null,{"$f":"IF((AL24<=$D$18),$D$18,AL24)","v":40.268000000000001},null,{"$f":"IF((AN24<=$D$18),$D$18,AN24)","v":43.701000000000001},null,{"$f":"IF((AP24<=$D$18),$D$18,AP24)","v":47.134},null,{"$f":"IF((AR24<=$D$18),$D$18,AR24)","v":50.567},null,{"$f":"IF((AT24<=$D$18),$D$18,AT24)","v":54},null,{"$f":"IF((AV24<=$D$18),$D$18,AV24)","v":57.433},null,{"$f":"IF((AX24<=$D$18),$D$18,AX24)","v":60.866},null,{"$f":"IF((AZ24<=$D$18),$D$18,AZ24)","v":64.299000000000007},null,{"$f":"IF((BB24<=$D$18),$D$18,BB24)","v":67.731999999999999},null,{"$f":"IF((BD24<=$D$18),$D$18,BD24)","v":71.164999999999992},null,{"$f":"IF((BF24<=$D$18),$D$18,BF24)","v":75.214999999999989},null,{"$f":"IF((BH24<=$D$18),$D$18,BH24)","v":79.264999999999986},null,{"$f":"IF((BJ24<=$D$18),$D$18,BJ24)","v":83.314999999999998},null,{"$f":"IF((BL24<=$D$18),$D$18,BL24)","v":87.364999999999995},null,{"$f":"IF((BN24<=$D$18),$D$18,BN24)","v":91.414999999999992},null,{"$f":"IF((BP24<=$D$18),$D$18,BP24)","v":95.464999999999989},null,{"$f":"IF((BR24<=$D$18),$D$18,BR24)","v":99.514999999999986},null,{"$f":"IF((BT24<=$D$18),$D$18,BT24)","v":103.565},null,{"$f":"IF((BV24<=$D$18),$D$18,BV24)","v":107.61499999999998},null,{"$f":"IF((BX24<=$D$18),$D$18,BX24)","v":111.66499999999999},null,{"$f":"IF((BZ24<=$D$18),$D$18,BZ24)","v":115.71499999999999},null,{"$f":"IF((CB24<=$D$18),$D$18,CB24)","v":119.76499999999999},null,{"$f":"IF((CD24<=$D$18),$D$18,CD24)","v":123.815},null,{"$f":"IF((CF24<=$D$18),$D$18,CF24)","v":127.86499999999998},null,{"$f":"IF((CH24<=$D$18),$D$18,CH24)","v":131.91499999999999},null,135.96499999999997,null,140.01499999999999,null,144.065,null,148.11500000000001,null,152.16499999999999,null,156.21499999999997,null,{"$f":"IF((CV24<=$D$18),$D$18,CV24)","v":160.26499999999999},null,{"$f":"IF((CX24<=$D$18),$D$18,CX24)","v":164.315},null,{"$f":"IF((CZ24<=$D$18),$D$18,CZ24)","v":168.36499999999998},null,{"$f":"IF((DB24<=$D$18),$D$18,DB24)","v":172.41499999999999},null,{"$f":"IF(C17=0,0,IF((DD24<=$D$3),$D$3,IF(DD24>D18,DD24)))","v":0}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F25","v":19.670000000000002},null,{"$f":"H25","v":19.670000000000002},null,{"$f":"J25","v":19.670000000000002},null,{"$f":"L25","v":19.670000000000002},null,{"$f":"N25","v":19.670000000000002},null,{"$f":"P25","v":19.670000000000002},null,{"$f":"R25","v":19.670000000000002},null,{"$f":"T25","v":19.670000000000002},null,{"$f":"V25","v":19.670000000000002},null,{"$f":"X25","v":19.670000000000002},null,{"$f":"Z25","v":19.670000000000002},null,{"$f":"AB25","v":23.103000000000002},null,{"$f":"AD25","v":26.536000000000001},null,{"$f":"AF25","v":29.969000000000001},null,{"$f":"AH25","v":33.402000000000001},null,{"$f":"AJ25","v":36.835000000000001},null,{"$f":"AL25","v":40.268000000000001},null,{"$f":"AN25","v":43.701000000000001},null,{"$f":"AP25","v":47.134},null,{"$f":"AR25","v":50.567},null,{"$f":"AT25","v":54},null,{"$f":"AV25","v":57.433},null,{"$f":"AX25","v":60.866},null,{"$f":"AZ25","v":64.299000000000007},null,{"$f":"BB25","v":67.731999999999999},null,{"$f":"BD25","v":71.164999999999992},null,{"$f":"BF25","v":75.214999999999989},null,{"$f":"BH25","v":79.264999999999986},null,{"$f":"BJ25","v":83.314999999999998},null,{"$f":"BL25","v":87.364999999999995},null,{"$f":"BN25","v":91.414999999999992},null,{"$f":"BP25","v":95.464999999999989},null,{"$f":"BR25","v":99.514999999999986},null,{"$f":"BT25","v":103.565},null,{"$f":"BV25","v":107.61499999999998},null,{"$f":"BX25","v":111.66499999999999},null,{"$f":"BZ25","v":115.71499999999999},null,{"$f":"CB25","v":119.76499999999999},null,{"$f":"CD25","v":123.815},null,{"$f":"CF25","v":127.86499999999998},null,{"$f":"CH25","v":131.91499999999999},null,135.96499999999997,null,140.01499999999999,null,144.065,null,148.11500000000001,null,152.16499999999999,null,156.21499999999997,null,{"$f":"CV25","v":160.26499999999999},null,{"$f":"CX25","v":164.315},null,{"$f":"CZ25","v":168.36499999999998},null,{"$f":"DB25","v":172.41499999999999},null,{"$f":"DD25","v":0}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F26","v":19.670000000000002},null,{"$f":"H26","v":19.670000000000002},null,{"$f":"J26","v":19.670000000000002},null,{"$f":"L26","v":19.670000000000002},null,{"$f":"N26","v":19.670000000000002},null,{"$f":"P26","v":19.670000000000002},null,{"$f":"R26","v":19.670000000000002},null,{"$f":"T26","v":19.670000000000002},null,19.670000000000002,null,19.670000000000002,null,19.670000000000002,null,23.103000000000002,null,26.536000000000001,null,29.969000000000001,null,33.402000000000001,null,36.835000000000001,null,40.268000000000001,null,43.701000000000001,null,47.134,null,50.567,null,54,null,57.433,null,60.866,null,64.299000000000007,null,67.731999999999999,null,71.164999999999992,null,75.214999999999989,null,79.264999999999986,null,83.314999999999998,null,87.364999999999995,null,91.414999999999992,null,95.464999999999989,null,99.514999999999986,null,103.565,null,107.61499999999998,null,111.66499999999999,null,115.71499999999999,null,119.76499999999999,null,123.815,null,127.86499999999998,null,131.91499999999999,null,135.96499999999997,null,{"$f":"CL26","v":140.01499999999999},null,{"$f":"CN26","v":144.065},null,148.11500000000001,null,152.16499999999999,null,156.21499999999997,null,160.26499999999999,null,{"$f":"CX26","v":164.315},null,{"$f":"CZ26","v":168.36499999999998},null,172.41499999999999,null,{"$f":"DD26*0.8","v":0}]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F26+F27","v":39.340000000000003},null,{"$f":"H26+H27","v":39.340000000000003},null,{"$f":"J26+J27","v":39.340000000000003},null,{"$f":"L26+L27","v":39.340000000000003},null,{"$f":"N26+N27","v":39.340000000000003},null,{"$f":"P26+P27","v":39.340000000000003},null,{"$f":"R26+R27","v":39.340000000000003},null,{"$f":"T26+T27","v":39.340000000000003},null,{"$f":"V26+V27","v":39.340000000000003},null,{"$f":"X26+X27","v":39.340000000000003},null,{"$f":"Z26+Z27","v":39.340000000000003},null,{"$f":"AB26+AB27","v":46.206000000000003},null,{"$f":"AD26+AD27","v":53.072000000000003},null,{"$f":"AF26+AF27","v":59.938000000000002},null,{"$f":"AH26+AH27","v":66.804000000000002},null,{"$f":"AJ26+AJ27","v":73.67},null,{"$f":"AL26+AL27","v":80.536000000000001},null,{"$f":"AN26+AN27","v":87.402000000000001},null,{"$f":"AP26+AP27","v":94.268000000000001},null,{"$f":"AR26+AR27","v":101.134},null,{"$f":"AT26+AT27","v":108},null,{"$f":"AV26+AV27","v":114.866},null,{"$f":"AX26+AX27","v":121.732},null,{"$f":"AZ26+AZ27","v":128.59800000000001},null,{"$f":"BB26+BB27","v":135.464},null,{"$f":"BD26+BD27","v":142.32999999999998},null,{"$f":"BF26+BF27","v":150.42999999999998},null,{"$f":"BH26+BH27","v":158.52999999999997},null,{"$f":"BJ26+BJ27","v":166.63},null,{"$f":"BL26+BL27","v":174.73},null,{"$f":"BN26+BN27","v":182.82999999999998},null,{"$f":"BP26+BP27","v":190.92999999999998},null,{"$f":"BR26+BR27","v":199.02999999999997},null,{"$f":"BT26+BT27","v":207.13},null,{"$f":"BV26+BV27","v":215.22999999999996},null,{"$f":"BX26+BX27","v":223.32999999999998},null,{"$f":"BZ26+BZ27","v":231.42999999999998},null,{"$f":"CB26+CB27","v":239.52999999999997},null,{"$f":"CD26+CD27","v":247.63},null,{"$f":"CF26+CF27","v":255.72999999999996},null,{"$f":"CH26+CH27","v":263.83},null,271.92999999999995,null,280.02999999999997,null,288.13,null,296.23,null,304.33,null,312.42999999999995,null,{"$f":"CV26+CV27","v":320.52999999999997},null,{"$f":"CX26+CX27","v":328.63},null,{"$f":"CZ26+CZ27","v":336.72999999999996},null,{"$f":"DB26+DB27","v":344.83},null,{"$f":"DD26+DD27","v":0},null,null,null,null,{"$f":"DD28-DD13","v":0}]
[]
[]
[]
["CONDOMÍNIO em BALNEÁRIO CAMBORIÚ (caso real)"]
[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"]
["RESIDENCIAL  ","TFDI com RTP",null,28.69,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,11,0.48,0,{"$f":"E36*$D$20","v":0},1,{"$f":"G36*$D$20","v":1.9670000000000001},2,{"$f":"I36*$D$20","v":3.9340000000000002},3,{"$f":"K36*$D$20","v":5.9009999999999998},4,{"$f":"M36*$D$20","v":7.8680000000000003},5,{"$f":"O36*$D$20","v":9.8350000000000009},6,{"$f":"Q36*$D$20","v":11.802},7,{"$f":"S36*$D$20","v":13.769},8,{"$f":"U36*$D$20","v":15.736000000000001},9,{"$f":"W36*$D$20","v":17.702999999999999},10,{"$f":"Y36*$D$20","v":19.670000000000002},10,{"$f":"AA36*$D$20","v":19.670000000000002},10,{"$f":"AC36*$D$20","v":19.670000000000002},10,{"$f":"AE36*$D$20","v":19.670000000000002},10,{"$f":"AG36*$D$20","v":19.670000000000002},10,{"$f":"AI36*$D$20","v":19.670000000000002},10,{"$f":"AK36*$D$20","v":19.670000000000002},10,{"$f":"AM36*$D$20","v":19.670000000000002},10,{"$f":"AO36*$D$20","v":19.670000000000002},10,{"$f":"AQ36*$D$20","v":19.670000000000002},10,{"$f":"AS36*$D$20","v":19.670000000000002},10,{"$f":"AU36*$D$20","v":19.670000000000002},10,{"$f":"AW36*$D$20","v":19.670000000000002},10,{"$f":"AY36*$D$20","v":19.670000000000002},10,{"$f":"BA36*$D$20","v":19.670000000000002},10,{"$f":"BC36*$D$20","v":19.670000000000002},10,{"$f":"BE36*$D$20","v":19.670000000000002},10,{"$f":"BG36*$D$20","v":19.670000000000002},10,{"$f":"BI36*$D$20","v":19.670000000000002},10,{"$f":"BK36*$D$20","v":19.670000000000002},10,{"$f":"BM36*$D$20","v":19.670000000000002},10,{"$f":"BO36*$D$20","v":19.670000000000002},10,{"$f":"BQ36*$D$20","v":19.670000000000002},10,{"$f":"BS36*$D$20","v":19.670000000000002},10,{"$f":"BU36*$D$20","v":19.670000000000002},10,{"$f":"BW36*$D$20","v":19.670000000000002},10,{"$f":"BY36*$D$20","v":19.670000000000002},10,{"$f":"CA36*$D$20","v":19.670000000000002},10,{"$f":"CC36*$D$20","v":19.670000000000002},10,{"$f":"CE36*$D$20","v":19.670000000000002},10,{"$f":"CG36*$D$20","v":19.670000000000002},10,{"$f":"CI36*$D$20","v":19.670000000000002},10,{"$f":"CK36*$D$20","v":19.670000000000002},10,{"$f":"CM36*$D$20","v":19.670000000000002},10,{"$f":"CO36*$D$20","v":19.670000000000002},10,{"$f":"CQ36*$D$20","v":19.670000000000002},10,{"$f":"CS36*$D$20","v":19.670000000000002},10,{"$f":"CU36*$D$20","v":19.670000000000002},10,{"$f":"CW36*$D$20","v":19.670000000000002},10,{"$f":"CY36*$D$20","v":19.670000000000002},10,{"$f":"DA36*$D$20","v":19.670000000000002},{"$f":"IF((DC34)<=DQ36, DC34,DQ36)","v":0},{"$f":"DC36*$D$36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*C33","v":0},"consumo faixa 01"]
[null,11,26,3.16,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":3.4329999999999998},2,{"$f":"AC37*$D$21","v":6.8659999999999997},3,{"$f":"AE37*$D$21","v":10.298999999999999},4,{"$f":"AG37*$D$21","v":13.731999999999999},5,{"$f":"AI37*$D$21","v":17.164999999999999},6,{"$f":"AK37*$D$21","v":20.597999999999999},7,{"$f":"AM37*$D$21","v":24.030999999999999},8,{"$f":"AO37*$D$21","v":27.463999999999999},9,{"$f":"AQ37*$D$21","v":30.896999999999998},10,{"$f":"AS37*$D$21","v":34.33},11,{"$f":"AU37*$D$21","v":37.762999999999998},12,{"$f":"AW37*$D$21","v":41.195999999999998},13,{"$f":"AY37*$D$21","v":44.628999999999998},14,{"$f":"BA37*$D$21","v":48.061999999999998},15,{"$f":"BC37*$D$21","v":51.494999999999997},15,{"$f":"BE37*$D$21","v":51.494999999999997},15,{"$f":"BG37*$D$21","v":51.494999999999997},15,{"$f":"BI37*$D$21","v":51.494999999999997},15,{"$f":"BK37*$D$21","v":51.494999999999997},15,{"$f":"BM37*$D$21","v":51.494999999999997},15,{"$f":"BO37*$D$21","v":51.494999999999997},15,{"$f":"BQ37*$D$21","v":51.494999999999997},15,{"$f":"BS37*$D$21","v":51.494999999999997},15,{"$f":"BU37*$D$21","v":51.494999999999997},15,{"$f":"BW37*$D$21","v":51.494999999999997},15,{"$f":"BY37*$D$21","v":51.494999999999997},15,{"$f":"CA37*$D$21","v":51.494999999999997},15,{"$f":"CC37*$D$21","v":51.494999999999997},15,{"$f":"CE37*$D$21","v":51.494999999999997},15,{"$f":"CG37*$D$21","v":51.494999999999997},15,{"$f":"CI37*$D$21","v":51.494999999999997},15,{"$f":"CK37*$D$21","v":51.494999999999997},15,{"$f":"CM37*$D$21","v":51.494999999999997},15,{"$f":"CO37*$D$21","v":51.494999999999997},15,{"$f":"CQ37*$D$21","v":51.494999999999997},15,{"$f":"CS37*$D$21","v":51.494999999999997},15,{"$f":"CU37*$D$21","v":51.494999999999997},15,{"$f":"CW37*$D$21","v":51.494999999999997},15,{"$f":"CY37*$D$21","v":51.494999999999997},15,{"$f":"DA37*$D$21","v":51.494999999999997},{"$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,null,null,null,null,null,null,null,null,null,{"$f":"15*C33","v":0},"consumo faixa 02"]
[null,"≥ 25",null,4.33,null,{"$f":"E38*$D$23","v":0},null,{"$f":"G38*$D$23","v":0},null,{"$f":"I38*$D$23","v":0},null,{"$f":"K38*$D$23","v":0},null,{"$f":"M38*$D$23","v":0},null,{"$f":"O38*$D$23","v":0},null,{"$f":"Q38*$D$23","v":0},null,{"$f":"S38*$D$23","v":0},null,{"$f":"U38*$D$23","v":0},null,{"$f":"W38*$D$23","v":0},null,{"$f":"Y38*$D$23","v":0},null,{"$f":"AA38*$D$23","v":0},null,{"$f":"AC38*$D$23","v":0},null,{"$f":"AE38*$D$23","v":0},null,{"$f":"AG38*$D$23","v":0},null,{"$f":"AI38*$D$23","v":0},null,{"$f":"AK38*$D$23","v":0},null,{"$f":"AM38*$D$23","v":0},null,{"$f":"AO38*$D$23","v":0},null,{"$f":"AQ38*$D$23","v":0},null,{"$f":"AS38*$D$23","v":0},null,{"$f":"AU38*$D$23","v":0},null,{"$f":"AW38*$D$23","v":0},null,{"$f":"AY38*$D$23","v":0},null,{"$f":"BA38*$D$23","v":0},null,{"$f":"BC38*$D$23","v":0},null,{"$f":"BE38*$D$23","v":0},null,{"$f":"BG38*$D$23","v":0},null,{"$f":"BI38*$D$23","v":0},null,{"$f":"BK38*$D$23","v":0},null,{"$f":"BM38*$D$23","v":0},null,{"$f":"BO38*$D$23","v":0},null,{"$f":"BQ38*$D$23","v":0},null,{"$f":"BS38*$D$23","v":0},null,{"$f":"BU38*$D$23","v":0},null,{"$f":"BW38*$D$23","v":0},null,{"$f":"BY38*$D$23","v":0},null,{"$f":"CA38*$D$23","v":0},null,{"$f":"CC38*$D$23","v":0},null,{"$f":"CE38*$D$23","v":0},null,{"$f":"CG38*$D$23","v":0},null,{"$f":"CI38*$D$23","v":0},null,{"$f":"CK38*$D$23","v":0},null,{"$f":"CM38*$D$23","v":0},null,{"$f":"CO38*$D$23","v":0},null,{"$f":"CQ38*$D$23","v":0},null,{"$f":"CS38*$D$23","v":0},null,{"$f":"CU38*$D$23","v":0},null,{"$f":"CW38*$D$23","v":0},null,{"$f":"CY38*$D$23","v":0},null,{"$f":"DA38*$D$23","v":0},{"$f":"IF($DQ$38>0,$DQ$38)","v":false},{"$f":"DC38*$D$38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DC34-DQ36-DQ37","v":0},"consumo acima da faixa 03"]
[null,"TOTAL CONSUMO",null,null,null,{"$f":"SUM(F36:F38)","v":0},null,{"$f":"SUM(H36:H38)","v":1.9670000000000001},null,{"$f":"SUM(J36:J38)","v":3.9340000000000002},null,{"$f":"SUM(L36:L38)","v":5.9009999999999998},null,{"$f":"SUM(N36:N38)","v":7.8680000000000003},null,{"$f":"SUM(P36:P38)","v":9.8350000000000009},null,{"$f":"SUM(R36:R38)","v":11.802},null,{"$f":"SUM(T36:T38)","v":13.769},null,{"$f":"SUM(V36:V38)","v":15.736000000000001},null,{"$f":"SUM(X36:X38)","v":17.702999999999999},null,{"$f":"SUM(Z36:Z38)","v":19.670000000000002},null,{"$f":"SUM(AB36:AB38)","v":23.103000000000002},null,{"$f":"SUM(AD36:AD38)","v":26.536000000000001},null,{"$f":"SUM(AF36:AF38)","v":29.969000000000001},null,{"$f":"SUM(AH36:AH38)","v":33.402000000000001},null,{"$f":"SUM(AJ36:AJ38)","v":36.835000000000001},null,{"$f":"SUM(AL36:AL38)","v":40.268000000000001},null,{"$f":"SUM(AN36:AN38)","v":43.701000000000001},null,{"$f":"SUM(AP36:AP38)","v":47.134},null,{"$f":"SUM(AR36:AR38)","v":50.567},null,{"$f":"SUM(AT36:AT38)","v":54},null,{"$f":"SUM(AV36:AV38)","v":57.433},null,{"$f":"SUM(AX36:AX38)","v":60.866},null,{"$f":"SUM(AZ36:AZ38)","v":64.299000000000007},null,{"$f":"SUM(BB36:BB38)","v":67.731999999999999},null,{"$f":"SUM(BD36:BD38)","v":71.164999999999992},null,{"$f":"SUM(BF36:BF38)","v":71.164999999999992},null,{"$f":"SUM(BH36:BH38)","v":71.164999999999992},null,{"$f":"SUM(BJ36:BJ38)","v":71.164999999999992},null,{"$f":"SUM(BL36:BL38)","v":71.164999999999992},null,{"$f":"SUM(BN36:BN38)","v":71.164999999999992},null,{"$f":"SUM(BP36:BP38)","v":71.164999999999992},null,{"$f":"SUM(BR36:BR38)","v":71.164999999999992},null,{"$f":"SUM(BT36:BT38)","v":71.164999999999992},null,{"$f":"SUM(BV36:BV38)","v":71.164999999999992},null,{"$f":"SUM(BX36:BX38)","v":71.164999999999992},null,{"$f":"SUM(BZ36:BZ38)","v":71.164999999999992},null,{"$f":"SUM(CB36:CB38)","v":71.164999999999992},null,{"$f":"SUM(CD36:CD38)","v":71.164999999999992},null,{"$f":"SUM(CF36:CF38)","v":71.164999999999992},null,{"$f":"SUM(CH36:CH38)","v":71.164999999999992},null,{"$f":"SUM(CJ36:CJ38)","v":71.164999999999992},null,{"$f":"SUM(CL36:CL38)","v":71.164999999999992},null,{"$f":"SUM(CN36:CN38)","v":71.164999999999992},null,{"$f":"SUM(CP36:CP38)","v":71.164999999999992},null,{"$f":"SUM(CR36:CR38)","v":71.164999999999992},null,{"$f":"SUM(CT36:CT38)","v":71.164999999999992},null,{"$f":"SUM(CV36:CV38)","v":71.164999999999992},null,{"$f":"SUM(CX36:CX38)","v":71.164999999999992},null,{"$f":"SUM(CZ36:CZ38)","v":71.164999999999992},null,{"$f":"SUM(DB36:DB38)","v":71.164999999999992},null,{"$f":"SUM(DD36:DD38)","v":0}]
[null,"TOTAL TFDI UNIDADES",null,null,null,{"$f":"IF((F39<=$D$18),$D$18,F39)","v":19.670000000000002},null,{"$f":"IF((H39<=$D$18),$D$18,H39)","v":19.670000000000002},null,{"$f":"IF((J39<=$D$18),$D$18,J39)","v":19.670000000000002},null,{"$f":"IF((L39<=$D$18),$D$18,L39)","v":19.670000000000002},null,{"$f":"IF((N39<=$D$18),$D$18,N39)","v":19.670000000000002},null,{"$f":"IF((P39<=$D$18),$D$18,P39)","v":19.670000000000002},null,{"$f":"IF((R39<=$D$18),$D$18,R39)","v":19.670000000000002},null,{"$f":"IF((T39<=$D$18),$D$18,T39)","v":19.670000000000002},null,{"$f":"IF((V39<=$D$18),$D$18,V39)","v":19.670000000000002},null,{"$f":"IF((X39<=$D$18),$D$18,X39)","v":19.670000000000002},null,{"$f":"IF((Z39<=$D$18),$D$18,Z39)","v":19.670000000000002},null,{"$f":"IF((AB39<=$D$18),$D$18,AB39)","v":23.103000000000002},null,{"$f":"IF((AD39<=$D$18),$D$18,AD39)","v":26.536000000000001},null,{"$f":"IF((AF39<=$D$18),$D$18,AF39)","v":29.969000000000001},null,{"$f":"IF((AH39<=$D$18),$D$18,AH39)","v":33.402000000000001},null,{"$f":"IF((AJ39<=$D$18),$D$18,AJ39)","v":36.835000000000001},null,{"$f":"IF((AL39<=$D$18),$D$18,AL39)","v":40.268000000000001},null,{"$f":"IF((AN39<=$D$18),$D$18,AN39)","v":43.701000000000001},null,{"$f":"IF((AP39<=$D$18),$D$18,AP39)","v":47.134},null,{"$f":"IF((AR39<=$D$18),$D$18,AR39)","v":50.567},null,{"$f":"IF((AT39<=$D$18),$D$18,AT39)","v":54},null,{"$f":"IF((AV39<=$D$18),$D$18,AV39)","v":57.433},null,{"$f":"IF((AX39<=$D$18),$D$18,AX39)","v":60.866},null,{"$f":"IF((AZ39<=$D$18),$D$18,AZ39)","v":64.299000000000007},null,{"$f":"IF((BB39<=$D$18),$D$18,BB39)","v":67.731999999999999},null,{"$f":"IF((BD39<=$D$18),$D$18,BD39)","v":71.164999999999992},null,{"$f":"IF((BF39<=$D$18),$D$18,BF39)","v":71.164999999999992},null,{"$f":"IF((BH39<=$D$18),$D$18,BH39)","v":71.164999999999992},null,{"$f":"IF((BJ39<=$D$18),$D$18,BJ39)","v":71.164999999999992},null,{"$f":"IF((BL39<=$D$18),$D$18,BL39)","v":71.164999999999992},null,{"$f":"IF((BN39<=$D$18),$D$18,BN39)","v":71.164999999999992},null,{"$f":"IF((BP39<=$D$18),$D$18,BP39)","v":71.164999999999992},null,{"$f":"IF((BR39<=$D$18),$D$18,BR39)","v":71.164999999999992},null,{"$f":"IF((BT39<=$D$18),$D$18,BT39)","v":71.164999999999992},null,{"$f":"IF((BV39<=$D$18),$D$18,BV39)","v":71.164999999999992},null,{"$f":"IF((BX39<=$D$18),$D$18,BX39)","v":71.164999999999992},null,{"$f":"IF((BZ39<=$D$18),$D$18,BZ39)","v":71.164999999999992},null,{"$f":"IF((CB39<=$D$18),$D$18,CB39)","v":71.164999999999992},null,{"$f":"IF((CD39<=$D$18),$D$18,CD39)","v":71.164999999999992},null,{"$f":"IF((CF39<=$D$18),$D$18,CF39)","v":71.164999999999992},null,{"$f":"IF((CH39<=$D$18),$D$18,CH39)","v":71.164999999999992},null,{"$f":"IF((CJ39<=$D$18),$D$18,CJ39)","v":71.164999999999992},null,{"$f":"IF((CL39<=$D$18),$D$18,CL39)","v":71.164999999999992},null,{"$f":"IF((CN39<=$D$18),$D$18,CN39)","v":71.164999999999992},null,{"$f":"IF((CP39<=$D$18),$D$18,CP39)","v":71.164999999999992},null,{"$f":"IF((CR39<=$D$18),$D$18,CR39)","v":71.164999999999992},null,{"$f":"IF((CT39<=$D$18),$D$18,CT39)","v":71.164999999999992},null,{"$f":"IF((CV39<=$D$18),$D$18,CV39)","v":71.164999999999992},null,{"$f":"IF((CX39<=$D$18),$D$18,CX39)","v":71.164999999999992},null,{"$f":"IF((CZ39<=$D$18),$D$18,CZ39)","v":71.164999999999992},null,{"$f":"IF((DB39<=$D$18),$D$18,DB39)","v":71.164999999999992},null,{"$f":"D34*C33","v":0}]
[null,"FATURAMENTO ESGOTO 80% DO CONSUMO",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"DD39*0.8","v":0},null,"Diferença de R$ 819,78 em relação à primeira tabela (atual-sem a jurisprudência)",null,null,{"$f":"DD42-DD13","v":0}]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"#REF!+F41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+H41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+J41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+L41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+N41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+P41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+R41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+T41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+V41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+X41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+Z41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AB41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AD41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AF41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AH41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AJ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AL41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AN41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AP41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AR41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AT41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AV41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AX41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+AZ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BB41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BD41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BF41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BH41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BJ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BL41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BN41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BP41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BR41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BT41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BV41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BX41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+BZ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CB41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CD41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CF41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CH41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CJ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CL41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CN41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CP41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CR41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CT41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CV41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CX41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+CZ41","v":{"$error":"#REF!"}},null,{"$f":"#REF!+DB41","v":{"$error":"#REF!"}},null,{"$f":"DD39+DD40+DD41","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":"E51*$D$20","v":0},1,{"$f":"G51*$D$20","v":1.9670000000000001},2,{"$f":"I51*$D$20","v":3.9340000000000002},3,{"$f":"K51*$D$20","v":5.9009999999999998},4,{"$f":"M51*$D$20","v":7.8680000000000003},5,{"$f":"O51*$D$20","v":9.8350000000000009},6,{"$f":"Q51*$D$20","v":11.802},7,{"$f":"S51*$D$20","v":13.769},8,{"$f":"U51*$D$20","v":15.736000000000001},9,{"$f":"W51*$D$20","v":17.702999999999999},10,{"$f":"Y51*$D$20","v":19.670000000000002},10,{"$f":"AA51*$D$20","v":19.670000000000002},10,{"$f":"AC51*$D$20","v":19.670000000000002},10,{"$f":"AE51*$D$20","v":19.670000000000002},10,{"$f":"AG51*$D$20","v":19.670000000000002},10,{"$f":"AI51*$D$20","v":19.670000000000002},10,{"$f":"AK51*$D$20","v":19.670000000000002},10,{"$f":"AM51*$D$20","v":19.670000000000002},10,{"$f":"AO51*$D$20","v":19.670000000000002},10,{"$f":"AQ51*$D$20","v":19.670000000000002},10,{"$f":"AS51*$D$20","v":19.670000000000002},10,{"$f":"AU51*$D$20","v":19.670000000000002},10,{"$f":"AW51*$D$20","v":19.670000000000002},10,{"$f":"AY51*$D$20","v":19.670000000000002},10,{"$f":"BA51*$D$20","v":19.670000000000002},10,{"$f":"BC51*$D$20","v":19.670000000000002},10,{"$f":"BE51*$D$20","v":19.670000000000002},10,{"$f":"BG51*$D$20","v":19.670000000000002},10,{"$f":"BI51*$D$20","v":19.670000000000002},10,{"$f":"BK51*$D$20","v":19.670000000000002},10,{"$f":"BM51*$D$20","v":19.670000000000002},10,{"$f":"BO51*$D$20","v":19.670000000000002},10,{"$f":"BQ51*$D$20","v":19.670000000000002},10,{"$f":"BS51*$D$20","v":19.670000000000002},10,{"$f":"BU51*$D$20","v":19.670000000000002},10,{"$f":"BW51*$D$20","v":19.670000000000002},10,{"$f":"BY51*$D$20","v":19.670000000000002},10,{"$f":"CA51*$D$20","v":19.670000000000002},10,{"$f":"CC51*$D$20","v":19.670000000000002},10,{"$f":"CE51*$D$20","v":19.670000000000002},10,{"$f":"CG51*$D$20","v":19.670000000000002},10,{"$f":"CI51*$D$20","v":19.670000000000002},10,{"$f":"CK51*$D$20","v":19.670000000000002},10,{"$f":"CM51*$D$20","v":19.670000000000002},10,{"$f":"CO51*$D$20","v":19.670000000000002},10,{"$f":"CQ51*$D$20","v":19.670000000000002},10,{"$f":"CS51*$D$20","v":19.670000000000002},10,{"$f":"CU51*$D$20","v":19.670000000000002},10,{"$f":"CW51*$D$20","v":19.670000000000002},10,{"$f":"CY51*$D$20","v":19.670000000000002},10,{"$f":"DA51*$D$20","v":19.670000000000002},1080,{"$f":"DC51*$D$51","v":2084.4},null,"Simulação nova estrutura tarifária"]
[null,11,26,8.64,null,{"$f":"E52*$D$21","v":0},null,{"$f":"G52*$D$21","v":0},null,{"$f":"I52*$D$21","v":0},null,{"$f":"K52*$D$21","v":0},null,{"$f":"M52*$D$21","v":0},null,{"$f":"O52*$D$21","v":0},null,{"$f":"Q52*$D$21","v":0},null,{"$f":"S52*$D$21","v":0},null,{"$f":"U52*$D$21","v":0},null,{"$f":"W52*$D$21","v":0},null,{"$f":"Y52*$D$21","v":0},1,{"$f":"AA52*$D$21","v":3.4329999999999998},2,{"$f":"AC52*$D$21","v":6.8659999999999997},3,{"$f":"AE52*$D$21","v":10.298999999999999},4,{"$f":"AG52*$D$21","v":13.731999999999999},5,{"$f":"AI52*$D$21","v":17.164999999999999},6,{"$f":"AK52*$D$21","v":20.597999999999999},7,{"$f":"AM52*$D$21","v":24.030999999999999},8,{"$f":"AO52*$D$21","v":27.463999999999999},9,{"$f":"AQ52*$D$21","v":30.896999999999998},10,{"$f":"AS52*$D$21","v":34.33},11,{"$f":"AU52*$D$21","v":37.762999999999998},12,{"$f":"AW52*$D$21","v":41.195999999999998},13,{"$f":"AY52*$D$21","v":44.628999999999998},14,{"$f":"BA52*$D$21","v":48.061999999999998},15,{"$f":"BC52*$D$21","v":51.494999999999997},15,{"$f":"BE52*$D$21","v":51.494999999999997},15,{"$f":"BG52*$D$21","v":51.494999999999997},15,{"$f":"BI52*$D$21","v":51.494999999999997},15,{"$f":"BK52*$D$21","v":51.494999999999997},15,{"$f":"BM52*$D$21","v":51.494999999999997},15,{"$f":"BO52*$D$21","v":51.494999999999997},15,{"$f":"BQ52*$D$21","v":51.494999999999997},15,{"$f":"BS52*$D$21","v":51.494999999999997},15,{"$f":"BU52*$D$21","v":51.494999999999997},15,{"$f":"BW52*$D$21","v":51.494999999999997},15,{"$f":"BY52*$D$21","v":51.494999999999997},15,{"$f":"CA52*$D$21","v":51.494999999999997},15,{"$f":"CC52*$D$21","v":51.494999999999997},15,{"$f":"CE52*$D$21","v":51.494999999999997},15,{"$f":"CG52*$D$21","v":51.494999999999997},15,{"$f":"CI52*$D$21","v":51.494999999999997},15,{"$f":"CK52*$D$21","v":51.494999999999997},15,{"$f":"CM52*$D$21","v":51.494999999999997},15,{"$f":"CO52*$D$21","v":51.494999999999997},15,{"$f":"CQ52*$D$21","v":51.494999999999997},15,{"$f":"CS52*$D$21","v":51.494999999999997},15,{"$f":"CU52*$D$21","v":51.494999999999997},15,{"$f":"CW52*$D$21","v":51.494999999999997},15,{"$f":"CY52*$D$21","v":51.494999999999997},15,{"$f":"DA52*$D$21","v":51.494999999999997},null,{"$f":"DC52*$D$37","v":0}]
[null,26,51,12.12,null,{"$f":"E53*$D$22","v":0},null,{"$f":"G53*$D$22","v":0},null,{"$f":"I53*$D$22","v":0},null,{"$f":"K53*$D$22","v":0},null,{"$f":"M53*$D$22","v":0},null,{"$f":"O53*$D$22","v":0},null,{"$f":"Q53*$D$22","v":0},null,{"$f":"S53*$D$22","v":0},null,{"$f":"U53*$D$22","v":0},null,{"$f":"W53*$D$22","v":0},null,{"$f":"Y53*$D$22","v":0},null,{"$f":"AA53*$D$22","v":0},null,{"$f":"AC53*$D$22","v":0},null,{"$f":"AE53*$D$22","v":0},null,{"$f":"AG53*$D$22","v":0},null,{"$f":"AI53*$D$22","v":0},null,{"$f":"AK53*$D$22","v":0},null,{"$f":"AM53*$D$22","v":0},null,{"$f":"AO53*$D$22","v":0},null,{"$f":"AQ53*$D$22","v":0},null,{"$f":"AS53*$D$22","v":0},null,{"$f":"AU53*$D$22","v":0},null,{"$f":"AW53*$D$22","v":0},null,{"$f":"AY53*$D$22","v":0},null,{"$f":"BA53*$D$22","v":0},null,{"$f":"BC53*$D$22","v":0},1,{"$f":"BE53*$D$22","v":4.05},2,{"$f":"BG53*$D$22","v":8.1},3,{"$f":"BI53*$D$22","v":12.149999999999999},4,{"$f":"BK53*$D$22","v":16.2},5,{"$f":"BM53*$D$22","v":20.25},6,{"$f":"BO53*$D$22","v":24.299999999999997},7,{"$f":"BQ53*$D$22","v":28.349999999999998},8,{"$f":"BS53*$D$22","v":32.4},9,{"$f":"BU53*$D$22","v":36.449999999999996},10,{"$f":"BW53*$D$22","v":40.5},11,{"$f":"BY53*$D$22","v":44.55},12,{"$f":"CA53*$D$22","v":48.599999999999994},13,{"$f":"CC53*$D$22","v":52.65},14,{"$f":"CE53*$D$22","v":56.699999999999996},15,{"$f":"CG53*$D$22","v":60.75},16,{"$f":"CI53*$D$22","v":64.8},17,{"$f":"CK53*$D$22","v":68.849999999999994},18,{"$f":"CM53*$D$22","v":72.899999999999991},19,{"$f":"CO53*$D$22","v":76.95},20,{"$f":"CQ53*$D$22","v":81},21,{"$f":"CS53*$D$22","v":85.05},22,{"$f":"CU53*$D$22","v":89.1},23,{"$f":"CW53*$D$22","v":93.149999999999991},24,{"$f":"CY53*$D$22","v":97.199999999999989},25,{"$f":"DA53*$D$22","v":101.25},null,{"$f":"DC53*#REF!","v":{"$error":"#REF!"}}]
[null,51,9999,15.19,null,{"$f":"E54*$D$23","v":0},null,{"$f":"G54*$D$23","v":0},null,{"$f":"I54*$D$23","v":0},null,{"$f":"K54*$D$23","v":0},null,{"$f":"M54*$D$23","v":0},null,{"$f":"O54*$D$23","v":0},null,{"$f":"Q54*$D$23","v":0},null,{"$f":"S54*$D$23","v":0},null,{"$f":"U54*$D$23","v":0},null,{"$f":"W54*$D$23","v":0},null,{"$f":"Y54*$D$23","v":0},null,{"$f":"AA54*$D$23","v":0},null,{"$f":"AC54*$D$23","v":0},null,{"$f":"AE54*$D$23","v":0},null,{"$f":"AG54*$D$23","v":0},null,{"$f":"AI54*$D$23","v":0},null,{"$f":"AK54*$D$23","v":0},null,{"$f":"AM54*$D$23","v":0},null,{"$f":"AO54*$D$23","v":0},null,{"$f":"AQ54*$D$23","v":0},null,{"$f":"AS54*$D$23","v":0},null,{"$f":"AU54*$D$23","v":0},null,{"$f":"AW54*$D$23","v":0},null,{"$f":"AY54*$D$23","v":0},null,{"$f":"BA54*$D$23","v":0},null,{"$f":"BC54*$D$23","v":0},null,{"$f":"BE54*$D$23","v":0},null,{"$f":"BG54*$D$23","v":0},null,{"$f":"BI54*$D$23","v":0},null,{"$f":"BK54*$D$23","v":0},null,{"$f":"BM54*$D$23","v":0},null,{"$f":"BO54*$D$23","v":0},null,{"$f":"BQ54*$D$23","v":0},null,{"$f":"BS54*$D$23","v":0},null,{"$f":"BU54*$D$23","v":0},null,{"$f":"BW54*$D$23","v":0},null,{"$f":"BY54*$D$23","v":0},null,{"$f":"CA54*$D$23","v":0},null,{"$f":"CC54*$D$23","v":0},null,{"$f":"CE54*$D$23","v":0},null,{"$f":"CG54*$D$23","v":0},null,{"$f":"CI54*$D$23","v":0},null,{"$f":"CK54*$D$23","v":0},null,{"$f":"CM54*$D$23","v":0},null,{"$f":"CO54*$D$23","v":0},null,{"$f":"CQ54*$D$23","v":0},null,{"$f":"CS54*$D$23","v":0},null,{"$f":"CU54*$D$23","v":0},null,{"$f":"CW54*$D$23","v":0},null,{"$f":"CY54*$D$23","v":0},null,{"$f":"DA54*$D$23","v":0},null,{"$f":"DC54*$D$38","v":0}]
[null,"TOTAL CONSUMO",null,null,null,{"$f":"SUM(F51:F54)","v":0},null,{"$f":"SUM(H51:H54)","v":1.9670000000000001},null,{"$f":"SUM(J51:J54)","v":3.9340000000000002},null,{"$f":"SUM(L51:L54)","v":5.9009999999999998},null,{"$f":"SUM(N51:N54)","v":7.8680000000000003},null,{"$f":"SUM(P51:P54)","v":9.8350000000000009},null,{"$f":"SUM(R51:R54)","v":11.802},null,{"$f":"SUM(T51:T54)","v":13.769},null,{"$f":"SUM(V51:V54)","v":15.736000000000001},null,{"$f":"SUM(X51:X54)","v":17.702999999999999},null,{"$f":"SUM(Z51:Z54)","v":19.670000000000002},null,{"$f":"SUM(AB51:AB54)","v":23.103000000000002},null,{"$f":"SUM(AD51:AD54)","v":26.536000000000001},null,{"$f":"SUM(AF51:AF54)","v":29.969000000000001},null,{"$f":"SUM(AH51:AH54)","v":33.402000000000001},null,{"$f":"SUM(AJ51:AJ54)","v":36.835000000000001},null,{"$f":"SUM(AL51:AL54)","v":40.268000000000001},null,{"$f":"SUM(AN51:AN54)","v":43.701000000000001},null,{"$f":"SUM(AP51:AP54)","v":47.134},null,{"$f":"SUM(AR51:AR54)","v":50.567},null,{"$f":"SUM(AT51:AT54)","v":54},null,{"$f":"SUM(AV51:AV54)","v":57.433},null,{"$f":"SUM(AX51:AX54)","v":60.866},null,{"$f":"SUM(AZ51:AZ54)","v":64.299000000000007},null,{"$f":"SUM(BB51:BB54)","v":67.731999999999999},null,{"$f":"SUM(BD51:BD54)","v":71.164999999999992},null,{"$f":"SUM(BF51:BF54)","v":75.214999999999989},null,{"$f":"SUM(BH51:BH54)","v":79.264999999999986},null,{"$f":"SUM(BJ51:BJ54)","v":83.314999999999998},null,{"$f":"SUM(BL51:BL54)","v":87.364999999999995},null,{"$f":"SUM(BN51:BN54)","v":91.414999999999992},null,{"$f":"SUM(BP51:BP54)","v":95.464999999999989},null,{"$f":"SUM(BR51:BR54)","v":99.514999999999986},null,{"$f":"SUM(BT51:BT54)","v":103.565},null,{"$f":"SUM(BV51:BV54)","v":107.61499999999998},null,{"$f":"SUM(BX51:BX54)","v":111.66499999999999},null,{"$f":"SUM(BZ51:BZ54)","v":115.71499999999999},null,{"$f":"SUM(CB51:CB54)","v":119.76499999999999},null,{"$f":"SUM(CD51:CD54)","v":123.815},null,{"$f":"SUM(CF51:CF54)","v":127.86499999999998},null,{"$f":"SUM(CH51:CH54)","v":131.91499999999999},null,{"$f":"SUM(CJ51:CJ54)","v":135.96499999999997},null,{"$f":"SUM(CL51:CL54)","v":140.01499999999999},null,{"$f":"SUM(CN51:CN54)","v":144.065},null,{"$f":"SUM(CP51:CP54)","v":148.11500000000001},null,{"$f":"SUM(CR51:CR54)","v":152.16499999999999},null,{"$f":"SUM(CT51:CT54)","v":156.21499999999997},null,{"$f":"SUM(CV51:CV54)","v":160.26499999999999},null,{"$f":"SUM(CX51:CX54)","v":164.315},null,{"$f":"SUM(CZ51:CZ54)","v":168.36499999999998},null,{"$f":"SUM(DB51:DB54)","v":172.41499999999999},null,{"$f":"SUM(DD51:DD54)","v":{"$error":"#REF!"}}]
[null,"TOTAL TFDI 113 economias",null,null,null,{"$f":"IF((F55<=$D$18),$D$18,F55)","v":19.670000000000002},null,{"$f":"IF((H55<=$D$18),$D$18,H55)","v":19.670000000000002},null,{"$f":"IF((J55<=$D$18),$D$18,J55)","v":19.670000000000002},null,{"$f":"IF((L55<=$D$18),$D$18,L55)","v":19.670000000000002},null,{"$f":"IF((N55<=$D$18),$D$18,N55)","v":19.670000000000002},null,{"$f":"IF((P55<=$D$18),$D$18,P55)","v":19.670000000000002},null,{"$f":"IF((R55<=$D$18),$D$18,R55)","v":19.670000000000002},null,{"$f":"IF((T55<=$D$18),$D$18,T55)","v":19.670000000000002},null,{"$f":"IF((V55<=$D$18),$D$18,V55)","v":19.670000000000002},null,{"$f":"IF((X55<=$D$18),$D$18,X55)","v":19.670000000000002},null,{"$f":"IF((Z55<=$D$18),$D$18,Z55)","v":19.670000000000002},null,{"$f":"IF((AB55<=$D$18),$D$18,AB55)","v":23.103000000000002},null,{"$f":"IF((AD55<=$D$18),$D$18,AD55)","v":26.536000000000001},null,{"$f":"IF((AF55<=$D$18),$D$18,AF55)","v":29.969000000000001},null,{"$f":"IF((AH55<=$D$18),$D$18,AH55)","v":33.402000000000001},null,{"$f":"IF((AJ55<=$D$18),$D$18,AJ55)","v":36.835000000000001},null,{"$f":"IF((AL55<=$D$18),$D$18,AL55)","v":40.268000000000001},null,{"$f":"IF((AN55<=$D$18),$D$18,AN55)","v":43.701000000000001},null,{"$f":"IF((AP55<=$D$18),$D$18,AP55)","v":47.134},null,{"$f":"IF((AR55<=$D$18),$D$18,AR55)","v":50.567},null,{"$f":"IF((AT55<=$D$18),$D$18,AT55)","v":54},null,{"$f":"IF((AV55<=$D$18),$D$18,AV55)","v":57.433},null,{"$f":"IF((AX55<=$D$18),$D$18,AX55)","v":60.866},null,{"$f":"IF((AZ55<=$D$18),$D$18,AZ55)","v":64.299000000000007},null,{"$f":"IF((BB55<=$D$18),$D$18,BB55)","v":67.731999999999999},null,{"$f":"IF((BD55<=$D$18),$D$18,BD55)","v":71.164999999999992},null,{"$f":"IF((BF55<=$D$18),$D$18,BF55)","v":75.214999999999989},null,{"$f":"IF((BH55<=$D$18),$D$18,BH55)","v":79.264999999999986},null,{"$f":"IF((BJ55<=$D$18),$D$18,BJ55)","v":83.314999999999998},null,{"$f":"IF((BL55<=$D$18),$D$18,BL55)","v":87.364999999999995},null,{"$f":"IF((BN55<=$D$18),$D$18,BN55)","v":91.414999999999992},null,{"$f":"IF((BP55<=$D$18),$D$18,BP55)","v":95.464999999999989},null,{"$f":"IF((BR55<=$D$18),$D$18,BR55)","v":99.514999999999986},null,{"$f":"IF((BT55<=$D$18),$D$18,BT55)","v":103.565},null,{"$f":"IF((BV55<=$D$18),$D$18,BV55)","v":107.61499999999998},null,{"$f":"IF((BX55<=$D$18),$D$18,BX55)","v":111.66499999999999},null,{"$f":"IF((BZ55<=$D$18),$D$18,BZ55)","v":115.71499999999999},null,{"$f":"IF((CB55<=$D$18),$D$18,CB55)","v":119.76499999999999},null,{"$f":"IF((CD55<=$D$18),$D$18,CD55)","v":123.815},null,{"$f":"IF((CF55<=$D$18),$D$18,CF55)","v":127.86499999999998},null,{"$f":"IF((CH55<=$D$18),$D$18,CH55)","v":131.91499999999999},null,{"$f":"IF((CJ55<=$D$18),$D$18,CJ55)","v":135.96499999999997},null,{"$f":"IF((CL55<=$D$18),$D$18,CL55)","v":140.01499999999999},null,{"$f":"IF((CN55<=$D$18),$D$18,CN55)","v":144.065},null,{"$f":"IF((CP55<=$D$18),$D$18,CP55)","v":148.11500000000001},null,{"$f":"IF((CR55<=$D$18),$D$18,CR55)","v":152.16499999999999},null,{"$f":"IF((CT55<=$D$18),$D$18,CT55)","v":156.21499999999997},null,{"$f":"IF((CV55<=$D$18),$D$18,CV55)","v":160.26499999999999},null,{"$f":"IF((CX55<=$D$18),$D$18,CX55)","v":164.315},null,{"$f":"IF((CZ55<=$D$18),$D$18,CZ55)","v":168.36499999999998},null,{"$f":"IF((DB55<=$D$18),$D$18,DB55)","v":172.41499999999999},null,{"$f":"D49*113","v":3260.05}]
[null,"FATURAMENTO DE ÁGUA",null,null,null,{"$f":"F56","v":19.670000000000002},null,{"$f":"H56","v":19.670000000000002},null,{"$f":"J56","v":19.670000000000002},null,{"$f":"L56","v":19.670000000000002},null,{"$f":"N56","v":19.670000000000002},null,{"$f":"P56","v":19.670000000000002},null,{"$f":"R56","v":19.670000000000002},null,{"$f":"T56","v":19.670000000000002},null,{"$f":"V56","v":19.670000000000002},null,{"$f":"X56","v":19.670000000000002},null,{"$f":"Z56","v":19.670000000000002},null,{"$f":"AB56","v":23.103000000000002},null,{"$f":"AD56","v":26.536000000000001},null,{"$f":"AF56","v":29.969000000000001},null,{"$f":"AH56","v":33.402000000000001},null,{"$f":"AJ56","v":36.835000000000001},null,{"$f":"AL56","v":40.268000000000001},null,{"$f":"AN56","v":43.701000000000001},null,{"$f":"AP56","v":47.134},null,{"$f":"AR56","v":50.567},null,{"$f":"AT56","v":54},null,{"$f":"AV56","v":57.433},null,{"$f":"AX56","v":60.866},null,{"$f":"AZ56","v":64.299000000000007},null,{"$f":"BB56","v":67.731999999999999},null,{"$f":"BD56","v":71.164999999999992},null,{"$f":"BF56","v":75.214999999999989},null,{"$f":"BH56","v":79.264999999999986},null,{"$f":"BJ56","v":83.314999999999998},null,{"$f":"BL56","v":87.364999999999995},null,{"$f":"BN56","v":91.414999999999992},null,{"$f":"BP56","v":95.464999999999989},null,{"$f":"BR56","v":99.514999999999986},null,{"$f":"BT56","v":103.565},null,{"$f":"BV56","v":107.61499999999998},null,{"$f":"BX56","v":111.66499999999999},null,{"$f":"BZ56","v":115.71499999999999},null,{"$f":"CB56","v":119.76499999999999},null,{"$f":"CD56","v":123.815},null,{"$f":"CF56","v":127.86499999999998},null,{"$f":"CH56","v":131.91499999999999},null,{"$f":"CJ56","v":135.96499999999997},null,{"$f":"CL56","v":140.01499999999999},null,{"$f":"CN56","v":144.065},null,{"$f":"CP56","v":148.11500000000001},null,{"$f":"CR56","v":152.16499999999999},null,{"$f":"CT56","v":156.21499999999997},null,{"$f":"CV56","v":160.26499999999999},null,{"$f":"CX56","v":164.315},null,{"$f":"CZ56","v":168.36499999999998},null,{"$f":"DB56","v":172.41499999999999},null,{"$f":"DD55+DD56","v":{"$error":"#REF!"}}]
[null,"FATURAMENTO ESGOTO 100%",null,null,null,{"$f":"F57","v":19.670000000000002},null,{"$f":"H57","v":19.670000000000002},null,{"$f":"J57","v":19.670000000000002},null,{"$f":"L57","v":19.670000000000002},null,{"$f":"N57","v":19.670000000000002},null,{"$f":"P57","v":19.670000000000002},null,{"$f":"R57","v":19.670000000000002},null,{"$f":"T57","v":19.670000000000002},null,19.670000000000002,null,19.670000000000002,null,19.670000000000002,null,23.103000000000002,null,26.536000000000001,null,29.969000000000001,null,33.402000000000001,null,36.835000000000001,null,40.268000000000001,null,43.701000000000001,null,47.134,null,50.567,null,54,null,57.433,null,60.866,null,64.299000000000007,null,67.731999999999999,null,71.164999999999992,null,75.214999999999989,null,79.264999999999986,null,83.314999999999998,null,87.364999999999995,null,91.414999999999992,null,95.464999999999989,null,99.514999999999986,null,103.565,null,107.61499999999998,null,111.66499999999999,null,115.71499999999999,null,119.76499999999999,null,123.815,null,127.86499999999998,null,131.91499999999999,null,135.96499999999997,null,140.01499999999999,null,144.065,null,148.11500000000001,null,152.16499999999999,null,156.21499999999997,null,160.26499999999999,null,164.315,null,168.36499999999998,null,172.41499999999999,null,{"$f":"DD57","v":{"$error":"#REF!"}},null,"Diferença de R$ 735,86",null,null,{"$f":"DD59-DD13","v":{"$error":"#REF!"}}]
[null,"VALOR TOTAL DA FATURA",null,null,null,{"$f":"F57+F58","v":39.340000000000003},null,{"$f":"H57+H58","v":39.340000000000003},null,{"$f":"J57+J58","v":39.340000000000003},null,{"$f":"L57+L58","v":39.340000000000003},null,{"$f":"N57+N58","v":39.340000000000003},null,{"$f":"P57+P58","v":39.340000000000003},null,{"$f":"R57+R58","v":39.340000000000003},null,{"$f":"T57+T58","v":39.340000000000003},null,{"$f":"V57+V58","v":39.340000000000003},null,{"$f":"X57+X58","v":39.340000000000003},null,{"$f":"Z57+Z58","v":39.340000000000003},null,{"$f":"AB57+AB58","v":46.206000000000003},null,{"$f":"AD57+AD58","v":53.072000000000003},null,{"$f":"AF57+AF58","v":59.938000000000002},null,{"$f":"AH57+AH58","v":66.804000000000002},null,{"$f":"AJ57+AJ58","v":73.67},null,{"$f":"AL57+AL58","v":80.536000000000001},null,{"$f":"AN57+AN58","v":87.402000000000001},null,{"$f":"AP57+AP58","v":94.268000000000001},null,{"$f":"AR57+AR58","v":101.134},null,{"$f":"AT57+AT58","v":108},null,{"$f":"AV57+AV58","v":114.866},null,{"$f":"AX57+AX58","v":121.732},null,{"$f":"AZ57+AZ58","v":128.59800000000001},null,{"$f":"BB57+BB58","v":135.464},null,{"$f":"BD57+BD58","v":142.32999999999998},null,{"$f":"BF57+BF58","v":150.42999999999998},null,{"$f":"BH57+BH58","v":158.52999999999997},null,{"$f":"BJ57+BJ58","v":166.63},null,{"$f":"BL57+BL58","v":174.73},null,{"$f":"BN57+BN58","v":182.82999999999998},null,{"$f":"BP57+BP58","v":190.92999999999998},null,{"$f":"BR57+BR58","v":199.02999999999997},null,{"$f":"BT57+BT58","v":207.13},null,{"$f":"BV57+BV58","v":215.22999999999996},null,{"$f":"BX57+BX58","v":223.32999999999998},null,{"$f":"BZ57+BZ58","v":231.42999999999998},null,{"$f":"CB57+CB58","v":239.52999999999997},null,{"$f":"CD57+CD58","v":247.63},null,{"$f":"CF57+CF58","v":255.72999999999996},null,{"$f":"CH57+CH58","v":263.83},null,{"$f":"CJ57+CJ58","v":271.92999999999995},null,{"$f":"CL57+CL58","v":280.02999999999997},null,{"$f":"CN57+CN58","v":288.13},null,{"$f":"CP57+CP58","v":296.23},null,{"$f":"CR57+CR58","v":304.33},null,{"$f":"CT57+CT58","v":312.42999999999995},null,{"$f":"CV57+CV58","v":320.52999999999997},null,{"$f":"CX57+CX58","v":328.63},null,{"$f":"CZ57+CZ58","v":336.72999999999996},null,{"$f":"DB57+DB58","v":344.83},null,{"$f":"DD57+DD58","v":{"$error":"#REF!"}}]

{"sheet":"CALCULADORA","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CALCULADORA EMASA"]
[null,"DIGITE O VOLUME CONSUMIDO EM m³"]
[null,0]
[null,"DIGITE O NÚMERO DE UNIDADES CONSUMIDORAS"]
[null,0]
[]
[]
[null,"FATURA APÓS DECISÃO JUDICIAL (R$)",null,35.409999999999997]
[null,0]
[null,"Jurisprudência: 1 hidrômetro = 01 economia"]
[null,"FATURA COM ESTRUTURA PROPOSTA PELA ARESC (R$)",null,35.409999999999997]
[null,0]
[null,"Tarifa Fixa (TFDI) + Volume medido"]
[]
[null,null,null,59.11]