AnsweredAssumed Answered

Excel Functions in Design Tables

Question asked by David Mandl on Jul 21, 2011
Latest reply on Aug 3, 2011 by David Mandl

We have a system of derived configurations that we use, primarily so we can configure the materials (we offer our product in several standard finishes).

 

The "Default" config is the parent, and we have a -01 configuration for our clear finish (color code 204), and a -02 configuration for our dark bronze finish (313).  (Ignore the "architectural" config)

 

We have some properties that we would like to control individually between each configuration.  Often, the differences between the properties are pretty minor.  Here is a screen shot from an assembly template that I'm working on right now:

 

New Picture (4).bmp

 

In the B column, I'm controlling a property called "FINISH".  By default, this column will indicate that the parts have an anodized finish, with the -01 and -02 specifying the 204 and 313 finishes specifically.  There will be some parts where we will want to specify a different type of finish (powder coated, for instance).  In those cases, the engineer would have to go through all four rows and change the text individually.  It would be a lot easier if I could use a concatenate command to drive this, so they only have to type over the B3 cell, and the "anodized finish" text would change in the other cells below.

 

However, when I tried to do this, the concatenate command wouldn't compute, and I'd be left with a long awkward text string that is useless to everyone:

 

New Picture (5).bmp

I'm not sure what I'm doing wrong here.  I did this for my .sldprt templates, and it works just fine (see the C and D columns):

 

New Picture (6).bmp

 

Anybody have any ideas what's up here?

Outcomes