{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Planung 2024","Schulung (April)","Segway-Tour (Mai)"],"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":"Planung 2024","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,9,0,10],[0,6,0,8],[0,4,0,5]]}
[{"$nulls":4},"Einnahmen",null,"Ausgaben",null,null,"Gesamt"]
[null,null,null,"Teilnehmer","TN","Kosten/TN","Speisen/Getränke","Referent","Sonstiges","Einnahmen","Ausgaben"]
["Januar",null,"-",{"$nulls":6},{"$f":"E3*F3","v":0},{"$f":"G3+H3+I3","v":0}]
["Februar",null,"Jahreshauptversammlung",{"$nulls":4},500,null,{"$f":"E4*F4","v":0},{"$f":"G4+H4+I4","v":500}]
["März",null,"-",{"$nulls":6},0,0]
["April",null,"Bowling mit Wj",{"$nulls":5},300,0,300]
["Mai",null,"Freies Treffen",{"$nulls":6},0,0]
["Juni",null,"Schulung / Weiterbildung I",10,10,120,200,1000,1000,1200,2200]
["August",null,"Sommertreffen",20,{"$nulls":4},2000,0,2000]
["September",null,"Bundeskongress",6,{"$nulls":4},600,0,600]
["Oktober",null,"-",{"$nulls":6},0,0]
["November",null,"Schulung / Weiterbildung I",10,10,120,200,1000,1000,1200,2200]
[null,null,"Weihnachtstreffen",{"$nulls":5},200,0,200]
["Dezember",null,"-",{"$nulls":6},{"$f":"E14*F14","v":0},{"$f":"G14+H14+I14","v":0}]
["Gesamt",{"$nulls":8},{"$f":"SUM(J3:J13)","v":2400},{"$f":"SUM(K3:K13)","v":8000}]

{"sheet":"Schulung (April)","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Kalkulation der Schulung am 28.04.2023"]
[]
["Kosten pro TN:",115]
["Kosten für Speisen/Getränke:",54.5]
["Kosten für Referent:",761.6]
[]
["TN","Einnahmen","Ausgaben","Zuschuss vom Verein"]
[1,{"$f":"A8*$B$3","v":115},{"$f":"($B$4*(A8+2))+$B$5","v":925.1},{"$f":"C8-B8","v":810.1}]
[2,230,979.6,749.6]
[3,345,1034.0999999999999,689.09999999999991]
[4,460,1088.5999999999999,628.59999999999991]
[5,575,1143.0999999999999,568.09999999999991]
[6,{"$f":"A13*$B$3","v":690},{"$f":"($B$4*(A13+2))+$B$5","v":1197.5999999999999},{"$f":"C13-B13","v":507.59999999999991}]
[7,{"$f":"A14*$B$3","v":805},{"$f":"($B$4*(A14+2))+$B$5","v":1252.0999999999999},{"$f":"C14-B14","v":447.09999999999991}]
[8,920,1306.5999999999999,386.59999999999991]
[9,1035,1361.1,326.09999999999991]
[10,1150,1415.6,265.59999999999991]
[11,1265,1470.1,205.09999999999991]
[12,1380,1524.6,144.59999999999991]
[13,1495,1579.1,84.099999999999909]
[14,1610,1633.6,23.599999999999909]
[15,1725,1688.1,-36.900000000000091]

