trying to put together a football pool, 100 squares, 10 rows x 10 rows. Cant find the format to fit this idea
Here’s one version I’ve seen.
Here’s how it works:
1. Type the Home and Visitor team names in P1 and P2.
2. Hide the numbers using the option button to the right.
3. Print the worksheet.
4. Go collect 100 initials, one per box.
5. Type the initials in the boxes.
6. Show the numbers using the option button.
7. Print the final worksheet.
The numbers will change every time the worksheet calculates, and that includes when you show/hide the numbers. So be careful that you only show the numbers right before you’re ready to print. The final printed form will have the correct numbers, but the worksheet will not have those numbers if you do anything else that causes a recalc.
Not familiar with this type of pool? Take the sheet you printed in Step 3 around your office and sell each of the 100 squares. When a person buys a square (or squares), he writes his initials in the purchased squares. When all 100 squares are sold, the numbers are inserted in the top row and down the side. At the end of every quarter of the game, you find the winning square based on the last digit of each teams score. If, at the end of the first quarter, Nebraska is beating Iowa State by a score of 19 to 15, the person whose initials are in the top left square would be the winner for that quarter and get 25% of the pot. Do the same for the remaining three quarters.
Of course you should never do this where it is prohibited by law.
Update: Chip added some macros to lock in the numbers and report the winners. You can download FootballSquares20.zip for the macro version. Thanks Chip.