Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Fantasy FIRST (http://www.chiefdelphi.com/forums/forumdisplay.php?f=128)
-   -   [FF]: 2011 Seaon Long Fantasy FIRST (http://www.chiefdelphi.com/forums/showthread.php?t=86343)

Vikesrock 06-03-2011 17:00

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.

Barry Bonzack 06-03-2011 19:36

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.

Koko Ed 06-03-2011 19:39

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Quote:

Originally Posted by Vikesrock (Post 1035627)
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.

If Barry is within 200 points of you then he's too close for comfort.

Vikesrock 06-03-2011 19:45

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Quote:

Originally Posted by Barry Bonzack (Post 1035724)
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.

My initial idea was to modify Eric's sheet so that the regional name was a merged cell and each team a player had was it's own cell. Then I was going to do a lookup using the teams and event code into a sheet containing a master list of all the teams, events and total scores.

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.

Barry Bonzack 07-03-2011 15:43

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Quote:

Originally Posted by Vikesrock (Post 1035627)

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

This is a much much better start than last year... ::devious grin::

Vikesrock 09-03-2011 18:07

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.

Vikesrock 09-03-2011 21:30

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.

EricH 11-03-2011 16:01

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


Vikesrock 11-03-2011 16:07

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Quote:

Originally Posted by EricH (Post 1037946)
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):

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.

Basel A 11-03-2011 16:17

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Heh, a third of my points from one event.

Koko Ed 12-03-2011 05:36

Re: [FF]: 2011 Seaon Long Fantasy FIRST
 
Quote:

Originally Posted by EricH (Post 1037946)
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
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


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

EricH 12-03-2011 11:50

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

Vikesrock 13-03-2011 07:49

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

EricH 13-03-2011 11:20

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.

Vikesrock 13-03-2011 11:28

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