<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
    xmlns:admin="http://webns.net/mvcb/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:content="http://purl.org/rss/1.0/modules/content/">

    <channel>
    
    <title>The Hardball Times</title>
    <link>http://www.hardballtimes.com/main</link>
    <description>Baseball. Insight. Daily.</description>
    <dc:language>en</dc:language>
    <dc:creator>amiv3p@yahoo.com</dc:creator>
    <dc:rights>Copyright 2009</dc:rights>
    <dc:date>2009-11-23T20:53:00+00:00</dc:date>
    <admin:generatorAgent rdf:resource="http://www.pmachine.com/" />
    

    <item>
      <title>Who should be the Yankees DH?</title>

<link>http://www.hardballtimes.com/main/blog_article/who&#45;should&#45;be&#45;the&#45;yankees&#45;dh/</link>

<guid>http://www.hardballtimes.com/main/blog_article/who-should-be-the-yankees-dh/</guid>

<description><![CDATA[In a piece at River Ave. Blues yesterday, Mike Axisa <a href="http://riveraveblues.com/2009/11/could-miranda-be-the-full-time-dh-in-2010-20359/" title="wrote at length">wrote at length</a> about the Yankees DH situation. There's a faction of the fan base that would like to see the team promote from within, and make Cuban defector <a href="http://www.fangraphs.com/statss.aspx?playerid=7783&position=1B" class="player">Juan Miranda</a> the regular DH next season, while giving frequent half-days off to the old-ish lineup by allowing them to DH on occasion. Without thinking about it too much, I agreed with this line of thinking. Keeping <a href="http://www.fangraphs.com/statss.aspx?playerid=1659&position=DH/OF" class="player">Hideki Matsui</a> around in 2010 would A) cost much more than promoting Miranda would, and B) make it more difficult to let some regulars DH on occasion, since Matsui can't play the field. <br />
<br />
So I figured just let Miranda start around 100-120 games at DH, and give guys like Posada, A-Rod, and Damon the remaining time at DH to keep them fresh. Well in that article at RAB, Mike headed down that road by saying this:<br />
<blockquote>There are always more DH types available than DH spots open, so the Yanks certainly have options. However, the team is said to be looking to scale back the payroll a bit, and if they can’t retain Matsui on favorable terms, the team might be better off filling the DH spot from within rather than dropping seven figures on a guy in the decline phase of his career. I’m not talking about that silly rotating DH thing when I say filling the spot from within, I’m talking about Juan Miranda.</blockquote><br />
<br />
The article continues extolling the virtues of Miranda, saying how he destroyed lefties this year after struggling against them in the past, and how he has hit MLB pitching well in his extremely limited sample size. Essentially what you would expect to hear from a prospect fanatic like Mike. But then it takes an unexpected twist:<br /><br /><blockquote>Using the wonderful <a href="http://minorleaguesplits.com/mlecalc.html" title="MLE Calculator">MLE Calculator</a>, we can see that Miranda’s Triple-A batting line this year would have translated to .249-.318-.412 with 15 homers in the big leagues, though I don’t think the MLEc has been updated to reflect the homer happy New Yankee Stadium yet. For the sake of context, that’s basically what <a href="http://www.fangraphs.com/statss.aspx?playerid=254&position=OF" class="player"><a href="http://www.fangraphs.com/statss.aspx?playerid=254&position=OF" class="player">Aaron Rowand</a></a> hit this year. The same Aaron Rowand whose .323 wOBA ranked 68th among all outfielders with at least 400 PA in 2009. Need more context? <a href="http://www.fangraphs.com/statss.aspx?playerid=4022&position=OF" class="player"><a href="http://www.fangraphs.com/statss.aspx?playerid=4022&position=OF" class="player">Melky Cabrera</a></a> was 63rd with a .331 wOBA. So yeah, it’s not very good.</blockquote><br />
<br />
Well that caught me off guard. He does have a point though. Miranda might turn out to be a useful player, and he might be able to provide that value as soon as this season. And that's the problem: he might. He also might not. He has some upside, but the potential downside of giving him the starting job is too great, in my opinion, to take a chance on if you are gunning for another championship. The Yankees offense this season pulverized opposing pitching staffs partially because there was rarely a weak point in the lineup. If you look up on June 1st, and the designated hitter is hitting .245/.320/.430, there's a serious issue that needs to be addressed. <br />
<br />
And this is why it's all about minimizing risk. For a minute now, let's say the Yankees and <a href="http://www.fangraphs.com/statss.aspx?playerid=1659&position=DH/OF" class="player"><a href="http://www.fangraphs.com/statss.aspx?playerid=1659&position=DH/OF" class="player">Hideki Matsui</a></a> part ways. They would have a few primary options, including signing a left fielder and making Damon the full-time DH, keeping everything as is and promoting Miranda. The first option would probably involve a lot of money, and the second would, as I said above, involve a lot of risk. In Dave Cameron's post at FanGraphs on Friday, <a href="http://www.fangraphs.com/blogs/index.php/adding-value/" title="he wrote">he wrote</a> about this very topic:<br />
<blockquote>Rather than replacing the average player with a superior option, this <a href="http://www.fangraphs.com/blogs/wp-content/uploads/2009/11/WAR2.jpg" title="new graph">new graph</a> represents the result of simply having more options. This is a strategy to pursue depth rather than premium talent. It is the baseball version of diversification. Rather than pursuing a single, high-end player with a big contract that still leaves them vulnerable to total loss in case of an injury or inexplicable drop in performance, pairing different types of players can offer similar upside and risk at a reduced cost.</blockquote><br />
<br />
So say no to <a href="http://www.fangraphs.com/statss.aspx?playerid=1873&position=OF" class="player"><a href="http://www.fangraphs.com/statss.aspx?playerid=1873&position=OF" class="player">Matt Holliday</a></a> and his 7-year $100+ million deal, and say no to relying on a 27-year old rookie to fill the vacant spot. Say yes to... <a href="http://www.fangraphs.com/statss.aspx?playerid=1297&position=1B" class="player"><a href="http://www.fangraphs.com/statss.aspx?playerid=1297&position=1B" class="player">Carlos Delgado</a></a>. In his last full season in 2008, Delgado smacked 38 home runs and slugged a robust .518. All that in a pitcher-friendly Shea Stadium. Put his batted ball distribution in homer-friendly Yankee Stadium and who knows what that season looks like. But as always seems to be the problem with Delgado, he has been injured. Hip surgery limited to Delgado to just 112 plate appearances this past season, but his triple-slash line was as good as ever in this small sample. Delgado appeared to be nearing a return to the Mets in August before an oblique strain caused them to shut him down, so he's presumably ready to go health-wise.<br />
<br />
This isn't about Delgado's pure production, which is difficult to project coming off an injury. CHONE <a href="http://www.baseballprojection.com/2010/free2010.htm" title="projects">projects</a> .247/.322/.449, while Bill James is more optimistic about Delgado, seeing a .263/.361/.494 line. It's also about Delgado's potentially affordable contract, which <a href="http://www.mlbtraderumors.com/carlos_delgado/" title="could be">could be</a> heavier on incentives than on guaranteed dollars.  If the Yankees were to sign Delgado, they wouldn't be making a bet on <i>him alone</i> being that productive; they'd be betting that either Delgado or Miranda (or a combination of both) could produce offensively for a low price. Signing Delgado to an incentive-laden deal allows them to take a chance on Delgado's 30+ home run upside while still hedging their bets with Miranda should Delgado get hurt or be ineffective. Now if only Wall Street could manage its risk like this, we might be getting somewhere.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/who&#45;should&#45;be&#45;the&#45;yankees&#45;dh/&amp;itemDate=2009-11-23 19:53:00&amp;itemTitle=Who should be the Yankees DH?">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/who&#45;should&#45;be&#45;the&#45;yankees&#45;dh/&amp;itemDate=2009-11-23 19:53:00&amp;itemTitle=Who should be the Yankees DH?" /></a>
]]>

