|
12-21-2012, 07:19 PM
|
#1
|
Registered User
Join Date: Jun 2011
Posts: 588
|
Excel - Bris File Creator
This Excel program I designed is a simple tool that opens .drf or .eg files, converts them to columns and closes the original race file. Designed for bris single data files, there's a feature to select the columns you want to keep and delete the rest. Still a work in progress...
Save as .xlsm after download
Instructions:
1.Find the macro "OpenRaceFile" and edit the line:
ChDir "C:\*****PASTE YOUR FILE PATH HERE*******"
between the quotes enter the file path to your race file folder,
example: "C:\Documents\racefiles"
2.Go to settings sheet and click the button 'open race file'
3.IF you have selected a folder for your file path, click the folder and then click on the race file and click open. (make sure it is not a zipped file)
4.In the settings page check off all the desired columns then click on 'Process Race'
Last edited by JJMartin; 12-21-2012 at 07:25 PM.
|
|
|
12-21-2012, 09:43 PM
|
#2
|
Registered User
Join Date: Jun 2011
Posts: 588
|
any feedback is welcomed
|
|
|
12-22-2012, 11:12 PM
|
#3
|
Registered User
Join Date: Sep 2005
Posts: 1,827
|
Quote:
Originally Posted by JJMartin
any feedback is welcomed
|
Not sure exactly what your trying to do, but the latest Excel will take in all of the drf files. It is not restricted to 255 col. You might want to check out Ray's program.
__________________
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.
|
|
|
12-22-2012, 11:40 PM
|
#4
|
Registered User
Join Date: Jun 2011
Posts: 588
|
Quote:
Originally Posted by BIG49010
Not sure exactly what your trying to do, but the latest Excel will take in all of the drf files. It is not restricted to 255 col. You might want to check out Ray's program.
|
why would you say its restricted to 255 col?
|
|
|
12-23-2012, 03:19 AM
|
#5
|
Registered User
Join Date: Dec 2005
Location: MI
Posts: 6,330
|
Quote:
Originally Posted by JJMartin
why would you say its restricted to 255 col?
|
EXcel prior to 2007 had a 255 column limit.
__________________
"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."
Anatole France
|
|
|
12-23-2012, 10:57 AM
|
#6
|
Registered User
Join Date: Jun 2011
Posts: 588
|
Quote:
Originally Posted by Capper Al
EXcel prior to 2007 had a 255 column limit.
|
I'm aware of that, I've had all the versions of Excel. I thought maybe BIG49010 was having a problem using the file. I use Excel 2010. I should clarify that if you are still using 2003, this won't work.
This is just a simple program that converts delimited race files, all 1435 columns for you instead of having to do it manually with the 'Text Import Wizard'...and then I added the column selection sheet, which would auto select which columns to keep (after the initial manual setup) on every race. Obviously theres no header but the column assignment number which you could use to determine the definition of the column. Now I could work on this file more, add a header and make it into a full blown analysis software but I have one already. I looked at alldata which is a nice program. It seems like a good 'handicapping with traditional information software' (like reading the newspaper racing form), if that's your goal. I use my own program that is tailored to working with and creating custom algorithms for the purpose of detecting profitable patterns mostly (most currently) in the area of speed using various methods of construction. After 8 years and 1000 mutations, the complexity of the algorithms has become quite elaborate.
Last edited by JJMartin; 12-23-2012 at 10:59 AM.
|
|
|
12-24-2012, 10:06 AM
|
#7
|
Registered User
Join Date: Sep 2005
Posts: 1,827
|
Quote:
Originally Posted by JJMartin
why would you say its restricted to 255 col?
|
I played around with your sheet in 2007 Excel, and it seemed to limit on one page to 255. It could be it opened it in 2003 mode.
Nice work though.
__________________
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.
|
|
|
12-24-2012, 11:11 AM
|
#8
|
Registered User
Join Date: Dec 2005
Location: MI
Posts: 6,330
|
Try this:
- Open a blank tab (sheet)
- Click the data tab
- Click Import From Text
- In the box that popped up, Go to your folder/directory
- Choose "All Files" from the drop down in the lower right of the box.
- Click on your file name
- Click Import
- A new box comes -- Make sure delimited is highlighted. If not, click it.
- Click Next
- uncheck tab
- Click Comma
- Click next
- Click Finish
- A new box comes up. It should say =$A$1. This should be the cell where you want to start your data import from. If not, change it by clicking on the cell that you want to start your data from.
- Once your have your chosen starting point for data import, click ok.
That should do it. You get all the races on the card.
__________________
"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."
Anatole France
|
|
|
12-24-2012, 12:42 PM
|
#9
|
Registered User
Join Date: Jun 2011
Posts: 588
|
Quote:
Originally Posted by Capper Al
Try this:
- Open a blank tab (sheet)
- Click the data tab
- Click Import From Text
- In the box that popped up, Go to your folder/directory
- Choose "All Files" from the drop down in the lower right of the box.
- Click on your file name
- Click Import
- A new box comes -- Make sure delimited is highlighted. If not, click it.
- Click Next
- uncheck tab
- Click Comma
- Click next
- Click Finish
- A new box comes up. It should say =$A$1. This should be the cell where you want to start your data import from. If not, change it by clicking on the cell that you want to start your data from.
- Once your have your chosen starting point for data import, click ok.
That should do it. You get all the races on the card.
|
The problem is with the .xls extension.
|
|
|
12-24-2012, 12:52 PM
|
#10
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by JJMartin
I'm aware of that, I've had all the versions of Excel. I thought maybe BIG49010 was having a problem using the file. I use Excel 2010. I should clarify that if you are still using 2003, this won't work.
This is just a simple program that converts delimited race files, all 1435 columns for you instead of having to do it manually with the 'Text Import Wizard'...and then I added the column selection sheet, which would auto select which columns to keep (after the initial manual setup) on every race. Obviously theres no header but the column assignment number which you could use to determine the definition of the column. Now I could work on this file more, add a header and make it into a full blown analysis software but I have one already. I looked at alldata which is a nice program. It seems like a good 'handicapping with traditional information software' (like reading the newspaper racing form), if that's your goal. I use my own program that is tailored to working with and creating custom algorithms for the purpose of detecting profitable patterns mostly (most currently) in the area of speed using various methods of construction. After 8 years and 1000 mutations, the complexity of the algorithms has become quite elaborate.
|
AllData isn't restricted to "traditional information", you just create a new "view" and manipulate any of the raw 1435 field data as you see fit, by referencing either the raw data in the Bris files or any of the data in any of the other "views" already in the workbook, some of which are far from being "traditional", and are already manipulated and /or adjusted.
Getting more than 255 fields of the 1435 fields in the Bris data ,into Excel, was the first thing AllData accomplished, via a text parser utility. Later we got rid of the need to use a parser utility, and now the import is fully automated, within Excel itself. The free AllData workbook, not only imports all of the Bris data, it also imports the Bris Exotic results data. If the user doesn't want to use certain fields in the data files, then he simply doesn't reference that data in the "views" he creates.
I applaud you for your work, and it is fine if you're using 2007 or 2010, but it won't work for the vast majority of Excel users, because they still use previous versions of Excel. AllData works in any version of Excel.
Again, thank you for your offering, it is quite a handy piece of work!!
|
|
|
|
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
|
|
|
|
|