Directory

Excel Work Product Samples:

1. Menu system for Vehicle Lease Tracking - novice users can maintain a complex database.

2. Interactive Breakeven Analysis - interactive graphics - financial operation dynamics.

3. Dynamic Business Planning Model - easy method for changing key financial assumptions.

4. Scrolling Data Table of Monthly Mortgage Payments - how Excel’s data tables are used.

5. Pricing / Sales Quotes for PC Repair Operation - sales reps can accurately quote proposal.

6. Sales Activity Tracking - track up to 12 user-defined weekly sales activities.

7. Quote System for CSR’s in Waste Management Industry - generate telephone quotes.

8. Metrics Dashboard - simple way to allow users to track multiple metrics every month.

9. Entrepreneur’s 5-Year financial model (Summary page) - 5-year forecasts.

10. Print Macros Page - ease of printing any reports.

Development Methodology
Excel-based applications created by Eric W. Augusta are designed and
implemented with these primary goals in mind:
• Accuracy
• Flexibility
• User-friendliness
• User-maintainability

Our development methodology - “Rapid Prototyping” - has three key steps:
1. Developing a basic understanding of the User’s end goals
2. Producing an initial, rapid prototype for client review
3. Collaborating with the client in a series of modification cycles

We believe this approach produces major benefits for clients, including:
• Faster development / lower cost
• Integrate dynamic requirements into the development cycle
• Higher overall end-user satisfaction

Please click links below to view examples of work products using this methodology (all examples are shown in PDF format).