August 2019 – In addition to OPDEC’s traditional software, we also offer services to develop custom, offline solutions for project management problems. These efforts can vary in purpose and permanence. Sometimes, these tools work as a proof of concept, and allow users to develop and refine an automation process before creating their own. In other cases, these tools are simply the most cost-effective solution. The goal, however, is always the same: reduce data errors and duplication of effort by introducing automation to improve standardization and efficiency.
The initial desire to create a custom solution came from a lack of reporting capability. The client rigorously maintained their project cost data, but still had difficulty interpreting it. During typical daily operations, the team frequently found themselves bogged down by manually creating and updating spreadsheets to answer simple questions. How much money did they plan to spend versus how much they actually spent? Why was the initial budget for the project insufficient? What other reasons contributed to the delay of materials or manpower needed to complete the project?
Management recognized the need to streamline their processes and allow their project managers more time managing projects rather than spreadsheets.
Through coordination between OPDEC and the team, the decision was made to manage the projects entirely in a custom tool; within it, their projects would be created, budgeted, scheduled, and maintained. Next, managers will export actuals data (dollars and labor hours spent) from their cost system and import it into this custom tool. This process was automated to simplify it down to a few mouse clicks.
All of the team’s project data is now centralized in the custom PM tool instead of interspersed between various team members. The projects entire life cycle could be managed from the tool, and team productivity increased to wide approval from both team members and management. Here’s a list of the functionality introduced by OPDEC.