I have a basket of KPIs that my company is using. What I'd like to do is store the target/warning/alert values in some sort of spreadsheet. What I'm getting hung up on is how to structure such a spreadsheet.
Right now I've got something like this.
Location
Metric
Target
TimePeriod
CHUCKECHEESE
Popcorn Pay
$100
Weekly
But I also want to show the user Green/Yellow/Red coloring, which transforms my chart into this.
Location
Metric
Target
YellowPct
RedPct
TimePeriod
CHUCKECHEESE
Popcorn Pay
$100
120
150
Weekly
This is workable if the value is between the Target/Yellow/Red. But if it is on one side of the Target or Red, then we need to know which direction is "good".
So now my chart is:
Location
Metric
KPIDirection
Target
YellowPct
RedPct
TimePeriod
CHUCKECHEESE
Popcorn Pay
MIN
$100
120
150
Weekly
CHUCKECHEESE
Mouse Revenues
MAX
$250
80
60
Weekly
As you can see, my KPI Target document is getting out of hand. I was wondering how other people solve this problem, or if I'm just going to have to have lots and lots of columns. A simple template would go far in helping me materialize my vision.
