Transaction Oracle— A Timely Look at Transactions as They Happen
Tuesday, January 09, 2007
Start Relief Projection Toy for Microsoft Excel
This should be self-explanatory. Anything that I think could be confusing to someone who is not familiar with the way I make spreadsheets (like people that aren’t me), I made a little note inside the file. The file can be found here.
Dan Szymborski
Posted: January 09, 2007 at 01:17 AM | 18 comment(s)
Login to Bookmark
Related News:
|
Reader Comments and Retorts
Go to end of page
Statements posted here are those of our readers and do not represent the BaseballThinkFactory. Names are provided by the poster and are not verified. We ask that posters follow our submission policy. Please report any inappropriate comments.
1. CraigK Posted: January 09, 2007 at 03:21 AM (#2276628)Braden Looper is estimated to go 11-9 with a 4.12 ERA.
Gagne '03 is estimated at 18-3 with 234 K's; was injury the only reason he became a reliever?
The switch to relief wasn't due to injury.
He was coming off a disappointing season as a starter, was a bit homer-prone, and had trouble locating his offspeed stuff in the strike zone in the starts I saw (which is related to point 2), IIRC. Of course, he also picked up a fair bit of velocity from the switch.
I am master of excel VB macros but I still haven't bothered to figure out VLookup. One of these days.
(/NERD)
Problem with regular lookup lists is if the value you're looking for isn't in the table, you'll get data from the next row.
Thanks, guys, I can use this. I don't like getting the N/A value when I don't have an exact match, but I see this can be solved with an IF function.
I have to go brush up on my Excel skills now - great tool, Dan!
You must be Registered and Logged In to post comments.
<< Back to main