{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Forside","Dashboard","Resultater","Inputark","Hjælpeark","SIB projektet","Standarder","Lister"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":1,"defined_names":98,"comments":2,"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":"Forside","index":0,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[[56,13,57,18],[9,13,10,18],[12,13,13,18],[17,13,18,18],[40,13,41,18],[43,13,44,18],[53,13,54,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" Dette Excel-værktøj er et hjælperedskab til designs af fremtidige resultatbaserede betalingsmodeller for"]
[" sociale indsatser, hvor indsatsen varetages af en ekstern leverandør og finansieres af en investor.  "]
[" Værktøjet gør det muligt at beregne betalingen pr. borger, der kommer i beskæftigelse, givet en række "]
[" centrale antagelser vedrørende bl.a. den forventede mereffekt og omkostningerne til indsatsen."]
[]
[" Modellen er udviklet med inspiration i erfaringerne fra SIB-projektet (Social Inklusion og Beskæftigelse),"]
[" som blev gennemført i perioden 2020-2023 i et samarbejde mellem DRC Dansk Flygtningehjælp, "]
[" Herning Kommune, Viborg Kommune og Poul Due Jensens Fond. Se fanen vedrørende dette projekt. "]
[]
[]
[]
[]
[]
[]
["Project number:",null,"A127669"]
["Date:",null,"2023-05-28"]
["Created by:",null,"PGM/APHE"]
["Checked by:",null,"JEE"]
["Approved by:",null,"HLE"]
["Version:",null,2]

{"sheet":"Dashboard","index":1,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"Dashboard"]
[]
[]
[null,"Før indsats (baseline)"]
[]
[null,"Centrale forudsætninger for målgruppen"]
[]
[null,"Gns. arbejdstid pr. person i målgruppen ","timer/år",1000]
[null,"Gns. løn pr. person i målgruppen","kr./time",150]
[null,"Nuværende gns. beskæftigelse","timer/uge",12]
[null,"Nuværende gns. overførselsindkomst","kr./år",100000]
[null,"Nuværende gns. omkostning ved beskæftigelsesindsats","kr./år",25000]
[null,"Andel af målgruppe, der forventes at komme i   beskæftigelse uden en indsats","%",0.2]
[]
[]
[null,"Indsats"]
[]
[null,"Centrale forudsætninger for indsatsen"]
[]
[null,"Indsatsens første år","år",2022]
[null,"Indsatsens sidste år","år",2022]
[]
[null,"Indsatsperiode","år",{"$f":"D21-D20+1","v":1}]
[]
[null,{"$f":"\"Beskæftigelseseffekt ved indsatsen \"&slutår+1","v":"Beskæftigelseseffekt ved indsatsen 2023"},"%-point",0.2]
[null,{"$f":"\"Antal år efter \"&slutår+1&\" hvor beskæftigelseseffekten falder\"","v":"Antal år efter 2023 hvor beskæftigelseseffekten falder"},"år",2]
[null,{"$f":"\"Forventet årlige fald i beskæftigelseseffekt efter \"&slutår+1+D26","v":"Forventet årlige fald i beskæftigelseseffekt efter 2025"},"%",0.15]
[null,"Besparelse på almindelig indsats (i indsatsperioden)","%",0]
[]
[null,"Deltagere"]
[null,"Afvigelse fra bruttobeskæftigelse, høj",null,0.1]
[null,"Afvigelse fra bruttobeskæftigelse, lav",null,-0.1]
[]
[]
[null,"Investeringer og afkast"]
[]
[null,"Investeringssum, leverandør","kr. ",100000]
[null,"Investeringssum, myndighed","kr. ",10000]
[]
[null,"Samlet investering","kr.",{"$f":"D37+D38","v":110000}]
[]
[null,"År for tilbagebetaling til investor","År",2023]
[null,"Forventet andel af overskud, der skal gå til investor",null,0.25]
[null,"Forventet andel af overskud, der skal gå til myndighed",null,{"$f":"1-D43","v":0.75}]
[]
[]
[]
[null,"Skatter og overførselsindkomster"]
[]
[null,"Kommunal skattesats","%",0.2]
[null,"Statsskattesats","%",0.1]
[]
[null,"Statsrefusion på kommunale udgifter til overførselsindkomst","%",0.2]

{"sheet":"Resultater","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Resultater"}]
[]
[]
[]
[]
[null,"Resultater"]
[null,"Budgetøkonomisk overskud",{"$f":"Hjælpeark!C46-Hjælpeark!C50-Hjælpeark!C51","v":21692.856402992184}]
[null,"Investors andel af budgetøkonomisk overskud",{"$f":"C7*Dashboard!D43","v":5423.2141007480459}]
[null,"Myndighed forventer at betale investor i gennemsnit pr. deltager",{"$f":"C8+Hjælpeark!C50","v":105423.21410074804}]
[]
[null,"Myndighed betaler investor, kr. pr. person, der kommer i beskæftigelse",{"$f":"C9/(Dashboard!D25+Dashboard!D13)","v":263558.03525187005}]
[]
[null,"Betaling differentieret på deltager"]
[null,"Deltager med gode forudsætninger",{"$f":"Hjælpeark!C12*C11/Hjælpeark!C14","v":197668.52643890254}]
[null,"Deltager med mindre gode forudsætninger",{"$f":"Hjælpeark!C13*C11/Hjælpeark!C14","v":329447.54406483751}]
[null,"Gennemsnit",{"$f":"AVERAGE(C14:C15)","v":263558.03525187005}]

{"sheet":"Inputark","index":3,"n_rows":17,"n_cols":41,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Inputs"]
[]
[null,"Centrale parametre"]
[]
[null,"Kalkulationsrente",3.5000000000000003E-2,"år 0 til 35"]
[null,"Kilder:"]
[null,"Finansministeriet: Vejledning om samfundsøkonomiske konsekvensvuirderinger",null,"https://fm.dk/arbejdsomraader/regnemetoder-og-regnemodeller/regnemetoder-og-regnemodeller/vejledning-om-samfundsoekonomiske-konsekvensvurderinger/"]
[]
[null,"Netto-nutidsværdi-år",2022]
[]
[]
[null,"Hjælpetabel for diskontering"]
[null,"år",null,null,2022,{"$f":"E13+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058]
[null,"Antal år før/efter år for beregning af nutidsværdi",null,null,{"$f":"E13-C9","v":0},{"$f":"E14+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[null,"Rentesats",null,null,{"$f":"C5","v":3.5000000000000003E-2},{"$f":"E15","v":3.5000000000000003E-2},3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2]
[null,"Diskonteringsfaktor",null,null,{"$f":"1/(1+E15)^E14","v":1},0.96618357487922713,0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911,0.50256588443167061,0.48557090283253213,0.46915063075606966,0.45328563358074364,0.43795713389443841,0.42314698926998884,0.40883767079225974,0.39501224231136206,0.38165434039745127,0.36874815497338298,0.35627841060230236,0.34423034840802164,0.33258970860678427,0.32134271362974326,0.3104760518161771,0.29997686165814214,0.28983271657791515]
[null,"Diskonteringsfaktor, midtperiode",null,null,{"$f":"1/(1+E15)^(0.5+E14)","v":0.98294637436598087},0.94970664189949849,0.91759095835700355,0.88656131242222569,0.85658097818572543,0.8276144716770294,0.7996275088666952,0.77258696508859437,0.74646083583439082,0.72121819887380756,0.69682917765585284,0.67326490594768384,0.65049749366925991,0.62849999388334288,0.60724637090178069,0.58671146947031949,0.56687098499547783,0.54770143477823952,0.52918013022052124,0.51128514997151819,0.49399531398214319,0.47729015843685341,0.46114991153319174,0.44555547008037849,0.43048837688925462,0.41593079892681606,0.40186550620948419,0.38827585141012966,0.37514575015471469,0.36245966198523161,0.35020257196640742,0.33835997291440334,0.32691784822647663,0.31586265529128182,0.30518130946017569,0.29486116856055622,0.28489001793290458]

{"sheet":"Hjælpeark","index":4,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[null,"Hjælpeark"]
[]
[null,"Dette er et hjælpeark til beregning af det forventede budgetøkonomiske regnskab, pba. af de brugerspecificerede værdier"]
[]
[null,"Budgetøkonomiske konsekvenser, kr. pr. gennemsnitlig deltager i en indsats"]
[]
[]
[]
[]
[null,"Hjælpeberegning til deltager med forskellig karakteristika"]
[]
[null,"Stærk ",{"$f":"Resultater!C9/(Dashboard!D13+Dashboard!D25+Dashboard!D31)","v":210846.42820149608}]
[null,"Svag",{"$f":"Resultater!C9/(Dashboard!D13+Dashboard!D25+Dashboard!D32)","v":351410.71366916009}]
[null,"Gennemsnit",{"$f":"(C12+C13)/2","v":281128.57093532808}]
[]
[]
[]
[]
[]
[null,"Betalingsmodel"]
[]
[]
[]
[null,"Omkostninger pr. deltager for indsatsgennemførsel"]
[null,null,"NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Samlet omkostning",{"$f":"C28-C30-C31","v":-1324581.0479315503},-99000,-77189.189189189186,-77189.189189189186,-80460.810810810814,-83241.689189189186,-85605.435810810814,-87614.620439189195,-89322.427373310813,-90774.063267314195,-92007.953777217059,-93056.760710634509,-93948.246604039334,-94706.009613433445,-95350.108171418426,-95897.591945705644,-96362.953153849812,-96758.510180772326,-97094.733653656484,-97380.523605608003,-97623.445064766798]
[null,"Indtægt"]
[null,"Skatteindtægter",{"$f":"SUMPRODUCT(D28:W28,Inputark!$E$16:$X$16)","v":124486.79912899528},{"$f":"IF(D25<=slutår,$D$38,IF(D25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(C28-C38)*(1-Dashboard!$D$27)+C38))","v":6000},{"$f":"IF(E25<=slutår,$D$38,IF(E25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(D28-D38)*(1-Dashboard!$D$27)+D38))","v":12000},{"$f":"IF(F25<=slutår,$D$38,IF(F25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(E28-E38)*(1-Dashboard!$D$27)+E38))","v":12000},{"$f":"IF(G25<=slutår,$D$38,IF(G25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(F28-F38)*(1-Dashboard!$D$27)+F38))","v":11100},{"$f":"IF(H25<=slutår,$D$38,IF(H25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(G28-G38)*(1-Dashboard!$D$27)+G38))","v":10335},{"$f":"IF(I25<=slutår,$D$38,IF(I25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(H28-H38)*(1-Dashboard!$D$27)+H38))","v":9684.75},{"$f":"IF(J25<=slutår,$D$38,IF(J25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(I28-I38)*(1-Dashboard!$D$27)+I38))","v":9132.0375000000004},{"$f":"IF(K25<=slutår,$D$38,IF(K25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(J28-J38)*(1-Dashboard!$D$27)+J38))","v":8662.2318750000013},{"$f":"IF(L25<=slutår,$D$38,IF(L25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(K28-K38)*(1-Dashboard!$D$27)+K38))","v":8262.8970937500017},{"$f":"IF(M25<=slutår,$D$38,IF(M25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(L28-L38)*(1-Dashboard!$D$27)+L38))","v":7923.462529687501},{"$f":"IF(N25<=slutår,$D$38,IF(N25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(M28-M38)*(1-Dashboard!$D$27)+M38))","v":7634.9431502343759},{"$f":"IF(O25<=slutår,$D$38,IF(O25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(N28-N38)*(1-Dashboard!$D$27)+N38))","v":7389.7016776992195},{"$f":"IF(P25<=slutår,$D$38,IF(P25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(O28-O38)*(1-Dashboard!$D$27)+O38))","v":7181.2464260443367},{"$f":"IF(Q25<=slutår,$D$38,IF(Q25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(P28-P38)*(1-Dashboard!$D$27)+P38))","v":7004.0594621376858},{"$f":"IF(R25<=slutår,$D$38,IF(R25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(Q28-Q38)*(1-Dashboard!$D$27)+Q38))","v":6853.4505428170332},{"$f":"IF(S25<=slutår,$D$38,IF(S25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(R28-R38)*(1-Dashboard!$D$27)+R38))","v":6725.4329613944783},{"$f":"IF(T25<=slutår,$D$38,IF(T25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(S28-S38)*(1-Dashboard!$D$27)+S38))","v":6616.6180171853066},{"$f":"IF(U25<=slutår,$D$38,IF(U25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(T28-T38)*(1-Dashboard!$D$27)+T38))","v":6524.1253146075105},{"$f":"IF(V25<=slutår,$D$38,IF(V25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(U28-U38)*(1-Dashboard!$D$27)+U38))","v":6445.5065174163838},{"$f":"IF(W25<=slutår,$D$38,IF(W25-slutår<=Dashboard!$D$26,Dashboard!$D$25*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50+$E$38,(V28-V38)*(1-Dashboard!$D$27)+V38))","v":6378.680539803926}]
[null,"Udgifter"]
[null,"Overførselsindkomst",{"$f":"SUMPRODUCT(D30:W30,Inputark!$E$16:$X$16)","v":1111511.7238090893},{"$f":"IF(D25<=slutår,$D$40,IF(D25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(C30-C40)*(1-Dashboard!$D$27)+C40))","v":80000},{"$f":"IF(E25<=slutår,$D$40,IF(E25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(D30-D40)*(1-Dashboard!$D$27)+D40))","v":69189.189189189186},{"$f":"IF(F25<=slutår,$D$40,IF(F25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(E30-E40)*(1-Dashboard!$D$27)+E40))","v":69189.189189189186},{"$f":"IF(G25<=slutår,$D$40,IF(G25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(F30-F40)*(1-Dashboard!$D$27)+F40))","v":70810.810810810814},{"$f":"IF(H25<=slutår,$D$40,IF(H25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(G30-G40)*(1-Dashboard!$D$27)+G40))","v":72189.189189189186},{"$f":"IF(I25<=slutår,$D$40,IF(I25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(H30-H40)*(1-Dashboard!$D$27)+H40))","v":73360.810810810814},{"$f":"IF(J25<=slutår,$D$40,IF(J25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(I30-I40)*(1-Dashboard!$D$27)+I40))","v":74356.689189189186},{"$f":"IF(K25<=slutår,$D$40,IF(K25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(J30-J40)*(1-Dashboard!$D$27)+J40))","v":75203.185810810814},{"$f":"IF(L25<=slutår,$D$40,IF(L25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(K30-K40)*(1-Dashboard!$D$27)+K40))","v":75922.707939189189},{"$f":"IF(M25<=slutår,$D$40,IF(M25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(L30-L40)*(1-Dashboard!$D$27)+L40))","v":76534.301748310812},{"$f":"IF(N25<=slutår,$D$40,IF(N25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(M30-M40)*(1-Dashboard!$D$27)+M40))","v":77054.156486064196},{"$f":"IF(O25<=slutår,$D$40,IF(O25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(N30-N40)*(1-Dashboard!$D$27)+N40))","v":77496.033013154563},{"$f":"IF(P25<=slutår,$D$40,IF(P25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(O30-O40)*(1-Dashboard!$D$27)+O40))","v":77871.628061181385},{"$f":"IF(Q25<=slutår,$D$40,IF(Q25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(P30-P40)*(1-Dashboard!$D$27)+P40))","v":78190.883852004175},{"$f":"IF(R25<=slutår,$D$40,IF(R25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(Q30-Q40)*(1-Dashboard!$D$27)+Q40))","v":78462.251274203547},{"$f":"IF(S25<=slutår,$D$40,IF(S25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(R30-R40)*(1-Dashboard!$D$27)+R40))","v":78692.913583073008},{"$f":"IF(T25<=slutår,$D$40,IF(T25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(S30-S40)*(1-Dashboard!$D$27)+S40))","v":78888.976545612051},{"$f":"IF(U25<=slutår,$D$40,IF(U25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(T30-T40)*(1-Dashboard!$D$27)+T40))","v":79055.630063770237},{"$f":"IF(V25<=slutår,$D$40,IF(V25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(U30-U40)*(1-Dashboard!$D$27)+U40))","v":79197.285554204704},{"$f":"IF(W25<=slutår,$D$40,IF(W25-slutår<=Dashboard!$D$26,Dashboard!$D$11*(1-Dashboard!$D$53)-(Dashboard!$D$25)*Dashboard!$D$11*(37-Dashboard!$D$10)/37*(1-Dashboard!$D$53),(V30-V40)*(1-Dashboard!$D$27)+V40))","v":79317.692721073996}]
[null,"Beskæftigelsesindsats",{"$f":"SUMPRODUCT(D31:W31,Inputark!$E$16:$X$16)","v":337556.1232514563},{"$f":"IF(D25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(D25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(C31-C41)*(1-Dashboard!$D$27)+C41))","v":25000},{"$f":"IF(E25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(E25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(D31-D41)*(1-Dashboard!$D$27)+D41))","v":20000},{"$f":"IF(F25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(F25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(E31-E41)*(1-Dashboard!$D$27)+E41))","v":20000},{"$f":"IF(G25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(G25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(F31-F41)*(1-Dashboard!$D$27)+F41))","v":20750},{"$f":"IF(H25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(H25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(G31-G41)*(1-Dashboard!$D$27)+G41))","v":21387.5},{"$f":"IF(I25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(I25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(H31-H41)*(1-Dashboard!$D$27)+H41))","v":21929.375},{"$f":"IF(J25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(J25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(I31-I41)*(1-Dashboard!$D$27)+I41))","v":22389.96875},{"$f":"IF(K25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(K25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(J31-J41)*(1-Dashboard!$D$27)+J41))","v":22781.473437500001},{"$f":"IF(L25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(L25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(K31-K41)*(1-Dashboard!$D$27)+K41))","v":23114.252421875},{"$f":"IF(M25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(M25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(L31-L41)*(1-Dashboard!$D$27)+L41))","v":23397.114558593752},{"$f":"IF(N25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(N25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(M31-M41)*(1-Dashboard!$D$27)+M41))","v":23637.54737480469},{"$f":"IF(O25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(O25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(N31-N41)*(1-Dashboard!$D$27)+N41))","v":23841.915268583987},{"$f":"IF(P25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(P25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(O31-O41)*(1-Dashboard!$D$27)+O41))","v":24015.62797829639},{"$f":"IF(Q25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(Q25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(P31-P41)*(1-Dashboard!$D$27)+P41))","v":24163.283781551931},{"$f":"IF(R25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(R25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(Q31-Q41)*(1-Dashboard!$D$27)+Q41))","v":24288.791214319142},{"$f":"IF(S25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(S25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(R31-R41)*(1-Dashboard!$D$27)+R41))","v":24395.472532171272},{"$f":"IF(T25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(T25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(S31-S41)*(1-Dashboard!$D$27)+S41))","v":24486.151652345583},{"$f":"IF(U25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(U25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(T31-T41)*(1-Dashboard!$D$27)+T41))","v":24563.228904493746},{"$f":"IF(V25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(V25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(U31-U41)*(1-Dashboard!$D$27)+U41))","v":24628.744568819686},{"$f":"IF(W25<=slutår,Dashboard!$D$12*(1-Dashboard!$D$28),IF(W25-slutår<=Dashboard!$D$26,(1-Dashboard!$D$25)*Dashboard!$D$12,(V31-V41)*(1-Dashboard!$D$27)+V41))","v":24684.432883496735}]
[null,"Diskonteret samlet omkostning",null,{"$f":"D26*Inputark!F16","v":-95652.173913043487},{"$f":"E26*Inputark!G16","v":-72056.93406071479},{"$f":"F26*Inputark!H16","v":-69620.226145618159},{"$f":"G26*Inputark!I16","v":-70116.948215406344},{"$f":"H26*Inputark!J16","v":-70087.268661274589},{"$f":"I26*Inputark!K16","v":-69640.077188340569},{"$f":"J26*Inputark!L16","v":-68864.299688946485},{"$f":"K26*Inputark!M16","v":-67832.483576578976},{"$f":"L26*Inputark!N16","v":-66603.741690727984},{"$f":"M26*Inputark!O16","v":-65226.169443608269},{"$f":"N26*Inputark!P16","v":-63738.829382277443},{"$f":"O26*Inputark!Q16","v":-62173.38050610161},{"$f":"P26*Inputark!R16","v":-60555.415854859864},{"$f":"Q26*Inputark!S16","v":-58905.560529213304},{"$f":"R26*Inputark!T16","v":-57240.372981101355},{"$f":"S26*Inputark!U16","v":-55573.084754120311},{"$f":"T26*Inputark!V16","v":-53914.207565185367},{"$f":"U26*Inputark!W16","v":-52272.03145411695},{"$f":"V26*Inputark!X16","v":-50653.033486301072},{"$f":"W26*Inputark!Y16","v":-49062.213010241132}]
[]
[null,"Omkostninger pr. deltager i baseline"]
[null,null,"NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Samlet omkostning",{"$f":"C38-SUM(C40:C41)","v":-1456273.9043345423},-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000]
[null,"Indtægt"]
[null,"Skatteindtægter",{"$f":"SUMPRODUCT(D38:W38,Inputark!$E$16:$X$16)","v":88259.024505123787},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000},{"$f":"Dashboard!$D$13*Dashboard!$D$8*Dashboard!$D$9*Dashboard!$D$50","v":6000}]
[null,"Udgifter"]
[null,"Overførselsindkomst",{"$f":"SUMPRODUCT(D40:W40,Inputark!$E$16:$X$16)","v":1176786.9934016503},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000},{"$f":"Dashboard!$D$11*(1-Dashboard!$D$53)","v":80000}]
[null,"Beskæftigelsesindsats",{"$f":"SUMPRODUCT(D41:W41,Inputark!$E$16:$X$16)","v":367745.93543801579},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000},{"$f":"Dashboard!$D$12","v":25000}]
[null,"Diskonteret samlet omkostning",null,{"$f":"D36*Inputark!F16","v":-95652.173913043487},{"$f":"E36*Inputark!G16","v":-92417.559336273902},{"$f":"F36*Inputark!H16","v":-89292.32786113421},{"$f":"G36*Inputark!I16","v":-86272.780542158667},{"$f":"H36*Inputark!J16","v":-83355.34351899389},{"$f":"I36*Inputark!K16","v":-80536.563786467523},{"$f":"J36*Inputark!L16","v":-77813.105107698095},{"$f":"K36*Inputark!M16","v":-75181.744065408799},{"$f":"L36*Inputark!N16","v":-72639.366246771795},{"$f":"M36*Inputark!O16","v":-70182.962557267441},{"$f":"N36*Inputark!P16","v":-67809.625659195604},{"$f":"O36*Inputark!Q16","v":-65516.546530623767},{"$f":"P36*Inputark!R16","v":-63301.011140699309},{"$f":"Q36*Inputark!S16","v":-61160.397237390629},{"$f":"R36*Inputark!T16","v":-59092.171243855693},{"$f":"S36*Inputark!U16","v":-57093.885259763956},{"$f":"T36*Inputark!V16","v":-55163.174164023156},{"$f":"U36*Inputark!W16","v":-53297.752815481312},{"$f":"V36*Inputark!X16","v":-51495.413348291135},{"$f":"W36*Inputark!Y16","v":-49754.022558735393}]
[]
[null,"Forskel ift. baseline"]
[null,null,"NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Samlet besparelse ift. baseline",{"$f":"SUM(C47:C49)","v":131692.85640299218},0,21810.810810810814,21810.810810810814,18539.189189189186,15758.310810810814,13394.564189189186,11385.379560810814,9677.572626689187,8225.9367326858119,6992.0462227829366,5943.2392893654905,5051.753395960669,4293.990386566561,3649.8918285815798,3102.4080542943439,2637.0468461501978,2241.4898192276723,1905.2663463435274,1619.4763943919943,1376.5549352331955]
[null,"Skatteindtægter",{"$f":"SUMPRODUCT(D47:W47,Inputark!$E$16:$X$16)","v":36227.774623871468},{"$f":"D28-D38","v":0},6000,6000,5100,4335,3684.75,3132.0375000000004,2662.2318750000013,2262.8970937500017,1923.462529687501,1634.9431502343759,1389.7016776992195,1181.2464260443367,1004.0594621376858,853.45054281703324,725.4329613944783,616.6180171853066,524.12531460751052,445.50651741638376,378.68053980392597]
[null,"Overførselsindkomst",{"$f":"SUMPRODUCT(D48:W48,Inputark!$E$16:$X$16)","v":65275.269592561206},{"$f":"D40-D30","v":0},10810.810810810814,10810.810810810814,9189.1891891891864,7810.8108108108136,6639.1891891891864,5643.3108108108136,4796.8141891891864,4077.2920608108107,3465.6982516891876,2945.8435139358044,2503.9669868454366,2128.3719388186146,1809.1161479958246,1537.7487257964531,1307.0864169269917,1111.0234543879487,944.36993622976297,802.71444579529634,682.30727892600407]
[null,"Beskæftigelsesindsats",{"$f":"SUMPRODUCT(D49:W49,Inputark!$E$16:$X$16)","v":30189.81218655952},{"$f":"D41-D31","v":0},5000,5000,4250,3612.5,3070.625,2610.03125,2218.5265624999993,1885.7475781249996,1602.885441406248,1362.4526251953102,1158.0847314160128,984.37202170360979,836.71621844806941,711.20878568085755,604.52746782872782,513.84834765441701,436.77109550625391,371.25543118031419,315.56711650326542]
[null,"Investering, leverandør",{"$f":"SUMPRODUCT(D50:W50,Inputark!$E$16:$X$16)","v":100000},{"$f":"IF(D45<=slutår,Dashboard!$D$37/levetid,0)","v":100000},{"$f":"IF(E45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(F45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(G45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(H45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(I45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(J45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(K45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(L45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(M45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(N45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(O45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(P45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(Q45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(R45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(S45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(T45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(U45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(V45<=slutår,Dashboard!$D$37/levetid,0)","v":0},{"$f":"IF(W45<=slutår,Dashboard!$D$37/levetid,0)","v":0}]
[null,"Investering, myndighed",{"$f":"SUMPRODUCT(D51:W51,Inputark!$E$16:$X$16)","v":10000},{"$f":"IF(D45<=slutår,Dashboard!$D$38/levetid,0)","v":10000},{"$f":"IF(E45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(F45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(G45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(H45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(I45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(J45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(K45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(L45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(M45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(N45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(O45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(P45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(Q45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(R45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(S45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(T45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(U45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(V45<=slutår,Dashboard!$D$38/levetid,0)","v":0},{"$f":"IF(W45<=slutår,Dashboard!$D$38/levetid,0)","v":0}]
[]
[null,"Indtægter fordelt på aktører"]
[null,null,"NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Leverandør",{"$f":"SUMPRODUCT($D$55:$W$55,Inputark!$E$16:$X$16)","v":-100000},{"$f":"-D50","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Myndighed",{"$f":"SUMPRODUCT(D56:W56,Inputark!$E$16:$X$16)","v":121692.85640299217},{"$f":"-D51+D49+D48+D47","v":-10000},21810.810810810814,21810.810810810814,18539.189189189186,15758.310810810814,13394.564189189186,11385.379560810814,9677.572626689187,8225.9367326858119,6992.0462227829366,5943.2392893654905,5051.753395960669,4293.990386566561,3649.8918285815798,3102.4080542943439,2637.0468461501978,2241.4898192276723,1905.2663463435274,1619.4763943919943,1376.5549352331955]
[]
[null,"Fordelt på aktører udspecificeret"]
[null,null,"NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Baseline"]
[null,"Leverandør",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Myndighed",{"$f":"SUMPRODUCT(D62:W62,Inputark!$E$16:$X$16)","v":-1456273.9043345426},{"$f":"D36","v":-99000},-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000,-99000]
[null,"Indsats"]
[null,"Leverandør",{"$f":"SUMPRODUCT(D64:W64,Inputark!$E$16:$X$16)","v":-100000},{"$f":"-D50","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Myndighed",{"$f":"SUMPRODUCT(D65:W65,Inputark!$F$16:$Y$16)","v":-1289450.2878565704},{"$f":"D26-D51","v":-109000},{"$f":"E26-E51","v":-77189.189189189186},-77189.189189189186,-80460.810810810814,-83241.689189189186,-85605.435810810814,-87614.620439189195,-89322.427373310813,-90774.063267314195,-92007.953777217059,-93056.760710634509,-93948.246604039334,-94706.009613433445,-95350.108171418426,-95897.591945705644,-96362.953153849812,-96758.510180772326,-97094.733653656484,-97380.523605608003,-97623.445064766798]
[null,"Difference"]
[null,"Leverandør",{"$f":"SUMPRODUCT(D67:W67,Inputark!$E$16:$X$16)","v":-100000},{"$f":"D61+D64","v":-100000},{"$f":"E61-E64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Myndighed",{"$f":"SUMPRODUCT(D68:W68,Inputark!$E$16:$X$16)","v":121692.85640299217},{"$f":"-(D62-D65)","v":-10000},21810.810810810814,21810.810810810814,18539.189189189186,15758.310810810814,13394.564189189186,11385.379560810805,9677.572626689187,8225.9367326858046,6992.0462227829412,5943.2392893654905,5051.7533959606662,4293.9903865665547,3649.8918285815744,3102.4080542943557,2637.0468461501878,2241.4898192276742,1905.2663463435165,1619.476394391997,1376.5549352332018]
[]
[]
[]
[null,"Myndigheden betaler til investor"]
[]
[null,"Diskonterede værdier"]
[null,null,null,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Skatteindtægter",null,{"$f":"D47*Inputark!E$16","v":0},{"$f":"E47*Inputark!F$16","v":5797.1014492753629},{"$f":"F47*Inputark!G$16","v":5601.0642021984186},{"$f":"G47*Inputark!H$16","v":4599.9077989069137},{"$f":"H47*Inputark!I$16","v":3777.7020570733112},{"$f":"I47*Inputark!J$16","v":3102.4606265819471},{"$f":"J47*Inputark!K$16","v":2547.9145242460436},{"$f":"K47*Inputark!L$16","v":2092.4901889943362},{"$f":"L47*Inputark!M$16","v":1718.4702035219193},{"$f":"M47*Inputark!N$16","v":1411.3040318779047},{"$f":"N47*Inputark!O$16","v":1159.0419585470715},{"$f":"O47*Inputark!P$16","v":951.87020750242596},{"$f":"P47*Inputark!Q$16","v":781.7291559198668},{"$f":"Q47*Inputark!R$16","v":641.99978988588089},{"$f":"R47*Inputark!S$16","v":527.24620425410512},{"$f":"S47*Inputark!T$16","v":433.00412909757443},{"$f":"T47*Inputark!U$16","v":355.60725578061675},{"$f":"U47*Inputark!V$16","v":292.04460619664172},{"$f":"V47*Inputark!W$16","v":239.84339639337719},{"$f":"W47*Inputark!X$16","v":196.97283761774929}]
[null,"Overførselsindkomster",null,{"$f":"D48*Inputark!E$16","v":0},{"$f":"E48*Inputark!F$16","v":10445.227836532187},{"$f":"F48*Inputark!G$16","v":10092.007571528684},{"$f":"G48*Inputark!H$16","v":8288.1221601926354},{"$f":"H48*Inputark!I$16","v":6806.6703731050675},{"$f":"I48*Inputark!J$16","v":5590.0191469944966},{"$f":"J48*Inputark!K$16","v":4590.8369806235041},{"$f":"K48*Inputark!L$16","v":3770.2525927825836},{"$f":"L48*Inputark!M$16","v":3096.3427090485011},{"$f":"M48*Inputark!N$16","v":2542.8901475277535},{"$f":"N48*Inputark!O$16","v":2088.3638892739973},{"$f":"O48*Inputark!P$16","v":1715.0814549593233},{"$f":"P48*Inputark!Q$16","v":1408.521001657411},{"$f":"Q48*Inputark!R$16","v":1156.7563781727547},{"$f":"R48*Inputark!S$16","v":949.99316081820552},{"$f":"S48*Inputark!T$16","v":780.18761999563185},{"$f":"T48*Inputark!U$16","v":640.73379419931462},{"$f":"U48*Inputark!V$16","v":526.20649765161465},{"$f":"V48*Inputark!W$16","v":432.15026377185632},{"$f":"W48*Inputark!X$16","v":354.90601372568034}]
[null,"Beskæftigelsesindsats",null,{"$f":"D49*Inputark!E$16","v":0},{"$f":"E49*Inputark!F$16","v":4830.9178743961356},{"$f":"F49*Inputark!G$16","v":4667.5535018320152},{"$f":"G49*Inputark!H$16","v":3833.2564990890951},{"$f":"H49*Inputark!I$16","v":3148.0850475610928},{"$f":"I49*Inputark!J$16","v":2585.3838554849558},{"$f":"J49*Inputark!K$16","v":2123.2621035383695},{"$f":"K49*Inputark!L$16","v":1743.7418241619453},{"$f":"L49*Inputark!M$16","v":1432.0585029349315},{"$f":"M49*Inputark!N$16","v":1176.0866932315851},{"$f":"N49*Inputark!O$16","v":965.86829878922424},{"$f":"O49*Inputark!P$16","v":793.22517291868598},{"$f":"P49*Inputark!Q$16","v":651.4409632665529},{"$f":"Q49*Inputark!R$16","v":534.99982490489936},{"$f":"R49*Inputark!S$16","v":439.37183687841883},{"$f":"S49*Inputark!T$16","v":360.83677424797622},{"$f":"T49*Inputark!U$16","v":296.33937981717764},{"$f":"U49*Inputark!V$16","v":243.3705051638654},{"$f":"V49*Inputark!W$16","v":199.86949699447797},{"$f":"W49*Inputark!X$16","v":164.14403134812119}]
[null,"Indsatsomkostninger",null,{"$f":"-IF(D83=betalingsår,D51+Resultater!$C$9,D51)*Inputark!E16","v":-10000},{"$f":"-IF(E83=betalingsår,E51+Resultater!$C$9,E51)*Inputark!F16","v":-101858.17787511888},{"$f":"-IF(F83=betalingsår,F51+Resultater!$C$9,F51)*Inputark!G16","v":0},{"$f":"-IF(G83=betalingsår,G51+Resultater!$C$9,G51)*Inputark!H16","v":0},{"$f":"-IF(H83=betalingsår,H51+Resultater!$C$9,H51)*Inputark!I16","v":0},{"$f":"-IF(I83=betalingsår,I51+Resultater!$C$9,I51)*Inputark!J16","v":0},{"$f":"-IF(J83=betalingsår,J51+Resultater!$C$9,J51)*Inputark!K16","v":0},{"$f":"-IF(K83=betalingsår,K51+Resultater!$C$9,K51)*Inputark!L16","v":0},{"$f":"-IF(L83=betalingsår,L51+Resultater!$C$9,L51)*Inputark!M16","v":0},{"$f":"-IF(M83=betalingsår,M51+Resultater!$C$9,M51)*Inputark!N16","v":0},{"$f":"-IF(N83=betalingsår,N51+Resultater!$C$9,N51)*Inputark!O16","v":0},{"$f":"-IF(O83=betalingsår,O51+Resultater!$C$9,O51)*Inputark!P16","v":0},{"$f":"-IF(P83=betalingsår,P51+Resultater!$C$9,P51)*Inputark!Q16","v":0},{"$f":"-IF(Q83=betalingsår,Q51+Resultater!$C$9,Q51)*Inputark!R16","v":0},{"$f":"-IF(R83=betalingsår,R51+Resultater!$C$9,R51)*Inputark!S16","v":0},{"$f":"-IF(S83=betalingsår,S51+Resultater!$C$9,S51)*Inputark!T16","v":0},{"$f":"-IF(T83=betalingsår,T51+Resultater!$C$9,T51)*Inputark!U16","v":0},{"$f":"-IF(U83=betalingsår,U51+Resultater!$C$9,U51)*Inputark!V16","v":0},{"$f":"-IF(V83=betalingsår,V51+Resultater!$C$9,V51)*Inputark!W16","v":0},{"$f":"-IF(W83=betalingsår,W51+Resultater!$C$9,W51)*Inputark!X16","v":0}]
[]
[]
[null,"Akkumuleret"]
[null,"Myndighed betaler til Investor","NPV",2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Myndighed",null,{"$f":"SUM(D85:D88)","v":-10000},{"$f":"SUM(E85:E88)","v":-90784.930714915201},-70424.305439356074,-53703.018981167435,-39970.561503427976,-28692.697874366568,-19430.68426595864,-11824.199660019789,-5577.3282445144287,-447.04737187718274,3766.2267747331061,7226.403610113528,10068.094730957353,12401.850723920899,14318.461925871627,15892.490449212812,{"$f":"SUM(T85:T88)","v":17185.170879009922},18246.792488022038,19118.65564518176,19834.6785278733]
[null,"Skatteindtægter",null,{"$f":"SUM($D$76:D76)","v":0},{"$f":"SUM($D$76:E76)","v":5797.1014492753629},{"$f":"SUM($D$76:F76)","v":11398.165651473781},{"$f":"SUM($D$76:G76)","v":15998.073450380694},{"$f":"SUM($D$76:H76)","v":19775.775507454004},{"$f":"SUM($D$76:I76)","v":22878.236134035949},{"$f":"SUM($D$76:J76)","v":25426.150658281993},{"$f":"SUM($D$76:K76)","v":27518.640847276329},{"$f":"SUM($D$76:L76)","v":29237.111050798248},{"$f":"SUM($D$76:M76)","v":30648.415082676154},{"$f":"SUM($D$76:N76)","v":31807.457041223224},{"$f":"SUM($D$76:O76)","v":32759.327248725651},{"$f":"SUM($D$76:P76)","v":33541.056404645518},{"$f":"SUM($D$76:Q76)","v":34183.056194531397},{"$f":"SUM($D$76:R76)","v":34710.302398785505},{"$f":"SUM($D$76:S76)","v":35143.306527883076},{"$f":"SUM($D$76:T76)","v":35498.913783663695},{"$f":"SUM($D$76:U76)","v":35790.958389860338},{"$f":"SUM($D$76:V76)","v":36030.801786253716},{"$f":"SUM($D$76:W76)","v":36227.774623871468}]
[null,"Overførselsindkomst",null,{"$f":"SUM($D$77:D77)","v":0},{"$f":"SUM($D$77:E77)","v":10445.227836532187},{"$f":"SUM($D$77:F77)","v":20537.235408060871},{"$f":"SUM($D$77:G77)","v":28825.357568253508},{"$f":"SUM($D$77:H77)","v":35632.027941358574},{"$f":"SUM($D$77:I77)","v":41222.047088353072},{"$f":"SUM($D$77:J77)","v":45812.884068976578},{"$f":"SUM($D$77:K77)","v":49583.136661759163},{"$f":"SUM($D$77:L77)","v":52679.479370807661},{"$f":"SUM($D$77:M77)","v":55222.369518335414},{"$f":"SUM($D$77:N77)","v":57310.733407609412},{"$f":"SUM($D$77:O77)","v":59025.814862568732},{"$f":"SUM($D$77:P77)","v":60434.335864226145},{"$f":"SUM($D$77:Q77)","v":61591.092242398896},{"$f":"SUM($D$77:R77)","v":62541.085403217105},{"$f":"SUM($D$77:S77)","v":63321.273023212736},{"$f":"SUM($D$77:T77)","v":63962.006817412053},{"$f":"SUM($D$77:U77)","v":64488.213315063666},{"$f":"SUM($D$77:V77)","v":64920.363578835524},{"$f":"SUM($D$77:W77)","v":65275.269592561206}]
[null,"Beskæftigelsesindsats",null,{"$f":"SUM($D$78:D78)","v":0},{"$f":"SUM($D$78:E78)","v":4830.9178743961356},{"$f":"SUM($D$78:F78)","v":9498.4713762281499},{"$f":"SUM($D$78:G78)","v":13331.727875317245},{"$f":"SUM($D$78:H78)","v":16479.812922878336},{"$f":"SUM($D$78:I78)","v":19065.196778363294},{"$f":"SUM($D$78:J78)","v":21188.458881901664},{"$f":"SUM($D$78:K78)","v":22932.20070606361},{"$f":"SUM($D$78:L78)","v":24364.259208998541},{"$f":"SUM($D$78:M78)","v":25540.345902230125},{"$f":"SUM($D$78:N78)","v":26506.214201019349},{"$f":"SUM($D$78:O78)","v":27299.439373938036},{"$f":"SUM($D$78:P78)","v":27950.880337204588},{"$f":"SUM($D$78:Q78)","v":28485.880162109486},{"$f":"SUM($D$78:R78)","v":28925.251998987904},{"$f":"SUM($D$78:S78)","v":29286.088773235879},{"$f":"SUM($D$78:T78)","v":29582.428153053057},{"$f":"SUM($D$78:U78)","v":29825.798658216921},{"$f":"SUM($D$78:V78)","v":30025.668155211399},{"$f":"SUM($D$78:W78)","v":30189.81218655952}]
[null,"Indsatsomkostninger",null,{"$f":"SUM($D$79:D79)","v":-10000},{"$f":"SUM($D$79:E79)","v":-111858.17787511888},{"$f":"SUM($D$79:F79)","v":-111858.17787511888},{"$f":"SUM($D$79:G79)","v":-111858.17787511888},{"$f":"SUM($D$79:H79)","v":-111858.17787511888},{"$f":"SUM($D$79:I79)","v":-111858.17787511888},{"$f":"SUM($D$79:J79)","v":-111858.17787511888},{"$f":"SUM($D$79:K79)","v":-111858.17787511888},{"$f":"SUM($D$79:L79)","v":-111858.17787511888},{"$f":"SUM($D$79:M79)","v":-111858.17787511888},{"$f":"SUM($D$79:N79)","v":-111858.17787511888},{"$f":"SUM($D$79:O79)","v":-111858.17787511888},{"$f":"SUM($D$79:P79)","v":-111858.17787511888},{"$f":"SUM($D$79:Q79)","v":-111858.17787511888},{"$f":"SUM($D$79:R79)","v":-111858.17787511888},{"$f":"SUM($D$79:S79)","v":-111858.17787511888},{"$f":"SUM($D$79:T79)","v":-111858.17787511888},{"$f":"SUM($D$79:U79)","v":-111858.17787511888},{"$f":"SUM($D$79:V79)","v":-111858.17787511888},{"$f":"SUM($D$79:W79)","v":-111858.17787511888}]
[]
[null,"Beskæftigelseseffekt",null,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,"Baseline",null,{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2},{"$f":"Dashboard!$D$13","v":0.2}]
[null,"Indsats",null,{"$f":"IF(D83<=slutår,D91,IF(D83-slutår<=Dashboard!$D$26+D91,D91+Dashboard!$D$25,D91+(C92-D91)*(1-Dashboard!$D$27)))","v":0.2},{"$f":"IF(E83<=slutår,E91,IF(E83-slutår<=Dashboard!$D$26+E91,E91+Dashboard!$D$25,E91+(D92-E91)*(1-Dashboard!$D$27)))","v":0.4},{"$f":"IF(F83<=slutår,F91,IF(F83-slutår<=Dashboard!$D$26+F91,F91+Dashboard!$D$25,F91+(E92-F91)*(1-Dashboard!$D$27)))","v":0.4},{"$f":"IF(G83<=slutår,G91,IF(G83-slutår<=Dashboard!$D$26+G91,G91+Dashboard!$D$25,G91+(F92-G91)*(1-Dashboard!$D$27)))","v":0.37},{"$f":"IF(H83<=slutår,H91,IF(H83-slutår<=Dashboard!$D$26+H91,H91+Dashboard!$D$25,H91+(G92-H91)*(1-Dashboard!$D$27)))","v":0.34450000000000003},{"$f":"IF(I83<=slutår,I91,IF(I83-slutår<=Dashboard!$D$26+I91,I91+Dashboard!$D$25,I91+(H92-I91)*(1-Dashboard!$D$27)))","v":0.32282500000000003},{"$f":"IF(J83<=slutår,J91,IF(J83-slutår<=Dashboard!$D$26+J91,J91+Dashboard!$D$25,J91+(I92-J91)*(1-Dashboard!$D$27)))","v":0.30440125000000001},{"$f":"IF(K83<=slutår,K91,IF(K83-slutår<=Dashboard!$D$26+K91,K91+Dashboard!$D$25,K91+(J92-K91)*(1-Dashboard!$D$27)))","v":0.28874106249999998},{"$f":"IF(L83<=slutår,L91,IF(L83-slutår<=Dashboard!$D$26+L91,L91+Dashboard!$D$25,L91+(K92-L91)*(1-Dashboard!$D$27)))","v":0.27542990312499999},{"$f":"IF(M83<=slutår,M91,IF(M83-slutår<=Dashboard!$D$26+M91,M91+Dashboard!$D$25,M91+(L92-M91)*(1-Dashboard!$D$27)))","v":0.26411541765625002},{"$f":"IF(N83<=slutår,N91,IF(N83-slutår<=Dashboard!$D$26+N91,N91+Dashboard!$D$25,N91+(M92-N91)*(1-Dashboard!$D$27)))","v":0.2544981050078125},{"$f":"IF(O83<=slutår,O91,IF(O83-slutår<=Dashboard!$D$26+O91,O91+Dashboard!$D$25,O91+(N92-O91)*(1-Dashboard!$D$27)))","v":0.24632338925664063},{"$f":"IF(P83<=slutår,P91,IF(P83-slutår<=Dashboard!$D$26+P91,P91+Dashboard!$D$25,P91+(O92-P91)*(1-Dashboard!$D$27)))","v":0.23937488086814454},{"$f":"IF(Q83<=slutår,Q91,IF(Q83-slutår<=Dashboard!$D$26+Q91,Q91+Dashboard!$D$25,Q91+(P92-Q91)*(1-Dashboard!$D$27)))","v":0.23346864873792286},{"$f":"IF(R83<=slutår,R91,IF(R83-slutår<=Dashboard!$D$26+R91,R91+Dashboard!$D$25,R91+(Q92-R91)*(1-Dashboard!$D$27)))","v":0.22844835142723444},{"$f":"IF(S83<=slutår,S91,IF(S83-slutår<=Dashboard!$D$26+S91,S91+Dashboard!$D$25,S91+(R92-S91)*(1-Dashboard!$D$27)))","v":0.22418109871314928},{"$f":"IF(T83<=slutår,T91,IF(T83-slutår<=Dashboard!$D$26+T91,T91+Dashboard!$D$25,T91+(S92-T91)*(1-Dashboard!$D$27)))","v":0.22055393390617689},{"$f":"IF(U83<=slutår,U91,IF(U83-slutår<=Dashboard!$D$26+U91,U91+Dashboard!$D$25,U91+(T92-U91)*(1-Dashboard!$D$27)))","v":0.21747084382025036},{"$f":"IF(V83<=slutår,V91,IF(V83-slutår<=Dashboard!$D$26+V91,V91+Dashboard!$D$25,V91+(U92-V91)*(1-Dashboard!$D$27)))","v":0.21485021724721282},{"$f":"IF(W83<=slutår,W91,IF(W83-slutår<=Dashboard!$D$26+W91,W91+Dashboard!$D$25,W91+(V92-W91)*(1-Dashboard!$D$27)))","v":0.2126226846601309}]

{"sheet":"SIB projektet","index":5,"n_rows":78,"n_cols":6,"rows_kept":78,"cut":false,"hidden":false,"merged":[[68,1,69,1],[3,1,3,8],[68,2,69,2]]}
[null,"SIB-indsatsen"]
[]
[]
[null,"DRC/Dansk Flygtningehjælp har med støtte fra Poul Due Jensens Fond udviklet og gennemført en beskæftigelsesindsats for 55 længerevarende ledige ikke-vestlige mænd i Viborg og Herning Kommuner i perioden 1. oktober 2020 til 30. april 2022. COWI har forestået dokumentationen af beskæftigelsesindsatsen, herunder en samfundsøkonomisk og budgetøkonomisk analyse. Analysen viser, at beskæftigelsesindsatsen giver en budgetøkonomisk gevinst. Mens udviklingsprojektet ikke indebar en betalingmodel, betyder en sådan gevinst, at den givne beskæftigelsesindsats godt kunne have fundet sted via en betalingsmodel, hvor myndigheden (f.eks. en kommune) betaler en investor (f.eks. Poul Due Jensens Fond), der betaler en leverandør (f.eks. Dansk Flygtningehjælp), som gennemfører indsatsen. For en mere detaljeret beskrivelse, se de to COWI-notater: \"Samfundsøkonomisk analyse af SIB-projektet\" og \"Betalingsmodel for SIB-projektet\".                           "]
[]
[]
[]
[]
[]
[null,"UDGIFTER"]
[]
[null,"Aktør","Udgifter: kr. pr. deltager i SIB-indsatsen"]
[null,"Dansk Flygtningehjælp",75255]
[null,"Herning/Viborg Kommune",5146]
[null,"I alt",{"$f":"SUM(C13:C14)","v":80401}]
[null,"Kilde: Dansk Flygtningehjælp, Herning og Viborg Kommuner, og COWI"]
[]
[null,"INDTÆGTER"]
[]
[null,"Antagelser"]
[null,"Beskæftigelseseffekt, %",0.17599999999999999]
[null,"- målgruppe",0.35]
[null,"- kontrolgruppe",{"$f":"C22-C21","v":0.17399999999999999}]
[null,"Årligt fald i beskæftigelseseffekt efter 2 år",0.15]
[null,"Arbejdstid, timer pr. år",565]
[null,"Arbejdstid, kr. pr. time",164]
[null,"Antal timer på overførselsind. pr. uge",21]
[null,"Kommunal skattesats",0.2]
[null,"Statsskattesats",0.1]
[null,"Alm. indsats, kr. person pr. år",26150]
[null,"Besparelse på alm. indsats, % (2 første år)",0.5]
[null,"Nuværende overførselsindkomst til en gennemsnitlig deltager, kr. pr. år",105032]
[null,"Statsrefusion på kommunale udgifter til overførselsindkomst",0.2]
[null,"Kilde: Dansk Flygtningehjælp, Herning og Viborg Kommuner, og COWI"]
[]
[null,"BUDGETØKONOMISK RESULTAT"]
[]
[]
[null,"Udgifter og indtægter","Nutidsværdi"]
[null,null,"Kr."]
[null,"Udgifter",{"$f":"C42+C43","v":-79235.664548089597}]
[null,"Dansk Flygtningehjælp",-74164.602624505933]
[null,"Kommune",-5071.061923583663]
[]
[null,"Indtægter",{"$f":"C46+C47+C48","v":107588.37317481251}]
[null,"Øgede skatteindtægter (kommune)",18866.609139041368]
[null,"Sparede overførselsesindkomsker (kommune)",36356.577490268282]
[null,"Sparet beskæftigelsesindsats (kommune)",52365.18654550286]
[]
[null,"Indtægter - udgifter",{"$f":"C51+C52","v":28352.708626722917}]
[null,"Dansk Flygtningehjælp",{"$f":"C42","v":-74164.602624505933}]
[null,"Kommune",{"$f":"C45+C43","v":102517.31125122885}]
[null,"Note: Negative beløb er udgifter og positive beløb er indtægter."]
[]
[]
[]
[null,"Investors andel af økonomisk råderum",0.5]
[]
[null,null,"Kr. pr. person pr. SIB-forløb (NPV)"]
[null,"Økonomisk råderum",{"$f":"C50","v":28352.708626722917}]
[null,"Eksempel - en deling af det økonomiske råderum",{"$f":"C60*C57","v":14176.354313361458}]
[null,"Kommune betaler Dansk Flygtningehjælp i gennemsnit pr. deltager",{"$f":"C61-C51","v":88340.956937867391}]
[]
[null,"Antal år før kommunen opnår budgetøkonomisk overskud for en gennemsnitlig deltager",8]
[]
[null,"Kommune betaler Dansk Flygtningehjælp, kr. pr. person der kommer i beskæftigelse",{"$f":"C62/E73","v":254801.50830783346}]
[]
[null,"Nogle deltagere er sværere at få i beskæftigelse end andre"]
[null,"Beskæftigelseserfaring de sidste to år: ","Andel af deltagere","I beskæftigelse efter forløb"]
[null,null,null,"Nej","Ja"]
[null,"Ja",0.35,0.47370000000000001,0.52629999999999999]
[null,"Nej",0.65,0.75,0.25]
[null,"Vægtede gns.",null,{"$f":"(D71*$C$71)+($C$72*D72)","v":0.65329500000000007},{"$f":"(E71*$C$71)+($C$72*E72)","v":0.34670499999999999}]
[]
[null,"Kommune betaler Dansk Flygtningehjælp, kr. pr. person der kommer i beskæftigelse","Kr. pr. person i beskæftigelse",null,"hjælpeberegning"]
[null,"Beskæftigelseserfaring",{"$f":"C66-E76","v":209040.4314232881},null,{"$f":"F76*C66","v":45761.076884545349},{"$f":"(E71-E73)","v":0.179595}]
[null,"Ingen beskæftigelseserfaring",{"$f":"E77+C66","v":279442.08816874248},null,{"$f":"F77*C66","v":24640.579860909031},{"$f":"(E73-E72)","v":9.6704999999999985E-2}]
[null,"Gennemsnit",{"$f":"(C71*C76)+(C72*C77)","v":254801.50830783346},null,null,{"$f":"C66","v":254801.50830783346}]

{"sheet":"Standarder","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),99)","v":"Standarder"}]
[]
[]
[null,"Standarder for celler"]
[]
[]
[null,null,null,"Tekst"]
[null,null,null,"Input data"]
[null,null,null,"Link til andre celler"]
[null,null,null,"Formler"]
[null,null,null,"Tentativ data"]
[]
[]
[null,"Standarder for ark"]
[]
[]
[null,null,null,"Lyseblå ark er ark med datainput"]
[null,null,null,"Hvide ark er ark er informationsark til brugeren vedrørende modellen"]
[null,null,null,"Grå ark indeholder beregninger"]

{"sheet":"Lister","index":7,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Lister"]
[]
[]
[null,"Antal år før beskæftigelses fald",null,null,"Projektperiode"]
[null,{"$f":"_xlfn.SEQUENCE(Dashboard!D26,,Dashboard!D20,1)","v":2022},null,null,{"$f":"_xlfn.SEQUENCE(Dashboard!$D$23,,Dashboard!D20,1)","v":2022}]
[null,2023]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Startår for beskæftigelseeffekt"]
[null,{"$f":"Dashboard!D21+1","v":2023}]