Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |