The original Miller Heiman process used physical paper. Today, spreadsheets offer distinct advantages:
However, the danger is turning a strategic tool into a messy data dump. The secret to success is structured layout.
In complex B2B environments, sales failure rarely results from product shortcomings; it stems from an inability to navigate human consensus. Miller Heiman’s solution to this problem is the Blue Sheet (part of the Strategic Selling framework). The sheet forces sellers to move beyond the "economic buyer" and consider coaches, users, and technical buyers. miller heiman blue sheet excel
However, paper forms are siloed. The Excel version of the Blue Sheet serves three critical functions:
The Excel Blue Sheet typically consists of 5 core modules. Each module corresponds to columns or tabs in a workbook. The original Miller Heiman process used physical paper
If you are building your own, here is the exact column order I recommend for Data Entry (Row 1 headers):
A Role (Dropdown: EB, UB, TB, Coach)
B Name
C Title
D Power (1-Low to 5-High)
E Influence (1-Low to 5-High)
F Stance (Pro, Neutral, Con)
G Personal Win
H Action Plan
I Our Contact
J Last Meeting However, the danger is turning a strategic tool
Then, on a separate "Dashboard" sheet, use SUMIF and CHARTS to visualize the data.
Sample Dashboard Formula: