|
#1
|
|||
|
|||
![]() 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. |
#2
|
|||
|
|||
![]() Here is program
Last edited by moeee : 12th April 2012 at 05:13 PM. |
#3
|
|||
|
|||
![]() Many thanks
|
#4
|
|||
|
|||
![]() This would be easy to automate, just import the dog fields from uinitab site.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
#5
|
|||
|
|||
![]() 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. |
#6
|
|||
|
|||
![]() 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. |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|