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
Leader
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
Trusted Information Resource
#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.
 

Miner

Forum Moderator
Leader
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
Trusted Information Resource
#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
Trusted Information Resource
#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
giavannatabbs ISO 9001:2015 Control of Records - QMS Communications? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
H ISO 9001:2015 - 8.5.1 - Routers not being signed Manufacturing and Related Processes 5
M Is there a mandatory requirement to notify customers of the complaint resolution in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
J ISO 9001:2015 Document Revison History ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
M Preservation of Raw Materials in ISO 9001:2015 Standard ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
L Assignment on the link between Quality Gurus & ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
D ISO 9001:2015 Internal Audit Check Sheet ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
A ISO 9001:2015 8.5.6 and 7.5.3 Document Control Questions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
J ISO 9001:2015 Clause 8.2.3 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
B ISO 9001:2015 Registered Companies ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
D ISO 9001:2015 Calibration Procedures Manufacturing and Related Processes 16
S ISO 9001:2015 Project Plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
P How to keep a ISO 9001:2015 certification when a company is sold ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
D ISO 9001:2015 Recertification Audit Timing ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
J ISO 9001:2015 Is a Project Evaluation form necessary? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Sidney Vianna ISO 9001 News ISO/TC 176/SC 2 Listing of Approved Interpretations against ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Q Management Review ISO 9001-2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 36
J Process capability analysis in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
B Use an iso 9001/2015 form for api q1 systeme Oil and Gas Industry Standards and Regulations 5
Q Which Kapt standard assignment ISO 9001:2015? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Q Quality Awareness 7.3 ISO 9001-2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Cats Clause ISO 9001:2015 7.1.5 Monitoring and measuring resources: Application to training providers ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
M Quality Management-ISO 9001:2015 General Auditing Discussions 1
G ISO 9001-2015 How to co-relate Clause 4.2 & Clause 6.1 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 22
B ISO 9001:2015 vs ISO 13485:2016 Gap analysis ISO 13485:2016 - Medical Device Quality Management Systems 9
G Compliance with ISO 9001-2015 for ISO 17025 Accredited Labs? ISO 17025 related Discussions 8
L Change Log in (controlled) Forms? (ISO 9001:2015) Document Control Systems, Procedures, Forms and Templates 6
S Transition training for Internal Auditor from ISO 9001: 2008 to the ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
J ISO 9001:2015 Clause 8.5.1 Control of Production and service provision - Help with Work Instruction Access ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 13
M Does the scope of ISO 9001:2015 applies to tenders, pricing and sales department of a medical devices distributor? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
C ISO 9001:2015 8.3.2. h) Design and Development Planning - What is required? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
B Employee Handbook in ISO 9001:2015 Section 7 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 19
Q ISO 9001-2015 Internal audit finding Internal Auditing 14
R AS9100D internal audit checklist or ISO 9001 2015 to AS9100 D AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
J Opportunity in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 27
D Reports under change management | ISO 13485:2016 & ISO 9001:2015 ISO 13485:2016 - Medical Device Quality Management Systems 3
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 16
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 7
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

Similar threads

Top Bottom