Category talk:Excel: Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
| Line 21: | Line 21: | ||
::Regarding Conway's game of life: funny example, it's fairly easy to build a CGOL emulator in a spreadsheet, with only spreadsheets functions, and relying on some evaluation order (that can be controlled by options, usually). Of course the grid of the game is made of spreadsheet cells. |
::Regarding Conway's game of life: funny example, it's fairly easy to build a CGOL emulator in a spreadsheet, with only spreadsheets functions, and relying on some evaluation order (that can be controlled by options, usually). Of course the grid of the game is made of spreadsheet cells. |
||
::Actually, there is much more to spreadsheets than merely accounting functions, with some imagination. For instance, it's possible to sort a list with spreadsheet functions. It's probably not enough to say it's a "true" programming language, but the same can be said of LaTeX or SQL, and probably others on RosettaCode. |
::Actually, there is much more to spreadsheets than merely accounting functions, with some imagination. For instance, it's possible to sort a list with spreadsheet functions. It's probably not enough to say it's a "true" programming language, but the same can be said of LaTeX or SQL, and probably others on RosettaCode. |
||
::And here, I'm not even considering replacing "temporal loops" by "spatial loops": copying a formula is like a "for loop", and can be used for instance to compute the solution of an equation, or to integrate a function. Of course, you have much more power if you use the solver, or VBA, or external DLLs (like LAPACK to compute eigenvalues for data analysis), combine all of this with your data to produce tabular or graphical output, everything within your spreadshet. Not too bad, for a ''not-a-programming-language''. |
|||
::Have also a look at the nice [https://newtonexcelbach.wordpress.com/ Newton-Excel-Bach blog]. |
|||
::[[User:Arbautjc|Arbautjc]] ([[User talk:Arbautjc|talk]]) 10:47, 19 July 2015 (UTC) |
::[[User:Arbautjc|Arbautjc]] ([[User talk:Arbautjc|talk]]) 10:47, 19 July 2015 (UTC) |
||
Unfortunately there is a site limitation that does not allow images to be uploaded. This might affect how graphical solutions to problems can be shown on Rosetta Code. I did [[Knapsack_problem/Unbounded#OOCalc|this]] several years ago which is an oocalc entry.<br> |
Unfortunately there is a site limitation that does not allow images to be uploaded. This might affect how graphical solutions to problems can be shown on Rosetta Code. I did [[Knapsack_problem/Unbounded#OOCalc|this]] several years ago which is an oocalc entry.<br> |
||