Dual-fiber digital intelligent dynamic power and vibration characteristic testing and analysis system for high-speed spindles

Abstract

A dual-fiber digital intelligent dynamic power and vibration characteristic testing and analysis system for high-speed spindles, belonging to the technical field of intelligent manufacturing. Provided is a dedicated device for the spectral analysis of digital intelligent dynamic power and vibration characteristics of high-speed spindles, integrating MCU-based dual-fiber ten-frequency-division laser fiber sensor pulse-width speed measurement, intelligent state recognition and multi-parameter big data dynamic high-speed real-time data acquisition with Python-based data visualization graphics processing, real-time dynamic data interpolation and intelligent state recognition measurement and control. The system is composed of modules such as a ten-frequency-division driven dynamic optical-fiber speed and power measurement mechanism, a vibration testing and adjustment mechanism and a spindle dynamic optical-fiber speed measurement mechanism, and uses a design enabling simultaneous speed increasing, sampling, data processing and visual plotting, integrated with multi-parameter big data and intelligent state recognition measurement and control to dynamically plot amplitude-frequency spectrum, torque spectrum and power spectrum dynamic characteristic curves of spindles in real time. The requirements of spindle design, R&D and manufacturing enterprises, industry research institutions, and metrology and testing authorities for evaluating dynamic characteristic parameters of spindles can be satisfied.

Description

High-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system TECHNICAL FIELD

[0001] The application belongs to the technical field of intelligent manufacturing, and is a high-speed spindle digital intelligent dynamic power vibration characteristic test analysis system, which is a special equipment for intelligent analysis and control of dynamic power test spectrum analysis and dynamic vibration test spectrum analysis of high-speed spindle test technology in the fields of frequency conversion driving, Modbus serial communication, double optical fiber pulse width speed measurement based on MCU, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition, data visualization graphical processing based on PYTNON, real-time dynamic data interpolation, intelligent state recognition measurement and control, high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage, and electromechanical integration technology. BACKGROUND

[0002] High-speed spindles are textile machinery special parts for high-speed rotation on textile spinning machines, and there are hundreds of millions of spindles in operation in China. With industrial upgrading and technological progress, the operating speed of spindles in textile enterprises has gradually increased from about 16000 rpm to 20000-22000 rpm, and the technical reserves of spindle manufacturing enterprises have reached 25000 rpm-30000 rpm. It is the pursuit of textile machinery manufacturing enterprises and textile enterprises to develop and adopt spindles with high-speed and super-high-speed adaptability, excellent vibration performance, wide and flat amplitude-frequency characteristics, long service life, and energy saving. Intelligent equipment faces the upgrading and transformation of traditional industries, including intelligent instruments and control systems, and intelligent special equipment, which can realize manufacturing process automation, intelligentization, and precision, and improve the level of equipment manufacturing technology. A once simultaneous evaluation of the energy consumption of a spindle and the X-axis and Y-axis bidirectional amplitude, the amplitude-frequency characteristics, frequency spectrum analysis, and vibration performance of the spindle, especially the dynamic test of the dynamic amplitude curve, dynamic spindle end axis trajectory curve, dynamic torque curve, and dynamic power curve of the spindle, are particularly important for objectively evaluating the power characteristics and vibration characteristics of the spindle, improving the design and production process of spindle special parts manufacturing enterprises, improving the digitalization, intelligentization, and mechatronics technology level of measurement and detection equipment, and providing optimal operation parameters for textile enterprises.

[0003] According to the latest "cotton spinning ring spindle" textile industry standard released by the Ministry of Industry and Information Technology, FZ / T92023-2017, single spindle power is measured by a single spindle torque instrument, and the empty spindle amplitude value is measured by an optical vibration meter. At present, the spindle power test equipment and spindle vibration meter test technology of the national textile machinery quality supervision and inspection center and spindle special part manufacturing enterprises were built in the 1970s and 1980s and have been used until now, and the technology has obviously fallen behind and is seriously unsuitable for modern manufacturing needs.

[0004] The industry spindle power test is static speed test (i.e. only one spindle speed torque, power measurement), nixie tube display, manual recording and operation, and need to be measured three times. The disadvantage is inefficient, time-consuming, poor accuracy. First measurement: load spindle belt, use the speed potentiometer to accelerate the drive motor, drive pulley through the spindle belt, drive spindle rotation, using flash speedometer to measure the spindle speed n, due to the spindle belt tension fluctuation, transmission efficiency and drive motor slip rate and other factors, will lead to the spindle speed n fluctuation, so, resulting in measurement personnel, can only roughly estimate the relative stability of the spindle speed n, at this time, also need to record the drive pulley speed s torque instrument display, but, the drive pulley speed s at this time is also not stable, also need to give the s estimate value; Second measurement: remove the spindle belt, use the speed potentiometer to accelerate the drive motor, make the drive pulley speed s accelerate to close to the first measurement of drive pulley speed s point near, but the drive pulley speed s fluctuation still exists, and, the torque value T under the drive pulley speed s, also in the fluctuation. At this time, the measurement personnel need to adjust the corresponding torque value of the drive pulley speed s to zero, the zero adjustment process needs to be repeated, and the value can only be fluctuated around zero; Third measurement: load the spindle belt again, use the speed potentiometer to accelerate the drive motor, make the drive pulley speed s accelerate to close to the first measurement of drive pulley speed s point near, and use the flash speedometer to check the spindle speed n, repeatedly compare the drive pulley speed s and spindle speed n value of two measurements, make the third measurement value close to the original first record value, record the torque T value at this time, since the second measurement has adjusted the drive pulley torque to near zero, then, the torque T and power P displayed by the torque instrument in the third measurement is the torque T and power P of the spindle itself.

[0005] From the single spindle torque meter error source, the measurement error mainly comes from the estimation of the drive pulley speed s and spindle speed n in three measurements, because the drive pulley speed s and spindle speed n are in fluctuation state at any time, and the measurement personnel cannot perform weighted average data processing operation in a short time, so that the synchronous relationship between the drive pulley speed s and spindle speed n in three measurements cannot be accurately corresponded. At the same time, when the second measurement, the torque value corresponding to the drive pulley speed s is adjusted to zero, it is also in fluctuation state. The zero drift of the third measurement after zero adjustment also exists objectively, so the asynchrony of the corresponding relationship between the drive pulley speed s, spindle speed n and torque T fluctuation and torque T zero drift cannot be eliminated or compensated by the measurement personnel like computer using real-time data processing method.

[0006] The above single spindle torque meter measures single spindle power method, manual debugging, artificial record calculation, because need to read a plurality of corresponding data, such as, first measurement, when artificial read spindle speed n, read drive pulley speed s parameter, spindle speed n has actually changed; Second measurement, when artificial read drive pulley speed s parameter, read torque T parameter, the previously read drive pulley speed s parameter has changed, that is, the real-time of artificial sampling is poor. There are repeated debugging, low precision, large drift, low efficiency, large system error, poor repeatability and stability of measurement results. Industry comparison test error is nearly 15%-20%, and it is impossible to provide spindle dynamic power curve (i.e. spindle power curve with spindle running speed change).

[0007] There are two methods for measuring the vibration amplitude of empty spindle in the industry: one is a portable spindle vibration meter developed in the 1970s, and the other is a yarn spindle vibration characteristic test analyzer developed in the late 1980s. The two test instruments are based on photoelectric amplitude measurement.

[0008] Portable spindle vibration meter: this vibration meter uses silicon photocell light shielding area comparison method, with the difference between the long and short axis diameters of the elliptical needle as the horizontal axis length, and the longitudinal height of the silicon photocell light window as the vertical axis. The light shielding area formed by the two changes during rotation, that is, the light flux changes. The light flux adjustment caused by the difference between the long and short axis diameters of the elliptical needle is the mv value of the corresponding silicon photocell, which is approximately used as the peak-to-peak value of the elliptical needle. The light flux size caused by the spindle amplitude is compared with the instrument nominal value, and the size of the spindle amplitude is measured, which is not the actual physical meaning of peak-to-peak value. The instrument can be simplified as an equivalent value of microns / millivolts, and the range is 2000mv of three and a half direct current voltmeter. It is not a smart instrument, without MCU microprocessor data sampling processing function, and data acquisition function cannot meet the sampling theorem requirements. For ordinary spindle speed 18000rpm spindle, its working frequency is 300Hz, according to the sampling theorem, the sampling frequency should be at least 600Hz or more, that is, the sampling period is 1.67ms, and the sampling time of this instrument is the refresh time of liquid crystal screen, about 400-600ms. Therefore, in actual engineering application, it is impossible to accurately capture the real-time peak-to-peak value at the actual working frequency.

[0009] Spindle vibration characteristic test analyzer: its basic principle is the same as the above-mentioned portable spindle vibration tester, which adopts the light shielding area comparison method of silicon photocell, that is, the change of light flux is sent to the computer for processing through AD conversion. The shortcomings are: due to the limitation of spindle design and production technology at that time, the actual running speed of the spindle is not high, the design of the highest running speed of the original spindle vibration characteristic analysis test equipment, the vibration-proof structure design of the test equipment at high speed and other technical conditions cannot meet the needs of the current high-speed and super-speed spindle research and development test analysis; and due to the limitation of software and hardware technology at that time (the host computer uses 386 microcomputer and 12-bit AD chip), the test precision is not high, the light flux is easily disturbed by external environment light, and the silicon photocell is used as the photoelectric conversion element, when the photocell is aged and the sensitivity is reduced, the measurement data is not accurate, the measurement system stability and repeatability are poor; the host computer software lacks filtering function, which cannot test and analyze the spindle vibration characteristics by using various modern advanced vibration analysis theories and models (such as adding various window functions); the frequency spectrum analysis function only has amplitude spectrum, lacks power spectrum and phase spectrum; there is no spindle speed-up time and sampling period setting function, so the relationship between spindle speed-up rate and spindle amplitude-frequency curve cannot be tested and analyzed, and there is no sampling period setting function, due to the limitation of memory, the maximum number of sampling points that can be tested in the rated test speed range is 32, and due to the small number of sampling points in a test period, the spindle speed-up vibration characteristic or spindle amplitude-frequency analysis function is poor.

[0010] For the foregoing single-spindle power and empty-spindle swing test technical solutions, the speed sensor plays a key role in the time domain range of measurement accuracy. The use of flash testers or speed measurement technologies that are not synchronized with the spindle speed n is a major defect or flaw.

[0011] In addition, there is also a dynamic virtual power tester and a dynamic virtual vibration test and analysis system solution. The former drives the speed from the frequency converter output, which is not the real-time speed of the driving pulley. Due to the existence of motor slip, the error is large, the synchronization between the driving speed and the actual measured spindle speed is poor, and the measurement result accuracy is seriously affected. Both the former and the latter use virtual instrument technology. Due to graphical language programming, the calling between different subprograms in actual application requires test delay time, and there is a process of converting graphical language to machine language, which has certain limitations for systems with high real-time dynamic measurement requirements.

[0012] In addition, there is also a defect that there is no function to adjust the spindle installation center height. For spindles with different installation heights, only the method of adding or subtracting shims can be used to solve the problem.

[0013] In summary, the current spindle power measurement and vibration measurement technology is obviously backward, inefficient, time-consuming and low in precision, and cannot meet the needs of the progress of the textile industry. There is no high-speed spindle dual-fiber digital intelligent dynamic power vibration characteristic test and analysis system in China that can simultaneously and synchronously measure the driving belt wheel speed s, the spindle speed n, the amplitude X, the amplitude Y, the XY axis synthesized amplitude, the spindle end axis trajectory, the torque T and the power P. SUMMARY

[0014] The purpose of the present application is to provide a high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage device that applies mechatronic technology to the field of high-speed spindle testing, and is capable of intelligent analysis and control of dynamic power test spectrum analysis and dynamic vibration test spectrum analysis, in order to meet the needs of fair, scientific, accurate, intelligent and efficient evaluation of the torque, power, amplitude-frequency characteristic and spectrum analysis of high-speed spindles at one time, especially the dynamic test and drawing of the amplitude-frequency spectrum of high-speed spindles, the dynamic amplitude curve, the dynamic spindle end axis trajectory curve, the torque spectrum, the dynamic torque curve, the power spectrum and the dynamic power curve, and the objective evaluation of the energy-saving performance, torque characteristic, power characteristic and vibration characteristic of high-speed spindles.

[0015] The purpose of the present application is achieved by a high-speed spindle dual-fiber digital intelligent dynamic power vibration characteristic test and analysis system, which comprises: a very frequent driving dynamic optical fiber speed measurement and power measurement mechanism, a very frequent driving dynamic optical fiber speed measurement and power measurement lifting mechanism, a spindle belt tension loading mechanism, a spindle installation and movement mechanism, a vibration test adjustment mechanism, a dynamic optical fiber speed measurement mechanism for spindles, a dual-fiber very frequent laser optical fiber sensor pulse width speed measurement module based on MCU, an intelligent state recognition module, a multi-parameter large data dynamic high-speed real-time data acquisition module, a PYTNON-based data visualization graphic processing module, a real-time dynamic data interpolation module, an intelligent state recognition and control module for high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display and storage modules, wherein:

[0016] The high-speed spindle dual-fiber digital intelligent dynamic power vibration characteristic test and analysis system adopts a dual-fiber laser optical fiber sensor, an X-axis eddy current sensor, a Y-axis eddy current sensor and a dynamic torque sensor to synchronously measure the driving speed s, the spindle speed n, the amplitude X, the amplitude Y, the torque T and the power P, and form one-to-one corresponding frame data.

[0017] The very frequency driving dynamic optical fiber speed measurement power mechanism is installed on the very frequency driving dynamic optical fiber speed measurement power lifting mechanism, the center line of the very frequency driving dynamic optical fiber speed measurement power lifting mechanism is parallel to the center line of the very frequency driving dynamic optical fiber speed measurement power mechanism, and the very frequency driving dynamic optical fiber speed measurement power lifting mechanism adjusts the center height of the very frequency driving dynamic optical fiber speed measurement power mechanism.

