File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_Calculation.tex
Revision
1.2:
download - view:
text,
annotated -
select for diffs
Fri Aug 29 21:45:21 2003 UTC (21 years ago) by
matthew
Branches:
MAIN
CVS tags:
version_1_2_X,
version_1_2_1,
version_1_2_0,
version_1_1_X,
version_1_1_99_5,
version_1_1_99_4,
version_1_1_99_3,
version_1_1_99_2,
version_1_1_99_1,
version_1_1_99_0,
version_1_1_3,
version_1_1_2,
version_1_1_1,
version_1_1_0,
version_1_0_99_3,
version_1_0_99_2,
version_1_0_99_1,
version_1_0_99,
version_1_0_3,
version_1_0_2,
version_1_0_1,
HEAD
Cleanups to remove duplicate tags. Still rotten text....
\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>