
Welcome to this workshop focused on metric calculations using Building Information Modeling (BIM).
Throughout this course, you will explore key software tools such as Revit, Navisworks, and Dynamo, learning how to work with them in various environments to extract precise metric data from your building models.
Metric calculations refer to construction quantities and cost estimates that are accurate enough to support different project phases, from conceptual design through pre-construction documentation and beyond.
Key Topics Covered:
Introduction to BIM and metric calculations
Overview of Revit schedules and their role in metric data extraction
Use of Navisworks and Dynamo to complement metric computations
Applications of quantity take-offs during design and pre-construction
Role of metric calculations in procurement and project control
Practical Value in BIM Workflows:
Enable accurate construction quantity estimations
Support detailed cost estimation early in the project
Improve procurement and construction phase control
Facilitate building maintenance through data management
By the end of this lecture, you will understand the foundational concepts of BIM-based metric calculations and be ready to dive into the basic schedule functionalities within Revit, setting the stage for deeper learning in subsequent lessons.
This lecture focuses on creating and customizing schedule views in Revit to facilitate accurate metric estimations within BIM workflows. You will learn the basics of working with scheduling tools, including how to generate tables for specific categories such as walls. This process helps organize project information related to quantities, areas, and volumes necessary for precise cost estimation.
The workflow starts by selecting the category for the schedule and assigning meaningful names to help identify planning tables. You will explore how to add useful parameters like area and volume, which are critical for construction and demolition cost calculations. The lesson emphasizes how to manipulate schedule settings, including filtering elements based on criteria and sorting or grouping for clearer data visualization.
Additionally, you will see how to create calculated parameters within schedules, enabling you to include adjustments such as abundance factors to improve volume estimations. Overall, this lesson covers foundational skills to optimize quantity take-offs using Revit's scheduling capabilities.
Key Topics Covered:
Accessing and creating schedule views in Revit
Selecting categories and defining schedules for specific elements like walls
Adding and managing parameters such as area and volume
Using filters to control which elements appear in schedules
Sorting, grouping, and summarizing schedule data
Creating calculated parameters with formulas
Applying abundance factors in volume calculations for demolition estimates
Practical Value for BIM Metric Computations:
Enhances accuracy in estimating quantities for walls and other elements
Improves workflow efficiency through automated scheduling and filtering
Allows detailed cost estimation by incorporating calculated fields
Facilitates data organization for better project management and reporting
By the end of this lecture, you will understand how to create and customize Revit schedules tailored to metric computations. You will be able to develop detailed quantity take-offs that support precise estimations and streamlined BIM project execution.
In this lecture, we delve deeper into material quantification within multi-layer elements in Revit, such as walls, roofs, and slabs. Unlike simple category-based schedules, we explore how to obtain detailed quantity take-offs for individual materials embedded in these complex elements.
You will learn how Revit organizes multi-layer elements by composition and how to use material takeoff schedules to isolate and quantify materials like ceramic tiles, frieze, masonry blocks, and roofing components separately. This refined approach allows you to distinguish different materials within the same construction element, improving accuracy in your metric computations.
The workflow involves creating a new schedule specifically focused on materials instead of categories, configuring fields and parameters that capture areas and volumes by material type, and sorting/grouping the data for clearer presentation. The lecture guides you through these steps using a roof example, demonstrating how to list layers such as asphalt tiles and wooden grooves distinctly with their respective measurements.
Key topics covered:
Understanding the concept of multi-layer elements in Revit
Differentiating between category schedules and material takeoffs
Creating and customizing material takeoff schedules
Adding relevant parameters like material name, area, and volume
Sorting and grouping schedules by material for clear reports
Extracting quantities for individual materials within a single element
Practical value in BIM metric computations:
Accurate quantity estimation for varied materials within complex elements
Improved project cost and material management with detailed takeoffs
Enhanced reporting capabilities in Revit for multi-layer construction parts
Enabling precise budgeting and procurement based on material specifics
By the end of this lesson, you will be able to create material-based schedules that separate quantities by material layers inside multi-layer elements, enabling you to generate more detailed and actionable metric computations for your BIM projects.
In this lecture, we delve deep into refining metric computations in Revit by focusing on the creation of parts to enhance accuracy and detail in multi-layered building elements. Previously, we've explored the general concept of metric calculations through schedules, but this class highlights the limitations when working solely with multi-layer elements, such as slabs, where internal finishes and materials may vary substantially.
Multi-layer elements like slabs contain multiple material layers, for example, a terracotta finish and a concrete slab underneath. While assigning layers in Revit gives a base structure, it does not adequately reflect the real-life variations of materials across different zones or rooms within a project. For instance, in a building, some sections of the slab might have terracotta tile while others might feature ceramic or other types of tiles in bathrooms or porches.
To address this, this lesson teaches a powerful technique in Revit: the creation of parts. Using the “Create Parts” tool, Revit parcels out each layer of a multi-layer element into separate selectable objects. This breakdown allows you to manage and modify each material layer as an individual element rather than a unified entity, opening the path for more granular control over the modeling process and measurements.
Once the parts are created, the next challenge is to reflect real-world material distribution. This is done by subdividing parts with the “Divide Parts” tool through sketching boundaries directly on the slab sections. This offers a practical way to differentiate areas with distinct floor finishes by drawing partitions within the parts themselves, such as terracotta in porches, ceramic tiles in bathrooms, or wooden patterns in other areas.
Importantly, the lecture balances the need for level of detail and practicality. It advises against overly complex subdivisions, such as creating borders for every wall or removing parts extensively, which can become tedious for large floor plans. Instead, it encourages sensible subdivisions where precision matters most, maintaining a smooth workflow without excessive manual work.
The process continues by modifying material properties for each subdivided part. The instructor demonstrates how to set a material override within the parts, changing finishes like the terracotta default to wood, tile, or other textures drawn from the material library. This step enhances visualization and ensures that schedules and quantity take-offs reflect the true finish applied to each area.
Finally, the lecture concludes by emphasizing that using parts is the only effective method to enable subdividing different material sections in multi-layer elements and achieve a highly detailed and accurate measurement schedule. This technique takes accuracy beyond the native multi-layer element capabilities in Revit, providing a robust solution for BIM quantity take-offs.
Key topics covered in this lecture:
Limitations of multi-layer elements in representing variable material finishes
Using the “Create Parts” tool to dissect multi-layer elements into individual parts
Understanding parts visibility in 3D and floor plan views
Subdivision of parts using the “Divide Parts” sketch tool
Balancing level of detail with workflow efficiency in subdividing parts
Applying material overrides to subdivided parts for accurate finishes
Practical selection and hiding techniques to manage parts in complex models
Enhancing measurement accuracy by detailed part creation and subdivision
Integrating part-based modeling into BIM quantity take-off workflows
Practical value in BIM metric computations:
Enables precise measurement of complex multi-layer elements with varying materials
Improves accuracy in quantity take-offs by reflecting real material distributions
Allows customized subdivision of building elements to match architectural details
Facilitates visual differentiation of materials in 3D views for stakeholder communication
Supports efficient workflow by recommending balanced detailing without over-complication
Provides methodology to override material appearances directly on parts
Enhances downstream processes like scheduling, cost estimation, and procurement
Upon completing this lecture, learners will understand how to enhance BIM model accuracy by creating and subdividing parts within multi-layer elements in Revit. They will be able to subdivide and assign distinct materials to sections of slabs or floors, greatly improving the fidelity of metric computations and enabling precise, practical quantity take-offs for complex architectural projects.
In this lecture, we explore how to leverage parts created within Revit to perform detailed metric calculations using schedules. After subdividing elements into parts, such as with walls, we use planning schedules to quantify and organize data effectively.
The process starts by selecting the parts category and creating a schedule specific to those parts. We use material as a key grouping parameter to tabulate precise area and volume values, which are essential for accurate quantity take-offs in BIM. The generated schedule displays various materials like concrete base, terracotta, ceramic tiles, and their respective measurement data.
Although this detailed approach provides substantial insight, the formatting of schedules may need adaptation to meet final design deliverable standards. Typically, design disciplines report metric calculations differently, emphasizing family and type codes rather than only materials or areas. To align with these requirements, we prepare to format data into Excel tables, including codes, descriptions, units, quantities, and potentially cost metrics.
Key topics covered:
Creating schedules for parts in Revit
Grouping metric computations by material
Calculating areas and volumes for parts
Configuring schedule display options
Understanding the need for adapted data presentation formats
Introduction to coding and classification methods for metric data
Preparing data for export and further formatting in Excel
Practical value for BIM quantity take-offs:
Enables precise and detailed quantity extraction from subdivided model parts
Improves accuracy in metric computations by material and volume
Prepares metric data for professional presentation aligned with design discipline formats
Facilitates integration of cost and classification codes in quantity schedules
By mastering parts computation and schedule customization, learners will be able to produce detailed, accurate quantity take-offs in Revit and prepare data appropriately for integration into project documentation and cost estimation workflows.
In this lecture, we explore how to customize and format metric calculation schedules within Revit to enhance the clarity and usefulness of quantity take-offs. Unlike the default parameters that Revit provides, such as keynote and description, these parameters do not apply universally across all elements, particularly parts. To overcome this limitation, we focus on creating custom project parameters including code, description, unit, and unit price, which can be applied consistently across multiple elements.
The process begins by introducing how to add project parameters from the Manage tab in Revit, emphasizing the choice between type and instance parameters. Instance parameters are preferable when individual editing is required from the properties palette, offering greater flexibility. Each custom parameter is carefully assigned to the construction discipline and associated with all relevant categories, ensuring comprehensive application throughout the model.
Next, we integrate these custom parameters into the schedule view. This includes adding the new fields for code, description, unit, and unit price. Special attention is placed on formatting headers and customizing labels to mirror standard metric calculation schedules, such as renaming the area field to 'quantity' for greater professional alignment.
A critical aspect covered is the creation of calculated parameters to derive meaningful values such as total cost. We multiply area by unit price to generate this value, but encounter unit inconsistencies due to dimensional mismatches. This challenge is addressed by applying appropriate unit conversions within the formula, demonstrating a nuanced understanding necessary for precise BIM quantity calculations.
The lecture also covers sorting and grouping schedule data by the custom 'code' parameter, instead of by family or type, to better organize and summarize information for cost estimation purposes. Formatting options such as decimal precision in numeric fields are adjusted to improve readability and accuracy.
Finally, the lecture highlights best practices such as creating reusable Revit templates containing these customized schedules and parameters. This streamlines future projects by automating metric calculation formatting and ensuring consistent data output, which can then be exported efficiently. While the initial setup may be intricate, it significantly reduces manual effort and errors in subsequent quantity take-offs and cost analyses.
Key topics covered in this lecture:
Creating and managing custom project parameters in Revit.
Differentiating between instance and type parameters and their application.
Inserting custom parameters into schedules and formatting headers.
Developing calculated parameters to perform unit-consistent cost computations.
Sorting and grouping schedule data by custom codes.
Formatting numeric fields for display precision.
Strategies for creating reusable Revit templates for metric calculations.
Understanding and resolving unit inconsistencies in formula fields.
Practical value in BIM quantity estimation and cost calculation:
Enable precise classification and description of building elements for quantity take-off.
Facilitate accurate cost estimation through calculated total price fields.
Improve data organization by grouping elements by custom codes rather than family or type.
Enhance schedule readability by customizing parameter labels and numeric formats.
Automate metric calculations and formatting to save time and reduce errors.
Create standardized Revit templates to ensure consistency across multiple projects.
Establish workflows that bridge BIM modeling with cost management processes.
By the end of this lecture, learners will have a comprehensive understanding of how to create custom parameters and utilize them within Revit schedules to produce well-structured, automated metric calculations. They will be equipped to enhance BIM quantity take-offs with customized data fields and calculated totals, ensuring more reliable quantity and cost data that support downstream project workflows.
This lecture focuses on exporting schedules created in Revit, which contain detailed information such as code description, unit quantity, unit price, and total cost. It explains how to prepare schedules for export and discusses the importance of formatting them for use in external editing or estimation software.
You will learn how to use Revit's built-in export functionality to save schedules as text files, which can then be imported and edited in Excel or similar programs. This workflow enables more flexible and efficient handling of BIM quantity data outside of Revit.
The lecture includes a step-by-step demonstration of exporting a parts schedule, choosing the appropriate delimiters for fields, and importing the file into Excel for enhanced table editing and formatting.
Key topics covered in this lecture:
Exporting schedules from Revit using the Export > Reports feature
Saving schedules as text files with comma-separated values
Selecting export options including columns and title presence
Importing exported schedules into Excel via the Data tab
Using delimiters to correctly parse data fields in external programs
Editing and formatting schedules efficiently in Excel
Applying the export-import process to various schedule types
Practical value for BIM quantity take-off and estimation:
Enables integration of BIM data with external cost estimation tools
Facilitates advanced data manipulation and presentation in Excel
Improves workflow efficiency by automating quantity export
Supports accurate project cost calculation by linking Revit data with pricing software
After completing this lesson, learners will understand how to export metric computation schedules from Revit to external file formats and use Excel to enhance data editing and cost estimation processes.
This lecture introduces Dynamo, a powerful visual programming tool integrated within Revit that enables automation across various workflows. You will learn how to access Dynamo, understand its visual programming environment, and explore its basic functions through practical examples.
Dynamo operates with visual nodes instead of traditional code, making programming accessible to users without prior coding experience. This visual approach allows for easy creation, modification, and management of algorithms by connecting nodes on a workspace canvas.
We will cover how to add and manipulate elements like numbers and operations using the Dynamo interface. You will also see how to execute programs manually or automatically, and how this tool facilitates repetitive or complex tasks in Revit such as metric computations and data exports.
Key topics covered in this lecture:
Introduction to the Dynamo interface and how to launch it in Revit
Understanding visual programming with nodes and connectors
Creating basic numeric operations with sliders and add functions
Manual versus automatic execution of Dynamo scripts
Connecting Dynamo workflows to Revit elements by category
Using Dynamo to manage metric computations and data export
Basic navigation and sample scripts from Dynamo's homepage
Practical benefits of using Dynamo in BIM workflows:
Automate repetitive tasks within Revit to save time and reduce errors
Create custom scripts for metric calculations and quantity takeoffs
Directly connect and manipulate Revit elements for enhanced control
Export data efficiently to formats like CSV or Excel for further analysis
By the end of this lecture, you will understand the fundamentals of Dynamo’s visual programming system and be able to start creating simple scripts that automate metric computations and data handling in Revit, opening up new possibilities to streamline BIM workflows.
In this lecture, we explore the practical application of Dynamo to automate the export of Revit schedules, focusing on streamlining a traditionally tedious and repetitive task. While Revit offers basic schedule export functionality through its file export options, handling a large number of schedules individually can be time-consuming, especially when schedule data is regularly updated. Dynamo provides an effective solution by enabling batch export processes, significantly optimizing workflows in BIM quantity take-off tasks.
The session begins by opening Dynamo to create a new script that targets schedules within the Revit model. The method involves selecting specific element types—in this case, "View Schedule" elements—which correspond to the planning tables or schedule views that contain relevant quantity data. We filter the schedules by identifying a naming convention prefix "CM" (for metric calculations), ensuring only intended schedules are processed. This selective filtering is accomplished through string operations and Boolean logic nodes, which check for the prefix and generate corresponding masks to isolate relevant elements.
Next, the lecture details building a dynamic export path for the schedules. The instructor demonstrates constructing directory paths where each schedule CSV file will be saved, merging folder directory paths with filtered schedule names and the ".csv" file extension using a code block script. This approach guarantees each exported file is uniquely named and saved in the correct location, facilitating organized output management.
The export configuration is then fine-tuned with Dynamo's built-in export nodes. Various parameters are set, such as column delimiters (changing from default tabs to commas), header inclusion, and text qualifiers (enclosing text with double quotes), reflecting common CSV formatting standards compatible with software like Excel. Export options for headers and titles are enabled or disabled according to practical needs, with Boolean nodes simplifying parameter toggling.
Throughout the lecture, practical tips are shared, including how to re-run the script to overwrite previous exports and keep data updated effortlessly. The automation dramatically reduces manual effort, enabling mass export of filtered schedules with just a few clicks, compared to the manual repetition of export tasks for each schedule.
This all culminates as the exported CSV files are validated by opening them in Excel, demonstrating identical data content to manual exports but achieved through automation. The tutorial closes by setting the stage for future workflows that consolidate multiple schedules into a single Excel workbook with aggregated quantities—an advanced step toward comprehensive BIM 5D quantity analysis.
Key topics covered in this lecture:
Automating the export of schedules using Dynamo scripts
Selecting and filtering schedules by element type and naming prefixes
Creating dynamic file paths for batch exports
Configuring CSV export options including delimiters, headers, and text qualifiers
Boolean masks to filter lists based on string content
Streamlining repetitive BIM data export with visual programming
Validating exported files in Excel
Best practices for organizing and updating schedule exports automatically
Practical value for BIM quantity extraction workflows:
Significantly reduces time and errors compared with manual schedule export
Enables batch processing of multiple schedules with customizable naming conventions
Facilitates organized storage of export files for easy access and review
Supports efficient project updates by simplifying repeated export needs
Leverages Dynamo visual scripting without advanced programming knowledge
Improves BIM dimensions integration by automating repetitive computational tasks
Prepares data for downstream cost estimation or quantity takeoff analysis
By completing this lecture, learners will be able to use Dynamo to automate the export of multiple Revit schedule tables efficiently. They will master filtering schedules by name prefixes, constructing export paths programmatically, and configuring CSV export settings to produce clean, structured data outputs. This knowledge empowers them to streamline BIM metric computations, save significant time on routine tasks, and lay the groundwork for more advanced data manipulation and quantity consolidation in subsequent lessons.
In this lecture, we focus on the practical process of exporting BIM quantity data from Dynamo directly into Microsoft Excel. Building upon the previous session where text file exportation was demonstrated, this lesson shifts gear by showing how to effectively manage and automate Excel exports within the Dynamo environment.
The lesson begins with an exploration of Dynamo’s built-in nodes related to Excel exports, highlighting their limitations when dealing with Revit scheduled views. We observe that default exports handle tables as a whole but do not expose the column and row data directly, which restricts further manipulation and filtering at the data granularity level.
A key technical insight shared in this class involves enriching Dynamo’s capabilities by installing specialized packages, specifically the Bimorph Nodes package. This package extends the native functionality, enabling users to extract and export table contents as proper rows and columns in Excel. The learning curves through the installation process and introduces important nodes such as GetData, which extracts scheduled views and their corresponding data sets for subsequent processing.
The instructor emphasizes workflow best practices essential for successful execution, including setting Dynamo to manual run mode to avoid errors caused by continuous extraction attempts. By toggling options such as removing headings, learners understand how to control which parts of the data are exported, tailoring outputs to their reporting needs.
After acquiring the data in list formats, the lesson proceeds with the creation of an Excel file to serve as the export destination, reinforcing the necessity that the file and folder exist beforehand to prevent errors. The session illustrates mapping between the Dynamo data structures and the Excel file, detailing how to specify file paths, define sheet tab names, and establish starting points for rows and columns during export.
A significant portion of the lesson is dedicated to advanced data manipulation techniques within Dynamo, such as flattening nested lists to consolidate multiple tables into a single flat list, and the merging of headers with corresponding data rows. Through the use of nodes like GetItemAtIndex and AddItem, the session demonstrates how to assemble comprehensive tables that aggregate metric computations across various scheduled views into one summary Excel sheet.
Finally, we see the culmination of these steps in a full export operation where four Excel sheets are generated—three from original tables and one summary sheet that combines all data. This summary sheet facilitates a holistic view of cost estimates and metric calculations made within Revit, showcased as a streamlined, fully automated output that greatly accelerates project quantity take-off and budgeting tasks.
Key topics covered in this lecture:
Exploring Dynamo’s default Excel export nodes and their limitations
Installing and utilizing the Bimorph Nodes package to export data as rows and columns
Setting Dynamo to manual run mode to manage data extraction
Techniques for removing headers and managing boolean switches in data export
Creating and using Microsoft Excel files and sheet tabs as export targets
Data structuring in Dynamo—flattening nested lists and merging headers with data
Adding new tables and sheet names dynamically in Excel exports
Automating the export of summarized quantity take-off data across multiple sheets
Workflow best practices for reusable Dynamo scripts in BIM quantity computations
Practical value in the BIM metric computation domain:
Automates export of detailed quantity data from Revit schedules to Excel sheets
Enables creation of comprehensive summary sheets combining multiple data tables
Supports reusable workflows for repeated project quantity take-offs using Dynamo
Reduces manual effort and errors in transferring BIM quantities to external reporting tools
Facilitates cost estimation by connecting Revit calculations with Excel summarization
Enhances data handling by using specialized Dynamo packages for richer exports
Promotes practical understanding of list manipulation and data structuring in Dynamo
Upon completing this lecture, learners will be able to craft and customize Dynamo scripts that efficiently export and summarize BIM quantity data into Excel workbooks. They will understand how to extend Dynamo’s native capabilities with community packages, properly configure data extraction nodes, and assemble the exported information into clear, usable Excel tables that support rapid cost estimation and metric analysis workflows in BIM projects.
This lecture concludes our exploration of using Dynamo for metric quantity extraction by demonstrating how to operate Dynamo Player. Dynamo Player is a streamlined interface integrated within Revit that enables running Dynamo scripts without opening the full Dynamo environment.
We start by accessing Dynamo Player from the Manage tab in the Visual Programming section, where you can select the folder containing your saved Dynamo scripts. Running a script is as simple as selecting it and clicking the Run button, which automatically executes the script and generates the calculated summaries.
Additionally, Dynamo Player allows you to manage and edit script inputs directly through its interface. This means you can designate specific nodes as inputs in your Dynamo scripts, enabling you to modify parameters like file paths before execution, without needing to open Dynamo itself. This feature enhances automation and flexibility when working with multiple Dynamo workflows within BIM projects.
Key topics covered in this lecture:
Accessing and navigating Dynamo Player within Revit
Selecting script folders and refreshing Dynamo scripts
Running Dynamo scripts directly from Dynamo Player
Creating and editing input nodes for scripts
Automating script execution without opening Dynamo
Managing file paths and inputs for export tables
Enhancing workflow automation across multiple Dynamo files
Practical value in BIM quantity extraction workflows:
Speeding up quantity data extraction by bypassing Dynamo's full environment
Improving automation of repetitive BIM calculation tasks
Allowing quick modification of script parameters via input nodes
Centralizing Dynamo script management through folder selection
Supporting efficient project workflows by running multiple scripts easily
By the end of this lesson, learners will confidently use Dynamo Player to execute and manage Dynamo scripts efficiently, improving their BIM quantity extraction automation processes without requiring direct interaction with the full Dynamo interface.
This lecture focuses on the essential final steps to integrate Revit metric calculations with external cost estimation software, highlighting best practices that facilitate seamless workflows between these tools. The instructor emphasizes the importance of preparing comprehensive and well-organized schedules in Revit, tailored for different disciplines and elements, ensuring accurate quantity takeoffs.
Starting with the construction of dedicated Revit schedules for materials and elements such as columns, slabs, walls, and structural components, the lesson explains how to add key information like unit weights and descriptive labels. These details are crucial not only for Revit computations but also for exporting data efficiently to other applications.
The use of filters by disciplines, such as architecture, structural engineering, and systems (MEP), is recommended to segment calculations logically. This approach allows teams to focus on their relevant components—for example, slabs and finishes in architecture, foundations and trusses in structure, or piping in systems. The creation of separate Revit template files by discipline helps streamline this process by preconfiguring schedules and views for ongoing projects.
Subdividing the model elements into parts with associated codes, descriptions, units, and prices is underlined as a vital practice. These parts facilitate downstream automation and clear organization of the cost estimation workflow.
The lecture then demonstrates how Dynamo serves as an automation bridge by exporting Revit schedules directly to Excel. This saved effort reduces manual data handling, speeding up the preparation of cost data for external software.
Next, the lesson introduces iP3 site control as an example of an external program used to create detailed cost estimates. Using iP3, users import the exported schedule data, map Revit codes to the software’s database items, and build a comprehensive budget. The interface allows selection among multiple item definitions with the same code, ensuring that specifications, such as type of concrete, are accurately represented.
The cost estimate in iP3 is automatically calculated, inclusive of labor, equipment, and material breakdowns, based on up-to-date pricing in the software’s database. Additionally, the program applies region-specific factors like FCAs (Construction Finished Area) to reflect local conditions accurately.
The integration showcased reduces what could be an extensive manual budgeting process to a few simple copy-and-paste actions, leveraging earlier efforts in Dynamo and Revit and greatly enhancing efficiency and accuracy in project cost estimation.
Key topics covered in this lecture:
Best practices for creating detailed Revit schedules for metric computations
Segmentation of metric calculations by discipline with use of filters
Creation and use of Revit template files with preconfigured schedules and views
Subdivision of model elements into parts with associated codes and pricing information
Automated export of quantity schedules from Revit to Excel using Dynamo
Introduction to cost estimation with iP3 site control software
Mapping Revit schedule codes to iP3 cost database items
Generation of detailed budgets including labor, materials, equipment, and regional cost factors
Integration workflow efficiencies through Dynamo and external software connection
Practical value in the BIM quantity take-off and cost estimation domain:
Enabling precise and structured quantity take-offs within Revit tailored to multiple disciplines
Saving significant time by automating schedule exports and cost data preparation
Facilitating accurate cost estimate generation using up-to-date regional cost databases
Reducing errors and rework by linking BIM quantities directly to estimating software
Supporting better project planning and budgeting through integrated BIM and cost workflows
Providing a logical method to subdivide and code building components for clear estimation
Offering a scalable template-based approach to streamline quantity take-offs across projects
By completing this lecture, learners will understand how to effectively bridge Revit quantity take-offs with external cost estimation tools through best data preparation and automation practices. They will be able to organize and export schedules in Revit by discipline, use Dynamo to automate data extraction, and create reliable budgets in cost estimation software such as iP3, boosting project efficiency and accuracy in BIM 5D workflows.
This lecture introduces Navisworks, a versatile software widely used in BIM projects to coordinate multiple files and perform various analyses. Navisworks is particularly valuable for integrating models from different sources into a single project environment.
We focus on understanding Navisworks' core functionalities relevant to metric computations, including collision detection, construction timeline analyses, and especially quantity takeoffs.
Additionally, you will learn about the wide variety of file types that Navisworks can handle, making it a powerful tool for managing complex BIM workflows.
Key topics covered in this lecture:
Overview of Navisworks capabilities in BIM coordination
Collision detection and timeliner functions
Focus on quantity takeoff and metric calculations
Supported file formats including Revit, AutoDesk, 3D Studio, SketchUp, and more
Best practices for importing Revit data using the NWC cached file format
Practical value for BIM professionals:
Learn how to efficiently merge diverse building models into a single project environment
Understand key analysis tools to detect design clashes and schedule construction activities
Discover the optimal workflow for importing Revit models to speed up quantity extraction
Gain insight into the wide compatibility Navisworks offers with various architectural and design software
By the end of this lesson, you will understand why Navisworks is essential for BIM project coordination and how to prepare your files properly for streamlined metric computations and quantity takeoffs.
In this lecture, you will learn how to correctly configure a Revit file to enable proper export to the Navisworks environment, which is essential for 5D quantity take-off workflows. The process begins by creating a new 3D view within Revit that includes all elements and categories you intend to export and quantify in Navisworks. This view is then duplicated and renamed for easy identification, typically as "navisworks."
It is critical to verify that all the relevant element categories in this 3D view are visible before export. This is controlled through the Visibility Graphics settings in Revit, ensuring that every item you want Navisworks to acknowledge is turned on. Additionally, an important step is to ensure that parts are visible and properly subdivided — not just showing original elements by category, but their subdivided parts with identifiable codes.
The lecture emphasizes creating parts in Revit by selecting elements and using the "Create Part" function, which subdivides larger elements into manageable parts. However, a challenge arises because parts initially lack essential data such as sign codes, descriptions, units, and unit prices, which are necessary for accurate quantity take-off in Navisworks. Manually assigning these parameters can be tedious.
This is where automation via Dynamo, a visual programming tool within Revit, becomes highly valuable. The instructor shares a pre-built Dynamo script available for download that automatically transfers key parameters — including description codes, units, and unit prices — from original materials to their corresponding parts. This significantly streamlines the preparation process by reducing manual data entry and potential human errors, though some zero-value warnings may appear if parameters are blank.
Once the Revit file is properly configured, with parts created and parameter data assigned, you proceed to export to Navisworks through the "Navisworks" external tool available under the Add-Ins tab in Revit. Before exporting, you must adjust specific settings in Navisworks Export options. These include enabling "Convert construction parts" to include the created parts in the export and "Convert element properties" to ensure that all relevant parameters and properties transfer correctly from Revit to Navisworks.
The export generates an NWC cache file, which optimizes the loading and performance of the model inside Navisworks. The lecture clarifies the distinction between the NWC file — used for importing and caching data — and the NWD file, which is the native Navisworks model document; the latter must be saved within Navisworks to avoid compatibility issues later. After exporting the NWC file, you learn how to load it into Navisworks using the Append tool, observing how all elements and their assigned material data appear promptly and can be inspected through quick properties.
This foundational process ensures that your BIM model in Navisworks accurately reflects the detailed components and their associated metadata, setting you up to efficiently extract metric computations and quantities in subsequent lessons.
Key topics covered in this lecture:
Configuring a Revit 3D view for export compatibility with Navisworks
Managing visibility of categories and parts in the export view
Creating parts in Revit for granular element subdivision
Assigning codes, descriptions, units, and prices to parts
Using Dynamo scripts to automate parameter transfer
Adjusting Navisworks export settings in Revit for parts and properties
Exporting to NWC cache files for Navisworks
Loading NWC files into Navisworks using the Append tool
Distinguishing between NWC cache files and NWD Navisworks documents
Practical value in BIM quantity take-off and metric computations:
Enables efficient export of detailed BIM components to Navisworks for quantity analysis
Improves data consistency by automating parameter population via Dynamo
Prepares models for accurate 5D cost estimations and metric extractions
Facilitates integration between Revit and Navisworks through proper export settings
Helps users avoid common export pitfalls, such as missing parts or incomplete properties
Optimizes Navisworks project performance by using NWC cache files
Provides understanding of file management within Navisworks environment
By the end of this lecture, you will be proficient in preparing and exporting Revit BIM models with detailed element parts and metadata ready for metric computations in Navisworks, laying the groundwork for advanced quantity take-off and cost analysis tasks.
In this lecture, you will learn how to configure metric computation settings within the Navisworks environment, a key step in setting up quantity take-offs for BIM projects. The process begins by saving your project file in the NWD format to embed all references in a single file, making it easier to manage and quantify.
Once the file is saved, you will open the Quantification tool from the Home tab in Navisworks, which also opens important catalogs such as the Item Catalog and Resource Catalog. The main task in this session is configuring the quantification workbook by setting up project parameters, choosing appropriate catalogs, and defining units suited for your project, like metric units.
This setup creates a Work Breakdown Structure (WBS), organizing your quantification tasks into logical components such as foundations, enclosures, roofing, stairs, and interior finishes, providing a clear framework to associate and quantify elements.
Key topics covered in this lecture:
Saving files in NWD format to embed all references
Using Navisworks' Quantification tool and related catalogs
Setting up the quantification workbook with project setups
Selecting standard or customized catalogs like Uniformat or CSI
Defining units for measurement (metric system)
Understanding and using the Work Breakdown Structure (WBS)
Requirements for quantification setup and file readiness
Practical value for BIM metric computations:
Enables precise configuration of quantity take-off parameters
Facilitates organization of quantification tasks via structured catalogs
Supports unit standardization for accurate project metrics
Prepares the project file for efficient quantity estimation workflows
By the end of this lecture, you will be able to save and configure your Navisworks file properly to begin quantifying BIM elements effectively, using industry-standard catalogs and measurement units organized within a clear work breakdown structure.
In this lecture, you will learn how to create and manage item catalogs within Navisworks, focusing on building a detailed custom work structure essential for precise BIM metric computations. The session begins with setting up a new project from scratch, ensuring that no predefined catalogs are used. This approach provides full control over the creation of your quantification structure for accurate tracking and estimation.
We explore the dual nature of the catalog by differentiating between items (work activities) and resources (materials or inputs required to perform these activities). You will understand the workflow for creating groups and individual items, such as a concrete slab foundation, specifying appropriate primary units for measurement such as volume in cubic meters, which aligns with the metric system. This step is crucial for ensuring that quantities are computed correctly within the model.
The lecture further demonstrates how to populate the detailed work structure with actual elements in the model, linking activities to physical components. This connection enables the automatic quantification of metrics like thickness, area, and volume tied directly to your model components, facilitating efficient and accurate project estimations.
Advancing to resource management, the class elaborates on grouping resources by categories such as "reinforced concrete" and adding essential materials such as sand, gravel, and cement bags. You will learn how to attach these resources to the corresponding activities within the catalog, thus enabling resource-driven quantity takeoffs that complement the element-based quantification.
In addition, you will discover techniques for assigning formulas to resources, enabling dynamic calculation of resource needs based on the primary quantity of the associated activity. For example, sand quantity is calculated as 40% of the concrete volume, gravel follows a similar proportion, and cement bags are calculated using a multiplication factor. This methodology empowers you to produce detailed material lists directly from the project model, improving accuracy and reducing manual errors.
The lecture concludes by revisiting the quantification workbook, where the results of the configured work structure and resources are displayed hierarchically. This enables you to see sub-level quantities and total amounts of each material required per activity, yielding a comprehensive overview of project metrics and material demands.
Through this module, you gain the skills to build, organize, and link catalogs of items and resources in Navisworks, complete with calculation formulas that connect physical model geometry to real-world material needs. This empowers more precise planning and execution of BIM projects.
Key topics covered:
Creating new projects and work structures from scratch
Distinction between item catalogs (work activities) and resource catalogs (materials)
Adding groups and items to the catalog
Assigning primary units and calculation formulas for quantity takeoffs
Linking model elements to catalog items for automatic quantification
Building resource groups and adding materials like sand, gravel, and cement
Associating resources to activities with resource usage formulas
Reviewing quantification results in the workbook with hierarchical structure
Practical value in BIM metric computations:
Enables creation of customized work structures tailored to project needs
Supports precise measurement of volumes, areas, and quantities from BIM models
Allows material resource planning based on activity-driven demands
Reduces errors through automated calculations and formula-based resource quantification
Facilitates informed decision-making for construction phases and procurement
Streamlines quantity takeoff workflow integrating both items and resources
Improves accuracy and completeness of BIM-based cost estimation inputs
By the end of this lecture, you will be able to confidently create and manage catalogs of work activities and resources within Navisworks, assign measurement units and calculation formulas, link model elements for quantification, and interpret detailed metric outputs that support BIM 5D quantity takeoff processes.
This lecture explores the concept of virtual computations within Navisworks, offering an alternative method for metric calculations that supplements direct model-based quantity takeoffs. While traditional takeoffs use elements already modeled—such as walls, windows, and structural components—virtual takeoffs address items that have yet to be modeled or included in the BIM. This approach facilitates the inclusion of essential, yet missing, quantities as part of the detailed work structure, ensuring comprehensive quantification even when some project elements are not physically present in the model.
Using the quantification workbook in Navisworks, the instructor explains how virtual takeoff allows users to estimate quantities based on project needs. This method involves creating new catalog items manually, representing features like additional construction elements or modifications that improve project performance. For example, a concrete flange designed to divert water away from foundations can be added virtually, despite its absence from the original model.
The workflow focuses on the practical steps for creating and managing these virtual items. The tutorial covers how to assign meaningful names, attach representative images, and set key measurements such as length, width, and especially volume. Emphasis is placed on using volume as a primary quantity when dealing with concrete pours or similar volume-dependent materials. By estimating quantities like 10 cubic meters of concrete, learners can integrate virtual elements seamlessly into their overall quantity takeoff processes.
Moreover, the lecture demonstrates the synchronization between the virtual takeoff items and the quantification workbook in Navisworks. This linkage ensures that virtual amounts are calculated and displayed accurately alongside modeled quantities, providing a clear and complete overview of project metrics. Importantly, this strategy does not delay quantification workflows but rather allows for ongoing precision and adaptability even in the face of incomplete modeling data.
The integration of virtual computations serves as a vital bridge between the modeled project and real conditions or project adjustments, ensuring that no significant construction elements are overlooked. This capability encourages proactive project management by enabling teams to flag missing items for revision and subsequent inclusion in the BIM model, thereby improving accuracy and collaboration.
Throughout the lecture, learners gain insight into how Navisworks supports flexible, comprehensive metric estimations that complement model-based quantities. The focus on creating, customizing, and quantifying virtual takeoff items equips students with practical tools and workflow strategies to enhance their BIM quantity extraction processes.
Key topics covered:
Introduction to virtual takeoff as an alternative metric calculation method
Differences between model-based and virtual quantity takeoffs
Creating and naming new catalog items for virtual quantities
Assigning representative images to virtual catalog items
Manual input of measurements such as length, width, and volume
Using volume as the primary quantity for materials like concrete
Updating and syncing virtual quantities in the Navisworks quantification workbook
Practical example of adding a concrete flange for water diversion
Workflow benefits: maintaining accuracy when elements are missing in the model
Practical value in BIM metric computations:
Enables inclusion of unmodeled but necessary quantities in project metrics
Improves accuracy and completeness of quantity takeoffs
Facilitates proactive revision and model updating processes
Supports flexible, adaptable workflows for evolving project conditions
Allows estimation of custom elements crucial for project success
Reduces delays in quantification despite incomplete models
Integrates smoothly with Navisworks quantification tools and catalogs
By completing this lecture, learners will understand how to perform virtual computations in Navisworks to capture quantities not represented in their BIM models. They will be able to create and manage virtual catalog items, estimate relevant quantities manually, and incorporate these into their overall quantity takeoff workflows. This knowledge will ensure more accurate and comprehensive metric extraction and will empower users to handle the complexities of real-world BIM projects effectively.
This lecture focuses on optimizing workflow within Navisworks, a key tool for BIM metric computations. Efficient workflow is crucial when handling complex models, and Navisworks offers various features to streamline selections and automate repetitive tasks. The instructor demonstrates practical techniques such as advanced selection tools, saving selection sets, and managing catalogs to avoid redundant work across projects.
We begin by exploring the selection tools, which allow users to quickly select elements based on shared characteristics like type, material, or base level. For example, selecting all walls of a specific type or all elements sharing the same material can be performed effortlessly using the "select same" function. The selection tree further refines this process by enabling selective filtering by levels and categories, which is invaluable in large models where precision is essential.
The lecture also introduces how to filter elements using properties, such as searching for all components with a material named "glass." Better yet, using the "find items" feature allows filtering based on various parameters, including custom codes created in Revit. This integration between Revit and Navisworks highlights the importance of well-structured BIM data, enabling seamless cross-software workflows.
To further optimize, selections can be saved as sets or searches within Navisworks. The difference is significant: while sets save the current selection (the exact elements), saved searches store the search criteria, which allows dynamic updating when the model changes. Naming and organizing these searches enables users to efficiently manage complex quantification tasks.
Additionally, exporting and importing these custom search sets and catalogs as XML files allow for reuse across different Navisworks projects. This capability means that once work is structured correctly, it can be quickly repeated or adapted to new models, enhancing productivity.
Finally, the instructor demonstrates how to assign these saved selections to the Quantification Workbook, automating the takeoff process by linking elements with their respective codes and categories. This method significantly reduces manual input and minimizes errors, making metric computations more accurate and efficient.
Key Topics Covered:
Using selection tools to select elements by type, material, and base level
Employing the selection tree for precise category and level filtering
Filtering elements by properties and custom codes using Find Items
Saving selections as sets versus saved searches for dynamic updating
Exporting and importing search sets and custom catalogs for reuse
Integrating Navisworks selections with Quantification Workbook for automatic takeoff
Practical workflow tips to minimize repetition and automate tasks
Cross-software parameter use between Revit and Navisworks
Practical Value in BIM Metric Computations:
Enhances selection efficiency and accuracy within large BIM models
Reduces repetitive work by reusing saved selection sets and search parameters
Enables consistent application of Revit-created parameters inside Navisworks
Facilitates faster and more reliable takeoffs with automated assignment to Quantification Workbook
Provides the ability to export/import resources to streamline new projects
Improves project documentation and traceability through structured workflows
Supports dynamic updates ensuring selections reflect latest model changes
Upon completing this lecture, learners will understand how to leverage Navisworks' advanced selection and management tools to optimize their metric computation workflows. They will be able to create reusable, parameter-driven selection sets and catalogs that integrate efficiently with quantification processes, significantly improving their productivity and accuracy in BIM quantity takeoff projects.
This lecture concludes the exploration of Navisworks by demonstrating how to export the quantities obtained from the assigned materials and elements within the quantification workbook.
The export process focuses on creating a detailed Excel report, which includes all selected items or the entire dataset, depending on user choice. This report provides a comprehensive view of quantified data organized by groups such as structure and superstructure.
After exporting, you will see detailed tables and pivot tables showing objects, raw resources used, item categorizations, and quantity measures such as area, volume, length, and perimeter.
Key topics covered in this lecture:
Exporting quantity data from Navisworks to Excel
Understanding the structure of exported quantification reports
Usage of selection sets and item/resource catalogs
Detailed data presentation including groups, objects, and pivot tables
Automation potential for quantity extraction workflows
Saving and managing selection sets for consistent workflows
Connecting Navisworks export with Revit model parameters
Practical value in BIM metric computations:
Enables sharing of detailed quantity reports in Excel format
Facilitates customization of selection sets tailored to project or regional needs
Supports automation of metric extraction from BIM models
Enhances clarity and accuracy in quantity take-offs for BIM practitioners
By the end of this lecture, you will be able to confidently export comprehensive quantity reports from Navisworks, organize your data for better analysis, and prepare your workflows for efficient metric extraction aligned with your Revit model data.
This final lecture concludes the BIM metric calculation course, emphasizing the comprehensive integration of various software tools and stages involved in quantity take-offs.
Quantification in BIM is not limited to a single software but rather encompasses multiple applications across different project phases, from early estimations and documentation to maintenance stages.
With the knowledge gained in this course, learners can confidently apply metric calculations at any project stage and level of detail, utilizing features in Revit, Dynamo, and Navisworks.
Key topics covered:
Applying schedules and material take-offs within Revit with detailed customization
Use of custom codes and automated parameter calculations in Revit schedules
Automation of quantity extraction using Dynamo and exporting data to Excel
Utilizing the Dynamo Player for streamlined process automation
Exploring Navisworks for effective quantity extraction and working set creation
Creating detailed work structures and custom resources in Navisworks
Integrating multi-software workflows for comprehensive BIM quantification
Practical value for BIM quantity calculation:
Ability to perform detailed and automated quantity take-offs at any project phase
Enhanced efficiency through automation of repetitive tasks using Dynamo
Development of custom workflows and resources adapted to company needs
Confidence in using integrated BIM software to improve project metric computations
By completing this course, learners will understand how to seamlessly extract and automate metric quantities across BIM platforms, enabling more accurate estimations and improved project workflows that support diverse construction and maintenance scenarios.
This course offers an in-depth exploration of metric calculations within Building Information Modeling (BIM), focusing on extracting quantities directly from models using industry-leading software tools such as Revit, Navisworks, and Dynamo. It is designed to provide learners with practical skills to accurately quantify building elements and automate complex workflows to improve project efficiency.
Throughout this workshop, you will engage with real-world BIM workflows where metric computations support crucial activities across all project phases — from conceptual design to detailed construction documentation and beyond. These calculations impact cost estimation, scheduling, and resource planning, making them essential for BIM professionals.
Using Revit, you will learn to create, customize, and export planning and material tables, improving your ability to manage quantities with precision. The course then introduces Dynamo, a visual programming tool integrated with Revit, enabling you to automate repetitive data extraction and manipulation tasks without prior coding experience.
Additionally, the course covers Navisworks to demonstrate how to import models, set up metric computations, manage catalogs, and efficiently export quantity reports. This software integration approach reflects industry best practices for collaborative and coordinated BIM workflows.
The learning approach combines detailed software instruction with practical examples, allowing you to apply the techniques to your own projects confidently. The course content was developed by AulaGEO experts and professionally voiced to enhance accessibility for English-speaking students.
Learning Objectives
By the end of this course, you will be able to:
Extract accurate metric computations from BIM models across different project stages.
Create and customize Revit schedule views to generate detailed quantity tables.
Automate quantity extraction workflows using Dynamo’s visual programming environment.
Export data efficiently from Revit and Dynamo for further analysis and reporting.
Set up and manage quantity take-offs using Navisworks for integrated BIM project coordination.
Develop workflows that link Revit, Dynamo, and Navisworks for streamlined metric calculations.
Utilize coding and descriptive parameters to enhance quantity schedules and classification.
Optimize BIM workflows to reduce errors and improve collaboration between disciplines.
Who Should Take This Course
Architects seeking to improve their BIM quantity take-off skills.
Civil engineers involved in construction estimation and planning.
BIM coordinators and managers aiming to automate data extraction processes.
Design and execution technicians who work with quantity computations.
Construction professionals looking to integrate multiple BIM tools for accurate metrics.
Students and practitioners wanting hands-on experience in Revit, Dynamo, and Navisworks workflows.
Course Structure
Section 1: Introduction
Welcome learners and introduce BIM metric calculation workflows using Revit, Navisworks, and Dynamo.
Section 2: Revit Metric Computations
Teach how to create, customize, and export metric calculation schedules using Revit to accurately quantify building elements.
Section 3: Dynamo for Metric Computations
Demonstrate automation of Revit quantity export and data handling workflows using Dynamo and Dynamo Player.
Section 4: Navisworks for Metric Computations
Cover importing, setting up, computing, cataloging, and exporting quantities using Navisworks for BIM metric calculations.
Section 5: Conclusion
Summarize course content, reinforce BIM workflows integrating Revit, Dynamo, and Navisworks, and encourage skill application.
Why Take This Course
Mastering quantity take-offs in BIM is essential for accurate cost estimation, project scheduling, and resource management in architecture, engineering, and construction. This course equips you with crucial software skills and workflow knowledge to automate these processes, saving time and reducing errors.
Through integrated use of Revit, Dynamo, and Navisworks, you'll learn to streamline project workflows and improve collaboration across disciplines. Automating metric computations ensures consistent data quality, enabling better decision-making throughout the project lifecycle.
Whether you are working on conceptual designs or detailed documentation, these skills will enhance your professional toolkit and increase your value in multidisciplinary BIM teams.
Professional Context
This course provides a practical foundation for BIM professionals who need to accurately quantify building elements using coordinated software tools. It bridges the gap between design intent and construction documentation, offering automation techniques that improve project delivery efficiency.
Graduates of this course will be prepared to contribute to advanced BIM projects requiring integrated workflows between Revit, Dynamo, and Navisworks, supporting cost estimation, scheduling, and data management objectives essential to modern construction practice.