calculation for load optimizations
Does anyone know if there is a way to calculate optimized loads within filemaker? Given a master cartons dimensions and the maximum loadable dimensions on the target container (be it a pallet, a 20' ocean container, or a 53' trailer), I need to be able to calculate the maximum number of cartons that container can hold. My product is light, so I don't need to concern myself with maximum weights.
Also because my product is light, I don't have to worry about crushing, which means that my cartons can be loaded with any dimension vertical (there is no "this side up.")
I wrote a solution a while ago in Excel, but that solution was dependent on the Solver add-on. I'd love to have an in-FileMaker pro solution if there is one. Thanks in advance.