• 568 views | 5 messages Discussion: LEAP
    Topic: Question about InterpYearlyShape function Subscribe | Previous | Next
  • Tae Hyun Yoo 10/6/2016

    Like

    Dear Mr./Ms.

    I have a question about InterpYearlyShape function.

    The function accepts up to ten different year/shape pairs, but I need to put more yearlyshapes into the function(20 yearlyshapes!!).

    Is there any way to resolve this problem?

    Or, Is there any plan to extend InterpYearlyShape function?


    Thank you.


  • Emily Ghosh 10/6/2016
      Best Response

    Like

    Hello,

    If you would like to enter additional pairs, use LEAP's Interp function as follows:

    Interp(Year 1, YearlyShape(Shape 1), Year 2, YearlyShape(Shape 2) ... Year N, YearlyShape(Shape N))

    This leads to a slightly longer expression compared to using InterpYearlyShape, but does not have the same limitations.

    Hope this helps!
    Emily


  • Tae Hyun Yoo 10/10/2016
      Best Response

    Like

    Hi Emily,

    It helps a lot. We resolve the problem!

    Thank you.


  • Tae Hyun Yoo 11/17/2016
      Best Response

    Like

    Hi Emily,

    I have a problem about the results of two expression.

    1) InterpYearlyShape(2014,loadshape2014, 2015,loadshape2015)

    and,

    2) Interp(2014,YearlyShape(loadshape2014),2015,YearlyShape(loadshape2015))

    #2 shows wrong Load Factor(Please check with some examples). I think it can't replace the function "InterpYearlyshape".


  • Emily Ghosh 11/28/2016
      Best Response

    Like

    I apologize for the very delayed response. You are correct - there appears to be an error in the calculation of the Load Factor when the Interp function is used in lieu of InterpYearlyShape. We are currently looking into a solution and will let you know on this thread when the issue is resolved.

    Best regards,

    Emily