This Cracks Lotto pick 5, I need your Help

Reply #25

time*treat — Fri, 07 Oct 2011 15:55:17 GMT

Can't answer the java question about maximum, but as far as the dimensions -- it's only 2: [500 rows x 400 columns].

Reply #24

thinktank — Fri, 07 Oct 2011 15:35:09 GMT

outch! I have 500+ rows, with about 400 cells per row! should i use a one dimensional aray and make its elements 400, i.e. int[] a = new int[400]

what are the max elements I can have in an array in java

Reply #23

time*treat — Fri, 07 Oct 2011 15:30:50 GMT

Good stuff, here. The Assembly language mention gave me a chuckle. Took a course in that -- talk about needing to have your code well thought out. Check wiki for a sample of what its code looks like.

Back to VBA, I load the data into memory and run it that way, the spreadsheet is mainly just to verify things and save the trouble of writing a 'container'.

Unless they've upped it in newer versions, the maximum number of excel array dimensions is 32.

Reply #22

Teamprofit — Fri, 07 Oct 2011 15:15:45 GMT

Wow....Thank you very much for your in-depth explanation. This was very helpful since I have close to zero programming knowledge. I did take c++ in high school but I didn't pay to much attention lol..I wish I did at this point in my life.

I'm in no rush though, I will attempt to learn at my own pace...since i'm getting by fairly well using excel/google docs. But the thing that really catches my attention and makes me want to learn programming is the idea that I can run different systems simul... [ More ]

Reply #21

paurths — Fri, 07 Oct 2011 14:34:46 GMT

Hi,

You can read and write to excel files.

There is no need to open them.

The way this is done is in your java code.

Basically you will be declaring a filename, a workbook, a worksheet, and perhaps even rows and cells, which then will point to your excel file -- workbook -- worksheet -- rows -- cells.

Your code will then open the excel file in memory, not visible on the screen. (unless you implicitly tell it to render the visibility property to true)

You will not want to manipu... [ More ]

Reply #20

thinktank — Fri, 07 Oct 2011 12:54:32 GMT

I want to reclarify something. When I said this cracks Lotto pick5, I was speaking of lotto 5/39 game, no the actually pick 5 with the example, 1-8-8-9-0 game. the lotto 5/39 game will have the example winning numbers, 7-10-26-33-39. Sorry for the misleading interpretation of this forum room

Reply #19

thinktank — Fri, 07 Oct 2011 12:50:44 GMT

I REALLY appreciate your in-depth description of which route I would like to take. I am currently interested in going the Java route; however, my algorythm is so complicated, yet so simple, that trying to come up with lego blocks to build in Java is daunting. Basically I have my 1000 lines of 400 cells each, and they are in an excel spreadsheet. Can I interface with this spreadsheet with Java, without converting the spreadsheet it into a text file , in which I dread? I basically want to leave ev... [ More ]

Reply #18

paurths — Fri, 07 Oct 2011 07:13:17 GMT

It helps if you would read the question.

Reply #17

jarasan — Thu, 06 Oct 2011 23:00:43 GMT

We got that:

https://www.lotterypost.com/words-to-numbers

Reply #16

paurths — Thu, 06 Oct 2011 20:44:17 GMT

First i'd like to begin with saying: this is just my opinion. There will be others, plenty of them, that don't share my thoughts here.

The choice depends on what languages one knows or is familiar with.

First of all, the high level languages will be performing slower, but will be for the programmer a gift if she or he wants to write a program very quickly.

The lower you go, and why not immediatly go to assembly, the faster it will perform. And in theory it will outperform any other comp... [ More ]

Reply #15

Teamprofit — Thu, 06 Oct 2011 19:28:28 GMT

What would you say is the better programming to create a lottery based system

Reply #14

paurths — Thu, 06 Oct 2011 18:22:38 GMT

Yes, it is faster, way faster. (ofcourse, it always depends on how you costructed your code, algorithm)

There is no user interface involved, that alone makes it faster.

