OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Sports and Gambling (http://forums.ozmium.com.au/forumdisplay.php?f=6)
-   -   DIY Greyhound Formguide (http://forums.ozmium.com.au/showthread.php?t=23824)

moeee 12th April 2012 05:04 PM

DIY Greyhound Formguide
 
This is something I stole from good helping Member Kennedy91210.

Its only part of the donation he gave , so I don't believe it will upset him.

What it does is downloads Form and a handy Excel User can build on this Program to manipulate the data as to however they choose.

The 8 Sheets need to be cleared and the correct animals and Box Numbers need to be placed in the DATA Sheet as necessary.
As does the days date.

I have it set so that it downloads the previous 24 months.

To run it , you must Run the Macro.
I figure that if you don't have the knowledge to do that , then this Program is of zero use to you.

moeee 12th April 2012 05:11 PM

1 Attachment(s)
Here is program

Raven 12th April 2012 07:35 PM

Many thanks

Shaun 12th April 2012 07:41 PM

This would be easy to automate, just import the dog fields from uinitab site.

moeee 12th April 2012 08:27 PM

I guess so Shaun.

I choose to do a copy and paste.
Takes me maybe 10 seconds tops to paste the dogs names.

I download an Excel Sheet from the GRV Website that has the Fields for Victorian Meetings.
Then I copy and paste straight across.

moeee 13th April 2012 09:00 AM

Updated Program
 
1 Attachment(s)
As a further helping hand , here is the Program with a little more features that approaches how I do things.

The Click Boxes on the Data Sheet Run the Macros.

Reset Fields - Clears the Dogs Sheets.

Get Form - Fills the Sheets with the required 2 years of Form.

Sort Form - Mostly eliminates Lines where an animal was scratched or where it never gained a run as a Reserve.
It also eliminates all runs further back than the latest 18.

This is how I have it set up in my studies.
There is no right or wrong way.
The Macros are there and easily editted and modified to suit the User.

In the FormGuide , The Times are the actual Times the animal ran , as are the Splits.


All times are GMT +10. The time now is 07:27 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.