4 ms·
Excel has a top-to-bottom, left-to-right calculation order of cells, which can mess things up if you aren't careful. How does your engine handle calc execution
by prometheus76 3y ago
Excel has a top-to-bottom, left-to-right calculation order of cells, which can mess things up if you aren't careful.
How does your engine handle calc execution order?
- breckognize 3y agoThe spreadsheet DAG is derived from the formulas. See https://en.wikipedia.org/wiki/Topological_sorting https://en.wikipedia.org/wiki/Topological_sorting. Let me know if I'm misunderstanding!
- deleted 3y ago[deleted]
- deleted 3y ago[deleted]
- prometheus76 3y agoThis video explains better what I'm thinking of. He has built a 16-bit computer in Excel, and where he put the different formulas for the different parts of the computer on the sheet affected how it worked (he basically had to change his design because of how Excel calculates). https://www.youtube.com/watch?v=5rg7xvTJ8SU https://www.youtube.com/watch?v=5rg7xvTJ8SU