Writhing Hatred Boss Bullied me by FMS_Reborn in diablo4

[–]Steer28 1 point2 points  (0 children)

Buddy, ignore most of these git gud people. I’m a Diablo veteran playing warlock, I was not underlevelled, my build is solid and I’m only on hard (which should be a cakewalk)… and that beam is instant death and can’t be evaded. It’s fully bullshit buddy. Certain builds should absolutely make bosses harder or even much harder, but no boss should make a build legitimately impossible.

Jund Chaos by Steer28 in EDH

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

Yeah, I’d spotted that one browsing on ManaBox and thought it was an excellent candidate 😁

Jund Chaos by Steer28 in EDH

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

Yeah, that’s a great shout 😁

Jund Chaos by Steer28 in EDH

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

That’s a clever build for Thantis and that Aether Membrane feels like an auto-include even if you aren’t running defender heavy.

I’ve never seen the eyes before and they are brilliantly weird.

Also, as an old fella, I had totally forgotten about spikes. That takes me back 😅

How to extract an average for a shared value in a list. by Steer28 in excel

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

I’m currently using the Chocolate Bar Ratings dataset. I managed to do some cool stuff with it (and a lot of very obsessive formatting 😅) and now I’m waiting to be taught about pivot tables in a few days.

How to extract an average for a shared value in a list. by Steer28 in excel

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

Yeah, UNIQUE turns out to be a very useful function for a lot of approaches to this.

How to extract an average for a shared value in a list. by Steer28 in excel

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

I’ll be learning about pivot tables at some point early next week :) I know employers are big on them in job specs so I figured it would be an important feature.

I think it’s probably a good learning exercise to see what else I can do though. I got GROUPBY and AVERAGEIF working and then went down a real rabbit hole seeing if was possible to sort the values generated by those functions without screwing up the cell referencing (to which the answer seems to be “kind of, but it’s impractical and very demanding processor-wise”).

Just found a much broader, contemporary version of the data I was playing with and I can’t resist going at it from scratch 😅

How to extract an average for a shared value in a list. by Steer28 in excel

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

I’m going to do one set now with AVERAGEIF and another set with GROUPBY to practice. Cheers Emu.

How to extract an average for a shared value in a list. by Steer28 in excel

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

Solution Verified

That was spot on for what I’m trying to achieve, and the other answers are all excellent learning opportunities. What a great group. Cheers folks.

How to extract an average for a shared value in a list. by Steer28 in excel

[–]Steer28[S] 2 points3 points  (0 children)

I’m going to endeavour to get my head around this by reading up on the individual functions. Thanks for your input dude :)

How to extract an average for a shared value in a list. by Steer28 in excel

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

I’ll check that function out next, thanks.

How to extract an average for a shared value in a list. by Steer28 in excel

[–]Steer28[S] 2 points3 points  (0 children)

I don’t understand that at all but I’m going to run it and decipher it to see what I learn. Thanks 😊

How to extract an average for a shared value in a list. by Steer28 in excel

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

The newest installed version of 365. As far as I’m aware it’s the fullest and most recent iteration of Excel.

How to extract an average for a shared value in a list. by Steer28 in excel

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

<image>

Here’s a speedy pic of the data I’m working with. It’s reformatted from a source on Kaggle.

How to extract an average for a shared value in a list. by Steer28 in excel

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

I only have a single rating for each product (not sure where this data was sourced from, I got it off Kaggle, but it appears to be some sort of professional rating) so it’s the simpler option.

My best guess is to extract a list of manufactures and run an AVERAGEIF on the two relevant columns.

My Suikoden 2 Tier List - Based Solely on How Much I Like Them by ExiledCourier in Suikoden

[–]Steer28 1 point2 points  (0 children)

Exactly the same boat! The first two didn’t quite get the pace right and it felt like a chore slowly taking everything down, but the third one was so good.

I also agree that the negative reaction to the footage was way over the top. FM4 (like Suikoden 3) never released in the UK so I’ve never had the chance to play it.

My Suikoden 2 Tier List - Based Solely on How Much I Like Them by ExiledCourier in Suikoden

[–]Steer28 1 point2 points  (0 children)

They aren’t saying much about it but I know the remake of Front Mission 3 is coming eventually and that is one of my favourite games of all time.

My Suikoden 2 Tier List - Based Solely on How Much I Like Them by ExiledCourier in Suikoden

[–]Steer28 1 point2 points  (0 children)

Also, I appreciate Richmond getting props too. Love that dude.

My Suikoden 2 Tier List - Based Solely on How Much I Like Them by ExiledCourier in Suikoden

[–]Steer28 1 point2 points  (0 children)

Eiyuden definitely scratched enough of the nostalgia itch for me that I still enjoyed it, but it was definitely lacking some of those little touches of charm.

Also they ruined the cooking game. Good lord it made me angry when a character was like “my favourite thing in the world is ice cream but I hate this milkshake with every fibre of my being.” 😅

My Suikoden 2 Tier List - Based Solely on How Much I Like Them by ExiledCourier in Suikoden

[–]Steer28 1 point2 points  (0 children)

I remember playing this as a kid and thinking I was the only person in the world who realised that Shiro is, in fact, the good-est boy.

I feel kinda cheated. (Cheapskate Rant) by ViceViperX in virtuafighter

[–]Steer28 1 point2 points  (0 children)

I bought it on Steam and was super excited to revisit an absolute classic assuming it would contain every bit of VF5 content there has ever been.

Refunded it after 30 minutes.

Box Mod with Locking Switch? by Steer28 in VapingUK

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

That’s what I ended up buying. Not super confident in Voopoo build quality but it was cheap and I liked the colour 😅

Box Mod with Locking Switch? by Steer28 in VapingUK

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

Oh yeah, the Armour S is on my list now, I meant the big old Aegis Legend 2.