{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Estimates Table","2008 Contracts&Pharmacies","Salary Calculation","Beneficiary Information"],"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":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Subpart","Original # Respondents","2006 Estimate - Burden Hours ","# Respondents (CY 2009 - 209)","# of Responses","Time per response (in hours)","2008 Revised BurdenEstimate","Exempt/Separate PRA","Division"]
["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,209,154738,0.000138889,4491.703871138]
["Entering OHI into PDP sponsor systems",370,246790,209,1,0.0166,3.4694]
["Submission of Lump Sum",370,22200,209,1,60,12540]
["Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)","n/a","n/a",209,1,40,8360]
["ATBT  exchanges and updates transactions (New CY 2009)","n/a","n/a",209,52632,0.000138889,1527.791222232]
["Pharmacies"]
["Eligibility Queries",55413,132753,55855,1182,0.011574074074074073,764127.4305555555]
["States/Secondary Payers"]
["Submission of VDSAs",636,318,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-214","OFM"]
["Submission of Enrollment Files",636,382,"n/a","n/a","n/a",null,"Already collected for MSP purposes - Separate PRA 0938-215","OFM"]
["State Attestations",21,10.5,39,1,2,78]
["Lump Sum Negotiations",21,1260,39,1,60,2340]
[null,null,1017913.5,56988,208558,222.02845185207408,794068.3950489255]
[]
[{"$nulls":4},3.6596827402260126,null,13.933957939371895,"responses per respondent/ yr "]
[null,0.011574074074074073]

{"sheet":"2008 Contracts&Pharmacies","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Source"]
[null,"2008 Sponsors",null,"HPMS"]
[null,209,"Parent Organizations","HPMS"]
[null,87,"PDPs","HPMS"]
[null,605,"MA-PDs","HPMS"]
[]
[null,"Ave. monthly enrollment ",25.4,"HPMS"]
[]
[null,"% enrollees w/ OHI ",0.23,"See OHI tab"]
[null,"# enrollees w/OHI",5.842]
[]
[]
[]
[null,"38,934 chain pharmacies & 16,921 independents.  Total – 55,314 * Source – NACDS 2007 data."]

{"sheet":"Salary Calculation","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Subpart","# Respondents","# of Responses","Time per response (in hours)","2008 Revised Burden Estimate","GS-11/6 Hourly Rate (2008)","Estimated Cost","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,1,60,600,26.92,16152.000000000002]
["Processing claims through TrOOP facilitator (Receiving Ns)",209,154738,0.000138889,4491.703871138,26.92,120916.66821103496]
["Entering OHI into PDP sponsor systems",209,1,0.0166,3.4694,26.92,93.396248]
["Submission of Lump Sum",209,1,60,12540,26.92,337576.80000000005]
["Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)",209,1,40,8360,26.92,225051.2]
["ATBT  exchanges and updates transactions (New CY 2009)",209,52632,0.000138889,1527.791222232,26.92,41128.139702485445]
["Pharmacies"]
["Eligibility Queries",55855,1182,0.0166,1095942.126,26.92,29502762.03192]
["States/Secondary Payers"]
["Submission of VDSAs","n/a","n/a","n/a"]
["Submission of Enrollment Files","n/a","n/a","n/a"]
["State Attestations",39,1,2,78,26.92,2099.76]
["Lump Sum Negotiations",39,1,60,2340,26.92,62992.8]
[null,56988,208558,222.03347777800002,1125883.0904933698,26.92,30308772.796081524]
[{"$nulls":5},30308772.796081517]
[null,20,null,0.0010646126150902868]

{"sheet":"Beneficiary Information","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":4},"Total # Responses","# Respondents","# per Respondent"]
["Total N transactions for all sponsors (9/2007 - 10/2008)  ",null,null,null,32340162,209,154737.61722488038]
["Total  estimated ATBT transactions",null,null,null,11000000,209,52631.57894736842]
["Total Eligibility Queries",null,null,null,66067290,55855,1182.835735386268]
[]
[]
[]
["Source:  TrOOP Facilitation Contractor/Deborah Larwood"]