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

spreadsheet

Topic closed. 5 replies. Last post 3 years ago by retxx.

Page 1 of 1
51
PrintE-mailLink
retxx's avatar - mrthumbs
BOSTON
United States
Member #48
September 9, 2001
3584 Posts
Offline
Posted: August 31, 2013, 10:38 am - IP Logged

hi ranman or carlig wonder if you can do a spreadsheet that allows me to put the last 40 or so keno numbers in and have it show the best 5 combo as a set. Or put in the last 100 also. ThanksLurking

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: August 31, 2013, 11:08 am - IP Logged

    Retxx  you need to define what best means to you. Excel is very good at doing math, lousy at thinking.  as the thinker you have to decide exactly what you want done, best is not descriptive enough.  do you the 5 with highest frequency in a set period, oldest or most overdue,  mix of hot and cold #'s.  If you can define best, in matematical terms then a spreadsheet could be created

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: August 31, 2013, 11:43 am - IP Logged

      LOL

        retxx's avatar - mrthumbs
        BOSTON
        United States
        Member #48
        September 9, 2001
        3584 Posts
        Offline
        Posted: August 31, 2013, 1:22 pm - IP Logged

        will wait to see what they can suggest. They are 2 sharp people. I will do whatever they think would work best and test it out. thanksBed

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: August 31, 2013, 2:02 pm - IP Logged

          Here is a link to a Keno Excel file from a number of years ago.

          https://app.box.com/s/j9ccvgonjc3jb2c8tqsh

          Choose the correct file for your Excel version

          .xls = 1997 through 2003

          .xlsm - 2007 & 2010

          You will need to copy and paste your own draws into cell range B1 through Y1.  Delete any excess draws.

            retxx's avatar - mrthumbs
            BOSTON
            United States
            Member #48
            September 9, 2001
            3584 Posts
            Offline
            Posted: August 31, 2013, 4:32 pm - IP Logged

            thanks winsum;that is a great sheet. It has all that I need. thanks again.Sad Cheers