Industrial material price benchmark conversion verification and statistical analysis method and system

Abstract

The application provides an industrial material price benchmark conversion verification and statistical analysis method and system, belonging to the technical field of computer data processing. The method comprises the following steps: determining candidate price records and a target pricing benchmark through material price data and query conditions; performing pricing benchmark processing on the candidate price records through the target pricing benchmark to obtain a comparable price record set, and performing statistics on the comparable price record set to generate a price query result. The method provided by the application unifies industrial material prices of different pricing benchmarks to a target pricing benchmark, while retaining directly comparable price records that do not need to be converted. The conversion results are verified by using data different from the conversion parameter source, so as to prevent invalid or incomplete conversion results from entering the comparable price record set. On this basis, the price records are grouped and counted, so as to improve the comparability, reliability and traceability of the price query result.

Description

Technical Field

[0001] This application relates to the field of computer data processing technology, and in particular to a method and system for converting, verifying and statistically analyzing industrial material price benchmarks. Background Technology

[0002] Industrial material price data typically comes from supplier quotations, purchase records, and market information. Similar materials may be priced by sheet, by meter, by volume, or by weight; when the material type or pricing basis is inconsistent, price records are difficult to compare directly, affecting price inquiries and statistical analysis.

[0003] The relevant technology can be found in Chinese invention patent with authorization announcement number CN119477385B, which discloses the standardization of supplier addresses and regional division, predicts price trends based on historical prices and market data, and generates a supplier list by combining transportation conditions and procurement constraints, thereby realizing automatic price comparison and procurement decision-making.

[0004] The aforementioned technologies are capable of consolidating, predicting, and comparing supplier prices. However, they focus on procurement choices under different supplier and transportation conditions, without addressing the conversion of prices for similar materials under different pricing benchmarks to the target pricing benchmark based on physical quantity relationships, or the verification of the conversion results using independent source data. Price records that have not been converted and verified are unlikely to form a reliable set of comparable prices, thus affecting the accuracy of query and statistical results. Summary of the Invention

[0005] In view of the above-mentioned problems, the present invention is proposed.

[0006] Therefore, the technical problem solved by this invention is that existing methods for converting and verifying industrial material price benchmarks have the following problems when price records use different pricing benchmarks: it is difficult to directly compare price records with the same caliber; the conversion results lack independent source data verification; the reliability of comparable price sets is low; and how to form verifiable price query and statistical results under a unified pricing benchmark.

[0007] To address the aforementioned technical problems, this application provides a method and system for converting, verifying, and statistically analyzing industrial material price benchmarks.

[0008] A first aspect of this application provides a method for converting and verifying industrial material price benchmarks and conducting statistical analysis, comprising: determining candidate price records and target pricing benchmarks through material price data and query conditions.

[0009] The candidate price records are processed using the target pricing benchmark to obtain a set of comparable price records. The comparable price records are then statistically analyzed to generate price query results.

[0010] The pricing benchmark processing includes: determining directly comparable price records and price records to be converted based on the correspondence between candidate price records and target pricing benchmarks.

[0011] The price is converted based on the physical quantity relationship corresponding to the material category, and the price conversion result is verified using verification data from a different source than the original source of the parameters used in the price conversion.

[0012] Based on the verification results, the directly comparable price records and the valid price conversion results are written into the comparable price record set.

[0013] Preferably, determining the candidate price record and the target pricing benchmark includes: filtering candidate price records from the material price data based on the material category and material identity parameters in the query conditions.

[0014] When the query criteria include a specified pricing benchmark, the specified pricing benchmark will be determined as the target pricing benchmark; when the query criteria do not include a specified pricing benchmark, the default pricing benchmark for the corresponding material category will be determined as the target pricing benchmark.

[0015] Preferably, determining the directly comparable price record and the price record to be converted includes: determining the candidate price record whose pricing benchmark is consistent with the target pricing benchmark as the directly comparable price record.

[0016] Candidate price records that are inconsistent with the target pricing benchmark and have material relationship records that match the material category, source pricing benchmark, and target pricing benchmark are identified as price records to be converted.

[0017] Candidate price records that do not have a material relationship record that matches the material category, source pricing benchmark, and target pricing benchmark are marked as incomplete conversion price records.

[0018] Candidate price records that do not have a corresponding physical quantity relationship are marked as incomplete conversion price records.

[0019] Preferably, the physical quantity relationship corresponding to the material category is determined by at least one material relationship record.

[0020] Material relationship records include: material category, source pricing benchmark, target pricing benchmark, physical quantity relationship formula, formula parameter field, parameter source field, relationship version, and validity period.

[0021] When a price conversion cannot be completed directly by a single material relationship record and requires connecting multiple material relationship records, the multiple material relationship records are connected in the order that the output physical quantity of the previous material relationship record is the same as the input physical quantity of the next material relationship record.

[0022] Preferably, the step of converting the price record to be converted includes: writing the numerical conversion parameters in the price record to be converted into the corresponding formula parameter field.

[0023] The main conversion factor is obtained by calculating the number of target pricing units corresponding to one source pricing unit based on the formula for the relationship between physical quantities.

[0024] The target pricing benchmark price is generated based on the ratio of the original price in the price record to the main conversion factor, and the price conversion result is obtained.

