I am creating a BOM for a job i am working on. The problem i'm having is i cant combine the same size conduit in the BOM. For example, I want to have one line item that says 3/4" conduit and it give me a total footage for all 3/4" conduit and not several lines for 3/4" conduit that i have to calculate a total.
Review the attached PDF. It shows that i can combine and get a quantity of 10' sticks but the ones that differ in size have there own line item.
It is the length column itself that is causing the items to be split up. If you want all 3/4" conduit to be on one line, you will have to remove the length column.
But the lenght is important on the BOM. What it looks like I'm going to thave to do is have a seperate bill for each differnet size conduit. At the bottom i can get a total but i need a total per group. For example. I will need a total footage for 3/4" conduit, total for 1" conduit, total for 1-1/4" conduit, ect.
So the important ones would be the size of conduit and the total footage of each different size. I thought there was a way to group the BOM by size and lenght so you want end up with 50 pages of just 3/4" conduit.
Hopefully someone can find a fix for this or maybe Autodesk will give this option in the future,
thanks for the help.
For some things, it is desired that the length be shown for each item. Things that are not field cut to length for example.
One way to get what you are after is to add a manual property to the property set you are using for the schedule table. After scheduling the conduit you can note the total length then delete the length column. Select the table, right click and select "Edit Table Cell". Type the total length into the cell under your manual property column.
AMEP does not allow for totals of a row wether you use a formula or not, It only allows for totals of a column. Its is a limitation of the schedules. The only way I know of is to export the shedule to exel then do your totals in there.
Ryan Smit
MEP 2012
South Africa
I have been working and asking for years for a way to this. The best way we have found is to like mentioned either use a manual entry into a property or export to excel. I have also at times copied the schedule and converted it into a table. We can then link that table to excel or manually add fields and other items to it so that we get the calculations we need.
If you read the notes in link it explains how thrown together quickly to get something going so basiclly for each pipe with same system, diameter etc.......
You can read link, but the source code and dll for using at link.
Please post any ideas you would like to see.
Does not cost any money, but you might have to join theSwamp to download.
If you are not a member you should join as it is a great resource.
http://www.theswamp.org/index.php?topic=39349.new
From this
To