[LON-CAPA-users] Spreadsheet syntax question

lon-capa-users@mail.lon-capa.org lon-capa-users@mail.lon-capa.org
Mon, 11 Jun 2007 20:17:53 -0400

OK, guys (and Guy!), I'm struggling with a syntax question in the
spreadsheet (assess_calc level, for a multi-parted problem).

I have a point assignment hash table which assigns points based on the
number of tries. Works OK as far as using the hash. The expression below
correctly assigns values from the points hash.


But, I want to assign the points for an incomplete problem differently; for
the moment, I want to assign the value -22. I am trying various
combinations of

[&EXPANDSUM(PART;("stores_PART_solved" eq 'incorrect_attempted'? -22 :

where the check of stores_PART_solved is intended to find the problem parts
which have been tried but not completed.

The problem: the check never hits the -22 case, although stores_700_solved
indicates its value is incorrect_attempted (in the A column). All points
are coming from the $points hash. If I change the -22 to another number,
the total points calculated stays constant. Somehow, I am not coding the
comparison correctly.

Any suggestions?