Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Productivity Log
Ok, I have a difficult scenario. I have all of these folks entering all the
work they have done throughout the week into a log. I then take their weekly report and input it into a scorecard. This is a very manual process and I have inherited it. Any suggestions on how to better automate this. Here are the steps I take. I have employee input the work they did throughout the week into a simple excel log like so: Hard Medium Easy ABC Inc 06/17/08 X ZZZ Inc 06/17/08 X CCC Inc 06/17/08 X Then each week, I take this information and manually input it to a seperate log which automatically calculates different scores based upon scoring of hard/easy etc. I then automatically rank them and the final report looks something like this. Score Rank Employee 1 195 1 Employee 2 130 2 Since we have over 50 employees doing this each week it is very manual. Any suggestions on automating this ? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Productivity | Excel Worksheet Functions | |||
Calculating productivity by time | Excel Worksheet Functions | |||
calculate a productivity percentage | New Users to Excel | |||
How do I make a productivity report? | Excel Worksheet Functions | |||
Quality/ Productivity diagram | Charts and Charting in Excel |