Formula for calculating Variance

  • Thread starter Thread starter Lori Lynn
  • Start date Start date
L

Lori Lynn

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?
 
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
 
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. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variance Calculations 2
excel formula 3
formula question 1
Pivot table and variance calculation 1
Problem with Calculated item in Pivot Table 1
Total percentages 2
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Access Group by precinct, calculate percentage of older voters 0

Back
Top