color appearance in distinct materials

[MARCOC]

hello to all, rehearsals, title coems, there is a way to make appear in the distinct material (different base that you do together) a column that brings the field look? ? I must make the color of the part appear in the distinct
I don't know how to do

Thank you very much

 

[MassiVonWeizen]

automatically I fear not, except to use a macro perhaps.
you should fill out the property by hand

 

[MARCOC]

you say you create a color field and fill it manually, without any connection to the appearance name? ? ?

 

[MassiVonWeizen]

you say you create a color field and fill it manually,

I thought it was pretty clear you should fill out the property by hand, But that's what I meant.
appearance name? What is that?

 

[MARCOC]

I create 'aspects' so it calls them solidworks,xhe are the colors, with the name of the ral color, type ral-7024, and we would have liked not to rewrite the color manually, then when I change the look I also have to update the manual field, and definitely sooner or later something is wrong

 

[MARCOC]

I try to search on the net if there are some macros

 

[MassiVonWeizen]

you can use the data table
when you create the color column (which contains a number that I don't know what you identify)
create the custom property and then in excel do a colleague between the two columns

 

[MARCOC]

I saw that by doing the data table, it creates a color column, but apart from the number that associates with the color, but how do I connect a property to that excel column?? you know solid for me are unknown things

 

[MassiVonWeizen]

If you have created a custom property in solid to the creation of the data table you will create a color column and one with the custom property.
then it is to make a connection between the two columns using the functions of excel.
for each color will be used a number, you must associate to this number the corresponding ral and through a function (search.vertical maybe) return in the property column the correct ral code.
the problem is this number of appearance; if you have few aspects you can make a model in which to insert them all and extrapolate their values otherwise if you search on the net if you can decode them

 

[MARCOC]

Massive, making the colelgation between cells, ok works, but the fact and that it takes behind the numeric text of the color that as well as and not usable in a distinct

Now I'm putting an image I found on the helpthe problem and that by inserting that formula in excel, it gives me error and says that it is not correct
Can someone tell me where the mistake is? ? ?

 

[MassiVonWeizen]

Surely without table, which is a banal excel, how do you understand the error, guessing?
look that that formula serves to do the opposite, that is having the rgb of the color calculate the value to be sare to solid to define the aspect.
do you know the rgb of your heral?
what I explained in the previous post you didn't understand it and now, from the cell phone, I can't do it better. tonight I see some examples

 

[MassiVonWeizen]

I attach a part with data table, color property connection and explanation of what I wanted to say in the posts above

 

[MassiVonWeizen]

I also found the rgb-ral values pagehttps://digilander.libero.it/arci56/frames/tabelle/standard2.htm

 

[MARCOC]

Thanks massive, but for the excel speech I understood, I found that formula from the help and inserted it in excel and gave me error, and for what brought it back in the forum, and it does not work because and wrong syntax, it takes the; and not the, as and written in the help
I know he doesn't do what I need, but I wanted to figure out what he was doing.

Thanks again

 

[MassiVonWeizen]

So what's wrong with this system?

 

[MARCOC]

the ultrasound question ere on the formula that didn't work, if you try to copy that written in the help as from image I posted you will see that it doesn't work, then not being expert of excel I asked if someone knew how to tell me why, but then I realized that it was written with the wrong syntax and everything was resolved

try massive and you will see that

 

[MassiVonWeizen]

Okay, correct the formula and you're all right?
signals the thing to solidworks

 

[MARCOC]

I would not like to use the tables in configurations, but I would like to be able to handle it as a normal configuration, without passing by excel

cmq for now is fine so

 

[MassiVonWeizen]

by curiosity I checked the excel page about the use of punctuation and the English version, or perhaps American, instead of the point and comma, as a concatenator of references, the comma is used.page in Italianpage in Englishtherefore of its formula is not wrong but is wrong translation or more correctly adaptation of syntax