What cheeses me off

[Gremlin]

I wonder if the data they're after is actually the response rate to the feedback survey request not the results of the survey itself.

My logic? People tend to not really respond if they have a good, average, expected or even somewhat below average transaction/experience. However, if people have a really bad experience they are more likely to take the time to complete the survey. So if all of a sudden your response rate increases from 0.5% to 1.5% it might indicate a problem worth investigating.

...and the delivery itself. If you don't get a bounceback, you have a legit email address. They can use that to match to marketing lists for other purposes entirely, including onselling data about you

 

[Pushka]

When you buy a cover for your iPad from Amazon with the description matching your model but don't get around to changing it until after the return date, and it's too small and now a waste

 

[CMA222]

When you buy a cover for your iPad from Amazon with the description matching your model but don't get around to changing it until after the return date, and it's too small and now a waste

If the product supplied does not match the description when you made the purchase, no matter how long (within reason) after you receive it, it is breach of the Australian Consumer Law related to sale by description. If it does not match the description it is a major failure under the ACL and the purchaser is entitled to a replacement or a refund, whichever the purchaser prefers. No time limit imposed by the supplier can override the ACL.

 

[Quickstatus]

Except that Amazon is a jungle and ACL is likely unenforceable when buying from an OS seller

 

[TheRealTMA]

Except that Amazon is a jungle and ACL is likely unenforceable when buying from an OS seller

You can still apply to Amazon to send it back, but, but the return postage is probably more than the cover is worth. IMHO just chalk it up to own error and buy a new one.

 

[RooFlyer]

WCMO are the nongs who developed MS Excel. It doesn't recognise dates prior to 1900 as it stores a date as the number of days that have elapsed since January 1, 1900 . However, it does recognise dates forward to 9999. I mean, really?

So dates in the nineteenth century & before can't be formatted as a 'date'. It remains as text, so, for instance, sorting a column of mixed dates will not work.

Appreciate @exceladdict pointing towards a work-around. You add 1,000 years to each date. As the way dates are 'calculated' by Excel is not straightforward, neither is the adding of 1,000 years, but when you get there, it works.

 

[exceladdict]

WCMO are the nongs who developed MS Excel. It doesn't recognise dates prior to 1900 as it stores a date as the number of days that have elapsed since January 1, 1900 . However, it does recognise dates forward to 9999. I mean, really?

So dates in the nineteenth century & before can't be formatted as a 'date'. It remains as text, so, for instance, sorting a column of mixed dates will not work.

Appreciate @exceladdict pointing towards a work-around. You add 1,000 years to each date. As the way dates are 'calculated' by Excel is not straightforward, neither is the adding of 1,000 years, but when you get there, it works.

Yeah excel's ability to deal with dates is not great. There's a plenty of good memes/reels going around about excel converting things to dates without asking.

Something that cheeses me off is getting mentally misdirected when misreading a notification. After a nice DM exchange with @RooFlyer earlier today, I was worried I had done something wrong when I first glanced at this:

 

[Flashback]

Yeah excel's ability to deal with dates is not great. There's a plenty of good memes/reels going around about excel converting things to dates without asking.

Something that cheeses me off is getting mentally misdirected when misreading a notification. After a nice DM exchange with @RooFlyer earlier today, I was worried I had done something wrong when I first glanced at this:

View attachment 383898

WCMO is where an Excel file has the region/language set to UK/AU for example, but when you open it in WebApp (rather than the desktop client) the dates display in US format...... One main reason why I'll set the format on a date field to dd-mmm-yy, so you can see you've entered one wrong.

 

[VPS]

Packing to come home after 8 weeks away. I hope the hotel cleaning staff like all the stuff I'm leaving behind

 

[JohnK]

YouTube, please note it is called "My Mix" for a reason and that reason is that it's My Mix, not what YouTube wants to be in My Mix.

Laptop not restarted for 16 days, I have a Chrome tab with My Mix and play this over and over by using backtab to go to beginning and play again.

Restart laptop and "My Mix' is now jumbled and contains songs that are not part of My Mix and songs I've not listened to in recent memory. FFS.

