Tech Tip: Accelerated Electrical Designs with Excel and E3.series

Menu

We are all looking to gain productivity in our design cycle to save time and reduce costs. A good method to get a head start is to use Excel or a .csv file to get the design started and load devices into you project.

The most common application is to load the connectors and signals from Printed Circuit Board (PCB) in the electrical design. Blocks can be used to represent systems and the Excel sheet can help you get the system information from other teams or 3rd party vendors.

The information that needs to be included in the Excel sheet is as follow:

  • Part number –The part number must be present in your library to ensure a successful lookup from Excel.
  • Device tag – tags can be edited in the project.
  • Device pin names can be defined or can use default names from the library.
  • Signals – avoid rework by using signals from the Excel sheet and edit them in the project as required.

Linking the ‘Block’ and the Excel sheet enables the user to update the project based on changes in the Excel sheet. The pin, signal and other information can be easily updated in the project using the dedicated update block command.

If you use the amazing Harness Builder extension for E3.series you can import connectors and related connections. The import tool helps in accelerating the creation of a harness in E3.series by helping you define the connectivity in Excel.

The option of working with Excel and .csv files to eliminate rework is a real time-saver and is highly recommended for all designers trying to maximize their productivity.

Sanu Warrier
Sanu Warrier
Sanu Warrier has been a product leader in the Electrical industry working with multiple solutions over the last decade. He has been helping customers find effective solutions to their design challenges, drawing from R&D experience in software, hardware and solutions development. He is a self-professed foody and loves to dabble in gastronomic alchemy as often as possible. The main focus for Sanu continues to be Eliminating inefficiencies, improving design processes and reducing costs to improve your competitive advantage.

Leave a Reply

Your email address will not be published. Required fields are marked *

wp-header-1920x844-iltelligent-design-tool-2-510x310
  • Blog
March 27, 2025
What is an Intelligent E-CAD System?

Traditional CAD software was once just a digital drafting tool, requiring manual updates and prone to inconsistencies. However, as electrical systems grow increasingly complex, intelligent CAD systems have transformed the design process. Learn more on our blog.

Read now
wp-header-1920x844-colosseum-510x310
  • Blog
February 06, 2025
From Rome to the Racetrack: The Gladiators of La Sapienza University Take on MotoStudent

At last year’s Zuken Innovation World Italy, we had the pleasure of meeting a talented team of young engineers from La Sapienza University in Rome. Calling themselves the "Gladiators," Francesco, Matteo, and Domenico are pushing the boundaries of innovation by designing and racing a PreMoto3 prototype in the prestigious MotoStudent competition. Read the whole story on our blog.

Read now
next-generation-car-featured-img-510x310
  • Blog
December 12, 2024
Electrifying Transportation: Challenges and Opportunities

The transportation industry never experienced breakthroughs prior to electrification. Now, innovations in motor, control, and battery technology are enabling the electrification of the transportation industry.

Read now
Industrial Automation: A focused engineer interacts with a futuristic holographic interface, showcasing the power of advanced technology in a modern industrial setting
  • Blog
December 05, 2024
Designing the Future: Challenges and Innovations in Industrial IoT

From automation to real-time analytics, the Industrial Internet of Things (IIoT) is fundamentally transforming industries. But behind the opportunities lie challenges: Can security, legacy equipment, and complex systems be seamlessly integrated? Discover how smart factories of the future are being shaped and why the IIoT is the key to it all.

Read now