{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Ausgaben","Einnahmen","Gewinn - Verlust - Zusammenfass"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Ausgaben","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,5],[2,1,3,1]]}
[null,"Veranstaltungsbudget für [Veranstaltungsname] ",{"$nulls":5},"AUSGABEN"]
[]
[null,"GESAMTAUSGABEN",{"$nulls":4},"Geschätzt","Tatsächlich"]
[{"$nulls":6},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"882.00 €"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"333.00 €"}}]
[]
[null,"Veranstaltungsort","Geschätzt","Tatsächlich",null,"Erfrischungen","Geschätzt","Tatsächlich"]
[null,"Gebühren für Raum und Halle",{"v":500,"d":"500.00 €"},null,null,"Essen"]
[null,"Personal am Veranstaltungsort",{"$nulls":3},"Getränke",{"v":20,"d":"20.00 €"}]
[null,"Ausstattung",{"$nulls":3},"Tischwäsche",null,{"v":20,"d":"20.00 €"}]
[null,"Tische und Stühle",{"$nulls":3},"Personal und Trinkgelder"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle1[Geschätzt])","v":{"v":500,"d":"500.00 €"}},{"$f":"SUBTOTAL(109,Tabelle1[Tatsächlich])","v":{"v":0,"d":"0.00 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle3[Geschätzt])","v":{"v":20,"d":"20.00 €"}},{"$f":"SUBTOTAL(109,Tabelle3[Tatsächlich])","v":{"v":20,"d":"20.00 €"}}]
[]
[null,"Dekorationen","Geschätzt","Tatsächlich",null,"Programm","Geschätzt","Tatsächlich"]
[null,"Blumen",{"v":200,"d":"200.00 €"},{"v":300,"d":"300.00 €"},null,"Künstler"]
[null,"Kerzen",{"$nulls":3},"Referenten",{"v":30,"d":"30.00 €"}]
[null,"Beleuchtung",{"$nulls":3},"Reise"]
[null,"Ballons",{"$nulls":3},"Hotel"]
[null,"Papierlieferungen",{"$nulls":3},"Sonstiges"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle4[Geschätzt])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,Tabelle4[Tatsächlich])","v":{"v":300,"d":"300.00 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle5[Geschätzt])","v":{"v":30,"d":"30.00 €"}},{"$f":"SUBTOTAL(109,Tabelle5[Tatsächlich])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Öffentlichkeitsarbeit","Geschätzt","Tatsächlich",null,"Preise","Geschätzt","Tatsächlich"]
[null,"Grafikarbeiten",{"$nulls":3},"Schleifen/Plaketten/Pokale"]
[null,"Kopieren/Drucken",{"v":20,"d":"20.00 €"},null,null,"Geschenke",{"v":100,"d":"100.00 €"}]
[null,"Porto",{"$nulls":3},"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle7[Geschätzt])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,Tabelle7[Tatsächlich])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle6[Geschätzt])","v":{"v":20,"d":"20.00 €"}},{"$f":"SUBTOTAL(109,Tabelle6[Tatsächlich])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Sonstiges","Geschätzt","Tatsächlich"]
[null,"Telefon",null,{"v":13,"d":"13.00 €"}]
[null,"Beförderung",{"v":12,"d":"12.00 €"}]
[null,"Büromaterial"]
[null,"Faxdienste"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle8[Geschätzt])","v":{"v":12,"d":"12.00 €"}},{"$f":"SUBTOTAL(109,Tabelle8[Tatsächlich])","v":{"v":13,"d":"13.00 €"}}]

