3. Program
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This is the ACL 2017 Program Worksheet Template
2
3
To use this worksheet, replace the contents of the 'Input - Accepted Papers' worksheet. Because of connections to the rest of the worksheets, you may find it useful to cut and paste the appropriate data into the sheet. You will have all of the data except for the input fields that you need to decide on to create your schedule.
4
N.B. this is the sanitized version of the spreadsheet that we shared with the committee (we omitted the review fields and scores from the original)
5
6
The golden fields are the editable fields in all of the worksheets. You need to set appropriate values in them.
7
- First, in the Overview spreadsheet, set the prelimary times for your paper types
8
- Then in the 'Input - Accepted Papers', fill in your decisions on orals/posters, session assignments, and ordering within the sessions. The individual day programs and the overview sheets should automagically update as needed.
9
10
Hints:
11
- We found that liberal use of conditional formatting helps ti programmatically color cells in a way that helps with visualizing the program.
12
- We use the powerful Swiss-army knift "Query" function to build the programmatic schedules in the three day schedule
13
- You may find it necessary to update the source data after camera ready deadlines as titles, authors and abstracts change significantly. We didn't do this, but wished we had bandwidth to do this.
14
15
16
17
18
19
20
21
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
Loading...
 
 
 
Description
Overview
Input - Accepted Papers
Mon 31 Jul
Tue 1 Aug
Wed 2 Aug
 
 
Main menu