[0018] The very frequency driving dynamic optical fiber speed measurement power mechanism adopts laser fiber sensor pulse width speed measurement in two speed measurement channels of the spindle dynamic optical fiber speed measurement mechanism, and the driving rotation speed s and the spindle rotation speed n form a double-fiber synchronous speed measurement mode.

[0019] The very frequency driving dynamic optical fiber speed measurement power mechanism is installed on the very frequency driving dynamic optical fiber speed measurement power lifting mechanism, the center line of the very frequency driving dynamic optical fiber speed measurement power lifting mechanism is parallel to the center line of the very frequency driving dynamic optical fiber speed measurement power mechanism, and the very frequency driving dynamic optical fiber speed measurement power lifting mechanism adjusts the center height of the very frequency driving dynamic optical fiber speed measurement power mechanism.

[0020] The very frequency driving dynamic optical fiber speed measurement power mechanism is installed on the very frequency driving dynamic optical fiber speed measurement power lifting mechanism, the center line of the very frequency driving dynamic optical fiber speed measurement power lifting mechanism is parallel to the center line of the very frequency driving dynamic optical fiber speed measurement power mechanism, and the very frequency driving dynamic optical fiber speed measurement power lifting mechanism adjusts the center height of the very frequency driving dynamic optical fiber speed measurement power mechanism.

[0021] The driving rotation speed s laser rotation speed sensor takes the falling edge of the reflected laser pulse signal as the interrupt source of the MCU single-chip microcomputer INT0, and takes the interrupt period as the driving rotation speed s real-time rotation speed signal.

[0022] The dynamic torque sensor is connected with the frequency conversion motor through the lower diaphragm type coupling and connected with the very frequency driving pulley through the upper diaphragm type coupling and pulley shaft. The dynamic torque sensor, the lower diaphragm type coupling, the frequency conversion motor, the upper diaphragm type coupling, the pulley shaft and the very frequency driving pulley are axially centered on the same straight line.

[0023] Ten reflective color marks with the same width are equally divided on the very frequency driving pulley. When the very frequency driving pulley rotates one revolution, the output end of the laser rotation speed sensor outputs ten high and low levels, and the very frequency driving rotation speed s is 0.1 rpm.

[0024] The upper portion of the sub-multiple frequency driving pulley is provided with a driving speed measuring support plate, and the driving speed measuring support plate is provided with R2.5*10° long waist light inlet holes and R5*30° long waist light inlet holes at both ends of the corresponding sub-multiple frequency driving pulley reflective light color mark rotation track, so as to shield the light for the sub-multiple frequency driving pulley and avoid the interference of stray light.

[0025] The sub-multiple frequency driving pulley is connected with the measured spindle through the spindle tension loading mechanism and the upper delivery plate of the spindle installation movement mechanism, and drives the measured spindle to rotate.

[0026] The upper delivery plate of the spindle installation movement mechanism is provided with a vibration test adjustment mechanism, and the vibration test adjustment mechanism comprises a Z-axis lifting table, a Z-axis lifting table mounting seat, a Z-axis connecting seat, an upper measuring disc, a lower measuring disc, a sensor connecting seat, a sensor mounting sleeve, an X-axis eddy current sensor, a Y-axis eddy current sensor, an X-axis orthogonal displacement platform and a Y-axis orthogonal displacement platform, the axis of the Z-axis lifting table is parallel to the center line of the measured spindle, and the X-axis orthogonal displacement platform and the Y-axis orthogonal displacement platform are perpendicular to the center line of the measured spindle.

[0027] The X-axis eddy current sensor on the vibration test adjustment mechanism sends the measured real-time dynamic data to a MCU-based double-fiber sub-multiple frequency laser fiber sensor pulse width speed measuring, intelligent state recognition and multi-parameter large data dynamic high-speed real-time data acquisition module for processing, and the Y-axis eddy current sensor sends the measured real-time dynamic data to the MCU-based double-fiber sub-multiple frequency laser fiber sensor pulse width speed measuring, intelligent state recognition and multi-parameter large data dynamic high-speed real-time data acquisition module for processing.

[0028] The vibration test adjustment mechanism is provided with a spindle dynamic fiber speed measuring mechanism, the spindle dynamic fiber speed measuring mechanism is provided with a spindle speed n laser speed sensor composed of an E32-ZD200E spindle speed n speed measuring fiber and an E3X-DA21-S spindle speed n speed measuring fiber amplifier, the spindle speed n index value is 1 rpm, and the spindle speed n laser speed sensor sends the measured spindle speed n real-time dynamic data to a MCU-based double-fiber sub-multiple frequency laser fiber sensor pulse width speed measuring, intelligent state recognition and multi-parameter large data dynamic high-speed real-time data acquisition module for processing.

[0029] The spindle speed n laser speed sensor takes the falling edge of the reflected laser pulse signal as the interrupt source of an MCU single-chip microcomputer INT1, and takes the interrupt period as the spindle speed n real-time speed signal.

[0030] The MCU-based double-fiber sub-multiple frequency laser fiber sensor pulse width speed measuring, intelligent state recognition and multi-parameter large data dynamic high-speed real-time data acquisition module comprises an MCU single-chip microcomputer, an 8-channel 16-bit AD7606 module, a 2.7-inch OLED, a front panel and a rear panel.

[0031] The front panel is provided with load test display lamp, drive test display lamp, drive speed s display lamp, spindle speed n display lamp, sensitivity state steel display lamp, sensitivity state aluminum display lamp, sensitivity setting key.

[0032] The rear panel is provided with communication interface, torque T interface, drive speed s interface, spindle speed n interface, amplitude X interface, amplitude Y interface.

[0033] The X-axis eddy current sensor sends the measured real-time dynamic data to channel 1 of 8-channel 16-bit AD7606 module through amplitude X interface, the Y-axis eddy current sensor sends the measured real-time dynamic data to channel 2 of 8-channel 16-bit AD7606 module through amplitude Y interface, 8-channel 16-bit AD7606 module is set to 4 times oversampling (i.e. 4 samples are collected inside the hardware to average), MCU single-chip microcomputer continuously collects 40 samples of dynamic data of channel 1 and channel 2 (for each channel, it is equivalent to collecting 160 samples), arranges 40 samples in a queue, removes one maximum value and one minimum value, takes the next 5 values and the last 5 values, corresponds to subtraction, obtains 5 peak-to-peak values, takes the average value as the peak-to-peak value of the measurement point, amplitude X i , amplitude Y i ; the dynamic torque sensor sends the measured real-time dynamic data to channel 0 of 8-channel 16-bit AD7606 module through torque T interface, and the 4 times oversampling hardware average, the MCU single-chip microcomputer continuously collects 3 samples to average, as the torque value T i of the measurement point; the drive speed s laser speed sensor sends the measured drive speed s real-time dynamic data through the drive speed s interface, and sends the MCU single-chip microcomputer INT0 through level conversion, the MCU single-chip microcomputer continuously collects 4 falling edges and three pulse widths, calculates the average pulse width, and derives the average speed s value of 3 samples, as the real-time drive speed s of the measurement point; the spindle speed n laser speed sensor sends the measured spindle speed n real-time dynamic data through the spindle speed n interface, and sends the MCU single-chip microcomputer INT1 through level conversion, the MCU single-chip microcomputer continuously collects 4 falling edges and three pulse widths, calculates the average pulse width, and derives the average speed n value of 3 samples, as the real-time spindle speed n of the measurement point.

[0034] The MCU single-chip microcomputer is provided with a sensitivity setting subroutine, and the sensitivity setting key is built-in two key values, when the key value is 0, the material is steel, the sensitivity sk=10mv / μm, when the key value is 1, the material is aluminum, the sensitivity sk=13.8mv / μm, the selected sensitivity setting key value is saved in the MCU single-chip microcomputer ROM for calling, when the selected key value is 0, the sensitivity state steel display lamp is bright, indicating that the current measured spindle material is steel, when the selected key value is 1, the sensitivity state aluminum display lamp is bright, indicating that the current measured spindle material is aluminum.

[0035] The MCU single-chip microcomputer is provided with an intelligent state recognition subroutine. When the MCU single-chip microcomputer is powered on and initialized, if the driving speed s>10 and the spindle speed n<10, the 2.7-inch OLED displays "spindle driving performance test" in the first row, the driving speed s display light is on, indicating that only the drive pulley rotates, the driving test state display light is on, and the load test state display light is off, indicating that the system is currently in the "spindle driving performance test" state; if the driving speed s>10 and the spindle speed n>10, the 2.7-inch OLED displays "spindle load performance test" in the first row, the driving speed s display light is on, the spindle speed n display light is on, indicating that the drive pulley rotates, and the measured spindle also rotates, the driving test state display light is off, and the load test state display light is on, indicating that the system is currently in the "spindle load performance test" state; if the above two conditions are not met, i.e., the driving speed s<10 and the spindle speed n<10 (at this time, the timeout function is triggered, and the timeout time is set to 16.7 seconds, which is equivalent to the driving speed s<1 rpm, and the system sets the driving speed s to zero), the 2.7-inch OLED displays "spindle comprehensive performance test" in the first row, the driving speed s display light is off, the spindle speed n display light is off, indicating that the drive pulley stops rotating, and the measured spindle also stops rotating, the driving test state display light is off, and the load test state display light is off, indicating that the system is currently in the "spindle comprehensive performance test" state (i.e., standby state).

[0036] The MCU-based double-fiber high-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module is connected with the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON through the MCU single-chip microcomputer communication interface, using RS-485 and Modbus 8N2 for RTU serial communication protocol. The MCU single-chip microcomputer is provided with a serial communication subroutine, and the driving speed s, the spindle speed n, the amplitude X, the amplitude Y, the torque T, and the power P frame data dynamically collected in SBUF are stored. When the read command issued by the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON is received on the COM bus and the local address is consistent, the frame data in SBUF is returned to the COM bus.

[0037] The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control is composed of a communication parameter setting area, a spindle test parameter setting area, an amplitude-frequency spectrum dynamic curve visualization drawing window, a torque spectrum dynamic curve, a power spectrum dynamic curve visualization drawing window and its function keys, a function display window and a state display lamp to form a graphical user interface (GUI).

[0038] The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control is composed of intelligent data visualization graphic processing, real-time dynamic data interpolation and related programs, including: first load measurement data processing subprogram, secondary drive measurement and spindle characteristic parameter data processing subprogram, obtaining characteristic parameter report, storing original experimental data subprogram, intelligent data acquisition measurement and control subprogram, intelligent state recognition subprogram, intelligent automatic screen clearing subprogram.

[0039] The first load measurement data processing subprogram: set communication parameters, set spindle parameters, send write frequency command, frequency Frequency resolution 0.01 Hz; the frame data corresponding to the synchronous measurement of driving speed s, spindle speed n, amplitude X, amplitude Y, torque T and power P is interpolated by linear interpolation method with selected spindle speed n interpolation interval, and the interpolation interval is set to six levels ('50', '100', '200', '500', '1000'), with default '100'; receive / acquire data, data visualization drawing window (first load measurement point line graph red) draws four real-time dynamic curves of amplitude-frequency spectrum: X-axis amplitude, X-axis amplitude, XY-axis combined amplitude: Eccentricity i ,θ i ), eccentricity peak Phase angle Draw two real-time dynamic curves of torque spectrum of first load measurement: real-time dynamic torque T-drive speed s curve, real-time dynamic torque T-spindle speed n curve; draw two real-time dynamic curves of power spectrum of first load measurement: real-time dynamic power P-drive speed s curve, real-time dynamic power P-spindle speed n curve.

[0040] The secondary drive measurement and spindle characteristic parameter data processing subroutine: the frame data corresponding to the driving speed s, the spindle speed n = 0, the amplitude X = 0, the amplitude Y = 0, the torque T and the power P at this time are interpolated at the selected spindle speed n interval, the frame data is interpolated in real time by using the linear interpolation method, the data is received / captured, and the data visualization drawing window (the secondary drive measurement point line graph is blue, and the spindle characteristic parameter point line graph is brown) draws two real-time dynamic curves of the secondary drive measurement torque spectrum: the real-time dynamic torque T-driving speed s curve and the real-time dynamic torque T-spindle speed n curve; two real-time dynamic curves of the secondary drive measurement power spectrum are drawn: the real-time dynamic power P-driving speed s curve and the real-time dynamic power P-spindle speed n curve; the corresponding frame data after real-time interpolation of the first load measurement and the secondary drive measurement is subjected to difference value operation, the spindle characteristic parameter state display lamp is turned on at the same time, indicating that the current is in the spindle real-time characteristic parameter calculation state; the corresponding difference value operation frame data after real-time interpolation of the first load measurement and the secondary drive measurement is used to draw two real-time dynamic curves of the spindle characteristic parameter torque spectrum: the spindle real-time dynamic torque T-driving speed s curve and the spindle real-time dynamic torque T-spindle speed n curve; two real-time dynamic curves of the spindle characteristic parameter power spectrum are drawn: the spindle real-time dynamic power P-driving speed s curve and the spindle real-time dynamic power P-spindle speed n curve.

[0041] The acquisition characteristic parameter report and storage of original experimental data subroutine: when the secondary drive measurement is completed, the acquisition characteristic parameter report is clicked, and a WORD document can be generated: test file name, test time, and set test parameters; the entire data visualization window screenshot includes the first load measurement point line graph (red) generated according to the spindle speed N interpolation interval; the secondary drive measurement point line graph (blue); the spindle characteristic parameter point line graph (brown); the characteristic parameter data table generated according to the spindle speed N interpolation interval includes: the driving speed S corresponding to the spindle speed N, the load measurement torque T and power P, the secondary drive measurement torque T and power P, and the spindle torque T and power P; the storage of original experimental data is clicked, and an EXCEL table of real-time measurement data can be generated, including: the driving speed s, the spindle speed n, the X-axis amplitude, the Y-axis amplitude, the XY-axis combined amplitude, the axis center trajectory, the torque T, the power P, the measurement process attribute, and the measurement time point data.

