Skip to content
CyanBuild

Rebar takeoff spreadsheet: preserve bar marks and cutting lengths

A rebar takeoff spreadsheet has to carry the bar mark from the structural detail all the way to the count, because a length without a bar mark cannot be checked and a count without a bar mark cannot be ordered. Keep the drawing, the revision, the mark, the designation and the cutting length on the same row, and give anything that varies along a member its own row. The downloadable CSV below carries one labelled example: bar mark B1, a straight bar, 10 pieces at 12 ft, giving 120 linear feet. That demonstrates a multiplication and a row layout. It is not a cutting schedule, a bending detail or a reinforcement design. Development length, lap splice and hook requirements come from the approved design, and this worksheet does not calculate them.

By CyanBuild. Figures checked .

Carrying the bar mark, the mill mark and the shop mark on one row

Three marking systems meet on a rebar package, and the worksheet should hold the one the project uses. CRSI describes the marking sequence that a production mill applies to each bar: the first letter or symbol identifies the producing mill, the next marking is the bar size, the third marking symbol designates the type of reinforcing steel, usually S for carbon steel under ASTM A615 or W for low-alloy steel under ASTM A706, and a final marking gives the grade, 60, 75, 80, 100 or 120, expressed either as a numeral or as one to four deformation lines. A shop mark is added downstream for a piece fabricated for one job. Whichever convention the drawings use, put it on the row as its own field so a bar can be traced from the detail to the delivered bundle. ASTM A615 also requires that final products be marked by a tag, which is the tag that arrives with the shipment.

Reading the cutting length out of a detail rather than a dimension

A cutting length on a bar schedule is not the same number as the clear dimension on the plan. It usually includes the length needed for the hook, the bend allowance and the lap at the far end, and it is the fabricator who works from the schedule rather than the dimension. Take the length from the detail or the bar schedule that the drawings designate, and record which one you used in the reference column. Where the structural drawings give a dimension and the schedule gives a different cutting length, the schedule is the fabrication input and the difference is worth a note, because it is often where a quantity goes wrong. A mark that appears on a plan without a matching schedule entry needs an answer from the structural designer. Writing a guessed length into the row because the number is missing leaves a figure in the sheet that looks like a measurement.

Splitting a member where the detail changes along its length

A single member frequently carries two or more bar marks. A footing stem may have a different bar at the bottom than at the top, a beam may have a separate bar each side of a support, and a slab may be split by a construction joint. When the design changes along a member, split the rows so that each quantity follows its own detail, and record the zone each row covers. The alternative is to average, which produces a length that corresponds to no bar in the package. Where the split falls, record it: the station or the grid line that marks the change is the reference a reviewer needs. Where a member repeats identically across a floor, keep one row for it and record the repetition in a count or a note, and make sure the repetition is visible to anyone checking the total.

Turning a bar count into a weight with the right unit basis

A total linear length is not an order by weight, because weight depends on the bar that the length belongs to. CRSI records that the modulus of all steel reinforcement is 29,000,000 psi, that steel reinforcement is available with yield strengths from 40 to 100 ksi, and that the yield strength does not depend on the bar diameter. The same note records that CRSI encourages its producer members to return to an inch-pound bar marking system, because reducing confusion in the supply chain depends on a marking everyone can read. NIST Handbook 44 gives the mass relationships needed to finish the conversion, including 16 ounces to a pound, 256 drams to a pound and 7,000 grains to a pound. Keep the bar designation next to the length on the row so the weight conversion uses the right bar every time, and keep the unit basis of the source in the sheet.

Keeping laps, hooks and couplers out of the straight length

A cutting length that already includes a hook or a lap must not be adjusted again for the same feature, and the worksheet cannot tell you which it is. Two conventions exist in practice: the schedule gives the total length the fabricator must cut, or it gives the straight length and the fabricator adds the hooks. Records differ, so record the convention. Where the drawings define the splice and development lengths, they belong to the design and are not recalculated here. Where a mechanical coupler replaces a lap, it is a separate counted item with its own specification and its own unit, and it belongs on its own row. The same goes for dowels, chairs, spacers and other supports. Each of them is priced from its own scope, and folding them into a length row makes both the length and the accessory count wrong.

Reading the coating and the grade out of the specification

Coated bar is a different order from plain bar and it needs its own rows. ASTM A775 covers deformed and plain steel reinforcing bars with a protective epoxy coating applied by the electrostatic spray method, and ASTM A706 covers deformed and plain low-alloy steel bars for concrete reinforcement, whose nominal dimensions are equivalent to those of a plain round bar of the same weight. ASTM A615 covers deformed and plain carbon-steel bars in cut lengths and coils, with four minimum yield strength levels of 40, 60, 80 and 100 ksi and standard bar sizes and number designations given in its Table 1. Record the grade and the coating on the row, because a coated grade 60 bar and a plain grade 60 bar are not interchangeable in a quote, and a shop marks the bundle by grade as well as by size.

