Discover how to create a detailed room schedule using Revit. Learn how to add different fields, set parameters, and calculate total material costs for each room to get the most out of your schedules.
Key Insights
- The article provides a step-by-step guide on creating a room schedule in Revit, starting from the view tab, schedules, and schedule quantities, where rooms are selected.
- It instructs on how to add different fields such as number, name, floor finish, area, and parameters like material cost per square foot, which are used to calculate flooring costs for the schedule.
- The guide teaches how to conduct grouping, sorting, formatting, and conditional formatting for the parameters, ensuring that area and total material cost calculate totals at the end, thus providing an overview of total area and total material cost.
Note: These materials offer prospective students a preview of how our classes are structured. Students enrolled in this course will receive access to the full set of materials, including video lectures, project-based assignments, and instructor feedback.
This next schedule that we're going to create is a room schedule, and we're going to use the room category to make this happen. So just like the other ones we've created, we'll go to our View tab, Schedules, Schedule/Quantities again, and we're going to look for rooms and click OK. Now that we have the schedule properties up, we can go in and we can add all of the different fields that we want.
So in this case, we're going to go with number, name, floor finish, area, and we're going to add a couple of parameters that we're going to use to determine what our flooring cost is going to be for this schedule. So the first parameter that we're going to add is called material cost per square foot. So I'll add the new parameter here, and I'll call it material cost per square foot.
And this type of parameter here, we are going to make it a number because we're going to take our area parameter and multiply it by this so that we can get that information. For our grouping, we can group this under construction and click OK. The next parameter that we're going to add is actually an equation that we'll add here, and this will allow us to add a few different parameters together, multiply them, divide them, whatever it may be, but we can use this, the calculated parameter, to get more out of our schedules.
So I'll click on that, and what we'll do is we'll give it a name. So the name for this one will be total material cost. We will go ahead and leave it as a common discipline.
That's perfectly fine there. And then instead of the number being the type, we need to change it to area to keep the units consistent, and what we can do is we can actually go in and we can use the existing parameters to help create that. So I'll click on that browse button, and I want to do area, and then I'll do shift 8 to add the asterisk, so that's like my multiplication symbol.
Learn Revit
- Nationally accredited
- Create your own portfolio
- Free student software
- Learn at your convenience
- Authorized Autodesk training center
So area times material cost per square foot, and that gives me the parameter that I'm looking for, or the equation I need for that parameter. So I'll click OK, and now I have all of my fields ready to go. So I'll go to Sorting/Grouping, and this one's going to be a little bit more of a straightforward schedule, so we'll go ahead and just sort by number, and then we'll say grand totals, and we're going to say title and total, so that we have that information totaling up at the end.
The next thing I'll do here is I'll go to Formatting, and I want to make sure the area is going to calculate totals at the end, and I want to make sure that total material cost is going to calculate totals at the end as well, so I can see what my total area is, and I can see what my total material cost is going to be. Then we can make our simple change in here to Appearance, so that we can kind of get all these things out of the way before we move back to the next setup for our schedule. Okay, so everything looks good here.
I will go ahead and do some formatting adjustments for these guys here though. So the material cost, we want to make sure that aligns to the right, and same with the total material cost, we want those to align to the right as well. Now, both of these parameters, we want to make sure the field format is relatively close to what a number looks like, so the field format for material cost per square foot, I'll turn off the default, and it's going to be a general one.
We can make it currency, and use the two decimal places if we want, so that it looks like a number, but we're not going to be inputting material cost that goes to two decimal places, but we'll set that up that way anyhow. I'm going to leave the unit symbol off, and you'll kind of see why here in a second. So the total material cost, we can do the same thing, but this is a parameter that's been set up as an area, so it's going to show up as square feet, and so I want it to go to two decimal places, but I can't set the symbol to currency here, so I'm just going to set it to none, and that way we can have it look like you see here in the preview, and it'll look more like a currency setup.
So I'll click OK, and I'll click OK again, and we'll get a look at our schedule. So as you can see here, we have a few rooms that were added, but are not placed anymore, and so if we want to get rid of those, what we need to do is we will isolate the Not Placed/Unenclosed, and then we will delete these ones out of the project. So I'll select the ones that we are not going to keep, so I just did a press-and-drag, and then I will delete these rows.
This is actually deleting the rooms from the project, so we'll click OK. Understanding that is what we're doing, and then we'll go back to show here to show the rest of the schedule. The next thing I need to do here is input some information.
We're going to go through, and we're going to define the flooring for each one of our different spaces here. So the floor finish for my lobby is going to be t-1 for some type of a tile finish, and we're going to try to make this a nicer building, so we're going to have that at a higher cost. If I type in a number here, in this case I'm typing in 18, and press ENTER, then you can see that it will total up the cost.
Now, if you've gone in and done that, and it didn't total up the cost, then you'll need to go back in, rewind the video, and double check to make sure that you had everything exactly the way that I did for material cost per square foot and total material cost.
