AllData PPs.xls latest version
 

I have uploaded the latest version of my Excel template (containing all 1435 data fields from Bris/TSN single file data files).

The new version contains an auto-paceline selection process, as well as, a manual over-ride for the auto-selected lines.

You can go to my website for the download, on the "AllData" tab. The file name is: "alldata_pps_1.3.zip".

Go to the "AllData Blog" tab to see my comments on the use of the new feature, ie: setting the criteria defaults, setting the criteria category rankings, etc..

I will be uploading a more detailed help file on the "AllData" page later.

If you have not visited my website and want to give the spreadsheet a go, please check the "Infotran" page, as well, and read all the instruction files for both Infotran and AllData PPs.

THANK YOU !!!!

No prob, Doug.

I'm gonna download your program as well, been thinking that there might be a way to interface your program's outputs with AllData.

Also, thinking some about including the process for loading the .xrd results files and macroing the pp data and the results to an Excel db sheet. I've done this before with an earlier spreadsheet I wrote.

bug found in the new version
 

A bug was reported with the latest version of "AllData PPs.xls". I fixed it and republished it. So, Doug and anyone else who has already downloaded the new version already, you will need to redownload it again.

The fixed file is the same name and in the same place on the "Alldata" page.

Sorry about the oversite, I should have caught it before publishing.

Ray

Latest of the latest version
 

After having another report of problems with macros in ver 1.3, I went back, again, and checked/fixed and tested every macro in AllData PPs, ver 1.3.zip. It works fine in Excel 2000 and 2003. I suggest that if you have downloaded ver 1.3 previous to this post that you replace your copy with the one on the "Alldata" page on my site.

The newest version is also named: "alldata_pps_1.3.zip"

PS: I've already begun creating the "Summaries" sheet which will isolate the final selected paceline data, for each of the horses, all in one view. This view will be compressed enough, I hope, that you will be able to print it (in landscape mode) on one page.

Thanks
 

This is great.

I've added another tab to the "AllData" site named: "Modifying AllData PPs".

It contains an exercise suggested by Geoff, one of our users, to add a simple tutorial for adding EPS (earnings per start) to the spreadsheet. I had been thinking of doing a tutorial that would give a brief example of some of the ways to work with Excel and his suggestion was well timed.

So, if you're using Excel (or thinking about it) and you're not an Excel guru, stop by and check it out.

Feel free to comment on anything on the site or in the spreadsheet by clicking the "AllData Blog" tab and posting there.

AllData PPs, version 2.0, is uploaded to the AllData site, on the "AllData" page.

Version 2.0 contains the 1st of at least 2 "Summary" views. This one is a summary for the PPs (Past Performances). It shows all the horses in the race, along with their respective final paceline selection.

I've added a little "conditional formatting" (green cell shading) to some of the columns that highlights the top 3 numbers/figures in each of the affected columns.

I also added a couple of sets of data, to the right of the PPs data, to show one way of working with the raw data to get something else. Just click any of the cells in these areas to see what's going on.

If you are having any problems or have comments about anything on the site or in any of the versions please post here or in the blog on the site.

Thanks!!

AllData PPs Help file is uploaded to the "AllData" page on the site. The file name is: alldata_pps_help.rtf". I think everything is in there, from Infotran to AllData PPs.xls Version 2.0.

Using Infotran With Windows Vista 64
 

Hi Ray,

First let me say that you did a great piece of work which I'm sure is appreciated by many of us, myself included.

I am using Vista 64 as my operating system and have to use DOS BOX to run Infotran.
The program goes through all the iterations but produces a spurious result when opened up in your alldata spreadsheet.
Is there a version of Infotran that would be more compatible with my operating system.

Any help would be appreciated.

No, there is only 1 version of Infotran. If you can run a DOS program on your computer, no matter what utility you have to use to enable the running of DOS, the resulting text file should be exactly like ours.

I would think that, if you're getting "spurious" results when opening the text file in AllData PPs, then something else is causing the problem, not Infotran.

Maybe someone else on the forum knows about 64 bit machines and running DOS on them.

If so, please chime in!!

raybo: Ray, you were absolutely right. After re-reading your instructions, I got it to work. It's a beautiful piece of work and I appreciate your willingness to share.

No problem and THANKS!!!

AllData PPs Version 2.1 is uploaded to the AllData site.

V2.1 adds the "Summary RRs" view to the spreadsheet. It's done the same way as the "Summary PPs" except you get the Race Ratings (Sartin figures) data instead of the DRF style past performance data.

The "Summary RRs" are directly below the "Summary PPs" so you can see them both in the same view.

I also updated the help file to include V2.1.

Ray, You have really done a fantastic job with your updated version,anyone using Sartin figures should really check it out.

I hope Raybo doesnt mind but here is a screenshot of his spreadsheet,he really did a fantastic job with it and you can use it with the Bris files.I had to do it with 2 different shots.

NICE
 

All I can say is thanks. This is very nice. Anyone out there that is not excell savvy "like me". I went through the help file, and was up and running in no time. Thank you Raybo.....Great job..Chris

No problem.

Looks like you need to widen a couple of columns on your spreadsheet. The cells that show "#####" are too narrow to show the values.

Here's a screenshot showing both summaries:

Raybo,Thanks for the suggestion,by our two screenshots it isnt hard to tell who is better equipped to do so.

While working with AllData PPs last night I found a couple of bugs in the Summaries.

I had to tear down both summaries and fix the bugs then reassemble them.

I have updated the "alldata_pps_2.1.zip" download on my site with the fixes.

As a result, those users who downloaded the zip file prior to Jan 23rd @ 1:15PM, must go back to the site and redownload it and replace what you've got on your computer, with the new one.

Sorry for the inconvenience, but, I don't have beta testers for AllData PPs so I have to depend on the users letting me know when there are things happening that shouldn't be.

Thanks!

Raybo,How do I go about making those columns wider?Thanks

Go up to the column headers (column letters), for the column you want to widen, click on the right border of the column header, hold the mouse button down and slide slightly to the right. That widens the column. To narrow the column, slide to the left.

Thanks very much

You can, of course, change the height of the rows, also, using the same process, but, on the row headers.

.. after reading the posts in this thread .. I can be seen stumbling along and mumbling to myself. I will go quietly and call my friend Alex to help with the decoding process. :lol:

This is a really old thread, from back in the day when we had to use a data parser in order to import the data files into Excel. Things are much simpler now that all this is done within Excel, simply by clicking some buttons.

If you're interested in using Excel as a handicapping platform, feel free to ask specific questions here or PM me. If you're not really too familiar with Excel, things can seem overwhelming, when it's really not that difficult. It's like anything else, you have to start at the beginning and break things down into understandable steps, building your understanding, and skills set, as you proceed from step to step.

Excel can be very complex, but it doesn't have to be, and compared to what one has to go through to learn a programming language, it's like kindergarten compared to high school.

I do ms excel handicapping! I would like to Join but i can't because of the securty coad at the bottom of page I can't make it out
can anybody help
tom

Tom,

I've sent you an email.