Maintain the Drug Ranking Excel File

The Drug Ranking Excel File import is intended for allowing convenient updating of drug ranking as defined in a maintained spreadsheet.

The drug ranking Excel file will be provided to you by your head office. Alternatively, a template can be exported from List of Drugs report.

The Drug Ranking Excel File will have the following columns by default:

(Click the image to enlarge it).

Column

Description

DrugCode

Fred Drug Code

DrugDescription

Drug brand name, form, and strength

BrandName

Drug brand name

Form

Drug form

Strength

Drug strength

PackSize

Drug pack size

GenericName

Drug generic name

GenericCode

Fred Generic Drug Code

ManufacturerCode

Drug manufacturer code

GTIN

Barcode (Note: Only the first barcode is included)

HQID

AppCAT HQID (coming soon)

AverageWholesalerCost

Drug average wholesaler cost

CreatedDate

Date drug became available in Fred Dispense Plus

Ranking

User specified ranking value between 0 to 9. 0 is highest ranking, 9 is lowest rank. 5 is the default ranking value.

Group

User specified ranking group e.g. Group1, Group2 etc. Values are not case sensitive (e.g. Tier1 will be treated the same as tier1). Can be left empty.

It is recommended, but not essential, that the columns are in the same order as above.

The Drug Ranking Excel File must have the DrugCode, Ranking and Group columns as they are used by the import process. The name for these columns must be as they appear in the table above. The other columns can be hidden or removed.

Excel .xlsx files are supported and it is also important to note that only the first worksheet within the .xlsx file is processed.

A template with all currently active drugs can be provided as a starting point. However, the Drug Ranking Excel File needs to be maintained by the user on an ongoing basis.

Some general considerations when maintaining the Drug Ranking Excel file:

  • The ranking in the Excel file will replace any existing drug ranking in Fred Dispense Plus when it is imported.

  • The ranking for any drugs that are not part of the import process will remain in its current state.

  • To reset a drug ranking back to default, include the drug and specify a ranking value of 5.

Related Topics

Import a Drug Ranking Excel File