Accurate material number matching method based on resistance value grading

Abstract

The invention discloses an accurate material number matching method based on resistance value grading, which comprises the following steps: establishing a fuzzy material number matching table and a character code rule resistance value library based on excel software, and storing standard resistance values and corresponding codes under different resistance value grades; the method specifically comprises the following steps that A1, initialization preparation is conducted, user selection is obtained, and an output area is emptied; a2, a default resistance grading standard is determined, and a recommended grading standard is automatically judged according to the numerical value of a certain column of the selected row; a3, acquiring a user instruction; a4, matching and screening resistance values, positioning a data source, performing circular traversal and performing range screening; and A5, material number information is generated and filled in, a complete material record is generated for each qualified resistance value passing screening, it is ensured that the generated material number accords with a set standard resistance value series, and specification information is accurate.

Description

Technical Field

[0001] This invention belongs to the field of resistance value classification technology, specifically, it relates to a precise part number matching method based on resistance value classification. Background Technology

[0002] Surface mount resistors are miniaturized electronic components, a type of resistor, primarily used for limiting current, voltage division, or as a load in circuits. They are manufactured using surface mount technology (SMT) and typically consist of a ceramic substrate, a resistive film (such as a metal alloy film), an electrode layer, and a protective layer. They are mostly rectangular or square in shape and are much smaller than traditional through-hole resistors (such as axial lead resistors).

[0003] Currently, there are numerous mainstream resistor manufacturers on the market. Surface mount resistors are further classified into various models based on performance, application, and manufacturing process. Among these numerous electronic component manufacturers, each has its own set of naming and classification rules for resistor specifications. This means that when we want to replace a model A surface mount resistor from manufacturer A with its corresponding model B from manufacturer B, we have to go through a lengthy process of searching, comparing, and finally confirming the information. This process is extremely time-consuming and labor-intensive. Moreover, this process is extremely important. For example, if a high-power resistor resistant to sulfur is mistakenly replaced with an ordinary high-power resistor, the system may still function normally initially, but the ordinary resistor will quickly fail in a sulfur atmosphere, eventually leading to an accident.

[0004] Therefore, the existing technology, which involves manually matching product models from different companies, has the following problems: 1. It is time-consuming, requires matching key resistor performance characteristics such as voltage, power, and temperature coefficient, and the search process is difficult due to different naming rules; 2. There is a risk of error. Because of human involvement, accidental errors are unavoidable. Summary of the Invention

[0005] To address the shortcomings of existing technologies, the present invention aims to solve the above two problems, achieve the effects of saving manpower and time, and reducing the risk of matching errors, and provide a precise part number matching method based on resistance value grading.

[0006] To achieve the aforementioned objective, the technical solution adopted by this invention includes: a precise part number matching method based on resistance value grading, comprising: A fuzzy part number matching table was created using Excel software, including supplier name, supplier part number, supplier series number, product name, size, resistance range, power, TCR, maximum operating voltage, anti-sulfurization performance, anti-ESD performance, and remarks. A character code rule resistance value library was established using Excel software, storing the standard resistance values ​​and their corresponding codes under different resistance value grades. The user interface prompts the user to input the required resistance range via an InputBox; Specifically, it includes the following steps: A1. Initialize and prepare, obtain user selections, and clear the output area; A2. Determine the default resistance value classification standard. Based on the value of a column in the selected row, automatically determine a recommended classification standard. A3. Obtain user instructions; A4. Match and filter resistance values, locate the data source - loop through - filter by range; A5. Generate and fill in the part number information: For each qualified resistance value that passes the screening, perform the following operations to generate a complete material record: A5.1 Copy Basic Information: Copy the basic attributes of the original part number from the row selected by the user to the result table; A5.2 Generate new, precise part numbers by concatenating strings; A5.3. Enter the standard resistance value: Enter the selected standard resistance value and its corresponding code into the result table.

[0007] This invention, based on the powerful database function of Excel software, summarizes and classifies the product performance and models of mainstream manufacturers on the market. It allows searching by the main performance indicators of resistors as keywords, or by searching by the model number of a certain manufacturer, to obtain the corresponding model numbers of other manufacturers' products.

[0008] Further, in step A1, the user's selection is obtained, and it is determined which row the user has currently selected in the table. Clear the output area: Clear the contents of cells A2 to P10000 in Sheet4, which is used to store the generated results, to prepare for the entry of new data.

