I have a Google form that has multiple choice answers. I want to score the document (the spreadsheet that is generated) by giving each answer a numerical value (not just right or wrong, but answer A=1 point, answer B is 2 points, etc) , then take the total and multiply by 4 (this will bring the range of the answers from 24-120, but because of the particular questions, the totals will rarely be above 100.
What is the distance from your house to event?
A. 40+ Miles
B. <40 Miles
C. <20 Miles
D. <10 Miles
E. At Home!
In this case, "At Home!" would be the most valuable answer (5 points), and the answer choice "40+ Miles" would be least valuable (1 point).
The order of the answer choices does not matter; it's not a test, just a way of formulating "value" to a situation.
There are a total of 6 questions as of now, and 2 of those questions are irrelevant to the scoring
There are 5 answer choices for every question. Instead of getting a total and multiplying by the values of the answer could also be in increments of 4 if it makes formulating easier.