Find Jobs
Hire Freelancers

Automated Packing Tool

€30-250 EUR

Completed
Posted about 5 years ago

€30-250 EUR

Paid on delivery
This project is to create a packing list tool with 3 outputs. • The tool view which shows a matrix of what product is in what box • A packing list that shows what needs to be packed where is a list • Packing labels. This takes the list above and separates the boxes and adds titles to the cells. Therefore, these labels can be cut and added to a pdf. An example of the packing can be seen in excel sheet. The process of the tool will work as follows: USER 1. FRONT SHEET: User enters ‘FILL AMOUNT’ how full they want the boxes. The boxes should not be filled with any more volume or weight then the amount entered in the cell. E.g. if there is a 30L vol box, and the ‘FILL AMOUNT’ is 80%, the maximum volume in the box should be 24L. 2. FRONT SHEET: User enters the ‘MAX BOX WEIGHT’ and ‘BOX DIMENSIONS’ which the “FILL AMOUNT’ is applied against 3. FRONT SHEET: User enters the ‘COLUMN TO ORDER LIST BY:” which defines the column that the data will be sorted by. 4. PACKING TOOL: User copies the ‘COPY FROM SAP’. A group of data that gives all the information needed to calculate the packing. 5. FRONT SHEET: User clicks on the ‘GET PACKING’ button MACRO: 1. Macro sorts the data in PACKING TOOL TAB by the column specified by the user in the FRONT SHEET ‘COLUMN TO ORDER LIST BY’. This should always be order in alphabetical order or lowest value first 2. Macro takes the first box and fills it with the products in the first row of the COPY OF SAP (example in cell Y5) (Note, the capacity of the box is the MAX WEIGHTxFILL AMOUNT or BOX VOLUMExFILL AMOUNT, whichever is hit first). 3. When the first box is full and nothing else can added from the line below, Macro moves onto box 2. 4. This process is continued until all the products are allocated to boxes 5. Macro enters the total number of boxes into the ‘BOXES REQUIRED’ on the FRONT SHEET. 6. Macro takes the packing matrix it has created in the ‘PACKING TOOL’ tab, and copies it into a column layout in the ‘PACKING LIST’ tab. The necessary attributes are shown the attached example. 7. The Macro does the same in the ‘PACKING LABELS” tab, however, for this it separates the boxes and copies the ‘TITLES’ (that are specified at the top of the tab) above each boxes data. USER: 1. User enters the ‘AMAZON BOX CODE’ on the FRONT SHEET which in turn changes the ‘AMAZON BOX NUMBER’ on the ‘PACKING LIST’ & ‘PACKING LABELS’ tab. Any questions, please let me know.
Project ID: 18549149

About the project

17 proposals
Remote project
Active 5 yrs 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
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have a macro in Excel that will follow the steps you mention there. Everything's clear and I don't need something clarified. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 270 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you 100€ and can deliver within a couple of days (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
€100 EUR in 2 days
4.9 (178 reviews)
7.0
7.0
17 freelancers are bidding on average €139 EUR for this job
User Avatar
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. 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 and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Excel, Visual Basic. Please ping me for more discussion.
€250 EUR in 4 days
4.9 (294 reviews)
7.7
7.7
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Checked the requirement at a high level, and it looks achievable. Willing to take up your project. Thank you, Regards.
€250 EUR in 5 days
4.9 (81 reviews)
6.0
6.0
User Avatar
I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I get what you need and I can write the packing tool marco as requested You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to chat further and work on your project.
€150 EUR in 3 days
5.0 (63 reviews)
5.3
5.3
User Avatar
Hi there, I have read your project brief and understand that you require and Packing and Labeling solution for your business. I am the right candidate for your task because I am a professional freelancer having Expert level MS Excel skills (please see my portfolio to check the projects I have done in past) and can complete your task effectively and efficiently in a timely manner. Let's discuss it further over a chat. Thanks.
€230 EUR in 5 days
4.8 (39 reviews)
5.4
5.4
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached excel file. You have described 7 tasks for macro. I can design macros for these 7 tasks and create final results. I have excellent knowledge and experience of Manipulating Data in Multiple Sheets, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
€230 EUR in 3 days
4.8 (67 reviews)
5.3
5.3
User Avatar
Dear Sir or Madam, As I got from the task description and the example workbook, the packing algorithm shall be simplified with no account for how the goods are actually fit into a box (only total weight and volume are accounted). In this case it is relatively simple for a VBA code. I have some questions about how the data shall be handled, which we may discuss if you are interested. The project will take 1-2 days to complete. Faithfully yours, Alexander Rubtsov.
€80 EUR in 2 days
5.0 (18 reviews)
4.5
4.5
User Avatar
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
€70 EUR in 2 days
4.9 (19 reviews)
4.2
4.2
User Avatar
This is a similar concept to a project I completed recently for a Party Beverage Company, who needed to calculate the quantities of all the ingredients and drinks required for a given function and produce picking lists and order lists for their staff. I will easily be able to write the Macro in VBA that will follow you logic and deliver the required output. There should be no reason that I couldn’t have a first-draft to you within a few hours of awarding the project, with the ability to adjust it as required to meet your needs exactly. Please reach out via PM if you have any questions.
€138 EUR in 2 days
5.0 (9 reviews)
4.3
4.3
User Avatar
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. You can get your work done here with highest quality at lowest price. I accept only once you are fully satisfied with the work done. Looking forward to work with you
€55 EUR in 2 days
4.6 (16 reviews)
4.0
4.0
User Avatar
Hello there, I am an Excel coder and I read very carefully your description about macro you want to create. Please contact me and we can start. I have 2 weekend and will spend it for this project. Thank you.
€50 EUR in 1 day
5.0 (23 reviews)
3.8
3.8
User Avatar
Hello My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I’m sure my macro experience will be valuable to your packing tool. I hope to hear back from you soon. Kind regards Steve
€166 EUR in 5 days
5.0 (5 reviews)
3.7
3.7
User Avatar
I am having Microsoft certified C# developer, having 10 years of Exp. in C# software development. Please let me if you are interested. Thanks
€100 EUR in 3 days
5.0 (4 reviews)
3.1
3.1
User Avatar
Hi, I have done my MBA from one of the top 3 institutes of India and have been freelancing from last 8 years. I have done numerous jobs as data analyst, MS Excel Expert, VBA Champion and google spreadsheet projects. I can assure you the quality of the work and timed delivery. I am available to start immediately to start working on the same. Looking forward for your message. -Harsh
€166 EUR in 3 days
5.0 (8 reviews)
3.2
3.2
User Avatar
Hi, I have a lot of experience with Excel automation and VBA. I would be happy to work on this project and deliver your requirements. Regards, Sherif
€100 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRIA
Salzburg, Austria
4.6
1
Payment method verified
Member since Oct 4, 2018

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.