AutoCAD MEP General Discussion

Reply
New Member
DBares
Posts: 1
Registered: ‎11-18-2003
Message 1 of 3 (80 Views)

Piping: Has any one used piping objects for cost estimating?

80 Views, 2 Replies
11-18-2003 11:42 AM
I would like to either export piping information for cost estimating to excel, or report the data to a schedule. I would like to know if there is an easier way of generating cost information for a pipe run. I have used the style manager and made a property set definition calculation formula, but I am having problems with different cost factors on different sizes of pipe.

Is VB the best way, or is there something I am missing? Or is there an easier way?
*[Autodesk], Hakan Wikemar
Message 2 of 3 (80 Views)

Re: Piping: Has any one used piping objects for cost estimating?

11-19-2003 03:56 PM in reply to: DBares
Hi DBares!

 

Formulas should be able to do the trick for you
with some VB in it (some if or case things should do the trick). If you
need some info on formulas please look on the "Brain dump" provided by Scott
Arvin in the thread: "where is property ductobject:size defined?" in this
forum.

 

If you need some additional help, please post your
drawing with your tries, in the customer files area with some comments on what
you would like it to do and I'll have a look at it.

 

Thanks

/Hakan



style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
I
would like to either export piping information for cost estimating to excel,
or report the data to a schedule. I would like to know if there is an easier
way of generating cost information for a pipe run. I have used the style
manager and made a property set definition calculation formula, but I am
having problems with different cost factors on different sizes of pipe.

Is VB the best way, or is there something I am missing? Or is there an
easier way?

*[Autodesk], Hakan Wikemar
Message 3 of 3 (80 Views)

Re:

11-19-2003 10:00 PM in reply to: DBares
Hi again,

 

I discovered some problems with this now too, if
you use nominal diameter it provides you with the 1'-3 1/2" format. I
see two problems with that:

 

Problem 1. Formulas doesn't seem to like the "
much... I got around that problem by assigning the value to a variable like
this: varName = "[Nominaldiameter] (notice only one ") the value for the var
name is now 1'-3 1/2.

 

Problem 2.

Hard to calculate with this format... I think I
soved this by changing the string a bit:

 

I came up with the following:

(Where you should be able to just change the
conditions of the if things at the button to get your costs.) (I'm attaching a
dwg wit this and another propset)

 

strInch = "
size=2>[NominalDiameter]

pos1 = InStr(1, strInch, "'")

If pos1 <> 0 Then

feet = CDbl(Left(strInch, pos1 - 1))

Else

feet = 0

pos1 = 1

End If

pos2 = InStr(1, strInch, "-")

pos3 = InStr(1, strInch, " ")

pos4 = InStr(1, strInch, "/")

If pos4 <> 0 Then

inch21 = (Mid(strInch, pos3 + 1, pos4 - (pos3 +
1)))

inch22 = (Right(strInch, Len(strInch) -
pos4))

inch2 = CDbl(inch21) / CDbl(inch22)

Else

inch2 = 0

End If

If pos3 = 0 And pos4 <> 0 Then

inch1 = 0

Else

If pos3 = 0 Then pos3 = Len(strInch) +
1

inch1 = (Mid(strInch, pos2 + 1, pos3 - (pos2 +
1)))

End If

diam = feet * 12 + inch1 + inch2

 

if diam >=10 then

RESULT = 20*
size=2>[Length]

elseif diam >=5 then

RESULT = 15*
size=2>[Length]

else

RESULT = 10*
size=2>[Length]

end if

 

 

 

hth

/Hakan


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

Hi DBares!

 

Formulas should be able to do the trick for you
with some VB in it (some if or case things should do the trick). If you
need some info on formulas please look on the "Brain dump" provided by Scott
Arvin in the thread: "where is property ductobject:size defined?" in this
forum.

 

If you need some additional help, please post
your drawing with your tries, in the customer files area with some comments on
what you would like it to do and I'll have a look at it.

 

Thanks

/Hakan



style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
I
would like to either export piping information for cost estimating to excel,
or report the data to a schedule. I would like to know if there is an easier
way of generating cost information for a pipe run. I have used the style
manager and made a property set definition calculation formula, but I am
having problems with different cost factors on different sizes of pipe.

Is VB the best way, or is there something I am missing? Or is there an
easier way?

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD MEP Category!

The AutoCAD MEP forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community