[0025] Preferably, the verification data includes: material standard data or independent measured data; Verification conversion factors are generated based on the unit physical quantity conversion values ​​in the material standard data or the ratios of physical quantities in the independent measured data.

[0026] When the data source identifier of the verification data is different from the data source identifier of the parameters used for price conversion, the corresponding material standard data or independent measured data will be used to verify the price conversion result.

[0027] Preferably, the verification of the price conversion result includes: generating a verification result based on the relative deviation between the main conversion factor and the verification conversion factor.

[0028] When the relative deviation is not greater than the allowable deviation for the corresponding material category, the price conversion result is determined to be valid; when the relative deviation is greater than the allowable deviation, the price conversion result is determined to be invalid.

[0029] When no corresponding verification data exists, the price conversion result is determined to be incomplete, and invalid or incomplete price conversion results are prohibited from being written into the comparable price record set.

[0030] Preferably, the statistical analysis of the comparable price record set includes: grouping the comparable price record set according to material identity parameters and target pricing benchmark.

[0031] Calculate the average price, lowest price, highest price, price range, and number of records for each group of price records.

[0032] Based on the calculation results of each group of price records, corresponding price statistics are generated, and price query results are generated based on the price statistics.

[0033] Preferably, statistical analysis of the comparable price record set also includes: establishing the correlation between price records, material relationship records, parameters used for price conversion, and verification results.

[0034] When the parameters used in material relationship records or price conversions are updated, the affected price records are determined based on the relationships.

[0035] The affected price records are re-calibrated based on the pricing benchmark, and the price query results are regenerated based on the updated set of comparable price records.

[0036] Another objective of this invention is to provide an industrial material price benchmark conversion verification and statistical analysis system. This system can distinguish between directly comparable price records and price records to be converted by using a target pricing benchmark, convert the price records to be converted according to the physical quantity relationship of materials, and verify the conversion results using verification data from different sources. This solves the problem that current price analysis techniques often suffer from difficulties in unifying price data for different pricing benchmarks and insufficient reliability of conversion results.

[0037] As a preferred embodiment of the industrial material price benchmark conversion verification and statistical analysis system of the present invention, it includes: a recording determination unit, a benchmark processing unit, and a statistical output unit.

[0038] The record determination unit is used to determine candidate price records and target pricing benchmarks based on material price data and query conditions.

[0039] The benchmark processing unit is used to process the candidate price records using the target pricing benchmark to obtain a set of comparable price records.

[0040] The statistical output unit is used to perform statistics on the set of comparable price records and generate price query results.

[0041] The beneficial effects of the industrial material price benchmark conversion verification and statistical analysis method and system provided in this application are as follows: it unifies the prices of industrial materials with different pricing benchmarks to the target pricing benchmark, while retaining directly comparable price records that do not require conversion; it verifies the conversion results using data from different sources than the conversion parameters to prevent invalid or incompletely verified conversion results from entering the comparable price record set; and it groups and statistically analyzes the price records on this basis, thereby improving the comparability, reliability, and traceability of the price query results. Attached Figure Description

[0042] Figure 1 A schematic diagram illustrating the price record pricing benchmark processing for a method of converting, verifying, and statistically analyzing industrial material price benchmarks. Figure 2 A schematic diagram illustrating the conversion factor verification of a method for converting and statistically analyzing industrial material price benchmarks; Figure 3 This is a schematic diagram of the statistical results of comparable price records for a method of converting and verifying industrial material price benchmarks and conducting statistical analysis. Figure 4 This is a schematic diagram of a system for converting, verifying, and statistically analyzing industrial material price benchmarks. Detailed Implementation

[0043] In the following description, specific details such as particular system architectures and techniques are set forth for illustrative purposes and not for limitation, in order to provide a thorough understanding of the embodiments of this application. However, those skilled in the art will understand that this application may also be implemented in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, apparatuses, circuits, and methods have been omitted so as not to obscure the description of this application with unnecessary detail.

[0044] To make the purpose, technical solution, and advantages of this application clearer, the following will be described in conjunction with the appendix. Figure 1 - Appendix Figure 4 The following is an explanation using specific examples.

[0045] Example 1

[0046] Reference Figure 1 This is an embodiment of the present invention, which provides a specific implementation method for determining candidate price records and target pricing benchmarks in an industrial material price benchmark conversion verification and statistical analysis method.

[0047] First, obtain material price data and query criteria.

[0048] Material price data is stored in the form of price records. Each price record includes at least a price record identifier, material category, material identification parameters, original price, source pricing benchmark, price collection time, and data source identifier.

[0049] Material identity parameters are a set of attribute fields used to distinguish different material objects within the same material category. Different material categories correspond to pre-defined essential identity parameters. For example, the essential identity parameters for the steel plate category include material grade, length, width, and thickness. Price records lacking a material category or any of these essential identity parameters will not participate in the candidate price record selection process.

[0050] A pricing benchmark must include at least: a currency unit, a unit of measurement for the physical quantity being priced, and a measurement caliber. The measurement caliber is used to distinguish between theoretical and actual measurements. For example, although RMB yuan / theoretical kilogram and RMB yuan / measured kilogram use the same currency unit and unit of measurement for the physical quantity being priced, their measurement calibers differ, and therefore they belong to different pricing benchmarks.

