AI prompts for lean: A3, 8D, PDCA and the X-Matrix, ready for Claude in Excel
AI earns its place in lean when it erases the reporting, not the thinking. With the prompts on this page, an assistant such as Claude in Excel drafts the A3 boxes that compile facts, compiles the PDCA Check, writes the 8D report and audits the X-Matrix, so the team spends its hours at the gemba, on root causes and on decisions. Each prompt drafts, compiles or challenges; none of them decides.
Most prompts assume an open workbook; the others take pasted notes. Paste one, adjust the bracketed parts, keep the sentences that forbid inventing data. They work in Claude in Excel and Copilot in Excel; the read-only ones also work with the .xlsx uploaded to Claude or ChatGPT.
The rule: AI writes, the team decides
Every lean prompt on this page drafts, compiles or challenges; none chooses a root cause, sets a target, picks which objective an initiative serves or replaces a visit to the floor. Each asks the assistant to use only what it is given and to list what is missing instead of filling it, because an invented figure in an A3 is worse than an empty cell. Why that rule makes AI compatible with lean is argued in our guide to AI in lean management.
How to use these prompts in Excel
Any assistant that can read a workbook can run these lean prompts, and Claude in Excel, Anthropic’s add-in for Microsoft Excel, can also write into it. Open the workbook, open the assistant, paste a prompt, replace the parts in [brackets]. The prompts that write into the workbook (fill, link) need an assistant working inside Excel; with an uploaded .xlsx, use the read-only ones (audit, D4, Check, agenda).
Before pasting customer complaints or production data, check your company’s AI policy and use the plan it approves. The 8D prompts ask the assistant to strip customer names and personal data from what it writes.
X-Matrix prompts: fill, link and audit your hoshin matrix
Three prompts fill, link and audit a hoshin X-Matrix in Excel. They use the sheet names of the free hoshin.app template (X-Matrix, Action Plan, KPI Bowler) and its band layout: breakthrough objectives North, annual objectives East, initiatives South, KPIs West. On another layout, replace the band names with yours.
The template records one kind of link, initiative to annual objective, in the Action Plan. The other links of the X (breakthrough to annual objective, objective to KPI) need a decision by the team, so the audit prompt turns them into questions instead of guessing them.
I am pasting our strategy notes below. Fill the X-Matrix sheet of this workbook with what the notes contain: up to 5 breakthrough objectives (3-5 years) in the North band, the annual objectives that serve them in the East band, the improvement initiatives in the South band, and the KPIs that prove progress in the West band, written as 'KPI — target: x / current: y'. Each band has 4 rows; use the empty row below it for a fifth. Use only objectives, initiatives and KPIs that appear in our notes, in our words: leave a band short rather than invent. Where a target or a current value is missing, leave '…' and list your questions at the end. [paste your notes]
In the Action Plan sheet, list every initiative of the South band in column A. Fill column B with the annual objective (East band) it serves only where our notes or the matrix state the link, using the exact title. Where you would be guessing, leave column B empty and write 'suggested: <exact objective title> — confirm' in Notes; where nothing fits, write 'orphan: keep, attach or stop?'. Then, in column A of the KPI Bowler, replace the 'KPI 1' to 'KPI 4' placeholders with the West KPI titles, same wording, without the target and current part. Set each Type to 'result' if the KPI measures an outcome, 'performance' if it measures a process; where you cannot tell, leave Type empty and ask.
Act as a hoshin facilitator reviewing this X-Matrix before our strategy review. Use only the links the workbook records: the initiative-to-annual-objective links in column B of the Action Plan. Never infer a link from the wording. Report the initiatives with no annual objective, the annual objectives that no initiative serves, and the KPIs with no Type. Then list, as questions for the team, the links the workbook cannot hold: which annual objectives serve each breakthrough objective, and which KPIs measure each annual objective. Give me the five fixes that matter most, in order, citing the cells. Do not change the workbook.
A3: challenge the analysis without writing it
The A3 is a one-page problem-solving report built on the PDCA cycle. The thinking belongs to the team; the drafting, the Pareto and the follow-up table do not have to cost it hours. The prompt below is the one that matters most: it challenges the analysis without writing it.
Our guide to AI for A3 problem solving gives a prompt for every box of the A3, from the background to the follow-up, plus one for the mentor.
Here is our 5-whys chain: [paste]. Challenge it like a lean coach. For each 'why', say whether it is a verified fact, an assumption or a logical jump, and what we should go and see on the floor to confirm it. Flag as a logical jump any step that blames a person or ends in 'lack of training' without data to show it. Do not propose a root cause yourself.
8D: check the D4 root causes before they escape again
The 8D is the eight-discipline method for quality problems, most often customer complaints, formalized by Ford in the late 1980s and widely required across the automotive supply chain. Its most expensive trap is a root cause that explains the defect but not why it escaped to the customer (D4), which the prompt below checks.
Our guide to AI for 8D reports gives a prompt for every discipline from D2 to D8, including the containment check and the customer report.
Here is our D4 analysis: [paste]. Check it against the data in this workbook if one is open; otherwise say which data would confirm each cause. Sort the causes we gave into occurrence (why the defect was made) and non-detection, Ford's escape point (why it was not caught before the customer). If our analysis gives no cause on one side, say it is missing; do not supply one. For each cause, state the evidence that supports it, how it was verified, and what would disprove it. Flag any cause stated without evidence. Do not propose a root cause yourself.
PDCA prompts: lighten the Check and the Act
Plan-Do-Check-Act stalls at Check, because compiling results is tedious, and at Act, because standardizing is paperwork. Those are the two steps to hand to an assistant.
The KPI Bowler sheet holds monthly target and actual values. For the last month with an actual value, list the KPIs that are off target, by how much (in % of target, or as an absolute gap when the target is zero) and for how many consecutive months. Treat empty cells as missing, not zero. If a KPI's name does not make clear whether higher or lower is better, ask instead of guessing. Add the initiative each KPI depends on only if the workbook records that link; otherwise write 'no link recorded'. No commentary.
This countermeasure worked; the results are pasted below. Draft the Act step on one page: the standard to update, which roles or stations need training (from our notes, no names), what to check in three months to make sure the gain holds, and, as questions, where else the same standard could apply. Mark with [TO CONFIRM] anything our notes do not establish. [paste the results]
Prepare the agenda of our monthly hoshin review from this workbook. Put first the points that need a decision: KPIs off target with no countermeasure recorded in the Notes column of the Action Plan (or in the notes pasted below), blocked initiatives, initiatives with no annual objective in the Action Plan. Then one line for each remaining item. Use only what the workbook records, and list what is missing instead of filling it.
From the spreadsheet to a living system
The A3 and the 8D are where problems get solved; the X-Matrix is where a company decides which problems matter. The link between them is usually lost in a folder: the initiative in the matrix and the A3 that carries it never meet again after the kick-off.
In hoshin.app, every link of the X is one click, each initiative carries a link to its A3, its project or its 8D, and an AI assistant connected through MCP reads the whole matrix to prepare the review. To start, fill the free X-Matrix template with the prompts above, then score it with the free X-Matrix checker: no account needed.
Frequently asked questions
Can I run these prompts in ChatGPT or Copilot instead of Claude?
Yes. The prompts are plain language and assume only that the assistant can read the workbook: Copilot in Excel, or the .xlsx uploaded to ChatGPT or Claude. The prompts that write into the workbook need an assistant working inside Excel, such as Claude in Excel or Copilot in Excel.
What is the difference between A3, 8D and PDCA?
PDCA (Plan-Do-Check-Act) is the improvement cycle underneath both. The A3 is a one-page format that walks a team through that cycle for any problem. The 8D is an eight-discipline method for quality problems, most often customer complaints, with explicit containment and verification steps.
Which prompt should I start with?
The PDCA Check if you already track KPIs monthly, because it saves time on the first run. The X-Matrix audit if your next strategy review is close, because it shows the missing links before the room does.
Do I need hoshin.app to use these prompts?
No. They work on any workbook. The free X-Matrix template gives you the sheets the X-Matrix prompts expect, and the app is where the matrix becomes a living system that agents keep current.