Pick3 Game Index Digits

Reply #55

boise — Fri, 16 Nov 2012 08:50:18 GMT

Cg,does this one still work the same way

Reply #54

bootleg233 — Tue, 13 Nov 2012 10:44:19 GMT

Hell the way the weather is now a days ya just never know! lol

Reply #53

CarliG — Tue, 13 Nov 2012 01:44:48 GMT

retxx, if you had read the most recent posts you would see there are others having issues with this file also .

A couple people offered possible solutions, so you could try what they suggested.. Other than that , I give up on trying to share this file.

Dont know what else to try ..

Sorry

CG

Reply #52

CarliG — Tue, 13 Nov 2012 01:42:26 GMT

Thanks bootleg ,

Considering how often it snows in South Florida , Dont think Yellow Snow will be an issue .. LOL

Carlig

Reply #51

retxx — Tue, 13 Nov 2012 01:39:52 GMT

how do I get rid of view only carli

Reply #50

bootleg233 — Tue, 13 Nov 2012 01:36:43 GMT

Best knowledge I can give you CarliG is: DONT EAT YELLOW SNOW!!.. Ok now u know this...just Thanks for all you do for EVERYONE!!!! Good Luck.

Reply #49

CarliG — Mon, 12 Nov 2012 23:54:00 GMT

Thanks Susscs

You always have such good info . Gonna give the mirror thing a try , might work when the original is in its change mode and goes cold..

I do have an 8, 12 and 20 draw set up for pick 3, But only use the 20 draw on pick 4..

Would it help If I downloaded the converter ? Would it then allow me to save in a way others can open ? Or is it more for the person doing the downloading ..

I have learned so much on these forums and we all know that knowledge is power .

So thank

Reply #48

susscs — Mon, 12 Nov 2012 18:42:53 GMT

Carli, I use Excell 2003 also but I downloaded a converter from Microsoft and use that to open any of the 2007 files, you need to install the converter program, after it is installed I just right click on file and tell it to open with XLM converter. The download is free from microsoft.

This may help some people.

Another thing a player from New York does is he puts the numbers in again but as the mirror of the number drawn, he only does Refernce boxes after the last draw on Saturday and I b... [ More ]

Reply #47

CarliG — Mon, 12 Nov 2012 16:41:17 GMT

Thanks for the info , gotta admit I never heard of kingsoft but Im going to check it out..

I dont know why I have so much trouble sharing this particular sheet . I use it all the time and its a great tool . Think maybe this was my last attempt on sharing this one.. Oh well I tried lol

Carlig

Reply #46

Wishing4awin — Mon, 12 Nov 2012 12:46:41 GMT

I am using Excel 2003. I also have Open Office and Kingsoft.

When I downloaded the file from the last link that Carlig posted. My Excel 2003 will not let me open anything with the .xlsx extension. For some reason the converted does not want to work. So I opened the file in Kingsoft and the only thing I got was a blank sheet. No numbers, just the orange highlighted area. So I went back and downloaded it again as an Open Office file and then opened it up in Open Office. It worked just fine. The... [ More ]

Reply #45

CarliG — Mon, 12 Nov 2012 05:10:17 GMT

Here is a link for Google Docs .

Hopefully this will work

https://docs.google.com/spreadsheet/ccc?key=0AtECjiU3R7TedGxELWhjLU81bWc2UHItb2FTZnpLanc

CG

Reply #44

CarliG — Mon, 12 Nov 2012 04:59:06 GMT

So what your saying is if I load the one you sent me to google docs and they down load from there it should work for example in Excel 2003 ??

Interesting. I will give it a shot.

Carlig

Reply #43

Teamprofit — Mon, 12 Nov 2012 04:55:25 GMT

Two things you can try..

1.Create a copy on google documents and download it to excel from there....this way all the formulas are downloaded as well.

2.anyone can create a google account using their email from whichever provider. This way you can have access to your spreadsheets from anywhere.

The first thing is really for carlig, the second thing is for anyone. I find it easier to have a google docs account and access spreadsheets from any computer.

Reply #42

CarliG — Mon, 12 Nov 2012 00:23:46 GMT

mglsr ,

its not going to work if I save down to excel 2003

I tried and it loses the formulas every time I try ..

To me that is strange cause it seems to work with open office , but it is what it is..

Sorry, I dont know anything else to try.

Carlig

Reply #41

mglsr — Sun, 11 Nov 2012 21:46:49 GMT

Okay thanks so much

Reply #40

CarliG — Sun, 11 Nov 2012 21:43:21 GMT

I will try saving it down but it may not work . As I said I have had trouble sharing this before

but I will try ..

Gotta run out but will be back soon and will do it then ,

Im using 2007 and works okay . Not sure which version Teamprofit, who made it uses ..

I will also try loading in Google Docs to see if that helps

CG

Reply #39

mglsr — Sun, 11 Nov 2012 21:28:50 GMT

Program says read-only because your excel is a newer version than i have CarliG

