cms10110.asp_data_collection_validation_macro_user_guide_032520

Manufacturer Submission of Average Sales Price (ASP) Data for Medicare Part B Drugs and Biological and Supporting Regulations (CMS-10110)

cms10110.asp_data_collection_validation_macro_user_guide_032520

OMB: 0938-0921

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 0938-0921 can be found here:

2024-05-17 - Revision of a currently approved collection

Document [pdf]

Download: pdf | pdf

Centers for Medicare & Medicaid Services
Center for Medicare (CM)
Hospital and Ambulatory Policy Group
7500 Security Blvd
Baltimore, MD 21244-1850

Average Sale Price (ASP) Data Collection
Template/Data Validation Macro

User Manual
Version: 1.6
Last Modified: March 25, 2020

PRA Disclosure Statement
According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number. The valid OMB
control number for this information collection is 0938-XXXX (Expires XX/XX/XXXX). The time required to complete this information collection is estimated to average [Insert Time
(hours or minutes)] per response, including the time to review instructions, search existing data resources, gather the data needed, and complete and review the information collection. If
you have comments concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to: CMS, 7500 Security Boulevard, Attn: PRA Reports Clearance
Officer, Mail Stop C4-26-05, Baltimore, Maryland 21244-1850. ****CMS Disclosure**** Please do not send applications, claims, payments, medical records or any documents
containing sensitive information to the PRA Reports Clearance Office. Please note that any correspondence not pertaining to the information collection burden approved
under the associated OMB control number listed on this form will not be reviewed, forwarded, or retained.

TABLE OF CONTENTS
1

OVERVIEW ............................................................................................................................ 1
Explanatory Messaging .......................................................................................................................... 1
Secondary Validation Check .................................................................................................................. 1

NAVIGATING THE TEMPLATE ....................................................................................... 2

FIELD DEFINITIONS ........................................................................................................... 5

TEMPLATE REQUIREMENTS ........................................................................................ 17

ACRONYMS ......................................................................................................................... 17

User Manual Version 1.6 / September 27, 2012

LIST OF FIGURES
Figure 1: Example of validation macro error message ................................................................... 1
Figure 2: Screenshot of Run ASP Validation Button ..................................................................... 2
Figure 3: Screenshot of Security Warning section.......................................................................... 2
Figure 4: Screenshot of detailed security alert macro ..................................................................... 3
Figure 5: Screenshot of validation macro error message ................................................................ 3
Figure 6: Screenshot of highlighted cell with error ........................................................................ 3
Figure 7: Screenshot of the Run ASP Validation Button ............................................................... 4

User Manual Version 1.6 / September 27, 2012

iii

