$1.$ Download the Template.

$2.$ Start on the first tab, $$Employee details$,$ and note that you have information about the jobs and salaries of fifteen employees. You will be coaching their manager on whether any of these employees requires a major pay increase this salary planning cycle.

$3.$ Move over to the second tab $$All employees with pay ranges$.$ This document shows pay range information for every single employee in the company, including the fifteen on the team you are advising.

$4.$ Move back to the $$employee details tab$.$ If you scroll over to the right, you$$ll see two blank columns, I and J$.$ Your goal is to find or calculate the information that goes in these columns.

$5.$ For column I, $$Pay Range Mid Point$,$ you will need to use information from the $$All employees with pay ranges$$ tab to find the pay range Mid point associated with each of your fifteen employees.

Be sure to use employee ID rather than name to look up this information.

If you are experienced with Excel$/$spreadsheet software or would like to learn something new, you can use a $$VLOOKUP$$ to do this very quickly. If you$$d like to learn about VLOOKUP, go here.

$6.$ After you have filled in the pay reference midpoint for each employee, find the comparative ratio $($compa$-$ratio$)$ for each.

The formula for this can be found in section $2$ of the resource documents $-$ these are the same as the documents provided in the previous step.

Again, you can calculate each by hand, or you can use a formula to move more quickly or challenge yourself.

$7.$ Now we must tell the manager who requires a raise. To do this, segment the comparative ratio values into three segments $($less than $80\%,$ between $80\%-100\%$ and greater than $100\%).$ Highlight those who are below $80\%$ and those who are between $80-100\%$ using two different colors.