Spreadsheet: 859225d1707685259-clarification-table-indexing-array-issue-test-worksheet
Sheet: Order 1

Customer | AmeriQual |  |  |  |  | Customer Notes |  |  |  |  |  | Customer: |  |  |  | Requested Ship Date:
Cust Code |  |  | Delivery Address |  |  |  |  |  |  |  |  | PO#: |  |  |  | Within Lead Time:
PO# |  |  |  |  |  |  |  |  |  |  |  | SRF#: |  |  | Lead-Compliant Ship Date:
Lead Time |  |  |  |  |  |  |  |  |  |  |  | * Blank rows in this section are intentionally blank, as this form is auto-populated based on order entry in All Shipping. | Flagged |  | Adj Qty |  | On PO but Not Flagged |  | Adj Qty
Ship Via
Carrier
ORDER DETAILS
PO# |  | PO Date
SRF Order # |  | Requested Del
 |  | Requested LTL Ship |  | LTL Within Lead Time? |  |  | Lead-Compliant LTL Ship Date
 |  | Requested P/U Date |  |  | P/U Within Lead Time? |  |  |  | Lead-Compliant P/U Date |  |  | Notes
 |  | FTL Ship Date
 | Override Ship Date |  | Override Ship Via |  |  |  |  |  |  |  |  | Send Flagged [NAME]
Enter Order Quantities | Product # | Qty | Description |  |  |  | GTIN | Class | Class Freight Multiplier | Flagged
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
 | Order Notes
FREIGHT/SHIPPING DETAILS |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | DtD After P/U
1 Pallet:
2 Pallets:
3 Pallets: |  |  |  |  |  |  |  |  |  |  |  | Pallet Cube | CPFP | GCW | GIW | Freight Charge
Full Pallet Req? |  |  | Delivered Pricing
Pallet(s) Cube |  |  | Enter in Freight Tracking -> | Freight |  | Fuel |  | Total
Pallet Count |  |  | FOB Pricing | Freight |  | Fuel |  | SRF
Weight |  |  |  |  |  |  |  | Total
[NAME]
Ship Week
 | New Order Entry Process |  |  |  | Ship Prep Process
 | [NAME] |  |  |  | P/U appt scheduled by carrier & added to All Shipping & Outlook calendars
 | Enter order in FDS |  |  |  | Lots assigned from Pick Sheet
 | Flags reported to Sales@ |  |  |  | Driver paperwork generated
 | Rate Quote/BOL sent to carrier (CC: Shipping@) |  |  |  | [NAME]
 | Carrier confirmed |  |  |  | Print Invoice
 | Freight Tracking entered (unless a P/U) |  |  |  | Enter Invoice # in Freight Tracking (unless a P/U) |  |  |  |  |  |  |  |  | [NAME]
 | Added to All Shipping calendar |  |  |  | [NAME] to customer through FDS unless an SPS/EDI customer* |  |  |  |  |  |  |  |  | Pallet Weight
 | FDS prices match PO prices (usually minus [NAME]) |  |  |  | SPS/EDI: create shipment & print
 | Order confirmed to customer |  |  |  | SPS/EDI: create invoice & print
Product # | GTIN | Item Desc |  |  | PO Qty | GCW | GIW | CPFP | Class | TiHi
Sauces
31-1020 | 00812177011839 | ABC Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1030 | 00812177011778 | General [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1040 | 00812177011747 | Orange Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1050 | 00812177011723 | Sweet & Sour Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1061 | 00812177011815 | White Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1070 | 00812177011822 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1080 | 00812177011921 | Hunan II Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1090 | 00812177011884 | Pad Thai Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1180 | 00812177012508 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2000 | 00812177011877 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2001 | 00812177012416 | Savory Brown Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2010 | 00812177011754 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-1100 | 00812177011808 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-9045 | 00812177011860 | Red Pepper Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-9060 | 00812177011853 | Hot & Sour Solution |  |  |  | 25.5 |  | 77 | S | 11 x 7
35-9065 | 00812177011846 | Stir-Fry Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1525 | 00812177012027 | Jump General Tso Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1875 | 00812177011983 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1940 | 00812177011730 | [NAME] [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
59-0005 | 00812177011785 | RS: Teriyaki with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
59-2065 | 00812177011891 | RS: General Tso with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
Proteins
35-1928 | 00812177012249 | HT Chicken Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10
35-1938 | 00812177012256 | HT Pork Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10
35-1948 | 00812177012263 | HT Dark Chicken Chunk |  |  |  | 11.5 |  | 110 | P | 11 x 10
45-1950 | 00812177012546 | FC Sliced Beef |  |  |  | 11.5 |  | 110 | P | 11 x 10
45-1965 | 00812177012539 | FC [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10
45-2050 | 00812177012584 | [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10
60-1950 |  | 20 OZ/SRF FC-Beef Slice |  |  |  | 1.3125 |  | 800 | P | 800 x 1
60-1965 |  | 20 OZ/SRF FC-Chicken Slice |  |  |  | 1.3125 |  | 800 | P | 800 x 1
Kits
37-1070 | 00856460001305 | Teriyaki Beef |  |  |  | 17.75 |  | 70 | K | 7 x 10
37-1090 | 00856460001138 | Beef with Broccoli |  |  |  | 17.75 |  | 70 | K | 7 x 10
37-1180 | 00812177011129 | [NAME] |  |  |  | 17.25 |  | 70 | K | 7 x 10
37-1200 | 00812177012423 | Thai Chili Chicken |  |  |  | 10.5 |  | 110 | K | 11 x 10
37-1210 | 00812177012966 | Breakfast Fried Rice w/ Turkey |  |  |  | 16 |  | 110 | R | 11 x 10
68-5010 | 00812177012577 | Fried Rice |  |  |  | 16.5 |  | 110 | R | 11 x 10
68-5020 | 00812177012911 | White Rice |  |  |  | 16.5 |  | 110 | R | 11 x 10
78-0010 | 00812177012867 | Orange [NAME]P&S ONLY* |  |  | 1 | 9.5 |  | 110 | K | 11 x 10
78-0020 | 00812177012874 | General [NAME] veg* |  |  | 2 | 11 |  | 110 | K | 11 x 10
78-0030 | 00812177012881 | Beef with Broccoli *w/ veg* |  |  | 3 | 11 |  | 110 | K | 11 x 10
78-0050 | 00812177012898 | Veg [NAME] veg* |  |  | 4 | 14 |  | 110 | K | 11 x 10
78-0060 | 00812177012935 | [NAME] veg* |  |  | 5 | 11 |  | 110 | K | 11 x 10
[NAME].
30-8030 | 00043431003011 | Pre-Cooked Lo Mein Noodles |  |  |  | 32 |  | 60 | M | 15 x 4
33-7005 | 00812177012188 | 3 oz Pork & Shrimp Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10
33-7122 | 05265118261001 | 1 oz Spring Roll |  |  |  | 27 |  | 48 | SR | 12 x 4
33-7100 | 00812177012171 | 3 oz Southwestern Chicken Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10
34-1667 | 00812177012195 | 3 oz Vegetable Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10