Form and Form/Record Numbering in an Excel Spreadsheet

S

Subie Girl

#1
Issue: I have an Excel spreadsheet that will be used as a record of an individuals training in areas from "production" to "how to access employee information on-line". I've given the blank form a number, e.g., HRTF-6.2-001 30-60-90 Training Record; then HR adds department specific training headers to each column in the form layout and names it, 30-60-90 Training Record - Press Operator - Blue. This will be done for several other areas, e.g., maintenance, tool and die. Once HR has the different forms for each area, they will use it to evaluate each employee in that area and save it in the employee's HR folder.

Question:
1. Do I create a blank form/template number as shown above? They would be able to use it to create any additional department specific training records.
2. Do I give each department specific form a revision page for tracking changes to the department form (headers, etc.)?
3. Or should I give each department specific form a different form number?

I understand that there is a basic form and once it is filled in and they name it that becomes the record. Form number stays they same. I guess what's bothering me is tracking the revisions on my TS Master List; revisions to each department form (header titles) or is that something HR would be responsible for keeping up with?
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#2
Re: Form and Form/Record Numbering

When I make Excel templates to share in the Cove's attachments, I always try to include the advice to the effect of: "First thing! save this document as another name in case you accidentally delete a formula." The date of save becomes the revision date in the files. I do keep a number of versions, going back in the years in which I made significant changes that affect features, function or usability.

This is a kind of risk based thinking, which is the premise for revision control in forms - keeping a template. The questions are: what can go wrong? Does it matter? If so, how critical is it? Does the form include instructions and/or parameters and/or critical formulas (Excel)?

If a simple matrix is used to record training I struggle to understand why the template would need revision control. Is HR allowed to add names and training items? If so, this sounds like a living document and the entries themselves become the record. The entries can be revision protected through consistent use of the Track Changes feature in Excel. :2cents:
 

somashekar

Staff member
Super Moderator
#3
Re: Form and Form/Record Numbering

Do what works best for you, but make it simple. Let the basic form be really basic so as to give more liberty for each department. Its good to train all the department users that basic form what you make, and have a common understanding about what details goes into which cell. Consult the users and get the agreement before you push out the form for use.
 
Thread starter Similar threads Forum Replies Date
G Is it mandatory to record all processes in form 2 of AS9102 FAI report AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
x-files A form becomes a record when data is entered ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
R Electronic Training Record Form (Template) Document Control Systems, Procedures, Forms and Templates 6
K Form 42-2 for Document Initiation and Change Record - Template wanted Document Control Systems, Procedures, Forms and Templates 3
S Definition Form vs. Record - What is the Difference between a Form and a Record Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 63
D Vendor (Supplier) Audit Form as a Controlled Form and as a Record Supplier Quality Assurance and other Supplier Issues 15
R Retention of records - Original Order Form vs. Computer Entry record - ISO 13485 Records and Data - Quality, Legal and Other Evidence 12
M Blank Form vs. Completed Form - A document or record? Records and Data - Quality, Legal and Other Evidence 11
L Does a backdate form format can be changed if wrong revision is used? Document Control Systems, Procedures, Forms and Templates 6
D Question regarding ECO process, specifically for Life Science products and defining form fit and function ISO 13485:2016 - Medical Device Quality Management Systems 1
D New Equipment form / template Document Control Systems, Procedures, Forms and Templates 5
C Certificate of Conformance Form - COC for each customer a controlled document? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
B EMPB (Erstmusterprufbericht) VDA form confusion + PSW VDA Standards - Germany's Automotive Standards 2
gunnyshore Form FDA 3500A MedWatch eSubmitter 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
M AS9102B Detail Part/Assembly FAI Form 1 box 13; AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
A AS9102B - 3.6 Design Characteristics and form 3 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
M AS9102 FAI Report formats - Boxes in form 1, 2, 3 of AS9102 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
C AS9145 Appendix D PPAP Approval Form APQP and PPAP 2
L Form-dependent position prevention control FMEA and Control Plans 1
Y Blank Fields on CAPA Form Document Control Systems, Procedures, Forms and Templates 21
Q Do Management Review records have to be on a controlled form? ISO 13485:2016 - Medical Device Quality Management Systems 30
M How to complete structure Analysis and Function analysis sections' columns of AIAG-VDA DFMEA form FMEA and Control Plans 0
P AS9102 Form 3 Dimension Results Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
M Informational EU – MDCG 2019-12 Designating authority’s final assessment form: Key Information Medical Device and FDA Regulations and Standards News 0
Ed Panek Relevant questions on Substantial Change Form CE Marking (Conformité Européene) / CB Scheme 3
B Documenting hardware on Form 2 of AS9102 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
M Nonconformity for missing form number on the job description document Nonconformance and Corrective Action 1
Sidney Vianna Interesting Discussion Interesting article form the UNIDO Magazine - CSR: a wolf in sheep’s clothing? Sustainability, Green Initiatives and Ecology 16
R Process Specification - What is the name of this PPAP form? APQP and PPAP 15
GreatNate Document Control info - What is required on a controlled form/document for ISO 9001: 2015? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
G I-chart form for GM GP-12 Customer and Company Specific Requirements 2
M Informational US FDA – Ethicon Recalls Circular Staplers for Insufficient Firing and Failure to Completely Form Staples Medical Device and FDA Regulations and Standards News 0
B AS9102 COTS Form 1 vs. 2 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
D Incoming (Receiving) Inspection - General form for incoming part inspection Document Control Systems, Procedures, Forms and Templates 17
S C of C release with accompanying EASA Form 1 for EASA Part 145 EASA and JAA Aviation Standards and Requirements 0
S Where did FDA 510(K) form 3654 go? Other US Medical Device Regulations 1
M What are the differences between "Process Flowchart form" and "Process Flow Diagram form"? IATF 16949 - Automotive Quality Systems Standard 4
K Does anyone have a copy of a GM 5 Phase Problem solving form Problem Solving, Root Cause Fault and Failure Analysis 1
Ron Rompen Source needed for Spline Form gauge (GO and NOGO members) General Measurement Device and Calibration Topics 3
T NAFTA request for form with no part numbers showing Supply Chain Security Management Systems 0
C Do we need to make a new OFI (Opportunity for Improvement) for each document/form we update? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 23
R SaMD - Software as a Medical Device - Software change control form ISO 13485:2016 - Medical Device Quality Management Systems 3
K Work Order Form (Controlled Document)? Document Control Systems, Procedures, Forms and Templates 5
J Medical Device Vigilance decision tree FORM - Please share yours EU Medical Device Regulations 14
O Localized clean room dust extraction system coupled in HVAC - Manufacturing solid dosage form Manufacturing and Related Processes 9
Ajit Basrur Informational Merger of PAC and APLAC to form the Asia Pacific Accreditation Cooperation (APAC) General Measurement Device and Calibration Topics 0
JoshuaFroud FDA Form MDSAP AU F0029.1.004 - Help with Completion US Food and Drug Administration (FDA) 0
L AS9102 Form 1 Section 13 Detail or Assembly Question AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
supadrai Informational Japan Minor Change Notification Application Form - Found it? Japan Medical Device Regulations 0
S Adding Value prior to signing EASA Form 1 EASA and JAA Aviation Standards and Requirements 5

Similar threads

Top Bottom