interpolation of excel data

tbs14 · Post by **tbs14** » Wed Apr 21, 2010 2:32 am

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

Post by **Administrator** » Wed Apr 21, 2010 6:15 am

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

Tony.

bob@vensim.com · Post by **bob@vensim.com** » Wed Apr 21, 2010 9:06 am

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

my data :LOOK FORWARD: := GET XLS DATA...

Post by **tomfid** » Wed Apr 21, 2010 1:20 pm

You can also use the :RAW: pattern in your data, and then test for existence of data with IF THEN ELSE( myData = :NA:, ...

tbs14 · Post by **tbs14** » Wed Apr 21, 2010 11:22 pm

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