ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
NOTE: This is a group shared spreadsheet that does not allow edits. In order to use for your own purposes you will need to make a copy: Select "File" and "Make a Copy.." and save in your Google Drive.
2
To use this gsheet:
3
1. Fill in your school's holidays one day at a time
4
2. Go to the tab for each class and edit them as needed. DON'T change any of the dates except the "start date" in B3 on each class tab.
5
3. To INSERT a unit:
6
 -- right click the row under the place you want to insert. Then click "insert row".
7
-- copy the two cells above or below in each of the dates column and paste the contents in BOTH the new row and the row directly under the new row.
8
 -- add the amount of days the unit will last.
9
 -- add the information in the rest of the columns.
10
4. To DELETE a unit:
11
 -- right click the row you wish to delete. Then click "delete row".
12
 -- all the dates below will show "#REF".
13
-- copy the cell above or below in the first dates column and paste the contents in the first row that shows #REF.
14
5. To create a new class:
15
 -- right click "Blank Class".
16
 -- click "Duplicate".
17
 -- fill in all the cells around the dates columns (B and C).
18
6. To add more units:
19
 -- copy the formulas in both the dates columns (B and C).
20
 -- paste them into the desired amount of cells below.
21
 -- add the information in the rest of the columns.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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