82
4-10. Pass/Fail evaluation and report of this test.
The log file data must be checked for each item.
The Excel test file “ESPTestReporter.xls” can check all of the items that are logged. This file has
a macro to load the data from the log data text (.txt) file.
The example above shows a test that failed because of no data.
The method to load the log data is below.
- Open the Excel test file, “ESPTestReporter.xls”. Be sure to click ENABLE MACROS when the
dialog box opens.
- Once the file is open, click on TOOLS / MACRO / MACROS. When the macro dialog box
opens, you should see a macro named “TestLogOpen”. Select this macro and click RUN. When
the File Open dialog box opens, browse to the location of the test text (.txt) file you created and
select it. Click OPEN. At this point the test data will automatically be loaded into the Excel sheet.
If the item is passed, the corresponded cell will be changed to TRUE.
If the item is failed, the corresponded cell will be kept to FALSE.
After loading , pass/fail will be summed to the RESULT cell.
The macro will default to a blank sheet after the results have been loaded. You must open the
.xls file that was created as a result of loading the test text (.txt) file. It will be the same name as
the .txt file with an .xls extension. Once you open this file in Excel you will be able to view the
results, PASS or FAIL, and view the parameters measured. All tests must be passed.
TEST PROCEDURES
To Next Page
Loading...
Need help?
General
