Shane, you may already be aware but there's a way whereby you only have to type the fractional odds in to one cell, e.g.

[   This image is no longer available.   ]

The picture below shows the formulas.  I use Open Office Calc but if you're using Excel just change the semicolons to commas.

[   This image is no longer available.   ]

Spoiler: Show

Date	Name	Total
Dec-12		£
Nov-12	hong kong fooey	£15.17
Oct-12	DubaiPrince	£11.69
Sep-12	hong kong fooey	£22.50
Aug-12	DubaiPrince	£24.81
Jul-12	Red Bloom	£15.16
Jun-12	little bobby	£5.21
May-12	DubaiPrince	£23.15
Apr-12	mini me	£19.35
Mar-12	I am the one & only223	£16.90
Feb-12	Value Seeker	£21.63
Jan-12	I am the one & only223	£19.44
Dec-11	general custer	£10.33
Nov-11	hong kong fooey	£39.00
Oct-11	la mallatiere	£22.34
Sep-11	hong kong fooey	£55.33
Aug-11	shearer2therescue	£21.23
Jul-11	Tightfisted	£23.82
Jun-11	mr d ferret	£28.99
May-11	Moose	£19.18
Apr-11	Fidway	£16.87
Mar-11	josh monk	£35.50
Feb-11	Fidway	£14.29
Jan-11	Grendel	£21.64

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.                                                                                                                
                                                                                                               
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.                                                                                                                
                                                                                                               
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.                                                                                                               
                                                                                                               
3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.                                                                                                               
                                                                                                               
4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).                                                                                                               
                                                                                                               
5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.                                                                                                               
                                                                                                               
6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.                                                                                                                
                                                                                                               
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.                                                                                                               
                                                                                                               
3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.                                                                                                               
                                                                                                               
4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).                                                                                                               
                                                                                                               
5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.                                                                                                               
                                                                                                               
6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.                                                                                                               
                                                                                                               
7 - LAST DAY RULES for the last day of the month : all selections must be made BY THE SCHEDULED OFF TIME OF THE FIRST RACE of the day, you can't choose a horse already selected by another competitor in the same division, and only named horses are allowed.                                                                                                                
                                                                                                               
8 - On any day that a competitor does not post (excluding Sundays and final days) they will automatically revert to the Last Race Favourite (UK only). However, once the total of non-selections for a month reaches 10, further days where no selection is made in that month will count as a Non Selection. In the case of more than one favourite in the race it will be settled on the favourite with lowest race-card number. Competitors will be able to opt out if they wish, in which case the standard Non Selection rule will apply.                                                                                                               
                                                                                                               
9 - Reserve selections to cover the possibility of non-runners will be allowed, but they must be running in the same race as the main selection or a subsequent race.                                                                                                               
                                                                                                               
10 - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.                                                                                                               
                                                                                                               
11 - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).                                                                                                               
                                                                                                               
12 - Quite often, things can crop up that aren`t strictly covered by the above rules (grey areas) in these instances please abide by the individual settler`s decision/ruling.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.                                                                                                                
                                                                                                               
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.                                                                                                               
                                                                                                               
3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.                                                                                                               
                                                                                                               
4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).                                                                                                               
                                                                                                               
5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.                                                                                                               
                                                                                                               
6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.                                                                                                               
                                                                                                               
7 - LAST DAY RULES for the last day of the month : all selections must be made BY THE SCHEDULED OFF TIME OF THE FIRST RACE of the day, you can't choose a horse already selected by another competitor in the same division, and only named horses are allowed.                                                                                                                
                                                                                                               
8 - On any day that a competitor does not post (excluding Sundays and final days) they will automatically revert to the Last Race Favourite (UK only). However, once the total of non-selections for a month reaches 10, further days where no selection is made in that month will count as a Non Selection. In the case of more than one favourite in the race it will be settled on the favourite with lowest race-card number. Competitors will be able to opt out if they wish, in which case the standard Non Selection rule will apply.                                                                                                               
                                                                                                               
9 - Reserve selections to cover the possibility of non-runners will be allowed, but they must be running in the same race as the main selection or a subsequent race.                                                                                                               
                                                                                                               
10 - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.                                                                                                               
                                                                                                               
11 - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).                                                                                                               
                                                                                                               
