Excel Automation Expertise Needed

$250-750 USD

Completed

Posted

4 months ago

$250-750 USD

Paid on delivery

I'm looking for a highly skilled freelancer to assist me in automating tasks within Microsoft Excel. My goal is to efficiently manage and process basic data and return optimal results as well as a visual. related specifically to manufacturing foam blocks. Ideal Freelancer Skills: - Proficient in Excel VBA and macros - Experience with automation of data tasks - Knowledge of manufacturing industry a plus - Detail-oriented and analytical thinker Project Requirements: - Ensure accurate interpretation of manufacturing data - Generate solutions for rectangular and custom-shaped blocks processing Specific request: We are a foam manufacturing company and we cut foam to size from very large blocks on saws. We typically calculate the size to cut manually on the factory floor using the hard copy sheets (see attached). I would like to have an excel sheet to essentially mimic these sheets where you input the 3 sizes of the foam we'd like to cut and then the results will show the factory floor how to cut the block as well as showing a visual to the factory workers on how to actually make the cuts- basically creating these sheets in excel. Please let me know your thoughts on cost - this is likely more of a presentation basis than programming, but we will need some formulas and graphics to calculate and show the best way to cut the block and best way to to "yield" pieces from the block BLOCK SIZE IS ALWAYS 40 X 80 X 108 INCHES. There will likely be a couple iterations of this to get to completion.

Excel

Visual Basic

Data Processing

Visual Basic for Apps

Data Entry

Project ID: 37653279

About the project

65 proposals

Remote project

Active 4 mos ago

Looking to make some money?

Email address

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:

@akritisood94

My name is Akriti and I can imagine how daunting it must be to manually calculate foam cuts. But don't worry, as an Excel automation guru, I've got just the solution you need. I will create a fully functional Excel tool that not only replicates your current process but also enhances it with precise formulas and visual aids. My advanced knowledge of VBA macros will help mimic your hard copy sheets while optimizing the process for better yield and minimal waste. With my background in manufacturing, I understand the specifications unique to your industry. This sets me apart from other freelancers as I'll be able to generate solutions that accurately interpret the manufacturing data for efficient foam cuts of rectangular and custom-shaped blocks. Collaborating with factory personnel to test, refine, and implement these solutions won't be a problem, as I'm flexible and persistent in ensuring a perfect fit. The iterations required for this project pose no concern to me; in fact, I see them as valuable opportunities for continuous improvement. My commitment to our collaboration extends far beyond completion—I'll gladly provide support post-delivery to guarantee that our tool pays long-lasting dividends to your foam manufacturing business. Choose me for a comprehensive solution that saves costs and boosts productivity!

$300 USD in 2 days

4.9

(409 reviews)

7.5

65 freelancers are bidding on average $425 USD for this job

@jaylancer43

Hello Sir, From my understanding of your project needs, you require a proficient and detail-oriented professional who can accurately interpret and manage manufacturing data using Excel. I'm confident that my extensive experience in Excel, Visual Basic, and Automation align well with your objectives. Furthermore, my expertise in the manufacturing industry would be valuable as I'm familiar with processes such as cutting foam to size. Working specifically on your request for an Excel sheet to mimic the hard copy sheets, I am well-versed in creating easy-to-use yet powerful sheets that provide essential information - both visually and through formulas. Cost-efficiently cutting the rectangular blocks from your 40 x 80 x 108 inches foam blocks to desired sizes requires precise calculations which I guarantee to deliver. Additionally, I can generate appropriate graphics to display the best approach to cut the block and optimize yield. Thanks

$590 USD in 3 days

5.0

(930 reviews)

9.4

@schoudhary1553

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

(604 reviews)

8.5

@sultanang464

Hi there, I am an expert in excel with VBA & macros. I can do your work with great quality as per your requirements. Please contact so that we can discuss & start your work now. Regards Razia

$250 USD in 1 day

5.0

(309 reviews)

7.4

@daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$250 USD in 1 day

4.8

(239 reviews)

7.3

@kolosibalint

Dear Sir/Madam, I have previously built two similar Excel based tool to a steel manufacturing company. The tools calculated effective way of cutting stock size steel bars into predefined smaller lengths with the least possible waste. The same was developed for stock metal sheets from which smaller rectangles were cut out. I understand that in your case I have to calculate with 3 dimensions but it won't cause difficulties. As I understand, you have a single size stock material that gets cut into smaller pieces. To do the drawing part, my idea is adding vertical/horizontal/diagonal lines onto the stock material's cubiod. Let's say that for example you need to cut 20,5" pieces then, we put a vertical line at the first quarter of the bottom line, then another at halfway then another at 3/4. I'm happy to discuss it in more details but I think I get the main concept. Regards, Balint

$600 USD in 7 days

5.0

(139 reviews)

7.1

@maverick44000

Hello Sir, I have designed similar design Excel sheet in the past for other manufacturing processes. I am keen to get on to this one as well. Please invite for a discussion so we may proceed. Thank you, Usman

$500 USD in 8 days

5.0

(95 reviews)

7.1

@AccountantArman

"""""""""""""""""""""""ADVANCE EXCEL AUTOMATION/VBA MACRO EXPERT"""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

$250 USD in 1 day

4.9

(280 reviews)

7.3

@Giovanni704

Hi there! As I have read, I see you need help automating data tasks in Excel to facilitate your company's data management processes quickly and easily and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.

$250 USD in 1 day

4.9

(62 reviews)

7.1

@mananraja

hi I have reviewed the attached screenshots and can help you with creating an Excel sheet to automate this whole process (blocks processing based on manufacturing data) I'm interested to discuss more details in chat, and can start right away. Abdul H.

