skip to content
Primary navigation

Pay Equity Prep Spreadsheet

The information displayed in this worksheet is required to submit a pay equity report.  

Gather the data to create a report.  

Click on the column header for more information or refer to our Instructions for Completing Pay Equity Report (pdf)  (word version).

jobid  title males females points mins maxs yrmax yrsrv exsrv
1
 Box Office 1 1 110 1650 1854 4 0
2
 Stage Crew 6 1 130 1950 2191 5 0  LONGEVITY
3
 Props Chief 1 0 140 2100 2359 5 0  LONGEVITY
4
 Costume Designer 0 1 142 2130 2393 5 0
5
 Set Technician 1 0 150 2250 2528 5 0
6
 Lighting Technician 1 0 164 2460 2763 6 0
7
 Effects Engineer 1 0 179 2685 3016 6 0
8
 Stage Manager 0 1 180 2700 3033 5 0  LONGEVITY
9
 Writer 1 0 180 2700 3033 6 0
10
 Marketing Director 1 0 200 3000 3370 4 0
11
 Actor/Actress 10 12 217 3255 3656 4 0  PERFORMANCE
12
 Director 1 0 275 4125 4634 0 3
13
 Producer 0 1 260 3900 4381 0 1
14  General Manager 0 1 300 4500 5055 0 5

There are three ways reports can be entered in the Minnesota Pay Equity Management System

  1. Manually key in the data,
  2. Copy an existing report and make edits, 
  3. Upload an Excel spreadsheet

Additional information can be found in our System Access and Navigation Guide (pdf)  (word version)

back to top