H. Dallas TCA Products 07132026.xlsx

This is a pharmaceutical product usage data file containing prescription records from the Dallas Consolidated Mail Outpatient Pharmacy (CMOP) facility. The spreadsheet captures historical medication dispensing patterns across multiple drugs with National Drug Codes (NDCs), including detailed metrics on prescription volumes, tablet/capsule quantities, and weekly prescription rates. The data encompasses medications such as Acetazolamide (various strengths), Acyclovir, Amantadine, Amitriptyline, Atenolol (multiple formulations), Acarbose, Amoxicillin-Clavulanate, Azithromycin, Apixaban, Apremilast, Benazepril, Benztropine, Bethanechol, Bromocriptine, Bumetanide, Bisoprolol, Buspirone, Budesonide, Bupropion, Calcitriol, Carbidopa-Levodopa (various combinations), Cephalexin, Chlorpheniramine, Chlorthalidone, Ciprofloxacin, Calcium Carbonate, Colestipol, Cilostazol, Cevimeline, Colesevelam, Citalopram, Cinacalcet, and Diltiazem, with records organized by NDC and product code.

The data appears designed to support the VA's RFP 36C77026R0007 for the Lancaster CMOP Low to Medium Volume TCA (Tablet Counting and Sorting) and Sorting Loops Project, which seeks to maintain and upgrade automation infrastructure at the Dallas CMOP facility currently processing approximately 90,000 prescriptions daily. The prescription volume information—organized by unique days, quantity requested, total prescriptions, total tablets, and prescriptions per weekday—provides baseline demand forecasting data essential for evaluating automated dispensing system requirements, throughput capacity, and sorting loop configurations. This historical usage data enables potential vendors to understand product mix complexity, peak processing demands, and system scalability needs to support current operations and anticipated future growth under VA Medical Centers and Community Based Outpatient Clinics nationwide.