Hi All ,
I need to generate a Shipping Schedule based on the below Info
Input Data
| project # | Project Name | Project Size | SCHEDULED SHIP DATE | Weekly Ship Rate |
| 959885 | XXXX | 81.3 | 04/27/2020 | 8 |
I am looking at generating date rows based on Reference date stated above with a Gap of 7 Days (as I need to generate Weekly Schedules) , however it should only generate based on below logic
If Project Size > Weekly Ship Rate then keep adding Date Rows with a gap of a Week until the Summation of Schedules does not exceed Project Size.
It is like generating Date Rows by adding a week to previous Row & also stating the Ship Schedule by ensuring the Ship schedule does not exceed Project Size.
Something like using the No. of Weeks like Division of (Project Size, Weekly Ship Rate) + 1 (if MOD(Project Size , Ship rate) <>0)
Desired Output is below :
| project # | Project Name | Project Size | SCHEDULED SHIP DATE | Ship Schedule |
| 959885 | XXXX | 81.3 | 04/27/2020 | 8 |
| 959885 | XXXX | 81.3 | 05/04/2020 | 8 |
| 959885 | XXXX | 81.3 | 05/11/2020 | 8 |
| 959885 | XXXX | 81.3 | 05/18/2020 | 8 |
| 959885 | XXXX | 81.3 | 05/25/2020 | 8 |
| 959885 | XXXX | 81.3 | 06/01/2020 | 8 |
| 959885 | XXXX | 81.3 | 06/08/2020 | 8 |
| 959885 | XXXX | 81.3 | 06/15/2020 | 8 |
| 959885 | XXXX | 81.3 | 06/22/2020 | 8 |
| 959885 | XXXX | 81.3 | 06/29/2020 | 8 |
| 959885 | XXXX | 81.3 | 07/06/2020 | 1.3 |
This is my first Post in the Community as I am a new User. Forgive me for any silly questions
