Forum Discussion
Excel Capability Question
We are being asked to build something in Excel that can look at the overall population of a specific store and compare the scores for that store to a goal. If the score is below the goal, the store ...
Thanks for the response. I was able to get a bit more information. I hope this helps to determine if it can be done in Excel.
Several thousand locations (each identified by a unique number) will be scored each week for their performance against 11 different areas of focus to determine how they are doing for that specific subject (for example scanning accuracy rate, etc).
Each location has a target score for each Area of Focus that they need to meet for the week. Targets are dependent on the actual Area of Focus and may not be the same for multiple areas.
We are wondering if Excel can look at the 11 Area of Focus scores for a location each week and compare each score to its target. If a location is below target on a specific Area of Focus, Excel would display that information for the location.
The location would then be required to go into further training lasting anywhere from two to six weeks so that they can bring that Area of Focus score up. We would be tracking the further training as well through the weekly scores.
The overall score determines which one of 11 learning paths that store must take to improve a specific Area of Focus score.
Several thousand locations (each identified by a unique number) will be scored each week for their performance against 11 different areas of focus to determine how they are doing for that specific subject (for example scanning accuracy rate, etc).
Each location has a target score for each Area of Focus that they need to meet for the week. Targets are dependent on the actual Area of Focus and may not be the same for multiple areas.
We are wondering if Excel can look at the 11 Area of Focus scores for a location each week and compare each score to its target. If a location is below target on a specific Area of Focus, Excel would display that information for the location.
The location would then be required to go into further training lasting anywhere from two to six weeks so that they can bring that Area of Focus score up. We would be tracking the further training as well through the weekly scores.
The overall score determines which one of 11 learning paths that store must take to improve a specific Area of Focus score.
There is no doubt in my mind that this could be done. I suspect the Excel side of it is the easy part....getting all the data and organizing it will be the challenge. But it sounds like you're a large enough organization that the challenge will be readily met.
The kind of comparison of a score against a standard, comparing two values (to be more generic) is very basic Excel.
You said you've got experienced Excel users, so this should be right up their respective alleys.
- Thank you for the response. They are quite experienced and I will have them dig into Excel.