Office Pool Spreadsheets Auto-Scoring Office Pools Free Downloads No Registration

2Apr/11

Tennis Round Robin Match-Maker Bracket

Click here to download the Tennis Round Robin Match-Maker Spreadsheet

Use this match-maker spreadsheet to score and organize a tennis round robin event for up to 8 players competing in a round-robin singles event, 14 players competing in a round-robin doubles event or 16 players competing as teams of 2 in a round-robin doubles tournament.



Tennis Round Robin Match Maker for up to 14 singles players or 8 doubles teams

Tennis Round Robin Match Maker

Filed under: Tennis 1 Comment
9Feb/11

Double Elimination Tournament Brackets

Click here to download the 3 to 13 team Double Elimination Tournament Brackets
 
Use this spreadsheet to organize double elimination tournaments of various games including table tennis, volleyball, softball, football, soccer, chess, tennis, etc. It has a seeding sheet that auto-fills the brackets. The games are played in order to give the least downtime to participants.


Use this double elimination bracket for 3 to 13 team tournaments. It has a seeding sheet that auto-fills the brackets.

Double Elimination Tournament Brackets

 

26Jan/11

Sports Player Ranking System Calculator

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



Sports Player Ranking System for 101 players of tennis, ping pong, table tennis, football, poker, chess, Texas Hold'em, basketball, volleyball, cricket

Sports Player Ranking Table


 
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.
 
Sports Player Ranking system for teams or players of football, tennis, ping pong, table tennis, volleyball, cricket, poker, chess, Texas hold'em, basketball, hockey, flag football

Sports Player Ranking System Data Entry Sheet

 

19Dec/10

About Office Pool Spreadsheets

I hope you enjoy my office pool bracket calculators at bracketman.com. Feel free to leave any comments.

For some reason I love working with spreadsheets and want to share some of my favorites with you.  One of the most useful tools I have found for spreadsheets is helping to keep up with an office pool. The spreadsheets I have created aim to give some information on the teams that are participating to make it easier to make your picks without doing a lot of research. They also aim to make it easy to track the points of the participants and provide a ranking table that can be copied and pasted easily into an email for keeping participants updated on the leaders of the pool. When appropriate I have included a bracket for tournament style events which can be handed out or copied and pasted into a new document and subsequently emailed to participants for filling out their picks. I have also tried to make a second sheet that is physically smaller than the original sheet where picks are entered so that this smaller sheet can be printed and posted for viewing.  I hope you find the spreadsheets useful.

2011 NCAA March Madness Bracket Calculator Demo Version