</description>

      <dc:creator>Dan Novick</dc:creator>
      <dc:date>2009-11-23T19:53:00+00:00</dc:date>
    </item>

    <item>
      <title>Mauer Power</title>

<link>http://www.hardballtimes.com/main/shysterball/article/mauer&#45;power/</link>

<guid>http://www.hardballtimes.com/main/shysterball/article/mauer-power/</guid>

<description><![CDATA[Pop quiz, hot shot: There's a catcher who wins the Gold Glove, the batting title and leads the league in on base and slugging percentage. What do you call him?<br />
<br />
<a href="http://bbwaa.com/" title="MVP">MVP</a>.<br />
<br />
That is, unless you're the (presumably) Detroit-area voter who put Miguel Cabrera in front of Mauer in first place, costing him the unanimous MVP.<br />
<br />
Same dude who voted Verlander over Greinke for the Cy Young award?  If so, is it time to investigate whether this city-by-city system is the best way to go?<br />
<br />
<b>UPDATE</b>: <a href="http://twitter.com/KenDavidoff/status/5984854758" title="Ken Davidoff Tweets">Ken Davidoff Tweets</a> that it was Keizo Konishi of Kyodo News, based in Seattle, who voted Miguel Cabrera first.  I can think of no worldly justification for voting Cabrera ahead of either Mauer or Jeter for that matter, so I eagerly await Mr. Konishi's explanation.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/mauer&#45;power/&amp;itemDate=2009-11-23 18:24:38&amp;itemTitle=Mauer Power">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/mauer&#45;power/&amp;itemDate=2009-11-23 18:24:38&amp;itemTitle=Mauer Power" /></a>
]]>

