{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Reisek.","VSt.Verpfl.","Städte","Staaten","Fahrzeug","Kontenplan","__Goal_Metadata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":4,"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":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[46,18,47,18],[4,14,5,14],[1,19,1,22],[46,19,47,19],[46,20,47,20],[46,22,47,22],[4,20,5,22],[4,18,5,18],[4,12,4,13],[5,12,5,13],[46,11,47,11],[4,17,5,17],[4,15,5,15],[4,16,5,16],[46,12,47,12],[52,3,52,6],[1,0,1,8],[54,8,54,9],[4,2,4,3],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[44,3,44,10]]}
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J2>K2,\"' 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":""},{"$f":"IF(YEAR(K2)<YEAR(Y1),\"Datum < \"&TEXT(X1,\"JJJJ\")&\" !\",IF(YEAR(K2)>YEAR(Z1),\"Datum > \"&TEXT(Z1,\"JJJJ\")&\" !\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01","2020-12-31"]
["Reisekosten-Abrechnung",null,null,null,null,null,null,null,null,{"$f":"Z11","v":"2020-01-01"},{"$f":"Z15","v":"2020-01-31"},null,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," ",{"$f":"IF(ISERROR(VLOOKUP(J10,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J10,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G10+G11>=24/24,VLOOKUP(K10,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B10+100-B11<>0,N10=\"N\"),VLOOKUP(K10,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B10+100-B11<>0,N10=\"N\"),VLOOKUP(K10,Staaten!$A$4:$I$366,9,FALSE),\" \"))","v":" "},null,null,1,null,{"$f":"IF(Q10=\"\",\"\",VLOOKUP(Q10,Fahrzeug!$A$2:$B$20,2,0))","v":""},{"$f":"IF(Q10=\"\",\" \",O10*R10)","v":" "},null,{"$f":"IF(RIGHT(W11,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K10,Staaten!$A$7:$B$336,2,0)*LEFT(W11,4),L10),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W11,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W11,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W11,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W11,Kontenplan!$A$4:$C$110,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":""},{"$f":"VLOOKUP(K10,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J12,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J12,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G12+G13>=24/24,VLOOKUP(K12,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B12+100-B13<>0,N12=\"N\"),VLOOKUP(K12,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B12+100-B13<>0,N12=\"N\"),VLOOKUP(K12,Staaten!$A$4:$I$366,9,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(RIGHT(W13,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K12,Staaten!$A$7:$B$336,2,0)*LEFT(W13,4),L12),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W13,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W13,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W13,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W13,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "},null,null,1]
[null,{"$f":"IF(A13=\"\",B12,DATE(Jahr,RIGHT(A13,2),LEFT(A13,LEN(A13)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K12,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J14,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J14,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G14+G15>=24/24,VLOOKUP(K14,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B14+100-B15<>0,N14=\"N\"),VLOOKUP(K14,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B14+100-B15<>0,N14=\"N\"),VLOOKUP(K14,Staaten!$A$4:$I$366,9,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(RIGHT(W15,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K14,Staaten!$A$7:$B$336,2,0)*LEFT(W15,4),L14),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W15,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W15,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W15,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W15,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "},null,null,2020]
[null,{"$f":"IF(A15=\"\",B14,DATE(Jahr,RIGHT(A15,2),LEFT(A15,LEN(A15)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K14,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J16,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J16,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G16+G17>=24/24,VLOOKUP(K16,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B16+100-B17<>0,N16=\"N\"),VLOOKUP(K16,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B16+100-B17<>0,N16=\"N\"),VLOOKUP(K16,Staaten!$A$4:$I$366,9,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(RIGHT(W17,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K16,Staaten!$A$7:$B$336,2,0)*LEFT(W17,4),L16),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W17,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W17,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W17,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W17,Kontenplan!$A$4:$C$110,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(Jahr,RIGHT(A17,2),LEFT(A17,LEN(A17)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K16,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J18,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J18,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G18+G19>=24/24,VLOOKUP(K18,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B18+100-B19<>0,N18=\"N\"),VLOOKUP(K18,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B18+100-B19<>0,N18=\"N\"),VLOOKUP(K18,Staaten!$A$4:$I$366,9,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(RIGHT(W19,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K18,Staaten!$A$7:$B$336,2,0)*LEFT(W19,4),L18),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W19,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W19,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W19,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W19,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "},null,null,{"$f":"Z14","v":2020}]
[null,{"$f":"IF(A19=\"\",B18,DATE(Jahr,RIGHT(A19,2),LEFT(A19,LEN(A19)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K18,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J20,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J20,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G20+G21>=24/24,VLOOKUP(K20,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B20+100-B21<>0,N20=\"N\"),VLOOKUP(K20,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B20+100-B21<>0,N20=\"N\"),VLOOKUP(K20,Staaten!$A$4:$I$366,9,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(RIGHT(W21,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K20,Staaten!$A$7:$B$336,2,0)*LEFT(W21,4),L20),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W21,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W21,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W21,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W21,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A21=\"\",B20,DATE(Jahr,RIGHT(A21,2),LEFT(A21,LEN(A21)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K20,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J22,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J22,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G22+G23>=24/24,VLOOKUP(K22,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B22+100-B23<>0,N22=\"N\"),VLOOKUP(K22,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B22+100-B23<>0,N22=\"N\"),VLOOKUP(K22,Staaten!$A$4:$I$366,9,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(RIGHT(W23,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K22,Staaten!$A$7:$B$336,2,0)*LEFT(W23,4),L22),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W23,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W23,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W23,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W23,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A23=\"\",B22,DATE(Jahr,RIGHT(A23,2),LEFT(A23,LEN(A23)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K22,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J24,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J24,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G24+G25>=24/24,VLOOKUP(K24,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B24+100-B25<>0,N24=\"N\"),VLOOKUP(K24,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B24+100-B25<>0,N24=\"N\"),VLOOKUP(K24,Staaten!$A$4:$I$366,9,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(RIGHT(W25,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K24,Staaten!$A$7:$B$336,2,0)*LEFT(W25,4),L24),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W25,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W25,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W25,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W25,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A25=\"\",B24,DATE(Jahr,RIGHT(A25,2),LEFT(A25,LEN(A25)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K24,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J26,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J26,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G26+G27>=24/24,VLOOKUP(K26,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B26+100-B27<>0,N26=\"N\"),VLOOKUP(K26,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B26+100-B27<>0,N26=\"N\"),VLOOKUP(K26,Staaten!$A$4:$I$366,9,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(RIGHT(W27,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K26,Staaten!$A$7:$B$336,2,0)*LEFT(W27,4),L26),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W27,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W27,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W27,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W27,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A27=\"\",B26,DATE(Jahr,RIGHT(A27,2),LEFT(A27,LEN(A27)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K26,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J28,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J28,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G28+G29>=24/24,VLOOKUP(K28,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B28+100-B29<>0,N28=\"N\"),VLOOKUP(K28,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B28+100-B29<>0,N28=\"N\"),VLOOKUP(K28,Staaten!$A$4:$I$366,9,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(RIGHT(W29,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K28,Staaten!$A$7:$B$336,2,0)*LEFT(W29,4),L28),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W29,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W29,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W29,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W29,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A29=\"\",B28,DATE(Jahr,RIGHT(A29,2),LEFT(A29,LEN(A29)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K28,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J30,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J30,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G30+G31>=24/24,VLOOKUP(K30,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B30+100-B31<>0,N30=\"N\"),VLOOKUP(K30,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B30+100-B31<>0,N30=\"N\"),VLOOKUP(K30,Staaten!$A$4:$I$366,9,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(RIGHT(W31,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K30,Staaten!$A$7:$B$336,2,0)*LEFT(W31,4),L30),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W31,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W31,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W31,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W31,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A31=\"\",B30,DATE(Jahr,RIGHT(A31,2),LEFT(A31,LEN(A31)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K30,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J32,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J32,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G32+G33>=24/24,VLOOKUP(K32,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B32+100-B33<>0,N32=\"N\"),VLOOKUP(K32,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B32+100-B33<>0,N32=\"N\"),VLOOKUP(K32,Staaten!$A$4:$I$366,9,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(RIGHT(W33,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K32,Staaten!$A$7:$B$336,2,0)*LEFT(W33,4),L32),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W33,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W33,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W33,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W33,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A33=\"\",B32,DATE(Jahr,RIGHT(A33,2),LEFT(A33,LEN(A33)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K32,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J34,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J34,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G34+G35>=24/24,VLOOKUP(K34,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B34+100-B35<>0,N34=\"N\"),VLOOKUP(K34,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B34+100-B35<>0,N34=\"N\"),VLOOKUP(K34,Staaten!$A$4:$I$366,9,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(RIGHT(W35,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K34,Staaten!$A$7:$B$336,2,0)*LEFT(W35,4),L34),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W35,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W35,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W35,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W35,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A35=\"\",B34,DATE(Jahr,RIGHT(A35,2),LEFT(A35,LEN(A35)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K34,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J36,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J36,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G36+G37>=24/24,VLOOKUP(K36,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B36+100-B37<>0,N36=\"N\"),VLOOKUP(K36,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B36+100-B37<>0,N36=\"N\"),VLOOKUP(K36,Staaten!$A$4:$I$366,9,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(RIGHT(W37,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K36,Staaten!$A$7:$B$336,2,0)*LEFT(W37,4),L36),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W37,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W37,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W37,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W37,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A37=\"\",B36,DATE(Jahr,RIGHT(A37,2),LEFT(A37,LEN(A37)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K36,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J38,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J38,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G38+G39>=24/24,VLOOKUP(K38,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B38+100-B39<>0,N38=\"N\"),VLOOKUP(K38,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B38+100-B39<>0,N38=\"N\"),VLOOKUP(K38,Staaten!$A$4:$I$366,9,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(RIGHT(W39,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K38,Staaten!$A$7:$B$336,2,0)*LEFT(W39,4),L38),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W39,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W39,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W39,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W39,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A39=\"\",B38,DATE(Jahr,RIGHT(A39,2),LEFT(A39,LEN(A39)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K38,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J40,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J40,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G40+G41>=24/24,VLOOKUP(K40,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B40+100-B41<>0,N40=\"N\"),VLOOKUP(K40,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B40+100-B41<>0,N40=\"N\"),VLOOKUP(K40,Staaten!$A$4:$I$366,9,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(RIGHT(W41,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K40,Staaten!$A$7:$B$336,2,0)*LEFT(W41,4),L40),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W41,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W41,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W41,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W41,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A41=\"\",B40,DATE(Jahr,RIGHT(A41,2),LEFT(A41,LEN(A41)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K40,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,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," ",{"$f":"IF(ISERROR(VLOOKUP(J42,Städte!$A$2:$B$1030,2,0)),\" \",VLOOKUP(J42,Städte!$A$2:$B$1030,2,0))","v":" "},{"$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$336,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$336,4,0),IF(G42+G43>=24/24,VLOOKUP(K42,Staaten!$A$7:$B$336,2,0),\"\")))))","v":""},{"$f":"IF(AND($A$3=\"A\",B42+100-B43<>0,N42=\"N\"),VLOOKUP(K42,Staaten!$A$7:$E$366,5,FALSE),IF(AND($A$3=\"U\",B42+100-B43<>0,N42=\"N\"),VLOOKUP(K42,Staaten!$A$4:$I$366,9,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(RIGHT(W43,17)=\"Kürzung Pauschale\",-MIN(VLOOKUP(K42,Staaten!$A$7:$B$336,2,0)*LEFT(W43,4),L42),\"\")","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(W43,Kontenplan!$A$4:$B$110,2,0)),\"\",IF($A$3=\"A\",VLOOKUP(W43,Kontenplan!$A$4:$B$110,2,0),IF(ISERROR(VLOOKUP(W43,Kontenplan!$A$4:$C$110,3,0)),\" \",IF($A$3=\"U\",VLOOKUP(W43,Kontenplan!$A$4:$C$110,3,0),\" \"))))","v":" "}]
[null,{"$f":"IF(A43=\"\",B42,DATE(Jahr,RIGHT(A43,2),LEFT(A43,LEN(A43)-2)))","v":"2019-12-31"},null,null,"00:00:00","00:00:00",0,null,null,"",{"$f":"VLOOKUP(K42,Staaten!$A$7:$G$347,7,0)","v":" "},{"$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$366,6,FALSE),\" \")","v":" "},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,null,"Anzahl der Übernachtungen in Moskau in Gästewohnungen der Deutschen Botschaft",null,null,null,null,null,null,null,null,{"$f":"IF(Jahr>=2010,C46*135,0)","v":0}]
[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:M46)","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(L47:M47)+SUM(S47:U47)","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":"K2","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":[[1,8,1,10],[4,1,4,2],[1,0,1,5],[44,9,45,9],[44,10,45,10],[44,8,45,8],[5,7,5,8],[44,7,45,7],[44,6,45,6],[4,6,4,10],[50,2,50,3],[2,1,2,3],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[44,1,44,5]]}
[]
["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.!K2","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,"€","€","% VSt.","€","€"]
[]
[{"$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.!H10)","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.!H11)","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.!H12)","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.!H13)","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.!H14)","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.!H15)","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.!H16)","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.!H17)","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.!H18)","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.!H19)","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.!H20)","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":""},""]
[{"$f":"IF(Reisek.!A21<=0,\" \",Reisek.!A21)","v":" "},{"$f":"IF(OR(Reisek.!E21=0,Reisek.!G21=0),\"\",Reisek.!E21)","v":""},{"$f":"IF(Reisek.!F21=0,\" \",Reisek.!F21)","v":" "},{"$f":"IF(Reisek.!G21=0,\" \",Reisek.!H21)","v":" "},null,{"$f":"IF(Reisek.!I21<=0,\" \",Reisek.!I21)","v":" "},{"$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.!H22)","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":""},""]
[{"$f":"IF(Reisek.!A23<=0,\" \",Reisek.!A23)","v":" "},{"$f":"IF(OR(Reisek.!E23=0,Reisek.!G23=0),\"\",Reisek.!E23)","v":""},{"$f":"IF(Reisek.!F23=0,\" \",Reisek.!F23)","v":" "},{"$f":"IF(Reisek.!G23=0,\" \",Reisek.!H23)","v":" "},null,{"$f":"IF(Reisek.!I23<=0,\" \",Reisek.!I23)","v":" "},{"$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.!H24)","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":""},""]
[{"$f":"IF(Reisek.!A25<=0,\" \",Reisek.!A25)","v":" "},{"$f":"IF(OR(Reisek.!E25=0,Reisek.!G25=0),\"\",Reisek.!E25)","v":""},{"$f":"IF(Reisek.!F25=0,\" \",Reisek.!F25)","v":" "},{"$f":"IF(Reisek.!G25=0,\" \",Reisek.!H25)","v":" "},null,{"$f":"IF(Reisek.!I25<=0,\" \",Reisek.!I25)","v":" "},{"$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.!H26)","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":""},""]
[{"$f":"IF(Reisek.!A27<=0,\" \",Reisek.!A27)","v":" "},{"$f":"IF(OR(Reisek.!E27=0,Reisek.!G27=0),\"\",Reisek.!E27)","v":""},{"$f":"IF(Reisek.!F27=0,\" \",Reisek.!F27)","v":" "},{"$f":"IF(Reisek.!G27=0,\" \",Reisek.!H27)","v":" "},null,{"$f":"IF(Reisek.!I27<=0,\" \",Reisek.!I27)","v":" "},{"$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.!H28)","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":""},""]
[{"$f":"IF(Reisek.!A29<=0,\" \",Reisek.!A29)","v":" "},{"$f":"IF(OR(Reisek.!E29=0,Reisek.!G29=0),\"\",Reisek.!E29)","v":""},{"$f":"IF(Reisek.!F29=0,\" \",Reisek.!F29)","v":" "},{"$f":"IF(Reisek.!G29=0,\" \",Reisek.!H29)","v":" "},null,{"$f":"IF(Reisek.!I29<=0,\" \",Reisek.!I29)","v":" "},{"$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.!H30)","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":""},""]
[{"$f":"IF(Reisek.!A31<=0,\" \",Reisek.!A31)","v":" "},{"$f":"IF(OR(Reisek.!E31=0,Reisek.!G31=0),\"\",Reisek.!E31)","v":""},{"$f":"IF(Reisek.!F31=0,\" \",Reisek.!F31)","v":" "},{"$f":"IF(Reisek.!G31=0,\" \",Reisek.!H31)","v":" "},null,{"$f":"IF(Reisek.!I31<=0,\" \",Reisek.!I31)","v":" "},{"$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.!H32)","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":""},""]
[{"$f":"IF(Reisek.!A33<=0,\" \",Reisek.!A33)","v":" "},{"$f":"IF(OR(Reisek.!E33=0,Reisek.!G33=0),\"\",Reisek.!E33)","v":""},{"$f":"IF(Reisek.!F33=0,\" \",Reisek.!F33)","v":" "},{"$f":"IF(Reisek.!G33=0,\" \",Reisek.!H33)","v":" "},null,{"$f":"IF(Reisek.!I33<=0,\" \",Reisek.!I33)","v":" "},{"$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.!H34)","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.!H35)","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.!H36)","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.!H37)","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.!H38)","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.!H39)","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.!H40)","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.!H41)","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.!H42)","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.!H43)","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,{"$f":"IF(Reisek.!H44=0,\" \",Reisek.!H44)","v":" "},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(Reisek.!C45<=0,\" \",Reisek.!C47)","v":" "},null,null,null,null,{"$f":"SUM(G43:G44)","v":0},null,null,"Kontierung:",{"$f":"\"1400 / \"&RIGHT(Reisek.!L50,4)","v":"1400 / 6664"}]
[]
[]
[]
[]
[]
[{"$f":"Reisek.!A53","v":"..................... "},null,{"$f":"Reisek.!D53","v":"2020-01-31"}]
[]
[null,null,null,null,null,"(Unterschrift)"]

{"sheet":"Städte","index":2,"n_rows":228,"n_cols":2,"rows_kept":228,"cut":false,"hidden":false,"merged":[]}
["Stadt","Staat"]
[" "," "]
["Accra","Ghana"]
["Abuja",{"$f":"A4","v":"Abuja"}]
["Addis Abeba","Äthiopien"]
["Aden","Jemen"]
["Algier","Algerien"]
["Alma-Ata","Kasachstan"]
["Amman","Jordanien"]
["Amsterdam","Niederlande"]
["Andorra la Vella","Andorra"]
["Ankara","TR - Türkei"]
["Antananarivo","Madagaskar"]
["Apia","Samoa"]
["Aschchabad","Turkmenistan"]
["Asmara","Eritrea"]
["Asunción","Paraguay"]
["Athen",{"$f":"A18","v":"Athen"}]
["Atlanta",{"$f":"A19","v":"Atlanta"}]
["Bagdad","Irak"]
["Baku","Aserbaidschan"]
["Bamako","Mali"]
["Bangalore",{"$f":"A23","v":"Bangalore"}]
["Bangok","Thailand"]
["Bangui","Zentralafrikan.Republik"]
["Banjul","Gambia"]
["Barcelona","Barcelona"]
["Beirut","Libanon"]
["Belgrad","Jugoslawien"]
["Berlin"," "]
["Bern","Bern"]
["Bischkek","Kirgisistan"]
["Bissau","Guinea-Bissau"]
["Blantyre","Blantyre"]
["Bogotá","Kolumbien"]
["Bordeaux","F - Frankreich"]
["Boston",{"$f":"A37","v":"Boston"}]
["Brasilia","Brasilia"]
["Bratislawa","Slowakei"]
["Brazzaville","Kongo"]
["Breslau","Breslau"]
["Bridgetown","Barbados"]
["Brüssel","Belgien"]
["Budapest","Ungarn"]
["Buenos Aires","Argentinien"]
["Bujumbura","Burundi"]
["Bukarest",{"$f":"A47","v":"Bukarest"}]
["Canberra","Canberra"]
["Caracas","Venezuela"]
["Chengdu","Chengdu"]
["Chennai","Chennai"]
["Chicago","Chicago"]
["Chisinau","Moldau, Republik"]
["Colombo","Sri Lanka"]
["Conakry","Guinea"]
["Daha","Katar"]
["Dakar","Senegal"]
["Damaskus","Syrien, Arab.Repubik"]
["Danzig","Danzig"]
["Dhaka (Dacca)","Bangladesch"]
["Djidda","Djidda"]
["Dodoma","Tansania, Verein.Rep."]
["Dschibuti-Stadt","Dschibuti"]
["Dubai","Dubai"]
["Dublin","Irland"]
["Duschanbe","Tadschikistan"]
["Edinburgh",{"$f":"A67","v":"Edinburgh"}]
["Freetown","Sierra Leone"]
["Gaborone","Botsuana"]
["Genf","Genf"]
["Georgetown","Guyana"]
["Guatemala-Stadt","Guatemala"]
["Freetown","Simbabwe"]
["Haute-Seine","Haute-Seine"]
["Havanna","Kuba"]
["Helsinki","Finnland"]
["Ho-Chi-Min-Stadt","Vietnam"]
["Hongkong",{"$f":"A78","v":"Hongkong"}]
["Houston",{"$f":"A79","v":"Houston"}]
["Islamabad",{"$f":"A80","v":"Islamabad"}]
["Istanbul","Istanbul"]
["Izmir",{"$f":"A82","v":"Izmir"}]
["Jakarta","Indonesien"]
["Jaunde","Jaunde"]
["Jekatarinenburg","Jekatarinenburg"]
["Jerevan (Eriwan)","Armenien"]
["Jerusalem","Israel"]
["Johannisburg","Johannisburg"]
["Kabul","Afghanistan"]
["Kairo","Ägypten"]
["Kalkutta",{"$f":"A91","v":"Kalkutta"}]
["Kampala","Uganda"]
["Kanton","Kanton"]
["Kapstadt","Kapstadt"]
["Katmandu","Nepal"]
["Khartum","Sudan"]
["Kiew","Ukraine"]
["Kigali","Ruanda"]
["Kingston","Jamaika"]
["Kinshasa","Kongo, Demokr. Rep."]
["Kopenhagen",{"$f":"A101","v":"Kopenhagen"}]
["Krakau",{"$f":"A102","v":"Krakau"}]
["Kuala Lumpur","Malaysia"]
["Kuwait-Stadt","Kuwait"]
["Lagos",{"$f":"A105","v":"Lagos"}]
["La Paz","Bolivien"]
["Libreville","Gabun"]
["Lilongwe","Malawi"]
["Lima","Peru"]
["Lissabon",{"$f":"A110","v":"Lissabon"}]
["Ljublljana","Slowenien"]
["Lome","Togo"]
["London",{"$f":"A113","v":"London"}]
["Los Angeles",{"$f":"A114","v":"Los Angeles"}]
["Luanda","Angola"]
["Lusaka","Sambia"]
["Luxemburg","Luxemburg"]
["Lyon","Lyon"]
["Madrid",{"$f":"A119","v":"Madrid"}]
["Mailand",{"$f":"A120","v":"Mailand"}]
["Malabo","Äquatorialguinea"]
["Malé","Malediven"]
["Managua","Nicaragua"]
["Manama","Bahrain"]
["Manchester","GB - Verein.Königreich"]
["Manila","Philippinen"]
["Maputo","Mosambik"]
["Marseille","Marseille"]
["Maseru","Lesotho"]
["Maskat","Oman"]
["Mbabane","Swasiland"]
["Melbourne","Melbourne"]
["Mexiko-Stadt","Mexiko"]
["Miami","Miami"]
["Minsk","Weißrußland"]
["Mogadischu","Somalia"]
["Monaco-Ville","Monaco"]
["Monrovia","Liberia"]
["Montevideo","Uruguay"]
["Moroni","Komoren"]
["Moskau","Moskau"]
["Mumbai","Mumbai"]
["Nairobi","Kenia"]
["Nassau","Bahamas"]
["N'Djamena","Tschad"]
["Neu Delhi","Neu Delhi"]
["New York City","New York City"]
["Niamey","Niger"]
["Nicosia","Zypern"]
["Nouakchott","Mauretanien"]
["Nukualofa","Tonga"]
["Oslo","Norwegen"]
["Ottawa","Ottawa"]
["Ouagadougou","Burkina Faso"]
["Palma de Mallorca",{"$f":"A155","v":"Palma de Mallorca"}]
["Panama-Stadt","Panama"]
["Paris","Paris"]
["Peking","Peking"]
["Phnom Penh","Kambodscha"]
["Pjöngjang","Korea, Demokr. VR"]
["Port Louis","Mauritius"]
["Port Moresby","Papua-Neuguinea"]
["Port of Spain","Trinidad und Tobago"]
["Port-au-Prince","Haiti"]
["Porto Novo","Benin"]
["Prag","Tschechische Rep."]
["Praia","Kap Verde"]
["Pretoria","Südafrika"]
["Pristina","Kosovo"]
["Quito","Ecuador"]
["Rabat","Marokko"]
["Reykjavík","Island"]
["Riad","Riad"]
["Riga","Lettland"]
["Rio de Janeiro","Rio de Janeiro"]
["Rom","Rom"]
["San Francisco","San Francisco"]
["San José","Costa Rica"]
["San Marino","San Marino"]
["San Salvador","El Salvador"]
["Sana","Jemen"]
["Santiago de Chile","Chile"]
["Santo Domingo","Dominikanische Rep."]
["Sao Paulo","Sao Paulo"]
["Sao Tomé","Sao Tomé u. Principe"]
["Sarajevo","Bosnien-Herzegowina"]
["Seattle","USA - Verein. Staaten"]
["Seine-Saint Denis","Seine-Saint Denis"]
["Seoul","Korea, Republik"]
["Shanghai","Shanghai"]
["Singapur","Singapur"]
["Skopje","Mazedonien"]
["Sofia","Bulgarien"]
["St. Petersburg","St. Petersburg"]
["Stockholm","Schweden"]
["Straßburg","Straßburg"]
["Suva","Fidschi"]
["Sydney","Sydney"]
["Taipeh","(China) Taiwan"]
["Tallinn (Reval)","Estland"]
["Taschkent","Usbekistan"]
["Tegucigalpa","Honduras"]
["Teheran","Iran, Islamische Rep."]
["Tel Aviv",{"$f":"A204","v":"Tel Aviv"}]
["Tiflis","Georgien"]
["Tirana","Albanien"]
["Tokio",{"$f":"A207","v":"Tokio"}]
["Toronto","Toronto"]
["Tripolis","Libysch-Arab.Dsch."]
["Tunis","Tunesien"]
["Ulan-Bator","Mongolei"]
["Vaduz","Liechtenstein"]
["Val-de-Marne",{"$f":"A213","v":"Val-de-Marne"}]
["Valletta","Malta"]
["Vancouver","Vancouver"]
["Vatikanstadt","Vatikanstadt"]
["Vientiane","Laotische Demokr.VR"]
["Warschau",{"$f":"A218","v":"Warschau"}]
["Washington D.C.",{"$f":"A219","v":"Washington D.C."}]
["Wellington","Neuseeland"]
["Wien",{"$f":"A221","v":"Wien"}]
["Wilna (Vilnius)","Litauen"]
["Windhoek","Namibia"]
["Windhuk","Namibia"]
["Yamoussoukro","Côte d'Ivoire"]
["Yangon (Rangun)","Myanmar  (Burma)"]
["Yaoundé","Kamerun"]
["Zagreb","Kroatien"]

{"sheet":"Staaten","index":3,"n_rows":267,"n_cols":9,"rows_kept":267,"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"," "]
["in das Ausland",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",{"$f":"VLOOKUP(I10,Staaten!$A$13:$D$336,2,0)","v":47},{"$f":"ROUNDUP(B10/3*2,0)","v":32},{"$f":"C10","v":32},{"$f":"VLOOKUP(I10,Staaten!$A$13:$E$336,5,0)","v":130},-9.4,{"$f":"\"(wie \"&I10&\")\"","v":"(wie Luxemburg)"},null,"Luxemburg"]
["Schiffsreise",{"$f":"VLOOKUP(I11,Staaten!$A$13:$D$336,2,0)","v":47},{"$f":"ROUNDUP(B11/3*2,0)","v":32},32,{"$f":"VLOOKUP(I11,Staaten!$A$13:$E$336,5,0)","v":130},-9.4,{"$f":"\"(wie \"&I11&\")\"","v":"(wie Luxemburg)"},null,"Luxemburg"]
["Flugreise über 2 Tage",{"$f":"VLOOKUP(I12,Staaten!$A$13:$D$336,2,0)","v":40},{"$f":"ROUNDUP(B12/3*2,0)","v":27},27,{"$f":"VLOOKUP(I12,Staaten!$A$13:$E$336,5,0)","v":108},-8,"(wie A - Österreich)",null,"A - Österreich"]
[null,null,null,null,null,null," "]
["Afghanistan",30,{"$f":"ROUND(B14/3*2,0)","v":20},{"$f":"C14","v":20},95,{"$f":"B14*-0.2","v":-6}," "]
["Ägypten",{"$f":"IF(Jahr>=2018,41,40)","v":41},{"$f":"ROUNDUP(B15/3*2,0)","v":28},{"$f":"C15","v":28},{"$f":"IF(Jahr>=2018,125,113)","v":125},{"$f":"B15*-0.2","v":-8.2000000000000011}," "]
["Äthiopien",{"$f":"IF(Jahr>=2020,39,IF(Jahr<2015,30,27))","v":39},{"$f":"ROUND(B16/3*2,0)","v":26},26,{"$f":"IF(Jahr>=2020,130,IF(Jahr<2015,175,86))","v":130},{"$f":"B16*-0.2","v":-7.8000000000000007}," "]
["Äquatorialguinea",{"$f":"IF(Jahr<2016,50,36)","v":36},{"$f":"ROUND(B17/3*2,0)","v":24},24,{"$f":"IF(Jahr<2016,226,166)","v":166},{"$f":"B17*-0.2","v":-7.2}," "]
["Albanien",{"$f":"IF(Jahr<2016,23,29)","v":29},{"$f":"ROUNDUP(B18/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2017,113,IF(Jahr<2016,110,90))","v":113},-5.8000000000000007," "]
["Algerien",{"$f":"IF(Jahr>=2017,51,39)","v":51},{"$f":"ROUND(B19/3*2,0)","v":34},34,{"$f":"IF(Jahr>=2017,173,190)","v":173},-10.200000000000001," "]
["Andorra",{"$f":"IF(Jahr<2016,32,34)","v":34},{"$f":"ROUND(B20/3*2,0)","v":23},23,{"$f":"IF(Jahr<2016,82,45)","v":45},-6.8000000000000007," "]
["Angola",{"$f":"IF(Jahr>=2020,52,77)","v":52},{"$f":"ROUNDUP(B21/3*2,0)","v":35},35,{"$f":"IF(Jahr>=2020,299,265)","v":299},-10.4," "]
["Antigua und Barbuda",{"$f":"IF(Jahr>=2019,45,53)","v":45},{"$f":"ROUNDUP(B22/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2019,177,117)","v":177},-9," "]
["Argentinien",{"$f":"IF(Jahr>=2020,35,IF(Jahr<2015,36,34))","v":35},{"$f":"ROUNDUP(B23/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2020,113,IF(Jahr<2015,125,144))","v":113},-7," "]
["Armenien",{"$f":"IF(Jahr>=2020,24,IF(Jahr<2015,24,23))","v":24},{"$f":"ROUNDUP(B24/3*2,0)","v":16},16,{"$f":"IF(Jahr>=2020,59,IF(Jahr<2015,90,63))","v":59},-4.8000000000000007," "]
["Aserbaidschan",{"$f":"IF(Jahr>=2017,30,40)","v":30},{"$f":"ROUND(B25/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2017,72,120)","v":72},-6," "]
["AUS - Australien",{"$f":"IF(Jahr>=2018,51,56)","v":51},34,34,{"$f":"IF(Jahr>=2018,158,133)","v":158},-10.200000000000001," "]
["Canberra",{"$f":"IF(Jahr>=2018,51,58)","v":51},{"$f":"ROUND(B27/3*2,0)","v":34},34,158,{"$f":"B27*-0.2","v":-10.200000000000001},"Australien"]
["Melbourne",{"$f":"IF(Jahr>=2018,51,56)","v":51},34,34,{"$f":"IF(Jahr>=2018,158,133)","v":158},-10.200000000000001,"Australien"]
["Sydney",{"$f":"IF(Jahr>=2018,68,59)","v":68},{"$f":"ROUND(B29/3*2,0)","v":45},45,{"$f":"IF(Jahr>=2018,184,186)","v":184},-13.600000000000001,"Australien"]
["Bahrain",{"$f":"IF(Jahr<2016,36,45)","v":45},30,30,{"$f":"IF(Jahr<2016,70,180)","v":180},-9," "]
["Bangladesch",{"$f":"IF(Jahr>=2020,50,30)","v":50},33,33,{"$f":"IF(Jahr>=2020,165,111)","v":165},-10," "]
["Barbados",{"$f":"IF(Jahr>=2019,52,58)","v":52},35,35,{"$f":"IF(Jahr>=2019,165,179)","v":165},-10.4," "]
["Belgien",{"$f":"IF(Jahr>=2018,42,41)","v":42},{"$f":"ROUNDUP(B33/3*2,0)","v":28},28,135,-8.4," "]
["Benin",{"$f":"IF(Jahr>=2020,52,40)","v":52},{"$f":"ROUNDUP(B34/3*2,0)","v":35},35,{"$f":"IF(Jahr>=2020,115,101)","v":115},-10.4," "]
["Bolivien",{"$f":"IF(Jahr>=2017,30,24)","v":30},20,20,{"$f":"IF(Jahr>=2017,93,70)","v":93},-6," "]
["Bosnien-Herzegowina",{"$f":"IF(Jahr>=2020,23,18)","v":23},{"$f":"ROUNDUP(B36/3*2,0)","v":16},16,{"$f":"IF(Jahr>=2020,75,73)","v":75},-4.6000000000000005," "]
["Botsuana",{"$f":"IF(Jahr<2016,33,40)","v":40},27,27,{"$f":"IF(Jahr<2016,105,102)","v":102},-8," "]
["BR - Brasilien",{"$f":"IF(Jahr>=2018,51,54)","v":51},34,34,{"$f":"IF(Jahr>=2018,84,110)","v":84},{"$f":"B38*-0.2","v":-10.200000000000001}," "]
["Brasilia",{"$f":"IF(Jahr>=2018,57,53)","v":57},{"$f":"IF(Jahr<2012,ROUND(B39/3*2,0),ROUNDUP(B39/3*2,0))","v":38},38,{"$f":"IF(Jahr>=2018,127,160)","v":127},{"$f":"B39*-0.2","v":-11.4},"Brasilien"]
["Rio de Janeiro",{"$f":"IF(Jahr>=2018,57,47)","v":57},{"$f":"ROUNDUP(B40/3*2,0)","v":38},38,145,-11.4,"Brasilien"]
["Sao Paulo",53,{"$f":"IF(Jahr<2012,ROUND(B41/3*2,0),ROUNDUP(B41/3*2,0))","v":36},36,{"$f":"IF(Jahr>=2018,132,120)","v":132},-10.600000000000001,"Brasilien"]
["Brunei",{"$f":"IF(Jahr>=2020,52,48)","v":52},35,35,106,-10.4," "]
["Bulgarien",22,15,15,{"$f":"IF(Jahr<2015,72,90)","v":90},-4.4000000000000004," "]
["Burkina Faso",{"$f":"IF(Jahr>=2020,38,44)","v":38},25,25,{"$f":"IF(Jahr>=2020,174,84)","v":174},-7.6000000000000005," "]
["Burma",39,26,26,75,-7.8000000000000007,"Myanmar  (Burma)"]
["Burundi",47,{"$f":"ROUNDUP(B46/3*2,0)","v":32},32,98,-9.4," "]
["Chile",{"$f":"IF(Jahr>=2018,44,40)","v":44},29,29,{"$f":"IF(Jahr>=2018,187,130)","v":187},-8.8000000000000007," "]
["RC - China",{"$f":"IF(Jahr>=2017,50,IF(Jahr<2015,33,40))","v":50},33,33,{"$f":"IF(Jahr>=2017,78,IF(Jahr<2015,80,113))","v":78},{"$f":"B48*-0.2","v":-10}," "]
["Chengdu",{"$f":"IF(Jahr<2016,32,35)","v":35},{"$f":"IF(Jahr<2016,ROUND(B49/3*2,0),ROUNDUP(B49/3*2,0))","v":24},24,{"$f":"IF(Jahr<2016,85,105)","v":105},{"$f":"B49*-0.2","v":-7},"China"]
["Hongkong",{"$f":"IF(Jahr<2016,62,74)","v":74},49,49,{"$f":"IF(Jahr<2016,170,145)","v":145},{"$f":"B50*-0.2","v":-14.8},"China"]
["Kanton",{"$f":"IF(Jahr>=2017,40,IF(Jahr<2015,33,40))","v":40},{"$f":"ROUND(B51/3*2,0)","v":27},{"$f":"C51","v":27},{"$f":"IF(Jahr>=2017,113,IF(Jahr<2015,80,113))","v":113},{"$f":"B51*-0.2","v":-8},"China"]
["Peking",{"$f":"IF(Jahr<2016,39,46)","v":46},31,31,{"$f":"IF(Jahr<2016,115,142)","v":142},-9.2000000000000011,"China"]
["Shanghai",{"$f":"IF(Jahr<2016,42,50)","v":50},33,33,{"$f":"IF(Jahr<2016,140,128)","v":128},-10,"China"]
["(China) Taiwan",{"$f":"IF(Jahr>=2017,51,39)","v":51},34,34,{"$f":"IF(Jahr>=2017,126,110)","v":126},-10.200000000000001," "]
["Costa Rica",{"$f":"IF(Jahr>=2019,47,46)","v":47},{"$f":"ROUNDUP(B55/3*2,0)","v":32},32,{"$f":"IF(Jahr>=2017,93,69)","v":93},-9.4," "]
["Côte d'Ivoire",{"$f":"IF(Jahr<2015,54,51)","v":51},34,34,{"$f":"IF(Jahr<2015,145,146)","v":146},-10.200000000000001," "]
["DK - Dänemark",{"$f":"IF(Jahr>=2018,58,60)","v":58},39,39,{"$f":"IF(Jahr>=2018,143,150)","v":143},{"$f":"B57*-0.2","v":-11.600000000000001}," "]
["Kopenhagen",{"$f":"IF(Jahr>=2018,58,60)","v":58},39,39,{"$f":"IF(Jahr>=2018,143,150)","v":143},-11.600000000000001,"Dänemark"]
["Dominica",{"$f":"IF(Jahr>=2019,45,40)","v":45},30,30,{"$f":"IF(Jahr>=2019,177,94)","v":177},-9," "]
["Dominikanische Rep.",{"$f":"IF(Jahr>=2018,45,40)","v":45},30,30,{"$f":"IF(Jahr>=2018,147,71)","v":147},-9," "]
["Dschibuti",{"$f":"IF(Jahr>=2018,65,48)","v":65},{"$f":"ROUNDUP(B61/3*2,0)","v":44},44,{"$f":"IF(Jahr>=2018,305,160)","v":305},-13," "]
["Ecuador",{"$f":"IF(Jahr>=2017,44,39)","v":44},29,29,{"$f":"IF(Jahr>=2017,97,55)","v":97},-8.8000000000000007," "]
["El Salvador",{"$f":"IF(Jahr<2016,46,44)","v":44},29,29,{"$f":"IF(Jahr<2016,75,119)","v":119},-8.8000000000000007," "]
["Eritrea",{"$f":"IF(Jahr>=2019,50,46)","v":50},33,33,{"$f":"IF(Jahr>=2019,91,81)","v":91},-10," "]
["Estland",{"$f":"IF(Jahr>=2020,29,27)","v":29},{"$f":"ROUNDUP(B65/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2020,85,71)","v":85},-5.8000000000000007," "]
["Fidschi",{"$f":"IF(Jahr>=2017,34,32)","v":34},23,23,{"$f":"IF(Jahr>=2017,69,57)","v":69},-6.8000000000000007," "]
["Finnland",{"$f":"IF(Jahr>=2018,50,39)","v":50},33,33,136,-10," "]
["F - Frankreich",44,29,29,{"$f":"IF(Jahr>=2018,115,81)","v":115},{"$f":"B68*-0.2","v":-8.8000000000000007}," "]
["Paris",58,39,39,135,-11.600000000000001,"Frankreich"]
["Haute-Seine",58,{"$f":"ROUND(B70/3*2,0)","v":39},39,135,-11.600000000000001,"Frankreich"]
["Seine-Saint-Denis",58,39,39,135,-11.600000000000001,"Frankreich"]
["Val-de-Marne",58,39,39,135,-11.600000000000001,"Frankreich"]
["Lyon",{"$f":"IF(Jahr>=2018,44,53)","v":44},{"$f":"ROUNDUP(B73/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2018,115,83)","v":115},{"$f":"B73*-0.2","v":-8.8000000000000007},"Frankreich"]
["Marseille",{"$f":"IF(Jahr>=2018,46,51)","v":46},{"$f":"ROUND(B74/3*2,0)","v":31},31,{"$f":"IF(Jahr>=2018,101,86)","v":101},{"$f":"B74*-0.2","v":-9.2000000000000011},"Frankreich"]
["Straßburg",{"$f":"IF(Jahr>=2018,51,48)","v":51},34,34,{"$f":"IF(Jahr>=2018,96,89)","v":96},-10.200000000000001,"Frankreich"]
["Gabun",{"$f":"IF(Jahr>=2020,52,62)","v":52},35,35,{"$f":"IF(Jahr>=2020,183,278)","v":183},-10.4," "]
["Gambia",{"$f":"IF(Jahr<2016,18,30)","v":30},20,20,{"$f":"IF(Jahr<2016,70,125)","v":125},-6," "]
["Georgien",{"$f":"IF(Jahr>=2018,35,30)","v":35},{"$f":"ROUNDUP(B78/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2018,88,80)","v":88},-7," "]
["Ghana",46,31,31,{"$f":"IF(Jahr>=2019,148,174)","v":148},-9.2000000000000011," "]
["Grenada",{"$f":"IF(Jahr>=2019,45,51)","v":45},{"$f":"ROUND(B80/3*2,0)","v":30},{"$f":"C80","v":30},{"$f":"IF(Jahr>=2019,177,121)","v":177},{"$f":"B80*-0.2","v":-9}," "]
["GR - Griechenland",{"$f":"IF(Jahr>=2017,36,42)","v":36},24,24,{"$f":"IF(Jahr>=2019,135,89)","v":135},-7.2," "]
["Athen",{"$f":"IF(Jahr>=2017,46,57)","v":46},31,31,{"$f":"IF(Jahr>=2017,132,125)","v":132},-9.2000000000000011,"Griechenland"]
["Guatemala",{"$f":"IF(Jahr>=2019,34,28)","v":34},23,23,{"$f":"IF(Jahr>=2019,90,96)","v":90},-6.8000000000000007," "]
["Guinea",{"$f":"IF(Jahr>=2018,46,38)","v":46},31,31,{"$f":"IF(Jahr>=2018,118,110)","v":118},-9.2000000000000011," "]
["Guinea-Bissau",{"$f":"IF(Jahr<2016,38,24)","v":24},16,16,{"$f":"IF(Jahr<2016,110,86)","v":86},-4.8000000000000007," "]
["Guyana",{"$f":"IF(Jahr>=2019,45,41)","v":45},{"$f":"ROUNDUP(B86/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2019,177,81)","v":177},-9," "]
["Haiti",{"$f":"IF(Jahr>=2018,58,50)","v":58},39,39,{"$f":"IF(Jahr>=2018,130,111)","v":130},-11.600000000000001," "]
["Honduras",{"$f":"IF(Jahr>=2017,48,IF(Jahr<2015,35,44))","v":48},{"$f":"IF(Jahr<2015,ROUNDUP(B88/3*2,0),ROUND(B88/3*2,0))","v":32},32,{"$f":"IF(Jahr>=2017,101,IF(Jahr<2015,115,104))","v":101},-9.6000000000000014," "]
["IND - Indien",{"$f":"IF(Jahr>=2019,32,34)","v":32},21,21,{"$f":"IF(Jahr>=2019,85,145)","v":85},{"$f":"B89*-0.2","v":-6.4}," "]
["Bangalore",{"$f":"IF(Jahr>=2020,42,IF(Jahr>=2019,32,34))","v":42},28,28,{"$f":"IF(Jahr>=2020,155,IF(Jahr>=2019,85,145))","v":155},{"$f":"B90*-0.2","v":-8.4},"Indien"]
["Chennai",{"$f":"IF(Jahr>=2019,32,34)","v":32},21,21,{"$f":"IF(Jahr>=2019,85,87)","v":85},{"$f":"B91*-0.2","v":-6.4},"Indien"]
["Kalkutta",{"$f":"IF(Jahr>=2019,35,41)","v":35},{"$f":"IF(Jahr<2016,ROUND(B92/3*2,0),ROUNDUP(B92/3*2,0))","v":24},24,{"$f":"IF(Jahr>=2019,145,117)","v":145},-7,"Indien"]
["Mumbai",{"$f":"IF(Jahr>=2019,50,32)","v":50},{"$f":"IF(Jahr<2016,ROUNDUP(B93/3*2,0),ROUND(B93/3*2,0))","v":33},33,{"$f":"IF(Jahr>=2019,146,125)","v":146},-10,"Indien"]
["Neu Delhi",{"$f":"IF(Jahr>=2019,38,50)","v":38},25,25,{"$f":"IF(Jahr>=2019,185,144)","v":185},-7.6000000000000005,"Indien"]
["Indonesien",{"$f":"IF(Jahr>=2020,36,38)","v":36},{"$f":"ROUND(B95/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2020,134,130)","v":134},-7.2," "]
["Iran",{"$f":"IF(Jahr>=2018,33,28)","v":33},{"$f":"ROUND(B96/3*2,0)","v":22},22,{"$f":"IF(Jahr>=2018,196,84)","v":196},{"$f":"B96*-0.2","v":-6.6000000000000005}," "]
["Irland",{"$f":"IF(Jahr<2016,42,44)","v":44},29,29,{"$f":"IF(Jahr<2016,90,92)","v":92},-8.8000000000000007," "]
["Island",{"$f":"IF(Jahr<2015,53,47)","v":47},{"$f":"ROUNDUP(B98/3*2,0)","v":32},32,{"$f":"IF(Jahr<2015,105,108)","v":108},-9.4," "]
["IL - Israel",{"$f":"IF(Jahr>=2020,66,56)","v":66},{"$f":"IF(Jahr<2016,ROUNDUP(B99/3*2,0),ROUND(B99/3*2,0))","v":44},44,{"$f":"IF(Jahr>=2020,190,191)","v":190},-13.200000000000001," "]
["Tel Aviv",{"$f":"IF(Jahr>=2020,66,56)","v":66},{"$f":"IF(Jahr<2016,ROUNDUP(B100/3*2,0),ROUND(B100/3*2,0))","v":44},44,{"$f":"IF(Jahr>=2020,190,191)","v":190},-13.200000000000001,"Israel"]
["I - Italien",{"$f":"IF(Jahr>=2019,40,34)","v":40},27,27,{"$f":"IF(Jahr>=2019,135,126)","v":135},{"$f":"B101*-0.2","v":-8}," "]
["Mailand",{"$f":"IF(Jahr>=2019,45,39)","v":45},30,30,{"$f":"IF(Jahr>=2019,158,156)","v":158},-9,"Italien"]
["Rom",{"$f":"IF(Jahr>=2019,40,52)","v":40},27,27,{"$f":"IF(Jahr>=2019,135,160)","v":135},-8,"Italien"]
["Jamaika",{"$f":"IF(Jahr>=2019,57,54)","v":57},38,38,{"$f":"IF(Jahr>=2019,138,135)","v":138},-11.4," "]
["J - Japan",{"$f":"IF(Jahr>=2020,52,51)","v":52},35,35,{"$f":"IF(Jahr>=2020,190,156)","v":190},{"$f":"B105*-0.2","v":-10.4}," "]
["Tokio",{"$f":"IF(Jahr>=2018,66,53)","v":66},{"$f":"ROUNDUP(B106/3*2,0)","v":44},44,{"$f":"IF(Jahr>=2018,233,153)","v":233},-13.200000000000001,"Japan"]
["Jemen",24,16,16,95,-4.8000000000000007," "]
["Jordanien",{"$f":"IF(Jahr>=2017,46,36)","v":46},31,31,{"$f":"IF(Jahr>=2017,126,85)","v":126},-9.2000000000000011," "]
["Kambodscha",{"$f":"IF(Jahr>=2019,38,39)","v":38},25,25,{"$f":"IF(Jahr>=2017,94,85)","v":94},-7.6000000000000005," "]
["CAM - Kamerun",{"$f":"IF(Jahr>=2017,50,40)","v":50},{"$f":"ROUND(B110/3*2,0)","v":33},33,{"$f":"IF(Jahr>=2017,180,130)","v":180},-10," "]
["Jaunde",{"$f":"IF(Jahr>=2017,50,40)","v":50},{"$f":"ROUNDUP(B111/3*2,0)","v":34},34,{"$f":"IF(Jahr>=2017,180,130)","v":180},-10,"Kamerun"]
["CDN - Kanada",{"$f":"IF(Jahr>=2018,47,44)","v":47},31,31,{"$f":"IF(Jahr>=2018,134,111)","v":134},-9.4," "]
["Ottawa",{"$f":"IF(Jahr>=2018,47,35)","v":47},{"$f":"IF(Jahr<2016,ROUND(B113/3*2,0),ROUNDUP(B113/3*2,0))","v":32},32,{"$f":"IF(Jahr>=2018,142,110)","v":142},-9.4,"Kanada"]
["Toronto",{"$f":"IF(Jahr>=2018,51,52)","v":51},{"$f":"ROUNDUP(B114/3*2,0)","v":34},34,{"$f":"IF(Jahr>=2018,161,142)","v":161},-10.200000000000001,"Kanada"]
["Vancouver",{"$f":"IF(Jahr>=2018,50,48)","v":50},33,33,{"$f":"IF(Jahr>=2018,140,106)","v":140},-10,"Kanada"]
["Kap Verde",30,20,20,55,-6," "]
["Kasachstan",{"$f":"IF(Jahr>=2019,45,39)","v":45},30,30,{"$f":"IF(Jahr>=2019,111,109)","v":111},-9," "]
["Katar",56,37,37,{"$f":"IF(Jahr>=2020,149,170)","v":149},-11.200000000000001," "]
["Kenia",{"$f":"IF(Jahr<2016,35,42)","v":42},{"$f":"ROUNDUP(B119/3*2,0)","v":28},28,{"$f":"IF(Jahr<2016,135,223)","v":223},-8.4," "]
["Kirgisistan",{"$f":"IF(Jahr>=2020,27,29)","v":27},{"$f":"ROUNDUP(B120/3*2,0)","v":18},18,{"$f":"IF(Jahr>=2020,74,91)","v":74},-5.4," "]
["Kolumbien",{"$f":"IF(Jahr>=2020,46,41)","v":46},{"$f":"ROUNDUP(B121/3*2,0)","v":31},31,{"$f":"IF(Jahr>=2020,115,126)","v":115},-9.2000000000000011," "]
["Kongo, Republik",{"$f":"IF(Jahr<2016,57,50)","v":50},33,33,{"$f":"IF(Jahr<2016,113,200)","v":200},-10," "]
["Kongo, Demokratische Rep. (früher: Zaire)",{"$f":"IF(Jahr>=2020,70,68)","v":70},47,47,{"$f":"IF(Jahr>=2020,190,171)","v":190},-14," "]
["Kongo, Demokratische Republik",{"$f":"IF(Jahr>=2020,70,68)","v":70},47,47,{"$f":"IF(Jahr>=2020,190,171)","v":190},{"$f":"B124*-0.2","v":-14},"(früher Zaire)"]
["Korea, Demokratische Volksrepublik",{"$f":"IF(Jahr>=2020,28,39)","v":28},19,19,{"$f":"IF(Jahr>=2020,92,132)","v":92},-5.6000000000000005,"(Nord-Korea)"]
["Korea, Republik",{"$f":"IF(Jahr<2016,66,58)","v":58},39,39,{"$f":"IF(Jahr<2016,180,112)","v":112},-11.600000000000001,"(Süd-Korea)"]
["Kosovo",{"$f":"IF(Jahr>=2017,23,26)","v":23},{"$f":"IF(Jahr>=2017,ROUNDUP(B127/3*2,0),ROUND(B127/3*2,0))","v":16},16,{"$f":"IF(Jahr>=2017,57,65)","v":57},-4.6000000000000005," "]
["Kroatien",{"$f":"IF(Jahr>=2020,35,28)","v":35},{"$f":"ROUNDUP(B128/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2020,107,75)","v":107},-7," "]
["Kuba",{"$f":"IF(Jahr>=2018,46,50)","v":46},31,31,{"$f":"IF(Jahr>=2018,228,85)","v":228},-9.2000000000000011," "]
["Kuwait",42,28,28,{"$f":"IF(Jahr<2016,130,185)","v":185},-8.4," "]
["Laos",33,22,22,{"$f":"IF(Jahr>=2018,96,67)","v":96},{"$f":"B131*-0.2","v":-6.6000000000000005},"Demokratische VR Laos"]
["Lesotho",24,16,16,{"$f":"IF(Jahr<2016,70,103)","v":103},-4.8000000000000007," "]
["Lettland",{"$f":"IF(Jahr>=2020,35,30)","v":35},{"$f":"ROUNDUP(B133/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2020,76,80)","v":76},-7," "]
["Libanon",{"$f":"IF(Jahr>=2019,59,44)","v":59},{"$f":"IF(Jahr>=2019,ROUNDUP(B134/3*2,0),ROUND(B134/3*2,0))","v":40},40,{"$f":"IF(Jahr>=2019,123,120)","v":123},-11.8," "]
["Libyen",{"$f":"IF(Jahr>=2019,63,45)","v":63},42,42,{"$f":"IF(Jahr>=2019,135,100)","v":135},{"$f":"B135*-0.2","v":-12.600000000000001},"Libysch-Arab.Dsch."]
["Liechtenstein",{"$f":"IF(Jahr<2016,47,53)","v":53},{"$f":"ROUNDUP(B136/3*2,0)","v":36},36,{"$f":"IF(Jahr<2016,82,180)","v":180},-10.600000000000001," "]
["Litauen",{"$f":"IF(Jahr>=2020,26,24)","v":26},17,17,{"$f":"IF(Jahr>=2020,109,68)","v":109},-5.2," "]
["Luxemburg",47,{"$f":"ROUNDUP(B138/3*2,0)","v":32},32,{"$f":"IF(Jahr>=2018,130,102)","v":130},-9.4," "]
["Madagaskar",{"$f":"IF(Jahr>=2018,34,38)","v":34},{"$f":"ROUND(B139/3*2,0)","v":23},23,{"$f":"IF(Jahr>=2018,87,83)","v":87},-6.8000000000000007," "]
["MW - Malawi",{"$f":"IF(Jahr<2016,39,47)","v":47},{"$f":"IF(Jahr<2016,ROUND(B140/3*2,0),ROUNDUP(B140/3*2,0))","v":32},32,{"$f":"IF(Jahr<2016,110,123)","v":123},-9.4," "]
["Blantyre",{"$f":"IF(Jahr<2016,39,47)","v":47},{"$f":"IF(Jahr<2016,ROUND(B141/3*2,0),ROUNDUP(B141/3*2,0))","v":32},32,{"$f":"IF(Jahr<2016,110,123)","v":123},{"$f":"B141*-0.2","v":-9.4},"Malawi"]
["Malaysia",{"$f":"IF(Jahr>=2017,34,36)","v":34},23,{"$f":"C142","v":23},{"$f":"IF(Jahr>=2017,88,100)","v":88},-6.8000000000000007," "]
["Malediven",{"$f":"IF(Jahr>=2018,52,38)","v":52},35,35,{"$f":"IF(Jahr>=2018,170,93)","v":170},-10.4," "]
["Mali",{"$f":"IF(Jahr>=2020,38,41)","v":38},{"$f":"IF(Jahr>=2020,ROUND(B144/3*2,0),ROUNDUP(B144/3*2,0))","v":25},25,{"$f":"IF(Jahr>=2020,120,122)","v":120},-7.6000000000000005," "]
["Malta",{"$f":"IF(Jahr>=2020,46,45)","v":46},31,31,{"$f":"IF(Jahr>=2020,114,112)","v":114},-9.2000000000000011," "]
["Marokko",42,28,28,{"$f":"IF(Jahr>=2017,129,105)","v":129},-8.4," "]
["Marshall Inseln",63,42,42,{"$f":"IF(Jahr>=2019,102,70)","v":102},-12.600000000000001," "]
["Mauretanien",{"$f":"IF(Jahr<2016,48,39)","v":39},26,26,{"$f":"IF(Jahr<2016,89,105)","v":105},-7.8000000000000007," "]
["Mauritius",{"$f":"IF(Jahr>=2018,54,48)","v":54},36,36,{"$f":"IF(Jahr>=2018,220,140)","v":220},-10.8," "]
["Mazedonien",{"$f":"IF(Jahr>=2018,29,24)","v":29},{"$f":"ROUNDUP(B150/3*2,0)","v":20},20,95,-5.8000000000000007," "]
["Mexiko",{"$f":"IF(Jahr>=2020,48,41)","v":48},{"$f":"ROUNDUP(B151/3*2,0)","v":32},32,{"$f":"IF(Jahr>=2020,177,141)","v":177},-9.6000000000000014," "]
["Mikronesien",{"$f":"IF(Jahr>=2019,33,56)","v":33},22,22,{"$f":"IF(Jahr>=2019,116,74)","v":116},-6.6000000000000005," "]
["Moldau, Republik",{"$f":"IF(Jahr>=2017,24,18)","v":24},16,16,{"$f":"IF(Jahr>=2017,88,100)","v":88},-4.8000000000000007," "]
["Monaco",{"$f":"IF(Jahr>=2017,42,41)","v":42},{"$f":"ROUNDUP(B154/3*2,0)","v":28},28,{"$f":"IF(Jahr>=2017,180,52)","v":180},-8.4," "]
["Mongolei",{"$f":"IF(Jahr>=2018,27,29)","v":27},{"$f":"ROUNDUP(B155/3*2,0)","v":18},18,{"$f":"IF(Jahr>=2018,92,84)","v":92},-5.4," "]
["Montenegro",29,20,20,{"$f":"IF(Jahr>=2017,94,95)","v":94},{"$f":"B156*-0.2","v":-5.8000000000000007}," "]
["Mosambik",{"$f":"IF(Jahr>=2019,38,42)","v":38},25,25,{"$f":"IF(Jahr>=2019,146,147)","v":146},-7.6000000000000005," "]
["Myanmar  (Burma)",{"$f":"IF(Jahr>=2017,35,46)","v":35},{"$f":"IF(Jahr>=2017,ROUNDUP(B158/3*2,0),ROUND(B158/3*2,0))","v":24},24,{"$f":"IF(Jahr>=2017,155,45)","v":155},-7," "]
["Namibia",{"$f":"IF(Jahr>=2020,30,23)","v":30},{"$f":"ROUNDUP(B159/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2020,112,77)","v":112},-6," "]
["Nepal",{"$f":"IF(Jahr<2015,32,28)","v":28},{"$f":"ROUND(B160/3*2,0)","v":19},19,{"$f":"IF(Jahr<2015,72,86)","v":86},-5.6000000000000005," "]
["Neuseeland",{"$f":"IF(Jahr>=2018,56,47)","v":56},{"$f":"ROUNDDOWN(B161/3*2,0)","v":37},37,{"$f":"IF(Jahr>=2018,153,98)","v":153},-11.200000000000001," "]
["Nicaragua",{"$f":"IF(Jahr<2016,30,36)","v":36},24,24,{"$f":"IF(Jahr<2016,100,81)","v":81},-7.2," "]
["Niederlande",{"$f":"IF(Jahr>=2020,47,46)","v":47},{"$f":"ROUNDUP(B163/3*2,0)","v":32},32,{"$f":"IF(Jahr>=2020,122,119)","v":122},-9.4," "]
["Niger",{"$f":"IF(Jahr>=2018,41,36)","v":41},{"$f":"ROUNDUP(B164/3*2,0)","v":28},28,{"$f":"IF(Jahr>=2018,89,70)","v":89},-8.2000000000000011," "]
["WAN - Nigeria",{"$f":"IF(Jahr>=2020,46,63)","v":46},31,31,{"$f":"IF(Jahr>=2020,182,255)","v":182},{"$f":"B165*-0.2","v":-9.2000000000000011}," "]
["Abuja",{"$f":"IF(Jahr>=2020,46,63)","v":46},{"$f":"ROUND(B166/3*2,0)","v":31},{"$f":"C166","v":31},{"$f":"IF(Jahr>=2020,182,255)","v":182},{"$f":"B166*-0.2","v":-9.2000000000000011},"Nigeria"]
["Lagos",{"$f":"IF(Jahr>=2020,46,63)","v":46},31,31,{"$f":"IF(Jahr>=2020,182,255)","v":182},-9.2000000000000011,"Nigeria"]
["Norwegen",{"$f":"IF(Jahr>=2018,80,64)","v":80},53,53,182,{"$f":"B168*-0.2","v":-16}," "]
["A - Österreich",{"$f":"IF(Jahr>=2019,40,36)","v":40},{"$f":"ROUNDUP(B169/3*2,0)","v":27},27,{"$f":"IF(Jahr>=2019,108,104)","v":108},-8," "]
["Wien",{"$f":"IF(Jahr>=2019,40,36)","v":40},{"$f":"ROUNDUP(B170/3*2,0)","v":27},27,{"$f":"IF(Jahr>=2019,108,104)","v":108},-8,"Österreich"]
["Oman",{"$f":"IF(Jahr>=2017,60,48)","v":60},40,40,{"$f":"IF(Jahr>=2017,200,120)","v":200},-12," "]
["PK - Pakistan",{"$f":"IF(Jahr>=2020,34,27)","v":34},23,23,{"$f":"IF(Jahr>=2020,122,68)","v":122},-6.8000000000000007," "]
["Islamabad",{"$f":"IF(Jahr>=2020,23,30)","v":23},{"$f":"ROUNDUP(B173/3*2,0)","v":16},16,{"$f":"IF(Jahr>=2020,238,165)","v":238},-4.6000000000000005,"Pakistan"]
["Palau",51,34,34,{"$f":"IF(Jahr>=2019,179,166)","v":179},-10.200000000000001," "]
["Panama",{"$f":"IF(Jahr>=2017,39,34)","v":39},26,26,{"$f":"IF(Jahr>=2017,111,101)","v":111},-7.8000000000000007," "]
["Papua-Neuguinea",{"$f":"IF(Jahr>=2017,60,36)","v":60},40,40,{"$f":"IF(Jahr>=2017,234,90)","v":234},-12," "]
["Paraguay",{"$f":"IF(Jahr>=2018,38,36)","v":38},25,25,{"$f":"IF(Jahr>=2018,108,61)","v":108},-7.6000000000000005," "]
["Peru",{"$f":"IF(Jahr>=2020,34,30)","v":34},23,23,{"$f":"IF(Jahr>=2020,143,93)","v":143},-6.8000000000000007," "]
["Philippinen",{"$f":"IF(Jahr>=2019,33,30)","v":33},22,22,{"$f":"IF(Jahr>=2019,116,107)","v":116},-6.6000000000000005," "]
["PL - Polen",{"$f":"IF(Jahr>=2019,29,27)","v":29},{"$f":"ROUNDUP(B180/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2019,60,50)","v":60},{"$f":"B180*-0.2","v":-5.8000000000000007}," "]
["Breslau",33,22,22,{"$f":"IF(Jahr>=2019,117,92)","v":117},{"$f":"B181*-0.2","v":-6.6000000000000005}," "]
["Danzig",{"$f":"IF(Jahr>=2019,30,29)","v":30},{"$f":"ROUNDUP(B182/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2019,84,77)","v":84},{"$f":"B182*-0.2","v":-6}," "]
["Krakau",{"$f":"IF(Jahr>=2019,27,28)","v":27},18,18,{"$f":"IF(Jahr>=2019,86,88)","v":86},-5.4,"Polen"]
["Warschau",{"$f":"IF(Jahr>=2019,29,30)","v":29},{"$f":"ROUNDUP(B184/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2019,109,105)","v":109},-5.8000000000000007,"Polen"]
["P - Portugal",{"$f":"IF(Jahr<2015,33,36)","v":36},24,24,{"$f":"IF(Jahr<2015,95,92)","v":92},{"$f":"B185*-0.2","v":-7.2}," "]
["Lissabon",36,24,24,{"$f":"IF(Jahr<2015,95,92)","v":92},-7.2,"Portugal"]
["Ruanda",{"$f":"IF(Jahr<2016,36,46)","v":46},31,31,{"$f":"IF(Jahr<2016,135,141)","v":141},-9.2000000000000011," "]
["R - Rumänien",{"$f":"IF(Jahr>=2017,26,27)","v":26},17,17,{"$f":"IF(Jahr>=2017,62,80)","v":62},{"$f":"B188*-0.2","v":-5.2}," "]
["Bukarest",{"$f":"IF(Jahr>=2017,32,26)","v":32},21,21,100,-6.4,"Rumänien"]
["RUS - Russ.Föderation",{"$f":"IF(Jahr>=2017,24,IF(Jahr<2015,36,21))","v":24},16,16,{"$f":"IF(Jahr>=2017,58,IF(Jahr<2015,80,78))","v":58},{"$f":"B190*-0.2","v":-4.8000000000000007}," "]
["Jekatarinenburg",{"$f":"IF(Jahr>=2017,28,21)","v":28},{"$f":"ROUND(B191/3*2,0)","v":19},{"$f":"C191","v":19},{"$f":"IF(Jahr>=2017,84,78)","v":84},{"$f":"B191*-0.2","v":-5.6000000000000005},"Russische Föderation"]
["Moskau",{"$f":"IF(Jahr<2015,33,30)","v":30},20,20,110,-6,"Russische Föderation"]
["St. Petersburg",{"$f":"IF(Jahr>=2017,26,IF(Jahr<2015,36,24))","v":26},17,17,{"$f":"IF(Jahr>=2017,114,IF(Jahr<2015,110,104))","v":114},-5.2,"Russische Föderation"]
["Sambia",36,24,24,{"$f":"IF(Jahr>=2017,130,95)","v":130},-7.2," "]
["Samoa",29,{"$f":"ROUNDUP(B195/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2017,85,57)","v":85},-5.8000000000000007," "]
["San Marino",{"$f":"IF(Jahr>=2017,34,41)","v":34},{"$f":"ROUNDUP(B196/3*2,0)","v":23},{"$f":"C196","v":23},{"$f":"IF(Jahr>=2017,75,77)","v":75},{"$f":"B196*-0.2","v":-6.8000000000000007}," "]
["Sao Tomé u. Principe",{"$f":"IF(Jahr>=2017,47,42)","v":47},{"$f":"IF(Jahr>=2017,ROUNDUP(B197/3*2,0),ROUND(B197/3*2,0))","v":32},32,{"$f":"IF(Jahr>=2017,80,75)","v":80},{"$f":"B197*-0.2","v":-9.4}," "]
["SA - Saudi-Arabien",{"$f":"IF(Jahr<2016,47,48)","v":48},32,32,80,{"$f":"B198*-0.2","v":-9.6000000000000014}," "]
["Djidda",{"$f":"IF(Jahr<2016,48,38)","v":38},25,25,{"$f":"IF(Jahr<2016,80,234)","v":234},{"$f":"B199*-0.2","v":-7.6000000000000005},"Saudi-Arabien"]
["Riad",48,32,32,{"$f":"IF(Jahr<2016,95,179)","v":179},-9.6000000000000014,"Saudi-Arabien"]
["Schweden",{"$f":"IF(Jahr<2016,72,50)","v":50},33,33,{"$f":"IF(Jahr<2016,165,168)","v":168},-10," "]
["CH - Schweiz",{"$f":"IF(Jahr<2016,48,62)","v":62},41,41,{"$f":"IF(Jahr<2016,139,169)","v":169},-12.4," "]
["Bern",{"$f":"IF(Jahr<2016,48,62)","v":62},41,41,{"$f":"IF(Jahr<2016,139,169)","v":169},{"$f":"B203*-0.2","v":-12.4},"Schweiz"]
["Genf",{"$f":"IF(Jahr<2016,62,64)","v":64},43,43,{"$f":"IF(Jahr<2016,174,195)","v":195},{"$f":"B204*-0.2","v":-12.8},"Schweiz"]
["Senegal",{"$f":"IF(Jahr<2015,42,IF(Jahr<2016,47,45))","v":45},{"$f":"ROUNDUP(B205/3*2,0)","v":30},30,{"$f":"IF(Jahr<2015,90,IF(Jahr<2016,125,128))","v":128},-9," "]
["Serbien",{"$f":"IF(Jahr>=2017,20,30)","v":20},13,13,{"$f":"IF(Jahr>=2017,74,90)","v":74},-4," "]
["Sierra Leone",{"$f":"IF(Jahr>=2019,48,39)","v":48},32,32,{"$f":"IF(Jahr>=2019,161,82)","v":161},-9.6000000000000014," "]
["Simbabwe",45,{"$f":"ROUNDUP(B208/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2019,140,103)","v":140},-9," "]
["Singapur",{"$f":"IF(Jahr>=2019,54,53)","v":54},{"$f":"ROUNDUP(B209/3*2,0)","v":36},36,{"$f":"IF(Jahr>=2019,197,188)","v":197},-10.8," "]
["Slowakische Republik",24,16,16,{"$f":"IF(Jahr>=2017,85,130)","v":85},-4.8000000000000007," "]
["Slowenien",{"$f":"IF(Jahr>=2017,33,30)","v":33},22,22,95,-6.6000000000000005," "]
["E - Spanien",{"$f":"IF(Jahr>=2019,34,29)","v":34},{"$f":"ROUNDUP(B212/3*2,0)","v":23},{"$f":"C212","v":23},{"$f":"IF(Jahr>=2019,115,88)","v":115},{"$f":"B212*-0.2","v":-6.8000000000000007}," "]
["Barcelona",{"$f":"IF(Jahr>=2019,34,32)","v":34},23,23,118,-6.8000000000000007,"Spanien"]
["Madrid",{"$f":"IF(Jahr>=2019,40,41)","v":40},{"$f":"ROUNDUP(B214/3*2,0)","v":27},27,{"$f":"IF(Jahr>=2019,118,113)","v":118},-8,"Spanien"]
["Kanarische Inseln",{"$f":"IF(Jahr>=2019,40,32)","v":40},27,27,{"$f":"IF(Jahr>=2019,115,98)","v":115},-8,"Spanien"]
["Palma de Mallorca",{"$f":"IF(Jahr>=2019,35,32)","v":35},{"$f":"IF(Jahr>=2019,ROUNDUP(B216/3*2,0),ROUND(B216/3*2,0))","v":24},24,{"$f":"IF(Jahr>=2019,121,110)","v":121},-7,"Spanien"]
["Sri Lanka",{"$f":"IF(Jahr>=2018,42,40)","v":42},28,28,{"$f":"IF(Jahr>=2018,100,118)","v":100},-8.4," "]
["St. Kitts und Nevis",45,30,30,{"$f":"IF(Jahr>=2019,177,99)","v":177},-9," "]
["St. Lucia",{"$f":"IF(Jahr>=2019,45,54)","v":45},30,30,{"$f":"IF(Jahr>=2019,177,129)","v":177},-9," "]
["St. Vincent und die Grenadinen",{"$f":"IF(Jahr>=2019,45,52)","v":45},30,30,{"$f":"IF(Jahr>=2019,177,121)","v":177},-9," "]
["Sudan",{"$f":"IF(Jahr>=2020,33,35)","v":33},{"$f":"IF(Jahr<2015,ROUND(B221/3*2,0),ROUNDUP(B221/3*2,0))","v":22},22,{"$f":"IF(Jahr>=2020,195,115)","v":195},-6.6000000000000005," "]
["ZA -Südafrika",{"$f":"IF(Jahr<2016,36,22)","v":22},15,15,{"$f":"IF(Jahr<2016,72,94)","v":94},-4.4000000000000004," "]
["Johannisburg",{"$f":"IF(Jahr<2016,36,29)","v":29},{"$f":"IF(Jahr<2016,ROUND(B223/3*2,0),ROUNDUP(B223/3*2,0))","v":20},20,{"$f":"IF(Jahr<2016,72,124)","v":124},-5.8000000000000007,"Südafrika"]
["Kapstadt",{"$f":"IF(Jahr<2016,38,27)","v":27},18,18,{"$f":"IF(Jahr<2016,94,112)","v":112},{"$f":"B224*-0.2","v":-5.4},"Südafrika"]
["Südsudan",{"$f":"IF(Jahr>=2017,34,IF(Jahr<2015,46,53))","v":34},{"$f":"IF(Jahr<2015,ROUND(B225/3*2,0),ROUNDUP(B225/3*2,0))","v":23},23,{"$f":"IF(Jahr>=2017,150,IF(Jahr<2015,134,114))","v":150},{"$f":"B225*-0.2","v":-6.8000000000000007}," "]
["Suriname",{"$f":"IF(Jahr>=2019,45,41)","v":45},{"$f":"IF(Jahr<2016,ROUND(B226/3*2,0),ROUNDUP(B226/3*2,0))","v":30},30,{"$f":"IF(Jahr>=2019,177,108)","v":177},-9," "]
["Syrien, Arab.Repubik",38,25,25,140,-7.6000000000000005," "]
["Tadschikistan",{"$f":"IF(Jahr>=2019,27,26)","v":27},18,18,{"$f":"IF(Jahr>=2019,118,67)","v":118},-5.4," "]
["Taiwan",{"$f":"IF(Jahr>=2020,46,IF(Jahr>=2017,51,39))","v":46},31,31,{"$f":"IF(Jahr>=2020,143,IF(Jahr>=2017,126,110))","v":143},-9.2000000000000011," "]
["Tansania",{"$f":"IF(Jahr<2016,40,47)","v":47},{"$f":"IF(Jahr<2016,ROUND(B230/3*2,0),ROUNDUP(B230/3*2,0))","v":32},32,{"$f":"IF(Jahr<2016,141,201)","v":201},-9.4," "]
["Thailand",{"$f":"IF(Jahr>=2019,38,32)","v":38},{"$f":"ROUND(B231/3*2,0)","v":25},25,{"$f":"IF(Jahr>=2019,110,118)","v":110},-7.6000000000000005," "]
["Togo",{"$f":"IF(Jahr>=2020,39,35)","v":39},{"$f":"IF(Jahr<2015,ROUND(B232/3*2,0),ROUNDUP(B232/3*2,0))","v":26},26,{"$f":"IF(Jahr>=2020,118,108)","v":118},-7.8000000000000007," "]
["Tonga",{"$f":"IF(Jahr>=2018,39,32)","v":39},26,26,{"$f":"IF(Jahr>=2018,94,36)","v":94},-7.8000000000000007," "]
["Trinidad und Tobago",{"$f":"IF(Jahr>=2019,45,54)","v":45},{"$f":"ROUNDUP(B234/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2019,177,164)","v":177},-9," "]
["Tschad",{"$f":"IF(Jahr>=2018,64,47)","v":64},{"$f":"ROUNDUP(B235/3*2,0)","v":43},43,{"$f":"IF(Jahr>=2018,163,151)","v":163},-12.8," "]
["Tschechische Rep.",{"$f":"IF(Jahr>=2017,35,24)","v":35},{"$f":"ROUNDUP(B236/3*2,0)","v":24},24,{"$f":"IF(Jahr>=2017,94,97)","v":94},-7," "]
["TR - Türkei",{"$f":"IF(Jahr>=2020,17,40)","v":17},{"$f":"ROUNDUP(B237/3*2,0)","v":12},12,{"$f":"IF(Jahr>=2020,95,78)","v":95},{"$f":"B237*-0.2","v":-3.4000000000000004}," "]
["Istanbul",{"$f":"IF(Jahr>=2020,26,35)","v":26},{"$f":"IF(Jahr<=2020,ROUND(B238/3*2,0),ROUNDUP(B238/3*2,0))","v":17},17,{"$f":"IF(Jahr>=2020,120,104)","v":120},-5.2,"Türkei"]
["Izmir",{"$f":"IF(Jahr>=2020,29,42)","v":29},{"$f":"ROUNDUP(B239/3*2,0)","v":20},20,{"$f":"IF(Jahr>=2020,55,80)","v":55},-5.8000000000000007,"Türkei"]
["Tunesien",{"$f":"IF(Jahr>=2018,40,33)","v":40},27,27,{"$f":"IF(Jahr>=2018,115,80)","v":115},-8," "]
["Turkmenistan",33,22,22,108,-6.6000000000000005," "]
["Uganda",{"$f":"IF(Jahr>=2020,41,35)","v":41},{"$f":"IF(Jahr<2015,ROUND(B242/3*2,0),ROUNDUP(B242/3*2,0))","v":28},28,{"$f":"IF(Jahr>=2020,143,129)","v":143},-8.2000000000000011," "]
["Ukraine",{"$f":"IF(Jahr>=2020,26,IF(Jahr>=2017,32,36))","v":26},17,17,{"$f":"IF(Jahr>=2017,98,85)","v":98},-5.2," "]
["Ungarn",{"$f":"IF(Jahr>=2017,22,30)","v":22},15,15,{"$f":"IF(Jahr>=2017,63,75)","v":63},-4.4000000000000004," "]
["Uruguay",{"$f":"IF(Jahr>=2020,48,44)","v":48},32,32,{"$f":"IF(Jahr>=2020,90,109)","v":90},-9.6000000000000014," "]
["USA - Verein. Staaten",51,34,34,138,-10.200000000000001," "]
["Atlanta",62,41,41,175,-12.4,"Vereinigte Staaten"]
["Boston",58,39,39,265,-11.600000000000001,"Vereinigte Staaten"]
["Chicago",54,{"$f":"ROUND(B249/3*2,0)","v":36},36,209,{"$f":"B249*-0.2","v":-10.8},"Vereinigte Staaten"]
["Houston",63,42,42,138,{"$f":"B250*-0.2","v":-12.600000000000001},"Vereinigte Staaten"]
["Los Angeles",56,37,37,274,-11.200000000000001,"Vereinigte Staaten"]
["Miami",64,43,43,151,{"$f":"B252*-0.2","v":-12.8},"Vereinigte Staaten"]
["New York City",58,{"$f":"ROUND(B253/3*2,0)","v":39},39,282,{"$f":"B253*-0.2","v":-11.600000000000001},"Vereinigte Staaten"]
["San Francisco",51,{"$f":"ROUNDUP(B254/3*2,0)","v":34},34,314,{"$f":"B254*-0.2","v":-10.200000000000001},"Vereinigte Staaten"]
["Washington D.C.",62,41,41,276,{"$f":"B255*-0.2","v":-12.4},"Vereinigte Staaten"]
["Usbekistan",{"$f":"IF(Jahr<2015,30,34)","v":34},23,23,{"$f":"IF(Jahr>=2020,104,123)","v":104},-6.8000000000000007," "]
["Vatikanstaat",52,35,35,160,-10.4," "]
["Venezuela",{"$f":"IF(Jahr>=2020,45,IF(Jahr>=2019,69,IF(Jahr>=2018,47,48)))","v":45},{"$f":"ROUNDUP(B258/3*2,0)","v":30},30,{"$f":"IF(Jahr>=2019,127,IF(Jahr>=2018,120,207))","v":127},{"$f":"B258*-0.2","v":-9}," "]
["VAE - Verein. Arab. E.",{"$f":"IF(Jahr>=2020,65,45)","v":65},{"$f":"ROUNDUP(B259/3*2,0)","v":44},44,{"$f":"IF(Jahr>=2020,156,155)","v":156},-13," "]
["Dubai",{"$f":"IF(Jahr>=2020,65,45)","v":65},{"$f":"ROUNDUP(B260/3*2,0)","v":44},44,{"$f":"IF(Jahr>=2020,156,155)","v":156},-13,"Verein. Arab. Emirate"]
["GB - Verein.Königreich",{"$f":"IF(Jahr<2016,42,45)","v":45},30,30,{"$f":"IF(Jahr<2016,119,115)","v":115},{"$f":"B261*-0.2","v":-9}," "]
["London",{"$f":"IF(Jahr<2016,57,62)","v":62},41,41,{"$f":"IF(Jahr<2016,160,224)","v":224},-12.4,"Vereinigtes Königreich"]
["Edinburgh",{"$f":"IF(Jahr<2016,42,45)","v":45},30,30,{"$f":"IF(Jahr<2016,119,115)","v":115},-9,"Vereinigtes Königreich"]
["Vietnam",{"$f":"IF(Jahr>=2019,41,38)","v":41},{"$f":"IF(Jahr>=2019,ROUNDUP(B264/3*2,0),ROUND(B264/3*2,0))","v":28},28,86,{"$f":"B264*-0.2","v":-8.2000000000000011}," "]
["Weißrußland",{"$f":"IF(Jahr>=2018,20,27)","v":20},13,13,{"$f":"IF(Jahr>=2018,98,109)","v":98},-4," "]
["Zentralafrikan.Republik",46,{"$f":"ROUNDUP(B266/3*2,0)","v":31},31,74,-9.2000000000000011," "]
["Zypern",45,30,30,116,-9," "]

{"sheet":"Fahrzeug","index":4,"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":5,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Kontenplan Reisekosten"]
[null,"Arbeitnehmer","Unternehmer"]
[null,"Konto","Konto"]
[" "," "," "]
["Autobahngeb. 0%","10 6650","10 6670"]
["Autobahngeb.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"]
["Geschenk b.35,- 0%","10 6610","10 6610"]
["Geschenk b.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"]
["20% Kürzung Pauschale","10 6660","10 6680"]
["40% Kürzung Pauschale","10 6660","10 6680"]
["60% Kürzung Pauschale","10 6660","10 6680"]
["80% Kürzung Pauschale","10 6660","10 6680"]
["100% Kürzung Pauschale","10 6660","10 6680"]
["Landkarte 0%","10 6650","10 6670"]
["Landkarte 7%","80 6650","80 6670"]
["lfd. Kfz-Kosten 0%","10 6530",{"$f":"B38","v":"10 6530"}]
["lfd. Kfz-Kosten 19%","90 6530",{"$f":"B39","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":"B44","v":"10 6595"}]
["Mietwagen 19%","90 6595",{"$f":"B45","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"}]
["Wagenpflege 0%","10 6530",{"$f":"B60","v":"10 6530"}]
["Wagenpflege 19%","90 6530",{"$f":"B61","v":"90 6530"}]
["Werkzeuge 0%","10 6845",{"$f":"B62","v":"10 6845"}]
["Werkzeuge 19%","90 6845",{"$f":"B63","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":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["_KAW999934","J"]
["_KAW999120","K0000133"]