Dear Sir,
My name is Pratik Sarwadnya. I also want to calculate ESI, but I cannot understand how to calculate it. Specifically, I cannot understand the formula: (total number of responses of 5 * 5) + (total number of responses of 4 * 4) + (total number of responses of 3 * 3) + (total number of responses of 2 * 2) + (total number of responses of 1 * 1). What does the star mark indicate? Is it for multiplication?
Another query I have is regarding "TOTAL (pt. d) * 5." Could you please explain what "pt. d" refers to?
Regards,
Pratik Sarwadnya
sarwadnya.pratik@yahoo.in
From India
Acknowledge(0)
Amend(0)
1My name is Pratik Sarwadnya. I also want to calculate ESI, but I cannot understand how to calculate it. Specifically, I cannot understand the formula: (total number of responses of 5 * 5) + (total number of responses of 4 * 4) + (total number of responses of 3 * 3) + (total number of responses of 2 * 2) + (total number of responses of 1 * 1). What does the star mark indicate? Is it for multiplication?
Another query I have is regarding "TOTAL (pt. d) * 5." Could you please explain what "pt. d" refers to?
Regards,
Pratik Sarwadnya
sarwadnya.pratik@yahoo.in
From India
Acknowledge(0)Amend(0)
Dear Pratik,
Please download the Excel table attached by Autumn Jane. I am sure the table clearly explains what is done. You are correct, the asterisk sign in 5*5 represents multiplication. By clicking on different cells in the table, it will show you what has been done.
From United Kingdom
Acknowledge(0)Amend(0)
Please download the Excel table attached by Autumn Jane. I am sure the table clearly explains what is done. You are correct, the asterisk sign in 5*5 represents multiplication. By clicking on different cells in the table, it will show you what has been done.
From United Kingdom
Acknowledge(0)Amend(0)
Dear PARI.NERURKAR,
Please explain to me the Excel sheet calculation attached here. I didn't understand the numbers mentioned corresponding to each question. Usually, employees will tick on the appropriate columns to show their satisfaction level. For example, for the first question, if they strongly agree, then they will tick on the 1st column, and the points should be four. However, in the first column, it is mentioned as 1. What is the rating for that particular question?
Binoy M George (binoy.mgeorge@gmail.com)
From United%20Arab%20Emirates, Sharjah
Acknowledge(0)Amend(0)
Please explain to me the Excel sheet calculation attached here. I didn't understand the numbers mentioned corresponding to each question. Usually, employees will tick on the appropriate columns to show their satisfaction level. For example, for the first question, if they strongly agree, then they will tick on the 1st column, and the points should be four. However, in the first column, it is mentioned as 1. What is the rating for that particular question?
Binoy M George (binoy.mgeorge@gmail.com)
From United%20Arab%20Emirates, Sharjah
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Employee Appraisal Form new.doc