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 PDF

Info

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
Application number
CN201810749882.XA
Other languages
Chinese (zh)
Other versions
CN109063006B (en
Inventor
卢珊
王聪
朱琴
向辉
刘孔祥
李建才
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chery Automobile Co Ltd
Original Assignee
SAIC Chery Automobile Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SAIC Chery Automobile Co Ltd filed Critical SAIC Chery Automobile Co Ltd
Priority to CN201810749882.XA priority Critical patent/CN109063006B/en
Publication of CN109063006A publication Critical patent/CN109063006A/en
Application granted granted Critical
Publication of CN109063006B publication Critical patent/CN109063006B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/12Use of codes for handling textual entities
    • G06F40/151Transformation
    • G06F40/157Transformation using dictionaries or tables
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/12Use of codes for handling textual entities
    • G06F40/126Character 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

A kind of method that Excel realizes the calculating of vehicle software configuration coding and parsing
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.
CN201810749882.XA 2018-07-10 2018-07-10 Method for calculating and analyzing configuration code of whole vehicle software by Excel Active CN109063006B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (9)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
王顺金: "会计人员应掌握的Excel函数", 《财会月刊》 *

Cited By (4)

* Cited by examiner, † Cited by third party
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