kamagra oral jelly cvs

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

9May/11

The Preakness 2011

Click here for the latest version of the 2011 Preakness Stakes Office Pool Spreadsheet Calculator

This version update has the post position included.

Posted Wednesday, May 18, 2011 5:09 PM Central Time


Click here for the 2011 Preakness Stakes Office Pool Spreadsheet Calculator

This version is has the horses listed with the dosage index, odds, earnings but not the post position as that has not been determined yet. It also has a blurb explaining the Thoroughbred Dosage Index in the "copy to new document and email" sheet to help you make better picks for the race.

Posted Tuesday, May 17, 2011 10:52 PM Central Time


Here is the blurb I added on the dosage index:

The Dosage Index is a calculation based on the horses pedigree that indicates whether the horse is built for speed over shorter distances or endurance and longer distances. The higher the index the speedier that horses relatives were the lower the index the greater his relatives did at longer distance races. A DI of 1.00 indicates a balance of speed and stamina. The median dosage index of North American Thoroughbreds is 2.4. In recent years it has been very rare to see a triple crown winner due to breeding of thoroughbreds for specific distances. The Kentucky Derby is the intermediate distance race of the North American Triple Crown being 1.25 miles, the Preakness is the shortest at 1.1875 miles and the Belmont the longest at 1.5 miles. So putting it together one might think the horse with the highest dosage index would do best at the Preakness and the one with the lowest best at the Belmont. But remember typical Thoroughbred races in North America vary in distance from 0.63 to 1.5 mi.

 

The Preakness Stakes 2011


3May/11

Kentucky Derby Office Pool Spreadsheet Calculator

Click here for the latest version of the Kentucky Derby Office Pool Spreadsheet Calculator

This update added a blurb explaining the Thoroughbred Dosage Index in the "copy to new document and email" sheet to help you make better picks for the race. I also made some cosmetic changes to the Enter Picks and Results sheet such as removing the gray background in some areas and coloring some of the gridlines white. This update did not affect the functionality of previous spreadsheet calculators.

Posted Saturday, May 4, 2013 9:06 AM Central Time


Here is the blurb I added on the dosage index:

The Dosage Index is a calculation based on the horses pedigree that indicates whether the horse is built for speed over shorter distances or endurance and longer distances. The higher the index the speedier that horses relatives were the lower the index the greater his relatives did at longer distance races. A DI of 1.00 indicates a balance of speed and stamina. The median dosage index of North American Thoroughbreds is 2.4. In recent years it has been very rare to see a triple crown winner due to breeding of thoroughbreds for specific distances. The Kentucky Derby is the intermediate distance race of the North American Triple Crown being 1.25 miles, the Preakness is the shortest at 1.1875 miles and the Belmont the longest at 1.5 miles. So putting it together one might think the horse with the highest dosage index would do best at the Preakness and the one with the lowest best at the Belmont. But remember typical Thoroughbred races in North America vary in distance from 0.63 to 1.5 mi.


This update added the post position for the horses and also added some hyperlinks to the "copy to new document and email" sheet to help with research of your horse picks for the office pool. It also fixed a problem with the 52nd participants points not showing up in the sortable ranking table. This will not affect the functionality of your previous spreadsheet calculator unless you have 52 participants participating in your office pool.

Posted Wednesday, May 4, 2011 6:25 PM Central Time


Click here for the 2011 Kentucky Derby Office Pool Spreadsheet Calculator

Posted Wednesday, May 4, 2011 1:45 AM Central Time


Use this spreadsheet to organize and run an office pool for the 2011 Kentucky Derby. I has the field listed on the left and participants can pick the order of finish. Points are awarded for correct picks for first, second, third and fourth, fifth through seventh, eighth through tenth, eleventh through fifteenth, and sixteenth through twentieth. Enter the results of the race and the calculator tabulates the points for the participants automatically based on the number of correct picks they made. The amount of points awarded for correct picks are adjustable. The calculator has a sortable ranking table for the participants. It supports up to 51 participants.

I plan on uploading an updated Microsoft Excel and Apple Numbers Office Pool Spreadsheet when the post positions for the horses are announced. Which is supposed to be Wednesday, May 4, 2011.

 

Kentucky Derby 2011