Pick 3 - "Dueness" - Observation - Florida Combined DrawsPrev TopicNext Topic

• Broulir32

  

  United States
  Member #67,379
  November 24, 2008
  282 Posts
  Offline
  Apr 28, 2010, 8:26 pm

  ▲▼

  did u hit it

  And the answer is ???       U won't get it, if u don't ask the question ??
  
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 28, 2010, 8:35 pm

  ▲▼
  In response to CarliG

  Quote: Originally posted by CarliG on Apr 28, 2010

  There goes the STRAIGHT 513

  Eve - 4/28

   

  Nice work Winsum

   

  CarliG

  Nice!!

  

  If you updated all your drawings including this evenings 513

  In the Tab labeled "Pick3HitSkipChart" go to cell B4 and replace the number that is there now with the number 26

  Scroll over to cell range X1 through AC7 and you should have the same chart as above.
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Apr 28, 2010, 8:41 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 28, 2010

  Nice!!

  

  If you updated all your drawings including this evenings 513

  In the Tab labeled "Pick3HitSkipChart" go to cell B4 and replace the number that is there now with the number 26

  Scroll over to cell range X1 through AC7 and you should have the same chart as above.

  Okay, gonna go update now..

  Then I need to read back from the beginning and see where you get the "26" from..

  Didnt play it . figured I would just watch it this week and give it a go next one..

   

  CarliG
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Apr 28, 2010, 8:49 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Apr 28, 2010

  Nice!!

  

  If you updated all your drawings including this evenings 513

  In the Tab labeled "Pick3HitSkipChart" go to cell B4 and replace the number that is there now with the number 26

  Scroll over to cell range X1 through AC7 and you should have the same chart as above.

  Yep. Im with you so far. Mine looks just like this..

  We hold the original list till tommorrow , correct ?

  then we need to come up with new list.

   

  CarliG
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 28, 2010, 8:52 pm

  ▲▼

  The reason I enter a 26 is that the number bypasses the 6 draws since Sunday Evening and gives you all the stats.  It's like the 6 (Monday Midday & Combined, Tuesday Midday & Combined, and Wenesday Midday & Combined) draws have not been drawn.

  If you go to the Tab labeled "Draws" after you updated all the draws including tonights drawing you will see that the most current drawing is on line 20. The last time I update I used Sunday's Evening draw.  So if you look at the line Sunday's drawing is on line 26.  That's why I used the number 26.

  Go to the Tab labeled "Pick3Dueness" and scroll over to cell range CY24 through DF24.  This was the last drawing I used to calculate the "Dueness Index" for Segement 12 (cell CY23).

  After tomorrows Midday Florida drawing I will have 7 new drawings to enter in cell range DA14 through DF20.

  I'll post an image tomorrow after the Midday drawing.
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Apr 29, 2010, 10:02 pm

  ▲▼

  Winsum

  Can you check this and let me know if I did it right ?

  I saw a couple discrepencies in directions so I want to be sure its okay..

  This is after I entered todays mid draw.

  

   

  Thanks

  CarliG
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 30, 2010, 12:26 am

  ▲▼
  In response to CarliG

  Quote: Originally posted by CarliG on Apr 29, 2010

  Winsum

  Can you check this and let me know if I did it right ?

  I saw a couple discrepencies in directions so I want to be sure its okay..

  This is after I entered todays mid draw.

  

   

  Thanks

  CarliG

  OK, you entered today's Florida Midday Pick 3 - 035

  Add a new sheet by right clicking any one of the Tab at the bottom.  Doesn't matter which one.  So right click any tab and then select "Insert" from the list of options.  The a window will open then select "Worksheet" then click OK.  You should now have a new sheet added.  Might be sheet1, sheet2 it doesn't matter.  This is where we will copy and paste our new combinations.

  Go to the Tab labeled "Pick3Dueness" and enter the number 20 in cell B4.

  Next, go to the Tab labeled "Pick3HitSkipChart" and enter the number 20 in cell B4

  Next, staying in the same Tab "Pick3HitSkipChart" go to cell B12 and click cell b12 and hold down your left mouse button and while holding down your left mouse button move your mouse so it highlights over to cell F12.  Keep holding your left mouse button down and move your mouse down and highlight all the way down to cell F1011.  Let go of the left mouse button.  OK so now cell range B12 through F1011 should now be highlighted.  Use the scroll bar on the extreme right side and push the scroll bar all the way to the top.  Next, go to cell B12 and using your mouse right-click and select Copy.  Next, go to the new sheet you created above and click the Tab of the new sheet.  Go to cell A1 and right click your mouse and select Paste Special.  Then from the next screen select Special. You should now have 4 columns of data in cell columns A through F.  Next, click cell G1.

  OK, take you mouse and hover over the "C" in column C.  As soon as the "cross hairs" turns into a "down arrow" click the letter C.  This will highlight the entire column C.  Next click the delete key on your keyboard.  We don't need the data in column C.

  Next, take your mouse and click column E to highlight the entire column.  Take your mouse and right click.  Then select "Format Cells".  A Format Cells window will open.  You will see Tabs at the top of this new window.  Clcik the Tab labeled "Number".  Go to the bottom of the list in the "Category" column and look for the word "Custom" and click the word "Custom".  You will see the box to the right become active.  Look for the "0" (zero) and click it.  A 0 (zero) will appear under the word "Type".  Enter 2 more zeros next to the first one so you shoul now have a total of 3 zeroes. (000) Then clcik the OK button.  All the combinations in cell column E will be formatted with three places.

  Next, click column B to highlight the entire column.  Right Click using your mouse and select "Format".  Click the Tab labeled "Number".  To the right where you see "Decimal Places" change the decimal places from a 2 to a 5 then click the OK button.

  Next, take your mouse and highlight cell columns A through F by going to the A in cell column A and holding down your left mouse drag your mouse to highlight columns A through F.  Let go of your mouse button.  Cell columns A through F should now be highlighted.  Go the top and click the "Center" formatting Icon.  Just like the Icon in Word. To the right to the Bold Italic and Underline Icons.  Ok so cell columns A through F are still highlighted and now centered.  Now go to the top of the Main Menu and select "Data", then select "Sort", a window will open.  In the "Sort By" use the drop down to select "Column A" and to the right select "Ascending" then click the OK button.  In column A you should see all the "1" for 46 total combinations.  Copy and paste all 46 combinations in cell column "E" and paste them to a new column.  Then sort by number group like you did in you previous post.

  Should look like this:

  

  The new list should look like the image above.  We added 3 new combinations 079, 579, and 956.  We lost 5 highlighted in yellow. 422, 447, 462, 513, 661.  Of course the 513 hit straight.  What I did was compare the new list to the last list I originally posted.  You should have all the combinations with the exception of the combinations highlighted in yellow.

  Here is the new Excel file with the Midday draw from today Thursday April 29 2010.

  http://www.box.net/shared/4n598kajhg

  Good Luck!!
