Posted by: Tree
- Donor [491019157] Sat, Nov 15, 2003, 09:03
everyone please check your numbers carefully - i'm having some problems with the excel spreadsheet as it mysteriously inserted some "merged cells" into itself, and i'm not sure how to fix it...woohoo!
1
Tree Donor
ID: 22105158 Sat, Nov 15, 2003, 09:05
STANDINGS
Position
Position
Most
TOTAL
Position
Last Week
2 Weeks
Team
Owner
Recent Wk
Pts
Pts Behind
1
1
1
Rock Out With Your Brock Out
Tree
89
1256
-
5
5
5
Old Italian Disorder
Mist
133
1224
32
2
2
3
Rolling Thunder
Wiggs
80
1192
64
4
4
4
Team Not Feeling Creative Yet
Farn
68
1120
136
3
3
2
It's Not for Everyone
Mike D
56
1105
151
7
7
6
Endangered
Species
88
968
288
6
6
7
Flying Jalapenos
MITH
57
926
330
8
8
8
Eight Henchmen
Goat Locker
88
912
344
9
9
9
Controlled Destruction
Kev
51
645
611
11
11
11
Sponge Bob Square Circle
Sponge
76
618
638
12
12
12
Fock Fear, Drink Beer
Adam H
46
550
706
10
10
10
Never Leave Your Buddy's Behind
Great One
12
540
716
2
Tree Donor
ID: 22105158 Sat, Nov 15, 2003, 09:07
Overall Scoring
Eight Henchmen
Goat Locker
Season
This week
InEligible Pts
Total
A-Train
151
15
0
151
D-Von Dudley
245
21
0
245
Rene Dupre
178
25
0
178
Doug Basham
245
27
0
245
Charlie Haas
68
0
0
68
Christopher Nowinski
0
0
0
0
Johnny Stamboli
25
0
5
30
Rico
0
0
60
60
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
912
88
65
977
Average
152.00
14.67
10.83
162.83
It's Not For Everyone
Mike D
Season
This week
InEligible Pts
Total
Kane
162
4
0
162
Tajiri
270
5
0
270
Jazz
0
0
0
0
Zach Gowan
74
0
2
76
RVD
404
45
0
404
Lance Storm
130
2
0
130
Jeff Hardy
0
0
0
0
Shannon Moore
50
0
26
76
Spike Dudley
15
0
20
35
Hardcore Holly
0
0
7
7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
1105
56
55
1160
Avg per week
184.17
9.33
9.17
193.33
The Flying Jalapenos
MITH
Season
This week
InEligible Pts
Total
Vince McMahon
153
4
0
153
Trish Stratus
196
2
0
196
Nunzio
0
0
25
25
Rodney Mack
69
0
0
69
Rey Misterio
12
0
0
12
Kevin Nash
0
0
0
0
Rikishi
25
0
0
25
Al Snow
67
0
0
67
Chris Jericho
310
21
0
310
William Regal
0
0
0
0
Scotty 2 Hotty
0
0
0
0
Matt Morgan
37
5
10
47
Nova
0
0
0
0
Sakoda
57
25
0
57
TOTAL
926
57
35
961
Avg per week
154.33
9.50
5.83
160.17
Fock Fear, Drink Beer
Adam H
Season
This week
InEligible Pts
Total
Jamie Noble
0
0
76
76
Nidia
12
0
19
31
Gail Kim
196
25
0
196
Golddust
19
0
0
19
Triple H
155
10
0
155
Stone Cold Steve Austin
129
9
0
129
Val Venis
39
2
0
39
Hulk Hogan
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
550
46
95
645
Avg per week
91.67
7.67
15.83
107.50
Rolling Thunder
Wiggs
Season
This week
InEligible Pts
Total
Goldberg
368
28
0
368
Batista
99
25
5
104
Ric Flair
211
0
0
211
Garrison Cade
125
2
0
125
Kurt Angle
223
20
0
223
Stacey Keibler
72
5
0
72
Edge
0
0
0
0
Jim Ross
94
0
6
100
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
1192
80
11
1203
Avg per week
198.67
13.33
1.83
200.50
Sponge Bob Square Circle
Sponge
Season
This week
InEligible Pts
Total
Shelton Benjamin
26
0
0
26
Sylvian Grenier
80
0
0
80
Lita
116
19
104
220
The Rock
2
0
0
2
Booker T
76
32
92
168
Farooq
105
0
0
105
Rob Conway
188
25
0
188
Ivory
25
0
0
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
618
76
196
814
Avg per week
103.00
12.67
32.67
135.67
Endangered
Species
Season
This week
InEligible Pts
Total
Chris Benoit
306
37
0
306
Christian
225
24
0
225
Matt Hardy
78
0
0
78
Shane McMahon
138
8
0
138
Scott Steiner
221
19
0
221
Billy Gunn
0
0
0
0
Paul London
0
0
19
19
Nick Dinsmore
0
0
0
0
Scotty 2 Hotty
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
968
88
19
987
Avg per week
161.33
14.67
3.17
164.50
Old Italian Disorder
Mist
Season
This week
InEligible Pts
Total
Test
111
0
5
116
Palumbo
30
0
0
30
Undertaker
180
0
0
180
Bradshaw
210
30
0
210
John Cena
254
35
0
254
Mick Foley
0
0
0
0
Mark Henry
238
19
0
238
Nathan Jones
20
10
37
57
John Heidenreich
65
2
0
65
Shawn Michaels
116
37
0
116
Nunzio
0
0
12
12
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
1224
133
54
1278
Avg per week
204.00
22.17
9.00
213.00
Never Leave Your Buddy's Behind
Great One
Season
This week
InEligible Pts
Total
Shawn Michaels
142
0
0
142
Rhyno
42
0
0
42
Torrie Wilson
19
0
11
30
Ultimo Dragon
55
0
15
70
Chris Jericho
36
0
0
36
Orlando Jordan
17
0
20
37
William Regal
0
0
0
0
Steven Richards
66
0
0
66
Nunzio
0
0
20
20
Rey Misterio
163
12
0
163
Test
0
0
0
0
Palumbo
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
540
12
66
606
Avg per week
90.00
2.00
11.00
101.00
Team Not Feeling Creative Yet
Farn
Season
This week
InEligible Pts
Total
Big Show
331
22
0
331
Victoria
81
0
0
81
Rosie S.H.I.T.
89
12
0
89
Jerry Lawler
0
0
95
95
Eddie Guerrero
328
2
0
328
Molly Holly
189
25
0
189
Stephanie McMahon
38
0
36
74
Shaniqua
64
7
30
94
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
1120
68
161
1281
Avg per week
186.67
11.33
26.83
213.50
Rock Out With Your Brock Out
Tree
Season
This week
InEligible Pts
Total
Buh-Buh Ray Dudley
245
21
0
245
Chavo Guerrero
178
17
0
178
Mark Jindrak
47
2
78
125
Brian Spanky Kendrick
0
0
5
5
Brock Lesner
412
22
0
412
Maven
132
0
0
132
Danny Basham
235
27
0
235
Nikita
0
0
0
0
Travis Bane
0
0
0
0
Akio aka Jimmy Yang
7
0
40
47
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
1256
89
123
1379
Avg per week
209.33
14.83
20.50
229.83
Controlled Destruction
Kev
Season
This week
InEligible Pts
Total
Eric Bischoff
117
6
0
117
Billy Kidman
27
0
0
27
The Hurricane
83
12
34
117
Jonathan Coach Coachman
84
0
14
98
Randy Orton
265
27
0
265
Sable
54
4
4
58
Sean O'Haire
2
0
0
2
Paul Heyman
13
2
23
36
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
645
51
75
720
Avg per week
107.50
8.50
12.50
120.00
Free Agents
Season
This week
Total
0
0
0
0
Miss Jackie
20
0
20
Jacquiline
12
0
12
Spike Dudley
12
0
12
Theodore Long
58
5
58
Terri
32
14
32
Dawn Marie
24
0
24
Moolah
32
0
32
Mae Young
7
0
7
Michael Cole
23
0
23
Tazz
28
0
28
Tommy Dreamer
20
0
20
Josh Matthews
7
0
7
Arch "Sexual Intellectual" Kincaid
12
0
12
John Walters
12
0
12
Cousin Jose (aka "El Vato" Joni Chingas)
2
0
2
Linda McMahon
22
0
22
Midget Angle
5
0
5
Scotty 2 Hotty
25
0
25
Ryan Sakoda
15
0
15
Hardcore Holly
2
0
2
Funaki
5
0
5
LeBron James
5
0
5
Fred Bone Crusher Sampson
8
4
8
Priest (not Holmes nor Judas)
4
2
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
392
25
0
392
Avg per week
65.33
4.17
65.33
3
Tree Donor
ID: 22105158 Sun, Nov 16, 2003, 09:26
definitely having a merged cell problem...some of these numbers are right, some are not - which of course, is making it all the more confusing...so, possibly disregard this week's standings i've posted, until i can figure this out...
since i'm not 100 percent sure what a merged cell is and how it got there, i'm not sure how to fix it...this calls for a second cup of coffee! wheeeeeeeeeeeeeeeeeeeee
4
Tree Donor
ID: 22105158 Sun, Nov 16, 2003, 09:40
ok, let's try this again...in a bit i'm gonna try and post things in a new thread - but i'll leave this one up so you guys can see what's gone on - in a nutshell, excel kept trying to double this week's score, and i think i fixed it....it does change these originally posted standings a bit...
5
Great One Donor
ID: 298341017 Sun, Nov 16, 2003, 11:15
12. I scored 12 this week. Rock on.
6
Mike D Sustainer
ID: 23715270 Sun, Nov 16, 2003, 11:33
That actually might be 6, if the score was doubled. ;)
7
GoatLocker Sustainer
ID: 60151121 Sun, Nov 16, 2003, 12:10
Tree, A quick look shows that mine appears to be okay. If you need me to look at the file, send it to the email I listed and I'll try to check it sometime today.
Let me know where you think the problem is.
Cliff
8
Great One Donor
ID: 298341017 Sun, Nov 16, 2003, 13:03
Thanks Mike D. :) trying to cost me points?! haha... I am coming for ya... I predict I win this whole thing! now what! (maybe next year. I will have the number one pick at this rate).
9
Mike D Sustainer
ID: 23715270 Sun, Nov 16, 2003, 13:56
Only if you trade me Rey Rey, or maybe HBK. ;)
10
Great One Donor
ID: 298341017 Sun, Nov 16, 2003, 17:16
I moved HBK to get younger with the injured Test. Rey just isn't getting it done right now. I need to nail a waiver pick up or two or I will be so far in last place its ridiculous.
My only hope with potential bubbling under so to speak is Orlando Jordan right now.
11
Tree Donor
ID: 22105158 Sun, Nov 16, 2003, 20:19
GL - i think i figured it out - there were merged cells, and for reasons that i HAVEN'T figured out, it wasn't accepting the points in some columns....
i fixed it i think - using the help file - which seemed to fix it for me without telling me what it did....
i've got the numbers done, but spent most of the afternoon out of the house, so i'll post them later tonight or tomorrow sometime...