Mastering Complexity : Adding Coherence Throughout Your Business with Dependency Structure Spreadsheets

The author covers fourteen tools to help you find the information you need and offers step-by-step instructions for constructing each one. He shows you how these tools can be combined with a set of simple problem-solving steps that can act as a powerful change agent to help reduce or eliminate process problems.

Five-Step Problem-Solving Process

Identify the problem: Clearly state what needs improvement.

Analyze: Determine what causes the problem to occur.

1. Evaluate Alternatives: Identify and select actions to reduce or eliminate the problem.
3. Test Implement: Implement these actions on a trial basis to determine their effectiveness.
5. Standardize: Ensure that useful actions are preserved.

Mastering Complexity is designed to help readers develop and maintain logical, adaptable solutions to business problems. It demonstrates how to visualize business dependency connections with a square spreadsheet called a Dependency Structure Matrix (DSM). Once the links representing dependencies are visualized in a DSM, it can be used to improve the business. The book focuses on simple practices that the reader can easily understand to solve business problems on his or her own.The book begins by identifying how logical elements are represented in a DSM spreadsheet. It shows where the elements can run in parallel, where the elements must run in sequence, and where the elements are tangled together. The book shows how to untangle these elements so they can be understood.The book then demonstrates how to build a dependency map in a DSM spreadsheet. It defines the various types of dependencies and shows how to order the spreadsheet elements to create a workflow. The author shows how to assign risk levels to the spreadsheet elements so a workflow can be optimized to manage risk. The book concludes with a look at several software tools that can be used to create, manipulate, and analyze DSM spreadsheets. It discusses how the tools work and where they can be ordered.