The Bernie's Iznop SystemPrev Topic Next Topic

New Topic New Poll

winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Oct 4, 2009, 10:28 am

Quote: Originally posted by winsumloosesum on Oct 4, 2009
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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Oct 4, 2009, 10:54 am

Quote: Originally posted by winsumloosesum on Oct 4, 2009
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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Oct 4, 2009, 11:34 am

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

TX/LOTTOLAND/USA
United States
Member #78,378
August 13, 2009
2,687 Posts
Offline

Oct 4, 2009, 12:53 pm

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

TX/LOTTOLAND/USA
United States
Member #78,378
August 13, 2009
2,687 Posts
Offline

Oct 4, 2009, 1:11 pm

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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Oct 4, 2009, 1:45 pm

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

Oklahoma
United States
Member #45,969
September 1, 2006
5,000 Posts
Offline

Oct 4, 2009, 1:47 pm

Thanks a ton, works like a charm now!!

GOOD LUCK EVERYONE
truecritic

Michigan
United States
Member #22,394
September 24, 2005
1,583 Posts
Offline

Oct 4, 2009, 2:07 pm

Quote: Originally posted by winsumloosesum on Oct 4, 2009
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

TX/LOTTOLAND/USA
United States
Member #78,378
August 13, 2009
2,687 Posts
Offline

Oct 4, 2009, 5:27 pm

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

TX/LOTTOLAND/USA
United States
Member #78,378
August 13, 2009
2,687 Posts
Offline

Oct 5, 2009, 10:02 am

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 $$ :)
merdis salley

chicago illinois
United States
Member #1,199
February 26, 2003
382 Posts
Offline

Oct 5, 2009, 8:16 pm

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.
flatfrog

connecticut
United States
Member #62,462
June 28, 2008
64 Posts
Offline

Oct 5, 2009, 10:19 pm

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

california
United States
Member #69,200
January 6, 2009
2,741 Posts
Offline

Oct 6, 2009, 9:42 am

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

North Carolina
United States
Member #50,545
March 7, 2007
52 Posts
Offline

Oct 6, 2009, 9:53 am

Quote: Originally posted by BernieMadoff on Sep 27, 2009
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

california
United States
Member #69,200
January 6, 2009
2,741 Posts
Offline

Oct 6, 2009, 10:08 am

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

New Topic New Poll

Subscribe to this topic

The Bernie's Iznop SystemPrev TopicNext Topic

The Bernie's Iznop SystemPrev Topic Next Topic