Moving scheduled work hours

[pawelj795]

Hi,
Below you can see two simple visualizations that show time demand to do some scheduled work.
Calculation is simply.
Time Demand = Sales QTY * Time per one qty

Now, I need to do 2 adjustments.

1. If the required work is overdue, then calculation must be move to do today.
Example: 60 hours of work were scheduled to do on 20 March. But it wasn't done.
I want to move these hours to be scheduled today.

2. As you see above, some work were scheduled on weekends.
I want also to move these work to do on Friday (before weekends).

Is it possible to do that?

Sample file:
https://drive.google.com/open?id=12utAiiyvjXBp2rOwAET79yDCHY4jclJM

[v-yingjl]

Hi @pawelj795 ,

To achieve these two requirements, it seems to be missing something about logic definition.

For example, what's the definition of overdue? Since 60 hours of work were scheduled to do on 20 March. But it wasn't done. How to define it like over 50 or something else?

In addition, what's the definition of moving these hours to be scheduled today? How to allocate the remaining time because there are three products in your dataset. If the previous day is always overdue, the work time will accumulate instead of just the weekends work time shows.

Best Regards,

Yingjie Li

[pawelj795]

@v-yingjl 
Hi, thanks for weighing in.
I'm aware that probably I didn't explain it very well.

1. Overdue -> I meant that if any work were scheduled before today (how many days elapsed don't really matter)

The point is if that work weren't done, it should be done asap, which means scheduled on today as a reminder.

2. Yes, I want to accumulate these hours.

Let me show a 2 simple examples.
1. Today is 24th April

In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 20th March 60 work hours were scheduled 
- On 4th April 30 work hours were scheduled
- On 24th April 10 work hours were scheduled

These hours weren't done!

If these work hours would be done then they would disappear by my SQL database.

Now, in my desired model I want to sum these hours, which means that on 24th April(today) I should have 100 work hours.

2. Example about weekends. (future)

Today is 24th April

In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 8th May 20 works hours were scheduled

- On 9th May 10 works hours were scheduled (Saturday)

- On 10th May 30 works hours were scheduled (Sunday)

In my desired model should be 60 works hours on 8th May (before the weekend).

I hope this would help you understand my problem.

[pawelj795]

anyone help?

[pawelj795]

up

[pawelj795]

Sample file

https://drive.google.com/open?id=12utAiiyvjXBp2rOwAET79yDCHY4jclJM

[pawelj795]

up