Spreadsheet: 860800d1708799102-indexing-issue-pull-historical-data-from-table-and-return-last-five-instances-test-workbook
Sheet: Order 1

Customer | US FOODS California (4C) |  | Cust Code |  |  | Customer Notes |  |  |  |  |  | Customer: |  |  |  | Requested Ship Date:
PO# |  |  | Delivery Address |  |  |  |  |  |  |  |  | PO#: |  |  |  | Within Lead Time:
SRF O# |  |  |  |  |  |  |  |  |  |  |  | SRF#: |  | Lead-Compliant Ship Date:
Conf'd Ship Date |  |  |  |  |  |  |  |  |  |  |  | * Blank rows in this section are intentionally blank, as this form is auto-populated based on order entry in All Shipping. | Flagged |  |  |  | On PO but not flagged
Ship Via
Carrier
ORDER DETAILS
PO Date |  | [NAME]
Requested Del |  | Cust Lead
 |  | 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
 |  | Requested FTL Ship Date |  |  | FTL Within Lead Time? |  |  |  | Lead-Compliant FTL Ship Date
 | Product # | Qty | Description |  |  |  | GTIN | Class | Freight Multiplier | Flagged |  | [NAME]:
Item 1 |  |  |  |  |  |  |  |  |  |  |  | Send Flagged [NAME]
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 |  |  |  |  |  |  |  |  |  |  |  | Most Recent Historical Shipments
 |  |  |  |  |  |  |  |  |  |  |  | SRF# | Carrier | Ship Date | # Pallets |  | Cust Pd | Ttl Freight | Dif
1 Pallet:
2 Pallets:
3 Pallets:
Full Pallet Req? |  |  | Delivered Pricing
Pallet(s) Cube |  |  | Enter in Freight Tracking -> | Freight |  | Fuel |  | Total
Pallet Count |  |  | Freight-Added Pricing | Freight |  | Fuel |  | SRF
Weight |  |  |  |  |  |  |  | Total
[NAME]
Ship Week
 | Order Entry Process |  |  |  | Ship Prep Process
 | [NAME] from email |  |  |  | P/U appt scheduled by carrier & added to All Shipping & Outlook calendars
 | Enter order here first & then in FDS |  |  |  | Lots assigned from Pick Sheet, verifying any discrepancies
 | Report flags to Sales@, wait for confirmation email & print |  |  |  | Driver paperwork generated & given to [NAME]
 | Make order adjustments from email on this worksheet in All Shipping |  |  |  | [NAME]
 | Rate Quote/BOL sent to carrier (CC: Shipping@), print Rate Quote |  |  |  | Print Invoice in FDS
 | Enter in Freight Tracking (unless a P/U) |  |  |  | Enter Invoice # in Freight Tracking (unless a P/U)
 | Add to All Shipping calendar & wait for carrier confirmation |  |  |  | [NAME] to customer through FDS unless an SPS/EDI customer*
 | Print Carrier Confirmation once received |  |  |  |  | SPS/EDI: create shipment & print (ensure quantities match) |  |  |  |  |  | [NAME] |  | DtD After P/U
 | FDS prices match PO prices (usually minus [NAME]) |  |  |  |  | SPS/EDI: create invoice & print (ensure Totals match) |  |  |  |  |  | Del State |  | FTL DTD
 | Confirm order to customer by replying to PO email unless SPS/EDI*
 |  | SPS/EDI: Acknowledge order & print
 | Place order packet with red sticky flag in designated area |  |  |  |  |  |  |  |  |  |  | Pallet Cube | CPFP | GCW | GIW | Freight Charge
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 |  |  |  | [NAME]
31-2000 | 00812177011877 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  | Pallet Weight
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* |  |  |  | 9.5 |  | 110 | K | 11 x 10
78-0020 | 00812177012874 | General [NAME] veg* |  |  |  | 11 |  | 110 | K | 11 x 10
78-0030 | 00812177012881 | Beef with Broccoli *w/ veg* |  |  |  | 11 |  | 110 | K | 11 x 10
78-0050 | 00812177012898 | Veg [NAME] veg* |  |  |  | 14 |  | 110 | K | 11 x 10
78-0060 | 00812177012935 | [NAME] veg* |  |  |  | 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