My Spreadsheet - OHR

**The Duke** · **17-04-09**, **09:40 PM**

For those of you who have a copy of one of my spreadsheets, do you find it easy enough to use?

If you need advice on how to use the spreadsheet then please leave a message in here, and I'll try and produce a comprehensive guide on how to use it correctly.

I've made it as simple as possible and it was the sheet I was using last year to some success. The one I'm currently using is alot more complicated and needs someone who is very handy on excel to operate - that said, this sheet isn't available to the general public at the moment.

**rogsmith** · **17-04-09**, **09:57 PM**

Great stuff mate many thanks,but you may wish that you hadnt offered.

**givemeabreak** · **18-04-09**, **07:38 AM**

On the spreadsheet do i have this correct ?

When you do the card say it's 7 races you end up with the first variance figure, but when you want to then omit any that look as if they are throwing it out you then have to remove them completely from the sheet and therefore are not able to rate them on the sheet ?

**givemeabreak** · **18-04-09**, **08:24 AM**

Just noticed this, have put question in tutorial thread can it be moved to here pease

**Spook** · **18-04-09**, **09:12 AM**

Cheers Jamie,

even I can work this, but I do believe it might have a hitherto unrealsied application (unless of course its been realised already). Can you reverse the calculation? If you can then I think, you can use it as a tool for calculating standards, which might be helpful for other analysis

**The Duke** · **18-04-09**, **12:22 PM**

Yeah the calculation could/can be reversed no problem whatsoever.

What exactly would you need calculated and in what format?

**Spook** · **18-04-09**, **02:59 PM**

I don't know yet, and I coudl be talking rubbish by virtue of thinking allowed, but it would take a few stabs at it to try and work things out through trial and error but I was wondering how easy it might be to try calculate a standard out of?

On thinking about it, I'm almost certainly talking nonesense, or part nonesense at the very least

**The Duke** · **18-04-09**, **03:14 PM**

Originally Posted by givemeabreak

When you do the card say it's 7 races you end up with the first variance figure, but when you want to then omit any that look as if they are throwing it out you then have to remove them completely from the sheet and therefore are not able to rate them on the sheet ?

Put all the races in to begin with, then whichever two you wish to remove from the spreadsheet, just delete the line across. The spreadsheet will then automatically adjust the ratings and variance to the remaining races on the sheet.

Hope that helps.

**The Duke** · **18-04-09**, **03:18 PM**

Originally Posted by Spook

I don't know yet, and I coudl be talking rubbish by virtue of thinking allowed, but it would take a few stabs at it to try and work things out through trial and error but I was wondering how easy it might be to try calculate a standard out of?

On thinking about it, I'm almost certainly talking nonesense, or part nonesense at the very least

That doesn't really help lol. It's possible to switch around the calculation to do it in reverse to how it currently does things. Like I say I have a couple of advanced versions, one which is done using times per furlong instead of the mile average, and another which uses Mordin's standards.

I'm tempted to use the RP standards to incorperate their 'Rating' system on their website so I can input the data into each race result and eventually I'll have a mass pull of ratings at the click of a mouse.

**givemeabreak** · **18-04-09**, **03:22 PM**

Originally Posted by The Duke

Put all the races in to begin with, then whichever two you wish to remove from the spreadsheet, just delete the line across. The spreadsheet will then automatically adjust the ratings and variance to the remaining races on the sheet.

Hope that helps.

Yep cheers i thought it would be something like that, i guess it just means you don't rate the horses in those 2 races but i suppose if they are so freakishly out you have to remove them in the first place they would be of questionable value anyway.

**Spook** · **18-04-09**, **03:24 PM**

What you do with is something that allows you to beat beaten distances on a sub/ drop down menu which then calculates the next half dozen home too.

I think you could calculate a standard time for a hypothetical course on good ground (variance 0.00) at Gp 1. Once you have this figure expressed as a time you'd probably have to profile the indiviual quirks in by making the correction against the RP standard. I think it would work, and I'll have a play with it and see what happens. As with any noew toy it takes a bit of getting used to, and it coudl well be that my whole hypothesis is flawed (about 90% of such ideas normally are). What i don't know though, is even if you could do this to any level of reliability, would the figure be of any use anyway?

The enquiring mind has to investigate though

**broadsword** · **18-04-09**, **04:57 PM**

Originally Posted by The Duke

For those of you who have a copy of one of my spreadsheets, do you find it easy enough to use?

If you need advice on how to use the spreadsheet then please leave a message in here, and I'll try and produce a comprehensive guide on how to use it correctly.

I've made it as simple as possible and it was the sheet I was using last year to some success. The one I'm currently using is alot more complicated and needs someone who is very handy on excel to operate - that said, this sheet isn't available to the general public at the moment.

Duke if its possible could you send me one of these spread sheets I wouldn't know what one looks like or what to do with it but the good lady knows a bit so maybe she could help me out a bit

Thanks in advance.

**daresaints** · **18-04-09**, **06:26 PM**

Duke, think you've got another convert here - could you send me a copy of the spreadsheet as well

**mlmrob** · **18-04-09**, **08:54 PM**

I would like to have a copy of the spreadsheet as well Duke. Thanks. Rob

**The Duke** · **18-04-09**, **09:02 PM**

Please note that this spreadsheet is copyright of OHRacing, and must not be produced or sold on elsewhere. This is for your own personal useage only and for the benefit of the forum.

**Teekay** · **18-04-09**, **10:52 PM**

I'll have a copy aswell if you dont mind cheers

**gwynfi** · **19-04-09**, **12:22 AM**

And me please

**The Duke** · **19-04-09**, **09:06 AM**

Sorry but the sheet is only available for regular forum contributors.

**Spook** · **19-04-09**, **09:24 AM**

