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

# need excel for what a difference

Topic closed. 23 replies. Last post 12 years ago by retxx.

 Page 2 of 2
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: January 26, 2005, 5:19 pm - IP Logged

Wow did thread get off the topic!!

I am almost finished "Bug's" System Excel worksheet.

There are a couple questions I wanted to ask:

1. How many past drawings do you use?

2. How do you determine if a Pair is "HOT", "DUE" or "PLAYED"?

Once I get the rest of the info I will give it out to those that would like a copy.  If it is OK with BUG.

Thanks,

Winsum

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 30, 2005, 10:38 am - IP Logged

Back to the excel sheet ;-)

I first must learn the system, but I have already made some progress in automation on sheet 2 of the original excel workbook. Right now it will...

A. let you enter the numbers into the sheet for your state

B. separate them into 3 new columns, e.g. you enter into column C 714, then column D will change to 7, E to 1 and F to 4... this step is key to automatic recalculation... Since it was set up using 2 months of draws, I left that the same.

C. it now automatically calculates the front and back pair sums using BUG's conversion system, I adapted them into excel using the following....

for SUM

=IF((D7+E7>9),(D7+E7-10+1),(D7+E7))

For Difference

=IF((E7<D7),((E7+10)-D7),(E7-D7))

D. it automatically counts the front/back sum and front/back differences, so when you change the input numbers, it automatically adjusts.

E. it uses a rudimentary formula to determine extreme HOT and extreme DUE (MAX and MIN respectively) and alerts you to it... that was done with this formula...

=IF((N5=MAX(\$N\$5:\$N\$14)),"HOT",IF((N5=MIN(\$N\$5:\$N\$14)),"DUE"," "))

I need to understand where the rest of the numbers come from before I can go further... on sheet 2 is a section in gray with a note that says "need one of these as a back pair"... whare do these numbers come from? why are they needed from the back pair and where in the rest of the information were they calculated from?

I'm not half bad with excel, I just don't follow the system 100% yet... but progress has indeed been made ;-)

Playing more than one ticket per game is betting against yourself.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 30, 2005, 3:48 pm - IP Logged

Yes Hypersoniq you are pure genius material

L ttaL   T

United States
Member #89
January 18, 2002
2092 Posts
Offline
 Posted: January 30, 2005, 8:24 pm - IP Logged

SirMetro,

The website about "Fractal Geometry" impressed me quite well. I'm not of the 'nerd' persuasion nor am I a genius or scientist but I am quite aware of good information.

Thank you,

Teufellj...

BOSTON
United States
Member #48
September 9, 2001
3584 Posts
Offline
 Posted: January 30, 2005, 9:26 pm - IP Logged

wow wtg hyper for all your hard work here,we will all benefit I hope. With a couple more questions answered you might be able to finish down to the final cells needed to list probable numbers to play. Thanks

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: February 3, 2005, 8:46 pm - IP Logged

quick Q.

in the original file, second worksheet... I get that all the numbers below 04 use a +1+1 progression...

(automated thusly...

"04" is at M31... move the "0" to L31 and leave the 4 at M31, then in L32 put

=IF((L31+1)<10,(L31+1),((L31-10)+1))

drag this formula from L32 thru M40, this sets up your numbers to automatically add just one (even to a 9) regardless of the starting number.....

)

my question is where does the "04" come from originally?

Playing more than one ticket per game is betting against yourself.

Greensboro, North Carolina
United States
Member #1616
June 5, 2003
1285 Posts
Offline
 Posted: February 13, 2005, 10:38 am - IP Logged

hyper, how is the project coming along?

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: February 13, 2005, 4:19 pm - IP Logged

still trying to figure out the rest of the system...

formula creation is the easy part for me, I have trouble figuring out exactly how the system ends up with the numbers it does, once I get that info, the rest is easy.

Playing more than one ticket per game is betting against yourself.

BOSTON
United States
Member #48
September 9, 2001
3584 Posts
Offline
 Posted: February 13, 2005, 9:10 pm - IP Logged

did you pm bug to get those answers?

 Page 2 of 2