Find Jobs
Hire Freelancers

Container Stack Visualiser

$30-250 AUD

Completed
Posted 11 months ago

$30-250 AUD

Paid on delivery
Container Stack Visualiser I am looking for a freelancer to create a 2D visualisation of a container stack. The container stack is created by the Container Terminal Operator and available to us in a csv format. It is important that we take the containers in a certain order, and a 2d visualisation of this stack would help in this process. We currently manually recreate the csv in an excel table to visualise the stack. Each csv could contain as few as 2 and as many as 100 containers, although it is usually less than 20. We want to be able to either copy/paste or import this csv into a solution that can then present us with the visualisation. The containers within the csv could be spread over multiple stacks, that is not all the containers will be in the same stack, so the solution would need the ability to create multiple visualised stacks from the one set of data. The stack locations are presented in a set of numbers detailed the stack number and then location. The location is set out as XX YY.AA.B; XX YY is the stack number and detail the stack the containers are in. As mentioned, within the csv there could be multiple stacks. A change in either, or both, of these numbers indicate a new stack. The actual stack number isn't that relevant and should only be used for labelling purposes where there are multiple stacks. The AA.B shows where in the stack the container is and is the part that needs to be visualised. AA is the "depth" of the container within the stack, essentially the column that the container is in. B is how high in the stack container is, essentially the row the container is in. I've attached a sample of the stack layout, showing the values for XX YY.AA.B and their position in the stack. This is a rough sample of how our manual output looks at the moment. While a stack may contain many containers, we may only have a few in that stack. Using the attached example, we may only have 3 containers on the stack (eg, 33 49.01.1, 33 49.02.4, 33 49.04.3), the rest of the stack will need to be "drawn" but left blank where there is no data. In positions that do have a container, the container number and size (available form other cells in the imported csv) will need to be entered into that position. A stack may only have one contained on it that we have data for. The project could be a standalone application, where the csv is imported and the stacks created. The project could be created in excel, where the csv is copy/pasted into it and then the stack is calculated from that. The final output should be in a printable format.
Project ID: 36822960

About the project

6 proposals
Remote project
Active 11 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
$0 AUD in 2 days
5.0 (2 reviews)
2.3
2.3
6 freelancers are bidding on average $158 AUD for this job
User Avatar
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.
$100 AUD in 1 day
5.0 (4 reviews)
4.5
4.5
User Avatar
Hi and good greetings. I've read the description and checked the attached image, I understood the requirements and I know I can fulfill and satisfy you with the final work result, as designing and coding such GUI is part of my experience. My suggestion is to create a dedicated software "app" rather than using Excel, the csv files can be imported directly to the app (even as simple and quick import as drag-and-drop), then the app immediately map it into appropriate 2D representation that is printable at high quality. But if you prefer, I can make the app to be just a tool to produce Excel files corresponding to the csv files as input (or simply having the app do both, display the 2D visualization and produce corresponding Excel files). I'm good experienced in all of that, good at communicating for work and clarification, and ready to have the nice opportunity with you. Sincerely, Abdulrahman (New freelancer at Freelancer.com).
$150 AUD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Canning Vale, Australia
5.0
5
Payment method verified
Member since Sep 20, 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.