Comprehensive BOM & Fabrication Spreadsheet

@HiraMahmood4072

Hello, With over 7 years of experience in Excel, Excel VBA, Excel Macros, and Data Management, I have the expertise required to handle your project efficiently. I have carefully reviewed your requirements for a Comprehensive BOM & Fabrication Spreadsheet tool. To address your needs, I propose to create a dynamic Excel workbook that will allow you to select different materials and dimensions from drop-down menus, automatically calculating material requirements, weight, and total costs. The workbook will include separate cost columns for workshop labor, site labor, and other processes, providing you with a clear project total. Additionally, I will incorporate features for scheduling, enabling you to assign start dates, durations, and workstations for each item or assembly. The deliverables will include a user-friendly Excel workbook with formulas and structured tables, a summary dashboard displaying total costs and labor breakdowns, and documentation to guide you on adjusting rates or adding new columns. I will ensure that the tool functions seamlessly in Microsoft 365. I would like to discuss this project further with you in chat to provide a tailored solution. Please feel free to connect for a detailed conversation. You can visit my Profile: https://www.freelancer.com/u/HiraMahmood4072 Thank you.

@zafarfarooq612

Hello, I am an experienced Excel specialist who has built custom estimation and scheduling tools for steel fabrication projects. I will create a clean workbook with dropdown menus for materials (structural steel, plates, pipes, fittings) that automatically calculate quantities, weights, and costs—plus separate columns for workshop and site labour rolling up to project totals. On the scheduling side, you'll assign start dates, durations, and workstations to each item for an at-a-glance production view. Includes a summary dashboard and brief documentation. No macros needed. Regards, Zafar

@Yohanesujang

Hi Sir Ujang here I have experience on your project 1. Start with brainstorming of the design 2. CAD with Solidworks/OnShape 3. Create the BOM (part qty, part cost column if needed, etc) 4. Create manufacturing drawing include the tolerance needed Let me know if you are interested to work with me

@ShaikhAneesa

Hello, I’ve reviewed your project details and understand that you need a comprehensive Excel based BOM, costing, and fabrication scheduling tool tailored for steel and stainless steel workflows. With strong expertise in advanced Excel modeling and production planning systems, I can confidently build a scalable and intuitive workbook that aligns with your operational needs. My approach begins by designing structured tables with data validation and dropdowns for material categories, dimensions, and quantities. I will implement dynamic formulas using INDEX MATCH, XLOOKUP, and named ranges to calculate material weights, costs, and totals based on predefined rate libraries. Next, I will build cost modules that separate workshop labour, site labour, and additional processes, ensuring all values roll up into a clear project level summary. For scheduling, I will create a timeline view using date logic, conditional formatting, and Gantt style visualization to highlight workloads and clashes. Finally, I will design a clean dashboard using pivot tables and charts, along with documentation explaining formulas and customization points. Would you like the scheduling view at item level or grouped by assemblies for better planning visibility? Best Regards, Aneesa.

@subodhkumarv2015

Hi, there I hope you’re doing well. I’m a Mechanical Engineer with strong experience in SolidWorks, Fusion360, Inventor, product design, 3D modeling, Printing, and manufacturing drawings. I’ve completed many projects as following: • 3D modeling and mechanical design with functions • Detailed engineering drawings and GD&T • Product development from sketches or new concept idea • 3D printing(STL) and Design for manufacturing (STEP) • High qualitied Rendering I can deliver accurate results and fast revisions, and I always maintain clear communication and reliability. I’d be happy to discuss your project details and start immediately. Looking forward to working with you. Best regards

@sabaehsan

Greetings, Thank you for the detailed project description. It sounds like you’re looking for a comprehensive Excel tool that streamlines your bill-of-materials process for steel and stainless steel jobs, integrating material calculations, costs, and fabrication scheduling into one efficient workbook. To tackle this, I would create a user-friendly Excel workbook featuring dropdown menus for easy selection of materials, dimensions, and quantities. I'll incorporate formulas to automatically compute material needs, weights, and costs, while also providing clear columns for labor costs. The scheduling component will allow you to assign start dates and durations, helping you visualize production timelines and avoid potential clashes. I’ll ensure that the workbook is clean, organized, and easy to modify, along with a summary dashboard and brief documentation for your convenience. My experience in Excel and data management will ensure that everything functions smoothly in Microsoft 365. Best regards, Saba Ehsan

@KirtikaKataria

