Schedules and Data Extraction Flashcards

A project manager needs a door schedule to show the total cost for each door type. The cost per door is known, but there is no 'Cost' parameter in the door families. Which of the following is the most efficient method to add cost data and calculate totals within the schedule?

Answer: Use a Key Schedule to define door styles and their associated costs, then add the key to the door schedule.

Key Schedules are specifically designed to manage and apply a set of common properties (like cost, material, or fire rating) to elements like doors without editing each family type. By creating a 'Door Style' key with a 'Cost' field, you can assign a style to each door, and the cost will populate automatically, which is far more efficient than entering the cost for every single door instance.

In the Schedule Properties dialog, which tab is used to combine multiple instances of the same element type into a single row and show the total count?

Answer: Sorting/Grouping

The 'Sorting/Grouping' tab allows you to organize the schedule. By sorting by a specific field (like 'Type Mark' or 'Family and Type') and unchecking the "Itemize every instance" option, Revit groups identical items onto one line and provides a 'Count' field.

Which of the following schedule types should be created to calculate the total surface area and volume of paint required for all walls of a specific type in a project?

Answer: A Material Takeoff

A standard Wall Schedule reports on the wall elements themselves (e.g., length, area, type). A Material Takeoff schedule, however, drills down into the layered materials that make up an element, allowing you to quantify specific materials like paint, brick, or concrete by area or volume.

You have created a comprehensive Room Schedule for a multi-story building, but for a specific sheet, you only want to display rooms from 'Level 2' that have an area greater than 150 square feet. Which tab in the Schedule Properties dialog is used to set these rules?

Answer: Filter

The 'Filter' tab is used to set rules that determine which elements appear in the schedule. You can create multiple rules, such as 'Level' equals 'Level 2' AND 'Area' is greater than '150 SF', to display only the elements that meet all specified criteria.

A designer is creating an electrical equipment schedule and has a parameter for 'Apparent Load' which is measured in volt-amperes (VA). They need to create a calculated field that displays this value in kilovolt-amperes (kVA). What is the correct formula to achieve this?

Answer: Apparent Load / 1000

Revit's formulas in calculated values are unit-aware. To convert from a smaller unit (VA) to a larger unit (kVA), you must divide by the conversion factor (1000). Simply typing `Apparent Load / 1000` will correctly perform the unit conversion. Dividing by `1 VA` would create a unitless number, which is incorrect.

A cost estimator needs the data from a Revit Wall Schedule to perform further analysis in a spreadsheet application. Which of the following is the standard procedure to export the schedule from Revit into a format easily readable by Microsoft Excel?

Answer: With the schedule view open, go to File > Export > Reports > Schedule.

The designated workflow for exporting schedule data is through the File menu. Navigating to File > Export > Reports > Schedule allows the user to save the schedule as a delimited text file (.txt or .csv), which is the standard format for importing into spreadsheet applications like Excel.