Hazardous waste label generation method

Abstract

The invention relates to a hazardous waste label generation method, which comprises the following steps of: acquiring a printing signal, acquiring a waste name from a hazardous waste generation link record table entry specified by the printing signal, comparing the waste name with a waste name in a hazardous waste comparison table, finding out the same value, determining the entry where the same value is located, and generating a hazardous waste label; attribute data of the waste in the hazardous waste comparison table are taken, and a hazardous waste label template is filled in according to the attribute data; obtaining a production date from a hazardous waste production link record table entry specified by the printing signal, and writing the production date into a hazardous waste label template; obtaining weight information from a hazardous waste generation link record table entry specified by the printing signal, and writing the weight information into a hazardous waste label template; generating a digital identification code and writing the digital identification code into a hazardous waste label template to form a hazardous waste label; and printing and outputting the hazardous waste label. Through the hazardous waste comparison table, most of the content needing to be filled in can be directly written into the hazardous waste label, and the printing speed of the hazardous waste label is greatly increased.

Description

Technical Field

[0001] The present invention relates to the technical field of hazardous waste treatment, and in particular to a method for generating hazardous waste labels. Background Art

[0002] Hazardous waste refers to solid waste and liquid waste that has any of the following conditions and is included in the national hazardous waste list according to the national hazardous waste identification standards and identification methods: (i) having one or more hazardous characteristics such as corrosiveness, toxicity, flammability, reactivity or infectivity; (ii) having hazardous characteristics that may cause harmful effects on the environment or human health and need to be managed as hazardous waste. The management of hazardous waste in industry is a key management project for safe production.

[0003] The chemical, oil refining, metal, mining, machinery and pharmaceutical industries produce more types of hazardous wastes and larger data, while general production enterprises produce fewer types of hazardous wastes. In addition, since the business scope of each company is relatively fixed, the types of hazardous wastes produced are also fixed. According to the "Law of the People's Republic of China on the Prevention and Control of Environmental Pollution by Solid Wastes", hazardous wastes need to establish a special ledger and be managed by a dedicated person.

[0004] The existing technology provides many solutions for the management of hazardous wastes. For example, my country's invention patent CN202010657611.9 provides a method for the full supervision of hazardous wastes, which manages the generation, transportation, and treatment of hazardous wastes; my country's patent application CN202011062885.X uses electronic tags to control the material flow status of hazardous wastes in the disposal site, which is convenient for the full tracking of materials. my country's patent application CN202311234821.7 provides a generally applicable hazardous waste label printing method, hazardous waste storage method, system, and medium, which performs data processing based on traditional databases and can be used for hazardous waste key focus units and general small-scale hazardous waste management enterprises.

[0005] The label printing disclosed in CN202311234821.7 is based on the extraction and collection of data from the warehouse database. The warehouse database is usually a ledger database established by the enterprise. There are many items recorded in the ledger database, including all the information of each hazardous waste. This solution extracts part of the data required for the hazardous waste label from the ledger database, and the amount of data calculation is extremely large; it "generates a QR code based on the storage record information" and "creates a label interface on the terminal device, and arranges the received storage record information and the QR code in the label interface to obtain a pre-printed label;" This project requires dedicated equipment and a relatively large data processing system.

[0006] Among the hazardous wastes of general enterprises, there are only a few or a dozen fixed types. The traditional management of hazardous wastes uses manual ledgers and handwritten paper labels to record and mark hazardous wastes. The more tedious work is mainly in the production and posting of labels. Each hazardous waste is also required to post a label that matches its waste name, waste category, waste code, waste form, hazardous characteristics, main components, and harmful components. Handwritten labels are tedious and prone to errors and will take up a lot of manpower and time costs. It is obviously not economical to use the solution disclosed in the above patent to solve the problem of label printing. Summary of the invention

[0007] The technical problem to be solved by the present invention is the problem that the printing efficiency of hazardous waste labels is low and errors are easy to occur.

