{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Reisek.","VSt.Verpfl.","Staaten","Fahrzeug","Kontenplan","__Goal_Metadata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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":"Reisek.","index":0,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,8,53,9],[45,12,46,12],[4,16,5,16],[45,18,46,18],[4,14,5,14],[45,11,46,11],[4,17,5,17],[4,15,5,15],[44,3,44,9],[4,4,4,5],[4,2,4,3],[4,6,4,7],[5,6,5,7],[51,3,51,6],[45,2,45,9],[1,0,1,8],[6,6,6,7],[7,6,7,7],[45,22,46,22],[1,19,1,22],[4,20,5,22],[4,12,4,13],[45,19,46,19],[45,20,46,20],[5,12,5,13],[4,18,5,18]]}
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J2>L2,\"' Datum von ' größer als ' Datum bis ' !\",IF(YEAR(J2)<YEAR(Y1),\"Datum < \"&TEXT(Y1,\"JJJJ\")&\" !\",IF(YEAR(J2)>YEAR(Z1),\"Datum > \"&TEXT(Z1,\"JJJJ\")&\" !\",\"\")))","v":""},null,{"$f":"IF(YEAR(L2)<YEAR(Y1),\"Datum < \"&TEXT(Y1,\"JJJJ\")&\" !\",IF(YEAR(L2)>YEAR(Z1),\"Datum > \"&TEXT(Z1,\"JJJJ\")&\" !\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01","2020-12-31"]
["Reisekosten-Abrechnung",null,null,null,null,null,null,null,null,{"$f":"Z11","v":"2020-01-01"},null,{"$f":"Z15","v":"2020-01-31"},null,null,null,null,null,null,null,"Thomas Mustermann",null,null,null,null,null,"Pkw"]
["A",null,"(A = Arbeitnehmer, bei Erstattung durch Arbeitgeber)"]
[null,null,"(U = Unternehmer und Werbungskosten als Arbeitnehmer)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Motorr."]
["Datum","Datum","Uhrzeit",null,"Uhrzeit",null,"Stunden",null,"\nGeschäftspartner","Ort","Staat","Verpflegungs-\nmehraufwand","Übernachtung\n- Pauschale -",null,"Kilometergeld","zusätzl.Personen","Fahrzeug","km-Satz","Summe","Bewirtungs-","\n\n\nsonstige Kosten",null,null,null,"U","Krad"]
[null,null,"von","bis","von","bis",null,null,"Reisezweck",null,null,"- Pauschale -","Kürzung Frühstück",null,null,null,null,null,null,"kosten 19%",null,null,null,null,null,"Moped"]
[null,null,null,null,null,null,null,null,null,null,null,"€",{"$f":"L7","v":"€"},"J/N","km","Anzahl","Typ",{"$f":"L7","v":"€"},{"$f":"L7","v":"€"},{"$f":"L7","v":"€"},{"$f":"L7","v":"€"},null,"Kontierung",null,null,"Mofa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fahrrad"]
[]
[null,{"$f":"IF(OR(A10=\"\",A10=3112),J2-1,DATE(Jahr,RIGHT(A10,2),LEFT(A10,LEN(A10)-2)))","v":"2019-12-31"},null,null,{"$f":"IF(C10=\"\",F8,IF(LEN(C10)=1,\"00:0\"&C10,IF(LEN(C10)=2,\"00:\"&C10,IF(LEN(C10)=3,\"0\"&LEFT(C10,1)&\":\"&RIGHT(C10,2),IF(LEN(C10)=4,LEFT(C10,2)&\":\"&RIGHT(C10,2),0)))))","v":"00:00:00"},{"$f":"IF(LEN(D10)=1,\"00:0\"&D10,IF(LEN(D10)=2,\"00:\"&D10,IF(LEN(D10)=3,\"0\"&LEFT(D10,1)&\":\"&RIGHT(D10,2),IF(LEN(D10)=4,LEFT(D10,2)&\":\"&RIGHT(D10,2),0))))","v":"00:00:00"},{"$f":"IF(OR(C10=\"\",D10=\"\"),0,IF(OR(B10<=0,C10=\"\"),0,IF(OR(RIGHT(C10,2)*1>59,RIGHT(D10,2)*1>59),\"X\",F10-E10)))","v":0},null,null,null," ",{"$f":"IF(OR(D10>2400,D11>2400,G10=\"X\",G11=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J11<>\"\",L11<>\"\"),\"\",IF(AND(G10+G11>8/24,G10+G11<24/24),VLOOKUP(K10,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B10-B8=1,D8=2400,ISNUMBER(C10),C10=0,G10<1),AND(B12-B10=1,C12=0,D10=2400,G10<1)),VLOOKUP(K10,Staaten!$A$7:$D$335,4,0),IF(G10+G11>=24/24,VLOOKUP(K10,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B10+100-B11<>0,N10=\"N\"),VLOOKUP(K10,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B10+100-B11<>0,N10=\"N\"),VLOOKUP(K10,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q10=\"\",\"\",VLOOKUP(Q10,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q10=\"\",\"\",O10*R10)","v":""},null,{"$f":"IF(LEFT(W11,4)=\"Kürz\",-MIN(LEFT(RIGHT(W11,7),5)*1,L10),IF(AND($A$4=\"A\",W11=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W11,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W11,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W11,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W11,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A11=\"\",B10,DATE(Jahr,RIGHT(A11,2),LEFT(A11,LEN(A11)-2)))","v":"2019-12-31"},null,null,{"$f":"IF(C11=\"\",F10,IF(LEN(C11)=1,\"00:0\"&C11,IF(LEN(C11)=2,\"00:\"&C11,IF(LEN(C11)=3,\"0\"&LEFT(C11,1)&\":\"&RIGHT(C11,2),IF(LEN(C11)=4,LEFT(C11,2)&\":\"&RIGHT(C11,2),0)))))","v":"00:00:00"},{"$f":"IF(LEN(D11)=1,\"00:0\"&D11,IF(LEN(D11)=2,\"00:\"&D11,IF(LEN(D11)=3,\"0\"&LEFT(D11,1)&\":\"&RIGHT(D11,2),IF(LEN(D11)=4,LEFT(D11,2)&\":\"&RIGHT(D11,2),0))))","v":"00:00:00"},{"$f":"IF(OR(C11=\"\",D11=\"\"),0,IF(OR(B11<=0,C11=\"\"),0,IF(OR(RIGHT(C11,2)*1>59,RIGHT(D11,2)*1>59),\"X\",F11-E11)))","v":0},null,null,{"$f":"IF(OR(AND(C10=\"\",D10<>\"\"),AND(C11=\"\",D11<>\"\"),D10>2400,D11>2400,G10=\"X\",G11=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B9=B10,E10<F9),AND(A10<>\"\",B8=B10,E10<F8),AND(B10=B11,E11<F10)),\"Datum + Uhrzeit prüfen !\",IF(AND(E11+1-F10<>0,B10+1-B11=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G10+G11>0,I10<=0),\"Geschäftspartner ?\",IF(AND(G10+G11>0,I11<=0),\"Reisezweck fehlt!\",IF(AND(G10+G11>0,J10<=0),\"Ort fehlt!\",IF(AND(G10+G11>0,J10=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D10>0,B10<=0),\"Datum fehlt !\",IF(AND(D11>0,B11<=0),\"Datum fehlt !\",IF(NOT(OR(B10=B11,B10+1=B11,B11<=0,)),\"Datum prüfen !\",IF(OR(AND(B9=B10,E10<F9),AND(B10=B11,E11<F10)),\"Datum + Uhrzeit prüfen !\",IF(AND(E11+1-F10<>0,B10+1=B11),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B10+1=B11,C10<1600),AND(B10+1=B11,D11>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N10=\"J\",VLOOKUP(K10,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," ",null,null,{"$f":"DATE(Z14,Z13,Z12)","v":"2020-01-01"},{"$f":"Z11-1","v":"2019-12-31"}]
[null,{"$f":"IF(A12=\"\",B10,DATE(Jahr,RIGHT(A12,2),LEFT(A12,LEN(A12)-2)))","v":"2019-12-31"},null,null,{"$f":"IF(C12=\"\",F11,IF(LEN(C12)=1,\"00:0\"&C12,IF(LEN(C12)=2,\"00:\"&C12,IF(LEN(C12)=3,\"0\"&LEFT(C12,1)&\":\"&RIGHT(C12,2),IF(LEN(C12)=4,LEFT(C12,2)&\":\"&RIGHT(C12,2),0)))))","v":"00:00:00"},{"$f":"IF(LEN(D12)=1,\"00:0\"&D12,IF(LEN(D12)=2,\"00:\"&D12,IF(LEN(D12)=3,\"0\"&LEFT(D12,1)&\":\"&RIGHT(D12,2),IF(LEN(D12)=4,LEFT(D12,2)&\":\"&RIGHT(D12,2),0))))","v":"00:00:00"},{"$f":"IF(OR(C12=\"\",D12=\"\"),0,IF(OR(B12<=0,C12=\"\"),0,IF(OR(RIGHT(C12,2)*1>59,RIGHT(D12,2)*1>59),\"X\",F12-E12)))","v":0},null,null,null," ",{"$f":"IF(OR(D12>2400,D13>2400,G12=\"X\",G13=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J13<>\"\",L13<>\"\"),\"\",IF(AND(G12+G13>8/24,G12+G13<24/24),VLOOKUP(K12,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B12-B10=1,D10=2400,ISNUMBER(C12),C12=0,G12<1),AND(B14-B12=1,C14=0,D12=2400,G12<1)),VLOOKUP(K12,Staaten!$A$7:$D$335,4,0),IF(G12+G13>=24/24,VLOOKUP(K12,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B12+100-B13<>0,N12=\"N\"),VLOOKUP(K12,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B12+100-B13<>0,N12=\"N\"),VLOOKUP(K12,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q12=\"\",\"\",VLOOKUP(Q12,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q12=\"\",\"\",O12*R12)","v":""},null,{"$f":"IF(LEFT(W13,4)=\"Kürz\",-MIN(LEFT(RIGHT(W13,7),5)*1,L12),IF(AND($A$4=\"A\",W13=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W13,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W13,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W13,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W13,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "},null,null,1]
[null,{"$f":"IF(A13=\"\",B12,DATE(Z$14,RIGHT(A13,2),LEFT(A13,LEN(A13)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C12=\"\",D12<>\"\"),AND(C13=\"\",D13<>\"\"),D12>2400,D13>2400,G12=\"X\",G13=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B11=B12,E12<F11),AND(A12<>\"\",B10=B12,E12<F10),AND(B12=B13,E13<F12)),\"Datum + Uhrzeit prüfen !\",IF(AND(E13+1-F12<>0,B12+1-B13=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G12+G13>0,I12<=0),\"Geschäftspartner ?\",IF(AND(G12+G13>0,I13<=0),\"Reisezweck fehlt!\",IF(AND(G12+G13>0,J12<=0),\"Ort fehlt!\",IF(AND(G12+G13>0,J12=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D12>0,B12<=0),\"Datum fehlt !\",IF(AND(D13>0,B13<=0),\"Datum fehlt !\",IF(NOT(OR(B12=B13,B12+1=B13,B13<=0,)),\"Datum prüfen !\",IF(OR(AND(B11=B12,E12<F11),AND(B12=B13,E13<F12)),\"Datum + Uhrzeit prüfen !\",IF(AND(E13+1-F12<>0,B12+1=B13),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B12+1=B13,C12<1600),AND(B12+1=B13,D13>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N12=\"J\",VLOOKUP(K12,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," ",null,null,1]
[null,{"$f":"IF(A14=\"\",B12,DATE(Jahr,RIGHT(A14,2),LEFT(A14,LEN(A14)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D14>2400,D15>2400,G14=\"X\",G15=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J15<>\"\",L15<>\"\"),\"\",IF(AND(G14+G15>8/24,G14+G15<24/24),VLOOKUP(K14,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B14-B12=1,D12=2400,ISNUMBER(C14),C14=0,G14<1),AND(B16-B14=1,C16=0,D14=2400,G14<1)),VLOOKUP(K14,Staaten!$A$7:$D$335,4,0),IF(G14+G15>=24/24,VLOOKUP(K14,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B14+100-B15<>0,N14=\"N\"),VLOOKUP(K14,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B14+100-B15<>0,N14=\"N\"),VLOOKUP(K14,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q14=\"\",\"\",VLOOKUP(Q14,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q14=\"\",\"\",O14*R14)","v":""},null,{"$f":"IF(LEFT(W15,4)=\"Kürz\",-MIN(LEFT(RIGHT(W15,7),5)*1,L14),IF(AND($A$4=\"A\",W15=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W15,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W15,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W15,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W15,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "},null,null,2020]
[null,{"$f":"IF(A15=\"\",B14,DATE(Z$14,RIGHT(A15,2),LEFT(A15,LEN(A15)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C14=\"\",D14<>\"\"),AND(C15=\"\",D15<>\"\"),D14>2400,D15>2400,G14=\"X\",G15=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B13=B14,E14<F13),AND(A14<>\"\",B12=B14,E14<F12),AND(B14=B15,E15<F14)),\"Datum + Uhrzeit prüfen !\",IF(AND(E15+1-F14<>0,B14+1-B15=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G14+G15>0,I14<=0),\"Geschäftspartner ?\",IF(AND(G14+G15>0,I15<=0),\"Reisezweck fehlt!\",IF(AND(G14+G15>0,J14<=0),\"Ort fehlt!\",IF(AND(G14+G15>0,J14=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D14>0,B14<=0),\"Datum fehlt !\",IF(AND(D15>0,B15<=0),\"Datum fehlt !\",IF(NOT(OR(B14=B15,B14+1=B15,B15<=0,)),\"Datum prüfen !\",IF(OR(AND(B13=B14,E14<F13),AND(B14=B15,E15<F14)),\"Datum + Uhrzeit prüfen !\",IF(AND(E15+1-F14<>0,B14+1=B15),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B14+1=B15,C14<1600),AND(B14+1=B15,D15>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N14=\"J\",VLOOKUP(K14,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," ",null,null,{"$f":"DATE(Z18,Z17,Z16)","v":"2020-01-31"},{"$f":"Z15+1","v":"2020-02-01"}]
[null,{"$f":"IF(A16=\"\",B14,DATE(Jahr,RIGHT(A16,2),LEFT(A16,LEN(A16)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D16>2400,D17>2400,G16=\"X\",G17=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J17<>\"\",L17<>\"\"),\"\",IF(AND(G16+G17>8/24,G16+G17<24/24),VLOOKUP(K16,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B16-B14=1,D14=2400,ISNUMBER(C16),C16=0,G16<1),AND(B18-B16=1,C18=0,D16=2400,G16<1)),VLOOKUP(K16,Staaten!$A$7:$D$335,4,0),IF(G16+G17>=24/24,VLOOKUP(K16,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B16+100-B17<>0,N16=\"N\"),VLOOKUP(K16,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B16+100-B17<>0,N16=\"N\"),VLOOKUP(K16,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q16=\"\",\"\",VLOOKUP(Q16,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q16=\"\",\"\",O16*R16)","v":""},null,{"$f":"IF(LEFT(W17,4)=\"Kürz\",-MIN(LEFT(RIGHT(W17,7),5)*1,L16),IF(AND($A$4=\"A\",W17=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W17,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W17,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W17,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W17,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "},null,null,{"$f":"SUM(AA16:AC16)","v":0},31,{"$f":"Z12-1","v":0},{"$f":"IF(Z13=12,Z12*-1+1,Z12-AB16-32)","v":-31}]
[null,{"$f":"IF(A17=\"\",B16,DATE(Z$14,RIGHT(A17,2),LEFT(A17,LEN(A17)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C16=\"\",D16<>\"\"),AND(C17=\"\",D17<>\"\"),D16>2400,D17>2400,G16=\"X\",G17=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B15=B16,E16<F15),AND(A16<>\"\",B14=B16,E16<F14),AND(B16=B17,E17<F16)),\"Datum + Uhrzeit prüfen !\",IF(AND(E17+1-F16<>0,B16+1-B17=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G16+G17>0,I16<=0),\"Geschäftspartner ?\",IF(AND(G16+G17>0,I17<=0),\"Reisezweck fehlt!\",IF(AND(G16+G17>0,J16<=0),\"Ort fehlt!\",IF(AND(G16+G17>0,J16=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D16>0,B16<=0),\"Datum fehlt !\",IF(AND(D17>0,B17<=0),\"Datum fehlt !\",IF(NOT(OR(B16=B17,B16+1=B17,B17<=0,)),\"Datum prüfen !\",IF(OR(AND(B15=B16,E16<F15),AND(B16=B17,E17<F16)),\"Datum + Uhrzeit prüfen !\",IF(AND(E17+1-F16<>0,B16+1=B17),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B16+1=B17,C16<1600),AND(B16+1=B17,D17>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N16=\"J\",VLOOKUP(K16,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," ",null,null,{"$f":"IF(AND(Z16>0,SUM(AA17:AB17)>12),12,IF(SUM(AA17:AB17)>13,13,SUM(AA17:AB17)))","v":2},1,{"$f":"Z13","v":1}]
[null,{"$f":"IF(A18=\"\",B16,DATE(Jahr,RIGHT(A18,2),LEFT(A18,LEN(A18)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D18>2400,D19>2400,G18=\"X\",G19=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J19<>\"\",L19<>\"\"),\"\",IF(AND(G18+G19>8/24,G18+G19<24/24),VLOOKUP(K18,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B18-B16=1,D16=2400,ISNUMBER(C18),C18=0,G18<1),AND(B20-B18=1,C20=0,D18=2400,G18<1)),VLOOKUP(K18,Staaten!$A$7:$D$335,4,0),IF(G18+G19>=24/24,VLOOKUP(K18,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B18+100-B19<>0,N18=\"N\"),VLOOKUP(K18,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B18+100-B19<>0,N18=\"N\"),VLOOKUP(K18,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q18=\"\",\"\",VLOOKUP(Q18,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q18=\"\",\"\",O18*R18)","v":""},null,{"$f":"IF(LEFT(W19,4)=\"Kürz\",-MIN(LEFT(RIGHT(W19,7),5)*1,L18),IF(AND($A$4=\"A\",W19=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W19,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W19,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W19,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W19,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "},null,null,{"$f":"Z14","v":2020}]
[null,{"$f":"IF(A19=\"\",B18,DATE(Z$14,RIGHT(A19,2),LEFT(A19,LEN(A19)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C18=\"\",D18<>\"\"),AND(C19=\"\",D19<>\"\"),D18>2400,D19>2400,G18=\"X\",G19=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B17=B18,E18<F17),AND(A18<>\"\",B16=B18,E18<F16),AND(B18=B19,E19<F18)),\"Datum + Uhrzeit prüfen !\",IF(AND(E19+1-F18<>0,B18+1-B19=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G18+G19>0,I18<=0),\"Geschäftspartner ?\",IF(AND(G18+G19>0,I19<=0),\"Reisezweck fehlt!\",IF(AND(G18+G19>0,J18<=0),\"Ort fehlt!\",IF(AND(G18+G19>0,J18=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D18>0,B18<=0),\"Datum fehlt !\",IF(AND(D19>0,B19<=0),\"Datum fehlt !\",IF(NOT(OR(B18=B19,B18+1=B19,B19<=0,)),\"Datum prüfen !\",IF(OR(AND(B17=B18,E18<F17),AND(B18=B19,E19<F18)),\"Datum + Uhrzeit prüfen !\",IF(AND(E19+1-F18<>0,B18+1=B19),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B18+1=B19,C18<1600),AND(B18+1=B19,D19>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N18=\"J\",VLOOKUP(K18,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A20=\"\",B18,DATE(Jahr,RIGHT(A20,2),LEFT(A20,LEN(A20)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D20>2400,D21>2400,G20=\"X\",G21=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J21<>\"\",L21<>\"\"),\"\",IF(AND(G20+G21>8/24,G20+G21<24/24),VLOOKUP(K20,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B20-B18=1,D18=2400,ISNUMBER(C20),C20=0,G20<1),AND(B22-B20=1,C22=0,D20=2400,G20<1)),VLOOKUP(K20,Staaten!$A$7:$D$335,4,0),IF(G20+G21>=24/24,VLOOKUP(K20,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B20+100-B21<>0,N20=\"N\"),VLOOKUP(K20,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B20+100-B21<>0,N20=\"N\"),VLOOKUP(K20,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q20=\"\",\"\",VLOOKUP(Q20,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q20=\"\",\"\",O20*R20)","v":""},null,{"$f":"IF(LEFT(W21,4)=\"Kürz\",-MIN(LEFT(RIGHT(W21,7),5)*1,L20),IF(AND($A$4=\"A\",W21=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W21,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W21,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W21,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W21,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A21=\"\",B20,DATE(Z$14,RIGHT(A21,2),LEFT(A21,LEN(A21)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C20=\"\",D20<>\"\"),AND(C21=\"\",D21<>\"\"),D20>2400,D21>2400,G20=\"X\",G21=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B19=B20,E20<F19),AND(A20<>\"\",B18=B20,E20<F18),AND(B20=B21,E21<F20)),\"Datum + Uhrzeit prüfen !\",IF(AND(E21+1-F20<>0,B20+1-B21=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G20+G21>0,I20<=0),\"Geschäftspartner ?\",IF(AND(G20+G21>0,I21<=0),\"Reisezweck fehlt!\",IF(AND(G20+G21>0,J20<=0),\"Ort fehlt!\",IF(AND(G20+G21>0,J20=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D20>0,B20<=0),\"Datum fehlt !\",IF(AND(D21>0,B21<=0),\"Datum fehlt !\",IF(NOT(OR(B20=B21,B20+1=B21,B21<=0,)),\"Datum prüfen !\",IF(OR(AND(B19=B20,E20<F19),AND(B20=B21,E21<F20)),\"Datum + Uhrzeit prüfen !\",IF(AND(E21+1-F20<>0,B20+1=B21),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B20+1=B21,C20<1600),AND(B20+1=B21,D21>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N20=\"J\",VLOOKUP(K20,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A22=\"\",B20,DATE(Jahr,RIGHT(A22,2),LEFT(A22,LEN(A22)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D22>2400,D23>2400,G22=\"X\",G23=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J23<>\"\",L23<>\"\"),\"\",IF(AND(G22+G23>8/24,G22+G23<24/24),VLOOKUP(K22,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B22-B20=1,D20=2400,ISNUMBER(C22),C22=0,G22<1),AND(B24-B22=1,C24=0,D22=2400,G22<1)),VLOOKUP(K22,Staaten!$A$7:$D$335,4,0),IF(G22+G23>=24/24,VLOOKUP(K22,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B22+100-B23<>0,N22=\"N\"),VLOOKUP(K22,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B22+100-B23<>0,N22=\"N\"),VLOOKUP(K22,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q22=\"\",\"\",VLOOKUP(Q22,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q22=\"\",\"\",O22*R22)","v":""},null,{"$f":"IF(LEFT(W23,4)=\"Kürz\",-MIN(LEFT(RIGHT(W23,7),5)*1,L22),IF(AND($A$4=\"A\",W23=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W23,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W23,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W23,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W23,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A23=\"\",B22,DATE(Z$14,RIGHT(A23,2),LEFT(A23,LEN(A23)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C22=\"\",D22<>\"\"),AND(C23=\"\",D23<>\"\"),D22>2400,D23>2400,G22=\"X\",G23=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B21=B22,E22<F21),AND(A22<>\"\",B20=B22,E22<F20),AND(B22=B23,E23<F22)),\"Datum + Uhrzeit prüfen !\",IF(AND(E23+1-F22<>0,B22+1-B23=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G22+G23>0,I22<=0),\"Geschäftspartner ?\",IF(AND(G22+G23>0,I23<=0),\"Reisezweck fehlt!\",IF(AND(G22+G23>0,J22<=0),\"Ort fehlt!\",IF(AND(G22+G23>0,J22=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D22>0,B22<=0),\"Datum fehlt !\",IF(AND(D23>0,B23<=0),\"Datum fehlt !\",IF(NOT(OR(B22=B23,B22+1=B23,B23<=0,)),\"Datum prüfen !\",IF(OR(AND(B21=B22,E22<F21),AND(B22=B23,E23<F22)),\"Datum + Uhrzeit prüfen !\",IF(AND(E23+1-F22<>0,B22+1=B23),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B22+1=B23,C22<1600),AND(B22+1=B23,D23>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N22=\"J\",VLOOKUP(K22,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A24=\"\",B22,DATE(Jahr,RIGHT(A24,2),LEFT(A24,LEN(A24)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D24>2400,D25>2400,G24=\"X\",G25=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J25<>\"\",L25<>\"\"),\"\",IF(AND(G24+G25>8/24,G24+G25<24/24),VLOOKUP(K24,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B24-B22=1,D22=2400,ISNUMBER(C24),C24=0,G24<1),AND(B26-B24=1,C26=0,D24=2400,G24<1)),VLOOKUP(K24,Staaten!$A$7:$D$335,4,0),IF(G24+G25>=24/24,VLOOKUP(K24,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B24+100-B25<>0,N24=\"N\"),VLOOKUP(K24,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B24+100-B25<>0,N24=\"N\"),VLOOKUP(K24,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q24=\"\",\"\",VLOOKUP(Q24,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q24=\"\",\"\",O24*R24)","v":""},null,{"$f":"IF(LEFT(W25,4)=\"Kürz\",-MIN(LEFT(RIGHT(W25,7),5)*1,L24),IF(AND($A$4=\"A\",W25=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W25,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W25,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W25,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W25,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A25=\"\",B24,DATE(Z$14,RIGHT(A25,2),LEFT(A25,LEN(A25)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C24=\"\",D24<>\"\"),AND(C25=\"\",D25<>\"\"),D24>2400,D25>2400,G24=\"X\",G25=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B23=B24,E24<F23),AND(A24<>\"\",B22=B24,E24<F22),AND(B24=B25,E25<F24)),\"Datum + Uhrzeit prüfen !\",IF(AND(E25+1-F24<>0,B24+1-B25=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G24+G25>0,I24<=0),\"Geschäftspartner ?\",IF(AND(G24+G25>0,I25<=0),\"Reisezweck fehlt!\",IF(AND(G24+G25>0,J24<=0),\"Ort fehlt!\",IF(AND(G24+G25>0,J24=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D24>0,B24<=0),\"Datum fehlt !\",IF(AND(D25>0,B25<=0),\"Datum fehlt !\",IF(NOT(OR(B24=B25,B24+1=B25,B25<=0,)),\"Datum prüfen !\",IF(OR(AND(B23=B24,E24<F23),AND(B24=B25,E25<F24)),\"Datum + Uhrzeit prüfen !\",IF(AND(E25+1-F24<>0,B24+1=B25),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B24+1=B25,C24<1600),AND(B24+1=B25,D25>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N24=\"J\",VLOOKUP(K24,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A26=\"\",B24,DATE(Jahr,RIGHT(A26,2),LEFT(A26,LEN(A26)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D26>2400,D27>2400,G26=\"X\",G27=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J27<>\"\",L27<>\"\"),\"\",IF(AND(G26+G27>8/24,G26+G27<24/24),VLOOKUP(K26,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B26-B24=1,D24=2400,ISNUMBER(C26),C26=0,G26<1),AND(B28-B26=1,C28=0,D26=2400,G26<1)),VLOOKUP(K26,Staaten!$A$7:$D$335,4,0),IF(G26+G27>=24/24,VLOOKUP(K26,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B26+100-B27<>0,N26=\"N\"),VLOOKUP(K26,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B26+100-B27<>0,N26=\"N\"),VLOOKUP(K26,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q26=\"\",\"\",VLOOKUP(Q26,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q26=\"\",\"\",O26*R26)","v":""},null,{"$f":"IF(LEFT(W27,4)=\"Kürz\",-MIN(LEFT(RIGHT(W27,7),5)*1,L26),IF(AND($A$4=\"A\",W27=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W27,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W27,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W27,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W27,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A27=\"\",B26,DATE(Z$14,RIGHT(A27,2),LEFT(A27,LEN(A27)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C26=\"\",D26<>\"\"),AND(C27=\"\",D27<>\"\"),D26>2400,D27>2400,G26=\"X\",G27=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B25=B26,E26<F25),AND(A26<>\"\",B24=B26,E26<F24),AND(B26=B27,E27<F26)),\"Datum + Uhrzeit prüfen !\",IF(AND(E27+1-F26<>0,B26+1-B27=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G26+G27>0,I26<=0),\"Geschäftspartner ?\",IF(AND(G26+G27>0,I27<=0),\"Reisezweck fehlt!\",IF(AND(G26+G27>0,J26<=0),\"Ort fehlt!\",IF(AND(G26+G27>0,J26=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D26>0,B26<=0),\"Datum fehlt !\",IF(AND(D27>0,B27<=0),\"Datum fehlt !\",IF(NOT(OR(B26=B27,B26+1=B27,B27<=0,)),\"Datum prüfen !\",IF(OR(AND(B25=B26,E26<F25),AND(B26=B27,E27<F26)),\"Datum + Uhrzeit prüfen !\",IF(AND(E27+1-F26<>0,B26+1=B27),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B26+1=B27,C26<1600),AND(B26+1=B27,D27>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N26=\"J\",VLOOKUP(K26,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A28=\"\",B26,DATE(Jahr,RIGHT(A28,2),LEFT(A28,LEN(A28)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D28>2400,D29>2400,G28=\"X\",G29=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J29<>\"\",L29<>\"\"),\"\",IF(AND(G28+G29>8/24,G28+G29<24/24),VLOOKUP(K28,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B28-B26=1,D26=2400,ISNUMBER(C28),C28=0,G28<1),AND(B30-B28=1,C30=0,D28=2400,G28<1)),VLOOKUP(K28,Staaten!$A$7:$D$335,4,0),IF(G28+G29>=24/24,VLOOKUP(K28,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B28+100-B29<>0,N28=\"N\"),VLOOKUP(K28,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B28+100-B29<>0,N28=\"N\"),VLOOKUP(K28,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q28=\"\",\"\",VLOOKUP(Q28,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q28=\"\",\"\",O28*R28)","v":""},null,{"$f":"IF(LEFT(W29,4)=\"Kürz\",-MIN(LEFT(RIGHT(W29,7),5)*1,L28),IF(AND($A$4=\"A\",W29=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W29,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W29,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W29,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W29,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A29=\"\",B28,DATE(Z$14,RIGHT(A29,2),LEFT(A29,LEN(A29)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C28=\"\",D28<>\"\"),AND(C29=\"\",D29<>\"\"),D28>2400,D29>2400,G28=\"X\",G29=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B27=B28,E28<F27),AND(A28<>\"\",B26=B28,E28<F26),AND(B28=B29,E29<F28)),\"Datum + Uhrzeit prüfen !\",IF(AND(E29+1-F28<>0,B28+1-B29=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G28+G29>0,I28<=0),\"Geschäftspartner ?\",IF(AND(G28+G29>0,I29<=0),\"Reisezweck fehlt!\",IF(AND(G28+G29>0,J28<=0),\"Ort fehlt!\",IF(AND(G28+G29>0,J28=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D28>0,B28<=0),\"Datum fehlt !\",IF(AND(D29>0,B29<=0),\"Datum fehlt !\",IF(NOT(OR(B28=B29,B28+1=B29,B29<=0,)),\"Datum prüfen !\",IF(OR(AND(B27=B28,E28<F27),AND(B28=B29,E29<F28)),\"Datum + Uhrzeit prüfen !\",IF(AND(E29+1-F28<>0,B28+1=B29),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B28+1=B29,C28<1600),AND(B28+1=B29,D29>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N28=\"J\",VLOOKUP(K28,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A30=\"\",B28,DATE(Jahr,RIGHT(A30,2),LEFT(A30,LEN(A30)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D30>2400,D31>2400,G30=\"X\",G31=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J31<>\"\",L31<>\"\"),\"\",IF(AND(G30+G31>8/24,G30+G31<24/24),VLOOKUP(K30,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B30-B28=1,D28=2400,ISNUMBER(C30),C30=0,G30<1),AND(B32-B30=1,C32=0,D30=2400,G30<1)),VLOOKUP(K30,Staaten!$A$7:$D$335,4,0),IF(G30+G31>=24/24,VLOOKUP(K30,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B30+100-B31<>0,N30=\"N\"),VLOOKUP(K30,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B30+100-B31<>0,N30=\"N\"),VLOOKUP(K30,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q30=\"\",\"\",VLOOKUP(Q30,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q30=\"\",\"\",O30*R30)","v":""},null,{"$f":"IF(LEFT(W31,4)=\"Kürz\",-MIN(LEFT(RIGHT(W31,7),5)*1,L30),IF(AND($A$4=\"A\",W31=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W31,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W31,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W31,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W31,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A31=\"\",B30,DATE(Z$14,RIGHT(A31,2),LEFT(A31,LEN(A31)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C30=\"\",D30<>\"\"),AND(C31=\"\",D31<>\"\"),D30>2400,D31>2400,G30=\"X\",G31=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B29=B30,E30<F29),AND(A30<>\"\",B28=B30,E30<F28),AND(B30=B31,E31<F30)),\"Datum + Uhrzeit prüfen !\",IF(AND(E31+1-F30<>0,B30+1-B31=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G30+G31>0,I30<=0),\"Geschäftspartner ?\",IF(AND(G30+G31>0,I31<=0),\"Reisezweck fehlt!\",IF(AND(G30+G31>0,J30<=0),\"Ort fehlt!\",IF(AND(G30+G31>0,J30=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D30>0,B30<=0),\"Datum fehlt !\",IF(AND(D31>0,B31<=0),\"Datum fehlt !\",IF(NOT(OR(B30=B31,B30+1=B31,B31<=0,)),\"Datum prüfen !\",IF(OR(AND(B29=B30,E30<F29),AND(B30=B31,E31<F30)),\"Datum + Uhrzeit prüfen !\",IF(AND(E31+1-F30<>0,B30+1=B31),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B30+1=B31,C30<1600),AND(B30+1=B31,D31>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N30=\"J\",VLOOKUP(K30,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A32=\"\",B30,DATE(Jahr,RIGHT(A32,2),LEFT(A32,LEN(A32)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D32>2400,D33>2400,G32=\"X\",G33=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J33<>\"\",L33<>\"\"),\"\",IF(AND(G32+G33>8/24,G32+G33<24/24),VLOOKUP(K32,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B32-B30=1,D30=2400,ISNUMBER(C32),C32=0,G32<1),AND(B34-B32=1,C34=0,D32=2400,G32<1)),VLOOKUP(K32,Staaten!$A$7:$D$335,4,0),IF(G32+G33>=24/24,VLOOKUP(K32,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B32+100-B33<>0,N32=\"N\"),VLOOKUP(K32,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B32+100-B33<>0,N32=\"N\"),VLOOKUP(K32,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q32=\"\",\"\",VLOOKUP(Q32,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q32=\"\",\"\",O32*R32)","v":""},null,{"$f":"IF(LEFT(W33,4)=\"Kürz\",-MIN(LEFT(RIGHT(W33,7),5)*1,L32),IF(AND($A$4=\"A\",W33=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W33,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W33,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W33,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W33,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A33=\"\",B32,DATE(Z$14,RIGHT(A33,2),LEFT(A33,LEN(A33)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C32=\"\",D32<>\"\"),AND(C33=\"\",D33<>\"\"),D32>2400,D33>2400,G32=\"X\",G33=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B31=B32,E32<F31),AND(A32<>\"\",B30=B32,E32<F30),AND(B32=B33,E33<F32)),\"Datum + Uhrzeit prüfen !\",IF(AND(E33+1-F32<>0,B32+1-B33=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G32+G33>0,I32<=0),\"Geschäftspartner ?\",IF(AND(G32+G33>0,I33<=0),\"Reisezweck fehlt!\",IF(AND(G32+G33>0,J32<=0),\"Ort fehlt!\",IF(AND(G32+G33>0,J32=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D32>0,B32<=0),\"Datum fehlt !\",IF(AND(D33>0,B33<=0),\"Datum fehlt !\",IF(NOT(OR(B32=B33,B32+1=B33,B33<=0,)),\"Datum prüfen !\",IF(OR(AND(B31=B32,E32<F31),AND(B32=B33,E33<F32)),\"Datum + Uhrzeit prüfen !\",IF(AND(E33+1-F32<>0,B32+1=B33),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B32+1=B33,C32<1600),AND(B32+1=B33,D33>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N32=\"J\",VLOOKUP(K32,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A34=\"\",B32,DATE(Jahr,RIGHT(A34,2),LEFT(A34,LEN(A34)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D34>2400,D35>2400,G34=\"X\",G35=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J35<>\"\",L35<>\"\"),\"\",IF(AND(G34+G35>8/24,G34+G35<24/24),VLOOKUP(K34,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B34-B32=1,D32=2400,ISNUMBER(C34),C34=0,G34<1),AND(B36-B34=1,C36=0,D34=2400,G34<1)),VLOOKUP(K34,Staaten!$A$7:$D$335,4,0),IF(G34+G35>=24/24,VLOOKUP(K34,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B34+100-B35<>0,N34=\"N\"),VLOOKUP(K34,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B34+100-B35<>0,N34=\"N\"),VLOOKUP(K34,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q34=\"\",\"\",VLOOKUP(Q34,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q34=\"\",\"\",O34*R34)","v":""},null,{"$f":"IF(LEFT(W35,4)=\"Kürz\",-MIN(LEFT(RIGHT(W35,7),5)*1,L34),IF(AND($A$4=\"A\",W35=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W35,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W35,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W35,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W35,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A35=\"\",B34,DATE(Z$14,RIGHT(A35,2),LEFT(A35,LEN(A35)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C34=\"\",D34<>\"\"),AND(C35=\"\",D35<>\"\"),D34>2400,D35>2400,G34=\"X\",G35=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B33=B34,E34<F33),AND(A34<>\"\",B32=B34,E34<F32),AND(B34=B35,E35<F34)),\"Datum + Uhrzeit prüfen !\",IF(AND(E35+1-F34<>0,B34+1-B35=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G34+G35>0,I34<=0),\"Geschäftspartner ?\",IF(AND(G34+G35>0,I35<=0),\"Reisezweck fehlt!\",IF(AND(G34+G35>0,J34<=0),\"Ort fehlt!\",IF(AND(G34+G35>0,J34=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D34>0,B34<=0),\"Datum fehlt !\",IF(AND(D35>0,B35<=0),\"Datum fehlt !\",IF(NOT(OR(B34=B35,B34+1=B35,B35<=0,)),\"Datum prüfen !\",IF(OR(AND(B33=B34,E34<F33),AND(B34=B35,E35<F34)),\"Datum + Uhrzeit prüfen !\",IF(AND(E35+1-F34<>0,B34+1=B35),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B34+1=B35,C34<1600),AND(B34+1=B35,D35>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N34=\"J\",VLOOKUP(K34,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A36=\"\",B34,DATE(Jahr,RIGHT(A36,2),LEFT(A36,LEN(A36)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D36>2400,D37>2400,G36=\"X\",G37=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J37<>\"\",L37<>\"\"),\"\",IF(AND(G36+G37>8/24,G36+G37<24/24),VLOOKUP(K36,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B36-B34=1,D34=2400,ISNUMBER(C36),C36=0,G36<1),AND(B38-B36=1,C38=0,D36=2400,G36<1)),VLOOKUP(K36,Staaten!$A$7:$D$335,4,0),IF(G36+G37>=24/24,VLOOKUP(K36,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B36+100-B37<>0,N36=\"N\"),VLOOKUP(K36,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B36+100-B37<>0,N36=\"N\"),VLOOKUP(K36,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q36=\"\",\"\",VLOOKUP(Q36,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q36=\"\",\"\",O36*R36)","v":""},null,{"$f":"IF(LEFT(W37,4)=\"Kürz\",-MIN(LEFT(RIGHT(W37,7),5)*1,L36),IF(AND($A$4=\"A\",W37=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W37,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W37,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W37,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W37,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A37=\"\",B36,DATE(Z$14,RIGHT(A37,2),LEFT(A37,LEN(A37)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C36=\"\",D36<>\"\"),AND(C37=\"\",D37<>\"\"),D36>2400,D37>2400,G36=\"X\",G37=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B35=B36,E36<F35),AND(A36<>\"\",B34=B36,E36<F34),AND(B36=B37,E37<F36)),\"Datum + Uhrzeit prüfen !\",IF(AND(E37+1-F36<>0,B36+1-B37=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G36+G37>0,I36<=0),\"Geschäftspartner ?\",IF(AND(G36+G37>0,I37<=0),\"Reisezweck fehlt!\",IF(AND(G36+G37>0,J36<=0),\"Ort fehlt!\",IF(AND(G36+G37>0,J36=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D36>0,B36<=0),\"Datum fehlt !\",IF(AND(D37>0,B37<=0),\"Datum fehlt !\",IF(NOT(OR(B36=B37,B36+1=B37,B37<=0,)),\"Datum prüfen !\",IF(OR(AND(B35=B36,E36<F35),AND(B36=B37,E37<F36)),\"Datum + Uhrzeit prüfen !\",IF(AND(E37+1-F36<>0,B36+1=B37),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B36+1=B37,C36<1600),AND(B36+1=B37,D37>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N36=\"J\",VLOOKUP(K36,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A38=\"\",B36,DATE(Jahr,RIGHT(A38,2),LEFT(A38,LEN(A38)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D38>2400,D39>2400,G38=\"X\",G39=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J39<>\"\",L39<>\"\"),\"\",IF(AND(G38+G39>8/24,G38+G39<24/24),VLOOKUP(K38,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B38-B36=1,D36=2400,ISNUMBER(C38),C38=0,G38<1),AND(B40-B38=1,C40=0,D38=2400,G38<1)),VLOOKUP(K38,Staaten!$A$7:$D$335,4,0),IF(G38+G39>=24/24,VLOOKUP(K38,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B38+100-B39<>0,N38=\"N\"),VLOOKUP(K38,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B38+100-B39<>0,N38=\"N\"),VLOOKUP(K38,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q38=\"\",\"\",VLOOKUP(Q38,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q38=\"\",\"\",O38*R38)","v":""},null,{"$f":"IF(LEFT(W39,4)=\"Kürz\",-MIN(LEFT(RIGHT(W39,7),5)*1,L38),IF(AND($A$4=\"A\",W39=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W39,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W39,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W39,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W39,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A39=\"\",B38,DATE(Z$14,RIGHT(A39,2),LEFT(A39,LEN(A39)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C38=\"\",D38<>\"\"),AND(C39=\"\",D39<>\"\"),D38>2400,D39>2400,G38=\"X\",G39=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B37=B38,E38<F37),AND(A38<>\"\",B36=B38,E38<F36),AND(B38=B39,E39<F38)),\"Datum + Uhrzeit prüfen !\",IF(AND(E39+1-F38<>0,B38+1-B39=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G38+G39>0,I38<=0),\"Geschäftspartner ?\",IF(AND(G38+G39>0,I39<=0),\"Reisezweck fehlt!\",IF(AND(G38+G39>0,J38<=0),\"Ort fehlt!\",IF(AND(G38+G39>0,J38=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D38>0,B38<=0),\"Datum fehlt !\",IF(AND(D39>0,B39<=0),\"Datum fehlt !\",IF(NOT(OR(B38=B39,B38+1=B39,B39<=0,)),\"Datum prüfen !\",IF(OR(AND(B37=B38,E38<F37),AND(B38=B39,E39<F38)),\"Datum + Uhrzeit prüfen !\",IF(AND(E39+1-F38<>0,B38+1=B39),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B38+1=B39,C38<1600),AND(B38+1=B39,D39>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N38=\"J\",VLOOKUP(K38,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A40=\"\",B38,DATE(Jahr,RIGHT(A40,2),LEFT(A40,LEN(A40)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D40>2400,D41>2400,G40=\"X\",G41=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J41<>\"\",L41<>\"\"),\"\",IF(AND(G40+G41>8/24,G40+G41<24/24),VLOOKUP(K40,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B40-B38=1,D38=2400,ISNUMBER(C40),C40=0,G40<1),AND(B42-B40=1,C42=0,D40=2400,G40<1)),VLOOKUP(K40,Staaten!$A$7:$D$335,4,0),IF(G40+G41>=24/24,VLOOKUP(K40,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B40+100-B41<>0,N40=\"N\"),VLOOKUP(K40,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B40+100-B41<>0,N40=\"N\"),VLOOKUP(K40,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q40=\"\",\"\",VLOOKUP(Q40,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q40=\"\",\"\",O40*R40)","v":""},null,{"$f":"IF(LEFT(W41,4)=\"Kürz\",-MIN(LEFT(RIGHT(W41,7),5)*1,L40),IF(AND($A$4=\"A\",W41=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W41,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W41,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W41,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W41,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A41=\"\",B40,DATE(Z$14,RIGHT(A41,2),LEFT(A41,LEN(A41)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C40=\"\",D40<>\"\"),AND(C41=\"\",D41<>\"\"),D40>2400,D41>2400,G40=\"X\",G41=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B39=B40,E40<F39),AND(A40<>\"\",B38=B40,E40<F38),AND(B40=B41,E41<F40)),\"Datum + Uhrzeit prüfen !\",IF(AND(E41+1-F40<>0,B40+1-B41=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G40+G41>0,I40<=0),\"Geschäftspartner ?\",IF(AND(G40+G41>0,I41<=0),\"Reisezweck fehlt!\",IF(AND(G40+G41>0,J40<=0),\"Ort fehlt!\",IF(AND(G40+G41>0,J40=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D40>0,B40<=0),\"Datum fehlt !\",IF(AND(D41>0,B41<=0),\"Datum fehlt !\",IF(NOT(OR(B40=B41,B40+1=B41,B41<=0,)),\"Datum prüfen !\",IF(OR(AND(B39=B40,E40<F39),AND(B40=B41,E41<F40)),\"Datum + Uhrzeit prüfen !\",IF(AND(E41+1-F40<>0,B40+1=B41),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B40+1=B41,C40<1600),AND(B40+1=B41,D41>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N40=\"J\",VLOOKUP(K40,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(A42=\"\",B40,DATE(Jahr,RIGHT(A42,2),LEFT(A42,LEN(A42)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,null," ",{"$f":"IF(OR(D42>2400,D43>2400,G42=\"X\",G43=\"X\"),\"Uhrzeit prüfen!\",IF(OR(J43<>\"\",L43<>\"\"),\"\",IF(AND(G42+G43>8/24,G42+G43<24/24),VLOOKUP(K42,Staaten!$A$7:$D$335,3,0),IF(OR(AND(B42-B40=1,D40=2400,ISNUMBER(C42),C42=0,G42<1),AND(B44-B42=1,C44=0,D42=2400,G42<1)),VLOOKUP(K42,Staaten!$A$7:$D$335,4,0),IF(G42+G43>=24/24,VLOOKUP(K42,Staaten!$A$7:$B$335,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B42+100-B43<>0,N42=\"N\"),VLOOKUP(K42,Staaten!$A$7:$E$335,5,FALSE),IF(AND($A$3=\"U\",B42+100-B43<>0,N42=\"N\"),VLOOKUP(K42,Staaten!$A$4:$E$335,5,FALSE),\" \"))","v":" "},null,null,null,null,{"$f":"IF(Q42=\"\",\"\",VLOOKUP(Q42,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q42=\"\",\"\",O42*R42)","v":""},null,{"$f":"IF(LEFT(W43,4)=\"Kürz\",-MIN(LEFT(RIGHT(W43,7),5)*1,L42),IF(AND($A$4=\"A\",W43=\"Übern.Pauschale AN 20 €\"),20,\"\"))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W43,Kontenplan!$A$4:$B$113,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W43,Kontenplan!$A$4:$B$113,2,0),IF(ISERROR(VLOOKUP(W43,Kontenplan!$A$4:$C$113,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W43,Kontenplan!$A$4:$C$113,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A43=\"\",B42,DATE(Z$14,RIGHT(A43,2),LEFT(A43,LEN(A43)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,{"$f":"IF(OR(AND(C42=\"\",D42<>\"\"),AND(C43=\"\",D43<>\"\"),D42>2400,D43>2400,G42=\"X\",G43=\"X\"),\"Uhrzeit prüfen!\",IF(OR(AND(B41=B42,E42<F41),AND(A42<>\"\",B40=B42,E42<F40),AND(B42=B43,E43<F42)),\"Datum + Uhrzeit prüfen !\",IF(AND(E43+1-F42<>0,B42+1-B43=0),\"Datum + Uhrzeit prüfen !\",IF(AND(G42+G43>0,I42<=0),\"Geschäftspartner ?\",IF(AND(G42+G43>0,I43<=0),\"Reisezweck fehlt!\",IF(AND(G42+G43>0,J42<=0),\"Ort fehlt!\",IF(AND(G42+G43>0,J42=\" \"),\"Ort fehlt!\",\"\")))))))","v":""},null,{"$f":"IF(AND(D42>0,B42<=0),\"Datum fehlt !\",IF(AND(D43>0,B43<=0),\"Datum fehlt !\",IF(NOT(OR(B42=B43,B42+1=B43,B43<=0,)),\"Datum prüfen !\",IF(OR(AND(B41=B42,E42<F41),AND(B42=B43,E43<F42)),\"Datum + Uhrzeit prüfen !\",IF(AND(E43+1-F42<>0,B42+1=B43),\"Datum + Uhrzeit prüfen !\",IF(OR(AND(B42+1=B43,C42<1600),AND(B42+1=B43,D43>800)),\"Pauschale prüfen !\",\"\"))))))","v":""},{"$f":"IF(N42=\"J\",VLOOKUP(K42,Staaten!$A$7:$F$335,6,FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L43)","v":0},null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,{"$f":"IF(AND(A3=\"U\",C45<>\"\"),\"Pauschalversteuerung bei Unternehmer nicht möglich !\",\"Zuschlag bei Pauschalversteuerung (25% + KiSt + SolZ) durch Arbeitgeber\")","v":"Zuschlag bei Pauschalversteuerung (25% + KiSt + SolZ) durch Arbeitgeber"},null,null,null,null,null,null,null,{"$f":"IF(A3=\"A\",ROUND(L44*C45,2),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Euro"]
[null,null,{"$f":"IF(L45>L44,L45-L44,\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"SUM(L44:L45)","v":0},{"$f":"SUM(M10:M43)","v":0},null,null,null,null,null,{"$f":"SUM(S10:S43)","v":0},{"$f":"SUM(T10:T43)","v":0},{"$f":"SUM(U10:U43)","v":0},null,{"$f":"SUM(L46:M46)+SUM(S46:U46)","v":0}]
[]
[]
["Kontierung",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"A\",\"     6664\",\"     6674\")","v":"     6664"},{"$f":"IF($A$3=\"A\",\"     6660\",\"     6680\")","v":"     6660"},null,null,null,null,null,{"$f":"IF($A$3=\"A\",6668,6688)","v":6668},906640,null,null,"Auszahlung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bar / Scheck Nr. "]
[]
["..................... ",null,null,{"$f":"L2","v":"2020-01-31"}]
[]
[null,null,null,null,null,null,null,null,"(Unterschrift)"]

{"sheet":"VSt.Verpfl.","index":1,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[44,7,45,7],[1,0,1,5],[44,6,45,6],[1,8,1,10],[2,1,2,3],[50,2,50,3],[4,6,4,10],[44,1,44,5],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[44,9,45,9],[44,10,45,10],[44,8,45,8],[5,7,5,8],[4,1,4,2]]}
[]
["Vorsteuerabzug aus \nReisekosten-Abrechnung",null,null,null,null,null,null,null,{"$f":"Reisek.!T2","v":"Thomas Mustermann"}]
[null,{"$f":"Reisek.!J2","v":"2020-01-01"},null,null,null,{"$f":"Reisek.!L2","v":"2020-01-31"}]
[]
["Datum","Uhrzeit",null,"Stunden",null,"\nGeschäftspartner","Verpflegungsmehraufwand"]
[null,"von","bis",null,null,"Reisezweck","- Pauschale -","tatsächliche Kosten",null,"VSt.-Abzug aus","abziehbare VSt."]
[null,null,null,null,null,null,"€",{"$f":"G7","v":"€"},"% VSt.",{"$f":"G7","v":"€"},{"$f":"G7","v":"€"}]
[]
[{"$f":"IF(Reisek.!A10<=0,\" \",Reisek.!A10)","v":" "},{"$f":"IF(OR(Reisek.!E10=0,Reisek.!G10=0),\"\",Reisek.!E10)","v":""},{"$f":"IF(Reisek.!F10=0,\" \",Reisek.!F10)","v":" "},{"$f":"IF(Reisek.!G10=0,\" \",Reisek.!G10)","v":" "},null,{"$f":"IF(Reisek.!I10<=0,\" \",Reisek.!I10)","v":" "},{"$f":"IF(Reisek.!L10=\"\",0,Reisek.!L10)","v":0},null,null,{"$f":"IF(H9=\"\",\"\",IF(Reisek.!$A$3=\"U\",H9,IF(AND(Reisek.!$A$3=\"A\",(H9+H10)<=G9*(1+Reisek.!$C$45)),H9,\"\")))","v":""},{"$f":"IF(J9=\"\",\"\",ROUND(J9/(100+I9)*I9,2))","v":""}]
[{"$f":"IF(Reisek.!A11<=0,\" \",Reisek.!A11)","v":" "},{"$f":"IF(OR(Reisek.!E11=0,Reisek.!G11=0),\"\",Reisek.!E11)","v":""},{"$f":"IF(Reisek.!F11=0,\" \",Reisek.!F11)","v":" "},{"$f":"IF(Reisek.!G11=0,\" \",Reisek.!G11)","v":" "},null,{"$f":"IF(Reisek.!I11<=0,\" \",Reisek.!I11)","v":" "},{"$f":"IF(Reisek.!L11=\"\",0,Reisek.!L11)","v":0},null,null,{"$f":"IF(H10=\"\",\"\",IF(Reisek.!$A$3=\"U\",H10,IF(AND(Reisek.!$A$3=\"A\",(H9+H10)<=G9*(1+Reisek.!$C$45)),H10,\"\")))","v":""},{"$f":"IF(J10=\"\",\"\",ROUND(J10/(100+I10)*I10,2))","v":""}]
[{"$f":"IF(Reisek.!A12<=0,\" \",Reisek.!A12)","v":" "},{"$f":"IF(OR(Reisek.!E12=0,Reisek.!G12=0),\"\",Reisek.!E12)","v":""},{"$f":"IF(Reisek.!F12=0,\" \",Reisek.!F12)","v":" "},{"$f":"IF(Reisek.!G12=0,\" \",Reisek.!G12)","v":" "},null,{"$f":"IF(Reisek.!I12<=0,\" \",Reisek.!I12)","v":" "},{"$f":"IF(Reisek.!L12=\"\",0,Reisek.!L12)","v":0},null,null,{"$f":"IF(H11=\"\",\"\",IF(Reisek.!$A$3=\"U\",H11,IF(AND(Reisek.!$A$3=\"A\",(H11+H12)<=G11*(1+Reisek.!$C$45)),H11,\"\")))","v":""},{"$f":"IF(J11=\"\",\"\",ROUND(J11/(100+I11)*I11,2))","v":""}]
[{"$f":"IF(Reisek.!A13<=0,\" \",Reisek.!A13)","v":" "},{"$f":"IF(OR(Reisek.!E13=0,Reisek.!G13=0),\"\",Reisek.!E13)","v":""},{"$f":"IF(Reisek.!F13=0,\" \",Reisek.!F13)","v":" "},{"$f":"IF(Reisek.!G13=0,\" \",Reisek.!G13)","v":" "},null,{"$f":"IF(Reisek.!I13<=0,\" \",Reisek.!I13)","v":" "},{"$f":"IF(Reisek.!L13=\"\",0,Reisek.!L13)","v":0},null,null,{"$f":"IF(H12=\"\",\"\",IF(Reisek.!$A$3=\"U\",H12,IF(AND(Reisek.!$A$3=\"A\",(H11+H12)<=G11*(1+Reisek.!$C$45)),H12,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A14<=0,\" \",Reisek.!A14)","v":" "},{"$f":"IF(OR(Reisek.!E14=0,Reisek.!G14=0),\"\",Reisek.!E14)","v":""},{"$f":"IF(Reisek.!F14=0,\" \",Reisek.!F14)","v":" "},{"$f":"IF(Reisek.!G14=0,\" \",Reisek.!G14)","v":" "},null,{"$f":"IF(Reisek.!I14<=0,\" \",Reisek.!I14)","v":" "},{"$f":"IF(Reisek.!L14=\"\",0,Reisek.!L14)","v":0},null,null,{"$f":"IF(H13=\"\",\"\",IF(Reisek.!$A$3=\"U\",H13,IF(AND(Reisek.!$A$3=\"A\",(H13+H14)<=G13*(1+Reisek.!$C$45)),H13,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A15<=0,\" \",Reisek.!A15)","v":" "},{"$f":"IF(OR(Reisek.!E15=0,Reisek.!G15=0),\"\",Reisek.!E15)","v":""},{"$f":"IF(Reisek.!F15=0,\" \",Reisek.!F15)","v":" "},{"$f":"IF(Reisek.!G15=0,\" \",Reisek.!G15)","v":" "},null,{"$f":"IF(Reisek.!I15<=0,\" \",Reisek.!I15)","v":" "},{"$f":"IF(Reisek.!L15=\"\",0,Reisek.!L15)","v":0},null,null,{"$f":"IF(H14=\"\",\"\",IF(Reisek.!$A$3=\"U\",H14,IF(AND(Reisek.!$A$3=\"A\",(H13+H14)<=G13*(1+Reisek.!$C$45)),H14,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A16<=0,\" \",Reisek.!A16)","v":" "},{"$f":"IF(OR(Reisek.!E16=0,Reisek.!G16=0),\"\",Reisek.!E16)","v":""},{"$f":"IF(Reisek.!F16=0,\" \",Reisek.!F16)","v":" "},{"$f":"IF(Reisek.!G16=0,\" \",Reisek.!G16)","v":" "},null,{"$f":"IF(Reisek.!I16<=0,\" \",Reisek.!I16)","v":" "},{"$f":"IF(Reisek.!L16=\"\",0,Reisek.!L16)","v":0},null,null,{"$f":"IF(H15=\"\",\"\",IF(Reisek.!$A$3=\"U\",H15,IF(AND(Reisek.!$A$3=\"A\",(H15+H16)<=G15*(1+Reisek.!$C$45)),H15,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A17<=0,\" \",Reisek.!A17)","v":" "},{"$f":"IF(OR(Reisek.!E17=0,Reisek.!G17=0),\"\",Reisek.!E17)","v":""},{"$f":"IF(Reisek.!F17=0,\" \",Reisek.!F17)","v":" "},{"$f":"IF(Reisek.!G17=0,\" \",Reisek.!G17)","v":" "},null,{"$f":"IF(Reisek.!I17<=0,\" \",Reisek.!I17)","v":" "},{"$f":"IF(Reisek.!L17=\"\",0,Reisek.!L17)","v":0},null,null,{"$f":"IF(H16=\"\",\"\",IF(Reisek.!$A$3=\"U\",H16,IF(AND(Reisek.!$A$3=\"A\",(H15+H16)<=G15*(1+Reisek.!$C$45)),H16,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A18<=0,\" \",Reisek.!A18)","v":" "},{"$f":"IF(OR(Reisek.!E18=0,Reisek.!G18=0),\"\",Reisek.!E18)","v":""},{"$f":"IF(Reisek.!F18=0,\" \",Reisek.!F18)","v":" "},{"$f":"IF(Reisek.!G18=0,\" \",Reisek.!G18)","v":" "},null,{"$f":"IF(Reisek.!I18<=0,\" \",Reisek.!I18)","v":" "},{"$f":"IF(Reisek.!L18=\"\",0,Reisek.!L18)","v":0},null,null,{"$f":"IF(H17=\"\",\"\",IF(Reisek.!$A$3=\"U\",H17,IF(AND(Reisek.!$A$3=\"A\",(H17+H18)<=G17*(1+Reisek.!$C$45)),H17,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A19<=0,\" \",Reisek.!A19)","v":" "},{"$f":"IF(OR(Reisek.!E19=0,Reisek.!G19=0),\"\",Reisek.!E19)","v":""},{"$f":"IF(Reisek.!F19=0,\" \",Reisek.!F19)","v":" "},{"$f":"IF(Reisek.!G19=0,\" \",Reisek.!G19)","v":" "},null,{"$f":"IF(Reisek.!I19<=0,\" \",Reisek.!I19)","v":" "},{"$f":"IF(Reisek.!L19=\"\",0,Reisek.!L19)","v":0},null,null,{"$f":"IF(H18=\"\",\"\",IF(Reisek.!$A$3=\"U\",H18,IF(AND(Reisek.!$A$3=\"A\",(H17+H18)<=G17*(1+Reisek.!$C$45)),H18,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A20<=0,\" \",Reisek.!A20)","v":" "},{"$f":"IF(OR(Reisek.!E20=0,Reisek.!G20=0),\"\",Reisek.!E20)","v":""},{"$f":"IF(Reisek.!F20=0,\" \",Reisek.!F20)","v":" "},{"$f":"IF(Reisek.!G20=0,\" \",Reisek.!G20)","v":" "},null,{"$f":"IF(Reisek.!I20<=0,\" \",Reisek.!I20)","v":" "},{"$f":"IF(Reisek.!L20=\"\",0,Reisek.!L20)","v":0},null,null,{"$f":"IF(H19=\"\",\"\",IF(Reisek.!$A$3=\"U\",H19,IF(AND(Reisek.!$A$3=\"A\",(H19+H20)<=G19*(1+Reisek.!$C$45)),H19,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E21=0,Reisek.!G21=0),\"\",Reisek.!E21)","v":""},null,{"$f":"IF(Reisek.!G21=0,\" \",Reisek.!G21)","v":" "},null,null,{"$f":"IF(Reisek.!L21=\"\",0,Reisek.!L21)","v":0},null,null,{"$f":"IF(H20=\"\",\"\",IF(Reisek.!$A$3=\"U\",H20,IF(AND(Reisek.!$A$3=\"A\",(H19+H20)<=G19*(1+Reisek.!$C$45)),H20,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A22<=0,\" \",Reisek.!A22)","v":" "},{"$f":"IF(OR(Reisek.!E22=0,Reisek.!G22=0),\"\",Reisek.!E22)","v":""},{"$f":"IF(Reisek.!F22=0,\" \",Reisek.!F22)","v":" "},{"$f":"IF(Reisek.!G22=0,\" \",Reisek.!G22)","v":" "},null,{"$f":"IF(Reisek.!I22<=0,\" \",Reisek.!I22)","v":" "},{"$f":"IF(Reisek.!L22=\"\",0,Reisek.!L22)","v":0},null,null,{"$f":"IF(H21=\"\",\"\",IF(Reisek.!$A$3=\"U\",H21,IF(AND(Reisek.!$A$3=\"A\",(H21+H22)<=G21*(1+Reisek.!$C$45)),H21,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E23=0,Reisek.!G23=0),\"\",Reisek.!E23)","v":""},null,{"$f":"IF(Reisek.!G23=0,\" \",Reisek.!G23)","v":" "},null,null,{"$f":"IF(Reisek.!L23=\"\",0,Reisek.!L23)","v":0},null,null,{"$f":"IF(H22=\"\",\"\",IF(Reisek.!$A$3=\"U\",H22,IF(AND(Reisek.!$A$3=\"A\",(H21+H22)<=G21*(1+Reisek.!$C$45)),H22,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A24<=0,\" \",Reisek.!A24)","v":" "},{"$f":"IF(OR(Reisek.!E24=0,Reisek.!G24=0),\"\",Reisek.!E24)","v":""},{"$f":"IF(Reisek.!F24=0,\" \",Reisek.!F24)","v":" "},{"$f":"IF(Reisek.!G24=0,\" \",Reisek.!G24)","v":" "},null,{"$f":"IF(Reisek.!I24<=0,\" \",Reisek.!I24)","v":" "},{"$f":"IF(Reisek.!L24=\"\",0,Reisek.!L24)","v":0},null,null,{"$f":"IF(H23=\"\",\"\",IF(Reisek.!$A$3=\"U\",H23,IF(AND(Reisek.!$A$3=\"A\",(H23+H24)<=G23*(1+Reisek.!$C$45)),H23,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E25=0,Reisek.!G25=0),\"\",Reisek.!E25)","v":""},null,{"$f":"IF(Reisek.!G25=0,\" \",Reisek.!G25)","v":" "},null,null,{"$f":"IF(Reisek.!L25=\"\",0,Reisek.!L25)","v":0},null,null,{"$f":"IF(H24=\"\",\"\",IF(Reisek.!$A$3=\"U\",H24,IF(AND(Reisek.!$A$3=\"A\",(H23+H24)<=G23*(1+Reisek.!$C$45)),H24,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A26<=0,\" \",Reisek.!A26)","v":" "},{"$f":"IF(OR(Reisek.!E26=0,Reisek.!G26=0),\"\",Reisek.!E26)","v":""},{"$f":"IF(Reisek.!F26=0,\" \",Reisek.!F26)","v":" "},{"$f":"IF(Reisek.!G26=0,\" \",Reisek.!G26)","v":" "},null,{"$f":"IF(Reisek.!I26<=0,\" \",Reisek.!I26)","v":" "},{"$f":"IF(Reisek.!L26=\"\",0,Reisek.!L26)","v":0},null,null,{"$f":"IF(H25=\"\",\"\",IF(Reisek.!$A$3=\"U\",H25,IF(AND(Reisek.!$A$3=\"A\",(H25+H26)<=G25*(1+Reisek.!$C$45)),H25,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E27=0,Reisek.!G27=0),\"\",Reisek.!E27)","v":""},null,{"$f":"IF(Reisek.!G27=0,\" \",Reisek.!G27)","v":" "},null,null,{"$f":"IF(Reisek.!L27=\"\",0,Reisek.!L27)","v":0},null,null,{"$f":"IF(H26=\"\",\"\",IF(Reisek.!$A$3=\"U\",H26,IF(AND(Reisek.!$A$3=\"A\",(H25+H26)<=G25*(1+Reisek.!$C$45)),H26,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A28<=0,\" \",Reisek.!A28)","v":" "},{"$f":"IF(OR(Reisek.!E28=0,Reisek.!G28=0),\"\",Reisek.!E28)","v":""},{"$f":"IF(Reisek.!F28=0,\" \",Reisek.!F28)","v":" "},{"$f":"IF(Reisek.!G28=0,\" \",Reisek.!G28)","v":" "},null,{"$f":"IF(Reisek.!I28<=0,\" \",Reisek.!I28)","v":" "},{"$f":"IF(Reisek.!L28=\"\",0,Reisek.!L28)","v":0},null,null,{"$f":"IF(H27=\"\",\"\",IF(Reisek.!$A$3=\"U\",H27,IF(AND(Reisek.!$A$3=\"A\",(H27+H28)<=G27*(1+Reisek.!$C$45)),H27,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E29=0,Reisek.!G29=0),\"\",Reisek.!E29)","v":""},null,{"$f":"IF(Reisek.!G29=0,\" \",Reisek.!G29)","v":" "},null,null,{"$f":"IF(Reisek.!L29=\"\",0,Reisek.!L29)","v":0},null,null,{"$f":"IF(H28=\"\",\"\",IF(Reisek.!$A$3=\"U\",H28,IF(AND(Reisek.!$A$3=\"A\",(H27+H28)<=G27*(1+Reisek.!$C$45)),H28,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A30<=0,\" \",Reisek.!A30)","v":" "},{"$f":"IF(OR(Reisek.!E30=0,Reisek.!G30=0),\"\",Reisek.!E30)","v":""},{"$f":"IF(Reisek.!F30=0,\" \",Reisek.!F30)","v":" "},{"$f":"IF(Reisek.!G30=0,\" \",Reisek.!G30)","v":" "},null,{"$f":"IF(Reisek.!I30<=0,\" \",Reisek.!I30)","v":" "},{"$f":"IF(Reisek.!L30=\"\",0,Reisek.!L30)","v":0},null,null,{"$f":"IF(H29=\"\",\"\",IF(Reisek.!$A$3=\"U\",H29,IF(AND(Reisek.!$A$3=\"A\",(H29+H30)<=G29*(1+Reisek.!$C$45)),H29,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E31=0,Reisek.!G31=0),\"\",Reisek.!E31)","v":""},null,{"$f":"IF(Reisek.!G31=0,\" \",Reisek.!G31)","v":" "},null,null,{"$f":"IF(Reisek.!L31=\"\",0,Reisek.!L31)","v":0},null,null,{"$f":"IF(H30=\"\",\"\",IF(Reisek.!$A$3=\"U\",H30,IF(AND(Reisek.!$A$3=\"A\",(H29+H30)<=G29*(1+Reisek.!$C$45)),H30,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A32<=0,\" \",Reisek.!A32)","v":" "},{"$f":"IF(OR(Reisek.!E32=0,Reisek.!G32=0),\"\",Reisek.!E32)","v":""},{"$f":"IF(Reisek.!F32=0,\" \",Reisek.!F32)","v":" "},{"$f":"IF(Reisek.!G32=0,\" \",Reisek.!G32)","v":" "},null,{"$f":"IF(Reisek.!I32<=0,\" \",Reisek.!I32)","v":" "},{"$f":"IF(Reisek.!L32=\"\",0,Reisek.!L32)","v":0},null,null,{"$f":"IF(H31=\"\",\"\",IF(Reisek.!$A$3=\"U\",H31,IF(AND(Reisek.!$A$3=\"A\",(H31+H32)<=G31*(1+Reisek.!$C$45)),H31,\"\")))","v":""},""]
[null,{"$f":"IF(OR(Reisek.!E33=0,Reisek.!G33=0),\"\",Reisek.!E33)","v":""},null,{"$f":"IF(Reisek.!G33=0,\" \",Reisek.!G33)","v":" "},null,null,{"$f":"IF(Reisek.!L33=\"\",0,Reisek.!L33)","v":0},null,null,{"$f":"IF(H32=\"\",\"\",IF(Reisek.!$A$3=\"U\",H32,IF(AND(Reisek.!$A$3=\"A\",(H31+H32)<=G31*(1+Reisek.!$C$45)),H32,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A34<=0,\" \",Reisek.!A34)","v":" "},{"$f":"IF(OR(Reisek.!E34=0,Reisek.!G34=0),\"\",Reisek.!E34)","v":""},{"$f":"IF(Reisek.!F34=0,\" \",Reisek.!F34)","v":" "},{"$f":"IF(Reisek.!G34=0,\" \",Reisek.!G34)","v":" "},null,{"$f":"IF(Reisek.!I34<=0,\" \",Reisek.!I34)","v":" "},{"$f":"IF(Reisek.!L34=\"\",0,Reisek.!L34)","v":0},null,null,{"$f":"IF(H33=\"\",\"\",IF(Reisek.!$A$3=\"U\",H33,IF(AND(Reisek.!$A$3=\"A\",(H33+H34)<=G33*(1+Reisek.!$C$45)),H33,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A35<=0,\" \",Reisek.!A35)","v":" "},{"$f":"IF(OR(Reisek.!E35=0,Reisek.!G35=0),\"\",Reisek.!E35)","v":""},{"$f":"IF(Reisek.!F35=0,\" \",Reisek.!F35)","v":" "},{"$f":"IF(Reisek.!G35=0,\" \",Reisek.!G35)","v":" "},null,{"$f":"IF(Reisek.!I35<=0,\" \",Reisek.!I35)","v":" "},{"$f":"IF(Reisek.!L35=\"\",0,Reisek.!L35)","v":0},null,null,{"$f":"IF(H34=\"\",\"\",IF(Reisek.!$A$3=\"U\",H34,IF(AND(Reisek.!$A$3=\"A\",(H33+H34)<=G33*(1+Reisek.!$C$45)),H34,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A36<=0,\" \",Reisek.!A36)","v":" "},{"$f":"IF(OR(Reisek.!E36=0,Reisek.!G36=0),\"\",Reisek.!E36)","v":""},{"$f":"IF(Reisek.!F36=0,\" \",Reisek.!F36)","v":" "},{"$f":"IF(Reisek.!G36=0,\" \",Reisek.!G36)","v":" "},null,{"$f":"IF(Reisek.!I36<=0,\" \",Reisek.!I36)","v":" "},{"$f":"IF(Reisek.!L36=\"\",0,Reisek.!L36)","v":0},null,null,{"$f":"IF(H35=\"\",\"\",IF(Reisek.!$A$3=\"U\",H35,IF(AND(Reisek.!$A$3=\"A\",(H35+H36)<=G35*(1+Reisek.!$C$45)),H35,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A37<=0,\" \",Reisek.!A37)","v":" "},{"$f":"IF(OR(Reisek.!E37=0,Reisek.!G37=0),\"\",Reisek.!E37)","v":""},{"$f":"IF(Reisek.!F37=0,\" \",Reisek.!F37)","v":" "},{"$f":"IF(Reisek.!G37=0,\" \",Reisek.!G37)","v":" "},null,{"$f":"IF(Reisek.!I37<=0,\" \",Reisek.!I37)","v":" "},{"$f":"IF(Reisek.!L37=\"\",0,Reisek.!L37)","v":0},null,null,{"$f":"IF(H36=\"\",\"\",IF(Reisek.!$A$3=\"U\",H36,IF(AND(Reisek.!$A$3=\"A\",(H35+H36)<=G35*(1+Reisek.!$C$45)),H36,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A38<=0,\" \",Reisek.!A38)","v":" "},{"$f":"IF(OR(Reisek.!E38=0,Reisek.!G38=0),\"\",Reisek.!E38)","v":""},{"$f":"IF(Reisek.!F38=0,\" \",Reisek.!F38)","v":" "},{"$f":"IF(Reisek.!G38=0,\" \",Reisek.!G38)","v":" "},null,{"$f":"IF(Reisek.!I38<=0,\" \",Reisek.!I38)","v":" "},{"$f":"IF(Reisek.!L38=\"\",0,Reisek.!L38)","v":0},null,null,{"$f":"IF(H37=\"\",\"\",IF(Reisek.!$A$3=\"U\",H37,IF(AND(Reisek.!$A$3=\"A\",(H37+H38)<=G37*(1+Reisek.!$C$45)),H37,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A39<=0,\" \",Reisek.!A39)","v":" "},{"$f":"IF(OR(Reisek.!E39=0,Reisek.!G39=0),\"\",Reisek.!E39)","v":""},{"$f":"IF(Reisek.!F39=0,\" \",Reisek.!F39)","v":" "},{"$f":"IF(Reisek.!G39=0,\" \",Reisek.!G39)","v":" "},null,{"$f":"IF(Reisek.!I39<=0,\" \",Reisek.!I39)","v":" "},{"$f":"IF(Reisek.!L39=\"\",0,Reisek.!L39)","v":0},null,null,{"$f":"IF(H38=\"\",\"\",IF(Reisek.!$A$3=\"U\",H38,IF(AND(Reisek.!$A$3=\"A\",(H37+H38)<=G37*(1+Reisek.!$C$45)),H38,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A40<=0,\" \",Reisek.!A40)","v":" "},{"$f":"IF(OR(Reisek.!E40=0,Reisek.!G40=0),\"\",Reisek.!E40)","v":""},{"$f":"IF(Reisek.!F40=0,\" \",Reisek.!F40)","v":" "},{"$f":"IF(Reisek.!G40=0,\" \",Reisek.!G40)","v":" "},null,{"$f":"IF(Reisek.!I40<=0,\" \",Reisek.!I40)","v":" "},{"$f":"IF(Reisek.!L40=\"\",0,Reisek.!L40)","v":0},null,null,{"$f":"IF(H39=\"\",\"\",IF(Reisek.!$A$3=\"U\",H39,IF(AND(Reisek.!$A$3=\"A\",(H39+H40)<=G39*(1+Reisek.!$C$45)),H39,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A41<=0,\" \",Reisek.!A41)","v":" "},{"$f":"IF(OR(Reisek.!E41=0,Reisek.!G41=0),\"\",Reisek.!E41)","v":""},{"$f":"IF(Reisek.!F41=0,\" \",Reisek.!F41)","v":" "},{"$f":"IF(Reisek.!G41=0,\" \",Reisek.!G41)","v":" "},null,{"$f":"IF(Reisek.!I41<=0,\" \",Reisek.!I41)","v":" "},{"$f":"IF(Reisek.!L41=\"\",0,Reisek.!L41)","v":0},null,null,{"$f":"IF(H40=\"\",\"\",IF(Reisek.!$A$3=\"U\",H40,IF(AND(Reisek.!$A$3=\"A\",(H39+H40)<=G39*(1+Reisek.!$C$45)),H40,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A42<=0,\" \",Reisek.!A42)","v":" "},{"$f":"IF(OR(Reisek.!E42=0,Reisek.!G42=0),\"\",Reisek.!E42)","v":""},{"$f":"IF(Reisek.!F42=0,\" \",Reisek.!F42)","v":" "},{"$f":"IF(Reisek.!G42=0,\" \",Reisek.!G42)","v":" "},null,{"$f":"IF(Reisek.!I42<=0,\" \",Reisek.!I42)","v":" "},{"$f":"IF(Reisek.!L42=\"\",0,Reisek.!L42)","v":0},null,null,{"$f":"IF(H41=\"\",\"\",IF(Reisek.!$A$3=\"U\",H41,IF(AND(Reisek.!$A$3=\"A\",(H41+H42)<=G41*(1+Reisek.!$C$45)),H41,\"\")))","v":""},""]
[{"$f":"IF(Reisek.!A43<=0,\" \",Reisek.!A43)","v":" "},{"$f":"IF(OR(Reisek.!E43=0,Reisek.!G43=0),\"\",Reisek.!E43)","v":""},{"$f":"IF(Reisek.!F43=0,\" \",Reisek.!F43)","v":" "},{"$f":"IF(Reisek.!G43=0,\" \",Reisek.!G43)","v":" "},null,{"$f":"IF(Reisek.!I43<=0,\" \",Reisek.!I43)","v":" "},{"$f":"IF(Reisek.!L43=\"\",0,Reisek.!L43)","v":0},null,null,{"$f":"IF(H42=\"\",\"\",IF(Reisek.!$A$3=\"U\",H42,IF(AND(Reisek.!$A$3=\"A\",(H41+H42)<=G41*(1+Reisek.!$C$45)),H42,\"\")))","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(G9:G42)","v":0},null,null,null,{"$f":"SUM(K9:K42)","v":0}]
[null,{"$f":"IF(Reisek.!C45<=0,\" \",Reisek.!C45)","v":" "},"Zuschlag bei Pauschalversteuerung",null,null,null,{"$f":"Reisek.!L45","v":0}]
[null,{"$f":"IF(G44=\" \",\" \",IF(G44>G43,G44-G43,\" \"))","v":" "},null,null,null,null,{"$f":"SUM(G43:G44)","v":0},null,null,"Kontierung:",{"$f":"\"1400 / \"&RIGHT(Reisek.!L49,4)","v":"1400 / 6664"}]
[]
[]
[]
[]
[]
[{"$f":"Reisek.!A52","v":"..................... "},null,{"$f":"Reisek.!D52","v":"2020-01-31"}]
[]
[null,null,null,null,null,"(Unterschrift)"]

{"sheet":"Staaten","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Dienst und Geschäftsreisen","mind. 24 Std.","weniger als 24 Std.","Tag vor oder nach","Pauschbetrag für","Kürzung für"," "]
[null,null,"aber mehr als 8 Std.","Übernachtung","Übernachtungsk.","Frühstück"," "]
[null,"€",{"$f":"B3","v":"€"},{"$f":"B3","v":"€"},{"$f":"B3","v":"€"},{"$f":"B3","v":"€"}," "]
[" ",{"$f":"IF(Jahr>=2020,28,24)","v":28},{"$f":"IF(Jahr>=2020,14,12)","v":14},14,0,{"$f":"B4*-0.2","v":-5.6000000000000005},"(Unternehmer)"]
["Inland",28,14,14,0,-5.6000000000000005,"(Unternehmer)"]
["Deutschland",28,14,14,0,-5.6000000000000005,"(Unternehmer)"]
["Inland",28,14,14,20,-5.6000000000000005,"(Arbeitnehmer)"]
["Deutschland",28,14,14,20,-5.6000000000000005,"(Arbeitnehmer)"]
[" ",28,14,14,20,-5.6000000000000005,"(Arbeitnehmer)"]
["nicht in Tabelle",47,32,32,130,-9.4,"(wie Luxemburg)"]
["Schiffsreise",47,32,32,130,-9.4,"(wie Luxemburg)"]
["Flugreise über 2 Tage",40,27,27,108,-8,"(wie Österreich)"]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"Fahrzeug","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Fahrzeug","km-Satz"]
["Pkw",0.3]
["Motorr.",0.2,"(für Motorrad oder Motorroller)"]
["Krad",0.2,"(für Motorrad oder Motorroller)"]
["Moped",0.2]
["Mofa",0.2]
["Fahrrad",0.05]

{"sheet":"Kontenplan","index":4,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Kontenplan Reisekosten"]
[null,"Arbeitnehmer","Unternehmer"]
[null,"Konto","Konto"]
[" "," "," "]
["Autobahngebühren 0%","10 6650","10 6670"]
["Autobahngebühren 19%","90 6650","90 6670"]
["Benzin 0%","10 6530",{"$f":"B7","v":"10 6530"}]
["Benzin 19%","90 6530","90 6530"]
["Betriebsbedarf 0%","10 6850","10 6850"]
["Betriebsbedarf 19%","90 6850","90 6850"]
["Bewirtung 0%","10 6640","10 6640"]
["Bürobedarf 0%","10 6815","10 6815"]
["Bürobedarf 19%","90 6815","90 6815"]
["Diesel 0%","10 6530","10 6530"]
["Diesel 19%","90 6530","90 6530"]
["Eintritt Messe 0%","10 6650","10 6670"]
["Eintritt Messe 19%","90 6650","90 6670"]
["Fahrkarte 0%","10 6650","10 6670"]
["Fahrkarte 19%","90 6663","90 6673"]
["Fahrkarte 7%","80 6663","80 6673"]
["Flugticket 0%","10 6650","10 6670"]
["Flugticket 19%","90 6663","90 6673"]
["Garagenmiete 0%","10 6550",{"$f":"B23","v":"10 6550"}]
["Garagenmiete 19%","90 6550","90 6550"]
["Geschenke bis 35,- 0%","10 6610","10 6610"]
["Geschenke bis 35,- 19%","90 6610","90 6610"]
["Kfz-Reparaturen 0%","10 6540","10 6540"]
["Kfz-Reparaturen 19%","90 6540","90 6540"]
["Kleingeräte 0%","10 6845","10 6845"]
["Kleingeräte 19%","90 6845","90 6845"]
[{"$f":"\"Kürzung Frühstück \"&IF(Jahr>=2020,5.6,4.8)&\"0 €\"","v":"Kürzung Frühstück 5,60 €"},"10 6660","10 6680"]
[{"$f":"\"Kürzg.Mittagessen \"&IF(Jahr>=2020,11.2,9.6)&\"0 €\"","v":"Kürzg.Mittagessen 11,20 €"},"10 6660","10 6680"]
[{"$f":"\"Kürzg.Abendessen \"&IF(Jahr>=2020,11.2,9.6)&\"0 €\"","v":"Kürzg.Abendessen 11,20 €"},"10 6660","10 6680"]
[{"$f":"\"Kürzg.Pauschale \"&IF(Jahr>=2020,16.8,14.4)&\"0 €\"","v":"Kürzg.Pauschale 16,80 €"},"10 6660","10 6680"]
[{"$f":"\"Kürzg.Pauschale \"&IF(Jahr>=2020,22.4,19.2)&\"0 €\"","v":"Kürzg.Pauschale 22,40 €"},"10 6660","10 6680"]
[{"$f":"\"Kürzg.Pauschale \"&IF(Jahr>=2020,28,24)&\",00 €\"","v":"Kürzg.Pauschale 28,00 €"},"10 6660","10 6680"]
["Landkarte 0%","10 6650","10 6670"]
["Landkarte 7%","80 6650","80 6670"]
["lfd. Kfz-Kosten 0%","10 6530",{"$f":"B39","v":"10 6530"}]
["lfd. Kfz-Kosten 19%","90 6530",{"$f":"B40","v":"90 6530"}]
["Mautgebühren 0%","10 6650","10 6670"]
["Mautgebühren 19%","90 6650","90 6670"]
["Messekatalog 0%","10 6650","10 6670"]
["Messekatalog 19%","90 6650","90 6670"]
["Mietwagen 0%","10 6595",{"$f":"B45","v":"10 6595"}]
["Mietwagen 19%","90 6595",{"$f":"B46","v":"90 6595"}]
["Parkgebühren 0%","10 6650","10 6670"]
["Parkgebühren 19%","90 6650","90 6670"]
["sonstige Reisek. 0%","10 6650","10 6670"]
["sonstige Reisek. 19%","90 6650","90 6670"]
["Stadtplan 0%","10 6650","10 6670"]
["Stadtplan 7%","80 6650","80 6670"]
["Taxi 0%","10 6650","10 6670"]
["Taxi 19%","90 6663","90 6673"]
["Taxi 7%","80 6663","80 6673"]
["Telefongebühren 0%","10 6805","10 6805"]
["Telefongebühren 19%","90 6805","90 6805"]
["Trinkgeld","10 6650","10 6670"]
["Übernachtung 0%","10 6660","10 6680"]
["Übernachtung 7%",{"$f":"IF(Jahr>=2010,\"80 6660\",\"\")","v":"80 6660"},{"$f":"IF(Jahr>=2010,\"80 6680\",\"\")","v":"80 6680"}]
["Übernachtung 19%",{"$f":"IF(Jahr>=2010,\"\",\"90 6660\")","v":""},{"$f":"IF(Jahr>=2010,\"\",\"90 6680\")","v":""}]
["Wagenpflege 0%","10 6530",{"$f":"B62","v":"10 6530"}]
["Wagenpflege 19%","90 6530",{"$f":"B63","v":"90 6530"}]
["Werkzeuge 0%","10 6845",{"$f":"B64","v":"10 6845"}]
["Werkzeuge 19%","90 6845",{"$f":"B65","v":"90 6845"}]
["Zuschl.Business-Package",906650,906670]
["Zuschl.Service-Pauschale",906650,906670]
["Zuschlag Frühstück",906664,"bei UN nicht möglich !"]
["Zuschlag Halbpension",906664,"bei UN nicht möglich !"]
["Zuschlag Vollpension",906664,"bei UN nicht möglich !"]

{"sheet":"__Goal_Metadata","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["_KAW999934","J"]
["_KAW999120","K0000133"]