18
February

Prairieland Draft Day!

It’s Prairieland’s Draft/Selection Day! 

Follow Eric Berg’s blog Red 11 for live results!!

Posted by: | Category: Tournament | Tags: , | Leave a comment

15
February

3 days till Prairieland selection draft!

IMG_2498-001Eric Berg is busily preparing for the Prairieland 2 tournament draft/selection process.  While the tournament itself isn’t until April 1, 23 tourney participants will begin selecting their teams and accompanying fantasy deadball players beginning this weekend in a snake-style draft.  Eric spells it all out here on his blog, Red 11.

Eric also posted a final list of participants.  If you signed up and somehow got left off, please let us know.  Once we’re set, the order will be randomized and we’ll begin this weekend.

The tourney will consist of teams from 1970-2000 but each one will have help from one fantasy deadball player which will also be chosen in the draft.  I’m curious about APBA Blog contributor Scott Fennessy’s take on this.  Scott is our deadball expert.

I assure you, he has not given me any inside info… yet (don’t hold out on me, buddy). 

Truth be told, I already have my A-list of teams and players picked out.  I generally don’t go into the team selection process with a real competitive attitude. I pick teams that are interesting to me (see last place ‘87 Cubs who I took a few tourneys back). 

Good luck in the draft process, guys!!

Posted by: | Category: Tournament | Tags: , | Leave a comment

14
February

Excel stats setup: Creating a dynamic team roster

I just uploaded another quick video on how I set up my stats for the Excel fans out there.  It’s a follow-up to the first one when I created player worksheets.  This video takes the data from those player worksheets from the first one and displays it all in a meaningful fashion in the form of a stats roster.

As always, watch in full-screen mode for best experience.  Those numbers are tiny!

 

 

Topics covered:

Bulk editing worksheets

You can “group” worksheets by holding Control and selecting each worksheet or hold Shift button and select the last worksheet in the range.  All edits will now affect every grouped worksheet.  Right-click and “Ungroup Sheets” when you are finished (don’t forget!)

The SUM function

Example:

=SUM(A1:A20)

will display the sum of all cells between A1 and A20

Paste Link

Rather than pasting the static text, Paste Link is dynamic and will display what is in the referenced cell even if it changes.

Here is the Excel file used in the video.

At this point in the setup, team files are ready and just need to be populated with players and stats.

The fun is just beginning.  We’ve now laid the groundwork.  Once we get some useable data, we can take it and create a league roster and get down and dirty with data.  We can then start playing with leaderboards, standings, total team stats, pretty much whatever you want.

Next time:  Putting together a League Register.

Posted by: | Category: replay | Tags: , , , , , | 1 comment

13
February

Monster Card Monday: 1998 Juan Gonzalez

igor

Ryan Morrison recently suggested this 1998 Juan Gonzalez APBA card for Monster Monday.  Juan Gone was a big star in our Illowa APBA League.  My buddy Chuck Lucas even traded him to me but Chuck’s no dummy.  He waited just before his usefulness was about to expire.  I got one semi-decent year out of him (I remember that was the year my team had three players named Gonzalez, Juan, Luis and Alex).   

Chuck on the other hand, was able to enjoy this card.  Gonzalez played a full season in 1998, playing 154 and batting 606 times.  In that time, he blasted 45 dingers and drove home 157 runs.  Not only that, he amazingly led the league in doubles with 50. 

Igor was never much to take a pitch but in 1998 he did manage to walk 46 times a high for him up until that point. 

Split G PA AB R H 2B 3B HR RBI SB BB SO BA OBP SLG
1998 Totals 154 669 606 110 193 50 2 45 157 2 46 126 .318 .366 .630
Provided by Baseball-Reference.com: View Original Table
Generated 2/13/2017.

 

APBA doled out only two 14s to Gonzalez but that’s probably because he had so many plate appearances.  Let’s face it, this card can hit! 

Not only does Juan have five power numbers with 1-1-5-6-6, he also has a 55-7 on top of that. 

Fun numbers:  33-5, 44-6, 55-7

