Hello,
I am new to this forum, and I have a couple of questions about the attached spreadsheet I am working on for employee ratings.
Essentially what the sheet is doing is taking each day of the month (each month being a tab), and having 3 supervisors rate each employee that worked that day (3 rows each day, averages per row and per supervisor for each employee; total each day as bottom rows of sheet, and average for the month on the far right of sheet).
The math I haven't done yet for the Monthly Average for each employee as I first need to ensure that I can make the supervisor selection per day not overlap (ie Day 1 cannot have K as column C and E; K can only be selected once per day at maximum).
That is my conundrum, I have tried a couple of sites such as http://www.excelforum.com/attachment...7&d=1329498021 & http://www.contextures.com/xlDataVal03.html; but I don't think these totally fulfill my requirement (these are more for a single sheet using a single list once); whereas I need multiple sheets with multiple days each sheet using the same list and validating independently against it each time for the 3 selections each day.
This is my first problem.
Second I mentioned briefly above, at the end of the month (far right) I have the Monthly Average which I need to be able to dynamically calculate based on each Supervisor's initial for each day what their scores were for that employee. I think I could potentially use a macro based on color (as I have conditional formatted all columns to different colors based on supervisor selection) but that has not always turned out well for me, especially using so many columns dynamically though that is an option. The other is using the initial itself. I haven't really gotten to this part yet, but short of a nested if for each column for each initial I'd have to find another way to validate the column value dynamically. Any help here is greatly appreciated.
You can check the other sheets, I did a pretty basic way to grab the average for each criteria for each supervisor; this is all thrown out the window and why the values of these cells are blank (for the first employee).
I only have 3 months right now (old sheet, started in August) and the September/October are an older version; which I'll correct once I get August right. The only difference with the other sheets is the Last Month Comparison which is simple enough once I get August up and running.
Bookmarks