Hacker News new | ask | show | jobs
by mediaman 1260 days ago
I'm not sure if this is what you're looking for, but Grist has relationship-driven spreadsheets where the formulas are all Python code. And you can have multiple tables show on the same page, where selection of one filters the others.

The tables are more database-style than pure unstructured Excel sheet style, but I've found that having a full Python environment in each cell to be pretty powerful, and I've started turning to it for analytical work because I can avoid the mess that larger Excel formulas can turn into.

No relationship except as a customer -- they're at getgrist.com

2 comments

Ooh, excited to see mention of Grist (I am a cofounder). Python code and structured data are a great combination, and are particularly good for AI. We did an experiment where AI was quite impressive in writing Python formulas in Grist based on simple prompts: https://news.ycombinator.com/item?id=33809111

I suppose it's similar to rows.com's ASK_OPENAI("write a spreadsheet formula that..."). Most impressive is that it knows relationships between tables, and can construct correct lookup formulas, and do useful things with their results.

Looks cool too! Python!!