AutoDCP vs. Excel

AutoDCP And Excel comparison

With AutoDCP you create the data and it creates the Excel documents. With Excel you are a clerk - with AutoDCP you are an engineer. Here are some key differences in building APQP documents (Process Flow Diagram,  FMEA and Control Plan) the hard way in Microsoft Excel versus the automation in AutoDCP:

Automation Type AutoDCP Excel
Linking AutoDCP is integrated. The Process Flow, FMEA and Control Plan are linked. The project, process and characteristic information is entered in only one place and automatically updated in all documents. Must manually edit each document and achieve consistency with a lot of effort. This is a common source of audit issues.
Formatting AutoDCP creates multiple documents from the same information, i.e. four different process flow diagrams, eight different FMEA formats, three different Control Plans. This makes it easy to reuse existing information for multiple customers with different requirements. Can be done by creating multiple spreadsheets with formats for multiple customers. Requires additional effort.
Automatic Creation Auto Fill feature matches the process steps and characteristics in the current project with all others and populates the current FMEA with matching information. Extremely fast way to create new projects using templates. Unavailable.
Risk Profiles populate characteristics in the FMEA with the entire block of records rather than construction one record at a time. Unavailable.
AutoPFMEA command language automatically constructs the FMEA. Up to 100 times faster than anything that can be done in Excel. Unavailable.
AutoDCP command language automatically constructs the Dimensional Control Plan. Up to 100 times faster than as anything that can be done in Excel. Unavailable.
Engineering changes can be implemented across all affected projects in the database with a single click.  Unavailable. Must manually edit each affected record in each project.
Line balancing is accomplished by identifying which process to move characteristics to. All of the FMEA and Control Plan information is moved with a single click. Unavailable. Can be manually accomplished with considerable effort.
Standard Data Libraries are used for failure modes, effects, causes and controls on the FMEA. Using standard values eliminates typing and enables statistical analysis. Difficult to accomplish and makes analysis impossible.
User Assist Auto Save feature provides single click population of cells or records. Copy / paste. Requires more effort.
Process Specific Lists offers a way to use just the portion of libraries relevant to the current process step or operation. Unavailable.
Smart List option automatically shrinks the libraries as a record is constructed to only the values previously used on past FMEAs. Great for helping an inexperienced engineer learn a process. Unavailable.
Mass update feature will update several characteristics simultaneously. Great for adding a failure mode to multiple records. Unavailable.
Op History feature offers a simple way to copy records from other FMEAs to avoid mistakes. Copy / paste. Requires more effort.
Saved rules gives easy access to the most frequently used records for quick copying to the current FMEA Unavailable.
Quality Improvement Automatic identification of incomplete FMEAs, Control Plans. No more audit surprises. Unavailable.
On demand FMEA analysis across all projects Unavailable.
Automatic scoring of improvement Unavailable.
Executive Dashboards Unavailable.
Finch Risk Diagrams Unavailable.

Contact Us  |  Site Map