Toil
18th March 2012, 11:17 AM
I have been running this program for about a week now checking it out but yesterday it decided to stop working :S
But when i run it for the next day it works but it has a problem when you run it for the next day in that the 3LSV 2LSV LSV columns are blank or only show figures for 1 or 2 runners and this has always been the case, its no good running it for the next day as those 3 columns are vital to the ratings.
I have Provided an attachment of the original Method_260 Auto excel program
When i run it for today's date it immediately comes up with Run-time error '9': Subscript out of range.
And shows this:
Races 01 02 03 04 05 06 07 08 09 10 11 12
QR SUNSHINE COAST (QR) Fields 12:30 13:05 13:40 14:15 14:50 15:26 16:05 16:44
NR NOWRA (NR) Fields Abnd Abnd Abnd Abnd Abnd Abnd Abnd
VR CRANBOURNE (VR) Fields 54m 12:35 13:10 13:45 14:20 14:58 15:38 16:14
AR PT LINCOLN (AR) Fields 59m 12:40 13:15 13:50 14:25 15:04 15:42 16:18
CR TAREE (CR) Fields 12:20 12:55 13:30 14:05 14:40 15:16 15:54
PR MT BARKER (PR) Fields 14:54 15:34 16:10 16:48 17:25 18:05 18:45 19:25
ER WANGARATTA (ER) Fields 12:15 12:50 13:25 14:00 14:35 15:12 15:50 16:26
ZR HORSHAM (ZR) Fields 40m 12:22 13:00 13:31 14:08 14:42 15:19
SS KRANJI (SS) Fields 14:50 15:20 15:50 16:20 16:50 17:20 17:50 18:20 18:55 19:25 20:00 8:30
OS SHA TIN (OS) Fields 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:35 19:15 19:50
ZS ASCOT PARK (ZS) Fields 7,3,1 6,9,10 6,1,7 11m 47m 12:30 13:07 13:44
Trots 1 2 3 4 5 6 7 8 9 10 11 12
ORANGE (NT) Fields 12:44 1:21 1:58 2:34 3:14 3:44 4:12 4:45
BOORT (VT) Fields 12:24 12:59 1:34 2:09 2:44 3:20 3:58 4:38
MOTUKARARA (OT) Fields 18,5,9 7,11,8 16,10,4 13,6,9 0m 37m 12:16 12:53 1:30 2:07 2:42
MANAWATU (ZT) Fields 8,5,10 6,2,8 8,7,3 Interim 24m 12:07 12:44 1:21 1:58
LAUNCESTON (TT) Fields 4:51 5:20 5:47 6:12 6:35 7:00 7:20 7:42 8:05 8:25
Greyhounds 1 2 3 4 5 6 7 8 9 10 11 12
ALBION PARK (BG) Fields 5:06 F4 5:29 F4 5:44 F4 6:02 F4 6:22 F4 6:41 F4 6:57 F4 7:16 F4 7:39 F4 7:57 F4
SANDOWN PARK (MG) Fields 1:04 1:28 1:49 2:12 2:32 2:54 3:11 3:29 3:49 4:07 4:25
NOWRA (NG) Fields 5:01 5:16 5:39 5:57 6:17 6:32 6:53 7:11 7:34 7:53
SALE (VG) Fields 4:56 5:11 5:34 5:53 6:09 6:27 6:49 7:06 7:29 7:48
GAWLER (AG) Fields 4:43 F4 5:04 F4 5:27 F4 5:46 F4 6:08 F4 6:26 F4 6:48 F4 7:08 F4 7:31 F4 7:47 F4
CANBERRA (CG) Fields 4:37 4:55 5:14 5:36 5:55 6:16 6:40 6:59 7:19 7:38 7:55
HEALESVILLE (EG) Fields 12:27 12:49 1:13 1:35 1:56 2:19 2:39 3:04 3:24 3:41 3:57 4:17
CAMBRIDGE (ZG) Fields 32m 54m 12:23 12:39 1:00 1:16 1:37 1:53 2:14 2:29 2:48 3:07
MT GAMBIER (DG) Fields 29m F4 44m F4 12:13 F4 12:36 F4 12:57 F4 1:19 F4 1:41 F4 2:03 F4 2:24 F4 2:47 F4
But when i run it for the next day it works but it has a problem when you run it for the next day in that the 3LSV 2LSV LSV columns are blank or only show figures for 1 or 2 runners and this has always been the case, its no good running it for the next day as those 3 columns are vital to the ratings.
I have Provided an attachment of the original Method_260 Auto excel program
When i run it for today's date it immediately comes up with Run-time error '9': Subscript out of range.
And shows this:
Races 01 02 03 04 05 06 07 08 09 10 11 12
QR SUNSHINE COAST (QR) Fields 12:30 13:05 13:40 14:15 14:50 15:26 16:05 16:44
NR NOWRA (NR) Fields Abnd Abnd Abnd Abnd Abnd Abnd Abnd
VR CRANBOURNE (VR) Fields 54m 12:35 13:10 13:45 14:20 14:58 15:38 16:14
AR PT LINCOLN (AR) Fields 59m 12:40 13:15 13:50 14:25 15:04 15:42 16:18
CR TAREE (CR) Fields 12:20 12:55 13:30 14:05 14:40 15:16 15:54
PR MT BARKER (PR) Fields 14:54 15:34 16:10 16:48 17:25 18:05 18:45 19:25
ER WANGARATTA (ER) Fields 12:15 12:50 13:25 14:00 14:35 15:12 15:50 16:26
ZR HORSHAM (ZR) Fields 40m 12:22 13:00 13:31 14:08 14:42 15:19
SS KRANJI (SS) Fields 14:50 15:20 15:50 16:20 16:50 17:20 17:50 18:20 18:55 19:25 20:00 8:30
OS SHA TIN (OS) Fields 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:35 19:15 19:50
ZS ASCOT PARK (ZS) Fields 7,3,1 6,9,10 6,1,7 11m 47m 12:30 13:07 13:44
Trots 1 2 3 4 5 6 7 8 9 10 11 12
ORANGE (NT) Fields 12:44 1:21 1:58 2:34 3:14 3:44 4:12 4:45
BOORT (VT) Fields 12:24 12:59 1:34 2:09 2:44 3:20 3:58 4:38
MOTUKARARA (OT) Fields 18,5,9 7,11,8 16,10,4 13,6,9 0m 37m 12:16 12:53 1:30 2:07 2:42
MANAWATU (ZT) Fields 8,5,10 6,2,8 8,7,3 Interim 24m 12:07 12:44 1:21 1:58
LAUNCESTON (TT) Fields 4:51 5:20 5:47 6:12 6:35 7:00 7:20 7:42 8:05 8:25
Greyhounds 1 2 3 4 5 6 7 8 9 10 11 12
ALBION PARK (BG) Fields 5:06 F4 5:29 F4 5:44 F4 6:02 F4 6:22 F4 6:41 F4 6:57 F4 7:16 F4 7:39 F4 7:57 F4
SANDOWN PARK (MG) Fields 1:04 1:28 1:49 2:12 2:32 2:54 3:11 3:29 3:49 4:07 4:25
NOWRA (NG) Fields 5:01 5:16 5:39 5:57 6:17 6:32 6:53 7:11 7:34 7:53
SALE (VG) Fields 4:56 5:11 5:34 5:53 6:09 6:27 6:49 7:06 7:29 7:48
GAWLER (AG) Fields 4:43 F4 5:04 F4 5:27 F4 5:46 F4 6:08 F4 6:26 F4 6:48 F4 7:08 F4 7:31 F4 7:47 F4
CANBERRA (CG) Fields 4:37 4:55 5:14 5:36 5:55 6:16 6:40 6:59 7:19 7:38 7:55
HEALESVILLE (EG) Fields 12:27 12:49 1:13 1:35 1:56 2:19 2:39 3:04 3:24 3:41 3:57 4:17
CAMBRIDGE (ZG) Fields 32m 54m 12:23 12:39 1:00 1:16 1:37 1:53 2:14 2:29 2:48 3:07
MT GAMBIER (DG) Fields 29m F4 44m F4 12:13 F4 12:36 F4 12:57 F4 1:19 F4 1:41 F4 2:03 F4 2:24 F4 2:47 F4