1. society
2. welfare
3. healthcare

To All VGM Fall Series Attendees:
Here is (via link) a large Excel file which includes the current master listing of ALL DMEPOS suppliers
with an active Medicare PTAN number. https://data.medicare.gov/data/supplier-directory
(Also, you may reference your power point for additional instructions.)
I will detail the contents of each column below, but, in a short version, the file allows you to view every
location (by NPI) of every company/entity in the U.S. that is eligible to bill Medicare for at least one (of
80) product categories. In addition, the file lists every competitive bid contract currently in effect per
each location/NPI, by product category.
This spreadsheet may be copied/edited and is easily manipulated via the Data/Sort function.
For example, you may wish to copy a certain state or region and obtain a listing of all suppliers in the
area by city for member prospecting, insurance, referrals, advocacy, and many other potential
reasons.
You can also sort these locations as to which suppliers offer certain products…for example CPAP.
There are 80 product categories in which the NSC recognizes and updates via the 855S format.
Many full line suppliers offer dozens of products. Some niche suppliers (think opticians who offer
cataract sunglasses) may only be in one or two categories. You will be able to sort these out by a tool I
reference below.
In the meantime, here is a key to the spreadsheet column…
The first 21 (A to X) identify the supplier by location/contact detail and to whether the supplier has
any competitive bid contracts. It also includes a column (X) as to whether the entity is a participating
Medicare supplier. See below.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Competitive Bid Service Area
Company Name
DBA Name
Address
Address 2
City
State
Zip
Zip Plus 4
Phone
Oxygen Supplies and Equipment
Mail-Order Diabetic Supplies
Enteral Nutrients, Equipment and Supplies
CPAP Devices, Respiratory Assist Devices, and Related Supplies and
Accessories
Hospital Beds and Related Accessories
Negative Pressure Wound Therapy Pumps and Related Supplies and
Accessories
Q
R
S
T
U
V
W
X
Walkers and Related Accessories
Support Surfaces (Group 2 mattresses and overlays)
Standard (Power & Manual) Wheelchairs, Scooters, and Related Accessories
External Infusion Pumps and Supplies
General Home Equipment and Related Supplies and Accessories
Respiratory Equipment and Related Supplies and Accessories
Standard Mobility Equipment and Related Accessories
Is Supplier Participating?
Beginning with Column K (this is Oxygen Supplies and Equipment) the data option is either NO or
YES. If NO this supplier has no competitive bid contract. If YES then the supplier (in this location) has
a competitive bid contract for that product category. Both Round 1 recompete and Round 2 product
categories follow in columns K through W. Remember there were differences in categories between
these two rounds. At column X the competitive bid data set ends and, as noted, column X is a YES or
NO as to whether the supplier is participating.
The next series of columns include all 80 product categories included within the 855S enrollment
data. If the supplier location is accredited/credentialed to bill Medicare for the category, the indication
is YES. If not NO.
Starting with Column Y and ending at Column DA the products are as follows:
Automatic External Defibrillators (AEDS)
Commodes, Urinals, & Bedpans
Continuous Passive Motion (CPM) Devices
Dynamic Splints
Blood Glucose Monitors & Supplies: Non-Mail Order
Blood Glucose Monitors & Supplies: Mail Order
Blood Glucose Monitors: Mail Order
Gastric Suction Pumps
Heat & Cold Applications
Hospital Beds: Electric
Hospital Beds: Total Electric & Pediatric
Hospital Beds: Manual
Hospital Beds: Manual & Pediatric
Infrared Heating Pad Systems
Infusion Pumps & Supplies: External Infusion
Infusion Pumps: Implantable & Uninterrupted
Infusion Pumps & Supplies: Insulin Infusion
Infusion Pumps & Supplies: Implanted Infusion
Negative Pressure Wound Therapy Pumps & Supplies
Neuromuscular Electrical Stimulators (NMES)
Osteogenesis Stimulators
Pneumatic Compression Devices
Speech Generating Devices
Support Surfaces: Pressure Reducing Beds, Mattresses, Overlays, & Pads
Support Surfaces (e.g. Air Fluidized bed)
Traction Equipment
Transcutaneous Electrical Nerve Stimulators (TENS) Units
Ultraviolet Light Devices
Home Dialysis Equipment & Supplies
Hemodialysis Equipment & Supplies
Canes & Crutches
Patient Lifts
Power Operated Vehicles (Scooters)
Seat Lift Mechanisms
Walkers
Wheelchairs & Accessories:Standard Manual
Wheelchairs & Accessories:Standard Manual (e.g. Pediatrics)
Wheelchairs & Accessories:Standard Power
Wheelchairs & Accessories:Standard Power (e.g. Pediatrics and custom cushions )
Wheelchairs & Accessories:Complex Rehabilitative Manual
Wheelchairs & Accessories:Complex Rehabilitative Power
Wheelchairs & Accessories:Complex Rehabilitative Power (e.g. Group 3, Group 4, Group
5)
Wheelchair Seating/Cushions
Wheelchair Seating/Cushions (e.g. skin protecting seat cushions)
Orthoses: Custom Fabricated
Orthoses: Prefabricated
Orthoses: Off-the-Shelf
Breast Prostheses & Accessories
Cochlear Implants
Facial Prostheses
Neurostimulators
Ocular Prostheses
Ostomy Supplies
Somatic Prostheses
Tracheostomy Supplies
Urological Supplies
Voice Prosthetics
Prosthetic Lenses: Conventional Eyeglasses
Prosthetic Lenses: Conventional Contact Lenses
Prosthetic Lenses: Prosthetic Cataract Lenses
Enteral Nutrients, Equipment, & Supplies
Enteral Nutrients & Supplies for Special Metabolic Needs and Pediatrics
Parenteral Nutrients, Equipment & Supplies
Limb Prostheses
Eye Prostheses
CPAP, RADs, & Related Supplies & Accessories
CPAP and RADs Supplies (e.g. combination masks)
High Frequency Chest Wall Oscillation (HFCWO) Devices
Invasive Mechanical Ventilation
Intermittent Positive Pressure Breathing (IPPB) Devices
Intrapulmonary Percussive Ventilation Devices
Mechanical In-Exsufflation Devices
Nebulizer Equipment & Supplies
Nebulizer Equipment: Ultrasonic and Controlled Dose
Oxygen Equipment & Supplies
Respiratory Suction Pumps
Ventilators, Accessories & Supplies
Surgical Dressings
Diabetic Shoes & Inserts: Prefabricated
Diabetic Shoes & Inserts: Custom Fabricated
Now, I recognize that much data may be difficult to comprehend.
What you could do is select just a state or region, and copy it into another blank spreadsheet. Then,
using the find and replace function, highlight from Column Y and all through the 80 other product
columns and “find” all the “NO” cells. Replace it with a blank (insert nothing). Now there are many
cells with nothing in them and will be ignored. Do the same thing with the YES “find” but replace it
with a 1 (one).
Then highlight all of the product category columns, and, in the next one to the right of all of them, use
the “count” function. I will show you an example below, but it is merely @count(row number cell
number..row number cell number) and copied all the way down. This will give you how many
categories this supplier location is eligible to bill. Then you can resort the entire list of suppliers from
top to bottom by number of categories. Those suppliers “on top” (with the most categories) are likely
your competitors or HMEs of interest. The ones at the bottom (with just a few) are likely opticians or
niche suppliers.
As an example, I copied all of the Iowa DMEPOS suppliers from the master spreadsheet. (I would
attach it but it is 30 MB!!). I then followed the instructions above and eliminated from any “counting”
all of the Iowa locations with NO in the product columns by a Find and Replace. I did the same thing
with YES, and then used the @count function to array them from top to bottom. (I inserted a new
column next to the company name – B – and titled it “Yes’s – meaning that is the number of YES
results I sorted.)
Here is a sample of what I received (more than 34 “YES” only)
Competitive Bid Service
Area
YES's
49
AVERA HOME MEDICAL EQUIPMENT
49
47
FLOYD VALLEY HOME MEDICAL EQUIPMENT
AVERA HOME MEDICAL EQUIPMENT OF SIOUX
CENTER
AVERA HOME MEDICAL EQUIPMENT OF SPENCER HOSPITAL
LLC
DBA Name
AVERA HOME MEDICAL
EQUIPMENT
AVERA HOME MEDICAL EQUIPMENT OF
FLO
AVERA HOME MEDICAL EQUIPMENT OF
SIO
AVERA HOME MEDICAL EQUIPMENT OF
SPE
46
UNITYPOINT AT HOME
UNITYPOINT AT HOME
46
46
UNITYPOINT AT HOME
UNITYPOINT AT HOME
UNITYPOINT AT HOME
UNITYPOINT AT HOME
49
Company Name
A
6
A
1
N
3
S
7
A
1
C
1
A
1
Omaha-Council Bluffs, NE-IA
45
APRIA HEALTHCARE LLC
APRIA HEALTHCARE INC
45
UNITYPOINT AT HOME
UNITYPOINT AT HOME
Omaha-Council Bluffs, NE-IA
45
APRIA HEALTHCARE LLC
APRIA HEALTHCARE LLC
Omaha-Council Bluffs, NE-IA
45
APRIA HEALTHCARE LLC
APRIA HEALTHCARE INC
45
UNITYPOINT AT HOME
UNITYPOINT AT HOME
44
PSI HEALTH CARE INC
43
CHI NATIONAL HOME CARE
PSI HEALTH CARE
MERCY RESPIRATORY CARE AND
MEDICAL
43
APRIA HEALTHCARE LLC
APRIA HEALTHCARE INC
43
APRIA HEALTHCARE LLC
APRIA HEALTHCARE
43
APRIA HEALTHCARE LLC
43
CHI NATIONAL HOME CARE
APRIA HEALTHCARE INC
MERCY RESPIRATORY CARE AND
MEDICAL
43
DUMED, INC.
DUMED HOME HEALTH CARE
43
APRIA HEALTHCARE LLC
APRIA HEALTHCARE LLC
43
APRIA HEALTHCARE LLC
APRIA HEALTHCARE INC
43
APRIA HEALTHCARE LLC
41
41
HERITAGE MEDICAL EQUIPMENT AND SUPPLIES
VALUE CARE INC
APRIA HEALTHCARE LLC
HERITAGE MEDICAL EQUIPMENT &
SUPP
HOMECARE MEDICAL SUPPLY
Omaha-Council Bluffs, NE-IA
Northern-Chicago Metro CBA
A
6
S
1
1
1
A
2
S
2
B
5
A
1
2
7
T
3
S
1
A
6
H
3
C
4
2
1
R
2
A
6
A
3
41
EXCEL MEDICAL OF FORT DODGE INC
41
P B R INC
EXCEL MEDICAL
MED EQIP HOME CARE PHARMACY
3
41
HAMILTON MEDICAL EQUIPMENT SERVICE INC
HAMILTON MEDICAL EQUIPMENT
41
EXCEL MEDICAL OF MARSHALLTOWN INC
EXCEL MEDICAL
41
HAMILTON MEDICAL EQUIPMENT SERVICE INC
HOMECARE HELPING HAND
41
P B R INC
41
HAMILTON MEDICAL EQUIPMENT SERVICE INC
41
HERITAGE MEDICAL EQUIPMENT AND SUPPLIES
MED-EQUIP
HILL ROUSE HOME MEDICAL
EQUIPMENT
HERITAGE MEDICAL EQUIPMENT &
SUPPLI
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
40
LINCARE INC
LINCARE INC
39
39
UNITYPOINT AT HOME
AMERICAN HOMEPATIENT, INC.
UNITYPOINT AT HOME
AMERICAN HOMEPATIENT
S
1
A
1
A
1
R
5
S
7
S
1
S
3
A
1
A
2
S
2
S
4
S
5
N
8
A
2
B
4
D
1
S
3
Omaha-Council Bluffs, NE-IA
39
KEOKUK AREA MEDICAL EQUIPMENT & SUPPLY, INC.
KEOKUK AREA MEDICAL EQUIPMENT
SUPPL
39
AMERICAN HOMEPATIENT, INC.
AMERICAN HOMEPATIENT
39
AMERICAN HOMEPATIENT, INC.
AMERICAN HOMEPATIENT
39
LINCARE INC
LINCARE INC
38
AHP-MHR HOME CARE, LLP
AHP-MHR HOMECARE
38
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY
38
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY EAST
38
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY
38
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY
38
HAMMER INCORPORATED
HAMMER MED SUPPLY
38
HAMMER INCORPORATED
HAMMER INCORPORATED
38
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY
37
C R PHARMACY SERVICE INC
37
CHI NATIONAL HOME CARE
CAREPRO HOME MEDICAL
ALEGENT CREIGHTON HEALTH AT HOME
ME
37
HAMMER INCORPORATED
ALEGENT HEALTH BERGAN MERCY HEALTH
SYSTEM
SANFORD HOME MEDICAL EQUIPMENT, INC
HAMMER MEDICAL SUPPLY
ALEGENT HEALTH AT HOME MEDICAL
EQUI
SANFORD HOME MEDICAL EQUIPMENT
37
37
S
4
S
1
W
5
A
6
A
4
S
9
A
1
A
2
S
1
E
1
E
6
A
8
R
4
S
4
S
6
S
4
S
2
INC
Omaha-Council Bluffs, NE-IA
36
NUDAK VENTURES LLC
NUCARA IV SERVICES
36
NUDAK VENTURES LLC
NUCARA PHARMACY #16
36
COMMUNITY MEDICAL SUPPLY, INC.
COMMUNITY MEDICAL SUPPLY INC
36
AMERICAN HOMEPATIENT, INC.
36
COVENANT MEDICAL CENTER INC
AMERICAN HOMEPATIENT
COVENANT HOME MEDICAL
SERVICES
35
C R PHARMACY SERVICE INC
CAREPRO HOME MEDICAL
35
WILLIAM BURKE LTD
MAIN AT LOCUST PHARMACY
35
UNITYPOINT AT HOME
UNITYPOINT AT HOME
35
COMMUNITY MEDICAL SUPPLY, INC.
COMMUNITY MEDICAL SUPPLY INC
34
HAMMER INCORPORATED
HAMMER MEDICAL SUPPLY
34
MERCY HEALTH SERVICES-IOWA, CORP
MERCY HOME CARE DUBUQUE
34
KOHLLS PHARMACY & HOMECARE INC
34
CHI NATIONAL HOME CARE
KOHLL'S PHARMACY & HOMECARE
ALEGENT CREIGHTON HEALTH AT HOME
ME
33
AMERICAN HOMEPATIENT, INC.
AMERICAN HOMEPATIENT
W
1
S
1
S
5
S
2
A
4
D
4
A
1
S
8
R
2
D
1
S
2
D
4
S
4
S
9
S
What I did not copy and paste is all of the product category columns that each supplier location is able
to bill. But it is easy to do and see once the sorting is completed.
Some of you will not want to do all of the sorting steps. That’s fine – you can still visualize the
product categories (and competitive bid contracts by location) without any data manipulation.
And you can call me for help.
Hope you find this helpful!