Environment protection data management system based on enterprise logistics information

Abstract

The invention relates to an environmental protection data management system based on enterprise logistics information. Five tables including a scale bill template, an original ledger, a filing unit table, a general solid waste ledger and an income analysis table are established in an EXCEL file; filling in a scale sheet template according to the actual vehicle access condition; outputting and printing the scale bill by confirming scale bill information, and meanwhile, commanding data filled in the scale bill to be automatically input into an original ledger by using a VB script language; extracting net weight data of the same accepting unit from the original machine account by utilizing an SUMIF function of EXCEL, performing sum value, and judging whether the accepting solid waste quantity is critical or exceeds the standard; the FILTER function of EXCEL is utilized to extract factory records of the specified type of solid waste from the original ledger, and the factory records are filled into the general solid waste ledger; according to the scheme, the data entry workload is integrated into supervision of an accepting unit, the labor and time cost is greatly reduced, and ledger counterfeiting is completely eradicated.

Description

Technical Field

[0001] The invention belongs to the technical field of environmental protection management of solid waste and chemical fuel, and in particular relates to an environmental protection data management system based on enterprise logistics information. Background Art

[0002] Solid waste refers to solid, semi-solid and gaseous items and substances in containers that have lost their original utilization value or have not lost their utilization value but have been discarded or abandoned in the production, life and other activities, as well as items and substances that are required to be included in solid waste management by laws and administrative regulations.

[0003] Solid waste is provided by waste-producing units and transported to receiving units by transportation units. A special ledger should be established for solid waste to be strictly monitored. The regulatory department shall supervise the waste-producing units to establish a general industrial solid waste ledger. Solid waste is sent to receiving units, and the transferred solid waste should have entry and exit links registered.

[0004] When solid waste is transported out of the waste-producing unit, it needs to be weighed and a weighing slip needs to be filled in to record the amount of transportation. The weighing slip is generally handwritten and prone to errors. Further, a working method of using software to fill in the weighing slip has also emerged, which solves the problem of the troublesome and error-prone handwritten weighing slip to a certain extent. The problems that still exist in the prior art are: 1. The waste-producing unit uses the weighing slip to record the entry and exit of solid waste, and also needs to fill in the solid waste ledger. The ledger contains multiple record tables, which are currently entered separately, and the workload of data entry is large; 2. When the solid waste regulatory agency conducts statistics on the solid waste situation, it can only be summarized regularly based on the traditional electronic ledger, which is cumbersome and lagging; the ledger of each enterprise is recorded separately, and the data between enterprises is unrelated, making it difficult to achieve full supervision of solid waste. 3. The annual acceptance volume of the receiving unit is fixed, but because the accounts are cumbersome and lagging, there is a lack of supervision on the situation where the receiving unit takes more or takes the wrong amount. Summary of the invention

[0005] The present invention provides a solid waste management system for automatically generating a solid waste ledger to facilitate solid waste management of waste-producing units.

[0006] The present invention solves the above-mentioned problem by adopting the following technical solution: An environmental protection data management system based on enterprise logistics information operates in the following steps: S1, create a new sheet sheet1 in the EXCEL file, build a weight bill template in the sheet, create a new sheet sheet2 in the EXCEL file, set it as the original ledger and set the items to be filled in, create a new sheet sheet3 in the EXCEL file, establish a record unit table, fill in the list of logistics terminals, the list includes the names of the receiving units and the purchasing units; create a new sheet sheet4 in the EXCEL file, set it as a general solid waste ledger, set the items to be filled in according to the standard requirements, create a new sheet5 in the EXCEL file, set it as a profit analysis table, insert a time selection button, and set the items to be displayed as: date, coal purchase quantity, unit price, power generation, heat supply, load factor and profit; S2, fill in the weighing list template according to the actual vehicle entry and exit situation; S3, by confirming the weighing slip information, the weighing slip is output and printed, and the data filled in the weighing slip is automatically entered into the original ledger using the VB language command; S4, completing the original ledger based on the data automatically entered into the original ledger; S5, use the SUMIF function of EXCEL to extract the net weight data of the same receiving unit from the original ledger and sum the values, compare the sum value with the approved comprehensive utilization amount of the enterprise, and determine whether the amount of solid waste accepted by the enterprise is critical or exceeds the standard; S6, using the FILTER function of EXCEL to extract the factory records of the specified types of solid waste from the original ledger, and enter them into the general solid waste ledger; S7, insert a time selection button in the profit analysis table, use the SUMIFS function to extract the coal entry record on that date from the original ledger, judge and sum the coal type information and date, estimate the daily carbon emissions, enter the daily power generation, heat supply, and load factor, and get the daily quota.

