{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Stand 2021-09-27","Tabelle1","Daten","Kosten-Stellen","Historie"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":11,"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":"Stand 2021-09-27","index":0,"n_rows":65,"n_cols":33,"rows_kept":65,"cut":false,"hidden":false,"merged":[[49,8,51,9],[49,11,51,13],[51,1,51,3],[48,7,48,13],[47,7,47,13],[9,4,9,7],[11,4,11,7],[26,13,26,14],[27,13,27,14],[24,3,24,4],[19,13,19,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[25,13,25,14],[20,13,20,14],[18,3,18,4],[19,3,19,4],[21,3,21,4],[20,3,20,4],[11,10,11,11],[40,3,40,4],[40,6,40,7],[22,3,22,4],[23,3,23,4],[11,8,11,9],[13,3,13,14],[33,13,33,14],[34,13,34,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[18,6,18,7],[18,8,18,10],[17,6,17,7],[17,8,17,10],[11,13,11,14],[15,13,17,14],[12,9,12,13],[33,6,33,7],[64,1,64,3],[55,8,57,9],[55,11,57,13],[58,11,58,13],[58,8,58,9],[64,4,64,7],[64,10,64,14],[59,1,59,4],[57,1,57,3],[55,1,55,3],[56,1,56,3],[58,1,58,3],[63,3,63,4],[52,1,52,3],[53,1,53,3],[54,1,54,3],[48,1,49,5],[52,11,52,13],[54,7,54,13],[52,8,52,9],[9,18,17,18],[9,17,17,17],[9,16,17,16],[9,1,9,3],[9,10,9,14],[9,8,9,9],[15,5,17,5],[15,3,17,4],[15,2,17,2],[15,1,17,1],[15,6,15,11],[12,1,12,3],[12,4,12,6],[12,7,12,8],[13,1,13,2],[14,1,14,14],[18,13,18,14],[13,30,13,33],[14,30,14,33],[15,30,15,33],[16,30,16,33],[12,30,12,33],[41,21,41,29],[21,30,21,32],[1,20,1,27],[1,29,1,33],[2,30,2,33],[3,30,3,33],[4,30,4,33],[5,30,5,33],[7,30,7,33],[9,30,9,33],[11,30,11,33],[32,31,32,33],[33,31,33,33],[34,31,34,33],[35,31,35,33],[36,31,36,33],[37,31,37,33],[38,31,38,33],[39,31,39,33],[7,1,7,3],[2,1,2,9],[3,1,3,3],[3,4,3,6],[3,7,3,8],[3,9,3,13],[4,1,4,3],[5,10,5,14],[7,10,7,14],[4,8,4,9],[5,8,5,9],[7,8,7,9],[4,10,4,14],[4,4,4,7],[5,4,5,7],[7,4,7,7],[1,11,1,13],[2,11,2,13],[1,1,1,9],[50,1,50,3],[25,3,25,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[34,3,34,4],[46,11,46,13],[46,1,46,3],[47,1,47,3],[44,1,44,3],[43,1,43,3],[29,3,29,4],[30,3,30,4],[46,8,46,9],[31,3,31,4],[32,3,32,4],[11,1,11,3],[16,6,16,11],[36,8,36,10],[5,1,5,3],[37,8,37,10],[45,1,45,3],[26,3,26,4],[27,3,27,4],[28,3,28,4],[33,3,33,4],[41,1,42,5],[26,6,26,7],[27,6,27,7],[31,8,31,10],[32,8,32,10],[33,8,33,10],[43,8,45,9],[34,6,34,7],[35,8,35,10],[28,13,28,14],[29,13,29,14],[30,13,30,14],[19,8,19,10],[20,8,20,10],[21,8,21,10],[22,8,22,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10],[31,13,31,14],[32,13,32,14],[39,3,39,4],[41,7,42,13],[43,11,45,13],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[38,8,38,10],[39,8,39,10],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[28,8,28,10],[29,8,29,10],[30,8,30,10],[40,8,40,10],[38,13,38,14],[39,13,39,14],[34,8,34,10]]}
[]
[null,"Tischtennis Baden-Württemberg e.V.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fehler-Meldungen",null,null,null,null,null,null,null,null,"Fehler-Menü"]
[null,"Verwaltungskosten",null,null,null,null,null,null,null,null,null,"Kostenstelle",null,null,null,null,null,null,null,null,{"$f":"IF(L2=\"\",1,\"\")","v":1},1,null,null,null,null,null,null,null,1,"Als Erstes: Kostenstellen-Nummer eingeben>> Auswahl Dropdown (siehe auch Blatt \"Kosten-Stellen\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Anschrift-Feld ist nicht vollständig"]
[null,"Anschrift:",null,null,null,null,null,null,"Bankverbindung:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Bankverbindung ist nicht vollständig"]
[null,"Vorname Name:",null,null,null,null,null,null,"Bankname:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E6=\"\",E8=\"\",E10=\"\"),2,\"\")","v":2},2,null,null,null,null,null,null,null,4,"Angabe Amt / Funktion fehlt"]
[]
[null,"PLZ, Wohnort:",null,null,null,null,null,null,"BIC:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Datum fehlt oder falsch"]
[]
[null,"Straße:",null,null,null,null,null,null,"IBAN:",null,null,null,null,null,null,null," Gruppe"," Portosatz"," Anzahl Einträge in Zeile",null,{"$f":"IF(OR(K6=\"\",K8=\"\",K10=\"\"),3,\"\")","v":3},3,null,null,null,null,null,null,null,6,"Auswahl Sachkonto-Gruppe fehlt"]
[]
[null,"Amt / Funktion:",null,null,null,null,null,null,"Zeitraum  - von: ",null,{"$f":"IF(C19=\"\",\"\",MIN(C19:C40))","v":""},null,"bis:",{"$f":"IF(C19=\"\",\"\",MAX(C19:C40))","v":""},null,null,null,null,null,null,{"$f":"IF(E12=\"\",4,\"\")","v":4},4,null,null,null,null,null,null,null,7,"Angabe Gegenstand/Gesprächs-Empfänger fehlt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Angabe Anlass fehlt bei Porto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Angabe Sendungs-Art fehlt bei Porto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Angabe Beleg/Dauer/Anzahl fehlt"]
[null,null,"Datum","Gruppe",null,"Sach-\nkonto","Gegenstand",null,null,null,null,null,"Beleg-Nr.(Bx)","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Betrag fehlt (Porto automatisch)"]
[null,null,null,null,null,null,"bei Telefon:  Pauschale oder Gesprächs-Partner",null,null,null,null,null,"Dauer (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,"bei Porto:  Empfänger",null,"Anlass",null,null,"Art","Anzahl",null,null,null,null,null,null,null,5,6,7,8,9,10,11,12]
[null,"1.",null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,$AE$23:$AG$30,2,FALSE))","v":""},null,null,null,null,null,null,null,{"$f":"IF(Q19=5,M19*R19,\"\")","v":""},null,null,{"$f":"IF(C19=\"\",0,IF(ISNA(VLOOKUP(D19,$AE$23:$AG$30,3,FALSE)),\"F\",VLOOKUP(D19,$AE$23:$AG$30,3,FALSE)))","v":0},{"$f":"IF(Q19=5,IF(ISNA(VLOOKUP(L19,$E$45:$F$48,2,FALSE)),0,VLOOKUP(L19,$E$45:$F$48,2,FALSE)),0)","v":0},{"$f":"COUNTA(C19:E19,G19:M19)","v":0},null,{"$f":"IF(S19=0,\"\",IF(ISERROR(C19-1),5,IF(OR(YEAR(C19)-YEAR(TODAY())>1,(YEAR(C19)-YEAR(TODAY())<-3)),5,\"\")))","v":""},{"$f":"IF(S19=0,\"\",IF(D19=\"\",6,\"\"))","v":""},{"$f":"IF(S19=0,\"\",IF(G19=\"\",7,\"\"))","v":""},{"$f":"IF(S19=0,\"\",IF(AND(Q19=5,I19=\"\"),8,\"\"))","v":""},{"$f":"IF(S19=0,\"\",IF(AND(Q19=5,L19=\"\"),9,\"\"))","v":""},{"$f":"IF(S19=0,\"\",IF(M19=\"\",10,\"\"))","v":""},{"$f":"IF(OR(S19=0,Q19=5),\"\",IF(N19=\"\",11,\"\"))","v":""}]
[null,"2.",null,null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,$AE$23:$AG$30,2,FALSE))","v":""},null,null,null,null,null,null,null,{"$f":"IF(Q20=5,M20*R20,\"\")","v":""},null,null,{"$f":"IF(C20=\"\",0,IF(ISNA(VLOOKUP(D20,$AE$23:$AG$30,3,FALSE)),\"F\",VLOOKUP(D20,$AE$23:$AG$30,3,FALSE)))","v":0},{"$f":"IF(Q20=5,IF(ISNA(VLOOKUP(L20,$E$45:$F$48,2,FALSE)),0,VLOOKUP(L20,$E$45:$F$48,2,FALSE)),0)","v":0},{"$f":"COUNTA(C20:E20,G20:M20)","v":0},null,{"$f":"IF(S20=0,\"\",IF(ISERROR(C20-1),5,IF(OR(YEAR(C20)-YEAR(TODAY())>1,(YEAR(C20)-YEAR(TODAY())<-3)),5,\"\")))","v":""},{"$f":"IF(S20=0,\"\",IF(D20=\"\",6,\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(G20=\"\",7,\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(AND(Q20=5,I20=\"\"),8,\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(AND(Q20=5,L20=\"\"),9,\"\"))","v":""},{"$f":"IF(S20=0,\"\",IF(M20=\"\",10,\"\"))","v":""},{"$f":"IF(OR(S20=0,Q20=5),\"\",IF(N20=\"\",11,\"\"))","v":""}]
[null,"3.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"4.",null,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,$AE$23:$AG$30,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,{"$f":"IF(C22=\"\",0,IF(ISNA(VLOOKUP(D22,$AE$23:$AG$30,3,FALSE)),\"F\",VLOOKUP(D22,$AE$23:$AG$30,3,FALSE)))","v":0},{"$f":"IF(Q22=5,IF(ISNA(VLOOKUP(L22,$E$45:$F$48,2,FALSE)),0,VLOOKUP(L22,$E$45:$F$48,2,FALSE)),0)","v":0},0,null,{"$f":"IF(S22=0,\"\",IF(ISERROR(C22-1),5,IF(OR(YEAR(C22)-YEAR(TODAY())>1,(YEAR(C22)-YEAR(TODAY())<-3)),5,\"\")))","v":""},"","","","","",{"$f":"IF(OR(S22=0,Q22=5),\"\",IF(N22=\"\",11,\"\"))","v":""},null,null,null,"Gruppen-Liste  (aus Formular-Tabelle)"]
[null,"5.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,{"$f":"B52","v":"Bürobedarf: Verbrauch"},{"$f":"E52","v":2701},1]
[null,"6.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,"Bürobedarf: HW+SW",2701,2]
[null,"7.",null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(Q25=5,M25*R25,\"\")","v":""},null,null,0,0,0,null,"","","","","","","",null,null,null,"Kopien",2701,3]
[null,"8.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,"Telefon",2702,4]
[null,"9.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,"Porto",2702,5]
[null,"10.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,"Fachliteratur, DVD",2713,6]
[null,"11.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,"Geschenke",2802,7]
[null,"12.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","","",null,null,null,{"$f":"B59","v":"Rechnungsw: Bankgebühren"},{"$f":"E59","v":2803},8]
[null,"13.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"14.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"15.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"16.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"17.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"18.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"19.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"20.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"21.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[null,"22.",null,null,null,"",null,null,null,null,null,null,null,"",null,null,0,0,0,null,"","","","","","",""]
[]
[null,"Portosätze:",null,null,null,null,null,"Mit der Unterschrift wird die Richtigkeit bestätigt.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(U3:U17,U19:AB40)","v":1},"Fehler-Nummer des 1. Fehlers"]
[]
[null,"Art",null,null,"Kürzel","Porto"]
[null,"Standardbrief:  20 g    235 x 125 x 5 mm",null,null,"SB",0.8]
[null,"Kompaktbrief:  50 g    235 x 125 x 10 mm",null,null,"KB",0.95]
[null,"Großbrief:      500 g   335 x 250 x 20 mm",null,null,"GB",1.55,null,null,"(Datum)",null,null,"(Unterschrift)"]
[null,"Maxibrief:    1.000 g   335 x 250 x 50 mm",null,null,"MB",2.7]
[null,"Zusammenstellung:",null,null,null,null,null,"Freigabe:"]
[]
[null,"Gruppe",null,null,"SK","Betrag"]
[null,"Bürobedarf: Verbrauch",null,null,2701,{"$f":"IF(SUMIF($Q$19:$Q$40,AG23,$N$19:$N$40)=0,\"\",SUMIF($Q$19:$Q$40,AG23,$N$19:$N$40))","v":""}]
[null,"Bürobedarf: HW+SW",null,null,2701,"",null,null,"(Datum)",null,null,"(Unterschrift)"]
[null,"Kopien",null,null,2701,""]
[null,"Telefon",null,null,2702,"",null,"Überweisung:"]
[null,"Porto",null,null,2702,""]
[null,"Fachliteratur, DVD",null,null,2713,""]
[null,"Geschenke",null,null,2802,""]
[null,"Rechnungsw: Bankgebühren",null,null,2803,"",null,null,"(Datum)",null,null,"(Unterschrift)"]
[null,"Summe:",null,null,null,{"$f":"SUM(F52:F59)","v":0}]
[]
[]
[null,4,9,20,9,10,8,11,14,7,2,8,12,8,3,"Å",{"$f":"SUM(B63:N63)","v":122}]
[null,null,null,{"$f":"SUM(D63:E63)","v":29}]
[null,{"$f":"SUM(B63:D63)","v":33},null,null,{"$f":"SUM(E63:H63)","v":38},null,null,null,null,null,{"$f":"SUM(K63:P63)","v":33}]

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

{"sheet":"Daten","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,1,5,9],[6,1,6,9],[1,1,1,9],[2,1,2,9]]}
[]
[null,"Tischtennisverband Württemberg-Hohenzollern e.V."]
[null,"Verwaltungskosten"]
[]
[]
[null,"Tischtennis Baden-Württemberg e.V."]
[null,"Verwaltungskosten"]

{"sheet":"Kosten-Stellen","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Kostenstellen-\nNummern"]
[null,10000000,"Präsident","Präsidium, Hauptversammlung"]
[null,20000000,"Präsident","Öffentlichkeitsarbeit"]
[null,30000000,"VP Finanzen"," Haushaltsführung, Controlling, Buchhaltung"]
[null,40000000,"VP Sport","Erwachsenensport, Senioren: Wettkämpfe, Turniere"]
[null,50000000,"VP Jugend: JugSport","Jugendsport: Wettkämpfe, Turniere"]
[null,60000000,"VP Jugend: Sport-Entw.","Sportentwicklung"]
[null,70000000,"SportD: Kader","Kader/ Personal"]
[null,80000000,"SportD: Aus+FortB","Aus- und Fortbildung"]

{"sheet":"Historie","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,3],[3,0,3,3],[1,1,1,3]]}
["Abrechnung Verwaltungskosten"]
["Formular:","FO_TTBW-12e Abr-VerwKo"]
[]
["Versionsdokumentation"]
[]
["Version","Datum","Autor","Aktion / Änderung"]
["0","2013-12-29","W. Renz","Erstanfertigung"]
["1.0","2013-12-31","W. Renz","Darstellung verbessert, auch der ausgeblendeten Hilfstabellen; Briefport 58 > 60 c"]
["1.1","2014-01-06","W. Renz","G14: Überschrift erweitert \"bei Telefon:  Pauschale oder Gesprächs-Partner\""]
["1.2","2014-02-24","W. Renz","Automatische Zeitraum-Angabe eingefügt (Min und Max aus den Zeiten)"]
["2.0","2014-03-02","W. Renz","Kontroll- und Fehleranzeige verbessert; Formelfehler 11 (12) korrigiert"]
["2.3","2015-01-23","W. Renz","Briefporto neuen Beträgen angepasst"]