Interpolation

SarahE
SarahE
in Modeling

How can we do interpolation in Anaplan? 

I need to interpolate scores from the following criterias:

a. Min number with equivalent score

b. Max number with equivalent score

 

Thank you!

Tagged:

Answers

  • DavidSmith
    DavidSmith

    @SarahE 

    It would be worth publishing a worked example of what you are trying to achieve. 

    I, for one, am not sure what Interpolation is!

    David

     

  • Rashmih
    Rashmih

    Hi Sarah,

    @SarahE 

    Could you please provide examples in Excel for both the criterias...

    Thanks and regards,

    Rashmi

  • gdembla
    gdembla
    edited March 2024

    Hi @SarahE - Is this what you were looking for? https://gaurav-dembla.medium.com/anaplan-use-case-4-linear-interpolation-3d28b03987f8

  • JG1
    JG1

    Interpolation:
    You make 5k in a month, but is so far the 3rd week of the month, how much you have earned on a weekly basis?
    Since is 3 of 4 weeks, you have ~ 3/4 of 5k. That's a Linear interpolation
    or [InitialValue + (Days) x (FinalValue - InitialVaue)/(FinalDate - InitialDate)]
    or [ 0 x 21days x (5k -0)/(30days - 0)

    Let you calc things like the %of budget you should have cover by an specific date or Accrued costs, etc

Categories