{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instruction","Overview","Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,5,0],[6,0,9,0],[0,0,0,2]]}
["Instruction",null,null,"Navigation \n(click to start)"]
["Analysis phase / (verification phase)",1,"Start on slide \"overview\" and fill the marked area. You have the opportunity to assess processes in up to three merged companies in parallel. If you need only two entities, let \"C\" free and use only \"A\" and \"B\". "]
[null,2,"Press the button \"Start assessement\". This leads you to the slide \"analysis\", where you can start the assessment."]
[null,3,"Fill in the columns \"A\" and \"B\" (if needed also \"C\") the title of the processes you would like to assess. Enter parallel processes (e. g. supplier management) that exist in all merged entities in both (or all three) columns with their particular title (e.g. Company A: supplier management, company B: procurement). Both processes shall contain about the same process objectives/process output. "]
[null,4,"Assess the process (e.g. supplier management / procurement) for all merged sites, insert \"1\" for poor, \"2\" for fair, \"3\" for good or \"4\" for very good in the columns D-R for each process A and B (and C if needed). The stage of maturity is assessed for each process in the areas process design, process metrics, process performers, process infrastructure and process owner (based on Hammer, M., 2015. What is Business Process Management? In J. vom Brocke & M. Rosemann, eds. Handbook on Business Process Management 1. Berlin Heidelberg: Springer Berlin Heidelberg, pp. 3–16). If a process is available in one entity only, please insert this process, too, to get a complete process map. You can assess this single process, but it is not manatory, next steps for one-entity-processes follow in the conception phase."]
[null,5,"The result for each process A and B (and C if needed) appears automatically in the columns S-U. This result is the premise for the further decision to build your concept on process level. "]
["Conception phase",6,"Press the button \"CLICK HERE for taking decisions on process level\". Columns W-AA will appear and will support you to design the future process map for the merged entity. "]
[null,7,"Column W \"decision\" asks you to choose one of the following opportunities:\n- ONE process A/B/C: take over one of the already existing processes of one entity for the merged entity\n- NEW process: none of the already existing processes is of high maturity, so a new process with the requirements of all merged companies is developed\n- GATE-principle: an immediate process harmonization is not possible or not desired whereas a quick solution is needed. The GATE solution defines a harmonized output with individual process steps in the entities. \n- not needed: the assessed process is no longer needed and will not be regarded in the future process map"]
[null,8,"Columns X-AA request the future concept of the process. The new harmonized title, the process owner and the classification into management/support/core process is inserted here. The column \"coments\" is not mandatory to be filled, background information that led to the decision can be documented here."]
[null,9,"The slide \"overview\" shows the future harmonized process map according to the decisions taken for conceptioning the processes. "]

{"sheet":"Overview","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[23,0,23,7],[19,0,22,1],[0,0,0,7],[1,0,1,7],[2,0,7,1],[3,3,3,5],[6,3,6,5],[7,3,7,5],[2,2,2,5],[10,0,10,7],[4,3,4,5],[5,3,5,5],[15,0,18,1],[11,0,14,1],[9,0,9,7]]}
["ProMergeTool! for process level"]
["Overview"]
["This process maturity assessment aims to support merged companies in comparing the double or multi available processes up to three companies or company parts and take a decision for process harmonization as a premise for the conception phase. The spreadsheet \"explanation\" explains how to use this tool.",null,"Please insert your data:"]
[null,null,"Company (part) A"]
[null,null,"Company (part) B"]
[null,null,"Company (part) C"]
[null,null,"Assessor(s):"]
[null,null,"Date:"]
[]
["Result"]
["Process map after process harmonization"]
["Management process",null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A1))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A17))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A2))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A18))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A3))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A19))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$12)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$12)+1-ROW(A20))),\"\")","v":""}]
["Core process",null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A1))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A17))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A2))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A18))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A3))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A19))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$16)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$16)+1-ROW(A20))),\"\")","v":""}]
["Support process",null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A1))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A17))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A2))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A18))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A3))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A19))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Analysis!$X$5:$X$38,LARGE((Analysis!$Y$5:$Y$38=$A$20)*(ROW(Analysis!$Y$5:$Y$38)-4),COUNTIF(Analysis!$Y$5:$Y$38,$A$20)+1-ROW(A20))),\"\")","v":""}]

{"sheet":"Analysis","index":2,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,27,2,27],[3,27,37,27],[3,21,37,21],[0,21,2,21],[1,25,2,25],[1,26,2,26],[1,23,2,23],[1,24,2,24],[1,22,2,22],[0,18,0,20],[0,0,2,2],[0,3,0,17],[1,3,1,5],[2,3,2,5],[1,6,1,8],[2,6,2,8],[1,9,1,11],[2,9,2,11],[1,12,1,14],[2,12,2,14],[1,15,1,17],[2,15,2,17],[1,18,2,18],[1,19,2,19],[1,20,2,20]]}
["Process analysis",null,null,"Stage of maturity level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overview result",null,null,"Start Conception","Decision","New title","Process classificaion","Process owner","Comments"]
[null,null,null,"Process design\n- specification of a process\n- tasks to be performed by whom, wehen, in what locations, under what circumstances, degree of precision, information, like\n- conformity with company strategy\n- balance of process levels (standardisation vs. individualisation)\n- models, instruments, tools for process design",null,null,"Process metrics\n- end-to-end metrics\n- targets and performance monitored against metrics of customer needs and enterprise goals\n- set of metrics deployed for improvements: cost , speed, quality, ...\n- process controlling\n- KPIs",null,null,"Process performers\n- different set of skills and behaviours for working in processes\n- understanding of overall process and goals\n- teamswork, self-management capacities",null,null,"Process infrastructure\n- supportive integrated systems (ERP systems)\n- process transparency (process architecture, docuemntation, documentation process avaluation and continuity)",null,null,"Process owner\n- process owner responsible for end-to-end process\n- senior managers with authority and responsibility for a process across the organization as a whole\n- process organisation elements in a company\n- sustainability",null,null,{"$f":"Overview!D4","v":0},{"$f":"Overview!D5","v":0},{"$f":"Overview!D6","v":0},null,"ONE process\nNew process\nGATE-principle\nnot needed","process title after process harmonization","Management process\nCore process\nSupport process\nn.a.","Definition of process owner: responsible person for the process and its harmonization; definition of stakeholder if desired","strenghts and weaknesses\nyour comments (if needed)"]
[null,null,null," 1 - poor\n 2 - fair\n 3 - good\n 4 - very good",null,null," 1 - poor\n 2 - fair\n 3 - good\n 4 - very good",null,null," 1 - poor\n 2 - fair\n 3 - good\n 4 - very good",null,null," 1 - poor\n 2 - fair\n 3 - good\n 4 - very good",null,null," 1 - poor\n 2 - fair\n 3 - good\n 4 - very good"]
["process company A","process company B","process company C","A","B","C","A","B","C","A","B","C","A","B","C","A","B","C","A","B","C",null,null,null,null,null,null,null,"One process A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(D5,G5,J5,M5,P5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E5,H5,K5,N5,Q5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F5,I5,L5,O5,R5)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"One process B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(D6,G6,J6,M6,P6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(F6,I6,L6,O6,R6)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"One process C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"New process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"GATE principle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(D9,G9,J9,M9,P9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E9,H9,K9,N9,Q9)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Not needed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Management process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Core process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Support process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(D19,G19,J19,M19,P19)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E19,H19,K19,N19,Q19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(D20,G20,J20,M20,P20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E20,H20,K20,N20,Q20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F20,I20,L20,O20,R20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]