Live data from Hacker News

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

subset.so

21–30 of 223 posts

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

#21
post #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.

Airtable is great, but it's got more of Access than Excel in its genes imho.

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

#22
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.

Last time I used it I believe it just crashed when opening a large CSV file.

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

#23

in the metaverse, you will have 3d tables, x,y and z axis, you would be able to twist and turn those 3d tables to get different views, join with other 3d tables

Why does this need to be in the metaverse? Can't we have 3d excel sheets currently without the need for VR?

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

#24
Yes, Excel spreadsheets frequently contain errors that are hard to spot. Sometimes those errors end people’s careers and damage companies. Tools like Quantrix that use multi-dimensional models provide a formula syntax that’s radically less error prone while providing far superior reporting.

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

#25

"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 aro…

I agree. There may be no better UX alternative than columnar spreadsheets. Excel shines in scenario analysis when, for example, the data comes from your head. I believe Excel has an opportunity to improve when data comes from external sources like CSV dump from a CRM. I would like to see Excel improve the way it allows you to extract data from other systems which would reduce redundant effort and decrease the likelihood of errors.

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

#26

in the metaverse, you will have 3d tables, x,y and z axis, you would be able to twist and turn those 3d tables to get different views, join with other 3d tables

we could do that in the 80s when you hacked into the Gibson

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

#28
If your data consists of a long complicated pipeline, there might be some useful UX coming out of shader graphs systems from computer graphics. Shaders transform data in a functional way and you can build large graphs that also clearly show the inputs and outputs of a transformation. This might be easier to debug than a spreadsheet. Any point in the pipeline can be output to a visualizer in this way.

It would make debugging, understanding and inspecting the dataflow easier, but it would probably make browsing the output a bit harder so I can't say it's an obvious slam dunk. Might be interesting though.

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

#29
post #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.

Airtable is great, but it's got more of Access than Excel in its genes imho.

I agree, but say more about what you mean here.
Post reply on HN