{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Kursus","TAP-Økonomiark","Grønt ark til upload i ERP","Lopslag"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":7,"defined_names":23,"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":"Kursus","index":0,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[75,0,75,5],[13,2,13,5],[0,0,0,5],[39,0,42,0],[44,0,63,0],[23,0,37,0],[21,0,21,5],[9,2,9,5],[11,2,11,5],[15,2,15,5],[7,2,7,5],[1,2,1,5],[3,2,3,5],[5,2,5,5]]}
["Budget"]
[null,"Kursus/ydelse"]
[]
[null,"Kort beskrivelse af kurset og forløbet eller ydelsen"]
[]
[null,"Bevillingsgiver (virksomhed)"]
[]
[null,"Ansvarlig VIP"]
[]
[null,"Dato"]
[]
[null,"Tid"]
[]
[null,"Sted"]
[]
[null,"Antal dage/timer"]
[]
[null,"Antal forløb",null,1]
[null,{"$f":"+IF(B18=\"Antal forløb\",\"Aftalt pris for et samlet forløb\",\"Individuel pris pr. person - ekskl. moms\")","v":"Aftalt pris for et samlet forløb"},null,0]
[null,"Samlet indtægt",null,{"$f":"+D18*D19","v":0}]
[]
["Udgifter "]
[]
["Løn til dig og dine kollegaer","Titel","Direkte arbejdstimer","Timer for kørsel","Arbejdstimer i alt","Beløb"]
[null,"Vælg titel…",0,0,{"$f":"+C25+D25","v":0},{"$f":"+VLOOKUP(B25,kostprisVIP,2,FALSE)*E25","v":0}]
[null,"Vælg titel…",0,0,{"$f":"+C26+D26","v":0},{"$f":"+VLOOKUP(B26,kostprisVIP,2,FALSE)*E26","v":0}]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[null,"Vælg titel…",0,0,0,0]
[]
[null,"Honoraraflønning (ikke ansat på SDU)",null,null,null,0]
[]
[null,"Konsulentydelser – ekstern underviser med CVR nummer:",null,null,null,0]
[]
["Admini-stration","Opgave","Titel","Arbejdstimer i alt","Timeløn","Beløb"]
[null,"Kursusadministration","AC, fuldmægtig",0,{"$f":"+VLOOKUP(C41,Lopslag!$H$20:$K$26,2,FALSE)","v":381},{"$f":"+D41*E41","v":0}]
[null,"Kommunikation","AC, fuldmægtig",0,{"$f":"+VLOOKUP(C42,Lopslag!$H$20:$K$26,2,FALSE)","v":381},{"$f":"+D42*E42","v":0}]
[null,"Studentermedhjælp","Studentermedhjælp HK",0,{"$f":"+VLOOKUP(C43,Lopslag!$H$20:$K$26,2,FALSE)","v":160},{"$f":"+D43*E43","v":0}]
[]
["Øvrig drift","Rejseudgifter via zExpense- underviser og konsulenter",null,null,null,0]
[null,"SDU-forplejning - deltagerer og undervisere - pris pr. deltager",null,null,0,{"$f":"+E46*(D18+COUNTIF(E25:E32,\">0\"))","v":0}]
[null,"Markedsføring - trykt på SDU",null,null,null,0]
[null,"Øvrig drift - andre SDU omkostninger",null,null,null,0]
[]
[null,"Leje af lokale til undervisning (på SDU) - pris kan fås ved henvendelse til 8888@sdu.dk",null,null,null,0]
[]
[null,"Leje af lokale til undervisning (ikke på SDU)",null,null,null,0]
[]
[null,"Forplejning:",null,null,"Beløb pr. deltager"]
[null,"* Hotel-konferencepakke – hel dag",null,null,0,{"$f":"+E55*($D$18+COUNTIF($E$25:$E$34,\">0\"))","v":0}]
[null,"* Hotel-pakke – halv dag ",null,null,0,{"$f":"+E56*($D$18+C56)","v":0}]
[]
[null,"Indkvartering/Hotelovernatning – kursister",null,null,0,{"$f":"+E58*D18","v":0}]
[]
[null,"Kursusmateriale (direkte udgifter til artikler/bøger mv) - ikke leveret af SDU",null,null,0,{"$f":"+E60*D18","v":0}]
[null,"Markedsføring (direkte udgifter, annoncer, tryksager mv.) - ikke leveret af SDU",null,null,null,0]
[]
[null,{"$f":"IF(D63=0,\"Vingaver\",CONCATENATE(\"Vingaver - køb af \",D63,\" stk. \",\" - pris pr. vingave kr. \",E63))","v":"Vingaver"},"Antal vingaver",0,150,{"$f":"+D63*E63","v":0}]
[null,"Øvrig drift",null,null,null,0]
[]
[null,"I alt direkte projektomkostninger",null,null,null,{"$f":"+SUM(F25:F64)","v":0}]
[]
[null,"Overhead - Beregnes automatisk",null,null,null,{"$f":"+F77+F78","v":0}]
[]
[null,"Minimumspris",null,null,null,{"$f":"+F68+F66","v":0}]
[]
[null,"Ønsket overskud",null,null,null,0]
[]
[null,"Salgspris",null,null,null,{"$f":"+F72+F70","v":0}]
[]
["Projektudgifter SDU IV-regler - beregnet på baggrund af indtægt"]
[null,{"$f":"+CONCATENATE(\"Overhead af direkte omkostninger \",\"(\",Lopslag!I33*100,\" %\",\")\")","v":"Overhead af direkte omkostninger (120 %)"},null,null,null,{"$f":"+(SUM(F25:F34)+SUM(F41:F43))*(Lopslag!I33)","v":0}]
[null,{"$f":"+CONCATENATE(\"Overhead af konsulentomkostninger \",\"(\",Lopslag!I34*100,\" %\",\")\")","v":"Overhead af konsulentomkostninger (10 %)"},null,null,null,{"$f":"+((SUM(F45:F64))+F36+F38)*(Lopslag!I34)","v":0}]
[null,"Overskud/underskud overført til UK10",null,null,{"$f":"+IF(F79<0,\"Denne må ikke være negativ, da projektet skal give overskud i henhold til gældende regelsæt\",\" \")","v":" "},{"$f":"+D20-F66-F77-F78","v":0}]
[null,"Direkte projektomkostninger",null,null,null,{"$f":"+F66","v":0}]
[null,"Udgifter i alt (= samlede indtægter)",null,null,null,{"$f":"SUM(F77:F80)","v":0}]

