{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Portada","Càlculs Predoctorals i Postdoct"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":19,"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àlculs Predoctorals i Postdoct","index":1,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,6,59,7],[48,3,48,4],[50,3,51,3],[1,3,3,11],[5,3,5,6],[7,3,7,4],[8,3,8,4],[9,3,9,4],[21,3,21,6],[15,3,15,6],[17,3,17,4],[18,3,18,4],[19,3,19,4]]}
[]
[]
[]
[]
[]
[null,"Tipus investigador",null,"Càlcul imports reserves de recursos"]
[]
[null,null,null,"Retribució mensual"]
[null,null,null,"Data inici"]
[null,null,null,"Data fi"]
[]
[]
[null,null,null,"Sou","Quota patronal","Indemnització","Total"]
[null,null,null,{"$f":"IF(OR(F8=\"\",F9=\"\",F10=\"\"),0,SUM(I56:I60))","v":0},{"$f":"IF(F9=\"\",0,IF(L61<>0,L61,IF(D46=1,D14*26.02%,D14*33.1%)))","v":0},{"$f":"IF(OR(F9=\"\",F10=\"\",),0,ROUND(F8/30*L50,2))","v":0},{"$f":"SUM(D14:F14)","v":0}]
[]
[null,null,null,"Càlcul retribució mensual a partir d'un ajut econòmic determinat"]
[]
[null,null,null,"Import total de l'ajut"]
[null,null,null,"Data inici contracte"]
[null,null,null,"Mesos de durada"]
[]
[null,null,null,"Imports mensuals"]
[null,null,null,"Sou","Quota patronal","Indemnització","Total"]
[null,null,null,{"$f":"IF(E56=\"\",0,IF(E65<>0,ROUND(E65,2),ROUND(E57,2)))","v":0},{"$f":"IF(E56=\"\",0,ROUND(E58,2))","v":-115},{"$f":"IF(OR(F18=\"\",F19=\"\",),0,ROUND(D24/30*L51,2))","v":0},{"$f":"SUM(D24:F24)","v":-115}]
[]
[]
[null,null,null,null,"Sou 37,5h","hores","anual","Mensual"]
[null,null,null,"postdoc",25150.44,37.5,{"$f":"(E28/37.5)*F28","v":25150.44},{"$f":"G28/12","v":2095.87}]
[null,null,null,"ordinari",34981.360000000001,37.5,{"$f":"(E29/37.5)*F29","v":34981.360000000001},{"$f":"G29/12","v":2915.1133333333332}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[25028.76]
[]
[]
[null,null,null,"Tipus investigador"]
[null,null,null,1]
[null,null,null,null,null,null,"12 PAGUES",null,null,"Any inici contracte","Any de taspàs inici"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",YEAR(F9))","v":""},{"$f":"IF(OR(G52=2020,G52=2024,G52=2028,G52=2032,G52=2036,G52=2040,G52=2044,G52=2048,G52=2052,G52=2056,G52=2060,G52=2064,G52=2068,G52=2072,G52=2076,G52=2080,G52=2084,G52=2088,G52=2092,G52=2096),\"si\",\"\")","v":""}]
[null,null,null,"Desplegables",null,null,"data inici","data fi",null,null,null,"Dies indemnització"]
[null,null,null,"D22","Sí",null,{"$f":"IF(F9=\"\",\"\",DAY(F9))","v":""},{"$f":"IF(F10=\"\",\"\",DAY(F10))","v":""},"Dies","Nombre dies",null,{"$f":"ROUND(IF(F9=\"\",0,IF(D46=2,(F10-F9+1)*20/365,IF(D46=3,(F10-F9+1)*20/365,IF(D46=4,(F10-F9+1)*20/365,IF(D46=5,(F10-F9+1)*20/365,IF(D46=1,(F10-F9+1)*12/365)))))),2)","v":0}]
[null,null,null,"Pagues",12,null,{"$f":"IF(F9=\"\",\"\",MONTH(F9))","v":""},{"$f":"IF(F10=\"\",\"\",MONTH(F10))","v":""},"Mesos",null,null,{"$f":"ROUND(IF(F18=\"\",0,IF(D46=2,(F20*20/12),IF(D46=3,(F20*20/12),IF(D46=4,(F20*20/12),IF(D46=5,(F20*20/12),IF(D46=1,(F20*12/12))))))),2)","v":0}]
[null,null,null,null,14,null,{"$f":"IF(F9=\"\",\"\",YEAR(F9))","v":""},{"$f":"IF(F10=\"\",\"\",YEAR(F10))","v":""},"Anys",{"$f":"IF(I57=\"\",\"\",IF(AND(G51=2,K48=\"\"),29-G50,IF(AND(G51=2,K48=\"si\"),30-G50,IF(OR(G51=4,G51=6,G51=9,G51=11),31-G50,32-G50))))","v":""},null,"Any de taspàs final"]
[null,null,null,null,null,null,"RR mensual o diària",{"$f":"IF(OR(G50=\"\",H50=\"\"),\"\",IF(G50=1,IF(OR(AND(H50=29,H51=2,L53=\"si\"),AND(H50=28,H51=2,L53=\"\"),AND(H50=30,H51=4),AND(H50=30,H51=6),AND(H50=30,H51=9),AND(H50=30,H51=11),AND(H50=31)),\"RRMENSUAL\",\"RRDIARIA\"),\"RRDIARIA\"))","v":""},null,{"$f":"IF(I58<>\"\",H50,\"\")","v":""},null,{"$f":"IF(OR(H52=2020,H52=2024,H52=2028,H52=2032,H52=2036,H52=2040,H52=2044,H52=2048,H52=2052,H52=2056,H52=2060,H52=2064,H52=2068,H52=2072,H52=2076,H52=2080,H52=2084,H52=2088,H52=2092,H52=2096),\"si\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I59=\"\",\"\",IF(AND(G51=2,K48=\"\"),29-G50,IF(AND(G51=2,K48=\"si\"),30-G50,IF(OR(G51=4,G51=6,G51=9,G51=11),31-G50,32-G50))))","v":""},{"$f":"IF(I60<>\"\",(H50-G50)+1,H50)","v":""}]
[null,null,null,null,null,null,null,"Mesos sencers","Salari amb triennis","SS RR mateix dia",null,"SS amb salari > 4070,10"]
[null,null,null,"Base",{"$f":"IF(D46=1,((12/365)+1+(26.02/100)),((20/365)+1+(33.1/100)))","v":1.2930767123287672},null,"Mesos complets",{"$f":"IF(H53=\"RRMENSUAL\",(DATEDIF(F9,F10,\"m\")+1),\"\")","v":""},{"$f":"IF(H56=\"\",\"\",F8*H56)","v":""},"Suma SS amb Salari > 4070,10",null,{"$f":"IF(I56=\"\",\"\",IF(F8>4070.1,(4070.1*32.1%)*H56,\"\"))","v":""}]
[null,null,null,"Sou",{"$f":"IF(OR(F18=\"\",F20=\"\"),0,(F18/E56)/F20)","v":0},null,"Més inicial fraccionat",{"$f":"IF(AND(G50<>1,OR(AND(H50=28,H51=2,L53=\"\"),AND(H50=29,H51=2,N61=\"si\"),AND(H50=30,H51=4),AND(H50=30,H51=6),AND(H50=30,H51=9),AND(H50=30,H51=11),AND(H50=31))),(DATEDIF(F9,F10,\"m\")),\"\")","v":""},{"$f":"IF(H57=\"\",\"\",(ROUND(H57*F8+(IF(AND(G51=2,K48=\"\"),F8/28*(29-G50),IF(AND(G51=2,K48=\"si\"),F8/29*(30-G50),IF(OR(G51=4,G51=6,G51=9,G51=11),F8/30*(31-G50),F8/31*(32-G50))))),2)))","v":""},null,null,{"$f":"IF(I57=\"\",\"\",ROUND(IF(F8>4070.1,(H57*4070.1)*32.1%+(IF(AND(G51=2,K48=\"\"),(4070.1/28*J52)*32.1%,IF(AND(G51=2,K48=\"si\"),(4070.1/29*J52)*31.1%,IF(OR(G51=4,G51=6,G51=9,G51=11),(4070.1/30*J52)*32.1%,(4070.1/31*J52)*32.1%))))),2))","v":""}]
[null,null,null,"Quota patronal",{"$f":"IF(E57<4070.1,IF(D46=1,E57*33.18%-115,E57*33.1%),1157.53)","v":-115},null,"Més final fraccionat",{"$f":"IF(OR(F9=\"\",F10=\"\"),\"\",IF(AND(G50=1,H53=\"RRDIARIA\"),DATEDIF(F9,F10,\"m\"),\"\"))","v":""},{"$f":"IF(H58=\"\",\"\",(ROUND(H58*F8+(IF(AND(H51=2,L53=\"\"),F8/28*H50,IF(AND(H51=2,L53=\"si\"),F8/29*H50,IF(OR(H51=4,H51=6,H51=9,H51=11),F8/30*H50,F8/31*H50)))),2)))","v":""},null,null,{"$f":"IF(I58=\"\",\"\",ROUND(IF(F8>4070.1,(H58*4070.1)*32.1%+(IF(AND(H51=2,L53=\"\"),(4070.1/28*J53)*32.1%,IF(AND(H51=2,L53=\"si\"),(4070.1/29*J53)*32.1%,IF(OR(H51=4,H51=6,H51=9,H51=11),(4070.1/30*J53)*32.1%,(4070.1/31*J53)*32.1%))))),2))","v":""}]
[null,null,null,"Indemnització",{"$f":"E57/365*20","v":0},null,"Inci i final fraccionat amb mesos dels mateixos dies",{"$f":"IF(H53=\"\",\"\",IF(AND(H56=\"\",H57=\"\",H58=\"\"),IF(DAY(F9)<=DAY(F10),DATEDIF(F9,F10,\"M\")-1,DATEDIF(F9,F10,\"M\")),\"\"))","v":""},{"$f":"IF(H59=\"\",\"\",IF(I60<>\"\",\"\",ROUND((IF(AND(G51=2,K48=\"\"),F8/28*(29-G50),IF(AND(G51=2,K48=\"si\"),F8/29*(30-G50),IF(OR(G51=4,G51=6,G51=9,G51=11),F8/30*(31-G50),F8/31*(32-G50)))))+F8*H59+(IF(AND(H51=2,L53=\"\"),F8/28*H50,IF(AND(H51=2,L53=\"si\"),F8/29*H50,IF(OR(H51=4,H51=6,H51=9,H51=11),F8/30*H50,F8/31*H50)))),2)))","v":""},null,null,{"$f":"IF(I59=\"\",\"\",ROUND(IF(F8>4070.1,(H59*4070.1)*32.1%+(IF(AND(G51=2,K48=\"\"),(4070.1/28*J54)*32.1%,IF(AND(G51=2,K48=\"si\"),(4070.1/29*J54)*32.1%,IF(OR(G51=4,G51=6,G51=9,G51=11),(4070.1/30*J54)*32.1%,(4070.1/31*J54)*32.1%))))+(IF(AND(H51=2,L53=\"\"),(4070.1/28*K54)*32.1%,IF(AND(H51=2,L53=\"si\"),(4070.1/29*K54)*32.1%,IF(OR(H51=4,H51=6,H51=9,H51=11),(4070.1/30*K54)*32.1%,(4070.1/31*K54)*32.1%))))),2))","v":""}]
[null,null,null,null,null,null,"RR del mateix mes",null,{"$f":"IF(AND(F9=\"\",F10=\"\"),\"\",IF(OR(H56<>\"\",H57<>\"\",H58<>\"\"),\"\",IF(H51<>G51,\"\",IF(AND(G51=H51,G52<>H52),\"\",(IF(AND(G52=H52,G51=H51),IF(AND(G51=2,K48=\"\"),(F8/28)*(H50-G50+1),IF(AND(G51=2,K48=\"si\"),(F8/29)*(H50-G50+1),IF(OR(G51=4,G51=6,G51=9,G51=11),(F8/30)*(H50-G50+1),(F8/31)*(H50-G50+1))))))))))","v":""},null,{"$f":"H59","v":""},{"$f":"IF(AND(F9=\"\",F10=\"\"),\"\",IF(F8=\"\",\"\",IF(OR(L56<>\"\",L57<>\"\",L58<>\"\",L59<>\"\",F8<4070.1),\"\",IF(AND(G51=2,K48=\"\"),(4070.1/28*K54)*32.1%,IF(AND(G51=2,K48=\"si\"),(4070.1/29*K54)*32.1%,IF(OR(G51=4,G51=6,G51=9,G51=11),(4070.1/30*K54)*32.1%,(4070.1/31*K54)*32.1%))))))","v":""}]
[null,null,null,"Diferència quota patronal en >4070,10",{"$f":"IF(E57>4070.1,(E57*32.1%)-E58,\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(L56:L60)","v":0}]
[null,null,null,"Base sou indemnització",{"$f":"E59/E57","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Indemnització a sumar",{"$f":"E61*E62","v":{"$error":"#VALUE!"}}]
[null,null,null,"Sou a sumar",{"$f":"E61-E63","v":{"$error":"#VALUE!"}}]
[null,null,null,"Sou si > 4070,10",{"$f":"IF(E57>4070.1,SUM(E64+E57),0)","v":0}]
[null,null,null,"Indemnització  si > 4070,10",{"$f":"IF(E57>4070.1,E59+E63,0)","v":0}]