{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Contents","Front Page","HOS Inpatient Data","HOS Outpatient Data","Hospital List","Reference Tables","Hos IP Review","HOS IP Payments Review","HOS OP Payments Review","HOS OP Multiplier Review","HOS OP Service Review","Payers","System Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Contents","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[17,1,17,2]]}
["Payer Reporting of Relative Price"]
["Table of Contents"]
[]
[null,"Tab Name","Details"]
[null,"Front Page","Summary overview of the Workbook"]
[null,"Hos Inpatient Data","Location for data entry by submitters"]
[null,"Hos Outpatient Data","Location for data entry by submitters"]
[null,"Hospital List","Reference table with Hospitals and accompanying OrgIDs"]
[null,"Reference Tables","Lookup codes for data entry are provided here"]
[null,"Hos IP Review","Summary of inpatient payments and Case Mix by Hospital"]
[null,"HOS IP Payments Review","Summary of inpatient payments by Hospital Type"]
[null,"HOS OP Payments Review","Summary of outpatient payments by Hospital"]
[null,"HOS OP Multiplier Review","Summary of multipliers by Service Group"]
[null,"HOS OP Service Review","Summary of Service Groups reported by Hospital"]
[]
[]
[]
[null,"Workbook Color Key"]
[null,null,"User Data Entry tab"]
[null,null,"Auto-populated Field"]
[null,null,"Reference Materials"]
[null,null,"Summary of Entered Data"]
[null,null,"Identified Error"]
[null,null,"Attention Required"]

