#query {background: #ebf5fd; color: #4f4f4f; letter-spacing: 1px; padding: 5px; border: 1px #001b31 solid; text-indent: 3%; font-size: small;} form#search_query { color: #FDFCFB; text-align: left; margin: 0px; }
V.Raghunathan
Process Industry Consultant / Soft Skill
Executive Human Resource At Emcure Pharmaceuticals
V.B.Patil
Hr Professional
Nashbramhall
Learning & Teaching Fellow (retired)

Dear Seniors,
I would like to know how to use weightage method with rating scale in performance appraisal ?
And How to use BEll Curve in Performance Appraisal , I would be greatly appreciate if someone share the excel sheet for this.
Thanks in anticipation.
Regards,
Manpreet
11th January 2014 From India, Delhi
Dear Manpreet, Please find the attached Bell Curve sheet for you ready reference.
11th January 2014 From India, Kolhapur

Attached Files
 Membership is required for download. Create An Account First Bell Curve.xls (23.0 KB, 3080 views)

Dear Mr Vinayak Patil,

You have presented a simple, yet very effective Bell Curve.

I am sure many would stand to get benefitted by it.

One possibility extends to cover the STAR performers separately.

In this, 3,3 category opens up a new column( column F as per your attached Xl).

The total commitment to the Management will be limited to the 5% for Column F

Consequently the allotted percentages in D & E

(OR even in B,C,D,E )would stand reduced accordingly.

The changes as above would provide a perfect Normal Distribution curve theoretically.

Practically this would be useful to retain the STAR performers as they stand out

from the rest. The Management would be very happy to retain them.

I have one more suggestion to consider the following values for the given Bell Curve.

Column D -- 50 to 60 %.

Column E -- 15 to 20 %.

This would ensure that in the event of Management sanctioning Maximum as proposed,

then the total would add to 100% considering Maximum in all the four.

thank you again for your excellent post,

V.Raghunathan
11th January 2014 From India
Dear Sir,
Humbly I would like to inform you that, the attached bell curve sheet was not prepared by me. Sorry, I did not mention the source while uploading the same, the source was internet itself.
I used the same in my organization so, shared for ready reference & thanks for your valuable suggestion.
11th January 2014 From India, Kolhapur
Your request would sound better if reworded as follows. "Please could some one explain to me how the ratings 1.1,1.2 etc. are developed?"
15th January 2014 From United Kingdom
It is based on marks obtained.
Example classification is as below:
20-40=4=Needs Improvement
40-60=3=Average
60-80=2=Good
80-100=1=Very Good
40=3
41=3.05
42=3.1
43=3.15
44=3.2
45=3.25
46=3.3
47=3.35
48=3.4
49=3.45
50=3.5
51=3.55
52=3.6
53=3.65
54=3.7
55=3.75
56=3.8
57=3.85
58=3.9
59=3.95
Please correct me if I have done it in wrong way.
7th June 2014 From India, Mumbai
please find attached snip for PMS Ranking example.
7th June 2014 From India, Mumbai

Attached Images
 Membership is required for download. Create An Account First PMS Ranking.JPG (23.5 KB, 551 views)

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)