Need Excel help (Pick-3)

Reply #9

lakerben — Wed, 11 Apr 2018 15:46:00 GMT

Any updates

Reply #8

dr san — Sun, 11 Mar 2018 14:24:27 GMT

Hello amber we can join as filters the doubles are pairs and doubles are of odd

Pairs = 0,2,4,6,8

Odds = 1,3,5,7,9

Ex 881 = double pairs 88

With an odd

Double odd two = 158

We have two odd

Objective to look for pairs and odd pairs within

From the three positions of pick 3 and pick4 also

Another ex = filter that the last two digits of pick3 are pairs

Then 524

986

Reply #7

amber123 — Thu, 08 Mar 2018 18:04:18 GMT

Yeah I figured it wasn't an original idea..lol

I did a short test in Florida and it looks promising. More box than str8, but there are a lot of duplicates which can be eliminated to cut cost. This reduction will eliminate potential str8 winners, but that's the only way to start off with this for right now.

I also eliminate any combos that have the same numbers If they are in the same position as the last winner. This filter eliminated a few combos.

Out of the 80 combos, I filtered them... [ More ]

Reply #6

amber123 — Thu, 08 Mar 2018 17:57:52 GMT

I love the work you do here for LP members, but I'm not an expert with these programs. Sets didn't change when i input a number into the yellow box. The Apache office Mr. B provided works.

But I do want to thank you for your work.

Reply #5

winsumloosesum — Thu, 08 Mar 2018 12:58:22 GMT

Amber let me know if the calculations are correct.

Thanks,

Wisnusm

Reply #4

amber123 — Thu, 08 Mar 2018 12:42:53 GMT

Thank you so much Winsum and Mr.B....you guys are the best.

Reply #3

Mr-B 216 — Thu, 08 Mar 2018 03:31:59 GMT

Check the link in this post for the Open Office format of destiny's system.

Here's a link for amber's system in Open Office format.

Reply #2

winsumloosesum — Thu, 08 Mar 2018 03:30:27 GMT

Hopefully this is what you are looking for:

https://my.pcloud.com/publink/show?code=XZAPrL7ZKwvmIDVtVmfd6oaPP4R3r8H59VVk

Excel 2010 Version

Enable Macros

You may need to adjust your security settings.

Enter your last drawing in cell D3 (D3:F3) merged cell

Click the Toolbar in cell range B8 through B11 CLICK TO CALCULATE

This macro will calculate all 8 +/- (see cell column M) and place the results in cell columns R4 through AJ83

Let me know if this is correct.

The winn... [ More ]

Reply #1

destiny2008 — Thu, 08 Mar 2018 00:12:17 GMT

hi amber

I remember this was done at one time for me. my variables were the same but the only number i used for 123. I remember asking someone to do for me, but I dont believe it was ever done. good luck

Need Excel help (Pick-3)

amber123 — Wed, 07 Mar 2018 19:54:21 GMT

Looking at some older systems here, I saw some potential in this, but it wasn't covering all sides of the angle. I'd like to test this system, but it would take too long to do on paper.

Hi, wondering if anyone can put this into a user friendly Excel...thanks.

I want to input the last winning number, and get 80 sets to play.

The variables are,

A: +++

B: ++-

C: -++

D: +-+

E: +--

F: -+-

G: --+

H: ---

I'd like those variables to be applied to,

01... [ More ]