|
|
01-11-2009, 01:23 PM
|
#1
|
Registered User
Join Date: Dec 2004
Location: San Diego
Posts: 232
|
Wanted: Microsoft Excel Formula - Quirin Speed Points
Looking for formula(e) to help me automate the calculations of Running Styles and Quirin Speed Points.
Assumptions:
1. Formulae for paper and pencil methods are in the public domain.
2. Data is already imported into Excel from ITS – (no BRIS CSV available).
3. Microsoft Excel 2007 – beginner to intermediate skill level.
No luck with PA search for this info,
Thanks, Dan H
|
|
|
01-11-2009, 06:42 PM
|
#2
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by Dan H
Looking for formula(e) to help me automate the calculations of Running Styles and Quirin Speed Points.
Assumptions:
1. Formulae for paper and pencil methods are in the public domain.
2. Data is already imported into Excel from ITS – (no BRIS CSV available).
3. Microsoft Excel 2007 – beginner to intermediate skill level.
No luck with PA search for this info,
Thanks, Dan H
|
Do you have the paper and pencil methods?
Do you have the ITS data structure?
How familiar are you with Excel and writing formulas?
I don't use Quirin speed points but if you know how you want them calculated/manipulated there are many here who can write the formulas/macros for you.
To calculate running styles you need to decide how you want to do that before you ask for Excel formulas.
|
|
|
01-11-2009, 07:05 PM
|
#3
|
Registered User
Join Date: Jan 2008
Location: Cincinnati,Ohio
Posts: 5,289
|
I don't think it's something that you really want automated.
There are enough things to be noticed looking through a horses running lines that would get glossed over by an objective selection method.Sometimes a single running line clues you into a horse's capabilities.Or looking through 5-10 lines you get to know the running style personality of a horse when you were simply trying to place him at the 1st call.
Just my 2 cents.I have always adhered to Davidowitz's advice to scan the lines bottom to top,top to bottom and be able to absorb that history at a glance.Most times it's all you need to know.
|
|
|
01-11-2009, 08:43 PM
|
#4
|
Registered User
Join Date: Sep 2005
Posts: 1,827
|
If someone can come up with formula, it would be interesting to check it against the Bris Files which put the data in.
__________________
Every time you are tempted to react in the same old way, ask if you want to be a prisoner of the past or a pioneer of the future.
|
|
|
01-11-2009, 09:51 PM
|
#5
|
Registered User
Join Date: Dec 2004
Location: San Diego
Posts: 232
|
Quote:
Originally Posted by raybo
Do you have the paper and pencil methods?
Do you have the ITS data structure?
How familiar are you with Excel and writing formulas?
.
|
QSP rules can be found at:
http://www.free-horseracing-info.com/universalbias.html (Calibration Handicapping site)
The ITS Data Structure can be found at:
http://www.itsdata.com/tech_info/ptd...df_format.html (Post Time Solutions site)
I can write IF, SUM, and other basic formulae. No Visual Basic.
Here's the formula I created to identify a Z-Pattern in a running line:
=IF(AND(AK11>=AL11,AL11<=AM11,AM11>AN11),"ZPAT","" )
Thanks for the responses so far.
Dan H
|
|
|
01-12-2009, 01:24 AM
|
#6
|
Registered User
Join Date: Apr 2008
Posts: 6,843
|
Quote:
Originally Posted by CincyHorseplayer
Just my 2 cents.I have always adhered to Davidowitz's advice to scan the lines bottom to top,top to bottom and be able to absorb that history at a glance.Most times it's all you need to know.
|
That would be me......There are many additive and bonus things that have signifcant value, but Bottom/Topping each line is the heart and soul of it for me...... Superior Pace numbers combined with Good Form tells the relevant story.......Making mountains out of mole hills is a great waster of time, in my opinion....Sure you can get those extra few wins, but overall, at what cost ?..Simplicity works best for me, as well.....
best,
__________________
.
"Cursed be the man who puts his trust in man" - Jer 17:5 (KJV)
|
|
|
01-12-2009, 02:08 AM
|
#7
|
Registered User
Join Date: Jan 2008
Location: Cincinnati,Ohio
Posts: 5,289
|
Quote:
Originally Posted by LottaKash
That would be me......There are many additive and bonus things that have signifcant value, but Bottom/Topping each line is the heart and soul of it for me...... Superior Pace numbers combined with Good Form tells the relevant story.......Making mountains out of mole hills is a great waster of time, in my opinion....Sure you can get those extra few wins, but overall, at what cost ?..Simplicity works best for me, as well.....
best,
|
Maybe we think alike because we have the same birthday?
I noticed your name above mine on Jan 9
Must say your approach is eerily similar to how I approach the game too.
|
|
|
01-12-2009, 02:15 AM
|
#8
|
Registered User
Join Date: Apr 2008
Posts: 6,843
|
Quote:
Originally Posted by CincyHorseplayer
Maybe we think alike because we have the same birthday?
I noticed your name above mine on Jan 9
Must say your approach is eerily similar to how I approach the game too.
|
It must be a Capricorn thing........You know dem goats.....Mark Martin also shares that great day as well.....
But, getting back to the original thing, I believe that when you stay focused and are adept at deciphering the running lines and the companion pace's of those races, well then, most everthing else is less, and yet there are those who accomplish the same results but with a mountain of work and scads of numbers to get the same........yeesh, I am too old for the all that drudgery.....
best,
__________________
.
"Cursed be the man who puts his trust in man" - Jer 17:5 (KJV)
|
|
|
01-12-2009, 07:00 AM
|
#9
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by Dan H
|
I'll see what I can do this evening.
Are the different files in separate locations in Excel? Are the fields already in separate cells in Excel or are they still in comma-delimited format? ( I'm assuming, at this point, that you simply "opened" the files in Excel 2007 without using a parsing program to select and order the comma-delimited data)
It might help if you send me a sample file so I can open it in Excel 2007 and then go from there.
|
|
|
01-14-2009, 07:12 AM
|
#10
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
I started working out the Quirin speed numbers using a Bris data file and it is quite complicated, but I'll figure it out before long.
You'll have to modify it to work with your ITS data files, but that shouldn't be a problem for you. At first I had thought of putting it all in one huge formula, since you have Excel 2007 and that version allows such a huge formula, but doing it that way was way too complicated so I decided to use several columns to separate some of the "IF" statements to allow a more efficient way of getting all the variables taken care of.
|
|
|
01-14-2009, 12:37 PM
|
#11
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
|
Okay... I have been playing with this.
I have the sprints thus far.
Please note that this is just the calculation AFTER you have what you need from the pacelines loaded into a 10-race grid.
http://www.horsestreet.com/BBSImages/QuirinEsPts.xlsx
|
|
|
01-14-2009, 12:39 PM
|
#12
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
|
Oops... penalty needs work.
|
|
|
01-14-2009, 12:46 PM
|
#13
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
|
Okay. I think I have it now. Sprints look good. Give it a test.
|
|
|
01-14-2009, 07:34 PM
|
#14
|
Registered User
Join Date: Dec 2004
Location: San Diego
Posts: 232
|
Dave,
Thanks for the help, the link you offer saves to my computer as a zip file that extracts to xml folders and files. If that's by design, then you're miles ahead of me on this.
Dan H
|
|
|
01-14-2009, 11:36 PM
|
#15
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,872
|
Dan,
Alll I did was save the file. (Excel 2007) I did not zip it.
Were you able to open it? If not, let me know and I will save it in an older version of Excel.
Dave
PS: Let me just put it up as a 2003 file:
http://www.horsestreet.com/BBSImages/QuirinEsPts.xls
I fthis doesn't work for you, I WILL zip it and put it up again.
Last edited by Dave Schwartz; 01-14-2009 at 11:39 PM.
|
|
|
|
|
Thread Tools |
|
Rate This Thread |
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|