General Fantasy Sports

View the Forum Registry


Self-edit this thread


0 Subject: week 1173 table of results

Posted by: StLCards
- Sustainer [417433018] Sun, Oct 07, 10:39

I think I have this right. gurupies1173

Sheet1

Name H.ID. Race # Age Tr Typ Dis S Sp PL FD PP Purse Odds Earn. Owner Clm St
Jericho Velvet 39269 1173.6112 O-3+ FN Str 8 T 94.3 1 14 13 7600 4.3 4560 madman4 5000 40
Burglar Wanting 36916 1173.4911 O-3+ E5 C2L 6.5 T 67.4 7 13 4 11100 14.1 0 madman999 20000 15
Admirable Launch 30398 1173.4611 O-3+ NF Clm 5.5 D 79.2 5 6 5 13300 4.6 266 madman4 13500 23
Skin Jumping 35877 1173.4515 O-3+ ME Str 7 D 92.5 3 14 5 50000 6 4000 madman4 2500 72
Private Count 11166 1173.4108 F-3+ MX A3x 10 D 85.4 4 12 11 7000 3.7 350 madman4   100
Light Jupiter 2866 1173.1402 O-3+ NM Str 6 D 100.6 1 14 4 4100 2.1 2460 madman999 5000 26
Chocolate Dump 36272 1173.1207 O-4+ PA 450 6 T 88.8 4 14 2 11100 12.8 555 madman999   49
Name H.ID. Race # Age Tr Typ Dis S Sp PL FD PP Purse Odds Earn. Owner Clm St
Mama Junior(jpn) 6372 1173.7312 F-3 RI MS 6.5 T 72.1 7 14 2 23700 27 0 devil01   70
Financial Sky(ire) 17219 1173.5901 O-3+ IR A2n 10 D 59 13 13 8 24300 40 0 devil01   82
St. George 41904 1173.4205 O-3 WI Str 10 D 58 6 6 1 4900 22.4 0 jkaye 10000 16
Malt Toto 6439 1173.4111 O-3+ MX A1x 8.5 D 62.2 6 8 1 5400 9.5 0 devil01   100
El Guitar 12917 1173.3203 O-3+ AL MC 8 T 59.2 5 14 14 3500 10.9 70 sunday89 4000 70
Ransom Cecil 23176 1173.3202 O-4+ AL Alw 9 D 72.5 12 13 1 26000 74.1 0 devil01   45
Blantantly Spank 32011 1173.2514 O-3+ OR MS 6 D 80.4 8 20 7 50000 11.7 0 sunday89   49
Blonde Broad 22252 1173.2213 O-3+ DE A-T 6.5 T 70.5 6 7 3 22400 11.7 0 jkaye1   50
Prospector's Turn 16983 1173.201 F-2 IN A1x 6 D 46.3 14 14 8 24600 44.8 0 jkaye   0
Together Print 5450 1173.1801 O-3+ KS C3s 6.5 D 74.3 6 12 8 4100 7.8 0 sunday89 4000 31
Slain At Clontarf 25338 1173.1702 O-2 VA MS 6.5 T 46.7 10 14 1 15200 13 0 sunday89   74
Alot At The Bait 6119 1173.1504 O-3+ AZ Str 10 D 87.3 3 8 8 10100 3.3 808 sunday89 10000 51
Sal With Fleet 24915 1173.1306 O-3+ WV Clm 6 D 64.4 11 14 12 2900 4.9 0 devil01 2500 62
Out With Colony 51313 1173.1104 O-3+ OH A1x 8 D 75.5 12 14 8 10000 10.3 0 sunday89   73
Broke Night 13912 1173.0114 F-2 CA G2 8 D 66.2 13 14 14 200000 34 0 sunday89   63
Name H.ID. Race # Age Tr Typ Dis S Sp PL FD PP Purse Odds Earn. Owner Clm St
Sweltering Order 40401 1173.6414 F-3+ PT 200 7 D 89 4 10 10 11100 31.9 555 pepe31   31
Yankee Alphabet 20221 1173.6213 O-3+ FR 300 10 D 90.5 1 9 2 30400 5.8 18240 cab   29
Fourth Bingo 30051 1173.6204 O-3+ FR Str 12 D 79 3 7 5 15200 5.6 1216 pepe31 25000 71
Mr. Fresh(gb) 51186 1173.5902 O-3 IR MC 8 D 66.8 6 14 4 7600 25 0 pepe31 15000 52
Prince Beau 9097 1173.4211 O-3+ WI 45 8 D 73.4 4 8 7 4300 7.9 215 cab   55
Cherokee Judge 10363 1173.421 F-2 WI MS 7.5 T 52.4 11 14 9 10400 46.8 0 cab   32
Jinx Darnning 37946 1173.4011 O-4+ NC C2L 8 D 76.5 3 8 6 5300 7.9 424 cab31 10000 56
Rule In The Burns 20043 1173.3209 F-3 AL MC 13 D 36.7 7 14 4 3500 5.6 0 pepe31 4000 61
Mars Can 47713 1173.2714 O-3+ UT Stk 5.5 T 69.7 4 4 4 75000 26.3 3750 cab   45
Sparky Brush 30704 1173.1914 O-3+ IA MS 7 D 73.4 10 14 6 10900 9.4 0 cab31   25
Clam Carnival(ire) 55791 1173.1607 O-3 WA Str 8 D 95.2 3 10 10 8700 2.9 696 cab 10000 88
Explosive Miner 42396 1173.0211 O-3 FL 650 7.5 D 93.9 3 14 6 25500 9.5 2040 cab31   60
Name H.ID. Race # Age Tr Typ Dis S Sp PL FD PP Purse Odds Earn. Owner Clm St
Retired Dan 26365 1173.7604 O-2 CN MS 8 D 49.1 12 14 3 27500 22.5 0 stlcards1   49
Purple Park 65676 1173.7407 O-3+ TN MS 8 T 63.9 5 14 11 13100 3.8 262 stlcards2   100
Rich Wine 8094 1173.7404 F-3+ TN MS 6.5 D 98 1 14 5 13100 14.2 7860 stlcards1   75
Out Within Form 36286 1173.421 F-2 WI MS 7.5 T 45.9 12 14 8 10400 26.9 0 stlcards3   44
Brass Ones 14986 1173.4101 O-3 MX Str 6 D 70.1 8 10 1 3900 9.8 0 stlcards 15000 35
Long Foot 36905 1173.3804 O-3+ NH MS 13 D 29.1 12 14 8 23300 25.3 0 stlcards3   84
Erica Bark 7602 1173.3708 F-3 VT 1M 8 T 71.4 6 8 6 30400 4.6 0 stlcards   92
Neatly Impregnate 1835 1173.231 F-3+ NB MS 6 D 60.7 14 14 4 12800 29.2 0 stlcards   80
Stolen Boundary 38062 1173.2014 O-3+ IN 290 7 D 71.2 14 14 3 16300 10.6 0 stlcards   13
Sally Plow 19104 1173.2001 F-3+ IN A1x 9 D 86.1 4 12 8 24600 22.8 1230 stlcards3   84
Dusty Colony 51349 1173.0608 O-3 AK MS 8 D 80 4 14 4 31800 2.9 1590 stlcards1   66
1cab
      Donor
      ID: 783144
      Sun, Oct 07, 21:53
