Page 1 of 1
lookup table
Posted: Tue Apr 10, 2018 4:08 pm
by sani
hello
please help me
My lookup function f multiplies only one constant in growth rate the variable
Re: lookup table
Posted: Tue Apr 10, 2018 5:53 pm
by Administrator
Given the numbers in the lookup, I think you need
growth rate = f ( time )
Is time (or year) the x axis in your lookup?
Re: lookup table
Posted: Tue Apr 10, 2018 6:02 pm
by sani
Yes x-axis is time and y-axis is GDP growth rate
Re: lookup table
Posted: Tue Apr 10, 2018 9:57 pm
by tomfid
To suppress units warnings you can make the x-input Time/Unit Time (where Unit time = 1 with whatever time unit you need). Then:
GDP Growth Rate = GDP Growth Lookup( Time/Unit Year ) ~ fraction/year
GDP Growth Lookup ... {table}
Unit Year = 1 ~ year
Re: lookup table
Posted: Wed Apr 11, 2018 2:06 pm
by sani
Hello
thanks for your help.
I modify growth rate = f ( time ) and I change units, but I still have a problem!
Re: lookup table
Posted: Wed Apr 11, 2018 2:24 pm
by Administrator
Did you also change the time bounds of your model so it runs from 2016 onwards?
Re: lookup table
Posted: Wed Apr 11, 2018 3:20 pm
by LAUJJL
Hi
A growth rate that dépends on time, looks Strange.
generally the growth rate dépends on the level, like a bank account with interests.
Regards.
JJ
Re: lookup table
Posted: Wed Apr 11, 2018 3:43 pm
by sani
Administrator wrote:Did you also change the time bounds of your model so it runs from 2016 onwards?
excuse me, How should I do this?
Re: lookup table
Posted: Wed Apr 11, 2018 3:59 pm
by tomfid
JJ - I think it's a terminology issue. In my suggested equations, "growth rate" refers to the fractional rate of increase, in units of fraction/year, as distinct from the actual growth that occurs, in $/year/year. So, the full equations might be:
Code: Select all
GDP = INTEG( GDP Growth, Initial GDP ) ~ $/year
GDP Growth = GDP * GDP Growth Rate ~ $/year/year
GDP Growth Rate = GDP Growth Lookup( Time/Unit Year ) ~ fraction/year
GDP Growth Lookup ... {table}
Unit Year = 1 ~ year
Re: lookup table
Posted: Wed Apr 11, 2018 4:50 pm
by sani
Thank you so much for your valuable guides.
Re: lookup table
Posted: Wed Apr 11, 2018 5:13 pm
by LAUJJL
Hi Tom
Your équations are mathematically correct (see model joined) but I was saying that a growth rate depending on time was economically not very realistic.
The growth rate is realistically more a constant like an interest rate , one of the run joined than growing linearly like the second run joined.
Regards.
JJ
Re: lookup table
Posted: Wed Apr 11, 2018 6:11 pm
by sani
Thank you for your all your help.
Re: lookup table
Posted: Wed Apr 11, 2018 6:23 pm
by tomfid
Indeed you are correct. A growth rate dependent on time might be convenient if you just want a GDP scenario as an input to a model of something else, but it isn't much if you're interested in modeling the economy itself.
Re: lookup table
Posted: Wed Apr 11, 2018 6:49 pm
by LAUJJL
Making a variable time dependant, is like inputing this variable as an external data.
Re: lookup table
Posted: Thu Apr 12, 2018 4:33 am
by sani
Despite all the changes and corrections, when I put the actual data about GDP growth along years in the lookup table, it seems that the output is still wrong.
GDP starts from zero point instead of 393.4 billion dollars!!
Re: lookup table
Posted: Thu Apr 12, 2018 7:02 am
by LAUJJL
Hi
Here is the model corrected, with a unit correction (the model has strictest unit testing set on) and the initial GDP set outside the GDP equation (best practice).
the llokup now starts from year 1 (2017) to year 2 (2018.
The model is in published format (vpm) downloadable with any Vensim version with the run growth 4 included.
Use the table tool to observe the GDP and not the Graph one where the the GDP looks like starting from 0.
Regards.
JJ
Re: lookup table
Posted: Thu Apr 12, 2018 8:56 am
by sani
Thank you so much.