|
|
01-10-2022, 09:17 PM
|
#91
|
crusty old guy
Join Date: Aug 2003
Location: Snarkytown USA
Posts: 3,918
|
Quote:
Originally Posted by Light
A template? Piece of cake. After importing the data into say sheet1, sheet2 can extract any particular data into it from sheet1 and be a template. Sheet3 can be a different template extracting specific data from sheet1 and so on.
|
You talk a good game. If it's a piece of cake go ahead and create it for Chuck. He seems like a decent guy.
__________________
"Don't believe everything that you read on the Internet." -- Abraham Lincoln
|
|
|
01-10-2022, 10:02 PM
|
#92
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Quote:
Originally Posted by Light
A template? Piece of cake. After importing the data into say sheet1, sheet2 can extract any particular data into it from sheet1 and be a template. Sheet3 can be a different template extracting specific data from sheet1 and so on.
|
Yeah, if you know what the elements are.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
01-10-2022, 10:45 PM
|
#93
|
Veteran
Join Date: Dec 2003
Posts: 7,139
|
Look at the file structure that Bris gives you. For example if using the single file comma delimited file format, it tells you that the horses names are in column 45 and the horses speed rating is in 846-855 for their last 10 starts.
So if I wanted to make a template with all the horses names in column A and their last 10 SR's in columns B and beyond its a piece of cake.
After importing the data file into sheet 1, record a macro in sheet 2. To do this you don't even need to know how to write code. Turn the macro recorder on and copy and paste from sheet 1 to sheet 2. All your movements of data is recorded into a macro and is now available any time you want for any race card. Run the macro, and bang, your template data is there in a second.
You can expand on that by adding fields such as dates,track,jocks, trouble,etc. Just look up what columns these factors are in let the macro recorder record your movements. Simple.
The macro recorder has its limitations such as doing loops but you can find code for whatever you want to do on forums or just googling it.
Last edited by Light; 01-10-2022 at 10:46 PM.
|
|
|
01-10-2022, 10:55 PM
|
#94
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Quote:
Originally Posted by Light
Look at the file structure that Bris gives you. For example if using the single file comma delimited file format, it tells you that the horses names are in column 45 and the horses speed rating is in 846-855 for their last 10 starts.
So if I wanted to make a template with all the horses names in column A and their last 10 SR's in columns B and beyond its a piece of cake.
After importing the data file into sheet 1, record a macro in sheet 2. To do this you don't even need to know how to write code. Turn the macro recorder on and copy and paste from sheet 1 to sheet 2. All your movements of data is recorded into a macro and is now available any time you want for any race card. Run the macro, and bang, your template data is there in a second.
You can expand on that by adding fields such as dates,track,jocks, trouble,etc. Just look up what columns these factors are in let the macro recorder record your movements. Simple.
The macro recorder has its limitations such as doing loops but you can find code for whatever you want to do on forums or just googling it.
|
Which column is the company line?
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
01-10-2022, 11:42 PM
|
#95
|
Veteran
Join Date: Dec 2003
Posts: 7,139
|
Quote:
Originally Posted by ranchwest
Which column is the company line?
|
In the $1 single file format:
406- 415 Winner's Name
416- 425 2nd Place finishers Name
426- 435 3rd Place finishers Name
|
|
|
01-11-2022, 12:03 AM
|
#96
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Quote:
Originally Posted by Light
In the $1 single file format:
406- 415 Winner's Name
416- 425 2nd Place finishers Name
426- 435 3rd Place finishers Name
|
But which column tells the next out winners? And the horses in today' race?
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
01-11-2022, 12:14 AM
|
#97
|
DJ M.Walk
Join Date: Aug 2002
Location: Compton, CA!
Posts: 2,072
|
Quote:
Originally Posted by ranchwest
But which column tells the next out winners? And the horses in today' race?
|
The file format is right here!
|
|
|
01-11-2022, 02:40 AM
|
#98
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Quote:
Originally Posted by Speed Figure
The file format is right here!
|
So maybe you can answer my question. What column contains the next out winner data and what are the codes?
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
Last edited by ranchwest; 01-11-2022 at 02:43 AM.
|
|
|
01-11-2022, 02:49 AM
|
#99
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Or what is at column 1378-1382?
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
01-11-2022, 08:59 AM
|
#100
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Quote:
Originally Posted by ranchwest
Or what is at column 1378-1382?
|
I opened Aqu1205 and those fields 1375 - 1382 are blank.
I think what you want is here...
__________________
Who does the Racing Form Detective like in this one?
|
|
|
01-11-2022, 09:22 AM
|
#101
|
Veteran
Join Date: May 2021
Location: NYC
Posts: 1,554
|
Quote:
Originally Posted by Speed Figure
The file format is right here!
|
Thxs for this....
One thing, no updates since 2009....I thought Horses Weight was added within a year or 2 ago..
Last edited by geroge.burns99; 01-11-2022 at 09:29 AM.
|
|
|
01-11-2022, 10:39 AM
|
#102
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Quote:
Originally Posted by ranchwest
So maybe you can answer my question. What column contains the next out winner data and what are the codes?
|
Oh, you are looking for the bolded and italcised names?
I don't see that anywhere.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
01-11-2022, 12:08 PM
|
#103
|
Registered User
Join Date: Jan 2020
Posts: 313
|
Hey whoever said I was a decent guy, lol I would tend to agree with you. However, I do not think my ex-wife or any other women I left along the loop would not. Kidding, I am so grateful and do appreciate the input from everyone. Part of people helping one another and helping people learn in my honest opinion is the most important thing we can teach other as people as oppose to the many problems and issues that face the world as we go forward (Movie Speech) I think if we took this approach to all parts of the individual problems that mankind faces then perhaps instead of all this uncertainty/political turmoil and unrest that faces us then perhaps we would reverse the gears and set forth a new road to which you build consensus and try to make people's lives better and not worse. We are bombarded with negativity now when it comes news period, home, local, province/state/country. Every one is so hell bent on one upping one another and then take a picture of it, roll the camera on it. The world is meant to be words followed by actions in order to produce results that satisfy the needs of the many not just the few. The voyeuristic society we have created is in danger of causing us to self-destruct. Just an opinion.
So thanks to the Light for explaining that and thanks to I believe it was Headhawg for spitting out. Yes, I am trying to take the basic factors of what has all been passed on to us since the invention of the Daily Racing Form(The Old Testament of Horse Racing-I think we would mostly agree to this.) The advent of the PIRCO group and the pioneers who have advanced the figures through machine learning and mathematics to people who have become obsessed with the game of horse racing (I being one of those) I am trying to make my own as stated using the available tools given to me. The developers of the DRF/Equibase/Bris and the creators of software such as Mike Pizzolla (Whom I think is a genius, as well as the others who have gained notieriety and have taught us) I am trying to take what I have learned from them .
So yes, taking the necessary factors from PP's and putting them into a format that extracts. It is a start anyways and thanks to Light for explaining. It is just not about Excel or The Sheets and handicappig but I am also trying to to learn how the program works as I go.
Chuck
|
|
|
01-11-2022, 01:11 PM
|
#104
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Quote:
Originally Posted by Tom
Oh, you are looking for the bolded and italcised names?
I don't see that anywhere.
|
I knew the answer. It was a quiz. The bolded and italicized data is at 1192-1201, but you have to decode the data.
My point is that there are columns designated as Reserved that are actually in use. Some of the data can be viewed in the PP pdf files. Apparently I am the only one who cares. Some of the content I have not figured out. Some of the columns seem to always be blank, so those are truly reserved.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
01-11-2022, 01:15 PM
|
#105
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
And apparently counting the columns and comparing them to the document is easier than having the columns labeled.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
|
|
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
|
|
|
|
|