New Material Creation Macro

[Anonymous]

Hello,

I am an architecture student and a Revit beginner.

I have to make an estimative metric computation of my revit project by using our local price list.

So I started assigning a price to all the materials i have in my project.

For each material to insert I have to Create it (by duplicate another one), and insert cost per m2 and manpower percentage of the cost into the information fields (copy/paste it from the price list .xls file).

Is there a faster way to do it?

Or maybe a code that create new material by taking information from an .xls file?

Thanks

[Anonymous]

Hi,

Have you tried creating material takeoffs and adding the cost and any other formula into the actual schedule table itself? 

http://www.graitec.co.uk/blog/entry/how-to-filter-a-schedule-in-autodesk-revit

you can then filter the schedule based o whether the material is part of the object e.g. brick in a wall, or applied post build e.g. paint or tiles.

the schedule table can have multiple formula added to apply sums sum as working out the number of bricks in a wall e.g. Wall Area*55 and you could even add on wastage % etc.

Regards

Justin

PS once you have a schedule, then this can be exported out to an Excel Spreadsheet  or ODBC into MS Access. Here you can alter information such as cost and manufacture details, save and then 'push' back into Revit (it's a bi-directional link). The DBLink is an Autodesk add-on and is free.

If you're looking for a similar solution via Excel, then Graitec have a whole series of tools including this in their Graitec Revit Power Pack