HNHacker News
TopNewBestAskShowJobs

OzCrimson

192 karma · joined February 27, 2018

submissionscomments
OzCrimson··on Excel warriors who save governments and companies from spreadsheet errors
See. You've got answers to something that you haven't asked a single question about. But in your judgement the company should have had the right developer on staff.

That's what's frustrating about these anti-Excel discussions.

Ok. What happens when I say that the company bought another company and it had a product line that the new company wanted to pay sales people commissions on? And the compensation plan around it was complex.

For whatever reasons, that's not a report the DBA was up for developing from scratch (or, someone decided his time wasn't to be used that way). That's just the reality.

We can talk about what should have been or what ought to have been, but that doesn't change the reality.

The reality is that I ended up doing most of it ACCURATELY in Excel.

OzCrimson··on Excel warriors who save governments and companies from spreadsheet errors
Who's going to pay to train a Customer Service Rep, Admin Assistant, Sales Assistant or Warehouse Manager to do Python when there's Excel?

Get into the world of the Excel user. Some of us do learn coding. But generally speaking? No. If it happens, it's on our own.

And we can agree that spreadsheets have problems, and Excel users typically are not data people.

BUT!

When we agree on that, it becomes evident that a lot of suggested solutions are non-starters. Not all Excel users are in an enterprise that's throwing money around for training and dedicated software.

I'd like to see the Warehouse Manager who goes in Monday morning and says to the company vice-president, "I've been looking into this Python class ... "

OzCrimson··on Excel warriors who save governments and companies from spreadsheet errors
Again. What's the comparable alternative?

This is so frustrating because I've worked in small departments in an international company. Our problems were too small to get consistent, needed help from IT and we weren't important enough to get one of the limited licenses to the fancy reporting system.

Ultimately, there's all this bad talk about evil Excel, but we get no help or other resources.

And what about all the junk reports that were coming out of the company database that no one wanted to spend the money to fix?

THE ONLY VIABLE ALTERNATIVE WAS EXCEL.

OzCrimson··on Excel warriors who save governments and companies from spreadsheet errors
Excel bashing is easy but, where's a truly comparable alternative?

- Alteryx at $5000/year/user?

- A database that requires specialized skill or going through a DBA for every little need?

- Salesforce? It's hell to configure if you don't have the skill.

- Sharepoint? Again. If you're a small business or nonprofit, you've gotta hire or train someone before this is a serious conversation.

I would in no way suggest that an enterprise can run on Excel with centralized data and multiple users. And that's where I believe a lot of criticism of Excel is unfair: the comparisons are not apples to apples.

And let's be honest. EVERYTHING comes with a level of human error.

- Enterprise level databases can get so big that the corrupt data in them can be impossible to cleanse.

- Reports made by SQL people are often flawed.

Over my 7 years in an international company I discovered report after report that didn't accurately match business rules or they were based on loads of incomplete records, duplicates, inconsistencies, incorrect math, etc.

How about fixing the reports? Often the decision was "no." Fixing the reports wasn't something a department head wanted to pay a consultant for.

Eventually, I had the DBA stop sending me reports. I started exporting the raw data into Excel and made my own reports.

- Brand new reports can be impossible to get if they don't justify the cost of a consultant to create the report. (Ah, but there's Excel.)

- Databases get hacked and they crash.

So. Where's the tool that's perfect, free and easy to use? It doesn't exist.

OzCrimson··on Portland adopts landmark facial recognition ordinances
Technology can help. Good, proven technology. Facial recognition tech is not ready for prime time.

Too often we've seen the legal system use flimsy evidence, and comb the earth for experts who'll back up the flimsy evidence. Then years later the city is paying someone for their wrongful conviction.

I don't want to be the person whose life is turned upside-down, and unable to pay legal fees all because of some flawed facial recognition.

When facial recognition is reliable, then we need to talk about privacy and access to the data and how it's used.

I can already imagine what'll happen. Government entities like, law enforcement, will have to jump through hoops to get warrants and prove they have a good reason to access the data. However, private entities like grocery stores, marijuana dispensaries and car washes won't need a good reason. They'll use it for marketing, and making money allowing 3rd parties to access the data.

I'm not cool with any of that.

OzCrimson··on Portland adopts landmark facial recognition ordinances
I'm listening to this podcast about the ban and it's loaded with concerns. https://xraypod.com/show/banned-in-pdx/biz-and-tech-groups-a...

For one, the lobbyists and pro-tech groups that are against the ban, have nothing to say about what happens when the tech is wrong. They're painting a perfect world where the tech is solid and used for things like identifying missing children.

The podcast describes the high level of false positives in the algorithms. They say "top performing" algorithms are pretty good, but generally speaking ... no. Not good.

And there's the implementation. How does this get rolled out? Who's responsible for breaches? Who can access the data? Will anyone be able to sell access to the data?

But I always come back to: what happens when it's wrong? And I don't expect perfection. KNOWING that this tech is flawed, it's important to ask "what level of flawed is acceptable?"

OzCrimson··on Portland adopts landmark facial recognition ordinances
I live in Portland, too. And we do need help. But facial recognition is unreliable. I'd hate to be the one who's misidentified but, overzealous law enforcement keeps insisting it's me. Or, maybe I'm shaking hands with some random person and then facial recognition is used to make it look like we're buddies, and accomplices in some mess he's in.

