Revit Schedules and Data Extraction Questions and Answers — Questions and Answers
Question 1: 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?
- Add a 'Cost' project parameter to doors, enter the value for each instance, then use a calculated value.
- Use a Key Schedule to define door styles and their associated costs, then add the key to the door schedule. (Correct answer)
- Export the schedule to Excel, add a cost column, perform the calculation there, and import it back into Revit.
- Manually add a 'Cost' text parameter to each door type in the family editor and use the 'Grand Totals' feature.
Correct 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.
Question 2: 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?
- Fields
- Filter
- Sorting/Grouping (Correct answer)
- Formatting
Correct 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.
Question 3: 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?
- A Material Takeoff (Correct answer)
- A Wall Schedule
- A Sheet List
- A View List
Correct 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.
Question 4: 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?
- Appearance
- Filter (Correct answer)
- Sorting/Grouping
- Formatting
Correct 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.
Question 5: 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?
- Apparent Load * 1000
- Apparent Load / 1000 (Correct answer)
- kVA(Apparent Load)
- Apparent Load / 1 VA
Correct 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.
Question 6: 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?
- Use the 'Print' command and select 'Print to CSV'.
- In the Project Browser, right-click the schedule and choose 'Save to New File'.
- With the schedule view open, go to File > Export > Reports > Schedule. (Correct answer)
- Use the 'Copy to Clipboard' command and paste directly into the spreadsheet.
Correct 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.
Revit Schedules and Data Extraction Questions and Answers
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?