Vibration Data Management in Excel & Threshold Setting Guide

"I don't know how to utilize the collected CSV data." "I'm unsure how to determine the criteria (thresholds) for judging anomalies."
To solve such on-site issues, conanair provides free tools that can handle everything from daily trend management to precise frequency analysis. We will explain how to interpret specific data and how to utilize the Excel worksheets.

1. Simple Diagnosis Macro 1 (List Display & Threshold Management) and Usage

This is an Excel macro that displays a list of the latest vibration data collected from multiple measurement points, allowing you to grasp the health status of your equipment at a glance.
Targeting the latest data from each measurement point, it automatically color-codes the display on the screen into Blue (Normal), Yellow (Caution), and Red (Warning) based on the "thresholds" set by the user.

Now supports direct loading of raw data (.cna files)

With the latest version update, you can now directly load not only the automatically generated "CSV files" but also conanair's specific ".cna files".
As a result, even when targeting data files (.cna) measured and downloaded in manual mode, you no longer need to go through the trouble of converting them to CSV using the included app, allowing for immediate list display and judgment (In automatic mode, it loads the automatically generated CSV data as before).

"Recommended" Threshold Calculation Method

While there are absolute value indicators defined by ISO for determining anomalies, they often cannot be smoothly applied to on-site equipment. Therefore, the basic rule is to set the "trend data of your own equipment during normal operation" as the baseline.
To simplify management, basically use "Velocity RMS (3D composite value)" as the indicator and calculate using the following formulas:

• Caution (Yellow) threshold: 200% of normal
• Warning (Red) threshold: 400% to 500% of normal

Since the difference in quality may appear significantly in specific measurement directions, caution is necessary depending on the characteristics of your equipment.

How to Enter Data in Excel and Usage Image

Open the downloaded Excel file with macros, and enter the measurement points and the calculated thresholds. After that, automatic judgment is performed simply by importing the latest data (measurement points without set thresholds will remain clear).
Since numerous measurement points are managed collectively on the Excel file and the status of each machine is visually color-coded, it becomes easy to implement an operation that detects on-site "danger" in advance, such as checking only the red or yellow spots first thing in the morning, even without specialized knowledge.

2. Simple Diagnosis Macro 2 (Trend Graph Creation)

This is an Excel macro that loads multiple past data entries (CSV) from a specific measurement point and automatically creates a trend graph.
Its main purpose is report creation, and it is highly convenient when you want to observe differences in each measurement direction (X, Y, Z), RMS, or peak values.

The visual information of a line graph trending up or down, rather than just single numerical values, is extremely effective in catching signs of failure. You can also enter and save thresholds for "CAUTION" and "WARNING" from the settings field on the bottom right.
* We are currently transitioning this feature to a dedicated web browser application.

3. Precision Diagnosis App 3 (FFT@conanair)

This is a browser-exclusive application that performs frequency analysis via FFT (Fast Fourier Transform) and raw waveform graph display for a specific piece of measurement data. No software installation is required; you can use it simply by opening the extracted HTML file.

New Features and How to Use

• Envelope FFT: Bearing damage can be detected by applying envelope processing to the raw waveform and then performing an FFT.
• LF Accel. (Low Frequency Analysis): By excluding gravitational acceleration, peaks near 0Hz caused by posture changes during measurement are prevented, enabling analysis in lower frequency bands (10Hz or less).
• LPF (Low Pass Filter): Removes high-frequency noise signals to display clear low-frequency waveforms.

Experience Analysis with Sample Data

Sample data for verification is included with the app. Please load the "Normal (NORM)" and "Anomaly (oNG)" waveform data to actually experience how frequency peaks appear when an anomaly occurs.

Download Tools and Samples

You can download the various tools in ZIP format from the links below.

1. Download Simple Diagnosis Macro 1 (List Display & Threshold Management)
2. Download Simple Diagnosis Macro 2 (Trend Graph Creation)
3. Download Precision Diagnosis App 3 (FFT@conanair) and Sample Data
4. Download Reference Simple Diagnosis Macro Excel Sheet and Sample Data
   The reference file above includes sample CSV data for demonstration, allowing you to experience list displays and trend graphs. The "Simple Diagnosis Macro" includes a "Guide" sheet explaining everything step-by-step, from initial settings to importing data and reading results. Even if unfamiliar with Excel, simply following this guide lets you start trend management immediately. Please read the Guide sheet first after downloading.
   

Disclaimer and Support
The Excel macros and tools provided are offered as samples. Depending on your PC environment, Windows, or Excel versions, they may not operate correctly. Please utilize them with the understanding that we do not provide technical support for Excel tailored to individual user environments. However, if you have any questions regarding how to interpret data using these tools, setting "thresholds," or operational methods, we will provide advice as much as possible, so please feel free to contact us.

30-Day Free Trial & Inquiry

Try conanair for free for 30 days. Here is what our users are saying:

• Easy installation for immediate use
• No app required; operate via web browser
• No cloud required for fully automatic measurement
• Affordable, including dedicated software

Try equipment anomaly detection and predictive maintenance for free. Please feel free to contact us.

30-Day Free Trial & Inquiry

Try conanair for free for 30 days. Here is what our users are saying:

• Easy installation for immediate use
• No app required; operate via web browser
• No cloud required for fully automatic measurement
• Affordable, including dedicated software

Try equipment anomaly detection and predictive maintenance for free. Please feel free to contact us.

前のページ

Data Utilization Guide for Engineers: From CSV Export to Python Analysis

次のページ

Developer Story: A Vibration Sensor Built by Field Experts