ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
README
2
PLRG PrinciplesPLRG HotCRP Guide
3
4
The DB tab is the single source of truth for the PLRG reading group.
5
Add, update, or remove papers from the schedule by editing the relevant row in the DB tab.
6
Conditional formatting rules will automatically color the row according to which quarter it falls in (orange = autumn, blue = winter, green = spring, yellow = summer).
7
The seasons are defined as: Winter 1/1 - 3/15; Spring 3/15 - 6/15; Summer 6/15 - 9/15; Winter 9/15 - 12/31. These dates can be changed in the conditional formatting rules for the DB tab.
8
Data validation rules ensure dates in column A are all Fridays.
9
Column B is computed from Column A and cannot be edited directly.
10
Column H is populated by the Apps Script code and cannot be edited directly.
11
When you are finished making changes to the DB tab, click PLRG Calendar > Update Calendar Events from the menu bar. This will run Apps Script code to fill in the event descriptions for all of the PLRG calendar events in the PLSE calendar. If you do not have the right permissions to run the script, contact Anjali.
12
13
The Candidates tab tracks the list of papers we may want to read in PLRG. Anyone can add papers to this list, but please add your name in the "Proposer" column and a short pitch for why it would be a good paper for PLRG in the "Pitch" column.
14
Conditional formatting rules will automatically color the row gray if the paper appears in the DB tab (that is, the paper has been read by PLRG already). The date the paper was read is shown in Column B.
15
16
The PLRG Schedule tab shows the PLRG schedule for a given quarter, computed from the DB tab. Change the view by changing the quarter/year in the dropdown menus. No other changes to this sheet are permitted.
17
18
If you encounter any issues with this sheet, or have comments/suggestions/feedback/ideas, please contact Anjali.
19
Last Updated: 9/24/2025
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