Inventor General Discussion

Reply
Distinguished Contributor
SteveFrey
Posts: 512
Registered: ‎09-12-2007
Message 1 of 7 (455 Views)

BOM / Parts List Question

455 Views, 6 Replies
06-07-2012 12:30 PM

In my parts lists the length (81 inches) is displayed as 81 in.  How do I make it so it displays as 81 without the "in" suffix?

 

Also, is there a way to enter a formula like in excel so I can divide the sum by 12 then ROUNDUP to the nearest whole number? 

 

Our system is counting the materials we use to the nearest foot and I'd rather export it to excel already converted. 

 

 

Thanks!

Steve

 

Inventor 2012

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
*Expert Elite*
Cadmanto
Posts: 3,197
Registered: ‎12-07-2011
Message 2 of 7 (445 Views)

Re: BOM / Parts List Question

06-07-2012 12:50 PM in reply to: SteveFrey

Steve,

Edit the parts list and on the QTY column select format column.

 

BOM.JPG

Try editing the units here.

As far as the forumula I really don't know.

Best Regards,
Scott McFadden
Inventor Professional 2013
(Colossians 3:23-25)

Valued Contributor
schae235
Posts: 60
Registered: ‎05-24-2011
Message 3 of 7 (440 Views)

Re: BOM / Parts List Question

06-07-2012 12:57 PM in reply to: Cadmanto

I am not sure if you would want to do this but there is a formula in ilogic to round a number to the next highest whole number.  I am 98% sure that it is "Ceil()"

 

Not sure if you would want to have an ilogic code to save the parameter using Ceil() and then put that parameter in the BOM?  

 

maybe using

 

 "ThisBOM.OverrideQuantity("Model Data", partNumber,quantity)

 

Example:

 

ftQty=Ceil(inQty/12)

ThisBOM.OverrideQuantity("Model Data", partNumber, ftQty)

Of course  fixing the "Model Data" and the partNumber

INV 2012 SP1
Windows 7 64 Bit
ATI FirePro V5800
14.0 GB RAM
Distinguished Contributor
SteveFrey
Posts: 512
Registered: ‎09-12-2007
Message 4 of 7 (428 Views)

Re: BOM / Parts List Question

06-07-2012 01:36 PM in reply to: Cadmanto

Thanks!

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Distinguished Contributor
SteveFrey
Posts: 512
Registered: ‎09-12-2007
Message 5 of 7 (427 Views)

Re: BOM / Parts List Question

06-07-2012 01:37 PM in reply to: schae235

I haven't used iLogic so I'm afraind this won't work for me.  Thanks.

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Product Support
Daren.Lawrence
Posts: 193
Registered: ‎11-04-2003
Message 6 of 7 (385 Views)

Re: BOM / Parts List Question

06-13-2012 12:02 PM in reply to: SteveFrey

The iLogic approach is a good option but if you’re not comfortable in it there are two other options I can think of: the first is to allow Inventor to round to the nearest whole value – if you don’t care about rounding down. See “Approach_1_A” and “Approach_1_B”.

 

In option 2 you can use the “ceil” function to round up to the next highest integer but it’s expected to be unitless (using ceil) so you need to use isolate;unit;ul like “ceil(isolate(LG;in;ul) / 12 ul)” as pictured. This will make sure that, if the length is 73” it won’t round down to 6’ but round to the next highest foot value (7). Please see the attached images (“Approach_2_A” and “Approach_2_B”).

 

In either case, if you don’t want to show the units, you deselect “units string”.

 

Please mark this as resolved if it answers your questions and resolves this. Thank you. 



Daren Lawrence
Product Support Specialist
MFG Support - Inventor
Autodesk, Inc.


http://beinginventive.typepad.com/being-inventive/
Product Support
Daren.Lawrence
Posts: 193
Registered: ‎11-04-2003
Message 7 of 7 (384 Views)

Re: BOM / Parts List Question

06-13-2012 12:03 PM in reply to: Daren.Lawrence

And, due to the 3 attachment limit, here's "Approach_2_B".



Daren Lawrence
Product Support Specialist
MFG Support - Inventor
Autodesk, Inc.


http://beinginventive.typepad.com/being-inventive/

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.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube