\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
\index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 

For example, for the above assessment with three parts,

\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}

would become

\texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
\texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
\texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
\texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\

where \textbf{bolded text} is used to highlight what the
\texttt{\&EXPANDSUM} function is doing.\label{Spreadsheet_Tries}
In multi-part questions, "tries"\index{tries} is now the average number of tries to
get the parts right. The full data for each part is still stored by
the system. To expand the data and work with all parts, please see
\ref{Spreadsheet_Op_On_All_Problem_Parts}.