Giving time series data

Use this forum to post Vensim related questions.
Post Reply
sankee82
Member
Posts: 28
Joined: Mon Oct 01, 2018 5:56 pm
Vensim version: DSS

Giving time series data

Post by sankee82 »

I have given time series data as input to my variables. The data is annual in nature. I have set the time step to year in initial settings of the model. However when I am trying to plot the variable it is observed that the values are plotted with an interval of one month. How to rectify it?
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

You probably just need to change the unit for Time in Model>Settings>Time Bounds.

After you've done that, you should define and check all your other units.
sankee82
Member
Posts: 28
Joined: Mon Oct 01, 2018 5:56 pm
Vensim version: DSS

Re: Giving time series data

Post by sankee82 »

tomfid wrote: Tue Oct 02, 2018 9:36 pm You probably just need to change the unit for Time in Model>Settings>Time Bounds.

After you've done that, you should define and check all your other units.
I have already done it. Still the data is taken at a step of one month.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

Can you post the model & data, or a screenshot of a sample of each?
sankee82
Member
Posts: 28
Joined: Mon Oct 01, 2018 5:56 pm
Vensim version: DSS

Re: Giving time series data

Post by sankee82 »

tomfid wrote: Tue Oct 02, 2018 10:01 pm Can you post the model & data, or a screenshot of a sample of each?
I am attaching model, excel data and graph of one of the variable.
Attachments
potential_gwr.xlsx
(12.28 KiB) Downloaded 240 times
well water data.png
well water data.png (6.33 KiB) Viewed 6636 times
Vensim.pdf
(36.52 KiB) Downloaded 268 times
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

The Year column in your spreadsheet is not numeric, it's text. I'm not sure what Vensim is assuming about the time axis, because you haven't provided the equations or imported .vdf, but I'm guessing that if you fix the timing it will work.
sankee82
Member
Posts: 28
Joined: Mon Oct 01, 2018 5:56 pm
Vensim version: DSS

Re: Giving time series data

Post by sankee82 »

I am unable to understand how to use the imported data in writing equations involving time series. Can you please help me with it. I know this is very small thing to ask for, but as I am new to Vensim it is talking me a lot of time to figure out.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

This might be a good place to start: http://vensim.com/documentation/usr16.htm
JudeChen
Member
Posts: 20
Joined: Thu Jul 04, 2019 7:42 am
Vensim version: DSS

Re: Giving time series data

Post by JudeChen »

Hi,

If my Units for Time is set at Yearly, and my Time Step is at 0.0625, does Vensim read XLS data for time in the monthly or yearly manner here?

I am currently using the VensimDSS (S/N 9510), academic use license although it says VensimPLE on my profile.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

Vensim will be looking for time formatted as a decimal year.
JudeChen
Member
Posts: 20
Joined: Thu Jul 04, 2019 7:42 am
Vensim version: DSS

Re: Giving time series data

Post by JudeChen »

tomfid wrote: Wed Oct 09, 2019 5:22 pm Vensim will be looking for time formatted as a decimal year.
Okay. thanks! So should i input the info as based on monthly or yearly data?
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Giving time series data

Post by Administrator »

If your model runs in years, then input it as yearly data if you can as otherwise things can get confusing.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Giving time series data

Post by tomfid »

Are you talking about the units or granularity of the data? Generally it's always better to use the finest time scale you can, given the time step of the model.
Post Reply