[0042] The intelligent data acquisition and control subprogram: click the start data acquisition button, the program sends the read MCU data command: 050300000006C44C to the serial port, sends the write frequency converter forward operation control word: 0106200000120207, the frequency conversion motor starts operation, and receives the MCU return real-time driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, and power P frame data. When the first load measurement real-time spindle speed n≥set spindle speed N threshold is TRUE, it means that the first load measurement is completed, the first load measurement is ended, the read MCU data command: 050300000006C44C is stopped sending, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, and the frequency conversion motor stops operation. Otherwise, for FALSE, continue to send the read MCU data command: 050300000006C44C, continue data acquisition; when the secondary drive measurement real-time driving speed s≥set driving speed S threshold is TRUE, it means that the secondary drive measurement is completed, the secondary drive measurement is ended, the read MCU data command: 050300000006C44C is stopped sending, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, and the frequency conversion motor stops operation. Otherwise, for FALSE, continue to send the read MCU data command: 050300000006C44C, continue data acquisition.

[0043] The intelligent state recognition subprogram: when the spindle speed n<10 is TRUE, it is determined that the current is in the secondary drive measurement state, the secondary drive measurement state display light is on, and the first load measurement state display light is off; when the spindle speed n<10 is FALSE, it is determined that the current is in the first load measurement state, the first load measurement state display light is on, and the secondary drive measurement state display light is off.

[0044] The intelligent automatic screen clearing subprogram: when the secondary drive measurement is ended, the characteristic parameter report is obtained, the original experimental data is stored, and the next sample needs to be measured, in the spindle test parameter setting area, any change of a word can realize the emptying of the original measurement data and the point-line graph, setting a new file name, setting the spindle parameters, starting data acquisition, and entering a new round of load measurement process.

[0045] The serial communication of the application is connected with the variable frequency motor control and MCU single-chip microcomputer data acquisition, and the serial communication protocol of RS-485 and Modbus 8N2 for RTU is adopted to realize the communication with the frequency converter and the MCU single-chip microcomputer, intelligently and accurately control the start and stop of the variable frequency motor, the spindle speed setting, the transmission efficiency and the speed-up time, and the MCU single-chip microcomputer data acquisition reading, and ensure the consistency of the experimental conditions. The double-fiber laser fiber sensor, the X-axis eddy current sensor, the Y-axis eddy current sensor and the dynamic torque sensor are adopted to synchronously measure the driving speed s, the spindle speed n, the amplitude X, the amplitude Y, the torque T and the power P, and form one-to-one corresponding frame data. The high-precision sensor and the data acquisition and processing technology are adopted to ensure the accuracy of the measurement results, the double-fiber very high frequency laser fiber sensor pulse width speed measurement based on the MCU is adopted, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition design is adopted, the driving speed s is divided by 0.1 rpm, the spindle speed n is divided by 1 rpm, and the driving speed s measurement accuracy is 10 times higher than that of the current manual measurement technology; the remaining four parameters of the amplitude X, the amplitude Y, the torque T and the power P are processed in real time and synchronously according to the respective parameter data acquisition algorithm, and the actual precision is much higher than that of the current manual measurement precision. The edge speed-up, the edge sampling, the edge data processing, the edge data visualization drawing design are adopted to reach the setting of the spindle speed and the end of the dynamic sampling. For example, the default sampling period is 1000 ms, the speed-up time is 60 s, the interpolation interval is 100 rpm, the setting spindle speed is 20000 rpm, the first load measurement and the second driving measurement are adopted, and the measurement process of all the dynamic parameters of 200 spindle speed measurement points can be completed in 120 s, including the drawing of 16 dynamic curves. However, the current manual measurement needs to use multiple devices and takes at least ten to twenty times more time to complete the measurement of a few parameters of a spindle speed measurement point. Multi-parameter and data visualization: multi-parameter real-time dynamic data acquisition, synchronous acquisition of sensor data of up to 6 channels during the whole measurement process, real-time calculation of synthesized amplitude, axis trajectory and other key characteristic parameters, intuitive display of spindle vibration characteristics, synchronous generation and dynamic drawing of data visualization, amplitude spectrum 4 dynamic curves, torque spectrum 6 dynamic curves and power spectrum 6 dynamic curves, comprehensive capture of real-time running state of the spindle, clear display of the trend of amplitude, torque and power with the change of the spindle speed, and convenient intuitive comparison and analysis for users.Big data: compared with the current artificial measurement technology, once the vibration is measured, only the amplitude of one direction can be measured, several seconds are spent, repeated measurement is confirmed, and manual recording is required; when measuring power, a flash tester is manually used to measure spindle speed, torque T, power P data are manually measured repeatedly, four parameters of amplitude X, torque T, spindle speed n and power P under one spindle speed are measured through three stages of measurement process, and 12 data are manually recorded and calculated; in one sampling period (default 1000 ms), the application can collect driving speed s, spindle speed n signal data amount: 3x2=6, amplitude X, amplitude Y signal data amount: 4x40x2=320, torque T signal data amount: 4x3=12, power P signal data amount: 4x3=12, and the total collected signal data amount is 350; the default speed-up time is 60s, the whole measurement process is 120s, and the signal data amount that can be collected is 350x120=42000, which is 3500 times the signal data amount collected by artificial one rated spindle speed (42000 / (4x3)=3500); when the spindle speed N=20000rpm and the interpolation interval is 100rpm, 400 measurement point signal data amount: 350x400=140000 will be generated in the whole measurement process of 120s, which is 11667 times the signal data amount collected by artificial sampling (140000 / (4x3)=11667); here, the data amount derived from the synthetic amplitude, the spindle end trajectory and the related mean value, standard deviation statistical analysis is not included; in short, the current manual measurement technology collects data amount, which cannot be compared with the data amount collected by the application.Intelligent state recognition: MCU single-chip microcomputer and PYTNON-based host computer application program are respectively provided with intelligent state recognition subprogram, when driving speed s>10 and spindle speed n<10, front panel OLED first line displays "spindle drive performance test", driving speed s display light is bright, driving test state display light is bright, load test state display light is off, at the same time, host computer graphical user interface (GUI), secondary driving measurement state display light is bright, first load measurement state display light is off, indicating that the system is currently in "spindle drive performance test" state; when driving speed s>10 and spindle speed n>10, front panel OLED first line displays "spindle load performance test", driving speed s display light is bright, spindle speed n display light is bright, driving test state display light is off, load test state display light is bright, at the same time, host computer graphical user interface (GUI), first load measurement state display light is bright, secondary driving measurement state display light is off, indicating that the system is currently in "spindle load performance test" state; when driving speed s<10 and spindle speed n<10, front panel OLED first line displays "spindle comprehensive performance test", driving speed s display light is off, spindle speed n display light is off, driving test state display light is off, load test state display light is off, at the same time, host computer graphical user interface (GUI), secondary driving measurement state display light is off, first load measurement state display light is off, indicating that the system is currently in "spindle comprehensive performance test" state. Intelligent measurement and control: PYTNON host computer application program is provided with intelligent data acquisition and control subprogram, click start data acquisition button, program sends MCU data reading command to serial port, sends frequency converter forward operation control word, variable frequency motor starts operation, and receives MCU returned real-time driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, power P frame data. When first load measurement real-time spindle speed n is greater than or equal to set spindle speed N threshold, stop sending MCU data reading command, send write frequency converter stop operation control word to serial port, variable frequency motor stops operation, first load measurement is completed; when secondary driving measurement real-time driving speed s is greater than or equal to set driving speed S threshold, stop sending MCU data reading command, send write frequency converter stop operation control word to serial port, variable frequency motor stops operation, secondary driving measurement is completed. Automatically generate detailed experiment report, including experiment parameters, real-time screenshot and data table: provide all amplitude-frequency spectrum, torque spectrum, power spectrum all real-time original experiment data, and characteristic parameter report data and 16 dynamic curves after interpolation operation, including 4 dynamic curves in amplitude-frequency spectrum, 6 dynamic curves in torque spectrum, 6 dynamic curves in power spectrum, which is convenient for user to archive and share.Real-time: real-time data collection, analysis and display, helping users quickly grasp the running state of the spindle; ease of use: friendly graphical interface, simple and convenient operation, no professional knowledge is required; customizability: support for user-defined parameters and analysis indicators to meet different needs; real-time monitoring and feedback: real-time update of serial port status, device status and other information, and display on the interface. BRIEF DESCRIPTION OF DRAWINGS

[0046] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings in the embodiments of the present application are briefly introduced as follows.

[0047] Figure 1 is a mechanical part assembly drawing of a high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system disclosed by the embodiments of the present application.

[0048] Figure 2 is a top view of the mechanical part assembly drawing of the high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system.

[0049] Figure 3 is a K-view of the mechanical part assembly drawing of the high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system.

[0050] Figure 4 is a very frequency driving pulley drawing.

[0051] Figure 5 is a driving speed measurement support plate drawing.

[0052] Figure 6 is a driving speed measurement principle diagram.

[0053] Figure 7 is a spindle speed measurement principle diagram.

[0054] Figure 8 is a principle diagram of a double-fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU.

[0055] Figure 9 is a front panel drawing of a double-fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU.

[0056] Figure 10 is a rear panel drawing of a double-fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU.

[0057] Figure 11 is a block diagram of a high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system, wherein: the left part of the figure is a block diagram of a double-fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU, and the right part of the figure is a block diagram of a high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON for data visualization graphical processing, real-time dynamic data interpolation and intelligent state recognition control.

[0058] Figure 12 is a flow chart of the pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module of the MCU-based double-fiber quarter-wave laser fiber sensor, wherein the left part of the figure is a first load measurement intelligent state recognition data acquisition subprogram flow chart, and the right part of the figure is a secondary drive measurement intelligent state recognition data acquisition subprogram flow chart.

[0059] Figure 13 is a high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module flow chart based on PYTNON data visualization graphical processing, real-time dynamic data interpolation, and intelligent state recognition measurement and control, wherein the left part of the figure is a first load measurement data processing subprogram flow chart, the middle part of the figure is a secondary drive measurement and spindle characteristic parameter data processing subprogram flow chart, and the right part of the figure is a characteristic parameter report acquisition and original experimental data storage subprogram flow chart.

[0060] Figure 14 is a first load measurement characteristic curve of the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphical processing, real-time dynamic data interpolation, and intelligent state recognition measurement and control.

[0061] Figure 15 is a secondary drive measurement and spindle characteristic curve of the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphical processing, real-time dynamic data interpolation, and intelligent state recognition measurement and control. DETAILED DESCRIPTION

[0062] The technical solutions in the embodiments of the present application will be further described below with reference to the accompanying drawings in the embodiments of the present application.

[0063] The present application provides a high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system to meet the requirements of fair, scientific, accurate, intelligent, and efficient simultaneous evaluation of the torque, power, amplitude-frequency characteristic, and frequency spectrum analysis of a high-speed spindle, especially the dynamic test and drawing of the amplitude-frequency spectrum of a high-speed spindle, including the dynamic amplitude curve, dynamic spindle end shaft trajectory curve, torque spectrum dynamic torque curve, and power spectrum dynamic power curve, to objectively evaluate the energy-saving performance, torque characteristic, power characteristic, and vibration characteristic of a high-speed spindle.

[0064] A high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system mechanical assembly diagram is shown in Figure 1, which will be described below by parts, including:

[0065] The quarter-wave drive dynamic optical fiber speed measurement and power measurement mechanism, the quarter-wave drive dynamic optical fiber speed measurement and power measurement lifting mechanism, the spindle belt tension loading mechanism, the spindle installation movement mechanism, the vibration test adjustment mechanism, and the spindle dynamic optical fiber speed measurement mechanism.

[0066] In combination with the mechanical assembly drawing of the high-speed spindle double-optical fiber digital intelligent dynamic power vibration characteristic test and analysis system shown in Fig. 1, the mechanical assembly drawing top view of the high-speed spindle double-optical fiber digital intelligent dynamic power vibration characteristic test and analysis system shown in Fig. 2, the mechanical assembly drawing K view of the high-speed spindle double-optical fiber digital intelligent dynamic power vibration characteristic test and analysis system shown in Fig. 3, the high-frequency driving pulley shown in Fig. 4, the driving speed measurement support plate shown in Fig. 5, and the driving speed measurement principle diagram shown in Fig. 6, the high-frequency driving dynamic optical fiber speed measurement and power measurement mechanism: the slide plate 03 is installed on the guide rail 21 of the high-frequency driving dynamic optical fiber speed measurement and power lifting mechanism, the variable frequency motor 02 is installed below the slide plate 03, the dynamic torque sensor 05 is fixed on the side of the slide plate 03, connected with the variable frequency motor 02 through the lower diaphragm type coupling 04, connected with the pulley shaft 09 installed between the two bearings 08 through the upper diaphragm type coupling 06, the end cover 10 fixes the two bearings 08 on the upper end of the slide plate 03, the high-frequency driving pulley 12 is installed on the upper end of the pulley shaft 09 and connected with the measured spindle 55 through the spindle belt 29, the variable frequency motor 02 drives the measured spindle 55 to rotate through the coaxially installed lower diaphragm type coupling 04, dynamic torque sensor 05, upper diaphragm type coupling 06, pulley shaft 09, high-frequency driving pulley 12, spindle belt 29; the driving speed measurement support plate 13 is fixed on the upper end of the slide plate 03 through the driving speed measurement support 15, the E32-ZD200E driving speed measurement optical fiber 18 is fixed on the driving speed measurement support plate 13 through the optical fiber positioning sleeve 16, optical fiber guide sleeve 17 and positioning sleeve 14, the E3X-DA21-S driving speed measurement optical fiber amplifier 19, and the optical fiber storage box 20 are also fixed on the driving speed measurement support plate 13, the E32-ZD200E driving speed measurement optical fiber 18 and the E3X-DA21-S driving speed measurement optical fiber amplifier 19 constitute the driving speed laser speed sensor, and the window 11 is fixed on the installation base plate 07, which is used for observing the running state of the lower diaphragm type coupling 04, dynamic torque sensor 05 and upper diaphragm type coupling 06 below the window and plays a safety protection role.

