ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
INSTRUCTIONS: Before you do anything, please download this spreadsheet. You can download from the top left of your screen under "File." You cannot modify this original document.

This calculator is meant to be a useful tool to help employees understand where they are projected to be on the new state pay plan as of July 1, 2023 and July 1, 2024. In no way is this document a guarantee of an employee's income at those times.

Please only type into the GRAY cells with the employee's information. All other cells (i.e., the BLUE and YELLOW cells) will be auto-populated based on the formulas.
3
4
5
6
7
8
9
10
11
Inputs
12
Job classificationADMIN ASSISTANT IIIUse the dropdown to select the appropriate job classification.
13
Employee's current monthly pay$5,000.00Note: You can find your job series in the "Job Series for Placement" sheet. Be sure to count years from when you started in that job series to July 1, 2024.
14
Employee's years in current job series as of July 1, 20247
15
16
July 1, 2023
17
New monthly minimum in pay plan$4,033
18
Result$5,250
19
Result explanationYou are projected to get a 5% ATB raise on top of your current pay.
20
Percent change from current monthly pay5.0%
21
22
July 1, 2024
23
New monthly minimum in pay plan$4,154
24
Minimum for employee's matching step$4,580
25
Closest step5
26
Result$5,408
27
Result explanationYou are projected to get a 3% ATB raise, because you already make more than the 5-year step minimum.
28
Percent change from current monthly pay8.2%
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