Score calculation based on weightage given & achieved kpi

[Suresh Badhani]

How we can give a score based on weightage as weightage and achieved score known for different kpi as mentioned

 

[vletm]

Suresh Badhani
Have You test to write to cell N8 =E8*E$3/E$2 and copy down as well as right?

 

[Peter Bartholomew]

How do you wish to report employees that exceed targets? Are percentages greater than 100% OK? The attached is built from array formulas because that is the default I use, but one version of the formula uses 365 functionality that was only released today.

= MMULT(Score,TRANSPOSE(weight))

or

= BYROW(weight*achieved/target, SUMλ)
where SUMλ is defined to be
= LAMBDA(x, SUM(x))

 

[Suresh Badhani]

Here some condition as
Login hrs <=8:00 then
Attrition <=7% then
Same shrinkage, shift adherence, abandon
And
Quilty >=85% then
Aht >=240 then

 

[Suresh Badhani]

Suresh Badhani
Have You test to write to cell N8 =E8*E$3/E$2 and copy down as well as right?

Here some condition as
Login hrs <=8:00 then
Attrition <=7% then
Same shrinkage, shift adherence, abandon
And
Quilty >=85% then
Aht >=240 then

 

[vletm]

Suresh Badhani
You pasted two times same 'some conditions' for some reason.
Did You test my solution?

 

[Suresh Badhani]

Thanks for sharing and reply I checked in all there total points sum comming more then 100
So why this can ok.