Return to Spreadsheet_Op_On_All_Problem_Parts.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

.tex files from help.loncapa.org largely done. Added some lables to
older files. Last mega-massive .tex commit for a while.

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