Draft Review 21st Century draft game - full 22 edition

[Guardian Hawk]

 

[Purple7x08_24]

Lol I'm rubbish with Excel. SM, MWPP or Stokey are the go-to whizzes imo....

I just tried the formula as this as a test to see if it would work and it doesn't, Somethings wrong
It's frustrating because I'm following what it says to do.

 

[SM]

eth-dog I'm not as versed with countifs, but how do I set up the formula to count for both

"St Kilda" and "StK" I keep getting 0 as an output because I need to allow for part of the string (Say "Haw/StK") and I need to be able to add them)

Not having much luck with it.

Easiest way is to just make it a sum, i.e.

=COUNTIFS([Insert formula searching for St Kilda])+COUNTIFS([Insert formula searching for Stk])

 

[Purple7x08_24]

Easiest way is to just make it a sum, i.e.

=COUNTIFS([Insert formula searching for St Kilda])+COUNTIFS([Insert formula searching for Stk])

Still returns 0 so not sure what I'm doing wrong.

I used "St Kilda" and "Brisbane" Just to make sure it wasn't an issue with say "Haw/StK"

 

[Purple7x08_24]

Excel is so frustrating

 

[Purple7x08_24]

Solved with multiple (countif) Stupid Excel.

 

[SM]

Excel is so frustrating

View attachment 2063383

Think the biggest issue is that column F looks like it has a lot of variations. What you might be wanting to do if I understand you is count if a cell contains, but isn't limited to, St Kilda, for example. In which case you'd need to adjust your wording to be =COUNTIFS($F$2F$370,""&"St Kilda"&"",$F$2F$370,""&"Brisbane"&"")

Might not need the speech marks around St Kilda and Brisbane, so try both.

 

[SM]

Solved with multiple (countif) Stupid Excel.

View attachment 2063384

You mean exactly what I suggested doing?

 

[SM]

Hang on just realised why it didn't work. COUNTIFS is a multiple criteria function, it means you were asking Excel to count all instances of column F being simultaneously St Kilda and Brisbane which is impossible, so of course it would return 0.
What you wanted to do is count if column F is St Kilda OR Brisbane. Which is why my initial suggestion of summing two count functions together made most sense.

You can't use COUNTIFS as if each criteria is a separate count, because COUNTIFS isn't just going to sum up all the criteria, it needs all criteria to be solved to count as 1 and it then counts up all the times all those criteria are met.

 

[Purple7x08_24]

You mean exactly what I suggested doing?

Yes I did change it but it still won't let me do it with countifs, It's just easier to individually do them with countif.
Thanks for the help

 

[ArdentEagle]

Mr Meow is it??

 

[Purple7x08_24]

Think the biggest issue is that column F looks like it has a lot of variations. What you might be wanting to do if I understand you is count if a cell contains, but isn't limited to, St Kilda, for example. In which case you'd need to adjust your wording to be =COUNTIFS($F$2F$370,""&"St Kilda"&"",$F$2F$370,""&"Brisbane"&"")

Might not need the speech marks around St Kilda and Brisbane, so try both.

Thanks. I used StK surrounded by asterix to do all instances but I seem to be missing one so might have a case sensitive entry there somewher.

 

[Purple7x08_24]

Hang on just realised why it didn't work. COUNTIFS is a multiple criteria function, it means you were asking Excel to count all instances of column F being simultaneously St Kilda and Brisbane which is impossible, so of course it would return 0.
What you wanted to do is count if column F is St Kilda OR Brisbane. Which is why my initial suggestion of summing two count functions together made most sense.

You can't use COUNTIFS as if each criteria is a separate count, because COUNTIFS isn't just going to sum up all the criteria, it needs all criteria to be solved to count as 1 and it then counts up all the times all those criteria are met.

BTW, I've sent Isaac Heeney to the Dockers.

 

[ArdentEagle]

BTW, I've sent Isaac Heeney to the Dockers.

What?

 

[SM]

BTW, I've sent Isaac Heeney to the Dockers.

Poor Dockers.

 

[Purple7x08_24]

Ahhh eth-dog


I'm doing my head in trying to work out why Gold Coast has incorrect numbering and there's an errant space at the end of the title. haha. Got me there.

 

[eth-dog]

Ahhh eth-dog


I'm doing my head in trying to work out why Gold Coast has incorrect numbering and there's an errant space at the end of the title. haha. Got me there.

You fix it?

 

[Purple7x08_24]

This was more of a headache than I thought.

Had to change all the Port Adelaide entries to Port, and Greater Western Sydney to GWS to make it work

 

[Guardian Hawk]

Sorry guys...this is my fault..got busy at work and didn't realise/remember that Mr Meow sent me his list overnight.

West Side Pavlovas select......Heretier Lumumba.

