schedule materials only ie: conc.

[Maximillian]

Is there a way to do a takeoff of everything in my model that has the material "concrete - cast in place" assigned to it? My goal is to get the cubic ft or yards of concrete used in the model to know how much to order for the building.

[muttlieb]

Make sure you have the Material: Name and Material: Volume fields in your takeoff schedule. Then create a filter in your schedule that filters by Material: Name equals and select the material you want from the drop down list. In my example I also sorted by Family and Type and selected Grand totals: Totals only.

[Maximillian]

So I will be doing multiple multi-category takeoffs and then just filtering them down..

cool beans

Thanks

[ford347]

To add to this, I have a material take-off I'm doing for my drywall. Since I have drywall applied to my walls and my ceilings, I have made a multi category takeoff, then filter, equals to the drywall material for the walls, then filter, equals to, the drywall material used for the ceilings. When I have both of them filtered, nothing shows up. If I filter one at a time, they will show up??? What's going on with that? The filter tools states, filter by, equal, then material, then in the same dialog box, off to the left, it states 'AND', which tells me you should be able to filter to another material and have them both show up in the schedule. I've done it in other schedules just fine. I must be missing something.


Josh

[twiceroadsfool]

Josh, the AND Filter is telling it to only show Items that meet BOTH requirements, so nothing will show up.

To show both, Filter using OR. Then SORT with the Ceiling vs. Wall...

[MikeJarosz]

Make sure you don't have any duplicate or overlaid objects. They will throw your totals off. We had a lot of problems with overlaid shear walls in the Freedom Tower that affected the total concrete volume.. Your data needs to be very clean when doing material takeoffs.

[ford347]

Thanks guys. Good advice on the clean work. I have been paying extra attention to this as I had anticipated using the material take-off tool for this project. A little cumbersome at times, but it's nice to have the info.


To show both, Filter using OR. Then SORT with the Ceiling vs. Wall...

How do you filter by OR? the and is off to the side in the filters tab, something that can't be changed to my understanding.

I've added the category parameter to the schedule, then sorted by category, but I still need to filter the material, which I'm sure is what you meant by filtering by OR instead of AND, but I'm not sure how to change that.

Thanks
Josh

[muttlieb]

Is this what you're after? It shows total areas of drywall for each building component. I did it the same way I described in the first example I posted to the original question. Filter by Material: Name and then sort by Family and Type and select Grand totals: Totals only. And under the Formatting tab, select calculate totals for the Material: Area field.

[twiceroadsfool]

Thanks guys. Good advice on the clean work. I have been paying extra attention to this as I had anticipated using the material take-off tool for this project. A little cumbersome at times, but it's nice to have the info.



How do you filter by OR? the and is off to the side in the filters tab, something that can't be changed to my understanding.

I've added the category parameter to the schedule, then sorted by category, but I still need to filter the material, which I'm sure is what you meant by filtering by OR instead of AND, but I'm not sure how to change that.

Thanks
Josh

My apologies, i was thinking on the fly. For Filtering, you cant do that. Youll have to Filter down to that material, and then if you ONLY want it for Walls or Ceilings, there are a few options:

Youll have ad add some information to a parameter that you can filter by in both ceilings and floors, or make two schedules, and put them together on the sheet.

[ford347]

Is this what you're after? It shows total areas of drywall for each building component. I did it the same way I described in the first example I posted to the original question. Filter by Material: Name and then sort by Family and Type and select Grand totals: Totals only. And under the Formatting tab, select calculate totals for the Material: Area field.
Yes, that would work. I ran into the problem though because I had two diff. types of drywall material, one for walls, and one for ceiling. The only reason was because one had a pattern and one did not, where I like to see it on the ceiling, and not on the walls. So when I entered both of these into the filter selection, it busted.


Youll have ad add some information to a parameter that you can filter by in both ceilings and floors, or make two schedules, and put them together on the sheet.
I'm not sure I quite understand this. Anyway you have time to post an example. I'll give it a shot.

Thanks a lot!
Josh

[twiceroadsfool]

Well, as you discovered, you cannot filter using the AND for ceiling and wall, or you get nothing. However, both ceilings and walls have a "Comments" field. So if you enter teh word "schedule" in that field, you can then filter by Comments = schedule.

