Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Moving scheduled work hours

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

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      pawelj795
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      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.