3 ms·

I do financial modelling at a Big4 and can easily see the value of this type of visualization tool. I wonder if/how you are able to visualize INDEX/MATCH type

I do financial modelling at a Big4 and can easily see the value of this type of visualization tool. I wonder if/how you are able to visualize INDEX/MATCH type lookups, SUMPRODUCT and array formulas? Obviously, these types of formulas are not in every model, but for my usecase it would be pretty important. Also, since others have asked but the answer watn't too clear: is any data uploaded? You mention that you have plans to move to a model where things happen in reverse: models would be defined as flows and the spreadsheet could be generated. What progress (if any) have you made on that front?

crrashby 13y ago
-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.
- filearts 13y ago
  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)