Oh and the stupid ads that play after each song. FFS. I'm really glad I can ignore any ad playing in front me. And by ignore I mean ignore. Next time ad plays its like I've never seen/heard the ad previously. I really hate ads. It's the main reason I stopped watching TV 15 years ago. That and the stupid recordings that pass as shows suitable to be watched by the masses.

 

[VPS]

People who pick up after their pooch then drop the bag into my bin. What makes me even more cheesed off is they live down the hill so why not simply take it home and put it in their own bin?

I live on a main road and can't see when the bin men have been and it's quite variable. There are a lot of cafes nearby and I get everything from half full coffee cups with plastic lids in my green bin to dog poo and in summer I'm supposed to have that sitting in my garage for two weeks. I've just printed and laminated some cards for the lids basically saying Eff off but a little bit more subtle than that

 

[Quickstatus]

You add 1,000 years to each date

Trigger warning - WGAtype of post following...

Then you may get cheesed off by another small matter which is the recurrence of leap years.

A Papal decree by a Pope called Greg resulted in thr catholic world gradually using the Gregorian calendar over the Julian Calendar from the 1500s. However the British Parliament by an Act adopted the Gregorian Calendar in the calendar reform of 1752 which included the start of the year being 1 Jan. This means English historical dates prior the 1752 can be really sketchy if Gregorian is used. The Greeks being Greek only caught up in 1920 or thereabouts.

WCMO is the period of rotation of the earth around the sun is not exactly 365.000 days. It's a stupid 365.24 yada yada. The Julian method of adding an extra year every 4 years mostly corrected the error . But it also had 11 more days in a year. The Gregorian took out the 11 days but the leap year issue is a little more complicated. Gregorian also had the leap year every 4 years except when the year was divisible by 100 and not 400 years. So I've heard it's better to offset by 2000 instead of 1000. Of course it may not matter for the individual use case. Again, WGA

 

[RooFlyer]

A Papal decree by a Pope called Greg resulted in thr catholic world using the Gregorian calendar over the Julian Calendar in the 1500s. However the British Parliament by an Act adopted the Gregorian Calendar in the calendar reform of 1752. This means English historical dates prior the 1752 can be really sketchy if Gregorian is used. The Greeks being Greek only caught up in 1920 or thereabouts.

I'm a genealogist, and have traced families back to 16th century, so all over the 1752 thing. Many parish churches just did their own thing wrt baptismal etc registers.

So I've heard it's better to offset by 2000 instead of 1000. Of course it may not matter for the individual use case.

My current date compilation are all in the 19th century, so 1,000 yrs does it for me.

PS . What's WGA?

 

[Quickstatus]

19th century

The excel nongs could have studied a bit of history and made 1 = 1750 when England did the Calendar reform act instead of the random 1900.

WGA = who gives a (for those who DGA ). Mrs QS stopped doing her genealogy when she discovered she likely was an illegitimate issue of an English earl - possibly the servant girl?. I think that cheesed her off. Eventually her forebears settled in NZ

 

[Quickstatus]

You can still apply to Amazon to send it back

But not enforceable under ACL if they don't.

 

[RooFlyer]

The excel nongs could have studied a bit of history and made 1 = 1750 instead of 1900 when England did the Calendar reform act.

I guess they can't change their definition of 'date' now, but you'd think they could add one more date function tool to accommodate <1900.

 

[Pushka]

I guess they can't change their definition of 'date' now, but you'd think they could add one more date function tool to accommodate <1900.

Microsoft updates all sorts of completely unnecessary and sometimes harmfully so, irrelevant stuff, but not to software that actually matters.

 

[Quickstatus]

they could add one more date function tool

I've heard it's due to some "floating point" implementation inaccuracies but I suspect they DGA
Some function like "DATE1752" would help...

 

[RooFlyer]

I've heard it's due to some "floating point"

It’s the baseline for dates that they established I guess from the start in some garage in California. Excel stores a date as the number of days that have elapsed since January 1, 1900 . If you’re a tech nerd in Paolo Alto, shy on earth would you ever need to consider a date before 1900?

 

[TheRealTMA]

But not enforceable under ACL if they don't.

No, didn't say that. But still worth a try. I have been successful in the past for a refund.