Do you use Excel for playing?Prev TopicNext Topic

• GASMETERGUY

  

  NASHVILLE, TENN
  United States
  Member #33,371
  February 20, 2006
  1,044 Posts
  Offline
  Sep 8, 2012, 12:26 pm

  ▲▼
  In response to LottoBoner

  Quote: Originally posted by LottoBoner on Sep 3, 2012

  Is 4 days of VBA run time not a little overkill?  I mean usually when you guess right you guess fast, because it jumps out at you.  Your intuition points it out and the other part of your brain tries to verify it.   But you are right, excel is a must there is no easier method to track patterns such as the favorite FF, and other hitting patterns.

  Overkill?  Perhaps; perhaps not.  Depending on what one is looking for, some ideas take seconds to run while others might require 4 days.  In my particular case, 4 days is what the data I wanted to see required.

  As a side note, the data turned out to be less than expected (which is usually the case).  I have abandoned the idea.
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Sep 8, 2012, 2:11 pm

  ▲▼
  In response to GASMETERGUY

  Quote: Originally posted by GASMETERGUY on Sep 8, 2012

  Overkill?  Perhaps; perhaps not.  Depending on what one is looking for, some ideas take seconds to run while others might require 4 days.  In my particular case, 4 days is what the data I wanted to see required.

  As a side note, the data turned out to be less than expected (which is usually the case).  I have abandoned the idea.

  The faster the processor, the better for you.

  
• MillionsWanted

  

  Norway
  Member #9,517
  December 10, 2004
  1,904 Posts
  Offline
  Oct 2, 2012, 3:54 am

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Sep 8, 2012

  The faster the processor, the better for you.

  The solution will always be more computer power.

  I've been using an AMD Athlon 7850 for three years. Compared to the CPUs these days it falls behind.

  http://www.cpubenchmark.net/cpu_lookup.php?cpu=AMD+Athlon+7850+Dual-Core

  Intel's i7-3770 costs only $300 and gives a 6.6X performance.

  http://www.cpubenchmark.net/cpu_lookup.php?cpu=Intel+Core+i7-3770+%40+3.40GHz

  I will probably upgrade to i7-3770 with 32GB memory before new year. It will almost be like upgrading to a super computer.

  I'll have to change not only CPU, but also motherboard and memory, because it use another kind of CPU slot, but it will be future proof.

  Perhaps it will be fast enough to run neural networks. I've used neural networks in Excel, but it takes forever if the columns becomes to long.
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Oct 2, 2012, 3:50 pm

  ▲▼

  A standalone program is probably faster than Excel for a lot of tasks. Only Excel offers the possibility to work on the results. You can save some paper and markers with it.

  
• jamella724

  

  Texas
  United States
  Member #132,449
  September 4, 2012
  483 Posts
  Offline
  Oct 6, 2012, 8:21 am

  ▲▼

  I am using Excel - in my work, in my personal affairs and in almost everything.  I just didn't know that excel has another use and that is...lottery.
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Oct 6, 2012, 2:09 pm

  ▲▼
  In response to jamella724

  Quote: Originally posted by jamella724 on Oct 6, 2012

  I am using Excel - in my work, in my personal affairs and in almost everything.  I just didn't know that excel has another use and that is...lottery.

  You can use XML with Excel too.

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 17, 2012, 8:05 pm

  ▲▼

  Who says that it cannot be done?

  to order	order AZ	order ZA
  2456522	2224556	6554222
  a153z	135az	za531
  aA: zZ1280	0128:AZaz	zaZA:8210
  18/11/2012	//01111228	82211110//

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 24, 2012, 1:30 pm

  ▲▼

  

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 24, 2012, 2:33 pm

  ▲▼

  I replaced the function for games out by the right one. ;)

  

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 27, 2012, 6:19 pm

  ▲▼

  
• garyo1954

  

  Texas
  United States
  Member #4,549
  May 2, 2004
  4,228 Posts
  Offline
  Dec 8, 2012, 11:25 am

  ▲▼

  I use a two step process.

  I write the programs in QB64, output the data as a CV, and take that into Excel.

  I'm probably here unless I'm not.
  Dreaming would be a perfectly useless function if it's only purpose was to entertain.