You 1st open the P3Draws Excel file first and update the tabs M, E, C (Midday Draws, Evening Draws, Combined Draws) then go to the top Main Menu and select File > Open then you have a choice of selecting either the WorkoutsDeMapMidday, WorkoutsDeMapEvening, or WorkoutsDeMapCombined. So for example you decide to just use want to use the WorkoutsDeMapMidday file.
If you click the Tab at the bottom labeled "Pick3Draws2", I'm using an 80 draw history range which are the drawings from July 31st back to May 13, 2013. Cell column A. Every time you update the Excel file 'P3Draws" Midday drawing(s) (M Tab) you will also need to adjust the drawing number in cell AC1 located in the WorkoutsDeMapMidday Excel workbook in the Tab/worksheet labeled Pick3Draws2. For now you don't need to adjust cell AC1 which is currently set at 29. The 29 is taken from the 1st tab labeled "Pick3Draws". If you look at the leftmost column where you see where 29 is on the same row as July 31, 2013.
I'm also using an 80 draw range to calculate how many times a Front Pair, Back Pair, or Side Pair has hit. You can also change the 80 draw range to 120 draws by going to the Tab labeled Pick3Draws2 and click cell AF1. To the right of cell AF1 there is a drop-down arrow. If you click the drop-down arrow you have a choice of 79 or 119. If you select 79 you will be using an 80 draw history. If you select 119 you will be using a 120 draw history. Currently it is set to 79 which is an 80 draw history range from July 31 2013 through May 13, 2013
The only entries you need to make are in the tab labled "FrequencyModel" in the WorkoutsDeMapMidday Excel file. This is cell range AB5 though AB24.
Notice in cell AB16 the last entry was from friday August 9th 2013 which was 309. The Front Pair is 30 (cell AD16), Side Pair is 39 (AE16), and the Back Pair is 09 (AF16). The 1 in cell AH16 indicates that the Front Pair 30 occurred 1 time from July 31st throgh May 13 (80 draw history). The 1 in cell AI6 indicates that the Sidet Pair 39 occurred 1 time from July 31st throgh May 13 (80 draw history). The 2 in cell AJ16 indicates that the Back Pair 09 occurred 2 times from July 31st throgh May 13 (80 draw history). In cell AL16 is taking AH16, AI16, and AI16 and just creating the "box set" 112. In cell AP16 you should see the number 29. This incicates that there are only a total of 29 possible Pick 3 combinations for 112. If you click the Tab labeled "AllMaps" and only select 112 from the filtered listing you will see all 29 Pick 3 combinations.
In the Tab "AllMaps" in the WorkoutsDeMapMidday Excel file I selected the box "000". You can change this by clicking in the drop-down arrow in cell C1. Currently it has an icon that looks like a funnel/filter. If you click the icon a drop down list will appear where you can change the current box selection 000 to whatever is in the list at the bottom.