Spreadsheet functions
Spreadsheet functions
(OP)
Hi,
I have a problem with modeling spreadsheet. For example when I want to perform any mass calculation:
=MASS3D(SOLIDS,X,X) it says, that the expression contains error. Is there any reson for that? I think, that it should work and I have done it on another computer before and it worked.
Its version 4 and 5.
Thank you for help
Vit
I have a problem with modeling spreadsheet. For example when I want to perform any mass calculation:
=MASS3D(SOLIDS,X,X) it says, that the expression contains error. Is there any reson for that? I think, that it should work and I have done it on another computer before and it worked.
Its version 4 and 5.
Thank you for help
Vit





RE: Spreadsheet functions
John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
RE: Spreadsheet functions
Two possibilities that I can think of are that either it works in the spreadsheet or it works in the expressions editor. Not necessarily both.
If you're using Excel....?
That isn't any excel formula that I'm familiar with but maybe you can try just nominating the values and perorming that calculation in standalone Excel (i.e. without even starting NX). Then apply the same formula plugging in the field values passed to it when you launch from within NX.
Else....
Does the calculation work in the expressions without using a spreadsheet?
Best Regards
Hudson
RE: Spreadsheet functions
When you launch the Spreadsheet function from within Modeling, the version of Excel that you get will have added to it several special add-ons unique to NX including a function to extract the mass properties of a body so that you can include those values in a cell which can then be referenced however you wish. Go to the user Documentation and search on 'MASS3D'.
John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
RE: Spreadsheet functions
I have launched the modeling spreadsheet. I can extract the expressions, I can extract the attributes, but when I want to perform any mass calculation using mass3d function, it says, that there is an error in the expression.
Vit
RE: Spreadsheet functions
John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
RE: Spreadsheet functions
Vit
RE: Spreadsheet functions
Darned if i don't hate it when you solve your own problems just before providing the model. I'd love to see you example so I can still learn from it. I don't post this stuff for nothing you know I always want to learn from others experience.
Cheers
Hudson
RE: Spreadsheet functions
and in the dialog select "User defined" from the category dropdown list.