[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.

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.

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):

rtfgnow    725
Barry Bonzack    685
Basel A    634
Vikesrock    622
Chris is me    620
EricH    601
Bethany Mc.    557
dodar    514
Josh Fox    489
Tim Delles    466
Karibou    464
Koko Ed    446

Sorry for the confusion. I was trying to convey that the final update that I posted had minor changes from the previous update which had included Kettering.

Heh, a third of my points from one event.

Wow.
I went from meh to Ultrafail in the blink of an eye. :frowning:

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)?

New York and Israel aren’t finished yet and some Dean’s List and WFFA’s are missing, but here are your current standings:


Vikesrock	1103
Barry Bonzack	974
Chris is me	831
Karibou	        817
Josh Fox	809
EricH   	767
rtfgnow      	765
dodar   	698
Basel A       	686
Koko Ed	        645
Bethany Mc.	547
Tim Delles	498

Updated sheets will be up momentarily. KC, San Diego and Duluth are the events missing Dean’s List and WFFA teams.

Just to check: That score is just for this week, right? Because if it isn’t, I think someone has some ‘splainin’ to do.:wink:

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.

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.

Updated sheets should be posted

Current Week 2 scores


Vikesrock	1103
Barry Bonzack	959
Chris is me	846
Karibou	        832
Josh Fox     	809
EricH	        782
rtfgnow	        780
Basel A	        701
dodar	        698
Koko Ed	        660
Bethany Mc.	547
Tim Delles	483

Overall Standings


Vikesrock	1710
Barry Bonzack	1659
rtfgnow	        1535
Chris is me     1527
EricH           1436
Basel A       	1365
Karibou	        1334
Josh Fox	1313
dodar	        1216
Bethany Mc.	1114
Koko Ed	        1108
Tim Delles	966

Vikes, I saw that you made some swaps in certain events. Did you make sure that they had been updated after the build season waiver results?

I checked to make sure the teams were available using the scoring sheet which should be fully updated.

I didn’t check if everybody else’s teams were correct in the threads or if the available teamlist was correct ::ouch::

Yep, I do my best to make sure everything is up to date.

So far, Week 3 issues:
Seattle:
Vikesrock: Cascade, missing team
Bethany Mc: Still waiting on what’s supposed to happen there… If anybody happens to contact her, it might be a good idea to mention that Skunkworks is one of the teams that switched events.

Koko Ed: Peachtree, 3836; Detroit, 2673; West MI 2, 862
dodar: West MI 1, 862
Basel A: Chesapeake, 2890
Bethany Mc: Chesapeake, 1708

And, just to get people thinking a bit, Week 4:

Koko Ed: Palmetto, 108
Chris is me: Oregon, 852
dodar: Oregon, 948, 2412

Just fix my missing teams with randoms.
I pretty much screwed anyways.

Got NYC scored, waiting on this information (plus Israel) to wrap up week 2:

[strike]Superior WFFA and confirmation of no Dean’s List[/strike]
[strike]San Diego WFFA and 1 Dean’s List[/strike]
New York WFFA and [strike]1 Dean’s List[/strike]

Either Ed or I have posts in the appropriate regional threads requesting the information so hopefully we can get it tracked down.

just give me randoms for my missing teams for week 3

Israel has been scored. Sheets will be updated very shortly.

Current standings:

Vikesrock	1984
Barry Bonzack	1814
Chris is me	1643
rtfgnow	        1621
EricH	        1580
Josh Fox	1534
Karibou	        1475
Basel A	        1416
dodar	        1309
Koko Ed      	1274
Bethany Mc.	1229
Tim Delles	1096

I’ll be running scores tomorrow, but I just wanted to get this up here to see if anyone objects.

The Coopertition Award at the Peachtree Regional was not awarded. This was an error as we (3573) put up 122’s minibot in our second to last qual match (and informed the volunteers whose mini it was). This was the only mini sharing at the event. After 122 won Chairman’s they didn’t want to bother finding out why the Coop wasn’t awarded, but I plan on scoring it for them.

Any objections?

I don’t object.

Now, if Seattle will just finish getting their match scores up…

Heads up:

Hawaii: Team 8 won’t be attending. That’ll be Chris and Josh needing to deal with that.
Oregon: Chris, 852 is missing.

All other Week 4 issues have already had random-team requests made.

Week 5:

Basel A: Livonia, 68
Bethany Mc: Las Vegas, 841
Tim Delles: Livonia, 322
Josh Fox, GTR East 2, 3683; Las Vegas, 3759; Smokey Mountain, 348

dodar and Ed also have missing teams, but have requested randoms.

Week 6:
rtfgnow: Dallas, missing team
Karibou: Virginia, 614