|Posted: February 14, 2016, 12:51 pm - IP Logged|
Created an Excel file together as a companion for the T-Lex program from RL, when analyzing same/change, Lexi digits skip/hits, hot cold, consecutive same/change etc.
This for those who own a fully functional version of Excel 2010, 2013, 2016 and beyond...
Close T-Lex Program if open!!
1> Place the zip file in your T-Lex folder
2> Unzip the contents of the zip file
3> You should have a folder called "Master" and an Excel file "TLexImportDrawsSC.xlsm"
4> The "Master" folder is the exact same files folder used by T-Lex. Copy and Paste the "Master" folder into the T-Lex main folder. Normally located at C:\T-Lex\ Replace the existing "Master" folder.
5> Open the Excel file "TLexImportDrawsSC.xlsm". You may need to enable macros if prompted
> Click the tab labeled "DrawImport" (2nd tab at the bottom from the left)
> Click cell U2
> Click the drop-down arrow to the right and select your lottery game. In cell U2 I have my game example Pennsylvania Treasure Hunt PA530"
> Click the "Clear Drawings" toolbar located in cell range O3:P5. This should clear the draws from cell rows B:J
> Click the "Click to Import Draw Text File" toolbar located in cell range O7:P10. This should insert your game draws in cell rows B:J
> Click the toolbar labeled "Copy Drawings to DrawHistory1 Tab". This will copy your games history from cell rows B:J to the tab labeled DrawHistory1
> You should see your games draw history starting in cell B20
> Click the toolbar labeled "Click to Clear S/C Report" located in cell range C3:C5. This may take 10 to 15 seconds. You should see a pop message when the macro is finished. Close the message box.
> Click the toolbar labeled "Click to Run S/C Report" located in cell range C8:C10. This again may take up to 15 seconds and you should see a pop message when the macro is finished. Close the message box.
> Scroll over to cell range rows AX through CB. These are the Same/Change calculations from the Lexi draws for each position. S = Same, C = Change
> You can see by the colors from the last 100 draws for "S" or "C". This will help when making you decision on what the next Step(s) may hit.
> Click the tab labeled "SCForwardLexi"
> This worksheet calculates the same/change "consecutive" hits for Step Position 1, 2, and 3. So for example when you see that a "S" or a "C" has hit "x" amount consecutive times in the last "x" number of draws this chart will show you how many times it has hit. The cell will be highlighted in Yellow for each Lexi Position/Step. For example if a Lexi Position 2 "Step 1/ P2" has hit 6 times in a row you can look to the right and see how many times it hit 7,8,9,10 etc. The higher the number of consecutive hits the more likely the "s"/"c" will flip or change.
> The next tab labeled "LexiPoSkips" is for analyzing Lexi's by position. Click cell H7 and from the drop-down list select what Lexi Position you want to analyze. To the right will bel the current skip for that Lexi # and all the skips from the last 1000 draws. Or whatever total amount of draws are in your game. To the left are the "hits". The Lexi digits are colorized by Group 1 through 3.
> Click the tab to the right at the bottom labeled "LexiRankingChart". This worksheet calculates the "ranking" of each Lexi position, the total hits, current skip, and ranking "Hot", "Warm", "Cold" in cell column range 19 through 30. I may have made these calculations based on member notmyday.