Capabilities Illustrated
This section goes past the words and attempts to visually depict my capabilities. I wanted to illustrate some of the projects I've worked on in different categories. Although my training in these various disciplines is self-acquired and not necessarily at expert level it may at least show my familiarity with them. And, hopefully, a bit of my versatility.
Form Design
This is a bill of lading I designed to avoid the agony of repetition--manually writing dozens of these every day was frustrating when everything else we did was computerized. I took the best elements from a number of predesigned forms and made my own to cover nearly any contingency. If features auto-dating and auto-numbering as well as auto-fill for common fields. In addition all check boxes and totals are computerized. Package 'type' may be selected from a drop-down list (not shown here). It was written using OmniForm and will easily integrate with a database application.
Spreadsheets
Sample #1
A spreadsheet doesn't necessarily have to look like a spreadsheet. Witness this "Nascar Tire Setup Calculator". Although this is not one of my "work" spreadsheets it is one of my design concepts. I always incorporate formulae into the spreadsheets I create; however, most of these here are from programs freely circulated among Nascar PC racing enthusiasts. The second picture shows that the program is actually part of an Excel spreadsheet. To prove that it is a working example the sheet is available for download from the side bar. If you want to run it you will need to allow/enable macros.
Sample #2
A customer complained that we were seriously late with the majority of our deliveries. They were seeking recompense in the form of a discount on all late orders. As the company was a major customer we were accustomed to accepting their demands. Since they sent a spreadsheet as proof it was almost a foregone conclusion that they would have their way. I took the data and added our records in and crunched it. Their spreadsheet was seriously flawed. In addition to many duplicate entries and erroneous dates they didn't take into account working days and non-working days. I did. My employer sent the customer a copy of my report and nothing more was said. I never calculated how much money was saved in the process but it would have been easy enough.
This down & dirty worksheet was prepared using Excel 2000 with the Analysis ToolPak Add-in installed. The workday calculations will not work properly without it. If you are inclined to check it out you will need to have this installed. It is found under Tools > Add-Ins in the Standard Toolbar.