[0008] The present invention solves the above-mentioned problem by adopting the following technical solution: A method for generating hazardous waste labels: The first step is to establish a record sheet for the generation of hazardous waste; The second step is to establish a hazardous waste comparison table based on the types of hazardous waste that can be generated. The hazardous waste comparison table includes the names of hazardous wastes and corresponding attribute data; The third step is to create a hazardous waste label template; The fourth step is to register hazardous wastes and fill in the hazardous waste generation record form; Step 5: Get the print signal, get the waste name from the hazardous waste generation link record table entry specified by the print signal, compare it with the waste name in the hazardous waste comparison table, find the same value in the hazardous waste comparison table and determine its entry position in the hazardous waste comparison table, and fill in the hazardous waste label template according to the content of the entry; Step 6: Obtain the date of generation from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; obtain the weight information from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; generate a digital identification code and write it into the hazardous waste label template to form a hazardous waste label; Step 7: Print out the hazardous waste label.

[0009] Compared with the prior art, the present invention using the above method has the following beneficial effects: The present invention provides a concise data processing method. By establishing a hazardous waste comparison table specifically serving hazardous waste labels, most of the content that needs to be filled in can be directly written in, which solves the problem of repeatedly filling in the same content each time a new label is created. Most of the data in the hazardous waste label comes from a fixed record table, which avoids errors caused by manual real-time input of newly entered content, saves repeated content verification work, and greatly improves the printing speed of hazardous waste labels.

[0010] As a preferred embodiment, a further technical solution of the above structure is: Specifically, the attribute data in the hazardous waste comparison table include waste category, waste code, waste form, main components, harmful components, precautions and hazardous characteristics.

[0011] Furthermore, the hazardous waste generation link record table and hazardous waste comparison table are prepared based on EXCEL, and the calculation function in EXCEL is used to automatically fill in the hazardous waste generation link record table with the corresponding attribute data in the hazardous waste comparison table after the waste name is entered into the hazardous waste generation link record table.

[0012] Preferably, obtaining the generation date from the hazardous waste generation link record table is specifically as follows: first locate the generation batch coding data of the hazardous waste, and extract the numbers representing the year, month and day; obtaining the weight information from the hazardous waste generation link record table is specifically as follows: first locate the generation quantity data of the hazardous waste, extract its value, and then extract the data in the measurement unit and combine them.

[0013] Optionally, the digital identification code is generated by combining the organization code of the hazardous waste management entity, some characters of the batch code generated in the record table of the hazardous waste generation link, and some characters in the hazardous waste code.

[0014] When the obtained printing signal is for printing multiple items, a corresponding number of hazardous waste labels are generated in sequence according to the item numbers. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 It is an existing handwritten label; Figure 2 It is a data processing block diagram of the present invention; Figure 3 is a label generated by the present invention; Figure 4 It is the hazardous waste account template of the present invention; Figure 5 This is an example of hazardous waste ledger data of the present invention; Figure 6 It is the hazardous waste comparison table of the present invention. DETAILED DESCRIPTION

[0016] The present invention will be further described below in conjunction with embodiments, the purpose of which is only to provide a better understanding of the content of the present invention. Therefore, the examples given do not limit the protection scope of the present invention.

[0017] 1. Existing tools and working conditions: Hazardous waste electronic ledger: mainly includes the following parts: "Hazardous waste generation link record form", "Hazardous waste storage link record form", "Hazardous waste outbound link record form", "Hazardous waste outsourcing utilization / disposal record form", each form mainly contains the following information: code, time, hazardous waste name, code, weight, container packaging code, etc. Some data need to be filled in multiple tables at the same time, and each weighing record needs to be recorded, so the workload of writing or entering is relatively large, and there are many repeated contents to fill in. Handwritten ledgers are particularly cumbersome and complicated.

[0018] Hazardous waste label: produced when hazardous waste is put into storage, and is issued together with the "Hazardous Waste Generation Record Form". The original form is empty and all items need to be filled in manually. Figure 1 The specific items that need to be filled in include waste name, waste category, waste code, waste form, hazardous characteristics, main components, harmful components, precautions, name of generating / collecting unit, contact person, contact information, generation date, waste weight and remarks.

