Page 1 of 1
interpolation of excel data
Posted: Wed Apr 21, 2010 2:32 am
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
Posted: Wed Apr 21, 2010 6:15 am
by Administrator
Search the help system for "Data equations" you will need to use one of these to do what you want.
Tony.
Posted: Wed Apr 21, 2010 9:06 am
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...
Posted: Wed Apr 21, 2010 1:20 pm
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:, ...
Posted: Wed Apr 21, 2010 11:22 pm
by tbs14
Thanks for the feedback. I will try them out:)