wizardbeard

joined 1 year ago
[–] [email protected] 4 points 1 month ago (1 children)

Please pardon the ramble.

Most (not all) of the interpretation issues in Excel are because people don't know how to use it and click ok without reading message boxes.

Modern Office 365 Excel on the desktop asks if I want to convert numbers as text with leading zeroes into numerals (eliminating the leading zeroes) whenever I open a csv that has them in it, and has had this feature for at least a month now. You just hit no.

For more complicated data, open a new spreadsheet, go to the data tab, import from text or csv, select your csv. In the data import wizard thing that pops up, select every column and set format to text. Boom. Problem solved, no data mangling. Delete the link back to the source csv so there's no weird sync being attempted, and the data is just flat data in your spreadsheet in table form.

For commas in "cell" contents in your source csv file, wrap the contents in quotes and excel won't treat the comma within as a column separator. Exporting csvs from PowerShell does this automatically for string data.

Personally, I always try to keep the flat csv output as a separate copy from the xlsx file I format for human reading. Csv for at rest data storage, xlsx for display. Non-cosmetic edits get worked back into the program generating the csv, or I whip up a basic PowerShell script to import the csv data in, work with it as objects, then export back to csv.

Mixing the two use cases of display and data processing is where the footguns are all hidden. Business users absolutely deserve a better set of tools than Excel for data manipulation. It works so much better as just formatting.

[–] [email protected] 15 points 1 month ago (2 children)

There's a handy "Take Action" button at the bottom of the article where you can look up your representative and send them an editable pre-written email.

[–] [email protected] -2 points 1 month ago (1 children)

Yes, the only options are left, do nothing centrist, or extremist right.

Don't have time to debate you right now, but that is an absolutely absurdist level false dichotomy and cheetah speed goalpost moving.

[–] [email protected] 0 points 1 month ago

Mmmmm, I sure love idealogical purity tests!

Better not step an inch out of line!

[–] [email protected] 1 points 1 month ago (1 children)

Why yes, I excitedly look forward to the time I can spend being spoken down to about my area of expertise, and would much rather engineer things to spend more of my time doing that instead of any of my other job duties, or browsing the internet.

[–] [email protected] 0 points 1 month ago (4 children)

Yes, because fucking Rambo of all movies is about how bad american soldiers felt about what they did.

Thanks for the laugh

[–] [email protected] 2 points 1 month ago (1 children)

Most homes in the US don't break a million in up front cost, unless you're buying in one of the very popular "reality warp" locations that are in absurdly high demand (SF Bay area, Redmond, Dallas, New York, etc).

[–] [email protected] 14 points 1 month ago (27 children)

On the highest level, they have a constant firehose of as much audio data from a sea of customers as they wish.

Send it to cheap overseas transcribers, use it to train and improve voice recognition and automatic transcription.

Have a backchannel to television viewing and music listening patterns.

Know when different customers are home or not, improving demographics data.

Know what is discussed within the house for data on ad penetration/reach, brand awareness, and better advertisement targeting.

It's not a direct data to money pipeline, but having an always on listening device in someone's home nets you a ton of useful data as an online retailer and advertiser.

[–] [email protected] 10 points 1 month ago* (last edited 1 month ago)

Can't you automate around this edge case that we told you during planning could never happen due to controls on our end?

That's easier for us than sticking to our word.

What do you mean that it was a key requirement of your design, like you told us in advance?

[–] [email protected] 4 points 1 month ago

I think that's better than one department (with the clout to do so) going "this is going to be our source of truth" while completely unprepared for what it means.

They literally spent over a year in talks with the whole rest of the damn company about what that would mean and what level of responsibility that would entail, delayed the go live multiple months multiple times... and they still can't do fucking basic data validation.

Leading and trailing spaces. Names randomly in all caps.

Oh, there's a shit ton built off the requirement that this field is one of these options? Surprise, we silently added another option without telling anyone, after we agreed in planning that option was invalid. Not our fault, your fault for building shit based off the idea this was a source of truth and we actually took requirements seriously.

Why is everyone coming to us to correct this data? Why can't you just correct it downstream like you used to? What do you mean we were warned? I wasn't paying attention during that meeting that you held specifically to warn me about this in advance because I was too busy ignoring all the other warnings people were telling me!

What do you mean that the thing you warned us would be consistently be delayed until next day because of how our source of truth works can't be done on demand on the same day? Huh, we signed off on it being okay, along with every other relevant department?

[–] [email protected] 11 points 1 month ago (2 children)

The update that crashed things was an anti-malware definitions update, Crowdstrike offers no way to delay or stage them (they are downloaded automatically as soon as they are available), and there's good reason for not wanting to delay definition updates as it leaves you vulnerable to known malware longer.

[–] [email protected] 8 points 1 month ago (4 children)

You could look into using a download manager. No reason for you to manually start each download in sequence if there's a way to get your computer to automatically start the next as soon as one finishes.

view more: ‹ prev next ›