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.