{"sheet":"Einnahmen","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,4],[2,1,3,1]]}
[null,"Veranstaltungsbudget für [Veranstaltungsname] ",{"$nulls":4},"EINNAHMEN"]
[]
[null,"GESAMTEINNAHMEN",{"$nulls":3},"Geschätzt","Tatsächlich"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"1,831.00 €"}}]
[]
[null,"EINTRITTE"]
[null,"Geschätzte Anzahl","Tatsächliche Anzahl","Typ","Preis","Geschätzte Einnahmen","Tatsächliche Einnahmen"]
[null,300,278,"Erwachsene @",{"v":5,"d":"5.00 €"},{"$f":"B8*E8","v":{"v":1500,"d":"1,500.00 €"}},{"$f":"C8*E8","v":{"v":1390,"d":"1,390.00 €"}}]
[null,197,195,"Kinder @",{"v":2,"d":"2.00 €"},{"$f":"B9*E9","v":{"v":394,"d":"394.00 €"}},{"$f":"C9*E9","v":{"v":390,"d":"390.00 €"}}]
[null,42,51,"Andere @",{"v":1,"d":"1.00 €"},{"$f":"B10*E10","v":{"v":42,"d":"42.00 €"}},{"$f":"C10*E10","v":{"v":51,"d":"51.00 €"}}]
[null,"Ergebnis",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabelle9[Geschätzte Einnahmen])","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"SUBTOTAL(109,Tabelle9[Tatsächliche Einnahmen])","v":{"v":1831,"d":"1,831.00 €"}}]
[]
[null,"ANZEIGEN IM PROGRAMM"]
[null,"Geschätzte Anzahl","Tatsächliche Anzahl","Typ","Preis","Geschätzte Einnahmen","Tatsächliche Einnahmen"]
[null,12,null,"Deckblätter @",null,{"$f":"B15*E15","v":{"v":0,"d":"0.00 €"}},{"$f":"C15*E15","v":{"v":0,"d":"0.00 €"}}]
[null,null,158,"Halbe Seiten @",null,{"$f":"B16*E16","v":{"v":0,"d":"0.00 €"}},{"$f":"C16*E16","v":{"v":0,"d":"0.00 €"}}]
[null,4,null,"Viertelseiten @",null,{"$f":"B17*E17","v":{"v":0,"d":"0.00 €"}},{"$f":"C17*E17","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabelle10[Geschätzte Einnahmen])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle10[Tatsächliche Einnahmen])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"AUSSTELLER/LIEFERANTEN"]
[null,"Geschätzte Anzahl","Tatsächliche Anzahl","Typ","Preis","Geschätzte Einnahmen","Tatsächliche Einnahmen"]
[null,23,null,"Große Stände @",null,{"$f":"B22*E22","v":{"v":0,"d":"0.00 €"}},{"$f":"C22*E22","v":{"v":0,"d":"0.00 €"}}]
[null,354,null,"Mittelgroße Stände @",null,{"$f":"B23*E23","v":{"v":0,"d":"0.00 €"}},{"$f":"C23*E23","v":{"v":0,"d":"0.00 €"}}]
[null,56,null,"Kleine Stände @",null,{"$f":"B24*E24","v":{"v":0,"d":"0.00 €"}},{"$f":"C24*E24","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabelle11[Geschätzte Einnahmen])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle11[Tatsächliche Einnahmen])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"VERKAUF VON ARTIKELN"]
[null,"Geschätzte Anzahl","Tatsächliche Anzahl","Typ","Preis","Geschätzte Einnahmen","Tatsächliche Einnahmen"]
[{"$nulls":3},"Artikel @",null,{"$f":"B29*E29","v":{"v":0,"d":"0.00 €"}},{"$f":"C29*E29","v":{"v":0,"d":"0.00 €"}}]
[null,123,null,"Artikel @",null,{"$f":"B30*E30","v":{"v":0,"d":"0.00 €"}},{"$f":"C30*E30","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Artikel @",null,{"$f":"B31*E31","v":{"v":0,"d":"0.00 €"}},{"$f":"C31*E31","v":{"v":0,"d":"0.00 €"}}]
[null,13,null,"Artikel @",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 €"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabelle12[Geschätzte Einnahmen])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabelle12[Tatsächliche Einnahmen])","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Gewinn - Verlust - Zusammenfass","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,4]]}
[" ","Veranstaltungsbudget für [Veranstaltungsname] ",{"$nulls":4},"GEWINN "]
[{"$nulls":6},"Zusammenfassung Verlust"]
[]
[]
[null,null,"Geschätzt","Tatsächlich"]
[null,"Einkünfte gesamt",{"$f":"Einnahmen!F4","v":{"v":1936,"d":"1,936.00 €"}},{"$f":"Einnahmen!G4","v":{"v":1831,"d":"1,831.00 €"}}]
[null,"Gesamtausgaben",{"$f":"Ausgaben!G4","v":{"v":882,"d":"882.00 €"}},{"$f":"Ausgaben!H4","v":{"v":333,"d":"333.00 €"}}]
[]
[null,"Gesamtgewinn             (oder -verlust)",{"$f":"C6-C7","v":{"v":1054,"d":"1,054.00 €"}},{"$f":"D6-D7","v":{"v":1498,"d":"1,498.00 €"}}]