Free Trials

Download a free trial to find out which Altium software best suits your needs

How to Buy

Contact your local sales office to get started on improving your design environment

Downloads

Download the latest in PCB design and EDA software

  • PCB DESIGN SOFTWARE
  • Altium Designer

    Complete Environment for Schematic + Layout

  • CircuitStudio

    Entry Level, Professional PCB Design Tool

  • CircuitMaker

    Community Based PCB Design Tool

  • NEXUS

    Agile PCB Design For Teams

  • CLOUD PLATFORM
  • Altium 365

    Connecting PCB Design to the Manufacturing Floor

  • COMPONENT MANAGEMENT
  • Altium Concord Pro

    Complete Solution for Library Management

  • Octopart

    Extensive, Easy-to-Use Component Database

  • PRODUCT EXTENSIONS
  • PDN Analyzer

    Natural and Effortless Power Distribution Network Analysis

  • See All Extensions
  • EMBEDDED
  • TASKING

    World-Renowned Technology for Embedded Systems Development

  • TRAININGS
  • Live Courses

    Learn best practices with instructional training available worldwide

  • On-Demand Courses

    Gain comprehensive knowledge without leaving your home or office

  • ONLINE VIEWER
  • Altium 365 Viewer

    View & Share electronic designs in your browser

  • Altium Designer 20

    The most powerful, modern and easy-to-use PCB design tool for professional use

    ALTIUMLIVE

    Annual PCB Design Summit

    • Forum

      Where Altium users and enthusiasts can interact with each other

    • Blog

      Our blog about things that interest us and hopefully you too

    • Ideas

      Submit ideas and vote for new features you want in Altium tools

    • Bug Crunch

      Help make the software better by submitting bugs and voting on what's important

    • Wall

      A stream of events on AltiumLive you follow by participating in or subscribing to

    • Beta Program

      Information about participating in our Beta program and getting early access to Altium tools

    All Resources

    Explore the latest content from blog posts to social media and technical white papers gathered together for your convenience

    Downloads

    Take a look at what download options are available to best suit your needs

    How to Buy

    Contact your local sales office to get started improving your design environment

    • Documentation

      The documentation area is where you can find extensive, versioned information about our software online, for free.

    • Training & Events

      View the schedule and register for training events all around the world and online

    • Design Content

      Browse our vast library of free design content including components, templates and reference designs

    • Webinars

      Attend a live webinar online or get instant access to our on demand series of webinars

    • Support

      Get your questions answered with our variety of direct support and self-service options

    • Technical Papers

      Stay up to date with the latest technology and industry trends with our complete collection of technical white papers.

    • Video Library

      Quick and to-the-point video tutorials to get you started with Altium Designer

    Excel Versus BOM Software: When Your Data Management Tool Needs an Upgrade

    Altium Designer
    |  September 7, 2018

    Spreadsheet with numbers in columns and row

    At our house, creating a grocery shopping list can become a multi-day event. Stage 1 of the extravaganza involves a careful but not well-planned review of all available grocery store ads. Stage 2 moves on to the analysis of those advertisements. One never knows where bargains may lurk. Then, Stage 3 takes us to the pantry for a study of our available resources while Stage 4 measures our budget against our needs. When we eventually stroll through the grocery store with list in hand, all planning goes out the proverbial window as wife, kids, and husband diverge into grocery store scout teams.

    Don’t treat your manufacturing and design bills anymore lackadaisically. While you could start organizing column, character, quality, and cost in a spreadsheet, it might be best to order inventory and list within a bill of materials file. A template can make the structure easy to work through, and data sure beats out an excel file any day of the week for manufacturing output information.

    Making a List

    A similar (but hopefully much more developed) general set of process steps apply to the early stages of PCB design and the creation of a Bill of Materials (). As we move to assembling the for a project, the task becomes easier because of the different types of management software offered by manufacturers. But what if your budget doesn’t allow access to those bell-and-whistle filled software suites? Can a simple spreadsheet take care of your needs?

    The answer to the spreadsheet question is: “Yes, Maybe, and No.”

    On the “yes” side, most of us create and maintain the initial engineering within a spreadsheet. We use spreadsheets to import data from contractors and vendors. After all, the spreadsheet works as a great tool for arranging the data in sets, performing calculations, and outputting the data to other tools. From the perspective, using a spreadsheet allows us to generate a list of needed for developing and completing a product. For truly small PCB projects, a spreadsheet can become a “yes” and “maybe” response.

    But what about large projects that involve multiple project teams with some members working locally while others work remotely? For those projects, the answer is a clear “no.” Here’s why.

    Excel spreadsheet

    Managing large systems designs and immense production schedules can be a bull.

    Share the Good Times!

    A Bill of Materials provides information about , vendors, manufacturers—and, perhaps, most importantly—about the relationships between those groups. Advanced software allows your design team to create BOMs from the schematic, the layout, or from components used in the design.

    Throughout the PCB design process, various team members along the supply chain, including engineers, PCB design services, vendors, and others, use the BOM to make decisions and manage assets as the project moves from concept to prototyping and eventually to production. As an example, an engineering team may need to understand the operating relationships between components within a product. At the same time, other members of the design team may need to review the vendor list, financial information, or delivery estimates.

    Collaboration is Key!

    Because of its complexity, the BOM requires management. On one hand, the BOM software must serve multiple users who need simultaneous access. On the other, the BOM must recognize the relationships between stored items. The BOM also works as a record management tool that ensures that the most current revisions are visible to all members of various different teams. This management capability pays dividends as engineering teams focused on costs and tasks hand over the PCB project to manufacturing teams that build the product. Both teams need the ability to work from the same product data.

    While spreadsheets may provide some of the right tools for managing small projects, managing even small and mid-size PCB design and production teams requires tools that support a much larger view of the business world. BOMs can save costs through real-time, simultaneous access to repositories of product information. Having this type of access reduces opportunities for errors that can occur when copy-pasting or transferring data from one BOM to another.

    Collaboration through a BOM can also reduce costs because of operational transparency. Anyone within the enterprise can access the BOM and view cost and availability information. Many BOM packages also allow business partners—such as the supply chain or third-party design teams—to access the information. This unified access ensures that the right go into the product.

    Organizing information in a spreadsheet

    Don’t get lost in excel spreadsheets ever again

    Software Integration Works!

    Most software packages accept the automatic transfer of CAD information. For example, you can generate a from a CAD assembly that includes images of the components and mechanical . Integrating the , CAD, Enterprise Resource Planning (ERP), and Product Lifecycle Management (PLM) systems synchronizes design, engineering, and manufacturing tools.

    While integration allows different types of software to communicate during the design process, software can use different formatting options and templates. With this capability, you can use the can export to different output file formats. Advanced software tools export to the CSV, XLS, PDF, Tab Delimited Text, HTML, and XML spreadsheet formats.

    With reliable software like Altium on your side, you can optimize the PCB development process and keep track of various files, formats, and templates. And with the added functionality of Active , your design teams can save time and minimize costs by providing manufacturers with the correct format from the get-go. Talk to an Altium expert today to learn more.

    About Author

    About Author

    PCB Design Tools for Electronics Design and DFM. Information for EDA Leaders.

    most recent articles

    Back to Home