🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Manufacturing & Marine › Drafting / CAD / BIM › BIM Workflows for Manufacturing and Marine Drafting › Lesson 11
MFG-DRAF17-06 · Lesson 11 · 10 clock hours · lab

BIM Data, Schedules, and Quantity Takeoffs

Objective. Students will extract a material takeoff and a structural framing schedule from a Revit model, export the data to a spreadsheet, and verify quantities against a manually calculated reference.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a licensed engineer or certified journey-level tradesperson or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

What BIM Data Can Do for You

A Revit model is not just a set of drawings — it is a database. Every wall, beam, floor slab, and column you place carries properties: material, dimensions, mark number, and more. Schedules and quantity takeoffs pull that data out of the model and organize it so estimators, fabricators, and project managers can use it. In manufacturing and marine drafting, accurate material counts directly affect procurement costs and build schedules, so getting these numbers right is a core professional skill.

Material Takeoffs

A Material Takeoff (MTO) in Revit is a special schedule type that reports on the materials assigned to model elements rather than on the elements themselves. For example, a concrete masonry unit (CMU) wall element may contain two materials — CMU block and mortar — and the MTO can report the area and volume of each separately.

To create a Material Takeoff:

1. Go to View → Schedules → Material Takeoff.

2. Select the element category you want to analyze (for example, Walls).

3. In the Fields tab, add Material: Name, Material: Area, and Material: Volume.

4. Use the Filter tab to limit results to specific materials, such as Concrete or CMU, to reduce noise in the report.

5. Sort and group by Material: Name so totals appear cleanly at the bottom of each group.

Revit calculates area and volume automatically from the geometry you have modeled. These numbers are only as accurate as the model itself, which is why you must verify them against an independent hand calculation before trusting them for procurement.

Structural Framing Schedules

A Structural Framing Schedule lists every beam (and other framing members) in the model. In marine and manufacturing projects, beam schedules drive steel orders, fabrication drawings, and erection sequences. A complete schedule must show at minimum: Mark, Type, Length, and Material.

To build one:

1. Go to View → Schedules → Schedule/Quantities.

2. Choose the Structural Framing category.

3. Add the fields: Mark, Family and Type (acts as the type label), Length, Structural Material.

4. On the Sorting/Grouping tab, sort by Family and Type so all similar beams appear together.

5. Use the Formatting tab to set Length units to feet and inches.

Revit does not have a built-in fill-color conditional format the way Excel does, but you can use the Appearance tab or add a Calculated Value field to flag beams below a threshold. A common workaround is to add a Yes/No calculated parameter: `IF(Length < 6', "FLAG", "")`. After export to CSV, full conditional formatting can be applied in the spreadsheet application.

Exporting Schedules to CSV

Once your schedules look correct inside Revit:

1. Open the schedule view.

2. Go to File → Export → Reports → Schedule.

3. Choose a destination folder and set the file type to Delimited Text (*.txt) or accept the default, then change the extension to .csv when prompted — Revit's export dialog lets you choose the delimiter (comma is standard).

4. Open the file in Excel or an equivalent spreadsheet application.

5. Format column headers in bold, apply number formatting to area and volume columns, and set column widths for readability.

Always keep the raw exported CSV separate from your formatted working copy so the original data is preserved.

Verifying Quantities by Hand

Software can misreport if elements overlap, if a material is applied incorrectly, or if a wall is modeled at the wrong height. A quick hand check on two or three key values is standard practice before submitting any takeoff.

For a concrete wall, the volume check is:

Volume = Length × Height × Thickness

For a CMU wall area, the check is:

Area = Length × Height

Compare your hand-calculated values to the Revit schedule values. A difference of more than 5% signals a modeling error or a filter problem that must be resolved before the data goes to procurement.

Discrepancy Reporting

When you find a difference between your hand calculation and the schedule value, document it in a brief written note: state what the values are, calculate the percentage difference, and explain the most likely cause (for example, a wall modeled at the wrong height, or a material assigned to only part of an element). Clear documentation protects you and your team professionally.

Workstation and File Safety

BIM lab sessions carry low physical hazard, but data safety is a real concern:

Accurate schedules and takeoffs are the link between the digital model and real-world materials. Master this workflow and you add measurable value on any manufacturing or marine project from day one.

Key terms8

Material Takeoff (MTO)A Revit schedule type that reports the area, volume, and other properties of the materials assigned to model elements, used for procurement and cost estimation.
Structural Framing ScheduleA schedule listing all structural framing members (such as beams) in a Revit model, including fields like mark, type, length, and material.
CSV (Comma-Separated Values)A plain-text file format in which data fields are separated by commas; used to transfer schedule data from Revit into spreadsheet applications.
Conditional FormattingA spreadsheet feature that automatically changes the appearance of a cell (such as color or font) when its value meets a defined condition, used here to flag beams below a minimum length.
Calculated Value FieldA user-defined field in a Revit schedule that applies a formula to existing parameter data, such as flagging elements that fall outside an acceptable range.
Quantity VerificationThe process of independently checking schedule-reported quantities against hand calculations or a reference sheet to confirm model accuracy before data is used for procurement or fabrication.
Schedule FilterA condition applied in a Revit schedule to display only elements or materials that meet specific criteria, such as showing only CMU or concrete materials.
MarkA unique identifier assigned to a structural element in Revit that corresponds to the element tag on construction drawings, enabling traceability between the model and fabrication documents.

