I read over my earlier entries where I said I had given up on OpenOffice spreadsheets and the last comment was 22 Jul 09. True. I then started construction of the new spreadsheet with old software I have on hand (Lotus 1-2-3 - does anyone else still use it?). The new file is complete. It's highly unlikely that the client will use it in its original form - I'm certainly not happy with the requirements as requested - and I'll be working on the mods that I believe that it will be necessary to please both him and I. There are over 7.6 million formatted cells in the spreadsheet - no mean accomplishment - and a single data entry format. Best of all, the file can be converted to MS Excel, both the 2003 and 2007 versions, with a minimum of effort.
All in all, though, it's still a portion of the second phase of the project, and, as such, won't be used until the first phase is complete. It is a template, though, and will be the most important part of that phase. If I can keep the Lotus software usable, it'll save a tremendous amount of time since the conversion of data to formatted text files was and is easier in Lotus than in any other software.
As far as the lotteries are concerned, my next project will be the Lucky Lines game in Oregon.