{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Forklaring","Traktor alene","Traktor og redskab ","Selvkørende","Bil alene","Vedligehold & salgsandel (%)","Gns. Traktoromk","GNs. årlige traktortimer."],"not_rendered":{"charts":14,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gns. Traktoromk","index":6,"reason":"not_a_worksheet"},{"sheet":"GNs. årlige traktortimer.","index":7,"reason":"not_a_worksheet"}],"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":"Forklaring","index":0,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Kalkulatus for Entreprenør-virksomheder"]
[]
[null,"Denne regneprogram giver mulighed for at beregne maskinomkostninger udfra egne forudsætninger."]
[null,"Dermed kan bruges både for brugte og nye maskiner."]
[]
[null,"Traktor"]
[null,"I denne fane kan man beregne egne omkostninger til traktor."]
[null,"I de fremhævede felter kan man indtaste egne tal og forudsætninger. Der er forklaring ved de enkelte felter"]
[]
[null,"Traktor + redskab"]
[null,"I denne fane kan man beregne egne omkostninger for traktortrukne redskaber."]
[null,"I de fremhævede felter kan man indtaste egne tal og forudsætninger. Der er forklaring ved de enkelte felter "]
[null,"Bemærk, at traktor indgår som en timeomkostning."]
[null,"Selvkørende maskiner"]
[null,"I denne fane kan man beregne egne omkostninger for selvkørende maskiner."]
[null,"I de fremhævede felter kan man indtaste egne tal og forudsætninger. Der er forklaring ved de enkelte felter"]
[]
[null,"Vedligehold og salgsandel (%)"]
[null,"I denne fane kan man finde data for hhv. gennemsnitsvedligeholdelse (Kr./time) og salgsandel (%) for forskellige maskingrupper."]
[null,"Begge dele er beregnet for 1 hel sæson. "]
[null,"Gns. Traktoromk."]
[null,"I denne fane er vist data fra 404 traktorer opdelt i 6 grupper efter motoreffekt. "]
[null,"Data er beregnet som gennemsnit ift. kørte timer for et helt år."]
[null,"Gns. Årlige traktortimer"]
[null,"I denne fane er vist de gennemsnitlige kørte traktortimer for de 6 opdelte grupper efter motoreffekt."]
[null,"Kørte traktortimer er timer, hvor traktoren har kørt på opgaver og transport. Derved kan der forskel ift. traktormetertimer,"]
[null,"hvor alle motortimer registreres."]
[]
[]
[null,"Vh."]
[null,"Torben Madsen"]
[null,"Driftsøkonom, DM&E"]

