6 ms·
That would imply non-tech people having some surprisingly deep visibility into technical details. What they really see is Excel vs. some contractor doing "a sys
by TeMPOraL 6y ago
That would imply non-tech people having some surprisingly deep visibility into technical details. What they really see is Excel vs. some contractor doing "a system".
The reality is that Excel is available today and works, and scales up... well, until it doesn't. Still, you have data entry that everybody in the field understands, that's rock solid (so no need to unit test anything), and has a tried and true authentication module built in (a file sent from a government mail address). There's a risk of user errors, but the system will be working immediately[0]. Deployment can be done by anyone, as it's just clicking on File->New and starting to type data in.
Meanwhile, a "pigsqueal" solution will take half a year to design, produce and deploy (that's in an emergency, a year otherwise). And that's with competent IT people, and not someone who wants to profiteer off the crisis. Then you'll have to train the users, and hope the reality won't necessitate any changes, because they will take a while.
I think plenty of decent coders appreciate the fact that Excel is suitable for a surprisingly wide range of tasks, and that if you spot it widely used somewhere, it most likely means there isn't any comparable alternative available.
--
[0] - Note that the user error that finally happened did not happen in the place where you'd expect it to.
- strbean 6y agoCouldn't you achieve exactly what was needed here with Airtable? Or, easier yet, Google Sheets and a Google Form?
- TeMPOraL 6y agoExtremely low performance. Obscure "sharing" workflow instead of obvious "mail a file". Cloud dependency that needs to be vetted for security (EDIT: and data privacy, as 'sjansen pointed out), and policies regarding cloud accounts on government e-mails. And in case of Airtable, also for budget. I'd be surprised if either of the above could handle 65k rows in a single table without becoming near-unusable.
- sjansen 6y agoProbably not while complying with privacy laws. I would be much more upset to find out a governemnt employ on a deadline used Google Sheets or Airtable to share my medical data instead of an Excel doc on a secure government file server.
- retbull 6y agoI don't really agree with much of google any more but I was at one point fairly involved in a project there. They do have some more secure systems for government use that isn't the crazy leaky ad cesspool gmail and docs is.
- srtjstjsj 6y agoWhere are the ads in Docs?
- monocasa 6y agoThe docs are used for data into the advertisement systems. I've heard on the grapevine that several fortune 500 companies are on O365 because Google wouldn't disassociate docs from data gathering, even at the level of high touch high paying customers and they rightfully consider their internal documents to be part of their IP. Microsoft says "sure" and flips a secret "don't even gather stack traces on the server" flag for these customers.
- strbean 6y agoAh, HIPAA. Having looked at the marketplace for HIPAA compliant solutions for educational therapy patient record keeping (patient CRM, whatever the industry term is), I'd feel so much safer having my data in the hands of Airtable than the absolute dumpster fire that was every offering I saw.
- ploika 6y agoHIPAA is an American regulation, not a British one.
- srtjstjsj 6y ago> HIPAA " For customers who are subject to the requirements of the Health Insurance Portability and Accountability Act (HIPAA), G Suite and Cloud Identity can also support HIPAA compliance" https://support.google.com/a/answer/3407054?hl=en https://support.google.com/a/answer/3407054?hl=en > secure "UHS says all U.S. facilities affected by apparent ransomware attack Computer systems at Pennsylvania-based Universal Health Services began to fail over the weekend, leading to a network shutdown at hospitals around the country." https://www.healthcareitnews.com/news/uhs-says-all-us-facilities-affected-apparent-ransomware-attack https://www.healthcareitnews.com/news/uhs-says-all-us-facili...
- boogies 6y agoWhat about LibreOffice’s spreadsheets?
- benhurmarcel 6y agoFor most cases where Excel is used where it "shouldn't be", any alternative that stores the data in the cloud is not possible. Just getting the approval and contracts would take longer than the entire span of the project.
- deleted 6y ago[deleted]
- gxs 6y agoNot to mention the "system" solution will have to go through its own debugging and will undoubtedly have bugs in it for some time after initial release. On top of that, there is STILL room for human error as a user is still the one actually inputting data and designing the experiment/data flow. I'm going to get mauled on this forum given the audience, but parent comment reeks of the technical elitism on this forum and the tendency to immediately condemn anyone who is using excel. Excel works great - I've personally built some very complicated models that work just fine. Goes through the same process of QA and line-by-line checking of requirements. Not sure what the big deal is - mistakes happen in excel or otherwise.
- xupybd 6y agoYep Excel is a solid choice for some systems. Business people know it and it's a hard sell to tell them you want more time / money to use something they see giving them less.
- srtjstjsj 6y ago> Goes through the same process of QA and line-by-line checking of requirements. That's simply not possible unless you have a whole system around excel running a year harness. You can maybe do it if you are super dedicated with locked cells and formal double-blind QA passes which maybe exist somewhere but not in the vast majority of operations.
- Aeolun 6y ago> formal double-blind QA passes I don’t know what you think I have in my unit tests, but it’s almost certainly not whatever you mentioned. Using excel as an alternative to CSV is fine. It’s not like anyone was doing anhthing complicated here. Just storing data.
- konjin 6y ago>Using excel as an alternative to CSV is fine. Clippy the Paperclip Hi, it looks like this alphanumeric constant is the date format used by the Democratic Peoples Republic of Arstotzka for the year 127 BC. I have changed the encoding for the file to Arstotzka standard and overwritten the original.
- srtjstjsj 6y agoExcel never works for math, at any scale. It's a constant trashfire of "looks fine" until it shows a result someone doesn't want, and then an error is found that changes results and the cycle repeats. Excel is nice for visualizing and browsing data you already have, and informally searching and sorting for hypothesis generation.
- ksenzee 6y ago> Excel never works for math, at any scale. That is patently untrue. I've borrowed and lent money based on Excel spreadsheets, more than once. That's small-scale math with real-life consequences, and Excel is an excellent tool for the job.
- mordae 6y agoCouch GnuCash Cough
- m-p-3 6y agoYou're right, but if you asked me to do something in GnuCash which I never used or do the equivalent in Excel with formulas I'm already familiar with, I'd go with Excel in a pinch. This is why Excel is so well known, because once you get the hang of it, it becomes a great tool for something small. It scales poorly though.
- inopinatus 6y agoI'd concur if s/excellent/adequate/.
- TeMPOraL 6y agoMy 4th order Runge-Kutta ODE solver I did in an afternoon in Excel the other day, because I didn't want to pirate Matlab to do a homework assignment, begs to differ :). Not to mention, the entire financial industry and many (most?) small businesses. Lots of people use Excel for various types of math, and it works fine, if you know what you're doing. Excel not being idiot-proof doesn't mean it's not usable. And that's all without writing a single line of VBA. (We can have a separate discussion about some of the newer Excel features, like automatically suggesting what kind of statistical analyses to perform on your data - I consider this to be a potential future source of serious fuckups, as it allows people to easily transform data using methods, whose assumptions and implications they do not understand.) > "looks fine" until it shows a result someone doesn't want, and then an error is found that changes results and the cycle repeats That's a feature, though. Excel is interactive, which means you get ample opportunity to do sanity checks on results (both partial and final) as you work on your sheet, as well as immediate feedback on corrections. In "properly written" IT systems, this is rarely the case - you end up discovering a problem further down the chain, and have to figure out which component did something wrong, and why.
- ccktlmazeltov 6y ago> that's rock solid (so no need to unit test anything) that is crazy talk, the amount of user error that can happen in an Excel spreadsheet means that you would need to do crazy macro work in order to maintain the integrity of the data
- bigiain 6y ago> Still, you have data entry that everybody in the field understands, that's rock solid (so no need to unit test anything) Hey @TeMPOraL, there's a guy with a withdrawn PhD thesis on line 1 who'd like a word with you... http://blogs.nature.com/naturejobs/2017/02/27/escape-gene-name-mangling-with-escape-excel/ http://blogs.nature.com/naturejobs/2017/02/27/escape-gene-na...