{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CálculoTarifasMR","ComponentesGas2016","Tarifas E1 y E2 diciembre2023"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":42,"comments":1,"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":"CálculoTarifasMR","index":0,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[9,11,9,12],[0,0,0,9],[1,0,1,9],[2,0,2,2],[2,3,2,6],[49,6,50,6],[49,7,50,7],[45,0,45,10],[46,0,46,10],[49,8,49,9],[47,4,47,6],[48,7,48,10],[48,1,48,6],[49,0,51,0],[49,1,50,1],[49,2,50,2],[49,3,50,3],[49,4,50,4],[49,5,50,5],[35,7,36,7],[9,0,9,9],[35,0,36,0],[22,0,22,9],[20,4,20,6],[35,8,36,8],[35,3,36,3],[35,2,36,2],[35,4,36,5]]}
["GAS NATURAL POR RED",null,null,null,null,null,null,null,null,null,null,"FacConv",{"$f":"ROUND(1/0.3048^3/1000,8)","v":3.5314669999999999E-2}]
["COSTOS MERCADO REGULADO MUNICIPIO DE CISNEROS"]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Mes m Consumo",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"G ",{"$error":"#N/A"},"USD/ MBTU",null,"Calculado",null,"Cm","Calculado"]
["Mes m-1 Costo",{"$f":"EDATE(B5,-1)","v":{"$error":"#REF!"}},null,null,"Poder calorífico",{"$error":"#N/A"},"MBTU / KPC","Dm ($/m3)",{"$error":"#N/A"},null,"$/factura",1429.69]
["TRM ($/ USD)",2844.14,{"$f":"EOMONTH(B6,0)","v":{"$error":"#REF!"}},null,"T",{"$error":"#N/A"},"USD / KPC"]
[null,null,null,null,"Pérdidas",{"$error":"#N/A"},"%"]
[]
["Costo Calculado",null,null,null,null,null,null,null,null,null,null,"Validación SUI"]
["Rangoj","Gm","Tm","Djm","Alfa","Dvjm","Dfjm","Cm","Mvjm","Mfjm",null,"Mvjm","Mfjm"]
[null,"$/m3","$/m3","$/m3","ajm","$/m3","$/factura","$/factura","$/m3","$/factura",null,"$/m3","$/factura"]
["Rango 1",{"$f":"ROUND(G_USD*FacConv*TRM*Poder_calorífico,2)","v":{"$error":"#N/A"}},{"$f":"ROUND(T_USD*FacConv*TRM,2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0,{"$f":"(1-E13)*D13","v":{"$error":"#N/A"}},{"$f":"E13*D13","v":{"$error":"#N/A"}},1429.69,{"$f":"ROUND((B13+C13)/(1-Pérdidas)+F13,2)","v":{"$error":"#N/A"}},{"$f":"ROUND(G13+H13,2)","v":{"$error":"#N/A"}},null,{"$f":"(B13+C13)/(1-Pérdidas)+D26","v":{"$error":"#N/A"}},{"$f":"J13","v":{"$error":"#N/A"}}]
["Rango 2",{"$f":"B$13","v":{"$error":"#N/A"}},{"$f":"C$13","v":{"$error":"#N/A"}},{"$error":"#N/A"},0,{"$f":"(1-E14)*D14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"H$13","v":1429.69},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"J14","v":{"$error":"#N/A"}}]
["Rango 3",{"$f":"B$13","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"H$13","v":1429.69},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"}]
["Rango 4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},1429.69,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"}]
["Rango 5"]
["Rango 6"]
["Rango GNCV",null,null,{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Cambia tarifa: SI ( 1 )  NO ( 0 )",null,{"$error":"#N/A"},null,null,null,null,null,"Aplicado",null,"Cm","Calculado"]
[null,null,null,null,null,null,null,"Dm ($/m3)",{"$f":"#REF!","v":{"$error":"#REF!"}},"rango 1","$/factura",{"$f":"IF($C$21=1,L6,#REF!)","v":{"$error":"#N/A"}}]
[{"$f":"IF(C21=1,\"Costo Aplicado = Costo Calculado\",\"Costo Aplicado = Costo del mes anterior\")","v":{"$error":"#N/A"}}]
["Rangoj","Gm","Tm","Djm","Alfa","Dvjm","Dfjm","Cm","Mvjm","Mfjm","Tarifa No res"]
[null,"$/m3","$/m3","$/m3","ajm  ","$/m3","$/factura","$/factura","$/m3","$/factura","$/m3"]
["Rango 1",{"$f":"IF($C$21=1,B13,#REF!*(1-Pérdidas))","v":{"$error":"#N/A"}},{"$f":"IF($C$21=1,C13,#REF!*(1-Pérdidas))","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"(1-E26)*D26","v":{"$error":"#REF!"}},{"$f":"E26*D26","v":{"$error":"#REF!"}},{"$f":"IF($C$21=1,H13,#REF!)","v":{"$error":"#N/A"}},{"$f":"ROUND((B26+C26)/(1-$F$8)+F26,2)","v":{"$error":"#N/A"}},{"$f":"ROUND(G26+H26,2)","v":{"$error":"#REF!"}},{"$f":"I26*1.089","v":{"$error":"#N/A"}}]
["Rango 2",{"$f":"B$26","v":{"$error":"#N/A"}},{"$f":"C$26","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"(1-E27)*D27","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"H$26","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#N/A"}]
["Rango 3",{"$f":"B$26","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"H$26","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#N/A"}]
["Rango 4",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#N/A"}]
["Rango 5"]
["Rango 6"]
["Rango GNCV",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Tarifas estratos 1 y 2 (PND)"]
[]
["Tarifa Equivalente base","facturación de","Consumo prom subsistencia","Meqm,e","Variación Costo                      Cmc",null,"Tarifa calculada","% Subsidio calculado","% Subsidio aplicado","Tarifa aplicada"]
[null,"2013-12-01",null,null,null,null,"Tar mc,e",null,null,"Tar mc,e"]
["TEqdic,1",503.99,{"$error":"#N/A"},{"$f":"($I$26*C38+$J$26)/C38","v":{"$error":"#N/A"}},null,null,{"$f":"B38*B41","v":{"$error":"#REF!"}},{"$f":"1-G38/D38","v":{"$error":"#REF!"}},{"$f":"IF(H38>60%,60%,ROUND(H38,4))","v":{"$error":"#REF!"}},{"$f":"ROUND(D38*(1-I38),2)","v":{"$error":"#N/A"}}]
["TEqdic,2",631.26,{"$error":"#N/A"},{"$f":"($I$26*C39+$J$26)/C39","v":{"$error":"#N/A"}},null,null,{"$f":"B39*B41","v":{"$error":"#REF!"}},{"$f":"1-G39/D39","v":{"$error":"#REF!"}},{"$f":"IF(H39>50%,50%,ROUND(H39,4))","v":{"$error":"#REF!"}},{"$f":"ROUND(D39*(1-I39),2)","v":{"$error":"#N/A"}}]
["Mes IPC",{"$f":"B6","v":{"$error":"#REF!"}},{"$f":"B6","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"D3","v":{"$error":"#REF!"}}]
["Var IPC",{"$error":"#REF!"}]
[null,null,{"$f":"(CONCATENATE(\"AñoMes Factura: \"&YEAR(C40),IF(MONTH(C40)<10,\"0\",),MONTH(C40)))","v":{"$error":"#REF!"}}]
[]
[]
[]
["Servicio de gas natural"]
["Tarifas del mercado regulado"]
[null,null,null,null,{"$f":"D3","v":{"$error":"#REF!"}}]
[null,"Costos",null,null,null,null,null,"Tarifas"]
["Rangoj","Cm","Gm","Tm","Djm","Costo Fijo","Costo Variable","Cargo Fijo","Cargo Variable",null,"Porcentaje"]
[null,null,null,null,null,null,null,null,"0-20 m3","Más de 20 m3","Subsidio (-)"]
[null,"$/factura","$/m3","$/m3","$/m3","$/factura","$/m3","$/m3","$/m3","$/m3","Contribución (+)"]
["Rango 1"]
["Estrato 1",{"$f":"J26","v":{"$error":"#REF!"}},{"$f":"B26/(1-Pérdidas)","v":{"$error":"#N/A"}},{"$f":"C26/(1-Pérdidas)","v":{"$error":"#N/A"}},{"$f":"D26","v":{"$error":"#REF!"}},{"$f":"B54","v":{"$error":"#REF!"}},{"$f":"D38","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"-I38","v":{"$error":"#REF!"}}]
["Estrato 2",{"$f":"B$54","v":{"$error":"#REF!"}},{"$f":"C$54","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D39","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"-I39","v":{"$error":"#REF!"}}]
["Estrato 3",{"$f":"B$54","v":{"$error":"#REF!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C56:E56)","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0]
["Estrato 4",{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0]
["Estrato 5",{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0.2]
["Estrato 6",{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0.2]
["No Residencial",{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#N/A"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"K26","v":{"$error":"#N/A"}},{"$f":"I60","v":{"$error":"#N/A"}},8.8999999999999996E-2]
["Rango 2",{"$error":"#REF!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"D27","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#N/A"},{"$f":"H60","v":{"$error":"#REF!"}},{"$error":"#N/A"},{"$error":"#N/A"},8.8999999999999996E-2]
["Rango 3",null,null,null,{"$f":"D28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#N/A"},{"$error":"#N/A"},8.8999999999999996E-2]
["Rango 4",null,null,null,{"$f":"D29","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#N/A"},{"$error":"#N/A"},8.8999999999999996E-2]
["Rango 5",null,null,null,{"$f":"D30","v":0},null,0,null,0,0,8.8999999999999996E-2]
["Rango 6",null,null,null,{"$f":"D31","v":0},null,0,null,0,0,8.8999999999999996E-2]
[]
["Notas:"]
["- En los rangos 2 a 6 sólo se encuentran clientes comerciales e industriales"]
["- Las tarifas para los rangos 2 a 6 corresponden a clientes considerados como regulados, independiente de su consumo."]

{"sheet":"ComponentesGas2016","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[[3,0,3,4],[3,5,3,8],[0,0,0,3],[2,0,2,3]]}
["Servicio de gas natural"]
["Facturación: ",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Componentes del Costo Cisneros"]
["Presentación en la Factura",null,null,null,null,"Presentación Aviso de prensa"]
["Compra Gas","G",{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3","(incluye pérdidas)","Gm",{"$f":"C5*0.965","v":{"$error":"#REF!"}},"$/m3","sin pérdidas"]
["Transporte","T",{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3","(incluye pérdidas)","Tm",{"$f":"C6*0.965","v":{"$error":"#REF!"}},"$/m3","sin pérdidas"]
["Distribución","Dm",{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"Dm",{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3"]
["Rango 1",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D1",{"$f":"ROUND(CálculoTarifasMR!D26,2)","v":{"$error":"#REF!"}}]
["Rango 2",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D2",{"$f":"ROUND(CálculoTarifasMR!D27,2)","v":{"$error":"#REF!"}}]
["Rango 3",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D3",{"$f":"ROUND(CálculoTarifasMR!D28,2)","v":{"$error":"#REF!"}}]
["Rango 4",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D4",{"$f":"ROUND(CálculoTarifasMR!D29,2)","v":{"$error":"#REF!"}}]
["Rango 5",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D5",{"$f":"ROUND(CálculoTarifasMR!D30,2)","v":0}]
["Rango 6",null,{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/m3",null,"D6",{"$f":"ROUND(CálculoTarifasMR!D31,2)","v":0}]
["Comercialización","Cm",{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}},"$/factura",null,"Cm",{"$f":"ROUND(CálculoTarifasMR!H26,2)","v":{"$error":"#N/A"}},"$/factura"]
["Pérdidas","p",{"$f":"+PérdidasRes127","v":{"$error":"#REF!"}},"%"]
[]
["Poder calorífico","Kz",{"$error":"#N/A"},"MBTU/kPC"]

{"sheet":"Tarifas E1 y E2 diciembre2023","index":2,"n_rows":15,"n_cols":23,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,13],[0,1,0,22],[5,0,5,16],[9,0,9,12],[11,0,11,16],[12,0,12,16]]}
[null,"% Subsidio aplicado en la facturación de diciembre 2023"]
["Estrato","Valle de Aburra","Antioquia Suroriente","La Ceja","La Unión","El Retiro","El Peñol_Guatapé","Yarumal","Sonsón","Apartadó","Turbo y Chigorodó","Ciudad Bolívar","Santa Fe de Antioquía","Amagá","Puerto Berrio","Cisneros","San Roque (Nus)","Frontino","Abejorral","San Juan de Urabá","Maceo","Ituango","Abriaquí"]
["Estrato 1",0.54759999999999998,0.26079999999999998,0.54520000000000002,0.54490000000000005,0.53979999999999995,0.54610000000000003,0.56200000000000006,0.5464,0.47310000000000002,0.4879,0.55059999999999998,0.55110000000000003,0.55200000000000005,0.56389999999999996,0.56679999999999997,0.54890000000000005,0.54330000000000001,0.54500000000000004,0.54690000000000005,0.54790000000000005,0.54549999999999998,0.54790000000000005]
["Estrato 2",0.436,0.49759999999999999,0.43159999999999998,0.4289,0.42749999999999999,0.43659999999999999,0.45229999999999998,0.43180000000000002,0.37440000000000001,0.39419999999999999,0.44009999999999999,0.44359999999999999,0.44369999999999998,0.45639999999999997,0.45739999999999997,0.43580000000000002,0.43,0.43419999999999997,0.43020000000000003,0.43440000000000001,0.43840000000000001,0.43640000000000001]
["Composición mercados relevantes:"]
["Valle de Aburrá: Incluye los municipios de Medellín, Barbosa, Girardota, Copacabana, Bello, Envigado, Itagüí, Sabaneta, La Estrella, Caldas, La Ceja, La Unión, El Retiro, Sonsón, Apartadó, Turbo, Chigorodó, Carepa, Necoclí, Arboletes, Frontino, Cañasgordas, Fredonia, Santa Bárbara, Jardín, Jericó, San Juan de Urabá, Abejorral, Angelópolis, Belmira, Betania, Betulia, Caramanta, Carolina del Príncipe, Cocorná, Concordia, Gómez Plata, Granada, Guadalupe, Hispania, Montebello, Mutatá, Pueblorico, Puerto Nare, Salgar, San Carlos, San Luis, San Pedro de Urabá, San Rafael, Támesis, Tarso, Titiribí, Urrao, Valparaíso, Venecia, Maceo, Amalfi, Santo Domingo, Caracolí, Yolombó, San Vicente, Ituango, Liborina, Olaya, Sabanalarga, San Andrés de Cuerquía, Valdivia, Concepción, Dabeiba, Remedios, San José de la Montaña, San Roque (urbano), Toledo, Vegachí y Yalí.  "]
["Yarumal: Incluye los municipios de Yarumal, Santa Rosa de Osos, Don Matías, Entrerríos y San Pedro de los Milagros."]
["Santa Fe de Antioquía: Incluye los municipios de Santa Fe de Antioquia, San Jerónimo y Sopetrán."]
["Antioquia suroriente: Rionegro, Marinilla y Guarne."]
["Turbo y Chigorodó: Arboletes, Carepa, Chigorodó, Necoclí y Turbo"]
["Frontino: Frontino, Cañasgordas, Fredonia, Santa Bárbara, Jardín y Jericó"]
["Abejorral: Abejorral, Angelópolis, Belmira, Betania, Betulia, Caramanta, Carolina del Príncipe, Cocorná, Concordia, Gómez Plata, Granada, Guadalupe, Hispania, Montebello, Mutatá, La Pintada, Pueblorrico, Puerto Nare, Salgar, San Carlos, San Luis, San Pedro de Urabá, San Rafael, Támesis, Tarso, Titiribí, Urrao, Valparaíso y Venecia"]
["Maceo:  Maceo, Amalfi, Caracolí, San Vicente, Santo Domingo y Yolombó"]
["Ituango: Ituango, Liborina, Olaya, Sabanalarga, San Andrés de Cuerquia y Valdivia "]
["Abriaquí: Concepción, Dabeiba, San José de la Montaña, San Roque Urbano, Toledo, Vegachí, Yalí, Remedios"]