![]() |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
I'm still waiting on Kettering awards before posting final Week 1 scores, but here are the current totals:
rtfgnow: 621 Basel A.: 560 Chris is Me: 556 EricH: 547 Vikesrock: 513 Barry Bonzack: 510 dodar: 478 Bethany Mc.: 440 Koko Ed: 387 Josh Fox: 366 Tim Delles: 360 Karibou: 347 Alex has a commanding lead, with consistent performances across the board. Basel isn't too far off the pace powered by getting the entire Alamo winning alliance with Chris and Eric right on his tail. The rest of us have some catchup to do, but it is only week 1. |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
This is great. Are you planning on putting names next to the owners? I suggest a column for each tier in a column before the team number, then using a SUMIF() formula to automatically calculate the scores. If you want me to do a page as an example let me know, but i'm a tad busy this week with the Florida Regional.
|
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Quote:
|
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Quote:
Your idea sounds interesting and may be a bit easier, I'll look into it. I did the player scoring manually this week, looking to automate it will be something I work on either during the week or next weekend. |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Quote:
|
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Final Week 1 scores are done. Both the team/event sheet and player sheet can be found here:
http://www.chiefdelphi.com/media/papers/2463 I have automated the player scoring by making some modifications to Eric's workbook and using a long nasty formula to do matching by team and event to a single long list of the teams with event codes and scores. I will be going through and fixing up the rest of the weeks to look the same as week 1 and trying to catch any team changes made that are not currently in my copy. I hope to have an updated copy posted by the end of the night. |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Fully updated version posted.
Week 1 scores remained almost the same. I remembered I had listed WFFAs for Traverse City because FIRST listed (2) them. Michigan does not award WFFA at the district level according to the Michigan Rules Supplement and Kettering has none listed, so I removed them and changed the scores for teams 141 and 201. As far as I know this sheet should have the all of the latest changes incorporated. If any of your teams are incorrect please let me know. |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Now that I'm back...
First, thanks for automating the scoring. Second, I find it kind of, shall we say, wide of the mark, to say that the scores didn't change much. The following is what I have from your sheet (which does include Kettering): Code:
rtfgnow 725 |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Quote:
|
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Heh, a third of my points from one event.
|
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Quote:
I went from meh to Ultrafail in the blink of an eye. :( |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Yeah, but Pink's doing well in Florida last I checked. And you've got Simbotics in Pitt. You should be able to pull up a few spots this week.
It's next week you want to worry about--or should I just assume high rookie for Peachtree (3836 missing), Detroit (2673 missing), and/or West MI (862 missing)? |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
New York and Israel aren't finished yet and some Dean's List and WFFA's are missing, but here are your current standings:
Code:
Vikesrock 1103 |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Just to check: That score is just for this week, right? Because if it isn't, I think someone has some 'splainin' to do.;)
Also, I'm confused right now. I'm listed with 650 on the sheet, and 767 on the above list. It doesn't help that 1065's Quality award wasn't counted (Cell AC, the one for that award, is overlooked by the summing formula--you may want to rerun the numbers)--but that'll only give 665, leaving 102 points somewhere. I'd figure they're in San Diego, except that my reckoning gives more points than that... One further comment: Barry isn't in first yet.:ahh: That goes to the one person to break 1000 in a single week so far--and they've got over 100 points on Barry. |
Re: [FF]: 2011 Seaon Long Fantasy FIRST
Not sure why I posted the Week 2 numbers and called them "current standings", I either should have posted the standings, or called them the "Week 2 scores"
Nice catch on the Quality Award. That's a pretty big error on my part. Not only was the Quality Award not being counted, the Spirit award was being counted once at it's point value and once at the Quality point value. I'll fix up the scoring for all affected teams and post up the corrected sheet. A note I forgot in my previous post is any team listed in bold for a scored week 2 event is a random replacement for a missing team. |
| All times are GMT -5. The time now is 17:27. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi