Retrieve the calculated cell from a table in a custom property

Hello

I want to retrieve the value of a cell that I calculated in a table from a custom property.

e.g. "MAWP (MPa)" is calculated against "MAWP (barg)" which is already a custom property.

In fact in the same document I should be able to display the MAWP in different Units (x4).

I created a form to insert the value in barg and I wanted to be able to do some kind of automatic conversion.


capture.jpg

If it's just to make a table, I think it's possible to put a formula in the table (like XL).

Hello

No, it's not to make a table but a Note. I would like to retrieve in my Note what I have calculated in the table cell.

To be more precise, the workshop works with this plan and we operate with bargs. Apart from this, this plan is also used to get the foreign authorities to approve the devices we manufacture and they (the authorities) work with units other than the barg.

Hello

As Stefbeno says,

What you call the "note" is the painting we see in your image?

If so, why use an external Excel file if you can include formulas directly in SolidWorks? (e.g. by creating a variable in the equations)

For example, you could create a relationship for MAWP (MPa) of the type => "MAWP (MPa) = "X" x "MAWP (barg)

Hello

We misunderstood each other, I apologize. I created in solidworks a "General Table" (this is 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 information).

I would like to retrieve in a note (attached capture) the value I have just calculated.


capture.jpg
1 Like

Ahhh yes indeed I had misunderstood:)

Stefbeno asked a similar question yesterday: 

http://www.lynkoa.com/forum/cao/mecano-soude-annotation

Maybe it will help you

2 Likes

Maybe not so simple, I just tried and when I click on the table box to associate it with the grade, it stops editing the grade (like when you click to validate the grade).

For the time being, you may indeed have to go through variables calculated in the "equations" panel of the room but you lose the link with the table.

1 Like

So then, according to the tests I just did and if the following information is correct:

MAWP (MPa); MAWP (Barg), etc... are custom properties

So, when creating the note, you have to click in the "Text format" tab and then on "Link to property"

Then "Model in the view specified in Sheet Properties" -> Click on File Properties

Choose property is go to the drop-down menu to select the custom property:

The link should be made in this way

 

 

4 Likes

Its no problem.

The problem is how to go from the general table to the personal properties.

How I create a personal property. which retrieves the calculation I made in the table.

1 Like

Equation -> Variables

Variables -> Custom Prop

Personal prop -> board

                    -> note

4 Likes

It seems to me that you can't create a global variable in a drawing.

And to complete Stefbeno:

Double-click in the table box -> Link Property 

For example, the table box clearly indicates the custom property created by a variable. Variable that can be driven by another variable!

[edit] The variable must be created in the room

[edit] Adding the image to link the table to the property:

 

4 Likes

Indeed, they must be created in the room

Also, to explain to others how to make this kind of relationship through variables:

 


conversion.jpg
3 Likes

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.

Well in this case you can also create an empty room by including these 3 variables, but hey it's not necessarily very clean ....

Or create the custom properties in the drawing by "File" -> "Properties" and link them to the table:


tableau_prop_perso.jpg
1 Like

[duplicate]

How to link them to the paintings.

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

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

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

This will save me the creation of  this table.