{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Portada","Càlcul Cost Contractació ","Càlcul Indemnització - Vacances","Informació Retribucions"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":12,"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":"Portada","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}

{"sheet":"Càlcul Cost Contractació ","index":1,"n_rows":121,"n_cols":20,"rows_kept":121,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[2,7,2,8],[7,4,7,5],[8,4,8,5],[8,7,8,8],[9,7,9,8],[12,4,12,8],[14,4,14,5],[14,7,14,8],[57,14,57,16]]}
[]
[]
[null,"Quantia de la indemnització",null,null,"Càlcul retribució contractes",null,null,"Càlcul triennis"]
[]
[null,null,null,null,"Grup i categoria",null,null,"Grup"]
[null,null,null,null,"Hores/Setmana",null,null,"Hores/Setmana"]
[null,null,null,null,null,null,null,"Número de Triennis"]
[null,null,null,null,"Retribució mensual"]
[null,null,null,null,{"$f":"IF(OR(F5=\"\",F6=\"\"),0,ROUND(((VLOOKUP(F5,H76:I83,2,0))/35*F6),2))","v":0},null,null,"Retribució mensual"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(I5=\"\",I6=\"\",I7=\"\"),0,ROUND((VLOOKUP(I5,'[1]Informació Retribucions'!C:F,4,0)/35*'Càlcul Cost Contractació '!I6*'Càlcul Cost Contractació '!I7),2))","v":0}]
[]
[]
[null,null,null,null,"Càlcul imports reserves de recursos"]
[]
[null,null,null,null,"Model 1",null,null,"Model 2"]
[]
[null,null,null,null,"Grup i categoria",null,null,"Retribució mensual amb triennis"]
[null,null,null,null,"Hores/Setmana",null,null,"Hores/Setmana"]
[null,null,null,null,"Número de Triennis",null,null,"Data inici"]
[null,null,null,null,"Data inici",null,null,"Data finalització"]
[null,null,null,null,"Data finalització",null,null,"Estabilitzat"]
[null,null,null,null,"Estabilitzat",null,null,"Plus Campus"]
[null,null,null,null,"Plus Campus","Sí"]
[]
[]
[null,null,null,null,"Imports reserva de recursos"]
[]
[null,null,null,null,"Sou \n(64130 - 28130)","SS\n(64160 - 28160)","Indemnització\n(64132 - 28132)","Complement PLUS CAMPUS","TOTAL"]
[null,null,null,null,{"$f":"IF(AND(I17=\"\",F17=\"\"),0,IF(AND(I60=0,O60=0),0,IF(I60<>0,I60,O60)))","v":0},{"$f":"IF(AND(I17=\"\",F17=\"\"),0,IF(AND(J60=0,P60=0),0,IF(J60<>0,J60,P60)))","v":0},{"$f":"IF(AND(I17=\"\",F17=\"\"),0,IF(AND(K60=0,Q60=0),0,IF(K60<>0,K60,Q60)))","v":0},{"$f":"IF(F23=\"Sí\",ROUND(446.91/365/35*F18*(F21-F20+1),2),IF(I22=\"Sí\",ROUND(446.91/365/35*I18*(I20-I19+1),2),))","v":0},{"$f":"SUM(E29:H29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Quantia indemnització"]
[null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"Número màxim d'hores",35]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"RESERVES DE RECURSOS CALCULADES PER GRUP I NOMBRE D'HORES",null,null,null,null,null,"RESERVES DE RECURSOS CALCULADES PER SALARI"]
[null,null,null,null,null,null,null,null,"SOU","SS","INDEMNITZACIÓ",null,null,null,"SOU","SS","INDEMNITZACIÓ"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F17=\"\",F18=\"\",F20=\"\",F21=\"\"),0,IF(K73=\"\",SUM(J70:J73),K73))","v":0},{"$f":"IF(I60=\"\",\"\",IF(J77<4070.1,I60*33.1%,\"Veure nota 2\"))","v":0},{"$f":"IF(OR(F20=\"\",F21=\"\"),0,IF(F22=\"sí\",0,ROUND(J77/30*K63,2)))","v":0},null,null,null,{"$f":"IF(OR(I17=\"\",I19=\"\",I20=\"\"),0,IF(T73=\"\",SUM(P70:P73),T73))","v":0},{"$f":"IF(O60=\"\",\"\",IF(S75<>0,S75,O60*32.6%))","v":0},{"$f":"IF(OR(I19=\"\",I20=\"\"),0,IF(I21=\"sí\",0,ROUND(I17/30*Q63,2)))","v":0}]
[]
[null,null,null,null,null,null,null,"data inici","data fi",null,"Dies indemnització",null,null,"data inici","data fi",null,"Dies indemnització"]
[null,null,null,null,null,null,"Dies",{"$f":"IF(F20=\"\",\"\",DAY(F20))","v":""},{"$f":"IF(F21=\"\",\"\",DAY(F21))","v":""},null,{"$f":"ROUND(IF(F20=\"\",0,IF(H51=1,(F21-F20+1)*12/365,IF(H51=2,(F21-F20+1)*20/365))),2)","v":0},null,"Dies",{"$f":"IF(I19=\"\",\"\",DAY(I19))","v":""},{"$f":"IF(I20=\"\",\"\",DAY(I20))","v":""},null,{"$f":"ROUND(IF(I19=\"\",0,IF(H51=1,(I20-I19+1)*12/365,IF(H51=2,(I20-I19+1)*20/365))),2)","v":0}]
[null,null,null,null,null,null,"Mesos",{"$f":"IF(F20=\"\",\"\",MONTH(F20))","v":""},{"$f":"IF(F21=\"\",\"\",MONTH(F21))","v":""},null,null,null,"Mesos",{"$f":"IF(I19=\"\",\"\",MONTH(I19))","v":""},{"$f":"IF(I20=\"\",\"\",MONTH(I20))","v":""}]
[null,null,null,null,null,null,"Anys",{"$f":"IF(F20=\"\",\"\",YEAR(F20))","v":""},{"$f":"IF(F21=\"\",\"\",YEAR(F21))","v":""},null,"Any de traspàs inici","Any de traspàs final","Anys",{"$f":"IF(I19=\"\",\"\",YEAR(I19))","v":""},{"$f":"IF(I20=\"\",\"\",YEAR(I20))","v":""},null,"Any de traspàs inici","Any de traspàs final"]
[null,null,null,null,null,null,"Dies del mes",{"$f":"IF(F20=\"\",\"\",DAY(EOMONTH(F20,0)))","v":""},{"$f":"IF(F21=\"\",\"\",DAY(EOMONTH(F21,0)))","v":""},null,{"$f":"IF(OR(H65=2020,H65=2024,H65=2028,H65=2032,H65=2036,H65=2040,H65=2044,H65=2048,H65=2052,H65=2056,H65=2060,H65=2064,H65=2068,H65=2072,H65=2076,H65=2080,H65=2084,H65=2088,H65=2092,H65=2096),\"si\",\"\")","v":""},{"$f":"IF(OR(I65=2020,I65=2024,I65=2028,I65=2032,I65=2036,I65=2040,I65=2044,I65=2048,I65=2052,I65=2056,I65=2060,I65=2064,I65=2068,I65=2072,I65=2076,I65=2080,I65=2084,I65=2088,I65=2092,I65=2096),\"si\",\"\")","v":""},"Dies del mes",{"$f":"IF(I19=\"\",\"\",DAY(EOMONTH(I19,0)))","v":""},{"$f":"IF(I20=\"\",\"\",DAY(EOMONTH(I20,0)))","v":""},null,{"$f":"IF(OR(N65=2020,N65=2024,N65=2028,N65=2032,N65=2036,N65=2040,N65=2044,N65=2048,N65=2052,N65=2056,N65=2060,N65=2064,N65=2068,N65=2072,N65=2076,N65=2080,N65=2084,N65=2088,N65=2092,N65=2096),\"si\",\"\")","v":""},{"$f":"IF(OR(O65=2020,O65=2024,O65=2028,O65=2032,O65=2036,O65=2040,O65=2044,O65=2048,O65=2052,O65=2056,O65=2060,O65=2064,O65=2068,O65=2072,O65=2076,O65=2080,O65=2084,O65=2088,O65=2092,O65=2096),\"si\",\"\")","v":""}]
[null,null,null,null,null,null,null,"RR mensual o diària",{"$f":"IF(H63=\"\",\"\",IF(H63=1,IF(OR(AND(I63=29,I64=2,L66=\"si\"),AND(I63=28,I64=2,L66=\"\"),AND(I63=30,I64=4),AND(I63=30,I64=6),AND(I63=30,I64=9),AND(I63=30,I64=11),AND(I63=31)),\"RRMENSUAL\",\"RRDIARIA\"),\"RRDIARIA\"))","v":""},null,null,null,null,"RR mensual o diària",{"$f":"IF(N63=\"\",\"\",IF(N63=1,IF(OR(AND(O63=29,O64=2,R66=\"si\"),AND(O63=28,O64=2,R66=\"\"),AND(O63=30,O64=4),AND(O63=30,O64=6),AND(O63=30,O64=9),AND(O63=30,O64=11),AND(O63=31)),\"RRMENSUAL\",\"RRDIARIA\"),\"RRDIARIA\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Mesos sencers","Salari amb triennis",null,null,null,null,"Mesos sencers","Salari amb triennis","Nombre dies",null,"SS amb salari >4070,10"]
[null,null,null,null,null,null,null,"Mesos complets",{"$f":"IF(I67=\"RRMENSUAL\",(DATEDIF(F20,F21,\"m\")+1),\"\")","v":""},{"$f":"IF(I70=\"\",\"\",J77*I70)","v":""},null,null,null,"Mesos complets",{"$f":"IF(O67=\"RRMENSUAL\",(DATEDIF(I19,I20,\"m\")+1),\"\")","v":""},{"$f":"IF(O70=\"\",\"\",I17*O70)","v":""},null,null,{"$f":"IF(P70=\"\",\"\",IF(I17>4070.1,(4070.1*32.6%)*O70,))","v":""}]
[null,null,null,null,null,null,null,"Més inicial fraccionat",{"$f":"IF(AND(H63<>1,OR(AND(I63=28,I64=2,L66=\"\"),AND(I63=29,I64=2,L66=\"si\"),AND(I63=30,I64=4),AND(I63=30,I64=6),AND(I63=30,I64=9),AND(I63=30,I64=11),AND(I63=31))),(DATEDIF(F20,F21,\"m\")),\"\")","v":""},{"$f":"IF(I71=\"\",\"\",(ROUND(I71*J77+(IF(AND(H64=2,K66=\"\"),J77/28*(29-H63),IF(AND(H64=2,K66=\"si\"),J77/29*(30-H63),IF(OR(H64=4,H64=6,H64=9,H64=11),J77/30*(31-H63),J77/31*(32-H63))))),2)))","v":""},null,null,null,"Més inicial fraccionat",{"$f":"IF(AND(N63<>1,OR(AND(O63=28,O64=2,R66=\"\"),AND(O63=29,O64=2,R66=\"si\"),AND(O63=30,O64=4),AND(O63=30,O64=6),AND(O63=30,O64=9),AND(O63=30,O64=11),AND(O63=31))),(DATEDIF(I19,I20,\"m\")),\"\")","v":""},{"$f":"IF(OR(I19=\"\",I20=\"\"),\"\",IF(O71=\"\",\"\",(ROUND(O71*I17+(IF(AND(N64=2,Q66=\"\"),I17/28*(29-N63),IF(AND(N64=2,Q66=\"si\"),I17/29*(30-N63),IF(OR(N64=4,N64=6,N64=9,N64=11),I17/30*(31-N63),I17/31*(32-N63))))),2))))","v":""},{"$f":"IF(P71=\"\",\"\",IF(AND(N64=2,Q66=\"\"),29-N63,IF(AND(N64=2,Q66=\"si\"),30-N63,IF(OR(N64=4,N64=6,N64=9,N64=11),31-N63,32-N63))))","v":""},null,{"$f":"IF(P71=\"\",\"\",ROUND(IF(I17>4070.1,(O71*4070.1)*32.6%+(IF(AND(N64=2,Q66=\"\"),(4070.1/28*Q71)*32.6%,IF(AND(N64=2,Q66=\"si\"),(4070.1/29*Q71)*32.6%,IF(OR(N64=4,N64=6,N64=9,N64=11),(4070.1/30*Q71)*32.6%,(4070.1/31*Q71)*32.6%))))),2))","v":""}]
[null,null,null,null,null,null,null,"Més final fraccionat",{"$f":"IF(AND($H$63=1,$I$67=\"RRDIARIA\"),DATEDIF(F20,F21,\"m\"),\"\")","v":""},{"$f":"IF(I72=\"\",\"\",(ROUND(I72*J77+(IF(AND(I64=2,L66=\"\"),J77/28*I63,IF(AND(I64=2,L66=\"si\"),J77/29*I63,IF(OR(I64=4,I64=6,I64=9,I64=11),J77/30*I63,J77/31*I63)))),2)))","v":""},"RR del mateix mes",null,null,"Més final fraccionat",{"$f":"IF(OR(I19=\"\",I20=\"\"),\"\",IF(AND($N$63=1,$O$67=\"RRDIARIA\"),DATEDIF(I19,I20,\"m\"),\"\"))","v":""},{"$f":"IF(O72=\"\",\"\",(ROUND(O72*I17+(IF(AND(O64=2,R66=\"\"),I17/28*O63,IF(AND(O64=2,R66=\"si\"),I17/29*O63,IF(OR(O64=4,O64=6,O64=9,O64=11),I17/30*O63,I17/31*O63)))),2)))","v":""},{"$f":"IF(P72<>\"\",O63,\"\")","v":""},null,{"$f":"IF(P72=\"\",\"\",ROUND(IF(I17>4070.1,(O72*4070.1)*32.6%+(IF(AND(O64=2,R66=\"\"),(4070.1/28*Q72)*32.6%,IF(AND(O64=2,R66=\"si\"),(4070.1/29*Q72)*32.6%,IF(OR(O64=4,O64=6,O64=9,O64=11),(4070.1/30*Q72)*32.6%,(4070.1/31*Q72)*32.6%))))),2))","v":""},"RR del mateix mes"]
[null,null,null,null,null,null,null,"Inici i final fraccionat amb mesos dels mateixos dies",{"$f":"IF(I67=\"\",\"\",IF(AND(I70=\"\",I71=\"\",I72=\"\"),IF(DAY(F20)<=DAY(F21),DATEDIF(F20,F21,\"M\")-1,DATEDIF(F20,F21,\"M\")),\"\"))","v":""},{"$f":"IF(I73=\"\",\"\",IF(K73<>\"\",\"\",ROUND((IF(AND(H64=2,K66=\"\"),J77/28*(29-H63),IF(AND(H64=2,K66=\"si\"),J77/29*(30-H63),IF(OR(H64=4,H64=6,H64=9,H64=11),J77/30*(31-H63),J77/31*(32-H63)))))+J77*I73+(IF(AND(I64=2,L66=\"\"),J77/28*I63,IF(AND(I64=2,L66=\"si\"),J77/29*I63,IF(OR(I64=4,I64=6,I64=9,I64=11),J77/30*I63,J77/31*I63)))),2)))","v":""},{"$f":"IF(I73=\"\",\"\",IF(AND(H65=I65,I64=H64),J77/H66*(I63-H63+1),\"\"))","v":""},null,null,"Inci i final fraccionat amb mesos dels mateixos dies",{"$f":"IF(O67=\"\",\"\",IF(AND(O70=\"\",O71=\"\",O72=\"\"),IF(DAY(I19)<=DAY(I20),DATEDIF(I19,I20,\"M\")-1,DATEDIF(I19,I20,\"M\")),\"\"))","v":""},{"$f":"IF(O73=\"\",\"\",IF(T73<>\"\",\"\",ROUND((IF(AND(N64=2,Q66=\"\"),I17/28*(29-N63),IF(AND(N64=2,Q66=\"si\"),I17/29*(30-N63),IF(OR(N64=4,N64=6,N64=9,N64=11),I17/30*(31-N63),I17/31*(32-N63)))))+I17*O73+(IF(AND(O64=2,R66=\"\"),I17/28*O63,IF(AND(O64=2,R66=\"si\"),I17/29*O63,IF(OR(O64=4,O64=6,O64=9,O64=11),I17/30*O63,I17/31*O63)))),2)))","v":""},{"$f":"IF(P73=\"\",\"\",IF(AND(N64=2,Q66=\"\"),29-N63,IF(AND(N64=2,Q66=\"si\"),30-N63,IF(OR(N64=4,N64=6,N64=9,N64=11),31-N63,32-N63))))","v":""},{"$f":"IF(T73<>\"\",(O63-N63)+1,O63)","v":""},{"$f":"IF(P73=\"\",\"\",ROUND(IF(I17>4070.1,(O73*4070.1)*32.6%+(IF(AND(N64=2,Q66=\"\"),(4070.1/28*Q73)*32.6%,IF(AND(N64=2,Q66=\"si\"),(4070.1/29*Q73)*32.6%,IF(OR(N64=4,N64=6,N64=9,N64=11),(4070.1/30*Q73)*32.6%,(4070.1/31*Q73)*32.6%))))+(IF(AND(O64=2,R66=\"\"),(4070.1/28*R73)*32.6%,IF(AND(O64=2,R66=\"si\"),(4070.1/29*R73)*32.6%,IF(OR(O64=4,O64=6,O64=9,O64=11),(4070.1/30*R73)*32.6%,(4070.1/31*R73)*32.6%))))),2))","v":""},{"$f":"IF(OR(O70<>\"\",O71<>\"\",O72<>\"\"),\"\",IF(N63=\"\",\"\",IF(AND(N65=O65,N64=O64),J77/N66*(O63-N63+1),\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SS RR mateix dia",null,{"$f":"IF(OR(I19=\"\",I20=\"\"),\"\",IF(AND(I19=\"\",I20=\"\"),\"\",IF(I17=\"\",\"\",IF(OR(S70<>\"\",S71<>\"\",S72<>\"\",S73<>\"\",I17<4070.1),\"\",(IF(AND(N64=2,Q66=\"\"),(4070.1/28*R73)*32.6%,IF(AND(N64=2,Q66=\"si\"),(4070.1/29*R73)*32.6%,IF(OR(N64=4,N64=6,N64=9,N64=11),(4070.1/30*R73)*32.6%,(4070.1/31*R73)*32.6%))))))))","v":""}]
[null,null,null,null,null,null,null,"Grup i Categoria","Sou mensual brut",null,null,null,null,null,null,null,"Suma SS amb Salari > 4070,1",null,{"$f":"SUM(S70:S74)","v":0}]
[null,null,null,null,null,null,null,"1 - Q",{"$f":"'Informació Retribucions'!E6","v":3158.71},"Salari amb triennis"]
[null,null,null,null,null,null,null,"2 - L",{"$f":"'Informació Retribucions'!E7","v":3092.32},{"$f":"IF(F18=\"\",0,((VLOOKUP($F$17,$H$76:$I$83,2,0)/35*F18)+J88))","v":0}]
[null,null,null,null,null,null,null,"2 - O",{"$f":"'Informació Retribucions'!E8","v":2906.32}]
[null,null,null,null,null,null,null,"2 - Q",{"$f":"'Informació Retribucions'!E9","v":2775.79}]
[null,null,null,null,null,null,null,"3 - L",{"$f":"'Informació Retribucions'!E10","v":2770.65}]
[null,null,null,null,null,null,null,"3 - O",{"$f":"'Informació Retribucions'!E11","v":2584.65}]
[null,null,null,null,null,null,null,"3 - Q",{"$f":"'Informació Retribucions'!E12","v":2454.12}]
[null,null,null,null,null,null,null,"4 - P",{"$f":"'Informació Retribucions'!E13","v":2129.08}]
[]
[]
[]
[null,null,null,null,null,null,null,"Trienni G1",{"$f":"'Informació Retribucions'!F6","v":77.459999999999994},"Import Triennis"]
[null,null,null,null,null,null,null,"Trienni G2-4",{"$f":"'Informació Retribucions'!F7","v":64.790000000000006},{"$f":"IF(F19=\"\",0,ROUND(IF(F17=\"1 - Q\",(I87/35*F18)*F19,(I88/35*F18)*F19),2))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,2021]

{"sheet":"Càlcul Indemnització - Vacances","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Càlcul de les indemnitzacions i de les vacances"]
[]
[null,null,null,null,"Data inici"]
[null,null,null,null,"Data finalització"]
[null,null,null,null,"Retribució mensual amb triennis "]
[]
[null,null,null,null,"Total dies indemnització","Total indemnització"]
[null,null,null,null,{"$f":"IF(OR(F5=\"\",F6=\"\"),0,ROUND(IF(E33=1,(F6-F5+1)*12/365,IF(E33=2,(F6-F5+1)*20/365,)),2))","v":0},{"$f":"F7/30*E10","v":0}]
[]
[]
[]
[null,null,null,null,"Total dies vacances","Total import vacances","Seguretat social"]
[null,null,null,null,{"$f":"ROUND(IF(OR(F5=\"\",F6=\"\"),0,ROUND((F6-F5+1)*31/365,2)),0)","v":0},{"$f":"IF(E15=31,F7,F16*E15)","v":0},{"$f":"F15*32.6%","v":0}]
[null,null,null,null,null,{"$f":"ROUND(F7/30,2)","v":0}]
[]
[null,null,null,null,"Es compten des de l'1 de setembre fins al 31 d'agost de l'any vinent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1]

{"sheet":"Informació Retribucions","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[]
[]
[]
[null,"Categoria laboral","Grup","Retribució bruta anual (35h/s)","Retribució bruta mensual (35h/s)","Preu trienni \n(35h/s)"]
[null,"T. superior de suport a la recerca","1 - Q",37904.516800000005,{"$f":"ROUND(D6/12,2)","v":3158.71},77.459999999999994]
[null,"T. mitjà de suport a la recerca","2 - L",37107.828000000001,3092.32,64.790000000000006]
[null,"T. mitjà de suport a la recerca","2 - O",34875.890400000004,2906.32,64.790000000000006]
[null,"T. mitjà de suport a la recerca","2 - Q",33309.537600000003,2775.79,64.790000000000006]
[null,"T. especialista de suport a la recerca","3 - L",33247.787200000006,2770.65,64.790000000000006]
[null,"T. especialista de suport a la recerca","3 - O",31015.849599999998,2584.65,64.790000000000006]
[null,"T. especialista de suport a la recerca","3 - Q",29449.496800000001,2454.12,64.790000000000006]
[null,"Auxiliar de suport a la recerca","4 - P",25548.947199999999,2129.08,64.790000000000006]