<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/">
  <channel>
    <title>Listing Pick-3 numbers</title>
    <link>http://www.lotterypost.com/thread/90940</link>
    <atom:link href="http://www.lotterypost.com/rss/topic/90940" rel="self" type="application/rss+xml" />
    <description>Lottery Post Forum Topic: Listing Pick-3 numbers</description>
    <dc:language>en-us</dc:language>
    <generator>Lottery Post RSS Generator</generator>
    <item>
      <title>Reply #7</title>
      <link>http://www.lotterypost.com/thread/90940/228537</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/228537</guid>
      <pubDate>Mon, 12 Jul 2004 11:06:15 GMT</pubDate>
      <dc:creator>Colin F</dc:creator>
      <description><![CDATA[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]]></description>
      <category>Colin F</category>
    </item>
    <item>
      <title>Reply #6</title>
      <link>http://www.lotterypost.com/thread/90940/228417</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/228417</guid>
      <pubDate>Sun, 11 Jul 2004 23:18:59 GMT</pubDate>
      <dc:creator>hypersoniq</dc:creator>
      <description><![CDATA[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]]></description>
      <category>hypersoniq</category>
    </item>
    <item>
      <title>Reply #5</title>
      <link>http://www.lotterypost.com/thread/90940/228415</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/228415</guid>
      <pubDate>Sun, 11 Jul 2004 23:12:04 GMT</pubDate>
      <dc:creator>UCI1</dc:creator>
      <description><![CDATA[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... [&nbsp;<a href="http://www.lotterypost.com/thread/90940/228415">More</a>&nbsp;]]]></description>
      <category>UCI1</category>
    </item>
    <item>
      <title>Reply #4</title>
      <link>http://www.lotterypost.com/thread/90940/228152</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/228152</guid>
      <pubDate>Sun, 11 Jul 2004 12:24:02 GMT</pubDate>
      <dc:creator>Bertil</dc:creator>
      <description><![CDATA[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]]></description>
      <category>Bertil</category>
    </item>
    <item>
      <title>Reply #3</title>
      <link>http://www.lotterypost.com/thread/90940/227326</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/227326</guid>
      <pubDate>Fri, 09 Jul 2004 08:54:12 GMT</pubDate>
      <dc:creator>UCI1</dc:creator>
      <description><![CDATA[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... [&nbsp;<a href="http://www.lotterypost.com/thread/90940/227326">More</a>&nbsp;]]]></description>
      <category>UCI1</category>
    </item>
    <item>
      <title>Reply #2</title>
      <link>http://www.lotterypost.com/thread/90940/227322</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/227322</guid>
      <pubDate>Fri, 09 Jul 2004 08:13:18 GMT</pubDate>
      <dc:creator>Colin F</dc:creator>
      <description><![CDATA[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]]></description>
      <category>Colin F</category>
    </item>
    <item>
      <title>Reply #1</title>
      <link>http://www.lotterypost.com/thread/90940/226791</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940/226791</guid>
      <pubDate>Thu, 08 Jul 2004 00:36:54 GMT</pubDate>
      <dc:creator>JAP69</dc:creator>
      <description><![CDATA[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]]></description>
      <category>JAP69</category>
    </item>
    <item>
      <title>Listing Pick-3 numbers</title>
      <link>http://www.lotterypost.com/thread/90940</link>
      <guid isPermaLink="true">http://www.lotterypost.com/thread/90940</guid>
      <pubDate>Thu, 08 Jul 2004 00:27:26 GMT</pubDate>
      <dc:creator>Bertil</dc:creator>
      <description><![CDATA[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]]></description>
      <category>Bertil</category>
    </item>
  </channel>
</rss>