{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Certificación Relación Mensual","Importes","Contador","Campos a Cubrir"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":63,"n_cols":107,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,6,7,7],[1,6,1,10],[2,6,2,10],[3,6,3,10],[8,20,8,21]]}
["IdN","ACHE","Proc","Num",null,"Meses",7,8,9,10,11,12,1,2,3,4,"Xornada","Achega","Dias","Contía","%CV","Diascv","Vacacións","NÓMINA",null,"IT","Baixa",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&\"-\"&$AC$7&\"-\"&$AD$7)-1)>28,29,\"\")","v":29},{"$f":"IF(DAY(VALUE(1&\"-\"&$AC$7&\"-\"&$AD$7)-1)>29,30,\"\")","v":30},{"$f":"IF(DAY(VALUE(1&\"-\"&$AC$7&\"-\"&$AD$7)-1)>30,31,\"\")","v":31},"Trab.","Baixa",null,null,null,null,"inimes","finmes","diasnomina","diasbaixa","dbaixa","dalta","dbaixaat","dbaixait","Dias baixa mes","Diasconsumidos","Totdiasbaixa","ya subv.","Pedientes","DatainiCV","DiasCV","1ºS 3","resto","os 12","- os 3 1ºS","os 12","Pago","Alt","Baix","NÓMINA",null,null,"Data_nómina"]
["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,"Xullo","Agosto","Setembro","Outubro","Novembro"]
["de",null,null,"A1",null,null,"DNI/NIF:",null,null,null,null,null,null,null,"NºExp",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,7,8,9,10,11]
["a",null,null,{"$f":"\"AV\"&IF(MAXA(A2:A60)=0,11,11+MAXA(A12:A60))","v":"AV11"},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,"Xullo","Agosto","Setembro","Outubro","Novembro"]
[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 Comunadade 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,{"$f":"VALUE(1&\"-\"&$AC$7&\"-\"&$AD$7)-1","v":"2023-07-31"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IFERROR(VLOOKUP(#REF!,$AC$12:$AC$60,1,FALSE),\"\")=\"\",\"\",1)","v":""}]
[null,null,null,null,null,"Desde",{"$f":"IF($AD$5=VALUE(30&\"/\"&6&\"/\"&YEAR($AD$5)),\"Verán\",IF($AD$5=VALUE(31&\"/\"&12&\"/\"&YEAR($AD$5)),\"Inverno\",\"\"))","v":""},"Data_nómina",null,null,null,null,null,"50%SMI","60%SMI",null,"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,"mes","ano",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(AQ11&\"/\"&MONTH($AD$5)&\"/\"&YEAR($AD$5))","v":"2023-07-01"},"2023-07-02","2023-07-03","2023-07-04","2023-07-05","2023-07-06","2023-07-07","2023-07-08","2023-07-09","2023-07-10","2023-07-11","2023-07-12","2023-07-13","2023-07-14","2023-07-15","2023-07-16","2023-07-17","2023-07-18","2023-07-19","2023-07-20","2023-07-21","2023-07-22","2023-07-23","2023-07-24","2023-07-25","2023-07-26","2023-07-27","2023-07-28","2023-07-29","2023-07-30","2023-07-31",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,"Convenio"]
["Novo ","Tot. Trab. CEE/RNT",null,null,null,"Certificación do cadro de ",null,{"$f":"VALUE(\"1/\"&HLOOKUP(G8,Z2:AN3,2,FALSE)&\"/\"&(IF(HLOOKUP(G8,Z2:AN3,2,FALSE)<7,YEAR(AA7)+1,YEAR(AA7))))","v":"2023-07-01"},null,"Certificación comprobada",null,null,"Si",{"$f":"COUNTIFS($I$11:$I$61,P7,$B$11:$B$61,0,$X$11:$X$61,\"SI\")","v":0},{"$f":"COUNTIFS($I$11:$I$61,P7,$B$11:$B$61,1,$X$11:$X$61,\"SI\")","v":0},"H","T. Achega mes",null,null,{"$f":"VALUE(SUBTOTAL(109,T11:T61))","v":0},"T.c.Vacacións",null,{"$f":"SUBTOTAL(9,W11:W61)","v":0},null,"Periodo",null,"2023-07-01",null,{"$f":"IF(MONTH(T8)+1>12,MONTH(T8)+1-12,MONTH(T8)+1)","v":8},{"$f":"IF(MONTH(T8)+1>12,YEAR(T8)+1,YEAR(T8))","v":2023},null,null,null,null,null,null,"Anexo X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","% Trab. c/discap.",null,null,{"$f":"IFERROR(T9/E7,0)","v":0},"persoal do mes de ","Xullo",null,null,"Calculo correcto?",null,null,"Si",{"$f":"COUNTIFS($I$11:$I$61,P8,$B$11:$B$61,0,$X$11:$X$61,\"SI\")","v":0},{"$f":"COUNTIFS($I$11:$I$61,P8,$B$11:$B$61,1,$X$11:$X$61,\"SI\")","v":0},"M","T.P.Trab",null,{"$f":"SUM(N7:O8)","v":0},{"$f":"H7","v":"2023-07-01"},"Tot. Certificación mes de",null,null,null,"Convc.Axudas",null,null,{"$f":"(DAY(AA7)&\"/\"&(VALUE(MONTH(AA7))+5)&\"/\"&YEAR(AA7))-1","v":"2023-11-30"},"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,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":"CT8","v":"NON"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB9","v":"NON"}]
[{"$f":"MAXA(A11:A61)+1","v":1},"G","Cod","Salario mes","Nº Rexistro",null,null,null,null,null,null,null,null,null,null,null,"Tot. P. Trab. mes",null,null,{"$f":"COUNTIF(X11:X61,\"SI\")","v":0},{"$f":"G8","v":"Xullo"},null,{"$f":"W7+T7","v":0},null,null,null,"Conv. IT","NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["IdX",null,null,"Convenio","ou data pub","Traballador",null,"Data",null,null,null,null,"Data","Data","Código","Tipo ","%","Tipo",null,"Achega","%",null,"Comp.",null,"Dias","IT","I T  /  A T",null,"Conv",null,null,null,"Xust",null,"INF.","Copia ","Comun.","Anexo",null,null,"Anexo",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,"tres primeros"]
["IdN","D","RNT","Colectivo","Conv. Colect","(Apelido1 Apelido2, Nome)","N.I.F.","Nacemento","sexo","Discapacidade","Grao","Tipo","Alta ","Baixa","Contrato","Cont","Xornada","Achega","Días","Mensual","Xornada2","Días3","Vacacións","Certific4","Absentism","AT","Baixa5","Alta","Baixa6","Interindade","Observacións","Nómina","Pago","TC2","IDC","Cto","SEPE","XI","IDC7","TA2","XII","Columna8","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.","Baixa9","Baixa10","Acum ","xa sub","Pend","inimes","finmes","diasnomina","diasbaixa","dbaixa","dalta","dbaixaat","dbaixait","Dias baixa mes","Diasconsumidos","Totdiasbaixa","ya subv.","Pedientes","DatainiCV","DiasCV","1ºS 3","resto","os 12","- os 3 1ºS","os 1211","Pago12","Alt","Baix","Certific","52","105","Data_nómina","Columna13"]
[null,{"$f":"IF(AND(J12=\"\",K12=\"\"),\"\",IF(K12>=65,1,IF(AND(K12>=33,OR(J12=\"P. Cerebral\",J12=\"Enf. Mental\",J12=\"D. Intelectual\",J12=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(F12,1,2)&(MID(F12,FIND(\" \",F12,1)+1,2))&IFERROR((MID(F12,FIND(\",\",F12,1)+2,1)),MID(F12,FIND(\" \",F12,FIND(\" \",F12,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O12,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",{"$f":"IFERROR(IF(OR(CV12=\"AAINT\",CV12=\"ALINT\",CV12=\"AA\",CV12=\"AL\"),CD12,\"\"),\"\")","v":0},{"$f":"IFERROR(ROUND(IF(MOD(S12,30)=0,QUOTIENT(S12,30)*VLOOKUP(B12&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q12>100,0,$Q12)/100),S12*VLOOKUP(B12&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q12>100,0,$Q12)/100)),2),0)","v":0},{"$f":"IFERROR(IF(V12=\"\",\"\",Q12),\"\")","v":""},{"$f":"IFERROR(IF(OR(CV12=\"ALINT\",CV12=\"AL\"),CP12,\"\"),\"\")","v":""},{"$f":"IF(V12=\"\",\"\",IF(V12>0,ROUND(IF(MOD(V12,30)=0,QUOTIENT(V12,30)*VLOOKUP(B12&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U12>100,0,$U12)/100),V12*VLOOKUP(B12&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U12>100,0,$U12)/100)),2),0))","v":""},{"$f":"IFERROR(IF(CY12=\"NO\",\"\",CY12),\"\")","v":""},null,null,{"$f":"IF(Z12=\"IT\",M12,IF(Z12=\"AT\",M12,\"\"))","v":""},{"$f":"IF(AND(AA12<>\"\",N12>0),N12,\"\")","v":""},"Si",null,"",{"$f":"IF($T12>0,\"X\",\"\")","v":""},"","","","","","","","","",{"$f":"IF(IFERROR(VLOOKUP(G12,$AD$12:$AD$60,1,FALSE),\"\")=\"\",\"\",1)","v":""},{"$f":"IF(VALUE($A12)=0,\"\",IF(AQ$11=\"\",\"\",IF($N12<AQ$6,\"\",IF($M12>AQ$6,\"\",IF(AND(OR($N12=\"\",$N12>=AQ$6),$AA12=\"\",$R12<>\"\"),\"F\",IF(AND($AA12<=AQ$6,OR($AB12=$N12,$AB12>=AQ$6,IF($AB12=\"\",$AD$5))),\"h\",IF($CC12>=AQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A12)=0,\"\",IF(BA$11=\"\",\"\",IF($N12<BA$6,\"\",IF($M12>BA$6,\"\",IF(AND(OR($N12=\"\",$N12>=BA$6),$AA12=\"\",$R12<>\"\"),\"F\",IF(AND($AA12<=BA$6,OR($AB12=$N12,$AB12>=BA$6,IF($AB12=\"\",$AD$5))),\"h\",IF($CC12>=BA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A12)=0,\"\",IF(BK$11=\"\",\"\",IF($N12<BK$6,\"\",IF($M12>BK$6,\"\",IF(AND(OR($N12=\"\",$N12>=BK$6),$AA12=\"\",$R12<>\"\"),\"F\",IF(AND($AA12<=BK$6,OR($AB12=$N12,$AB12>=BK$6,IF($AB12=\"\",$AD$5))),\"h\",IF($CC12>=BK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",{"$f":"IF(COUNTIF(AP12:BU12,\"F\")=0,0,COUNTIF(AP12:BU12,\"F\"))","v":0},{"$f":"IF(COUNTIF(AP12:BU12,\"h\")=0,0,COUNTIF(AP12:BU12,\"h\"))","v":0},{"$f":"IF(OR(Z12=\"IT\",Z12=\"AT\"),CG12+1-(CF12),0)","v":0},{"$f":"IF(Z12=\"AT\",1,IF(IF(Z12=\"IT\",CG12+1-(CF12),0)>15,15,IF(Z12=\"IT\",CG12+1-(CF12),0)))","v":0},{"$f":"IF(Z12=\"IT\",IF(BX12-BW12>15,15,BX12-BW12),IF(Z12=\"AT\",IF(BX12-BW12>1,1,BX12-BW12),0))","v":0},{"$f":"IF(OR(AC12=\"SI\",$CA$8=\"SI\"),BY12-BZ12,IF(AND(AC12<>\"SI\",OR($CA$8=\"NON\",$CA$8=\"<<>>\")),IF(BZ12<=3,IF(BY12-BZ12-3<=0,IF(Z12=\"AT\",IF(BZ12=1,0,1),0),BY12-BZ12-(3-BZ12)),BY12-BZ12),0))","v":0},{"$f":"IF(M12<$T$8,$T$8,M12)","v":"2023-07-01"},{"$f":"IF(N12=\"\",$AD$5,N12)","v":"2023-07-31"},{"$f":"IF(BV12+CE12>30,30,IF(AND(MONTH($H$7)=2,BV12>=DAY($AD$5),OR(AA12=\"\",AA12<=$H$7)),30,IF(BV12+CA12>30,30,BV12+CA12)))","v":0},{"$f":"CN12","v":0},{"$f":"IF(Z12=\"at\",IF(CH12<$AA$7,CH12,IF(CH12<$T$8,$T$8-1,CH12)),CI12)","v":"2023-01-01"},{"$f":"IF(OR(AB12=\"\",AB12>$AD$5),IF(N12=\"\",$AD$5,IF(N12>$AD$5,$AD$5,N12)),AB12)","v":"2023-07-31"},{"$f":"IF(Z12=\"AT\",CI12,0)","v":"00:00:00"},{"$f":"IF(IF(AA12=\"\",0,AA12)+3=3,VALUE(1&\"-\"&1&\"-\"&$AD$7),AA12)","v":"2023-01-01"},{"$f":"BW12","v":0},{"$f":"IF(OR(Z12=\"IT\",Z12=\"AT\"),IF(CF12<CB12,CB12-(CF12),0),0)","v":0},{"$f":"IF(OR(Z12=\"IT\",Z12=\"AT\"),CG12+1-(CF12),0)","v":0},{"$f":"IF(OR(Z12=\"IT\",Z12=\"AT\"),IF(CK12>=15,12,IF(CK12<15,CK12,CK12-3)),0)","v":0},{"$f":"IF(AND(Z12=\"AT\",CL12-CJ12=0),1,IF(Z12=\"IT\",CU12,0))","v":0},{"$f":"IF(M12<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AD$5)<$AD$7,YEAR($AD$5),$AD$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AD$5)<$AD$7,YEAR($AD$5),$AD$7)),M12)","v":"2023-01-01"},{"$f":"IF(N12=\"\",0,(DAYS360(CO12,N12)+1)/30*2.5)","v":0},{"$f":"IF(CM12>=3,3,CM12)","v":0},{"$f":"IF(OR($CT$8=\"SI\",$AC12=\"SI\"),CQ12,3-CQ12)","v":0},{"$f":"IF(CK12>15,IF(OR($CT$8=\"SI\",$AC12=\"SI\"),15,12),IF(OR($CT$8=\"SI\",$AC12=\"SI\"),CK12,CK12-CQ12))","v":0},{"$f":"IF(CL12-CR12-CQ12<0,0,IF(CL12-CR12-CQ12>12,IF(OR($CT$8=\"SI\",$AC12=\"SI\"),15,12),IF(CL12-CR12-CQ12>BW12,BW12-CR12,CL12-CR12-CQ12)))","v":0},{"$f":"IF(CT12-CS12>=IF(OR($CT$8=\"SI\",$AC12=\"SI\"),15,12),IF(OR($CT$8=\"SI\",$AC12=\"SI\"),15,12),CT12-CS12)","v":0},{"$f":"CW12&CX12&IF(OR(O12=510,O12=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(M12)<YEAR($H$7),\"A\",IF(YEAR(M12)=YEAR($H$7),IF(MONTH(M12)<=MONTH($H$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(N12=\"\",\"A\",IF(YEAR(N12)>YEAR($H$7),\"A\",IF(YEAR(N12)=YEAR($H$7),IF(MONTH(N12)>MONTH($H$7),\"A\",IF(MONTH(N12)=MONTH($H$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L12<33,\"NO\",IF(OR(CV12=\"AA\",CV12=\"AL\"),\"SI\",IF(OR(CV12=\"AAINT\",CV12=\"ALINT\"),\"SI\"))),\"\")","v":"NO"},{"$f":"IF(COLUMN()>0,5,5)","v":5},{"$f":"IFERROR(IF(AND(F12>0,G12>0),7,0),7)","v":0},{"$f":"IFERROR(IF(CY12=\"SI\",$H$7,\"\"),0)","v":""}]
[null,{"$f":"IF(AND(J13=\"\",K13=\"\"),\"\",IF(K13>=65,1,IF(AND(K13>=33,OR(J13=\"P. Cerebral\",J13=\"Enf. Mental\",J13=\"D. Intelectual\",J13=\"Psíquica\")),1,0)))","v":""},{"$f":"IFERROR(MID(F13,1,2)&(MID(F13,FIND(\" \",F13,1)+1,2))&IFERROR((MID(F13,FIND(\",\",F13,1)+2,1)),MID(F13,FIND(\" \",F13,FIND(\" \",F13,1)+1)+1,1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O13,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S13,30)=0,QUOTIENT(S13,30)*VLOOKUP(B13&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q13>100,0,$Q13)/100),S13*VLOOKUP(B13&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q13>100,0,$Q13)/100)),2),0)","v":0},"","",{"$f":"IF(V13=\"\",\"\",IF(V13>0,ROUND(IF(MOD(V13,30)=0,QUOTIENT(V13,30)*VLOOKUP(B13&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U13>100,0,$U13)/100),V13*VLOOKUP(B13&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U13>100,0,$U13)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTIF(AP13:BU13,\"F\")=0,0,COUNTIF(AP13:BU13,\"F\"))","v":0},{"$f":"IF(COUNTIF(AP13:BU13,\"h\")=0,0,COUNTIF(AP13:BU13,\"h\"))","v":0},0,0,0,0,"2023-07-01","2023-07-31",0,{"$f":"CN13","v":0},"2023-01-01","2023-07-31","00:00:00","2023-01-01",{"$f":"BW13","v":0},0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,{"$f":"IFERROR(IF(AND(F13>0,G13>0),7,0),7)","v":0},{"$f":"IFERROR(IF(CY13=\"SI\",$H$7,\"\"),0)","v":""}]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O14,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S14,30)=0,QUOTIENT(S14,30)*VLOOKUP(B14&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q14>100,0,$Q14)/100),S14*VLOOKUP(B14&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q14>100,0,$Q14)/100)),2),0)","v":0},{"$f":"IFERROR(IF(V14=\"\",\"\",Q14),\"\")","v":""},{"$f":"IFERROR(IF(OR(CV14=\"ALINT\",CV14=\"AL\"),CP14,\"\"),\"\")","v":""},{"$f":"IF(V14=\"\",\"\",IF(V14>0,ROUND(IF(MOD(V14,30)=0,QUOTIENT(V14,30)*VLOOKUP(B14&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U14>100,0,$U14)/100),V14*VLOOKUP(B14&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U14>100,0,$U14)/100)),2),0))","v":""},{"$f":"IFERROR(IF(CY14=\"NO\",\"\",CY14),\"\")","v":""},null,null,{"$f":"IF(Z14=\"IT\",M14,IF(Z14=\"AT\",M14,\"\"))","v":""},{"$f":"IF(AND(AA14<>\"\",N14>0),N14,\"\")","v":""},"Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O15,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S15,30)=0,QUOTIENT(S15,30)*VLOOKUP(B15&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q15>100,0,$Q15)/100),S15*VLOOKUP(B15&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q15>100,0,$Q15)/100)),2),0)","v":0},"","",{"$f":"IF(V15=\"\",\"\",IF(V15>0,ROUND(IF(MOD(V15,30)=0,QUOTIENT(V15,30)*VLOOKUP(B15&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U15>100,0,$U15)/100),V15*VLOOKUP(B15&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U15>100,0,$U15)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O16,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S16,30)=0,QUOTIENT(S16,30)*VLOOKUP(B16&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q16>100,0,$Q16)/100),S16*VLOOKUP(B16&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q16>100,0,$Q16)/100)),2),0)","v":0},"","",{"$f":"IF(V16=\"\",\"\",IF(V16>0,ROUND(IF(MOD(V16,30)=0,QUOTIENT(V16,30)*VLOOKUP(B16&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U16>100,0,$U16)/100),V16*VLOOKUP(B16&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U16>100,0,$U16)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O17,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S17,30)=0,QUOTIENT(S17,30)*VLOOKUP(B17&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q17>100,0,$Q17)/100),S17*VLOOKUP(B17&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q17>100,0,$Q17)/100)),2),0)","v":0},"","",{"$f":"IF(V17=\"\",\"\",IF(V17>0,ROUND(IF(MOD(V17,30)=0,QUOTIENT(V17,30)*VLOOKUP(B17&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U17>100,0,$U17)/100),V17*VLOOKUP(B17&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U17>100,0,$U17)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O18,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S18,30)=0,QUOTIENT(S18,30)*VLOOKUP(B18&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q18>100,0,$Q18)/100),S18*VLOOKUP(B18&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q18>100,0,$Q18)/100)),2),0)","v":0},"","",{"$f":"IF(V18=\"\",\"\",IF(V18>0,ROUND(IF(MOD(V18,30)=0,QUOTIENT(V18,30)*VLOOKUP(B18&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U18>100,0,$U18)/100),V18*VLOOKUP(B18&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U18>100,0,$U18)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O19,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S19,30)=0,QUOTIENT(S19,30)*VLOOKUP(B19&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q19>100,0,$Q19)/100),S19*VLOOKUP(B19&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q19>100,0,$Q19)/100)),2),0)","v":0},"","",{"$f":"IF(V19=\"\",\"\",IF(V19>0,ROUND(IF(MOD(V19,30)=0,QUOTIENT(V19,30)*VLOOKUP(B19&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U19>100,0,$U19)/100),V19*VLOOKUP(B19&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U19>100,0,$U19)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O20,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S20,30)=0,QUOTIENT(S20,30)*VLOOKUP(B20&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q20>100,0,$Q20)/100),S20*VLOOKUP(B20&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q20>100,0,$Q20)/100)),2),0)","v":0},"","",{"$f":"IF(V20=\"\",\"\",IF(V20>0,ROUND(IF(MOD(V20,30)=0,QUOTIENT(V20,30)*VLOOKUP(B20&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U20>100,0,$U20)/100),V20*VLOOKUP(B20&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U20>100,0,$U20)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O21,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S21,30)=0,QUOTIENT(S21,30)*VLOOKUP(B21&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q21>100,0,$Q21)/100),S21*VLOOKUP(B21&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q21>100,0,$Q21)/100)),2),0)","v":0},"","",{"$f":"IF(V21=\"\",\"\",IF(V21>0,ROUND(IF(MOD(V21,30)=0,QUOTIENT(V21,30)*VLOOKUP(B21&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U21>100,0,$U21)/100),V21*VLOOKUP(B21&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U21>100,0,$U21)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O22,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S22,30)=0,QUOTIENT(S22,30)*VLOOKUP(B22&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q22>100,0,$Q22)/100),S22*VLOOKUP(B22&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q22>100,0,$Q22)/100)),2),0)","v":0},"","",{"$f":"IF(V22=\"\",\"\",IF(V22>0,ROUND(IF(MOD(V22,30)=0,QUOTIENT(V22,30)*VLOOKUP(B22&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U22>100,0,$U22)/100),V22*VLOOKUP(B22&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U22>100,0,$U22)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","",{"$f":"IF(VALUE($A22)=0,\"\",IF(AQ$11=\"\",\"\",IF($N22<AQ$6,\"\",IF($M22>AQ$6,\"\",IF(AND(OR($N22=\"\",$N22>=AQ$6),$AA22=\"\",$R22<>\"\"),\"F\",IF(AND($AA22<=AQ$6,OR($AB22=$N22,$AB22>=AQ$6,IF($AB22=\"\",$AD$5))),\"h\",IF($CC22>=AQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A22)=0,\"\",IF(BA$11=\"\",\"\",IF($N22<BA$6,\"\",IF($M22>BA$6,\"\",IF(AND(OR($N22=\"\",$N22>=BA$6),$AA22=\"\",$R22<>\"\"),\"F\",IF(AND($AA22<=BA$6,OR($AB22=$N22,$AB22>=BA$6,IF($AB22=\"\",$AD$5))),\"h\",IF($CC22>=BA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A22)=0,\"\",IF(BK$11=\"\",\"\",IF($N22<BK$6,\"\",IF($M22>BK$6,\"\",IF(AND(OR($N22=\"\",$N22>=BK$6),$AA22=\"\",$R22<>\"\"),\"F\",IF(AND($AA22<=BK$6,OR($AB22=$N22,$AB22>=BK$6,IF($AB22=\"\",$AD$5))),\"h\",IF($CC22>=BK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O23,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S23,30)=0,QUOTIENT(S23,30)*VLOOKUP(B23&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q23>100,0,$Q23)/100),S23*VLOOKUP(B23&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q23>100,0,$Q23)/100)),2),0)","v":0},"","",{"$f":"IF(V23=\"\",\"\",IF(V23>0,ROUND(IF(MOD(V23,30)=0,QUOTIENT(V23,30)*VLOOKUP(B23&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U23>100,0,$U23)/100),V23*VLOOKUP(B23&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U23>100,0,$U23)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O24,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S24,30)=0,QUOTIENT(S24,30)*VLOOKUP(B24&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q24>100,0,$Q24)/100),S24*VLOOKUP(B24&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q24>100,0,$Q24)/100)),2),0)","v":0},"","",{"$f":"IF(V24=\"\",\"\",IF(V24>0,ROUND(IF(MOD(V24,30)=0,QUOTIENT(V24,30)*VLOOKUP(B24&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U24>100,0,$U24)/100),V24*VLOOKUP(B24&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U24>100,0,$U24)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O25,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S25,30)=0,QUOTIENT(S25,30)*VLOOKUP(B25&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q25>100,0,$Q25)/100),S25*VLOOKUP(B25&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q25>100,0,$Q25)/100)),2),0)","v":0},"","",{"$f":"IF(V25=\"\",\"\",IF(V25>0,ROUND(IF(MOD(V25,30)=0,QUOTIENT(V25,30)*VLOOKUP(B25&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U25>100,0,$U25)/100),V25*VLOOKUP(B25&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U25>100,0,$U25)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O26,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S26,30)=0,QUOTIENT(S26,30)*VLOOKUP(B26&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q26>100,0,$Q26)/100),S26*VLOOKUP(B26&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q26>100,0,$Q26)/100)),2),0)","v":0},"","",{"$f":"IF(V26=\"\",\"\",IF(V26>0,ROUND(IF(MOD(V26,30)=0,QUOTIENT(V26,30)*VLOOKUP(B26&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U26>100,0,$U26)/100),V26*VLOOKUP(B26&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U26>100,0,$U26)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O27,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S27,30)=0,QUOTIENT(S27,30)*VLOOKUP(B27&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q27>100,0,$Q27)/100),S27*VLOOKUP(B27&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q27>100,0,$Q27)/100)),2),0)","v":0},"","",{"$f":"IF(V27=\"\",\"\",IF(V27>0,ROUND(IF(MOD(V27,30)=0,QUOTIENT(V27,30)*VLOOKUP(B27&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U27>100,0,$U27)/100),V27*VLOOKUP(B27&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U27>100,0,$U27)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O28,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S28,30)=0,QUOTIENT(S28,30)*VLOOKUP(B28&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q28>100,0,$Q28)/100),S28*VLOOKUP(B28&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q28>100,0,$Q28)/100)),2),0)","v":0},"","",{"$f":"IF(V28=\"\",\"\",IF(V28>0,ROUND(IF(MOD(V28,30)=0,QUOTIENT(V28,30)*VLOOKUP(B28&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U28>100,0,$U28)/100),V28*VLOOKUP(B28&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U28>100,0,$U28)/100)),2),0))","v":""},"",null,null,"","","Si",null,"",{"$f":"IF($T28>0,\"X\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O29,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S29,30)=0,QUOTIENT(S29,30)*VLOOKUP(B29&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q29>100,0,$Q29)/100),S29*VLOOKUP(B29&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q29>100,0,$Q29)/100)),2),0)","v":0},"","",{"$f":"IF(V29=\"\",\"\",IF(V29>0,ROUND(IF(MOD(V29,30)=0,QUOTIENT(V29,30)*VLOOKUP(B29&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U29>100,0,$U29)/100),V29*VLOOKUP(B29&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U29>100,0,$U29)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,{"$f":"IFERROR(IF(AND(F29>0,G29>0),7,0),7)","v":0},""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O30,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S30,30)=0,QUOTIENT(S30,30)*VLOOKUP(B30&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q30>100,0,$Q30)/100),S30*VLOOKUP(B30&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q30>100,0,$Q30)/100)),2),0)","v":0},"","",{"$f":"IF(V30=\"\",\"\",IF(V30>0,ROUND(IF(MOD(V30,30)=0,QUOTIENT(V30,30)*VLOOKUP(B30&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U30>100,0,$U30)/100),V30*VLOOKUP(B30&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U30>100,0,$U30)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O31,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S31,30)=0,QUOTIENT(S31,30)*VLOOKUP(B31&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q31>100,0,$Q31)/100),S31*VLOOKUP(B31&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q31>100,0,$Q31)/100)),2),0)","v":0},"","",{"$f":"IF(V31=\"\",\"\",IF(V31>0,ROUND(IF(MOD(V31,30)=0,QUOTIENT(V31,30)*VLOOKUP(B31&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U31>100,0,$U31)/100),V31*VLOOKUP(B31&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U31>100,0,$U31)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O32,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S32,30)=0,QUOTIENT(S32,30)*VLOOKUP(B32&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q32>100,0,$Q32)/100),S32*VLOOKUP(B32&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q32>100,0,$Q32)/100)),2),0)","v":0},"","",{"$f":"IF(V32=\"\",\"\",IF(V32>0,ROUND(IF(MOD(V32,30)=0,QUOTIENT(V32,30)*VLOOKUP(B32&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U32>100,0,$U32)/100),V32*VLOOKUP(B32&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U32>100,0,$U32)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","",{"$f":"IF(VALUE($A32)=0,\"\",IF(AQ$11=\"\",\"\",IF($N32<AQ$6,\"\",IF($M32>AQ$6,\"\",IF(AND(OR($N32=\"\",$N32>=AQ$6),$AA32=\"\",$R32<>\"\"),\"F\",IF(AND($AA32<=AQ$6,OR($AB32=$N32,$AB32>=AQ$6,IF($AB32=\"\",$AD$5))),\"h\",IF($CC32>=AQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A32)=0,\"\",IF(BA$11=\"\",\"\",IF($N32<BA$6,\"\",IF($M32>BA$6,\"\",IF(AND(OR($N32=\"\",$N32>=BA$6),$AA32=\"\",$R32<>\"\"),\"F\",IF(AND($AA32<=BA$6,OR($AB32=$N32,$AB32>=BA$6,IF($AB32=\"\",$AD$5))),\"h\",IF($CC32>=BA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A32)=0,\"\",IF(BK$11=\"\",\"\",IF($N32<BK$6,\"\",IF($M32>BK$6,\"\",IF(AND(OR($N32=\"\",$N32>=BK$6),$AA32=\"\",$R32<>\"\"),\"F\",IF(AND($AA32<=BK$6,OR($AB32=$N32,$AB32>=BK$6,IF($AB32=\"\",$AD$5))),\"h\",IF($CC32>=BK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O33,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S33,30)=0,QUOTIENT(S33,30)*VLOOKUP(B33&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q33>100,0,$Q33)/100),S33*VLOOKUP(B33&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q33>100,0,$Q33)/100)),2),0)","v":0},"","",{"$f":"IF(V33=\"\",\"\",IF(V33>0,ROUND(IF(MOD(V33,30)=0,QUOTIENT(V33,30)*VLOOKUP(B33&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U33>100,0,$U33)/100),V33*VLOOKUP(B33&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U33>100,0,$U33)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O34,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S34,30)=0,QUOTIENT(S34,30)*VLOOKUP(B34&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q34>100,0,$Q34)/100),S34*VLOOKUP(B34&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q34>100,0,$Q34)/100)),2),0)","v":0},"","",{"$f":"IF(V34=\"\",\"\",IF(V34>0,ROUND(IF(MOD(V34,30)=0,QUOTIENT(V34,30)*VLOOKUP(B34&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U34>100,0,$U34)/100),V34*VLOOKUP(B34&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U34>100,0,$U34)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O35,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S35,30)=0,QUOTIENT(S35,30)*VLOOKUP(B35&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q35>100,0,$Q35)/100),S35*VLOOKUP(B35&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q35>100,0,$Q35)/100)),2),0)","v":0},"","",{"$f":"IF(V35=\"\",\"\",IF(V35>0,ROUND(IF(MOD(V35,30)=0,QUOTIENT(V35,30)*VLOOKUP(B35&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U35>100,0,$U35)/100),V35*VLOOKUP(B35&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U35>100,0,$U35)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O36,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S36,30)=0,QUOTIENT(S36,30)*VLOOKUP(B36&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q36>100,0,$Q36)/100),S36*VLOOKUP(B36&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q36>100,0,$Q36)/100)),2),0)","v":0},"","",{"$f":"IF(V36=\"\",\"\",IF(V36>0,ROUND(IF(MOD(V36,30)=0,QUOTIENT(V36,30)*VLOOKUP(B36&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U36>100,0,$U36)/100),V36*VLOOKUP(B36&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U36>100,0,$U36)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O37,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S37,30)=0,QUOTIENT(S37,30)*VLOOKUP(B37&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q37>100,0,$Q37)/100),S37*VLOOKUP(B37&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q37>100,0,$Q37)/100)),2),0)","v":0},"","",{"$f":"IF(V37=\"\",\"\",IF(V37>0,ROUND(IF(MOD(V37,30)=0,QUOTIENT(V37,30)*VLOOKUP(B37&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U37>100,0,$U37)/100),V37*VLOOKUP(B37&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U37>100,0,$U37)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O38,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S38,30)=0,QUOTIENT(S38,30)*VLOOKUP(B38&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q38>100,0,$Q38)/100),S38*VLOOKUP(B38&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q38>100,0,$Q38)/100)),2),0)","v":0},"","",{"$f":"IF(V38=\"\",\"\",IF(V38>0,ROUND(IF(MOD(V38,30)=0,QUOTIENT(V38,30)*VLOOKUP(B38&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U38>100,0,$U38)/100),V38*VLOOKUP(B38&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U38>100,0,$U38)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O39,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S39,30)=0,QUOTIENT(S39,30)*VLOOKUP(B39&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q39>100,0,$Q39)/100),S39*VLOOKUP(B39&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q39>100,0,$Q39)/100)),2),0)","v":0},"","",{"$f":"IF(V39=\"\",\"\",IF(V39>0,ROUND(IF(MOD(V39,30)=0,QUOTIENT(V39,30)*VLOOKUP(B39&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U39>100,0,$U39)/100),V39*VLOOKUP(B39&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U39>100,0,$U39)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O40,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S40,30)=0,QUOTIENT(S40,30)*VLOOKUP(B40&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q40>100,0,$Q40)/100),S40*VLOOKUP(B40&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q40>100,0,$Q40)/100)),2),0)","v":0},"","",{"$f":"IF(V40=\"\",\"\",IF(V40>0,ROUND(IF(MOD(V40,30)=0,QUOTIENT(V40,30)*VLOOKUP(B40&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U40>100,0,$U40)/100),V40*VLOOKUP(B40&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U40>100,0,$U40)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O41,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S41,30)=0,QUOTIENT(S41,30)*VLOOKUP(B41&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q41>100,0,$Q41)/100),S41*VLOOKUP(B41&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q41>100,0,$Q41)/100)),2),0)","v":0},"","",{"$f":"IF(V41=\"\",\"\",IF(V41>0,ROUND(IF(MOD(V41,30)=0,QUOTIENT(V41,30)*VLOOKUP(B41&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U41>100,0,$U41)/100),V41*VLOOKUP(B41&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U41>100,0,$U41)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","",{"$f":"IF(IFERROR(VLOOKUP(G41,$AD$12:$AD$60,1,FALSE),\"\")=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O42,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S42,30)=0,QUOTIENT(S42,30)*VLOOKUP(B42&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q42>100,0,$Q42)/100),S42*VLOOKUP(B42&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q42>100,0,$Q42)/100)),2),0)","v":0},"","",{"$f":"IF(V42=\"\",\"\",IF(V42>0,ROUND(IF(MOD(V42,30)=0,QUOTIENT(V42,30)*VLOOKUP(B42&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U42>100,0,$U42)/100),V42*VLOOKUP(B42&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U42>100,0,$U42)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","",{"$f":"IF(VALUE($A42)=0,\"\",IF(AQ$11=\"\",\"\",IF($N42<AQ$6,\"\",IF($M42>AQ$6,\"\",IF(AND(OR($N42=\"\",$N42>=AQ$6),$AA42=\"\",$R42<>\"\"),\"F\",IF(AND($AA42<=AQ$6,OR($AB42=$N42,$AB42>=AQ$6,IF($AB42=\"\",$AD$5))),\"h\",IF($CC42>=AQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A42)=0,\"\",IF(BA$11=\"\",\"\",IF($N42<BA$6,\"\",IF($M42>BA$6,\"\",IF(AND(OR($N42=\"\",$N42>=BA$6),$AA42=\"\",$R42<>\"\"),\"F\",IF(AND($AA42<=BA$6,OR($AB42=$N42,$AB42>=BA$6,IF($AB42=\"\",$AD$5))),\"h\",IF($CC42>=BA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A42)=0,\"\",IF(BK$11=\"\",\"\",IF($N42<BK$6,\"\",IF($M42>BK$6,\"\",IF(AND(OR($N42=\"\",$N42>=BK$6),$AA42=\"\",$R42<>\"\"),\"F\",IF(AND($AA42<=BK$6,OR($AB42=$N42,$AB42>=BK$6,IF($AB42=\"\",$AD$5))),\"h\",IF($CC42>=BK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O43,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S43,30)=0,QUOTIENT(S43,30)*VLOOKUP(B43&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q43>100,0,$Q43)/100),S43*VLOOKUP(B43&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q43>100,0,$Q43)/100)),2),0)","v":0},"","",{"$f":"IF(V43=\"\",\"\",IF(V43>0,ROUND(IF(MOD(V43,30)=0,QUOTIENT(V43,30)*VLOOKUP(B43&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U43>100,0,$U43)/100),V43*VLOOKUP(B43&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U43>100,0,$U43)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O44,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S44,30)=0,QUOTIENT(S44,30)*VLOOKUP(B44&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q44>100,0,$Q44)/100),S44*VLOOKUP(B44&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q44>100,0,$Q44)/100)),2),0)","v":0},"","",{"$f":"IF(V44=\"\",\"\",IF(V44>0,ROUND(IF(MOD(V44,30)=0,QUOTIENT(V44,30)*VLOOKUP(B44&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U44>100,0,$U44)/100),V44*VLOOKUP(B44&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U44>100,0,$U44)/100)),2),0))","v":""},"",null,null,{"$f":"IF(Z44=\"IT\",M44,IF(Z44=\"AT\",M44,\"\"))","v":""},{"$f":"IF(AND(AA44<>\"\",N44>0),N44,\"\")","v":""},"Si",null,"","","","","","","","","","","",{"$f":"IF(IFERROR(VLOOKUP(G44,$AD$12:$AD$60,1,FALSE),\"\")=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(Z44=\"IT\",Z44=\"AT\"),CG44+1-(CF44),0)","v":0},{"$f":"IF(Z44=\"AT\",1,IF(IF(Z44=\"IT\",CG44+1-(CF44),0)>15,15,IF(Z44=\"IT\",CG44+1-(CF44),0)))","v":0},{"$f":"IF(Z44=\"IT\",IF(BX44-BW44>15,15,BX44-BW44),IF(Z44=\"AT\",IF(BX44-BW44>1,1,BX44-BW44),0))","v":0},{"$f":"IF(OR(AC44=\"SI\",$CA$8=\"SI\"),BY44-BZ44,IF(AND(AC44<>\"SI\",OR($CA$8=\"NON\",$CA$8=\"<<>>\")),IF(BZ44<=3,IF(BY44-BZ44-3<=0,IF(Z44=\"AT\",IF(BZ44=1,0,1),0),BY44-BZ44-(3-BZ44)),BY44-BZ44),0))","v":0},{"$f":"IF(M44<$T$8,$T$8,M44)","v":"2023-07-01"},{"$f":"IF(N44=\"\",$AD$5,N44)","v":"2023-07-31"},{"$f":"IF(BV44+CE44>30,30,IF(AND(MONTH($H$7)=2,BV44>=DAY($AD$5),OR(AA44=\"\",AA44<=$H$7)),30,IF(BV44+CA44>30,30,BV44+CA44)))","v":0},0,{"$f":"IF(Z44=\"at\",IF(CH44<$AA$7,CH44,IF(CH44<$T$8,$T$8-1,CH44)),CI44)","v":"2023-01-01"},{"$f":"IF(OR(AB44=\"\",AB44>$AD$5),IF(N44=\"\",$AD$5,IF(N44>$AD$5,$AD$5,N44)),AB44)","v":"2023-07-31"},{"$f":"IF(Z44=\"AT\",CI44,0)","v":"00:00:00"},{"$f":"IF(IF(AA44=\"\",0,AA44)+3=3,VALUE(1&\"-\"&1&\"-\"&$AD$7),AA44)","v":"2023-01-01"},0,{"$f":"IF(OR(Z44=\"IT\",Z44=\"AT\"),IF(CF44<CB44,CB44-(CF44),0),0)","v":0},{"$f":"IF(OR(Z44=\"IT\",Z44=\"AT\"),CG44+1-(CF44),0)","v":0},{"$f":"IF(OR(Z44=\"IT\",Z44=\"AT\"),IF(CK44>=15,12,IF(CK44<15,CK44,CK44-3)),0)","v":0},{"$f":"IF(AND(Z44=\"AT\",CL44-CJ44=0),1,IF(Z44=\"IT\",CU44,0))","v":0},{"$f":"IF(M44<VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AD$5)<$AD$7,YEAR($AD$5),$AD$7)),VALUE(1&\"-\"&1&\"-\"&IF(YEAR($AD$5)<$AD$7,YEAR($AD$5),$AD$7)),M44)","v":"2023-01-01"},{"$f":"IF(N44=\"\",0,(DAYS360(CO44,N44)+1)/30*2.5)","v":0},{"$f":"IF(CM44>=3,3,CM44)","v":0},{"$f":"IF(OR($CT$8=\"SI\",$AC44=\"SI\"),CQ44,3-CQ44)","v":0},{"$f":"IF(CK44>15,IF(OR($CT$8=\"SI\",$AC44=\"SI\"),15,12),IF(OR($CT$8=\"SI\",$AC44=\"SI\"),CK44,CK44-CQ44))","v":0},{"$f":"IF(CL44-CR44-CQ44<0,0,IF(CL44-CR44-CQ44>12,IF(OR($CT$8=\"SI\",$AC44=\"SI\"),15,12),IF(CL44-CR44-CQ44>BW44,BW44-CR44,CL44-CR44-CQ44)))","v":0},{"$f":"IF(CT44-CS44>=IF(OR($CT$8=\"SI\",$AC44=\"SI\"),15,12),IF(OR($CT$8=\"SI\",$AC44=\"SI\"),15,12),CT44-CS44)","v":0},{"$f":"CW44&CX44&IF(OR(O44=510,O44=410),\"INT\",\"\")","v":"AA"},{"$f":"IF(YEAR(M44)<YEAR($H$7),\"A\",IF(YEAR(M44)=YEAR($H$7),IF(MONTH(M44)<=MONTH($H$7),\"A\",\"NO\")))","v":"A"},{"$f":"IF(N44=\"\",\"A\",IF(YEAR(N44)>YEAR($H$7),\"A\",IF(YEAR(N44)=YEAR($H$7),IF(MONTH(N44)>MONTH($H$7),\"A\",IF(MONTH(N44)=MONTH($H$7),\"L\",\"B\")))))","v":"A"},{"$f":"IFERROR(IF(L44<33,\"NO\",IF(OR(CV44=\"AA\",CV44=\"AL\"),\"SI\",IF(OR(CV44=\"AAINT\",CV44=\"ALINT\"),\"SI\"))),\"\")","v":"NO"},5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O45,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S45,30)=0,QUOTIENT(S45,30)*VLOOKUP(B45&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q45>100,0,$Q45)/100),S45*VLOOKUP(B45&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q45>100,0,$Q45)/100)),2),0)","v":0},"","",{"$f":"IF(V45=\"\",\"\",IF(V45>0,ROUND(IF(MOD(V45,30)=0,QUOTIENT(V45,30)*VLOOKUP(B45&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U45>100,0,$U45)/100),V45*VLOOKUP(B45&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U45>100,0,$U45)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O46,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S46,30)=0,QUOTIENT(S46,30)*VLOOKUP(B46&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q46>100,0,$Q46)/100),S46*VLOOKUP(B46&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q46>100,0,$Q46)/100)),2),0)","v":0},"","",{"$f":"IF(V46=\"\",\"\",IF(V46>0,ROUND(IF(MOD(V46,30)=0,QUOTIENT(V46,30)*VLOOKUP(B46&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U46>100,0,$U46)/100),V46*VLOOKUP(B46&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U46>100,0,$U46)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O47,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S47,30)=0,QUOTIENT(S47,30)*VLOOKUP(B47&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q47>100,0,$Q47)/100),S47*VLOOKUP(B47&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q47>100,0,$Q47)/100)),2),0)","v":0},"","",{"$f":"IF(V47=\"\",\"\",IF(V47>0,ROUND(IF(MOD(V47,30)=0,QUOTIENT(V47,30)*VLOOKUP(B47&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U47>100,0,$U47)/100),V47*VLOOKUP(B47&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U47>100,0,$U47)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O48,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S48,30)=0,QUOTIENT(S48,30)*VLOOKUP(B48&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q48>100,0,$Q48)/100),S48*VLOOKUP(B48&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q48>100,0,$Q48)/100)),2),0)","v":0},"","",{"$f":"IF(V48=\"\",\"\",IF(V48>0,ROUND(IF(MOD(V48,30)=0,QUOTIENT(V48,30)*VLOOKUP(B48&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U48>100,0,$U48)/100),V48*VLOOKUP(B48&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U48>100,0,$U48)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O49,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S49,30)=0,QUOTIENT(S49,30)*VLOOKUP(B49&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q49>100,0,$Q49)/100),S49*VLOOKUP(B49&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q49>100,0,$Q49)/100)),2),0)","v":0},"","",{"$f":"IF(V49=\"\",\"\",IF(V49>0,ROUND(IF(MOD(V49,30)=0,QUOTIENT(V49,30)*VLOOKUP(B49&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U49>100,0,$U49)/100),V49*VLOOKUP(B49&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U49>100,0,$U49)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O50,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S50,30)=0,QUOTIENT(S50,30)*VLOOKUP(B50&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q50>100,0,$Q50)/100),S50*VLOOKUP(B50&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q50>100,0,$Q50)/100)),2),0)","v":0},"","",{"$f":"IF(V50=\"\",\"\",IF(V50>0,ROUND(IF(MOD(V50,30)=0,QUOTIENT(V50,30)*VLOOKUP(B50&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U50>100,0,$U50)/100),V50*VLOOKUP(B50&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U50>100,0,$U50)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O51,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S51,30)=0,QUOTIENT(S51,30)*VLOOKUP(B51&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q51>100,0,$Q51)/100),S51*VLOOKUP(B51&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q51>100,0,$Q51)/100)),2),0)","v":0},"","",{"$f":"IF(V51=\"\",\"\",IF(V51>0,ROUND(IF(MOD(V51,30)=0,QUOTIENT(V51,30)*VLOOKUP(B51&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U51>100,0,$U51)/100),V51*VLOOKUP(B51&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U51>100,0,$U51)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","",{"$f":"IF(IFERROR(VLOOKUP(G51,$AD$12:$AD$60,1,FALSE),\"\")=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O52,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S52,30)=0,QUOTIENT(S52,30)*VLOOKUP(B52&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q52>100,0,$Q52)/100),S52*VLOOKUP(B52&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q52>100,0,$Q52)/100)),2),0)","v":0},"","",{"$f":"IF(V52=\"\",\"\",IF(V52>0,ROUND(IF(MOD(V52,30)=0,QUOTIENT(V52,30)*VLOOKUP(B52&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U52>100,0,$U52)/100),V52*VLOOKUP(B52&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U52>100,0,$U52)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","",{"$f":"IF(VALUE($A52)=0,\"\",IF(AQ$11=\"\",\"\",IF($N52<AQ$6,\"\",IF($M52>AQ$6,\"\",IF(AND(OR($N52=\"\",$N52>=AQ$6),$AA52=\"\",$R52<>\"\"),\"F\",IF(AND($AA52<=AQ$6,OR($AB52=$N52,$AB52>=AQ$6,IF($AB52=\"\",$AD$5))),\"h\",IF($CC52>=AQ$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A52)=0,\"\",IF(BA$11=\"\",\"\",IF($N52<BA$6,\"\",IF($M52>BA$6,\"\",IF(AND(OR($N52=\"\",$N52>=BA$6),$AA52=\"\",$R52<>\"\"),\"F\",IF(AND($AA52<=BA$6,OR($AB52=$N52,$AB52>=BA$6,IF($AB52=\"\",$AD$5))),\"h\",IF($CC52>=BA$6,\"F\",\"\")))))))","v":""},"","","","","","","","","",{"$f":"IF(VALUE($A52)=0,\"\",IF(BK$11=\"\",\"\",IF($N52<BK$6,\"\",IF($M52>BK$6,\"\",IF(AND(OR($N52=\"\",$N52>=BK$6),$AA52=\"\",$R52<>\"\"),\"F\",IF(AND($AA52<=BK$6,OR($AB52=$N52,$AB52>=BK$6,IF($AB52=\"\",$AD$5))),\"h\",IF($CC52>=BK$6,\"F\",\"\")))))))","v":""},"","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O53,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S53,30)=0,QUOTIENT(S53,30)*VLOOKUP(B53&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q53>100,0,$Q53)/100),S53*VLOOKUP(B53&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q53>100,0,$Q53)/100)),2),0)","v":0},"","",{"$f":"IF(V53=\"\",\"\",IF(V53>0,ROUND(IF(MOD(V53,30)=0,QUOTIENT(V53,30)*VLOOKUP(B53&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U53>100,0,$U53)/100),V53*VLOOKUP(B53&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U53>100,0,$U53)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","",{"$f":"IF($T53>0,\"X\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O54,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S54,30)=0,QUOTIENT(S54,30)*VLOOKUP(B54&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q54>100,0,$Q54)/100),S54*VLOOKUP(B54&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q54>100,0,$Q54)/100)),2),0)","v":0},"","",{"$f":"IF(V54=\"\",\"\",IF(V54>0,ROUND(IF(MOD(V54,30)=0,QUOTIENT(V54,30)*VLOOKUP(B54&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U54>100,0,$U54)/100),V54*VLOOKUP(B54&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U54>100,0,$U54)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O55,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S55,30)=0,QUOTIENT(S55,30)*VLOOKUP(B55&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q55>100,0,$Q55)/100),S55*VLOOKUP(B55&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q55>100,0,$Q55)/100)),2),0)","v":0},"","",{"$f":"IF(V55=\"\",\"\",IF(V55>0,ROUND(IF(MOD(V55,30)=0,QUOTIENT(V55,30)*VLOOKUP(B55&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U55>100,0,$U55)/100),V55*VLOOKUP(B55&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U55>100,0,$U55)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O56,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S56,30)=0,QUOTIENT(S56,30)*VLOOKUP(B56&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q56>100,0,$Q56)/100),S56*VLOOKUP(B56&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q56>100,0,$Q56)/100)),2),0)","v":0},"","",{"$f":"IF(V56=\"\",\"\",IF(V56>0,ROUND(IF(MOD(V56,30)=0,QUOTIENT(V56,30)*VLOOKUP(B56&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U56>100,0,$U56)/100),V56*VLOOKUP(B56&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U56>100,0,$U56)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O57,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S57,30)=0,QUOTIENT(S57,30)*VLOOKUP(B57&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q57>100,0,$Q57)/100),S57*VLOOKUP(B57&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q57>100,0,$Q57)/100)),2),0)","v":0},"","",{"$f":"IF(V57=\"\",\"\",IF(V57>0,ROUND(IF(MOD(V57,30)=0,QUOTIENT(V57,30)*VLOOKUP(B57&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U57>100,0,$U57)/100),V57*VLOOKUP(B57&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U57>100,0,$U57)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O58,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S58,30)=0,QUOTIENT(S58,30)*VLOOKUP(B58&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q58>100,0,$Q58)/100),S58*VLOOKUP(B58&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q58>100,0,$Q58)/100)),2),0)","v":0},"","",{"$f":"IF(V58=\"\",\"\",IF(V58>0,ROUND(IF(MOD(V58,30)=0,QUOTIENT(V58,30)*VLOOKUP(B58&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U58>100,0,$U58)/100),V58*VLOOKUP(B58&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U58>100,0,$U58)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O59,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S59,30)=0,QUOTIENT(S59,30)*VLOOKUP(B59&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q59>100,0,$Q59)/100),S59*VLOOKUP(B59&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q59>100,0,$Q59)/100)),2),0)","v":0},"","",{"$f":"IF(V59=\"\",\"\",IF(V59>0,ROUND(IF(MOD(V59,30)=0,QUOTIENT(V59,30)*VLOOKUP(B59&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U59>100,0,$U59)/100),V59*VLOOKUP(B59&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U59>100,0,$U59)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[null,"","",null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(VLOOKUP(O60,Importes!K:P,2,FALSE),\"\")","v":""},null,"AM+E",0,{"$f":"IFERROR(ROUND(IF(MOD(S60,30)=0,QUOTIENT(S60,30)*VLOOKUP(B60&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($Q60>100,0,$Q60)/100),S60*VLOOKUP(B60&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($Q60>100,0,$Q60)/100)),2),0)","v":0},"","",{"$f":"IF(V60=\"\",\"\",IF(V60>0,ROUND(IF(MOD(V60,30)=0,QUOTIENT(V60,30)*VLOOKUP(B60&\"AM+E\",Importes!$A$2:$F$14,6,FALSE)*(IF($U60>100,0,$U60)/100),V60*VLOOKUP(B60&\"AM+E\",Importes!$A$2:$F$14,5,FALSE)*(IF($U60>100,0,$U60)/100)),2),0))","v":""},"",null,null,"","","Si",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,0,0,0,0,"2023-07-01","2023-07-31",0,0,"2023-01-01","2023-07-31","00:00:00","2023-01-01",0,0,0,0,0,"2023-01-01",0,0,0,0,0,0,"AA","A","A","NO",5,0,""]
[]
[null,null,null,null,null,null,"Lugar e data:"]
[null,null,null,null,null,null,"SINATURA DA PERSOA REPRESENTANTE"]

{"sheet":"Importes","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Códigos",null,"SMI 2018",{"$f":"H1/30","v":36},{"$f":"D1/12*2","v":6},"Achega/mes","SMI 2019",1080,null,null,"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":21},{"$f":"ROUND(D2*$H$1+$I$2*D2,2)","v":630},null,"Prorrata 2PE",{"$f":"H1/12*2","v":180},null,100,{"$f":"IF(M2=\"Indefinido\",\"Ind\",\"Temp\")","v":"Ind"},"Indefinido","TIEMPO COMPLETO","ORDINARIO"]
["0AM",0,"AM",0.5,{"$f":"ROUND(D3*$D$1,2)","v":18},{"$f":"ROUND(D3*$H$1,2)","v":540},null,null,null,null,109,{"$f":"IF(M3=\"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,null,130,"Ind","Indefinido","TIEMPO COMPLETO","MINUSVÁLIDOS"]
[{"$f":"B5&C5","v":"0CP"},0,"CP",{"$f":"0.5/6","v":0.08},{"$f":"ROUND(D5*$D$1,2)","v":2.88},{"$f":"ROUND(D5*$H$1,2)","v":86.4},null,null,null,null,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":18},{"$f":"ROUND(D6*$H$1,2)","v":540},null,null,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},18,540,null,null,null,null,189,"Ind","Indefinido","TIEMPO COMPLETO",null,"TRANSFORMACIÓN CONTRATO Temporal"]
[null,null,null,null,null,null,null,null,null,null,200,"Ind","Indefinido","TIEMPO PARCIAL","ORDINARIO"]
["1AM+E",1,"AM+E",0.6,{"$f":"ROUND(D9*$D$1+$E$1*D9,2)","v":25.2},{"$f":"ROUND(D9*$H$1+$I$2*D9,2)","v":756},null,null,null,null,209,"Ind","Indefinido","TIEMPO PARCIAL","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","TRANSFORMACIÓN CONTRATO Temporal"]
["1AM",1,"AM",0.6,{"$f":"ROUND(D10*$D$1,2)","v":21.6},{"$f":"ROUND(D10*$H$1,2)","v":648},null,null,null,null,230,"Ind","Indefinido","TIEMPO PARCIAL","MINUSVÁLIDOS"]
[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.6/6","v":0.1},{"$f":"ROUND(D12*$D$1,2)","v":3.6},{"$f":"ROUND(D12*$H$1,2)","v":108},null,null,null,null,250,"Ind","Indefinido","TIEMPO PARCIAL","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","INICIAL"]
["1CV",1,"CV",0.6,{"$f":"ROUND(D13*$D$1,2)","v":21.6},{"$f":"ROUND(D13*$H$1,2)","v":648},null,null,null,null,289,"Ind","Indefinido","TIEMPO PARCIAL",null,"TRANSFORMACIÓN CONTRATO Temporal"]
["1CV+E",1,"CV+E",0.6,{"$f":"ROUND(D14*$D$1+$E$1*D14,2)","v":25.2},{"$f":"ROUND(D14*$H$1+$I$2*D14,2)","v":756},null,null,null,null,300,"Ind","Indefinido","FIJO/DISCONTINUO"]
[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,330,"Ind","Indefinido","FIJO/DISCONTINUO","MINUSVÁLIDOS"]
["Pensionista",null,"minus",null,null,null,null,null,null,null,350,"Ind","Indefinido","FIJO/DISCONTINUO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE","INICIAL"]
["Definitiva",null,"Física",null,null,null,null,null,null,null,389,"Ind","Indefinido","FIJO/DISCONTINUO",null,"TRANSFORMACIÓN CONTRATO Temporal"]
["Provisional",null,"Sensorial",null,null,null,null,null,null,null,401,"Temp","Duración Determinada","TIEMPO COMPLETO","OBRA O SERVICIO DETERMINADO"]
[" ",null,"P. Cerebral",null,null,null,null,null,null,null,402,"Temp","Duración Determinada","TIEMPO COMPLETO","EVENTUAL POR CIRCUNSTANCIAS DE LA PRODUCCIÓN"]
["sexo",null,"Enf. Mental",null,null,null,null,null,null,null,403,"Temp","Duración Determinada","TIEMPO COMPLETO","INSERCIÓN"]
["H",null,"D. Intelectual",null,null,null,null,null,null,null,408,"Temp","Temporal","TIEMPO COMPLETO",null,"CARÁCTER ADMINISTRATIVO"]
["M",null,"Psíquica",null,null,null,null,null,null,null,410,"Temp","Duración Determinada","TIEMPO COMPLETO","INTERINIDAD"]
[null,null,null,null,null,null,null,null,null,null,418,"Temp","Duración Determinada","TIEMPO COMPLETO","INTERINIDAD","CARÁCTER ADMINISTRATIVO"]
[null,null,null,null,null,null,null,null,null,null,420,"Temp","Temporal","TIEMPO COMPLETO","PRÁCTICAS"]
["Conv",null,null,null,null,null,null,null,null,null,421,"Temp","Temporal","TIEMPO COMPLETO","FORMACIÓN"]
["Baixa",null,null,null,null,null,null,null,null,null,430,"Temp","Temporal","TIEMPO COMPLETO","MINUSVÁLIDOS"]
["Si",null,null,null,null,null,null,null,null,null,441,"Temp","Temporal","TIEMPO COMPLETO","RELEVO"]
["Non",null,null,null,null,null,null,null,null,null,450,"Temp","Temporal","TIEMPO COMPLETO","FOMENTO CONTRATACIÓN INDEFINIDA / EMPLEO ESTABLE"]
[null,null,null,null,null,null,null,null,null,null,501,"Temp","Duración Determinada","TIEMPO PARCIAL","OBRA O SERVICIO DETERMINADO"]
[null,"Mes",null,null,null,null,null,null,null,null,502,"Temp","Duración Determinada","TIEMPO PARCIAL","EVENTUAL POR CIRCUNSTANCIAS DE LA PRODUCCIÓN"]
[null,7,"Xullo",null,null,null,null,null,null,null,503,"Temp","Duración Determinada","TIEMPO PARCIAL","INSERCIÓN"]
[null,8,"Agosto",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,510,"Temp","Duración Determinada","TIEMPO PARCIAL","INTERINIDAD"]
[null,10,"Outubro",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,520,"Temp","Temporal","TIEMPO PARCIAL","PRÁCTICAS"]
[null,12,"Decembro",null,null,null,null,null,null,null,530,"Temp","Temporal","TIEMPO PARCIAL","MINUSVÁLIDOS"]
[null,1,"Xaneiro",null,null,null,null,null,null,null,540,"Temp","Temporal","TIEMPO PARCIAL","JUBILADO PARCIAL"]
[null,2,"Febreiro",null,null,null,null,null,null,null,541,"Temp","Temporal","TIEMPO PARCIAL","RELEVO"]
[null,3,"Marzo ",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,5,"Maio"]
[null,6,"Xuño"]

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

{"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"]