How to set number of operator for each shift by Global Table?

Question

question

Yunjukuo asked Aug 13 2022 at 4:19 PM Fengjun0113 commented Aug 22 2022 at 12:54 AM

How to set number of operator for each shift by Global Table?

In this case, the operators are divided into day shifts and night shifts. The maximum number of operator in each shift is 5, so there should be a total of 10 operators in day and night shifts. But for the convenience of generating charts, I set 5 operators working for 24 hours in the model.

Day shift working hours: 7:00~19:00

Night shift work hours: 19:00~next day7:00

Each person has a rest time following the TimeTable setting.

I want to use GlobalTable to set the number of operator working in day shift and night shift. How can I do this in FlexSim?

In the table below, each row represents the day of the month, and each column represents which person is on the day shift or night shift. 1 means working, 0 means not working

For example, row "Day 5" column "Day OP_B" is 1 means operatorB must work on the 5th day of this month.

https://drive.google.com/file/d/1Mg577vHXRjEMAoagDcksjB-zONzXFCwA/view?usp=sharing

Software Version:

FlexSim 16.1.2

global table operator shift schedule

1660407402106.png (14.2 KiB)

· 3

Joerg Vogel commented · Aug 14 2022 at 7:25 AM

There exists already a timetable tool wherein you can choose down and uptime. And you can select members connected to this timetable.

PLEASE use this tool! It is always better to follow methods than inventing new one. If you want to replace timetables, then you setup for example a repeating user event, which loops through your table to stop or resume involved operators.

0 ·

Yunjukuo Joerg Vogel commented · Aug 14 2022 at 8:56 AM

Can you please demonstrate how to use TimeTable to achieve the function of the above situation? The daily rest time of each operator is fixed. The users of this model hope to have a function such as a table that can easily set staff shifts without changing member of TimeTable each time.

Or is there a code function/command to change the members of the TimeTable, so that I can put operator into the TimeTable that Shedule_Down all day according to the GlobalTable setting every shift.

0 ·

Andrew O commented · Aug 18 2022 at 6:41 PM

Hi @Yunjukuo, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

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 · 2022-08-15T07:39:47Z

Felix Möhlmann answered Aug 15 2022 at 7:39 AM Fengjun0113 commented Aug 22 2022 at 12:54 AM

What you could do is create a time table for each shift, with each operator being a member of both time tables. In the down/resume-function you can then add a condition based on the Shift table that controls if the operator is actually stopped or not.

Because this controls if the down time happens or not, the marked times in the time table are inverted: In the night shift table, the night hours are marked as inactive and vice versa.

The code below determines the correct row by reading the current date and converting the day into a number. To get the column it's probably easiest to just write those onto labels of the operators and read them from there.

Only if the shift is marked with a "0" in the table, will the condition evaluate to true and the operator will be stopped. Otherwise nothing happens and the operator remains active.

(In the screenshot I use the default "Stop Object" logic. You can also use other logic such as the "Travel To Object, Delay Until Down Time Complete". Just change the option before you edit the code and then enclose everything after the variable definitions (up to line 6) in the condition as seen above)

1660548986237.png (81.0 KiB)

1660549108270.png (5.0 KiB)

· 13

Fengjun0113 commented · Aug 20 2022 at 2:47 PM

Hi @Felix MöhlmannI tried to take reference of your code. But, According to the situation of this case, I chose "Travel To Delay Until Down Time Complete" instead of "Stop Object". However, I observed two unormal things. First, these two operators will go to "Rest" directly. Some of them should NOT go to "Rest" based on the setting in "Global Table-Shift". Second, for this case I think we should consider operators should work or not ("Global Table-Shift") then dicide these operators going to "Rest"(Time Table). But, your logic just consider operators going to "Rest" when they are in both "Down Time" and not work. Belows is the link of the model.

https://drive.google.com/file/d/1DKwubrQbJnRgqT4pSH7VATbpiNEhV1AW/view?usp=sharing

0 ·

1661006866519.png (839.3 KiB)

Felix Möhlmann Fengjun0113 commented · Aug 20 2022 at 4:21 PM

When reading the value from the the global table you set the name of the table as "shift" instead of "Shift". Because of this the command always returns 0 since no table with the given name exists. This then causes the down function to execute.

I don't quite understand what you mean by your second point. What you describe is functionally the same as what the time table is doing: At given points in time (when the down time starts) it checks if the operator works or not and sends them to "Rest" in the latter case.

In newer versions of FlexSim you could also do this with only a single time table that contains both shifts. But since in 16.1 the time table only supports increments of 5min, two down shifts that follow directly after each other would be merged into one.

You will always need a timed trigger to check whether the operator should start its down time or not. I believe using the down time of the time tables for this is convenient since all you need to do is to not run the default code depending on the value in the table. For example the time table automatically handles the case of the model starting during a shift, which you would have to account for separately in a custom logic.

If you think handling this logic from the time tables would be better, then you can of course set up a timer in a process flow that checks the value of the respective columns every 12 hours and runs the same code as the down function would, if the operator is supposed to be off shift.

0 ·

Fengjun0113 Felix Möhlmann commented · Aug 20 2022 at 5:07 PM

Thanks for your reply

For the first point, I edited "shift" to "Shift", but these operators still go to "Rest".

For seconf point, what I mean is I want operators go to "Rest" in two conditions. There are marked 0 in "Shift" and Down Time in Time Table. consider operators should work or not ("Global Table-Shift") then dicide these operators going to "Rest"(Time Table). But your logic makes operaors go to "Rest" go to "Rest" in only one condition which is marked 0 in "Shift" and Down Time in Time Table happened at the same time.

https://drive.google.com/file/d/1DKwubrQbJnRgqT4pSH7VATbpiNEhV1AW/view?usp=sharing

0 ·

Show more comments

question