Miller Heiman Blue Sheet Excel

This is a complete guide to understanding, creating, and using a Miller Heiman Blue Sheet in Excel. The "Blue Sheet" is the strategic planning tool associated with the Miller Heiman Sales Methodology , specifically designed for Complex Sales . While the official tool is a physical paper form or a proprietary digital platform (part of Salesforce), many organizations recreate it in Excel for customization and ease of distribution.

Part 1: What is the Blue Sheet? The Blue Sheet is not just a document; it is a thinking process. It forces a salesperson to move away from "closing the deal" and focus on "managing the process." Its primary purpose is to map the Political Landscape of the buying organization and identify gaps in your sales strategy. The Core Components:

Buying Influence: Who are the people involved? Response Modes: How do they feel about change? Win-Results: What personal value do they get? Best Action Plan: What do you do next?

Part 2: Building Your Excel Template (The Layout) If you are building this in Excel, do not simply make a list. Use the grid structure to map relationships. Tab 1: Opportunity Overview miller heiman blue sheet excel

Account Name: Opportunity Description: Date: Current Phase: (Region 1 to 5 in Miller Heiman terms, e.g., "Growth" or "Trouble").

Tab 2: The Buying Influence Matrix (The Heart of the Sheet) Create a table with the following column headers. This is where the heavy lifting happens. | Role (Type) | Name & Title | Response Mode | Degree of Influence | Rating (Support) | Win-Result (Personal Win) | Leverage From/To | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | EB (Economic Buyer) | Who gives final approval? | Growth, Trouble, Even, Overconfident | Final | 1-5 (Enemies to Champions) | What is in it for them personally? | Who influences them? | | TB (Technical Buyer) | Who vets the specs? | ... | Gatekeeper | ... | ... | ... | | UB (User Buyer) | Who uses the product? | ... | Advisory | ... | ... | ... | | Coach | Your guide inside | N/A | Varies | N/A | ... | ... |

Part 3: How to Fill It Out (The Logic) You cannot fill a Blue Sheet correctly without understanding the Miller Heiman definitions. Here is how to populate your Excel file. 1. Identify the Buying Roles This is a complete guide to understanding, creating,

Economic Buyer (EB): The person who can say "Yes" when everyone else says "No." They control the budget. Usually only one person. Technical Buyer (TB): They focus on specifications and feasibility. They can say "No," but usually cannot say "Yes." (e.g., IT, HR, Legal). User Buyer (UB): The people who will actually use your product/service. They care about how it affects their daily work. Coach: Someone inside the account who wants you to win and guides you. You must have a Coach to succeed.

2. Determine Response Mode (Why would they change?)

Growth: They want to make something better (optimistic). Trouble: They have a problem that needs fixing now (urgent). Even: Things are fine; they want to maintain the status quo. Overconfident: They think things are better than they actually are. Excel Tip: Use Data Validation to create a dropdown menu for these options to keep your data clean. Part 1: What is the Blue Sheet

3. Define the "Win-Result" This is the most critical column. A Win-Result is not "They save money." That is a corporate result.

Corporate Result: Saves 10% on overhead. Win-Result (Personal): The VP of Operations gets recognized for efficiency; the User gets to go home on time; the CFO hits their quarterly bonus target.