CN112784545B - Dynamic chart editing method of radioactive gamma nuclide report file - Google Patents
Dynamic chart editing method of radioactive gamma nuclide report file Download PDFInfo
- Publication number
- CN112784545B CN112784545B CN202010678570.1A CN202010678570A CN112784545B CN 112784545 B CN112784545 B CN 112784545B CN 202010678570 A CN202010678570 A CN 202010678570A CN 112784545 B CN112784545 B CN 112784545B
- Authority
- CN
- China
- Prior art keywords
- data
- dynamic
- nuclide
- file
- text
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E30/00—Energy generation of nuclear origin
- Y02E30/30—Nuclear fission reactors
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Measurement Of Radiation (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a dynamic chart editing method of a radioactive gamma nuclide report file, which comprises the following steps: step one, screening and judging the data in the RPT format report file, extracting keywords and the values of the keywords, and storing the keywords and the values in a memory. And step two, carrying out logic judgment, addition calculation, proportion calculation and DEI and DEX weighted calculation on the data in the memory, and assigning the calculated values together with the key words and the key word values to the nuclide buffer subtable. And thirdly, inserting the data of the nuclide buffer area into a data storage sub-table in a form of a table, wherein the data in the sub-table is associated with a dynamic table, so that trend analysis of the data is realized. The invention can improve the processing efficiency when the data file is imported into the form, and save the labor and time cost.
Description
Technical Field
The invention relates to a dynamic chart editing method of a radioactive gamma nuclide report file, and belongs to the technical field of file editing.
Background
The radioactive gamma nuclide analyzer measures radioactive samples to generate 4-5 pages of file reports in RPT format, and a plurality of samples have a plurality of file reports in RPT format. The file report in the RPT format cannot intuitively perform data comparison and trend analysis, and cannot dynamically display chart data. Since the electronic form has a defect on the function of text editing, the electronic form is very inconvenient to use in the process of editing the report file, and conventional text editing operation cannot be performed. Most text editors cannot create dynamic charts, which brings little trouble to report making, for example, when the same table changes in value, the table cannot change correspondingly according to the change of the content, and the chart needs to be redrawn in the chart editing system, which is troublesome. The traditional report file interpretation method can only manually search key data, copy target data into the electronic table through copying and pasting, and perform visual chart operation through a chart tool of the electronic table.
Chinese patent CN104156344A discloses a text editing method and device, and belongs to the technical field of computers. The text editing method comprises the steps of receiving a text editing operation, determining an editing starting point and an editing end point of the text editing operation in a text file, wherein the editing starting point is an offset position between a first character in text content requested to be edited and a starting position of the text file, and the editing end point is an offset position between a last character in the text content requested to be edited and an ending position of the text file, and storing the editing starting point, the editing end point and the text content between the editing starting point and the editing end point in a correlated mode according to the text editing operation. According to the method, a dynamic table cannot be inserted into a text, when the dynamic table is needed, a dynamic diagram is drawn through other diagram drawing devices and then is inserted in a static mode, and when text information is changed each time, the dynamic diagram is required to be drawn again, so that the method is very inconvenient.
The Chinese patent 106126489 discloses a text editing method and a text editing device, which provide a report file dynamic chart editing method and a report file dynamic chart editing system, wherein the report file dynamic chart editing method comprises the following steps: the text editing module sends an instruction for establishing a chart to the dynamic chart generating module. Step two: the dynamic chart generation module selects the text parallel typesetting required by the chart content according to the text content edited in the text editing module. Step three: and selecting a formula data model according to the selected text field content, and calculating the required data. Step four: and setting an abscissa and an ordinate according to the calculated data and the selected field, and establishing a chart according to the calculated data in the third step. Step five: and displaying the chart established in the fourth step in a text area edited by the text editing module. The limitation of the invention is that the data in the text cannot be calculated, and the data processing function of the radionuclide report, in particular the calculation of the iodine Dose Equivalent (DEI) and the xenon Dose Equivalent (DEX), cannot be satisfied.
Disclosure of Invention
The invention aims to realize the integrated comprehensive data processing of key data reading, data tabulation, nuclide statistics, trend analysis and the like of a radioactive gamma nuclide analysis report file.
In order to solve the technical problems, the technical scheme of the invention is to provide a dynamic chart editing method of a radioactive gamma nuclide report file, which is characterized by comprising the following steps:
step one, importing an RPT format report generated by a radioactive gamma nuclide analysis instrument into a dynamic electronic table, and finishing data judgment and screening while importing the data of the report, and rejecting a plain text or converting the plain text into a plain number; the judgment principle is that if the measurement result of the corresponding nuclide is ">12 half-life", the "activity at counting" is counted. In the following table, the "nuclide 2" is taken as an example, and the corrected activity corresponding to the "nuclide 2" is ">12 half-life", and thus the numerical calculation cannot be performed, and therefore the data is counted as "activity at count".
Step two, completing radionuclide addition operation, radionuclide proportion calculation and DEI and DEX weighting calculation at the same time of data import;
step three, simultaneously, storing all nuclide measurement activities and corresponding 'identifiers' in the corresponding data storage sub-tables of claim 1, storing the sub-tables in a classified manner according to file names, and arranging the sub-tables in a 'decay correction time (or sampling time)' description manner;
step four, synchronously updating the dynamic table and the trend graph while importing data, wherein the updating principle is that the dynamic table and the trend graph with the same characteristics as the imported file are generated; the table title of the dynamic table 'nuclide analysis tool' is synchronously updated according to the key character 'in the file name', and the data in the dynamic table and the trend chart are synchronously updated into historical data in the same category as the newly imported file; simultaneously, the table base color of the dynamic table is synchronously updated.
If the radionuclide analyzer format is reported as a TXT format file, the operation steps are identical.
The invention has the advantages that an analyst can import the radioactive gamma nuclide report file which cannot be analyzed in trend into the electronic form by only one-key operation and store the radioactive gamma nuclide report file in a nuclide database, and update the dynamic form to display the historical trend of each nuclide; the intelligent reading of the text type report file and the automatic of the nuclide data are realized, and the efficiency of radionuclide data management is greatly improved.
Drawings
FIG. 1 is a schematic diagram of a dynamic table generated in accordance with the method of the present invention;
FIG. 2 is a schematic diagram of a dynamic table generated in accordance with the method of the present invention.
Detailed Description
In order to make the invention more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Examples
The invention aims at the integrated comprehensive data processing of key data reading, data tabulation, nuclide statistics, trend analysis and the like of a radioactive gamma nuclide analysis report file.
The method is characterized in that an operator can import a specified radionuclide analysis file into a spreadsheet by only one-key operation, and the spreadsheet can store, calculate and form a dynamic chart sequentially.
In the process of performing electronic spreadsheet on the radioactive gamma nuclide report, all the radioactive gamma nuclide report is subjected to strict field screening and removal, and the header information only keeps 6 fields of sampling time, analysis time, nuclide cry, living time, analysis person and time difference. The table contents only retain the "post-correction activity" of the nuclide, the wild card.
In the process of electronically formatting the radionuclide report, when the corrected activity is not a numerical value, for example, a plain text format is ">12 half-life", the corrected activity takes the value of the corresponding nuclide, namely, the calculated activity. The following table is a directly imported data source,
the following table is the table style after the numerical format judgment:
in the process of performing electronic spreadsheet on the radionuclide report, the following statistical formula is automatically calculated:
DEI: iodine dose equivalents, weighted by the individual isotopes of iodine;
DEX: xenon dose equivalent, see the weighting of each isotope of xenon;
iodine Dose Equivalent (DEI), xenon Dose Equivalent (DEX)
Σ (gamma nuclide): the sum of all radionuclides activity;
I-131/I-133: the ratio of gamma nuclide iodine-131 to iodine-133;
Xe-133/Xe-135: the ratio of gamma nuclide xenon-133 to xenon-135;
Kr-88/Xe-133: the ratio of gamma nuclide krypton-85 to xenon-133.
After the radioactive gamma nuclides are imported into the electronic form, all the radioactive gamma nuclides are respectively stored according to sample types and used as data sources for dynamic form production in the future. The data storage style is shown in the following table:
for data sources that have been imported, a dynamic table 1 is made: the "sampling time" is taken as an abscissa, the nuclide name is taken as an ordinate, and the "corrected activity" of the nuclide is taken as a data value.
To improve the visualization effect of the dynamic graph, the above table needs to be screened: hiding the data containing "<" in the nuclide identifier, and only displaying the values with the activity larger than the detection limit.
In order to improve the trend analysis function of the dynamic chart, the comparison deviation of the newly introduced data and the latest 1 analysis value of the similar sample and the comparison deviation of the latest 6 analysis average value of the similar sample are added in the table.
In order to improve the historical trend comparison of the dynamic table, a transverse scroll bar is added, so that the nuclide analysis values in the table are switched in different time periods.
In order to improve the visual effect of the table, a sample type drop-down menu is set at the title position of the table. The drop down menu is operated to switch the data in the dynamic form among different sample types.
When the dynamic table sample types are switched, the table base color is synchronously changed, for example, the table base color is changed into light blue aiming at the sample data of the #1 machine set; for the #2 unit sample data, the table base color was switched to "light green".
To improve the visualization of the table, two rows of data in the dynamic table are biased, and the data bar change is performed.
To improve the visualization of the table, the "error value" in the deviation is automatically hidden.
To improve the visual effect of the table, when the value in the deviation is greater than "30%", the data is displayed in red; when the value in the deviation is less than "-30%", the value shows purple as shown in the following table:
for data sources that have been imported, a dynamic table 2 is made: the "sampling time" is taken as an abscissa, the nuclide name is taken as an ordinate, and the "corrected activity" of the nuclide is taken as a data value.
In order to improve the visual effect of the table, the dynamic table 2 only displays 6 lines of data, and is provided with a vertical scroll bar to realize the switching among nuclides.
In order to improve the visual effect of the table, a trend analysis graph line graph is made in the dynamic table 2, and the blank data are connected by using straight lines.
And (3) according to the 6 lines of data in the dynamic table 2, making a trend analysis graph line graph, setting a check box for each line of data, and determining whether the line of data is hidden or not through the check box.
By the processing method, an analyst can import the radioactive gamma nuclide report file which cannot be analyzed in trend into the electronic form by only one-key operation, store the radioactive gamma nuclide report file in the nuclide database, and update the dynamic form to display the historical trend of each nuclide. The intelligent reading of the text type report file and the automatic of the nuclide data are realized, and the efficiency of radionuclide data management is greatly improved.
The device is opened, the 'lead-in RPT/TXT file' button is clicked, the RPT format file to be read is selected, the report text file can be intelligently led into the customized electronic form according to the 'determination', and all functions of dynamic tabulation of the text file, automatic calculation of text data, automatic updating of trend graphs and the like can be completed, and the accompanying figures 1 and 2 are dynamic form schematic generated according to the method.
Claims (2)
1. The dynamic chart editing method of the radionuclide report file is characterized by comprising the following steps of:
step one, importing an RPT format report generated by a radioactive gamma nuclide analysis instrument into a dynamic electronic table, judging and screening data, removing a plain text or converting the plain text into a plain number;
step two, adding the radionuclides, calculating the proportion of the radionuclides, and weighting and calculating the iodine dose equivalent DEI and the xenon dose equivalent DEX;
step three, storing all nuclide measurement activities and corresponding identifiers in a data storage sub-table of the dynamic electronic table in the step one, classifying and storing the sub-table according to file names, and arranging according to attenuation correction time or sampling time in a description way; the dynamic electronic table is added with the comparison deviation of the newly-imported data and the latest 1-time analysis value of the same kind of sample and the comparison deviation of the latest 6-time analysis average value of the same kind of sample;
and step four, generating a dynamic table and a trend chart which have the same characteristics as the current imported file, and synchronously updating the data in the dynamic table and the trend chart into historical data of the same category as the new imported file.
2. The method of claim 1, wherein in the first step, the data determination principle is that if the measurement result of the corresponding nuclide is >12 half-life, the counting activity is counted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010678570.1A CN112784545B (en) | 2020-07-15 | 2020-07-15 | Dynamic chart editing method of radioactive gamma nuclide report file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010678570.1A CN112784545B (en) | 2020-07-15 | 2020-07-15 | Dynamic chart editing method of radioactive gamma nuclide report file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112784545A CN112784545A (en) | 2021-05-11 |
| CN112784545B true CN112784545B (en) | 2023-06-27 |
Family
ID=75750188
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010678570.1A Active CN112784545B (en) | 2020-07-15 | 2020-07-15 | Dynamic chart editing method of radioactive gamma nuclide report file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112784545B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113468834B (en) * | 2021-06-17 | 2024-01-05 | 深圳市一博科技股份有限公司 | Method for simplifying rpt file generation |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101202647A (en) * | 2006-12-13 | 2008-06-18 | 中兴通讯股份有限公司 | Dynamic generating report method for generating network report used in network planning and optimizing process |
| CN102509250A (en) * | 2011-11-03 | 2012-06-20 | 上海大学 | Automatic generation method for medical report |
| CN104156344A (en) * | 2014-07-21 | 2014-11-19 | 小米科技有限责任公司 | Text editing method and text editing device |
| CN106126489A (en) * | 2016-06-23 | 2016-11-16 | 江苏中威科技软件系统有限公司 | A kind of report file dynamic chart edit methods and system |
| CN109604316A (en) * | 2018-10-26 | 2019-04-12 | 中国辐射防护研究院 | A kind of radioactive pollution soil restoring technology screening technique |
| CN110913767A (en) * | 2017-07-25 | 2020-03-24 | 拜耳股份公司 | Device for the dosing of a radiopharmaceutical to a body part |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7348564B2 (en) * | 2005-12-12 | 2008-03-25 | General Electric Company | Multi modality imaging methods and apparatus |
-
2020
- 2020-07-15 CN CN202010678570.1A patent/CN112784545B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101202647A (en) * | 2006-12-13 | 2008-06-18 | 中兴通讯股份有限公司 | Dynamic generating report method for generating network report used in network planning and optimizing process |
| CN102509250A (en) * | 2011-11-03 | 2012-06-20 | 上海大学 | Automatic generation method for medical report |
| CN104156344A (en) * | 2014-07-21 | 2014-11-19 | 小米科技有限责任公司 | Text editing method and text editing device |
| CN106126489A (en) * | 2016-06-23 | 2016-11-16 | 江苏中威科技软件系统有限公司 | A kind of report file dynamic chart edit methods and system |
| CN110913767A (en) * | 2017-07-25 | 2020-03-24 | 拜耳股份公司 | Device for the dosing of a radiopharmaceutical to a body part |
| CN109604316A (en) * | 2018-10-26 | 2019-04-12 | 中国辐射防护研究院 | A kind of radioactive pollution soil restoring technology screening technique |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112784545A (en) | 2021-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20050183002A1 (en) | Data and metadata linking form mechanism and method | |
| CN110825364B (en) | Application template configuration method based on tree structure | |
| CN104881275A (en) | Electronic spreadsheet generating method and device | |
| CN113822037B (en) | Method, device, equipment and medium for inserting placeholder and generating data mapping table | |
| US20050240562A1 (en) | Method, computer program product and device for importing a plurality of data sets into a system | |
| CN112883042A (en) | Data updating and displaying method and device, electronic equipment and storage medium | |
| CN112784545B (en) | Dynamic chart editing method of radioactive gamma nuclide report file | |
| CN110083814A (en) | A kind of report form generation method and device, computer readable storage medium | |
| CN112434033B (en) | Method for collecting and displaying flexible and changeable table type data | |
| WO2023125032A1 (en) | Scientific research data change review method based on data snapshot, and server | |
| CN112966482A (en) | Report generation method, device and equipment | |
| CN111598535A (en) | Basic material importing method and system and computer equipment | |
| CN113360603B (en) | Contract similarity and compliance detection method and device | |
| CN112486989B (en) | Multi-source data granulation fusion and index classification and layering processing method | |
| CN113806661A (en) | Website information barrier-free detection tool | |
| CN113297831A (en) | Method and system for generating verifiable report webpage by Excel | |
| CN111708814A (en) | Data statistical method, device, equipment and medium | |
| US20020156597A1 (en) | Inspection report generation software | |
| CN111143353A (en) | Method for extracting BOM change data from change list | |
| CN115587098A (en) | Method and system for intelligently identifying chart data | |
| CN115906213A (en) | Editing method and system of visual chess evaluation statistical model | |
| CN114968348A (en) | Data analysis method and device, electronic equipment and storage medium | |
| CN107943872A (en) | Graphical document generating method and system | |
| CN106649724A (en) | Information display method and device and user terminal | |
| Liu et al. | Extraction of attribute dependency graph from database applications |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |