Page 1 of 1

Can I use TREND function to express a steady decrease of a variable over time

Posted: Sat Mar 18, 2023 2:46 pm
by ngtrang
I have a question:
Can I use TREND function to express a steady decrease of a varibale over time.
For example, I have a fraction variable of 0.8 per year. I want to decrease the value of this fraction variable over time at a rate of 0.5% each year within 10 years, for example.
Can I use TREND function instead of creating a stock and level?
Thank you.

Re: Can I use TREND function to express a steady decrease of a variable over time

Posted: Sat Mar 18, 2023 3:12 pm
by tomfid
No. The TREND calculates the fractional rate of change of a variable; it doesn't generate it.

In advanced versions (not PLE) you could write a macro to handle this behavior.

If the rate will not change during the simulation, you can use:

decayVar = initialValue*EXP(-decayRate*(Time-INITIAL TIME))
initialValue = 0.8
decayRate = 0.005

If the decayRate might change midway through the simulation, a stock-flow structure, or an equivalent macro, is really the only choice.

Re: Can I use TREND function to express a steady decrease of a variable over time

Posted: Mon Mar 20, 2023 11:52 am
by ngtrang
Thank you so much