Adolf is a LotteryPost member who has a formula in his blog which you may be interested in. It is probably what you are looking for.
I had it put together by a sister-in-law who is much more proficient than I at programming Excel spreadsheets. She had a hard time understanding its' purpose, so she went through 9 different versions so far as we emailed each other back and forth, until she was steered more correctly to the goal, and she still has some final touch-ups to add to make it look pretty!
She had her own little ideas to add to it so that it looked more personalized as she grasped for understanding as to what we needed and what we were projecting to do with it later when she understood the concept, so we let her imagination run wild as she had some fun with it.
I intend to release the completed version at no charge as soon as she is done with it after all the year-end celebrating. I suspect this will encourage the free-thinking and revealing of observations, methods and strategies which all lottery players make and use to keep the forums active with ideas and information flow.
For now, you can view Adolf's Excel Rundown Programming Data at :
https://www.lotterypost.com/blog/1952
I'm amusing myself with these little rundowns to see what they reveal. Many thanks to Adolf for posting this info.
LottoHackJack