Pick-3 statistics

[Bertil]

I'm looking for a site where the Pick-3 game results are listed without a dash
in the numbers because when transfering them to Excel it lists them as dates.
That makes it impossible to do any kind of analysis. I need hundreds of past
numbers for the work I've in mind.

Bertil

 

[tomtom]

I'm looking for a site where the Pick-3 game results are listed without a dash
in the numbers because when transfering them to Excel it lists them as dates.
That makes it impossible to do any kind of analysis. I need hundreds of past
numbers for the work I've in mind.

Bertil

well, if you already have such results, then maybe is a better idea asking here or at some programing forum how to import data, while data will not be listed as dates...I believe have seen that's possible in just few steps using tools and options but didn't really pay attention to it... anyone familiar with excel can provide an answer...

 

[GillesD]

Quick way out of dates

Not always easy to deal with data ressembling dates but here is a quick solution that may give you what you want.

Let's say your imported data is in a date format in column A. Then, in the next three columns, using row #2 as an example, enter the following formulas:
- in B2: =DAY(A2)
- in C2: =MONTH(A2)
- in D2: =YEAR(A2)

Of course, this assumes that the data in column A is in a day/month/year format; otherwise, adjust as necessary. Also in some cases, you may need to format those three new columns in a number format with no decimals.

After that, you can transform the results of the formulas into data using the Copy and Paste Special commands and delete column A that is no longer needed.

 

[tomtom]

Not always easy to deal with data ressembling dates but here is a quick solution that may give you what you want.

Let's say your imported data is in a date format in column A. Then, in the next three columns, using row #2 as an example, enter the following formulas:
- in B2: =DAY(A2)
- in C2: =MONTH(A2)
- in D2: =YEAR(A2)

Of course, this assumes that the data in column A is in a day/month/year format; otherwise, adjust as necessary. Also in some cases, you may need to format those three new columns in a number format with no decimals.

After that, you can transform the results of the formulas into data using the Copy and Paste Special commands and delete column A that is no longer needed.

There is much easier way…it goes using data-text to columns (converting )and then importing or pasting the data… Needed that longer time ago and did it just easily, but don’t remember now how exactly …not sure what is the exact way, but it goes something like this…

 

[tomtom]

There is much easier way…it goes using data-text to columns (converting )and then importing or pasting the data… Needed that longer time ago and did it just easily, but don’t remember now how exactly …not sure what is the exact way, but it goes something like this…

and, column data format should be text when asked when converting...

therefore, it goes like this: import or paste any data, then select it, then data (toolbar), then text to columns, select text option, finish converting and then import or paste data in the formated(converted) selection....that should be it...

 

[blitzed]

Hello Bertil,

I'd simply dump results to text, do a search and replace '-' with ' '

Or do manual import, then delete the '-' columns from the imported spreadsheet.

Also, what type of pick3 analysis are you doing? pick3 is fluid and constantly changes...I don't see much value in anything more than 28draws, unless maybe you are trying to track pairs in 100 or so. The further out you go, the less value there is in probability.

blitzed