Friday, February 25, 2011

yogi_Form CheckBox Questions Split Into Own Columns

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

emitsignal said ...
I am collecting registration details from schools participating in my charitable programme so I can match them. They're asked to select as many options as apply to them, but the results end up aggregated into single cells. Although these are comma delimited so I can split them in Excel, they end up spread across different columns which makes it impossible to sort meaningfully so I can match the schools properly. 
I have assumed there are 5 CheckBoxes for each question
I have used the following layout from Andre (ahab)'s fine solution posted to emitsignal's question in Google Docs Help Forum. I had a little play with it and I present my following solution:

update May-23-2011
I have added a scoring scheme as shown in sheet named TestScoresForYandNresponses
whrere both Y and N responses are assigned a score as shown in cells C4 and C6
and Test Scores for submittals are shown in column I