</description>

      <dc:creator>Craig Calcaterra</dc:creator>
      <dc:date>2009-11-23T18:24:38+00:00</dc:date>
    </item>

    <item>
      <title>My Morning in Exile</title>

<link>http://www.hardballtimes.com/main/shysterball/article/my&#45;morning&#45;in&#45;exile112309/</link>

<guid>http://www.hardballtimes.com/main/shysterball/article/my-morning-in-exile112309/</guid>

<description><![CDATA[Had my last Monday morning staff meeting this morning. Next Monday: it's me, my cat, my Ipod, my pajamas, a pot of coffee and a big bowl of Count Chocula. Until then:<br />
<br />
<li><a href="http://bases.nbcsports.com/2009/11/white-sox-offer-vizquel-1-million.html.php" title="Omar Vizquel">Omar Vizquel</a> is Snake Eyes to Ozzie Guillen's Storm Shadow.</li><br />
<br />
<li>Comment of the day comes from Len over at NBC: <a href="http://bases.nbcsports.com/2009/11/the-mets-may-play-some-games-in-puerto-rico.html.php" title="&quot;Hey, Frenchie might hit a double!&quot;">"Hey, Frenchie might hit a double!"</a></li><br />
<br />
<li>A-Rod's cousin's house is being foreclosed upon. There's a good chance that it's a walkaway as opposed to a hardship case, and the piece itself quotes someone saying that A-Rod is still taking care of the guy financially, <a href="http://bases.nbcsports.com/2009/11/did-a-rod-throw-his-cousin-under-the-financial-bus.html.php" title="but don't let that stop the Daily News from portraying this as a situation in which A-Rod threw his family under the bus and then abandoned him">but don't let that stop the Daily News from portraying this as a situation in which A-Rod threw his family under the bus and then abandoned him</a>. That's just how they do.</li><br />
<br />
<li><a href="http://bases.nbcsports.com/2009/11/the-sox-will-throw-money-into-a-lowell-deal.html.php" title="If they throw in another $6 million">If they throw in another $6 million</a> I'll take Mike Lowell off the Red Sox' hands. I could use some veteran presence around the house.</li><br />
<br />
<li><a href="http://bases.nbcsports.com/2009/11/the-blue-jays-add-scouts-how-very-moneyball-of-them.html.php" title="Not having enough scouts">Not having enough scouts</a> is the new inefficiency.</li><br />
<br />
<li>The biggest difference between blogging full time and blogging part time is that when you blog full time, you pretty much have to opine on things like <a href="http://bases.nbcsports.com/2009/11/as-torrealba-looks-west-the-rockies-court-brian-schneider.html.php" title="the backup catcher market">the backup catcher market</a>. I'm cool with that. In fact, going forward, I'm going to view making innocuous stories like that interesting as a creative challenge.</li> <br />
<br />
As I mentioned the other day, the job change is tempting me <a href="http://craigcalcaterra.blogspot.com/" title="to take a stab at reviving my long dead personal blog">to take a stab at reviving my long dead personal blog</a>. I make no promises that it will keep going -- two blogs tends to be a challenge -- but I've got a new post up today. It won't be anything like my baseball writing in terms of volume -- if I get one or two new things up a week over there I'll be happy. And if it dies again, hell, it dies.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/my&#45;morning&#45;in&#45;exile112309/&amp;itemDate=2009-11-23 15:38:14&amp;itemTitle=My Morning in Exile">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/my&#45;morning&#45;in&#45;exile112309/&amp;itemDate=2009-11-23 15:38:14&amp;itemTitle=My Morning in Exile" /></a>
]]>

