I've been working on this spreadsheet for a while. I've got some of the ideas off stephen247 spreadsheet and the TS website. It contains a trade path page where you can experiment how and when you're going to use your trades (as well as how your team will look heading into each round), score prediction, a bye planner and a hot and cold streaks page. If you are interested just PM (friend request if your not a friend already) your email address and I'll send it to you.
I just had a look at the spreadsheet tonight for the first time. Thanks heaps for putting it all together. Not sure if I understand it all properly, but it will help still
FR sent! I'll see what I can add from my existing spreadsheet One thing that I thought of is getting all the excel wizards together in a sort of open source arena to create the mother of all spreadsheets... people think there are yeards in this?
Great idea bandit. I did a bye planner which has been incorporated in to this one - and had thoughts much along your lines about seeing if we can get a collective group of excel people together to deliver a ripper. Obviously there are some smart minds out there (and I not including myself in that) so I think it would be a great project... (for next year!).
<blockquote>Quote from stephen247 on March 21, 2012, 12:29 Great idea bandit. I did a bye planner which has been incorporated in to this one - and had thoughts much along your lines about seeing if we can get a collective group of excel people together to deliver a ripper. Obviously there are some smart minds out there (and I not including myself in that) so I think it would be a great project... (for next year!).</blockquote> Agree, one for next year... but interested to see who want to contribute to it... aware that people will come up with absolute wishlists, but if there is a core group of guys/girls (say 4-6) to put in the inital functionality and then we can manage the wishlist from there!
Nothing to add; just got a laugh out of gravenger and redsheeps photo's above. < though perhaps the spreadsheet could include voting on best TS team name and funniest photo? >
Alright lads, getting to the pointy end of this season, and I have been knocked out of my comps! Keen to get a collective together of excel people to work on a master sheet for the TS members (read that as donors) to get their hands on for the 2013 season. We can use some of the great features of the spreadsheet that was sent around at the start of the year, and add to them (might even consider a wishlist but I know how out of control they can get!) Anyone keen to give me a hand in putting it together? Drop me a note and we can kick it around over October/November.
@bandit, not sure where my excel skillset can help but always happy to assist. @SCSS, thanks heaps for providing this to everyone this season. To demonstrate how well it worked for me, over the byes I went from being in 7,742 position overall to 427 just from planning my team, the donuts (or lack thereof) and upgrades over that period and i owe it all to your spreadsheet. Did mean i missed Zorko cos he didnt fit at the time, but did mean i held strong on my strategy for the whole season...