• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Warehouse visualization

G

greg.begin

Member
I am trying to create a visualization of a warehouse showing areas of high volume that I want to color code, Red for high volume through blue for low volume, but I want to represent this in a 3d format so I can see a each location in its respective rack in its respective row with about 10 bin rows. basically looking like a rubics cube with an aisle between every two bin rows, just like a warehouse and each height is distinguished, about 5 high, 10 deep, and 20 bin rows paired in twos with an aisle, does any one know if this is possible?
 
Many things are possible,
but You missed to Upload Your sample file with sample data of this case.
 
Do you want the 3rd Column values to be represented by the Height or is each level the same height with the color of each cell representing the values?
 
Each level is the same height but stacked on each other to represent a racking system, and the color would be to represent the values based on a scale, maybe 3 tiered conditional formatting. the first numbers represent the bin row numbers, the Alpha character represent the height levels, A being the floor and E being near the ceiling, and the last number represents the next rack in the bin row. If possible, I would like a way to represent rack heights by a value because some areas of the warehouse actually have G levels, but are the same over all height of 30ish feet. Thanks for assisting.
 
Vletm,
Thank you for your response, unfortunately its not exactly what I was looking for, but i like what you were able to do, it does provide an alternate way to look at it.
Attached is the "result" I was hoping to get to, but i would like each level represented, not as an entire row like I have in my example; but like a rubics cube with aisles, that is why I am not sure it is possible what I am asking for, but the size of the cubes should always be the same, the color varies based on the demand (i.e. the values presented) I want it to be more cubic in its representation, in essence, look like a warehouse like the example I uploaded, then I want to be able to rotate it to get a better views, all at once so I can analyze patterns from its entirety. what do you think?
 

Attachments

@greg.begin
Hmm ... You should use same values as in the 1st example.
Or
do it manually (125 cubes).
Anyway, I tested to do it floor by floor (Sheet3).
As Sheet2, colors presents cube's value of 1/3 steps
and heights presents values (You can see values in Sheet2).
It could rotate 90degrees steps (not yet).
 

Attachments

You must log in or register to reply here.
Back
Top