I have created a spreadsheet that is fairly simple to pop in premiums, monthly drug copay and any deductible to determine a yearly estimated cost of the plan. Perhaps the most daunting aspect is collecting the data. Each plan publishes a drug formulary that will list if the drug is covered, the tier, copay for each tier and any deductible.