[0067] Ten light reflection color marks with the same width are equally coated on the high-frequency driving pulley 12, and the output end of the laser speed sensor will output ten high and low levels when the high-frequency driving pulley 12 rotates one round, and the high-frequency driving speed s is 0.1 rpm.

[0068] The driving rotating speed s laser rotating speed sensor takes the falling edge of the reflected laser pulse signal as the interrupt source of the MCU single-chip microcomputer INT0, and takes the interrupt period as the driving rotating speed s real-time rotating speed signal.

[0069] The center line of the very frequent driving dynamic optical fiber speed measurement power lifting mechanism is parallel to the center line of the very frequent driving dynamic optical fiber speed measurement power mechanism, and the very frequent driving dynamic optical fiber speed measurement power lifting mechanism adjusts the center height of the very frequent driving dynamic optical fiber speed measurement power mechanism.

[0070] The very frequent driving dynamic optical fiber speed measurement power mechanism adopts laser fiber sensor pulse width speed measurement in two speed measurement channels of the spindle dynamic optical fiber speed measurement mechanism, and the driving rotating speed s and the spindle rotating speed n constitute a double-fiber synchronous speed measurement mode.

[0071] The dynamic torque sensor 05 sends the measured real-time dynamic data to the MCU-based double-fiber very frequent laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module for processing.

[0072] The E32-ZD200E driving rotating speed s speed measurement fiber 18 receives the reflected light signal from the very frequent driving belt wheel 12, and the E3X-DA21-S driving rotating speed s speed measurement fiber amplifier 19 processes the measured driving rotating speed s real-time dynamic data based on the MCU-based double-fiber very frequent laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module.

[0073] The dynamic torque sensor 05, the lower diaphragm coupling 04, the frequency conversion motor 02, the upper diaphragm coupling 06, the belt wheel shaft 09, and the very frequent driving belt wheel 12 axial center are on the same straight line.

[0074] The very frequent driving belt wheel 12 is connected with the measured spindle 55 installed on the upper apron 36 of the spindle installation movement mechanism through the spindle belt 29 of the spindle belt tension loading mechanism, and drives the measured spindle 55 to rotate.

[0075] In combination with the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test and analysis system shown in Figure 1, the ultra-frequency driving dynamic optical fiber speed measurement power measurement lifting mechanism is as follows: the mounting base plate 07 is fixed on the bed 01, the guide rail 21 is installed on the mounting base plate 07, the lead screw 22, the lead screw seat 27 and the hand wheel 28 are installed on the guide rail 21, the lead screw nut 23 is installed on the lead screw 22, the lead screw nut 23 is connected with the slide plate 03; the locking screw 24 is installed at the connection between the guide rail 21 and the mounting base plate 07, two steel balls 25 are installed in the vertical intersecting holes, the locking column 26 is installed in the horizontal hole, the left side of the locking column 26 is on the side slide way of the slide plate 03, and the right side of the locking column 26 is in contact with the steel ball 25; the locking screw 24, the steel ball 25 and the locking column 26 eliminate the gap between the slide plate 03 and the guide rail 21, and lock the slide plate 03 on the guide rail 21.

[0076] When working, the locking screw 24 is loosened, the steel ball 25 and the locking column 26 eliminate the locking of the slide plate 03, the hand wheel 28 is rotated to drive the lead screw 22 to rotate, the lead screw nut 23 drives the slide plate 03 to move up and down, the appropriate height is adjusted, and the locking screw 24 is locked; the ultra-frequency driving dynamic optical fiber speed measurement power measurement lifting mechanism makes the center height of the ultra-frequency driving dynamic optical fiber speed measurement power measurement mechanism rise and fall, and the center height of the measured spindle installation is adjusted relatively.

[0077] In combination with the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test and analysis system shown in Figure 1, the spindle belt tension loading mechanism is as follows: the roller support 32 and the roller 33 are installed on the right side of the lower part of the guide rail base plate 35, the traction seat 30 is installed on the upper slide plate 36, the loading weight 34 is connected with the traction seat 30 through the traction steel wire 31 and the roller 33, under the action of the gravity of the loading weight 34, the measured spindle 55 installed on the upper slide plate 36 of the spindle installation movement mechanism is driven to move to the right, the spindle belt 29 is tensioned, the measured spindle 55 is loaded, the ultra-frequency driving pulley 12 is connected with the measured spindle 55 installed on the upper slide plate 36 of the spindle installation movement mechanism through the spindle belt 29 of the spindle belt tension loading mechanism, and drives the measured spindle 55 to rotate.

[0078] In combination with the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 1, the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 2, and the K-direction view of the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 3, the spindle mounting mechanism: the upper part of the guide rail base plate 35 is made into a dovetail shape, and the lower part is fixed on the bed 01; the upper slide plate 36 is provided with rolling bearings 38 arranged in a 90° V-shaped dovetail shape on both sides and rolling bearings 38 arranged in a horizontal axis; each rolling bearing 38 is provided with an eccentric shaft 37 for adjusting the gap between the dovetail rolling bearings; the eccentric distances of each eccentric shaft 37 are adjusted; the rolling bearings 38 arranged in a 90° V-shaped dovetail shape and the rolling bearings 38 arranged in a horizontal axis are in close contact with the dovetail guide rail surface of the guide rail base plate 35, respectively, to form a dovetail rolling bearing guide rail; the measured spindle 55 is fixed in the hole of the upper slide plate 36; the very frequency driving pulley 12 is connected with the measured spindle 55 mounted on the upper slide plate 36 of the spindle mounting mechanism through the spindle belt 29 of the spindle belt tension loading mechanism, and drives the measured spindle 55 to rotate.

[0079] In combination with the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 1, the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 2, and the K-direction view of the mechanical assembly drawing of the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system shown in Figure 3, the vibration test adjustment mechanism: the Z-axis lifting table 39 is fixed on the side of the upper slide plate 36 through the Z-axis lifting table mounting seat 40; the upper measuring disc 42 and the lower measuring disc 43 are connected with the sliding table of the Z-axis lifting table 39 through the Z-axis connecting seat 41; the X-axis orthogonal displacement platform 48 and the Y-axis orthogonal displacement platform 49 are fixed on the upper surface of the lower measuring disc 43, respectively; the X-axis eddy current sensor 46 and the Y-axis eddy current sensor 47 are fixed on the corresponding X-axis orthogonal displacement platform 48 and Y-axis orthogonal displacement platform 49 through the sensor connecting seat 44 and the sensor mounting sleeve 45; the X-axis orthogonal displacement platform 48 and the Y-axis orthogonal displacement platform 49 are used for adjusting the position of the X-axis eddy current sensor 46 and the Y-axis eddy current sensor 47 in the spatial plane coordinate, so as to align the center of the measured spindle 55 and adjust the measurement gap; the Z-axis lifting table 39 is used for adjusting the center height of the X-axis eddy current sensor 46 and the Y-axis eddy current sensor 47, so as to align the measurement height position of the measured spindle 55.

[0080] The axis of the Z-axis lifting table is parallel to the center line of the measured spindle; the X-axis orthogonal displacement platform and the Y-axis orthogonal displacement platform are perpendicular to the center line of the measured spindle.

[0081] The X-axis eddy current sensor on the vibration test adjusting mechanism sends the measured real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module for processing. The Y-axis eddy current sensor sends the measured real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module for processing.

[0082] In combination with the high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system mechanical part assembly drawing shown in FIG. 1, the high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system mechanical part assembly drawing top view shown in FIG. 2, the high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system mechanical part assembly drawing K view shown in FIG. 3, and the spindle speed measurement principle diagram shown in FIG. 7, the spindle dynamic fiber speed measurement mechanism includes: the E32-ZD200E spindle speed n measurement fiber 52 is fixed on the spindle speed measurement support rod 51 through the fiber positioning sleeve 16 and the fiber guide sleeve 17, and the spindle speed measurement support rod 51 is fastened in the hole of the support block 54 through the spindle speed measurement support column 50; the E3X-DA21-S spindle speed n measurement fiber amplifier 53 is fixed on the top of the installation base plate 07, and the fiber storage box 20 is fixed on the side of the Z-axis lifting table 39; the spindle speed measurement support rod 51, the spindle speed measurement support column 50, and the support block 54 can slide relative to each other to adjust the measurement position of the E32-ZD200E spindle speed n measurement fiber 52 relative to the measured spindle 55; and the E32-ZD200E spindle speed n measurement fiber 52 and the E3X-DA21-S spindle speed n measurement fiber amplifier 53 constitute the spindle speed n laser speed sensor.

[0083] The spindle speed n laser speed sensor takes the falling edge of the reflected laser pulse signal as the interrupt source of the MCU single-chip microcomputer INT1, and takes the interrupt period as the spindle speed n real-time speed signal.

[0084] The E32-ZD200E spindle speed n measurement fiber 52 receives the reflected light signal from the measured spindle 55, and sends the measured spindle speed n real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module for processing through the E3X-DA21-S spindle speed n measurement fiber amplifier 53.

[0085] The sub-frequency drive dynamic fiber speed measurement power measurement mechanism, both speed measurement channels of the spindle dynamic fiber speed measurement mechanism adopt laser fiber sensor pulse width speed measurement, and the drive speed s and the spindle speed n constitute a double-fiber synchronous speed measurement mode.

[0086] With the MCU-based double optical fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module principle diagram shown in Figure 8, the front panel diagram of the MCU-based double optical fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module shown in Figure 9, the rear panel diagram of the MCU-based double optical fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module shown in Figure 10, the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system block diagram shown in Figure 11, the flow chart of the MCU-based double optical fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module shown in Figure 12, the MCU-based double optical fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module: the external interrupt ports INT0, INT1 of the MCU single-chip microcomputer 56 are connected to the drive speed s interface 68 and the spindle speed n interface 69 on the rear panel through drive speed level conversion and spindle speed level conversion respectively, and receive the real-time dynamic speed signals collected by the drive speed s laser speed sensor composed of the E32-ZD200E drive speed s speed measurement optical fiber 18 and the E3X-DA21-S drive speed s speed measurement optical fiber amplifier 19, and the real-time dynamic speed signals collected by the spindle speed n laser speed sensor composed of the E32-ZD200E spindle speed n speed measurement optical fiber 52 and the E3X-DA21-S spindle speed n speed measurement optical fiber amplifier 53; the MCU single-chip microcomputer 56 is connected with the 8-channel 16-bit AD7606 module 57 through an analog SPI serial port, the channels 1 and 2 of the 8-channel 16-bit AD7606 module 57 are connected to the amplitude X interface 70 and the amplitude Y interface 71 on the rear panel through signal conditioning circuit filtering, shaping and limiting amplitude processing, and receive the real-time dynamic amplitude signals collected by the X-axis eddy current sensor 46 and the Y-axis eddy current sensor 47 respectively; the channel 0 of the 8-channel 16-bit AD7606 module 57 is connected to the torque T interface 67 on the rear panel, and receives the real-time dynamic torque signal collected by the dynamic torque sensor 05; the serial port of the MCU single-chip microcomputer 56 is connected to the RS485 bus through the RS485 module connected to the rear panel communication interface 66, to realize the communication of the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module with the upper computer based on PYTNON data visualization graphical processing, real-time dynamic data interpolation, intelligent state recognition measurement and control; the MCU single-chip microcomputer 56 is connected to the 2.7-inch OLED display screen 58 on the front panel through an analog SPI serial port, and the 2.7 inch OLED display screen is used to display the current measurement state, and the real-time collected torque T, power P, driving speed s, spindle speed n, amplitude X, amplitude Y dynamic data; the P4^3 port of the MCU single-chip microcomputer 56 is connected to the load test state display lamp 59 of the front panel; the P4^4 port is connected to the driving test state display lamp 60 of the front panel; the P3^2 port is connected to the driving speed s display lamp 61 of the front panel; the P3^3 port is connected to the spindle speed n display lamp 62 of the front panel; the P4^1 port is connected to the sensitivity state steel display lamp 63 of the front panel; the P4^2 port is connected to the sensitivity state aluminum display lamp 64 of the front panel; and the P4^0 port is connected to the sensitivity setting 65 of the front panel.

[0087] Figure 11 shows a high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test analysis system block diagram, which will be described below: based on the MCU, the double-fiber very-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module on the left side of the block diagram:

[0088] The frequency converter receives the control word of the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module of the data visualization graphical processing, real-time dynamic data interpolation, intelligent state recognition measurement and control based on PYTNON of the host computer, and sets the frequency of the variable frequency motor 02 The speed-up time, start, and stop control; the variable frequency motor 02 drives the very-frequency driving pulley 12 to rotate through the dynamic torque sensor 05, the very-frequency driving pulley 12 drives the measured spindle 55 to rotate through the spindle belt 29; the real-time dynamic torque signal collected by the dynamic torque sensor 05 is sent to the 0 channel of the 8-channel 16-bit AD7606 module 57, the real-time dynamic amplitude signals collected by the X-axis eddy current sensor 46 and the Y-axis eddy current sensor 47 are sent to the 1 and 2 channels of the 8-channel 16-bit AD7606 module 57 respectively, and are processed by the MCU single-chip microcomputer 56; the real-time dynamic speed signal collected by the driving speed s laser speed sensor composed of the E32-ZD200E driving speed s speed measurement fiber 18 and the E3X-DA21-S driving speed s speed measurement fiber amplifier 19 is sent to the INT0 port of the MCU single-chip microcomputer 56, and the real-time dynamic speed signal collected by the spindle speed n laser speed sensor composed of the E32-ZD200E spindle speed n speed measurement fiber 52 and the E3X-DA21-S spindle speed n speed measurement fiber amplifier 53 is sent to the INT1 port of the MCU single-chip microcomputer 56.

