Windows located inside different wall types - worksheet functions

[Samuel Derenboim]

Hi everyone, 

 

Another questions regarding worksheet functions. Is it possible to call out which windows/doors are located inside a particular wall type?

We generally need this information for energy requirements, and was wondering if something like that was available parametrically. I'm trying to call out wall style name, window ID, and door id and i get the following: 

 

is there a way to integrate wall style id and the objects located inside them using conditional statements in a worksheet?

 

Also, is there a way to just simply call out a wall type id? I can no longer see that option in the 'records' drop down menu. 

 

Either way, thank you in advance!

 

 

Edited November 2, 2018 by Samuel Derenboim