I have xp and excel 2000, downloaded the program with the txt file for s7 and it works well. However, when I downloaded the txt files from Nicks site for 6/49 and keno it did not load properly. Everytime I tried to load both files a message appears "Error 13 (type mismatch) in procedure File_LoadDataBase of module mDataBase"!. Does anyone have any suggestions how to correct this problem. Any help will be greatly appreciated. Thanks.
LottoSelectorXL v102
- Thread starter brascan1
- Start date
Beaker
Member
This error occurs with large data files - like 649 and keno.brascan1 said:
Nick is looking into this - he can comment further.
The fix is to ignore the error - until Nick has a fix - and manually enter the params in row 2
So, for example 6/49
2115 in A2
649 in B2
49 in C2
and spin 7 into D2.
Everthing should be fine after that.
Re: Re: LottoSelectorXL v102
Sorry Beaker I am new using excel spreadsheets. Therefore, what I understand is, do I load the 6/49 txt file first and then ignore the error message. After, I go into the sheet and make changes. Please, let me know thanks.
Beaker said:This error occurs with large data files - like 649 and keno.
Nick is looking into this - he can comment further.
The fix is to ignore the error - until Nick has a fix - and manually enter the params in row 2
So, for example 6/49
2115 in A2
649 in B2
49 in C2
and spin 7 into D2.
Everthing should be fine after that.
Sorry Beaker I am new using excel spreadsheets. Therefore, what I understand is, do I load the 6/49 txt file first and then ignore the error message. After, I go into the sheet and make changes. Please, let me know thanks.
Nick Koutras
Member
Re: Re: LottoSelectorXL v102
I thought that I did fix this error.
I'll give it another try to identify why xl2000 indicates Type Mismatch
The large file does not matter, it is the
mismatch that causes the error.
Beaker said:This error occurs with large data files - like 649 and keno.
Nick is looking into this - he can comment further.
The fix is to ignore the error - until Nick has a fix - and manually enter the params in row 2
So, for example 6/49
2115 in A2
649 in B2
49 in C2
and spin 7 into D2.
Everthing should be fine after that.
I thought that I did fix this error.
I'll give it another try to identify why xl2000 indicates Type Mismatch
The large file does not matter, it is the
mismatch that causes the error.
Brad
Member
Using Excel 2002
This format works nicely:
2924,30/04/2004,2,3,6,7,14,15,23,28,29,30,35,42,51,52,53,54,57,65,69,70
2925,01/04/2004,8,11,13,15,18,19,21,28,31,34,35,40,42,47,48,50,60,62,67,70
2926,02/04/2004,3,6,9,11,12,23,31,34,35,36,38,46,48,49,54,56,61,62,64,68
The above is from ON Keno. I was also able to input a BC Keno file of about 25,000 draws (a years worth) without a problem, it had the same format except the date includes time also.
660834,5/2/2004 0:45,2,6,9,13,14,18,20,26,35,37,39,47,53,55,57,61,68,69,70,71
660835,5/2/2004 0:50,4,7,11,13,19,24,26,30,31,34,36,40,42,44,55,57,63,66,73,78
The prog recognizes the draw ID # rather than date I think.
This format works nicely:
2924,30/04/2004,2,3,6,7,14,15,23,28,29,30,35,42,51,52,53,54,57,65,69,70
2925,01/04/2004,8,11,13,15,18,19,21,28,31,34,35,40,42,47,48,50,60,62,67,70
2926,02/04/2004,3,6,9,11,12,23,31,34,35,36,38,46,48,49,54,56,61,62,64,68
The above is from ON Keno. I was also able to input a BC Keno file of about 25,000 draws (a years worth) without a problem, it had the same format except the date includes time also.
660834,5/2/2004 0:45,2,6,9,13,14,18,20,26,35,37,39,47,53,55,57,61,68,69,70,71
660835,5/2/2004 0:50,4,7,11,13,19,24,26,30,31,34,36,40,42,44,55,57,63,66,73,78
The prog recognizes the draw ID # rather than date I think.
Nick Koutras
Member
Re: Re: Re: Re: LottoSelectorXL v102
Download version 104.
I hope that I have fixed the problem loading any database
brascan1 said:
Download version 104.
I hope that I have fixed the problem loading any database
About data
Hi, Nick,
I download your On_Keno.txt file, Thanks.
Actually I have data after 01/01/2001 myself, so I ran a check, and found maybe you have some mistypo in your file.
2001-11-20 2 4 8 11 19 21 24 25 37 42 49 52 56 62 63 64 66 67 68 70
2002-2-4 2 3 5 9 13 14 15 22 27 32 36 40 41 46 49 51 56 66 68 69
2002-2-18 1 6 9 11 14 19 21 27 32 36 38 39 42 43 45 46 51 58 66 69
2002-3-6 2 3 4 11 21 22 26 30 44 45 47 51 54 55 60 62 63 64 66 70
2002-3-9 7 10 18 19 24 25 26 33 37 40 41 43 46 48 50 60 65 67 68 70
2002-3-23 1 3 4 5 6 7 13 19 20 22 27 33 36 43 45 50 52 56 65 67
2002-4-12 1 6 7 13 16 21 24 27 29 34 37 39 41 42 48 50 53 64 65 67
2002-4-22 1 2 10 11 12 14 15 18 22 23 29 35 37 49 59 60 61 66 69 70
2002-5-26 2 16 17 18 31 38 39 40 43 48 50 52 54 55 59 62 64 66 67 70
2002-5-30 1 14 23 25 26 27 29 32 33 43 46 47 48 51 52 56 59 64 68 69
2002-6-14 2 17 18 20 21 24 25 27 32 36 37 38 45 46 49 55 58 61 62 67
2002-7-14 5 20 23 24 26 35 36 40 41 42 45 46 47 52 53 60 62 65 66 70
2002-7-27 2 15 16 18 20 21 31 33 34 36 49 50 51 52 54 56 58 61 62 70
2002-8-8 1 15 18 22 25 28 30 31 32 36 40 41 45 50 52 55 61 63 67 70
2002-8-15 1 7 8 15 18 24 29 30 37 43 45 46 48 50 53 54 58 59 63 66
2002-10-14 6 21 26 31 33 34 35 37 39 44 45 46 48 49 50 54 55 56 58 64
2003-2-25 6 18 20 23 24 29 30 31 32 36 39 40 43 48 55 64 65 66 68 70
I checked it with sypatico's lottery result. I know sometimes it may be wrong also. I don't know what your source is. Would you please take a look?
thanks.
Hi, Nick,
I download your On_Keno.txt file, Thanks.
Actually I have data after 01/01/2001 myself, so I ran a check, and found maybe you have some mistypo in your file.
2001-11-20 2 4 8 11 19 21 24 25 37 42 49 52 56 62 63 64 66 67 68 70
2002-2-4 2 3 5 9 13 14 15 22 27 32 36 40 41 46 49 51 56 66 68 69
2002-2-18 1 6 9 11 14 19 21 27 32 36 38 39 42 43 45 46 51 58 66 69
2002-3-6 2 3 4 11 21 22 26 30 44 45 47 51 54 55 60 62 63 64 66 70
2002-3-9 7 10 18 19 24 25 26 33 37 40 41 43 46 48 50 60 65 67 68 70
2002-3-23 1 3 4 5 6 7 13 19 20 22 27 33 36 43 45 50 52 56 65 67
2002-4-12 1 6 7 13 16 21 24 27 29 34 37 39 41 42 48 50 53 64 65 67
2002-4-22 1 2 10 11 12 14 15 18 22 23 29 35 37 49 59 60 61 66 69 70
2002-5-26 2 16 17 18 31 38 39 40 43 48 50 52 54 55 59 62 64 66 67 70
2002-5-30 1 14 23 25 26 27 29 32 33 43 46 47 48 51 52 56 59 64 68 69
2002-6-14 2 17 18 20 21 24 25 27 32 36 37 38 45 46 49 55 58 61 62 67
2002-7-14 5 20 23 24 26 35 36 40 41 42 45 46 47 52 53 60 62 65 66 70
2002-7-27 2 15 16 18 20 21 31 33 34 36 49 50 51 52 54 56 58 61 62 70
2002-8-8 1 15 18 22 25 28 30 31 32 36 40 41 45 50 52 55 61 63 67 70
2002-8-15 1 7 8 15 18 24 29 30 37 43 45 46 48 50 53 54 58 59 63 66
2002-10-14 6 21 26 31 33 34 35 37 39 44 45 46 48 49 50 54 55 56 58 64
2003-2-25 6 18 20 23 24 29 30 31 32 36 39 40 43 48 55 64 65 66 68 70
I checked it with sypatico's lottery result. I know sometimes it may be wrong also. I don't know what your source is. Would you please take a look?
thanks.