# Structural Steel Fabrication Estimate Worksheet

> Source: https://netray.co/tools/structural-steel-fabrication-estimate-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Edit a member list with weights per foot, lengths and shop hours per ton to get weight, material, labor and bid price.

## Category

cost-finance

## Industry

Metal Fabrication

## Audience

- Estimator
- Steel detailer
- Project manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Mark

**Key:** mark

**Type:** text

#### Member

**Key:** member

**Type:** text

#### Shape

**Key:** shape

**Type:** select

**Options:**

- Wide flange
- HSS
- Angle
- Channel
- Plate
- Other

#### Weight per ft

**Key:** lbft

**Type:** number

**Unit:** lb/ft

**Help:** Plate: use 12 in wide strip, 40.8 lb/ft per inch of thickness.

#### Length

**Key:** len

**Type:** number

**Unit:** ft

#### Qty

**Key:** qty

**Type:** number

#### Material price

**Key:** cwt

**Type:** number

**Format:** currency

**Unit:** $/cwt

**Help:** Dollars per 100 lb.

#### Shop hours per ton

**Key:** hpt

**Type:** number

**Unit:** hr/ton

#### Shop rate

**Key:** rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Total weight

**Key:** wt

**Type:** number

**Expr:** lbft * len * qty

**Format:** number

**Unit:** lb

#### Material cost

**Key:** matl

**Type:** number

**Expr:** lbft * len * qty / 100 * cwt

**Format:** currency

#### Shop hours

**Key:** hrs

**Type:** number

**Expr:** lbft * len * qty / 2000 * hpt

**Format:** decimal

#### Labor cost

**Key:** labor

**Type:** number

**Expr:** lbft * len * qty / 2000 * hpt * rate

**Format:** currency

#### Line cost

**Key:** total

**Type:** number

**Expr:** lbft * len * qty / 100 * cwt + lbft * len * qty / 2000 * hpt * rate

**Format:** currency

**Rows:**

**Mark:** B1

**Member:** W12x26 floor beam

**Shape:** Wide flange

**Lbft:** 26

**Len:** 24

**Qty:** 12

**Cwt:** 78

**Hpt:** 18

**Rate:** 62

**Mark:** C1

**Member:** HSS4x4x1/4 column

**Shape:** HSS

**Lbft:** 12.21

**Len:** 14

**Qty:** 8

**Cwt:** 92

**Hpt:** 28

**Rate:** 62

**Mark:** L1

**Member:** L4x4x1/4 bracing

**Shape:** Angle

**Lbft:** 6.6

**Len:** 10

**Qty:** 16

**Cwt:** 82

**Hpt:** 40

**Rate:** 62

**Mark:** CH1

**Member:** C10x15.3 stair stringer

**Shape:** Channel

**Lbft:** 15.3

**Len:** 12

**Qty:** 4

**Cwt:** 80

**Hpt:** 45

**Rate:** 62

**Mark:** BP1

**Member:** Base plate 14x14x1

**Shape:** Plate

**Lbft:** 55.6

**Len:** 1

**Qty:** 8

**Cwt:** 88

**Hpt:** 35

**Rate:** 62

**Totals:**

#### Total weight (lb)

**Key:** wt

**Agg:** sum

**Format:** number

#### Material

**Key:** matl

**Agg:** sum

**Format:** currency

#### Shop hours

**Key:** hrs

**Agg:** sum

**Format:** decimal

#### Labor

**Key:** labor

**Agg:** sum

**Format:** currency

#### Direct cost

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Total tons

**Key:** tons

**Expr:** sum_wt / 2000

**Format:** decimal

#### Direct cost per ton

**Key:** cost_ton

**Expr:** sum_total / tons

**Format:** currency

#### Blended shop hours per ton

**Key:** hrs_ton

**Expr:** sum_hrs / tons

**Format:** decimal

#### Bid price (15 percent overhead, 10 percent profit)

**Key:** bid

**Expr:** sum_total * 1.15 * 1.10

**Format:** currency

**Primary:** true

#### Bid price per ton

**Key:** bid_ton

**Expr:** bid / tons

**Format:** currency

**Notes:** Weights are nominal AISC values per foot (W12x26 is 26 lb/ft, HSS4x4x1/4 is about 12.21, L4x4x1/4 is 6.6, C10x15.3 is 15.3). Hours per ton are placeholders that depend on complexity, so replace them with your own history. Add freight, galvanizing, paint, erection and detailing separately. Overhead and profit multipliers are fixed in the summary at 15 and 10 percent.

## Content

**Intro:** Structural steel is bought and sold by weight, so a clean estimate starts with a takeoff in pounds and ends in dollars per ton. This worksheet keeps each member on its own line and computes weight, material, shop hours and labor automatically.

**Sections:**

#### How to use it

**Body:** Add a row for each mark or group of identical pieces. Enter weight per foot from the AISC shape table, length, quantity and your current price per hundredweight. Enter shop hours per ton for that kind of piece and your shop rate. The computed columns produce weight, material, hours and labor, and the summary shows totals, cost per ton and a bid price.

**Bullets:**

- Light connection-heavy pieces need more hours per ton than big beams
- Group identical marks to keep the sheet short
- Export to Excel to attach to the bid package

#### The math

**Body:** Weight equals pounds per foot times length times quantity. Material cost equals weight divided by 100 times the cwt price. Shop hours equal tons times hours per ton, and labor equals hours times the shop rate. Direct cost is material plus labor, and the bid line applies overhead and profit multipliers. Plate is entered as a one foot strip, using 40.8 pounds per foot per inch of thickness for a 12 inch wide strip.

#### Reading the result

**Body:** Watch blended hours per ton and cost per ton rather than the grand total. If a job averages well above your normal hours per ton, the member list is heavy on small connection material or the hours inputs are too optimistic. Compare cost per ton against recent awards before submitting.

#### What it does not include

**Body:** The sheet covers shop fabrication only. Add detailing, shop drawings, anchor bolts, loose hardware, galvanizing or paint, shipping, erection and any inspection costs as separate lines or add-ons. Also add waste for cut offs on bar and plate, typically a few percent.

**Cta:** If you want estimates compared to actual shop hours and material usage by job, Netray can connect your ERP job costing to this method and show where bids drift.

**Faq:**

#### Where do I get weight per foot?

**Answer:** Use the AISC Steel Construction Manual shape tables or your mill supplier catalog. Wide flange, channel, angle and HSS all list nominal weight per foot.

#### How do I estimate plate?

**Answer:** Plate steel weighs about 40.8 pounds per square foot per inch of thickness. For a piece, compute area times thickness times 0.2836 pounds per cubic inch, then enter the total as weight per piece with length one.

#### What are typical hours per ton?

**Answer:** It varies widely with complexity, from low double digits for simple beams to several times that for light, connection-heavy work. Use your own job history, since placeholders here are only examples.

#### Is the bid price a quote?

**Answer:** No. It is a calculation based on the multipliers shown and the inputs you enter. Review scope, exclusions, escalation and risk before issuing a proposal.

## Search terms

structural steel estimating spreadsheet, steel fabrication estimate excel, steel takeoff worksheet, fabrication cost per ton, steel weight calculator beams, structural steel estimate template, shop hours per ton steel, steel fabrication bid sheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json