{"sheet":"Front Page","index":1,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":false,"merged":[[38,1,38,9],[39,6,39,7],[39,8,39,9],[60,1,60,9],[61,6,61,7],[61,8,61,9],[0,0,0,1],[1,0,1,1],[8,1,8,2],[18,1,18,2],[26,1,26,2]]}
["Payer Reporting of Relative Price"]
["A. File Overview and Payer Verification"]
[]
[]
[null,"Required Fields *"]
["Contact Name:  *"]
["Contact Email:  *",null,{"$f":"IF(ISBLANK(B7),\"\",IF(AND(RIGHT(B7,3)<>\"com\",RIGHT(B7,3)<>\"org\"),\"Please enter a valid email address\",\"\"))","v":""}]
[]
[null,"Table A.1: File Overview"]
[null,"Payer OrgID *",{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,1))","v":0}]
[null,"Payer Name *",{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,2))","v":"Select Payer:"}]
[null,"Risk Tool and Version *"]
[null,"Submission Year *"]
[null,"Data Year *"]
[]
[]
[]
[]
[null,"Table A.2: Data Checks"]
[null,"Hos Inpatient Data Tab",{"$f":"IF(AND('HOS Inpatient Data'!I3=\"\",'HOS Inpatient Data'!J3=\"\",'HOS Inpatient Data'!K3=\"\",'HOS Inpatient Data'!L3=\"\",'HOS Inpatient Data'!M3=\"\"), \"Please run Inpatient Data Review prior to submission\", IF((COUNTIF('HOS Inpatient Data'!I:M,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on Hos Inpatient Tab, please correct\", \"All entered data is valid\"))","v":"Please run Inpatient Data Review prior to submission"}]
[null,"Hos Outpatient Data Tab",{"$f":"IF(AND('HOS Outpatient Data'!J2=\"\",'HOS Outpatient Data'!K2=\"\",'HOS Outpatient Data'!L2=\"\",'HOS Outpatient Data'!M2=\"\",'HOS Outpatient Data'!N2=\"\",'HOS Outpatient Data'!O2=\"\",'HOS Outpatient Data'!P2=\"\"), \"Please run Outpatient Data Review prior to submission\",IF((COUNTIF('HOS Outpatient Data'!J:P,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on Hos Outpatient Tab, please correct\", \"All entered data is valid\"))","v":"Please run Outpatient Data Review prior to submission"}]
[null,"Hos IP Review",{"$f":"IF(AND('HOS Inpatient Data'!I3=\"\",'HOS Inpatient Data'!J3=\"\",'HOS Inpatient Data'!K3=\"\",'HOS Inpatient Data'!L3=\"\",'HOS Inpatient Data'!M3=\"\"), \"Please run Inpatient Data Review prior to submission\",IF((COUNTIF('Hos IP Review'!I:I,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on Hos IP Review Tab, please correct\", \"All data is valid\"))","v":"Please run Inpatient Data Review prior to submission"}]
[null,"IP Payments Review",{"$f":"IF(AND('HOS Inpatient Data'!I3=\"\",'HOS Inpatient Data'!J3=\"\",'HOS Inpatient Data'!K3=\"\",'HOS Inpatient Data'!L3=\"\",'HOS Inpatient Data'!M3=\"\"), \"Please run Inpatient Data Review prior to submission\",IF((COUNTIF('HOS IP Payments Review'!L:L,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on IP Payments Review Tab, please correct\", \"All data is valid\"))","v":"Please run Inpatient Data Review prior to submission"}]
[null,"OP Service Review",{"$f":"IF(AND('HOS Outpatient Data'!J2=\"\",'HOS Outpatient Data'!K2=\"\",'HOS Outpatient Data'!L2=\"\",'HOS Outpatient Data'!M2=\"\",'HOS Outpatient Data'!N2=\"\",'HOS Outpatient Data'!O2=\"\",'HOS Outpatient Data'!P2=\"\"), \"Please run Outpatient Data Review prior to submission\",IF((COUNTIF('HOS OP Service Review'!G:G,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on OP Service Review tab, please correct\", \"All data is valid\"))","v":"Please run Outpatient Data Review prior to submission"}]
[]
[]
[null,"Table A.3: Data Reviews Cerifications"]
[null,"Data Tab","Acknowledgement"]
[null,"I acknowledge I have reviewed the Hos Inpatient Data tab  *"]
[null,"I acknowledge I have reviewed the Hos Outpatient Data tab  *"]
[null,"I acknowledge I have reviewed the Hos Inpatient Review tab  *"]
[null,"I acknowledge I have reviewed the OP Payments Review tab  *"]
[null,"I acknowledge I have reviewed the OP Multiplier Review tab  *"]
[null,"I acknowledge I have reviewed the OP Service Review tab  *"]
[null,"RP Comments"]
[null,"Additional Comments"]
[]
[]
[null,"Table A.4: In-Network Providers (Inpatient)"]
[null,null,null,null,null,null,"Hospitals",null,"Percent of Payments"]
[null,"Insurance Category","Product Type","Total Claims Payments","Total Non-Claims Payments","Number of Hospitals","In Network *","Out of Network *","In Network *","Out of Network *"]
[null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B42)*('HOS Inpatient Data'!L:L = 'Front Page'!C42),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B43)*('HOS Inpatient Data'!L:L = 'Front Page'!C43),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B44)*('HOS Inpatient Data'!L:L = 'Front Page'!C44),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B45)*('HOS Inpatient Data'!L:L = 'Front Page'!C45),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B46)*('HOS Inpatient Data'!L:L = 'Front Page'!C46),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B47)*('HOS Inpatient Data'!L:L = 'Front Page'!C47),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B48)*('HOS Inpatient Data'!L:L = 'Front Page'!C48),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B49)*('HOS Inpatient Data'!L:L = 'Front Page'!C49),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B50)*('HOS Inpatient Data'!L:L = 'Front Page'!C50),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B51)*('HOS Inpatient Data'!L:L = 'Front Page'!C51),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B52=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B52)*('HOS Inpatient Data'!L:L = 'Front Page'!C52),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B53=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B53)*('HOS Inpatient Data'!L:L = 'Front Page'!C53),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B54)*('HOS Inpatient Data'!L:L = 'Front Page'!C54),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B55=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B55)*('HOS Inpatient Data'!L:L = 'Front Page'!C55),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B56=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B56)*('HOS Inpatient Data'!L:L = 'Front Page'!C56),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B57=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B57)*('HOS Inpatient Data'!L:L = 'Front Page'!C57),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B58=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Inpatient Data'!K:K = 'Front Page'!B58)*('HOS Inpatient Data'!L:L = 'Front Page'!C58),'HOS Inpatient Data'!A:A),'HOS Inpatient Data'!A:A)>0)))","v":""}]
[]
[]
[null,"Table A.5: In-Network Providers (Outpatient)"]
[null,null,null,null,null,null,"Hospitals",null,"Percent of Payments"]
[null,"Insurance Category","Product Type","Total Claims Payments","Total Non-Claims Payments","Number of Hospitals","In Network *","Out of Network *","In Network *","Out of Network *"]
[null,null,null,null,null,{"$f":"IF(B64=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B64)*('HOS Outpatient Data'!N:N = 'Front Page'!C64),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B65=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B65)*('HOS Outpatient Data'!N:N = 'Front Page'!C65),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B66=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B66)*('HOS Outpatient Data'!N:N = 'Front Page'!C66),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B67=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B67)*('HOS Outpatient Data'!N:N = 'Front Page'!C67),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B68=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B68)*('HOS Outpatient Data'!N:N = 'Front Page'!C68),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B69=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B69)*('HOS Outpatient Data'!N:N = 'Front Page'!C69),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B70=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B70)*('HOS Outpatient Data'!N:N = 'Front Page'!C70),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B71=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B71)*('HOS Outpatient Data'!N:N = 'Front Page'!C71),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B72=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B72)*('HOS Outpatient Data'!N:N = 'Front Page'!C72),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B73=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B73)*('HOS Outpatient Data'!N:N = 'Front Page'!C73),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B74=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B74)*('HOS Outpatient Data'!N:N = 'Front Page'!C74),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B75=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B75)*('HOS Outpatient Data'!N:N = 'Front Page'!C75),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B76=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B76)*('HOS Outpatient Data'!N:N = 'Front Page'!C76),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B77=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B77)*('HOS Outpatient Data'!N:N = 'Front Page'!C77),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B78=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B78)*('HOS Outpatient Data'!N:N = 'Front Page'!C78),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B79=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B79)*('HOS Outpatient Data'!N:N = 'Front Page'!C79),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]
[null,null,null,null,null,{"$f":"IF(B80=\"\",\"\",SUM(--(FREQUENCY(IF(('HOS Outpatient Data'!M:M = 'Front Page'!B80)*('HOS Outpatient Data'!N:N = 'Front Page'!C80),'HOS Outpatient Data'!A:A),'HOS Outpatient Data'!A:A)>0)))","v":""}]

{"sheet":"HOS Inpatient Data","index":2,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["HospitalOrgID","HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","ClaimsPayments","NonClaimsPayments","Discharges","CaseMixScore","Hospital","HospitalType","InsuranceCategory","ProductType","DataCheck"]

{"sheet":"HOS Outpatient Data","index":3,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["HospitalOrgID","HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","Service","MultiplierIndicator","Multiplier","ClaimsPayments","NonClaimsPayments","TotalPayments","Hospital","HospitalType","InsuranceCategory","ProductType","MultiplierType","Data Check"]

{"sheet":"Hospital List","index":4,"n_rows":151,"n_cols":3,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["OrgID","Hospital Name","Type"]
[1,"Anna Jaques Hospital","Acute Hospital"]
[2,"Athol Memorial Hospital","Acute Hospital"]
[5,"Baystate Franklin Medical Center","Acute Hospital"]
[4,"Baystate Medical Center","Acute Hospital"]
[106,"Baystate Noble Hospital","Acute Hospital"]
[139,"Baystate Wing Hospital","Acute Hospital"]
[6309,"Berkshire Medical Center","Acute Hospital"]
[98,"Beth Israel Deaconess Hospital - Milton","Acute Hospital"]
[53,"Beth Israel Deaconess Hospital - Needham","Acute Hospital"]
[79,"Beth Israel Deaconess Hospital - Plymouth","Acute Hospital"]
[8702,"Beth Israel Deaconess Medical Center","Acute Hospital"]
[46,"Boston Children's Hospital","Acute Hospital"]
[12661,"Boston Children's Hospital - Suburban","Acute Hospital"]
[12660,"Boston Children's Hospital - Urban","Acute Hospital"]
[3107,"Boston Medical Center","Acute Hospital"]
[59,"Brigham and Women's Faulkner Hospital","Acute Hospital"]
[22,"Brigham and Women's Hospital","Acute Hospital"]
[12665,"Brigham and Women's Hospital - Suburban","Acute Hospital"]
[12664,"Brigham and Women's Hospital - Urban","Acute Hospital"]
[3108,"Cambridge Health Alliance","Acute Hospital"]
[39,"Cape Cod Hospital","Acute Hospital"]
[50,"Cooley Dickinson Hospital","Acute Hospital"]
[51,"Dana-Farber Cancer Institute","Acute Hospital"]
[57,"Emerson Hospital","Acute Hospital"]
[8,"Fairview Hospital","Acute Hospital"]
[40,"Falmouth Hospital","Acute Hospital"]
[68,"Harrington Memorial Hospital","Acute Hospital"]
[14496,"HealthAlliance-Clinton Hospital (formerly HealthAlliance Hospital) ","Acute Hospital"]
[73,"Heywood Hospital","Acute Hospital"]
[77,"Holyoke Medical Center","Acute Hospital"]
[6546,"Lahey Hospital and Medical Center","Acute Hospital"]
[83,"Lawrence General Hospital","Acute Hospital"]
[85,"Lowell General Hospital","Acute Hospital"]
[133,"Marlborough Hospital","Acute Hospital"]
[88,"Martha's Vineyard Hospital","Acute Hospital"]
[89,"Massachusetts Eye and Ear Infirmary","Acute Hospital"]
[91,"Massachusetts General Hospital","Acute Hospital"]
[12663,"Massachusetts General Hospital - Suburban","Acute Hospital"]
[12662,"Massachusetts General Hospital - Urban","Acute Hospital"]
[3111,"MelroseWakefield Healthcare (formerly Hallmark Health)","Acute Hospital"]
[6547,"Mercy Medical Center","Acute Hospital"]
[3110,"MetroWest Medical Center","Acute Hospital"]
[97,"Milford Regional Medical Center","Acute Hospital"]
[99,"Morton Hospital - A Steward Family Hospital","Acute Hospital"]
[100,"Mount Auburn Hospital","Acute Hospital"]
[101,"Nantucket Cottage Hospital","Acute Hospital"]
[11467,"Nashoba Valley Medical Center","Acute Hospital"]
[103,"New England Baptist Hospital","Acute Hospital"]
[105,"Newton-Wellesley Hospital","Acute Hospital"]
[345,"North Shore Medical Center","Acute Hospital"]
[3112,"Northeast Hospital","Acute Hospital"]
[127,"Saint Vincent Hospital","Acute Hospital"]
[6963,"Shriners Hospitals for Children - Boston","Acute Hospital"]
[11718,"Shriners Hospitals for Children - Springfield","Acute Hospital"]
[25,"Signature Healthcare Brockton Hospital","Acute Hospital"]
[122,"South Shore Hospital","Acute Hospital"]
[3113,"Southcoast Hospitals Group","Acute Hospital"]
[42,"Steward Carney Hospital","Acute Hospital"]
[8701,"Steward Good Samaritan Medical Center","Acute Hospital"]
[75,"Steward Holy Family Hospital","Acute Hospital"]
[114,"Steward Saint Anne's Hospital","Acute Hospital"]
[126,"Steward St. Elizabeth's Medical Center","Acute Hospital"]
[129,"Sturdy Memorial Hospital","Acute Hospital"]
[104,"Tufts Medical Center","Acute Hospital"]
[12666,"Tufts Medical Center - Floating","Acute Hospital"]
[12667,"Tufts Medical Center - Non-Floating","Acute Hospital"]
[3115,"UMass Memorial Medical Center","Acute Hospital"]
[138,"Winchester Hospital","Acute Hospital"]
[1,"Anna Jaques Hospital","Acute Hospital (Psychiatric Unit)"]
[5,"Baystate Franklin Medical Center","Acute Hospital (Psychiatric Unit)"]
[4,"Baystate Medical Center","Acute Hospital (Psychiatric Unit)"]
[139,"Baystate Wing Hospital","Acute Hospital (Psychiatric Unit)"]
[6309,"Berkshire Medical Center","Acute Hospital (Psychiatric Unit)"]
[79,"Beth Israel Deaconess Hospital - Plymouth","Acute Hospital (Psychiatric Unit)"]
[8702,"Beth Israel Deaconess Medical Center","Acute Hospital (Psychiatric Unit)"]
[46,"Boston Children's Hospital","Acute Hospital (Psychiatric Unit)"]
[59,"Brigham and Women's Faulkner Hospital","Acute Hospital (Psychiatric Unit)"]
[3108,"Cambridge Health Alliance","Acute Hospital (Psychiatric Unit)"]
[39,"Cape Cod Hospital","Acute Hospital (Psychiatric Unit)"]
[50,"Cooley Dickinson Hospital","Acute Hospital (Psychiatric Unit)"]
[57,"Emerson Hospital","Acute Hospital (Psychiatric Unit)"]
[3111,"Hallmark Health","Acute Hospital (Psychiatric Unit)"]
[68,"Harrington Memorial Hospital","Acute Hospital (Psychiatric Unit)"]
[14496,"HealthAlliance-Clinton Hospital (formerly HealthAlliance Hospital)","Acute Hospital (Psychiatric Unit)"]
[73,"Heywood Hospital","Acute Hospital (Psychiatric Unit)"]
[77,"Holyoke Medical Center","Acute Hospital (Psychiatric Unit)"]
[133,"Marlborough Hospital","Acute Hospital (Psychiatric Unit)"]
[91,"Massachusetts General Hospital","Acute Hospital (Psychiatric Unit)"]
[6547,"Mercy Medical Center","Acute Hospital (Psychiatric Unit)"]
[118,"Mercy Medical Center - Providence Behavioral Health Hospital Campus","Acute Hospital (Psychiatric Unit)"]
[3110,"MetroWest Medical Center","Acute Hospital (Psychiatric Unit)"]
[99,"Morton Hospital - A Steward Family Hospital","Acute Hospital (Psychiatric Unit)"]
[100,"Mount Auburn Hospital","Acute Hospital (Psychiatric Unit)"]
[11467,"Nashoba Valley Medical Center","Acute Hospital (Psychiatric Unit)"]
[105,"Newton-Wellesley Hospital","Acute Hospital (Psychiatric Unit)"]
[106,"Noble Hospital","Acute Hospital (Psychiatric Unit)"]
[345,"North Shore Medical Center","Acute Hospital (Psychiatric Unit)"]
[3112,"Northeast Hospital","Acute Hospital (Psychiatric Unit)"]
[127,"Saint Vincent Hospital","Acute Hospital (Psychiatric Unit)"]
[25,"Signature Healthcare Brockton Hospital","Acute Hospital (Psychiatric Unit)"]
[42,"Steward Carney Hospital Inc","Acute Hospital (Psychiatric Unit)"]
[8701,"Steward Good Samaritan Medical Center","Acute Hospital (Psychiatric Unit)"]
[75,"Steward Holy Family Hospital Inc","Acute Hospital (Psychiatric Unit)"]
[114,"Steward Saint Anne's Hospital Inc","Acute Hospital (Psychiatric Unit)"]
[126,"Steward St.Elizabeth's Medical Center","Acute Hospital (Psychiatric Unit)"]
[104,"Tufts Medical Center","Acute Hospital (Psychiatric Unit)"]
[3115,"UMass Memorial Medical Center","Acute Hospital (Psychiatric Unit)"]
[414,"Curahealth Stoughton","Chronic Care Hospital"]
[407,"Franciscan Hospital for Children","Chronic Care Hospital"]
[416,"Hebrew Rehabilitation Center","Chronic Care Hospital"]
[429,"Lemuel Shattuck Hospital","Chronic Care Hospital"]
[410,"New England Sinai Hospital","Chronic Care Hospital"]
[430,"Pappas Rehabilitation Hospital for Children","Chronic Care Hospital"]
[405,"Spaulding Hospital Cambridge","Chronic Care Hospital"]
[408,"Vibra Hospital of Western Massachusetts","Chronic Care Hospital"]
[12672,"Vibra Hospital of Western Massachusetts - Central Campus","Chronic Care Hospital"]
[432,"Western Massachusetts Hospital","Chronic Care Hospital"]
[454,"AdCare Hospital of Worcester","Psychiatric Hospital"]
[442,"Arbour Hospital","Psychiatric Hospital"]
[436,"Arbour-Fuller Hospital","Psychiatric Hospital"]
[438,"Arbour-HRI Hospital","Psychiatric Hospital"]
[434,"Austen Riggs Center","Psychiatric Hospital"]
[435,"Baldpate Hospital","Psychiatric Hospital"]
[443,"Bournewood Hospital","Psychiatric Hospital"]
[424,"Cape Cod and The Islands Mental Health Center","Psychiatric Hospital"]
[422,"Corrigan Mental Health Center","Psychiatric Hospital"]
[13185,"High Point Hospital","Psychiatric Hospital"]
[16580,"Hospital for Behavioral Medicine","Psychiatric Hospital"]
[429,"Lemuel Shattuck Hospital","Psychiatric Hospital"]
[12674,"Massachusetts Mental Health Center","Psychiatric Hospital"]
[445,"McLean Hospital","Psychiatric Hospital"]
[10358,"Pembroke Hospital","Psychiatric Hospital"]
[13125,"Southcoast Behavioral Hospital","Psychiatric Hospital"]
[13237,"Taravista Behavioral Health Center","Psychiatric Hospital"]
[8880,"Walden Behavioral Care ","Psychiatric Hospital"]
[14491,"Westborough Behavioral Healthcare Hospital","Psychiatric Hospital"]
[437,"Westwood Lodge","Psychiatric Hospital"]
[10665,"Whittier Pavilion","Psychiatric Hospital"]
[428,"Worcester State Hospital","Psychiatric Hospital"]
[452,"Braintree Rehabilitation Hospital","Rehabilitation Hospital"]
[447,"Healthsouth Fairlawn Rehabilitation Hospital","Rehabilitation Hospital"]
[453,"HealthSouth Rehabilitation Hospital of Western Massachusetts","Rehabilitation Hospital"]
[6749,"New Bedford Rehabilitation Hospital","Rehabilitation Hospital"]
[451,"New England Rehabilitation Hospital","Rehabilitation Hospital"]
[12059,"NorthEast Rehabilitation Hospital","Rehabilitation Hospital"]
[450,"Spaulding Rehabilitation Hospital Boston","Rehabilitation Hospital"]
[1471,"Spaulding Rehabilitation Hospital Cape Cod","Rehabilitation Hospital"]
[431,"Tewksbury Hospital","Rehabilitation Hospital"]
[449,"Whittier Rehab Hospital Bradford","Rehabilitation Hospital"]
[4062,"Whittier Rehab Hospital Westborough","Rehabilitation Hospital"]

{"sheet":"Reference Tables","index":5,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Relative Price Submission"]
["Reference Tables"]
[]
[]
[null,"Table E.1 - Hospital Types"]
[null,"Hospital Type Code","Description"]
[null,1,"Acute Hospital"]
[null,2,"Psychiatric or Substance Abuse Hospital or Acute Hospital Behavioral Health only"]
[null,3,"Chronic Hospital"]
[null,4,"Rehabilitation Hospital"]
[]
[]
[null,"Table E.2 - Insurance Categories"]
[null,"Insurance Category Code ","Description"]
[null,1,"Medicare Advantage"]
[null,2,"Medicaid MCO/ACO-A"]
[null,3,"Commercial (self and fully insured)"]
[null,4,"SCO"]
[null,5,"OneCare"]
[null,6,"Other"]
[]
[]
[null,"Table E.3 - Product Types"]
[null,"Product Type Code","Description"]
[null,1,"HMO and POS"]
[null,2,"PPO"]
[null,3,"Indemnity"]
[null,4,"Other"]
[]
[]
[null,"Table E.4 - Multiplier Indicators"]
[null,"Service Multiplier Indicator","Description"]
[null,1,"Negotiated multiplier (not calculated)"]
[null,2,"Calculated payment-derived multiplier"]
[null,3,"Standard per unit rate "]

{"sheet":"Hos IP Review","index":6,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Total Payments and Case Mix counts reported for each Hospital"]
[]
["Table F.1: Inpatient Payments and Case Mix"]
["HospitalOrgID","HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","Sum of ClaimsPayments","Sum of NonClaimsPayments","Sum of Total Payments","Count of CaseMixScore","Data Check"]

{"sheet":"HOS IP Payments Review","index":7,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Please review the Total Payments reported for each Hospital"]
[null,null,null,null,null,null,null,"Data Check"]
["Table G.1: Inpatient Payments by Hospital Type",null,null,null,null,null,null,{"$f":"IF(E2<>2,\"\",IF(AND(E3>D3,D3>0),\"ERROR: Acute Total Payments must be greater than Psych Total Payments\"))","v":""}]
["Sum of Total Payments",null,null,"HospitalTypeCode"]
["HospitalOrgID","InsuranceCategoryCode","ProductTypeCode","Column1",null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"HOS OP Payments Review","index":8,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Total Payments reported for each Hospital"]
[]
["Table H.1: Total Outpatient Payments by Hospital"]
["HospitalOrgID","HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","Sum of ClaimsPayments","Sum of NonClaimsPayments","Sum of Total Payments"]

{"sheet":"HOS OP Multiplier Review","index":9,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Range of Multipliers reported for each Service"]
[]
["Table I.1: Summary of Multipliers by Service"]
["HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","Service","Max of Multiplier","Min of Multiplier","Average of Multiplier","Max of Total Payments","Min of Total Payments","Average of Total Payments"]

{"sheet":"HOS OP Service Review","index":10,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Services reported for each Hospital"]
[]
["Table J.1: List of Services per Hospital"]
["HospitalOrgID","HospitalTypeCode","InsuranceCategoryCode","ProductTypeCode","Service","Count of Multiplier","Data Review"]

{"sheet":"Payers","index":11,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["OrgID","Payer Name","ShortName"]
[null,"Select Payer:","Select Payer:"]
[290,"Aetna Health Inc. (PA) - Aetna Life Ins. Co. (ALIC)","Aetna"]
[291,"Blue Cross Blue Shield of Massachusetts","BCBS"]
[296,"Fallon Community Health Plan","Fallon"]
[300,"Harvard Pilgrim Health Care","HPHC"]
[301,"Health New England, Inc.","HNE"]
[308,"Tufts Associated Health Maintenance Organization, Inc.","THP"]
[310,"UniCare Life and Health Insurance Company","Unicare"]
[312,"United Healthcare Insurance Company","United"]
[3156,"MassHealth","MassHealth"]
[3735,"Mass General Brigham Health Plan, Inc.","MGBHP"]
[12103,"Tufts Medicare Advantage","TuftsMedicare"]
[10728,"Commonwealth Care Alliance","CCA"]
[10926,"United Healthcare Insurance Company - Medicare Advantage","UnitedMedicare"]
[11226,"WellSense Health Plan","WellSense"]
[11227,"Network Health, LLC  (Medicaid MCO)","THPP"]
[11474,"CIGNA Health and Life Insurance Company (CHLIC)","Cigna"]
[12814,"United Healthcare Insurance - Medicare & Retirement (SCO)","UnitedSCO"]

{"sheet":"System Data","index":12,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[true,"OnSaveFlag",{"$f":"ROWS(_xlfn._xlws.FILTER('Hospital List'!A:B,('Hospital List'!A:A<>\"\")+('Hospital List'!B:B<>\"\")))","v":151},"HosCount"]
[1,"iPayer",{"$f":"ROWS(_xlfn._xlws.FILTER('HOS Inpatient Data'!A:H,('HOS Inpatient Data'!A:A<>\"\")+('HOS Inpatient Data'!B:B<>\"\")+('HOS Inpatient Data'!C:C<>\"\")+('HOS Inpatient Data'!D:D<>\"\")+('HOS Inpatient Data'!E:E<>\"\")+('HOS Inpatient Data'!F:F<>\"\")+('HOS Inpatient Data'!G:G<>\"\")+('HOS Inpatient Data'!H:H<>\"\")))+1","v":2},"IP Row"]
[{"$f":"A4&\"_\"&A5&\"_\"&A6&\"_\"&A7&\"_\"&A8&\".xlsm\"","v":"0_Select Payer:_0_116_HOS.xlsm"},"vFileName",{"$f":"ROWS(_xlfn._xlws.FILTER('HOS Outpatient Data'!A:I,('HOS Outpatient Data'!A:A<>\"\")+('HOS Outpatient Data'!B:B<>\"\")+('HOS Outpatient Data'!C:C<>\"\")+('HOS Outpatient Data'!D:D<>\"\")+('HOS Outpatient Data'!E:E<>\"\")+('HOS Outpatient Data'!F:F<>\"\")+('HOS Outpatient Data'!G:G<>\"\")+('HOS Outpatient Data'!H:H<>\"\")+('HOS Outpatient Data'!I:I<>\"\")))+1","v":2},"OP Row"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,1))","v":0},"vPayerOrgID",{"$f":"ROWS(_xlfn._xlws.FILTER('HOS IP Payments Review'!A:A,'HOS IP Payments Review'!A:A<>\"\"))+1","v":5},"IP Payments Review Row"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,3))","v":"Select Payer:"},"vPayerShortName"]
[{"$f":"'Front Page'!C13","v":0},"vYear"]
[116,"FilingTypeID"]
["HOS","TemplateType"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(AND(A20=TRUE,A40=TRUE),TRUE,FALSE)","v":false},"cfAllFrontPageRequriedFields"]
[{"$f":"IF(AND(A21=TRUE,A22=TRUE,A24=TRUE,A25=TRUE,A26=TRUE,A27=TRUE,A28=TRUE),TRUE,FALSE)","v":false},"A. FrontPage WorkSheet"]
[{"$f":"IF('Front Page'!B6=\"\",  FALSE, TRUE)","v":false},"vContactName"]
[{"$f":"IF(OR('Front Page'!B7=\"\",'Front Page'!C7=\"Please enter a valid email address\"),FALSE,TRUE)","v":false},"vContactEmail"]
[null,"cfFrontPageTableA1RequiredFields"]
[{"$f":"IF(OR('Front Page'!C10=\"\",'Front Page'!C10=0),FALSE,TRUE)","v":false},"vPayerOrgID"]
[{"$f":"IF(OR('Front Page'!C11=\"\",'Front Page'!C11=\"Select Payer:\"),FALSE,TRUE)","v":false},"vPayerName"]
[{"$f":"IF('Front Page'!C12=\"\",FALSE,TRUE)","v":false},"vRiskTool&Version"]
[{"$f":"IF('Front Page'!C13=\"\",FALSE,TRUE)","v":false},"vSubmissionYear"]
[{"$f":"IF('Front Page'!C14=\"\",FALSE,TRUE)","v":false},"vDataYear"]
[]
[]
[{"$f":"IF(AND(A32=TRUE,A33=TRUE,A34=TRUE,A35=TRUE,A36),TRUE,FALSE)","v":false},"cfFrontPageTableA2RequiredFields"]
[{"$f":"IF(OR(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C20)), ISNUMBER(SEARCH(\"All data is valid\",'Front Page'!C20))), TRUE,FALSE)","v":false},"vHosInpatientDataTab"]
[{"$f":"IF(OR(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C21)), ISNUMBER(SEARCH(\"All data is valid\",'Front Page'!C21))), TRUE,FALSE)","v":false},"vHosOutpatientDataTab"]
[{"$f":"IF(OR(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C22)), ISNUMBER(SEARCH(\"All data is valid\",'Front Page'!C22))), TRUE,FALSE)","v":false},"vHosInpatientReview"]
[{"$f":"IF(OR(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C23)), ISNUMBER(SEARCH(\"All data is valid\",'Front Page'!C23))), TRUE,FALSE)","v":false},"vIPPaymentsReview"]
[{"$f":"IF(OR(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C24)), ISNUMBER(SEARCH(\"All data is valid\",'Front Page'!C24))), TRUE,FALSE)","v":false},"vOPServiceReview"]
[]
[]
[]
[{"$f":"IF(AND(A41=TRUE,A42=TRUE,A43=TRUE,A44=TRUE,A45=TRUE,A46=TRUE),TRUE,FALSE)","v":false},"cfFrontPageTableA3RequiredFields"]
[{"$f":"IF('Front Page'!C29=\"\", FALSE, TRUE)","v":false},"vAcknowledgeHosInpatientDataTab"]
[{"$f":"IF('Front Page'!C30=\"\", FALSE, TRUE)","v":false},"vAcknowledgeHosOutpatientDataTab"]
[{"$f":"IF('Front Page'!C31=\"\", FALSE, TRUE)","v":false},"vAcknowledgeHosInpatientReviewTab"]
[{"$f":"IF('Front Page'!C32=\"\", FALSE, TRUE)","v":false},"vOPPaymentsReviewTab"]
[{"$f":"IF('Front Page'!C33=\"\", FALSE, TRUE)","v":false},"vOPPaymentsMultiplierReviewTab"]
[{"$f":"IF('Front Page'!C34=\"\", FALSE, TRUE)","v":false},"vOPServiceReviewTab"]