{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Recovery Categories Defined","Line by Line Field Definitions","Summary of Waste","Q1 Details of Waste","Q2 Details of Waste","Q3 Details of Waste","Q4 Details of Waste","Drop Down Lists","Sheet1"],"not_rendered":{"images":5,"macros":1,"external_links":3,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Recovery Categories Defined","index":0,"n_rows":11,"n_cols":2,"rows_kept":11}
["Recovery Categories","Recovery Categories Defined"]
["Cost Share","Cost share is when a member does not fully meet the financial requirement for Medicaid eligibility and may pay a portion of their medical expenses each month in order to be eligible for Medicaid.  Cost Share – occurs when a patient pays for a portion of health care costs and means the recipient’s out of pocket payment to the provider for furnishing medical, allied care, goods, or services."]
["Credit Balance","Credit Balance is an onsite review of the facility’s accounting and can include identification of duplicate payments, incorrect payment errors, COB, change in hospital billing, etc."]
["Data Mining","Data mining includes contract configuration errors, fee schedule errors, incorrect billing, excessive units, inclusive billing, multiple procedure reduction errors, incorrect billing per Medicare/Medicaid guidelines, etc."]
["DRG Validation","Coding and clinical review of inpatient stay charts to determine proper DRG was billed and paid."]
["Medical Records Review","Medical Chart review to determine proper billing according to Medicare/Medicaid guidelines.  Example - SNF/IRF chart review which reviews charts to determine proper stay guidelines and billing/payment of RUGs."]
["Retroterms","Retro-termination of member eligibility."]
["Settlements","Settlements includes all recovery opportunities that MCO's Payment Integrity department (Recovery Department could not pursue due to inclusion of recovery claims within a settlement’s terms."]
["Subrogation","Recovery of monies from third party liability insurance."]
["TPL","Recovery of money where another medical insurance was primary and the MCO secondary."]
["Vendor","Recovery of money where the MCO's vendor identified improper payments or billing errors."]

{"sheet":"Line by Line Field Definitions","index":1,"n_rows":26,"n_cols":2,"rows_kept":26}
["Field Name","Description"]
["MCO Internal Tracking ID","Plan's case/audit number"]
["Date Recovery Initiated","Date recovery initiated (format MM/DD/YYYY)"]
["Reporting Quarter Initially Identified","Quarter in YYYYQQ format (ex: 2015Q1)"]
["Status of Recovery","Ongoing or completed"]
["Completion Date ","Date completed (format MM/DD/YYYY)"]
["Recovery Category","Categories:  Cost Share, Credit Balance, Data Mining, DRG Validation, Medical Records Review, Retroterms, Settlements, Subrogation, TPL, Other (define in MCO Comments)"]
["Vendor Type Associated","Indicate the type of vendor associated if applicable"]
["Provider or Recipient Indicator","Indicate whether a provider or a recipient"]
["Provider/Recipient Last Name","Provider Last Name"]
["Provider/Recipient First Name","Provider First Name"]
["Provider/Recipient Middle Initial","Providers Middle Initial"]
["Entity Name","Name of provider if business entity or group"]
["Provider Type","Provider type"]
["Zip Code","Five Digit zip code of provider or member's location where issue occurred"]
["NPI","Provider's National Provider Identifier #"]
["TIN","Provider's Tax ID #"]
["Medicaid Provider ID ","Provider Medicaid ID"]
["Preliminary Overpayment Amount Identified","Total preliminary overpayment identified through plan's audit/recovery activity"]
["Updated Overpayment Amount Identified","Updated overpayment identified through plan's audit/recovery activity if different than the preliminary amount"]
["Final Overpayment Amount Identified ","Total final overpayment identified through plan's audit/recovery activity"]
["Overpayment Amount Recovered","Total recovered from provider through plan's audit/recovery activity"]
["Overpayment Collection Method","Provider Submitted Check, Plan Initiated Withhold, Plan Initiated Recoupment, Other (define in MCO Comments)"]
["MCO Comments and Details Regarding Waste Recovery Category","All other details for an \"other\" selection made in the Waste Recovery Category field"]
["MCO Comments and Details Regarding Overpayment Collection Method","All other details for an \"other\" selection made in the Overpayment Collection Method field"]
["Other MCO Comments and Details","Free-form comments from plan for any other comments or details not included elsewhere on the report"]

