CN103678266A - Automatic processing system for fracture toughness test results of metallic materials - Google Patents
Automatic processing system for fracture toughness test results of metallic materials Download PDFInfo
- Publication number
- CN103678266A CN103678266A CN201310711380.5A CN201310711380A CN103678266A CN 103678266 A CN103678266 A CN 103678266A CN 201310711380 A CN201310711380 A CN 201310711380A CN 103678266 A CN103678266 A CN 103678266A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- output
- window
- data input
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Investigating Strength Of Materials By Application Of Mechanical Stress (AREA)
Abstract
The invention discloses an automatic processing system for fracture toughness test results of metallic materials. The automatic processing system comprises a data input and output system and a report sending system which is in communication with the data input and output system, wherein the data input and output system comprises a data input window and a result output window; a textbox and other contents of the data input window are designed according to paper original data; the result output window outputs the test results in sequence, judges whether the test results are valid or not, and calculates data results according to validity criteria; the report sending system comprises a report input window and a report output window, a textbox and other contents of the report input window are designed according to paper test reports, and the report output window outputs the test results and data. The automatic processing system is based on Excel spreadsheet software and can store and calculate the input data and send the reports, and therefore full automation of data processing of fracture toughness tests of the metallic materials and report sending can be achieved.
Description
Technical field
The present invention relates to automatic data processing technical field, in particular, relate to a kind of Fracture of Metal Material toughness test result automated processing system.
Background technology
The processing of the test findings of the fracture toughness test carrying out for metal material employing compact tensile specimen, prior art is by the artificial test method according to product standard appointment, to determine whether effective K1C data after calculating result, and the metal material of testing according to navigation mark can also judge whether null result is significant KQ data.At present, Plane Strain Fracture Toughness is tested the general coordinative experiments software result of calculation by testing equipment and is judged the part requirement of test standard, and adopt, manually calculate other requirements, and use WORD to send report, although carrying out fatigue tester and the cupping machine of fracture toughness test, Dan Ge testing laboratory can provide test findings, but cannot judge whole requirements of the whether Pass Test standard of testing, whether still need testing crew manually to calculate test meets the requirements, and use the office softwares such as WORD to send report, labor intensive.
Therefore, realizing the data processing of Fracture of Metal Material toughness test and the full automation that report sends, is those skilled in the art's problem demanding prompt solutions.
Summary of the invention
In view of this, the invention provides a kind of Fracture of Metal Material toughness test result automated processing system, to overcome in prior art, owing to still needing testing crew manually to calculate test, whether meet the requirements, and use the office softwares such as WORD to send report, cause the problem of labor intensive.
For achieving the above object, the invention provides following technical scheme:
A Fracture of Metal Material toughness test result automated processing system, comprising: data input-output system and the report transmitting system being connected by communication with described data input-output system, wherein,
Described data input-output system comprises data input window and result output window, the content basis papery raw data designs such as the text box of described data input window, described result output window is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result;
The content basis papery laboratory reports such as described report transmitting system comprises report input window and report output window, the text box of described report input window design, described report output window is by described test findings and data output.
Preferably, also comprise:
The storage system being connected with described report transmitting system with described data input-output system respectively, for carrying out the storage of system by described test findings and data.
Wherein, described data input window is two worksheets.
Preferably, described data input window comprises data calculating and stores worksheet, back-up job table.
Wherein, described report input window is four worksheets.
Preferably, described report input window comprises:
The product standard of supporting and corresponding sampling standard, test method, alloy state thereof, define the parameter limit worksheet of available measurer, testing crew;
The standard limit value worksheet of the fracture toughness ultimate value of product standard defined;
The report template worksheet of the test report template of well in advance;
And the report raw data worksheet of depositing the raw data of report and the report gauge outfit data of report input window input.
Known via above-mentioned technical scheme, compared with prior art, the invention discloses a kind of Fracture of Metal Material toughness test result automated processing system, this system comprises: data input-output system and the report transmitting system being connected by communication with described data input-output system, wherein, described data input-output system comprises data input window and result output window, the content basis papery raw data designs such as the text box of described data input window, described result output window is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result, the content basis papery laboratory reports such as described report transmitting system comprises report input window and report output window, the text box of described report input window design, described report output window is by described test findings and data output.This system is based on excel spreadsheet lattice software, and the Data Concurrent that can store, calculate input goes out report, realizes the data processing of Fracture of Metal Material toughness test and the full automation that report sends.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skills, do not paying under the prerequisite of creative work, other accompanying drawing can also be provided according to the accompanying drawing providing.
Fig. 1 is the disclosed a kind of Fracture of Metal Material toughness test result automated processing system structural representation of the embodiment of the present invention;
Fig. 2 is the disclosed another kind of Fracture of Metal Material toughness test result automated processing system structural representation of the embodiment of the present invention;
Fig. 3 is the exemplary plot of the disclosed data input-output system of the embodiment of the present invention;
Fig. 4 is the exemplary plot of the disclosed report transmitting system of example of the present invention;
Fig. 5 is the report exemplary plot that the disclosed report transmitting system of example of the present invention is sent.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
The invention discloses a kind of Fracture of Metal Material toughness test result automated processing system, this system comprises: data input-output system and the report transmitting system being connected by communication with described data input-output system, wherein, described data input-output system comprises data input window and result output window, the content basis papery raw data designs such as the text box of described data input window, described result output window is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result; The content basis papery laboratory reports such as described report transmitting system comprises report input window and report output window, the text box of described report input window design, described report output window is by described test findings and data output.This system is based on excel spreadsheet lattice software, and the Data Concurrent that can store, calculate input goes out report, realizes the data processing of Fracture of Metal Material toughness test and the full automation that report sends.
Refer to accompanying drawing 1, Fig. 1 is the disclosed a kind of Fracture of Metal Material toughness test result automated processing system structural representation of the embodiment of the present invention.The disclosed a kind of Fracture of Metal Material toughness test result automated processing system of the embodiment of the present invention, this system concrete structure comprises: data input-output system 101 and the report transmitting system 102 being connected by communication with described data input-output system 101, wherein, described data input-output system 101 comprises data input window 103 and result output window 104, the content basis papery raw data designs such as the text box of described data input window 103, described result output window 104 is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result, the content basis papery laboratory reports such as described report transmitting system 102 comprises report input window 105 and report output window 106, the text box of described report input window 105 design, described report output window 106 is by described test findings and data output.
This system is based on excel spreadsheet lattice software, and the Data Concurrent that can store, calculate input goes out report, realizes the data processing of Fracture of Metal Material toughness test and the full automation that report sends.
Preferably, refer to accompanying drawing 2, Fig. 2 is the disclosed another kind of Fracture of Metal Material toughness test result automated processing system structural representation of the embodiment of the present invention.This system, except comprising system described above, also comprises: the storage system 107 being connected with described report transmitting system 102 with described data input-output system 101 respectively, and for described test findings and data are carried out to the storage of system.
This system is stored test findings and data by storage system, facilitates follow-up the transferring and using of data of carrying out.
The present invention is directed to laboratory applications, by excel spreadsheet lattice and subsidiary VBA programming language thereof, provide a kind of program that has input/output function.Form of the present invention is with grand Excel book, comprises at least 6 worksheets, two input windows and a series of self-defining function in book.Six worksheets are respectively data calculating and storage, backup, parameter limit, standard limit value, report template, report raw data table; Two input windows complete respectively data input and send report.
Wherein, described data input window is two worksheets.
Wherein, described data input window comprises data calculating and stores worksheet, back-up job table.
Wherein, described report input window is four worksheets.
Wherein, described report input window comprises:
The product standard of supporting and corresponding sampling standard, test method, alloy state thereof, define the parameter limit worksheet of available measurer, testing crew;
The standard limit value worksheet of the fracture toughness ultimate value of product standard defined;
The report template worksheet of the test report template of well in advance;
And the report raw data worksheet of depositing the raw data of report and the report gauge outfit data of report input window input.
Refer to accompanying drawing 3, Fig. 3 is the exemplary plot of the disclosed data input-output system of the embodiment of the present invention.According to a kind of Fracture of Metal Material toughness test result automated processing system described above, for data input-output system, be described as: data input-output system main body comprises three parts: the one, 62 cells of a line, the raw data that comprises individual sample and every calculating formula, do not have the blank line of raw data to be kept in back-up job table, result computing formula is from ASTM E399, and the judgment formula of the requirement of test standard is write according to standard-required; The 2nd, data input window, clicks " input " button after input data, first blank line is copied to data and calculates and store worksheet and cell corresponding to raw data carried out to assignment; The 3rd, result output window, blank line by assignment after Excel whether automatically calculate requirement the judgement test of test findings and test standard effective, and by output window, whole result of calculation is returned.Click " input " button, data will be kept at data and calculate and store worksheet, click " only seeing result " button, and data will can not preserved.
Report transmitting system is described: report transmitting system comprises two parts: the one, and report input window, is used for inputting the every data relevant to report; Two is four worksheets.Parameter limit table worksheet is product standard and corresponding sampling standard, test method, alloy state thereof, defines available measurer, testing crew etc.; Standard limit value worksheet is the fracture toughness ultimate value of product standard defined; Report template worksheet is the test report template of well in advance, and report raw data worksheet is deposited the raw data of report and the report gauge outfit data of report input window input.
Refer to accompanying drawing 4 and accompanying drawing 5, Fig. 4 is the exemplary plot of the disclosed report transmitting system of example of the present invention, and Fig. 5 is the report exemplary plot that the disclosed report transmitting system of example of the present invention is sent.According to above-mentioned description, its report process of transmitting is: the selected data of having inputted in the worksheet of save data, open report input window.The report input window partial data that VBA program obtains from parameter limit table worksheet according to the data of having inputted while opening, now only need fill in report number, heat number, order number, thermal treatment lot number, selects measurer, personnel.Click " generating report " button, VBA program copies to the assigned address in report raw data worksheet by the raw data in " boat material is placed " worksheet, and the data assignment in report input window is to the designating unit lattice of reporting in raw data worksheet.After report template worksheet calculates automatically, reproduction replica is to this book, VBA carries out assign operation to whole cells in copy, then indefinite for content in template but comprise now Chinese and English or needs on, lower target cell carries out Set font operation, because Excel is different from Word, font Chinese and English arranges separately in full, and the definite text of formula can not be gone up subscript, therefore these two kinds of operations all need programming, set font character by character, after Set font, this copy is clipped in a new book, then by this new book according to " date. lot number. report number. fracture toughness " form automatically save as Excel file and pdf document.
For the test report of output, its test report form is inventor place laboratory report form, horizontal A4 antiquarian, front-back two-sided printing.Whole report is comprised of 158 * 77 cells (A1:GB77), the wide about 1.67mm of each cell.Report adopts a large amount of junior unit lattice and the VBA method that character sets font one by one to reach the effect of similar Word, finally saves as PDF and is convenient to the transmission of file between different system.
In sum: the invention discloses a kind of Fracture of Metal Material toughness test result automated processing system, this system comprises: data input-output system and the report transmitting system being connected by communication with described data input-output system, wherein, described data input-output system comprises data input window and result output window, the content basis papery raw data designs such as the text box of described data input window, described result output window is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result; The content basis papery laboratory reports such as described report transmitting system comprises report input window and report output window, the text box of described report input window design, described report output window is by described test findings and data output.This system is based on excel spreadsheet lattice software, and the Data Concurrent that can store, calculate input goes out report, realizes the data processing of Fracture of Metal Material toughness test and the full automation that report sends.
Above-mentioned explanation to the disclosed embodiments, makes professional and technical personnel in the field can realize or use the present invention.To the multiple modification of these embodiment, will be apparent for those skilled in the art, General Principle as defined herein can, in the situation that not departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to these embodiment shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (6)
1. a Fracture of Metal Material toughness test result automated processing system, is characterized in that, comprising: data input-output system and the report transmitting system being connected by communication with described data input-output system, wherein,
Described data input-output system comprises data input window and result output window, the content basis papery raw data designs such as the text box of described data input window, described result output window is output test result successively, and judge that whether described test findings is effective, and according to validity criterion computational data result;
The content basis papery laboratory reports such as described report transmitting system comprises report input window and report output window, the text box of described report input window design, described report output window is by described test findings and data output.
2. system according to claim 1, is characterized in that, also comprises:
The storage system being connected with described report transmitting system with described data input-output system respectively, for carrying out the storage of system by described test findings and data.
3. system according to claim 1, is characterized in that, described data input window is two worksheets.
4. system according to claim 3, is characterized in that, described data input window comprises data calculating and stores worksheet, back-up job table.
5. system according to claim 1, is characterized in that, described report input window is four worksheets.
6. system according to claim 5, is characterized in that, described report input window comprises:
The product standard of supporting and corresponding sampling standard, test method, alloy state thereof, define the parameter limit worksheet of available measurer, testing crew;
The standard limit value worksheet of the fracture toughness ultimate value of product standard defined;
The report template worksheet of the test report template of well in advance;
And the report raw data worksheet of depositing the raw data of report and the report gauge outfit data of report input window input.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310711380.5A CN103678266A (en) | 2013-12-20 | 2013-12-20 | Automatic processing system for fracture toughness test results of metallic materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310711380.5A CN103678266A (en) | 2013-12-20 | 2013-12-20 | Automatic processing system for fracture toughness test results of metallic materials |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103678266A true CN103678266A (en) | 2014-03-26 |
Family
ID=50315878
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310711380.5A Pending CN103678266A (en) | 2013-12-20 | 2013-12-20 | Automatic processing system for fracture toughness test results of metallic materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103678266A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943776A (en) * | 2017-12-12 | 2018-04-20 | 国网山东省电力公司淄博供电公司 | One-touch power cable test report automatic creation system and method |
| CN115562979A (en) * | 2022-09-27 | 2023-01-03 | 上海艾柯检测科技有限公司 | Method for automatically generating test report based on artificial intelligence |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1435772A (en) * | 2002-01-31 | 2003-08-13 | 佳能株式会社 | Information processing device and method |
| US6895364B2 (en) * | 2000-08-30 | 2005-05-17 | Paul Banfer | Materials analytical review and reporting system |
| CN101615176A (en) * | 2009-08-07 | 2009-12-30 | 北京协成致远网络科技有限公司 | A kind of data monitoring system and implementation method |
-
2013
- 2013-12-20 CN CN201310711380.5A patent/CN103678266A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6895364B2 (en) * | 2000-08-30 | 2005-05-17 | Paul Banfer | Materials analytical review and reporting system |
| CN1435772A (en) * | 2002-01-31 | 2003-08-13 | 佳能株式会社 | Information processing device and method |
| CN101615176A (en) * | 2009-08-07 | 2009-12-30 | 北京协成致远网络科技有限公司 | A kind of data monitoring system and implementation method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943776A (en) * | 2017-12-12 | 2018-04-20 | 国网山东省电力公司淄博供电公司 | One-touch power cable test report automatic creation system and method |
| CN115562979A (en) * | 2022-09-27 | 2023-01-03 | 上海艾柯检测科技有限公司 | Method for automatically generating test report based on artificial intelligence |
| CN115562979B (en) * | 2022-09-27 | 2023-04-25 | 上海艾柯检测科技有限公司 | Method for automatically generating test report based on artificial intelligence |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Zhou et al. | Generalized asymmetric linguistic term set and its application to qualitative decision making involving risk appetites | |
| Dahlin et al. | Integrated management systems–interpretations, results, opportunities | |
| CN106874244A (en) | A kind of construction method of the document Auto-generation Model based on work sequence | |
| Karmakov et al. | Numerical analysis of the delamination in CFRP laminates: VCCT and XFEM assessment | |
| CN102074080A (en) | Customization and management method of visual management invoice template | |
| CN106909604B (en) | Automatic checking method and system for EXCEL form and ACCESS database based on rules | |
| Vasarhelyi | Formalization of standards, automation, robots, and IT governance | |
| CN105894183A (en) | Project evaluation method and apparatus | |
| Mavrov | Software for intercriteria analysis: working with the results | |
| CN103678266A (en) | Automatic processing system for fracture toughness test results of metallic materials | |
| KR100982527B1 (en) | Total Dimensional Accuracy Control System and Method for Block Assembly | |
| CN107767242A (en) | Accounting data processing method and accounting data processing unit | |
| Girgenti et al. | Development of a custom software for processing the stress corrosion experimental data through Axiomatic Design | |
| CN106155665A (en) | Accordance puts to the proof system and method | |
| Zappalorto et al. | Nonlinear mode III crack stress fields for materials obeying a modified Ramberg‐Osgood law | |
| Reisinger et al. | Lead, cadmium and mercury flow analysis–decision support for Austrian environmental policy | |
| CN112231111A (en) | Data pasting method and device, electronic equipment and storage medium | |
| CN104699916B (en) | A kind of general multisample scenario generation method and system | |
| CN104850722B (en) | A kind of CAPP process automatically generates and update system and method | |
| Volderauer et al. | 3-dimensional numerical calculations considering geotechnical measurement data | |
| Burn-Thornton et al. | The use of data mining to indicate virtual (email) bullying | |
| Crawford et al. | A web-based tool for streamlining environmental decision-making in building design | |
| CN112184853B (en) | Gauge construction method and device, electronic equipment and storage medium | |
| Hans | Accelerating biological screenings through the combination of high-throughput and modeling | |
| de Sena Monteiro Ozelim et al. | NorSand4AI: A Comprehensive Triaxial Test Simulation Database for NorSand Constitutive Model Materials |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140326 |
|
| RJ01 | Rejection of invention patent application after publication |