AutoCAD MEP
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Piping: Has any one used piping objects for cost estimating
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
70 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?
Is VB the best way, or is there something I am missing? Or is there an easier way?
*[Autodesk], Hakan Wikemar
Re: Piping: Has any one used piping objects for cost estimating
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
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.
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">
"DBares" <dbares@indy.net>I
wrote in message
href="news:f19e5bc.-1@WebX.maYIadrTaRb">news:f19e5bc.-1@WebX.maYIadrTaRb...
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
Re:
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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:
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.
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:
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)
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]
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)))
1)))
inch22 = (Right(strInch, Len(strInch) -
pos4))
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
1
inch1 = (Mid(strInch, pos2 + 1, pos3 - (pos2 +
1)))
1)))
End If
diam = feet * 12 + inch1 + inch2
if diam >=10 then
RESULT = 20*
size=2>[Length]
size=2>[Length]
elseif diam >=5 then
RESULT = 15*
size=2>[Length]
size=2>[Length]
else
RESULT = 10*
size=2>[Length]
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">
"Hakan Wikemar [Autodesk]" <
href="mailto:hakan.wikemar@autodesk.com">hakan.wikemar@autodesk.com>
wrote in message
href="news:2F0EC8D0C5D8E1007D394CB4770A6CD5@in.WebX.maYIadrTaRb">news:2F0EC8D0C5D8E1007D394CB4770......
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">
"DBares" <dbares@indy.net>I
wrote in message
href="news:f19e5bc.-1@WebX.maYIadrTaRb">news:f19e5bc.-1@WebX.maYIadrTaRb...
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?
