19th May 2009, 09:50 AM
|
|
Member
|
|
Join Date: Oct 2005
Posts: 52
|
|
Hi All,
I have attached a spreadsheet for all of you to try out. The system is called Method 260 which was given to me for free from the nice people at racerate.
Instructions:
Open spreadsheet to the Main tab
Press Alt-F8 to bring up the macros window
Select Method260 and press run
Enter the date in YYYY/MM/DD format ie. Today will be 2009/05/19.
Watch the program work.
It will do each race in chronological order and create a new tab for each race. It is not 100% in that after all races are put in it will create a blank tab for each meeting. If someone can fix that, happy days.
The next day if you want to start again, simply delete every tab created leaving the Main, Horse and Table tabs in place. To do this simply select the first tab after the Table tab then while holding shift down click on the last tab. Then right click and select delete. Then save the sheet and start again.
If anyone has got a good system that could be improved by automation, post it up here and I will see if I can make it better.
Cheers.
|