And I've seen enough unreliable technologies hit the market and marketers don't talk about the flaws or limitations in a responsible way. They highlight when the tech has done something miraculous.

With all of this kind of stuff I ask: what happens when the tech is wrong? Who's accountable? Who makes the victim whole? Too often the answer is nobody is accountable.

OzCrimson··on XLOOKUP for Excel
I saw a preview of XLOOKUP at the MVP Summit in March and was excited about it (but couldn't say anything about it until it was released).

Here's my brief video on XLOOKUP along with a Peace Summit where a staunch INDEX/MATCH user and I formally buried the hatchet n Perth, Australia.

https://youtu.be/0KEhR66btUs

OzCrimson··on XLOOKUP for Excel
Your co-worker couldn't tell you about doing a join in Excel's Power Query?
OzCrimson··on XLOOKUP for Excel
For a lot of individuals and small businesses true databases have a tough learning curve. I commend the Excel developers for recognizing this and including things like Power Query and Power Pivot.

They aren't there to completely replace databases, but they are a decent middle-ground for meeting people where they are.

OzCrimson··on Why Is Joe Rogan So Popular?
One vote of massive respect is after Jack Dorsey was on the show and Joe's audience gave him hell for letting Jack get away with BS. Joe admitted that he didn't know enough about the topic.

So, Joe scheduled a do-over and had Tim Pool alongside, and Tim acted as the BS-detector. To Jack's credit, he and his lawyer showed up for the do-over (as opposed to just declining).

Will a MSM reporter admit they're in over their head? Not a chance. But there are different motivations. MSM reporters are after the ratings. If a screaming match unfolds, that's more important than anything else. I'd rather have the polite conversations that Joe Rogan leads. Get to know the guests, get to know how they think.

OzCrimson··on Why Is Joe Rogan So Popular?
I like Joe Rogan and I agree. It's more conversational and that's what I like.
OzCrimson··on Mmm, Pi-hole
LOL!
OzCrimson··on Mmm, Pi-hole
I lean toward agreeing with you. Sure. I'd rather view ads than pay. BUT! Why I'm setting up a pi-hole isn't about ads in and of themselves. It's the intrusive and misleading ads. It's the tracking and difficulty opting out of targeted advertising.

I don't have a problem with tv ads for shampoo that I won't ever buy. I do have a problem with a web page that surrounds a legit news article with bizarre ads with cockimamy health claims, and links that don't go where they claim to go.

If a website says, "Pay up or look at these 'spider veins' ads" that's entitlement, arrogance and open contempt. That's not treating me like a desired customer.

OzCrimson··on Mmm, Pi-hole
Where I feel my hand was forced was when a friend wanted help promoting a professional conference in the area of data and tech. I went to the website and, in the center of the page, there was an ad for cellulite cream.

OH! C'MON!!! I believe in the conference, but I'm not going to share the link with that ad on it.

It's been explained to me that the website owners don't know what ads are being served up. All they know is they signed up for an ad service. If that ad is a redirect to a porn site, the website owner has no clue unless people complain.

And that's why I ordered a raspberry-pi to set up a pi-hole.

I get that a lot of my friends won't like this. They're in advertising and marketing, and they insist that they're one of the good ones. Fine. But the bad ones are REALLY bad.

Also. I've spent HOURS opting out of tracking cookies. Then I heard that my effort is only as good as the entities that respect that I opted out. OH? WOW!

So, when I hear people complain that we're hurting them, and they're one of the good ones, it ignores the real problem. Look ...

if I was bitten by 10 dogs out of 50 dogs, I'm gonna have a problem with dogs. Period. You can insist on how friendly your dog is, but no. Talk to the other dog owners before trying to get me to take another risk.

OzCrimson··on Vermont passes first law to crack down on data brokers
I agree! A lot of what's going on with data is the low-cost ease of intimate access to targeted people. Thus, we get constantly pestered and then it's our job to figure out how to get peace from stuff that we didn't ask for.

I've had to turn off alerts and miss notifications from friends because marketers have run amok. And we go back to the cost: it's been so doggone cheap that so many marketers have gotten to where they just don't care about being annoying.

There should be a higher cost to access me when I'm sitting in my barber's chair. Actually, DON'T contact me when I'm in my barber's chair. Go back to tv commercials, billboards, and snail mail. Put in some effort.

OzCrimson··on Ask HN: What's one book that changed your life?
"Bring Me Your Love" Charles Bukowski

Bukowski's style gave me a permission that I didn't know I was looking for. It was raw and accessible. It showed me that prose and poetry didn't need to be buried in metaphor and riddles.

That extends to much of life: let's get on with it. Sometimes it's fine to drop ceremony and adornment--especially if it's not genuine.

OzCrimson··on This Design Generation Has Failed, should designers be licensed?
I don't take the licensing point seriously. I see it more as an analogy for external accountability.

Let's agree that licensing is wrong. There's still the issue of nefarious and self-serving design that's caused a lot of real harm, and the decision-makers and creators don't see a problem. They don't have to.

← PreviousPage 2 of 2