Quote: Originally posted by thamizhpayan on Mar 17, 2017
Hi,
I was posting about skip/hit statistics tracking under state Pick-3 and Pick-4 threads. I thought of posting them under one Post to get feed back. You can also PM me if you want report for another state or so.
You can see what's hot, cold and due. In addition you can see actual dueness and math dueness. I know these have been discussed in lot of threads. I wanted to start fresh with these charts to identify some pattern or so.
I put a word document in the same drive folder "Pick3_And_Pick4_Statistics_Guide.docx". There is clear explanation in this document about what's there in each sheet and how to interpret.
Here are
Pick-3 IL hit and Hit/Skip statistics as excels 03/16/2017
https://drive.google.com/open?id=0B4Qt2_2g3zs5STZ4enNnOXdJNG8
Pick 3 and Pick 4 NJ Hit/Skip statistics as excels 03/15/2017:
https://drive.google.com/open?id=0B4Qt2_2g3zs5ajRLMUlQN1FvemM
Pick 3 and Pick 4 IA Hit/Skip statistics as excels 03/15/2017:
https://drive.google.com/open?id=0B4Qt2_2g3zs5bGgxR2hNVDRpZFE
Draw files are named as Pick3C_ or Pick4C_ and IA/IL/NJ the state 2 letter code is suffixed to it.
Pick3C_IA.xlsx - Iowa Pick-3 draw file
Pick4C_IA.xlsx - Iowa Pick-4 draw file
Pick3Charts.xlsx - Pick-3 pairs and combo charts
Pick4Charts.xlsx - Pick-4 pairs and combo charts - also refer to above Pick3Charts file for triplet combo information
Statistics files:
file name interpretation:
Stat_PICK3_IA_02-19-2017_E_MAXDR_1_REP_E_P_90.xlsx
02-19-2017 Evening draw report based on just Evening Draws with 90 days(draws) used for statistics.
Note : Pick-4 statistics includes all 4 triplets statistics too XXX_, _XXX, X_XX, XX_X : front, back, split one, split two triplets
I know that the Pick-3 statistics posted above won't be fully useful without a wheel. I am going to work on a pick-3/4 wheel so that we can add new features.
For now, use this excel sheet to filter and pick combinations. For each statistics sheet's index(the value being analyzed e.g., digit 1) there is a corresponding column in this workbook.
If you want to filter root sum, short sum or sum or any of the classification in the statistics, you can use this excel sheet to filter out(also you can use excel's filtering feature to include few and exclude few - like a filter). All 1000 number's digits, sums, pairs, pair sums, classifications as boxes and straights, etc.,... everything is presented as separate column.
https://drive.google.com/open?id=0B4Qt2_2g3zs5Yzl2dDAtZkROVUk
Now you can use the statistics file and pick whatever you think will come(most out, most due or most frequent/hot) and then filter it out in this spreadsheet and pick your combinations... You can move around the columns - reorder them as per your need and even remove the ones you don't want.
For time being use this to filter combos. I will post a similar sheet for Pick-4 also.
Most of these sheet data and calculations are derived from discussions from various posts and threads started by following users : MonEL, Garyo, Paruths(Ricky), Steve(Winsumloosesum), Libra(index tool), Tntea and Blackapple's posts. And the reports resemble that of LotSoftPro/Versabet as it does the same calculations.
Note: there are no macros or any calculations in the sheet. The sheets are all output from program.
Thanks and Good Luck