Percentages achieved by threshold

[Nubian]

Hi,

I need a formula to work out % of improvement achieved based on actual verse 5 thresholds of improvement brackets.

I've attached a spreadsheet with an example of what I require. Thanks

[FDibbins]

could you give some idea on how you arrived at the values in I and J please?

[Nubian]

Hi Fdibbins,

I made column C's score meet the top end of some of the thresholds.

C3 does not meet any
C4 matches high end of D4
C5 matches high end of F5
C6 top achievement and matches H6

Line 1 D:H shows the percentage achieved bracket if they fall between any scores D3:H6

[Nubian]

Hi, I'll try give more detail.

It's a measurement of Improvement.

Column B shows the previous years score. for information
Column C is the score in current year

I have listed 4 plans of improvement each having a target to meet with the target with a percentage of improvement bracket, depending on which target they meet i'd like the corresponding percentage bracket shown as the score. Column J formula is not necessary I added J just to show correlation between improvement bracket.

So if
Tier 1 scores -7.3 it meets none of the targets and gets 0% improvement
Tier 2 scores 1.0 it meets the top end of the minimal improvement bracket scoring 54% improvement

Let me know if you need anything further please