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