{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["personalarforar","SammanstallningPrisma"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"personalarforar","index":0,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,10,13,15]]}
["PERSONAL"]
[null,null,null,null,"Omfattning av heltid (Procent av lönen)",null,null,null,null,null,"Kostnad"]
[null,"Spec","Namn","Lönebelopp heltid vid ansökan","År 1","År 2","År 3","Å3 4","År 5",null,"År 1","År 2 ","År 3 ","År 4 ","År 5","Totalt"]
[1,"Projektledare",null,null,null,null,null,null,null,null,{"$f":"$D4*E4*$C$23*12*$C$24","v":0},{"$f":"$D4*$F4*12*$C$23*$C$24^2","v":0},{"$f":"$D4*$G4*12*$C$23*$C$24^3","v":0},{"$f":"$D4*$H4*12*$C$23*$C$24^4","v":0},{"$f":"$D4*$I4*12*$C$23*$C$24^5","v":0},{"$f":"SUM(K4:O4)","v":0}]
[2,"Övrig, ej disputerad personal ",null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[3,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[4,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[5,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[6,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
["Löner inklusive sociala avgifter totalt",null,null,null,{"$f":"SUM(E4:E9)","v":0},{"$f":"SUM(F4:F9)","v":0},{"$f":"SUM(G4:G9)","v":0},{"$f":"SUM(H4:H9)","v":0},{"$f":"SUM(I4:I9)","v":0},null,{"$f":"SUM(K4:K9)","v":0},0,0,0,0,0]
[]
["Enhetshyra 2023: 6542 kr/kvm",null,null,null,null,null,null,null,null,null,{"$f":"K10*0.13","v":0},{"$f":"L10*0.13","v":0},{"$f":"M10*0.13","v":0},{"$f":"N10*0.13","v":0},{"$f":"O10*0.13","v":0},{"$f":"SUM(K12:O12)","v":0}]
["Lokalpåslag huvudprincip, internhyra 2023: 13%"]
["Lokalpåslag undervisningslokaler, internhyra 2023: 10%",null,null,null,null,null,null,null,null,null,"Grov beräkning. Lite manuell fix/trix behövs för rad 3, samt  om avvikande anskaffningstid. "]
[null,"Avskrivning utrustning",null,"Anskaffningsvärde","Avskrivs på x år",null,null,null,null,null,"Kostnad per år om anskaffning 1. januari år 1",null,null,null,null,"Totalt"]
[1,"Pryl 1",null,null,3,null,null,null,null,null,{"$f":"$D$16/$E$16","v":0},{"$f":"$D$16/$E$16","v":0},{"$f":"$D$16/$E$16","v":0},null,null,{"$f":"SUM(K16:O16)","v":0}]
[2,"Pryl 2",null,null,5,null,null,null,null,null,{"$f":"$D$17/$E$17","v":0},{"$f":"$D$17/$E$17","v":0},{"$f":"$D$17/$E$17","v":0},{"$f":"$D$17/$E$17","v":0},{"$f":"$D$17/$E$17","v":0},{"$f":"SUM(K17:O17)","v":0}]
[3,"Pryl 3"]
[null,"Avskrivning utrustning totalt",null,{"$f":"SUM(D16:D18)","v":0},null,null,null,null,null,null,{"$f":"SUM(K16:K18)","v":0},{"$f":"SUM(L16:L17)","v":0},{"$f":"SUM(M16:M17)","v":0},{"$f":"SUM(N16:N17)","v":0},{"$f":"SUM(O16:O17)","v":0},{"$f":"SUM(P16:P17)","v":0}]
[]
[]
[null,{"$f":"SammanstallningPrisma!C49","v":"Procent"},{"$f":"SammanstallningPrisma!D49","v":"Faktor"}]
[{"$f":"SammanstallningPrisma!B50","v":"LKPmm lön (2023)"},0.55449999999999999,{"$f":"SammanstallningPrisma!D50","v":1.5545}]
[{"$f":"SammanstallningPrisma!B51","v":"Årlig löneökn"},{"$f":"SammanstallningPrisma!C51","v":2.5000000000000001E-2},{"$f":"SammanstallningPrisma!D51","v":1.0249999999999999}]
[{"$f":"SammanstallningPrisma!B52","v":"Kostnader för stödverksamhet Lingvistik 2023"},{"$f":"OHFUFling","v":0.51}]
["Prisökning årlig",1.4999999999999999E-2,{"$f":"1+B26","v":1.0149999999999999}]

{"sheet":"SammanstallningPrisma","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[47,1,48,1],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[2,3,2,8],[14,3,14,8],[19,3,19,8],[29,3,29,8],[36,3,36,8]]}
[]
[null,"Löner inklusive sociala avgifter"]
[null,null,null,"Mata in omfattning och lön i bladet \"personalarforar\" (personal år för år), uppgifterna hämtas upp därifrån till denna tabell."]
[null,"Spec","Omfattning av heltid (Procent av lönen)","År 1","År 2 ","År 3 ","År 4 ","År 5","Totalt"]
[{"$f":"personalarforar!A4","v":1},{"$f":"personalarforar!C4","v":0},null,{"$f":"personalarforar!K4","v":0},{"$f":"personalarforar!L4","v":0},{"$f":"personalarforar!M4","v":0},{"$f":"personalarforar!N4","v":0},{"$f":"personalarforar!O4","v":0},{"$f":"SUM(D5:H5)","v":0}]
[{"$f":"personalarforar!A5","v":2},{"$f":"personalarforar!C5","v":0},null,{"$f":"personalarforar!K5","v":0},{"$f":"personalarforar!L5","v":0},{"$f":"personalarforar!M5","v":0},{"$f":"personalarforar!N5","v":0},{"$f":"personalarforar!O5","v":0},0]
[{"$f":"personalarforar!A6","v":3},{"$f":"personalarforar!C6","v":0},null,{"$f":"personalarforar!K6","v":0},{"$f":"personalarforar!L6","v":0},{"$f":"personalarforar!M6","v":0},{"$f":"personalarforar!N6","v":0},{"$f":"personalarforar!O6","v":0},0]
[{"$f":"personalarforar!A7","v":4},{"$f":"personalarforar!C7","v":0},null,{"$f":"personalarforar!K7","v":0},{"$f":"personalarforar!L7","v":0},{"$f":"personalarforar!M7","v":0},{"$f":"personalarforar!N7","v":0},{"$f":"personalarforar!O7","v":0},0]
[{"$f":"personalarforar!A8","v":5},{"$f":"personalarforar!C8","v":0},null,{"$f":"personalarforar!K8","v":0},{"$f":"personalarforar!L8","v":0},{"$f":"personalarforar!M8","v":0},{"$f":"personalarforar!N8","v":0},{"$f":"personalarforar!O8","v":0},0]
[{"$f":"personalarforar!A9","v":6},{"$f":"personalarforar!C9","v":0},null,{"$f":"personalarforar!K9","v":0},{"$f":"personalarforar!L9","v":0},{"$f":"personalarforar!M9","v":0},{"$f":"personalarforar!N9","v":0},{"$f":"personalarforar!O9","v":0},0]
[null,"Löner inklusive sociala avgifter totalt",null,{"$f":"SUM(D5:D10)","v":0},0,0,0,0,0]
[]
[]
[null,"Övriga kostnader"]
[null,"Lokaler",null,"Uppgifterna hämtas upp från bladet \"personalarforar\""]
[null,"Typav av lokal",null,{"$f":"D4","v":"År 1"},{"$f":"E4","v":"År 2 "},{"$f":"F4","v":"År 3 "},{"$f":"G4","v":"År 4 "},{"$f":"H4","v":"År 5"},"Totalt"]
[1,"Kontor",null,{"$f":"personalarforar!K12","v":0},{"$f":"personalarforar!L12","v":0},{"$f":"personalarforar!M12","v":0},{"$f":"personalarforar!N12","v":0},{"$f":"personalarforar!O12","v":0},{"$f":"SUM(D17:H17)","v":0}]
[null,"Lokaler totalt",null,{"$f":"D17","v":0},{"$f":"E17","v":0},{"$f":"F17","v":0},{"$f":"G17","v":0},{"$f":"H17","v":0},{"$f":"SUM(D18:H18)","v":0}]
[]
[null,"Driftskostnader",null,"Skriv in kostnaden för varje rad och år för sig (ental kronor)"]
[1,"Resor",null,null,null,null,null,null,{"$f":"SUM(D21:H21)","v":0}]
[2,"Litteratur",null,null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[3,"Datorer och programvara (om ej under utrustning)",null,null,null,null,null,null,0]
[4,"Open Access",null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,0]
[null,"Driftskostnader totalt",null,{"$f":"SUM(D21:D27)","v":0},0,0,0,0,0]
[]
[null,"Avskrivning utrustning",null,{"$f":"D15","v":"Uppgifterna hämtas upp från bladet \"personalarforar\""}]
[1,{"$f":"personalarforar!B16","v":"Pryl 1"},null,{"$f":"personalarforar!K16","v":0},{"$f":"personalarforar!L16","v":0},{"$f":"personalarforar!M16","v":0},{"$f":"personalarforar!N16","v":0},{"$f":"personalarforar!O16","v":0},{"$f":"SUM(D31:H31)","v":0}]
[2,{"$f":"personalarforar!B17","v":"Pryl 2"},null,{"$f":"personalarforar!K17","v":0},{"$f":"personalarforar!L17","v":0},{"$f":"personalarforar!M17","v":0},{"$f":"personalarforar!N17","v":0},{"$f":"personalarforar!O17","v":0},{"$f":"SUM(D32:H32)","v":0}]
[3,{"$f":"personalarforar!B18","v":"Pryl 3"},null,{"$f":"personalarforar!K18","v":0},{"$f":"personalarforar!L18","v":0},{"$f":"personalarforar!M18","v":0},{"$f":"personalarforar!N18","v":0},{"$f":"personalarforar!O18","v":0},{"$f":"SUM(D33:H33)","v":0}]
[null,"Avskrivning utrustning totalt",null,{"$f":"SUM(D31:D33)","v":0},0,0,0,0,0]
[]
[null,"Total kostnad för projektet"]
[null,null,null,"Uppgifterna hämtas upp från delspecifikationerna ovan. Indirekta kostnader beräknas automatiskt med oh påslag (spec nedan) på löner inklusive sociala avgifter ovan."]
[null,{"$f":"B2","v":"Löner inklusive sociala avgifter"},null,{"$f":"D11","v":0},{"$f":"E11","v":0},{"$f":"F11","v":0},{"$f":"G11","v":0},{"$f":"H11","v":0},{"$f":"SUM(D38:H38)","v":0}]
[null,"Driftskostnader",null,{"$f":"D28","v":0},{"$f":"E28","v":0},{"$f":"F28","v":0},{"$f":"G28","v":0},{"$f":"H28","v":0},{"$f":"SUM(D39:H39)","v":0}]
[null,"Avsksrivningar utrustning",null,{"$f":"D34","v":0},{"$f":"E34","v":0},{"$f":"F34","v":0},{"$f":"G34","v":0},{"$f":"H34","v":0},{"$f":"SUM(D40:H40)","v":0}]
[null,"Lokaler",null,{"$f":"D18","v":0},{"$f":"E18","v":0},{"$f":"F18","v":0},{"$f":"G18","v":0},{"$f":"H18","v":0},{"$f":"SUM(D41:H41)","v":0}]
[null,"Delsumma (före oh)",null,{"$f":"SUM(D38:D41)","v":0},0,0,0,0,0]
[null,"Indirekta kostnader",null,{"$f":"OHFUFling*D11","v":0},{"$f":"OHFUFling*E11","v":0},{"$f":"OHFUFling*F11","v":0},{"$f":"OHFUFling*G11","v":0},{"$f":"OHFUFling*H11","v":0},{"$f":"SUM(D43:H43)","v":0}]
[null,"TOTAL PROJEKTKOSTNAD",null,{"$f":"SUM(D42:D43)","v":0},{"$f":"SUM(E42:E43)","v":0},{"$f":"SUM(F42:F43)","v":0},{"$f":"SUM(G42:G43)","v":0},{"$f":"SUM(H42:H43)","v":0},{"$f":"SUM(D44:H44)","v":0}]
[]
[]
[]
[null,"Dessa uppgifter hämtas härifrån till bladet \"personalarforar\""]
[null,null,"Procent","Faktor"]
[null,"LKPmm lön (2023)",0.55449999999999999,{"$f":"1+C50","v":1.5545}]
[null,"Årlig löneökn",2.5000000000000001E-2,{"$f":"1+C51","v":1.0249999999999999}]
[null,"Kostnader för stödverksamhet Lingvistik 2023",0.51,{"$f":"1+OHFUFling","v":1.51}]
[null,{"$f":"personalarforar!A26","v":"Prisökning årlig"},{"$f":"personalarforar!B26","v":1.4999999999999999E-2},{"$f":"personalarforar!C26","v":1.0149999999999999}]