Prof Hitts GreenBook in Excel Formula

Published:

Updated:

abcdEnter   GreenBook 3&4
152Last          
4586Draw          
       Pick-3
=A2=B2=C2  =F5=G5=H5  
     =MOD(F5-1,10)=MOD(G5-1,10)=MOD(H5-1,10)  =MOD(K5+1,10)=MOD(L5+2,10)=MOD(M5+3,10)  
     =MOD(F6-1,10)=MOD(G6-1,10)=MOD(H6-1,10)  =MOD(K6+1,10)=MOD(L6+2,10)=MOD(M6+3,10)  
     =MOD(F7-1,10)=MOD(G7-1,10)=MOD(H7-1,10)  =MOD(K7+1,10)=MOD(L7+2,10)=MOD(M7+3,10)  
     =MOD(F8-1,10)=MOD(G8-1,10)=MOD(H8-1,10)  =MOD(K8+1,10)=MOD(L8+2,10)=MOD(M8+3,10)  
     =MOD(F9-1,10)=MOD(G9-1,10)=MOD(H9-1,10)  =MOD(K9+1,10)=MOD(L9+2,10)=MOD(M9+3,10)  
     =MOD(F10-1,10)=MOD(G10-1,10)=MOD(H10-1,10)  =MOD(K10+1,10)=MOD(L10+2,10)=MOD(M10+3,10)  
     =MOD(F11-1,10)=MOD(G11-1,10)=MOD(H11-1,10)  =MOD(K11+1,10)=MOD(L11+2,10)=MOD(M11+3,10)  
     =MOD(F12-1,10)=MOD(G12-1,10)=MOD(H12-1,10)  =MOD(K12+1,10)=MOD(L12+2,10)=MOD(M12+3,10)  
     =MOD(F13-1,10)=MOD(G13-1,10)=MOD(H13-1,10)  =MOD(K13+1,10)=MOD(L13+2,10)=MOD(M13+3,10)  
     =MOD(F14-1,10)=MOD(G14-1,10)=MOD(H14-1,10)  =MOD(K14+1,10)=MOD(L14+2,10)=MOD(M14+3,10)
          
       Pick-4  
=A3=B3=C3=D3  =F18=G18=H18=I18
     =MOD(F18-1,10)=MOD(G18-1,10)=MOD(H18-1,10)=MOD(I18-1,10)  =MOD(L18+1,10)=MOD(M18+2,10)=MOD(N18+3,10)=MOD(O18+4,10)
     =MOD(F19-1,10)=MOD(G19-1,10)=MOD(H19-1,10)=MOD(I19-1,10)  =MOD(L19+1,10)=MOD(M19+2,10)=MOD(N19+3,10)=MOD(O19+4,10)
     =MOD(F20-1,10)=MOD(G20-1,10)=MOD(H20-1,10)=MOD(I20-1,10)  =MOD(L20+1,10)=MOD(M20+2,10)=MOD(N20+3,10)=MOD(O20+4,10)
     =MOD(F21-1,10)=MOD(G21-1,10)=MOD(H21-1,10)=MOD(I21-1,10)  =MOD(L21+1,10)=MOD(M21+2,10)=MOD(N21+3,10)=MOD(O21+4,10)
     =MOD(F22-1,10)=MOD(G22-1,10)=MOD(H22-1,10)=MOD(I22-1,10)  =MOD(L22+1,10)=MOD(M22+2,10)=MOD(N22+3,10)=MOD(O22+4,10)
     =MOD(F23-1,10)=MOD(G23-1,10)=MOD(H23-1,10)=MOD(I23-1,10)  =MOD(L23+1,10)=MOD(M23+2,10)=MOD(N23+3,10)=MOD(O23+4,10)
     =MOD(F24-1,10)=MOD(G24-1,10)=MOD(H24-1,10)=MOD(I24-1,10)  =MOD(L24+1,10)=MOD(M24+2,10)=MOD(N24+3,10)=MOD(O24+4,10)
     =MOD(F25-1,10)=MOD(G25-1,10)=MOD(H25-1,10)=MOD(I25-1,10)  =MOD(L25+1,10)=MOD(M25+2,10)=MOD(N25+3,10)=MOD(O25+4,10)
     =MOD(F26-1,10)=MOD(G26-1,10)=MOD(H26-1,10)=MOD(I26-1,10)  =MOD(L26+1,10)=MOD(M26+2,10)=MOD(N26+3,10)=MOD(O26+4,10)
     =MOD(F27-1,10)=MOD(G27-1,10)=MOD(H27-1,10)=MOD(I27-1,10)  =MOD(L27+1,10)=MOD(M27+2,10)=MOD(N27+3,10)=MOD(O27+4,10)
Entry #79

Comments

Avatar adolf -
#1
Just copy & paste to your excel sheet...

Good Luck!!
adolf
Avatar adolf -
#2
This Excel Formula is a automation systems

(keep it simple)

It's Pick-3 contains 2,000 complete rundowns

&

It's Pick-4 contains 22,000 complete rundowns

Good Luck!
Adolf
Avatar emilyg -
#3
thank you adolf.
Avatar adolf -
#4
Emilyg..I Hope you enjoy it...you are #1 in my book...
Avatar adolf -
#5
My new project is Fantasy lotteries math for pick3,pick4,pick5,pick6,jackpots,keno

http://www.fantasylotteries.com

Fantasy Lotteries and Mathematics is a 208-page comprehensive program that builds on the success of Fantasy Pick-3 and Fantasy Pick-4. The program includes lesson plans, 46 worksheets, 46 quizzes, graphs, box scores, number values for 295 players, a comprehensive pre- and post test, and step-by-step instructions on how to implement the game into curricula as well as how to access statistics online.

Students can play Fantasy Lotteries  from early January until Christmas, giving them well over twelve months to enjoy the excitement and drama this dynamic game brings to the learning environment. Students get the opportunity to lotto teams, decide on starting lineups, make tracks, and manage franchises as they see fit. This autonomy is a natural fit for their social and cognitive development.

Fantasy Lotteries and Mathematics is the perfect curriculum for summer school programs. In addition, for those teachers who teach the same students in consecutive years, imagine picking up the game in the fall where you left off at the beginning of summer vacation.

The inclusion of 165 different scoring systems gives teachers and parents the opportunity to customize the content according to the skill level of their students. Scoring systems are based on fractions, decimals, exponents, roots, integers, summations, factorials, absolute value, or a mixture of all of the above.

Several of the practice worksheets are designed to be used with a graph, thereby facilitating learning for visual learners and learning-disabled students. Examples of concepts that are woven into worksheets include ratio and proportion, percentage of price increase/decrease, finding a percent of a number, operations with integers, fractions, and decimals, and data depiction including box and whisker graphs, scatter plots, and stem-and-leaf plots. Additional concepts include functions, solving linear equations, Pythagorean Theorem, and mean, median, mode, and range.

Fantasy Lotteries and Mathematics continues the tradition of providing meaningful, innovative curriculum that engages students so they can make connections between math at home and math at school.
Avatar adolf -
#6
I found a number counting system...like the card counting system..so lets break the lottery

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register