{"sheet":"TAP-Økonomiark","index":1,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,2],[6,1,6,2],[12,1,12,4],[41,1,41,4]]}
[]
[null,"UK90-aktivitet til afrapporteringsskema"]
[null,"Løn",{"$f":"+SUM(Kursus!F25:F36)+SUM(Kursus!F41:F43)","v":0}]
[null,"Drift",{"$f":"+Kursus!D20-'TAP-Økonomiark'!C3","v":0}]
[null,"Total",{"$f":"SUM(C3:C4)","v":0}]
[]
[null,"Påvirkning af instituttets indtægter på ordinær økonomi (UK10)"]
[null,"OH indtægt",{"$f":"+Kursus!F77+Kursus!F78","v":0}]
[null,"Projektafgift (10% af alle udgifter)",{"$f":"-0.1*C5","v":0}]
[null,"Overskud/underskud til institut",{"$f":"+Kursus!F79","v":0}]
[null,"Samlet resultat til fordeling efter projektafgift",{"$f":"SUM(C8:C10)","v":0}]
[]
[null,"Intern SDU-afregning"]
[]
[null,"Beregninger tager udgangspunkt i følgende:"]
[null,{"$f":"+Kursus!B18","v":"Antal forløb"},null,null,{"$f":"+Kursus!D18","v":1}]
[null,{"$f":"+Kursus!B19","v":"Aftalt pris for et samlet forløb"},null,null,{"$f":"+Kursus!D19","v":0}]
[]
[null,"Samlet overskud"]
[null,"Overhead",null,null,{"$f":"+Kursus!F77+Kursus!F78","v":0}]
[null,"Overskud",null,null,{"$f":"+Kursus!F79","v":0}]
[null,"Total",null,null,{"$f":"SUM(E20:E21)","v":0}]
[]
[null,"Administration - skal dækkes af overskuddet",null,"Omk.sted",{"$f":"+SUM(E25:E27)","v":0}]
[null,"Rektor/fællesadministration - Projektafgift 10%",null,99999,{"$f":"+Kursus!D20*0.1","v":0}]
[null,"Økonomiadministration",null,null,0]
[null,"Administrativ support - Conference Manager samt koordinering",null,null,0]
[null,"Rest af overskud ",null,null,{"$f":"+E22-E25","v":0}]
[]
[null,"VIP - Andel pr. institut - direkte aflønning af arbejdstimer","Navn - skriv selv","Timer til bogføring","Beløb på projektet","\"Faglig erfaring, - netværk og - udvikling\" - antal timer","Omregnet til beløb"]
[null,{"$f":"+Kursus!B25","v":"Vælg titel…"},null,{"$f":"+Kursus!E25","v":0},{"$f":"+Kursus!F25","v":0},50,{"$f":"+F31*(VLOOKUP(B31,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B26","v":"Vælg titel…"},null,{"$f":"+Kursus!E26","v":0},{"$f":"+Kursus!F26","v":0},10,{"$f":"+F32*(VLOOKUP(B32,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B27","v":"Vælg titel…"},null,{"$f":"+Kursus!E27","v":0},{"$f":"+Kursus!F27","v":0},0,{"$f":"+F33*(VLOOKUP(B33,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B28","v":"Vælg titel…"},null,{"$f":"+Kursus!E28","v":0},{"$f":"+Kursus!F28","v":0},0,{"$f":"+F34*(VLOOKUP(B34,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B29","v":"Vælg titel…"},null,{"$f":"+Kursus!E29","v":0},{"$f":"+Kursus!F29","v":0},0,{"$f":"+F35*(VLOOKUP(B35,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B30","v":"Vælg titel…"},null,{"$f":"+Kursus!E30","v":0},{"$f":"+Kursus!F30","v":0},0,{"$f":"+F36*(VLOOKUP(B36,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B31","v":"Vælg titel…"},null,{"$f":"+Kursus!E31","v":0},{"$f":"+Kursus!F31","v":0},0,{"$f":"+F37*(VLOOKUP(B37,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B32","v":"Vælg titel…"},null,{"$f":"+Kursus!E32","v":0},{"$f":"+Kursus!F32","v":0},0,{"$f":"+F38*(VLOOKUP(B38,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B33","v":"Vælg titel…"},null,{"$f":"+Kursus!E33","v":0},{"$f":"+Kursus!F33","v":0},0,{"$f":"+F39*(VLOOKUP(B39,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[null,{"$f":"+Kursus!B34","v":"Vælg titel…"},null,{"$f":"+Kursus!E34","v":0},{"$f":"+Kursus!F34","v":0},0,{"$f":"+F40*(VLOOKUP(B40,Lopslag!$H$4:$K$15,2,FALSE))","v":0}]
[]
[null,"Intern fordeling/disponering af overskud"]
[null,"Fordeling af overhead og overskud",null,{"$f":"+E22","v":0},"Bemærkning"]
[null,"Rektor = 10% projektafgift",null,{"$f":"-C5*0.1","v":0},99999]
[null,"Økonomiadministration",null,0]
[null,{"$f":"+B27","v":"Administrativ support - Conference Manager samt koordinering"},null,{"$f":"-E27","v":0}]
[null,"Rest overskud - evt. disponering efter aftale med ansvarlig VIP",null,{"$f":"+D43+SUM(D44:D46)","v":0},"Bemærkning"]
[null,"Engangsvederlag","Forsker XX",0,"Løn"]
[null,"Konference til USA","Forsker YY",0,"Drift"]
[null,"\"Faglig erfaring, - netværk og - udvikling\" ",null,{"$f":"+SUM(G31:G40)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Rest til enhed",null,{"$f":"+D47-SUM(D48:D56)","v":0}]

{"sheet":"Grønt ark til upload i ERP","index":2,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[[92,15,92,16],[0,4,3,5],[16,15,16,16],[18,15,18,16],[19,15,19,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[87,15,87,16],[89,15,89,16],[90,15,90,16],[91,15,91,16]]}
["Projekttype:",null,"T-01 - STANDARD",null,"Data/tekst er hentet automatisk fra øvrige ark, men kan overskrives ved behov."]
[]
["Dato for budgetudarbejdelse:",null,"2024-07-01"]
["Indeværende år",null,2024]
[]
["Dato for budgetstart:",null,"2024-12-01",null,"Kun farvede felter skal udfyldes!"]
["Dato for budgetslut:",null,"2024-12-31"]
[]
["Projektnummer:",null,{"$f":"+_xlfn.CONCAT(90,\"-\",'[7]1. Budgetark - aktivitet'!B22,\" - xxxxxxx\")","v":"90- - xxxxxxx"}]
["Projekt-titel:",null,{"$f":"+Kursus!C2","v":0}]
["Bevillingshaver:",null,{"$f":"+Kursus!C8","v":0}]
["Overhead:"]
[]
["Bevillingsgiver:",null,{"$f":"+Kursus!C6","v":0}]
["Samlet bevillling i alt:",null,{"$f":"+Kursus!D20","v":0}]
[]
["Underkonto","Analyse Nr. ","Opgavenavn","Artskonto",{"$f":"+C4","v":2024},{"$f":"E17+1","v":2025},{"$f":"F17+1","v":2026},{"$f":"G17+1","v":2027},{"$f":"H17+1","v":2028},{"$f":"I17+1","v":2029},{"$f":"+J17+1","v":2030},{"$f":"+K17+1","v":2031},{"$f":"+L17+1","v":2032},{"$f":"+M17+1","v":2033},"Hovedtotal","Meddelelser"]
[null,null,null,null,"Total","Total","Total","Total","Total","Total",{"$f":"+J18","v":"Total"},{"$f":"+K18","v":"Total"},{"$f":"+L18","v":"Total"},{"$f":"+L18","v":"Total"},"Dkk"]
[]
["UK 90, 95 el. 97","01100","[T01 VIP-løn]","180000",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:N20)","v":0}]
[null,"01110","[T01 VIP-løn] Frikøb/Omkontering","180000",{"$f":"+'[7]1. Budgetark - aktivitet'!C38","v":0},null,null,null,null,null,null,null,null,null,0]
[null,"01120","[T01 VIP-løn] Ratetilpasning","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01130","[T01 VIP-løn] Ph.D","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01140","[T01 VIP-løn] Post Doc","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01150","[T01 VIP-løn] Videnskabelig assistent","180000",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01200","[T01 TAP-løn]","180000",{"$f":"+'[7]1. Budgetark - aktivitet'!C44","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:N27)","v":0}]
[null,"01210","[T01 TAP-løn] Frikøb/Omkontering","180000",{"$f":"+'[7]1. Budgetark - aktivitet'!C45","v":0},null,null,null,null,null,null,null,null,null,0]
[null,"01220","[T01 TAP-løn] Ratetilpasning","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01230","[T01 TAP-løn] Studentermedhjælp","180000",{"$f":"+'[7]1. Budgetark - aktivitet'!C43","v":0},null,null,null,null,null,null,null,null,null,0]
[null,"01240","[T01 TAP-løn] Sekretær","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01250","[T01 TAP-løn] Laborant","180000",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01300","[T01 Rejser]","220000",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:N34)","v":0}]
[null,"01301","[T01 Rejser]","220000",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:N35)","v":0}]
[null,"01303","[T01 Rejser]","220000",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E36:N36)","v":0}]
[]
[null,"01400","[T01 Drift]",220000,{"$f":"+'[7]1. Budgetark - aktivitet'!C70","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(E38:N38)","v":0}]
[null,"01401","[T01 Drift] Småanskaffelser","220000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01402","[T01 Drift] Formidling",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01403","[T01 Drift] Dataindsamling",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01404","[T01 Drift] Publicering",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01405","[T01 Drift] Ph.D udgifter",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01406","[T01 Drift] Konsulentudgifter",220000,{"$f":"+'[7]1. Budgetark - aktivitet'!C49","v":0},null,null,null,null,null,null,null,null,null,0]
[null,"01407","[T01 Drift] Øvrige honorarer",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01408","[T01 Drift] Gæsteprofessorer",220000,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01500","[T01 Taxametertilskud]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E48:N48)","v":0}]
[]
[null,"01990","[T01 Overskud UK90]","431085",{"$f":"+'[7]1. Budgetark - aktivitet'!C74","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(E50:N50)","v":0}]
[null,"01400","[T01 Intern afregning UK90]","431082",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E51:N51)","v":0}]
[]
[null,"01600","[T01 Apparatur] over kr. 100.000,-",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E53:N53)","v":0}]
[null,"01650","[T01 Apparatur] under kr. 100.000,-",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E54:N54)","v":0}]
[]
[null,"09990","Overhead","431000",{"$f":"SUM(E20:E49,E51:E54)*$C$12/100","v":0},{"$f":"SUM(F20:F49,F51:F54)*$C$12/100","v":0},{"$f":"SUM(G20:G49,G51:G54)*$C$12/100","v":0},0,0,0,0,0,0,0,{"$f":"SUM(E56:N56)","v":0}]
["UK10","01100","[T01 VIP-løn]","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01110","[T01 VIP-løn] Frikøb/Omkontering","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01120","[T01 VIP-løn] Ratetilpasning","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01130","[T01 VIP-løn] Ph.D","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01140","[T01 VIP-løn] Post Doc","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01150","[T01 VIP-løn] Videnskabelig assistent","180000",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01200","[T01 TAP-løn]","180000",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E64:N64)","v":0}]
[null,"01210","[T01 TAP-løn] Frikøb/Omkontering","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01220","[T01 TAP-løn] Ratetilpasning","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01230","[T01 TAP-løn] Studentermedhjælp","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01240","[T01 TAP-løn] Sekretær","180000",null,null,null,null,null,null,null,null,null,null,0]
[null,"01250","[T01 TAP-løn] Laborant","180000",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01300","[T01 Rejser]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E71:N71)","v":0}]
[null,"01301","[T01 Rejser]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:N72)","v":0}]
[null,"01303","[T01 Rejser]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E73:N73)","v":0}]
[]
[null,"01400","[T01 Drift]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E75:N75)","v":0}]
[null,"01401","[T01 Drift] Småanskaffelser",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01402","[T01 Drift] Formidling",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01403","[T01 Drift] Dataindsamling",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01404","[T01 Drift] Publicering",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01405","[T01 Drift] Ph.D udgifter",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01406","[T01 Drift] Konsulentudgifter",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01407","[T01 Drift] Øvrige honorarer",220000,null,null,null,null,null,null,null,null,null,null,0]
[null,"01408","[T01 Drift] Gæsteprofessorer",220000,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"01500","[T01 Taxametertilskud]",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E85:N85)","v":0}]
[]
[null,"01600","[T01 Apparatur] over kr. 100.000,-",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E87:N87)","v":0}]
[null,"01650","[T01 Apparatur] under kr. 100.000,-",220000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E88:N88)","v":0}]
[]
[null,"09990","Medfinansieret Overhead","431000",{"$f":"SUM(E57:E89)*$C$12/100","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E90:N90)","v":0}]
[]
[]
["I alt",null,null,null,{"$f":"SUM(E20:E92)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E93:N93)","v":0}]
[]
[]
["NB! Såfremt der er brug for yderligere linjer, indsæt da selv flere linier."]