[0051] For price records priced per sheet, coil, or unit that do not directly involve theoretical or actual measurement, the source pricing benchmark is determined according to the corresponding pricing object. For example, steel plates quoted per sheet correspond to RMB yuan per sheet.

[0052] The query criteria must include at least: material category and corresponding material identification parameters, and may also include: price collection period, applicable region, tax-inclusive status, and specified pricing benchmark. The price collection period, applicable region, and tax-inclusive status are used to filter price records with consistent price criteria and are not involved in physical quantity conversion.

[0053] Taking a query for the price of a steel plate with grade Q235B, a length of 2 meters, a width of 1 meter, and a thickness of 0.01 meters as an example, the material category in the query conditions is steel plate, and the material identification parameters are Q235B, 2 meters, 1 meter, and 0.01 meters. The specified pricing basis is RMB yuan / theoretical kilogram. The query conditions also limit the price collection period, the applicable region, and whether tax is included.

[0054] If the query criteria are missing a material category or any necessary identity parameter, an incomplete query status will be generated and the query will be terminated.

[0055] Furthermore, candidate price records are filtered based on the query criteria.

[0056] Price records that meet the query criteria in terms of material category, material identity parameters, price collection period, applicable price region, and tax-inclusive status are identified as candidate price records.

[0057] For example, the material price data includes price record R1 and price record R2. Price record R1 corresponds to Q235B steel plate with specifications of 2 meters × 1 meter × 0.01 meters, and the original price is 589 yuan / sheet, with the source pricing basis being RMB yuan / sheet; price record R2 corresponds to steel plate of the same grade and specifications, with an original price of 3.75 yuan / theoretical kilogram, and the source pricing basis being RMB yuan / theoretical kilogram.

[0058] The material identity parameters and applicable price conditions of price records R1 and R2 both meet the query conditions, therefore price records R1 and R2 are identified as candidate price records.

[0059] Price records whose material grade, length, width, thickness, or other necessary identification parameters do not match the search criteria will not be considered as candidate price records. Price records whose price collection period, applicable region, or tax-inclusive status does not meet the search criteria will also not be considered as candidate price records.

[0060] Furthermore, the target pricing benchmark was determined.

[0061] When the query criteria include a specified pricing benchmark, it is determined whether the specified pricing benchmark belongs to the pricing benchmarks allowed for the corresponding material category. If the specified pricing benchmark matches the corresponding relationship, it is determined as the target pricing benchmark; if the specified pricing benchmark does not match the corresponding relationship, a pricing benchmark inapplicable status is generated and the query is terminated.

[0062] When the query criteria do not include a specified pricing benchmark, the default pricing benchmark is retrieved based on the correspondence between the material category and the default pricing benchmark. The default pricing benchmark for steel plate can be set to RMB yuan / theoretical kilogram.

[0063] When there is no default pricing benchmark for the corresponding material category, a target pricing benchmark missing status is generated, and no price conversion or statistics are performed on the candidate price records.

[0064] Furthermore, the candidate price records are categorized based on their correspondence with the target pricing benchmark.

[0065] Compare the source pricing benchmark with the target pricing benchmark for each candidate price record.

[0066] When the source pricing benchmark and the target pricing benchmark are consistent in terms of currency unit, unit of pricing physical quantity, and measurement scope, the corresponding candidate price record will be determined as a directly comparable price record.

[0067] The source pricing benchmark for price record R2 is RMB yuan / theoretical kilogram, which is consistent with the target pricing benchmark. Therefore, price record R2 is determined to be a directly comparable price record.

[0068] When the source pricing benchmark and the target pricing benchmark are inconsistent, the material relationship record is queried according to the material category, the source pricing benchmark, and the target pricing benchmark.

[0069] The source pricing benchmark for price record R1 is RMB yuan per sheet, which is inconsistent with the target pricing benchmark of RMB yuan per theoretical kilogram. Since the steel plate category has a physical quantity relationship for calculating the theoretical weight of each steel plate based on its length, width, thickness, and theoretical gravimetric density, price record R1 is identified as the price record to be converted.

[0070] If there is no physical quantity relationship between the source pricing benchmark and the target pricing benchmark, the corresponding candidate price record will be marked as an incomplete conversion price record and will not be allowed to enter the price statistics process.

[0071] If a corresponding physical quantity relationship exists, but the candidate price record lacks the parameters required by the physical quantity relationship formula, or the parameter units cannot be converted to the units specified in the formula, the corresponding candidate price record will also be marked as an incomplete conversion price record, and the fields with missing parameters or incorrect units will be recorded.

[0072] Furthermore, pricing benchmark processing is performed on directly comparable price records and price records to be converted.

[0073] For directly comparable price records, retain the original price and target pricing benchmark, and write the directly comparable price records into the comparable price record set.

[0074] For the price records to be converted, the price is converted according to the physical quantity relationship corresponding to the material category, and the price conversion result is verified using verification data from a different source than the parameters used in the price conversion.

[0075] When the price conversion result is verified to be valid, a converted price record is generated, including the original price record identifier, the target pricing benchmark, and the target pricing benchmark price, and the converted price record is written into the comparable price record set.