Reply #38

CarliG — Sun, 11 Nov 2012 21:06:04 GMT

Here is a link to the full version including RB and Index .

I have had problems sharing this in the past but thanks to TeamProfit, I uploaded a fresh new version from the original.

If it doesnt workd, let me know and I will yank it down

https://www.box.com/s/2eis4h8wqlcihj80seeh

Carlig

Reply #37

Teamprofit — Sun, 11 Nov 2012 19:03:15 GMT

No credit needed :)...we are all here to help

I sent you a pm, i never wheeled the numbers.

Reply #36

CarliG — Sun, 11 Nov 2012 18:37:48 GMT

I had totally forgot you were the one who originally made it .. I apologize for not giving you proper credit, but I really forgot who made it.

That would be great if you could post the original, I know more than a few people that would like the complete sheet . For some reason when I put the complete sheet on Box.net, if loses its formulas .

The only think I did different was , I believe you wheeled the RB only and Pav wants the Game Index wheeled .

On my personal copy I have both the R... [ More ]

Reply #35

Teamprofit — Sun, 11 Nov 2012 18:29:50 GMT

CarliG, put it up on google documents so i can take a look at it.

I still have a copy of the original file i had created for him at that time. If nothing has changed, i can post that.

Reply #34

CarliG — Sun, 11 Nov 2012 18:21:00 GMT

Thanks grwurston for the link . There is a lot of great info in that thread ..

CG

Reply #33

pavizlo$ — Sun, 11 Nov 2012 17:09:45 GMT

Yes, you will need to re-input your 20 numbers every three days to update your Game Index table. The Index Plays table is not

a complete full wheel of the 6 numbers located in the Game Index table as you noticed it, that why the lower 2 boxes are empty.

The Index Plays table is a complete combination of Low digits (L), Medium digits (M), and High digit (H).

Reply #32

boise — Sun, 11 Nov 2012 09:33:30 GMT

Hi I would like to know when do you add your new numbers to the last 20 days? do I just re-do my 20 numbers every three days? And in the index box the two lower boxes on the right are empty shoud they be?

Thanks..

Reply #31

grwurston — Sat, 10 Nov 2012 21:17:09 GMT

Here is the link to the original thread for the Game Index if it will help anyone. Good Luck all!!!

https://www.lotterypost.com/thread/227727/1962251

Reply #30

Scott311 — Sat, 10 Nov 2012 19:53:58 GMT

Program works now, Thanks CarliG

Reply #29

CarliG — Sat, 10 Nov 2012 16:28:29 GMT

Thanks Carbob

You are right this is a great tool, for anyone who doesnt already have it .

The difference between this and the index, is that the index is not by position

He wants the top Low , Medium and High regardless of position which If I remember correctly Paurths wont do.

But I wholeheartedly agree this is a great too and have used it myself many times.

Carlig

Reply #28

retxx — Sat, 10 Nov 2012 16:18:10 GMT

hi carlig I am using open office just fine

Reply #27

pavizlo$ — Sat, 10 Nov 2012 15:44:31 GMT

A HUGE CREDIT TO CARLIG FOR FIXING THIS PROBLEM.

THANK YOU,

Reply #26

CARBOB — Sat, 10 Nov 2012 11:52:03 GMT

Another image showing my selections.

Reply #25

CARBOB — Sat, 10 Nov 2012 11:46:22 GMT

Carli,

Have any of you downloaded this tool from Paurth? Not sure, but should work same as Excel program. Enter the draws, then select digits to play.

Reply #24

CarliG — Sat, 10 Nov 2012 06:39:39 GMT

Sounds like we are good to go , I hope .

Thanks

Carlig

Reply #23

Wishing4awin — Sat, 10 Nov 2012 06:36:43 GMT

I got the same numbers that CarliG got because like hers mine are the combined Mid and Eve.

Reply #22

lakerben — Sat, 10 Nov 2012 06:33:02 GMT

mid only.

Reply #21

CarliG — Sat, 10 Nov 2012 06:31:03 GMT

Oh darn, I got different numbers lol

Are yours combined draws or Mid only ?

mine are combined draws

138 130 135 139

180 185 189 105

109 380 385 389

159 305 309 805

809 059

Reply #20

lakerben — Sat, 10 Nov 2012 06:27:14 GMT

I input the last 20 for fl p3. See if this is right.

Index Plays

059 052 053 058

092 093 098 023

028 592 593 598

038 523 528 923

928 238

This may look better.

059 052 053 058

092 093 098 023

028 592 593 598

038 523 528 923

928 238

Reply #19

Wishing4awin — Sat, 10 Nov 2012 06:26:15 GMT

Thanks CarliG. I will. I am learning the excel just like you. Have done a lot research here on LP. It has been a lot of help.

Reply #18

CarliG — Sat, 10 Nov 2012 06:23:59 GMT

Well Dang

Thank You Wishing4awin . Feel free to jump in anytime, I need all the help I can get ..

CG

