formula inventor dwg X = A x B

[Anonymous]

Hi,
I do not know if this is the right forum but i used to work with Autocad and are aware of the possibilities of using Lisp and was hoping Inventor uses the same programming language. I’m quite new to inventor but am proficient in Autocad and had this problem fixed but in Inventor I’m struggling.

On one work-order we often have to multiple similar steel assemblies ("A" ) and have to produce the individual cutting sheets for each part of that assembly, these are saved in one dwg file with all individual sheets( dwg sheets). 
For each unique part (B) that requires fabricating we generate one sheet and list the total quantity (X) required for the total work order job hence X=A * B. if my assembly has 150 unique part I have 150 sheets in one dwg file. But one part might be used multiple times within one assembly.
The issue that we have is on a new order of an assembly that we have produced before and the order quantity is (A) is different, we have to amend the total quantity required (x) on all sheets individually and takes a lot of time and there is margin for error.
In Inventor all projects have a project file ( *.ipj) and would it be possible to create a formula where in I manually list the quantity of:
A ( total assemblies on order) location in I properties or exel 
B (total number parts required for one assembly) location a text field in my title block field text (model bar)

And X will be generated and is placed in a text field of the title block on each sheet.
This meas when we copy an assembly to a new work-order file we only have to amend "A" and all my sheets will be updated

Any advice is welcome
Frank

[dano0310]

How are you displaying the quanity?  Are you using the Parts List?  A symbol and custom iProperty?

There are numerous ways of doing this all without code.  One way is to add a parts list from the top level assembly and hide all parts except for the one one being detailed.  This assumes that you have in fact reused the same part umpteen hundred times and not just redrawn it lots of times. 

This can get tedious with having to go through and hide all the lines in the parts list that aren't needed.  This is where you can use VBA, VB, whatever.

If this is the case give me a shout and I'll give you the code I use.

[Anonymous]

Hi, Dano0310

At the moment I place the total quantity manually in a table in the title block.

For some reason I can not attach my dwg template.

I started of with producing parts list, drawing a full assembly and placing the total amount of assemblies in one  *iam drawing, followed by creating individual views of each part.

I abandoned this Idea very quickly as it took to much time creating all the individual views for each part.

We reverse engineer all pasts have been named and drawn by the client . We final inspect the design, redraw all parts to make them suitable for welding (adding weld preparations and allow for weld gaps). All parts keep the same part no as per the BoM of the client. that is why we type everything manually, auto number does not work for us. 

But Saying that I would not mind giving this a go again, as this is the way Inventor likes to work. If the code you have saves me time to hide all the lines I'll give that a good go.

 The way I work is a solid one but is not automized and can not create part lists with the information we require and or extract data. I realise We need to work more towards how Inventor wants to work and eventually have everything automized instead of manual text input, (Aautocad way).

At the moment I do not have the know-how of how to amend them all at once i.e list steel quality automatically or link the part number to the sheet number and file name ( might be dangerous in case of errors) currently we type it 3 times and that is no the way, but this will all come in good time. 

Thank you for your help

Frank