ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Content Staffing Calculator
copyright ©
Content Company, Inc.
2
How to use this calculator
3
4
Figure out your tasks
5
Use the task calculator to list your organization's actual tasks over the complete content lifecycle. For more details on the content lifecycle, see my blog post on the content lifecycle: https://contentcompany.biz/blog/content-lifecycle/ and download my content lifecycle criteria worksheet: https://contentcompany.biz/blog/content-lifecycle-criteria-worksheet/
6
You'll want to do this both for new content and for content updates -- most organizations find that content updates require fewer tasks and less time
7
8
Identify the time each task takes
9
Share the task calculator sheets with the subject-matter experts/content creators in your organizations -- there are formulas built in to the sheets that should calculate the average length of time for each tasks
10
You'll want to do this both for new content and for content updates -- most organizations find that content updates require fewer tasks and less time
11
12
Adjust the names of content groupings and volume
13
On the staffing calculators, Row 1 lists "departments," which is the model for content creation in an association. In your organization, it might be "lines of business" (LOBs) or something else -- adjust as needed to reflect the groupings of people who create content
14
The first column in each grouping lists the content volume per year. Adjust that for each grouping. It's important to think about it on an annual basis, since it is intended to drive discussions and decisions for permanent annual staffing.
15
16
Work with subject-matter experts to identify the balance of work for each task:
How much of the work do subject-matter experts do, and how much does the web team do?
You may want to have the web team draft the numbers and vet them with SMEs.
17
There are formulas built in to the spreadsheet that calculate percentages and hours.
18
19
Compare the numbers by department/LOB and overall to your existing staffing model.
20
To translate hours into staff, use a round calculation that 2,000 hours equals a full-time employee (FTE): 40 hours per week, 50 hours per year
21
It is likely that you'll find the numbers, particularly the hours required for the web team, to be substantially higher than the current size of the web team.
22
23
If you find a discrepancy, discuss it!
24
25
26
27
28
If you have questions, please feel free to contact Hilary Marsh, the creator of this calculator: hilary@contentcompany.biz
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