{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Estimates Table","2013Contracts&Pharmacies","Beneficiary Information","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Estimates Table","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Subpart","# Respondents (CY 2010 - 196 sponsors, 39 states, 56,000 pharmacies)","2010 Approved Estimate - Burden hours","# Respondents (CY 2013 - 211 sponsors, 39 states, 56,000 pharmacies)","# of Responses","Time per response (in hours)","2013 Revised Estimate - Burden hours","Exempt/Separate PRA"]
["J—Coordination of Part D Plans with Other Prescription Drug Coverage"]
["423.464 Coordination of Benefits"]
["Part D sponsors"]
["Revise payer systems to receive N transactions from Troop Facilitator",10,600,10,1,60,600]
["Processing claims through TrOOP facilitator (Receiving Ns)",196,5210,211,2172000,0.000138889,63651.717588]
["Entering OHI into PDP sponsor systems",196,3,211,1,0.0166,3.5026]
["Submission of Lump Sum",196,11760,211,1,60,12660]
["Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)",196,7840,211,1,40,8440]
["ATBT  exchanges and updates transactions ",196,1520,211,225075,0.000138889,6595.953193425]
["ATBT additional programming. ",196,3499,10,1,17.85,178.5]
["Pharmacies"]
["Eligibility Queries",56000,724158,56000,5500,0.0166,5112800]
["States/Secondary Payers"]
["Submission of VDSAs","n/a",null,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-0214"]
["Submission of Enrollment Files","n/a",null,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-0214"]
["State Attestations",39,78,39,1,2,78]
["Lump Sum Negotiations",2,120,2,1,60,120]
[null,57227,754788,57116,2402582,239.883477778,5205127.673381425]
[]
[]
[null,null,null,"# respondents",null,null,57116]
[null,null,null,"Ave time per response",null,null,0.4615798402576362]
[null,null,null,"Ave # responses per respondent ",null,null,42.064955529098675]
[null,null,null,"Annual # responses",null,null,2402582,{"$nulls":4},4450339.673381425]
[null,null,null,"Annual hour burden ",null,null,5205127.673381425]

{"sheet":"2013Contracts&Pharmacies","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Below are the results for 2013 Part D as of today. "]
[]
["# of Parent Organizations**",211]
[]
[]
[]
[]
[null,"39,000 chain + 17000 independent"]

{"sheet":"Beneficiary Information","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Total # Responses","# Respondents","Responses per respondent"]
["Total N transactions for all sponsors (4/2012-3/2013)  ",null,null,null,458277000,211,2171928.9099526065]
["Total  estimated ATBT transactions",null,null,null,47490800,211,225074.8815165877]
["Total Eligibility Queries",null,null,null,308000000,56000,5500]
[]
[]
[]
["Source:  Transaction Facilitation Contractor"]
[]
[]
[]
["% enrollees w/ other health insurance OHI ",0.23]
["# enrollees w/OHI",0]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}