12 - Quite often, things can crop up that aren`t strictly covered by the above rules (grey areas) in these instances please abide by the individual settler`s decision/ruling.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.                                                                                                                
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.                                                                                                               
3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.                                                                                                               
4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).                                                                                                               
5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.                                                                                                               
6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.                                                                                                               
7 - LAST DAY RULES for the last day of the month : all selections must be made BY THE SCHEDULED OFF TIME OF THE FIRST RACE of the day, you can't choose a horse already selected by another competitor in the same division, and only named horses are allowed.                                                                                                                
8 - On any day that a competitor does not post (excluding Sundays and final days) they will automatically revert to the Last Race Favourite (UK only). However, once the total of non-selections for a month reaches 10, further days where no selection is made in that month will count as a Non Selection. In the case of more than one favourite in the race it will be settled on the favourite with lowest race-card number. Competitors will be able to opt out if they wish, in which case the standard Non Selection rule will apply.                                                                                                               
9 - Reserve selections to cover the possibility of non-runners will be allowed, but they must be running in the same race as the main selection or a subsequent race.                                                                                                               
10 - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.                                                                                                               
11 - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).                                                                                                               
12 - Quite often, things can crop up that aren`t strictly covered by the above rules (grey areas) in these instances please abide by the individual settler`s decision/ruling.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.
2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.
3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.
4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).
5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.
6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.
7 - LAST DAY RULES for the last day of the month : all selections must be made BY THE SCHEDULED OFF TIME OF THE FIRST RACE of the day, you can't choose a horse already selected by another competitor in the same division, and only named horses are allowed.
8 - On any day that a competitor does not post (excluding Sundays and final days) they will automatically revert to the Last Race Favourite (UK only). However, once the total of non-selections for a month reaches 10, further days where no selection is made in that month will count as a Non Selection. In the case of more than one favourite in the race it will be settled on the favourite with lowest race-card number. Competitors will be able to opt out if they wish, in which case the standard Non Selection rule will apply.
9 - Reserve selections to cover the possibility of non-runners will be allowed, but they must be running in the same race as the main selection or a subsequent race.
10 - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.
11 - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).
12 - Quite often, things can crop up that aren`t strictly covered by the above rules (grey areas) in these instances please abide by the individual settler`s decision/ruling.

1 - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Subject to Rule 8, failure to post will be deemed a Non Selection and 1 point will be deducted.

2 - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.

3 - Selections must be posted AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.

4 - Selections may be changed as long as it is at least 1hr prior to the original race OR if the selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).

5 - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.

6 - Sunday selections will be optional unless it is the last day of the month. On optional Sundays there will be no deductions for non-posters and Rule 8 will not apply.

7 - LAST DAY RULES for the last day of the month : all selections must be made BY THE SCHEDULED OFF TIME OF THE FIRST RACE of the day, you can't choose a horse already selected by another competitor in the same division, and only named horses are allowed.

8 - On any day that a competitor does not post (excluding Sundays and final days) they will automatically revert to the Last Race Favourite (UK only). However, once the total of non-selections for a month reaches 10, further days where no selection is made in that month will count as a Non Selection. In the case of more than one favourite in the race it will be settled on the favourite with lowest race-card number. Competitors will be able to opt out if they wish, in which case the standard Non Selection rule will apply.

9 - Reserve selections to cover the possibility of non-runners will be allowed, but they must be running in the same race as the main selection or a subsequent race.

10 - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.

11 - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).

12 - Quite often, things can crop up that aren`t strictly covered by the above rules (grey areas) in these instances please abide by the individual settler`s decision/ruling.

1. - You have to choose 1 horse each day. Winners will be returned at SP/Industry Prices and stake is 1 point. If no SP/Industry Price is returned winning selections will be settled as non-runners. Non selection means a loser.

2. - All UK and Irish races are eligible along with the Dubai Festival and the Sunday Arc de Triomphe meet.

3. - Selections must be made AT LEAST 1 hour before your selected race. Failure to comply will result in the selection being declared Invalid and treated as a Non Selection.

4. - Selections may be changed as long as it is BEFORE 1hr prior to original race OR if selection is a NR or deemed invalid ( Rule 3 MUST still be adhered to).

5. - Rule 4 and Dead Heat rules will apply to SP/Industry Prices.

6. - Sunday selections will be optional. No deductions for non posters. (it will be compulsory if Sunday is last day of the month).

7. - LAST DAY RULES for every last day of the month : all selections must be made BY THE SCHEDULED OFF OF THE FIRST RACE of the day, you can't choose any horse already selected and only named horses are allowed (no instructions).

8. - Instructions to cover holiday / days can't post will be allowed but under the following STRICT guidelines :
- The instructions you wish to use must be clearly stated (Sundays will not have instructions applied unless EXPLICITLY stated otherwise).
- Instructions will be applied to GB mainland races only UNLESS explicitly stated otherwise. Ie Eire & Northern Ireland
- Only 10 days on instructions which do not name horses (i.e last fav , Spotform's nap etc) will be allowed each month. Once that has been exceeded one point per day will be deducted.
- Horses selected from the five day entries will be allowed. If they do not run they will be treated under the non runners rule and will not count towards the 10 day instruction maximum.
- In the case of more than one favourite in a race Instructions will be settled on the favourite with lowest race-card number.

9. - In the event of a tie the person who has used least instructions will be deemed to finish above the person they have tied with.

10. - In the event of a major Betfair upgrade which may affect the ability to post on the Forum before racing starts that day will have Sunday rules applied (ie. no deduction for non-posters).

11. - Reserve selections are allowed only in the event of the possibility of abandoned meetings.

12. - Quiet often things can crop up that arn`t strictly covered by the above rules (grey areas) In these instances please abide by the individual settlers decision/ruling.