{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["forside","input","Beregning","Resultat","Enhedspriskatalog","KPI Husleje "],"not_rendered":{"charts":0,"images":31,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,5,1,22],[5,7,5,13],[7,7,7,13],[9,7,9,13]]}
[]
[null,"Omkostingsvurdering af:",null,null,null,"Familiens Hus "]
[]
[]
[]
[null,"Ansvarlig for beregning:",null,null,null,null,null,"Tine Lesner og Andreas Müller, Center for Data, Analyse og Metode",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(evt vedhæfte notat)"]
[]
[null,"Ansvarlig for input vedrørende indsatsen:",null,null,null,null,null,"Rikke Plauborg, Center for Børn, Unge og Familier"]
[]
[null,"Dato:",null,null,null,null,null,"2016-02-26"]

{"sheet":"input","index":1,"n_rows":95,"n_cols":20,"rows_kept":95,"cut":false,"hidden":false,"merged":[[33,11,33,13],[33,15,33,16],[33,18,33,19],[0,1,0,20]]}
[null,"Input vedrørende indsatsen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Generelle input",null,null,"Specifikation af teams"]
[null,null,"Indtast",null,"Medarbejder-type","Specifikation","Antal pr. team","Antal I alt","Årsløn","timeløn"]
[null,"Generelt",null,null,"Type 1","Leder",1,1,{"$f":"Enhedspriskatalog!D65","v":539565.58935714175},{"$f":"Enhedspriskatalog!E65","v":380.51169912351321}]
[null,"Forløb pr. team pr. år",110,null,"Type 2","Administrativ medarbejder ",{"$f":"32/37","v":0.86486486486486491},1,{"$f":"Enhedspriskatalog!D52","v":396314.49781889492},{"$f":"Enhedspriskatalog!E52","v":279.48836235465086}]
[null,"Antal driftsår",3,null,"Type 3","Socialrådgivere",3,3,{"$f":"Enhedspriskatalog!D62","v":435398.67051219422},{"$f":"Enhedspriskatalog!E62","v":307.05124859816237}]
[null,"Antal teams",1,null,"Type 4","Sundhedsplejerske",1.5,1.5,{"$f":"Enhedspriskatalog!D64","v":438457.85570475715},{"$f":"Enhedspriskatalog!E64","v":309.20864295116866}]
[null,"Antal forløb pr år",{"$f":"C15*C17","v":110},null,"Type 5","Uddannelsesvejleder ",0.5,0.5,{"$f":"Enhedspriskatalog!D62","v":435398.67051219422},{"$f":"Enhedspriskatalog!E62","v":307.05124859816237}]
[null,"Antal forløb i driftsperioden i alt",{"$f":"C18*C16","v":330},null,"Type 6","Metodekonsulent",0.5,0.5,{"$f":"Enhedspriskatalog!D45","v":532122.30942199985},{"$f":"Enhedspriskatalog!E45","v":375.26255953596603}]
[null,"Borgere",null,null,"Type 7","Frivillighedskoordinator",0.5,0.5,{"$f":"Enhedspriskatalog!D62","v":435398.67051219422},{"$f":"Enhedspriskatalog!E62","v":307.05124859816237}]
[null,"Borgere pr. forløb",1,null,"Type 8","Jordemoder ",0.5,0.5,346800,{"$f":"I21/1418","v":244.56981664315938}]
[null,"Andel fuldførte  borgerforløb",1]
[null,"Antal igangsatte borgerforløb pr. år",{"$f":"C15*C17","v":110}]
[null,"Antal gennemførte borgerforløb pr. år",{"$f":"C23*C22","v":110}]
[null,"Antal igangsatte borgerforløb over driftsperioden",{"$f":"C23*C16","v":330}]
[null,"Antal gennemførte borgerforløb over driftsperioden",{"$f":"C25*C22","v":330}]
[null,"Specifikation af aktører"]
[null,"Aktør 1","Esbjerg kommune"]
[null,"Aktør 2"]
[null,"Aktør 3"]
[]
[]
[null,"Ressourceforbrug",null,null,null,null,null,null,null,null,null,"Fordeling",null,null,null,"Baggrundsinfo"]
[null,null,"Beskrivelse","Enhed","Angivet","Antal","Enhedspris","Overhead (pct.)","Enhedspris inkl. overhead","Levetid (år)",null,"Fordeling af omkostninger (%)",null,null,null,"Baggrund 1",null,null,"Baggrund 2"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28=\"\", \"\", C28)","v":"Esbjerg kommune"},{"$f":"IF(C29=\"\", \"\", C29)","v":""},{"$f":"IF(C30=\"\", \"\",C30)","v":""},null,"Beskrivelse","værdi",null,"Beskrivelse","værdi"]
[null,"Forberedelse"]
[null,"Løn  til medarbejdertype 1 ",null,"kr","",1,{"$f":"T37","v":135064.5},0.2,{"$f":"IF(G37=\"\", \"\", G37*(1+H37))","v":162077.4},10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"354.5*381","v":135064.5}]
[null,"Løn  til medarbejdertype 2",null,"kr",null,1,{"$f":"T38","v":85454.351999999999},0.2,102545.2224,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","(1418*0,8)/4=306,3"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"306.288*279","v":85454.351999999999}]
[null,"Løn  til medarbejdertype 3 ",null,"kr",null,1,326494.5,0.2,391793.39999999997,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*307)*3","v":326494.5}]
[null,"Løn  til medarbejdertype 4",null,"kr",null,1,163247.25,0.2,195896.69999999998,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*307)*1.5","v":163247.25}]
[null,"Løn  til medarbejdertype 5",null,"kr",null,1,54415.75,0.2,65298.899999999994,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*307)*0.5","v":54415.75}]
[null,"Løn  til medarbejdertype 6",null,"kr",null,1,54415.75,0.2,65298.899999999994,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*307)*0.5","v":54415.75}]
[null,"Løn  til medarbejdertype 7",null,"kr",null,1,54415.75,0.2,65298.899999999994,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*307)*0.5","v":54415.75}]
[null,"Løn  til medarbejdertype 8",null,"kr",null,1,54770.25,0.2,65724.3,10,null,1,null,null,null,"Det beregende antal timer i forberedelsesfasen pr. medarbejdergruppe","1418/4=354,5"," ","Den beregende løn pr. medarbejdergruppe i forberedelsesfasen",{"$f":"(354.5*309)*0.5","v":54770.25}]
[null,"Kontorhold, indretning husleje ","Værdien dækker både indretning, husleje og kontorhold. Værdien er beregnet på Moderniseringsstyrelsens oversigt over statens gennemsnitlige udgifter til husleje pr. årsværk.  ","kr ",null,1,140000,0.2,168000,10,null,1]
[null,"Yderlser købt eksternt ","Konkrete ydelser købt eksternt dækker bl.a. over ydelers købt hos en ekstern psykolog, fysioterapeut og andre eksterne.   ","kr",null,1,30000,null,30000,10,null,1]
[null,"Uddannelse"]
[null,"Efteruddannelse ","Der er tale om fælles interne uddannelses forløb, som afvikles løbende i takt med medarbejderuskiftning. Efteruddannelsen kan afoldes i grupper. ","kr",null,1,100000,null,{"$f":"IF(G48=\"\", \"\", G48*(1+H48))","v":100000},1,null,1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G49=\"\", \"\", G49*(1+H49))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Drift af indsats",null,null,null,null,null,null,{"$f":"IF(G56=\"\", \"\", G56*(1+H56))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G57=\"\", \"\", G57*(1+H57))","v":""}]
[null,null,null,"kr",null,null,null,null,""]
[null,"Løn  til medarbejdertype 1 ",null,"kr",null,1,{"$f":"I14","v":539565.58935714175},0.2,647478.70722857013,1,null,1]
[null,"Løn  til medarbejdertype 2",null,"kr",null,1,396314.49781889492,0.2,475577.39738267387,1,null,1]
[null,"Løn  til medarbejdertype 3 ",null,"kr",null,1,435398.67051219422,0.2,522478.40461463307,1,null,1]
[null,"Løn  til medarbejdertype 4",null,"kr",null,1,438457.85570475715,0.2,526149.42684570851,1,null,1]
[null,"Løn  til medarbejdertype 5",null,"kr ",null,1,435398.67051219422,0.2,522478.40461463307,1,null,1]
[null,"Løn  til medarbejdertype 6",null,"kr",null,1,532122.30942199985,0.2,{"$f":"IF(G64=\"\", \"\", G64*(1+H64))","v":638546.77130639984},1,null,1]
[null,"Løn  til medarbejdertype 7",null,"kr",null,1,435398.67051219422,0.2,522478.40461463307,1,null,1]
[null,"Løn  til medarbejdertype 8",null,"kr",null,1,346800,0.2,416160,1,null,1]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Investeringer  "]
[null,null,null,null,null,null,null,null,{"$f":"IF(G73=\"\", \"\", G73*(1+H73))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G74=\"\", \"\", G74*(1+H74))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Øvrige omkostninger"]
[null,"Kontorhold, indretning husleje ","Værdien dækker både indretning, husleje og kontorhold. Værdien er beregnet på Moderniseringsstyrelsens oversigt over statens gennemsnitlige udgifter til husleje pr. årsværk.  ","kr",null,1,{"$f":"'KPI Husleje '!G6","v":546476.62162162166},0.2,{"$f":"IF(G80=\"\", \"\", G80*(1+H80))","v":655771.94594594592},1,null,1]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Ydelser købt eksternt ","Konkrete ydelser købt eksternt dækker bl.a. over ydelers købt hos en ekstern psykolog, fysioterapeut og andre eksterne.   ","kr",null,1,125000,null,125000,1,null,1]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Tilskud"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G91=\"\", \"\", G91*(1+H91))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G92=\"\", \"\", G92*(1+H92))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G93=\"\", \"\", G93*(1+H93))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G94=\"\", \"\", G94*(1+H94))","v":""}]
[null,"Total"]

