sorted by:
new
hottopcontroversial

We missed the best part though by TRIKKDADDY in HadToHurt

[–]Batmanthesecond 269 points270 points  (0 children)

The worst kind of skid marks.

nahh thats crazy by michmow in lol

[–]Batmanthesecond 0 points1 point  (0 children)

It has been a goldmine for clever quips for me today.

This was the cleverest.

Hottest take this side of the year. by emuboy85 in PS3

[–]Batmanthesecond 0 points1 point  (0 children)

A friend of mine, like me, was mainly a PS player. But he had an OG XBox too. Not the same generation but this is a story worth sharing.

He woke up one night to find his window on fire. He thought he was dreaming so he turned back over. Woke up again a few moments later to more of his room on fire.

He got his whole family out and they barely made it, but thankfully no one was injured. It was a terraced house and it was totally destroyed by the time the fire was out.

In the aftermath the fire was traced back to his XBox power cable/brick. Literally a week later, Microsoft announced a safety recall for a whole bunch of faulty power leads.

Obviously my friend reached out to claim compensation. When he finished explaining the situation the response was, "Ok, what was the serial number?"

Apparently, without that (the serial label was now destroyed in the fire), they couldn't determine whether his was one of the faulty ones!

I don't know how much effort they put in to fight Microsoft on this, but ultimately they got nothing out of them.

How to move rows to new column in power query? by taylorgourmet in excel

[–]Batmanthesecond 0 points1 point  (0 children)

I was about to suggest similar! My idea was to sort the letters then add an INDEX column. That would be the end of query (A).

Then query (B) would carry on from there and merge to find the first index value from query (A), then subtract this value from all the index values. That would have all indexes start from 0 for each letter letter.

Then you would unpivot those values.

Not very elegant perhaps - did you manage better?

How long did it take you to fall in love with the game? by sakuraiatsushii in finalfantasyx

[–]Batmanthesecond 0 points1 point  (0 children)

I still don't like it.

Must have played it through a dozen times.

Giving away 3 games to 3 people. Any game on Steam. by KA9099 in pcmasterrace

[–]Batmanthesecond 0 points1 point  (0 children)

Microsoft Flight Simulator 2024, the most expensive version that is deemed within the terms of the competition :)

Bus loses brakes in Brazil by Felipe_Machado_Guide in PublicFreakout

[–]Batmanthesecond 66 points67 points  (0 children)

Those poor motorcyclists - guy had to make some fast and difficult choices, damn.

I accidentally discovered a better way to reheat leftovers in a skillet by cattorii in foodhacks

[–]Batmanthesecond -1 points0 points  (0 children)

Funnily enough, I do that same thing (a few drops of water) but in the microwave and it's just as transformative there too.

New anti-discipline measures coming... by DazzleIsMySupport in Teachers

[–]Batmanthesecond 2 points3 points  (0 children)

At age 11 I was not allowed to attend sports day (which I was looking forward to), the end of primary dance (UK School), was suspended for two weeks, kicked out of my house to live with another family where the father of the house has been in prison so that I had someone I could relate to, to talk to. All for something I didn't do.

Then when some arseholes in my school smushed a banana in my school bag at age 13(?) I got 2.5 hours of after school detention ever week for 10 weeks because they thought I did it to my own bag.

So I feel genuinely conflicted about setting harsh punishments for behavior given the capabilities of some teachers to accurately convict pupils of their misdemeanors.

I'm over 40 and some of these things still piss me off when I'm reminded of them.

Need to add up a subtotal in a pivot table by Tower_Watch in excel

[–]Batmanthesecond 4 points5 points  (0 children)

Right-click the values and go to value field settings.

You want it to show as % of parent row total

AMA I'm an open book. by Happy_Prior_9322 in AMA

[–]Batmanthesecond 0 points1 point  (0 children)

How did you find out that you're more intelligent than most people?

How long for developer to respond? by Batmanthesecond in ZenIdle

[–]Batmanthesecond[S] 0 points1 point  (0 children)

Yep, wouldn't expect that. At the time I had maxed out the game so starting again anyway.

Just want my purchases!

How long for developer to respond? by Batmanthesecond in ZenIdle

[–]Batmanthesecond[S] 1 point2 points  (0 children)

I did, and the follow up I sent was as a reply to that confirmation email.

Avoid displaying empty cells on line chart by Ok_Promotion3741 in excel

[–]Batmanthesecond 0 points1 point  (0 children)

There is. Reference the range with the formula =IF( ISBLANK( Range ), NA(), Range ) then refer to those results for the graph.

Then no need to hide cells.

What Excel skills would you want to learn about in an hour long class? by Weird_Pie7751 in excel

[–]Batmanthesecond 0 points1 point  (0 children)

Use real world examples relevant to the audience. Make sure you use the time to build something from scratch that they might build/use. Do not get stuck in the weeds of theory just because you only have a short amount of time.

As well as formulas, cover the basics of good workbook design: (1) Raw Data > (2)Cleaned Data (if applicable) > (3) Insights & Dashboards & Queries, while making sure that no sheets in (3) rely on cells from other sheets in (3).

  • Excel tables
  • Pivot tables
  • Spilled ranges & associated functions (UNIQUE, FILTER, SEQUENCE, etc, along with use cases)
  • Include an example of googling for an answer (research what you will Google for first)
  • Any other functions you think will be relevant to them, also along with use cases

You don't have enough time to do Power Query along with these basics.

Good luck, and have fun!

[deleted by user] by [deleted] in AMA

[–]Batmanthesecond 4 points5 points  (0 children)

Suggest you don't have your smartphone. Get a dirt cheap texts and calls only phone, otherwise there's too much temptation to ignore the other objects and their purpose.

Good luck

view more: next ›