{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LandingPage","Providers","Lookup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"LandingPage","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["1) Please Select DOBI Issuer ID:","DOBI001"]
[]
["2) Populate the 'Providers' tab with your data"]
["One row of data per Provider/Address/Specialty where an individual can make an appointment with the provider within the state of New Jersey at the listed address. No Virtual only providers should be submitted."]
[]
["3) Click the 'Validate' button on the 'Providers' tab to check for errors"]
["Correct any errors and click the 'Validate' button again"]
["To pass validations all column headers must be green"]
[]
["4) After Provider data is validated, choose File - Save As to create a new file"]
[]
["5) Name the file in accordance with defined naming convention"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revised 4/11/25"]

{"sheet":"Providers","index":1,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,null,"Please correct any red highlighted cells and rerun validation"]
["IssuerId","NPI","FirstName","MiddleName","LastName","Suffix","Credentials","Phone","Address","Address2","City","State ","Zip","SpecialtyCode","SpecialtyDescription","PCPAcceptingNew","Tier1","SubmittedClaimWithin12MonthsForThisLocation_Specialty(Y/N)","ContractedHospitalNPI1","ContractedHospitalName1","ContractedHospitalNPI2","ContractedHospitalName2","ContractedHospitalNPI3","ContractedHospitalName3","ContractedHospitalNPI4","ContractedHospitalName4"]

{"sheet":"Lookup","index":2,"n_rows":141,"n_cols":6,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["Valid IssuerIDs",null,"State of NJ SpecCode"," State of NJ Specialty Description"]
["DOBI001",null,"001","General Practice",null,{"$f":"C2&D2","v":"001General Practice"}]
["DOBI002",null,"002","Family Practice",null,{"$f":"C3&D3","v":"002Family Practice"}]
["DOBI003",null,"003","Internal Medicine",null,"003Internal Medicine"]
["DOBI004",null,"007","Allergist/Immunologist",null,"007Allergist/Immunologist"]
["DOBI005",null,"008","Cardiologist",null,"008Cardiologist"]
["DOBI006",null,"010","Chiropractors",null,"010Chiropractors"]
["DOBI007",null,"011","Dermatologist",null,"011Dermatologist"]
["DOBI008",null,"012","Endocrinologist",null,"012Endocrinologist"]
["DOBI009",null,"013","Otolaryngologist",null,"013Otolaryngologist"]
["DOBI010",null,"014","Gastroenterologist",null,"014Gastroenterologist"]
["DOBI011",null,"015","General Surgeon",null,"015General Surgeon"]
["DOBI012",null,"016G","Gynecologist",null,"016GGynecologist"]
["DOBI013",null,"016O","Obstetrician",null,"016OObstetrician"]
["DOBI014",null,"017","Infectious Disease Specialist",null,"017Infectious Disease Specialist"]
["DOBI015",null,"018","Nephrologist",null,"018Nephrologist"]
["DOBI016",null,"019","Neurologist",null,"019Neurologist"]
["DOBI017",null,"021","Oncologist/Hematologist",null,"021Oncologist/Hematologist"]
["DOBI018",null,"023","Ophthalmologist",null,"023Ophthalmologist"]
["DOBI019",null,"024","Oral Surgeon",null,"024Oral Surgeon"]
["DOBI020",null,"025","Orthopedist",null,"025Orthopedist"]
["DOBI021",null,"026","Physiatrist",null,"026Physiatrist"]
["DOBI022",null,"028","Podiatry",null,"028Podiatry"]
["DOBI023",null,"029","Psychiatrist",null,"029Psychiatrist"]
["DOBI024",null,"030","Pulmonologist",null,"030Pulmonologist"]
["DOBI025",null,"033","Urologist",null,"033Urologist"]
["DOBI026",null,"034","Vascular Surgery",null,"034Vascular Surgery"]
["DOBI027",null,"035","Cardio Thoracic Surgery",null,"035Cardio Thoracic Surgery"]
["DOBI028",null,"100","Board Certified Behavior Analyst (BCBA)",null,"100Board Certified Behavior Analyst (BCBA)"]
["DOBI029",null,"101","Pediatrics",null,"101Pediatrics"]
["DOBI030",null,"102","Social Worker (LCSW, LSW, CSW)",null,"102Social Worker (LCSW, LSW, CSW)"]
["DOBI031",null,"103","Psychologists",null,"103Psychologists"]
["DOBI032",null,"104","Certified Alcohol and Drug Counselor (CADC)",null,"104Certified Alcohol and Drug Counselor (CADC)"]
["DOBI033",null,"105","Licensed Clinical Alcohol/Drug Counselor (LCADC)",null,"105Licensed Clinical Alcohol/Drug Counselor (LCADC)"]
["DOBI034",null,"106","Psychiatric - Mental Health Nurse (PMHN)",null,"106Psychiatric - Mental Health Nurse (PMHN)"]
["DOBI035",null,"198","Audiology",null,"198Audiology"]
["DOBI036",null,"200","Optometrist",null,"200Optometrist"]
["DOBI037",null,"201","General Dentist",null,"201General Dentist"]
["DOBI038",null,"202","Orthodontist",null,"202Orthodontist"]
["DOBI039",null,"203","Periodontist",null,"203Periodontist"]
["DOBI040",null,"204","Endodontist",null,"204Endodontist"]
["DOBI041",null,"205","Pedodontist",null,"205Pedodontist"]
["DOBI042",null,"206","Prosthodontist",null,"206Prosthodontist"]
["DOBI043",null,"036","Anesthesiology",null,"036Anesthesiology"]
["DOBI044",null,"517","Acupuncture",null,"517Acupuncture"]
["DOBI045",null,"518","Interventional Pain",null,"518Interventional Pain"]
["DOBI046",null,"519","Massage Therapy",null,"519Massage Therapy"]
["DOBI047",null,"521","Naturopathy",null,"521Naturopathy"]
["DOBI048",null,"523","Joint & Spinal Surgical",null,"523Joint & Spinal Surgical"]
["DOBI049",null,"FFC","Fertility",null,"FFCFertility"]
["DOBI050"]
["DOBI051"]
["DOBI052"]
["DOBI053"]
["DOBI054"]
["DOBI055"]
["DOBI056"]
["DOBI057"]
["DOBI058"]
["DOBI059"]
["DOBI060"]
["DOBI061"]
["DOBI062"]
["DOBI063"]
["DOBI064"]
["DOBI065"]
["DOBI066"]
["DOBI067"]
["DOBI068"]
["DOBI069"]
["DOBI070"]
["DOBI071"]
["DOBI072"]
["DOBI073"]
["DOBI074"]
["DOBI075"]
["DOBI076"]
["DOBI077"]
["DOBI078"]
["DOBI079"]
["DOBI080"]
["DOBI081"]
["DOBI082"]
["DOBI083"]
["DOBI084"]
["DOBI085"]
["DOBI086"]
["DOBI087"]
["DOBI088"]
["DOBI089"]
["DOBI090"]
["DOBI091"]
["DOBI092"]
["DOBI093"]
["DOBI094"]
["DOBI095"]
["DOBI096"]
["DOBI097"]
["DOBI098"]
["DOBI099"]
["DOBI100"]
["DOBI101"]
["DOBI102"]
["DOBI103"]
["DOBI104"]
["DOBI105"]
["DOBI106"]
["DOBI107"]
["DOBI108"]
["DOBI109"]
["DOBI110"]
["DOBI111"]
["DOBI112"]
["DOBI113"]
["DOBI114"]
["DOBI115"]
["DOBI116"]
["DOBI117"]
["DOBI118"]
["DOBI119"]
["DOBI120"]
["DOBI121"]
["DOBI122"]
["DOBI123"]
["DOBI124"]
["DOBI125"]
["DOBI126"]
["DOBI127"]
["DOBI128"]
["DOBI129"]
["DOBI130"]
["DOBI131"]
["DOBI132"]
["DOBI133"]
["DOBI134"]
["DOBI135"]
["DOBI136"]
["DOBI137"]
["DOBI138"]
["DOBI139"]
["DOBI140"]