Using my own number sets in Excel - how to check winning numbers easily & quickly?Prev Topic Next Topic

New Topic New Poll

billbled

Winston Salem, NC
United States
Member #70,383
January 31, 2009
7 Posts
Offline

Jun 17, 2014, 8:44 pm

Hi,

I've tried searching the forums for this, but I'm not sure what to search for....

I play Carolina Cash 5 (39 numbers) exclusively.

Here's what I want to do:

1- Enter into Excel my 5 number sets in a spreadsheet. Let's say I had 55 number sets, so I'd have 55 rows, with each row having 5 numbers, one in each column A thru E.

2- After each draw, I want to input the wining 5 numbers (in another row?), start a Macro, push a button, whatever....and have Excel show me all of the number matches throughout all 55 number sets. It could bold the matching numbers, change the background color, whatever. I don't care.

But I want to make my own number sets - and have an automated way to "win check" them.

Has anyone done this?

Is it possible?

Search terms or forum thread pointers?

Another piece of software that does this?

Thanks in advance for any help.

--Bill
basilio

United States
Member #145,201
July 31, 2013
94 Posts
Offline

Jun 18, 2014, 2:18 am

There you go,

https://dl.dropboxusercontent.com/u/100391577/P5-39.xlsx
billbled

Winston Salem, NC
United States
Member #70,383
January 31, 2009
7 Posts
Offline

Jun 18, 2014, 5:40 am

Wow! Thanks so much - that's exactly what I was looking for.

thank you thank you!
misswinner

Florida
United States
Member #129,510
June 20, 2012
11 Posts
Offline

Jun 18, 2014, 1:58 pm

Hey Basilio. I was trying to send u message but your inbox is full, Hey by any chance do you assist with prediction with the Florida lottery and also will you be posting another great number in Maddogs PB/MM challenges...
basilio

United States
Member #145,201
July 31, 2013
94 Posts
Offline

Jun 18, 2014, 4:14 pm

Quote: Originally posted by misswinner on Jun 18, 2014
Hey Basilio. I was trying to send u message but your inbox is full, Hey by any chance do you assist with prediction with the Florida lottery and also will you be posting another great number in Maddogs PB/MM challenges...

i keep it that way :)

will help you with anything i can - about the PB my system tells me when to play or not ( basically if the game is in alignment or not )

usually once every 7 to 10 draws ( from my experience with CA 5/39 game ) - will post new numbers as soon as my system gives me the OK

Thx
mrcraft

Los Angeles, California
United States
Member #149,486
December 2, 2013
919 Posts
Offline

Jun 18, 2014, 4:23 pm

Quote: Originally posted by basilio on Jun 18, 2014
i keep it that way :)

will help you with anything i can - about the PB my system tells me when to play or not ( basically if the game is in alignment or not )

usually once every 7 to 10 draws ( from my experience with CA 5/39 game ) - will post new numbers as soon as my system gives me the OK

Thx

i keep it that way :)

So, did you get flooded with requests since your 5+1 prediction?
DaExpert

Los Angeles
United States
Member #156,171
June 10, 2014
34 Posts
Offline

Jun 18, 2014, 5:17 pm

Quote: Originally posted by mrcraft on Jun 18, 2014
i keep it that way :)

So, did you get flooded with requests since your 5+1 prediction?

sure did

and i respond to all my PMs, but for now i just don't have a reliable prediction for PB

i prefer quality over quantity so i only post predictions when i am confident

did you hit Fantasy 5 yet ? its at 100K today !
mrcraft

Los Angeles, California
United States
Member #149,486
December 2, 2013
919 Posts
Offline

Jun 18, 2014, 5:26 pm

Quote: Originally posted by DaExpert on Jun 18, 2014
sure did

and i respond to all my PMs, but for now i just don't have a reliable prediction for PB

i prefer quality over quantity so i only post predictions when i am confident

did you hit Fantasy 5 yet ? its at 100K today !

Yup, I'm gonna buy a ticket soon.
lotsofwins

Texas
United States
Member #114,698
August 5, 2011
4,623 Posts
Offline

Jun 18, 2014, 11:01 pm

Hey Basillo-actually mrcraft answered my question about the PB-but also tried sending you an email about the Texas cash 5 (If you could take a look) I can sometimes get 3 of 5 with it-but that is with weeks of me holding the same numbers-appreciate any help you can provide..-also congrats on the PB win yayayay
basilio

United States
Member #145,201
July 31, 2013
94 Posts
Offline

Jun 19, 2014, 8:52 am

Quote: Originally posted by DaExpert on Jun 18, 2014
sure did

and i respond to all my PMs, but for now i just don't have a reliable prediction for PB

i prefer quality over quantity so i only post predictions when i am confident

did you hit Fantasy 5 yet ? its at 100K today !

why did you post my PM respond to you ??!?!?!
basilio

United States
Member #145,201
July 31, 2013
94 Posts
Offline

Jun 19, 2014, 8:53 am

Quote: Originally posted by lotsofwins on Jun 18, 2014
Hey Basillo-actually mrcraft answered my question about the PB-but also tried sending you an email about the Texas cash 5 (If you could take a look) I can sometimes get 3 of 5 with it-but that is with weeks of me holding the same numbers-appreciate any help you can provide..-also congrats on the PB win yayayay

i sent you a respond, thanks and good luck !