excel help-developing strategy

Reply #9

SergeM — Fri, 02 Nov 2012 16:17:03 GMT

Simple example of filtering by results

Reply #8

SergeM — Fri, 02 Nov 2012 16:12:44 GMT

Headers: Date n1 n2 ... nn function.

Apply filter on function.

--------------------------------------------------

Your job is to study the built in functions first.

For each function there is a good help file. Read it, try it and repeat it.

Your main tools are:

functions, filter, sorting and coloring.

-----------------------------------------------------------

After filtering you can copy the results and paste them to another sheet if you want to work on the found dat... [ More ]

Reply #7

jackpotismine — Sat, 27 Oct 2012 13:37:04 GMT

Since I don't know how to program excel that's why I'm posting here.

Reply #6

SergeM — Sat, 27 Oct 2012 13:06:54 GMT

For single numbers you can do this manually or in Excel. For more you need to write a program. - A drawn number can be hot or not, follower or not and both together, partially or not. That makes 2*2=4 cases. - Indeed you could try winning by wheeling only hot and followers. - Even if you find high scoring followers, they will start failing to some point, as it is in the nature of the lottery that the drawings are mainly different.

Reply #5

jackpotismine — Sat, 27 Oct 2012 12:35:06 GMT

Use it as a tool to select my numbers and also have others benefit from this type of program. I want to compare the followers with the numbers that are either 'hot, cold or due or what my instints tell me. I'm interested in the group numbers not so much the single followers. From groups of 3,4,5, or 6 as I stated in my initial post. Of course I could do it manually but it some what time consuming.

Reply #4

SergeM — Sat, 27 Oct 2012 12:22:06 GMT

I already programed that, by single numbers and by combinations.

No, I am not selling.

What do you want to do with it

Reply #3

jackpotismine — Sat, 27 Oct 2012 10:53:21 GMT

So for the next draw which is Sunday 10-28. How many of of six will show? Stay tuned...

Reply #2

jackpotismine — Sat, 27 Oct 2012 09:55:35 GMT

Here's an actual example of a 1 year draw result:

the most recent draw was

We have 3 draws a week. So as you can see 16,24,25 came out 4 times and 33 27 came out 3x

I want to be able to do this for at least 5 years of draws.

Reply #1

jackpotismine — Sat, 27 Oct 2012 04:38:39 GMT

Here's an example of a pick 6 game here in China:

Last numbers drawn on 2012-10-25--------------3-5-12-15-23-24

So now I'm going to see if in previous draws there was at least 3-6 numbers from the previous draws that are the same. When I find a draw that has at least 3-6 of the same numbers drawn in the last drawn number. I write down what came out the VERY NEXT DAY DRAW.

For example on 10-7 the numbers drawn was: 5-6-7-12-15-28 . At least 3 numbers came out from the last draw(3-5-12-15... [ More ]

excel help-developing strategy

jackpotismine — Sat, 27 Oct 2012 03:42:18 GMT

Hopefully someone can help me.

Let's take a pick 5 game as an example. What I want to get are the 'followers' of a set of numbers that are drawn. Let me explain further.

Let's say: 3-7-8-10-33 came out tonight. I want to collect all the drawings that have at least 3 number the same from the 3-7-8-10-33 and get the 'followers'. Next I want to know out of these followers, how many times the digit came out.

Let's say: Jan. 2nd 3-6-7-10-34 came out so we have at least the 3-7-10 so what was... [ More ]