CN109063006A - A kind of method that Excel realizes the calculating of vehicle software configuration coding and parsing - Google Patents
A kind of method that Excel realizes the calculating of vehicle software configuration coding and parsing Download PDFInfo
- Publication number
- CN109063006A CN109063006A CN201810749882.XA CN201810749882A CN109063006A CN 109063006 A CN109063006 A CN 109063006A CN 201810749882 A CN201810749882 A CN 201810749882A CN 109063006 A CN109063006 A CN 109063006A
- Authority
- CN
- China
- Prior art keywords
- software configuration
- code
- vehicle
- excel
- function
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 21
- 238000006243 chemical reaction Methods 0.000 claims abstract description 4
- 230000006870 function Effects 0.000 claims description 36
- 239000000284 extract Substances 0.000 claims description 6
- 239000000446 fuel Substances 0.000 claims description 5
- 229910002056 binary alloy Inorganic materials 0.000 claims description 3
- 238000012937 correction Methods 0.000 claims description 3
- 239000011521 glass Substances 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 claims description 3
- 208000035139 partial with pericentral spikes epilepsy Diseases 0.000 claims description 3
- 238000002485 combustion reaction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/126—Character encoding
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Combined Controls Of Internal Combustion Engines (AREA)
- Stored Programmes (AREA)
Abstract
The present invention relates to a kind of method and devices that vehicle software configuration coding is realized based on Excel, establish the basic database of vehicle software configuration coding;When calculation code, soft software config option is inputted in Excel table;Using the line number of the binary code in each software configuration option matching basic database that MATCH function is input, using BIN2HEX function, by matched binary code by byte conversion at heuristicimal code;Using CONCATENATE function, the heuristicimal code of acquisition is merged according to byte order becomes vehicle code, and is shown.When reverse resolution encodes, vehicle code is inputted in input frame;Using MID function, the heuristicimal code of each byte of vehicle code is extracted;Using HEX2BIN function, binary digit code is converted by the heuristicimal code of each byte of vehicle code;Using MID function, the binary digit code of each software configuration variable is extracted;Using MATCH function, the line number of the corresponding software configuration option of binary digit code in basic database is searched, and is shown.
Description
Technical field
The present invention relates to a kind of method and devices that vehicle software configuration coding is realized based on Excel.
Background technique
With the rapid development of automotive engineering, the function of vehicle and configuration are more and more abundant.For adapt to each version type of vehicle it
Between function and configuration variance, most of controller does software configuration on vehicle.Controller software configuration can optimize and reduce
Controller software version is conducive to software release upgrade and updates and manage.Part No. can be reduced conducive to inventory and exemplar management.
Each config option of each software configuration variable of each controller is pressed binary system first by main engine plants' R & D design stage
The coding of coding, all configuration variables is eventually converted into hexadecimal storage, transmitting by bitmap.It changes in offline general assembly or after sale
When part, then be written in each controller by equipment.Controller software is initialized according to software configuration code, embodies different function and configuration
Difference.
It is disadvantageous in that existing for existing vehicle software configuration coding method, main engine plants' research and development test and manual entrucking are tested
The card stage need to calculate repeatedly and analysis software configuration code, and existing encoding tool (the automatic calculating instrument of such as webpage) all only has just
To encoding function, there is no reverse resolution function, cause to check software configuration code issue low efficiency, checks the new code of old code production and ask
It is difficult when topic.
Summary of the invention
It is an object of that present invention to provide a kind of method and devices that vehicle software configuration coding is realized based on Excel, can
Effectively improve the working efficiency of vehicle software configuration coding.
Based on the same inventive concept, there are two independent technical solutions for present invention tool:
1, a kind of method that vehicle software configuration coding is realized based on Excel, which is characterized in that the meter of vehicle software configuration coding
Include the following steps:
Step 1: establishing the basic database of vehicle software configuration coding;Basic database includes multiple software configuration variables, often
A software configuration variable is correspondingly provided with software configuration option, each software configuration option is correspondingly provided with binary code and binary system is compiled
The value of code;
Step 2: Excel table being established based on Excel software, Input Software configuration variables and its corresponding soft in Excel table
Part config option;
Step 3: utilize MATCH function, each software configuration option to input in step 2 match in basic database two into
The line number of code processed, then the value of the corresponding binary code of ranks positioning return by INDEX function;
Step 4: BIN2HEX function is utilized, by binary code matched in step 3 by byte conversion at heuristicimal code;
Step 5: utilizing CONCATENATE function, the heuristicimal code obtained in step 4 is become according to byte order merging
Vehicle code is shown on mobile phone or computer apparatus.
Further, the parsing of vehicle software configuration coding includes the following steps:
Input frame is created in step 6:Excel table, and vehicle code is inputted in input frame;
Step 7: utilizing MID function, extract the heuristicimal code of each byte of vehicle code;
Step 8: utilizing HEX2BIN function, convert binary digit code for the heuristicimal code of each byte of vehicle code;It utilizes
MID function extracts the binary digit code of each software configuration variable;
Step 9: utilizing MATCH function, the binary digit code for searching each software configuration variable in basic database is corresponding soft
The line number of part config option recycles the positioning of INDEX function ranks to return to the value of software configuration option, in mobile phone or computer apparatus
Upper display.
Further, in step 2, the software configuration option in basic database is arranged and is inputted under combo box as user
Draw sequence data source.
Further, it when the calculating of vehicle software configuration coding, by changing Input Software config option, generates new whole
Vehicle code, and shown.
Further, the cell attribute of Excel table is set, cell is protected and is hidden, can only inputted
Cell Input Software configuration variables and its corresponding software configuration option.
Further, headed by vehicle software configuration variable protect, maintenance shop every, Fuel consumption correction coefficient, reversing radar alarm, combustion
Material type, LDW, language, overspeed alarming, radio reception region, reverse image or driver side glass rise automatically.
Further, vehicle software configuration variable be EMS, BCM, ICM, ABM, ABS, ESP, IMMO, TCU,
CLM, EPS, PEPS, IHU, TBOX, APM, TPMS or SAM.
2, the device of the above method is realized, it is characterised in that: device is mobile phone or computer, is equipped on mobile phone or computer
Excel program.
The invention has the benefit that
The present invention uses mobile phone or computer hardware device, installs excel tool (program) and establishes vehicle software configuration coding
Basic database;Excel table is established based on Excel tool, Input Software configuration variables and its corresponding soft in Excel table
Part config option;Using MATCH function, the row of the binary code in each software configuration option matching basic database of input
Number, then the value of the corresponding binary code of ranks positioning return by INDEX function;Using BIN2HEX function, by matched two
Ary codes are by byte conversion at heuristicimal code;Using CONCATENATE function, the heuristicimal code of acquisition is suitable according to byte
Sequence, which merges, becomes vehicle code, and is shown.The present invention sufficiently uses mobile phone or computer hardware device, utilizes Excel tool
Functional based method calculates vehicle Software Coding, effectively increases the working efficiency of vehicle software configuration coding.
The present invention can carry out the reverse resolution of vehicle software configuration coding, input frame be created in Excel table, in input frame
Middle input vehicle code;Using MID function, the heuristicimal code of each byte of vehicle code is extracted;It, will using HEX2BIN function
The heuristicimal code of each byte of vehicle code is converted into binary digit code;Using MID function, by the two of each software configuration variable
System position code extracts;Using MATCH function, the binary digit code for searching each software configuration variable in basic database is right
The line number for the software configuration option answered recycles the positioning of INDEX function ranks to return to the value of software configuration option, and is shown
Show.The present invention sufficiently uses mobile phone or computer hardware device, can be to vehicle Software Coding using the functional based method of Excel tool
Reverse resolution is carried out, solves the problems, such as that existing method cannot carry out reverse resolution to vehicle Software Coding, configuration volume can be carried out
The verification of code, and then further increase the working efficiency of vehicle software configuration coding.
Software configuration option in basic database is arranged the drop-down sequence data that combo box is inputted as user by the present invention
Source facilitates input to operate.When the calculating of vehicle software configuration of the present invention coding, can by changing Input Software config option,
New vehicle code is generated, and is shown, new code, the use of more convenient user, into one can be generated on the basis of old code
Step improves the working efficiency of vehicle software configuration coding.The cell of the Excel table of mobile phone or computer apparatus is arranged in the present invention
Attribute is protected cell and is hidden, and can only match in input unit lattice Input Software configuration variables and its corresponding software
Option is set, remaining element lattice can not operate, and only show main data frame, the use of more convenient user.
Detailed description of the invention
Fig. 1 is method flow block diagram of the invention.
Specific embodiment
As shown in Figure 1, the calculating of vehicle software configuration coding includes the following steps:
Step 1: using mobile phone or computer hardware device, excel tool is installed and establishes the basic number of vehicle software configuration coding
According to library;Basic database includes multiple software configuration variables, and each software configuration variable is correspondingly provided with software configuration option, each
Software configuration option is correspondingly provided with binary code and binary-coded value.
Protected headed by vehicle software configuration variable, maintenance shop every, Fuel consumption correction coefficient, reversing radar alarm, fuel type,
LDW, language, overspeed alarming, radio reception region, reverse image or driver side glass rise automatically.Vehicle software configuration variable is
EMS、 BCM 、ICM 、ABM、 ABS、 ESP、 IMMO、 TCU 、CLM 、EPS、 PEPS 、IHU 、TBOX 、APM、 TPMS
Or SAM.
It is as shown in the table:
Step 2: Excel table being established based on Excel software tool, Input Software configuration variables and its correspondence in Excel table
Software configuration option.
When implementation, the software configuration option in basic database is arranged to the drop-down sequence data that combo box is inputted as user
Source, i.e., in " EXCEL- data-data validity-sequence-source ", by " the software configuration choosing of each software configuration variable
" it is used as data source, user is that each configuration variables select corresponding software configuration option to input by drop-down combo box.
Step 3: utilizing MATCH (lookup_value, lookup_array, match_type) function, be in step 2
Input each software configuration option matching basic database in binary code line number, then by INDEX (array,
Row_num, column_num) the ranks positioning of function returns to the value of corresponding binary code.
Step 4: utilizing BIN2HEX (number, places) function, binary code matched in step 3 is turned by byte
Change heuristicimal code into.
When implementation, the binary code of each software configuration variable matched in step 3 is arranged by bitmap, is utilized
BIN2HEX (number, places) function, is converted into heuristicimal code by byte.Bitmap table is as follows:
Step 5: using CONCATENATE (text1, text2 ...) function, by the heuristicimal code obtained in step 4 according to
Byte order, which merges, becomes vehicle code (calculating output code), and is shown.
Shown in step 2 to step 5 table specific as follows:
The parsing of vehicle software configuration coding includes the following steps:
Input frame is created in step 6:Excel table, and vehicle code (parsing input code) is inputted in input frame;
Step 7: utilize MID (text, start_num, num_chars) function, extract the 16 of each byte of vehicle code into
Code processed;
Step 8: utilizing HEX2BIN (number, places) function, convert two for the heuristicimal code of each byte of vehicle code
System position code;
Using MID (text, start_num, num_chars) function, the binary digit code of each software configuration variable is extracted
Out;
Step 9: utilizing MATCH (lookup_value, lookup_array, match_type) function, search basic database
In each software configuration variable the corresponding software configuration option of binary digit code line number, recycle INDEX (array, row_
Num, column_num) positioning of function ranks returns to the value of software configuration option, and is shown.
Shown in step 6 to step 9 table specific as follows:
When the calculating of vehicle software configuration coding, it can generate new vehicle code by changing Input Software config option and (calculate defeated
Code out), and shown.
The cell attribute of Excel table is set, cell is protected and is hidden, can only be inputted in input unit lattice
Software configuration variable and its corresponding software configuration option, remaining element lattice can not operate, and only show main data
Frame, the use of more convenient user.It is as shown in the table:
Claims (8)
1. a kind of method for realizing vehicle software configuration coding based on Excel, which is characterized in that the meter of vehicle software configuration coding
Include the following steps:
Step 1: establishing the basic database of vehicle software configuration coding;Basic database includes multiple software configuration variables, often
A software configuration variable is correspondingly provided with software configuration option, each software configuration option is correspondingly provided with binary code and binary system is compiled
The value of code;
Step 2: Excel table being established based on Excel software, Input Software configuration variables and its corresponding soft in Excel table
Part config option;
Step 3: utilize MATCH function, each software configuration option to input in step 2 match in basic database two into
The line number of code processed, then the value of the corresponding binary code of ranks positioning return by INDEX function;
Step 4: BIN2HEX function is utilized, by binary code matched in step 3 by byte conversion at heuristicimal code;
Step 5: utilizing CONCATENATE function, the heuristicimal code obtained in step 4 is become according to byte order merging
Vehicle code is shown on mobile phone or computer apparatus.
2. the method according to claim 1 for realizing vehicle software configuration coding based on Excel, which is characterized in that vehicle
The parsing of software configuration coding includes the following steps:
Input frame is created in step 6:Excel table, and vehicle code is inputted in input frame;
Step 7: utilizing MID function, extract the heuristicimal code of each byte of vehicle code;
Step 8: utilizing HEX2BIN function, convert binary digit code for the heuristicimal code of each byte of vehicle code;It utilizes
MID function extracts the binary digit code of each software configuration variable;
Step 9: utilizing MATCH function, the binary digit code for searching each software configuration variable in basic database is corresponding soft
The line number of part config option recycles the positioning of INDEX function ranks to return to the value of software configuration option, and is shown.
3. the method according to claim 2 for realizing vehicle software configuration coding based on Excel, it is characterised in that: step 2
In, the software configuration option in basic database is arranged to the drop-down sequence data source that combo box is inputted as user.
4. the method according to claim 3 for realizing vehicle software configuration coding based on Excel, it is characterised in that: vehicle
When the calculating of software configuration coding, by changing Input Software config option, new vehicle code is generated, in mobile phone or computer apparatus
Upper display.
5. the method according to claim 4 for realizing vehicle software configuration coding based on Excel, it is characterised in that: setting
The cell attribute of Excel table, protects cell and is hidden, can only be in input unit lattice Input Software configuration variables
And its corresponding software configuration option.
6. the method according to claim 5 for realizing vehicle software configuration coding based on Excel, it is characterised in that: vehicle
Headed by software configuration variable protect, maintenance shop every, the alarm of Fuel consumption correction coefficient, reversing radar, fuel type, LDW, language, hypervelocity
Alarm, radio reception region, reverse image or driver side glass rise automatically.
7. the method according to claim 6 for realizing vehicle software configuration coding based on Excel, it is characterised in that: vehicle
Software configuration variable be EMS, BCM, ICM, ABM, ABS, ESP, IMMO, TCU, CLM, EPS, PEPS, IHU,
TBOX, APM, TPMS or SAM.
8. realizing the device of claim 1 to 7 any one method, it is characterised in that: device is mobile phone or computer, in mobile phone or
Excel program is installed on computer.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810749882.XA CN109063006B (en) | 2018-07-10 | 2018-07-10 | Method for calculating and analyzing configuration code of whole vehicle software by Excel |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810749882.XA CN109063006B (en) | 2018-07-10 | 2018-07-10 | Method for calculating and analyzing configuration code of whole vehicle software by Excel |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109063006A true CN109063006A (en) | 2018-12-21 |
CN109063006B CN109063006B (en) | 2021-12-28 |
Family
ID=64819341
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810749882.XA Active CN109063006B (en) | 2018-07-10 | 2018-07-10 | Method for calculating and analyzing configuration code of whole vehicle software by Excel |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109063006B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109871391A (en) * | 2019-01-09 | 2019-06-11 | 东莞联宝光电科技有限公司 | Utilize the method for Excel software retrospect packaging products in boxes |
CN110598187A (en) * | 2019-08-06 | 2019-12-20 | 中国华冶科工集团有限公司 | Batch manufacturing method of cable nameplates |
WO2023206999A1 (en) * | 2022-04-26 | 2023-11-02 | 一汽奔腾轿车有限公司 | Method, apparatus, device and storage medium for automatically generating eol configuration code of control unit |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
CN102262404A (en) * | 2011-04-11 | 2011-11-30 | 浙江吉利汽车研究院有限公司 | End-of-line configuration system and configuration method for finished vehicle |
CN102447575A (en) * | 2011-10-08 | 2012-05-09 | 烽火通信科技股份有限公司 | Method for analyzing and managing log file with hexadecimal data |
CN102622470A (en) * | 2012-02-21 | 2012-08-01 | 重庆邮电大学 | General car code conversion method |
CN103617045A (en) * | 2013-12-12 | 2014-03-05 | 用友软件股份有限公司 | Plug-in development system and method based on user-defined Excel function |
CN103885926A (en) * | 2014-01-19 | 2014-06-25 | 涂志芳 | Method for scheduling program of sports meeting by Excel functions |
US20160321231A1 (en) * | 2015-04-30 | 2016-11-03 | Claudia Lehmann | Computer Implemented Systems and Methods for Automatic Generation of Data Transformations |
CN106650059A (en) * | 2016-12-08 | 2017-05-10 | 南京越博动力系统股份有限公司 | Matlab-based vehicle performance simulation and calculation method for automobile |
CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
-
2018
- 2018-07-10 CN CN201810749882.XA patent/CN109063006B/en active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
CN102262404A (en) * | 2011-04-11 | 2011-11-30 | 浙江吉利汽车研究院有限公司 | End-of-line configuration system and configuration method for finished vehicle |
CN102447575A (en) * | 2011-10-08 | 2012-05-09 | 烽火通信科技股份有限公司 | Method for analyzing and managing log file with hexadecimal data |
CN102622470A (en) * | 2012-02-21 | 2012-08-01 | 重庆邮电大学 | General car code conversion method |
CN103617045A (en) * | 2013-12-12 | 2014-03-05 | 用友软件股份有限公司 | Plug-in development system and method based on user-defined Excel function |
CN103885926A (en) * | 2014-01-19 | 2014-06-25 | 涂志芳 | Method for scheduling program of sports meeting by Excel functions |
US20160321231A1 (en) * | 2015-04-30 | 2016-11-03 | Claudia Lehmann | Computer Implemented Systems and Methods for Automatic Generation of Data Transformations |
CN106650059A (en) * | 2016-12-08 | 2017-05-10 | 南京越博动力系统股份有限公司 | Matlab-based vehicle performance simulation and calculation method for automobile |
CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
Non-Patent Citations (1)
Title |
---|
王顺金: "会计人员应掌握的Excel函数", 《财会月刊》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109871391A (en) * | 2019-01-09 | 2019-06-11 | 东莞联宝光电科技有限公司 | Utilize the method for Excel software retrospect packaging products in boxes |
CN109871391B (en) * | 2019-01-09 | 2021-04-09 | 东莞联宝光电科技有限公司 | Method for tracing product boxing by using Excel software |
CN110598187A (en) * | 2019-08-06 | 2019-12-20 | 中国华冶科工集团有限公司 | Batch manufacturing method of cable nameplates |
WO2023206999A1 (en) * | 2022-04-26 | 2023-11-02 | 一汽奔腾轿车有限公司 | Method, apparatus, device and storage medium for automatically generating eol configuration code of control unit |
Also Published As
Publication number | Publication date |
---|---|
CN109063006B (en) | 2021-12-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110704588A (en) | Multi-round dialogue semantic analysis method and system based on long-term and short-term memory network | |
CN109063006A (en) | A kind of method that Excel realizes the calculating of vehicle software configuration coding and parsing | |
CN111177184A (en) | Structured query language conversion method based on natural language and related equipment thereof | |
CN104899304A (en) | Named entity identification method and device | |
CN109446221A (en) | A kind of interactive data method for surveying based on semantic analysis | |
CN104699667A (en) | Semantic dictionary-based improved word similarity calculating method and device | |
EP3474142A1 (en) | System and method for cognitive troubleshooting assistance | |
CN110866115A (en) | Sequence labeling method, system, computer equipment and computer readable storage medium | |
CN107016019A (en) | Database index creation method and device | |
CN112035645A (en) | Data query method and system | |
CN103902770A (en) | Method for quickly analyzing universal reliability indicators of printed circuit board | |
CN109670148A (en) | Collection householder method, device, equipment and storage medium based on speech recognition | |
CN112836061A (en) | Intelligent recommendation method and device and computer equipment | |
CN114492470A (en) | Commodity title text translation method and device, equipment, medium and product thereof | |
CN113868252A (en) | Database mode matching method and device and SQL query statement generation method | |
CN104361040A (en) | Method and device for customized query | |
CN113837669B (en) | Evaluation index construction method of label system and related device | |
CN101930362B (en) | Method for integrating TTCN language and data description language | |
CN107368500B (en) | Data extraction method and system | |
CN113687825B (en) | Method, device, equipment and storage medium for constructing software module | |
CN112000692B (en) | Page query feedback method and device, computer equipment and readable storage medium | |
CN112446405A (en) | User intention guiding method for home appliance customer service and intelligent home appliance | |
CN113326701A (en) | Nested entity recognition method and device, computer equipment and storage medium | |
CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
CN111126056A (en) | Method and device for identifying trigger words |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |