{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Certificación Relación Mensual","Contador","Importes","Campos a Cubrir"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"Certificación Relación Mensual","index":0,"n_rows":44,"n_cols":174,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,7,7,8],[1,7,1,11],[2,7,2,11],[3,7,3,11],[8,37,8,38],[2,12,2,14],[2,16,2,33],[1,12,1,33],[3,12,3,33]]}
["IdN","IdX","ACHE","Proc","Num",null,"Meses",7,8,9,10,11,12,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,5,6,"Xornada","Achega","Dias","Contía","%PPE","Diascp","P.P. Extra","%CV","Diascv","Vacacións","NÓMINA",null,"IT","Baixa",null,null,null,null,null,null,null,null,"","","","","","","","","","","","",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,{"$f":"IF(DAY(VALUE(1&\"-\"&$AT$7&\"-\"&$AU$7)-1)>28,29,\"\")","v":29},{"$f":"IF(DAY(VALUE(1&\"-\"&$AT$7&\"-\"&$AU$7)-1)>29,30,\"\")","v":30},{"$f":"IF(DAY(VALUE(1&\"-\"&$AT$7&\"-\"&$AU$7)-1)>30,31,\"\")","v":""},"Trab.","Baixa",null,null,null,null,null,null,"inimes","finmes","diasnomina","diasbaixa","dbaixa","dalta","dbaixaat","dbaixait","Dias baixa mes","Diasconsumidos","Totdiasbaixa","ya subv.","Pedientes","DatainiCV","DiasCV","filas","Folla","Follas","1ºS 3","resto","os 12","- os 3 1ºS","os 12","Pago","Alt","Baix","NÓMINA","Data_nómina"]
[null,"area de impresión",null,null,null,null,null,"C.E.E. Solicitante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outubro","Novembro","Decembro","Xaneiro","Febreiro","Marzo","Abril","Maio","Xuño","Xullo","Agosto","Setembro"]
[null,"de",null,null,"A1",null,null,"DNI/NIF:",null,null,null,null,null,null,null,"NºExp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Certificación mensual da relación do cadro de persoal c/discapaciade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,11,12,1,2,3,4,5,6,7,8,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"VALUE(1&\"-\"&$EV$6&\"-\"&$EW$6)-1","v":"2025-10-31"}]
[null,"a",null,null,{"$f":"\"AV\"&IF(MAXA(B2:B38)=0,11,11+MAXA(B12:B44))","v":"AV20"},null,null,"Nome da persoa representante:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outubro","Novembro","Decembro","Xaneiro","Febreiro","Marzo","Abril","Maio","Xuño","Xullo","Agosto","Setembro"]
[null,null,null,null,null,null,null,"Tipo de Axuda: Subvencion para a financiación do custo salarial de todas a persoas traballadoras con discapacidade contratadas en C.E.E. do territorio da Comunidade Autónoma de Galicia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"VALUE(1&\"-\"&$AT$7&\"-\"&$AU$7)-1","v":"2025-11-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,"S    U    X    E    R    I    D    O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mes","año"]
[null,null,null,null,null,null,"Desde",{"$f":"IF($AU$5=VALUE(30&\"/\"&6&\"/\"&YEAR($AU$5)),\"Verán\",IF($AU$5=VALUE(31&\"/\"&12&\"/\"&YEAR($AU$5)),\"Inverno\",\"\"))","v":""},"Data_nómina",null,null,null,null,"50%SMI","65%SMI",null,"Tot",null,null,null,null,null,null,null,null,null,null,"Tot.P.",0,0,"Programa III: Programa de axudas ao mantemento do custo salarial nos C.E.E. (Procedemento TR341M)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mes","ano",null,null,null,null,null,null,null,null,null,null,null,null,"Totais","Achega Mes",null,null,"P.P.Extra",null,null,"Vacacións",null,{"$f":"VALUE(BQ11&\"/\"&MONTH($AU$5)&\"/\"&YEAR($AU$5))","v":"2025-11-01"},"2025-11-02","2025-11-03","2025-11-04","2025-11-05","2025-11-06","2025-11-07","2025-11-08","2025-11-09","2025-11-10","2025-11-11","2025-11-12","2025-11-13","2025-11-14","2025-11-15","2025-11-16","2025-11-17","2025-11-18","2025-11-19","2025-11-20","2025-11-21","2025-11-22","2025-11-23","2025-11-24","2025-11-25","2025-11-26","2025-11-27","2025-11-28","2025-11-29","2025-11-30",{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI(AK13=\"AT\";CO13;0)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convenio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MONTH(AR7)+1>12,MONTH(AR7)+1-12,MONTH(AR7)+1)","v":11},{"$f":"IF(MONTH(AR7)+1>12,YEAR(AR7)+1,YEAR(AR7))","v":2025}]
["Novo ",null,"Tot. Trab. CEE/RNT",null,null,null,"Certificación do cadro de ",null,{"$f":"DATE(IF(HLOOKUP(H8,BR2:CC3,2,FALSE)<10,YEAR(AR7)+1,YEAR(AR7)),HLOOKUP(H8,BR2:CC3,2,FALSE),1)","v":"2025-11-01"},null,"Cert.comprobada",null,"Si",{"$f":"SUMPRODUCT(($J$11:$J$980=P7)*($C$11:$C$980=0)*($AO$11:$AO$980=\"SI\")*((($AH$11:$AH$980<>0)+(($AN$11:$AN$980<>\"\")*($AN$11:$AN$980>0)))>0)/IF(COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P7,$C$11:$C$980,0,$AO$11:$AO$980,\"SI\")=0,1,COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P7,$C$11:$C$980,0,$AO$11:$AO$980,\"SI\")))","v":0},{"$f":"SUMPRODUCT(($J$11:$J$978=P7)*($C$11:$C$978=1)*($AO$11:$AO$978=\"SI\")*((($AH$11:$AH$978<>0)+(($AN$11:$AN$978<>\"\")*($AN$11:$AN$978>0)))>0)/MAX(1,COUNTIFS($H$11:$H$978,$H$11:$H$978,$J$11:$J$978,P7,$C$11:$C$978,1,$AO$11:$AO$978,\"SI\")))","v":0},"H","P.Trab",null,null,null,null,null,null,null,null,null,null,"Trab.",null,{"$f":"AB8","v":0},"Total  Achega mes",null,null,{"$f":"VALUE(SUBTOTAL(109,AH11:AH39))","v":0},"P.Extra",null,{"$f":"SUBTOTAL(9,AK12:AK44)","v":0},"T.c.Vacacións",null,{"$f":"SUBTOTAL(9,AN11:AN39)","v":0},null,"Periodo",null,"2025-10-01","2025-12-31",{"$f":"IF(MONTH(AH8)+1>12,MONTH(AH8)+1-12,MONTH(AH8)+1)","v":12},{"$f":"IF(MONTH(AH8)+1>12,YEAR(AH8)+1,YEAR(AH8))","v":2025},null,null,null,null,null,null,"Anexo X",null,null,null,null,null,null,{"$f":"SUBTOTAL(9,BI12:BI44)","v":0},null,null,{"$f":"SUBTOTAL(9,BL12:BL44)","v":0},null,null,{"$f":"SUBTOTAL(9,BO12:BO44)","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,"IT",15]
["IdX",{"$f":"MAXA(B12:B44)","v":9},"% Trab. c/discap.",null,null,{"$f":"IFERROR(AH9/F7,0)","v":0},"persoal do mes de ","Novembro",null,null,"Calculo correcto?",null,"Si",{"$f":"SUMPRODUCT(($J$11:$J$980=P8)*($C$11:$C$980=0)*($AO$11:$AO$980=\"SI\")*((($AH$11:$AH$980<>0)+(($AN$11:$AN$980<>\"\")*($AN$11:$AN$980>0)))>0)/IF(COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P8,$C$11:$C$980,0,$AO$11:$AO$980,\"SI\")=0,1,COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P8,$C$11:$C$980,0,$AO$11:$AO$980,\"SI\")))","v":0},{"$f":"SUMPRODUCT(($J$11:$J$980=P8)*($C$11:$C$980=1)*($AO$11:$AO$980=\"SI\")*((($AH$11:$AH$980<>0)+(($AN$11:$AN$980<>\"\")*($AN$11:$AN$980>0)))>0)/IF(COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P8,$C$11:$C$980,1,$AO$11:$AO$980,\"SI\")=0,1,COUNTIFS($H$11:$H$980,$H$11:$H$980,$J$11:$J$980,P8,$C$11:$C$980,1,$AO$11:$AO$980,\"SI\")))","v":0},"M",{"$f":"SUM(N7:O8)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N7:O8)","v":0},null,{"$f":"AB8*180/30","v":0},"Ordinaria",null,"x",{"$f":"I7","v":"2025-11-01"},"Semestal",null,null,"Tot. Certificación mes de",null,null,null,"Convc.Axudas",null,{"$f":"AS7+1","v":"2026-01-01"},"2026-09-30","mes","ano",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AT",1,null,{"$f":"DY8","v":"NON"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS9","v":"NON"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"incio",null,null,null,null,null,null,null,null,null,null,null,"fin"]
[{"$f":"MAXA(A11:A39)+1","v":1},null,"G","Cod","Salario mes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tot. P. Trab. mes",null,null,{"$f":"Q8","v":0},null,null,"Total Anexo X",{"$f":"H8","v":"Novembro"},null,{"$f":"AN7+AK7+AH7","v":0},null,null,null,"Conv. IT","NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Xeral mes de",null,{"$f":"H8","v":"Novembro"},null,null,null,{"$f":"BO7+BL7+BI7","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,"Total","Días","Días","Días",null,{"$f":"COLUMN()","v":107},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8,9,10,11,12,1,2,3,4,5,6]
["IdX","IdN",null,null,"Convenio","Nº Rexistro","Traballador",null,"Data",null,null,null,null,"Data","Data","Código","Tipo ",null,null,null,null,null,null,null,null,null,null,null,null,null,"%","Tipo",null,"Achega","%",null,"Comp.","%",null,"Comp.",null,"Dias","IT","I T  /  A T",null,"Conv",null,null,null,"Xust",null,"INF.","Copia ","Comun.","Anexo",null,null,"Anexo","%","Dias","Achega Mensual","%","Dias","Comp.","%","Dias","Comp.",null,"C","A","L","E","N","D","A","R","I","O",null,"D","E",null,"T","R","A","B","A","L","L","O",null,"D","O",null,"M","E","S",null,null,"Días","Días","Días","Baixa","Baixa","Baixa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tres primeros",null,null,null,null,null,null,null,null,null,null,"Dias  1º","1º Período",null,null,null,null,"Dias  2º","2º Periodo",null,null,null,null,null,null,{"$f":"$AR$7","v":"2025-10-01"},{"$f":"EU11+1","v":"2025-11-01"},{"$f":"EV11+1","v":"2025-12-01"},"2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01",{"$f":"EU10","v":"2025-10-01"},{"$f":"FG11+1","v":"2523-11-01"},{"$f":"FH11+1","v":"2524-12-01"},"2526-01-01","2626-02-01","2627-03-01","2628-04-01","2629-05-01","2630-06-01","2631-07-01","2632-08-01","2633-09-01"]
["IdN","IdX","D","RNT","Colectivo","Conv. Colect","(Apelido1 Apelido2, Nome)","N.I.F.","Nacemento","sexo","Discapacidade","Grao","Tipo","Alta ","Baixa","Contrato","Cont","Empresa","NIF","EXP","mes","total","Nomina","trab","DN","DA","DB","acheg","Rateo","+Cont","Xornada","Achega","Días","Mensual","Xornada2","Días3","P.P. Extra","Xornada4","Días5","Vacacións","Certific","Absentism","AT","Baixa6","Alta","Baixa7","Interindade","Observacións","Nómina","Pago","TC2","IDC","Cto","SEPE","XI","IDC8","TA2","XII","Xornada9","Sux.","Suxerida","Xornada10","Columna11","P.P. Extra12","Xornada13","Columna14","Vacacións15","Columna16","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Trab.","Baixa17","Baixa18","Acum ","xa sub","Pend","52","53","inimes","finmes","diasnomina","diasbaixa","dbaixa","dalta","dbaixaat","dbaixait","Dias baixa mes","Diasconsumidos","Totdiasbaixa","ya subv.","Pedientes","DatainiCV","DiasCV","0","Columna4","Columna5","1ºS 3","resto","os 12","- os 3 1ºS","os 126","Pago7","Alt","Baix","Certific8","Data_nómina","Columna9","Periodo","710","811","912","1013","1114","Periodo15","1216","117","218","319","420","521","622","31-10-25","30-11-25","31-12-25","31-01-26","28-02-26","31-03-26","30-04-26","31-05-26","30-06-26","31-07-26","31-08-26","30-09-26","31-10-2523","30-11-2524","31-12-2525","31-01-2626","28-02-2627","31-03-2628","30-04-2629","31-05-2630","30-06-2631","31-07-2632","31-08-2633","30-09-2634"]
[null,2,{"$f":"IF(AND(K12=\"\",L12=\"\"),\"\",IF(L12>=65,1,IF(AND(L12>=33,OR(K12=\"P. Cerebral\",K12=\"Enf. Mental\",K12=\"D. Intelectual\",K12=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G12,1,2)&(MID(G12,FIND(\" \",G12,1)+1,2))&IFERROR((MID(G12,FIND(\",\",G12,1)+2,1)),MID(G12,FIND(\" \",G12,FIND(\" \",G12,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P12,Importes!L:Q,2,FALSE),\"\")","v":""},{"$f":"IF(G12=\"\",\"\",$M$4)","v":""},{"$f":"IF(G12=\"\",\"\",#REF!)","v":""},{"$f":"IF(G12=\"\",\"\",#REF!)","v":""},{"$f":"IF(G12=\"\",\"\",IF($AH$8=\"Extra Inverno\",\"1/12/2016\",IF($AH$8=\"Extra Verán\",\"1/6/2017\",$AH$8)))","v":""},{"$f":"IF(G12=\"\",\"\",$AN$9)","v":""},{"$f":"IF(G12=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},{"$f":"$AH$9","v":0},{"$f":"IF(I12=\"\",\"\",DAY(I12)&\"/\"&MONTH(I12)&\"/\"&YEAR(I12))","v":""},{"$f":"IF(N12=\"\",\"\",DAY(N12)&\"/\"&MONTH(N12)&\"/\"&YEAR(N12))","v":""},{"$f":"IF(O12=\"\",\"\",DAY(O12)&\"/\"&MONTH(O12)&\"/\"&YEAR(O12))","v":""},{"$f":"MID(AF12,1,4)","v":"AM+E"},{"$f":"\"Si\"","v":"Si"},"2",null,{"$f":"IF(AC12=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},{"$f":"IFERROR(IF(OR(AD12=\"NS\",AD12=\"+CT\",AD12=\"<15días\",AD12=\"<15\",AD12=\"Non D.\",AF12=\"\"),0,IF(BH12-AP12<0,0,BH12-AP12)),0)","v":0},{"$f":"IFERROR(IF(OR(AD12=\"+CT\",AF12=\"\"),0,ROUND(IF(MOD(AG12,30)=0,QUOTIENT(AG12,30)*VLOOKUP(C12&AF12,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE12>100,0,$AE12)/100),AG12*VLOOKUP(C12&AF12,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE12>100,0,$AE12)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ12=\"\",\"\",AE12),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ12=\"\",\"\",IF(AJ12<180,AJ12*VLOOKUP(C12&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI12>100,0,$AI12)/100),IF(AJ12=180,VLOOKUP(C12&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI12>100,0,$AI12)/100),0))),0)","v":""},{"$f":"IFERROR(IF(AM12=\"\",\"\",AE12),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BN12,\"\"),\"\")","v":""},{"$f":"IF(AM12=\"\",\"\",IF(AM12>0,ROUND(IF(MOD(AM12,30)=0,QUOTIENT(AM12,30)*VLOOKUP(C12&IF(AC12=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL12>100,0,$AL12)/100),AM12*VLOOKUP(C12&IF(AC12=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL12>100,0,$AL12)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED12=\"NO\",\"\",ED12),\"\")","v":""},null,null,null,{"$f":"IF(AND(AR12<>\"\",O12>0),O12,\"\")","v":""},"Non",null,"",{"$f":"IF($AH12>0,\"X\",\"\")","v":""},"","","","","","","","","",100,{"$f":"IFERROR(IF(AF12=\"AM\",DF12,IF(AF12=\"AM+E\",DF12,IF(AF12=\"CP\",DO12,IF(AF12=\"CV\",DR12,IF(AF12=\"CV+E\",DR12))))),0)","v":0},{"$f":"IFERROR(IF(OR(AD12=\"+CT\",AF12=\"\"),0,ROUND(IF(MOD(AG12,30)=0,QUOTIENT(AG12,30)*VLOOKUP(C12&AF12,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE12>100,0,$AE12)/100),AG12*VLOOKUP(C12&AF12,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE12>100,0,$AE12)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK12=\"\",\"\",BG12),\"\")","v":""},{"$f":"IFERROR(ROUND(IF($AI$8=\"Anual\",0.5,1)*IF(AND(AF12=\"AM\",OR(EA12=\"ALINT\",EA12=\"AL\")),DO12,IF(AND(AF12=\"AM\",$AG$9=\"x\"),DO12,\"\")),0),\"\")","v":""},{"$f":"IF(AJ12=\"\",\"\",IF(AJ12>0,ROUND(IF(MOD(AJ12,30)=0,QUOTIENT(AJ12,30)*VLOOKUP(C12&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG12>100,0,$BG12)/100),BK12*VLOOKUP(C12&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG12>100,0,$BG12)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN12=\"\",\"\",BG12),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA12=\"ALINT\",EA12=\"AL\"),DR12,\"\"),\"\")","v":""},{"$f":"IF(AM12=\"\",\"\",IF(AM12>0,ROUND(IF(MOD(AM12,30)=0,QUOTIENT(AM12,30)*VLOOKUP(C12&IF(AC12=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG12>100,0,$BG12)/100),AM12*VLOOKUP(C12&IF(AC12=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG12>100,0,$BG12)/100)),2),0))","v":""},{"$f":"IF(IFERROR(VLOOKUP(H12,$AU$12:$AU$44,1,FALSE),\"\")=\"\",\"\",1)","v":""},{"$f":"IF(VALUE($A12)=0,\"\",IF(BQ$11=\"\",\"\",IF(AND($O12<>\"\",$O12<BQ$6),\"\",IF($N12>BQ$6,\"\",IF(AND(OR($O12=\"\",$O12>=BQ$6),$AR12=\"\",$AF12<>\"\"),\"F\",IF(AND($AR12<=BQ$6,OR($AS12=$O12,$AS12>=BQ$6,IF($AS12=\"\",$AU$5))),\"h\",IF($DE12>=BQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A12)=0,\"\",IF(CA$11=\"\",\"\",IF(AND($O12<>\"\",$O12<CA$6),\"\",IF($N12>CA$6,\"\",IF(AND(OR($O12=\"\",$O12>=CA$6),$AR12=\"\",$AF12<>\"\"),\"F\",IF(AND($AR12<=CA$6,OR($AS12=$O12,$AS12>=CA$6,IF($AS12=\"\",$AU$5))),\"h\",IF($DE12>=CA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A12)=0,\"\",IF(CK$11=\"\",\"\",IF(AND($O12<>\"\",$O12<CK$6),\"\",IF($N12>CK$6,\"\",IF(AND(OR($O12=\"\",$O12>=CK$6),$AR12=\"\",$AF12<>\"\"),\"F\",IF(AND($AR12<=CK$6,OR($AS12=$O12,$AS12>=CK$6,IF($AS12=\"\",$AU$5))),\"h\",IF($DE12>=CK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",{"$f":"IF(COUNTIF(BP12:CU12,\"F\")=0,0,COUNTIF(BP12:CU12,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP12:CU12,\"h\")=0,0,COUNTIF(BP12:CU12,\"h\"))","v":0},{"$f":"IF(OR(AQ12=\"IT\",AQ12=\"AT\"),DI12+1-(DH12),0)","v":0},{"$f":"IF(AQ12=\"AT\",1,IF(IF(AQ12=\"IT\",DI12+1-(DH12),0)>15,15,IF(AQ12=\"IT\",DI12+1-(DH12),0)))","v":0},{"$f":"IF(AQ12=\"IT\",IF(CX12-CW12>15,15,CX12-CW12),IF(AQ12=\"AT\",IF(CX12-CW12>1,1,CX12-CW12),0))","v":0},{"$f":"IF(OR(AT12=\"SI\",$DA$8=\"SI\"),CY12-CZ12,IF(AND(AT12<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ12<=3,IF(CY12-CZ12-3<=0,IF(AQ12=\"AT\",IF(CZ12=1,0,1),0),CY12-CZ12-(3-CZ12)),CY12-CZ12),0))","v":0},{"$f":"IF(COLUMN()>0,5,5)","v":5},0,{"$f":"IF(N12<$AH$8,$AH$8,N12)","v":"2025-11-01"},{"$f":"IF(O12=\"\",$AU$5,O12)","v":"2025-11-30"},{"$f":"IF(CV12+DG12>30,30,IF(AND(MONTH($I$7)=2,CV12>=DAY($AU$5),OR(AR12=\"\",AR12<=$I$7)),30,IF(CV12+DA12>30,30,CV12+DA12)))","v":0},{"$f":"DP12","v":0},{"$f":"IF(AQ12=\"at\",IF(DJ12<$AR$7,DJ12,IF(DJ12<$AH$8,$AH$8-1,DJ12)),DK12)","v":"2025-01-01"},{"$f":"IF(OR(AS12=\"\",AS12>$AU$5),IF(O12=\"\",$AU$5,IF(O12>$AU$5,$AU$5,O12)),AS12)","v":"2025-11-30"},{"$f":"IF(AQ12=\"AT\",DK12,0)","v":"00:00:00"},{"$f":"IF(IF(AR12=\"\",0,AR12)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR12)","v":"2025-01-01"},{"$f":"CW12","v":0},{"$f":"IF(OR(AQ12=\"IT\",AQ12=\"AT\"),IF(DH12<DD12,DD12-(DH12),0),0)","v":0},{"$f":"IF(OR(AQ12=\"IT\",AQ12=\"AT\"),DI12+1-(DH12),0)","v":0},{"$f":"IF(OR(AQ12=\"IT\",AQ12=\"AT\"),IF(DM12>=15,12,IF(DM12<15,DM12,DM12-3)),0)","v":0},{"$f":"IF(AND(AQ12=\"AT\",DN12-DL12=0),1,IF(AQ12=\"IT\",DZ12,0))","v":0},{"$f":"IF(N12<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N12)","v":"2025-01-01"},{"$f":"IF(O12=\"\",0,(DAYS360(DQ12,O12)+1)/30*2.5)","v":0},{"$f":"IFERROR(#REF!+IF(EE12=$I$7,1,0),0)","v":0},{"$f":"IF(DS12=\"\",\"\",IF(MOD(DS12,10)=0,QUOTIENT(DS12,10),QUOTIENT(DS12,10)+1))","v":0},{"$f":"QUOTIENT(COUNTIF(EE:EE,$I$7),10)+IF(MOD(COUNTIF(EE:EE,$I$7),10)>0,1,0)","v":0},{"$f":"IF(DO12>=3,3,DO12)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT12=\"SI\"),DV12,3-DV12)","v":3},{"$f":"IF(DM12>15,IF(OR($DY$8=\"SI\",$AT12=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT12=\"SI\"),DM12,DM12-DV12))","v":0},{"$f":"IF(DN12-DW12-DV12<0,0,IF(DN12-DW12-DV12>12,IF(OR($DY$8=\"SI\",$AT12=\"SI\"),15,12),IF(DN12-DW12-DV12>CW12,CW12-DW12,DN12-DW12-DV12)))","v":0},{"$f":"IF(DY12-DX12>=IF(OR($DY$8=\"SI\",$AT12=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT12=\"SI\"),15,12),DY12-DX12)","v":0},{"$f":"EB12&EC12&IF(OR(P12=510,P12=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N12)<YEAR($I$7),\"A\",IF(YEAR(N12)=YEAR($I$7),IF(MONTH(N12)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O12=\"\",\"A\",IF(YEAR(O12)>YEAR($I$7),\"A\",IF(YEAR(O12)=YEAR($I$7),IF(MONTH(O12)>MONTH($I$7),\"A\",IF(MONTH(O12)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L12<33,\"NO\",IF(OR(EA12=\"AA\",EA12=\"AL\"),\"SI\",IF(OR(EA12=\"AAINT\",EA12=\"ALINT\"),\"SI\",\"\"))),\"\")","v":"NO"},{"$f":"IFERROR(IF(ED12=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH12:EL12),0)","v":148},{"$f":"IF(OR(EU12=0,FG12=0),0,IF(FG12-EU12+1>30,30,FG12-EU12+1))","v":30},{"$f":"IF(OR(EV12=0,FH12=0),0,IF(FH12-EV12+1>30,30,FH12-EV12+1))","v":30},{"$f":"IF(OR(EW12=0,FI12=0),0,IF(FI12-EW12+1>30,30,FI12-EW12+1))","v":30},{"$f":"IF(OR(EX12=0,FJ12=0),0,IF(FJ12-EX12+1>30,30,FJ12-EX12+1))","v":30},{"$f":"IF(OR(EY12=0,FK12=0),0,IF(FK12-EY12+1>30,30,FK12-EY12+1))","v":28},{"$f":"IFERROR(SUM(EN12:ET12),0)","v":210},{"$f":"IF(OR(EZ12=0,FL12=0),0,IF(FL12-EZ12+1>30,30,FL12-EZ12+1))","v":30},{"$f":"IF(OR(FA12=0,FM12=0),0,IF(FM12-FA12+1>30,30,FM12-FA12+1))","v":30},{"$f":"IF(IF(OR(FB12=0,FN12=0),0,IF(FN12-FB12+1>30,30,FN12-FB12+1))>=28,30,IF(OR(FB12=0,FN12=0),0,IF(FN12-FB12+1>30,30,FN12-FB12+1)))","v":30},{"$f":"IF(OR(FC12=0,FO12=0),0,IF(FO12-FC12+1>30,30,FO12-FC12+1))","v":30},{"$f":"IF(OR(FD12=0,FP12=0),0,IF(FP12-FD12+1>30,30,FP12-FD12+1))","v":30},{"$f":"IF(OR(FE12=0,FQ12=0),0,IF(FQ12-FE12+1>30,30,FQ12-FE12+1))","v":30},{"$f":"IF(OR(FF12=0,FR12=0),0,IF(FR12-FF12+1>30,30,FR12-FF12+1))","v":30},{"$f":"IFERROR(IF($N12<=EU$11,1,IF(YEAR($N12)=YEAR(EU$11),IF(MONTH($N12)=MONTH(EU$11),DAY($N12),0))),0)","v":1},1,1,1,1,1,1,1,1,1,1,1,{"$f":"IFERROR(IF(OR($O12=\"\",$O12=0),DAY(FG$11),IF($O12>=FG$11,DAY(FG$11),IF(MONTH($O12)=MONTH(FG$11),DAY($O12),0))),0)","v":31},30,31,31,28,31,30,31,30,31,31,30]
[null,null,{"$f":"IF(AND(K13=\"\",L13=\"\"),\"\",IF(L13>=65,1,IF(AND(L13>=33,OR(K13=\"P. Cerebral\",K13=\"Enf. Mental\",K13=\"D. Intelectual\",K13=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G13,1,2)&(MID(G13,FIND(\" \",G13,1)+1,2))&IFERROR((MID(G13,FIND(\",\",G13,1)+2,1)),MID(G13,FIND(\" \",G13,FIND(\" \",G13,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P13,Importes!L:Q,2,FALSE),\"\")","v":""},{"$f":"IF(G13=\"\",\"\",$M$4)","v":""},{"$f":"IF(G13=\"\",\"\",$M$2)","v":""},{"$f":"IF(G13=\"\",\"\",$Q$2)","v":""},{"$f":"IF(G13=\"\",\"\",IF($AH$8=\"Extra Inverno\",\"1/12/2016\",IF($AH$8=\"Extra Verán\",\"1/6/2017\",$AH$8)))","v":""},{"$f":"IF(G13=\"\",\"\",$AN$9)","v":""},{"$f":"IF(G13=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),6,1)),\"Extra Verán\",\"\"))))","v":""},{"$f":"$AH$9","v":0},{"$f":"IF(I13=\"\",\"\",DAY(I13)&\"/\"&MONTH(I13)&\"/\"&YEAR(I13))","v":""},{"$f":"IF(N13=\"\",\"\",DAY(N13)&\"/\"&MONTH(N13)&\"/\"&YEAR(N13))","v":""},{"$f":"IF(O13=\"\",\"\",DAY(O13)&\"/\"&MONTH(O13)&\"/\"&YEAR(O13))","v":""},{"$f":"MID(AF13,1,4)","v":"AM+E"},{"$f":"\"Si\"","v":"Si"},null,null,{"$f":"IF(AC13=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},{"$f":"IFERROR(IF(OR(AD13=\"NS\",AD13=\"+CT\",AD13=\"<15días\",AD13=\"<15\",AD13=\"Non D.\",AF13=\"\"),0,IF(BH13-AP13<0,0,BH13-AP13)),0)","v":0},{"$f":"IFERROR(IF(OR(AD13=\"+CT\",AF13=\"\"),0,ROUND(IF(MOD(AG13,30)=0,QUOTIENT(AG13,30)*VLOOKUP(C13&AF13,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE13>100,0,$AE13)/100),AG13*VLOOKUP(C13&AF13,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE13>100,0,$AE13)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ13=\"\",\"\",AE13),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ13=\"\",\"\",IF(AJ13<180,AJ13*VLOOKUP(C13&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($AI13>100,0,$AI13)/100),IF(AJ13=180,VLOOKUP(C13&\"CP\",Importes!$A$2:$F$14,6,FALSE)*6*(IF($AI13>100,0,$AI13)/100),0))),0)","v":""},"","",{"$f":"IF(AM13=\"\",\"\",IF(AM13>0,ROUND(IF(MOD(AM13,30)=0,QUOTIENT(AM13,30)*VLOOKUP(C13&IF(AC13=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL13>100,0,$AL13)/100),AM13*VLOOKUP(C13&IF(AC13=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL13>100,0,$AL13)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED13=\"NO\",\"\",ED13),\"\")","v":""},null,null,null,{"$f":"IF(AND(AR13<>\"\",O13>0),O13,\"\")","v":""},null,null,null,{"$f":"IF($AH13>0,\"X\",\"\")","v":""},"","","","","","","","","",null,{"$f":"IFERROR(IF(AF13=\"AM\",DF13,IF(AF13=\"AM+E\",DF13,IF(AF13=\"CP\",DO13,IF(AF13=\"CV\",DR13,IF(AF13=\"CV+E\",DR13))))),0)","v":0},{"$f":"IFERROR(IF(OR(AD13=\"+CT\",AF13=\"\"),0,ROUND(IF(MOD(AG13,30)=0,QUOTIENT(AG13,30)*VLOOKUP(C13&AF13,Importes!$A$2:$F$14,6,FALSE)*(IF($AE13>100,0,$AE13)/100),AG13*VLOOKUP(C13&AF13,Importes!$A$2:$F$14,5,FALSE)*(IF($AE13>100,0,$AE13)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK13=\"\",\"\",BG13),\"\")","v":""},{"$f":"IFERROR(ROUND(IF($AI$8=\"Anual\",0.5,1)*IF(AND(AF13=\"AM\",OR(EA13=\"ALINT\",EA13=\"AL\")),DO13,IF(AND(AF13=\"AM\",$AG$9=\"x\"),DO13,\"\")),0),\"\")","v":""},{"$f":"IF(AJ13=\"\",\"\",IF(AJ13>0,ROUND(IF(MOD(AJ13,30)=0,QUOTIENT(AJ13,30)*VLOOKUP(C13&\"CP\",Importes!$A$2:$F$14,6,FALSE)*(IF($BG13>100,0,$BG13)/100),BK13*VLOOKUP(C13&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($BG13>100,0,$BG13)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN13=\"\",\"\",BG13),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA13=\"ALINT\",EA13=\"AL\"),DR13,\"\"),\"\")","v":""},{"$f":"IF(AM13=\"\",\"\",IF(AM13>0,ROUND(IF(MOD(AM13,30)=0,QUOTIENT(AM13,30)*VLOOKUP(C13&IF(AC13=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,6,FALSE)*(IF($BG13>100,0,$BG13)/100),AM13*VLOOKUP(C13&IF(AC13=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,5,FALSE)*(IF($BG13>100,0,$BG13)/100)),2),0))","v":""},{"$f":"IF(IFERROR(VLOOKUP(H13,$AU$12:$AU$45,1,FALSE),\"\")=\"\",\"\",1)","v":""},{"$f":"IF(VALUE($A13)=0,\"\",IF(BQ$11=\"\",\"\",IF(AND($O13<>\"\",$O13<BQ$6),\"\",IF($N13>BQ$6,\"\",IF(AND(OR($O13=\"\",$O13>=BQ$6),$AR13=\"\",$AF13<>\"\"),\"F\",IF(AND($AR13<=BQ$6,OR($AS13=$O13,$AS13>=BQ$6,IF($AS13=\"\",$AU$5))),\"h\",IF($DE13>=BQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(BP13:CU13,\"F\")=0,0,COUNTIF(BP13:CU13,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP13:CU13,\"h\")=0,0,COUNTIF(BP13:CU13,\"h\"))","v":0},{"$f":"IF(OR(AQ13=\"IT\",AQ13=\"AT\"),DI13+1-(DH13),0)","v":0},{"$f":"IF(AQ13=\"AT\",1,IF(IF(AQ13=\"IT\",DI13+1-(DH13),0)>15,15,IF(AQ13=\"IT\",DI13+1-(DH13),0)))","v":0},{"$f":"IF(AQ13=\"IT\",IF(CX13-CW13>15,15,CX13-CW13),IF(AQ13=\"AT\",IF(CX13-CW13>1,1,CX13-CW13),0))","v":0},{"$f":"IF(OR(AT13=\"SI\",$DA$8=\"SI\"),CY13-CZ13,IF(AND(AT13<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ13<=3,IF(CY13-CZ13-3<=0,IF(AQ13=\"AT\",IF(CZ13=1,0,1),0),CY13-CZ13-(3-CZ13)),CY13-CZ13),0))","v":0},{"$f":"IF(COLUMN()>0,5,5)","v":5},null,{"$f":"IF(N13<$AH$8,$AH$8,N13)","v":"2025-11-01"},{"$f":"IF(O13=\"\",$AU$5,O13)","v":"2025-11-30"},{"$f":"IF(CV13+DG13>30,30,IF(AND(MONTH($I$7)=2,CV13>=DAY($AU$5),OR(AR13=\"\",AR13<=$I$7)),30,IF(CV13+DA13>30,30,CV13+DA13)))","v":0},{"$f":"DP13","v":0},{"$f":"IF(AQ13=\"at\",IF(DJ13<$AR$7,DJ13,IF(DJ13<$AH$8,$AH$8-1,DJ13)),DK13)","v":"2025-01-01"},{"$f":"IF(OR(AS13=\"\",AS13>$AU$5),IF(O13=\"\",$AU$5,IF(O13>$AU$5,$AU$5,O13)),AS13)","v":"2025-11-30"},{"$f":"IF(AQ13=\"AT\",DK13,0)","v":"00:00:00"},{"$f":"IF(IF(AR13=\"\",0,AR13)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR13)","v":"2025-01-01"},{"$f":"CW13","v":0},{"$f":"IF(OR(AQ13=\"IT\",AQ13=\"AT\"),IF(DH13<DD13,DD13-(DH13),0),0)","v":0},{"$f":"IF(OR(AQ13=\"IT\",AQ13=\"AT\"),DI13+1-(DH13),0)","v":0},{"$f":"IF(OR(AQ13=\"IT\",AQ13=\"AT\"),IF(DM13>=15,12,IF(DM13<15,DM13,DM13-3)),0)","v":0},{"$f":"IF(AND(AQ13=\"AT\",DN13-DL13=0),1,IF(AQ13=\"IT\",DZ13,0))","v":0},{"$f":"IF(N13<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N13)","v":"2025-01-01"},{"$f":"IF(O13=\"\",0,(DAYS360(DQ13,O13)+1)/30*2.5)","v":0},{"$f":"IFERROR(DS12+IF(EE13=$I$7,1,0),0)","v":0},{"$f":"IF(DS13=\"\",\"\",IF(MOD(DS13,10)=0,QUOTIENT(DS13,10),QUOTIENT(DS13,10)+1))","v":0},0,{"$f":"IF(DO13>=3,3,DO13)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT13=\"SI\"),DV13,3-DV13)","v":3},{"$f":"IF(DM13>15,IF(OR($DY$8=\"SI\",$AT13=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT13=\"SI\"),DM13,DM13-DV13))","v":0},{"$f":"IF(DN13-DW13-DV13<0,0,IF(DN13-DW13-DV13>12,IF(OR($DY$8=\"SI\",$AT13=\"SI\"),15,12),IF(DN13-DW13-DV13>CW13,CW13-DW13,DN13-DW13-DV13)))","v":0},{"$f":"IF(DY13-DX13>=IF(OR($DY$8=\"SI\",$AT13=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT13=\"SI\"),15,12),DY13-DX13)","v":0},{"$f":"EB13&EC13&IF(OR(P13=510,P13=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N13)<YEAR($I$7),\"A\",IF(YEAR(N13)=YEAR($I$7),IF(MONTH(N13)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O13=\"\",\"A\",IF(YEAR(O13)>YEAR($I$7),\"A\",IF(YEAR(O13)=YEAR($I$7),IF(MONTH(O13)>MONTH($I$7),\"A\",IF(MONTH(O13)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L13<33,\"NO\",IF(OR(EA13=\"AA\",EA13=\"AL\"),\"SI\",IF(OR(EA13=\"AAINT\",EA13=\"ALINT\"),\"SI\",\"\"))),\"\")","v":"NO"},{"$f":"IFERROR(IF(ED13=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH13:EL13),0)","v":30},{"$f":"IF(OR(EU13=0,FG13=0),0,IF(FG13-EU13+1>30,30,FG13-EU13+1))","v":30},{"$f":"IF(OR(EV13=0,FH13=0),0,IF(FH13-EV13+1>30,30,FH13-EV13+1))","v":0},{"$f":"IF(OR(EW13=0,FI13=0),0,IF(FI13-EW13+1>30,30,FI13-EW13+1))","v":0},{"$f":"IF(OR(EX13=0,FJ13=0),0,IF(FJ13-EX13+1>30,30,FJ13-EX13+1))","v":0},{"$f":"IF(OR(EY13=0,FK13=0),0,IF(FK13-EY13+1>30,30,FK13-EY13+1))","v":0},{"$f":"IFERROR(SUM(EN13:ET13),0)","v":0},{"$f":"IF(OR(EZ13=0,FL13=0),0,IF(FL13-EZ13+1>30,30,FL13-EZ13+1))","v":0},{"$f":"IF(OR(FA13=0,FM13=0),0,IF(FM13-FA13+1>30,30,FM13-FA13+1))","v":0},{"$f":"IF(IF(OR(FB13=0,FN13=0),0,IF(FN13-FB13+1>30,30,FN13-FB13+1))>=28,30,IF(OR(FB13=0,FN13=0),0,IF(FN13-FB13+1>30,30,FN13-FB13+1)))","v":0},{"$f":"IF(OR(FC13=0,FO13=0),0,IF(FO13-FC13+1>30,30,FO13-FC13+1))","v":0},{"$f":"IF(OR(FD13=0,FP13=0),0,IF(FP13-FD13+1>30,30,FP13-FD13+1))","v":0},{"$f":"IF(OR(FE13=0,FQ13=0),0,IF(FQ13-FE13+1>30,30,FQ13-FE13+1))","v":0},{"$f":"IF(OR(FF13=0,FR13=0),0,IF(FR13-FF13+1>30,30,FR13-FF13+1))","v":0},{"$f":"IFERROR(IF($N13<=EU$11,1,IF(YEAR($N13)=YEAR(EU$11),IF(MONTH($N13)=MONTH(EU$11),DAY($N13),0))),0)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR($O13=\"\",$O13=0),DAY(FG$11),IF($O13>=FG$11,DAY(FG$11),IF(MONTH($O13)=MONTH(FG$11),DAY($O13),0))),0)","v":31}]
[null,3,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P14,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G14=\"\",\"\",#REF!)","v":""},{"$f":"IF(G14=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G14=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","3",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD14=\"+CT\",AF14=\"\"),0,ROUND(IF(MOD(AG14,30)=0,QUOTIENT(AG14,30)*VLOOKUP(C14&AF14,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE14>100,0,$AE14)/100),AG14*VLOOKUP(C14&AF14,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE14>100,0,$AE14)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ14=\"\",\"\",IF(AJ14<180,AJ14*VLOOKUP(C14&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI14>100,0,$AI14)/100),IF(AJ14=180,VLOOKUP(C14&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI14>100,0,$AI14)/100),0))),0)","v":""},"","",{"$f":"IF(AM14=\"\",\"\",IF(AM14>0,ROUND(IF(MOD(AM14,30)=0,QUOTIENT(AM14,30)*VLOOKUP(C14&IF(AC14=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL14>100,0,$AL14)/100),AM14*VLOOKUP(C14&IF(AC14=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL14>100,0,$AL14)/100)),2),0))","v":""},"",null,null,null,null,"Non",null,"","","","","","","","","","","",75,0,{"$f":"IFERROR(IF(OR(AD14=\"+CT\",AF14=\"\"),0,ROUND(IF(MOD(AG14,30)=0,QUOTIENT(AG14,30)*VLOOKUP(C14&AF14,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE14>100,0,$AE14)/100),AG14*VLOOKUP(C14&AF14,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE14>100,0,$AE14)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ14=\"\",\"\",IF(AJ14>0,ROUND(IF(MOD(AJ14,30)=0,QUOTIENT(AJ14,30)*VLOOKUP(C14&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG14>100,0,$BG14)/100),BK14*VLOOKUP(C14&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG14>100,0,$BG14)/100)),2),0))","v":""},"","",{"$f":"IF(AM14=\"\",\"\",IF(AM14>0,ROUND(IF(MOD(AM14,30)=0,QUOTIENT(AM14,30)*VLOOKUP(C14&IF(AC14=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG14>100,0,$BG14)/100),AM14*VLOOKUP(C14&IF(AC14=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG14>100,0,$BG14)/100)),2),0))","v":""},{"$f":"IF(IFERROR(VLOOKUP(H14,$AU$12:$AU$44,1,FALSE),\"\")=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,0,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(DS12+IF(EE14=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,5,{"$f":"IF(AND(K15=\"\",L15=\"\"),\"\",IF(L15>=65,1,IF(AND(L15>=33,OR(K15=\"P. Cerebral\",K15=\"Enf. Mental\",K15=\"D. Intelectual\",K15=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G15,1,2)&(MID(G15,FIND(\" \",G15,1)+1,2))&IFERROR((MID(G15,FIND(\",\",G15,1)+2,1)),MID(G15,FIND(\" \",G15,FIND(\" \",G15,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P15,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G15=\"\",\"\",#REF!)","v":""},{"$f":"IF(G15=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G15=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","4",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD15=\"+CT\",AF15=\"\"),0,ROUND(IF(MOD(AG15,30)=0,QUOTIENT(AG15,30)*VLOOKUP(C15&AF15,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE15>100,0,$AE15)/100),AG15*VLOOKUP(C15&AF15,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE15>100,0,$AE15)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ15=\"\",\"\",AE15),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ15=\"\",\"\",IF(AJ15<180,AJ15*VLOOKUP(C15&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI15>100,0,$AI15)/100),IF(AJ15=180,VLOOKUP(C15&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI15>100,0,$AI15)/100),0))),0)","v":""},{"$f":"IFERROR(IF(AM15=\"\",\"\",AE15),\"\")","v":""},"",{"$f":"IF(AM15=\"\",\"\",IF(AM15>0,ROUND(IF(MOD(AM15,30)=0,QUOTIENT(AM15,30)*VLOOKUP(C15&IF(AC15=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL15>100,0,$AL15)/100),AM15*VLOOKUP(C15&IF(AC15=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL15>100,0,$AL15)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED15=\"NO\",\"\",ED15),\"\")","v":""},null,null,{"$f":"IF(AQ15=\"IT\",N15,IF(AQ15=\"AT\",N15,\"\"))","v":""},{"$f":"IF(AND(AR15<>\"\",O15>0),O15,\"\")","v":""},"Non",null,"","","","","","","","","","","",62.5,0,{"$f":"IFERROR(IF(OR(AD15=\"+CT\",AF15=\"\"),0,ROUND(IF(MOD(AG15,30)=0,QUOTIENT(AG15,30)*VLOOKUP(C15&AF15,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE15>100,0,$AE15)/100),AG15*VLOOKUP(C15&AF15,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE15>100,0,$AE15)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK15=\"\",\"\",BG15),\"\")","v":""},"",{"$f":"IF(AJ15=\"\",\"\",IF(AJ15>0,ROUND(IF(MOD(AJ15,30)=0,QUOTIENT(AJ15,30)*VLOOKUP(C15&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG15>100,0,$BG15)/100),BK15*VLOOKUP(C15&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG15>100,0,$BG15)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN15=\"\",\"\",BG15),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA15=\"ALINT\",EA15=\"AL\"),DR15,\"\"),\"\")","v":""},{"$f":"IF(AM15=\"\",\"\",IF(AM15>0,ROUND(IF(MOD(AM15,30)=0,QUOTIENT(AM15,30)*VLOOKUP(C15&IF(AC15=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG15>100,0,$BG15)/100),AM15*VLOOKUP(C15&IF(AC15=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG15>100,0,$BG15)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(BP15:CU15,\"F\")=0,0,COUNTIF(BP15:CU15,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP15:CU15,\"h\")=0,0,COUNTIF(BP15:CU15,\"h\"))","v":0},{"$f":"IF(OR(AQ15=\"IT\",AQ15=\"AT\"),DI15+1-(DH15),0)","v":0},{"$f":"IF(AQ15=\"AT\",1,IF(IF(AQ15=\"IT\",DI15+1-(DH15),0)>15,15,IF(AQ15=\"IT\",DI15+1-(DH15),0)))","v":0},{"$f":"IF(AQ15=\"IT\",IF(CX15-CW15>15,15,CX15-CW15),IF(AQ15=\"AT\",IF(CX15-CW15>1,1,CX15-CW15),0))","v":0},{"$f":"IF(OR(AT15=\"SI\",$DA$8=\"SI\"),CY15-CZ15,IF(AND(AT15<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ15<=3,IF(CY15-CZ15-3<=0,IF(AQ15=\"AT\",IF(CZ15=1,0,1),0),CY15-CZ15-(3-CZ15)),CY15-CZ15),0))","v":0},5,0,{"$f":"IF(N15<$AH$8,$AH$8,N15)","v":"2025-11-01"},{"$f":"IF(O15=\"\",$AU$5,O15)","v":"2025-11-30"},{"$f":"IF(CV15+DG15>30,30,IF(AND(MONTH($I$7)=2,CV15>=DAY($AU$5),OR(AR15=\"\",AR15<=$I$7)),30,IF(CV15+DA15>30,30,CV15+DA15)))","v":0},{"$f":"DP15","v":0},{"$f":"IF(AQ15=\"at\",IF(DJ15<$AR$7,DJ15,IF(DJ15<$AH$8,$AH$8-1,DJ15)),DK15)","v":"2025-01-01"},{"$f":"IF(OR(AS15=\"\",AS15>$AU$5),IF(O15=\"\",$AU$5,IF(O15>$AU$5,$AU$5,O15)),AS15)","v":"2025-11-30"},{"$f":"IF(AQ15=\"AT\",DK15,0)","v":"00:00:00"},{"$f":"IF(IF(AR15=\"\",0,AR15)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR15)","v":"2025-01-01"},{"$f":"CW15","v":0},{"$f":"IF(OR(AQ15=\"IT\",AQ15=\"AT\"),IF(DH15<DD15,DD15-(DH15),0),0)","v":0},{"$f":"IF(OR(AQ15=\"IT\",AQ15=\"AT\"),DI15+1-(DH15),0)","v":0},{"$f":"IF(OR(AQ15=\"IT\",AQ15=\"AT\"),IF(DM15>=15,12,IF(DM15<15,DM15,DM15-3)),0)","v":0},{"$f":"IF(AND(AQ15=\"AT\",DN15-DL15=0),1,IF(AQ15=\"IT\",DZ15,0))","v":0},{"$f":"IF(N15<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N15)","v":"2025-01-01"},{"$f":"IF(O15=\"\",0,(DAYS360(DQ15,O15)+1)/30*2.5)","v":0},{"$f":"IFERROR(DS14+IF(EE15=$I$7,1,0),0)","v":0},{"$f":"IF(DS15=\"\",\"\",IF(MOD(DS15,10)=0,QUOTIENT(DS15,10),QUOTIENT(DS15,10)+1))","v":0},0,{"$f":"IF(DO15>=3,3,DO15)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT15=\"SI\"),DV15,3-DV15)","v":3},{"$f":"IF(DM15>15,IF(OR($DY$8=\"SI\",$AT15=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT15=\"SI\"),DM15,DM15-DV15))","v":0},{"$f":"IF(DN15-DW15-DV15<0,0,IF(DN15-DW15-DV15>12,IF(OR($DY$8=\"SI\",$AT15=\"SI\"),15,12),IF(DN15-DW15-DV15>CW15,CW15-DW15,DN15-DW15-DV15)))","v":0},{"$f":"IF(DY15-DX15>=IF(OR($DY$8=\"SI\",$AT15=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT15=\"SI\"),15,12),DY15-DX15)","v":0},{"$f":"EB15&EC15&IF(OR(P15=510,P15=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N15)<YEAR($I$7),\"A\",IF(YEAR(N15)=YEAR($I$7),IF(MONTH(N15)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O15=\"\",\"A\",IF(YEAR(O15)>YEAR($I$7),\"A\",IF(YEAR(O15)=YEAR($I$7),IF(MONTH(O15)>MONTH($I$7),\"A\",IF(MONTH(O15)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},"NO",{"$f":"IFERROR(IF(ED15=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH15:EL15),0)","v":148},{"$f":"IF(OR(EU15=0,FG15=0),0,IF(FG15-EU15+1>30,30,FG15-EU15+1))","v":30},{"$f":"IF(OR(EV15=0,FH15=0),0,IF(FH15-EV15+1>30,30,FH15-EV15+1))","v":30},{"$f":"IF(OR(EW15=0,FI15=0),0,IF(FI15-EW15+1>30,30,FI15-EW15+1))","v":30},{"$f":"IF(OR(EX15=0,FJ15=0),0,IF(FJ15-EX15+1>30,30,FJ15-EX15+1))","v":30},{"$f":"IF(OR(EY15=0,FK15=0),0,IF(FK15-EY15+1>30,30,FK15-EY15+1))","v":28},{"$f":"IFERROR(SUM(EN15:ET15),0)","v":210},{"$f":"IF(OR(EZ15=0,FL15=0),0,IF(FL15-EZ15+1>30,30,FL15-EZ15+1))","v":30},{"$f":"IF(OR(FA15=0,FM15=0),0,IF(FM15-FA15+1>30,30,FM15-FA15+1))","v":30},{"$f":"IF(IF(OR(FB15=0,FN15=0),0,IF(FN15-FB15+1>30,30,FN15-FB15+1))>=28,30,IF(OR(FB15=0,FN15=0),0,IF(FN15-FB15+1>30,30,FN15-FB15+1)))","v":30},{"$f":"IF(OR(FC15=0,FO15=0),0,IF(FO15-FC15+1>30,30,FO15-FC15+1))","v":30},{"$f":"IF(OR(FD15=0,FP15=0),0,IF(FP15-FD15+1>30,30,FP15-FD15+1))","v":30},{"$f":"IF(OR(FE15=0,FQ15=0),0,IF(FQ15-FE15+1>30,30,FQ15-FE15+1))","v":30},{"$f":"IF(OR(FF15=0,FR15=0),0,IF(FR15-FF15+1>30,30,FR15-FF15+1))","v":30},1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,null,{"$f":"IF(AND(K16=\"\",L16=\"\"),\"\",IF(L16>=65,1,IF(AND(L16>=33,OR(K16=\"P. Cerebral\",K16=\"Enf. Mental\",K16=\"D. Intelectual\",K16=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G16,1,2)&(MID(G16,FIND(\" \",G16,1)+1,2))&IFERROR((MID(G16,FIND(\",\",G16,1)+2,1)),MID(G16,FIND(\" \",G16,FIND(\" \",G16,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P16,Importes!L:Q,2,FALSE),\"\")","v":""},{"$f":"IF(G16=\"\",\"\",$M$4)","v":""},{"$f":"IF(G16=\"\",\"\",$M$2)","v":""},{"$f":"IF(G16=\"\",\"\",$Q$2)","v":""},{"$f":"IF(G16=\"\",\"\",IF($AH$8=\"Extra Inverno\",\"1/12/2016\",IF($AH$8=\"Extra Verán\",\"1/6/2017\",$AH$8)))","v":""},{"$f":"IF(G16=\"\",\"\",$AN$9)","v":""},{"$f":"IF(G16=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),6,1)),\"Extra Verán\",\"\"))))","v":""},{"$f":"$AH$9","v":0},{"$f":"IF(I16=\"\",\"\",DAY(I16)&\"/\"&MONTH(I16)&\"/\"&YEAR(I16))","v":""},{"$f":"IF(N16=\"\",\"\",DAY(N16)&\"/\"&MONTH(N16)&\"/\"&YEAR(N16))","v":""},{"$f":"IF(O16=\"\",\"\",DAY(O16)&\"/\"&MONTH(O16)&\"/\"&YEAR(O16))","v":""},{"$f":"MID(AF16,1,4)","v":"AM+E"},{"$f":"\"Si\"","v":"Si"},null,null,{"$f":"IF(AC16=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},{"$f":"IFERROR(IF(OR(AD16=\"NS\",AD16=\"+CT\",AD16=\"<15días\",AD16=\"<15\",AD16=\"Non D.\",AF16=\"\"),0,IF(BH16-AP16<0,0,BH16-AP16)),0)","v":0},{"$f":"IFERROR(IF(OR(AD16=\"+CT\",AF16=\"\"),0,ROUND(IF(MOD(AG16,30)=0,QUOTIENT(AG16,30)*VLOOKUP(C16&AF16,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE16>100,0,$AE16)/100),AG16*VLOOKUP(C16&AF16,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE16>100,0,$AE16)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ16=\"\",\"\",AE16),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ16=\"\",\"\",IF(AJ16<180,AJ16*VLOOKUP(C16&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($AI16>100,0,$AI16)/100),IF(AJ16=180,VLOOKUP(C16&\"CP\",Importes!$A$2:$F$14,6,FALSE)*6*(IF($AI16>100,0,$AI16)/100),0))),0)","v":""},{"$f":"IFERROR(IF(AM16=\"\",\"\",AE16),\"\")","v":""},"",{"$f":"IF(AM16=\"\",\"\",IF(AM16>0,ROUND(IF(MOD(AM16,30)=0,QUOTIENT(AM16,30)*VLOOKUP(C16&IF(AC16=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL16>100,0,$AL16)/100),AM16*VLOOKUP(C16&IF(AC16=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL16>100,0,$AL16)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED16=\"NO\",\"\",ED16),\"\")","v":""},null,null,{"$f":"IF(AQ16=\"IT\",N16,IF(AQ16=\"AT\",N16,\"\"))","v":""},{"$f":"IF(AND(AR16<>\"\",O16>0),O16,\"\")","v":""},null,null,null,{"$f":"IF($AH16>0,\"X\",\"\")","v":""},"","","","","","","","","",null,{"$f":"IFERROR(IF(AF16=\"AM\",DF16,IF(AF16=\"AM+E\",DF16,IF(AF16=\"CP\",DO16,IF(AF16=\"CV\",DR16,IF(AF16=\"CV+E\",DR16))))),0)","v":0},{"$f":"IFERROR(IF(OR(AD16=\"+CT\",AF16=\"\"),0,ROUND(IF(MOD(AG16,30)=0,QUOTIENT(AG16,30)*VLOOKUP(C16&AF16,Importes!$A$2:$F$14,6,FALSE)*(IF($AE16>100,0,$AE16)/100),AG16*VLOOKUP(C16&AF16,Importes!$A$2:$F$14,5,FALSE)*(IF($AE16>100,0,$AE16)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK16=\"\",\"\",BG16),\"\")","v":""},{"$f":"IFERROR(ROUND(IF($AI$8=\"Anual\",0.5,1)*IF(AND(AF16=\"AM\",OR(EA16=\"ALINT\",EA16=\"AL\")),DO16,IF(AND(AF16=\"AM\",$AG$9=\"x\"),DO16,\"\")),0),\"\")","v":""},{"$f":"IF(AJ16=\"\",\"\",IF(AJ16>0,ROUND(IF(MOD(AJ16,30)=0,QUOTIENT(AJ16,30)*VLOOKUP(C16&\"CP\",Importes!$A$2:$F$14,6,FALSE)*(IF($BG16>100,0,$BG16)/100),BK16*VLOOKUP(C16&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($BG16>100,0,$BG16)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN16=\"\",\"\",BG16),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA16=\"ALINT\",EA16=\"AL\"),DR16,\"\"),\"\")","v":""},{"$f":"IF(AM16=\"\",\"\",IF(AM16>0,ROUND(IF(MOD(AM16,30)=0,QUOTIENT(AM16,30)*VLOOKUP(C16&IF(AC16=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,6,FALSE)*(IF($BG16>100,0,$BG16)/100),AM16*VLOOKUP(C16&IF(AC16=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,5,FALSE)*(IF($BG16>100,0,$BG16)/100)),2),0))","v":""},"",{"$f":"IF(VALUE($A16)=0,\"\",IF(BQ$11=\"\",\"\",IF(AND($O16<>\"\",$O16<BQ$6),\"\",IF($N16>BQ$6,\"\",IF(AND(OR($O16=\"\",$O16>=BQ$6),$AR16=\"\",$AF16<>\"\"),\"F\",IF(AND($AR16<=BQ$6,OR($AS16=$O16,$AS16>=BQ$6,IF($AS16=\"\",$AU$5))),\"h\",IF($DE16>=BQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(BP16:CU16,\"F\")=0,0,COUNTIF(BP16:CU16,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP16:CU16,\"h\")=0,0,COUNTIF(BP16:CU16,\"h\"))","v":0},{"$f":"IF(OR(AQ16=\"IT\",AQ16=\"AT\"),DI16+1-(DH16),0)","v":0},{"$f":"IF(AQ16=\"AT\",1,IF(IF(AQ16=\"IT\",DI16+1-(DH16),0)>15,15,IF(AQ16=\"IT\",DI16+1-(DH16),0)))","v":0},{"$f":"IF(AQ16=\"IT\",IF(CX16-CW16>15,15,CX16-CW16),IF(AQ16=\"AT\",IF(CX16-CW16>1,1,CX16-CW16),0))","v":0},{"$f":"IF(OR(AT16=\"SI\",$DA$8=\"SI\"),CY16-CZ16,IF(AND(AT16<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ16<=3,IF(CY16-CZ16-3<=0,IF(AQ16=\"AT\",IF(CZ16=1,0,1),0),CY16-CZ16-(3-CZ16)),CY16-CZ16),0))","v":0},{"$f":"IF(COLUMN()>0,5,5)","v":5},null,{"$f":"IF(N16<$AH$8,$AH$8,N16)","v":"2025-11-01"},{"$f":"IF(O16=\"\",$AU$5,O16)","v":"2025-11-30"},{"$f":"IF(CV16+DG16>30,30,IF(AND(MONTH($I$7)=2,CV16>=DAY($AU$5),OR(AR16=\"\",AR16<=$I$7)),30,IF(CV16+DA16>30,30,CV16+DA16)))","v":0},{"$f":"DP16","v":0},{"$f":"IF(AQ16=\"at\",IF(DJ16<$AR$7,DJ16,IF(DJ16<$AH$8,$AH$8-1,DJ16)),DK16)","v":"2025-01-01"},{"$f":"IF(OR(AS16=\"\",AS16>$AU$5),IF(O16=\"\",$AU$5,IF(O16>$AU$5,$AU$5,O16)),AS16)","v":"2025-11-30"},{"$f":"IF(AQ16=\"AT\",DK16,0)","v":"00:00:00"},{"$f":"IF(IF(AR16=\"\",0,AR16)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR16)","v":"2025-01-01"},{"$f":"CW16","v":0},{"$f":"IF(OR(AQ16=\"IT\",AQ16=\"AT\"),IF(DH16<DD16,DD16-(DH16),0),0)","v":0},{"$f":"IF(OR(AQ16=\"IT\",AQ16=\"AT\"),DI16+1-(DH16),0)","v":0},{"$f":"IF(OR(AQ16=\"IT\",AQ16=\"AT\"),IF(DM16>=15,12,IF(DM16<15,DM16,DM16-3)),0)","v":0},{"$f":"IF(AND(AQ16=\"AT\",DN16-DL16=0),1,IF(AQ16=\"IT\",DZ16,0))","v":0},{"$f":"IF(N16<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N16)","v":"2025-01-01"},{"$f":"IF(O16=\"\",0,(DAYS360(DQ16,O16)+1)/30*2.5)","v":0},{"$f":"IFERROR(DS15+IF(EE16=$I$7,1,0),0)","v":0},{"$f":"IF(DS16=\"\",\"\",IF(MOD(DS16,10)=0,QUOTIENT(DS16,10),QUOTIENT(DS16,10)+1))","v":0},0,{"$f":"IF(DO16>=3,3,DO16)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT16=\"SI\"),DV16,3-DV16)","v":3},{"$f":"IF(DM16>15,IF(OR($DY$8=\"SI\",$AT16=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT16=\"SI\"),DM16,DM16-DV16))","v":0},{"$f":"IF(DN16-DW16-DV16<0,0,IF(DN16-DW16-DV16>12,IF(OR($DY$8=\"SI\",$AT16=\"SI\"),15,12),IF(DN16-DW16-DV16>CW16,CW16-DW16,DN16-DW16-DV16)))","v":0},{"$f":"IF(DY16-DX16>=IF(OR($DY$8=\"SI\",$AT16=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT16=\"SI\"),15,12),DY16-DX16)","v":0},{"$f":"EB16&EC16&IF(OR(P16=510,P16=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N16)<YEAR($I$7),\"A\",IF(YEAR(N16)=YEAR($I$7),IF(MONTH(N16)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O16=\"\",\"A\",IF(YEAR(O16)>YEAR($I$7),\"A\",IF(YEAR(O16)=YEAR($I$7),IF(MONTH(O16)>MONTH($I$7),\"A\",IF(MONTH(O16)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L16<33,\"NO\",IF(OR(EA16=\"AA\",EA16=\"AL\"),\"SI\",IF(OR(EA16=\"AAINT\",EA16=\"ALINT\"),\"SI\",\"\"))),\"\")","v":"NO"},{"$f":"IFERROR(IF(ED16=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH16:EL16),0)","v":30},{"$f":"IF(OR(EU16=0,FG16=0),0,IF(FG16-EU16+1>30,30,FG16-EU16+1))","v":30},{"$f":"IF(OR(EV16=0,FH16=0),0,IF(FH16-EV16+1>30,30,FH16-EV16+1))","v":0},{"$f":"IF(OR(EW16=0,FI16=0),0,IF(FI16-EW16+1>30,30,FI16-EW16+1))","v":0},{"$f":"IF(OR(EX16=0,FJ16=0),0,IF(FJ16-EX16+1>30,30,FJ16-EX16+1))","v":0},{"$f":"IF(OR(EY16=0,FK16=0),0,IF(FK16-EY16+1>30,30,FK16-EY16+1))","v":0},{"$f":"IFERROR(SUM(EN16:ET16),0)","v":0},{"$f":"IF(OR(EZ16=0,FL16=0),0,IF(FL16-EZ16+1>30,30,FL16-EZ16+1))","v":0},{"$f":"IF(OR(FA16=0,FM16=0),0,IF(FM16-FA16+1>30,30,FM16-FA16+1))","v":0},{"$f":"IF(IF(OR(FB16=0,FN16=0),0,IF(FN16-FB16+1>30,30,FN16-FB16+1))>=28,30,IF(OR(FB16=0,FN16=0),0,IF(FN16-FB16+1>30,30,FN16-FB16+1)))","v":0},{"$f":"IF(OR(FC16=0,FO16=0),0,IF(FO16-FC16+1>30,30,FO16-FC16+1))","v":0},{"$f":"IF(OR(FD16=0,FP16=0),0,IF(FP16-FD16+1>30,30,FP16-FD16+1))","v":0},{"$f":"IF(OR(FE16=0,FQ16=0),0,IF(FQ16-FE16+1>30,30,FQ16-FE16+1))","v":0},{"$f":"IF(OR(FF16=0,FR16=0),0,IF(FR16-FF16+1>30,30,FR16-FF16+1))","v":0},{"$f":"IFERROR(IF($N16<=EU$11,1,IF(YEAR($N16)=YEAR(EU$11),IF(MONTH($N16)=MONTH(EU$11),DAY($N16),0))),0)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR($O16=\"\",$O16=0),DAY(FG$11),IF($O16>=FG$11,DAY(FG$11),IF(MONTH($O16)=MONTH(FG$11),DAY($O16),0))),0)","v":31}]
[null,6,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P17,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G17=\"\",\"\",#REF!)","v":""},{"$f":"IF(G17=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G17=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","5",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD17=\"+CT\",AF17=\"\"),0,ROUND(IF(MOD(AG17,30)=0,QUOTIENT(AG17,30)*VLOOKUP(C17&AF17,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE17>100,0,$AE17)/100),AG17*VLOOKUP(C17&AF17,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE17>100,0,$AE17)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ17=\"\",\"\",IF(AJ17<180,AJ17*VLOOKUP(C17&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI17>100,0,$AI17)/100),IF(AJ17=180,VLOOKUP(C17&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI17>100,0,$AI17)/100),0))),0)","v":""},"","",{"$f":"IF(AM17=\"\",\"\",IF(AM17>0,ROUND(IF(MOD(AM17,30)=0,QUOTIENT(AM17,30)*VLOOKUP(C17&IF(AC17=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL17>100,0,$AL17)/100),AM17*VLOOKUP(C17&IF(AC17=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL17>100,0,$AL17)/100)),2),0))","v":""},"",null,null,{"$f":"IF(AQ17=\"IT\",N17,IF(AQ17=\"AT\",N17,\"\"))","v":""},"","Non",null,"","","","","","","","","","","",75,0,{"$f":"IFERROR(IF(OR(AD17=\"+CT\",AF17=\"\"),0,ROUND(IF(MOD(AG17,30)=0,QUOTIENT(AG17,30)*VLOOKUP(C17&AF17,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE17>100,0,$AE17)/100),AG17*VLOOKUP(C17&AF17,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE17>100,0,$AE17)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ17=\"\",\"\",IF(AJ17>0,ROUND(IF(MOD(AJ17,30)=0,QUOTIENT(AJ17,30)*VLOOKUP(C17&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG17>100,0,$BG17)/100),BK17*VLOOKUP(C17&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG17>100,0,$BG17)/100)),2),0))","v":""},"","",{"$f":"IF(AM17=\"\",\"\",IF(AM17>0,ROUND(IF(MOD(AM17,30)=0,QUOTIENT(AM17,30)*VLOOKUP(C17&IF(AC17=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG17>100,0,$BG17)/100),AM17*VLOOKUP(C17&IF(AC17=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG17>100,0,$BG17)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(DS15+IF(EE17=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,7,{"$f":"IF(AND(K18=\"\",L18=\"\"),\"\",IF(L18>=65,1,IF(AND(L18>=33,OR(K18=\"P. Cerebral\",K18=\"Enf. Mental\",K18=\"D. Intelectual\",K18=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G18,1,2)&(MID(G18,FIND(\" \",G18,1)+1,2))&IFERROR((MID(G18,FIND(\",\",G18,1)+2,1)),MID(G18,FIND(\" \",G18,FIND(\" \",G18,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P18,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G18=\"\",\"\",#REF!)","v":""},{"$f":"IF(G18=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G18=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","7",null,{"$f":"IF(AC18=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},{"$f":"IFERROR(IF(OR(AD18=\"NS\",AD18=\"+CT\",AD18=\"<15días\",AD18=\"<15\",AD18=\"Non D.\",AF18=\"\"),0,IF(BH18-AP18<0,0,BH18-AP18)),0)","v":0},{"$f":"IFERROR(IF(OR(AD18=\"+CT\",AF18=\"\"),0,ROUND(IF(MOD(AG18,30)=0,QUOTIENT(AG18,30)*VLOOKUP(C18&AF18,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE18>100,0,$AE18)/100),AG18*VLOOKUP(C18&AF18,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE18>100,0,$AE18)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ18=\"\",\"\",AE18),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ18=\"\",\"\",IF(AJ18<180,AJ18*VLOOKUP(C18&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI18>100,0,$AI18)/100),IF(AJ18=180,VLOOKUP(C18&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI18>100,0,$AI18)/100),0))),0)","v":""},"","",{"$f":"IF(AM18=\"\",\"\",IF(AM18>0,ROUND(IF(MOD(AM18,30)=0,QUOTIENT(AM18,30)*VLOOKUP(C18&IF(AC18=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL18>100,0,$AL18)/100),AM18*VLOOKUP(C18&IF(AC18=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL18>100,0,$AL18)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED18=\"NO\",\"\",ED18),\"\")","v":""},null,null,null,{"$f":"IF(AND(AR18<>\"\",O18>0),O18,\"\")","v":""},"Non",null,"","","","","","","","","","","",62.5,{"$f":"IFERROR(IF(AF18=\"AM\",DF18,IF(AF18=\"AM+E\",DF18,IF(AF18=\"CP\",DO18,IF(AF18=\"CV\",DR18,IF(AF18=\"CV+E\",DR18))))),0)","v":0},{"$f":"IFERROR(IF(OR(AD18=\"+CT\",AF18=\"\"),0,ROUND(IF(MOD(AG18,30)=0,QUOTIENT(AG18,30)*VLOOKUP(C18&AF18,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE18>100,0,$AE18)/100),AG18*VLOOKUP(C18&AF18,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE18>100,0,$AE18)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK18=\"\",\"\",BG18),\"\")","v":""},{"$f":"IFERROR(ROUND(IF($AI$8=\"Anual\",0.5,1)*IF(AND(AF18=\"AM\",OR(EA18=\"ALINT\",EA18=\"AL\")),DO18,IF(AND(AF18=\"AM\",$AG$9=\"x\"),DO18,\"\")),0),\"\")","v":""},{"$f":"IF(AJ18=\"\",\"\",IF(AJ18>0,ROUND(IF(MOD(AJ18,30)=0,QUOTIENT(AJ18,30)*VLOOKUP(C18&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG18>100,0,$BG18)/100),BK18*VLOOKUP(C18&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG18>100,0,$BG18)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN18=\"\",\"\",BG18),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA18=\"ALINT\",EA18=\"AL\"),DR18,\"\"),\"\")","v":""},{"$f":"IF(AM18=\"\",\"\",IF(AM18>0,ROUND(IF(MOD(AM18,30)=0,QUOTIENT(AM18,30)*VLOOKUP(C18&IF(AC18=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG18>100,0,$BG18)/100),AM18*VLOOKUP(C18&IF(AC18=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG18>100,0,$BG18)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(BP18:CU18,\"F\")=0,0,COUNTIF(BP18:CU18,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP18:CU18,\"h\")=0,0,COUNTIF(BP18:CU18,\"h\"))","v":0},{"$f":"IF(OR(AQ18=\"IT\",AQ18=\"AT\"),DI18+1-(DH18),0)","v":0},{"$f":"IF(AQ18=\"AT\",1,IF(IF(AQ18=\"IT\",DI18+1-(DH18),0)>15,15,IF(AQ18=\"IT\",DI18+1-(DH18),0)))","v":0},{"$f":"IF(AQ18=\"IT\",IF(CX18-CW18>15,15,CX18-CW18),IF(AQ18=\"AT\",IF(CX18-CW18>1,1,CX18-CW18),0))","v":0},{"$f":"IF(OR(AT18=\"SI\",$DA$8=\"SI\"),CY18-CZ18,IF(AND(AT18<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ18<=3,IF(CY18-CZ18-3<=0,IF(AQ18=\"AT\",IF(CZ18=1,0,1),0),CY18-CZ18-(3-CZ18)),CY18-CZ18),0))","v":0},5,5,{"$f":"IF(N18<$AH$8,$AH$8,N18)","v":"2025-11-01"},{"$f":"IF(O18=\"\",$AU$5,O18)","v":"2025-11-30"},{"$f":"IF(CV18+DG18>30,30,IF(AND(MONTH($I$7)=2,CV18>=DAY($AU$5),OR(AR18=\"\",AR18<=$I$7)),30,IF(CV18+DA18>30,30,CV18+DA18)))","v":0},{"$f":"DP18","v":0},{"$f":"IF(AQ18=\"at\",IF(DJ18<$AR$7,DJ18,IF(DJ18<$AH$8,$AH$8-1,DJ18)),DK18)","v":"2025-01-01"},{"$f":"IF(OR(AS18=\"\",AS18>$AU$5),IF(O18=\"\",$AU$5,IF(O18>$AU$5,$AU$5,O18)),AS18)","v":"2025-11-30"},{"$f":"IF(AQ18=\"AT\",DK18,0)","v":"00:00:00"},{"$f":"IF(IF(AR18=\"\",0,AR18)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR18)","v":"2025-01-01"},{"$f":"CW18","v":0},{"$f":"IF(OR(AQ18=\"IT\",AQ18=\"AT\"),IF(DH18<DD18,DD18-(DH18),0),0)","v":0},{"$f":"IF(OR(AQ18=\"IT\",AQ18=\"AT\"),DI18+1-(DH18),0)","v":0},{"$f":"IF(OR(AQ18=\"IT\",AQ18=\"AT\"),IF(DM18>=15,12,IF(DM18<15,DM18,DM18-3)),0)","v":0},{"$f":"IF(AND(AQ18=\"AT\",DN18-DL18=0),1,IF(AQ18=\"IT\",DZ18,0))","v":0},{"$f":"IF(N18<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N18)","v":"2025-01-01"},{"$f":"IF(O18=\"\",0,(DAYS360(DQ18,O18)+1)/30*2.5)","v":0},{"$f":"IFERROR(#REF!+IF(EE18=$I$7,1,0),0)","v":0},{"$f":"IF(DS18=\"\",\"\",IF(MOD(DS18,10)=0,QUOTIENT(DS18,10),QUOTIENT(DS18,10)+1))","v":0},0,{"$f":"IF(DO18>=3,3,DO18)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT18=\"SI\"),DV18,3-DV18)","v":3},{"$f":"IF(DM18>15,IF(OR($DY$8=\"SI\",$AT18=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT18=\"SI\"),DM18,DM18-DV18))","v":0},{"$f":"IF(DN18-DW18-DV18<0,0,IF(DN18-DW18-DV18>12,IF(OR($DY$8=\"SI\",$AT18=\"SI\"),15,12),IF(DN18-DW18-DV18>CW18,CW18-DW18,DN18-DW18-DV18)))","v":0},{"$f":"IF(DY18-DX18>=IF(OR($DY$8=\"SI\",$AT18=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT18=\"SI\"),15,12),DY18-DX18)","v":0},{"$f":"EB18&EC18&IF(OR(P18=510,P18=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N18)<YEAR($I$7),\"A\",IF(YEAR(N18)=YEAR($I$7),IF(MONTH(N18)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O18=\"\",\"A\",IF(YEAR(O18)>YEAR($I$7),\"A\",IF(YEAR(O18)=YEAR($I$7),IF(MONTH(O18)>MONTH($I$7),\"A\",IF(MONTH(O18)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L18<33,\"NO\",IF(OR(EA18=\"AA\",EA18=\"AL\"),\"SI\",IF(OR(EA18=\"AAINT\",EA18=\"ALINT\"),\"SI\",\"\"))),\"\")","v":"NO"},{"$f":"IFERROR(IF(ED18=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH18:EL18),0)","v":148},{"$f":"IF(OR(EU18=0,FG18=0),0,IF(FG18-EU18+1>30,30,FG18-EU18+1))","v":30},{"$f":"IF(OR(EV18=0,FH18=0),0,IF(FH18-EV18+1>30,30,FH18-EV18+1))","v":30},{"$f":"IF(OR(EW18=0,FI18=0),0,IF(FI18-EW18+1>30,30,FI18-EW18+1))","v":30},{"$f":"IF(OR(EX18=0,FJ18=0),0,IF(FJ18-EX18+1>30,30,FJ18-EX18+1))","v":30},{"$f":"IF(OR(EY18=0,FK18=0),0,IF(FK18-EY18+1>30,30,FK18-EY18+1))","v":28},{"$f":"IFERROR(SUM(EN18:ET18),0)","v":210},{"$f":"IF(OR(EZ18=0,FL18=0),0,IF(FL18-EZ18+1>30,30,FL18-EZ18+1))","v":30},{"$f":"IF(OR(FA18=0,FM18=0),0,IF(FM18-FA18+1>30,30,FM18-FA18+1))","v":30},{"$f":"IF(IF(OR(FB18=0,FN18=0),0,IF(FN18-FB18+1>30,30,FN18-FB18+1))>=28,30,IF(OR(FB18=0,FN18=0),0,IF(FN18-FB18+1>30,30,FN18-FB18+1)))","v":30},{"$f":"IF(OR(FC18=0,FO18=0),0,IF(FO18-FC18+1>30,30,FO18-FC18+1))","v":30},{"$f":"IF(OR(FD18=0,FP18=0),0,IF(FP18-FD18+1>30,30,FP18-FD18+1))","v":30},{"$f":"IF(OR(FE18=0,FQ18=0),0,IF(FQ18-FE18+1>30,30,FQ18-FE18+1))","v":30},{"$f":"IF(OR(FF18=0,FR18=0),0,IF(FR18-FF18+1>30,30,FR18-FF18+1))","v":30},1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,null,{"$f":"IF(AND(K19=\"\",L19=\"\"),\"\",IF(L19>=65,1,IF(AND(L19>=33,OR(K19=\"P. Cerebral\",K19=\"Enf. Mental\",K19=\"D. Intelectual\",K19=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G19,1,2)&(MID(G19,FIND(\" \",G19,1)+1,2))&IFERROR((MID(G19,FIND(\",\",G19,1)+2,1)),MID(G19,FIND(\" \",G19,FIND(\" \",G19,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P19,Importes!L:Q,2,FALSE),\"\")","v":""},{"$f":"IF(G19=\"\",\"\",$M$4)","v":""},{"$f":"IF(G19=\"\",\"\",$M$2)","v":""},{"$f":"IF(G19=\"\",\"\",$Q$2)","v":""},{"$f":"IF(G19=\"\",\"\",IF($AH$8=\"Extra Inverno\",\"1/12/2016\",IF($AH$8=\"Extra Verán\",\"1/6/2017\",$AH$8)))","v":""},{"$f":"IF(G19=\"\",\"\",$AN$9)","v":""},{"$f":"IF(G19=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),6,1)),\"Extra Verán\",\"\"))))","v":""},{"$f":"$AH$9","v":0},{"$f":"IF(I19=\"\",\"\",DAY(I19)&\"/\"&MONTH(I19)&\"/\"&YEAR(I19))","v":""},{"$f":"IF(N19=\"\",\"\",DAY(N19)&\"/\"&MONTH(N19)&\"/\"&YEAR(N19))","v":""},{"$f":"IF(O19=\"\",\"\",DAY(O19)&\"/\"&MONTH(O19)&\"/\"&YEAR(O19))","v":""},{"$f":"MID(AF19,1,4)","v":"AM+E"},"Si",null,null,{"$f":"IF(AC19=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},0,{"$f":"IFERROR(IF(OR(AD19=\"+CT\",AF19=\"\"),0,ROUND(IF(MOD(AG19,30)=0,QUOTIENT(AG19,30)*VLOOKUP(C19&AF19,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE19>100,0,$AE19)/100),AG19*VLOOKUP(C19&AF19,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE19>100,0,$AE19)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ19=\"\",\"\",AE19),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ19=\"\",\"\",IF(AJ19<180,AJ19*VLOOKUP(C19&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($AI19>100,0,$AI19)/100),IF(AJ19=180,VLOOKUP(C19&\"CP\",Importes!$A$2:$F$14,6,FALSE)*6*(IF($AI19>100,0,$AI19)/100),0))),0)","v":""},"","",{"$f":"IF(AM19=\"\",\"\",IF(AM19>0,ROUND(IF(MOD(AM19,30)=0,QUOTIENT(AM19,30)*VLOOKUP(C19&IF(AC19=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL19>100,0,$AL19)/100),AM19*VLOOKUP(C19&IF(AC19=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL19>100,0,$AL19)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED19=\"NO\",\"\",ED19),\"\")","v":""},null,null,null,{"$f":"IF(AND(AR19<>\"\",O19>0),O19,\"\")","v":""},null,null,null,{"$f":"IF($AH19>0,\"X\",\"\")","v":""},"","","","","","","","","",null,{"$f":"IFERROR(IF(AF19=\"AM\",DF19,IF(AF19=\"AM+E\",DF19,IF(AF19=\"CP\",DO19,IF(AF19=\"CV\",DR19,IF(AF19=\"CV+E\",DR19))))),0)","v":0},{"$f":"IFERROR(IF(OR(AD19=\"+CT\",AF19=\"\"),0,ROUND(IF(MOD(AG19,30)=0,QUOTIENT(AG19,30)*VLOOKUP(C19&AF19,Importes!$A$2:$F$14,6,FALSE)*(IF($AE19>100,0,$AE19)/100),AG19*VLOOKUP(C19&AF19,Importes!$A$2:$F$14,5,FALSE)*(IF($AE19>100,0,$AE19)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK19=\"\",\"\",BG19),\"\")","v":""},{"$f":"IFERROR(ROUND(IF($AI$8=\"Anual\",0.5,1)*IF(AND(AF19=\"AM\",OR(EA19=\"ALINT\",EA19=\"AL\")),DO19,IF(AND(AF19=\"AM\",$AG$9=\"x\"),DO19,\"\")),0),\"\")","v":""},{"$f":"IF(AJ19=\"\",\"\",IF(AJ19>0,ROUND(IF(MOD(AJ19,30)=0,QUOTIENT(AJ19,30)*VLOOKUP(C19&\"CP\",Importes!$A$2:$F$14,6,FALSE)*(IF($BG19>100,0,$BG19)/100),BK19*VLOOKUP(C19&\"CP\",Importes!$A$2:$F$14,5,FALSE)*(IF($BG19>100,0,$BG19)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN19=\"\",\"\",BG19),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA19=\"ALINT\",EA19=\"AL\"),DR19,\"\"),\"\")","v":""},{"$f":"IF(AM19=\"\",\"\",IF(AM19>0,ROUND(IF(MOD(AM19,30)=0,QUOTIENT(AM19,30)*VLOOKUP(C19&IF(AC19=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,6,FALSE)*(IF($BG19>100,0,$BG19)/100),AM19*VLOOKUP(C19&IF(AC19=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$F$14,5,FALSE)*(IF($BG19>100,0,$BG19)/100)),2),0))","v":""},"",{"$f":"IF(VALUE($A19)=0,\"\",IF(BQ$11=\"\",\"\",IF(AND($O19<>\"\",$O19<BQ$6),\"\",IF($N19>BQ$6,\"\",IF(AND(OR($O19=\"\",$O19>=BQ$6),$AR19=\"\",$AF19<>\"\"),\"F\",IF(AND($AR19<=BQ$6,OR($AS19=$O19,$AS19>=BQ$6,IF($AS19=\"\",$AU$5))),\"h\",IF($DE19>=BQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(BP19:CU19,\"F\")=0,0,COUNTIF(BP19:CU19,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP19:CU19,\"h\")=0,0,COUNTIF(BP19:CU19,\"h\"))","v":0},{"$f":"IF(OR(AQ19=\"IT\",AQ19=\"AT\"),DI19+1-(DH19),0)","v":0},{"$f":"IF(AQ19=\"AT\",1,IF(IF(AQ19=\"IT\",DI19+1-(DH19),0)>15,15,IF(AQ19=\"IT\",DI19+1-(DH19),0)))","v":0},{"$f":"IF(AQ19=\"IT\",IF(CX19-CW19>15,15,CX19-CW19),IF(AQ19=\"AT\",IF(CX19-CW19>1,1,CX19-CW19),0))","v":0},{"$f":"IF(OR(AT19=\"SI\",$DA$8=\"SI\"),CY19-CZ19,IF(AND(AT19<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ19<=3,IF(CY19-CZ19-3<=0,IF(AQ19=\"AT\",IF(CZ19=1,0,1),0),CY19-CZ19-(3-CZ19)),CY19-CZ19),0))","v":0},{"$f":"IF(COLUMN()>0,5,5)","v":5},null,{"$f":"IF(N19<$AH$8,$AH$8,N19)","v":"2025-11-01"},{"$f":"IF(O19=\"\",$AU$5,O19)","v":"2025-11-30"},{"$f":"IF(CV19+DG19>30,30,IF(AND(MONTH($I$7)=2,CV19>=DAY($AU$5),OR(AR19=\"\",AR19<=$I$7)),30,IF(CV19+DA19>30,30,CV19+DA19)))","v":0},{"$f":"DP19","v":0},{"$f":"IF(AQ19=\"at\",IF(DJ19<$AR$7,DJ19,IF(DJ19<$AH$8,$AH$8-1,DJ19)),DK19)","v":"2025-01-01"},{"$f":"IF(OR(AS19=\"\",AS19>$AU$5),IF(O19=\"\",$AU$5,IF(O19>$AU$5,$AU$5,O19)),AS19)","v":"2025-11-30"},{"$f":"IF(AQ19=\"AT\",DK19,0)","v":"00:00:00"},{"$f":"IF(IF(AR19=\"\",0,AR19)+3=3,VALUE(1&\"-\"&1&\"-\"&$AU$7),AR19)","v":"2025-01-01"},{"$f":"CW19","v":0},{"$f":"IF(OR(AQ19=\"IT\",AQ19=\"AT\"),IF(DH19<DD19,DD19-(DH19),0),0)","v":0},{"$f":"IF(OR(AQ19=\"IT\",AQ19=\"AT\"),DI19+1-(DH19),0)","v":0},{"$f":"IF(OR(AQ19=\"IT\",AQ19=\"AT\"),IF(DM19>=15,12,IF(DM19<15,DM19,DM19-3)),0)","v":0},{"$f":"IF(AND(AQ19=\"AT\",DN19-DL19=0),1,IF(AQ19=\"IT\",DZ19,0))","v":0},{"$f":"IF(N19<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AU$5)<$AU$7,YEAR($AU$5),$AU$7)),N19)","v":"2025-01-01"},{"$f":"IF(O19=\"\",0,(DAYS360(DQ19,O19)+1)/30*2.5)","v":0},{"$f":"IFERROR(DS18+IF(EE19=$I$7,1,0),0)","v":0},{"$f":"IF(DS19=\"\",\"\",IF(MOD(DS19,10)=0,QUOTIENT(DS19,10),QUOTIENT(DS19,10)+1))","v":0},0,{"$f":"IF(DO19>=3,3,DO19)","v":0},{"$f":"IF(OR($DY$8=\"SI\",$AT19=\"SI\"),DV19,3-DV19)","v":3},{"$f":"IF(DM19>15,IF(OR($DY$8=\"SI\",$AT19=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT19=\"SI\"),DM19,DM19-DV19))","v":0},{"$f":"IF(DN19-DW19-DV19<0,0,IF(DN19-DW19-DV19>12,IF(OR($DY$8=\"SI\",$AT19=\"SI\"),15,12),IF(DN19-DW19-DV19>CW19,CW19-DW19,DN19-DW19-DV19)))","v":0},{"$f":"IF(DY19-DX19>=IF(OR($DY$8=\"SI\",$AT19=\"SI\"),15,12),IF(OR($DY$8=\"SI\",$AT19=\"SI\"),15,12),DY19-DX19)","v":0},{"$f":"EB19&EC19&IF(OR(P19=510,P19=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(N19)<YEAR($I$7),\"A\",IF(YEAR(N19)=YEAR($I$7),IF(MONTH(N19)<=MONTH($I$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(O19=\"\",\"A\",IF(YEAR(O19)>YEAR($I$7),\"A\",IF(YEAR(O19)=YEAR($I$7),IF(MONTH(O19)>MONTH($I$7),\"A\",IF(MONTH(O19)=MONTH($I$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L19<33,\"NO\",IF(OR(EA19=\"AA\",EA19=\"AL\"),\"SI\",IF(OR(EA19=\"AAINT\",EA19=\"ALINT\"),\"SI\",\"\"))),\"\")","v":"NO"},{"$f":"IFERROR(IF(ED19=\"SI\",$I$7,\"\"),0)","v":""},null,{"$f":"IFERROR(SUM(EH19:EL19),0)","v":30},{"$f":"IF(OR(EU19=0,FG19=0),0,IF(FG19-EU19+1>30,30,FG19-EU19+1))","v":30},0,0,0,0,{"$f":"IFERROR(SUM(EN19:ET19),0)","v":0},{"$f":"IF(OR(EZ19=0,FL19=0),0,IF(FL19-EZ19+1>30,30,FL19-EZ19+1))","v":0},{"$f":"IF(OR(FA19=0,FM19=0),0,IF(FM19-FA19+1>30,30,FM19-FA19+1))","v":0},{"$f":"IF(IF(OR(FB19=0,FN19=0),0,IF(FN19-FB19+1>30,30,FN19-FB19+1))>=28,30,IF(OR(FB19=0,FN19=0),0,IF(FN19-FB19+1>30,30,FN19-FB19+1)))","v":0},{"$f":"IF(OR(FC19=0,FO19=0),0,IF(FO19-FC19+1>30,30,FO19-FC19+1))","v":0},0,0,0,{"$f":"IFERROR(IF($N19<=EU$11,1,IF(YEAR($N19)=YEAR(EU$11),IF(MONTH($N19)=MONTH(EU$11),DAY($N19),0))),0)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR($O19=\"\",$O19=0),DAY(FG$11),IF($O19>=FG$11,DAY(FG$11),IF(MONTH($O19)=MONTH(FG$11),DAY($O19),0))),0)","v":31}]
[null,8,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P20,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G20=\"\",\"\",#REF!)","v":""},{"$f":"IF(G20=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G20=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","8",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD20=\"+CT\",AF20=\"\"),0,ROUND(IF(MOD(AG20,30)=0,QUOTIENT(AG20,30)*VLOOKUP(C20&AF20,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE20>100,0,$AE20)/100),AG20*VLOOKUP(C20&AF20,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE20>100,0,$AE20)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ20=\"\",\"\",IF(AJ20<180,AJ20*VLOOKUP(C20&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI20>100,0,$AI20)/100),IF(AJ20=180,VLOOKUP(C20&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI20>100,0,$AI20)/100),0))),0)","v":""},"","",{"$f":"IF(AM20=\"\",\"\",IF(AM20>0,ROUND(IF(MOD(AM20,30)=0,QUOTIENT(AM20,30)*VLOOKUP(C20&IF(AC20=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL20>100,0,$AL20)/100),AM20*VLOOKUP(C20&IF(AC20=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL20>100,0,$AL20)/100)),2),0))","v":""},"",null,null,null,"","Non",null,"","","","","","","","","","","",100,0,{"$f":"IFERROR(IF(OR(AD20=\"+CT\",AF20=\"\"),0,ROUND(IF(MOD(AG20,30)=0,QUOTIENT(AG20,30)*VLOOKUP(C20&AF20,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE20>100,0,$AE20)/100),AG20*VLOOKUP(C20&AF20,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE20>100,0,$AE20)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ20=\"\",\"\",IF(AJ20>0,ROUND(IF(MOD(AJ20,30)=0,QUOTIENT(AJ20,30)*VLOOKUP(C20&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG20>100,0,$BG20)/100),BK20*VLOOKUP(C20&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG20>100,0,$BG20)/100)),2),0))","v":""},"","",{"$f":"IF(AM20=\"\",\"\",IF(AM20>0,ROUND(IF(MOD(AM20,30)=0,QUOTIENT(AM20,30)*VLOOKUP(C20&IF(AC20=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG20>100,0,$BG20)/100),AM20*VLOOKUP(C20&IF(AC20=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG20>100,0,$BG20)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A20)=0,\"\",IF(CN$11=\"\",\"\",IF(AND($O20<>\"\",$O20<CN$6),\"\",IF($N20>CN$6,\"\",IF(AND(OR($O20=\"\",$O20>=CN$6),$AR20=\"\",$AF20<>\"\"),\"F\",IF(AND($AR20<=CN$6,OR($AS20=$O20,$AS20>=CN$6,IF($AS20=\"\",$AU$5))),\"h\",IF($DE20>=CN$6,\"F\",\"\")))))))","v":""},"","","","","","","",0,0,0,0,0,0,5,0,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE20=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,9,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P21,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G21=\"\",\"\",#REF!)","v":""},{"$f":"IF(G21=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G21=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","9",null,"AM+E",0,0,"","",{"$f":"IFERROR(IF(AJ21=\"\",\"\",IF(AJ21<180,AJ21*VLOOKUP(C21&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI21>100,0,$AI21)/100),IF(AJ21=180,VLOOKUP(C21&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI21>100,0,$AI21)/100),0))),0)","v":""},"","",{"$f":"IF(AM21=\"\",\"\",IF(AM21>0,ROUND(IF(MOD(AM21,30)=0,QUOTIENT(AM21,30)*VLOOKUP(C21&IF(AC21=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL21>100,0,$AL21)/100),AM21*VLOOKUP(C21&IF(AC21=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL21>100,0,$AL21)/100)),2),0))","v":""},"",null,null,null,"","Non",null,"","","","","","","","","","","",100,0,{"$f":"IFERROR(IF(OR(AD21=\"+CT\",AF21=\"\"),0,ROUND(IF(MOD(AG21,30)=0,QUOTIENT(AG21,30)*VLOOKUP(C21&AF21,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE21>100,0,$AE21)/100),AG21*VLOOKUP(C21&AF21,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE21>100,0,$AE21)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ21=\"\",\"\",IF(AJ21>0,ROUND(IF(MOD(AJ21,30)=0,QUOTIENT(AJ21,30)*VLOOKUP(C21&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG21>100,0,$BG21)/100),BK21*VLOOKUP(C21&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG21>100,0,$BG21)/100)),2),0))","v":""},"","",{"$f":"IF(AM21=\"\",\"\",IF(AM21>0,ROUND(IF(MOD(AM21,30)=0,QUOTIENT(AM21,30)*VLOOKUP(C21&IF(AC21=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG21>100,0,$BG21)/100),AM21*VLOOKUP(C21&IF(AC21=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG21>100,0,$BG21)/100)),2),0))","v":""},"","","","","","",{"$f":"IF(VALUE($A21)=0,\"\",IF(BV$11=\"\",\"\",IF(AND($O21<>\"\",$O21<BV$6),\"\",IF($N21>BV$6,\"\",IF(AND(OR($O21=\"\",$O21>=BV$6),$AR21=\"\",$AF21<>\"\"),\"F\",IF(AND($AR21<=BV$6,OR($AS21=$O21,$AS21>=BV$6,IF($AS21=\"\",$AU$5))),\"h\",IF($DE21>=BV$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A21)=0,\"\",IF(CF$11=\"\",\"\",IF(AND($O21<>\"\",$O21<CF$6),\"\",IF($N21>CF$6,\"\",IF(AND(OR($O21=\"\",$O21>=CF$6),$AR21=\"\",$AF21<>\"\"),\"F\",IF(AND($AR21<=CF$6,OR($AS21=$O21,$AS21>=CF$6,IF($AS21=\"\",$AU$5))),\"h\",IF($DE21>=CF$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(DS20+IF(EE21=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P22,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G22=\"\",\"\",#REF!)","v":""},{"$f":"IF(G22=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G22=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","11",null,{"$f":"IF(AC22=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},0,{"$f":"IFERROR(IF(OR(AD22=\"+CT\",AF22=\"\"),0,ROUND(IF(MOD(AG22,30)=0,QUOTIENT(AG22,30)*VLOOKUP(C22&AF22,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE22>100,0,$AE22)/100),AG22*VLOOKUP(C22&AF22,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE22>100,0,$AE22)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ22=\"\",\"\",IF(AJ22<180,AJ22*VLOOKUP(C22&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI22>100,0,$AI22)/100),IF(AJ22=180,VLOOKUP(C22&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI22>100,0,$AI22)/100),0))),0)","v":""},"","",{"$f":"IF(AM22=\"\",\"\",IF(AM22>0,ROUND(IF(MOD(AM22,30)=0,QUOTIENT(AM22,30)*VLOOKUP(C22&IF(AC22=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL22>100,0,$AL22)/100),AM22*VLOOKUP(C22&IF(AC22=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL22>100,0,$AL22)/100)),2),0))","v":""},"",null,null,null,"","Non",null,"",{"$f":"IF($AH22>0,\"X\",\"\")","v":""},"","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD22=\"+CT\",AF22=\"\"),0,ROUND(IF(MOD(AG22,30)=0,QUOTIENT(AG22,30)*VLOOKUP(C22&AF22,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE22>100,0,$AE22)/100),AG22*VLOOKUP(C22&AF22,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE22>100,0,$AE22)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ22=\"\",\"\",IF(AJ22>0,ROUND(IF(MOD(AJ22,30)=0,QUOTIENT(AJ22,30)*VLOOKUP(C22&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG22>100,0,$BG22)/100),BK22*VLOOKUP(C22&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG22>100,0,$BG22)/100)),2),0))","v":""},"","",{"$f":"IF(AM22=\"\",\"\",IF(AM22>0,ROUND(IF(MOD(AM22,30)=0,QUOTIENT(AM22,30)*VLOOKUP(C22&IF(AC22=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG22>100,0,$BG22)/100),AM22*VLOOKUP(C22&IF(AC22=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG22>100,0,$BG22)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE22=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P23,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G23=\"\",\"\",#REF!)","v":""},{"$f":"IF(G23=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G23=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","12",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD23=\"+CT\",AF23=\"\"),0,ROUND(IF(MOD(AG23,30)=0,QUOTIENT(AG23,30)*VLOOKUP(C23&AF23,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE23>100,0,$AE23)/100),AG23*VLOOKUP(C23&AF23,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE23>100,0,$AE23)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ23=\"\",\"\",IF(AJ23<180,AJ23*VLOOKUP(C23&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI23>100,0,$AI23)/100),IF(AJ23=180,VLOOKUP(C23&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI23>100,0,$AI23)/100),0))),0)","v":""},"","",{"$f":"IF(AM23=\"\",\"\",IF(AM23>0,ROUND(IF(MOD(AM23,30)=0,QUOTIENT(AM23,30)*VLOOKUP(C23&IF(AC23=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL23>100,0,$AL23)/100),AM23*VLOOKUP(C23&IF(AC23=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL23>100,0,$AL23)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD23=\"+CT\",AF23=\"\"),0,ROUND(IF(MOD(AG23,30)=0,QUOTIENT(AG23,30)*VLOOKUP(C23&AF23,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE23>100,0,$AE23)/100),AG23*VLOOKUP(C23&AF23,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE23>100,0,$AE23)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ23=\"\",\"\",IF(AJ23>0,ROUND(IF(MOD(AJ23,30)=0,QUOTIENT(AJ23,30)*VLOOKUP(C23&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG23>100,0,$BG23)/100),BK23*VLOOKUP(C23&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG23>100,0,$BG23)/100)),2),0))","v":""},"","",{"$f":"IF(AM23=\"\",\"\",IF(AM23>0,ROUND(IF(MOD(AM23,30)=0,QUOTIENT(AM23,30)*VLOOKUP(C23&IF(AC23=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG23>100,0,$BG23)/100),AM23*VLOOKUP(C23&IF(AC23=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG23>100,0,$BG23)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE23=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,{"$f":"IFERROR(IF($N23<=EU$11,1,IF(YEAR($N23)=YEAR(EU$11),IF(MONTH($N23)=MONTH(EU$11),DAY($N23),0))),0)","v":1},1,1,1,1,1,1,1,1,1,1,1,{"$f":"IFERROR(IF(OR($O23=\"\",$O23=0),DAY(FG$11),IF($O23>=FG$11,DAY(FG$11),IF(MONTH($O23)=MONTH(FG$11),DAY($O23),0))),0)","v":31},30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P24,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G24=\"\",\"\",#REF!)","v":""},{"$f":"IF(G24=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G24=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","15",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD24=\"+CT\",AF24=\"\"),0,ROUND(IF(MOD(AG24,30)=0,QUOTIENT(AG24,30)*VLOOKUP(C24&AF24,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE24>100,0,$AE24)/100),AG24*VLOOKUP(C24&AF24,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE24>100,0,$AE24)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ24=\"\",\"\",IF(AJ24<180,AJ24*VLOOKUP(C24&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI24>100,0,$AI24)/100),IF(AJ24=180,VLOOKUP(C24&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI24>100,0,$AI24)/100),0))),0)","v":""},"","",{"$f":"IF(AM24=\"\",\"\",IF(AM24>0,ROUND(IF(MOD(AM24,30)=0,QUOTIENT(AM24,30)*VLOOKUP(C24&IF(AC24=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL24>100,0,$AL24)/100),AM24*VLOOKUP(C24&IF(AC24=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL24>100,0,$AL24)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD24=\"+CT\",AF24=\"\"),0,ROUND(IF(MOD(AG24,30)=0,QUOTIENT(AG24,30)*VLOOKUP(C24&AF24,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE24>100,0,$AE24)/100),AG24*VLOOKUP(C24&AF24,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE24>100,0,$AE24)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ24=\"\",\"\",IF(AJ24>0,ROUND(IF(MOD(AJ24,30)=0,QUOTIENT(AJ24,30)*VLOOKUP(C24&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG24>100,0,$BG24)/100),BK24*VLOOKUP(C24&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG24>100,0,$BG24)/100)),2),0))","v":""},"","",{"$f":"IF(AM24=\"\",\"\",IF(AM24>0,ROUND(IF(MOD(AM24,30)=0,QUOTIENT(AM24,30)*VLOOKUP(C24&IF(AC24=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG24>100,0,$BG24)/100),AM24*VLOOKUP(C24&IF(AC24=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG24>100,0,$BG24)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A24)=0,\"\",IF(CU$11=\"\",\"\",IF(AND($O24<>\"\",$O24<CU$6),\"\",IF($N24>CU$6,\"\",IF(AND(OR($O24=\"\",$O24>=CU$6),$AR24=\"\",$AF24<>\"\"),\"F\",IF(AND($AR24<=CU$6,OR($AS24=$O24,$AS24>=CU$6,IF($AS24=\"\",$AU$5))),\"h\",IF($DE24>=CU$6,\"F\",\"\")))))))","v":""},0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE24=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P25,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G25=\"\",\"\",#REF!)","v":""},{"$f":"IF(G25=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G25=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","17",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD25=\"+CT\",AF25=\"\"),0,ROUND(IF(MOD(AG25,30)=0,QUOTIENT(AG25,30)*VLOOKUP(C25&AF25,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE25>100,0,$AE25)/100),AG25*VLOOKUP(C25&AF25,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE25>100,0,$AE25)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ25=\"\",\"\",IF(AJ25<180,AJ25*VLOOKUP(C25&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI25>100,0,$AI25)/100),IF(AJ25=180,VLOOKUP(C25&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI25>100,0,$AI25)/100),0))),0)","v":""},"","",{"$f":"IF(AM25=\"\",\"\",IF(AM25>0,ROUND(IF(MOD(AM25,30)=0,QUOTIENT(AM25,30)*VLOOKUP(C25&IF(AC25=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL25>100,0,$AL25)/100),AM25*VLOOKUP(C25&IF(AC25=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL25>100,0,$AL25)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD25=\"+CT\",AF25=\"\"),0,ROUND(IF(MOD(AG25,30)=0,QUOTIENT(AG25,30)*VLOOKUP(C25&AF25,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE25>100,0,$AE25)/100),AG25*VLOOKUP(C25&AF25,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE25>100,0,$AE25)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ25=\"\",\"\",IF(AJ25>0,ROUND(IF(MOD(AJ25,30)=0,QUOTIENT(AJ25,30)*VLOOKUP(C25&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG25>100,0,$BG25)/100),BK25*VLOOKUP(C25&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG25>100,0,$BG25)/100)),2),0))","v":""},"","",{"$f":"IF(AM25=\"\",\"\",IF(AM25>0,ROUND(IF(MOD(AM25,30)=0,QUOTIENT(AM25,30)*VLOOKUP(C25&IF(AC25=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG25>100,0,$BG25)/100),AM25*VLOOKUP(C25&IF(AC25=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG25>100,0,$BG25)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE25=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P26,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G26=\"\",\"\",#REF!)","v":""},{"$f":"IF(G26=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G26=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","18",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD26=\"+CT\",AF26=\"\"),0,ROUND(IF(MOD(AG26,30)=0,QUOTIENT(AG26,30)*VLOOKUP(C26&AF26,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE26>100,0,$AE26)/100),AG26*VLOOKUP(C26&AF26,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE26>100,0,$AE26)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ26=\"\",\"\",IF(AJ26<180,AJ26*VLOOKUP(C26&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI26>100,0,$AI26)/100),IF(AJ26=180,VLOOKUP(C26&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI26>100,0,$AI26)/100),0))),0)","v":""},"","",{"$f":"IF(AM26=\"\",\"\",IF(AM26>0,ROUND(IF(MOD(AM26,30)=0,QUOTIENT(AM26,30)*VLOOKUP(C26&IF(AC26=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL26>100,0,$AL26)/100),AM26*VLOOKUP(C26&IF(AC26=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL26>100,0,$AL26)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD26=\"+CT\",AF26=\"\"),0,ROUND(IF(MOD(AG26,30)=0,QUOTIENT(AG26,30)*VLOOKUP(C26&AF26,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE26>100,0,$AE26)/100),AG26*VLOOKUP(C26&AF26,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE26>100,0,$AE26)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ26=\"\",\"\",IF(AJ26>0,ROUND(IF(MOD(AJ26,30)=0,QUOTIENT(AJ26,30)*VLOOKUP(C26&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG26>100,0,$BG26)/100),BK26*VLOOKUP(C26&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG26>100,0,$BG26)/100)),2),0))","v":""},"","",{"$f":"IF(AM26=\"\",\"\",IF(AM26>0,ROUND(IF(MOD(AM26,30)=0,QUOTIENT(AM26,30)*VLOOKUP(C26&IF(AC26=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG26>100,0,$BG26)/100),AM26*VLOOKUP(C26&IF(AC26=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG26>100,0,$BG26)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE26=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P27,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G27=\"\",\"\",#REF!)","v":""},{"$f":"IF(G27=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G27=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","19",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD27=\"+CT\",AF27=\"\"),0,ROUND(IF(MOD(AG27,30)=0,QUOTIENT(AG27,30)*VLOOKUP(C27&AF27,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE27>100,0,$AE27)/100),AG27*VLOOKUP(C27&AF27,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE27>100,0,$AE27)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ27=\"\",\"\",IF(AJ27<180,AJ27*VLOOKUP(C27&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI27>100,0,$AI27)/100),IF(AJ27=180,VLOOKUP(C27&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI27>100,0,$AI27)/100),0))),0)","v":""},{"$f":"IFERROR(IF(AM27=\"\",\"\",AE27),\"\")","v":""},"",{"$f":"IF(AM27=\"\",\"\",IF(AM27>0,ROUND(IF(MOD(AM27,30)=0,QUOTIENT(AM27,30)*VLOOKUP(C27&IF(AC27=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL27>100,0,$AL27)/100),AM27*VLOOKUP(C27&IF(AC27=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL27>100,0,$AL27)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD27=\"+CT\",AF27=\"\"),0,ROUND(IF(MOD(AG27,30)=0,QUOTIENT(AG27,30)*VLOOKUP(C27&AF27,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE27>100,0,$AE27)/100),AG27*VLOOKUP(C27&AF27,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE27>100,0,$AE27)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ27=\"\",\"\",IF(AJ27>0,ROUND(IF(MOD(AJ27,30)=0,QUOTIENT(AJ27,30)*VLOOKUP(C27&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG27>100,0,$BG27)/100),BK27*VLOOKUP(C27&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG27>100,0,$BG27)/100)),2),0))","v":""},"","",{"$f":"IF(AM27=\"\",\"\",IF(AM27>0,ROUND(IF(MOD(AM27,30)=0,QUOTIENT(AM27,30)*VLOOKUP(C27&IF(AC27=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG27>100,0,$BG27)/100),AM27*VLOOKUP(C27&IF(AC27=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG27>100,0,$BG27)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(DS26+IF(EE27=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P28,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G28=\"\",\"\",#REF!)","v":""},{"$f":"IF(G28=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G28=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","20",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD28=\"+CT\",AF28=\"\"),0,ROUND(IF(MOD(AG28,30)=0,QUOTIENT(AG28,30)*VLOOKUP(C28&AF28,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE28>100,0,$AE28)/100),AG28*VLOOKUP(C28&AF28,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE28>100,0,$AE28)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ28=\"\",\"\",IF(AJ28<180,AJ28*VLOOKUP(C28&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI28>100,0,$AI28)/100),IF(AJ28=180,VLOOKUP(C28&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI28>100,0,$AI28)/100),0))),0)","v":""},"","",{"$f":"IF(AM28=\"\",\"\",IF(AM28>0,ROUND(IF(MOD(AM28,30)=0,QUOTIENT(AM28,30)*VLOOKUP(C28&IF(AC28=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL28>100,0,$AL28)/100),AM28*VLOOKUP(C28&IF(AC28=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL28>100,0,$AL28)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD28=\"+CT\",AF28=\"\"),0,ROUND(IF(MOD(AG28,30)=0,QUOTIENT(AG28,30)*VLOOKUP(C28&AF28,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE28>100,0,$AE28)/100),AG28*VLOOKUP(C28&AF28,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE28>100,0,$AE28)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ28=\"\",\"\",IF(AJ28>0,ROUND(IF(MOD(AJ28,30)=0,QUOTIENT(AJ28,30)*VLOOKUP(C28&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG28>100,0,$BG28)/100),BK28*VLOOKUP(C28&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG28>100,0,$BG28)/100)),2),0))","v":""},"","",{"$f":"IF(AM28=\"\",\"\",IF(AM28>0,ROUND(IF(MOD(AM28,30)=0,QUOTIENT(AM28,30)*VLOOKUP(C28&IF(AC28=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG28>100,0,$BG28)/100),AM28*VLOOKUP(C28&IF(AC28=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG28>100,0,$BG28)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P29,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G29=\"\",\"\",#REF!)","v":""},{"$f":"IF(G29=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G29=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","21",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD29=\"+CT\",AF29=\"\"),0,ROUND(IF(MOD(AG29,30)=0,QUOTIENT(AG29,30)*VLOOKUP(C29&AF29,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE29>100,0,$AE29)/100),AG29*VLOOKUP(C29&AF29,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE29>100,0,$AE29)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ29=\"\",\"\",IF(AJ29<180,AJ29*VLOOKUP(C29&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI29>100,0,$AI29)/100),IF(AJ29=180,VLOOKUP(C29&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI29>100,0,$AI29)/100),0))),0)","v":""},"","",{"$f":"IF(AM29=\"\",\"\",IF(AM29>0,ROUND(IF(MOD(AM29,30)=0,QUOTIENT(AM29,30)*VLOOKUP(C29&IF(AC29=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL29>100,0,$AL29)/100),AM29*VLOOKUP(C29&IF(AC29=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL29>100,0,$AL29)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD29=\"+CT\",AF29=\"\"),0,ROUND(IF(MOD(AG29,30)=0,QUOTIENT(AG29,30)*VLOOKUP(C29&AF29,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE29>100,0,$AE29)/100),AG29*VLOOKUP(C29&AF29,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE29>100,0,$AE29)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ29=\"\",\"\",IF(AJ29>0,ROUND(IF(MOD(AJ29,30)=0,QUOTIENT(AJ29,30)*VLOOKUP(C29&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG29>100,0,$BG29)/100),BK29*VLOOKUP(C29&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG29>100,0,$BG29)/100)),2),0))","v":""},"","",{"$f":"IF(AM29=\"\",\"\",IF(AM29>0,ROUND(IF(MOD(AM29,30)=0,QUOTIENT(AM29,30)*VLOOKUP(C29&IF(AC29=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG29>100,0,$BG29)/100),AM29*VLOOKUP(C29&IF(AC29=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG29>100,0,$BG29)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P30,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G30=\"\",\"\",#REF!)","v":""},{"$f":"IF(G30=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G30=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","28",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD30=\"+CT\",AF30=\"\"),0,ROUND(IF(MOD(AG30,30)=0,QUOTIENT(AG30,30)*VLOOKUP(C30&AF30,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE30>100,0,$AE30)/100),AG30*VLOOKUP(C30&AF30,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE30>100,0,$AE30)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ30=\"\",\"\",IF(AJ30<180,AJ30*VLOOKUP(C30&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI30>100,0,$AI30)/100),IF(AJ30=180,VLOOKUP(C30&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI30>100,0,$AI30)/100),0))),0)","v":""},"",{"$f":"IFERROR(IF($M$8=\"Si\",BN30,\"\"),\"\")","v":""},{"$f":"IF(AM30=\"\",\"\",IF(AM30>0,ROUND(IF(MOD(AM30,30)=0,QUOTIENT(AM30,30)*VLOOKUP(C30&IF(AC30=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL30>100,0,$AL30)/100),AM30*VLOOKUP(C30&IF(AC30=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL30>100,0,$AL30)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD30=\"+CT\",AF30=\"\"),0,ROUND(IF(MOD(AG30,30)=0,QUOTIENT(AG30,30)*VLOOKUP(C30&AF30,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE30>100,0,$AE30)/100),AG30*VLOOKUP(C30&AF30,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE30>100,0,$AE30)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ30=\"\",\"\",IF(AJ30>0,ROUND(IF(MOD(AJ30,30)=0,QUOTIENT(AJ30,30)*VLOOKUP(C30&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG30>100,0,$BG30)/100),BK30*VLOOKUP(C30&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG30>100,0,$BG30)/100)),2),0))","v":""},"","",{"$f":"IF(AM30=\"\",\"\",IF(AM30>0,ROUND(IF(MOD(AM30,30)=0,QUOTIENT(AM30,30)*VLOOKUP(C30&IF(AC30=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG30>100,0,$BG30)/100),AM30*VLOOKUP(C30&IF(AC30=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG30>100,0,$BG30)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE30=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,{"$f":"IFERROR(IF($N30<=EU$11,1,IF(YEAR($N30)=YEAR(EU$11),IF(MONTH($N30)=MONTH(EU$11),DAY($N30),0))),0)","v":1},1,1,1,1,1,1,1,1,1,1,1,{"$f":"IFERROR(IF(OR($O30=\"\",$O30=0),DAY(FG$11),IF($O30>=FG$11,DAY(FG$11),IF(MONTH($O30)=MONTH(FG$11),DAY($O30),0))),0)","v":31},30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P31,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G31=\"\",\"\",#REF!)","v":""},{"$f":"IF(G31=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G31=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","29",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD31=\"+CT\",AF31=\"\"),0,ROUND(IF(MOD(AG31,30)=0,QUOTIENT(AG31,30)*VLOOKUP(C31&AF31,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE31>100,0,$AE31)/100),AG31*VLOOKUP(C31&AF31,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE31>100,0,$AE31)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ31=\"\",\"\",IF(AJ31<180,AJ31*VLOOKUP(C31&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI31>100,0,$AI31)/100),IF(AJ31=180,VLOOKUP(C31&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI31>100,0,$AI31)/100),0))),0)","v":""},"","",{"$f":"IF(AM31=\"\",\"\",IF(AM31>0,ROUND(IF(MOD(AM31,30)=0,QUOTIENT(AM31,30)*VLOOKUP(C31&IF(AC31=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL31>100,0,$AL31)/100),AM31*VLOOKUP(C31&IF(AC31=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL31>100,0,$AL31)/100)),2),0))","v":""},"",null,null,"","","Non",null,"",{"$f":"IF($AH31>0,\"X\",\"\")","v":""},"","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD31=\"+CT\",AF31=\"\"),0,ROUND(IF(MOD(AG31,30)=0,QUOTIENT(AG31,30)*VLOOKUP(C31&AF31,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE31>100,0,$AE31)/100),AG31*VLOOKUP(C31&AF31,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE31>100,0,$AE31)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ31=\"\",\"\",IF(AJ31>0,ROUND(IF(MOD(AJ31,30)=0,QUOTIENT(AJ31,30)*VLOOKUP(C31&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG31>100,0,$BG31)/100),BK31*VLOOKUP(C31&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG31>100,0,$BG31)/100)),2),0))","v":""},"","",{"$f":"IF(AM31=\"\",\"\",IF(AM31>0,ROUND(IF(MOD(AM31,30)=0,QUOTIENT(AM31,30)*VLOOKUP(C31&IF(AC31=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG31>100,0,$BG31)/100),AM31*VLOOKUP(C31&IF(AC31=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG31>100,0,$BG31)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE31=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P32,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G32=\"\",\"\",#REF!)","v":""},{"$f":"IF(G32=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G32=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","30",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD32=\"+CT\",AF32=\"\"),0,ROUND(IF(MOD(AG32,30)=0,QUOTIENT(AG32,30)*VLOOKUP(C32&AF32,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE32>100,0,$AE32)/100),AG32*VLOOKUP(C32&AF32,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE32>100,0,$AE32)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ32=\"\",\"\",IF(AJ32<180,AJ32*VLOOKUP(C32&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI32>100,0,$AI32)/100),IF(AJ32=180,VLOOKUP(C32&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI32>100,0,$AI32)/100),0))),0)","v":""},"","",{"$f":"IF(AM32=\"\",\"\",IF(AM32>0,ROUND(IF(MOD(AM32,30)=0,QUOTIENT(AM32,30)*VLOOKUP(C32&IF(AC32=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL32>100,0,$AL32)/100),AM32*VLOOKUP(C32&IF(AC32=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL32>100,0,$AL32)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD32=\"+CT\",AF32=\"\"),0,ROUND(IF(MOD(AG32,30)=0,QUOTIENT(AG32,30)*VLOOKUP(C32&AF32,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE32>100,0,$AE32)/100),AG32*VLOOKUP(C32&AF32,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE32>100,0,$AE32)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ32=\"\",\"\",IF(AJ32>0,ROUND(IF(MOD(AJ32,30)=0,QUOTIENT(AJ32,30)*VLOOKUP(C32&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG32>100,0,$BG32)/100),BK32*VLOOKUP(C32&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG32>100,0,$BG32)/100)),2),0))","v":""},"","",{"$f":"IF(AM32=\"\",\"\",IF(AM32>0,ROUND(IF(MOD(AM32,30)=0,QUOTIENT(AM32,30)*VLOOKUP(C32&IF(AC32=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG32>100,0,$BG32)/100),AM32*VLOOKUP(C32&IF(AC32=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG32>100,0,$BG32)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A32)=0,\"\",IF(CU$11=\"\",\"\",IF(AND($O32<>\"\",$O32<CU$6),\"\",IF($N32>CU$6,\"\",IF(AND(OR($O32=\"\",$O32>=CU$6),$AR32=\"\",$AF32<>\"\"),\"F\",IF(AND($AR32<=CU$6,OR($AS32=$O32,$AS32>=CU$6,IF($AS32=\"\",$AU$5))),\"h\",IF($DE32>=CU$6,\"F\",\"\")))))))","v":""},0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P33,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G33=\"\",\"\",#REF!)","v":""},{"$f":"IF(G33=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G33=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","33",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD33=\"+CT\",AF33=\"\"),0,ROUND(IF(MOD(AG33,30)=0,QUOTIENT(AG33,30)*VLOOKUP(C33&AF33,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE33>100,0,$AE33)/100),AG33*VLOOKUP(C33&AF33,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE33>100,0,$AE33)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ33=\"\",\"\",IF(AJ33<180,AJ33*VLOOKUP(C33&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI33>100,0,$AI33)/100),IF(AJ33=180,VLOOKUP(C33&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI33>100,0,$AI33)/100),0))),0)","v":""},"","",{"$f":"IF(AM33=\"\",\"\",IF(AM33>0,ROUND(IF(MOD(AM33,30)=0,QUOTIENT(AM33,30)*VLOOKUP(C33&IF(AC33=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL33>100,0,$AL33)/100),AM33*VLOOKUP(C33&IF(AC33=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL33>100,0,$AL33)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD33=\"+CT\",AF33=\"\"),0,ROUND(IF(MOD(AG33,30)=0,QUOTIENT(AG33,30)*VLOOKUP(C33&AF33,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE33>100,0,$AE33)/100),AG33*VLOOKUP(C33&AF33,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE33>100,0,$AE33)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ33=\"\",\"\",IF(AJ33>0,ROUND(IF(MOD(AJ33,30)=0,QUOTIENT(AJ33,30)*VLOOKUP(C33&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG33>100,0,$BG33)/100),BK33*VLOOKUP(C33&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG33>100,0,$BG33)/100)),2),0))","v":""},"","",{"$f":"IF(AM33=\"\",\"\",IF(AM33>0,ROUND(IF(MOD(AM33,30)=0,QUOTIENT(AM33,30)*VLOOKUP(C33&IF(AC33=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG33>100,0,$BG33)/100),AM33*VLOOKUP(C33&IF(AC33=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG33>100,0,$BG33)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A33)=0,\"\",IF(CS$11=\"\",\"\",IF(AND($O33<>\"\",$O33<CS$6),\"\",IF($N33>CS$6,\"\",IF(AND(OR($O33=\"\",$O33>=CS$6),$AR33=\"\",$AF33<>\"\"),\"F\",IF(AND($AR33<=CS$6,OR($AS33=$O33,$AS33>=CS$6,IF($AS33=\"\",$AU$5))),\"h\",IF($DE33>=CS$6,\"F\",\"\")))))))","v":""},"","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE33=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P34,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G34=\"\",\"\",#REF!)","v":""},{"$f":"IF(G34=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G34=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","35",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD34=\"+CT\",AF34=\"\"),0,ROUND(IF(MOD(AG34,30)=0,QUOTIENT(AG34,30)*VLOOKUP(C34&AF34,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE34>100,0,$AE34)/100),AG34*VLOOKUP(C34&AF34,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE34>100,0,$AE34)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ34=\"\",\"\",IF(AJ34<180,AJ34*VLOOKUP(C34&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI34>100,0,$AI34)/100),IF(AJ34=180,VLOOKUP(C34&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI34>100,0,$AI34)/100),0))),0)","v":""},"","",{"$f":"IF(AM34=\"\",\"\",IF(AM34>0,ROUND(IF(MOD(AM34,30)=0,QUOTIENT(AM34,30)*VLOOKUP(C34&IF(AC34=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL34>100,0,$AL34)/100),AM34*VLOOKUP(C34&IF(AC34=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL34>100,0,$AL34)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD34=\"+CT\",AF34=\"\"),0,ROUND(IF(MOD(AG34,30)=0,QUOTIENT(AG34,30)*VLOOKUP(C34&AF34,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE34>100,0,$AE34)/100),AG34*VLOOKUP(C34&AF34,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE34>100,0,$AE34)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ34=\"\",\"\",IF(AJ34>0,ROUND(IF(MOD(AJ34,30)=0,QUOTIENT(AJ34,30)*VLOOKUP(C34&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG34>100,0,$BG34)/100),BK34*VLOOKUP(C34&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG34>100,0,$BG34)/100)),2),0))","v":""},"","",{"$f":"IF(AM34=\"\",\"\",IF(AM34>0,ROUND(IF(MOD(AM34,30)=0,QUOTIENT(AM34,30)*VLOOKUP(C34&IF(AC34=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG34>100,0,$BG34)/100),AM34*VLOOKUP(C34&IF(AC34=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG34>100,0,$BG34)/100)),2),0))","v":""},"",{"$f":"IF(VALUE($A34)=0,\"\",IF(BQ$11=\"\",\"\",IF(AND($O34<>\"\",$O34<BQ$6),\"\",IF($N34>BQ$6,\"\",IF(AND(OR($O34=\"\",$O34>=BQ$6),$AR34=\"\",$AF34<>\"\"),\"F\",IF(AND($AR34<=BQ$6,OR($AS34=$O34,$AS34>=BQ$6,IF($AS34=\"\",$AU$5))),\"h\",IF($DE34>=BQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A34)=0,\"\",IF(CG$11=\"\",\"\",IF(AND($O34<>\"\",$O34<CG$6),\"\",IF($N34>CG$6,\"\",IF(AND(OR($O34=\"\",$O34>=CG$6),$AR34=\"\",$AF34<>\"\"),\"F\",IF(AND($AR34<=CG$6,OR($AS34=$O34,$AS34>=CG$6,IF($AS34=\"\",$AU$5))),\"h\",IF($DE34>=CG$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,{"$f":"IFERROR(#REF!+IF(EE34=$I$7,1,0),0)","v":0},0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P35,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G35=\"\",\"\",#REF!)","v":""},{"$f":"IF(G35=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G35=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","36",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD35=\"+CT\",AF35=\"\"),0,ROUND(IF(MOD(AG35,30)=0,QUOTIENT(AG35,30)*VLOOKUP(C35&AF35,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE35>100,0,$AE35)/100),AG35*VLOOKUP(C35&AF35,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE35>100,0,$AE35)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ35=\"\",\"\",IF(AJ35<180,AJ35*VLOOKUP(C35&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI35>100,0,$AI35)/100),IF(AJ35=180,VLOOKUP(C35&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI35>100,0,$AI35)/100),0))),0)","v":""},"","",{"$f":"IF(AM35=\"\",\"\",IF(AM35>0,ROUND(IF(MOD(AM35,30)=0,QUOTIENT(AM35,30)*VLOOKUP(C35&IF(AC35=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL35>100,0,$AL35)/100),AM35*VLOOKUP(C35&IF(AC35=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL35>100,0,$AL35)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD35=\"+CT\",AF35=\"\"),0,ROUND(IF(MOD(AG35,30)=0,QUOTIENT(AG35,30)*VLOOKUP(C35&AF35,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE35>100,0,$AE35)/100),AG35*VLOOKUP(C35&AF35,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE35>100,0,$AE35)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ35=\"\",\"\",IF(AJ35>0,ROUND(IF(MOD(AJ35,30)=0,QUOTIENT(AJ35,30)*VLOOKUP(C35&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG35>100,0,$BG35)/100),BK35*VLOOKUP(C35&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG35>100,0,$BG35)/100)),2),0))","v":""},"","",{"$f":"IF(AM35=\"\",\"\",IF(AM35>0,ROUND(IF(MOD(AM35,30)=0,QUOTIENT(AM35,30)*VLOOKUP(C35&IF(AC35=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG35>100,0,$BG35)/100),AM35*VLOOKUP(C35&IF(AC35=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG35>100,0,$BG35)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P36,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G36=\"\",\"\",#REF!)","v":""},{"$f":"IF(G36=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G36=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","37",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD36=\"+CT\",AF36=\"\"),0,ROUND(IF(MOD(AG36,30)=0,QUOTIENT(AG36,30)*VLOOKUP(C36&AF36,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE36>100,0,$AE36)/100),AG36*VLOOKUP(C36&AF36,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE36>100,0,$AE36)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ36=\"\",\"\",IF(AJ36<180,AJ36*VLOOKUP(C36&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI36>100,0,$AI36)/100),IF(AJ36=180,VLOOKUP(C36&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI36>100,0,$AI36)/100),0))),0)","v":""},"","",{"$f":"IF(AM36=\"\",\"\",IF(AM36>0,ROUND(IF(MOD(AM36,30)=0,QUOTIENT(AM36,30)*VLOOKUP(C36&IF(AC36=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL36>100,0,$AL36)/100),AM36*VLOOKUP(C36&IF(AC36=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL36>100,0,$AL36)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD36=\"+CT\",AF36=\"\"),0,ROUND(IF(MOD(AG36,30)=0,QUOTIENT(AG36,30)*VLOOKUP(C36&AF36,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE36>100,0,$AE36)/100),AG36*VLOOKUP(C36&AF36,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE36>100,0,$AE36)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ36=\"\",\"\",IF(AJ36>0,ROUND(IF(MOD(AJ36,30)=0,QUOTIENT(AJ36,30)*VLOOKUP(C36&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG36>100,0,$BG36)/100),BK36*VLOOKUP(C36&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG36>100,0,$BG36)/100)),2),0))","v":""},"","",{"$f":"IF(AM36=\"\",\"\",IF(AM36>0,ROUND(IF(MOD(AM36,30)=0,QUOTIENT(AM36,30)*VLOOKUP(C36&IF(AC36=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG36>100,0,$BG36)/100),AM36*VLOOKUP(C36&IF(AC36=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG36>100,0,$BG36)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P37,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G37=\"\",\"\",#REF!)","v":""},{"$f":"IF(G37=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G37=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","38",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD37=\"+CT\",AF37=\"\"),0,ROUND(IF(MOD(AG37,30)=0,QUOTIENT(AG37,30)*VLOOKUP(C37&AF37,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE37>100,0,$AE37)/100),AG37*VLOOKUP(C37&AF37,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE37>100,0,$AE37)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ37=\"\",\"\",IF(AJ37<180,AJ37*VLOOKUP(C37&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI37>100,0,$AI37)/100),IF(AJ37=180,VLOOKUP(C37&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI37>100,0,$AI37)/100),0))),0)","v":""},"","",{"$f":"IF(AM37=\"\",\"\",IF(AM37>0,ROUND(IF(MOD(AM37,30)=0,QUOTIENT(AM37,30)*VLOOKUP(C37&IF(AC37=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL37>100,0,$AL37)/100),AM37*VLOOKUP(C37&IF(AC37=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL37>100,0,$AL37)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD37=\"+CT\",AF37=\"\"),0,ROUND(IF(MOD(AG37,30)=0,QUOTIENT(AG37,30)*VLOOKUP(C37&AF37,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE37>100,0,$AE37)/100),AG37*VLOOKUP(C37&AF37,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE37>100,0,$AE37)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ37=\"\",\"\",IF(AJ37>0,ROUND(IF(MOD(AJ37,30)=0,QUOTIENT(AJ37,30)*VLOOKUP(C37&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG37>100,0,$BG37)/100),BK37*VLOOKUP(C37&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG37>100,0,$BG37)/100)),2),0))","v":""},"","",{"$f":"IF(AM37=\"\",\"\",IF(AM37>0,ROUND(IF(MOD(AM37,30)=0,QUOTIENT(AM37,30)*VLOOKUP(C37&IF(AC37=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG37>100,0,$BG37)/100),AM37*VLOOKUP(C37&IF(AC37=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG37>100,0,$BG37)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P38,Importes!L:Q,2,FALSE),\"\")","v":""},"",{"$f":"IF(G38=\"\",\"\",#REF!)","v":""},{"$f":"IF(G38=\"\",\"\",#REF!)","v":""},"","",{"$f":"IF(G38=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CU$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",#REF!=\"x\",$AH$8=DATE(YEAR($CV$8),6,1)),\"Extra Verán\",\"\"))))","v":""},0,"","","","AM+E","Si","39",null,"AM+E",0,{"$f":"IFERROR(IF(OR(AD38=\"+CT\",AF38=\"\"),0,ROUND(IF(MOD(AG38,30)=0,QUOTIENT(AG38,30)*VLOOKUP(C38&AF38,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE38>100,0,$AE38)/100),AG38*VLOOKUP(C38&AF38,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE38>100,0,$AE38)/100)),2)),0)","v":0},"","",{"$f":"IFERROR(IF(AJ38=\"\",\"\",IF(AJ38<180,AJ38*VLOOKUP(C38&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI38>100,0,$AI38)/100),IF(AJ38=180,VLOOKUP(C38&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI38>100,0,$AI38)/100),0))),0)","v":""},"","",{"$f":"IF(AM38=\"\",\"\",IF(AM38>0,ROUND(IF(MOD(AM38,30)=0,QUOTIENT(AM38,30)*VLOOKUP(C38&IF(AC38=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL38>100,0,$AL38)/100),AM38*VLOOKUP(C38&IF(AC38=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL38>100,0,$AL38)/100)),2),0))","v":""},"",null,null,"","","Non",null,"","","","","","","","","","","","",0,{"$f":"IFERROR(IF(OR(AD38=\"+CT\",AF38=\"\"),0,ROUND(IF(MOD(AG38,30)=0,QUOTIENT(AG38,30)*VLOOKUP(C38&AF38,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE38>100,0,$AE38)/100),AG38*VLOOKUP(C38&AF38,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE38>100,0,$AE38)/100)),2)),0)","v":0},"","",{"$f":"IF(AJ38=\"\",\"\",IF(AJ38>0,ROUND(IF(MOD(AJ38,30)=0,QUOTIENT(AJ38,30)*VLOOKUP(C38&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG38>100,0,$BG38)/100),BK38*VLOOKUP(C38&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG38>100,0,$BG38)/100)),2),0))","v":""},"","",{"$f":"IF(AM38=\"\",\"\",IF(AM38>0,ROUND(IF(MOD(AM38,30)=0,QUOTIENT(AM38,30)*VLOOKUP(C38&IF(AC38=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG38>100,0,$BG38)/100),AM38*VLOOKUP(C38&IF(AC38=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG38>100,0,$BG38)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,5,5,"2025-11-01","2025-11-30",0,0,"2025-01-01","2025-11-30","00:00:00","2025-01-01",0,0,0,0,0,"2025-01-01",0,0,0,0,0,3,0,0,0,"AA","A","A","NO","",null,148,30,30,30,30,28,210,30,30,30,30,30,30,30,1,1,1,1,1,1,1,1,1,1,1,1,31,30,31,31,28,31,30,31,30,31,31,30]
[null,"",{"$f":"IF(AND(K39=\"\",L39=\"\"),\"\",IF(L39>=65,1,IF(AND(L39>=33,OR(K39=\"P. Cerebral\",K39=\"Enf. Mental\",K39=\"D. Intelectual\",K39=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(G39,1,2)&(MID(G39,FIND(\" \",G39,1)+1,2))&IFERROR((MID(G39,FIND(\",\",G39,1)+2,1)),MID(G39,FIND(\" \",G39,FIND(\" \",G39,1)+1)+1,1)),\"\")","v":""},null,"","","","","","","","","","","",{"$f":"IFERROR(VLOOKUP(P39,Importes!L:Q,2,FALSE),\"\")","v":""},{"$f":"IF(G39=\"\",\"\",$M$4)","v":""},{"$f":"IF(G39=\"\",\"\",$M$2)","v":""},{"$f":"IF(G39=\"\",\"\",$Q$2)","v":""},{"$f":"IF(G39=\"\",\"\",IF($AH$8=\"Extra Inverno\",\"1/12/2016\",IF($AH$8=\"Extra Verán\",\"1/6/2017\",$AH$8)))","v":""},{"$f":"IF(G39=\"\",\"\",$AN$9)","v":""},{"$f":"IF(G39=\"\",\"\",IF($AG$8=\"x\",\"Mensualidade\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),12,1)),\"Extra Inverno\",IF(AND($AG$8=\"\",$AG$9=\"x\",$I$7=DATE(YEAR($I$7),6,1)),\"Extra Verán\",\"\"))))","v":""},{"$f":"$AH$9","v":0},{"$f":"IF(I39=\"\",\"\",DAY(I39)&\"/\"&MONTH(I39)&\"/\"&YEAR(I39))","v":""},{"$f":"IF(N39=\"\",\"\",DAY(N39)&\"/\"&MONTH(N39)&\"/\"&YEAR(N39))","v":""},{"$f":"IF(O39=\"\",\"\",DAY(O39)&\"/\"&MONTH(O39)&\"/\"&YEAR(O39))","v":""},{"$f":"MID(AF39,1,4)","v":"AM+E"},"Si","",{"$f":"IFERROR(BG39,0)","v":""},{"$f":"IF(AC39=\"Non\",\"AM+e\",\"AM+E\")","v":"AM+E"},0,{"$f":"IFERROR(IF(OR(AD39=\"+CT\",AF39=\"\"),0,ROUND(IF(MOD(AG39,30)=0,QUOTIENT(AG39,30)*VLOOKUP(C39&AF39,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE39>100,0,$AE39)/100),AG39*VLOOKUP(C39&AF39,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE39>100,0,$AE39)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(AJ39=\"\",\"\",AE39),\"\")","v":""},{"$f":"IFERROR(IF($M$8=\"Si\",BK39,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ39=\"\",\"\",IF(AJ39<180,AJ39*VLOOKUP(C39&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AI39>100,0,$AI39)/100),IF(AJ39=180,VLOOKUP(C39&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*6*(IF($AI39>100,0,$AI39)/100),0))),0)","v":""},"","",{"$f":"IF(AM39=\"\",\"\",IF(AM39>0,ROUND(IF(MOD(AM39,30)=0,QUOTIENT(AM39,30)*VLOOKUP(C39&IF(AC39=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AL39>100,0,$AL39)/100),AM39*VLOOKUP(C39&IF(AC39=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AL39>100,0,$AL39)/100)),2),0))","v":""},{"$f":"IFERROR(IF(ED39=\"NO\",\"\",ED39),\"\")","v":""},null,null,{"$f":"IF(AQ39=\"IT\",N39,IF(AQ39=\"AT\",N39,\"\"))","v":""},{"$f":"IF(AND(AR39<>\"\",O39>0),O39,\"\")","v":""},null,null,null,{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},{"$f":"IF($AH39>0,\"X\",\"\")","v":""},"",0,{"$f":"IFERROR(IF(OR(AD39=\"+CT\",AF39=\"\"),0,ROUND(IF(MOD(AG39,30)=0,QUOTIENT(AG39,30)*VLOOKUP(C39&AF39,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($AE39>100,0,$AE39)/100),AG39*VLOOKUP(C39&AF39,Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($AE39>100,0,$AE39)/100)),2)),0)","v":0},{"$f":"IFERROR(IF(BK39=\"\",\"\",BG39),\"\")","v":""},"",{"$f":"IF(AJ39=\"\",\"\",IF(AJ39>0,ROUND(IF(MOD(AJ39,30)=0,QUOTIENT(AJ39,30)*VLOOKUP(C39&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG39>100,0,$BG39)/100),BK39*VLOOKUP(C39&\"CP\",Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG39>100,0,$BG39)/100)),2),0))","v":""},{"$f":"IFERROR(IF(BN39=\"\",\"\",BG39),\"\")","v":""},{"$f":"IFERROR(IF(OR(EA39=\"ALINT\",EA39=\"AL\"),DR39,\"\"),\"\")","v":""},{"$f":"IF(AM39=\"\",\"\",IF(AM39>0,ROUND(IF(MOD(AM39,30)=0,QUOTIENT(AM39,30)*VLOOKUP(C39&IF(AC39=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),6,9),FALSE)*(IF($BG39>100,0,$BG39)/100),AM39*VLOOKUP(C39&IF(AC39=\"Si\",\"AM+E\",\"AM\"),Importes!$A$2:$I$14,IF($I$7<DATE(2026,1,1),5,8),FALSE)*(IF($BG39>100,0,$BG39)/100)),2),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(VALUE($A39)=0,\"\",IF(CU$11=\"\",\"\",IF(AND($O39<>\"\",$O39<CU$6),\"\",IF($N39>CU$6,\"\",IF(AND(OR($O39=\"\",$O39>=CU$6),$AR39=\"\",$AF39<>\"\"),\"F\",IF(AND($AR39<=CU$6,OR($AS39=$O39,$AS39>=CU$6,IF($AS39=\"\",$AU$5))),\"h\",IF($DE39>=CU$6,\"F\",\"\")))))))","v":""},{"$f":"IF(COUNTIF(BP39:CU39,\"F\")=0,0,COUNTIF(BP39:CU39,\"F\"))","v":0},{"$f":"IF(COUNTIF(BP39:CU39,\"h\")=0,0,COUNTIF(BP39:CU39,\"h\"))","v":0},{"$f":"IF(OR(AQ39=\"IT\",AQ39=\"AT\"),DI39+1-(DH39),0)","v":0},{"$f":"IF(AQ39=\"AT\",1,IF(IF(AQ39=\"IT\",DI39+1-(DH39),0)>15,15,IF(AQ39=\"IT\",DI39+1-(DH39),0)))","v":0},{"$f":"IF(AQ39=\"IT\",IF(CX39-CW39>15,15,CX39-CW39),IF(AQ39=\"AT\",IF(CX39-CW39>1,1,CX39-CW39),0))","v":0},{"$f":"IF(OR(AT39=\"SI\",$DA$8=\"SI\"),CY39-CZ39,IF(AND(AT39<>\"SI\",OR($DA$8=\"NON\",$DA$8=\"<<>>\")),IF(CZ39<=3,IF(CY39-CZ39-3<=0,IF(AQ39=\"AT\",IF(CZ39=1,0,1),0),CY39-CZ39-(3-CZ39)),CY39-CZ39),0))","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,"Lugar e data:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si"]
[null,null,null,null,null,null,null,"SINATURA DA PERSOA REPRESENTANTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si"]

{"sheet":"Contador","index":1,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["expediente",7,null,null,null,"Verdadero"]

{"sheet":"Importes","index":2,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Códigos",null,"SMI",{"$f":"$K$1/30","v":39.466666666666669},{"$f":"D1/12*2","v":6.5777777777777784},"Achega SMI1",{"$f":"$K$4/30","v":40.700000000000003},{"$f":"G1/12*2","v":6.7833333333333341},"Achega SMI2","SMI 1",{"$f":"I17","v":1184},"cod",null,"tipo","tempo","nome","obxecto"]
[{"$f":"B2&C2","v":"0AM+E"},0,"AM+E",{"$f":"D3+D4","v":0.5},{"$f":"ROUND(D2*$D$1+$E$1*D2,2)","v":23.02},{"$f":"ROUND(D2*$I$17+$K$2*D2,2)","v":690.67},{"$f":"G3+H4","v":0.5},{"$f":"ROUND(G2*$G$1+$H$1*G2,2)","v":23.74},{"$f":"ROUND(D2*$I$18+$K$5*D2,2)","v":712.25},"Prorrata 2PE",{"$f":"K1/12*2","v":197.33333333333334},100,{"$f":"IF(N2=\"Indefinido\",\"Ind\",\"Temp\")","v":"Ind"},"Indefinido","TIEMPO COMPLETO","ORDINARIO"]
["0AM",0,"AM",0.5,{"$f":"ROUND(D3*$D$1,2)","v":19.73},{"$f":"ROUND(D3*$I$17,2)","v":592},0.5,{"$f":"ROUND(G3*$G$1,2)","v":20.350000000000001},{"$f":"ROUND(D3*$I$18,2)","v":610.5},null,null,109,{"$f":"IF(N3=\"Indefinido\",\"Ind\",\"Temp\")","v":"Ind"},"Indefinido","TIEMPO COMPLETO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","TRANSFORMACIÓN CONTRATO Temporal"]
[null,null,null,null,null,null,null,null,null,"SMI 2",{"$f":"I18","v":1221},130,"Ind","Indefinido","TIEMPO COMPLETO","MINUSVÁLIDOS"]
[{"$f":"B5&C5","v":"0CP"},0,"CP",{"$f":"0.5/6","v":8.3333333333333329E-2},{"$f":"ROUND(D5*$D$1,2)","v":3.29},{"$f":"ROUND(D5*$I$17,2)","v":98.67},{"$f":"0.5/6","v":8.3333333333333329E-2},{"$f":"ROUND(G5*$G$1,2)","v":3.39},{"$f":"ROUND(D5*$I$18,2)","v":101.75},"Prorrata 2PE",{"$f":"K4/12*2","v":203.5},139,"Ind","Indefinido","TIEMPO COMPLETO","MINUSVÁLIDOS","TRANSFORMACIÓN CONTRATO Temporal"]
[{"$f":"B6&C6","v":"0CV"},0,"CV",0.5,{"$f":"ROUND(D6*$D$1,2)","v":19.73},{"$f":"ROUND(D6*$I$17,2)","v":592},0.5,{"$f":"ROUND(G6*$G$1,2)","v":20.350000000000001},{"$f":"ROUND(D6*$I$18,2)","v":610.5},null,null,150,"Ind","Indefinido","TIEMPO COMPLETO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","INICIAL"]
["0CV+E",0,"CV+E",{"$f":"D3+D4","v":0.5},{"$f":"ROUND(D7*$D$1,2)","v":19.73},{"$f":"ROUND(D7*$I$17,2)","v":592},{"$f":"G3+G4","v":0.5},{"$f":"ROUND(G7*$G$1,2)","v":20.350000000000001},{"$f":"ROUND(D7*$I$18,2)","v":610.5},null,null,189,"Ind","Indefinido","TIEMPO COMPLETO",null,"TRANSFORMACIÓN CONTRATO Temporal"]
[null,null,null,null,null,null,null,null,null,null,null,200,"Ind","Indefinido","TIEMPO PARCIAL","ORDINARIO"]
["1AM+E",1,"AM+E",0.65,{"$f":"ROUND(D9*$D$1+$E$1*D9,2)","v":29.93},{"$f":"ROUND(D9*$I$17+$K$2*D9,2)","v":897.87},0.65,{"$f":"ROUND(G9*$G$1+$H$1*G9,2)","v":30.86},{"$f":"ROUND(D9*$I$18+$K$5*D9,2)","v":925.93},null,null,209,"Ind","Indefinido","TIEMPO PARCIAL","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","TRANSFORMACIÓN CONTRATO Temporal"]
["1AM",1,"AM",0.65,{"$f":"ROUND(D10*$D$1,2)","v":25.65},{"$f":"ROUND(D10*$I$17,2)","v":769.6},0.65,{"$f":"ROUND(G10*$G$1,2)","v":26.46},{"$f":"ROUND(D10*$I$18,2)","v":793.65},null,null,230,"Ind","Indefinido","TIEMPO PARCIAL","MINUSVÁLIDOS"]
[null,null,null,null,null,null,null,null,null,null,null,239,"Ind","Indefinido","TIEMPO PARCIAL","MINUSVÁLIDOS","TRANSFORMACIÓN CONTRATO Temporal"]
["1CP",1,"CP",{"$f":"0.65/6","v":0.10833333333333334},{"$f":"ROUND(D12*$D$1,2)","v":4.28},{"$f":"ROUND(D12*$I$17,2)","v":128.27000000000001},{"$f":"0.65/6","v":0.10833333333333334},{"$f":"ROUND(G12*$G$1,2)","v":4.41},{"$f":"ROUND(D12*$I$18,2)","v":132.28},null,null,250,"Ind","Indefinido","TIEMPO PARCIAL","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","INICIAL"]
["1CV",1,"CV",0.65,{"$f":"ROUND(D13*$D$1,2)","v":25.65},{"$f":"ROUND(D13*$I$17,2)","v":769.6},0.65,{"$f":"ROUND(G13*$G$1,2)","v":26.46},{"$f":"ROUND(D13*$I$18,2)","v":793.65},null,null,289,"Ind","Indefinido","TIEMPO PARCIAL",null,"TRANSFORMACIÓN CONTRATO Temporal"]
["1CV+E",1,"CV+E",0.65,{"$f":"ROUND(D14*$D$1+$E$1*D14,2)","v":29.93},{"$f":"ROUND(D14*$I$17+$K$2*D14,2)","v":897.87},0.65,{"$f":"ROUND(G14*$G$1+$H$1*G14,2)","v":30.86},{"$f":"ROUND(D14*$I$18+$K$5*D14,2)","v":925.93},null,null,300,"Ind","Indefinido","FIJO/DISCONTINUO"]
[null,null,null,null,null,null,null,null,null,null,null,309,"Ind","Indefinido","FIJO/DISCONTINUO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","TRANSFORMACIÓN CONTRATO Temporal"]
["Minusvalía",null,"Tipo ",null,null,null,null,null,null,null,null,330,"Ind","Indefinido","FIJO/DISCONTINUO","MINUSVÁLIDOS"]
["Pensionista",null,"minus",null,null,"2024-02-06","SMI",2025,1184,null,null,350,"Ind","Indefinido","FIJO/DISCONTINUO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","INICIAL"]
["Definitiva",null,"Física",null,null,"2025-02-12","SMI",2026,1221,null,null,389,"Ind","Indefinido","FIJO/DISCONTINUO",null,"TRANSFORMACIÓN CONTRATO Temporal"]
["Provisional",null,"Sensorial",null,null,null,null,null,null,null,null,401,"Temp","Duración Determinada","TIEMPO COMPLETO","OBRA O SERVICIO DETERMINADO"]
[" ",null,"P. Cerebral",null,null,null,"mes","SMI","mes",null,null,402,"Temp","Duración Determinada","TIEMPO COMPLETO","EVENTUAL POR CIRCUNSTANCIAS DE LA PRODUCCIÓN"]
["sexo",null,"Enf. Mental",null,null,null,10,1184,10,"Out",null,403,"Temp","Duración Determinada","TIEMPO COMPLETO","INSERCIÓN"]
["H",null,"D. Intelectual","meses 1º SMI",{"$f":"COUNTIF($H$21:$H$32,MIN($H$21:$H$32))","v":3},null,11,1184,11,"Nov",null,408,"Temp","Temporal","TIEMPO COMPLETO",null,"CARÁCTER ADMINISTRATIVO"]
["M",null,"Psíquica","meses 2º SMI",{"$f":"COUNTIF($H$24:$H$32,MAX($H$24:$H$32))","v":9},null,12,1184,12,"Dec",null,410,"Temp","Duración Determinada","TIEMPO COMPLETO","INTERINIDAD"]
[null,null,null,null,null,null,1,1221,1,"Xan",null,418,"Temp","Duración Determinada","TIEMPO COMPLETO","INTERINIDAD","CARÁCTER ADMINISTRATIVO"]
[null,null,null,null,null,null,2,1221,2,"Feb",null,420,"Temp","Temporal","TIEMPO COMPLETO","PRÁCTICAS"]
["Conv",null,null,null,null,null,3,1221,3,"Mar",null,421,"Temp","Temporal","TIEMPO COMPLETO","FORMACIÓN"]
["Baixa",null,null,null,null,null,4,1221,4,"Abr",null,430,"Temp","Temporal","TIEMPO COMPLETO","MINUSVÁLIDOS"]
["Non",null,null,null,null,null,5,1221,5,"Mai",null,441,"Temp","Temporal","TIEMPO COMPLETO","RELEVO"]
["Non",null,null,null,null,null,6,1221,6,"Xuñ",null,450,"Temp","Temporal","TIEMPO COMPLETO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE"]
[null,null,null,null,null,null,7,1221,7,"Xull",null,501,"Temp","Duración Determinada","TIEMPO PARCIAL","OBRA O SERVICIO DETERMINADO"]
[null,"Mes",null,null,null,null,8,1221,8,"Ago",null,502,"Temp","Duración Determinada","TIEMPO PARCIAL","EVENTUAL POR CIRCUNSTANCIAS DE LA PRODUCCIÓN"]
[null,7,"Xullo",null,null,null,9,1221,9,"Sep",null,503,"Temp","Duración Determinada","TIEMPO PARCIAL","INSERCIÓN"]
[null,8,"Agosto",null,null,null,null,null,null,null,null,508,"Temp","Temporal","TIEMPO PARCIAL",null,"CARÁCTER ADMINISTRATIVO"]
[null,9,"Setembro",null,null,null,null,null,null,null,null,510,"Temp","Duración Determinada","TIEMPO PARCIAL","INTERINIDAD"]
[null,10,"Outubro",null,null,null,null,null,null,null,null,518,"Temp","Duración Determinada","TIEMPO PARCIAL","INTERINIDAD","CARÁCTER ADMINISTRATIVO"]
[null,11,"Novembro",null,null,null,null,null,null,null,null,520,"Temp","Temporal","TIEMPO PARCIAL","PRÁCTICAS"]
[null,12,"Decembro",null,null,null,null,null,null,null,null,530,"Temp","Temporal","TIEMPO PARCIAL","MINUSVÁLIDOS"]
[null,1,"Xaneiro",null,null,null,null,null,null,null,null,540,"Temp","Temporal","TIEMPO PARCIAL","JUBILADO PARCIAL"]
[null,2,"Febreiro",null,null,null,null,null,null,null,null,541,"Temp","Temporal","TIEMPO PARCIAL","RELEVO"]
[null,3,"Marzo ",null,null,null,null,null,null,null,null,550,"Temp","Temporal","TIEMPO PARCIAL","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE"]
[null,4,"Abril",null,null,null,null,null,null,null,null," ",null," "," "," "," "]
[null,5,"Maio"]
[null,6,"Xuño"]

{"sheet":"Campos a Cubrir","index":3,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Este modelo está en formato Excel e, polo tanto, aínda que pode ser cuberta utilizando LibreOffice, debe gardar os cambios no mesmo formato.",null,null,null,null,null,null,null,"I  M  P  O  R  T  A  N  T  E"]
[]
["A continuación describense os campos do formulario con indicación do tipo de campo, a súa descrición, si é un campo autocalculado e si se cubre ou non",null,null,null,null,null,null,null,"Este modelo de folla de cálculo tén celdas ocultas, e celdas con fórmulas (algunhas delas ocultas)"]
[null,null,null,null,null,null,null,null,"para inserir novas filas ou para borrar información deben terse en conta as seguintes"]
["Campo",null,"Tamaño","Tipo","Descrición",null,null,null,"recomendacións:"]
["Nº Exp",null,19,"Texto","Nº de Expediente administrativo asignado na convocatoria de axudas"]
["C.E.E.",null,50,"Texto","Nome do Centro Especial de Emprego",null,null,null,"Borrar información"]
["C.I.F.",null,9,"Texto","C.I.F. do Centro Especial de Emprego"]
["Nome da persoa representante",null,null,"Texto","Nome da persoa representate do Centro Especial de Emprego",null,null,null,"No caso de querer borrar a información dunha fila completamente debemos facelo"]
[null,null,null,null,null,null,null,null,"copiando na fila que queremos borrar  a inforación dunha fila que esté totalmente en"]
["Novo Idx",null,null,"Numérico","Suxire o nº de índice polo que se vincularía a alta dunha nova persoa traballadora ","Non se cubre","Autocalculado",null,"blanco, xa que así conservamos a formulas de cálculo ocultas cos seus valores correctos."]
["Tot. Trab. CEE/RNT",null,null,"Numérico","Nº de persoas traballadoras que aparecen no RNT do mes que se certifica"]
["Certificación do cadro de persoal do mes de ",null,null,"Texto","lista despregable donde se escolle o mes que se vai a certificar",null,null,null,"Para facer esto temos que marcar a fila en blanco a copiar (totalmente) facendo a selección "]
["Certificación comprobada",null,null,"Texto","lista despregable donde se indica que a certificación esta totalmente correcta","(Por omisión ten o valor \"SI\")",null,null,"desde o número indicativo da fila (non desde unha celda), seleccionar a opción de copiar e"]
["Calculo correcto",null,null,"Texto","lista despregable donde se indica que os calculos feitos son correctos","(Por omisión ten o valor \"SI\")",null,null,"posicionarnos a celda que corresponda co Idx/Idn da fila a borrar, e logo pegar a información "]
[null,null,null,null,null,null,null,null,"seleccionada.  Desta maneira aseguramonos de que todas as formulas, ocultas ou non, se "]
["Total Achega Mes",null,null,"Numérico","Importe total das achegas mensuais solicitadas na certificación","Non se cubre","Autocalculado",null,"copian correctamente na fila que acabamos de borrar "]
["T.c.Vacacións",null,null,"Numérico","Importe total dos complemento por vacións solicitados na certificación","Non se cubre","Autocalculado"]
["Tot. Trab. Mes",null,null,"Numérico","Total de traballadores con discapacidade que se relacionan no mes","Non se cubre","Autocalculado",null,"Inserir novas filas para engadir datos de novas persoas traballadoras "]
["Total Certificación mes de ",null,null,"Numérico","total conxunto de todas a achegas e complemento que se relacionan na certificación mensual","Non se cubre","Autocalculado",null,"Para facer insercións correctamente debemos:"]
[]
["Conv. IT",null,null,"Texto","lista despregable para indicar si os calculos das baixas por enfermidade correspondense co que dispoña a normativa da Seguridade Social ou si hai un convenio colectivo de aplicación específica","(Por omisión ten o valor \"NON\")",null,null,"1º","Seleccionar o rango de filas a inserir e executar o comando"]
[null,null,null,null,null,null,null,null,"2º","Seleccionar completamente unha fila con datos cubertos totalmente"]
["Idx / Idn",null,3,"Numérico","Indicaría o nº de índice polo que se vincularía á persoa traballadora (é único para cada traballador e contrato de traballo)",null,null,null,null,"(seleccionando desde o número indicativo da fila)"]
["G D",null,1,"Numérico","Permite determinar si polo traballador se precibe una subvención do 50 % do SMI ou si se prima cun 10 % adicional determinado na orde de convocatoria de axudas","Non se cubre","Autocalculado",null,"3º","Escoller o comando copiar"]
["Salario/mes Convenio Colectivo",null,null,"Numérico","Importe mensual do salario bruto a percibir por cada persoa traballadora",null,null,null,"4º","Pegar nas novas filas en branco a selección anterior para que se restablezan nas"]
["Nº Rexistro ou data publicación C.C.",null,3,"Texto","Nº de Rexistro ou data de publicación do convenio colectivo de aplicación ó traballador",null,null,null,null,"novas filas as fórmulas ocultas ou non para poder facer posibles os cálulos)"]
["Traballador",null,50,"Texto","Apelidos e nome da persoa traballadora",null,null,null,null,"posicionandonos na celda que corresponda con campo Idx/Idn da nova fila a inserir"]
["D.N.I.",null,9,"Texto","Documento Nacional de Identidade da persoa traballadora"]
["Data Nacemento",null,6,"Data\ndd/mm/aa","Data de nacemento",null,null,null,"*****"]
["Sexo",null,1,"Texto","Sexo",null,null,null,"No caso de que nalgunha celda se borrase unha fórmula necesaria para o correcto cálculo da"]
["Discapacidade",null,14,"Texto","Tipo de discapacidade. Lista despregable cos seguintes valores (Física, Sensorial, P. Cerebral, Enf. Mental, D. Intelectual, Psíquica)",null,null,null,"subvención, sempre se pode repoñer copiando a fórmula correspondente dunha celda que faga"]
["Grao",null,4,"Numérico","% de discapacidade do traballador",null,null,null,"ese mesmo cálculo para outra persoa traballadora"]
["Tipo",null,11,"Texto","lista despregable donde se indica si a discapacidade do traballador é Provisional, Definitiva ou si é Pensionista con consideración de persoa con discapacidade (o contrato debe ser anterior a 29/11/2018)"]
["Data Alta",null,6,"Data\ndd/mm/aa","Data de inicio da relación laboral (data de alta do contrato de traballo)"]
["Data Baixa",null,6,"Data\ndd/mm/aa","Data de finalización da relación laboral (data de baixa do contrato de traballo)"]
["Contrato Código",null,3,"Numérico","Lista desplegable. Código do contrato de traballo según a codificación do INSS  (*)",null,null,"(*)No caso de contratos 402 ou 502 débese indicar a data de finalización do mesmo"]
["Contrato Tipo",null,4,"Texto","Sinala si o contrato de traballo é de carácter indefinido (Ind) ou temporal (Temp)","Non se cubre","Autocalculado"]
["Rateo",null,3,"Texto","Lista despregable de dous valores (Si - Non) Indica si nas retribucións percibidas mensualmente pola persoa traballadora se inclúe ou non a Parte proporcional das Pagas Extraordinarias (só a efectos de clasificación, os cálculos das achegas mensuais xa incluen a p.p. da paga extraordinaria)"]
["% Xornada",null,4,"Numérico","% de Xornada da persoa traballadora no mes de inicio do período subvencionable"]
["Tipo de achega",null,null,"Texto","Indica o tipo de achega que se pericibe por cada traballador, equivalente a porcentaxe do SMI que corresponda segundo o beneficiario mais a parte proporcional da paga extraordinaria que lle corresponda por mes","Non se cubre","Autocalculado"]
["Días",null,null,"Numérico","Número de días que se solicitan por cada persoa traballadora","Non se cubre","Autocalculado"]
["Achega Mensual",null,null,"Numérico","Importe da subvención mensual correspondente a cada persoa traballadora","Non se cubre","Autocalculado"]
["% Xornada",null,null,"Numérico","% de xornada da persoa traballadora correspondente á liquidación do complemento de vacacións","Non se cubre","Autocalculado"]
["Días",null,null,"Numérico","Número de días que se solicitan por cada persoa traballadora polo complemento de vacacións nos casos de finalización de contratos de traballo e que estas foran cotizadas en non disfrutadas pola persoa traballadora","Non se cubre","Autocalculado"]
["Comp. Vacacións",null,null,"Numérico","Importe da subvención correspondente ao complemento de vacacións cotizadas en non disfrutadas","Non se cubre","Autocalculado"]
["Certific",null,null,"Texto","Campo indicativo de que a persoa traballador se inclúe na certificación do mes","Non se cubre","Autocalculado"]
["Días Absentismo",null,null,"Numérico","Número de días que se descontarán en casos de absentismo"]
["IT   AT",null,null,"Texto","Lista desplebabel de dous valores (IT-AT) donde si indicará si a baixa laboral é por Incapacidade Temporal ou por Accidente de Traballo"]
["Baixa",null,null,"Data\ndd/mm/aa","Data de inicio da baixa por enfermidade ou accidente de traballo"]
["Alta",null,null,"Data\ndd/mm/aa","Data de finalización da baixa por enfermidade ou accidente de traballo"]
["Conv Baixa",null,null,"Texto","lista despregable para indicar si, nalgún caso específico e para esa persoa traballadora,  os calculos das baixas por enfermidade correspondense co que dispoña a normativa da Seguridade Social ou si hai un convenio colectivo de aplicación específica"]
["Interinidade",null,null,"Texto","Nº do DNI ou NIF da persoa traballadora sustituida. So se cubre para os contratos 410 e 510"]
["Observacións",null,null,"Texto"]