Spreadsheet: 95302d1294922184-modify-sumproduct-and-sumif-formulas-help_123
Sheet: Summary

 |  |  |  |  |  |  | Supplier
 | OpCo | Business Unit | Location | Category | Sub-Category |  | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 | (should be dynamic in formatting and formulas with a maximum of 100 suppliers)
 | ESG | Heil | Ft. Payne | Fittings | Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct) | 10% (30%)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | 37° Flare J533b | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Tube Assemblies | 37° Flare J533b | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Tube Assemblies | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | O-Ring Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | NPT | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Tube Assemblies | NPT | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | NPT | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | 37° Flare J533b | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | Flat Face O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | O-Ring Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | O-Ring Code 61 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | [NAME] | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Vernon, AL | Fittings | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Yerington, NV | Fittings | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Vernon, AL | Fittings | O-Ring Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Fittings | O-Ring Code 61 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Fittings | 24° Cone | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Fittings | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Tube Assemblies | 24° Cone | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | [NAME] | 37° Flare J533b | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Tube Assemblies | 24 Cone | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Fittings | Code 61 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | [NAME] | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | [NAME] | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Tube Assemblies | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | #20 o-ring male x #24 MJIC male | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | [NAME] | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | Straight Thread w/ O=Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Fittings | Tube - Compression | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG-A | China | [NAME] | JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | [NAME] | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | [NAME] | JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | [NAME] | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | NPT | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | Push-In | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | Straight Thread to 37° Flare | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | 3/8" to 1/4" | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | [NAME] | 37° Flare | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | VSG NSA (Rotary) | [NAME], IN | Fittings | 37° | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | Ooltewah, TN | Fittings | Flat Face | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | [NAME], NC | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | Davenport, IA | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | [NAME], NC | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | [NAME], NC | Fittings | Quick Disconnect | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | CustomWorks | Dubuque, IA | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Genesis | Superior, WI | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Genesis | Superior, WI | Fittings | Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Genesis | Superior, WI | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Jewell | Portland, OR | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Jewell | Portland, OR | Fittings | Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | JRB | Akron, OH | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | JRB | Akron, OH | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | [NAME] | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | [NAME] | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | Quick Disconnect | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | [NAME] | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | Code 62 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | [NAME] | 37° Flare | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Fittings | 37° Flare | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | JRB | Akron, OH | Fittings | O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | JRB | Akron, OH | Fittings | Code 61 | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Fittings | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Fittings | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Fittings | Quick Disconnect | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Fittings | Quick Disconnect (Connect Under Pressure) | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | [NAME] | 37° JIC | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Fittings | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | [NAME] | Pipe | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | [NAME] | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | Hoses | Straight Thread w/ O-Ring | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | [NAME] | O-Ring Face Seal | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | [NAME] | 37° Flare | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Gear | Gear | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | Vane | Vane | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Vernon, AL | Gear | Gear | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Yerington, NV | Gear | Gear | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Vernon, AL | Piston | Piston | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Marathon | Yerington, NV | Vane | Vane | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Vane | Double Pump | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Vane | Single | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Piston | Variable Displacement | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | GPI | Tulsa, OK | Gear | Gear | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Gear | PTO | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Piston | Axial | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Jewell | Portland, OR | Gear | Commercial P330 Series | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI |  | [NAME] | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI |  | Hand pump | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | In-Tank | In-Tank | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Environmental | Fort Payne, AL | In-line | In-line | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Return | Return | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | ESG | Heil Europe | Hillend, Scotland | Pressure | Pressure | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | Return | Return | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | TWG | TWI | Tulsa, OK | In-line | In-line | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | Blitz | Braunlingen, DE | Suction | Suction | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | VSG | Blitz | Braunlingen, DE | In-line | In-line | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Sweepster-Harley | Dexter, MI | Return | Return | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)
 | Paladin | Bradco | Delhi, IA | In-line | In-line | Savings (Number of Parts)
 |  |  |  |  |  | Total Spend (Number of Parts)
 |  |  |  |  |  | Savings Pct on Quoted Items (Coverage Pct)