How do I go about creating document logs and registers with the MS Excel

#1
hi my name is john, I am currently in Construction Industry as a document control coordinator (DCC) i'm new to document controlling so i'd really appreciate all the advice and help i can get.

quick one: how do i go about creating up logs and registers with the MS EXcel to control documents created or generated within the organisation and how to handle external documents. my company currently has 12 departments and each generating different documents.
and the information these logs and resisters will contain
can i get sample templates to achieve this task

thanks all as i anticipate your answers and response.
 
Elsmar Forum Sponsor

ScottK

Not out of the crisis
Staff member
Super Moderator
#2
hi my name is john, I am currently in Construction Industry as a document control coordinator (DCC) i'm new to document controlling so i'd really appreciate all the advice and help i can get.

quick one: how do i go about creating up logs and registers with the MS EXcel to control documents created or generated within the organisation and how to handle external documents. my company currently has 12 departments and each generating different documents.
and the information these logs and resisters will contain
can i get sample templates to achieve this task

thanks all as i anticipate your answers and response.
Hi John. That's a pretty tall order for someone who is new to this stuff...
While Excel is fine for logging lists of documents, Excel itself does not Control them.

If you go into the attachments portion this site you may find some sample logs. Should be a simple list with things like
  • Document ID number
  • Document Title
  • Revision
  • Revision Date
at the most basic.

So you'll need a system to assign ID's and a process for how to create/modify/obsolete a document. And standard templates would help too or everyone will be creating documents in separate formats.

It's not dissimilar from how construction drawings are controlled.

I hope that helps somewhat - a lot of us could go on for pages and pages about doc control.
 
Thread starter Similar threads Forum Replies Date
S When creating a 510k, which Guidance Document Wins? Other US Medical Device Regulations 9
P Creating a PPAP document for my Suppliers APQP and PPAP 1
T Creating Swim Lanes to document where processes cross functional boundaries ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
D Definition Document Types - Creating definitions for all the different document types Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 6
L Creating a Global Document Control System Document Control Systems, Procedures, Forms and Templates 4
R Accelerated Aging - Creating test samples - Implantable medical device Question Other Medical Device Related Standards 4
L Hazardous Waste - Tips for creating standardized training Miscellaneous Environmental Standards and EMS Related Discussions 2
M Informational Creating a post market surveillance (PMS) system for medical devices – Part 1 Medical Device and FDA Regulations and Standards News 7
J Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
8 Creating Flow and Pull Game Lean in Manufacturing and Service Industries 1
B Main responsibility for Control Plans - creating and maintaining FMEA and Control Plans 13
shimonv Creating a new commercial product based on a modification to an existing product Other US Medical Device Regulations 4
R Creating WIs for a Heavy Civil Engineering Services company Document Control Systems, Procedures, Forms and Templates 19
M Creating a Plant Level Value Stream Map Process Maps, Process Mapping and Turtle Diagrams 1
T IMDS - Creating an MDS out of material and a made item? RoHS, REACH, ELV, IMDS and Restricted Substances 4
W ISO9001:2015 - Clause 7.5.2 - Requirements for Creating & Updating Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
K Creating together Standard Definition for Prevention and Detection FMEA FMEA and Control Plans 1
Marc Creating an Internal Audit Program That Works for Your Organization Internal Auditing 0
M Creating change / Forcing change within a Company Lean in Manufacturing and Service Industries 7
A Creating a policy to evaluate the Third Party Security IEC 27001 - Information Security Management Systems (ISMS) 4
S Creating goals and objectives with targets and measurables for self-evaluations Management Review Meetings and related Processes 2
L Creating a xlsx Customer Complaint file to track Complaints Excel .xls Spreadsheet Templates and Tools 2
P GS1 NHRN AIs - Creating Barcodes for Human Product Other ISO and International Standards and European Regulations 4
O Creating a Tool to Track & Verify Mistake Proofing Devices Document Control Systems, Procedures, Forms and Templates 5
B Any suggestion on creating the best paper plane that can hit a target perfectly? Coffee Break and Water Cooler Discussions 2
L Any recommendations on software for creating hierarchical workflows ? Misc. Quality Assurance and Business Systems Related Topics 2
AnaMariaVR2 Creating Global Giants from a Culture of Israeli Start-Ups Coffee Break and Water Cooler Discussions 0
R Creating a c-chart spreadsheet to use in my department Excel .xls Spreadsheet Templates and Tools 5
R Inspection Database Picker - Creating an Inspection Report Document Control Systems, Procedures, Forms and Templates 1
P Problem with creating VSM current map Lean in Manufacturing and Service Industries 3
G Creating an Organization Chart - AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
L Creating DHF (Design History File) for Medical Device Systems Design and Development of Products and Processes 8
Q Recommendations for criteria on creating a CAPA (Corrective and Preventive Action) ISO 13485:2016 - Medical Device Quality Management Systems 8
C Creating a Multiple Table SQL (Structured Query Language) Query in Minitab Using Minitab Software 10
C Resources for creating Process Validation Procedures Qualification and Validation (including 21 CFR Part 11) 5
B Creating an Audit Mechanism (System/Plan) General Auditing Discussions 3
A Customer Profiles - Creating a Customer 'Profile' for our Top 10 Customers Document Control Systems, Procedures, Forms and Templates 2
M Creating an Index for our Documents - Imaging Millions of Paper Records Document Control Systems, Procedures, Forms and Templates 13
N ISO 9001 based Audit Schedules: Creating and Maintaining - Template wanted General Auditing Discussions 5
P Creating a Traceability Database with Microsoft Access Document Control Systems, Procedures, Forms and Templates 7
V Creating a Cosmetic Inspection Specification for Powder Coated Painted Finished Parts Manufacturing and Related Processes 7
I Difficulty in creating a Quality Manual Quality Management System (QMS) Manuals 4
J Creating an Audit Schedule & Revamping QMS Internal Auditing 18
L How can you capture many positions held without creating a lengthy resume Career and Occupation Discussions 4
Miner Intro to MSA of Continuous Data - Part 10: Creating gauge families Imported Legacy Blogs 10
E Manufacturing Planning - Creating Improvements Misc. Quality Assurance and Business Systems Related Topics 7
R Creating Quality System and using it before it is complete ISO 13485:2016 - Medical Device Quality Management Systems 8
G Creating a "Records Policy" - Control of Quality Records Records and Data - Quality, Legal and Other Evidence 13
C Creating a Micro QMS - 4 geographical sites and 3 types of core activities ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
S Sources for Tips, Quotes with Graphics to be used for Creating Awareness? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1

Similar threads

Top Bottom