{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BBDD","Simulador"],"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":"BBDD","index":0,"n_rows":43,"n_cols":52,"rows_kept":43,"cut":false,"hidden":true,"merged":[[18,2,21,11],[0,42,0,45],[5,37,5,40],[1,49,1,51],[1,46,1,48],[0,23,1,23],[0,24,0,28],[0,30,1,30],[0,31,0,35],[18,0,18,1],[2,43,2,44],[1,42,1,43],[8,0,11,0],[5,0,7,0],[12,0,16,0],[0,13,1,13],[0,14,0,18],[0,0,1,1],[0,7,0,11],[0,4,0,6],[2,0,4,0],[0,2,0,3],[4,37,4,40],[0,20,0,21],[0,37,0,40]]}
["Servicio",null,"Fórmula",null,"Peaje",null,null,"Multiplicador",null,null,null,null,null,"Mes","Multiplicador AVB (Almacenamiento y Agregado)",null,null,null,null,null,"Rango",null,null,"Mes","Multiplicador AVB (I)",null,null,null,null,null,"Mes","Multiplicador AVB (E)",null,null,null,null,null,"Contraflujo",null,null,null,null,"Auxiliar para SA (AR/ARE/DAR/DARE)",null,null,null,{"$f":"SUM(AU4:AU43)","v":0},{"$f":"SUM(AV4:AV43)","v":0},{"$f":"SUM(AW4:AW43)","v":0},{"$f":"SUM(AX4:AX43)","v":0},0,0]
[null,null,"Peaje","Interrumpibilidad","Tc\n(€/(kWh/día)/año)","Tv1\n(€/kWh)","Tv2\n(€/kWh)","Anual","Trimestral","Mensual","Diario","Intradiario",null,null,"Anual","Trimestral","Mensual","Diario","Intradiario",null,"Producto","Naturaleza",null,null,"Anual","Trimestral","Mensual","Diario","Intradiario",null,null,"Anual","Trimestral","Mensual","Diario","Intradiario",null,"Extracción",1,"abr","oct",null,"Contrato Regasificación",null,{"$f":"IF(OR(Simulador!D5=BBDD!B14,Simulador!D5=B15,Simulador!D5=B16,Simulador!D5=B17),Simulador!$D$17,\" \")","v":" "},null,"Término de Capacidad",null,null,"Término de Volumen"]
["AVB","Almacenamiento AVB","Q x (M x Tc + Pr) x (D / D_año)",null,2.5560000000000001E-3,null,null,null,null,null,null,null,null,1,1,1,1.3,1.6,2.4,null,"Anual","Firme",null,1,1,1,1.3,1,1,null,1,1,1,1.3,1.6,2.4,null,"Inyección",1,"nov","mar",null,"Duración ","Almacenamiento (Q)",null,"Existencias (V)","Peaje diario Almacenamiento TVB","Peaje anual Regasificación","Peaje diario Entrada a PVB desde TVB","Peaje diario Almacenamiento TVB","Peaje anual Regasificación","Peaje diario Entrada a PVB desde TVB"]
[null,"Inyección","Q x (M x Tc + Pr) x (D / D_año)","Fi x (Qi x M x Tc) x (1 / D_año)",9.6387E-2,null,null,null,null,null,null,null,null,2,1,1,1.1000000000000001,1.3,2.1,null,"Trimestral","Interrumpible",null,2,1,1,1.1000000000000001,1,1,null,2,1,1,1.1000000000000001,1.3,2.1,null,null,null,null,null,null,{"$f":"IF(AS4= \" \",0,\"Día 1\")","v":0},{"$f":"IF(OR(Simulador!$D$5=BBDD!$B$14,Simulador!$D$5=$B$15,Simulador!$D$5=$B$16,Simulador!$D$5=$B$17),Simulador!$D$12, \" \" )","v":" "},{"$f":"AR4","v":" "},{"$f":"IF(AS4>1,AS4,0)","v":" "},{"$f":"IF(AS4<> \" \",AS4 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":" "},{"$f":"IF($AS$2<> \" \", $AS$2 * ( VLOOKUP( $B$7, $B:$H, COLUMNS($B:$H), FALSE ) * VLOOKUP( $B$7, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * Simulador!$D$8 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11), \" \")","v":" "},{"$f":"IF($AS$2<> \" \", $AS$2 * ( VLOOKUP( $B$10, $B:$K, COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$10, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * Simulador!D8/ _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11), \" \")","v":" "},{"$f":"IF(AT4<> \" \",AT4*(VLOOKUP($B$6,$B:$F,COLUMNS($B:$F),FALSE)), \" \")","v":" "},{"$f":"IF(AS2<> \" \",AS2*$AL$6*VLOOKUP($B$7, $B:$F, COLUMNS($B:$F), FALSE )*Simulador!$D$8, \" \")","v":" "},{"$f":"IF(AS4<> \" \", AS4*$AL$6*VLOOKUP($B$10,$B:$F,COLUMNS($B:$F),FALSE)*Simulador!$D$8, \" \")","v":" "}]
[null,"Extracción","Q x (M x Tc + Pr) x (D / D_año)","Fi x (Qi x M x Tc) x (1 / D_año)",7.1538000000000004E-2,null,null,null,null,null,null,null,null,3,1,1,1,1.2,1.9,null,"Mensual",null,null,3,1,1,1,1,1,null,3,1,1,1,1.2,1.9,null,"% nominación agregado",null,null,null,null,{"$f":"IF(AS5<0.000000001,0,\"Día 2\")","v":0},{"$f":"IF(AR4 <> \" \",AR4-$AS$2, \" \")","v":" "},{"$f":"IF(AR5<>\" \",IF(AR5<=0,0,AS4-$AS$2),0)","v":0},{"$f":"IF(AS5>1,AT4-$AL$6*$AS$2,0)","v":0},{"$f":"IF(AS5<> \" \",AS5 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",{"$f":"IF(AT5<> \" \",AT5*(VLOOKUP($B$6,$B:$F,COLUMNS($B:$F),FALSE)), \" \")","v":0},"-","-"]
["TVB","Almacenamiento TVB","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,5.5999999999999995E-4,3.0000000000000001E-6,null,1,1.1000000000000001,1.3,1.5,5,null,4,1,1,1.1000000000000001,1.3,2.1,null,"Diario",null,null,4,1,1,1.1000000000000001,1.3,2.1,null,4,1,1,1.1000000000000001,1,1,null,{"$f":"IFERROR(Simulador!D13/Simulador!D12,\" \")","v":" "},null,null,null,null,{"$f":"IF(AS6<0.000000001,0,\"Día 3\")","v":0},{"$f":"IF(AR5 <> \" \",AR5-$AS$2, \" \")","v":" "},{"$f":"IF(AR6<>\" \",IF(AR6<=0,0,AS5-$AS$2),0)","v":0},{"$f":"IF(AS6>1,AT5-$AL$6*$AS$2,0)","v":0},{"$f":"IF(AS6<> \" \",AS6 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",{"$f":"IF(AT6<> \" \",AT6*(VLOOKUP($B$6,$B:$F,COLUMNS($B:$F),FALSE)), \" \")","v":0},"-","-"]
[null,"Regasificación","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,1.9876999999999999E-2,2.1900000000000001E-4,null,1,1.2,1.3,1.7,6,null,5,1,1,1.1000000000000001,1.3,2.1,null,"Intradiario",null,null,5,1,1,1.1000000000000001,1.3,2.1,null,5,1,1,1.1000000000000001,1,1,null,null,null,null,null,null,{"$f":"IF(AS7<0.000000001,0,\"Día 4\")","v":0}," ",{"$f":"IF(AR7<>\" \",IF(AR7<=0,0,AS6-$AS$2),0)","v":0},{"$f":"IF(AS7>1,AT6-$AL$6*$AS$2,0)","v":0},{"$f":"IF(AS7<> \" \",AS7 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"Licuefacción","Q x (M x Tc + Pr) x (D / D_año)",null,1.3649999999999999E-3,null,null,1,1.2,1.3,1.7,6,null,6,1,1,1.1000000000000001,1.3,2.1,null,null,null,null,6,1,1,1.1000000000000001,1.3,2.1,null,6,1,1,1.1000000000000001,1,1,null,null,null,null,null,null,{"$f":"IF(AS8<0.000000001,0,\"Día 5\")","v":0}," ",{"$f":"IF(AR8<>\" \",IF(AR8<=0,0,AS7-$AS$2),0)","v":0},{"$f":"IF(AS8>1,AT7-$AL$6*$AS$2,0)","v":0},{"$f":"IF(AS8<> \" \",AS8 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
["PVB","Entrada a PVB desde AVB","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,0,1.37E-4,null,1,1.1000000000000001,1.2,1.6,5.6,null,7,1,1.3,1.3,1.6,2.4,null,"Origen",null,null,7,1,1.3,1.3,1.6,2.4,null,7,1,1.3,1.3,1,1,null,null,null,null,null,null,{"$f":"IF(AS9<0.000000001,0,\"Día 6\")","v":0}," ",{"$f":"IF(AR9<>\" \",IF(AR9<=0,0,AS8-$AS$2),0)","v":0},{"$f":"IF(AS9>1,AT8-$AL$6*$AS$2,0)","v":0},{"$f":"IF(AS9<> \" \",AS9 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"Entrada a PVB desde TVB","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,9.6285999999999997E-2,1.37E-4,null,1,1.1000000000000001,1.2,1.6,5.6,null,8,1,1.3,1.5,1.8,2.8,null,"SI",null,null,8,1,1.3,1.5,1.8,2.8,null,8,1,1.3,1.5,1,1,null,null,null,null,null,null,{"$f":"IF(AS10<0.000000001,0,\"Día 7\")","v":0}," ",0,0,{"$f":"IF(AS10<> \" \",AS10 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"Salida desde PVB a AVB","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,0,1.37E-4,null,1,1.2,1.3,1.6,3.4,null,9,1,1.3,1.6,2,3,null,"NO",null,null,9,1,1.3,1.6,2,3,null,9,1,1.3,1.6,1,1,null,null,null,null,null,null,{"$f":"IF(AS11<0.000000001,0,\"Día 8\")","v":0}," ",0,0,{"$f":"IF(AS11<> \" \",AS11 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"Salida desde PVB a TVB","Q x (M x Tc + Pr) x (D / D_año) + V x Tv",null,0.109767,1.37E-4,null,1,1.2,1.3,1.6,3.4,null,10,1,1.4,1.6,2,3,null,null,null,null,10,1,1.4,1.6,2,3,null,10,1,1.4,1.6,1,1,null,null,null,null,null,null,{"$f":"IF(AS12<0.000000001,0,\"Día 9\")","v":0}," ",0,0,{"$f":"IF(AS12<> \" \",AS12 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
["SA","AIE (Almacenamiento AVB, Inyección y Extracción)","Q x (M x Tc + Pr) x (D / D_año) + Vi x Tvi / D_año + Ve x Tve / D_año",null,{"$f":"E3","v":2.5560000000000001E-3},{"$f":"E4","v":9.6387E-2},{"$f":"E5","v":7.1538000000000004E-2},null,null,null,null,null,null,11,1,1.4,1.5,1.8,2.8,null,null,null,null,11,1,1.4,1.5,1,1,null,11,1,1.4,1.5,1.8,2.8,null,null,null,null,null,null,{"$f":"IF(AS13<0.000000001,0,\"Día 10\")","v":0}," ",0,0,{"$f":"IF(AS13<> \" \",AS13 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"AR (Almacenamiento TVB y Regasificación)","Peaje diario almacenamiento TVB + Peaje anual regasificación",null,null,null,null,null,null,null,null,null,null,12,1,1.4,1.5,1.8,2.8,null,null,null,null,12,1,1.4,1.5,1,1,null,12,1,1.4,1.5,1.8,2.8,null,null,null,null,null,null,{"$f":"IF(AS14<0.000000001,0,\"Día 11\")","v":0}," ",0,0,{"$f":"IF(AS14<> \" \",AS14 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"ARE (Almacenamiento TVB, Regasificación y Entrada a PVB desde TVB)","Peaje diario almacenamiento TVB + Peaje anual regasificación + Peaje diario entrada a PVB desde TVB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS15<0.000000001,0,\"Día 12\")","v":0}," ",0,0,{"$f":"IF(AS15<> \" \",AS15 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"DAR (Descarga, Almacenamiento TVB y Regasificación)","Peaje descarga + Peaje diario almacenamiento TVB + Peaje anual regasificación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS16<0.000000001,0,\"Día 13\")","v":0}," ",0,0,{"$f":"IF(AS16<> \" \",AS16 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,"DARE (Descarga, Almacenamiento TVB, Regasificación y Entrada a PVB desde TVB)","Peaje descarga + Peaje diario almacenamiento TVB + Peaje anual regasificación + Peaje diario entrada a PVB desde TVB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS17<0.000000001,0,\"Día 14\")","v":0}," ",0,0,{"$f":"IF(AS17<> \" \",AS17 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS18<0.000000001,0,\"Día 15\")","v":0}," ",0,0,{"$f":"IF(AS18<> \" \",AS18 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
["Otras variables",null,"SIMULADOR VÁLIDO PARA FACTURACIONES CON FECHA DE PRESTACIÓN DE SERVICIOS DEL 1/10/2024 AL 30/09/2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS19<0.000000001,0,\"Día 16\")","v":0}," ",0,0,{"$f":"IF(AS19<> \" \",AS19 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
["Cuota GTS",1.5259999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS20<0.000000001,0,\"Día 17\")","v":0}," ",0,0,{"$f":"IF(AS20<> \" \",AS20 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
["Tasa CNMC",1.4000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS21<0.000000001,0,\"Día 18\")","v":0}," ",0,0,{"$f":"IF(AS21<> \" \",AS21 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS22<0.000000001,0,\"Día 19\")","v":0}," ",0,0,{"$f":"IF(AS22<> \" \",AS22 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS23<0.000000001,0,\"Día 20\")","v":0}," ",0,0,{"$f":"IF(AS23<> \" \",AS23 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS24<0.000000001,0,\"Día 21\")","v":0}," ",0,0,{"$f":"IF(AS24<> \" \",AS24 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS25<0.000000001,0,\"Día 22\")","v":0}," ",0,0,{"$f":"IF(AS25<> \" \",AS25 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,{"$f":"IF(AS26<0.000000001,0,\"Día 23\")","v":0}," ",0,0,{"$f":"IF(AS26<> \" \",AS26 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS27<0.000000001,0,\"Día 24\")","v":0}," ",0,0,{"$f":"IF(AS27<> \" \",AS27 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS28<0.000000001,0,\"Día 25\")","v":0}," ",0,0,{"$f":"IF(AS28<> \" \",AS28 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS29<0.000000001,0,\"Día 26\")","v":0}," ",0,0,{"$f":"IF(AS29<> \" \",AS29 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS30<0.000000001,0,\"Día 27\")","v":0}," ",0,0,{"$f":"IF(AS30<> \" \",AS30 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS31<0.000000001,0,\"Día 28\")","v":0}," ",0,0,{"$f":"IF(AS31<> \" \",AS31 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS32<0.000000001,0,\"Día 29\")","v":0}," ",0,0,{"$f":"IF(AS32<> \" \",AS32 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",{"$f":"IF(AT32<> \" \",AT32*(VLOOKUP($B$6,$B:$F,COLUMNS($B:$F),FALSE)), \" \")","v":0},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS33<0.000000001,0,\"Día 30\")","v":0}," ",0,0,{"$f":"IF(AS33<> \" \",AS33 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS34<0.000000001,0,\"Día 31\")","v":0}," ",0,0,{"$f":"IF(AS34<> \" \",AS34 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS35<0.000000001,0,\"Día 32\")","v":0}," ",0,0,{"$f":"IF(AS35<> \" \",AS35 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS36<0.000000001,0,\"Día 33\")","v":0}," ",0,0,{"$f":"IF(AS36<> \" \",AS36 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS37<0.000000001,0,\"Día 34\")","v":0}," ",0,0,{"$f":"IF(AS37<> \" \",AS37 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS38<0.000001,0,\"Día 35\")","v":0}," ",0,0,{"$f":"IF(AS38<> \" \",AS38 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS39<0.000000001,0,\"Día 36\")","v":0}," ",0,0,{"$f":"IF(AS39<> \" \",AS39 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS40<0.000000001,0,\"Día 37\")","v":0}," ",0,0,{"$f":"IF(AS40<> \" \",AS40 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS41<0.000000001,0,\"Día 38\")","v":0}," ",0,0,{"$f":"IF(AS41<> \" \",AS41 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS42<0.000000001,0,\"Día 39\")","v":0}," ",0,0,{"$f":"IF(AS42<> \" \",AS42 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS43<0.000000001,0,\"Día 40\")","v":0}," ",0,0,{"$f":"IF(AS43<> \" \",AS43 * ( VLOOKUP( $B$6,$B:$K,COLUMNS($B:$K), FALSE ) * VLOOKUP( $B$6, $B:$E, COLUMNS($B:$E), FALSE ) + Simulador!$D$15 ) * 1 / _xlfn.DAYS(EDATE(Simulador!$D$11, 12), Simulador!$D$11),\" \")","v":0},"-","-",0,"-","-"]

{"sheet":"Simulador","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,10],[4,3,5,3],[3,6,3,9],[6,6,6,7],[5,6,5,7],[4,6,4,7],[6,8,6,9],[5,8,5,9],[4,8,4,9],[17,6,18,7],[17,8,18,9],[8,6,8,7],[4,2,5,2],[7,6,7,7],[9,6,10,7],[9,8,10,9],[7,8,7,9],[8,8,8,9]]}
[null,"Simulador Facturación Servicios GTS"]
[null,null," "]
[]
[null,null,"Tipo de servicio","Servicio individual",null,null,"Facturación"]
[null,null,"Servicio",null,null,null,"Término de Capacidad",null,{"$f":"IF(  D20 <> \"\",\n          IF(  OR(D4 = \"Servicio Individual\", D5 = BBDD!B13),\n                  D12 * (IF(OR(D5 = BBDD!B3, D5 = BBDD!B4, D5 = BBDD!B5, D5 = BBDD!B13), _xlfn.IFS(OR(D5=BBDD!B3,D5=BBDD!B13),VLOOKUP(MONTH(D11),BBDD!N:S,IF(D8=24,MATCH(\"Diario\",BBDD!N2:S2,0),MATCH(D7,BBDD!N2:S2,0)),FALSE),D5=BBDD!B4,VLOOKUP(MONTH(D11),BBDD!X:AC,IF(D8=24,MATCH(\"Diario\",BBDD!X2:AC2,0),MATCH(D7,BBDD!X2:AC2,0)),FALSE),D5=BBDD!B5,VLOOKUP(MONTH(D11),BBDD!AE:AJ,IF(D8=24,MATCH(\"Diario\",BBDD!AE2:AJ2,0),MATCH(D7,BBDD!AE2:AJ2,0)),FALSE)),VLOOKUP(D5,BBDD!B:L,IF(D8=24,MATCH(\"Diario\",BBDD!B2:L2,0),MATCH(D7,BBDD!B2:L2,0)),FALSE)) * VLOOKUP( D5, BBDD!B:E, COLUMNS(BBDD!B:E), FALSE ) + D15  ) / _xlfn.DAYS(EDATE(D11, 12), D11) * IF( D7 = BBDD!U7, D8 / 24, MAX( _xlfn.DAYS(EDATE(D11, IF(D7 = BBDD!H2, 12, IF(D7 = BBDD!I2, 3, IF(D7 = BBDD!J2, 1, 0)))), D11), 1 ) ),\n                  IF(  OR( D5 = BBDD!B14, D5 = BBDD!B16 ),\n                          BBDD!AU1  +  BBDD!AV1,\n                          IF(  OR( D5 = BBDD!B15, D5 = BBDD!B17 ),\n                                  BBDD!AU1  + BBDD!AV1  +  BBDD!AW1,\n                                  0  )  )  ),\n                   0 )","v":0}]
[null,null,null,null,null,null,"Término de Volumen",null,{"$f":"IF(  D20 <> \"\",\n          IF(  D4 = \"Servicio Individual\",\n                  D13 * VLOOKUP( D5, BBDD!B:F, COLUMNS(BBDD!B:F), FALSE ),\n                  IF(  D5 = BBDD!B13,\n                          D13 * ROUND( VLOOKUP( D5, BBDD!B:F, COLUMNS(BBDD!B:F), FALSE ) / _xlfn.DAYS(EDATE(D11, 12), D11), 6 )  +  D14 * ROUND( VLOOKUP( D5, BBDD!B:G, COLUMNS(BBDD!B:G), FALSE ) / _xlfn.DAYS(EDATE(D11, 12), D11), 6 ),\n                          IF(  OR( D5 = BBDD!B14, D5 = BBDD!B16 ),\n                                 BBDD!AX1+BBDD!AY1,\n                                  IF(  OR( D5 = BBDD!B15, D5 = BBDD!B17 ),\n                                          BBDD!AX1+BBDD!AY1+BBDD!AZ1,\n                                          0  )  )  )  ),\n          0  )","v":0}]
[null,null,{"$f":"IF( OR(D4 = \"Servicio Individual\", D5 = BBDD!B13), \"Producto\", \"\" )","v":"Producto"},null,null,null,"Compensación Interrumpibilidad",null,{"$f":" - IF(  AND( D20 <> \"\", D10 = BBDD!V4, OR(D5 = BBDD!B4, D5 = BBDD!B5) ),\n              MIN(  3 * ( D16 * _xlfn.IFS(D5=BBDD!B4,VLOOKUP( MONTH(D11), BBDD!X:AC, IF(D8=24,MATCH(\"Diario\", BBDD!X2:AC2, 0),MATCH(D7, BBDD!X2:AC2, 0)), FALSE),D5=BBDD!B5,(VLOOKUP( MONTH(D11), BBDD!AE:AJ, IF(D8=24,MATCH(\"Diario\", BBDD!AE2:AJ2, 0),MATCH(D7, BBDD!AE2:AJ2, 0)), FALSE))) * VLOOKUP( D5, BBDD!B:E, COLUMNS(BBDD!B:E), FALSE ) / _xlfn.DAYS(EDATE(D11, 12), D11) ) * IF( D7 = BBDD!U7, D8 / 24, 1 ),  I5 + I6  ),\n              0  )","v":0}]
[null,null,{"$f":"IF( AND(D4 = \"Servicio agregado\", D5 <> BBDD!B13), \"Días de duración del servicio\", IF( D7 = \"Intradiario\", \"Horas de duración del servicio (H)\", \"\" ) )","v":""},null,{"$f":"IF( C8 <> \"\", LOWER( LEFT( C8, FIND(\" \", C8) - 1 ) ), \"\" )","v":""},null,"Cuota GTS",null,{"$f":"IF(  D20 <> \"\",  BBDD!B20 * SUM(I5:J7),  0  )","v":0}]
[null,null,null,null,null,null,"Tasa CNMC y Ministerio",null,{"$f":"IF(  D20 <> \"\",  BBDD!B21 * SUM(I5:J7),  0  )","v":0}]
[null,null,"Naturaleza",null,null,null,"Importe",null,{"$f":"SUM(I5:J9)","v":0}]
[null,null,"Fecha de inicio del servicio"]
[null,null,{"$f":"IF(AND(D4=\"Servicio agregado\",D4=BBDD!B13),\"Capacidad almacenamiento (Q)\",\"Capacidad a contratar (Q)\")","v":"Capacidad a contratar (Q)"},null,{"$f":"IF( D7 = \"Intradiario\", \"kWh/nº horas\", \"kWh/día\" )","v":"kWh/día"}]
[null,null,{"$f":"IF(D5=BBDD!B13,\"Volumen de inyección (Vi)\",\"Volumen de consumo (V)\")","v":"Volumen de consumo (V)"},null,{"$f":"IF(C13 <> \"\", \"kWh\", \"\" )","v":"kWh"}]
[null,null,{"$f":"IF( D5 = BBDD!B13, \"Volumen de extracción (Ve)\", \"\" )","v":""},null,{"$f":"IF(C14 <> \"\", \"kWh\", \"\" )","v":""}]
[null,null,"Prima subasta (Pr)",null,"€/(kWh/día)/año"]
[null,null,{"$f":"IF( D10 = BBDD!V4, \"Capacidad Interrumpida (Qi)\", \"\" )","v":""},null,{"$f":"IF( C16 <> \"\", \"kWh/día\", \"\" )","v":""}]
[null,null,{"$f":"IF( AND(D4 = \"Servicio agregado\", D5 <> BBDD!B13),\"Contrato Regasificación\",\" \")","v":" "},{"$f":"IFERROR(IF( AND(D4 = \"Servicio agregado\", D5 <> BBDD!B13),D12/D8,\" \"),\" \")","v":" "},{"$f":"IF(C17 <> \" \", \"kWh/día\", \"\" )","v":""}]
[null,null,null,null,null,null,"Importe Acumulado",null,{"$f":"SUM(K30:K506)","v":0}]
[null,null,"Fórmula del peaje a aplicar",{"$f":"IF(  D5 <> \"\",\n          IF(  D7 = BBDD!U7,\n                  SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( VLOOKUP( D5, BBDD!B:C, COLUMNS(BBDD!B:C), FALSE )  &  IF( D10 = BBDD!V4, \" - \"  &  VLOOKUP( D5, BBDD!B:D, COLUMNS(BBDD!B:D), FALSE ), \"\" ), \"D_año\", \"H_año\" ), \"D\", \"H\" ), \"1\", \"H\" ),\n                  VLOOKUP( D5, BBDD!B:C, COLUMNS(BBDD!B:C), FALSE )  &  IF( D10 = BBDD!V4, \" - \"  &  VLOOKUP( D5, BBDD!B:D, COLUMNS(BBDD!B:D), FALSE ), \"\" )  ),\n          \"\"  )","v":""}]
[null,null,null,{"$f":"IF(  AND( D7 <> \"\", D11 <> \"\", OR(D4 = \"Servicio individual\", D5 = BBDD!B13) ),\n          SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( D19, \"Qi\", D16*1), \"Q\", D12*1 ), \"Vi\", D13*1 ), \"Ve\", D14*1 ), \"V\", D13*1 ), \"Pr\", D15 ), \"Tc\", VLOOKUP( D5, BBDD!B:E, COLUMNS(BBDD!B:E), FALSE)),\"Tvi\", VLOOKUP( D5, BBDD!B:F, COLUMNS(BBDD!B:F), FALSE ) ), \"Tve\", VLOOKUP( D5, BBDD!B:G, COLUMNS(BBDD!B:G), FALSE ) ), \"Tv\", VLOOKUP( D5, BBDD!B:F, COLUMNS(BBDD!B:F), FALSE ) ), \"M\", IF(OR(D5 = BBDD!B3, D5 = BBDD!B4, D5 = BBDD!B5, D5 = BBDD!B13), _xlfn.IFS(OR(D5=BBDD!B3,D5=BBDD!B13),VLOOKUP(MONTH(D11),BBDD!N:S,(IF(D8=24,MATCH(\"Diario\",BBDD!N2:S2,0),MATCH(D7,BBDD!N2:S2,0))),FALSE),D5=BBDD!B4,VLOOKUP(MONTH(D11),BBDD!X:AC,(IF(D8=24,MATCH(\"Diario\",BBDD!X2:AC2,0),MATCH(D7,BBDD!X2:AC2,0))),FALSE),D5=BBDD!B5,VLOOKUP(MONTH(D11),BBDD!AE:AJ,IF(D8=24,MATCH(\"Diario\",BBDD!AE2:AJ2,0),MATCH(D7,BBDD!AE2:AJ2,0)),FALSE)),VLOOKUP(D5,BBDD!B:L,IF(D8=24,MATCH(\"Diario\",BBDD!B2:L2,0),MATCH(D7,BBDD!B2:L2,0)),FALSE))), \"D_año\", _xlfn.DAYS(EDATE(D11, 12), D11) ), \"D\", MAX( _xlfn.DAYS(EDATE(D11, IF(D7 = BBDD!H2, 12, IF(D7 = BBDD!I2, 3, IF(D7 = BBDD!J2, 1, 0)))), D11), 1 ) ), \"H_año\", _xlfn.DAYS(EDATE(D11, 12), D11) * 24 ), \"H\", D8*1 ), \"Fi\", 3 ),\n          IF(  OR(D5 = BBDD!B16, D5 = BBDD!B17),\n                  \"(La Descarga queda excluida del importe calculado al ser facturada por el Operador de Planta)\",\n                   IF(  OR(D5 = BBDD!B14, D5 = BBDD!B15),  \" \",  \"\"  )  )  )","v":""}]
[]
[]
[null,null,"* Estos cálculos no son vinculantes."]
[null,null,"* Valores totales por contrato. La facturación se realiza con periodicidad mensual. "]
[null,null,"* Se aplican los peajes y cánones vigentes para el año de gas 2025."]
[null,null,"* No se incluye el cálculo para contratos de origen \"Desbalance\", ni agregados con almacenamiento de descarga menor al 100%.",null,null,null,null,null,null,"Fecha actualización: ","2024-10-01"]
[]
[]
[null,"ID","Servicio","Producto","Duración","Naturaleza","Fecha Inicio","Capacidad","Volumen","Prima","Importe"]