{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ocupació certificació","Codis TGSS"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":3,"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":"Ocupació certificació","index":0,"n_rows":95,"n_cols":17,"rows_kept":95,"cut":false,"hidden":false,"merged":[[45,8,45,13],[18,9,18,11],[22,1,22,13],[29,1,29,13],[36,1,36,13],[24,1,24,3],[25,1,25,3],[26,1,26,3],[32,1,32,3],[33,1,33,3],[39,1,39,3],[40,1,40,3],[20,6,20,11],[43,8,43,13],[0,0,0,14],[31,1,31,3],[38,1,38,3],[2,1,2,2],[8,1,10,3],[2,3,2,8],[6,9,6,11],[6,6,6,8],[4,3,4,13],[6,13,7,13],[11,1,13,3],[14,1,16,3]]}
["OCUPACIÓ ACTUAL - FASE DE APROVACIÓ"]
[]
[null,"CONVOCATÒRIA:",null,"Any 2022  -  RESOLUCIÓ ACC/1894/2022, de 13 de juny",null,null,null,null,null,null,null,"Nº EXPEDIENT:"]
[]
[null,null,"NOM O RAÓ SOCIAL:"]
[]
[null,null,null,null,null,null,"HOMES",null,null,"DONES",null,null,null,"TOTAL"]
[null,null,null,null,null,null,"< o = 40 anys",null,"> 40 anys","< o = 40 anys",null,"> 40 anys"]
[null,"Llocs de treball consolidats",null,null,"Fixes",null,{"$f":"SUMIF($M$26:$M$28,\"HF<40\",$L$26:$L$28)","v":0},null,{"$f":"SUMIF($M$26:$M$28,\"HF>40\",$L$26:$L$28)","v":0},{"$f":"SUMIF($M$26:$M$28,\"DF<40\",$L$26:$L$28)","v":0},null,{"$f":"SUMIF($M$26:$M$28,\"DF>40\",$L$26:$L$28)","v":0},null,{"$f":"SUM(G9:L9)","v":0}]
[null,null,null,null,"Temporals",null,{"$f":"SUMIF($M$26:$M$28,\"HT<40\",$L$26:$L$28)","v":0},null,{"$f":"SUMIF($M$26:$M$28,\"HT>40\",$L$26:$L$28)","v":0},{"$f":"SUMIF($M$26:$M$28,\"DT<40\",$L$26:$L$28)","v":0},null,{"$f":"SUMIF($M$26:$M$28,\"DT>40\",$L$26:$L$28)","v":0},null,{"$f":"SUM(G10:L10)","v":0}]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G9:G10)","v":0},null,{"$f":"SUM(I9:I10)","v":0},{"$f":"SUM(J9:J10)","v":0},null,{"$f":"SUM(L9:L10)","v":0},null,0]
[null,"Llocs de treball creats",null,null,"Fixes",null,{"$f":"SUMIF($M$33:$M$35,\"HF<40\",$L$33:$L$35)","v":0},null,{"$f":"SUMIF($M$33:$M$35,\"HF>40\",$L$33:$L$35)","v":0},{"$f":"SUMIF($M$33:$M$35,\"DF<40\",$L$33:$L$33)","v":0},null,{"$f":"SUMIF($M$33:$M$35,\"DF>40\",$L$33:$L$35)","v":0},null,0]
[null,null,null,null,"Temporals",null,{"$f":"SUMIF($M$33:$M$35,\"HT<40\",$L$33:$L$35)","v":0},null,{"$f":"SUMIF($M$33:$M$35,\"HT>40\",$L$33:$L$35)","v":0},{"$f":"SUMIF($M$33:$M$35,\"DT<40\",$L$33:$L$35)","v":0},null,{"$f":"SUMIF($M$33:$M$35,\"DT>40\",$L$33:$L$35)","v":0},null,0]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G12:G13)","v":0},null,{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:J13)","v":0},null,{"$f":"SUM(L12:L13)","v":0},null,0]
[null,"Llocs de treball conjunturals\n(no computen a efectes de l'ajut)",null,null,"Fixes",null,{"$f":"SUMIF($M$40:$M$42,\"HF<40\",$L$40:$L$42)","v":0},null,{"$f":"SUMIF($M$40:$M$42,\"HF>40\",$L$40:$L$42)","v":0},{"$f":"SUMIF($M$40:$M$42,\"DF<40\",$L$40:$L$42)","v":0},null,{"$f":"SUMIF($M$40:$M$42,\"DF>40\",$L$40:$L$42)","v":0},null,0]
[null,null,null,null,"Temporals",null,{"$f":"SUMIF($M$40:$M$42,\"HT<40\",$P$40:$P$42)","v":0},null,{"$f":"SUMIF($M$40:$M$42,\"HT>40\",$L$40:$L$42)","v":0},{"$f":"SUMIF($M$40:$M$42,\"DT<40\",$L$40:$L$42)","v":0},null,{"$f":"SUMIF($M$40:$M$42,\"DT>40\",$L$40:$L$42)","v":0},null,0]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},{"$f":"SUM(J15:J16)","v":0},null,{"$f":"SUM(L15:L16)","v":0},null,0]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL LLOCS DE TREBALL",null,null,null,{"$f":"N14+N11+N17","v":0}]
[]
[null,null,null,null,null,null,"CREACIÓ D'OCUPACIÓ PRIORITÀRIA (VALORACIÓ GAL)",null,null,null,null,null,null,{"$f":"COUNTIFS(P33:P35,\"S\",K33:K35,\"F\")+0.5*COUNTIFS(P33:P35,\"S\",K33:K35,\"T\")","v":0}]
[]
[null,"Llocs de treball consolidats 1"]
[]
[null,"TREBALLADORA / TREBALLADOR\n(Nom i cognoms)",null,null,"DATA DE NAIXEMENT",null,"GÈNERE",null,"DATA DE CONTRACTACIÓ","TIPUS DE CONTRACTE\n(codi TGSS)",null,"% DE JORNADA",null,"GRAU DE MINUSVALIA\n(si s'escau)"]
["x",null,null,null,null,{"$f":"IF((TODAY()-E26)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(G26=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(J26=\"RETA Associat\",\"F\",IF(J26=\"RETA Fix\",\"F\",IF(J26<400,\"F\",\"T\")))","v":"F"},null,{"$f":"IF(L26=0,\"X\",IF(J26=\"RETA Fix\",IF(L26<0.75,0,CONCATENATE(H26,K26,F26)),IF(J26=\"RETA Temporal\",IF(L26<0.75,0,CONCATENATE(H26,K26,F26)),CONCATENATE(H26,K26,F26))))","v":"X"},null,null,{"$f":"IF(F26=\"<40\",\"S\",IF(H26=\"D\",\"S\",IF(N26>=33,\"S\",\"N\")))","v":"N"},{"$f":"IF(M26=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
["x",null,null,null,null,{"$f":"IF((TODAY()-E27)>14600,\">40\",\"<40\")","v":">40"},null,"H",null,null,"F",null,"X",null,null,null,{"$f":"IF(M27=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
[]
[]
[null,"Llocs de treball creats 2"]
[]
[null,"TREBALLADORA / TREBALLADOR\n(Nom i cognoms)",null,null,"DATA DE NAIXEMENT",null,"GÈNERE",null,"DATA DE CONTRACTACIÓ","TIPUS DE CONTRACTE\n(codi TGSS)",null,"% DE JORNADA",null,"GRAU DE MINUSVALIA\n(si s'escau)",null,"PRIORITÀRIA?"]
["y",null,null,null,null,{"$f":"IF((TODAY()-E33)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(G33=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(J33=\"RETA Associat\",\"F\",IF(J33=\"RETA Fix\",\"F\",IF(J33<400,\"F\",\"T\")))","v":"F"},null,{"$f":"IF(L33=0,\"X\",IF(J33=\"RETA Fix\",IF(L33<0.75,0,CONCATENATE(H33,K33,F33)),IF(J33=\"RETA Temporal\",IF(L33<0.75,0,CONCATENATE(H33,K33,F33)),CONCATENATE(H33,K33,F33))))","v":"X"},null,null,{"$f":"IF(F33=\"<40\",\"S\",IF(H33=\"D\",\"S\",IF(N33>=33,\"S\",\"N\")))","v":"N"},{"$f":"IF(M33=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
["y",null,null,null,null,{"$f":"IF((TODAY()-E34)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(G34=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(J34=\"RETA Associat\",\"F\",IF(J34=\"RETA Fix\",\"F\",IF(J34<400,\"F\",\"T\")))","v":"F"},null,{"$f":"IF(L34=0,\"X\",IF(J34=\"RETA Fix\",IF(L34<0.75,0,CONCATENATE(H34,K34,F34)),IF(J34=\"RETA Temporal\",IF(L34<0.75,0,CONCATENATE(H34,K34,F34)),CONCATENATE(H34,K34,F34))))","v":"X"},null,null,{"$f":"IF(F34=\"<40\",\"S\",IF(H34=\"D\",\"S\",IF(N34>=33,\"S\",\"N\")))","v":"N"},{"$f":"IF(M34=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
[]
[]
[null,"Llocs de treball conjunturals 3"]
[]
[null,"TREBALLADORA / TREBALLADOR\n(Nom i cognoms)",null,null,"DATA DE NAIXEMENT",null,"GÈNERE",null,"DATA DE CONTRACTACIÓ","TIPUS DE CONTRACTE\n(codi TGSS)",null,"% DE JORNADA",null,"GRAU DE MINUSVALIA\n(si s'escau)"]
["z",null,null,null,null,{"$f":"IF((TODAY()-E40)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(G40=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(J40=\"RETA Associat\",\"F\",IF(J40=\"RETA Fix\",\"F\",IF(J40<400,\"F\",\"T\")))","v":"F"},null,{"$f":"IF(L40=0,\"X\",IF(J40=\"RETA Fix\",IF(L40<0.75,0,CONCATENATE(H40,K40,F40)),IF(J40=\"RETA Temporal\",IF(L40<0.75,0,CONCATENATE(H40,K40,F40)),CONCATENATE(H40,K40,F40))))","v":"X"},null,null,null,{"$f":"IF(M40=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
["z",null,null,null,null,">40",null,{"$f":"IF(G41=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(J41=\"RETA Associat\",\"F\",IF(J41=\"RETA Fix\",\"F\",IF(J41<400,\"F\",\"T\")))","v":"F"},null,{"$f":"IF(L41=0,\"X\",IF(J41=\"RETA Fix\",IF(L41<0.75,0,CONCATENATE(H41,K41,F41)),IF(J41=\"RETA Temporal\",IF(L41<0.75,0,CONCATENATE(H41,K41,F41)),CONCATENATE(H41,K41,F41))))","v":"X"},null,null,null,{"$f":"IF(M41=0,\"Només es tindran en compte els autònoms econòmicament dependents (≥75% jornada)\",0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"SIGNATURA ELECTRÒNICA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DATA:",null,{"$f":"TODAY()","v":"2022-07-19"}]
[]
[]
[null,null,null,null,null,null,null,"Home",null,null,100,null,{"$f":"TODAY()","v":"2022-07-19"}]
[null,null,null,null,null,null,null,"Dona",null,null,109]
[null,null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,null,null,null,189]
[null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,209]
[null,null,null,null,null,null,null,null,null,null,230]
[null,null,null,null,null,null,null,null,null,null,239]
[null,null,null,null,null,null,null,null,null,null,250]
[null,null,null,null,null,null,null,null,null,null,289]
[null,null,null,null,null,null,null,null,null,null,300]
[null,null,null,null,null,null,null,null,null,null,309]
[null,null,null,null,null,null,null,null,null,null,330]
[null,null,null,null,null,null,null,null,null,null,339]
[null,null,null,null,null,null,null,null,null,null,350]
[null,null,null,null,null,null,null,null,null,null,389]
[null,null,null,null,null,null,null,null,null,null,401]
[null,null,null,null,null,null,null,null,null,null,402]
[null,null,null,null,null,null,null,null,null,null,403]
[null,null,null,null,null,null,null,null,null,null,408]
[null,null,null,null,null,null,null,null,null,null,410]
[null,null,null,null,null,null,null,null,null,null,418]
[null,null,null,null,null,null,null,null,null,null,420]
[null,null,null,null,null,null,null,null,null,null,421]
[null,null,null,null,null,null,null,null,null,null,430]
[null,null,null,null,null,null,null,null,null,null,441]
[null,null,null,null,null,null,null,null,null,null,450]
[null,null,null,null,null,null,null,null,null,null,452]
[null,null,null,null,null,null,null,null,null,null,501]
[null,null,null,null,null,null,null,null,null,null,502]
[null,null,null,null,null,null,null,null,null,null,503]
[null,null,null,null,null,null,null,null,null,null,508]
[null,null,null,null,null,null,null,null,null,null,510]
[null,null,null,null,null,null,null,null,null,null,518]
[null,null,null,null,null,null,null,null,null,null,520]
[null,null,null,null,null,null,null,null,null,null,530]
[null,null,null,null,null,null,null,null,null,null,540]
[null,null,null,null,null,null,null,null,null,null,541]
[null,null,null,null,null,null,null,null,null,null,550]
[null,null,null,null,null,null,null,null,null,null,552]
[null,null,null,null,null,null,null,null,null,null,"RETA Associat"]
[null,null,null,null,null,null,null,null,null,null,"RETA Fix"]
[null,null,null,null,null,null,null,null,null,null,"RETA Temporal"]

{"sheet":"Codis TGSS","index":1,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,3,48,3],[3,3,8,3],[0,1,0,3],[9,3,20,3],[21,3,32,3],[33,3,44,3]]}
[null,"CODIS DE CONTRACTES DE TREBALL TGSS"]
[]
[null,"CODI","DESCRIPCIÓ","COMENTARIS"]
[null,100,"INDEFINIT TEMPS COMPLET - ORDINARI","INDEFINIT TEMPS COMPLERT"]
[null,109,"INDEFINIT TEMPS COMPLET - FOMENT CONTRACTACIÓ INDEFINIDA / OCUPACIÓ ESTABLE TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,130,"INDEFINIT TEMPS COMPLET - DISCAPACITATS"]
[null,139,"INDEFINIT TEMPS COMPLET - DISCAPACITATS TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,150,"INDEFINIT TEMPS COMPLET - FOMENT CONTRACTACIÓ INDEFINIDA / OCUPACIÓ ESTABLE INICIAL"]
[null,189,"INDEFINIT TEMPS COMPLET - TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,200,"INDEFINIT TEMPS PARCIAL - ORDINARI","INDEFINITS TEMPS PARCIAL"]
[null,209,"INDEFINIT TEMPS PARCIAL - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,230,"INDEFINIT TEMPS PARCIAL - DISCAPACITATS"]
[null,239,"INDEFINIT TEMPS PARCIAL - DISCAPACITATS TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,250,"INDEFINIT TEMPS PARCIAL - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE INICIAL"]
[null,289,"INDEFINIT TEMPS PARCIAL - TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,300,"INDEFINIT FIX/DISCONTINU - ORDINARI"]
[null,309,"INDEFINIT FIX/DISCONTINU - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,330,"INDEFINIT FIX/DISCONTINU - DISCAPACITATS"]
[null,339,"INDEFINIT FIX/DISCONTINU - DISCAPACITATS TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,350,"INDEFINIT FIX/DISCONTINU - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE INICIAL"]
[null,389,"INDEFINIT FIX/DISCONTINU - TRANSFORMACIÓ CONTRACTE TEMPORAL"]
[null,401,"DURACIÓ DETERMINADA TEMPS COMPLET - OBRA O SERVEI DETERMINAT","TEMPORALS TEMPS COMPLERT"]
[null,402,"DURACIÓ DETERMINADA TEMPS COMPLET - EVENTUAL PER CIRCUMSTÀNCIES DE LA PRODUCCIÓ"]
[null,403,"DURACIÓ DETERMINADA TEMPS COMPLET - INSERCIÓ"]
[null,408,"DURACIÓ DETERMINADA TEMPS COMPLET - CARÀCTER ADMINISTRATIU"]
[null,410,"DURACIÓ DETERMINADA TEMPS COMPLET - INTERINITAT"]
[null,418,"DURACIÓ DETERMINADA TEMPS COMPLET - INTERINITAT CARÀCTER ADMINISTRATIU"]
[null,420,"DURACIÓ DETERMINADA TEMPS COMPLET - PRÀCTIQUES"]
[null,421,"DURACIÓ DETERMINADA TEMPS COMPLET - FORMACIÓ"]
[null,430,"DURACIÓ DETERMINADA TEMPS COMPLET - DISCAPACITATS"]
[null,441,"DURACIÓ DETERMINADA TEMPS COMPLET - RELLEU"]
[null,450,"DURACIÓ DETERMINADA TEMPS COMPLET - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE"]
[null,452,"DURACIÓ DETERMINADA TEMPS COMPLET - TREBALLADORS DESOCUPATS CONTRACTATS PER EMPRESES D'INSERCIÓ"]
[null,501,"DURACIÓ DETERMINADA TEMPS PARCIAL - OBRA O SERVEI DETERMINAT","TEMPORALS TEMPS PARCIAL"]
[null,502,"DURACIÓ DETERMINADA TEMPS PARCIAL - EVENTUAL PER CIRCUMSTÀNCIES DE LA PRODUCCIÓ"]
[null,503,"DURACIÓ DETERMINADA TEMPS PARCIAL - INSERCIÓ"]
[null,508,"DURACIÓ DETERMINADA TEMPS PARCIAL - CARÀCTER ADMINISTRATIU"]
[null,510,"DURACIÓ DETERMINADA TEMPS PARCIAL - INTERINITAT"]
[null,518,"DURACIÓ DETERMINADA TEMPS PARCIAL - INTERINITAT CARÀCTER ADMINISTRATIU"]
[null,520,"DURACIÓ DETERMINADA TEMPS PARCIAL - PRÀCTIQUES"]
[null,530,"DURACIÓ DETERMINADA TEMPS PARCIAL - DISCAPACITATS"]
[null,540,"DURACIÓ DETERMINADA TEMPS PARCIAL - JUBILACIÓ PARCIAL"]
[null,541,"DURACIÓ DETERMINADA TEMPS PARCIAL - RELLEU"]
[null,550,"DURACIÓ DETERMINADA TEMPS PARCIAL - FOMENT CONTRACTACIÓ INDEFINIDA/OCUPACIÓ ESTABLE"]
[null,552,"DURACIÓ DETERMINADA TEMPS PARCIAL - TREBALLADORS DESOCUPATS CONTRACTATS PER EMPRESES D'INSERCIÓ"]
[]
[null,"RETA Associat","RÈGIM ESPECIAL DE TREBALLADORS AUTÒNOMS - Persona sòcia de l'empresa donada d'alta en el RETA.","AUTÒNOMS/ES"]
[null,"RETA Fix","RÈGIM ESPECIAL DE TREBALLADORS AUTÒNOMS - Relació indefinida amb l'empresa"]
[null,"RETA Temporal","RÈGIM ESPECIAL DE TREBALLADORS AUTÒNOMS - Relació temporal amb l'empresa"]