This updated version fixed a problem with the sortable ranking table that occurred when I added a merge cells format to put my dot-com and email address on that sheet.
Updated Monday, April 4, 2011 @ 11:42 PM
Click here for the latest version of The 2011 Masters Golf Tournament Office Pool Spreadsheet Bracket Calculator
This updated version is just prettied up a bit on the data entry page and I also included a clickable link to my home page and email address. The functionality of the Calculator was not changed.
Updated Monday, April 4, 2011 @ 10:30PM
Posted Sunday, April 2, 2011
Use this spreadsheet to auto-score an office pool for The 2011 Masters Golf Tournament. The spreadsheet awards points based on a participants correct picks. The picks are grouped so picking 3rd through fourth correct gives a certain amount of points, fifth through seventh another set of points, eighth through tenth another so on up to 42 picks. The points awarded are adjustable. The spread sheet includes a ranking table for the participants and the players in the tournament have their world ranking listed. Their is also a money distributor.
THE MASTERS 2011 GOLF TOURNAMENT
Office Pool Spreadsheet Bracket Calculator
• FREE DOWNLOAD NO REGISTRATION
• FIELD LISTED WITH WORLD RANKINGS
• ADJUSTABLE POINTS
• MICROSOFT EXCEL & APPLE NUMBERS FORMAT
• SORTABLE RANKING TABLE FOR PARTICIPANTS
• OFFICE POOL MONEY DISTRIBUTOR
• ENTRY FEE BOOK-KEEPING
• SUPPORTS UP TO 51 PARTICIPANTS
• VIDEO HOW TO TUTORIAL
• CLICK HERE TO DOWNLOAD
Click here to download the Sports Player Ranking System Spreadsheet Calculator
Use this spreadsheet to rank sports players or teams in a recurring sporting event of football, baseball, golf, soccer, table tennis, tennis, volleyball, baseball, cricket, chess, pool, cards, Texas Hold'em, Poker, flag football, basketball, bowling, or any game or sport. It supports up to 101 participants
This Ranking Table (above) auto populates from the data entry sheet below. Rankings are easily sortable. The ranking is based on the performance of the participants or teams in a recurring competition. Points for each match are awarded based on the number of participants for the particular game divided by the players finish, hence if there are 12 participants and a player finishes 1rst then he gets 12 points, if second with 12 participants then 6 points and on down to twelfth place getting 1 point (12 participants divided by 12th place). This point system is repeated for each match. The Ranking Calculator performs these calculations automatically after entering the number of participants in the match and the match results in the data entry sheet. If you base your ranking on performance over 6 matches then you enter the seventh match results over the first match results. I like this system because it encourages participation (if you don't show up for a match you don't get points) and it's an exponential reward for finishing higher i.e. there is great separation between finishing first as opposed to second but not so much difference between twelfth from eleventh if it's a 12 team/man competition for that match. Also the more participants in a match the more points you get for finishing first i.e. If there are 20 participants in a match and you finish first you get 20 points, if there a five participants in a match and you finish first you get 5 points.