Program Office Automation Archives

Project Management Tool greatly reduces time expended chasing disparate data

Written on August 22, 2019.

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.

Chart Package: Automating the updating of reoccurring presentations

Written on May 22, 2019.

May 2019 - OPDEC is experienced in automating the task of updating reoccurring presentations. The complexity depends on the amount of individual nuances built into the presentations. In this article, we’ll be discussing a generalized version of the Chart Package Tool; it is highly customizable.

Automating the Boeing Format 7 Report

Written on November 23, 2018.

November 2018 – OPDEC is very experienced in automating recurring standard reports for clients who want to reduce the burden of manual reports. One such example is the “Boeing Format 7” report. For many subcontractors to Boeing, this specific format report is a contractual requirement and is provided every month. These tend to be inherently tedious when built manually, but OPDEC can help eliminate or greatly reduce the amount of manual effort required. This article will discuss the creation of one such tool for the Boeing Format 7 report.

Latest Revised Estimate Tool

Written on September 23, 2018.

September 2018 - The Latest Revised Estimate (LRE) Tool is a custom, offline software solution utilizing Microsoft Office. It was initially developed as a proof of concept to introduce automation to the client team’s estimation process. The standard is for managers to continually update their estimations for how much money an effort will take to complete. As the task progresses, they can adjust their estimates to reflect any under or overruns.

Contractor Cost Data Reporting (CCDR) Tool

Written on June 23, 2018.

June 2018 - The CCDR Tool is an automation process that helps expedite the fulfillment of the Contractor Cost Data Reporting requirements. This is a tool that OPDEC has made several variations of, and we can synchronize it with either OPDEC’s IPM cost module or any other cost system utilized.

Analyze data consistency with OPDEC’s Data Trace

Written on February 23, 2018.

February 2018 - The Data Trace Tool is a piece of custom Microsoft Office automation software that OPDEC has developed in numerous variations. The generalized ideas behind the tool will be discussed in this article. Essentially, this tool is designed to analyze data consistency across multiple points of data entry.