A coolant invoice tells you what the shop bought. A refractometer reading tells you something about a sample at a particular time. Neither, by itself, explains why one machine uses more concentrate or needs more maintenance than another.
Useful coolant data connects condition, additions, work performed and production output. Begin with a record that can answer one expensive question. If the question is why concentrate use is rising, record additions and output. If the question is repeated instability, connect readings with interventions and operating events.
Define the fields before choosing software
Use a machine or system identifier that stays the same across shifts. Record date and time, exact product, job or material, operating hours and the person making the entry. For a measured value, identify the instrument, scale and any conversion required by the product's method.
Keep raw measurements distinguishable from calculated values. A Brix reading is not automatically coolant concentration. If a factor is required, the record should make the factor and converted result traceable. For fluids needing component-specific analysis, a single refractometer value may be insufficient.
Log additions in actual units. “One bucket” is ambiguous unless the bucket's working volume is defined. “Top-up completed” omits the amount and composition needed to understand the subsequent change.
A compact record for a working machine
- Before the addition: fluid level, representative condition readings and relevant machine state.
- What entered: amount of premix, concentrate or water, plus the verified makeup condition.
- What changed: job, tool, filter, lubricant leak, cleaner use, repair or planned cleanout.
- What the machine produced: operating hours and accepted output for a comparable period.
- What followed: recheck, quality observation and whether the original issue returned.
Use blanks deliberately. “Not measured” is different from zero. Do not let a default zero imply that the machine consumed no fluid or had no operating hours. Where an estimate is unavoidable, identify it as an estimate so it cannot silently become a precision claim later.
Normalize before comparing machines
A high-use machine may simply do more work. Compare concentrate per productive hour, per repeated batch or per accepted part when those measures fit the process. Different materials and operations may need separate groups.
Illustrative example: machine A uses 8 gallons of concentrate over 160 operating hours, or 0.05 gallon per hour. Machine B uses 6 gallons over 80 hours, or 0.075 gallon per hour. Machine A uses more total concentrate but less per operating hour. That does not prove A is better: job mix, planned refills and losses still need review.
If both machines run a repeat job under comparable conditions, the difference becomes more useful. If one is a roughing cell with heavy chip removal and the other performs intermittent finishing, investigate them within their own operating context rather than assigning a simplistic league table.
Use a trend to form a testable hypothesis
A concentration rise accompanied by falling level suggests a different question from a falling concentration after every top-up. A sudden consumption jump after a conveyor change points to another investigation. The log helps identify timing; it does not establish the cause without a check.
Write the hypothesis in a form that can be tested: “The mixer output changed after the supply adjustment” is useful. “The coolant is bad” is not specific enough. Take the appropriate sample or inspect the relevant process, then record whether the evidence supported the hypothesis.
Do not delete an inconvenient outlier simply to make a trend look smooth. Flag instrument errors, unusual jobs and cleanout refills. Keep the original entry and the correction trail so another person can understand the result.
Reconcile the data with physical inventory
At the chosen review interval, compare concentrate issued with opening inventory plus receipts minus closing inventory, allowing for transfers, returns and documented losses. A material mismatch is a signal to improve the measurement or recordkeeping.
This reconciliation catches problems that a dashboard cannot solve on its own: a package moved to another department, an unlogged refill or different units in two records. Resolve those before calculating savings to two decimal places.
Purchasing history is still useful for cost and replenishment planning. It should be connected to the machine record, not mistaken for automatic machine monitoring. This article does not assume that a Tech Tool customer account provides sensors, usage alerts or an automated reorder system.
Choose automation around the decision
Commercial systems use different combinations of sensors, manual inputs and controls. The Turck central-fluid application illustrates an integrated installation. Zebra's Dazzle 2.e description distinguishes manually entered Brix readings from additional instrumentation. These are examples of different data architectures, not products claimed as part of Tech Tool's catalog.
Before investing, ask what is measured directly, what is calculated, how calibration is checked, who responds to exceptions and what happens when communication or a sensor fails. An automated record with an unreliable input can make a wrong decision more consistent.
Start with the minimum reliable dataset. If a manual record demonstrates a recurring mixing problem, it can justify evaluating equipment. If the main problem is a leaking machine lubricant system, additional data collection is unlikely to replace the repair.
Turn the record into a monthly action
- Check completeness and units before reviewing performance.
- Separate planned fills and unusual jobs from routine consumption.
- Identify the largest repeated loss or intervention.
- Assign one corrective action with a measurable expected result.
- Compare a suitable before-and-after interval and retain the evidence.
Use the coolant cost-per-part guide when converting the record into an economic comparison. Keep verified spending reductions separate from estimated recovered capacity.
Tech Tool carries the Coolant Refractometer for appropriate measurement workflows. Confirm suitability and the product-specific method. Share your Oemeta usage record with Tech Tool when you need help investigating the pattern or selecting the next practical control.
