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
interpolation of excel data
-
- Super Administrator
- Posts: 4841
- Joined: Wed Mar 05, 2003 3:10 am
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
You can also use the :RAW: pattern in your data, and then test for existence of data with IF THEN ELSE( myData = :NA:, ...
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/