{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instruktion","Exempel","Löneberäkning","Timmar","Def"],"not_rendered":{"charts":0,"images":12,"macros":0,"external_links":0,"defined_names":56,"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":"Instruktion","index":0,"n_rows":235,"n_cols":24,"rows_kept":235,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mallversion: 2023-11-01"]
[null,"Instruktion löneberäkningsmall"]
[]
[null,"Redigera celler"]
[]
[null,"Skriv in data/värden i vita celler"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mallen har tillskapats på"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Avdelningen för forsknings-"]
[null,null,null,null,null,null,null,null,null,null,null,null,"och samverkansstöd /DB2023"]
[]
[]
[]
[]
[]
[null,"Beräkningar görs automatiskt i de blå cellerna"]
[]
[]
[null,"Definiera namn på personer"]
[]
[null,"Namn på personer i projektet definieras under \"Namn\" i fliken \"Löneberäkning\"."]
[null,"Dessa namn finns sedan i tabellen för timmar i fliken \"Timmar\" och"]
[null,"de finns också i rullgardinsmenyn under namn vid beräkning av dagsekvivalenter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Här definieras namnen =>"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Vid beräkning av dagsekvivaleter finns namnen i rullgardinsmenyn."]
[null,null,null,null,null,null,null,null,null,"Det är viktigt att namnen alltid skrive på samma sätt så att "]
[null,null,null,null,null,null,null,null,null,"mallen kan hitta all data som tillhör en viss person."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"I rubriken i fliken \"Timmar\" återfinns också alla personer med en"]
[null,null,null,null,null,null,null,null,null,"egen kolumn för timmar jobbade i projektet."]
[]
[]
[]
[]
[]
[null,"Steg 1 - Ange data för projektet och personer"]
[]
[null,"I fliken \"Löneberäkning\" anger du datum för rapporteringsperioden mm",null,null,null,null,null,null,null,"I listan med 20 celler anger du personernas namn som ska löneberäknas."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Det är viktigt att ange rapporteringsperiodens omfattning"]
[null,"för att beräkningarna ska bli rätt."]
[]
[null,"Om du behöver mer hjälp med att fylla i mallen så klicka för att"]
[null,"\"Visa hjälptexter\" så visas ytterligare hjälp."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Steg 2 - Beräkna dagsekvivaleter (MDD - maximum declarable days)"]
[]
[null,"I fliken \"löneberäkning\" så beräknas dagsekvivalenterna för varje person i projektet. Ange personen namn under \"namn\" (rullgardinsmeny) för varje rad som rör personen."]
[null,"Ange period som personen varit anställd under redovisningsperioden genom att fylla i \"Fr.o.m\" samt \"T.o.m.\" och ange att beräkningsraden avser \"Heltid/Deltid\"."]
[null,"Om personen anställdes under redovisningsperioden så anger du första anställningsdag. Om personen jobbade resten av redovisningsperioden så ange periodens"]
[null,"sista dag som \"T.o.m.\". Ange inte datum utanför redovisningsperioden. Om personen var anställd när redovisningsperioden började, så ange redovisningsperiodens"]
[null,"första dag i \"Fr.o.m\". Det ska inte gå att lägga in datum som ligger untanför rapporteringsperioden, men det är alltid upp till den enskilde användaren att kontrollera att det är rätt."]
[]
[null,"Ange anställningsgrad på SU."]
[null,"Om anställningsraden varierat under redovisningsperioden använd en rad per sammanhållen period med en viss anställningsgrad."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Det finns en rullgardinsmeny för att välja mellan \"Heltid/Deltid\" samt \"Föräldraledighet\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Föräldraledighet"]
[]
[null,"Dagar som personen varit föräldraledig (ej VAB) ska anges för att minska antalet produktiva dagar (pro-rata av maximum declarable days)."]
[null,"Ange perioden (\"Fr.o.m.\" och \"T.o.m.\") samt att det avser föräldraledighet och graden av föräldraledighet."]
[]
[null,"OBS!"]
[null,"Om det är så att en person varit deltidsanställd och deltidsföräldraledig under en och samma period behöver beräkningar ske manuellt."]
[null,"Kontakta projektekonomerna vid Avdelningen för forsknings- och samverkansstöd på förvaltningen för hjälp."]
[]
[null,"Steg 3 - Lägg in timmar från tidrapporteringen"]
[]
[null,"I fliken \"Timmar\" anger du de rapporterade timmarna från tidrapporterna under respektive månad."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Steg 4 - Lägg in uppgifter om lön"]
[]
[null,"I fliken \"Löneberäkning\" anger du hur stor lönekostnaden har varit för respektive person under rapporteringsperioden. Hela lönen på SU ska anges."]
[null,"Här inkluderar du alla godkända lönekostnader (ex. inkl. LKP, föräldraledighet, sjuklön, Kåpan, friskvård etc). Om du är osäker på vad som ingår så"]
[null,"konsultera lathunden."]
[]
[]
[]
[]
[null,null,null,null,null,"TAK!",null,null,null,null,null,null,null,null,null,null,null,null,"TAK!"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mallen beräknar"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Om det är gröna celler betyder det att SU har rapporterat"]
[null,"Mallen räknar ut värdet i de blå cellerna automatiskt",null,null,null,null,null,null,null,null,null,null,"FLER dagar/timmar än de som är maximalt tillåtet."]
[null,"Dagskostnaden är lönen delat på antal dagar.",null,null,null,null,null,null,null,null,null,null,"Mallen anger att vi rapporterar upp till taket för antal dagar.",null,null,null,null,null,null,null,null,null,null,"Mallen anger vilket belopp vi kan rapportera för respektive person"]
[]
[null,"Timmarna från tidrapporten förs in automatiskt och",null,null,null,null,null,null,null,null,null,null,"Om det är röda celler betyder det att vi inte rapporterat tillräckligt"]
[null,"omvandlas till motsvarande dagar (delas med 8).",null,null,null,null,null,null,null,null,null,null,"många dagar/timmar för att kunna rapportera maximal lönekostnad."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vi får bara rapportera det som är LÄGST av taket och"]
[null,null,null,null,null,null,null,null,null,null,null,null,"våra faktiska dagar/timmar i projektet."]
[]
[]
[]
[null,"Varningar"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Om det anges ett utropstecken så beror det på att"]
[null,"det angivits färre månader för den anställde än rapporteringsperiodens längd."]
[null,"Det kan vara helt i sin ordning om personen inte var anställd på SU under hela rapporteringsperioden."]
[null,"Om cellen är röd så har det angivits fler månader än vad som finns i rapporteringsperioden."]
[null,"Detta måste rättas."]
[]
[]
[null,"Utskrift"]
[]
[null,"Det är förinställt att skriva ut de flesta flikar i denna kalkylbok på A3 för att få en sammanhållande överblick över datan."]
[null,"Det är rekommenderat att skriva ut på detta större pappersformat."]

{"sheet":"Exempel","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Exempel"]

{"sheet":"Löneberäkning","index":2,"n_rows":139,"n_cols":16,"rows_kept":139,"cut":false,"hidden":false,"merged":[[4,11,6,15],[1,1,6,4]]}
[]
[null,"Löneberäkning Horizon Europe",null,null,null,null,null,"Projektakronym:",null,null,null,{"$f":"version","v":"Mallversion: 2023-11-01"}]
[null,null,null,null,null,null,null,"Rapporteringsperiod nr.:"]
[null,null,null,null,null,null,null,{"$f":"IF(start.date=\"\",\"***Ange startdatum***\",\"Startdatum\")","v":"***Ange startdatum***"}]
[null,null,null,null,null,null,null,{"$f":"IF(end.date=\"\",\"***Ange slutdatum***\",\"Slutdatum\")","v":"***Ange slutdatum***"},null,null,null,{"$f":"I2&\"-RP\"&I3","v":"-RP"}]
[null,null,null,null,null,null,null,"Antal månader i perioden",{"$f":"IF(ROUND((end.date-start.date)/(365/12),0)<=0,\"\",ROUND((end.date-start.date)/(365/12),0))","v":""}]
[]
[null,null,null,null,null,null,null,null,true]
[null,"Här definierar du med namn de personer (en rad per person) som ska löneberäknas. \nBra att börja här.","[Automatiskt summering av personens antal månader som finns med i beräkningen av dagar]","[Automatisk summering av personens arbetsdagar under perioden. Samtliga personen rader från talbellen nedan.]","Här anger du hur mycket lön som personen fått från hela SU (inte bara konteringen) för perioden.","[Automatisl beräkning av lönebelopp delat med MDD ]","[Automatiskt koppling till timmarna som är angivna i flik för timmar]","[Automatisk beräkning av hur många dagar som timmarna i tidrapporten motsvarar]","[Automatiskt anges hur mycket mer eller mindre dagar som jobbats än MDD]","[Automatisk beräkning av motsvarande antal timmar för kolumnen innan]","[Automatisk information om hur många dagar som ska rapporteras. Lägsta antalet]","[Automatisk beräkning av personalkostnadstaket. \nDagar x dagskostnaden]","Här anger du hur mycket lön som har bokförts på projektet i ekonomisystemet. Om lön kan flyttas så gör det först och sedan uppdatera datan i cellen.","[Automatisk redovisning som är det lägre beloppet av bokförd kostnad och lönetaket]","[Automatisk beräkning av hur mycket mer som kan rapporteras i fall dessa lönemedel kan flyttas/ombokas till projektet i ekonomisystemet]"]
[null,"Namn","Totalt antal månader hel eller deltidsanställd på SU","Maximum Declarable Day-equvivalent (MDD)","Lön under perioden från SU","Daily rate\n(kr/dag)","Timmar i tidrapporter","Motsvarar dagar","Antal dagar avvikelse mot MDD","Antal timmar avvikelse mot maximum","Dagar att rapportera","Personalkostnadstak","Bokfört på projektet under perioden","Kostnad att rapportera","Skillnad bokfört mot taket","Kommentar"]
[1,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E16:E17)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E16:F17)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E16:E17),0.5)","v":0},null,{"$f":"IFERROR(E11/D11,0)","v":0},{"$f":"sum.h.01","v":0},{"$f":"MROUND(G11/hours.per.day,0.5)","v":0},{"$f":"ROUND(H11-D11,2)","v":0},{"$f":"I11*8","v":0},{"$f":"IF(H11>D11,D11,H11)","v":0},{"$f":"IFERROR(F11*K11,0)","v":0},null,{"$f":"IF(M11>L11,L11,M11)","v":0},{"$f":"IFERROR(ROUND(L11-M11,2),0)","v":0}]
[2,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E18:E19)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E18:F19)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E18:E19),0.5)","v":0},null,0,{"$f":"sum.h.02","v":0},0,0,0,0,0,null,{"$f":"IF(M12>L12,L12,M12)","v":0},0]
[3,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E20:E21)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E20:F21)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E20:E21),0.5)","v":0},null,0,{"$f":"sum.h.03","v":0},0,0,0,0,0,null,0,0]
[4,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E22:E23)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E22:F23)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E22:E23),0.5)","v":0},null,0,{"$f":"sum.h.04","v":0},0,0,0,0,0,null,0,0]
[5,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E24:E25)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E24:F25)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E24:E25),0.5)","v":0},null,0,{"$f":"sum.h.05","v":0},0,0,0,0,0,null,0,0]
[6,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E26:E27)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E26:F27)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E26:E27),0.5)","v":0},null,0,{"$f":"sum.h.06","v":0},0,0,0,0,0,null,0,0]
[7,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E28:E29)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E28:F29)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E28:E29),0.5)","v":0},null,0,{"$f":"sum.h.07","v":0},0,0,0,0,0,null,0,0]
[8,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E30:E31)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E30:F31)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E30:E31),0.5)","v":0},null,0,{"$f":"sum.h.08","v":0},0,0,0,0,0,null,0,0]
[9,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E32:E33)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E32:F33)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E32:E33),0.5)","v":0},null,0,{"$f":"sum.h.09","v":0},0,0,0,0,0,null,0,0]
[10,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E34:E35)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E34:F35)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E34:E35),0.5)","v":0},null,0,{"$f":"sum.h.10","v":0},0,0,0,0,0,null,0,0]
[11,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E36:E37)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E36:F37)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E36:E37),0.5)","v":0},null,0,{"$f":"sum.h.11","v":0},0,0,0,0,0,null,0,0]
[12,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E38:E39)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E38:F39)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E38:E39),0.5)","v":0},null,0,{"$f":"sum.h.12","v":0},0,0,0,0,0,null,0,0]
[13,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E40:E41)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E40:F41)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E40:E41),0.5)","v":0},null,0,{"$f":"sum.h.13","v":0},0,0,0,0,0,null,0,0]
[14,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E42:E43)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E42:F43)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E42:E43),0.5)","v":0},null,0,{"$f":"sum.h.14","v":0},0,0,0,0,0,null,0,0]
[15,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E44:E45)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E44:F45)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E44:E45),0.5)","v":0},null,0,{"$f":"sum.h.15","v":0},0,0,0,0,0,null,0,0]
[16,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E46:E47)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E46:F47)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E46:E47),0.5)","v":0},null,0,{"$f":"sum.h.16","v":0},0,0,0,0,0,null,0,0]
[17,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E48:E49)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E48:F49)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E48:E49),0.5)","v":0},null,0,{"$f":"sum.h.17","v":0},0,0,0,0,0,null,0,0]
[18,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E50:E51)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E50:F51)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E50:E51),0.5)","v":0},null,0,{"$f":"sum.h.18","v":0},0,0,0,0,0,null,0,0]
[19,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E52:E53)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E52:F53)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E52:E53),0.5)","v":0},null,0,{"$f":"sum.h.19","v":0},0,0,0,0,0,null,0,0]
[20,null,{"$f":"DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E54:E55)-DSUM(Tabell1[#All],Tabell1[[#Headers],[Månader]],Def!E54:F55)","v":0},{"$f":"MROUND(DSUM(Tabell1[#All],Tabell1[[#Headers],[Day-equvivalents]],Def!E54:E55),0.5)","v":0},null,0,{"$f":"sum.h.20","v":0},0,0,0,0,0,null,0,0]
[]
[null,"SUMMA",null,{"$f":"SUM(D11:D30)","v":0},0,null,0,0,null,null,0,{"$f":"SUM(L11:L30)","v":0},0,0,0]
[]
[]
[null,"Beräkning av dagsekvivalenter",null,null,"Läs också informationen i fliken för \"Instruktion\" för hjälp med mallen."]
[]
[null,"Här väljer du namn på personen i rullgardinsmenyn. Det går också att klistra in identisk stavning och/eller fylla nedåt.","Här anger du om du beräkningar arbetsdagar i perioden (Heltid/Deltid) eller gör avdrag för Föräldraledighet. \nOBS! Rullgardinsmeny!","Här anger du första dagen i perioden som har en och samma %. Notera att det är \"Fr.o.m.\".","Här anger du sista dagen i perioden med samma %. Notera att det är \"T.o.m.\".","[Automatisk beräkning av antalet månader. Kan vara mindre än 1]","Här anger du hur stor % anställning personen hade på hela SU eller grad av föräldraledighet.","[Automatisk beräkning av antalet arbetsdagar.]"]
[null,"Namn","Avser","Fr.o.m.","T.o.m.","Månader","%","Day-equvivalents","Kommentar"]
[null,null,null,null,null,{"$f":"IF(D39=\"\",\"\",DAYS360(D39,E39+1)/standard.days.per.month)","v":""},null,{"$f":"IFERROR(IF(C39=Foraldraledighet,prod.days.per.month*-F39*G39,prod.days.per.month*F39*G39),\"\")","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,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",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(D103=\"\",\"\",DAYS360(D103,E103+1)/standard.days.per.month)","v":""},null,{"$f":"IFERROR(IF(C103=Foraldraledighet,prod.days.per.month*-F103*G103,prod.days.per.month*F103*G103),\"\")","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,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]
[null,null,null,null,null,"",null,""]

{"sheet":"Timmar","index":3,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,1,4,5]]}
[]
[null,"Timmar från tidrapporterna",null,null,null,null,"Här fyller du in timmarna som har noterats på projektet genom tidrapportering."]
[null,null,null,null,null,null,"Ange summan av timmar på projektet (alla eventuella WP (work packages))."]
[null,null,null,null,null,null,"Ange timmar per person, en kolumn per person. Namnen ska först fyllas i (definieras) på fliken för löneberäkning."]
[]
[]
[]
[null,"SUMMA timmar",{"$f":"SUM(C11:C71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Månad",{"$f":"employee.01","v":0},{"$f":"employee.02","v":0},{"$f":"employee.03","v":0},{"$f":"employee.04","v":0},{"$f":"employee.05","v":0},{"$f":"employee.06","v":0},{"$f":"employee.07","v":0},{"$f":"employee.08","v":0},{"$f":"employee.09","v":0},{"$f":"employee.10","v":0},{"$f":"employee.11","v":0},{"$f":"employee.12","v":0},{"$f":"employee.13","v":0},{"$f":"employee.14","v":0},{"$f":"employee.15","v":0},{"$f":"employee.16","v":0},{"$f":"employee.17","v":0},{"$f":"employee.18","v":0},{"$f":"employee.19","v":0},{"$f":"employee.20","v":0}]
[0,{"$f":"IF(A11<Löneberäkning!$I$6,EDATE(start.date,A11),\"\")","v":"00:00:00"}]
[1,{"$f":"IF(A12<Löneberäkning!$I$6,EDATE(start.date,A12),\"\")","v":"1900-01-31"}]
[2,{"$f":"IF(A13<Löneberäkning!$I$6,EDATE(start.date,A13),\"\")","v":60}]
[3,{"$f":"IF(A14<Löneberäkning!$I$6,EDATE(start.date,A14),\"\")","v":"1900-03-31"}]
[4,{"$f":"IF(A15<Löneberäkning!$I$6,EDATE(start.date,A15),\"\")","v":"1900-04-30"}]
[5,{"$f":"IF(A16<Löneberäkning!$I$6,EDATE(start.date,A16),\"\")","v":"1900-05-31"}]
[6,{"$f":"IF(A17<Löneberäkning!$I$6,EDATE(start.date,A17),\"\")","v":"1900-06-30"}]
[7,{"$f":"IF(A18<Löneberäkning!$I$6,EDATE(start.date,A18),\"\")","v":"1900-07-31"}]
[8,{"$f":"IF(A19<Löneberäkning!$I$6,EDATE(start.date,A19),\"\")","v":"1900-08-31"}]
[9,{"$f":"IF(A20<Löneberäkning!$I$6,EDATE(start.date,A20),\"\")","v":"1900-09-30"}]
[10,{"$f":"IF(A21<Löneberäkning!$I$6,EDATE(start.date,A21),\"\")","v":"1900-10-31"}]
[11,{"$f":"IF(A22<Löneberäkning!$I$6,EDATE(start.date,A22),\"\")","v":"1900-11-30"}]
[12,{"$f":"IF(A23<Löneberäkning!$I$6,EDATE(start.date,A23),\"\")","v":"1900-12-31"}]
[13,{"$f":"IF(A24<Löneberäkning!$I$6,EDATE(start.date,A24),\"\")","v":"1901-01-31"}]
[14,{"$f":"IF(A25<Löneberäkning!$I$6,EDATE(start.date,A25),\"\")","v":"1901-02-28"}]
[15,{"$f":"IF(A26<Löneberäkning!$I$6,EDATE(start.date,A26),\"\")","v":"1901-03-31"}]
[16,{"$f":"IF(A27<Löneberäkning!$I$6,EDATE(start.date,A27),\"\")","v":"1901-04-30"}]
[17,{"$f":"IF(A28<Löneberäkning!$I$6,EDATE(start.date,A28),\"\")","v":"1901-05-31"}]
[18,{"$f":"IF(A29<Löneberäkning!$I$6,EDATE(start.date,A29),\"\")","v":"1901-06-30"}]
[19,{"$f":"IF(A30<Löneberäkning!$I$6,EDATE(start.date,A30),\"\")","v":"1901-07-31"}]
[20,{"$f":"IF(A31<Löneberäkning!$I$6,EDATE(start.date,A31),\"\")","v":"1901-08-31"}]
[21,{"$f":"IF(A32<Löneberäkning!$I$6,EDATE(start.date,A32),\"\")","v":"1901-09-30"}]
[22,{"$f":"IF(A33<Löneberäkning!$I$6,EDATE(start.date,A33),\"\")","v":"1901-10-31"}]
[23,{"$f":"IF(A34<Löneberäkning!$I$6,EDATE(start.date,A34),\"\")","v":"1901-11-30"}]
[24,{"$f":"IF(A35<Löneberäkning!$I$6,EDATE(start.date,A35),\"\")","v":"1901-12-31"}]
[25,{"$f":"IF(A36<Löneberäkning!$I$6,EDATE(start.date,A36),\"\")","v":"1902-01-31"}]
[26,{"$f":"IF(A37<Löneberäkning!$I$6,EDATE(start.date,A37),\"\")","v":"1902-02-28"}]
[27,{"$f":"IF(A38<Löneberäkning!$I$6,EDATE(start.date,A38),\"\")","v":"1902-03-31"}]
[28,{"$f":"IF(A39<Löneberäkning!$I$6,EDATE(start.date,A39),\"\")","v":"1902-04-30"}]
[29,{"$f":"IF(A40<Löneberäkning!$I$6,EDATE(start.date,A40),\"\")","v":"1902-05-31"}]
[30,{"$f":"IF(A41<Löneberäkning!$I$6,EDATE(start.date,A41),\"\")","v":"1902-06-30"}]
[31,{"$f":"IF(A42<Löneberäkning!$I$6,EDATE(start.date,A42),\"\")","v":"1902-07-31"}]
[32,{"$f":"IF(A43<Löneberäkning!$I$6,EDATE(start.date,A43),\"\")","v":"1902-08-31"}]
[33,{"$f":"IF(A44<Löneberäkning!$I$6,EDATE(start.date,A44),\"\")","v":"1902-09-30"}]
[34,{"$f":"IF(A45<Löneberäkning!$I$6,EDATE(start.date,A45),\"\")","v":"1902-10-31"}]
[35,{"$f":"IF(A46<Löneberäkning!$I$6,EDATE(start.date,A46),\"\")","v":"1902-11-30"}]
[36,{"$f":"IF(A47<Löneberäkning!$I$6,EDATE(start.date,A47),\"\")","v":"1902-12-31"}]
[37,{"$f":"IF(A48<Löneberäkning!$I$6,EDATE(start.date,A48),\"\")","v":"1903-01-31"}]
[38,{"$f":"IF(A49<Löneberäkning!$I$6,EDATE(start.date,A49),\"\")","v":"1903-02-28"}]
[39,{"$f":"IF(A50<Löneberäkning!$I$6,EDATE(start.date,A50),\"\")","v":"1903-03-31"}]
[40,{"$f":"IF(A51<Löneberäkning!$I$6,EDATE(start.date,A51),\"\")","v":"1903-04-30"}]
[41,{"$f":"IF(A52<Löneberäkning!$I$6,EDATE(start.date,A52),\"\")","v":"1903-05-31"}]
[42,{"$f":"IF(A53<Löneberäkning!$I$6,EDATE(start.date,A53),\"\")","v":"1903-06-30"}]
[43,{"$f":"IF(A54<Löneberäkning!$I$6,EDATE(start.date,A54),\"\")","v":"1903-07-31"}]
[44,{"$f":"IF(A55<Löneberäkning!$I$6,EDATE(start.date,A55),\"\")","v":"1903-08-31"}]
[45,{"$f":"IF(A56<Löneberäkning!$I$6,EDATE(start.date,A56),\"\")","v":"1903-09-30"}]
[46,{"$f":"IF(A57<Löneberäkning!$I$6,EDATE(start.date,A57),\"\")","v":"1903-10-31"}]
[47,{"$f":"IF(A58<Löneberäkning!$I$6,EDATE(start.date,A58),\"\")","v":"1903-11-30"}]
[48,{"$f":"IF(A59<Löneberäkning!$I$6,EDATE(start.date,A59),\"\")","v":"1903-12-31"}]
[49,{"$f":"IF(A60<Löneberäkning!$I$6,EDATE(start.date,A60),\"\")","v":"1904-01-31"}]
[50,{"$f":"IF(A61<Löneberäkning!$I$6,EDATE(start.date,A61),\"\")","v":"1904-02-29"}]
[51,{"$f":"IF(A62<Löneberäkning!$I$6,EDATE(start.date,A62),\"\")","v":"1904-03-31"}]
[52,{"$f":"IF(A63<Löneberäkning!$I$6,EDATE(start.date,A63),\"\")","v":"1904-04-30"}]
[53,{"$f":"IF(A64<Löneberäkning!$I$6,EDATE(start.date,A64),\"\")","v":"1904-05-31"}]
[54,{"$f":"IF(A65<Löneberäkning!$I$6,EDATE(start.date,A65),\"\")","v":"1904-06-30"}]
[55,{"$f":"IF(A66<Löneberäkning!$I$6,EDATE(start.date,A66),\"\")","v":"1904-07-31"}]
[56,{"$f":"IF(A67<Löneberäkning!$I$6,EDATE(start.date,A67),\"\")","v":"1904-08-31"}]
[57,{"$f":"IF(A68<Löneberäkning!$I$6,EDATE(start.date,A68),\"\")","v":"1904-09-30"}]
[58,{"$f":"IF(A69<Löneberäkning!$I$6,EDATE(start.date,A69),\"\")","v":"1904-10-31"}]
[59,{"$f":"IF(A70<Löneberäkning!$I$6,EDATE(start.date,A70),\"\")","v":"1904-11-30"}]
[60,{"$f":"IF(A71<Löneberäkning!$I$6,EDATE(start.date,A71),\"\")","v":"1904-12-31"}]

{"sheet":"Def","index":4,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"EU: Produktiva dagar per motsvarande 12 månader",215,"ç","prod.days.per.year",null,null,null,null,"list.arbetstid"]
[null,null,null,null,"Månader per år",12,null,null,null,null,null,null,"Heltid/Deltid","ç","Heltid.el.Deltid"]
[null,null,null,null,"Produktiva dagar per månad",{"$f":"F4/F5","v":17.916666666666668},"ç","prod.days.per.month",null,null,null,null,"Föräldraledighet","ç","Foraldraledighet"]
[null,null,null,null,"Kalenderdagar per månad",30,"ç","standard.days.per.month"]
[null,null,null,null,"Produktiva timmar per dag",8,"ç","hours.per.day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anställd07"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,null,null,null,null,null,null,"Anställd08"]
[null,null,null,null,{"$f":"employee.01","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,null,null,null,null,null,null,"Anställd09"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,null,null,null,null,null,null,"Anställd10"]
[null,null,null,null,{"$f":"employee.02","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,null,null,null,null,null,null,"Anställd11"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,null,null,null,null,null,null,"Anställd12"]
[null,null,null,null,{"$f":"employee.03","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,null,null,null,null,null,null,"Anställd13"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.01","v":0},{"$f":"IF(M22=\"\",,M22)","v":0},null,null,null,null,"Anställd14"]
[null,null,null,null,{"$f":"employee.04","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.02","v":0},{"$f":"IF(M23=\"\",,M23)","v":0},null,null,null,null,"Anställd15"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.03","v":0},0,null,null,null,null,"Anställd16"]
[null,null,null,null,{"$f":"employee.05","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.04","v":0},0,null,null,null,null,"Anställd17"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.05","v":0},0,null,null,null,null,"Anställd18"]
[null,null,null,null,{"$f":"employee.06","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.06","v":0},0,null,null,null,null,"Anställd19"]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.07","v":0},0,null,null,null,null,"Anställd20"]
[null,null,null,null,{"$f":"employee.07","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.08","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.09","v":0},0]
[null,null,null,null,{"$f":"employee.08","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.10","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.11","v":0},0]
[null,null,null,null,{"$f":"employee.09","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.12","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.13","v":0},0]
[null,null,null,null,{"$f":"employee.10","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.14","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.15","v":0},0]
[null,null,null,null,{"$f":"employee.11","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.16","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.17","v":0},0]
[null,null,null,null,{"$f":"employee.12","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.18","v":0},0]
[null,null,null,null,"Namn","Avser",null,null,null,null,null,null,{"$f":"employee.19","v":0},0]
[null,null,null,null,{"$f":"employee.13","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"},null,null,null,null,null,null,{"$f":"employee.20","v":0},0]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.14","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.15","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.16","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.17","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.18","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.19","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]
[null,null,null,null,"Namn","Avser"]
[null,null,null,null,{"$f":"employee.20","v":0},{"$f":"Foraldraledighet","v":"Föräldraledighet"}]