3 ms·
It seems like most graph traversal and high-dimension problems would be difficult to model in Excel’s 2D data structures. (Don’t get me wrong, I think more of
by sokoloff 5y ago
It seems like most graph traversal and high-dimension problems would be difficult to model in Excel’s 2D data structures.
(Don’t get me wrong, I think more of the world runs on Excel than most people think and it’s perfectly well-suited for it, but “it can do anything” does not seem practically true to me.)
- gh02t 5y agoActual tensor math would be fun to see. Definitely possible but it'd be ugly.
- NamTaf 5y agoAs in something like MMULT, or deeper functionality?
- gh02t 5y agoI was thinking about how wild it would be to build up full support for the operations in tensor algebra for arbitrary orders. Doing that in Excel seems like it'd be wild. And then build up (numerical) tensor calculus operations on top of that if you really wanted to go nuts. That would probably be the worst hell I could imagine.
- Frost1x 5y agoGraph structures in general are painful in Excel. You can generate adjacency lists or matrices and do stuff that way, but it's painful and non-intuitive. I'm currently helping some people who started modeling such a datastructure in Excel. You end up with massive sparse matrices that aren't intuitive to work with, visualize, traverse, and so forth.
- NamTaf 5y agoSUM(Sheet1:Sheet3!A1:B3) is a valid function. Excel is a 3D data structure.