Please provide assistance in the following example (attached):
DATA is collected from a historical database.
EXAMPLES (A,B,C) are particular sources that are most comparable to a new product.
TEST is an input/output table which supposedly takes existing EXAMPLES and DATA and forecasts for a given future year the result.
TITLE is a manually selected data validation cell referring to A, B, C.
YEAR is automatically recalled based on the information in TITLE.
COLOR is a manually selected category of TITLE which has a specific VALUE.
VALUE cell is automatically recalled based on the information in COLOR.
FORECAST is a manually selected future year.
MULTIPLIER is automatically returned as excel's forecasted calculation divided by the original YEAR.
ULTIMATE is automatically returned as the MULTIPLIER multiplied by the original VALUE.
In order to achieve an efficient model which can handle changing examples, which formulae should be used for the TEST tables?
Please bear in mind that if the database has a zero under our selection, we would require the first and nearest preceding or subsequent non-zero number (e.g. ORANGE 2006).
Thank you!
Bookmarks