In fairness you'd need to be up to speed with the class par rating system for it to be of any use to anyone anyway

**quadrilla** · **19-04-09**, **10:16 AM**

Welcome Gwynfi, I take it that your from Tom Jones Land ? You have picked a great user name there. If you had choosed Hugebigharyjok, you would had no chance in finding support in receiving this amazing and unique spreadshit.

Keep the posts come.

**The Duke** · **19-04-09**, **05:59 PM**

Originally Posted by quadrilla

Welcome Gwynfi, I take it that your from Tom Jones Land ? You have picked a great user name there. If you had choosed Hugebigharyjok, you would had no chance in finding support in receiving this amazing and unique spreadshit.

No need to be a smart arse.

**rogsmith** · **25-04-09**, **09:44 PM**

Hello mate,im gradually reading my way through the speed rating info you sent and i think its making sense.The spreadsheet looks very good but what i would like to know is how you go about doing the ratings as in ,do you do every flat race,i assume you must have some kind of data base of horses and times etc etc.So really how would you suggest i start,and how do you use the ratings.Cheers mate.

17-04-09, 09:40 PM	#1 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	My Spreadsheet For those of you who have a copy of one of my spreadsheets, do you find it easy enough to use? If you need advice on how to use the spreadsheet then please leave a message in here, and I'll try and produce a comprehensive guide on how to use it correctly. I've made it as simple as possible and it was the sheet I was using last year to some success. The one I'm currently using is alot more complicated and needs someone who is very handy on excel to operate - that said, this sheet isn't available to the general public at the moment.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

17-04-09, 09:57 PM	#2 (permalink)
rogsmith Claimer Join Date: Mar 2009	Great stuff mate many thanks,but you may wish that you hadnt offered.

18-04-09, 07:38 AM	#3 (permalink)
givemeabreak World Class Join Date: Jul 2007	On the spreadsheet do i have this correct ? When you do the card say it's 7 races you end up with the first variance figure, but when you want to then omit any that look as if they are throwing it out you then have to remove them completely from the sheet and therefore are not able to rate them on the sheet ?

18-04-09, 08:24 AM	#4 (permalink)
givemeabreak World Class Join Date: Jul 2007	Just noticed this, have put question in tutorial thread can it be moved to here pease

18-04-09, 09:12 AM	#5 (permalink)
Spook World Class Join Date: Sep 2005	Cheers Jamie, even I can work this, but I do believe it might have a hitherto unrealsied application (unless of course its been realised already). Can you reverse the calculation? If you can then I think, you can use it as a tool for calculating standards, which might be helpful for other analysis

18-04-09, 12:22 PM	#6 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Yeah the calculation could/can be reversed no problem whatsoever. What exactly would you need calculated and in what format?

18-04-09, 02:59 PM	#7 (permalink)
Spook World Class Join Date: Sep 2005	I don't know yet, and I coudl be talking rubbish by virtue of thinking allowed, but it would take a few stabs at it to try and work things out through trial and error but I was wondering how easy it might be to try calculate a standard out of? On thinking about it, I'm almost certainly talking nonesense, or part nonesense at the very least

18-04-09, 03:24 PM	#11 (permalink)
Spook World Class Join Date: Sep 2005	What you do with is something that allows you to beat beaten distances on a sub/ drop down menu which then calculates the next half dozen home too. I think you could calculate a standard time for a hypothetical course on good ground (variance 0.00) at Gp 1. Once you have this figure expressed as a time you'd probably have to profile the indiviual quirks in by making the correction against the RP standard. I think it would work, and I'll have a play with it and see what happens. As with any noew toy it takes a bit of getting used to, and it coudl well be that my whole hypothesis is flawed (about 90% of such ideas normally are). What i don't know though, is even if you could do this to any level of reliability, would the figure be of any use anyway? The enquiring mind has to investigate though

18-04-09, 06:26 PM	#13 (permalink)
daresaints Blackandwhitearmy Join Date: Mar 2005 Location: Paisley	Duke, think you've got another convert here - could you send me a copy of the spreadsheet as well

18-04-09, 08:54 PM	#14 (permalink)
mlmrob Low Grade Handicapper Join Date: Jan 2009 Location: Durham	I would like to have a copy of the spreadsheet as well Duke. Thanks. Rob

18-04-09, 09:02 PM	#15 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Please note that this spreadsheet is copyright of OHRacing, and must not be produced or sold on elsewhere. This is for your own personal useage only and for the benefit of the forum.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

18-04-09, 10:52 PM	#16 (permalink)
Teekay World Class Join Date: Mar 2005 Location: Cramlington	I'll have a copy aswell if you dont mind cheers

19-04-09, 12:22 AM	#17 (permalink)
gwynfi Selling Plater Join Date: Jan 2009	And me please

19-04-09, 09:06 AM	#18 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Sorry but the sheet is only available for regular forum contributors.

19-04-09, 09:24 AM	#19 (permalink)
Spook World Class Join Date: Sep 2005	In fairness you'd need to be up to speed with the class par rating system for it to be of any use to anyone anyway

19-04-09, 10:16 AM	#20 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	Welcome Gwynfi, I take it that your from Tom Jones Land ? You have picked a great user name there. If you had choosed Hugebigharyjok, you would had no chance in finding support in receiving this amazing and unique spreadshit. Keep the posts come.

25-04-09, 09:44 PM	#22 (permalink)
rogsmith Claimer Join Date: Mar 2009	Hello mate,im gradually reading my way through the speed rating info you sent and i think its making sense.The spreadsheet looks very good but what i would like to know is how you go about doing the ratings as in ,do you do every flat race,i assume you must have some kind of data base of horses and times etc etc.So really how would you suggest i start,and how do you use the ratings.Cheers mate.