Can you tell me the steps in excel to correct errors happened when write
Enter or Semi colon
بتاريخ ٢٥/٠١/٢٠١٥ ٤:١٧ ص، جاء من opendatakit@googlegroups.com:
opendatakit@googlegroups.com
Google Groups
Topic digest
View all topics
ODK Briefcase - can't see instances - 1 Update
HELP WITH SCORE CALCULATION - 6 Updates
ODK Briefcase - can't see instances
Mitch Sundt mitchellsundt@gmail.com: Jan 24 05:05PM -0800I am having difficulty understanding what you are asking.
ODK Briefcase supports:
(1) PULLing data into the ODK Briefcase Storage Location.
(2) PUSHing data to ODK Aggregate from the ODK Briefcase Storage Location.
(3) EXPORTing data in CSV format to a set of files
It sounds like you are trying to do (1) -- PULLing from a set of
directories that you have copied off of a device. To do that, you need to
have an 'odk' directory that contains a 'forms' and an 'instances'
subdirectory.
When using the "Custom Path to ODK Directory", choose this "odk"
directory.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Back to top
HELP WITH SCORE CALCULATION
Karisa Kazungu kkarisah@gmail.com: Jan 23 11:07PM -0800Hey all,
I am stuck at the point where I need to calculate the score in the
attached
Excel ODK sheet. I have 10 questions in the sheet hence the score is out
of
10 marks (each question is 1 point).I have tried the calculate function but I think the formula is wrong.
Kindly help me in getting the right formula.
In the choices tab I have highlighted the right answers in yellow meaning
if the respondent chooses that answer, then he/she gets a point (1 mark).
How do I write the formula in a way that will pick the right answer as 1
point and calculate out of 10 so that one can get 4,5,6, or whatever
point
they get depending on how they answer the questions.Thanks in advance.
Angelo Lazzari angelo.lazzari@redtulp.com: Jan 24 07:30AMHi,
if i understood correctly this example can do what you need, doesn't it?Every option has a number value and at the end you sum the responses
values.check it on https://enketo.org/formtester
Let me know!
Angelo
Karisa Kazungu kkarisah@gmail.com: Jan 24 01:03AM -0800
Thanks Angelo,
I can see your form but I need you to correct the form I have attached.
That way I will understand better. And I tried using the Enketo tester
but
it keeps loading and no reply. Kindly assist.This is the message I get when I submit the form
on http://opendatakit.org/xiframe/Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
Invalid calculate for the bind attached to "${Score}" : Couldn't
understand
the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
'7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1',
$Dancing},