It’s worth mentioning that Chuck did very well with this card in the Illowa APBA League.  Gonzalez hit 65 homeruns for him with 156 rbis.  Gonzalez’ 65 homers ranks sixth all-time and his 156 rbis ranks 12th all-time. 

Interestingly, Gonzalez did not lead the IAL in homers that year but that’s another story

thanks Ryan!!

Posted by: | Category: Card Analysis | Tags: , , | Leave a comment

10
February

1966 NL replay: Making sense of two stat anomalies

main_1-Lou-Brock-1966-Topps-125-PristineAuction.com

Take some pitches, Lou

I noticed two things about my stats in my 1966 NL replay (Basic Game, actual lineups, rotations) recently that gave me a reason to pause but after investigating they were mostly vindicated.  As of now, I am just finishing up May with two more days left to play in the month. 

1)  Sandy Koufax’ arm must be falling off

Pitcher Team Innings 
Koufax, Sandy LA 96   
Veale, Bob Pit 87 1/3
Sutton, Don LA 87   
Cloninger, Tony Atl 85 1/3
Marichal, Juan SF 85   
Bunning, Jim Phi 81   
Gibson, Bob StL 81   
Osteen, Claude LA 79   
Short, Chris Phi 71 2/3
Bolin, Bobby SF 71 1/3

I was perusing my leaderboards and saw my list of pitchers with most Innings Pitched.  Yikes! Sandy Koufax already has 96 innings pitched in my replay as of May 29th.  Needless to say, he leads the league.  I thought that was inordinately high and maybe I was misusing him. Perhaps the bullpen was being ignored.

Well, I may be partially right but not as much as I thought.  Using Baseball Reference, I found out how many innings Koufax had pitched by May 29th.  It turns out he had pitched 82 1/3 innings by that point.  So while it may be time to dial it down if I want to be realistic, I am certainly not out of the ballpark. 

 

2) Do they teach bat discipline in St. Louis?

I’m almost rooting for the 1966 Cardinals in my replay.  They can’t buy a win at 11-28.  Looking over my team totals, I wonder if it’s because they can’t get on base.  In 39 games, Cardinal batters have walked only 64 times in my replay.  That’s 1.64 walks per game.  I honestly worried if I made a mistake in my stat keeping but it all checks out.  Leadoff man Lou Brock (with his one 14) is the worst offender.  Though he’s batting .320, he’s walked just once in 130 plate appearances! 

Again, checking Baseball Reference, I see that St. Louis had the least walks of any team in the NL in 1966 with 345 for the entire season.  That works out to 2.12 BB/G, a little higher than my average but not by much.  As for Brock, he walked 26 times in real life so he’ll need to learn to take some pitches to reach that mark. 

 

There are just a few more games before I hit June.  I’m planning on a big update. 

Posted by: | Category: replay | Tags: , | 2 comments

9
February

Rod’s Replay Insider: Tracking pinch hitting

imageI’ve always wondered why MLB doesn’t focus more attention on the result of pinch hitters. These guys get paid big money to deliver in important situations, always the end of games, but they don’t get much ink or recognition.

I track pinch hitting results in my replays, simply out of curiosity. The results are always surprising. In every replay I have conducted, an obscure player emerges who consistently delivers in the clutch.

The tracking chart for tracking pinch hitters is very basic. All you have to do is make a copy for each team, pencil in the names of the hitters and pencil in each at bat, hit, etc. A little extra room is provided to accommodate those players who will be most likely to be called upon as pinch hitters.

Here is a link for a formatted pinch hitting chart that you can reproduce and incorporate into your next replay. It includes extra space to accommodate those batters who will likely be called upon to pinch hit most often.

Next: Tracking pitching winning and losing streaks

Read all of Rod’s Replay Insider articles!

Posted by: | Category: replay | Tags: , , | 2 comments

9
February

Scott Fennessy: Pirates beat Cubs, move into first place

332px-IMG_6787_Neil_WalkerThe Cubs and Pirates meet again as the Pirates look to continue their winning ways after yesterday’s solid victory. Tonight’s game sees Jay Happ against Kyle Hendricks. The Pirates jump on young Kyle instantly. Gregory Polanco, who has feasted on Chicago pitching so far this year gets a single and scores on Andrew McCutchen’s RBI double via the hit and run. McCutchen has really punished pitching so far and could be an MVP candidate at this pace.

