{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","McKinsey-Matrix","Hilfstabelle"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":"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",9]
[null,"Thema","Strategisches Projekt-Controlling"]
[]
[null,"Inhalt","McKinsey-Matrix"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"McKinsey-Matrix","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,0,5],[8,2,8,5],[16,2,16,5]]}
[null,null,"Produkte"]
["Kriterien","Gewichtung","A","B","C","D"]
["Marktvolumen",0.48,2,1,0,3]
["Marktentwicklung",0.31,3,0,2,1]
["Wettbewerbssituation",0.21,2,3,1,2]
["Marktattraktivität",{"$f":"SUM(B3:B5)","v":1},{"$f":"C3*$B3+C4*$B4+C5*$B5","v":2.31},{"$f":"D3*$B3+D4*$B4+D5*$B5","v":1.1099999999999999},0.83,2.17]
[]
[]
[null,null,"Produkte"]
["Kriterien","Gewichtung","A","B","C","D"]
["Marktanteil",0.24,2,1,0,3]
["Umsatzentwicklung",0.42,3,0,2,1]
["Profitabilität",0.34,2,3,1,2]
["Wettbewerbsstärke",{"$f":"SUM(B11:B13)","v":1},{"$f":"C11*$B11+C12*$B12+C13*$B13","v":2.42},{"$f":"D11*$B11+D12*$B12+D13*$B13","v":1.26},{"$f":"E11*$B11+E12*$B12+E13*$B13","v":1.18},{"$f":"F11*$B11+F12*$B12+F13*$B13","v":1.8199999999999998}]
[]
[]
[null,null,"Produkte"]
["Priorität",{"$f":"SUM(C18:F18)","v":1},0.12,0.32,0.18,0.38]

{"sheet":"Hilfstabelle","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[0.4,1,0,3,2,0]
[0.4,0,3,3,3,2]
[0.2,3,3,0,1,2]
[]
[null,{"$f":"B2*$A2+B3*$A3+B4*$A4","v":1},{"$f":"C2*$A2+C3*$A3+C4*$A4","v":1.8000000000000003},{"$f":"D2*$A2+D3*$A3+D4*$A4","v":2.4000000000000004},2.2000000000000002,1.2000000000000002]