Reply #17

lakerben — Sat, 10 Nov 2012 06:21:05 GMT

Its changing now. I input some random numbers. Thanks for your hard work CarliG!

Index Plays

037 031 035 038

071 075 078 015

018 371 375 378

058 315 318 715

718 158

Reply #16

CarliG — Sat, 10 Nov 2012 06:14:48 GMT

Made the change suggested by Wishingforawin

not sure it will resolve the open office issue or not, but it will resolve a leading zero issue that could pop up....

https://www.box.com/s/vzpnd7fosydoe9ojdl9f

Carlig

Reply #15

lakerben — Sat, 10 Nov 2012 06:07:55 GMT

Thanks CG I'll check it out.

Reply #14

CarliG — Sat, 10 Nov 2012 06:05:16 GMT

Thanks , Let me take a look at original and see what formulas say .

Really appreciate the input.. I am surely no wiz at this stuff. I just saw a need for it and started reading excel help sites , trying to learn , but its a slow process .

I will save this formula for sure.. I usually format the input as text to eliminate that issue, but doings so does give me trouble sometimes .

I will change that and reupload and let Scot or Laker try it..

Thanks

CG

Reply #13

Wishing4awin — Sat, 10 Nov 2012 05:58:35 GMT

P.S. I have downloaded alot of excel file you post and you have helped me a lot. Thank you for all you do.

Reply #12

Wishing4awin — Sat, 10 Nov 2012 05:56:42 GMT

Hi Carlig, I downloaded the file and it is working fine for me. I am using Excel 2003. I did change the formula in columns C, D, and E. This formula does count the zeros even if you don't put the 0 in the original number. Like 83, when it should be 083. Column C formala = (INT(B2/100), Column D formula =INT((B2-(C2*100))/10), and Column E =INT((B2-((C2*100)+D2*10))).

I hope this helps.

Reply #11

CarliG — Sat, 10 Nov 2012 05:56:02 GMT

So not even the frequency changes, Down at the bottom ??

It may be the formulas are too complex for open office ??

Keep in mind that the index itself is not going to change every day. So to test I would pad the lowest frequency and see if that changes anything .

Hope I said that right lol

CG

Reply #10

CarliG — Sat, 10 Nov 2012 05:46:53 GMT

Thanks Scott ,

Lakerben also uses Open Office, so Im wondering now if that is the issue ....

If anyone that uses excel , is having issues, hope they will speak up .

Im not sure there is anything I can do to get it open office compatible .

Maybe if Pogo is around , he can take a look and maybe comeup

with something .

Sorry Guys

Carlig

Reply #9

Scott311 — Sat, 10 Nov 2012 05:45:08 GMT

What link do you have? When I use the two links posted above, none of the numbers change when I enter the results.

Reply #8

Scott311 — Sat, 10 Nov 2012 05:41:33 GMT

I am actually using OpenOffice, all of your other files in the past worked with no issue..... P.S. I wanted to thank you for all the work you do here on the forums. You're an Excel wiz

Reply #7

CarliG — Sat, 10 Nov 2012 05:39:21 GMT

I just downloaded it from the link I provided and it works just fine ..

If you look down at the Frequency numbers, are you seeing them change ???

CG

Reply #6

CarliG — Sat, 10 Nov 2012 05:35:06 GMT

Scott ,

Are you using Excel 7 or 10 ??

Thanks

CG

Reply #5

CarliG — Sat, 10 Nov 2012 05:31:02 GMT

Thanks for the heads up guys ,

I will disable the download till I can get it figured out.

If I remember correctly , I had this issue before and it had to do with what excel version user had and how I hve is saved ,

Thanks

Carlig

Reply #4

Scott311 — Sat, 10 Nov 2012 05:19:12 GMT

....Yep, no matter what you enter the numbers stay the same in the boxes.

Reply #3

lakerben — Sat, 10 Nov 2012 05:15:12 GMT

The gi stays at 167 ,238 no matter what input I enter.

Reply #2

pavizlo$ — Sat, 10 Nov 2012 04:46:34 GMT

I just double check it is working, here it is again

https://www.box.com/s/vzpnd7fosydoe9ojdl9f

Reply #1

Scott311 — Sat, 10 Nov 2012 04:39:07 GMT

Is this file working correctly? I enter numbers and the Game Index and the other boxes do not change. I've used CarliG's excel programs in the past with no issues.

Pick3 Game Index Digits

pavizlo$ — Sat, 10 Nov 2012 04:14:55 GMT

This method has been differently discussed sometime ago. The purpose of this method is to sort the hottest

digits in the last 20 draws of your state pick3 history. This method select only 2 digits among the low, 2 digits among the medium, and 2 digits among the high.

The digits are defined as follow:

(L) Low digits are 0, 1,2

(M) Medium digits are 3,4,5,6

(H) high digits are 7,8,9.

Thanks to CarliG the exel program will do all for you.

Here the link https://www.box.com/s/vzp... [ More ]