1 | Madman
ID: 21020124 Mon, Jan 14, 2002, 04:54
|
Now, a copy of an email I just sent to an inquiring mind, with more detailed technical info. about the raceout.zip format. _______________________________ Well, since Mr. Coker is calling it quits, I think I am somewhat absolved of my responsibility to my promise to keep from spreading these raceout.zip tips. As per your email request on the message board: Raceout.zip code illustration: Raceout 1271, first horse listed in race 0101: KRISTEENE S., 16714 , 106.742592223185 , 0.276742901833907 ,-1.11308858036995 ,-1.09338490724564 ,-0.190719803571701 , 0.127802343070507 , 0.104566984623671 , 0.123006733059883 , 0.254576377094401 ,-40 , 1291 ,erik
Horse Name, Horse ID, Speed (coded), start%, raceview adjustment1, raceview adjustment2, raceview adjustment3, raceview adjustment4, raceview adjustment 5, raceview adjustment6, odds (coded), post position (coded), owner ID, ownername
Horses are listed by finish place, by race *999999 ends the report. Either 1.0 or 2.0 should start the report. 1.0 refers to very early raceout versions, IIRC. Code Summary: 1) Speed factor: sp! is the original field value in VB Code: sp! = Format(sp! + Left(hid!, 1) - Right(hid!, 1), "##.0") In other words, take the first digit of the horse's ID, subtract the last digit of the horse's id, and add that to the 3rd field in the raceout.zip 2) odds: in VB Code: odds! is the original field value rshorse!odds = Fix((0.82 - odds!) / odds! * 10) / 10 If rshorse!odds < 0.1 Then rshorse!odds = 0.1 In other words, take (.82-odds)*10 and divide by the odds. Drop any remainder off that, and divide by 10. If the resulting amount is less than .1, then set it equal to .1. Otherwise, this is the amount of the odds column. 3) Post Position: In VB Code: hid! = horse ID ppostemp! = original value in post position from raceout If Mid(hid!, 1, 1) = 9 Then ppos% = 49 + ppostemp! Else ppos% = 49 + Mid(hid!, 1, 1) + ppostemp! End If In other words: if the horse ID starts with "9", then simply add 49 to the value in this field. Otherwise, take 49, add the first digit of the horse ID and add THAT to the value of the field. There you go. Now you know basically what I know. Good luck. Please don't advertise these too widely, but feel free to use your judgement in helping others out. If you figure out the raceview fields, let me know. I don't even know for sure that they are fields that affect the way the race is run / viewed. But I have some good evidence to that effect, and Mr. Coker thought my hypotheses on that score were reasonable, although not provable.
-- Madman
|