Extracting information from ABS

[stelthorst]

Hi All,

Here's the situation. I've completed my coordination drawing with all of my electrical conduit and cable trays. What I want to do now is query the drawing to have it tell me how much (ie total length) of each size of conduit or cable tray is on the drawing and how many of each fitting is on the drawing. I can do this with blocks, via attribute extraction, but am not sure how to do it with ABS objects.

I don't think I've completely convinced management of the advantages of ABS to regular AutoCAD and this would go a long way into convincing them that it was money well spent.

Any help would be greatly appreciated.

[RobertB]

What version of ABS?

[stelthorst]

Sorry, I should have put this in my original post.

I'm using ABS2005 on a windows XP machine.

My IT guy just told me he has the update disk to ABS2006. He just hasn't taken the time to update us.

[arcadia_x27]

You should be able to schedule all these items to get the length of wires and number of objects etc.

[stelthorst]

You should be able to schedule all these items to get the length of wires and number of objects etc.

Now we're getting somewhere. I did some research on schedules and property sets and am beginning to understand them. The problem I'm having now is creating a schedule that will summarize all the entities on my drawing.

For example, I want to create a schedule that lists every size of conduit on my drawing and the total length of all the runs of conduit of that size.

In my mind the schedule would look something like this.

Conduit----------Length
2"------------------85'-6"
2-1/2"------------175'-3"
3"------------------487'-2"

Does anyone know how I might create a table like this?

Thanks in advance for any suggestions.

[Steve_Bennett]

For example, I want to create a schedule that lists every size of conduit on my drawing and the total length of all the runs of conduit of that size.

In my mind the schedule would look something like this.

Conduit----------Length
2"------------------85'-6"
2-1/2"------------175'-3"
3"------------------487'-2"
You would need to turn on the total column for the schedule table, but I don't think that will break it out for each type. It might need to be a formula PSD to fill in what you're looking for.

[stelthorst]

You would need to turn on the total column for the schedule table, but I don't think that will break it out for each type. It might need to be a formula PSD to fill in what you're looking for.

Thanks Steve,

Any idea on what the formula would look like.

I've turned on both quantity and product but my data looks like this:

Quantity............Size............. Length.........Product
17......................2.5.................10'-0".............2.5
1........................2.5..................8'-6".............2.5
1........................2.5..................4'-3".............2.5
etc....etc...

I've worked around my problem by exporting the schedule to Excel and summarizing the data there and then importing this table back into ABS, but it seems like there should be an easier way.

Thanks again for your help.