Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method of excel to realize the calculation and analysis of vehicle software configuration code

A software configuration, excel technology, applied in computing, instruments, word processing, etc., can solve problems such as difficulty in troubleshooting old codes to produce new codes, no reverse analysis function, and low efficiency in troubleshooting software configuration code problems, so as to improve work efficiency. The effect of efficiency

Active Publication Date: 2021-12-28
CHERY AUTOMOBILE CO LTD
View PDF9 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The disadvantage of the existing vehicle software configuration coding method is that the software configuration code needs to be repeatedly calculated and analyzed during the R&D testing and manual loading verification stages of the main engine factory, and the existing coding tools (such as automatic calculation tools for web pages) only have correct Direct coding function, no reverse analysis function, resulting in low efficiency in troubleshooting software configuration code problems, and difficulty in troubleshooting old codes to produce new codes

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method of excel to realize the calculation and analysis of vehicle software configuration code
  • A method of excel to realize the calculation and analysis of vehicle software configuration code
  • A method of excel to realize the calculation and analysis of vehicle software configuration code

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Such as figure 1 As shown, the calculation of the vehicle software configuration code includes the following steps:

[0030] Step 1: Using a mobile phone or computer hardware device, install the excel tool and establish a basic database of vehicle software configuration codes; the basic database includes multiple software configuration variables, each software configuration variable corresponds to a software configuration option, each software configuration option Correspondence has a binary code and a binary coded value.

[0031] Vehicle software configuration variables are first maintenance, maintenance interval, fuel consumption correction factor, reversing radar alarm, fuel type, LDW, language, speeding alarm, radio area, reversing image or driver’s side glass automatically rises. The vehicle software configuration variables are EMS, BCM, ICM, ABM, ABS, ESP, IMMO, TCU, CLM, EPS, PEPS, IHU, TBOX, APM, TPMS or SAM.

[0032] As shown in the table below:

[0033] ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method and device for realizing vehicle software configuration coding based on Excel, and establishes a basic database of vehicle software configuration coding; when calculating codes, input software configuration options in an Excel table; use the MATCH function as input for each software The configuration option matches the row number of the binary code in the basic database, and uses the BIN2HEX function to convert the matched binary code into a hexadecimal code byte by byte; use the CONCATENATE function to merge the obtained hexadecimal codes in byte order Become a vehicle code and display it. When reversely analyzing the code, enter the vehicle code in the input box; use the MID function to extract the hexadecimal code of each byte of the vehicle code; use the HEX2BIN function to extract the hexadecimal code of each byte of the vehicle code The base code is converted into a binary code; use the MID function to extract the binary code of each software configuration variable; use the MATCH function to find the line number of the software configuration option corresponding to the binary code in the basic database, and display it.

Description

technical field [0001] The invention relates to a method and a device for realizing the configuration coding of vehicle software based on Excel. Background technique [0002] With the rapid development of automobile technology, the functions and configurations of vehicles are becoming more and more abundant. In order to adapt to the differences in functions and configurations between different versions of the vehicle, most of the controllers on the vehicle are configured with software. The controller software configuration can optimize and reduce the controller software version, which is beneficial to software version upgrade and management. The ability to reduce part numbers facilitates inventory and sample management. [0003] In the R&D and design stage of the main engine factory, firstly, each configuration option of each software configuration variable of each controller is coded in binary, and the codes of all configuration variables are finally converted into hexade...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F40/126G06F40/157G06F40/18G06F16/2455G06F16/22G06F16/248
CPCG06F40/157G06F40/126
Inventor 卢珊王聪朱琴向辉刘孔祥李建才
Owner CHERY AUTOMOBILE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com