Pilot assembly equations

Hello

I would simply like to know if it is possible to integrate simple equations into the excel file automatically generated by the Pilotassembly.

Concretely, I would like the Ø of a part to be equal to the Ø of another part of this assembly... I put my basic excel formula in the cell concerned: =E119, but when I started the modification this formula did not work...

Thank you in advance for your answers

Julian

Hello

Why don't you edit the dimension in the assembly and then you do = and you click on the function with the other Diam so that the dimension appears and then you click on it. Thus they will be linked.

2 Likes

Ditto, why insist on going through excel when the bass equation system does the same thing?

2 Likes

Hello thank you for your answers, I found it more user-friendly to go through excel, all the functions, dimensions ... are available and readable on the screen. If it's not possible, too bad, I'll do it in the asm directly.

If possible, just create an excel file in the assembly and then you do as in a part by selecting the dimensions.

2 Likes

How do we create this excel file?

I'll explain my approach to you, it will help you understand where I want to go.

I design UV reactors, these reactors are infinitely customizable at the customer's discretion

Body Ø (DN150 to DN700), Inlet/Outlet Tap Ø (DN40 to DN450), Number of Lamps (1 to 48), Orientation etc etc... The sales people ask me daily for this or that configuration and it takes me a lot of time. I attended the presentation of Driveworks but this solution will require too much time (in addition to being very expensive) for its deployment, so I turned to the pilotassembly which seemed suitable to me.

My original idea was therefore, via the excel of the pilotassembly to generate my volume and then thanks to the smartdrawing module to generate the drawings automatically.

I'm putting you the image of a reactor that could be customized to see what it looks like.


rea-1lampe.png

Have you tried changing the format of the cell in pilot Assembly,

Otherwise, make a request to support by opening a ticket, they are the ones who develop this software, they will answer you quickly if it is possible or not!

To do this, you can use a support menu and then open a ticket.

 

Watch and see, it should help you 

1 Like

Hello, it is also possible to make the holes in the assembly by asking to propagate the function to the parts. in this way the 2 Øs are identical and perfectly aligned.

may the force be with you.

 


obiwan.jpg
2 Likes

Hello, thank you for your answers, I'll probably mix all your solutions to achieve my goals. The families of parts, the holes in the context and can be the pilot assembly.

 

1 Like

Hello

You can also create an Excel file of the part family whose references of the configurations made in it are identical for the different parts, then you will just have to link this Excel file to these parts.

 

3 Likes

Yes, I'll probably try in the first place by the families of parts, it's true that it's a function that allows a lot of things. The key now is to find the time to do it:)

Thank you all again for your participation