Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Has anybody of you ever used an Excel analysis feature before?
I was thinking on using this for a calculation that I need to calculate a position.
Because it involves an iteration and because it is a very complex calculation, I think it is not possible to do this from within Creo.
Upon opening the setup screen of the excel analysis feature, I noticed this is very basic.
As far as I can see, it seems not possible to add feature parameters?
I really need these parameters to create my excel analysis feature.
Also, it seems it is not possible to add boolean parameters?
(this would be easily solved by adding integer parameters and link them with a relation...)
Does anybody know if it is possible to add feature parameters?
Solved! Go to Solution.
Update
The Excel Analysis feature is a very powerful feature, and works very well.
In my case, I need to iterate a rather complex calculation, I don't think it is possible to do this within Creo.
Problem 1: It is not possible to add feature paramaters
Even more: it is only possible to add parameters from the component itself.
Assembly parameters are also not possible.
And to make things even worse: it is not possible to use locked parameters (parameters that are updated with a relation)
Solution:
I have created a dummy sketch containing lines and angles. The sketch has relations to update the langth of the lines and the angle with the (feature) parameters I need. It is possible to use these dimensions, even if they are driven by a parameter.
Problem 2: Boolean and Real parameters:
You cannot select them from the list, Creo does not allow many things here.
Solution:
Real parameters are made integer by using them as a dimension in the sketch
Boolean parameters are transformed to 0 and 1 by relation. (if YES then 1 ...)
Because of the possible problems of making a line length zero, I used these parameters as a dimension between the 'parameter-lines' (see problem 1)
It's a lot of workaround for such a beautiful feature. I don't know why there are so many limitations defined in Creo.
I now need to create an UDF containing this calculation. I hope it will still work afterwards.
Update
The Excel Analysis feature is a very powerful feature, and works very well.
In my case, I need to iterate a rather complex calculation, I don't think it is possible to do this within Creo.
Problem 1: It is not possible to add feature paramaters
Even more: it is only possible to add parameters from the component itself.
Assembly parameters are also not possible.
And to make things even worse: it is not possible to use locked parameters (parameters that are updated with a relation)
Solution:
I have created a dummy sketch containing lines and angles. The sketch has relations to update the langth of the lines and the angle with the (feature) parameters I need. It is possible to use these dimensions, even if they are driven by a parameter.
Problem 2: Boolean and Real parameters:
You cannot select them from the list, Creo does not allow many things here.
Solution:
Real parameters are made integer by using them as a dimension in the sketch
Boolean parameters are transformed to 0 and 1 by relation. (if YES then 1 ...)
Because of the possible problems of making a line length zero, I used these parameters as a dimension between the 'parameter-lines' (see problem 1)
It's a lot of workaround for such a beautiful feature. I don't know why there are so many limitations defined in Creo.
I now need to create an UDF containing this calculation. I hope it will still work afterwards.
Next problem:
I'm trying to use this analysis feature inside a UDF.
While placing the UDF, I get a message that the feature is failed:
"Analysis creation failed due to computation error"
Is it possible to get more information concerning this error while placing the UDF?
Simplified Logic Inc specializes in bi-directional Excel to Creo or Creo to Excell data transfer this with an application called Nitro-CELL. Please see this Website: Simplified Logic, Inc. and YouTube Channel: Simplified Logic, Inc. - YouTube