Welcome Guest
You last visited September 30, 2020, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

# Pick 1/39 Random NUmber Generator for Excell?

Topic closed. 15 replies. Last post 7 years ago by adobea78.

 Page 1 of 2
 SageThread StarterDunwoody GeorgiaUnited StatesMember #747September 29, 2002685 PostsOffline March 10, 2014, 12:19 am⮟Good Morning Lottery Post family.  Awhile back someone  had said there was a Randon Number Generstor for the Fantasy 5 or Pick 5 game 1-39 balls written In Excell?  I was wondering if someone had a copy and if so would they be willing to  share it?  Thanks for taking the time to look. Dripping In Finesse for 2018!
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 10, 2014, 5:48 amhttps://app.box.com/s/549ldc2sckdp1hd0jsapInstructions:Open Excel file LotterRandomNumber.xlsmClick the tab at the bottom labeled GeneratorIn cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39In cell A3 enter "how many" sets you want to generate. Example 10 setsIn cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets. You can use this for any lottery game!!
 LottoBux25OntarioCanadaMember #109239April 9, 201160463 PostsOffline March 10, 2014, 10:30 amQuote: Originally posted by winsumloosesum on March 10, 2014https://app.box.com/s/549ldc2sckdp1hd0jsapInstructions:Open Excel file LotterRandomNumber.xlsmClick the tab at the bottom labeled GeneratorIn cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39In cell A3 enter "how many" sets you want to generate. Example 10 setsIn cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets. You can use this for any lottery game!!Thanks For Sharing winsumloosesum Simple Yet Effective.I Just Tried It Out For Keno(10/20/70 Game)
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 10, 2014, 1:46 pmQuote: Originally posted by LottoBux on March 10, 2014Thanks For Sharing winsumloosesum Simple Yet Effective.I Just Tried It Out For Keno(10/20/70 Game)Your welcome.I added an additional 2 Toolbars.The 2nd Toolbar will create your random sets in cell column O1The 3rd Toolbar will clear cell sets from column O.https://app.box.com/s/z0033jmmgr8v63s7sz7a Excel version 1997 - 2003https://app.box.com/s/14d3c9kobx65an6auzz7
 dr sanbgonÃ§alvesBrasilMember #92560June 9, 20103126 PostsOffline March 10, 2014, 3:53 pmHello Winsum, manages to put, yes of course depending on the size of the lottery in question   Generate rows or 3 or more bets without repeating digits example =   Lotto 50/5   01 05 15 29 45 12 18 39 44 14 22 25 35 48     No repetition number among the three lines
 SageThread StarterDunwoody GeorgiaUnited StatesMember #747September 29, 2002685 PostsOffline March 10, 2014, 9:45 pmQuote: Originally posted by winsumloosesum on March 10, 2014https://app.box.com/s/549ldc2sckdp1hd0jsapInstructions:Open Excel file LotterRandomNumber.xlsmClick the tab at the bottom labeled GeneratorIn cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39In cell A3 enter "how many" sets you want to generate. Example 10 setsIn cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets. You can use this for any lottery game!!What can I say? Thank you Steve!  You are truly the best of the best!!!  I know I can always count on you!Dripping In Finesse for 2018!
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 10, 2014, 10:11 pmQuote: Originally posted by Sage on March 10, 2014What can I say? Thank you Steve!  You are truly the best of the best!!!  I know I can always count on you!Your welcome!!If you want to create a random set of 20 (or other selections 10, 15 etc) numbers to wheel:1. In cell A1 enter the "lowest" ball number in your lottery.  Example 1/49 game low number ball is 12. In cell A2 enter the "highest" ball number in your lottery. Example 1/49 game high number ball is 493. In cell A3 enter "how many" sets you want to generate. Example 1 set4. In cell A4 enter the "total number" of balls drawn in your lottery game.  Enter 205. Click the Toolbar at the top.  The message box will display your 20 numbers to wheel.You can change the value to other values other than 20 in step 4 above.
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 10, 2014, 10:22 pmQuote: Originally posted by winsumloosesum on March 10, 2014Your welcome!!If you want to create a random set of 20 (or other selections 10, 15 etc) numbers to wheel:1. In cell A1 enter the "lowest" ball number in your lottery.  Example 1/49 game low number ball is 12. In cell A2 enter the "highest" ball number in your lottery. Example 1/49 game high number ball is 493. In cell A3 enter "how many" sets you want to generate. Example 1 set4. In cell A4 enter the "total number" of balls drawn in your lottery game.  Enter 205. Click the Toolbar at the top.  The message box will display your 20 numbers to wheel.You can change the value to other values other than 20 in step 4 above.
 pavizlo\$OKC, OKUnited StatesMember #120571December 22, 20111409 PostsOffline March 10, 2014, 10:49 pmQuote: Originally posted by winsumloosesum on March 10, 2014https://app.box.com/s/549ldc2sckdp1hd0jsapInstructions:Open Excel file LotterRandomNumber.xlsmClick the tab at the bottom labeled GeneratorIn cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39In cell A3 enter "how many" sets you want to generate. Example 10 setsIn cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets. You can use this for any lottery game!!Good stuff here, this is one of the things i like about Lotterypost site: when somebody is looking for some help, there are always a good people who are ready to help.Thank you Winsumloosesum,GOOD LUCK EVERYONE
 dr sanbgonÃ§alvesBrasilMember #92560June 9, 20103126 PostsOffline March 11, 2014, 8:41 amHello, Winsum. so you can generate = the user sends about 50 bets at random, only that they will be based, another tool based on the 50 random bets, others generate at most one or two numbers of each bet or wager is already in law of averages to hit one or two numbers in the first 50, which are the basis, then you can generate again, the 2nd generation, but need for it to generate enough in the first one is based, it would be done already counting that in the first generation random does not play, if thrown in the 2nd or 3rd generation of random, based on the first (discarding the first) or register gara sweepstakes and a maximum of two numbers from previous draws
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 12, 2014, 10:18 amAdded a Pick 3 and Pick 4 for Excel versions 1997 - 2003 .xls and 2007, 2010,nd 2013 .xlsmDownload Folder:https://app.box.com/s/9grn3jlg60wv8dxxvcmo
 ramSouth TexasUnited StatesMember #11December 6, 2001220 PostsOffline March 12, 2014, 12:52 pmThanks Steve,your hard work is greatly appreciated.
 winsumloosesumUnited StatesMember #2218September 1, 20036476 PostsOnline March 12, 2014, 2:54 pmAdded a Big Game Excel file for Mega Millions & PowerBall games:Download Folder:BigGameLotteryRandomSetGenerator.xlsm & BigGameLotteryRandomSetGenerator.xlshttps://app.box.com/s/9grn3jlg60wv8dxxvcmo
 SageThread StarterDunwoody GeorgiaUnited StatesMember #747September 29, 2002685 PostsOffline March 20, 2014, 2:10 pmQuote: Originally posted by winsumloosesum on March 12, 2014Added a Big Game Excel file for Mega Millions & PowerBall games:Download Folder:BigGameLotteryRandomSetGenerator.xlsm & BigGameLotteryRandomSetGenerator.xlshttps://app.box.com/s/9grn3jlg60wv8dxxvcmoSteve I can't thank you enough for all your years of service at the lottery post.  I don't care what I may have asked you to do over the past 5 10 years or however long it's been you have always rose to the occasion and made sure that I got exactly what I asked for!  Thank you from the bottom of my heart! People don't realize how much you could charge for all this work or how much other people would charge someone to make something in excel.  Thank you Steve!  You are The Best! Dripping In Finesse for 2018!
 SergeMEconomy classBelgiumMember #123696February 27, 20124035 PostsOffline March 20, 2014, 3:18 pmSweet code again.

 Page 1 of 2