Ecological product value accounting method for EOD project

Abstract

The invention relates to the technical field of ecological product accounting, in particular to an EOD project ecological product value accounting method. Comprising the steps of obtaining and constructing an ecological product data table; and obtaining a character verification set and determining a target numeric character, thereby determining a supplementary verification character, and verifying and correcting the supplementary verification character. The method comprises the following steps: constructing a character verification set through repeated characters and associated characters to determine whether abnormity exists in an ecological product data table, if yes, determining a target numeric character, and forming analysis of a digit recognition feature, a sequence recognition feature and a character recognition feature according to the target numeric character, thereby obtaining a comprehensive recognition feature; and re-determining supplementary verification characters in combination with the comprehensive identification features, and constructing a supplementary verification data column to verify and correct the supplementary verification characters in the supplementary verification data column so as to re-generate an ecological product data table and execute ecological product value accounting while improving the accuracy of the accounting.

Description

Technical Field

[0001] The present invention relates to the technical field of ecological product accounting, and in particular to an ecological product value accounting method for an EOD project. Background Art

[0002] Ecological product value accounting is a method that quantifies, evaluates and calculates the value of ecological products and services based on ecosystems. It aims to reveal the direct and indirect benefits that ecosystems provide to humans and provide a basis for decision-making for policymakers, businesses and the public.

[0003] At present, in order to facilitate the calculation of the value of ecological products, the collected ecological product data are usually input into Excel tables for rapid value calculation. However, after the calculation, in order to ensure the accuracy of the ecological product value calculation, a large amount of ecological product data in the Excel tables needs to be verified one by one, which results in a large loss of time and efficiency of verification. Moreover, if there are multiple Excel tables of ecological product data, the Excel tables of ecological product data cannot be verified and verified quickly, which affects the actual efficiency of the overall ecological product value calculation and affects the analysis and decision-making of the ecosystem. Summary of the invention

[0004] In view of the above-mentioned shortcomings of the prior art, the present invention provides an EOD project ecological product value accounting method, which can effectively solve the problem of rechecking a large amount of ecological product data one by one in the prior art, resulting in a large loss of time and recheck efficiency.

[0005] To achieve the above objectives, the present invention is implemented through the following technical solutions: The present invention provides an EOD project ecological product value accounting method, comprising the following steps: S1. Obtain ecological product data and fill it into an Excel spreadsheet and construct an ecological product data sheet to perform value accounting; S2. Obtain the repeated characters and related characters in the ecological product data table, extract the repeated characters and related characters to generate a character check set, and determine whether the character check set has an abnormality, wherein: If there is an exception, perform the following steps: Extract abnormal data characters from the character check set, and compare them with the corresponding digital characters of the initial ecological data to obtain the target digital characters, wherein: If there are multiple target data characters, perform feature analysis on the target data characters. Feature analysis includes performing digit recognition feature , Sequential recognition features and character recognition features , thereby obtaining comprehensive identification features, re-determining the supplementary verification characters in combination with the comprehensive identification features, and constructing a supplementary verification data column to check and correct the supplementary verification characters in the supplementary verification data column, so as to regenerate the ecological product data table and perform ecological product value accounting; S3. When generating the supplementary verification data columns, if there are multiple pages of ecological products, clarify whether there are distribution characteristics and character quantity characteristics in the rows and columns where the supplementary verification characters are located in the multi-page ecological product data table, and apply them to other ecological product data tables based on the distribution characteristics and character quantity characteristics to form a verification calibration for other ecological product data tables, so as to re-execute value accounting for other ecological product data tables.

[0006] The ecological products in the ecological product data sheet include: Ecological material projects: specifically, agricultural products, forestry products, animal husbandry products, fishery products, and ecological energy products; Regulation service items: specifically, water conservation, soil conservation, wind and sand fixation, coastal protection, and water purification; Cultural service projects: specifically, such as leisure and tourism services, and landscape value services.

[0007] The associated character refers to a numeric character that has a calculation influence feature with the repeated character.

