{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["EnableMacros","Formulary Tiers","Drug Lists","Names"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"EnableMacros","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]],"flags":["formulas_cached_only"]}
["Prescription Drug Template"]
[]
[]
[]
[]
[null,"If you are seeing this sheet, macros are not enabled, please follow the following steps: "]
[]
[]
[null,"If using Excel 2003:"]
[null,"1. Set the macro security setting to Medium (Recommended) or Low.  To change the macro security setting, select Tools-> "]
[null,"       Macro->Security."]
[null,"2. If the macro security setting is set to Medium, select Enable Macros when opening the workbook."]
[]
[]
[null,"If using Excel 2007 and 2010:"]
[null,"1. Set the macro security setting to Disable macros with notifications (Recommended) or Enable all macros. To change"]
[null,"    the macro security setting, click the Office Button and select Excel Option -> Trust Center -> Trust Center Settings -> "]
[null,"    Macro Settings."]
[null,"2. If the macro security setting is set to Disable macros with notifications, click the Option button and select Enable this "]
[null,"    content."]
[]
[]
[null,"Note: This screen will flash momentarily when you save or finalize this workbook."]

{"sheet":"Formulary Tiers","index":1,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Prescription Drug Formulary Template v1.0",null,null,"Instructions: ","All fields with an asterisk (*) are required"]
[{"$nulls":4},"Enter more instructions here as they apply to this template"]
[]
[]
[]
["Issuer ID* "]
["Issuer State* "]
[]
[]
[]
["Formulary ID*","Formulary URL","Drug List ID*","Number of Tiers*","Drug Tier ID*","Drug Tier Type*","1 Month In Network Retail Pharmacy Cost Sharing Type*"," Copayment*","Coinsurance*","1 Month Out of Network Retail Pharmacy Benefit Offered?*","1 Month Out of Network Retail Pharmacy Cost Sharing Type "," Copayment ","Coinsurance ","3 Month In Network Mail Order Pharmacy Benefit Offered?*","3 Month In Network Mail Order Pharmacy Cost Sharing Type"," Copayment ","Coinsurance ","3 Month Out of Network Mail Order Pharmacy Benefit Offered?*","3 Month Out of Network Mail Order Pharmacy Cost Sharing Type "," Copayment ","Coinsurance "]
["Required:\nSelect the Formulary ID","Required:\nEnter the Formulary URL","Required:\nSelect the Drug List ID \n(from Drug Lists sheet)","Required:\nSelect the number of Tiers","Required:\nThe template will populate a Drug Tier ID 1-7","Required:\nSelect all the Drug Types included in this tier","Required:\nSelect the Cost Sharing Type","Required:\nEnter the Copayment for 1 Month In Network Retail Pharmacy","Required:\nEnter the Coinsurance for 1 Month In Network Retail Pharmacy","Required:\nDoes this tier offer 1 Month Out of Network Retail Pharmacy benefits?","Required if Offered:\nSelect the Cost Sharing Type","Required if Offered:\nEnter the Copayment for 1 Month Out of Network Retail Pharmacy","Required if Offered:\nEnter the Coinsurance for 1 Month Out of Network Retail Pharmacy","Required:\nDoes this tier offer 3 Month In Network Mail Order Pharmacy benefits?","Required if Offered:\nSelect the Cost Sharing Type","Required if Offered:\nEnter the Copayment for 3 Month In Network Mail Order","Required if Offered:\nEnter the Coinsurance for 3 Month In Network Mail Order","Required:\nDoes this tier offer 3 Month Out of Network Mail Order benefits?","Required if Offered:\nSelect the Cost Sharing Type","Required if Offered:\nEnter the Copayment for 3 Month Out of Network Mail Order","Required if Offered:\nEnter the Coinsurance for 3 Month Out of Network Mail Order"]

{"sheet":"Drug Lists","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[[5,1,5,3]],"flags":["formulas_cached_only"]}
["Drug Lists","Instructions: ","All fields with an asterisk (*) are required"]
[null,null,"Enter more instructions here as they apply to this template"]
[]
[]
[]
[null,"Drug List ID 1"]
["RXCUI*","Tier Level*","Prior Authorization Required","Step Therapy Required"]
["Required:\nEnter the RXCUI","Required:\nSelect the Tier this drug is in, or select NA if this drug is not a part of this Drug List","Required if Tier Level is not NA:\nSelect \"Yes\" if Prior Authorization is Required","Required if Tier Level is not NA:\nSelect \"Yes\" if Step Therapy is Required"]

{"sheet":"Names","index":3,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["All Generics",1,"Copayment","Yes","NA",1,null,"AK"]
["All Preferred Generics",2,"Coinsurance","No",1,null,null,"AL"]
["All Non-Preferred Generics",3,"Lesser of Copayment or Coinsurance",null,2,null,null,"AR"]
["Only Select Generics",4,"Greater of Copayment or Coisurance",null,3,null,null,"AS"]
["All Brands",5,null,null,4,null,null,"AZ"]
["All Preferred Brands",6,null,null,5,null,null,"CA"]
["All Non-Preferred Brands",7,null,null,6,null,null,"CO"]
["Only Select Brands",null,null,null,7,null,null,"CT"]
[{"$nulls":7},"DC"]
[{"$nulls":7},"DE"]
[{"$nulls":7},"FL"]
[{"$nulls":7},"FM"]
[{"$nulls":7},"GA"]
[{"$nulls":7},"GU"]
[{"$nulls":7},"HI"]
[{"$nulls":7},"IA"]
[{"$nulls":7},"ID"]
[{"$nulls":7},"IL"]
[{"$nulls":7},"IN"]
[{"$nulls":7},"KS"]
[{"$nulls":7},"KY"]
[{"$nulls":7},"LA"]
[{"$nulls":7},"MA"]
[{"$nulls":7},"MD"]
[{"$nulls":7},"ME"]
[{"$nulls":7},"MH"]
[{"$nulls":7},"MI"]
[{"$nulls":7},"MN"]
[{"$nulls":7},"MO"]
[{"$nulls":7},"MP"]
[{"$nulls":7},"MS"]
[{"$nulls":7},"MT"]
[{"$nulls":7},"NC"]
[{"$nulls":7},"ND"]
[{"$nulls":7},"NE"]
[{"$nulls":7},"NH"]
[{"$nulls":7},"NJ"]
[{"$nulls":7},"NM"]
[{"$nulls":7},"NV"]
[{"$nulls":7},"NY"]
[{"$nulls":7},"OH"]
[{"$nulls":7},"OK"]
[{"$nulls":7},"OR"]
[{"$nulls":7},"PA"]
[{"$nulls":7},"PR"]
[{"$nulls":7},"PW"]
[{"$nulls":7},"RI"]
[{"$nulls":7},"SC"]
[{"$nulls":7},"SD"]
[{"$nulls":7},"TN"]
[{"$nulls":7},"TX"]
[{"$nulls":7},"UT"]
[{"$nulls":7},"VA"]
[{"$nulls":7},"VI"]
[{"$nulls":7},"VT"]
[{"$nulls":7},"WA"]
[{"$nulls":7},"WI"]
[{"$nulls":7},"WV"]
[{"$nulls":7},"WY"]