Welcome Guest
Log In | Register )
You last visited December 10, 2016, 7:35 am
All times shown are
Eastern Time (GMT-5:00)

excel help

Topic closed. 17 replies. Last post 12 years ago by winsumloosesum.

Page 1 of 2
PrintE-mailLink
shanemc1's avatar - zill
New Member
macon
United States
Member #12671
March 20, 2005
2 Posts
Offline
Posted: April 8, 2005, 11:16 pm - IP Logged

any help is appreceated. i need to turn these numbers into a pyramid with the number with the highest value at the top and the lowest value lower right

0= 15                                                                        0
1= 12                                                     
2= 8                                                                  7               1 
3= 9
4= 8                                                            6            3              4
5= 8
6= 11                                                      5        2            8            9
7= 13
8= 5
9= 4

crude model to give you an idea of what i am trying to do

i can get excel to do everything ok i just got stuck with the numbers with the same value on paper i just use the first number in a games history to break ties in this example 4 shows up most recent in game history.

again if you can help thank you.

ps: cant spell

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: April 9, 2005, 2:19 am - IP Logged



    dim digits() as integer, rank() as integer

    dim t as integer, rank_val as integer, passes as integer,currentnum as integer

    dim high_val as integer, low_val as integer



    rank_val = 0

    redim digits(9)

    redim rank(9)

    for t = 0 to 9

        digits(t)=0 '<----- your digit "counts" will go here, later

        rank(t) = 0 '<---- let's you rank numbers that have the same 'count'

    next t



    ...(cycle through your numbers using) ...

    digits(currentnum) = digits(currentnum) (plus) 1



    ....' after your 'counts' are set '.....



    high_val = 0

    low_val =100



    for t= 0 to 9

        if digits(t) > high_val then high_val = digits(t)

        if digits(t) < low_val then low_val = digits(t)

    next t



    for passes = high_val to low_val step -1

    for t = 0 to 9

        if digits(t) = passes then

          rank_val = rank_val (plus) 1

          rank(t) = rank_val

        end if

    next t

    next passes



    'after this point, you can place the number by calling the

    digit or the rank and set it in whatever cell you want'

    (plus) is used where the symbol wouldn't show up

    In neo-conned Amerika, bank robs you.
    Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

      shanemc1's avatar - zill
      New Member
      macon
      United States
      Member #12671
      March 20, 2005
      2 Posts
      Offline
      Posted: April 9, 2005, 8:46 am - IP Logged

      Thank you for your help its been some time since i messed with any vb im having some trouble with it

      hopefully you put me in the right direction

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: April 11, 2005, 10:26 pm - IP Logged

        GameDateResults
        Cash 35/1/20048, 7, 7
        Cash 35/2/20046, 5, 0
        Cash 35/3/20047, 4, 2
        Cash 35/4/20042, 4, 3
        Cash 35/5/20049, 4, 4
        Cash 35/6/20042, 7, 3
        Cash 35/7/20049, 6, 4
        Cash 35/8/20048, 4, 1
        Cash 35/9/20044, 4, 5
        Cash 35/10/20043, 5, 9

         

        I am trying to import previous lottery results into an excel spreadsheet. 

        The above is how it looks--Just wondering if there is any way that I can get rid of the , so that I can just cut and paste results into the specific area that I want.

        L ttaL   T

          johnph77's avatar - avatar
          CA
          United States
          Member #2987
          December 10, 2003
          832 Posts
          Offline
          Posted: April 12, 2005, 1:14 am - IP Logged

          lottaloot -

          If you are using this data from a text file in a simple editor like WordPad, simply use find-and-replace <CTRL-H> to replace the commas with spaces. If it's already a .csv (Comma-separated values) file, you have double commas in there - replace those double commas with a space and a comma.

          The other alternative is to remove the commas using the same method after the file is imported to Excel, and the numbers will be automatically converted to values after that is done.

          gl

          j

          Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

          Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

           =^.^=

            time*treat's avatar - radar

            United States
            Member #13130
            March 30, 2005
            2171 Posts
            Offline
            Posted: April 12, 2005, 4:26 am - IP Logged

            M$ XL also gives you the option of selecting a custom character to be treated as a delimiter or converted to another character. When you do an "import" from text look for a blank box near the top, where it shows what you will import. You put your apostrophe or whatever into that box. You can tell XL to treat it as a delimiter instead of a character. HTH

            In neo-conned Amerika, bank robs you.
            Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3594 Posts
              Offline
              Posted: April 12, 2005, 11:09 am - IP Logged

              time treat. Wonder if you could devise a spreadsheet to use for thread pick3 reviewed post to enter past say 30 draws and apply his filters by choice. I think he has some great ideas to help solve daily numbers. What do you think? thanks

                lottaloot's avatar - AvatarZ56
                Redford/MI
                United States
                Member #3396
                January 18, 2004
                4867 Posts
                Offline
                Posted: April 12, 2005, 12:13 pm - IP Logged

                Thanks you guys

                L ttaL   T

                  time*treat's avatar - radar

                  United States
                  Member #13130
                  March 30, 2005
                  2171 Posts
                  Offline
                  Posted: April 12, 2005, 7:22 pm - IP Logged

                  retxx,

                  I don't follow the pick 3 threads, so I don't know which poster you are referring to...

                  As far as applying filters "by choice"; if you mean "use filter A, is the numbers run "left" and use filter B, if the numbers run "right", then yes, it can be done. You would need some code to run behind the spreadsheet, though. If that wasn't your question, please rephrase it for me.

                  In neo-conned Amerika, bank robs you.
                  Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

                    retxx's avatar - mrthumbs
                    BOSTON
                    United States
                    Member #48
                    September 9, 2001
                    3594 Posts
                    Offline
                    Posted: April 12, 2005, 9:27 pm - IP Logged

                    to rephrase it I mean enter the last 30 pic3 draws and use filters such as hll-lhh-sums as an example to reduce the amount of plays. hll meaning high-low-low and lhh meaning low-high-high. I will find the correct thread number so you can look at his formula. I will get back. thanks

                      retxx's avatar - mrthumbs
                      BOSTON
                      United States
                      Member #48
                      September 9, 2001
                      3594 Posts
                      Offline
                      Posted: April 12, 2005, 9:31 pm - IP Logged

                      it is on lottery systems and is old pick3 method reviewed by lantern. Quite interesting and informative.

                        time*treat's avatar - radar

                        United States
                        Member #13130
                        March 30, 2005
                        2171 Posts
                        Offline
                        Posted: April 13, 2005, 2:03 am - IP Logged

                        for those of you playing at home, the "system" in question is at

                        http://www.lotterypost.com/thread/110385

                        Steel yourselves for pointless verbosity.



                        Happily, I don't have to change my original answer.

                        You drop the numbers into a spreadsheet. You run different scenarios and output them to another/other sheets depending on which/how many scenarios you're using. Your code picks up the numbers, parses them, runs your filters, drops your results onto your output page(s). You can even branch based on intermediate results.



                        The good news is your code will take up fewer pages than that thread.

                        In neo-conned Amerika, bank robs you.
                        Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3594 Posts
                          Offline
                          Posted: April 13, 2005, 11:13 am - IP Logged

                          I misunderstood you because I thought there was a spreadsheet at that thread but nothing. can you write one to conform with what lantern is doing manually? thanks

                            Avatar
                            Ga
                            United States
                            Member #4378
                            April 17, 2004
                            136 Posts
                            Offline
                            Posted: April 13, 2005, 11:23 am - IP Logged

                              time*treat's avatar - radar

                              United States
                              Member #13130
                              March 30, 2005
                              2171 Posts
                              Offline
                              Posted: April 13, 2005, 6:29 pm - IP Logged

                              retxx,

                              there are two pieces, the spreadsheet which just holds the raw data, that's more cut-and-paste than "write", and the code which does all that comparison stuff, is the part you "write". If you're interested in trying to code his system, you can use the code at the beginning of this thread as one possible starting place. You would only need to modify it slightly to hold the extra ranking and statistical data. The people who play p3 and write their own code probably have most of the other parts already in their systems somewhere. LANTERN pointed out there are variations on the filters, so you could have different results even with the same code as someone else. LANTERN has tied them together in a particular way. All of the pieces exist, you just have to put them together, or buy someone else's. I'm sure there are retail versions that do this, if you don't write your own code.

                              In neo-conned Amerika, bank robs you.
                              Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.