1 OVERVIEW
The Average Sales Price Data Form Addendum A Excel template (available at:
http://www.cms.gov/McrPartBDrugAvgSalesPrice/) provides a framework for drug manufacturers to submit
their ASP data for current Medicare Part B drugs to CMS. Such data consists of financial, sales, and descriptive
data elements.
The Addendum A Excel template has been enhanced to include a
validation macro which will ensure that the Center for Medicare (CM)/
Hospital and Ambulatory Policy Group (HAPG) receives complete and
correctly formatted data from each manufacturer. The validation macro
performs a quality check on the formatting of manufacturers’ ASP
information.

Explanatory Messaging

The ASP Macro does not edit for the
validity of data or of calculations,
only for whether the contents of the
field are correctly formatted. Users
are responsible for ensuring that
the data entered is technically
correct.

Each cell within the data entry area of the template has been
programmed to validate data formatting upon entry. If an invalid format is entered, an error message will be
displayed, and the cell will remain highlighted until the error is corrected. Additionally, if a required field is left
blank, the macro will provide a message to the user upon exiting that required field (refer to Figure 1 below for
sample error message).

Figure 1: Example of validation macro error message

Secondary Validation Check
The user initiates a secondary validation check by clicking the [Run ASP Validation] button (refer to Figure 2)
located above the first row of the field descriptions. This prompts the macro to scan all cells that contain data.
Note: The secondary validation check can be run at any time during the data entry process. It can be run more
than once.
The secondary check provides an alternate method of data validation in MS Excel. Data that are copied and
pasted into the template will override many of the individual cell validations. Therefore, the validation macro
should be run after pasting data into the template.
Page 1 of 17

Figure 2: Screenshot of Run ASP Validation Button

2 NAVIGATING THE TEMPLATE




Open the Addendum A template in Microsoft Excel.
The first time the template is accessed, the user must accept the digital signature to utilize the validation
macro.
To accept the digital signature, look for the security warning at the top of the page (see Figure 3).

Figure 3: Screenshot of Security Warning section
If a user’s system security
policies do not allow the use of
macros, even if from trusted
sources, notify CMS in writing
as a part of your submission’s
cover letter or “Assumptions”
document. All submissions
must still conform to the data

 Select the Options button to the right of the security
warning message. When the next window appears, select the
“Trust all documents from this publisher” option and select the
“OK” button at the bottom of the screen (see Figure 4). This
will enable the macro and enable the spreadsheet to accept data
entries. Selection of the “Enable this content” option is also
acceptable, but this selection must be made each time the
spreadsheet is open.
Note: Once you’ve accepted the option to “Trust all documents
from this publisher”, you will not have to perform this step
again.

“Field Definitions” described in
Section 3.

Page 2 of 17

Figure 4: Screenshot of detailed security alert macro


Enter data into each cell. If the user enters an invalid format or leaves a required field or field
combination blank, an error message will be displayed (see Figure 5) and the cell(s) with the incorrect
format will be highlighted until the user corrects the error(s) (see Figure 6).

Figure 5: Screenshot of validation macro error message

Figure 6: Screenshot of highlighted cell with error


Upon completion of data entry, select the [Run ASP Validation] button located above the first row of
the field descriptions to determine if data pass the preliminary validation checks (see Figure 7).

Page 3 of 17

Figure 7: Screenshot of the Run ASP Validation Button



The user shall correct any highlighted errors before proceeding. Upon completion of all corrections, the
user shall run the full validation macro again to confirm there are no additional errors.
Once the entered data are error free, the user shall submit the template to CMS per the submission
instructions at: http://www.cms.gov/McrPartBDrugAvgSalesPrice/.

Page 4 of 17

3 FIELD DEFINITIONS
The validation macro identifies the values listed below as acceptable for each field. All required fields shall
contain appropriately formatted data. If no data are present in a required field, the cell with the missing data
will be highlighted and an error message will appear. The user must enter properly formatted data before
additional data entry can be completed. Fields identified as not required may be left blank.
Depending on the type of product, manufacturers must submit ASP data according to one of the following
sets of field definitions.

1. Table 1 contains the field definitions for drugs and biologicals reported on the NDC
or CMS-specified unit level.
Most ASP reporting is done at the NDC level where the ASP corresponds to the amount of drug represented
by that NDC. However, for a limited number of products, reporting at the NDC unit level is not appropriate
and must be done at a CMS-specified unit level. A list of such drug products is maintained on the CMS
website at: http://www.cms.gov/McrPartBDrugAvgSalesPrice/. For these drugs and biologicals,
manufacturers will still submit ASP sales data for an NDC, but will do so on an ASP unit level specified in
this list.

Table 1: Field Definitions for Drugs and Biologicals
Field Name
Field Definition
Valid Values
Manufacturer's Name
11-Digit National Drug Code
(NDC1)

The reporting
manufacturer’s name.
The NDC1 is the first 5
digits of the 11 digit
National Drug Code that
identifies the labeler.
The 11 digit NDC
consists of the NDC1,
NDC2, and NDC3,
which identifies the
labeler, product, and
package size.

11-Digit National Drug Code
(NDC2)

The NDC2 is the sixth
through the ninth digits
of the 11 digit National
Drug Code that identifies
the product.
The 11 digit NDC

Free form field. Alpha and
numeric values accepted.
NDC1 values should be
formatted as a 5 digit
number. Use a preceding
zero(s) as needed (ex:
labeler code 1234 shall be
reported as 01234).

Required
Field
Yes

Yes, if
Alternate ID
has NOT
been entered

NDC2 values should be
formatted as a 4 digit
number.
Use a preceding zero as
needed (ex: NDC2 123 shall
be reported as 0123).

Yes, if
Alternate ID
has NOT
Page 5 of 17

Field Name

Field Definition

Valid Values

been entered

consists of the NDC1,
NDC2, and NDC3,
which identify the
labeler, product, and
package size.
11-Digit National Drug Code
(NDC3)

The NDC3 is the last 2
digits of the 11 digit
National Drug Code that
identifies the package
size.
The 11 digit NDC
consists of the NDC1,
NDC2, and NDC3,
which identify the
labeler, product, and
package size.

NDC3 values should be
formatted as a 2 digit
number.
Use a preceding zero as
needed (ex: NDC3 1 shall be
reported as 01).

Alternate ID

Numeric or
alphanumeric alternate
identifier (ex: an NHRIC
or UPC number) used
when an 11 digit NDC is
not available.

An alphanumeric alternate
ID is 23 characters or less.

Manufacturer's Average Sales
Price

ASP for a corresponding
ASP unit rounded to 3 or
more decimal places.

Any positive or negative
numbers including zero.
Value must include at least
three decimal places. Do
not include dollar sign ($).
If no ASP, enter “0.000”.

The number of ASP units Any positive or negative
sold.
numbers including zero.
Value must include at least
three decimal places. If no
units sold, enter “0.000”.
Any positive or negative
Wholesale Acquisition Cost (WAC) The WAC for a
numbers including zero.
corresponding ASP unit
Value must include at least
in effect on the last day
three decimal places. Do
of the reporting period.
not include dollar sign ($).
If no WAC available, enter
WAC is defined in
“0.000”.
Section 1847A(c)(6)(B)

Number of ASP Units

Required
Field

Yes, if
Alternate ID
has NOT
been entered

Yes, if
NDC1,
NDC2,
NDC3 have
NOT been
entered
Yes

Yes

Page 6 of 17

Field Name

Field Definition

Valid Values

Required
Field

as “the manufacturer’s
list price for the drug or
biological to wholesalers
or direct purchasers in
the United States, not
including prompt pay or
other discounts, rebates
or reductions in price, for
the most recent month
for which the
information is available,
as reported in wholesale
price guides or other
publications of drug or
biological pricing data.”
CMS further clarified, in
70 FR 70221, that
manufacturers must
report WAC for all
single source drugs and
biologicals (including
new drugs) each
reporting period.
Manufacturers must
report the WAC in effect
on the last day of the
reporting period.
Name of Drug or Biological

The trade or brand name
of the product or the
active ingredient name.

This a free form field
limited to 100 alphanumeric
characters.

Yes

Strength of the Product

The dosage strength of
one item (e.g.: 250 mg
tablet, 20 mg/ml
solution, 1 IU).

This a free form field
limited to 500 alphanumeric
characters.

Yes

Volume Per Item

The amount in one item
This a free form field
(ex: 10 ml in one vial, or limited to 12 alphanumeric
500 tablets in one bottle). characters. Enter “1” for
certain forms of drugs (e.g.
powders) when “Strength of
the Product” indicates the
amount of the product per
item.
The number of items in
Limited to 10 numeric
the 11-digit NDC (ex: if digits.

Yes

Number of Items Per NDC

Yes
Page 7 of 17

Field Name

Field Definition

Valid Values

Required
Field

an NDC packaged as a
box contains 4 vials, the
number of items per
NDC is 4).
Expiration Date of Final Lot Sold

The expiration date of
the final lot sold must be
reported to CMS once at
the end of utilization of
the NDC or when there
are no sales for three
consecutive quarters.
For ASP purposes, “at
the end of utilization”
means the manufacturer
will not make sales of
that NDC to any
purchaser.

Value should be in the date
format (MM/DD/YYYY).

Date of First Sale

Report for NDCs first
sold on or after
04/01/2006. Report at
least once and no later
than with the first ASP
report.

Value should be in the date
format (MM/DD/YYYY).

Yes

Number of CAP Units Excluded

Data must be numeric and
Beginning with the
3Q2006 reporting period, must include at least three
decimal places.
report the number of
whole or fractional units
administered to a
beneficiary by a Part B
Drug Competitive
Acquisition Program
participating physician
excluded from the ASP
calculation.

FDA Application Number

The application number
assigned by the Food and
Drug Administration
(FDA).

Yes

Page 8 of 17

Field Name

FDA Application Supplement
Number

Additional FDA Application
Number #1

Additional FDA Application
Supplement Number #1

Additional FDA Application
Number #2

Field Definition

Valid Values

report 6 digits. Do not use
dashes or spaces.
The application
This field is limited to 4
supplement number
characters. Use the format
assigned by the Food and XXXX for the application
Drug Administration
supplement number.
(FDA).
The application number
assigned by the Food and
Drug Administration
(FDA).

If the product has more than
one FDA Application
Number, enter an additional
application number here.

This field is limited to 6 or 7
characters. Data may
include a mixture of alpha
numeric and numeric values
(ex: A123456) or just
numeric values (ex:
123456). For entries with
only numeric values, use
leading zeros if necessary to
report 6 digits. Do not use
dashes or spaces.
The application
This field is limited to 4
characters. Use the format
supplement number
assigned by the Food and XXXX for the supplemental
application number.
Drug Administration
(FDA).
The application number
assigned by the Food and
Drug Administration
(FDA).

If the product has more than
one FDA Application
Number, enter an additional
application number here.

Required
Field
No

Field Name

Field Definition

Valid Values

Additional FDA Application
Supplement Number #2

The application
supplement number
assigned by the Food and
Drug Administration
(FDA).

This field is limited to 4
characters. Use the format
XXXX for the supplemental
application number.

FDA Final Pre-Marketing
Approval Date

This is the original date
that the FDA granted
approval for the drug
(NDA), biological
(BLA), or pre-marketing
application (PMA).

Value should be in the date
format (MM/DD/YYYY).

Yes

The type of FDA
approval for the product.

Choose a value from the
drop down menu (ANDA,
NDA, NDA-505b2, 510K,
BLA, BLA 351k, PMA,
Human Tissue, Vaccine,
Other).

FDA Approval Type

Required
Field

If there is no approval date,
baseline date should be set
to 01/01/1965.
Yes

If Other, specify the type in
the column ‘Description of
FDA Approval Type.’
Description of FDA Approval Type If Other was specified in
the column ‘FDA
Approval Type,’ please
specify the type.

Free form field limited to
255 alphanumeric
characters.

Yes, if FDA
Approval
Type is
“Other”.

2. Table 2 contains the field definitions for dermal grafting products.
Some dermal grafting products are not assigned an NDC. Instead, manufacturers identify them using
product codes, which can be catalog numbers, Universal Product Codes (UPCs), or other unique identifiers.
If an NDC is not available, the UPC or other unique identifier must be entered in the field “Alternate ID”.
Manufacturers may not convert a UPC or other alternative identifier to an NDC format by adding zeros or
removing numbers. Additionally, where the strength of a dermal grafting product must be described in units
of area, manufacturers must report in units of square centimeters. Dermal grafting products that are sold in
customized or irregularly shaped sheets must be quantified and reported using square centimeters. Other
units of measure such as “square inches”, “each”, ”sheet”, etc are not acceptable. Dermal grafting products

Page 10 of 17

that are sold in powder, foam, or liquid form must be quantified and reported in metric measures such as
grams, milligrams, or milliliters.

Table 2: Field Definitions for Dermal Grafting Products
Field Name
Field Definition
Valid Values
Manufacturer's Name

The reporting
manufacturer’s name.

Free form field. Alpha and
numeric values accepted.

11-Digit National Drug Code
(NDC1)

The NDC1 is the first 5
digits of the 11 digit
National Drug Code that
identifies the labeler.

NDC1 values should be
formatted as a 5 digit
number. Use a preceding
zero(s) as needed (ex:
labeler code 1234 shall be
reported as 01234).

The 11 digit NDC
consists of the NDC1,
NDC2, and NDC3,
which identifies the
labeler, product, and
package size.
11-Digit National Drug Code
(NDC2)

The NDC2 is the sixth
through the ninth digits
of the 11 digit National
Drug Code that identifies
the product.
The 11 digit NDC
consists of the NDC1,
NDC2, and NDC3,
which identify the
labeler, product, and
package size.

11-Digit National Drug Code
(NDC3)

Required
Field
Yes

Yes, if
Alternate ID
has NOT
been entered.

NDC2 values should be
formatted as a 4 digit
number.
Use a preceding zero as
needed (ex: NDC2 123 shall
be reported as 0123).

Yes, if
Alternate ID
has NOT
been entered.

NDC3 values should be
formatted as a 2 digit
number.
Use a preceding zero as
needed (ex: NDC3 1 shall be
reported as 01).

Yes, if
Alternate ID
has NOT
been entered

Page 11 of 17

Field Name

Field Definition

Valid Values

Alternate ID

Numeric or
alphanumeric alternate
identifier (ex: an NHRIC
number or UPC) used
when an 11 digit NDC is
not available.

An alphanumeric alternate
ID is 23 characters or less.

Manufacturer's Average Sales
Price

ASP rounded to 3 or
more decimal places.

Any positive or negative
numbers including zero.
Value must include at least
three decimal places. Do
not include dollar sign ($).
If no ASP, enter “0.000”.

Report the ASP per
package, as identified by
the NDC or alternate ID
(ex: for an NDC or
Alternate ID that
represents a box of five 2
cm x 3cm grafts, report
the ASP per box of five).
Number of ASP Units

Report the number of
packages sold (ex: for an
NDC or Alternate ID that
represents a box of five 2
cm x 3cm grafts, report
the number of boxes
sold).

Wholesale Acquisition Cost (WAC) The WAC in effect on
the last day of the
reporting period.
Report the WAC per
package.
WAC is defined in
Section 1847A(c)(6)(B)
as “the manufacturer’s
list price for the drug or
biological to wholesalers
or direct purchasers in
the United States, not
including prompt pay or
other discounts, rebates
or reductions in price, for
the most recent month
for which the
information is available,
as reported in wholesale

Required
Field
Yes, if
NDC1,
NDC2,
NDC3 have
NOT been
entered.
Yes

Any positive or negative
numbers including zero.
Value must include at least
three decimal places. If no
units sold, enter “0.000”.

Yes

Any positive or negative
numbers including zero.
Value must include at least
three decimal places. Do
not include dollar sign ($).
If no WAC available, enter
“0.000”.

Yes

Page 12 of 17

Field Name

Field Definition

Valid Values

Required
Field

price guides or other
publications of drug or
biological pricing data.”
CMS further clarified, in
70 FR 70221, that
manufacturers must
report WAC for all
single source drugs and
biologicals (including
new drugs) each
reporting period.
Manufacturers must
report the WAC in effect
on the last day of the
reporting period.
Name of Drug or Biological

The trade or brand name
of the product or the
active ingredient name.

This a free form field
limited to 100 alphanumeric
characters.

Yes

Strength of the Product

For products sold in
sheets: the total square
centimeters in one item
(ex: a 6cm x 8cm item is
48 sq cm).

This a free form field
limited to 500 alphanumeric
characters.

Yes

Volume Per Item

Use this field for dermal
grafting products that are
reported in units of
volume, for example
liquids. Report the
volume amount in one
item, include the metric
unit of measurement,
such as cc or ml. Enter
“1” for powders and
sheets.

This a free form field
limited to 12 alphanumeric
characters. Enter “1” for
powders and sheets.

Yes

Number of Items Per NDC

Limited to 10 numeric
The number of items in
digits.
the 11-digit NDC or
Alternative ID (ex: for an
NDC or Alternate ID that
has 5 grafts in a package,
the number of items per
NDC is 5).

Yes

Page 13 of 17

Field Name

Field Definition

Valid Values

Expiration Date of Final Lot Sold

The expiration date of
the final lot sold must be
reported to CMS once at
the end of utilization of
the NDC or Alternate ID
when there are no sales
for three consecutive
quarters. For ASP
purposes, “at the end of
utilization” means the
manufacturer will not
make sales of that NDC
or Alternate ID to any
purchaser.

Value should be in the date
format (MM/DD/YYYY).

Date of First Sale

Report for
NDCs/Alternate IDs first
sold on or after
04/01/2006. Report at
least once and no later
than with the first ASP
report.

Value should be in the date
format (MM/DD/YYYY).

Yes

Number of CAP Units Excluded

FDA Application Number

The application number
assigned by the Food and
Drug Administration
(FDA).

FDA Application Supplement

The application

Required
Field

Yes

No
Page 14 of 17

Field Name

Field Definition

Number

supplement number
characters. Use the format
assigned by the Food and XXXX for the application
Drug Administration
supplement number.
(FDA).

Additional FDA Application
Number #1

The application number
assigned by the Food and
Drug Administration
(FDA).

Additional FDA Application
Supplement Number #1

Additional FDA Application
Number #2

Additional FDA Application
Supplement Number #2

Valid Values

If the product has more than
one FDA Application
Number, enter an additional
application number here.

Required
Field

Page 15 of 17

Field Name

Field Definition

Valid Values

Required
Field

(FDA).
FDA Final Pre-Marketing
Approval Date

FDA Approval Type

This is the original date
the FDA granted
approval for the drug
(NDA), biological
(BLA), or pre-marketing
application (PMA).

Value should be in the date
format (MM/DD/YYYY).

The type of FDA
approval for the product.

Choose a value from the
drop down menu (ANDA,
NDA, NDA-505b2,
510K, BLA, BLA 351k,
PMA, Human Tissue,
Vaccine, Other).

Yes

If there is no approval date,
baseline date should be set
to 01/01/1965.

Yes

If Other, specify the type in
the column ‘Description of
FDA Approval Type’.
Description of FDA Approval Type If Other was specified in
the column ‘FDA
Approval Type,’ please
specify the type.

Free form field limited to
255 alphanumeric
characters.

Yes, if FDA
Approval
Type is
“Other”

Page 16 of 17

4 TEMPLATE REQUIREMENTS
1. To use this template, a user must have the ability to enable and execute MS Excel-based Visual Basics
for Applications (VBA) Macros.
 If the user is not able to accept macros due to constraints in corporate security policies, CMS
should be notified in writing of the security limitations in the user’s cover letter.
2. Users shall not add additional columns to the template.
3. Users shall not add, remove or otherwise change columns or column headings within the template.
4. Users shall not submit blank rows between data entries. All data must be submitted in contiguous rows.
5. Users shall not create multiple rows for one NDC or Alternative ID.

5 ACRONYMS
ANDA

Abbreviated New Drug Application

ASP

Average Sale Price

BLA

Biologics License Application

CAP

Competitive Acquisition Program

Center for Medicare

CMS

Centers for Medicare & Medicaid Services

FDA

Food and Drug Administration

Federal Register

HAPG

Hospital and Ambulatory Policy Group

International Units

NDA

New Drug Application

NDC

National Drug Code

NHRIC

National Health Related Items Code

Milliliter

Milligram

Microsoft

PMA

Pre Marketing Approval

VBA

Visual Basic for Applications

WAC

Wholesale Acquisition Cost

Page 17 of 17

File Type	application/pdf
File Title	Average Sale Price (ASP) Data Collection Template/Data Validation Macro
Subject	Average Sale Price (ASP) Data Collection Template/Data Validation Macro, User Manual
Author	CMS
File Modified	2023-01-19
File Created	2020-03-25