[0008] The method for performing feature analysis on the target data characters is: SA, determine the number of digits of the target data character. If the number of digits of the target data characters is the same, the number of digits of the target data character is marked as the digit identification feature. ; ST. Based on the determined number of digits of the target data character, if there is a target data character with at least two digits, the order of the adjacent digits of the target data character is determined from left to right, where: If the target data characters have the same digit size order, the digit size order of the target data characters is marked as the sequential recognition feature. ; SG, determine whether the target data characters have the same characters, if there are the same characters, then mark the same characters as character recognition features ; Determine the number of digits contained in the target data character to identify the characteristics , Sequential recognition features or character recognition feature , comprehensive recognition features are obtained by superimposing the included features; Combined with the comprehensive identification features, the supplementary verification characters are re-determined in the ecological product data table, and a supplementary verification data column is constructed thereby. The supplementary verification characters in the supplementary verification data column are compared with the corresponding digital characters in the initial ecological data to identify abnormal data characters in the ecological product data table and perform corrections accordingly.

[0009] If the supplementary verification characters include data characters that do not exist in the initial ecological data, the data characters are marked as endpoint characters, and the extended characters associated with them are obtained using the endpoint characters, where: Extended characters refer to digital characters that have a computational association between endpoint characters, so that the extended characters can be verified with the initial ecological data, and the value of ecological products can be calculated in combination with the regenerated ecological product data table.

[0010] The distribution characteristics are determined based on whether the rows and columns where the supplementary verification characters are located in adjacent ecological product data table pages are the same, increasing or decreasing.

[0011] The character quantity feature is determined based on whether the data character quantity in each page of the ecological product data sheet is the same. If the data character quantity is the same, it is marked as a character quantity feature.

[0012] If there are other ecological product data sheets, perform the following steps: If the number of data characters per page in other eco-product data sheets is the same as that in the current eco-product data sheet and the number of pages is also the same; According to the distribution characteristics, the rows and columns where the supplementary verification characters on the first page of the ecological product data table are located are synchronously verified for other ecological product data tables. If matching abnormal data characters appear in other ecological product data tables after verification, the distribution characteristics are continued to be executed. Otherwise, the distribution characteristics will not be used to verify other ecological product data tables.

[0013] If the number of data characters per page in other eco-product data sheets is different from the number of data characters per page in the current eco-product data sheet: Re-execute steps S2-S3 with other eco-product data sheets to re-determine the comprehensive identification features, character quantity features, and distribution features of other eco-product data sheets, thereby re-verifying other eco-product data sheets and performing value accounting; By determining multiple different comprehensive identification features, character quantity features and distribution features, if there is a new other ecological product data table for data character verification, the corresponding comprehensive identification features and distribution features are determined in advance with the character quantity features and page numbers that match the new other ecological product data table, so as to form a data character verification for the new other ecological product data table and thereby re-execute the value accounting.

[0014] Compared with the known prior art, the technical solution provided by the present invention has the following beneficial effects: A character check set is constructed by repeated characters and associated characters to determine whether there are anomalies in the ecological product data table. If there are anomalies, the target digital characters are determined, and the digit recognition features, sequence recognition features and character recognition features are analyzed according to the target digital characters to obtain a comprehensive recognition feature. The supplementary verification characters are re-determined in combination with the comprehensive recognition features, and a supplementary verification data column is constructed to check and correct the supplementary verification characters in the supplementary verification data column, so as to regenerate the ecological product data table and perform ecological product value accounting while improving the accuracy of the accounting; The distribution characteristics and character quantity characteristics are determined based on the number of pages of the ecological product data table, and are combined and applied to other ecological product data tables to form a verification and calibration of other ecological product data tables, so that other ecological product data tables can re-execute value accounting and speed up the accounting efficiency of the ecological product data tables. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention, and for ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0016] Figure 1 It is a schematic diagram of the overall process of the present invention; Figure 2 It is a schematic diagram of the overall method of the present invention; Figure 3 This is a schematic diagram of the ecological product project of the present invention. DETAILED DESCRIPTION

[0017] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0018] The present invention will be further described below in conjunction with the embodiments.

[0019] Example 1 (see Figure 1-Figure 3 ): The calculation method of ecological product value of EOD project shall at least include: S1. Obtain the ecological product data (ecological product list and related data) within the scope of the EOD ecological project and fill it into the Excel table, thereby constructing an ecological product data table to calculate the value of the ecological products in the ecological product data table. The ecological products (related data) in the ecological product data table include: Ecological material products, such as agricultural products (output and output value), forestry products (output and output value), animal husbandry products (output and output value), fishery products (output and output value), ecological energy products (total output value of ecological energy); Regulation service products, such as water conservation (improvement of water conservation capacity), soil conservation (reduction of siltation area and land development value), windbreak and sand fixation (maintaining topsoil area, reducing land loss value and maintaining soil fertility value), coastal protection (protection area and development value), water purification (purification of COD, total nitrogen, total phosphorus and development value), etc.; Cultural service products, such as leisure tourism services (total number of tourists and their recreational value), landscape value services (area of ​​benefited land and real estate and value of land and real estate), etc.; In the above, it should be noted that in the ecological product data table, since it includes agricultural products, water conservation conditions, and leisure and tourism services, there will be data characters such as price, area, quantity, date of commissioning, time of commissioning, and city name. Therefore, when calculating the value of data characters in the ecological product data table, in order to ensure the accuracy of the calculation, this plan also includes: S2. Analyze the ecological product data table to obtain the repeated characters in the ecological product data table. The repeated characters can largely reflect the possibility of abnormality in the current ecological product data table, thereby obtaining the associated characters associated with the repeated characters. The associated characters associated with the repeated characters refer to the existence of accounting influence features between the repeated characters and the associated characters. For example, the repeated characters are value, the associated characters are area and price, and the value is obtained according to the area and price, or the associated characters are value, and the repeated characters are area and price. Similarly, the existence of accounting influence features between the repeated characters and the associated characters is obtained; In this way, repeated characters and related characters are extracted to generate a character check set, and then the initial ecological data corresponding to the character check set is obtained from the database (the initial ecological data table is preset in the database, which is the original data, and the initial ecological data is part of the data in the initial ecological data table) for comparison to determine whether there are any anomalies in the character check set, and then the data character anomalies in the ecological product data table can be identified and corrected, thereby improving the accuracy of the subsequent ecological product value calculation in the ecological product data table.

[0020] Furthermore, when comparing the initial ecological data corresponding to the character check set, if there is an abnormality in the data characters in the character check set, the following steps are performed: Extract abnormal data characters in the character check set, and compare them with the corresponding digital characters in the initial ecological data to obtain target digital characters that are prone to abnormal situations (the abnormal data characters in the character check set correspond to the digital characters in the initial ecological data); If there are multiple target data characters, perform feature analysis on the target data characters: SA, determine the number of digits of the target data character. If the number of digits of the target data characters is the same, the number of digits of the target data character is marked as the digit identification feature. ; ST. Based on the determined number of digits of the target data character, if there is a target data character with at least two digits, the order of the adjacent digits of the target data character is determined from left to right, where: If the target data characters have the same digit order, for example, the target data character is the 3-digit 627, then , , that is, the number of digits of the target data characters is: large, that is, when both are large, the order of the number of digits of the target data characters is marked as the sequential recognition feature ; SG, determine whether the target data characters have the same characters, if there are the same characters, then mark the same characters as character recognition features ; Therefore, according to the above feature analysis of the target data character, the number of digits recognition feature contained in the target data character is determined. , Sequential recognition features or character recognition feature , the included features are superimposed to obtain the comprehensive recognition features obtained by analyzing the target digital characters, so that the supplementary verification characters can be re-determined in the ecological product data table in combination with the comprehensive recognition features, and the supplementary verification data column can be constructed to compare the supplementary verification characters in the supplementary verification data column with the corresponding digital characters in the initial ecological data, thereby realizing the verification of the calculated ecological product data table, so as to quickly identify the abnormal data characters in the ecological product data table, and perform corrections accordingly, so that after the correction, the value of the ecological product can be recalculated to obtain the accurate value of the ecological product.

[0021] It is worth noting that when calculating the ecological value in the ecological product data table, the following formula can be used for calculation: In the formula, is the total value of ecological products, For the Output of ecological products, For the Eco-product prices, It is the general category of ecological products. The above-mentioned ecological material products, regulatory service products and cultural service products can all be calculated according to this formula. It should be noted that in this plan, there is no specific limitation on the calculation of the value of ecological products, as long as it can realize the calculation of the value of ecological products in the ecological product data table.

