top of page

MainSheet Solutions
BOM Tools Suite:  An Add-in for Microsoft Excel simplifying spreadsheet work with Bills-of-Material and other structured tables/lists

Menu Ribbon of all BOM Tools Suite Functions
Example Spreadsheet

Our Add-in provides 20 time-saving functions covering over 250 use cases for Bill of Material Management, Formatting, and Analysis.

Formatting

Ribbon - Formatting Functions

Make tables easier to navigate.
 
Find what you need.

Customize the appearance.

Management

Filter tools delete, hide, or highlight what you want or don’t want.

Precisely Replace what you don’t need.

Manage tables using unique identifiers.
 
Automate the generation of outline structure ID, e.g. 1.2.2.1.

Associate each line with it’s next higher assembly.

Smart sorting can sort an outline structure ID, e.g. 1.2.2.1.
 

Analysis

Ribbon - BOM Analysis Functions

Generate Rollup Equations.

Weighted Averages.
 
Maturity Projections.
 
Extended Quantities.

and Check Structure.
 

Ribbon - BOM Management Functions

Why use BOM Tools Suite?

Enterprise systems are very powerful.

 

But they can't do it all.

In the gaps between enterprise functionality exists an ecosystem of excel spreadsheets, which in many cases are used to generate the source data for the enterprise systems.  

Spreadsheets are also very powerful, but are often not used in repeatable ways.   

That's where the BOM Tools Suite comes in.

Bills of Material (BOMs) are often downloaded from an enterprise Product Data Management (PDM) system, or an Enterprise Resource Planning (ERP) system, or a Computer Aided Design (CAD) system to a spreadsheet for data manipulation and analysis at which point the engineer may need to:

  • Format the BOM, e.g. group rows

  • Filter items that don't effect higher level analyses

  • Apply engineering parameters, e.g.

    • Mass properties, Mass, CG, Moments of Inertia

    • Material Cost

  • Analyze the BOM at multiple levels 

  • Answer questions like,

    • Which subsystem weighs the most? 

    • Will the system achieve cost goals?

    • What is the Mean Time Between Failures (MTBF)?

    • What is the Operational Availability?

    • What is the Mean Time to Repair (MTTR)?

The tools in the BOM Tools Suite are useful in many of the 'ilities' and other engineering analyses, e.g.

  • Reliability, e.g.

    • Mean Time Between Failures, MTBF

    • Mean Time Between Maintenance, MTBM

  • Maintainability,

    • Mean Time To Repair, MTTR

  • Availability, Operational (Ao), Inherent (Ai)

  • Supportability

  • Maintenance Ratio, MR

  • Mass Properties, Centers of Gravity, CG

  • Affordability / Cost Engineering

    • Material Cost

    • Labor Cost

  • Material Planning

  • Project Management and hierarchies of tasks and subtasks

Using the BOM Tools Suite can save time and money and help generate the actionable data your organization needs.  Such data supports milestone/phase gate reviews during product development, and may be instrumental in generating contract deliverables.  

Have confidence in your data.

Have confidence in your analysis.

Have confidence in your decisions.

Better decisions means happier customers. 

Just think...a few clicks in your spreadsheet can change the world.

Download for Excel

Mainsheet ICON
bottom of page