Worked examples4

1. A CMU wall is 24 feet long and 10 feet high. Your Revit Material Takeoff reports the wall area as 247 sq ft. Is this within the acceptable 5% tolerance?
  1. Calculate the hand-checked area: Area = Length × Height = 24 ft × 10 ft = 240 sq ft.
  2. Find the difference: 247 − 240 = 7 sq ft.
  3. Calculate the percentage difference: (7 ÷ 240) × 100 = 2.92%.
  4. Compare to the 5% threshold: 2.92% < 5%, so the value is within tolerance.
Answer: The Revit value of 247 sq ft is within the 5% tolerance (2.92% difference). The discrepancy could be caused by Revit including a small return or reveal in its area calculation. No correction is required, but note the difference in your verification paragraph.
2. A concrete wall is 18 feet long, 12 feet high, and 8 inches (0.667 ft) thick. Revit reports the material volume as 144.5 cubic feet. Check whether this is within 5% tolerance.
  1. Calculate the hand-checked volume: Volume = Length × Height × Thickness = 18 × 12 × 0.667 = 144.07 cu ft.
  2. Find the difference: 144.5 − 144.07 = 0.43 cu ft.
  3. Calculate the percentage difference: (0.43 ÷ 144.07) × 100 = 0.30%.
  4. Compare to the 5% threshold: 0.30% < 5%, so the value is within tolerance.
Answer: The Revit reported volume of 144.5 cu ft is within tolerance (0.30% difference). This is an acceptable result; record the values and move on.
3. Your Structural Framing Schedule shows a beam with a reported length of 5.5 feet. Write the calculated value formula expression you would use in Revit (or note in your spreadsheet) to flag this beam, and confirm whether it should be flagged.
  1. The flagging rule: flag any beam with Length < 6 ft.
  2. In a Revit Calculated Value field (Yes/No type), the expression is: Length < 6' (using Revit's formula syntax with the feet symbol).
  3. Evaluate: 5.5 ft < 6 ft → TRUE, so the calculated value returns Yes (or "FLAG" if formatted as text).
  4. In Excel after CSV export, the equivalent formula in a helper column would be: =IF(A2<6,"FLAG","") where A2 contains the length in feet.
Answer: The beam at 5.5 ft is shorter than the 6 ft threshold and must be flagged. The Revit formula Length < 6' returns Yes for this element. In Excel, the IF formula displays "FLAG" in the conditional column.
4. Your exported framing schedule shows 12 beams. After sorting by type, you count: 5 W8×31 beams and 6 W10×49 beams. How many beams are unaccounted for, and what should you do?
  1. Add the sorted counts: 5 + 6 = 11 beams accounted for.
  2. Subtract from total: 12 − 11 = 1 beam is unaccounted for.
  3. Return to the Revit model and check whether any framing element lacks a type assignment or has a different category that excluded it from the schedule filter.
  4. Correct the element's type or category in the model, regenerate the schedule, and re-export the CSV.
Answer: One beam is unaccounted for. You must investigate the model — likely the beam has no type assigned or is in the wrong category. Correct the model data, regenerate the schedule, and re-export before submitting.

The math in this lesson2

Learners check Revit-reported quantities against a 5 percent tolerance.
7.RP.3G-GMD.3
Brush up in the math halls at newSchoolWorks.com:
In class: Students create a Revit Material Takeoff schedule for concrete and CMU materials, displaying area and volume columns, then cross-check two values by hand-calculating from the floor plan dimensions. · Students build a Structural Framing Schedule listing mark, type, length, and material for all beams in the model, sort by type, and apply conditional formatting to flag any beam shorter than 6 feet. · Students export both schedules to CSV using Revit's export function, open the CSV in a spreadsheet application, format columns, and submit the file with a one-paragraph note explaining one discrepancy found during verification.
Materials: Autodesk Revit, spreadsheet application (Microsoft Excel or equivalent), student workstations, instructor-prepared reference quantity sheet.
Check: Exported schedules compared to instructor answer key; material quantities must be within 5% of the reference values, and the framing schedule must contain all required fields to pass.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

BIM data management and documentation
1. In Revit, which schedule type is designed to report the area and volume of individual materials assigned to model elements rather than the count of elements themselves?
Quantity verification and applied mathematics
2. A CMU wall section is 30 feet long and 9 feet high. What is the wall area you would use to hand-verify a Revit Material Takeoff entry?
Quantity verification and applied mathematics
3. You are verifying a Revit concrete volume. Your hand calculation gives 120 cu ft and Revit reports 128 cu ft. What is the percentage difference, and does it pass the 5% tolerance check?
BIM software operation — Autodesk Revit
4. Which Revit tab in the Schedule Properties dialog allows you to display only beams made of a specific material, such as steel?
BIM data exchange and interoperability
5. After exporting a Revit schedule using File → Export → Reports → Schedule, what file format does Revit produce that can be opened directly in a spreadsheet application?
BIM documentation and drawing coordination
6. In a Structural Framing Schedule, the 'Mark' field serves what primary purpose?
BIM data management and professional practice
7. Which best practice should you follow to preserve original exported schedule data when formatting it in a spreadsheet?
BIM model quality control and coordination
8. Your framing schedule sorts all beams by type and you notice one beam has no type listed — the field is blank. What is the most appropriate corrective action?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →