{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instruktion","MSCA","Samfinansiering","Calc","Def"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":69,"comments":2,"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":"Instruktion","index":0,"n_rows":70,"n_cols":4,"rows_kept":70,"cut":false,"hidden":false,"merged":[[64,2,65,8],[59,2,60,8],[69,2,70,8],[22,2,22,6],[31,3,31,5],[46,2,46,8],[48,2,48,8],[50,2,50,8],[52,2,52,8]]}
[]
[null,"Instruktion till mallen för budget/avstämning"]
[]
[null,"1.","Fyll i de förutsättningar som gäller för det aktuella projektet"]
[null,null,"Ange om mallen ska användas för budgetering eller avstämning/tilläggsbetalning."]
[null,null,"Alla val påverkar beräkningarna så ange alla förutsättningar."]
[null,null,"Om du är osäker på någon förutsättning, kolla i avtalet eller fråga Avdelningen för forsknings- "]
[null,null,"och samverkansstöd. Work programme avser när utlysningen till bidraget gjordes. IF/PF är för post docs "]
[null,null,"och ITN/DN är för doktorander."]
[]
[null,"2.","Resultatet genereras i tabell på sidan. De aktuella värdena som används vid beräkning"]
[null,null,"finns uppe till höger."]
[]
[null,"3.","För avstämning/tilläggsbetalning ange bokfört belopp i de vita cellerna."]
[]
[null,"Tips","Vita celler går bra att skriva i det aktuella värdet"]
[]
[]
[]
[]
[null,null,"Det går också bra att hoppa mellan cellerna genom att använda tabulator-knappen"]
[]
[null,null,"Himmelfärgade celler innehåller en sk. rullgarinsmeny. När du ställer dig i cellen kommer en pil fram till höger om cellen och du kan göra ditt val."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Testa=>","Budgetering"]
[]
[]
[]
[null,"4.","Mallen gör vissa avstämningar för att undvika vanlig fel exemplvis:"]
[]
[null,null,null,"Räknar ut bokfört belopp mot beloppet i överenskommelsen med EU"]
[]
[]
[]
[]
[]
[]
[null,"Checklista för samfinansiering"]
[]
[null,1,"Ange bruttolön"]
[]
[null,2,"Ange hur stor OH som institutionen tar för personalkostnader (SUHF-modellen)."]
[]
[null,3,"Ange övriga planerade kostnader (resor, förbrukningsvaror mm)."]
[]
[null,4,"För projekt med konsortsium (ex. doktorandnätverk) ange hur mycket som koordinatorn behåller av projektmedlen för koordinering. Ska regleas i konsortialavtalet (CA)."]
[]
[null,5,"Mallen räknar ut ev. samfinansieringsbehov."]
[]
[]
[null,"Osäkerhetsfaktorer att känna till"]
[]
[null,"l","Växelkursen ändras, det kan bli valutavinst eller valutaförluster (beräknad växelkurs (vid rapportering) vs. faktisk växelkurs (vid betalning))"]
[]
[]
[null,"l","OH på institutionen kan ändras"]
[]
[null,"l","LKP-nivåer kan ändras vilket ändrar fördelningen mellan bruttolön och LKP i det bidrag som ges"]
[]
[]
[null,"l","Lön revideras regelbundet, gäller också för MSCA-forskare"]
[]
[null,"l","Bankens växelkurs vid utbetalning av bidraget är annat än beräknad och faktiska växelkurs. Det kan bli valutaförlust eller valutavinst."]

{"sheet":"MSCA","index":1,"n_rows":84,"n_cols":75,"rows_kept":84,"cut":false,"hidden":false,"merged":[[81,2,81,13],[81,15,81,19],[81,22,81,27],[81,30,81,35],[81,38,81,44],[83,2,84,13],[83,15,84,19],[83,22,84,27],[83,30,84,35],[83,38,84,44],[73,2,74,15],[78,15,78,19],[78,22,78,27],[78,30,78,35],[78,38,78,44],[80,2,80,13],[80,15,80,19],[80,22,80,27],[80,30,80,35],[80,38,80,44],[0,1,0,73],[0,74,3,74],[10,53,10,56],[12,53,12,56],[14,53,14,56],[16,53,16,56],[18,53,18,56],[20,53,20,56],[8,12,8,24],[10,12,10,16],[12,12,12,16],[14,12,14,16],[16,12,16,16],[5,41,6,74],[5,2,6,38],[8,2,8,10],[10,2,10,10],[12,2,12,10],[10,18,10,24],[16,2,16,10],[18,26,20,38],[1,32,1,38],[14,41,14,51],[16,67,16,70],[44,6,44,13],[45,6,45,13],[46,6,46,13],[47,6,47,13],[66,15,66,19],[66,22,66,27],[31,6,31,13],[32,6,32,13],[32,15,32,19],[40,15,40,19],[37,6,38,13],[42,22,42,27],[34,6,35,13],[47,22,47,27],[52,22,52,27],[34,22,35,27],[43,15,43,19],[28,38,28,44],[28,30,28,35],[14,2,14,10],[18,12,18,14],[65,15,65,19],[65,22,65,27],[65,30,65,35],[65,38,65,44],[49,15,50,19],[49,22,50,27],[65,2,65,13],[58,2,59,44],[52,15,52,19],[53,22,53,27],[53,15,53,19],[49,2,50,13],[63,15,63,19],[63,22,63,27],[28,22,28,27],[28,15,28,19],[52,6,52,13],[53,6,53,13],[54,6,54,13],[18,2,18,8],[31,30,31,35],[32,30,32,35],[31,38,31,44],[32,38,32,44],[31,15,31,19],[30,6,30,13],[30,22,30,27],[30,15,30,19],[30,38,30,44],[30,30,30,35],[27,6,28,13],[68,2,69,13],[68,15,69,19],[68,22,69,27],[68,30,69,35],[68,38,69,44],[54,38,54,44],[54,15,54,19],[45,22,45,27],[45,30,45,35],[54,22,54,27],[54,30,54,35],[46,30,46,35],[52,30,52,35],[49,30,50,35],[49,38,50,44],[47,38,47,44],[66,30,66,35],[63,30,63,35],[63,38,63,44],[66,38,66,44],[66,2,66,13],[46,22,46,27],[43,6,43,13],[23,49,24,74],[23,2,24,44],[27,67,27,73],[20,41,20,51],[28,49,28,55],[27,49,27,55],[42,15,42,19],[41,6,41,13],[42,6,42,13],[40,22,40,27],[41,22,41,27],[32,67,32,73],[34,67,35,73],[40,6,40,13],[34,49,35,55],[34,58,35,64],[40,38,40,44],[40,30,40,35],[31,22,31,27],[32,22,32,27],[34,15,35,19],[36,67,37,73],[32,49,32,55],[41,38,41,44],[46,15,46,19],[41,15,41,19],[44,15,44,19],[47,15,47,19],[42,30,42,35],[42,38,42,44],[45,15,45,19],[45,38,45,44],[43,22,43,27],[44,22,44,27],[34,30,35,35],[34,38,35,44],[43,50,53,73],[40,49,41,57],[46,38,46,44],[47,30,47,35],[41,30,41,35],[53,30,53,35],[52,38,52,44],[53,38,53,44],[37,28,38,44],[36,58,38,64],[36,50,38,55],[43,38,43,44],[43,30,43,35],[44,30,44,35],[44,38,44,44],[31,58,31,64],[32,58,32,64],[21,59,22,74],[18,67,18,70],[20,67,20,70],[20,12,20,17],[10,67,10,70],[12,67,12,70],[14,67,14,70],[30,49,30,55],[31,49,31,55],[16,41,16,51],[18,41,18,51],[10,26,10,38],[28,67,28,73],[30,67,30,73],[31,67,31,73],[28,58,28,64],[27,58,27,64],[30,58,30,64],[10,41,10,51],[12,41,12,51],[26,49,26,74],[12,18,12,24]]}
[null,"HEU & H2020 Budgetmall Marie Skłodowska-Curie Actions",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,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,"Version: 240221"]
[null,"Löneavgift gällande:",null,null,null,null,null,null,null,null,"2024-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,"Doktorandstegen:",null,null,null,null,null,null,null,"2023-10-01"]
[]
[null,"Work program: ",null,null,null,null,null,null,null,null,"H2020: 2014-2015",null,null,null,null,null,null,null,null,"2016-2017",null,null,null,null,null,"2018-2020",null,null,null,null,null,"Horizon Europe: 2021-2024"]
[]
[null,null,"Ange förutsättningarna",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,"Värden som används"]
[]
[]
[null,null,"Mallens funktion",null,null,null,null,null,null,null,null,null,"Budgetering"]
[]
[null,null,"Work Programme",null,null,null,null,null,null,null,null,null,"2021-2024",null,null,null,null,null,"Åldersgrupp",null,null,null,null,null,null,null,"Lön till anställda födda 1988-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Justerings-koefficient",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_koeficient","v":1.254},null,null,null,null,null,"Löneavgift Living",null,null,null,null,null,null,null,{"$f":"UT_LKP_living*100&\" %\"","v":"58 %"}]
[]
[null,null,"Typ av projekt",null,null,null,null,null,null,null,null,null,"IF/PF",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,"Living allowance (ej justerat)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_living_allowance","v":5080},null,null,null,null,null,"Löneavgift Mobility",null,null,null,null,null,null,null,{"$f":"UT_LKP_mobility*100&\" %\"","v":"58 %"}]
[]
[null,null,"Antal månader",null,null,null,null,null,null,null,null,null,36,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,"Mobility allowance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_mobility_allowance","v":600},null,null,null,null,null,"Löneavgift Family",null,null,null,null,null,null,null,{"$f":"UT_LKP_family*100&\" %\"","v":"58 %"}]
[]
[null,null,"Växelkurs (SEK/€)",null,null,null,null,null,null,null,null,null,10,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,"Family allowance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_family_allowance","v":660},null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),\"Ingångslön*\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),29700*(1+UT_LKP_living),\"\")","v":""}]
[]
[null,null,"Family allowance",null,null,null,null,null,null,null,null,null,"Ja",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(errorlevel>0,\"Varning! Minst en (1) förutsättning är inte ifylld!\",IF(UT_LKP_living=0,\"Varning! Semesterdagar och åldersgrupp inte kompatibla!\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Research, training, networking",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_research","v":1000},null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),\"50% uppnåtts*\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),30900*(1+UT_LKP_living),\"\")","v":""}]
[]
[null,null,{"$f":"IF(AND(typ.projekt=ITN),\"Doktorandnivå\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Ingångslön",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,"Management & Indirect costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_mgt_IDC","v":650},null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),\"80% uppnåtts*\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),32800*(1+UT_LKP_living),\"\")","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(typ.projekt=ITN),\"*= Bruttolön + löneavgift enl. doktorandstegen fr. 2021-10-01\",\"\")","v":""}]
[]
[null,null,"Bidrag till MSCA-forskaren",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,{"$f":"IF(Funktion=\"Avstämning/Tilläggsbetalning\",\"Avstämning/Tilläggsbetalning (SEK)\",\"\")","v":""}]
[]
[]
[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,null,null,{"$f":"IF(AND(Funktion=\"Avstämning/Tilläggsbetalning\",typ.projekt=\"ITN\",svar.doktorandstegen=\"Nej\"),\"Tillägg måste göras för doktorandstegen!!!\",\"\")","v":""}]
[null,null,null,null,null,null,"Allowance",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,{"$f":"IF(Funktion=Avstamning,\"Bokförd lönekostnad\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,\"Avvikelse\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,\"Exklusive\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,"HELA PERIODEN",null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,null,"HELA PERIODEN",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,\"HELA PERIODEN\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,\"Lönekostnader\",\"\")","v":""}]
[]
[null,null,null,null,null,null,"Living",null,null,null,null,null,null,null,null,{"$f":"UT_living_allowance*UT_koeficient","v":6370.32},null,null,null,null,null,null,{"$f":"P31*manader","v":229331.52},null,null,null,null,null,null,null,{"$f":"ROUND(P31*vaxelkurs,0)","v":63703},null,null,null,null,null,null,null,{"$f":"AE31*manader","v":2293308},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,AX31-AM31,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,BG31/(1+UT_LKP_living),\"\")","v":""}]
[null,null,null,null,null,null,"Mobility",null,null,null,null,null,null,null,null,{"$f":"UT_mobility_allowance","v":600},null,null,null,null,null,null,{"$f":"P32*manader","v":21600},null,null,null,null,null,null,null,{"$f":"ROUND(P32*vaxelkurs,0)","v":6000},null,null,null,null,null,null,null,{"$f":"AE32*manader","v":216000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,AX32-AM32,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,BG32/(1+UT_LKP_mobility),\"\")","v":""}]
[null,null,null,null,null,null,"Family",null,null,null,null,null,null,null,null,{"$f":"IF(familj=\"ja\",UT_family_allowance,0)","v":660},null,null,null,null,null,null,{"$f":"P33*manader","v":23760},null,null,null,null,null,null,null,{"$f":"ROUND(P33*vaxelkurs,0)","v":6600},null,null,null,null,null,null,null,{"$f":"AE33*manader","v":237600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,AX33-AM33,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Funktion=Avstamning,BG33/(1+UT_LKP_family),\"\")","v":""}]
[]
[null,null,null,null,null,null,"SUMMA",null,null,null,null,null,null,null,null,{"$f":"SUM(P31:T33)","v":7630.32},null,null,null,null,null,null,{"$f":"SUM(W31:AB33)","v":274691.52},null,null,null,null,null,null,null,{"$f":"SUM(AE31:AI33)","v":76303},null,null,null,null,null,null,null,{"$f":"SUM(AM31:AR33)","v":2746908}]
[]
[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,null,null,null,{"$f":"IF(AND(Funktion=\"Avstämning/Tilläggsbetalning\",typ.projekt=\"ITN\"),\"Lön har betalats minst i nivå med doktorandstegen\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Funktion=\"\",\"\",IF(Funktion=\"Budgetering\",\"\",IF(OR(BG31<0,BG32<0,BG33<0),\"För lite har betalats i minst en (1) kategori\",IF(OR(BG31>0,BG32>0,BG33>0),\"''För mycket'' har betalats i minst en (1) kategori\",\"\"))))","v":""}]
[null,null,null,null,null,null,"Fördelning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(doktorandniva=\"\",\"\",IF(AND(typ.projekt=ITN,doktorandniva=niva.ingangslon,kr.manad<kr.ingangslon),\"Ingångs-doktorandlönen inkl LKP (\"&kr.ingangslon&\" kr) är högre än living allowance inkl. LKP (\"&kr.manad&\" kr).\",IF(AND(typ.projekt=ITN,doktorandniva=niva.50,kr.manad<kr.50),\"50%-nivå för doktorandlönen inkl LKP (\"&kr.50&\" kr) är högre än living allowance inkl. LKP (\"&kr.manad&\" kr).\",IF(AND(typ.projekt=ITN,doktorandniva=niva.80,kr.manad<kr.80),\"80%-nivån för doktorandlönen inkl LKP (\"&kr.80&\" kr) är högre än living allowance inkl. LKP (\"&kr.manad&\" kr).\",\"\"))))","v":""}]
[]
[]
[null,null,"LIVING",null,null,null,"Bruttolön",null,null,null,null,null,null,null,null,{"$f":"P31/(1+UT_LKP_living)","v":4031.8481012658226},null,null,null,null,null,null,{"$f":"P41*manader","v":145146.5316455696},null,null,null,null,null,null,null,{"$f":"ROUND(P41*vaxelkurs,0)","v":40318},null,null,null,null,null,null,null,{"$f":"AE41*manader","v":1451448},null,null,null,null,null,null,null,null,null,null,"Anteckningar"]
[null,null,null,null,null,null,{"$f":"\"Löneavgift (\"&UT_LKP_living*100&\"%)\"","v":"Löneavgift (58%)"},null,null,null,null,null,null,null,null,{"$f":"P41*UT_LKP_living","v":2338.4718987341771},null,null,null,null,null,null,84184.988354430374,null,null,null,null,null,null,null,23385,null,null,null,null,null,null,null,841860]
[]
[null,null,"MOBILITY",null,null,null,"Brutto",null,null,null,null,null,null,null,null,{"$f":"P32/(1+UT_LKP_mobility)","v":379.74683544303798},null,null,null,null,null,null,13670.886075949367,null,null,null,null,null,null,null,3797,null,null,null,null,null,null,null,136692,null,null,null,null,null,null,null,null,null,null,null,"Här går det bra att skriva anteckningar.\n\nOm du vill göra ny rad är det bara att använda [Alt]+[Enter]\n\nTips är att spara denna fil vid budgetering och göra en ny vid avstämningen.\nLycka till!"]
[null,null,null,null,null,null,{"$f":"\"Löneavgift (\"&UT_LKP_mobility*100&\"%)\"","v":"Löneavgift (58%)"},null,null,null,null,null,null,null,null,{"$f":"P44*UT_LKP_mobility","v":220.25316455696202},null,null,null,null,null,null,7929.1139240506327,null,null,null,null,null,null,null,2203,null,null,null,null,null,null,null,79308]
[]
[null,null,"FAMILY",null,null,null,"Brutto",null,null,null,null,null,null,null,null,{"$f":"P33/(1+UT_LKP_family)","v":417.72151898734177},null,null,null,null,null,null,15037.974683544304,null,null,null,null,null,null,null,4177,null,null,null,null,null,null,null,150372]
[null,null,null,null,null,null,{"$f":"\"Löneavgift (\"&UT_LKP_family*100&\"%)\"","v":"Löneavgift (58%)"},null,null,null,null,null,null,null,null,{"$f":"P47*UT_LKP_family","v":242.2784810126582},null,null,null,null,null,null,8722.0253164556962,null,null,null,null,null,null,null,2423,null,null,null,null,null,null,null,87228]
[]
[null,null,"SUMMA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53+P54+P55","v":7630.32},null,null,null,null,null,null,{"$f":"W53+W54+W55","v":274691.51999999996},null,null,null,null,null,null,null,{"$f":"AE53+AE54+AE55","v":76303},null,null,null,null,null,null,null,{"$f":"AM53+AM54+AM55","v":2746908}]
[]
[]
[null,null,"Varav",null,null,null,"Brutto",null,null,null,null,null,null,null,null,{"$f":"P41+P44+P47","v":4829.316455696202},null,null,null,null,null,null,{"$f":"P53*manader","v":173855.39240506326},null,null,null,null,null,null,null,{"$f":"ROUND(P53*vaxelkurs,0)","v":48293},null,null,null,null,null,null,null,{"$f":"AE53*manader","v":1738548}]
[null,null,null,null,null,null,"Löneavgift",null,null,null,null,null,null,null,null,{"$f":"P42+P45+P48","v":2801.0035443037973},null,null,null,null,null,null,{"$f":"P54*manader","v":100836.1275949367},null,null,null,null,null,null,null,{"$f":"ROUND(P54*vaxelkurs,0)","v":28010},null,null,null,null,null,null,null,{"$f":"AE54*manader","v":1008360}]
[]
[]
[]
[]
[null,null,"Bidrag till institutionen (värden)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,"HELA PERIODEN",null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,null,"HELA PERIODEN"]
[]
[null,null,"Research/training/networking",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_research","v":1000},null,null,null,null,null,null,{"$f":"P66*manader","v":36000},null,null,null,null,null,null,null,{"$f":"ROUND(P66*vaxelkurs,0)","v":10000},null,null,null,null,null,null,null,{"$f":"AE66*manader","v":360000}]
[null,null,"Management & Indirect cost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UT_mgt_IDC","v":650},null,null,null,null,null,null,{"$f":"P67*manader","v":23400},null,null,null,null,null,null,null,{"$f":"ROUND(P67*vaxelkurs,0)","v":6500},null,null,null,null,null,null,null,{"$f":"AE67*manader","v":234000}]
[]
[null,null,"SUMMA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P66:T67)","v":1650},null,null,null,null,null,null,{"$f":"SUM(W66:AB67)","v":59400},null,null,null,null,null,null,null,{"$f":"SUM(AE66:AI67)","v":16500},null,null,null,null,null,null,null,{"$f":"SUM(AM66:AR67)","v":594000}]
[]
[]
[]
[]
[null,null,"Totalt bidrag"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,"HELA PERIODEN",null,null,null,null,null,null,null,"PER MÅNAD",null,null,null,null,null,null,null,"HELA PERIODEN"]
[]
[null,null,"Till MSCA-forskaren",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35","v":7630.32},null,null,null,null,null,null,{"$f":"W35","v":274691.52},null,null,null,null,null,null,null,{"$f":"ROUND(P81*vaxelkurs,0)","v":76303},null,null,null,null,null,null,null,{"$f":"AE81*manader","v":2746908}]
[null,null,"Till insitutionen",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P69","v":1650},null,null,null,null,null,null,{"$f":"W69","v":59400},null,null,null,null,null,null,null,{"$f":"ROUND(P82*vaxelkurs,0)","v":16500},null,null,null,null,null,null,null,{"$f":"AE82*manader","v":594000}]
[]
[null,null,"SUMMA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P81:T82)","v":9280.32},null,null,null,null,null,null,{"$f":"SUM(W81:AB82)","v":334091.52000000002},null,null,null,null,null,null,null,{"$f":"SUM(AE81:AI82)","v":92803},null,null,null,null,null,null,null,{"$f":"SUM(AM81:AR82)","v":3340908}]

{"sheet":"Samfinansiering","index":2,"n_rows":41,"n_cols":60,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,38,22,43],[32,45,33,51],[32,53,33,58],[29,54,29,58],[40,29,51,58],[30,46,30,51],[30,53,30,58],[30,27,30,43],[28,53,28,58],[28,27,28,43],[29,27,29,43],[29,46,29,51],[27,53,27,58],[12,46,13,51],[28,46,28,51],[16,45,16,51],[18,45,18,51],[20,45,20,51],[22,45,22,51],[24,45,24,51],[17,45,17,51],[19,45,19,51],[21,45,21,51],[23,45,23,51],[28,4,51,23],[12,18,12,24],[12,27,12,29],[12,38,12,43],[12,13,12,16],[12,2,12,11],[32,27,33,43],[16,2,16,29],[17,2,17,29],[18,2,18,29],[19,2,19,29],[20,2,20,29],[21,2,21,29],[22,2,22,29],[23,2,23,29],[24,2,24,29],[2,2,3,21],[27,46,27,51],[24,38,24,43],[6,38,6,43],[7,38,7,43],[9,38,9,43],[16,38,16,43],[18,38,18,43],[20,38,20,43],[15,2,15,29],[6,46,6,51],[7,18,7,24],[9,2,9,9],[9,18,9,24],[9,46,9,51],[9,27,9,29]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MSCA!BW1","v":"Version: 240221"}]
[]
[null,null,"Uppskattning av samfinansiering"]
[]
[]
[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,"Institutionens",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Institutionens"]
[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,"% indirekta kostnader",null,null,null,null,null,null,null,null,null,null,"indirekta",null,null,null,null,null,null,null,"Total kostnad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HELA PERIODEN",null,null,null,null,null,null,null,null,"som belastar projektet",null,null,null,null,null,null,null,null,null,null,"kostnader",null,null,null,null,null,null,null,null,null,null,null,null,"(direkta+indirekta)"]
[]
[null,null,"Allowances (alla)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((UT_living_allowance*UT_koeficient)+UT_mobility_allowance+IF(familj=\"ja\",UT_family_allowance,0))*manader*vaxelkurs","v":2746915.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S10*AB10","v":0},null,null,null,null,null,null,null,{"$f":"S10+AM10","v":2746915.2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lönekostnader utöver bidraget från EU"]
[null,null,"Inriktning bruttolön",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(bruttolon>Bidrag.bruttolon,(bruttolon-Bidrag.bruttolon)*(100%+UT_LKP_living)*manader,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S13*AB13","v":0},null,null,null,null,null,null,null,{"$f":"S13+AM13","v":0}]
[null,null,{"$f":"IF(bruttolon<Bidrag.bruttolon,\"Bidraget till bruttolönen är \"&Bidrag.bruttolon&\" kr och ingår i ''Allowances (alla)'' lönedelar utöver det läggs till på rad 2\",\"Lönekostnader utöver bidraget från EU\")","v":"Bidraget till bruttolönen är 40318 kr och ingår i ''Allowances (alla)'' lönedelar utöver det läggs till på rad 2"}]
[]
[null,null,"Övriga planerade direkta kostnader (ex. training, network, traveling, research)"]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[]
[]
[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,"Summa",null,null,{"$f":"IFERROR(AU10+AU13+SUM(AT17:AZ25),\"\")","v":2746915.2},null,null,null,null,null,null,{"$f":"IFERROR(AU28/vaxelkurs,\"\")","v":274691.52}]
[null,null,null,null,"FÖLJ CHECKLISTAN PÅ INSTRUKTIONS-SIDAN!\n\nINFORMATION\nUppskattningen av samfinansieringsbehovet baseras på bruttolönen, angiven växelkurs samt rådande nivå (%) för indirekta kostnader (OH) på institutionen.\n\nLivinga allowance är ett BIRDAG till personalkostnaderna och lönebildning ska ske enligt SU:s normala regelverk.\n\nÖvriga planerade direkta kostnader måste också anges. \n\nOH beräknas enligt SUHF-modellen\n\nOsäkerheten/risken ligger i skillnaden mellan växelkursen som används i beräkning och den slutliga, faktiska, växelkursen.\n\n*) OBS!\nFör ITN kan den som koordinerar projektet ta del av den budget för management som varje beneficiary får. Då måste vi ange hur mycket det är för att få en rättvisande bild. OM vi inte vet hur mycket koordinatorn tänker ta så är det en rekommendation att räkna med 30% av \"Management & Indirect cost\". Dock kan det faktiska avdraget såklart bli mindre eller större. Frågan kan väckas till koordinatorn vid ansökan för att få en mer rättvisande uppskattning för samfinasieringen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summa från EU (enligt GA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB29*vaxelkurs","v":3340915.2},null,null,null,null,null,null,{"$f":"MSCA!W35+MSCA!W69","v":334091.52000000002}]
[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,{"$f":"IF(typ.projekt=\"ITN\",\"*) Fyll i beloppet som koordinatorn behåller =>\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC30*vaxelkurs","v":0}]
[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,"Belopp till SU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB31*vaxelkurs","v":3340915.2},null,null,null,null,null,null,{"$f":"BB29-BC30","v":334091.52000000002}]
[]
[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,"Uppskattad samfinansiering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AU28-AU31,\"\")","v":-594000},null,null,null,null,null,null,null,{"$f":"IFERROR(AT33/vaxelkurs,\"\")","v":-59400}]
[]
[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,null,null,null,null,{"$f":"IF(AT33=\"\",\"Något är fel, ingen beräkning av samfinansiering kan göras.\",IF(AT33<0,\"Vid minus (-) behövs ingen medfinansiering (under rådande växelkurs)\",\"Projektet måste medfinasieras\"))","v":"Vid minus (-) behövs ingen medfinansiering (under rådande växelkurs)"}]
[]
[]
[]
[]
[]
[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,"Här går det bra att skriva anteckningar.\n\nOm du vill göra ny rad är det bara att använda [Alt]+[Enter]\n\nLycka till!"]

{"sheet":"Calc","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":true,"merged":[[29,9,30,10]]}
[]
[null,null,null,null,"Funktion",{"$f":"Funktion","v":"Budgetering"}]
[null,null,"Input","RAD","Work Package",{"$f":"WP","v":"2021-2024"},{"$f":"IF(F3=WP_1,2,IF(F3=WP_2,3,IF(F3=WP_3,4,5)))","v":5}]
[null,null,null,"MATRIX","Typ av projekt",{"$f":"typ.projekt","v":"IF/PF"}]
[null,null,null,null,"Antal månader",{"$f":"manader","v":36}]
[null,null,null,null,"Växelkurs",{"$f":"vaxelkurs","v":10}]
[]
[null,null,null,"MATRIX"]
[null,null,null,"RAD",{"$f":"MSCA!S11","v":"Åldersgrupp"},{"$f":"Aldersgrupp","v":"Lön till anställda födda 1988-"},{"$f":"IF(AND(Funktion=Avstamning,Aldersgrupp=aldersgrupp.1),2,IF(AND(Funktion=Avstamning,aldersgrupp.2),3,IF(AND(Funktion=Budgetering,Aldersgrupp=aldersgrupp.1),4,5)))","v":5},{"$f":"IF(AND(Funktion=Avstamning,Aldersgrupp=aldersgrupp.1),1,IF(AND(Funktion=Avstamning,aldersgrupp.2),2,IF(AND(Funktion=Budgetering,Aldersgrupp=aldersgrupp.1),3,4)))","v":4}]
[]
[null,null,null,null,"Family allowance",{"$f":"familj","v":"Ja"}]
[]
[null,null,2,3,4,5,6,7,2,3,4]
[null,null,"Koefficient","Living allowance","Mobility allowance","Family allowance","Research, training, networking","Management & Indirect costs","LKP living","LKP mobility","LKP family"]
[null,"Utput",{"$f":"IF($F$4=ITN,INDEX(tabell.ITN,$G$3,C13),INDEX(tabell.IF,$G$3,C13))","v":1.254},5080,600,660,1000,650,{"$f":"INDEX(tabell.LKP,$G$9,I13)","v":0.57999999999999996},{"$f":"INDEX(tabell.LKP,$G$9,J13)","v":0.57999999999999996},{"$f":"INDEX(tabell.LKP,$G$9,K13)","v":0.57999999999999996}]
[]
["ITN/DN"]
[null,"År","Koefficient","Living allowance","Mobility allowance","Family allowance","Research, training, networking","Management & Indirect costs"]
[null,"2014-2015",1.117,3110,600,500,1800,1200]
[null,"2016-2017",1.117,3110,600,500,1800,1200]
[null,"2018-2020",1.218,3270,600,500,1800,1200]
[null,"2021-2024",1.254,3400,600,660,1600,1200]
[]
["IF/PF"]
[null,"År","Koefficient","Living allowance","Mobility allowance","Family allowance","Research, training, networking","Management & Indirect costs"]
[null,"2014-2015",1.117,4650,600,500,800,650]
[null,"2016-2017",1.117,4650,600,500,800,650]
[null,"2018-2020",1.218,4880,600,500,800,650]
[null,"2021-2024",1.254,5080,600,660,1000,650]
[null,null,null,null,null,null,null,null,null,"mobility+family genererar inte semestertillägg"]
[]
[]
[null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,null,null,1,"Tabell ALLA","LKP living","LKP mobility","LKP family"]
[null,null,"Error-koll",null,null,"Använda åldersgrupp?",2,{"$f":"aldersgrupp.1","v":"Lön till anställda födda 1953-1987"},0.55800000000000005,0.55800000000000005,0.55800000000000005]
[null,null,"Om något indata saknas",null,null,"Nej",3,{"$f":"aldersgrupp.2","v":"Lön till anställda födda 1988-"},0.55800000000000005,0.55800000000000005,0.55800000000000005]
[null,"Funktion",{"$f":"IF(Funktion=0,1,\"\")","v":""},null,null,null,4,{"$f":"aldersgrupp.3","v":"BUDGET anställda födda 1953-1987"},0.57999999999999996,0.57999999999999996,0.57999999999999996]
[null,"WP",{"$f":"IF(WP=0,1,\"\")","v":""},null,null,null,5,{"$f":"aldersgrupp.4","v":"BUDGET anställda födda 1988-"},0.57999999999999996,0.57999999999999996,0.57999999999999996]
[null,"Projekttyp",{"$f":"IF(typ.projekt=0,1,\"\")","v":""},null,null,null,6]
[null,"Månader",{"$f":"IF(manader=0,1,\"\")","v":""},null,null,null,7]
[null,"Växelkurs",{"$f":"IF(vaxelkurs=0,1,\"\")","v":""},null,null,null,8]
[null,null,null,null,null,null,9]
[null,null,null,null,null,null,10]
[null,"Åldersgrupp",{"$f":"IF(Aldersgrupp=0,1,\"\")","v":""},null,null,null,11]
[null,null,null,null,null,null,12]
[null,"Familje allow",{"$f":"IF(familj=0,1,\"\")","v":""},null,null,null,13]
[]
[]
[]
[]
[]
[]
[]
[null,"SUMMA",{"$f":"SUM(C37:C53)","v":0}]

{"sheet":"Def","index":4,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"LEGEND","Lista"]
[]
[null,null,"Work Package",null,"Typ av projekt",null,null,null,null,null,null,null,"Family allowance",null,"År för löneavgift"]
[null,null,"2014-2015",null,"ITN/DN",null,null,null,null,null,null,null,"Ja",null,2010]
[null,null,"2016-2017",null,"IF/PF",null,null,null,null,null,null,null,"Nej",null,2011]
[null,null,"2018-2020",null,null,null,null,null,null,null,null,null,null,null,2012]
[null,null,"2021-2024",null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,null,null,null,null,null,"Åldersgrupper",null,"Mallens funktion",null,"Doktorandnivå",null,"Doktorandstegen",null,"2015-01-01 -- 2015-04-30"]
[null,null,null,null,null,null,"Lön till anställda födda 1953-1987",null,"Budgetering",null,"Ingångslön",null,"Ja",null,"2015-05-01 -- 2015-07-31"]
[null,null,null,null,null,null,"Lön till anställda födda 1988-",null,"Avstämning/Tilläggsbetalning",null,"50% uppnåtts",null,"Nej",null,"2015-08-01 -- 2015-12-31"]
[null,null,null,null,null,"kanske inte behövs","BUDGET anställda födda 1953-1987",null,null,null,"80% uppnåtts",null,null,null,"2016-01-01 -- 2016-05-31"]
[null,null,null,null,null,"kanske inte behövs","BUDGET anställda födda 1988-",null,null,null,null,null,null,null,"2016-06-01 -- 2016-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[]
[]
[null,null,"När nytt WP läggs till måste det definieras enligt \"WP_X\" samt att WP-listan måste expandera att inkludera det nya WP:et"]