</description>

      <dc:creator>Craig Calcaterra</dc:creator>
      <dc:date>2009-11-23T15:38:14+00:00</dc:date>
    </item>

    <item>
      <title>Book excerpt: Evaluating Baseball&#8217;s Managers: Pat Moran</title>

<link>http://www.hardballtimes.com/main/article/book&#45;excerpt&#45;evaluating&#45;baseballs&#45;managers&#45;pat&#45;moran/</link>
<guid>http://www.hardballtimes.com/main/article/book-excerpt-evaluating-baseballs-managers-pat-moran/</guid>
<description><![CDATA[In another sneak preview from <a href="http://www.mcfarlandpub.com/book-2.php?id=978-0-7864-3920-1">his new book</a>, Chris examines the greatest manager you never heard of: <a href="http://www.baseball-reference.com/managers/moranpa01.shtml"  class="player" target="new">Pat Moran</a>.<br /><br />Click the title to read more.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/book&#45;excerpt&#45;evaluating&#45;baseballs&#45;managers&#45;pat&#45;moran/&amp;itemDate=2009-11-23 09:26:43&amp;itemTitle=Book excerpt: Evaluating Baseball&#8217;s Managers: Pat Moran">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/book&#45;excerpt&#45;evaluating&#45;baseballs&#45;managers&#45;pat&#45;moran/&amp;itemDate=2009-11-23 09:26:43&amp;itemTitle=Book excerpt: Evaluating Baseball&#8217;s Managers: Pat Moran" /></a>
]]>

</description>

      <dc:creator>Chris Jaffe</dc:creator>
      <dc:date>2009-11-23T09:26:43+00:00</dc:date>
    </item>

    <item>
      <title>Players worth remembering, 1901&#45;1924</title>

<link>http://www.hardballtimes.com/main/article/players&#45;worth&#45;remembering&#45;1901&#45;1924/</link>
<guid>http://www.hardballtimes.com/main/article/players-worth-remembering-1901-1924/</guid>
<description><![CDATA[Where have all the Heinies gone?<br /><br />Click the title to read more.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/players&#45;worth&#45;remembering&#45;1901&#45;1924/&amp;itemDate=2009-11-23 08:15:44&amp;itemTitle=Players worth remembering, 1901&#45;1924">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/players&#45;worth&#45;remembering&#45;1901&#45;1924/&amp;itemDate=2009-11-23 08:15:44&amp;itemTitle=Players worth remembering, 1901&#45;1924" /></a>
]]>

</description>

      <dc:creator>Geoff Young</dc:creator>
      <dc:date>2009-11-23T08:15:44+00:00</dc:date>
    </item>

    <item>
      <title>How Sabermetrics saved my dissertation</title>

