[LON-CAPA-users] Spreadsheet question

Guy Albertelli II lon-capa-users@mail.lon-capa.org
Fri, 29 Jun 2007 14:40:57 -0400 (EDT)

Hi Todd,

> 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.


You can, (if you name the subfolders similarly) use the regexp so it
also match all of the subfolders "regexp:(Homework|Sub Folder)"

So a small amount of naming consistancy could make it apply

guy@albertelli.com   0-7-0-9-27,137