Need help in supply chain production plan updation

Hello everyone,
This is a supply chain scenario wherein I need to change (upload) a new production schedule in excel format while the model is running with an existing schedule & withoutreset the model to see the changes. Is it possible ?
As per the market demand the productionschedule is expected to change frequently with no fixed timeline. How can Iincorporate this flexibility in the flexsim model without resettingthe running model. I tried using GUI but no success. Please suggest.
Regards,
Vivek

Hi,

Where do you have the production schedule? Is it a global table or something else? My answer below assumes that you have a global table where you have the data.

I am not sure if one can import an Excel table while the simulation is running. Probably if the model is stopped, then new data is loaded and then the model is started again. This should be possible using some code that stops the model and updates the data if the file is changed. Look into the excelimporttable function for reading the excel data in code.

If that does not work then at least you can create a function yourself that reads the data from a text file into a global table. We are using a function like this ourselves.

I am not sure about how to check if the file has been modified. Unless there is some function for it, you possibly you can read e.g. the first row where you have some number that changes for each iteration of the file. Then you would need to periodically check for changes. Unless you figure out some way for the Excel file to notify Flexsim when it has changed.

Hope this helps

Axel

Thank You Axel !!


Just found a way which solved my purpose. Need to stop the model first but without resetting the running model by linking the excel interface tool directly from current global table to my new excel file. Working for both arrival schedule as well as by global table.


Meanwhile as you said I will see if excelimport or similar function codes can help it change dynamically while the model is running even without stopping.


Thank You again


Regards
Vivek Dubey