Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

This release marks version 2.0, primarily adding support for the AutoSAR protocol stack.

Vehicle Technology released the free version of the excel2dbc tool three years ago.
The definition of free is: no authorization code required, no internet connection needed, freely copied and distributed, and no expiration date!
Three years later, it has finally been updated, with the new version released, upgrading from v1.0 to v2.0.

Wang Po Sells Melons

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Its v1.0 version is simple and practical, the format check report is very detailed, the excel is exquisite, and the dbc standard is high, making it undoubtedly the best excel2dbc tool in the Eastern Hemisphere.

We have considered almost all details to meet all requirements in network design and testing.
It is no exaggeration to say that any experienced network design engineer will praise our tool!
We have also written several articles to introduce such a tool:
Bus Lecture 10, the best excel2dbc conversion tool in the Eastern Hemisphere, always free to give
Bus Lecture 14, detailed video demonstration of the four major functions of excel2dbc
Bus Architecture Lecture 15, demonstrating the reliability of the excel2dbc tool from the details
Bus Architecture Lecture 17, significant breakthroughs in excel2dbc adaptive format templates
Excel2dbc tool is given away for free, not a penny required, no authorization needed, no internet connection needed
Colleagues who understand will surely know that the simpler a powerful and comprehensive tool appears to you, the more work the developers have done behind the scenes, and the more effort they have put in. This is an unbreakable truth.
Our excel2dbc tool is the same; it is as simple as a children’s book, completely unlike a professional technical tool.

Software Update

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

This update mainly aims to adapt to the widely used “configuration-based vehicle ECU basic software development” in the industry, with the most typical being the AutoSAR protocol stack.

1. Upgrade of Send Type Characters

In this update, we considered similar tools from companies like Hengrun and Dongxin Chuangzhi, making their Excel templates compatible, thereby enhancing its universality across the industry.

For example, the changes in the message send type from v2.0 compared to v1.0 are as follows:

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

The purpose of the changes is to align with the AutoSAR protocol stack.
2. New Attributes
Two new attributes for messages and three for signals have been added, which are:
Message:
CycleTimeFast(ms): Fast cycle time of the message. The original CycleTime(ms) defaults to slow cycle time. MsgNrOfRepetitions: Number of retransmissions.
Signal:
SigSendType: Signal send type InactiveValueHex: TimeoutTime:
The enumeration list for signal send types is as follows, consistent with the entire industry:
"Cyclic","OnWrite","OnWriteWithRepetition","OnChange","OnChangeWithRepetition","IfActive","IfActiveWithRepetition","NoSigSendType";
3. Cancellation of Custom Message Send Types
Version 1.0 supported user-defined message send types. Its default types are as follows:
"FixedPeriodic","Event","EnablePeriodic","NotUsed","NotUsed","EventPeriodic","NotUsed","NotUsed","NoMsgSendType";
You can also manually modify it to types like those in v2.0, or even make humanized definitions using Chinese characters, for example:
"周期型","事件型","使能周期型","未定义类型","未定义类型","事件周期型","未定义类型","未定义类型","无发送类型";
The method is to create a txt file in the same path as the exe and write these strings into it.
This is feasible, as its theoretical basis comes from the following article:
Bus Lecture 50, how to thoroughly understand the “send type” in dbc?
Given that the usage rate of this feature is extremely low and it is not conducive to industry standardization, version 2.0 no longer supports custom definitions, only supporting AutoSAR standard send type dropdown strings, referred to as “Upgrade of Send Type Characters” above.

Impact on Old Users

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Although the tool is free, it does not hinder our pursuit of excellence; the user experience of old users is a key consideration for us.

The Excel from v1.0 is certainly outdated, as some new attributes have been added. The original Excel cannot unleash the power of v2.0 software and can be discarded.

However, the old dbc can still be used; the dbc generated by v1.0 can be utilized in v2.0.

You can use v1.0 software to convert v1.0 Excel to dbc, and then use v2.0 software to convert dbc back to Excel, and that will work perfectly!

You will find that the Excel generated by v2.0 has the newly added attributes listed above.

The modification of the “send type” will be automatically implemented when converting dbc to Excel, and you do not need to make any edits or modifications in Excel.

What you may need to do is to familiarize yourself with those characters and develop a sense of familiarity… cyclic, active, blah blah blah

InitValue Explanation

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

In Vector’s dbc coding specification document, it is clearly stated that Init.Value is the raw value, i.e., the original value on the bus.

However, in the CAN dbc++ interface, this value is the physical value, as shown in the following image. In CANoe, clicking on the blue part in the image will provide further pop-up explanations.

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

To maintain continuity in usage and to align with CANdb++, Vehicle Technology’s excel2dbc v2.0 continues to use physical values for signal InitialValue, which is more reasonable and aligns with user thinking habits.

After all, for variables such as “temperature”, engineers are clearly more familiar with the initial value of “20 degrees Celsius” rather than “0x4E”.

Sharing Guidelines

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Sharing guidelines refer to Bus Lecture 10, the best excel2dbc tool in the Eastern Hemisphere…

As shown below:

Bus Lecture 10, the best excel2dbc conversion tool in the Eastern Hemisphere, always free to give

For specific terms, please click to read; no further elaboration here.

If you sincerely want it, please follow the requirements.

It’s not complicated; just forward this article and provide the company email.

For friends who have shared before, you can directly go to the original download link to re-download; the sharing link remains unchanged!

Of course, if you are willing to forward another article, Lion No. 1 would be extremely happy.

Much love~

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Development Process

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Thanks to an excellent and reasonable software architecture, this upgrade was completed in just half a month, even during fragmented spare time.

From this matter, Lion No. 1 deeply feels that to excel in software development, it is essential to have a solid foundation, a critical base, and a useful framework; only on this foundation can performance optimization be discussed.

So, software development engineers should not wait until the software release node to battle system engineers over the rationality of functional definitions; that is purely a distraction. What you truly need to do is optimize software performance and architecture, striving to reduce bugs.

At the same time, through the development of this industry basic tool, you should further feel Vehicle Technology’s strength in LabVIEW testing applications.

Feel free to check the “Vehicle Technology LabVIEW Video Tutorial” below and consider purchasing a copy to enhance yourself, surpass colleagues, and take the most comfortable position in the workplace.

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Self-Evaluation

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Lion No. 1 is most satisfied with two points.

The first is the beautiful Excel generated during dbc to Excel conversion, with bright colors, highlighted key points, and aesthetically pleasing cell formatting, making it very enjoyable to use.

The second is its format checking function, comprehensive and powerful, covering all aspects, making great strides.

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Indeed, creating a conversion tool to implement functionality is simple, but achieving comprehensive format checking is truly challenging, as there are many considerations.

However, for user convenience, this is precisely the most important aspect, as it can alert users to where issues lie.

[Recommendation]
In the automotive industry, never go for outsourcing
Hengrun and Yian, two windows to understand the past, present, and future of the industry

Bus Lecture 10, the best excel2dbc tool in the Eastern Hemisphere, always free to give

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support
Excel2DBC Tool Major Upgrade: AutoSAR Protocol Support

Leave a Comment