Go to Post Ah, free slave labor. One of the many benefits of being a mentor - Ari423 [more]
Home
Go Back   Chief Delphi > Other > Chit-Chat > Games/Trivia > Fantasy FIRST
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #13   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
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 22:20.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi