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.

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.