Reconciling the schedule with the plan before a purchase order

Before anything is ordered, walk the schedule against the plan in both directions. Every mark on the plan should appear in the schedule, and every mark in the schedule should appear on a drawing. Look for the marks that appear twice on the plan because the same member is drawn on a plan and on a section, and look for the marks in the schedule that have no visible location, which usually means the member belongs to a detail that the sheet you are reading does not carry. Check the revision column on every row, because a superseded detail and its replacement can carry the same mark and different counts. Record the reconciliation as a note rather than silently correcting a number. Where a duplicate or a missing mark cannot be resolved from the documents in hand, the responsible project team has to answer it, and the row stays open until it does.

What can you download and adapt?

A plain CSV worksheet you can open in Excel or another spreadsheet application. The values below are illustrative inputs, not measured project data. The CSV contains static values; it does not include formulas, macros, engineering checks or prices.

Illustrative register, not a certified bending schedule or reinforcement design.
DrawingRevisionBar markBar designationShape detailLength ftCountTotal LF
Example onlyAExample B1From designStraight example only1210120

The address receives the worksheet and occasional estimating notes. No account is created and no password is set.

What does CyanBuild software cost?

These are CyanBuild’s published software plans as checked on October 6, 2026. Each allowance is for PDF pages per month. You review the quantities; an outsourced takeoff service is a separate purchase.

Published monthly plans in USD. Source: CyanBuild pricing.
PlanMonthly pricePDF pages / month
Free$03
Starter$2930
Pro$99120
Enterprise$299400

Paid subscriptions renew according to their terms. A page allowance does not guarantee the completeness of a takeoff, and unused capacity does not turn the subscription into a per-project service. Check current features and terms before choosing a plan.

What else should you check?

Does the worksheet calculate lap splice and development lengths?
No. Lap, development, hook and bend requirements come from the approved design and from the applicable project requirements, and a worksheet that produced them would be inventing structural information. This is a quantity register. Where the drawings give a cutting length, that length is recorded as given. Where the drawing does not give one, the row stays open for the design team rather than carrying a spreadsheet default.
How do I get from 120 linear feet to a weight in pounds?
You need the bar designation and a verified unit-weight basis for that specific bar, and the sheet has to carry both. NIST Handbook 44 gives the mass relationships, but a length times a number only produces a weight when the number belongs to the bar on that row. Use a generic conversion across different bar sizes and the result looks plausible while being wrong. Keep the designation, the length and the count on the same row so the multiplication can be traced to its inputs.
What does the bar mark mean, and can I use it as the order quantity?
The bar mark is an identifier that links a bar to its detail, and the quantity sits in a separate column. CRSI describes the mill marking sequence, in which the mill identification comes first, then the bar size, then the type of steel, then the grade, with a shop mark added downstream for a piece fabricated for one job. The quantity comes from counting how many times that mark appears in the structure, which is what the count column records. The mark is what tells you which piece you counted.
Do I count a bar that changes shape part way along its length?
Count it as more than one bar if the design gives it more than one mark, and split the rows accordingly. A bar that bends in two directions is normally scheduled as two pieces with two marks and two lengths, and averaging them into one row produces a length that matches neither. Record the zone each row covers and the reference that establishes the split, so a reviewer can check both halves of the member against the detail.
Should a coated bar be counted on the same row as a plain bar?
Keep them apart. ASTM A775 covers epoxy-coated reinforcing bars applied by the electrostatic spray method, and CRSI records that reinforcing steel is generally produced to ASTM or AASHTO specifications including A615 for carbon steel, A706 for low-alloy steel, A955 for stainless and A1035 for low-carbon chromium. The grade, the coating and the producer all affect what a shop quotes, so the row has to hold the specification as well as the size and the length.
What do I do when the bar schedule lists a mark that does not appear on the plan?
Keep the row, flag it in the review column and reference the schedule line that produced it. A mark without a visible location usually means the member belongs to a detail or a sheet you have not opened, and it is also a common symptom of a superseded revision. Do not delete the row and do not silently leave it uncounted. Ask the structural designer to confirm the mark, its count and its location, then record the answer against the row.
Is the example count of 10 bars taken from a real project?
No. The 10 pieces at 12 ft giving 120 linear feet are illustrative values used to show the multiplication and the row structure, and the drawing field on the worksheet says so. They describe no structure, no footing and no slab. Use checked structural drawings for an actual takeoff, and keep the same column layout so a reviewer can follow each number back to the detail that set it.

Where do the figures and product facts come from?

Sources checked November 9, 2026. Published prices can change; verify the actual terms before purchasing. Worked examples on this page are labeled separately from published product or service facts.

Check a drawing before you choose a plan.

Create an account, upload a representative PDF and compare the draft quantities with your drawing.

Create a free account