Client: Global aerospace manufacturer / defense contractor
Users: Engineers, financial analysts, program managers
Project evaluation-investment analysis system based in Excel with data storage via ADO and Access:
- Tracks a gated project management process with separate workflows for the user and the administrator.
- Facilitates the capital budgeting process for the maintenance operations of a large jet engine fleet.
- Features project-level and dataset-level objects for chronological data capture and historical audit views.
- Accepts user input through an extensive MSForms UI and runs a detailed cash flow / NPV model to compute a score for each project.
- Supports decision-making with a global ranking function and division-level reporting.
-
- Main
-
- Add Project
-
- Project Properties 1
-
- Project Properties 2
-
- Project Properties 3
-
- Project Properties 4a
-
- Project Properties 4b
-
- Project Properties 5
-
- Select Project 1
-
- Select Project 2
-
- Find Project 1
-
- Find Project 2
-
- Add Project Note
-
- Edit DataSet 1
-
- Edit DataSet 2