{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Forklaring","Traktor alene","Traktor og redskab ","Selvkørende","Gns. Traktoromk","GNs. årlige traktortimer."],"not_rendered":{"charts":11,"images":1,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gns. Traktoromk","index":4,"reason":"not_a_worksheet"},{"sheet":"GNs. årlige traktortimer.","index":5,"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":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
["Kalkulatus for Skov-entreprenører"]
[]
[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,"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 350 hk"]
[]
[null,null,"Købspris",1600000,"kr",null,"  Omkostninger         -            Salgspriser"]
[null,null,"Periode",8,"år",null,200,"(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":140156.41457868292},"kr",null,null,"i alt","excl.diesel","excl.løn","excl.løn"]
[null,null,"Restværdi ",{"$f":"((1-D8/100)^D6)*D5","v":478748.68337053672},"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":185686.97457331794},"kr/år",null,600,{"$f":"($D$16/G11+$D$28)*(1+($J$17/100))","v":776.68662428886319},{"$f":"($D$16/G11+($D$28-$D$27))*(1+($J$17/100))","v":696.68662428886319},{"$f":"($D$16/G11+$D$29)*(1+($J$17/100))","v":472.81162428886324},{"$f":"($D$16/G11+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":392.81162428886324}]
[null,null,"Kapitalomkostninger",{"$f":"+D11/D5*100","v":11.605435910832371},"%",null,{"$f":"+$G$6+G11","v":800},{"$f":"($D$16/G12+$D$28)*(1+($J$17/100))","v":690.9837182166475},{"$f":"($D$16/G12+($D$28-$D$27))*(1+($J$17/100))","v":610.9837182166475},{"$f":"($D$16/G12+$D$29)*(1+($J$17/100))","v":387.10871821664745},{"$f":"($D$16/G12+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":307.10871821664745}]
[null,null,"Husleje",0,"kr/år",null,{"$f":"+$G$6+G12","v":1000},{"$f":"($D$16/G13+$D$28)*(1+($J$17/100))","v":639.56197457331791},{"$f":"($D$16/G13+($D$28-$D$27))*(1+($J$17/100))","v":559.56197457331791},{"$f":"($D$16/G13+$D$29)*(1+($J$17/100))","v":335.68697457331791},{"$f":"($D$16/G13+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":255.68697457331794}]
[null,null,"Forsikring ",20000,"kr/år",null,{"$f":"+$G$6+G13","v":1200},{"$f":"($D$16/G14+$D$28)*(1+($J$17/100))","v":605.28081214443159},{"$f":"($D$16/G14+($D$28-$D$27))*(1+($J$17/100))","v":525.28081214443159},{"$f":"($D$16/G14+$D$29)*(1+($J$17/100))","v":301.40581214443159},{"$f":"($D$16/G14+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":221.40581214443162}]
[null,null,"Vægtafgift",0,"kr/år",null,{"$f":"+$G$6+G14","v":1400},{"$f":"($D$16/G15+$D$28)*(1+($J$17/100))","v":580.79426755237},{"$f":"($D$16/G15+($D$28-$D$27))*(1+($J$17/100))","v":500.79426755237},{"$f":"($D$16/G15+$D$29)*(1+($J$17/100))","v":276.91926755237},{"$f":"($D$16/G15+($D$28-$D$23-$D$27))*(1+($J$17/100))","v":196.91926755236997}]
[null,null,"Faste omkostninger",{"$f":"$D$11+D13+D14+$D$15","v":205686.97457331794},"kr/år"]
[]
[]
[null,null,"Løn til medarbejder",170,"kr/time"]
[null,null,"Sociale omk",43,"%"]
[null,null,"Lønomkostning",{"$f":"+D19*(1+D20/100)","v":243.1},"kr/time"]
[null,null,"Effektivitet",80,"%"]
[null,null,"Lønomkostning",{"$f":"+D21/(D22/100)","v":303.875},"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":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FU23","v":1000},{"$f":"FV23","v":1000},{"$f":"FW23","v":1000},{"$f":"FX23","v":1000},{"$f":"FY23","v":1000},700,{"$f":"SUM(FU23:GB23)","v":8000}]
[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",4,"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":1376000},{"$f":"FU26*(100-$D$8)/100","v":1183360},{"$f":"FV26*(100-$D$8)/100","v":1017689.6},875213.05599999998,752683.22815999994,647307.57621759991,556684.51554713596,478748.68337053695,411723.86769866175,354082.52622084907,304510.97254993021,261879.43639294]
[null,null,"Brændstof",{"$f":"+D25*D26","v":80},"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":224000},{"$f":"FU26-FV26","v":192640},{"$f":"FV26-FW26","v":165670.40000000002},142476.54399999999,122529.82784000004,105375.65194240003,90623.06067046395,77935.832176599011,67024.8156718752,57641.341477812675,49571.55367091886,42631.536156990216,null,{"$f":"SUM(FU27:GB27)","v":1121251.3166294631}]
[null,null,"Driftsomk.ialt ",{"$f":"$D$24+$D$27+$D$23","v":433.875},"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":64000},{"$f":"FU26*(($D$7/100))*(1+R7/100)","v":55040},{"$f":"FV26*(($D$7/100))*(1+R7/100)","v":47334.400000000001},{"$f":"FW26*(($D$7/100))*(1+R7/100)","v":40707.584000000003},{"$f":"FX26*(($D$7/100))*(1+R7/100)","v":35008.522239999998},{"$f":"FY26*(($D$7/100))*(1+R7/100)","v":30107.3291264},{"$f":"FZ26*(($D$7/100))*(1+R7/100)","v":25892.303048703998},{"$f":"GA26*(($D$7/100))*(1+R7/100)","v":22267.380621885441},{"$f":"GB26*(($D$7/100))*(1+S7/100)","v":19149.947334821478},{"$f":"GC26*(($D$7/100))*(1+T7/100)","v":16468.954707946472},{"$f":"GD26*(($D$7/100))*(1+U7/100)","v":14163.301048833964},{"$f":"GE26*(($D$7/100))*(1+V7/100)","v":12180.43890199721},null,{"$f":"SUM(FU28:GB28)","v":320357.51903698937}]
[null,null,"Driftsomk. Ex løn",{"$f":"+D28-D23","v":130},"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":288},{"$f":"(FV28+FV27)/FV23","v":247.68},213.00480000000002,183.18412799999999,157.53835008000004,135.48298106880003,116.51536371916795,100.20321279848446,86.174763006696679,74.11029618575914,63.734854719752825,54.811975058987422]
[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":20000},{"$f":"$D$15+$D$14+$D$13","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,{"$f":"SUM(FU30:GB30)","v":160000}]
[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":185686.97457331794},{"$f":"D32/G13","v":185.68697457331794},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":20000},{"$f":"D33/G13","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":20},{"$f":"FV30/FV23","v":20},20,20,20,20,20,20,20,20,20,20,28.571428571428573]
[null,null,"Løn",{"$f":"D23*G13","v":303875},{"$f":"D34/G13","v":303.875},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":50000},{"$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":303.875},{"$f":"$D$23","v":303.875},303.875,303.875,303.875,303.875,303.875,303.875,303.875,303.875,303.875,303.875,303.875]
[null,null,"Brændstof",{"$f":"D27*G13","v":80000},{"$f":"D36/G13","v":80},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":80},{"$f":"$D$27","v":80},80,80,80,80,80,80,80,80,80,80,80]
[null,null,"Total omk.",{"$f":"SUM(D32:D36)","v":639561.97457331792},{"$f":"D37/G13","v":639.56197457331791},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":288},247.68,213.00480000000002,183.18412799999999,157.53835008000004,135.48298106880003,116.51536371916795,100.20321279848446,86.174763006696679,74.11029618575914,63.734854719752825,54.811975058987422,{"$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":741.875},701.55500000000006,666.87980000000005,637.05912799999999,611.4133500800001,589.35798106879997,570.39036371916791,554.0782127984844,540.04976300669671,527.98529618575913,517.60985471975278,508.6869750589874,462.44642857142856]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":639.56197457331791},{"$f":"FN41","v":639.56197457331791},{"$f":"FO41","v":639.56197457331791},639.56197457331791,639.56197457331791,639.56197457331791,639.56197457331791,639.56197457331791]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":20},{"$f":"IF(FA46=\"\",\"\",$D$24)","v":50},{"$f":"IF(FA46=\"\",\"\",$D$23)","v":303.875},{"$f":"IF(FA46=\"\",\"\",$D$27)","v":80},{"$f":"IF(FA46=\"\",\"\",FP46)","v":288},{"$f":"IF(FA46=\"\",\"\",SUM(FB46:FF46)*$J$17/100)","v":0},{"$f":"IF(FA46=\"\",\"\",$FO$41)","v":639.56197457331791},{"$f":"SUM(FB46:FG46)","v":741.875},null,null,null,{"$f":"$D$5*(100-$D$8)/100","v":1376000},{"$f":"D5-FM46","v":224000},{"$f":"D5*(($D$7/100))","v":64000},{"$f":"(FO46+FN46)/$G$13","v":288}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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},20,50,303.875,{"$f":"IF(FA47=\"\",\"\",$D$27)","v":80},247.68,{"$f":"IF(FA47=\"\",\"\",SUM(FB47:FF47)*$J$17/100)","v":0},{"$f":"IF(FA47=\"\",\"\",$FO$41)","v":639.56197457331791},701.55500000000006,null,null,null,{"$f":"FM46*(100-$D$8)/100","v":1183360},{"$f":"FM46-FM47","v":192640},{"$f":"FM46*(($D$7/100))","v":55040},247.68,{"$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},20,50,303.875,80,213.00480000000002,0,639.56197457331791,666.87980000000005,null,null,null,1017689.6,165670.40000000002,47334.400000000001,213.00480000000002,116.27906976744184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,303.875,80,183.18412799999999,0,639.56197457331791,637.05912799999999,null,null,null,875213.05599999998,142476.54399999999,40707.584000000003,183.18412799999999,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,5,20,50,303.875,80,157.53835008000004,0,639.56197457331791,611.4133500800001,null,null,null,752683.22815999994,122529.82784000004,35008.522239999998,157.53835008000004,116.27906976744183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,303.875,80,135.48298106880003,0,639.56197457331791,589.35798106879997,null,null,null,647307.57621759991,105375.65194240003,30107.3291264,135.48298106880003,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,7,20,50,303.875,80,116.51536371916795,0,639.56197457331791,570.39036371916791,null,null,null,556684.51554713596,90623.06067046395,25892.303048703998,116.51536371916795,116.27906976744194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,303.875,80,100.20321279848446,0,639.56197457331791,554.0782127984844,null,null,null,478748.68337053695,77935.832176599011,22267.380621885441,100.20321279848446,116.27906976744184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,411723.86769866175,67024.8156718752,19149.947334821478,86.174763006696679,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(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,354082.52622084907,57641.341477812675,16468.954707946472,74.11029618575914,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(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,304510.97254993021,49571.55367091886,14163.301048833964,63.734854719752825,116.27906976744194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,261879.43639294,42631.536156990216,12180.43890199721,54.811975058987422,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,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","F.eks. Udkører"]
[]
[null,"Pris ",1000000,"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":"m3"},{"$f":"+F17","v":"m3"},"eff.time","ex. Traktor"]
[null,"Gns. Årligt værditab",{"$f":"+(C5-C10)/C6","v":90938.684370117204},"kr/år",null,"i alt",null,"i alt","excl.diesel","excl.løn"]
[null,"Restværdi ",{"$f":"((1-C8/100)^C6)*C5","v":272490.52503906243},"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":118955.02611095284},"kr/år",600,{"$f":"($C$17/E11+$C$31)*(1+($I$19/100))","v":1027.6993798978658},{"$f":"+F11/$H$17","v":13.70265839863821},{"$f":"+E11*$H$17","v":45000},{"$f":"($C$17/E11+($C$31-$C$28))*(1+($I$19/100))","v":867.19937989786592},{"$f":"($C$17/E11+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":381.55312989786592}]
[null,"Kapitalomkostninger",{"$f":"+C11/C5","v":0.11895502611095284},null,{"$f":"+$E$6+E11","v":700},{"$f":"($C$17/E12+$C$31)*(1+($I$19/100))","v":988.47750419817089},{"$f":"+F12/$H$17","v":13.179700055975612},{"$f":"+E12*$H$17","v":52500},{"$f":"($C$17/E12+($C$31-$C$28))*(1+($I$19/100))","v":827.97750419817089},{"$f":"($C$17/E12+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":342.33125419817083}]
[null,"Husleje",0,"kr/år",{"$f":"+$E$6+E12","v":800},{"$f":"($C$17/E13+$C$31)*(1+($I$19/100))","v":959.06109742339947},{"$f":"+F13/$H$17","v":12.78748129897866},{"$f":"+E13*$H$17","v":60000},{"$f":"($C$17/E13+($C$31-$C$28))*(1+($I$19/100))","v":798.56109742339947},{"$f":"($C$17/E13+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":312.91484742339941}]
[null,"Forsikring ",35000,"kr/år",{"$f":"+$E$6+E13","v":900},{"$f":"($C$17/E14+$C$31)*(1+($I$19/100))","v":936.18166993191062},{"$f":"+F14/$H$17","v":12.482422265758808},{"$f":"+E14*$H$17","v":67500},{"$f":"($C$17/E14+($C$31-$C$28))*(1+($I$19/100))","v":775.68166993191062},{"$f":"($C$17/E14+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":290.03541993191055}]
[null,"Vægtafgift",null,"kr/år",{"$f":"+$E$6+E14","v":1000},{"$f":"($C$17/E15+$C$31)*(1+($I$19/100))","v":917.87812793871967},{"$f":"+F15/$H$17","v":12.238375039182928},{"$f":"+E15*$H$17","v":75000},{"$f":"($C$17/E15+($C$31-$C$28))*(1+($I$19/100))","v":757.37812793871967},{"$f":"($C$17/E15+($C$31-$C$23-$C$28-$C$25))*(1+($I$19/100))","v":271.73187793871955}]
[]
[null,"Faste omkostninger",{"$f":"$C$11+C13+C14+$C$15","v":153955.02611095284},"kr/år","enhed","m3","kapacitet",75,"enhed/time"]
[]
[null,"Løn til medarbejder",170,"kr/time","Administration",null,null,null,7,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":600000},{"$f":"CJ21*$G$22","v":700000},{"$f":"CK21*$G$22","v":800000},{"$f":"CL21*$G$22","v":900000},{"$f":"CM21*$G$22","v":1000000}]
[null,"Sociale omk",43,"%","0 - punktsberegning"]
[null,"Lønomkostning",{"$f":"+C19*(1+C20/100)","v":243.1},"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":600},{"$f":"E12","v":700},{"$f":"E13","v":800},{"$f":"E14","v":900},{"$f":"E15","v":1000}]
[null,"Effektivitet",80,"%","Kostpris",{"$f":"+F13","v":959.06109742339947},1000,"Kostpris",{"$f":"+G13","v":12.78748129897866},{"$f":"G22/H17","v":13.333333333333334},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":-16619.627938719583},{"$f":"CJ19-SUM(CJ23:CJ29)","v":8065.7470612804173},{"$f":"CK19-SUM(CK23:CK29)","v":32751.122061280417},{"$f":"CL19-SUM(CL23:CL29)","v":57436.497061280417},{"$f":"CM19-SUM(CM23:CM29)","v":82121.872061280417}]
[null,"Lønomkostning",{"$f":"+C21/(C22/100)","v":303.875},"kr/eff.time","Antal",{"$f":"+C17/((F22/(I19/100+1))-C31)","v":800.00000000000011},{"$f":"+C17/((G22/(I19/100+1))-C31)","v":667.32580703643168},"Antal",{"$f":"+C17/(((+I22*H17)/(I19/100+1))-C31)*H17","v":60000.000000000007},{"$f":"+C17/(((+J22*H17)/(I19/100+1))-C31)*H17","v":50049.435527732378},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":118955.02611095284},"Værditab+forrentn.",{"$f":"CG23","v":118955.02611095284},{"$f":"CG23","v":118955.02611095284},{"$f":"CG23","v":118955.02611095284},{"$f":"CG23","v":118955.02611095284},{"$f":"CG23","v":118955.02611095284}]
[null,"Rep/vedligeh.",100,"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":35000},"Øvrige faste omk.",{"$f":"CG24","v":35000},{"$f":"CG24","v":35000},{"$f":"CG24","v":35000},{"$f":"CG24","v":35000},{"$f":"CG24","v":35000}]
[null,"Traktoromkostninger",150,"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":303.875},"Lønomkostning",{"$f":"$CG$25*CI21","v":182325},{"$f":"$CG$25*CJ21","v":212712.5},{"$f":"$CG$25*CK21","v":243100},{"$f":"$CG$25*CL21","v":273487.5},{"$f":"$CG$25*CM21","v":303875}]
[null,"Brændstofforbrug",30,"liter/time",{"$f":"+E11","v":600},{"$f":"+(($F$22*E26))-$C$17-($C$31*E26)","v":-843.3676569131203},{"$f":"+(($G$22*E26))-$C$17-($C$31*E26)","v":23719.973889047164},{"$f":"+E26*$H$17","v":45000},{"$f":"+(($I$22*H26))-$C$17-((H26/$H$17)*$C$31)","v":-843.3676569131203},{"$f":"+(($J$22*H26))-$C$17-((H26/$H$17)*$C$31)","v":23719.973889047164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":100},"Rep/vedligeh.",{"$f":"$CG$26*CI21","v":60000},{"$f":"$CG$26*CJ21","v":70000},{"$f":"$CG$26*CK21","v":80000},{"$f":"$CG$26*CL21","v":90000},{"$f":"$CG$26*CM21","v":100000}]
[null,"Brændstofpris",5,"kr/liter",{"$f":"+E12","v":700},{"$f":"+(($F$22*E27))-$C$17-($C$31*E27)","v":24675.242085426813},{"$f":"+(($G$22*E27))-$C$17-($C$31*E27)","v":53332.473889047164},{"$f":"+E27*$H$17","v":52500},{"$f":"+(($I$22*H27))-$C$17-((H27/$H$17)*$C$31)","v":24675.242085426813},{"$f":"+(($J$22*H27))-$C$17-((H27/$H$17)*$C$31)","v":53332.473889047164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":150},{"$f":"B41","v":"Brændstof"},{"$f":"$CG$27*CI21","v":90000},{"$f":"$CG$27*CJ21","v":105000},{"$f":"$CG$27*CK21","v":120000},{"$f":"$CG$27*CL21","v":135000},{"$f":"$CG$27*CM21","v":150000}]
[null,"Brændstof",{"$f":"+C26*C27","v":150},"kr/eff.time",{"$f":"+E13","v":800},{"$f":"+(($F$22*E28))-$C$17-($C$31*E28)","v":50193.851827766746},{"$f":"+(($G$22*E28))-$C$17-($C$31*E28)","v":82944.973889047164},{"$f":"+E28*$H$17","v":60000},{"$f":"+(($I$22*H28))-$C$17-((H28/$H$17)*$C$31)","v":50193.851827766746},{"$f":"+(($J$22*H28))-$C$17-((H28/$H$17)*$C$31)","v":82944.973889047164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":150},"Traktoromk.",{"$f":"$CG$28*CI21","v":90000},{"$f":"$CG$28*CJ21","v":105000},{"$f":"$CG$28*CK21","v":120000},{"$f":"$CG$28*CL21","v":135000},{"$f":"$CG$28*CM21","v":150000}]
[null,"Traktor i alt",{"$f":"IF(C25=0,0,C25+C28)","v":300},"kr/eff.time",{"$f":"+E14","v":900},{"$f":"+(($F$22*E29))-$C$17-($C$31*E29)","v":75712.46157010668},{"$f":"+(($G$22*E29))-$C$17-($C$31*E29)","v":112557.47388904716},{"$f":"+E29*$H$17","v":67500},{"$f":"+(($I$22*H29))-$C$17-((H29/$H$17)*$C$31)","v":75712.46157010668},{"$f":"+(($J$22*H29))-$C$17-((H29/$H$17)*$C$31)","v":112557.47388904716},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":150},"Administrationsomkostning",{"$f":"(CI28+CI27+CI26+CI25+CI24+CI23)*$I$19/100","v":40339.601827766703},{"$f":"(CJ28+CJ27+CJ26+CJ25+CJ24+CJ23)*$I$19/100","v":45266.726827766703},{"$f":"(CK28+CK27+CK26+CK25+CK24+CK23)*$I$19/100","v":50193.851827766703},{"$f":"(CL28+CL27+CL26+CL25+CL24+CL23)*$I$19/100","v":55120.976827766703},{"$f":"(CM28+CM27+CM26+CM25+CM24+CM23)*$I$19/100","v":60048.101827766703}]
[null,"Vareforbrug ",0,"kr/eff.time",{"$f":"+E15","v":1000},{"$f":"+(($F$22*E30))-$C$17-($C$31*E30)","v":101231.07131244661},{"$f":"+(($G$22*E30))-$C$17-($C$31*E30)","v":142169.97388904716},{"$f":"+E30*$H$17","v":75000},{"$f":"+(($I$22*H30))-$C$17-((H30/$H$17)*$C$31)","v":101231.07131244673},{"$f":"+(($J$22*H30))-$C$17-((H30/$H$17)*$C$31)","v":142169.97388904716}]
[null,"Driftsomk.ialt ",{"$f":"$C$24+$C$23+$C$25+C28+C30","v":703.875},"kr/eff.time"]
[null,"Driftsomk. Ex løn",{"$f":"+C31-C23","v":400},"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":800000},{"$f":"C35/$E$13","v":1000},{"$f":"D35/$H$17","v":13.333333333333334},{"$f":"C35/$C$35*100","v":100}]
[null,"Forrentning+afskrivning",{"$f":"C11","v":118955.02611095284},148.69378263869103,1.9825837685158805,14.869378263869104]
[null,"Forsikring/vægtafgift/oa.",{"$f":"C15+C14+C13","v":35000},43.75,0.58333333333333337,4.375]
[null,"Løn",{"$f":"C23*E13","v":243100},303.875,4.0516666666666667,30.387499999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":80000},100,1.3333333333333333,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,1,{"$f":"IF(CG39=\"\",\"\",($C$13+$C$14+$C$15)/$E$13)","v":43.75},{"$f":"IF(CG39=\"\",\"\",$C$24)","v":100},{"$f":"IF(CG39=\"\",\"\",$C$23)","v":303.875},{"$f":"IF(CG39=\"\",\"\",$C$25)","v":150},{"$f":"IF(CG39=\"\",\"\",$C$28)","v":150},{"$f":"IF(CG39=\"\",\"\",$C$30)","v":0},{"$f":"IF(CG39=\"\",\"\",CX39)","v":237.5},{"$f":"IF(CG39=\"\",\"\",SUM(CH39:CN39)*$I$19/100)","v":68.958749999999995},{"$f":"IF(CG39=\"\",\"\",$F$22)","v":959.06109742339947},{"$f":"IF(CG39=\"\",\"\",$G$22)","v":1000},null,null,{"$f":"SUM(CH39:CO39)","v":1054.08375},{"$f":"$C$5*(100-$C$8)/100","v":850000},{"$f":"C5-CU39","v":150000},{"$f":"C5*(($C$7/100))","v":40000},{"$f":"(CW39+CV39)/$E$13","v":237.5}]
[null,"Traktor ",{"$f":"C25*E13","v":120000},150,2,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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},43.75,100,303.875,150,150,0,201.875,66.465000000000003,959.06109742339947,1000,null,null,1015.965,{"$f":"CU39*(100-$C$8)/100","v":722500},{"$f":"CU39-CU40","v":127500},{"$f":"CU39*(($C$7/100))","v":34000},201.875,{"$f":"CX39/CX40*100","v":117.64705882352942}]
[null,"Brændstof",{"$f":"C28*E13","v":120000},150,2,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,43.75,100,303.875,150,150,0,171.59375,64.345312500000006,959.06109742339947,1000,null,null,983.56406249999998,614125,108375,28900,171.59375,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,43.75,100,303.875,150,150,0,145.85468750000001,62.543578124999996,959.06109742339947,1000,null,null,956.02326562499991,522006.25,92118.75,24565,145.85468750000001,117.64705882352939]
[null,"Administrationsomk.",{"$f":"F28","v":50193.851827766746},62.742314784708434,0.83656419712944574,6.2742314784708428,"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,43.75,100,303.875,150,150,0,123.976484375,61.012103906250005,959.06109742339947,1000,null,null,932.61358828125003,443705.3125,78300.9375,20880.25,123.976484375,117.64705882352942]
[null,"Gns. Fortjeneste",{"$f":"C35-SUM(C36:C43)","v":32751.122061280417},{"$f":"D35-SUM(D36:D43)","v":40.938902576600526},0.54585203435467367,4.0938902576600524,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,43.75,100,303.875,150,150,0,105.38001171875,59.710350820312499,959.06109742339947,1000,null,null,912.71536253906243,377149.515625,66555.796875,17748.212500000001,105.38001171875,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,7,43.75,100,303.875,150,150,0,89.573009960937526,58.603860697265624,959.06109742339947,1000,null,null,895.80187065820314,320577.08828124998,56572.427343750023,15085.980625,89.573009960937526,117.64705882352938]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,43.75,100,303.875,150,150,0,76.137058466796859,57.663344092675779,959.06109742339947,1000,null,null,881.42540255947256,272490.52503906249,48086.563242187491,12823.083531249998,76.137058466796859,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,231616.94628320311,40873.578755859373,10899.6210015625,64.716499696777333,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,0,196874.40434072263,34742.541942480486,9264.6778513281242,55.009024742260763,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,167343.24368961423,29531.160651108396,7874.9761736289056,46.757671030921628,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,142241.75713617209,25101.486553442141,6693.7297475845699,39.744020376283387,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,120905.49356574629,21336.263570425799,5689.670285446884,33.782417319840853,117.64705882352951]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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","Selvkørende maskine"]
[]
[null,"Pris ",2000000,"kr","Omkostninger - udnyttelse"]
[null,"Periode",8,"år",50,"(interval i skema)"]
[null,"Kalkulationsrente",4,"%","timer/","kr/","kr/",null,"kr/","kr/eff.time"]
[null,"Værditab",14,"%p.a","år","eff.time",{"$f":"+F17","v":"m3"},{"$f":"+F17","v":"m3"},"eff.time","ex. Traktor"]
[null,"Gns. Årligt værditab",{"$f":"+(C5-C10)/C6","v":175195.51822335363},"kr/år",null,"i alt",null,"i alt","excl.diesel","excl.løn"]
[null,"Restværdi ",{"$f":"((1-C8/100)^C6)*C5","v":598435.85421317094},"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":232108.71821664742},"kr/år",300,{"$f":"($C$17/E11+$C$29)*(1+($I$19/100))","v":1735.9277616393761},{"$f":"+F11/$H$17","v":57.864258721312538},{"$f":"+E11*$H$17","v":9000},{"$f":"($C$17/E11+($C$29-$C$27))*(1+($I$19/100))","v":1564.727761639376},{"$f":"($C$17/E11+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":1091.787761639376}]
[null,"Kapitalomkostninger",{"$f":"+C11/C5","v":0.11605435910832371},null,{"$f":"+$E$6+E11","v":350},{"$f":"($C$17/E12+$C$29)*(1+($I$19/100))","v":1610.5295099766081},{"$f":"+F12/$H$17","v":53.684316999220272},{"$f":"+E12*$H$17","v":10500},{"$f":"($C$17/E12+($C$29-$C$27))*(1+($I$19/100))","v":1439.3295099766081},{"$f":"($C$17/E12+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":966.389509976608}]
[null,"Husleje",4000,"kr/år",{"$f":"+$E$6+E12","v":400},{"$f":"($C$17/E13+$C$29)*(1+($I$19/100))","v":1516.480821229532},{"$f":"+F13/$H$17","v":50.549360707651068},{"$f":"+E13*$H$17","v":12000},{"$f":"($C$17/E13+($C$29-$C$27))*(1+($I$19/100))","v":1345.280821229532},{"$f":"($C$17/E13+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":872.34082122953191}]
[null,"Forsikring ",10000,"kr/år",{"$f":"+$E$6+E13","v":450},{"$f":"($C$17/E14+$C$29)*(1+($I$19/100))","v":1443.3318410929173},{"$f":"+F14/$H$17","v":48.11106136976391},{"$f":"+E14*$H$17","v":13500},{"$f":"($C$17/E14+($C$29-$C$27))*(1+($I$19/100))","v":1272.1318410929173},{"$f":"($C$17/E14+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":799.19184109291723}]
[null,"Vægtafgift",null,"kr/år",{"$f":"+$E$6+E14","v":500},{"$f":"($C$17/E15+$C$29)*(1+($I$19/100))","v":1384.8126569836254},{"$f":"+F15/$H$17","v":46.160421899454178},{"$f":"+E15*$H$17","v":15000},{"$f":"($C$17/E15+($C$29-$C$27))*(1+($I$19/100))","v":1213.6126569836256},{"$f":"($C$17/E15+($C$29-$C$23-$C$27))*(1+($I$19/100))","v":740.67265698362553}]
[]
[null,"Faste omkostninger",{"$f":"$C$11+C13+C14+$C$15","v":246108.71821664742},"kr/år","enhed","m3","kapacitet",30,"enhed/time"]
[]
[null,"Løn til medarbejder",170,"kr/time","Administration",null,null,null,7,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":510000},{"$f":"DR21*$G$22","v":595000},{"$f":"DS21*$G$22","v":680000},{"$f":"DT21*$G$22","v":765000},{"$f":"DU21*$G$22","v":850000}]
[null,"Sociale omk",43,"%","0 - punktsberegning"]
[null,"Lønomkostning",{"$f":"+C19*(1+C20/100)","v":243.1},"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":300},{"$f":"E12","v":350},{"$f":"E13","v":400},{"$f":"E14","v":450},{"$f":"E15","v":500},null,null,"Under 100 hk","100-150","150-200","200-250","250-300","300-350","Over 350 hk"]
[null,"Effektivitet",55,"%","Kostpris",{"$f":"+F13","v":1516.480821229532},1700,"Kostpris",{"$f":"+G13","v":50.549360707651068},{"$f":"G22/H17","v":56.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,"Gns. Fortjeneste pr. år ",{"$f":"DQ19-SUM(DQ23:DQ29)","v":-10778.328491812688},{"$f":"DR19-SUM(DR23:DR29)","v":31314.671508187312},{"$f":"DS19-SUM(DS23:DS29)","v":73407.671508187312},{"$f":"DT19-SUM(DT23:DT29)","v":115500.67150818731},{"$f":"DU19-SUM(DU23:DU29)","v":157593.67150818731},null,"Brændstof",31,51,72,90,113,131,149]
[null,"Lønomkostning",{"$f":"+C21/(C22/100)","v":441.99999999999994},"kr/eff.time","Antal",{"$f":"+C17/((F22/(I19/100+1))-C29)","v":400},{"$f":"+C17/((G22/(I19/100+1))-C29)","v":312.80299395601742},"Antal",{"$f":"+C17/(((+I22*H17)/(I19/100+1))-C29)*H17","v":12000},{"$f":"+C17/(((+J22*H17)/(I19/100+1))-C29)*H17","v":9384.0898186805225},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":232108.71821664742},"Værditab+forrentn.",{"$f":"DO23","v":232108.71821664742},{"$f":"DO23","v":232108.71821664742},{"$f":"DO23","v":232108.71821664742},{"$f":"DO23","v":232108.71821664742},{"$f":"DO23","v":232108.71821664742},null,"Løn",15,12,10,11,9,9,9]
[null,"Rep/vedligeh.",200,"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":14000},"Øvrige faste omk.",{"$f":"DO24","v":14000},{"$f":"DO24","v":14000},{"$f":"DO24","v":14000},{"$f":"DO24","v":14000},{"$f":"DO24","v":14000},null,"Rep/vedl",57,35,43,40,33,41,35]
[null,"Brændstofforbrug",40,"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":441.99999999999994},"Lønomkostning",{"$f":"$DO$25*DQ21","v":132599.99999999997},{"$f":"$DO$25*DR21","v":154699.99999999997},{"$f":"$DO$25*DS21","v":176799.99999999997},{"$f":"$DO$25*DT21","v":198899.99999999997},{"$f":"$DO$25*DU21","v":220999.99999999997},null,"Afskriv/forrentning",28,59,72,107,121,124,155]
[null,"Brændstofpris",4,"kr/liter",{"$f":"+E11","v":300},{"$f":"+(($F$22*E26))-$C$17-($C$29*E26)","v":-31764.47184778782},{"$f":"+(($G$22*E26))-$C$17-($C$29*E26)","v":23291.281783352606},{"$f":"+E26*$H$17","v":9000},{"$f":"+(($I$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":-31764.47184778782},{"$f":"+(($J$22*H26))-$C$17-((H26/$H$17)*$C$29)","v":23291.281783352606},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":200},"Rep/vedligeh.",{"$f":"$DO$26*DQ21","v":60000},{"$f":"$DO$26*DR21","v":70000},{"$f":"$DO$26*DS21","v":80000},{"$f":"$DO$26*DT21","v":90000},{"$f":"$DO$26*DU21","v":100000},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":160},"kr/eff.time",{"$f":"+E12","v":350},{"$f":"+(($F$22*E27))-$C$17-($C$29*E27)","v":3959.5692136888392},{"$f":"+(($G$22*E27))-$C$17-($C$29*E27)","v":68191.281783352606},{"$f":"+E27*$H$17","v":10500},{"$f":"+(($I$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":3959.5692136888392},{"$f":"+(($J$22*H27))-$C$17-((H27/$H$17)*$C$29)","v":68191.281783352606},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":160},{"$f":"B38","v":"Brændstof"},{"$f":"$DO$27*DQ21","v":48000},{"$f":"$DO$27*DR21","v":56000},{"$f":"$DO$27*DS21","v":64000},{"$f":"$DO$27*DT21","v":72000},{"$f":"$DO$27*DU21","v":80000},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":39683.610275165411},{"$f":"+(($G$22*E28))-$C$17-($C$29*E28)","v":113091.28178335261},{"$f":"+E28*$H$17","v":12000},{"$f":"+(($I$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":39683.610275165411},{"$f":"+(($J$22*H28))-$C$17-((H28/$H$17)*$C$29)","v":113091.28178335261},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":802},"kr/eff.time",{"$f":"+E14","v":450},{"$f":"+(($F$22*E29))-$C$17-($C$29*E29)","v":75407.651336641982},{"$f":"+(($G$22*E29))-$C$17-($C$29*E29)","v":157991.28178335261},{"$f":"+E29*$H$17","v":13500},{"$f":"+(($I$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":75407.651336641982},{"$f":"+(($J$22*H29))-$C$17-((H29/$H$17)*$C$29)","v":157991.28178335261},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":160},"Administrationsomkostning",{"$f":"(DQ27+DQ26+DQ25+DQ24+DQ23)*$I$19/100","v":34069.610275165316},{"$f":"(DR27+DR26+DR25+DR24+DR23)*$I$19/100","v":36876.610275165316},{"$f":"(DS27+DS26+DS25+DS24+DS23)*$I$19/100","v":39683.610275165316},{"$f":"(DT27+DT26+DT25+DT24+DT23)*$I$19/100","v":42490.610275165316},{"$f":"(DU27+DU26+DU25+DU24+DU23)*$I$19/100","v":45297.610275165316}]
[null,"Driftsomk. Ex løn",{"$f":"+C29-C23","v":360.00000000000006},"kr/eff.time",{"$f":"+E15","v":500},{"$f":"+(($F$22*E30))-$C$17-($C$29*E30)","v":111131.69239811855},{"$f":"+(($G$22*E30))-$C$17-($C$29*E30)","v":202891.28178335261},{"$f":"+E30*$H$17","v":15000},{"$f":"+(($I$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":111131.69239811867},{"$f":"+(($J$22*H30))-$C$17-((H30/$H$17)*$C$29)","v":202891.28178335261},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":-2.1133977434926838},{"$f":"DR22/DR19*100","v":5.2629700013760186},{"$f":"DS22/DS19*100","v":10.795245810027545},{"$f":"DT22/DT19*100","v":15.098126994534288},{"$f":"DU22/DU19*100","v":18.540431942139683}]
[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":680000},{"$f":"C33/$E$13","v":1700},{"$f":"D33/$H$17","v":56.666666666666664},{"$f":"C33/$C$33*100","v":100}]
[null,"Forrentning+afskrivning",{"$f":"C11","v":232108.71821664742},580.27179554161853,19.342393184720617,34.133635031859917]
[null,"Forsikring/vægtafgift/oa.",{"$f":"C15+C14+C13","v":14000},35,1.1666666666666667,2.0588235294117645]
[null,"Løn",{"$f":"C23*E13","v":176799.99999999997},441.99999999999994,14.733333333333331,25.999999999999996]
[null,"Rep/vedligeholdelse",{"$f":"C24*E13","v":80000},200,6.666666666666667,11.76470588235294]
[null,"Brændstof",{"$f":"C27*E13","v":64000},160,5.333333333333333,9.4117647058823533,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":35},{"$f":"IF(DO39=\"\",\"\",$C$24)","v":200},{"$f":"IF(DO39=\"\",\"\",$C$23)","v":441.99999999999994},null,{"$f":"IF(DO39=\"\",\"\",$C$27)","v":160},{"$f":"IF(DO39=\"\",\"\",$C$28)","v":0},{"$f":"IF(DO39=\"\",\"\",EF39)","v":900},{"$f":"IF(DO39=\"\",\"\",SUM(DP39:DV39)*$I$19/100)","v":121.59},{"$f":"IF(DO39=\"\",\"\",$F$22)","v":1516.480821229532},{"$f":"IF(DO39=\"\",\"\",$G$22)","v":1700},null,null,{"$f":"SUM(DP39:DW39)","v":1858.59},{"$f":"$C$5*(100-$C$8)/100","v":1720000},{"$f":"C5-EC39","v":280000},{"$f":"C5*(($C$7/100))","v":80000},{"$f":"(EE39+ED39)/$E$13","v":900}]
[null,"Administrationsomk.",{"$f":"F28","v":39683.610275165411},99.209025687913524,3.3069675229304507,5.8358250404655019,"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},35,200,441.99999999999994,null,160,0,774,112.77,1516.480821229532,1700,null,null,1723.77,{"$f":"EC39*(100-$C$8)/100","v":1479200},{"$f":"EC39-EC40","v":240800},{"$f":"EC39*(($C$7/100))","v":68800},774,{"$f":"EF39/EF40*100","v":116.27906976744187}]
[null,"Gns. Fortjeneste",{"$f":"C33-SUM(C34:C40)","v":73407.671508187195},{"$f":"D33-SUM(D34:D40)","v":183.51917877046799},6.1173059590155994,10.795245810027529,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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},35,200,441.99999999999994,null,160,0,665.64,105.1848,1516.480821229532,1700,null,null,1607.8247999999999,{"$f":"EC40*(100-$C$8)/100","v":1272112},{"$f":"EC40-EC41","v":207088},{"$f":"EC40*(($C$7/100))","v":59168},665.64,{"$f":"EF40/EF41*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,4,35,200,441.99999999999994,null,160,0,572.45039999999983,98.661527999999976,1516.480821229532,1700,null,null,1508.1119279999998,1094016.32,178095.67999999993,50884.480000000003,572.45039999999983,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,5,35,200,441.99999999999994,null,160,0,492.30734399999977,93.051514079999976,1516.480821229532,1700,null,null,1422.3588580799999,940854.03520000016,153162.28479999991,43760.652800000003,492.30734399999977,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,6,35,200,441.99999999999994,null,160,0,423.38431584,88.226902108800004,1516.480821229532,1700,null,null,1348.6112179488,809134.47027200018,131719.56492799998,37634.161408000007,423.38431584,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,7,35,200,441.99999999999994,null,160,0,364.1105116224004,84.077735813568012,1516.480821229532,1700,null,null,1285.1882474359684,695855.64443392004,113278.82583808014,32365.378810880007,364.1105116224004,116.27906976744174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,35,200,441.99999999999994,null,160,0,313.13503999526415,80.509452799668495,1516.480821229532,1700,null,null,1230.6444927949326,598435.85421317117,97419.790220748866,27834.225777356802,313.13503999526415,116.27906976744194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,514654.83462332719,83781.019589843985,23937.434168526848,269.29613439592708,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,{"$f":"IF(OR(DO47>=$C$6,DO47=\"\"),\"\",+DO47+1)","v":""},"","","",null,"","","","","","",null,null,0,442603.15777606139,72051.6768472658,20586.193384933089,231.59467558049721,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,{"$f":"IF(OR(DO48>=$C$6,DO48=\"\"),\"\",+DO48+1)","v":""},"","","",null,"","","","","","",null,null,0,380638.71568741277,61964.442088648619,17704.126311042455,199.17142099922771,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,0,327349.29549117497,53289.420196237799,15225.548627496511,171.28742205933577,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,"","","","",{"$f":"IF(DO51=\"\",\"\",#REF!)","v":""},"","","",{"$f":"IF(DO51=\"\",\"\",SUM(DP51:DV51)*$I$19/100)","v":""},"","",null,null,0,281520.39412241051,45828.901368764462,13093.971819646998,147.30718297102865,116.27906976744195]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":""}]