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

need a macro enlighten for dynamic skip and hit interval

Topic closed. 12 replies. Last post 10 years ago by paurths.

Page 1 of 1
PrintE-mailLink
sysp34's avatar - Lottery-062.jpg
Heroic City
Indonesia
Member #31689
February 2, 2006
1153 Posts
Offline
Posted: June 25, 2006, 9:47 am - IP Logged

Hi Macro/VBA master

is it posible to create dynamic skip and hit interval? because i have created open source spreadsheet that need dynamic skip and hit interval for smaller size and faster spreadsheet.

here is the link:

http://rapidshare.de/files/24071533/syshac1k.zip.html (1251 KB)


well i hope any Macro/VBA master would enlighten me.

so far the result like this

h.c.a
103 203 803 143 243 843
153 253 853 106 206 806
146 246 846 156 256 856
107 207 807 147 247 847
157 257 857 109 209 809
149 249 849 159 259 859 

for 15 state with eve drawing
--------------------------------
Monday, June 19, 2006
California 3-1-5
Florida  1-7-4
Louisiana  0-2-9
Michigan 0-6-1
New Mexico  0-1-7
New York 9-1-5*
Ohio 3-4-8 5-2-7
Tennessee 0-3-2*
Virginia 5-8-6*

9 hit with 3 correct state (eve)
--------------------------------
Tuesday, June 20, 2006
Connecticut 1-6-4
Delaware 2-6-4
Michigan 8-0-7
Missouri 1-9-5
Virginia 2-6-0*
Washington, D.C. 2-6-4

6 hit with 1 correct state (eve)
--------------------------------
Wednesday, June 21, 2006
Connecticut 0-1-9*
Georgia 2-0-7 6-1-0*
Maryland 1-7-0
Texas 1-0-3 0-7-2*
Tri-State 0-1-7*
Virginia 0-8-3*

6 hit with 5 correct state (eve)
--------------------------------
Thursday, June 22, 2006
Illinois 8-3-4
Maryland 9-4-1
New York 4-7-2
South Carolina 5-6-8*
Tri-State 7-8-4*

5 hit with 2 correct state (eve)
--------------------------------
Friday, June 23, 2006
Connecticut 4-7-2
Indiana 4-7-2
Missouri 3-8-5
Pennsylvania 3-5-2
Tri-State 0-6-1*
Virginia 3-1-0*
Washington  7-5-8 
Washington, D.C. 1-3-4

8 hit with 2 correct state (eve)
--------------------------------
Saturday, June 23, 2006
Connecticut  2-0-3
Minnesota  0-3-1 
Nebraska  1-0-7 
New York 0-3-2 9-5-1*
Ontario  1-7-5
Puerto Rico  2-0-6
South Carolina 1-0-7
Tennessee 2-5-7*
Washington, D.C. 1-4-3

10 hit with 2 correct state (eve)
--------------------------------

thank and good luck

