Завершено

Automated Packing Tool

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.

Квалификация: Excel, Visual Basic

Показать больше autobag bags, automated packaging systems locations, airpouch express 3 parts, automated packaging systems, automated box packaging systems, autobag4me, automatic bagger and sealer, automated packaging systems careers, website automated test tool accessibility, automated forum posting tool, automated screenshot tool, comparison different automated tool, coldfusion automated testing tool, automated flash tool visual basicnet, automated yahoo group subscriber posting, automated php tool, total number group buying websites, know virtuemart shopper group, automated packing list, java automated build tool

О работодателе:
( 1 отзыв ) Salzburg, Austria

ID проекта: #18549149

Поручен:

paris2785

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 clea Больше

€100 EUR за 2 дней(-я)
(178 отзывов(-а))
7.0

17 фрилансеров(-а) в среднем готовы выполнить эту работу за €139

schoudhary1553

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 Больше

€250 EUR за 4 дней(-я)
(294 отзывов(-а))
7.7
SBITServices

Hello samatterbury, I have checked the attached file and i have some questions in "Packing Tool" sheet. Can we discuss in chat box. I have 5 years experience in Excel VBA programming and completed 400+ p Больше

€75 EUR за 3 дней(-я)
(389 отзывов(-а))
7.4
periyannas

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. Больше

€250 EUR за 5 дней(-я)
(81 отзывов(-а))
6.0
sloker18

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 request Больше

€150 EUR за 3 дней(-я)
(63 отзывов(-а))
5.3
KavTan

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 Expe Больше

€230 EUR за 5 дней(-я)
(39 отзывов(-а))
5.4
vsprybhanu

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 Больше

€230 EUR за 3 дней(-я)
(67 отзывов(-а))
5.3
alexanderrubtsov

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 a Больше

€80 EUR за 2 дней(-я)
(18 отзывов(-а))
4.5
Capitan0Trueno

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 advanc Больше

€70 EUR за 2 дней(-я)
(19 отзывов(-а))
4.2
Sercho56

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 Больше

€138 EUR за 2 дней(-я)
(9 отзывов(-а))
4.3
bhupendrayadav

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 don Больше

€55 EUR за 2 дней(-я)
(16 отзывов(-а))
4.0
nvchien94

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 за 1 день
(23 отзывов(-а))
3.8
sdroberts

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 Больше

€166 EUR за 5 дней(-я)
(5 отзывов(-а))
3.7
muralidaran84

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 за 3 дней(-я)
(4 отзывов(-а))
3.1
hsingla85

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. Больше

€166 EUR за 3 дней(-я)
(8 отзывов(-а))
3.2
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac Больше

€155 EUR за 3 дней(-я)
(6 отзывов(-а))
3.5
Salek76

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 за 3 дней(-я)
(0 отзывов(-а))
0.0