Ed's
NFL Office Pool
Spreadsheet / Calculator


Version 3.04


Now available for
the 6th straight year!

Updated
with the 2017
NFL Schedule!

Updated
to support the
Chargers move
to Los Angeles

 




Frequently Asked Questions

 

Note:  The calculator is an Excel spreadsheet that uses "macros." 
When the workbook is first opened, depending upon your security settings,
you may have to enable macros if you see that warning message.



 

The calculator looks great! Will it work on my Mac?

I don't know!  Prior versions would not have worked, since the program used Active-X Control Buttons, which is a Windows-only technology.  But since I've removed all of the Active-X code, it might!  Alas, I don't own a Mac and I don't have access to one, nor am I familiar with them, so it's hard for me to test any of this.

Of course, the program should work if you're using the program on a Mac via some sort of a Windows emulator. 




I'm having problems with this program at work.  Does it have anything to do with our company firewall?


Most likely.  One or two users have now reported problems with it at work with their "very robust firewall."  However, when they ran it on their computers at home, they had no problems.




I've read your detailed Help tab, I've played around with the program, and I'm still having problems!  What should I do?


Most likely it's something simple, since so many users are now using the program with no problems whatsoever.  E-mail me a copy of the calculator with your picks entered, describe the problem as best you can, and I'll take a look at it.




Week #1 has two Monday Night games. 
Does the calculator add the total points from both of the Monday Night games for the tie-breaker?

No, it only uses the second Monday Night game.  However, if you wish the calculator to determine the winner based upon the total for both games, it's easy.  Simply overwrite/edit the Monday Night total the the program enters, with the total points scored in both games.  This total is located in cell S10 on the Main page.  After entering this total, click on the NFL Office Pool graphic, located underneath the RESET button, to recalculate everything.

Alternately, if you want the calculator to use the just first Monday Night game, simply switch these two games in the NFL_Schedule worksheet tab!  As it is written, the program will always use that last game's total score in the NFL_Schedule tab.





My office pool requires players to pick teams against the NFL pointspread.  Can I still use your program?

Of course!   You have two options.  (1) Just use the toggle buttons to toggle the winner of each game, taking the pointspread you are using into account.  For example, if the Lions beat the Bears by 3, but your pool spread was Chicago +4, toggle Chicago as the "winning team," not Detroit!  (2)  Or, enter the pointspread you are using in the NFL_Schedule tab.  When downloading the scores from the internet, the program will use the scores and your pointspread when determining the "winning team."




Our pool uses the Monday Night game as a tie-breaker too, but with our pool the winner is determined by the player coming closest to the Monday Night total score, without going over!   Can you modify your pool to accommodate this?

Good suggestion.  Done.  It's a new user option with version 2.14.  This, of course, is known as The Price Is Right scoring.




I run a very large pool (often more than 80 players) and your program seems a little slow.  Other than that, wow, it works great!


Alas, Visual Basic is not known for its speed.  However, the latest version, version 3.0, is MUCH faster than previous versions.  Also, note that you can bypass the logic that determines if every player is still alive, in the User_Options worksheet tab.  This will speed up things considerably.  Finally, if you happen to have any other workbooks open, try closing them.  If your other workbooks have a lot of volatile formulas, that can slow this workbook down.




I run our office pool and I'd like to use your calculator to help manage it.  My co-workers submit their picks to me via an Excel program.  Can I import these picks into your calculator, so I don't have to enter them manually?


Send me a copy of what your Excel pick sheet form looks like.  I might be able to help.  And yes, this is very possible, and if you're running a large pool you definitely should be importing the picks instead of entering them all manually.




I think I found a bug!


It wouldn't surprise me.  With a program this size (thousands of lines of code) it's not only possible, it's very likely there's a bug or two just waiting to be found.  Ideally, send me a copy of your spreadsheet with the picks you entered, and the steps required for me to reproduce the bug, so I can see what's going on at this end.

 

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