[0022] In the above, the comprehensive identification features are used to re-determine the supplementary verification characters in the ecological product data table, and thus the supplementary verification data column is constructed. The supplementary verification characters here are obtained from the ecological product data table. Since the ecological product data table is a calculated data table, the supplementary verification characters determined by the comprehensive identification features may contain data characters that do not exist in the initial ecological data, such as the total value of ecological products obtained by multiplying the output of ecological products and the price of ecological products. Therefore, if there are data characters that do not exist in the initial ecological data, the data characters are marked as endpoint characters, and the extended characters associated with them are obtained with the endpoint characters. Characters, where extended characters refer to endpoint characters as value, and extended characters as area and price. There is a calculation relationship between the three, thereby forming the determination of the extended characters. Furthermore, through the reverse determination of the extended characters, the endpoint characters can be used to form a verification and judgment between the extended characters and the initial ecological data, so as to accurately verify the data characters in the ecological product data table. If there are abnormalities in the extended characters, the extended characters can be corrected to re-correct the ecological product data table. Therefore, combined with the re-generated ecological product data table, the value of the ecological products can be calculated, while improving the accuracy and efficiency of the calculation.

[0023] S3. When the supplementary verification data column is generated, determine whether the ecological product data table is multi-page. If there are multiple pages (at least two pages or more), obtain the distribution position of the supplementary verification characters in the supplementary verification data column in each page of the ecological product data table, thereby locating the row and column where the supplementary verification characters are located, thereby obtaining the distribution status of the supplementary verification characters in each page of the ecological product data table, and thus clarify whether there are distribution characteristics in the rows and columns where the supplementary verification characters are located in the multi-page ecological product data table. The method for determining the distribution characteristics is: The rows and columns where the supplementary verification characters are located in adjacent pages of the ecological product data sheet are the same and increasing (where the supplementary verification characters in one page of the ecological product data sheet are in row 3 and column 6, and the supplementary verification characters in the adjacent ecological product data sheet are in row 4 and column 7, etc., that is, the number of rows and columns gradually increases) or decreasing (the opposite of increasing); It is determined again whether the ecological product data table has character quantity characteristics. The method for determining character quantity characteristics is as follows: It is determined whether the amount of data characters in each page of the ecological product data table is the same. If they are the same, they are marked as character quantity features. Therefore, when calculating other ecological product data tables in the future, if the amount of data characters in each page of other ecological product data tables is the same as the amount of data characters in each page of the current ecological product data table and the number of pages is also the same, the data characters that need to be verified in other ecological product data tables are pre-determined according to the current character quantity features and distribution features. It should be noted here that the data characters of the first page of other ecological product data tables are pre-verified synchronously with the current distribution features, that is, the rows and columns where the supplementary verification characters of the first page of the ecological product data table are located are synchronously verified with other ecological product data tables according to the distribution features. If other ecological product data tables have matched (identical to the ecological product data table) abnormal data characters after verification, the distribution features are continuously executed. Otherwise, the distribution features are not used to verify other ecological product data tables, thereby accelerating the efficiency of correcting abnormalities, improving the efficiency of ecological product value accounting, and avoiding the impact of verification errors on other ecological product data tables.

[0024] It should be noted that if the amount of data characters on each page in other ecological product data tables is different from the amount of data characters on each page in the current ecological product data table, steps S2-S3 are re-executed with other ecological product data tables to redetermine the comprehensive identification features, character quantity features and distribution features of other ecological product data tables, thereby re-verifying other ecological product data tables and calculating the value of ecological products. As a result, multiple different comprehensive identification features, character quantity features and distribution features can be determined in the subsequent calculation of other ecological product data tables. When there are new other ecological product data tables for data character verification, the corresponding comprehensive identification features and distribution features can be determined in advance with the character quantity features (the same amount of data characters) and page numbers that match the new other ecological product data tables, thereby achieving rapid verification of data characters in the new other ecological product data tables, speeding up verification efficiency while also improving ecological product value calculation efficiency.

[0025] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements will not cause the essence of the corresponding technical solutions to deviate from the protection scope of the technical solutions of the embodiments of the present invention.

Claims