• CARBOB

  

  COLUMBUS,GA.
  United States
  Member #4,924
  June 3, 2004
  6,719 Posts
  Offline
  Apr 30, 2010, 5:50 am

  ▲▼

  Steve,

   I want to use Mid and Eve draws separately. These are my Mid combos, will you verify for me , please.

   

   

   

   

  
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 30, 2010, 8:18 am

  ▲▼
  In response to CARBOB

  Quote: Originally posted by CARBOB on Apr 30, 2010

  Steve,

   I want to use Mid and Eve draws separately. These are my Mid combos, will you verify for me , please.

   

   

   

   

  

  Bob,

  I'll have to check your selections.  When you change to just Midday draws it will most likely change the "Dueness Index" possible play range.
• mglsr

  

  Tennessee
  United States
  Member #2,369
  September 23, 2003
  3,088 Posts
  Offline
  Apr 30, 2010, 2:10 pm

  ▲▼
  In response to CarliG

  Quote: Originally posted by CarliG on Apr 29, 2010

  Winsum

  Can you check this and let me know if I did it right ?

  I saw a couple discrepencies in directions so I want to be sure its okay..

  This is after I entered todays mid draw.

  

   

  Thanks

  CarliG

  Steven, I am not seeing this sheet anywhere?

  must be doing something wrong.

  "As Quoted by the Genius One:"

          "Life i$ Good "   

   $$$$ I FEEL LUCKY $$$$                                                               

   *lay off and it pays off*
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 30, 2010, 3:15 pm

  ▲▼
  In response to mglsr

  Quote: Originally posted by mglsr on Apr 30, 2010

  Steven, I am not seeing this sheet anywhere?

  must be doing something wrong.

  That was Carlig's post.  Check my response to Carli's and I posted an updated Excel file download link.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  Apr 30, 2010, 3:23 pm

  ▲▼

  Here is the updated Excel file (zip) download link with today's Midday result :

  http://www.box.net/shared/020ecv7h3d

  Go to the tab labeled "Pick3HitSkipChart" and scroll over to cell range BX through CG.

  I have to sort the list to arrive at the combinations in this range.  See my previous response to CarliG on how I do it.

  I'm just testing this strategy and not would not recommend playing any combinations.
• Best Picks

  

  Eastern Missouri
  United States
  Member #841
  November 7, 2002
  2,430 Posts
  Offline
  Apr 30, 2010, 7:17 pm

  ▲▼

  WSLS, i know we r not at this point yet, but how do we update the 7day segments where u show what has hit and if it falls within the range (would not paste right) it is on the pick3dueness tab

  Numbers.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  May 2, 2010, 1:44 pm

  ▲▼

  I wanted to add this insight to the Florida file.

  513 hit this week Wednesday Eve with a "Dueness Index" of 0.81472.  Use the "Dueness Index" .70000 through 0.79999 until this segment hits.

  If the "Dueness Index" hits, for the next segment of drawings re-calculate using a "Dueness Index" range of between 0.70000 through 0.79999.  Enter them in the Tab labeled "Pick3HitSkipChart" in cells B7 and C7.  You will see that this gives you 51 selections in cell C9.

  You will see that if we changed the "Dueness Index" from .80000 through .89999 to .70000 through .79999 in cells B7 and C7 we would have had 2 straight hits on Friday April 30 Midday (348) and Friday April 39 Evening (800).  Since the Evening drawing for Sunday May 2, 2010 is the last drawing for this 7 draw segemnt we would go back to .080000 through .89999 for the next 7 draws.

  

  Just testing this idea.