stelthorst
2006-05-26, 08:10 PM
Is there anyway to subtotal schedule items?
Here's the scenario.
I have assigned conduit numbers to all of my conduit runs. When I run my schedule table each individual conduit segment is listed in the schedule. What I want to do is somehow total these individual segment up so that my table will show the total length for each conduit run and not for each segment. For example:
Currently 2 conduit runs may have 2 segments (ie straight runs between bends) and my schedule looks like this:
Conduit No.....Size......Length
A101...............2"........10'-0"
A101...............2"........33'-3"
A102...............1"........12'-3"
A102...............1"........10'-3"
I want it to look like this
Conduit No.....Size....Length
A101..............2".......43'-3"
A102..............1".......22'-6"
Right now I'm importing my schedule table into Excel and subtotaling the data there but I'd like to have it done in ABS
ABS 2006
Windows XP Pro
Here's the scenario.
I have assigned conduit numbers to all of my conduit runs. When I run my schedule table each individual conduit segment is listed in the schedule. What I want to do is somehow total these individual segment up so that my table will show the total length for each conduit run and not for each segment. For example:
Currently 2 conduit runs may have 2 segments (ie straight runs between bends) and my schedule looks like this:
Conduit No.....Size......Length
A101...............2"........10'-0"
A101...............2"........33'-3"
A102...............1"........12'-3"
A102...............1"........10'-3"
I want it to look like this
Conduit No.....Size....Length
A101..............2".......43'-3"
A102..............1".......22'-6"
Right now I'm importing my schedule table into Excel and subtotaling the data there but I'd like to have it done in ABS
ABS 2006
Windows XP Pro