revit conditional formulas and schedules

0:48
- Create Parameter Required area
[Manage Tab]
Setting panel > Project Parameter

[Project Parameters Dialog]
Add... button

[Parameter Properties Dialog]
Project Parameter
Instance Parameter
Name : Required Area
Discipline: common
Type of Parameter : Area
Group parameter under: Analysis Results
Categories : Room
OK

[Project Parameters Dialog]
OK

1:25
- Add Fields
[Properties Palette]
Fields > Edit...

[Schedule Properties Dialog]
Available Fields: Require Area
Add button

1:28
Calculate Value button

[Calculate Value Dialog]
Name: area difference
Discipline: Common
Type: Area
Formula: area - required area
OK

[Schedule Properties Dialog]
OK

2:00
- Enter required area
[Schedule: Room Schedule - Project Windows]
Number, Name, Area, required area, area different
1,Room,25,25,0
2,Room,25,24,1
3,Room,19,17,2
4,Room,29,21,-2


2:24
- Add Additional Fields
[Properties Palette]
Fields > Edit...

[Schedule Properties Dialog]
Calculate Value button

[Calculate Value Dialog]
Name: over
Discipline: Common
Type: Yes/No
Formula: or(area > required area)
{ and, or, not only in formula field}
OK

[Schedule Properties Dialog]
Calculate Value button

[Calculate Value Dialog]
Name: under
Discipline: Common
Type: Yes/No
Formula: and (area < required area)
OK


[Schedule Properties Dialog]
OK

4:20
-Control Formatting
[Properties Palette]
Formatting > Edit...

[Schedule Properties Dialog]
Formatting Tab
area Difference
Conditional Format... button

[Conditional Formatting Dialog]
Field: area different
Test: Equal to
Value:0 m2
Background color

[Color dialog]
Cyan
OK

[Conditional Formatting Dialog]
OK

4:45
[Schedule Properties Dialog]
Formatting Tab
over
Conditional Format...button

[Conditional Formatting Dialog]
Field:area different
Test:Equal to
Value: Yes
Background color

[Color dialog]
Yellow
OK

[Conditional Formatting Dialog]
OK

5:03
[Schedule Properties Dialog]
Formatting Tab
under
Conditional Format...button

[Conditional Formatting Dialog]
Field:area different
Test:Equal to
Value: Yes
Background color

[Color dialog]
Red
OK

[Conditional Formatting Dialog]
OK


5:48
-Add share parameter

[Manage Tab]
Settings panel > Shared Parameter

[Edit Share Parameter Dialog]
Parameters New... button

[Parameter Properties]
Name: Yes-No
Discipline: Common
Type of Parameter: Yes/No
OK

[Edit Share Parameter Dialog]
OK

6:20
-Add Project Parameter
[Manage Tab]
Setting panel > Project Parameter

[Project Parameters Dialog]
Add... button

[Parameter Properties Dialog]
Shared parameter radio button check
Select... button

[Shared Parameters Dialog]
Parameters yes-no
Add... button
OK

[Parameter Properties Dialog]
Catagories: Rooms
Instance radio button
OK

[Shared Parameters Dialog]
OK

6:45
[Properties Palette]
Fields > Edit...

[Schedule Properties Dialog]
Fields Tab
Yes-No
Add button
OK


7:00
[Home Tab]
Room and Area > Legend
Lagend
{ Place legend to Drawing Area }

[Choose Space Type and Color Scheme dialog]
OK

[Modify:Color Fill Legend contextual tab]
Edit Scheme button

[Edit Color Scheme Dialog]
Title: yes or no result
Color: yes-no
[Color Not Preserved Massage]
Ok
[Edit Color Scheme Dialog]
OK

7:50
- Adjust yes-no field
[Schedule: Room Schedule - Project Windows]
Number, Name, Area,required area, area different, yes-no
1,Room,25,25,No,No,0,Check
2,Room,25,24,Yes,No,1,Uncheck
3,Room,19,17,Yes,No,2,Uncheck
4,Room,29,21,Yes,Yes,-2,Uncheck