Historical Cost Analysis with Claude Pro

Before uploading, collect what you have. You don't need everything. Start with what's accessible:

• Bid summaries: one-page estimate summaries showing total cost by CSI division or trade
• Unit cost records: any spreadsheets showing cost per SF, per LF, per CY for work items
• Job cost reports: actual costs from completed projects showing what things really cost vs. estimate
• Scope notes: any notes about what was included/excluded in each project

Organize files by project type in a folder (Healthcare, Office, Warehouse, Education).

What you should see: A folder with 10-30 files covering past bids and job costs.

Claude Projects let you maintain persistent context across multiple conversations, which makes them perfect for a reference database you'll query repeatedly.

1. Log in to {{tool:Claude.url}}
2. In the left sidebar, look for Projects and click + New Project
3. Name it: "Estimating Cost History: [Your Company Name]"
4. Add a project description: "Historical bid summaries, unit costs, and job cost reports for reference during estimating. Query for cost ranges, productivity rates, and historical benchmarks by project type."

What you should see: A new project workspace with an option to add files and set project instructions.

Click on Project Instructions (or similar settings area) and add:

You are a cost reference assistant for a commercial construction estimating team. You have access to our historical bid summaries and job cost reports. When asked about costs, always:
1. State which project(s) the data comes from
2. Give a range (low/high) not just an average
3. Note whether the cost is from a bid estimate or actual job cost
4. Flag if the data is older than 3 years (may need escalation adjustment)
5. Ask for project type and size context if not provided

1. In the project, click Add content or the upload button
2. Upload your bid summaries, unit cost records, and job cost reports
3. Add files in batches. PDF and Excel files work well
4. As you upload, consider adding a brief note to each file: "This is a 45,000 SF medical office completed 2024, actual costs"

What you should see: Files appear in the project's knowledge base. Claude can now reference these in all conversations within this project.

Start a new conversation inside your cost history project and ask a test question:

What are our historical costs for concrete slab-on-grade, including forming, placing, and finishing? Give me a range and note which projects this comes from.

What you should see: Claude references specific projects from your uploaded files and gives you a cost range. If it can't find data, it will tell you, which helps you identify gaps in your historical records.

Ask a higher-level question to test the analytical capability:

Based on the projects I've uploaded, what's our average cost per SF by project type (medical, office, warehouse)? Include only completed projects with actual costs where available.