ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Measuring Accuracy (https://www.excelbanter.com/excel-discussion-misc-queries/173220-measuring-accuracy.html)

John Moore

Measuring Accuracy
 
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 ?

joel

Measuring Accuracy
 
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 ?


John Moore

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 ?



All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com