Tracking Calibration and Qualification in an MS Excel Spreadsheet

A

adel.zakarya

#1
Hello every one ! :bigwave:
it's my first topic here and i hope to get much more experience from here.
I work as a qc analyst in the field of pharmaceuticals and I've an imagination for an excel sheet for the calibration and qualifications of the lab instruments.
I started an excel sheet but i'm not an experienced user with excel so i need help to improve this template which will help me and others of course.
thanks in advance ! :thanx:
 

Attachments

Elsmar Forum Sponsor
A

adel.zakarya

#2
Re: required calibration and qualification excel sheet

I wanted detailed and simple to use excel sheet
so that i inserted instrument, its code, calibration or qualification date, and the due date of calibration or qualification
so that with an overview of the column of the month we can simply identify the instruments to be calibrated or whatever.

I'm waiting to hear your ideas and i hope for improved template as I said before that i'm not experienced with excel at all :(
 

Ninja

Looking for Reality
Trusted Information Resource
#3
Re: required calibration and qualification excel sheet

We moved quickly from a spreadsheet to a database for ease of use.
I would suggest the same for anyone.

MSAccess and Rapid deployment dbases like Filemaker are pretty easy to move into...
:2cents:
 
A

adel.zakarya

#5
Re: required calibration and qualification excel sheet

I think this template is very complicated for what I wanted
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#6
Re: required calibration and qualification excel sheet

I wanted detailed and simple to use excel sheet
so that i inserted instrument, its code, calibration or qualification date, and the due date of calibration or qualification
so that with an overview of the column of the month we can simply identify the instruments to be calibrated or whatever.

I'm waiting to hear your ideas and i hope for improved template as I said before that i'm not experienced with excel at all :(
For work in pharmaceuticals you may need more than these minimum data points. Do you see the Post Attachments List in the green button in the header? I did a search for "calibration" and came up with this list, which includes the discussion threads they were attached within. Some various tools have been shared in this thread.
 
Thread starter Similar threads Forum Replies Date
J Tracking-Calibration Software Calibration and Metrology Software and Hardware 3
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
F Calibration Tracking Software: Seeking Recommendations and Comments General Measurement Device and Calibration Topics 23
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
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
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
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 2
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

Similar threads

Top Bottom