aperocket
-
Content Count
2 -
Joined
-
Last visited
-
help knapsack problem solution solver
aperocket replied to aperocket's topic in Calculation Engine (Define Fields)
Hello, Thanks for the ideas. I'm still checking the possibilities for mathematical solution before applying it to filemaker. -
help knapsack problem solution solver
aperocket posted a topic in Calculation Engine (Define Fields)
Is this doable through simple script or field calculation? I don't know where to start but I'm hoping to exact solution about this. Here my example. I have a stock of 70", 100", 2pcs of 150" and 12pcs of 240". Also i have orders that needs 39", 88", 91", 106", 55", 55", 72", 72", 72", 144", 144", 144", 32", 66", 66", 66", 66", 144", 144", 144", 50", 50", 81", 81", 132", 132", 132", 168", 196". In the real world my goal is to minimize the wastage. So it will end up similar to this results. #1 - 70" = 66", with 4" wastage #2 - 100" = 66", 32" with 2" waste