{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Estimates Table","2010 Contracts&Pharmacies","Beneficiary Information","ATBT separate calc.","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":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Subpart","Original # Respondents","Approved 2006 Estimate - Burden Hours ","# Respondents (CY 2010 - 196 sponsors, 39 states, 56,000 pharmacies)","# of Responses","Time per response (in hours)","2010 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",370,22200,10,1,60,600]
["Processing claims through TrOOP facilitator (Receiving Ns)",370,592000,196,191377,0.000138889,5209.7113899880005]
["Entering OHI into PDP sponsor systems",370,246790,196,1,0.0166,3.2536]
["Submission of Lump Sum",370,22200,196,1,60,11760]
["Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)",null,null,196,1,40,7840]
["ATBT  exchanges and updates transactions (New CY 2009)",null,null,196,55855,0.000138889,1520.4984386200001]
["ATBT additional programming. ",null,null,196,1,17.85,3498.6000000000004]
["Pharmacies"]
["Eligibility Queries",55413,132753,56000,779,0.0166,724158.4]
["States/Secondary Payers"]
["Submission of VDSAs",636,318,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-0214"]
["Submission of Enrollment Files",636,382,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-0214"]
["State Attestations",21,10.5,39,1,2,78]
["Lump Sum Negotiations",21,1260,2,1,60,120]
[null,58207,1017913.5,57227,248018,239.883477778,754788.463428608]
[]
[]
[null,null,null,"# respondents",null,null,57227]
[null,null,null,"Ave time per response",null,null,0.3285927276542945]
[null,null,null,"Ave # responses per respondent ",null,null,4.3]
[null,null,null,"Annual # responses",null,null,248018]
[null,null,null,"Annual hour burden ",null,null,754788]

{"sheet":"2010 Contracts&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 2010 Part D as of today. "]
[]
["# of Parent Organizations**",196]
["# of PDP Contract IDs",76]
["# of MAPD Contract IDs*",584]
[]
[]
[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 (9/2007 - 10/2008)  ",null,null,null,37510000,196,191377.55102040817]
["Total  estimated ATBT transactions",null,null,null,35675000,28,1274107.142857143]
["Total Eligibility Queries",null,null,null,43550000,55855,779.6974308477307]
[]
[]
[]
["Source:  TrOOP Facilitation Contractor/Deborah Larwood"]
[]
[]
[]
["% enrollees w/ other health insurance OHI ",0.23]
["# enrollees w/OHI",0]

{"sheet":"ATBT separate calc.","index":3,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Subpart","Original # Respondents","# responses","Time per response","2006 Estimate - Burden Hours ","# Respondents (CY 2010 - 196 sponsors, 39 states)","# of Responses","Time per response (in hours)","2010 Revised Estimate - Burden hours","Exempt/Separate PRA"]
["Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)","n/a",null,null,0,196,1,40,7840]
["ATBT  exchanges and updates transactions (New CY 2009)","n/a",null,null,0,196,55855,0.000138889,1520.4984386200001]
[{"$nulls":5},392,55856,40.000138889,9360.49843862]

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