Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board


View Single Post
Old 12-21-2012, 07:19 PM   #1
JJMartin
Registered User
 
JJMartin's Avatar
 
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'
Attached Files
File Type: xls BSD_FILE_CREATOR.V1.xls (329.0 KB, 251 views)

Last edited by JJMartin; 12-21-2012 at 07:25 PM.
JJMartin is offline   Reply With Quote Reply
 
» Advertisement
» Current Polls
Wh deserves to be the favorite? (last 4 figures)
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 01:54 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.