| 0 |
Subject: 2001 vs 2002 point totals for hitters
Posted by: Khahan
- [567232217] Mon, Mar 04, 2002, 22:13
I went to build my roster at TSN and was wondering how to get the most for my money. Obviously, just looking at where a player ranked last season will not work, because TSN now charges -2 per out instead of -1 per out. I compiled a list of the top 25 outfielders and looked at their At-bats, BA, Hits, Outs, 2001 formula points and 2002 formula points.
There were some surprises.
If somebody can suggest a way for me to post this (its in excel 97) other than with image hosting, I'll be more than happy to. For now a simple cut and paste is all I can do:
.
Player....... AB.. BA Hits Outs Old New % change
Barry Bonds 476 .328 156 320 3325 3005 .90
Sammy Sosa 577 .328 189 388 3082 2694 .87
Luis Gonzalz 609 .325 198 411 2887 2476 .86
Shawn Green 619 .297 184 435 2514 2079 .83
Larry Walker 497 .350 174 323 2449 2126 .87
Lance Brkmn 577 .331 191 386 2417 2031 .84
Bobby Abreu 588 .289 170 418 2373 1955 .82
Vlad Guerrer 599 .307 184 415 2349 1934 .82
Chipper Jone 572 .330 189 383 2297 1914 .83
Brian Giles.... 576 .309 178 398 2274 1876 .82
Cliff Floyd.... 555 .317 176 379 2248 1869 .83
Ichiro Suzuki 692 .350 242 450 2211 1761 .80
Mglio Ordnz 593 .305 181 412 2176 1764 .81
Ryan Klesko 538 .286 154 384 2166 1782 .82
Carlos Bltrn 617 .306 189 428 2120 1692 .80
Juan Gonzlz 532 .325 173 359 2094 1735 .83
Gary Sheffld 515 .311 160 355 2087 1732 .83
Manny Rmrz 529 .306 162 367 2081 1714 .82
Mike Cmrn 540 .267 144 396 1945 1549 .80
Jim Edmonds 500 .304 152 348 1919 1571 .82
Bernie Wliams 540 .307 166 374 1912 1538 .80
Jose Cruz Jr. 577 .274 158 419 1887 1468 .78
Moises Alou 513 .331 170 343 1837 1494 .81
Juan Pierre... 617 .327 202 415 1764 1349 .76
Garrt Andrsn 672 .289 194 478 1760 1282 .73
..
There are a few obvious things from this. The players with the most at-bats suffer the largest point swings (note Ichiro coming in 450 points lower with the 2002 formula).
What you do with the info is purely up to you guys. One thing I'm considering is walk totals. Obviously players who walk more will have less At-bats and as such less chances to record the -2 this year. To me, that greatly lowers the value of guys like Ichiro and Juan Pierre who hack at everything.
If anybody wants to make suggestions to improve the quality of info on the charts or the quality of how the charts look when I post them, please do so.
|
| 1 | Mike D
Donor
ID: 23149247
Mon, Mar 04, 2002, 23:15
|
Open the Excel document in Word, and then with Word you can go to File/Save As and select Web Page (then HTML format). After saving in Word 97 as web page, open an internet explorer window and go to File/Open. Then Browse to your Word/Web Page document. It will open in the Browser. Then go to View/Source. When the source code opens, choose Edit/Select All, then choose copy. Come back to the thread imput box, click "yes (for HTML table imput)," and paste the source code in the box. You should be good to go. FWIW, it's easier on Excel 2000. A lot less steps.
|
| 2 | Mike D
Donor
ID: 23149247
Mon, Mar 04, 2002, 23:17
|
Having said all that, Guru has updated the sartables with this info already, and it can be sorted lots of different ways, FWIW. Feel free to play around though. ;)
|
| 3 | APerfect10
ID: 3257215
Tue, Mar 05, 2002, 00:20
|
Just a minor comment.
Your % change category should actually be...
-((Old - New ) / Old ) * 100)
|
| 4 | Khahan
ID: 12432113
Tue, Mar 05, 2002, 07:33
|
Thanks for the help on converting excel onto the boards Mike D., and yes, I saw guru's sartibles had a section for old stats in the new formula. Everything came up as -2.0 or -2.5. I did not see where he actually converted the 2001 stats into a point total with the 2002 forumla, though.
And AP10..thanks I'll update that.
|
| Rate this thread: | If you wish, you may rate this thread on scale of 1-5. Ratings should indicate how valuable or interesting you believe this thread would be to other users of this forum. A '5' means that this thread is a 'must read'. A '1' means that this is a complete waste of time. If you have previously rated this thread, rating it again will delete your previous rating. If you do not want to rate this thread, but want to see how others have rated it, then click the button without entering a rating, or else click here. |
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|
|