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.

Example:

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).

Misc Notes:

1. The order of the answer choices does not matter; it's not a test, just a way of formulating "value" to a situation.

2. There are a total of 6 questions as of now, and 2 of those questions are irrelevant to the scoring

3. 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.