Calculating the percent effective based on a set weight.

[J.W. Aldridge]

I am trying to rate the performance based on a predetermined
percentage weight.

Example:
Bob has a 7% quality rate
Tracy has a 8% quality rate.
Larry has a 9% quality rate.

This particular category has a 30% total weight.

(The other categories - [production etc.] adds up to 70% totaling 100%
effective).

Question:
With a goal of 8%, how do I figure their effectiveness based on a 30%
weight?
Since I'm dealing with quality, the lower the number the higher their
weight.

Example:
Bob has a 7% (cell A2) quality.
The goal is 8% (cell A1).
The weight is in A3, (30%).

HIs effectiveness should be 33.75% (higher than 30).

Larry has a 9% quality rate (cell B2).
The goal is 8%.(cell B1)
The weight is in B3, (30%).

His effectiveness should be less (something like %26.25)


any suggestions?

 

[Niek Otten]

I would have thought:

=A1/A2*A3

but that results in 34.29%. Is your 33.75% just a guess or can you tell us how you arrived at that figure?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to rate the performance based on a predetermined
| percentage weight.
|
| Example:
| Bob has a 7% quality rate
| Tracy has a 8% quality rate.
| Larry has a 9% quality rate.
|
| This particular category has a 30% total weight.
|
| (The other categories - [production etc.] adds up to 70% totaling 100%
| effective).
|
| Question:
| With a goal of 8%, how do I figure their effectiveness based on a 30%
| weight?
| Since I'm dealing with quality, the lower the number the higher their
| weight.
|
| Example:
| Bob has a 7% (cell A2) quality.
| The goal is 8% (cell A1).
| The weight is in A3, (30%).
|
| HIs effectiveness should be 33.75% (higher than 30).
|
| Larry has a 9% quality rate (cell B2).
| The goal is 8%.(cell B1)
| The weight is in B3, (30%).
|
| His effectiveness should be less (something like %26.25)
|
|
| any suggestions?

 

[J.W. Aldridge]

Thanx...

Sometimes, the simple stuff works.

(Spent all this time trying to re-invent the wheel)