# US 8,751,929 B2 · Machine-implemented data conversion method for a bill of materials > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 8,751,929 B2 - Document ID: US8751929B2 - Status: Granted - Kind: B2 - Application number: 12/051,277 - Filed: 2008-03-19 - Published: 2009-09-24 - Granted: 2014-06-10 - Earliest claimed: 2008-03-19 - Assignees: Universal Scientific Industrial (Shanghai) Co., Ltd.; Universal Global Scientific Industrial Co., Ltd. - Applicants: Meng-Ling Chang - Inventors: Meng-Ling Chang - Web page: https://patentgrep.com/patent/US8751929B2 ## CPC - G06Q 10/06: Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract A machine-implemented method for data conversion, which is adapted for converting a plurality of entries of component data in a bill of materials, includes the steps of: (a) reading the entries of the component data from the bill of materials; (b) acquiring a critical text set from each of the entries of the component data; (c) generating a converted component value and a converted component value range for the critical text set acquired from each of the entries of the component data; and (d) rearranging the entries of the component data in the bill of materials according to the converted component values, and displaying the rearranged entries of the component data together with the corresponding converted component values and the corresponding converted component value ranges. ## Claims ### Claim 1 A method for data conversion, said method being adapted for converting a plurality of entries of component data in a bill of materials, the method being performed by a computer machine according to computer program instructions to execute steps of: (a) reading the entries of the component data from the bill of materials; (b) acquiring a critical text set from each of the entries of the component data, wherein the critical text set includes a component value text and a tolerance text, by: (b-1) acquiring a candidate text set from each of the entries of the component data according to a predefined text-acquiring rule set; (b-2) determining whether the candidate text set acquired from each of the entries of the component data includes text that does not conform with a predefined text format rule set; and (b-3) deleting the text from the candidate text set acquired from each of the entries of the component data and not conforming with the predefined text format rule set so as to result in the critical text set for each of the entries of the component data; (c) generating a converted component value and a converted component value range for the critical text set acquired from each of the entries of the component data; and (d) rearranging the entries of the component data in the bill of materials according to the converted component values, and displaying the rearranged entries of the component data together with the corresponding converted component values and the corresponding converted component value ranges. ### Claim 2 (depends on 1) The method as claimed in claim 1, wherein the rearranged entries of the component data are further displayed in step (d) according to classifications of the entries of the component data. ### Claim 3 (depends on 1) The method as claimed in claim 1, wherein said machine-implemented method is realized using a machine that executes a macro software tool. ### Claim 4 (depends on 1) The method as claimed in claim 1, wherein said machine-implemented method is realized using a machine that executes a macro software tool in a spreadsheet application. ### Claim 5 (depends on 1) The method as claimed in claim 1, wherein each of the entries of the component data includes a component description field, and in sub-step (b-1), the candidate text set is acquired from a component description field of each of the entries of the component data. ### Claim 6 (depends on 1) The method as claimed in claim 1, wherein the converted component value is one of a capacitance value, a resistance value, and an inductance value. ### Claim 7 (depends on 1) The method as claimed in claim 1, wherein a unit field is generated for the converted component value in step (c). ### Claim 8 A non-transitory computer readable data storage medium comprising program instructions for causing a computer to perform consecutive steps of a machine-implemented method for data conversion, said machine-implemented method being adapted for converting a plurality of entries of component data in a bill of materials, and comprising the steps of: (a) reading the entries of the component data from the bill of materials; (b) acquiring a critical text set from each of the entries of the component data, wherein the critical text set includes a component value text and a tolerance text, by: (b-1) acquiring a candidate text set from each of the entries of the component data according to a predefined text-acquiring rule set; (b-2) determining whether the candidate text set acquired from each of the entries of the component data includes text that does not conform with a predefined text format rule set; and (b-3) deleting the text from the candidate text set acquired from each of the entries of the component data and not conforming with the predefined text format rule set so as to result in the critical text set for each of the entries of the component data; (c) generating a converted component value and a converted component value range for the critical text set acquired from each of the entries of the component data; and (d) rearranging the entries of the component data in the bill of materials according to the converted component values, and displaying the rearranged entries of the component data together with the corresponding converted component values and the corresponding converted component value ranges. ### Claim 9 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein, in step (d), the rearranged entries of the component data are further displayed according to classifications of the entries of the component data. ### Claim 10 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein said program instructions constitute a macro software tool. ### Claim 11 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein said program instructions constitute a macro software tool in a spreadsheet application. ### Claim 12 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein each of the entries of the component data includes a component description field, and in sub-step (b-1) of the machine-implemented method, the candidate text set is acquired from the component description field of each of the entries of the component data. ### Claim 13 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein the converted component value is one of a capacitance value, a resistance value, and an inductance value. ### Claim 14 (depends on 8) The non-transitory computer readable data storage medium as claimed in claim 8, wherein a unit field is generated for the converted component value in step (c).