Readit Newsjpiech commented on Show HN: GS-Calc – A modern spreadsheet with Python integration citadel5.com/gs-calc.htm... · Posted by u/jpiech
As co-founder of Resolver Systems -- we tried but ultimately failed to take on Excel with a Python-enabled equivalent back in 2007 -- and current employee at Anaconda (providing Python in Excel) I really do hope you get this one to work. Excel is a mess, Python is better, and someone surely will eventually be able to fix the former with the latter. Let's hope it's you :-)
Thank you. The current integration is described in the online HTML GS-Calc help. Any suggestions would be highly appreciated.
jpiech commented on Show HN: GS-Calc – A modern spreadsheet with Python integration citadel5.com/gs-calc.htm... · Posted by u/jpiech
I like old-school UIs but I wonder if that look doesn't do the product a disservice. I think most people would find it much more appealing if it looked at least as good as tad and rowzero mentioned in other comments. My first impression was that it is some old, slow software from 30 years ago, and the plots are not what I would show to anyone (especially the 3d bar plots). But that's just the looks. Otherwise, the product is solid.
(Yes, I know that there is plenty of old software that is super fast.)
Yep, the website is being kept simple, in fact too simple and will have to be eventually redesigned.
It seems the classic (and actually up to date) WinAPI GUI shouldn't imply the software is being "slow". One could have it both ways and say it's usually on the contrary where commonly cloned packages weighing hundreds of MB and performing relatively simple tasks get a free ride on users' ten(s) of times faster hardware. Then there is the Wirth's law, May's law etc.
jpiech commented on Show HN: GS-Calc – A modern spreadsheet with Python integration citadel5.com/gs-calc.htm... · Posted by u/jpiech
are there any plans to add real-time collaboration features, like Google Sheets or Excel Online
This is a potentially interesting feature - it probably could be relatively easily extended to the shared environment in GS-Calc as there are already separate passwords to protect files, the sheet/view structures and cell ranges and optional sha256 checksums for all the data categories, but there no plans as such. At the moment you can just use two script commands to release the opened file, periodically check whether it's modified, report it and automatically reload the file.
jpiech commented on Show HN: GS-Calc – A modern spreadsheet with Python integration citadel5.com/gs-calc.htm... · Posted by u/jpiech
jpiech commented on Show HN: GS-Calc – A modern spreadsheet with Python integration citadel5.com/gs-calc.htm... · Posted by u/jpiech
It all sounds very compelling , great work! But I have to ask, what’s the catch? This almost seems like it’s ready to fully replace Excel but I’ve seen many things die in that pursuit. What will Excel users miss by switching?
I’m don’t do a ton to big data stuff, but sometimes despite Excels stated row and column support- I find it effectively melts down if even 100K/100 of data and forget adding formulas.
Thanks. This is just a set of features that offer better (sometimes significantly better) performance and make it possible to work with large data sets in some predictable way, that is, knowing what the performance is with 100K formulas, you should be able to estimate how it'll work with 10 millions no matter how much formatting is applied, added hyperlinks, links to external closed workbooks, lists etc. That is probably correct, in the upcoming years there might be no way to compete directly with (the standalone) Excel. Hopefully it just helps to perform or verify various things way faster than in Excel with add-ins (or often at all).
Fully adaptable to every database need, ranging from a household list to the personnel or inventory records of a large corporation.
You can analyze, query, perform calculations, merges and joins with up to 256 million rows, 16K columns and 4GB+ files efficiently using even old PC's.
If you are new to database technology, don't worry - GS Base lets you start small and, without any extra cost, increase functionality as you need it.
You can perform both simple and complex record filtering, searching for duplicates, for unique values and frequencies, full-text searches, find-as-you-type, fuzzy searches, searching quartiles, random searches, one-click statistical breakdown analysis and link GS-Base UDF function in calculated fields with your Python libraries. You can use unlimited in-cell charts to spot trends and analyze largest data sets using pivot tables with up to 256 million rows and a broad selection of pivot data functions.
https://pmc.ncbi.nlm.nih.gov/articles/PMC9125511/https://journals.viamedica.pl/folia_cardiologica/article/vie...