Live data from Hacker News

I only use Google Sheets

mayberay.bearblog.dev

201–210 of 361 posts

Re: I only use Google Sheets

#201
post #88

Slightly Off Topic, are there any other online SpreadSheets other than Excel 365 and Google Sheets? Some of them are AirTable like which is CRM focus, but I just want a really simple spreadsheet that is easily accessible and not from Big Tech.

The web version of Apple Numbers is pretty good although I suppose it doesn't meet your non-big-tech criteria.

I actually dont have big tech problem, it is just most of the well knowns once are blocked in where I work, and now even Notion is blocked.

Re: I only use Google Sheets

#202

Earlier quoted context omitted.

Another oft overlooked point is that anti-spreadsheet people aren't actually against using spreadsheets, we just want our coworkers to stop placing mission critical operations in an enormous, half-baked spreadsheet that exists only in some long-since retired users home directory.

I see these complaints on HN a lot, and maybe it’s anecdotal, but I just don’t see this in the real world these days. If someone shares a sheet with me, it’s for the intended purpose of sharing data and/or visualizations of that data. I’ve always been a huge fan of spreadsheets, and the rare times I’ve encountered them being misused, it was a long time ago, and not near enough to make me an “anti-spreadsheet” person.…

I was part of a team helping a Fortune 500 company whose inventory system was basically a master spreadsheet that maybe 8 people in the company actually had write access to. Everyone reported numbers up to them and the spreadsheet had read only views for purchase order projections.

To say that it was a nightmare was an understatement. They were willing to dump vast sums of money to get something better, but they'd homebrewed so many human processes to deal with the spreadsheet that they struggled to adapt to a more conventional way of doing things.

Re: I only use Google Sheets

#203
Reminder that anything you put into Google for storage is you voluntarily disclosing such information to the United States federal government without a warrant requirement.

Due to both the third party doctrine as well as FAA702, the feds do not require warrants to access, copy, process, and store indefinitely all information you provide to Google.

Good luck!

Re: I only use Google Sheets

#204
> I entered the workforce about 9 months ago

Right or wrong, it takes a certain amount of chutzpah to put forth such a definite opinion after less than a year in the workforce.

What OP probably misses is the "there ain't nothing so permanent as a temporary solution" thing. I too embrace quick and dirty solutions but only if I have total control over the lifetime of that solution. If someone's going to ask me to deliver it immediately and then build a castle on top of it... I might insist on using a tool that has more up front cost.

Re: I only use Google Sheets

#205
post #199
post #88

Slightly Off Topic, are there any other online SpreadSheets other than Excel 365 and Google Sheets? Some of them are AirTable like which is CRM focus, but I just want a really simple spreadsheet that is easily accessible and not from Big Tech.

Try out rowzero.io! It's a pure spreadsheet like Sheets/Excel, but with a much larger row limit.

Thank You that looks fantastic! It feels snappy as well.

Re: I only use Google Sheets

#206

Earlier quoted context omitted.

You need to give them a tool that's as easy to use as a spreadsheet, and yet stores data in a relational database. There are plenty of spreadsheet-database hybrids in the market.

Using any tool but Excel has the same problem as finding programmers who are willing to use some obscure proprietary programming language. They're going to worry about career lock if they're not developing portable skills. Even though Excel is proprietary too, it's ubiquitous enough that people don't have to worry about it.

That's true, nothing is as ubiquitous as Excel. But Excel is not designed for multiple people simultaneously updating data. At some point you need a database.

Re: I only use Google Sheets

#207

Earlier quoted context omitted.

Data > Protect sheets and ranges, choose Protect range or Protect sheet, and then click Set permissions to customize who can edit them. What Problem?

and they save versions every edit or every few minutes too. It's free version control that you cannot forget to turn on Huge contrast with MS approach to this

When was last time you used Onedrive or Sharepoint connected Excel? That's also how it works nowadays.

Re: I only use Google Sheets

#208
This is honestly one of the things I really like about Notion Databases, at the core they are an online collaborative spreadsheet. But then it can also be given multiple views and different forms such as a calendar, Kanban board, timeline, image gallery, etc., wish more apps would allow something like this, e.g. Obsidian Bases are a great first step.

Re: I only use Google Sheets

#209

Earlier quoted context omitted.

As someone who has been to multiple trade shows to show off our own spreadsheet product that solves some of these problems ( https://rowzero.io/home ), I can tell you there are a bunch of data engineers and their managers who have a visceral hatred of spreadsheets but have trouble articulating any reason for it.

Feels a bit like the no-code paradox though. When you make a sufficiently advanced no-code (or no-database) tool it becomes equivalent to code (or a database) and even though it does entice a novice to start using it, a complex system made in it is still complex code (or a complex database) and ends up requiring a competent programmer (or db admin) to maintain it, who wishes it was written the normal way to begin wit…

I have no doubt that the stories of complex spreadsheet models as the beating heart of a business are true. But those models are likely the sole survivor from a thousand dead and gone spreadsheets that people extracted value from for a time, but just didn't have the ongoing utility or wide enough audience to merit being turned into a dashboard or web app. It would be a mistake to insist that all of those spreadsheets should have started life as something else, just in case maintenance should someday become necessary.

In other words, one of the core use cases for a spreadsheet is that it empowers a broad swathe of users (broader than Tableau or PowerBI) to quickly extract insights from their data to fill immediate needs.

Or at least, that's a core use case if you can get your data into a spreadsheet without too much trouble.

Re: I only use Google Sheets

#210
post #126

Earlier quoted context omitted.

>Wasn't Microsoft Access basically that? No because the datagrid in MS Access is too rigid and doesn't have the extensive slice-&-dice features of MS Excel. My first consulting gig was creating customized MS Access applications. Despite that experience, I use MS Excel today because I know that MS Access is too limiting.

>> Wasn't Microsoft Access basically that? > No because the datagrid in MS Access is too rigid and doesn't have the extensive slice-&-dice features of MS Excel. i'm not saying it worked or worked well, but i'm pretty sure the point of Access in the office suite was so that you could access Access (get the clever marketing?) data from within Excel and then do all the excel things you were used to. anyone know if that…

I think it worked technically and I‘ve seen a few Access-based solutions to problems faced by people/groups without any real access to development resources. However, these solutions pretty much always came from people with rather technical mindsets and I think many of them involved tinkering in the evening and on weekends. So, my assumption would be that the demise of Access was more about UI/UX, complexity, familiarity and the like than it was about functionality.
Post reply on HN