Warehouse visualization

[greg.begin]

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?

 

[vletm]

Many things are possible,
but You missed to Upload Your sample file with sample data of this case.

 

[greg.begin]

I want it in a 3d graph so I can rotate it to see the variations, this is an example of what I want it to look like, but my description above is more complete layout

 

[Hui]

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?

 

[greg.begin]

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.

 

[greg.begin]

did my response answer your question or do did I miss it?
Is what I am asking possible?

 

[vletm]

The 1st version ...
You can see 'something' side by side ...
There is the spinner to change data.
It is possible to make those four 'missing' sides later...
Ideas?

 

[greg.begin]

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?

 

[vletm]

@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).