Community
AutoCAD MEP Forum
Welcome to Autodesk’s AutoCAD MEP Forums. Share your knowledge, ask questions, and explore popular AutoCAD MEP topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

2 REPLIES 2
Reply
Message 1 of 3
DBares
223 Views, 2 Replies

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

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?
2 REPLIES 2
Message 2 of 3
Anonymous
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?

Message 3 of 3
Anonymous
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?

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost