I have an Excel Sheet with information on tapping a furnace. The spreadsheet contains times (date, time) for the start of tapping and how long each bottling lasts.
What would be the best way to create a Vensim structure reads the spreadsheet and output 1 as long as a tapping is in progress and 0 when no tapping is in progress.
Discret function
Re: Discret function
Not sure what tapping a furnace really means, but there are at least two options:
1. Create data (excel side) with 0 or 1 at every time step, representing whether tapping is underway, and just read that into a data variable.
2. Create data with 1 only at the times where tapping occurs, then change the data interpolation pattern to :RAW:. Then you can write and auxiliary that tests IF THEN ELSE( data = :NA:, 0, data ). That will fill in 0s anywhere there isn't a 1.
Either way, you could import as vdf or use GET XLS.
1. Create data (excel side) with 0 or 1 at every time step, representing whether tapping is underway, and just read that into a data variable.
2. Create data with 1 only at the times where tapping occurs, then change the data interpolation pattern to :RAW:. Then you can write and auxiliary that tests IF THEN ELSE( data = :NA:, 0, data ). That will fill in 0s anywhere there isn't a 1.
Either way, you could import as vdf or use GET XLS.
/*
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
*/