[0019] Taking power generation enterprises as an example, their common hazardous wastes include waste oil, waste oil drums, waste paint drums, laboratory waste liquid, waste reagent bottles, etc. Although the types of hazardous wastes are different, each type of hazardous waste generated in the actual operation process has fixed corresponding relevant information (such as waste oil drums, the waste category in its classification information must be filled in as HW08, and the waste code must be filled in as 900-249-08. This is determined in accordance with the "National List of Hazardous Wastes (2021 Edition)". In terms of physical and chemical characteristics, the waste form must be solid, and the main components, harmful components, etc. are also constant due to fixed production and operation, and belong to quantitative information. The actual weight of the waste and the time of generation are filled in according to the actual situation, which is variable information.

[0020] The present invention studies the internal logical relationship of hazardous waste ledgers, establishes hazardous waste ledgers based on EXCEL, simplifies the process and manual input workload through built-in functions, and uses Visual Basic programming language to print hazardous waste labels in batches.

[0021] For details, see Figure 2 , Figure 3 The overall concept of the method for generating hazardous waste labels provided by the present invention is: The first step is to establish a record sheet for the generation of hazardous waste; The second step is to establish a hazardous waste comparison table based on the types of hazardous waste that may occur. The hazardous waste comparison table includes the names of hazardous wastes and the corresponding attribute data; The third step is to create a hazardous waste label template; The fourth step is to register hazardous wastes and fill in the hazardous waste generation record form; Step 5: Get the print signal, get the waste name from the hazardous waste generation link record table entry specified by the print signal, compare it with the waste name in the hazardous waste comparison table, find the same value to determine its entry, get the attribute data of the waste in the hazardous waste comparison table, and fill in the hazardous waste label template according to the attribute data; Step 6: Obtain the date of generation from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; obtain the weight information from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; generate a digital identification code and write it into the hazardous waste label template to form a hazardous waste label; Step 7: Print out the hazardous waste label.

[0022] The contents recorded in the hazardous waste comparison table are all quantitative information based on the waste name. They are defined as attribute data in this description. It can be seen that the items in the hazardous waste comparison table are all items that need to be filled in the hazardous waste label. The present invention facilitates the entry of attribute data by establishing a hazardous waste comparison table specifically serving hazardous waste labels. The print signal is used to determine the output target label. The system directly extracts the corresponding quantitative information from the hazardous waste comparison table, and then extracts the variable data from the hazardous waste generation link record table. The data extraction based on the Visual Basic programming language specifies the content of the cell, so the search path is extremely short, the data processing volume is small, and the processing speed is fast.

[0023] The steps of the present invention are described in detail below in conjunction with specific embodiments: 1. Record form of hazardous waste generation process Create a sheet in EXCEL, define it as sheet2, and then construct the header to determine the items that need to be filled in. For details, see Figure 4 , Figure 5 The content that needs to be filled in are: 1) Serial number, written from top to bottom; 2) Generate batch code, using the coding structure of the first letter of "…", time, and sequence number, such as HWFYCS20240227001. You can also use the first letter of "Generate" plus the year, month, and day plus the number, such as "HWCS20211031001". The time of generation is filled in with the time information in 24-hour time. 3) The name of hazardous waste can be written as the common name of the enterprise or the internal name of the unit, and should be unified; 4) Hazardous waste name, hazardous waste category, code The present invention plans to automatically fill in based on the hazardous waste comparison table, and the specific data content is not introduced here; 5) The amount produced should be filled in according to the actual weighing value; 6) The measurement unit is generally "ton", the packaging type is usually "barrel", and the packaging quantity is filled in according to the actual situation; 7) Fill in the code of the facility that generates hazardous waste, the person in charge, and the destination according to the actual situation.

[0024] II. Hazardous Waste Comparison Table See also Figure 6 , create a new sheet in the same EXCEL file and define it as sheet6. Enter the content of sheet6 according to the information required by the hazardous waste label, which includes the names of various wastes and their fixed corresponding attribute data.

[0025] 3. Hazardous waste labeling Create a new sheet in the same EXCEL file and define it as sheet1. Create it according to the label style provided by the national management standard, record the items that need to be filled in, such as waste name, waste category, waste code, precautions, affiliated unit, contact person, generation date, weight, etc., and also include a QR code of the main hazardous waste management identification; hazardous characteristics are displayed in the form of icons, combined with check boxes for annotation.

[0026] After the above data foundation is built, data association is performed through the data processing function of EXCEL and Visual Basic programming language to simplify data input. For example, after the table template of the hazardous waste generation record sheet 2 is prepared, the if function of EXCEL is used to make the name entered in the hazardous waste column of each entry (record) of sheet2 equal to a certain hazardous waste name in sheet6. The waste category, hazardous waste code and other attribute data in the entry where the hazardous waste name is located in sheet6 are automatically written into the corresponding cells in sheet2, thereby achieving the purpose of simplified entry.

