Step 1 - Collect all data and place it under the appropriate column heading
Step 2 - If you do not have data then leave the cells blank
Step 3 - For internal releases, ignore the column post release defect count
Step 4 - For external releases, count and enter the post release defect number
Limitations
1. Can be used for typical projects where only functional and regression is performed
2. In case of projects that need specialized testing, it would need tailoring or if all specialized test cases are counted as functional, would stil stand valid
3. No decimals allowed, round the values and enter the same
Note: Contact me if you need to add more columns into first sheet and generate metrics based on your needs.