| Strategic Designs Ltd., forums http://startersorders.com/phpBB2/ |
|
| Trainer logs http://startersorders.com/phpBB2/viewtopic.php?f=16&t=8306 |
Page 1 of 2 |
| Author: | leonvr [ Tue Jul 02, 2013 9:10 pm ] |
| Post subject: | Trainer logs |
These can be viewed in TOM. flat http://startersordersonline.com/tom11/flatLogs.php nh http://startersordersonline.com/tom11/NHLogs.php Tom still has a basic look. Will sort the look out once I have fixed all the code and functionality 81 wins for Andy is an incredible feat. I though there was a bug in my sql query for a while  Although Matt almost beat Andy for the championship title
|
|
| Author: | akhc [ Tue Jul 02, 2013 10:29 pm ] |
| Post subject: | Re: Trainer logs |
Leon I think your stakes won are wrong somewhere. There's no way I've won 134 million (134727650). Somewhere around 18.5 million is right by my rough calculations. Also your win percentage is wrong. By my reckoning I've won 81/138 races entered which is 58.7%. I think the database on TOM is corrupted. Certainly the race records for quite a few of my horses are wrong. Tatosi is 5-5-0 not 6-6-0 Aganju 8-5-0 instead of 9-5-0. Domnu 6-5-0 instead of 7-6-0. Also the prizemoney isn't accurate for a lot of my horses either. I've given up trying to work out exactly what I've won from TOM. I think the move in week 5 really messed up a lot of the records. |
|
| Author: | ghostzapper74 [ Tue Jul 02, 2013 10:50 pm ] |
| Post subject: | Re: Trainer logs |
It's say's I won 8.8 mill, I will take that all day long,  Sadly it's wrong 
|
|
| Author: | leonvr [ Wed Jul 03, 2013 6:28 am ] |
| Post subject: | Re: Trainer logs |
the stakes are correct now. The multiple joins are the issue. The database is mostly correct. There are 2 missing races as the horse text files where corrupt. Although I did manually enter the results for the first 5 places Tom and the horse files are not linked so having a corrupt horse file will not affect the database. However it is difficult to extract information from the database because of the way it has been set up. I get 58.7 % for your win percentage but combining the data in one sql query is causing the results to be incorrect. As soon as I figure out a way to do it I will update Tom |
|
| Author: | pjrhodes1970 [ Wed Jul 03, 2013 6:33 am ] |
| Post subject: | Re: Trainer logs |
68 winners in the lge is beyond my wildest dreams well done to the champs looks good Leon nice work with tom |
|
| Author: | Anadin [ Wed Jul 03, 2013 8:42 am ] |
| Post subject: | Re: Trainer logs |
Great Stuff Leon.... and finishing in the top 10 on wins (flat) is more than I thought, so pleased. Can we get rid of the profile page being first up when logging into to TOM and go straight to homepage? |
|
| Author: | leonvr [ Wed Jul 03, 2013 8:46 am ] |
| Post subject: | Re: Trainer logs |
Quote: Can we get rid of the profile page being first up when logging into to TOM and go straight to homepage? Yes will do. Will sort this out when I redo the look and layout. Going to do the top horses next and then horse form |
|
| Author: | akhc [ Wed Jul 03, 2013 10:24 am ] |
| Post subject: | Re: Trainer logs |
Hi Leon I'm not sure the money list is correct still. I've simply copied and pasted the table from TOM into excel and done a sum of winnings for each horse (as shown below - deleted some columns to make it easy to see)  I've chosen 6 trainers at random (started with number 50 on the list and simply taken every 5th trainer up from there) Here are the figures from TOM as obtained from the stable screen. I'm included your table figures in brackets Amyg879 303300 (303300) Deltanion 148100 (148100) Fredperry21 102750 (103850) PST193 59600 (59600) Tomo1727 7000 (7000) Flashdean 500 (500) As you can see.. pretty accurate. The one difference been Fredperry21 and this is easily explained by uploading a new horse in the week 5 break so the stable figure will underestimate this slightly. Here are the figures for the top 6 trainers keithbeaky 19030910 (19540260) akhc 18863400 (19154750) Nashwan 7671600 (7777350) Jalupen 4411210 (4411210) Pjrhodes1970 4200010 (4351610) Leonvr 3708500 (3850800) Here's where I'm questioning the accuracy. Looking at these 6 trainers, it's clear Jalupen hasn't transferred in or out in the week 5 window. The others appear to have done so hence the difference in figures. However I'm querying which horses keith and myself shipped in and out as there's large differences for both of us. I know which horses I switched out and working of the schedule and spreadsheet dated March 6th the total won for those horses is 279350. The difference between the two figures above is 291350 so a minor discrepency. The other query is which horses Matt shipped out as the difference between the two figures is 509350 and I'm querying what he shipped out to have such a large difference. The other issue is the number of winners/places in your wins table matches up with my records completely. However the money won per horse in TOM's table for my horses as I've stated previously is wrong for quite a few and in fact the figures for money won don't match up at all for me and in fact my calculations don't agree with the numbers above either. I'm double checking my figures again but I suspect there are still some errors in either the purses entered into TOM or somewhere else. |
|
| Author: | leonvr [ Wed Jul 03, 2013 10:37 am ] |
| Post subject: | Re: Trainer logs |
There were some corrupt horse text files which could not be uploaded correctly. The data for the few races that this occurred in would explain the reason for the variances. Unfortunately there is no way at this stage of the season to fix these errors. The race text files are just that a string in text format and are almost impossible to correct. The only other solution is to go through the database and manually correct the race results where the data has been uploaded incorrectly. I have the data for horse starts by trainer and win percentage. The data is below. I need to do some nested sql table queries and create virtual tables to display it together with stakes earned( will work on it tonight) Again there will be a variance to races run due to the corrupted horse text files from which all data entered into Tom comes trainer / starts / win percentage 17days 141 3.55 akhc 138 58.70 Alan Brentwood 12 8.33 AmyG879 67 4.48 Anadin 140 10.00 bolton123 3 0.00 cahiller 85 2.35 Cairnsey90 185 1.08 cdean 84 2.38 David1uk 73 9.59 davylad 182 4.40 Deltanion 87 3.45 dochay 119 13.45 DodgyDave 2 0.00 Doyley 17 0.00 Doza 47 2.13 durkinliam 11 9.09 Evire12 5 0.00 Flashdean 9 0.00 follis86 86 1.16 fredperry21 98 0.00 ghostzapper36 89 1.12 giddy 146 0.68 gmoore23 30 3.33 Greaver 144 4.86 jalupen 151 11.92 jbeattie02 52 0.00 JHarrison 125 3.20 jupiterjimmy 74 1.35 keenanbrown 176 3.41 keithbeaky 134 20.90 Kevcon 162 2.47 leonvr 184 9.78 lewiscrewe 181 5.52 masterm 64 4.69 Mikey1892 155 3.87 mjtags11 5 0.00 Nashwan 173 13.87 NeedGlue 84 3.57 pjrhodes1970 172 15.70 Pommard 131 3.82 pst193 26 7.69 redeyez 20 0.00 samdarby 81 8.64 Shaka 42 2.38 Simple Minds 158 6.96 SiriusChill 151 3.31 SuperCat 71 11.27 The Dude 39 0.00 tomo1727 46 0.00 tomrogers20 6 0.00 ubar02 53 3.77 Uncle_Tom 2 0.00 Wannabe 106 8.49 White Diamond Racing 1 0.00 |
|
| Author: | akhc [ Wed Jul 03, 2013 10:53 am ] |
| Post subject: | Re: Trainer logs |
 Here are two examples for my horses that show discrepencies with TOM figures TOM has Tatosi winning 1,839,000 and Taran winning 3,649,000 as opposed to what I calculate above. |
