yogi_Compute Row By Row Score 0 for 'a' 1 for 'b' 2 for 'c' And Total Score In Header Row

                                           Google Spreadsheet   Post  #1942
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr-11, 2015
question by mos Bas:

https://productforums.google.com/forum/utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/xGmQTxAvEeE

i want to calibrate answers

I am a psychiatrist and I am building a questionnaire which is a MCQ style, in which the responder will choose one of 4 answers, and each choice will have a score

(e.g: for the same question if responder chooses number a answer he will take 0,

 if he choses number b answer he will take 1 score,

if he choose number c answer he will take 2 points and so on )

 and according to his score he will be graded to either mild moderate or sever illness,

 the problem is when I use flubaroo it does not allow me to do this, I can give point scoring to only one single choice

thanks alot

---

Dear Mr Houdini

thanks a lot for your kindness, I tried to share it with you but I couldn't because I must have your e-mail address

an example of questions is like this

1) Do you feel depressed

     a- a little           (this answer should receive score=0)

     b- average         (this answer should receive score=1)

     c- a lot               (this answer should receive score=2)

2) Do you feel fatigued

     a- a little           (this answer should receive score=0)

     b- average         (this answer should receive score=1)

     c- a lot               (this answer should receive score=2)

then we shall add the score

I am very grateful to your kind help

------------------------------------------------------------------------------------------------------------------------------