Formula for calculating Variance
 

I need help with formulas to calculate the percentage of variance
between planned miles and actual miles driven by drivers at several
different locations. I am given the miles per location daily. I need
to calculate weekly percentage per location. Then YTD percentage per
local, then total for all locals, then YTD for all locals. Can someone
help me?


--
Lori Lynn
------------------------------------------------------------------------
Lori Lynn's Profile: http://www.excelforum.com/member.php...o&userid=25565
View this thread: http://www.excelforum.com/showthread...hreadid=389974

percentage of variance would be:

(actual miles-planned miles)/planned miles

Planned Actual Variance % Variance
100 115 15 15%
100 85 -15 -15%
100 100 0 0%


you can sum your weekly, monthly and year totals for each and apply the
same formula to all.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=389974

I thought I had it right - but in my YTD formula I had the cell
references switched. Thanks for your help. I was starting to doubt
myself. :)


--
Lori Lynn
------------------------------------------------------------------------
Lori Lynn's Profile: http://www.excelforum.com/member.php...o&userid=25565
View this thread: http://www.excelforum.com/showthread...hreadid=389974