2011 RUGBY WORLD CUP NEW ZEALAND
Office Pool Spreadsheet Bracket Calculator
Please test the functionality of your calculator prior to entering all your data as some versions of Microsoft excel do not seem to support the formulas I have used.
Updated Tuesday, September 13, 2011, 7:15 P.M. Central Time
This version corrected an error in the "Enter Picks & Results" sheet with auto-filling the group stage participants picks into rows E,34 to BB,34 and E,44 to BB,44 for the quarter-final match-ups.
If you want to correct the error without re-downloading the calculator and having to re-enter your picks follow these instructions:
Click on square D,34 and copy it, then highlight squares E,34 to BB,34 by clicking in E,34 then going to Square BB,34 and holding the shift key while you click on that square. This should highlight all the squares from E,34 to BB,34, then click paste and it should paste the function that you copied from D,34 into all these squares. This should rectify the issue for any false reading you were getting in row 34.
Then do the same for D,44 that is copy the D,44 square's function into squares E,44 to BB,44
Another way you can copy the function into those squares at least in Apple Numbers is to click on the square whose function you want to copy into the adjacent squares and click and hold the little dot in the lower right hand corner of the highlighted square and drag it over the squares that you want that formula to be. In this case click on D,44 and drag that function to the right over squares E,44 to BB,44.
Rugby World Cup New Zealand
Friday Sept. 9, 2011 to Sunday Oct. 23, 2011
Office Pool Spreadsheet Bracket Calculator
• SUPPORTS 51 PARTICIPANTS
• SORTABLE LEADER BOARD
• ADJUSTABLE SCORING SYSTEM
• AUTO-CALCULATES PARTICIPANT POINTS
• FREE DOWNLOAD NO REGISTRATION
• VIDEO HOW TO TUTORIAL
• TEAMS LISTED WITH IRB RANK
• CLICKABLE LINK TO IRB RANKING PAGE
• US CENTRAL & LOCAL TIME FOR MATCHES
• SINGLE PAGE PRINTABLE BRACKET
• AUTO-POT TOTALING
• AUTO-PRIZE MONEY DISTRIBUTOR FOR 4
• ENTRY FEE BOOK-KEEPING
• MICROSOFT EXCEL & APPLE NUMBERS FORMAT
• CLICK HERE TO DOWNLOAD
This video explains how to use the office pool spreadsheet bracket calculator.
Leave a comment