{"sheet":"Summary of Waste","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[11,1,11,10],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10]]}
[]
["Reporting Period"]
["Reporting Quarter"]
["Medicaid Health Plan"]
["Medicaid Health Plan Medicaid ID(s)"]
["Vendor-Dental Name:"]
["Vendor-Vision Name:"]
["Vendor-Transportation Name:"]
["Vendor-Behavioral Health Name:"]
["Vendor-Pharmacy Name:"]
[null,{"$f":"LEFT($B$3,4)&\"Q1\"","v":"Q1"},{"$f":"LEFT($B$3,4)&\"Q2\"","v":"Q2"},{"$f":"LEFT($B$3,4)&\"Q3\"","v":"Q3"},{"$f":"LEFT($B$3,4)&\"Q4\"","v":"Q4"}]
[null,"Referral of Waste Recoveries Quarterly"]
[]
[null,"Q1",null,"Q2",null,"Q3",null,"Q4",null,"YTD"]
["Recovery Category","Final Identified $","Recovered $","Final Identified $","Recovered $","Final Identified $","Recovered $","Final Identified $","Recovered $","Final Identified $","Recovered $"]
["Cost Share",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A16, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A16,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A16, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A16,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A16, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A16,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A16, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A16,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B16,D16,F16,H16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C16,E16,G16,I16)","v":{"v":0,"d":"$0.00"}}]
["Credit Balance",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A17, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A17,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A17, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A17,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A17, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A17,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A17, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A17,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B17,D17,F17,H17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C17,E17,G17,I17)","v":{"v":0,"d":"$0.00"}}]
["Data Mining",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A18, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A18,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A18, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A18,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A18, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A18,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A18, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A18,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["DRG Validation",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A19, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A19,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A19, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A19,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A19, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A19,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A19, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A19,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Medical Records Review",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A20, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A20,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A20, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A20,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A20, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A20,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A20, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A20,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Retroterms",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A21, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A21,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A21, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A21,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A21, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A21,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A21, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A21,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Settlements",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A22, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A22,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A22, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A22,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A22, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A22,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A22, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A22,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Subrogation",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A23, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A23,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A23, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A23,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A23, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A23,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A23, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A23,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["TPL",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A24, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A24,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A24, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A24,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A24, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A24,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A24, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A24,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Other",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A25, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$F$2:$F$150000, $A25,'Q1 Details of Waste'!$G$2:$G$150000, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A25, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$F$3:$F$150001, $A25,'Q2 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A25, 'Q3 Details of Waste'!$C$3:$C$150001, $D$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$F$3:$F$150001, $A25,'Q3 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A25, 'Q4 Details of Waste'!$C$3:$C$150001, $E$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$F$3:$F$150001, $A25,'Q4 Details of Waste'!$G$3:$G$150001, \"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Vendor-Dental",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$G$2:$G$150000, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$C$3:$C$150001, $C$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$C$3:$C$150001, $C$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$G$3:$G$150001, \"Dental\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(B27,D27,F27,H27)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["Vendor-Vision",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$G$2:$G$150000, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$C$3:$C$150001, $B$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$C$3:$C$150001, $B$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$C$3:$C$150001, $B$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$G$3:$G$150001, \"Vision\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Vendor-Transportation",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$G$2:$G$150000, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$C$3:$C$150001, $C$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$C$3:$C$150001, $C$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$G$3:$G$150001, \"Transportation\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Vendor-Behavioral Health",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$G$2:$G$150000, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$C$3:$C$150001, $C$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$C$3:$C$150001, $C$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$G$3:$G$150001, \"Behavioral Health\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Vendor-Pharmacy ",{"$f":"SUMIFS('Q1 Details of Waste'!$T$2:$T$150000, 'Q1 Details of Waste'!$C$2:$C$150000, $B$11, 'Q1 Details of Waste'!$G$2:$G$150000, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q1 Details of Waste'!$U$2:$U$150000, 'Q1 Details of Waste'!$G$2:$G$150000, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$T$3:$T$150001, 'Q2 Details of Waste'!$C$3:$C$150001, $C$11, 'Q2 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q2 Details of Waste'!$U$3:$U$150001, 'Q2 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$T$3:$T$150001, 'Q3 Details of Waste'!$C$3:$C$150001, $C$11, 'Q3 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q3 Details of Waste'!$U$3:$U$150001, 'Q3 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$T$3:$T$150001, 'Q4 Details of Waste'!$C$3:$C$150001, $C$11, 'Q4 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS('Q4 Details of Waste'!$U$3:$U$150001, 'Q4 Details of Waste'!$G$3:$G$150001, \"Pharmacy\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Total",{"$f":"SUM(B16:B31)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"Q1 Details of Waste","index":3,"n_rows":1,"n_cols":25,"rows_kept":1}
["MCO Internal Tracking ID","Date Recovery Initiated","Reporting Quarter Initially Identified","Status of Recovery","Entire Project Completion Date ","Waste Recovery Category","Vendor Type Associated","Provider or Recipient Indicator","Provider/Recipient- Last Name","Provider/Recipient - First Name","Provider/Recipient Middle Initial","Entity Name","Provider Type (Under Review)","Zip Code","NPI","TIN","Medicaid Provider ID ","Preliminary Overpayment Amount  Identified","Updated Overpayment Amount Identified","Final Overpayment Amount Identified","Overpayment  Amount Recovered","Overpayment Collection Method","MCO Comments and Details Regarding Waste Recovery Category","MCO Comments and Details Regarding Overpayment Collection Method","Other MCO Comments and Details"]

{"sheet":"Q2 Details of Waste","index":4,"n_rows":1,"n_cols":25,"rows_kept":1}
["MCO Internal Tracking ID","Date Recovery Initiated","Reporting Quarter Initially Identified","Status of Recovery","Entire Project Completion Date ","Waste Recovery Category","Vendor Type Associated","Provider or Recipient Indicator","Provider/Recipient- Last Name","Provider/Recipient - First Name","Provider/Recipient Middle Initial","Entity Name","Provider Type (Under Review)","Zip Code","NPI","TIN","Medicaid Provider ID ","Preliminary Overpayment Amount  Identified","Updated Overpayment Amount Identified","Final Overpayment Amount Identified","Overpayment  Amount Recovered","Overpayment Collection Method","MCO Comments and Details Regarding Waste Recovery Category","MCO Comments and Details Regarding Overpayment Collection Method","Other MCO Comments and Details"]

{"sheet":"Q3 Details of Waste","index":5,"n_rows":1,"n_cols":25,"rows_kept":1}
["MCO Internal Tracking ID","Date Recovery Initiated","Reporting Quarter Initially Identified","Status of Recovery","Entire Project Completion Date ","Waste Recovery Category","Vendor Type Associated","Provider or Recipient Indicator","Provider/Recipient- Last Name","Provider/Recipient - First Name","Provider/Recipient Middle Initial","Entity Name","Provider Type (Under Review)","Zip Code","NPI","TIN","Medicaid Provider ID ","Preliminary Overpayment Amount  Identified","Updated Overpayment Amount Identified","Final Overpayment Amount Identified","Overpayment  Amount Recovered","Overpayment Collection Method","MCO Comments and Details Regarding Waste Recovery Category","MCO Comments and Details Regarding Overpayment Collection Method","Other MCO Comments and Details"]

{"sheet":"Q4 Details of Waste","index":6,"n_rows":1,"n_cols":25,"rows_kept":1}
["MCO Internal Tracking ID","Date Recovery Initiated","Reporting Quarter Initially Identified","Status of Recovery","Entire Project Completion Date ","Waste Recovery Category","Vendor Type Associated","Provider or Recipient Indicator","Provider/Recipient- Last Name","Provider/Recipient - First Name","Provider/Recipient Middle Initial","Entity Name","Provider Type (Under Review)","Zip Code","NPI","TIN","Medicaid Provider ID ","Preliminary Overpayment Amount  Identified","Updated Overpayment Amount Identified","Final Overpayment Amount Identified","Overpayment  Amount Recovered","Overpayment Collection Method","MCO Comments and Details Regarding Waste Recovery Category","MCO Comments and Details Regarding Overpayment Collection Method","Other MCO Comments and Details"]

{"sheet":"Drop Down Lists","index":7,"n_rows":54,"n_cols":3,"rows_kept":54,"hidden":true}
["Waste Recovery Category",null,"Provider Type (Under Review)"]
["Cost Share",null,"01 - GENERAL HOSPITAL "]
["Credit Balance",null,"05 - COMMUNITY BEHAVIORAL HEALTH SERVICES"]
["Data Mining",null,"06 - AMBULATORY HEALTH CARE FACILITY"]
["DRG Validation",null,"07 - SPECIALIZED THERAPEUTIC SERVICES"]
["Medical Records Review",null,"08 - SCHOOL DISTRICT"]
["Retroterms",null,"09 - HOSPITAL-BASED SKILLED NURSING FACILITY"]
["Settlements",null,"10 - SKILLED NURSING FACILITY"]
["Subrogation",null,"13 - RURAL HOSPITAL SWING BED FACILITY"]
["TPL",null,"14 - ASSISTIVE CARE SERVICES"]
["Other (define in MCO Comments)",null,"15 - HOSPICE"]
[null,null,"16 - RESIDENTIAL AND FREESTANDING PSYCHIATRIC FACILITY"]
["Status of Recovery",null,"20 - PHARMACY"]
["Ongoing",null,"23 - MEDICAL FOSTER CARE/ PERSONAL CARE PROVIDER"]
["Completed",null,"24 - PRESCRIBED PEDIATRIC EXTENDED CARE (PPECC)"]
[null,null,"25 - PHYSICIAN (M.D.)"]
["Provider or Recipient Indicator",null,"26 - PHYSICIAN (D.O.)"]
["Provider",null,"27 - PODIATRIST"]
["Recipient",null,"28 - CHIROPRACTOR"]
[null,null,"29 - PHYSICIAN ASSISTANT"]
["Vendor Type Associated",null,"30 - NURSE PRACTITIONER (ARNP)"]
["Dental",null,"31 - REGISTERED NURSE/REGISTERED NURSE FIRST ASSISTANT"]
["Vision",null,"32 - SOCIAL WORKER/CASE MANAGER"]
["Transportation",null,"34 - LICENSED MIDWIFE"]
["Behavioral Health",null,"35 - DENTIST"]
["Prepayment Review",null,"40 - AMBULANCE"]
["Pharmacy ",null,"41 - NON-EMERGENCY TRANSPORT"]
[null,null,"42 - AIR AMBULANCE"]
["Overpayment Collection Method",null,"43 - TAXICAB COMPANY"]
["Provider Submitted Check",null,"44 - GOVERNMENT/MUNICIPAL TRANSPORT"]
["Plan Initiated Withhold",null,"45 - PRIVATE TRANSPORTATION"]
["Plan Initiated Recoupment",null,"46 - NON-PROFIT TRANSPORTATION"]
["Other (define in MCO Comments)",null,"47 - MULTI-LOAD PRIVATE TRANSPORT"]
[null,null,"50 - INDEPENDENT LABORATORY"]
[null,null,"51 - PORTABLE X-RAY COMPANY"]
[null,null,"60 - AUDIOLOGIST"]
[null,null,"61 - HEARING AID SPECIALIST"]
[null,null,"62 - OPTOMETRIST"]
[null,null,"63 - OPTICIAN"]
[null,null,"65 - HOME HEALTH SERVICES"]
[null,null,"66 - RURAL HEALTH CLINIC"]
[null,null,"67 - HOME AND COMMUNITY BASED SERVICES WAIVER"]
[null,null,"68 - FEDERALLY QUALIFIED HEALTH CENTER"]
[null,null,"69 - BIRTH CENTER"]
[null,null,"70 - MEDICAID HEALTH PLAN"]
[null,null,"72 - PREPAID MENTAL HEALTH SERVICES"]
[null,null,"75 - VOCATIONAL REHABILITATION AGENCY"]
[null,null,"76 - DEVELOPMENTAL DISABILITY AGENCY"]
[null,null,"81 - PROFESSIONAL EARLY INTERVENTION SERVICES          "]
[null,null,"82 - PARAPROFESSIONAL EARLY INTERVENTION SERVICES"]
[null,null,"83 - THERAPIST (PT, OT, ST, RT)"]
[null,null,"89 - DIALYSIS CENTER"]
[null,null,"90 - DURABLE MED EQUIPT/ MEDICAL SUPPLIES"]
[null,null,"91 - CASE MANAGEMENT AGENCY"]

{"sheet":"Sheet1","index":8,"n_rows":50,"n_cols":1,"rows_kept":50,"hidden":true}
{"$rows_empty":49}
["Hidden Sheet"]