{"sheet":"Beregning","index":2,"n_rows":72,"n_cols":33,"rows_kept":72,"cut":false,"hidden":false,"merged":[[10,23,10,25],[10,14,10,16],[0,1,0,21],[10,4,11,4],[10,5,11,5],[10,7,11,7],[10,8,11,8],[10,3,11,3],[10,2,11,2],[10,9,11,9],[10,11,10,13],[10,17,10,19],[10,20,10,22]]}
[null,"Beregning af omkostninger"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Beregning"]
[null,null,"Total antal enheder i den angivne levetid","Total omkostning i den angivne levetid","Årlig omkostning","NNV over hele perioden",null,"Omkostning pr forløb","Omkostning pr igangsat borgerforløb","Omkostning pr gennemført borgerforløb",null,"Årlig omk. Fordelt",null,null,"NNV fordelt","Fordelt",null,"Omk. Pr forløb fordelt","Fordelt",null,"Omk. Pr. igangsat borgerforløb fordelt","Fordelt",null,"Omkostninger på gennemført borgerforløb fordelt","Fordelt"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"input!$C$28","v":"Esbjerg kommune"},{"$f":"input!$C$29","v":0},{"$f":"input!$C$30","v":0},{"$f":"input!$C$28","v":"Esbjerg kommune"},{"$f":"input!$C$29","v":0},{"$f":"input!$C$30","v":0},{"$f":"input!$C$28","v":"Esbjerg kommune"},{"$f":"input!$C$29","v":0},{"$f":"input!$C$30","v":0},{"$f":"input!$C$28","v":"Esbjerg kommune"},{"$f":"input!$C$29","v":0},{"$f":"input!$C$30","v":0},{"$f":"input!$C$28","v":"Esbjerg kommune"},{"$f":"input!$C$29","v":0},{"$f":"input!$C$30","v":0}]
[null,{"$f":"IF(input!B36=\"\", \"\", input!B36)","v":"Forberedelse"},null,null,{"$f":"SUM(E14:E23)","v":155528.41108966077},{"$f":"SUM(F14:F23)","v":448869.71898805973},null,{"$f":"SUM(H14:H23)","v":1413.8946462696435},{"$f":"SUM(I14:I23)","v":1413.8946462696435},{"$f":"SUM(J14:J23)","v":1413.8946462696435},null,{"$f":"SUM(L14:L23)","v":155528.41108966077},0,0,448869.71898805973,0,0,1413.8946462696435,0,0,1413.8946462696435,0,0,{"$f":"SUM(X14:X23)","v":1413.8946462696435},0,0]
[null,{"$f":"IF(input!B37=\"\", \"\", input!B37)","v":"Løn  til medarbejdertype 1 "},1,{"$f":"IF(input!H37=\"\",Beregning!C14*input!G37,Beregning!C14*input!I37)","v":162077.4},{"$f":"IF(input!F37=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J37,Beregning!D14, 0, 1))","v":19214.111250551221},{"$f":"IF(input!F37= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E14,0, 1))","v":55453.744156546534},null,{"$f":"IF(E14= \"\", \"\", E14/input!$C$18)","v":174.67373864137474},{"$f":"IF(E14=\"\", \"\", E14/input!$C$23)","v":174.67373864137474},{"$f":"IF(E14=\"\", \"\", E14/input!$C$24)","v":174.67373864137474},null,{"$f":"IF($E14=\"\", \"\", $E14*input!L37)","v":19214.111250551221},{"$f":"IF($E14=\"\", \"\", $E14*input!M37)","v":0},{"$f":"IF($E14=\"\", \"\", $E14*input!N37)","v":0},{"$f":"IF($F14=\"\", \"\", $F14*input!L37)","v":55453.744156546534},{"$f":"IF($F14=\"\", \"\", $F14*input!M37)","v":0},{"$f":"IF($F14=\"\", \"\", $F14*input!N37)","v":0},{"$f":"IF($H14=\"\", \"\", $H14*input!L37)","v":174.67373864137474},{"$f":"IF($H14=\"\", \"\", $H14*input!M37)","v":0},{"$f":"IF($H14=\"\", \"\", $H14*input!N37)","v":0},{"$f":"IF($I14=\"\", \"\",$I14*input!L37)","v":174.67373864137474},{"$f":"IF($I14=\"\", \"\",$I14*input!M37)","v":0},{"$f":"IF($I14=\"\", \"\",$I14*input!N37)","v":0},{"$f":"IF($J14=\"\", \"\", $J14*input!L37)","v":174.67373864137474},{"$f":"IF($J14=\"\", \"\", $J14*input!M37)","v":0},{"$f":"IF($J14=\"\", \"\", $J14*input!N37)","v":0}]
[null,{"$f":"IF(input!B38=\"\", \"\", input!B38)","v":"Løn  til medarbejdertype 2"},1,{"$f":"IF(input!H38=\"\",Beregning!C15*input!G38,Beregning!C15*input!I38)","v":102545.2224},{"$f":"IF(input!F38=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J38,Beregning!D15, 0, 1))","v":12156.632025230643},{"$f":"IF(input!F38= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E15,0, 1))","v":35085.190948557691},null,{"$f":"IF(E15= \"\", \"\", E15/input!$C$18)","v":110.51483659300585},{"$f":"IF(E15=\"\", \"\", E15/input!$C$23)","v":110.51483659300585},{"$f":"IF(E15=\"\", \"\", E15/input!$C$24)","v":110.51483659300585},null,{"$f":"IF($E15=\"\", \"\", $E15*input!L38)","v":12156.632025230643},{"$f":"IF($E15=\"\", \"\", $E15*input!M38)","v":0},{"$f":"IF($E15=\"\", \"\", $E15*input!N38)","v":0},{"$f":"IF($F15=\"\", \"\", $F15*input!L38)","v":35085.190948557691},{"$f":"IF($F15=\"\", \"\", $F15*input!M38)","v":0},{"$f":"IF($F15=\"\", \"\", $F15*input!N38)","v":0},{"$f":"IF($H15=\"\", \"\", $H15*input!L38)","v":110.51483659300585},{"$f":"IF($H15=\"\", \"\", $H15*input!M38)","v":0},{"$f":"IF($H15=\"\", \"\", $H15*input!N38)","v":0},{"$f":"IF($I15=\"\", \"\",$I15*input!L38)","v":110.51483659300585},{"$f":"IF($I15=\"\", \"\",$I15*input!M38)","v":0},{"$f":"IF($I15=\"\", \"\",$I15*input!N38)","v":0},{"$f":"IF($J15=\"\", \"\", $J15*input!L38)","v":110.51483659300585},{"$f":"IF($J15=\"\", \"\", $J15*input!M38)","v":0},{"$f":"IF($J15=\"\", \"\", $J15*input!N38)","v":0}]
[null,{"$f":"IF(input!B39=\"\", \"\", input!B39)","v":"Løn  til medarbejdertype 3 "},1,{"$f":"IF(input!H39=\"\",Beregning!C16*input!G39,Beregning!C16*input!I39)","v":391793.39999999997},{"$f":"IF(input!F39=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J39,Beregning!D16, 0, 1))","v":46446.709873379725},{"$f":"IF(input!F39= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E16,0, 1))","v":134049.60201621876},null,{"$f":"IF(E16= \"\", \"\", E16/input!$C$18)","v":422.24281703072478},{"$f":"IF(E16=\"\", \"\", E16/input!$C$23)","v":422.24281703072478},{"$f":"IF(E16=\"\", \"\", E16/input!$C$24)","v":422.24281703072478},null,{"$f":"IF($E16=\"\", \"\", $E16*input!L39)","v":46446.709873379725},{"$f":"IF($E16=\"\", \"\", $E16*input!M39)","v":0},{"$f":"IF($E16=\"\", \"\", $E16*input!N39)","v":0},{"$f":"IF($F16=\"\", \"\", $F16*input!L39)","v":134049.60201621876},{"$f":"IF($F16=\"\", \"\", $F16*input!M39)","v":0},{"$f":"IF($F16=\"\", \"\", $F16*input!N39)","v":0},{"$f":"IF($H16=\"\", \"\", $H16*input!L39)","v":422.24281703072478},{"$f":"IF($H16=\"\", \"\", $H16*input!M39)","v":0},{"$f":"IF($H16=\"\", \"\", $H16*input!N39)","v":0},{"$f":"IF($I16=\"\", \"\",$I16*input!L39)","v":422.24281703072478},{"$f":"IF($I16=\"\", \"\",$I16*input!M39)","v":0},{"$f":"IF($I16=\"\", \"\",$I16*input!N39)","v":0},{"$f":"IF($J16=\"\", \"\", $J16*input!L39)","v":422.24281703072478},{"$f":"IF($J16=\"\", \"\", $J16*input!M39)","v":0},{"$f":"IF($J16=\"\", \"\", $J16*input!N39)","v":0}]
[null,{"$f":"IF(input!B40=\"\", \"\", input!B40)","v":"Løn  til medarbejdertype 4"},1,{"$f":"IF(input!H40=\"\",Beregning!C17*input!G40,Beregning!C17*input!I40)","v":195896.69999999998},{"$f":"IF(input!F40=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J40,Beregning!D17, 0, 1))","v":23223.354936689862},{"$f":"IF(input!F40= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E17,0, 1))","v":67024.801008109382},null,{"$f":"IF(E17= \"\", \"\", E17/input!$C$18)","v":211.12140851536239},{"$f":"IF(E17=\"\", \"\", E17/input!$C$23)","v":211.12140851536239},{"$f":"IF(E17=\"\", \"\", E17/input!$C$24)","v":211.12140851536239},null,{"$f":"IF($E17=\"\", \"\", $E17*input!L40)","v":23223.354936689862},{"$f":"IF($E17=\"\", \"\", $E17*input!M40)","v":0},{"$f":"IF($E17=\"\", \"\", $E17*input!N40)","v":0},{"$f":"IF($F17=\"\", \"\", $F17*input!L40)","v":67024.801008109382},{"$f":"IF($F17=\"\", \"\", $F17*input!M40)","v":0},{"$f":"IF($F17=\"\", \"\", $F17*input!N40)","v":0},{"$f":"IF($H17=\"\", \"\", $H17*input!L40)","v":211.12140851536239},{"$f":"IF($H17=\"\", \"\", $H17*input!M40)","v":0},{"$f":"IF($H17=\"\", \"\", $H17*input!N40)","v":0},{"$f":"IF($I17=\"\", \"\",$I17*input!L40)","v":211.12140851536239},{"$f":"IF($I17=\"\", \"\",$I17*input!M40)","v":0},{"$f":"IF($I17=\"\", \"\",$I17*input!N40)","v":0},{"$f":"IF($J17=\"\", \"\", $J17*input!L40)","v":211.12140851536239},{"$f":"IF($J17=\"\", \"\", $J17*input!M40)","v":0},{"$f":"IF($J17=\"\", \"\", $J17*input!N40)","v":0}]
[null,{"$f":"IF(input!B41=\"\", \"\", input!B41)","v":"Løn  til medarbejdertype 5"},1,{"$f":"IF(input!H41=\"\",Beregning!C18*input!G41,Beregning!C18*input!I41)","v":65298.899999999994},{"$f":"IF(input!F41=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J41,Beregning!D18, 0, 1))","v":7741.1183122299535},{"$f":"IF(input!F41= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E18,0, 1))","v":22341.600336036463},null,{"$f":"IF(E18= \"\", \"\", E18/input!$C$18)","v":70.373802838454125},{"$f":"IF(E18=\"\", \"\", E18/input!$C$23)","v":70.373802838454125},{"$f":"IF(E18=\"\", \"\", E18/input!$C$24)","v":70.373802838454125},null,{"$f":"IF($E18=\"\", \"\", $E18*input!L41)","v":7741.1183122299535},{"$f":"IF($E18=\"\", \"\", $E18*input!M41)","v":0},{"$f":"IF($E18=\"\", \"\", $E18*input!N41)","v":0},{"$f":"IF($F18=\"\", \"\", $F18*input!L41)","v":22341.600336036463},{"$f":"IF($F18=\"\", \"\", $F18*input!M41)","v":0},{"$f":"IF($F18=\"\", \"\", $F18*input!N41)","v":0},{"$f":"IF($H18=\"\", \"\", $H18*input!L41)","v":70.373802838454125},{"$f":"IF($H18=\"\", \"\", $H18*input!M41)","v":0},{"$f":"IF($H18=\"\", \"\", $H18*input!N41)","v":0},{"$f":"IF($I18=\"\", \"\",$I18*input!L41)","v":70.373802838454125},{"$f":"IF($I18=\"\", \"\",$I18*input!M41)","v":0},{"$f":"IF($I18=\"\", \"\",$I18*input!N41)","v":0},{"$f":"IF($J18=\"\", \"\", $J18*input!L41)","v":70.373802838454125},{"$f":"IF($J18=\"\", \"\", $J18*input!M41)","v":0},{"$f":"IF($J18=\"\", \"\", $J18*input!N41)","v":0}]
[null,{"$f":"IF(input!B42=\"\", \"\", input!B42)","v":"Løn  til medarbejdertype 6"},1,{"$f":"IF(input!H42=\"\",Beregning!C19*input!G42,Beregning!C19*input!I42)","v":65298.899999999994},{"$f":"IF(input!F42=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J42,Beregning!D19, 0, 1))","v":7741.1183122299535},{"$f":"IF(input!F42= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E19,0, 1))","v":22341.600336036463},null,{"$f":"IF(E19= \"\", \"\", E19/input!$C$18)","v":70.373802838454125},{"$f":"IF(E19=\"\", \"\", E19/input!$C$23)","v":70.373802838454125},{"$f":"IF(E19=\"\", \"\", E19/input!$C$24)","v":70.373802838454125},null,{"$f":"IF($E19=\"\", \"\", $E19*input!L42)","v":7741.1183122299535},{"$f":"IF($E19=\"\", \"\", $E19*input!M42)","v":0},{"$f":"IF($E19=\"\", \"\", $E19*input!N42)","v":0},{"$f":"IF($F19=\"\", \"\", $F19*input!L42)","v":22341.600336036463},{"$f":"IF($F19=\"\", \"\", $F19*input!M42)","v":0},{"$f":"IF($F19=\"\", \"\", $F19*input!N42)","v":0},{"$f":"IF($H19=\"\", \"\", $H19*input!L42)","v":70.373802838454125},{"$f":"IF($H19=\"\", \"\", $H19*input!M42)","v":0},{"$f":"IF($H19=\"\", \"\", $H19*input!N42)","v":0},{"$f":"IF($I19=\"\", \"\",$I19*input!L42)","v":70.373802838454125},{"$f":"IF($I19=\"\", \"\",$I19*input!M42)","v":0},{"$f":"IF($I19=\"\", \"\",$I19*input!N42)","v":0},{"$f":"IF($J19=\"\", \"\", $J19*input!L42)","v":70.373802838454125},{"$f":"IF($J19=\"\", \"\", $J19*input!M42)","v":0},{"$f":"IF($J19=\"\", \"\", $J19*input!N42)","v":0}]
[null,{"$f":"IF(input!B43=\"\", \"\", input!B43)","v":"Løn  til medarbejdertype 7"},1,{"$f":"IF(input!H43=\"\",Beregning!C20*input!G43,Beregning!C20*input!I43)","v":65298.899999999994},{"$f":"IF(input!F43=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J43,Beregning!D20, 0, 1))","v":7741.1183122299535},{"$f":"IF(input!F43= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E20,0, 1))","v":22341.600336036463},null,{"$f":"IF(E20= \"\", \"\", E20/input!$C$18)","v":70.373802838454125},{"$f":"IF(E20=\"\", \"\", E20/input!$C$23)","v":70.373802838454125},{"$f":"IF(E20=\"\", \"\", E20/input!$C$24)","v":70.373802838454125},null,{"$f":"IF($E20=\"\", \"\", $E20*input!L43)","v":7741.1183122299535},{"$f":"IF($E20=\"\", \"\", $E20*input!M43)","v":0},{"$f":"IF($E20=\"\", \"\", $E20*input!N43)","v":0},{"$f":"IF($F20=\"\", \"\", $F20*input!L43)","v":22341.600336036463},{"$f":"IF($F20=\"\", \"\", $F20*input!M43)","v":0},{"$f":"IF($F20=\"\", \"\", $F20*input!N43)","v":0},{"$f":"IF($H20=\"\", \"\", $H20*input!L43)","v":70.373802838454125},{"$f":"IF($H20=\"\", \"\", $H20*input!M43)","v":0},{"$f":"IF($H20=\"\", \"\", $H20*input!N43)","v":0},{"$f":"IF($I20=\"\", \"\",$I20*input!L43)","v":70.373802838454125},{"$f":"IF($I20=\"\", \"\",$I20*input!M43)","v":0},{"$f":"IF($I20=\"\", \"\",$I20*input!N43)","v":0},{"$f":"IF($J20=\"\", \"\", $J20*input!L43)","v":70.373802838454125},{"$f":"IF($J20=\"\", \"\", $J20*input!M43)","v":0},{"$f":"IF($J20=\"\", \"\", $J20*input!N43)","v":0}]
[null,{"$f":"IF(input!B44=\"\", \"\", input!B44)","v":"Løn  til medarbejdertype 8"},1,{"$f":"IF(input!H44=\"\",Beregning!C21*input!G44,Beregning!C21*input!I44)","v":65724.3},{"$f":"IF(input!F44=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J44,Beregning!D21, 0, 1))","v":7791.5490504203772},{"$f":"IF(input!F44= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E21,0, 1))","v":22487.148220961782},null,{"$f":"IF(E21= \"\", \"\", E21/input!$C$18)","v":70.832264094730704},{"$f":"IF(E21=\"\", \"\", E21/input!$C$23)","v":70.832264094730704},{"$f":"IF(E21=\"\", \"\", E21/input!$C$24)","v":70.832264094730704},null,{"$f":"IF($E21=\"\", \"\", $E21*input!L44)","v":7791.5490504203772},{"$f":"IF($E21=\"\", \"\", $E21*input!M44)","v":0},{"$f":"IF($E21=\"\", \"\", $E21*input!N44)","v":0},{"$f":"IF($F21=\"\", \"\", $F21*input!L44)","v":22487.148220961782},{"$f":"IF($F21=\"\", \"\", $F21*input!M44)","v":0},{"$f":"IF($F21=\"\", \"\", $F21*input!N44)","v":0},{"$f":"IF($H21=\"\", \"\", $H21*input!L44)","v":70.832264094730704},{"$f":"IF($H21=\"\", \"\", $H21*input!M44)","v":0},{"$f":"IF($H21=\"\", \"\", $H21*input!N44)","v":0},{"$f":"IF($I21=\"\", \"\",$I21*input!L44)","v":70.832264094730704},{"$f":"IF($I21=\"\", \"\",$I21*input!M44)","v":0},{"$f":"IF($I21=\"\", \"\",$I21*input!N44)","v":0},{"$f":"IF($J21=\"\", \"\", $J21*input!L44)","v":70.832264094730704},{"$f":"IF($J21=\"\", \"\", $J21*input!M44)","v":0},{"$f":"IF($J21=\"\", \"\", $J21*input!N44)","v":0}]
[null,{"$f":"IF(input!B45=\"\", \"\", input!B45)","v":"Kontorhold, indretning husleje "},1,{"$f":"IF(input!H45=\"\",Beregning!C22*input!G45,Beregning!C22*input!I45)","v":168000},{"$f":"IF(input!F45=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J45,Beregning!D22, 0, 1))","v":19916.229468714362},{"$f":"IF(input!F45= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E22,0, 1))","v":57480.123806896067},null,{"$f":"IF(E22= \"\", \"\", E22/input!$C$18)","v":181.05663153376693},{"$f":"IF(E22=\"\", \"\", E22/input!$C$23)","v":181.05663153376693},{"$f":"IF(E22=\"\", \"\", E22/input!$C$24)","v":181.05663153376693},null,{"$f":"IF($E22=\"\", \"\", $E22*input!L45)","v":19916.229468714362},{"$f":"IF($E22=\"\", \"\", $E22*input!M45)","v":0},{"$f":"IF($E22=\"\", \"\", $E22*input!N45)","v":0},{"$f":"IF($F22=\"\", \"\", $F22*input!L45)","v":57480.123806896067},{"$f":"IF($F22=\"\", \"\", $F22*input!M45)","v":0},{"$f":"IF($F22=\"\", \"\", $F22*input!N45)","v":0},{"$f":"IF($H22=\"\", \"\", $H22*input!L45)","v":181.05663153376693},{"$f":"IF($H22=\"\", \"\", $H22*input!M45)","v":0},{"$f":"IF($H22=\"\", \"\", $H22*input!N45)","v":0},{"$f":"IF($I22=\"\", \"\",$I22*input!L45)","v":181.05663153376693},{"$f":"IF($I22=\"\", \"\",$I22*input!M45)","v":0},{"$f":"IF($I22=\"\", \"\",$I22*input!N45)","v":0},{"$f":"IF($J22=\"\", \"\", $J22*input!L45)","v":181.05663153376693},{"$f":"IF($J22=\"\", \"\", $J22*input!M45)","v":0},{"$f":"IF($J22=\"\", \"\", $J22*input!N45)","v":0}]
[null,{"$f":"IF(input!B46=\"\", \"\", input!B46)","v":"Yderlser købt eksternt "},1,{"$f":"IF(input!H46=\"\",Beregning!C23*input!G46,Beregning!C23*input!I46)","v":30000},{"$f":"IF(input!F46=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J46,Beregning!D23, 0, 1))","v":3556.4695479847078},{"$f":"IF(input!F46= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E23,0, 1))","v":10264.307822660014},null,{"$f":"IF(E23= \"\", \"\", E23/input!$C$18)","v":32.331541345315529},{"$f":"IF(E23=\"\", \"\", E23/input!$C$23)","v":32.331541345315529},{"$f":"IF(E23=\"\", \"\", E23/input!$C$24)","v":32.331541345315529},null,{"$f":"IF($E23=\"\", \"\", $E23*input!L46)","v":3556.4695479847078},{"$f":"IF($E23=\"\", \"\", $E23*input!M46)","v":0},{"$f":"IF($E23=\"\", \"\", $E23*input!N46)","v":0},{"$f":"IF($F23=\"\", \"\", $F23*input!L46)","v":10264.307822660014},{"$f":"IF($F23=\"\", \"\", $F23*input!M46)","v":0},{"$f":"IF($F23=\"\", \"\", $F23*input!N46)","v":0},{"$f":"IF($H23=\"\", \"\", $H23*input!L46)","v":32.331541345315529},{"$f":"IF($H23=\"\", \"\", $H23*input!M46)","v":0},{"$f":"IF($H23=\"\", \"\", $H23*input!N46)","v":0},{"$f":"IF($I23=\"\", \"\",$I23*input!L46)","v":32.331541345315529},{"$f":"IF($I23=\"\", \"\",$I23*input!M46)","v":0},{"$f":"IF($I23=\"\", \"\",$I23*input!N46)","v":0},{"$f":"IF($J23=\"\", \"\", $J23*input!L46)","v":32.331541345315529},{"$f":"IF($J23=\"\", \"\", $J23*input!M46)","v":0},{"$f":"IF($J23=\"\", \"\", $J23*input!N46)","v":0}]
[null,{"$f":"IF(input!B47=\"\", \"\", input!B47)","v":"Uddannelse"},null,null,{"$f":"SUM(E25:E32)","v":100000},{"$f":"SUM(F25:F32)","v":288609.46745562146},null,{"$f":"SUM(H25:H32)","v":909.09090909090912},{"$f":"SUM(I25:I32)","v":909.09090909090912},{"$f":"SUM(J25:J32)","v":909.09090909090912},null,{"$f":"SUM(L25:L32)","v":100000},0,0,288609.46745562146,0,0,909.09090909090912,0,0,909.09090909090912,0,0,909.09090909090912,0,0]
[null,{"$f":"IF(input!B48=\"\", \"\", input!B48)","v":"Efteruddannelse "},1,{"$f":"IF(input!H48=\"\",Beregning!C25*input!G48,Beregning!C25*input!I48)","v":100000},{"$f":"IF(input!F48=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J48,Beregning!D25, 0, 1))","v":100000},{"$f":"IF(input!F48= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E25,0, 1))","v":288609.46745562146},null,{"$f":"IF(E25= \"\", \"\", E25/input!$C$18)","v":909.09090909090912},{"$f":"IF(E25=\"\", \"\", E25/input!$C$23)","v":909.09090909090912},{"$f":"IF(E25=\"\", \"\", E25/input!$C$24)","v":909.09090909090912},null,{"$f":"IF($E25=\"\", \"\", $E25*input!L48)","v":100000},{"$f":"IF($E25=\"\", \"\", $E25*input!M48)","v":0},{"$f":"IF($E25=\"\", \"\", $E25*input!N48)","v":0},{"$f":"IF($F25=\"\", \"\", $F25*input!L48)","v":288609.46745562146},{"$f":"IF($F25=\"\", \"\", $F25*input!M48)","v":0},{"$f":"IF($F25=\"\", \"\", $F25*input!N48)","v":0},{"$f":"IF($H25=\"\", \"\", $H25*input!L48)","v":909.09090909090912},{"$f":"IF($H25=\"\", \"\", $H25*input!M48)","v":0},{"$f":"IF($H25=\"\", \"\", $H25*input!N48)","v":0},{"$f":"IF($I25=\"\", \"\",$I25*input!L48)","v":909.09090909090912},{"$f":"IF($I25=\"\", \"\",$I25*input!M48)","v":0},{"$f":"IF($I25=\"\", \"\",$I25*input!N48)","v":0},{"$f":"IF($J25=\"\", \"\", $J25*input!L48)","v":909.09090909090912},{"$f":"IF($J25=\"\", \"\", $J25*input!M48)","v":0},{"$f":"IF($J25=\"\", \"\", $J25*input!N48)","v":0}]
[null,{"$f":"IF(input!B49=\"\", \"\", input!B49)","v":""},null,{"$f":"IF(input!H49=\"\",Beregning!C26*input!G49,Beregning!C26*input!I49)","v":0},{"$f":"IF(input!F49=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J49,Beregning!D26, 0, 1))","v":""},{"$f":"IF(input!F49= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E26,0, 1))","v":""},null,{"$f":"IF(E26= \"\", \"\", E26/input!$C$18)","v":""},{"$f":"IF(E26=\"\", \"\", E26/input!$C$23)","v":""},{"$f":"IF(E26=\"\", \"\", E26/input!$C$24)","v":""},null,{"$f":"IF($E26=\"\", \"\", $E26*input!L49)","v":""},{"$f":"IF($E26=\"\", \"\", $E26*input!M49)","v":""},{"$f":"IF($E26=\"\", \"\", $E26*input!N49)","v":""},{"$f":"IF($F26=\"\", \"\", $F26*input!L49)","v":""},{"$f":"IF($F26=\"\", \"\", $F26*input!M49)","v":""},{"$f":"IF($F26=\"\", \"\", $F26*input!N49)","v":""},{"$f":"IF($H26=\"\", \"\", $H26*input!L49)","v":""},{"$f":"IF($H26=\"\", \"\", $H26*input!M49)","v":""},{"$f":"IF($H26=\"\", \"\", $H26*input!N49)","v":""},{"$f":"IF($I26=\"\", \"\",$I26*input!L49)","v":""},{"$f":"IF($I26=\"\", \"\",$I26*input!M49)","v":""},{"$f":"IF($I26=\"\", \"\",$I26*input!N49)","v":""},{"$f":"IF($J26=\"\", \"\", $J26*input!L49)","v":""},{"$f":"IF($J26=\"\", \"\", $J26*input!M49)","v":""},{"$f":"IF($J26=\"\", \"\", $J26*input!N49)","v":""}]
[null,{"$f":"IF(input!B50=\"\", \"\", input!B50)","v":""},null,{"$f":"IF(input!H50=\"\",Beregning!C27*input!G50,Beregning!C27*input!I50)","v":0},{"$f":"IF(input!F50=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J50,Beregning!D27, 0, 1))","v":""},{"$f":"IF(input!F50= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E27,0, 1))","v":""},null,{"$f":"IF(E27= \"\", \"\", E27/input!$C$18)","v":""},{"$f":"IF(E27=\"\", \"\", E27/input!$C$23)","v":""},{"$f":"IF(E27=\"\", \"\", E27/input!$C$24)","v":""},null,{"$f":"IF($E27=\"\", \"\", $E27*input!L50)","v":""},{"$f":"IF($E27=\"\", \"\", $E27*input!M50)","v":""},{"$f":"IF($E27=\"\", \"\", $E27*input!N50)","v":""},{"$f":"IF($F27=\"\", \"\", $F27*input!L50)","v":""},{"$f":"IF($F27=\"\", \"\", $F27*input!M50)","v":""},{"$f":"IF($F27=\"\", \"\", $F27*input!N50)","v":""},{"$f":"IF($H27=\"\", \"\", $H27*input!L50)","v":""},{"$f":"IF($H27=\"\", \"\", $H27*input!M50)","v":""},{"$f":"IF($H27=\"\", \"\", $H27*input!N50)","v":""},{"$f":"IF($I27=\"\", \"\",$I27*input!L50)","v":""},{"$f":"IF($I27=\"\", \"\",$I27*input!M50)","v":""},{"$f":"IF($I27=\"\", \"\",$I27*input!N50)","v":""},{"$f":"IF($J27=\"\", \"\", $J27*input!L50)","v":""},{"$f":"IF($J27=\"\", \"\", $J27*input!M50)","v":""},{"$f":"IF($J27=\"\", \"\", $J27*input!N50)","v":""}]
[null,{"$f":"IF(input!B51=\"\", \"\", input!B51)","v":""},null,{"$f":"IF(input!H51=\"\",Beregning!C28*input!G51,Beregning!C28*input!I51)","v":0},{"$f":"IF(input!F51=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J51,Beregning!D28, 0, 1))","v":""},{"$f":"IF(input!F51= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E28,0, 1))","v":""},null,{"$f":"IF(E28= \"\", \"\", E28/input!$C$18)","v":""},{"$f":"IF(E28=\"\", \"\", E28/input!$C$23)","v":""},{"$f":"IF(E28=\"\", \"\", E28/input!$C$24)","v":""},null,{"$f":"IF($E28=\"\", \"\", $E28*input!L51)","v":""},{"$f":"IF($E28=\"\", \"\", $E28*input!M51)","v":""},{"$f":"IF($E28=\"\", \"\", $E28*input!N51)","v":""},{"$f":"IF($F28=\"\", \"\", $F28*input!L51)","v":""},{"$f":"IF($F28=\"\", \"\", $F28*input!M51)","v":""},{"$f":"IF($F28=\"\", \"\", $F28*input!N51)","v":""},{"$f":"IF($H28=\"\", \"\", $H28*input!L51)","v":""},{"$f":"IF($H28=\"\", \"\", $H28*input!M51)","v":""},{"$f":"IF($H28=\"\", \"\", $H28*input!N51)","v":""},{"$f":"IF($I28=\"\", \"\",$I28*input!L51)","v":""},{"$f":"IF($I28=\"\", \"\",$I28*input!M51)","v":""},{"$f":"IF($I28=\"\", \"\",$I28*input!N51)","v":""},{"$f":"IF($J28=\"\", \"\", $J28*input!L51)","v":""},{"$f":"IF($J28=\"\", \"\", $J28*input!M51)","v":""},{"$f":"IF($J28=\"\", \"\", $J28*input!N51)","v":""}]
[null,{"$f":"IF(input!B52=\"\", \"\", input!B52)","v":""},null,{"$f":"IF(input!H52=\"\",Beregning!C29*input!G52,Beregning!C29*input!I52)","v":0},{"$f":"IF(input!F52=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J52,Beregning!D29, 0, 1))","v":""},{"$f":"IF(input!F52= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E29,0, 1))","v":""},null,{"$f":"IF(E29= \"\", \"\", E29/input!$C$18)","v":""},{"$f":"IF(E29=\"\", \"\", E29/input!$C$23)","v":""},{"$f":"IF(E29=\"\", \"\", E29/input!$C$24)","v":""},null,{"$f":"IF($E29=\"\", \"\", $E29*input!L52)","v":""},{"$f":"IF($E29=\"\", \"\", $E29*input!M52)","v":""},{"$f":"IF($E29=\"\", \"\", $E29*input!N52)","v":""},{"$f":"IF($F29=\"\", \"\", $F29*input!L52)","v":""},{"$f":"IF($F29=\"\", \"\", $F29*input!M52)","v":""},{"$f":"IF($F29=\"\", \"\", $F29*input!N52)","v":""},{"$f":"IF($H29=\"\", \"\", $H29*input!L52)","v":""},{"$f":"IF($H29=\"\", \"\", $H29*input!M52)","v":""},{"$f":"IF($H29=\"\", \"\", $H29*input!N52)","v":""},{"$f":"IF($I29=\"\", \"\",$I29*input!L52)","v":""},{"$f":"IF($I29=\"\", \"\",$I29*input!M52)","v":""},{"$f":"IF($I29=\"\", \"\",$I29*input!N52)","v":""},{"$f":"IF($J29=\"\", \"\", $J29*input!L52)","v":""},{"$f":"IF($J29=\"\", \"\", $J29*input!M52)","v":""},{"$f":"IF($J29=\"\", \"\", $J29*input!N52)","v":""}]
[null,{"$f":"IF(input!B53=\"\", \"\", input!B53)","v":""},null,{"$f":"IF(input!H53=\"\",Beregning!C30*input!G53,Beregning!C30*input!I53)","v":0},{"$f":"IF(input!F53=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J53,Beregning!D30, 0, 1))","v":""},{"$f":"IF(input!F53= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E30,0, 1))","v":""},null,{"$f":"IF(E30= \"\", \"\", E30/input!$C$18)","v":""},{"$f":"IF(E30=\"\", \"\", E30/input!$C$23)","v":""},{"$f":"IF(E30=\"\", \"\", E30/input!$C$24)","v":""},null,{"$f":"IF($E30=\"\", \"\", $E30*input!L53)","v":""},{"$f":"IF($E30=\"\", \"\", $E30*input!M53)","v":""},{"$f":"IF($E30=\"\", \"\", $E30*input!N53)","v":""},{"$f":"IF($F30=\"\", \"\", $F30*input!L53)","v":""},{"$f":"IF($F30=\"\", \"\", $F30*input!M53)","v":""},{"$f":"IF($F30=\"\", \"\", $F30*input!N53)","v":""},{"$f":"IF($H30=\"\", \"\", $H30*input!L53)","v":""},{"$f":"IF($H30=\"\", \"\", $H30*input!M53)","v":""},{"$f":"IF($H30=\"\", \"\", $H30*input!N53)","v":""},{"$f":"IF($I30=\"\", \"\",$I30*input!L53)","v":""},{"$f":"IF($I30=\"\", \"\",$I30*input!M53)","v":""},{"$f":"IF($I30=\"\", \"\",$I30*input!N53)","v":""},{"$f":"IF($J30=\"\", \"\", $J30*input!L53)","v":""},{"$f":"IF($J30=\"\", \"\", $J30*input!M53)","v":""},{"$f":"IF($J30=\"\", \"\", $J30*input!N53)","v":""}]
[null,{"$f":"IF(input!B54=\"\", \"\", input!B54)","v":""},null,{"$f":"IF(input!H54=\"\",Beregning!C31*input!G54,Beregning!C31*input!I54)","v":0},{"$f":"IF(input!F54=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J54,Beregning!D31, 0, 1))","v":""},{"$f":"IF(input!F54= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E31,0, 1))","v":""},null,{"$f":"IF(E31= \"\", \"\", E31/input!$C$18)","v":""},{"$f":"IF(E31=\"\", \"\", E31/input!$C$23)","v":""},{"$f":"IF(E31=\"\", \"\", E31/input!$C$24)","v":""},null,{"$f":"IF($E31=\"\", \"\", $E31*input!L54)","v":""},{"$f":"IF($E31=\"\", \"\", $E31*input!M54)","v":""},{"$f":"IF($E31=\"\", \"\", $E31*input!N54)","v":""},{"$f":"IF($F31=\"\", \"\", $F31*input!L54)","v":""},{"$f":"IF($F31=\"\", \"\", $F31*input!M54)","v":""},{"$f":"IF($F31=\"\", \"\", $F31*input!N54)","v":""},{"$f":"IF($H31=\"\", \"\", $H31*input!L54)","v":""},{"$f":"IF($H31=\"\", \"\", $H31*input!M54)","v":""},{"$f":"IF($H31=\"\", \"\", $H31*input!N54)","v":""},{"$f":"IF($I31=\"\", \"\",$I31*input!L54)","v":""},{"$f":"IF($I31=\"\", \"\",$I31*input!M54)","v":""},{"$f":"IF($I31=\"\", \"\",$I31*input!N54)","v":""},{"$f":"IF($J31=\"\", \"\", $J31*input!L54)","v":""},{"$f":"IF($J31=\"\", \"\", $J31*input!M54)","v":""},{"$f":"IF($J31=\"\", \"\", $J31*input!N54)","v":""}]
[null,{"$f":"IF(input!B55=\"\", \"\", input!B55)","v":""},null,{"$f":"IF(input!H55=\"\",Beregning!C32*input!G55,Beregning!C32*input!I55)","v":0},{"$f":"IF(input!F55=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J55,Beregning!D32, 0, 1))","v":""},{"$f":"IF(input!F55= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E32,0, 1))","v":""},null,{"$f":"IF(E32= \"\", \"\", E32/input!$C$18)","v":""},{"$f":"IF(E32=\"\", \"\", E32/input!$C$23)","v":""},{"$f":"IF(E32=\"\", \"\", E32/input!$C$24)","v":""},null,{"$f":"IF($E32=\"\", \"\", $E32*input!L55)","v":""},{"$f":"IF($E32=\"\", \"\", $E32*input!M55)","v":""},{"$f":"IF($E32=\"\", \"\", $E32*input!N55)","v":""},{"$f":"IF($F32=\"\", \"\", $F32*input!L55)","v":""},{"$f":"IF($F32=\"\", \"\", $F32*input!M55)","v":""},{"$f":"IF($F32=\"\", \"\", $F32*input!N55)","v":""},{"$f":"IF($H32=\"\", \"\", $H32*input!L55)","v":""},{"$f":"IF($H32=\"\", \"\", $H32*input!M55)","v":""},{"$f":"IF($H32=\"\", \"\", $H32*input!N55)","v":""},{"$f":"IF($I32=\"\", \"\",$I32*input!L55)","v":""},{"$f":"IF($I32=\"\", \"\",$I32*input!M55)","v":""},{"$f":"IF($I32=\"\", \"\",$I32*input!N55)","v":""},{"$f":"IF($J32=\"\", \"\", $J32*input!L55)","v":""},{"$f":"IF($J32=\"\", \"\", $J32*input!M55)","v":""},{"$f":"IF($J32=\"\", \"\", $J32*input!N55)","v":""}]
[null,{"$f":"IF(input!B56=\"\", \"\", input!B56)","v":"Drift af indsats"},null,null,{"$f":"SUM(E34:E48)","v":4529547.2489915388},{"$f":"SUM(F34:F48)","v":13072702.193465233},null,{"$f":"SUM(H34:H48)","v":41177.702263559433},{"$f":"SUM(I34:I48)","v":41177.702263559433},{"$f":"SUM(J34:J48)","v":41177.702263559433},null,{"$f":"SUM(L34:L48)","v":4529547.2489915388},{"$f":"SUM(M34:M48)","v":0},{"$f":"SUM(N34:N48)","v":0},{"$f":"SUM(O34:O48)","v":13072702.193465233},{"$f":"SUM(P34:P48)","v":0},0,{"$f":"SUM(R34:R48)","v":41177.702263559433},0,0,{"$f":"SUM(U34:U48)","v":41177.702263559433},0,0,{"$f":"SUM(X34:X48)","v":41177.702263559433},0,0]
[null,{"$f":"IF(input!B57=\"\", \"\", input!B57)","v":""},null,{"$f":"IF(input!H57=\"\",Beregning!C34*input!G57,Beregning!C34*input!I57)","v":0},{"$f":"IF(input!F57=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J57,Beregning!D34, 0, 1))","v":""},{"$f":"IF(input!F57= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E34,0, 1))","v":""},null,{"$f":"IF(E34= \"\", \"\", E34/input!$C$18)","v":""},{"$f":"IF(E34=\"\", \"\", E34/input!$C$23)","v":""},{"$f":"IF(E34=\"\", \"\", E34/input!$C$24)","v":""},null,{"$f":"IF($E34=\"\", \"\", $E34*input!L57)","v":""},{"$f":"IF($E34=\"\", \"\", $E34*input!M57)","v":""},{"$f":"IF($E34=\"\", \"\", $E34*input!N57)","v":""},{"$f":"IF($F34=\"\", \"\", $F34*input!L57)","v":""},{"$f":"IF($F34=\"\", \"\", $F34*input!M57)","v":""},{"$f":"IF($F34=\"\", \"\", $F34*input!N57)","v":""},{"$f":"IF($H34=\"\", \"\", $H34*input!L57)","v":""},{"$f":"IF($H34=\"\", \"\", $H34*input!M57)","v":""},{"$f":"IF($H34=\"\", \"\", $H34*input!N57)","v":""},{"$f":"IF($I34=\"\", \"\",$I34*input!L57)","v":""},{"$f":"IF($I34=\"\", \"\",$I34*input!M57)","v":""},{"$f":"IF($I34=\"\", \"\",$I34*input!N57)","v":""},{"$f":"IF($J34=\"\", \"\", $J34*input!L57)","v":""},{"$f":"IF($J34=\"\", \"\", $J34*input!M57)","v":""},{"$f":"IF($J34=\"\", \"\", $J34*input!N57)","v":""}]
[null,{"$f":"IF(input!B58=\"\", \"\", input!B58)","v":""},null,{"$f":"IF(input!H58=\"\",Beregning!C35*input!G58,Beregning!C35*input!I58)","v":0},{"$f":"IF(input!F58=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J58,Beregning!D35, 0, 1))","v":""},{"$f":"IF(input!F58= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E35,0, 1))","v":""},null,{"$f":"IF(E35= \"\", \"\", E35/input!$C$18)","v":""},{"$f":"IF(E35=\"\", \"\", E35/input!$C$23)","v":""},{"$f":"IF(E35=\"\", \"\", E35/input!$C$24)","v":""},null,{"$f":"IF($E35=\"\", \"\", $E35*input!L58)","v":""},{"$f":"IF($E35=\"\", \"\", $E35*input!M58)","v":""},{"$f":"IF($E35=\"\", \"\", $E35*input!N58)","v":""},{"$f":"IF($F35=\"\", \"\", $F35*input!L58)","v":""},{"$f":"IF($F35=\"\", \"\", $F35*input!M58)","v":""},{"$f":"IF($F35=\"\", \"\", $F35*input!N58)","v":""},{"$f":"IF($H35=\"\", \"\", $H35*input!L58)","v":""},{"$f":"IF($H35=\"\", \"\", $H35*input!M58)","v":""},{"$f":"IF($H35=\"\", \"\", $H35*input!N58)","v":""},{"$f":"IF($I35=\"\", \"\",$I35*input!L58)","v":""},{"$f":"IF($I35=\"\", \"\",$I35*input!M58)","v":""},{"$f":"IF($I35=\"\", \"\",$I35*input!N58)","v":""},{"$f":"IF($J35=\"\", \"\", $J35*input!L58)","v":""},{"$f":"IF($J35=\"\", \"\", $J35*input!M58)","v":""},{"$f":"IF($J35=\"\", \"\", $J35*input!N58)","v":""}]
[null,{"$f":"IF(input!B59=\"\", \"\", input!B59)","v":"Løn  til medarbejdertype 1 "},1,{"$f":"IF(input!H59=\"\",Beregning!C36*input!G59,Beregning!C36*input!I59)","v":647478.70722857013},{"$f":"IF(input!F59=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J59,Beregning!D36, 0, 1))","v":647478.70722857001},{"$f":"IF(input!F59= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E36,0, 1))","v":1868684.8488209182},null,{"$f":"IF(E36= \"\", \"\", E36/input!$C$18)","v":5886.1700657142728},{"$f":"IF(E36=\"\", \"\", E36/input!$C$23)","v":5886.1700657142728},{"$f":"IF(E36=\"\", \"\", E36/input!$C$24)","v":5886.1700657142728},null,{"$f":"IF($E36=\"\", \"\", $E36*input!L59)","v":647478.70722857001},{"$f":"IF($E36=\"\", \"\", $E36*input!M59)","v":0},{"$f":"IF($E36=\"\", \"\", $E36*input!N59)","v":0},{"$f":"IF($F36=\"\", \"\", $F36*input!L59)","v":1868684.8488209182},{"$f":"IF($F36=\"\", \"\", $F36*input!M59)","v":0},{"$f":"IF($F36=\"\", \"\", $F36*input!N59)","v":0},{"$f":"IF($H36=\"\", \"\", $H36*input!L59)","v":5886.1700657142728},{"$f":"IF($H36=\"\", \"\", $H36*input!M59)","v":0},{"$f":"IF($H36=\"\", \"\", $H36*input!N59)","v":0},{"$f":"IF($I36=\"\", \"\",$I36*input!L59)","v":5886.1700657142728},{"$f":"IF($I36=\"\", \"\",$I36*input!M59)","v":0},{"$f":"IF($I36=\"\", \"\",$I36*input!N59)","v":0},{"$f":"IF($J36=\"\", \"\", $J36*input!L59)","v":5886.1700657142728},{"$f":"IF($J36=\"\", \"\", $J36*input!M59)","v":0},{"$f":"IF($J36=\"\", \"\", $J36*input!N59)","v":0}]
[null,{"$f":"IF(input!B60=\"\", \"\", input!B60)","v":"Løn  til medarbejdertype 2"},1,{"$f":"IF(input!H60=\"\",Beregning!C37*input!G60,Beregning!C37*input!I60)","v":475577.39738267387},{"$f":"IF(input!F60=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J60,Beregning!D37, 0, 1))","v":475577.39738267381},{"$f":"IF(input!F60= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E37,0, 1))","v":1372561.3939254396},null,{"$f":"IF(E37= \"\", \"\", E37/input!$C$18)","v":4323.4308852970344},{"$f":"IF(E37=\"\", \"\", E37/input!$C$23)","v":4323.4308852970344},{"$f":"IF(E37=\"\", \"\", E37/input!$C$24)","v":4323.4308852970344},null,{"$f":"IF($E37=\"\", \"\", $E37*input!L60)","v":475577.39738267381},{"$f":"IF($E37=\"\", \"\", $E37*input!M60)","v":0},{"$f":"IF($E37=\"\", \"\", $E37*input!N60)","v":0},{"$f":"IF($F37=\"\", \"\", $F37*input!L60)","v":1372561.3939254396},{"$f":"IF($F37=\"\", \"\", $F37*input!M60)","v":0},{"$f":"IF($F37=\"\", \"\", $F37*input!N60)","v":0},{"$f":"IF($H37=\"\", \"\", $H37*input!L60)","v":4323.4308852970344},{"$f":"IF($H37=\"\", \"\", $H37*input!M60)","v":0},{"$f":"IF($H37=\"\", \"\", $H37*input!N60)","v":0},{"$f":"IF($I37=\"\", \"\",$I37*input!L60)","v":4323.4308852970344},{"$f":"IF($I37=\"\", \"\",$I37*input!M60)","v":0},{"$f":"IF($I37=\"\", \"\",$I37*input!N60)","v":0},{"$f":"IF($J37=\"\", \"\", $J37*input!L60)","v":4323.4308852970344},{"$f":"IF($J37=\"\", \"\", $J37*input!M60)","v":0},{"$f":"IF($J37=\"\", \"\", $J37*input!N60)","v":0}]
[null,{"$f":"IF(input!B61=\"\", \"\", input!B61)","v":"Løn  til medarbejdertype 3 "},3,{"$f":"IF(input!H61=\"\",Beregning!C38*input!G61,Beregning!C38*input!I61)","v":1567435.2138438993},{"$f":"IF(input!F61=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J61,Beregning!D38, 0, 1))","v":1567435.2138438993},{"$f":"IF(input!F61= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E38,0, 1))","v":4523766.4233867591},null,{"$f":"IF(E38= \"\", \"\", E38/input!$C$18)","v":14249.41103494454},{"$f":"IF(E38=\"\", \"\", E38/input!$C$23)","v":14249.41103494454},{"$f":"IF(E38=\"\", \"\", E38/input!$C$24)","v":14249.41103494454},null,{"$f":"IF($E38=\"\", \"\", $E38*input!L61)","v":1567435.2138438993},{"$f":"IF($E38=\"\", \"\", $E38*input!M61)","v":0},{"$f":"IF($E38=\"\", \"\", $E38*input!N61)","v":0},{"$f":"IF($F38=\"\", \"\", $F38*input!L61)","v":4523766.4233867591},{"$f":"IF($F38=\"\", \"\", $F38*input!M61)","v":0},{"$f":"IF($F38=\"\", \"\", $F38*input!N61)","v":0},{"$f":"IF($H38=\"\", \"\", $H38*input!L61)","v":14249.41103494454},{"$f":"IF($H38=\"\", \"\", $H38*input!M61)","v":0},{"$f":"IF($H38=\"\", \"\", $H38*input!N61)","v":0},{"$f":"IF($I38=\"\", \"\",$I38*input!L61)","v":14249.41103494454},{"$f":"IF($I38=\"\", \"\",$I38*input!M61)","v":0},{"$f":"IF($I38=\"\", \"\",$I38*input!N61)","v":0},{"$f":"IF($J38=\"\", \"\", $J38*input!L61)","v":14249.41103494454},{"$f":"IF($J38=\"\", \"\", $J38*input!M61)","v":0},{"$f":"IF($J38=\"\", \"\", $J38*input!N61)","v":0}]
[null,{"$f":"IF(input!B62=\"\", \"\", input!B62)","v":"Løn  til medarbejdertype 4"},1.5,{"$f":"IF(input!H62=\"\",Beregning!C39*input!G62,Beregning!C39*input!I62)","v":789224.14026856283},{"$f":"IF(input!F62=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J62,Beregning!D39, 0, 1))","v":789224.14026856283},{"$f":"IF(input!F62= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E39,0, 1))","v":2277775.588260306},null,{"$f":"IF(E39= \"\", \"\", E39/input!$C$18)","v":7174.7649115323893},{"$f":"IF(E39=\"\", \"\", E39/input!$C$23)","v":7174.7649115323893},{"$f":"IF(E39=\"\", \"\", E39/input!$C$24)","v":7174.7649115323893},null,{"$f":"IF($E39=\"\", \"\", $E39*input!L62)","v":789224.14026856283},{"$f":"IF($E39=\"\", \"\", $E39*input!M62)","v":0},{"$f":"IF($E39=\"\", \"\", $E39*input!N62)","v":0},{"$f":"IF($F39=\"\", \"\", $F39*input!L62)","v":2277775.588260306},{"$f":"IF($F39=\"\", \"\", $F39*input!M62)","v":0},{"$f":"IF($F39=\"\", \"\", $F39*input!N62)","v":0},{"$f":"IF($H39=\"\", \"\", $H39*input!L62)","v":7174.7649115323893},{"$f":"IF($H39=\"\", \"\", $H39*input!M62)","v":0},{"$f":"IF($H39=\"\", \"\", $H39*input!N62)","v":0},{"$f":"IF($I39=\"\", \"\",$I39*input!L62)","v":7174.7649115323893},{"$f":"IF($I39=\"\", \"\",$I39*input!M62)","v":0},{"$f":"IF($I39=\"\", \"\",$I39*input!N62)","v":0},{"$f":"IF($J39=\"\", \"\", $J39*input!L62)","v":7174.7649115323893},{"$f":"IF($J39=\"\", \"\", $J39*input!M62)","v":0},{"$f":"IF($J39=\"\", \"\", $J39*input!N62)","v":0}]
[null,{"$f":"IF(input!B63=\"\", \"\", input!B63)","v":"Løn  til medarbejdertype 5"},0.5,{"$f":"IF(input!H63=\"\",Beregning!C40*input!G63,Beregning!C40*input!I63)","v":261239.20230731653},{"$f":"IF(input!F63=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J63,Beregning!D40, 0, 1))","v":261239.20230731653},{"$f":"IF(input!F63= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E40,0, 1))","v":753961.07056445989},null,{"$f":"IF(E40= \"\", \"\", E40/input!$C$18)","v":2374.9018391574232},{"$f":"IF(E40=\"\", \"\", E40/input!$C$23)","v":2374.9018391574232},{"$f":"IF(E40=\"\", \"\", E40/input!$C$24)","v":2374.9018391574232},null,{"$f":"IF($E40=\"\", \"\", $E40*input!L63)","v":261239.20230731653},{"$f":"IF($E40=\"\", \"\", $E40*input!M63)","v":0},{"$f":"IF($E40=\"\", \"\", $E40*input!N63)","v":0},{"$f":"IF($F40=\"\", \"\", $F40*input!L63)","v":753961.07056445989},{"$f":"IF($F40=\"\", \"\", $F40*input!M63)","v":0},{"$f":"IF($F40=\"\", \"\", $F40*input!N63)","v":0},{"$f":"IF($H40=\"\", \"\", $H40*input!L63)","v":2374.9018391574232},{"$f":"IF($H40=\"\", \"\", $H40*input!M63)","v":0},{"$f":"IF($H40=\"\", \"\", $H40*input!N63)","v":0},{"$f":"IF($I40=\"\", \"\",$I40*input!L63)","v":2374.9018391574232},{"$f":"IF($I40=\"\", \"\",$I40*input!M63)","v":0},{"$f":"IF($I40=\"\", \"\",$I40*input!N63)","v":0},{"$f":"IF($J40=\"\", \"\", $J40*input!L63)","v":2374.9018391574232},{"$f":"IF($J40=\"\", \"\", $J40*input!M63)","v":0},{"$f":"IF($J40=\"\", \"\", $J40*input!N63)","v":0}]
[null,{"$f":"IF(input!B64=\"\", \"\", input!B64)","v":"Løn  til medarbejdertype 6"},0.5,{"$f":"IF(input!H64=\"\",Beregning!C41*input!G64,Beregning!C41*input!I64)","v":319273.38565319992},{"$f":"IF(input!F64=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J64,Beregning!D41, 0, 1))","v":319273.38565319992},{"$f":"IF(input!F64= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E41,0, 1))","v":921453.21806123282},null,{"$f":"IF(E41= \"\", \"\", E41/input!$C$18)","v":2902.4853241199994},{"$f":"IF(E41=\"\", \"\", E41/input!$C$23)","v":2902.4853241199994},{"$f":"IF(E41=\"\", \"\", E41/input!$C$24)","v":2902.4853241199994},null,{"$f":"IF($E41=\"\", \"\", $E41*input!L64)","v":319273.38565319992},{"$f":"IF($E41=\"\", \"\", $E41*input!M64)","v":0},{"$f":"IF($E41=\"\", \"\", $E41*input!N64)","v":0},{"$f":"IF($F41=\"\", \"\", $F41*input!L64)","v":921453.21806123282},{"$f":"IF($F41=\"\", \"\", $F41*input!M64)","v":0},{"$f":"IF($F41=\"\", \"\", $F41*input!N64)","v":0},{"$f":"IF($H41=\"\", \"\", $H41*input!L64)","v":2902.4853241199994},{"$f":"IF($H41=\"\", \"\", $H41*input!M64)","v":0},{"$f":"IF($H41=\"\", \"\", $H41*input!N64)","v":0},{"$f":"IF($I41=\"\", \"\",$I41*input!L64)","v":2902.4853241199994},{"$f":"IF($I41=\"\", \"\",$I41*input!M64)","v":0},{"$f":"IF($I41=\"\", \"\",$I41*input!N64)","v":0},{"$f":"IF($J41=\"\", \"\", $J41*input!L64)","v":2902.4853241199994},{"$f":"IF($J41=\"\", \"\", $J41*input!M64)","v":0},{"$f":"IF($J41=\"\", \"\", $J41*input!N64)","v":0}]
[null,{"$f":"IF(input!B65=\"\", \"\", input!B65)","v":"Løn  til medarbejdertype 7"},0.5,{"$f":"IF(input!H65=\"\",Beregning!C42*input!G65,Beregning!C42*input!I65)","v":261239.20230731653},{"$f":"IF(input!F65=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J65,Beregning!D42, 0, 1))","v":261239.20230731653},{"$f":"IF(input!F65= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E42,0, 1))","v":753961.07056445989},null,{"$f":"IF(E42= \"\", \"\", E42/input!$C$18)","v":2374.9018391574232},{"$f":"IF(E42=\"\", \"\", E42/input!$C$23)","v":2374.9018391574232},{"$f":"IF(E42=\"\", \"\", E42/input!$C$24)","v":2374.9018391574232},null,{"$f":"IF($E42=\"\", \"\", $E42*input!L65)","v":261239.20230731653},{"$f":"IF($E42=\"\", \"\", $E42*input!M65)","v":0},{"$f":"IF($E42=\"\", \"\", $E42*input!N65)","v":0},{"$f":"IF($F42=\"\", \"\", $F42*input!L65)","v":753961.07056445989},{"$f":"IF($F42=\"\", \"\", $F42*input!M65)","v":0},{"$f":"IF($F42=\"\", \"\", $F42*input!N65)","v":0},{"$f":"IF($H42=\"\", \"\", $H42*input!L65)","v":2374.9018391574232},{"$f":"IF($H42=\"\", \"\", $H42*input!M65)","v":0},{"$f":"IF($H42=\"\", \"\", $H42*input!N65)","v":0},{"$f":"IF($I42=\"\", \"\",$I42*input!L65)","v":2374.9018391574232},{"$f":"IF($I42=\"\", \"\",$I42*input!M65)","v":0},{"$f":"IF($I42=\"\", \"\",$I42*input!N65)","v":0},{"$f":"IF($J42=\"\", \"\", $J42*input!L65)","v":2374.9018391574232},{"$f":"IF($J42=\"\", \"\", $J42*input!M65)","v":0},{"$f":"IF($J42=\"\", \"\", $J42*input!N65)","v":0}]
[null,{"$f":"IF(input!B66=\"\", \"\", input!B66)","v":"Løn  til medarbejdertype 8"},0.5,{"$f":"IF(input!H66=\"\",Beregning!C43*input!G66,Beregning!C43*input!I66)","v":208080},{"$f":"IF(input!F66=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J66,Beregning!D43, 0, 1))","v":208080},{"$f":"IF(input!F66= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E43,0, 1))","v":600538.57988165715},null,{"$f":"IF(E43= \"\", \"\", E43/input!$C$18)","v":1891.6363636363637},{"$f":"IF(E43=\"\", \"\", E43/input!$C$23)","v":1891.6363636363637},{"$f":"IF(E43=\"\", \"\", E43/input!$C$24)","v":1891.6363636363637},null,{"$f":"IF($E43=\"\", \"\", $E43*input!L66)","v":208080},{"$f":"IF($E43=\"\", \"\", $E43*input!M66)","v":0},{"$f":"IF($E43=\"\", \"\", $E43*input!N66)","v":0},{"$f":"IF($F43=\"\", \"\", $F43*input!L66)","v":600538.57988165715},{"$f":"IF($F43=\"\", \"\", $F43*input!M66)","v":0},{"$f":"IF($F43=\"\", \"\", $F43*input!N66)","v":0},{"$f":"IF($H43=\"\", \"\", $H43*input!L66)","v":1891.6363636363637},{"$f":"IF($H43=\"\", \"\", $H43*input!M66)","v":0},{"$f":"IF($H43=\"\", \"\", $H43*input!N66)","v":0},{"$f":"IF($I43=\"\", \"\",$I43*input!L66)","v":1891.6363636363637},{"$f":"IF($I43=\"\", \"\",$I43*input!M66)","v":0},{"$f":"IF($I43=\"\", \"\",$I43*input!N66)","v":0},{"$f":"IF($J43=\"\", \"\", $J43*input!L66)","v":1891.6363636363637},{"$f":"IF($J43=\"\", \"\", $J43*input!M66)","v":0},{"$f":"IF($J43=\"\", \"\", $J43*input!N66)","v":0}]
[null,{"$f":"IF(input!B67=\"\", \"\", input!B67)","v":""},null,{"$f":"IF(input!H67=\"\",Beregning!C44*input!G67,Beregning!C44*input!I67)","v":0},{"$f":"IF(input!F67=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J67,Beregning!D44, 0, 1))","v":""},{"$f":"IF(input!F67= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E44,0, 1))","v":""},null,{"$f":"IF(E44= \"\", \"\", E44/input!$C$18)","v":""},{"$f":"IF(E44=\"\", \"\", E44/input!$C$23)","v":""},{"$f":"IF(E44=\"\", \"\", E44/input!$C$24)","v":""},null,{"$f":"IF($E44=\"\", \"\", $E44*input!L67)","v":""},{"$f":"IF($E44=\"\", \"\", $E44*input!M67)","v":""},{"$f":"IF($E44=\"\", \"\", $E44*input!N67)","v":""},{"$f":"IF($F44=\"\", \"\", $F44*input!L67)","v":""},{"$f":"IF($F44=\"\", \"\", $F44*input!M67)","v":""},{"$f":"IF($F44=\"\", \"\", $F44*input!N67)","v":""},{"$f":"IF($H44=\"\", \"\", $H44*input!L67)","v":""},{"$f":"IF($H44=\"\", \"\", $H44*input!M67)","v":""},{"$f":"IF($H44=\"\", \"\", $H44*input!N67)","v":""},{"$f":"IF($I44=\"\", \"\",$I44*input!L67)","v":""},{"$f":"IF($I44=\"\", \"\",$I44*input!M67)","v":""},{"$f":"IF($I44=\"\", \"\",$I44*input!N67)","v":""},{"$f":"IF($J44=\"\", \"\", $J44*input!L67)","v":""},{"$f":"IF($J44=\"\", \"\", $J44*input!M67)","v":""},{"$f":"IF($J44=\"\", \"\", $J44*input!N67)","v":""}]
[null,{"$f":"IF(input!B68=\"\", \"\", input!B68)","v":""},null,{"$f":"IF(input!H68=\"\",Beregning!C45*input!G68,Beregning!C45*input!I68)","v":0},{"$f":"IF(input!F68=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J68,Beregning!D45, 0, 1))","v":""},{"$f":"IF(input!F68= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E45,0, 1))","v":""},null,{"$f":"IF(E45= \"\", \"\", E45/input!$C$18)","v":""},{"$f":"IF(E45=\"\", \"\", E45/input!$C$23)","v":""},{"$f":"IF(E45=\"\", \"\", E45/input!$C$24)","v":""},null,{"$f":"IF($E45=\"\", \"\", $E45*input!L68)","v":""},{"$f":"IF($E45=\"\", \"\", $E45*input!M68)","v":""},{"$f":"IF($E45=\"\", \"\", $E45*input!N68)","v":""},{"$f":"IF($F45=\"\", \"\", $F45*input!L68)","v":""},{"$f":"IF($F45=\"\", \"\", $F45*input!M68)","v":""},{"$f":"IF($F45=\"\", \"\", $F45*input!N68)","v":""},{"$f":"IF($H45=\"\", \"\", $H45*input!L68)","v":""},{"$f":"IF($H45=\"\", \"\", $H45*input!M68)","v":""},{"$f":"IF($H45=\"\", \"\", $H45*input!N68)","v":""},{"$f":"IF($I45=\"\", \"\",$I45*input!L68)","v":""},{"$f":"IF($I45=\"\", \"\",$I45*input!M68)","v":""},{"$f":"IF($I45=\"\", \"\",$I45*input!N68)","v":""},{"$f":"IF($J45=\"\", \"\", $J45*input!L68)","v":""},{"$f":"IF($J45=\"\", \"\", $J45*input!M68)","v":""},{"$f":"IF($J45=\"\", \"\", $J45*input!N68)","v":""}]
[null,{"$f":"IF(input!B69=\"\", \"\", input!B69)","v":""},null,{"$f":"IF(input!H69=\"\",Beregning!C46*input!G69,Beregning!C46*input!I69)","v":0},{"$f":"IF(input!F69=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J69,Beregning!D46, 0, 1))","v":""},{"$f":"IF(input!F69= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E46,0, 1))","v":""},null,{"$f":"IF(E46= \"\", \"\", E46/input!$C$18)","v":""},{"$f":"IF(E46=\"\", \"\", E46/input!$C$23)","v":""},{"$f":"IF(E46=\"\", \"\", E46/input!$C$24)","v":""},null,{"$f":"IF($E46=\"\", \"\", $E46*input!L69)","v":""},{"$f":"IF($E46=\"\", \"\", $E46*input!M69)","v":""},{"$f":"IF($E46=\"\", \"\", $E46*input!N69)","v":""},{"$f":"IF($F46=\"\", \"\", $F46*input!L69)","v":""},{"$f":"IF($F46=\"\", \"\", $F46*input!M69)","v":""},{"$f":"IF($F46=\"\", \"\", $F46*input!N69)","v":""},{"$f":"IF($H46=\"\", \"\", $H46*input!L69)","v":""},{"$f":"IF($H46=\"\", \"\", $H46*input!M69)","v":""},{"$f":"IF($H46=\"\", \"\", $H46*input!N69)","v":""},{"$f":"IF($I46=\"\", \"\",$I46*input!L69)","v":""},{"$f":"IF($I46=\"\", \"\",$I46*input!M69)","v":""},{"$f":"IF($I46=\"\", \"\",$I46*input!N69)","v":""},{"$f":"IF($J46=\"\", \"\", $J46*input!L69)","v":""},{"$f":"IF($J46=\"\", \"\", $J46*input!M69)","v":""},{"$f":"IF($J46=\"\", \"\", $J46*input!N69)","v":""}]
[null,{"$f":"IF(input!B70=\"\", \"\", input!B70)","v":""},null,{"$f":"IF(input!H70=\"\",Beregning!C47*input!G70,Beregning!C47*input!I70)","v":0},{"$f":"IF(input!F70=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J70,Beregning!D47, 0, 1))","v":""},{"$f":"IF(input!F70= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E47,0, 1))","v":""},null,{"$f":"IF(E47= \"\", \"\", E47/input!$C$18)","v":""},{"$f":"IF(E47=\"\", \"\", E47/input!$C$23)","v":""},{"$f":"IF(E47=\"\", \"\", E47/input!$C$24)","v":""},null,{"$f":"IF($E47=\"\", \"\", $E47*input!L70)","v":""},{"$f":"IF($E47=\"\", \"\", $E47*input!M70)","v":""},{"$f":"IF($E47=\"\", \"\", $E47*input!N70)","v":""},{"$f":"IF($F47=\"\", \"\", $F47*input!L70)","v":""},{"$f":"IF($F47=\"\", \"\", $F47*input!M70)","v":""},{"$f":"IF($F47=\"\", \"\", $F47*input!N70)","v":""},{"$f":"IF($H47=\"\", \"\", $H47*input!L70)","v":""},{"$f":"IF($H47=\"\", \"\", $H47*input!M70)","v":""},{"$f":"IF($H47=\"\", \"\", $H47*input!N70)","v":""},{"$f":"IF($I47=\"\", \"\",$I47*input!L70)","v":""},{"$f":"IF($I47=\"\", \"\",$I47*input!M70)","v":""},{"$f":"IF($I47=\"\", \"\",$I47*input!N70)","v":""},{"$f":"IF($J47=\"\", \"\", $J47*input!L70)","v":""},{"$f":"IF($J47=\"\", \"\", $J47*input!M70)","v":""},{"$f":"IF($J47=\"\", \"\", $J47*input!N70)","v":""}]
[null,{"$f":"IF(input!B71=\"\", \"\", input!B71)","v":""},null,{"$f":"IF(input!H71=\"\",Beregning!C48*input!G71,Beregning!C48*input!I71)","v":0},{"$f":"IF(input!F71=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J71,Beregning!D48, 0, 1))","v":""},{"$f":"IF(input!F71= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E48,0, 1))","v":""},null,{"$f":"IF(E48= \"\", \"\", E48/input!$C$18)","v":""},{"$f":"IF(E48=\"\", \"\", E48/input!$C$23)","v":""},{"$f":"IF(E48=\"\", \"\", E48/input!$C$24)","v":""},null,{"$f":"IF($E48=\"\", \"\", $E48*input!L71)","v":""},{"$f":"IF($E48=\"\", \"\", $E48*input!M71)","v":""},{"$f":"IF($E48=\"\", \"\", $E48*input!N71)","v":""},{"$f":"IF($F48=\"\", \"\", $F48*input!L71)","v":""},{"$f":"IF($F48=\"\", \"\", $F48*input!M71)","v":""},{"$f":"IF($F48=\"\", \"\", $F48*input!N71)","v":""},{"$f":"IF($H48=\"\", \"\", $H48*input!L71)","v":""},{"$f":"IF($H48=\"\", \"\", $H48*input!M71)","v":""},{"$f":"IF($H48=\"\", \"\", $H48*input!N71)","v":""},{"$f":"IF($I48=\"\", \"\",$I48*input!L71)","v":""},{"$f":"IF($I48=\"\", \"\",$I48*input!M71)","v":""},{"$f":"IF($I48=\"\", \"\",$I48*input!N71)","v":""},{"$f":"IF($J48=\"\", \"\", $J48*input!L71)","v":""},{"$f":"IF($J48=\"\", \"\", $J48*input!M71)","v":""},{"$f":"IF($J48=\"\", \"\", $J48*input!N71)","v":""}]
[null,{"$f":"IF(input!B72=\"\", \"\", input!B72)","v":"Investeringer  "},null,null,{"$f":"SUM(E50:E55)","v":0},{"$f":"SUM(F50:F55)","v":0},null,{"$f":"SUM(H50:H55)","v":0},{"$f":"SUM(I50:I55)","v":0},{"$f":"SUM(J50:J55)","v":0},null,{"$f":"SUM(L50:L55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(input!B73=\"\", \"\", input!B73)","v":""},null,{"$f":"IF(input!H73=\"\",Beregning!C50*input!G73,Beregning!C50*input!I73)","v":0},{"$f":"IF(input!F73=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J73,Beregning!D50, 0, 1))","v":""},{"$f":"IF(input!F73= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E50,0, 1))","v":""},null,{"$f":"IF(E50= \"\", \"\", E50/input!$C$18)","v":""},{"$f":"IF(E50=\"\", \"\", E50/input!$C$23)","v":""},{"$f":"IF(E50=\"\", \"\", E50/input!$C$24)","v":""},null,{"$f":"IF($E50=\"\", \"\", $E50*input!L73)","v":""},{"$f":"IF($E50=\"\", \"\", $E50*input!M73)","v":""},{"$f":"IF($E50=\"\", \"\", $E50*input!N73)","v":""},{"$f":"IF($F50=\"\", \"\", $F50*input!L73)","v":""},{"$f":"IF($F50=\"\", \"\", $F50*input!M73)","v":""},{"$f":"IF($F50=\"\", \"\", $F50*input!N73)","v":""},{"$f":"IF($H50=\"\", \"\", $H50*input!L73)","v":""},{"$f":"IF($H50=\"\", \"\", $H50*input!M73)","v":""},{"$f":"IF($H50=\"\", \"\", $H50*input!N73)","v":""},{"$f":"IF($I50=\"\", \"\",$I50*input!L73)","v":""},{"$f":"IF($I50=\"\", \"\",$I50*input!M73)","v":""},{"$f":"IF($I50=\"\", \"\",$I50*input!N73)","v":""},{"$f":"IF($J50=\"\", \"\", $J50*input!L73)","v":""},{"$f":"IF($J50=\"\", \"\", $J50*input!M73)","v":""},{"$f":"IF($J50=\"\", \"\", $J50*input!N73)","v":""}]
[null,{"$f":"IF(input!B74=\"\", \"\", input!B74)","v":""},null,{"$f":"IF(input!H74=\"\",Beregning!C51*input!G74,Beregning!C51*input!I74)","v":0},{"$f":"IF(input!F74=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J74,Beregning!D51, 0, 1))","v":""},{"$f":"IF(input!F74= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E51,0, 1))","v":""},null,{"$f":"IF(E51= \"\", \"\", E51/input!$C$18)","v":""},{"$f":"IF(E51=\"\", \"\", E51/input!$C$23)","v":""},{"$f":"IF(E51=\"\", \"\", E51/input!$C$24)","v":""},null,{"$f":"IF($E51=\"\", \"\", $E51*input!L74)","v":""},{"$f":"IF($E51=\"\", \"\", $E51*input!M74)","v":""},{"$f":"IF($E51=\"\", \"\", $E51*input!N74)","v":""},{"$f":"IF($F51=\"\", \"\", $F51*input!L74)","v":""},{"$f":"IF($F51=\"\", \"\", $F51*input!M74)","v":""},{"$f":"IF($F51=\"\", \"\", $F51*input!N74)","v":""},{"$f":"IF($H51=\"\", \"\", $H51*input!L74)","v":""},{"$f":"IF($H51=\"\", \"\", $H51*input!M74)","v":""},{"$f":"IF($H51=\"\", \"\", $H51*input!N74)","v":""},{"$f":"IF($I51=\"\", \"\",$I51*input!L74)","v":""},{"$f":"IF($I51=\"\", \"\",$I51*input!M74)","v":""},{"$f":"IF($I51=\"\", \"\",$I51*input!N74)","v":""},{"$f":"IF($J51=\"\", \"\", $J51*input!L74)","v":""},{"$f":"IF($J51=\"\", \"\", $J51*input!M74)","v":""},{"$f":"IF($J51=\"\", \"\", $J51*input!N74)","v":""}]
[null,{"$f":"IF(input!B75=\"\", \"\", input!B75)","v":""},null,{"$f":"IF(input!H75=\"\",Beregning!C52*input!G75,Beregning!C52*input!I75)","v":0},{"$f":"IF(input!F75=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J75,Beregning!D52, 0, 1))","v":""},{"$f":"IF(input!F75= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E52,0, 1))","v":""},null,{"$f":"IF(E52= \"\", \"\", E52/input!$C$18)","v":""},{"$f":"IF(E52=\"\", \"\", E52/input!$C$23)","v":""},{"$f":"IF(E52=\"\", \"\", E52/input!$C$24)","v":""},null,{"$f":"IF($E52=\"\", \"\", $E52*input!L75)","v":""},{"$f":"IF($E52=\"\", \"\", $E52*input!M75)","v":""},{"$f":"IF($E52=\"\", \"\", $E52*input!N75)","v":""},{"$f":"IF($F52=\"\", \"\", $F52*input!L75)","v":""},{"$f":"IF($F52=\"\", \"\", $F52*input!M75)","v":""},{"$f":"IF($F52=\"\", \"\", $F52*input!N75)","v":""},{"$f":"IF($H52=\"\", \"\", $H52*input!L75)","v":""},{"$f":"IF($H52=\"\", \"\", $H52*input!M75)","v":""},{"$f":"IF($H52=\"\", \"\", $H52*input!N75)","v":""},{"$f":"IF($I52=\"\", \"\",$I52*input!L75)","v":""},{"$f":"IF($I52=\"\", \"\",$I52*input!M75)","v":""},{"$f":"IF($I52=\"\", \"\",$I52*input!N75)","v":""},{"$f":"IF($J52=\"\", \"\", $J52*input!L75)","v":""},{"$f":"IF($J52=\"\", \"\", $J52*input!M75)","v":""},{"$f":"IF($J52=\"\", \"\", $J52*input!N75)","v":""}]
[null,{"$f":"IF(input!B76=\"\", \"\", input!B76)","v":""},null,{"$f":"IF(input!H76=\"\",Beregning!C53*input!G76,Beregning!C53*input!I76)","v":0},{"$f":"IF(input!F76=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J76,Beregning!D53, 0, 1))","v":""},{"$f":"IF(input!F76= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E53,0, 1))","v":""},null,{"$f":"IF(E53= \"\", \"\", E53/input!$C$18)","v":""},{"$f":"IF(E53=\"\", \"\", E53/input!$C$23)","v":""},{"$f":"IF(E53=\"\", \"\", E53/input!$C$24)","v":""},null,{"$f":"IF($E53=\"\", \"\", $E53*input!L76)","v":""},{"$f":"IF($E53=\"\", \"\", $E53*input!M76)","v":""},{"$f":"IF($E53=\"\", \"\", $E53*input!N76)","v":""},{"$f":"IF($F53=\"\", \"\", $F53*input!L76)","v":""},{"$f":"IF($F53=\"\", \"\", $F53*input!M76)","v":""},{"$f":"IF($F53=\"\", \"\", $F53*input!N76)","v":""},{"$f":"IF($H53=\"\", \"\", $H53*input!L76)","v":""},{"$f":"IF($H53=\"\", \"\", $H53*input!M76)","v":""},{"$f":"IF($H53=\"\", \"\", $H53*input!N76)","v":""},{"$f":"IF($I53=\"\", \"\",$I53*input!L76)","v":""},{"$f":"IF($I53=\"\", \"\",$I53*input!M76)","v":""},{"$f":"IF($I53=\"\", \"\",$I53*input!N76)","v":""},{"$f":"IF($J53=\"\", \"\", $J53*input!L76)","v":""},{"$f":"IF($J53=\"\", \"\", $J53*input!M76)","v":""},{"$f":"IF($J53=\"\", \"\", $J53*input!N76)","v":""}]
[null,{"$f":"IF(input!B77=\"\", \"\", input!B77)","v":""},null,{"$f":"IF(input!H77=\"\",Beregning!C54*input!G77,Beregning!C54*input!I77)","v":0},{"$f":"IF(input!F77=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J77,Beregning!D54, 0, 1))","v":""},{"$f":"IF(input!F77= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E54,0, 1))","v":""},null,{"$f":"IF(E54= \"\", \"\", E54/input!$C$18)","v":""},{"$f":"IF(E54=\"\", \"\", E54/input!$C$23)","v":""},{"$f":"IF(E54=\"\", \"\", E54/input!$C$24)","v":""},null,{"$f":"IF($E54=\"\", \"\", $E54*input!L77)","v":""},{"$f":"IF($E54=\"\", \"\", $E54*input!M77)","v":""},{"$f":"IF($E54=\"\", \"\", $E54*input!N77)","v":""},{"$f":"IF($F54=\"\", \"\", $F54*input!L77)","v":""},{"$f":"IF($F54=\"\", \"\", $F54*input!M77)","v":""},{"$f":"IF($F54=\"\", \"\", $F54*input!N77)","v":""},{"$f":"IF($H54=\"\", \"\", $H54*input!L77)","v":""},{"$f":"IF($H54=\"\", \"\", $H54*input!M77)","v":""},{"$f":"IF($H54=\"\", \"\", $H54*input!N77)","v":""},{"$f":"IF($I54=\"\", \"\",$I54*input!L77)","v":""},{"$f":"IF($I54=\"\", \"\",$I54*input!M77)","v":""},{"$f":"IF($I54=\"\", \"\",$I54*input!N77)","v":""},{"$f":"IF($J54=\"\", \"\", $J54*input!L77)","v":""},{"$f":"IF($J54=\"\", \"\", $J54*input!M77)","v":""},{"$f":"IF($J54=\"\", \"\", $J54*input!N77)","v":""}]
[null,{"$f":"IF(input!B78=\"\", \"\", input!B78)","v":""},null,{"$f":"IF(input!H78=\"\",Beregning!C55*input!G78,Beregning!C55*input!I78)","v":0},{"$f":"IF(input!F78=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J78,Beregning!D55, 0, 1))","v":""},{"$f":"IF(input!F78= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E55,0, 1))","v":""},null,{"$f":"IF(E55= \"\", \"\", E55/input!$C$18)","v":""},{"$f":"IF(E55=\"\", \"\", E55/input!$C$23)","v":""},{"$f":"IF(E55=\"\", \"\", E55/input!$C$24)","v":""},null,{"$f":"IF($E55=\"\", \"\", $E55*input!L78)","v":""},{"$f":"IF($E55=\"\", \"\", $E55*input!M78)","v":""},{"$f":"IF($E55=\"\", \"\", $E55*input!N78)","v":""},{"$f":"IF($F55=\"\", \"\", $F55*input!L78)","v":""},{"$f":"IF($F55=\"\", \"\", $F55*input!M78)","v":""},{"$f":"IF($F55=\"\", \"\", $F55*input!N78)","v":""},{"$f":"IF($H55=\"\", \"\", $H55*input!L78)","v":""},{"$f":"IF($H55=\"\", \"\", $H55*input!M78)","v":""},{"$f":"IF($H55=\"\", \"\", $H55*input!N78)","v":""},{"$f":"IF($I55=\"\", \"\",$I55*input!L78)","v":""},{"$f":"IF($I55=\"\", \"\",$I55*input!M78)","v":""},{"$f":"IF($I55=\"\", \"\",$I55*input!N78)","v":""},{"$f":"IF($J55=\"\", \"\", $J55*input!L78)","v":""},{"$f":"IF($J55=\"\", \"\", $J55*input!M78)","v":""},{"$f":"IF($J55=\"\", \"\", $J55*input!N78)","v":""},null,null,null,null,null,null,1]
[null,{"$f":"IF(input!B79=\"\", \"\", input!B79)","v":"Øvrige omkostninger"},null,null,{"$f":"SUM(E57:E66)","v":780771.94594594592},{"$f":"SUM(F57:F66)","v":2253381.7552374871},null,{"$f":"SUM(H57:H66)","v":7097.9267813267807},{"$f":"SUM(I57:I66)","v":7097.9267813267807},{"$f":"SUM(J57:J66)","v":7097.9267813267807},null,{"$f":"SUM(L57:L66)","v":780771.94594594592},{"$f":"SUM(M57:M66)","v":0},0,{"$f":"SUM(O57:O66)","v":2253381.7552374871},0,0,{"$f":"SUM(R57:R66)","v":7097.9267813267807},0,0,{"$f":"SUM(U57:U66)","v":7097.9267813267807},0,0,{"$f":"SUM(X57:X66)","v":7097.9267813267807},0,0]
[null,{"$f":"IF(input!B80=\"\", \"\", input!B80)","v":"Kontorhold, indretning husleje "},1,{"$f":"IF(input!H80=\"\",Beregning!C57*input!G80,Beregning!C57*input!I80)","v":655771.94594594592},{"$f":"IF(input!F80=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J80,Beregning!D57, 0, 1))","v":655771.94594594592},{"$f":"IF(input!F80= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E57,0, 1))","v":1892619.9209179603},null,{"$f":"IF(E57= \"\", \"\", E57/input!$C$18)","v":5961.5631449631446},{"$f":"IF(E57=\"\", \"\", E57/input!$C$23)","v":5961.5631449631446},{"$f":"IF(E57=\"\", \"\", E57/input!$C$24)","v":5961.5631449631446},null,{"$f":"IF($E57=\"\", \"\", $E57*input!L80)","v":655771.94594594592},{"$f":"IF($E57=\"\", \"\", $E57*input!M80)","v":0},{"$f":"IF($E57=\"\", \"\", $E57*input!N80)","v":0},{"$f":"IF($F57=\"\", \"\", $F57*input!L80)","v":1892619.9209179603},{"$f":"IF($F57=\"\", \"\", $F57*input!M80)","v":0},{"$f":"IF($F57=\"\", \"\", $F57*input!N80)","v":0},{"$f":"IF($H57=\"\", \"\", $H57*input!L80)","v":5961.5631449631446},{"$f":"IF($H57=\"\", \"\", $H57*input!M80)","v":0},{"$f":"IF($H57=\"\", \"\", $H57*input!N80)","v":0},{"$f":"IF($I57=\"\", \"\",$I57*input!L80)","v":5961.5631449631446},{"$f":"IF($I57=\"\", \"\",$I57*input!M80)","v":0},{"$f":"IF($I57=\"\", \"\",$I57*input!N80)","v":0},{"$f":"IF($J57=\"\", \"\", $J57*input!L80)","v":5961.5631449631446},{"$f":"IF($J57=\"\", \"\", $J57*input!M80)","v":0},{"$f":"IF($J57=\"\", \"\", $J57*input!N80)","v":0}]
[null,{"$f":"IF(input!B81=\"\", \"\", input!B81)","v":""},null,{"$f":"IF(input!H81=\"\",Beregning!C58*input!G81,Beregning!C58*input!I81)","v":0},{"$f":"IF(input!F81=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J81,Beregning!D58, 0, 1))","v":""},{"$f":"IF(input!F81= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E58,0, 1))","v":""},null,{"$f":"IF(E58= \"\", \"\", E58/input!$C$18)","v":""},{"$f":"IF(E58=\"\", \"\", E58/input!$C$23)","v":""},{"$f":"IF(E58=\"\", \"\", E58/input!$C$24)","v":""},null,{"$f":"IF($E58=\"\", \"\", $E58*input!L81)","v":""},{"$f":"IF($E58=\"\", \"\", $E58*input!M81)","v":""},{"$f":"IF($E58=\"\", \"\", $E58*input!N81)","v":""},{"$f":"IF($F58=\"\", \"\", $F58*input!L81)","v":""},{"$f":"IF($F58=\"\", \"\", $F58*input!M81)","v":""},{"$f":"IF($F58=\"\", \"\", $F58*input!N81)","v":""},{"$f":"IF($H58=\"\", \"\", $H58*input!L81)","v":""},{"$f":"IF($H58=\"\", \"\", $H58*input!M81)","v":""},{"$f":"IF($H58=\"\", \"\", $H58*input!N81)","v":""},{"$f":"IF($I58=\"\", \"\",$I58*input!L81)","v":""},{"$f":"IF($I58=\"\", \"\",$I58*input!M81)","v":""},{"$f":"IF($I58=\"\", \"\",$I58*input!N81)","v":""},{"$f":"IF($J58=\"\", \"\", $J58*input!L81)","v":""},{"$f":"IF($J58=\"\", \"\", $J58*input!M81)","v":""},{"$f":"IF($J58=\"\", \"\", $J58*input!N81)","v":""}]
[null,{"$f":"IF(input!B82=\"\", \"\", input!B82)","v":""},null,{"$f":"IF(input!H82=\"\",Beregning!C59*input!G82,Beregning!C59*input!I82)","v":0},{"$f":"IF(input!F82=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J82,Beregning!D59, 0, 1))","v":""},{"$f":"IF(input!F82= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E59,0, 1))","v":""},null,{"$f":"IF(E59= \"\", \"\", E59/input!$C$18)","v":""},{"$f":"IF(E59=\"\", \"\", E59/input!$C$23)","v":""},{"$f":"IF(E59=\"\", \"\", E59/input!$C$24)","v":""},null,{"$f":"IF($E59=\"\", \"\", $E59*input!L82)","v":""},{"$f":"IF($E59=\"\", \"\", $E59*input!M82)","v":""},{"$f":"IF($E59=\"\", \"\", $E59*input!N82)","v":""},{"$f":"IF($F59=\"\", \"\", $F59*input!L82)","v":""},{"$f":"IF($F59=\"\", \"\", $F59*input!M82)","v":""},{"$f":"IF($F59=\"\", \"\", $F59*input!N82)","v":""},{"$f":"IF($H59=\"\", \"\", $H59*input!L82)","v":""},{"$f":"IF($H59=\"\", \"\", $H59*input!M82)","v":""},{"$f":"IF($H59=\"\", \"\", $H59*input!N82)","v":""},{"$f":"IF($I59=\"\", \"\",$I59*input!L82)","v":""},{"$f":"IF($I59=\"\", \"\",$I59*input!M82)","v":""},{"$f":"IF($I59=\"\", \"\",$I59*input!N82)","v":""},{"$f":"IF($J59=\"\", \"\", $J59*input!L82)","v":""},{"$f":"IF($J59=\"\", \"\", $J59*input!M82)","v":""},{"$f":"IF($J59=\"\", \"\", $J59*input!N82)","v":""}]
[null,{"$f":"IF(input!B83=\"\", \"\", input!B83)","v":""},null,{"$f":"IF(input!H83=\"\",Beregning!C60*input!G83,Beregning!C60*input!I83)","v":0},{"$f":"IF(input!F83=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J83,Beregning!D60, 0, 1))","v":""},{"$f":"IF(input!F83= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E60,0, 1))","v":""},null,{"$f":"IF(E60= \"\", \"\", E60/input!$C$18)","v":""},{"$f":"IF(E60=\"\", \"\", E60/input!$C$23)","v":""},{"$f":"IF(E60=\"\", \"\", E60/input!$C$24)","v":""},null,{"$f":"IF($E60=\"\", \"\", $E60*input!L83)","v":""},{"$f":"IF($E60=\"\", \"\", $E60*input!M83)","v":""},{"$f":"IF($E60=\"\", \"\", $E60*input!N83)","v":""},{"$f":"IF($F60=\"\", \"\", $F60*input!L83)","v":""},{"$f":"IF($F60=\"\", \"\", $F60*input!M83)","v":""},{"$f":"IF($F60=\"\", \"\", $F60*input!N83)","v":""},{"$f":"IF($H60=\"\", \"\", $H60*input!L83)","v":""},{"$f":"IF($H60=\"\", \"\", $H60*input!M83)","v":""},{"$f":"IF($H60=\"\", \"\", $H60*input!N83)","v":""},{"$f":"IF($I60=\"\", \"\",$I60*input!L83)","v":""},{"$f":"IF($I60=\"\", \"\",$I60*input!M83)","v":""},{"$f":"IF($I60=\"\", \"\",$I60*input!N83)","v":""},{"$f":"IF($J60=\"\", \"\", $J60*input!L83)","v":""},{"$f":"IF($J60=\"\", \"\", $J60*input!M83)","v":""},{"$f":"IF($J60=\"\", \"\", $J60*input!N83)","v":""}]
[null,{"$f":"IF(input!B84=\"\", \"\", input!B84)","v":"Ydelser købt eksternt "},1,{"$f":"IF(input!H84=\"\",Beregning!C61*input!G84,Beregning!C61*input!I84)","v":125000},{"$f":"IF(input!F84=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J84,Beregning!D61, 0, 1))","v":125000},{"$f":"IF(input!F84= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E61,0, 1))","v":360761.83431952685},null,{"$f":"IF(E61= \"\", \"\", E61/input!$C$18)","v":1136.3636363636363},{"$f":"IF(E61=\"\", \"\", E61/input!$C$23)","v":1136.3636363636363},{"$f":"IF(E61=\"\", \"\", E61/input!$C$24)","v":1136.3636363636363},null,{"$f":"IF($E61=\"\", \"\", $E61*input!L84)","v":125000},{"$f":"IF($E61=\"\", \"\", $E61*input!M84)","v":0},{"$f":"IF($E61=\"\", \"\", $E61*input!N84)","v":0},{"$f":"IF($F61=\"\", \"\", $F61*input!L84)","v":360761.83431952685},{"$f":"IF($F61=\"\", \"\", $F61*input!M84)","v":0},{"$f":"IF($F61=\"\", \"\", $F61*input!N84)","v":0},{"$f":"IF($H61=\"\", \"\", $H61*input!L84)","v":1136.3636363636363},{"$f":"IF($H61=\"\", \"\", $H61*input!M84)","v":0},{"$f":"IF($H61=\"\", \"\", $H61*input!N84)","v":0},{"$f":"IF($I61=\"\", \"\",$I61*input!L84)","v":1136.3636363636363},{"$f":"IF($I61=\"\", \"\",$I61*input!M84)","v":0},{"$f":"IF($I61=\"\", \"\",$I61*input!N84)","v":0},{"$f":"IF($J61=\"\", \"\", $J61*input!L84)","v":1136.3636363636363},{"$f":"IF($J61=\"\", \"\", $J61*input!M84)","v":0},{"$f":"IF($J61=\"\", \"\", $J61*input!N84)","v":0}]
[]
[]
[]
[]
[null,{"$f":"IF(input!B89=\"\", \"\", input!B89)","v":""},null,{"$f":"IF(input!H89=\"\",Beregning!C66*input!G89,Beregning!C66*input!I89)","v":0},{"$f":"IF(input!F89=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J89,Beregning!D66, 0, 1))","v":""},{"$f":"IF(input!F89= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E66,0, 1))","v":""},null,{"$f":"IF(E66= \"\", \"\", E66/input!$C$18)","v":""},{"$f":"IF(E66=\"\", \"\", E66/input!$C$23)","v":""},{"$f":"IF(E66=\"\", \"\", E66/input!$C$24)","v":""},null,{"$f":"IF($E66=\"\", \"\", $E66*input!L89)","v":""},{"$f":"IF($E66=\"\", \"\", $E66*input!M89)","v":""},{"$f":"IF($E66=\"\", \"\", $E66*input!N89)","v":""},{"$f":"IF($F66=\"\", \"\", $F66*input!L89)","v":""},{"$f":"IF($F66=\"\", \"\", $F66*input!M89)","v":""},{"$f":"IF($F66=\"\", \"\", $F66*input!N89)","v":""},{"$f":"IF($H66=\"\", \"\", $H66*input!L89)","v":""},{"$f":"IF($H66=\"\", \"\", $H66*input!M89)","v":""},{"$f":"IF($H66=\"\", \"\", $H66*input!N89)","v":""},{"$f":"IF($I66=\"\", \"\",$I66*input!L89)","v":""},{"$f":"IF($I66=\"\", \"\",$I66*input!M89)","v":""},{"$f":"IF($I66=\"\", \"\",$I66*input!N89)","v":""},{"$f":"IF($J66=\"\", \"\", $J66*input!L89)","v":""},{"$f":"IF($J66=\"\", \"\", $J66*input!M89)","v":""},{"$f":"IF($J66=\"\", \"\", $J66*input!N89)","v":""}]
[null,{"$f":"IF(input!B90=\"\", \"\", input!B90)","v":"Tilskud"},null,null,{"$f":"SUM(E68:E71)","v":0},{"$f":"SUM(F68:F71)","v":0},null,{"$f":"SUM(H68:H71)","v":0},{"$f":"SUM(I68:I71)","v":0},{"$f":"SUM(J68:J71)","v":0},null,{"$f":"SUM(L68:L71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(input!B91=\"\", \"\", input!B91)","v":""},null,{"$f":"IF(input!H91=\"\",Beregning!C68*input!G91,Beregning!C68*input!I91)","v":0},{"$f":"IF(input!F91=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J91,Beregning!D68, 0, 1))","v":""},{"$f":"IF(input!F91= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E68,0, 1))","v":""},null,{"$f":"IF(E68= \"\", \"\", E68/input!$C$18)","v":""},{"$f":"IF(E68=\"\", \"\", E68/input!$C$23)","v":""},{"$f":"IF(E68=\"\", \"\", E68/input!$C$24)","v":""},null,{"$f":"IF($E68=\"\", \"\", $E68*input!L91)","v":""},{"$f":"IF($E68=\"\", \"\", $E68*input!M91)","v":""},{"$f":"IF($E68=\"\", \"\", $E68*input!N91)","v":""},{"$f":"IF($F68=\"\", \"\", $F68*input!L91)","v":""},{"$f":"IF($F68=\"\", \"\", $F68*input!M91)","v":""},{"$f":"IF($F68=\"\", \"\", $F68*input!N91)","v":""},{"$f":"IF($H68=\"\", \"\", $H68*input!L91)","v":""},{"$f":"IF($H68=\"\", \"\", $H68*input!M91)","v":""},{"$f":"IF($H68=\"\", \"\", $H68*input!N91)","v":""},{"$f":"IF($I68=\"\", \"\",$I68*input!L91)","v":""},{"$f":"IF($I68=\"\", \"\",$I68*input!M91)","v":""},{"$f":"IF($I68=\"\", \"\",$I68*input!N91)","v":""},{"$f":"IF($J68=\"\", \"\", $J68*input!L91)","v":""},{"$f":"IF($J68=\"\", \"\", $J68*input!M91)","v":""},{"$f":"IF($J68=\"\", \"\", $J68*input!N91)","v":""}]
[null,{"$f":"IF(input!B92=\"\", \"\", input!B92)","v":""},null,{"$f":"IF(input!H92=\"\",Beregning!C69*input!G92,Beregning!C69*input!I92)","v":0},{"$f":"IF(input!F92=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J92,Beregning!D69, 0, 1))","v":""},{"$f":"IF(input!F92= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E69,0, 1))","v":""},null,{"$f":"IF(E69= \"\", \"\", E69/input!$C$18)","v":""},{"$f":"IF(E69=\"\", \"\", E69/input!$C$23)","v":""},{"$f":"IF(E69=\"\", \"\", E69/input!$C$24)","v":""},null,{"$f":"IF($E69=\"\", \"\", $E69*input!L92)","v":""},{"$f":"IF($E69=\"\", \"\", $E69*input!M92)","v":""},{"$f":"IF($E69=\"\", \"\", $E69*input!N92)","v":""},{"$f":"IF($F69=\"\", \"\", $F69*input!L92)","v":""},{"$f":"IF($F69=\"\", \"\", $F69*input!M92)","v":""},{"$f":"IF($F69=\"\", \"\", $F69*input!N92)","v":""},{"$f":"IF($H69=\"\", \"\", $H69*input!L92)","v":""},{"$f":"IF($H69=\"\", \"\", $H69*input!M92)","v":""},{"$f":"IF($H69=\"\", \"\", $H69*input!N92)","v":""},{"$f":"IF($I69=\"\", \"\",$I69*input!L92)","v":""},{"$f":"IF($I69=\"\", \"\",$I69*input!M92)","v":""},{"$f":"IF($I69=\"\", \"\",$I69*input!N92)","v":""},{"$f":"IF($J69=\"\", \"\", $J69*input!L92)","v":""},{"$f":"IF($J69=\"\", \"\", $J69*input!M92)","v":""},{"$f":"IF($J69=\"\", \"\", $J69*input!N92)","v":""}]
[null,{"$f":"IF(input!B93=\"\", \"\", input!B93)","v":""},null,{"$f":"IF(input!H93=\"\",Beregning!C70*input!G93,Beregning!C70*input!I93)","v":0},{"$f":"IF(input!F93=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J93,Beregning!D70, 0, 1))","v":""},{"$f":"IF(input!F93= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E70,0, 1))","v":""},null,{"$f":"IF(E70= \"\", \"\", E70/input!$C$18)","v":""},{"$f":"IF(E70=\"\", \"\", E70/input!$C$23)","v":""},{"$f":"IF(E70=\"\", \"\", E70/input!$C$24)","v":""},null,{"$f":"IF($E70=\"\", \"\", $E70*input!L93)","v":""},{"$f":"IF($E70=\"\", \"\", $E70*input!M93)","v":""},{"$f":"IF($E70=\"\", \"\", $E70*input!N93)","v":""},{"$f":"IF($F70=\"\", \"\", $F70*input!L93)","v":""},{"$f":"IF($F70=\"\", \"\", $F70*input!M93)","v":""},{"$f":"IF($F70=\"\", \"\", $F70*input!N93)","v":""},{"$f":"IF($H70=\"\", \"\", $H70*input!L93)","v":""},{"$f":"IF($H70=\"\", \"\", $H70*input!M93)","v":""},{"$f":"IF($H70=\"\", \"\", $H70*input!N93)","v":""},{"$f":"IF($I70=\"\", \"\",$I70*input!L93)","v":""},{"$f":"IF($I70=\"\", \"\",$I70*input!M93)","v":""},{"$f":"IF($I70=\"\", \"\",$I70*input!N93)","v":""},{"$f":"IF($J70=\"\", \"\", $J70*input!L93)","v":""},{"$f":"IF($J70=\"\", \"\", $J70*input!M93)","v":""},{"$f":"IF($J70=\"\", \"\", $J70*input!N93)","v":""}]
[null,{"$f":"IF(input!B94=\"\", \"\", input!B94)","v":""},null,{"$f":"IF(input!H94=\"\",Beregning!C71*input!G94,Beregning!C71*input!I94)","v":0},{"$f":"IF(input!F94=\"\", \"\", -PMT(Enhedspriskatalog!$B$6,input!J94,Beregning!D71, 0, 1))","v":""},{"$f":"IF(input!F94= \"\", \"\", -PV(Enhedspriskatalog!$B$6, input!$C$16,Beregning!E71,0, 1))","v":""},null,{"$f":"IF(E71= \"\", \"\", E71/input!$C$18)","v":""},{"$f":"IF(E71=\"\", \"\", E71/input!$C$23)","v":""},{"$f":"IF(E71=\"\", \"\", E71/input!$C$24)","v":""},null,{"$f":"IF($E71=\"\", \"\", $E71*input!L94)","v":""},{"$f":"IF($E71=\"\", \"\", $E71*input!M94)","v":""},{"$f":"IF($E71=\"\", \"\", $E71*input!N94)","v":""},{"$f":"IF($F71=\"\", \"\", $F71*input!L94)","v":""},{"$f":"IF($F71=\"\", \"\", $F71*input!M94)","v":""},{"$f":"IF($F71=\"\", \"\", $F71*input!N94)","v":""},{"$f":"IF($H71=\"\", \"\", $H71*input!L94)","v":""},{"$f":"IF($H71=\"\", \"\", $H71*input!M94)","v":""},{"$f":"IF($H71=\"\", \"\", $H71*input!N94)","v":""},{"$f":"IF($I71=\"\", \"\",$I71*input!L94)","v":""},{"$f":"IF($I71=\"\", \"\",$I71*input!M94)","v":""},{"$f":"IF($I71=\"\", \"\",$I71*input!N94)","v":""},{"$f":"IF($J71=\"\", \"\", $J71*input!L94)","v":""},{"$f":"IF($J71=\"\", \"\", $J71*input!M94)","v":""},{"$f":"IF($J71=\"\", \"\", $J71*input!N94)","v":""}]
[null,{"$f":"IF(input!B95=\"\", \"\", input!B95)","v":"Total"},null,null,{"$f":"E13+E24+E33+E49+E56+E67","v":5565847.6060271449},{"$f":"F13+F24+F33+F49+F56+F67","v":16063563.135146402},null,{"$f":"H13+H24+H33+H49+H56+H67","v":50598.614600246765},{"$f":"I13+I24+I33+I49+I56+I67","v":50598.614600246765},{"$f":"J13+J24+J33+J49+J56+J67","v":50598.614600246765},null,{"$f":"L13+L24+L33+L49+L56+L67","v":5565847.6060271449},0,0,{"$f":"O13+O24+O33+O49+O56+O67","v":16063563.135146402},0,0,50598.614600246765,0,0,50598.614600246765,0,0,50598.614600246765,0,0]

