| Posted by: Great One
- [120252515] Tue, Feb 05, 2013, 10:39
Talent | Season Total | Wiggs | Wiggs | | | Alberto Del Rio | 351 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Sheamus | 305 | Daniel Bryan | 288 | Randy Orton | x | 91 | 91 | | 261 | 261 | Kane | 284 | Ryback | x | 59 | 59 | | 149 | 149 | Dolph Ziggler | 266 | Daniel Bryan | x | 124 | 124 | | 288 | 288 | Randy Orton | 261 | Dolph Ziggler | x | 115 | 115 | | 266 | 266 | Big Show | 229 | Brodus Clay | x | 25 | 25 | | 52 | 52 | Damien Sandow | 217 | Christian | x | 0 | 0 | | 0 | 0 | Cody Rhodes | 215 | Kassius Ohno | | 0 | 0 | 0 | 0 | 0 | Wade Barrett | 205 | Jack Swagger | | 35 | 0 | 35 | 0 | 35 | John Cena | 192 | Ezekiel* | | 0 | 0 | 0 | 0 | 0 | CM Punk | 188 | tbd | | 0 | 0 | 0 | 0 | 0 | Antonio Cesaro | 177 | tbd | | 0 | 0 | 0 | 0 | 0 | The Rock | 164 | tbd | | 0 | 0 | 0 | 0 | 0 | Ryback | 149 | tbd | | 0 | 0 | 0 | 0 | 0 | Kaitlyn | 142 | tbd | | 0 | 0 | 0 | 0 | 0 | Heath Slater | 133 | tbd | | 0 | 0 | 0 | 0 | 0 | Great Khali | 128 | tbd | | 0 | 0 | 0 | 0 | 0 | The Miz | 128 | Total | | 449 | 414 | 35 | 1016 | 1051 | Jinder Mahal | 103 | RJ | 3MB… Baby!!! | | | Drew McIntyre | 102 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Lord Tensai | 97 | Kofi Kingston | 97 | Drew McIntyre | x | 26 | 26 | | 26 | 102 | Paul Heyman | 89 | Jinder Mahal | x | 22 | 22 | | 42 | 103 | Chris Jericho | 82 | Heath Slater | x | 32 | 32 | | 133 | 133 | AJ Lee | 81 | Paul Heyman | x | 28 | 28 | | 89 | 89 | Titus O'Neil | 80 | AJ Lee | x | 25 | 25 | | 81 | 81 | Darren Young | 73 | Brad Maddox | | 0 | 0 | 0 | 9 | 9 | Ricardo Rodriguez | 66 | Bo Dallas | x | 61 | 61 | | 61 | 61 | Bo Dallas | 61 | Jimmy Uso | | 0 | 0 | 0 | 0 | 47 | Big E. Langston | 59 | Mark Henry* | | 0 | 0 | 0 | 0 | 0 | Natalya | 55 | tbd | | 0 | 0 | 0 | 0 | 0 | Zack Ryder | 52 | tbd | | 0 | 0 | 0 | 0 | 0 | Brodus Clay | 52 | tbd | | 0 | 0 | 0 | 0 | 0 | Rey Mysterio | 49 | Santino Marella | | 0 | 0 | 0 | 0 | 38 | Jey Uso | 47 | Natalya | | 0 | 0 | 0 | 134 | 55 | Jimmy Uso | 47 | Rey Mysterio | | 0 | 0 | 0 | 0 | 49 | Sin Cara | 44 | Alberto Del Rio | | 0 | 0 | 0 | 104 | 351 | Dean Ambrose | 40 | Total | | 194 | 194 | 0 | 679 | 1118 | Seth Rollins | 40 | Nailer | Team Little Jimmy's Awesome Fruity Pebbles | | | Roman Reigns | 40 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Santino Marella | 38 | Eve Torres | 36 | John Cena | x | 95 | 95 | | 192 | 192 | Jack Swagger | 35 | The Miz | x | 26 | 26 | | 128 | 128 | Vickie Guerrero | 33 | R-Truth | x | 0 | 0 | | 0 | 0 | Primo Colon | 32 | Zack Ryder | x | 22 | 22 | | 52 | 52 | Rosa Mendes | 27 | Kofi Kingston | x | 47 | 47 | | 47 | 97 | Booker T | 27 | Layla | | 5 | 0 | 5 | 2 | 7 | Hornswaggle | 26 | Undertaker | | 0 | 0 | 0 | 0 | 0 | Epico | 22 | Alberto Del Rio | x | 121 | 121 | | 247 | 351 | Goldust | 22 | Ric Flair* | | 0 | 0 | 0 | 0 | 5 | Aksana | 20 | tbd | | 0 | 0 | 0 | 0 | 0 | Alicia Fox | 20 | tbd | | 0 | 0 | 0 | 0 | 0 | David Otunga | 20 | tbd | | 0 | 0 | 0 | 0 | 0 | Tamina | 15 | tbd | | 0 | 0 | 0 | 0 | 0 | Alex Riley | 10 | tbd | | 0 | 0 | 0 | 0 | 0 | Curt Hawkins | 10 | Justin Gabriel | | 0 | 0 | 0 | 0 | 10 | JTG | 10 | Natalya | | 0 | 0 | 0 | 15 | 55 | Justin Gabriel | 10 | Total | | 316 | 311 | 5 | 683 | 897 | Michael McGillicutty | 10 | Zyre | The Embassy | | | Yoshi Tatsu | 10 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Brock Lesnar | 10 | Cameron | 10 | Sheamus | x | 110 | 110 | | 305 | 305 | Naomi | 10 | Seth Rollins | x | 20 | 20 | | 40 | 40 | Brad Maddox | 9 | Cody Rhodes | x | 86 | 86 | | 215 | 215 | Teddy Long | 9 | Paige Turner | | 0 | 0 | 0 | 0 | 0 | Mick Foley | 7 | Rey Mysterio | x | 49 | 49 | | 49 | 49 | Layla | 7 | Big Show | x | 51 | 51 | | 143 | 229 | Ric Flair | 5 | Big E. Langston | | 25 | 0 | 25 | 0 | 59 | Matt Striker | 5 | Kaitlyn | x | 15 | 15 | | 122 | 142 | Alex Shelley | 0 | Leo Kruger* | | 0 | 0 | 0 | 0 | 0 | Batista | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Beth Phoenix | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Bray Wyatt | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Bret Dibiase | 0 | Eve Torres | | 0 | 0 | 0 | 36 | 36 | Brie Bella | 0 | Jinder Mahal | | 0 | 0 | 0 | 61 | 103 | Camacho | 0 | Lord Tensai | | 0 | 0 | 0 | 0 | 97 | Christian | 0 | Tamina | | 0 | 0 | 0 | 0 | 15 | Conor O'Brian | 0 | Total | | 356 | 331 | 25 | 971 | 1290 | Derrick Bateman | 0 | Greg Rude | Rude's Ravishers | | | tbd | 0 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Edge | 0 | Evan Bourne | 0 | Titus O'Neil | x | 41 | 41 | | 56 | 80 | Ezekiel | 0 | Justin Gabriel | x | 0 | 0 | | 0 | 10 | HBK | 0 | Roman Reigns | x | 20 | 20 | | 40 | 40 | Hunico | 0 | Johnny Curtis | x | 0 | 0 | | 0 | 0 | Jerry Lawler | 0 | Epico | x | 0 | 0 | | 22 | 22 | Jim Duggan | 0 | Vickie Guerrero | | 19 | 0 | 19 | 14 | 33 | Jim Ross | 0 | Naomi | | 10 | 0 | 10 | 0 | 10 | John Laurinaitis | 0 | Santino Marella | x | 21 | 21 | | 21 | 38 | Johnny Curtis | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Josh Matthews | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Kassius Ohno | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Kelly Kelly | 0 | Kofi Kingston | | 0 | 0 | 0 | 0 | 97 | Kevin Nash | 0 | Tyson Kidd | | 0 | 0 | 0 | 0 | 0 | Leo Kruger | 0 | The Rock | | 0 | 0 | 0 | 0 | 164 | Mark Henry | 0 | CM Punk | | 0 | 0 | 0 | 104 | 188 | Mason Ryan | 0 | Booker T | | 0 | 0 | 0 | 0 | 27 | Michael Cole | 0 | Total | | 111 | 82 | 29 | 257 | 709 | Michelle McCool | 0 | Farn | Oh Well | | | Nikki Bella | 0 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | Percy Watson | 0 | Regal | 0 | Lord Tensai | x | 57 | 57 | | 97 | 97 | R-Truth | 0 | Sin Cara | x | 44 | 44 | | 44 | 44 | Sakamoto | 0 | Tamina | x | 15 | 15 | | 15 | 15 | Samoa Joe | 0 | David Otunga | x | 20 | 20 | | 20 | 20 | Steamboat | 0 | Michael McGillicutty | x | 0 | 0 | | 10 | 10 | Steve Austin | 0 | Primo Colon | x | 0 | 0 | | 32 | 32 | tbd | 0 | Triple H | | 0 | 0 | 0 | 0 | 0 | Shelton Benjamin | 0 | Mason Ryan | | 0 | 0 | 0 | 0 | 0 | John Morrison | 0 | Alex Shelley* | | 0 | 0 | 0 | 0 | 0 | Paige Turner | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Carlito | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | tbd | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | tbd | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Ted Dibiase Jr. | 0 | tbd | | 0 | 0 | 0 | 0 | 0 | Trent Barreta | 0 | Big Show | | 0 | 0 | 0 | 86 | 229 | Triple H | 0 | Kaitlyn | | 0 | 0 | 0 | 20 | 142 | Tyson Kidd | 0 | Total | | 136 | 136 | 0 | 324 | 589 | Undertaker | 0 | TREE | The United Nation of Procrastination | | | Velvet Sky | 0 | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | | | | | Wade Barrett | x | 61 | 61 | | 205 | 205 | | | Antonio Cesaro | x | 47 | 47 | | 177 | 177 | | | CM Punk | x | 67 | 67 | | 84 | 188 | | | Darren Young | | 24 | 0 | 24 | 49 | 73 | | | Ricardo Rodriguez | x | 27 | 27 | | 66 | 66 | | | The Rock | x | 117 | 117 | | 137 | 164 | | | Brock Lesnar | | 10 | 0 | 10 | 0 | 10 | | | Shelton Benjamin | x | 0 | 0 | | 0 | 0 | | | Steamboat* | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | Tyson Kidd | | 0 | 0 | 0 | 0 | 0 | | | Titus O'Neil | | 0 | 0 | 0 | 24 | 80 | | | Total | | 353 | 319 | 34 | 742 | 963 | | | Great One | The Ministry of darkness | | | | | Active | Total This Week | Active Team Points | Other Points | YTD Team Points | YTD Total Points | | | | | Kane | x | 120 | 120 | | 284 | 284 | | | Damien Sandow | x | 88 | 88 | | 217 | 217 | | | Dean Ambrose | x | 20 | 20 | | 40 | 40 | | | Carlito | x | 0 | 0 | | 0 | 0 | | | Great Khali | x | 56 | 56 | | 128 | 128 | | | Jey Uso | x | 0 | 0 | | 47 | 47 | | | Chris Jericho | | 82 | 0 | 82 | 0 | 82 | | | John Morrison | | 0 | 0 | 0 | 0 | 0 | | | Bray Wyatt* | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | tbd | | 0 | 0 | 0 | 0 | 0 | | | Drew McIntyre | | 0 | 0 | 0 | 76 | 102 | | | Total | | 366 | 284 | 82 | 792 | 900 | | | Free Agents | | This Week | | | | YTD Points | | | Aksana | | 0 | | | | 20 | | | Alex Riley | | 0 | | | | 10 | | | Alicia Fox | | 0 | | | | 20 | | | Batista | | 0 | | | | 0 | | | Beth Phoenix | | 0 | | | | 0 | | | Bret Dibiase | | 0 | | | | 0 | | | Booker T | | 0 | | | | 27 | | | Camacho | | 0 | | | | 0 | | | Cameron | | 0 | | | | 10 | | | Conor O'Brian | | 0 | | | | 0 | | | Curt Hawkins | | 0 | | | | 10 | | | Eve Torres | | 0 | | | | 36 | | | Edge | | 0 | | | | 0 | | | Evan Bourne | | 0 | | | | 0 | | | Goldust | | 0 | | | | 22 | | | HBK | | 0 | | | | 0 | | | Hornswaggle | | 0 | | | | 26 | | | Hunico | | 0 | | | | 0 | | | Jerry Lawler | | 0 | | | | 0 | | | Jim Duggan | | 0 | | | | 0 | | | Jim Ross | | 0 | | | | 0 | | | John Laurinaitis | | 0 | | | | 0 | | | Josh Matthews | | 0 | | | | 0 | | | JTG | | 0 | | | | 10 | | | Kelly Kelly | | 0 | | | | 0 | | | Kevin Nash | | 0 | | | | 0 | | | Matt Striker | | 0 | | | | 5 | | | Michael Cole | | 0 | | | | 0 | | | Michelle McCool | | 0 | | | | 0 | | | Mick Foley | | 0 | | | | 7 | | | Natalya | | 0 | | | | 55 | | | Percy Watson | | 0 | | | | 0 | | | Regal | | 0 | | | | 0 | | | Rosa Mendes | | 0 | | | | 27 | | | Sakamoto | | 0 | | | | 0 | | | Samoa Joe | | 0 | | | | 0 | | | Steve Austin | | 0 | | | | 0 | | | tbd | | 0 | | | | 0 | | | tbd | | 0 | | | | 0 | | | Ted Dibiase Jr. | | 0 | | | | 0 | | | Teddy Long | | 0 | | | | 9 | | | Tyson Kidd | | 0 | | | | 0 | | | Velvet Sky | | 0 | | | | 0 | | | Yoshi Tatsu | | 0 | | | | 10 | | | | | | | | | | |
| 1 | Great One
ID: 120252515 Tue, Feb 05, 2013, 10:40
|
Standings | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | Wk7 | Wk8 | Wk9 | Wk10 | Wk11 | Wk12 | Wk13 | Wk14 | Wk15 | Wk16 | Wk17 | Wk18 | Total | Zyre | 166 | 225 | 219 | 331 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 941 | Rude | 96 | 86 | 55 | 82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 319 | Nailer | 58 | 127 | 172 | 311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 668 | wiggs | 173 | 198 | 231 | 414 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1016 | GO | 127 | 184 | 197 | 284 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 792 | RJ | 198 | 62 | 121 | 194 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 575 | Farn | 106 | 32 | 50 | 136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 324 | Tree | 140 | 126 | 157 | 319 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 742 | | Regular Season | Regular Season | Regular Season | Regular Season | Regular Season | Regular Season | End Regular Season | Semi-Final | Semi-Final | Semi-Final | Finals | Finals | Finals | RWF Super Bowl | Finals | Finals | Finals | Finals | Grand Total | | | | | Royal Rumble | | | Elimination Chamber | | | End Round 1 | | | | Wrestlemania | | | | | | | | | | | | | | | | | | | | | | | | | |
|
|
| 2 | wiggs
ID: 221138912 Tue, Feb 05, 2013, 22:16
|
Not sure if its an option or how hard it would be, but is it possible to do the standings in order? If not, no problem is asking
|
|
| 3 | GO
ID: 300542419 Tue, Feb 05, 2013, 22:36
|
Yeah, its kind of a pain in the butt to do it cause everything is a formula. And when you sort systematically it doesn't bring the corresponding colors along with it correctly. So I have to one by one copy the row and re-order (and remember to not save those changes permanently).
|
|
| 4 | Greg Rude
ID: 150282923 Tue, Feb 05, 2013, 22:57
|
Thanks for doing this GO
|
|
| 5 | wiggs
ID: 221138912 Wed, Feb 06, 2013, 16:40
|
ok- then dont worry about it. I dont want it to be a pain in the butt. Just wanted to see my name on the top- its been a while and who knows how long it will last lol
|
|
| 6 | GO
ID: 300542419 Wed, Feb 06, 2013, 22:12
|
I'll play around with it and see if I can come up with something. But I try to remember to order when its i.e. end of regular season and maybe the week before.
|
|
| 7 | Tree
ID: 1910562515 Thu, Feb 07, 2013, 01:26
|
GO -
you sure about that color issue? if you're using excel, when you sort, the colors should absolutely move along with how you sorted it.
|
|
| 8 | Great One
ID: 120252515 Thu, Feb 07, 2013, 08:50
|
The colors may stick but the formulas don't match up so when I got close to figuring out a workaround (which I can't remember now how the colors were an issue).
The problem with sorting that chart is that formulas on other tabs are pointed at those cells. So if I move Wiggs Week 4 out of C4 -- and a formula on another page is looking for Wiggs/W4 in C4 and now he's up to A4 -- its not gonna be the same thing. Its going to populate someone else's score that week. So I think I can do it as it is but have to be careful not to save it.
I also played around with rewriting the forumula to look at the names instead of the cell # -- but haven't been successful yet.
|
|
|