Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Any referenced datasets can be downloaded from "Module downloads" in the module overview.
Transcript
00:01
MIKE BRONSON: In this video, we are going to review and modify
00:04
the space schedule.
00:05
It will start by creating additional formulas
00:07
to help reflect the differences between design requirements
00:11
and calculated airflows.
00:13
We start by opening day the existing small medical center
00:16
analysis we find in model 01.
00:20
In the project browser, navigate to the schedules
00:23
and open the space schedule itself.
00:26
Inspect the schedule, noting the parameter information
00:29
being shown.
00:31
In this schedule there are two calculated parameters
00:34
that will compare the differences between specified
00:36
calculated and actual airflow CFM value.
00:40
These fields will be used to verify the spaces made
00:43
in your design requirement.
00:46
Select the schedule.
00:48
Go to the Properties.
00:50
Select the Fields tab.
00:52
Select the Specified versus Calculated Parameter.
00:55
Edit the parameter using the Pencil icon.
00:59
You can see how the formula has been assembled.
01:01
Specified versus calculated is simply
01:03
subtracting specified from calculated.
01:06
Actual versus calculated is subtracting calculate
01:08
from the actual airflow.
01:11
We will use these two fields to highlight, for example, where
01:14
the design requirements or specified supply
01:17
airflow did not match the analysis results
01:20
or calculated supply airflow.
01:23
To accomplish this, we will add a conditional format
01:26
to the specified and calculated supply airflow parameter Select
01:31
the space schedule again.
01:33
Go to the Properties box and select the Formatting tab.
01:38
Scroll down and select the specified supply airflow
01:41
parameter on the left.
01:43
This is where we will add a conditional format formula.
01:46
Since the specified supply airflow is not an exact value,
01:50
we will set the conditional formula
01:51
to arrange building in a taller one.
01:54
The formula will be constructed to reflect when the specified
01:57
value falls within that range.
02:00
Go back to the Properties box and select specified supply
02:03
airflow parameter.
02:05
On the right, select Conditional Format button.
02:10
Drop the fields arrow down and select
02:12
the calculating parameter-- specified versus calculated.
02:16
Set the test to now between with values of maybe minus 50
02:21
CFM to plus 50 CFM.
02:24
Set the background color to a light red.
02:27
This will stand out nicely in the schedule.
02:30
Click OK to continue.
02:32
You notice that the schedule now shows where the specified
02:35
differs from the calculated.
02:37
We can now do the same by checking the calculated supply
02:40
airflow against the actual supply airflow.
02:44
To make sure the air flow from the space supply diffuser
02:46
is enough, we will also set this conditional format to arrange.
02:51
Go back to the schedule.
02:54
Select the properties tab.
02:56
Again, select the formatting tab.
02:59
Scroll down and select calculated supply airflow
03:01
from the list on the left.
03:02
On the right, select conditional format button.
03:06
Again, drop the field's arrow down
03:08
and select the calculatingly parameter-- actual versus
03:11
calculated.
03:13
Set the test to Not Between.
03:16
Make this tolerance a bit tighter
03:17
by setting the values to minus 10 and plus 10.
03:21
Set the background color to maybe a light orange.
03:25
Click OK to continue all the way out.
03:29
Again, notice the highlighted fields
03:30
reflecting the differences between
03:32
calculated and actual airflows.
03:34
One in particular had a value already within that tolerance
03:38
we set up earlier.
03:40
If any of the design requirements
03:42
differ from the analysis results, the spaces in question
03:45
will be highlighted and both color charts
03:47
as you said earlier.
03:49
Remember, you can utilize the schedule as an internal design
03:53
check and create a duplicate schedule,
03:56
hiding those calculated parameters being used
03:58
and your conditional formulas in the project
04:00
schedule for the printed sheet.
04:03
Save the project.
Video transcript
00:01
MIKE BRONSON: In this video, we are going to review and modify
00:04
the space schedule.
00:05
It will start by creating additional formulas
00:07
to help reflect the differences between design requirements
00:11
and calculated airflows.
00:13
We start by opening day the existing small medical center
00:16
analysis we find in model 01.
00:20
In the project browser, navigate to the schedules
00:23
and open the space schedule itself.
00:26
Inspect the schedule, noting the parameter information
00:29
being shown.
00:31
In this schedule there are two calculated parameters
00:34
that will compare the differences between specified
00:36
calculated and actual airflow CFM value.
00:40
These fields will be used to verify the spaces made
00:43
in your design requirement.
00:46
Select the schedule.
00:48
Go to the Properties.
00:50
Select the Fields tab.
00:52
Select the Specified versus Calculated Parameter.
00:55
Edit the parameter using the Pencil icon.
00:59
You can see how the formula has been assembled.
01:01
Specified versus calculated is simply
01:03
subtracting specified from calculated.
01:06
Actual versus calculated is subtracting calculate
01:08
from the actual airflow.
01:11
We will use these two fields to highlight, for example, where
01:14
the design requirements or specified supply
01:17
airflow did not match the analysis results
01:20
or calculated supply airflow.
01:23
To accomplish this, we will add a conditional format
01:26
to the specified and calculated supply airflow parameter Select
01:31
the space schedule again.
01:33
Go to the Properties box and select the Formatting tab.
01:38
Scroll down and select the specified supply airflow
01:41
parameter on the left.
01:43
This is where we will add a conditional format formula.
01:46
Since the specified supply airflow is not an exact value,
01:50
we will set the conditional formula
01:51
to arrange building in a taller one.
01:54
The formula will be constructed to reflect when the specified
01:57
value falls within that range.
02:00
Go back to the Properties box and select specified supply
02:03
airflow parameter.
02:05
On the right, select Conditional Format button.
02:10
Drop the fields arrow down and select
02:12
the calculating parameter-- specified versus calculated.
02:16
Set the test to now between with values of maybe minus 50
02:21
CFM to plus 50 CFM.
02:24
Set the background color to a light red.
02:27
This will stand out nicely in the schedule.
02:30
Click OK to continue.
02:32
You notice that the schedule now shows where the specified
02:35
differs from the calculated.
02:37
We can now do the same by checking the calculated supply
02:40
airflow against the actual supply airflow.
02:44
To make sure the air flow from the space supply diffuser
02:46
is enough, we will also set this conditional format to arrange.
02:51
Go back to the schedule.
02:54
Select the properties tab.
02:56
Again, select the formatting tab.
02:59
Scroll down and select calculated supply airflow
03:01
from the list on the left.
03:02
On the right, select conditional format button.
03:06
Again, drop the field's arrow down
03:08
and select the calculatingly parameter-- actual versus
03:11
calculated.
03:13
Set the test to Not Between.
03:16
Make this tolerance a bit tighter
03:17
by setting the values to minus 10 and plus 10.
03:21
Set the background color to maybe a light orange.
03:25
Click OK to continue all the way out.
03:29
Again, notice the highlighted fields
03:30
reflecting the differences between
03:32
calculated and actual airflows.
03:34
One in particular had a value already within that tolerance
03:38
we set up earlier.
03:40
If any of the design requirements
03:42
differ from the analysis results, the spaces in question
03:45
will be highlighted and both color charts
03:47
as you said earlier.
03:49
Remember, you can utilize the schedule as an internal design
03:53
check and create a duplicate schedule,
03:56
hiding those calculated parameters being used
03:58
and your conditional formulas in the project
04:00
schedule for the printed sheet.
04:03
Save the project.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in to start learning
Sign in for unlimited free access to all learning content.Save your progress
Take assessments
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.