In my math class your example would equate to 30 units per day average. So
you need to clarify how you got to an average of 1.

"Cdn Gas Guy" wrote:

I have a list of contracts with daily volumes and dates which start and end
at various points over months/years organized in rows. Next to the this I
have columns for every calendar month moving years into the future. What I
need to do is have a formula to return the average contract volume applicable
to every given calendar month across the months.

ie. If the contract was for 30 units per day and the contract date started
Nov 30/07 then the average daily volume for Nov/07 would be 1 unit.

Any help will be greatly appreciated.

30 units per day for one day = 30 units. Divided by 30 days in November =
average 1 unit per day

"JLGWhiz" wrote:

In my math class your example would equate to 30 units per day average. So
you need to clarify how you got to an average of 1.

"Cdn Gas Guy" wrote:

I have a list of contracts with daily volumes and dates which start and end
at various points over months/years organized in rows. Next to the this I
have columns for every calendar month moving years into the future. What I
need to do is have a formula to return the average contract volume applicable
to every given calendar month across the months.

ie. If the contract was for 30 units per day and the contract date started
Nov 30/07 then the average daily volume for Nov/07 would be 1 unit.

Any help will be greatly appreciated.

30 units per day x 30 days = 900/30 = 30 units per day.
30 units per month @ 30 days in mo/30 = 1 unit per day.

Ending date per contract - Starting Date per contract = total time in days
Sum(Delivery by Contract)/total time in days = average units per day

The terminology needs to match the expected outcome or you will get some
erroneous answers.

"Cdn Gas Guy" wrote:

30 units per day for one day = 30 units. Divided by 30 days in November =
average 1 unit per day

"JLGWhiz" wrote:

In my math class your example would equate to 30 units per day average. So
you need to clarify how you got to an average of 1.

"Cdn Gas Guy" wrote:

I have a list of contracts with daily volumes and dates which start and end
at various points over months/years organized in rows. Next to the this I
have columns for every calendar month moving years into the future. What I
need to do is have a formula to return the average contract volume applicable
to every given calendar month across the months.

ie. If the contract was for 30 units per day and the contract date started
Nov 30/07 then the average daily volume for Nov/07 would be 1 unit.

Any help will be greatly appreciated.

Just to jump into this thread, I think JLGWhiz's comment centered around
this.... your original message said your contract started November 30th
which means your contract only had one day in it before the month ended...
30 units per day divided by the one day in the month your contract was
active for equals 30 units per day average.

Rick


"Cdn Gas Guy" wrote in message
...
30 units per day for one day = 30 units. Divided by 30 days in November =
average 1 unit per day

"JLGWhiz" wrote:

In my math class your example would equate to 30 units per day average.
So
you need to clarify how you got to an average of 1.

"Cdn Gas Guy" wrote:

I have a list of contracts with daily volumes and dates which start and
end
at various points over months/years organized in rows. Next to the this
I
have columns for every calendar month moving years into the future.
What I
need to do is have a formula to return the average contract volume
applicable
to every given calendar month across the months.

ie. If the contract was for 30 units per day and the contract date
started
Nov 30/07 then the average daily volume for Nov/07 would be 1 unit.

Any help will be greatly appreciated.