Live data from Hacker News

Excel 2.0 – Is there a better visual data model than a grid of cells?

subset.so

1–10 of 223 posts

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#3
"A spreadsheet is then the simplest, most organically natural way of organizing discrete units of information, the easiest way to perform CRUD operations on any type of data."

So... you've basically answered the question here.

"It’s been 40 years since the original Visicalc spreadsheet program was released, and no one has been able to beat them"

There is a reason that columnar workbooks and spreadsheets have been around since humans started writing down numbers and manipulating them... it works.

A "grid of cells" does exactly what it is supposed to do in the most efficient manner possible. The only "innovation" opportunities are making the underlying product suck less, or providing analytics/reporting functionality.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#4
The key is that you can examine the state of most (not all) "intermediate" variables so not only do you know the inputs, the outputs, but also everything that happened in between in all these different ways.

Your calendar app adds 2 days for tasks? You can just see the cell where it says 2 to make sure that variable is set right. Its amazing, and we are just catching up to it with "always on" variable inspectors in IDEs.

Edit: That's not the only trick: cells don't have variable names but locations. You don't have to remember the type (they are all cells) or the name of a variable. Its just a location and you click on it to select it.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#5
I think about this a lot. There is a need for more data-driven applications to create graphics that are more “track able” than excel. I have a series of charts that need to be sent out to multiple people (internal and external) each week. Charts, logos, tables, etc could benefit from a pipeline but without needing a data engineer. Right now, we have a standard data download from Bloomberg or another data provider, macros to change the format, access to slice, back to excel where the charts are 75% standard but might need some tweaking. Bloomberg might not classify one company as healthcare but I want to include them so access keeps a list or companies I want. That same Bloomberg output could include companies some of my colleagues would classify as tech companies so relevant for multiple people. No way to see what was done last week or changes made to the chart / table output from one person to another besides new versions of the same excel file (but still no way to see the logs)

Long winded description but hopefully helps describe how important excel is but there is still room to grow.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#6
Bettering a table for data is going to be hard. Calculated fields (instead of $L$123, $Total) could be represented in other ways to bound to cells. As could code. But honestly, with the amount of time people already waste formatting spreadsheets, less options is probably a productivity enhancement.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#8
I liked the way Apple did it in their Numbers clone of Excel - you can have multiple grids on a single page. It makes it a lot easier to have related data on the same page without fiddling with the row/column sizes to suite multiple types of data.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#9
I've shifted to Airbase for pretty much anything data sheet related. The ability to have more typical data-flow joins with an easier to manage UX that teaches folks along the way is pretty phenomenal. It grows as you need, but still remains relatively simple.

It's one of my favorite pieces of software from the past decade.

Re: Excel 2.0 – Is there a better visual data model than a grid of cells?

#10
post #8

I liked the way Apple did it in their Numbers clone of Excel - you can have multiple grids on a single page. It makes it a lot easier to have related data on the same page without fiddling with the row/column sizes to suite multiple types of data.

Numbers is deeply underrated.
Post reply on HN