{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Kontoübersicht","Rückbuchungen"],"not_rendered":{"charts":0,"images":0,"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":"Kontoübersicht","index":0,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Geplante Ausgaben, Maiball 2016"]
[]
["Kostenpunkt",null,null,"Betrag","MwSt. Satz","MwSt. Betrag","Gezahlt am","Anlage Nr","Bemerkungen"]
["Stadthalle  (Zahl aus 2015)",null,null,{"$f":"8629.76-2688","v":5941.76},0.19,{"$f":"D4-(D4/1.19)","v":948.68436974789893},null,null,"Stadthalle gesamt:",null,null,{"$f":"SUM(D4:D6)","v":9105.76}]
["Catering Stadthalle (Mitternachtssnack, Sektempfang)","Adam Jassowicz",null,2856,0.19,{"$f":"D5-(D5/1.19)","v":456},null,1,"Stadthalle + Kuchen letztes Jahr:",null,null,9329.76]
["Wertmarken 616 a 0,50€",null,null,{"$f":"616*0.5","v":308},0.19,{"$f":"D6-(D6/1.19)","v":49.176470588235304},null,null,"Ersparnis:",null,null,{"$f":"L5-L4","v":224}]
[]
["Getränkeeinkauf/Verpflegung Tanzorchester/Rosen/Tänzer (REWE+Aldi)",null,null,103.27]
["Automiete",null,null,36.68,0.19,5.86]
["Parkticket",null,null,9,0.19,1.44]
[]
["Gage Tanzorchester",null,null,2300,0,0]
["Gage DJ ",null,null,100,0,0]
["GEMA (8h, 700m², 45€, 550 Gäste, Werbung, bis 50% Tonträger)",null,null,1747.96,7.0000000000000007E-2,{"$f":"D14-(D14/1.07)","v":114.35252336448616}]
["Miete Räumlichkeiten Tanzkurs ",null,null,250,0,0]
["Gage Showact ",null,null,250,0,0]
[]
["Briefmarken Ausland",null,null,{"$f":"0.9*1.13","v":1.0169999999999999},0.19,{"$f":"D18-(D18/1.19)","v":0.16237815126050414},null,null,"Portoerhöhung 2016 um 13% berücksichtigt"]
["Kopiekosten Vera",null,null,30.59,0.19,{"$f":"D19-(D19/1.19)","v":4.8841176470588223}]
["Porto/Briefe",null,null,{"$f":"144.4*1.13","v":163.172},0.19,{"$f":"D20-(D20/1.19)","v":26.052672268907543},null,null,"Portoerhöhung 2016 um 13% berücksichtigt"]
["Porto Briefe GEMA",null,null,{"$f":"2.9*1.13","v":3.2769999999999997},0.19,{"$f":"D21-(D21/1.19)","v":0.52321848739495769},null,null,"Portoerhöhung 2016 um 13% berücksichtigt"]
["Druckkosten Karten",null,null,44.2,0.19,7.06]
[]
["Anzahlung Jugendherberge ",null,null,1000,0,0]
["Nachzahlung Jugendherberge",null,"Zu viel gezahlt, Gutschrift für 2016  22€",759,0,0]
["Steffis Hostel",null,null,764,"7% + 19%",{"$f":"44.5+13.41","v":57.91}]
[]
["Deko (Blumen + Papiermanschetten)",null,null,115,7.0000000000000007E-2,7.52]
["Herzen + Satinbänder Spendeaktion",null,null,112.04,"19% auf Satin",3.39]
["Deko (100 Teelichter)",null,null,9.99,0.19,1.6]
["Deko (Tischläufer)",null,null,84.99,0.19,13.57]
["Wertmarken",null,null,18.43,0.19,2.94]
[]
["Abschlussessen Orgateam",null,null,300]
["Spende",null,null,500,0,0]
["Geschenk Tanzkurslehrer",null,null,30,0.19,{"$f":"0.19*D36","v":5.7}]
["Weinflasche + Studentenküsse",null,null,{"$f":"4.9+12.9","v":17.8},"??",0]
[]
["4 Freikarten aus Pärchenspiel 20 15",null,null,{"$f":"4*B45","v":140},0.19,{"$f":"D39-(D39/1.19)","v":22.35294117647058}]
[]
["Umsatzsteuer Einnahmen",null,null,{"$f":"SUM(F45:F49)","v":3310.0793000000003}]
["Gesamt Ausgaben",null,null,{"$f":"SUM(D4:D41)","v":21306.255300000008},null,{"$f":"SUM(F4:F41)","v":1729.1786914317131}]
[]
["Voraussichtliche Einnahmen, Maiball 2016","Einzelpreis","Anzahl","Netto","UmSt. Satz","UmSt. Betrag","Anlage"]
["Eintrittskarten",35,{"$f":"D45/B45","v":569.44542857142858},{"$f":"19970.59-40","v":19930.59},0.19,{"$f":"(D45-E46)*0.19","v":3310.0793000000003}]
[null,null,null,"davon:",2509.12,"Jugendherberge"]
[]
["Sponsoring",null,null,0,0.19,{"$f":"D48*0.19","v":0}]
["Spendeneinnahmen",null,null,0,0,0]
[]
[]
["Rückeinnahmen Jugendherberge+Steffis hostel"]
["Gutschrift Jugendherberge",null,null,22]
[]
[]
["Gesamt Einnahmen",null,null,{"$f":"SUM(D45:D55)","v":19952.59}]
["Saldo abzüglich UmSt.",null,null,{"$f":"D56-D42","v":-1353.6653000000078}]
["Saldo zuzüglich Voraussteuer",null,null,{"$f":"D57+F42","v":375.51339143170526}]

{"sheet":"Rückbuchungen","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Rückbuchungen"]
[]
["Steffen Zaschka",null,50]
["Baris Baloglu",null,27]
["Lina Driouk",null,148]
["David Retzmann",null,149]
["Jan Klaas Janßen",null,30]
["Felix Bergmann",null,99]
["Leonie Schültke",null,50]
["Tobias Stark",null,102]
[null,null,655]