Lukket

Warehouse 2D or 3D Excel Racking Layout

Hi,

Please read this carefully, automated responses will not be considered. When applying I need to know you understand what I'm looking for.

Looking for some one that can do the following for me in excel or another program in either 2D or 3D

Here are the following requirements

This project is based on Dynamic picking in a warehouse racking layout, so if you can understand what Dynamic picking is then this will make it easier for you.

1. Develop the warehouse racking plan layout. I have the current plan

2. Then show me based on the data I have the best way to layout my products in the warehouse racking based on volumes etc.

3. Then based on the layout of my products I then need to zone these to identify them based on an ABC analysis or another strategy

4. I would also like a heat map generated based on the ABC analysis showing where the products are located by zone

5. I would then need to show a total warehouse capacity graph or utilisation of spaces etc.

6. Then need a dashboard created to show a various list of trends etc from the data.

Objective

1. Develop the warehouse racking layout

2. Demonstrate via the racking layout the best way to relay my products in the racking

3. Demonstrate the products into zones via conditional formatting or heat maps etc.

4. Develop a dynamic dashboard based on information from the data.

The key to all this is the data will continuously be updated to review the information in the racking layout and the data spread sheet will remain constant and fixed with header information so you need to apply logic when developing this.

Probably macro's or some magic VB script.

If you have the skill set and understand the requirements I would like to hear from you.

Thanks

Færdigheder: AutoCAD, Forretnings Analyse, Excel, Software Udvikling, Visual Basic

Se mere: warehouse layout racking excel, heat map warehouse excel, vb dashboard, make spread sheet, current trends software development, automated logic, abc warehouse, 3d total, 3d via, 3d warehouse, warehouse, vb excel, software 3d, skill development , excel formatting, macro development excel, heat map excel, spread sheet formatting, excel sheet formatting, data trends excel, excel based dashboard, excel macro develop, dashboard layout, excel 2014 macro, picking sheet

Om arbejdsgiveren:
( 24 bedømmelser ) Craigieburn, Australia

Projekt-ID: #6014209

13 freelancere byder i gennemsnit $787 for dette job

priyal1997

Hi Glen Hope you are doing good Can you send me the latest version of this file.. I will think this differently and let you know within few hours whether I can do it, and send me my solution. If you are fine, will d Mere

$750 AUD in 10 dage
(108 bedømmelser)
6.2
topacademics

A proposal has not yet been provided

$750 AUD in 10 dage
(35 bedømmelser)
5.9
amitchaps

Hi, This is Amit from Illuminatus Softwares,India. We have worked extensively in autocad macros & executed multiple projects in autocad automation. We are comfortable with generating a drawing based on external Mere

$711 AUD in 8 dage
(8 bedømmelser)
5.6
finecodervw

Hi, I am well versed with both Excel and Visual Basic. I do not want to write a detail profile here as the objective is to get straight to the point. The requirement definitely needs discussion and if you are onl Mere

$600 AUD in 10 dage
(74 bedømmelser)
5.7
JonnaNueros121

A proposal has not yet been provided

$526 AUD in 10 dage
(10 bedømmelser)
4.4
binarycodersvw

Hi.I have read the description of your project and I am interested.My name is Andrei. I am a Visual Basic .NET programmer and website developer with 10 years experience. I know you hear things like these a lot but I ca Mere

$1974 AUD in 17 dage
(6 bedømmelser)
4.2
williammatheson

Hi Glen, I will develop this in Excel. I will do some background research beforehand to see what other companies are doing. Sounds like an engineering problem... right up my alley. Cheers, William

$722 AUD in 10 dage
(5 bedømmelser)
3.8
hdlong66

Hello, I've found your project very interesting and would like work on it. Please let me know more details about input data (maybe as the current plant, rack's dimensions, product's dimensions, the rule how to fit pro Mere

$750 AUD in 30 dage
(8 bedømmelser)
3.0
JonNxt

So this is the other project you talked about. It is very interesting, not sure if this can be done only with Excel though. I just re-installed my VB6 and I will try to analyze what it can be done, as soon as we'll f Mere

$700 AUD in 7 dage
(5 bedømmelser)
2.9
excelmacro

Hi, I have earlier created a similar tool as a part of a six sigma optimization project. To get the right solution for your warehouse we need a good communication.

$700 AUD in 20 dage
(3 bedømmelser)
2.2
daskswarup

I can do this work...................................................................................

$744 AUD in 30 dage
(0 bedømmelser)
0.0
jblsolution

hi ,i have best solution for.I will do your project in unity3d so we can export for all platform like web.iOS,android for all platform.i will give you demo first.No need to pay any advance.I have all resources in my co Mere

$515 AUD in 10 dage
(0 bedømmelser)
0.0
tekware2

Dear Sir Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. yes we have similar experience and can deliver u as u have mentioned in your requirements. we Mere

$555 AUD in 10 dage
(0 bedømmelser)
0.0
applnet

I am an expert in warehouse racking layout. I have many experiences in this fields. I can do it correctly. Best Regards

$555 AUD in 10 dage
(0 bedømmelser)
0.0
Swapnilspace

I am an Architect and 3d visualizer. I have been working since last Eight years. I have a young team of professionals and we work in all types of Architectural and Interior design, drawing, 3d modeling and max renderin Mere

$555 AUD in 6 dage
(0 bedømmelser)
0.0
sanskar2011

A proposal has not yet been provided

$750 AUD in 10 dage
(0 bedømmelser)
0.0