top of page


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

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

Generate Rollup Equations.
Weighted Averages.
Maturity Projections.
Extended Quantities.
and Check Structure.

Uses:
In many engineering functions, Bills of Material (BOMs) are downloaded from an enterprise Product Data Management (PDM) system to a spreadsheet for 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
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.
bottom of page