Demo Cycle Template Calendar 2015
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEF
1
2
Only Columns with blue headers need to be edited. Green headers are optional. Columns with red headers should not Be edited.
3
4
5
6
7
8
9
Blog Post
10
Sheet Set Up
11


1. Go to the "Teacher Schedule" sheet and customize the "Day Cycle" column to match your schedule. The sheet is set up for a 6 day cycle by default.

2. Go to the "Event List" sheet and customize column A. This column becomes the event choices represented in the drop down menus on the teacher schedule sheet.

3. Return to the "Teacher Schedule," Customize columns "E" and "F" to match your period lengths. Each day can have unique times.

4. As you set times, you can set corresponding event titles in column "H."

5. Go to the "Day Cycle" sheet and add the holidays from your calendar.

6. Stay on the "Day Cycle" sheet and fill in the new day cycle added in step 1, working around the holidays.

7. Run the formMule Script (See below)
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Script Directions:
28


1. Click the "formMule" menu item and select "Run initial configuration." Then initialize and grant permission.

2. Click on the "formMule" menu again and select "Step 1: Define Merge Source Settings."

3. Under "Choose the sheet that you want the script to use as a data source for merged emails and/or calendar events." use the drop down menu to select "Master Schedule." Then, clcik "save settings."

4. Copy the Calendar Address of the calendar that you will be setting up. Learn more about Calendar addresses here: https://support.google.com/calendar/answer/37083?hl=en&rd=1

5. Click on the "formMule" menu again and select "Step 2b: Set up Calendar Merge." Use the image below to set up your merge. This does not include the optional step of inviting guests or attaching documents. Click "Save calendar settings" when done.

6. Click on the "formMule" menu again and select "Preview and Perform Manual Merge"
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
Loading...
 
 
 
Directions
TeacherSchedule
Day Cycle
Event List
Master Schedule
Sept
Oct
Nov
Dec
Jan
Feb
Mar
April
May
June