I am calculating some workload stats, to allow annual comparisons to be made across a number of metrics. If for one year the figures are only available for part of the year, I provide a prediction column. For example, for April, this is only one month and therefore I would calculate the number by 12 to get the prediction. If this were June, I would multiply by 4 as only 3 months have lapsed, and multiplying by 4 would provide a prediction for a year's workload completed.
How could I then calculate the average? If 5 full years have lapsed, then the average is
=AVERAGE(B2:F2)
However, if only 1 month has lapsed for the following year, how could I include this figure for the average calculation.
With one month, the time which has lapsed is 8.33% of the year. Does this then make the average the total of B2:G2/5.08, as the range refers to 5 full years plus 0.08 of a year?
How could I then calculate the average? If 5 full years have lapsed, then the average is
=AVERAGE(B2:F2)
However, if only 1 month has lapsed for the following year, how could I include this figure for the average calculation.
With one month, the time which has lapsed is 8.33% of the year. Does this then make the average the total of B2:G2/5.08, as the range refers to 5 full years plus 0.08 of a year?
