Developed an Excel budgeting spreadsheet application to replace difficult to use AS/400 screens. The application imported a flat file of preliminary data from the AS/400, and created the various department spreadsheets. Department management entered new budget information and when they were satisfied, clicked a button on the sheet that copied the data to a central repository spreadsheet that compiled the data in summary and detail P&L statements for senior management review. Upon their approval, the data was automatically exported as a flat file that was updated to the AS/400.

Client was concerned about old financially sensitive documents being passed around, so we used VBA to allow a user to enter an expiration date for a MS Word document. When the date passes, the document automatically deletes its contents and refuses to open. Tried, but failed, to get the computer to emit blue smoke.

Our client was receiving lead information from their website in a word document that simply appended form submits one after another. This format was totally unsuitable for any further data manipulation, so we wrote a conversion program that took the one field per row layout, ignoring all of the extraneous formatting, and rewrote the data as true comma delimited ASCII file that they could easily import into a program.