In a Microsoft Excel window, click on File, then Open.
Make sure that the “Files of type” box is set to “All Files.”
To open the file in Excel, you will need to have saved it as a text file.
Choose the log file that you would like to open. It will have the extension .log.
The next window is the Text Import Wizard.
In this window, select Delimited, then click Next.
In the next window, deselect the Tab checkbox, then select Other and add the Pipe symbol (|).
Click the Next button to continue.
The final window in this text import wizard allows you to select the data format for each column.
This step is purely optional.
You may skip it and click on Finish.
You now see the converted log file in the main Excel window.
Using Excel’s various features, you can add further formatting to the file.
For example, if you wanted to make a chart to illustrate test results, you could do one such as this using Excel’s Chart Wizard.
The first step in creating this chart is instructing Excel to recognize and tally the test codes.
To do this, click on the cell you would like to contain the value of total passed tests, then click the Function icon.
Under the “Function category,” select “All.”
Under “Function name,” select “COUNTIF.”
This will bring up a new box for the Range and Criteria.
For Range, select all the codes in the first column.
To count Pass conditions, enter “800” in the Criteria box.
This counts the total number of PASSED test results recorded by SilverCreek in the journal log.
Repeat these steps twice more, substituting “801” and “808” in the criteria field to count the FAILED and WARNING test results, respectively.
The next step is to create the chart itself.
Select Chart from the menu or the Chart Wizard icon.
Select any chart type you wish, and click next.
For this example, Column/Clustered Column with a 3D visual effect was selected.
Under the Data Range tab, select the COUNT totals that you previously created.
Under the Series tab, highlight series 1.
Enter PASSED for the name, and select the count totals for PASSED tests.
Repeat for series 2, selecting count for FAILED, and series 3, selecting COUNT for WARNING.
Then select Next.
This step allows you to add more text to better describe your results.
You can add a name to your chart in the “Chart title” field.
If you browse through the other tabs in this step, you will find many options for adjusting the information displayed for your chart.
When you are done, click Finish to create your chart.
Want to Know More?
|Find more videos||How to buy||Contact an Expert|