649 Triple Pairings

cdrake

Member
This is a follow up to the thread I posted a couple of weeks ago. In the original thread I had requested a simple program that could analyze a 649 data-file for triple pairings. I wanted the program to list all the triple pairings present and there frequency. I also wanted these triples to be listed from the highest occurring to the lowest. In the original thread I should have stated that the data files that I have been working with are .txt files with no special formatting. The data-sets consist of 6 numbers in a row with 1 space between each of the numbers. Each row represents 1 draw and the draws are arranged in the order of the most recent to the oldest. These files are compatible with Ion Saliu’s lottery software, which I utilize to generate optimum combinations. The lottery software that I have seen being offered on the web, that could possibly perform this task, generally have a limited time frame of usage before one has to purchase the software to continue doing so. I am looking for software that would be classified as shareware of freeware. There was a reply to my previous thread in which excell was utilized to perform this task. This would be great as long as I could import .txt files into excell without running into any formatting issues. Since I am working with large files it would be too time consuming to have to enter each combination 1 by 1 not to mention that there would be a high probability of a data entry error occurring. Thank you for your help and I eagerly await your reply.
 

jbiff

Member
Hey cdrake,
It couldn't hurt to give Excel a try. It really only takes a minute or less to import a text file the way you have it formatted. This is my first attempt at giving this kind of advise, so let me know if you try and either have success or frustration...the more you use it the easier it gets.

To import text file in Excel
1. Open a blank workbook
2. Look across top toolbar and single click the word "Data"
3. Move your curser to the bottom and over the words "Import External Data"
4. More options appear to the right. Single click "Import Data"
5. The "Select Data Source" box should appear. At the bottom where it says "Files of type:" click drop down menu and scroll down till you find "Text Files(*.txt;*.prn;*.cvs;*.tab;*.asc)" and select it.
6. Go to the top "Look in:" dropdown menu and find the location of your text file and double click on it.
7. The "Text Import Wizard-Step 1 of 3" box appears. Because of the way you have formatted your text file the rest is easy. Click the "Next" button.
8. Hopefully you should now see the top 4 to 6 draws in your file divide into 6 columns. Just click the "Finish" button.
9. On the "Import Data" box click "OK" button

Provided the above worked, you’re now ready to start learning how to do some lotto Analysis Excel magic
I know this isn't the answer to the original question, but hope this helped some ...if not at least we tried
Biff
 

thornc

Member
again...

Go and take a look at this thread!

Download LottoStatistics it should do what you want!

You might have a bit of work converting from Saliu's text format to the one used by LottoStatistics but it shouln't take much time!

Just out of curiosity, how have you had good results with saliu's software?
 

Beaker

Member
Re: again...

thornc said:
Go and take a look at this thread!

Download LottoStatistics it should do what you want!

You might have a bit of work converting from Saliu's text format to the one used by LottoStatistics but it shouln't take much time!

Just out of curiosity, how have you had good results with saliu's software?

Can you do all 18,424 triples in that SW? :confused:

I bet GillesD could write a quick macro for this in VB. I know he has one for triple consecutives but not ALL triples ;)
 

thornc

Member
Re: Re: again...

Beaker said:
Can you do all 18,424 triples in that SW? :confused:
Nope, just up to 250 for frequency!
But that should be more than enough!



I bet GillesD could write a quick macro for this in VB. I know he has one for triple consecutives but not ALL triples ;)
I want to bet too... who accepts the bets :D !!

:lol:
One of these days, I have to get back to coding stuff... we this new job I haven't had the time or the motivation to do it :(
 

GillesD

Member
Triples in Excel

Yes, Beaker, it is fairly easy for Excel to calculate this information. A macro to calculate triples just has been listed in another thread.

And, thornc, you should not bet when the odds are against you. But surely you know that since you play the lottery.
 

Sidebar

Top