# Design Review Comment Resolution Log Worksheet > Source: https://netray.co/tools/design-review-comment-resolution-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log every design review comment with severity, owner, response and due date, and see how many remain open. ## Category engineering-plm ## Industry Aerospace and Defense ## Audience - Design engineer - Systems engineer - Engineering manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Comment ID **Key:** id **Type:** text #### Document or drawing **Key:** item **Type:** text #### Reviewer **Key:** reviewer **Type:** text #### Comment **Key:** comment **Type:** text #### Severity **Key:** severity **Type:** select **Options:** - Critical - Major - Minor - Suggestion #### Owner **Key:** owner **Type:** text #### Response **Key:** response **Type:** select **Options:** - Accepted - Accepted with change - Rejected with reason - Needs discussion #### Due date **Key:** due **Type:** date #### Status **Key:** status **Type:** select **Options:** - Open - In work - Closed #### Weight **Key:** points **Type:** number **Help:** 3 critical, 2 major, 1 minor, 0 suggestion **Rows:** **Id:** DR-001 **Item:** GB3-2204-A Rev B **Reviewer:** Quality **Comment:** Datum scheme unclear for bore position **Severity:** Major **Owner:** S. Alvarez **Response:** Accepted with change **Due:** 2026-10-30 **Status:** In work **Points:** 2 **Id:** DR-002 **Item:** GB3-2204-A Rev B **Reviewer:** Manufacturing **Comment:** Internal corner radius too small for standard cutter **Severity:** Major **Owner:** S. Alvarez **Response:** Accepted with change **Due:** 2026-10-30 **Status:** Open **Points:** 2 **Id:** DR-003 **Item:** Gearbox thermal analysis **Reviewer:** Systems **Comment:** Ambient temperature assumption not stated **Severity:** Critical **Owner:** T. Nguyen **Response:** Needs discussion **Due:** 2026-10-28 **Status:** Open **Points:** 3 **Id:** DR-004 **Item:** BOM GB3-0001 **Reviewer:** Purchasing **Comment:** Single source on bearing; add alternate **Severity:** Minor **Owner:** M. Silva **Response:** Accepted **Due:** 2026-11-05 **Status:** Closed **Points:** 1 **Id:** DR-005 **Item:** Title block **Reviewer:** Document control **Comment:** Update drawing scale note **Severity:** Suggestion **Owner:** L. Okafor **Response:** Rejected with reason **Due:** 2026-11-05 **Status:** Closed **Points:** 0 **Totals:** #### Total comment weight **Key:** points **Agg:** sum **Format:** number #### Comments logged **Key:** id **Agg:** count **Format:** integer **Summary:** #### Average weight per comment **Key:** avg_weight **Expr:** sum_points / count **Format:** decimal **Notes:** Enter the weight by severity so the totals show how heavy the review was. Do not close a review gate while Critical or Major comments are Open. Keep rejected comments with a reason, since reviewers will ask why. ## Content **Intro:** A design review produces dozens of comments, and untracked comments return as defects. This log records each comment, who owns it, how it was answered and whether it is closed, so the gate decision rests on evidence. **Sections:** #### How to use the log **Body:** Number the comments as they are raised in the review. Capture the document, the reviewer, the comment itself and its severity. After the meeting, the owner chooses a response and a due date. Export to Excel and circulate it to reviewers so they can confirm closure. Close the review only when all critical and major comments are closed. **Bullets:** - Write comments as specific, actionable statements. - Always record a reason when a comment is rejected. - Use consistent severity definitions across reviews. - Ask the reviewer, not the owner, to confirm closure of critical items. #### Severity guidance **Body:** Critical means safety, regulatory or contractual non-compliance, or a failure of a key requirement. Major means a significant risk to function, cost or schedule. Minor is a clear defect without major consequence. Suggestion is an optional improvement. Agree these definitions before the review so debate does not eat the meeting. #### Where it fits in the process **Body:** Use the log at preliminary and critical design reviews, manufacturability reviews and drawing checks. The design review outputs feed engineering change requests when a released design must be altered. Standards such as AS9100 expect design reviews to be recorded and their actions followed up, and a log like this serves as that record. #### Common mistakes **Body:** Vague comments such as 'check this', no owner, and closing items without reviewer agreement are the main weaknesses. Another is mixing action items from the meeting with comments on documents; keep one log per review and separate lists for general actions. **Cta:** If review findings and change requests live in different places, we can help connect them to your PLM and ERP data. **Faq:** #### What is a comment resolution matrix? **Answer:** It is a table listing every review comment with the response and result. It shows that each comment was considered, answered and either implemented or rejected with a reason. #### Who closes a review comment? **Answer:** The reviewer who raised it should agree that the response is acceptable, especially for critical and major items. The owner proposes closure, the reviewer confirms. #### How many comments is normal? **Answer:** It varies by project size and maturity. A very low number can mean a shallow review, while a very high number may indicate immature design. Track trends across reviews instead of judging one count. #### Can I reuse the log for supplier design reviews? **Answer:** Yes. Add the supplier name to the document column or add a column for the company, then share the Excel export with the supplier. ## Search terms design review comment log, review comment resolution matrix excel, PDR CDR action item log, design review action tracker, comment resolution matrix template, engineering review findings log, design review issue tracker excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json