{"sheet":"Traktor alene","index":1,"n_rows":58,"n_cols":190,"rows_kept":58,"cut":false,"hidden":false,"merged":[[37,6,37,10],[38,6,38,10],[35,6,35,10],[36,6,36,10],[30,6,30,10],[31,6,31,10],[32,6,32,10],[33,6,33,10],[34,6,34,10]]}
[]
[null,null,"Kalkulatus 2023",null,null,null,"     Maskinkalkulation"]
[null,null,"Maskintype","Traktor 250 hk"]
[]
[null,null,"Købspris",1000000,"kr",null,"  Omkostninger         -            Salgspriser"]
[null,null,"Periode",8,"år",null,100,"(interval i skema)"]
[null,null,"Kalkulationsrente",4,"%",null,"eff.timer/","kr/","kr/","kr/","kr/"]
[null,null,"Værditab",14,"%p.a",null,"år","eff.time","eff.time","eff.time","eff.time"]
[null,null,"Gns. Årligt værditab",{"$f":"+(D5-D10)/D6","v":87597.759111676816},"kr",null,null,"i alt","excl.diesel","excl.løn","excl.løn"]
[null,null,"Restværdi ",{"$f":"((1-D8/100)^D6)*D5","v":299217.92710658547},"kr",null,null,null,"incl. løn","incl.diesel","excl.diesel"]
[null,null,"Værditab+forrentn.",{"$f":"((1-(1-$D$8/100)^$D$6)*($D$7/(1-((1+$D$7/100)^(-$D$6))))+(100*(1-$D$8/100)^$D$6)*($D$7/100))*(D5/100)","v":116054.35910832371},"kr/år",null,400,{"$f":"($D$16/G11+$D$28)*(1+($J$17/100))","v":814.66089777080924},{"$f":"($D$16/G11+($D$28-$D$27))*(1+($J$17/100))","v":680.66089777080924},{"$f":"($D$16/G11+$D$29)*(1+($J$17/100))","v":529.13589777080927},{"$f":"($D$16/G11+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":395.13589777080927}]
[null,null,"Kapitalomkostninger",{"$f":"+D11/D5*100","v":11.605435910832371},"%",null,{"$f":"+$G$6+G11","v":500},{"$f":"($D$16/G12+$D$28)*(1+($J$17/100))","v":745.63371821664737},{"$f":"($D$16/G12+($D$28-$D$27))*(1+($J$17/100))","v":611.63371821664737},{"$f":"($D$16/G12+$D$29)*(1+($J$17/100))","v":460.10871821664739},{"$f":"($D$16/G12+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":326.10871821664739}]
[null,null,"Husleje",3000,"kr/år",null,{"$f":"+$G$6+G12","v":600},{"$f":"($D$16/G13+$D$28)*(1+($J$17/100))","v":699.61559851387278},{"$f":"($D$16/G13+($D$28-$D$27))*(1+($J$17/100))","v":565.61559851387278},{"$f":"($D$16/G13+$D$29)*(1+($J$17/100))","v":414.09059851387281},{"$f":"($D$16/G13+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":280.09059851387281}]
[null,null,"Forsikring ",15000,"kr/år",null,{"$f":"+$G$6+G13","v":700},{"$f":"($D$16/G14+$D$28)*(1+($J$17/100))","v":666.74551301189103},{"$f":"($D$16/G14+($D$28-$D$27))*(1+($J$17/100))","v":532.74551301189103},{"$f":"($D$16/G14+$D$29)*(1+($J$17/100))","v":381.220513011891},{"$f":"($D$16/G14+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":247.220513011891}]
[null,null,"Vægtafgift",4000,"kr/år",null,{"$f":"+$G$6+G14","v":800},{"$f":"($D$16/G15+$D$28)*(1+($J$17/100))","v":642.09294888540467},{"$f":"($D$16/G15+($D$28-$D$27))*(1+($J$17/100))","v":508.09294888540461},{"$f":"($D$16/G15+$D$29)*(1+($J$17/100))","v":356.56794888540463},{"$f":"($D$16/G15+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":222.56794888540463}]
[null,null,"Faste omkostninger",{"$f":"$D$11+D13+D14+$D$15","v":138054.3591083237},"kr/år"]
[]
[]
[null,null,"Løn til medarbejder",162,"kr/time"]
[null,null,"Sociale omk",41,"%"]
[null,null,"Lønomkostning",{"$f":"+D19*(1+D20/100)","v":228.42},"kr/time"]
[null,null,"Effektivitet",80,"%"]
[null,null,"Lønomkostning",{"$f":"+D21/(D22/100)","v":285.52499999999998},"kr/eff.time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"timer/år",{"$f":"G13","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FU23","v":600},{"$f":"FV23","v":600},{"$f":"FW23","v":600},{"$f":"FX23","v":600},{"$f":"FY23","v":600},700,{"$f":"SUM(FU23:GB23)","v":4800}]
[null,null,"Rep/vedligeh.",50,"kr/time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"år"]
[null,null,"Brændstofforbrug",20,"liter/eff.time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"faste omkostninger",1,2,3,4,5,6,7,8,9,10,11,12,"GNS."]
[null,null,"Brændstofpris",6.7,"kr/liter",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"primoværdi",{"$f":"$D$5*(100-$D$8)/100","v":860000},{"$f":"FU26*(100-$D$8)/100","v":739600},{"$f":"FV26*(100-$D$8)/100","v":636056},547008.16,470427.01760000008,404567.23513600009,347927.82221696002,299217.92710658559,257327.41731166359,221301.57888803069,190319.35784370638,163674.64774558748]
[null,null,"Brændstof",{"$f":"+D25*D26","v":134},"kr/eff.time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"afskriv",{"$f":"D5-FU26","v":140000},{"$f":"FU26-FV26","v":120400},{"$f":"FV26-FW26","v":103544},89047.839999999967,76581.142399999953,65859.782463999989,56639.412919040071,48709.895110374433,41890.509794921993,36025.8384236329,30982.221044324309,26644.7100981189,null,{"$f":"SUM(FU27:GB27)","v":700782.0728934143}]
[null,null,"Driftsomk.ialt ",{"$f":"$D$24+$D$27+$D$23","v":469.52499999999998},"kr/eff.time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forrentning",{"$f":"D5*(($D$7/100))*(1+R7/100)","v":40000},{"$f":"FU26*(($D$7/100))*(1+R7/100)","v":34400},{"$f":"FV26*(($D$7/100))*(1+R7/100)","v":29584},{"$f":"FW26*(($D$7/100))*(1+R7/100)","v":25442.240000000002},{"$f":"FX26*(($D$7/100))*(1+R7/100)","v":21880.326400000002},{"$f":"FY26*(($D$7/100))*(1+R7/100)","v":18817.080704000004},{"$f":"FZ26*(($D$7/100))*(1+R7/100)","v":16182.689405440004},{"$f":"GA26*(($D$7/100))*(1+R7/100)","v":13917.112888678401},{"$f":"GB26*(($D$7/100))*(1+S7/100)","v":11968.717084263424},{"$f":"GC26*(($D$7/100))*(1+T7/100)","v":10293.096692466544},{"$f":"GD26*(($D$7/100))*(1+U7/100)","v":8852.0631555212276},{"$f":"GE26*(($D$7/100))*(1+V7/100)","v":7612.7743137482557},null,{"$f":"SUM(FU28:GB28)","v":200223.44939811842}]
[null,null,"Driftsomk. Ex løn",{"$f":"+D28-D23","v":184},"kr/eff.time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faste omk pr. time",{"$f":"(FU28+FU27)/FU23","v":300},{"$f":"(FV28+FV27)/FV23","v":258},221.88,190.81679999999994,164.10244799999992,141.12810528,121.37017054080012,104.37834666508806,89.765378131975694,77.19822519349907,66.390473666409235,57.095807353111923]
[null,null,null,null,null,null,"Kommentar",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Husleje+forsikring+vægtafgift",{"$f":"$D$15+$D$14+$D$13","v":22000},{"$f":"$D$15+$D$14+$D$13","v":22000},22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,{"$f":"SUM(FU30:GB30)","v":176000}]
[null,null,"Omkostninger på årsbasis.",null,"Kr./time",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable omk."]
[null,null,"Forrentning+afskrivning",{"$f":"D11","v":116054.35910832371},{"$f":"D32/G13","v":193.42393184720618},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"År",{"$f":"FU25","v":1},{"$f":"FV25","v":2},3,4,5,6,7,8,9,10,11,12,"GNS."]
[null,null,"Forsikring/vægtafgift/oa.",{"$f":"D15+D14+D13","v":22000},{"$f":"D33/G13","v":36.666666666666664},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Husleje+forsikring+vægtafgift",{"$f":"FU30/FU23","v":36.666666666666664},{"$f":"FV30/FV23","v":36.666666666666664},36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,36.666666666666664,31.428571428571427]
[null,null,"Løn",{"$f":"D23*G13","v":171315},{"$f":"D34/G13","v":285.52499999999998},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rep./vedligehold",{"$f":"$D$24","v":50},{"$f":"$D$24","v":50},50,50,50,50,50,50,50,50,50,50,50]
[null,null,"Rep/vedligeholdelse",{"$f":"D24*G13","v":30000},{"$f":"D35/G13","v":50},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbejdsløn",{"$f":"$D$23","v":285.52499999999998},{"$f":"$D$23","v":285.52499999999998},285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998,285.52499999999998]
[null,null,"Brændstof",{"$f":"D27*G13","v":80400},{"$f":"D36/G13","v":134},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brændstof",{"$f":"$D$27","v":134},{"$f":"$D$27","v":134},134,134,134,134,134,134,134,134,134,134,134]
[null,null,"Total omk.",{"$f":"SUM(D32:D36)","v":419769.3591083237},{"$f":"D37/G13","v":699.61559851387278},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afskriv/forrent",{"$f":"(FU28+FU27)/FU23","v":300},258,221.88,190.81679999999994,164.10244799999992,141.12810528,121.37017054080012,104.37834666508806,89.765378131975694,77.19822519349907,66.390473666409235,57.095807353111923,{"$f":"G35","v":0}]
[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,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,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,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,"Administration",{"$f":"SUM(FU33:FU37)*$J$17/100","v":0},{"$f":"SUM(FV33:FV37)*$J$17/100","v":0},0,0,0,0,0,0,0,0,0,0,0]
[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,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,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,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,{"$f":"SUM(FU33:FU38)","v":806.19166666666661},764.19166666666661,728.0716666666666,697.00846666666655,670.29411466666647,647.31977194666661,627.56183720746674,610.57001333175469,595.9570447986423,583.38989186016568,572.58214033307581,563.28747401977853,500.95357142857142]
[]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gns. kostpris for perioden",{"$f":"H13","v":699.61559851387278},{"$f":"FN41","v":699.61559851387278},{"$f":"FO41","v":699.61559851387278},699.61559851387278,699.61559851387278,699.61559851387278,699.61559851387278,699.61559851387278]
[]
[]
[]
[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,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,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,null,null,null,null,null,null,null,null,null,"År","Husleje+forsikring+vægtafgift","Rep./vedligehold","Arbejdsløn","Brændstof","Afskriv/forrent","Administration","Gns. kostpris for perioden","kostpris",null,null,null,"primoværdi","afskriv","Forrentning","Faste omk pr. time"]
[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,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,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,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(FA46=\"\",\"\",($D$13+$D$14+$D$15)/$G$13)","v":36.666666666666664},{"$f":"IF(FA46=\"\",\"\",$D$24)","v":50},{"$f":"IF(FA46=\"\",\"\",$D$23)","v":285.52499999999998},{"$f":"IF(FA46=\"\",\"\",$D$27)","v":134},{"$f":"IF(FA46=\"\",\"\",FP46)","v":300},{"$f":"IF(FA46=\"\",\"\",SUM(FB46:FF46)*$J$17/100)","v":0},{"$f":"IF(FA46=\"\",\"\",$FO$41)","v":699.61559851387278},{"$f":"SUM(FB46:FG46)","v":806.19166666666661},null,null,null,{"$f":"$D$5*(100-$D$8)/100","v":860000},{"$f":"D5-FM46","v":140000},{"$f":"D5*(($D$7/100))","v":40000},{"$f":"(FO46+FN46)/$G$13","v":300}]
[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,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,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,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(FA46>=$D$6,FA46=\"\"),\"\",+FA46+1)","v":2},36.666666666666664,50,285.52499999999998,{"$f":"IF(FA47=\"\",\"\",$D$27)","v":134},258,{"$f":"IF(FA47=\"\",\"\",SUM(FB47:FF47)*$J$17/100)","v":0},{"$f":"IF(FA47=\"\",\"\",$FO$41)","v":699.61559851387278},764.19166666666661,null,null,null,{"$f":"FM46*(100-$D$8)/100","v":739600},{"$f":"FM46-FM47","v":120400},{"$f":"FM46*(($D$7/100))","v":34400},258,{"$f":"FP46/FP47*100","v":116.27906976744187}]
[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,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,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,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(FA47>=$D$6,FA47=\"\"),\"\",+FA47+1)","v":3},36.666666666666664,50,285.52499999999998,134,221.88,0,699.61559851387278,728.0716666666666,null,null,null,636056,103544,29584,221.88,116.27906976744187]
[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,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,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,null,null,null,null,null,null,null,null,null,4,36.666666666666664,50,285.52499999999998,134,190.81679999999994,0,699.61559851387278,697.00846666666655,null,null,null,547008.16,89047.839999999967,25442.240000000002,190.81679999999994,116.27906976744188]
[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,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,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,null,null,null,null,null,null,null,null,null,5,36.666666666666664,50,285.52499999999998,134,164.10244799999992,0,699.61559851387278,670.29411466666647,null,null,null,470427.01760000008,76581.142399999953,21880.326400000002,164.10244799999992,116.27906976744188]
[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,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,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,null,null,null,null,null,null,null,null,null,6,36.666666666666664,50,285.52499999999998,134,141.12810528,0,699.61559851387278,647.31977194666661,null,null,null,404567.23513600009,65859.782463999989,18817.080704000004,141.12810528,116.2790697674418]
[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,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,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,null,null,null,null,null,null,null,null,null,7,36.666666666666664,50,285.52499999999998,134,121.37017054080012,0,699.61559851387278,627.56183720746674,null,null,null,347927.82221696002,56639.412919040071,16182.689405440004,121.37017054080012,116.27906976744175]
[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,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,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,null,null,null,null,null,null,null,null,null,8,36.666666666666664,50,285.52499999999998,134,104.37834666508806,0,699.61559851387278,610.57001333175469,null,null,null,299217.92710658559,48709.895110374433,13917.112888678401,104.37834666508806,116.27906976744191]
[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,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,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,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(FA54=\"\",\"\",($D$13+$D$14+$D$15)/$G$13)","v":""},{"$f":"IF(FA54=\"\",\"\",$D$24)","v":""},{"$f":"IF(FA54=\"\",\"\",$D$23)","v":""},"","","","",0,null,null,null,257327.41731166359,41890.509794921993,11968.717084263424,89.765378131975694,116.27906976744191]
[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,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,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,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(FA55=\"\",\"\",($D$13+$D$14+$D$15)/$G$13)","v":""},{"$f":"IF(FA55=\"\",\"\",$D$24)","v":""},{"$f":"IF(FA55=\"\",\"\",$D$23)","v":""},"","","","",0,null,null,null,221301.57888803069,36025.8384236329,10293.096692466544,77.19822519349907,116.27906976744191]
[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,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,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,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(FA56=\"\",\"\",($D$13+$D$14+$D$15)/$G$13)","v":""},{"$f":"IF(FA56=\"\",\"\",$D$24)","v":""},{"$f":"IF(FA56=\"\",\"\",$D$23)","v":""},"","","","",0,null,null,null,190319.35784370638,30982.221044324309,8852.0631555212276,66.390473666409235,116.2790697674418]
[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,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,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,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(FA57=\"\",\"\",($D$13+$D$14+$D$15)/$G$13)","v":""},{"$f":"IF(FA57=\"\",\"\",$D$24)","v":""},{"$f":"IF(FA57=\"\",\"\",$D$23)","v":""},"","","","",0,null,null,null,163674.64774558748,26644.7100981189,7612.7743137482557,57.095807353111923,116.27906976744191]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Traktor og redskab ","index":2,"n_rows":69,"n_cols":103,"rows_kept":69,"cut":false,"hidden":false,"merged":[[39,6,39,9],[40,6,40,9],[41,6,41,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[37,6,37,9],[38,6,38,9]]}
[]
[null,"Kalkulatus 2023",null,null,null,"     Maskinkalkulation"]
[null,"Maskintype","Jordvogn 16 T"]
[]
[null,"Pris ",200000,"kr","Omkostninger - udnyttelse"]
[null,"Periode",6,"år",100,"(interval i skema)"]
[null,"Kalkulationsrente",4,"%","timer/","kr/","kr/",null,"kr/","kr/eff.time"]
[null,"Værditab",15,"%p.a","år","eff.time",{"$f":"+F17","v":"time"},{"$f":"+F17","v":"time"},"eff.time","ex. Traktor"]
[null,"Gns. Årligt værditab",{"$f":"+(C5-C10)/C6","v":20761.682812500007},"kr/år",null,"i alt",null,"i alt","excl.diesel","excl.løn"]
[null,"Restværdi ",{"$f":"((1-C8/100)^C6)*C5","v":75429.903124999968},"kr",null,null,null,null,null,"excl.diesel"]
[null,"Værditab+forrentn.",{"$f":"((1-(1-$C$8/100)^$C$6)*($C$7/(1-((1+$C$7/100)^(-$C$6))))+(100*(1-$C$8/100)^$C$6)*($C$7/100))*(C5/100)","v":26780.424800475113},"kr/år",300,{"$f":"($C$17/E11+$C$31)*(1+($I$19/100))","v":764.27239093507546},{"$f":"+F11/$H$17","v":764.27239093507546},{"$f":"+E11*$H$17","v":300},{"$f":"($C$17/E11+($C$31-$C$28))*(1+($I$19/100))","v":648.77239093507546},{"$f":"($C$17/E11+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":153.19489093507542}]
[null,"Kapitalomkostninger",{"$f":"+C11/C5","v":0.13390212400237556},null,{"$f":"+$E$6+E11","v":400},{"$f":"($C$17/E12+$C$31)*(1+($I$19/100))","v":732.84866820130662},{"$f":"+F12/$H$17","v":732.84866820130662},{"$f":"+E12*$H$17","v":400},{"$f":"($C$17/E12+($C$31-$C$28))*(1+($I$19/100))","v":617.34866820130662},{"$f":"($C$17/E12+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":121.77116820130657}]
[null,"Husleje",3000,"kr/år",{"$f":"+$E$6+E12","v":500},{"$f":"($C$17/E13+$C$31)*(1+($I$19/100))","v":713.99443456104518},{"$f":"+F13/$H$17","v":713.99443456104518},{"$f":"+E13*$H$17","v":500},{"$f":"($C$17/E13+($C$31-$C$28))*(1+($I$19/100))","v":598.49443456104518},{"$f":"($C$17/E13+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":102.91693456104525}]
[null,"Forsikring ",3000,"kr/år",{"$f":"+$E$6+E13","v":600},{"$f":"($C$17/E14+$C$31)*(1+($I$19/100))","v":701.42494546753778},{"$f":"+F14/$H$17","v":701.42494546753778},{"$f":"+E14*$H$17","v":600},{"$f":"($C$17/E14+($C$31-$C$28))*(1+($I$19/100))","v":585.92494546753778},{"$f":"($C$17/E14+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":90.34744546753771}]
[null,"Vægtafgift",1500,"kr/år",{"$f":"+$E$6+E14","v":700},{"$f":"($C$17/E15+$C$31)*(1+($I$19/100))","v":692.44673897217513},{"$f":"+F15/$H$17","v":692.44673897217513},{"$f":"+E15*$H$17","v":700},{"$f":"($C$17/E15+($C$31-$C$28))*(1+($I$19/100))","v":576.94673897217513},{"$f":"($C$17/E15+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":81.369238972175182}]
[]
[null,"Faste omkostninger",{"$f":"$C$11+C13+C14+$C$15","v":34280.424800475113},"kr/år","enhed","time","kapacitet",1,"enhed/time"]
[]
[null,"Løn til medarbejder",162,"kr/time","Administration",null,null,null,10,"%",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,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,{"$f":"CI21*$G$22","v":207300},{"$f":"CJ21*$G$22","v":276400},{"$f":"CK21*$G$22","v":345500},{"$f":"CL21*$G$22","v":414600},{"$f":"CM21*$G$22","v":483700}]
[null,"Sociale omk",41,"%","0 - punktsberegning"]
[null,"Lønomkostning",{"$f":"+C19*(1+C20/100)","v":228.42},"kr/time",null,"kr/time","VÆLG salgspris",null,"kr/enhed","VÆLG salgspris",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,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,{"$f":"E11","v":300},{"$f":"E12","v":400},{"$f":"E13","v":500},{"$f":"E14","v":600},{"$f":"E15","v":700}]
[null,"Effektivitet",80,"%","Kostpris",{"$f":"+F13","v":713.99443456104518},691,"Kostpris",{"$f":"+G13","v":713.99443456104518},{"$f":"G22/H17","v":691},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,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,"Gns. fortjeneste pr. år",{"$f":"CI19-SUM(CI23:CI29)","v":-21981.717280522629},{"$f":"CJ19-SUM(CJ23:CJ29)","v":-16739.467280522629},{"$f":"CK19-SUM(CK23:CK29)","v":-11497.217280522629},{"$f":"CL19-SUM(CL23:CL29)","v":-6254.9672805226292},{"$f":"CM19-SUM(CM23:CM29)","v":-1012.7172805225709}]
[null,"Lønomkostning",{"$f":"+C21/(C22/100)","v":285.52499999999998},"kr/eff.time","Antal",{"$f":"+C17/((F22/(I19/100+1))-C31)","v":500.00000000000034},{"$f":"+C17/((G22/(I19/100+1))-C31)","v":719.31837055696781},"Antal",{"$f":"+C17/(((+I22*H17)/(I19/100+1))-C31)*H17","v":500.00000000000034},{"$f":"+C17/(((+J22*H17)/(I19/100+1))-C31)*H17","v":719.31837055696781},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,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,{"$f":"C11","v":26780.424800475113},"Værditab+forrentn.",{"$f":"CG23","v":26780.424800475113},{"$f":"CG23","v":26780.424800475113},{"$f":"CG23","v":26780.424800475113},{"$f":"CG23","v":26780.424800475113},{"$f":"CG23","v":26780.424800475113}]
[null,"Rep/vedligeh.",25,"kr/eff.time","Driftsresultat fra timepris",null,null,"Driftsresultat fra enhedspris",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,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,{"$f":"C15+C14+C13","v":7500},"Øvrige faste omk.",{"$f":"CG24","v":7500},{"$f":"CG24","v":7500},{"$f":"CG24","v":7500},{"$f":"CG24","v":7500},{"$f":"CG24","v":7500}]
[null,"Traktoromkostninger",165,"kr/eff.time","timer","i alt","kr i alt","enheder","kr/i alt","kr i alt",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,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,{"$f":"C23","v":285.52499999999998},"Lønomkostning",{"$f":"$CG$25*CI21","v":85657.5},{"$f":"$CG$25*CJ21","v":114209.99999999999},{"$f":"$CG$25*CK21","v":142762.5},{"$f":"$CG$25*CL21","v":171315},{"$f":"$CG$25*CM21","v":199867.49999999997}]
[null,"Brændstofforbrug",15,"liter/time",{"$f":"+E11","v":300},{"$f":"+(($F$22*E26))-$C$17-($C$31*E26)","v":5760.4055678384611},{"$f":"+(($G$22*E26))-$C$17-($C$31*E26)","v":-1137.924800475128},{"$f":"+E26*$H$17","v":300},{"$f":"+(($I$22*H26))-$C$17-((H26/$H$17)*$C$31)","v":5760.4055678384611},{"$f":"+(($J$22*H26))-$C$17-((H26/$H$17)*$C$31)","v":-1137.924800475128},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,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,{"$f":"C24","v":25},"Rep/vedligeh.",{"$f":"$CG$26*CI21","v":7500},{"$f":"$CG$26*CJ21","v":10000},{"$f":"$CG$26*CK21","v":12500},{"$f":"$CG$26*CL21","v":15000},{"$f":"$CG$26*CM21","v":17500}]
[null,"Brændstofpris",7,"kr/liter",{"$f":"+E12","v":400},{"$f":"+(($F$22*E27))-$C$17-($C$31*E27)","v":19107.349023942952},{"$f":"+(($G$22*E27))-$C$17-($C$31*E27)","v":9909.575199524872},{"$f":"+E27*$H$17","v":400},{"$f":"+(($I$22*H27))-$C$17-((H27/$H$17)*$C$31)","v":19107.349023942952},{"$f":"+(($J$22*H27))-$C$17-((H27/$H$17)*$C$31)","v":9909.575199524872},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,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,{"$f":"C28","v":105},{"$f":"B41","v":"Brændstof"},{"$f":"$CG$27*CI21","v":31500},{"$f":"$CG$27*CJ21","v":42000},{"$f":"$CG$27*CK21","v":52500},{"$f":"$CG$27*CL21","v":63000},{"$f":"$CG$27*CM21","v":73500}]
[null,"Brændstof",{"$f":"+C26*C27","v":105},"kr/eff.time",{"$f":"+E13","v":500},{"$f":"+(($F$22*E28))-$C$17-($C$31*E28)","v":32454.292480047443},{"$f":"+(($G$22*E28))-$C$17-($C$31*E28)","v":20957.075199524872},{"$f":"+E28*$H$17","v":500},{"$f":"+(($I$22*H28))-$C$17-((H28/$H$17)*$C$31)","v":32454.292480047443},{"$f":"+(($J$22*H28))-$C$17-((H28/$H$17)*$C$31)","v":20957.075199524872},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,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,{"$f":"C25","v":165},"Traktoromk.",{"$f":"$CG$28*CI21","v":49500},{"$f":"$CG$28*CJ21","v":66000},{"$f":"$CG$28*CK21","v":82500},{"$f":"$CG$28*CL21","v":99000},{"$f":"$CG$28*CM21","v":115500}]
[null,"Traktor i alt",{"$f":"IF(C25=0,0,C25+C28)","v":270},"kr/eff.time",{"$f":"+E14","v":600},{"$f":"+(($F$22*E29))-$C$17-($C$31*E29)","v":45801.235936151992},{"$f":"+(($G$22*E29))-$C$17-($C$31*E29)","v":32004.575199524872},{"$f":"+E29*$H$17","v":600},{"$f":"+(($I$22*H29))-$C$17-((H29/$H$17)*$C$31)","v":45801.235936151992},{"$f":"+(($J$22*H29))-$C$17-((H29/$H$17)*$C$31)","v":32004.575199524872},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,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,{"$f":"C28","v":105},"Administrationsomkostning",{"$f":"(CI28+CI27+CI26+CI25+CI24+CI23)*$I$19/100","v":20843.792480047512},{"$f":"(CJ28+CJ27+CJ26+CJ25+CJ24+CJ23)*$I$19/100","v":26649.042480047512},{"$f":"(CK28+CK27+CK26+CK25+CK24+CK23)*$I$19/100","v":32454.292480047512},{"$f":"(CL28+CL27+CL26+CL25+CL24+CL23)*$I$19/100","v":38259.542480047516},{"$f":"(CM28+CM27+CM26+CM25+CM24+CM23)*$I$19/100","v":44064.792480047516}]
[null,"Vareforbrug ",0,"kr/eff.time",{"$f":"+E15","v":700},{"$f":"+(($F$22*E30))-$C$17-($C$31*E30)","v":59148.179392256483},{"$f":"+(($G$22*E30))-$C$17-($C$31*E30)","v":43052.075199524872},{"$f":"+E30*$H$17","v":700},{"$f":"+(($I$22*H30))-$C$17-((H30/$H$17)*$C$31)","v":59148.179392256483},{"$f":"+(($J$22*H30))-$C$17-((H30/$H$17)*$C$31)","v":43052.075199524872}]
[null,"Driftsomk.ialt ",{"$f":"$C$24+$C$23+$C$25+C28+C30","v":580.52499999999998},"kr/eff.time"]
[null,"Driftsomk. Ex løn",{"$f":"+C31-C23","v":295},"kr/eff.time",null,"0-punktsberegning",null,null,null,"tm2023"]
[null,null,null,null,null,null,"Kommentar"]
[null,"Driftsøkonomi på årsbasis.","Totaler","kr./time","kr./enhed","%"]
[null,"Omsætning",{"$f":"G22*E13","v":345500},{"$f":"C35/$E$13","v":691},{"$f":"D35/$H$17","v":691},{"$f":"C35/$C$35*100","v":100}]
[null,"Forrentning+afskrivning",{"$f":"C11","v":26780.424800475113},53.560849600950228,53.560849600950228,7.7512083358828114]
[null,"Forsikring/vægtafgift/oa.",{"$f":"C15+C14+C13","v":7500},15,15,2.1707670043415339]
[null,"Løn",{"$f":"C23*E13","v":142762.5},285.52499999999998,285.52499999999998,41.320549927641096,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,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,"År","Husleje+forsikring+vægtafgift","Rep./vedligehold","Arbejdsløn","Traktoromkostning","Brændstof","Vareforbrug","Afskriv/forrent","Administration","Gns. kostpris for perioden","Gns. salgspris for perioden",null,null,"kostpris","primoværdi","afskriv","Forrentning","Faste omk pr. time"]
[null,"Rep/vedligeholdelse",{"$f":"C24*E13","v":12500},25,25,3.6179450072358899,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,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,1,{"$f":"IF(CG39=\"\",\"\",($C$13+$C$14+$C$15)/$E$13)","v":15},{"$f":"IF(CG39=\"\",\"\",$C$24)","v":25},{"$f":"IF(CG39=\"\",\"\",$C$23)","v":285.52499999999998},{"$f":"IF(CG39=\"\",\"\",$C$25)","v":165},{"$f":"IF(CG39=\"\",\"\",$C$28)","v":105},{"$f":"IF(CG39=\"\",\"\",$C$30)","v":0},{"$f":"IF(CG39=\"\",\"\",CX39)","v":76},{"$f":"IF(CG39=\"\",\"\",SUM(CH39:CN39)*$I$19/100)","v":67.152500000000003},{"$f":"IF(CG39=\"\",\"\",$F$22)","v":713.99443456104518},{"$f":"IF(CG39=\"\",\"\",$G$22)","v":691},null,null,{"$f":"SUM(CH39:CO39)","v":738.67750000000001},{"$f":"$C$5*(100-$C$8)/100","v":170000},{"$f":"C5-CU39","v":30000},{"$f":"C5*(($C$7/100))","v":8000},{"$f":"(CW39+CV39)/$E$13","v":76}]
[null,"Traktor ",{"$f":"C25*E13","v":82500},165,165,23.878437047756872,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,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,{"$f":"IF(OR(CG39>=$C$6,CG39=\"\"),\"\",+CG39+1)","v":2},15,25,285.52499999999998,165,105,0,64.599999999999994,66.012500000000003,713.99443456104518,691,null,null,726.13750000000005,{"$f":"CU39*(100-$C$8)/100","v":144500},{"$f":"CU39-CU40","v":25500},{"$f":"CU39*(($C$7/100))","v":6800},64.599999999999994,{"$f":"CX39/CX40*100","v":117.64705882352942}]
[null,"Brændstof",{"$f":"C28*E13","v":52500},105,105,15.195369030390736,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,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,3,15,25,285.52499999999998,165,105,0,54.91,65.043499999999995,713.99443456104518,691,null,null,715.47849999999994,122825,21675,5780,54.91,117.64705882352942]
[null,"Vareforbrug",{"$f":"C30*E13","v":0},0,0,0,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,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,4,15,25,285.52499999999998,165,105,0,46.673499999999997,64.219849999999994,713.99443456104518,691,null,null,706.41834999999992,104401.25,18423.75,4913,46.673499999999997,117.64705882352942]
[null,"Administrationsomk.",{"$f":"F28","v":32454.292480047443},64.908584960094885,64.908584960094885,9.3934276353248745,"Adm. omk. tillægges med procentdel.",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,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,5,15,25,285.52499999999998,165,105,0,39.672474999999999,63.519747499999994,713.99443456104518,691,null,null,698.71722249999993,88741.0625,15660.1875,4176.05,39.672474999999999,117.64705882352942]
[null,"Gns. Fortjeneste",{"$f":"C35-SUM(C36:C43)","v":-11497.217280522571},{"$f":"D35-SUM(D36:D43)","v":-22.994434561045182},-22.994434561045182,-3.3277039885738269,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,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,6,15,25,285.52499999999998,165,105,0,33.721603750000007,62.924660374999995,713.99443456104518,691,null,null,692.17126412499999,75429.903124999997,13311.159375000003,3549.6424999999999,33.721603750000007,117.64705882352939]
[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,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,0,64115.41765625,11314.485468749997,3017.1961249999999,28.663363187499996,117.64705882352946]
[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,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,0,54498.105007812504,9617.3126484374952,2564.6167062499999,24.363858709374988,117.64705882352946]
[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,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,0,46323.389256640628,8174.715751171876,2179.9242003125,20.709279902968753,117.64705882352932]
[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,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,0,39374.880868144537,6948.5083884960914,1852.9355702656251,17.602887917523432,117.64705882352946]
[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,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,0,33468.648737922857,5906.2321302216806,1574.9952347257815,14.962454729894924,117.64705882352935]
[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,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,0,28448.351427234429,5020.2973106884274,1338.7459495169144,12.718086520410683,117.64705882352943]
[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,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,0,24181.098713149266,4267.2527140851635,1137.9340570893771,10.810373542349081,117.64705882352939]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B68=\"\",\"\",$G$22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B69=\"\",\"\",$G$22)","v":""}]

{"sheet":"Selvkørende","index":3,"n_rows":69,"n_cols":137,"rows_kept":69,"cut":false,"hidden":false,"merged":[[38,6,38,9],[32,6,32,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[37,6,37,9]]}
[]
[null,"Kalkulatus 2023",null,null,null,"     Maskinkalkulation"]
[null,"Maskintype","2 tons minigraver"]
[]
[null,"Pris ",350000,"kr","Omkostninger - udnyttelse"]
[null,"Periode",8,"år",100,"(interval i skema)"]
[null,"Kalkulationsrente",4,"%","timer/","kr/","kr/",null,"kr/","kr/eff.time"]
[null,"Værditab",15,"%p.a","år","eff.time",{"$f":"+F17","v":"time"},{"$f":"+F17","v":"time"},"eff.time","ex. Traktor"]
[null,"Gns. Årligt værditab",{"$f":"+(C5-C10)/C6","v":31828.53952954102},"kr/år",null,"i alt",null,"i alt","excl.diesel","excl.løn"]
[null,"Restværdi ",{"$f":"((1-C8/100)^C6)*C5","v":95371.683763671841},"kr",null,null,null,null,null,"excl.diesel"]
[null,"Værditab+forrentn.",{"$f":"((1-(1-$C$8/100)^$C$6)*($C$7/(1-((1+$C$7/100)^(-$C$6))))+(100*(1-$C$8/100)^$C$6)*($C$7/100))*(C5/100)","v":41634.259138833491},"kr/år",400,{"$f":"($C$17/E11+$C$29)*(1+($I$19/100))","v":593.57171263179214},{"$f":"+F11/$H$17","v":593.57171263179214},{"$f":"+E11*$H$17","v":400},{"$f":"($C$17/E11+($C$29-$C$27))*(1+($I$19/100))","v":516.57171263179202},{"$f":"($C$17/E11+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":202.4942126317921}]
[null,"Kapitalomkostninger",{"$f":"+C11/C5","v":0.11895502611095284},null,{"$f":"+$E$6+E11","v":500},{"$f":"($C$17/E12+$C$29)*(1+($I$19/100))","v":564.07287010543371},{"$f":"+F12/$H$17","v":564.07287010543371},{"$f":"+E12*$H$17","v":500},{"$f":"($C$17/E12+($C$29-$C$27))*(1+($I$19/100))","v":487.07287010543371},{"$f":"($C$17/E12+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":172.99537010543372}]
[null,"Husleje",2000,"kr/år",{"$f":"+$E$6+E12","v":600},{"$f":"($C$17/E13+$C$29)*(1+($I$19/100))","v":544.40697508786138},{"$f":"+F13/$H$17","v":544.40697508786138},{"$f":"+E13*$H$17","v":600},{"$f":"($C$17/E13+($C$29-$C$27))*(1+($I$19/100))","v":467.40697508786138},{"$f":"($C$17/E13+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":153.32947508786143}]
[null,"Forsikring ",10000,"kr/år",{"$f":"+$E$6+E13","v":700},{"$f":"($C$17/E14+$C$29)*(1+($I$19/100))","v":530.35990721816688},{"$f":"+F14/$H$17","v":530.35990721816688},{"$f":"+E14*$H$17","v":700},{"$f":"($C$17/E14+($C$29-$C$27))*(1+($I$19/100))","v":453.35990721816694},{"$f":"($C$17/E14+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":139.28240721816692}]
[null,"Vægtafgift",null,"kr/år",{"$f":"+$E$6+E14","v":800},{"$f":"($C$17/E15+$C$29)*(1+($I$19/100))","v":519.82460631589606},{"$f":"+F15/$H$17","v":519.82460631589606},{"$f":"+E15*$H$17","v":800},{"$f":"($C$17/E15+($C$29-$C$27))*(1+($I$19/100))","v":442.82460631589606},{"$f":"($C$17/E15+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":128.74710631589605}]
[]
[null,"Faste omkostninger",{"$f":"$C$11+C13+C14+$C$15","v":53634.259138833491},"kr/år","enhed","time","kapacitet",1,"enhed/time"]
[]
[null,"Løn til medarbejder",162,"kr/time","Administration",null,null,null,10,"%",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,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,null,null,null,null,null,null,null,null,null,null,null,"omsætning",{"$f":"DQ21*$G$22","v":220000},{"$f":"DR21*$G$22","v":275000},{"$f":"DS21*$G$22","v":330000},{"$f":"DT21*$G$22","v":385000},{"$f":"DU21*$G$22","v":440000}]
[null,"Sociale omk",41,"%","0 - punktsberegning"]
[null,"Lønomkostning",{"$f":"+C19*(1+C20/100)","v":228.42},"kr/time",null,"kr/time","VÆLG salgspris",null,"kr/enhed","VÆLG salgspris",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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E11","v":400},{"$f":"E12","v":500},{"$f":"E13","v":600},{"$f":"E14","v":700},{"$f":"E15","v":800},null,null,"Under 100 hk","100-150","150-200","200-250","250-300","300-350","Over 350 hk"]
[null,"Effektivitet",80,"%","Kostpris",{"$f":"+F13","v":544.40697508786138},550,"Kostpris",{"$f":"+G13","v":544.40697508786138},{"$f":"G22/H17","v":550},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,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,null,null,null,null,null,null,null,null,null,null,null,"Gns. Fortjeneste pr. år ",{"$f":"DQ19-SUM(DQ23:DQ29)","v":-17428.685052716814},{"$f":"DR19-SUM(DR23:DR29)","v":-7036.4350527168717},{"$f":"DS19-SUM(DS23:DS29)","v":3355.8149472831283},{"$f":"DT19-SUM(DT23:DT29)","v":13748.064947283128},{"$f":"DU19-SUM(DU23:DU29)","v":24140.314947283186},null,"Brændstof",31,51,72,90,113,131,149]
[null,"Lønomkostning",{"$f":"+C21/(C22/100)","v":285.52499999999998},"kr/eff.time","Antal",{"$f":"+C17/((F22/(I19/100+1))-C29)","v":600.00000000000011},{"$f":"+C17/((G22/(I19/100+1))-C29)","v":567.70848519537981},"Antal",{"$f":"+C17/(((+I22*H17)/(I19/100+1))-C29)*H17","v":600.00000000000011},{"$f":"+C17/(((+J22*H17)/(I19/100+1))-C29)*H17","v":567.70848519537981},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C11","v":41634.259138833491},"Værditab+forrentn.",{"$f":"DO23","v":41634.259138833491},{"$f":"DO23","v":41634.259138833491},{"$f":"DO23","v":41634.259138833491},{"$f":"DO23","v":41634.259138833491},{"$f":"DO23","v":41634.259138833491},null,"Løn",15,12,10,11,9,9,9]
[null,"Rep/vedligeh.",50,"kr/eff.time","Driftsresultat fra timepris",null,null,"Driftsresultat fra enhedspris",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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15+C14+C13","v":12000},"Øvrige faste omk.",{"$f":"DO24","v":12000},{"$f":"DO24","v":12000},{"$f":"DO24","v":12000},{"$f":"DO24","v":12000},{"$f":"DO24","v":12000},null,"Rep/vedl",57,35,43,40,33,41,35]
[null,"Brændstofforbrug",10,"liter/time","timer","i alt","kr i alt","enheder","kr/i alt","kr i alt",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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C23","v":285.52499999999998},"Lønomkostning",{"$f":"$DO$25*DQ21","v":114209.99999999999},{"$f":"$DO$25*DR21","v":142762.5},{"$f":"$DO$25*DS21","v":171315},{"$f":"$DO$25*DT21","v":199867.49999999997},{"$f":"$DO$25*DU21","v":228419.99999999997},null,"Afskriv/forrentning",28,59,72,107,121,124,155]
[null,"Brændstofpris",7,"kr/liter",{"$f":"+E11","v":400},{"$f":"+(($F$22*E26))-$C$17-($C$29*E26)","v":1918.5308963110438},{"$f":"+(($G$22*E26))-$C$17-($C$29*E26)","v":4155.7408611665014},{"$f":"+E26*$H$17","v":400},{"$f":"+(($I$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":1918.5308963110438},{"$f":"+(($J$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":4155.7408611665014},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C24","v":50},"Rep/vedligeh.",{"$f":"$DO$26*DQ21","v":20000},{"$f":"$DO$26*DR21","v":25000},{"$f":"$DO$26*DS21","v":30000},{"$f":"$DO$26*DT21","v":35000},{"$f":"$DO$26*DU21","v":40000},null,null,"Under 100 hk","100-150","150-200","200-250","250-300","300-350","Over 350 hk"]
[null,"Brændstof",{"$f":"+C25*C26","v":70},"kr/eff.time",{"$f":"+E12","v":500},{"$f":"+(($F$22*E27))-$C$17-($C$29*E27)","v":15806.728405097208},{"$f":"+(($G$22*E27))-$C$17-($C$29*E27)","v":18603.240861166501},{"$f":"+E27*$H$17","v":500},{"$f":"+(($I$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":15806.728405097208},{"$f":"+(($J$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":18603.240861166501},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C27","v":70},{"$f":"B38","v":"Brændstof"},{"$f":"$DO$27*DQ21","v":28000},{"$f":"$DO$27*DR21","v":35000},{"$f":"$DO$27*DS21","v":42000},{"$f":"$DO$27*DT21","v":49000},{"$f":"$DO$27*DU21","v":56000},null,"Timer",303,361,572,659,659,826,1024]
[null,"Vareforbrug ",0,"kr/eff.time",{"$f":"+E13","v":600},{"$f":"+(($F$22*E28))-$C$17-($C$29*E28)","v":29694.925913883315},{"$f":"+(($G$22*E28))-$C$17-($C$29*E28)","v":33050.740861166501},{"$f":"+E28*$H$17","v":600},{"$f":"+(($I$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":29694.925913883315},{"$f":"+(($J$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":33050.740861166501},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C28","v":0},"Vareforbrug",{"$f":"$DO$28*DQ21","v":0},{"$f":"$DO$28*DR21","v":0},{"$f":"$DO$28*DS21","v":0},{"$f":"$DO$28*DT21","v":0},{"$f":"$DO$28*DU21","v":0}]
[null,"Driftsomk.ialt ",{"$f":"$C$24+$C$23+C27+C28","v":405.52499999999998},"kr/eff.time",{"$f":"+E14","v":700},{"$f":"+(($F$22*E29))-$C$17-($C$29*E29)","v":43583.12342266948},{"$f":"+(($G$22*E29))-$C$17-($C$29*E29)","v":47498.240861166501},{"$f":"+E29*$H$17","v":700},{"$f":"+(($I$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":43583.12342266948},{"$f":"+(($J$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":47498.240861166501},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C27","v":70},"Administrationsomkostning",{"$f":"(DQ27+DQ26+DQ25+DQ24+DQ23)*$I$19/100","v":21584.425913883351},{"$f":"(DR27+DR26+DR25+DR24+DR23)*$I$19/100","v":25639.675913883351},{"$f":"(DS27+DS26+DS25+DS24+DS23)*$I$19/100","v":29694.925913883351},{"$f":"(DT27+DT26+DT25+DT24+DT23)*$I$19/100","v":33750.175913883351},{"$f":"(DU27+DU26+DU25+DU24+DU23)*$I$19/100","v":37805.425913883351}]
[null,"Driftsomk. Ex løn",{"$f":"+C29-C23","v":120},"kr/eff.time",{"$f":"+E15","v":800},{"$f":"+(($F$22*E30))-$C$17-($C$29*E30)","v":57471.320931455586},{"$f":"+(($G$22*E30))-$C$17-($C$29*E30)","v":61945.740861166501},{"$f":"+E30*$H$17","v":800},{"$f":"+(($I$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":57471.320931455586},{"$f":"+(($J$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":61945.740861166501},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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ22/DQ19*100","v":-7.9221295694167333},{"$f":"DR22/DR19*100","v":-2.558703655533408},{"$f":"DS22/DS19*100","v":1.0169136203888267},{"$f":"DT22/DT19*100","v":3.5709259603332799},{"$f":"DU22/DU19*100","v":5.4864352152916327}]
[null,null,null,null,null,null,null,null,null,"tm2023"]
[null,"Driftsøkonomi på årsbasis.","Totaler","kr./time","kr./enhed","%","Kommentar"]
[null,"Omsætning",{"$f":"G22*E13","v":330000},{"$f":"C33/$E$13","v":550},{"$f":"D33/$H$17","v":550},{"$f":"C33/$C$33*100","v":100}]
[null,"Forrentning+afskrivning",{"$f":"C11","v":41634.259138833491},69.390431898055823,69.390431898055823,12.616442163282876]
[null,"Forsikring/vægtafgift/oa.",{"$f":"C15+C14+C13","v":12000},20,20,3.6363636363636362]
[null,"Løn",{"$f":"C23*E13","v":171315},285.52499999999998,285.52499999999998,51.913636363636364]
[null,"Rep/vedligeholdelse",{"$f":"C24*E13","v":30000},50,50,9.0909090909090917]
[null,"Brændstof",{"$f":"C27*E13","v":42000},70,70,12.727272727272727,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"År","Husleje+forsikring+vægtafgift","Rep./vedligehold","Arbejdsløn","Kolonne1","Brændstof","Vareforbrug","Afskriv/forrent","Administration","Gns. kostpris for perioden","Gns. salgspris for perioden",null,null,"kostpris","primoværdi","afskriv","Forrentning","Faste omk pr. time"]
[null,"Vareforbrug",{"$f":"C28*E13","v":0},0,0,0,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(DO39=\"\",\"\",($C$13+$C$14+$C$15)/$E$13)","v":20},{"$f":"IF(DO39=\"\",\"\",$C$24)","v":50},{"$f":"IF(DO39=\"\",\"\",$C$23)","v":285.52499999999998},null,{"$f":"IF(DO39=\"\",\"\",$C$27)","v":70},{"$f":"IF(DO39=\"\",\"\",$C$28)","v":0},{"$f":"IF(DO39=\"\",\"\",EF39)","v":110.83333333333333},{"$f":"IF(DO39=\"\",\"\",SUM(DP39:DV39)*$I$19/100)","v":53.635833333333338},{"$f":"IF(DO39=\"\",\"\",$F$22)","v":544.40697508786138},{"$f":"IF(DO39=\"\",\"\",$G$22)","v":550},null,null,{"$f":"SUM(DP39:DW39)","v":589.99416666666673},{"$f":"$C$5*(100-$C$8)/100","v":297500},{"$f":"C5-EC39","v":52500},{"$f":"C5*(($C$7/100))","v":14000},{"$f":"(EE39+ED39)/$E$13","v":110.83333333333333}]
[null,"Administrationsomk.",{"$f":"F28","v":29694.925913883315},49.491543189805526,49.491543189805526,8.9984623981464598,"Adm. omk. tillægges med procentdel.",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DO39>=$C$6,DO39=\"\"),\"\",+DO39+1)","v":2},20,50,285.52499999999998,null,70,0,94.208333333333329,51.973333333333336,544.40697508786138,550,null,null,571.70666666666671,{"$f":"EC39*(100-$C$8)/100","v":252875},{"$f":"EC39-EC40","v":44625},{"$f":"EC39*(($C$7/100))","v":11900},94.208333333333329,{"$f":"EF39/EF40*100","v":117.64705882352942}]
[null,"Gns. Fortjeneste",{"$f":"C33-SUM(C34:C40)","v":3355.8149472831865},{"$f":"D33-SUM(D34:D40)","v":5.5930249121387305},5.5930249121387305,1.0169136203888443,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DO40>=$C$6,DO40=\"\"),\"\",+DO40+1)","v":3},20,50,285.52499999999998,null,70,0,80.077083333333334,50.560208333333328,544.40697508786138,550,null,null,556.16229166666665,{"$f":"EC40*(100-$C$8)/100","v":214943.75},{"$f":"EC40-EC41","v":37931.25},{"$f":"EC40*(($C$7/100))","v":10115},80.077083333333334,{"$f":"EF40/EF41*100","v":117.64705882352939}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20,50,285.52499999999998,null,70,0,68.065520833333338,49.359052083333324,544.40697508786138,550,null,null,542.94957291666663,182702.1875,32241.5625,8597.75,68.065520833333338,117.64705882352942]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,20,50,285.52499999999998,null,70,0,57.855692708333336,48.33806927083333,544.40697508786138,550,null,null,531.71876197916663,155296.859375,27405.328125,7308.0875000000005,57.855692708333336,117.64705882352942]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,20,50,285.52499999999998,null,70,0,49.17733880208332,47.470233880208333,544.40697508786138,550,null,null,522.17257268229162,132002.33046875001,23294.528906249994,6211.8743750000003,49.17733880208332,117.64705882352946]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,20,50,285.52499999999998,null,70,0,41.800737981770844,46.732573798177079,544.40697508786138,550,null,null,514.05831177994787,112201.9808984375,19800.349570312508,5280.0932187500002,41.800737981770844,117.64705882352935]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,20,50,285.52499999999998,null,70,0,35.530627284505215,46.105562728450522,544.40697508786138,550,null,null,507.16119001295573,95371.68376367187,16830.297134765628,4488.0792359375,35.530627284505215,117.64705882352942]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,81065.9311991211,14305.75256455077,3814.8673505468751,30.20103319182941,117.64705882352951]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DO47>=$C$6,DO47=\"\"),\"\",+DO47+1)","v":""},"","","",null,"","","","","","",null,null,0,68906.041519252933,12159.889679868167,3242.6372479648439,25.670878213055019,117.64705882352932]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DO48>=$C$6,DO48=\"\"),\"\",+DO48+1)","v":""},"","","",null,"","","","","","",null,null,0,58570.135291364997,10335.906227887936,2756.2416607701175,21.820246481096756,117.64705882352946]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,49784.614997660246,8785.5202937047507,2342.8054116546,18.547209508932252,117.64705882352935]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(DO51=\"\",\"\",#REF!)","v":""},"","","",{"$f":"IF(DO51=\"\",\"\",SUM(DP51:DV51)*$I$19/100)","v":""},"","",null,null,0,42316.922748011209,7467.692249649037,1991.3845999064099,15.765128082592412,117.64705882352942]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B65=\"\",\"\",$G$22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B66=\"\",\"\",$G$22)","v":""}]

{"sheet":"Bil alene","index":4,"n_rows":69,"n_cols":137,"rows_kept":69,"cut":false,"hidden":false,"merged":[[38,6,38,9],[32,6,32,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[37,6,37,9]]}
[]
[null,"Kalkulatus 2023",null,null,null,"     Maskinkalkulation"]
[null,"Maskintype","Varebil uden mand "]
[]
[null,"Pris ",325000,"kr","Omkostninger - udnyttelse"]
[null,"Periode",7,"år",100,"(interval i skema)"]
[null,"Kalkulationsrente",4,"%","timer/","kr/","kr/",null,"kr/","kr/eff.time"]
[null,"Værditab",20,"%p.a","år","eff.time",{"$f":"+F17","v":"km"},{"$f":"+F17","v":"km"},"eff.time","ex. Traktor"]
[null,"Gns. Årligt værditab",{"$f":"+(C5-C10)/C6","v":36691.794285714277},"kr/år",null,"i alt",null,"i alt","excl.diesel","excl.løn"]
[null,"Restværdi ",{"$f":"((1-C8/100)^C6)*C5","v":68157.440000000046},"kr",null,null,null,null,null,"excl.diesel"]
[null,"Værditab+forrentn.",{"$f":"((1-(1-$C$8/100)^$C$6)*($C$7/(1-((1+$C$7/100)^(-$C$6))))+(100*(1-$C$8/100)^$C$6)*($C$7/100))*(C5/100)","v":45518.736876833063},"kr/år",200,{"$f":"($C$17/E11+$C$29)*(1+($I$19/100))","v":407.59368438416533},{"$f":"+F11/$H$17","v":6.7932280730694226},{"$f":"+E11*$H$17","v":12000},{"$f":"($C$17/E11+($C$29-$C$27))*(1+($I$19/100))","v":362.59368438416533},{"$f":"($C$17/E11+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":362.59368438416533}]
[null,"Kapitalomkostninger",{"$f":"+C11/C5","v":0.14005765192871711},null,{"$f":"+$E$6+E11","v":300},{"$f":"($C$17/E12+$C$29)*(1+($I$19/100))","v":295.06245625611018},{"$f":"+F12/$H$17","v":4.9177076042685028},{"$f":"+E12*$H$17","v":18000},{"$f":"($C$17/E12+($C$29-$C$27))*(1+($I$19/100))","v":250.06245625611021},{"$f":"($C$17/E12+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":250.06245625611021}]
[null,"Husleje",2000,"kr/år",{"$f":"+$E$6+E12","v":400},{"$f":"($C$17/E13+$C$29)*(1+($I$19/100))","v":238.79684219208266},{"$f":"+F13/$H$17","v":3.9799473698680443},{"$f":"+E13*$H$17","v":24000},{"$f":"($C$17/E13+($C$29-$C$27))*(1+($I$19/100))","v":193.79684219208266},{"$f":"($C$17/E13+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":193.79684219208266}]
[null,"Forsikring ",10000,"kr/år",{"$f":"+$E$6+E13","v":500},{"$f":"($C$17/E14+$C$29)*(1+($I$19/100))","v":205.03747375366612},{"$f":"+F14/$H$17","v":3.4172912292277688},{"$f":"+E14*$H$17","v":30000},{"$f":"($C$17/E14+($C$29-$C$27))*(1+($I$19/100))","v":160.03747375366612},{"$f":"($C$17/E14+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":160.03747375366612}]
[null,"Vægtafgift",10000,"kr/år",{"$f":"+$E$6+E14","v":600},{"$f":"($C$17/E15+$C$29)*(1+($I$19/100))","v":182.53122812805509},{"$f":"+F15/$H$17","v":3.0421871354675849},{"$f":"+E15*$H$17","v":36000},{"$f":"($C$17/E15+($C$29-$C$27))*(1+($I$19/100))","v":137.53122812805509},{"$f":"($C$17/E15+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":137.53122812805509}]
[]
[null,"Faste omkostninger",{"$f":"$C$11+C13+C14+$C$15","v":67518.736876833063},"kr/år","enhed","km","kapacitet",60,"enhed/time"]
[]
[null,"Løn til medarbejder",0,"kr/time","Administration",null,null,null,0,"%",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,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,null,null,null,null,null,null,null,null,null,null,null,"omsætning",{"$f":"DQ21*$G$22","v":47800},{"$f":"DR21*$G$22","v":71700},{"$f":"DS21*$G$22","v":95600},{"$f":"DT21*$G$22","v":119500},{"$f":"DU21*$G$22","v":143400}]
[null,"Sociale omk",45,"%","0 - punktsberegning"]
[null,"Lønomkostning",{"$f":"+C19*(1+C20/100)","v":0},"kr/time",null,"kr/time","VÆLG salgspris",null,"kr/enhed","VÆLG salgspris",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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E11","v":200},{"$f":"E12","v":300},{"$f":"E13","v":400},{"$f":"E14","v":500},{"$f":"E15","v":600},null,null,"Under 100 hk","100-150","150-200","200-250","250-300","300-350","Over 350 hk"]
[null,"Effektivitet",80,"%","Kostpris",{"$f":"+F13","v":238.79684219208266},239,"Kostpris",{"$f":"+G13","v":3.9799473698680443},{"$f":"G22/H17","v":3.9833333333333334},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,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,null,null,null,null,null,null,null,null,null,null,null,"Gns. Fortjeneste pr. år ",{"$f":"DQ19-SUM(DQ23:DQ29)","v":-33718.736876833063},{"$f":"DR19-SUM(DR23:DR29)","v":-16818.736876833063},{"$f":"DS19-SUM(DS23:DS29)","v":81.263123166936566},{"$f":"DT19-SUM(DT23:DT29)","v":16981.263123166937},{"$f":"DU19-SUM(DU23:DU29)","v":33881.263123166937},null,"Brændstof",31,51,72,90,113,131,149]
[null,"Lønomkostning",{"$f":"+C21/(C22/100)","v":0},"kr/eff.time","Antal",{"$f":"+C17/((F22/(I19/100+1))-C29)","v":400},{"$f":"+C17/((G22/(I19/100+1))-C29)","v":399.51915311735542},"Antal",{"$f":"+C17/(((+I22*H17)/(I19/100+1))-C29)*H17","v":24000},{"$f":"+C17/(((+J22*H17)/(I19/100+1))-C29)*H17","v":23971.149187041327},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C11","v":45518.736876833063},"Værditab+forrentn.",{"$f":"DO23","v":45518.736876833063},{"$f":"DO23","v":45518.736876833063},{"$f":"DO23","v":45518.736876833063},{"$f":"DO23","v":45518.736876833063},{"$f":"DO23","v":45518.736876833063},null,"Løn",15,12,10,11,9,9,9]
[null,"Rep/vedligeh.",25,"kr/eff.time","Driftsresultat fra timepris",null,null,"Driftsresultat fra enhedspris",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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15+C14+C13","v":22000},"Øvrige faste omk.",{"$f":"DO24","v":22000},{"$f":"DO24","v":22000},{"$f":"DO24","v":22000},{"$f":"DO24","v":22000},{"$f":"DO24","v":22000},null,"Rep/vedl",57,35,43,40,33,41,35]
[null,"Brændstofforbrug",5,"liter/time","timer","i alt","kr i alt","enheder","kr/i alt","kr i alt",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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C23","v":0},"Lønomkostning",{"$f":"$DO$25*DQ21","v":0},{"$f":"$DO$25*DR21","v":0},{"$f":"$DO$25*DS21","v":0},{"$f":"$DO$25*DT21","v":0},{"$f":"$DO$25*DU21","v":0},null,"Afskriv/forrentning",28,59,72,107,121,124,155]
[null,"Brændstofpris",9,"kr/liter",{"$f":"+E11","v":200},{"$f":"+(($F$22*E26))-$C$17-($C$29*E26)","v":-33759.368438416532},{"$f":"+(($G$22*E26))-$C$17-($C$29*E26)","v":-33718.736876833063},{"$f":"+E26*$H$17","v":12000},{"$f":"+(($I$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":-33759.368438416532},{"$f":"+(($J$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":-33718.736876833063},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C24","v":25},"Rep/vedligeh.",{"$f":"$DO$26*DQ21","v":5000},{"$f":"$DO$26*DR21","v":7500},{"$f":"$DO$26*DS21","v":10000},{"$f":"$DO$26*DT21","v":12500},{"$f":"$DO$26*DU21","v":15000},null,null,"Under 100 hk","100-150","150-200","200-250","250-300","300-350","Over 350 hk"]
[null,"Brændstof",{"$f":"+C25*C26","v":45},"kr/eff.time",{"$f":"+E12","v":300},{"$f":"+(($F$22*E27))-$C$17-($C$29*E27)","v":-16879.684219208269},{"$f":"+(($G$22*E27))-$C$17-($C$29*E27)","v":-16818.736876833063},{"$f":"+E27*$H$17","v":18000},{"$f":"+(($I$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":-16879.684219208269},{"$f":"+(($J$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":-16818.736876833063},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C27","v":45},{"$f":"B38","v":"Brændstof"},{"$f":"$DO$27*DQ21","v":9000},{"$f":"$DO$27*DR21","v":13500},{"$f":"$DO$27*DS21","v":18000},{"$f":"$DO$27*DT21","v":22500},{"$f":"$DO$27*DU21","v":27000},null,"Timer",303,361,572,659,659,826,1024]
[null,"Vareforbrug ",0,"kr/eff.time",{"$f":"+E13","v":400},{"$f":"+(($F$22*E28))-$C$17-($C$29*E28)","v":0},{"$f":"+(($G$22*E28))-$C$17-($C$29*E28)","v":81.263123166936566},{"$f":"+E28*$H$17","v":24000},{"$f":"+(($I$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":0},{"$f":"+(($J$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":81.263123166936566},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C28","v":0},"Vareforbrug",{"$f":"$DO$28*DQ21","v":0},{"$f":"$DO$28*DR21","v":0},{"$f":"$DO$28*DS21","v":0},{"$f":"$DO$28*DT21","v":0},{"$f":"$DO$28*DU21","v":0}]
[null,"Driftsomk.ialt ",{"$f":"$C$24+$C$23+C27+C28","v":70},"kr/eff.time",{"$f":"+E14","v":500},{"$f":"+(($F$22*E29))-$C$17-($C$29*E29)","v":16879.684219208269},{"$f":"+(($G$22*E29))-$C$17-($C$29*E29)","v":16981.263123166937},{"$f":"+E29*$H$17","v":30000},{"$f":"+(($I$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":16879.684219208269},{"$f":"+(($J$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":16981.263123166937},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,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,null,null,null,null,null,null,null,null,null,null,{"$f":"C27","v":45},"Administrationsomkostning",{"$f":"(DQ27+DQ26+DQ25+DQ24+DQ23)*$I$19/100","v":0},{"$f":"(DR27+DR26+DR25+DR24+DR23)*$I$19/100","v":0},{"$f":"(DS27+DS26+DS25+DS24+DS23)*$I$19/100","v":0},{"$f":"(DT27+DT26+DT25+DT24+DT23)*$I$19/100","v":0},{"$f":"(DU27+DU26+DU25+DU24+DU23)*$I$19/100","v":0}]
[null,"Driftsomk. Ex løn",{"$f":"+C29-C23","v":70},"kr/eff.time",{"$f":"+E15","v":600},{"$f":"+(($F$22*E30))-$C$17-($C$29*E30)","v":33759.368438416524},{"$f":"+(($G$22*E30))-$C$17-($C$29*E30)","v":33881.263123166937},{"$f":"+E30*$H$17","v":36000},{"$f":"+(($I$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":33759.368438416524},{"$f":"+(($J$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":33881.263123166937},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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ22/DQ19*100","v":-70.54129053730766},{"$f":"DR22/DR19*100","v":-23.457094667828539},{"$f":"DS22/DS19*100","v":8.5003266911021516E-2},{"$f":"DT22/DT19*100","v":14.210262027754759},{"$f":"DU22/DU19*100","v":23.627101201650582}]
[null,null,null,null,null,null,null,null,null,"tm2023"]
[null,"Driftsøkonomi på årsbasis.","Totaler","kr./time","kr./enhed","%","Kommentar"]
[null,"Omsætning",{"$f":"G22*E13","v":95600},{"$f":"C33/$E$13","v":239},{"$f":"D33/$H$17","v":3.9833333333333334},{"$f":"C33/$C$33*100","v":100}]
[null,"Forrentning+afskrivning",{"$f":"C11","v":45518.736876833063},113.79684219208266,1.8966140365347111,47.613741502963457]
[null,"Forsikring/vægtafgift/oa.",{"$f":"C15+C14+C13","v":22000},55,0.91666666666666663,23.01255230125523]
[null,"Løn",{"$f":"C23*E13","v":0},0,0,0]
[null,"Rep/vedligeholdelse",{"$f":"C24*E13","v":10000},25,0.41666666666666669,10.460251046025103]
[null,"Brændstof",{"$f":"C27*E13","v":18000},45,0.75,18.828451882845187,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"År","Husleje+forsikring+vægtafgift","Rep./vedligehold","Arbejdsløn","Kolonne1","Brændstof","Vareforbrug","Afskriv/forrent","Administration","Gns. kostpris for perioden","Gns. salgspris for perioden",null,null,"kostpris","primoværdi","afskriv","Forrentning","Faste omk pr. time"]
[null,"Vareforbrug",{"$f":"C28*E13","v":0},0,0,0,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(DO39=\"\",\"\",($C$13+$C$14+$C$15)/$E$13)","v":55},{"$f":"IF(DO39=\"\",\"\",$C$24)","v":25},{"$f":"IF(DO39=\"\",\"\",$C$23)","v":0},null,{"$f":"IF(DO39=\"\",\"\",$C$27)","v":45},{"$f":"IF(DO39=\"\",\"\",$C$28)","v":0},{"$f":"IF(DO39=\"\",\"\",EF39)","v":195},{"$f":"IF(DO39=\"\",\"\",SUM(DP39:DV39)*$I$19/100)","v":0},{"$f":"IF(DO39=\"\",\"\",$F$22)","v":238.79684219208266},{"$f":"IF(DO39=\"\",\"\",$G$22)","v":239},null,null,{"$f":"SUM(DP39:DW39)","v":320},{"$f":"$C$5*(100-$C$8)/100","v":260000},{"$f":"C5-EC39","v":65000},{"$f":"C5*(($C$7/100))","v":13000},{"$f":"(EE39+ED39)/$E$13","v":195}]
[null,"Administrationsomk.",{"$f":"F28","v":0},0,0,0,"Adm. omk. tillægges med procentdel.",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DO39>=$C$6,DO39=\"\"),\"\",+DO39+1)","v":2},55,25,0,null,45,0,156,0,238.79684219208266,239,null,null,281,{"$f":"EC39*(100-$C$8)/100","v":208000},{"$f":"EC39-EC40","v":52000},{"$f":"EC39*(($C$7/100))","v":10400},156,{"$f":"EF39/EF40*100","v":125}]
[null,"Gns. Fortjeneste",{"$f":"C33-SUM(C34:C40)","v":81.263123166936566},{"$f":"D33-SUM(D34:D40)","v":0.20315780791733573},3.385963465288929E-3,8.5003266911021516E-2,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,55,25,0,null,45,0,124.8,0,238.79684219208266,239,null,null,249.8,166400,41600,8320,124.8,125]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,55,25,0,null,45,0,99.84,0,238.79684219208266,239,null,null,224.84,133120,33280,6656,99.84,125]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,55,25,0,null,45,0,79.872,0,238.79684219208266,239,null,null,204.87200000000001,106496,26624,5324.8,79.872,125]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,55,25,0,null,45,0,63.89759999999999,0,238.79684219208266,239,null,null,188.89759999999998,85196.800000000003,21299.199999999997,4259.84,63.89759999999999,125.00000000000003]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,55,25,0,null,45,0,51.118079999999999,0,238.79684219208266,239,null,null,176.11807999999999,68157.440000000002,17039.36,3407.8720000000003,51.118079999999999,124.99999999999997]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,54525.952000000005,13631.487999999998,2726.2976000000003,40.894463999999992,125.00000000000003]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,43620.761599999998,10905.190400000007,2181.0380800000003,32.715571200000021,124.99999999999989]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,34896.609279999997,8724.1523200000011,1744.8304639999999,26.172456960000005,125.00000000000004]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,27917.287423999998,6979.3218559999987,1395.8643711999998,20.937965567999996,125.00000000000004]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,"","","","","","",null,null,0,22333.829939199997,5583.4574848000011,1116.69149696,16.750372454400004,124.99999999999993]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(DO51=\"\",\"\",#REF!)","v":""},"","","","","","",null,null,0,17867.063951359996,4466.7659878400009,893.35319756799993,13.400297963520002,125.00000000000003]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B65=\"\",\"\",$G$22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B66=\"\",\"\",$G$22)","v":""}]

{"sheet":"Vedligehold & salgsandel (%)","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"Gns.","Gns."]
[null,null,"vedligeholdelse","salgsandel"]
[null,null,"Kr./time","%"]
[null,"Diverse entreprenøropgaver"]
[null,"Gravemaskine              over 15 ton",61,88]
[null,"Gravemaskine              6-  15 ton",48,88]
[null,"Minigraver                             +300 timer",26,97]
[null,"Minegraver                    under 300 timer",51,90]
[null,"Jordvogne",34,77]
[null,"Slamsuger over 15 m3",102,48]
[null,"Slamsuger under 15 m3",41,57]
[null,"Combispuler",45,67]
[null,"Sneplov/fejekost",17,84]
[null,"Saltspreder",19,85]
[null,"Lastbiler+trailer"]
[null,"Lastbiltrækker",111,85]
[null,"Tiptrailer",59,85]
[null,"Lastbil forvogn",140,79]