Revit Schedules and Data Extraction 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?

Accepted Answer

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

Answer

Add a 'Cost' project parameter to doors, enter the value for each instance, then use a calculated value.

Answer

Export the schedule to Excel, add a cost column, perform the calculation there, and import it back into Revit.

Answer

Manually add a 'Cost' text parameter to each door type in the family editor and use the 'Grand Totals' feature.

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?

Accepted Answer

Sorting/Grouping

Answer

Fields

Answer

Filter

Answer

Formatting

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?

Accepted Answer

A Material Takeoff

Answer

A Wall Schedule

Answer

A Sheet List

Answer

A View List

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?

Accepted Answer

Filter

Answer

Appearance

Answer

Sorting/Grouping

Answer

Formatting

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?

Accepted Answer

Apparent Load / 1000

Answer

Apparent Load * 1000

Answer

kVA(Apparent Load)

Answer

Apparent Load / 1 VA

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?

Accepted Answer

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

Answer

Use the 'Print' command and select 'Print to CSV'.

Answer

In the Project Browser, right-click the schedule and choose 'Save to New File'.

Answer

Use the 'Copy to Clipboard' command and paste directly into the spreadsheet.