Welcome Guest
Log In | Register )
You last visited December 9, 2016, 8:10 pm
All times shown are
Eastern Time (GMT-5:00)

Do you use Excel for playing?

Topic closed. 25 replies. Last post 4 years 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 #33372
February 20, 2006
1044 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 - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 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.

      MillionsWanted's avatar - 24Qa6LT

      Norway
      Member #9517
      December 10, 2004
      1272 Posts
      Online
      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 - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 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.

          Avatar
          Texas
          United States
          Member #132455
          September 4, 2012
          483 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 - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 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.

              SergeM's avatar - slow icon.png
              Economy class
              Belgium
              Member #123700
              February 27, 2012
              4035 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//

                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: November 24, 2012, 1:30 pm - IP Logged

                  SergeM's avatar - slow icon.png
                  Economy class
                  Belgium
                  Member #123700
                  February 27, 2012
                  4035 Posts
                  Offline
                  Posted: November 24, 2012, 2:33 pm - IP Logged

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

                    SergeM's avatar - slow icon.png
                    Economy class
                    Belgium
                    Member #123700
                    February 27, 2012
                    4035 Posts
                    Offline
                    Posted: November 27, 2012, 6:19 pm - IP Logged

                      garyo1954's avatar - garyo
                      Dallas, Texas
                      United States
                      Member #4549
                      May 2, 2004
                      1730 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.

                      My greatest accomplishment is teaching cats about Vienna Sausage. When I need a friend, all I need do is walk outside, pop open a can, and every little critter in the neighborhood drops by to say "Hi!"