Chris,
Using your ideas and changing a few things around I seem to have arrived at
a solution.
If you would like see what I came up with, you should be able to download it
he
http://www.mediafire.com/?sharekey=8...e6ba49b5870170
Thanks again for the push in an easier direction.
If you see anything that can be improved, or if Im trying to do something
doofus-like, please feel free to point it out.
smartin,
Thanks for the thoughtful comments.
It helped to push me in a direction that should allow for an easier way to
add the ability to track more bonus levels and even the possibility of a
carryover count to the next chart.
28 day streaks are exceedingly rare, and longer streaks even more so.
Fortunately, The-Bonus-Dude (Dude-ette actually) makes a significantly big
deal out of a long A series, so keeping track of the max in a long A
streak should suffice to determine an employees super bonus.
If in the future, the number of A streaks that go longer than 28 and then
beyond the next number, say 35, increases by a reasonable amount (more than
the 2 or 3 that we have now) then I think it will be fairly easy to add a
counter for that new number.
For our use, we would not reset after 28, because each successive bonus
increases in value, so we want to keep track of how long a series continues.
Perhaps in the future we will need to add more levels of bonus to the five
(7, 14, 21, 28, and max) that we already have.
Who knows, maybe this spreadsheet will make it easier to see what amount of
bonuses are being paid out and our whole bonus program will change.
"smartin" wrote:
Good Stuff, Chris!
Please don't take this as a criticism, just an observation...
The only thing that seems to be lacking--and something the OP doesn't
address--is what should happen when an employee has a long winning
streak. E.g., if an employee has straight "A"s for 99 days, they earn
the 28 day bonus, but nothing thereafter.
It might make sense if a 28 day bonus should also reset the counters,
but the OP should provide direction on this.