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
Technical Marketing Manager
Sanu Warrier is a Technical Marketing Manager, helping customers find effective solutions to their design challenges. His work focusses on eliminating inefficiencies, improving design processes and reducing costs to improve competitive advantages. He is a self-professed foodie and loves to dabble in gastronomic alchemy as often as possible.