Measuring Accuracy

  • Thread starter Thread starter John Moore
  • Start date Start date
J

John Moore

Hi guys, I'm looking for a good way to meaure demand accuracy across a range
of products each month. Does anyone know of a good way to do this ?
 
Not sure what you are looking for. The formula is easy, arre you looking for
recommmendattions on how to setup the spreadsheet? Is the problem the "Range
of Products"?

Error = (Actual - Forecast)/Actual

Accuracy = 1 - Error.
 
Hi Joel, yeah, that is the formula I am using ,, and I have a format already
made up, but thanks for the offer. I was looking for any other ways of
measuring accuracy , are you awrae of anywhere that could help?
 
You must log in or register to reply here.

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

How to measure how much cell formula memory to be used? 2
Calculating forecast accuracy as a percentage 2
Time Accuracy 13
Percentage Accuracy 1
How to show % increase when accuracy decreases? 2
Max Value Across Worksheets Returning Sheet Name 2
Checking accuracy of multiple formulas 4
SumIf by Date? 12

Back
Top