1. The method for calculating the value of ecological products of EOD projects is characterized by: The steps include: S1. Obtain the list of ecological products involved in the project and their related data and fill them into an Excel spreadsheet to construct an ecological product data sheet for value calculation; S2. Obtain the repeated characters and related characters in the ecological product data table, extract the repeated characters and related characters to generate a character check set, and determine whether the character check set has an abnormality, wherein: If there is an exception, perform the following steps: Extract abnormal data characters from the character check set, and compare them with the corresponding digital characters of the initial ecological data to obtain the target digital characters, wherein: If there are multiple target data characters, perform feature analysis on the target data characters. Feature analysis includes performing digit recognition feature , Sequential recognition features and character recognition features , thereby obtaining comprehensive identification features, re-determining the supplementary verification characters in combination with the comprehensive identification features, and constructing a supplementary verification data column to check and correct the supplementary verification characters in the supplementary verification data column, so as to regenerate the ecological product data table and perform ecological product value accounting; S3. When the supplementary verification data columns are generated, if there are multiple pages in the ecological product data table, clarify whether there are distribution characteristics and character quantity characteristics in the rows and columns where the supplementary verification characters are located in the multi-page ecological product data table, and apply them to other ecological product data tables based on the distribution characteristics and character quantity characteristics to form a verification calibration for other ecological product data tables, so as to re-execute value accounting for other ecological product data tables.

2. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: The ecological products in the ecological product data sheet include: Ecological material projects: specifically, agricultural products, forestry products, animal husbandry products, fishery products, and ecological energy products; Regulation service items: specifically, water conservation, soil conservation, wind and sand fixation, coastal protection, and water purification; Cultural service projects: specifically, such as leisure and tourism services, and landscape value services.

3. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: The associated character refers to a numeric character that has a calculation influence feature with the repeated character.

4. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: The method for performing feature analysis on the target data characters is: SA, determine the number of digits of the target data character. If the number of digits of the target data characters is the same, the number of digits of the target data character is marked as the digit identification feature. ; ST. Based on the determined number of digits of the target data character, if there is a target data character with at least two digits, the order of the adjacent digits of the target data character is determined from left to right, where: If the target data characters have the same digit size order, the digit size order of the target data characters is marked as the sequential recognition feature. ; SG, determine whether the target data characters have the same characters, if there are the same characters, then mark the same characters as character recognition features ; Determine the number of digits contained in the target data character to identify the characteristics , Sequential recognition features or character recognition feature , comprehensive recognition features are obtained by superimposing the included features; Combined with the comprehensive identification features, the supplementary verification characters are re-determined in the ecological product data table, and a supplementary verification data column is constructed thereby. The supplementary verification characters in the supplementary verification data column are compared with the corresponding digital characters in the initial ecological data to identify abnormal data characters in the ecological product data table and perform corrections accordingly.

5. The method for calculating the value of ecological products of EOD projects according to claim 4 is characterized in that: If the supplementary verification characters include data characters that do not exist in the initial ecological data, the data characters are marked as endpoint characters, and the extended characters associated with them are obtained using the endpoint characters, where: Extended characters refer to digital characters that have a computational association between endpoint characters, so that the extended characters can be verified with the initial ecological data, and the value of ecological products can be calculated in combination with the regenerated ecological product data table.

6. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: The distribution characteristics are determined based on whether the rows and columns where the supplementary verification characters are located in adjacent ecological product data table pages are the same, increasing or decreasing.

7. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: The character quantity feature is determined based on whether the data character quantity in each page of the ecological product data sheet is the same. If the data character quantity is the same, it is marked as a character quantity feature.

8. The method for calculating the value of ecological products of EOD projects according to claim 1 is characterized in that: If there are other ecological product data sheets, perform the following steps: If the number of data characters per page in other eco-product data sheets is the same as that in the current eco-product data sheet and the number of pages is also the same; According to the distribution characteristics, the rows and columns where the supplementary verification characters on the first page of the ecological product data table are located are synchronously verified for other ecological product data tables. If matching abnormal data characters appear in other ecological product data tables after verification, the distribution characteristics are continued to be executed. Otherwise, the distribution characteristics will not be used to verify other ecological product data tables.

9. The method for calculating the value of ecological products of EOD projects according to claim 8 is characterized in that: If the number of data characters per page in other eco-product data sheets is different from the number of data characters per page in the current eco-product data sheet: Re-execute steps S2-S3 with other eco-product data sheets to re-determine the comprehensive identification features, character quantity features, and distribution features of other eco-product data sheets, thereby re-verifying other eco-product data sheets and performing value accounting; By determining multiple different comprehensive identification features, character quantity features and distribution features, if there is a new other ecological product data table for data character verification, the corresponding comprehensive identification features and distribution features are determined in advance with the character quantity features and page numbers that match the new other ecological product data table, so as to form a data character verification for the new other ecological product data table and thereby re-execute the value accounting.

Images