# Plating Bath Analysis and Additions Log Worksheet > Source: https://netray.co/tools/plating-bath-analysis-and-additions-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log bath analysis results with targets and control limits, compute deviation and out-of-range flags, and record additions for audit and Nadcap-style records. ## Category quality ## Industry Metal Finishing ## Audience - Plating line supervisor - Process chemist - Quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Date **Key:** date **Type:** date #### Tank **Key:** tank **Type:** text #### Bath type **Key:** bath **Type:** select **Options:** - Watts nickel - Acid copper - Acid zinc - Alkaline zinc - Hard chrome - Type II anodize - Electroless nickel #### Parameter **Key:** param **Type:** text #### Unit **Key:** unit **Type:** select **Options:** - g/L - oz/gal - ppm - pH - deg C - mL/L - % v/v #### Lower limit **Key:** low **Type:** number #### Target **Key:** target **Type:** number #### Upper limit **Key:** high **Type:** number #### Result **Key:** result **Type:** number #### Deviation from target **Key:** dev **Type:** number **Expr:** result - target **Format:** decimal #### Deviation (%) **Key:** devpct **Type:** number **Expr:** (result - target) / target * 100 **Format:** percent #### Out of range (1 = yes) **Key:** oor **Type:** number **Expr:** if(or(lt(result, low), gt(result, high)), 1, 0) **Format:** integer #### Addition made **Key:** addition **Type:** text #### Analyst **Key:** by **Type:** text **Rows:** **Date:** 2026-10-19 **Tank:** N-1 **Bath:** Watts nickel **Param:** Nickel sulfate **Unit:** g/L **Low:** 240 **Target:** 270 **High:** 300 **Result:** 252 **Addition:** Add 8 kg nickel sulfate **By:** JR **Date:** 2026-10-19 **Tank:** N-1 **Bath:** Watts nickel **Param:** Nickel chloride **Unit:** g/L **Low:** 30 **Target:** 45 **High:** 60 **Result:** 47 **Addition:** None **By:** JR **Date:** 2026-10-19 **Tank:** N-1 **Bath:** Watts nickel **Param:** Boric acid **Unit:** g/L **Low:** 30 **Target:** 40 **High:** 45 **Result:** 28 **Addition:** Add 5 kg boric acid **By:** JR **Date:** 2026-10-19 **Tank:** N-1 **Bath:** Watts nickel **Param:** pH **Unit:** pH **Low:** 3.5 **Target:** 4 **High:** 4.5 **Result:** 4.1 **Addition:** None **By:** JR **Date:** 2026-10-19 **Tank:** C-2 **Bath:** Acid copper **Param:** Copper sulfate **Unit:** g/L **Low:** 180 **Target:** 210 **High:** 240 **Result:** 214 **Addition:** None **By:** MK **Date:** 2026-10-19 **Tank:** C-2 **Bath:** Acid copper **Param:** Sulfuric acid **Unit:** g/L **Low:** 45 **Target:** 60 **High:** 75 **Result:** 78 **Addition:** Dilute with DI water **By:** MK **Date:** 2026-10-19 **Tank:** C-2 **Bath:** Acid copper **Param:** Chloride **Unit:** ppm **Low:** 40 **Target:** 60 **High:** 80 **Result:** 55 **Addition:** None **By:** MK **Totals:** #### Parameters out of range **Key:** oor **Agg:** sum **Format:** integer #### Analyses logged **Key:** result **Agg:** count **Format:** integer **Summary:** #### Out-of-range rate **Key:** oor_rate **Expr:** sum_oor / count * 100 **Format:** percent **Primary:** true #### Average absolute-signed deviation (%) **Key:** avg_dev **Expr:** avg_devpct **Format:** percent **Notes:** Targets and limits shown are typical textbook ranges for illustration. Use the limits in your bath supplier's data sheet and your controlled process specification. Keep the log with calibration status of titration or XRF equipment to support Nadcap or customer audits. ## Content **Intro:** A bath that drifts out of range produces rejects days before anyone notices. This worksheet records each analysis against target and control limits, computes deviation, flags out-of-range results and keeps the addition made, so the plating line has a complete chemistry record. **Sections:** #### How to use the log **Body:** Add a row for each parameter analyzed on each tank. Enter the lower limit, target and upper limit from the process specification, then the result. The sheet calculates the deviation and percent deviation from target and flags any result outside limits. Record the addition and analyst so the log supports traceability. The summary shows how many results were out of range and the overall rate, which is useful for trend reviews and audit evidence. **Bullets:** - Log one row per parameter per analysis - Copy limits from the controlled bath specification - Always record the addition quantity and the analyst - Review out-of-range counts weekly #### What to analyze and how often **Body:** Watts nickel typically tracks nickel metal or nickel sulfate, chloride, boric acid, pH and temperature, plus brighteners and contaminants by Hull cell. Acid copper tracks copper sulfate, sulfuric acid, chloride and organic additives. Alkaline and acid zinc baths track zinc metal, caustic or chloride and carriers. Frequency ranges from daily for critical baths to weekly for stable ones, and special process customers often specify it. Hull cell panels complement titration. #### Reading deviations and trends **Body:** A single reading out of range requires correction, but a series drifting toward a limit is the early warning. Percent deviation lets you compare parameters with different units. Repeated additions of the same component suggest dragout, evaporation or an analysis error. Use the exported data to build a control chart and set action limits tighter than specification limits. #### Common mistakes **Body:** Common failures are not recording the addition made, mixing units (g/L and oz/gal) in the same column, and copying limits from memory rather than the controlled specification. Another is analyzing right after an addition, which hides drift. Make sure titration glassware and reagents are calibrated and that the analyst initials every entry. **Cta:** If your chemistry results already sit in LIMS, lab spreadsheets or ERP quality records, we can help build a private assistant that flags drift and drafts addition recommendations for review. **Faq:** #### What should a plating bath log include? **Answer:** Date, tank, parameter, unit, target and limits, result, the addition made, and who analyzed it. Include temperature, pH and Hull cell results where relevant. Records should be legible, dated and retained as the customer or Nadcap requires. #### How often should plating baths be analyzed? **Answer:** Frequency depends on production volume and the process specification. High-volume or critical baths are commonly analyzed daily or every shift, and low-volume baths weekly. Follow the customer's specification and the supplier's recommendation. #### What is a Hull cell used for? **Answer:** A Hull cell is a small angled test cell that shows deposit appearance across a range of current densities in one panel. It helps judge brightener levels, contamination and bath condition in ways titration alone cannot. #### Are the default limits mandatory? **Answer:** No. The limits shown are illustrative typical ranges. Always use the limits in your supplier data sheet and your controlled process specification, which may differ by bath formulation and application. ## Search terms plating bath analysis log, plating tank log sheet, bath control chart template, watts nickel bath analysis, plating solution analysis record, bath additions log, nadcap plating records, plating chemistry log excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json