[0007] Compared with the prior art, the present invention adopting the above structure has the following beneficial effects: The original ledger is established through the weighing slip information, and an EXCEL table is created to automatically generate the original ledger. Built-in functions are used to simplify the process and the workload of manual entry. At the same time, the VB language in EXCEL is used to manage general industrial solid waste, integrate it into the supervision of the receiving unit, greatly reduce labor and time costs, and eliminate ledger falsification; on the other hand, carbon trading estimates are made based on coal type information to provide data support for the company's dual carbon policy.

[0008] As a preferred embodiment, a further technical solution of the above structure is: Optionally, when filling in the weighing slip, the terminal unit item is filled in using the drop-down options, and the data source of the drop-down options is the list of logistics terminals in the filing unit table.

[0009] Optionally, the process of automatically entering the data in the weighing slip into the original ledger is: 1) enter the weighing slip number in the weighing slip table; 2) determine whether there is the same value in the code column in the original ledger; 3) if not, then synchronously enter the data filled in the weighing slip into the next line of the last record in the original ledger; if so, rewrite the line where the code is located in the original ledger according to the confirmation command, and exit the weighing slip input if there is no confirmation command.

[0010] Optionally, fill in the entry time and weight when the vehicle enters the factory, and fill in the departure time and weight when the vehicle leaves the factory; the departure time in the weighing slip is supplemented again when the vehicle leaves the factory. The specific process is: 1) Select the license plate number of the vehicle from the original ledger; 2) The original ledger writes the data back to the weighing slip template; 3) At the same time, EXCEL automatically jumps to the data cell of the departure time in the weighing slip; 4) Complete the weighing slip data in the weighing slip; 5) After the weighing slip is confirmed, the supplemented departure time and weight are synchronously entered into the original ledger.

[0011] Optionally, to determine whether the amount of solid waste accepted by the solid waste receiving unit exceeds the standard, the following are specific steps: 1) For each solid waste receiving unit, the registered unit table also records its approved comprehensive utilization amount and accepted amount, where the approved comprehensive utilization amount is filled in according to the evaluation results of the environmental assessment agency; 2) The data in the original ledger is traversed through the SUNIF function, and all net weight values ​​of the designated receiving unit are summed to form the accepted amount; 3) When the accepted amount is close to or exceeds the value of the approved comprehensive utilization amount, an alarm is issued.

[0012] Optionally, the name of the recipient unit that issued the alert does not appear in the drop-down list of options.

[0013] Optional, filling in the general solid waste ledger is as follows: 1) select a cell in the general solid waste ledger and fill in the name of a solid waste; 2) use the FILTER function to extract the factory record data of the above solid waste in the original ledger and implant it into the general solid waste ledger. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 It is a schematic diagram of a scale sheet of the present invention; Figure 2 It is a schematic diagram of the original ledger of the present invention; Figure 3 It is the intention of the unit filing the invention; Figure 4 It is a schematic diagram of a general solid waste account of the present invention; Figure 5 It is a representation of the benefit analysis of the present invention. DETAILED DESCRIPTION

[0015] 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.

[0016] Taking power plants as an example, in logistics management, all vehicles and goods entering and leaving the plant need to be verified by recording relevant information such as vehicles and goods. Materials traded by weight need to be recorded through weighing slips. In power plant management, such goods generally include two categories: one is the materials traded out of the plant: general industrial solid waste, generally including fly ash, slag, gypsum, etc.; the other is the materials traded into the plant: such as coal.

[0017] The idea of ​​this solution is to input the weight slip information required for heavy cargo transportation through EXCEL, use Visual Basic programming language to print the weight slip, and use the cargo in and out data to conduct general industrial solid waste management and carbon trading analysis. Visual Basic (VB for short) is a general object-based programming language developed by Microsoft. It is a structured, modular, object-oriented, and visual programming language with an event-driven mechanism that assists the development environment. Specifically, it includes: 1) By inputting the weighing bill information required for heavy cargo transportation, the weighing bill can be printed and the original ledger can be automatically generated; 2) Establish a general industrial solid waste ledger based on the original ledger, and use Visual Basic language to implement terminal utilization unit qualification control; 3) Establish a carbon trading benefit analysis module based on the original ledger, and derive the daily carbon trading income based on the coal type, providing effective support for the power plant's dual carbon policy.