[0076] When the price conversion result is determined to be invalid or the verification is incomplete, the corresponding converted price record will not be written into the comparable price record set.

[0077] Finally, the comparable price record set is statistically analyzed to generate price query results.

[0078] Example 2

[0079] Reference Figure 2 This invention provides a specific implementation method for price conversion and independent verification based on the relationship between physical quantities of materials in an industrial material price benchmark conversion verification and statistical analysis method.

[0080] First, establish material relationship records corresponding to material categories.

[0081] Each material relationship record should include at least the following: material relationship record identifier, material category, source pricing benchmark, target pricing benchmark, physical quantity relationship formula, formula parameter field, parameter source field, relationship version, and validity period.

[0082] Record the input physical quantity type, input physical quantity unit, output physical quantity type, and output physical quantity unit of the physical quantity relationship formula, which is used to determine whether the physical quantity relationship is applicable to the corresponding price record.

[0083] For materials that can be converted using a single physical quantity relationship formula, use one material relationship record and do not artificially split the same calculation process into multiple material relationship records.

[0084] Taking the conversion of steel plate price from RMB yuan / sheet to RMB yuan / theoretical kilogram as an example, a material relationship record is used.

[0085] The specific formulas for the physical quantity relationships in the material relationship record are as follows:

[0086] The formula inputs are length, width, thickness, and theoretical weight density, and the formula output is the theoretical weight corresponding to one source pricing unit.

[0087] Multiple material relationship records should only be connected when the conversion cannot be completed directly through a single material relationship record. When connecting, the target pricing benchmark of the preceding material relationship record should be consistent with the source pricing benchmark of the following material relationship record, and the output physical quantity type and unit of the preceding material relationship record should also be consistent with the input physical quantity type and unit of the following material relationship record.

[0088] For the same material category, source pricing benchmark, target pricing benchmark, and validity period, only one valid direct material relationship record or a set of valid material relationship record connection paths will be retained. When conflicting valid records exist, the corresponding price conversion will not be performed, and a relationship configuration conflict state will be generated.

[0089] Furthermore, valid material relationship records are determined based on the price records to be converted.

[0090] Match the material category, source pricing benchmark, and target pricing benchmark of the price record to be converted with the material relationship record, and determine the corresponding relationship version based on the price collection time.

[0091] When the price collection time falls within the valid period of any material relationship record, the corresponding relationship version is used. When the price collection time does not fall within the valid period of any material relationship record, the latest relationship version is not used to replace the historical relationship version; instead, the corresponding price record is marked as incomplete conversion.

[0092] Furthermore, the numerical parameters in the price records to be converted are written into the physical quantity relationship formula.

[0093] Read the length, width, and thickness from the material specification record A associated with the price record R1, and read the theoretical weight density of the Q235B steel plate from the material property record B.

[0094] Material specification record A lists the length as 2 meters, the width as 1 meter, and the thickness as 0.01 meters. Material property record B lists the theoretical gravimetric density as 7850 kg / m³. All parameters are positive values ​​and the units conform to the requirements of the physical quantity relationship formula; therefore, price conversion is permitted.

[0095] If any required parameter is empty, has a value less than or equal to zero, or its unit cannot be converted to the unit specified in the formula, the conversion of the corresponding price record shall be stopped and marked as incomplete. Zero values, historical averages, or unconfirmed default values ​​must not be used to replace missing parameters.

[0096] Furthermore, the main conversion factors are calculated.

[0097] The theoretical weight of a single steel plate is calculated based on its length, width, thickness, and theoretical gravimetric density.

[0098] A preferred method for calculating the theoretical weight of a single steel plate is as follows: 2 × 1 × 0.01 × 7850 = 157 kg.

[0099] The source pricing unit for price record R1 is sheets, and the target pricing unit is theoretical kilograms. Therefore, the main conversion factor is 157 theoretical kilograms / sheet.

[0100] A preferred method for calculating the target pricing benchmark price is as follows:

[0101] in, This represents the original price of the price record to be converted. Indicates the target pricing benchmark price. This represents the primary conversion factor, which is the number of target pricing units corresponding to one source pricing unit.

[0102] The unit is RMB yuan per note. The unit is theoretical kilograms per sheet. The unit is RMB yuan per theoretical kilogram.

[0103] The original price of price record R1 was 589 yuan per share, therefore the target pricing benchmark price is... The specific calculation is expressed as follows:

[0104] The main conversion factor is used in price conversion with full precision, and the target pricing benchmark price is retained to four decimal places when generating the converted price record. If the main conversion factor is less than or equal to zero, no target pricing benchmark price is generated.

[0105] Furthermore, verify the price conversion parameters and the source of the verification data.

[0106] Material specification record A preserves the original source of length, width, and thickness, while material property record B preserves the original source of theoretical gravimetric density. When different data records are copied from the same source data, they retain the same original source identifier and are not identified as having different sources due to different data storage locations.

[0107] When using independent measured data for verification, the independent measured data should correspond to the same material category, material identification parameters, and measurement object as the price record. When the price record has a material batch identifier, the independent measured data corresponding to the same supplier and the same acceptance batch as the price record should be used first.

