Inventor General Discussion

Inventor General Discussion

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

BOM / Parts List Question

458 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,231
Registered: ‎12-07-2011
Message 2 of 7 (448 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 (443 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: 517
Registered: ‎09-12-2007
Message 4 of 7 (431 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: 517
Registered: ‎09-12-2007
Message 5 of 7 (430 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 (388 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 (387 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/
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 or visit the Installation and Licensing Forum to get help installing your software.