[0018] See also Figures 1 to 5 The environmental protection data management system based on enterprise logistics information provided by the present invention is operated according to the following steps: S1, create a new EXCEL file, Create a new sheet 1 in the EXCEL file and build a weighing slip template in it. A weighing slip generally contains the following items that need to be filled in: code; person in charge of the factory process; license plate number; transportation information; company name; time of entry and exit; weight, etc.

[0019] Create a new sheet 2 in the EXCEL file, set it as the original ledger and set the items to be filled in. The original ledger usually contains almost all the data recorded on the scale slip, such as code, name of the goods transported, factory time, net weight (referring to the weight of the goods loaded), person in charge, transportation information, etc. Other project data such as net weight, transportation method and flow type can also be added according to the needs of enterprise data analysis.

[0020] Create a new sheet 3 in the EXCEL file, establish a registration unit table, and fill in the list of logistics terminals, which includes the company names of the receiving units and purchasing units.

[0021] Create a new sheet 4 in the EXCEL file, set it as a general solid waste ledger, and set the items that need to be filled in according to the standard requirements. The solid waste factory record sheet (solid waste ledger) usually contains the code, solid waste name, factory time, factory quantity, factory handler, transportation unit, license plate number, transportation information (driver and phone number), transportation method, receiving unit, and flow type. The content of this solid waste factory record sheet is part of the original ledger.

[0022] Create a new sheet5 in the EXCEL file, set it as a profit analysis table, insert a time selection button, and set the items to be displayed as: date, coal purchase quantity, unit price, power generation, heat supply, load factor and profit.

[0023] S2. Fill in the weighing slip template according to the actual vehicle entry and exit situation.

[0024] S3, print out the weighing slip by confirming the weighing slip information, and use VB language command to automatically enter the data filled in the weighing slip into the original ledger.

[0025] S4, complete the original ledger based on the data automatically entered into the original ledger.

[0026] S5. Use the SUMIF function of EXCEL to extract the net weight data of the same receiving unit from the original ledger and sum the values. Compare the sum with the approved comprehensive utilization amount of the enterprise to determine whether the amount of solid waste accepted is critical or exceeds the standard.

[0027] S6. Use the FILTER function of EXCEL to extract the factory records of the specified type of solid waste from the original ledger and enter them into the general solid waste ledger.

[0028] S7, insert a time selection button in the profit analysis table, use the SUMIFS function to extract the coal entry record on that date from the original ledger, judge and sum the coal type information and date, estimate the daily carbon emissions, enter the daily power generation, heat supply, and load factor, and get the daily quota.

[0029] In the above steps, the step numbers do not necessarily represent the order of data processing, and steps that have no causal relationship can be performed simultaneously.

[0030] Regarding the registration unit table, it is a new form added to this scheme to achieve the purpose of the invention. The supplier of the user of this scheme is the "purchasing unit", and the recipient of the solid waste of the user is the "receiving unit". The purchasing unit and the receiving unit recorded in this system should be cooperative units approved by the user after review. A list of each cooperative unit is formed, which can be directly called when filling out the weighing slip, avoiding errors in the input of company names and the mixing of unaudited companies, thereby improving the safety within the factory and the traceability of goods entering and leaving the factory.

[0031] Based on this, when filling in the weighing slip, the terminal unit item is filled in by drop-down options, and the data source of the drop-down options is the list of logistics objects in the record unit table. When filling in the weighing slip, the receiving unit can only be filled in by selection, so that the whereabouts of solid waste can be traced, thus forming an information chain and facilitating supervision.

[0032] The registration unit table includes three values: enterprise name, approved comprehensive utilization amount and accepted amount. Since this plan focuses on the situation of solid waste receiving units and supervises whether the receiving units are qualified, in fact only the receiving units need to mark the approved comprehensive utilization amount and the accepted amount.

[0033] Based on EXCEL, the amount of solid waste transported to each receiving unit is recorded, and an early warning function is performed according to the approved comprehensive utilization amount of the receiving unit. The specific idea is: establish a ledger for the registered unit, find the real-time transfer amount of each registered unit through the SUMIF function, and compare the annual comprehensive utilization amount of the registered unit. When it is less than 30 tons, the data turns red and prompts an early warning; when the real-time transfer amount is greater than the comprehensive utilization amount of the receiving unit in the original ledger, it is automatically displayed as empty in the drop-down option of the scale order through VB language and function, that is, it does not appear in the drop-down option of the scale order, which solves the problem of lack of control over the amount of solid waste actually sent to the receiving unit. Therefore, when sending solid waste outward, the receiving unit displayed in the drop-down option in the terminal unit item when filling in the scale order is: first, it must be an audited unit, specifically referring to the solid waste utilization capacity determined by a qualified environmental assessment unit, and the utilization capacity value is approved by the government; second, the annual total amount of solid waste currently received by the receiving unit should not exceed its comprehensive utilization amount.

[0034] Specifically, the following steps are used to determine whether the amount of solid waste accepted by the solid waste accepting unit exceeds the standard: 1) For each solid waste accepting unit, the registered unit table also records its approved comprehensive utilization amount and accepted amount, where the approved comprehensive utilization amount is filled in according to the evaluation results of the environmental assessment agency; 2) The data in the original ledger is traversed through the SUNIF function, and all net weight values ​​of the designated accepting units are summed to form the accepted amount; 3) When the accepted amount is close to or exceeds the value of the approved comprehensive utilization amount, an alarm is issued.

[0035] Function formulas such as: =SUMIF(data!J4:J40,A3,data!D4:D40), IF(C2 <B2,A2,"")。

[0036] This plan effectively monitors the acceptance volume of solid waste receiving units. When the target acceptance volume approaches the critical value, the solid waste supply to the target is reduced or cancelled, thereby enhancing the role of waste-producing units in management.

[0037] The process of automatically entering the data in the weighing slip into the original ledger is: 1) enter the weighing slip number in the weighing slip table; 2) determine whether there is the same value in the code column in the original ledger; 3) if not, then synchronously enter the data filled in the weighing slip into the next line of the last record in the original ledger; if so, rewrite the line where the code is located in the original ledger according to the confirmation command, and exit the weighing slip input if there is no confirmation command.

