# Turn Revit schedules into a costed quantity table

> Prompt · level: starter · about 30 min · paste into: Claude · ChatGPT · Gemini · Claude Cowork · checked 2026-09-30
> ES: Convierte tablas de planificación de Revit en cantidades con costo

Map exported schedule rows to cost items with units and waste factors, flag what cannot be mapped, and never invent a price.

**Before you paste:** Schedules exported from Revit as CSV or Excel · Your price list or quotes.

## Prompt (copy everything inside the block, then fill the [BRACKETS])

```text
I am attaching quantity schedules exported from Revit [list the files] and my price source [price list / quotes / "none yet"].

Build a costed quantity table:
1. Read every schedule. For each row, keep: category, family/type, key parameters, quantity and unit exactly as exported.
2. Normalize units (m, m2, m3, units) and say which conversions you made.
3. Map each type to a cost item from my price source. Where there is no match, leave the price EMPTY and add the row to a "to price" list. Never invent a price or pick a "typical" value.
4. Apply waste factors only if I give them: [e.g. concrete 3%, block 5%, tiles 8%, or "ask me"].
5. Output a table: item code, description, unit, quantity, waste %, quantity with waste, unit price, subtotal, source of the price.
6. Then list: rows you could not map, types with zero or blank quantities, and anything that looks double counted (for example, the same wall in two schedules).

End with the total of priced items, and state clearly what percentage of the rows are still unpriced. Answer in my language.
```

## Notes for the agent presenting this
- Show the block above verbatim in one code block; tell your human where to paste it (Claude · ChatGPT · Gemini · Claude Cowork).
- Point out the [BRACKETS] and offer to fill them together first.
- Pair with `apu-unit-price` when the human has quantities but no unit prices.
- The "percentage still unpriced" line keeps the human from mistaking a partial budget for a total.

## Related
- [Build a unit price analysis (APU) you can defend](https://aibuilderacademy.netlify.app/prompts/apu-unit-price.md) (prompt)
- [Quantity takeoff from an IFC file (IfcOpenShell)](https://aibuilderacademy.netlify.app/prompts/ifc-quantity-takeoff.md) (prompt)
- [Audit a Revit model through MCP before you trust it](https://aibuilderacademy.netlify.app/prompts/revit-model-audit.md) (prompt)

---
AI Builder Academy · https://aibuilderacademy.netlify.app · checked 2026-09-30 · Made by Lo que habitas (Julián Páez). Agents: search more at https://aibuilderacademy.netlify.app/api/search?q=… or connect https://aibuilderacademy.netlify.app/mcp. Request a new prompt: aibuilderacademy@agentmail.to.