interpolation of excel data

Use this forum to post Vensim related questions.
Post Reply
tbs14
Junior Member
Posts: 9
Joined: Wed Nov 04, 2009 1:57 am

interpolation of excel data

Post by tbs14 »

I have a variable 'scheduled production' for an annual production schedule that is made up using Excel data using the Get Xls data command. Then I have another function that is defined as IF THEN ELSE(price>production cost,production ahead,scheduled production). However at the time steps where the Excel data is missing, the software interpolates the value. Is there any way I can stop this because I would like to use the actual data only.

TQ
Administrator
Super Administrator
Posts: 4841
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

Search the help system for "Data equations" you will need to use one of these to do what you want.

Tony.
bob@vensim.com
Senior Member
Posts: 1107
Joined: Wed Mar 12, 2003 2:46 pm

Post by bob@vensim.com »

Use either :LOOK FORWARD: or :HOLD BACKWARD: in the equation for the data as in

my data :LOOK FORWARD: := GET XLS DATA...
tomfid
Administrator
Posts: 3995
Joined: Wed May 24, 2006 4:54 am

Post by tomfid »

You can also use the :RAW: pattern in your data, and then test for existence of data with IF THEN ELSE( myData = :NA:, ...
tbs14
Junior Member
Posts: 9
Joined: Wed Nov 04, 2009 1:57 am

Post by tbs14 »

Thanks for the feedback. I will try them out:)
Post Reply