Autodesk Robot Structural Analysis
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I try to make example from manual:
But expression =EVar(_q*_L^2/8) returns 0. This function works only in this form: =EVar(_q)*EVar(_L)^2/8.
In addition, we have another bug: when I change value of q, for example, value in cell with Evar function return 0. Then, if I want to obtain the result, I go to Preferences, change any unit and press OK. In this case, the value will be updated.
Also I attached text file. Thanks.
Re: Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Romanich wrote:
I try to make example from manual:
EVar function works for a single registered cell only rather than for the whole expression. It searches for the registered in RESC cell and imports information about unit type converting it to the default unit. For the efficiency it is recommended to use EUToBase(...) function instead of EVar. EUToBase and EUToUser contain in their arguments all necessary information to convert values to the default units and vice versa to the display units.
It has to be remembered that each value in the expression has to be included in this formula so that EVar(-q*_l^2/8) is incorrect and is not supported.
But expression =EVar(_q*_L^2/8) returns 0. This function works only in this form: =EVar(_q)*EVar(_L)^2/8.
In addition, we have another bug: when I change value of q, for example, value in cell with Evar function return 0. Then, if I want to obtain the result, I go to Preferences, change any unit and press OK. In this case, the value will be updated.
Also I attached text file. Thanks.
Please try to use the EUToBase method instead.
If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Re: Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
=EUToBase(_q;"unit name")*EUToBase(_L;"unit name")^2/8
If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Re: Spreadshee t Calculator 2012 - EVar function
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
You can find the list of 'unit names' in 01units.cfg file (see the attached picture). In addition I'm attaching the modified xls.
If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.




