Whoo hoo!   Beginning its 10th year!
Ed's
NFL Office Pool Calculator/Workbook
Version 4.01
An Excel workbook using Visual Basic macros, to manage your weekly NFL Office Pick'em Pool!

All set up and ready to go for 2021!
All set to include this season's additional 17th game!


 


To use the workbook, your PC must have, of course, a copy of Microsoft Excel on it,
and you must be able to run Excel macros to use the program.

(Note:  Unfortunately, I don't believer there exists any Excel phone app that supports macros.)

 

 

For the first several years, the workbook was completely free! 
All contributions were voluntary.  These last few years I began charging a very small fee for the workbook.

This year, the workbook is free again!!! 
Donations are still very much appreciated.

(Last year, because of the pandemic, I suspect many offices did not run a football pool. 
Let's hope this year is a better one.)

2020 Office Pool Survey Results Can Be Found Here!


 

Program Features!
 

  • After entering the selections for everyone in your office pool, the calculator then does the rest!  At the click of a button it will download the NFL scores for you and automatically determine the winner of your pool!  No more manual calculations!  It will save the results from week to week, for those who wish to keep a running total, for simply for bragging rights.   
     

  • The program will also automatically generate a cross-reference chart, indicating exactly how many games each player picked differently from everyone else!  No other spreadsheet or online service has this feature!
     

  • You can also easily play "what if?"  Who would have won the pool if this team had won instead of that team?
     

  • As just a few of the winning teams are determined, the calculator will automatically determine which players are still alive and which players are mathematically eliminated!  No other spreadsheet or online service has this feature!
     

  • The calculator now has the ability to import picks from Excel pick sheet Forms.  If you manage a large office pool, this feature may be desirable.  You won't have to enter their picks manually into the program!

  • The calculator supports "regular" pools and pools that use Confidence Points!  
     

  • The program supports pools that use (or ignore) the NFL pointspread!
     

  • The calculator supports a full schedule of the 16 weekly games or a smaller subset!  (Your office pool doesn't have to use the Thursday evening game, for example.)
     

  • At the request of several users, a running total of prior week's scores are kept!
     

  • There are many options to customize the program to your own personal taste!
     

  • Two different weekly pick sheet forms, for all 17 weeks of the NFL season, are included!

 

 

Home  /   About   /   Necessity   /   How To Use   /   Comments   /   Revisions   /   Donations