Here is a free miscellaneous metals estimating template for Excel. It prices stairs, handrail and guardrail, ladders, lintels, grating and checker plate, bollards, canopy frames, and embeds by the unit: you enter flights, linear feet, openings, and panels, and each tab turns them into weight, shop hours, and cost. A summary tab builds the bid, and a checklist of commonly missed items sits at the back.
Free. Needs a free Steelflo account (also includes 3 free takeoffs, no card).
The download needs a free Steelflo account (no card). The file has no macros and no watermark, and it works in Excel, Google Sheets, and LibreOffice. Yellow cells are inputs; grey cells are locked formulas.
Misc metals do not price like framing. A stair or a run of rail carries far more shop time per pound than a floor beam, so a per-ton price borrowed from structural steel will misprice the package. This template estimates the way the work is actually done: by unit, with hours you control. For the background, read the miscellaneous metals estimating guide.
What's Inside the Template
| Tab | What it does |
|---|---|
| ReadMe | Instructions and how the weights are calculated |
| Inputs | Material $/ton, grating $/ft2, shop labor rate, shop hours per unit (editable defaults), coating, freight, field install, contingency, overhead, profit |
| Stairs | Per flight: risers, rise and run, stringer section, pan or grating treads, landings |
| Handrail & Guardrail | Per linear foot: post spacing, post and rail sections, rail count, optional pickets, post base plates |
| Ladders | Rails, rungs at your spacing, extension above the top, optional cage |
| Lintels | Per opening: width, bearing at each end, angle section, angles per opening |
| Grating & Checker | Per ft2: grating, checker plate, or plain plate, cutouts, edge banding |
| Bollards | Pipe length, cap and base plates, fill allowance |
| Canopy Frame | Rafters, header and fascia, hangers |
| Embeds & Plates | Plate size, quantity, studs or anchors |
| Summary | Per-tab weight, material, hours, labor, coating, total; cost build-up to a bid price |
| Commonly Missed | A 32-line checklist to run before you submit |
| Sections | Pounds per foot for AISC W, S, HP, C, MC, L, WT, HSS and pipe, plus plate, flat, round and square bar |
Each item tab has a green worked-example block (a storage mezzanine) at the top and a block for your own items beneath it. Their totals are kept apart on the Summary tab, so the example never leaks into your bid.
How to Use It
- Set the Inputs tab first. The hours-per-unit table matters more than any other input: hours per riser, per landing, per linear foot of rail, per vertical foot of ladder, per lintel, per square foot of grating, per bollard. The values that ship are example starting points. Replace them with numbers from your own completed jobs.
- Work one item type at a time. Fill one row per item on the matching tab, under YOUR ITEMS. Type sections as they appear on the drawing:
C12X20.7,PIPE1-1/2STD,L4X3-1/2X1/4,PL1/4X12,RB3/4. - Read the Check column. Each row says
ok,INCOMPLETEif a needed input is blank, orCHECK SECTIONif a designation is not in the Sections tab. The Summary tab counts these flags and they must be zero before you trust a total. - Compare cost per ton. The Summary shows bid price per pound and per ton. If your misc metals package comes out near your structural per-ton price, check your hours.
- Run the checklist. Go through Commonly Missed and mark each line Priced, Not in scope, or N/A.
If you are also taking off the structure, pair this with the free steel takeoff template for the framing and the steel estimating spreadsheet for its cost build-up.
How Each Tab Turns Units into Cost
The logic is the same on every tab, so once you read one you can read them all.
Quantities to weight. Each tab uses the geometry that governs that item. Stairs compute stringer slope length from risers, rise, and run, then add treads and landings. Rail tabs count posts from the run and spacing. Ladders count rungs from the height and spacing. Plates use thickness times width times length times 0.2836 lb per cubic inch, a figure you can check by hand. Shapes and pipe come from the Sections lookup.
Weight to material. Weight times a waste allowance, priced at a shapes rate or a plate-and-bar rate. Grating is priced per square foot, which is how it is bought.
Units to shop hours. This is where misc metals differ from framing. Hours come from the per-unit table on the Inputs tab, not from weight. Two stairs of equal weight can take very different time depending on riser count and landings, and the sheet reflects that.
Hours to labor and total. Hours times your loaded rate, plus coating by finish, plus material. On the Summary tab, freight and field install are added, then contingency, overhead, and a profit markup.
The geometry is simplified on purpose: straight stringers, flat pan treads, circular cage hoops. Treat the output as a solid estimate to be tightened against shop drawings, not as a detailed weight.
Worked Example: A Mezzanine Stair and Guardrail
The example blocks price the stair and rail package for a storage mezzanine. Every figure below comes from example inputs, so it shows the mechanics, not a price for any real job.
- Stair ST-1: one flight, 16 risers at 6.75 in with an 11 in run, 42 in wide, C12X20.7 stringers, 12-gauge pan treads, and one 4 by 3.5 ft landing with 1/4 in plate on C6X8.2 framing.
- Guardrail GR-1: 60 LF, posts at 5 ft, 1-1/2 in pipe top and mid rails, 3.5 ft posts.
- Stair handrail HR-1: 38 LF, posts at 4 ft, one rail.
- Embeds EP-1: four 1/2 by 8 by 8 in plates with four studs each, galvanized.
| Tab | Weight (lb) | Shop hours | Total cost |
|---|---|---|---|
| Stairs | 1,220 | 30.6 | $3,333 |
| Handrail & Guardrail | 684 | 53.9 | $4,450 |
| Embeds & Plates | 36 | 2.8 | $265 |
| Subtotal | 1,940 | 87.3 | $8,048 |
Add freight ($82) and field install ($2,062) for a direct cost of $10,192. Contingency (3%), overhead (12%), and an 8% profit markup bring the bid to $12,698, which is $6.54 per pound or about $13,088 per ton on 0.97 tons.
Look at that per-ton number. It is a long way from a typical structural per-ton price, and this is the pattern the guides describe: stair cost per flight and stairs and railings takeoff both explain why misc metals are quoted by the unit. In this example about three quarters of the shop cost is labor, because the hours are large relative to the weight. Your numbers will differ, and the point of the template is that you can see which input is doing the work.
The same package of 16 risers works out to roughly $208 per riser before rails, markup, and install on the Stairs tab alone. Change the hours per riser on the Inputs tab and watch that figure move.
The Items That Get Missed
Misc metals bids lose money on omissions more than on bad arithmetic: handrail returns and extensions, wall brackets, toe plates, ladder standoffs, cutouts in grating, embed delivery for early pours, shop drawings, galvanizing vent holes. The Commonly Missed tab lists 32 of them with why each gets skipped and where to look. Work through it before every submission, and read the lintel takeoff guide and the mezzanine takeoff guide for the items that tie to those scopes.
Where a Spreadsheet Breaks Down
You still count by hand. Misc metals are scattered across plans, sections, details, and schedules. Finding every stair, rail run, lintel, and embed is most of the work, and the template does none of it.
Quantities come from the drawing, not the sheet. A rail length scaled off a plan and a rail length from a section can disagree. Nothing in a spreadsheet will tell you.
Simplified geometry. The template does not model custom stair shapes, curved rail, or monumental work. Price those from a detailed takeoff.
Revisions mean redoing it. A revised plan changes lengths and counts across several tabs.
If the counting is your bottleneck, a takeoff tool helps: with Steelflo you upload a PDF, it boxes the steel labels it finds on each page, you review the boxes, and you export a BOM for pricing. You can look at a public sample takeoff first. For a quick weight on a single section, the steel weight calculator is faster than opening a workbook. The longer comparison is in steel estimating templates vs software.
Frequently Asked Questions
How do you estimate miscellaneous metals?
Price them by the unit: per flight or riser for stairs, per linear foot for rail, per opening for lintels, per square foot for grating. Convert quantities to weight and shop hours, then add material, coating, freight, install, and markups.
Why not price misc metals per ton?
Misc metals carry much more shop time per pound than framing, so a framing per-ton price usually underprices them. Pricing by the unit with hours you control avoids that.
Is the misc metals template free?
Yes. The download needs a free Steelflo account with no card. The workbook has no macros, no watermark, and no usage limit.
Are the hours and prices in the template accurate for my shop?
No. Every rate and hour in the file is an example starter value so the sheet works when you open it. Replace them with quotes and your own job history before you bid from it.
Can I add my own sections?
Yes. Add rows below the table on the Sections tab, with the designation in column A and pounds per foot in column B. The lookups read rows 2 through 3000.
Does it work in Google Sheets?
Yes, and in LibreOffice. The workbook uses standard functions only.
Spending your days counting? Start a free takeoff with SteelFlo: upload a PDF drawing set, review the boxed members, and export a BOM. The template stays yours either way.