VBA-based automatic processing device for bearing life data based on

A technology for processing device and bearing life, applied in the direction of electrical digital data processing, special data processing application, probability CAD, etc., can solve problems such as complicated calculation process, relatively high qualification requirements for data processing personnel, error-prone data processing, etc., to achieve convenience The effect of operation, improving work efficiency and work effect, and convenient installation

Pending Publication Date: 2021-11-26
C&U CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Although the relevant life parameters can be obtained in some data processing software through the above devices, the calculation process is relatively complicated, and usually requires manual cooperation and data processing to complete the calculation. On the one hand, the qualification requirements for data processing personnel are relatively high. On the other hand, when the amount of data is large, data processing is often error-prone
Moreover, the regression line of the existing device during operation is not the real Weibull distribution curve, but for the convenience of processing the graph obtained through function transformation, which ultimately cannot give a double-logarithmic Y-axis-logarithmic X-axis Weibull distribution plot

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • VBA-based automatic processing device for bearing life data based on
  • VBA-based automatic processing device for bearing life data based on
  • VBA-based automatic processing device for bearing life data based on

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The present invention is based on the bearing life data automatic processing device of VBA such as Figure 1-4 shown, including:

[0026] The failure data input module includes the first input area for inputting test life data, the second input area for marking whether the bearing is normally damaged or artificially cut off (corresponding to figure 2 The two columns A and B shown), where the data unit of each cell in column A is hour, each cell in column B contains a drop-down box, which can mark the bearing as "normal damage" or "artificial cut-off", column A There is no upper limit for data input, theoretically it can reach the input upper limit of the number of Excel table rows, and the input data of the test life does not need to be sorted from small to large, the program will automatically sort all the data;

[0027] The confidence level setting module includes a text box for inputting a specific value of the confidence level, which is set in the "C1:F5" area, an...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a VBA-based automatic processing device for bearing life data. The method comprises a failure data input module, a confidence level setting module, an effectiveness test module, a Weibull distribution probability paper generation module, a data point-line graph generation module, a fitted statistical parameter calculation and display module, a Weibull distribution parameter calculation and display module, a Weibull distribution formula expression display module and a failure probability and failure time calculation and display module. The method can be used for processing, analyzing, drawing, storing and the like of the service life data of the bearing simply and quickly, and can effectively improve the working efficiency and the working effect.

Description

technical field [0001] The invention relates to a VBA-based automatic processing device for bearing life data. Background technique [0002] The fatigue life of rolling bearings and the life of lubricating grease obey the Weibull distribution. It is necessary to arrange the sequence numbers and calculate the intermediate rank according to the data after the life test, and then fit the straight line according to the regression analysis device, and then calculate the bearing through the fitted parameters. shape parameter, scale parameter, F 10 (time corresponding to 10% bearing failure) F 50 (the time corresponding to 50% of the bearing failures), etc. [0003] Although the relevant life parameters can be obtained in some data processing software through the above devices, the calculation process is relatively complicated, and usually requires manual cooperation and data processing to complete the calculation. On the one hand, the qualification requirements for data processi...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F30/20G06F111/08G06F119/02G06F119/04
CPCG06F30/20G06F2119/02G06F2111/08G06F2119/04
Inventor 阚文彬刘斌杜帅强永席李贤
Owner C&U CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap