Sun - Moon Excel Chart

Reply #45

Rip Snorter — Sun, 18 Sep 2005 21:57:15 GMT

Thanks Dave. I'm not sure it clears up my fuzzy headedness on the issue, but I'll work with it.Gracias.Jack

Reply #44

libra — Sun, 18 Sep 2005 21:35:36 GMT

Hi JackI'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

Reply #43

Rip Snorter — Sun, 18 Sep 2005 20:59:34 GMT

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:https://www.lotterypost.com/blogcomments.asp?i=3991here's this morning, September 17-18, before dawn:https://blogs.lotterypost.com/rip_snorter/2005/9/those-pb-numbers-last-night.htmCHART:9/16... [ More ]

Reply #42

Rip Snorter — Thu, 15 Sep 2005 12:39:02 GMT

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 th... [ More ]

Reply #41

Rip Snorter — Wed, 14 Sep 2005 19:10:15 GMT

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-ph... [ More ]

Reply #40

libra — Wed, 14 Sep 2005 17:01:47 GMT

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

Reply #39

Rip Snorter — Wed, 14 Sep 2005 12:44:01 GMT

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 withou... [ More ]

Reply #38

Jiggles — Mon, 12 Sep 2005 01:49:35 GMT

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

Reply #37

libra — Mon, 12 Sep 2005 01:01:27 GMT

AliceYes 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 dig... [ More ]

Reply #36

Jiggles — Mon, 12 Sep 2005 00:44:23 GMT

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

Reply #35

Jiggles — Mon, 12 Sep 2005 00:22:40 GMT

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

Reply #34

libra — Sat, 03 Sep 2005 04:34:48 GMT

Hi RetxxYes 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 ,... [ More ]

Reply #33

retxx — Sat, 03 Sep 2005 02:49:49 GMT

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

Reply #32

libra — Fri, 02 Sep 2005 16:49:33 GMT

RetxxIf 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

Reply #31

Rip Snorter — Fri, 02 Sep 2005 16:01:47 GMT

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 p... [ More ]

Reply #30

retxx — Fri, 02 Sep 2005 15:38:10 GMT

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

Reply #29

libra — Fri, 02 Sep 2005 04:08:38 GMT

RetxxClick on the Date Column to highlight it. Then go to the top of the page and click on format. When the box opens click on Cells, then the number tab, then click on date The side box will show you different variations of dates , use 3/14/01 click on it, Then click ok. It should straighten it out.Libra Dave

Reply #28

retxx — Fri, 02 Sep 2005 03:04:48 GMT

dave same thing date column reads 29192.rip snorter said about formatting. can you explain further?Thanks

Reply #27

retxx — Thu, 01 Sep 2005 14:57:29 GMT

I got it dave thanks. I will let you know.

Reply #26

Rip Snorter — Thu, 01 Sep 2005 05:09:02 GMT

Ah, thanks.Jack

Reply #25

libra — Thu, 01 Sep 2005 04:54:02 GMT

Jack You can have a moon sign return in a Sun sign within a month, it happens a lot. Usually the First and last sign in the series.Libra Dave

Reply #24

CARBOB — Wed, 31 Aug 2005 16:03:05 GMT

Dave, I received your file, thanks a lot. Retxx, your problem might format. Format your date column.Carbob

Reply #23

libra — Wed, 31 Aug 2005 15:38:47 GMT

Retxx and CalifDudePlease resend emails and I will send you a zipped copy of the file. Retxx please delete the old one before opening the new one. Maybe it got scrambled somehow. Also I work 2nd shift so I'm off line after 1:PM EDT. Back on after 11:Pm.Libra Dave

Reply #22

retxx — Wed, 31 Aug 2005 15:30:49 GMT

I am running excel 2000 so can someone explain my earlier question? thanks.

Reply #21

Rip Snorter — Wed, 31 Aug 2005 15:27:05 GMT

Dave:I'm running it on EXCEL '97..... might be I don't have a lot of the features you provided, but it works well enough to be admirably usable, completely helpful, a dynamic demonstration of the amount of work you've done on it.I might yet find glitches, but all in all you've done so much already it's difficult to imagine any problems with it that the end-users can't figure out how to overcome with a bit of study and head scratching.Thanks again,Jack

Reply #20

libra — Wed, 31 Aug 2005 15:21:18 GMT

RetxxI don't know what the date problem is, could be a older version of excel. I am also finding out a lot of people don't have the check box in the data sort dropdown. I am running Excel 2003. If you don't have that, sort by the letter B. If anyone can explain this better please do.Libra Dave