[0108] Price record R1 is a historical purchase price record that has been accepted. Its associated batch weighing record C records that the net weight of 100 steel plates in the same batch is 15620 kg. Based on the ratio of net weight to the number of steel plates, the verification conversion factor is 156.2 kg / plate.

[0109] Batch weighing record C is derived directly from the weighing results of this batch and does not reference the calculation results in material specification record A or material property record B. Therefore, batch weighing record C and the parameters used for price conversion have different data sources.

[0110] Independent measured data are only used to verify whether the main conversion factor is within the allowable deviation range. RMB / theoretical kilogram is not changed to RMB / measured kilogram, nor is measured weight used to replace the main conversion factor that has already passed the verification.

[0111] For price records without corresponding acceptance batches, applicable material standard data should be selected for verification according to the material verification rules. The material standard data should be consistent with the material category, material identification parameters, and measurement caliber of the price record, and its validity period should also cover the price collection time.

[0112] When material standard data and price conversion parameters reference the same source data, the corresponding material standard data is not considered independent verification data. If no verification data exists that meets the criteria of independent material object, validity period, and source, the price conversion result is determined to be incomplete verification.

[0113] Furthermore, a verification result is generated based on the relative deviation between the main conversion factor and the verification conversion factor.

[0114] A preferred method for calculating the relative deviation is:

[0115] in, This indicates the verification conversion factor. Indicates relative deviation.

[0116] and Both represent the quantity of target pricing units corresponding to a source pricing unit, and the physical quantity type and unit of both must be consistent.

[0117] If the verification conversion factor is empty or less than or equal to zero, the relative deviation is not calculated, and the corresponding verification data is determined to be unusable.

[0118] The main conversion factor for price record R1 is 157 kg / sheet, the verification conversion factor is 156.2 kg / sheet, and the relative deviation is calculated to be 0.512%, specifically:

[0119] The material verification rules record the allowable deviation, the supporting documentation for the allowable deviation, and the validity period. The allowable deviation is determined before price conversion and will not be adjusted temporarily based on the current conversion result.

[0120] To illustrate the verification process, the allowable deviation in the material verification rules corresponding to price record R1 is shown. Use 2%. This value is only used to illustrate the comparison between relative deviation and allowable deviation, and does not mean that all steel plates use a 2% allowable deviation.

[0121] The relative deviation of 0.512% is not greater than the allowable deviation of 2%. Therefore, the price conversion result of price record R1 is determined to be valid, and a converted price record with a target pricing benchmark price of 3.7516 yuan / theoretical kilogram is generated.

[0122] If the relative deviation is greater than the allowable deviation, the price conversion result will be determined as invalid, and the corresponding converted price record will not be written into the comparable price record set.

[0123] If no valid data is found, the price conversion result will be determined as incomplete, and the corresponding converted price record will not be written into the comparable price record set.

[0124] When the relative deviation equals the allowable deviation, it is treated as valid. The relative deviation calculation uses the unrounded main conversion factor and the check conversion factor to avoid changing the check status due to display precision.

[0125] Example 3 Reference Figure 3 This is an embodiment of the present invention, which provides a specific implementation method for performing price statistics and reprocessing the updated results based on the conversion basis in the method for converting and verifying industrial material price benchmarks.

[0126] First, obtain a set of comparable price records.

[0127] The set of comparable price records includes directly comparable price records whose pricing benchmark is consistent with the target pricing benchmark, as well as converted price records that have been converted and verified as valid.

[0128] Invalid price conversion results, incompletely validated price conversion results, and incompletely converted price records are not written into the comparable price record set and therefore do not participate in price statistics.

[0129] Furthermore, the comparable price record set is grouped according to material identity parameters and target pricing benchmark.

[0130] After conversion and verification, price record R1 corresponds to a target pricing benchmark price of 3.7516 yuan / theoretical kilogram. Price record R2 is a directly comparable price record with a price of 3.75 yuan / theoretical kilogram.

[0131] The comparable price record set also includes price record R3 and price record R4. Price records R3 and R4 have the same material grade, length, width, and thickness as price record R1, and meet the same price collection period, applicable price region, tax-inclusive status, and theoretical measurement caliber. The prices of price records R3 and R4 are 3.74 yuan / theoretical kg and 3.76 yuan / theoretical kg, respectively.

[0132] The material identity parameters and target pricing benchmarks of price records R1, R2, R3 and R4 are consistent, so the four price records are grouped into the same price statistics group.

[0133] If there are no price records matching the query criteria in the comparable price record set, the number of generated records is zero or there are no comparable prices. The average price, lowest price, highest price, and price range are not generated.

[0134] Furthermore, the price statistics for each group of price records are calculated.

[0135] For a price statistics group containing n price records, the sum of the prices of each price record is divided by the number of records n to obtain the average price; the minimum price in the group is determined as the lowest price; the maximum price in the group is determined as the highest price; and the difference between the highest price and the lowest price is determined as the price range.

[0136] The above price statistics group includes four price records: 3.7516 yuan / theoretical kg, 3.75 yuan / theoretical kg, 3.74 yuan / theoretical kg, and 3.76 yuan / theoretical kg.

