Spreadsheet: 860816d1708822838-indexing-issue-pull-historical-data-from-table-and-return-last-five-instances-test-workbook-dj
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: |  |  |  |  |  |  |  |  |  |  |  |  | FFE | 2023-09-14 00:00:00 | 2 |  |  | 634.1700000000001 | 78.12999999999988
2 Pallets: |  |  |  |  |  |  |  |  |  |  |  | 42849 | FFE | 2023-09-21 00:00:00 | 2 |  | 712.3 | 608.41 | 103.89
3 Pallets: |  |  |  |  |  |  |  |  |  |  |  | 42928 | FFE | 2023-10-20 00:00:00 | 2 |  | 719.97 | 555.41 | 164.5600000000001
 |  |  |  |  |  |  |  |  |  |  |  | 43024 | FFE | 2023-11-02 00:00:00 | 3 |  | 928.23 | 787.01 | 141.22
Full Pallet Req? |  |  | Delivered Pricing |  |  |  |  |  |  |  |  | 43071 | FFE | 2023-11-16 00:00:00 | 2 |  | 709.74 | 544.08 | 165.66
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 |  |  |  |  |  |  |  |  |  |  |  |  |  | SYSCO - Seattle
 | [NAME] from email |  |  |  | P/U appt scheduled by carrier & added to All Shipping & Outlook calendars |  |  |  |  |  |  |  |  |  |  |  |  |  | Feesers
 | Enter order here first & then in FDS |  |  |  | Lots assigned from Pick Sheet, verifying any discrepancies |  |  |  |  |  |  |  |  |  |  |  |  |  | US Foods - Raleigh/Zebulon
 | Report flags to Sales@, wait for confirmation email & print |  |  |  | Driver paperwork generated & given to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | SYSCO - Maryland
 | Make order adjustments from email on this worksheet in All Shipping |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Driscoll Foods
 | Rate Quote/BOL sent to carrier (CC: Shipping@), print Rate Quote |  |  |  | Print Invoice in FDS |  |  |  |  |  |  |  |  |  |  |  |  |  | US Foods - Oklahoma
 | Enter in Freight Tracking (unless a P/U) |  |  |  | Enter Invoice # in Freight Tracking (unless a P/U) |  |  |  |  |  |  |  |  |  |  |  |  |  | SYSCO - Las Vegas
 | Add to All Shipping calendar & wait for carrier confirmation |  |  |  | [NAME] to customer through FDS unless an SPS/EDI customer* |  |  |  |  |  |  |  |  |  |  |  |  |  | SYSCO - Riverside
 | Print Carrier Confirmation once received |  |  |  |  | SPS/EDI: create shipment & print (ensure quantities match) |  |  |  |  |  | [NAME] |  | DtD After P/U |  |  |  |  | PFS - Metro NY
 | FDS prices match PO prices (usually minus [NAME]) |  |  |  |  | SPS/EDI: create invoice & print (ensure Totals match) |  |  |  |  |  | Del State |  | FTL DTD |  |  |  |  | SYSCO - Cleveland
 | Confirm order to customer by replying to PO email unless SPS/EDI* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C&S - West Seneca
 |  | SPS/EDI: Acknowledge order & print |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weis Markets
 | Place order packet with red sticky flag in designated area |  |  |  |  |  |  |  |  |  |  | Pallet Cube | CPFP | GCW | GIW | Freight Charge |  |  | JAMAC Frozen Food Corp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wornick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Associated Food Stores
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan State University
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N Kansas City School Dist
Product # | GTIN | Item Desc |  |  | PO Qty | GCW | GIW | CPFP | Class | TiHi |  |  |  |  |  |  |  |  | Penn State University
Sauces |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shamrock - Aurora
31-1020 | 00812177011839 | ABC Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | Desert Gold Food Co.
31-1030 | 00812177011778 | General [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US Foods - Utah
31-1040 | 00812177011747 | Orange Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | Performance Arizona
31-1050 | 00812177011723 | Sweet & Sour Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | Food City
31-1061 | 00812177011815 | White Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | C&S - Aberdeen
31-1070 | 00812177011822 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US Foods - Chicago
31-1080 | 00812177011921 | Hunan II Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US Foods - Manassas
31-1090 | 00812177011884 | Pad Thai Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US Foods - Swedesboro
31-1180 | 00812177012508 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  | [NAME] |  |  |  |  | US Foods - Seattle
31-2000 | 00812177011877 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  | Pallet Weight |  |  |  |  | US Foods - Metro NY
31-2001 | 00812177012416 | Savory Brown Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US Foods - California
31-2010 | 00812177011754 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | Dr. [NAME]
34-1100 | 00812177011808 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | JFC - Chicago
34-9045 | 00812177011860 | Red Pepper Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | JFC - Houston
34-9060 | 00812177011853 | Hot & Sour Solution |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | Seattle Fish
35-9065 | 00812177011846 | Stir-Fry Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | JFC - Dallas
36-1525 | 00812177012027 | Jump General Tso Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | JFC - Atlanta
36-1875 | 00812177011983 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US FOODS - Raleigh
36-1940 | 00812177011730 | [NAME] [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | C&S Aberdeen
59-0005 | 00812177011785 | RS: Teriyaki with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | US FOODS - Oklahoma City
59-2065 | 00812177011891 | RS: General Tso with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7 |  |  |  |  |  |  |  |  | JFC - Boston
Proteins |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JFC - New York
35-1928 | 00812177012249 | HT Chicken Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | [NAME]
35-1938 | 00812177012256 | HT Pork Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | Dr Fish
35-1948 | 00812177012263 | HT Dark Chicken Chunk |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | Five Star Gourmet Foods
45-1950 | 00812177012546 | FC Sliced Beef |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | Bally Plus
45-1965 | 00812177012539 | FC [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | Driscoll
45-2050 | 00812177012584 | [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10 |  |  |  |  |  |  |  |  | JAMAC [NAME]
60-1950 |  | 20 OZ/SRF FC-Beef Slice |  |  |  | 1.3125 |  | 800 | P | 800 x 1 |  |  |  |  |  |  |  |  | Desert Gold Food Company
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