[LON-CAPA-users] Spreadsheet question

Todd Ruskell lon-capa-users@mail.lon-capa.org
Thu, 28 Jun 2007 22:36:55 -0600


A question about the spreadsheet for the few others of you that use it.
 At the student level, I can use &SUMSEQ("F","regexp:Homework")
to sum all the values in column "F", in every folder that has "Homework"
in it, as an effective way to to get a homework total.

However, if a "Homework" folder has sub-folders, this does not recurse
down the tree, which is a "good thing" for many reasons.

I'm wondering, though, if there is a way to tell &SUMSEQ that I actually
want it to recurse through all sub-folders.  I'm finding this could be
really useful, instead of having to add each entry manually.


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