4 ms·

Topological sort on cells based on formula references. Excel sheets are often highly convoluted in cell cross-references in formulas. It would help to have a

by alok-g 9y ago

Topological sort on cells based on formula references. Excel sheets are often highly convoluted in cell cross-references in formulas. It would help to have a clean-up mechanism that performs a topological sort on all the cells with formulas and puts them in a more natural order. It would help to be able to identify the backward references even if the cells are not automatically rearranged.

westurner 9y ago
+1 for Topological sort of formulas (e.g. into a Jupyter notebook; as e.g. Python) https://www.reddit.com/r/statistics/comments/2arevn/how_to_use_python_for_statistical_analysis/ciyf3v3 https://www.reddit.com/r/statistics/comments/2arevn/how_to_u... https://www.reddit.com/r/personalfinance/comments/1739oc/improving_your_excel_skills_can_definitely_help/c84lr6x https://www.reddit.com/r/personalfinance/comments/1739oc/imp...
deleted 9y ago
[deleted]
qubex 9y ago
In a other comment I have suggested that the author of the original post look at Lotus Improv (and Quantrix Modeler, two spreadsheets from the nineties that were way ahead of their time for keeping data and formulae distinct. This obviates the need for topological sorting as described because the dataflow aspect of the sheet being worked on is always very explicit and clear.