Template or example Excel list of ISO certificates issued to clients

PE-2011

Quite Involved in Discussions
#1
Hello,

i want to maintain list of ISO certificates issued to clients - year wise. could anyone help. i want single excel sheet which can show cycle wise & year wise issuance.

thanks in advance.
 
Elsmar Forum Sponsor

Ajit Basrur

Staff member
Admin
#3
Hello,

i want to maintain list of ISO certificates issued to clients - year wise. could anyone help. i want single excel sheet which can show cycle wise & year wise issuance.

thanks in advance.
Clarify what you mean when you say "certificates issued to clients" ... are you working at a registrar?
 

PE-2011

Quite Involved in Discussions
#4
Thank you all.


example
i have 500 clients
iso certificates issued for 3 year cycle


list of certificate maintained is issue date & expiry date


when one cycle completed and second cycle starts, issue date & expiry date will change and new dates will update


so when i need to know how many was issued in 2015 year (suppose) and 2016 year, 2017 year like this


i need to know one customer in how many cycle completed


how it can manage in one single excel sheet



any idea?


thanks in advance
 

Ninja

Looking for Reality
Trusted Information Resource
#5
Just out of curiosity...are you familiar with the "sort" function in Excel?
Fill Down?
Drag and fill?
 
Thread starter Similar threads Forum Replies Date
Q Example of the Risk Template Document Control Systems, Procedures, Forms and Templates 1
A Australia TGA Medical Device Sponsor Agreement - Example or Template Other Medical Device Regulations World-Wide 14
T Example wanted - Template for internal audit IATF 16949 IATF 16949 - Automotive Quality Systems Standard 1
R Clinical evaluation Meddev (2.7.1 revision 4) - Example or Template EU Medical Device Regulations 4
B Seeking for an example or a template of a Business Plan Service Industry Specific Topics 3
D Design and Development Procedure example and Template wanted - AS9100 Rev D AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
B Feasibility Analysis Study Format Template Example Document Control Systems, Procedures, Forms and Templates 2
T External Document (Documents of External Origin) Control Template example wanted Document Control Systems, Procedures, Forms and Templates 14
S In-House Equipment Calibration Report Format & Template Example Needed Document Control Systems, Procedures, Forms and Templates 1
1 Stop Ship/Build or something like a Quality Alert template or procedure example Document Control Systems, Procedures, Forms and Templates 5
B Control Plan example and Process Sheet template wanted Document Control Systems, Procedures, Forms and Templates 4
P ISO 20072 Requirements - Example or template of a DFP (device functionality profile) Other Medical Device Related Standards 2
T New Product Validation Plan example or template for a Medical Device 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
N Audit Summary Report - Need template example and help Internal Auditing 3
hogheavenfarm Fire Safety Analysis (FSA) example or template FMEA and Control Plans 7
P Work Standard / Work Instruction Template Example wanted FMEA and Control Plans 3
K Software Life Cycle Process Map? Template or example wanted IEC 62304 - Medical Device Software Life Cycle Processes 3
O Supplier Risk Assessment template or example needed Supplier Quality Assurance and other Supplier Issues 5
J Electronic Signature Validation Protocol example or template Qualification and Validation (including 21 CFR Part 11) 2
B Implement Clause 7.3 Design and Development procedure template example ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Q Example of a Customer Complaint / Feedback form or template. Document Control Systems, Procedures, Forms and Templates 6
C Usability Engineering File - Looking for an example/template IEC 62366 - Medical Device Usability Engineering 3
K Design Input document example format/template needed Design and Development of Products and Processes 12
L Production and Process Control SOP example or template needed US Food and Drug Administration (FDA) 2
W Design History File (DHF) Template Example for Consideration. Design and Development of Products and Processes 12
R Process Flow Chart Template example Document Control Systems, Procedures, Forms and Templates 20
L Issuing Credit to Customer - Example form / template Nonconformance and Corrective Action 1
J Job Traveler or Work Order example template needed Document Control Systems, Procedures, Forms and Templates 13
Crusader Spill Containment Procedure template - Need example Miscellaneous Environmental Standards and EMS Related Discussions 12
Ajit Basrur Quality Plan for ISO 9001 and ISO 13485 - Template or Example Needed Document Control Systems, Procedures, Forms and Templates 29
N "Concept Feasibility Review" checklist for new products - Seeking template or example APQP and PPAP 5
A Manufacturing Plan Template or Example wanted Document Control Systems, Procedures, Forms and Templates 16
A Supplier Scorecard template / example Supplier Quality Assurance and other Supplier Issues 16
T TS16949 QMS Manual - Quality Systems Manual example or template Quality Management System (QMS) Manuals 25
F Nonconformance Report example template or form Document Control Systems, Procedures, Forms and Templates 11
M Auditee Evaluation of Auditors Example, Form or Template General Auditing Discussions 6
M Internal Audit Report Example Template Document Control Systems, Procedures, Forms and Templates 50
D Planning for Product Realization example form, template or checklist Document Control Systems, Procedures, Forms and Templates 6
N Seeking: Control Plan template and example FMEA and Control Plans 6
J Process FMEA Template with examples - Cold and Hot Forged components FMEA and Control Plans 4
F MDR GSPR Checklist template EU Medical Device Regulations 4
M Email Template that go to a customer and then get returned to us for RMA/Warranty Document Control Systems, Procedures, Forms and Templates 1
C Ford's MMOG/le Template wanted Manufacturing and Related Processes 0
C SOP Template needed for ISO 13485 6.3 Infrastructure ISO 13485:2016 - Medical Device Quality Management Systems 9
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 5
dgrainger Informational MDCG 2020:13 - Clinical evaluation assessment report template EU Medical Device Regulations 0
Q Internal audit plan template Internal Auditing 6
D New Equipment form / template Document Control Systems, Procedures, Forms and Templates 5
M Supplier Audit Report - Template for second party audit wanted Lean in Manufacturing and Service Industries 1
D Design Transfer Template capturing Customer Specific Requirements Other Medical Device Related Standards 3

Similar threads

Top Bottom