[0038] Commands such as: If flag Then Dim ms ms = MsgBox("The document number "&dh&" already exists. Do you want to overwrite the previous data?"&vbCrLf&vbCrLf&"Click "Yes" to overwrite the previous data; click "No" to cancel the save operation.", vbYesNo +vbInformation, "Prompt") If ms = vbNo Then Exit Sub Sheet2.Cells(lr, 1) = dh Sheet2.Cells(lr, 2) = Sheet1.Range("b6") Sheet2.Cells(lr, 3) = Sheet1.Range("b8") Sheet2.Cells(lr, 4) = Sheet1.Range("d8") Sheet2.Cells(lr, 5) = Sheet1.Range("d2") Sheet2.Cells(lr, 6) = Sheet1.Range("d6") Sheet2.Cells(lr, 7) = Sheet1.Range("d5") Sheet2.Cells(lr, 8) = Sheet1.Range("b5") Sheet2.Cells(lr, 10) = Sheet1.Range("b4") Sheet2.Cells(lr, 12) = Sheet1.Range("b7") Sheet2.Cells(lr, 13) = Sheet1.Range("d7") Else lr = Srw(Sheet2, 1) + 1 Sheet2.Cells(lr, 1) = dh Sheet2.Cells(lr, 2) = Sheet1.Range("b6") Sheet2.Cells(lr, 3) = Sheet1.Range("b8") Sheet2.Cells(lr, 4) = Sheet1.Range("d8") Sheet2.Cells(lr, 5) = Sheet1.Range("d2") Sheet2.Cells(lr, 6) = Sheet1.Range("d6") Sheet2.Cells(lr, 7) = Sheet1.Range("d5") Sheet2.Cells(lr, 8) = Sheet1.Range("b5") Sheet2.Cells(lr, 10) = Sheet1.Range("b4") Sheet2.Cells(lr, 12) = Sheet1.Range("b7") Sheet2.Cells(lr, 13) = Sheet1.Range("d7") End If Dim lr arr = getShtRange(Sheet2, 1, 1, 1) Dim flag flag = False For i = 3 To UBound(arr) If CStr(arr(i, 1)) = dh Then flag = True lr = i Exit For End If Next i If flag Then Sheet2.Cells(lr, 1) = dh Sheet2.Cells(lr, 2) = Sheet1.Range("b6") Sheet2.Cells(lr, 3) = Sheet1.Range("b8") Sheet2.Cells(lr, 4) = Sheet1.Range("d8") Sheet2.Cells(lr, 5) = Sheet1.Range("d2") Sheet2.Cells(lr, 6) = Sheet1.Range("d6") Sheet2.Cells(lr, 7) = Sheet1.Range("d5") Sheet2.Cells(lr, 8) = Sheet1.Range("b5") Sheet2.Cells(lr, 10) = Sheet1.Range("b4") Sheet2.Cells(lr, 12) = Sheet1.Range("b7") Sheet2.Cells(lr, 13) = Sheet1.Range("d7") Else lr = Srw(Sheet2, 1) + 1 Sheet2.Cells(lr, 1) = dh Sheet2.Cells(lr, 2) = Sheet1.Range("b6") Sheet2.Cells(lr, 3) = Sheet1.Range("b8") Sheet2.Cells(lr, 4) = Sheet1.Range("d8") Sheet2.Cells(lr, 5) = Sheet1.Range("d2") Sheet2.Cells(lr, 6) = Sheet1.Range("d6") Sheet2.Cells(lr, 7) = Sheet1.Range("d5") Sheet2.Cells(lr, 8) = Sheet1.Range("b5") Sheet2.Cells(lr, 10) = Sheet1.Range("b4") Sheet2.Cells(lr, 12) = Sheet1.Range("b7") Sheet2.Cells(lr, 13) = Sheet1.Range("d7") End If Sheet1.PrintOut MsgBox "保存成功!" Application.DisplayAlerts = True Application.ScreenUpdating = True ' Application.AskToUpdateLinks =true ' Application.Calculation = xlAutomatic End Sub Sub clearcontent() Dim msg% 'On Error resume next msg = MsgBox("是否清空?", vbOKCancel) If msg = 2 Then Exit Sub Sheet1.Range("b6") = "" Sheet1.Range("b8") = "" Sheet1.Range("d8") = "" Sheet1.Range("d2") = "" Sheet1.Range("d6") = "" Sheet1.Range("d5") = "" Sheet1.Range("b5") = "" Sheet1.Range("b4") = "" Sheet1.Range("b7") = "" Sheet1.Range("d7") = "" Sheet1.Range("b2") = "" End Sub Function getShtRange(sht As Worksheet, rStart As Integer, cStart As Integer, cEnd As Integer) 'Table, data first cell row, column, last column num Dim rEnd As Long Dim arr rEnd = sht.Cells(sht.Rows.Count, cStart).End(xlUp).Row If rEnd - rStart<= 1 Then rEnd = rStart + 1 arr = sht.Range(sht.Cells(rStart, cStart), sht.Cells(rEnd, cEnd)) getShtRange = arr End Function Function Srw(st As Worksheet, i) Srw = st.Cells(st.Rows.Count, i).End(xlUp).Row For some data not displayed in the weighing slip, the original ledger can be supplemented with the data that has been entered into the original ledger. For example, for "mode of transport", the vehicle type can be known based on the license plate number, and "road" or "rail" can be filled in accordingly. Of course, according to the current situation of our factory, all transportation is by truck, so "road" can be uniformly filled in; for example, "flow direction type", according to the name of the filing unit, the geographical division of the opposite direction of the logistics can be known, and the corresponding filling is within the city or across provinces; the net weight is the value weighed when the vehicle leaves the factory minus the value weighed when it enters the factory.

[0039] When a vehicle enters the factory, fill in the entry time and entry weight, and when the vehicle leaves the factory, fill in the exit time and exit weight; due to the large volume of vehicles entering and leaving the factory, the next vehicle cannot wait for the previous vehicle to enter and leave the factory before recording the entry, so part of the record must be made when entering the factory, and another part of the record must be made when leaving the factory. Re-filling the relevant entry and exit information when leaving the factory is obviously not enough to save work. The solution to this problem is based on the vehicle's entry and exit information. After the user enters the weighing slip information, it is written into the table corresponding to the original ledger, and it can be saved to the original ledger by clicking Save. When the vehicle leaves the factory, double-click the row where the vehicle information is located to re-write it into the weighing slip template. After filling in the vehicle's factory information, click Save and Print the required information to continue writing it into the original ledger.

