Sidebar

[raybo]

Originally Posted by Dan H

QSP rules can be found at:

http://www.free-horseracing-info.com/universalbias.html (Calibration Handicapping site)

The ITS Data Structure can be found at:

http://www.itsdata.com/tech_info/ptd...df_format.html (Post Time Solutions site)

I can write IF, SUM, and other basic formulae. No Visual Basic.

Here's the formula I created to identify a Z-Pattern in a running line:

=IF(AND(AK11>=AL11,AL11<=AM11,AM11>AN11),"ZPAT","" )

Thanks for the responses so far.

Dan H

I'll see what I can do this evening.

Are the different files in separate locations in Excel? Are the fields already in separate cells in Excel or are they still in comma-delimited format? (I'm assuming, at this point, that you simply "opened" the files in Excel 2007 without using a parsing program to select and order the comma-delimited data)

It might help if you send me a sample file so I can open it in Excel 2007 and then go from there.