Gain a Forecast through selected variables

[iain2003]

Hi All,

Unsure if anyone will be able to help with this but I will give it a go anyway:

I am looking to build an Access user application that will allow data to be entered in specific fields and then churn out a daily planning forecast of response activity.

Eg. Volume of activity entered (number), response rate (%) entered and sales conversion rate(%) entered along with an activity duration (start and end date/time) in order to give me a daily response volume and sales value. I am aware that I will require some form of 365 day calendar table in order to account for seasonality. And that I will require a calculations table to plug into the main user entry table in order to calculate my results. I am just missing the code method to plug link it all together.

Does anyone know of any useful threads or previous apps that could help me or any advice that could assist my programming?

Any help is greatly appreciated.

Thanks

 

[MichaelRed]

Given sufficient DATA, I'm sure that such a 'forcast' could be generated. Unfortunatly, the details provided are not, for me at least, anywhere near sufficient.





MichaelRed
mlred@verizon.net

 

[CajunCenturion]

You might want to research various regression and extrapolation algorithms. A google search using those two terms will provide a number of hits.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein