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},