{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instruction","Overview","Results","1-context","2-leadership","3-planning","4-support","5-operation","6-performance evaluation","7-improvement","8-indiv requirements"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1],[12,0,12,2],[1,0,1,1]]}
["Instructions"]
["This part of ProMergeTool! Constitutes a maturity model on management system (MS) level. Some aspects within the categories might illuminate processes as well, but for a detailled process analysis the ProMergeTool! on process level is advised. "]
[1,"Start on slide \"overview\" and fill the marked area. You have the opportunity to assess up to three merged companies in parallel. If you only need 2, let the field with company C empty. "]
[null,"Fields with this colour can be filled, all other cells are locked. "]
[2,"Press the button \"Start assessment company A\". This leads you to the slide \"1 - context\". The columns A and B define the requirements for \"context\", respectively in all other categories in the following slides. Most of the requirements are based on the standard ISO 9001:2015, all further aspects are marked with \"*\". In each category you can add up to three company specific requirements at the bottom of the slide (\"Others main 1-3\").  \nIn the columns C-G the stage of maturity in company A is assessed. It describes the occurrence of each category aspect. Please insert 1/2/3/4 for each requirement the five maturity stages for availability, simplicity and speed, robustness and stability, efficiency and performance. Further explanation for the meaning of 1-4 in the occurrence are listed in the slides. If an aspect is not applicable in your company or you can not assess it, insert \"1\" in the column \"not applicable\" instead. The arithemetic average of each category aspect appears in the last column, the arithmetic average in the occurrences appears at the top of the slide in line 4. If an aspect is divided in sub-aspects the sub-average appears in grey bailed lines. \nWhen you have finished a category, press the button \"SAVE and GO ON\" at the top right side in the slide. "]
[3,"Proceed in the categories 2-8."]
[4,"Category 8 defines individual requirements of a company, all aspects already inserted are not based in ISO 9001:2015, they describe experiences and best practice. The occurences are not suitable for individual requirements, so the assessement is oriented on availability and implementation only. Press the button \"SAVE and return to overview\" to close the assessment for company A. Click on the button \"Close A\" to save the results."]
[5,"In the slide \"overview\" the assessment for company A appears in the spider diagrams for \"categories\" and \"occurrence\".\nThe slide \"results\" gives an overview of the arithmetic averages of the assessment. The slide allows at one sight to regognize strenghts and weaknesses within the categories and occurrences in each merged company supported by corresponding colouring.\nOptional you can give the categories and occurrences a weight from 1-3, if any of it is of special interest for your merged company. Attention: if you wish to weight the categories and occurrences, please insert the weight at first step BEFORE any assessments are started. \nBy default all categories and occurrences have the same weight. The weight influences the average result, not the assessment itself. "]
[6,"To start the assessment for company B press the button \"Start assessment company B\". \nATTENTION: With pressing the button all previous assessments for company A are cleared, only the arithmetic averages for the categories and occurrences will remain. If you wish to maintain all assessments in the slides please save the file separately.\nPlease navigate through the tool as described above. "]
[7,"Press the button \"Close B\" to save the results for company B. The calculations in the background are running and in the spider diagrams the graphs of company B appear next to company A.\nIf a third entity is to be assessed, press \"Start assessment company C\". Please navigate once again through the tool as already described to assess company C. After running through the categories press button \"Close C\" to save the results for company C as well. All companies appear in the spider diagram. "]
[8,"As last step summarize your findings in the SWOT analysis. "]
[]
["results"]
["3,5-4,0","Excellent MS/process, best practice for benchmarking, processes optimized, categories and occurrences have high maturity\nRecommendation: absorption of weaker MS, ONE process","excellent"]
["3,0-3,4","Stable and strong process/MS, improvement on some aspects possible\nRecommendation: partly absorption, take over most parts of MS, check categories and occurrences carefully for weaknesses, choose ONE process or GATE","good"]
["2,0-2,9","MS/processes available, need for improvement\nRecommendation: symbiosis if merged MS is not weaker, take over strong categories / occurrences or processes, GATE on process level","intermediate"]
["1,0-1,9","Processes/MS not defined or available, need for improvement\nRecommendation: to be absorbed by stronger MS/process if available or new design, check if process needed","poor"]

{"sheet":"Overview","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,5,8,8],[2,4,2,8],[0,0,0,11],[1,0,1,11],[2,0,8,3],[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[6,9,6,11],[7,9,8,11],[17,0,24,0],[26,0,28,0],[31,1,31,5],[32,1,32,5],[33,1,33,5],[31,0,34,0],[30,0,30,10],[34,1,34,5],[31,6,31,10],[32,6,32,10],[33,6,33,10],[34,6,34,10],[23,6,23,7]]}
["Maturity assessment of management system harmonization"]
["Overview"]
["This maturity assessment aims to support merged companies in comparing the double or multi available management systems. The spreadsheet \"explanation\" explains how to use this tool. ",null,null,null,"Please insert your data:"]
[null,null,null,null,"Company (part) A"]
[null,null,null,null,"Company (part) B"]
[null,null,null,null,"Company (part) C"]
[null,null,null,null,"Assessor(s):","Assessor(s):","Names and functions",null,null,"Attention: with \"Start assessment company B/C\" the previous assessment disappears in the tabs, only the results are saved"]
[null,null,null,null,"Date:","Date:",null,null,null,"Click at the button \"Close A/B/C\" to save the category and occrrence results when finishing the assessment of a company"]
[null,null,null,null,"Purpose:","Initial assessment / assessment for verification"]
[]
[]
[]
[]
[]
[]
[]
[null,"Category",{"$f":"F4","v":0},{"$f":"F5","v":0},{"$f":"F6","v":0},null,"Occurrence",{"$f":"F4","v":0},{"$f":"F5","v":0},{"$f":"F6","v":0}]
[null,"Context",{"$f":"Results!D19","v":0},{"$f":"Results!D32","v":0},{"$f":"Results!D45","v":0},null,"availability",{"$f":"Results!E27","v":0},{"$f":"Results!E40","v":0},{"$f":"Results!E53","v":0}]
[null,"Leadership",{"$f":"Results!D20","v":0},{"$f":"Results!D33","v":0},{"$f":"Results!D46","v":0},null,"simplicity and speed",{"$f":"Results!F27","v":0},{"$f":"Results!F40","v":0},{"$f":"Results!F53","v":0}]
[null,"Planning",{"$f":"Results!D21","v":0},{"$f":"Results!D34","v":0},{"$f":"Results!D47","v":0},null,"robustness and stability ",{"$f":"Results!G27","v":0},{"$f":"Results!G40","v":0},{"$f":"Results!G53","v":0}]
[null,"Support",{"$f":"Results!D22","v":0},{"$f":"Results!D35","v":0},{"$f":"Results!D48","v":0},null,"efficiency",{"$f":"Results!H27","v":0},{"$f":"Results!H40","v":0},{"$f":"Results!H52+Results!H53","v":0}]
[null,"Operation",{"$f":"Results!D23","v":0},{"$f":"Results!D36","v":0},{"$f":"Results!D49","v":0},null,"performance",{"$f":"Results!I27","v":0},{"$f":"Results!I40","v":0},{"$f":"Results!I53","v":0}]
[null,"Performance evaluation",{"$f":"Results!D24","v":0},{"$f":"Results!D37","v":0},{"$f":"Results!D50","v":0}]
[null,"Improvement",{"$f":"Results!D25","v":0},{"$f":"Results!D38","v":0},{"$f":"Results!D51","v":0},null,"results:"]
[null,"Individual requirements",{"$f":"Results!D26","v":0},{"$f":"Results!D39","v":0},{"$f":"Results!D52","v":0},null,"excellent","3,5-4,0"]
[null,null,null,null,null,null,"good","3,0-3,4"]
[null,null,null,null,null,null,"intermediate","2,0-2,9"]
[null,null,null,null,null,null,"poor","1,0-1,9"]
[]
[]
["Summary analysis phase"]
["SWOT analysis","Strengths",null,null,null,null,"Weaknesses"]
[]
[null,"Opportunities",null,null,null,null,"Threats"]

{"sheet":"Results","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,0,52,2],[39,0,39,2],[42,0,42,1],[43,0,43,1],[43,2,43,3],[41,0,41,1],[41,2,41,9],[30,0,30,1],[30,2,30,3],[16,0,16,1],[17,0,17,1],[17,2,17,3],[28,0,28,1],[28,2,28,9],[11,0,11,2],[26,0,26,2],[29,0,29,1],[2,0,2,1],[2,2,2,3],[0,4,0,8],[1,0,1,1],[15,2,15,9],[15,0,15,1]]}
[]
["Current assessment",null,"Occurence","Weighted Result category","availability","simplicity and speed","robstuness and stability ","efficiency","performance","Result Category"]
["Category",null,"Weight (1-3)",null,1,1,1,1,1]
[1,"Context",1,{"$f":"($E$3*J4+$F$3*J4+$G$3*J4+$H$3*J4+$I$3*J4)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'1-context'!C4","v":""},{"$f":"'1-context'!D4","v":""},{"$f":"'1-context'!E4","v":""},{"$f":"'1-context'!F4","v":""},{"$f":"'1-context'!G4","v":""},{"$f":"'1-context'!I4","v":""}]
[2,"Leadership",1,{"$f":"($E$3*J5+$F$3*J5+$G$3*J5+$H$3*J5+$I$3*J5)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'2-leadership'!C4","v":""},{"$f":"'2-leadership'!D4","v":""},{"$f":"'2-leadership'!E4","v":""},{"$f":"'2-leadership'!F4","v":""},{"$f":"'2-leadership'!G4","v":""},{"$f":"'2-leadership'!I4","v":""}]
[3,"Planning",1,{"$f":"($E$3*J6+$F$3*J6+$G$3*J6+$H$3*J6+$I$3*J6)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'3-planning'!C4","v":""},{"$f":"'3-planning'!D4","v":""},{"$f":"'3-planning'!E4","v":""},{"$f":"'3-planning'!F4","v":""},{"$f":"'3-planning'!G4","v":""},{"$f":"'3-planning'!I4","v":""}]
[4,"Support",1,{"$f":"($E$3*J7+$F$3*J7+$G$3*J7+$H$3*J7+$I$3*J7)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'4-support'!C4","v":""},{"$f":"'4-support'!D4","v":""},{"$f":"'4-support'!E4","v":""},{"$f":"'4-support'!F4","v":""},{"$f":"'4-support'!G4","v":""},{"$f":"'4-support'!I4","v":""}]
[5,"Operation",1,{"$f":"($E$3*J8+$F$3*J8+$G$3*J8+$H$3*J8+$I$3*J8)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'5-operation'!C4","v":""},{"$f":"'5-operation'!D4","v":""},{"$f":"'5-operation'!E4","v":""},{"$f":"'5-operation'!F4","v":""},{"$f":"'5-operation'!G4","v":""},{"$f":"'5-operation'!I4","v":""}]
[6,"Performance evaluation",1,{"$f":"($E$3*J9+$F$3*J9+$G$3*J9+$H$3*J9+$I$3*J9)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'6-performance evaluation'!C4","v":""},{"$f":"'6-performance evaluation'!D4","v":""},{"$f":"'6-performance evaluation'!E4","v":""},{"$f":"'6-performance evaluation'!F4","v":""},{"$f":"'6-performance evaluation'!G4","v":""},{"$f":"'6-performance evaluation'!I4","v":""}]
[7,"Improvement",1,{"$f":"($E$3*J10+$F$3*J10+$G$3*J10+$H$3*J10+$I$3*J10)/SUM($E$3:$I$3)","v":{"$error":"#VALUE!"}},{"$f":"'7-improvement'!C4","v":""},{"$f":"'7-improvement'!D4","v":""},{"$f":"'7-improvement'!E4","v":""},{"$f":"'7-improvement'!F4","v":""},{"$f":"'7-improvement'!G4","v":""},{"$f":"'7-improvement'!I4","v":""}]
[8,"Individual requirements",1,{"$f":"J11","v":""},null,null,null,null,null,{"$f":"'8-indiv requirements'!B4","v":""}]
["Overall result",null,null,{"$f":"(D4*C4+D5*C5+D6*C6+D7*C7+D8*C8+D9*C9+D10*C10+D11*C11)/SUM(C4:C11)","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE(E4:E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F4:F10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G4:G10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H4:H10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(I4:I10)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Company A",null,"Overview merged company results"]
[{"$f":"Overview!F4","v":0},null,"Occurence","Weighted Result category","availability","simplicity and speed","robstuness and stability ","efficiency","performance"]
["Category",null,"Weight (1-3)"]
[1,"Context"]
[2,"Leadership"]
[3,"Planning"]
[4,"Support"]
[5,"Operation"]
[6,"Performance evaluation"]
[7,"Improvement"]
[8,"Individual requirements",1]
["Overall result"]
[]
["Company B",null,"Overview merged company results"]
[{"$f":"Overview!F5","v":0},null,"Occurence","Weighted Result category","availability","simplicity and speed","robstuness and stability ","efficiency","performance"]
["Category",null,"Weight (1-3)"]
[1,"Context"]
[2,"Leadership"]
[3,"Planning"]
[4,"Support"]
[5,"Operation"]
[6,"Performance evaluation"]
[7,"Improvement"]
[8,"Individual requirements",1]
["Overall result"]
[]
["Company C",null,"Overview merged company results"]
[{"$f":"Overview!F6","v":0},null,"Occurence","Weighted Result category","availability","simplicity and speed","robstuness and stability ","efficiency","performance"]
["Category",null,"Weight (1-3)"]
[1,"Context"]
[2,"Leadership"]
[3,"Planning"]
[4,"Support"]
[5,"Operation"]
[6,"Performance evaluation"]
[7,"Improvement"]
[8,"Individual requirements",1]
["Overall result"]

{"sheet":"1-context","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,7],[3,0,3,1],[0,0,2,1]]}
["1 Context of the organization",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C8,C18,C19,C20),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D8,D18,D19,D20),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["understanding the organization and its context","understanding and considering issues arising from legal, technological, competitive, market, cultural, social and economic environments, whether international, national, regional or local; \nunderstanding and considering issues related to values, culture, knowledge and performance of the organization",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["Understanding the needs and expectations of interested parties","monitor and review information about interested parties that are relevant to the quality management system to provide continuously products and services that meet customer requirements and applicable statutory and regulatory requirements",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["determination of the scope of the quality management system","determine the boundaries and applicability of the quality management system and establish its scope, documentation of the scope with justification for any excluded requirements of DIN EN ISO 9001",null,null,null,null,null,null,""]
["quality management system",null,{"$f":"IFERROR(AVERAGE(C9:C17),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D9:D17),\"\")","v":""},"","","","",""]
["quality management system","establish, implement, maintain and continually improve a quality management system; ",null,null,null,null,null,null,""]
["process map *","showing organization of company and interdependencies of processes",null,null,null,null,null,null,""]
["coverage of norm requirements *","general assessment of 3rd party audits for certification",null,null,null,null,null,null,""]
["coverage of customer requirements *","general assessment of customer audits, satisfaction of customers concerning customer specific requirements",null,null,null,null,null,null,""]
["administration of management system *","general assessment of administration effort",null,null,null,null,null,null,""]
["process tree/document tree viewable *","systematic of processes and documents, interdependencies of documents",null,null,null,null,null,null,""]
["environment management *","general assessment of 3rd party audits for certification ISO 14001",null,null,null,null,null,null,""]
["ISMS *","general assessment of 3rd party audits for certification ISO 27001",null,null,null,null,null,null,""]
["processes of management system","determine the processes needed for the quality management system and their application throughout the organization; process content: input and output, sequence and interaction, criteria and methods needed to ensure effective operation and control, resources and their availability, responsibilities and authorities, risks and opportunities, evaluation and improvement of processes ",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"2-leadership","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,7],[3,0,3,1],[0,0,2,1]]}
["2 Leadership",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C12),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D12),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["leadership commitment","top management commitment and demonstration to the quality management system",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["customer focus","focus on enhancing customer satisfaction",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["quality policy","quality policy and quality objectives are compatible with the context and strategic direction of he company, communication of documented quality policy",null,null,null,null,null,null,""]
["Organizational roles, responsibilities and authorities","responsibilities and authorities for relevant roles are assigned, communicated and understood within the organization.",null,null,null,null,null,null,""]
["quality strategy and quality objective in alignment with new/future company strategy and company objectives *","readiness of the company concerning quality stratgy and quality objectives for future orientation",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"3-planning","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,0,2,1],[3,0,3,1]]}
["3 Planning",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C12),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D12),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["Risk management","adoption of new practices, launching new products, opening new markets, addressing new customers, building partnerships, using new technology and other desirable and viable possibilities to address the organization's or its customers' needs",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["opportunities management: ","integration and implementation of actions, evaluation of the effectiveness of these actions; avoiding risk, taking risk in order to pursue an opportunity, eliminating the risk source, changing the likelihood or consequences, sharing the risk, or retaining risk by informed decision",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["integration of risk and opportunity management in business processes","measurable, in consistence with quality policy",null,null,null,null,null,null,""]
["quality objectives","changes in structure of management system",null,null,null,null,null,null,""]
["planning of changes","assessment of correlation of as-is management system with future management system regarding general strategy and objectives",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"4-support","index":6,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,0,2,1],[3,0,3,1]]}
["4 Support",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C14,C18,C19,C20),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D14,D18,D19,D20),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["people","provide persons necessary for maintenance of quality management system and operation of processes",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["infrastructure","determine, provide and maintain the infrastructure necessary for the operation of its processes and to achieve conformity of products and services; infrastructure can include buildings and associated utilities, equipment including hardware and software, transportation resources, information and communication technology",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["environment for the operation of processes","determine, provide and maintain the environment necessary for the operation of its processes and to achieve conformity of products and services; suitable environment can be an combination of human and physical factors (social, psychological, physical)",null,null,null,null,null,null,""]
["monitoring and measuring resources","resources needed to ensure valid and reliable results in monitoring and measuring",null,null,null,null,null,null,""]
["measurement traceability","calibration/verification against measurement standards, identification, safeguarded from adjustments",null,null,null,null,null,null,""]
["organizational knowledge","knowledge management for safeguarding the organization from loss of knowledge and encouraging the organization to acquire knowledge",null,null,null,null,null,null,""]
["competence","training, experience, taking actions where necessary, documentation of competence",null,null,null,null,null,null,""]
["awareness","awareness of persons concerning quality policy, quality objectives, their contribution, implications of non-conformance with management system",null,null,null,null,null,null,""]
["communication ","internal and external communication relevant for management system ",null,null,null,null,null,null,""]
["document management",null,{"$f":"IFERROR(AVERAGE(C15:C17),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D15:D17),\"\")","v":""},"","","",null,""]
["document management","creation and updating, control of documented information, ",null,null,null,null,null,null,""]
["configuration management *","availability of systematic configuration management for management system",null,null,null,null,null,null,""]
["change management *","availability of systematic change management process for management system",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"5-operation","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,0,2,1],[3,0,3,1]]}
["5 Operation",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C8,C12:C17),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D8,D12:D17),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["operational planning and control","plan, implement and control the processes needed to meet the requirements for the provision of products and services, implement the actions determined, output of this planning suitable for the organization´s operation, control plannes changes and review the consequenes of unintended changes, taking action to mitigate any adverse effects",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["requirements for products and services","customer communication, determination, review and changes of the requirements for procucts and services, management of contract / order requirements",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["design and development of products and services","establish, implement and maintain a design and development process that is appropriate to ensure the subsequent provision of products and services; design and development planning, design and development inputs,  design and development controls, design and development outputs, design and development changes",null,null,null,null,null,null,""]
["supplier management",null,{"$f":"IFERROR(AVERAGE(C9:C11),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D9:D11),\"\")","v":""},"","","",null,""]
["supplier management","control of externally provided processes, products and services",null,null,null,null,null,null,""]
["systematic supplier audits *","regular execution of supplier audits in accordance to a systematic and planned supplier audit selection",null,null,null,null,null,null,""]
["adapted process for different supplier classes *","definition of different supplier classes and systematic corresponding actions",null,null,null,null,null,null,""]
["production and service provision","control of production and service provision, identification and traceability, property belonging to customers or external providers, preservation, post-delivery activities, control of changes",null,null,null,null,null,null,""]
["release of products and services","acceptance criteria, traceability to the persons authorizing the release",null,null,null,null,null,null,""]
["control of nonconfirming outputs","ensure that outputs that do not conform to their requirements are identified and controlled to prevent their uninteded use or delivery, control of nonconforming outputs after delivery",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"6-performance evaluation","index":8,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,0,2,1],[3,0,3,1]]}
["6 Performance evaluation",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5:C9,C13:C16),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5:D9,D13:D16),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["reporting system","monitoring, measurement, analysis and evaluation",null,null,null,null,null,null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["customer satisfaction","monitor customers' perceptions of the degree to which their needs and expectations have been fulfilled. The organization shall determine the methods for obtaining, monitoring and reviewing this information",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["complaint management / failure management with root cause analysis *","systematic process for handling complaints and failures",null,null,null,null,null,null,""]
["analysis and evaluation","conformity of products and services,  the degree of customer satisfaction, the performance and effectiveness of the quality management system, if planning has been implemented effectively, the effectiveness of actions taken to address risks and opportunities, the performance of external providers, the need for improvements to the quality management system",null,null,null,null,null,null,""]
["internal audit",null,{"$f":"IFERROR(AVERAGE(C10:C12),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D10:D12),\"\")","v":""},"","","",null,""]
["internal audit","conduct internal audits at planned intervals, audit programme, audit criteria and scope, auditor selection, audit reporting, correction and corrective actions, documented information as evidence fo the implementation of the audit programme and the audit results",null,null,null,null,null,null,""]
["covering ISO 19011 *","covers the requirements of ISO 19011 - guideline for audits of quality management systems and environment management system",null,null,null,null,null,null,""]
["management of internal auditors *","systematic qualification, training and introduction of new auditors, internal auditor release process, regular fresh-up trainings, same audit standard within internal auditors supported by standardized internal audit checklists, internal auditors centrally controlled by management system staff, centralized audit planning",null,null,null,null,null,null,""]
["management review","proper information with defined management review inputs and management review outputs",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"7-improvement","index":9,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,0,2,1],[3,0,3,1]]}
["7 Improvement",null,"Stage of maturity level"]
[null,null,"availability","simplicity and speed","robustness and stability","efficiency","performance","not applicable"]
[null,null," 1 - not available, process needed, but missing\n2 - available, process parts missing\n3 - available, aspects missing\n4 - available, all aspects included"," 1 - complicated / no standardization / transparency hardly recognizable / long process duration until output\n2 - Standardization of processes in an early stage / many exceptions and single solutions / slow process speed\n3 - standardized processes / clear and simple structure / acceptable speed for output\n4 - standardized processes / simple presentation / self explaining, clear structure / quick output"," 1 - initial process / low stability\n2 - committed and established process \n3 - improved process, accepted by employees and stakeholder / high stability\n4 - optimized process, high stability, successful external ad hoc audits possible / Best Practice"," 1 - high effort for process run necessary / high investment for understanding process and work with it / complex process\n2 - quite complex process / too much effort for process run / intended output not guaranteed\n3 - efficiency efforts successful integrated\n4 - high efficiency, low administration effort / highly automated process, standardized KPIs / slim process"," 1 - poor KPIs / poor output qualita / no standard output / no benefit / more reaction than action\n2 - most KPIs acceptable /reaction predominant\n3 - process performance and KPIs satisfying / benefit for company / more action than reaction\n4 - high output quality / continuous good KPIs / benefit for company"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",null,{"$f":"IFERROR(AVERAGE(C5,C9:C12),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D5,D9:D12),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H4=1,\" \",AVERAGE(C4:G4)),\"\")","v":""}]
["nonconformity and corrective action",null,{"$f":"IFERROR(AVERAGE(C6:C8),\"\")","v":""},{"$f":"IFERROR(AVERAGE(D6:D8),\"\")","v":""},"","","",null,{"$f":"IFERROR(IF(H5=1,\" \",AVERAGE(C5:G5)),\"\")","v":""}]
["nonconformity and corrective action","reaction to nonconformities, evalutaion of the need for action to eliminate the cause of the nonconformity, implement any action needed, reivew the effectiveness of corrective actions, update risks and opportunities, make changes to the quality management system if necessary",null,null,null,null,null,null,{"$f":"IFERROR(IF(H6=1,\" \",AVERAGE(C6:G6)),\"\")","v":""}]
["root cause analysis process *","complaint and failure classification, defined root cause analysis methodology for at least serious failures and (customer) complaints",null,null,null,null,null,null,{"$f":"IFERROR(IF(H7=1,\" \",AVERAGE(C7:G7)),\"\")","v":""}]
["effective action management *","active management of corrective and preventive actions, active risk management; clear defined KPIs for non-conformities and corrective actions",null,null,null,null,null,null,""]
["continual improvement","continuous improvement of suitability, adequacy, effectiveness of quality management system, consider results of analysis and evaluation, the outputs from management review for needs or opportunities as part of continual improvement",null,null,null,null,null,null,""]
["{Others main 1}",null,null,null,null,null,null,null,""]
["{Others main 2}",null,null,null,null,null,null,null,""]
["{Others main 3}",null,null,null,null,null,null,null,""]

{"sheet":"8-indiv requirements","index":10,"n_rows":89,"n_cols":3,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,0,2,0]]}
["8 Individual requirements"]
[null,"covers requirements"]
[null," 1 - no, not available\n2 - initially planned, not available or implemented\n3 - predominant available or implemented\n4 - yes, completely available or implemented"," 1- criteria not applicable"]
["* not required by DIN EN ISO 9001:2015",{"$f":"IFERROR(AVERAGE(B5,B25,B39,B76,B81,B86),\"\")","v":""}]
["efficiency *",{"$f":"IFERROR(AVERAGE(B6:B23),\"\")","v":""}]
["short and concise process descriptions, simple processes"]
["manageable amount of documents"]
["stability of management system"]
["low administration effort"]
["flexibility, room for individual processes"]
["high standardization rate"]
["central control by QM"]
["acceptance of stakeholder"]
["switch to high level structure possible"]
["clear defined KPIs"]
["automatical readout of KPIs"]
["simple and short release processes (e.g. document management)"]
["no paper work"]
["modern/contemporary management system"]
["company culture compatible with changes"]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]
[]
["internal QM organization *",{"$f":"IFERROR(AVERAGE(B26:B37),\"\")","v":""}]
["QM regarded as a benefit/support by other departments"]
["organisation chart with responsibilities and focus of QM staff available, communicated to employees"]
["Qualification/competence of QM staff"]
["central control of MS and all QM topics"]
["working environment/ team culture / cooperational internal atmosphere"]
["satisfaction of stakeholder as a support function"]
["cooperational and supporting mentality"]
["good overview of projects/operational perfomance"]
["beneficial input of QM for operational departments"]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]
[]
["database - requirements *",{"$f":"IFERROR(AVERAGE(B40,B52,B65,B68,B72,B73,B74),\"\")","v":""}]
["general criteria",{"$f":"IFERROR(AVERAGE(B41:B51),\"\")","v":""}]
["ease of access"]
["linking and correlation of data"]
["automatic versioning, backup and archive"]
["user management"]
["robustness"]
["simple and intuitive usage "]
["administratability"]
["migration"]
["cost effectiveness"]
["Quality 4.0 readiness"]
["CAQ elements"]
["document edition and administration",{"$f":"IFERROR(AVERAGE(B53:B64),\"\")","v":""}]
["simple distribution of documents"]
["centralized tracking of actions"]
["database support functions (e.g. automnatic reminder and alerts, automatic analysis and statistics)"]
["visibility of changes, changes notifications"]
["workflow management"]
["paperless release process"]
["robust templates"]
["simple graphical process design"]
["central management of interdependencies, links etc."]
["robust and automatic versioning"]
["central document list"]
["access statistics"]
["reports and KPIs",{"$f":"IFERROR(AVERAGE(B66:B67),\"\")","v":""}]
["automatic generation of reports and KPIs"]
["web based tracking list, survey tools corresponding with reporting tool"]
["information + presentation",{"$f":"IFERROR(AVERAGE(B69:B71),\"\")","v":""}]
["full text search"]
["simple navigation"]
["basis for knowledge management"]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]
[]
["Other requirement 1",{"$f":"IFERROR(IF(C77=1,\" \",AVERAGE(B77:B79)),\"\")","v":""}]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]
[]
["Other requirement 2",{"$f":"IFERROR(IF(C82=1,\" \",AVERAGE(B82:B84)),\"\")","v":""}]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]
[]
["Other requirement 3",{"$f":"IFERROR(IF(C87=1,\" \",AVERAGE(B87:B89)),\"\")","v":""}]
["{Others main 1}"]
["{Others main 2}"]
["{Others main 3}"]