See what this will do for the testing. I hope it's ok I made it???
I tested with it for here in NC but just for the month of July 2013, and it had two box wins just by viewing them as the numbers being what they where. Mirroring had quite a few more, and there was quite a few hits. I hadn't had time to really do a lot of games with it. Pretty much just winding it up.
It's set up with a full months worth of draws in it. Column A is the dates. Yellow (sun) cells for day draws. Purple (moon) cells for the evening draws.
Put your draws in B thru D to fill it in. F is where you can put the phase at according to the date in A. Pick 4 draws can be put in H thru K.
N thru AB will give you your calculations for each phase every time the new draws are put in.
AD thru AM will show you what numbers show up in all the sets of phases the most. AD is for 0, AE is for 1 and so on thru AM for 9.
Your stats will be in AO thru AW. It will tell you how many times each position in each phase was in the next drawing. It will tell you how many hits you had total for each phase by position and how many hits in total. (The hits by position, doesn't mean that the first pick was exactly for the first number, it just means that that first pick of the calculation showed up in the next drawing). How many straight wins it showed per phase. How many any other kind of wins it showed per phase. (It counts all wins together, but has a seperate cell for straight wins.) (So if it shows 8 wins for full moon and 2 straight wins for full moon, there was 6 boxed, combo or whatever and 2 straight wins in total.) How many balls drawn and how many games that has been drawn. It also shows how many doubles and triples where drawn. And there are some percentages that will pop up also when you start filling it in.
Anyone could make a book copy and test month by month or make sheet copies inside the book and just rename each sheet for each month. I didn't put the phase in it, but there is a column for that that is unlocked. You'll just have to find that on here and put it in for whatever month you are testing/using. (If one wanted to).
https://www.dropbox.com/s/c3o16fi6s73z7g7/Pick%203%20Moon%20Phases.xlsm
Best of luck to all today and be safe!!!!
(P.S. I didn't put any stats for the 4 draw, because the data isn't all there, but you can see it visually easy. It will also highlight what numbers in the draw showed up in the calculations for the pick 3 so you can get a better view of what is/was going on. If you just entered the 5th day draw, where you will look for what showed up in the 5th day draw off to the right from the calculations of the 4th eve draw.) After you put in the first draw, it will give you the calculations off to the right in the same row. Once you put in the next draw, it will highlight what showed up from that draw in the calculations on the previous row. After you fill in the first two games, you'll see what I'm talking about and how it works easily.