Divide frequency over year

[elmalle]

Good day all,

I have customers that need to be picked up every few days, sometimes a large package and sometimes a small package, the type of package is known at the beginning of the year.

Is there a possibility to automatically divide this over the year?

For instance:
Client1: has at the beginning of each month a large package that needs to be picked up, in the meantime a resource package and a small package remains. With regard to transport, package major is important.
We have to pick up the packages every 8 days, weekends too.

I have 1 table with customer1 large / customer1 resource / customer1 small.

For this various customers with different frequencies.
I have the file on tab 1: the annual calendar to be distributed, tab 2: the customers with the packages and the frequencies.


Is it possible with a formula to divide this over the all days of next year?

I can not get it done
thanks in advance

dave

 

[elmalle]

A solution to divide in interval without de package type is a start, but i dont know how to do this.