News for hackers. Stuff that matters.
Re:Query Google Sheets as virtual tables with SQLite extensi... by mpweiher on Saturday March 18, 2023 @11:39AM (#35209961)
> let's just set a formula for the entire column, and make it refer to another column

Meet Lotus Improv (1991): https://en.wikipedia.org/wiki/Lotus_Improv

I think the patents have expired now.

Re:Query Google Sheets as virtual tables with SQLite extensi... by bargle0 on Saturday March 18, 2023 @02:41PM (#35211882)
Improv brought me joy. There isn’t anything like it.
Re:Query Google Sheets as virtual tables with SQLite extensi... by recuter on Saturday March 18, 2023 @05:03PM (#35213079)
I read this many times on HN. As far as I can tell Excel copied most of it about a decade later with pivot tables.
Re:Query Google Sheets as virtual tables with SQLite extensi... by geocar on Sunday March 19, 2023 @03:04AM (#35216723)
Sort of. Improv lets you work in the pivot though, like that's the main view, and the ramifications of that are huge.

- You don't have to make your sum/avg/analytic rows because Improv does that automatically. Yes, Excel does this on the pivot tables, but because you can't work there, a lot of people make a SUM(B2:B999) or something to make summary data more accessible.

- Your formulas look simple like ConversionRate=Total:Closes/Total:Leads instead of =SUM(A2:A99)/SUM(B2:B99) and sure I know there's a way to make Excel do something like that, but nobody does, which is one thing that makes it hard to mix stuff between multiple documents in Excel -- someone moves the lead count on the lead sheet and it blows everything up back at headquarters. In Improv if someone renamed Leads to Pipe or something it'd break and you'd see that right away with much less chaos.

And so on