Listing Pick-3 numbers

Reply #7

Colin F — Mon, 12 Jul 2004 11:06:15 GMT

Normally I would just leave something like this alone after giving the information I gave - but I'm mindful that others read posts like this.So, what's the big deal I thought. Now, I have to agree that the CT site is one of the worst I've come across as far as downloading data but not insurmountable.Here is what I recommend everybody does. Go and get yourself a student version of MS Access. You won't regret it.First step use Save As from your browser to put it somewhere in your Computer in HTML... [ More ]

Reply #6

hypersoniq — Sun, 11 Jul 2004 23:18:59 GMT

bertil, leave the -signs there... follow UCI1's instructions... then when using the excel import wizard, you can choose - as a column separator.there you can also pick the TYPE (date, number, text) of the column data.you could also force-format the cell, or just put into notepad and use find and replace to replace the - with nothing.When I got the data for the PB initially, I used the text file on the MUSL site, opened it with MSWord, sorted by date 'ascending' (so the newest is on the bottom... [ More ]

Reply #5

UCI1 — Sun, 11 Jul 2004 23:12:04 GMT

Quote: Originally posted by Bertil on July 11, 2004 UC11, Your advice looks good but there is a problem when saving the data file from the state lottery to my spread sheet. All numbers get converted to dates except for those with a zero in them. Cand these dates be reconverted to numbers? No not at this point. Once I have the numbers on the spread sheet as x-y-z I can replace the dashes with a blank and then prcess the digits into separate cells and perform statistical analysis of various kin... [ More ]

Reply #4

Bertil — Sun, 11 Jul 2004 12:24:02 GMT

UC11, Your advice looks good but there is a problem when saving the data file from the state lottery to my spread sheet. All numbers get converted to dates except for those with a zero in them. Cand these dates be reconverted to numbers and if so how should I do that. Once I have the numbers on the spread sheet as x-y-z I can replace the dashes with a blank and then prcess the digits into separate cells and perform statistical analysis of various kinds.Bertil

Reply #3

UCI1 — Fri, 09 Jul 2004 08:54:12 GMT

I think what Bertil is saying is that the numbers are listed as 123 and not 1,2,3 or 1-2-3.If you have MSExcel you can place the digits into seperate cells.Save the list of numbers to notepad, open Excel and click on the folder icon. This will open a window of your folder and files, at the bottom where it says File type, change that to say All Files as notepad is a .txt file. Find the file that has the numbers list and open it. This will open another window that will allow you to convert the dat... [ More ]

Reply #2

Colin F — Fri, 09 Jul 2004 08:13:18 GMT

BertilSeems like a very easy task to me as they are always single digits!What are you importing into?Why can't you use the mid function and convert to byte?Give some more details and I am sure a simple solution is available.Colin

Reply #1

JAP69 — Thu, 08 Jul 2004 00:36:54 GMT

South Carolina after deleting the st/ bx winners under each draw.June23, 2004 [ Evening ] 2 0 3 June24, 2004 [ Midday ] 9 4 4June24, 2004 [ Evening ] 4 5 6 June25, 2004 [ Midday ] 5 8 7June25, 2004 [ Evening ] 6 2 7 June26, 2004 [ Midday ] 4 7 2June26, 2004 [ Evening ] 9 3 7June27, 2004 [ Evening ] 7 8 8 June28, 2004 [ Midday ] 1 6 4June28, 2004 [ Evening ] 7 1 0 June29, 2004 [ Midday ] 1 6 9June29, 2004 [ Evening ] 2 6 3 June30, 2004 [ Midday ] 5 7 5June30, 2004 [ Evening ] 6 1 9

Listing Pick-3 numbers

Bertil — Thu, 08 Jul 2004 00:27:26 GMT

I would like to analyze the sum of Pick-3 winning numbers in a state lottery that reports them as :xyz and not as x-y-z. It has proven very difficult to transform the x-y-z to x,y,z needed for an analysis.Can some body please tell me a state that list the numbers as xyz, not x-y-z.Help would be greatly appreciated. I need one year of data.Bertil