• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Robot Structural Analysis

    Reply
    Moderator
    Romanich
    Posts: 406
    Registered: ‎09-29-2009

    Spreadsheet Calculator 2012 - EVar function

    453 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: 2,752
    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
    Support Specialist
    Product Support
    Autodesk, Inc.

    Please use plain text.
    Moderator
    Romanich
    Posts: 406
    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: 2,752
    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.

    Please use plain text.
    Moderator
    Romanich
    Posts: 406
    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: 2,752
    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.

    Please use plain text.