[0089] The X-axis eddy current sensor 46 sends the measured real-time dynamic data through the amplitude X interface 70 to channel 1 of the 8-channel 16-bit AD7606 module 57, and the Y-axis eddy current sensor 47 sends the measured real-time dynamic data through the amplitude Y interface 71 to channel 2 of the 8-channel 16-bit AD7606 module 57. The X-axis eddy current sensor and the Y-axis eddy current sensor data acquisition algorithm: The 8-channel 16-bit AD7606 module 57 is set to 4 times oversampling (i.e. 4 samples are collected inside the hardware to average), and the MCU single-chip microcomputer 56 continuously collects 40 samples of dynamic data of channels 1 and 2 (for each channel, it is equivalent to collecting 160 samples), queues the 40 samples, removes one maximum value, removes one minimum value, takes the next 5 values and the last 5 values, corresponds to subtraction, obtains 5 peak-to-peak values, and takes the average value as the peak-to-peak value of the measurement point. Amplitude X i , amplitude Y i .

[0090] The dynamic torque sensor 05 sends the measured real-time dynamic data through the torque T interface 67 to channel 0 of the 8-channel 16-bit AD7606 module 57. The dynamic torque sensor data acquisition algorithm: The dynamic torque sensor 05 collects the measured real-time dynamic data through 4 times oversampling hardware averaging, and the MCU single-chip microcomputer 56 continuously collects 3 samples to average, as the torque value T i .

[0091] The drive speed s laser speed sensor sends the measured drive speed s real-time dynamic data through the drive speed s interface 68, through level conversion to the INT0 of the MCU single-chip microcomputer 56. The drive speed s laser speed sensor data acquisition algorithm: The MCU single-chip microcomputer 56 continuously collects 4 falling edges, three pulse widths, calculates the average pulse width, and derives a 3-sample average speed s value as the real-time drive speed s of the measurement point.

[0092] The spindle speed n laser speed sensor sends the measured spindle speed n real-time dynamic data through the spindle speed n interface 69, through level conversion to the INT1 of the MCU single-chip microcomputer 56. The spindle speed n laser speed sensor data acquisition algorithm: The MCU single-chip microcomputer 56 continuously collects 4 falling edges, three pulse widths, calculates the average pulse width, and derives a 3-sample average speed n value as the real-time spindle speed n of the measurement point.

[0093] The relevant ports of the MCU single-chip microcomputer 56 are connected to the load test status display lamp 59, the drive test status display lamp 60, the drive speed s display lamp 61, the spindle speed n display lamp 62, the sensitivity status steel display lamp 63, the sensitivity status aluminum display lamp 64, and the sensitivity setting 65 on the front panel, to realize the corresponding LED display function.

[0094] The MCU single-chip microcomputer 56 is connected to the 2.7-inch OLED display screen 58 on the front panel through an analog SPI serial port, for displaying the current measurement state, and the real-time collected torque T, power P, driving speed s, spindle speed n, amplitude X, and amplitude Y dynamic data.

[0095] The serial port of the MCU single-chip microcomputer 56 is connected to the RS485 bus through the RS485 module and the rear panel communication interface 66, to realize communication with the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module of the PYTNON-based data visualization graphical processing, real-time dynamic data interpolation, intelligent state recognition measurement and control.

[0096] The MCU single-chip microcomputer 56 is provided with a sensitivity setting subprogram and a sensitivity setting 65 key, and has two built-in key values. When the key value is 0, the material is steel, and the sensitivity sk=10 mv / μm. When the key value is 1, the material is aluminum, and the sensitivity sk=13.8 mv / μm. The selected sensitivity setting key value is saved in the ROM of the MCU single-chip microcomputer 56 for calling. The P4^0 port is connected to the sensitivity setting 65 of the front panel. When the P4^0 port is at a low level, the selected key value is 0, the P4^1 port outputs a low level, and the sensitivity state steel display lamp 63 is bright, indicating that the current measured spindle material is steel. When the P4^0 port is at a high level, the selected key value is 1, the P4^2 port outputs a low level, and the sensitivity state aluminum display lamp 64 is bright, indicating that the current measured spindle material is aluminum.

[0097] The MCU single-chip microcomputer 56 is provided with an intelligent state recognition subroutine. When the MCU single-chip microcomputer 56 is powered on and initialized, if the driving rotation speed s > 10 and the spindle rotation speed n < 10, the 2.7-inch OLED display screen 58 displays "spindle driving performance test" in the first row, the INT0 interrupt port P3^2 outputs a pulse signal, the P3^2 port is connected to the driving rotation speed s display lamp 61 on the front panel, at this time, the driving rotation speed s display lamp 61 flashes, the flashing frequency is consistent with the driving rotation speed s frequency, indicating that only the drive pulley 12 rotates, the P4^4 port is connected to the driving test state display lamp 60 on the front panel, the P4^4 port outputs a low level, the driving test state display lamp 60 is on, the P4^3 port outputs a high level, and the load test state display lamp 59 is off, indicating that the system is currently in the "spindle driving performance test" state; if the driving rotation speed s > 10 and the spindle rotation speed n > 10, the 2.7-inch OLED display screen 58 displays "spindle load performance test" in the first row, the INT0 interrupt port P3^2 outputs a pulse signal, the P3^2 port is connected to the driving rotation speed s display lamp 61 on the front panel, at this time, the driving rotation speed s display lamp 61 flashes, the flashing frequency is consistent with the driving rotation speed s frequency, the INT1 interrupt port P3^3 outputs a pulse signal, the P3^3 port is connected to the spindle rotation speed n display lamp 62 on the front panel, at this time, the spindle rotation speed n display lamp 62 flashes, indicating that the drive pulley 12 rotates, and the measured spindle 55 also rotates, the P4^4 port outputs a high level, the driving test state display lamp 60 is off, the P4^3 port outputs a low level, and the load test state display lamp 59 is on, indicating that the system is currently in the "spindle load performance test" state; if neither of the above two conditions is met, i.e., the driving rotation speed s < 10 and the spindle rotation speed n < 10 (at this time, the timeout function is triggered, and the timeout time is set to 16.7 seconds, which is equivalent to the driving rotation speed s < 1 rpm, and the system sets the driving rotation speed s to zero), the 2.7-inch OLED display screen 58 displays "spindle comprehensive performance test" in the first row, the INT0 interrupt port P3^2 does not output a pulse signal, the INT1 interrupt port P3^3 does not output a pulse signal, the driving rotation speed s display lamp 61 is off, the spindle rotation speed n display lamp 62 is off, indicating that the drive pulley 12 stops rotating, and the measured spindle 55 also stops rotating, the P4^4 port outputs a high level, the driving test state display lamp 60 is off, the P4^3 port outputs a high level, and the load test state display lamp 59 is off, indicating that the system is currently in the "spindle comprehensive performance test" state (i.e., standby state).

[0098] The MCU-based double optical fiber very high frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module is connected with the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphics processing, real-time dynamic data interpolation, intelligent state recognition measurement and control through the MCU single-chip microcomputer communication interface 66, using RS-485 and Modbus 8N2 for RTU serial communication protocol, the MCU single-chip microcomputer 56 is provided with a serial communication subprogram, and the dynamic real-time collected driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, and power P frame data are stored in SBUF, when the read command issued by the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphics processing, real-time dynamic data interpolation, intelligent state recognition measurement and control is received on the COM bus and the local address is consistent, the frame data in SBUF is returned to the COM bus.

[0099] The high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system adopts a double optical fiber laser fiber sensor, an X-axis eddy current sensor, a Y-axis eddy current sensor, and a dynamic torque sensor, and synchronously measures driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, and power P, to form one-to-one corresponding frame data.

[0100] Fig. 12 shows a flowchart of an MCU-based double optical fiber very high frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module, wherein the left part of the figure is a first load measurement intelligent state recognition data acquisition subprogram flowchart, and the right part of the figure is a second driving measurement intelligent state recognition data acquisition subprogram flowchart, which will be described below according to the flow:

[0101] The first load measurement intelligent state recognition data acquisition subprogram flow chart: before starting measurement, connect the very frequency drive pulley 12 and the measured spindle 55 with the spindle belt 29, power on the MCU single-chip microcomputer 56, IAP15L2K61S2 is initialized, port distribution: INT0 drives the rotation speed s, INT1 spindle rotation speed n, sensitivity setting: P4^0, sensitivity state display: P4^1, P4^2, test state display: P4^3, P4^4; AD7606 setting: torque T, amplitude X, amplitude Y; OLED intelligent state screen display setting; communication format: RS-485 Modbus 8N2 for RTU, equipment address: 05; before starting measurement, the very frequency drive pulley 12 and the measured spindle 55 do not rotate, so: the 2.7-inch OLED display screen 58 displays one line: "spindle comprehensive performance test", P4^3 high level, load test state display lamp 59 is off; P4^4 high level, drive test state display lamp 60 is off; because in the process of program execution, the first load measurement: the very frequency drive pulley 12 rotates, the measured spindle 55 rotates, there are both drive rotation speed s and spindle rotation speed n, so in the measurement: the 2.7-inch OLED display screen 58 displays one line: "spindle load performance test", P4^3 low level, load test state display lamp 59 is on, P4^4 port output high level, drive test state display lamp 60 is off.

[0102] Start data acquisition: adopt pulse width method to continuously collect four falling edges of INT0, INT1 interrupt port, calculate the average width of three pulses, calculate real-time drive rotation speed s, spindle rotation speed n, the very frequency drive rotation speed s has a scale value of 0.1 rpm, the spindle rotation speed n has a scale value of 1 rpm.

[0103] When it is judged that drive rotation speed s>10 and spindle rotation speed n<10 are met, the 2.7-inch OLED display screen 58 displays the first line: "spindle drive performance test", P4^4 port output low level, drive test state display lamp 60 is on, P4^3 port output high level, load test state display lamp 59 is off, indicating that the system is currently in "spindle drive performance test" state; otherwise: when it is judged that drive rotation speed s>10 and spindle rotation speed n>10 are met, the 2.7-inch OLED display screen 58 displays the first line: "spindle load performance test", P4^4 port output high level, drive test state display lamp 60 is off, P4^3 port output low level, load test state display lamp 59 is on, indicating that the system is currently in "spindle load performance test" state; otherwise: it is judged that the above two conditions are not met, the 2.7-inch OLED display screen 58 displays the first line: "spindle comprehensive performance test", P4^4 port output high level, drive test state display lamp 60 is off, P4^3 port output high level, load test state display lamp 59 is off, indicating that the system is currently in "spindle comprehensive performance test" state (i.e. standby state).

[0104] The set sensitivity is extracted, and the 8-channel 16-bit AD7606 module 57 data is read: amplitude X, amplitude Y; torque T, and power P is calculated. According to the data acquisition algorithm, the frame data of the driving speed s, the spindle speed n, the amplitude X, the amplitude Y, the torque T, and the power P of the synchronous acquisition processing are stored in the SBUF of the MCU single-chip microcomputer 56. At the same time, the 2.7-inch OLED display screen 58 displays the current measurement state in one row, the torque T in two rows and one column, the power P in two rows and two columns, the driving speed s in three rows and one column, the spindle speed n in three rows and two columns, the amplitude X in four rows and one column, and the amplitude Y in four rows and two columns dynamic data.

[0105] It is judged whether RI = 1 (serial port interrupt) is N, and the data acquisition is returned; it is Y, the instruction on the COM port 485 bus is read, START≥10ms, device address code, function code, data start address, data quantity, and CRC check code; the local address is judged: if the instruction address on the bus does not match the local device address code, the program returns to continue collecting data upwards, if the instruction address on the bus matches the local device address, the program executes downwards, and the frame data in the SBUF, the device address code 05, the function code 03, the data quantity 0C, the data, and the CRC check code are returned to the COM port; the data acquisition is started.

[0106] The secondary driving measurement intelligent state recognition data acquisition subroutine flow chart: before starting measurement, the connecting very frequency driving pulley 12 and the measured spindle 55 spindle belt 29 is removed, and the measured spindle 55 no longer rotates; before starting measurement, the very frequency driving pulley 12 and the measured spindle 55 do not rotate, so that the 2.7-inch OLED display screen 58 displays “spindle comprehensive performance test” in one row, P4^3 high level, and the load test state display lamp 59 is off; P4^4 high level, driving test state display lamp 60 is off; because the program executes in the process of secondary driving measurement, only the very frequency driving pulley 12 rotates, so only the driving speed s, no spindle speed n, so in the measurement: the 2.7-inch OLED display screen 58 displays “spindle driving performance test” in one row, P4^4 low level, driving test state display lamp 60 is bright, P4^3 port outputs high level, and the load test state display lamp 59 is off.

[0107] Starting data acquisition: same as the first load measurement, the pulse width method is used to continuously collect the INT0, INT1 interrupt port 4 falling edges, calculate the average width of three pulses, calculate the real-time driving speed s, the spindle speed n, and the very frequency driving speed s division value 0.1 rotation. The difference is that, since the secondary driving measurement only has the very frequency driving pulley 12 rotating, only the driving speed s, the spindle speed n≡0.

[0108] If the driving speed s > 10 and the spindle speed n < 10, the first line of the 2.7-inch OLED display 58 displays "spindle driving performance test", the P4^4 port outputs low level, the driving test state display lamp 60 is on, the P4^3 port outputs high level, the load test state display lamp 59 is off, indicating that the system is currently in the "spindle driving performance test" state; otherwise, if the driving speed s > 10 and the spindle speed n > 10, the first line of the 2.7-inch OLED display 58 displays "spindle load performance test", the P4^4 port outputs high level, the driving test state display lamp 60 is off, the P4^3 port outputs low level, the load test state display lamp 59 is on, indicating that the system is currently in the "spindle load performance test" state; otherwise, the above two conditions are not met, the first line of the 2.7-inch OLED display 58 displays "spindle comprehensive performance test", the P4^4 port outputs high level, the driving test state display lamp 60 is off, the P4^3 port outputs high level, the load test state display lamp 59 is off, indicating that the system is currently in the "spindle comprehensive performance test" state (i.e. standby state); due to secondary driving measurement, only the driving pulley 12 rotates, only the driving speed s, and the spindle speed n ≡ 0, so: during actual program execution, only one state of the driving speed s > 10 and the spindle speed n < 10 appears, the first line of the 2.7-inch OLED display 58 displays "spindle driving performance test", the P4^4 port outputs low level, the driving test state display lamp 60 is on, the P4^3 port outputs high level, the load test state display lamp 59 is off, indicating that the system is currently in the "spindle driving performance test" state.

