View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
 
Posts: 70
Default Measuring Accuracy

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?

"Joel" wrote:

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.

"John Moore" wrote:

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 ?