{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Spesen13"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Spesen13","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,1],[50,0,50,1],[51,0,51,1],[43,0,43,4],[44,0,44,4],[47,0,47,1],[48,0,48,1],[41,0,41,1],[42,0,42,4],[6,1,6,2],[7,7,7,10],[37,0,37,1],[38,0,38,1],[3,9,6,9],[3,10,6,10],[49,12,52,15],[52,7,52,11],[1,1,1,2],[1,7,1,12],[1,13,1,15],[2,7,2,10],[2,11,2,12],[2,13,6,13],[2,14,6,14],[2,15,6,15],[3,7,6,7],[3,8,6,8],[3,11,6,11],[3,12,6,12],[39,0,39,1],[40,0,40,1]]}
["Konto",null,null,null,null,"Rechnungsjahr",2020]
["PersNr",null,null,null,null,null,null,"Verpflegung und Unterkunft",null,null,null,null,null,"Fahrauslagen"]
[null,null,null,null,null,null,null,"Normalansatz",null,null,null,"tatsächl. Auslagen",null,"Bahn","Auto","andere\nFahrauslagen\ngem. Belegen"]
[null,null,null,"Spesenrechnung",null,null,null,"Morgenessen","Mittagessen","Abendessen","übr.Konsumation","Verpflegung","Übernachten\nund übr. Kosten\ngem. Belegen"]
["von"]
["pro"]
["Datum","Zeitangabe",null,"Reise-Ziel",null,"Reise-Zweck"]
[null,"Abreise","Rückkehr",null,null,null,null,"Anzahl",null,null,null,"Fr.","Fr.","Fr.","km","Fr."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H9:H34)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"\"Im Jahr \"&G1&\" bisher verrechnet\"","v":"Im Jahr 2020 bisher verrechnet"},null,null,null,null,null,"km"]
[null,null,null,"Ausrechnung",null,null,null,"Total verr. im laufenden Jahr",null,null,null,null,null,"km",{"$f":"kmtotalbisher+kmtotalneu","v":0}]
["Maximalansatz",null,"Anzahl","Ansatz",null,"Fr."]
["Morgenessen",null,{"$f":"H35","v":0},8,null,{"$f":"D39*C39","v":0}]
["Mittagessen",null,{"$f":"I35","v":0},25,null,{"$f":"D40*C40","v":0},null,null,"Visum ",null,null,null,"Visum",null,"Visum"]
["Abendessen",null,{"$f":"J35","v":0},25,null,{"$f":"D41*C41","v":0},null,null,"Mitarbeiter/-in",null,null,null,"Vorgesetzte/-r",null,"Kontrolle"]
["übr.Konsum.",null,{"$f":"K35","v":0},6,null,{"$f":"D42*C42","v":0}]
["tatsächliche Auslagen für Verpflegung\nund Unterkunft gem. Belegen",null,null,null,null,{"$f":"L35+M35","v":0}]
["Bahn",null,null,null,null,{"$f":"N35","v":0},null,null,null,null,null,null,"Verbucht im SAP HR / ausbezahlt:"]
["andere Fahrauslagen gem. Belegen",null,null,null,null,{"$f":"P35","v":0},"Lohnkonto"]
[null,null,null,null,"LA 6100",{"$f":"ROUND(SUM(F39:F45)*20,0)/20","v":0}]
["Auto",null,"km","Ansatz"]
["bis 5'000 km",null,{"$f":"IF(kmtotal<=E48,IF(kmtotalbisher<=E48,kmtotalneu,0),MAX(E48-kmtotalbisher,0))","v":0},0.7,5000,{"$f":"C48*D48","v":0}]
["ab 5'001 km",null,{"$f":"IF(kmtotal<=E49,IF(kmtotalbisher>E49,kmtotalneu,kmtotalneu-C48),MAX(E49-kmtotalbisher-C48,0))","v":0},0.6,10000,{"$f":"C49*D49","v":0}]
["ab 10'001 km",null,{"$f":"IF(kmtotal<=km_Grenze_2,0,IF(kmtotalbisher+km_zu_verrechnen_1+km_zu_verrechnen_2<=km_Grenze_2,kmtotalneu-km_zu_verrechnen_1-km_zu_verrechnen_2,kmtotalneu))","v":0},0.55000000000000004,null,{"$f":"C50*D50","v":0},null,null,null,null,null,null,"Ein neues Spesenformular erstellen:\nRegister \"Add-Ins\", Schaltfläche\n\"Neues Spesenformular\""]
["Motorfahrrad",null,0,0.2,null,{"$f":"C51*D51","v":0}]
["Motorrad/Roller",null,0,0.3,null,{"$f":"C52*D52","v":0},"Total Fr.  ","Datum"]
[null,null,null,null,"LA 6110",{"$f":"ROUND(SUM(F48:F52)*20,0)/20","v":0},{"$f":"F53+F46","v":0},{"$f":"TODAY()","v":"2019-12-03"}]