Group Study Room Reservation "plug-in"

	A	B	C	D	E	F	G	H	J	K	L
1	RULES FOR ROOM USE:		- FOR RESIDENTS AND PAID MEMBERSHIP PATRONS - AGES 13+ CAN MAKE A RESERVATION - UP TO 2 DAYS IN ADVANCE - 8 PERSONS MAXIMUM IN ROOM - PERSON MAKING THE RESERVATION MUST BE PRESENT DURING THE APPOINTMENT - ROOM IS ONLY "HELD" FOR 15 MINUTES AFTER APPOINTMENT TIME (UNLESS CONTACTED BY PATRON), THEN CANCELED - NO WAITLIST - NO CANCELATIONS ARE RECORDED, DELETE INFO WITHIN ROW - ONE RESERVATION = ONE BLOCK (NO MULTIPLE HOLDS IN SINGLE DAY) - PLEASE CALL OR COME IN TO CANCEL OR AMEND RESERVATIONS: 512 - 401 - 5608
2	SATURDAY 9AM - 5PM	12/30/2023	START	END	PATRON NAME	CPPL NUMBER	STAFF INITIALS	NOTES	INSTRUCTIONS	1
3									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is SATURDAY Can reserve through MONDAY
4			10:00:00 AM	12:00:00 PM	Eric Yi	1124621	el				2
5
6
7
8
9
10
11
12	SUNDAY 1PM - 6PM	12/31/2023	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS	1
13									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is SUNDAY Can reserve through TUESDAY
14			1:00:00 PM	3:00:00 PM	Felanie Ainsworth	1126995	jl				2
15
16
17
18
19
20			5:00:00 PM	6:00:00 PM	CLOSED	HOLIDAY
21
22	MONDAY 9AM - 9PM	1/1/2024	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS
23									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is MONDAY Can reserve through WEDNESDAY
24
25
26
27					CLOSED	HOLIDAY
28
29
30
31
32	TUESDAY 9AM - 9PM	1/2/2024	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS	2
33									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is TUESDAY Can reserve through THURSDAY
34			10:00:00 AM	12:00:00 PM	Eric Yi	1124621	ARP				2
35
36
37			2:00:00 PM	4:00:00 PM	Daniel Flood	1119744	ARP				2
38
39
40
41
42	WEDNESDAY 9AM - 9PM	1/3/2024	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS	3
43			9:30:00 AM	11:00:00 AM	Jeanette Gieske	9962167	jl		Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is WEDNESDAY Can reserve through FRIDAY		1.5
44
45
46			1:00:00 PM	6:00:00 PM	HCCM
47											5
48
49			4:30:00 PM	6:30:00 PM	Shan Savalia	1126900		pulled from online report			2
50
51											8.5
52	THURSDAY 9AM - 9PM	1/4/2024	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS
53									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is THURSDAY Can reserve through SATURDAY
54
55
56
57
58
59
60
61
62	FRIDAY 9AM - 5PM	1/5/2024	START	END	NAME	CPPL NUMBER	INITIALS	NOTES	INSTRUCTIONS
63									Make reservations in 15-minute blocks :00, :15, :30, :45 MIN: 15 minutes \| MAX: 3 hours Today is FRIDAY Can reserve through SUNDAY
64			10:00 AM	12:00:00 PM	Eric Yi	1124621	mg	already in online report
65
66
67
68
69
70
71
72
73	Instructions for GSR Sheet upkeep:								Note:
74		- Make PDF of schedule at end of week							At the end of the Fiscal Year, make the new FY tab for Group Study Room Usage.XLSX and new FY spreadsheet for FY23_Further Stats GSR.XLSX
75			Highlight C2 - H71 and choose the following settings: Font: Nunito, Font size: 12, Bold, Horizontal alignment: Center, Vertical alignment: Center, Text Wrapping: Wrap. This is to ensure that all text entered is visible and the format is consistent.
76			Save the completed week's "current sheet" as a PDF with the naming convention MM.DD.YY-MM.DD.YY
77			Save to T:\Library\Info Desk\Study Room\Google Sheet Room Reservations
78		- Add reservation totals to CPPL Google Sheet \| Group Study Room Usage.XLSX
79		- Add reservation data to CPPL Google Sheet \| FY23_Further Stats GSR.XLSX
80		- Update dates on "ORIGINAL TEMPLATE"
81			Duplicate "ORIGINAL TEMPLATE"
82			Name duplicate M/D/YY-M/D/YY
83			Add closures and block out HCCM times in new copy for the upcoming week
84		- Once all data has been recorded and updated, delete previous week's tab
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100