Saturday, April 11, 2015

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