- ocfoaAsked on June 11, 2012 at 05:02 PM
I'm creating a sample performance evaluation form for football officials. We want to use terms like "Exceeds Expectations", "Meets Expectations" and "Needs Improvement" for 4 different areas of performance. The matrix works really well for this. At the end of the season, we want to be able to tally the overall score for each official and average the rating. We'd like to have a numeric value associated with each rating. 3 pts for "Exceeds Expectations", 2 pts for "Meets Expectations" and 1 pt for "Needs Improvement". These points will be averaged over the total number of evalutions that the official received for the season. For instance if an official is rated 3 times and his total score is 30, his average score will be 2.5 (30 divided by 3 divided by 4). We can do the averaging using the Excel export and using an Excel function but we need to have a field that carries that numeric value. Any suggestions?
- JotForm SupportjonathanAnswered on June 11, 2012 at 06:33 PM
I am not sure if this can be useful on your end, but I tried it on mine and using Excel report, -- I can get the "equivalent" numerical value for the evaluation answer using the excel formulas.
I have it like this:
=IF(J2="Exceeds Expectations",3,IF(J2="Meets Expectations",2,IF(J2="Needs Improvement",1)))
"J2" was the cell that refer to "Referee Evaluation" 1st question... I just expanded the formula on the excel sheet and changed "J2" into the appropriate cell address(eval question)
Hope this help in anyway.
I will try also on google spreadsheet integration if the same formula will work.
Please inform us if this is not what you need.
- JotForm SupportjonathanAnswered on June 11, 2012 at 07:26 PM
The formula will also work if applied to a form integrated to google spreadsheet.
- ocfoaAnswered on June 12, 2012 at 09:09 PM
Jonathan, thank you for the quick response. I'm still revising the format of the evaluation, I will give this a try as soon as I've got it somewhat solidified. Looking at your solution, I don't see why it wouldn't work, I will post an update as soon as possible.