{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Budget - Budget Maiball 2017","Einnahmen - Einnahmen durch Ein","Einnahmen - Einnahmen durch Spo","Ausgaben - Ausgaben (vorläufig)","Ausgaben - Legende","Nebenrechnungen - Kontoführungs","Nebenrechnungen - Einkäufe","Nebenrechnungen - Sonstiges"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Budget - Budget Maiball 2017","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Budget Maiball 2017"]
["Einnahmen",{"$f":"'Einnahmen - Einnahmen durch Spo'!B4+'Einnahmen - Einnahmen durch Ein'!D5","v":16960}]
["Ausgaben",{"$f":"'Ausgaben - Ausgaben (vorläufig)'!B31","v":15629.839999999998}]
["Saldo",{"$f":"A2:B2-A3:B3","v":1330.1600000000017}]

{"sheet":"Einnahmen - Einnahmen durch Ein","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Einnahmen durch Eintrittskarten"]
["Posten","Anzahl","Stückpreis","Gesamtpreis"]
["Karten, reduziert (Stipendiatinnen/Stipendiaten oder Studierende)",370,35,{"$f":"B3*C3","v":12950}]
["Karten, regulär (Alumni, nicht-mehr-Studierende)",78,45,{"$f":"B4*C4","v":3510}]
["Summe",{"$f":"SUM(B3:B4)","v":448},{"$f":"D5/B5","v":36.741071428571431},{"$f":"SUM(D3:D4)","v":16460}]

{"sheet":"Einnahmen - Einnahmen durch Spo","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Einnahmen durch Sponsoring"]
["Posten","Gesamtpreis"]
["HeidelbergCement",500]
["Summe",{"$f":"SUM(B3:B3)","v":500}]

{"sheet":"Ausgaben - Ausgaben (vorläufig)","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Ausgaben (vorläufig)"]
["Posten","Betrag","USt.-Satz","USt.-Betrag","Kommentar"]
["Stadthalle",6595.28,0.19,{"$f":"B3-(B3/(1+C3))","v":1053.0278991596633}]
["Veranstalterhaftpflicht",192,0,0]
["Catering",2856,0.19,456]
[null,null,null,0]
["Getränkeeinkauf/Verpflegung Tanzorchester/Rosen/Tänzer (REWE+Aldi)",{"$f":"'Nebenrechnungen - Einkäufe'!B15","v":174.76},null,0]
[null,null,null,0]
["Gage Tanzorchester",2300,0,0]
["Gage Vertikaltuchartistin",250,null,0,"Rechnung steht noch aus, Quittung liegt vor; Ausgelegt von Tobi"]
["Gage Ballett",230,null,0]
["GEMA",1761.22,7.0000000000000007E-2,115.22000000000003]
["Raummiete Tanzkurs",178.5,0.19,28.5]
[null,null,null,0]
["Schloßführung sans Alumnibeitrag",100,null,0]
["Photograph",100,null,0]
[null,null,null,0]
["Umschläge und Briefmarken",157,7.0000000000000007E-2,10.271028037383189]
["Druckkosten Karten",34.26,0.19,5.4700840336134426]
[null,null,null,0]
["Vereinsregistereintrag",50,null,0]
["Notariat (Unterschriftsbeglaubigungen)",23.8,null,0]
["Kontoführungsgebühr",{"$f":"'Nebenrechnungen - Kontoführungs'!B15","v":109.72},null,0]
["Servermiete",36.94,0.19,5.8979831932773088]
["Sonstige Ausgaben",{"$f":"'Nebenrechnungen - Sonstiges'!B15","v":111.82},null,0]
[null,null,null,0]
["Blumen",195,null,0]
["Herzen und Bänder",75.44,null,0]
["Tischläufer",98.1,0.19,15.663025210084029]
[null,null,null,0]
["Gesamt",{"$f":"SUM(B3:B30)","v":15629.839999999998},null,{"$f":"SUM(D3:D30)","v":1690.0500196340213}]

{"sheet":"Ausgaben - Legende","index":4,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Legende"]
["Bezahlt"]
["Offen"]
["Geschätzt"]
["Korrektur nötig"]

{"sheet":"Nebenrechnungen - Kontoführungs","index":5,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Kontoführungsgebühren 2017"]
["Monat","Gebühr"]
["Januar",8.93]
["Februar",9.4]
["März",64.97]
["2013-03-31",9.16]
["Mai",17.260000000000002]
["Juni"]
["Juli"]
["2013-07-31"]
["2013-08-31"]
["Oktober"]
["2013-10-31"]
["Dezember"]
["Gesamt",{"$f":"SUM(B3:B14)","v":109.72}]

{"sheet":"Nebenrechnungen - Einkäufe","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Einkäufe"]
["Rechnung","Betrag"]
["Aldi 20. 5. 2017 I",105.66]
["REWE 20. 5. 2017 I",38.82]
["Aldi 20. 5. 2017 II",24.29]
["REWE 20. 5. 2017 II",40.32]
["davon Pfand",-34.33]
{"$rows_empty":7}
["Gesamt",{"$f":"SUM(B3:B14)","v":174.76}]

{"sheet":"Nebenrechnungen - Sonstiges","index":7,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Sonstiges"]
["Was?","Betrag","Wer?"]
["Porto GEMA",0.7,"Vereinskonto"]
["Parkgebühr",4.5,"Peter"]
["Kopien",8.1199999999999992,"Peter"]
["Verpflegung für Photographenfreund (der die Abendkasse vertreten hat)",15,"Dani"]
["Fahrtkosten Einkauf",9,"Felix"]
["Strafgebühr B41",74.5]
[]
[]
[]
[]
[]
[]
["Gesamt",{"$f":"SUM(B3:C14)","v":111.82}]