Visualise the structure of a spreadsheet

Re:Visualise the structure of a spreadsheet by crrashby on Monday October 21, 2013 @02:03PM (#6587189)

-A formula such as INDEX or MATCH is shown as a box with an arrow coming in for each parameter of the function. Hovering over the box gives a breakdown of which cell is being looked up for each row.

-None of the content of the spreadsheet is uploaded.

-We're not looking at building the model as a tree right now but it's a cool area to explore.

[ Parent | on HN ]

Re:Visualise the structure of a spreadsheet by filearts on Monday October 21, 2013 @03:17PM (#6587604)

We have some pretty powerful in-hourse tools for visualizing information flow within a given worksheet. It will overlay borders around contiguous blocks of identical (R1C1) formulas and color code based on whether the cell has a value, a formula an off-sheet formula and cross-file formula, etc...

However, where our tools fail, and where your tool really shines is transforming the spreadsheet visual paradigm into something that more closely resembles the intent of the model. Very cool! (I signed up)

[ Parent | on HN ]