{"sheet":"Lopslag","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,7,0,10],[16,7,16,10],[28,8,28,13],[1,7,2,7],[1,8,2,8],[17,7,18,7],[17,8,18,8]]}
[null,null,null,null,null,null,null,"VIP-projektmedarbejder"]
["Institut","EAN","omk","kort navn","institutleder","Økonomimedarb. ",null,"Stilling - kostpris tilrettet - 2024 priser","KOST\nPRIS\npr. time",null,"IDV-Salgspris pr. time"]
["Vælg arbejdssted…","","","","","",null,null,null,null,1.2]
["SAMF FØS",5798000423190,59000,"SAM FØS","Torben Durck Johansen","Tanja H. Hansen",null,"Vælg titel…",0,null,{"$f":"CEILING(I4+(I4*($K$3)),10)","v":0}]
["SAMF UDD",5798000423190,59100,"SAM UDD","Annette Schmidt","Tanja H. Hansen",null,"Adjunkt",381,null,{"$f":"CEILING(I5+(I5*($K$3)),10)","v":840}]
[null,null,null,null,null,null,null,"Ingeniør",450,null,{"$f":"CEILING(I6+(I6*($K$3)),10)","v":990}]
["Institut for Erhverv og Bæredygtighed",5798000423237,52400,"IEB","Christian Elmelund-Præstekær","Hanne Damkjær/Anette Skov Johnsen",null,"Ekstern lektor",320,null,710]
["Økonomisk Institut",5798000423251,52600,"ECON","Lone Grønbæk","Astrid Holm Nielsen",null,"Lektor",455,null,1010]
["Juridisk Institut",5798000423305,55500,"JURA","Hanne Søndergaard Birkmose","Dorthe Carstensen",null,"Post Doc",381,null,840]
["Institut for Statskundskab",5798000423312,55600,"STAT","Signe Pihl-Thingvad","Anette Schmidt/Ann Skovly",null,"Professor",608,null,1340]
[null,null,null,null,null,null,null,"Professor, MSO",560,null,1240,"Gennemsnitspris SAMF"]
[null,null,null,null,null,null,null,"Specialkonsulent",390,null,860,"Gennemsnitspris SAMF"]
["OH i % til beregning i denne aktivitet ",1.17,null,null,null,null,null,"Chefkonsulent",445,null,980,"Gennemsnitspris SAMF"]
[null,null,null,null,null,null,null,"Seniorådgiver",420,null,930,"Gennemsnitspris SAMF"]
[null,null,null,null,null,null,null,"Videnskabelig assistent",352,null,780,"Gennemsnitspris SAMF"]
[]
[null,null,null,null,null,null,null,"TAP-administration"]
[null,null,null,null,null,null,null,"Stilling - kostpris tilrettet - 2024 priser","KOST\nPRIS",null,"SDU OH %"]
[null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,"Vælg titel…",0,null,{"$f":"CEILING(I20+(I20*($K$19)),10)","v":0}]
[null,null,null,null,null,null,null,"AC, fuldmægtig",381,null,{"$f":"CEILING(I21+(I21*($K$19)),10)","v":840}]
[null,null,null,null,null,null,null,"HK, laborant",326,null,720,"Gennemsnitspris SAMF"]
[null,null,null,null,null,null,null,"HK, sekretær",326,null,720]
[null,null,null,null,null,null,null,"Chefkonsulent",460,null,1020]
[null,null,null,null,null,null,null,"Specialkonsulent",405,null,900]
[null,null,null,null,null,null,null,"Studentermedhjælp HK",160,null,360,"Gennemsnitspris SAMF"]
[]
[]
[null,null,null,null,null,null,null,"Kilde:","Prisblad for indtægtsdækket virksomhed (2024-priser)"]
[]
[null,null,null,null,null,null,null,"Tjek selv timepris i QlikView. Løn (Timepris)"]
[]
[null,null,null,null,null,null,null,{"$f":"+CONCATENATE(\"Overhead af direkte omkostninger \",\"(\",Lopslag!I33*100,\" %\",\")\")","v":"Overhead af direkte omkostninger (120 %)"},1.2]
[null,null,null,null,null,null,null,{"$f":"+CONCATENATE(\"Overhead af konsulentomkostninger \",\"(\",Lopslag!I34*100,\" %\",\")\")","v":"Overhead af konsulentomkostninger (10 %)"},0.1]