[0009] Furthermore, in step A2, including the precision = 0.05, it is recommended to use one of the series. For accuracy ≤ 0.01, it is recommended to use one or more combinations of these series. For other accuracy requirements, it is recommended to use one of the series.

[0010] Furthermore, step A3 includes: A3.1 Display an input box prompting the user to select the resistance range rules. A3.2. Users can choose to use the default value directly or enter it manually. A3.3 Input validation: If the user inputs the correct information, the program continues to execute. If the user inputs unrecognizable content, an error message will pop up and the program will terminate immediately.

[0011] Further, step A4 includes: A4.1 Locating the data source: Based on the user-selected categories, determine the corresponding data columns in the reference table. A4.2 Loop Traversal: Starting from the second row of the corresponding data column, read the standard resistance values ​​from the specified grade column row by row. A4.3 Range Filtering: Check whether each standard resistance value is within the range of the minimum and maximum resistance values ​​specified by the user in the selected row. If the resistance value is within the range: Proceed to the next step of part number generation. If the resistance value is not within the range: skip the resistance value and check the next one.

[0012] Furthermore, step A5.2 includes: A part number, taking a certain series of part numbers as an example: take the first 12 digits of the part number + the standard resistance code + the last digit of the part number; Company B's part number: Take the first 7 digits of the part number + another code for the standard resistance value + the last 5 digits of the part number.

[0013] Furthermore, step A6 is included, which involves checking the next resistance value in Sheet5, repeating steps four and five until all standard resistance values ​​have been processed and all eligible resistance values ​​have generated corresponding part numbers, at which point the process ends.

[0014] Compared with the prior art, the advantages of the present invention include: (1) The present invention provides a precise part number matching method based on resistance value grading, which ensures that the generated part number conforms to the established standard resistance value series and that the specification information is accurate.

[0015] (2) The present invention provides a precise part number matching method based on resistance value grading, which saves manpower and time, improves work efficiency, and reduces the risk of matching errors. Users only need to select the required resistance value grading, and the system automatically completes the subsequent data processing and generation work.

[0016] (3) The present invention provides a precise part number matching method based on resistance value grading. Each row in the precise part number matching table contains important data such as detailed supplier information, standard resistance value and its corresponding code. The error handling mechanism ensures the stability and reliability of the system. Attached Figure Description

[0017] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0018] Figure 1 This is a flowchart illustrating a precise part number matching method based on resistance value grading in this invention. Detailed Implementation

[0019] In view of the shortcomings of the prior art, the inventors of this invention, through long-term research and extensive practice, have proposed the technical solution of this invention. The technical solution, its implementation process, and principles will be further explained below with reference to the accompanying drawings and specific implementation examples in the embodiments of this application.

[0020] It should be noted that the embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and should not be construed as limiting the present invention. The described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, the present invention covers any substitutions, modifications, equivalent methods and solutions made on the spirit, principles and scope of the present invention as defined by the claims. All other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0021] In the description of this application, the terms "first," "second," "third," and similar words do not indicate any order, quantity, or importance, but are merely used to distinguish different components. Similarly, the terms "a" or "one," and similar words, do not indicate a quantity limitation, but rather indicate the presence of at least one. The terms "comprising" or "including," and similar words, mean that the elements or objects preceding "comprising" or "including" encompass the elements or objects listed following "comprising" or "including," and their equivalents, but do not exclude other elements or objects. The terms "connected" or "linked," and similar words, are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect.

[0022] In the description of this application, the terms "center," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used solely for the convenience of describing this application and for simplification, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application. Furthermore, when using positional terms such as "both sides," "outer side," and "upper and lower," it should be understood that they are used only for ease of understanding and description, taking into account that the structure may be oriented to other positions.

[0023] In the description of this application, unless otherwise expressly specified and limited, the technical or scientific terms used shall have the ordinary meaning understood by a person with ordinary skills in the art to which this application pertains. Terms such as “installation,” “connection,” and “joining” shall be interpreted broadly, for example, as fixed connection, detachable connection, mating connection, or integral connection. For a person skilled in the art, the specific meaning of the above terms in this application can be understood according to the specific circumstances.

