In another thread, people starting talking about criteria/factors they consider for rating courses. They were then talking about how they weight each of their criteria/factors.
Ever since I started reviewing courses in 2012, I have used a spreadsheet with a similar list of factors and differing weights to try and stay objective in my course ratings. I've made a more user friendly copy of my spreadsheet if anyone wants to do something similar but doesn't want/isn't able to set up a spreadsheet of their own.
Step 1: Open this link to make a copy of the spreadsheet
Course Rating Spreadsheet
Step 2: ONLY CHANGE THE ORANGE CELLS In the factors tab enter the factors that you want to consider in column A, and their weighting (how important they are to you) in column B.
(note: The ones that are currently there that have weights that aren't 0 are the factors I use, the ones with a weight of 0 are ones I think a decent number of other reviewers consider. Feel free to delete/modify any of these factors, just make sure to put the weight to 0 for any you don't want to use)
Step 3: Navigate to the "Rating Entry" tab. You should see a list of your factors and their weights in columns A and B (if you want to modify them, do so in the factors tab, not this one). I have entered 3 example courses in columns E, G, and I. Change cell E2 to whatever course you want to rate, and rank each of your factors from 0-10 E3 and going down (the orange cells below the course name). The rating will show up in E1, directly above the course name. Continue to the right to add more courses.
I've been bullet pointing what I think are among the most important criteria for years criteria for a while:
Variety
Elevation
Challenge
Aesthetics
Memorable/unique holes
Equipment
Nav and routing
Fun factor
I think that list nails it ! Now what order would you put them in, assuming they are not weighted equally ?
Ever since I started reviewing courses in 2012, I have used a spreadsheet with a similar list of factors and differing weights to try and stay objective in my course ratings. I've made a more user friendly copy of my spreadsheet if anyone wants to do something similar but doesn't want/isn't able to set up a spreadsheet of their own.
Step 1: Open this link to make a copy of the spreadsheet
Course Rating Spreadsheet
Step 2: ONLY CHANGE THE ORANGE CELLS In the factors tab enter the factors that you want to consider in column A, and their weighting (how important they are to you) in column B.
(note: The ones that are currently there that have weights that aren't 0 are the factors I use, the ones with a weight of 0 are ones I think a decent number of other reviewers consider. Feel free to delete/modify any of these factors, just make sure to put the weight to 0 for any you don't want to use)
Step 3: Navigate to the "Rating Entry" tab. You should see a list of your factors and their weights in columns A and B (if you want to modify them, do so in the factors tab, not this one). I have entered 3 example courses in columns E, G, and I. Change cell E2 to whatever course you want to rate, and rank each of your factors from 0-10 E3 and going down (the orange cells below the course name). The rating will show up in E1, directly above the course name. Continue to the right to add more courses.