formula to measure employee performance

[vinod9111]

Hi All,

Can anybody help me with a formula to measure employee performance.

Our department job is to prepare reports , so some reports have frequency , it means the submission of reports are daily/weekly in nature. While others are huge data based which is time consuming. Few are critical in nature as it involves financial implications on wrong reporting.

Looking for a formula which can measure volume, huge data working, criticality as well as negative marks for wrong submission. Something which can meet all these parameters.

I know my expectations is bit weird, would appreciate any help on this.

regards,
Vinod Krishna

 

[oldbrewer]

have a row with employee name, type of report, date due, date submitted, report quality
then columns with on time submission yes/no etc etc


then use sumproduct

 

[SpillerBD]

What are you going to measure?
and How are you going to measure?
My go-to methodology is Pivot Tables, but depending on the how, you may need PowerPivot (DAX) solution.
SUMPRODUCT can be easier, just remember that when you add employees or other similar items, you may need to add or modify your formulas.

In either case, if you have to manually maintain the data, you will be better off using a Table (Insert Table or CTRL+T) instead of a range. Also consider data-validation to ensure accuracy of data entry.

 

[vinod9111]

Thanks SpillerBD and Oldbrewer for your inputs. My data will be somewhat as given below. And I have to derive formula to provide appropriate scores for the returns handled by them. Some of the teams are handling critical returns and some high voluminous return. I want to give weightage to both the type of work and derive a feasible score formula.


[TABLE="width: 961"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Type of work[/TD]
[TD]employee[/TD]
[TD]Return Name[/TD]
[TD]Hours[/TD]
[TD]Frequency[/TD]
[TD]Critical*[/TD]
[TD]Resubmission**[/TD]
[TD]Scores[/TD]
[/TR]
[TR]
[TD]Regular[/TD]
[TD]A[/TD]
[TD]ABC return[/TD]
[TD]4[/TD]
[TD]Fortnighly[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Regular[/TD]
[TD]B[/TD]
[TD]XYZ return[/TD]
[TD]24[/TD]
[TD]Quarterly[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Regular[/TD]
[TD]C[/TD]
[TD]EFG Return[/TD]
[TD]8[/TD]
[TD]Monthly[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Regular[/TD]
[TD]E[/TD]
[TD]DFA return[/TD]
[TD]0.3[/TD]
[TD]Daily[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Adhoc[/TD]
[TD]D[/TD]
[TD]Misc[/TD]
[TD]0.15[/TD]
[TD]Adhoc[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 210"]
<colgroup><col></colgroup><tbody>[TR]
[TD]* financial implications[/TD]
[/TR]
[TR]
[TD]** due to error from data source[/TD]
[/TR]
[TR]
[TD]** due to operational errors[/TD]
[/TR]
</tbody>[/TABLE]

regards,
Vinod

 

[SpillerBD]

That makes up your "What"s, but now the How.
Hours? Is that the expected time required, or the actual time it took. Wouldn't performance be a difference of the two?
Weight? Which items will add weight to a score? You'll probably use a lookup table to transform text to numeric values.

You seem to very early in this project. Do not be too afraid to experiment with the calculations to get a single performance number, or maybe a split between cost vs benefit...?