Tracking PPAP On Time Completion using Excel

V

vardar3

#1
I want to create a metric in excel 2007 for tracking whether PPAPs were completed on time.
? I have a "start date" a "due date" and an "end date" in same row, different columns
? How could get a “yes” “no” response to whether or not the PPAP was completed in time?
 
Elsmar Forum Sponsor
R

rsimano

#2
Re: Tracking PPAP on time completion

Make a "Completed On Time" column and use this function

=IF("DUE DATE" = 0, "",IF("END DATE" = 0,"",IF("DUE DATE" < "END DATE","NO","YES")))

Replace both "DUE DATE" and both "END DATE" with the cell location of their corrisponding data.

This will diplay YES or NO depending on if the completion time was before or after your Due date. If it was completed on the due date it will still display YES. If you have empty data in Due Date or End Date it will show blank.

EDIT: It would probably be good to wrap this in an =IFERROR( X ,"ERROR") where X is everything after the = symbol. This will display ERROR if the information in the 2 different cells dont match. (ex. Trying to calulate numbers and text in the same formula or different variable types otherwise Exel may throw back an error message to you if the data is incorrect)
 
Last edited by a moderator:
Thread starter Similar threads Forum Replies Date
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
V PPAP Tracking Log wanted Document Control Systems, Procedures, Forms and Templates 3
I PPAP in GQTS (GM's Global Quality Tracking System)? APQP and PPAP 11
QMMike Tracking of PPAP Timing and Sample Deliveries APQP and PPAP 1
N On-Time Supplier PPAP Tracking APQP and PPAP 3
W PPAP On-Time Tracking procedure wanted IATF 16949 - Automotive Quality Systems Standard 3
R PPAP Manual 1.2.2.7 Dimension Result Report and Tracking Samples APQP and PPAP 3
J Designing new gauge tracking software IATF 16949 - Automotive Quality Systems Standard 4
Q 21 CFR 821 Medical Device Tracking 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Q Tracking Procedure Revisions (Document Control) Document Control Systems, Procedures, Forms and Templates 9
samer Acceptable limits for Spills - Tracking Hydraulic Spills ISO 14001:2015 Specific Discussions 3
M Standards Subscription Service and Standards Tracking Service Pros and Cons? Other US Medical Device Regulations 3
R Software change control process and defect tracking ISO 13485:2016 - Medical Device Quality Management Systems 1
I Tracking Protoype Changes; 8D or simple document revision? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
S Tracking laptop movement inside the office IEC 27001 - Information Security Management Systems (ISMS) 7
I Corrective Action Tracking for Product and Process in the same system? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
J Training Record Template and tracking Document Control Systems, Procedures, Forms and Templates 1
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
Q Tracking savings - Long term projects and the day to day decisions Preventive Action and Continuous Improvement 5
J Tracking-Calibration Software Calibration and Metrology Software and Hardware 3
A Order Confirmations 7.4 - Tracking Purchase Order Confirmations from Suppliers AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 4
M Tracking External Oversight at a large Naval Shipyard Quality Manager and Management Related Issues 9
J Using a Rhode FSH6 Tracking Generator General Measurement Device and Calibration Topics 2
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 6
kmyers Processing Time Tracking Software Program Help Needed Lean in Manufacturing and Service Industries 3
C Reagent tracking in an ISO 17025 laboratory ISO 17025 related Discussions 2
J Software and Methods for Tracking CAPA (Corrective and Preventive Action) items US Food and Drug Administration (FDA) 3
N What is the Cost of Tracking Non-Conforming Product Nonconformance and Corrective Action 5
P Need suggestion on Software or App for Tracking Quality Plan Status Software Quality Assurance 1
A Ensuring Tooling Use Tracking and Traceability AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 1
D Tracking response time with individual label I.D. Statistical Analysis Tools, Techniques and SPC 6
I Tracking changes in ISO Standards Other Medical Device Related Standards 12
G Tracking Employee Training Software Training - Internal, External, Online and Distance Learning 7
B Need help tracking training for my business Quality Assurance and Compliance Software Tools and Solutions 3
K Fast Response Tracking Board (QSB+) Customer and Company Specific Requirements 6
L OTD (On Time Delivery) Tracking and Reporting Misc. Quality Assurance and Business Systems Related Topics 13
J Tracking and Traceability of Finished Goods ISO 13485:2016 - Medical Device Quality Management Systems 6
S ISO9001:2008 - Effectiveness Tracking for Nonconformance ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
A Identifying and Tracking Customer Specific Requirements Customer and Company Specific Requirements 1
S Presentation for tracking Quality Objectives across sites Preventive Action and Continuous Improvement 3
Marc Does this browser make me look fat? Opting out of tracking ads After Work and Weekend Discussion Topics 1
S Internal Quality Audit Tracking Sheet with Auto Report Excel .xls Spreadsheet Templates and Tools 1
B How to begin tracking FPY (First Pass Yield) and "Downtime" tracking Manufacturing and Related Processes 3
C Medical Device Tracking Sampling Plan using MIL-STD-105E Other US Medical Device Regulations 4
R Tracking Corrective Actions using an Excel sheet Excel .xls Spreadsheet Templates and Tools 7
M Tracking New ISO Document Releases Other Medical Device Related Standards 4
C Tracking Spills as an Environmental Aspect Miscellaneous Environmental Standards and EMS Related Discussions 7
D Gage Tracking Systems - Infinity's QS GTS System and Retired Gages General Measurement Device and Calibration Topics 4
N Please Review My Tracking System Document Control Systems, Procedures, Forms and Templates 12
Similar threads


















































Top Bottom