View Single Post
  #249   Spotlight this post!  
Unread 02-03-2016, 21:26
ttldomination's Avatar
ttldomination ttldomination is offline
Sunny
no team
Team Role: Mentor
 
Join Date: Mar 2007
Rookie Year: 2007
Location: Roanoke, TX
Posts: 2,066
ttldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond reputettldomination has a reputation beyond repute
Re: [FF]: 2016 Season Long Fantasy FIRST

Folks, for this past week, I've been working on an automated scoring system to help everyone out.

Leveraging the power of pivot tables and a little bit of scripting, the end result is available by clicking here.

Just some of the sheets:
"ScoreTotal" - Total scores for all teams.
"ScoreByEvent" - Score breakdown for all FF teams by the event.
"ScoreByWeek" - Score breakdown for all FF teams by the competition week.
"Raw Picks" - All picks and points for each FF teams.

The rest of the sheets hold raw data, roll ups, and other information needed to power the autoscoring.

As of right now, this thing will (should) score regionals and districts and keep it up as the season goes on.

If there are any questions/suggestions I can field them here. Additionally, if you poke around and find any errors, let me know and I'll get them ironed out as soon as possible.

Thanks,
- Sunny G.

Edit: As a note, the scoring isn't real-time. The processing for gathering data can be manually kicked off.
__________________
1261: 2007-2012
1648: 2013-2014
5283: 2015

Last edited by ttldomination : 02-03-2016 at 21:29.
Reply With Quote