sysp34

    SirMetro's avatar - center
    East of Atlanta
    United States
    Member #6191
    August 11, 2004
    1389 Posts
    Offline
    Posted: June 28, 2006, 8:54 pm - IP Logged

    Please explain the origins of the original numbers so I can better understand how to write the required macro. I have an idea, but need more directions to better implement it.

    Sir Metro

      sysp34's avatar - Lottery-062.jpg
      Heroic City
      Indonesia
      Member #31689
      February 2, 2006
      1153 Posts
      Offline
      Posted: June 28, 2006, 10:02 pm - IP Logged

      Please explain the origins of the original numbers so I can better understand how to write the required macro. I have an idea, but need more directions to better implement it.

      Sir Metro

      Sir Metro,

      thank for replying,

      about dynamic skip and hit interval, i mean after we update drawing files then it should count last 30 skip and 30 hit interval. i though it need macro code because "the code" only count last row.

      formula to count skip and hit interval

      =IF(OR(((COUNTA(draw!$F$2:$F3)+1)-((COUNTA(draw!$F$2:$F3)+1)-(ROWS(draw!$F$2:$F3)-MATCH(2,1/SEARCH(B$1,draw!$F$2:$F3)))))=0,((COUNTA(draw!$F$2:$F2)+1)-((COUNTA(draw!$F$2:$F2)+1)-(ROWS(draw!$F$2:$F2)-MATCH(2,1/SEARCH(B$1,draw!$F$2:$F2)))))=0),((COUNTA(draw!$F$2:$F2)+1)-((COUNTA(draw!$F$2:$F2)+1)-(ROWS(draw!$F$2:$F2)-MATCH(2,1/SEARCH(B$1,draw!$F$2:$F2))))),"")

      it was extended for this formula if(or(a1=0,a2=0),count skip or hit,blank)

      00 03 00 00 01 00 04 00 01 00 00 00 07 00 03 00 00 00 00 00 03 00 00 01      00 04 00 00 00 03 00 00 03 00 13 00 01 00 03 00 03 00 01 00 00 03 00 03 00 01 00 03 00 03 00 01 00 04 00 00

      therefore we need macro to count ONLY last 30 skip and 30 hit or 60 skip and hit interval for these patterns

      a.c.h, 2a.c, 2a.h, 2c.a, 2h.a, 2c.h, 2h.c, 3a, 3c, 3h,

      A.A.A, A.A.C, A.A.H, A.C.A, A.H.A, C.A.A, H.A.A, A.C.C, A.C.H, A.H.C, A.H.H, C.A.C, C.A.H, C.C.A, C.H.A, H.A.C, H.A.H, H.C.A, H.H.A, C.C.C, C.C.H, C.H.C, C.H.H, H.C.C, H.C.H, H.H.C, H.H.H     
      123

      AHC     
      AHC     
      AHC     

      single.FD     
      double.FD     
      triple.FD     

      012345     
      012345     
      012345

      well thanks, i hope we HAC pick 3/4 games lol

      if you have any question please make some questionaire and email to me i try to answer your question, because often my neuron are fastest that my hand, that way my english language is worst. lol

      sysp34

        LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
        Tx
        United States
        Member #4570
        May 4, 2004
        5180 Posts
        Offline
        Posted: July 2, 2006, 4:02 am - IP Logged

        Who will help sysp34?

        Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).

        BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

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

          sysp34's avatar - Lottery-062.jpg
          Heroic City
          Indonesia
          Member #31689
          February 2, 2006
          1153 Posts
          Offline
          Posted: July 2, 2006, 4:43 am - IP Logged

          Who will help sysp34?

          Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).

          Fernando, my friends

          i think that not possible to do in worksheet, because the dynamically conditions.

          btw tx eve only cacth pair x38 lol still need learn from the PROFESSOR. :)

          well thanks and good luck.

            LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
            Tx
            United States
            Member #4570
            May 4, 2004
            5180 Posts
            Offline
            Posted: July 3, 2006, 6:06 am - IP Logged

            Who will help sysp34?

            Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).

            Fernando, my friends

            i think that not possible to do in worksheet, because the dynamically conditions.

            btw tx eve only cacth pair x38 lol still need learn from the PROFESSOR. :)

            well thanks and good luck.

            sysp34

            My friend, You are both: The Master and The Professor, hardly anybody is a match for you, you are almost The Predictor Supreme or maybe you already are, you seem to already be.

            You have left me and many others very far behind.

            This does not mean that you know everything and that have no more to learn, as I have never posted about everything that I know about filters and I learn more as time goes by, for example: I just today, by meditating on the Lotto 007 P3P4Demo program's filters, I created new filters, that is possible good variations of some already known filters, they are both: New and old, new uses or new ways of using some filters, but an unknown variation of their regular use, I will add them to my growing list of filters, some of which I might have never posted about, I have showed way too much already as it is and Paurths does not seem to want to add any more filters to his FreeWheelers any-way, not even those of which I have already posted about.

            If you can, try to add some VISUAL stats or Graphics to your spreadsheets, as Visual representation(s) of stats can help a lot, you can see things in them that you can't see just with numbers' stats.

            Master sysp34, Good luck to you.

            Fernando.

            BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

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

              paurths's avatar - underground
              Switching between Fairfax, VA and Belgium
              Belgium
              Member #19287
              July 29, 2005
              2254 Posts
              Offline
              Posted: July 3, 2006, 6:17 am - IP Logged

              lol Fernando,

              there are only 24 hours in 1 day...

              greetz
              Ricky

                CARBOB's avatar - FL LOTTERY_LOGO.png
                ORLANDO, FLORIDA
                United States
                Member #4924
                June 3, 2004
                5913 Posts
                Offline
                Posted: July 3, 2006, 6:53 am - IP Logged

                lol Fernando,

                there are only 24 hours in 1 day...

                greetz
                Ricky

                Ricky,

                 You mean, you have to eat, sleep and work? LOL

                   Go Germany!!!

                 

                  LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                  Tx
                  United States
                  Member #4570
                  May 4, 2004
                  5180 Posts
                  Offline
                  Posted: July 3, 2006, 6:54 am - IP Logged

                  Ricky

                  Yes, I know. Not to worry.

                  Thanks a lot.

                  Fernando.

                  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: July 3, 2006, 7:08 am - IP Logged

                    Layout for doubles: 

                    <AddList:NumberClasses> B
                    <SelectFilter:NumberTypes> S,D
                    <AddList:Numbers:FromLotteryProgram>
                    <SubtractList:AbbrSums:LastDraw>
                    <SubtractList:Roots:LastDraw>
                    <SubtractList:LineWidth:9+Last2Draws>
                    <SubtractList:Roots:2ndLastDraw>
                    <SubtractList:Sums:3rdLastDraw>
                    <SubtractList:Pairs:LastDraw>
                    <SelectFilter:Pairs:>
                    <SubtractList:BoxedNumbers:Last26Draws>
                    <SelectFilter:KeyNumbers:0,1,2,3,4,5,6,CountFromLth-Rth,GoingDown,BeginWithLastDraw>
                    <SelectFilter:KeyNumbers:4,5,6,7,8,9,SameInstructionsAsAbove>
                    <SelectFilter:KeyNumbers:5OrfewerDigitsNotForDoubles>

                    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: July 3, 2006, 7:11 am - IP Logged

                      I know that the use of these layouts is hard to understand to those not familiar with the particular program, but What can I do or say?

                      Those are just some very good layouts, but not all of them, just most of them.

                      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: July 3, 2006, 7:14 am - IP Logged

                        The 3 last lines of Key Numbers commands is a special key numbers technique and so perhaps very hard to understand.

                        BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

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

                          paurths's avatar - underground
                          Switching between Fairfax, VA and Belgium
                          Belgium
                          Member #19287
                          July 29, 2005
                          2254 Posts
                          Offline
                          Posted: July 3, 2006, 10:00 am - IP Logged

                          lol Fernando,

                          there are only 24 hours in 1 day...

                          greetz
                          Ricky

                          Ricky,

                           You mean, you have to eat, sleep and work? LOL

                             Go Germany!!!

                           

                          I don't eat that much, but i sometimes drink enough for an entire week lol!

                          Go France!!!!! Go Zizou!!!!