Directions for the September 2002 Pay Raise Spreadsheet

Pay Raise Spreadsheet - This is an Excel file. You must use Internet Explorer as your web browser and have Microsoft Excel loaded on your computer for the spreadsheet to work.

Directions to Use the Pay Raise Spreadsheet

Full-time unit members who will be in the unit on September 29, 2002, can use the September Pay Raise Spreadsheet to calculate their expected pay increase effective that date.

Please consult Article XIIIA of the contract for specific definitions of the factors used in the Minimum Salary Formula (below). All such information is subject to verification and all projections calculated through use of this Spreadsheet are approximate. Some raises are contingent upon "satisfactory performance" by the unit member under Article VIII, Section O, of the current Agreement.

To use the Pay Raise Spreadsheet, you must enter the five following pieces of information in the appropriate cell shaded in blue:

Academic Rank: Enter your academic rank as of September 1, 2002, exactly as follows:

Professor: Professor
Senior Librarian: Senior Lib
Associate Professor: Associate
Librarian: Librarian
Assistant Professor: Assistant
Associate Librarian: Assoc Lib

Members who hold an academic rank not listed above should leave the cell blank.

Years of Full-Time Teaching Experience: As of September 1, 2002, add up all of your years of full-time college/university teaching experience, including those full-time years prior to hire at both four-year and two- year institutions and, for education professors, full-time years of K-12 teaching prior to hire, as well as your full-time state college service from your date of hire to September 1, 2002. A semester is equal to 0.5 years of experience. Librarians should use the total number of years of full-time professional experience prior to hire as well as state college service. Enter the total number of years in this cell.

Terminal Degree: Enter Yes if you held a terminal degree or its contractual Equivalent on September 1, 2002. Leave the cell blank if you do not.

Years of Full-Time Professional Experience: Enter the number of years of appropriate full-time professional experience you had prior to your date of hire in the state college system.

Annual Salary on September 28, 2002: Enter your annual salary as it was on September 28, 2002. You can calculate this figure by multiplying by 26 the Gross Pay from your Pay Advice for September 13, 2002. You can also the Gross Pay for other periods since May, 2002, if and only if you were not promoted effective September 1, 2002.

 

 

9/23/02