Welcome Guest
Log In | Register )
You last visited December 4, 2016, 4:15 am
All times shown are
Eastern Time (GMT-5:00)

winsum plus minus help

Topic closed. 5 replies. Last post 2 years ago by kreative1.

Page 1 of 1
51
PrintE-mailLink
kreative1's avatar - flower2
NE PA
United States
Member #127838
May 10, 2012
1230 Posts
Offline
Posted: November 8, 2014, 2:55 pm - IP Logged

winsum do you still have this in excel somewhere?

I think it was the one that you could plus minus each digit with 0 to 9

thanks!

 

Link below to Excel file and text file instructions.

http://www.badongo.com/file/10237132

 

Creates Pick 3 and Pick 4 combinations based on your Plus Minus configurations

    kreative1's avatar - flower2
    NE PA
    United States
    Member #127838
    May 10, 2012
    1230 Posts
    Offline
    Posted: November 8, 2014, 3:48 pm - IP Logged

    I'm not sure if it's the one I'm thinking or if you had done it, it might have been pogo

    It had drop down for each digit, plus or minus 0-9

    I had it on pc but with files encrypted I can't figure out what one it was or the name..

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: November 9, 2014, 9:13 am - IP Logged

      If you have a link to the thread or know the name of the file it would help.

        kreative1's avatar - flower2
        NE PA
        United States
        Member #127838
        May 10, 2012
        1230 Posts
        Offline
        Posted: November 9, 2014, 10:49 am - IP Logged

        I don't know...

        The only thing I know is for each digit of pick 3-4 there was a drop down of plus 0-9 and minus 0-9

        example 123

        1(drop down+0-9,-0-9) 2 (drop down+0-9,-0-9) 3 (drop down+0-9,-0-9)

        example 1234

        1(drop down+0-9,-0-9) 2 (drop down+0-9,-0-9) 3 (drop down+0-9,-0-9) 4  (drop down+0-9,-0-9)

          kreative1's avatar - flower2
          NE PA
          United States
          Member #127838
          May 10, 2012
          1230 Posts
          Offline
          Posted: November 9, 2014, 1:58 pm - IP Logged

          I found it!

          Lakerbens pick 3 combo

          Excel versions 2002-2003

          https://www.box.com/s/j9x2468w08cqa9swbgv3

           

          Excel 2007 - 2010

          https://www.box.com/s/zxw8b72ktt60i9crq5hz

           

          Instructions:

          1. Enter your Pick 3 number in cell C5  (example, 867)

          2. Enter +/- in cell range H5 through J5 (example, -1, -1, -1)

          I modified the +/- so you could enter any +/- value in cell range H5:J5  (example, 1, -1, -2, +1, +5, -5, etc.)

          If you are using a negative value make sure you enter the "-" before the value in cell range H5 though J5. (example, -1, -2, -3, -4, -5, -6, -7, -8, -9)

            kreative1's avatar - flower2
            NE PA
            United States
            Member #127838
            May 10, 2012
            1230 Posts
            Offline
            Posted: November 9, 2014, 2:22 pm - IP Logged

            Added the option of either using the Root times Sum Method or using the Pick 3 number from cell C5.

            Here's how it works:

            1.  Enter your Pick 3 combo in cell C5

             

            2.  Click cell F5. You will see a drop-down arrow to the right.  Select either "A" or "B".

            "A" = The Root * Sum calculation method. 

            "B" = Using the Pick 3 combo in cell C5.

             

            3.  Click inside Cell H5.  You will see a drop-down arrow to the right. Select the +/- value for Position 1

                 Click inside Cell I5.  You will see a drop-down arrow to the right. Select the +/- value for Position 2

                 Click inside Cell J5.  You will see a drop-down arrow to the right. Select the +/- value for Position 3

            Note: You can also select "0" in cells H5, I5, or J5.  This will not change the value for that particular Position.

             

            Here are the new download links:

            Excel versions 1997 - 2003

            https://www.box.com/s/j9x2468w08cqa9swbgv3

            Excel versions 2007 - 2010

            https://www.box.com/s/zxw8b72ktt60i9crq5hz

            I uploaded this to Google Docs:

            https://docs.google.com/spreadsheet/ccc?key=0AinNorl305O8dG5kNF96N0dpeWgzR1pVbFhub0Ixamc#gid=0