We used spreadsheets to manage offices -- there is about 15 separate offices -- complete data set (clients, analytics, call logs) and each sheet has many, many different formulas interconnecting all the sheets in the book.
We use Google Sheets, as we changed from Office at the beginning of this year, and 10-15 times a day my tab crashes on Chrome from just existing, let alone when trying to do any operations.
It's a mess, and I'd rather build a simple web app to replace it, but don't have the time, approval, or financial resources to make the switch. So instead of letting me improve 100+ peoples daily workflows, we just suffer.
I know it sounds like a terrible idea,but next time you wait for the tab to restart how about looking into the sheets api docs? And the next time,try to write a quick script that just makes updating the cells you need to update a bit easier. At the end of it,at least you won't have to suffer.
+1 for Google Apps Script. I’ve built dashboards in sheets using Apps Script to call web services. I think you can even make your Apps Script act as a rudimentary FAAS using the sheet as a database.
That's not an Excel problem. That's a problem with using Google's shitty, half-baked, bloated facsimile of Excel.
I personally would rather build an Excel sheet (in actual Excel) than a simple web app. In fact, I believe a double digit percentage of SaaS startups would be strictly more useful to their users if they came in the form of a downloadable Excel sheet instead of the bullshit web SPA thing. But of course, selling something useful for the customer is not how you make money today.
We use Google Sheets, as we changed from Office at the beginning of this year, and 10-15 times a day my tab crashes on Chrome from just existing, let alone when trying to do any operations.
It's a mess, and I'd rather build a simple web app to replace it, but don't have the time, approval, or financial resources to make the switch. So instead of letting me improve 100+ peoples daily workflows, we just suffer.
Go spreadsheets!