Lottaloot system set-up

Reply #35

ADB-23 — Wed, 22 Jun 2005 22:54:24 GMT

i got it to work thank for all your help

Reply #34

lottaloot — Wed, 22 Jun 2005 22:46:14 GMT

Does the spreadsheet help

Reply #33

ADB-23 — Wed, 22 Jun 2005 22:28:38 GMT

ok thanks but W column still 0

Reply #32

lottaloot — Wed, 22 Jun 2005 22:25:21 GMT

Thanks go to SirMetro for the statement that I say next.He has set up a spreadsheet to send out to anyone that would like a copy of the spreadshee. Just pm me with your email address and I will send it to you now. He tweaked it a bit so that it includes the H/L O/E pairs as well as a conversion of the draw result into a box result. The gate is now open

Reply #31

lottaloot — Wed, 22 Jun 2005 22:15:35 GMT

This is what goes in S3 thru S47483828077923450829044668053503784767572712263716360901695889595606241539341913180249141725 See if that clears up what appears in Column W

Reply #30

lottaloot — Wed, 22 Jun 2005 22:11:21 GMT

Thanks for coming to my rescue SirMetro (he taught me everything I know about excel )You schooled me well but I still can't speak excel the way you do.

Reply #29

SirMetro — Wed, 22 Jun 2005 22:00:02 GMT

And for those dealing with numbers that start with a zero such as 001, make sure you enter it as '001or simply put, Excel will read it and reflect it as 1 and the formulas will fail.And for those who want to point out the redundancies, my response is, yes, there are reduncies and they are there for a reason. Porting in the data and then separating it out to my liking wasn't easy. And like a previous email, we do not offer a magic bullet . We don't even claim you will make anything usuable from... [ More ]

Reply #28

SirMetro — Wed, 22 Jun 2005 21:50:35 GMT

I will look on Microsoft later, but Microsoft has a file viewer that will allow you to receive an Excel spreadsheet and look at it on your computer. Not much more then that, but it is functional. Also, I recall an inexpensive (use to be free) spreadsheet/office program package and will post data about it as well. I recognize Excel is not a cheap program. The cool feature is, most of what is done in excel can be ported to other spreadsheets and maybe something simple (and inexpensive) can be fou... [ More ]

Reply #27

lottaloot — Wed, 22 Jun 2005 21:43:21 GMT

