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.
A diagram showcasing how the use of PLM can improve functionality, as was the case with Haulotte integrating Zuken's E3.series
  • Blog
February 20, 2024
Delivering on the Promise of Product Lifecycle Management (PLM)

Product Lifecycle Management (PLM) stands as a cornerstone in enhancing product development and operational efficiency, offering a comprehensive approach to navigating the complexities of modern manufacturing. Discover the strategies for effective PLM integration on our blog.

Read now
Haulotte's integration of E3.series with ARAS PLM, highlighting improved engineering processes, efficiency, error reduction, and PLM integration, supporting Haulotte's innovation and success in aerial work platforms.
  • Case Study
January 16, 2024
Haulotte

Haulotte's choice of Zuken's E3.series solution has enabled the optimization of work methodology and a more serene and effective projection towards future developments

Read now
The integration of the E3.Series and DS-E3 solutions with the ARAS PLM fully meets the needs expressed by the engineering department at Haulotte.
Hydrogen Fuel Cell Vehicles: Are they a Sustainable Automotive Innovation?
  • Blog
January 15, 2024
Hydrogen Fuel Cell Vehicles: A Sustainable Automotive Innovation

The fuel cell is indeed a clean and sustainable energy technology, primarily due to its ability to generate electricity with minimal emissions of greenhouse gases and pollutants. However, its wider diffusion faces several challenges. Learn more on our blog.

Read now
MLC Technologies' sailboat, powered by Zuken's E3.series design tools, showcases advanced maritime technology in action for the blog on innovative off-grid solutions.
  • Blog
November 20, 2023
MLC Technologies Introduces E3.series for the Design of Maritime and Off-Grid Technologies

MLC Technologies Ltd, a fast-growing electrical engineering business specializing in delivering complex mission critical electrical and electronic solutions for data acquisition, mission control, power distribution, and navigation applications in maritime and off grid environments, has introduced Zuken’s E3.series ECAD software for the design and validation of their electronic and electrical systems and wiring harness designs.

Read now