2. Training - Operations - Zig Zag Calculator.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		Step 1: Check all group names and numbers in the yellow box >>				Step 3: Reverse the numbers for AM and PM slots for WEEK TWO so they are the opposite of WEEK ONE				Group		Number	Country	Package
3										Accademia GARDEN		100	Italy	Deluxe
4										Accademia PH		55	Italy	Deluxe
5		Step 2: Allocate groups to either AM or PM slots in the WEEK ONE chart below, following these rules:								BEX		30	Italy	Deluxe
6										GHAZALEH		20	Isreal	Deluxe
7						Step 4: Adjust the timetables on each tab of this spreadsheet so they accurately display which week is AM classes and which week is PM classes. Timetables must then be shared with their respective group leaders.				KI STUDY		15	Brazil	Explorer
8		- Groups larger than 50 should be split evenly between AM and PM								S&V		25	Spain	Explorer
9										TRAVELLING FOX		70	France	Explorer
10		- Nationalities in both slots should be as mixed as possible								ACES		18	Germany	Deluxe
11										AVENUE		2	Italy	Explorer
12		- The total number for each slot should be as balanced as possible								EGI		6	Italy	Explorer
13										GEC		23	China	Deluxe
14										MASTER STUDIO		12	Italy	Explorer
15		NOTE: The AM to pm slot denotes classes in the morning, activities in the afternoon								ZAINETTO		18	Italy	Explorer
16										OL		10	Taiwan	Explorer
17
18
19
20		SLOT (classes)	WEEK ONE ZIG ZAG TURN 1 WEEK 1
21	Garden Hall		Accademia GARDEN	Accademia PH	BEX	GHAZALEH	KI STUDY	S&V	TRAVELLING FOX	ACES	AVENUE	EGI	GEC	MASTER STUDIO	ZAINETTO	OL
22		AM to pm	75		30		15		35	18			23			10	TOTAL AM to pm	206
23		PM to am	25	50		20		25	35		2	6		12	18		TOTAL PM to am	193
24	Malvern House London
25		AM to pm															TOTAL AM to pm	0
26		PM to am															TOTAL PM to am	0
27
28	ZIG ZAG SWAP DAY ON DAY 9 = FRIDAY 14th JULY WEEK 2
29
30		SLOT (classes)	WEEK TWO ZIG ZAG TURN 1 WEEK 2
31	Garden Hall		Accademia GARDEN	Accademia PH	BEX	GHAZALEH	KI STUDY	S&V	TRAVELLING FOX	ACES	AVENUE	EGI	GEC	MASTER STUDIO	ZAINETTO	OL
32		AM	25	50		20		25	35		2	6		12	18		TOTAL AM	193
33		PM	75		30		15		35	18			23			10	TOTAL PM	206
34	Malvern House London
35		AM															TOTAL AM	0
36		PM															TOTAL PM	0
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100