by PotKettleBlack » Tue Jan 10, 2012 12:37 pm
[quote:ed64f25102="PillPop"]Please do share, PKB. I'm often at a loss as to why some-- hey, MOST-- of my teams fall short and would appreciate any tools for future analysis.[/quote:ed64f25102]
Cleaning up the sheet and do not have a way of assigning blame/shame/fame to individual fielders as of yet.
Have a reasonable working of assigning WS to bats versus the other side of the game.
Have a reasonable approximation of breaking fielding from pitching.
Decent approximation of batter values (without credit/debit for fielding prowess) and of pitcher values (without credit/debit for fielding exploits or batting incompetence). I will share it on Google Docs when it's cleaner, as it's an f'ing mess right now.
Issues making it an f'ing mess. Multiple sheets that require information from different pages (team page, Sim Stats L/R, Stats-Team, Stats-Team Fielding). Incomplete data to accurately compute OBP:
[img:ed64f25102]http://upload.wikimedia.org/wikipedia/en/math/5/6/e/56e63a7b1b0724813e09ba0ab1160a22.png[/img:ed64f25102]
and a couple other issues. The fielding data is really deplorable and makes the valuation of slick fielders very tricky indeed. I had an idea to fudge the distribution of WinShares to fielders based on DeanTSC's OffvsDef sheet, but I forgot the mechanism I came up with and I'm way more inventive with spreadsheets away from my computer.
At first blush (having looked at two teams) it does kind of unpack somethings. Like the team I linked above...
without even knowing the D impact of Utley at 2nd, I can say from his hitting that, to do this team again, I'd trade him for a similarly valued second sacker who maybe hits less.
I will continue my love affair with Bob O'Farrell.
I will be using Pete Rose 1969 more in the future. He created half a win share less than Dimaggio's card, at ~60% of the price. The difference is that he got more PAs, specifically 30 more AB, 15 more BB and more HBP or fewer SF. That was leading off most of the season I think. Which brings back something else; the importance of putting your best guys up top. Bonds was a monster as only Bonds Ruth and maybe Gibson can be. He had 701 AB+BB. Rose had 766. Dimag 721. Buck Leonard 763.
Chuck Klein at DH vs Buck Leonard at 1B... About one win with the bat. Leonard has a sterling glove at 1st. Think he makes up the ten marginal runs with his glove? I think so. He's a .502 winner at 100, .532 at 80, .498 at 140...
Scott Brosius. I'm writing him to bad luck. 550 PA. He took a lot of balls in the body, and had FIVE injuries. 36-38, 67-73, 106-113, 115-129, 141-141. He hit the ball well against LHP, which was really his job (.302/.382/.556 vs L... Chuck Klein vs L, Bobby Wallace vs R). But the injuries. If I'd have known, I'd've dropped him after game 106, not sure if that would have been 10 or 20%, but considering that he'd play a game and a half between 107 and 129, someone 80% of him would have produced more than he did during that stretch.
Any rate, I will put up a link to the sheet when I think it's better linked together, minimal work, and more logically arranged.
Last edited by
PotKettleBlack on Tue Jan 10, 2012 1:04 pm, edited 1 time in total.