Updated R-column calculator

I’ve attached an update to my RB card calculator. This version fixes a minor calculation issue that impacted some RB. Most of the additions are explained in the notes. The biggest addition is that the spreadsheet will now give an estimate of how often the entered card will generate various gains. There was a discussion recently on ABTL regarding the 1983 John Riggins card. I hope that this spreadsheet will shed some light on those type of questions.

RB Card Calculator V2

Dan Flynn’s “Yards per Catch” Innovation

Mr. Dan Flynn is an avid APBA Football player who recently contacted me regarding a Yards per Catch (YPC) innovation that he created. His “YardsPerCatch” spreadsheet allows the calculation of YPC ratings.  It also includes the chart used to determine the adjusted yardages.  The system allows for a range of YPC ratings from -5 to 10.  These ratings when used with the chart included will adjust the receivers YPC to more closely match their actual YPC. Mark Zarb and I reviewed the innovation and provided feedback. After several back and forth emails, Dan was nice enough to provide me with the finalized YPC spreadsheet and his methodology behind creating the innovation to share with the community. The instructions for usage are inside the spreadsheet.

I would like to thank Dan for all his hard work and attention to detail in creating this fine innovation. A job well done!

Dan Flynn’s YardsPerCatchUpdate

Dan Flynn’s Methodology for YPC Innovation

Shane Gleeson’s “Play Calling” Program

CFB Play Selection

This morning I received an email from a gentleman named, David Macias, introducing a “Play Calling” program for College APBA Football. A little background, although David is a lifelong APBA Baseball guy, he recently dived into APBA Football. He hired his friend, Mr. Shane Gleeson, to create an Excel play calling program that would disperse the rushes and pass attempts realistically among the players on a team based on their real-life stats. Dave has been using it for his 2019-2020 college replays and is extremely pleased with how well it has worked. The “Play Calling’ program scrubs the Sports Reference pages for the team and individual stats and has a two-tiered decision model. Say a team runs 60% of the time, it will call for 60% run plays (or thereabouts) using the random number function. Once a run has been established, it will then look at the number of rushing attempts and dole out the carries based on the percentages each player ran the ball. David recommends employing a “common sense” manual override for situational downs. For example, always call a pass play on second down and long or on more or third and medium/long situations. He always calls a run on third or fourth down and short situations (1 or 2 yards). Just refresh the screen (pressing F9 key) until you get either the applicable pass or run call.

What I love about the program too is that he added a yearly function in there so that you can go back and pull up any year you want as well. He is nearly complete with an NFL version of this “Play Calling” system.

Mr. Shane Gleeson owns the “intellectual rights” to this innovation. I have received his permission to make this available to the public free of charge with the caveat he receives the recognition. In addition, he is available to do custom work if anyone has any ideas for upgrades to this existing program or the creation of any new project. Shane’s contact information is s.gleeson@outlook.com.

Managing “QB Rushing Attempts”

So you are thinking about replaying the Chicago Bears 1972 season and have concerns that Bobby Douglass won’t reach his total amount of rushing attempts (141). Will additional called runs be required? If so, how many are required? This video answers those questions with a simple math-based, two-step process that are applicable to both either mobile or non-mobile quarterbacks.   

QB Rush Deficit Calculator

2-Minute Offense – Manual Timing

There have been a number of innovations I’ve seen recently that try to take account of the radically different timing that occurs in 2-minute offense situations.

Each to their own I say, and whatever you feel comfortable with is right for you. For me personally, I’ve used manual timing inside the 2-minute warning for some time now. In my opinion, it’s the only realistic way you can replicate hurry-up timing, or go to slow-down when a team wants to milk the clock. Manual timing involves going away from APBA’s half-play system and requires you to record the timing completely separately. For those that record play-by-play (as I do), it’s not a problem to incorporate the play clock as well.

Here is my latest version of the timing rules I use. I use manual timing inside the last 2:30 of any half or OT period. I’ve benchmarked them against more than 50 actual NFL gamebooks and they are remarkably accurate.

The timing rules require use of a Timing Chart, that lets you know how much game clock is used depending on the length of the play or return.

I’ve also developed a chart for use when the FG unit needs to hurry on at the end of the half with the clock ticking down. Is there enough time left to get the kick away?

As always, comments welcomed.

2-minute timing

Macro or Auto-Sort “Standings”

In this corner, we have the number 1 contender, Auto-sort, versus the champion, Macros, in a title bout for the “Most User-friendly APBA Football Standings”. In this title bout the APBA Football community is the winner because both methods are tremendous timesavers. I’m always looking for ways to improve all facets (preparation, method of play, data input and reporting) of my replays and am blessed to have really smart friends. Denny Hodge created the auto-sort version and my APBA Football brother, Mark Zarb, created the macro-version.

These standings are designed to use in conjunction with the team workbooks that I posted a few days back. All you have to do is link each teams win, loss, tie, points scored and points allowed to the template. If using the auto-sort workbook, just link to gray-colored section.

Usage is very simple, for the auto-sort just open the file and the standings automatically adjust for each team’s winning percentage. For the macro version, just simultaneously press CTRL R keys and each divisions winning percentage is sorted. Press a second time and each divisions win record is sorted and press a third time and each division is alphabetically for teams with identical records. These functions happen a mind-numbing speed.

I know which one is my favorite but they are both winners in my book! Unfortunately WordPress doesn’t allow macro files to be inserted into a post but if interested email me at greg.barath@oguard62.net and I will send you the file.

2002 Standings(auto sort)

Tweaks to Existing Innovations & Introducing a New One

For several years now, Mark Zarb and I have corroborated numerous innovations and ideas with regard to APBA Football. Mark is the “brains”, he comes up with the conceptual ideas and transforms them into procedures or innovations. I apply those ideas/innovations to my replays to determine the effectiveness. Now, that Mark is playing full-time, we have double the data points to determine if it “works or not”.

The primary reason I replayed the 1969 AFL season was to be able to compare the statistics of the two replays. The following is the four objectives that I evaluated:

Objective 1. Assess adjustment to Fletch67 defensive ratings and Key against the Run.

Objective 2. Assess change to Double Coverage (Keying) formula for both Neutral and Situational downs.

Objective 3. Assess if change to “Situational Down and Distance” chart affected opponent’s ability to convert third down.

Objective 4. Assess frequency and playability of new “Pass Rush Impact” innovation.

Test Report