Create advanced schedules

Step-by-step guide

Create a schedule and use parameters to control its appearance.

1. Open the project M07_01.rvt.
2. Ensure that the current view is HVAC > Floor Plans > 1 – Mech.
3. On the ribbon, View tab, click the Schedules drop-down and select Schedule/Quantities.

4. Name the new schedule "Air Changes".
5. Click OK.
6. In the Schedule Properties dialog box, under Available fields, select the Name field.
7. Click the Add Parameter arrow to add it to the Scheduled fields list.
8. Repeat steps 6 and 7 to add the following fields:

• Number
• Volume
• Actual Supply Airflow
• Air Changes per hour

9. Click OK to review the schedule.

10. In Properties, next to the Fields parameter, click Edit.

11. In the Schedule Properties dialog box, click the Combine Parameters button.
12. Name the combined parameter "Space id".
13. From the list of Schedule Parameters, select Name.
14. Click Add Parameter to add it to the Combined parameters.
15. Repeat steps 13 and 14 to add the Number parameter.
16. For each Combined parameter, in the Separator column, delete the forward slash (/).
17. In the Name row, Separator column, add a dash (-).

18. Click OK.
19. In the Schedule Properties dialog box, Fields tab, move the new Space id combined parameter to the top of the list.
20. On the Sorting and Grouping tab, set the Sort by drop-down to the Number of the space.
21. On the Formatting tab, for the Name parameter, enable Hidden field.
22. For Number, enable Hidden field.

23. Click OK.
24. Review the combined parameter and the updated formatting for the schedule.

25. Next to the Fields parameter, click Edit.
26. In the Schedule Properties dialog box, click the Add calculated parameter button.
27. Name the calculated parameter "ACH Calculated".

Next, build a formula to calculate the actual number of air changes per hour based on the volume of the space and the actual supply airflow. This can then be compared against the allocated value for the space.

28. Next to the Formula field, click Browse (…) to open the Fields dialog box.

29. From the list of available fields, select Actual Supply Airflow.
30. Click OK.
31. In the Formula field, type "/1" to divide the value by 1. This accounts for the inconsistent units that will appear in this formula.

32. Click OK.
33. In the Schedule Properties dialog box, below the Scheduled fields list, click Edit parameter to continue with the calculated parameter.

Notice that the unit of measure CFM is added to the formula.

34. Type "*60" to multiply by 60, so the formula reads: Actual Supply Airflow/1CFM*60.

Next, divide by the space volume:

35. Click Browse (…).
36. In the Fields dialog box, select Volume.
37. Click OK.

The completed formula reads: Actual Supply Airflow/1CFM*60/Volume.

38. Click OK to close all dialog boxes.
39. Review the schedule with the added ACH Calculated parameter.

To set the number of decimal places to zero:

40. Next to the Formatting parameter, click Edit.
41. In the Schedule Properties dialog box, select the ACH Calculated parameter.
42. Click Field Format.
43. Deselect Use default settings.
44. Set the Units to Fixed.
45. Set the Rounding to 0 decimal places.
46. Click OK.

The final schedule provides a comparison between:

• The number of air changes per hour as defined in each space.
• A calculated value based on the physical dimensions of each space and the airflow from the systems within each of those spaces.

47. Save the project.