3 ms·
And it's not just a matter of functionality: there's an enormous difference in performance. I've had to push the limits of Excel to do data analysis and visuali
by nradov 2y ago
And it's not just a matter of functionality: there's an enormous difference in performance. I've had to push the limits of Excel to do data analysis and visualization on huge spreadsheets with complex lookup formulas. It worked great. Then I tried to import into Google Sheets to share with colleagues and it completely choked. Like I let it churn for hours and it never finished recalculating. Google Sheets is "good enough" for basic, simple stuff but for anything more it's a real productivity killer.
- MegaDeKay 2y agoThis. I had similar experiences with LibreOffice. It can choke on what you'd think were pretty mundane and reasonably sized things. I imported a CSV file of 15K lines once and it used all available memory on my PC doing it. The optimization that goes into Excel is one of those "unsung hero" things that doesn't get a lot of glory but it is clutch day in and day out.
- Affric 2y agoI worked in a place where excel was used for ad-hoc calculations. We became a Google shop. Sheets was a piece of junk compared to excel. Anyone who did any real work rather than just looking at a spreadsheet or using a template got Excel back in about a week.
- ianand 2y agoGoogle Sheets does struggle past a certain size. For Spreadsheets-are-all-you-need (GPT2 Small implemented in Spreadsheet, ~1.25GB Excel file, 124M parameters), I have only been able to get the complete model working in Excel. In Google Sheets, I've only been able to get it to implement a single layer out of the 12 in the model. And there's no way it can handle the embedding matrix. And it randomly quit during tokenization. That being said, I am a fan of both Excel and Google Sheets. In Google Sheets the formulas are easier to read, and for teaching my class, it's great because students and I can be in the same sheet at the same time during a lesson. I also tried LibreOffice briefly. While it could open the Excel file, it was unable to save it (it crashed during the save process).
- deafpolygon 2y agoIn my case, it doesn't crash. But there tends to be visual formatting issues.