Retrieve the calculated cell from a table in a custom property

2D plans Layout
21

"Let us agree in the direction of the table towards the properties."

So there, for me it's impossible, you have to declare somewhere a variable to be able to link it!

1 Like
22

"Unless you know how to integrate an equation into properties.

I know how to concatenate them, but is it possible to add them together?"

Can you explain a little more please?

23

Here is an example


capture.jpg
1 Like
24

Do you mean, "Create an equation with custom properties?"

 

[EDIT] I hadn't seen your message

25

So yes absolutely, in my previous example:

I do have a relationship between the properties, here "MAWP_barg" / 10 = "MAWP_MPa", the value 2.17 is calculated via this formula

[edit] So thanks to this formula, you only have to drive the value of "MAWP_barg" so that the value of "MAWP_MPa is updated

1 Like
26

Except that here you go through a global variable, which I can't do with respect to my assembly model. I have to stay at the level of the MEP.

2 Likes
27

Exactly, I had mixed everything up...

 

28

So for me, if you don't want to add variables in your room, apart from integrating global variables into an empty room... I'm drying

1 Like
29

I'm doing research to go through a macro. it's a funny problem  :-)

30

And we want your macro in the file of this question to help those who have the same questioning as you:)

1 Like
31

I tried to follow along, but I don't understand what prevents me from including them in the assembly but only displaying them in the mep ?!??   I must have missed an episode somewhere...

1 Like
32

@opiep27 "I'm sorry but it has no interest for me to create this variable in my model.

The MAWP property in my case is only important for the display in the MEP.

I already have 254 global variables in my model to be able to control all the parts attached to it."

1 Like
33

@opiep27 and "Except that here you go through a global variable, which I can't do with respect to my assembly model. I have to stay at the level of the MEP."

1 Like
34

I didn't know that the number of variables was limited.

Regarding the interest of creating it in the template: there may not be one, except to display it later in the mep....

1 Like
35

There is no limit to the number of variables, he simply does not want to create more (I admit that I would have chosen to create some but I don't know enough about these problems :) )

2 Likes
36

Hi all

First of all, thank you for paying attention to my problem.

To enlighten you, I am copying the screenshot of my model.

The company I work for manufactures high-capacity heat exchangers. At the moment we use Autocad to make the plans, but we have a strong dynamic to move to 3D. I am therefore leading a project to create a parametric model for a category of our interchanges.

The client of this project (the designers) must already fill in a very large amount of data in the assembly part that I have them fill in through an excel sheet that is then written in the assembly. This sheet is temporary to give the IT department time to create a bridge between our calculation tools and solidworks. The final goal is that the "customer does not have to enter the assembly and that he remains at the level of the MEP.

I hope that I have partly answered your questions.


capture.jpg
1 Like
37

Oh yes, it's clearer :)!

So if not, maybe it's possible to use the custom property forms that are available with drawings. This will allow you to have a user-friendly interface for your customers.

On the other hand, it seems to me once again that mathematical formulas between custom properties are impossible.

1 Like
38

So you said earlier:

"I created in solidworks a "General Table" (that's the image I linked) in which I retrieve the value of my custom property in "barg", then thanks to the formula I do my conversions in the neighboring cells, all this still in solidworks (2013 for info)."

The client of this project (the designers) is therefore the ones who enter the data into the assembly.

The MAWP value (barg) is populated by whom? 

The end customer must, if I understood correctly, only have access to the plan with the data from the MAWP

39

And the LUT is currently manual?

40

I had already made it possible to create a form to be able to modify the plan easily (Capture).

At the moment, it is the designer who informs it at the MEP level.

For the moment I have reached the point where the designer does not need to enter the assembly to enter a data, at worst to hide an option (a company plate for example). Everything happens from the MEP and the excel form for the data (2nd capture).


capture.jpg
1 Like