[0024] The present invention aims to introduce and explain the structural composition of a precise part number matching method based on resistance value grading and the cooperation relationship between the various components. Unless otherwise specified, the dimensions, materials and manufacturing processes of each component in the precise part number matching method based on resistance value grading in the present invention can be selected according to specific circumstances, and no special limitations or explanations are made here.

[0025] Furthermore, to provide the public with a better understanding of the present invention, certain specific details are described in detail in the following description of the invention. However, those skilled in the art will fully understand the invention even without these detailed descriptions.

[0026] Example 1 Please see Figure 1 A precise part number matching method based on resistance value grading includes: A fuzzy part number matching table was created using Excel software, including supplier name (Chinese and English), supplier part number, supplier serial number, product name, size, resistance range, power, TCR, maximum operating voltage, anti-sulfurization performance, anti-ESD performance, and remarks. A character code rule resistance value library was established based on Excel software, storing the standard resistance values ​​and their corresponding codes under different resistance value grades (E24 / E96 / E12); The user interface prompts the user to enter the required resistance range via an InputBox, and default options are also supported.

[0027] Specifically, it includes the following steps: A1. Initialization Preparation: A1.1 Obtain user selection and determine which row the user has currently selected in the table. A1.2 Clear the output area: Clear the contents of all cells from A2 to P10000 in Sheet4, which is used to store the generated results, in preparation for filling in new data; The user selects a raw material line (from Sheet1) that represents a "fuzzy requirement". This raw material may only define the resistance range (e.g., 1KΩ-10KΩ), accuracy, package, power, etc., but not the specific resistance value.

[0028] A2. Determine the default resistance value classification standard: Based on the value in the 10th column of the selected row (usually representing precision or tolerance), automatically determine a recommended grading standard: If the precision is 0.05, the E24 series is recommended by default. If the precision is ≤ 0.01, the E24+E96 series (which is more precise) is recommended by default. For other accuracy requirements → E12 series is recommended by default. Macros associate fuzzy requirements with a defined standard (E series) based on precision rules.

[0029] A3. Obtain user instructions: A3.1 Display an input box prompting the user to select the resistance range rules. A3.2 Users can choose to use the default value directly or manually enter: E12, E24, or E96. A3.3 Input validation: If the user inputs correctly, the program continues to execute; if the user inputs unrecognizable content, an error message will pop up and the macro will terminate immediately. In the standard resistance value library (Sheet5), the macro iterates through all the standard resistance values ​​of the selected E series (such as 1.0, 1.1, 1.2, ..., 8.2 under the E24 series), performs conditional judgment on each standard resistance value, and checks whether it falls within the resistance value range defined by the original material.

[0030] A4. Match and filter resistance values A4.1 Locating the data source: Based on the user-selected data categories, determine the corresponding data columns in the reference table Sheet5. A4.2 Loop Traversal: Starting from line 2 of Sheet5, read the standard resistance values ​​from the specified column line by line. A4.3 Range Filtering: Checks whether each standard resistance value falls within the range of the minimum resistance value (column 8) and the maximum resistance value (column 9) specified by the user in the selected row. If the resistance value is within the range: proceed to the next step of part number generation. If the resistance value is not within the range: skip this resistance value and check the next one; A5. Generate and fill in the part number information: For each qualified resistance value that passes the screening, perform the following operations to generate a complete material record: A5.1 Copy basic information: Copy the basic attributes of the original part number (such as brand, description, package, power, etc.) from the row selected by the user to the result sheet Sheet4; A5.2 This is the most crucial step: generating a new, precise part number through string concatenation. For example, the part number of Company A is the part number of a certain series: take the first 12 digits of the part number + the standard resistance code + the last digit of the part number; B part number / B company part number: Take the first 7 digits of the part number + another code for the standard resistance value + the last 5 digits of the part number; For each "qualified" standard resistance value that passes the screening, the macro begins to perform a string concatenation operation.

[0031] It extracts fixed parts (representing brand, type, power, package, etc.) from the original part number.

[0032] Replace the part representing the variable resistance value with the corresponding standard code taken from the standard resistance value library.

[0033] Ultimately, this is combined into a new, complete, and precise part number.

[0034] Fill: The newly generated part number and all its related attributes (resistance, code, precision, description, etc.) are systematically filled into the output table (Sheet4) as a new record.

