Connect with us
Celebrating 20 seasons of AFL Fantasy fun in 2026

Resources

Pauliechoo’s Dream Team Template

VERSION 2.1 UPDATED! Pauliechoo has sent us a very handy spreadsheet for the Dream Team nerds out there like us. It is a team template worksheet, created in Excel, that lets you calculate your team scores based on their 2010 data and their 2011 NAB Cup/Challenge scores and more.

Pauliechoo has sent us a very handy spreadsheet for the Dream Team nerds out there like us. It is a team template worksheet, created in Excel, that lets you calculate your team scores based on their 2010 data and their 2011 NAB Cup/Challenge scores and more.

What you do is select your team using the drop down menus and then it will do the rest itself!

Thanks heaps Paul! This is a ripper!

Updates:

  1. Pre-season game count error fixed
  2. Pre-season DT averages fixed
  3. 2010 Average (column F) now populates with 2011 pre-season average for players with no 2010 data to reference.
  4. For players with no 2010 data, nor any 2011 pre-season data, a default score of 20 has been used.

If you have any questions, Paul will try to answer them here.

Co-captain of DT Talk since we started this thing in 2007. Best finish was 13th in 2009... that was a long time ago. Follow on Twitter: @WarnieDT and follow on Instagram: @warnedawgs.




Recent Comments

  • Matt on AFL Fantasy open for 2026: “Same. Good defenders and early buy tricky this year. My need to carry one. Ash for me.Jan 22, 12:36
  • Warnie on AFL Fantasy open for 2026: “No field view on phone, but there is on desktop – is your screen resolution small? App out next week,…Jan 22, 09:55
  • Warnie on AFL Fantasy open for 2026: “I like it, but my worry is easing him back in if Achilles. I reckon they go with a dual-ruck…Jan 22, 09:54
  • Warnie on AFL Fantasy open for 2026: “We kept saying it, and he never got one… I think he’s a watch for me to begin with due…Jan 22, 09:53
  • Matt on AFL Fantasy open for 2026: “Can say Ive ever seen NAS tagged. That makes me wary to pick himJan 22, 08:32

Podcasts

Advertisement

More in Resources