[BACK]Return to Spreadsheet_Calculation.tex CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / html / adm / help / tex
File:  [LON-CAPA] / loncom / html / adm / help / tex / Spreadsheet_Calculation.tex
Revision 1.3: download - view: text, annotated - select for diffs
Tue Sep 14 22:24:56 2004 UTC (20 years, 2 months ago) by albertel
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_X, version_2_8_99_1, version_2_8_99_0, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_X, version_2_5_99_1, version_2_5_99_0, version_2_5_2, version_2_5_1, version_2_5_0, version_2_4_X, version_2_4_99_0, version_2_4_2, version_2_4_1, version_2_4_0, version_2_3_X, version_2_3_99_0, version_2_3_2, version_2_3_1, version_2_3_0, version_2_2_X, version_2_2_99_1, version_2_2_99_0, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_X, version_2_1_99_3, version_2_1_99_2, version_2_1_99_1, version_2_1_99_0, version_2_1_3, version_2_1_2, version_2_1_1, version_2_1_0, version_2_12_X, version_2_11_X, version_2_11_5_msu, version_2_11_5, version_2_11_4_uiuc, version_2_11_4_msu, version_2_11_4, version_2_11_3_uiuc, version_2_11_3_msu, version_2_11_3, version_2_11_2_uiuc, version_2_11_2_msu, version_2_11_2_educog, version_2_11_2, version_2_11_1, version_2_11_0_RC3, version_2_11_0_RC2, version_2_11_0_RC1, version_2_11_0, version_2_10_X, version_2_10_1, version_2_10_0_RC2, version_2_10_0_RC1, version_2_10_0, version_2_0_X, version_2_0_99_1, version_2_0_2, version_2_0_1, version_2_0_0, version_1_99_3, version_1_99_2, version_1_99_1_tmcc, version_1_99_1, version_1_99_0_tmcc, version_1_99_0, version_1_3_X, version_1_3_3, version_1_3_2, version_1_3_1, version_1_3_0, version_1_2_99_1, version_1_2_99_0, loncapaMITrelate_1, language_hyphenation_merge, language_hyphenation, bz6209-base, bz6209, bz5969, bz2851, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE, HEAD, GCI_3, GCI_2, GCI_1, BZ5971-printing-apage, BZ5434-fox, BZ4492-merge, BZ4492-feature_horizontal_radioresponse
- more tth fixes

\label{Spreadsheet_Calculation}

The total number of spreadsheets in course can be tremendous, since it is
the number of students times the number of assessments. LON-CAPA
caches these sheets and only selectively invalidates those cache
copies if potentially relevant data changes. 

The automatic spreadsheet devalidation catches student
submissions, \textbf{PAR}a\textbf{M}eter changes, and spreadsheet
changes, but not re-publication of a problem resource.  

\textbf{Spreadsheet\_Max\_Depth\_Exceeded}

The ``Maximum Calculation Depth Exceeded''\index{Maximum Calculation
Depth Exceeded error} error can occur when you reference other cells in
calculations. For example, if you have: 

\texttt{G0 = Some\_complicated\_expression\\
 X0 = G0>2?1:0}

Try replacing \texttt{X0}'s contents with \texttt{[
(Some\_complicated\_expression) > 2]?1:0}. In other words, replace the
reference to \texttt{G0} with the actual contents of \texttt{G0}. That
might fix your error by removing one level of indirection that
LON-CAPA must process in order to compute the result.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>