Tracking response time with individual label I.D.

dgriffith

Quite Involved in Discussions
#1
Looking to track a response time variable (easy) and simultaneously label the response time with an ownership attribute (harder), but I don't want to have to type the label on the chart each time. It should come from a cell associated with the response time.

1. Out of tolerance/non-conformance forms are distributed to M&TE owners
2. Forms require a response within 5 duty days (7 calendar) indicating action taken to evaluate/mitigate any impact on product, with signatures
3. Higher management is notified of non-complying owners with forms still outstanding through a 7-day interval progressive notification process, ending with the "Big Boss" (actually, it ends with the auditor, who shall surely sniff out any process non-compliance, which, ahem, is why I'm now doing this . . . )

The response time monitoring is now one of the corrective actions, and I'm looking to use Excel to plot a time series against the 7-day 'containment' limit and also label/show the form owners' organization ID.

So, when the big boss looks at a quarterly chart of the number of forms issued (X-axis value), the days outstanding variable with owning organization attribute is plotted (2 y-axis values).
 
Elsmar Forum Sponsor

Darius

Quite Involved in Discussions
#2
could you post an example?, so the solution can be better for your case.

note: you want the labels into the chart, or you want the info in a square near the chart, or something else...
 
Last edited:

dgriffith

Quite Involved in Discussions
#3
Here is example file. Each X-axis point is an individual form--it has a days outstanding variable (Column A) and an ownership attribute (Column B).

I was just thinking that each point can be manually colorized, each color representing the org code, but that requires too much of the viewer. It needs to be in print at the data point. Was just hoping to do this automatically.
 

Attachments

Darius

Quite Involved in Discussions
#5
each point can be manually colorized, each color representing the org code, but that requires too much of the viewer. It needs to be in print at the data point. Was just hoping to do this automatically.
Sorry to question:confused:, you need to colorize each point and it is what you want?

I don't get the meaning of "needs to be in print at the data point", you mean that you have to select the point and change it one by one?
 

dgriffith

Quite Involved in Discussions
#7
You didn't answered if you wanted each type with a different color, so I changed to something without any macros that can do the trick.

A different column for each type, if you want in just a column a VBA macro will be needed.
Darius, Very nice application. Thank you.
I had thought of colors but also thought the legend with each identifier would be too busy, making the viewer work too hard to correlate the color with code. But you laid it out nicely and even I picked it up right away.
I think you have a working solution.
:applause:
 
Thread starter Similar threads Forum Replies Date
K Fast Response Tracking Board (QSB+) Customer and Company Specific Requirements 6
M Proof of distribution - FedEx/UPS tracking numbers Manufacturing and Related Processes 2
J 21 CFR 821 Medical Device Tracking Requirement 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
J Is Device Tracking Card an actual requirement under FDA regulation? Other US Medical Device Regulations 0
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
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
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, NADCAP and Aerospace related 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, NADCAP and Aerospace related Standards and Requirements 1
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
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
V Tracking PPAP On Time Completion using Excel Excel .xls Spreadsheet Templates and Tools 1
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
T Tracking Medical Device Components for Recalls Manufacturing and Related Processes 1
Ronen E CDRH Export Certification and Tracking System launched Other US Medical Device Regulations 0
M Tracking Preventive Maintenance Effectively Nonconformance and Corrective Action 5

Similar threads

Top Bottom