In this example, we demonstrate how to automate the extraction and updating of quantity takeoff data in Revit—tasks that are often time-consuming and prone to errors, especially in large-scale projects. Using BIMLOGIQ Copilot’s AI capabilities, we show how to export floor element data to Excel, modify cost values, and import the updated data back into Revit. This AI-powered process ensures accurate management of parameters like Element ID, Area, Volume, and Cost. We also illustrate how to compare the updated values in Revit’s schedule with the modified Excel file, ensuring consistency across your project. By leveraging AI with BIMLOGIQ Copilot, you can optimize your workflow, reduce manual errors, and increase efficiency in quantity takeoff management.
Prompts
Prompt 1: Find all floor elements in the current project and export their data to an Excel file named "takeoff.xlsx", saved on the desktop. The Excel file should have the following columns: First column: Element ID, Second column: Area (m²), Third column: Volume (m³), Fourth column: Cost parameter. Ensure that all parameter values are displayed in their respective units.
Prompt 2: Update values of Cost parameters from excel file = "takeoff.xlsx".If its Null or Read-Only, don't do anything.