Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
528 Posts
5 Kudos
Registered: ‎09-12-2007
Post 1 of 7

BOM / Parts List Question

511 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*
3,370 Posts
1,273 Kudos
Registered: ‎12-07-2011
Post 2 of 7

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 2014
(Colossians 3:23-25)

Valued Contributor
60 Posts
6 Kudos
Registered: ‎05-24-2011
Post 3 of 7

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
528 Posts
5 Kudos
Registered: ‎09-12-2007
Post 4 of 7

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
528 Posts
5 Kudos
Registered: ‎09-12-2007
Post 5 of 7

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
194 Posts
3 Kudos
Registered: ‎11-04-2003
Post 6 of 7

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
194 Posts
3 Kudos
Registered: ‎11-04-2003
Post 7 of 7

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/
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post