{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Simpelt Input","Detaljer Simpel","Hjælpemidler (Simpel)","Udvidet input","Hjælpemidler (Udvidet)","Eksempel (Udvidet)","Ark1","Stamoplysninger (eksempel)","Detaljer (eksempel)","Detaljer (Udvidet)","Stamoplysninger"],"not_rendered":{"charts":4,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Simpelt Input","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Prisen for en fejlrekruttering - en økonomisk beregner"]
[]
[null,"Kandidatomkostninger"]
[null,"Omkostninger for kandidataens arbejdskraft."]
[null,"Årsløn inkl. pension"]
[null,"Personalegoder",null,"F.eks. bil, telefon"]
[]
[null,"Kandidatens værditilførelse"]
[null,"Den værdi kandidaten tilfører til virksomheden. OBS. Udfyld kun ét af felterne."]
[null,"Specifikt mål (f.eks.  Et salgsmål)",null,"Udfyldes hvis der til stillingen er udarbejdet et specifikt mål. F.eks ved salg."]
[null,"I forhold til kandidatens løn",null,"Udfyldes hvis kandidaten forventes af tilføre sin løn samt et markup. Udfyldes i % - f.eks 160%, hvis kandidaten tilfører 60% overskud af sin løn."]
[]
[]
[null,"Rekrutteringsomkostninger"]
[null,"Omkostninger før en kandidat er ansat."]
[null,"Annoncering",null,"Omkostninger i forbindelse med opstartsmøder, udarbejdelse af stillingsopslag, annoncering mv."]
[null,"Ekstern Konsulent ",null,"samlet fee til ekstern konsulent, internt arbejde med konsulent mv."]
[null,"Tests",null,"Omkostninger i forbindelse med gennemgang af kandidater, testtagning, gennemgang af tests, tilbagemelding mv."]
[null,"Øvrige",null,"Andet."]
[null,"I alt til rekruttering",{"$f":"SUM(C20:C23)","v":0}]
[]
[]
[null,"Onboardingomkostninger"]
[null,"Omkostninger efter kandidaten er ansat som led i oplæring mv."]
[null,"Oplæring og kurser",null,"Omkostninger i forbindelse med oplæring af kandidaten."]
[null,"Indkøb af udstyr",null,"Omkostninger i forbindelse med indkøb af udstyr."]
[null,"Øvrige",null,"Andet."]
[null,"I alt til onboarding",{"$f":"SUM(C29:C31)","v":0}]
[]
[]
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"-'Detaljer Simpel'!I15","v":0},{"$f":"-'Detaljer Simpel'!O15","v":0},{"$f":"-'Detaljer Simpel'!U15","v":0},{"$f":"-'Detaljer Simpel'!AA15","v":0}]

