[LON-CAPA-users] Spreadsheet Help!

Todd Ruskell lon-capa-users@mail.lon-capa.org
Fri, 15 Dec 2006 16:25:07 -0700

I swear I had this working earlier in the semester, but it's not now.  I
need to find the number of parts in a problem that have *not* been
excused.  I tried pulling some code from the default spreadsheet, and
this is what I'm trying:

[&EXPANDSUM(PART;1*(stores_PART_solved !~ /^(\W?excused\W?|)$/ ?1:0))];

The problem is, this seems to always return the total number of parts.
I'm not a perl genius, so it's probably (hopefully?) something simple.
What am I missing/doing wrong?

Final grades are due on Monday.

Thanks in advance for your help.

Dr. Todd Ruskell
Senior Lecturer, Department of Physics       Office:  Meyer Hall 326
Colorado School of Mines                     Phone: 303-384-2080
1523 Illinois Street                         Fax: 303-273-3919
Golden, CO 80401