Neat table STL....Thanks!...I seem to have trouble getting the results on the SSS for everyone(don't seem to be able to get specific weeks for some reason)so it's good to catch up on the results...

I put a stable into the NWRC this week....So most of the Cab runners will be racing in that area for a while...except for Yankee ,who i shipped to Europe...I plan on giving him a few turf tries just to see what he can do, although the longer he goes on dirt(so far) the better he has looked...It is far easier finding turf races over there...
2StLCards
      Sustainer
      ID: 417433018
      Mon, Oct 08, 00:30
Looks like you had some well placed horses this week Cab. The only positives I had this week was Rich Wine a claimer I picked up a few weeks ago. A 98SP for a filly should win a few races. Puts her up there with my other claimer Hero Grub who has been my best horse so far. I accidently ran Erica Bark, 3yo filly, back to back, so the 71 turf is probably not reflective of what she can do. This was the first turf test so I'll have to try again. My other bright spot was Sally Plow who ran a nice 86SP on dirt. First try on dirt so I'm pleased so far. Hopefully she will get faster as I hone in on the right distance.

Looks like Madman is trying to become king of the starter allowance.
3Madman
      ID: 68361122
      Mon, Oct 08, 01:51
Nice table :)

Cab -- you have to make sure that the weeks are numbered correctly in the raceout.zip's that you download. I bet that's the main deal. I get all my raceouts from the main site or Supertoy's site.

