Subtotals in schedule table

[goyete]

Hello, I'm trying to make a schedule table to count the meters of cable tray of a Project but I don't know how... In the example I have attached, I have a multiple meters of a same cable tray dimension. In the schedule table, it counts all of them and it shows the subtotal but I don't know how to show only the subtotals and hide the parcials counting. I would like to have a schedule table with only 4 rows (one for each cable tray dimension) and then another row with the TOTAL lenght of the cable tray dimension.

[VitalyF · Accepted solution]

Hi,

There is no way to do this, unfortunately !!!

I have written many times Wishlist...

Try to use this table with the formula

Set app = GetObject (,"AutoCAD.Application")
On Error Resume Next
RESULT = "--"

Set baseApp = app.GetInterfaceObject("AecX.AecArchBaseApplication.7.7")
Set ActiveDoc =baseApp.ActiveDocument
Set ObjectCollection = ActiveDoc.ModelSpace

totLength = 0
n = "[CableTrayObjects:PartSizeName]"

For Each Object In ObjectCollection
	If Object.ObjectName = "AecbDbCableTray" Then
		If Object.SizeName = n Then
				totLength = totLength + Object.Length
		End if
	End If
Next
RESULT = Replace( Round((totLength)/1000,2), ",", ",")

 

For Autocad MEP2015

For Autocad MEP2014  change this string >>

Set baseApp = app.GetInterfaceObject("AecX.AecArchBaseApplication.7.5")

Regards,

Vitaly

[goyete]

Thanks! It works very very good. Now I will try to apply to different objects like pipes and similar.

[goyete]

Hi VitalyF, I have addapted your Schedule Table for counting pipe and it works good but it takes a lot of time to "operate" the table. Also each time I open a DWG with this table. Is it normal? Thanks!

[VitalyF]

Hi,

Try to convert the Schedule Table in to Autocad Table

and then delete the schedule

[goyete]

Thanks for your information but where is the option to convert a Schedule Table to a AutoCAD Table format. Is it relatively simple? Or where can I read about it to learn to do it. Thanks a lot!!

[VitalyF]

Hi,

Oh, sorry! Right click on the Schedule Table > Convert to Autocad table

[GeorgeMoody]

hi there. do you mind explaining how i can manipulate this formula to work with Eastcoast CAD piping? or any other piping that has special property sets?

[VitalyF]

Hi,

You can attach an example?

[GeorgeMoody]

please see attached dwg file. thank you...