Farn Sustainer
ID: 451044109 Mon, Feb 02, 2004, 23:11
fancied it up a bit, mainly because its easier for me to just fill in the squares live.
No +5 for Batista or Flair at the end because they didn't interfere. All they did was run through the crowd.
Kane got 2 No Contests: one against Goldberg and one against Trish. I never heard a winner announced.
HBK's win was non-title.
2
Tree
ID: 5117220 Mon, Feb 02, 2004, 23:29
daaaaaaaaaaaamn, now THAT'S results...
maybe that's how we oughta do things next season - fill it in as you go, post it, email me the spreadsheet and i'll plug it into the larger spreadsheet, and we're good to go.
i appreciate the coverage farn. one thing i'm trying to do in my "time off" is come up with a way to make the top 20 more automatic....
3
Farn Sustainer
ID: 451044109 Mon, Feb 02, 2004, 23:32
yeah, that top 20 is too much to do in my eyes. I love it but the hassle seems to outweigh its usefulness.
The sheet above is as primative as it gets. So you would have to tweak it to make it work with the other one. But based on what you did with the standings SS my guess is that you could find a way to make the above chart work in some way with that one.
4
wiggs Donor
ID: 4991311 Tue, Feb 03, 2004, 02:05
farn, only problem i see is you forgot the title defense points for flair and batista.
5
Farn Sustainer
ID: 451044109 Tue, Feb 03, 2004, 09:45
good call wiggs.
Fixed it on my sheet.
6
Farn Sustainer
ID: 451044109 Tue, Feb 03, 2004, 13:38
Tree-
The sheet above, could you put that in the workbook with the standings and then set the week-by week worksheet to pick up the numbers right off the sheet I made above? The only problem I would see might be eligible/ineligible differentiation. It would have to be set to send it to the right part.
But if that could be done it might be pure gold. Even a couple of monkeys like wiggs and I could run it. :)
7
Species Leader
ID: 7724916 Tue, Feb 03, 2004, 13:45
Wow. Thanks Farn and wiggs. I wish I was more of an Excel guy....although if it's all automated, then any bozo could do it.
One suggestion......I like having the whole "roster" there.....but would it be hard to list the points of all of the participating wrestlers first, THEN do the non-participating wrestlers? That would be a cool feature to see WHO scored WHAT.....but still tell you who did NOT score.
8
Tree Donor
ID: 599393013 Tue, Feb 03, 2004, 14:05
The sheet above, could you put that in the workbook with the standings and then set the week-by week worksheet to pick up the numbers right off the sheet I made above? The only problem I would see might be eligible/ineligible differentiation. It would have to be set to send it to the right part.
Farn - i think you've helped close the gap in mind where i was having a hard time "connecting" things in regards to this...
in my spreadsheets, you'll see where i have the totals for all the wrestlers...i think if i put another page that calls the wrestlers names and points from a corresponding page, i may have to sort it.
the kink isn't so much eligible and ineligible points, as it is wrestlers who have been traded, because then it's culling points from two places, and for OVERALL points, those have got to be added....
i'm no excel whiz - someone on this board, probably RFS or someone - could have done this a lot easier, i'm sure. i'm just having fun learning and teaching myself as i go!
9
Farn Sustainer
ID: 451044109 Tue, Feb 03, 2004, 14:12
Species- I probably could but incase it wasn't clear I am not an Excel wiz. Maybe if Tree told me how to make it sort the name column and the points together so they wouldn't seperate I could pull that off. The reason I have it like that is so I can find their names easier.
Tree- well, if you are no whiz than wiggs and I are indeed monkeys. Because you certainly are way ahead of us.
I considered asking RFS to tidy it up but you would probably take a lot more pride in doing it yourself. Even if you don't have it ready til Season 3 its still better than nothing. Just take the Saturday mornings that wiggs and I freed up for ya and see what you can come up with.