Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
measuring plan in % with pie chart | Charts and Charting in Excel | |||
Measuring growth-how much did revenue increase using 12 months of | Excel Discussion (Misc queries) | |||
Measuring Average Changes | Excel Discussion (Misc queries) | |||
VBA - Measuring Time -subsecond | Excel Discussion (Misc queries) | |||
measuring historical volatility | Excel Discussion (Misc queries) |