{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Front Page","Physician Group Data","Physician Group List","Reference Tables","Payments Review","Multiplier Review","Service Review","Payers","System Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[14,1,14,2]]}
["Payer Reporting of Relative Price"]
["Table of Contents"]
[]
[null,"Tab Name","Details"]
[null,"Front Page","Summary overview of the Workbook"]
[null,"Physician Group Data","Location for data entry by submitters"]
[null,"Physician Group List","Reference table with Physician Groups and accompanying OrgIDs"]
[null,"Reference Tables","Lookup codes for data entry are provided here"]
[null,"Payments Review","Summary of payments by Physician Group"]
[null,"Multiplier Review","Summary of multipliers by Service Group"]
[null,"Service Review","Summary of Service Groups reported by Physician Group"]
[]
[]
[]
[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":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[33,5,33,6],[33,7,33,8],[32,1,32,8],[0,0,0,1],[1,0,1,1],[8,1,8,2],[22,1,22,2],[17,1,17,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\"),\"ERROR: 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,"Submission Year *"]
[null,"Data Year *"]
[]
[]
[]
[]
[null,"Table A.2: Data Checks"]
[null,"Physician Group Data Tab",{"$f":"IF(AND('Physician Group Data'!K3=\"\",'Physician Group Data'!L3=\"\",'Physician Group Data'!M3=\"\",'Physician Group Data'!N3=\"\",'Physician Group Data'!O3=\"\",'Physician Group Data'!P3=\"\",'Physician Group Data'!Q3=\"\"), \"Please run Data Review prior to submission\", IF((COUNTIF('Physician Group Data'!K:Q,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on Physician Group Data Tab, please correct\", \"All entered data is valid\"))","v":"Please run Data Review prior to submission"}]
[null,"Service Review Tab",{"$f":"IF(AND('Physician Group Data'!K3=\"\",'Physician Group Data'!L3=\"\",'Physician Group Data'!M3=\"\",'Physician Group Data'!N3=\"\",'Physician Group Data'!O3=\"\",'Physician Group Data'!P3=\"\",'Physician Group Data'!Q3=\"\"), \"Please run Data Review prior to submission\", IF((COUNTIF('Service Review'!H:H,\"*\"&\"ERROR\"&\"*\")>0)=TRUE, \"Errors identified on Service Review Tab, please correct\", \"All entered data is valid\"))","v":"Please run Data Review prior to submission"}]
[]
[]
[null,"Table A.3: Data Review Certifications"]
[null,"Data Tab","Acknowledgement"]
[null,"I acknowledge that I have reviewed the Physician Group Data tab  *"]
[null,"I acknowledge that I have reviewed the Payments Review tab *"]
[null,"I acknowledge that I have reviewed the Multiplier Review tab *"]
[null,"I acknowledge that I have reviewed the Service Review tab *"]
[null,"RP Comments"]
[null,"Additional Comments"]
[]
[]
[null,"Table A.4: In-Network Providers"]
[null,null,null,null,null,"Providers",null,"Percent of Payments"]
[null,"Insurance Category","Product Type","Total Payments","Number of Provider Groups","In Network *","Out of Network *","In Network *","Out of Network *"]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B36)*('Physician Group Data'!O:O = 'Front Page'!C36),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B37=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B37)*('Physician Group Data'!O:O = 'Front Page'!C37),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B38=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B38)*('Physician Group Data'!O:O = 'Front Page'!C38),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B39=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B39)*('Physician Group Data'!O:O = 'Front Page'!C39),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B40=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B40)*('Physician Group Data'!O:O = 'Front Page'!C40),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B41=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B41)*('Physician Group Data'!O:O = 'Front Page'!C41),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B42)*('Physician Group Data'!O:O = 'Front Page'!C42),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B43)*('Physician Group Data'!O:O = 'Front Page'!C43),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B44)*('Physician Group Data'!O:O = 'Front Page'!C44),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B45=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B45)*('Physician Group Data'!O:O = 'Front Page'!C45),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B46=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B46)*('Physician Group Data'!O:O = 'Front Page'!C46),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B47=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B47)*('Physician Group Data'!O:O = 'Front Page'!C47),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B48=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B48)*('Physician Group Data'!O:O = 'Front Page'!C48),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B49=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B49)*('Physician Group Data'!O:O = 'Front Page'!C49),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]
[null,null,null,null,{"$f":"IF(B50=\"\",\"\",SUM(--(FREQUENCY(IF(('Physician Group Data'!N:N = 'Front Page'!B50)*('Physician Group Data'!O:O = 'Front Page'!C50),'Physician Group Data'!A$1:A$2),'Physician Group Data'!A$1:A$2)>0)))","v":""}]