<link>http://www.hardballtimes.com/main/article/how&#45;sabermetrics&#45;saved&#45;my&#45;dissertation/</link>
<guid>http://www.hardballtimes.com/main/article/how-sabermetrics-saved-my-dissertation/</guid>
<description><![CDATA[What does clinical psychology have in common with Sabermetrics? Quite a bit, as it turns out.<br /><br />Click the title to read more.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/how&#45;sabermetrics&#45;saved&#45;my&#45;dissertation/&amp;itemDate=2009-11-23 05:05:40&amp;itemTitle=How Sabermetrics saved my dissertation">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/how&#45;sabermetrics&#45;saved&#45;my&#45;dissertation/&amp;itemDate=2009-11-23 05:05:40&amp;itemTitle=How Sabermetrics saved my dissertation" /></a>
]]>

</description>

      <dc:creator>Pizza Cutter</dc:creator>
      <dc:date>2009-11-23T05:05:40+00:00</dc:date>
    </item>

    <item>
      <title>Why Baseball Needs a Visual Facelift</title>

<link>http://www.hardballtimes.com/main/blog_article/why&#45;baseball&#45;needs&#45;a&#45;visual&#45;facelift/</link>

<guid>http://www.hardballtimes.com/main/blog_article/why-baseball-needs-a-visual-facelift/</guid>

<description><![CDATA[Baseball has been around for awhile.  Over a hundred years, with a VAST treasure chest of information and history.  As a baseball fan I’ve often wondered why there was so little visualization of stats and other information.  It seems like most of baseball’s rich history has been communicated through rows and columns of data.  Not that I have anything against numbers (I love numbers!), but shouldn’t we have progressed beyond this approach by now?  I got curious about progress, and looked back at how things have changed in our society since baseball was invented.<br />
<br />
<img src="http://www.hardballtimes.com/images/uploads/boxscore_evolution.jpg" border="0" alt="image" name="image" width="600" height="776" /> <br />
<br />
Take a look at how little the box score has changed since 1876!  It’s really the tip of the iceberg in terms of how little innovation there has been in the sport’s design and communication of information.  My hope is to be part of a revolution in changing the way baseball is viewed and understood by its fans.  In the same way that Sabermetrics has opened up new insight via new and better analysis of information, I'd like to see the same happen via the visual communication of information.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/why&#45;baseball&#45;needs&#45;a&#45;visual&#45;facelift/&amp;itemDate=2009-11-22 04:08:02&amp;itemTitle=Why Baseball Needs a Visual Facelift">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/why&#45;baseball&#45;needs&#45;a&#45;visual&#45;facelift/&amp;itemDate=2009-11-22 04:08:02&amp;itemTitle=Why Baseball Needs a Visual Facelift" /></a>
]]>

</description>

      <dc:creator>Kevin Dame</dc:creator>
      <dc:date>2009-11-22T04:08:02+00:00</dc:date>
    </item>

    <item>
      <title>Introducing Visual Baseball</title>

<link>http://www.hardballtimes.com/main/blog_article/introducing&#45;visual&#45;baseball/</link>

<guid>http://www.hardballtimes.com/main/blog_article/introducing-visual-baseball/</guid>

<description><![CDATA[Hi there.  I'm a new blogger at The Hardball Times and wanted to introduce myself and a topic that I hope you'll find interesting.  It's called Visual Baseball and it's about the intersection of two things I love - baseball and infographics (the visual display of information).  Over the next few months you'll be seeing lots of different visuals from me.  Some of them will be works in progress, but pushing towards a longer-term goal of bringing some fresh ideas for how this sport might be experienced.  As I experiment with new visual methods and approaches, I would love your feedback - good or bad.  It'll help me create better stuff and hopefully help fans enjoy the game in new ways.  Looking forward to collaborating with all of you!  Cheers,  Kevin<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/introducing&#45;visual&#45;baseball/&amp;itemDate=2009-11-22 04:05:52&amp;itemTitle=Introducing Visual Baseball">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/introducing&#45;visual&#45;baseball/&amp;itemDate=2009-11-22 04:05:52&amp;itemTitle=Introducing Visual Baseball" /></a>
]]>

</description>

      <dc:creator>Kevin Dame</dc:creator>
      <dc:date>2009-11-22T04:05:52+00:00</dc:date>
    </item>

    <item>
      <title>Building a Retrosheet database, the short form</title>

