Excel BOM Comparison Analysis

@furkancakir

Hi. I'm expert on excel, hourly price is not suitable for me I thought if you want I can help you with fixed price maybe, or I can continue with my hourly? Btw Can I see document please. Thanks. Principal Mechanical Engineer https://www.freelancer.com/u/furkancakir # SolidWorks # Visualize # ANSYS # Composer # AutoCAD # 3dsMAX # LS-Dyna # Abaqus # Fusion 360 # Inventor # FreeCAD # Blender # Q-Blade # Altair EDEM # Rocky DEM # MeshLab # Bambu Studio # MS Excel # MS Word # MS Office # VBA for SolidWorks # VBA for MS Excel # C++ # Java # MatLab 600+ Character Per Minute. Thanks,

@bhupendrayadav

I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can create this excel based automation tool which takes data from all available BOM files and clean and validate the data, summarise and compare the data on given parameters. Please have a look at my previous projects portfolio for details on my experience. I can deliver a fast, accurate, and customized solution for your requirements. Let’s discuss your project—I can start right away. Lets chat for further discussion. Looking forward to working with you!

@omkumarsingh1

Merging BOMs across revisions always breaks on inconsistent part naming before pricing differences even show up—that's usually the real bottleneck, not the lookups themselves. My approach: import each BOM via Power Query, normalize manufacturer names and part number formats in a staging layer, then use XLOOKUP with error-trapping to build the master comparison so nothing silently drops. Duplicates and mismatches get flagged automatically, not manually. Pivot tables sit on top, refreshable with one click, no hard-coded paths, tested on Excel 2016+. I've handled electronic component BOMs before, so unit variants and alt-manufacturer mapping won't trip things up. I'll also add short notes explaining the structure so you can extend it yourself later. How many BOMs are you merging, and are they already in consistent column layouts?

@CAPSFinGlobal

All your BOMs merged, normalised, and compared in one clean workbook — cost variances, manufacturer changes, and missing parts surfaced automatically. That's what I'll deliver. I'm Puneet, a Chartered Accountant with advanced Excel skills across Power Query, XLOOKUP, Pivot Tables, and data modelling. I've built multi-source consolidation workbooks and management dashboards for finance teams — the same logic applies directly to BOM comparison. Here's my approach: - Power Query to pull all source BOMs in, normalise part numbers and naming conventions, and flag duplicates or mismatches automatically - XLOOKUP-based comparison layer for accurate cross-BOM lookups across every part number - Two dedicated comparison views — one for cost variance (price deltas by part and revision), one for manufacturer/part changes (alternates, additions, removals) - Pivot table dashboards refreshable with one click when new BOM data arrives - No hard-coded paths — fully portable across any Windows Excel 2016+ installation - Short usage notes so you can maintain and update the file without breaking anything Before I start I'll need the source BOM files and a quick note on how part numbers are structured across revisions. How many BOMs are we merging and what's your timeline? Puneet Kumar, CA

@gowrik16

Hello, Your project is an excellent match for both my technical background and Excel expertise. I hold a Bachelor's degree in Electrical & Electronics Engineering and previously worked as a Project Engineer, where I was highly involved in preparing and validating Bills of Materials (BOMs), material planning, and cost calculations for engineering projects. This experience has made me detail-oriented and very calculative when comparing components, quantities, and pricing. My approach will be: * Consolidate all BOMs into a structured master workbook. * Normalize part names and manufacturer details. * Use XLOOKUP/VLOOKUP, Pivot Tables, and Power Query to identify duplicates, missing parts, manufacturer changes, and cost variances. * Build refreshable comparison views with clear summaries and provide simple documentation for future updates. I have also developed Excel and Power BI reporting solutions involving data cleaning, analysis, and interactive dashboards, which are showcased in my portfolio. I can start immediately and deliver a clean, well-documented, and easy-to-maintain solution. Please take a look at my portfolio, and I would be happy to discuss your requirements further through an interview where you can evaluate my technical approach and ability to deliver high-quality results. Thank you, Gowri K

@yogeshs124

I have built such master data templates before and have done professionally summarised and presented of such data