Planning, Scheduling & Programming Discussion Member for 14 years 7 months Member for 14 years 7 months Submitted by jithin on Tue, 2024-09-24 05:57 Permalink Hi All,Can I have few more Hi All, Can I have few more ideas. Like by changing the date it should automatically distribute the quantity per month. Thanks Jithin Member for 7 years Member for 7 years Submitted by redouane on Tue, 2024-09-03 12:25 Permalink Hello, please find to Hello, please find to attached file. the quantity change when you change the start date and finish date and the dates in E2, F2, G2 and H2 change also. Your exemple: StartFinishDurationTotal QtyPer Day27/09/202425/10/202429/11/202427/12/2024TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 409/09/202427/12/2024110,0010009,0909090919,00172,72727328,00254,54545535,00318,18181828,00254,5454551000 Change date start and finish StartFinishDurationTotal QtyPer Day29/10/202426/11/202431/12/202425/02/2025TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 411/10/202425/02/2025138,0010007,2463768119,00137,68115928,00202,89855135,00253,62318856,00405,7971011000 if you need execl file please send me. my ID Email is: redouanebenadjel@gmail.com have a nice day. BENADJAL Redouane Project engineer (Algeria) Log in or register to post comments
Member for 14 years 7 months Member for 14 years 7 months Submitted by jithin on Tue, 2024-09-24 05:57 Permalink Hi All,Can I have few more Hi All, Can I have few more ideas. Like by changing the date it should automatically distribute the quantity per month. Thanks Jithin
Member for 7 years Member for 7 years Submitted by redouane on Tue, 2024-09-03 12:25 Permalink Hello, please find to Hello, please find to attached file. the quantity change when you change the start date and finish date and the dates in E2, F2, G2 and H2 change also. Your exemple: StartFinishDurationTotal QtyPer Day27/09/202425/10/202429/11/202427/12/2024TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 409/09/202427/12/2024110,0010009,0909090919,00172,72727328,00254,54545535,00318,18181828,00254,5454551000 Change date start and finish StartFinishDurationTotal QtyPer Day29/10/202426/11/202431/12/202425/02/2025TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 411/10/202425/02/2025138,0010007,2463768119,00137,68115928,00202,89855135,00253,62318856,00405,7971011000 if you need execl file please send me. my ID Email is: redouanebenadjel@gmail.com have a nice day. BENADJAL Redouane Project engineer (Algeria)
Member for
14 years 7 monthsHi All,Can I have few more
Hi All,
Can I have few more ideas.
Like by changing the date it should automatically distribute the quantity per month.
Thanks
Jithin
Member for
7 yearsHello, please find to
Hello, please find to attached file.
the quantity change when you change the start date and finish date and the dates in E2, F2, G2 and H2 change also.
Your exemple: StartFinishDurationTotal QtyPer Day27/09/202425/10/202429/11/202427/12/2024TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 409/09/202427/12/2024110,0010009,0909090919,00172,72727328,00254,54545535,00318,18181828,00254,5454551000 Change date start and finish StartFinishDurationTotal QtyPer Day29/10/202426/11/202431/12/202425/02/2025TotalDuration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 411/10/202425/02/2025138,0010007,2463768119,00137,68115928,00202,89855135,00253,62318856,00405,7971011000
if you need execl file please send me.
my ID Email is: redouanebenadjel@gmail.com
have a nice day.
BENADJAL Redouane
Project engineer (Algeria)