Find Jobs
Hire Freelancers

Bill of Materials - Excel based

$250-750 USD

Completed
Posted 6 months ago

$250-750 USD

Paid on delivery
I am looking to create an Excel-based Bill of Materials. I would want an input form where I can define detailed descriptions of the components of a part (e.g. name, material, dimensions, units, quantity), a list of purchased parts for that part (e.g. screws, washers, raw materials) that can be pulled from a drop-down list, and packing list. The input form would then store those components and purchased parts in a database for the parts. There should be a list of purchased parts that is either built from the input forms or is imported from elsewhere. The operator would be prompted for which the Part Number and Quantity for the parts that are being built - and the Bill of Material report output would list the component parts, purchased parts and the packing list necessary for that quantity of the specified part. While we envision this being in the form of an Excel file (see attached example) that does not have to be how the project is implements. The goal is to have the ability to input the components of an assembly or single parts into a database and then have the ability to query the system to create a Bill of Materials to serve as a production and packaging guide.
Project ID: 37427904

About the project

126 proposals
Remote project
Active 6 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I've recently built a Bill of Materials workbook tool for another client in NC that I would love to demo for you. Functionality includes numerous user forms, drop-down objects, progressive list boxes that identify item subgroups, pictures associated with items (it's a lot of fun). Excel based tools that feel like a web experience are my specialty - let's chat! ** US born/educated/based and I speak perfect English | Graduated Penn State University ** ** Check my profile and compare the quality of work to the other candidates ** ** Created and managed a Business Analytics division for a $300M manufacturing company for 10+ years ** - Excel: 20 years @ expert level (as good as it gets, I know all the tips and tricks of the trade) - Visual Basic: 20 years @ expert level (creative code writing, proficient in modules, userforms, procedures) - Data/Reporting Analysis: 20 years @ expert level (never done anything else since college) - Project Management: 15 years @ expert level (complete system development lifecycle) - Professional Consulting: 7 years (for large corporations like Microsoft, Salesforce, Home Depot) I work fast, I communicate well, and I listen to your needs closely but also provide additional options and suggestions knowing what the tool is capable of and how I can make it help you best. You want an Excel Wizard? I'm the freelancer you're looking for. I would be happy to send more examples if you would like additional information.
$600 USD in 5 days
5.0 (4 reviews)
4.6
4.6
126 freelancers are bidding on average $427 USD for this job
User Avatar
Hello, I am Full Time Expert Techno-Functional Freelance Analyst having in-depth experience in various programming languages including Macro Programming for entire MS Office suite. I understand that you are looking to create an Excel-based Bill of Materials system that will allow users to enter parts information into a database and have the system query the system to generate a Bill of Materials to serve as a production and packaging guide. With my expertise in data entry, data processing and Excel, I believe I can build the solution exactly as you envision it. Additionally, I provide long term support for the developed solutions. I would love to discuss this project further with you. Please feel free to reach out if you have any questions or would like me to provide more information about my skillset and endtoend functional testing services.
$590 USD in 3 days
5.0 (922 reviews)
9.4
9.4
User Avatar
Dear Employer, I am an Excel expert with over 15 years of expertise and will build a professional BOM solution for you to enter the components and purchased products through a dropdown option. I have built several such solutions for you. Kindly suggest a suitable time to connect. Thanks and Regards, Ashish
$750 USD in 7 days
5.0 (302 reviews)
8.4
8.4
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$500 USD in 7 days
4.9 (610 reviews)
8.6
8.6
User Avatar
Hello there, Straight to the point, how about intergrate excel into VB for this project ? This way, you will able to see a wonderful front end to input data and view data. We are confident, we can do your project in style with all the requirement you mentioned on your project. We are open to discuss further Waiting for your good reply
$250 USD in 7 days
5.0 (75 reviews)
8.4
8.4
User Avatar
Dear Sir, Are you looking for a solution to create an Excel-based Bill of Materials? I can provide a solution for this project. My proposal includes the following steps: 1. Design an input form where detailed descriptions of the components of a part (e.g. name, material, dimensions, units, quantity) can be defined. 2. Create a list of purchased parts for the part that can be pulled from a drop-down list. 3. Store the components and purchased parts in a database for the parts. 4. Prompt the operator for the Part Number and Quantity for the parts that are being built. 5. Create a Bill of Materials report that lists the component parts, purchased parts and packing list necessary for the specified part. 6. Deliver the solution in the form of an Excel file (see attached example). I am confident that I can deliver a solution that meets your requirements. To demonstrate my capabilities, I offer a free demonstration of the solution even before the project is awarded. I look forward to hearing from you and discussing the project further. Sincerely, Smith
$500 USD in 7 days
4.9 (77 reviews)
7.0
7.0
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$500 USD in 7 days
5.0 (191 reviews)
7.1
7.1
User Avatar
Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 years of in the Freelancing field. With my skills and expertise, I can guarantee 100% success rate in your project. I have a deep understanding of the requirements of this project and I'm confident that I can provide you with the best results. Additionally, I provide regular updates during the project so that you don't have to worry about anything. Please feel free to contact me if you have any questions or would like to discuss this opportunity further. All the best, Muhammad Ali
$250 USD in 1 day
5.0 (164 reviews)
6.7
6.7
User Avatar
Dear hiring manage ,, Fully understand your requirements & already i saw your attached xls file, I can provide you create an Excel-based Bill of Materials .understood what you require. I can do this project with 100% accuracy right now. I want to send you sample tamlate because your satisfaction is my pride. I am the best freelancer for your job. Choose me and I will deliver within right time. I can get this done for you. Thank you M A Kayem Hussain
$250 USD in 2 days
4.9 (125 reviews)
6.3
6.3
User Avatar
Hello Good afternoon , I just finished reading the job description . I see you are looking for someone experienced in developing products using Visual Basic, Engineering, Excel, Data Processing and Data Entry. This is something I can do, Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) My Portfolio: https://www.freelancer.com/u/AwaisChaudhry Please start the chat to discuss it further. Regards, Awais
$750 USD in 13 days
5.0 (6 reviews)
6.5
6.5
User Avatar
Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!
$250 USD in 1 day
5.0 (93 reviews)
6.0
6.0
User Avatar
Hi, I will do microsoft excel spreadsheet, google sheets work using vba, macro, formulas and script Services: Customized Automated excel spreadsheet with Formulas, Tables or Graphs. Customized Automated Google Sheets with Formulas, Tables or Graphs. Create Customized Automated Dashboard in excel or google sheets Excel/Google Sheets Formulas Microsoft Excel VBA/macro Excel Charts or Graphs Invoices/Pay Slips Financial Budgeting / Investment Calculators Buttons, Drop-down lists, menu, forms. Conditional Formatting Pivot tables automated dynamic excel dashboard large data analysis Apply formulas/Advance Filter Vlookup/Hlookup, Index-Match Spreadsheet Excel data entry and formatting
$500 USD in 7 days
5.0 (26 reviews)
5.9
5.9
User Avatar
Dear Client, I propose the development of a BOM system to meet your requirements. Here's a concise plan: Input Form: Create a user-friendly form for part details and purchased parts. Database Integration: Store data in a dedicated database for easy retrieval. Purchased Parts List: Maintain a list for components, either input or imported. Operator Prompts: Input Part Number and Quantity for production. BOM Report: Generate a detailed BOM report for production and packaging guidance. Flexible Implementation: Adapt the system to your preferred format, be it Excel or other. This solution streamlines part management and documentation. We are committed to delivering a high-quality product on time and within budget. Looking forward to discussing this further. Best regards, Muhammad H.
$300 USD in 1 day
5.0 (51 reviews)
5.8
5.8
User Avatar
I understand you are looking for someone to create an Excel-based Bill of Materials system that can store components, purchased parts, and packing lists necessary for producing a part quantity. I believe I am the perfect person for this project. My skills include data entry, engineering, and Excel. I am skilled in Visual Basic and can start working on your project immediately. My experience includes working with Visual Basic, VBA, MS Access and Microsoft SQL Server. This combination makes me well-suited to creating an Excel-based system that can store components, purchased parts, and packing lists necessary for producing part quantities. There are many other solutions like building a standalone app or Ms Access database. I can provide a prototype within 3 hours after discussion. Best regards, Michael
$250 USD in 3 days
5.0 (67 reviews)
5.8
5.8
User Avatar
Dear Client,                 I am writing to express my interest in collaborating with you on your project posted in Freelancer. Based on the project details provided, I assure you that I have the skills and expertise required to deliver high-quality work within the specified timeframe. I am confident in my ability to deliver exceptional results for your project. I am committed to maintaining open lines of communication, delivering on time, and ensuring your complete satisfaction. Waiting to hear from you. With thanks regards
$398 USD in 7 days
4.7 (111 reviews)
6.3
6.3
User Avatar
Hello there, I understand that you would like an input form where you can define detailed descriptions of the components of a part (e.g. name, material, dimensions, units), a list of purchased parts for that part (e.g. screws, washers) that can be pulled from a drop-down list, and packing list. Regards, Ritika
$250 USD in 1 day
4.9 (121 reviews)
6.2
6.2
User Avatar
"Hello there, ⭐⭐⭐⭐⭐ I’m ready to work right now ⭐⭐⭐⭐⭐ I understand your project description very well. I'm an electrical engineer with a master's degree in electrical engineering. I have vast experience in Excel. I can help you with your statement .Plz contact me for more details Thanks Ibrahim Ragab"
$500 USD in 10 days
4.9 (72 reviews)
5.8
5.8
User Avatar
Hello, I'm excited about the prospect of creating your Excel-based Bill of Materials. I'll design a user-friendly input form to define component details, utilize drop-down lists for purchased parts, and integrate a dynamic database for seamless storage and retrieval. Your vision for easy querying and report generation aligns with my expertise. While I'll adhere to the Excel format, I'm open to optimizing implementation for efficiency. With a keen eye for detail and a commitment to user-friendly functionality, I'm ready to streamline your production and packaging processes effectively.
$250 USD in 7 days
4.8 (88 reviews)
6.1
6.1
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. I can design complex formula and functions that fits to your needs. Feel free to message me to help you as soon as possible. Thank you so much.
$300 USD in 5 days
4.9 (76 reviews)
5.7
5.7
User Avatar
Hi there, I hope this message finds you well. I have carefully reviewed the project details you provided and I am confident that I can assist you in creating an Excel-based Bill of Materials system that meets your requirements. The proposed solution will include an input form where you can define detailed descriptions of the components of a part, such as name, material, dimensions, units, and quantity. Additionally, there will be a list of purchased parts for each part, which can be selected from a drop-down list. The input form will store these components and purchased parts in a database for easy access and management. Furthermore, the system will have a list of purchased parts that can be either built from the input forms or imported from external sources. This will provide flexibility and convenience in managing the inventory of purchased parts. To generate the Bill of Material report, the operator will be prompted to enter the Part Number and Quantity for the parts being built. The system will then generate a comprehensive report that includes the component parts, purchased parts, and the packing list required for the specified quantity of the part. This report will serve as a production and packaging guide, ensuring accurate and efficient assembly processes. While the initial concept is based on an Excel file, the implementation can be customized to suit your specific needs. The main objective is to create a user-friendly interface that allows you to input...
$500 USD in 15 days
5.0 (4 reviews)
5.6
5.6
User Avatar
Hello Dear, I hope you are doing great and are in good health. I see that you need a statistical data analyst. I am an expert data analyst and research consultant with a deep understanding of several financial models, statistical methods, and their applications. I am expert in Visual Basic, Engineering, Excel, Data Processing and Data Entry. I can handle undergraduate, postgraduate, doctoral, and corporate research I am confident working on new challenges and can guarantee that your project will be returned on time and high-quality work. Finally, my priorities are customer satisfaction and fast delivery. My statistical analysis skills include: • Bayesian and Classical Statistics • Biostatistics • Certainty, Uncertainty, and Probability • Bayes’ Rule • Data Cleaning, Synthesis, and Preparation • Experimental Design • Regression and Multivariate Analysis • Time Series Analysis • Spatial Analysis • Meta-Analysis • Machine Learning • Exploratory Data Analysis • Data Visualization I can use these tools for data analysis; • R Programming • STATA, • Anylogic • Python, • Eviews, • SAS, • Matlab, • Eviews, • Minitab, • Excel • SPSS Thanks Regards Muhammad Asad
$555 USD in 6 days
5.0 (11 reviews)
5.3
5.3

About the client

Flag of UNITED STATES
Hamilton, United States
5.0
3
Payment method verified
Member since Dec 31, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.