Pull from a list based on sum of label values.

Question

question

Kari Payton asked Dec 18 2017 at 9:12 PM jing.c commented Dec 21 2017 at 4:52 AM

Pull from a list based on sum of label values.

I have a shipping truck that can only carry 8 tons. I have items on a list with label for the weight (last column). When I pull the items is there a way I can limit it to pull less than 8 tons in total?

Software Version:

FlexSim 17.2.3

process flow lists

wasteweighteample.png (48.1 KiB)

______

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 · 2017-12-18T21:50:27Z

Jordan Johnson answered Dec 18 2017 at 9:50 PM jing.c commented Dec 21 2017 at 4:52 AM

I don't know of a way to do that within the pull query. The closest thing I can think of is to put a Zone around the Push to List activity. You can use the Zone Subsets to limit the total label amount in the Zone, which will consequently limit the amount on the list.

zoneandlist-1.fsm

zoneandlist.png (15.5 KiB)

zoneandlist-1.fsm (21.1 KiB)

· 5

Kari Payton commented · Dec 20 2017 at 5:20 PM

@jordan.johnson

Well the item container can hold 20,000 kg so I can't limit the items pushed to the list. I can only limit the amount (kg) that can be pulled (5,000 kg)

0 ·

Kari Payton commented · Dec 20 2017 at 8:36 PM

@jordan.johnson I used the zone subset but also added preemption to push items to another list and pull only those items that were allowed to enter the zone. Probably made it more complicated than it had to be but it works. Anyway, thanks for the insight.

0 ·

jing.c commented · Dec 21 2017 at 2:13 AM

hi, @jordan.johnson

Would you please tell me what's meaning is the "1e12" in RequestNumber of Pull from List activity? I guess it means no limit token it will pull from the list, but I'm not sure~

0 ·

Jordan Johnson ♦♦ jing.c commented · Dec 21 2017 at 3:34 AM

FlexScript allows scientific notation. 1e12 is scientific notation for 1x10^12, making 1 trillion. I could also have typed 1000000000000. There isn't a magic number for pulling everything off the list, but 1e12 is so big that it usually works.

1 ·

jing.c Jordan Johnson ♦♦ commented · Dec 21 2017 at 4:52 AM

Many thanks~

0 ·

Answer 2 · 2017-12-20T12:27:27Z

Raja Sekaran answered Dec 20 2017 at 12:27 PM Kari Payton commented Dec 20 2017 at 9:37 PM

Hi @Kari Payton,

I have attached the sample models.

In the first attachment, Track the running total with the help of Track Number Fields Total.

Then add Expression field to the list and Track the Total Field Value(Weight).

In the List entries, the result of the expression field(CalculateTotalweight) will be like as the pic below.

Then, use the query in the Pull from the list as the pic below.

In the second attachment, I have used the SELECT clause to pulling the things from the list and also specify theTruck Capacity in the Request number and Require Number field. But It allows you to pull things from the list using fluid-like request quantities, instead of discrete entries on the list.

attachment-1.fsm

attachment-2.fsm

I hope this will help you.

Thanks

list-capture.png (16.7 KiB)

tracknumberfieldtotals.png (17.7 KiB)

listexpressionfield.png (15.1 KiB)

listentries.png (6.6 KiB)

query-from-list.png (14.3 KiB)

attachment-1.fsm (19.2 KiB)

attachment-2.fsm (23.1 KiB)

· 5

Kari Payton commented · Dec 20 2017 at 5:15 PM

@Raja Sekaran

I really appreciate your models and feedback. Really nice... They both work great on the first delivery. However, when I send the truck again to do a pickup I get errors.

In the second scenario, it works perfectly but I get an error because the items disappear if the truck only picks up some of the weight. For example it an item is 150 but the truck capacity is 100, there will be 50 left on the list. This is perfect but then on the list the item shows up as "0x0". Then on the next pickup, i get profiletasksequence error because the item has been deleted in the sink. I tried recycling flowitems in the sink but that doesn't work either.

In the first sceanio the calculation doesn't update when an item is taken off the list.

0 ·

Raja Sekaran Kari Payton commented · Dec 20 2017 at 5:58 PM

In the first attachment, In order update the total, I have removed the all entries from the list and re add it to the list again before pulling things from the list. You can find two activities (Remove from List and Re-add it to list) in the first attachment. These two activities will update the calculated value when you send the truck again for pickup.

0 ·

Kari Payton Raja Sekaran commented · Dec 20 2017 at 6:49 PM

@Raja Sekaran

Here's example of what's happening. I changed the weight to 5 to show it clearer.

It's correct here before the pulls.

After only 1 item is pulled. It doesn't update the calculated total weight.

0 ·

correctcalc.png (23.2 KiB)

wrongtotal.png (32.2 KiB)

Show more comments

question