Welcome Guest
Log In | Register )
You last visited January 17, 2017, 5:54 am
All times shown are
Eastern Time (GMT-5:00)

Excel Question

Topic closed. 32 replies. Last post 7 years ago by LottoChica23.

Page 2 of 3
PrintE-mailLink
Play4Keeps's avatar - 656f0b5f5f1f6b58
End Of The Rainbow
United States
Member #67807
December 5, 2008
489 Posts
Offline
Posted: November 29, 2009, 10:20 am - IP Logged

Ok...lemme give that a try.

One moment, please.

Ok. I opened the .doc file up in wordpad. Good.

Now, how do I get the info over to excel so that I can change ';' to ',' and so on?

 

I'm really trying....

In Everything You Do.....PLAY 4 KEEPS!

Lots of luck, everyone!!

         





    LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
    Tx
    United States
    Member #4570
    May 4, 2004
    5180 Posts
    Offline
    Posted: November 29, 2009, 10:22 am - IP Logged

    No

    you will open the file with word or WordPad or with notepad, and change it there, you will not change it with Excell

    BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

    "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

      LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
      Tx
      United States
      Member #4570
      May 4, 2004
      5180 Posts
      Offline
      Posted: November 29, 2009, 10:23 am - IP Logged

      Waith a moment 1 second

      BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

      "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

        Play4Keeps's avatar - 656f0b5f5f1f6b58
        End Of The Rainbow
        United States
        Member #67807
        December 5, 2008
        489 Posts
        Offline
        Posted: November 29, 2009, 10:23 am - IP Logged

        Ok. I opened the .doc file up in wordpad. Good.

        Now, how do I get the info over to excel so that I can change ';' to ',' and so on?

         

        I'm really trying....

        Ya'll are so helpful...don't let me get on your nerves.

        I saw that you meant for me to do that in WordPad, after my last post.

        So, I've now done the changing of the semi-colon's and the colon's over to the comma's.

        Still working on the rest.

        In Everything You Do.....PLAY 4 KEEPS!

        Lots of luck, everyone!!

                 





          LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
          Tx
          United States
          Member #4570
          May 4, 2004
          5180 Posts
          Offline
          Posted: November 29, 2009, 10:25 am - IP Logged

          BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

          "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

            Play4Keeps's avatar - 656f0b5f5f1f6b58
            End Of The Rainbow
            United States
            Member #67807
            December 5, 2008
            489 Posts
            Offline
            Posted: November 29, 2009, 10:27 am - IP Logged

            I GOT IT!!!!  Big Grin

             

            Thank ya'll sooooo much!!!  Learn something new everyday, I always say.

             

            Ok. Since I have your 'eye', is there a way to look for repeating numbers in this new file that we've made today?

             

            Many, Many Thanks.

            Sandra

             

             

            In Everything You Do.....PLAY 4 KEEPS!

            Lots of luck, everyone!!

                     





              LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
              Tx
              United States
              Member #4570
              May 4, 2004
              5180 Posts
              Offline
              Posted: November 29, 2009, 10:27 am - IP Logged

              Now save the test file as a TXT or Doc or whatever.

              then rename the text or doc file so the ending has:

              .CSV

              Then all you have to do is click on it and it will open in Excel

              BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

              "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                Tx
                United States
                Member #4570
                May 4, 2004
                5180 Posts
                Offline
                Posted: November 29, 2009, 10:28 am - IP Logged

                Wait a few seconds OK?

                BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                  Play4Keeps's avatar - 656f0b5f5f1f6b58
                  End Of The Rainbow
                  United States
                  Member #67807
                  December 5, 2008
                  489 Posts
                  Offline
                  Posted: November 29, 2009, 10:29 am - IP Logged

                  Well, I gotta run out a minute. But, I will be back later on in the afternoon.

                  See ya'll then.

                  In Everything You Do.....PLAY 4 KEEPS!

                  Lots of luck, everyone!!

                           





                    LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                    Tx
                    United States
                    Member #4570
                    May 4, 2004
                    5180 Posts
                    Offline
                    Posted: November 29, 2009, 10:33 am - IP Logged

                    BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                    "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                      LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                      Tx
                      United States
                      Member #4570
                      May 4, 2004
                      5180 Posts
                      Offline
                      Posted: November 29, 2009, 10:41 am - IP Logged

                      As on the picture all that you have to do is:

                      Go to

                      Edit and enter for example:

                      9,1,4

                      And then Press

                      Find Next

                      and just keep on pressing

                      Find Next untill you find al the

                      9,1,4

                      That there are on the file.

                      --------------------

                      But that is the hard way as you will have to enter 1 pick 3 number at a time.

                      You if you need to see all the repeats of pick 3 numbers, boxed and or straights you need either to have a Excel workout for it or to use a lottery program.



                      BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                      "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                        LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                        Tx
                        United States
                        Member #4570
                        May 4, 2004
                        5180 Posts
                        Offline
                        Posted: November 29, 2009, 11:01 am - IP Logged

                        BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                        "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5396 Posts
                          Offline
                          Posted: November 29, 2009, 11:07 am - IP Logged

                          Maybe this will also help.

                          Instructions for Importing Virginia Pick 3 Draws to Excel

                          http://www.box.net/shared/y1f01c48xc

                            LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                            Tx
                            United States
                            Member #4570
                            May 4, 2004
                            5180 Posts
                            Offline
                            Posted: November 29, 2009, 11:12 am - IP Logged

                            Next here at the Lottery Post go to

                            The blue menu bar above to

                            System

                            to

                            Deflate 3 numbers set reduction

                            Then leave all the deflate options settings alone as they are, don't change anything at all.

                            Just paste the numbers that you copied from your site onto the space given for them on the deflate.

                            You can use

                            Ctrl + V

                            To paste the pick 3 numbers there with.

                            Then all you have to do is

                            Click on

                            Deflate Numbers at the bottom left of the Deflate program and it will give you this:

                            • Results:  200 box combination groups  (664 straight combinations)
                            • Tier 10
                              061(610,160,061,160,601,610,016,601,016)

                               

                              Tier 9
                              579(597,957,579,579,759,795,795,975) 928(982,928,289,289,289,829,892,982) 978(789,879,987,798,798,789,978,978) 846(468,648,486,648,846,684,864,684)

                               

                              Tier 8
                              093(093,039,930,903,039,309,930) 379(379,793,973,937,793,937,793) 263(236,263,263,362,362,362,263)

                               

                              Tier 7
                              940(049,490,049,049,094,094) 294(924,492,924,924,429,492) 796(679,796,976,796,697,796) 563(356,635,365,563,365,563) 718(817,781,781,871,718,187) 076(670,760,670,670,607,670) 870(870,708,780,870,708,708) 782(728,782,728,782,287,827) 321(123,312,321,132,321,213) 726(276,276,267,726,672,267) 325(352,235,253,352,523,532) 553(553,355,553,355,355,535) 691(169,619,916,916,961,691)

                               

                              Tier 6
                              135(513,531,531,315,531) 721(712,172,127,172,127) 324(234,432,324,324,324) 677(776,767,776,776,776) 650(650,560,056,506,506) 386(368,683,836,683,638)

                               

                              Tier 5
                              033(303,033,330,303) 834(438,834,384,384) 674(476,764,746,476) 831(183,813,381,813) 184(418,841,418,148) 823(832,283,238,832) 714(417,174,471,714) 048(840,804,480,804) 906(690,069,906,609) 562(526,256,526,652) 516(165,156,561,165) 029(209,092,092,029) 842(842,248,428,428) 797(779,797,779,797) 058(058,850,058,058) 931(391,193,931,931) 162(162,621,126,261) 680(860,068,608,680) 043(034,403,304,340)

                               

                              Tier 4
                              704(074,407,704) 512(512,125,251) 375(357,375,357) 344(434,434,443) 327(273,723,723) 406(406,604,046) 799(997,799,979) 134(431,143,341) 847(487,478,784) 146(641,416,461) 743(374,374,374) 963(963,963,396) 945(594,495,594) 901(190,019,901) 207(270,270,720) 346(436,643,436) 717(771,771,771) 150(501,051,150) 564(465,654,546) 955(559,595,595) 130(310,103,031) 971(197,197,971) 250(502,025,052) 389(893,839,893) 089(098,098,809) 402(402,042,042) 856(568,568,856) 852(582,285,258) 021(102,012,210) 885(885,858,885) 496(496,946,694)

                               

                              Tier 3
                              062(026,206) 522(225,522) 171(117,171) 244(424,424) 700(700,007) 090(900,090) 063(036,603) 981(198,891) 988(898,988) 202(022,202) 722(227,227) 821(821,821) 617(167,167) 830(308,038) 592(295,952) 772(727,772) 050(005,050) 339(393,339) 730(073,730) 618(618,168) 587(587,785) 534(435,345) 591(519,591) 268(286,682) 815(581,158) 991(919,991) 768(687,867) 242(242,422) 140(014,410) 293(293,239) 733(733,373) 765(657,567) 950(509,950) 274(247,274) 552(255,552) 447(474,744) 504(054,504) 079(970,709) 100(100,100) 219(912,129) 124(241,124) 154(415,415) 745(754,574) 736(673,763) 667(676,676)

                               

                              Tier 2
                              333(333) 082(082) 701(071) 965(596) 993(993) 194(194) 663(366) 477(477) 911(119) 229(229) 869(869) 550(055) 660(660) 223(223) 558(585) 895(985) 844(844) 778(778) 899(998) 666(666) 441(441) 974(974) 440(044) 838(838) 882(828) 499(499) 737(377) 775(757) 593(359) 669(966) 081(810) 664(664) 783(387) 203(302) 626(266)

                               

                              Tier 1
                              161 282 394 554 661 984 788 323 020 566 300 226 996 524 686 992 642 770 088 385 444 544 221 011 173 449 575 571 655 927 296 113 752 644 343 099 361 118 411 350 211 854 881

                               


                            Filters: No filtering selected

                            -------------------

                            As you can see:

                            Study that the numbers are in goups by how many times the numbers repeated or came out on all those draws that you copied from the Va site.

                            Here you have all the numbers for the whole year of 2009.

                            You have enough free trials of the Deflate system to do this and other things with it many times if you need to.

                            Otherwise there are offline  lottery programs that can also do that.

                            BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                            "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5396 Posts
                              Offline
                              Posted: November 29, 2009, 11:19 am - IP Logged

                              Maybe this will also help.

                              Instructions for Importing Virginia Pick 3 Draws to Excel

                              http://www.box.net/shared/y1f01c48xc

                              If you download the draws to a text file to your Desktop you can create a Macro that will import the text files into Excel

                              You will need to change the "YourName" in the macro to whatever your user name is for your computer.

                              I named my macro ImportDraws

                               

                              Sub ImportDraws()

                                  ChDir "C:\Users\"YourName"\Desktop"
                                  Workbooks.OpenText Filename:="C:\Users\"YourName"\Desktop\Pick3_ASCII.doc-1.txt", _
                                      Origin:=437, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
                                      xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=True, _
                                      Comma:=True, Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), _
                                      Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1)), TrailingMinusNumbers:=True


                              End Sub

                               

                              Then in Excel select Tools > Macros > select ImportDraws macro the select > Run