{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Reifegrad-Tabelle","Reifegrad-Diagramm","Aktionsplan"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Reifegrad-Diagramm","index":2,"reason":"not_a_worksheet"}],"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",8]
[null,"Thema","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","Reifegrad"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Reifegrad-Tabelle","index":1,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"Bewertung [%]",null,null,null,null,"Ergebnis","Kommentare"]
["Level",null,0,0.25,0.5,0.75,1,{"$f":"AVERAGE(H8,H12,H18,H22,H28,H32,H35,H39)","v":0.42500000000000004},"Reifegrad"]
["1.1","Prozess benannt",null,null,null,null,"x"]
["1.2","Der/Die Prozessverantwortliche (PV) ist bestimmt",null,null,null,null,"x"]
["1.3","Der/DiePV ist qualifiziert",null,null,"x"]
["1.3","Die Rolle des/der PV ist festgelegt",null,null,null,"x"]
["1.4","Die Bereitstellung (finanziell, personell,…) ist erfolgt",null,null,null,"x"]
["1","Prozessverantwortlich",{"$f":"COUNTA(C3:C7)","v":0},{"$f":"COUNTA(D3:D7)","v":0},{"$f":"COUNTA(E3:E7)","v":1},{"$f":"COUNTA(F3:F7)","v":2},{"$f":"COUNTA(G3:G7)","v":2},{"$f":"SUM(D8/4+E8/2+3*F8/4+G8)/COUNTA(A3:A7)","v":0.8}]
["2.1","Das Prozessteam (PT) ist festgelegt"," ",null,"x"]
["2.2","Das Rollenverständnis ist geklärt"," ","x",null,null,null,null," "]
["2.3","Die Verfügbarkeit des PT ist sichergestellt "," ",null,null,"x"]
["2","Prozessteam",{"$f":"COUNTA(C9:C11)","v":3},{"$f":"COUNTA(D9:D11)","v":1},{"$f":"COUNTA(E9:E11)","v":1},{"$f":"COUNTA(F9:F11)","v":1},{"$f":"COUNTA(G9:G11)","v":0},{"$f":"+(D12/4+E12/2+3*F12/4+G12)/COUNTA(A7:A11)","v":0.3}]
["3.1","Die Qualifizierung des PT ist gegeben"," ","x"]
["3.2","Die Prozessbeschreibung ist erstellt"," ",null,null,null,"x"]
["3.3","Die Prozessplanung ist erstellt"," ","x"]
["3.4","Die Risiken sind dokumentiert"," ",null,"x"]
["3.5","Die Anforderungen an den Prozess sind dokumentiert"," ",null,null,"x"]
["3","Prozessanalyse",{"$f":"COUNTA(C13:C17)","v":5},{"$f":"COUNTA(D13:D17)","v":2},{"$f":"COUNTA(E13:E17)","v":1},{"$f":"COUNTA(F13:F17)","v":1},{"$f":"COUNTA(G13:G17)","v":1},{"$f":"+(D18/4+E18/2+3*F18/4+G18)/COUNTA(A13:A17)","v":0.55000000000000004}]
["4.1","Prozessziele (PZ) sind festgelegt und dem PT bekannt"," ","x"]
["4.2","Die Kennzahlen zur Überprüfung der PZ sind bestimmt"," ","x"]
["4.3 ","Die Kennzahlen (KZ) werden periodisch ausgewertet"," ",null,"x"]
["4","Prozessziele und -kenngrößen",{"$f":"COUNTA(C19:C21)","v":3},{"$f":"COUNTA(D19:D21)","v":2},{"$f":"COUNTA(E19:E21)","v":1},{"$f":"COUNTA(F19:F21)","v":0},{"$f":"COUNTA(G19:G21)","v":0},{"$f":"+(D22/4+E22/2+3*F22/4+G22)/COUNTA(A17:A21)","v":0.2}]
["5.1","Soll-Ist-Vergleich von PZ und KZ wird durchgeführt"," ",null,"x"]
["5.2","Prozess-Reviews werden durchgeführt"," ",null,null,"x"]
["5.3","Die Schulung zum Bewertungsmodell ist erfolgt"," ","x"]
["5.4","Die Schulung zum Bewertungstool ist erfolgt"," ",null,null,"x"]
["5.5","Stärken und Schwächen sind dem PT bekannt"," ",null,"x"]
["5","Prozessbewertung",{"$f":"COUNTA(C23:C27)","v":5},{"$f":"COUNTA(D23:D27)","v":1},{"$f":"COUNTA(E23:E27)","v":2},{"$f":"COUNTA(F23:F27)","v":2},{"$f":"COUNTA(G23:G27)","v":0},{"$f":"+(D28/4+E28/2+3*F28/4+G28)/COUNTA(A23:A27)","v":0.55000000000000004}]
["6.1","Die PZ sind priorisiert"," ",null,null,"x"]
["6.2 ","Optimierungen sind geplant","x"]
["6.3","Optimierungen sind umgesetzt","x"]
["6","Prozessoptimierung",{"$f":"COUNTA(C29:C31)","v":3},{"$f":"COUNTA(D29:D31)","v":0},{"$f":"COUNTA(E29:E31)","v":0},{"$f":"COUNTA(F29:F31)","v":1},{"$f":"COUNTA(G29:G31)","v":0},{"$f":"+(D32/4+E32/2+3*F32/4+G32)/COUNTA(A27:A31)","v":0.15}]
["7.1","Prozessleistung wird regelmäßig an GL berichtet"," ",null,null,"x"]
["7.2","Die GL unterstützt den/die PV bei der Realisierung","x",null,null,null,"x"]
["7","Prozessmanagement",{"$f":"COUNTA(C33:C34)","v":2},{"$f":"COUNTA(D33:D34)","v":0},{"$f":"COUNTA(E33:E34)","v":0},{"$f":"COUNTA(F33:F34)","v":1},{"$f":"COUNTA(G33:G34)","v":1},{"$f":"+(D35/4+E35/2+3*F35/4+G35)/COUNTA(A30:A34)","v":0.35}]
["8.1","Erfahrungsaustausch mit anderen Unternehmen"," ",null,null,null,"x"]
["8.2","Externer Kennzahlenvergleich findet statt"," ",null,null,null,"x"]
["8.3","Benchmarking wird durchgeführt"," ",null,"x"]
["8","Prozessbenchmarking",{"$f":"COUNTA(C36:C38)","v":3},{"$f":"COUNTA(D36:D38)","v":0},{"$f":"COUNTA(E36:E38)","v":1},{"$f":"COUNTA(F36:F38)","v":0},{"$f":"COUNTA(G36:G38)","v":2},{"$f":"+(D39/4+E39/2+3*F39/4+G39)/COUNTA(A34:A38)","v":0.5}]

{"sheet":"Aktionsplan","index":3,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Aktion","Verbesserungspotenzial/ Benchmark-Anregung","Maßnahmen","Aufwand (PT)","Aufwand (EUR)","Nutzen","Priorität","verantwortlich","Termin","Status"]
["1.1","PZ sind nicht nach SMART ausgerichtet","Meeting der Prozess-Verantwortlichen PV + GL","5 MT",null,"Klare Definition der PZ naxh SMART","hoch","PV",null,"i.V."]
["1.2",null,"PT-Befragung zu den Zielvorstellungen",null,null,null,"mittel","PV","sofort","i.A."]
["1.3",null,"Abstimmung der PZ im Zielvereinbarungsgespräch",null,null,null,"hoch","PV","sofort","ok"]
["2.1","Es fehlen KZ","Erarbeitung der fehlenden KZ","2 MT",null,"Überprüfung der Prozessleistung","hoch","PV","sofort","i.A."]