The Cove Business Standards Discussion Forums
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
UL - Underwriters Laboratories - Health Sciences
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

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


Monitor the Elsmar Forum
Sponsor Links




Courtesy Quick Links


Links Elsmar Cove visitors will find useful in the quest for knowledge and support:

Jennifer Kirley's
Conway Business Services


Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC



International Standards Bodies - World Wide Standards Bodies

AIAG - Automotive Industry Action Group

ASQ - American Society for Quality

International Organization for Standardization - ISO Standards and Information

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags
document control, iso 9001:2015, measurement traceability
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 24th June 2018, 06:49 PM
GlossyMikeQC

 
 
Total Posts: 2
Please Help! ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

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

Sponsored Links
  Post Number #2  
Old 24th June 2018, 07:10 PM
Jen Kirley's Avatar
Jen Kirley

 
 
Total Posts: 6,135
Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

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.
Thank You to Jen Kirley for your informative Post and/or Attachment!
  Post Number #3  
Old 25th June 2018, 02:26 AM
John Broomfield's Avatar
John Broomfield

 
 
Total Posts: 2,605
Yin Yang Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

Mike,

Donít forget to differentiate between the form (your spreadsheet) that calls for certain data and the data themselves.

The form is subject to document control whereas the data are the records.

John
Thank You to John Broomfield for your informative Post and/or Attachment!
  Post Number #4  
Old 25th June 2018, 07:42 AM
Randy's Avatar
Randy

 
 
Total Posts: 8,709
Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

Do whatever you want, just be sure to define (be able to explain) and control what you're doing.
Thank You to Randy for your informative Post and/or Attachment!
  Post Number #5  
Old 25th June 2018, 05:57 PM
Ninja's Avatar
Ninja

 
 
Total Posts: 1,017
Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

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...
Thank You to Ninja for your informative Post and/or Attachment!
  Post Number #6  
Old 25th June 2018, 07:35 PM
GlossyMikeQC

 
 
Total Posts: 2
Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

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.
  Post Number #7  
Old 26th June 2018, 04:28 PM
John Broomfield's Avatar
John Broomfield

 
 
Total Posts: 2,605
Let Me Help You Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

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?
  Post Number #8  
Old 26th June 2018, 04:42 PM
Miner's Avatar
Miner

 
 
Total Posts: 4,334
Re: ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

Quote:
In Reply to Parent Post by Ninja View Post

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.
Quote:
In Reply to Parent Post by GlossyMikeQC View Post

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?
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Emoticons are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
ISO 9001:2015 Clause 7.1.5.2 - Is Measurement traceability applicable? Ren33 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1 20th April 2018 02:26 PM
ISO 9001:2015 - Management Review 9.3.2 c) 5) - Monitoring and Measurement Results ganglai ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4 9th October 2017 10:58 AM
Document Control Guidelines in Engineering Projects - Excel sheets with VBA coding sushilkadam Document Control Systems, Procedures, Forms and Templates 3 16th November 2016 08:22 AM
ISO 9001:2015 clauses and clause details in Excel format smitha_ph Document Control Systems, Procedures, Forms and Templates 11 28th July 2016 03:36 PM
Automated Calculators like EXCEL sheets for different processes lafbox Quality Assurance and Compliance Software Tools / Solutions 2 24th December 2011 04:27 PM



The time now is 03:00 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.



Misc. Internal Links


NOTE: This forum uses "Cookies"