BBTF's Transaction Oracle Discussion :: Start Relief Projection Toy for Microsoft Excel

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 02: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 04:21 AM (#2276628)

Nice.

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?

2. NTNgod Posted: January 09, 2007 at 04:34 AM (#2276632)

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.

3. Dr. Vaux Posted: January 09, 2007 at 05:09 AM (#2276641)

Even a 4.50 ERA from Looper in any reasonable number of innings would be a godsend for the Cardinals. If they know what's good for them, they at least won't let Ryan Madson keep Wainwright out of the rotation.

4. flournoy Posted: January 09, 2007 at 05:39 PM (#2276810)

2002 Chris Hammond would have gone 154-8 if he'd been allowed to throw 1964 innings. Damn, why didn't the Braves think of that.

5. Kyle S Posted: January 09, 2007 at 08:14 PM (#2276915)

Dan, I have excel 2003 at work and it doesn't know what MROUND is. is that a function you have to install or something?

6. AROM Posted: January 09, 2007 at 08:48 PM (#2276966)

That's cool. I'll give that I try. First time I saw the error I just changed it to a regular round function.

I am master of excel VB macros but I still haven't bothered to figure out VLookup. One of these days.

7. Dan Szymborski

Posted: January 09, 2007 at 09:13 PM (#2277011)

VLOOKUP is really cool - if you have my MLE spreadsheet, you'll see a lot of it. I love having park effects all listed on another sheet and having all the park factors looked up on other pages as I need them.

8. Kyle S Posted: January 09, 2007 at 09:34 PM (#2277043)

AROM, vlookup takes about 15 minutes to figure out. The important thing to remember is the lookup list has to be sorted alphabetically - if you don't remember that, you'll spend hours scratching your head wondering at some of the results your functions give you.

9. Jeff Miller Posted: January 09, 2007 at 10:14 PM (#2277100)

Not if you end the VLOOKUP function with (,FALSE). That should take care of the alphabetizing problem. You can also use INDEX(MATCH()) if you take a few minutes to figure it out. It's actually a lot more powerful than VLOOKUP.
(/NERD)

10. AROM Posted: January 09, 2007 at 10:22 PM (#2277114)

I've been using just the regular lookup function in excel, so I'm used to keeping my lookup lists rounded.

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.

11. AROM Posted: January 09, 2007 at 10:23 PM (#2277115)

doh. rounded = alphabetized.

12. Jeff Miller Posted: January 09, 2007 at 11:13 PM (#2277162)

Just put ,FALSE at the end of the command and it will only take exact matches

13. Kyle S Posted: January 09, 2007 at 11:44 PM (#2277192)

good to know. thanks jeff.

14. AROM Posted: January 10, 2007 at 12:09 AM (#2277217)

I just printed out Vlookup from help and read it on the train home.

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.

15. CoastalFan Posted: January 10, 2007 at 08:24 AM (#2277466)

Wow? Did anyone else hear that loud whooshing sound? I think it was the sound of that whole conversation going right over my head - lol....
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

Tuesday, January 09, 2007

Start Relief Projection Toy for Microsoft Excel

Reader Comments and Retorts

BBTF Partner

Bookmarks

Hot Topics

Syndicate