[0040] Specifically, the process of secondary re-entering the weighing slip information when the vehicle leaves the factory is: 1) Select the license plate number of the vehicle from the original ledger; 2) The original ledger writes the data back to the weighing slip template; 3) At the same time, EXCEL automatically jumps to the data cell of the factory time in the weighing slip; 4) Complete the weighing slip data in the weighing slip; 5) After the weighing slip is confirmed, the supplemented factory time and factory weight are synchronously entered into the original ledger.

[0041] The command is as follows: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, CancelAs Boolean) If Target.Count>1 Then Exit Sub If Target = "" Then Exit Sub c = Target.Column r = Target.Row If r>2 And c = 7 Then Cancel = True lr = r Sheet1.Range("b2") = CStr(Sheet2.Cells(lr, 1)) Sheet1.Range("b6") = Sheet2.Cells(lr, 2) Sheet1.Range("b8") = Sheet2.Cells(lr, 3) Sheet1.Range("d8") = Sheet2.Cells(lr, 4) Sheet1.Range("d2") = Sheet2.Cells(lr, 5) Sheet1.Range("d6") = Sheet2.Cells(lr, 6) Sheet1.Range("d5") = Sheet2.Cells(lr, 7) Sheet1.Range("b5") = Sheet2.Cells(lr, 8) Sheet1.Range("b4") = Sheet2.Cells(lr, 10) Sheet1.Range("b7") = Sheet2.Cells(lr, 12) Sheet1.Range("d7") = Sheet2.Cells(lr, 13) Sheet1.Activate Sheet1.[b8].Select End If End Sub The present invention sets a drop-down option including fly ash, gypsum, and slag, selects the specified solid waste, thereby displaying the record of the solid waste and automatically displaying the "general solid waste ledger" of the solid waste. Specifically, filling in the general solid waste ledger is as follows: 1) Select a cell in the general solid waste ledger to set a drop-down option and determine a solid waste name by selection; 2) Use the FILTER function to extract the factory record data of the above solid waste in the original ledger and implant it into the general solid waste ledger. The function formula is as follows: =FILTER(data!A3:K39, data!B3:B39=general solid waste ledger!A1).

[0042] The industrial raw material of the power plant is coal. The present invention inserts a time selection button in EXCEL, and the coal weighing information can be summarized on a daily basis using the FILTER function, and the carbon element analysis results of the coal types built by the enterprise are combined to perform profit analysis of carbon trading in accordance with relevant regulations. In the benefit analysis module, a time selection button is inserted, and the SUMIFS function is used to judge and sum the coal type information and date. Because the coal types of the power plant are relatively fixed and the elemental carbon content is relatively stable, the daily carbon emissions are estimated according to the relevant requirements of the "Guidelines for the Accounting and Reporting of Greenhouse Gas Emissions for Enterprises for Power Generation Facilities". After entering the daily power generation, heat supply, and load factor, the daily quota can be obtained according to the "Total Quota and Allocation Plan for the National Carbon Emission Trading Power Generation Industry in 2023 and 2024", and the daily profit of the enterprise in carbon trading can be calculated.

[0043] Beneficial effects of the present invention: 1) Data management is based on EXCEL, which is highly versatile and does not require the purchase of new software, with low investment; 2) Data can be automatically entered into the database through VB language settings, saving a lot of data entry work; 3) Early warnings can be set through functions to determine whether the amount of solid waste received by the receiving unit exceeds its acceptance capacity, effectively monitoring the amount of solid waste in the receiving unit and improving supervision and management capabilities; 4) EXCEL built-in functions are used to achieve one-click production of general industrial solid waste ledgers, eliminating the "two ledgers phenomenon" and automatically completing data entry of the ledger while making the weighing slip, making data processing fast; 5) For different types of coal, based on the automatically generated database, daily carbon trading income is calculated in accordance with relevant national regulations, providing basic data support for the company's dual-carbon development.

