Discussion Groups

## Autodesk Robot Structural Analysis

Moderator
Posts: 411
Registered: ‎09-29-2009

# Spreadsheet Calculator 2012 - EVar function

455 Views, 5 Replies
08-22-2011 12:43 AM

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.﻿

Product Support
Posts: 2,769
Registered: ‎12-17-2010

# Re: Spreadsheet Calculator 2012 - EVar function

09-02-2011 06:37 AM in reply to: Romanich

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.﻿

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.

Moderator
Posts: 411
Registered: ‎09-29-2009

# Re: Spreadsheet Calculator 2012 - EVar function

09-02-2011 07:44 AM in reply to: Artur.Kosakowski

Thank you Artur. Syntax of the expression should be﻿﻿ =EUToBase﻿(_q*_L^2/8)﻿  ?

Product Support
Posts: 2,769
Registered: ‎12-17-2010

# Re: Spreadsheet Calculator 2012 - EVar function

09-06-2011 12:48 AM in reply to: Romanich

=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.

Moderator
Posts: 411
Registered: ‎09-29-2009

# Re: Spreadsheet Calculator 2012 - EVar function

09-06-2011 12:57 AM in reply to: Artur.Kosakowski

In "unit name" I have to manually enter ﻿units? Can you modify & attach my file from first post? Many thanks in advance﻿.

Product Support
Posts: 2,769
Registered: ‎12-17-2010

# Re: Spreadsheet Calculator 2012 - EVar function

09-06-2011 01:56 AM in reply to: Romanich

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.