News for hackers. Stuff that matters.
Re:You Suck at Excel (2015) [video] by ALittleLight on Friday December 20, 2019 @06:41PM (#21848381)
Earlier today I was looking at data from two different sources about the same thing. I wanted to see how similar the reports were. I grepped my logs, got columns of data, copied and pasted into Excel, created a line chart, copied and pasted the line chart into an email to a colleague. How would SQL let me do the same thing? With Excel this was probably less than a minute end to end. Would SQL be as fast? Keeping in mind that I wouldn't have a database for any of the data I was looking at.
Re:You Suck at Excel (2015) [video] by hoistbypetard on Friday December 20, 2019 @07:16PM (#21848598)
Concur. For whacking out a quick analysis like that, it's hard to beat a spreadsheet. (I do like Excel, but no longer think it's all that far ahead of LibreOffice for most things I tend to use it for.)

It's also good for creating what amounts to a quick interactive form.

But I've lost count of how many times I've run across a spreadsheet being misused as a shitty, ad-hoc database where it'd be less work (and less error-prone) to just use sqlite (or even postgres, honestly), so I have some empathy for GP's perspective.