Dav -

Thanks Again.

I see your points about the need for a new logic if we go to fixed
monthly amounts rather than a fixed monthly rate. I've heard rumblings
from some of the big bosses at my company that they wanted to offer a
static monthly goal so that there isn't the dollar fluctuation. But I
don't think they've thought it through that the fluctuation is a
natural derivation from the differences in the '05 actuals vs '06
Budgets. Such a plan would value performance in an inconsistent way
unless the budget vs prior year actuals were exactly the same each
month.

Personally, I prefer the first version you built. I tried it out on
several current plans and it worked perfectly. I've found now that a
few people were overpaid using the pre-Dav formulas.

If you're ever out in Los Angeles, I owe you a beer!

Cheers,
Derek


--
derekblain
------------------------------------------------------------------------
derekblain's Profile: http://www.excelforum.com/member.php...o&userid=37171
View this thread: http://www.excelforum.com/showthread...hreadid=569657