[0044] 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. An environmental protection data management system based on enterprise logistics information, characterized in that: Follow these steps: S1, create a new EXCEL file, Create a new sheet1 in the EXCEL file and build a single-pound bill template in the sheet. Create a new sheet 2 in the EXCEL file, set it as the original ledger and set the items that need to be filled in. Create a new sheet 3 in the EXCEL file, create a record unit table, and fill in the list of logistics terminals, which includes the names of the receiving units and the purchasing units; Create a new sheet 4 in the EXCEL file, set it as a general solid waste ledger, and set the items that need to be filled in according to the standard requirements. Create a new sheet5 in the EXCEL file, set it as a profit analysis table, insert a time selection button, and set the items to be displayed as: date, coal purchase quantity, unit price, power generation, heat supply, load factor and profit; S2, fill in the weighing list template according to the actual vehicle entry and exit situation; S3, by confirming the weighing slip information, the weighing slip is output and printed, and the data filled in the weighing slip is automatically entered into the original ledger using the VB language command; S4, completing the original ledger based on the data automatically entered into the original ledger; S5, use the SUMIF function of EXCEL to extract the net weight data of the same receiving unit from the original ledger and sum the values, compare the sum value with the approved comprehensive utilization amount of the enterprise, and determine whether the amount of solid waste accepted by the enterprise is critical or exceeds the standard; S6, using the FILTER function of EXCEL to extract the factory records of the specified types of solid waste from the original ledger, and enter them into the general solid waste ledger; S7, insert a time selection button in the profit analysis table, use the SUMIFS function to extract the coal entry record on that date from the original ledger, judge and sum the coal type information and date, estimate the daily carbon emissions, enter the daily power generation, heat supply, and load factor, and get the daily quota.

2. The environmental protection data management system based on enterprise logistics information according to claim 1 is characterized in that: When filling in a weighing slip, the terminal unit item is filled in using a drop-down option, and the data source for the drop-down option is the list of logistics terminals in the filing unit table.

3. The environmental protection data management system based on enterprise logistics information according to claim 1 is characterized in that: The process of automatically entering the data in the weighing slip into the original ledger is: 1) enter the weighing slip number in the weighing slip table; 2) determine whether there is the same value in the code column in the original ledger; 3) if not, then synchronously enter the data filled in the weighing slip into the next line of the last record in the original ledger; if so, rewrite the line where the code is located in the original ledger according to the confirmation command, and exit the weighing slip input if there is no confirmation command.

4. The environmental protection data management system based on enterprise logistics information according to claim 1 is characterized by: When a vehicle enters the factory, fill in the entry time and entry weight; when a vehicle leaves the factory, fill in the departure time and departure weight; the departure time in the weighing slip is supplemented with information when the vehicle leaves the factory. The specific process is: 1) Select the license plate number of the vehicle from the original ledger; 2) The original ledger writes the data back to the weighing slip template; 3) At the same time, EXCEL automatically jumps to the data cell of the departure time in the weighing slip; 4) Complete the weighing slip data in the weighing slip; 5) After the weighing slip is confirmed, the supplemented departure time and departure weight are synchronously entered into the original ledger.

5. The environmental protection data management system based on enterprise logistics information according to claim 1 is characterized in that: The specific steps to determine whether the amount of solid waste accepted by the solid waste receiving unit exceeds the standard are: 1) For each solid waste receiving unit, the registered unit table also records its approved comprehensive utilization amount and accepted amount, where the approved comprehensive utilization amount is filled in according to the evaluation results of the environmental assessment agency; 2) The data in the original ledger is traversed through the SUNIF function, and all net weight values ​​of the designated receiving unit are summed to form the accepted amount; 3) When the accepted amount is close to or exceeds the value of the approved comprehensive utilization amount, an alarm is issued.

6. The environmental protection data management system based on enterprise logistics information according to claim 5 is characterized in that: For the receiving unit that issued the warning, its name does not appear in the drop-down options of the weighing slip.

7. The environmental protection data management system based on enterprise logistics information according to claim 1 is characterized in that: The specific steps for filling in the general solid waste ledger are: 1) select a cell in the general solid waste ledger to set the drop-down option and select a solid waste name; 2) use the FILTER function to extract the factory record data of the above solid waste in the original ledger and implant it into the general solid waste ledger.

Images