Bill of Materials in AutoCAD MEP?

[Siberian]

Anyone know how to make a BOM (bill of materials) in AutoCAD MEP? Can't seem to find any command or other way to achieve this...

[RFRUSSO]

AutoCAD MEP?! Thjis is the Revit section my brotha'

[tzframpton]

This is what I use. It creates an Excel Spreadsheet for all MvParts, and other tools used. Great program. Just add/enable it in your Macro Load menu (Cad Manager > Macro > Load Project...) and then run the file named "Main" at the end under your Macros Dialog Box.

MEP_Information_Report.zip

[Siberian]

So there really isn't a built-in thing for this...? Wierd...

I can't seem to make your program work proparly. It keeps telling me "Can't find project or library". I so don't get VB

[tzframpton]

So there really isn't a built-in thing for this...? Wierd...

I can't seem to make your program work proparly. It keeps telling me "Can't find project or library". I so don't get VB

 

Here is how you run it:

 

Go to CAD Manager > Macro > Load Project.

 

Now browse for the file and Open it from whatever directory you saved it under.

 

 

Next, go to CAD Manager > Macro > Macros... and select the 4th option down as in the picture below (the modMain.main file) and hit the Run button.

 

 

Then it will create the Excel BOM that you're wanting.

[chee_dee]

book marked

[chee_dee]

tells me it can't find project or library as well

[SEANT]

One of the reason this will happen is if the project (.dvb) references a version of Excel different from what is on the current machine. From within the VBAIDE, look if anything is listed as "Missing" in References. If it is Excel, select the correct version (may have to scroll down to locate it) for the machine.

[chee_dee]

these are whats missing:

 

AEC MEP 5.5 Application Library

AEC MEP 5.5 Base Object Library

AEC MEP Plumbing 5.5 Base Object Library

[SEANT]

Apparently this VBA project is very AEC MEP specific. If you are trying to use it with Standard AutoCAD 2007, the project will likely need modification to avoid tripping up on those missing libraries.

[ZERYAB]

Here is how you run it:

 

Go to CAD Manager > Macro > Load Project.

 

Now browse for the file and Open it from whatever directory you saved it under.

 

 

Next, go to CAD Manager > Macro > Macros... and select the 4th option down as in the picture below (the modMain.main file) and hit the Run button.

 

 

Then it will create the Excel BOM that you're wanting.

 

Can you please add calculated plumbing lines size (in dia) also. Regards, ZERYAB

[ZERYAB]

I need to include Plumbing lines Dia also in your macro. Can u? please

[ZERYAB]

Great Program! It will be more useful if it can generate plumbing lines lengths with calculated pipe sizes (dia). Can you modify it and send it to me.

Regards,

ZERYAB

[buzz]

I created a Duct Material Schedule that calculates sheet metal area, weight, liner area, lengths, etc. - it was done with the use of Property Set Definitions. You could accomplish the same thing for Piping.

 

-Buzz

[ZERYAB]

Plumbing ducts do have parameters like length, dia meters etc, but plumbing lines do not, can you please check it, if there is any option?

[buzz]

Piping objects do have Length, plumbing lines do too, but you have to add them to the Property Set Definitions...

 

-Buzz

[buzz]

Check out my blog site for the Duct Material Schedule...

 

http://geniusoft.blogspot.com

 

-Buzz

[ZERYAB]

You are genius, the information you have provided me really worked... thank you

[ZERYAB]

but can you tell me the next procedure to create schedule for plumbing lines as its not available in the Shedule and Tag option for plumbing. please your quick reply is needed

[jameslove2012]

When the length of a pipe or duct is over 50000 units, the VB programme stopped, it said 'Overflow'. The problem line is follow:

 

arrABS_Object(2, i) = CInt(arrABS_Object(2, i)) + aDuct.Length 'add one to the # of same column to the identical Duct

 

Please correct it if you can, thank you.