G
Guest
I am trying to develop a series of excel commands to take data and project it
into the future.
The general idea is to have 5 or more sets of data that are all aging
differently, so over time the % decrease is different.
Here is an example:
existing count of installed is 40,000
this sample is decreasing by 8% per month
New sample ages at 24% first month, 18% second month, 12% third month, then
8 % therafter, after 8th month it decreases to 6%, then increases back to 8%.
I would want to create a macro that can tell what month of installation each
part of the sample is in and adjust it accordingly.
does this make sense? is it possible.
thx.
into the future.
The general idea is to have 5 or more sets of data that are all aging
differently, so over time the % decrease is different.
Here is an example:
existing count of installed is 40,000
this sample is decreasing by 8% per month
New sample ages at 24% first month, 18% second month, 12% third month, then
8 % therafter, after 8th month it decreases to 6%, then increases back to 8%.
I would want to create a macro that can tell what month of installation each
part of the sample is in and adjust it accordingly.
does this make sense? is it possible.
thx.