Volume Allocation through time

[Karl Chalabala]

Hi -

Was hoping someone could help with the following.

Data is based on contracts with start and end date columns with specific volumes to be delivered each day and costs associated to do so.

The end date is in the future.

How do I calculate the intra-date volumes

I attached an excel version of one-line of the data table's basic structure.

 

Thank you,

Karl

[Gaia Paolini]

Hi

 

can you define what the intra-date volumes are Do you mean you want to calculate the total volume delivered to date, assuming that the same daily volume is delivered every day

 

If so, is the contract start date included in this count, and how do you handle weekends and public holidays

 

Gaia

[James Watts]

Or do you mean you want to create a record for each day of the contract