This is a DIRTY solution, because you then have to depend on everyone filling it in as they work, and the moment they forget, your schedules integrity is compromised. BUT, i suppose you could make it a type parameter, and set it up in the types? Also, i used the comment field as an example... If youre using it for other things, you could add a parameter for this purpose...

[sami]

can someone describe a step by step how to schedule all concrete volume in a project (as described in the first question) I am trying multi category but hitting too many roadblocks..
or if someone would like to share their schedule and upload it here that would be great..

I'm trying to get a prelimenary estimate of how much cubic ft of concrete we are using (in slabs, columns & shear walls)

[Scott Womack]

Yes, that would work. I ran into the problem though because I had two diff. types of drywall material, one for walls, and one for ceiling. The only reason was because one had a pattern and one did not, where I like to see it on the ceiling, and not on the walls. So when I entered both of these into the filter selection, it busted.

Depending upon the naming conventions for your multiple drywall names, it can still work. For instance, Gypsum Board Ceiling, and Gypsum Board Wall. One of the options in the filtering is to have a name that "contains" instead of just equals, and then you type in the string "Gypsum Board" This should pick up both materials in one take-off schedule.:beer:

[tomnewsom]

can someone describe a step by step how to schedule all concrete volume in a project (as described in the first question) I am trying multi category but hitting too many roadblocks..
or if someone would like to share their schedule and upload it here that would be great..

I'm trying to get a prelimenary estimate of how much cubic ft of concrete we are using (in slabs, columns & shear walls)
Create a new Material Takeoff Schedule
Make it Multi-Category
Fields: Add the parameters "Material:Name" and "Material:Volume" to the schedule
Filter by Material Name equals (choose your material from the drop down)
OR
Filter by Material Name starts with (type "Concrete" in the box, and it'll pick up "Concrete - Cast in place" and "Concrete - In Situ" for example)
Sort by Material name, turn on grand totals, turn off itemize every instance
Formatting - turn on calculate totals for Material:Volume

click ok!

[sami]

thanks tomnewsom,
One thing I just realized is that if I have a column or wall extending to more than one storey then its entire material will be listed on its base level and not divided between the floors. so the total will be correct but if I want to break it down by floor it is not correct.

I have had this similar issue when creating room area schedules where for simplicity I had rooms extending multiple stories (typical residential tower with similar floors) the room area would only schedule once, that is on its base level regardless that it extends several levels above..

Anyway around this?
I kind of understand the rational for rooms being only listed once regardless how high they extend, but the first issue with materials I don’t get it, isn’t it considered best practice to extend structural concrete walls and columns over multiple floors as opposed to repeating them on each floor?

[tomnewsom]

In the long term, having an object for each floor is the way to go. Revit (usually) works best if you build the model in the same way you'd build the building. Concrete columns are poured floor by floor, so that's how they should be modelled. You can probably use Groups to repeat a column layout on multiple floors.

[Gadget Man]

... isn’t it considered best practice to extend structural concrete walls and columns over multiple floors as opposed to repeating them on each floor?

You may tell me I'm wrong here - as in most cases there are at least two schools of everything and all depends from which school you are - but I always were told this: in Revit you model as you would build in the real life.

Meaning that, in the real life, seldom you would construct walls/columns spanning several storeys.

Usually, even if it looks like it was constructed this way, it's not - for many reasons: structural and constructional limitations, logistics, time involved, etc.

Practically, I found that trying to "cut the corners" and model things "the easy/fast way" adds more unnecessary work later. And leads to errors and omissions.

The best example is in this very thread: if the walls and columns were modelled "by level" they would schedule this way without any other additional workarounds...

And if they were intended to be constructed through several levels at once, they should be quantified accordingly... After all, in such a case, they would still be based at their bottom level - regardless where that was - so this particular quantity of material (say concrete) would belong to this particular level anyway.

Sorry tomnewsom, it took me to write my post so long (I was distructed in the mean time) that I didn't notice yours... I guess I said the same thing...

[tomnewsom]

No need to apologise :) Saying it twice makes the argument stonger!

[sami]

Thanks Jerry & tomnewsom, I guess I will keep walls extending over several floors at early stages and then change them to “ floor to floor walls” when the design progresses.
One thing about using floor to floor walls on a high rise building is computer performance, I would either have to use groups or lock to references, both seem to slow down performance on large multi storey buildings.