Quantity takeoff schedule

Revit
1

Good afternoon
I am very new to Revit and I have Revit 2025.
I wanted in the quantity list at the image that depending on the “Units” column having m2, m3, etc., it fills the “Quantities” column with the corresponding “Material: Area (m2)”, “Material: Volume (m3)” columns.

Formula
Formula1281×500 50 KB

I would appreciate it if someone could indicate a solution.

2

just let excel formula handle it, a bit of post-processing never hurts.

3

With Excel it’s easy…but i’d like have it directely on Revit quantity takeoff schedules…

4

This is my Revit go, I don’t think we can use a boolean parameter to drive a text field directly.

So I made a Yes/No (which can be hidden but that is risky?), then you can write a formula.

I used a volume Type, and did Area*1 to keep the units consistant.

If you want a dynamo flow, you could easily use a maths operator in your exporting to Excel, that would remove the risky of someone not updating the Yes/No when they make a material. Note the lacing set to ‘longest’.

I hope that helps,

Mark

image
image1427×784 135 KB

image
image1920×616 244 KB

5

I often found it best to do two schedules. One for area based stuff and one for volume based stuff. This makes the downstream work which occurs with the schedules much easier as you don’t have any risk of cross contamination.

Process there is easy:

  1. Duplicate the schedule twice.
  2. Rename one duplicate “volume takeoff” and add a filter of Material: Volume > 0
  3. Rename the other other duplicate “area takeoff” and add a filter of Material: Area > 0
6

Jacob thank’s for your answer.

The idea is to have on one shedulle all the quantities extracted from the model.

7

Ok - you have that already though.

Combining the volume or area into one value will (not can; will) eventually lead to issues where a material is used as both a form (so volume) and a paint (so area). I used to see this all the time where the designer would want the finish of the paint applied to the curtain wall mullions (so M2) to match the finish on the decorative metalwork (so M3). Trying to combine the two usually requires an async effort that is easily overlooked extra step (‘run this tool before we hit print’) and results in data which doesn’t mean what those receiving it think.

Your use case for now might be narrow enough that this isn’t an issue you can see, but I can’t recommend such a solution.

8

Hi Mark

Thank’s for your reply but i supose it work’s only when the shedule is exported.

9

Hey,

The first screengrab shows a solution which is native Revit, no exporting or addins needed (including Dynamo).

You just export your schedule to Excel as it is.

But it needs the the tick box for ‘Is_Area’ to be set correctly whenever a new material is created.

That is the risk.

Cheers,

Mark