{"sheet":"Physician Group Data","index":2,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ProviderGroupOrgID","LocalPracticeOrgID","InsuranceCategoryCode","ProductTypeCode","PediatricIndicator","Service","MultiplierIndicator","Multiplier","ClaimsPayments","NonClaimsPayments","TotalPayments","ProviderGroup","LocalPracticeGroup","InsuranceCategory","ProductType","MultiplierType","DataChecks"]

{"sheet":"Physician Group List","index":3,"n_rows":547,"n_cols":8,"rows_kept":547,"cut":false,"hidden":false,"merged":[]}
["OrgID","Physician Group",null,null,null,null,"Unique","All"]
[20220,"AbleTo Behavioral Health Services, P.C.",null,null,null,null,{"$f":"COUNT(_xlfn.UNIQUE(A:A))","v":546},{"$f":"COUNT(A:A)","v":546}]
[20229,"Accredo Health Group, Inc."]
[20214,"Achieve TMS Centers East"]
[10910,"Acton Medical Associates"]
[20271,"Acton Urgent Care"]
[11799,"Adams Internists, P.C."]
[12121,"Advanced Berkshire Medical Imaging, PC"]
[17761,"AFC Urgent Care"]
[10995,"Affiliated Pediatric Practices (APP)"]
[999999,"Aggregate Physicians Paid on a Fee Schedule"]
[20252,"All About Women"]
[12727,"Allergy and Asthma Physicians Pc"]
[11764,"Allied Pediatrics of Greater Brockton, Inc."]
[20253,"AMAC Neurology & Sleep Medicine LLC"]
[20272,"Ambulatory Employee Industrial Occupational & Urgent"]
[21797,"American Renal Management, LLC"]
[11610,"American Specialty Health (ASHN)"]
[21800,"AMR of Massachusetts"]
[20077,"Amwell Medical Group"]
[11857,"Anaesthesia Associates of Massachusetts, P.C."]
[19854,"Anchor Medical Group and Wellness Center, LLC"]
[11861,"Andover OB/GYN Associates, P.C."]
[20563,"Anesthesia Dynamics LLC"]
[20061,"Anesthesia Professionals"]
[20564,"Apple Medical Clinics Ma"]
[286,"ARC Worcester Center d/b/a Worcester Surgical Center"]
[20254,"Associated Physicians of HMFP of BIDMC/Hospitalist"]
[11491,"Associates in Internal Medicine"]
[20569,"Athletic Edge Physical Therapy"]
[10962,"Athol Memorial Hospital Physicians"]
[20223,"ATI Physical Therapy"]
[20255,"Atlantic Anesthesia P.C."]
[20579,"Atlantic Urology Clinics, LLC"]
[9995,"Atrius Health"]
[20038,"Bay State Eye Care"]
[12452,"Bay State Medical Associates PC"]
[20557,"Bay State Physical Therapy of Randolph"]
[8643,"Baycare Health Partners"]
[12109,"Baycare Health Partners, Inc. Adult Practices"]
[11774,"Baycare Health Partners, Inc. Pediatric Practices"]
[3258,"Baystate Brightwood Health Center"]
[19897,"Baystate Health Urgent Care "]
[11490,"Baystate Medical Practice"]
[14417,"Baystate Westfield Medical Corporation"]
[16655,"Behavioral Healthcare Services"]
[20558,"Bellefonte Anesthesia Psc"]
[19896,"Bellingham Urgent Care"]
[11405,"Belmont Medical Associates, Inc."]
[11794,"Berkshire Faculty Services"]
[11897,"Berkshire Health System Physicians"]
[3106,"Berkshire Health Systems"]
[11797,"Berkshire Medical Group, P.C."]
[12118,"Berkshire Orthopedic Associates"]
[10967,"Berkshire Pediatric Assoc"]
[10968,"Beth Israel Deaconess Care Organization (BIDCO)"]
[11894,"Beth Israel Deaconess Physician Organization - Boston"]
[20273,"Beth Israel Deaconess Urgent Care Center at Chelsea"]
[20274,"Beth Israel Deaconess Urgent Care Center At Chestnut Hill"]
[16665,"Beth Israel Lahey Health"]
[20276,"Beth Israel Lahey Health - Urgent Care Dedham"]
[20275,"Beth Israel Lahey Urgent Care"]
[20049,"Bethel Medical Group"]
[9691,"Beverly Anesthesia Associates"]
[12708,"Binney Medical Associates"]
[18790,"Blue Hill Adult Day Health Center"]
[16656,"Boneguard Orthopedics P.C."]
[12450,"Boston Emergency Physicians Foundation Inc"]
[20234,"Boston Eye Group, P.C."]
[17745,"Boston Foundation For Sight"]
[11895,"Boston IVF"]
[9667,"Boston MedFlight"]
[10969,"Boston Medical Center Mgt Service"]
[20570,"Boston Physical Therapy and Wellnes"]
[20053,"Boston Plastic and Oral Surgery"]
[21796,"Boston Public Health Comission-EMS"]
[20590,"Boston Sports Medicine, Inc."]
[9953,"Boston University Cardiac and Thoracic Surgical Foundation, Inc."]
[9954,"Boston University Dermatology, Inc."]
[9952,"Boston University Eye Associates, Inc."]
[9936,"Boston University Family Medicine, Inc."]
[9949,"Boston University General Surgical Associates, Inc."]
[9941,"Boston University Medical Center Radiologists, Inc."]
[9951,"Boston University Psychiatry Associates, Inc."]
[11,"Bowdoin Street Health Center"]
[9382,"Bridgewater Goddard Park Medical Associates"]
[10996,"Brigham and Women's Physicians Organization"]
[11765,"Brockton Area Primary Care, LLC"]
[20044,"Brockton Pediatrics, Inc."]
[20277,"Cambridge Health Alliance - Somerville Urgent Care Center"]
[8747,"Cambridge Health Alliance Physician Organization"]
[17752,"CAP Anesthesia, P.C."]
[11414,"Cape Ann Medical Center Physician Group"]
[20256,"Cape Cod Anesthesia Assoc Inc"]
[12459,"Cape Cod Emergency Associates LLC"]
[11812,"Cape Cod Preferred Physicians"]
[20057,"Cape Obstetrics Midwifery Gynecology PC"]
[11768,"Cape Physicians, LLC"]
[21834,"Carbon Health Medical Group- urgent care center"]
[19977,"Carecentral Urgent Care"]
[20230,"Caremark LLC"]
[12716,"CareWell Urgent Care"]
[125,"Caring Health Center, Inc."]
[11059,"Carney IPA"]
[9323,"CD Practice Associates"]
[20015,"Center for Brain Health"]
[10975,"CentMass Association of Physicians"]
[10971,"Central Massachusetts Independent Physician Assoc. (CMIPA)"]
[20066,"CH Neurology Foundation, Inc."]
[80,"Charles River Community Health"]
[10997,"Charles River Medical Associates, P.C."]
[11781,"Chestnut Medical Associates, Inc."]
[20050,"Child and Family Psychological Services,"]
[12019,"Child Health Associates"]
[12085,"Children's Health Care"]
[12043,"Children's Hospital Pediatric Associates"]
[12042,"Children's Hospital Physicians"]
[20045,"Children's Orthopaedic Surgery Foundatio"]
[11498,"CHMC Anesthesia Foundation, Inc."]
[19902,"Circle Health Urgent Care, LLC  "]
[20070,"Circle of Life Family Medicine"]
[20064,"Clear Vision Eye Center"]
[13120,"Coastal Medical Associates"]
[20042,"Coastal Orthopedic Associates Inc"]
[17,"Codman Square Health Center"]
[20278,"Codman Square Urgent Care"]
[19949,"Column Health"]
[20236,"Commonwealth Anesthesia A"]
[20548,"Commonwealth Diagnostics Inc"]
[20091,"Commonwealth Eyecare Professionals, LLC"]
[11856,"Commonwealth Hematology-Oncology, PC"]
[11860,"Commonwealth Radiology Associates"]
[6798,"Community Health Center of Cape Cod"]
[3104,"Community Health Center of Franklin County, Inc."]
[4051,"Community Health Connections - Fitchburg"]
[9416,"Community Health Programs"]
[13118,"Community Medical Associates"]
[20046,"Community Pediatrics of Milford"]
[11761,"Community Physicians Associates"]
[10998,"Compass Medical, P.C."]
[9357,"Concentra Health Services"]
[12701,"Confidence Connection Corporation"]
[20033,"Congenial Healthcare LLC"]
[11811,"Connecticut River Internists"]
[12947,"Contemporary Rheumatology"]
[20284,"ConvenientMD"]
[12159,"Cooley Dickinson PHO"]
[20279,"Cooley Dickinson Urgent Care"]
[20228,"Crossover Health Medical Group"]
[19858,"Crown OB/GYN"]
[20554,"D.R.A.C. P.T."]
[20094,"D'Ambrosio Eye Care Inc."]
[12956,"Dana-Farber Cancer Care Network"]
[20082,"David Menon Corporation"]
[10963,"Dedham Medical Associates"]
[20562,"Dellaria, Justine"]
[20572,"Dermatology Center in the Berkshire"]
[20079,"Dermatology Professionals LLC"]
[20571,"DG Physical Therapy P.C. dba Select"]
[55,"Dimock Community Health Center"]
[12715,"Doctors Express - Springfield"]
[18,"Dorchester House Multi-Service Center"]
[20043,"Dowd Medical Associates"]
[20587,"Dufer LLLC"]
[21805,"Ear, Nose & Throat Surgeons of Western New England, LLC"]
[19,"East Boston Neighborhood Health Center"]
[63,"Edward M. Kennedy Community Health Center, Inc."]
[20552,"Edwards, Thomas B"]
[20267,"Elliott Physical Therapy"]
[20257,"Elm Tree Clinic LLC"]
[11402,"Emerald Physician Services, Inc."]
[12455,"Emergency Medicine Solutions LLC"]
[10999,"Emerson Hospital And Emerson PHO"]
[17730,"Encompass Health Corporation"]
[11782,"Endocrine Associates of Western Mass"]
[21804,"ENT Specialists, Inc."]
[11916,"Essex County OB/GYN Associates"]
[20069,"Essex Inpatient Physicians"]
[9950,"Evans Medical Foundation, Inc."]
[20213,"Evolve Health, LLC"]
[12150,"Experience Wellness Centers, LLC"]
[20078,"Eye Health Associates Inc"]
[18766,"Eye Health Services"]
[20040,"Fairview Hospital ER Physicians"]
[11382,"Fairview Pediatrics, LLC"]
[11406,"Family Medical Associates LLC"]
[10973,"Family Practice Associates"]
[60,"Fenway Community Health Center"]
[12702,"Fertility Center of New England"]
[16658,"First Psychiatric Planners"]
[19860,"Fitzpatrick, Moran & Costa, LLP"]
[20586,"Five Star Rehabilitation and Wellne"]
[20580,"FlexPlus Physical Therapy, LLC"]
[999998,"For Non-Fee Schedule Paid"]
[21810,"Four Women Health Services, LLC"]
[20566,"Fox Rehab MA LLC"]
[20052,"Framingham Psychiatric Counseling Associ"]
[16654,"Franklin Eye Care Assoc LLC  Eye and Lasik Center"]
[19989,"Futures"]
[19999,"GEN PSYCHOLOGICAL ASSOC"]
[11784,"George F. Vitek, M.D & Associates, P.C."]
[12816,"Global Medical Group, PC"]
[10964,"Granite Medical"]
[20087,"Greater Boston Anesthesia Associate"]
[20058,"Greater Boston Gastroenterology, PC"]
[12815,"Greater Boston Medical Associates"]
[20550,"Greater Boston Plastic Surgery"]
[20075,"Greater Boston Urology, LLC"]
[64,"Greater Lawrence Family Health Center, Inc."]
[20209,"Greater Lowell Psychiatric Associates"]
[65,"Greater New Bedford Community Health Center, Inc."]
[20,"Greater Roslindale Medical and Dental Center"]
[11386,"Grove Medical Associates, P.C."]
[20060,"Gynecology Partners, PC"]
[12756,"Hallmark Health IPA"]
[7895,"Hallmark Health Medical Associates"]
[11000,"Hallmark Health System (HHS)"]
[20258,"Hampden and Franklin County Cardiovascular Associates"]
[10825,"Hampden County Physician Associates, LLC"]
[6382,"Harbor Community Health Center - Hyannis (formerly Mid-Upper Cape)"]
[11014,"Harbor Medical Associates PC"]
[20585,"Hardy Physical Therapy"]
[12805,"Harrington Healthcare System"]
[348,"Harrington Physician Services"]
[9914,"Harvard Medical Faculty Physicians at Beth Israel Deaconess Medical Center"]
[20063,"Harvard Square Eye"]
[69,"Harvard Street Neighborhood Health Center"]
[4932,"Harvard Vanguard Medical Associates"]
[11001,"Hawthorn Medical Associates"]
[20225,"HD Physical Therapy LLC"]
[10326,"Health Alliance with Physicians"]
[12950,"Health Express"]
[71,"HealthAlliance - Leominster Campus"]
[11015,"Healthcare South PC"]
[20565,"HealthPro Heritage Rehab & Fitness,"]
[20218,"HealthPro Pediatrics LLC"]
[10976,"Heywood Medical Group"]
[20280,"Heywood Urgent Care"]
[10988,"Highland Healthcare Assoc IPA"]
[14293,"Highland Pediatrics, PC"]
[20567,"Hopedale Cardiovascular Associates"]
[20217,"Innovative Autism Connect"]
[17718,"Inter Med Associates"]
[12020,"Internal Medicine Associates, PC"]
[12451,"IPC Hospitalists of New England PC"]
[16653,"Island Counseling Center, LLC"]
[20233,"IVS Anesthesia LLC"]
[20059,"John Magalhaes and Associates, Inc"]
[12037,"Jordan Physician Associates"]
[20227,"Joshua  Newman"]
[11808,"Joslin Clinic Physicians"]
[10552,"Justice Resource Institute"]
[20224,"Kennedy Brothers Physical Therapy"]
[20226,"Kennedy Brothers Physical Therapy"]
[20259,"Kidney Care and Transplant Services of New England"]
[20235,"Kids on the Common Pediatrics"]
[19991,"Kindle Behavior Consultants, Inc."]
[12093,"L&M Radiology, Inc."]
[17687,"Lahey Clinical Performance Accountable Care Organization"]
[19978,"Lahey Health Urgent Care"]
[6546,"Lahey Hospital and Medical Center"]
[14422,"Lahey Physician Community Org"]
[19857,"Lakes/National Emergency Physicians, Inc."]
[20123,"Lawrence Anesthesia Services"]
[10977,"Lawrence General IPA (d/b/a Choice Plus Network)"]
[20451,"Lawrence Integrated Health Provider Network, LLC"]
[20260,"Lawrence Medical Center"]
[20081,"Lexington Pediatrics, LLC"]
[12461,"LGH Medical Group Inc"]
[21808,"Longwood Eye LLC"]
[21809,"Love and Mercy Home Healthcare"]
[84,"Lowell Community Health Center Inc"]
[10978,"Lowell General PHO"]
[10979,"Lower Merrimac Valley Physician Hospital Organization (LMVPHO)"]
[16657,"Lowney Medical Associates, Inc"]
[86,"Lynn Community Health Center"]
[20281,"Lynn Urgent Care"]
[87,"Manet Community Health Center, Inc. at North Quincy"]
[7846,"Manet Community Health Center, Inc. at Snug Harbor"]
[20559,"Marathon Physical Therapy and Sport"]
[20222,"Marion Gagnon BS"]
[12038,"Martha's Vineyard Hospital Physicians"]
[20068,"Mass Optometric LLC."]
[19901,"Massachusetts Express Care, PLLC "]
[14423,"Massachusetts Eye and Ear Associates (PHO)"]
[12139,"Massachusetts Eye and Ear Associates (Physician Group)"]
[17722,"Massachusetts Eye Associates"]
[12698,"Massachusetts Eye Research and Surgery"]
[11002,"Massachusetts General Hospital Physicians Organization"]
[9324,"Massachusetts General Physicians Organization"]
[20568,"Massachusetts Medical and Physical"]
[21801,"Matrix Anesthesia"]
[90,"Mattapan Community Health Center"]
[16534,"MedExpress Urgent Care, PC-Massachusetts"]
[11810,"Medical Affiliates of Cape Cod "]
[11403,"Medical Care of Boston Management"]
[17746,"Medpost Urgent Care"]
[20588,"Medvedovski-Khanukaev, Elena"]
[3111,"Melrose Wakefield Healthcare"]
[12151,"Mercy Inpatient Medical Associates"]
[14424,"Mercy Medical Group"]
[14425,"Mercy Specialist Physicians"]
[12456,"Merrimack Valley Emergency Associates Inc"]
[10989,"Merrimack Valley Physicians Inc"]
[11493,"Merrimack Valley, IPA"]
[20261,"Metrowest Emergency Physicians"]
[10982,"MetroWest Health Care Alliance"]
[11394,"MetroWest Physicians Services"]
[20056,"MGH Patriot Pediatrics"]
[20286,"Mid-Cape Medical Center"]
[12960,"Middleton Family Medicine"]
[20054,"Milford Franklin Eye Center, Llc"]
[8750,"Milford Regional Physician Group"]
[11809,"Milton PHO, Inc."]
[11767,"Milton Primary Care, LLC"]
[12699,"Minuteclinic Diag of MA"]
[11391,"MIT Medical (Physician Group)"]
[10826,"Mount Auburn Cambridge IPA"]
[11404,"Mount Auburn Professional Services"]
[20072,"Mountain View Family Practice, PC"]
[20062,"Narragansett Bay Anesthesia, LLC"]
[11813,"Nashoba Physicians, Inc."]
[12741,"Natick Eye Associates, PC"]
[19872,"Natick Urgent Care"]
[20073,"Needham Wellesley Family Medicine P"]
[12449,"Neonatology Associates"]
[17721,"Nephrology Associates of the Merrimack Valley Circle, LLC"]
[102,"Neponset Health Center"]
[13119,"New England Baptist Clinical Integration Organization, LLC"]
[8655,"New England Baptist Medical Associates"]
[12686,"New England Dermatology, PC"]
[11855,"New England Neurological Associates"]
[12448,"New England Orthopedic Surgeons"]
[10065,"New England Physical Therapy Network"]
[9916,"New England Quality Care Alliance (NEQCA)"]
[20262,"New England Retina Consultants, PC"]
[20583,"New England Tissue Issue PLLC"]
[12453,"New Horizons Medical PC"]
[20014,"Newburyport Oral Surgery, Inc"]
[20581,"Newton Wellesley Emergency Medicine"]
[8644,"Newton-Wellesley Physician Hospital Group"]
[10993,"Noble Health Alliance, PHO"]
[19855,"North American Partners in Anesthesia Massachusetts, LLC"]
[19895,"North Attleboro Urgent Care"]
[17720,"North Quabbin Family Physicians"]
[1456,"North Shore Community Health, Inc."]
[11004,"North Shore Physicians Group"]
[13123,"Northeast Behavioral Health, LLC DBA Southeast Behavioral Health"]
[12629,"Northeast Dermatology Associates"]
[11408,"Northeast Medical Practice"]
[8646,"Northeast PHO (NEPHO)"]
[11399,"Northern Berkshire Healthcare Physicians Group"]
[15528,"NORTHSTAR ANESTHESIA OF MASSACHUSETTS II PLLC"]
[17748,"Norwood Urgent Care"]
[12119,"On Call Urgent Care"]
[16564,"Ophthalmic Consultants of Boston, Inc."]
[21799,"Optum Infusion Services 550,LLC"]
[11785,"Orchard Medical Associates, LLC"]
[12413,"Orion Emergency Services, Inc"]
[8695,"Orthopaedic Surgical Center of the North Shore, LLC"]
[20076,"Orthopedic Care Physician Network, LLC"]
[9454,"Orthopedic Care Specialists, Inc."]
[20589,"Orthopeidic & Sports Physical Therapy"]
[111,"Outer Cape Health Services, Inc."]
[12016,"Paper City Emergency Physicians"]
[8745,"Partners Community Physician Organization"]
[20574,"Partners In Rehabilitation, LLC"]
[16535,"Partners Urgent Care, LLC"]
[13249,"Patriot Urgent Care"]
[20051,"PCHC - Main Street/Medford"]
[20555,"Peak Performance Physical therapy"]
[20591,"Peak Physical Therapy, Inc"]
[12017,"Pediatric Associates of Fall River"]
[11862,"Pediatric Associates of Greater Salem"]
[11395,"Pediatric Associates, Inc. of Brockton"]
[11859,"Pediatric Health Care Associates"]
[9923,"Pediatric Physicians' Organization at Children's (PPOC)"]
[11005,"Pentucket Medical Associates (PMA)"]
[8162,"People, Inc"]
[20575,"Performance Rehabilitation Of Western MA"]
[20086,"Personal Primary Care and Weight Managem"]
[19898,"PhysicianOne Urgent Care   "]
[11010,"Physicians Of Cape Cod"]
[12677,"Physiotherapy Associates DBA"]
[20573,"Pinnacle Health Management"]
[21813,"Pioneer Spine & Sports Physicians, PC"]
[16532,"Pioneer Valley Cardiology Associates"]
[8082,"Pioneer Valley SurgiCenter, LLC"]
[11769,"Plymouth Bay Primary Care"]
[19979,"PM Pediatrics of New England, LLC"]
[11006,"PMG Physician Associates, P.C."]
[20084,"Post Acute Care Clinicians, LLC"]
[12148,"Pratt Medical  Group, Inc."]
[9776,"Prima CARE, P.C."]
[11770,"Primary Care Medical Associates"]
[20016,"Proex Physical Therapy"]
[20268,"Professional Physical Therapy"]
[20549,"Professional PT Therapy and Sport M"]
[20221,"Project Child"]
[20216,"Proven Behavior Solutions"]
[20219,"Proven Behavior Solutions"]
[20048,"Psychological Care Associates PC"]
[20561,"Puddingstone Place LLC"]
[21816,"Pure Life Renal of Stoughton, LLC"]
[11771,"Quincy Primary Care"]
[20263,"Rehabilitation Medical Associates"]
[10972,"Reliant Medical Group"]
[17723,"Renal and Transplant Associates of New England, PC"]
[20074,"Revere-Winthrop Pediatrics, Inc"]
[12697,"Rheumatology and Internal Medicine"]
[20065,"Rheumatology Consultants, PC"]
[19856,"Right Choice Health Group,LLC"]
[10914,"RiverBend Medical"]
[21812,"Rivers of Hope"]
[20089,"Riverside Eye Care PC    "]
[20584,"S & L Therapy"]
[12678,"S.T.A.R.T., Inc dba Novacare Rehabilitation"]
[14427,"Saint Vincent Medical Company"]
[12951,"Saint Vincent Radiological Associates, Inc."]
[20047,"Saperia Orthopaedics"]
[21803,"SaVida Health, PC"]
[11915,"Seacoast Affiliated Group Practice"]
[20055,"Shannon and Hunter, P.C. - SP"]
[20560,"Sheridan - Lowell Anesthesia"]
[20098,"Shriners Hospital for Children Physician Organization"]
[10327,"Signature Healthcare Medical Group"]
[11898,"Sisters of Providence Physicians"]
[20546,"Skin Dermatology Company"]
[20576,"SLP Associates, PC"]
[21798,"Soleo Health AKA Biomed"]
[20085,"Sound Physicians of Massachusetts II, P."]
[20071,"Sound Physicians of Massachusetts, Inc."]
[21,"South Boston Community Health Center"]
[20095,"South Coast Dermatology"]
[120,"South Cove Community Health Center"]
[10252,"South End Associates (of Fenway CHC)"]
[121,"South End Community Health Center"]
[9354,"South Shore Anesthesia Associates, Inc."]
[20264,"South Shore Cardiology, PC"]
[19980,"South Shore Health Express LLC"]
[11762,"South Shore Internal Medicine Associates"]
[10965,"South Shore Medical Center"]
[21807,"South Shore Orthopedics"]
[11393,"South Shore Physician Hospital Organization (SSPHO)"]
[21802,"South Shore Radiological Associates"]
[20582,"South Shore Sports and Muscular The"]
[21815,"South Shore Women's Health PC"]
[10966,"Southboro Medical Group"]
[4027,"Southcoast Health System"]
[7968,"Southcoast Hospitals Group - The Truesdale Clinic"]
[11497,"Southcoast Physician Group"]
[11016,"Southcoast Physicians Network"]
[20285,"Southcoast Urgent Care"]
[13228,"Southeast Rehab Center"]
[24,"Southern Jamaica Plain Health Center"]
[11017,"Southern New England Health Alliance"]
[21817,"Speech and Language Therapy Services, Inc."]
[21818,"Speech and Language Therapy Services, Inc."]
[21819,"Speech and Language Therapy Services, Inc."]
[21820,"Speech and Language Therapy Services, Inc."]
[21821,"Speech and Language Therapy Services, Inc."]
[21822,"Speech and Language Therapy Services, Inc."]
[21823,"Speech and Language Therapy Services, Inc."]
[21824,"Speech and Language Therapy Services, Inc."]
[21825,"Speech and Language Therapy Services, Inc."]
[21826,"Speech and Language Therapy Services, Inc."]
[21827,"Speech and Language Therapy Services, Inc."]
[20577,"Spine & Sports Injury Center"]
[20551,"Sports & Wellness Physical Therapy"]
[20032,"Sports Medicine North"]
[12447,"Springfield Anesthesia Services"]
[12746,"Springfield Eye Associates, Inc"]
[11786,"Springfield Medical Associates, LLC."]
[20088,"Square Medical Group, LLC"]
[11539,"St. Vincent Physician Services"]
[12454,"Steward Emergency Physicians Inc"]
[10970,"Steward Good Samaritan IPA"]
[11400,"Steward Medical Group"]
[11058,"Steward Network Services"]
[11061,"Steward Norwood Southwood IPA"]
[11063,"Steward St. Elizabeth's Health Professionals"]
[12948,"Stoneman Outpatient Center"]
[11397,"Sturdy Memorial Associates"]
[20090,"Sturdy Memorial Urgent Care"]
[11896,"Suburban Internal Medicine"]
[20547,"Tak Medical Group, P.C."]
[20092,"Tallman Eye Associates"]
[11801,"The Affiliated Physicians Group"]
[12120,"The Cardiovascular Specialists, LLC"]
[11018,"The Childrens Hospital Corporation"]
[20039,"The Heart Center of Metrowest, PC"]
[20041,"The May Institute, Inc"]
[20553,"Through the Forest Counseling Inc"]
[16659,"Total Wellness Centers LLC, dba Clean Slate Centers"]
[21811,"Trauma To Wellness, Inc."]
[20067,"Trinity Family Medicine, LLC"]
[20037,"Tristan Medical, PC"]
[19859,"Tru Med, Inc."]
[11224,"Tufts Internal Medicine & Adult Primary Care"]
[10991,"Tufts Medical Center Physician Organization"]
[20282,"Tully Walk in Care Center"]
[12018,"Tural Pediatrics"]
[6755,"UMass Memorial Health Care"]
[11773,"UMass Memorial Medical Center - Based Practices"]
[9784,"UMass Memorial Medical Group"]
[20083,"University of Mass Health Services"]
[20265,"University Pathologists, LLC"]
[4431,"Uphams Home Health Care"]
[19981,"Urgent Care Express"]
[19900,"Urgent Care of Holden  "]
[19899,"Urgent Care of Wilbraham"]
[19904,"Urgent Care Operations, PC "]
[20283,"Urgent Care Physicians PC"]
[19903,"Urgi Center Medical Group "]
[11415,"Valley Health Partners PHO at Holyoke Medical Center"]
[11787,"Valley Medical Associates, P.C."]
[11468,"Valley Medical Group Amherst"]
[11469,"Valley Medical Group Easthampton"]
[11470,"Valley Medical Group Florence"]
[11471,"Valley Medical Group Greenfield"]
[10960,"Valley Medical Group, P.C."]
[11792,"Valley Pulmonary and Medical Associates"]
[12682,"Valley Women's Health Group, LLC"]
[16652,"Vernon Integratice Medical Group, LLC"]
[3909,"Veterans Health Administration - VA Boston Healthcare System"]
[20231,"VK New England Management"]
[20232,"Vohra Post Acute Care Phy"]
[12021,"Wachusett Emergency Physicians, PC"]
[12171,"Walgreen Co."]
[20578,"Warwick Pain Associates LLC"]
[21814,"We Care 365"]
[20237,"Wellesley Women's Care PC"]
[12775,"Wellforce"]
[20080,"Wellness Concepts, Inc."]
[14428,"Western Mass Physician Associates"]
[11413,"Whittier IPA Physician Group"]
[137,"Whittier Street Health Center"]
[21806,"WIH Faculty Physicians, Inc"]
[11020,"Williamstown Medical Associates"]
[12022,"Winchester Physician Associates"]
[11814,"Wing Memorial Hospital Physicians"]
[10992,"Woburn Pediatric Associates"]
[12414,"Women's Health of Central Massachusetts"]
[20266,"Woodland Anesthesiology Associates"]
[17719,"Worcester Internal Medicine, Inc"]
[20556,"Worcester Physical Therapy"]
[7840,"Worthington Health Center"]

{"sheet":"Reference Tables","index":4,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Relative Price Submission"]
["Reference Tables"]
[]
[]
[null,"Table D.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 D.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 D.3 - Product Types"]
[null,"Product Type Code","Description"]
[null,1,"HMO and POS"]
[null,2,"PPO"]
[null,3,"Indemnity"]
[null,4,"Other"]
[]
[]
[null,"Table D.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":"Payments Review","index":5,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Total Payments reported for each Physician Group"]
[]
["Table E.1: Payment Summary"]
["ProviderGroupOrgID","LocalPracticeOrgID","InsuranceCategoryCode","ProductTypeCode","Sum of ClaimsPayments","Sum of NonClaimsPayments","Sum of Total Payments"]

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

{"sheet":"Service Review","index":7,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Please review the Services reported for each Physician Group"]
[]
["Table G.1: Service Group Summary"]
["ProviderGroupOrgID","LocalPracticeOrgID","PediatricIndicator","InsuranceCategoryCode","ProductTypeCode","Service","Count of Multiplier","Data Review"]

{"sheet":"Payers","index":8,"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,"AllWays Health Partners, Inc.","Allways"]
[12103,"Tufts Medicare Advantage","TuftsMedicare"]
[10728,"Commonwealth Care Alliance","CCA"]
[10926,"United Healthcare Insurance Company - Medicare Advantage","UnitedMedicare"]
[11226,"BMC HealthNet Plan, Inc. (Medicaid MCO)","BMCHP"]
[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":9,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[true,"OnSaveFlag",{"$f":"ROWS(_xlfn._xlws.FILTER('Physician Group List'!A$1:B$547,('Physician Group List'!A$1:A$547<>\"\")+('Physician Group List'!B$1:B$547<>\"\")))","v":547},"Org Count"]
[1,"iPayer",{"$f":"ROWS(_xlfn._xlws.FILTER('Physician Group Data'!A:J,('Physician Group Data'!A:A<>\"\")+('Physician Group Data'!B:B<>\"\")+('Physician Group Data'!C:C<>\"\")+('Physician Group Data'!D:D<>\"\")+('Physician Group Data'!E:E<>\"\")+('Physician Group Data'!F:F<>\"\")+('Physician Group Data'!G:G<>\"\")+('Physician Group Data'!H:H<>\"\")+('Physician Group Data'!I:I<>\"\")+('Physician Group Data'!J:J<>\"\")))+1","v":2},"Data Count"]
[{"$f":"A4&\"_\"&A5&\"_\"&A6&\"_\"&A7&\"_\"&A8&\".xlsm\"","v":"0_Select Payer:_0_116_PG.xlsm"},"vFileName"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,1))","v":0},"vPayerOrgID"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,3))","v":"Select Payer:"},"vPayerShortName"]
[{"$f":"'Front Page'!C12","v":0},"vYear"]
[116,"FilingTypeID"]
["PG","TemplateType"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(AND(A19=TRUE,A34=TRUE),TRUE,FALSE)","v":false},"cfAllFrontPageRequriedFields"]
[{"$f":"IF(AND(A20=TRUE,A21=TRUE,A23=TRUE,A24=TRUE,A25=TRUE,A26),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=\"ERROR: 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},"vSubmissionYear"]
[{"$f":"IF('Front Page'!C13=\"\", FALSE,TRUE)","v":false},"vDataYear"]
[]
[]
[{"$f":"IF(AND(A30=TRUE,A31=TRUE),TRUE,FALSE)","v":false},"cfFrontPageTableA2RequiredFields"]
[{"$f":"IF(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C19)), TRUE,FALSE)","v":false},"vPhysicianGroupDataTab"]
[{"$f":"IF(ISNUMBER(SEARCH(\"All entered data is valid\",'Front Page'!C20)), TRUE,FALSE)","v":false},"vServiceReviewTab"]
[]
[]
[{"$f":"IF(AND(A35=TRUE,A36=TRUE,A37=TRUE,A38=TRUE),TRUE,FALSE)","v":false},"cfFrontPageTableA3RequiredFields"]
[{"$f":"IF('Front Page'!C25=\"\", FALSE,TRUE)","v":false},"vAcknowledgeReviewedOther ProviderDataTab"]
[{"$f":"IF('Front Page'!C26=\"\",FALSE,TRUE)","v":false},"vAcknowledgeReviewedPaymentsReviewTab"]
[{"$f":"IF('Front Page'!C27=\"\",FALSE,TRUE)","v":false},"vAcknowledgeReviewedMultiplierReviewTab"]
[{"$f":"IF('Front Page'!C28=\"\",FALSE,TRUE)","v":false},"vAcknowledgeReviewedServiceReviewTab"]