# Metal Detector Check Log Worksheet (Excel Export) > Source: https://netray.co/tools/metal-detector-check-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log metal detector test piece checks and rejects by line and shift, and see the reject rate calculated for each run. ## Category quality ## Industry Food and Beverage Manufacturing ## Audience - QA technician - Food safety manager - Line operator ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Date **Key:** date **Type:** date #### Line **Key:** line **Type:** text #### Shift **Key:** shift **Type:** select **Options:** - Day - Evening - Night #### Ferrous test **Key:** fe **Type:** select **Options:** - Pass - Fail #### Non-ferrous test **Key:** nfe **Type:** select **Options:** - Pass - Fail #### Stainless test **Key:** ss **Type:** select **Options:** - Pass - Fail #### Units checked **Key:** units **Type:** number **Format:** integer #### Rejects **Key:** rejects **Type:** number **Format:** integer #### Reject rate **Key:** rate **Type:** number **Expr:** if(gt(units,0), rejects / units * 100, 0) **Format:** percent #### Initials **Key:** initials **Type:** text **Rows:** **Date:** 2026-10-19 **Line:** Line 1 **Shift:** Day **Fe:** Pass **Nfe:** Pass **Ss:** Pass **Units:** 18400 **Rejects:** 3 **Initials:** RM **Date:** 2026-10-19 **Line:** Line 2 **Shift:** Day **Fe:** Pass **Nfe:** Pass **Ss:** Fail **Units:** 9200 **Rejects:** 11 **Initials:** SK **Date:** 2026-10-19 **Line:** Line 1 **Shift:** Evening **Fe:** Pass **Nfe:** Pass **Ss:** Pass **Units:** 17650 **Rejects:** 1 **Initials:** TL **Date:** 2026-10-19 **Line:** Line 3 **Shift:** Evening **Fe:** Pass **Nfe:** Pass **Ss:** Pass **Units:** 12100 **Rejects:** 0 **Initials:** TL **Totals:** #### Total units checked **Key:** units **Agg:** sum **Format:** integer #### Total rejects **Key:** rejects **Agg:** sum **Format:** integer **Summary:** #### Overall reject rate **Key:** overall_rate **Expr:** if(gt(sum_units,0), sum_rejects / sum_units * 100, 0) **Format:** percent **Primary:** true **Notes:** Record start-of-run, periodic and end-of-run test piece checks per your plan. Any failed test piece means product made since the last good check must be held and re-passed through a working detector. Use the test piece sizes in your own validated procedure. ## Content **Intro:** Metal detector and X-ray checks are a common control for physical hazards. This worksheet records test piece results per line and shift and calculates the reject rate so you can spot a drifting detector or a contamination source. **Sections:** #### How to use it **Body:** Add a row for each check event. Select pass or fail for the ferrous, non-ferrous and stainless test pieces, then enter units checked and rejects for the run. The reject rate calculates automatically, and the summary shows the combined rate for the sheet. If any test piece fails, record it, hold product from the last good check, and open a corrective action. Export to Excel for trending or to PDF for the HACCP file. **Bullets:** - Test at start up, at intervals, after changeovers and at end of run - Pass the test piece through at the product position the plan specifies - Confirm the reject device actually removes the test piece - Never reset sensitivity to make a test pass #### Reading the reject rate **Body:** Reject rate is rejects divided by units checked, multiplied by 100. A sudden jump on one line usually means a product effect, a sensitivity change or a real metal source upstream. A rate of exactly zero for months on a product with known signal effects may mean sensitivity is too low. Compare the rate across lines running the same product, and compare it by shift to see if a particular crew or maintenance event correlates. #### Where it fits **Body:** Metal detection is treated as a critical control point in some plants and a prerequisite control in others, depending on the hazard analysis. Either way, schemes like SQF and BRCGS and many customer codes expect documented test piece verification and a defined response to failure. Keep the record with calibration data for the detector and the retention period your customer requires. **Cta:** If your detectors export event data, we can help bring it into a dashboard with alerts for failed checks and drifting reject rates. **Faq:** #### How often should metal detectors be tested? **Answer:** At start of production, at set intervals during the run, after any changeover or adjustment, and at the end. Many sites test hourly or every few hours, and customer codes may set a minimum. Follow your plan and customer requirements. #### What if a test piece fails? **Answer:** Stop the line, hold all product made since the last successful test, correct the problem, verify the detector with all test pieces, and re-inspect held product. Record the event in a corrective action. #### Do I need ferrous, non-ferrous and stainless tests? **Answer:** Most plants test all three because each has different detectability, and stainless is the hardest. Your validation and hazard analysis decide the exact test pieces and sizes. #### Is X-ray different from a metal detector log? **Answer:** The record structure is similar, with test pieces of metal, glass, stone or plastic depending on the unit. Use the same columns and adapt the test labels for your equipment. ## Search terms metal detector check log, metal detector test record food, foreign material control log, metal detector verification form, fe nfe ss test piece log, metal detection ccp record, x-ray inspection log food --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json