Need some help with calculating the following in Excel.
I have boxes in a format like 19 x 25cm, to fit in pallet.
How can I calculate the total number of boxes on pallet size 80 x 120cm with boxes of 19x25cm.?
I need the highest result between 80/19 or 80/25 and as well for the other side 120/19 or 120/25.
Is there a way to draw in Excel a rectangle to show the size of the pallet and then small rectangles for the boxes with the size of each object?
Thanks for your help. Kind Regards