Window vs Room Schedule/embedded

[yes_and_no]

 

 

Guys, I have a few questions re. Windows and associated Rooms as attached jpeg:

For small project or repetitive unit plan we have this window schedule, including vents, for light and ventilation purpose. As I hope you can see, we have to manually enter room areas (yellow) and make up some bold lines over the undesired data cells.

Q1: is there a way to black out the unwanted cells.

Q2: is there a way to include room area automatically associated window group without the messiness of embedded schedule (yes, unless you can show me a pic of a nice one) nor placebo rooms ?

Thx

[barthbradley]

---

@yes_and_no wrote:

Q1: is there a way to black out the unwanted cells.

---

You might look into Conditional Formatting (Format tab).  

[ToanDN]

---

@yes_and_no wrote:

 

Q1: is there a way to black out the unwanted cells.

Use Conditional format to black out cells.

Q2: is there a way to include room area automatically associated window group without the messiness of embedded schedule (yes, unless you can show me a pic of a nice one) nor placebo rooms ?

Add [From: Room] or [To: Room] Area parameter.

---

[RDAOU]

@yes_and_no 

1. Black or Blank? a solid black row sounds a little bit odd
2. Not that you need Room + embedded, a window schedule should give you all the info you need but I'm curious about what you find so messy about embedded schedule? 

[yes_and_no]

Guys, thx for the tips.

I have been able to use Conditional format to clear most of the fields that previously has been blacked out by bold drafting lines.

Only two columns left, and I still need help. As you see, this schedule has both windows and vents listed. Default typical vents of 6"dia. are scheduled, and as same as the windows they do report dimensions and areas. I would like these columns to continue to report such, but as the area get lesser than 1sf (the vents) then it should return "N/A". I m thinking of "IF" argument, but don't know how to make a return result. My clause is IF(width*height<1sf, "N/A", width*height) ....returns either invalid unit warning or invalid text warning.

 

[RDAOU]

@yes_and_no 

That will give inconsistent units ... You cannot combine text and number in the output of an IF statement

You could use both text

• if(true, "N/A", "Refer to Area")
• Or use a symbol... if(true, "", "●")

Otherwise both Area

• if(true, 0, Height*Width) ...ie both area

[ToanDN]

Why don't you black out the vent dimensions as well?

[yes_and_no]

We do need that dia. dimension

[yes_and_no]

I used your last line, Rv didn't understand "true". Can you make it any more clear ?

[RDAOU]

True means the condition you need example: height*width<1

Thats the general syntax so to say if(true, value1, value2) ... were value1 and value2 must have the same type/unit ie: both texts, both areas, both integers ...)

[yes_and_no]

Guys, I m getting pretty close. However:

• Q3: As you see in attached, the Windows report Fr room name  correctly (thx to Toan), yet the Vents report wrong room. They are created by OTB window families, I tried both w/frame and w/o type. Yes RHAOU, I also flipped their face. Furthermore, another one (last one) didn't even bother to report room data.

I have not tried to duplicate one working window, strip down everything and save as a vent, pretty sure it will work but I won't learn anything.

Can you point out what's went wrong ? Thx

 

[RDAOU]

Edit the family enable the toom calculation point option and check the from and to arrows...maybe you need to drag/adjust them to fall into the right room.

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2018/ENU/Revit-M...

[ToanDN]

Make sure the the Room height (Limit Offset) is higher than the Vents.  If not, the vents are considered outside of the room.

[yes_and_no]

Thx Toan n Rdou,

Now I try the next difficult task, embedded schedule. It appears that option is no longer available. So I created a new one with fewer column.

Rdaou, see attached for what I meant by messiness of embedded schedule ( or perhaps I didn't know how to make it work yet). It hard to break room data to be sideway from window data like I had from previous schedule (which I still have to enter room sf manually.