Method and system utilizing Excel format data to process welding performance data

A technology of welding performance and format data, which is applied in the fields of electrical digital data processing, natural language data processing, and special data processing applications, etc., which can solve the difficulty of unifying and using welding raw data and performance data, scattered welding test data, and inconvenient use and other problems, to achieve the effect of convenient and quick arrangement of records, optimization of welding parameters, and convenient use

Active Publication Date: 2016-05-04
SOUTHWEST JIAOTONG UNIV
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The first object of the present invention is to solve the technical problems such as complex and diverse welding raw data and performance data, which are difficult to organize and use in a unified manner, and the data after sorting is not intuitive, complicated, and inconvenient to use, etc., to provide a Method of Processing

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
  • Method and system utilizing Excel format data to process welding performance data
  • Method and system utilizing Excel format data to process welding performance data

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0034] Example one

Example Embodiment

[0035] figure 1 It is shown that a specific implementation of the method of the present invention is: a method for processing welding performance data using Excel format data, including the following steps:

[0036] S100. Obtain the original data of the welding test, including welding test data, welding test sample data, process data, and fatigue test data and residual stress test data of the welded sample;

[0037] S210. Use an Excel format to define a fatigue test workbook according to the raw data of the welding test. The fatigue test workbook includes a fatigue worksheet, a welding test worksheet, a sample worksheet, and a process worksheet; and then according to the fatigue test Data, use Excel format to define the fatigue performance parameter mapping relationship in the fatigue worksheet;

[0038] S220. Define a residual stress workbook using Excel format according to the original data of the welding test. The residual stress workbook includes a residual stress worksheet, a we...

Example Embodiment

[0048] Example two

[0049] figure 2 It is shown that a specific implementation of the system of the present invention is: a system for processing welding performance data using Excel format data, including:

[0050] The welding raw data acquisition module 100 is used to acquire the raw data of the welding test, including welding test data, sample data of the welding test, process data, and fatigue test data and residual stress test data of the sample after welding;

[0051] The Excel format definition module 200 is used to define the mapping relationship between Excel cells and attributes according to the welding test data, and specifically includes the following sub-modules: The process format definition sub-module 210 is used to define the Excel format and the process parameters in the process data The process worksheet is obtained by the mapping relationship between the samples; the sample format definition submodule 220 is used to define the mapping relationship between the Ex...

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 discloses a method and system utilizing Excel format data to process welding performance data. The method comprises the following steps: acquiring original welding data; utilizing the Excel format to define a fatigue test workbook and a residual stress workbook, and utilizing the Excel format to define the mapping relations of performance parameters in a fatigue worksheet, a residual stress worksheet, welding test worksheets, sample worksheets and process worksheets in the workbooks; examining whether the parameter format in each worksheet is correct or not; analyzing the contents of each worksheet, and saving item by item the data from each worksheet in a data array through the circular processing method; and according to the obtained data array, saving in batches fatigue performance parameter information, residual stress parameter information, welding test parameter information, sample parameter information and process parameter information in a database. The method and system provided by the invention have the advantages that the Excel format data is utilized to integrate and describe welding performances, so that the data complexity is greatly reduced, and the data is clearer and more intuitive to be conveniently read and processed for use.

Description

technical field [0001] The invention relates to the welding field of material engineering, in particular to a method and system for describing welding performance data by using Excel format data and realizing batch processing of data. Background technique [0002] At present, in the welding test of material engineering, a large amount of welding raw data will be generated. There are many ways to sort out the complex raw data. same. Due to the lack of advanced and applicable welding test data management methods, it is very difficult for scientific research units to maintain and use the welding test data, and it is difficult to guarantee the integrity, consistency, security and availability of the data, and it is impossible to dig out the data buried in the test data. the knowledge in it. Welding test data is very important for the verification and research of high-speed rail welding fatigue and residual stress. Welding test is an indispensable and important technology in th...

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
IPC IPC(8): G06F17/30G06F17/24
CPCG06F16/289G06F40/166
Inventor 陈辉苟国庆孙昀涛
Owner SOUTHWEST JIAOTONG UNIV
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