I forgot to tell you that whenever you use a 037 or 0XX for a draw result, you must put a ( ' ) before it or it won't work. And the pairs should automatically insert into the columns where theabacbabccacbare. All pairs go into the S3 thru S47 section. These are the pairs that you are tracking. I will explain after taking my child to pom practice.be back in 30 min

Reply #26

sue34 — Wed, 22 Jun 2005 21:42:59 GMT

Thanks! Much appreciated

Reply #25

lottaloot — Wed, 22 Jun 2005 21:38:20 GMT

I am still going to be doing the 8 states, SueI like it!I just can't break this down into multiple states had hoped that those who had only wanted their state would benefit from it

Reply #24

lottaloot — Wed, 22 Jun 2005 21:35:39 GMT

Just so that we are clear--you know that I did not add a vtrac section in this spreadsheet. One can be added. (SirMetro) provided me with this ability but I did not like it. But I can post the vtrac formulas if you want. In response to the 40.oo a month for 2 straight hit a month (don't waste your money--I did it was not good--Too many combinations) To answer the question- I post mine draw results in with the latest result on top (Just a habit now) but for those who don't know much about ex... [ More ]

Reply #23

LAVERNE MALONEY — Wed, 22 Jun 2005 21:33:11 GMT

I had set up the doubles past history in that manner. But now as of today when I decide to make daily plays I will enter them in the manner stated above using all 90 doubles.

Reply #22

ADB-23 — Wed, 22 Jun 2005 21:27:40 GMT

Q'S LOTTALOOT'S HOW DO I GET A NUMBER LIKE 086 OR 037 TO WORK ? ALSO DO I PUT THE PAIRS FOR THE abacbabccacbCOLUMNS IN S3--S47 OR IS THERE SOMETHING ELSE.LASTLY COLUMN W ALL I HAVE IS 0 FROM 2--11 WHAT AM I DOING WRONG

Reply #21

sue34 — Wed, 22 Jun 2005 21:25:57 GMT

All this excel/spreadsheet info is great if one understands how to work with a spreadsheet or has excel. For those of us who are Dummies , we are missing out on some very useful info. Lottoloot, I have been following the numbers you have provided for the 8 states and its very impressive, especially with the doubles. I had hoped you would continue doing the 8 states. This may force me into learning about spreadsheets. Anyhow, thanks for all the info.Sue

Reply #20

maine23 — Wed, 22 Jun 2005 21:17:09 GMT

Thanks lottaloot...For this system...I must say its one of the best Ive seen...been wanting to learn vtracs for a long while now...I went to a website talking about vtracs and for 40 dollars a month they will give you at least 2 strait hits a month...Sounded real good for a minute but i waited and hoped some one would talk about it..And presto your here...Thanks for sharing the information....1 more ?For example say if you were playing this months numbers...You would start from the 1 of June til... [ More ]

Reply #19

lottaloot — Wed, 22 Jun 2005 21:12:27 GMT

I remember the doubles history that you sent me in the past had the roots in ( )'sIs this what you are speaking of? I can then set my spreadsheet up the same way if I wanted.

Reply #18

lottaloot — Wed, 22 Jun 2005 21:08:19 GMT

This was just an example. I usually go back to 1st day of the month --but I fiddle with it on off.You have to choose how far you would like to go back.

Reply #17

lottaloot — Wed, 22 Jun 2005 21:05:04 GMT

What is it saying?Click on whereever you placed the formulaThen look at the top in the formula bar(probably what it is called) and click inside the ( )What area lights up in the blue or highlighted box? It should be the sections that have thisabacbabccacbor the H thru M columns where the pairs are. Let me know what happens

Reply #16

LAVERNE MALONEY — Wed, 22 Jun 2005 21:04:36 GMT

Very very simple. I put the doubles in groups according to root sums, then just put the dates next to them as they have appeared. I can see which doubles have played the most this month so far, along with the roots that are most popular of course which ones are not this time around with doubles. It also shows me what doubles are just on hold like, (669 RSum-3), (588 RSum-3), (255 RSum-3), etc. I didnot put this info on my compter, it's all on big yellow legal paper.

Reply #15

maine23 — Wed, 22 Jun 2005 21:04:13 GMT

How many days we go back???By looking at your MI example chart... it looks like you would go back 11 days is that right??? or do we go back more....

Reply #14

mybolade — Wed, 22 Jun 2005 20:57:26 GMT

Thanks Lottoloot, I appreciate you sharing your worksheet. I ran into a problem:The countif formulas that you have in Column R are not working for me. Have I done something wrong. The other formulas are working fine.Bolade

Reply #13

lottaloot — Wed, 22 Jun 2005 20:39:39 GMT

Do share ole Doubles Queen...do share

Reply #12

LAVERNE MALONEY — Wed, 22 Jun 2005 20:11:14 GMT

WOW lottaloot, just by looking at the formulas, the output that you have generated you have just allowed me to open a new chamber for my states dates arrangement. Now I can clearly see why in your previous posts that 33 55 were due doubles pairs. And they still are... there is nothing like a fresh new perspective for an old theme. Thanks

Reply #11

Shawnintennesse — Wed, 22 Jun 2005 19:40:28 GMT

Thank you...Your really apperciated..:)This should help a whole bunch...

Reply #10

undress — Wed, 22 Jun 2005 19:40:12 GMT

Thanks Lottaloot

Reply #9

lottaloot — Wed, 22 Jun 2005 19:11:20 GMT

This will give you an idea of what it will end up looking like. Not up to date of courseBut looking at it, you can see that 27 would be the most freq pairThe pairs with 0 beside them are due pairs, etc.

Reply #8

lottaloot — Wed, 22 Jun 2005 19:06:22 GMT

Here's an example of my MI spreadsheetDateEve Drawabc abacbabccacb rootSum DoublesPairs DatasinglesPairs Data06/17/05192192 191291922129 312 **CntMCnt06/16/05597597 595795977579 321 77027406/15/05125125 121521255152 88 88029306/14/05538538 535835388583 716 00039306/13/05584584 585485844548 817 66015306/12/05574574 575475744547 716 55102206/11/05457457 454754577475 716 99079206/10/05635635 636536355653 514 33126206/09/05999999 99 927 11209206/08/05200200 2... [ More ]

Reply #7

lottaloot — Wed, 22 Jun 2005 18:59:06 GMT

Dorothy A.K.A (lottery lady) wants to know how to do the system.Perhaps I am not communicating like I should and would appreciate anyone who would like to say it in an understandable way.In order to do this system1. You have to set up a spreadsheet in excel exactly as I have posted above2. Insert either separated or combined draw results into the draw section. 3. The sheet should do the rest--If not you need to copy down your formulas4. Look at the key numbers section and find the numbers that h... [ More ]

Reply #6

lottaloot — Wed, 22 Jun 2005 18:50:38 GMT

Yes

Reply #5

Shawnintennesse — Wed, 22 Jun 2005 18:32:41 GMT

Lottaloot,Is this for Excel

Reply #4

Atomic Dog — Wed, 22 Jun 2005 18:32:15 GMT

THANKS LOTTO!!!I appreciate the efforts that you put forth! You should be commended for work and thanked by all for a job well done! Good Luck,John (a.k.a. Atomic Dog

Reply #3

lottaloot — Wed, 22 Jun 2005 18:28:31 GMT

The formulas are already there. All you have to do is copy paste. You must include the (=) as well when you copy. Copy paste. If you have any questions, post it here I will be happy to address.I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one. I will not do that. But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would. SirMetro says that I can use the web spa... [ More ]

Reply #2

retxx — Wed, 22 Jun 2005 17:40:30 GMT

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

Reply #1

SirMetro — Wed, 22 Jun 2005 17:09:25 GMT

Credit for the origination of formulas I was involved in goes to all the great contributors here at LotteryPost. For without their insight, thoughts and ideas, I would have had no clue where to begin. And to Todd for providing a place where bums like myself can actually get a bit educated. I have even been able to utilize some of the programing ideas to enhance some of the work related projects I am doing.Sir MetroBTW...did I ever mention my real job sorta kinda requires me to show the US Govern... [ More ]

Lottaloot system set-up

lottaloot — Wed, 22 Jun 2005 16:35:11 GMT

I have decided to share my system since there are so many people requesting their state be done. Now you can do your own. If you can tweak this, please do so let us all know. Also, if you can share numbers within the forum that you obtain from this-Please do so. To set up in excel B1(DATE) C1 (DRAW) D1 (a) E1(b) F1(c)Column G has been made to become width .17 Add to Column H1 thru M1 ( ab, ac, ba, bc, ca, cb )O1(root)P1(sum)Q1(Doubles)R1(pairs)S1(Singles or whatever you wish to call other