Trying to minimize a non-continuous function that depends on data-validation lists

I can mount a brute force attack on the problem. You will have to add another sheet with some tables that hold parameters but I'll tell you how to do that. Then you can "re-attach" the missing sheets.

Basically, I am going to loop through all possible settings (everywhere you have a drop down). However I need to know where to look for the "answer." Would that be cell P47? If you think it worthwhile I could capture the data in P25:P47.

You could compress the file and attach it as a ZIP file.