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.
Bookmarks