Container Stack Visualiser
Budget: $30 – $250 AUD
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.
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.