{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Performance Guarantees","Credits-Allowances","Capabilitites","Financial - TRADITIONAL","Specialty Pharmacy","Bid Specifications (financial)","Bid Specifications (Other)","Additional Requests"],"not_rendered":{"images":1,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"Performance Guarantees","index":0,"n_rows":63,"n_cols":27,"rows_kept":63,"merged":[[2,2,2,7],[3,2,3,7],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,7],[21,2,21,7],[24,2,24,7],[31,2,31,7],[41,2,41,7],[49,2,49,7],[54,2,54,7]]}
[{"$nulls":26},"Agree"]
[{"$nulls":26},"Agree with exception"]
[null,null,"Performance Guarantees",{"$nulls":23},"Disagree"]
[null,null,"Anderson County "]
[]
[{"$nulls":6},"Vendor Response\n(Enter value in first cell and use drop downs below)","Please provide detail\n(no response needed if blacked out)                                                                                           "]
[null,null,{"$f":"\"What is the total value of the fees at risk for \"&C4","v":"What is the total value of the fees at risk for Anderson County "},{"$nulls":3},0]
[null,null,{"$f":"\"Vendor agrees to track and reconcile all performance guarantees on \"&C4&\" data and not the vendor's book of business as a whole\"","v":"Vendor agrees to track and reconcile all performance guarantees on Anderson County  data and not the vendor's book of business as a whole"}]
[null,null,"Vendor agrees to report on all guarantees having fees at risk based on the reporting frequency outlined below for each guarantee"]
[null,null,{"$f":"C4&\" may reallocate fees at risk annually\"","v":"Anderson County  may reallocate fees at risk annually"}]
[null,null,{"$f":"\"Performance guarantees will be settled on an annual basis and shortfall penalties will be paid to \"&C4&\" within the first quarter after the contract year\"","v":"Performance guarantees will be settled on an annual basis and shortfall penalties will be paid to Anderson County  within the first quarter after the contract year"}]
[null,null,"Vendor will not use a surplus gain in one performance metric to offset shortfalls in another"]
[]
[null,null,"PBM Service","Expectation","Frequency of reporting","Reconciliation period","Vendor Response\n(drop down)","Please provide detail\n(no response needed if blacked out)                                                                                           "]
[null,null,"Implementation"]
[null,null,"Vendor will successfully implement the RX benefit plan and member portal systems prior to the go-live date as mutually agreed upon by both parties","Program is operation on go-live date and vendor has met all surrogate deadlines","One time (during implementation process)","One time"]
[null,null,"Vendor will successfully load all eligibility data within 15 days and set-up  related file feeds needed for subsequent eligibility data transmission","Pass / Fail","One time (during implementation process)","One time"]
[null,null,{"$f":"\"Vendor will test and confirm successful benefit set-up with \"&C4","v":"Vendor will test and confirm successful benefit set-up with Anderson County "},"Pass / Fail","One time (during implementation process)","One time"]
[null,null,"Vendor will successfully obtain and load all claims history and prior authorization data from prior vendor","Pass / Fail","One time (during implementation process)","One time"]
[null,null,"Vendor agrees 99% of new plan participants will be mailed an on-boarding kit (ID cards and welcome materials), no later than 10 days prior to the go-live date, upon receipt of a clean and accurate eligibility file.","99% within 10 days (business)","One time (during implementation process)","One time"]
[null,null,"Client satisfaction with implementation process. All timelines are met, cards are mailed to correct addresses on time, communication materials are distributed as agreed upon and the benefit is set up to adjudicate claims as specified in the documentation signed off on during implementation.","Pass / Fail","Within 60 days after the effective date","One time"]
[]
[null,null,"Eligibility data (on-going)"]
[null,null,"Percent of eligibility files loaded without error within 2 business days. Assumes file error-free file from eligibility vendor",{"v":1,"d":"100%"},"Monthly","Annually"]
[]
[null,null,"Retail Network"]
[null,null,"Percent of time the claims processing system is available to retail pharmacies to adjudicate claims excluding any predetermined and communicated maintenance outages. ",">99.5%","Quarterly","Annually"]
[null,null,{"$f":"\"Percent of retail network pharmacies utilized by \"&C4&\"  which are audited annually\"","v":"Percent of retail network pharmacies utilized by Anderson County   which are audited annually"},{"v":0.02,"d":"2%"},"Quarterly","Annually"]
[null,null,{"$f":"\"Percent of mail and specialty pharmacies utilized by \"&C4&\"  which are audited annually\"","v":"Percent of mail and specialty pharmacies utilized by Anderson County   which are audited annually"},{"v":1,"d":"100%"},"Quarterly","Annually"]
[null,null,"Percent of members with access to a retail pharmacy in their zip code. 1 mile for urban, 15 miles for rural",">97%","Quarterly","Annually"]
[null,null,"Percent of pharmacies in the largest networked offered (nationally)",">98%","Quarterly","Annually"]
[]
[null,null,{"$f":"C14","v":"PBM Service"},{"$f":"D14","v":"Expectation"},"Frequency of reporting","Reconciliation period","Vendor Response\n(drop down)","Please provide detail\n(no response needed if blacked out)                                                                                           "]
[null,null,"Customer service"]
[null,null,"Average time that inbound calls to customer service will be answered. Excludes calls routed to IVR.","30 seconds","Quarterly","Annually"]
[null,null,"Percent of calls in which it take less than 60 seconds for the member to reach a pharmacist after requesting that transfer from a customer service representative or electing that option from prompts",{"v":1,"d":"100%"},"Quarterly","Annually"]
[null,null,"Percent of calls answered at the specialty pharmacy (by a live representative) within 30 seconds",{"v":1,"d":"100%"},"Quarterly","Annually"]
[null,null,"Percent of calls that are not answered by the PBM (abandonment rate)","<3%","Quarterly","Annually"]
[null,null,"Percent of members who do not call back within 1 week of their initial call for the same inquiry (first call resolution)",{"v":0.9,"d":"90%"},"Quarterly","Annually"]
[null,null,"Vendor agrees 99% of new plan participants will be mailed an on-boarding kit (ID cards and welcome materials) upon receipt of a clean and accurate eligibility file.","99% within 5 days (business)","Annually","One time"]
[null,null,"Percent of members who are responded to within 10 days of the PBM's receipt of a written request",{"v":0.95,"d":"95%"},"Quarterly","Annually"]
[]
[null,null,"Member survey"]
[null,null,"Percent of utilizing members who self report some level of satisfaction with their customer service experience based on an annual review.","≥90%","Annually","Annually"]
[null,null,{"$f":"C14","v":"PBM Service"},{"$f":"D14","v":"Expectation"},"Frequency of reporting","Reconciliation period","Vendor Response\n(drop down)","Please provide detail\n(no response needed if blacked out)                                                                                           "]
[null,null,"Account service"]
[null,null,"Calls returned by the account team within 1 business day",{"v":0.95,"d":"95%"},"Quarterly","Annually"]
[null,null,"Percent of calls and emails resolved within 2 business days","≥90%","Quarterly","Annually"]
[null,null,{"$f":"\"Average client satisfaction score from \"&C4&\". Subjectively graded by benefits administrative staff using the following criteria; 1 - Fails to meet service expectations, 2 - Dissatisfied, 3 - Satisfied, 4 - Very satisfied, 5 - Consistently exceeds expectation\"","v":"Average client satisfaction score from Anderson County . Subjectively graded by benefits administrative staff using the following criteria; 1 - Fails to meet service expectations, 2 - Dissatisfied, 3 - Satisfied, 4 - Very satisfied, 5 - Consistently exceeds expectation"},">4","Quarterly","Annually"]
[]
[null,null,"Claims"]
[null,null,"Percent of claims which adjudicate appropriately with respect to the client's plan design, pricing and coverage rules",{"v":0.995,"d":"99.5%"},"Quarterly","Annually"]
[null,null,"Percent of paper claims processed within 10 business days",{"v":0.9,"d":"90%"},"Quarterly","Annually"]
[null,null,"Overages in member paid amounts will be reimbursed to the member within 1 month of the fill date",{"v":1,"d":"100%"},"Quarterly","Annually"]
[]
[null,null,"Mail"]
[null,null,"Percent of mail and specialty prescriptions dispensed with no error in drug, form, dose, strength, directions, patient pursuant to the written prescription AND delivered to the correct patient address",{"v":0.9999,"d":"99.99%"},"Quarterly","Annually"]
[null,null,"Average turn around time (from receipt of RX to shipped date) for mail and specialty claims upon receipt of a clean prescription order","≤2 days","Quarterly","Annually"]
[null,null,"Average turn around time (from receipt of RX to shipped date) for mail and specialty claims upon receipt of an order requiring additional outreach to the member or physician. After consulting with the prescriber, if it is deemed necessary to not fill the prescription, the member will be notified within the 5 business days as well","≤5 days","Quarterly","Annually"]
[null,null,"Vendor agrees at least 97% of mail order prescription with an equivalent generic will be dispensed as the generic product where substitution is permissible.",{"v":0.97,"d":"97%"},"Quarterly","Annually"]
[null,null,{"$f":"C45","v":"PBM Service"},{"$f":"D45","v":"Expectation"},"Frequency of reporting","Reconciliation period","Vendor Response\n(drop down)","Please provide detail\n(no response needed if blacked out)                                                                                           "]
[null,null,"Reporting"]
[null,null,"Vendor will prepare and report (mutually agreed upon) plan performance metrics on an annual and quarterly basis. Reports will be provided in advance (electronically or hardcopy) within 60 days of the close of the study period",{"v":1,"d":"100%"},"Quarterly","Annually"]

{"sheet":"Credits-Allowances","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[2,2,2,5],[3,2,3,5]]}
[]
[]
[null,null,"Credits / Allowances"]
[null,null,{"$f":"'Performance Guarantees'!C4","v":"Anderson County "}]
[]
[null,null,"Please detail any credits/allowances being offered as part of this proposal"]
[]
[{"$nulls":3},"Year 1 ","Year 2","Year 3"]
[null,null,"Implementation Credit"]
[null,null,"Audit Credit - Pre-implementation"]
[null,null,"Audit Credit - Post-implementation or ongoing"]
[null,null,"Admin Credit - For clinical programs, mailings, etc."]
[null,null,"Other - Please Describe"]

{"sheet":"Capabilitites","index":2,"n_rows":186,"n_cols":14,"rows_kept":186,"merged":[[1,1,1,3],[2,1,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3]]}
[{"$nulls":9},"In-house","Available","Yes",1,"<1%"]
[null,"PBM Capabilities - Contracting",{"$nulls":7},"Subcontracted",{"$f":"J3","v":"Not offered"},"No",2,"1-5%"]
[null,{"$f":"'Credits-Allowances'!C4","v":"Anderson County "},{"$nulls":7},"Not offered",null,"N/A",3,"6-10%"]
[{"$nulls":12},4,">10%"]
[null,"Company Information","Vendor Response",{"$nulls":9},5]
[null,"Company Name",{"$nulls":10},">5"]
[null,"Number of Employees"]
[null,"Publically traded or privately held"]
[null,"Annual revenue"]
[null,"Assets"]
[null,"Liabilities"]
[null,"Pharmacy Metrics"]
[null,"Book of business (Commercial) annual RX trend for the last 3 years"]
[null,"Specialty","Year 1:                        Year 2:                         Year 3:"]
[null,"non-Specialty",{"$f":"C14","v":"Year 1:                        Year 2:                         Year 3:"}]
[null,"Total",{"$f":"C14","v":"Year 1:                        Year 2:                         Year 3:"}]
[null,"Book of business aggregate discount, network performance (weighted average AWP discount of amounts paid to network pharmacies across all claims. These aggregates will be assumed bucketed in accordance with financial bid specification responses)","<----Requested for TRADITIONAL bids. Strongly encouraged for PASS-THROUGH bids."]
[null,"Retail","Brand:","Generic:"]
[null,"Mail","Brand:","Generic:"]
[null,"Specialty","Brand:","Generic:"]
[null,"Number of lives under management"]
[null,"Number of prescriptions processed annually"]
[null,"Number of prescriptions filled through your own facilities/mail (if applicable)"]
[null,"Number of self-insured companies served"]
[null,"Number of self-insured lives managed"]
[null,"Number of Medicaid plans served"]
[null,"Number of Medicaid lives managed"]
[null,"Number of Medicare plans served"]
[null,"Number of Medicare lives managed"]
[null,"Staffing Metrics"]
[null,"Number of pharmacists on staff - Mail"]
[null,"Number of pharmacists on staff - Specialty"]
[null,"Number of pharmacists on staff - PBM operations/Formulary"]
[null,"Number of technicians on staff - Mail"]
[null,"Number of technicians on staff - Specialty"]
[null,"Number of technicians on staff - PBM/Formulary"]
[null,"Staffing Metrics cont. (Turnover Percentage)"]
[null,"Mail/Specialty pharmacist"]
[null,"PBM operations/formulary pharmacist"]
[null,"Mail/Specialty technician"]
[null,"PBM operations/formulary technician"]
[null,"Clinical account executive"]
[null,"Account managers"]
[null,"Sales representatives"]
[null,"Executives and directors"]
[null,"Service","Vendor\n(drop down)","Comments - Details"]
[null,"Appeals - Level 1"]
[null,"Appeals - Level 2"]
[null,"Urgent appeals"]
[null,"Independent Review Organization (IRO appeals)"]
[null,"Disease management"]
[null,"Claim adjudication"]
[null,"Eligibility processing and maintenance"]
[null,"Formulary maintenance"]
[null,"ID card production"]
[null,"Member communications"]
[null,"HRA admin"]
[null,"HSA admin"]
[null,"Mail order pharmacy and fulfillment"]
[null,"Specialty pharmacy and fulfillment"]
[null,"Call center - member"]
[null,"Call center - provider"]
[null,"Paper claim processing"]
[null,"Implementation services"]
[null,"Prior authorization services"]
[null,"Pharma contracting - Rebates"]
[null,"Retail pharmacy network management"]
[null,"Clinical programs- utilization management"]
[null,"Client Reporting Tools","Vendor\n(drop down)","Comments - Details"]
[null,"Eligibility updates"]
[null,"Coverage updates and overrides"]
[null,"Claim history"]
[null,"Utilization reports - standard or custom"]
[null,"Member Portal Tools","Vendor\n(drop down)","Comments - Details"]
[null,"Refill reminders"]
[null,"Medication pricing and alternatives"]
[null,"OTC therapy and interaction reporting"]
[null,"Member-level drug information online (side effects, intent of therapy, treatment goals, clinical pearls)"]
[null,"Drug:Drug interaction reporting online"]
[null,"Brand to generic conversion recommendations and savings estimates"]
[null,"Network pharmacy transition recommendations and savings estimates"]
[null,"Member cost share calculations specific to plan design and deductible/OOP accumulators"]
[null,"Other members savings opportunities available online"]
[null,"Access to standard formulary online"]
[null,"Access to member/client specific formulary online"]
[null,"Mobile/Tablet applications - Please describe the capabilities offered"]
[null,"Network pharmacy locator"]
[null,"Toll free customer service number"]
[null,"Access to formulary recommendations"]
[null,"Exclusions and non-preferred drug lists"]
[null,"Prescriber Tools","Vendor\n(drop down)","Comments - Details"]
[null,"ePrescribing"]
[null,"Mobile/Tablet applications - Please describe the capabilities offered"]
[null,"PBM Platform \\ Services","Vendor\n(drop down)","Comments - Details (if green)"]
[null,"Have you recently (within the last 2 years), or are their plans to acquire or merge with another PBM?"]
[null,"How many claims adjudication platforms are currently operating?"]
[null,"If there are plans to consolidate platforms, how many platforms do you anticipate running?"]
[null,"Are there any system upgrades, operational updates or clinical management updates planned or anticipated in the next 12 to 18 months?"]
[null,"Do the retail, specialty and mail channels operate on the same platform?"]
[null,"Can you accept an open refill file and what is the fee?"]
[null,"Can you accept a historic claims file for SmartPA and step therapy programs and what is the fee?"]
[null,"Are you able to provide a claims feed to the client or a designated disease management vendor and what are the fees?"]
[null,"Are you able to provide a claims feed to the medical carrier and what are the fees?"]
[null,"Are you able to receive and utilize medical claims information for safety monitoring and disease management and what are the associated fees?"]
[null,"What percent of claims do you review for payment accuracy?"]
[null,"What percent of claims from RETAIL pharmacies do you review for entry/processing accuracy?"]
[null,"What percent of claims from Mail pharmacies do you review for entry/processing accuracy?"]
[null,"Processing and payment","Vendor\n(drop down)","Comments - Details (if green)"]
[null,"Coinsurance at mail"]
[null,"Coinsurance at retail"]
[null,"Combined plan designs (copay & coinsurance, with or without mins/maxs) at mail"]
[null,"Combined plan designs (copay & coinsurance, with or without mins/maxs) at retail"]
[null,"OTC adjudication"]
[null,"Custom copay waivers - based on drug type or # of fills"]
[null,"Reduced copay for targeted disease states (value plan design)"]
[null,"Reduced copay for on-time refills by member. Promote adherence"]
[null,"Day supply limitations for specific drug groups (e.g. Specialty RX)"]
[null,"Copay variation by pharmacy - Retail/Mail, Network/non-network"]
[null,"Split copay for short day supply based on clinical review (e.g. short supply of oral oncology to limit wastage)"]
[null,"Ability to include or exclude penalties to out of pocket maximums and deductible"]
[null,"Out of pocket maximum - integration with medical carrier, calculation and application to claim"]
[null,"Deductible - integration with medical carrier, calculation and application to claim"]
[null,"Can you process paper claims within 10 days? Please provide detail on how often you process these claims and the frequency that reimbursement is mailed to members"]
[null,"Network","Vendor\n(drop down)","Comments - Details (if green)"]
[null,"Can you offer a 90-day retail network? If yes, please describe the number of pharmacies available to members with this option and detail the pricing arrangement (mail pricing?) to the plan sponsor and member."]
[null,"Can you accept manufacturer coupons at mail?"]
[null,"Can you accept manufacturer sponsored copay assistance programs at mail?"]
[null,"Can you exclude member subsidies (coupons and copay assistance) from out of pocket and deductible calculations?"]
[null,"Member communications included","Vendor\n(drop down)","Comments - Details (include specific fees if applicable)"]
[null,"Please indicate which are included as standard communications to new members-"]
[null,"Welcome letter"]
[null,"Formulary"]
[null,"FAQs"]
[null,"ID Card"]
[null,"Mail order forms for registration"]
[null,"Health and wellness material sponsored by vendor"]
[null,"\"Generics-first\" promotion"]
[null,"Are member communications available in languages other than English if needed?"]
[null,"Call center","Vendor Response\n(drop down if available)","Comments - Details"]
[null,"How many call centers are available to the client?"]
[null,"What city/state are the call centers located in?"]
[null,"What percent of calls are handled outside the U.S.?"]
[null,"What are the hours of operation for these call centers?"]
[null,"What are the hours of operation in which a pharmacist is available to a member?"]
[null,"Are general questions, mail inquiries and specialty inquiries handled by the same call center? If not, please provide details."]
[null,"Can members call in and receive assistance prior to the go-live date of the plan? If yes, please provide details on what information will be available and how early they may call in."]
[null,"Last year's Average Speed of Answer (ASA) rate-"]
[null,"Last year's Call Abandonment rate-"]
[null,"Last year's First Call Resolution rate-"]
[null,"Are these metrics reported in aggregate or by each call center separately?"]
[null,"How many hours are new representatives required to obtain prior to working independently? (classroom and preceptorship)"]
[null,"Which of the following would require an outbound call to the member prior to fulfillment? Please provide details on the threshold if applicable."]
[null,"Dollar threshold"]
[null,"Number of RX threshold"]
[null,"Controlled substances ($ or number of RX)"]
[null,"Temperature parameters"]
[null,"Specialty Medications"]
[null,"How many times will you attempt to reach the member?"]
[null,"What happens if no response?"]
[null,"Please indicate which of the following are available to the customer service representative-"]
[null,"Eligibility"]
[null,"Retail network information"]
[null,"Order status - mail order"]
[null,"HRA/HSA/FSA account information"]
[null,"Deductible accumulation"]
[null,"Max out of pocket accumulation"]
[null,"Lifetime maximum accumulation"]
[null,"Copays or coinsurance for a specific claim/drug"]
[null,"Claim history"]
[null,"ID card questions"]
[null,"How do you document call outcomes?"]
[null,"Are representative required to document outcomes prior to closing the case?"]
[null,"Will you generate call center reporting for the client based on standard metrics?"]
[null,"Please indicate whether you perform these types of member satisfaction surveys and provide details around the frequency of these surveys in the far right column"]
[null,"Telephone"]
[null,"Internet"]
[null,"Mail-in"]
[null,"Which metrics do you survey on?"]
[null,"CSR encounters"]
[null,"Mail order turnaround time"]
[null,"Mail order customer service"]
[null,"Specialty customer service"]
[null,"Specialty clinical support"]
[null,"Network pharmacy access"]
[null,"Acceptable resolution"]
[null,"Benefit inquires and plan design"]

{"sheet":"Financial - TRADITIONAL","index":3,"n_rows":204,"n_cols":9,"rows_kept":204,"merged":[[0,1,0,3],[1,1,1,3],[3,1,3,3],[9,1,9,2],[20,1,22,1],[23,1,25,1],[26,1,28,1],[29,1,31,1],[32,1,34,1],[36,1,38,1],[39,1,41,1],[43,1,45,1],[46,1,48,1],[49,1,51,1],[53,1,53,3],[54,1,54,3],[64,1,66,1],[67,1,69,1],[70,1,72,1],[73,1,75,1],[76,1,78,1],[80,1,82,1],[83,1,85,1],[87,1,89,1],[90,1,92,1],[93,1,95,1],[97,1,97,2],[104,1,106,1],[107,1,109,1],[110,1,112,1],[113,1,115,1],[116,1,118,1],[120,1,122,1],[123,1,125,1],[127,1,127,2],[131,1,133,1],[134,1,136,1],[138,1,140,1],[142,1,142,2],[144,1,146,1],[147,1,149,1],[150,1,152,1],[153,1,155,1],[157,1,157,2],[161,1,161,2],[162,1,164,1],[165,1,167,1],[168,1,170,1],[171,1,171,2],[172,1,174,1],[175,1,177,1],[178,1,180,1],[181,1,183,1],[184,1,186,1],[187,1,187,2],[188,1,188,2],[189,1,191,1],[192,1,194,1],[195,1,197,1],[198,1,200,1],[201,1,203,1]]}
[null,"Financial Bid - Traditional",{"$nulls":6},"Lookups:"]
[null,{"$f":"Capabilitites!B3","v":"Anderson County "},{"$nulls":6},"Pricing Deal"]
[{"$nulls":8},"Traditional"]
[null,"Bidding vendor should complete all cells shaded in green. Bid specifications may be drop down menus while financial inputs are fill-in-the-blank. Discounts should be based off AWP.",{"$nulls":6},"Pass Through (With minimum guarantees)"]
[]
[null,null,"Pricing compendia used","MediSpan"]
[null,null,"Proposed Formulary (name of formulary)"]
[null,null,"Formulary Type"]
[{"$nulls":8},"Retail network"]
[null,"Retail-30",null,"Open Network",{"$nulls":4},"Broad"]
[null,null,"Pricing Arrangement","Traditional",{"$nulls":4},"Narrow"]
[null,null,"Network","Broad"]
[null,null,"Pharmacies Excluded from proposed network"]
[null,null,"Pre/Post Rollback","Post Roll-back"]
[null,null,"Zero Balance Logic (ZBL) allowed and included","No",{"$nulls":4},"Placement of SSGs for pricing"]
[null,null,"U&C included in BRAND discount","No",{"$nulls":4},"Brand"]
[null,null,"U&C included in GENERIC discount","No",{"$nulls":4},"Generic"]
[null,null,"Single Source Generics included in brand or generic",{"$nulls":5},"Separated out"]
[]
[null,"Non-Specialty Discounts",{"$nulls":6},"Actual NDC"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"100ct and Pints"]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"U&C included"]
[null,"Generic Overall Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Yes"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"No"]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"MAC-Generic Discount","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"ZBL allowed"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"Yes"]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"No"]
[null,"non-MAC Generic Discount","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"MAC at Mail"]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"Yes"]
[null,"Single Source Generic Discount","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"No"]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"Specialty - retail lock required"]
[null,"Specialty Discounts",{"$nulls":6},"Yes"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"No"]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"Rebates"]
[null,"Generic Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Flat - guaranteed"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"Minimum - guaranteed"]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Dispensing Fees (per RX)"]
[null,"Brand","Year 1",0]
[null,null,"Year 2",0,{"$nulls":4},"Rebate Basis"]
[null,null,"Year 3",0,{"$nulls":4},"\\Brand RX"]
[null,"Generic","Year 1",0,{"$nulls":4},"\\Formulary Brand RX"]
[null,null,"Year 2",0,{"$nulls":4},"\\RX"]
[null,null,"Year 3",0]
[null,"Specialty","Year 1",0,{"$nulls":4},"Rollback"]
[null,null,"Year 2",0,{"$nulls":4},"Pre Roll-back"]
[null,null,"Year 3",0,{"$nulls":4},"Post Roll-back"]
[]
[null,"Retail-90",{"$nulls":6},"Admin Fees"]
[null,"Provide differential pricing and network information, if available, for specific retail pharmacies offering deeper discounts for mail-like fills at retail"]
[null,null,"Network",{"$nulls":5},"PEPM"]
[null,null,"Pharmacies in proposed retail-90 network (provide name and # of pharmacies)"]
[null,null,"Pre/Post Rollback","Post Roll-back",{"$nulls":4},"PMPM"]
[null,null,"Zero Balance Logic (ZBL) allowed and included","No"]
[null,null,"U&C included in BRAND discount","No",{"$nulls":4},"Mail pricing at retail"]
[null,null,"U&C included in GENERIC discount","No",{"$nulls":4},"Yes"]
[null,null,"Single Source Generics included in brand or generic",{"$nulls":5},"No"]
[]
[null,"Non-Specialty Discounts",{"$nulls":6},"Retail Lock for specialty pricing"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Yes"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"No"]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Generic Overall Guarantee","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Compendia"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"First Databank"]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"MediSpan"]
[null,"MAC-Generic Discount","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Other - Please specify"]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"Formulary"]
[null,"non-MAC Generic Discount","Year 1",{"v":0,"d":"0.00%"},{"$nulls":4},"Open"]
[null,null,"Year 2",{"v":0,"d":"0.00%"},{"$nulls":4},"Closed"]
[null,null,"Year 3",{"v":0,"d":"0.00%"},{"$nulls":4},"Other - Please specify"]
[null,"Single Source Generic Discount","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Specialty Discounts"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Generic Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Dispensing Fees (per RX)"]
[null,"Brand","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Generic","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[]
[null,"Mail Order"]
[null,null,"Package size provision"]
[null,null,"MAC at mail"]
[null,null,"Day Supply Minimum"]
[null,null,"Single Source Generics included in brand or generic"]
[]
[null,"Non-Specialty Discounts"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Generic Overall Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"MAC-Generic Discount","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"non-MAC Generic Discount","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Single Source Generic Discount","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Dispensing Fees (per RX)"]
[null,"Brand Guarantee","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Generic Guarantee","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[]
[null,"Specialty"]
[null,null,"Assumes Exclusive Specialty (\"retail lock\")"]
[]
[null,"Specialty Discounts"]
[null,"Brand Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Generic Guarantee","Year 1",{"v":0,"d":"0.00%"}]
[null,null,"Year 2",{"v":0,"d":"0.00%"}]
[null,null,"Year 3",{"v":0,"d":"0.00%"}]
[null,"Specialty dispensing Fees (per RX)"]
[null,"Brand and Generic","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[]
[null,"Admin Fees"]
[]
[null,"Retail","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Paper","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Mail/ Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"PBM           Fees","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[]
[null,"Rebates"]
[null,null,"Bid Requirement"]
[null,null,"Basis for rebates"]
[]
[null,"Client Rebate Percentage"]
[null,"Retail & Mail","Year 1",{"v":0,"d":"0%"}]
[null,null,"Year 2",{"$f":"D163","v":{"v":0,"d":"0%"}}]
[null,null,"Year 3",{"$f":"D164","v":{"v":0,"d":"0%"}}]
[null,"Specialty @ Retail","Year 1",{"v":0,"d":"0%"}]
[null,null,"Year 2",{"v":0,"d":"0%"}]
[null,null,"Year 3",{"v":0,"d":"0%"}]
[null,"Specialty @ Specialty","Year 1",{"v":0,"d":"0%"}]
[null,null,"Year 2",{"v":0,"d":"0%"}]
[null,null,"Year 3",{"v":0,"d":"0%"}]
[null,"Incentive plan design"]
[null,"Retail non-specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Retail Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Retail-90","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Mail","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Rebates"]
[null,"non-Incentive plan design"]
[null,"Retail non-specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Retail Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Retail-90","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Mail","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]
[null,"Specialty","Year 1",0]
[null,null,"Year 2",0]
[null,null,"Year 3",0]

{"sheet":"Specialty Pharmacy","index":4,"n_rows":72,"n_cols":6,"rows_kept":72,"merged":[[1,3,1,5],[2,3,2,5],[4,3,4,5]]}
[]
[{"$nulls":3},"Financial Bid - Specialty Pharmacy"]
[{"$nulls":3},{"$f":"'Financial - TRADITIONAL'!B2","v":"Anderson County "}]
[]
[{"$nulls":3},"In addition to the guaranteed aggregate specialty discount on the previous page, please provide your proposed discounts by drug. Please provide both open, and lock-in pricing if applicable."]
[]
[{"$nulls":3},"Brand Name","Open Network Discount","Exclusive - Lock-in Discount"]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]

{"sheet":"Bid Specifications (financial)","index":5,"n_rows":65,"n_cols":13,"rows_kept":65,"merged":[[2,1,2,4],[3,1,3,4],[6,1,6,4],[8,1,8,2],[57,1,64,1],[57,3,64,3],[57,4,64,4]]}
[{"$nulls":12},"Agree"]
[{"$nulls":12},"Agree with exception"]
[null,"Bid Specifications",{"$nulls":10},"Disagree"]
[null,{"$f":"'Specialty Pharmacy'!D3","v":"Anderson County "},{"$nulls":10},"N/A"]
[]
[]
[null,"All financial bids on the [financial] tab shall be inclusive of all fees associated with the PBM work in this contract. Terms on the [financial] tab will be assessed in conjunction with each vendor's response to the financial bid specifications below. Deviations may result in adjustments to the financial scoring or disqualification."]
[]
[null,"Bid Requirement (financial)",null,"Vendor Response (drop down)","Explanation for deviation"]
[null,"Brand discount guarantee \n(applies to Traditional bid)","Vendor offers an annual brand discount guarantee which will NOT include claims priced based on usual and customary charges or at a maximum allowable cost (MAC) rate."]
[null,"Generic discount guarantee \n(applies to Traditional bid)","Vendor offers an annual generic discount guarantee which will NOT include claims priced based on usual and customary charges, but will include all MAC and non-MAC generics."]
[null,"Rebate guarantee\n(applies to Traditional or Pass through bid)","Vendor may elect the basis of rebate guarantee on the [financial] tab. Vendor agrees this election will include all claims on that basis regardless of exclusivity, short supply issues or claims paid 100% by the member."]
[null,"Retail pass through\n(applies to Pass through bid)","Vendor offers to pass through 100% of the value of the contracted reimbursement discount/rate including discounts, MAC rates and dispensing fees on a per/RX basis. Pass through pricing is available on all drugs covered by the plan dispensed through the retail channel. The PBM shall not retain any monies as \"spread\" and will not subsidize any guarantee with that from another."]
[null,"Retail pass through\n(applies to Pass through bid)","Vendor attests the amounts received by the dispensing pharmacy as reimbursement will equal the amount paid by the plan sponsor on each claim."]
[null,"Retail contract transparency\n(applies to Pass through bid)",{"$f":"\"Vendor will share, at \"&B4&\"'s request, any network pharmacy's contracted discount, MAC reimbursement rates and/or dispensing fee at any time during the contract term.\"","v":"Vendor will share, at Anderson County 's request, any network pharmacy's contracted discount, MAC reimbursement rates and/or dispensing fee at any time during the contract term."}]
[null,"Retail contract transparency\n(applies to Pass through bid)",{"$f":"\"Vendor will share, at \"&B4&\"'s request, any contracts with a specific, or chain of network pharmacies\"","v":"Vendor will share, at Anderson County 's request, any contracts with a specific, or chain of network pharmacies"}]
[null,"Brand discount minimum guarantee \n(applies to Pass through bid)","Vendor offers an annual brand minimum discount guarantee which will NOT include claims priced based on usual and customary charges or at a maximum allowable cost (MAC) rate."]
[null,"Generic discount minimum guarantee \n(applies to Pass through bid)","Vendor offers an annual generic minimum discount guarantee which will NOT include claims priced based on usual and customary charges, but will include all MAC and non-MAC generics."]
[null,"Brand guarantee","Brand guarantees will include; single source brands, multi source brands, and over-the-counter drugs."]
[null,"Generic guarantee","Generic guarantees will include; single and multi source generic products regardless of their inclusion on the MAC list, multi-source brands not filled using a DAW code equal to 1 or 2, generics in patent litigation, generics in short supply, generic specialty drugs, and over-the-counter products. These same guarantees will exclude; claims priced at a pharmacy's usual and customary rate, 340b claims, LTC claims, home infusion claims, VA claims, compounds, paper claims, in-house pharmacy claims, and claims where the vendor paid as the secondary/COB payer. "]
[null,"Absence of signed contract","Vendor agrees that all pricing terms outlined in the proposal or subsequent best and final offers will apply upon the initiation of the benefit under the awarded vendor even in the absence of a signed contract at that time"]
[null,"Consistent application of pricing terms","Besides rebates, vendor agrees that pricing terms will apply to all members regardless of plan design"]
[null,"Consistent application of AWP and methodologies","Vendor agrees to use one database/compendia for the purposes of obtaining AWP data and identifying brand, generic and multisource products. Vendor will use the same methodologies and database to reconcile guarantees to actual plan performance"]
[null,"Market check",{"$f":"\"Vendor will offer revised financial terms at 18 months into the executed contract based on current market conditions at that time. If \"&B4&\" determine these terms are not competitive, \"&B4&\" reserves the right to terminate the contract without penalty\"","v":"Vendor will offer revised financial terms at 18 months into the executed contract based on current market conditions at that time. If Anderson County  determine these terms are not competitive, Anderson County  reserves the right to terminate the contract without penalty"}]
[null,"Enrollment Increase",{"$f":"\"Vendor agrees to offer improved financial terms if \"&B4&\"'s enrollment increases by 20% or more. Improvements will shall apply on the date enrollment increased to 120% or more.\"","v":"Vendor agrees to offer improved financial terms if Anderson County 's enrollment increases by 20% or more. Improvements will shall apply on the date enrollment increased to 120% or more."}]
[null,"Minimum terms","All pricing terms will be accepted as the \"minimum\" term and cannot be decreased at any point throughout the duration of the contract"]
[null,"AWP","AWP is defined as the Average Wholesale Price (AWP) published by MediSpan, active on the processing date of the claim, using the full 11-digit NDC of the particular drug /product dispensed. "]
[null,"Repackagers","Vendor will not use an AWP higher than that of the original manufacturer's AWP as the basis of adjudication of any repackaged product"]
[null,"Price benchmarks",{"$f":"\"Should the vendor choose another basis (e.g. transition from AWP to WAC or AAC) of determining ingredient cost, \"&B4&\" will be given a minimum of 90 days notice and details surrounding the change. The vendor will also be responsible for providing an analysis illustrating the revised methodology will be in the favor of, or cost neutral to \"&B4","v":"Should the vendor choose another basis (e.g. transition from AWP to WAC or AAC) of determining ingredient cost, Anderson County  will be given a minimum of 90 days notice and details surrounding the change. The vendor will also be responsible for providing an analysis illustrating the revised methodology will be in the favor of, or cost neutral to Anderson County "}]
[null,"Maximum Allowable Cost (MAC)",{"$f":"\"Vendor shall utilize a MAC reimbursement program for frequently utilized multisource products. These rates shall be the same used at mail and retail channels and the rates will be disclosed to \"&B4&\" upon request. These rates will be competitive with generic programs offered to cash paying guests at some retailers (e.g. Target, Wal-Mart $4 list)\"&\" The MAC rates used to charge \"&B4&\" must have changes which correlate in magnitude to those rates which are used to reimburse pharmacies specifically instances when a generic product loses exclusivity.\"","v":"Vendor shall utilize a MAC reimbursement program for frequently utilized multisource products. These rates shall be the same used at mail and retail channels and the rates will be disclosed to Anderson County  upon request. These rates will be competitive with generic programs offered to cash paying guests at some retailers (e.g. Target, Wal-Mart $4 list) The MAC rates used to charge Anderson County  must have changes which correlate in magnitude to those rates which are used to reimburse pharmacies specifically instances when a generic product loses exclusivity."}]
[null,"Separation of pricing and clinical programs","Vendor agrees that pricing agreements submitted (discounts/dispensing fees/rebates) are not tied to participation in any clinical programs such as Prior Authorization, Step Therapy, generics first or mandatory mail. Drug pricing will not be contingent on participation in any program."]
[null,"AWP Implications","Vendor agrees that claims will adjudicate and discounts will be reconciled against post-rollback AWP conditions."]
[null,"Aggregate guarantees","Vendor agrees that aggregate annual discount guarantees will be computed and reconciled on an all-in basis. Generic discounts will include all MAC and non-MAC products as well as multisource and single source generic products. These guarantees however, will exclude usual and customary as well as zero-balance claims (member pays 100%)."]
[null,"Financial shortfalls","Any shortfalls in financial guarantees will be paid to the client at an amount equal to, and no less than the financial impact to the client."]
[null,"Guarantees are mutually exclusive","Vendor agrees that financial guarantees are measured and reconciled in a mutually exclusive manner and shortfalls in one area may not be offset by surpluses in another. Additionally, rebates may not be included in the discount reconciliation."]
[null,"Payment of shortfalls","Vendor agrees to reconcile and provide payment of any shortfalls to the client within 90 days of the annual period."]
[null,"Retail Pharmacy Adjudication","Vendor will adjudicate claims at retail using the lower of; (1) contracted discount, (2) the maximum allowable cost, or (3) the usual and customary price submitted by the pharmacy. Dispensing fees will not be applied to claims paid at a usual and customary price. Pricing data will be applied for the particular date of service of each claim."]
[null,"Mail Pharmacy Adjudication","Vendor will adjudicate claims at mail using the lower of; (1) contracted discount, or (2) the maximum allowable cost, plus a dispensing fee (if applicable). Pricing data will be applied for the particular date of service of each claim."]
[null,"Lower of logic","Vendor agrees that all claims will adjudicate using a lower of logic based on discount, maximum allowable cost or the usual and customary price submitted by the pharmacy. The member shall never pay more than the  usual and customary price submitted even if the plan design suggests a higher cost share."]
[null,"Zero balance claims",{"$f":"B4&\" will have no financial responsibility on any claim paid 100% by the member including those at mail order.\"","v":"Anderson County  will have no financial responsibility on any claim paid 100% by the member including those at mail order."}]
[null,"MAC pricing","Vendor will use the same MAC pricing for retail pharmacies that it uses at mail"]
[null,"Mail MAC lower","Should MAC rates differ at mail and retail, the MAC rate for any given drug shall be lower at mail than retail"]
[null,"Postage increases","Postage increases shall not be passed on to the client. This applies to mail fulfillment and member communications alike"]
[null,"Compounded drugs","Compounded drugs will be priced using the same logic as other fills at mail and retail. There will be no additional costs or augmented dispensing fees associated with compounded products."]
[null,"Mail member cost share","The member cost share at mail must be the cost share defined by the plan design and there will not be a price floor for mail fills applied to the member cost share"]
[null,"Specialty pricing at retail","Vendor will price specialty drugs at retail based on the contracted and respective guaranteed brand and generic rates at retail. "]
[null,"Mail / Specialty pricing","Mail and specialty pricing will be in effect for all claims filled at their respective mail and specialty facilities regardless of day supply"]
[null,"Mail / Specialty collection",{"$f":"\"Member cost share not collected by the mail or specialty pharmacy will not be charged to \"&B4","v":"Member cost share not collected by the mail or specialty pharmacy will not be charged to Anderson County "}]
[null,"Specialty list - New adds","Vendor agrees that only new products will be included on the specialty list. Drugs previously considered non-specialty will not be added to the list."]
[null,"Generic to brand substitution","Vendor agrees that multisource brand products will only be dispensed pursuant to an appropriate DAW code. In the case a multisource brand drug is dispensed absent the request of the patient (DAW=2) or physician (DAW=1), the plan sponsor and member shall pay the contracted generic rate and cost share, and the claim will be included in the generic discount reconciliation. This includes claims billed using DAW 3, 4, and 5 where the pharmacist and/or pharmacy have indicated the generic to brand conversion."]
[null,"Administrative fees","Administrative fees are applied to paid claims only and will not include reversals or denied claims."]
[null,"Rebate payment","Minimum rebate guarantees will be paid to the client within 90 days at the end of each contract quarter."]
[null,"Rebate reconciliation","Rebates will be reconciled and paid to the client within 120 days following the end of each contract year."]
[null,"Rebate calculation","Rebates contracted on a claim calculation shall include all claims adjudicated for the plan and will not exclude those paid at 100% member cost share. Rebate calculations will also not exclude any claims based on day supply."]
[null,"Rebates defined","The term rebates will include all monies received by PBM from a manufacturer. This will include, but is not limited to; market share incentives, access fees, credits, educational disbursements, marketing grants and charge backs from a mail facility."]
[null,"Rebates - Formulary determination","Vendor agrees that guaranteed rebate amounts may not be reduced due to unexpected patent litigations, product withdrawals, recalls, product launches, or for any updates made to the formulary by the vendor during the life of the contract."]
[null,"Pricing source - Updates and changes","Vendor agrees that should a change in pricing benchmarks or the source of the pricing data due to marketplace changes or internal decisions, the vendor will; (1) provide the client advance notice (60 days) of the change, (2) reconcile any impacts through a 3rd party audit group, (3) pass through any lower gross costs to the client through deeper discount guarantees. The client will not be responsible for any fixed costs incurred by the PBM to update their systems."]
[null,"Specialty definition","Vendor agrees to the following definition of a specialty drug: A specialty drug may have two or more of the following characteristics:"]
[null,null,"-Biotech or biological drug"]
[null,null,"-Produced through DNA technology or biological processes "]
[null,null,"-Complex therapy for complex disease"]
[null,null,"-High Cost "]
[null,null,"-Requires special handling\\shipping\\storage"]
[null,null,"-Require frequent monitoring or specialized patient training"]
[null,null,"-Limited distribution"]

{"sheet":"Bid Specifications (Other)","index":6,"n_rows":41,"n_cols":13,"rows_kept":41,"merged":[[2,1,2,4],[3,1,3,4],[5,1,5,2],[21,1,21,2],[21,3,21,4],[31,1,31,2]]}
["Cigna",{"$nulls":11},"Agree"]
[{"$nulls":12},"Agree with exception"]
[null,"Bid Specifications",{"$nulls":10},"Disagree"]
[null,{"$f":"'Bid Specifications (financial)'!B4","v":"Anderson County "}]
[]
[null,"Bid Requirement (operational)",null,"Vendor Response (drop down)","Explanation for deviation"]
[null,"Carrier connectivity",{"$f":"\"Vendor must be capable of administering the pharmacy benefit in conjunction with \"&A1&\". Bi-directional data feeds for ACA compliance (e.g. deductible/max-out-of-pocket accumulators) must be operational and available to \"&B4&\" at no charge as this is a core requirement to administer PBM services under the ACA.\"","v":"Vendor must be capable of administering the pharmacy benefit in conjunction with Cigna. Bi-directional data feeds for ACA compliance (e.g. deductible/max-out-of-pocket accumulators) must be operational and available to Anderson County  at no charge as this is a core requirement to administer PBM services under the ACA."}]
[null,"Primary PBM functions","Vendor will be responsible for adjudicating prescription drugs claims on behalf, and in accordance with the client's plan design(s). The vendor will be responsible for all drug utilization review, as well as fraud/waste/abuse review at no costs in addition to the base administration fee. Vendor will adjudicate all electronic and paper claims in a timely fashion and have in place internal audits to prevent the mis-billing of any claim. "]
[null,"POS functions",{"$f":"\"Vendor agrees their system will allow for \"&B4&\" input of claim overrides, restriction of members to specific drugs/pharmacies/prescribers, and allow for restriction of individual prescribers to specific drug classes if requested\"","v":"Vendor agrees their system will allow for Anderson County  input of claim overrides, restriction of members to specific drugs/pharmacies/prescribers, and allow for restriction of individual prescribers to specific drug classes if requested"}]
[null,"Data acceptance","Vendor agrees to receive and load any necessary open refill or prior authorization files in addition to an eligibility file during implementation"]
[null,"Eligibility",{"$f":"\"While \"&B4&\" will determine procedures for enrollment and coverage cancellation, vendor accepts responsibility to validate and load all eligibility files upon receipt of a clean data file.\"&\" Vendor will accept and accurately process the prescription benefit for all eligible members of the plan\"","v":"While Anderson County  will determine procedures for enrollment and coverage cancellation, vendor accepts responsibility to validate and load all eligibility files upon receipt of a clean data file. Vendor will accept and accurately process the prescription benefit for all eligible members of the plan"}]
[null,"ID Cards","Vendor will adjudicate claims based on eligibility files. ID cards will be provided to all enrolled members during implementation and new members throughout the contract period. These cards will be mailed within 3 days of receipt of a clean eligibility file"]
[null,"ID Cards continued",{"$f":"\"Vendor shall allow \"&B4&\" the option to have RX information printed on the members medical ID card\"","v":"Vendor shall allow Anderson County  the option to have RX information printed on the members medical ID card"}]
[null,"Mail order pharmacy","If mail service is used; Vendor will be responsible for operating, or contracting with, a mail facility that meets the federal and state regulations to run a pharmacy. Any violations, penalties, or fines will not be passed on to the client. Any costs incurred to expedite an order resulting from an error in the pharmacy operations will not be passed on to the client."]
[null,"PPACA compliance","Vendor agrees to conform with all statutes and emerging guidance as a result of PPACA."]
[null,"Audit rights","Vendor agrees to allow the client to complete one audit per contract year. The vendor will provide reasonable access MAC rates, formulary rebates and other financial metrics necessary to audit financial performance of the plan. The client will not be responsible for any costs incurred by the PBM to compile the data needed to complete the audit."]
[null,"Pharmacy audits","Vendor agrees to continually audit at least 2% of network pharmacies. Vendor will be required to return 100% of recoveries to the client."]
[null,"Pharmacy network","Vendor will be required to have a toll-free number available to pharmacies 24/7, 365 days a year for claim processing inquires. Vendor will also be responsible for communicating a network pharmacy termination to the client, and impacted members, at least 90 days prior to that termination date."]
[null,"Data sharing","Vendor will allow up to three data feeds to external vendors (e.g. medical carrier, disease management vendor). Vendor should accept any reasonable request for customization of the data feed and frequency of communication based on typical business practices in the industry"]
[null,"House generics","In the event a brand drug is substituted and dispensed as a \"house generic\", in all cases, the member cost share and contractual guarantees of the comparable generic product will be applied"]
[null,"In house pharmacy","Vendor agrees to coordinate and partner with any onsite pharmacy (if applicable now, or in the future). This pharmacy shall be considered an in-network pharmacy for the purposes of claims adjudication."]
[null,"Bid Requirement (clinical)",null,"Vendor Response (drop down)","Explanation for deviation"]
[null,"Formulary","Vendor agrees that all formulary decisions and clinical protocols will be based on evidence based literature. The formulary and its resultant clinical programs will be designed to offer the member (and their plan sponsor) the most clinically appropriate and cost effective therapy. Up-tiering may only occur a maximum of twice per year. Drugs will never be excluded from the formulary unless required by the FDA or at the request of the plan sponsor. Exclusions occurring at the will of the PBM may be rejected by the plan sponsor and will not have implications on the financial deal in this proposal and subsequently executed in the contract."]
[null,"Fiduciary and clinical responsibility","Vendor assumes all fiduciary and clinical responsibility associated with ERISA appeals completed in house."]
[null,"Plan design","Vendor agrees they are willing and able to execute the plan design(s) as stated in the plan design section"]
[null,"Brand to brand conversions","Vendor agrees that brand to brand conversions will only be requested and/or executed pursuant to clinical programs elected by the plan sponsor. "]
[null,"Clinical program fees","Vendor agrees that any savings achieved from clinical programs will not shared with the vendor in addition to, or in lieu of fees collected for those programs"]
[null,"Drug utilization review","Vendor agrees that drug utilization review will be standard, and integrated across all channels (retail, mail, specialty, ect) and will include, at a minimum, the following safety edits; drug:drug interactions, drug:disease interactions, validation of dosage, age/gender edits, and monitoring for over/under utilization within a specific class of drugs."]
[null,"Specialty - Fulfillment/shipping",{"$f":"\"Should a medication be deemed unusable due to fulfillment/shipping delays or damage. The medication will be replaced by the vendor at no charge to the member or \"&B4","v":"Should a medication be deemed unusable due to fulfillment/shipping delays or damage. The medication will be replaced by the vendor at no charge to the member or Anderson County "}]
[null,"Specialty - Refills","Vendor will not auto-refill a specialty medication at anytime. Vendor will only refill a specialty medication pursuant to communication with the member where they are able to determine the subsequent fill is required, the member is responding to therapy and the subsequent fill will not harm the member."]
[null,"Specialty - New products",{"$f":"\"Vendor agrees to communicate new additions to vendor's specialty list within 30 days of FDA approval of that product. \"&B4&\" reserves the right to refuse addition to the specialty list during that notification period. \"&B4&\" reserves the right to review vendors proposed pricing (if available).\"&\" Should \"&B4&\" believe, with reasonable evidence, the pricing is not market competitive, both parties agree to renegotiate terms in good faith.\"","v":"Vendor agrees to communicate new additions to vendor's specialty list within 30 days of FDA approval of that product. Anderson County  reserves the right to refuse addition to the specialty list during that notification period. Anderson County  reserves the right to review vendors proposed pricing (if available). Should Anderson County  believe, with reasonable evidence, the pricing is not market competitive, both parties agree to renegotiate terms in good faith."}]
[null,"Bid Requirement (other)",null,"Vendor Response (drop down)","Explanation for deviation"]
[null,"Client data - privacy",{"$f":"\"Vendor agrees not to share \"&B4&\"'s data, in detail or in aggregate with out the written approval of \"&B4","v":"Vendor agrees not to share Anderson County 's data, in detail or in aggregate with out the written approval of Anderson County "}]
[null,"Client data - rights",{"$f":"\"Vendor agrees to allow \"&B4&\" access to their pharmacy claims data. While it is understood industry and trade privileged information may not be shared, it will be expected that \"&B4&\" may have access to most clinical and financial fields including  but not limited to; NDC, date of service, quantity, day supply, ingredient cost, dispensing fee, undiscounted AWP\"","v":"Vendor agrees to allow Anderson County  access to their pharmacy claims data. While it is understood industry and trade privileged information may not be shared, it will be expected that Anderson County  may have access to most clinical and financial fields including  but not limited to; NDC, date of service, quantity, day supply, ingredient cost, dispensing fee, undiscounted AWP"}]
[null,"Vendor coordination",{"$f":"B4&\" reserves the right to carve out (unbundle) portions of their benefit which could include specific drug classes. Vendor agrees to cooperate with all data sharing, analytics and coordination of benefits on behalf of \"&B4","v":"Anderson County  reserves the right to carve out (unbundle) portions of their benefit which could include specific drug classes. Vendor agrees to cooperate with all data sharing, analytics and coordination of benefits on behalf of Anderson County "}]
[null,"Specialty carve-out","Should the plan sponsor choose to contract with a specific vendor for specialty pharmacy management, adjudication and fulfillment the Vendor will provide the necessary data feeds for this transition. The vendor also agrees there will be no adjustments to non-specialty admin fees, discounts, dispensing fees and rebates in response."]
[null,"Network contracts",{"$f":"\"Vendor will allow \"&B4&\"  to contract directly with retail pharmacy(s) and will agree to administer their client-specific pricing on a pass-through basis with no revenue to the PBM derived from spread.\"","v":"Vendor will allow Anderson County   to contract directly with retail pharmacy(s) and will agree to administer their client-specific pricing on a pass-through basis with no revenue to the PBM derived from spread."}]
[null,"Class action law suits","Vendor agrees to alert the client of any drug related class action law suits which may implicate the client and/or their membership. The vendor will, at no charge, provide the client the necessary data to participate in the class."]
[null,"Termination clause","Vendor agrees the client may terminate their agreement with or without cause after notice no less than 90 days in advance"]
[null,"Vendor commitment during termination","Vendor agrees to pay all owed guarantees, rebates and penalties in the event of termination. Vendor will also provide all necessary documentation and data feeds necessary for transition. Costs incurred for this transition shall not be invoiced to client or used to offset any monies owed to the client. These data feeds include; open refill files, at least 6 months of claims data, and prior authorization records"]
[null,"Additional pharmacy related vendors","Vendor agrees to allow plan sponsor to engage and/or contract with additional vendors to augment their pharmacy benefit plan. These vendors provider additional services such as Medication Therapy Management (MTM) or member communication to drive consumerism through education around drug and/or pharmacy selection"]

{"sheet":"Additional Requests","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[1,1,1,2],[2,1,2,2],[4,1,4,2]]}
[]
[null,"Additional Requests"]
[null,{"$f":"'Bid Specifications (Other)'!B4","v":"Anderson County "}]
[]
[null,"Please provide the following documentation and/or drug lists. If these items are not available or inaccessible, please provide an explanation"]
[]
[null,"Program","Explanation"]
[null,"Prior Authorization  - Drug lists and a sample protocol"]
[null,"Step Therapy - List of classes with target and alternate drug lists"]
[null,"Specialty list"]
[null,"Preventive drug list"]
[null,"Geoaccess reporting (urban = 1mi, suburban = 5mi, rural = 15mi)"]
[null,"Formulary disruption"]