[0137] The average price is 3.7504 yuan / theoretical kg, the lowest price is 3.74 yuan / theoretical kg, the highest price is 3.76 yuan / theoretical kg, the price range is 0.02 yuan / theoretical kg, and the number of records is 4.

[0138] When the price statistics group includes only one price record, the price of that price record is simultaneously determined as the average price, the lowest price, and the highest price, and the price range is set to zero.

[0139] Directly comparable price records and effective converted price records are statistically analyzed using the same method, without different weights assigned based on record type.

[0140] Furthermore, the price statistics are composed of material identity parameters, target pricing benchmark, average price, lowest price, highest price, price range, and number of records, and price query results are generated based on the query conditions.

[0141] Furthermore, establish the correlation between price records and conversion bases.

[0142] For each converted price record, save the correspondence between the converted price record identifier, the original price record identifier, the material relationship record identifier and version, the source and version of the conversion parameters, the source and version of the verification data, the main conversion factor, the verification conversion factor, and the verification status.

[0143] For price conversion results that are invalid or incompletely verified, their association with material relationship records and conversion parameters is also preserved. After the corresponding material relationship records or conversion parameters are corrected, the affected price records can be re-determined based on this association.

[0144] Directly comparable price records have not undergone material relationship conversion, and their material relationship record identifier and conversion parameter association fields are empty. Therefore, when material relationship records or conversion parameters are updated, directly comparable price records are not identified as affected price records.

[0145] Furthermore, determine whether updates to material relationship records or conversion parameters affect existing price records.

[0146] If the update is only used to establish a new material relationship version that will take effect in the future, and the validity period of the new version does not cover the price collection time of the existing price record, the existing price record will not be reprocessed.

[0147] When an update is used to correct an existing material relationship version, or when the validity period of the update covers the price collection time of an existing price record, the affected price record is determined based on the material relationship record identifier, parameter source, version number, and validity period.

[0148] Therefore, future versions will not change historical price conversion results; only price records that actually reference the revised material relationship records or conversion parameters will be re-processed for pricing benchmarks.

[0149] Furthermore, the affected price records will be re-processed with a new pricing benchmark.

[0150] When the length, width, or thickness in material specification record A, or the theoretical weight density in material property record B, is corrected after verification from the original source, the price record referencing the parameters before the correction is determined based on the preserved association.

[0151] The corrected parameters are read, and the quantity of target pricing units corresponding to one source pricing unit is recalculated according to the publicly available physical quantity relationship formula to obtain the updated master conversion factor. Then, based on the ratio of the original price to the updated master conversion factor, the updated target pricing benchmark price is generated.

[0152] Subsequently, based on the verification data that is from a different source than the price conversion parameters and is still within its validity period, the verification conversion coefficients are regenerated and the relative deviation is recalculated.

[0153] If the relative deviation is not greater than the allowable deviation, the regenerated converted price record will be determined as valid; if the relative deviation is greater than the allowable deviation, the regenerated price conversion result will be determined as invalid; if there is no valid verification data, the regenerated price conversion result will be determined as incomplete verification.

[0154] Furthermore, the price query results are updated based on the reprocessed set of comparable price records.

[0155] When a valid converted price record is obtained after reprocessing, the new converted price record is used in the statistics of the corresponding price statistics group. If the reprocessing result is invalid or the verification is incomplete, the corresponding converted price record is not used in the statistics.

[0156] During reprocessing, the original price record, original conversion parameters, and original verification results are not deleted. The original converted price record is retained for review and is marked as having been replaced by the new version. The current price query only reads the converted price record corresponding to the currently valid conversion basis, avoiding the simultaneous inclusion of old and new conversion results for the same original price record in the statistics.

[0157] If, during the reprocessing process, physical quantity relationships cannot be connected, necessary parameters are missing, parameter units are incorrect, or verification data is unavailable, the affected price records will be marked as pending processing, and intermediate prices that have not yet been verified will not be written into the current comparable price record set.

[0158] After the abnormal data has been corrected, price conversion, independent verification, and statistical updates will be performed on the corresponding price records.

[0159] Example 4 Reference Figure 4 As an embodiment of the present invention, an industrial material price benchmark conversion verification and statistical analysis system is provided, including: a recording determination unit 1, a benchmark processing unit 2, and a statistical output unit 3.

[0160] The input to the record determination unit 1 is material price data and query conditions, and the output is candidate price records and the target pricing benchmark. The input to the benchmark processing unit 2 is candidate price records and the target pricing benchmark, and the output is a set of comparable price records. The input to the statistical output unit 3 is the set of comparable price records, and the output is the price query results.

[0161] First, record and determine the material price data and query conditions received by Unit 1.

[0162] Each price record in the material price data should include at least the price record identifier, material category, material identification parameters, original price, source pricing benchmark, price collection time, and data source identifier.

[0163] The query criteria should at least include the material category and corresponding material identification parameters, and may also include the price collection period, applicable region, tax-inclusive status, and specified pricing benchmark. The pricing benchmark includes the currency unit, unit of measurement for the physical quantity being priced, and measurement scope.

[0164] Unit 1 checks whether the material category and necessary identity parameters in the query conditions are complete. After the check is passed, candidate price records are filtered based on the material category, material identity parameters, and the applicable price conditions specified in the query conditions.

