0
Subject: Season 15 Week 1 Standings & Stats -- Week 1
Posted by: Farn
- Leader [451044109] Sat, Apr 10, 2010, 12:31
Standings Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8 Wk9 Wk10 Total 1 wiggs 144 0 0 0 0 0 0 0 0 0 144 2 Species 147 0 0 0 0 0 0 0 0 0 147 3 Zyre 144 0 0 0 0 0 0 0 0 0 144 4 Mike D 121 0 0 0 0 0 0 0 0 0 121 5 Bobo 115 0 0 0 0 0 0 0 0 0 115 6 Rude 88 0 0 0 0 0 0 0 0 0 88 7 Farn 77 0 0 0 0 0 0 0 0 0 77 8 Great One 71 0 0 0 0 0 0 0 0 0 71 9 Tree 66 0 0 0 0 0 0 0 0 0 66 10 GoatLocker 40 0 0 0 0 0 0 0 0 0 40
1 Farn Leader
ID: 451044109 Sat, Apr 10, 2010, 12:31
Individual Scoring Wiggs Parts Unknown, Team Unknown Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 1 Big Show 76 2 Miz 76 Randy Orton x 37 37 37 37 3 Jack Swagger 65 Big Show x 76 76 76 76 4 David Otunga 64 Zach Ryder x 12 12 12 12 5 John Cena 47 Gail Kim x 17 17 17 17 6 Kane 45 Santino x 2 2 2 2 7 Darren Young 43 Brett DiBiase 0 0 8 MVP 40 Joe Hennig 0 0 9 Randy Orton 37 10 Wade Barrett 37 11 Ted Dibiase 35 12 Drew McIntyre 35 Total 144 144 0 144 144 13 Justin Gabriel 35 14 Heath Slater 32 Goatlocker Goatlockers Goons 15 Beth Phoenix 30 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 16 Sheamus 30 17 Eve Torres 30 Batista x 20 20 20 20 18 Tyson Kidd 25 Shelton Benjamin x 0 0 0 0 19 Yoshi Tatsu 25 Kofi Kingston x 15 15 15 15 20 Evan Bourne 25 Mickie James x 0 0 0 0 21 DH Smith 25 JTG x 5 5 5 5 22 Michael Tarver 25 Vance Archer 0 0 0 23 Carlito 25 Joey Mercury 0 0 24 Tyson Kidd 25 25 Layla 23 26 Edge 22 27 Chris Jericho 22 Total 40 40 0 40 40 28 Batista 20 29 John Morrison 20 MIKE D Your Worst Nightmare 30 Daniel Bryan 20 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 31 Jillian Hall 20 32 Alicia Fox 19 Miz x 76 76 76 76 33 Kelly Kelly 18 Cody Rhodes x 0 0 0 0 34 Gail Kim 17 Kane x 45 45 45 45 35 Caylen Croft 17 Ezekiel x 0 0 0 0 36 Trent Barreta 17 Vladimir Kozlov x 0 0 0 0 37 Katie Burchill 16 Primo 0 0 0 38 Kofi Kingston 15 Chris Masters 0 0 0 39 Matt Hardy 15 40 Christian 15 41 Brie Bella 15 42 Nicole Bella 15 Total 121 121 0 121 121 43 Michelle McCool 13 44 Rosa Mendes 13 Species The All-American Non-Americans 45 Vickie Guerrero 13 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 46 Zach Ryder 12 47 Chavo Guerrero 12 John Cena x 47 47 47 47 48 Skip Sheffield 7 Ted Dibiase x 35 35 35 35 49 Triple H 7 MVP x 40 40 40 40 50 Michael Cole 6 Tyson Kidd x 25 25 25 25 51 JTG 5 Finlay x 0 0 0 0 52 Rey Mysterio 5 Booker T 0 0 53 Maryse 5 Skip Sheffield 7 7 0 7 54 Shad Gaspard 5 55 Luke Gallows 5 56 CM Punk 5 57 Serena 5 Total 154 147 7 147 154 58 Jerry Lawler 4 59 Josh Matthews 4 Zyre Brothers of Destruction 60 Matt Striker 4 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 61 Nattie Neidhart 3 62 Santino 2 Drew McIntyre x 35 35 35 35 63 Dolph Ziggler 2 Matt Hardy x 15 15 15 15 64 Hornswaggle 2 Beth Phoenix x 30 30 30 30 65 Todd Grisham 2 David Otunga x 64 64 64 64 66 Brett DiBiase 0 William Regal x 0 0 0 0 67 Joe Hennig 0 Yoshi Tatsu 25 25 0 25 68 Shelton Benjamin 0 Melina 0 0 0 69 Mickie James 0 70 Vance Archer 0 71 Joey Mercury 0 72 Cody Rhodes 0 Total 169 144 25 144 169 73 Ezekiel 0 74 Vladimir Kozlov 0 Greg Rude Rude's Ravishers 75 Primo 0 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 76 Chris Masters 0 77 Finlay 0 Jack Swagger x 65 65 65 65 78 Booker T 0 Rey Mysterio x 5 5 5 5 79 William Regal 0 R-Truth x 0 0 0 0 80 Melina 0 Michelle McCool x 13 13 13 13 81 R-Truth 0 Maryse x 5 5 5 5 82 Mark Henry 0 Shad Gaspard 5 5 0 5 83 Undertaker 0 Heath Slater 32 32 0 32 84 The Great Khali 0 85 Kaval/Low Ki 0 86 Goldust 0 87 Dos Caras Jr. 0 Total 125 88 37 88 125 88 Abraham Washington 0 89 Courtney Taylor 0 Farn 7 People 90 Dusty Rhodes 0 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 91 Eric Escobar 0 92 Funaki 0 Christian x 15 15 15 15 93 Gregory Helms 0 John Morrison x 20 20 20 20 94 Jeff Hardy 0 Luke Gallows x 5 5 5 5 95 Jesse Dalton 0 Mark Henry x 0 0 0 0 96 Jim Ross 0 Wade Barrett x 37 37 37 37 97 Jimmy Wang Yang 0 Kelly Kelly 18 18 0 18 98 Maria 0 Chavo Guerrero 12 12 0 12 99 Mike Knox 0 100 Ranjin Singh 0 101 Savannah 0 102 Shawn Michaels 0 Total 107 77 30 77 107 103 Theodore Long 0 104 Tiffany 0 TREE International Cartel 105 Tommy Dreamer 0 Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points 106 Tony Atlas 0 107 Tyler Reks 0 Edge x 22 22 22 22 108 Vince McMahon 0 Chris Jericho x 22 22 22 22 Dolph Ziggler x 2 2 2 2 Daniel Bryan x 20 20 20 20 Undertaker x 0 0 0 0 Nattie Neidhart 3 3 0 3 Darren Young 43 43 0 43 Total 112 66 46 66 112 Bobo Straight Edged Shooters Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points Sheamus x 30 30 30 30 Evan Bourne x 25 25 25 25 DH Smith x 25 25 25 25 Justin Gabriel x 35 35 35 35 The Great Khali x 0 0 0 0 Michael Tarver 25 25 0 25 Kaval/Low Ki 0 0 Total 140 115 25 115 140 Great One Omega Thuganomics Active Total This Week Active Team Points Other Points YTD Team Points YTD Total Points Triple H x 7 7 7 7 CM Punk x 5 5 5 5 Carlito x 25 25 25 25 Caylen Croft x 17 17 17 17 Trent Barreta x 17 17 17 17 Goldust 0 0 0 Dos Caras Jr. 0 0 Total 71 71 0 71 71 Free Agents This Week Wk 1 Prev Total Pts Abraham Washington 0 0 0 0 Alicia Fox 19 19 0 19 Brie Bella 15 15 0 15 Courtney Taylor 0 0 0 0 Dusty Rhodes 0 0 0 0 Eric Escobar 0 0 0 0 Eve Torres 30 30 0 30 Funaki 0 0 0 0 Gregory Helms 0 0 0 0 Hornswaggle 2 2 0 2 Jeff Hardy 0 0 0 0 Jerry Lawler 4 4 0 4 Jesse Dalton 0 0 0 0 Jillian Hall 20 20 0 20 Jim Ross 0 0 0 0 Jimmy Wang Yang 0 0 0 0 Josh Matthews 4 4 0 4 Katie Burchill 16 16 0 16 Layla 23 23 0 23 Maria 0 0 0 0 Matt Striker 4 4 0 4 Michael Cole 6 6 0 6 Mike Knox 0 0 0 0 Nicole Bella 15 15 0 15 Ranjin Singh 0 0 0 0 Rosa Mendes 13 13 0 13 Savannah 0 0 0 0 Serena 5 5 0 5 Shawn Michaels 0 0 0 0 Theodore Long 0 0 0 0 Tiffany 0 0 0 0 Todd Grisham 2 2 0 2 Tommy Dreamer 0 0 0 0 Tony Atlas 0 0 0 0 Tyler Reks 0 0 0 0 Tyson Kidd 25 25 0 25 Vickie Guerrero 13 13 0 13 Vince McMahon 0 0 0 0
2 Farn Leader
ID: 451044109 Sat, Apr 10, 2010, 12:32
Please doublecheck your roster and its points. This is very much a work in progress for me so I'm bound to have spreadsheet errors. And thanks to Mike D for sharing his sheet and cutting down on the workload for me.
3 wiggs
ID: 35149919 Sat, Apr 10, 2010, 18:47
You have tyson kidd as a free agent and on species roster.
4 wiggs
ID: 35149919 Sat, Apr 10, 2010, 18:48
my team looks good
5 Farn Leader
ID: 451044109 Sat, Apr 10, 2010, 19:02
Thanks. Fixed.
6 Great One
ID: 39342317 Sat, Apr 10, 2010, 19:54
Mine looks good, except I'm in 8th place which is confusing to me... usually my name is in 1st!!!!
7 Farn Leader
ID: 451044109 Sat, Apr 10, 2010, 19:56
That's not a mistake. We all talked during the "offseason" and decided to hold you down this year.
8 Greg Rude
ID: 292433117 Sun, Apr 11, 2010, 02:37
Everything looks good except for whatever reason Species is listed 2nd place although he has the most points :) hehe
9 Farn Leader
ID: 451044109 Sun, Apr 11, 2010, 09:37
I wish I could figure out why excel won't let me sort the first number in a set. It does it with the individual points too. Always makes me fix it with cut and paste. If anyone is excel knowledgeable... whenever I hit the sort button it will rearrange every other cell that I'm sorting but the first one (wiggs in this case).
10 Tree
ID: 248472317 Sun, Apr 11, 2010, 10:45
do you have that frame frozen?
11 Farn Leader
ID: 451044109 Sun, Apr 11, 2010, 10:46
I guess that's possible? How do I see if its frozen or not?
12 Farn Leader
ID: 451044109 Sun, Apr 11, 2010, 11:14
Ok, figured that out. Its not a frozen frame situation. Anyone else have a suggestion?
13 Mike D Leader
ID: 041831612 Sun, Apr 11, 2010, 14:06
If you are talking about the wrestler individual scoring column it can be a little tricky because there are cell references built in to the cells, and sometimes the sort function messes those up. Sometimes it isn't worth the hastle of sorting them when you can quickly copy and paste the wrestler and their points via right clicks. At the beginning of the season it is a pain because week to week the order swings are big for the wrestlers. As the season progress the order stays relatively the same though and it can be done pretty quickly. You can always copy and paste the wrestlers and their points into Notepad, then re-copy and paste them into a seperate Excel sheet that is indentical and colored but has no cell references. Then save that page as a web page with the cell range and post it. Only problem is that it becoms separated from the other portion of the page----so you would have a separate post for the wrestlers, not combined with the all the teams' scoring like it is above. Back to your question---if you highlight the actual columns, and then choose sort--by "column B" for instance----it may capture all of the data as opposed to doing it by highlighting the wrestlers and their points.
Post a reply to this message: