Fast catcher Paul Casanova appears to have quite the slugging year in 1967 for the Senators. His APBA card shows 53 under the HR column.
In reality, Casanova had just 9 dingers in ’67. He had 53 rbis. My guess is that the homerun column was deleted and all subsequent data was shifted to the left.
Thanks, Dan Oliverio!
Dave Larson’s Taz Devils (49-32) emerged as the winner the 2017 OAPBA World Series, edging Jonathan Stilwell’s Otters (45-36) in a hard-fought World Series to give the Devils the 2017 OAPBA championship. The teams were evenly matched, with two games going into extra innings and the Devils scoring 18 runs…
I want to wish all APBA fans a Merry Christmas and Happy Holidays! I hope these days are festive for everyone or at the very least, stress-free. I have to give kudos to my Illowa APBA League commissioner, Mike Bunch who is so dedicated to our league that he emailed…
Kevin Weber sparked a good conversation on Facebook with this 1941 Pete Reiser. There is certainly a lot to talk about. Reiser was born in St. Louis but he definitely bled Dodger Blue. He led Dem Bums to the pennant in 1941 while leading the NL in hitting (.343), runs…
Hey APBA replayers who use Excel, I have another Replay Stats with Excel video up on YouTube. As always this is using my 1966 NL replay.
[be best if you watch in full screen mode to see all the Excel goodness]
This episode deals with creating a league standings table. As with most everything in my Excel setup, it is pretty much self-sustaining once you create it. The biggest concept used is linking cells as you are simply pasting links from each team’s total pitching wins and pitching losses.
It isn’t too difficult to create and once you do, you can format to your heart’s delight to make it look nice. The trickiest part for me was the Games Back formula. I have found one that has worked pretty well. Here it is broken down…
Assuming the first place team is on row 4 and the Wins column is C and the Losses column is D, this formula should be entered for the first place team:
=(($C$4-C4)+(D4-$D$4))/2
Since the first wins cell and the last losses are absolute references, you should be able to copy and paste that formula (or simply click and drag it down as in the video) and the relative cells references will change and the absolute ones will not.
Files used in this video
Here are the Excel files I was using during the video. They are compressed in .zip format.
Mentioned in this video
This Week in APBA by John Asalon
Coming up next: Pivot tables! Also coming up: Game schedules and results.
If you want to watch past replay Excel tutorial videos in this series, here is the link. I hope this helps!
Dave Larson, Apopka, FL, has been an APBA replayer for nearly forty years. Dave oversees the long-running Orlando APBA Association, which is heading into its 30th season in 2018 and has conducted one of the most ambitious replays I have ever learned of—using teams from all 50 states and overseas,…
This is the reason I purchased the 1915 season. In the real world, this was the closest pennant race in baseball history with three teams finishing within a half game and the fourth-place team 5 games out. I did this season in windows with myself mainly managing the Cubs, and…
Some fans at the time who saw both Ruth and Gibson play called Ruth “the white Josh Gibson”. I have been to the town of Pittsburgh several times in past years for various reasons. Every time I visit and no matter what the reason, I find myself drawn to…
This 2009 Phil Hughes card (published that same year) is a bit strange but I kind of like it. Check out his pitching grade. He is a Grade D (A&C*) (XY). As APBA players, we’re mostly used to split grades like C(B*) or D(C*). On occasion, we will see a…
Beau Lofgren sent in this nifty 1994 Rick Wrona card that was published just this year. Wrona certainly didn’t have a lot of playing time but APBA rewarded him with a fun card. Wrona ended his career in 1994 with Milwaukee. That year he went 5 for 10 for the…