Hi Team,
Could you please help me to rank household members according to their sex and age in descending order in ODK forms. ie males in the order of decreasing age(oldest to youngest) and then the females in order of decreasing age(oldest to youngest).
Is there any function in XLSForm to achieve this?
Ordering like this is not easy to do in XLSForm and ODK Collect.
If you can place a limit on the number of people you want to place in order
(e.g., no more than 5), then you could do something like the "Biggest N of
Set" form, which uses techniques described here:
If possible, this ranking is best done during data analysis. The data
collection effort (survey design) should avoid imposing ordering like this.
Hi Team,
Could you please help me to rank household members according to their sex
and age in descending order in ODK forms. ie males in the order of
decreasing age(oldest to youngest) and then the females in order of
decreasing age(oldest to youngest).
Is there any function in XLSForm to achieve this?--
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.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
For others looking for this,
https://groups.google.com/d/msg/opendatakit/t-TF7v_LMFs/C3AxEpl9BwAJ
has your answer.
Hi Team,
Thank you for your reply. Is it possible to do the ranking using KISH method?
My understanding of the KISH method is that you use a pre-assigned
table of random numbers? Yes, you could build something like that by
loading the table in a CSV.
http://xlsform.org/#how-to-pull-data-from-csv for a how to.
Yaw
On Mon, Aug 29, 2016 at 6:29 AM, dhanyamol.300x9.zyxware@gmail.com wrote:
Hi Team,
Thank you for your reply. Is it possible to do the ranking using KISH method?
On Friday, August 26, 2016 at 10:32:33 PM UTC+5:30, Mitch Sundt wrote:
Ordering like this is not easy to do in XLSForm and ODK Collect.
If you can place a limit on the number of people you want to place in order (e.g., no more than 5), then you could do something like the "Biggest N of Set" form, which uses techniques described here: https://opendatakit.org/help/form-design/#xpath_expressions
If possible, this ranking is best done during data analysis. The data collection effort (survey design) should avoid imposing ordering like this.
On Wed, Aug 24, 2016 at 3:15 AM, dhanyamol.3...@gmail.com wrote:
Hi Team,Could you please help me to rank household members according to their sex and age in descending order in ODK forms. ie males in the order of decreasing age(oldest to youngest) and then the females in order of decreasing age(oldest to youngest).
Is there any function in XLSForm to achieve this?
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com--
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.
Has anyone pulled this off yet? What happens after you load the csv table? Here's a quick snapshot of a kish grid:
1 2 3 4 5 6 7 8 9
HH1 1 1 1 1 1 1 1 1 1
HH2 1 1 2 2 1 1 2 2 1
HH3 3 2 1 3 2 1 3 2 1
HH4 2 3 4 1 2 3 4 1 2
HH5 5 4 3 2 1 5 4 3 2
To use Kish, you need two more pieces of information in addition to the table - some kind of random number from 1 - 9(which can be generated on its own but is usually taken as the last number on the questionnaire ID number) and you also need an itemized list of all the members of the household you want to select (which should be easy enough).
I'm knew to ODK but can it easily generate a random number from 1-9? The form would then need to take this number and match it with the first row of the table e.g. if my random number is 3 - I would then go to the 4th column that should be titled "3". Then, let's say I only have 3 members of the HH - I would go down to the last row with a HH member - in this case - the 4th row (the one corresponding to the 3rd HH member). That gives me the number "1"
The first HH member - corresponding to number 1 - is the person I would select for the interview.
So how could I set up this form? After the random number (or questionnaire number is pulled), what code do I use to match it with the corresponding column title, then count down to the last row with a HH entry, pull that number and count again down that number of rows (+1) to select that HH member?
Thanks!
Corey
Hi Corey,
I've attached an example to get you started.
Yaw
kish.xlsx (32.6 KB)
kish.xml (1.71 KB)
data.csv (131 Bytes)
Thanks! Let me give it a try
Hi Corey,
I've attached an example to get you started.
Yaw
On Fri, Nov 11, 2016 at 6:46 PM, carrollpatterson@gmail.com wrote:
Has anyone pulled this off yet? What happens after you load the csv
table? Here's a quick snapshot of a kish grid:
1 2 3 4 5 6 7 8 9
HH1 1 1 1 1 1 1 1 1 1
HH2 1 1 2 2 1 1 2 2 1
HH3 3 2 1 3 2 1 3 2 1
HH4 2 3 4 1 2 3 4 1 2
HH5 5 4 3 2 1 5 4 3 2To use Kish, you need two more pieces of information in addition to the
table - some kind of random number from 1 - 9(which can be generated on its
own but is usually taken as the last number on the questionnaire ID number)
and you also need an itemized list of all the members of the household you
want to select (which should be easy enough).I'm knew to ODK but can it easily generate a random number from 1-9?
The form would then need to take this number and match it with the first
row of the table e.g. if my random number is 3 - I would then go to the 4th
column that should be titled "3". Then, let's say I only have 3 members
of the HH - I would go down to the last row with a HH member - in this case
- the 4th row (the one corresponding to the 3rd HH member). That gives me
the number "1"The first HH member - corresponding to number 1 - is the person I would
select for the interview.So how could I set up this form? After the random number (or
questionnaire number is pulled), what code do I use to match it with the
corresponding column title, then count down to the last row with a HH
entry, pull that number and count again down that number of rows (+1) to
select that HH member?
Thanks!
CoreyOn Monday, August 29, 2016 at 1:45:51 PM UTC+3, Yaw Anokwa wrote:
My understanding of the KISH method is that you use a pre-assigned
table of random numbers? Yes, you could build something like that by
loading the table in a CSV.
http://xlsform.org/#how-to-pull-data-from-csv for a how to.Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.On Mon, Aug 29, 2016 at 6:29 AM, dhanyamol.300x9.zyxware@gmail.com wrote:
Hi Team,
Thank you for your reply. Is it possible to do the ranking using KISH
method?On Friday, August 26, 2016 at 10:32:33 PM UTC+5:30, Mitch Sundt wrote:
Ordering like this is not easy to do in XLSForm and ODK Collect.
If you can place a limit on the number of people you want to place
in order (e.g., no more than 5), then you could do something like the
"Biggest N of Set" form, which uses techniques described here:
https://opendatakit.org/help/form-design/#xpath_expressionsIf possible, this ranking is best done during data analysis. The
data collection effort (survey design) should avoid imposing ordering like
this.On Wed, Aug 24, 2016 at 3:15 AM, dhanyamol.3...@gmail.com wrote:
Hi Team,Could you please help me to rank household members according to
their sex and age in descending order in ODK forms. ie males in the order
of decreasing age(oldest to youngest) and then the females in order of
decreasing age(oldest to youngest).Is there any function in XLSForm to achieve this?
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com--
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.--
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.--
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/Taez1aDVvHs/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.
Good afternoon Friends,
I have designed two separate forms. I have managed to load one to ODK
collect. However, i cant load the other one on account that the second
questionnaire as similar credentials or characteristics to the one i
uploaded first. What should i do to get to load the second form too??
Thanks
Collins
Thanks! Let me give it a try
On Fri, Nov 25, 2016 at 7:48 AM, Yaw Anokwa yanokwa@nafundi.com wrote:
Hi Corey,
I've attached an example to get you started.
Yaw
On Fri, Nov 11, 2016 at 6:46 PM, carrollpatterson@gmail.com wrote:
Has anyone pulled this off yet? What happens after you load the csv
table? Here's a quick snapshot of a kish grid:
1 2 3 4 5 6 7 8
9
HH1 1 1 1 1 1 1 1 1
1
HH2 1 1 2 2 1 1 2 2
1
HH3 3 2 1 3 2 1 3 2
1
HH4 2 3 4 1 2 3 4 1
2
HH5 5 4 3 2 1 5 4 3
2To use Kish, you need two more pieces of information in addition to the
table - some kind of random number from 1 - 9(which can be generated on its
own but is usually taken as the last number on the questionnaire ID number)
and you also need an itemized list of all the members of the household you
want to select (which should be easy enough).I'm knew to ODK but can it easily generate a random number from 1-9?
The form would then need to take this number and match it with the first
row of the table e.g. if my random number is 3 - I would then go to the 4th
column that should be titled "3". Then, let's say I only have 3 members
of the HH - I would go down to the last row with a HH member - in this case
- the 4th row (the one corresponding to the 3rd HH member). That gives me
the number "1"The first HH member - corresponding to number 1 - is the person I would
select for the interview.So how could I set up this form? After the random number (or
questionnaire number is pulled), what code do I use to match it with the
corresponding column title, then count down to the last row with a HH
entry, pull that number and count again down that number of rows (+1) to
select that HH member?
Thanks!
CoreyOn Monday, August 29, 2016 at 1:45:51 PM UTC+3, Yaw Anokwa wrote:
My understanding of the KISH method is that you use a pre-assigned
table of random numbers? Yes, you could build something like that by
loading the table in a CSV.
http://xlsform.org/#how-to-pull-data-from-csv for a how to.Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.On Mon, Aug 29, 2016 at 6:29 AM, dhanyamol.300x9.zyxware@gmail.com wrote:
Hi Team,
Thank you for your reply. Is it possible to do the ranking using
KISH method?On Friday, August 26, 2016 at 10:32:33 PM UTC+5:30, Mitch Sundt wrote:
Ordering like this is not easy to do in XLSForm and ODK Collect.
If you can place a limit on the number of people you want to place
in order (e.g., no more than 5), then you could do something like the
"Biggest N of Set" form, which uses techniques described here:
https://opendatakit.org/help/form-design/#xpath_expressionsIf possible, this ranking is best done during data analysis. The
data collection effort (survey design) should avoid imposing ordering like
this.On Wed, Aug 24, 2016 at 3:15 AM, dhanyamol.3...@gmail.com wrote:
Hi Team,Could you please help me to rank household members according to
their sex and age in descending order in ODK forms. ie males in the order
of decreasing age(oldest to youngest) and then the females in order of
decreasing age(oldest to youngest).Is there any function in XLSForm to achieve this?
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com--
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.--
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.--
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/to
pic/opendatakit/Taez1aDVvHs/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.--
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.