<link>http://www.hardballtimes.com/main/blog_article/building&#45;a&#45;retrosheet&#45;database&#45;the&#45;short&#45;form/</link>

<guid>http://www.hardballtimes.com/main/blog_article/building-a-retrosheet-database-the-short-form/</guid>

<description><![CDATA[Today marks the latest release of <a href="http://www.retrosheet.org" target="new">Retrosheet</a>'s event files, including 2009, the 1952 AL and some corrections to other years. This is a guide written for someone who already has an SQL database (MySQL, that is) set up and is comfortable with it. I am in the process of putting together a set of tutorials for those with no SQL experience whatsoever, but I've made a lot of changes to how I set up a database and I know some people would appreciate having those. And mind, this is a tutorial for Windows users. And make sure you have a lot of space free on your hard drive.<br />
<br />
You need to install <a href="http://gnuwin32.sourceforge.net/packages/wget.htm" target="new">wget</a> and <a href="http://www.7-zip.org/" target="new">7-zip</a>. I have made the presumption that you are installing them to C:\Program Files\. If you are not, you will have to edit some batch files.<br />
<br />
By the same token, I am assuming that everything else goes in the folder C:\Retrosheet. If you put it somewhere else, you will have to edit some batchfiles. I have created <a href="http://www.hardballtimes.com/images/uploads/retrosheet.zip">a zip file</a> that contains everything you need. Simply place that file in the C:\Retrosheet folder (you may have to make one first) and use 7-zip to unzip the file there. That file contains EVERYTHING you need except the event files themselves. That includes a copy of <a href="http://chadwick.sourceforge.net/" target="new">Chadwick</a> version 0.5.2, which is used to parse Retrosheet's event files.<br />
<br />
<b>WARNING:</b> The database schemas in here will only work with the version of Chadwick provided. You will get errors (or corrupted data) if you try to use an older version of Chadwick to parse these files and then load them into the database.<br />
<br />
Go to C:\Retrosheet\data\zipped and run the get_zip_files.bat file. (If you have installed 7-zip or wget somewhere other than the default, you'll need to edit this file.) This will download all the zip files from Retrosheet's website and extract the contents. Then go to the folder C:\Retrosheet\data\zipped, which should contain the files you just extracted. There are three batch files in there:<br />
<br />
<ul><br />
<li>$cwevent.bat<br />
<li>$cwgame.bat<br />
<li>$cwsub.bat<br />
</ul><br />
<br />
Run those to parse the event files through Chadwick.<br />
<br />
Okay, time to load that database. A warning - a lot of these queries will take a long time. The first thing to do is run retrosheet table schema.sql. That will wipe out anything you have in any database named "retrosheet," so if that's important to you, make a backup before starting. Then, you will find three files in the loaders directory:<br />
<br />
<ul><br />
<li>events.sql<br />
<li>games.sql<br />
<li>subs.sql<br />
</ul><br />
<br />
Run those. (In SQLyog, that option is called "Restore From SQL Dump," under the Tools menu.) They will populate the database. (Note - if you are using a different directory structure, you need to edit these files first to reflect that.) Then, run the partition.sql file - that will "partition" the database to make it easier to load into memory. This will dramatically speed up queries. (After you've run partition.sql, you can feel free to delete the tables events_bck and games_bck.) Finally, run lookup_codes.sql to load the lookup tables (the ones that will tell you what the different codes mean).<br />
<br />
That's it!<br />
<br />
Thanks to Tangotiger and Mat Kovach, whose work this is based on, Ted Turocy for providing the Chadwick tool set, and Dave Smith and all the volunteers over at Retrosheet for their hard work.<br />
<br />
I hope this is useful to you. Let me know if you need help or if something doesn't work right. And again, if all of this is a bit more advanced than you're prepared for right now, I am working on a set of more indepth tutorials that should get you started - look for them sometime this week, hopefully.<br />
<br />
UPDATE: Last time I posted a Retrosheet tutorial, I included some run expectancy code. Quite frankly, it was pretty poor. <a href="http://basql.wikidot.com/house-linear-weights" target="new">This</a> is much better. It includes code for figuring linear weights as well. It is very compute-intensive, though, and requires roughly four times the code of the old method. I think it's worth it, but then again I'm kind of an obsessive on the topics of run expectancy and linear weights.<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/building&#45;a&#45;retrosheet&#45;database&#45;the&#45;short&#45;form/&amp;itemDate=2009-11-21 16:24:36&amp;itemTitle=Building a Retrosheet database, the short form">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/building&#45;a&#45;retrosheet&#45;database&#45;the&#45;short&#45;form/&amp;itemDate=2009-11-21 16:24:36&amp;itemTitle=Building a Retrosheet database, the short form" /></a>
]]>

</description>

      <dc:creator>Colin Wyers</dc:creator>
      <dc:date>2009-11-21T16:24:36+00:00</dc:date>
    </item>

    <item>
      <title>HR/FB Park Factors</title>

<link>http://www.hardballtimes.com/main/blog_article/hr&#45;fb&#45;park&#45;factors/</link>

<guid>http://www.hardballtimes.com/main/blog_article/hr-fb-park-factors/</guid>

<description><![CDATA[Just a quick hit to share park factors for HR/FB rate.  <br />
<br />
I used BIP data and the methodology from <a href="http://www.baseball-reference.com/about/parkadjust.shtml" target="new">Baseball Reference</a> to determine simple HR/FB park factors for 2009 and 4-year weighed factors (weights are 5,3,2,1).<br />
<br />
<b>Update: My spreadsheet was thrown off by the Rays' name change.  I've corrected the numbers below</b><br />
<br />
Without further adieu, here's the list:<br />
<br />
<pre>Team        Park                         2009    4 Year
Angels      Angel Stadium                 110      96
Astros      Minute Maid Park              104     108
Athletics   McAfee Colisuem                95      92
Blue Jays   Rogers Centre                 105     108
Braves      Turner Field                   90      95
Brewers     Miller Park                   108     106
Cardinals   Busch Stadium                  86      84
Cubs        Wrigley Field                  97     103
DiamondbacksChase Field                    99     106
Dodgers     Dodger Stadium                 89      95
Giants      Pacific Bell Park             104      95
Indians     Jacobs Field                   75      88
Mariners    Safeco Park                    95      96
Marlins     Dolphins Stadium              109      99
Mets        Citi Field                     98      98
Nationals   Nationals Stadium              91      92
Orioles     Oriole Park at Camden Yar     109     115
Padres      PETCO Park                     73      75
Phillies    Citizens Bank Park            109      94
Pirates     PNC Park                      105      94
Rays        Tropicana Field               110     111
Rangers     The Ballpark at Arlington      98      97
Red Sox     Fenway Park                    98      90
Reds        Great American Ballpark       121     114
Rockies     Coors Field                   103     112
Royals      Kaufman Stadium                73      78
Tigers      Comerica Park                  94     101
Twins       Metrodome                     109      96
White Sox   US Cellular Field             115     118
Yankees     New Yankee Stadium            130     130
</pre><br />
<br />
The Mets and the Yankees Park Factors are one season only<br><br />
The Nationals Park Factor is two seasons, weighted at 5 and 3<br /><br />Read more great baseball stuff at <a href="http://www.hardballtimes.com/main/" target="new">The Hardball Times</a>.]]>

<![CDATA[
<a href="http://www.pheedo.com/click.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/hr&#45;fb&#45;park&#45;factors/&amp;itemDate=2009-11-21 11:58:38&amp;itemTitle=HR/FB Park Factors">
<img border="0" src="http://www.pheedo.com/img.phdo?feedUrl=http://www.hardballtimes.com/main/content/rss_2.0/&amp;itemLink=http://www.hardballtimes.com/main/site/hr&#45;fb&#45;park&#45;factors/&amp;itemDate=2009-11-21 11:58:38&amp;itemTitle=HR/FB Park Factors" /></a>
]]>

</description>

      <dc:creator>Dan Turkenkopf</dc:creator>
      <dc:date>2009-11-21T11:58:38+00:00</dc:date>
    </item>

    
    </channel>
</rss>