[+] enlarge |
- Project Title: Uptime Reports
- Category: Excel Applications
- Description: Monitor up-to-date interactive reports based on data files. This report utilized five raw data files and created a custom easy to read report for tracking purposes.
|
[+] enlarge |
- Project Title: Client Billing
- Category: Excel Applications
- Description: Program to enter different client and billing criteria and create automated invoices. This application was used by field staff to log their work, keep a record, generate an invoice, and on daily basis email a report to corporate headquarters.
|
[+] enlarge |
- Project Title: Purchase Order Creator
- Category: Excel Applications
- Description: Display products from two distributors, select the best prices, and create Purchase Orders. Upon importing a client order, data was pulled from two vendors as well as in-stock database. User was able to "cherry pick" different items from different vendors based on price and automatically create Purchase Orders to be sent to each vendor.
|
[+] enlarge |
- Project Title: Excel VBA Program - User Interface.
- Category: Excel Applications
- Description: Complex Excel VBA project with over 4,900 lines of code. Developed for 80 simultaneous users, grabbing and returning data from 6 different sources, with 16 Procedures (16 separate Macro Modules), to allow users to split workload among themselves.
This is the user interface, utilizing clickable icons for highest level of ease of use and simplicity. A "Please Wait" message pops up letting the user know that database is currently not available and a count-down begins until the DB becomes available or the program quits.
|
[+] enlarge |
- Project Title: Excel VBA Program - Start Page
- Category: Excel Applications
- Description: Complex Excel VBA project with over 4,900 lines of code. Developed for 80 simultaneous users, grabbing and returning data from 6 different sources, with 16 Procedures (16 separate Macro Modules).
This is a demonstration of a typical program title page and user interface. All programs are designed for professional, commercial-grade interface and stability.
|
