{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Background","General Information","Utilization Data","Unit Prices"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"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":"Background","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
["Background"]
[]
["Legislative Mandate for Data Request"]
[]
["Section 6001 (f) of the Deficit Reduction Act (DRA) requires CMS to contract with a vendor to conduct a monthly national survey of retail prescription drug prices and to report the prices to the States. These national average prices will be used as a benchmark by the States for the management of their prescription drug programs.  "]
[]
["The law requires that the States submit pricing information for the 50 most prescribed drugs so that the States' prices can be compared to the national average prices obtained from the survey. The States' pricing information will be compared and the States will be ranked.  The law also requires that States report their drug utilization rates for non-innovator multiple-source (generic) drugs, their payment rates under their State plan, and their dispensing fees. "]
[]
["This template has been developed to facilitate data collection from the States.                       "]
[]
["This Excel spreadsheet contains four (4) tabs:  Background, General Information, Utilization Data, and Unit Prices.  The first tab (this tab) provides the legislative background and mandate and requires no input from the States.  The remaining tabs each have instructions for filling in the requested information."]
{"$rows_empty":10}
["According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is 0938-XXXX.  The time required to complete this information collection is estimated to average (15 hours) per response, including the time to review instructions, search existing data resources, gather the data needed, and complete and review the information collection.  If you have comments concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to:  CMS, 7500 Security Boulevard, Attn: PRA Reports Clearance Officer, Mail Stop C4-26-05, Baltimore, Maryland 21244-1850"]

{"sheet":"General Information","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3],[20,3,20,5],[21,0,24,0],[21,1,24,1],[21,2,24,2]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,null,"         "]
["                                                                                                                       "]
{"$rows_empty":14}
["State","Pricing Source Formula","Dispensing Fee Schedule","Reference Price Source"]
[null,null,null,"Pricing Compendia","Other Pricing Source","Pricing Source Not Listed"]

{"sheet":"Utilization Data","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,0,25,1],[25,2,25,3],[25,4,25,5]],"flags":["formulas_cached_only"]}
{"$rows_empty":25}
["Single-Source Totals (S) ",null,"Non-Innovator Multi-Source Totals (N) ",null,"Innovator Multi-Source Totals (I)"]
["Number of Prescriptions","Reimbursement Amount","Number of Prescriptions","Reimbursement Amount","Number of Prescriptions","Reimbursement Amount"]

{"sheet":"Unit Prices","index":3,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[13,6,14,10],[13,11,15,11],[13,0,15,0],[13,4,15,4],[13,3,15,3],[13,5,15,5],[13,1,15,1],[13,2,15,2]],"flags":["formulas_cached_only"]}
{"$rows_empty":13}
["Rank","NDC11","Name","Strength","MMIS Pricing Unit","EAC Unit Price","EAC Pricing Source",{"$nulls":4},"Dispensing Fee"]
[]
[{"$nulls":6},"AWP","WAC","AMP","RPS","OTHER"]
[1,300304613,"PREVACID                ","30MG",null,null,false,false,false,false,false]
[2,186504031,"NEXIUM                  ","40MG",null,null,null,false,false,false]
[3,6011731,"SINGULAIR               ","10MG",null,null,null,false,false,false,false]
[4,173069600,"ADVAIR DISKUS           ","250-50MCG",null,null,false,null,null,false]
[5,6027531,"SINGULAIR               ","5MG",{"$nulls":5},false]
[6,310027210,"SEROQUEL                ","200MG",{"$nulls":5},false]
[7,50458030006,"RISPERDAL               ","1MG",{"$nulls":5},false]
[8,310027110,"SEROQUEL                ","100MG",{"$nulls":5},false]
[9,6071131,"SINGULAIR               ","4MG",{"$nulls":5},false]
[10,71015623,"LIPITOR                 ","20MG",{"$nulls":5},false]
[11,456202001,"LEXAPRO                 ","20MG",{"$nulls":5},false]
[12,88222033,"LANTUS                  ","1000U/10ML",{"$nulls":5},false]
[13,50458032006,"RISPERDAL               ","2MG",{"$nulls":5},false]
[14,310027460,"SEROQUEL                ","300MG",{"$nulls":5},false]
[15,456201001,"LEXAPRO                 ","10MG",{"$nulls":5},false]
[16,50458030206,"RISPERDAL               ","0.5MG",{"$nulls":5},false]
[17,24542131,"AMBIEN                  ","10MG",{"$nulls":5},false]
[18,310027510,"SEROQUEL                ","25MG",{"$nulls":5},false]
[19,71015523,"LIPITOR                 ","10MG",{"$nulls":5},false]
[20,173069500,"ADVAIR DISKUS           ","100-50MCG",{"$nulls":5},false]
[21,59148000813,"ABILIFY                 ","10MG",{"$nulls":5},false]
[22,59148000713,"ABILIFY                 ","5MG",{"$nulls":5},false]
[23,173064255,"LAMICTAL                ","100MG",{"$nulls":5},false]
[24,69154068,"NORVASC                 ","10MG",{"$nulls":5},false]
[25,8084181,"PROTONIX                ","40MG",{"$nulls":5},false]
[26,45064165,"TOPAMAX                 ","100MG",{"$nulls":5},false]
[27,50458033006,"RISPERDAL               ","3MG",{"$nulls":5},false]
[28,2411730,"ZYPREXA                 ","10MG",{"$nulls":5},false]
[29,2323730,"CYMBALTA                ","60MG",{"$nulls":5},false]
[30,173069700,"ADVAIR DISKUS           ","500-50MCG",{"$nulls":5},false]
[31,59148000913,"ABILIFY                 ","15MG",{"$nulls":5},false]
[32,71015723,"LIPITOR                 ","40MG",{"$nulls":5},false]
[33,2442030,"ZYPREXA                 ","20MG",{"$nulls":5},false]
[34,69553047,"ZYRTEC                  ","5MG/5ML",{"$nulls":5},false]
[35,24552131,"AMBIEN CR               ","12.5MG",{"$nulls":5},false]
[36,69153068,"NORVASC                 ","5MG",{"$nulls":5},false]
[37,69073166,"ZYRTEC                  ","10MG",{"$nulls":5},false]
[38,49399060,"GEODON                  ","80MG",{"$nulls":5},false]
[39,61958070101,"TRUVADA                 ","200-300MG",{"$nulls":5},false]
[40,6003144,"FOSAMAX                 ","70MG",{"$nulls":5},false]
[41,62192015,"ORTHO EVRA 3            ","20-150MCG/24HR",{"$nulls":5},false]
[42,78033705,"TRILEPTAL               ","300MG",{"$nulls":5},false]
[43,597007537,"SPIRIVA HANDIHALER      ","18MCG",{"$nulls":5},false]
[44,2441530,"ZYPREXA                 ","15MG",{"$nulls":5},false]
[45,59148001013,"ABILIFY                 ","20MG",{"$nulls":5},false]
[46,29315920,"AVANDIA                 ","4MG",{"$nulls":5},false]
[47,59148001113,"ABILIFY                 ","30MG",{"$nulls":5},false]
[48,64764030114,"ACTOS                   ","30MG",null,null,false,null,null,false]
[49,50474059540,"KEPPRA                  ","500MG",{"$nulls":5},false]
[50,45152550,"LEVAQUIN                ","500MG",{"$nulls":5},false]