2 ms·
I'm an experienced developer turned CTO in the finance industry. I've been studying finance and I've come to appreciate spreadsheets a lot. They are much more p
by haolez 2y ago
I'm an experienced developer turned CTO in the finance industry. I've been studying finance and I've come to appreciate spreadsheets a lot. They are much more powerful and interesting than my previous misconception.
- readams 2y agoI think the biggest weakness of spreadsheets is version control and testing. This really limits the potential for results that are both complex and correct.
- cxr 2y agoThere's nothing stopping you from checking your spreadsheets into version control just like any other text-based file format (or non-text-based format, for that matter).
- macintux 2y agoBesides having a snapshot of each change, version control’s big advantage is the ability to compare versions and merge between branches. How do you accomplish that with a spreadsheet?
- cxr 2y agoThe same way you do those with any other text-based file format. Just make sure you are committing the raw (unzipped) OOXML and not the .xlsx.
- breckognize 2y agoIf you like spreadsheets, check out https://rowzero.io https://rowzero.io. It looks and feels like Google Sheets and scales to 1B+ row data sets. We natively support Python and Parquet, and connect directly to Postgres, Snowflake, Databricks, Redshift, and S3.