[0109] The set sensitivity is extracted, the 8-channel 16-bit AD7606 module 57 data is read: amplitude X, amplitude Y; torque T, power P is calculated, according to the data acquisition algorithm, the driving speed s, the spindle speed n, the amplitude X, the amplitude Y, the torque T, and the power P frame data of the synchronous acquisition processing are stored in the SBUF of the MCU single-chip microcomputer 56; at the same time, the 2.7-inch OLED display 58 displays the current measurement state in one line, the torque T in two rows and one column, the power P in two rows and two columns; the driving speed s in three rows and one column, the spindle speed n in three rows and two columns; the amplitude X in four rows and one column, and the amplitude Y in four rows and two columns dynamic data; due to secondary driving measurement, only the driving pulley 12 rotates, only the driving speed s, and the spindle speed n ≡ 0, at the same time, the amplitude X ≡ 0, and the amplitude Y ≡ 0.

[0110] When the judgment is satisfied with RI = 1 (serial port interrupt), N is returned to data collection; Y is read on the COM port 485 bus command, START >= 10 ms, device address code, function code, data start address, data quantity, CRC check code; local address judgment: if the bus instruction address does not match the local device address code, the program returns to continue collecting data; if the bus instruction address matches the local device address, the program executes downwardly, returns the frame data in SBUF to the COM port, the device address code 05, the function code 03, the data quantity 0C, the data, and the CRC check code; and the data collection is started.

[0111] In combination with the high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system block diagram shown in FIG. 11, the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control shown in FIG. 13, the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module first load measurement characteristic curve diagram shown in FIG. 14, and the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module secondary drive measurement and spindle characteristic curve diagram shown in FIG. 15, the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control comprises a communication parameter setting area 72, a spindle test parameter setting area 77, an amplitude-frequency spectrum dynamic curve visualization drawing window 89, a torque spectrum dynamic curve and power spectrum dynamic curve visualization drawing window 94 and a function key, a function display window and a state display lamp, and constitutes a graphical user interface (GUI).

[0112] The communication parameter setting area 72 is used for setting communication parameters, including serial port number, check bit, stop bit, baud rate, data bit, sampling period, device address, register address setting and scanning serial port; the serial port opening / closing 73 is used for controlling communication with the lower computer; the serial port current state display 74 is used for displaying the current program execution function; the serial port current sending command word 75 is used for displaying the current sending data; and the serial port current receiving data 76 is used for displaying the current serial port returned data.

[0113] Spindle test parameter setting area 77, for setting spindle parameters, including: spindle model, spindle disc diameter, set spindle speed, transmission efficiency, speed-up time, interpolation interval, and set drive speed calculated from spindle disc diameter, set spindle speed, transmission efficiency, spindle speed increase button, spindle speed decrease button; wherein: the speed-up time is the time for the frequency conversion motor to rise to the set spindle speed; the spindle speed increase button and the spindle speed decrease button add or subtract 1 to the frequency formula, and each press increases or decreases one pulse of the frequency converter, with a pulse equivalent of 0.01 Hz; when the host computer issues a spindle speed increase or spindle speed decrease instruction, the frequency conversion motor increases or decreases 0.6 revolutions, and when the spindle transmission ratio is 6, the spindle speed increases or decreases 3.6 revolutions; real-time spindle speed display 78, for displaying the real-time spindle speed n of the currently measured spindle 55; drive real-time speed display 79, for displaying the real-time drive speed s of the currently measured drive pulley 12; start data collection button 80, for issuing a read data and frequency conversion motor 02 start command to the bus; frequency conversion motor separate start command 81, which does not collect data, and is only used to issue a frequency conversion motor 02 start command to the bus, facilitating equipment debugging; frequency conversion motor separate stop command 82, which is only used to issue a frequency conversion motor 02 stop command to the bus, facilitating equipment debugging or emergency shutdown during program operation; first load measurement state display light 83, for indicating that the system is currently in the first load measurement state; secondary drive measurement state display light 84, for indicating that the system is currently in the secondary drive measurement state; spindle characteristic parameter state display light 85, for indicating that the system is currently in the spindle characteristic parameter calculation process: calculating torque difference and power difference and other characteristic parameters according to processed data; characteristic parameter report button 86, for generating and storing characteristic parameter report files; raw experimental data button 87, for generating and storing raw experimental data files; measured spindle setting parameter display area 88, for displaying and facilitating measurement personnel to understand the currently set parameters, including: set spindle speed, spindle disc diameter, transmission efficiency, spindle speed increase, speed-up time, and drive speed.

[0114] Amplitude-frequency spectrum dynamic curve visualization drawing window 89, for drawing 4 visual real-time amplitude-frequency dynamic curves, including: X-axis real-time amplitude X-spindle speed n curve 90, Y-axis real-time amplitude Y-spindle speed n curve 91, X-axis Y-axis real-time combined amplitude p-spindle speed n curve 92, and spindle axis trajectory peak e-phase angle θ curve 93.

[0115] The torque spectrum dynamic curve, power spectrum dynamic curve visual drawing window 94 is used for drawing visual real-time torque dynamic curve, power dynamic curve and includes: 6 torque spectrum dynamic curves in twice measurement state: first load measurement real-time dynamic torque T-drive speed s curve 95, first load measurement real-time dynamic torque T-spindle speed n curve 97, second drive measurement real-time dynamic torque T-drive speed s curve 99, second drive measurement real-time dynamic torque T-spindle speed n curve 101, spindle real-time dynamic torque T-drive speed s curve 103, spindle real-time dynamic torque T-spindle speed n curve 105; 6 power spectrum dynamic curves in twice measurement state: first load measurement real-time dynamic power P-drive speed s curve 96, first load measurement real-time dynamic power P-spindle speed n curve 98, second drive measurement real-time dynamic power P-drive speed s curve 100, second drive measurement real-time dynamic power P-spindle speed n curve 102, spindle real-time dynamic power P-drive speed s curve 104, spindle real-time dynamic power P-spindle speed n curve 106.

[0116] Fig. 11 shows a high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system block diagram, the following block diagram right: based on PYTNON data visualization graphics processing, real-time dynamic data interpolation, intelligent state recognition control high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module, expand to be explained:

[0117] The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module application based on PYTNON data visualization graphics processing, real-time dynamic data interpolation, intelligent state recognition control adopts RS-485 and Modbus 8N2 for RTU serial communication protocol, is connected with the double optical fiber very frequency laser optical fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU through MCU communication interface 66, is connected with the frequency converter communication port of very frequency drive dynamic optical fiber speed measurement ergometer control variable frequency motor 02, and sends control command to the double optical fiber very frequency laser optical fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module based on MCU, very frequency drive dynamic optical fiber speed measurement ergometer control variable frequency motor 02 frequency converter, receives and returns data.

[0118] The PYTNON application program completes communication setting through the communication parameter setting area 72; completes spindle parameter setting through the spindle test parameter setting area 77; visualizes intelligent dynamic real-time data processing display of frame data returned on the 485 bus; performs denoising, interpolation, aggregation and other processing on the data; acquires amplitude-frequency spectrum dynamic curves in the amplitude-frequency spectrum dynamic curve visualized drawing window 89 through the first load measurement data processing subprogram, the secondary drive measurement and the spindle characteristic parameter data processing subprogram; acquires torque spectrum dynamic curves and power spectrum dynamic curves in the torque spectrum dynamic curve and power spectrum dynamic curve visualized drawing window 94; generates and stores a characteristic parameter report file by clicking the characteristic parameter report button 86; and generates and stores an original experimental data file by clicking the original experimental data storage button 87.

[0119] Fig. 13 shows a high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module flow chart based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control, wherein: the left graph is a first load measurement data processing subprogram flow chart, the middle graph is a secondary drive measurement and spindle characteristic parameter data processing subprogram flow chart, and the right graph is a characteristic parameter report acquisition and original experimental data storage subprogram flow chart, which are described below according to the flow:

[0120] In combination with the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module first load measurement characteristic curve based on PYTNON data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control shown in Fig. 14, the first load measurement data processing subprogram flow chart is as follows: before starting measurement, the spindle belt 29 is used to connect the measured spindle 55 and the driven belt pulley 12, the MCU single-chip microcomputer 56 is powered on, and the IAP15L2K61S2 serial port is initialized; the communication format is set in the communication parameter setting area 72: Modbus 8N2 for RTU, baud rate: 9600; sampling period: 1000 ms, device address: 5; register address: 0; frequency converter address: 01.

[0121] The RS-485 bus serial port communication is started by clicking the open / close serial port 73 button; the spindle parameters including the spindle model, the spindle disc diameter d, the spindle speed n and the transmission efficiency η are set in the spindle test parameter setting area 77; the frequency The frequency resolution is 0.01Hz; when the spindle diameter d is input, the spindle speed n is set, and the transmission efficiency η is set, the program has already generated the write frequency data; a write acceleration time command is sent to the inverter register address 01060109; the interpolation interval g is selected; before the measurement starts, the 10-minute drive pulley 12 and the spindle 55 under test do not rotate, therefore: the first load measurement status indicator light 83 is off, the second drive measurement status indicator light 84 is off, and the spindle characteristic parameter status indicator light 85 is off.

[0122] Clicking the "Start Data Acquisition" button 80 initiates data acquisition. The program sends a command to the serial port to read MCU data: 050300000006C44C, and simultaneously sends a command to the serial port to write inverter forward operation: 0106200000120207. The inverter motor 02 begins to rotate, driving the 10-minute drive pulley 12 to rotate. The measured spindle 55 rotates, exhibiting both drive speed s and spindle speed n. Therefore, the measurement is in progress.

[0123] When the spindle speed n < 10 is TRUE, it is determined that the current state is in the secondary drive measurement state, the secondary drive measurement status indicator 84 is on, and the first load measurement status indicator 83 is off; when the spindle speed n < 10 is FALSE, it is determined that the current state is in the first load measurement state, the first load measurement status indicator 83 is on, and the secondary drive measurement status indicator 84 is off. Since the spindle speed n < 10 is FALSE during the first load measurement, it is determined that the current state is in the first load measurement state, the first load measurement status indicator 83 is on, and the secondary drive measurement status indicator 84 is off.

[0124] Data reception / acquisition: Receives real-time drive speed S, spindle speed N, amplitude X, amplitude Y, torque T, and power P frame data from the MCU microcontroller 56 on the bus; sends read data command: 050300000006C44C.

[0125] Data visualization plotting window (red in the first load measurement dotted line graph): In the amplitude spectrum dynamic curve visualization plotting window 89, four visualized real-time amplitude-frequency dynamic curves are plotted, including: X-axis real-time amplitude X-spindle speed n curve 90, Y-axis real-time amplitude Y-spindle speed n curve 91, X-Y-axis real-time composite amplitude ρ-spindle speed n curve 92, spindle axis trajectory peak e-phase angle θ curve 93; real-time XY-axis composite amplitude Axial trajectory (e) i ,θ i ), peak value of the axis trajectory Phase angle

[0126] In the torque spectrum dynamic curve, power spectrum dynamic curve visualization drawing window 94, draw 2 torque spectrum dynamic curve includes: the first load measurement real-time dynamic torque T-drive speed s curve 95, the first load measurement real-time dynamic torque T-spindle speed n curve 97; Draw 2 power spectrum dynamic curve includes: the first load measurement real-time dynamic power P-drive speed s curve 96, the first load measurement real-time dynamic power P-spindle speed n curve 98; Real-time dynamic data is processed by real-time linear interpolation, data record and save.

[0127] When the first load measurement real-time spindle speed n is greater than or equal to the set spindle speed N threshold, it is TRUE, indicating that the first load measurement is complete, ending the first load measurement, and stopping sending the read MCU data command: 050300000006C44C, sending the write frequency converter stop running control word 01062000000143CA to the serial port, and the frequency conversion motor stops running, otherwise, it is FALSE, and the loop continues to send the read MCU data command: 050300000006C44C, and continues data acquisition.

[0128] In combination with the high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module secondary drive measurement and spindle characteristic curve graph based on PYTNON data visualization graph processing, real-time dynamic data interpolation, and intelligent state recognition measurement and control shown in FIG. 15, the secondary drive measurement and spindle characteristic parameter data processing subprogram flow chart: before starting measurement, remove the spindle belt 29 connecting the very frequency drive pulley 12 and the measured spindle 55.

[0129] Click the start data collection button 80, and the program starts data collection, sends the read MCU data command: 050300000006C44C to the serial port, and sends the write frequency converter forward operation command: 0106200000120207 to the serial port at the same time. The frequency conversion motor 02 starts to rotate and drives the very frequency drive pulley 12 to rotate. Because the spindle belt 29 connecting the very frequency drive pulley 12 and the measured spindle 55 has been removed, the measured spindle 55 stops rotating, and only the drive speed s is measured, so in the measurement:

[0130] When the spindle speed n is less than 10, it is TRUE, indicating that the current is in the secondary drive measurement state, the secondary drive measurement state display lamp 84 is on, and the first load measurement state display lamp 83 is off.

[0131] Receive / acquire data: receive the MCU single-chip microcomputer 56 on the bus, return real-time drive speed S, spindle speed n=0, amplitude X=0, amplitude Y=0, torque T, power P frame data; Send the read data command: 050300000006C44C.

