Hello!
I've programmed in excel a lot questions (ie. 500) that use select_one
(and later the relevancy adds up the responses to move on/skip to other
questions). I'm trying to find a simple way to fix this without having to
re-do the whole thing using 'checklist' which looks more appropriate...
In my choices tab I used:
list_namenamelabelAlcohol_Response1YesAlcohol_Response0NoAlcohol_Response
UnknownUnknownAlcohol_ResponseRefusedRefusedAlcohol_ResponseNANot Applicable
Because I used words (e.g. Unknown/Refused/NA under the name column) it
won't add and skip properly (using relevant codes below) because they are
words, and not strings. Is there a value (e.g. -1) or something like it
that I can write in instead of those words? I know -1 just subtracts 1 from
the sum. I'm basically looking for a dummy variable, or placeholder
variable that won't interfere with the addition of the responses (ie. in
checklist, you can use -1).
Here is an example of the code that uses those responses:
(int(${Alcohol_Current_A11a})+int(${Alcohol_Current_A11b}))=1
or
selected(${Alcohol_Impact}, '1')
Any help would be appreciated, before I have to re-write many many formulas
I believe this was already answered on an earlier thread. There is no
function that tests whether a value is a string or integer value, so your
best approach is to change the 'unknown' to a numeric value and
conditionally detect and not sum that value in. See the earlier answer.
Sorry for your pain. The golden rule of software development is early
end-to-end walk-throughs ("early integration"), and that applies here --
whenever you start writing a survey, be sure to periodically test filling
it out and doing analysis on the resulting dataset. The earlier you debug
the end-to-end operations, even if only a portion of the form data is
asked, the earlier you will uncover problems with usability or data
analysis.
···
On Mon, Oct 27, 2014 at 2:07 PM, Amber Rieder wrote:
Hello!
I've programmed in excel a lot questions (ie. 500) that use select_one
(and later the relevancy adds up the responses to move on/skip to other
questions). I'm trying to find a simple way to fix this without having to
re-do the whole thing using 'checklist' which looks more appropriate...
In my choices tab I used:
list_namenamelabelAlcohol_Response1YesAlcohol_Response0NoAlcohol_Response
UnknownUnknownAlcohol_ResponseRefusedRefusedAlcohol_ResponseNANot
Applicable
Because I used words (e.g. Unknown/Refused/NA under the name column) it
won't add and skip properly (using relevant codes below) because they are
words, and not strings. Is there a value (e.g. -1) or something like it
that I can write in instead of those words? I know -1 just subtracts 1 from
the sum. I'm basically looking for a dummy variable, or placeholder
variable that won't interfere with the addition of the responses (ie. in
checklist, you can use -1).
Here is an example of the code that uses those responses:
(int(${Alcohol_Current_A11a})+int(${Alcohol_Current_A11b}))=1
or
selected(${Alcohol_Impact}, '1')
Any help would be appreciated, before I have to re-write many many
formulas
Thanks Mitch,
I did the above, and it works swimmingly. I thought I had done thorough
testing (my yes and no values were the most important), and I'm not sure
why I hadn't checked that the summing was working with the 'not
applicable/unknown' responses. I guess I'm still a beginner, but learning
quickly!
Thanks for your help!
Amber
···
On Wed, Oct 29, 2014 at 1:20 PM, Mitch Sundt wrote:
I believe this was already answered on an earlier thread. There is no
function that tests whether a value is a string or integer value, so your
best approach is to change the 'unknown' to a numeric value and
conditionally detect and not sum that value in. See the earlier answer.
Sorry for your pain. The golden rule of software development is early
end-to-end walk-throughs ("early integration"), and that applies here --
whenever you start writing a survey, be sure to periodically test filling
it out and doing analysis on the resulting dataset. The earlier you debug
the end-to-end operations, even if only a portion of the form data is
asked, the earlier you will uncover problems with usability or data
analysis.
Hello!
I've programmed in excel a lot questions (ie. 500) that use select_one
(and later the relevancy adds up the responses to move on/skip to other
questions). I'm trying to find a simple way to fix this without having to
re-do the whole thing using 'checklist' which looks more appropriate...
In my choices tab I used:
list_namenamelabelAlcohol_Response1YesAlcohol_Response0NoAlcohol_Response
UnknownUnknownAlcohol_ResponseRefusedRefusedAlcohol_ResponseNANot
Applicable
Because I used words (e.g. Unknown/Refused/NA under the name column) it
won't add and skip properly (using relevant codes below) because they are
words, and not strings. Is there a value (e.g. -1) or something like it
that I can write in instead of those words? I know -1 just subtracts 1 from
the sum. I'm basically looking for a dummy variable, or placeholder
variable that won't interfere with the addition of the responses (ie. in
checklist, you can use -1).
Here is an example of the code that uses those responses:
(int(${Alcohol_Current_A11a})+int(${Alcohol_Current_A11b}))=1
or
selected(${Alcohol_Impact}, '1')
Any help would be appreciated, before I have to re-write many many
formulas
