Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Distribution by change in Date - Excel

2 replies [Last post]
Sun, 2024-09-01 17:55
Jithin Kambhikanam
User offline. Last seen 8 weeks 2 days ago. Offline
Joined: 22 Mar 2011
Posts: 200
Groups: GPC Qatar, Petro-Chem / Oil & Gas, Planning, Claims & Contracting, TURNAROUND & SHUTDOWN (T/A & S/D)

Hello Team,

Need your support in solving a proble. I have made a table with start date (A) and Finish date (B), The total Quantity (C) is divided by the durtation to give the per day quantity (D). Now I have per month cut of date (E, F, G, H).

Can anyone propose a formula for E. F, G, H, where the quantity would change when I change the start (A2) and finish (B2) based on the date in E2, F2, G2 and H2.

8827
quantity.png

Top

Replies

Tue, 2024-09-24 03:57
#1
Jithin Kambhikanam
User offline. Last seen 8 weeks 2 days ago. Offline
Joined: 22 Mar 2011
Posts: 200
Groups: GPC Qatar, Petro-Chem / Oil & Gas, Planning, Claims & Contracting, TURNAROUND & SHUTDOWN (T/A & S/D)

Hi All,

Can I have few more ideas.

Like by changing the date it should automatically distribute the quantity per month.

 

Thanks

Jithin

Top
Tue, 2024-09-03 10:25
#2
benadjal redouane
User offline. Last seen 11 weeks 7 hours ago. Offline
Joined: 4 Nov 2018
Posts: 1
Groups: None

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/2024Total
Duration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 4
09/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/2025Total
Duration 1Qty 1Duration 2Qty 2Duration 3Qty 3Duration 4Qty 4
11/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)

Top