[0165] When the query conditions include a specified pricing benchmark, the record determination unit 1 will determine the specified pricing benchmark that is compatible with the corresponding material category as the target pricing benchmark; when the query conditions do not include a specified pricing benchmark, the default pricing benchmark of the corresponding material category will be determined as the target pricing benchmark.

[0166] If the query conditions are incomplete, the specified pricing benchmark is not applicable to the corresponding material category, or there is no default pricing benchmark, the record determination unit 1 generates the corresponding abnormal status and does not pass the candidate price record to the benchmark processing unit 2.

[0167] Furthermore, the record determination unit 1 transmits the candidate price record and the target pricing benchmark to the benchmark processing unit 2.

[0168] Benchmark processing unit 2 compares the source pricing benchmark and the target pricing benchmark of the candidate price records. When the source pricing benchmark and the target pricing benchmark are consistent in currency unit, unit of pricing physical quantity, and measurement scope, the corresponding candidate price record is determined as a directly comparable price record.

[0169] When the source pricing benchmark and the target pricing benchmark are inconsistent, the benchmark processing unit 2 determines the valid material relationship record based on the material category, source pricing benchmark, target pricing benchmark and price collection time.

[0170] When a direct physical quantity relationship exists, price conversion is performed using only one material relationship record. When no direct physical quantity relationship exists, multiple material relationship records are connected according to the pricing basis and physical quantity correspondence of adjacent material relationship records. If a complete physical quantity relationship does not exist, the material relationship record is not valid, or the necessary conversion parameters are missing, the corresponding candidate price record is marked as incomplete conversion.

[0171] Furthermore, the benchmark processing unit 2 performs price conversion on the price record to be converted.

[0172] The benchmark processing unit 2 converts the numerical parameters in the price record to be converted into units specified by the physical quantity relationship formula, writes the converted parameters into the corresponding formula parameter field, calculates the number of target pricing units corresponding to one source pricing unit, and obtains the main conversion coefficient.

[0173] When the main conversion factor is greater than zero, the target pricing benchmark price is generated based on the ratio of the original price of the price record to be converted to the main conversion factor. When the main conversion factor is less than or equal to zero, necessary parameters are missing, or parameter units cannot be converted, the conversion of the corresponding price record is stopped, and the corresponding price record is marked as incomplete conversion.

[0174] Furthermore, the benchmark processing unit 2 verifies the price conversion results.

[0175] The benchmark processing unit 2 reads the data source and original source of the price conversion parameters, and then reads the data source and original source of the verification data.

[0176] When the verification data and price conversion parameters do not have the same original source, and the material category, material identity parameters, measurement object and validity period corresponding to the verification data all meet the verification conditions, a verification conversion factor is generated based on the unit physical quantity conversion value in the material standard data or the physical quantity ratio in the independent measured data.

[0177] The reference processing unit 2 generates a verification status based on the relative deviation between the main conversion factor and the verification conversion factor. If the relative deviation is not greater than the allowable deviation for the corresponding material category, the price conversion result is determined to be valid; if the relative deviation is greater than the allowable deviation, the price conversion result is determined to be invalid; if there is no verification data that meets the conditions, the price conversion result is determined to be incomplete verification.

[0178] Independent measured data are used only to verify the main conversion factor and do not change the theoretical or actual measurement caliber defined by the target pricing benchmark.

[0179] The benchmark processing unit 2 writes directly comparable price records and converted price records containing valid price conversion results into the comparable price record set. Invalid, incompletely validated, or incompletely converted price records are not written into the comparable price record set.

[0180] Furthermore, the benchmark processing unit 2 transmits the set of comparable price records to the statistical output unit 3.

[0181] The statistical output unit 3 groups the comparable price record set according to the material identity parameters and the target pricing benchmark, calculates the average price, lowest price, highest price, price range and number of records for each group, and combines the statistical results of each group into a price query result.

[0182] When the set of comparable price records is empty, the statistical output unit 3 outputs a record count of zero and a state with no comparable prices, and does not generate the average price, lowest price, highest price, and price range.

[0183] When a price statistics group contains only one price record, the statistical output unit 3 simultaneously determines the price of that price record as the average price, the lowest price, and the highest price, and sets the price range to zero.

[0184] Furthermore, the benchmark processing unit 2 stores the correlation between price records, material relationship records, price conversion parameters, and verification results.

[0185] When material relationship records or conversion parameters are updated, the benchmark processing unit 2 determines the affected price records based on the validity period, version number, and association of the updated records.

[0186] When creating a new version that will take effect in the future, and the validity period of the new version does not cover the price collection time of existing price records, the existing price records will not be reprocessed. When updating to correct an existing version or when the validity period of the update covers the price collection time of existing price records, the price records that actually reference the corresponding version or parameters will be recalculated and verified.

[0187] When a valid price conversion result is obtained through reprocessing, the benchmark processing unit 2 generates a new converted price record and marks the original converted price record as having been replaced by the new version; if the reprocessing result is invalid, incomplete in verification, or incomplete in conversion, the corresponding converted price record is not written into the current comparable price record set.

