question

Ahmed H2 avatar image
0 Likes"
Ahmed H2 asked Jeff Nordgren commented

Enter schedule for separator to pull from by quantity

Hello,

How i make the six separators in my model to pull from the queues by certain quantity in each day like (day 1 : separator 1 pull 100, separator 2 pull 70 .....-day 2 : separator 1 pull 70, separator 2 pull 60,....and so on) as i have schedule for the separators in excel i want to import it and make the separators read from it how much each one will pull in each day.

trial3.fsm

FlexSim 18.2.2
pull from listpull strategyschedule
trial3.fsm (31.2 KiB)
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

tannerp avatar image tannerp commented ·

This can be done with Process Flow and lists. You would reference the tables to determine how many items to move from the Queues depending on the day. I updated half of your model to do this. I'm not sure it's exactly what you're looking for, but it might help spark an idea. Let us know if you'd like something different.

If you need additional help, you might consider uploading your Excel file. This might help us give you an example.

updated-trial3.fsm

0 Likes 0 ·
updated-trial3.fsm (40.6 KiB)
Ahmed H2 avatar image Ahmed H2 tannerp commented ·

@Tanner Poulton Thank you so much.

0 Likes 0 ·

1 Answer

Jeff Nordgren avatar image
0 Likes"
Jeff Nordgren answered Jeff Nordgren commented

@Ahmed H2,

Attached is your model with the changes that I've made. You didn't attach your Excel file so I don't know what that looks like. So, I created my own Excel file to use with this model, also attached. The Excel file is a simple one with 31 days and the 6 Separators with the production amounts. I only filled out day 1 just to make sure that it worked.

I added code in the OnModelReset trigger to set the day of the month to retrieve the production numbers. If the production number is zero for any Separator, it will not process anything. If you wanted to run all 31 days, you would probably do that in the Experimenter and increment the Global Variable "CurrDay" by one at the end of each replication. Otherwise, you would just need to change the value in the OnModelReset trigger for the day that you want to run processing for.

I also added an Excel import that is used to retrieve the amounts in your Excel spreadsheet and put them into a Global Table called "DailyProduction". The Separators will then look at the Global Table to determine how many flowitems to process.

I hope that all of this makes some sense. Look at the model and see if something like this would work for your situation. If it doesn't, please describe in a little more detail what needs to happen and be sure to include your Excel spreadsheet so that we can see how that should be imported. Just put the attached spreadsheet in the same folder as your model. It makes it a lot easier.

Thanks.

trial3-jn1.fsm

dailyproduction.xlsx


trial3-jn1.fsm (57.8 KiB)
· 9
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ahmed H2 avatar image Ahmed H2 commented ·

@Jeff Nordgren Thank you so much it worked perfect.

0 Likes 0 ·
Ahmed H2 avatar image Ahmed H2 Ahmed H2 commented ·

@Jeff Nordgren please i can't understand how to make it run for all the 31 days

0 Likes 0 ·
tannerp avatar image tannerp Ahmed H2 commented ·

Were you able to get it to work for 1 or 2 days? Where is your model getting stuck?

Additionally, if you're able to upload your Excel file or an example of it, that would help us, like @Jeff Nordgren mentioned. Right now, we don't know what numbers to work with.

1 Like 1 ·
Show more comments
Mariam R avatar image Mariam R commented ·

Hello @Jeff Nordgren,

Thanks for your help, we can now share with you our schedule, each day consists of 3 shifts, the unit of the target of each shift is ton, so the quantity shown in the excel sheet is ton/shift, each shift is 8 hours, i want to run this model for 60 shifts (continuously), and i need to make sure that each throughput (box) is in tonnes, so if the target of the first shift for the first line is 5 ton/shift, i'll find the racks 5 boxes.3-lines.xlsx08-03-19.fsm

Please let us know if you can help more :)

0 Likes 0 ·
3-lines.xlsx (9.6 KiB)
08-03-19.fsm (39.9 KiB)
tannerp avatar image tannerp Mariam R commented ·

Hi @Mariam R,

Since this question has an accepted answer, it might fall off our radar before additional comments get answered. If you need help quickly, I would suggest posting this as a new question so that more eyes will see it and it doesn't get lost. Otherwise, @Jeff Nordgren will hopefully see that he's been notified by your tagging him.

0 Likes 0 ·
Mariam R avatar image Mariam R tannerp commented ·

Hi @Tanner Poulton,

Thanks for your suggestions and care, i'll post it now as a new question.

0 Likes 0 ·
Mariam R avatar image Mariam R Mariam R commented ·

Hello @Jeff Nordgren ,

previously you've helped me with some modifications in my model "trial3-v1823-jn2.fsm" but i'm not able to open it in FlexSim 2016, is there anyway that i can convert it?

if not, can you please let me know how to do define "Current day"?

0 Likes 0 ·
Jeff Nordgren avatar image Jeff Nordgren Mariam R commented ·

@Mariam R,

As @Tanner Poulton has suggested, this appears to be another question that may be only somewhat related to the original question posted by @Ahmed H2. As such and because the answer to that question has already been accepted, you need to post your question as a NEW forum question. NOT a new question attached to this existing question. As Tanner also mention, by attaching a "new" question to an already accepted answer, it is more likely than not, to get lost and not get answered at all. That is why you need to create a NEW question in the forum.

But if I read your question correctly, I'm not sure what version the "trial3-v1823-jn2.fsm" model was created in but if it was more recent than than version 2016, it would not be compatible to try and save it to an older version. Never really heard of someone wanting to "convert" to a previous version. But FlexSim does not make models backward compatible, only forward compatible. So if you're trying to convert a model to a previous version of FlexSim, that will be on you to do it. You may find someone here on the forum willing to help you do that, for a price, but it won't be anyone here at FlexSim. My suggestion would be to upgrade the version of FlexSim that you have to the current version 2019.1.0. If you're not willing to do that, then you are on your own.

0 Likes 0 ·