[0027] The print signal is used to specify the target to be printed, which can be one record or multiple records. When printing multiple records, the target of the print signal is to generate multiple hazardous waste labels in sequence according to the number of the record entries in the sheet2 table.

[0028] Process for generating a hazardous waste label: 1. Use Split and UBound functions to judge the input value. When specifying the print target range, you can enter the row number of the item. When printing multiple item records, enter the start row and end row, separated by a comma. If the input is illegal, a prompt pop-up window will be displayed, and then the operation will be returned and repeated. If the input is legal, proceed to the next step. Code such as: Sub getData() stend = Split(InputBox("Enter the starting line number separated by English commas. For example, enter 4,5 for lines 4 to 5"), ",") ''Enter the starting line number If UBound(stend)<= 0 Then MsgBox "Input error, please check!" Exit Sub 'Exit on error End If rs = stend(0) 'Start line rd = stend(1) 'end line If VBA.IsNumeric(rs) = True And VBA.IsNumeric(rd) = True Then 'If the input is not a number, exit the program For rol = rs To rd 'Loop from the beginning to the end 2. Use the if function to check whether the record specified by the print signal has valid data. If it is a blank line, exit printing. The code is as follows: If Cells(rol, 4) = "" Then Exit Sub '' If the selected row waste name is empty, exit the program.

[0029] 3. When the entry specified by the print signal records valid data, the waste name is obtained; simple data processing is performed based on the record to form data that can be written into the hazardous waste label, such as identification code, date of production, weight, etc.

[0030] Get the identification code: define the str1 variable so that "str1=subject organization code+numeric characters in the generated batch code+numeric characters of the hazardous waste code".

[0031] Get the generation date: define the sData variable so that it is equal to the numeric characters of the code date in the "Generate Batch Code".

[0032] Get Weight: Define the sW variable to be equal to the value of the "Amount Produced" combined with the "Unit of Measure" data.

