Using Google sheets.

[vegasone]

My bad...Just me seeing things not there

[Tom]

No problem, sometimes I hear things that aren't there.

[geroge.burns99]

Originally Posted by Tom

No problem, sometimes I hear things that aren't there.

SOMETIMES????

[wiretowire68]

Just curious, if it would be less of a daunting task to build a template from scratch and then try to insert bris or drf pp into the spread sheet. Also, found a website called aspose which takes pdf files and converts for free, was very handy.

[Tom]

Originally Posted by wiretowire68

Just curious, if it would be less of a daunting task to build a template from scratch and then try to insert bris or drf pp into the spread sheet. Also, found a website called aspose which takes pdf files and converts for free, was very handy.

Yes, very easy. I open my pp file alongside my spreadshhet file and enter the data. Very quick.

[wiretowire68]

I started building the main part of the template for a Bris file and a Drf file. I was curious, when the people who made the Bris fit, did you decide to adjust the cells first and then insert or the other way. How on this earth did Raybo build the formulas into all that......unbelievable. The factors I have would take forever in terms of angles. I was wondering if anyone on here has ever used Dave Scwartz Horse Street and what pp data does he use. I know you have to buy your data from the website that offers JCapper/Ken Massa. It is the same with Pizzolla who designed his own version of pps. Thoughts.

Chuck

[Light]

Wire

Many handicappers including myself use Excel vba programing to create customized input into an Excel spreadsheet. First learn how to bring data from a Bris data file into an Excel spreadsheet, then you can manipulate the data with macros and formulas.

I never did like any of the available programs there are for horse racing because they did not address areas I thought were significant.That's what forced me to learn how to build my own program which I feel is better than any I've seen.

[wiretowire68]

Yes,, I use sheets.. so....very similar. I just wanted to know if you built the template first etc. I could never do that amount of work. I am using my google spreadsheets and have develop some nice numbers. My idea is simple, be able to build your own to each race, but to have software read the data but give you the option of picking the data. Similar to Dave Schwartz only, I do not think you need 4000 thousand factors when it comes to handicapping. I think the pioneers were right in what they keep adding. Today, I do not think much is missing in terms of speed ratings/time ratings etc. However, experience dicates the factors in terms of conditions and class and fit cycles. So, I was looking for help in terms of step by step instructions on how to make a pp fit into cells. Everyone says it is trial and error. I get it,it is just frustrating.

[Light]

I've never looked into google sheets,but it is very simple to import a Bris file in Excel. So for example I just dl the Parx $1 single format data file from Bris.

After dl it, you have to turn it into a Drf file. I do this by opening the file with the Bris pp generator. Then open an Excel workbook and import the drf file into a sheet in the wkbk. In Excel there is an import file "wizard" that guides your import based in the type of file you are importing which in this case is a comma delimited file.

Don't know if "Google sheets" has that kind of sophistication.

[geroge.burns99]

Originally Posted by wiretowire68

Yes,, I use sheets.. so....very similar. I just wanted to know if you built the template first etc. I could never do that amount of work. I am using my google spreadsheets and have develop some nice numbers. My idea is simple, be able to build your own to each race, but to have software read the data but give you the option of picking the data. Similar to Dave Schwartz only, I do not think you need 4000 thousand factors when it comes to handicapping. I think the pioneers were right in what they keep adding. Today, I do not think much is missing in terms of speed ratings/time ratings etc. However, experience dicates the factors in terms of conditions and class and fit cycles. So, I was looking for help in terms of step by step instructions on how to make a pp fit into cells. Everyone says it is trial and error. I get it,it is just frustrating.

Why are you so hung up on getting PP's to fit?

Half of that info is going to be useless.....

Forget about getting data into excel for now....

You first step is to develop what YOU want your "main" sheet to look like

From there you then fill in the cells...not that difficult...

List what factors are needed and then input into the main sheet...


Mike

[ranchwest]

I import Multicaps (BRIS single file) into a dBase/Clipper/Harbour file using Harbour. I haven't tried importing the Harbour file into Open Office, but if anyone might find it useful, I could try. Theoretically, it should yield the column headings and formatting.

I use Harbour to create HTML files. Very cool as far as the versatility in formatting the data with colors, fonts, tables, etc.

[headhawg]

The OP has been told how to import a Bris single file (.drf) into Google Sheets. More than once. I don't think that is the issue. (Well maybe it still is, I am not sure.) From my POV it appears that he wants to build a PP "template". I am assuming that this template filters out the data from file that is not needed, and places it into a formatted worksheet. I also think there is this giant middle step between the importing and the outputting where all the calculations are done. (These are his "factors" if I am to understand Chuck correctly.)

I am not sure this is feasible for him given his skill level. You guys can continue to help, but unless someone will write the template for him, I don't think the project will see the light of day. Peace out.

[geroge.burns99]

Originally Posted by headhawg

The OP has been told how to import a Bris single file (.drf) into Google Sheets. More than once. I don't think that is the issue. (Well maybe it still is, I am not sure.) From my POV it appears that he wants to build a PP "template". I am assuming that this template filters out the data from file that is not needed, and places it into a formatted worksheet. I also think there is this giant middle step between the importing and the outputting where all the calculations are done. (These are his "factors" if I am to understand Chuck correctly.)

I am not sure this is feasible for him given his skill level. You guys can continue to help, but unless someone will write the template for him, I don't think the project will see the light of day. Peace out.

Thxs HH....that was going to be my next post and last....

[ranchwest]

Originally Posted by headhawg

The OP has been told how to import a Bris single file (.drf) into Google Sheets. More than once. I don't think that is the issue. (Well maybe it still is, I am not sure.) From my POV it appears that he wants to build a PP "template". I am assuming that this template filters out the data from file that is not needed, and places it into a formatted worksheet. I also think there is this giant middle step between the importing and the outputting where all the calculations are done. (These are his "factors" if I am to understand Chuck correctly.)

I am not sure this is feasible for him given his skill level. You guys can continue to help, but unless someone will write the template for him, I don't think the project will see the light of day. Peace out.

My point is that I think I can offer the column headings, which do not come in with the file. In fact, some of my column headings are not even documented.

[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.