# Patrol Inspection Round Worksheet > Source: https://netray.co/tools/patrol-inspection-round-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log timed patrol checks by station and characteristic, with limits entered once and an in-spec flag calculated per reading. ## Category quality ## Audience - Patrol inspector - Production supervisor - Quality technician ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Time **Key:** time **Type:** text #### Station **Key:** station **Type:** select **Options:** - CNC 1 - CNC 2 - Lathe 3 - Deburr - Assembly - Test #### Job / WO **Key:** job **Type:** text #### Characteristic **Key:** check **Type:** text #### Lower limit **Key:** lower **Type:** number #### Upper limit **Key:** upper **Type:** number #### Reading **Key:** reading **Type:** number #### In spec (1 = yes) **Key:** in_spec **Type:** number **Expr:** if(and(gte(reading, lower), lte(reading, upper)), 1, 0) **Format:** integer #### Distance to nearest limit **Key:** margin **Type:** number **Expr:** min(reading - lower, upper - reading) **Format:** decimal #### Action taken **Key:** action **Type:** text **Rows:** **Time:** 08:00 **Station:** CNC 1 **Job:** WO-55120 **Check:** Bore diameter **Lower:** 12.7 **Upper:** 12.725 **Reading:** 12.712 **Action:** None **Time:** 08:00 **Station:** CNC 2 **Job:** WO-55131 **Check:** Overall length **Lower:** 84.9 **Upper:** 85.1 **Reading:** 85.07 **Action:** None **Time:** 09:00 **Station:** CNC 1 **Job:** WO-55120 **Check:** Bore diameter **Lower:** 12.7 **Upper:** 12.725 **Reading:** 12.723 **Action:** Operator told, offset adjust **Time:** 09:00 **Station:** Lathe 3 **Job:** WO-55140 **Check:** Shaft OD **Lower:** 19.037 **Upper:** 19.063 **Reading:** 19.066 **Action:** Stopped, parts held **Totals:** #### Readings in spec **Key:** in_spec **Agg:** sum **Format:** integer #### Readings taken **Key:** time **Agg:** count **Format:** integer **Summary:** #### In-spec rate **Key:** in_spec_rate **Expr:** sum_in_spec / count * 100 **Format:** percent **Primary:** true **Notes:** A negative distance to nearest limit means the reading is out of tolerance. A small positive value is an early warning that the process is drifting toward a limit. ## Content **Intro:** Patrol inspection catches drift between first piece approval and final inspection. This worksheet gives patrol inspectors a structured round sheet that flags out-of-tolerance readings and shows how close in-spec readings are to a limit. **Sections:** #### How to use the round sheet **Body:** On each round, add a row per check: time, station, job number and characteristic. Enter the lower and upper limits from the control plan or inspection instruction, then the reading. The in-spec column returns 1 or 0, and the distance column shows how much room is left before the nearest limit. In the action column, record what was done: parts held, operator notified or offset adjusted. Export at the end of the shift for the quality file. #### Why distance to limit matters **Body:** A reading of 12.723 against an upper limit of 12.725 passes, but it leaves only 0.002 mm of room. Patrol records that only show pass or fail miss this. The distance column highlights drift early, so the inspector can ask for an offset adjustment before parts go out of tolerance. Many shops set an action line, for example at 75 percent of the tolerance, in the control plan. Use the distance column to apply it consistently. **Bullets:** - Negative distance means out of tolerance - Small positive values call for a conversation with the operator - Repeated small values on the same station suggest tool wear #### Fitting it to your control plan **Body:** Patrol frequency, sample size and characteristics should come from the process control plan, not from habit. Typical patterns are hourly checks or checks every set number of parts, with extra checks after tool changes, setups and breaks. List the key characteristics only, since too many checks per round leads to rushed readings. When a reading fails, the plan should state the reaction: stop, contain parts back to the last good check, and notify the supervisor. #### Common mistakes **Body:** Checking only the easy characteristics, backdating entries, and writing none in the action column when a reading was out of tolerance are the main failure modes. Containment must go back to the last good check, so the time column is essential. Do not overwrite a failed reading after adjustment, add a new row instead. If readings are consistently near one limit, review the process rather than relying on inspection to catch every escape. **Cta:** If patrol results are collected on paper and typed in later, Netray can help bring shop floor checks into your ERP or MES so containment can be traced by work order. **Faq:** #### How often should patrol inspection happen? **Answer:** As often as the control plan says. Common patterns are hourly or every fixed number of parts, with more frequent checks on unstable processes and after setup or tool changes. Base the frequency on process capability and the cost of escapes. #### What is the difference between patrol and in-process inspection? **Answer:** In-process inspection is checking during production in general. Patrol inspection is a roving inspector visiting stations on a schedule. Operator self-inspection is a third layer. The three work together under a control plan. #### What should I do after an out of spec reading? **Answer:** Stop the station, hold parts produced since the last good check, notify the supervisor, correct the cause and verify with a first piece check. Record the actions on the sheet and open a nonconformance if parts were affected. #### Can I add more than one limit set? **Answer:** Yes. Each row has its own lower and upper limit, so different characteristics and jobs can sit on the same sheet. Keep one sheet per shift or per line to stay readable. ## Search terms patrol inspection sheet, patrol inspection checklist excel, roving inspection log, in process inspection round sheet, patrol inspection format, line inspector log sheet, hourly inspection record, shop floor patrol check --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json