[0188] Finally, the benchmark processing unit 2 transmits the updated set of comparable price records to the statistical output unit 3, which then regenerates the price query results based on the updated set of comparable price records.

[0189] The above are merely specific embodiments of this application, but the scope of protection of this application is not limited thereto. Any person skilled in the art can easily conceive of various equivalent modifications or substitutions within the technical scope disclosed in this application, and these modifications or substitutions should all be covered within the scope of protection of this application. Therefore, the scope of protection of this application should be determined by the scope of the claims.

Claims

1. A method for converting, verifying, and statistically analyzing industrial material price benchmarks, characterized in that, include: Candidate price records and target pricing benchmarks are determined by using material price data and query criteria; A set of comparable price records is obtained by processing the candidate price records using the target pricing benchmark. Statistical analysis is then performed on this set to generate price query results. The process of processing the pricing benchmark includes: Based on the correspondence between candidate price records and target pricing benchmarks, determine directly comparable price records and price records to be converted; Based on the physical quantity relationship corresponding to the material category, the price record to be converted is converted, and the price conversion result is verified using verification data from a different source than the original source of the parameters used in the price conversion. Based on the verification results, the directly comparable price records and the valid price conversion results are written into the comparable price record set.

2. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 1, characterized in that, The determination of candidate price records and target pricing benchmarks includes: Based on the material category and material identity parameters in the query conditions, filter candidate price records from the material price data; When the query criteria include a specified pricing benchmark, the specified pricing benchmark will be determined as the target pricing benchmark; When the query criteria do not include the specified pricing benchmark, the default pricing benchmark for the corresponding material category will be determined as the target pricing benchmark.

3. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 2, characterized in that, The determination of directly comparable price records and price records to be converted includes: Candidate price records whose pricing benchmark is consistent with the target pricing benchmark are identified as directly comparable price records; Candidate price records that are inconsistent with the target pricing benchmark and have material relationship records that match the material category, source pricing benchmark and target pricing benchmark are identified as price records to be converted. Candidate price records that do not have material relationship records that match the material category, source pricing benchmark, and target pricing benchmark of the candidate price record are marked as incomplete conversion price records; Candidate price records that do not have a corresponding physical quantity relationship are marked as incomplete conversion price records.

4. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 3, characterized in that, The physical quantity relationships corresponding to the material category are determined by at least one material relationship record; Material relationship records include: material category, source pricing benchmark, target pricing benchmark, physical quantity relationship formula, formula parameter field, parameter source field, relationship version, and validity period; When a price conversion cannot be completed directly by a single material relationship record and requires connecting multiple material relationship records, the multiple material relationship records are connected in the order that the output physical quantity of the previous material relationship record is the same as the input physical quantity of the next material relationship record.

5. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 4, characterized in that, The price conversion of the price record to be converted includes: Write the numerical conversion parameters from the price record to be converted into the corresponding formula parameter field; Calculate the quantity of target pricing units corresponding to one source pricing unit based on the physical quantity relationship formula, and obtain the main conversion factor; The target pricing benchmark price is generated based on the ratio of the original price in the price record to the main conversion factor, and the price conversion result is obtained.

6. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 5, characterized in that, The verification data includes: material standard data or independent measured data; Generate verification conversion coefficients based on the unit physical quantity conversion values ​​in the material standard data or the physical quantity ratios in the independent measured data. When the data source identifier of the verification data is different from the data source identifier of the parameters used for price conversion, the corresponding material standard data or independent measured data will be used to verify the price conversion result.

7. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 6, characterized in that, The verification of the price conversion results includes: The verification result is generated based on the relative deviation between the main conversion factor and the verification conversion factor; When the relative deviation is not greater than the allowable deviation for the corresponding material category, the price conversion result is determined to be valid; When the relative deviation is greater than the allowable deviation, the price conversion result will be determined as invalid. When no corresponding verification data exists, the price conversion result is determined to be incomplete, and invalid or incomplete price conversion results are prohibited from being written into the comparable price record set.

8. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 7, characterized in that, The statistical analysis of the comparable price record set includes: The comparable price record set is grouped according to material identity parameters and target pricing benchmark; Calculate the average price, lowest price, highest price, price range, and number of records for each group of price records; Based on the calculation results of each group of price records, corresponding price statistics are generated, and price query results are generated based on the price statistics.

9. The method for converting, verifying, and statistically analyzing industrial material price benchmarks according to claim 8, characterized in that, Statistical analysis of comparable price record sets also includes: Establish the correlation between price records, material relationship records, parameters used in price conversion, and verification results; When the parameters used in material relationship records or price conversions are updated, the affected price records are determined based on the relationships. The affected price records are re-calibrated based on the pricing benchmark, and the price query results are regenerated based on the updated set of comparable price records.

10. A system for converting, verifying, and statistically analyzing industrial material price benchmarks, characterized in that, include: Record determination unit (1), benchmark processing unit (2), statistical output unit (3); The record determination unit (1) is used to determine the candidate price record and the target pricing benchmark through material price data and query conditions; The benchmark processing unit (2) is used to process the candidate price records with the target pricing benchmark to obtain a set of comparable price records; The statistical output unit (3) is used to perform statistics on the set of comparable price records and generate price query results.

Images