Can someone please help me put a solution in place for this problem.

We are working on a new internal web-based database to help track our
customer's activities, billing, etc. We need to write scenarios for the
company that has been hired to develop it. This seems to be more of a legal
issue than a technical, but we want to make sure we cover ourselves. Here is
the situation:

We want to have the hired company test multiple fields to make sure we get
the desired end results. If we don't present a scenario, there is a
potential the company we hired can say that we didn't request such a
requirement from the application.

The variables are items, for example,such as what would happen if I entered
a space in 1 of the 15 fields. Would the application spend a mutliple amount
of time searching for a million records, or would it come back immediately
with an error? If we don't mention a scenario such as this, then we might
have to pay for a customization since we did not request it: again a legal
issue.

We could use Excel to help automate the mutliple scenarios that could result
and then enter what we anticipate should be the end result. This would be a
matter of taking various single scenarios (each one a cell) and merging them
together.

I am thinking about entering the following info in the cells:
Sheet 1: space, 1, and multiple number
Sheet 2: alpha, and numeric
Sheet 3: First name, last name, street address, city, state, zipcode, (etc)
Sheet 4: a combination of Sheet 1, sheet 2, and sheet 3 and their variations
Sheet 5 (possibly) a way of running a macro that would eliminate duplicated
scenarios in Sheet 4
Sheet 6 merging the cells in Sheet 5 to be our end product of what criteria
we need tested.

Any help or direction would be appreciated
Thanks