StL -- yep, king of the starter allowance. But these races are drying up since people are carding CPU value races instead. Oh well. I haven't been doing the claim thing forever because of personal time issues, so my tags will be running out unless I can continue to acquire these low-tag horses.

BTW, Light Jupiter becomes my 3rd horse to break 100. I see that Toral is really kicking arse in that category :).
4cab
      Donor
      ID: 783144
      Thu, Oct 11, 12:37
I'm not really sure what has gone wrong Madman...I used to be able to do it and then i started downloading the racing zips as soon as they were available and changing the race number of the first race..(I get impatient and have to see the sp's as soon asi can!)...To be honest though, this computer can't handle too much searching....Not enough memory i think...I do a couple of searches(even just listing various races) and then an error comes up and i have to re-boot the computer...
5Madman
      ID: 68361122
      Thu, Oct 11, 14:13
Hmmm. That is weird. The database file is large now. On my machine, the import is taking longer and longer. The real kicker is that I compact the database after each import. This means copying the entire file temporarily. This means your hard drive goes into overdrive.

Once I get things settled, I may try to figure out ways to get around this.

FYI, I just bought 256K of RAM for $35 after shipping. www.crucial.com. SWEEEEET.

Of course, the rest of my machine is still in pieces. Sigh.
6StLCards
      Sustainer
      ID: 340491814
      Thu, Oct 11, 14:29
I noticed the import taking longer as well. I figured that it was just more races being run each week. I'll have to check my update specs on ram. Only 32M right now. Let's see, $35 for 256K, that is $140 per Meg, so an extra 32M would only be, $4,480. hmm, I better hope I win that $500K purse Sat.
7Madman
      ID: 68361122
      Thu, Oct 11, 16:07
Oooops. I meant 256 MB for $35. One DIMM. I'm up to the odd 392 :).

Actually, the problem isn't the number of races. Well, that's a factor, but it's a small factor.

The issue is the explosion in the sim. I don't have the numbers right off hand, but basically one month of data is equivalent to the first entire YEAR of the sim. To make the searches run as fast as they do, the Access database is "indexed". This is cool ONCE THE DATABASE is going. But it sucks, since each and every single horse that runs each week has to be matched and placed within this index whenever you import new data.

Obviously, even if the size of the new import doesn't increase, the time it takes to do this matching will definitely increase.

Numerical example:

How hard is it to match 5 new observations with 10 observations you already have?

How hard is it to match those same 5 new observations with 1,000,000 you already have?

Get the picture?

I don't know how long the SSS will remain functional without another database revision. I initially projected that it would remain functional for a year. With the revised keys, I thought I might be able to get it up to 2-3 years. But the import will continue to take longer and longer and longer . . .

The bad news is that I don't know how to speed things up, so I'm not even sure what a new revision would entail. :( The database is really huge, with almost a million records already, and it is growing extremely fast.
8StLCards
      Sustainer
      ID: 2504849
      Thu, Oct 11, 16:15
I may just start deleting some of the older weeks if I run into a problem. I only loaded to upper 800's IIRC and really focus more on the late 900's and up. I think data on the last 10 races for a horse is more than enough for my purposes of selecting races etc. May even help as old data may skew relevant current numbers. I don't effectively use the week filter right now.
General Fantasy Sports

View the Forum Registry


Self-edit this thread




Post a reply to this message: (But first, how about checking out this sponsor?)

Name:
Email:
Message:
Click here to create and insert a link
Ignore line feeds? no (typical)   yes (for HTML table input)


Viewing statistics for this thread
Period# Views# Users
Last hour11
Last 24 hours11
Last 7 days11
Last 30 days33
Since Mar 1, 2007563340