Alternatives to excel for casual data analysis with an interface?
This is part of a spreadsheet I build for keeping track of my personal finances.
The table consists of a single formula which got quite big and is just below excels limit of 8192 characters per cell.
Furthermore, compared to for example python excel formulas are much more of a pain in the neck.
I'd really love to do this in python. However, user interfaces are difficult to realize in python.
Calculating once in python an then transferring to excel isn’t an option as I want it to update in real time when adding new data.
Using python inside of excel seems promising, but it’s only available when subscribing to office 365 and all the code gets processed on MS servers.
So what’s the best way to achieve this not using excel?
Like I said, the data analysis part would be a walk in the park using python. But but creating a user interface is just very time consuming. That’s like a huge benefit of Excel.
What would a more professional approach be?