{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Kalkulation","Prisregulering, til kunden"],"not_rendered":{"external_links":1,"comments":55},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Kalkulation","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"merged":[[0,0,0,2],[1,0,1,5],[2,3,2,6],[3,1,3,5],[4,1,4,3],[4,4,4,5]],"flags":["formulas_cached_only"]}
["Dansk Transport og Logistik"]
["Kalkulation for kørsel med lastbilmonteret kran og mobilkran\nIndtast i de grå felter (alle beløb ekskl. moms)"]
[{"$nulls":3},"Når markøren placeres på felter med rød markering i hjørnet, fremvises en kommentar"]
["Materielbetegnelse:","Krankalkulation"]
["Dato:",{"$nulls":5},"Ændring"]
["Faste bilomkostninger:","Indtastning","Beregninger","Indtast indeks","Indtast indeks","Beregninger","i procent"]
["Anskaffelsespris i kr.",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Levetid i hele år"]
["Scrapværdi i % af anskaff. pris",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Rentesats i pct.",{"$nulls":4},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Antal udnyttede døgn pr. år"]
["Antal udnyttede timer pr. døgn"]
["Årligt kørte kilometer"]
["Heraf ikke fakturerbare km."]
["Gnsn. renter/afskrivning pr. år",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Forsikringer pr. år, drift",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Vægt- og vejbenyttelsesafgift",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Faste bilomkostninger i alt:",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Kapacitetsomkostninger pr. år","Indtastning","Beregninger","Indtast indeks","Indtast indeks","Beregninger"]
["Administrativ lønomkostning",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Løn, sælger",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Lokaleleje, kontor, garage",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Reklame og annoncer",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Revisor, advokat, konsulent",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Kontormask., -artikler, tryksager",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Forsikringer, andre",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Telefon og porto",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Diverse",{"$nulls":4},0,{"v":0,"d":"0.0%"}]
["Kapacitetsomkostninger i alt",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Variable kranomkostninger","Indtastning","Beregninger","Indtast indeks","Indtast indeks","Beregninger"]
["Brændstof, liter pr. time"]
["Brændstof, pris pr. liter",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Brændstofomkostning pr. år",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Motorolie, hydraulikolie, smøremidler",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Antal dæk "]
["Pris pr. dæk"]
["Km. pr. dæk",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Reparation/vedligeh. pr. år ",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Skader og selvrisiko pr. år",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Løn, værkstedspersonale",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Variable kranomkostn. pr. år i alt",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Chaufførløn:","Indtastning","Beregninger",null,"Indtastning","Beregninger"]
["Timeløn",{"$nulls":5},{"v":0,"d":"0.0%"}]
["Antal løntimer pr. år i alt",null,0,null,null,0]
["Antal timer med særlige tillæg"]
["Gnsn. særlige tillæg",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Kilometerløn (eksp., trailer/cont.)",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Indirekte lønomkostninger",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Løn i alt pr. år",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Overskud i pct. af omsætning",{"$nulls":3},{"v":0,"d":"0%"}]
["Nøgletal, salgsenheder:",null,"Kr.",null,null,"Kr."]
["Faste omkostninger pr. time",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Faste omkostninger pr døgn",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Var. bilomk. pr. time",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Chaufførløn pr. time",null,0,null,null,0,{"v":0,"d":"0.0%"}]
["Årlige totale omkostninger",{"v":1,"d":"100%"},0,null,null,0,{"v":0,"d":"0.0%"}]
["Årligt overskud",{"v":0,"d":"0%"},0,null,null,0,{"v":0,"d":"0.0%"}]
["Årlig omsætning",{"v":1,"d":"100%"},0,null,null,0,{"v":0,"d":"0.0%"}]
["Salgspris pr. time",null,0,null,null,0,{"v":0,"d":"0.0%"}]

{"sheet":"Prisregulering, til kunden","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[1,0,1,4],[2,1,2,5],[3,1,3,2],[3,3,3,4]],"flags":["formulas_cached_only"]}
["Dansk Transport og Logistik"]
["Prisregulering for krankørsel med lastbilmonteret kran og mobilkran\n"]
["Materielbetegnelse:"]
["Dato:","00:00:00",null,"00:00:00"]
[null,"Andel af totalomkostning","DTL-indeks","DTL-indeks","Ny andel af totalomkostning","Ændring i pct."]
["Totalomkostninger",{"v":1,"d":"100.0%"},null,null,{"v":0,"d":"0.0%"},{"v":-1,"d":"-100.0%"}]
["Faste bilomkostninger:",{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Afskrivning på køretøj",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Forrentning af køretøj",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Forsikringer, drift",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Vægt- og vejbenyttelsesafgift",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Kapacitetsomkostninger pr. år",{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Administrative lønomkostninger",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Løn, sælger",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Lokaleleje, kontor, garage",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Reklamer og annoncer",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Revisor, advokat, konsulent",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Kontormaskiner, kontorartikler, tryksager",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Forsikringer, andre",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Telefon og porto",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Diverse",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Variable bilomkostninger",{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Brændstof",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Motorolie og smøremidler",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Dæk",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Reparation og vedligeholdelse",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Skader og selvrisiko",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Løn, værkstedspersonale",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Chaufførløn jf. overenskomst:",{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Timeløn",{"v":0,"d":"0.0%"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Gnsn. særlige tillæg",{"v":0,"d":"0.0%"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Kilometerløn (eksp., trailer/cont.)",{"v":0,"d":"0.0%"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"kr 0.00"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
["Indirekte lønomkostninger",{"v":0,"d":"0.0%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]