kobo_sample.xlsx

	A	B	C	D	E	F	G	H	I
1	type	name	label	required	constraint	constraint_message	repeat_count	calculation	relevant
2	start	start
3	end	end
4	select_multiple do4iy07	_Status	What best describes the status of your household?	true	not((selected (.,'_IDP') and selected (.,'_returnees')) or (selected (.,'_IDP') and selected (.,'_local')) or (selected (.,'_returnees') and selected (.,'_local')))	You cannot select these options at the same time!
5	integer	_NumberHH	How many people live in your family, including you?	true
6	begin_repeat	_Roster	Repeated group (Enter the name of the person you are communicating with first)	true			${_NumberHH}
7	select_one biol_sex	_Sex	Specify the gender of the family member	false
8	integer	_Age	Indicate the age of the family member	true	${_Age} >= 18 and ${_Age} <= 114	The person must be an adult! The upper value of the field is limited to 114.
9	calculate	_Check_65plus_age		false				if(${_Age}>=65,1,0)
10	end_repeat
11	calculate	_65plus_amount		false				sum(${_Check_65plus_age})
12	note	_Warn_no_65plus	Check whether there is a person 65 years or older among the family members, if not, then uncheck the box ‘Family member over 65’ in the question ‘What best describes the status of your household?’	false					((${_Status}='_65+' and count-selected(_Status) >= 1) and ${_65plus_amount}=0) or (${_Status}='_65+' and ${_65plus_amount}=0)
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100