# How would you set up Claude to help automate electrical estimating from Excel price lists? — retained record

> Retained reddit record from reddit:ClaudeAI.

Canonical: https://highsignal.app/data/records/d24bac15b8c4a0ed

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:ClaudeAI)  published 2026-10-04 09:48 ingested 2026-10-05 02:37

[original source ↗](https://www.reddit.com/r/ClaudeAI/comments/1wxbrzu/how_would_you_set_up_claude_to_help_automate/)

## retained text



```
I work in the electrical contracting field, and I spend a lot of my evenings preparing quotations/estimates.

A big part of the process is repetitive. I normally receive a quantity takeoff / BOQ (usually Excel), then I have to:

Go through each item

Find the corresponding product/reference in supplier price lists

Apply our supplier discounts

Calculate our actual purchase price

Apply margins/labour where necessary

Fill everything back into the quotation

The price lists and discount tables are mostly Excel/PDF files and are always stored in the same folders. We also tend to use the same manufacturers and suppliers, so there are a lot of repetitive rules that could theoretically be learned.

I'd like to set up Claude so I could give it a new quantity map and have it automatically check those folders, identify the products, look up the prices, apply our discounts and generate a first draft of the quotation.

I don't expect it to make engineering decisions completely autonomously. Ideally, anything it can't confidently match would be flagged for me to review rather than guessed.

I'm not really looking to "train an AI model" from scratch. I'm trying to understand the best way to build this workflow around Claude.

Would you recommend Claude Projects, Claude Code + CLAUDE.md, MCP, Skills, or something else for this?

I'd also like the system to improve as I correct it — e.g. remembering that we normally use a particular Hager reference for a certain type of breaker, or that a particular supplier gets X% discount.

Has anyone built something similar for estimating, construction, electrical work, procurement, or working with large supplier price lists?

Any tutorials, GitHub projects, videos or examples you would recommend would be greatly appreciated.
```



document fetched 2026-10-05 00:22 · canonical https://reddit.com/r/ClaudeAI/comments/1wxbrzu/how_would_you_set_up_claude_to_help_automate
