Use spreadsheet formulas to gather info listed in .xlsx reports' "summary" tab

[Kristin Chuang]

[Background]
Most CE projects make use of the checkbox .xlsx report and use it as the final report delivered at the end of each test cycle.

However, there are times when QA needs to manually modify the test results listed in a checkbox .xlsx report's "test results" tab. These include appending results of manual runs that are not yet included inside checkbox, or correcting results that are incorrectly listed (due to various reasons such as a buggy test case or checkbox manual execution errors).

The numbers of passed/failed/skipped test cases listed in the "Summary" tab will cease to reflect the correct test status if this happens though, since the numbers in this tab are strings (collected and formatted directly from numbers calculated by checkbox when generating the report I assume) instead of formulas that dynamically output results based on the contents in the "test results" tab.

[Suggestion]
Use formulas in spreadsheet summary tab.
This way the numbers in the summary tab will always reflect the correct calculations.

An example of how the "summary" tab would be shown is attached in comment #1.
Note that contents in cells C5, C6, C7 & M3, M4, M5, M6 are all formulas.