S
Saxman
I obtained an Excel spreadsheet from a free download sometime ago.
Basically, by typing in a rating for a horse, it calculates the chance
of a horse in fractional odds. I find it very handy after having rated
my own horses.
I would like to find out the formula used, but cannot find it amongst
the spreadsheet. As far as I know the spreadsheet is not protected. On
the first sheet where all the calculations are done, one cannot do any
formatting of cells. This is owing to the options being greyed out. (I
thought it might be useful just in case the formula text is white).
The spreadsheet includes a main sheet and 16 other sheets. Although I
have deleted the 16 sheets, the formula still works on the main sheet,
yet the output cells make reference to another sheet. (I tried this
option temporarily in order to see if a received an error message).
Also, formatting of the other sheets is allowed.
If I copy/paste special the main sheet and 'select all' to another
workbook, the formula does not carry over.
Set below is the user instructions that are on the main sheet.
.....................................................................
Spreadsheet for converting a set of ratings into a set of odds.
1The spreadsheet comes with a 5-runner race already rated.
2Highlight column H and press the 'delete' key to begin.
3 Enter the ratings in column H , using cells H1,H2 etc
4The odds, calculated to a 100% book, are shown in cells J1,J2 etc
Notes
A minimum of 3 horses and a maximum of 40 horses is allowed.
If a horse is later declared a non-runner , clear it's cell. Do not
enter N/R or anything else.
Negative scores are permitted.
The 'unusual' SPs of 10/9 and 95/40 are not included in this
conversion
table , the maximum SP allowed is 100/1 and the minimum SP is 1/10.
.........................................................................
Any help would be appreciated.
Basically, by typing in a rating for a horse, it calculates the chance
of a horse in fractional odds. I find it very handy after having rated
my own horses.
I would like to find out the formula used, but cannot find it amongst
the spreadsheet. As far as I know the spreadsheet is not protected. On
the first sheet where all the calculations are done, one cannot do any
formatting of cells. This is owing to the options being greyed out. (I
thought it might be useful just in case the formula text is white).
The spreadsheet includes a main sheet and 16 other sheets. Although I
have deleted the 16 sheets, the formula still works on the main sheet,
yet the output cells make reference to another sheet. (I tried this
option temporarily in order to see if a received an error message).
Also, formatting of the other sheets is allowed.
If I copy/paste special the main sheet and 'select all' to another
workbook, the formula does not carry over.
Set below is the user instructions that are on the main sheet.
.....................................................................
Spreadsheet for converting a set of ratings into a set of odds.
1The spreadsheet comes with a 5-runner race already rated.
2Highlight column H and press the 'delete' key to begin.
3 Enter the ratings in column H , using cells H1,H2 etc
4The odds, calculated to a 100% book, are shown in cells J1,J2 etc
Notes
A minimum of 3 horses and a maximum of 40 horses is allowed.
If a horse is later declared a non-runner , clear it's cell. Do not
enter N/R or anything else.
Negative scores are permitted.
The 'unusual' SPs of 10/9 and 95/40 are not included in this
conversion
table , the maximum SP allowed is 100/1 and the minimum SP is 1/10.
.........................................................................
Any help would be appreciated.