Spreadsheet: 883903d1732659011-requesting-help-to-create-a-shipping-calculator-for-item-qtys-and-pallets-fit-container-container-loading-maximisation
Sheet: Sheet1

 | Container Loading Maximisation
 | Container Type |  | # Pallets | Accept 20ft container? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Pallet Count |  | Container Count
 | 40ft containter |  | 20
 | 20ft container |  | 10 | Yes
 |  |  |  |  |  |  |  | Round 1 |  |  |  | Round 2 |  |  |  | Round 3 |  |  |  | Round 4 |  |  |  | Round 5 |  |  |  | Round 6 |  |  |  | Round 7 |  |  |  | Round 8 |  |  |  | Round 9 |  |  |  | Round 10 |  |  |  | Round 11 |  |  |  | Round 12 |  |  |  | Round 13 |  |  |  | Round 14 |  |  |  | Round 15
 | Product | Qty per Pallet | [NAME] | # Pallets | Can Increase Qty? | Can Reduce Qty? | Rounding | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | % Diff | Adj Priority | Adj | Qty After Adj | Total Adj | [NAME] | Adj # Pallets | Adj Qty to Order | Increase /Reduce | % Increase /Reduce | Check
 | Product 1 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 2 | 96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 3 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 4 | 550 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 5 | 550 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 6 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 7 | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Product 8 | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | # pallets desired
 |  |  |  |  |  | To adjust Qty Up/(Down)
 | Requesting help to create a Shipping Calculator for Item QTY's and Pallets fit Container
 | https://www.excelforum.com/excel-general/1430751-requesting-help-to-create-a-shipping-calculator-for-item-qtys-and-pallets-fit-container.html