ATTACHMENT 2 - Glove Quote Spreadsheet.xlsx

Overview & Instructions

Gloves Quote Sheet Instructions

Overview Suppliers will use this workbook to quote gloves and provide item details in response to this solicitation.

Workbook tabs This quote sheet workbook contains 3 separate tabs:

Overview & Instructions Gloves Quoted Supplies- Quoted Gloves for the VA and item details shall be entered and priced here Data Field For Reference - Definition and examples of data fields to complete

Glove Quoted Supplies – Enter Data on this tab Supplier information shall be filled out completely at the top, ensuring business designation is accurately captured.

Suppliers should add glove details and price quotes in this tab for each quoted glove. Suppliers should enter each quoted glove on a separate line (i.e. each glove type and size should be on its own line). Please include the glove size in the description field.

The first two columns ("Index" and "For Internal Validation Purposes (set to 'No' by default)") are locked as they populate automatically based on user input in the other columns. Users cannot change these values.

For each glove quoted, manually complete all the GREEN fields; the copy paste data function is limited by the quote sheet’s validation macros. BLUE fields are optional, but are highly encouraged for completion if the information is known.

For the "OEM UOM Description" and "Smallest UOM Available for Facility Purchase" fields, select an option from the drop down list.

This quote sheet has built in validation that will alert the user when they enter data in the wrong format, e.g. filling in a field as text when it should be a date or number. The RED fields indicate missing information required for submission; RED text will change to GREEN when corrected.

Blank and NULL cells are counted as errors and are summarized at the top of the Gloves Quoted Supplies sheet. Quote sheets with errors will not be accepted. Do not submit the files until there are no errors identified by the sheet.

Key Steps to being able to edit the Quoted Supplies worksheet

1) Ensure to save and work from a local version of the file

2) Click on 'Enable Editing' if the warning pops-up

3) Click on 'Enable Content' to enable the built in validation macros of the workbook. The validation macros will assist you in filling out the Quoted Supplies tab

Gloves Quoted Supplies

http://www.google.com/ Data Fields For Reference Data Fields

Example are shown below, but are not limited to:

BD BUNDLE

BG BAG

BX BOX

CA CARTRIDGE

CO CONTAINER

CS CASE

CT CARTON

DZ DOZEN

EA EACH

PD PAD

PG PACKAGE

PR PAIR

PZ PACKET

RO ROLL

FDA is establishing a unique device identification system to adequately identify medical devices through their distribution and use. When fully implemented, the label of most devices will include a unique device identifier (UDI) in human- and machine-readable form. Device labelers must also submit certain information about each device to FDA’s Global Unique Device Identification Database (GUDID).

http://www.unspsc.org/

The UNSPSC Segment for Medical Equipment and Accessories and Supplies begins with "42." String Supplier 42142600 https://www.google.com/ Validation Lists