|
| Author: | akhc [ Wed Jul 03, 2013 10:56 am ] |
| Post subject: | Re: Trainer logs |
Heh sorry Leon.. Just wanting accuracy here. I'll accept that to have an accurate figure for money it might need a manual count and I suspect I will do it as my rough calculations so far (not doublechecked) show a difference of less than 30k between Matt and me. But this is also useful for the future so that we're sure of the accuracy of all data in TOM. |
|
| Author: | leonvr [ Wed Jul 03, 2013 11:08 am ] |
| Post subject: | Re: Trainer logs |
Its actually really good for me to find where the errors are. If you can let me know the race that would be even better. I will add a column in the race results display table indicating the prize money that was won for a race in Tom tonight. If you want you can the let me know where the error is http://startersordersonline.com/tom11/view-results.php Note I'm trying to fix the bug causing NH to flick back to the flat schedule so the NH results are not displaying at all at present Ideally I would like to work offline but word press keeps hijacking my localhost. I need to change the wordpress config files but as the league is not running at present I haven't bothered to do this yet |
|
| Author: | akhc [ Wed Jul 03, 2013 11:23 am ] |
| Post subject: | Re: Trainer logs |
leonvr wrote: Its actually really good for me to find where the errors are. If you can let me know the race that would be even better. I will add a column in the race results display table indicating the prize money that was won for a race in Tom tonight. If you want you can the let me know where the error is http://startersordersonline.com/tom11/view-results.php Note I'm trying to fix the bug causing NH to flick back to the flat schedule so the NH results are not displaying at all at present Ideally I would like to work offline but word press keeps hijacking my localhost. I need to change the wordpress config files but as the league is not running at present I haven't bothered to do this yet Sure I don't mind.. it's an academic exercise but I think one that needs done so we know going forwards that things are accurate but I'm mindful you're the one who needs to do the work and I wouldn't want to irritate you if you had other things to do first. At your leisure then and I'll look at it and see if the bugs can't be ironed out. |
|
| Author: | leonvr [ Sat Jul 06, 2013 10:40 am ] |
| Post subject: | Re: Trainer logs |
The results page is now up to date with the earnings for a race next to the horse so it can be checked for errors. With regards the win percentages this can't be done(or I haven't figured out how yet) with the database in its current format. These figures will however be available in a dialog box that will pop up when you click on a trainer which will reveal other stats about the trainer as well. It will take a while to do so won't be ready for a week or so Will get the top horses tables up and running first as this is quite simple. How do people want the horses divided up. For example 3 year old milers , older milers, sprinters , stayers etc.. Tables will be done on prize money gained in the distance specified. I can do an overall table for top horses as well |
|
| Author: | keithbeaky [ Sat Jul 06, 2013 7:35 pm ] |
| Post subject: | Re: Trainer logs |
Lets just say I won and leave it at that. |
|
| Page 1 of 2 | All times are UTC [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|