{"sheet":"Resultat","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[27,0,27,1],[0,0,0,18],[40,2,40,4],[52,2,52,4],[28,8,28,10],[40,8,40,10],[17,2,17,4],[28,2,28,4]]}
["Præsentation af resultater"]
[]
[]
[]
[]
[]
[]
[]
[]
["Opsummering af scenarie"]
[null,"Antal"]
["Antaget driftsperiode",{"$f":"input!C16","v":3}]
["Antal igangsatte borgerforløb pr år",{"$f":"input!C23","v":110}]
["Antal gennemførte borgerforløb pr år",{"$f":"input!C24","v":110}]
[]
[]
["Overordnede resultater"]
[null,"I alt, kr.","Heraf"]
[null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C30","v":0}]
["Omkostninger pr. igangsat borgerforløb",{"$f":"Beregning!I72","v":50598.614600246765},{"$f":"Beregning!U72","v":50598.614600246765},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0}]
["Omkosntinger på gennemført borgerforløb",{"$f":"Beregning!J72","v":50598.614600246765},{"$f":"Beregning!X72","v":50598.614600246765},{"$f":"Beregning!Y72","v":0},{"$f":"Beregning!Z72","v":0}]
["Omkostninger pr. forløb",{"$f":"Beregning!H72","v":50598.614600246765},{"$f":"Beregning!R72","v":50598.614600246765},{"$f":"Beregning!S72","v":0},{"$f":"Beregning!T72","v":0}]
["Årlige omkostninger i alt",{"$f":"Beregning!E72","v":5565847.6060271449},{"$f":"Beregning!L72","v":5565847.6060271449},{"$f":"Beregning!M72","v":0},{"$f":"Beregning!N72","v":0}]
["NNV over hele driftsperioden",{"$f":"Beregning!F72","v":16063563.135146402},{"$f":"Beregning!O72","v":16063563.135146402},{"$f":"Beregning!P72","v":0},{"$f":"Beregning!Q72","v":0}]
[]
[]
["Omkostninger opdelt på kategorier"]
["Omkostninger pr. igangsat deltagerforløb",null,null,null,null,null,"Årlige omkostninger i alt"]
["Kategorier","I alt, kr.","Heraf",null,null,null,"Kategorier","I alt, kr.","Heraf"]
[null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C30","v":0},null,null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C30","v":0}]
[{"$f":"Beregning!B13","v":"Forberedelse"},{"$f":"Beregning!I13","v":1413.8946462696435},{"$f":"Beregning!U13","v":1413.8946462696435},{"$f":"Beregning!V13","v":0},{"$f":"Beregning!W13","v":0},null,{"$f":"Beregning!B13","v":"Forberedelse"},{"$f":"Beregning!E13","v":155528.41108966077},{"$f":"Beregning!L13","v":155528.41108966077},{"$f":"Beregning!V13","v":0},{"$f":"Beregning!W13","v":0}]
[{"$f":"Beregning!B24","v":"Uddannelse"},{"$f":"Beregning!I24","v":909.09090909090912},{"$f":"Beregning!U24","v":909.09090909090912},{"$f":"Beregning!V24","v":0},{"$f":"Beregning!W24","v":0},null,{"$f":"Beregning!B24","v":"Uddannelse"},{"$f":"Beregning!E24","v":100000},{"$f":"Beregning!L24","v":100000},{"$f":"Beregning!V24","v":0},{"$f":"Beregning!W24","v":0}]
[{"$f":"Beregning!B33","v":"Drift af indsats"},{"$f":"Beregning!I33","v":41177.702263559433},{"$f":"Beregning!U33","v":41177.702263559433},{"$f":"Beregning!V33","v":0},{"$f":"Beregning!W33","v":0},null,{"$f":"Beregning!B33","v":"Drift af indsats"},{"$f":"Beregning!E33","v":4529547.2489915388},{"$f":"Beregning!L33","v":4529547.2489915388},{"$f":"Beregning!V33","v":0},{"$f":"Beregning!W33","v":0}]
[{"$f":"Beregning!B49","v":"Investeringer  "},{"$f":"Beregning!I49","v":0},{"$f":"Beregning!U49","v":0},{"$f":"Beregning!V49","v":0},{"$f":"Beregning!W49","v":0},null,{"$f":"Beregning!B49","v":"Investeringer  "},{"$f":"Beregning!E49","v":0},{"$f":"Beregning!L49","v":0},{"$f":"Beregning!V49","v":0},{"$f":"Beregning!W49","v":0}]
[{"$f":"Beregning!B56","v":"Øvrige omkostninger"},{"$f":"Beregning!I56","v":7097.9267813267807},{"$f":"Beregning!U56","v":7097.9267813267807},{"$f":"Beregning!V56","v":0},{"$f":"Beregning!W56","v":0},null,{"$f":"Beregning!B56","v":"Øvrige omkostninger"},{"$f":"Beregning!E56","v":780771.94594594592},{"$f":"Beregning!L56","v":780771.94594594592},{"$f":"Beregning!V56","v":0},{"$f":"Beregning!W56","v":0}]
[{"$f":"Beregning!B67","v":"Tilskud"},{"$f":"Beregning!I67","v":0},{"$f":"Beregning!U67","v":0},{"$f":"Beregning!V67","v":0},{"$f":"Beregning!W67","v":0},null,{"$f":"Beregning!B67","v":"Tilskud"},{"$f":"Beregning!E67","v":0},{"$f":"Beregning!L67","v":0},{"$f":"Beregning!V67","v":0},{"$f":"Beregning!W67","v":0}]
[{"$f":"Beregning!B72","v":"Total"},{"$f":"Beregning!I72","v":50598.614600246765},{"$f":"Beregning!U72","v":50598.614600246765},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0},null,{"$f":"Beregning!B72","v":"Total"},{"$f":"Beregning!E72","v":5565847.6060271449},{"$f":"Beregning!L72","v":5565847.6060271449},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0}]
[]
[]
["Omkostninger pr. gennemført deltagerforløb",null,null,null,null,null,"NNV over hele driftsperioden"]
["Kategorier","I alt, kr.","Heraf",null,null,null,"Kategorier","I alt, kr.","Heraf"]
[null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C30","v":0},null,null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C30","v":0}]
[{"$f":"Beregning!B13","v":"Forberedelse"},{"$f":"Beregning!J13","v":1413.8946462696435},{"$f":"Beregning!X13","v":1413.8946462696435},{"$f":"Beregning!V13","v":0},{"$f":"Beregning!W13","v":0},null,{"$f":"Beregning!B13","v":"Forberedelse"},{"$f":"Beregning!F13","v":448869.71898805973},{"$f":"Beregning!O13","v":448869.71898805973},{"$f":"Beregning!V13","v":0},{"$f":"Beregning!W13","v":0}]
[{"$f":"Beregning!B24","v":"Uddannelse"},{"$f":"Beregning!J24","v":909.09090909090912},{"$f":"Beregning!X24","v":909.09090909090912},{"$f":"Beregning!V24","v":0},{"$f":"Beregning!W24","v":0},null,{"$f":"Beregning!B24","v":"Uddannelse"},{"$f":"Beregning!F24","v":288609.46745562146},{"$f":"Beregning!O24","v":288609.46745562146},{"$f":"Beregning!V24","v":0},{"$f":"Beregning!W24","v":0}]
[{"$f":"Beregning!B33","v":"Drift af indsats"},{"$f":"Beregning!J33","v":41177.702263559433},{"$f":"Beregning!X33","v":41177.702263559433},{"$f":"Beregning!V33","v":0},{"$f":"Beregning!W33","v":0},null,{"$f":"Beregning!B33","v":"Drift af indsats"},{"$f":"Beregning!F33","v":13072702.193465233},{"$f":"Beregning!O33","v":13072702.193465233},{"$f":"Beregning!V33","v":0},{"$f":"Beregning!W33","v":0}]
[{"$f":"Beregning!B49","v":"Investeringer  "},{"$f":"Beregning!J49","v":0},{"$f":"Beregning!X49","v":0},{"$f":"Beregning!V49","v":0},{"$f":"Beregning!W49","v":0},null,{"$f":"Beregning!B49","v":"Investeringer  "},{"$f":"Beregning!F49","v":0},{"$f":"Beregning!O49","v":0},{"$f":"Beregning!V49","v":0},{"$f":"Beregning!W49","v":0}]
[{"$f":"Beregning!B56","v":"Øvrige omkostninger"},{"$f":"Beregning!J56","v":7097.9267813267807},{"$f":"Beregning!X56","v":7097.9267813267807},{"$f":"Beregning!V56","v":0},{"$f":"Beregning!W56","v":0},null,{"$f":"Beregning!B56","v":"Øvrige omkostninger"},{"$f":"Beregning!F56","v":2253381.7552374871},{"$f":"Beregning!O56","v":2253381.7552374871},{"$f":"Beregning!V56","v":0},{"$f":"Beregning!W56","v":0}]
[{"$f":"Beregning!B67","v":"Tilskud"},{"$f":"Beregning!J67","v":0},{"$f":"Beregning!X67","v":0},{"$f":"Beregning!V67","v":0},{"$f":"Beregning!W67","v":0},null,{"$f":"Beregning!B67","v":"Tilskud"},{"$f":"Beregning!F67","v":0},{"$f":"Beregning!O67","v":0},{"$f":"Beregning!V67","v":0},{"$f":"Beregning!W67","v":0}]
[{"$f":"Beregning!B72","v":"Total"},{"$f":"Beregning!J72","v":50598.614600246765},{"$f":"Beregning!X72","v":50598.614600246765},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0},null,{"$f":"Beregning!B72","v":"Total"},{"$f":"Beregning!F72","v":16063563.135146402},{"$f":"Beregning!O72","v":16063563.135146402},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0}]
[]
[]
["Omkostninger pr. forløb"]
["Kategorier","I alt, kr.","Heraf"]
[null,null,{"$f":"input!C28","v":"Esbjerg kommune"},{"$f":"input!C29","v":0},{"$f":"input!C238","v":0}]
[{"$f":"Beregning!B13","v":"Forberedelse"},{"$f":"Beregning!H13","v":1413.8946462696435},{"$f":"Beregning!R13","v":1413.8946462696435},{"$f":"Beregning!V13","v":0},{"$f":"Beregning!W13","v":0}]
[{"$f":"Beregning!B24","v":"Uddannelse"},{"$f":"Beregning!H24","v":909.09090909090912},{"$f":"Beregning!R24","v":909.09090909090912},{"$f":"Beregning!V24","v":0},{"$f":"Beregning!W24","v":0}]
[{"$f":"Beregning!B33","v":"Drift af indsats"},{"$f":"Beregning!H33","v":41177.702263559433},{"$f":"Beregning!R33","v":41177.702263559433},{"$f":"Beregning!V33","v":0},{"$f":"Beregning!W33","v":0}]
[{"$f":"Beregning!B49","v":"Investeringer  "},{"$f":"Beregning!H49","v":0},{"$f":"Beregning!R49","v":0},{"$f":"Beregning!V49","v":0},{"$f":"Beregning!W49","v":0}]
[{"$f":"Beregning!B56","v":"Øvrige omkostninger"},{"$f":"Beregning!H56","v":7097.9267813267807},{"$f":"Beregning!R56","v":7097.9267813267807},{"$f":"Beregning!V56","v":0},{"$f":"Beregning!W56","v":0}]
[{"$f":"Beregning!B67","v":"Tilskud"},{"$f":"Beregning!H67","v":0},{"$f":"Beregning!R67","v":0},{"$f":"Beregning!V67","v":0},{"$f":"Beregning!W67","v":0}]
[{"$f":"Beregning!B72","v":"Total"},{"$f":"Beregning!H72","v":50598.614600246765},{"$f":"Beregning!R72","v":50598.614600246765},{"$f":"Beregning!V72","v":0},{"$f":"Beregning!W72","v":0}]