[0033] str1 = "91130200MA07KTA05D"&Right(Cells(rol, 2), 11)&Replace(Cells(rol, 7), "-", "") '''Get the digital identification code sData = Left(Right(Cells(rol, 2), 11), 8) ''Get the date sW = Cells(rol, 8).text&Cells(rol, 9).text ''Get weight Set rg = Sheet6.Columns(1).Find(sr, , , xlWhole) ' Find matching values ​​in column 1 of Sheet6 4. Compare the hazardous waste names in sheet2 with those in sheet6, obtain the matching cell row numbers, and then write the attribute data of the row into the items corresponding to the hazardous waste labels one by one. Among them, the waste name, waste category, waste code, waste form, main components, harmful components and precautions are the information written directly. The values ​​of the str1 variable, sData variable and sW variable defined above can also be directly assigned to the hazardous waste labels; sr = Cells(rol, 4) ''Get the name of the selected waste If Not rg Is Nothing Then ' If a matching value is found r1 = rg.Row ' Get the row number of the matching cell With Sheet1 ' Start writing information to the print template .Cells(3, 2) = "Waste name: "&Sheet6.Cells(r1, 1) 'Set the waste name .Cells(4, 2) = "Waste category:"&Sheet6.Cells(r1, 2) 'Set waste category .Cells(5, 2) = "Waste code: "&Sheet6.Cells(r1, 3) 'Set waste code .Cells(5, 3) = "Waste form:"&Sheet6.Cells(r1, 4) 'Set waste form .Cells(6, 2) = "Main component:"&Sheet6.Cells(r1, 5) 'Set the main component .Cells(7, 2) = "Harmful ingredients:"&Sheet6.Cells(r1, 6) 'Set harmful ingredients .Cells(8, 2) = "Notes:"&Sheet6.Cells(r1, 7) 'Set notes .Cells(9, 2) = "Digital identification code: "&str1 'Set the digital identification code .Cells(12, 2) = "Generation date: "&sData ' Set the generation date .Cells(12, 3) = "Waste weight: "&sW ' Set waste weight End With Waste characteristics are usually marked with one or more labels. If there are two hazardous characteristics in the hazardous waste comparison table, they will be split into arrays and compared and judged separately. Specifically, according to the hazardous characteristic text in sheet6, the corresponding data in the hazardous waste label sheet1 is compared. If they match, the CheckBox value is 1, and the check box under the corresponding icon in sheet1 is changed to a checked state.

[0034] srr = Split(Sheet6.Cells(r1, 8), ",") ' Split waste characteristics into arrays ' Reset the CheckBox value to 0 (unchecked) Sheet1.CheckBox1.Value = 0 Sheet1.CheckBox2.Value = 0 Sheet1.CheckBox3.Value = 0 Sheet1.CheckBox4.Value = 0 For i = 0 To UBound(srr) ' Traverse the array and set the corresponding CheckBox according to the value, dangerous characteristics If srr(i) = Sheet1.CheckBox1.Caption ThenSheet1.CheckBox1.Value = 1 ' If it matches CheckBox1 caption, then check If srr(i) = Sheet1.CheckBox2.Caption ThenSheet1.CheckBox2.Value = 1 ' If it matches the CheckBox2 title, then check it If srr(i) = Sheet1.CheckBox3.Caption ThenSheet1.CheckBox3.Value = 1 ' If it matches the CheckBox3 title, then check it If srr(i) = Sheet1.CheckBox4.Caption ThenSheet1.CheckBox4.Value = 1 ' If it matches the CheckBox4 caption, then check it Next i At this point, the entire content of the hazardous waste label has been completed and printed out! Beneficial effects of the present invention: 1) The present invention studies the internal logical relationship of hazardous waste ledgers, simplifies the process and manual input workload by establishing an EXCEL table with built-in functions, realizes full electronic management, improves work efficiency, greatly reduces labor and time costs, and prints hazardous waste labels; 2) The Visual Basic programming language is used for batch printing of hazardous waste labels, with a small amount of data calculation, fast result output and high accuracy, and can completely avoid erroneous information; 3) It can be installed on any device, with low investment and easy implementation.

[0035] The above description is only a preferred feasible embodiment of the present invention, and does not limit the scope of rights of the present invention. All equivalent changes made using the contents of the present specification and its drawings are included in the scope of rights of the present invention.

Claims

1. A method for generating hazardous waste labels: The first step is to establish a record sheet for the generation of hazardous waste; The second step is to establish a hazardous waste comparison table based on the types of hazardous waste that can be generated. The hazardous waste comparison table includes the names of hazardous wastes and their corresponding attribute data; The third step is to create a hazardous waste label template; The fourth step is to register hazardous wastes and fill in the hazardous waste generation record form; It is characterized in that Step 5: Get the print signal, get the waste name from the hazardous waste generation link record table entry specified by the print signal, compare it with the waste name in the hazardous waste comparison table, find the same value in the hazardous waste comparison table and determine its entry position in the hazardous waste comparison table, and fill in the hazardous waste label template according to the content of the entry; Step 6: Obtain the date of generation from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; obtain the weight information from the entry in the hazardous waste generation link record table specified by the print signal and write it into the hazardous waste label template; generate a digital identification code and write it into the hazardous waste label template to form a hazardous waste label; Step 7: Print out the hazardous waste label.

2. The method for generating hazardous waste labels according to claim 1, characterized in that: The attribute data in the hazardous waste comparison table include waste category, waste code, waste form, main components, harmful components, precautions and hazardous characteristics.

3. The method for generating hazardous waste labels according to claim 1, characterized in that: The hazardous waste generation link record table and hazardous waste comparison table are prepared based on EXCEL, and the calculation function in EXCEL is used to automatically fill in the hazardous waste generation link record table with the corresponding attribute data in the hazardous waste comparison table after the waste name is entered in the hazardous waste generation link record table.

4. The method for generating hazardous waste labels according to claim 1, characterized in that: The specific steps of obtaining the generation date from the hazardous waste generation link record table are as follows: first locate the generation batch code data of the hazardous waste and extract the numbers representing the year, month and day; The specific steps of obtaining weight information from the hazardous waste generation record sheet are as follows: first locate the generation volume data of the hazardous waste, extract its value, and then extract the data in the measurement unit and combine them.

5. The method for generating hazardous waste labels according to claim 1, characterized in that: The digital identification code is generated by combining the organization code of the hazardous waste management entity, some characters in the batch code generated in the record table of hazardous waste generation, and some characters in the hazardous waste code.

6. The method for generating hazardous waste labels according to claim 1, characterized in that: When the obtained printing signal is for printing multiple items, a corresponding number of hazardous waste labels are generated in sequence according to the item numbers.

Images