LON-CAPA Help

• &NUM(range) - number of non-empty cells in range

• &BIN(low, high, range) - number of non-empty cells in range with values between low and high

• &SUM(range) - sum of the non-empty cells in range

• &MEAN(range) - mean value of non-empty cells in range

• &STDDEV(range) - standard deviation of non-empty cells in range

• &PROD(range) - product of non-empty cells in range

• &MAX(range) - maximum value of non-empty cell in range

• &MIN(range) - minimum value of non-empty cells in range

• &SUMMAX(n ,range) - sum of the maximum n non-empty cells in range

• &SUMMIN(n, range) - sum of the minimum n non-empty cells in range

• &EXT(expression) - access to EXT function in lonnet. Use &EXT('system.time') to retrieve the current time.

• &PARM(parameter) - get the value of a specific parameter

• &MINPARM(expression) - get the value of a parameter that matches the expression that is the smallest in value (If one specified 'opendate' it would return the smallest opendate set on the problem.)

• &MAXPARM(expression) - get the value of a parameter that matches the expression that is the largest in value (If one specified 'opendate' it would return the largest opendate set on the problem.)

• &SUMSEQ(column,sequence1,sequence2,sequence3,...) - sum the given column across the folders or sequences listed.

  When specifying a sequence use the full title. Instead of a sequence title the word all can be used to sum over all sequences. Regular expressions can be entered as well, if prefixed by regexp:. See below for examples.

  • &SUMSEQ('Z','Chapter 1');

  • &SUMSEQ('Z','Chapter 1','Chapter 2','Chapter 3');

  • &SUMSEQ('Z','all'); - sum over all sequences.

  • &SUMSEQ('Z','regexp:Large Biomolecules'); - sum over all sequences which match the regular expression /Large Biomolecules/.

In addition, most non-IO Perl functions work in cells.