[quote='joeu2004[_2_];1601597']<tippytoe wrote:
USG - stands for usage I assume
Columns I need explained a
M (Usg% Inc/Dec) what is being calculated in the formula
=IF((F2=0),((((H2*12)/I2)-F2)/1),(((H2*2)-F2)/F2))
N (New Inv Min) how and what is being calculated to come up with this #
=SUM((((K2/365)*12)*J2))*L2
O (New Inv Max) how and what is being calculated to come up with this #
=ROUNDUP(((N2*2)+0.1),0)

I hate to ask but have you ever used the moving average analysis in excel? I am new to the function and have no idea how it would works. I have all the data, would you be able to interpret and help me make the calculations?

this link expalins how it works but its for 2003 and i'm using 2010. http://office.microsoft.com/en-us/ex...001086480.aspx
Also, this is for 2003, anyone have any idea how I would use this function in 2010?

I've attached my 6 months worth of data. If there is anything else needed, please do not hesitate to ask.

Thank in advance. Tippy