Discussion Groups

Robot Structural Analysis

Reply
*Expert Elite* | International Moderator
Romanich
Posts: 563
Registered: ‎09-29-2009

Spreadsheet Calculator 2012 - EVar function

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

I try to make example from manual:

1.png

 

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 use plain text.
Product Support
Artur.Kosakowski
Posts: 4,736
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:

1.png

 

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
Please use plain text.
*Expert Elite* | International Moderator
Romanich
Posts: 563
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)  ? 

   
Please use plain text.
Product Support
Artur.Kosakowski
Posts: 4,736
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
Please use plain text.
*Expert Elite* | International Moderator
Romanich
Posts: 563
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.

   
Please use plain text.
Product Support
Artur.Kosakowski
Posts: 4,736
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
Please use plain text.