[0132] Data visualization plotting window (secondary drive measurement point line plot blue, spindle characteristic parameter point line plot brown): in the torque spectrum dynamic curve, power spectrum dynamic curve visualization plotting window 94, draw 2 torque spectrum dynamic curves, including: secondary drive measurement real-time dynamic torque T-drive speed s curve 99, secondary drive measurement real-time dynamic torque T-spindle speed n curve 101; draw 2 power spectrum dynamic curves, including: secondary drive measurement real-time dynamic power P-drive speed s curve 100, secondary drive measurement real-time dynamic power P-spindle speed n curve 102; real-time dynamic data is processed by real-time linear interpolation, data recording and saving.

[0133] The spindle real-time characteristic parameters: the real-time linear interpolation array of the first load measurement torque T-drive speed S, power P-drive speed S, torque T-spindle speed N, power P-spindle speed N is processed by real-time difference value with the real-time linear interpolation array of the secondary drive measurement torque T-drive speed S, power P-drive speed S, torque T-spindle speed N, power P-spindle speed N, and the spindle characteristic parameter state display lamp 85 is turned on at the same time, indicating that the current is in the spindle real-time characteristic parameter calculation state, and in the torque spectrum dynamic curve, power spectrum dynamic curve visualization plotting window 94, draw 2 torque spectrum dynamic curves, including: spindle real-time dynamic torque T-drive speed s curve 103, spindle real-time dynamic torque T-spindle speed n curve 105; draw 2 power spectrum dynamic curves, including: spindle real-time dynamic power P-drive speed s curve 104, spindle real-time dynamic power P-spindle speed n curve 106; real-time dynamic data is processed by real-time linear interpolation, and the real-time linear interpolation array of the first load measurement is processed by real-time difference value with the real-time linear interpolation array of the secondary drive measurement, and the data is recorded and saved.

[0134] When the secondary drive measurement real-time drive speed s is greater than or equal to the set drive speed S threshold, it is TRUE, indicating that the secondary drive measurement is completed, the secondary drive measurement is ended, and the read MCU data command: 050300000006C44C is stopped sending, the write frequency converter stop running control word 01062000000143CA is sent to the serial port, and the frequency conversion motor stops running, otherwise, it is FALSE, and the read MCU data command: 050300000006C44C is continuously sent, and data acquisition is continued.

[0135] The acquisition of characteristic parameter report, storage of original experimental data subprogram flow chart: after the end of secondary drive measurement, click the acquisition of characteristic parameter report button 86, a WORD document can be generated, including: test file name, test time, set test parameters; all data visualization window screenshot, including: first load measurement point line graph (red); secondary drive measurement point line graph (blue); spindle characteristic parameter point line graph (brown); characteristic parameter data table generated by interpolating interval according to spindle speed N, including: corresponding spindle speed N drive speed S, load measurement torque T, power P; secondary drive measurement torque T, power P, spindle torque T, power P.

[0136] Click the storage of original experimental data button 87, a real-time measurement data EXCEL table can be generated, including: drive speed s, spindle speed n, X-axis amplitude, Y-axis amplitude, XY-axis combined amplitude, axis center trajectory, torque T, power P, measurement process attribute, measurement time point data.

[0137] Determine whether the test is over, yes, close the serial port and exit the program; no, continue measurement, restore the spindle belt 29 connection, input new file name, original measurement data, point line graph is automatically cleared, set spindle parameters; start data collection, enter a new round of load measurement process.

[0138] The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphical processing, real-time dynamic data interpolation, intelligent state recognition measurement and control is composed of intelligent data visualization graphical processing, real-time dynamic data interpolation and related programs, including: first load measurement data processing subprogram, secondary drive measurement and spindle characteristic parameter data processing subprogram, acquisition of characteristic parameter report, storage of original experimental data subprogram, intelligent data collection and control subprogram, intelligent state recognition subprogram, intelligent automatic screen clearing subprogram.

[0139] The first load measurement data processing subprogram: set communication parameters in the communication parameter setting area 72, set spindle parameters in the spindle test parameter setting area 77, send write frequency command, frequency Frequency resolution 0.01 Hz; the frame data corresponding to drive speed s, spindle speed n, amplitude X, amplitude Y, torque T, power P is interpolated in real time by linear interpolation method with selected spindle speed n interpolation interval g, interpolation interval is set to (‘50’, ‘100’, ‘200’, ‘500’, ‘1000’) six levels, default ‘100’ rpm; receive / acquire data, draw four real-time dynamic curves: X-axis amplitude, X-axis amplitude, XY-axis combined amplitude in the amplitude-frequency spectrum dynamic curve visualization drawing window 89 (first load measurement point line graph red). Axis center trajectory (ei ,θ i ), axis trajectory peak phase angle In the torque spectrum dynamic curve, power spectrum dynamic curve visualization drawing window 94, draw the first load measurement torque spectrum 2 real-time dynamic curves: the first load measurement real-time dynamic torque T-drive speed s curve 95, the first load measurement real-time dynamic torque T-spindle speed n curve 97, draw the first load measurement power spectrum 2 real-time dynamic curves: the first load measurement real-time dynamic power P-drive speed s curve 96, the first load measurement real-time dynamic power P-spindle speed n curve 98.

[0140] The secondary drive measurement and spindle characteristic parameter data processing subroutine: adopt linear interpolation method to real-time interpolate the frame data with selected spindle speed n interpolation interval g, receive / acquire data, in the data visualization drawing window torque spectrum dynamic curve, power spectrum dynamic curve visualization drawing window 94 (secondary drive measurement point line graph blue, spindle characteristic parameter point line graph brown), draw the secondary drive measurement torque spectrum 2 real-time dynamic curves: the secondary drive measurement real-time dynamic torque T-drive speed s curve 99, the secondary drive measurement real-time dynamic torque T-spindle speed n curve 101; draw the secondary drive measurement power spectrum 2 real-time dynamic curves: the secondary drive measurement real-time dynamic power P-drive speed s curve 100, the secondary drive measurement real-time dynamic power P-spindle speed n curve 102; difference value operation is done to the corresponding frame data after real-time interpolation of the first load measurement and the secondary drive measurement, at the same time, the spindle characteristic parameter state display lamp 85 is bright, indicating that the current is in the spindle real-time characteristic parameter calculation state; with the corresponding difference value operation frame data after real-time interpolation of the first load measurement and the secondary drive measurement, draw the spindle characteristic parameter torque spectrum 2 real-time dynamic curves: the spindle real-time dynamic torque T-drive speed s curve 103, the spindle real-time dynamic torque T-spindle speed n curve 105; draw the spindle characteristic parameter power spectrum 2 real-time dynamic curves: the spindle real-time dynamic power P-drive speed s curve 104, the spindle real-time dynamic power P-spindle speed n curve 106.

[0141] The acquisition of characteristic parameter report, storage of original experimental data subroutine: when ending secondary driving measurement, click the acquisition of characteristic parameter report button 86, a WORD document can be generated: test file name, test time, set test parameters; all data visualization window screenshot, including the first load measurement point line graph (red) generated by interpolation interval according to spindle speed N; secondary driving measurement point line graph (blue); spindle characteristic parameter point line graph (brown); characteristic parameter data table generated by interpolation interval according to spindle speed N, including: corresponding driving speed S, load measurement torque T, power P, secondary driving measurement torque T, power P, spindle torque T, power P; storage of original experimental data button 87, a real-time measurement data EXCEL table can be generated, including: driving speed s, spindle speed n, X-axis amplitude, Y-axis amplitude, XY-axis combined amplitude, axis trajectory, torque T, power P, measurement progress attribute, measurement time point data;

[0142] The intelligent data acquisition and control subroutine: click the start data acquisition button 80, the program sends the read MCU data command: 050300000006C44C to the serial port, sends the write frequency converter forward operation control word: 0106200000120207, the frequency conversion motor 02 starts operation, and receives the MCU return real-time driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, power P frame data, when the first load measurement real-time spindle speed n≥set spindle speed N threshold is TRUE, it is indicated that the first load measurement is completed, the first load measurement is ended, the read MCU data command: 050300000006C44C is stopped to be sent, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, the frequency conversion motor 02 stops operation, otherwise, for FALSE, the read MCU data command: 050300000006C44C is continuously sent, and the data acquisition is continued; when the secondary driving measurement real-time driving speed s≥set driving speed S threshold is TRUE, it is indicated that the secondary driving measurement is completed, the secondary driving measurement is ended, the read MCU data command: 050300000006C44C is stopped to be sent, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, the frequency conversion motor 02 stops operation, otherwise, for FALSE, the read MCU data command: 050300000006C44C is continuously sent, and the data acquisition is continued.

[0143] The intelligent state recognition subroutine: when the spindle speed n<10 is TRUE, it is determined that the current is in the secondary driving measurement state, the secondary driving measurement state display lamp 84 is on, and the first load measurement state display lamp 83 is off; when the spindle speed n<10 is FALSE, it is determined that the current is in the first load measurement state, the first load measurement state display lamp 83 is on, and the secondary driving measurement state display lamp 84 is off.

[0144] The intelligent automatic clearing program: when ending the secondary driving measurement, obtaining the characteristic parameter report, storing the original experimental data, and continuing to measure the next sample, in the spindle test parameter setting area 77, any change of a word can realize the original measurement data and point-line chart empty, set a new file name, set the spindle parameters, start data collection, and enter a new round of load measurement process.

[0145] The interpolation calculation of real-time interpolation of frame data by using linear interpolation method: the interpolation method is used to calculate new data points for subsequent analysis and drawing. The following only takes the first load measurement as an example (programmatically referred to as stage 1) to briefly describe the interpolation calculation and drawing program:

[0146] In summary: a high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system, which is composed of a very frequency driving dynamic optical fiber speed measurement and power measurement mechanism, a very frequency driving dynamic optical fiber speed measurement and power measurement lifting mechanism, a spindle belt tension loading mechanism, a spindle installation and movement mechanism, a vibration test adjustment mechanism, a spindle dynamic optical fiber speed measurement mechanism, a double optical fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition module based on MCU, a high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display and storage module based on PYTNON data visualization graphics processing, real-time dynamic data interpolation, intelligent state recognition and control.

[0147] The system adopts high-precision sensors and data acquisition and processing technology to ensure the accuracy of the measurement results, adopts MCU-based double optical fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition design, very frequency driving speed s graduation value 0.1 rpm, spindle speed n graduation value 1 rpm, driving speed s measurement accuracy is 10 times higher than the current manual measurement technology; 16-bit 64K AD chip is adopted, and frame data is processed in real time according to the parameter data acquisition algorithm; the actual precision is much higher than the current manual measurement precision; high efficiency: the design of edge speed, edge sampling, edge data processing, edge data visualization drawing, real-time dynamic data interpolation, intelligent state recognition measurement and control; multi-parameter and data visualization: multi-parameter real-time dynamic data acquisition, during the whole measurement process, up to 6 channels of sensor data can be synchronously collected, and key characteristic parameters such as amplitude and axis trajectory are calculated in real time, the vibration characteristics of the spindle are intuitively displayed, and amplitude-frequency spectrum, torque spectrum and power spectrum dynamic curves are synchronously generated and dynamically drawn, so that the real-time running state of the spindle is fully captured, and the trends of amplitude, torque and power changing with the spindle speed are clearly displayed; big data: compared with the current manual measurement technology, through three stages of measurement process, and manually recording and calculating four parameters of amplitude X, torque T, spindle speed n and power P under one spindle speed, at most 12 data; the whole measurement process of the present application generates 400 measurement points within 120s, and the signal data amount is 140000, which is 11667 times of the signal data amount collected manually; a detailed experimental report is automatically generated, including experimental parameters, real-time screenshots and data tables: all amplitude-frequency spectrum, torque spectrum and power spectrum real-time original experimental data, and characteristic parameter report data after interpolation operation and 16 dynamic curves are provided, including 4 dynamic curves in amplitude-frequency spectrum, 6 dynamic curves in torque spectrum and 6 dynamic curves in power spectrum, which facilitates users to archive and share; real-time: real-time data acquisition, analysis and display help users quickly master the running state of the spindle; easy to use: friendly graphical interface, simple and convenient operation, no professional knowledge is needed; customizable: support user-defined parameters and analysis indexes to meet different needs; real-time monitoring and feedback: real-time update of serial port state, equipment state and other information, and display on the interface.

[0148] A high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test and analysis system belongs to the technical field of intelligent manufacturing, and is a special equipment for high-speed spindle digital intelligent dynamic power vibration characteristic spectrum analysis based on MCU-based double optical fiber very frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter large data dynamic high-speed real-time data acquisition, PYTNON-based data visualization graphical processing, real-time dynamic data interpolation, intelligent state recognition measurement and control. The high-speed spindle digital intelligent dynamic power vibration characteristic spectrum analysis system can meet the needs of spindle design and research, production and manufacturing enterprises, industry scientific research, and measurement and detection departments in evaluating dynamic characteristic parameters of the spindle.

Claims