Hendricks gets the next two hitters and the inning is over. Happ gets a perfect first inning and neither team can get much going. The Cubs had a couple of rallies in the second and third that came up short and while Pittsburgh was able to pile up a pitch count on Hendricks, were not able to do anything else until the fifth inning.

Oddly enough, it’s the light hitting pitcher Jay Happ who gets things started. Hitting a weak grounder that somehow gets between Starlin Castro and Anthony Rizzo. One out later he is on second base when Polanco strikes again with a single up the middle and Happ scores and Polanco holds as the ball is cut by Castro. Polanco steals second base as Miguel Montero’s throw was a bit high, but Hendricks gets the next two hitters to end the rally.

Happ finally gets a bit of a hot streak as he strikes out the side in the bottom of the fifth inning, giving him four in a row. The Pirates finally take control in the top of the sixth inning. Neil Walker, who has quietly become a bit of a catalyst for the team and on first with a single when a frustrated Kyle Hendricks gives in to Pedro Alvarez who crushes a towering two run homer into the family section of the left field seats for a two run jack. Hendricks gets out of the inning, but the Pirates now have a commanding 4-0 lead at the half way point.

The Cubs look like they are going to make a game of this in the bottom half when the now resurging Dexter Fowler hits a single to right with one out and moved to second with two down. Rizzo, who has been scuffling pretty badly of late gets his second hit of the night and Fowler gives the Cubs their first run of the game. Kris Bryant walks, but is stranded and the rally dies quickly. The Cubs do keep it a bit closer though, trailing 4-1 as we head to the seventh inning.

Jason Motte comes in and does not fare well at first. McCutchen gets his second double of the game and scores on Walker’s two out single. The inning ends with the Pirates on top by four runs now 5-1.

The visitors keep the pressure mounting as the bottom of the order gets a series of singles and Jody Mercer scores on Sterling Marte’s single and the lead is now 6-1 as the inning finally ends.

The Cubs give the offense another go in the bottom of the eighth inning with one out. Fowler rips a triple into the power alley in right, and the surprisingly dependable Starlin Castro singles sharply to center field for an RBI. Rizzo walks, but Bryant whiffs to stop the rally and the Cubs are now down by four. Tommy Hunter is summoned to make his first appearance of the year, and while he struggled a bit kept the Pirates off the board for the first time in five innings and they make their last chance to come back.

Happ has been a bit wild late in the game, but the manager wants to see if he can close this one out. Miguel Montero gets a leadoff walk and was on second with two outs when Addison Russell puts a charge into a 2-2 slider and this one is gone! Into the shrubbery (how dare you say that to a woman!) for a two run homer. The manager instantly pops out of the dugout and brings in Mark Melancon, who had been warming up after Montero’s walk and he strikes out pinch hitter Javier Baez to end the game and pick up a cheap save.

For the Pirates it was all good news at the plate. Walker’s return seems to have energized the lineup and four hitters had two hits each. For Happ who gets the win it was a bit of a struggle, walking four and allowing 6 scattered hits, including Russell’s blast, but he gave the bullpen a rest and the Pirates move into first place by percentage points over the Dodgers, who have not played today.

For the Cubs, another disappointing night for the bullpen, Motte looked terrible again, and while Hunter did not get scored on, he was saved by a crucial double play. But Fowler seems locked in, and if Rizzo and Bryant can get more consistent with their hitting they could really go on a tear.

Around the horn:

Mark Trumbo of the Mariners went 4-5 with a two run homer as Seattle gets a rare win over the Rangers, 7-5.

Pitching has been a bit dominant of late. Although the Tigers lost another game late, starter Anibal Sanchez ties the record for longest no hit bid by a D pitcher at 4.1 innings. He had a perfect game broken up by Torii Hunter’s single. Torii is limping into retirement at a .216 clip.

The Angels needed every bit of Garrett Richard’s terrific evening. Richard took a no hitter into the 6th inning and allowed just two hits overall as the Angels beat the A’s 2-0. Both hits were by Steve Vogt, who has been on fire after being injured on opening day. He is hitting .353 with a pair of homers since his return.

