Hello Excel Forum users! I'm trying to create a simple Excel workbook to track productivity in my department and am not sure of the best way to do this. There are about twenty different functions we track on a time sheet and each function has a 3 - 4 letter code and an expected production rate to go along with it. As you can see in the screenshots I've attached(uploader wasn't cooperating when trying to post the actual workbook) that I currently have two sheets going: The first sheet has employee names and dates for axes and then the cell has data in the format 'DSO, 101.47' (DSO is a code referring to a specific function and the number is the average lines per hour produced by the associate). The second sheet is a reference page that has listed all the codes and their corresponding rates. I'd like for it to look at a cell, reference the 'codes and rates' sheet to grab the expected rate, and then use some conditional formatting to show whether the associate was below or above rate for the week.
I'm fairly flexible as how this workbook could be laid out, so if there's a simpler way then I could try that instead.
-Thanks!
Productivity_Tracker.xlsx
Bookmarks