Excelquestion35
Board Regular
- Joined
- Nov 29, 2021
- Messages
- 53
- Office Version
- 2016
- Platform
- Windows
Hi all,
Currently dealing with what I thought would be easy to fix, yet seemed harder in reality.
For a forecast I have to calculate a date on which a move can be finished. The idea is as follows, we want to move 250 pallets a day for this specific move (either on a mon-fri or mon-sat workweek).
However, at the same time our outbound process of approximately 200 pallets a day will also continue.
The move can be started from the first of July next year, while the outbound process will continue all year long (in a mon-fri operation). Thus, at the start of the move already (11 * 200 pallets) have been moved.
Based on some volumes (between 0-12000 pallets, since 12000 is the capacity of the warehouse) that we want to move we want to calculate which date is feasible.
Now the date it is calculated solely on the 250 pallets that will be moved a day.
Any idea how I can incorporate the 11 days prior days into the formula and also the regular 5 day workload of 200 pallets?
The formula in column F is as follows:
I tried subtracting the 200 pallets a day in the roundup formula, but then I end up with dates even before the move has started..
Your help is much appreciated
Currently dealing with what I thought would be easy to fix, yet seemed harder in reality.
For a forecast I have to calculate a date on which a move can be finished. The idea is as follows, we want to move 250 pallets a day for this specific move (either on a mon-fri or mon-sat workweek).
However, at the same time our outbound process of approximately 200 pallets a day will also continue.
The move can be started from the first of July next year, while the outbound process will continue all year long (in a mon-fri operation). Thus, at the start of the move already (11 * 200 pallets) have been moved.
Based on some volumes (between 0-12000 pallets, since 12000 is the capacity of the warehouse) that we want to move we want to calculate which date is feasible.
Now the date it is calculated solely on the 250 pallets that will be moved a day.
Any idea how I can incorporate the 11 days prior days into the formula and also the regular 5 day workload of 200 pallets?
The formula in column F is as follows:
Excel Formula:
=WORKDAY($D$2,ROUNDUP(B7/$E$31,0))I tried subtracting the 200 pallets a day in the roundup formula, but then I end up with dates even before the move has started..
Your help is much appreciated
