×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Spreadsheet Functions in NX

Spreadsheet Functions in NX

Spreadsheet Functions in NX

(OP)
Spreadsheet function in NX is limited to only 8. Is it possible to insert more excel function?

RE: Spreadsheet Functions in NX

If you're talking about the functions available from within the NX Expression system, yes, but it will require you to program them using the KF (Knowledge Fusion) tool set.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Digital Factory
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Spreadsheet Functions in NX

nilanjana2012 --

What functions are you looking for here?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)

RE: Spreadsheet Functions in NX

8 - what ?

RE: Spreadsheet Functions in NX

(OP)
Dear Taylor,

I am looking for the following functions.
In lookup/reference function - MATCH, OFFSET, INDEX, ADDRESS
LOGICAL FUNCTIONS
STRING/MATHEMATICAL FUNCTION
DATABASE FUNCTION

Regards,




RE: Spreadsheet Functions in NX

Quote (nilanjana2012)

I am looking for the following functions.
In lookup/reference function - MATCH, OFFSET, INDEX, ADDRESS
LOGICAL FUNCTIONS
STRING/MATHEMATICAL FUNCTION
DATABASE FUNCTION

These are Excel functions; you can (and should) use them in the Excel spreadsheet. The "8" spreadsheet functions you refer to are mainly used to bridge between NX and Excel - to exchange information between the Excel sheet and the NX expression system. When working with Excel, you still have access to all of Excel's available functions.

www.nxjournaling.com

RE: Spreadsheet Functions in NX

nilanjana2012 --

So, there are a bunch of string functions and math functions available inside NX now... These are found very near the spreadsheet functions you've mentioned:





There are also some new spreadsheet functions in NX 9 that might be of interest. In particular, ug_read_list() and ug_read_fixed_list() are quite similar to the OFFSET and INDEX function you mentioned.

There is a position() function in KF that is very similar to MATCH, but the answer it returns when it can't find a match in the list doesn't play very well with expressions, so I always either formulate the problem differently (to use the nth() function, for instance) or make sure my logic and options are rock-solid. smile

For ADDRESS, I just use normal string operations to do this, because the cell references in the NX spreadsheet functions are just strings. And you can concatenate strings with the "plus" operator like this:

row = "12"
column = "C"
address = column + row = "C12" 

As for logical functions... While Excel uses functions for logical operations, NX uses key words and/or operators within expression formulas. For instance, you would set up the basic if-then-else pattern like this:

if (height >= 12) then (6) else (2) 

...and you can build up more complex statements using the "pipe" symbol (|) to represent "or" and the "ampersand" symbol (&) to represent "and", like this:

if ( ( (height > 12) & (height <= 48) ) | (width < 1) ) then (6) else (2) 

...or...

if ( ( (height > 12) & (height <= 48) ) ) then (6) else if (width < 1) then (1) else (3) 

And you can get very creative with these logical statements, up to about 1000 characters. Customers do some amazing things here. smile

Does this help?

And as John mentions, you certainly have the option of adding to the function list, using a bit of Knowledge Fusion programming. (In fact, now that I think about it, the "rounding functions" and "tba_excel_calc" categories in the image above are both custom sets of functions.) Knowledge Fusion has some ODBC database access functionality that might be of use to you here, if that's really critical. And of course, once you make the leap into customization programming, you could also start to leverage .NET, Java, C++ etc. if needed.

I'm curious about the specific workflow you're trying to accomplish here, and/or the new DesignLogic functions you need to perform these things. Can you tell us more?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources