Hi, I'm new to the forum but have used it many times to find solutions, and I posted this originally in the Off Topic area by mistake.

Here's my issue:

In my spreadsheet, I have effort hours for 1 month (no rolling history), Forecast hours and Actuals hours reported.

There are 3 categories (Work Type) for each section (Manager)

What's the best Variance formula when Actual could be either equal to, greater than, or less the than Forecast?

How do I calculate the Accuracy Percent for each Work Type?

I need to keep the result between 0% and 100%.

Then I need the Total of all 3 Work Types. Wouldn't it be a weighted average? Formula?

Sample attached. BTW, I'm using Excel 2010.

I've read many opinions and theories but since this is effort hours and not Grades, Financial, or Population; none seem to address this specifically so I'm hoping the good folks here can help.

Forecast HoursAccuracyPct.xlsx

I really appreciate any help/advise.