logoalt Hacker News

Adding Window Functions to a Spreadsheet

28 points • by reedciccio • today at 3:21 PM • 19 comments • view on HN

Comments

quaintdev • today at 5:42 PM

Checkout ironcalc if you are looking for spreadsheet alternatives https://www.ironcalc.com/index.html

mallahan • today at 5:41 PM

The way Excel formulas so easily break drove me to create https://www.treesum.app/.

librasteve • today at 4:15 PM

I’m all in favour of making spreadsheets better, with code friendly formulas. Here’s one I’m working on - somewhat earlier in dev cycle than grist and while I did consider Python (and lua) for the formula DSL decided to cook up my own.

All feedback good and bad v welcome.

https://omasheet.org

halo • today at 4:30 PM

I sometimes feel the world is slowly reinventing BusinessObjects

seemaze • today at 4:20 PM

Imagine a world where we starting teaching SQL in primary school..

➕ show 2 replies
shevy-java • today at 3:44 PM

The syntax is so archaic ... it really is anything but a thing of beauty.

    prev_balance = PREVIOUS(rec, order_by="Date").Running_Balance or 0
    prev_balance + $Amount
It's such a strange mix-up of stuff. PREVIOUS() is a macro or looks like one, right? But it is a function call assumingly. But then what's with .Running_Balance? Guess that also ties into a function. But why use different syntax for essentially the same thing? It seems rather weird to write code like that. What would the python variant be like? Or a DSL?

The syntax strangeness continues:

    rates = Rates.lookupRecords(Person=$Person, order_by="Rate_Start")
    rates.find.le($Date).Hourly_Rate
Does that really convey most easily what is wanted? It seems needlessly verbose. Why would it require both $Person and $Date? Should that not be easier to figure out in its own right? Is that efficient?

People need to remember that mentally, unless they use AI.

➕ show 3 replies
arbor-group • today at 3:43 PM

[flagged]