ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Method to calculate FTE for contract staff based on contract amount and average pay
2
3
Total contract amount in dollars
4
Average hourly pay
5
Estimated total hours worked#DIV/0!
6
Estimated regular year FTE staff for year (1 FTE = 2080 hours)#DIV/0!
7
8
Note - fill in yellow cells with correct estimates.
9
This spreadsheet is read only for users. Please make a your own copy (under File menu \ Make a Copy) and edit your copy to populate.
10
11
12
13
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