> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/assistant/agent/workflows/analyze-a-workbook.md).
# Analyze a workbook
Use this workflow when you need to understand a workbook before you edit it, audit it, or hand it off to someone else. Agent can map the workbook structure, explain formulas, identify key assumptions, and point you toward the next best step.
{% hint style="info" %}
**Best first prompt:** "Summarize this workbook. Identify the main sheets, key inputs, outputs, assumptions, and anything that needs closer review. Include sheet or cell references where helpful."
{% endhint %}
## At a glance
* **Best for:** Workbook orientation, model handoff, formula explanation, and early review.
* **Output:** A workbook summary, key sheets, inputs, outputs, assumptions, review signals, and follow-up questions.
* **Recommended mode:** Read-only mode.
## When to use this workflow
Use this workflow when you need a fast read of a workbook, sheet, range, or model before deciding what to do next.
Common goals include:
* Understand the purpose of a workbook.
* Find the main inputs, outputs, and assumptions.
* Explain formulas and calculation flow.
* Identify unusual values or structures.
* Prepare for a cleanup, audit, or handover.
## Starter prompts by goal
### Understand the workbook structure
* "Summarize this workbook and identify the main sheets."
* "Analyze the active sheet and explain how it fits into the workbook."
* "Create an executive summary of this workbook for a reviewer."
### Find inputs, outputs, and assumptions
* "Find the main inputs, outputs, and assumptions in this model."
* "List the key assumption cells and explain what each one appears to control."
* "Return a table with Sheet, Cell or Range, Purpose, and Notes."
### Explain formulas and flow
* "Which formulas drive the final output?"
* "Explain the calculation flow from inputs to outputs."
* "Review the selected range and explain what the formulas calculate."
### Check whether the workbook is ready for review
* "Review the selected range and tell me whether it looks like a clean table."
* "Show the most important issues first. Include sheet and cell references."
* "List what you can confirm from the workbook, then list assumptions you are making."
## Recommended workflow
1. **Pick the scope.** Select the sheet or range you want Agent to review, or name the workbook area in your prompt.
2. **Ask for a summary first.** Start broad enough to understand the workbook, but ask Agent to include sheet or cell references when it finds something important.
3. **Review the evidence.** Check any cells, ranges, or sheets Agent points out before you rely on the answer.
4. **Drill into one area.** Ask a narrower follow-up about formulas, assumptions, outputs, or unusual structures.
5. **Choose the next workflow.** If you find risks, move to an audit workflow. If you need changes, move to an editing workflow and ask for a preview first.
## Good follow-up requests
Show follow-up prompts
* "Where are the hardcoded assumptions?"
* "Which sheets look unused or supporting-only?"
* "What should I review before changing this workbook?"
* "Group the findings by Inputs, Calculations, Outputs, and Review notes."
* "Turn this into a short handover note for another analyst."
## Tip
Ask Agent to separate workbook evidence from interpretation when the workbook is unfamiliar. For example: "List what you can confirm from the workbook, then list assumptions you are making."
## Next best workflows
Use these pages when analysis turns into review, editing, or version comparison.
{% content-ref url="/pages/etefVmN87rI7HeGpM8kh" %}
[Audit a workbook](/assistant/agent/workflows/audit-a-workbook.md)
{% endcontent-ref %}
{% content-ref url="/pages/GkuuR40uEzhgWq74cjRe" %}
[Edit cells, ranges, and sheets](/assistant/agent/workflows/edit-cells-ranges-and-sheets.md)
{% endcontent-ref %}
{% content-ref url="/pages/eTbBJTerG3NPw9Jka3fd" %}
[Compare workbooks](/assistant/agent/workflows/compare-workbooks.md)
{% endcontent-ref %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.coherent.global/assistant/agent/workflows/analyze-a-workbook.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.