Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11

S

Samurai Sam

#1
Hello everybody, long time lurker-first time poster. I need to devise a spreadsheet that will calculate audit duration times based on the criteria of IAF MD5 and MD11. Has anybody done this before or can someone point me to someone who could help me?

Sam:cfingers:
 
Last edited by a moderator:
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#3
Hello everybody, long time lurker-first time poster. I need to devise a spreadsheet that will calculate audit duration times based on the criteria of IAF MD5 and MD11. Has anybody done this before or can someone point me to someone who could help me?

Sam:cfingers:
Welcome to the Cove! :bigwave:

Please forgive me, I am feeling a little thick. I am not clear what are you asking for besides a sum of audit durations as compared to requirements in a difference or ratio computation. Am I missing something?
 
#4
Hello everybody, long time lurker-first time poster. I need to devise a spreadsheet that will calculate audit duration times based on the criteria of IAF MD5 and MD11. Has anybody done this before or can someone point me to someone who could help me?

Sam:cfingers:
I'd suggest it is a practical impossibility to do that. The adjustments to duration would be difficult to program in.
 
S

Samurai Sam

#5
Welcome to the Cove! :bigwave:

Please forgive me, I am feeling a little thick. I am not clear what are you asking for besides a sum of audit durations as compared to requirements in a difference or ratio computation. Am I missing something?
Jennifer, basically, we are a CB and our AB witness audit found that we reduced the audit duration without taking into account the reduction criteria from MD 11, nor did we justify and document any reasoning behind the justification. Our client holds AISC Building Certification (basically a rehash of the old ISO 9001-1994), ISO 9001-2008 and ISO 3834. Just a rough guess is that the integration factor is 90% as these certifications all have the same requirements with the exception of some Process specific procedures required for their AISC Certification. What I am looking for is to plug in some formulas into an Excel spreadsheet that would take into account the number of auditors, number of management system standards to be covered by the integrated audit and the number of management systems the auditors are qualified to audit. It seems to me that Excel could do these calculations quickly based on some easily input factors. I want to then take the calculations to document in our audit duration worksheets so that we can justify any increase or decrease (decrease by 20% maximum)
 
I

ilkaytrade

#6
I prepared one excel sheet and I'm allready using this. Allready tested and verified at our followup audit from AB.
In a short time I will include to here .

regards,

ilkay,
Certification Mng.
Turkey,
 
Q

Qfortherightreasons

#7
I prepared one excel sheet and I'm allready using this. Allready tested and verified at our followup audit from AB.
In a short time I will include to here .

regards,

ilkay,
Certification Mng.
Turkey,
Hi Ilkay - did you happen to post the excel sheet you prepared? We are being directed by our CB that one of our remote sites needs a 4 man-day audit. There's only enough process work going on there to justify a 1 man-day audit. Just want to know how they arrived at 4 man-days!!! thanks!!
 

kani

Registered
#8
Hi Ilkay - did you happen to post the excel sheet you prepared? We are being directed by our CB that one of our remote sites needs a 4 man-day audit. There's only enough process work going on there to justify a 1 man-day audit. Just want to know how they arrived at 4 man-days!!! thanks!!
Hi Qfortherightreasons, have you had a copy of spreed sheet ?
 
#9
Hi Ilkay - did you happen to post the excel sheet you prepared? We are being directed by our CB that one of our remote sites needs a 4 man-day audit. There's only enough process work going on there to justify a 1 man-day audit. Just want to know how they arrived at 4 man-days!!! thanks!!

Hello sir,
I haven't been on the forum for a long time.
If your number of employees is over 30 and your Nace code is in the dangerous class, it is normal to have 4 man-day inspections. There is no rule that remote locations and construction sites will be controlled less than the headquarter.
The remote location, the number of employees at the construction site and the hazard class are effective in the man.day calculation.
I finished calculatıon form but its turkish language.
 
Thread starter Similar threads Forum Replies Date
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
V Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted General Measurement Device and Calibration Topics 3
K Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
A How do we calculate the control chart by using excel .xls spreadsheet? Excel .xls Spreadsheet Templates and Tools 4
C Software or Excel .xls spreadsheet to calculate sample size and the AQL - ISO 2859-1 AQL - Acceptable Quality Level 2
C Spreadsheet Validation and Release Qualification and Validation (including 21 CFR Part 11) 2
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
U Spreadsheet Context, interested parties ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
rob73 EU Medical Device Classification Spreadsheet EU Medical Device Regulations 4
S VDA 5 Variables Data GR&R Spreadsheet wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
C Visual Presentation of Supplier Score - .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 1
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 5
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet to use Basic and Mini MOST for Line Balancing Document Control Systems, Procedures, Forms and Templates 1
6 Spreadsheet for Health and Safety Reporting - Template Occupational Health & Safety Management Standards 6
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
D Is a separate spreadsheet required for the ASL (Approved Supplier List)? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Ajit Basrur How do I create two different columns in Excel spreadsheet ? Excel .xls Spreadsheet Templates and Tools 5
L Auditing Tool (Excel spreadsheet) for VDA 6.3 to Audit a Service Provider VDA Standards - Germany's Automotive Standards 4
M Dimension Report Formula .xlsx Editable Spreadsheet Form Excel .xls Spreadsheet Templates and Tools 24
B Third Party Service Provider Risk Rating Spreadsheet Risk Management Principles and Generic Guidelines 1
K Taguchi School Assignment using an L8 Orthogonal spreadsheet tool Statistical Analysis Tools, Techniques and SPC 1
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet Excel .xls Spreadsheet Templates and Tools 3
R Creating a c-chart spreadsheet to use in my department Excel .xls Spreadsheet Templates and Tools 5
R XBar & R Chart Spreadsheet to apply a Control Process Statistical Analysis Tools, Techniques and SPC 1
A ECR & ECN - Looking for advice and Spreadsheet Example Document Control Systems, Procedures, Forms and Templates 1
F SPC Data Analysis - Excel Spreadsheet I can use for Diameters and Perpendicularity Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Venture Capital Valuation Spreadsheet question Manufacturing and Related Processes 1
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
A Excel Spreadsheet Validation - Customer Audit Finding Other US Medical Device Regulations 2
V Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
P Calculating Process Capability from Data of attached spreadsheet Statistical Analysis Tools, Techniques and SPC 4
A How to create a Multiple Operations Specifications Comparison Spreadsheet? Excel .xls Spreadsheet Templates and Tools 3
6 Maintenance Spreadsheet to Monitor the Maintenance Process of a Fleet wanted IATF 16949 - Automotive Quality Systems Standard 8
H Is my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Using Minitab Software 18
automoto Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
J ROI (Return on Investment) Excel Spreadsheet example Excel .xls Spreadsheet Templates and Tools 1
L OEM Customer Specific Requirements - Spreadsheet wanted Customer and Company Specific Requirements 14
P Measurement Uncertainty Calculations Spreadsheet help General Measurement Device and Calibration Topics 4
R Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
T Controlled Documents - Can a word document and excel spreadsheet be controlled? Document Control Systems, Procedures, Forms and Templates 5
K Seeking a sample spreadsheet - Inventory of items with 2 units Document Control Systems, Procedures, Forms and Templates 3

Similar threads

Top Bottom