Hits against combo in Excel

Reply #16

budward — Sat, 14 Jul 2007 22:47:53 GMT

Thanks time*treat.

Bud

Reply #15

time*treat — Sat, 14 Jul 2007 22:40:06 GMT

Someone asked about making this a little more flexible, so I made a few changes to show the simpler way. I'd say print out both versions so you can compare side-by-side. I made the test draw numbers different. It's just easier to see which variable is doing what, that way. I bolded the changes. Now you only change the numbers at the top. As you can see, the more tricks you want it to do, the more code you're going to wind up with.

~~~

Sub Swed35c7__B()

'by time*treat'

'compar... [ More ]

Reply #14

CyberBam — Sat, 14 Jul 2007 19:58:08 GMT

Thanks alllot TimeTrea... you gave me a really good start :-)

I did the same above by adding a CountA-function on the sheet and then reffering the end value to the value of this cell.

Thanks again TimeTreat, you did a wonderfull job, you will get your share of the Jackpot if there will be any

Reply #13

time*treat — Sat, 14 Jul 2007 14:07:18 GMT

@Budward

Glad you like the code .

To answer your question, yes.

Way #1: If you create new variables called (for example) last__test__row, or last__draw__row, your new code might say For test__row = 3 to last__test__row. Then what you would do is to set the value of the last__test__row (as a constant) like you did with the pool__size

This is best, if you are just playing around with the concept.

Way #2: This is a little bit more complex to code, and is best for if you have... [ More ]

Reply #12

budward — Sat, 14 Jul 2007 12:29:07 GMT

THANKS time*treat.

I took your code and adapted it to my 5/39 game. It's great!!

now for my question..

where it has these two lines

For test__row = 3 To 9

For draw__row = 3 To 9

Is it possible to make this a non static number so I don't have to change the code every time my number of test draws draw numbers change

Sometimes I might have 5 test rows draw rows and sometime I might have 75.

Bud

Reply #11

time*treat — Fri, 13 Jul 2007 08:28:47 GMT

with 1 worksheet called drawset and one called testset (in the same workbook), draw data starting at row 3 col 2 (leaving space for a date), and test data starting at row 3 col 1, to row 9 for each...the screen may wrap some of these longer lines, I like to indent. Make sure they are 1 line before you run it.

Sub Swed35c7()

'by time*treat'

'compares test set of 35C7 numbers against'

'known 35C7 drawing and tallies subset counts'

'for the test__set matching the draw__set... [ More ]

Reply #10

CyberBam — Fri, 13 Jul 2007 01:42:29 GMT

Thanks m8... :-D

Draw set:

05 12 15 16 22 23 32

01 04 13 14 17 27 29

01 14 18 19 20 21 30

02 08 13 17 21 27 29

04 05 13 16 17 19 34

03 03 04 11 24 27 35

09 11 17 27 28 30 32

Test set

03 04 11 14 17 20 22

01 16 22 23 27 30 32

07 10 11 15 25 27 34

02 03 15 17 21 31 33

11 15 18 23 28 30 34

01 04 07 16 28 32 35

06 08 10 11 19 22 33

All numbers in Draw set are in there own cells B through H, as column A contains the draw date.

All numb... [ More ]

Reply #9

time*treat — Fri, 13 Jul 2007 01:07:21 GMT

Post 10 or so lines of the draw set and the test set.

Maybe we can give you a push in the right direction.

Reply #8

CyberBam — Fri, 13 Jul 2007 00:30:41 GMT

Yes... I'm halfway through, It is not an easy task though :Puhh:

I agree with Gasmeterguy

Reply #7

budward — Thu, 12 Jul 2007 23:04:27 GMT

There are lots of good programmers at the Lottery Post and there are lots of lottery related questions about programming and Excel. I know that I for one would be checking it constantly trying to learn new things.

JMHO...Bud

Reply #6

GASMETERGUY — Thu, 12 Jul 2007 22:33:35 GMT

We need a computer programming forum.

Reply #5

GASMETERGUY — Thu, 12 Jul 2007 22:33:22 GMT

We need a computer programming forum.

Reply #4

CyberBam — Tue, 10 Jul 2007 18:23:23 GMT

Aha.. I see what you mean, very good idea, thank you.

Gotta start reading VBA for dummies then :)

If any one else have an idea please do share it, thank you

Reply #3

time*treat — Tue, 10 Jul 2007 03:28:07 GMT

Doing this with a macro would be possible. You will need a couple of arrays (one for the current line, and one to hold your tallies) and a couple of loops (one for the drawn set, and one for the user set). You will also need to be a bit familiar with VBA, because any code you get here would need to be adjusted for your exact layout.

Reply #2

RJOh — Tue, 10 Jul 2007 03:25:55 GMT

I was comparing West Virgina Cash25 (6/25) with Ohio Classic Lotto (6/49) just for an example. I usually compare my playing file with the file of the game I'm playing.

Reply #1

RJOh — Tue, 10 Jul 2007 03:20:12 GMT

Most good lottery software can compare two different files one number at time. Even my home made DOS software can do that.

Example:

SEARCH/COMPARE FILES

SEARCHING FILE :CLOTO649 [73/73] WITH FILE :WVA625 [1569]

FILE NAME REC.NO. DATE NUMBERS MATCH

WVA625 11569 07/09/07 01 06 18 19 20 24 MIN. 2

______________________________________________________________

CLOTO649 12 62 10 06/13/07 01 19 25 29 33 46

Hits against combo in Excel

CyberBam — Tue, 10 Jul 2007 02:48:59 GMT

Hello everyone...

I am playing a lotto 7/35 type of game and here is what I'm trying to do:

I have about 2000 of the previous draws on one sheet and about 400 of my own combinations on another sheet and I want to know how many hits every comb. have in the previous draws?

like:

4hits 5hits 6hits 7hits

Comb 1: 01 05 08 12 17 33 34 44 5 1 0... [ More ]