Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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 Welding Performance Data in Excel Format
Using the method of the present invention can solve the shortcomings of scattered and difficult to reuse welding test data, and can further upload the welding test data to the system in batches, realize the sharing of welding data and expand more application directions on the basis of this data

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

specific Embodiment approach

[0035] figure 1 Shown, a kind of embodiment of the method of the present invention is: a kind of method utilizing Excel format data processing welding performance data, comprises 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 sample after welding;

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

[0038] S220. According to the original data of the welding test, define a residual stress workbook in Excel format, the residual stress workbook includes a residual stress worksheet, a we...

Embodiment 2

[0049] figure 2 As shown, a specific embodiment 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 obtain the raw data of the welding test, including welding test data, welding test sample data, process data, 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 submodules: the process format definition submodule 210 is used to define the relationship between the Excel format and each process parameter in the process data The mapping relation between, obtains craft worksheet; Sample format definition submodule 220, is used for defining the mapping relation between each sample parameter in Excel format and sample data...

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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com