Expression Value from Table Possibility
Expression Value from Table Possibility
(OP)
Hi John,
I'm creating a envelope based on SAEJ287. Both the J-Spec and my file require two inputs. Based on those inputs, one of the outputs is a "G" value. The J-Spec directs you to a particular xyz table based on the "G" value to locate approx 100 points. Without linking to an excel file somehow, I am about to do the following for each point...
Expression PT1_X = IF(G<-1.25)(850)Else If(-0.5<G<-1.24)(825)Else If ... I think there are 5 or 6 tables
Y and Z are always constant so I only have to do this for the hundred X values but it's still a lot of work. Plus, I did something similar for a "standard bolt shaft to hex head" relationship and it seems take a long time to open this file even though it's very small. Is there a better way to do this?
Scott
I'm creating a envelope based on SAEJ287. Both the J-Spec and my file require two inputs. Based on those inputs, one of the outputs is a "G" value. The J-Spec directs you to a particular xyz table based on the "G" value to locate approx 100 points. Without linking to an excel file somehow, I am about to do the following for each point...
Expression PT1_X = IF(G<-1.25)(850)Else If(-0.5<G<-1.24)(825)Else If ... I think there are 5 or 6 tables
Y and Z are always constant so I only have to do this for the hundred X values but it's still a lot of work. Plus, I did something similar for a "standard bolt shaft to hex head" relationship and it seems take a long time to open this file even though it's very small. Is there a better way to do this?
Scott





RE: Expression Value from Table Possibility
RE: Expression Value from Table Possibility
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.
RE: Expression Value from Table Possibility