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

need excel guru & master

Topic closed. 24 replies. Last post 11 years ago by SirMetro.

Page 2 of 2
PrintE-mailLink
LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
Tx
United States
Member #4570
May 4, 2004
5180 Posts
Offline
Posted: February 5, 2006, 9:53 pm - IP Logged

Sysp34

People are trying to understand your spreadsheet, I am not one of them, I don't do spreadsheets, I also don't do advanced or early future projected predictions, or project predictions into the future, just up to the very next draw, that does not mean that I could not do it, just that I have never really tried, except for one time for a several states 1 week prediction that I did and predicted right in 2 days, it was for about 5 states maybe, I can't remember, but it wasn't a real prediction, I just used a set of good "Generic" numbers.

For next draw predictions I can better help, but all of that is in my past filters' posts.

I don't plan on making very many new filters posts, at least no time soon.

Look at the old posts already given.

BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

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

    Avatar
    Central Pa.
    United States
    Member #4076
    March 19, 2004
    32 Posts
    Offline
    Posted: February 5, 2006, 10:55 pm - IP Logged

    Ok I take it the information you pasted on to us is from data in your main or general worksheet for ALL past draws and your trying to break it down to weekly and monthly is this correct? Soooooo just insert 2 more worksheets.name one weekly and one monthly and set up your same formulas to keep track of the last 7 or 14 if you have a mid day drawing and do the same for the last 30 or 60 in your monthly worksheet

     

     

     

     

    Still don’t have a clue what you’re trying to do.

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

      Sysp34

      People are trying to understand your spreadsheet, I am not one of them, I don't do spreadsheets, I also don't do advanced or early future projected predictions, or project predictions into the future, just up to the very next draw, that does not mean that I could not do it, just that I have never really tried, except for one time for a several states 1 week prediction that I did and predicted right in 2 days, it was for about 5 states maybe, I can't remember, but it wasn't a real prediction, I just used a set of good "Generic" numbers.

      For next draw predictions I can better help, but all of that is in my past filters' posts.

      I don't plan on making very many new filters posts, at least no time soon.

      Look at the old posts already given.

      yes i agree with you Lantern,

      if there are so many filter we'll be confused to pick up the "good" number.

      the .xls are for my wacth list to reduce p34lotto number by monthly_weekly trends. if there are even,odd,low,high,loweven,lowodd,higheven,highodd tendency i pick that number to reduce the 8 p34lotto component

      just sharing the file to select the "favorite" numbers

      regards
      sysp34

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

        check out the .xls file

        it's quite complex... even more so than the description above...

        6 worksheets

        it will take some time just to figure this thing out... let alone whatever added functionality is requested...

         

        bro hypersonic

        here are the modify .xls for pick 3 only.

        zip format 104 kb : http://www.rapidupload.com/d.php?file=dl&filepath=9743

        xls format 409 kb: http://www10.rapidupload.com/d.php?file=dl&filepath=16422


        i use your sb3.xls for monday, and for another day, the monthly_weekly range must be manually change. (is it any other step to change automaticly)

        i hope  this tools usefull for your lottery and all state, good luck 

        regards
        sysp34

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

          Ok I take it the information you pasted on to us is from data in your main or general worksheet for ALL past draws and your trying to break it down to weekly and monthly is this correct? Soooooo just insert 2 more worksheets.name one weekly and one monthly and set up your same formulas to keep track of the last 7 or 14 if you have a mid day drawing and do the same for the last 30 or 60 in your monthly worksheet

           

           

           

           

          Still don’t have a clue what you’re trying to do.

          Bob

          dear bob,

          the problem is monthly range must be modified manually :)

          column M to V
          column BB to CT

          eg: at .xls
          zip format 104 kb : http://www.rapidupload.com/d.php?file=dl&filepath=9743

          xls format 409 kb: http://www10.rapidupload.com/d.php?file=dl&filepath=16422 

              date                  1st  2nd   3rd 
          3  02/02/87  064  0      6      4 
              02/09/87  502  5      0       2
              02/16/87  615  6    1       5
              02/23/87  099  0    9       9
          7  02/01/88  961  9     6        1
              02/08/88  448  4     4       8
              02/15/88  412  4    1       2
              02/22/88  290  2    9        0
              02/29/88  569  5    6        9
          9  02/06/89  784  7    8      4
              02/13/89  378  3    7      8


          column M to V  =COUNTIF($E3:$G7,M$2) 
          column BB to BG =COUNTIF($W3:$W7,BB$2) 
          column BI to BN =COUNTIF($Z3:$Z7,BI$2)
          column BP to CA =COUNTIF($AC3:$AC7,BP$2)
          column CC to CT =COUNTIF(AI3:AI7,"x")

          the countif range is row 3 to 7 but the monthly range is 3 to 6
          so we must change the countif range row 3 to 6,

          and if there a modified cell range then we must modified all function

          so far solve with manually:
          select column M to V and with replace command change 7 with 6 and
          go to colum BB to CT and with replace command change 7 with 6 and

          repeat for the next row.

          is there any step to reduce the manually change?

          regards
          sysp34


            retxx's avatar - mrthumbs
            BOSTON
            United States
            Member #48
            September 9, 2001
            3582 Posts
            Offline
            Posted: February 6, 2006, 12:47 pm - IP Logged

            tell me how to get the next draw to play after i went to sun 2006 screen and deleted all your dates and pick 4 numbers and replaced with jan 1 to current numbers in my state. No other screens updated the change to reflect my changes. i guess it needs macros to do this. correct? Can someone help with what i did/ thanks

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3582 Posts
              Offline
              Posted: February 6, 2006, 12:49 pm - IP Logged

              P.S. i can e-mail my screen that I changed to see if anyone can make corrections to adjust the other screens.

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

                Dear Pick 4 Hobbiest

                just sharing xl sheet use last 95 draw (with 5 draw interval),

                xls format 840 kb : http://www7.rapidupload.com/d.php?file=dl&filepath=10173
                zip format 197 kb : http://www.rapidupload.com/d.php?file=dl&filepath=9766

                use last 95 draw for consecutive day and or

                last 95 draw weekly
                eg: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
                     1st week, 2nd week, 3rd week, 4th week
                     1,2,3,...31

                for those drawing files find the highest

                * Repeat Numbers : more than 80%

                * Low Odd, High Odd, Low Even, High Even Tendency
                     13 more than 30 %
                     579 more than 30 %
                     024 more than 30 %
                     68 more than 30 %

                the tendency high low and even odd, low odd, low even, high odd, high even, i hope similiar with monthly range.

                regards
                sysp34

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

                  dear 4d hobbiest

                  just sharing another spreadsheet

                  zip files 346kb : http://www10.rapidupload.com/d.php?file=dl&filepath=18081

                  just copy and paste last 100 draws and combine with pro filter pick3 and good luck

                  regards
                  sysp34

                   

                    SirMetro's avatar - center
                    East of Atlanta
                    United States
                    Member #6191
                    August 11, 2004
                    1389 Posts
                    Offline
                    Posted: February 11, 2006, 11:00 am - IP Logged

                    If I read what I think is the simplest request, the solution is ruther simple.

                    column M to V  =COUNTIF($E3:$G7,M$2) 
                    the countif range is row 3 to 7 but the monthly range is 3 to 6
                    so we must change the countif range row 3 to 6
                    ,

                    If the objective is to retain the original formula, all one would have to do is keep that formula on a second sheet. Then simply copy and paste it back to the main work sheet. And yes, one could write a macro to do the same as well.

                     On a side note, it appears some of the functions are similiar to features that can be found here at LotteryPost if you sign up for the Premium service (well worth it if you play a lot).

                    Good Luck,

                    Sir Metro