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

Excel

Topic closed. 10 replies. Last post 7 years ago by lottocalgal.

Page 1 of 1
PrintE-mailLink
Jordans121's avatar - nw bookeep.jpg

United States
Member #69169
January 5, 2009
2122 Posts
Offline
Posted: January 21, 2010, 6:11 pm - IP Logged

I cant believe every one on this entire site does not know how to input complex formulas into excel!!

either every does not know or does not want to help me.

"Many Strategies|One Game"

    LadyMylena's avatar - avatar6 1.jpg
    Kansas
    United States
    Member #83963
    December 19, 2009
    347 Posts
    Offline
    Posted: January 21, 2010, 6:16 pm - IP Logged

    I don't know either, or I would help you. I just said in another thread, that I don't have or know much about Excel. I wish I did. Frown

    Luck is  ** believing  ** you're lucky.” ~Tennessee Williams

    Money is neither my god nor my devil. It is a form of energy that tends to make us more of who we already are, whether it's greedy or loving.  ~ Dan Millman


      Jordans121's avatar - nw bookeep.jpg

      United States
      Member #69169
      January 5, 2009
      2122 Posts
      Offline
      Posted: January 21, 2010, 6:31 pm - IP Logged

      Me too. I wonder if Todd knows anything about it since he's a programmer. 

      "Many Strategies|One Game"

        tiggs95's avatar - Lottery-036.jpg

        United States
        Member #47420
        November 4, 2006
        3930 Posts
        Offline
        Posted: January 21, 2010, 7:39 pm - IP Logged

        I just know how to turn on the computer and don't know what Excel is..Good luck Jordan..Todd should be able to help he's smart..

          Avatar
          NASHVILLE, TENN
          United States
          Member #33372
          February 20, 2006
          1044 Posts
          Offline
          Posted: January 21, 2010, 8:56 pm - IP Logged

          I cant believe every one on this entire site does not know how to input complex formulas into excel!!

          either every does not know or does not want to help me.

          There are some members who use Excel.  Some are rank amatuers, like me, and others are professional who get paid for their work.

          I knew nothing about Excel when I began tracking the lottery.  Over time I had need of the VBA features.  I knew nothing!  So I searched the web for answers and found them.

          There are many sites which will teach what you want to know.  All you have to do is search.

          By the way, what is/was your Excel question?

            Raven62's avatar - binary
            New Jersey
            United States
            Member #17843
            June 28, 2005
            49835 Posts
            Offline
            Posted: January 21, 2010, 10:34 pm - IP Logged

            I cant believe every one on this entire site does not know how to input complex formulas into excel!!

            either every does not know or does not want to help me.

            Will denigrating the people you want help from: Get them to help you?

            A mind once stretched by a new idea never returns to its original dimensions!

              Avatar
              Milwaukee, WI
              United States
              Member #3131
              December 27, 2003
              665 Posts
              Offline
              Posted: January 22, 2010, 12:43 am - IP Logged

              Just get openoffice for dummies, download it and practice....

              I believe that it's 16.50 @ amazon...

              I learned it without any help...

              MarkP

                Jordans121's avatar - nw bookeep.jpg

                United States
                Member #69169
                January 5, 2009
                2122 Posts
                Offline
                Posted: January 22, 2010, 12:49 am - IP Logged

                Thanks to every one. I found what I needed

                "Many Strategies|One Game"

                  Avatar
                  Roanoke Rapids, NC
                  United States
                  Member #70505
                  February 4, 2009
                  225 Posts
                  Offline
                  Posted: January 22, 2010, 12:52 am - IP Logged

                  I cant believe every one on this entire site does not know how to input complex formulas into excel!!

                  either every does not know or does not want to help me.

                  Sorry I dont know , dont even know how do the workouts

                    Avatar

                    United States
                    Member #83701
                    December 13, 2009
                    225 Posts
                    Offline
                    Posted: January 22, 2010, 4:24 am - IP Logged

                    I cant believe every one on this entire site does not know how to input complex formulas into excel!!

                    either every does not know or does not want to help me.

                    I put together some Excel spreadsheets to analyze scratchoff games based on combinatorics instead of pure probabilities and hence take into consideration the discrete finite nature of the number of tickets printed and sold.   Initially, I used loops and logarithms to handle the large factorials in the VBA subroutines but this resulted in the sheet taking days to recalculate so I had to resort to a Ramunujan enhanced Stirling approximation reordered to handle the large factorials in the binomial coefficients.   Sped up the sheets to the point where its just a few seconds to recalculate.   I actually use both the slow and fast subroutines within the sheets as certain values are just fine with the slow and more accurate routine.   It's interesting to see the difference between these approaches and standard probabilities.

                    There's probably a lot more to Excel that I can learn to use in the spreadsheet but it's at the point where I think I've gotten all the information out that I can from the data published daily about the scratchoff prizes claimed.

                      lottocalgal's avatar - Lottery-043.jpg
                      CA
                      United States
                      Member #57222
                      December 23, 2007
                      587 Posts
                      Offline
                      Posted: January 22, 2010, 9:11 am - IP Logged

                      Me too. I wonder if Todd knows anything about it since he's a programmer. 

                      JOrdans121,

                      Im finally learning  formulas with my new job. I have been on MANY forums requesting assistance.  I finally got an answer on a true Excel forum.  I would hapy happpy to help you with anything if I knew more.  In fact, I thought i was pretty good at excel until I got this job and found out how extensive it is.   Im trying to learn Pivot tables which  is driving me crazy!

                      I hope im not out of line by saying it here  on LP but is there  a way you could ask your Excel on question a true Excel forum? not neccessarily on LP?  There are TONS out there and with people who would help.  I got an answer within one day.