topic Re: Show the maximum capacity of the rack in Dashboard in FlexSim Forum

Show the maximum capacity of the rack in Dashboard

GerardoRodea — Mon, 03 Jul 2023 11:54:01 GMT

[ FlexSim 23.1.3 ]

Hello!

I am trying to show the maximum capacity of the racks in the dashboard, how is that possible? This is to know the overall usage of my racks.

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Mon, 03 Jul 2023 15:12:28 GMT

Hi,

I have created an example model using a statistics collector that calculates the percentage of empty and occupied slots based on the total number of slots of the rack. With that data collected, you can choose any base chart you want to illustrate the results. I hope it helps!

23.1 Statistics Warehouse Usage.fsm

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Tue, 04 Jul 2023 11:38:16 GMT

Thanks a lot for you kind support. Is there a possibility to do it without coding?

When I copy pasted the code to my model, It is just showing the values of my initial stock I created using a list but showing how it changes along the time. How to fix this?

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Wed, 05 Jul 2023 06:08:22 GMT

You need to make sure that the event that updates the statistics collector is "On Slot Entry" of your rack, and that the Row Value is current.

If it still doesn't work as desired, you can attach your model here and I'll look it up for you!

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 09:10:52 GMT

thanks Paula for the follow up. I was running with different values for the source and even when the rack is NOT full in the 3D model, the statistics collector is showing 100% full. Could you please verify?

I am also wondering if its possible to do it without coding.

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Wed, 05 Jul 2023 09:24:13 GMT

There's no predefined graphs to show the value that you're looking for.

In order to identify why it isn't working properly, I'll need your model or at least a simplified copy of it. Could you attach the file on a comment here?

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 09:35:37 GMT

Hello Paula,

If you see, in the handover stations and quarantine for example, the value of used should be really low but it is showing overall the same values for all the racks.

Thanks

Example.fsm

Re: Show the maximum capacity of the rack in Dashboard

moehlmann_fe — Wed, 05 Jul 2023 12:06:01 GMT

Paula's statistics collector only measures the content at the slot level. As soon as an item enters the slot, the slot is 'full' regardless of how much space the item actually takes up.

If all items have the same size, you can manually calculate the maximum capacity of a rack and write that number to a label. This label is then used by the statistics collector to calculate the fill level.

Alternatively, you go by volume, where you compare the total volume of items in the rack with the total available volume.

Both approaches are demonstrated in the attached model.

231-statistics-warehouse-usage-fm.fsm

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 12:45:04 GMT

Thanks a lot for both approaches. In Paula's approach in the new file: 231 statistics warehouse usage, If I am understanding properly, once it's full, it should show 100%, but only when it's full shows only 50%.

For the volume part is do understand the logic. In my model, I would like to understand the same metric but by type of box used in the rack (I have 9 different type) all using the same size so it is fine using the slots approach.Example.fsm

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 12:49:25 GMT

I've replied as a new answer, sorry :)

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Wed, 05 Jul 2023 13:16:12 GMT

The reason why the statistics collector is showing nearly the same values for all the racks is because the code on the example model calculates the % considering all the slots in the storage system. To calculate this number having multiple racks, you need to add labels to the query, so that it only considers the slots you want.

I attach a new model with two racks to clarify what I mean.

23.1 Statistics Warehouse Usage.fsm

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 13:24:36 GMT

Hello Paula, thanks for the reply.

It is not showing the real capacity of the racks, as you can see in the screenshot, once I full the rack, the table is showing 100% but in the 3d model is not 100% full.

Thanks a lot!

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Wed, 05 Jul 2023 13:31:41 GMT

As @Felix Möhlmann commented, the code I used detects the slot as full the moment an item enters, regardless of its capacity. If you want to calculate it considering that multiple items can be stored in one slot, I recommend you take a look at the example model he attached.

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 13:42:04 GMT

Thanks Paula. In Felix's solution is having a similar issue: once I run the model, it not showing 100% of used capacity, rather only showing 50% of the capacity used. I already changed the dimensions of the rack as possibly it is increasing the slot but not being able to use, with the same results. No matter which changes I do, it is always showing 50%.felix.PNG

Re: Show the maximum capacity of the rack in Dashboard

Paula_LG — Wed, 05 Jul 2023 13:51:54 GMT

This is the result I get from running Felix's model without changing anything.

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 14:10:23 GMT

You are totally right! Thanks!! I'll investigate how to build it for my model.

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Wed, 05 Jul 2023 15:00:03 GMT

@Felix Möhlmann When I try to copy the values into my model, it is not showing any value, is there anything I should take care to make it work?

values.PNG

Re: Show the maximum capacity of the rack in Dashboard

moehlmann_fe — Wed, 05 Jul 2023 15:58:14 GMT

Did you add the MaxCapacity label to the rack(s)?

Re: Show the maximum capacity of the rack in Dashboard

GerardoRodea — Thu, 06 Jul 2023 08:57:55 GMT

I was missing that. Thanks! Could you then share to me the hint on how to calculate the max capacity? I see it's just an input number, but how was it calculated?

Re: Show the maximum capacity of the rack in Dashboard

moehlmann_fe — Thu, 06 Jul 2023 09:35:52 GMT

For the example model I just counted the capacity per slot and multiplied it with the number of slots in the rack.

If you have many differing slot sizes you can run the code below (for example in the srcipt console) to get the capacity of the given rack for the given item size.

Object rack = Model.find("Rack1");
double itemX = 0.61;
double itemY = 0.61;
double itemZ = 0.3;
int capacity = 0;
Storage.Object stoObjRack = rack;
for(int b = 1; b <= stoObjRack.bays.length; b++)
{
    Storage.Bay bay = stoObjRack.bays;
    for(int l = 1; l <= bay.levels.length; l++)
    {
        Storage.Level level = bay.levels;
        for(int s = 1; s <= level.slots.length; s++)
        {
            Storage.Slot slot = level.slots;
            capacity += Math.floor(slot.size.x/itemX)*Math.floor(slot.size.y/itemY)*Math.floor(slot.size.z/itemZ);
        }
    }
}
return capacity;