(11C) (15C) Invisicalc Spreadsheet

[Michael Zinn]

(11-12-2024 12:48 AM)Thomas Klemm Wrote:  We can define each of the red cells as the average of the four surrounding cells:

\(
\require{color}
\begin{array}{|c|c|c|c|}
\hline
& 5 & 6 & \\
\hline
.2 & \color{red} 1 & \color{red} 2 & 7 \\
\hline
.1 & \color{red} 3 & \color{red} 4 & 8 \\
\hline
& .0 & 9 & \\
\hline
\end{array}
\)
[...]

Thanks for this great example! Did it terminate (how long did it take?), or did you abort it at some point and got an approximate result? Since InvisiCalc does not detect circular dependencies, it can run forever, though in this case, it converges in theory, but I never tested it and wonder if it could also go into an infinite loop near the final result, where the values "flicker" by some tiny amount forever.