{"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,140]
["Automiete",null,null,40,0.19,5.86]
["Parkticket",null,null,10,0.19,1.44]
[]
["Gage Tanzorchester","Jannis",null,2300,0,0]
["Gage DJ ",null,null,100,0,0]
["GEMA (8h, 700m², 45€, 30min Pause, bis 50% Tonträger)",null,null,1934,7.0000000000000007E-2,{"$f":"D14-(D14/1.07)","v":126.52336448598135}]
["Miete Räumlichkeiten Tanzkurs ","Hannah Kordes",null,194,0,0]
["Gage Showact ","David Yang",null,350,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]
[]
[]
[]
[]
[]
["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]
[]
["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]
[]
[]
[]
["Umsatzsteuer Einnahmen",null,null,{"$f":"SUM(F45:F49)","v":3192}]
["Gesamt Ausgaben",null,null,{"$f":"SUM(D4:D41)","v":18296.266000000003},null,{"$f":"SUM(F4:F41)","v":1661.0865913767377}]
[]
["Voraussichtliche Einnahmen, Maiball 2016","Einzelpreis","Anzahl","Netto","UmSt. Satz","UmSt. Betrag","Anlage"]
["Eintrittskarten",35,480,{"$f":"B45*C45","v":16800},0.19,{"$f":"(D45)*0.19","v":3192}]
[null,{"$f":"B45*1.19","v":41.65}]
[null,{"$f":"B45/1.19","v":29.411764705882355}]
["Sponsoring",null,null,0,0.19,{"$f":"D48*0.19","v":0}]
["Spendeneinnahmen",null,null,0,0,0]
[]
[]
[]
[]
[]
[]
["Gesamt Einnahmen",null,null,{"$f":"SUM(D45:D55)","v":16800}]
["Saldo abzüglich UmSt.",null,null,{"$f":"D56-D42","v":-1496.2660000000033}]
["Saldo zuzüglich Voraussteuer",null,null,{"$f":"D57+F42","v":164.82059137673446}]

{"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]