Enter schedule for separator to pull from by quantity

Question

question

Ahmed H2 asked Feb 18 2019 at 10:20 AM Jeff Nordgren commented May 06 2019 at 11:00 PM

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

Software Version:

FlexSim 18.2.2

pull from list pull strategy schedule

trial3.fsm (31.2 KiB)

· 2

tannerp commented · Feb 18 2019 at 5:59 PM

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 ·

updated-trial3.fsm (40.6 KiB)

Ahmed H2 tannerp commented · Feb 19 2019 at 8:25 AM

@Tanner Poulton Thank you so much.

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2019-02-18T21:59:08Z

Jeff Nordgren answered Feb 18 2019 at 9:59 PM Jeff Nordgren commented May 06 2019 at 11:00 PM

@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)

dailyproduction.xlsx (8.9 KiB)

· 9

Ahmed H2 commented · Feb 19 2019 at 8:26 AM

@Jeff Nordgren Thank you so much it worked perfect.

0 ·

Ahmed H2 Ahmed H2 commented · Feb 19 2019 at 1:12 PM

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

0 ·

tannerp Ahmed H2 commented · Feb 22 2019 at 9:00 PM

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 ·

Show more comments

Mariam R commented · Mar 08 2019 at 9:24 PM

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.xlsx 08-03-19.fsm

Please let us know if you can help more :)

0 ·

3-lines.xlsx (9.6 KiB)

08-03-19.fsm (39.9 KiB)

tannerp Mariam R commented · Mar 08 2019 at 9:27 PM

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 ·

Mariam R tannerp commented · Mar 08 2019 at 9:44 PM

Hi @Tanner Poulton,

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

0 ·

Mariam R Mariam R commented · May 06 2019 at 9:57 PM

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 ·

Jeff Nordgren Mariam R commented · May 06 2019 at 11:00 PM

@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 ·

question