{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Januar 2018","Februar 2018","März 2018","April 2018","Mai 2018","Juni 2018","Juli 2018","August 2018","September 2018","Oktober 2018","November 2018","Dezember 2018","Hilfe","Tabelle9"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Januar 2018","index":0,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[5,1,5,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[17,1,17,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[41,14,41,15],[41,4,41,6],[40,14,40,15],[49,14,49,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[27,1,27,2],[37,1,37,2],[38,1,38,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-01-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,{"$f":"IF(F12>E12,ABS(ROUNDUP((F12-E12)*24,0)),ABS(ROUNDUP((IF(TEXT(E12,\"H\")<>\"0\",24-TEXT(E12,\"HH\"),0)+TEXT(F12,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H12 <> \"Keines\",IF(G12<8,0,IF(AND(G12>=8,G12<14),12,IF(AND(G12>=14,G12<24),12,24))),\"\")","v":""},"Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,{"$f":"IF(F28>E28,ABS(ROUNDUP((F28-E28)*24,0)),ABS(ROUNDUP((IF(TEXT(E28,\"H\")<>\"0\",24-TEXT(E28,\"HH\"),0)+TEXT(F28,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J28 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,{"$f":"IF(F30>E30,ABS(ROUNDUP((F30-E30)*24,0)),ABS(ROUNDUP((IF(TEXT(E30,\"H\")<>\"0\",24-TEXT(E30,\"HH\"),0)+TEXT(F30,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J30 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,{"$f":"IF(F39>E39,ABS(ROUNDUP((F39-E39)*24,0)),ABS(ROUNDUP((IF(TEXT(E39,\"H\")<>\"0\",24-TEXT(E39,\"HH\"),0)+TEXT(F39,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J39 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Februar 2018","index":1,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-02-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,9,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,null,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,null,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,null,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,null,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"März 2018","index":2,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-03-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"April 2018","index":3,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-04-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,{"$f":"IF(F31>E31,ABS(ROUNDUP((F31-E31)*24,0)),ABS(ROUNDUP((IF(TEXT(E31,\"H\")<>\"0\",24-TEXT(E31,\"HH\"),0)+TEXT(F31,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J31 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Mai 2018","index":4,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-05-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H11 <> \"Keines\",IF(G11<8,0,IF(AND(G11>=8,G11<14),12,IF(AND(G11>=14,G11<24),12,24))),\"\")","v":""},"Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Juni 2018","index":5,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-06-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H10 <> \"Keines\",IF(G10<8,0,IF(AND(G10>=8,G10<14),12,IF(AND(G10>=14,G10<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines",{"$f":"IF(H15 <> \"Keines\",IF(G15<8,0,IF(AND(G15>=8,G15<14),12,IF(AND(G15>=14,G15<24),12,24))),\"\")","v":""},"Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Juli 2018","index":6,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-07-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines",{"$f":"IF(H15 <> \"Keines\",IF(G15<8,0,IF(AND(G15>=8,G15<14),12,IF(AND(G15>=14,G15<24),12,24))),\"\")","v":""},"Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"August 2018","index":7,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-08-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines",{"$f":"IF(H15 <> \"Keines\",IF(G15<8,0,IF(AND(G15>=8,G15<14),12,IF(AND(G15>=14,G15<24),12,24))),\"\")","v":""},"Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"September 2018","index":8,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-09-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Oktober 2018","index":9,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-10-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"November 2018","index":10,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-11-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Dezember 2018","index":11,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,2],[2,2,2,3],[2,8,2,9],[2,13,2,14],[3,2,3,3],[3,8,3,9],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,14,40,15],[41,4,41,6],[41,14,41,15],[42,4,42,6],[42,14,42,15],[43,4,43,6],[43,14,43,15],[44,4,44,6],[44,14,44,15],[45,4,45,6],[45,14,45,15],[46,14,46,15],[48,14,48,15],[49,14,49,15]]}
["Reisekostenabrechnung"]
[]
["Firma",null,null,null,null,"Monat / Jahr",null,null,"2018-12-01",null,null,"Vorschuss"]
["Name",null,null,null,null,"Km-Geld je Km",null,null,0.3]
[]
["Tag","Reiseziel",null,"Reisezweck","von","bis","Std","Verpflegungsgeld",null,"Nächtigungsgeld",null,"KFZ","Bahn","Flug","Taxi","Sonst.",null,"Taggeld",null,null,null,"Nächtigung"]
[null,null,null,null,"SS:MM","SS:MM",null,null,"EUR",null,"EUR","Km","EUR","EUR","EUR","EUR",null,"Inland","Beleg","Ausland",null,"Inland","Beleg","Ausland"]
["Übertrag"]
[1,null,null,null,null,null,{"$f":"IF(F9>E9,ABS(ROUNDUP((F9-E9)*24,0)),ABS(ROUNDUP((IF(TEXT(E9,\"H\")<>\"0\",24-TEXT(E9,\"HH\"),0)+TEXT(F9,\"HH\")),0)))","v":0},"Keines",{"$f":"IF(H9 <> \"Keines\",IF(G9<8,0,IF(AND(G9>=8,G9<14),12,IF(AND(G9>=14,G9<24),12,24))),\"\")","v":""},"Keines",{"$f":"IF(J9 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H9=R$7,$I9,0)","v":0},{"$f":"IF($H9=S$7,$I9,0)","v":0},{"$f":"IF($H9=T$7,$I9,0)","v":0},null,{"$f":"IF($J9=V$7,$K9,0)","v":0},0,0]
[2,null,null,null,null,null,{"$f":"IF(F10>E10,ABS(ROUNDUP((F10-E10)*24,0)),ABS(ROUNDUP((IF(TEXT(E10,\"H\")<>\"0\",24-TEXT(E10,\"HH\"),0)+TEXT(F10,\"HH\")),0)))","v":0},"Keines","","Keines",{"$f":"IF(J10 <> \"Keines\",20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($H10=R$7,$I10,0)","v":0},0,0,null,0,0,0]
[3,null,null,null,null,null,{"$f":"IF(F11>E11,ABS(ROUNDUP((F11-E11)*24,0)),ABS(ROUNDUP((IF(TEXT(E11,\"H\")<>\"0\",24-TEXT(E11,\"HH\"),0)+TEXT(F11,\"HH\")),0)))","v":0},"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[4,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[5,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[6,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[7,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[8,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[9,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[10,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[11,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[12,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[13,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[14,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[15,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[16,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[17,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[18,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[19,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[20,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[21,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[22,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[23,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[24,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[25,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[26,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[27,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[28,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[29,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[30,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[31,null,null,null,null,null,0,"Keines","","Keines","",null,null,null,null,null,null,0,0,0,null,0,0,0]
[]
[null,null,null,"Verpflegungsgelder","Nächtigungsgelder",null,null,null,null,null,null,"Summe Std",null,null,{"$f":"SUM(G8:G29)","v":0},null,null,null,null,null,null,"Inland"]
["Übertrag",null,null,{"$f":"I8","v":0},{"$f":"K8","v":0},null,null,null,null,null,null,"Summe KM",null,null,{"$f":"SUM(L8:L29)","v":0},null,null,null,null,null,null,"Beleg"]
["Inland (pauschal)",null,null,{"$f":"SUM(R9:R39)","v":0},{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,"KM Geld",null,null,{"$f":"I4*O42","v":0},null,null,null,null,null,null,"Ausland"]
["Beleg",null,null,{"$f":"SUM(S9:S29)","v":0},{"$f":"SUM(W9:W29)","v":0},null,null,null,null,null,null,"Bahn",null,null,{"$f":"SUM(M8:M29)","v":0},null,null,null,null,null,null,"Keines"]
["Ausland",null,null,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(X9:X29)","v":0},null,null,null,null,null,null,"Flug",null,null,{"$f":"SUM(N8:N29)","v":0}]
["Summe",null,null,{"$f":"SUM(I8:I39)","v":0},{"$f":"SUM(K8:K29)","v":0},null,null,null,null,null,null,"Taxi",null,null,{"$f":"SUM(O8:O29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sonstiges",null,null,{"$f":"SUM(P8:P29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag",null,null,{"$f":"O43+D43+D44+D45+E43+E44+E45+O44+O45+O46+O47+D42+E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Abzügl. Vorschuss",null,null,{"$f":"O49-N3","v":0}]
[]
[null,"Auszahlung der Reisekosten durch: ",null,null," ¨","bar"," ¨ ","  Überweisung      ",null," ¨ ","Lohnabrechnung"]
[]
[]
[]
[null,"Ort, Datum",null,null,null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Hilfe","index":12,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[36,1,36,10],[37,1,37,10],[41,1,41,10]]}
["Hilfe zur Reisekostenabrechnung"]
[]
["Grundsätzliches"]
["Eingabefelder sind weiß hinterlegte, grau hintelegte Felder können nicht bearbeitet werden."]
["Stunden werden aufgerundet. Bsp.: (von 12:10 bis 15:20; Die Reisedauer von 03 h 10 min wird auf 4 Stunden aufgerundet)."]
["Bei der Reisekostenabrechung ist zu beachten das beim Taggeld und beim Nächtigungsgeld über ein Kombinationsfeld der einzugebene Betrag gesteuert werden kann. "]
[]
["Firma, Name"]
["Geben Sie hier Ihren Firmennamen und Ihren Namen ein."]
[]
["Monat / Jahr"]
["Geben Sie hier das Monat und das Jahr ein für welches Sie die Reisen erfassen wollen (Eingabe als Text)."]
[]
["KM Geld je KM"]
["Geben Sie hier den Kilometergeld-Satz je gefahrenen Kilometer ein."]
[]
["Tag / Reiseziel / Reisezweck"]
["Tag: Als Standard sind 31 Tage vorbelegt. Sie können dies Vorbelegung aber auch überschreiben, falls zB mehrere Reisen pro Tag existieren."]
["Ziel: Geben Sie das Ziel (Ort) Ihrer Reise an."]
["Zweck: Geben Sie den Zweck Ihrer Reise an, also zB welcher Kunde besucht wurde."]
[]
["von / bis"]
["Geben Sie hier Uhrzeit Ihrer Abfahrt und Ihrer Ankunft ein."]
["Die Uhrzeit muss im Format SS:MM  (Stunden:Minuten) eingegeben werden, also zB 8:50"]
[]
["Verpflegungsgeld:"]
["Wählen Sie für die Berechnung des Taggeldes in der ersten Spalte die Art der Berechnung."]
["Inland","Bei der Einstellung Inland, wird eine Verpflegungsgeldpauschale von 24,00 € für einen ganzen Tag angenommen."]
[null,"Dieses Pauschale wird wie folgt aliquotiert: Für eine Dauer ab 8 Stunden die halbe Pauschale, somit 12 €. "]
[null,"Für eine Reisedauer von mehr als 8 Stunden ergibt sich der Pauschalbetrag von 12 €. Die Reise muss mindestens 8 Stunden dauern."]
["Beleg","Bei Belegabrechnung geben Sie bitte die Summe Ihrer Belege im Betragsfeld ein."]
["Ausland","Bei Auslandsreisen erfolgt keine automatische Berechnung der Tagesdiäten. Der selbst berechnete Betrag kann eingegeben werden."]
["Keines","Keine Eingabe möglich"]
[]
["Nächtigungsgeld:"]
["Wählen Sie für die Berechnung des Nächtigungsgeldes in der ersten Spalte die Art der Berechnung."]
["Inland","Bei der Einstellung Inland werden 20,00 € als pauschales Nächtigungsgeld angenommen."]
[null,"(nur für Arbeitnehmer möglich, für Unternehmer ist grundsätzlich ein Einzelnachweis erforderlich)"]
["Beleg","Bei Belegabrechnung geben Sie bitte den Betrag Ihrer Hotelrechnung von der Nächtigung ein."]
[null,"(ist das Frühstück im Gesamtpreis enthalten, ist eine Kürzung um 4,80 € vorzunehmen)"]
["Ausland","Bei Auslandsreisen erfolgt keine automatische Berechnung. Der selbst berechnete Betrag kann eingegeben werden."]
[null,"(ist das Frühstück im Gesamtpreis enthalten, ist eine Kürzung um 20% des für den Unterkunftsort maßgebenden Pauschbetrags für Verpflegungsaufwendungen bei mehrtägiger Dienstreise, vorzunehmen)"]
["Keines","Keine Eingabe möglich"]
[]
[]
["KFZ-KM"]
["Zusätzlich zur Reise können auch die angefallenen KFZ Kilometer aufgezeichnet werden."]
["Die Summe der KFZ-KM wird dann mit dem oben eingegebenen Satz pro KM mulitpliziert und als KM Geld ausgewiesen."]
[]
["Bahn / Flug"]
["Geben Sie hier, wenn nötig, die angefallen Kosten bei Flug bzw. Bahnreise an."]

{"sheet":"Tabelle9","index":13,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Übersicht Reisekosten 2014"]
[]
[null,"Verpflegungsmehraufwendungen"]
[]
[null,null,"2014-01-01",null,{"$f":"'Januar 2018'!D43","v":0}]
[null,null,"2014-02-01",null,{"$f":"'Februar 2018'!D43","v":0}]
[null,null,"2014-03-01",null,{"$f":"'März 2018'!D43","v":0}]
[null,null,"2014-04-01",null,{"$f":"'April 2018'!D43","v":0}]
[null,null,"2014-05-01",null,{"$f":"'Mai 2018'!D43","v":0}]
[null,null,"2014-06-01",null,{"$f":"'Juni 2018'!D43","v":0}]
[null,null,"2014-07-01",null,{"$f":"'Juli 2018'!D43","v":0}]
[null,null,"2014-08-01",null,{"$f":"'August 2018'!D43","v":0}]
[null,null,"2014-09-01",null,{"$f":"'September 2018'!D43","v":0}]
[null,null,"2014-10-01",null,0]
[null,null,"2014-11-01",null,0]
[null,null,"2014-12-01",null,0]
[]
[null,null,"Summe Gesamt",null,{"$f":"SUM(E7:E19)","v":0}]