I'm ranking teams 3 different ways for HD and I need YOUR help to put together a solid, viable ranking. All I need for you to do to participate is to fill out this spreadsheet... http://spreadsheets.google.com/ccc?key=0ArJDwQU87BItdEI0TEZmMFdmNEtEWlR4UnZ2OGhmcnc&hl=en with all of your team's results, including regular season, CT, and any postseason tournament action. I will include any and all worlds, I myself am only in D2 Tarkanian so I intend to do my team and maybe a few others at random that I see fit.

BE SURE TO LIST YOUR TEAM NAME AS SUCH

Team-World-Season

i.e. Armstrong Atlantic State-Tark-41

MORE IMPORTANT INFO

If you could for the overall team ratings...put your overall team rating (512 or whatever) and then in parentheses, put your adjusted overall team rating (minus WE-DU-ST)...hell it'd probably be better if you put it in a new column altogether, but this is optional...I will be doing both for my team.

My email address is if it would be easier for you to just send a file that I can view with excel viewer. Thanks and hope we get some good stuff here.

P.S., A special thanks to fdny343 for suggesting that I setup a template for this project.

I'd like to do entire season with this thing...tournament and all...I think only doing the regular season + CT is valid as well, what do you guys think?

Schroedess26 where the hell are you? I figured you'd be the first one here copying and pasting this thing into your spreadsheet....come on let's go let's go let's go.

And before people go ape here, schroedess has been on my sack all day to get this thing up, so I'm jokingly digging at him as well, so heel.

Where are the formulas?

Little Bobby, and little Susie, have hung their stockings with care. Mom and Dad are out looking for Tickle-Me-Elmo 'til five a.m., and all of a sudden, Bobby looks up and he says, "Hey! Who is this Jesus?" Meanwhile, Kris Kringle
is drinking Coke! The reindeer are playing Nintendo! The elves are wearing Nike..! [ time-out buzzer sounds ]

sorry, no way I'm downloading a microsoft spreadsheet

might try just copying and pasting into a thread

what world do you want?

Why not publish it using Google Docs' spreadsheet? You can upload any MS Excel file to it it will automatically convert it. Just publish it and paste the URL so we can all use it.

Quote: Originally Posted By cornfused on 1/05/2010Where are the formulas

In my database where I'll compile it

Ok, I did what cthomas suggested, thanks man...here is the link...

http://spreadsheets.google.com/ccc?key=0ArJDwQU87BItdEI0TEZmMFdmNEtEWlR4UnZ2OGhmcnc&hl=en

Make the Google Doc public or we can't see it.

Quote: Originally Posted By cornfused on 1/05/2010Make the Google Doc public or we can't see it

Thanks, sorry, http://spreadsheets.google.com/ccc?key=0ArJDwQU87BItdEI0TEZmMFdmNEtEWlR4UnZ2OGhmcnc&hl=en

Quote: Originally Posted By fd343ny on 1/05/2010
sorry, no way I'm downloading a microsoft spreadsheet

might try just copying and pasting into a thread

what world do you want?

I'm in Tark, and its ending soon, so let's focus on that for now, but I'll do any and all...not necessarily looking for this thing to be "complete"

After we complete this, are you looking for folks to post them in this thread or something else?

working my way through inputting the data - except for the opponent info that still could change - and I have discovered that I did a great job at Oklahoma. We went 23-8, rpi 15 and got to sweet 16 despite the fact that we had a higher average player points in only 8 of our games......

now the truth is, we had some good IQs and our average is depressed by a walkon who didnt play....etc etc

by the way, a very simple adjustment to make this better would be to subtract up to say 2 walkons from the average - an easy calculation. If a team has more than 2 walkons then it begins to raise a question whether they can be excluded......in my opinion

let folks know if you want that done - otherwise the average rating data will be deeply confounded