Find out where your organization is losing energy before you invest in restructuring, training or new systems. This toolkit gives you a ready-to-use diagnostic survey based on Marvin Weisbord's Six-Box Model, extended with two areas that matter for any change effort: Attitude to Change and Agility. Responses are scored automatically and turned into a one-page dashboard that shows which areas are healthy, which need watching, and where to start.
WHAT IS INSIDE
The workbook has a cover page and six working sheets. Start Here explains the method, the answer codes and how to read the scores. Questionnaire is a printable survey of 24 forced-choice questions plus two closing questions: the three areas that drain the most energy, and an optional description of the last piece of work that got stuck. It shows no area names, so respondents are not steered. Responses is where you enter one row per respondent, with group (Leadership or Staff), an optional unit, the 24 answers as codes 1 to 4, and the three energy-drain picks. Settings holds the status thresholds, your list of units and an editable scoring key. Scoring converts every answer to a 1 to 7 scale and averages each area automatically. Dashboard shows scores by area for the whole organization, for leadership and for staff, the perception gap between the two groups, a radar map of all eight areas, an energy-drain count, a ranking from weakest to strongest, a suggested starting point, and results by unit.
WHY FORCED CHOICE
Agree or disagree surveys tend to come back with agree everywhere, which tells you nothing. Here every question offers two respectable statements and no middle option, so respondents have to lean one way. The healthy side alternates between the two statements, so a respondent who ticks the same column throughout averages around the middle and is flagged automatically for you to review.
PROTECTING ANONYMITY
The unit field is optional, and results for a unit appear only when it has at least three responses. The minimum is adjustable in Settings.
THE EIGHT AREAS
Purposes, Structure, Relationships, Rewards, Leadership, Helpful Mechanisms, Attitude to Change and Agility. All questions are original wording written for forced-choice use.
COMPATIBILITY
No macros and no add-ins. Works in Excel 2010 and later, Excel 365, LibreOffice and Google Sheets. You can also copy the questions into any online form tool and paste the answers back in.
WHO IT IS FOR
HR leaders, organization development practitioners, consultants and executives who need a quick, structured picture of organizational health before a change program, a restructuring or a leadership development effort.
PLEASE NOTE
All responses in the file are fictional sample data. A survey shows where to look, not why, so follow low-scoring areas with interviews or focus groups before deciding on action.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Organizational Design, Organizational Development Excel: Six-Box Organizational Diagnosis Toolkit Excel (XLSX) Spreadsheet, Sara Afshar Azad
|
Download our FREE Organization, Change, & Culture, Templates
Download our free compilation of 50+ slides and templates on Organizational Design, Change Management, and Corporate Culture. Methodologies include ADKAR, Burke-Litwin Change Model, McKinsey 7-S, Competing Values Framework, etc. |