I feel the need to get back into an Excel-based system for dealing with the PA Mid-Day drawings...
I don't play them, and don't plan on it unless backtesting shows success, but I am more interested in seeing if any of my rusty VB skills can be carried over into Excel's built-in VBA (something I can trudge through, but not fluently).

Simple Plan

Objective... Beat the PA mid-day computerized pick3/pick4, not talking reducing number pools or trapping, but really beating them at their own game using seed manipulation and some keen observation and testing to "synchronize" (props to GURU for the original idea) the Excel RNG with PA's RNG.

Requirements...
1.) Use ONLY Excel, since that is something more readily available should this become a group project. (any hardy souls with either excel2000 or excel2002 (XP) feel free to jump right in)
2.) HEAVILY documented VBA code. (proper comments and descriptive component names)
3.) Try and document every possible scenario (RNG a 3/4 digit number in one shot vs. RNG 1 number 3/4 times with a shift in the time as the seed modifier)