1. A high-speed spindle double optical fiber digital intelligent dynamic power vibration characteristic test analysis system, characterized in that: It comprises: The high-speed spindle double-fiber digital intelligent dynamic power vibration characteristic test and analysis system adopts a double-fiber laser fiber sensor, an X-axis eddy current sensor, a Y-axis eddy current sensor, a dynamic torque sensor, and synchronously measures driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, and power P to form one-to-one frame data. The high-frequency driving dynamic fiber speed measurement power lifting mechanism is installed on the high-frequency driving dynamic fiber speed measurement power mechanism, the center line of the high-frequency driving dynamic fiber speed measurement power lifting mechanism is parallel to the center line of the high-frequency driving dynamic fiber speed measurement power mechanism, and the high-frequency driving dynamic fiber speed measurement power lifting mechanism adjusts the center height of the measured spindle installation. The high-frequency driving dynamic fiber speed measurement power mechanism and the spindle dynamic fiber speed measurement mechanism both adopt laser fiber sensor pulse width speed measurement, and driving speed s and spindle speed n form a double-fiber synchronous speed measurement mode. The high-frequency driving dynamic fiber speed measurement power mechanism is provided with a dynamic torque sensor, and the dynamic torque sensor sends the measured real-time dynamic data to the MCU-based double-fiber high-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, and multi-parameter large data dynamic high-speed real-time data acquisition module for processing. The high-frequency driving dynamic fiber speed measurement power mechanism is provided with a driving speed s laser speed sensor composed of an E32-ZD200E driving speed s speed fiber and an E3X-DA21-S driving speed s speed fiber amplifier, and the high-frequency driving speed s indexing value is 0.1 rpm. The dynamic torque sensor is connected with the frequency conversion motor through the lower diaphragm coupling, and connected with the high-frequency driving pulley through the upper diaphragm coupling and the pulley shaft. The high-frequency driving pulley is connected with the measured spindle installed on the upper slide plate of the spindle installation movement mechanism through the spindle belt of the spindle belt tension loading mechanism, and drives the measured spindle to rotate. ​ The upper run plate of the spindle installation movement mechanism is provided with a vibration test adjusting mechanism, which comprises a Z-axis lifting table, a Z-axis lifting table mounting seat, a Z-axis connecting seat, an upper test disc, a lower test disc, a sensor connecting seat, a sensor mounting sleeve, an X-axis eddy current sensor, a Y-axis eddy current sensor, an X-axis orthogonal displacement platform and a Y-axis orthogonal displacement platform, and the axis of the Z-axis lifting table is parallel to the center line of the measured spindle; The X-axis eddy current sensor on the vibration test adjusting mechanism sends the measured real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module for processing; the Y-axis eddy current sensor sends the measured real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module for processing; The vibration test adjusting mechanism is provided with a spindle dynamic fiber speed measurement mechanism, which is provided with a spindle speed n laser speed sensor composed of an E32-ZD200E spindle speed n speed measurement fiber and an E3X-DA21-S spindle speed n speed measurement fiber amplifier, the spindle speed n index value is 1 rpm, and the spindle speed n laser speed sensor sends the measured spindle speed n real-time dynamic data to the MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module for processing; The MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module comprises an MCU single-chip microcomputer, an 8-channel 16-bit AD7606, a 2.7-inch OLED, a front panel and a rear panel; The X-axis eddy current sensor sends the measured real-time dynamic data through the amplitude X interface to channel 1 of the 8-channel 16-bit AD7606 module, the Y-axis eddy current sensor sends the measured real-time dynamic data through the amplitude Y interface to channel 2 of the 8-channel 16-bit AD7606 module, and the 8-channel 16-bit AD7606 module is set to 4 times oversampling, that is, 4 samples are collected inside the hardware to average, and the MCU single-chip microcomputer continuously collects 40 samples of the dynamic data of channels 1 and 2, for each channel, which is equivalent to collecting 160 samples, 40 samples are queued, one maximum value is removed, one minimum value is removed, the next 5 values and the next 5 values are taken, corresponding subtraction is performed, 5 peak-to-peak values are obtained, and the average value is taken as the peak-to-peak value of the measurement point, amplitude X i , amplitude Y i ; the dynamic torque sensor sends the measured real-time dynamic data through the torque T interface to channel 0 of the 8-channel 16-bit AD7606 module, and the 4 times oversampling hardware average is collected by the MCU single-chip microcomputer, and the average of 3 samples is continuously collected as the torque value T i ; the driving speed s laser speed sensor sends the measured driving speed s real-time dynamic data through the driving speed s interface, and sends the MCU single-chip microcomputer INT0 through level conversion, the MCU single-chip microcomputer continuously collects 4 falling edges, three pulse widths, calculates the average pulse width, and derives the average speed s value of 3 samples as the real-time driving speed s of the measurement point; the spindle speed n laser speed sensor sends the measured spindle speed n real-time dynamic data through the spindle speed n interface, and sends the MCU single-chip microcomputer INT1 through level conversion, the MCU single-chip microcomputer continuously collects 4 falling edges, three pulse widths, calculates the average pulse width, and derives the average speed n value of 3 samples as the real-time spindle speed n of the measurement point; The MCU-based double-fiber sub-frequency laser fiber sensor pulse width speed measurement, intelligent state recognition, multi-parameter big data dynamic high-speed real-time data acquisition module is connected with the PYTNON-based data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module through the MCU single-chip microcomputer communication interface, the RS-485 and Modbus 8N2 for RTU serial communication protocol, and the MCU single-chip microcomputer is provided with a serial communication subprogram, and the SBUF is stored with the dynamic real-time collected driving speed s, spindle speed n, amplitude X, amplitude Y, torque T and power P frame data; when the read command and the local address sent by the upper computer PYTNON-based data visualization graphic processing, real-time dynamic data interpolation, intelligent state recognition measurement and control high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module are consistent, the frame data in the SBUF is returned to the COM bus. The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation and intelligent state recognition measurement and control is composed of a communication parameter setting area, a spindle test parameter setting area, a frequency spectrum, a torque spectrum, a power spectrum dynamic curve and a function key, a function display window and a state display lamp to form a graphical user interface (GUI). The high-speed spindle digital intelligent dynamic power vibration characteristic real-time data processing display storage module based on PYTNON data visualization graphic processing, real-time dynamic data interpolation and intelligent state recognition measurement and control is composed of intelligent data visualization graphic processing, real-time dynamic data interpolation and related programs, including a first load measurement data processing subprogram, a secondary drive measurement and spindle characteristic parameter data processing subprogram, a characteristic parameter report acquisition and original experimental data storage subprogram, an intelligent data acquisition measurement and control subprogram, an intelligent state recognition subprogram and an intelligent automatic screen clearing subprogram.

2. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test analysis system of claim 1, wherein: The driving speed s laser speed sensor uses the falling edge of the reflected laser pulse signal as the interrupt source of the MCU INT0, and uses the interrupt period as the driving speed s real-time speed signal; the spindle speed n laser speed sensor uses the falling edge of the reflected laser pulse signal as the interrupt source of the MCU INT1, and uses the interrupt period as the spindle speed n real-time speed signal.

3. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test analysis system of claim 1, wherein: Ten equally wide reflective color markers are coated on the sub-frequency drive pulley, and the laser speed sensor output will output ten high and low levels when the sub-frequency drive pulley rotates one revolution, and the sub-frequency drive speed s is 0.1 rpm; the driving speed support plate is installed on the upper part of the sub-frequency drive pulley, and R2.5×10° long waist light inlet holes and R5×30° long waist light inlet holes are opened at both ends of the corresponding sub-frequency drive pulley reflective color marker return trajectory on the driving speed support plate to protect the sub-frequency drive pulley from light interference.

4. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test analysis system of claim 1, wherein: The MCU has a sensitivity setting subprogram, and the sensitivity setting key has two key values. When the key value is 0, the material is steel, and the sensitivity sk=10mv / μm. When the key value is 1, the material is aluminum, and the sensitivity sk=13.8mv / μm. The selected sensitivity setting key value is saved in the MCU ROM for calling. When the selected key value is 0, the steel sensitivity state display lamp is on, indicating that the current measured spindle material is steel. When the selected key value is 1, the aluminum sensitivity state display lamp is on, indicating that the current measured spindle material is aluminum.

5. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test and analysis system of claim 1, wherein: The MCU single-chip microcomputer is provided with an intelligent state recognition subprogram. When the MCU single-chip microcomputer is powered on and initialized, if the driving speed s>10 and the spindle speed n<10, the 2.7-inch OLED displays "spindle driving performance test" in the first row, the driving speed s display light is on, indicating that only the drive pulley rotates, the driving test state display light is on, and the load test state display light is off, indicating that the system is currently in the "spindle driving performance test" state; if the driving speed s>10 and the spindle speed n>10, the 2.7-inch OLED displays "spindle load performance test" in the first row, the driving speed s display light and the spindle speed n display light are on, indicating that the drive pulley rotates and the measured spindle also rotates, the driving test state display light is off, and the load test state display light is on, indicating that the system is currently in the "spindle load performance test" state; if neither of the above two conditions is met, i.e., the driving speed s<10 and the spindle speed n<10, at this time, the timeout function is triggered, the timeout time is set to 16.7 seconds, which is equivalent to the driving speed s<1 rpm, the system sets the driving speed s to zero, the 2.7-inch OLED displays "spindle comprehensive performance test" in the first row, the driving speed s display light and the spindle speed n display light are off, indicating that the drive pulley and the measured spindle stop rotating, the driving test state display light is off, and the load test state display light is off, indicating that the system is currently in the "spindle comprehensive performance test" state, i.e., the standby state.

6. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test and analysis system of claim 1, wherein: The first load measurement data processing subprogram, set the communication parameters, set the spindle parameters, send write frequency command, frequency Frequency resolution 0.01Hz; will adopt double optical fiber synchronous measurement drive speed s, spindle speed n, amplitude X, amplitude Y, torque T, power P-one corresponding frame data, with the selected spindle speed n interpolation interval, using linear interpolation method for real-time interpolation frame data, interpolation interval set ('50', '100', '200', '500', '1000') six grades, default '100'; receive / acquire data, data visualization drawing window, the first load measurement point line graph red, draw amplitude spectrum 4 real-time dynamic curve: X-axis amplitude, X-axis amplitude, XY axis synthetic amplitude: Axis center trajectory (e i ,θ i ), axis center trajectory peak Phase angle Draw the first load measurement torque spectrum 2 real-time dynamic curve: real-time dynamic torque T-drive speed s curve, real-time dynamic torque T-spindle speed n curve; draw the first load measurement power spectrum 2 real-time dynamic curve: real-time dynamic power P-drive speed s curve, real-time dynamic power P-spindle speed n curve.

7. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test and analysis system of claim 1, wherein: The secondary driving measurement and spindle characteristic parameter data processing subprogram: the frame data corresponding to the driving speed s, the spindle speed n=0, the amplitude X=0, the amplitude Y=0, the torque T, and the power P measured by the double optical fiber synchronous measurement are interpolated at the selected spindle speed n interval, the frame data is interpolated in real time by using the linear interpolation method, the data is received / captured, the data visualization drawing window, the secondary driving measurement point line graph is blue, the spindle characteristic parameter point line graph is brown, two real-time dynamic curves of the secondary driving measurement torque spectrum are drawn: the real-time dynamic torque T-driving speed s curve and the real-time dynamic torque T-spindle speed n curve; two real-time dynamic curves of the secondary driving measurement power spectrum are drawn: the real-time dynamic power P-driving speed s curve and the real-time dynamic power P-spindle speed n curve; the corresponding frame data of the first load measurement and the secondary driving measurement after real-time interpolation is subjected to difference operation, and the spindle characteristic parameter state display light is turned on, indicating that the current is in the spindle real-time characteristic parameter calculation state; the corresponding difference operation frame data of the first load measurement and the secondary driving measurement after real-time interpolation is used to draw two real-time dynamic curves of the spindle characteristic parameter torque spectrum: the spindle real-time dynamic torque T-driving speed s curve and the spindle real-time dynamic torque T-spindle speed n curve; two real-time dynamic curves of the spindle characteristic parameter power spectrum are drawn: the spindle real-time dynamic power P-driving speed s curve and the spindle real-time dynamic power P-spindle speed n curve.

8. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test analysis system of claim 1, wherein: The characteristic parameter report is acquired, the original experimental data subprogram is stored, when ending the secondary driving measurement, the characteristic parameter report is clicked to generate the WORD document: test file name, test time, set test parameter; all data visualization window screenshot, containing the first load measurement point line graph generated by the spindle speed N interpolation interval, red; secondary driving measurement point line graph, blue; The spindle characteristic parameter point line graph is brown; the characteristic parameter data table generated by the spindle speed N interpolation interval, containing: corresponding spindle speed N driving speed S, load measurement torque T, power P, secondary driving measurement torque T, power P, spindle torque T, power P; click to store the original experimental data to generate the real-time measurement data EXCEL table, including: driving speed s, spindle speed n, X-axis amplitude, Y-axis amplitude, XY-axis combined amplitude, axis trajectory, torque T, power P, measurement process attribute, measurement time point data; The intelligent automatic screen clearing subprogram: when ending the secondary driving measurement, acquiring the characteristic parameter report, storing the original experimental data, and continuing to measure the next sample, in the spindle parameter setting area, any change of a word can empty the original measurement data, point line graph, set a new file name, set the spindle parameters, start data collection, and enter a new round of load measurement process.

9. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test and analysis system of claim 1, wherein: The intelligent data acquisition and control subprogram is clicked to start data collection button, the program sends the read MCU data command to the serial port: 050300000006C44C, sends the write frequency converter forward operation control word: 0106200000120207, the frequency conversion motor starts operation, and receives the real-time driving speed s, spindle speed n, amplitude X, amplitude Y, torque T, and power P data returned by the MCU, when the first load measurement real-time spindle speed n≥set spindle speed N threshold is TRUE, it is indicated that the first load measurement is completed, the first load measurement is ended, the read MCU data command: 050300000006C44C is stopped to send, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, the frequency conversion motor stops operation, otherwise, it is FALSE, the read MCU data command: 050300000006C44C is continuously sent to continue data collection; when the secondary driving measurement real-time driving speed s≥set driving speed S threshold is TRUE, it is indicated that the secondary driving measurement is completed, the secondary driving measurement is ended, the read MCU data command: 050300000006C44C is stopped to send, the write frequency converter stop operation control word 01062000000143CA is sent to the serial port, the frequency conversion motor stops operation, otherwise, it is FALSE, the read MCU data command: 050300000006C44C is continuously sent to continue data collection.

10. The high speed spindle dual fiber optic digital smart dynamic power vibration signature test and analysis system of claim 1, wherein: The intelligent state recognition subroutine is: when the spindle speed n<10 is TRUE, it is determined that the current is in the secondary drive measurement state, the secondary drive measurement state display light is on, and the first load measurement state display light is off; when the spindle speed n<10 is FALSE, it is determined that the current is in the first load measurement state, the first load measurement state display light is on, and the secondary drive measurement state display light is off.

Images