{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Garantías por desbalance","Parametros"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":32,"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":"Garantías por desbalance","index":0,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,1,18],[2,12,2,15],[40,3,40,4],[40,1,40,2],[40,13,40,14],[35,4,35,12],[37,4,38,12]]}
[null,"Simulador de garantías para desbalances\n(Nivel de Riesgo de Desbalance)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Diciembre"]
[]
[]
[null,null,null,null,"PVB",null,null,null,"TVB",null,null,null,"AVB",null,null,null,"Recargos"]
[]
[null,null,"Entradas (día gas d)",null,null,"kWh",null,null,null,"kWh",null,null,null,"kWh"]
[]
[null,null,"Salidas (día gas d)",null,null,"kWh",null,null,null,"kWh",null,null,null,"kWh"]
[]
[null,null,"Demanda (día gas d)",null,null,"kWh"]
[]
[null,null,"Adquisiciones (días gas d y d+1)",null,null,"kWh",null,null,null,"kWh",null,null,null,"kWh"]
[]
[null,null,"Cesiones (días gas d y d+1)",null,null,"kWh",null,null,null,"kWh",null,null,null,"kWh"]
[]
[null,null,"Existencias iniciales (día gas d)",null,null,"kWh",null,null,null,"kWh",null,null,null,"kWh"]
[]
[null,null,"Tarifa de desbalance de compra diaria (día gas d)",null,null,"€/kWh",null,null,null,"€/kWh",null,null,null,"€/kWh"]
[]
[null,null,"Peajes (día gas d)",null,null,null,null,null,{"$f":"ROUND((Parametros!$L$4*VLOOKUP(M3,Parametros!$B$37:$I$48,4,FALSE)/366+Parametros!$N$4)+(Parametros!$L$7*VLOOKUP(M3,Parametros!$B$21:$I$32,4,FALSE)/366+Parametros!$N$7),6)","v":7.54E-4},"€/kWh",null,null,{"$f":"ROUND((Parametros!$L$5*VLOOKUP(M3,Parametros!$B$53:$I$64,4,FALSE)/366+Parametros!$N$5)+(Parametros!$L$6*VLOOKUP(M3,Parametros!$B$21:$I$32,4,FALSE)/366)+Parametros!$N$6,6)","v":5.6099999999999998E-4},"€/kWh"]
[]
[null,null,"Recargos por desbalances"]
[]
[null,null,"Derechos de cobro pendientes de cobrar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[]
[null,null,"Obligaciones de pago pendientes de pagar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[]
[null,null,null,null,"Rpvb",null,null,null,"Rtvb",null,null,null,"Ravb",null,null,null,"CD"]
[]
[null,null,"Niveles de riesgo",null,{"$f":"IF(ROUND((E8+E14-E10-E12-E16)*E20,2)*(-1)<=0,0,ROUND((E8+E14-E10-E12-E16)*E20,2)*(-1))","v":0},"€",null,null,{"$f":"IF(ROUND((I18+I8+I14-I10-I16)*(I20+I22),2)*(-1)<=0,0,ROUND((I18+I8+I14-I10-I16)*(I20+I22),2)*(-1))","v":0},"€",null,null,{"$f":"IF(ROUND((M18+M8+M14-M10-M16)*(M20+M22),2)*(-1)<=0,0,ROUND((M18+M8+M14-M10-M16)*(M20+M22),2)*(-1))","v":0},"€",null,null,{"$f":"Q28-Q26","v":0},"€"]
[]
[]
[]
[null,null,null,null,"Garantías para desbalances"]
[]
[null,null,null,null,{"$f":"MAX((SUMIF($E$32:$M$32,\">0\",$E$32:$M$32)+$Q$32),100000)","v":100000}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha actualización: ","30/04/2024"]

{"sheet":"Parametros","index":1,"n_rows":80,"n_cols":15,"rows_kept":80,"cut":false,"hidden":true,"merged":[[65,0,65,8],[66,0,79,0],[66,1,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[66,6,67,6],[66,7,67,7],[66,8,67,8],[49,0,49,8],[50,0,63,0],[50,1,51,2],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[33,0,33,8],[34,0,47,0],[34,1,35,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[17,0,17,8],[18,0,31,0],[18,1,19,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[1,13,2,13],[1,14,2,14],[0,10,0,14],[1,12,2,12],[0,0,0,8],[1,0,14,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,10,2,10],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,11,2,11]]}
["Administración PEAJES.  Almacenamientos subterráneos"]
["Productos estándar capacidad","Mes",null,"Intradiario (05)","Diario (04)","Mensual (03)","Trimestral (02)","Anual(01)","Indefinido",null,"Servicio","Tf","Unidad","Tv","Unidad"]
[]
[null,"Enero",1,2.4,1.6,1.3,1,1,1,null,"Licuefacción virtual",1.067E-3,"€/(kWh/día)/año",0,"€/kWh"]
[null,"Febrero",2,2.1,1.3,1.1000000000000001,1,1,1,null,"Inyección AASS",0.15548600000000001,"€/(kWh/día)/año",0,"€/kWh"]
[null,"Marzo",3,1.9,1.2,1,1,1,1,null,"Salida del PVB a AASS",0,"€/(kWh/día)/año",1.36E-4,"€/kWh"]
[null,"Abril",4,2.1,1.3,1.1000000000000001,1,1,1,null,"Salida del PVB a TVB",0.14965400000000001,"€/(kWh/día)/año",1.36E-4,"€/kWh"]
[null,"Mayo",5,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Junio",6,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Julio",7,2.4,1.6,1.3,1.3,1,1]
[null,"Agosto",8,2.8,1.8,1.5,1.3,1,1]
[null,"Septiembre",9,3,2,1.6,1.3,1,1]
[null,"Octubre",10,3,2,1.6,1.4,1,1]
[null,"Noviembre",11,2.8,1.8,1.5,1.4,1,1]
[null,"Diciembre",12,2.8,1.8,1.5,1.4,1,1]
[]
[]
["Administración PEAJES.  Salida de transporte no distribución"]
["Productos estándar capacidad","Mes",null,"Intradiario (05)","Diario (04)","Mensual (03)","Trimestral (02)","Anual(01)","Indefinido"]
[]
[null,"Enero",1,3.8,1.5,1.3,1.2,1,1]
[null,"Febrero",2,3.8,1.5,1.3,1.2,1,1]
[null,"Marzo",3,3.8,1.5,1.3,1.2,1,1]
[null,"Abril",4,3.8,1.5,1.3,1.2,1,1]
[null,"Mayo",5,3.8,1.5,1.3,1.2,1,1]
[null,"Junio",6,3.8,1.5,1.3,1.2,1,1]
[null,"Julio",7,3.8,1.5,1.3,1.2,1,1]
[null,"Agosto",8,3.8,1.5,1.3,1.2,1,1]
[null,"Septiembre",9,3.8,1.5,1.3,1.2,1,1]
[null,"Octubre",10,3.8,1.5,1.3,1.2,1,1]
[null,"Noviembre",11,3.8,1.5,1.3,1.2,1,1]
[null,"Diciembre",12,3.8,1.5,1.3,1.2,1,1]
[]
["Administración PEAJES. Licuefacción virtual"]
["Productos estándar capacidad","Mes",null,"Intradiario (05)","Diario (04)","Mensual (03)","Trimestral (02)","Anual(01)","Indefinido"]
[]
[null,"Enero",1,6.7,1.7,1.3,1.2,1,1]
[null,"Febrero",2,6.7,1.7,1.3,1.2,1,1]
[null,"Marzo",3,6.7,1.7,1.3,1.2,1,1]
[null,"Abril",4,6.7,1.7,1.3,1.2,1,1]
[null,"Mayo",5,6.7,1.7,1.3,1.2,1,1]
[null,"Junio",6,6.7,1.7,1.3,1.2,1,1]
[null,"Julio",7,6.7,1.7,1.3,1.2,1,1]
[null,"Agosto",8,6.7,1.7,1.3,1.2,1,1]
[null,"Septiembre",9,6.7,1.7,1.3,1.2,1,1]
[null,"Octubre",10,6.7,1.7,1.3,1.2,1,1]
[null,"Noviembre",11,6.7,1.7,1.3,1.2,1,1]
[null,"Diciembre",12,6.7,1.7,1.3,1.2,1,1]
[]
["Administración PEAJES.  Inyección"]
["Productos estándar capacidad","Mes",null,"Intradiario (05)","Diario (04)","Mensual (03)","Trimestral (02)","Anual(01)","Indefinido"]
[]
[null,"Enero",1,1,1,1.3,1,1,1]
[null,"Febrero",2,1,1,1.1000000000000001,1,1,1]
[null,"Marzo",3,1,1,1,1,1,1]
[null,"Abril",4,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Mayo",5,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Junio",6,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Julio",7,2.4,1.6,1.3,1.3,1,1]
[null,"Agosto",8,2.8,1.8,1.5,1.3,1,1]
[null,"Septiembre",9,3,2,1.6,1.3,1,1]
[null,"Octubre",10,3,2,1.6,1.4,1,1]
[null,"Noviembre",11,1,1,1.5,1.4,1,1]
[null,"Diciembre",12,1,1,1.5,1.4,1,1]
[]
["Administración PEAJES.  Extracción"]
["Productos estándar capacidad","Mes",null,"Intradiario (05)","Diario (04)","Mensual (03)","Trimestral (02)","Anual(01)","Indefinido"]
[]
[null,"Enero",1,2.4,1.6,1.3,1,1,1]
[null,"Febrero",2,2.1,1.3,1.1000000000000001,1,1,1]
[null,"Marzo",3,1.9,1.2,1,1,1,1]
[null,"Abril",4,1,1,1.1000000000000001,1,1,1]
[null,"Mayo",5,1,1,1.1000000000000001,1,1,1]
[null,"Junio",6,1,1,1.1000000000000001,1,1,1]
[null,"Julio",7,1,1,1.3,1.3,1,1]
[null,"Agosto",8,1,1,1.5,1.3,1,1]
[null,"Septiembre",9,1,1,1.6,1.3,1,1]
[null,"Octubre",10,1,1,1.6,1.4,1,1]
[null,"Noviembre",11,2.8,1.8,1.5,1.4,1,1]
[null,"Diciembre",12,2.8,1.8,1.5,1.4,1,1]