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

The Bernie's Iznop System

Topic closed. 109 replies. Last post 7 years ago by Jackie284.

Page 6 of 8
54
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: October 4, 2009, 10:28 am - IP Logged

I made some changes to the formulas and it is now shared in Google Docs

Here is the link:

http://spreadsheets.google.com/ccc?key=0Akpv-M8raPsfdDZJVmdnMFdSTlpIRkZVaGpzZl9sLWc&hl=en

I set up this file so you can make changes.

For example:

You can change your most recent draw in cells I5, J5, and K5 (Position 1, 2, and 3) and the previous draw in cells I10, J10, and K10

The results will be in colums AJ (Straight Plays) and AL (Boxed Plays)

You can also manually change the IZNOP settings in cell range N2 through R2 to whatever letter designation you want.  You will have to manually change the corresponding digit in cell range N3 through R3.  See cell columns A and B for the letter designations.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: October 4, 2009, 10:54 am - IP Logged

    I set up this file so you can make changes.

    For example:

    You can change your most recent draw in cells I5, J5, and K5 (Position 1, 2, and 3) and the previous draw in cells I10, J10, and K10

    The results will be in colums AJ (Straight Plays) and AL (Boxed Plays)

    You can also manually change the IZNOP settings in cell range N2 through R2 to whatever letter designation you want.  You will have to manually change the corresponding digit in cell range N3 through R3.  See cell columns A and B for the letter designations.

    Just realized a few issues:

    1.  I screwed up on the formulas trying to get this file to work in Google Docs.  Don't use the previous link posted use the one below!!!

    2.  Only enter the most recent draw in cell G5 and the previous draw in cell G10.  The Play list for straights and boxes will be in cell column AJ and AL

    Here is the new Google Docs link:

    http://spreadsheets.google.com/ccc?key=0Akpv-M8raPsfdEhjQ3FmV25qQU5vRVhkWkZfMWsta2c&hl=en

     

    The other issue is multiple people using this shared filed.  Maybe the best thing to do is if you haven't done so already is to set up a Google account and save this file to your own account.

    Let me know if you have any suggestions!!

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: October 4, 2009, 11:34 am - IP Logged

      I uploaded a new link. 

      Rule 1

      Only enter your states most recent drawing in cell "G5"

      Rule 2

      Only enter your states previous drawing in cell "G10"

      Donta toucha da othera cellsa. LOL

      Here is the new link:

      http://spreadsheets.google.com/ccc?key=0Akpv-M8raPsfdE5QcnhvZXlwd2JGQUtob2lkZFUxV1E&hl=en

       

      If you want to download the Excel file here is the link:

      http://rapidshare.com/files/288593927/IZNOP_Workoutv2.xls

       

      If you want to download the OpenOffice link:  (See previous post for link to FREE Openoffice download)

      http://rapidshare.com/files/288594867/IZNOP_Workout_Open_Office.ods

        centsless's avatar - Me 20Oct%202016.jpg
        TX/LOTTOLAND/USA
        United States
        Member #78380
        August 13, 2009
        2602 Posts
        Offline
        Posted: October 4, 2009, 12:53 pm - IP Logged

        Great job! Thank you for posting these links. The google one works great! Just one question. I've got bernie's original worksheet on excel. Why are you numbers not matching what I get on his?. Is the difference number correct? Thanks. I'll watch your post.

          centsless's avatar - Me 20Oct%202016.jpg
          TX/LOTTOLAND/USA
          United States
          Member #78380
          August 13, 2009
          2602 Posts
          Offline
          Posted: October 4, 2009, 1:11 pm - IP Logged

          The rapidshare link is correct, and works great! Thanks for your work. :) You Rock

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: October 4, 2009, 1:45 pm - IP Logged

            If you post Bernies Excel file on Google Docs I can look at it!!

              Shawn67's avatar - Lottery-061.jpg

              United States
              Member #45970
              September 1, 2006
              4763 Posts
              Offline
              Posted: October 4, 2009, 1:47 pm - IP Logged

              Thanks a ton, works like a charm now!!

                truecritic's avatar - PirateTreasure
                Michigan
                United States
                Member #22395
                September 24, 2005
                1583 Posts
                Offline
                Posted: October 4, 2009, 2:07 pm - IP Logged

                I uploaded a new link. 

                Rule 1

                Only enter your states most recent drawing in cell "G5"

                Rule 2

                Only enter your states previous drawing in cell "G10"

                Donta toucha da othera cellsa. LOL

                Here is the new link:

                http://spreadsheets.google.com/ccc?key=0Akpv-M8raPsfdE5QcnhvZXlwd2JGQUtob2lkZFUxV1E&hl=en

                 

                If you want to download the Excel file here is the link:

                http://rapidshare.com/files/288593927/IZNOP_Workoutv2.xls

                 

                If you want to download the OpenOffice link:  (See previous post for link to FREE Openoffice download)

                http://rapidshare.com/files/288594867/IZNOP_Workout_Open_Office.ods

                Thumbs Up Thumbs Up Thumbs Up

                  centsless's avatar - Me 20Oct%202016.jpg
                  TX/LOTTOLAND/USA
                  United States
                  Member #78380
                  August 13, 2009
                  2602 Posts
                  Offline
                  Posted: October 4, 2009, 5:27 pm - IP Logged

                  I'm working on posting bernie's version, my puter is very slow. :) I'll try to get that to you for your view.

                    centsless's avatar - Me 20Oct%202016.jpg
                    TX/LOTTOLAND/USA
                    United States
                    Member #78380
                    August 13, 2009
                    2602 Posts
                    Offline
                    Posted: October 5, 2009, 10:02 am - IP Logged

                    winsubloosesum, the worksheets are correct and working great! Thank you very much. I never could get bernie's version to upload for you to look at, but your version is coming up with the same numbers. Great job!

                     Now lets all make a little $$ :)

                      Avatar
                      chicago illinois
                      United States
                      Member #1199
                      February 26, 2003
                      377 Posts
                      Offline
                      Posted: October 5, 2009, 8:16 pm - IP Logged

                      I have been trying to download now for a couple of days will not work because I have AOL. will some one e-mail me the excel a sheet.

                        Avatar
                        connecticut
                        United States
                        Member #62464
                        June 28, 2008
                        64 Posts
                        Offline
                        Posted: October 5, 2009, 10:19 pm - IP Logged

                        this system does not seem to be hitting in connecticut i'll keep track with me fingers crossed

                          yiot's avatar - Lottery-050.jpg
                          california
                          United States
                          Member #69202
                          January 6, 2009
                          2645 Posts
                          Offline
                          Posted: October 6, 2009, 9:42 am - IP Logged

                          did you try whatever says on first post from bernie instruction number 5 and backtested

                            Avatar
                            North Carolina
                            United States
                            Member #50547
                            March 7, 2007
                            52 Posts
                            Offline
                            Posted: October 6, 2009, 9:53 am - IP Logged

                            I'm back folks.

                            First thanks to Mr Todd for restoring my account. I understand it was an automatic ban thing so I hold no grudge. I was new and didn't know the rules and was encouraged to post a link in my blog by a seasoned member, who also probably didn't know the rules about links applied to blogs for new players.

                            To my friend Truedookie thanks for making my situation known.

                            To all those who private mesaged me I could not get into Lottery Post so I could not see your messages.

                            To Winsumloosesum thanks for posting the Excel. You did it great even without the Twist. I like your Excel more than the one I did. Lol. Thanks.

                             

                            The twist works when you use the mirrors of the draws and difference to get the original IZNOP additions. But you use the original draws in adding and subtracting.

                            Just got online for the first time so will look and give Excel cell numbers later.

                             Hi Bernie,  I pulled up your system  under  Google.   But  I can not put the new #### in or delete the old ###  do you know what I am doing  wrong /   Thanks  ladyjane

                              yiot's avatar - Lottery-050.jpg
                              california
                              United States
                              Member #69202
                              January 6, 2009
                              2645 Posts
                              Offline
                              Posted: October 6, 2009, 10:08 am - IP Logged

                              on sept 28 check the mirror numbers, day as previous and night as last  draw and see what numbers are on OCT 1 and OCT 3 you got a str 000 and a box 140 you just get to test what days work best for your state hope this help you   for connecticut                   Lurking