{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":49,"n_cols":6,"rows_kept":49}
["Ermittlung Private Kfz.-Nutzung"]
[]
["1%-Regelung","Kennzeichen",null,null,"Jahr"]
[null,"Bezeichnung"]
["allg. Privatnutzung"]
[null,"€","1%","Monate",null,"zu verst."]
["Listenpreis incl. MWSt",null,{"$f":"B7/100","v":0},null,null,{"$f":"C7*D7","v":0}]
[]
["Fahrten Whg.-Arbst."]
[null,"€","Entf.-km ","Monate"]
["0,03 % des Listenpreises",{"$f":"0.03%*B7","v":{"v":0,"d":"0.00"}},null,null,{"$f":"B11*C11*D11","v":0}]
[]
[null,"€","Entf.-km","Tage"]
["abzüglich pauschal zu versteuern",{"v":0.3,"d":"0.30"},null,null,{"$f":"B14*C14*D14","v":0},{"$f":"E11-E14","v":0}]
[]
["Privatanteil gesamt",{"$nulls":4},{"$f":"F7+F14","v":0}]
[]
["Einzelnachweis"]
[]
["allg. Privatnutzung"]
["Anschaffungsk. netto/brutto",null,"% f. MWSt"]
["Abschreibung p. a.",null,{"$error":"#DIV/0!"}]
["Leasingraten netto/brutto",null,{"$error":"#DIV/0!"}]
["Steuer/ Versicherung",null,{"$error":"#DIV/0!"}]
["Betriebskosten/Reparaturen",null,{"$error":"#DIV/0!"}]
["Gesamtkosten",{"$f":"SUM(B22:B25)","v":0},100]
[]
[null,null,"km -Satz","Privat-Km"]
["Gesamt-Km",null,{"$f":"B29/B26","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C29*D29","v":{"$error":"#DIV/0!"}}]
[]
["Fahrten Whg.-Arbst."]
[null,"Tage","km-Satz","km"]
["Whg. -Arbst. Hin und Rück",null,{"$f":"C29","v":{"$error":"#DIV/0!"}},null,{"$f":"B33*C33*D33","v":{"$error":"#DIV/0!"}}]
["./. Entfernungs-KM x 0,30",null,{"v":0.3,"d":"0.30"},null,{"$f":"B34*C34*D34","v":0},{"$f":"E33-E34","v":{"$error":"#DIV/0!"}}]
[]
["Privatanteil gesamt o. MWSt",{"$nulls":4},{"$f":"F29+F34","v":{"$error":"#DIV/0!"}}]
[]
["BMG 1%-Regelung",{"$f":"F7","v":0}]
[{"$nulls":3},"USt 19%"]
["Mwst-pfl. Anteil 80%",{"$f":"B38*0.8","v":0},null,{"$f":"B40*0.19","v":0},null,{"$f":"B40+D40","v":0}]
["Mwst-freier 20%",{"$f":"B38-B40+F14","v":0},{"$nulls":3},{"$f":"B41","v":0}]
["        Summe",{"$f":"SUM(B40:B41)","v":0},{"$nulls":3},{"$f":"SUM(F40:F41)","v":0}]
[]
[]
["BMG Fahrtenbuch",{"$f":"F29","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"USt 19%"]
["Mwst-pfl. Anteil 80%",{"$f":"B45*0.8","v":{"$error":"#DIV/0!"}},null,{"$f":"B47*0.19","v":{"$error":"#DIV/0!"}},null,{"$f":"B47+D47","v":{"$error":"#DIV/0!"}}]
["Mwst-freier 20%",{"$f":"B45-B47+F34","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"B48","v":{"$error":"#DIV/0!"}}]
["        Summe",{"$f":"SUM(B47:B48)","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"SUM(F47:F48)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}