Kenevil
Automotive
- Apr 2, 2013
- 47
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