Create a Compelling Scorecard for tracking activities in Excel

• Status: Closed
• Prize: $110
• Entries Received: 14
• Winner: nymengr

Winner

Contest Brief

I need a scorecard created in excel that I can use when tracking activities that are critical to achieving a goal. An example tracking sales calls.

For 1 year Monday through Friday I want to visit 10 new locations per day.
50 being the goal compared to how many I did.
Measured daily using colors and graphs to make it visually pleasing and compelling to look at. This data must be able to be tract for at least 1 year, but have the option to make it as little as one month. I need this to be as flexible as possible.
I want something were 1, 2 or 3 activities can be tracked and reported on the same page. I am OK if the data is input on one sheet and the compelling scores are on another. I must be able to see the grafts and score tracked both weekly monthly and for the entirety of the assigned goal dates.

The most important thing to me is how compelling the scoreboard looks. It must be eye catching or even fun to look at.

Recommended Skills

• Data Processing
• Excel