Hey guys, this is Aaron. I want to take a look today at generating a door and
window schedule using SketchUp and LayOut. I have a model here. It's a kind
of little model. I got these three units, and I'm gonna show you kind of how I
have it set up, and then we'll go ahead and generate a report to create that
schedule. So I have my Outliner open over here. You can see I have a bunch of
Components, a bunch of pieces in this model. The most important part are these
three big pieces out here. They're little houses, cabana kind of things, and
each of these - if I expand the Outliner you can see - have a bunch of doors and
windows in them. So I'm going to go ahead and drill into one of these. I'm going to
open up the Component for this center unit, and I want to pick on one of these
pieces. So right here, first one here is a door. So over here I can look and I can
see I have a Definition name. This is called "Glass Door." And this specific
instance is called "D1." Down here under the Advanced Attributes, which you can
get to by clicking the little plus if it's not already expanded, I have my Advanced
Attribute information: price, size, URL, owner, status, and then my IFC type. If I want to
define that. For this particular thing that I'm exporting - just the door and window
schedule - all I've populated is the size. So this is a 3068 door.
I've done that for all the doors and windows in each of these units. An
important thing to note is that that Instance is actually what's going to
generate the label, and for most of these it's going to be the same. So the same
window repeats, this small window repeats throughout it's called "W4" wherever it's
used, you can see that. The door, for example, is the same component from one
of these units to the next, but you can see it's reversed. So in this one right here
I have it selected. It's called "D1." If I come into this Component over here,
select the same door, it's the same definition. Its "Glass Door," but the
Instance name is changed to "D2" because it's going to be
an opposite swing from this Component over here. So the Component is what
SketchUp calls it. The instance is what I want to call it on my output. Alright
so that all looks pretty good. I have that information in there that I'm going
to want to pull for my schedule. The other thing I'm going to look at now is
my Scenes. Just to point out, I have two Scenes. One is a Section Cut looking down
from above cut through. The other is just this kind of three-quarter view. I'm just
pointing this out because when we hop into LayOut I'm going to actually
reference those scenes, and we're going to create our output from those two
Scenes. So now that this model is all set ready to go, I'm going to go ahead and
generate the report. Generate Report is what's going to allow me to create my
schedule. So I'm going to hit Generate Report and I'm going to create a brand new
template. So I'm just gonna hit Create New Template. First thing I want to
choose is my filter. How do I want to choose which Components I report upon?
A couple options here. First is selection. Do I want to do the entire model or just what's
picked? I'm gonna do the entire model, because I set my model up to take
advantage of nesting over here. Nesting is what level in the Outliner the things
you want to report are on. So if I look at my Outliner right here, the top level is
my entire model. Level number two is these pieces: these barbecue, bench, chair,
fire pit, table, all that stuff plus the three buildings. Level three is my doors
and windows. You can see I intentionally set up my Outliner so that I would have
these pieces in this in this hierarchy. So I can come in here and I can say only
report upon Components in level three. So that's going to only get these doors and
windows. Now if you didn't set your model up that way, you have things in and out
of different levels or something like that, or you have everything in the same
level that you can't report upon a single level, that's fine. Then you just
want to use current selection and go through and pick the items you want to
report upon. It's pretty easy when you have the Outliner you can just kind of
scroll down and pick the doors and windows out of the Component list.
Alright, now I'm going to choose "How do I want to filter?"
I actually want to filter by the Entity Name.
That's this label. It's not the Definition Name. Definition Name is this
over here. I don't want to put that in. I want to get the Entity Name. That's going
to consolidate all the items that are the same into one line on my output. I'll
put a couple other things in here. I'm going to say I want to know the total
Quantities, and I want to put in the Size. That's right. So I'm going to put both those
in there, and looks good. I'm going to save that report. And I'm gonna run that
report. Alright so that gives us a list of: here's the Entity, here's how many
there are in the entire job, and then the Size. That looks good. I'm going to
download that file. I'm gonna save that as "MySchedule." Good to hear, and I can go
ahead and close this then. Now I'm going to go ahead and hit Save.
I don't think I've made any changes, but before I generate my LayOut output I
want to hit save. And Send to LayOut. LayOut's going to open up with my Default
Template and my current Scene showing up in the window. That looks good, but I want
to, first I'm going to do is I want to change my Scenes to that Section Cut.
That's going to give me that top-down view where I can actually see the doors
and windows. That looks pretty good. I'm going to scoot that over, and I'm gonna come in
here and Insert "MySchedule." Alright, that comes in as a new Table, and here I
have Entity Name - the items - Quantity and Size. This is all editable at this point.
At this point it's just a table, so I can come in here and I can say, "Label" if I
don't want to say Entity Name, for example. That's easy to do. Next thing I'm
going to do is label the doors and windows. So I'm going to go ahead and grab one of
these, and I'm going to click on this front door and put it up here. Slide it
over, and now I have an option of choosing, "what do I want to put in here?"
So I can choose my different levels. I'm going to choose on the D2 level to put in
the Component Instance. I could also put in, like, the Size if I wanted to call
that out. In this case I just want to put the D2 in, so I'm just going to click out,
click out. Here's another window. Click there, and the default is going to use
whatever it used last time. So it's going to use that W2 in this case. So I can
come around here and I can click all of these to put them in. Great way, easy way
to create that. It corresponds to this Section right here, and I'm going to go just
for fun make a copy of this. I'm going to shrink it down, and I'm going to add my
model from the other Scene. So here's my, my Scene 2. Because the cool thing is
these labels will correspond to any of the model. So here I have another copy of
the model, and some of these windows that I can't see, I can't see this window
that's up here, this L-shaped window because it's above the section cut, but I
can call it out...
...on this one,
and those labels again correspond to the same schedule, because I'm pulling the
information off of the exact same model. So there you go! Pretty quick and easy
way to create a schedule - door and window schedule - and labels using SketchUp and
LayOut with Generate Report and Advanced Attributes. Thank you!