{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instruktioner","Beräkning snittlön","Sammanställning","Grunduppgifter","Lönekostnad FINANSIÄR","Lönekostnad HB","Resekostnader","Externa tjänster","Övriga kostnader","Lokalkostnader","Utrustning och avskrivningar","Påslag","IN KIND","PåläggJaNej","Löneuppräkning"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":63,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruktioner","index":0,"n_rows":133,"n_cols":2,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["INSTRUKTIONER"]
[]
["Grunduppgifter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fyll i de gula fälten. Din ekonom vet aktuella procentsatser för lkp, löneuppräkning och högskolans påslag."]
[null,"Finansiärens villkor framgår av utlysningen."]
[]
["Sammanställning","Visar projektets kostnad utifrån HBs verkliga kostnader samt enligt finansiärens villkor."]
[null,"Alla siffror hämtas från andra källor i kalkylen, här fylls inget i. "]
[]
["Lönekostnad FINANSIÄR"]
[]
[]
[]
[null,"Fyll i de gula fälten. Lönekostnad beräknas enligt finansiärens villkor enligt det som angivits i fliken Grunduppgifter."]
[null,"Lönekostnaden visas för grundlön, LKP och totalt per år och totalt samt per individ och alla."]
[null,"Observera att omfattningen måste anges i procent (%)."]
[]
["Lönekostnad HB"]
[]
[]
[]
[null,"I denna flika hämtas personer, lön och omfattning från fliken Lönekostnad FINANSIÄR. Lönekostnad beräknas enligt HBs villkor enligt det som angivits i fliken Grunduppgifter. "]
[null,"Lönekostnaden visas för grundlön, LKP och totalt per år och totalt samt per individ och alla."]
[null,"Om personens insats är IN KIND av något slag och inte ska beräknas som en kostnad i projektet för HB så kan månadslönen sättas till 0."]
[]
["Resekostnader"]
[]
[]
[null,"Fyll i de gula fälten med projektets resekostnader. "]
[]
["Externa tjänster"]
[]
[]
[]
[]
[null,"Fyll i de gula fälten med projektets externa tjänster och konsulter."]
[]
["Övriga kostnader"]
[]
[]
[]
[]
[]
[]
[null,"Fyll i de gula fälten med projektets driftskostnader."]
[]
["Lokalkostnader"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fyll i de gula fälten med omfattning i procent respektive antal timmar för den typ av lokal som behövs för projektet."]
[null,"Tjänsterum bör alltid budgeteras för den tid som en person är tänkt att vara med i projektet."]
[null,"För externa lokaler behöver även beskrivning av lokal och kostnas/timme anges."]
[]
["Utrustning och avskrivningar"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fyll i anskaffningsvärdet samt antalet månader som ska avskrivningarna ska bekostas av projektet respektive år i de gula fälten."]
[null,"Observera att utrustning med anskaffningsvärde under 20 tkr inte avskrivs utan utgör en övrig kostnad."]
[]
["Påslag"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I denna flik beräknas påslagen enligt finansiärens villkor och högskolans villkor enligt vad som angivits i fliken Grunduppgifter. Observera att det är viktigt att det är korrekt valt vilka kostnaddslag som "]
[null,"finansiärens villkor beräknas på i fliken Grunduppgifter för att påslaget ska beräknas korrekt. "]
[null,"Om finansiären medger ett fast belopp anges procentsats 0% i fliken grunduppgifter och beloppet anges i de gula fälten i denna flik."]
[]
["IN KIND","I denna flik kan eventuell IN KIND anges och beräknas. "]
[null,"OBS: det som fylls i som IN KIND i denna flik påverkar inte vad som angivits i de andra flikarna."]

{"sheet":"Beräkning snittlön","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,5,8,5],[5,6,8,6],[5,10,8,10]]}
["Antagande för beräkning:","Med heltidsstudier är en doktorandutbildning 4 år. "]
[null,"Lönen under doktorandutbildningen ligger mellan 26500-30600 kr/mån. "]
[null,"Doktoranden antas ligga i de olika lönenivåerna lika länge, dvs ett år/steg."]
[]
[null,"År","Lön","Mån","Årslön","Bruttolön","Snitt/mån","LKP","Lönerev","Kostn/år","Kostnad 4 år"]
["Ingångslön",1,29500,12,{"$f":"C6*D6","v":354000},{"$f":"SUM(E6:E9)","v":1512000},{"$f":"F6/48","v":31500},1.5364,1.0249999999999999,{"$f":"$G$6*12*I6*H6","v":595278.17999999993},{"$f":"SUM(J6:J9)","v":2471901.9436715618}]
["60 hp",2,30500,12,{"$f":"C7*D7","v":366000},null,null,{"$f":"H6","v":1.5364},{"$f":"I6*1.025","v":1.0506249999999999},{"$f":"$G$6*12*I7*H7","v":610160.13449999993}]
["120 hp",3,32500,12,390000,null,null,{"$f":"H6","v":1.5364},{"$f":"I7*1.025","v":1.0768906249999999},625414.13786249992]
["180 hp",4,33500,12,402000,null,null,{"$f":"H6","v":1.5364},1.1038128906249998,641049.49130906234]
[null,null,null,null,null,null,"Om denna används blir det löneuppräkning på löneuppräkning enl trappan"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://www.hb.se/globalassets/global/hb---anstalld/styrdokument/lokalt-villkorsavtal-210520.pdf"]

{"sheet":"Sammanställning","index":2,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,6,3,11],[3,13,3,18]]}
["SAMMANSTÄLLNING PROJEKTKALKYL"]
[{"$f":"\"Projekt: \"&Grunduppgifter!B5","v":"Projekt: "}]
[]
[null,null,"Enl. fin. villkor","Enl. HBs villkor",null,null,"Enligt finansiärens villkor / år",null,null,null,null,null,null,"Enligt högskolans villkor / år"]
[null,null,"Totalt","Totalt",null,null,"År 1","År 2","År 3","År 4","År 5","Summa",null,"År 1","År 2","År 3","År 4","År 5","Summa"]
["Direkta kostnader"]
[null,"Personal",{"$f":"'Lönekostnad FINANSIÄR'!$Z$41","v":2886425.5749536613},{"$f":"'Lönekostnad HB'!$Y$41","v":2886425.5749536613},null,null,{"$f":"'Lönekostnad FINANSIÄR'!$K$41","v":692045.375137022},{"$f":"'Lönekostnad FINANSIÄR'!$N$41","v":709346.50951544743},{"$f":"'Lönekostnad FINANSIÄR'!$Q$41","v":727080.17225333361},{"$f":"'Lönekostnad FINANSIÄR'!$T$41","v":757953.5180478585},{"$f":"'Lönekostnad FINANSIÄR'!$W$41","v":0},{"$f":"SUM(G7:K7)","v":2886425.5749536613},null,{"$f":"'Lönekostnad HB'!J41","v":692045.375137022},{"$f":"'Lönekostnad HB'!M41","v":709346.50951544743},{"$f":"'Lönekostnad HB'!P41","v":727080.17225333361},{"$f":"'Lönekostnad HB'!S41","v":757953.5180478585},{"$f":"'Lönekostnad HB'!V41","v":0},{"$f":"SUM(N7:R7)","v":2886425.5749536613}]
[null,"Resor",{"$f":"Resekostnader!$G$40","v":70000},{"$f":"Resekostnader!$G$40","v":70000},null,null,{"$f":"Resekostnader!$B$40","v":15000},{"$f":"Resekostnader!$C$40","v":15000},{"$f":"Resekostnader!$D$40","v":15000},{"$f":"Resekostnader!$E$40","v":25000},{"$f":"Resekostnader!$F$40","v":0},{"$f":"SUM(G8:K8)","v":70000},null,{"$f":"G8","v":15000},{"$f":"H8","v":15000},{"$f":"I8","v":15000},25000,0,{"$f":"SUM(N8:R8)","v":70000}]
[null,"Externa tjänster",{"$f":"'Externa tjänster'!$G$40","v":14200},{"$f":"'Externa tjänster'!$G$40","v":14200},null,null,{"$f":"'Externa tjänster'!$B$40","v":800},{"$f":"'Externa tjänster'!$C$40","v":800},{"$f":"'Externa tjänster'!$D$40","v":800},{"$f":"'Externa tjänster'!$E$40","v":11800},{"$f":"'Externa tjänster'!$F$40","v":0},14200,null,{"$f":"G9","v":800},{"$f":"H9","v":800},{"$f":"I9","v":800},{"$f":"J9","v":11800},{"$f":"K9","v":0},14200]
[null,"Övriga driftskostnader",{"$f":"'Övriga kostnader'!$G$40","v":135000},{"$f":"'Övriga kostnader'!$G$40","v":135000},null,null,{"$f":"'Övriga kostnader'!$B$40","v":45000},{"$f":"'Övriga kostnader'!$C$40","v":25000},{"$f":"'Övriga kostnader'!$D$40","v":25000},{"$f":"'Övriga kostnader'!$E$40","v":40000},{"$f":"'Övriga kostnader'!$F$40","v":0},135000,null,45000,25000,25000,40000,0,135000]
[null,"Lokaler",{"$f":"Lokalkostnader!$O$41","v":97629.760000000009},{"$f":"Lokalkostnader!$O$41","v":97629.760000000009},null,null,{"$f":"Lokalkostnader!$J$41","v":23157.440000000002},{"$f":"Lokalkostnader!$K$41","v":23157.440000000002},{"$f":"Lokalkostnader!$L$41","v":23157.440000000002},{"$f":"Lokalkostnader!$M$41","v":28157.440000000002},{"$f":"Lokalkostnader!$N$41","v":0},97629.760000000009,null,23157.440000000002,23157.440000000002,23157.440000000002,28157.440000000002,0,97629.760000000009]
[null,"Utrustning och avskrivningar",{"$f":"'Utrustning och avskrivningar'!$O$46","v":0},{"$f":"'Utrustning och avskrivningar'!$O$46","v":0},null,null,{"$f":"'Utrustning och avskrivningar'!$J$46","v":0},{"$f":"'Utrustning och avskrivningar'!$K$46","v":0},{"$f":"'Utrustning och avskrivningar'!$L$46","v":0},{"$f":"'Utrustning och avskrivningar'!$M$46","v":0},{"$f":"'Utrustning och avskrivningar'!$N$46","v":0},0,null,0,0,0,0,0,0]
["Summa direkta kostnader",null,{"$f":"SUM(C7:C12)","v":3203255.3349536611},{"$f":"SUM(D7:D12)","v":3203255.3349536611},null,null,{"$f":"SUM(G7:G12)","v":776002.81513702194},{"$f":"SUM(H7:H12)","v":773303.94951544749},791037.61225333367,862910.95804785844,0,3203255.3349536615,null,{"$f":"SUM(N7:N12)","v":776002.81513702194},773303.94951544749,791037.61225333367,862910.95804785844,0,3203255.3349536615]
[]
["Indirekta kostnader"]
[null,"Påslag/Overhead",{"$f":"Påslag!$G$15","v":1464860.9792889832},{"$f":"Påslag!$M$15","v":1464860.9792889832},null,null,{"$f":"Påslag!$B$15","v":351213.02788203862},{"$f":"Påslag!$C$15","v":359993.35357908951},{"$f":"Påslag!$D$15","v":368993.18741856678},{"$f":"Påslag!$E$15","v":384661.41040928813},{"$f":"Påslag!$F$15","v":0},{"$f":"SUM(G16:K16)","v":1464860.9792889832},null,{"$f":"Påslag!H15","v":351213.02788203862},{"$f":"Påslag!I15","v":359993.35357908951},{"$f":"Påslag!J15","v":368993.18741856678},{"$f":"Påslag!K15","v":384661.41040928813},{"$f":"Påslag!L15","v":0},{"$f":"SUM(N16:R16)","v":1464860.9792889832}]
["Summa indirekta kostnader",null,{"$f":"SUM(C16)","v":1464860.9792889832},{"$f":"SUM(D16)","v":1464860.9792889832},null,null,{"$f":"SUM(G16)","v":351213.02788203862},{"$f":"SUM(H16)","v":359993.35357908951},368993.18741856678,384661.41040928813,0,1464860.9792889832,null,{"$f":"SUM(N16)","v":351213.02788203862},{"$f":"SUM(O16)","v":359993.35357908951},{"$f":"SUM(P16)","v":368993.18741856678},{"$f":"SUM(Q16)","v":384661.41040928813},{"$f":"SUM(R16)","v":0},1464860.9792889832]
[]
["Summa kostnader för projektet",null,{"$f":"C13+C17","v":4668116.3142426442},{"$f":"D13+D17","v":4668116.3142426442},null,null,{"$f":"G13+G17","v":1127215.8430190606},{"$f":"H13+H17","v":1133297.303094537},1160030.7996719005,1247572.3684571465,0,{"$f":"SUM(G19:K19)","v":4668116.3142426442},null,{"$f":"N13+N17","v":1127215.8430190606},{"$f":"O13+O17","v":1133297.303094537},1160030.7996719005,1247572.3684571465,0,{"$f":"SUM(N19:R19)","v":4668116.3142426442}]
[]
["Belopp som söks från finansiär",null,{"$f":"C19*Grunduppgifter!$D$39","v":4668116.3142426442},{"$f":"C21","v":4668116.3142426442},null,null,{"$f":"G19*Grunduppgifter!$D$39","v":1127215.8430190606},{"$f":"H19*Grunduppgifter!$D$39","v":1133297.303094537},{"$f":"I19*Grunduppgifter!$D$39","v":1160030.7996719005},{"$f":"J19*Grunduppgifter!$D$39","v":1247572.3684571465},{"$f":"K19*Grunduppgifter!$D$39","v":0},{"$f":"SUM(G21:K21)","v":4668116.3142426442},null,{"$f":"N19*Grunduppgifter!$D$39","v":1127215.8430190606},{"$f":"O19*Grunduppgifter!$D$39","v":1133297.303094537},{"$f":"P19*Grunduppgifter!$D$39","v":1160030.7996719005},{"$f":"Q19*Grunduppgifter!$D$39","v":1247572.3684571465},{"$f":"R19*Grunduppgifter!$D$39","v":0},{"$f":"SUM(N21:R21)","v":4668116.3142426442}]
[]
["Samfinansiering för projektet"]
[null,"Enligt utlysningens villkor",{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$C$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$C$19","v":0},null,null,{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$G$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$H$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$I$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$J$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$K$19","v":0},{"$f":"SUM(G24:K24)","v":0},null,{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$G$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$H$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$I$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$J$19","v":0},{"$f":"(1-Grunduppgifter!$D$39)*Sammanställning!$K$19","v":0},{"$f":"SUM(N24:R24)","v":0}]
[null,"För ej full kostnadstäckning Påslag",null,{"$f":"(D16-C16)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(N16-G16)","v":0},{"$f":"(O16-H16)","v":0},0,0,{"$f":"(R16-K16)","v":0},0]
[null,"För ej full kostnadstäckning lön och LKP",null,{"$f":"('Lönekostnad HB'!X41-'Lönekostnad FINANSIÄR'!Y41)+('Lönekostnad HB'!W41-'Lönekostnad FINANSIÄR'!X41)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"('Lönekostnad HB'!H41-'Lönekostnad FINANSIÄR'!I41)+('Lönekostnad HB'!I41-'Lönekostnad FINANSIÄR'!J41)","v":0},{"$f":"('Lönekostnad HB'!K41-'Lönekostnad FINANSIÄR'!L41)+('Lönekostnad HB'!L41-'Lönekostnad FINANSIÄR'!M41)","v":0},{"$f":"('Lönekostnad HB'!N41-'Lönekostnad FINANSIÄR'!O41)+('Lönekostnad HB'!O41-'Lönekostnad FINANSIÄR'!P41)","v":0},{"$f":"('Lönekostnad HB'!Q41-'Lönekostnad FINANSIÄR'!R41)+('Lönekostnad HB'!R41-'Lönekostnad FINANSIÄR'!S41)","v":0},{"$f":"('Lönekostnad HB'!T41-'Lönekostnad FINANSIÄR'!U41)+('Lönekostnad HB'!U41-'Lönekostnad FINANSIÄR'!V41)","v":0},0]
["Summa samfinansiering",null,{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},null,null,{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0},0,0,0,{"$f":"SUM(G27:K27)","v":0},null,{"$f":"SUM(N24:N26)","v":0},{"$f":"SUM(O24:O26)","v":0},{"$f":"SUM(P24:P26)","v":0},{"$f":"SUM(Q24:Q26)","v":0},{"$f":"SUM(R24:R26)","v":0},0]
[]
[]
[]
["Andel extern finansiering från finansiär",null,{"$f":"C21/C19","v":1},{"$f":"D21/D19","v":1}]
["Andel egen finansiering från institution/akademi",null,{"$f":"C27/C19","v":0},{"$f":"D27/D19","v":0}]
[null,null,{"$f":"SUM(C31:C32)","v":1},{"$f":"SUM(D31:D32)","v":1}]

{"sheet":"Grunduppgifter","index":3,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,1,19,7],[8,1,8,7],[9,1,9,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[6,1,6,7],[7,1,7,7],[10,1,10,7],[5,1,5,7],[13,1,13,7],[14,1,14,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7]]}
["PROJEKTINFORMATION"]
[]
["Ansökan / Beviljat projekt"]
["Orgenhet och Akt/proj"]
["Projekttitel:"]
["Huvudsökande:"]
["Projektledare:"]
["Institution: "]
["Ekonom på institution: "]
["Projektlängd (månader)"]
["Projektstart"]
[]
[]
["Anteckningar:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FÖRUTSÄTTNINGAR PROJEKTKALKYL"]
[]
[]
[null,null,"%","faktor"]
["Högskolans lönekostnadspålägg (25-29 år)",null,0.53639999999999999,{"$f":"C28","v":0.53639999999999999}]
["Lönekostnadspålägg som medges av finansiär",null,0.53639999999999999,{"$f":"C29","v":0.53639999999999999}]
[]
["Löneuppräkning",null,2.5000000000000001E-2,{"$f":"C31","v":2.5000000000000001E-2},null,null,"Påslag  FO 2023"]
["Löneuppräkning som medges av finansiär",null,2.5000000000000001E-2,{"$f":"C32","v":2.5000000000000001E-2},null,null,"A1",null,0.51529999999999998]
[null,null,null,null,null,null,"A2",null,0.51139999999999997]
["Högskolans totala påslag",null,0.50749999999999995,{"$f":"C34","v":0.50749999999999995},null,null,"A3",null,0.49569999999999997]
["Påslag som medges av finansiär",null,0.50749999999999995,{"$f":"C35","v":0.50749999999999995},null,null,"A4",null,0.50749999999999995]
[null,null,null,null,null,null,"Rektor, VS ",null,0.50749999999999995]
["Ingår lokaler i finansiärens påslag?",null,"Nej","(Välj Ja/Nej)",null,null,"Genomsnitt HB",null,0.50749999999999995]
[]
["Finansiering från extern part (%)",null,1,{"$f":"C39","v":1}]
["Samfinansiering från institution eller annan finansiär (%)",null,{"$f":"1-C39","v":0},{"$f":"C40","v":0}]
[]
[]
["Finansiären medger påslag på:"]
[]
["Lönekostnader: ",null,"Ja","(Välj Ja/Nej)"]
[]
["Driftkostnader: ",null,"Nej","(Välj Ja/Nej)"]
[]
["Utrustning: ",null,"Nej","(Välj Ja/Nej)"]
[]
["Lokaler: ",null,"Nej","(Välj Ja/Nej)"]

{"sheet":"Lönekostnad FINANSIÄR","index":4,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,27],[3,8,3,10],[3,11,3,13],[3,14,3,16],[40,0,40,6],[3,0,3,1],[3,17,3,19],[3,20,3,22],[3,23,3,25],[3,2,3,6]]}
["PERSONALKOSTNADER (FINANSIÄRENS VILLKOR)"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,null,null,null,null,null,null,null,"Kostnad"]
["Lönekostnader inkl. LKP",null,"Omfattning %",null,null,null,null,null,"År 1",null,null,"År 2",null,null,"År 3",null,null,"År 4",null,null,"År 5",null,null,"TOTALT"]
["Person / kompetens / roll","Månadslön","År 1","År 2","År 3","År 4","År 5",null,"Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Budget","Diff"]
["Handledning professor",70000,2.9499999999999998E-2,2.9499999999999998E-2,2.9499999999999998E-2,2.9499999999999998E-2,null,{"$f":"SUM(C6:G6)*100","v":11.799999999999999},{"$f":"$B6*(1+Löneuppräkning)^a*12*C6","v":25558.247225690564},{"$f":"I6*(LönekostnadspåläggFInansiär)","v":13709.443811860418},{"$f":"I6+J6","v":39267.691037550983},{"$f":"$B6*(1+Löneuppräkning)^b*12*D6","v":26197.203406332828},{"$f":"L6*(LönekostnadspåläggFInansiär)","v":14052.179907156929},{"$f":"L6+M6","v":40249.383313489758},{"$f":"$B6*(1+Löneuppräkning)^c_*12*E6","v":26852.133491491142},{"$f":"O6*(LönekostnadspåläggFInansiär)","v":14403.484404835848},{"$f":"O6+P6","v":41255.617896326992},{"$f":"$B6*(1+Löneuppräkning)^d*12*F6","v":27523.43682877842},{"$f":"R6*(LönekostnadspåläggFInansiär)","v":14763.571514956744},{"$f":"R6+S6","v":42287.008343735164},{"$f":"$B6*(1+Löneuppräkning)^e*12*G6","v":0},{"$f":"U6*(LönekostnadspåläggFInansiär)","v":0},{"$f":"U6+V6","v":0},{"$f":"I6+L6+O6+R6+U6","v":106131.02095229295},{"$f":"J6+M6+P6+S6+V6","v":56928.679638809946},{"$f":"X6+Y6","v":163059.70059110288},null,{"$f":"Z6-AA6","v":163059.70059110288}]
["Handledning lektor",52000,2.9499999999999998E-2,2.9499999999999998E-2,2.9499999999999998E-2,2.9499999999999998E-2,null,{"$f":"SUM(C7:G7)*100","v":11.799999999999999},{"$f":"$B7*(1+Löneuppräkning)^a*12*C7","v":18986.126510512993},10184.15826023917,{"$f":"I7+J7","v":29170.284770752165},19460.779673275811,10438.762216745145,{"$f":"L7+M7","v":29899.541890020955},19947.299165107706,10699.731272163774,{"$f":"O7+P7","v":30647.030437271482},20445.981644235402,10967.22455396787,{"$f":"R7+S7","v":31413.206198203272},0,0,{"$f":"U7+V7","v":0},{"$f":"I7+L7+O7+R7+U7","v":78840.186993131909},{"$f":"J7+M7+P7+S7+V7","v":42289.876303115954},{"$f":"X7+Y7","v":121130.06329624786},null,{"$f":"Z7-AA7","v":121130.06329624786}]
["Doktorand (snittlön doktorandtrappa 2022)",31500,1,1,1,1,null,400,389871.56784951716,209127.10899448101,598998.67684399814,399618.35704575502,214355.28671934298,613973.64376509795,409608.81597189885,219714.16888732652,629322.98485922534,419849.03637119627,225207.02310950967,645056.059480706,0,0,0,1618947.7772383671,868403.58771066018,2487351.3649490271,null,{"$f":"Z8-AA8","v":2487351.3649490271}]
["Opponent",62000,0,0,0,0.01,null,1,0,0,0,0,0,0,0,0,0,8263.6953190521181,4432.6461691395562,12696.341488191674,0,0,0,8263.6953190521181,4432.6461691395562,12696.341488191674,null,{"$f":"Z9-AA9","v":12696.341488191674}]
["Doktorandkurser 60 hp, ",55000,{"$f":"40/1700","v":2.3529411764705882E-2},{"$f":"40/1700","v":2.3529411764705882E-2},2.3529411764705882E-2,2.3529411764705882E-2,null,9.4117647058823533,16017.13257271592,8591.5899120048198,24608.72248472074,16417.560887033818,8806.3796598049394,25223.940546838756,16827.999909209662,9026.5391513000632,25854.539060509727,17248.699906939903,9252.2026300825637,26500.902537022466,0,0,0,66511.393275899303,35676.711353192382,102188.10462909169,null,102188.10462909169]
["(totalt 8 kurser * 7,5 hp 20 timmar/kurs för doktoranden)",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"I40+L40+O40+R40+U40","v":0},0,0,null,0]
["Summa lönekostnader",null,null,null,null,null,null,null,{"$f":"SUM(I6:I40)","v":450433.07415843668},{"$f":"SUM(J6:J40)","v":241612.30097858544},{"$f":"SUM(K6:K40)","v":692045.375137022},{"$f":"SUM(L6:L40)","v":461693.90101239749},247652.60850305003,709346.50951544743,473236.24853770738,253843.92371562621,727080.17225333361,493330.85007020214,264622.66797765641,757953.5180478585,0,0,0,1878694.0737787434,1007731.5011749179,{"$f":"SUM(Z6:Z40)","v":2886425.5749536613},{"$f":"SUM(AA6:AA40)","v":0},{"$f":"SUM(AB6:AB40)","v":2886425.5749536613}]

{"sheet":"Lönekostnad HB","index":5,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,6],[2,7,2,26],[3,0,3,1],[3,2,3,6],[3,7,3,9],[3,10,3,12],[3,13,3,15],[3,16,3,18],[3,19,3,21],[3,22,3,24]]}
["PERSONALKOSTNADER (HB:S VILLKOR)",null,null,null,null,null,null,"OBS: ALLT HÄMTAS FRÅN ANDRA FLIKAR"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,null,null,null,null,null,null,"Kostnad"]
["Lönekostnader inkl. LKP",null,"Omfattning %",null,null,null,null,"År 1",null,null,"År 2",null,null,"År 3",null,null,"År 4",null,null,"År 5",null,null,"TOTALT"]
["Person / kompetens / roll","Månadslön","År 1","År 2","År 3","År 4","År 5","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Budget","Diff"]
[{"$f":"'Lönekostnad FINANSIÄR'!A6","v":"Handledning professor"},{"$f":"'Lönekostnad FINANSIÄR'!B6","v":70000},{"$f":"'Lönekostnad FINANSIÄR'!C6","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!D6","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!E6","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!F6","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!G6","v":0},{"$f":"$B6*(1+LöneuppräkningHB)^a*12*C6","v":25558.247225690564},{"$f":"H6*(Lönekostnadspålägg)","v":13709.443811860418},{"$f":"H6+I6","v":39267.691037550983},{"$f":"$B6*(1+LöneuppräkningHB)^b*12*D6","v":26197.203406332828},{"$f":"K6*(Lönekostnadspålägg)","v":14052.179907156929},{"$f":"K6+L6","v":40249.383313489758},{"$f":"$B6*(1+LöneuppräkningHB)^c_*12*E6","v":26852.133491491142},{"$f":"N6*(Lönekostnadspålägg)","v":14403.484404835848},{"$f":"N6+O6","v":41255.617896326992},{"$f":"$B6*(1+LöneuppräkningHB)^d*12*F6","v":27523.43682877842},{"$f":"Q6*(Lönekostnadspålägg)","v":14763.571514956744},{"$f":"Q6+R6","v":42287.008343735164},{"$f":"$B6*(1+LöneuppräkningHB)^e*12*G6","v":0},{"$f":"T6*(Lönekostnadspålägg)","v":0},{"$f":"T6+U6","v":0},{"$f":"H6+K6+N6+Q6+T6","v":106131.02095229295},{"$f":"I6+L6+O6+R6+U6","v":56928.679638809946},{"$f":"W6+X6","v":163059.70059110288},null,{"$f":"Y6-Z6","v":163059.70059110288}]
[{"$f":"'Lönekostnad FINANSIÄR'!A7","v":"Handledning lektor"},{"$f":"'Lönekostnad FINANSIÄR'!B7","v":52000},{"$f":"'Lönekostnad FINANSIÄR'!C7","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!D7","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!E7","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!F7","v":2.9499999999999998E-2},{"$f":"'Lönekostnad FINANSIÄR'!G7","v":0},18986.126510512993,10184.15826023917,{"$f":"H7+I7","v":29170.284770752165},19460.779673275811,10438.762216745145,{"$f":"K7+L7","v":29899.541890020955},19947.299165107706,10699.731272163774,{"$f":"N7+O7","v":30647.030437271482},20445.981644235402,10967.22455396787,{"$f":"Q7+R7","v":31413.206198203272},0,0,{"$f":"T7+U7","v":0},{"$f":"H7+K7+N7+Q7+T7","v":78840.186993131909},42289.876303115954,{"$f":"W7+X7","v":121130.06329624786},null,{"$f":"Y7-Z7","v":121130.06329624786}]
[{"$f":"'Lönekostnad FINANSIÄR'!A8","v":"Doktorand (snittlön doktorandtrappa 2022)"},{"$f":"'Lönekostnad FINANSIÄR'!B8","v":31500},{"$f":"'Lönekostnad FINANSIÄR'!C8","v":1},{"$f":"'Lönekostnad FINANSIÄR'!D8","v":1},{"$f":"'Lönekostnad FINANSIÄR'!E8","v":1},{"$f":"'Lönekostnad FINANSIÄR'!F8","v":1},{"$f":"'Lönekostnad FINANSIÄR'!G8","v":0},389871.56784951716,209127.10899448101,598998.67684399814,399618.35704575502,214355.28671934298,613973.64376509795,409608.81597189885,219714.16888732652,629322.98485922534,419849.03637119627,225207.02310950967,645056.059480706,0,0,0,1618947.7772383671,868403.58771066018,2487351.3649490271,null,{"$f":"Y8-Z8","v":2487351.3649490271}]
[{"$f":"'Lönekostnad FINANSIÄR'!A9","v":"Opponent"},{"$f":"'Lönekostnad FINANSIÄR'!B9","v":62000},{"$f":"'Lönekostnad FINANSIÄR'!C9","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D9","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E9","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F9","v":0.01},{"$f":"'Lönekostnad FINANSIÄR'!G9","v":0},0,0,0,0,0,0,0,0,0,8263.6953190521181,4432.6461691395562,12696.341488191674,0,0,0,8263.6953190521181,4432.6461691395562,12696.341488191674,null,{"$f":"Y9-Z9","v":12696.341488191674}]
[{"$f":"'Lönekostnad FINANSIÄR'!A10","v":"Doktorandkurser 60 hp, "},{"$f":"'Lönekostnad FINANSIÄR'!B10","v":55000},{"$f":"'Lönekostnad FINANSIÄR'!C10","v":2.3529411764705882E-2},{"$f":"'Lönekostnad FINANSIÄR'!D10","v":2.3529411764705882E-2},{"$f":"'Lönekostnad FINANSIÄR'!E10","v":2.3529411764705882E-2},{"$f":"'Lönekostnad FINANSIÄR'!F10","v":2.3529411764705882E-2},{"$f":"'Lönekostnad FINANSIÄR'!G10","v":0},16017.13257271592,8591.5899120048198,24608.72248472074,16417.560887033818,8806.3796598049394,25223.940546838756,16827.999909209662,9026.5391513000632,25854.539060509727,17248.699906939903,9252.2026300825637,26500.902537022466,0,0,0,66511.393275899303,35676.711353192382,102188.10462909169,null,102188.10462909169]
[{"$f":"'Lönekostnad FINANSIÄR'!A11","v":"(totalt 8 kurser * 7,5 hp 20 timmar/kurs för doktoranden)"},{"$f":"'Lönekostnad FINANSIÄR'!B11","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C11","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D11","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E11","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F11","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F12","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F13","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F14","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F15","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F16","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F17","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F18","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F19","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F20","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F21","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F22","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F23","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F24","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F25","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F26","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F27","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F28","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F29","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F30","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F31","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F32","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F33","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F34","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F35","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F36","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F37","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F38","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F39","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[{"$f":"'Lönekostnad FINANSIÄR'!A40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!B40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!C40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!D40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!E40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!F40","v":0},{"$f":"'Lönekostnad FINANSIÄR'!G40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
["Summa lönekostnader",null,null,null,null,null,null,{"$f":"SUM(H6:H40)","v":450433.07415843668},{"$f":"SUM(I6:I40)","v":241612.30097858544},{"$f":"SUM(J6:J40)","v":692045.375137022},{"$f":"SUM(K6:K40)","v":461693.90101239749},247652.60850305003,709346.50951544743,473236.24853770738,253843.92371562621,727080.17225333361,493330.85007020214,264622.66797765641,757953.5180478585,0,0,0,1878694.0737787434,1007731.5011749179,2886425.5749536613,{"$f":"SUM(Z6:Z40)","v":0},{"$f":"SUM(AA6:AA40)","v":2886425.5749536613}]

{"sheet":"Resekostnader","index":6,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
["RESEKOSTNADER"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,"Kostnad"]
["Resekostnader","År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
["Resor",5000,5000,5000,5000,null,{"$f":"SUM(B5:F5)","v":20000},null,{"$f":"G5-H5","v":20000}]
["Konferenser",10000,10000,10000,10000,null,{"$f":"SUM(B6:F6)","v":40000},null,40000]
["Opponent disputation resa+hotell",null,null,null,10000,null,10000,null,10000]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
["Summa resekostnader",{"$f":"SUM(B5:B39)","v":15000},15000,15000,25000,0,70000,0,70000]

{"sheet":"Externa tjänster","index":7,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
["KOSTNADER FÖR EXTERNA TJÄNSTER"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,"Kostnad"]
["Externa tjänster","År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
["Språkgranskning",null,null,null,8000,null,{"$f":"SUM(B5:F5)","v":8000},null,{"$f":"G5-H5","v":8000}]
["Översättning",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0},null,0]
["Open Access",null,null,null,null,null,0,null,0]
["Publicering",null,null,null,null,null,0,null,0]
["Konsult",null,null,null,null,null,0,null,0]
["Extern sakkunskap",null,null,null,null,null,0,null,0]
["Representation Disputation",null,null,null,3000,null,3000,null,3000]
["Mobilabonnemang",800,800,800,800,null,3200,null,3200]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
["Summa externa tjänster",{"$f":"SUM(B5:B39)","v":800},800,800,11800,0,14200,0,14200]

{"sheet":"Övriga kostnader","index":8,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
["ÖVRIGA KOSTNADER"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,"Kostnad"]
["Övriga kostnader","År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
["Datorer (> 5 - < 20 tkr)",15000,null,null,null,null,{"$f":"SUM(B5:F5)","v":15000},null,{"$f":"G5-H5","v":15000}]
["Utrustning  (> 5 - < 20 tkr) Mobiltelefon",5000,null,null,null,null,{"$f":"SUM(B6:F6)","v":5000},null,5000]
["Litteratur",null,null,null,null,null,0,null,0]
["Möten",null,null,null,null,null,0,null,0]
["Workshops",null,null,null,null,null,0,null,0]
["Tryckning avhandling",null,null,null,15000,null,15000,null,15000]
["Förbrukningsmaterial, tex labmaterial",25000,25000,25000,25000,null,100000,null,100000]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
["Summa övriga kostnader",{"$f":"SUM(B5:B39)","v":45000},25000,25000,40000,0,135000,0,135000]

{"sheet":"Lokalkostnader","index":9,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,8],[32,4,32,8],[15,4,15,8],[2,9,2,16],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[3,4,3,8],[29,0,29,2],[30,0,30,2]]}
["LOKALKOSTNADER"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Tjänsterum",null,null,null,"Omfattning %",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
[null,null,"kvm","Kr/kvm/år","År 1","År 2","År 3","År 4","År 5",null,null,null,null,null,null,null,{"$f":"O5-P5","v":0}]
["Tjänsterum",null,7,2421,null,null,null,null,null,{"$f":"$C6*$D6*E6","v":0},{"$f":"$C6*$D6*F6","v":0},{"$f":"$C6*$D6*G6","v":0},{"$f":"$C6*$D6*H6","v":0},{"$f":"$C6*$D6*I6","v":0},{"$f":"SUM(J6:N6)","v":0},null,0]
["Tjänsterum",null,8,2421,1.08,1.08,1.08,1.08,null,{"$f":"$C7*$D7*E7","v":20917.440000000002},{"$f":"$C7*$D7*F7","v":20917.440000000002},{"$f":"$C7*$D7*G7","v":20917.440000000002},{"$f":"$C7*$D7*H7","v":20917.440000000002},{"$f":"$C7*$D7*I7","v":0},83669.760000000009,null,83669.760000000009]
["Tjänsterum",null,9,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,10,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,11,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,12,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,13,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,14,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Tjänsterum",null,15,2421,null,null,null,null,null,0,0,0,0,0,0,null,0]
[]
["Interna lokaler",null,null,null,"Antal timmar",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
[null,null,"Platser","kr/timme","År 1","År 2","År 3","År 4","År 5",null,null,null,null,null,null,null,0]
["Sammanträdesrum",null,"10 pl",180,null,null,null,null,null,{"$f":"$D18*E18","v":0},{"$f":"$D18*F18","v":0},{"$f":"$D18*G18","v":0},{"$f":"$D18*H18","v":0},{"$f":"$D18*I18","v":0},0,null,0]
["Sammanträdesrum",null,"25 pl",250,null,null,null,null,null,{"$f":"$D19*E19","v":0},{"$f":"$D19*F19","v":0},{"$f":"$D19*G19","v":0},{"$f":"$D19*H19","v":0},{"$f":"$D19*I19","v":0},0,null,0]
["Lärosal",null,"16-32 pl",280,8,8,8,8,null,2240,2240,2240,2240,0,8960,null,8960]
["Lärosal",null,"38-44 pl",290,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Lärosal",null,"45-65 pl",320,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Lärosal",null," 65 pl",350,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Hörsal",null,"88-119 pl",390,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Hörsal M404 (Hightech)",null,"120 pl",670,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Hörsal",null,"120-145 pl",450,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Hörsal",null,"200 pl",650,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Hörsal",null,"250 pl",750,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Datorsal",null,null,590,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Lab",null,null,null,null,null,null,null,null,{"$f":"$D30*E30","v":0},0,0,0,0,0,null,0]
["Lab",null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
[]
["Externa lokaler",null,null,null,"Antal timmar",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
[null,null,null,"kr/timme","År 1","År 2","År 3","År 4","År 5"]
["Disputation",null,null,1000,null,null,null,5,null,{"$f":"$D35*E35","v":0},0,0,5000,0,5000,null,5000]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,0]
["Summa lokaler",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J40)","v":23157.440000000002},23157.440000000002,23157.440000000002,28157.440000000002,0,97629.760000000009,0,97629.760000000009]

{"sheet":"Utrustning och avskrivningar","index":10,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,9,2,16],[45,0,45,3]]}
["KOSTNADER FÖR UTRUSTNING OCH AVSKRIVNINGAR"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Utrustning/avskrivningar",null,null,null,null,null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa","Budget","Diff"]
[null,"Ansk.värde","Livslängd (År):","År 1","År 2","År 3","År 4","År 5"]
["Dator (> 20 tkr)",null,3,null,null,null,null,null,{"$f":"B6/C6/12","v":0},{"$f":"D6*$I6","v":0},{"$f":"E6*$I6","v":0},{"$f":"F6*$I6","v":0},{"$f":"G6*$I6","v":0},{"$f":"H6*$I6","v":0},{"$f":"SUM(J6:N6)","v":0},null,{"$f":"O6-P6","v":0}]
["Dator (> 20 tkr)",null,3,null,null,null,null,null,{"$f":"B7/C7/12","v":0},{"$f":"D7*$I7","v":0},{"$f":"E7*$I7","v":0},{"$f":"F7*$I7","v":0},{"$f":"G7*$I7","v":0},{"$f":"H7*$I7","v":0},0,null,0]
["Dator (> 20 tkr)",null,3,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Dator (> 20 tkr)",null,5,null,null,null,null,null,0,{"$f":"D9*$I9","v":0},0,0,0,0,{"$f":"SUM(J9:N9)","v":0},null,{"$f":"O9-P9","v":0}]
["Dator (> 20 tkr)",null,5,null,null,null,null,null,0,0,{"$f":"E10*$I10","v":0},0,0,0,0,null,0]
["Dator (> 20 tkr)",null,5,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Dator (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Dator (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Dator (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,3,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,3,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,3,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,5,null,null,null,null,null,0,{"$f":"D18*$I18","v":0},{"$f":"E18*$I18","v":0},{"$f":"F18*$I18","v":0},{"$f":"G18*$I18","v":0},{"$f":"H18*$I18","v":0},{"$f":"SUM(J18:N18)","v":0},null,{"$f":"O18-P18","v":0}]
["Utrustning  (> 20 tkr)",null,5,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,5,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
["Utrustning  (> 20 tkr)",null,10,null,null,null,null,null,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J24:N24)","v":0},null,{"$f":"O24-P24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(IF($H26>0,IF($H26<13,12-$H26,0),0))*$I26","v":0},null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Summa utrustning/avskrivningar HB",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J45)","v":0},{"$f":"SUM(K5:K45)","v":0},0,0,0,0,0,0]

{"sheet":"Påslag","index":11,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,7,3,14],[3,1,3,6]]}
["KOSTNADER FÖR PÅSLAG OCH INDIREKTA KOSTNADER"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[]
[null,"Enligt Finansiärens villkor",null,null,null,null,null,"Enligt HBs villkor"]
["Kostnadsslag","År 1","År 2","År 3","År 4","År 5","Summa",{"$f":"B5","v":"År 1"},{"$f":"C5","v":"År 2"},{"$f":"D5","v":"År 3"},"År 4","År 5","Summa","Budget","Diff"]
["Lönekostnader inkl. lkp",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$45=\"Ja\",'Lönekostnad FINANSIÄR'!K41,0))","v":351213.02788203862},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$45=\"Ja\",'Lönekostnad FINANSIÄR'!N41,0))","v":359993.35357908951},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$45=\"Ja\",'Lönekostnad FINANSIÄR'!Q41,0))","v":368993.18741856678},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$45=\"Ja\",'Lönekostnad FINANSIÄR'!T41,0))","v":384661.41040928813},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$45=\"Ja\",'Lönekostnad FINANSIÄR'!W41,0))","v":0},{"$f":"SUM(B6:F6)","v":1464860.9792889832},{"$f":"'Lönekostnad HB'!J41*Påslag","v":351213.02788203862},{"$f":"'Lönekostnad HB'!M41*Påslag","v":359993.35357908951},{"$f":"'Lönekostnad HB'!P41*Påslag","v":368993.18741856678},{"$f":"'Lönekostnad HB'!S41*Påslag","v":384661.41040928813},{"$f":"'Lönekostnad HB'!V41*Påslag","v":0},{"$f":"SUM(H6:L6)","v":1464860.9792889832},null,{"$f":"M6-N6","v":1464860.9792889832}]
["Resekostnader",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",Resekostnader!B40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",Resekostnader!C40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",Resekostnader!D40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",Resekostnader!E40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",Resekostnader!F40,0))","v":0},0,null,null,null,null,null,null,null,0]
["Externa tjänster",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Externa tjänster'!B40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Externa tjänster'!C40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Externa tjänster'!D40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Externa tjänster'!E40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Externa tjänster'!F40,0))","v":0},0,null,null,null,null,null,null,null,0]
["Övriga kostnader",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Övriga kostnader'!B40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Övriga kostnader'!C40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Övriga kostnader'!D40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Övriga kostnader'!E40,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$47=\"Ja\",'Övriga kostnader'!F40,0))","v":0},0,null,null,null,null,null,null,null,0]
["Lokaler",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$51=\"Ja\",Lokalkostnader!J41,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$51=\"Ja\",Lokalkostnader!K41,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$51=\"Ja\",Lokalkostnader!L41,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$51=\"Ja\",Lokalkostnader!M41,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$51=\"Ja\",Lokalkostnader!N41,0))","v":0},0,null,null,null,null,null,null,null,0]
["Utrustning och avskrivningar",{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$49=\"Ja\",'Utrustning och avskrivningar'!J46,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$49=\"Ja\",'Utrustning och avskrivningar'!K46,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$49=\"Ja\",'Utrustning och avskrivningar'!L46,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$49=\"Ja\",'Utrustning och avskrivningar'!M46,0))","v":0},{"$f":"Grunduppgifter!$D$35*(IF(Grunduppgifter!$C$49=\"Ja\",'Utrustning och avskrivningar'!N46,0))","v":0},0,null,null,null,null,null,null,null,0]
[]
["Finansiär medger fast belopp om:",null,null,null,null,null,{"$f":"SUM(B13:F13)","v":0},null,null,null,null,null,null,null,0]
[]
["Summa påslag",{"$f":"SUM(B6:B14)","v":351213.02788203862},{"$f":"SUM(C6:C14)","v":359993.35357908951},{"$f":"SUM(D6:D14)","v":368993.18741856678},{"$f":"SUM(E6:E14)","v":384661.41040928813},{"$f":"SUM(F6:F14)","v":0},{"$f":"SUM(G6:G14)","v":1464860.9792889832},351213.02788203862,359993.35357908951,368993.18741856678,384661.41040928813,0,1464860.9792889832,0,1464860.9792889832]

{"sheet":"IN KIND","index":12,"n_rows":120,"n_cols":25,"rows_kept":120,"cut":false,"hidden":false,"merged":[[18,13,18,15],[18,16,18,18],[18,19,18,21],[18,22,18,24],[4,1,4,6],[108,1,108,6],[17,7,17,24],[86,4,86,8],[88,0,88,2],[89,0,89,2],[90,0,90,2],[91,0,91,2],[65,4,65,8],[76,4,76,8],[18,0,18,1],[18,2,18,6],[18,7,18,9],[18,10,18,12]]}
["IN KIND"]
[{"$f":"\"Projekt: \"&Grunduppgifter!$B$5","v":"Projekt: "}]
[]
[]
[null,"Sammanställning"]
[null,"År 1","År 2","År 3","År 4","År 5","Summa"]
["Lönekostnader",{"$f":"J27","v":0},{"$f":"K27","v":0},0,0,0,{"$f":"SUM(B7:F7)","v":0}]
["Resekostnader",{"$f":"B41","v":0},{"$f":"C41","v":0},0,0,0,{"$f":"SUM(B8:F8)","v":0}]
["Externa tjänster",{"$f":"B51","v":0},{"$f":"C51","v":0},0,0,0,0]
["Övriga kostnader",{"$f":"B61","v":0},{"$f":"C61","v":0},0,0,0,0]
["Lokalkostnader",{"$f":"J73+J84+J93","v":0},{"$f":"K73+K84+K93","v":0},0,0,0,0]
["Utrustning och avskrivningar",{"$f":"J104","v":0},{"$f":"K104","v":0},0,0,0,0]
["Påslag",{"$f":"B120","v":0},{"$f":"C120","v":0},0,0,0,0]
[null,{"$f":"SUM(B7:B13)","v":0},{"$f":"SUM(C7:C13)","v":0},0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,"Kostnad"]
["Lönekostnader inkl. LKP",null,"Omfattning %",null,null,null,null,"År 1",null,null,"År 2",null,null,"År 3",null,null,"År 4",null,null,"År 5",null,null,"TOTALT"]
["Person / kompetens / roll","Månadslön","År 1","År 2","År 3","År 4","År 5","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT","Lön","LKP","TOT"]
[null,null,null,null,null,null,null,{"$f":"$B21*(1+Löneuppräkning)^a*12*C21","v":0},{"$f":"H21*(LönekostnadspåläggFInansiär)","v":0},{"$f":"H21+I21","v":0},{"$f":"$B21*(1+Löneuppräkning)^b*12*D21","v":0},{"$f":"K21*(LönekostnadspåläggFInansiär)","v":0},{"$f":"K21+L21","v":0},{"$f":"$B21*(1+Löneuppräkning)^c_*12*E21","v":0},{"$f":"N21*(LönekostnadspåläggFInansiär)","v":0},{"$f":"N21+O21","v":0},{"$f":"$B21*(1+Löneuppräkning)^d*12*F21","v":0},{"$f":"Q21*(LönekostnadspåläggFInansiär)","v":0},{"$f":"Q21+R21","v":0},{"$f":"$B21*(1+Löneuppräkning)^e*12*G21","v":0},{"$f":"T21*(LönekostnadspåläggFInansiär)","v":0},{"$f":"T21+U21","v":0},{"$f":"H21+K21+N21+Q21+T21","v":0},0,{"$f":"W21+X21","v":0}]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H21:H26)","v":0},{"$f":"SUM(I21:I26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,"Kostnad"]
["Resekostnader","År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,null,null,null,null,{"$f":"SUM(B36:F36)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B37:F37)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,{"$f":"SUM(B36:B40)","v":0},{"$f":"SUM(C36:C40)","v":0},0,0,0,0]
[]
[]
[null,"Kostnad"]
["Externa tjänster","År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,null,null,null,null,{"$f":"SUM(B46:F46)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B47:F47)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,{"$f":"SUM(B46:B50)","v":0},{"$f":"SUM(C46:C50)","v":0},0,0,0,0]
[]
[]
[null,"Kostnad"]
["Övriga kostnader","År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,null,null,null,null,{"$f":"SUM(B56:F56)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B57:F57)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,{"$f":"SUM(B56:B60)","v":0},{"$f":"SUM(C56:C60)","v":0},{"$f":"SUM(D56:D60)","v":0},{"$f":"SUM(E56:E60)","v":0},{"$f":"SUM(F56:F60)","v":0},{"$f":"SUM(G56:G60)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Tjänsterum",null,null,null,"Omfattning %",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,"kvm","Kr/kvm/år","År 1","År 2","År 3","År 4","År 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"$C68*$D68*E68","v":0},{"$f":"$C68*$D68*F68","v":0},{"$f":"$C68*$D68*G68","v":0},{"$f":"$C68*$D68*H68","v":0},{"$f":"$C68*$D68*I68","v":0},{"$f":"SUM(J68:N68)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"$C69*$D69*E69","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J68:J72)","v":0},{"$f":"SUM(K68:K72)","v":0},{"$f":"SUM(L68:L72)","v":0},{"$f":"SUM(M68:M72)","v":0},{"$f":"SUM(N68:N72)","v":0},{"$f":"SUM(O68:O72)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Interna lokaler",null,null,null,"Antal timmar",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,"Platser","kr/timme","År 1","År 2","År 3","År 4","År 5"]
[null,null,null,null,25,25,25,null,null,{"$f":"$D79*E79","v":0},{"$f":"$D79*F79","v":0},{"$f":"$D79*G79","v":0},{"$f":"$D79*H79","v":0},{"$f":"$D79*I79","v":0},{"$f":"SUM(J79:N79)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"$D80*E80","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J79:J83)","v":0},{"$f":"SUM(K79:K83)","v":0},{"$f":"SUM(L79:L83)","v":0},{"$f":"SUM(M79:M83)","v":0},{"$f":"SUM(N79:N83)","v":0},{"$f":"SUM(O79:O83)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Externa lokaler",null,null,null,"Antal timmar",null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa"]
[null,null,null,"kr/timme","År 1","År 2","År 3","År 4","År 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"$D89*E89","v":0},0,0,0,0,{"$f":"SUM(J89:N89)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J88:J92)","v":0},{"$f":"SUM(K88:K92)","v":0},{"$f":"SUM(L88:L92)","v":0},{"$f":"SUM(M88:M92)","v":0},{"$f":"SUM(N88:N92)","v":0},{"$f":"SUM(O88:O92)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Kostnad"]
["Utrustning/avskrivningar",null,null,null,null,null,null,null,null,"År 1","År 2","År 3","År 4","År 5","Summa"]
[null,"Ansk.värde","Livslängd (År):","År 1","År 2","År 3","År 4","År 5"]
["Dator (> 20 tkr)",null,3,null,null,null,null,null,{"$f":"B100/C100/12","v":0},{"$f":"D100*$I100","v":0},0,0,0,0,{"$f":"SUM(J100:N100)","v":0}]
["Dator (> 20 tkr)",null,10,null,null,null,null,null,{"$f":"B101/C101/12","v":0},0,0,0,0,0,0]
["Utrustning  (> 20 tkr)",null,5,null,null,null,null,null,{"$f":"B102/C102/12","v":0},0,0,0,0,0,0]
["Utrustning  (> 20 tkr)",null,10,null,null,null,null,null,{"$f":"B103/C103/12","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J99:J103)","v":0},{"$f":"SUM(K99:K103)","v":0},{"$f":"SUM(L99:L103)","v":0},{"$f":"SUM(M99:M103)","v":0},{"$f":"SUM(N99:N103)","v":0},{"$f":"SUM(O99:O103)","v":0}]
[]
[]
[]
[]
[null,"Kostnad"]
["Påslag","År 1","År 2","År 3","År 4","År 5","Summa"]
["Lönekostnader inkl. lkp",null,null,null,null,null,{"$f":"SUM(B111:F111)","v":0}]
["Resekostnader",null,null,null,null,null,0]
["Externa tjänster",null,null,null,null,null,0]
["Övriga kostnader",null,null,null,null,null,0]
["Lokaler",null,null,null,null,null,0]
["Utrustning och avskrivningar",null,null,null,null,null,0]
[]
["Fast belopp om:",null,null,null,null,null,{"$f":"SUM(B118:F118)","v":0}]
[]
["Summa påslag",{"$f":"SUM(B111:B119)","v":0},{"$f":"SUM(C111:C119)","v":0},{"$f":"SUM(D111:D119)","v":0},{"$f":"SUM(E111:E119)","v":0},{"$f":"SUM(F111:F119)","v":0},{"$f":"SUM(G111:G119)","v":0}]

{"sheet":"PåläggJaNej","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ja"]
["Nej"]

{"sheet":"Löneuppräkning","index":14,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"Årsfaktor för löneupräkning"]
[]
[null,"Årsfaktorn tar hänsyn till så att angiven löneuppräkning slår ut även de 3 sista månaderna på året. "]
[]
[null,"Projektår",null,"Årsfaktor"]
[null,{"$f":"'Lönekostnad FINANSIÄR'!C5","v":"År 1"},"a",1.2523249999999999]
[null,{"$f":"'Lönekostnad FINANSIÄR'!$D$5","v":"År 2"},"b",{"$f":"a+1","v":2.2523249999999999}]
[null,{"$f":"'Lönekostnad FINANSIÄR'!$E$5","v":"År 3"},"c",{"$f":"b+1","v":3.2523249999999999}]
[null,{"$f":"'Lönekostnad FINANSIÄR'!$F$5","v":"År 4"},"d",{"$f":"c_+1","v":4.2523249999999999}]
[null,{"$f":"'Lönekostnad FINANSIÄR'!$G$5","v":"År 5"},"e",{"$f":"d+1","v":5.2523249999999999}]