How can I calculate time durations excluding scheduled down time?

Question

question

Jon Abbott asked Dec 12 2016 at 5:38 PM Jon Abbott commented Dec 15 2016 at 11:09 PM

How can I calculate time durations excluding scheduled down time?

I have a product being built with a span time that is currently being calculated by subtracting the start time from the finish time. This reports the number of minutes that have elapsed. I would like to adjust this calculation so that it excludes scheduled down time using a specified time table and/or MTBF/MTTR. Is this possible? I'm envisioning a command like the following:

timedelta(start_sim_time,finish_sim_time,[time table 1],[MTBF/MTTR 1],...)

This would behave similar to the NETWORKDAYS formula in Excel, except that it would return using the time units being used in the model. If something like this isn't available, is there another way to achieve the same result?

Software Version:

FlexSim 16.2.2

scheduled down time in system calculate times

______

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 · 2016-12-12T22:47:11Z

Joerg Vogel answered Dec 12 2016 at 10:47 PM Jon Abbott commented Dec 15 2016 at 11:09 PM

You can use the state pie chart. In its properties you can set the states you like to see or evaluated. If you explore the pie chart as a table you can compute the duration in your model run over all shown states.

· 3

Jon Abbott commented · Dec 12 2016 at 10:55 PM

Thanks @Jörg Vogel. I should explain my problem further, as I do not think the state pie would be sufficient. This model is for building a product that goes through multiple processes. I would like to measure the time that it takes for each product to go from the first process to the finish of the last process, excluding non-working (or scheduled down) time.

0 ·

Joerg Vogel Jon Abbott commented · Dec 14 2016 at 5:20 PM

If it is only the process and setup time you want to cumulate then you find these times in the variables of the items in the rank 2 and 3. You can increment an own label at every item in OnExit trigger of every processor.

processtime: getitemvar(item,2)

setup time : getitemvar(item,3)

Otherwise you can enhance the down-function and resume-function with the method to record the begin and end of a breakdown inside the involved item if it exists in the member object.

0 ·

Jon Abbott Joerg Vogel commented · Dec 15 2016 at 11:09 PM

Thank you @Jörg Vogel. I am not sure that the first approach will work, as sometimes the flowitems may be waiting in a queue that does not have process time or setup time, while the time table switches to a non-working time. I am not sure the second option works for the same reason - flowitems may be waiting in a queue that is not listed as a member of the schedule. I was hoping to be able to do this without resorting to lots of code or adjustments to the model. I may suggest the timedelta command as an idea for future versions of FlexSim.

0 ·

question