[0035] Step A6: Continue checking the next resistance value in Sheet5. Repeat steps four and five until all standard resistance values ​​have been processed and all matching resistance values ​​have generated their corresponding part numbers. End the process.

[0036] Working principle: Data processing logic: 1) Determine the corresponding column index based on the resistance value selected by the user.

[0037] 2) Traverse the character code rule resistance value library and find the standard resistance value that matches the resistance value range in the fuzzy part number matching table.

[0038] 3) Write the matched standard resistance value and related information into the resistor product database.

[0039] 4) Error handling mechanism: When the user input is invalid, an error message is displayed and the program execution is terminated.

[0040] For example, the product of this invention is an automated "fill-in-the-blank" expert: it receives a fuzzy range requirement, then finds all the answers that meet the requirements from a standard answer library (E series), and finally fills them in batches onto an application form according to a fixed format (part number coding rules). The historical record is this completed, traceable, and usable application form.

[0041] It should be understood that the above embodiments are only for illustrating the technical concept and features of the present invention, and are intended to enable those skilled in the art to understand the content of the present invention and implement it accordingly. It should not be considered that the specific implementation of the present invention is limited to these descriptions. For those skilled in the art, several simple deductions or substitutions can be made without departing from the concept of the present invention. All equivalent changes or modifications made in accordance with the spirit and essence of the present invention should be covered within the protection scope of the present invention.

Claims

1. A precise part number matching method based on resistance value grading, characterized in that: include: Fuzzy part number matching table, including supplier name, supplier part number, supplier series number, product name, size, resistance range, power, TCR, maximum operating voltage, anti-sulfurization performance, anti-ESD performance, and remarks; The character code rule resistance value library stores the standard resistance values ​​and their corresponding codes under different resistance value categories; The user interface prompts the user to input the required resistance range via an InputBox; Specifically, it includes the following steps: A1. Initialize and prepare, obtain user selections, and clear the output area; A2. Determine the default resistance value classification standard. Based on the value of a column in the selected row, automatically determine a recommended classification standard. A3. Obtain user instructions; A4. Match and filter resistance values, locate the data source - loop through - filter by range; A5. Generate and fill in the part number information: For each qualified resistance value that passes the screening, perform the following operations to generate a complete material record: A5.1 Copy Basic Information: Copy the basic attributes of the original part number from the row selected by the user to the result table; A5.2 Generate new, precise part numbers by concatenating strings; A5.

3. Enter the standard resistance value: Enter the selected standard resistance value and its corresponding code into the result table.

2. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: In step A1, the user's selection is obtained, and it is determined which row the user has currently selected in the table. Clear the output area: Clear the contents of cells A2 to P10000 in Sheet4, which is used to store the generated results, to prepare for the entry of new data.

3. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: In step A2, including the precision of 0.05, it is recommended to use one of the series. For accuracy ≤ 0.01, it is recommended to use one or more combinations of these series. For other accuracy requirements, it is recommended to use one of the series.

4. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: Step A3 includes: A3.1 Display an input box prompting the user to select the resistance range rules. A3.

2. Users can choose to use the default value directly or enter it manually. A3.3 Input validation: If the user inputs the correct information, the program continues to execute. If the user inputs unrecognizable content, an error message will pop up and the program will terminate immediately.

5. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: Step A4 includes: A4.1 Locating the data source: Based on the user-selected categories, determine the corresponding data columns in the reference table. A4.2 Loop Traversal: Starting from the second row of the corresponding data column, read the standard resistance values ​​from the specified grade column row by row. A4.3 Range Filtering: Check whether each standard resistance value is within the range of the minimum and maximum resistance values ​​specified by the user in the selected row. If the resistance value is within the range: Proceed to the next step of part number generation. If the resistance value is not within the range: skip the resistance value and check the next one.

6. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: Step A5.2 includes: A part number: take the first 12 digits of the part number + the standard resistance code + the last digit of the part number; B part number: Take the first 7 digits of the part number + another code for the standard resistance value + the last 5 digits of the part number.

7. The precise part number matching method based on resistance value grading according to claim 1, characterized in that: It also includes step A6, which continues to check the next resistance value in Sheet5. Steps four and five are repeated until all standard resistance values ​​have been processed and all resistance values ​​that meet the conditions have generated corresponding part numbers, at which point the process ends.

Images