Using Google sheets.

[geroge.burns99]

Originally Posted by Tom

Open Office is Fee.
Two versions, Appache and Libre, both open Excel files.

Thxs Tom....

With all the shit we learned over the years ......

Making our own is just as good...

[wiretowire68]

I guess your not willing to share the algorithm

[wiretowire68]

I do not have the paitence or the understanding to insert it into the sheet or googles version of excel. Any chance of a play by play from step 1 to the end? Be so grateful

[wiretowire68]

Here is the breakdown from tonight's race from Penn National race # 6. It shows basically what it finished and what I do not have as an angle. Is the trainer's roi on a layoff and if I put that in as a handicapping angle and give it a score, which I could, it may have added to the winner's score but would not have made the winner rank in Angles and Form pps. However, upon doing pacelines both by fraction and fps, the winner is........well it called all three.

So some systems work out once in awhile.

Chuck

[wiretowire68]

LOL.. Brohamer states in Modern Pace Handicapping that if Sustained Pace horse in on top and Average Pace is on top, its time to loosen the rubber band on the bankroll. I did not like an idiot in tournament play as I am using this as a testing ground for future bets. But the two showed 1 more point in terms of overall score. However, He does talk about betting two horses to win and I am always inclined to take the longer shot horse and how many times do you see the two favs. get bet down and get end up on the bottom. The seven had bood beyer figures in my system. Anyways. food for thought.

[wiretowire68]

To the peson who figured out how to get Bris files to fit into Google Sheets. Any possible chance of step by step instruction?

[geroge.burns99]

Originally Posted by wiretowire68

To the peson who figured out how to get Bris files to fit into Google Sheets. Any possible chance of step by step instruction?

Easy.....

Right Click on your BRIS FILE

Choose RENAME......

CHANGE EXTENSION from XXXXXX.drf to XXXXXX.CSV

GOOGLE SHEETS

Choose FILE.........IMPORT........UPLOAD

Done!!!

The only work I see is getting Column Headers in there..theres A LOT!!!!

[wiretowire68]

Yes I got that far... It is too daunting to say the least. I got a drf file in there and a Bris file. When you get to the point to seperate the columns. What do you choose semi colon, comman, custom? Then what?

[vegasone]

There is a thing called experimentation. If one way doesn't work then try a different way.....it doesn't cost you anything. Sometimes computer stuff can be frustrating and you have to just try stuff...Google also helps out.....Google "Bris data files" comes in handy when no one is around to help you.

[geroge.burns99]

Originally Posted by vegasone

There is a thing called experimentation. If one way doesn't work then try a different way.....it doesn't cost you anything. Sometimes computer stuff can be frustrating and you have to just try stuff...Google also helps out.....Google "Bris data files" comes in handy when no one is around to help you.

Thxs Vegas...I was just going to comment something like that...

Sheets didn't ask me how to separate this time....maybe it remembered

Usually Excel ask you that stuff

Anyway this is what it looks likes...

If you think this is going to be easy.....

[headhawg]

Originally Posted by wiretowire68

Yes I got that far... It is too daunting to say the least. I got a drf file in there and a Bris file. When you get to the point to seperate the columns. What do you choose semi colon, comman, custom? Then what?

The .csv extension stands for Comma-Separated Values, so choose "comma" as the separator. And I am not trying to insult you but if importing a file is "daunting" then writing macros and algorithms (formulas) will be way over your head. If you think that your handicapping methods are solid, just hire someone to code this stuff for you either as a stand alone app or in Excel. It won't be cheap, but it will get done before you destroy your computer in frustration.

[Tom]

Originally Posted by geroge.burns99

Easy.....

Right Click on your BRIS FILE

Choose RENAME......

CHANGE EXTENSION from XXXXXX.drf to XXXXXX.CSV

GOOGLE SHEETS

Choose FILE.........IMPORT........UPLOAD

Done!!!

The only work I see is getting Column Headers in there..theres A LOT!!!!

That didn't work for me.
I renamed the file xxxxx.drf xxxxx.csv, but it actually saved as xxxxx.csv.drf and wouldn't open. I opened it with Notepad and saved it as .csv and that worked. As far as headings go, make a one time template and then use that for future files.

OO will open by simply right clicking the file and using "open with" but it will only handle 1024 columns. If you don't need those ommitted columns, you're good to go.

[geroge.burns99]

Originally Posted by Tom

That didn't work for me.
I renamed the file xxxxx.drf xxxxx.csv, but it actually saved as xxxxx.csv.drf and wouldn't open. I opened it with Notepad and saved it as .csv and that worked. As far as headings go, make a one time template and then use that for future files.

OO will open by simply right clicking the file and using "open with" but it will only handle 1024 columns. If you don't need those ommitted columns, you're good to go.

thxs Tom

[headhawg]

I use Excel but I was curious as to why Sheets would not be able to load a csv file. So when I made the post about changing the extension from drf to csv I tried it and I imported the file into Sheets successfully. A file can only have one extension but that does not mean you can't have a file named thisfile.doc.txt.csv.drf. The extension is the last 3 or 4 characters after the last dot. At least in Windows; Mac and Linux might be different but probably not.

[vegasone]

Have to extract file BEFORE you change the extension