#1
|
|||
|
|||
![]() Hello all
I last posted about a year ago and at the time I had been testing an Excel based system that I used to calculate my own ratings for Sat meetings in Brisbane. At the time it was showing decent enough profit over approx 200 races and I'm pleased to say that one year on and its still looking OK - nothing earth shattering but enough to keep me interested. With the help of a few forum members I managed to get a few macros written to simplify and speed up my data capture and analysis. Essentially now I cut and paste form information from two websites and then run a couple of macros to convert my data into usable data and then to analyse the data and produce ratings. Again, nothing special here although I do apply my own weightings to different elements of form and also am able to manipulate the ratings to account for the state of the ground etc at each meeting and can also adjust barrier numbers etc when scratchings are announced. So its a bit labour intensive up front but works OK overall. I'm really keen to test the ratings out on more meetings, esp in other States but I'm time poor and simply don't have the time to cut and paste data from websites and run the macros then adjust for going, scratchings etc. I was wondering whether anyone has had similar issues and has managed to get a programmer to produce some software for them that replicates the (relatively simple) way in which Excel can calculate ratings and that fully automates processes that are otherwise performed in Excel via macros etc. I suppose the key issue I'm struggling with is getting the form data into Excel - perhaps there's a database that forum members use/can recommend that, with a bit of wizardry from a programmer, can be used as source data for a small programme that produces ratings automatically? Suspect I'm up against it here! Anyway, hope this makes sense and would appreciate any help or advice. Thanks in advance Sparky12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|