[photo credit]

Posted by: | Category: replay | Tags: , , | Leave a comment

8
February

Weird Card Wednesday: 1974 Phil Gagliano

2860

My friend Don Smith has been conducting a little Illowa APBA League “spring training” for his Molly Putts Marauders before our regular season starts.  I’ve seen some of his writeups on Facebook.  Quite enjoyable. 

Don told me that in his quest in finding teams to play Molly, he ran across this 1974 Phil Gagliano card from the Reds.  Now Phil was in his last year of his career and didn’t hit much.  However for some reason, he managed to draw a fair amount of walks in his short playing time.  He went 2 for 31 for a dismal .065 average but still walked 15 times! 

 

Split G GS PA AB R H 2B 3B HR RBI SB BB SO BA OBP SLG
1974 Totals 46 0 46 31 2 2 0 0 0 0 0 15 7 .065 .370 .065
Provided by Baseball-Reference.com: View Original Table
Generated 2/8/2017.

 

Hitting-wise, Phil’s card is pretty much like your standard American League pitcher’s card (7-8-9).  Then you get to the 14s.  He has a total of 12 of them. 

I guess if you absolutely, positively need that runner on base, right?

I told Don that I was familiar with Gagliano.  He plays for the Cardinals in my 1966 replay.  Gagliano was never a full-time star but 1965-1967 was as close as he would come to being a big part of the team.  APBA-wise, his 1966 card is pretty tame compared to this one. He has 0-0-7-7 plus a 15-10.  Oh and he only has three 14s.

I happened to notice that Phil Gagliano passed away just a month and a half ago on December 19, 2016.  I happened to notice it on Baseball Reference’s front page recognizing recent deaths.  While I had no previous connection with him, I felt a twinge since he no longer was around only because of my 1966 replay.

thanks, Don!

Posted by: | Category: Card Analysis | Tags: , , | 1 comment

7
February

Prairieland 2 is nearing!

IMG_2524

It is getting close to April 1st and that means Prairieland 2 tourney time!  More to the point, in less than two weeks, tourney participants will be selecting their teams and fantasy players in a two-round snake style draft. 

The draft will begin on February 18 and Eric Berg is taking over the process.  Here is his write-up on the matter on his blog, Red 11. 

Again, the details:

Date: April 1st, 2017
Time: Starts at 9am
Location:  Drury Inn, Champaign, Illinois
Cost: $15.00

We’re currently at 22 participants right now.  We don’t plan on turning anyone away even after the selection process so if you decide you want to have some fun, we would love to have you! 

Posted by: | Category: Tournament | Tags: , | Leave a comment

6
February

Monster Card Monday: 2016 Zach Britton

britton2016

When Pastor Rich Zawadzki sent me this Zach Britton card for last season and said “Monster card”, I first thought he was referring to Zach’s hitting skills.  I’m a little behind the times though.  It was in 2011 when Britton was a C starter but had double 1s and a 25-7

Of course, once I saw Rich’s card, I was instantly reminded of Britton’s excellent season out of the pen last year.  His 0.54 ERA and 47 saves for the Orioles qualified him for the rare A&B* grade. 

I Split W L W-L% ERA G GF CG SHO SV IP H R ER HR BB SO
  2016 Totals 2 1 .667 0.54 69 63 0 0 47 67.0 38 7 4 1 18 74
Provided by Baseball-Reference.com: View Original Table
Generated 2/6/2017.

By the way, Britton’s grade translates to 28* if you’re playing the Master Game.  That’s two points less than the highest MG grade of 30 given out by APBA.  In addition, Britton struck out 74 batters and only walked 18 in 67 innings.  For that, he will receive the additional threat of the XYZ ratings.  Batters beware!

Did Zach get a monster hitting card?  Nope, he received a standard 7-8-9 American League pitchers’ card.  That’s ok.  Hitting isn’t in his job description anymore. 

thanks, Rich! 

Posted by: | Category: Card Analysis | Tags: , , | 3 comments

Back to top