Excel pick3 whole number longest out counter by draw

Reply #13

Greenfox — Mon, 20 Jul 2020 08:55:02 GMT

Did you get that going and did it do what you wanted it to?

From your description it should be what you was looking for, but I never heard if it worked for you.

Just checking in case I needed to do anything differently.

Has anyone else been able to use them or is others having troubles with it

Reply #12

Greenfox — Sat, 11 Jul 2020 20:27:33 GMT

I didn't know you wanted them ranked. They are now. Now you can find a specific set, if you have one in mind, and see how many times it has been drawn plus see how many games back it is.

You can also see the sets that are the most out down to the most recently drawn. This will give you 2 different perspectives that will be fast and easy to find what you are looking for. If you want to know when the last time 123 was drawn, it will be in the data set of columns G through N with all of each num... [ More ]

Reply #11

TasBob — Sat, 11 Jul 2020 11:56:09 GMT

I'v got to be doing something wrong. I'll wait for video.

Here's what I was trying to get. I lost this program with computer crash

Number Draws out ...........#type I do not need. Need just the number and draws out

BOXED:

Longest out prior to Todays date

(Both Draws)

Draws

Num out # type

000 30000 Triple

555 30000 Triple

444 30000 Triple

199 30000 Dbl

557 30000 Dbl

222 30000 Triple

149 937 6-way

099 907 Dbl

666 874 Triple

117 830 Dbl

4... [ More ]

Reply #10

Greenfox — Sat, 11 Jul 2020 04:05:51 GMT

Try this one. It will only hold 5,000 draws though, but is faster on calculations.

If anyone is having trouble with these, please let me know so I can either fix the problem or let you know what I need to so you can use them.

Filling these in with draws is one of 4 ways. Just need one. If your draw history data is set as ### all in one cell you will only use column F or column M. If your oldest draws are at the bottom and you are pasting, use column F. Find how many draws you have had on y... [ More ]

Reply #9

TasBob — Sat, 11 Jul 2020 03:07:55 GMT

Ok TKS

Reply #8

Greenfox — Sat, 11 Jul 2020 02:49:59 GMT

Sounds like it may be a processor issue. I'll cut it down for you for a smaller game count, change it so it works off the numbers and not the date and upload a copy that way. I'm not going to build something for someone they can't use.

Reply #7

TasBob — Sat, 11 Jul 2020 02:39:02 GMT

I can't get running I reloaded it , Took if off try it again no luck.

Tks anyway Tas

Reply #6

Greenfox — Fri, 10 Jul 2020 17:27:56 GMT

I just downloaded the file I uploaded and tested it. If you just put your numbers in and not the date, it will not give you results. Did you put the dates in also? Try that and see what it does.

Reply #5

TasBob — Fri, 10 Jul 2020 14:50:05 GMT

I downloaded it but can't get it working.

I put in 600 draws , then to Draw Totals, hit Calculate, Get all o's.(Total and Games Back).

Reply #4

Greenfox — Fri, 10 Jul 2020 03:12:00 GMT

Pick 3 boxed sets and games back tracker

For whomever wants a copy of it here it is. This will handle 10,000 draws so it should do most all states history and have room for more.

Input and reversal sheet is now so you can put the digits separate in their own cells, all 3 in one cell and can be put in either oldest at the top or oldest at the bottom so no matter how you update, it will take care of it.

For oldest draws at the bottom, paste or start in columns B10001 for the date, C,... [ More ]

Reply #3

AllenB — Thu, 09 Jul 2020 23:01:44 GMT

Bob,

I will put this in the Eliminator File that I sent You.

Simple really but I will have to expand the draw data to include all of the Games Available.

Reply #2

TasBob — Thu, 09 Jul 2020 17:52:51 GMT

Yes 120 singles,90 Doubles Track them all,each draw.

Reply #1

Greenfox — Thu, 09 Jul 2020 17:19:10 GMT

Nevermind. I'll make something up. I'm guessing you are wanting for all discreet box sets and not just 231? I've got that discreet set book so it will be fairly easy with that. It's going to take more than just a formula to pull that off.

Excel pick3 whole number longest out counter by draw

TasBob — Thu, 09 Jul 2020 17:15:29 GMT

Is there excel formula that can update longest out numbers all box (231 Bx ),with 1000 draws I need it updated every draw.. TKS