Welcome Guest
You last visited December 9, 2016, 4:45 am
All times shown are
Eastern Time (GMT-5:00)

# Some new results on some old techniques.

Topic closed. 792 replies. Last post 3 years ago by Greenfox.

 Page 18 of 53
Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 9:48 pm - IP Logged

Excel - Subtraction formula conversion:

=IF(C3<=9,C3,IF(VALUE(RIGHT(TEXT(C3,0),1))=0,

...if(right(text(c3,0),1)="0",

Thank you SergeM for any excel help!!!  Like i said, I'll take all the knowledge about it i can.

I'm adding any tips to my list. I don't know what the VALUE, TEXT and all that mean. I haven't tried to use any of them yet. I really got to learn what does what.

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:01 pm - IP Logged

Hi Greenfox, I am here. Shop just called me and told me to get on that you had something to show us.

llucas

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:02 pm - IP Logged

This is some changes i made to this. First, I put a new sheet at the first of the book. In this sheet, you can either put the draws in by hand here and have it fill the book, or you can link it to the even/odd book and it will do it when you fill in that page. You can use it either way.

I have updated a copy with the formula that KnuckleHead wrote for us. I had to change the first part of it to show 0 if the cell it was getting info from was 9 or under. I couldn't see the numbers like i was.

Thirdly, i had noticed in the new part, that where it added the total X together, that if it was a 10 I might should put another set of columns to show those numbers. I don't even know how to explain this. You just gotta see it. So here it is. I love this one, so I'm going to show it first. It's just cool!!!

You may have to scroll over to see this. But you gotta see this!!!

This is the December 31, 2012 day draw here in NC. 9-1-7 was the numbers drew.

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:03 pm - IP Logged

Hi Greenfox, I am here. Shop just called me and told me to get on that you had something to show us.

llucas

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:08 pm - IP Logged

So without the 917 being in the date box for the 31st, would we still see the same info in the new boxes you just added?

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:14 pm - IP Logged

So without the 917 being in the date box for the 31st, would we still see the same info in the new boxes you just added?

That's what the data brought up with the formulas working. The winning number only comes in after the draws happen and you type it in either on the sheet it's self, the new first sheet i made, or in the even/odd books first page. Making this thing pick for us is way out of my knowledge of Excel usage. This is the info that the two previous draws brought up only. So yes your correct.

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:16 pm - IP Logged

That's what the data brought up with the formulas working. The winning number only comes in after the draws happen and you type it in either on the sheet it's self, the new first sheet i made, or in the even/odd books first page. Making this thing pick for us is way out of my knowledge of Excel usage. This is the info that the two previous draws brought up only. So yes your correct.

Have you uploaded the new version so I can down load it?

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:19 pm - IP Logged

Have you uploaded the new version so I can down load it?

So you see it? No I haven't got them up yet. I will have them up in a sec and get the links up here.

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:25 pm - IP Logged

So you see it? No I haven't got them up yet. I will have them up in a sec and get the links up here.

Yes I do and I love it, if it is going to do what I think it will. My ultimate goal is to be able find the winning number with no more than 5 numbers to play. I tried last night and I was off, but the winner was there staring me in the face and I still missed it. Today I was a little bit closer but still missed it.

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:47 pm - IP Logged

1-2013 Days:

http://www.sendspace.com/file/c2j6nb

1-2013 Evenings:

http://www.sendspace.com/file/zgs0az

These have the bugs worked out with the highlighting issues, a new first page with dual linking capabilities. You can either put the numbers in the Draws sheet, or link it to the first sheet of the EVEN/ODD books.

Best of luck and enjoy!!!!!!

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:52 pm - IP Logged

1-2013 Days:

http://www.sendspace.com/file/c2j6nb

1-2013 Evenings:

http://www.sendspace.com/file/zgs0az

These have the bugs worked out with the highlighting issues, a new first page with dual linking capabilities. You can either put the numbers in the Draws sheet, or link it to the first sheet of the EVEN/ODD books.

Best of luck and enjoy!!!!!!

Thank you, getting ready to test it out now. By the way are these books universal, meaning can we use them for future months or will we need new ones for the up coming months. Just thinking ahead....

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 10:54 pm - IP Logged

The December 30, 2012 day draw for NC.

You think the 9 and 6 is connected? On these keep your eyes in the upper corner of this new part.

This one was 7-7-6

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Gastonia, NC
United States
Member #117368
October 4, 2011
1677 Posts
Offline
 Posted: January 3, 2013, 10:59 pm - IP Logged

The December 30, 2012 day draw for NC.

You think the 9 and 6 is connected? On these keep your eyes in the upper corner of this new part.

This one was 7-7-6

Would you say it would have been safe to play both the 776 and the 779?

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 11:06 pm - IP Logged

Would you say it would have been safe to play both the 776 and the 779?

Yes, i would have. LOL. Plus look in the root of 8 under the counter 23 and 24, then again in the root of 8 under the 18 and 19.

Plus in the root of 5 from under counter 5 to 9 and see what you see.

Gonna get a shave and shower and I be back with more.

You can't steal second and keep your foot on FIRST!!!

When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
 Posted: January 3, 2013, 11:08 pm - IP Logged

Thank you, getting ready to test it out now. By the way are these books universal, meaning can we use them for future months or will we need new ones for the up coming months. Just thinking ahead....

You can always make copies, but I'm making all months. I have Feb about done. Just got a few more things to do to them. But yeah there will be more. I've even went back and tested the first draws in NC with it. I LIKE.

BTW, anyone know when and where the first pick 3 game in the US was and when? I'd like to just play with it a bit.

You can't steal second and keep your foot on FIRST!!!