{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Berechnung Reisekosten_VpflP","Ermittlung der Umsatzsteuer","Kreise","Tabelle1","Tabelle2","Tabelle3","Tabelle4","Tabelle5","Tabelle6","Tabelle7","Tabelle8","Tabelle9","Tabelle10","Tabelle11"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Berechnung Reisekosten_VpflP","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,3,3,8],[1,1,1,14],[3,9,3,14]]}
[]
[null,"Fahrtkosten und Sitzungsgelder"]
[]
["Fahrt- und Verpflegungskosten",null,null,"Fahrtkosten",null,null,null,null,null,"Abwesen-\nheit",null,null,null,null,null,null,null,null,"Tagessatz"]
["Name, Vorname des Verbandsmitarbeiters","Datum","Reiseziel","öff. Verk.","Pkw:","Km-Geld","Pkw-Fahrtkosten",null,"Anzahl\nMitfahrer","von","bis","Teilnehmeranzahl","Dauer",null,"Vpfl.\nSatz","6 Std.","9 Std.","12 Std","über\n 12 Std."]
[null,null,null,null,null,{"$f":"$E6*0.3","v":0},{"$f":"$F6+$H6","v":0},{"$f":"$I6*0.02*$E6","v":0},null,null,null,null,{"$f":"$K6-$J6","v":"00:00:00"},{"$f":"$M6","v":"00:00:00"},{"$f":"SUM($P6:$S6)*L6","v":0},{"$f":"IF(AND($N6>0.001,$N6<0.25069),7,\"\")","v":""},{"$f":"IF(AND($N6>0.25069,$N6<0.37569),9,\"\")","v":""},{"$f":"IF(AND($N6>0.37569,$N6<0.50069),11,\"\")","v":""},{"$f":"IF($N6>0.50069,13,\"\")","v":""}]
[null,null,null,null,null,{"$f":"$E7*0.3","v":0},{"$f":"$F7+$H7","v":0},0,null,null,null,null,{"$f":"$K7-$J7","v":"00:00:00"},{"$f":"$M7","v":"00:00:00"},{"$f":"SUM($P7:$S7)*L7","v":0},{"$f":"IF(AND($N7>0.001,$N7<0.25069),7,\"\")","v":""},{"$f":"IF(AND($N7>0.25069,$N7<0.37569),9,\"\")","v":""},{"$f":"IF(AND($N7>0.37569,$N7<0.50069),11,\"\")","v":""},{"$f":"IF($N7>0.50069,13,\"\")","v":""}]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
[null,null,null,null,null,0,0,0,null,null,null,null,"00:00:00","00:00:00",0,"","","",""]
["GESAMT",null,null,{"$f":"SUM(D6:D24)","v":0},null,null,{"$f":"SUM(G6:G24)","v":0},{"$f":"SUM(H6:H24)","v":0},null,null,null,null,null,{"$f":"SUM(N6:N24)","v":0},{"$f":"SUM(O6:O24)","v":0}]

{"sheet":"Ermittlung der Umsatzsteuer","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":true,"merged":[[3,0,11,0],[12,0,18,0],[19,0,29,0]]}
[null,null,null,null,null,"KREIS"]
["Ermittlung der Zahllast/Erstattung:",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Wirtschaftlicher Geschäftsbetrieb","Bezeichnung:","Konto:","Betrag:","stpfl. Umsatz","UST"]
[]
[null,"Sponsoring",44003,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Anzeigenerlöse",44007,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Warenverkauf",44010,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Inventarverkauf",48490,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D6:D12)","v":{"$error":"#REF!"}},{"$f":"E12/1.19*0.19","v":{"$error":"#REF!"}},0.19]
["Zweckbetrieb"]
[null,"Eintrittsgelder",43006,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Spielbetrieb",43007,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Verkauf von",43008,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D14:D18)","v":{"$error":"#REF!"}},{"$f":"E18/1.07*0.07","v":{"$error":"#REF!"}},7.0000000000000007E-2]
[null,"Zeitschriften",null,null,{"$f":"E12+E18","v":{"$error":"#REF!"}},{"$f":"F12+F18","v":{"$error":"#REF!"}},"Umsatzsteuer"]
["Ideeller Bereich"]
[null,"Mitglieds- und",40002,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sonderbeiträge"]
[]
[null,"Start- und ",40010,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Meldegelder"]
[]
[null,"Lehrgangsge-"]
[null,"bühren"]
[null,"dezentral",41101,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"zentral",41103,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"./. Vorsteuer ",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"ERGEBNIS:",null,null,{"$f":"F19-F32","v":{"$error":"#REF!"}}]

{"sheet":"Kreise","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"KSt",null,"Bank"]
[1,"Kassel",1,"T1601",1,18472,1,13801,null,1,"2014-03-31"]
[2,"Werra-Meißner",2,"T1602",2,18480,2,13802,null,2,"2014-06-30"]
[4,"Schwalm-Eder",4,"T1603",4,18499,4,13804,null,3,"2014-09-30"]
[7,"Waldeck",7,"T1604",7,18402,7,13807,null,4,"2014-12-30"]
[8,"Hofgeismar-Wolfhagen",8,"T1605",8,18410,8,13808]
[10,"Marburg",10,"T1606",10,18429,10,13810]
[11,"Alsfeld",11,"T1607",11,18437,11,13811,null,63021,"T2000"]
[12,"Gießen",12,"T1608",12,18445,12,13812]
[13,"Wetzlar",13,"T1609",13,18461,13,13813]
[15,"Dillenburg",15,"T1610",15,18470,15,13815]
[16,"Biedenkopf",16,"T1611",16,18488,16,13816]
[17,"Frankenberg",17,"T1612",17,18400,17,13817]
[18,"Fulda",18,"T1613",18,18418,18,13818]
[19,"Schlüchtern",19,"T1614",19,18426,19,13819]
[21,"Lauterbach-Hünfeld",21,"T1615",21,18434,21,13821]
[22,"Hersfeld-Rotenburg",22,"T1616",22,18442,22,13822]
[24,"Frankfurt",24,"T1617",24,18450,24,13824]
[25,"Friedberg",25,"T1618",25,18469,25,13825]
[26,"Büdingen",26,"T1619",26,18477,26,13826]
[27,"Gelnhausen",27,"T1620",27,18485,27,13827]
[28,"Hanau",28,"T1621",28,18493,28,13828]
[29,"Offenbach",29,"T1622",29,18407,29,13829]
[30,"Maintaunus",30,"T1632",30,18415,30,13830]
[31,"Hochtaunus",31,"T1623",31,18423,31,13831]
[33,"Darmstadt",33,"T1624",33,18431,33,13833]
[34,"Dieburg",34,"T1625",34,18440,34,13834]
[35,"Odenwald",35,"T1626",35,18458,35,13835]
[36,"Bergstraße",36,"T1627",36,18474,36,13836]
[37,"Groß-Gerau",37,"T1628",37,18482,37,13837]
[38,"Wiesbaden",38,"T1629",38,18490,38,13838]
[40,"Rheingau-Taunus",40,"T1630",40,18404,40,13840]
[41,"Limburg-Weilburg",41,"T1631",41,18412,41,13841]

{"sheet":"Tabelle1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle4","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle5","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle6","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle7","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle8","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle9","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle10","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle11","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}