Resource AFL Fantasy spreadsheet - 2022

[Jivlain]

And we're back!

No Freako email so far, no FootyWire update, the AFL doubling and tripling down on its frantic insistence that humans may not, under any circumstances, have usable access to any data, my database structure screaming with the torture of a thousand souls... and yet the spreadsheet shambles on, zombie-like. It literally cannot be stopped.

AFL Fantasy spreadsheet 2020 edition - round 1

Plus an ownership column.

 

[Jivlain]

AFL Fantasy spreadsheet - round 2

 

[Chris99]

AFL Fantasy spreadsheet - round 2

Thanks again mate! Just a quick question. How accurate are the price changes? You've got Adams getting 60 over his BE but dropping 1k?

 

[Jivlain]

Thanks again mate! Just a quick question. How accurate are the price changes? You've got Adams getting 60 over his BE but dropping 1k?

Not very, by the looks of things! So: BE I get from (currently DT Live), they should be reasonable. The estimated price is the formula I developed a few pages back, but I haven't really evaluated it in light of this season's data. They look generally pessimistic (average price change of -$13.5k, which I don't believe). I'll look into that (not before the weekend though).

 

[Jivlain]

AFL Fantasy spreadsheet - round 3

Removed the prediction columns. Will evaluate them once I have some time. Also killed the availability column because the AFL site is just soooooo bad I don't want to interact with it long enough to write a scraper anymore.

 

[Jivlain]

AFL Fantasy spreadsheet - round 4

 

[Jivlain]

AFL Fantasy spreadsheet - round 5

 

[Jivlain]

AFL Fantasy spreadsheet - round 6

 

[honeyball]

AFL Fantasy spreadsheet - round 6

This is quite brilliant

 

[Jivlain]

AFL Fantasy spreadsheet - round 7

 

[Jivlain]

AFL Fantasy spreadsheet - round 8

 

[Jivlain]

FYI, this will not be ready for the first game. Will try to update it as soon as possible.

 

[Jivlain]

AFL Fantasy spreadsheet - round 9

 

[Jivlain]

AFL Fantasy spreadsheet - round 12

I'm going to see if I fiddle things around so I can at least do a partial update ahead of the "rounds" in Frenzy Mk II, but no promises.

 

[Jivlain]

AFL Fantasy spreadsheet - round 13

 

[jim_shoes]

does anyone know where you can find the starting position from each bounce? eg. center square, wing, F50, D50

 

[Jivlain]

AFL Fantasy spreadsheet - round 14

 

[Jivlain]

AFL Fantasy spreadsheet - round 17

 

[FlowersByIrene]

Great work Jivlain!

 

[FlowersByIrene]

Hey Jivlain did you do this for 2021?

 

[Jivlain]

Hey Jivlain did you do this for 2021?

No. To be honest I was using it less and less myself, and then when I redid how I maintain my stats databases (see links in signature) for 2021 I didn't include a spreadsheet export. I'm currently having a think about what I do actually want in a spreadsheet and will be looking at that over the new year period, which may mean a new thing for 2022. We'll see.

 

[Keystone agony]

I'm interested in

Fantasy points per venue? If there is significant difference based on 2021

Fantasy points night games vs day games. Obviously a definition would need to be produced

 

[Jivlain]

Here's a sneak preview of what I've been working on. It's not yet live on my men's game site, but you can see how it works on AFLW Stats.
I'll be adding more functionality over time and feel free to give feedback.

 

[flaps]

Here's a sneak preview of what I've been working on. It's not yet live on my men's game site, but you can see how it works on AFLW Stats.
I'll be adding more functionality over time and feel free to give feedback.

Huge. Looks aewsome.

 

[Jivlain]

It's now also live on the men's site
AFL Stats Fantasy