look at the private dedicated newsgroup for the office scorecard
accelerator.

But, to resume... the complete formula is explained in the online help ;-)
http://localhost/sites/ScorecardDevelopment/_layouts/1033/Scorecard/dev_html/rollup_overview.htm

To resume, the score is evaluated by evaluating the position of the
normalized value into the bands. So, for example, if you have a 2 band
indicator with boundaries set like this:
0$ - 800 000$ - 1 000 000$

If your value is 500 000$ the score is not 50% but 31.25% (if there is no
error in my formula ;))
a score of 50% is 800K$ (which is exactly the middle band)

For the 500 K$ value --> you are in the first band
500 / 800 = 0.625 --> relative position of the value in the first band
Because you have 2 bands only each band = 50%
so...
50% * 0.625 = 31.25%

A value of 900K$ give you a score of 75%:
900K4 give you the second band.
(900 - 800) / (1000 - 800) = 100 / 200 = 0.5
50% * 0.5 = 25%
The lower band = 50% so the final score is:
50% (position of the lower band) + 25% (relative position in the band) = 75%

Well... read the only help, the re is beautyfull pictures !
:)

[quoted text, click to view]
Hi - did you ever get your answer to this? I'm trying to figure it out
as well.

Thanks,
Dean


[quoted text, click to view]