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

Transaction Oracle
— A Timely Look at Transactions as They Happen

Monday, January 08, 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 08, 2007 at 08:17 PM | 18 comment(s)
Related News: Sabermetrics

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.

Page 1 of 1 pages

1. Craig K Posted: January 08, 2007 at 10:21 PM (#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 08, 2007 at 10:34 PM (#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. Dan Szymborski

Posted: January 08, 2007 at 11:03 PM (#2276639)

Braden Looper is estimated to go 11-9 with a 4.12 ERA.

Actually a bit higher for Looper when I put it through the whole projection system - this is really just a quickie tool for fun.

4. Vaux, A.B.D. Posted: January 08, 2007 at 11:09 PM (#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.

5. flournoy Posted: January 09, 2007 at 11:39 AM (#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.

6. Kyle S Posted: January 09, 2007 at 02: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?

7. Dan Szymborski

Posted: January 09, 2007 at 02:23 PM (#2276927)

Kyle, MROUND allows you to round to the nearest multiple instead of the nearest decimal place.

So, =MROUND(13.5,1/3)

rounds 13.5 to the nearest 1/3, or 13.333333.

I'm pretty proud of myself - I usually learn new Excel things by bugging Vinay for the answer (it's how I learned to do VLOOKUP and CONCATENATE).

8. Dan Szymborski

Posted: January 09, 2007 at 02:26 PM (#2276931)

Oh bugger, I misread the question.

It turns out that it's part of the MSExcel Analysis Tool-Pack add-in. You should be able to activate it by going to Tools/Add-ins and checking the box.

9. AROM Posted: January 09, 2007 at 02: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.

10. Dan Szymborski

Posted: January 09, 2007 at 03: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.

11. Kyle S Posted: January 09, 2007 at 03: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.

12. Jeff Miller Posted: January 09, 2007 at 04: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)

13. AROM Posted: January 09, 2007 at 04: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.

14. AROM Posted: January 09, 2007 at 04:23 PM (#2277115)

doh. rounded = alphabetized.

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

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

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

good to know. thanks jeff.

17. AROM Posted: January 09, 2007 at 06:09 PM (#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.

18. CoastalFan Posted: January 10, 2007 at 02: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!

Page 1 of 1 pages

You must be Registered and Logged In to post comments.

<< Back to main

Monday, January 08, 2007

Start Relief Projection Toy for Microsoft Excel

Reader Comments and Retorts

Reader Comments and Retorts

Support BBTF

My Bookmarks

Hot Topics