UCF-Librarian-Workload-Analysis.xlsx

	A	B	C	G
1	Instructions
2
3		Overview
4	-	The intent of this inventory is to capture the annual percentage (%) of effort dedicated to functions performed by librarians at UCF Libraries.
5	-	The worksheet tab named "Data," included in this workbook, contains the areas/tasks for which you are being asked to assign a percentage of time.
6	-	Please only enter or modify data in yellow highlighted cells.
7		Instructions
8	-	Be sure to download this file and save it to your Onedrive. Before you begin filling out the form, rename the file and replace the text "BLANK" with your name (ex. UCF-Librarian-Workload-Analysis-AE-JohnSmith.xlsx). After completing the form, email it to your Unit Head for review.
9	-	Complete Name, Title and Team in the top section.
10	-	Estimate your annual effort for your position by entering percentages into Column C.
11	-	If a function is not applicable to your position, leave that row blank.
12	-	Use the "notes" section to provide information about work that may be seasonal, about volume levels of work, or to provide any other information you would like emphasized.
13	-	The list of pre-defined functions on the Data tab is meant to be exhaustive. However, if you need to enter effort for a function that is not listed, please utilize the "Other" line items at the bottom of each section, and include a clear description of this work in the Notes column.
14	-	When assigning a percentage of time, think about work on an annual basis (e.g. May 8, 2023 - May 7, 2024; or January 1 - December 31, 2023).
15		Different ways to calculate percent:
16			2 hours per week all year (2 hrs/40 hours)	5.0%
17			2 days per month all year (16 hrs/160 hours)	10.0%
18			1 day per week all year (8 hrs/40 hours)	20.0%
19			15 hours per week all year (15 hrs/40 hours)	37.5%
20			20 hours per year (20 hrs/2080 hrs)	1.0%
21	-	Up to one decimal place is allowed (ex. 11.5% or 0.5%)
22	-	The "Total Effort" number at the top of the survey (cell C6) should show 100.0% when you have completed the tool.
23
24
25
26		Credit:	This version of the workload analysis tool was created by Dean Beau Case and Associate Dean Thomas Caswell for UCF Libraries.
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