- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
So, for the frist one, I'm guessing no one at TDWTF has ever seen a fuzzy search, then?
Admin
For most use cases, it's not a great fuzzy search. It's very effective when searching for file names, function names, etc. Perhaps the word 'heavy' doesn't occur, and thare the low scoring results?
Admin
I suppose one interpretation of Virgin Atlantic's situation is that the 787 disappeared without a trace somewhere over the ocean and they hastily substituted a 737 they already had in the USA. So they flew it triumphantly to JFK for the big pre-planned media reception and hoped nobody would notice the sleight of hand.
Now that's a magic trick worthy of David Copperfield. ;)
Admin
In Excel, you can set a custom error alert title for the data validation rule, which seems to be the case here.
Admin
Did they by any chance try to fly via Bermuda... :-)
Admin
I've posted a question about that search over on the Eve Online subreddit, just to see if there is a reason for the search to work that way. I can't think of one, but I haven't touched that game in about a decade.
I'll let you know if I get any useful responses.
Admin
Somehow in flight they lost 50 of whatever those are measuring.
Admin
If you look at the results, he got a bunch of "Navy Issue" ships, with the "avy" in "Navy" matching the "avy" in "heavy". They also all have "h" and "e" in that order in the name before "Navy". It's even highlighted the matching letters in the results to clue you in to what's going on. Given that I can't think of any ships in Eve Online that have the word "heavy" in them, this is probably as close as it could get.
Admin
The real WTF is the cost of an MRI... Seriously, the problem with healthcare in the US isn't so much the health insurance system, but the sheer cost of medical acts. Nowhere else in the world does an MRI cost $2800! It's 4 times as expensive as, say, in France or in Canada.
Admin
That excel message is just terribly worded to start with, even ignoring the title.
"Someone set..."!? Just say "The data validation rule on this cell requires you to choose an item from the drop-down list." Concise. To the point. Not written like some awful attempt at a short story.
Admin
"The problem isn't the health insurance system... but the things that are caused by the health insurance system"
Admin
That search is
LIKE '%h%e%a%v%y%'
, man!Admin
I just checked in-game and no, it matches both perfect matches, partial matches and anything that happens to have those letters in the name.
Admin
@mallard ref
Again, that message is not an Excel message. It's written by the person(s) who wrote and formatted the spreadsheet, not MSFT.
Yes it's incompetent UI design. As is nearly everything ordinary people create with Excel.
Move along, people! Nothing to see here.
Admin
thanks for info
Addendum 2024-08-15 20:18: While exploring options for optimizing my programmatic ad buying, I found a comprehensive guide on SmartyAds that was incredibly helpful. The blog post titled top dsp https://smartyads.com/blog/10-best-dsps-that-define-programmatic-buying lists the top demand-side platforms (DSPs) and explains what makes each one stand out in the industry. This article is a must-read for anyone looking to make informed decisions when selecting a DSP to maximize their advertising efficiency and reach.