(Sorry Purple - it always has problems tagging you cos of the space but you're here anyway so I'm sure you'll see it )

 

[Purple7x08_24]

Fremantle with Pick 211 Select Rory Sloane



Rory Sloane

9

Rory Sloane

Age

36

Ht

183cm

Wt

87kg

Pos.

Mid

Career

Season

Last 5

D

23.7

5star

K

11.7

4star

HB

11.9

5star

M

3.5

4star

T

6.6

5star

CL

5.7

5star

D

15.3

4star

K

7.3

3star

HB

8.0

4star

M

1.3

1star

T

3.3

4star

CL

4.2

5star

D

22.2

5star

K

8.6

4star

HB

13.6

5star

M

3.2

4star

T

6.0

5star

CL

4.6

5star

—the man with the intensity of a thunderstorm and the work rate of a caffeinated squirrel. Let’s unravel why he was the heartbeat of the wing and the midfield, shall we?

1. The Winged Warrior:
   • Picture this: The sun dips low, casting elongated shadows across the MCG. Sloane stands on the wing, sleeves rolled up, eyes ablaze. His job? To be the link—the conduit between defense and attack. And oh, he did it with the flair of a tightrope walker in a cyclone.
   • Sloane’s wing play was like a symphony—each possession a note, each sprint a crescendo. He’d receive the ball, assess the field, and then—bam!—launch it forward like a slingshot loaded with hope.
2. The Midfield Dynamo:
   • Sloane wasn’t just a midfielder; he was the engine room personified. When the center bounces occurred, he’d burst forth like a greyhound chasing a mechanical rabbit. His legs pumped, his lungs burned, and the ball seemed magnetized to his hands.
   • His foot skills? Impeccable. His vision? Eagle-eyed. His ability to thread the needle through a maze of opponents? Magical. Sloane was the midfield’s maestro, conducting plays with a baton made of grit.
3. The Tackling Tornado:
   • Opponents feared the Sloane tackle. It wasn’t a mere collision; it was a seismic event. When he lunged, bodies crumpled like paper in a storm. Sloane’s tackles were like exclamation marks—bold, emphatic, and leaving no room for doubt.
   • And the sound? Oh, it echoed through stadiums—the thud of bodies meeting earth, the gasps from the crowd. “Did you see that Sloane tackle?” they’d whisper, wide-eyed.
4. The Heartbeat of Adelaide:
   • Sloane wasn’t just a player; he was the embodiment of the Crows’ spirit. When they sang the team song, his voice soared above the rest. His commitment was etched into every blade of grass at Adelaide Oval.
   • And when the chips were down, when the scoreboard taunted them, Sloane would gather his troops. “We fight,” he’d say. “We fight for every inch.” And they did, because Sloane’s words were gospel.
5. The Awards Cabinet Overfloweth:
   • Two Club Champion Awards? Check. All Australian honors? Check. Brownlow votes? Check. Sloane’s trophy shelf was like a museum of excellence.
   • But it wasn’t just about hardware. It was about the respect—the nods from opponents who knew they’d been in a battle. “Bloody Sloane,” they’d mutter, nursing bruises. “Bloody legend.”
6. The Unyielding Gaze:
   • Sloane’s eyes were like lasers. When he fixed them on an opponent, it was as if he’d dissected their soul. He’d read their intentions, anticipate their moves. His mind worked faster than a supercomputer crunching data.
   • And when he burst through packs, ball in hand, it was like watching a warrior emerge from the smoke—a hero in the chaos.

Sphynx

 

[eth-dog]

Sphynx

 

[Purple7x08_24]

Not too much bias

 

[Mr Meow]

There were a number of back flankers I could've gone for, but I couldn't ignore the sheer drive and territory Lumumba would give this team. Moving the ball at speed to our threats up forward is a priority. Attack will sometimes be the best form of defence in this line up. I also don't simply want a team bursting with current day players when I have options for suitable alternatives.

Team so far

FB: Stewart Frawley --
HB: Lumumba Sicily --
C: Hannebery Goodwin Embley
HF: -- Pavlich Deledio
FF: -- Hogan C.Cameron
FOL: -- Selwood Harvey

 

[RUNVS]

There were a number of back flankers I could've gone for, but I couldn't ignore the sheer drive and territory Lumumba would give this team. Moving the ball at speed to our threats up forward is a priority. Attack sometimes the best form of defence in this line up. I also don't simply want a team bursting with current day players when I have options for suitable alternatives.

Team so far

FB: Stewart Frawley --
HB: Lumumba Sicily --
C: Hannebery Goodwin Embley
HF: -- Pavlich Deledio
FF: -- Hogan C.Cameron
FOL: -- Selwood Harvey

Yes I think recency bias is a real thing. So easy to forget a player that retired in 2013 or something but had very good, but not great career.

 

[Mr Meow]

Yes I think recency bias is a real thing. So easy to forget a player that retired in 2013 or something but had very good, but not great career.

Exactly and in reality a lot of these half back flanker types who only had one official AA selection still had a good few years at a similar level. Lumumba was a sizeable component of that swarming Collingwood team that could turn defence into attack in a split second. You need a couple of players like him who can burst through congestion or receive a handball and get territory gained quickly. If you have strong contested players and crumbers ahead of the ball it works.

 

[Purple7x08_24]