Ed's NFL Office Pool Spreadsheet / Calculator
is an Excel
Your PC must, of course, have a copy of Excel on it,
and you must be able to run Excel macros to
use the program.
(Note: I know of no Excel phone app that DOES run macros.)
Wow, can you
eight years old this year!
Where does the time go?
NEW WITH VERSION 3.14!
You now have the ability to IMPORT everyone's picks!
There is now no need to enter them manually. If you manage a
large office pool, it might be very desirable to import
The calculator understands the weekly pick sheet form available
(Update! And now with Version 3.17, it is capable
of understanding other formats too.)
Send out this Excel form to each participant and have them fill it out and
send it back to you.
Save each form in the same folder. Save each week in a
different folder. (So you might have a Week 1 folder, a
Week 2 folder, etc.)
After clicking the new IMPORT button from the Player_Picks
worksheet tab, the calculator will ask you to select a folder.
That's it! It will read all of the weekly pick sheet forms
found in the folder you selected,
and import them automatically into your calculator!