Warrior General Games

Ok here is the West Power Rankings. This is not whatsdafuses formula, but one he suggested a couple of weeks ago. I have to play golf soon so the ones for the east come out in 3 hours or so. Also these dont include upset rankings, so teams like the All Stars are rated to high. I will add in upset rsnkings for both conferences tommorow or maybe late tonight. But for now here are the Wests power rankings not including upsets.

West

1. Honolulu Beach Boys 12.09883144
2. Los Angeles Express 12.00656565
3. Long Beach Dub All Stars 11.95764507
4. Huskers Illustrated Bug Eaters 11.47141017
5. Chicago Inferno 11.20426816
6. Timpanogos Thunder 10.80024509
7. Possum Trot Plauge 10.16431966
8. Dallas Hitmen 10.08710635
9. Tana River Eworks 9.55062388
10. Minnesota Mountain Lions 9.40145
11. Eugene SLUGs 9.357080605
12. Seattle Buffalos 9.27150919
13. Franfurt Universe 8.38232323
14. Spokane Owls 8.35525846
15. Montana Crow 6.278877
16. Houston Toxins 5.57279659

These are the Weatern Conference ones. I encourage you to post your complains or insights here. Please note that as of right now these do not include upset rankings, so your team will move up or down when I add them. Thankyou, and the East is coming in about 3 hours.

Like in a hour soon or tomorrow soon?

hour soon

cool

LOL wise ass. my power ranking formula is 39-9 in 3 weeks. thats pretty good #'s.

I gave you the formulas but i hope your placing all the players in teh right spots.

qb1- b2
qb2- b3
hb1- b4
hb2- b5
fb1- b6
fb2- b7
wr1- b8
wr2- b9
wr3- b10
wr4- b11
te1- b12
te2- b13
c1- b14
c2- b15
lot1- b16
lot2- b17
rot1- b18
rot2- b19
lg1- b20
lg2- b21
rg1- b22
rg2- b23

nt1- b27
nt2- b28
dt1- b29
dt2- b30
lde1- b31
lde2- b32
rde1- b33
rde2- b34
lolb1- b35
lolb2- b36
mlb1- b37
mlb2- b38
rolb1- b39
rolb2- b40
cb1- b41
cb2- b42
cb3- b43
cb4- 44
ss1- b45
ss2- b46
fs1- b47
fs2- b48

i set up the first team to be in the "b" b column.... then you do the next in D... so on and so forth

almost done with west.

Originally posted by Whatsdafus
LOL wise ass. my power ranking formula is 39-9 in 3 weeks. thats pretty good #'s.

what s your fomula exactly. Because I am doing one that only includes starters. You posted it about 2 weeks ago.

Oh yea... forgot to tell ya, each players ranking is lvl x 5.

so if a qb is lvl 16 he is worth 80

team is in the b column

b24 Pass offense - ((B2+(B3*0.6)+B8+B9+(((B10+B11)/2)*0.6)+(B12/5)+((B13/5)*0.6)+((B14+B16+B18+B20+B22)/2)+(((B15+B17+B19+B21+B23)/2)*0.6))/2.7)
b25 Rush offense - (B4+(B5*0.6)+(B6/5)+((B7/5)*0.6)+((B14+B16+B18+B20+B22)/2)+(((B15+B17+B19+B21+B23)/2)*0.6))/2.2
b26 total offense - (B24+B25)/2

b49 pass def - (B41+B42+(((B43+B44)/2)*0.6)+((B45+B47)/2)+(((B46+B48)/2)*0.6)+((B31+B33)/2)+(((B32+B34)/2)*0.6)+((B35+B37+B39)/3)+(((B36+B38+B40)/3)*0.6))/4.25
b50 rush def - ((B27+B29)/2+(((B28+B30)/2)*0.6)+((B31+B33)/2)+(((B32+B34)/2)*0.6)+((B35+B37+B39)/3)+(((B36+B38+B40)/3)*0.6))/2.5
b51 total def- (B49+B50)/2

b52 total ranking - (B26+B51)/4

B2 to B23 is offensive players
b27 to B48 is defensive players

So what i did is in column A i wrote out all the positions and totals. in row 1 i wrote out all the teams names going across.

then you just plug in the formula for each totals and change them for each team. meaning that formula would above will only work for the data in column b. so for it to work for column d teams data you have to change all the B's in teh formula to D's

Understand?

Originally posted by therichone
Originally posted by Whatsdafus

LOL wise ass. my power ranking formula is 39-9 in 3 weeks. thats pretty good #'s.

what s your fomula exactly. Because I am doing one that only includes starters. You posted it about 2 weeks ago.

Do this formula. the one that only does starters is bullshit. its ranking a team on less then half of its players.

Here what is your email. i think if i email you my set up, all you will have to do is change the teams names and put in the teams data, the table will be set already.

Originally posted by Whatsdafus
Here what is your email. i think if i email you my set up, all you will have to do is change the teams names and put in the teams data, the table will be set already.

its ok i understand. just please dont edit any of your posts in this thread.

I edited to show you where to place the totals on your excel.... see the #'s?