Section 7.1. Using Spreadsheets for Tests

7.1. Using Spreadsheets for Tests

Fit tests can be easily created by using a spreadsheet. It can be convenient to use the spreadsheet to calculate some values, such as the calculated column values of a ColumnFixture table, instead of working them out by hand. To distinguish the Fit tables from other text within a spreadsheet, test tables have borders, as shown by the Excel spreadsheet TestDiscountGroups.xls in Figure 7.1.

Figure 7.1. Creating a Spreadsheet File with Excel

Once you've edited a spreadsheet and saved it, you can run Fit on it to get a report. If you're not a programmer, ask a programmer to set things up for you (as discussed in Chapter 26).

The report in the TestDiscountGroups.html file results from running Fit on the spreadsheet in Figure 7.1. Double-click on this file to view it through a browser. For example, the report resulting from the test in the spreadsheet in Figure 7.1 is shown in Figure 7.2.

Figure 7.2. Report from the Spreadsheet File in Figure 7.1

After changing and saving the spreadsheet, you will need to run the tests again. Then click the Refresh button on your browser to see the latest report.

Questions & Answers

Q1:	Can tables be placed anywhere on the spreadsheet?
A1:	Yes, although tables can't be placed side by side.