{"sheet":"Enhedspriskatalog","index":4,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,0,0,18],[16,4,16,6],[16,8,16,11],[38,0,38,1]]}
["Diverse enhedspriser til beregning af omkostninger"]
[]
[]
["Centrale parametre"]
["Diverse (Socialstyrelsens anbefalinger)"]
["Standard diskonteringsfaktor",0.04]
["Standard overhead",0.2]
[]
[]
["Deflator til omregning af enhedspriser"]
["Valg af deflator og prisår"]
["Deflator","FPI"]
["Prisår",2014]
[]
[]
[]
[{"$f":"\"Valgt deflator: \"&B12","v":"Valgt deflator: FPI"},null,null,null,"Forbrugerprisindeks",null,null,null,"Kommunal service pris- og lønindeks"]
["år",{"$f":"B12","v":"FPI"},"Beregnet deflator",null,"år","FPI","Beregnet deflator",null,"Opgørelse","År","Kommunal service PL","Beregnet deflator"]
[2015,{"$f":"IF($B$12=\"FPI\",VLOOKUP($A19,$E$19:$G$34,2,FALSE),IF($B$12=\"Kommunal service PL\",VLOOKUP($A19,$J$19:$L$34,2,FALSE)))","v":129.6},{"$f":"IF($B$12=\"FPI\",VLOOKUP($A19,$E$19:$G$34,3,FALSE),IF($B$12=\"Kommunal service PL\",VLOOKUP($A19,$J$19:$L$34,3,FALSE)))","v":1.0007716049382716},null,2015,129.6,{"$f":"IF($B$13=$E$19,($F$19/F19),IF($B$13=$E$20,($F$20/F19),IF($B$13=$E$21,$F$21/F19,IF($B$13=$E$22,$F$22/F19,IF($B$13=$E$23,$F$23/F19,IF($B$13=$E$24,$F$24/F19,IF($B$13=$E$25,$F$25/F19,IF($B$13=$E$26,$F$26/F19,IF($B$13=$E$27,$F$27/F19,IF($B$13=$E$28,$F$28/F19,IF($B$13=$E$29,$F$29/F19,IF($B$13=$E$30,$F$30/F19,IF($B$13=$E$31,$F$31/F19,IF($B$13=$E$32,$F$32/F19,IF($B$13=$E$33,$F$33/F19,IF($B$13=$E$34,$F$34/F19,\"FEJL\"))))))))))))))))","v":1.0007716049382716},null,null,2015,1,{"$f":"IF($B$13=$J$19,1,IF($B$13=$J$20,($K$19/$K$20),IF($B$13=$J$21,($K$20/$K$21),IF($B$13=$J$22,($K$20/$K$21)/$K$22,IF($B$13=$J$23,(($K$20/$K$21)/$K$22)/$K$23,IF($B$13=$J$24,((($K$20/$K$21)/$K$22)/$K$23)/$K$24,IF($B$13=$J$25,(((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25,IF($B$13=$J$26,((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26,IF($B$13=$J$27,(((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,(((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,(((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":0.98716683119447202}]
[2014,{"$f":"IF($B$12=\"FPI\",VLOOKUP($A20,$E$20:$G$34,2,FALSE),IF($B$12=\"Kommunal service PL\",VLOOKUP($A20,$J$20:$L$34,2,FALSE)))","v":129.69999999999999},{"$f":"IF($B$12=\"FPI\",VLOOKUP($A20,$E$20:$G$34,3,FALSE),IF($B$12=\"Kommunal service PL\",VLOOKUP($A20,$J$20:$L$34,3,FALSE)))","v":1},null,2014,129.69999999999999,1,null,"(2014-2015)",2014,1.0129999999999999,{"$f":"IF($B$13=$J$19,$K$20,IF($B$13=$J$20,1,IF($B$13=$J$21,($K$20/$K$21),IF($B$13=$J$22,($K$20/$K$21)/$K$22,IF($B$13=$J$23,(($K$20/$K$21)/$K$22)/$K$23,IF($B$13=$J$24,((($K$20/$K$21)/$K$22)/$K$23)/$K$24,IF($B$13=$J$25,(((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25,IF($B$13=$J$26,((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26,IF($B$13=$J$27,(((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,(((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,(((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((((((((((($K$20/$K$21)/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1}]
[2013,128.4,1.0101246105919002,null,2013,128.4,1.0101246105919002,null,"(2013-2014)",2013,1.014,{"$f":"IF($B$13=$J$19,($K$21*$K$20),IF($B$13=$J$20,($K$21),IF($B$13=$J$21,1,IF($B$13=$J$22,$K$21/$K$22,IF($B$13=$J$23,($K$21/$K$22)/$K$23,IF($B$13=$J$24,(($K$21/$K$22)/$K$23)/$K$24,IF($B$13=$J$25,((($K$21/$K$22)/$K$23)/$K$24)/$K$25,IF($B$13=$J$26,(((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26,IF($B$13=$J$27,((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,(((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,(((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,((((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,(((((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,((((((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,(((((((((((($K$21/$K$22)/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.014}]
[2012,126.8,1.0228706624605677,null,2012,126.8,1.0228706624605677,null,"(2012-2013)",2012,1.01,{"$f":"IF($B$13=$J$19,($K$22*$K$21*$K$20),IF($B$13=$J$20,($K$21*$K$22),IF($B$13=$J$21,$K$22,IF($B$13=$J$22,1,IF($B$13=$J$23,($K$22/$K$23),IF($B$13=$J$24,($K$22/$K$23)/$K$24,IF($B$13=$J$25,(($K$22/$K$23)/$K$24)/$K$25,IF($B$13=$J$26,((($K$22/$K$23)/$K$24)/$K$25)/$K$26,IF($B$13=$J$27,(((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,(((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,((((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,(((((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((((((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((((((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((((((((($K$22/$K$23)/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.0241400000000001}]
[2011,123.4,1.0510534846029171,null,2011,123.4,1.0510534846029171,null,"(2011-2012)",2011,1.024,{"$f":"IF($B$13=$J$19,($K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$23*$K$22*$K$21),IF($B$13=$J$21,$K$22*$K$23,IF($B$13=$J$22,$K$23,IF($B$13=$J$23,1,IF($B$13=$J$24,($K$23/$K$24),IF($B$13=$J$25,($K$23/$K$24)/$K$25,IF($B$13=$J$26,(($K$23/$K$24)/$K$25)/$K$26,IF($B$13=$J$27,((($K$23/$K$24)/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,(((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,(((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,((((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,(((((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,((((((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,(((((((((($K$23/$K$24)/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.04871936}]
[2010,120.2,1.0790349417637271,null,2010,120.2,1.0790349417637271,null,"(2010-2011)",2010,1.0129999999999999,{"$f":"IF($B$13=$J$19,($K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$22*$K$21,IF($B$13=$J$23,$K$24,IF($B$13=$J$24,1,IF($B$13=$J$25,($K$24/$K$25),IF($B$13=$J$26,($K$24/$K$25)/$K$26,IF($B$13=$J$27,(($K$24/$K$25)/$K$26)/$K$27,IF($B$13=$J$28,((($K$24/$K$25)/$K$26)/$K$27)/$K$28,IF($B$13=$J$29,(((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,((((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,(((((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((((((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((((((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((((((($K$24/$K$25)/$K$26)/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.06235271168}]
[2009,117.8,1.1010186757215619,null,2009,117.8,1.1010186757215619,null,"(2009-2010)",2009,1.0289999999999999,{"$f":"IF($B$13=$J$19,($K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$25*$K$24,IF($B$13=$J$24,$K$25,IF($B$13=$J$25,1,IF($B$13=$J$26,($K$25/$K$26),IF($B$13=$J$27,(($K$25/$K$26))/$K$27,IF($B$13=$J$28,((($K$25/$K$26))/$K$27)/$K$28,IF($B$13=$J$29,(((($K$25/$K$26))/$K$27)/$K$28)/$K$29,IF($B$13=$J$30,((((($K$25/$K$26))/$K$27)/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,(((((($K$25/$K$26))/$K$27)/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((((((($K$25/$K$26))/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((((((($K$25/$K$26))/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((((((($K$25/$K$26))/$K$27)/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.0931609403187199}]
[2008,115.7,1.1210025929127052,null,2008,115.7,1.1210025929127052,null,"(2008-2009)",2008,1.0389999999999999,{"$f":"IF($B$13=$J$19,($K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$26*$K$25,IF($B$13=$J$25,$K$26,IF($B$13=$J$26,1,IF($B$13=$J$27,($K$26/$K$27),IF($B$13=$J$28,(($K$26/$K$27))/$K$28,IF($B$13=$J$29,((($K$26/$K$27))/$K$28)/$K$29,IF($B$13=$J$30,(((($K$26/$K$27))/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,((((($K$26/$K$27))/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,(((((($K$26/$K$27))/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,((((((($K$26/$K$27))/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,(((((((($K$26/$K$27))/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.1357942169911501}]
[2007,112.4,1.1539145907473307,null,2007,112.4,1.1539145907473307,null,"(2007-2008)",2007,1.0369999999999999,{"$f":"IF($B$13=$J$19,($K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$27*$K$26,IF($B$13=$J$26,$K$27,IF($B$13=$J$27,1,IF($B$13=$J$28,($K$27/$K$28),IF($B$13=$J$29,($K$27/$K$28)/$K$29,IF($B$13=$J$30,(($K$27/$K$28)/$K$29)/$K$30,IF($B$13=$J$31,((($K$27/$K$28)/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,(((($K$27/$K$28)/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,((((($K$27/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,(((((($K$27/$K$28)/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.1778186030198223}]
[2006,110.4,1.17481884057971,null,2006,110.4,1.17481884057971,null,"(2006-2007)",2006,1.032,{"$f":"IF($B$13=$J$19,($K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$28*$K$27,IF($B$13=$J$27,$K$28,IF($B$13=$J$28,1,IF($B$13=$J$29,($K$28/$K$29),IF($B$13=$J$30,($K$28/$K$29)/$K$30,IF($B$13=$J$31,(($K$28/$K$29)/$K$30)/$K$31,IF($B$13=$J$32,((($K$28/$K$29)/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,(((($K$28/$K$29)/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((((($K$28/$K$29)/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.2155087983164568}]
[2005,108.1,1.1998149861239593,null,2005,108.1,1.1998149861239593,null,"(2005-2006)",2005,1.036,{"$f":"IF($B$13=$J$19,($K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$29*$K$28,IF($B$13=$J$28,$K$29,IF($B$13=$J$29,1,IF($B$13=$J$30,$K$29/$K$30,IF($B$13=$J$31,($K$29/$K$30)/$K$31,IF($B$13=$J$32,(($K$29/$K$30)/$K$31)/$K$32,IF($B$13=$J$33,((($K$29/$K$30)/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,(((($K$29/$K$30)/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.2592671150558492}]
[2004,107,1.2121495327102803,null,2004,107,1.2121495327102803,null,"(2004-2005)",2004,1.026,{"$f":"IF($B$13=$J$19,($K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$30*$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$30*$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$30*$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$30*$K$29*$K$28,IF($B$13=$J$28,$K$30*$K$29,IF($B$13=$J$29,$K$30,IF($B$13=$J$30,1,IF($B$13=$J$31,$K$30/$K$31,IF($B$13=$J$32,($K$30/$K$31)/$K$32,IF($B$13=$J$33,(($K$30/$K$31)/$K$32)/$K$33,IF($B$13=$J$34,((($K$30/$K$31)/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.2920080600473014}]
[2003,105.8,1.2258979206049148,null,2003,105.8,1.2258979206049148,null,"(2003-2004)",2003,1.0329999999999999,{"$f":"IF($B$13=$J$19,($K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$31*$K$30*$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$31*$K$30*$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$31*$K$30*$K$29*$K$28,IF($B$13=$J$28,$K$31*$K$30*$K$29,IF($B$13=$J$29,$K$31*$K$30,IF($B$13=$J$30,$K$31,IF($B$13=$J$31,1,IF($B$13=$J$32,$K$31/$K$32,IF($B$13=$J$33,($K$31/$K$32)/$K$33,IF($B$13=$J$34,(($K$31/$K$32)/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.3346443260288621}]
[2002,103.1,1.2580019398642095,null,2002,103.1,1.2580019398642095,null,"(2002-2003)",2002,1.0349999999999999,{"$f":"IF($B$13=$J$19,($K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$32*$K$31*$K$30*$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$32*$K$31*$K$30*$K$29*$K$28,IF($B$13=$J$28,$K$32*$K$31*$K$30*$K$29,IF($B$13=$J$29,$K$32*$K$31*$K$30,IF($B$13=$J$30,$K$32*$K$31,IF($B$13=$J$31,$K$32,IF($B$13=$J$32,1,IF($B$13=$J$33,$K$32/$K$33,IF($B$13=$J$34,($K$32/$K$33)/$K$34,\"jiJL\"))))))))))))))))","v":1.3813568774398721}]
[2001,100.6,1.2892644135188867,null,2001,100.6,1.2892644135188867,null,"(2001-2002)",2001,1.026,{"$f":"IF($B$13=$J$19,($K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$33*$K$32*$K$31*$K$30*$K$29*$K$28,IF($B$13=$J$28,$K$33*$K$32*$K$31*$K$30*$K$29,IF($B$13=$J$29,$K$33*$K$32*$K$31*$K$30,IF($B$13=$J$30,$K$33*$K$32*$K$31,IF($B$13=$J$31,$K$33*$K$32,IF($B$13=$J$32,$K$33,IF($B$13=$J$33,1,IF($B$13=$J$34,$K$33/$K$34,\"jiJL\"))))))))))))))))","v":1.4172721562533088}]
[2000,98.3,1.3194303153611393,null,2000,98.3,1.3194303153611393,null,"(2000-2001)",2000,1.0349999999999999,{"$f":"IF($B$13=$J$19,($K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21*$K$20),IF($B$13=$J$20,($K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22*$K$21),IF($B$13=$J$21,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23*$K$22,IF($B$13=$J$22,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24*$K$23,IF($B$13=$J$23,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25*$K$24,IF($B$13=$J$24,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26*$K$25,IF($B$13=$J$25,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27*$K$26,IF($B$13=$J$26,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28*$K$27,IF($B$13=$J$27,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29*$K$28,IF($B$13=$J$28,$K$34*$K$33*$K$32*$K$31*$K$30*$K$29,IF($B$13=$J$29,$K$34*$K$33*$K$32*$K$31*$K$30,IF($B$13=$J$30,$K$34*$K$33*$K$32*$K$31,IF($B$13=$J$31,$K$34*$K$33*$K$32,IF($B$13=$J$32,$K$34*$K$33,IF($B$13=$J$33,$K$34,IF($B$13=$J$34,1,\"jiJL\"))))))))))))))))","v":1.4668766817221748}]
[]
[]
[]
["Lønninger for offentligt ansatte opdelt på personalegrupper"]
["Timenorm for offentlig ansatte"]
[1418,"timer/året"]
[]
[]
["Lønninger i Kommunerne"]
["Stillingskategori","Gns. Årsløn (2014)","Beregnet timeløn (årets priser)","Beregnet årsløn\n(faste priser pba. valgt prisår)","Beregnet timeløn\n(faste priser pba. valgt prisår)"]
["Akademikere (i alt)",532122.30942199985,{"$f":"B45/$A$40","v":375.26255953596603},{"$f":"B45*$C$20","v":532122.30942199985},{"$f":"C45*$C$20","v":375.26255953596603}]
["Jurister og økonomer, KL ny lønforløb",547775.60581699992,{"$f":"B46/$A$40","v":386.30155558321576},{"$f":"B46*$C$20","v":547775.60581699992},{"$f":"C46*$C$20","v":386.30155558321576}]
["Psykologer, nyt lønforløb",535913.98766899982,377.93652162834968,535913.98766899982,377.93652162834968]
["Dagplejere (i alt)",338577.38371899992,238.771074555007,338577.38371899992,238.771074555007]
["Ergoterapeuter",423779.21739838633,298.85699393398193,423779.21739838633,298.85699393398193]
["Fysioterapeuter",420142.49604469887,296.29231032771429,420142.49604469887,296.29231032771429]
["Kommunallæger (i alt)",819042.41812543757,577.60396200665559,819042.41812543757,577.60396200665559]
["Kontor- og it-personale ( i alt)",396314.49781889492,279.48836235465086,396314.49781889492,279.48836235465086]
["Omsorgs- og pædagogmedhjælpere, samt. pæd. ass. (i alt)",324164.03123213258,228.60651003676486,324164.03123213258,228.60651003676486]
["Pæd. personale, daginst./klub/skolefr. (i alt)",391248.23500304908,275.91553949439287,391248.23500304908,275.91553949439287]
["Hjemmevejledere og pæd. pers., døgninst. (i alt)",410767.36592992872,289.68079402674806,410767.36592992872,289.68079402674806]
["Pædagogiske konsulenter (i alt)",519329.00316139398,366.24048177813398,519329.00316139398,366.24048177813398]
["Pædagogmedhj. og pædagogiske assistenter (i alt)",293371.43025378103,206.89099453722216,293371.43025378103,206.89099453722216]
["Pædagogisk pers., forebyg. og dagbehandl. område",439707.85978442448,310.09016910044039,439707.85978442448,310.09016910044039]
["Social- og sundhedspersonale (i alt)",339063.21147978469,239.11368933694266,339063.21147978469,239.11368933694266]
["Social- og sundhedsassistenter",382335.24141693278,269.62993047738559,382335.24141693278,269.62993047738559]
["Social- og sundhedshjælpere",362113.10501288611,255.36890339413688,362113.10501288611,255.36890339413688]
["Socialrådg./socialformidlere",435398.67051219422,307.05124859816237,435398.67051219422,307.05124859816237]
["Sygeplejersker",437355.06379583949,308.43093356547212,437355.06379583949,308.43093356547212]
["Sundhedsplejersker",438457.85570475715,309.20864295116866,438457.85570475715,309.20864295116866]
["Syge- og sundhedspersonale, ledere (i alt)",539565.58935714175,380.51169912351321,539565.58935714175,380.51169912351321]
["Ledende sygeplejersker",552177.32205270976,389.40572782278542,552177.32205270976,389.40572782278542]
["Tolke (i alt)",427679.60351219104,301.60761883793447,427679.60351219104,301.60761883793447]
["Pædagogisk uddannede ledere (i alt)",515472.35407521902,363.52070104035192,515472.35407521902,363.52070104035192]
["Plejehjemsforstandere (i alt)",642557.65020848368,453.14361791853577,642557.65020848368,453.14361791853577]
["Lærer, folkeskole mv. (i alt)",467154.71521406953,329.4462025487091,467154.71521406953,329.4462025487091]
["Tandlæge (i alt)",634999.49948420294,447.81346931184976,634999.49948420294,447.81346931184976]
["Chefer, KL (forvaltningsniveau) (i alt)",860608.70389323717,606.91728060171874,860608.70389323717,606.91728060171874]
[]
[]
["Rejseomkostninger, kr."]
[null,"pris","Justeret til valgt prisår"]
["Kørselgodgørelse pr. medarbejder i Danmark, 2013",{"$f":"3.73","v":3.73},{"$f":"B77*$C$21","v":3.7677647975077875}]
["Gennemsnitlige rejseomkostninger pr. medarbejder(retur) i Danmark, 2013",{"$f":"600*B77","v":2238},2260.6588785046724]
["Hoteldispositionsbeløb pr. medarbejder i Danmark, 2013",1025,1035.3777258566977]
["Hoteldispositionsbeløb pr. medarbejder i Europa, 2014",1150,1161.6433021806852]
["Hoteldispositionsbeløb pr. medarbejder i USA, 2014",1678,1694.9890965732086]
["Dagpenge pr. medarbejder i Danmark, 2014",398,402.02959501557626]
["Dagpenge pr. medarbejder i Udlandet, 2014",464,468.69781931464166]
[]
[]
[]
["Omkostninger til teknisk udstyr ",null,null,"OBS! Tine skal give den rette kilde"]
["Teknisk udstyr","Beløb i kr. \n(2014-priser)","Justeret til valgt prisår"]
["32\" TV",3000,{"$f":"B89*$C$20","v":3000}]
["Videokamera",6500,{"$f":"B90*$C$20","v":6500}]
["Taske til kamera",470,{"$f":"B91*$C$20","v":470}]
["128 GB SD-kort",750,{"$f":"B92*$C$20","v":750}]
["Diktafon",600,{"$f":"B93*$C$20","v":600}]

{"sheet":"KPI Husleje ","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"Antal årsværk i alt i Esbjerg ",8.3648648648648649]
[null,null,null,null,null,"Gennemsnitlig husleje pr. årsværk fra kpi ",65330]
[null,null,null,null,null,"Husleje i esbjerg ",436448.23835059151]
[null,null,null,null,null,"Beregnet gennemsnits husleje - fra kpi ",{"$f":"G4*G3","v":546476.62162162166}]
[null,null,null,null,null,"Median huslejen pr. årsværk fra kpi",49472.749172384007]
[null,null,null,null,null,"Beregnet median husleje esbjerg - fra kpi ",{"$f":"G7*G3","v":413832.86132034729}]