There will be two versions of the script.

1. Build.

Using loops and passing in info such as the first year of the game (at it's current matrix, where relevant), the game code and the csv file to create will allow a massive script to be generated that will create fresh and accurate full history files. This will also form the basis of the next version...

2. Update.

Here is the version that will make it into the app... it will pass in the name of the file to update, checking the last entry for the last update, and building a lost of draws to append to each csv file... for all games!

Will test with a single year on build, then test with update for reading dates from files and appending only draws ahead of the last date point.

The goal here is to reduce the current process to a few button clicks and get results in minutes or seconds rather than the current time consuming manual processes.

It comes down to a vision... I have a vision of being able to run this app on a mobile device at home (or anywhere) and have results when I get to the kiosk. Then it does not matter the work schedule or other time commitments, a pick will always be readily available. It might be fun to cycle through pick 2 through pick 5, or alternate between match 6 and cash 5. Also to be able to flip between power ball and mega millions...

The app will also have the ability to check for wins in a cycle, and make a notice when a current cycle is about to expire. If I take my time with it, it might also track expenses with a nifty periodic profit and loss statement.

If I find some new or altered idea, it will be easy to update since I am creating the entire app.

Either way it will be good experience to create and maintain an entire code base for multiple platforms (Desktop and Android). Code, comments, documentation, maintenance... It is literally making my own tutorial!