Reply #19

retxx — Wed, 31 Aug 2005 15:12:50 GMT

hi dave the 29192 is under the date column. that is why i could not decipher it. Also I do not see any header to check a box off.

Reply #18

libra — Wed, 31 Aug 2005 15:03:07 GMT

CalifDudeYes the file is huge. Well over 2 1/2 MBYTE. I did send it, sorry you didn't get it. Do you have an alternet address like maybe Yahoo.Libra Dave

Reply #17

Rip Snorter — Wed, 31 Aug 2005 13:49:44 GMT

Nice number, though. Two of the six that hit last night, 29, 19.Jack

Reply #16

ADB-23 — Wed, 31 Aug 2005 13:41:49 GMT

thanks for the chart

Reply #15

Rip Snorter — Wed, 31 Aug 2005 12:38:21 GMT

Morning Dave:It was the CAN VIR twice in 2000 a month apart I was referring to, late august, late sep...Sorry I didn't explain it better.Jack

Reply #14

CalifDude — Wed, 31 Aug 2005 05:20:19 GMT

I requested, but did not receive the file. Is it over 1Mbyte? I don't think my ISP will allow attachments over that.

Reply #13

libra — Wed, 31 Aug 2005 04:43:18 GMT

Jack Just rechecked those 2000 numbers with the Ohio lottery site and they are correct.Libra Dave

Reply #12

libra — Wed, 31 Aug 2005 04:15:50 GMT

Jack Thanks for the offer, I'll get back to you on that.Libra Dave

Reply #11

libra — Wed, 31 Aug 2005 04:13:28 GMT

Hi RetxxThe 3rd is refering to the 3rd quarter of the moon phase. As for the 29192 I can't find it on the chart. What is the date before it ?Libra Dave

Reply #10

retxx — Wed, 31 Aug 2005 02:21:06 GMT

29192 date please explain this mo/d/yr. thanks

Reply #9

Rip Snorter — Wed, 31 Aug 2005 02:06:31 GMT

I don't have all the pick-5s in yet , but the chart is usable for the pick-3 and 4 and 6.You could copy and delete Ohios numbers and put in your state numbers as long as you match the dates up. Dave:I could email you all the PBMM, most of NY Lotto as far as it goes back on LP, Euro Millions and a few others all converted to Excel if it would help you. Might save a bit of time and work?I'd like to do anything I can to help in return for the gift of this chart.Jack

Reply #8

retxx — Wed, 31 Aug 2005 01:42:17 GMT

what is 3rd refering to

Reply #7

Rip Snorter — Tue, 30 Aug 2005 21:49:04 GMT

I'm wondering if the dates for 2000 might be a misprint... 8/24/00VIR - CANTH3RD 109 9187 79766938/25/00VIR - CANF3RD 376 3743 91309939/21/00VIR - CANTH3RD 474 3321 28911989/22/00VIR - CANF3RD 855 7958 0681466This is definitely going to be something to put to use. I did a workup for the MM challenge for tonight using it.Thanks again Dave,Jack

Reply #6

retxx — Tue, 30 Aug 2005 20:54:49 GMT

thanks but I need a lesson on reading the chart. could you print 1 line and define it for us.Thanks also there is no box to check about the header. especially explain the dates.

Reply #5

emilyg — Tue, 30 Aug 2005 16:48:35 GMT

it is wonderful

Reply #4

Rip Snorter — Tue, 30 Aug 2005 16:46:05 GMT

I'm looking it over now, Dave. This is a truly impressive piece of work.You're a generous person.GraciasJack

Reply #3

Demi540 — Tue, 30 Aug 2005 15:38:51 GMT

Thanks Libra Dave

Reply #2

Rip Snorter — Tue, 30 Aug 2005 15:38:09 GMT

This might be among the most helpful pieces of info I've ever seen on LP...Thanks a bunch.Jack

Reply #1

undress — Tue, 30 Aug 2005 14:54:34 GMT

Thanks Dave

Sun - Moon Excel Chart

libra — Tue, 30 Aug 2005 14:49:22 GMT

I have made a Sun - Moon Excel Chart For all of Ohio's Numbers.This shows what pick- 3 - 4 - 5 - 6 came out under what Sun - Moon sign. Sun - Moon sign come out together for 2 to 3 days a year. So this gives a different view of numbers. It starts at 12/3/1979 to the present. I don't have all the pick-5s in yet , but the chart is usable for the pick-3 and 4 and 6.You could copy and delete Ohios numbers and put in your state numbers as long as you match the dates up. It's free to whoever wants it... [ More ]