Hi there, I understand you need an Excel-based system that integrates your bill-of-materials workflow for steel and stainless steel jobs with automated cost calculations and a clear fabrication scheduling view. With strong experience in advanced Excel modeling, cost systems, and production planning tools, I can build a structured, scalable workbook tailored to your operations. My approach will begin by designing clean input sheets with dropdown-driven selections for material types, dimensions, and quantities, linked to calculation tables for weight, material cost, and extensible labour categories. I will ensure all formulas are transparent, using named ranges and structured tables so you can easily adjust rates or add new processes. Next, I will build a scheduling layer where each line item can be assigned start dates, durations, and workstations, feeding into a visual timeline/dashboard to highlight overlaps and workload distribution. The summary dashboard will consolidate material costs, labour splits, and project totals with a simple calendar-style view. Deliverable: A fully functional Excel workbook with BOM automation, cost calculations, fabrication scheduling, summary dashboard, and brief documentation for easy updates. QUESTION: To ensure the scheduling is truly useful on-site, do you want the timeline structured around daily workstation capacity limits, or a simpler task-based timeline without capacity constraints? Regards, Shehwani.

@GraphicsHub2k24

Dedicated Freelancer Ready to Elevate Your Project for Comprehensive BOM & Fabrication Spreadsheet. I have a solid background in AutoCAD, Excel VBA, Excel, Engineering, Excel Macros, Civil Engineering, Data Analysis and Data Management, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan

@TheDesignBloke

I’ve reviewed your project and understand you’re looking for a comprehensive Excel tool that integrates your bill-of-materials process specifically for steel and stainless steel jobs. With my extensive experience in Excel development, I can design a workbook featuring dropdown menus for materials and automatic calculations for costs and quantities. Additionally, I will incorporate scheduling functionalities that allow you to manage start dates and durations, helping you visualize and prevent potential clashes in the production timeline. The deliverables will include an intuitive dashboard, structured tables, and clear documentation for easy adjustments. What specific features would you like to prioritize for your dashboard?

@engrhasan01

You’re looking for to create a comprehensive Excel-based tool for your steel and stainless steel BOM, costing, and fabrication scheduling. I’m a Mechanical and CAD Design Engineer with 5+ years of experience building Excel tools for production planning, cost management, and materials tracking. I will develop a workbook where you can select material types, dimensions, and quantities via drop-down menus, automatically calculating weights, material costs, and separate labour/process costs, all rolling up to a clear project total. Deliverables:a clean, unlocked Excel workbook with structured tables, named ranges, and formulas for easy extension; a summary dashboard showing total material and labour costs by category plus a simple fabrication timeline/calendar; and brief documentation explaining formulas, rate adjustments, and adding new processes. The workbook will be fully functional in Microsoft 365, with clear, practical outputs to streamline your quoting and scheduling workflow.

@netclickgr

You need a production-ready Excel workbook that handles BOM selection via dropdowns for structural and stainless steel materials, then auto-calculates weights and costs. The key challenge is integrating workshop/site labour tracking with fabrication scheduling to give you clear timelines and avoid workstation clashes. I'll build this using Python with openpyxl to generate a structured Excel file with named ranges, data validation dropdowns, embedded formulas for weight/cost calculations, separate labour columns, and a dashboard with summary totals and timeline view. The workbook will be fully unlocked and documented so you can extend it. Delivery in 5 days at NZ$125 NZD. I've built custom Excel automation tools for manufacturing and project management workflows, delivering maintainable solutions clients can adapt over time. Ready to start — let's discuss your requirements.

@chiragbhavr

Respected Sir, Thank you for the detailed brief. I fully understand the need for a unified system that bridges the gap between BOM accuracy and shop-floor reality. My approach to this workbook will focus on data integrity and scannability. By using a 'Single Source of Truth' (a dedicated Settings/Rates sheet), we ensure that a price fluctuation in Stainless Steel or an update to your Workshop Labour rate reflects across every active quote instantly. I am well-versed in the delivery of industrial machinery and structural steel packages. In my most recent relevant project—the delivery of a material handling equipments & plant layouts—I utilized SolidWorks for the 3D skeleton and AutoCAD for the site layout and P&IDs. That project followed a 10-week cycle from initial modeling to final production rectification. I am happy to adopt your preferred rhythm of regular reporting and acceptance inspections to ensure our fabrication schedule remains airtight. Best regards, Chirag.

@presillaJ

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.

@zenk7

I am a highly detail-oriented and reliable individual with a strong ability to manage and process data accurately and efficiently. I take pride in maintaining high standards of data integrity, ensuring that all information is entered, reviewed, and organized with precision. I am comfortable working with large volumes of data under tight deadlines, and I consistently deliver results with minimal errors. My engineering background comes as added attribute to this project . I am also well-organized, disciplined, and quick to adapt to new systems and tools, which allows me to contribute effectively from the start. My strong focus, time management skills, and commitment to quality make me confident in my ability to support your team as a dependable data entry specialist.