Abrechnung/Payroll für Lehrer (Variante 2: Bonus nach Teilnehmerspanne)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S	T	U	V	W	X	Y
1	Bonus tiers	Starts with x participants	until Y participants	Bonus
2	Tier 1	0	4	10
3	Tier 2	5	9	15
4	Tier 3	10	19	20
5	Tier 4	20	100	30
6	Tier 5
7
8		Fixed income per teacher and class			Number of classes per tier					Number of classes per duration							Activity of your selected time period (Export from Activity Overview)
9		Fixed income / short class (45/60min)	Fixed income / long class (75/90min)		Tier 1	Tier 2	Tier 3	Tier 4	Tier 5	# short classes (45/60min)	# long classes (75/90min)	Total classes	Total fixed income	Total bonus	Total income	Duration	Date	Start time	End time	Class title	Enrolled	Participants	Maximum	Teacher
10	Maria	20	30		0	0	1	0	0	0	1	1	30	20	50	01:30	01.03.17	10:00	11:30	Gentle Hatha Yoga	11	11	24	Maria
11	Daniela	20	30		0	1	2	0	0	0	3	3	90	55	145	01:30	01.03.17	17:30	19:00	Vinyasa Flow English	17	17	24	Daniela
12	Max	20	30		1	0	1	0	0	0	2	2	60	30	90	01:30	01.03.17	19:15	20:45	Heal Your Back - English	4	4	24	Max
13	Lukas	20	30		0	1	6	1	0	0	8	8	240	165	405	01:30	01.03.17	19:30	21:00	Beginnerkurs	10	10	24	Lukas
14					0	0	0	0	0	0	0	0	0	0	0	01:30	02.03.17	17:30	19:00	Beginnerkurs	12	11	24	Lukas
15					0	0	0	0	0	0	0	0	0	0	0	01:30	02.03.17	17:30	19:00	Yoga All Levels English	15	15	28	Lukas
16					0	0	0	0	0	0	0	0	0	0	0	01:30	02.03.17	19:30	21:00	Yin Yoga	7	7	24	Lukas
17					0	0	0	0	0	0	0	0	0	0	0	01:30	02.03.17	19:30	21:00	Vinyasa Flow	16	16	24	Lukas
18					0	0	0	0	0	0	0	0	0	0	0	01:30	03.03.17	16:00	17:30	Vinyasa Flow	24	24	24	Lukas
19					0	0	0	0	0	0	0	0	0	0	0	01:30	04.03.17	11:00	12:30	Vinyasa Flow	10	10	24	Lukas
20					0	0	0	0	0	0	0	0	0	0	0	01:30	05.03.17	11:00	12:30	Vinyasa Flow	15	15	24	Lukas
21					0	0	0	0	0	0	0	0	0	0	0	01:30	05.03.17	18:00	19:30	Sunset Flow	6	6	24	Daniela
22					0	0	0	0	0	0	0	0	0	0	0	01:30	06.03.17	17:30	19:00	Beginnerkurs	16	16	24	Max
23					0	0	0	0	0	0	0	0	0	0	0	01:30	06.03.17	19:30	21:00	Vinyasa Flow	15	15	24	Daniela
24					0	0	0	0	0	0	0	0	0	0	0	00:00
25					0	0	0	0	0	0	0	0	0	0	0	00:00
26					0	0	0	0	0	0	0	0	0	0	0	00:00
27					0	0	0	0	0	0	0	0	0	0	0	00:00
28					0	0	0	0	0	0	0	0	0	0	0	00:00
29					0	0	0	0	0	0	0	0	0	0	0	00:00
30					0	0	0	0	0	0	0	0	0	0	0	00:00
31					0	0	0	0	0	0	0	0	0	0	0	00:00
32					0	0	0	0	0	0	0	0	0	0	0	00:00
33					0	0	0	0	0	0	0	0	0	0	0	00:00
34					0	0	0	0	0	0	0	0	0	0	0	00:00
35					0	0	0	0	0	0	0	0	0	0	0	00:00
36					0	0	0	0	0	0	0	0	0	0	0	00:00
37					0	0	0	0	0	0	0	0	0	0	0	00:00
38					0	0	0	0	0	0	0	0	0	0	0	00:00
39					0	0	0	0	0	0	0	0	0	0	0	00:00
40					0	0	0	0	0	0	0	0	0	0	0	00:00
41					0	0	0	0	0	0	0	0	0	0	0	00:00
42					0	0	0	0	0	0	0	0	0	0	0	00:00
43					0	0	0	0	0	0	0	0	0	0	0	00:00
44					0	0	0	0	0	0	0	0	0	0	0	00:00
45					0	0	0	0	0	0	0	0	0	0	0	00:00
46					0	0	0	0	0	0	0	0	0	0	0	00:00
47					0	0	0	0	0	0	0	0	0	0	0	00:00
48					0	0	0	0	0	0	0	0	0	0	0	00:00
49					0	0	0	0	0	0	0	0	0	0	0	00:00
50					0	0	0	0	0	0	0	0	0	0	0	00:00
51					0	0	0	0	0	0	0	0	0	0	0	00:00
52					0	0	0	0	0	0	0	0	0	0	0	00:00
53					0	0	0	0	0	0	0	0	0	0	0	00:00
54					0	0	0	0	0	0	0	0	0	0	0	00:00
55					0	0	0	0	0	0	0	0	0	0	0	00:00
56					0	0	0	0	0	0	0	0	0	0	0	00:00
57					0	0	0	0	0	0	0	0	0	0	0	00:00
58					0	0	0	0	0	0	0	0	0	0	0	00:00
59					0	0	0	0	0	0	0	0	0	0	0	00:00
60					0	0	0	0	0	0	0	0	0	0	0	00:00
61					0	0	0	0	0	0	0	0	0	0	0	00:00
62					0	0	0	0	0	0	0	0	0	0	0	00:00
63					0	0	0	0	0	0	0	0	0	0	0	00:00
64					0	0	0	0	0	0	0	0	0	0	0	00:00
65					0	0	0	0	0	0	0	0	0	0	0	00:00
66					0	0	0	0	0	0	0	0	0	0	0	00:00
67					0	0	0	0	0	0	0	0	0	0	0	00:00
68					0	0	0	0	0	0	0	0	0	0	0	00:00
69					0	0	0	0	0	0	0	0	0	0	0	00:00
70					0	0	0	0	0	0	0	0	0	0	0	00:00
71					0	0	0	0	0	0	0	0	0	0	0	00:00
72					0	0	0	0	0	0	0	0	0	0	0	00:00
73					0	0	0	0	0	0	0	0	0	0	0	00:00
74					0	0	0	0	0	0	0	0	0	0	0	00:00
75					0	0	0	0	0	0	0	0	0	0	0	00:00
76					0	0	0	0	0	0	0	0	0	0	0	00:00
77					0	0	0	0	0	0	0	0	0	0	0	00:00
78					0	0	0	0	0	0	0	0	0	0	0	00:00
79					0	0	0	0	0	0	0	0	0	0	0	00:00
80					0	0	0	0	0	0	0	0	0	0	0	00:00
81					0	0	0	0	0	0	0	0	0	0	0	00:00
82					0	0	0	0	0	0	0	0	0	0	0	00:00
83					0	0	0	0	0	0	0	0	0	0	0	00:00
84					0	0	0	0	0	0	0	0	0	0	0	00:00
85					0	0	0	0	0	0	0	0	0	0	0	00:00
86					0	0	0	0	0	0	0	0	0	0	0	00:00
87					0	0	0	0	0	0	0	0	0	0	0	00:00
88					0	0	0	0	0	0	0	0	0	0	0	00:00
89					0	0	0	0	0	0	0	0	0	0	0	00:00
90					0	0	0	0	0	0	0	0	0	0	0	00:00
91					0	0	0	0	0	0	0	0	0	0	0	00:00
92					0	0	0	0	0	0	0	0	0	0	0	00:00
93					0	0	0	0	0	0	0	0	0	0	0	00:00
94					0	0	0	0	0	0	0	0	0	0	0	00:00
95					0	0	0	0	0	0	0	0	0	0	0	00:00
96					0	0	0	0	0	0	0	0	0	0	0	00:00
97					0	0	0	0	0	0	0	0	0	0	0	00:00
98					0	0	0	0	0	0	0	0	0	0	0	00:00
99					0	0	0	0	0	0	0	0	0	0	0	00:00
100					0	0	0	0	0	0	0	0	0	0	0	00:00