Description
Download the zip file
This Python tool converts complex bills of materials (BOMs) from PDF or Excel into clean, consistent Input-Output Data Inventory (also known as life cycle inventory) and costing tables that align with PNNL’s Excel templates on DataHub. After uploading a BOM, users make a few selections; the script then parses, cleans, and fuzzy‑matches fields to map components and metadata into inventory‑ready structure with high accuracy. The process reduces manual effort by roughly an order of magnitude, speeds analysis for end-to-end, supply chain, and Build America, Buy America (BABA) reviews, and improves data consistency across projects. It is optimized for mechanical and electrical industries, with broader applicability to other sectors. The outputs—two tables (data inventory and costing)—can be uploaded directly to the data inventory templates (see DataHub Project page for the link to the templates), enabling faster, more reliable supply‑chain and compliance assessments.
Download the zip file above or click on this link to open the web-app version.
https://pnnl-bom-app.streamlit.app/
CITATIONS: Bill of Materials to Input‑Output Inventory Converter
Bibliography APA
Bixler, T., & Hickcox, K. S. (2026, March). Bill of Materials to Input‑Output Inventory Converter [Python Software]. Richland, Washington, U.S.: Pacific Northwest National Laboratory.
Bibliography MLA
Bixler, Taler and Kate S Hickcox. " Bill of Materials to Input‑Output Inventory Converter." Richland: Pacific Northwest National Laboratory, March 2026. Python Software.
If you have any questions or feedback, please contact us: LCI-Template@pnnl.gov