Mechanical Desktop

Reply
*Alex
Message 1 of 19 (177 Views)

BOM FUNCTIONS

177 Views, 18 Replies
08-16-2006 10:20 AM
Hi UG.
Can anyone explain me what these functions in BOM mean?
I am using some of them but a large portion is unknown me.

Regards
Al
*Bob Wiley
Message 2 of 19 (177 Views)

Re: BOM FUNCTIONS

08-16-2006 11:38 AM in reply to: *Alex
Alex,

Do a search in the Mechanical Desktop help on a function like ISBLANK. It will bring up a list of the various functions
and their syntax. This help information is pretty sketchy from Autodesk. However, the use of these functions in Autocad
is very symilar to their use in Excel and VB.

If you need specific help on setting up and using these functions, let me know. I have done quite a bit of customization
to my BOM's using these functions. For example, I have the size of my parts (XX x YY x ZZ) automatically and
parametrically entered into my BOM for 95% of the details I do. This saves a lot of time and eliminates a lot of error
on my cut-lists. I also have the part number and description parsed automatically (and again parametrically) from the
filename. A great thing about all this automation is if I open a part file, do a save as, and then change the length of
the part for example, the BOM/parts-list are completely updated and correct for the new part. There are many other
things you can do with these functions of course.

Bob W.


Alex wrote:
> Hi UG.
> Can anyone explain me what these functions in BOM mean?
> I am using some of them but a large portion is unknown me.
>
> Regards
> Al
>
>
> ------------------------------------------------------------------------
>


--
Bob Wiley
Mechanical Designer
Swedish Match North America

IV 10 SP3a
MDT2006 SP2
Vault 5
XP Pro 2002 SP2
Dell Precision 650
Dual Xeon 2.40 GHz
2.00 GB RAM
Quadro FX 3000, driver version 81.72
*Jason Rhymes
Message 3 of 19 (177 Views)

Re: BOM FUNCTIONS

08-16-2006 12:07 PM in reply to: *Alex
Bob, I would really like to see one of your BOMs with the formulas. I
struggle through these alot myself sometimes. The syntax seems to be picky
from one to the next and the documentation, like you said, is not very
complete or user friendly. What's entered into one, doesn't always work
using the same syntax in the next.
*Alex
Message 4 of 19 (177 Views)

Re: BOM FUNCTIONS

08-16-2006 01:07 PM in reply to: *Alex

Thanks Bob.

It was very helpful.

I'll play with these.

I am using formula:

=TEXT((SIZE_IN/12)*QTY,".000")

It converts IN to FT, and gives me a 0.123
(it's sample) value with a leading "0"

I want to take out a leading 
"0".

Regards

Al

 

"Bob Wiley" <wile2162removeB4atbellsouth.net>
wrote in message

face=Arial size=2>news:5270524@discussion.autodesk.com

face=Arial size=2>...
Alex,

Do a
search in the Mechanical Desktop help on a function like ISBLANK. It will bring
up a list of the various functions
and their syntax. This help information
is pretty sketchy from Autodesk. However, the use of these functions in Autocad

is very symilar to their use in Excel and VB.

If you need specific
help on setting up and using these functions, let me know. I have done quite a
bit of customization
to my BOM's using these functions. For example, I have
the size of my parts (XX x YY x ZZ) automatically and
parametrically entered
into my BOM for 95% of the details I do. This saves a lot of time and eliminates
a lot of error
on my cut-lists. I also have the part number and description
parsed automatically (and again parametrically) from the
filename. A great
thing about all this automation is if I open a part file, do a save as, and then
change the length of
the part for example, the BOM/parts-list are completely
updated and correct for the new part. There are many other
things you can do
with these functions of course.

Bob W.


Alex wrote:
> Hi
UG.
> Can anyone explain me what these functions in BOM mean?
> I am
using some of them but a large portion is unknown me.
>
>
Regards
> Al
>
>
>
------------------------------------------------------------------------
>



--
Bob Wiley
Mechanical Designer
Swedish Match North
America

IV 10 SP3a
MDT2006 SP2
Vault 5
XP Pro 2002 SP2
Dell
Precision 650
Dual Xeon 2.40 GHz
2.00 GB RAM
Quadro FX 3000, driver
version 81.72
New Member
willy34
Posts: 1
Registered: ‎08-16-2006
Message 5 of 19 (177 Views)

Re: BOM FUNCTIONS

08-16-2006 01:29 PM in reply to: *Alex
1 question for multi bom & multi balloon
in multi layout.
*Bob Wiley
Message 6 of 19 (177 Views)

Re: BOM FUNCTIONS

08-17-2006 09:02 AM in reply to: *Alex
Alex and Jason,

Take a look at this drawing it has the BOM functions I regularly use in addition to some that will do what Alex is
looking for.

Open this file and take a look at the BOM (AMBOM). Go all the way over to the right most 3 columns and you will see how
I would format the size to drop the leading zero. The first of the three columns has the source size (1.476). The second
has the unformatted calculated size in feet (ES) using the formula you provided. The third has the calculated size with
the leading zero dropped. If you look at the formula in the third column, you will see that the unformatted size (ES) is
referenced 3 times. If I had not placed the unformatted size in its own column then the formula in the third column
would have been VERY long and hard to read.

Now take a look at the column labeled "Size". It is fairly lengthy but is takes the X, Y, and Z dimensions for a
rectangular part, sorts them, and puts them in my BOM. For this to work, My base extrusion must be a rectangle with
constraints d0 and d1 as the length and width. When I extrude the rectangle, d2 is the draft angle which I ignore in the
BOM. d3 is the extrusion distance. So it is d0, d1 and d3 that I sort and use. This works for most all of my parts.
Anything that is not a rectangle to begin with requires me to manually type in the cut size on the BOM. The formula in
this column is not locked so all I have to do is just type over the calculated cut size if needed.

Look at the columns labeled "First space location" (SP), "PARSE" and "Description length" (US). These formulas set up to
parse out the part number and description from the part name (File name). We add an "_S" on the end of all our 3D solid
MDT files to distinquish them from regular Autocad 2D files. This "_S" is trimmed from the file name for the
description. The formulas in columns labeled "Dwg/Part No." and "Description" use the formulas SP, PARSE and US to
actually parse the part number and description. Normally I would have the SP, PARSE and US columns hidden but they are
visible in this case just for discussions sake.

The attached file is "SM-102002 CRANK GUARD COVER_S.dwg" The part number would be all the characters to the left of the
first space. The description would be all of the remainder with the _S stripped away. I can't remember the last time I
actually typed in a part number and description for a part. This works well!

To make all these formulas easy to use requires they be inserted automatically. You don't want to have to type these in
manually every time you need to use them. For some reason custom BOM standards cannot be put in your template file. What
I have done instead is place them in a seperate file that can be inserted as a block into the current drawing. My BOM
standard is in a file called SMNA_std_rev_B.dwg. I then have a toolbar button that fires the macro:

^C^C-insert "S:/TWOLF/DRAWINGS/LIBRARY/SMNA/TITLE/SMNA_std_rev_B" r 0 s 1 0,0,0;_amsymstd

This inserts the drawing containing the BOM standard and runs AMSYMSTD so I can pick a specific BOM standard with it's
associated formulas. I have three standards I use. One for parts, one for assemblies and one for purchased parts. These
BOM standards also set up which columns show up on the parts list that is placed on the drawing.

I have been using these BOM standards and formulas for probably 8 years now. Obviously I did not do all this overnight
and it has required some tweaking. The result has been untold hours saved and errors prevented.

--
Bob Wiley
Mechanical Designer
Swedish Match North America

IV 10 SP3a
MDT2006 SP2
Vault 5
XP Pro 2002 SP2
Dell Precision 650
Dual Xeon 2.40 GHz
2.00 GB RAM
Quadro FX 3000, driver version 81.72
*Jason Rhymes
Message 7 of 19 (177 Views)

Re: BOM FUNCTIONS

08-17-2006 12:11 PM in reply to: *Alex
Thanks, Bob for the great explanations. I'll be able to use some of this in
my BOMs. I didn't know about AMSYMSTD and I'm still not sure how to get it
to work as you described. Had no clue this existed. I couldn't find ANYTHING
in help file on it.

Looking at all the automation in the boms you have, I'm surprised you
haven't taken advantage of fields in your title blocks.
*Bob Wiley
Message 8 of 19 (177 Views)

Re: BOM FUNCTIONS

08-18-2006 06:31 AM in reply to: *Alex
Jason,

I have looked into this in depth. I can't figure out how to format and parse the information available in the fields. If
I could link my BOM info back into the fields it would be a no brainer but that does not seem possible. The best I have
been able to do is a VB script that retrieves field information, formats it, and then pushes it into the title block.
That's not a bad solution but I havn't spent enough time on it to get all the bugs out yet. Any ideas?

Bob


Jason Rhymes wrote:
> Thanks, Bob for the great explanations. I'll be able to use some of this in
> my BOMs. I didn't know about AMSYMSTD and I'm still not sure how to get it
> to work as you described. Had no clue this existed. I couldn't find ANYTHING
> in help file on it.
>
> Looking at all the automation in the boms you have, I'm surprised you
> haven't taken advantage of fields in your title blocks.


--
Bob Wiley
Mechanical Designer
Swedish Match North America

IV 10 SP3a
MDT2006 SP2
Vault 5
XP Pro 2002 SP2
Dell Precision 650
Dual Xeon 2.40 GHz
2.00 GB RAM
Quadro FX 3000, driver version 81.72
*Jason Rhymes
Message 9 of 19 (177 Views)

Re: BOM FUNCTIONS

08-18-2006 06:39 AM in reply to: *Alex
It would seem like you could use FIELD and use a diesel string to parcel.
It's been a while since I messed with this but I'll look into it.
*Jason Rhymes
Message 10 of 19 (177 Views)

Re: BOM FUNCTIONS

08-18-2006 10:04 AM in reply to: *Alex
Well I made you one but didn't realize until after you're using 2006. An of
course it's not easy to do a save as out MDT but I did. You may have to
recover before opening it. It crashed my 2005 here.

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
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

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

Ask the Community