191–200 of 223 posts
I think Eirik Bakke deserves a shoutout on this thread. He's the creator of UltOrg ( https://www.ultorg.com/ ) and has literally spent his career pursuing this question with a level of focus unlike anything I've ever seen. UltOrg is roughly "spreadsheets re-built atop the RDBMS datamodel". The UI supports nested joins, aggregations, filtering, for both display and data update. The result is essentially a general purp…
This looks really neat and powerful. I think spreadsheets have a lot of deficiencies and that many users abuse them, but that's because there is no widely known alternative/extension. For example, I wanted to create a list of data sources in a particular area. It doesn't warrant any coding, this is just a simple document, but doing it in a spreadsheet is too clunky: I want tags, paragraphs of text, and, crucially, a…
Earlier quoted context omitted.
This looks really neat and powerful. I think spreadsheets have a lot of deficiencies and that many users abuse them, but that's because there is no widely known alternative/extension. For example, I wanted to create a list of data sources in a particular area. It doesn't warrant any coding, this is just a simple document, but doing it in a spreadsheet is too clunky: I want tags, paragraphs of text, and, crucially, a…
try org-mode
https://orgmode.org/worg/org-tutorials/tables.html
After that, google for filtering, sorting, etc. It's all possible.
Earlier quoted context omitted.
Airtable really ought to be killing Excel, but the SaaS model combined with a stupidly low artificial row count limit (over 50000 rows is listed as "contact us for pricing") means that it will never achieve penetration into weird and wonderful use cases like Excel has. Like, my default is to throw a dataset I'm hacking on into an SQL database so I can actually query the thing. But no I don't want to upload my 400MB l…
I am currently working on a CLI that will allow you to query .csv, .xls and .tsv files and SQL tables via plain English.
Trillions of decisions have been made off a tool that has poor error handling and data consistency issues. Blame is not entirely on either the user or the software, but the tool is too trusted without validation. [Study that was at the core for Europe's austerity and European debt crisis contained excel errors when fixed showed the inverse of original hypothesis.]( https://www.nytimes.com/2013/04/19/opinion/krugman-t…
Airtable really ought to be killing Excel, but the SaaS model combined with a stupidly low artificial row count limit (over 50000 rows is listed as "contact us for pricing") means that it will never achieve penetration into weird and wonderful use cases like Excel has. Like, my default is to throw a dataset I'm hacking on into an SQL database so I can actually query the thing. But no I don't want to upload my 400MB l…
being able to have an excel grid and a chart view on the same page would probably suit your use case as well. being able to use python for the formulas is a nice touch too.
the free hosted version has almost all features available as far as i remember. there's also a docker version that's easy to get up and running and doesn't have any limitations
I scanned the comments to see if anyone had mentioned Causal[1] yet. I’d describe it as a spreadsheet specifically for modelling. I used it to build a cost model for the startup I work at, consisting of around 100 different inputs, and it was rather enjoyable. I was able to (reasonably easily) insert the different AWS costs for (for example) SD vs. HD video transcoding and see how that affected the costs of encoding…
It just needs more… AirTable style functionality to be all on one like Excel.
I think Eirik Bakke deserves a shoutout on this thread. He's the creator of UltOrg ( https://www.ultorg.com/ ) and has literally spent his career pursuing this question with a level of focus unlike anything I've ever seen. UltOrg is roughly "spreadsheets re-built atop the RDBMS datamodel". The UI supports nested joins, aggregations, filtering, for both display and data update. The result is essentially a general purp…
This looks really neat and powerful. I think spreadsheets have a lot of deficiencies and that many users abuse them, but that's because there is no widely known alternative/extension. For example, I wanted to create a list of data sources in a particular area. It doesn't warrant any coding, this is just a simple document, but doing it in a spreadsheet is too clunky: I want tags, paragraphs of text, and, crucially, a…
No. There's a reason why Excel has withstood the test of time. It will be the #1 productivity tool for decades to come
This approach was formalized in the concept-oriented model of data which relies on two basic elements: mathematical functions and mathematical sets. In contrast, most traditional data models rely on only sets. Functions are implemented as columns. This model gets rid of joins and groupby by making data processing simpler and more intuitive.
This approach was implemented in the Prosto data processing toolkit: https://github.com/asavinov/prosto
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.