Welcome Guest
Log In | Register )
The time is now 7:04 pm
You last visited May 19, 2013, 7:04 pm
All times shown are
Eastern Time (GMT-5:00)

Do you use Excel for playing?

Topic closed. 25 replies. Last post 5 months ago by garyo1954.

Page 2 of 2
32
PrintE-mailLink

What do you use?

Excel together with VBA! [ 17 ]  [32.69%]
Excel without VBA! [ 17 ]  [32.69%]
Mainly VBA Excel! [ 2 ]  [3.85%]
Don't have Excel! [ 2 ]  [3.85%]
Don't know how to use Excel! [ 5 ]  [9.62%]
Don't know how to use VBA! [ 2 ]  [3.85%]
Using another spreadsheet program! [ 1 ]  [1.92%]
Never heard of Excel! [ 4 ]  [7.69%]
Stopped using Excel! [ 2 ]  [3.85%]
Total Valid Votes [ 52 ]  
Discarded Votes [ 3 ]  
Avatar
NASHVILLE, TENN
United States
Member #33768
February 20, 2006
933 Posts
Offline
Posted: September 8, 2012, 12:26 pm - IP Logged

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's avatar - talking icon.png
    5/6 and 8/10 winner
    Belgium
    Member #123712
    February 27, 2012
    1788 Posts
    Offline
    Posted: September 8, 2012, 2:11 pm - IP Logged

    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.

    *keep crunching*

    .

      MillionsWanted's avatar - th 39059_moneyman_122_80lo.jpg

      Norway
      Member #9692
      December 10, 2004
      908 Posts
      Offline
      Posted: October 2, 2012, 3:54 am - IP Logged

      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. Wink

      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's avatar - talking icon.png
        5/6 and 8/10 winner
        Belgium
        Member #123712
        February 27, 2012
        1788 Posts
        Offline
        Posted: October 2, 2012, 3:50 pm - IP Logged

        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.

        *keep crunching*

        .

          Avatar
          Texas
          United States
          Member #132464
          September 4, 2012
          271 Posts
          Offline
          Posted: October 6, 2012, 8:21 am - IP Logged

          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's avatar - talking icon.png
            5/6 and 8/10 winner
            Belgium
            Member #123712
            February 27, 2012
            1788 Posts
            Offline
            Posted: October 6, 2012, 2:09 pm - IP Logged

            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.

            *keep crunching*

            .

              SergeM's avatar - talking icon.png
              5/6 and 8/10 winner
              Belgium
              Member #123712
              February 27, 2012
              1788 Posts
              Offline
              Posted: November 17, 2012, 8:05 pm - IP Logged

              Who says that it cannot be done?

              to orderorder AZorder ZA
              245652222245566554222
              a153z135azza531
              aA: zZ12800128:AZazzaZA:8210
              18/11/2012//0111122882211110//

              *keep crunching*

              .

                SergeM's avatar - talking icon.png
                5/6 and 8/10 winner
                Belgium
                Member #123712
                February 27, 2012
                1788 Posts
                Offline
                Posted: November 24, 2012, 1:30 pm - IP Logged

                *keep crunching*

                .

                  SergeM's avatar - talking icon.png
                  5/6 and 8/10 winner
                  Belgium
                  Member #123712
                  February 27, 2012
                  1788 Posts
                  Offline
                  Posted: November 24, 2012, 2:33 pm - IP Logged

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

                  *keep crunching*

                  .

                    SergeM's avatar - talking icon.png
                    5/6 and 8/10 winner
                    Belgium
                    Member #123712
                    February 27, 2012
                    1788 Posts
                    Offline
                    Posted: November 27, 2012, 6:19 pm - IP Logged

                      garyo1954's avatar - garyo
                      Dallas, Texas
                      United States
                      Member #4629
                      May 2, 2004
                      751 Posts
                      Offline
                      Posted: December 8, 2012, 11:25 am - IP Logged

                      I use a two step process.

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

                      Einstein was wrong. Insanity is playing new numbers and watching the old ones come up!