A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

Can I digitize Bill of Materials by making a photo of my BOM spreadsheet?

Can I digitize Bill of Materials by making a photo of my BOM spreadsheet?
Oleg
Oleg
3 March, 2019 | 2 min for reading

Digital transformation and machine learning is coming to us from every possible and, sometimes, very unexpected direction. Over the weekend, my attention was caught by very interesting news that came from Microsoft. Check Engadget blog – Import Excel data just by photographing a spreadsheet.

The new import feature uses image recognition technology to identify all of the information on the page and convert it into an Excel spreadsheet in the app. It should eliminate the need to manually enter or copy data, depending on its accuracy. The feature, labeled in-app as “Insert Data from Picture,” can perform the conversion from analog to digital with a single tap. Microsoft first floated the idea for this tool last year before being made widely available in the most recent update to the Android app. It’s just the latest in the company’s ongoing efforts to insert more machine learning models into its products.

Thinking about pragmatic approaches in the digital transformation of engineering and manufacturing, I found this feature very interesting. There are tons of debates about digital transformation. But simple ones are usually overlooked. Think about information which resides on paper or paper-like data sources. Engineering and manufacturing companies have tons of data like this. Just step in every manufacturing company shop-floor or archive and you will see a lot of printed drawings or PDF files with a bill of materials. By making pictures of BOM tables you can transform this information into a digital form.

You can ask, what is a big deal? Here is the thing… for many manufacturing companies (especially small ones) when you need to order parts, drawings are often the only source of information that actually needs to be ordered. A traditional (analog) way to do business will be to send this information to the purchasing department as PDF drawing, but getting it in Excel can speed up the process. Actually, by connecting this app to PLM tools can make it even better. (I’m considering to bring transformed BOMs directly to OpenBOM in one of the future releases – disclose, I’m co-founder and CEO of OpenBOM).

What is my conclusion? Digital transformation can have a significant impact on manufacturing companies. While often PLM companies are speaking about PLM as a strategy and multi-year business transformation, small and simple things matter. If you can get BOM from PDF file to be transferred into digital format and be able to manage purchases directly using one of the available PLM, ERP or new cloud online tools (eg. OpenBOM), it can be big deal for these companies. Just my thoughts…

Best, Oleg

Disclaimer: I’m co-founder and CEO of OpenBOM developing cloud-based bill of materials and inventory management tool for manufacturing companies, hardware startups, and supply chain. My opinion can be unintentionally biased.

Recent Posts

Also on BeyondPLM

4 6
29 March, 2021

Autodesk’s article Why Data Interoperability Is Game-Changing for Collaboration written by Amy Banzel caught my attention over the weekend. It...

20 February, 2009

I’d like to discuss 3D. The following 3D Perspectives blog post “Do Designers Really Want to Communicate in 3D?” got...

20 November, 2017

One of the things that caught my attention last week at Autodesk University 2017, was Andrew Anagnost, Autodesk CEO keynote...

10 March, 2016

Machine learning is an interesting trend to observe today. Companies are placing big bets on machine learning algorithms and thinking...

14 October, 2011

I wanted to share some of my notes from yesterday Dassault PLM forum in Moscow. Getting back to previous forums...

18 September, 2019

Last year, I asked if the Salesforce platform can accelerate cloud PLM. if you missed my article navigate your browser...

16 September, 2010

Email is playing a significant role in the way every organization is management today. Organizations are run by emails these...

4 August, 2014

The speed of data creation is amazing these days. According to the last IBM research, 90% of the data in...

25 January, 2017

To choose PLM is a difficult task. Usually it takes months and sometimes years. You wonder why it takes so...

Blogroll

To the top