build vba script for sensitivity anaylsis

Hello to all!

For the past two weeks, I've been trying to learn VBA in order to finish this project. I've come to the realization that I clearly won't have the skills to finish it within the time constraint set-forth and am in dire need of help for the last part of the sheet..

What happens is that I need a way to display the outcome based on 8 different inputs in order to find the best possible settings for the 8 inputs.
If it was 2-3 variables I could of used the Data-Analysis package, but I can`t.
I tried the Solver-Analysis tool by setting up all the constraints although everytime I run it the results are very inconsistent even if I stretch the time allowed for processing.

Is there anybody who could please help me out in writing the script in order to do a proper sensitivity analysis?
I really appreciate you taken the time to read this..



*I've stripped the file as much as I can and ZIP`d it to fit within the size limit of 1mb*