Complex multiple criteria selected for skipping (XLS format) question! Help Please :)

Hi there,
I'm trying to build a comprehensive psychiatric assessment in ODK XLS
format, and I have included a simple depression module example below with
some questions about how to make the skipping work when you have multiple
criteria required and how I get it to display the results (in a user
friendly summary format) at the very end.

Group 1
One of the following must be 'yes' to move on to group 2 (otherwise skip to
next module):

  1. Have you ever felt sad or down, or irritable most of the day, nearly
    every day for 2 weeks or more?2. Have you ever felt like you lost interest
    or pleasure in activities you like to do for fun for 2 weeks or more?

Group 2:
4 of the following must be 'yes' in order to get a diagnosis of depression:
3. Have you ever lost or gained weight when you weren't trying during one
of these episodes?4. Have you ever slept too much, or had difficulty
sleeping for a period of two weeks or more during one of these episodes?5.
Has anyone ever told you that you were moving more slowly, or were more
restless and agitated for two weeks or more?6. Have you ever felt tired or
without energy during one of these episodes?7. Have you ever felt worthless
or excessive guilt nearly every day during one of these episodes?8. Have
you ever had difficulty concentrating or making decisions during one of
these episodes?9. Have you ever had thoughts of death, or thought about
suicide, or attempted or made a plan to hurt or kill yourself?
DISPLAY at the end:
'Patient meets criteria for depression' (If they selected at least 1 from
group one, and at least 4 for group 2)
-Also list which ones the patient selected? (is this possible?)
'Patient does not meet criteria for major depressive disorder' (if nothing
was selected from group one, and/or less than 4 from group 2)

QUESTIONS:

  1. I read about binding, which I think will help me skip- but, the
    instructions are for XML not XLS. Any idea how to use binding in this case
    (ie. at least one in group 1, and at least 4 in group 2?) Maybe binding
    isn't right?

  2. I also read about calculate, which I think I will need to use for the
    display at the end. Are there any examples of how to do this? I am assuming
    it would tally what (if I weight the responses 1 or 0, and if they sum is
    equal to or greater than 1 (for group 1) or equal to or greater than 4 (for
    group 2), then it will display?

  3. After I finish all of the modules (this is just a simple depression
    example), but I plan to assess anxiety, substance abuse, etc. Can it
    summarize ALL of the criteria at the end? I assume I just put the
    'calculate' line at the end of the excel file, so I can get a full
    diagnostic output/summary of all the patients information?

  4. If I edit the code in XML, I assume I can't go backwards and use XLS
    again?

Thanks so much!! I'm sooo new, and any help would be appreciated. I have
attached my XLS form if its easier to respond with an example right in my
form.

Amber

DepressionModule.xlsx (15.2 KB)

Amber,

See http://opendatakit.org/help/form-design/xlsform for how to do binding
and calculates in XLSForm. And no, you can't go from XML to XLS.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Sat, Jun 14, 2014 at 1:32 PM, Amber Rieder amber.rieder@gmail.com wrote:

Hi there,
I'm trying to build a comprehensive psychiatric assessment in ODK XLS
format, and I have included a simple depression module example below with
some questions about how to make the skipping work when you have multiple
criteria required and how I get it to display the results (in a user
friendly summary format) at the very end.

Group 1
One of the following must be 'yes' to move on to group 2 (otherwise skip
to next module):

  1. Have you ever felt sad or down, or irritable most of the day, nearly
    every day for 2 weeks or more? 2. Have you ever felt like you lost
    interest or pleasure in activities you like to do for fun for 2 weeks or
    more?

Group 2:
4 of the following must be 'yes' in order to get a diagnosis of depression:
3. Have you ever lost or gained weight when you weren't trying during one
of these episodes? 4. Have you ever slept too much, or had difficulty
sleeping for a period of two weeks or more during one of these episodes? 5.
Has anyone ever told you that you were moving more slowly, or were more
restless and agitated for two weeks or more? 6. Have you ever felt tired
or without energy during one of these episodes? 7. Have you ever felt
worthless or excessive guilt nearly every day during one of these episodes?8.
Have you ever had difficulty concentrating or making decisions during one
of these episodes? 9. Have you ever had thoughts of death, or thought
about suicide, or attempted or made a plan to hurt or kill yourself?
DISPLAY at the end:
'Patient meets criteria for depression' (If they selected at least 1 from
group one, and at least 4 for group 2)
-Also list which ones the patient selected? (is this possible?)
'Patient does not meet criteria for major depressive disorder' (if nothing
was selected from group one, and/or less than 4 from group 2)

QUESTIONS:

  1. I read about binding, which I think will help me skip- but, the
    instructions are for XML not XLS. Any idea how to use binding in this case
    (ie. at least one in group 1, and at least 4 in group 2?) Maybe binding
    isn't right?

  2. I also read about calculate, which I think I will need to use for the
    display at the end. Are there any examples of how to do this? I am assuming
    it would tally what (if I weight the responses 1 or 0, and if they sum is
    equal to or greater than 1 (for group 1) or equal to or greater than 4 (for
    group 2), then it will display?

  3. After I finish all of the modules (this is just a simple depression
    example), but I plan to assess anxiety, substance abuse, etc. Can it
    summarize ALL of the criteria at the end? I assume I just put the
    'calculate' line at the end of the excel file, so I can get a full
    diagnostic output/summary of all the patients information?

  4. If I edit the code in XML, I assume I can't go backwards and use XLS
    again?

Thanks so much!! I'm sooo new, and any help would be appreciated. I have
attached my XLS form if its easier to respond with an example right in my
form.

Amber

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Amber,

Did you already look at this post?:
https://groups.google.com/forum/#!topic/opendatakit-developers/38Vjl7-knCI

There are some suggestions and examples you might try.

Arturo

··· Le samedi 14 juin 2014 22:32:48 UTC+2, Amber Rieder a écrit : > > Hi there, > I'm trying to build a comprehensive psychiatric assessment in ODK XLS > format, and I have included a simple depression module example below with > some questions about how to make the skipping work when you have multiple > criteria required and how I get it to display the results (in a user > friendly summary format) at the very end. > > Group 1 > One of the following must be 'yes' to move on to group 2 (otherwise skip > to next module): > 1. Have you ever felt sad or down, or irritable most of the day, nearly > every day for 2 weeks or more?2. Have you ever felt like you lost > interest or pleasure in activities you like to do for fun for 2 weeks or > more? > > Group 2: > 4 of the following must be 'yes' in order to get a diagnosis of depression: > 3. Have you ever lost or gained weight when you weren't trying during one > of these episodes?4. Have you ever slept too much, or had difficulty > sleeping for a period of two weeks or more during one of these episodes?5. > Has anyone ever told you that you were moving more slowly, or were more > restless and agitated for two weeks or more?6. Have you ever felt tired > or without energy during one of these episodes?7. Have you ever felt > worthless or excessive guilt nearly every day during one of these episodes?8. > Have you ever had difficulty concentrating or making decisions during one > of these episodes?9. Have you ever had thoughts of death, or thought > about suicide, or attempted or made a plan to hurt or kill yourself? > *DISPLAY at the end:* > 'Patient meets criteria for depression' (If they selected at least 1 from > group one, and at least 4 for group 2) > -Also list which ones the patient selected? (is this possible?) > 'Patient does not meet criteria for major depressive disorder' (if nothing > was selected from group one, and/or less than 4 from group 2) > > *QUESTIONS:* > 1. I read about binding, which I think will help me skip- but, the > instructions are for XML not XLS. Any idea how to use binding in this case > (ie. at least one in group 1, and at least 4 in group 2?) Maybe binding > isn't right? > > 2. I also read about calculate, which I think I will need to use for the > display at the end. Are there any examples of how to do this? I am assuming > it would tally what (if I weight the responses 1 or 0, and if they sum is > equal to or greater than 1 (for group 1) or equal to or greater than 4 (for > group 2), then it will display? > > 3. After I finish all of the modules (this is just a simple depression > example), but I plan to assess anxiety, substance abuse, etc. Can it > summarize ALL of the criteria at the end? I assume I just put the > 'calculate' line at the end of the excel file, so I can get a full > diagnostic output/summary of all the patients information? > > 4. If I edit the code in XML, I assume I can't go backwards and use XLS > again? > > Thanks so much!! I'm sooo new, and any help would be appreciated. I have > attached my XLS form if its easier to respond with an example right in my > form. > > Amber > >

The links didn't quite go deep enough for what I needed to do, but I
figured it out with some help anyway.
Thanks so much!
Amber

··· On Sun, Jun 15, 2014 at 5:58 AM, arturo garcia wrote:

Hi Amber,

Did you already look at this post?:
https://groups.google.com/forum/#!topic/opendatakit-developers/38Vjl7-knCI

There are some suggestions and examples you might try.

Arturo

Le samedi 14 juin 2014 22:32:48 UTC+2, Amber Rieder a écrit :

Hi there,
I'm trying to build a comprehensive psychiatric assessment in ODK XLS
format, and I have included a simple depression module example below with
some questions about how to make the skipping work when you have multiple
criteria required and how I get it to display the results (in a user
friendly summary format) at the very end.

Group 1
One of the following must be 'yes' to move on to group 2 (otherwise skip
to next module):

  1. Have you ever felt sad or down, or irritable most of the day, nearly
    every day for 2 weeks or more? 2. Have you ever felt like you lost
    interest or pleasure in activities you like to do for fun for 2 weeks or
    more?

Group 2:
4 of the following must be 'yes' in order to get a diagnosis of
depression:
3. Have you ever lost or gained weight when you weren't trying during one
of these episodes? 4. Have you ever slept too much, or had difficulty
sleeping for a period of two weeks or more during one of these episodes? 5.
Has anyone ever told you that you were moving more slowly, or were more
restless and agitated for two weeks or more? 6. Have you ever felt tired
or without energy during one of these episodes? 7. Have you ever felt
worthless or excessive guilt nearly every day during one of these episodes? 8.
Have you ever had difficulty concentrating or making decisions during one
of these episodes? 9. Have you ever had thoughts of death, or thought
about suicide, or attempted or made a plan to hurt or kill yourself?
DISPLAY at the end:
'Patient meets criteria for depression' (If they selected at least 1 from
group one, and at least 4 for group 2)
-Also list which ones the patient selected? (is this possible?)
'Patient does not meet criteria for major depressive disorder' (if
nothing was selected from group one, and/or less than 4 from group 2)

QUESTIONS:

  1. I read about binding, which I think will help me skip- but, the
    instructions are for XML not XLS. Any idea how to use binding in this case
    (ie. at least one in group 1, and at least 4 in group 2?) Maybe binding
    isn't right?

  2. I also read about calculate, which I think I will need to use for the
    display at the end. Are there any examples of how to do this? I am assuming
    it would tally what (if I weight the responses 1 or 0, and if they sum is
    equal to or greater than 1 (for group 1) or equal to or greater than 4 (for
    group 2), then it will display?

  3. After I finish all of the modules (this is just a simple depression
    example), but I plan to assess anxiety, substance abuse, etc. Can it
    summarize ALL of the criteria at the end? I assume I just put the
    'calculate' line at the end of the excel file, so I can get a full
    diagnostic output/summary of all the patients information?

  4. If I edit the code in XML, I assume I can't go backwards and use XLS
    again?

Thanks so much!! I'm sooo new, and any help would be appreciated. I have
attached my XLS form if its easier to respond with an example right in my
form.

Amber

--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/OIX-XtIjeC0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Amber D. Rieder, B.A., B.Sc., PhD.(c)
MiNDS | McMaster Integrative Neuroscience Discovery & Study
Graduate Neuroscience Program, McMaster University
PC 329 - 1280 Main Street West,
Hamilton, ON. L8S 4L8
Email: riedera@mcmaster.ca
Phone: 905.525.9140 x24784