Go on, I dare you; attach a sample workbook outlining the range of independent variables, and some samples of the 'different variants of the basic worksheet'.




You may find Switch between various sets of values by using scenarios useful where:
"A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results. If several people have specific information that you want to use in scenarios, you can collect the information in separate workbooks, and then merge the scenarios from the different workbooks into one.
After you have all the scenarios you need, you can create a scenario summary report that incorporates information from all the scenarios."