{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["LABORALS ","Manual d'ús","Condicions pràctiques","ValLAB","CONTRACTES","calcul dies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":1,"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":"LABORALS ","index":0,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,0,9,5],[30,3,30,4]]}
[]
["NOM"]
["TIPUS CONTRACTE"]
["DEDICACIÓ",35,{"$f":"IF(ValLAB!L24=3,\"Posar dedicació 35 hores\",IF(ValLAB!L24=4,\"Posar dedicació a temps parcial\",\"TP: posar les hores setmanals de dedicació / TC: posar 35 hores\"))","v":"TP: posar les hores setmanals de dedicació / TC: posar 35 hores"}]
["DATA ANY INICI VINCULACIÓ","2026-01-01",null,"FI CONTRACTE/PRORROGA","2026-12-31"]
["INICI CONTRACTE/PRORROGA","2025-10-01",null,"Possar el número de triennis de grup 1"]
["Grup: ","1900-01-03",null,"Possar el número de triennis de grup 2,3"]
["CLT: ","1900-02-04",null,"IMPORT TRIENNIS",{"$f":"((E6*ValLAB!F3)+(E7*ValLAB!F4))*(B4/35)*ValLAB!M28","v":0}]
["Nº Dies RD",20]
["COST MENSUAL"]
[]
["Retribucions:      ",{"$f":"SUM(B13:B16)","v":2846.89}]
["Sou",{"$f":"(ValLAB!M22)*B4/35*ValLAB!M28","v":2650.1}]
["Acord mesa",{"$f":"(ValLAB!P22)*B4/35*ValLAB!M28","v":8.58}]
["Millora",{"$f":"(ValLAB!N22)*B4/35*ValLAB!M28","v":17.63}]
["clt",{"$f":"ValLAB!M24*'LABORALS '!B4/35*ValLAB!M28","v":170.58}]
[]
["Prorrata mensual extres",{"$f":"ValLAB!M22*2/12*B4/35*ValLAB!M28","v":441.68333333333334}]
["Prorrata mensual triennis extres",{"$f":"E8*2/12*ValLAB!M28","v":0}]
["TOTAL PRORRATA ",{"$f":"SUM(B18:B19)","v":441.68333333333334}]
[]
["Triennis: ",{"$f":"SUM(E8)","v":0}]
[]
["TOTAL RETRIBUCIONS",{"$f":"SUM(B12+B20+B22)","v":3288.5733333333333}]
["Indemnització RD"]
["Quota patronal",{"$f":"IF(B24>ValLAB!N16,ValLAB!N26*4139.4,B24*ValLAB!N26)","v":1057.2763266666666}]
["TOTAL COST",{"$f":"SUM(B24:B26)","v":4345.8496599999999}]
[]
["COST PERIODE DEMANAT",{"$f":"CONCATENATE(B2,\" (\",DAY(B6),\"/\",MONTH(B6),\"/\",YEAR(B6),\"-\",DAY(E5),\"/\",MONTH(E5),\"/\",YEAR(E5),\")\")","v":" (1/10/2025-31/12/2026)"}]
[]
["Retribucions:",{"$f":"IF(B12=0,0,B12*(E33+(E34/30)))","v":42703.35},null,"                                                                 PERIODE DEMANAT"]
[]
["TOTAL EXTRES:",{"$f":"SUM(B34:B35)","v":6625.25},null,"nº mesos",{"$f":"IF((E5-B6)>0,'calcul dies'!L5,\"ERROR DATES\")","v":15}]
["Extra  juny",{"$f":"IF(B20=0,\" \",B20/2*(E33+(E34/30)))","v":3312.625},null,"nº dies",{"$f":"IF((E5-B6)>0,'calcul dies'!N5,\" \")","v":0}]
["Extra desembre",{"$f":"IF(B20=0,\" \",(B20/2)*(E33+E34/30))","v":3312.625}]
[]
["Triennis: ",{"$f":"IF(B22=0,0,B22*(E33+E34/30))","v":0}]
[]
["TOTAL RETRIB.",{"$f":"IF(B31=0,0,SUM(B31+B33+B37))","v":49328.6}]
["Indemnització RD ",{"$f":"IF(B25=0,0,B25*(E33+E34/30))","v":0}]
["Quota patronal",{"$f":"IF(B24>ValLAB!N16,B26*(E33+(E34/30)),B39*ValLAB!N26)","v":15859.144899999999}]
["TOTAL COST",{"$f":"SUM(B39:B41)","v":65187.744899999998}]

{"sheet":"Manual d'ús","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,1,13,12],[18,0,18,12],[2,0,2,6],[5,0,5,11],[8,0,8,12],[11,0,11,3],[12,0,12,12]]}
[]
["Què es aquest fitxer?"]
["És un simulador que us permet obtenir la distribució previsible de la despesa d'una contractació."]
[]
["Per a què serveix?"]
["Per a que el personal interessat en iniciar un procediment de contractació pugui preveure els costos de personal d'acord amb les seves necessitats"]
[]
["Com funciona?"]
["Heu d'emplenar els camps en blanc de la zona blava "]
[]
["Quin grup escollir?"]
["El grup depèn de les funcions que desenvolupi el/la treballador/a."]
["A continuació us facilitem un quadre on es recullen les diferents possibilitats de manera resumida:"]
["Grup 1: ","Funcions de Llicenciats/des, Enginyers/es, Arquitectes i Doctors/es."]
["Grup 2: ","Funcions de Diplomats/es, Enginyers/es Tècnics/ques"]
["Grup 3: ","Batxiller, FPII, CFGS. "]
[]
["Quin complement de lloc de treball (CLT) escollir?"]
["El CLT és un dels 3 complements que intervenen en la retribució del personal laboral (sou i millora serien la resta)"]
["A les següents possibilitats podreu triar la que us interessi més:"]
["Grup 1: ","De la U (el mínim) a la A (el màxim)."]
["Grup 2: ","De la U a la D."]
["Grup 3: ","De la U a la K."]

{"sheet":"Condicions pràctiques","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["1.","El lloc de treball haurà de permetre la obtenció de la pràctica professional adequada al nivell d’estudis cursats, de manera que les tasques objecte del contracte hauran d’anar acordes amb la mateixa. Per aquest motiu, si s’escau, les convocatòries dels concursos hauran de delimitar les titulacions concretes exigibles com a condició, no com a mèrit"]
["2. ","Han d’haver transcorregut un màxim de tres anys des de l’obtenció de la titulació (no titulació estrangeres) per la qual haurà de ser contractada la persona o cinc anys en el cas de persones amb la condició de discapacitades, en el moment d’inici de la contractació."]
["3. ","Les titulacions que habiliten per a la formalització d’un contracte en pràctiques, tenint en compte la classificació professional a la UPC són:"]
[null,"a. Enginyeria o Llicenciatura: Grup I"]
[null,"b. Enginyeria Tècnica o Diplomatura: Grup II"]
[null,"c. Cicles Formatius de Grau Superior o FPII: Grup III"]
["4. ","La persona contractada haurà d’estar en possessió del títol o del rebut d’haver abonat les tasses per a la seva expedició. Les certificacions acadèmiques o similars no són habilitants per a la realització d’aquest contracte."]
["5. ","La durada mínima inicial del contracte serà de sis mesos. La durada màxima d'un any. "]
["6. ","No es podrà subscriure en la mateixa o diferent empresa pel temps superior fixat en virtut de la mateixa titulació o certificat professional.\nTampoc es podrà contractar en la mateixa empresa, pel mateix lloc de treball pel temps superior a els màxims previstos, tot i que es tracti de diferent titulació o certificat. \nNOTA: Si han gaudit d’un contracte en pràctiques (anterior a la reforma laboral) es té en compte, ja que són de la mateixa naturalesa"]
["7. ","L’obtenció d’un nou títol habilita per a una nova contractació en formació per a l'obtenció de la pràctica professional"]
["8. ","Les retribucions pels temps de treball efectiu seran les fixades en el conveni col·lectiu aplicable a la empresa per aquests contractes o en el seu defecte la del grup professional i nivell retributiu corresponent a les funcions desenvolupades"]
["9. ","L’empresa elaborarà un pla formatiu individual detallant el contingut de la pràctica professional i assignarà un tutor.  El treballador/a té dret a la certificació de la pràctica realitzada"]

{"sheet":"ValLAB","index":3,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":true,"merged":[[42,0,69,0],[36,3,36,6],[36,9,36,12],[38,0,38,2],[39,0,39,2],[40,0,40,2]]}
[]
["Grups","Sou mes","Mll mes","Acord mesa","Hores extres","trienni",null,"CLT mes","Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes","Centre Liq.","% QP","% RETRIB.","Indemnització"]
[1,2650.1,17.63,8.58,11.54,69.47,"A",2958.17,"005-A",0.309,1,null,"LABORAL INDEFINIT","005-A",0.32150000000000001,1,"no"]
[2,2306.98,17.260000000000002,8.58,10.33,58.11,"A0",2748.75,"006-A",0.32100000000000001,0.75,null,"TEMPORAL FORMATIU PER A LA PRÀCTICA PROFESSIONAL","005-A",0.32150000000000001,1,"no"]
[3,2018.71,17.62,8.58,9.1199999999999992,58.11,"A1-no utilitzar",2616.09,"007-A",0.32100000000000001,0.6,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TC (35h)","006-A",0.33350000000000002,1,"si"]
[4,1671.9,17.55,8.58,7.6,58.11,"B",2428.11,"005-D",0.36599999999999999,null,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TP (< 35h)","007-A",0.33350000000000002,1,"si"]
[null,null,null,null,null,null,"B0",2371.27,"006-D",0.38700000000000001]
[null,null,null,null,null,null,"B1 -no utilizar",null,"007-D",0.38800000000000001]
[null,null,null,null,null,null,"C",2134.12,"005-80",0.309]
[null,null,null,null,null,null,"C0",1799.21,"006-80",0.32100000000000001]
[null,null,null,null,null,null,"D",1573.78,"007-80",0.33100000000000002]
[null,null,null,null,null,null,"E",1195.01,"001-A",0.307]
["retribucions actualitzades amb l'increment març 2026",null,null,null,null,null,"F",1150.3900000000001,"002-A",0.252]
[null,null,null,null,null,null,"G",993.5]
[null,null,null,null,null,null,"H",881.28]
[null,null,null,null,null,null,"I",773.12,null,null,null,null,"Base màx.cotització 2025",4909.5]
[null,null,null,null,null,null,"J",656.78]
[null,null,null,null,null,null,"K",530.13,null,null,null,"Retribucions"]
[null,null,null,null,null,null,"L",515.16999999999996,null,null,null,"Grup"]
[null,null,null,null,null,null,"M",474.7,null,null,null,1]
[null,null,null,null,null,null,"M1-sols PQS",418.08,null,null,null,"CLT","Sou","Millora","Hora","Acord mesa"]
[null,null,null,null,null,null,"N",387.40999999999997,null,null,null,26,{"$f":"CHOOSE(L20,B3,B4,B5,B6)","v":2650.1},{"$f":"CHOOSE(L20,C3,C4,C5,C6)","v":17.63},{"$f":"CHOOSE(L20,E3,E4,E5,E6)","v":11.54},{"$f":"CHOOSE(L20,D3,D4,D5,D6)","v":8.58}]
[null,null,null,null,null,null,"Ñ",366.21,null,null,null,"Centre de Liquidació-Epígraf"]
[null,null,null,null,null,null,"O",320.73,null,null,null,1,{"$f":"INDEX(H3:H32,L22)","v":170.58}]
[null,null,null,null,null,null,"O1-sols PQS",null,null,null,null,"Reducció de retribucions (contracte en pràctiques)",null,"% corresponent"]
[null,null,null,null,null,null,"P",249.05,null,null,null,{"$f":"L24","v":1},{"$f":"INDEX(N3:N14,L24)","v":"005-A"},{"$f":"INDEX(O3:O6,L24)","v":0.32150000000000001}]
[null,null,null,null,null,null,"Q",184.26]
[null,null,null,null,null,null,"R",170.58,null,null,null,null,{"$f":"INDEX(P3:P6,L26)","v":1}]
[null,null,null,null,null,null,"S",151.82]
[null,null,null,null,null,null,"T",122.06]
[null,null,null,null,null,null,"U",105.69]
[null,null,null,null,null,null,"V",49.61]
[]
[]
[]
["2022-11-01"]
[null,null,null,"Grup",null,null,null,null,null,"Grup"]
[null,null,null,1,2,3,4,null,null,1,2,3,4]
["Sou base",null,null,2401.09,2090.21,1829.02,1514.8,null,"P.Perillositat",241.88,201.6,170.71,130.88]
["Millora",null,null,15.96,15.62,15.95,15.89,null,"Triennis",62.94,52.64,52.64,52.64]
["Acord Mesa universitats",null,null,7.74,7.74,7.74,7.74,null,"Hores extres",11.54,10.33,9.1199999999999992,7.6]
[]
["Complement de lloc de treball","A ",2680.21]
[null,"A0",2490.4499999999998]
[null,"A1*",2370.2600000000002]
[null,"B ",2199.96]
[null,"B0",2148.44]
[null,"C ",1933.59]
[null,"C0",1630.12]
[null,"D ",1425.9]
[null,"E ",1082.72]
[null,"F ",1042.3]
[null,"G ",900.15]
[null,"H ",798.46]
[null,"I ",700.47]
[null,"J ",595.04999999999995]
[null,"K ",480.32]
[null,"L ",466.76]
[null,"M ",430.09]
[null,"M1*",378.76]
[null,"N ",351]
[null,"Ñ ",331.8]
[null,"O ",290.58999999999997]
[null,"P ",225.66]
[null,"Q ",166.94]
[null,"R ",154.55000000000001]
[null,"S ",137.55000000000001]
[null,"T ",110.59]
[null,"U ",95.76]
[null,"V ",44.94]

{"sheet":"CONTRACTES","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,0,2,6]]}
[]
[]
["CONTRCTES PSR"]
["CODI","DURADA","TIPUS","DEDICACIÓ","INDEMNITZACIÓ","RETRIBUCIONS","QUOTA PATRONAL","no consta la indemnització. Pendent decissió institucional per incrementar un % del fons de contitngència"]
[100,"INDEFINIT","D’ACTIVITATS CIENTIFICOTÈCNIQUES (PROJECTES CTT)","TEMPS COMPLET","20 días, pero no se contempla",1,null,"no consta la indemnització. Pendent decissió institucional per incrementar un % del fons de contitngència"]
[200,"INDEFINIT","D’ACTIVITATS CIENTIFICOTÈCNIQUES (PROJECTES CTT)","TEMPS PARCIAL","20 días, pero no se contempla",1,null,"no consta la indemnització. Pendent decissió institucional per incrementar un % del fons de contitngència"]
[100,"INDEFINIT","ALTRES PROJECTES QUE NO SIGUIN DE RECERCA","TEMPS COMPLET","20 días, pero no se contempla",1,null,"no consta la indemnització. Pendent decissió institucional per incrementar un % del fons de contitngència"]
[200,"INDEFINIT","ALTRES PROJECTES QUE NO SIGUIN DE RECERCA","TEMPS PARCIAL","20 días, pero no se contempla",1]
[406,"TEMPORAL","VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS","TEMPS COMPLET",12,1]
[506,"TEMPORAL","VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS","TEMPS PARCIAL",12,1]
[420,"TEMPORAL","FORMATIU PER A LA PRÀCTICA PROFESSIONAL","TEMPS COMPLET","no",1]
[520,"TEMPORAL","FORMATIU PER A LA PRÀCTICA PROFESSIONAL","TEMPS PARCIAL","no",1]

{"sheet":"calcul dies","index":5,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,13],[2,4,2,13]]}
["CALCULS DIES LABORALS NO TOPATS"]
[]
["MERITACIÓ ARROSEGAMENT PAGUES LABORALS NO TOPATS",null,null,null,"CÀLCUL DIES PRÒRROGA"]
[null,"DATA INICI","DATA FI",null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["PRORROGA",{"$f":"'LABORALS '!B6","v":"2025-10-01"},{"$f":"'LABORALS '!E5","v":"2026-12-31"},null,"INICI PRORROGA",{"$f":"DAY(B5)","v":1},{"$f":"MONTH(B5)","v":10},{"$f":"YEAR(B5)","v":2025},null,{"$f":"IF(F5>1,-1,0)","v":0},{"$f":"IF(F5=1,-M5,0)","v":-31},{"$f":"IF(H5=H6,G6-G5+1,13-G5+G6+(H6-H5-1)*12)+J5+J6","v":15},{"$f":"IF(G5=1,31-F5,IF(G5=2,28-F5,IF(G5=3,31-F5,IF(G5=4,30-F5,IF(G5=5,31-F5,IF(G5=6,30-F5,IF(G5=7,31-F5,IF(G5=8,31-F5,IF(G5=9,30-F5,IF(G5=10,31-F5,IF(G5=11,30-F5,IF(G5=12,31-F5))))))))))))+1","v":31},{"$f":"SUM(K5+M5+M6)","v":0}]
[null,null,null,null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":31},{"$f":"MONTH(C5)","v":12},{"$f":"YEAR(C5)","v":2026},null,{"$f":"IF(AND(G6=1,F6=31),0,IF(AND(G6=2,28=F6),0,IF(AND(G6=3,31=F6),0,IF(AND(G6=4,30=F6),0,IF(AND(G6=5,31=F6),0,IF(AND(G6=6,30=F6),0,IF(AND(G6=7,31=F6),0,IF(AND(G6=8,31=F6),0,IF(AND(G6=9,30=F6),0,IF(AND(G6=10,31=F6),0,IF(AND(G6=11,30=F6),0,IF(AND(G6=12,31=F6),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G6=1,F6<>31),F6,IF(AND(G6=2,28<>F6),F6,IF(AND(G6=3,31<>F6),F6,IF(AND(G6=4,30<>F6),F6,IF(AND(G6=5,31<>F6),F6,IF(AND(G6=6,30<>F6),F6,IF(AND(G6=7,31<>F6),F6,IF(AND(G6=8,31<>F6),F6,IF(AND(G6=9,30<>F6),F6,IF(AND(G6=10,31<>F6),F6,IF(AND(G6=11,30<>F6),F6,IF(AND(G6=12,31<>F6),F6,0))))))))))))","v":0}]