36C24C19Q0037-0005006.xlsm

Overview & Instructions

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 Editting' 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 Medical Surgical Prime Vendor (MSPV) Price Quote Sheet

PATIENT EXAM ROOM INSTRUMENTS & SUPPLIES (PEX)

Overview This workbook contains a quote sheet for suppliers to use to quote items under MSPV. Prospective Suppliers should quote medical/surgical supplies from their catalog appropriate to the VA recognized Product Category. This workbook also contains a detailed list of VA historically-used medical/surgical supplies from Calendar Year 2018 that suppliers can use for reference purposes to inform supply quotes.

The MSPV Supply procurement is organized into multiple Product Categories, which are all being solicited separately under Open Market solicitation. Suppliers shall only quote items under the relevant Product Category, as defined by VHA. Quote sheets with supplies quoted in the wrong category may be returned and recommended for submission in other Product Category solicitations or may not be evaluated.

Workbook tabs This quote sheet workbook contains 4 separate tabs:

Overview & Instructions PEX Historical Data - VA historical 12-month usage for MSPV medical/surgical supplies (from CY 2018) PEX Quoted Supplies - Quoted supplies for the MSPV program should be entered and priced here, both historical supplies and additional supplies relevant to the specified Product Category Data Field For Reference - Definition and examples of data fields to complete

PEX Historical Data This tab provides detailed information on VA usage of medical/surgical supplies from Calendar Year 2018. It should be used as a reference for specific supplies that the VA has previously purchased. The PEX Historical Data tab includes VA Spend for the entire Product Category across the 12-month period, as well as the potential usage (quantity of Unit of Measures (UOM) ordered) for each supply line item.

PEX Quoted Supplies – Enter Data on this tab Suppliers should add data, UOM measure information, and price quotes in this tab for each quoted item.

Supplier information shall be filled out completely at the top, ensuring business designation is accurately captured. Suppliers should enter each quoted item on a separate line. When quoting items listed on the Historical Data tab (reference), please copy and paste data (as values) from the Historical Data tab to the Quoted Supplies tab to ensure data integrity.

The first two columns ("Index" and "From Historical Data tab") are locked as they populate automatically based on user input in the other columns. Users cannot changes these values.

For each supply 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.

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 PEX 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.

Last Revision: July 26, 2019

PEX Historical Data

Patient Exam Room Instruments and Supplies includes a wide range of disposable and non-disposable items. This category should contain items that are meant to diagnose, treat or aid in diagnosis, treatment or self-care and allow for self-care. It should be classified as instruments or supplies. Non-surgical tools or devices designed to perform a specific function. Instruments and Supplies should be of mid- level range to sufficiently high quality in terms of: 1) Performance 2) Safety 3) Materials and design 4) Labelling and packaging. The quality of performance depends on the frequency of use for each item. It is not cost-effective to buy the most expensive because instruments are easily misplaced, or the cheapest because these are more likely to rust or fall apart. Items that should include but not limited to:

--a. Instruments- Penlight- disposable reusable illuminator with pocket clip, Vest, Lap belt, Jacket, Stretcher straps, Safety eye shield.-- --b. Supplies- Vaginal Speculum, Oral swabs, Paper table crepe, Emery Board, Enema bag set/kit, Hygiene items, Gait belt, glove (compression), Glove sleeve with gel, Hernia support belt, Hot/Cold packs, Irrigation kits, Lubed jelly package, Manicure sticks, Masks, Medication cups, Bandages, Admission packets, Bandages, Alcohol pad, Alcohol swab stick, anti-embolism compression stockings (ted hose), Cotton-tipped Applicators, Arm boards (covered), Arm sleeve/protector, Bedside Bag, paper, Baby Powder, Bed pans, Bed Liners, Blood pressure cuffs, Bowl, plastic, Bottle plastic lavette for perineal wash, Brace ankle/foot, Catheterization tray without catheter, Central line dressing kits, Chapstick, Chair pad alarm, Comb and hair brush (polyethylene), Compression gloves, wrist sleeves, Cups, Declogger tube enteral, Wood Depressor, Deodorant, Diapers, Reusable undergarments, Disposable dry wash cloths, disposable wet wash cloths, Pillow (therapeutic), Sitz Bath, Soap dish, Socks therapeutic, Specimen commode container, Stockinette, Suture removal kit, Emesis basins/bags, Tourniquet, Thermometers, , Wash basin, Urinals, Povidone Iodine packet 1 oz., Povidone Iodine Swab stick, Povidone Iodine prep 7.5% 10%, Razors, , Safety pins, Shampoo, Shaving gel and cream, , Tape measure, Water pitchers/cups/kits, Wash basins, Urinary drainage devices, Urinal holder.