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

Sun - Moon Excel Chart

Topic closed. 45 replies. Last post 11 years ago by Rip Snorter.

Page 3 of 4
PrintE-mailLink
retxx's avatar - mrthumbs
BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
Posted: September 2, 2005, 11:38 am - IP Logged

bingo dave date is all set thanks. next question. how can I transpose your numbers for mine in mass. do I have to do it manually? It would take 2 years to do it that way.Help

    Avatar
    New Mexico
    United States
    Member #12305
    March 10, 2005
    2984 Posts
    Offline
    Posted: September 2, 2005, 12:01 pm - IP Logged

    retxx:

    I hope there's an easy answer to that.  If you're looking only at specific lotteries the answer will probably be different than if you're just attempting to understand what numbers are likely to be coming down the pike on a given day.

    I'm just flipping over to empty sheets to use them as scratchpads, then highlighting the column, using the 'find' function to go through it year by year to the current phase, then copying and pasting.

    It's awfully time consuming, but I suspect it's the best a person can do if he's trying to get a general notion what numbers tend to hit during a specific phase, irregardless of the lottery.

    Here's what's current in text format, as far as I've gotten:

                                             
                                             
                                             
                                             
                                             
                                             
                                             
                                             
     VIR - CAN W 3RD      395 
     VIR - CAN TU 3RD      202 
     VIR - CAN TU 3RD      529 
     VIR - CAN SA 3RD      051 
     VIR - CAN F 3RD      498  6541
     VIR - CAN SA 3RD      732 
     VIR - CAN TH 3RD      105  2985
     VIR - LEO F 3RD      835  9637
     VIR - CAN TU 3RD      836  6437
     VIR - CAN W 3RD      163  8095
     VIR - CAN M 3RD      134  2995
     VIR - CAN TU 3RD      844  1560
     VIR - CAN F 3RD      698  5112
     VIR - CAN SA 3RD      592 
     VIR - CAN TU 3RD      706  9674
     VIR - CAN W 3RD      125  0399
     VIR - CAN TH 3RD      811  6461
     VIR - CAN M 3RD      407  6905
     VIR - CAN TU 3RD      837  1767
     VIR - LEO W 3RD      126  5901
     VIR - CAN F 3RD      170  8444
     VIR - CAN SA 3RD      738  1073
     VIR - CAN F 3RD      162  8184
     VIR - CAN SA 3RD      720  4018
     VIR - CAN W 3RD      135  1234
     VIR - CAN TH 3RD      806  4589


     VIR - VIR M 3RD      438 
     VIR - VIR TU NM      210 

     VIR - CAN TH 3RD      549 
     VIR - LEO F 3RD      012 
     VIR - LEO SA 3RD      440 

     VIR - CAN TU 3RD      202 
     VIR - LEO W 3RD      009 
     VIR - LEO TH 3RD      722  9998

     VIR - CAN TU 3RD      529 
     VIR - LEO W 3RD      817   

     VIR - LEO M 3RD      332   
     VIR - LEO TU 3RD      501  2729 

     VIR - CAN SA 3RD      732   
     VIR - LEO SU 3RD  X  X  X  X 
     VIR - LEO M 3RD      081  5342 

     VIR - CAN TH 3RD      105  2985 
     VIR - LEO F 3RD      835  9637 
     VIR - LEO SA 3RD      439   

     VIR - CAN W 3RD      163  8095 
     VIR - LEO TH 3RD      175  7002 
     VIR - LEO F 3RD      207  3122 
     VIR - LEO SA 3RD      483   

     VIR - CAN TU 3RD      844  1560 
     VIR - LEO W 3RD      932   
     VIR - LEO TH 3RD      875  0180 

     VIR - CAN SU 3RD  X  X  X  X 
     VIR - LEO M 3RD      712  6134 
     VIR - LEO TU 3RD      324  0127 

     VIR - CAN TH 3RD      811  6461 
     VIR - LEO F 3RD      389  5559 
     VIR - LEO SA 3RD      302  8051 

     VIR - CAN TU 3RD      837  1767 
     VIR - LEO W 3RD      126  5901 
     VIR - LEO TH 3RD      536  6136             

     VIR - CAN F 3RD      170  8444             
     VIR - CAN SA 3RD      738  1073             
     VIR - CAN SU 3RD  X  X  X  X             
     VIR - LEO M 3RD      765  2654             
     VIR - LEO TU 3RD      514  8913             
     Sep-90                       
     VIR - CAN W 3RD      135  1234             
     VIR - CAN TH 3RD      806  4589             
     VIR - LEO F 3RD      063  6239             
     VIR - LEO SA 3RD      256  0154             

     VIR - CAN TU 3RD      896  2885             
     VIR - CAN W 3RD      067  0241        7 18 22 33 34 35
     VIR - LEO TH 3RD      870  9345             
     VIR - LEO F 3RD      918  9462             

     VIR - CAN M 3RD      798  5661             
     VIR - LEO TU 3RD      687  6909  3 5 16 23 30       
     VIR - LEO W 3RD      068  7493        9 10 16 20 36 43 

    9/21/92 VIR - CAN M 3RD      955  9755             
    9/22/92 VIR - LEO TU 3RD      839  8658  1 13 19 20 35       
    9/23/92 LIB - LEO W 3RD      964  1081        3 22 26 33 37 45 

    9/11/93 VIR - CAN SA 3RD      985  8228        7 9 12 41 43 45 
    9/12/93 VIR - LEO SU 3RD  X  X  X  X  X X X X X  X X X X X X X
    9/13/93 VIR - LEO M 3RD      088  8860  5 16 22 28 34       

    9/1/94 VIR - CAN TH 3RD      742  7157  1 2 6 17 19       
    9/2/94 VIR - LEO F 3RD      589  9258  13 22 23 26 37       
    9/3/94 VIR - LEO SA 3RD      433  4702        23 24 29 31 38 43

    8/22/95 LEO - CAN TU 3RD      492  8409  9 20 25 26 36       
    8/23/95 LEO - LEO W 3RD      739  9036        6 7 14 24 25 37
    8/24/95 VIR - LEO TH 3RD      812  5068  6 11 15 25 37       

    9/18/95 VIR - CAN M 3RD      511  3703  12 17 24 27 30       
    9/19/95 VIR - LEO TU 3RD      468  6910  8 18 19 21 37       
    9/20/95 VIR - LEO W 3RD      761  9829        10 11 13 14 30 40

    9/7/96 VIR - CAN SA 3RD      780  0333        5 13 23 25 41 47
    9/8/96 VIR - LEO SU 3RD  X  X  X  X  X X X X X  X X X X X X
    9/9/96 VIR - LEO M 3RD      636  2779  6 16 23 28 32       
    9/10/96 VIR - LEO TU 3RD      752  9445  2 7 20 32 34       

    8/28/97 VIR - CAN TH 3RD      562  4492  2 3 10 25 37       
    8/29/97 VIR - LEO F 3RD      309  4737  13 15 20 24 37       
    8/30/97 VIR - LEO SA 3RD      957  7642        4 5 27 40 43 44 
    8/31/97 VIR - LEO SU 3RD  X  X  X  X  X X X X X  X X X X X X 

    9/15/98 VIR - CAN TU 3RD      721  3784  11 13 15 18 25       
    9/16/98 VIR - LEO W 3RD      757  8376        5 12 14 22 24 32 
    9/17/98 VIR - LEO TH 3RD      399  4712  4 6 11 12 22       

    9/4/99 VIR - CAN SA 3RD  955  5458  257  5998        8 11 22 37 40 47 
    9/5/99 VIR - CAN SU 3RD  X  X  X  X  X X X X X  X X X X X X 
    9/6/99 VIR - LEO M 3RD  471  9845  120  3255  7 15 20 21 24       
    9/7/99 VIR - LEO TU 3RD  407  5723  795  6486  9 13 18 20 26       

    8/25/00 VIR - CAN F 3RD  376  3743  913  0993  1 27 29 32 35       
    8/26/00 VIR - LEO SA 3RD  612  9574  310  9909        6 12 26 34 48 49 16
    8/27/00 VIR - LEO SU 3RD  X  X  X  X  X X X X X  X X X X X X X

    9/11/01 VIR - CAN TU 3RD  304  3058  327  0846  3 12 22 23 29       
    9/12/01 VIR - CAN W 3RD  848  2538  732  4745        14 21 29 30 45 47 11
    9/13/01 VIR - LEO TH 3RD  767  9264  585  9071  1 12 16 18 19       
    9/14/01 VIR - LEO F 3RD  012  1643  132  0909  20 25 29 30 35       

    9/2/02 VIR - CAN M 3RD  170  3081  110  6814  3 10 13 29 37       
    9/3/02 VIR - CAN TU 3RD  870  5932  705  8053  3 18 23 26 35       
    9/4/02 VIR - LEO W 3RD  040  5044  122  7640  16 18 26 29 36  1 10 20 24 38 45 21
    9/5/02 VIR - LEO TH 3RD  713  5617  186  7598  2 14 17 27 36       
    9/6/02 VIR - VIR  F 3RD  202  0371  322  2361  12 14 20 30 34       
    8/26/2003             8 12 22 30 41 44 32     
    8/27/2003             24 31 36 42 46 32       
    8/26/2003             9 28 42 44 49 47       
    8/23/2003             1 39 46 50 51 7       
    8/25/03 VIR - LEO M 3RD  410  8480  992  7167             
    8/26/03 VIR - LEO TU 3RD  118  4961  678  4224                             
    9/24/2003             17 19 20 28 47 37                       
    9/23/2003             11 12 22 30 33                       
    9/23/2003             5 16 24 49 51 28                       
    9/20/2003             11 13 28 31 33 29                       
    9/24/2003             10 14 18 30 33 55 54                     
                                             
    9/19/2003             13 14 24 34 47 13                       
    9/19/03 VIR - CAN F 3RD  805  5410  892  6385                             
    9/20/03 VIR - CAN SA 3RD  386  0558  797  5027  4 18 29 32 40 45 9                     
    9/21/03 VIR - LEO SU 3RD  X  X  X  X  X X X X X  X X X X X X X               
    9/22/03 VIR - LEO M 3RD  708  5295  442  5638                             

    9/7/04 VIR - CAN TU 3RD  916  7479  414  8744                             
    9/8/04 VIR - CAN W 3RD  239  9357  562  1167  4 6 7 27 47 49 5                     
    9/9/04 VIR - CAN TH 3RD  305  4283  708  1160  1 3 10 47 48 27                       
    9/10/04 VIR - LEO F 3RD  746  4288  884  4772  16 17 21 33 41 6                       
    9/11/04 VIR - LEO SA 3RD  906  1460  186  5060  5 15 22 28 29 45 12                     
    9/11/2004             25 34 36 46 49 9                       
    9/10/2004             11 17 27 45 52 5                       
    9/11/04             11 15 17 22 33 18                       

    If someone can tell me an easier way of doing this I'd definitely like to hear it.

    Gracias to all,

    Jack

     

     

    Absorb the good, ignore the bad, weigh the ugly.

    It's about number behavior.

    Egos don't count.

     

    Dedicated to the memory of Big Loooser

     

      libra's avatar - chi
      Cleveland , Ohio
      United States
      Member #961
      December 27, 2002
      43715 Posts
      Offline
      Posted: September 2, 2005, 12:49 pm - IP Logged

      Retxx

      If you already have the numbers on a excel chart you  can copy and paste. If Not you got to do it the hard way. It took me 2 Months and I'm still not done.

      Libra Dave 

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

        where Mass. only has an evening draw i guess all I would do is use the pick 3 eve column and delete those numbers allready in there as they are for Ohio I believe and then replace manually all those numbers with mass. pick 3. If this is correct then I need to know how to highlight the sun moon combos and go to set print and print it out. need help with this one thanks

          libra's avatar - chi
          Cleveland , Ohio
          United States
          Member #961
          December 27, 2002
          43715 Posts
          Offline
          Posted: September 3, 2005, 12:34 am - IP Logged

          Hi Retxx

          Yes you can delete all the Ohio numbers and put in the Mass pick-3 , just match up the dates.

          To use the chart You first Highlight all the columns that have data in them .Then go to the top of the page to Data and click on it .A box will open with sort in it .Click on sort.Another box will open.Right above options in this box you will see  Header Row        No Header row. Click  Header row , then go up to SORT BY  the box will say  Date  Click on the Blue down arrow. You will see a list , click on Sun- Moon. Then click ok at the bottom of the box. You will now have all the Sun - moon signs sorted into their own groups. Find the Group you want to work with, highlight all the data in that group. Then go to FILE  then down to Print Set Click on it then on Set print area.Then Print out you Sun - Moon Group. Be Sure to unset print set before sorting the chart back to Dates.

          Good Luck Libra Dave  Big Smile

            Avatar
            Detroit
            United States
            Member #8594
            November 11, 2004
            125 Posts
            Offline
            Posted: September 11, 2005, 8:22 pm - IP Logged

            Hello Dave, when you pull your numbers from the sun moon chart do you combine the midday and evening or look at them seperate?

            Alice 

              Avatar
              Detroit
              United States
              Member #8594
              November 11, 2004
              125 Posts
              Offline
              Posted: September 11, 2005, 8:44 pm - IP Logged

              Dave, for 9/12, am I looking for VIR- CAP?   

              Alice             

                libra's avatar - chi
                Cleveland , Ohio
                United States
                Member #961
                December 27, 2002
                43715 Posts
                Offline
                Posted: September 11, 2005, 9:01 pm - IP Logged

                Alice

                Yes for 9/12/05 you would be looking at VIR - CAP. I look at the numbers 6 ways. Separate , Merged Midday and Evening , Converted to Vtrac separate,and merged vtrac Midday and Evening. I also look at all the Sun - Moon signs for the Week , as some numbers move from Sign to sign , or drift backwards. You have VIR - AQU  and VIR - PIS. this week. Everyone looks at charts differently, and see s different things. So if you see something let me know. You may also see a steady increase by one digit. Like 078 , 718  , 872  etc.

                Good Luck Libra Dave  Big Smile

                  Avatar
                  Detroit
                  United States
                  Member #8594
                  November 11, 2004
                  125 Posts
                  Offline
                  Posted: September 11, 2005, 9:49 pm - IP Logged

                  Thanks Dave, I,m still chewing on it. Your system is really amazing!!

                    Avatar
                    New Mexico
                    United States
                    Member #12305
                    March 10, 2005
                    2984 Posts
                    Offline
                    Posted: September 14, 2005, 8:44 am - IP Logged

                    Hi Dave:

                    I've been fooling around with your chart for pick 6 draws.... preliminary results suggest there's a moon phase correlation between the high numbers and the related number combinations for each draw and the moon phase of the same combinations in past draws.  It's cumbersome to figure, so haven't back tested it, but at least for the MM draw last night there was enough to justify back testing it.  Which I probably won't do, but will rather just follow it along draw to draw to test it without investing in it until there's a track record.

                    The results are on my blog entry.

                    Thanks again for the labor and endurance you invested in making this chart, and for the gift you made of it.

                    Jack

                     

                    Absorb the good, ignore the bad, weigh the ugly.

                    It's about number behavior.

                    Egos don't count.

                     

                    Dedicated to the memory of Big Loooser

                     

                      libra's avatar - chi
                      Cleveland , Ohio
                      United States
                      Member #961
                      December 27, 2002
                      43715 Posts
                      Offline
                      Posted: September 14, 2005, 1:01 pm - IP Logged

                      Jack  You have the right idea. The chart was meant as a tool , it is not a system. It can be a bit overwelming with all the numbers. You can copy this chart and delete whatever numbers you are not interested in and rename it. It's a lot easyer on your eyes then. You can also sort by Day or Moon phase. So you can see what does hit on a Full Moon etc.

                      Good Luck Libra Dave  Big Smile

                        Avatar
                        New Mexico
                        United States
                        Member #12305
                        March 10, 2005
                        2984 Posts
                        Offline
                        Posted: September 14, 2005, 3:10 pm - IP Logged

                        Thanks Dave:

                        I jiggled things around a bit and posted 33 unique numbers that show for tonight.  The result for last night with roughly the same number of unique numbers was 4-1. 

                        One of the tricks I've found helpful for getting the moon phases for particular draw dates going back so far is converting the left several columns to text to allow faster scrolling.  This old machine of mine gets cranky trying to maneuver inside the Excel file.  So I identify the specific draws on Exel, but do my moon-phase IDs on the text file, then convert them back to Excel.  Speeds things up considerably.

                        Gracias,

                        Jack

                        Absorb the good, ignore the bad, weigh the ugly.

                        It's about number behavior.

                        Egos don't count.

                         

                        Dedicated to the memory of Big Loooser

                         

                          Avatar
                          New Mexico
                          United States
                          Member #12305
                          March 10, 2005
                          2984 Posts
                          Offline
                          Posted: September 15, 2005, 8:39 am - IP Logged

                          The moon-phase/high numbers test for last night were posted yesterday afternoon.  Out of a pool of 33 unique numbers the result was 3-1 for the draw. 

                          That result wasn't so compelling as the 4-1 from the MM draw the previous night, but it's still not too bad.  Especially considering the number of 0-0s on the MM challenge, (15 numbers for WB, 5 RB), and the best efforts giving 2-1 (one challenger), and several 2-0s. 

                          The workup for this is relatively simple and assumes a mechanical behavior from the numbers across the board for all lotteries.  The high number combinations are drawn from several different lotteries, including NY, Illinois, PB, MM and others where those combinations have hit during the moon phase of the draw of interest. 

                          The fact it works at all suggests there might be enough validity to a theory of correlation to be worthy of further examination.  If the numbers are coming down in some protracted pattern, following enough of a set of 'rules', it might be just a matter of a lot closer examination to find those behaviors don't include as much 'slop' as we like to imagine.

                          Jack 

                          Absorb the good, ignore the bad, weigh the ugly.

                          It's about number behavior.

                          Egos don't count.

                           

                          Dedicated to the memory of Big Loooser

                           

                            Avatar
                            New Mexico
                            United States
                            Member #12305
                            March 10, 2005
                            2984 Posts
                            Offline
                            Posted: September 18, 2005, 4:59 pm - IP Logged

                            Libra dave:

                            I'm a bit confused.  Evidently you're using different nomenclature for moon phases than I'm accustomed to.  Maybe your are related to positioning other than simply the appearance of the moon disc.  I'd have called these the first and second nights of the full moon.

                            Here's the moon September 16-17:

                            http://www.lotterypost.com/blogcomments.asp?i=3991

                            here's this morning, September 17-18, before dawn:

                            http://blogs.lotterypost.com/rip_snorter/2005/9/those-pb-numbers-last-night.htm

                            CHART:

                            9/16/05 VIR - PIS F 1ST
                            9/17/05 VIR - PIS SA 1ST
                            9/18/05 VIR - ARI SU FM

                            The moon will be waning after last night, but will show on the chart as full for several days.

                            Hope you'll clear up for me what I'm seeing, as opposed to what the chart's calling it.

                            Thanks,

                            Jack

                            Absorb the good, ignore the bad, weigh the ugly.

                            It's about number behavior.

                            Egos don't count.

                             

                            Dedicated to the memory of Big Loooser

                             

                              libra's avatar - chi
                              Cleveland , Ohio
                              United States
                              Member #961
                              December 27, 2002
                              43715 Posts
                              Offline
                              Posted: September 18, 2005, 5:35 pm - IP Logged

                              Hi Jack

                              I'm going by what's in the ephemeris. The Lunation Cycle lasts for 29 and 1/2 days. It is divided into 4 parts or Quarters.So the 2nd Ouarter is when the full moon starts. Most Calenders go by 1st Quarter , Full Moon , 3rd Quarter or Last Quarter. then New Moon. Hope this clears it up for you.

                              Libra Dave