{"sheet":"Segway-Tour (Mai)","index":2,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Kalkulation der Segway-Tour am 06.05.2023 (20 TN)",null,null,null,"Kalkulation der Segway-Tour am 06.05.2023 (geändert auf 12 TN)"]
[]
["Kosten pro TN:",60,null,null,"Kosten pro TN:",64]
["Angebotskosten:",{"$f":"1280*1.19","v":1523.1999999999998},null,null,"Angebotskosten:",913.92]
["Kosten für zz. Guide ab 11 TN:",{"$f":"150*1.19","v":178.5},null,null,"Kosten für zz. Guide ab 11 TN:",{"$f":"150*1.19","v":178.5}]
[]
["TN","Einnahmen","Ausgaben","Zuschuss vom Verein","TN","Einnahmen","Ausgaben","Zuschuss vom Verein"]
[1,{"$f":"A8*$B$3","v":60},{"$f":"$B$4","v":1523.1999999999998},{"$f":"C8-B8","v":1463.1999999999998},1,{"$f":"E8*$B$3","v":60},{"$f":"$F$4","v":913.92},{"$f":"G8-F8","v":853.92}]
[2,120,{"$f":"$B$4","v":1523.1999999999998},1403.1999999999998,2,120,{"$f":"$F$4","v":913.92},793.92]
[3,180,1523.1999999999998,1343.1999999999998,3,180,913.92,733.92]
[4,240,1523.1999999999998,1283.1999999999998,4,240,913.92,673.92]
[5,300,1523.1999999999998,1223.1999999999998,5,300,913.92,613.91999999999996]
[6,{"$f":"A13*$B$3","v":360},1523.1999999999998,{"$f":"C13-B13","v":1163.1999999999998},6,{"$f":"E13*$B$3","v":360},913.92,{"$f":"G13-F13","v":553.91999999999996}]
[7,{"$f":"A14*$B$3","v":420},1523.1999999999998,{"$f":"C14-B14","v":1103.1999999999998},7,{"$f":"E14*$B$3","v":420},913.92,{"$f":"G14-F14","v":493.91999999999996}]
[8,480,1523.1999999999998,1043.1999999999998,8,480,913.92,433.91999999999996]
[9,540,1523.1999999999998,983.19999999999982,9,540,913.92,373.91999999999996]
[10,600,1523.1999999999998,923.19999999999982,10,600,913.92,313.91999999999996]
[11,660,1523.1999999999998,863.19999999999982,11,660,913.92,253.91999999999996]
[12,720,1523.1999999999998,803.19999999999982,12,720,913.92,193.91999999999996]
[13,780,{"$f":"$B$4+$B$5","v":1701.6999999999998},921.69999999999982,13,780,{"$f":"$F$4+$F$5+((E20-12)*64*1.19)","v":1168.5800000000002},388.58000000000015]
[14,840,{"$f":"$B$4+$B$5","v":1701.6999999999998},861.69999999999982,14,840,{"$f":"$F$4+$F$5+((E21-12)*64*1.19)","v":1244.74},404.74]
[15,900,1701.6999999999998,801.69999999999982,15,900,1320.9,420.90000000000009]
[16,960,1701.6999999999998,{"$f":"C23-B23","v":741.69999999999982},16,960,1397.06,437.05999999999995]
[17,1020,1701.6999999999998,681.69999999999982,17,1020,1473.22,453.22]
[18,1080,1701.6999999999998,621.69999999999982,18,1080,1549.38,469.38000000000011]
[19,1140,1701.6999999999998,561.69999999999982,19,1140,1625.54,485.53999999999996]
[20,1200,1701.6999999999998,501.69999999999982,20,1200,1701.7,501.70000000000005]
[]
["bei Reduzierung der Teilnehmer 7 Tage vorher",null,null,null,"bei Reduzierung der Teilnehmer 7 Tage vorher"]
[]
["TN","Einnahmen","Ausgaben","Zuschuss vom Verein","TN","Einnahmen","Ausgaben","Zuschuss vom Verein"]
[1,{"$f":"A32*$B$3","v":60},{"$f":"64*A32*1.19","v":76.16},{"$f":"C32-B32","v":16.159999999999997},1,{"$f":"E32*$B$3","v":60},{"$f":"64*E32*1.19","v":76.16},{"$f":"G32-F32","v":16.159999999999997}]
[2,120,{"$f":"64*A33*1.19","v":152.32},32.319999999999993,2,120,{"$f":"64*E33*1.19","v":152.32},32.319999999999993]
[3,180,228.48,48.47999999999999,3,180,228.48,48.47999999999999]
[4,240,304.64,64.639999999999986,4,240,304.64,64.639999999999986]
[5,300,380.79999999999995,80.799999999999955,5,300,380.79999999999995,80.799999999999955]
[6,{"$f":"A37*$B$3","v":360},456.96,{"$f":"C37-B37","v":96.95999999999998},6,{"$f":"E37*$B$3","v":360},456.96,{"$f":"G37-F37","v":96.95999999999998}]
[7,{"$f":"A38*$B$3","v":420},533.12,{"$f":"C38-B38","v":113.12},7,{"$f":"E38*$B$3","v":420},533.12,{"$f":"G38-F38","v":113.12}]
[8,480,609.28,129.27999999999997,8,480,609.28,129.27999999999997]
[9,540,685.43999999999994,145.43999999999994,9,540,685.43999999999994,145.43999999999994]
[10,600,761.59999999999991,161.59999999999991,10,600,761.59999999999991,161.59999999999991]
[11,660,837.76,177.76,11,660,837.76,177.76]
[12,720,913.92,193.91999999999996,12,720,913.92,193.91999999999996]
[]
[]
["Kosten bei Stornierung bis 4 Wochen vorher",null,0.1,{"$f":"B4*0.1","v":152.32},"Kosten bei Stornierung bis 4 Wochen vorher",null,0.1,{"$f":"F4*0.1","v":91.391999999999996}]
["2023-04-07",null,null,null,"2023-04-07"]
["Kosten bei Stornierung bis 2 Wochen vorher",null,0.5,{"$f":"B4*0.5","v":761.59999999999991},"Kosten bei Stornierung bis 2 Wochen vorher",null,0.5,{"$f":"F4*0.5","v":456.96}]
["2023-04-21",null,null,null,"2023-04-21"]
["Kosten bei Stornierung bis 1 Woche vorher",null,0.75,{"$f":"B4*0.75","v":1142.3999999999999},"Kosten bei Stornierung bis 1 Woche vorher",null,0.75,{"$f":"F4*0.75","v":685.43999999999994}]
["2023-04-28",null,null,null,"2023-04-28"]
["Reduzierung der Teilnehmer bis 7 Tage vorher kostenfrei.",null,null,null,"Reduzierung der Teilnehmer bis 7 Tage vorher kostenfrei."]
["2023-04-28",null,null,null,"2023-04-28"]
[]
["Kostenübernahme vom Verein:",null,null,null,"Kostenübernahme vom Verein:"]
["Die Übernahme von 19% des Einzelnettopreises und eine eventuell zusätzlicher Guide ",null,null,null,"Die Übernahme von 19% des Einzelnettopreises und eine eventuell zusätzlicher Guide "]
["würde durch den Verein bezahlt",null,null,null,"würde durch den Verein bezahlt"]