Dynamic price listing for Material takeoffs

[Anonymous]

Hi,

Is there a way by which I can create a schedule containing the Market price of Cement, Sand & Aggregate as parameters which I can update any time, such that when these parameters are used in formulas of material takeoffs, the values will be updated automatically?

[Anonymous]

@RDAOU ,

Can you suggest something on this?

[L.Maas]

You can add an instance project parameter (e.g. unit price) to materials.

You then can create a material takeoff where you schedule that parameter.

[Anonymous]

Thankyou @L.Maas,

Can you share some sort of a small demonstration of this on a wall family? It will be easier for me to follow.

If I can explain myself in a bit more detail, we use Cement, Sand & Aggregate in both Columns and Slabs in a particular ratio(1:1.5:3). Similarly, Cement & Sand will be used in both wall plasters and tile screed in a different ratio(1:4).

If I am creating separate Project parameters specifying the cost of these materials for both Floor and Wall families, I am not able to borrow values from these parameters.

Hope I am not complicating the problem more.

Please guide me.

[RDAOU · Accepted solution]

@Anonymous 

Apologies for the late reply, work comes first ... I do not usually do costing in Revit but you can do that using a couple of instance/project Parameters

1. Go To Manage >>> Project Parameters
2. Add New Project Parameter(s)
   • Instance
   • Select Category Material
3. Repeat if you want to break down the cost to more than one material (example: sand + cement + aggregates + curing agent... => 4 parameter
4. Go to view >> Schedules >> Create Material Takeoff Schedule
5. Select category Walls or any other category you are scheduling
6. Add the following Fields
   • Type (ie: wall type)
   • Material: name
   • Material: Area or Material: Volume (whichever is more adequate)
   • Material: Coast A, Cost B, Cost C (the parameters you added in steps 2 and 3)
   • Go to formatting tab and set the fields which need totals to Calculate totals
7. If the parameters you added are unit cost (ie: 100$/cu.m then you will need to add a calculated value calculating the cost per ratio Cement/Sand/Water required)
8. Add also a calculated value for the total

Cost.gif

[denisyukJ]

Hello everyone, 

In addition to question above I've got a bit different problem.

I've got a batch of families which created by using lookup table and I want to add price to every type. Problem is price list updating every month and I will spend a lot of time for manual updating tables inside every family. Is there any way to automate it (or built in function)?

Thank you in advance.

Best regards,

Evgeny Denisyuk

[RDAOU · Accepted solution]

@denisyukJ 

You do not need to open it in revit to update...they are tab delimited files you can open edit in excel, save and close

[denisyukJ]

@RDAOU 

Thank you for your reply. Yes, but I have to update this table inside family manually any way.