In Excel, VBA for that matter, you can not use threading, while in java (or c++ or c#, and others) you can use threading which allows different tasks to be performed concurrently. (you'll need to study this in dept, because in java, or a dot.net language) you'll be using objects created from classes (instances) and they exi... [ More ]

Reply #13

paurths — Thu, 06 Oct 2011 18:09:58 GMT

Show the algorithm you are using for this calculation.

We might start from there to enhance it.

Reply #12

thinktank — Thu, 06 Oct 2011 15:44:35 GMT

Do java programs, run faster than macros? If so, can you make a table, or array as easy as microsoft excel? This is paramount for the success of my idea! Excel does a superb job, but it's just too slow

Reply #11

Peter00 — Tue, 04 Oct 2011 22:01:46 GMT

learn java programming. you do that and you can do any thing to an input file or database . in one year i'd say you can master it. one year of learning will last forever to lotto people like us.

plus java is free. works on any computer.

Reply #10

thinktank — Wed, 21 Sep 2011 14:22:49 GMT

Thanks so much Dr.San for your input and I will note advice, as it breaks a two digit number down to a simple 4 condition number. I see what you are doing, however, my process gets way involved than two digit numbers, and to explain it, would bore you to death. Maybe I can apply your concept if I sit and think about how to adapt it over into a 100 letter length word- maybe encoding every 5 letters into a one digit number. The letter length word is important to maintain in its entirety.

Reply #9

dr san — Wed, 21 Sep 2011 14:11:46 GMT

Hello, thinktank, then your work, go to the end no matter gives or does not result. This is just my suggestion example of a lottery = 39 / 5 02 15 23 31 36 pp i.i p.i i.i i.p where pp = 02 front of the digit is even and the final digit is even = i.i both digits are odd p.i = digit pair and the front end odd i.p = odd and even four conditions are more then these filters = caption = digits O = odd E = pairs L = low (0,1,2,3,4) H = high (5,6,7,8,9) 1,7,2,3,4 = LHLLL 00EOE 3,1,4,8,2 = LLLHL 00EEE 5,... [ More ]

Reply #8

thinktank — Wed, 21 Sep 2011 13:23:15 GMT

If someone could help me with this problem in excel, then the lottery would be solved!

Look at the below example as this is as simple as I can explain it! Please don t over think this problem or you will get stuck like me!

Take the three words for example, Cake, Lace, Tape:

In the above three words, the common string letters in each word is ae

I am trying to develop a macro that can look at per say these three words for simplicity and find the common string letters am... [ More ]

Reply #7

thinktank — Wed, 21 Sep 2011 11:09:55 GMT

thanks Teamprofit and Malie, at least you guys are optimistic, I will post this in the right forum before the trolls come and start planting their seeds of doubt

Reply #6

Teamprofit — Wed, 21 Sep 2011 03:03:37 GMT

Post this in the mathematics section, make subject excel macro help or assistance. The right people should see this there.......interesting concept.

good luck

Reply #5

Raven62 — Wed, 21 Sep 2011 00:58:41 GMT

It seems that you are unsuccessful at conveying what you're trying to accomplish and you're unwilling to try! Good Luck with your pursuit

Reply #4

malie10 — Wed, 21 Sep 2011 00:32:27 GMT

Sounds like a good idea, but No clue on how to do anything with excel. I like paper and pen! !

I do this with the daily 3. I use the letters on my phone keypad and try to help it make more sense to me. I've had some nice hits but I think it may have been random.. for example, the last 7 draws of the PA midday. Read from bottom up starting with 634.

581

994

700

393 Not a good system either when we see a 1 or 0, or doubles. Other than that, I will wait and see what midday tomo... [ More ]

Reply #3

thinktank — Wed, 21 Sep 2011 00:29:18 GMT

Raven u must have time to waist by making that pesimistic statement, go troll somewhere else! U haven't even given me time to explain my concept. Better yet, so I can cease mockery from u and other trolls, if anyone is interested where I'm going with this concept pm me! I'm not going to discuss it here anymore due to trolls lurking

Reply #2

Raven62 — Wed, 21 Sep 2011 00:17:41 GMT

Don't waste our time: If you can't give an actual example: That's exactly what your doing!

Happy Trails to You

Reply #1

Coin Toss — Tue, 20 Sep 2011 22:26:28 GMT

think tank,

It sounds like you're trying to apply some Bible Code type approach here.

The a/e's in cake, lace, and tape are string vowels interrupted by consonants.

Are you trying to substitute letters for nnumbders, or actuall trying to find 100 leter words?

The only such word I can think of is the name of a town in Wales, but I'm not even sure that it is 100 letters long.

This Cracks Lotto pick 5, I need your Help

thinktank — Tue, 20 Sep 2011 19:20:39 GMT