Return to Spreadsheet_Op_On_All_Problem_Parts.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex, revision 1.1

1.1     ! bowersj2    1: Often, there are several parts in a specific problem. For example, a
        !             2: problem with three parts would have parts 0, 11, 12, and 13. For a
        !             3: general spreadsheet, it is not often desirable to sum up all of these
        !             4: parts, while not knowing how many parts there are as the spreadsheet
        !             5: is written.
        !             6: 
        !             7: The spreadsheet has a preprocessor which an expand a symbolic
        !             8: expression over all symbolic names that fit. The general syntax is
        !             9: \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
        !            10: 
        !            11: For example, for the above assessment with three parts,
        !            12: 
        !            13: \texttt{[\&EXPANDSUM(\textbf{PART};parameter_\textbf{PART}_weight*stores_\textbf{PART}_awarded)]}
        !            14: 
        !            15: would become
        !            16: 
        !            17: \texttt{parameter_\textbf{0}_weight*stores_\textbf{0}_awarded +
        !            18: parameter_\textbf{11}_weight*stores_\textbf{11}_awarded +
        !            19: parameter_\textbf{12}_weight*stores_\textbf{12}_awarded +
        !            20: parameter_\textbf{13}_weight*stores_\textbf{13}_awarded}
        !            21: 
        !            22: where \textbf{bolded text} is used to highlight what the
        !            23: \texttt{\&EXPANDSUM} function is doing.