$250 USD in 1 day

5.0

(168 reviews)

6.9

@liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

$750 USD in 2 days

5.0

(11 reviews)

6.3

@AwaisChaudhry

Hi Good morning , How are you? I just saw your job posting and currently going through attached files . I see you have been looking for someone experience with these technologies Excel, Visual Basic, Data Processing, Visual Basic for Apps and Data Entry. I believe this is some thing I can help you with because I have 9 years of experience working with these tech stacks and 8 years of experience working on freelancer.com which you can confirm from my profile: https://www.freelancer.com/u/AwaisChaudhry I have few questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements. 2. Do you currently have anything done like Wireframes, UI/UX? Or this job has to be done from scratch? 3. What is the timeline to get this job 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. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Lets start the chat and discuss your job in detail and we will continue from there. Regards, Awais

$750 USD in 10 days

5.0

(5 reviews)

6.3

@merinsinha

Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$500 USD in 3 days

4.8

(165 reviews)

5.8

@arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun

$250 USD in 1 day

5.0

(41 reviews)

5.6

@OmarFarukBD

I am ready to start automating your foam manufacturing data tasks in Microsoft Excel. With proficiency in Excel VBA and macros, I'll develop a user-friendly sheet to streamline the process of calculating and visualizing foam block cutting instructions. My experience in the manufacturing industry ensures accurate interpretation of data, and my attention to detail guarantees optimal solutions for rectangular and custom-shaped blocks processing. I'm committed to delivering a presentation-ready solution promptly. Let's get to work!

$500 USD in 7 days

4.9

(16 reviews)

5.4

@raoarslan56

Hi! I have checked the attached files!!! and read the description carefully!!!. I propose developing a customized Excel solution to automate foam-cutting processes for your manufacturing company. The spreadsheet will allow input of 3 foam sizes and generate optimal cutting instructions with visuals, mirroring your manual hard copy sheets. This presentation-based tool will enhance efficiency and accuracy on the factory floor. The cost estimate includes formulas and graphics to calculate the best cutting strategy, ensuring optimal yield from the standard block size of 40x80x108 inches. Anticipating collaborative iterations for refinement, I am prepared to deliver a tailored solution that aligns seamlessly with your manufacturing needs. I can start working immediately. Text me to discuss more please.

$250 USD in 1 day

5.0

(38 reviews)

5.5

@expert4design

Hi there, Having honed my skills for over 9 years, I possess an deep understanding of Excel's capabilities including VBA and macros that will allow me to create highly efficient solutions for your manufacturing business. Moreover, being a fastidious thinker, I emphasize on every minute detail of the given task ensuring complete accuracy as we migrate the calculation and diagrams to Excel. Furthermore, having a prior experience working with manufacturing data, I bring a nuanced perspective to optimize your rectangular and custom-shaped foam block cutting operations. This means you can not only expect Excel sheets reflecting the inputs but complete visual presentations that resonate with factory floor intuitiveness, showcasing best way to cut the block and yield maximum pieces. Also, as you've rightly pointed out, it's likely that there'll be iterations along the data transformation journey. With my 365 days availability vía Freelancer.com, this never again needs to be seen as a potential pitfall but just another productive step towards project completion. Let's connect in chat for further discussion. Regards, Rahul

$300 USD in 1 day

5.0

(22 reviews)

4.8

@zafarfarooq612

Hello, I am an Excel expert with a strong background in VBA and macros, excited about the opportunity to assist you in automating tasks related to manufacturing foam blocks. My proficiency in Excel automation, coupled with a keen understanding of the manufacturing industry, positions me well to create a customized solution for your foam cutting process. I can develop an Excel sheet that accurately interprets manufacturing data, calculates the optimal sizes for cutting foam blocks, and provides visual representations for the factory workers. The goal is to streamline the process, ensuring efficiency and accuracy in the production of rectangular and custom-shaped foam blocks. I am detail-oriented, analytical, and ready to collaborate on this project, offering a combination of programming and presentation skills to meet your specific requirements. Let's discuss the cost and any iterations needed to achieve the best outcome for your foam manufacturing company. Best regards, Zafar

$250 USD in 1 day

4.9

(54 reviews)

5.0

@ajaykumar0701

I can provide an optimized algorithm which will minimize the PE foam scrap/ wastage basis the ordered dimensions as well as the total existing raw inventory. Let us discuss in detail if we need to implement this in only vertical and horizontal saw or with Skiver and tilt saw as well. The final cut instructions sheet can be automated through excel program along with a visual display of shop drawings.

$300 USD in 5 days

5.0

(10 reviews)

4.6

@EhtishamHaider1

As someone who specializes in Excel automation, I believe I can offer immense value to your project. Working with macros and VBA programming for years, I have mastered the art of leveraging Excel's powerful functions to automate data tasks and ensure accurate interpretation of financial and mathematical information. I understand that for manufacturing operations like yours, precision is key; and with my detail-oriented mindset and experience in the manufacturing industry (process analysis, data visualization), I'm equipped to provide optimal solutions using your rectangular block as a template. Beyond just automating data processing, my skills extend to designing easy-to-use graphical interfaces within Excel which can significantly facilitate the execution of tasks on site. In your case, I envision an appealing, user-friendly and interactive spreadsheet that takes input of 3 dimensions of the foam block you need to cut and then generates detailed cutting instructions along with visuals indistinguishable from those factory floors. Additionally, factoring in the size of blocks being constant at 40 x 80 x 108 inches, the equations behind will take into account wastage allocation for increasing general productivity/yields-per-block.

$250 USD in 7 days

5.0

(13 reviews)

4.3

@GdevDataSceince

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev

$500 USD in 7 days