{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Spesenabrechnung"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Spesenabrechnung","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Reisekostenbericht"]
[]
[null,"Name","Helga Schustereit","Autorisiert durch",null,null,"Niklas Gasper",null,"Kilometersatz",null,null,{"v":0.32,"d":"0.32 €"}]
[]
[null,"Abteilung","Umsätze","Datum der Einreichung",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"Fällige Erstattung gesamt",null,null,{"$f":"FälligeGesamterstattung","v":{"v":550.3846011865525,"d":"550.38 €"}}]
[]
[null,"Zeitraum",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"TT.MM.JJ\"),\"Von \"&TEXT(MIN(B10:B13),\"TT.MM.JJ\")&\" bis \"&TEXT(MAX(B10:B13),\"TT.MM.JJ\"))","v":"Von 20.12.17 bis 25.12.17"}]
[]
[null,"Datum","Beschreibung der Ausgaben","Flugkosten","Unterkunft","Fahrt- kosten \n(ÖPNV, Mietwagen, Taxi)","Mahlzeiten und Trinkgelder","Konferenzen und Seminare","Kilometer","Erstattung Fahrtkosten","Verschiedenes","Devisen-Wechselkurs","Währung der Ausgabe","Gesamt"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Reise zum Kunden",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF(Spesenabrechnung!I10<>\"\",Spesenabrechnung!I10*KilometerPauschale,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR(Spesenabrechnung!$L10=\"\",Spesenabrechnung!$L10=1),SUM(Spesenabrechnung!$J10:$K10,Spesenabrechnung!$D10:$H10)*1,SUM(Spesenabrechnung!$J10:$K10,Spesenabrechnung!$D10:$H10)/Spesenabrechnung!$L10),\"\")","v":{"v":407.5148319050759,"d":"407.51 €"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Mittagessen mit Kunde",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF(Spesenabrechnung!I11<>\"\",Spesenabrechnung!I11*KilometerPauschale,\"\")","v":3.84},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR(Spesenabrechnung!$L11=\"\",Spesenabrechnung!$L11=1),SUM(Spesenabrechnung!$J11:$K11,Spesenabrechnung!$D11:$H11)*1,SUM(Spesenabrechnung!$J11:$K11,Spesenabrechnung!$D11:$H11)/Spesenabrechnung!$L11),\"\")","v":{"v":18.5497692814766,"d":"18.55 €"}}]
[null,"2017-12-20","Seminar am Nachmittag",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(Spesenabrechnung!I12<>\"\",Spesenabrechnung!I12*KilometerPauschale,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR(Spesenabrechnung!$L12=\"\",Spesenabrechnung!$L12=1),SUM(Spesenabrechnung!$J12:$K12,Spesenabrechnung!$D12:$H12)*1,SUM(Spesenabrechnung!$J12:$K12,Spesenabrechnung!$D12:$H12)/Spesenabrechnung!$L12),\"\")","v":{"v":101.92,"d":"101.92 €"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"Fahrt zum Flughafen",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(Spesenabrechnung!I13<>\"\",Spesenabrechnung!I13*KilometerPauschale,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR(Spesenabrechnung!$L13=\"\",Spesenabrechnung!$L13=1),SUM(Spesenabrechnung!$J13:$K13,Spesenabrechnung!$D13:$H13)*1,SUM(Spesenabrechnung!$J13:$K13,Spesenabrechnung!$D13:$H13)/Spesenabrechnung!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 €"}}]
[null,"Gesamt",null,{"$f":"SUBTOTAL(109,Ausgaben[Flugkosten])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Ausgaben[Unterkunft])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Ausgaben[Fahrt- kosten \n(ÖPNV, Mietwagen, Taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Ausgaben[Mahlzeiten und Trinkgelder])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Ausgaben[Konferenzen und Seminare])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Ausgaben[Kilometer])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Ausgaben[Erstattung Fahrtkosten])","v":39.36},{"$f":"SUBTOTAL(109,Ausgaben[Verschiedenes])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Ausgaben[Gesamt])","v":{"v":550.3846011865525,"d":"550.38 €"}}]