\label{Spreadsheet_Op_On_All_Problem_Parts}
Often, there are several parts in a specific problem. For example, a
problem with three parts would have parts 0, 11, 12, and 13. For a
general spreadsheet, it is not often desirable to sum up all of these
parts, while not knowing how many parts there are as the spreadsheet
is written.
The spreadsheet has a preprocessor which an expand a symbolic
expression over all symbolic names that fit. The general syntax is
\texttt{[\&EXPANDSUM(VARNAME;expression)]}.
For example, for the above assessment with three parts,
\texttt{[\&EXPANDSUM(\textbf{PART};parameter_\textbf{PART}_weight*stores_\textbf{PART}_awarded)]}
would become
\texttt{parameter_\textbf{0}_weight*stores_\textbf{0}_awarded +
parameter_\textbf{11}_weight*stores_\textbf{11}_awarded +
parameter_\textbf{12}_weight*stores_\textbf{12}_awarded +
parameter_\textbf{13}_weight*stores_\textbf{13}_awarded}
where \textbf{bolded text} is used to highlight what the
\texttt{\&EXPANDSUM} function is doing.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>