ABCDEFIJKLMNOPQRSTUVWXYZ
1
Instructions:
2
Choose "Make a copy" from the File menu to enter your values. (Because this is a Google spreadsheet, not a web form, if we allowed you to enter your data here the next person to use the calculator would see your data.)
3
You'll need to be logged into your Google account to make a copy. If you don't have a Google account but do have Excel, choose "Download" from the File menu and download as an Excel file. As a last resort, the "Proposed salary schedule" tab also has the proposed salaries for every step and column, so you can look yourself up there as you would on the existing salary table.
4
As of right now this calculator reflects the AFT-2121 salary proposal made on May 4, 2021. We'll do our best to keep this copy of the calculator updated with any new proposals, or any changes as we become aware of them. But if you make a copy, your copy won't be updated—you'll have to come back and make a new copy.
5
For help with this calculator, reach out to clare.alice.heimer@gmail.com.
6
7
Enter your information here:Notes/instructions
8
Current columnFIf you're expecting a column change, this calculator won't show the effects directly—you can enter your current column to see your current salary, and your new column to see your new salary, but you can't see both at once.
9
Current step6Enter the step you're in now (in academic year 2020-21). You'll enter below whether you're expecting a step increase.
10
Number of units taught/semester6Enter 15 for FT. For PT, enter your workload in units, not hours or FTE. This calculator can help.
11
Pro-rata %86%Part-time instructional faculty's pro-rata percentage is almost always 86%; full-time faculty, and part-time counselors or librarians, should use 100%.
12
Step increase next year? y/nNIf you're expecting a step increase in Fall semester, enter Y. If you're expecting a step increase in January, your salary will change midyear. You can use this calculator twice, once for Fall semester (no step increase) and once for Spring (step increase). Take 0.5 of each result and add them together.
13
14
Effects on you:
15
Per unitPer semesterPer year
16
Current salary$2,271.83$13,631.00$27,262.00
17
Expectation for next year under current CBA$2,271.83$13,631.00$27,262.00
18
Proposed salary$2,068.53$12,411.18$24,822.35
19
% change from this year to next under AFT proposal-8.95%-8.95%-8.95%
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