Risk Management - Better, Faster, Easier - Software Demo
https://www.youtube.com/watch?v=ZUxo2S5htE8
Wednesday, November 2, 2022
Project Management - Better than XLS, but not too complex - Software Demo
Project Management - Better than XLS, but not too complex - Software Demo
https://www.youtube.com/watch?v=KwFd6Qo9G48
Tuesday, July 26, 2022
AS13100 Deadline Dec 2022 for Global Aerospace Engine Suppliers – APQP/PPAP is the missing link…
AS13100 Deadline Dec 2022 for Global Aerospace Engine Suppliers
– APQP/PPAP is the missing link…
https://www.linkedin.com/pulse/as13100-deadline-dec-2022-global-aerospace-engine-suppliers-cachat
Monday, May 16, 2022
Highly recommended Data Scientist & Data Engineer available
Highly
recommended Data Scientist & Data Engineer available.
“Roll up our sleeves” full-service consultant
specializing in cloud-based data analytics pipelines. Considering the migration
from dusty servers in the basement to the power of the cloud? Let's design,
spec, manage, and automate your data processes into seamless reports and data
dashboards. Previous projects with financial, research, and operational data
teams to shed hours off report requests and thousands off server bills.
Focus On Your Project, Not Hiring. Connect
with Jonathan Cachat, PhD to learn more.
Friday, April 15, 2022
Saturday, April 2, 2022
PeProSo PPAP Software Requirements Apr 2 2022
PeProSo PPAP Software Requirements Apr 2 2022
Intended Audience - part manufacturers (your suppliers
and/or plants)
- Process Flow Diagram (PFD),
PFMEA, Control Plan (CP), Gage Studies (GS), and DFMEA if needed
- PPAP Submission to customers,
internal, and from suppliers
|
Criteria |
Need/Want |
Yes / No |
Comments |
|
GENERAL EVALUATION CRITERIA |
|
|
|
|
Pricing
Model (Enterprise, Sites, Suppliers) |
|
Yes |
|
|
Pricing
Model (Named User, Concurrent User, Read Only User) |
|
Yes |
|
|
Payments
Terms (CapEx or Opex) |
|
Yes |
|
|
Vendor
financial stability |
|
Yes |
|
|
Vendor expertise / experience |
|
Yes |
|
|
Installation Options – either
on-premise or cloud/SaaS |
|
Yes |
|
|
Integration available |
|
Yes |
|
|
Customization available |
|
Yes |
|
|
Source code available |
|
Yes |
|
|
Global consulting / training
available |
|
Yes |
|
|
On Suppler site assistance
available |
|
Yes |
|
|
Supports both AIAG 4th
Edition and AIAG VDA Edition FMEA |
|
Yes |
|
|
Complicated User Security
settings |
|
No |
Having to define, designate, and modify user
roles and responsibilities (create new, edit, delete, etc.) is too
complicated – they will go back to spreadsheets. Baby step – is this better than
spreadsheets? |
|
Complicated Workflow management |
|
No |
Having to define all sorts of rules to
automate the PPAP process is too complicated – they will go back to
spreadsheets. Baby step – is this better than spreadsheets? |
|
Hashtag like search capability |
|
Yes |
|
|
Spreadsheet Like Screens |
|
|
A database app should provide
similar spreadsheet like capability including: -
Ability to store personal setup (related to
single user) -
Ability to search/filter each column. -
Export to spreadsheet (where applicable) -
Export to PDF (where applicable) Move columns, hide columns, filter
columns – real time report writer capability for lists of parts, projects,
and studies. In Project Forms – freeze columns,
hide columns, etc. |
|
Spell
Checking |
|
Yes |
Automatic real time spell checking during data entry – no more
mistakes from forgetting to run the spell checker in the spreadsheet before
submitting documents. |
|
Smart Lookup Filtering |
|
Yes |
The lookup list gets shorter as information is entered. |
|
Action Tab – My To Do List |
|
Yes |
A single place to see all your
project tasks, across all projects, FMEA action items, and more. |
|
Supports multiple/additional languages
(i.e., English, Spanish, Chinese, etc.) |
|
Yes |
More can be added... |
|
INITIAL SETUP and CONFIGURATION |
|
|
|
|
Ability to import Customer list. |
|
Yes |
|
|
Ability to import part list. |
|
Yes |
|
|
Ability to import Supplier list. |
|
Yes |
|
|
Manage multiple Gage Study Types |
|
Yes |
|
|
Manage multiple Operation Types. |
|
Yes |
|
|
Manage multiple plants / locations, |
|
Yes |
|
|
Manage multiple Product Type. |
|
Yes |
|
|
Manage multiple Product
Classification Types. |
|
Yes |
|
|
Manage multiple Process
Classification Types. |
|
Yes |
|
|
Manage multiple Project Types. |
|
Yes |
|
|
PART RECORDS |
|
Yes |
|
|
Part Number |
|
Yes |
Part Number detail includes a few
mandatory fields, and then a lot of flexibility, including Search Tags field,
like Hashtag capability, for searching and finding information not available
in standard fields. |
|
Part Revision History |
|
Yes |
A Part Revision History is maintained,
with a flexible Revision Level formatting.
This eliminates the need for the old “Part History” form. |
|
Part - Jump to Projects |
|
Yes |
There is a direct link to Projects
(PPAP Submission) on the Part Number screen, by revision level. |
|
Part - Import product
characteristics |
|
Yes |
|
|
Part – Geometric
Dimensioning and Tolerancing (GD&T) symbols |
|
Yes |
|
|
Part - Import process
characteristics |
|
Yes |
|
|
Part - Import operations |
|
Yes |
|
|
Part - Import Bill of Material
(BOM) |
|
Yes |
|
|
Part – Manage projects with
multiple part revisions at same time. |
|
Yes |
|
|
Part – Document revision control |
|
Yes |
|
|
Part – Track suppliers we buy
from |
|
Yes |
|
|
Part – Manage customer we sell
to |
|
Yes |
|
|
Part – Upload attachments
(design record(s), etc.) |
|
Yes |
|
|
Part Family - Manage reusable
product characteristics. |
|
Yes |
|
|
Part Family - Manage reusable
process characteristics. |
|
Yes |
|
|
Part Family - Manage reusable operations. |
|
Yes |
|
|
Product Family &
reusable knowledge |
|
Yes |
A new PFMEA is not required for every
part. A new Gage Study does not have
to be done on every part. This is a
huge cost savings. |
|
PROJECTS - PPAP SUBMISSIONS |
|
|
|
|
Projects |
|
Yes |
Projects
is where APQP or PPAP projects are created.
This is where “forms” are created and managed, using the database
View. There is complete flexibility on
how Projects are created regarding what Part Number / Revision level is
used. Multiple Projects can be open at
the same time, on the same Part Number and Part Revision level, or the same
Part Number with different Part Revision Level, to allow complete flexibility
to handle multiple customer / supplier submissions at the same time based on
what Part Revision manufacturing is currently producing. This can also handle the issue across
multiple plant locations for internal projects. A
Project is defined by the following: -
Part
Number / Name and revision level -
Which
Customer to be sent to, or if Internal, or if coming from a Supplier – this
project is based on only one of these options -
Start
and End Date -
Status Project
Revision History is maintained |
|
PPAP Submission Process |
|
Yes |
Very flexible PPAP Submission process,
including, multiple partial submission, full submissions, and
re-submissions. The PPAP Project
status includes: Pending, Interim, Approved, and Rejected |
|
Project - Ability to assign each
PPAP package a project number, associated program, and other unique
identifiers (tagging for traceability) |
|
Yes |
|
|
Project - Ability to create
customer specific requirements. |
|
Yes |
|
|
Project - Form Data Columns –
Hide, Sort, and Pin options |
|
Yes |
|
|
Project - Form Data Rows – add
below, copy below, move (drag and drop) |
|
Yes |
|
|
Project - Form Data Rows – hide
/ view rows in PFD, PFMEA, CP |
|
Yes |
|
|
Project All Forms view- PF,
PFMEA, CP all in a single view |
|
Yes |
|
|
Project Form Configurator – PFD,
PFMEA, CP |
|
Yes |
|
|
Project Form FMEA Action Item Tracker |
|
Yes |
The right side of the FMEAs
forms come to life with the Action Item tracking capability – assigned to and
due sate tracking. |
|
Project Form Family – manage
reusable lookups (control methods, failure modes, failure effects, process
controls, measurement techniques, sample size, frequency, reaction plan,
devices, etc.) |
|
Yes |
|
|
Project Form Templates |
|
Yes |
A
database Form Template will include the ability to configure and store and
reuse a Form View – for example OLD versus NEW FMEA views, this Customer view
versus that Customer view, etc. The
View Template allows the configuration of almost any form. |
|
Project Forms – ability to
create multiple views, including dimensional control plans (DCP) and other
combinations of PFD, PFMEA, ad CP information. |
|
Yes |
|
|
Project forms - PFD ability to
auto-populate steps into PFMEA |
|
Yes |
|
|
Project forms - PFMEA ability to
auto-populate steps into CP |
|
Yes |
|
|
Project forms - PFMEA ability to
expand rows to capture multiple failure modes, causes, and effects |
|
Yes |
|
|
Project Forms - Provide users
visibility within drop down with standard S, O, D descriptions |
|
No |
The training and documentation
are a separate subject. No one using
spreadsheets complained that they could not remember the 1-10 ratings
descriptions. |
|
Project Forms - provides
automatic merge cell view |
|
Yes |
|
|
Project Forms - Right side of
FMEA - action item tracking |
|
Yes |
|
|
Project Forms Publish option |
|
Yes |
|
|
Project Forms revision control |
|
Yes |
|
|
Project Gantt Chart |
|
Yes |
A database app will include
a simple Gantt chart, without all the hassles of a MS Project like tool, and
more flexibility. Allow for tasks to be related
to the Gantt Chart and have a start and end date attributed to them, then
show as graphical representations on the chart. If a task has just an end
date, it will be show on the Gantt chart as a milestone. |
|
Project Meetings |
|
Yes |
If needed, you can record
the cross functional team involvement in the process. If you are assigned to a team, you will
receive an email notification. |
|
Project Tasks – attachments |
|
Yes |
initial process capability
studies, inspection results FAIR, Process Capability Studies, etc. |
|
Project
Tasks - Templates |
|
Yes |
A task template is re-usable task list
– for example, the 18 PPAP items, an APQP task list, or any customer specific
tasks, and more. |
|
Project Tasks - Tracker |
|
Yes |
A simple task management
process with flexibility to customize the task list. A simple timeline with assignments and due
dates is available. By design, this is
NOT a MS Project like tool – you are not forced to do anything to use the
Task Tracker. A new Project can be
created by combining multiple task templates, as needed for this new Project. If you are assigned a task, you will
receive an email notification. |
|
Project Tasks – ability to have
unlimited sub-tasks |
|
Yes |
|
|
Project Tasks - Gantt charting
display with sorting option |
|
Yes |
|
|
Project Tasks – spreadsheet like
data entry |
|
Yes |
|
|
Project Tasks - configurator |
|
Yes |
Ability to have multiple task
templates for different PPAP submission rules – internal and customer and
suppliers. |
|
Ability to select applicable
PPAP deliverables by project/part/families. |
|
Yes |
|
|
Project - Team Members
(customers, employees, suppliers) |
|
Yes |
Keep track of who has been
involved. Upload video conference
files as an attachment. |
|
Projects - Publish user
definable PPAP submission elements into one PPAP zip file. |
|
Yes |
|
|
Projects – manage internal
projects. |
|
Yes |
|
|
Projects – manage same part from
multiple suppliers. |
|
Yes |
|
|
Projects – manage same part to multiple
customers. |
|
Yes |
|
|
Projects
- Ability to retain PPAP form revisions & audit trails for each PPAP
element for document history progressions. |
|
Yes |
|
|
Projects
- Ability to capture revision levels for each PPAP element. |
|
Yes |
|
|
Projects
- Ability for all documents associated with PPAP submission to be locked when
full disposition of the PPAP submission is established and all actions are
completed. |
|
Yes |
|
|
Project
- Ability to add additional fields to track data PPAP elements related to a
part/product (i.e. customer specific requirements) |
|
Yes |
|
|
Project
Forms - Automatic linkages between the DFMEA and PFMEA |
|
Yes |
|
|
Project
Forms - Ability to be flexible & configurable to standard format changes
(e.g. deleting columns on FMEAs, auto updates not forced, customizable
templates and dashboard, reshuffling of column/rows, headers customizable,
etc.) |
|
Yes |
|
|
Project
- Ability to distinguish between pre-production and production for control
plan (and other deliverables) |
|
Yes |
|
|
GAGE STUDIES |
|
|
|
|
Gage Studies |
|
Yes |
One (1) Attribute and Two
(2) Variable studies -
GR&R
Attribute Hypothesis Test Method -
GR&R
Variable Tolerance and TV Methods -
GR&R Anova Method |
|
Gage Studies Minitab Users |
|
Yes |
Two points: 1st. If you are
ONLY using Minitab for Gage Studies, a single named user license is $1,200
per year. Source 2nd The Minitab
Gage Studies reports are complicated, and annoying to your employees and
customers – a simple report that shows the results is preferred by most. |
|
Gage Studies – reusable across
multiple PPAP Submissions |
|
Yes |
Gage studies can be stored
in a library and reused in multiple projects. |
|
SYSTEM MANAGEMENT |
|
||
|
Ability to export PPAP package
from software for local storage (ease of access) |
|
Yes |
|
|
Ability to use single sign-on
(external & internal) |
|
Yes |
|
|
Ability to have a data back-up system. |
|
Yes |
|
|
Ability to support multiple/additional
languages (i.e., English, Spanish, Chinese, etc.) |
|
Yes |
John M. Cachat
PeProSo, LLC
jmc@peproso.com
www.linkedin.com/in/johncachat - happy to connect
Work travels at the speed of trust…
Subscribe to:
Posts (Atom)
