SBS - The best value in QMS software

ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

G

GlossyMikeQC

#1
New User/New Post - Apologize in advance if too wordy. :)

I am currently working on our company's document control practices while implementing ISO 9001:2015 standards.

For most of our production processes, we use Excel spreadsheets to input measurements taken from the warehouse floor point of use as a control. These measurements are then sampled/inspected using similar Excel spreadsheets as evidence of product conformance [conditional formatting and controls added to the inspection sheets].

Given that our order (measurement lot quantity) and inspection amounts (ANSI 2008) change frequently, is it possible to have revision/document control using these Excel sheets and still have the ability to add rows in the sheet as inspection or measurement quantities change without having to add revision levels?

I guess I am a little fuzzy on the technical definition of a "revision" when using Excel forms or other office products. I've created these basic measurement and inspection form templates for multiple parts and thought it would be best to get this understood prior to moving forward.

The company and myself are relatively green when it comes to ISO 9001:2015 standards.

Thank you in advance!

GlossyMikeQC
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#2
Welcome to the Cove!

You should be able to make a spreadsheet model that makes calculations based on inputs that change results. If your formulas are protected and you can show a history of changes, you can reasonably demonstrate control. People have been doing this with measurement system analysis (MSA) and control charts for years.

Such things are why the standard now refers to "documented information" - there can be various types, including spreadsheets.
 

Ninja

Looking for Reality
Staff member
Super Moderator
#5
But don't ever forget the drag and drop fault in XL...

This causes a significant risk of misleading results...and (as far as I've been able to determine after much angst) has remained unaddressed.

Password protecting your formulae does NOT necessarily mean that users can't break them without a password...
 
G

GlossyMikeQC

#6
I agree completely! I've had to warn others in management about the XL cell drag error multiple times over the years. That and cell reference issues have caused a huge headache when I've allowed others to edit themselves.
 

John Broomfield

Staff member
Super Moderator
#7
So, is a fillable PDF the answer?

If so does anyone know how to convert an Excel spreadsheet into a fillable PDF with its formulae intact?
 

Miner

Forum Moderator
Staff member
Admin
#8
But don't ever forget the drag and drop fault in XL...

This causes a significant risk of misleading results...and (as far as I've been able to determine after much angst) has remained unaddressed.
I agree completely! I've had to warn others in management about the XL cell drag error multiple times over the years.
What are the specific on this drag error?
 

Ninja

Looking for Reality
Staff member
Super Moderator
#9
Make yourself an XL spreadsheet with calculation cells, and referenced cells.

Protect everything except for the referenced cells (using the protection tab).

Password protect the sheet.

Then have someone else open the sheet, put data into the referenced cells (like you would doing data entry).

Then drag that entered data from one referenced cell to another...the formula will change, even though the calculation is supposedly behind the password protection...

If I can find this thread tomorrow, I'll post an example sheet...there's one on here from one of my posts a few years ago...
 

Ninja

Looking for Reality
Staff member
Super Moderator
#10
Here is a simple demo sheet showing the drag and drop flaw.

Any questions (or especially any solutions), please post.

This was made in Excel 2016 on a Windows 10 platform. I've seen this issue as far back as Windows 98 (not sure which XL level back then).
 

Attachments

Thread starter Similar threads Forum Replies Date
K Integrating ISO 9001:2015 with ISO 17025:2017 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
S Sequence of ISO 9001:2015 Implementation Steps ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
S ISO 9001:2015 Internal Auditing Internal Auditing 8
Q Process: Knowledge Section 7.1.6 of ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
A What must be recorded? (ISO 9001:2015, subclause 10.2) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
S ISO 9001:2015 vs 21 CFR Part 211 matrix Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
M Does the ISO 9001:2015 standard require a disaster recovery plan or emergency response plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
M ISO 9001:2015 and AS6081:2012 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Implementation ISO 9001: 2015 ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
eule del ayre Documented Information - Periodic Review of Documents? IATF 16949:2016 / ISO 9001:2015 IATF 16949 - Automotive Quality Systems Standard 34
J Audit Checklist for Integrated Management System for ISO 9001:2015, ISO 14001 & OHSAS18001 (IMS) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
lanley liao How to understand the clause 6 Planning of ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
A Does ISO 9001:2015 cover all the requirements of ISO 10012:2003? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
T ISO 9001:2015 - Small Shop ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
M ISO 9001:2015 case study sample ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
M Sample of Nonconformity report for ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
M Case study help as per ISO 9001: 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
M Case study solution help required as per ISO 9001 : 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
F Logistics and IT clauses in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 15
V Quality Objectives - ISO 9001 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 26
Gun46 ISO 9001 : 2015 Lead Auditor Exam General Auditing Discussions 16
Q ISO 9001:2015 man days for surveillance audit ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
D ISO 9001:2015 4.3 Determining the Scope of the QMS ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
I ISO 9001:2015 Section 9.3.2 C1 "customer satisfaction and feedback from relevant interested parties" ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
I ISO-9001:2015 and "Relevant Parties" Management Review Meetings and related Processes 2
I Master Document Access - ISO 9001:2015 clause 7.5.3 Document Control Systems, Procedures, Forms and Templates 5
qualprod Why new clause (7.1.6) in ISO 9001:2015? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
I Where can I beg, steal (just kidding of course) or borrow good training material on the ISO 9001:2015 standard? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Robert Stanley Which Registrar Should I Choose for ISO 9001:2015 registration? Registrars and Notified Bodies 10
M ISO 9001:2015 8.2.1 Contingency Plan required for small Business? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
A Help with Drawing Review - ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
V ISO 9001:2015 7.2 Competence ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 35
B ISO 9001:2015 Transition: Much Easier Than You Think! Misc. Quality Assurance and Business Systems Related Topics 0
A Process Documentation for ISO 9001:2015 Internal Auditing 2
C Migrate ISO 9001:2015 Certificate Registrars and Notified Bodies 4
J ISO 9001:2015 Small Operation Management Review General Auditing Discussions 6
E Three basic questions about ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
C ISO 9001:2015 Monitoring and measuring resources. Application a service industry ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
W ISO 9001:2015 Management Review Input Template wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
G Is ISO 9001:2015 certification worth it for a company that does only contract manufacturing? Quality Management System (QMS) Manuals 14
N ISO 9001:2015 Customer Complaints Requirements ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
O Performance Measurement ISO 9001: 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Does ISO 9001-2015 have a requirement for manufacturing equipment to be numbered? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
V ISO 9001: 2015 Production drawing Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
KCalaba21 ISO 9001:2015 6.2.2 E - "e) how the results will be evaluated." ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
S ISO 9001:2015 & ISO 14001 Re-Certification Audit Preparation ISO 14001:2015 Specific Discussions 8
S ISO 9001:2015 & ISO 14001:2015 - I need a format for Design & Development planning ISO 14001:2015 Specific Discussions 2
N ISO 9001:2015 - 5.3 - The roles and responsibilities matrix rears it's head ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7

Similar threads

Top Bottom