Linking assembly files with an excel document drawing data from planes

[Anonymous]

Good Morning All,

Is there any way to link an assembly file together with an excel document?

In a little more detail; we have a cylindrical extrusion with planes set at different degrees from the center, (45 degrees, 22.5 degrees, 90 degrees - see attached images). We then constrain different items to the cylinder at different heights.

What i am wanting to do is be able to make a constraint against three planes - one to constraint to the face of the cylinder, one to lock it into place at the desired degree, and the last as a dimension from the floor so it can be assigned a height, and then actually transmit that data across onto an excel document. 

Is this possible?

[salariua]

I still cant' get what you are after I am afraid.

You could create a common origin type layout where you control the position and angle of the connecting elements by changing their origin. You would essentially constrain origin planes of the parts to origin parts of the assembly (or ground them on origin).

You can also link parameters to excel....

http://help.autodesk.com/view/INVNTOR/2017/ENU/?guid=GUID-E8EF0669-E96E-4503-8A3C-B13AB6D35DBA

[johnsonshiue]

Hi! Or, you can create an iLogic rule within the assembly to link the parameters across parts. If you can provide a simple example what you are after, there are a lot of experts here to help you further.

Many thanks!

[Anonymous]

Hi

What I am actually attempting to do is have one Master document for creating different sizes of tanks with different items attached which can be toggled on and off (visibility). These item assemblies would be constrained to different planes to keep them in place, though i would like it if a set height from a ground plane could be entered.

For example you could select the capacity of the tank (120L / 150L / 210L / 250L / 300L) and then select the diameter of the cylinder required. (450, 500, 600, 700 etc) is what i would like

From this point i would like there to be assemblies which you can navigate to using folders and toggle them on or off by selecting the visibility.

I hope i am making sense here and i am sure there is a much better way than what i initially attempted (which was having sub folders in folders on the left hand side of the screen)

My knowledge of Ilogic is very poor so i'm not too sure what to do on that front.

[salariua]

---

@Anonymous wrote:

Hi

What I am actually attempting to do is have one Master document for creating different sizes of tanks with different items attached which can be toggled on and off (visibility).

---

You will be creating a large file, with a potentially huge number of iddle elements sitting around waiting to be suppressed or not. That is not a problem but you will have a problem if you try to document this on the drawings because you will need to save this huge assembly as a different file on disk every time in order to preserver the settings and have a correct drawing for each configuration.

I don't know your design and intent but I too design tanks, vessels; they are ilogic heavy and the base component has embedded excel file to pull data from.

Because we are not tanks manufacturers and we only need these for quoting and layouts I didn't bother creating it as an assembly but it all resides in a single part. It would have been complicated to do it in an assembly.

if connection 1 = type flange then replace occurrence conneciton1 with file on disk, ...... way too complicated.

I have instead created ifeatures which I can change size and position. Each ifeature is defined by size, type, angle, height, position (side, top) etc... so I ony change from top to side in which case height becomes height from ground floor rather than distance from center ....

anyway, that's me but I know @Jef_E does it as an assembly.