PCA data
Learn how to filter internal product development spreadsheets and verify pack sizes or medicinal forms using the British National Formulary (BNF) database.
This guide explains how to investigate #N/A errors in product development spreadsheets by cross-referencing medication pack sizes with the British National Formulary (BNF). Completing this ensures your pharmaceutical catalog data is accurate and free of calculation errors.
This applies to product development and data management teams. Use this workflow when auditing data or resolving formula errors in product control sheets.
Access the Product Development Directory
Locate and Filter Missing Data
You need to search for the product you are looking at
Cross-Reference the pack size with the BNF Database
Update the Spreadsheet
Q: Why does my spreadsheet show an #N/A error in the calculation columns?
A: This typically occurs when a dependent value, such as a drug's pack size, is missing or incorrect. Verifying the correct size via the BNF website and updating the cell will resolve the formula error.
Term | Definition |
|---|---|
BNF | The British National Formulary is a standard pharmaceutical reference used in the UK for dispensing and managing medications. |
NICE | The National Institute for Health and Care Excellence, which hosts the digital BNF database. |
PCA | A product control or pricing catalog file used internally during product development. |
Medicinal forms | The physical form in which a medication is produced and dispensed, such as tablets, capsules, or oral solutions. |