Daily Picker in Excel

Reply #25

lakerben — Wed, 16 Sep 2015 17:34:24 GMT

Thanks

Reply #24

AllenB — Tue, 15 Sep 2015 19:05:45 GMT

Thanks for your interest. I got side tracked looking at other ideas for Ca Fantasy Five. I do intend to post it when I get it to a user friendly state. The calculations are the easy part for me; however the Architecture of the worksheet is what takes most of the time for the posting to be understood and usable. I wrote instructions that I thought would make it easy to follow and was ready to post it then started working again and do not feel like I have the time to explain or respond to question... [ More ]

Reply #23

adulane62 — Sun, 13 Sep 2015 04:29:38 GMT

Colorado. What LP system is that

Reply #22

HHEH-100 — Sat, 12 Sep 2015 20:58:04 GMT

I'm serious......the systems are on l.p., I just put them in excel. What state are you in

Reply #21

HHEH-100 — Sat, 12 Sep 2015 20:56:36 GMT

I can't do to my partner.

Reply #20

adulane62 — Mon, 07 Sep 2015 00:55:35 GMT

HHEH-100 = The Joker from Gotham? OMG! And what is this winning number daily you speak of? Please do tell

Reply #19

retxx — Sun, 06 Sep 2015 19:40:18 GMT

HHEH. Are you willing to share it for us to test it in our states?Thanks

Reply #18

HHEH-100 — Sat, 05 Sep 2015 16:35:27 GMT

Sounds like something I have in excel. I have the winning number daily, 97% it is in box form.....working on Str8s. My sheet works on P3 and P4.

Reply #17

lakerben — Sat, 15 Aug 2015 17:27:08 GMT

Good idea

Reply #16

AllenB — Mon, 10 Aug 2015 23:33:20 GMT

Still Working on the Worksheet. It has grown much larger since I decided to use all of the numbers drawn on the same day in California for Fantasy5, Daily4, and Both Daily 3 draws in the equations. I am trying to process for a short list of high percentage combinations that I intend to Share. I don't think I will post the large worksheet; but I am working on a short version that would let you calculate some of your own formulas. It will be the nuts and bolts of the system and could be expanded b... [ More ]

Reply #15

lakerben — Sun, 09 Aug 2015 16:06:54 GMT

Can you post it

Reply #14

SergeM — Mon, 27 Jul 2015 22:33:28 GMT

Yes, surf to the menu page first.

https://emuis.be/pick3CA

There are 9 styled buttons. The buttons kind of work like links.

Some of the results are very big, others are short. You have to click and read through all of them.

By clicking on a button you request data from the server.

This can take a second or longer, depending of how much you are asking.

Nuthouse

You enter numbers and the server will return the combinations.

There are systems like one up or one down.

You

Reply #13

AllenB — Mon, 27 Jul 2015 21:04:02 GMT

I logged into nuthouse and California daily 3 on you site (I think). There was a box with labels but no numbers. Is this the right site

Reply #12

SergeM — Mon, 27 Jul 2015 20:39:42 GMT

In pick 3 you are mostly close to probability and the expectancy of payout ratio is 50%.

It is up to the reader to guess and play, if wished. Once you get used to the view, you may find good clues.

You are asking about sequence and combination. There is probability. I posted mathematics around followers straight and boxed.

There are followers charts on my webpage for California.

Reply #11

AllenB — Mon, 27 Jul 2015 20:34:05 GMT

Have you established a consistant set of scenarios that produce the numbers in the boxes you show

Reply #10

SergeM — Mon, 27 Jul 2015 20:22:03 GMT

Hits

RED: repeat GREEN: leapfrog BLUE: hit

DATE DT 0 1 2 3 4 5 6 7 8 9

2015-07-22 1 0 1 2 3 4 5 6 7 8 9

2015-07-22 2 0 1 2 3 4 5 6 7 8 9

2015-07-23 1 0 1 2 3 4 5 6 7 8 9

2015-07-23 2 0 1 2 3 4 5 6 7 8 9

2015-07-24 1 0 1 2 3 4 5 6 7 8 9

2015-07-24 2 0 1 2 3 4 5 6 7 8 9

2015-07-25 1 0 1 2 3 4 5 6 7 8 9

2015-07-25 2 0 1 2 3 4 5 6 7 8 9

2015-07-26 1 0 1 2 3 4 5 6 7 8 9

2015-07-26 2 0 1 2 3 4 5 6 7 8 9

Spans

DATE DT 0 1 2 3 4 5 6... [ More ]

Reply #9

SergeM — Mon, 27 Jul 2015 20:15:07 GMT

Reposting:

I have a page inspired by some wishes from members: Nuthouse , for pick 3 and pick 4. There is a system page too, but you weren't looking for that.

Reply #8

AllenB — Mon, 27 Jul 2015 20:14:17 GMT

Thanks, that is where I got the idea for this. I played with some of the posted sugestions and from that developed the Worksheet.

Reply #7

AllenB — Mon, 27 Jul 2015 20:12:53 GMT

You are right about overdoing this with functions. I have created a large number of scenarios in one worksheet and it gets to complicated and produces to many numbers. I have tried to use these multiple scenarios by selecting a diferent set for each number. The results are about the same.

Reply #6

SergeM — Mon, 27 Jul 2015 20:09:07 GMT

You need to look in the Systems forum, there you can read hundreds of posts of systems, that you call scenarios.

I have a page inspired by some wishes from members: Nuthouse , for pick 3 and pick 4. There is a system page too, but you weren't looking for that.

Reply #5

AllenB — Mon, 27 Jul 2015 20:06:50 GMT

I have run a bunch of scenarios using 1 to 3 of the numbers N1,N2,N3 and M1,M2,M3 with an individual games back for each plus multiple adds or subtracts.

I have also run formulas with exponents. there are so many option, I am looking for another persons ideas.

Reply #4

SergeM — Mon, 27 Jul 2015 20:03:54 GMT

I use a lite database for now.

With Excel you better don't over do it with functions.

Better keep values in cells than fill the sheets from top to bottom, and left to right with functions.

It crashes or delivers wrong values. It is finer working by lines. It never fails like that, and it is faster to use.

Also if you are playing locally, you don't need other stacks of drawings.

Reply #3

bigmon — Mon, 27 Jul 2015 20:02:08 GMT

Thanks Allen, let me and the crew know when it's ready. Sounds like another great tool. Thanks.

Reply #2

AllenB — Mon, 27 Jul 2015 20:00:41 GMT

Yes, my dat is based on California, but any Pick 3 Can Be quickly inserted into the games block.

Reply #1

SergeM — Mon, 27 Jul 2015 19:56:05 GMT

Is this about pick 3? I did some with php, here for California: Pick 3 CA USA .

What kind of scenarios are you looking for

Daily Picker in Excel

AllenB — Mon, 27 Jul 2015 19:00:05 GMT

For the last month I have been developing an Excel Worksheet that creates picks based on any calculation involving a previous number or sequence.

The first step was to download all of the picks for the California Daily 3 and calculate all of the mirror numbers for each sequence. The numbers are listed by game number (descending from Last draw) as follows: N1 N2 N3 M1 M2 M3

The next step was to create a formula set for each Number and Mirror number. For example: using M2 from a previous dr... [ More ]