General Stats Questions & Requests Thread

[Hate]

Here is up til the end of S27 (not my work):

Dropbox

www.dropbox.com

Just note, on this version, the EXIE column is incorrect, and I never got to fix it. I usually put an updated version with new name changes found correct sometime shortly after the Grand Final.

 

[NaturalDisaster]

I should be able to work with what I have but appreciated anyway.

Oh ok, less work for me

 

[Tarkyn_24]

Just note, on this version, the EXIE column is incorrect, and I never got to fix it. I usually put an updated version with new name changes found correct sometime shortly after the Grand Final.

No stress, I won't be using it.

 

[JoshWoodenSpoon]

No stress, I won't be using it.

Wow. Hope you know it's impossible to judge anything without EXIE.

 

[Tarkyn_24]

Dropbox

www.dropbox.com

(is my work)

Also has lots of random shit probably not helpful or recognisable.

DOES NOT INCLUDE S28 FINALS

Hello friend - where do I take just the raw stat numbers for the season (ie. HO, K, M...) from in your spreadsheet? Or will I have to collate this myself using the imports you've already got?

Preferably just after Demon and Dragon data

 

[JoshWoodenSpoon]

Hello friend - where do I take just the raw stat numbers for the season (ie. HO, K, M...) from in your spreadsheet?

R1 -> R16 tabs. You'll have to VLOOKUP or whatever to tally for each player over the whole season, as I've only done it there for each player in each position they play as separate data. Can do that for ya if you'd like.

 

[Tarkyn_24]

R1 -> R16 tabs. You'll have to VLOOKUP or whatever to tally for each player over the whole season, as I've only done it there for each player in each position they play as separate data. Can do that for ya if you'd like.

Would it take you long? I'm sure I could do it myself but would need to think it through haha.

 

[JoshWoodenSpoon]

Would it take you long? I'm sure I could do it myself but would need to think it through haha.

Yup sure thing. Just gotta finish a beez writeup then I'll get to it.

 

[Tarkyn_24]

Yup sure thing. Just gotta finish a beez writeup then I'll get to it.

Much appreciated

 

[akkaps]

=SUMIF(player column, player name, ho column)

^tiis should do the trick

=SUMIF($A:$A,”Tarkyn_24”,B:B)

 

[Tarkyn_24]

=SUMIF(player column, player name, ho column)

^tiis should do the trick

=SUMIF($A:$A,”Tarkyn_24”,B:B)

Yep, this is what I'm using. Josh has his raw data over 16 tabs though, which is what I'm struggling to work with.

 

[NaturalDisaster]

Yep, this is what I'm using. Josh has his raw data over 16 tabs though, which is what I'm struggling to work with.

Typical Josh

 

[akkaps]

Yep, this is what I'm using. Josh has his raw data over 16 tabs though, which is what I'm struggling to work with.

Copy and paste all the data onto spreadsheet. Otherwise expand the formula to cover all 16 sheets.

 

[akkaps]

JoshWoodenSpoon , do you have data of which players at which position certain number of times.
So like, it’d come up as totals for each player under each position.
I’m on my phone at the moment, and it’s hard to fully see the spreadsheet you posted.

Planning to runs DT/Exie League over SoO and need this data for positions.

 

[Tarkyn_24]

Copy and paste all the data onto spreadsheet. Otherwise expand the formula to cover all 16 sheets.

True. I suppose I could do that...

 

[Tarkyn_24]

JoshWoodenSpoon , do you have data of which players at which position certain number of times.
So like, it’d come up as totals for each player under each position.
I’m on my phone at the moment, and it’s hard to fully see the spreadsheet you posted.

Planning to runs DT/Exie League over SoO and need this data for positions.

This is exactly what he has, each position with a separate tab.

 

[JoshWoodenSpoon]

JoshWoodenSpoon , do you have data of which players at which position certain number of times.
So like, it’d come up as totals for each player under each position.
I’m on my phone at the moment, and it’s hard to fully see the spreadsheet you posted.

Planning to runs DT/Exie League over SoO and need this data for positions.

Yep, that's there.



Yeah Tarks you're better off just doing it yerself. Chuck it one bulk page then SUMIF or VLOOKUP. You'll get it sooner than if you have to wait for me.

 

[Hate]

Tarkyn_24

Dropbox - Error - Simplify your life

www.dropbox.com

 

[JoshWoodenSpoon]

akkaps lemme know if you need anything sussed some more.


Also, be warned that there is a player called "2121" as well as a player called "2121 change your name u POS".

 

[Hate]

akkaps lemme know if you need anything sussed some more.


Also, be warned that there is a player called "2121" as well as a player called "2121 change your name u POS".

You don't like manually changing it each week?

 

[Tarkyn_24]

Excellent, thanks guys. Think I'm there.

 

[akkaps]

akkaps lemme know if you need anything sussed some more.


Also, be warned that there is a player called "2121" as well as a player called "2121 change your name u POS".

I’ve dealt with a lot worse at the BFFCL in regards to usernames.

 

[JoshWoodenSpoon]

Heya Mobbs, can a player who is not currently in the ruck position contest the ruck?

 

[Mobbs]

Heya Mobbs, can a player who is not currently in the ruck position contest the ruck?

No. They need to have been moved there. There is no second-they-up. Kennedy Parker might fix that, though.

 

[Pie 4 Life]

Bit of an obscure one for you Hate ...

Premierships in your 400th game list?