{"sheet":"Detaljer Simpel","index":1,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Cashflow, udgifter"]
[null,"Måned",-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"Headhunter",{"$f":"'Simpelt Input'!$C$21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rekrutteringsomkostninger",{"$f":"'Simpelt Input'!$C$20+'Simpelt Input'!$C$22+'Simpelt Input'!$C$23+'Simpelt Input'!$C$10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onboarding",0,{"$f":"'Simpelt Input'!$C$32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Løn til kandidat",0,{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0},{"$f":"'Simpelt Input'!$C$9/12","v":0}]
[null,"I alt",{"$f":"SUM(C5:C8)","v":0},{"$f":"SUM(D5:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cashflow, indtægter"]
[null,"Værdi for virksomhed",0,{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!D18*'Detaljer Simpel'!D8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!E18*'Detaljer Simpel'!E8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!F18*'Detaljer Simpel'!F8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!G18*'Detaljer Simpel'!G8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!H18*'Detaljer Simpel'!H8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!I18*'Detaljer Simpel'!I8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!J18*'Detaljer Simpel'!J8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!K18*'Detaljer Simpel'!K8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!L18*'Detaljer Simpel'!L8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!M18*'Detaljer Simpel'!M8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!N18*'Detaljer Simpel'!N8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!O18*'Detaljer Simpel'!O8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!P18*'Detaljer Simpel'!P8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!Q18*'Detaljer Simpel'!Q8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!R18*'Detaljer Simpel'!R8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!S18*'Detaljer Simpel'!S8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!T18*'Detaljer Simpel'!T8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!U18*'Detaljer Simpel'!U8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!V18*'Detaljer Simpel'!V8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!W18*'Detaljer Simpel'!W8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!X18*'Detaljer Simpel'!X8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!Y18*'Detaljer Simpel'!Y8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!Z18*'Detaljer Simpel'!Z8,'Simpelt Input'!$C$14)","v":0},{"$f":"IF('Simpelt Input'!$C$15>0,'Detaljer Simpel'!AA18*'Detaljer Simpel'!AA8,'Simpelt Input'!$C$14)","v":0}]
[null,"I alt",{"$f":"SUM(C12:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Omkostning, hvis stop efter md.",0,{"$f":"C9+D9-D13","v":0},{"$f":"D15+E9-E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rene rekrutteringsomkostninger",0,{"$f":"$C$9","v":0},{"$f":"D16+E9-E8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Faktureringsgrad",0,{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0},{"$f":"'Simpelt Input'!$C$15","v":0}]
{"$rows_empty":10}
[null,"Rekrutteringsomkostninger",{"$f":"SUM(C5:C7)","v":0},{"$f":"C29+SUM(D5:D7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Totalomkostninger",{"$f":"C29+C8","v":0},{"$f":"C30+D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Indtægter",{"$f":"C13","v":0},{"$f":"C31+D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ROI (rekruttering)",{"$f":"(C31-C29)/C29","v":{"$error":"#DIV/0!"}},{"$f":"(D31-D29)/D29","v":{"$error":"#DIV/0!"}},{"$f":"(E31-E29)/E29","v":{"$error":"#DIV/0!"}},{"$f":"(F31-F29)/F29","v":{"$error":"#DIV/0!"}},{"$f":"(G31-G29)/G29","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ROI (total)",{"$f":"(C31-C30)/C30","v":{"$error":"#DIV/0!"}},{"$f":"(D31-D30)/D30","v":{"$error":"#DIV/0!"}},{"$f":"(E31-E30)/E30","v":{"$error":"#DIV/0!"}},{"$f":"(F31-F30)/F30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Hjælpemidler (Simpel)","index":2,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,4],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[34,1,34,4],[35,1,35,4]]}
[]
[]
[]
[]
[null,"Return on investment:"]
[null,null,"6 mdr","12 mdr","18 mdr","24 mdr"]
[null,"Værditilførelse (indtægter):",{"$f":"'Detaljer Simpel'!I31","v":0},{"$f":"'Detaljer Simpel'!O31","v":0},{"$f":"'Detaljer Simpel'!U31","v":0},{"$f":"'Detaljer Simpel'!AA31","v":0}]
[null,"Totalomkostninger:",{"$f":"'Detaljer Simpel'!I30","v":0},{"$f":"'Detaljer Simpel'!O30","v":0},{"$f":"'Detaljer Simpel'!U30","v":0},{"$f":"'Detaljer Simpel'!AA30","v":0}]
[null,"ROI (rekrutter-\ningsomkostninger):",{"$f":"'Detaljer Simpel'!I32","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!O32","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!U32","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!AA32","v":{"$error":"#DIV/0!"}}]
[null,"ROI (totale omkostninger):",{"$f":"'Detaljer Simpel'!I33","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!O33","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!U33","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer Simpel'!AA33","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Break-even:"]
{"$rows_empty":20}
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"'Simpelt Input'!B38","v":0},{"$f":"'Simpelt Input'!C38","v":0},{"$f":"'Simpelt Input'!D38","v":0},{"$f":"'Simpelt Input'!E38","v":0}]

{"sheet":"Udvidet input","index":3,"n_rows":95,"n_cols":15,"rows_kept":95,"cut":false,"hidden":false,"merged":[[16,7,16,8],[27,1,27,5]]}
[]
[]
[]
[null,"Prisen for en fejlrekruttering - en økonomisk beregner"]
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"-'Detaljer (Udvidet)'!I16","v":0},{"$f":"-'Detaljer (Udvidet)'!O16","v":0},{"$f":"-'Detaljer (Udvidet)'!U16","v":0},{"$f":"-'Detaljer (Udvidet)'!AA16","v":0}]
[]
[]
[null,"Deltagere i rekrutteringsprocessen","Årsløn","Udfyld de relevante deltagere og tryk på start"]
[null,"HR",{"$nulls":11},"Kategori","Anvendt timeløn"]
[null,"IT",{"$nulls":11},{"$f":"B12","v":"HR"},{"$f":"C12/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"Jurist",{"$nulls":11},"IT",{"$f":"C13/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"Kollega",{"$nulls":11},"Jurist",{"$f":"C14/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"Leder",{"$nulls":11},"Kollega",{"$f":"C15/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"VP",{"$nulls":11},"Leder",{"$f":"C16/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[{"$nulls":13},"VP",{"$f":"C17/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[{"$nulls":13},0,{"$f":"C18/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[{"$nulls":13},0,{"$f":"C19/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"Kandidat"]
[null,"Årsløn inkl. pension"]
[null,"Personalegoder",null,"F.eks. bil, telefon"]
[null,"Timeantal (pr. år)"]
[null,"Fuldt effektiv",6,"Tiden før kandidaten er fuldt effektiv for virksomheden"]
[null,"Performance ved fuld effektivitet",1.6,"Den værdi kandidaten tilfører virksomheden ved fuld effektivitet (procentdel af årsløn)."]
[]
[null,"Udfyld nedenstående skema med de involverede og konkrete omkostninger"]
[null,"Rekrutteringsomkostninger",{"$nulls":9}," "]
[null,"Medarbejdere, der deltager i aktiviteten med deres tidsforbrug samt de reelle omkostninger ved aktiviteten."]
[]
[null,"Aktivitet","Deltager A","Deltager B","Deltager C","Tidsforbrug -A (i min)","Tidsforbrug - B (i min)","Tidsforbrug - C (i min)","Omkostning","I alt"]
[null,"Opstartsmøde",{"$nulls":7},{"$f":"VLOOKUP(C33,$N$13:$O$20,2)*F33/60+VLOOKUP(D33,$N$13:$O$20,2)*G33/60+VLOOKUP(E33,$N$13:$O$20,2)*H33/60+I33","v":0},"Fastlæggelse af kriterier og krav til kandidaten"]
[null,"Udarbejdesle af stillingsopslag",{"$nulls":7},{"$f":"VLOOKUP(C34,$N$13:$O$20,2)*F34/60+VLOOKUP(D34,$N$13:$O$20,2)*G34/60+VLOOKUP(E34,$N$13:$O$20,2)*H34/60+I34","v":0}]
[null,"Annoncering",{"$nulls":7},{"$f":"VLOOKUP(C35,$N$13:$O$20,2)*F35/60+VLOOKUP(D35,$N$13:$O$20,2)*G35/60+VLOOKUP(E35,$N$13:$O$20,2)*H35/60+I35","v":0},"Annonceudgifter og styringen af annoncen"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C36,$N$13:$O$20,2)*F36/60+VLOOKUP(D36,$N$13:$O$20,2)*G36/60+VLOOKUP(E36,$N$13:$O$20,2)*H36/60+I36","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til annoncering",{"$nulls":7},{"$f":"SUM(J33:J36)","v":0}]
[]
[null,"Samlet fee til ekstern konsulent",{"$nulls":7},{"$f":"VLOOKUP(C39,$N$13:$O$20,2)*F39/60+VLOOKUP(D39,$N$13:$O$20,2)*G39/60+VLOOKUP(E39,$N$13:$O$20,2)*H39/60+I39","v":0},"Den samlede betaling til en headhunter"]
[null,"Internt arbejde med konsulent",{"$nulls":7},{"$f":"VLOOKUP(C40,$N$13:$O$20,2)*F40/60+VLOOKUP(D40,$N$13:$O$20,2)*G40/60+VLOOKUP(E40,$N$13:$O$20,2)*H40/60+I40","v":0},"Dialog med headhunter frem mod samtalerne"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C41,$N$13:$O$20,2)*F41/60+VLOOKUP(D41,$N$13:$O$20,2)*G41/60+VLOOKUP(E41,$N$13:$O$20,2)*H41/60+I41","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til ekstern konsulent",{"$nulls":7},{"$f":"SUM(J39:J41)","v":0}]
[]
[null,"Gennemgang af kandidater",{"$nulls":7},{"$f":"VLOOKUP(C44,$N$13:$O$20,2)*F44/60+VLOOKUP(D44,$N$13:$O$20,2)*G44/60+VLOOKUP(E44,$N$13:$O$20,2)*H44/60+I44","v":0},"Håndtering, gennemgang og udvælgelse af kandidater"]
[null,"Testtagning",{"$nulls":7},{"$f":"VLOOKUP(C45,$N$13:$O$20,2)*F45/60+VLOOKUP(D45,$N$13:$O$20,2)*G45/60+VLOOKUP(E45,$N$13:$O$20,2)*H45/60+I45","v":0},"Tid og omkostninger til testning af kandidater"]
[null,"Gennemgang af test",{"$nulls":7},{"$f":"VLOOKUP(C46,$N$13:$O$20,2)*F46/60+VLOOKUP(D46,$N$13:$O$20,2)*G46/60+VLOOKUP(E46,$N$13:$O$20,2)*H46/60+I46","v":0},"Gennemgang og vurdering af kandidater"]
[null,"Tilbagemelding",{"$nulls":7},{"$f":"VLOOKUP(C47,$N$13:$O$20,2)*F47/60+VLOOKUP(D47,$N$13:$O$20,2)*G47/60+VLOOKUP(E47,$N$13:$O$20,2)*H47/60+I47","v":0},"Tilbagemelding til fravalgte kandidater"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C48,$N$13:$O$20,2)*F48/60+VLOOKUP(D48,$N$13:$O$20,2)*G48/60+VLOOKUP(E48,$N$13:$O$20,2)*H48/60+I48","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til test",{"$nulls":7},{"$f":"SUM(J44:J48)","v":0}]
[]
[null,"1. samtale",{"$nulls":7},{"$f":"VLOOKUP(C51,$N$13:$O$20,2)*F51/60+VLOOKUP(D51,$N$13:$O$20,2)*G51/60+VLOOKUP(E51,$N$13:$O$20,2)*H51/60+I51","v":0},"Omkostninger ved samtaler i 1. runde"]
[null,"Evaluering  efter 1. samtale",{"$nulls":7},0,"Omkostninger ved evaluering af samtaler"]
[null,"2. samtale",{"$nulls":7},0,"Omkostninger ved samtaler i 2. runde"]
[null,"Evaluering  efter 2. samtale",{"$nulls":7},0,"Omkostninger ved evaluering af samtaler"]
[null,"3. samtale",{"$nulls":7},0,"Omkostninger ved samtaler i 3. runde"]
[null,"Evaluering  efter 2. samtale",{"$nulls":7},0,"Omkostninger ved evaluering af samtaler"]
[null,"Øvrige ",{"$nulls":7},0,"Både intern tid og reelle udgifter"]
[null,"I alt til samtaler",{"$nulls":7},{"$f":"SUM(J51:J56)","v":0}]
[]
[null,"Afslag",{"$nulls":7},{"$f":"VLOOKUP(C60,$N$13:$O$20,2)*F60/60+VLOOKUP(D60,$N$13:$O$20,2)*G60/60+VLOOKUP(E60,$N$13:$O$20,2)*H60/60+I60","v":0},"Omkostning ved udarbejdelse og evt. dialog med kandidater"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C61,$N$13:$O$20,2)*F61/60+VLOOKUP(D61,$N$13:$O$20,2)*G61/60+VLOOKUP(E61,$N$13:$O$20,2)*H61/60+I61","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til håndtering af afslag",{"$nulls":7},{"$f":"SUM(J60:J61)","v":0}]
[]
[null,"Referencetagning på kandidaten",{"$nulls":7},{"$f":"VLOOKUP(C64,$N$13:$O$20,2)*F64/60+VLOOKUP(D64,$N$13:$O$20,2)*G64/60+VLOOKUP(E64,$N$13:$O$20,2)*H64/60+I64","v":0}]
[null,"Lønforhandling",{"$nulls":7},0]
[null,"Kontraktudarbejdelse",{"$nulls":7},0]
[null,"1. Kontraktgennemgang",{"$nulls":7},0]
[null,"Kontraktjustering",{"$nulls":7},0]
[null,"2. Kontraktgennemgang",{"$nulls":7},0]
[null,"Øvrige ",{"$nulls":7},0,"Både intern tid og reelle udgifter"]
[null,"I alt til løn- og kontraktforhold",{"$nulls":7},{"$f":"SUM(J64:J70)","v":0}]
[]
[null,"Onboardingomkostninger"]
[null,"Omkostninger efter kandidaten er ansat som led i oplæring mv."]
[]
[null,"Aktiviteter","Medarbejder A","Medarbejder B","Medarbejder C","Tidsforbrug -A (i min)","Tidsforbrug - B (i min)","Tidsforbrug - C (i min)","Omkostning","I alt"]
[null,"Preboarding",{"$nulls":7},{"$f":"VLOOKUP(C77,$N$13:$O$20,2)*F77/60+VLOOKUP(D77,$N$13:$O$20,2)*G77/60+VLOOKUP(E77,$N$13:$O$20,2)*H77/60+I77","v":0},"Omkostninger afholdt inden kandidatens start"]
[null,"Pensionsmøde",{"$nulls":7},0,"Tid med pensionsleverandøren"]
[null,"Lønregistrering",{"$nulls":7},0]
[null,"Kurser",{"$nulls":7},0]
[null,"Kendskab til kollegaer",{"$nulls":7},0]
[null,"Administrativ onboarding",{"$nulls":7},0]
[null,"Teknisk support",{"$nulls":7},0]
[null,"Mentorordning",{"$nulls":7},0]
[null,"Indkøb af udstyr",{"$nulls":7},0,"Køb af skrivebord, stol, PC, visitkort"]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"I alt til onboarding",{"$nulls":7},{"$f":"SUM(J78:J88)","v":0}]
[]
[]
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"B8","v":0},{"$f":"C8","v":0},{"$f":"D8","v":0},{"$f":"E8","v":0}]

{"sheet":"Hjælpemidler (Udvidet)","index":4,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,4],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[34,1,34,4],[35,1,35,4]]}
[]
[]
[]
[]
[null,"Return on investment:"]
[]
[null,null,"6 mdr","12 mdr","18 mdr","24 mdr"]
[null,"Værditilførelse (indtægter):",{"$f":"'Detaljer (Udvidet)'!I38","v":0},{"$f":"'Detaljer (Udvidet)'!O38","v":0},{"$f":"'Detaljer (Udvidet)'!U38","v":0},{"$f":"'Detaljer (Udvidet)'!AA38","v":0}]
[null,"Totalomkostninger:",{"$f":"'Detaljer (Udvidet)'!I37","v":0},{"$f":"'Detaljer (Udvidet)'!O37","v":0},{"$f":"'Detaljer (Udvidet)'!U37","v":0},{"$f":"'Detaljer (Udvidet)'!AA37","v":0}]
[null,"ROI (rekrutter-\ningsomkostninger):",{"$f":"'Detaljer (Udvidet)'!I39","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!O39","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!U39","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!AA39","v":{"$error":"#DIV/0!"}}]
[null,"ROI (totale omkostninger):",{"$f":"'Detaljer (Udvidet)'!I40","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!O40","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!U40","v":{"$error":"#DIV/0!"}},{"$f":"'Detaljer (Udvidet)'!AA40","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Break-even:"]
{"$rows_empty":20}
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"'Udvidet input'!B95","v":0},{"$f":"'Udvidet input'!C95","v":0},{"$f":"'Udvidet input'!D95","v":0},{"$f":"'Udvidet input'!E95","v":0}]

{"sheet":"Eksempel (Udvidet)","index":5,"n_rows":95,"n_cols":15,"rows_kept":95,"cut":false,"hidden":false,"merged":[[16,7,16,8],[27,1,27,5]]}
[]
[]
[]
[null,"Prisen for en fejlrekruttering - en økonomisk beregner"]
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"-'Detaljer (eksempel)'!I16","v":-466645.58090277785},{"$f":"-'Detaljer (eksempel)'!O16","v":-196645.58090277785},{"$f":"-'Detaljer (eksempel)'!U16","v":73354.419097222155},{"$f":"-'Detaljer (eksempel)'!AA16","v":343354.41909722215}]
[]
[]
[null,"Deltagere i rekrutteringsprocessen","Årsløn","Udfyld de relevante deltagere og tryk på start"]
[null,"HR",400000,{"$nulls":10},"Kategori","Anvendt timeløn"]
[null,"IT",400000,{"$nulls":10},{"$f":"B12","v":"HR"},{"$f":"C12/'Stamoplysninger (eksempel)'!$D$4","v":277.77777777777777}]
[null,"Jurist",666666,{"$nulls":10},"IT",{"$f":"C13/'Stamoplysninger (eksempel)'!$D$4","v":277.77777777777777}]
[null,"Kollega",800000,{"$nulls":10},"Jurist",{"$f":"C14/'Stamoplysninger (eksempel)'!$D$4","v":462.96249999999998}]
[null,"Leder",700000,{"$nulls":10},"Kollega",{"$f":"C15/'Stamoplysninger (eksempel)'!$D$4","v":555.55555555555554}]
[null,"VP",1200000,{"$nulls":10},"Leder",{"$f":"C16/'Stamoplysninger (eksempel)'!$D$4","v":486.11111111111109}]
[{"$nulls":13},"VP",{"$f":"C17/'Stamoplysninger (eksempel)'!$D$4","v":833.33333333333337}]
[{"$nulls":13},0,{"$f":"C18/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[{"$nulls":13},0,{"$f":"C19/'Stamoplysninger (eksempel)'!$D$4","v":0}]
[null,"Kandidat"]
[null,"Årsløn inkl. pension",900000]
[null,"Personalegoder",200000,"F.eks. bil, telefon"]
[null,"Timeantal (pr. år)",1440]
[null,"Fuldt effektiv",6,"Tiden før kandidaten er fuldt effektiv for virksomheden"]
[null,"Performance ved fuld effektivitet",1.6]
[]
[null,"Udfyld nedenstående skema med de involverede og konkrete omkostninger"]
[null,"Rekrutteringsomkostninger",{"$nulls":9}," "]
[null,"Medarbejdere, der deltager i aktiviteten med deres tidsforbrug samt de reelle omkostninger ved aktiviteten."]
[]
[null,"Aktivitet","Deltager A","Deltager B","Deltager C","Tidsforbrug -A (i min)","Tidsforbrug - B (i min)","Tidsforbrug - C (i min)","Omkostning","I alt"]
[null,"Opstartsmøde","Leder","HR",null,60,60,null,null,{"$f":"VLOOKUP(C33,$N$13:$O$20,2)*F33/60+VLOOKUP(D33,$N$13:$O$20,2)*G33/60+VLOOKUP(E33,$N$13:$O$20,2)*H33/60+I33","v":763.88888888888891},"Fastlæggelse af kriterier og krav til kandidaten"]
[null,"Udarbejdesle af stillingsopslag","Leder","HR","HR",60,60,60,null,{"$f":"VLOOKUP(C34,$N$13:$O$20,2)*F34/60+VLOOKUP(D34,$N$13:$O$20,2)*G34/60+VLOOKUP(E34,$N$13:$O$20,2)*H34/60+I34","v":1041.6666666666667}]
[null,"Annoncering","HR",null,null,60,60,60,5000,{"$f":"VLOOKUP(C35,$N$13:$O$20,2)*F35/60+VLOOKUP(D35,$N$13:$O$20,2)*G35/60+VLOOKUP(E35,$N$13:$O$20,2)*H35/60+I35","v":5277.7777777777774},"Annonceudgifter og styringen af annoncen"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C36,$N$13:$O$20,2)*F36/60+VLOOKUP(D36,$N$13:$O$20,2)*G36/60+VLOOKUP(E36,$N$13:$O$20,2)*H36/60+I36","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til annoncering",{"$nulls":7},{"$f":"SUM(J33:J36)","v":7083.333333333333}]
[]
[null,"Samlet fee til ekstern konsulent",{"$nulls":6},200000,{"$f":"VLOOKUP(C39,$N$13:$O$20,2)*F39/60+VLOOKUP(D39,$N$13:$O$20,2)*G39/60+VLOOKUP(E39,$N$13:$O$20,2)*H39/60+I39","v":200000},"Den samlede betaling til en headhunter"]
[null,"Internt arbejde med konsulent","HR","VP","Jurist",120,120,120,10000,{"$f":"VLOOKUP(C40,$N$13:$O$20,2)*F40/60+VLOOKUP(D40,$N$13:$O$20,2)*G40/60+VLOOKUP(E40,$N$13:$O$20,2)*H40/60+I40","v":13148.147222222222},"Dialog med headhunter frem mod samtalerne"]
[null,"Øvrige ","HR",null,null,60,60,60,null,{"$f":"VLOOKUP(C41,$N$13:$O$20,2)*F41/60+VLOOKUP(D41,$N$13:$O$20,2)*G41/60+VLOOKUP(E41,$N$13:$O$20,2)*H41/60+I41","v":277.77777777777777},"Både intern tid og reelle udgifter"]
[null,"I alt til ekstern konsulent",{"$nulls":7},{"$f":"SUM(J39:J41)","v":213425.92500000002}]
[]
[null,"Gennemgang af kandidater","HR",null,null,180,180,180,null,{"$f":"VLOOKUP(C44,$N$13:$O$20,2)*F44/60+VLOOKUP(D44,$N$13:$O$20,2)*G44/60+VLOOKUP(E44,$N$13:$O$20,2)*H44/60+I44","v":833.33333333333337},"Håndtering, gennemgang og udvælgelse af kandidater"]
[null,"Testtagning","HR",null,null,60,60,60,1200,{"$f":"VLOOKUP(C45,$N$13:$O$20,2)*F45/60+VLOOKUP(D45,$N$13:$O$20,2)*G45/60+VLOOKUP(E45,$N$13:$O$20,2)*H45/60+I45","v":1477.7777777777778},"Tid og omkostninger til testning af kandidater"]
[null,"Gennemgang af test","Leder","HR","HR",180,180,180,null,{"$f":"VLOOKUP(C46,$N$13:$O$20,2)*F46/60+VLOOKUP(D46,$N$13:$O$20,2)*G46/60+VLOOKUP(E46,$N$13:$O$20,2)*H46/60+I46","v":3125},"Gennemgang og vurdering af kandidater"]
[null,"Tilbagemelding","HR",null,null,120,null,null,null,{"$f":"VLOOKUP(C47,$N$13:$O$20,2)*F47/60+VLOOKUP(D47,$N$13:$O$20,2)*G47/60+VLOOKUP(E47,$N$13:$O$20,2)*H47/60+I47","v":555.55555555555554},"Tilbagemelding til fravalgte kandidater"]
[null,"Øvrige ",{"$nulls":7},{"$f":"VLOOKUP(C48,$N$13:$O$20,2)*F48/60+VLOOKUP(D48,$N$13:$O$20,2)*G48/60+VLOOKUP(E48,$N$13:$O$20,2)*H48/60+I48","v":0},"Både intern tid og reelle udgifter"]
[null,"I alt til test",{"$nulls":7},{"$f":"SUM(J44:J48)","v":5991.666666666667}]
[]
[null,"1. samtale","Leder","HR","HR",360,360,360,null,{"$f":"VLOOKUP(C51,$N$13:$O$20,2)*F51/60+VLOOKUP(D51,$N$13:$O$20,2)*G51/60+VLOOKUP(E51,$N$13:$O$20,2)*H51/60+I51","v":6250},"Omkostninger ved samtaler i 1. runde"]
[null,"Evaluering  efter 1. samtale","Leder","HR","HR",60,60,60,null,1041.6666666666667,"Omkostninger ved evaluering af samtaler"]
[null,"2. samtale","Leder","HR","HR",180,180,180,null,3125,"Omkostninger ved samtaler i 2. runde"]
[null,"Evaluering  efter 2. samtale","Leder","HR","HR",30,30,30,null,520.83333333333337,"Omkostninger ved evaluering af samtaler"]
[null,"3. samtale","Leder","HR","HR",120,120,120,null,2083.3333333333335,"Omkostninger ved samtaler i 3. runde"]
[null,"Evaluering  efter 2. samtale","Leder","HR","HR",30,30,30,null,520.83333333333337,"Omkostninger ved evaluering af samtaler"]
[null,"Øvrige ",{"$nulls":6},2000,2000,"Både intern tid og reelle udgifter"]
[null,"I alt til samtaler",{"$nulls":7},{"$f":"SUM(J51:J56)","v":13541.66666666667}]
[]
[null,"Afslag","HR",null,null,300,300,300,null,{"$f":"VLOOKUP(C60,$N$13:$O$20,2)*F60/60+VLOOKUP(D60,$N$13:$O$20,2)*G60/60+VLOOKUP(E60,$N$13:$O$20,2)*H60/60+I60","v":1388.8888888888889},"Omkostning ved udarbejdelse og evt. dialog med kandidater"]
[null,"Øvrige ","HR",null,null,30,30,30,null,{"$f":"VLOOKUP(C61,$N$13:$O$20,2)*F61/60+VLOOKUP(D61,$N$13:$O$20,2)*G61/60+VLOOKUP(E61,$N$13:$O$20,2)*H61/60+I61","v":138.88888888888889},"Både intern tid og reelle udgifter"]
[null,"I alt til håndtering af afslag",{"$nulls":7},{"$f":"SUM(J60:J61)","v":1527.7777777777778}]
[]
[null,"Referencetagning på kandidaten","Leder",null,null,90,90,90,null,{"$f":"VLOOKUP(C64,$N$13:$O$20,2)*F64/60+VLOOKUP(D64,$N$13:$O$20,2)*G64/60+VLOOKUP(E64,$N$13:$O$20,2)*H64/60+I64","v":729.16666666666663}]
[null,"Lønforhandling","Leder","VP","VP",90,90,90,null,3229.1666666666665]
[null,"Kontraktudarbejdelse","Leder","Jurist","Jurist",120,120,120,null,2824.0722222222221]
[null,"1. Kontraktgennemgang","Leder",null,null,60,60,60,null,486.11111111111109]
[null,"Kontraktjustering","Leder","Jurist","Jurist",45,45,45,null,1059.0270833333334]
[null,"2. Kontraktgennemgang","Leder",null,null,30,30,30,null,243.05555555555554]
[null,"Øvrige ",{"$nulls":7},0,"Både intern tid og reelle udgifter"]
[null,"I alt til løn- og kontraktforhold",{"$nulls":7},{"$f":"SUM(J64:J70)","v":8570.5993055555555}]
[]
[null,"Onboardingomkostninger"]
[null,"Omkostninger efter kandidaten er ansat som led i oplæring mv."]
[]
[null,"Aktiviteter","Medarbejder A","Medarbejder B","Medarbejder C","Tidsforbrug -A (i min)","Tidsforbrug - B (i min)","Tidsforbrug - C (i min)","Omkostning","I alt"]
[null,"Preboarding","Leder",null,null,90,null,null,null,{"$f":"VLOOKUP(C77,$N$13:$O$20,2)*F77/60+VLOOKUP(D77,$N$13:$O$20,2)*G77/60+VLOOKUP(E77,$N$13:$O$20,2)*H77/60+I77","v":729.16666666666663},"Omkostninger afholdt inden kandidatens start"]
[null,"Pensionsmøde","Kandidat",null,null,90,90,90,null,694.44375000000002,"Tid med pensionsleverandøren"]
[null,"Lønregistrering","Kandidat","HR","HR",45,45,45,null,763.8885416666667]
[null,"Kurser","Kandidat","Leder","Leder",600,600,600,null,14351.847222222219]
[null,"Kendskab til kollegaer","Kandidat","Kollega","Kollega",120,120,120,null,3148.1472222222219]
[null,"Administrativ onboarding","Kandidat","IT","IT",90,90,90,null,1527.7770833333334]
[null,"Teknisk support","Kandidat","IT","IT",120,120,120,null,2037.036111111111]
[null,"Mentorordning","Kandidat","Kollega","Kollega",1200,1200,1200,null,31481.472222222219]
[null,"Indkøb af udstyr",{"$nulls":6},20000,20000,"Køb af skrivebord, stol, PC, visitkort"]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"I alt til onboarding",{"$nulls":7},{"$f":"SUM(J78:J88)","v":74004.612152777772}]
[]
[]
[null,"Kandidatværdi efter:"]
[null,"Prisen for kandidaten ved stop efter x antal måneder"]
[null,"6 mdr.","12 mdr.","18 mdr.","24 mdr."]
[null,{"$f":"B8","v":-466645.58090277785},{"$f":"C8","v":-196645.58090277785},{"$f":"D8","v":73354.419097222155},{"$f":"E8","v":343354.41909722215}]

{"sheet":"Ark1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Stamoplysninger (eksempel)","index":7,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Stamoplysning til beregninger"]
[]
[null,null,"Årsværk",1440]
[null,null,"Effektivitet",{"$f":"'Eksempel (Udvidet)'!C26","v":1.6}]

{"sheet":"Detaljer (eksempel)","index":8,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Cashflow, udgifter"]
[null,"Måned",-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"Headhunter",{"$f":"'Eksempel (Udvidet)'!J42","v":213425.92500000002},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rekrutteringsomkostninger",{"$f":"'Eksempel (Udvidet)'!J37+'Eksempel (Udvidet)'!J49+'Eksempel (Udvidet)'!J58+'Eksempel (Udvidet)'!J62+'Eksempel (Udvidet)'!J71","v":36715.043750000004},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onboarding",0,{"$f":"'Eksempel (Udvidet)'!J89","v":74004.612152777772},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Løn til kandidat",0,{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000},{"$f":"'Eksempel (Udvidet)'!$C$22/12","v":75000}]
[null,"I alt",{"$f":"SUM(C5:C8)","v":250140.96875000003},{"$f":"SUM(D5:D8)","v":149004.61215277779},75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000]
[]
[null,"Cashflow, indtægter"]
[null,"Værdi for virksomhed",0,{"$f":"D8*D19*D20","v":12500},{"$f":"E8*E19*E20","v":25000},{"$f":"F8*F19*F20","v":37500},50000,62500,{"$f":"I8*I19*I20","v":120000},{"$f":"J8*J19*J20","v":120000},120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000]
[null,"Ekstra",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I alt",{"$f":"SUM(C12:C13)","v":0},{"$f":"SUM(D12:D13)","v":12500},25000,37500,50000,62500,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000]
[]
[null,"Omkostning, hvis stop efter md.",0,{"$f":"C9+D9-D14","v":386645.58090277785},{"$f":"D16+E9-E14","v":436645.58090277785},{"$f":"E16+F9-F14","v":474145.58090277785},{"$f":"F16+G9-G14","v":499145.58090277785},511645.58090277785,466645.58090277785,421645.58090277785,376645.58090277785,331645.58090277785,286645.58090277785,241645.58090277785,196645.58090277785,151645.58090277785,106645.58090277785,61645.580902777845,16645.580902777845,{"$f":"S16+T9-T14","v":-28354.419097222155},-73354.419097222155,-118354.41909722215,-163354.41909722215,-208354.41909722215,-253354.41909722215,-298354.41909722215,-343354.41909722215]
[null,"Rene rekrutteringsomkostninger",0,{"$f":"C9+D9-D8","v":324145.58090277785},{"$f":"D17+E9-E8","v":324145.58090277785},324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785,324145.58090277785]
[]
[null,"Effektivitet",0,{"$f":"D25","v":0.16666666666666666},{"$f":"E25","v":0.33333333333333331},0.5,0.66666666666666663,0.83333333333333337,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Faktureringsgrad",0,{"$f":"IF(D19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1},{"$f":"IF(E19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1},{"$f":"IF(F19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1},{"$f":"IF(G19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1},{"$f":"IF(H19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1},{"$f":"IF(I19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(J19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(K19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(L19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(M19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(N19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(O19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(P19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(Q19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(R19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(S19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(T19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(U19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(V19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(W19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(X19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(Y19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(Z19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6},{"$f":"IF(AA19<1,1,'Stamoplysninger (eksempel)'!$D$5)","v":1.6}]
[]
[]
[null,"Effektivitet"]
[null,"Måned",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"Lineær",null,{"$f":"MIN(D24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":0.16666666666666666},{"$f":"MIN(E24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":0.33333333333333331},{"$f":"MIN(F24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":0.5},{"$f":"MIN(G24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":0.66666666666666663},{"$f":"MIN(H24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":0.83333333333333337},{"$f":"MIN(I24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(J24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(K24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(L24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(M24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(N24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(O24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(P24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(Q24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(R24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(S24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(T24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(U24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(V24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(W24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(X24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(Y24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(Z24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1},{"$f":"MIN(AA24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25","v":1}]
[null,"Power",null,{"$f":"$D$27^(1-(MIN(D24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":3.8387662073329686E-2},{"$f":"$D$27^(1-(MIN(E24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":7.3680629972807707E-2},{"$f":"$D$27^(1-(MIN(F24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":0.1414213562373095},{"$f":"$D$27^(1-(MIN(G24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":0.27144176165949063},{"$f":"$D$27^(1-(MIN(H24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":0.52100073095869137},{"$f":"$D$27^(1-(MIN(I24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(J24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(K24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(L24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(M24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(N24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(O24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(P24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Q24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(R24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(S24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(T24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(U24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(V24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(W24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(X24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Y24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Z24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(AA24,'Eksempel (Udvidet)'!$C$25)/'Eksempel (Udvidet)'!$C$25))","v":1}]
[null,"Læringskurve",null,0.02]

{"sheet":"Detaljer (Udvidet)","index":9,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Cashflow, udgifter"]
[null,"Måned",-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"Headhunter",{"$f":"'Udvidet input'!J42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rekrutteringsomkostninger",{"$f":"'Udvidet input'!J37+'Udvidet input'!J49+'Udvidet input'!J58+'Udvidet input'!J62+'Udvidet input'!J71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onboarding",0,{"$f":"'Udvidet input'!J89","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Løn til kandidat",0,{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0},{"$f":"'Udvidet input'!$C$22/12","v":0}]
[null,"I alt",{"$f":"SUM(C5:C8)","v":0},{"$f":"SUM(D5:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cashflow, indtægter"]
[null,"Værdi for virksomhed",0,{"$f":"D8*D19*D20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ekstra",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I alt",{"$f":"SUM(C12:C13)","v":0},{"$f":"SUM(D12:D13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Omkostning, hvis stop efter md.",0,{"$f":"C9+D9-D14","v":0},{"$f":"D16+E9-E14","v":0},{"$f":"E16+F9-F14","v":0},{"$f":"F16+G9-G14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rene rekrutteringsomkostninger",0,{"$f":"C9+D9-D8","v":0},{"$f":"D17+E9-E8","v":0},0,{"$f":"F17+G9-G8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Effektivitet",0,{"$f":"D25","v":0.16666666666666666},{"$f":"E25","v":0.33333333333333331},{"$f":"F25","v":0.5},0.66666666666666663,0.83333333333333337,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Faktureringsgrad",0,{"$f":"IF(D19<1,1,Stamoplysninger!$D$5)","v":1},{"$f":"IF(E19<1,1,Stamoplysninger!$D$5)","v":1},{"$f":"IF(F19<1,1,Stamoplysninger!$D$5)","v":1},{"$f":"IF(G19<1,1,Stamoplysninger!$D$5)","v":1},{"$f":"IF(H19<1,1,Stamoplysninger!$D$5)","v":1},{"$f":"IF(I19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(J19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(K19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(L19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(M19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(N19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(O19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(P19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(Q19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(R19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(S19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(T19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(U19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(V19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(W19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(X19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(Y19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(Z19<1,1,Stamoplysninger!$D$5)","v":1.6},{"$f":"IF(AA19<1,1,Stamoplysninger!$D$5)","v":1.6}]
[]
[]
[null,"Effektivitet"]
[null,"Måned",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"Lineær",null,{"$f":"MIN(D24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":0.16666666666666666},{"$f":"MIN(E24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":0.33333333333333331},{"$f":"MIN(F24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":0.5},{"$f":"MIN(G24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":0.66666666666666663},{"$f":"MIN(H24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":0.83333333333333337},{"$f":"MIN(I24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(J24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(K24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(L24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(M24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(N24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(O24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(P24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(Q24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(R24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(S24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(T24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(U24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(V24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(W24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(X24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(Y24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(Z24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1},{"$f":"MIN(AA24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25","v":1}]
[null,"Power",null,{"$f":"$D$27^(1-(MIN(D24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":3.8387662073329686E-2},{"$f":"$D$27^(1-(MIN(E24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":7.3680629972807707E-2},{"$f":"$D$27^(1-(MIN(F24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":0.1414213562373095},{"$f":"$D$27^(1-(MIN(G24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":0.27144176165949063},{"$f":"$D$27^(1-(MIN(H24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":0.52100073095869137},{"$f":"$D$27^(1-(MIN(I24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(J24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(K24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(L24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(M24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(N24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(O24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(P24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Q24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(R24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(S24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(T24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(U24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(V24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(W24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(X24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Y24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(Z24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1},{"$f":"$D$27^(1-(MIN(AA24,'Udvidet input'!$C$25)/'Udvidet input'!$C$25))","v":1}]
[null,"Læringskurve",null,0.02]
{"$rows_empty":8}
[null,"Rekrutteringsomkostninger",{"$f":"SUM(C5:C7)","v":0},{"$f":"C36+SUM(D5:D7)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"N36+SUM(O5:O7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Totalomkostninger",{"$f":"C36+C8","v":0},{"$f":"C37+D9","v":0},{"$f":"D37+E9","v":0},{"$f":"E37+F9","v":0},{"$f":"F37+G9","v":0},{"$f":"G37+H9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Indtægter",{"$f":"C14","v":0},{"$f":"C38+D14","v":0},{"$f":"D38+E14","v":0},{"$f":"E38+F14","v":0},{"$f":"F38+G14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ROI (rekruttering)",{"$f":"(C38-C36)/C36","v":{"$error":"#DIV/0!"}},{"$f":"(D38-D36)/D36","v":{"$error":"#DIV/0!"}},{"$f":"(E38-E36)/E36","v":{"$error":"#DIV/0!"}},{"$f":"(F38-F36)/F36","v":{"$error":"#DIV/0!"}},{"$f":"(G38-G36)/G36","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ROI (total)",{"$f":"(C38-C37)/C37","v":{"$error":"#DIV/0!"}},{"$f":"(D38-D37)/D37","v":{"$error":"#DIV/0!"}},{"$f":"(E38-E37)/E37","v":{"$error":"#DIV/0!"}},{"$f":"(F38-F37)/F37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Stamoplysninger","index":10,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Stamoplysning til beregninger"]
[]
[null,null,"Årsværk",{"$f":"'Udvidet input'!C24","v":0}]
[null,null,"Effektivitet",{"$f":"'Udvidet input'!C26","v":1.6}]