{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Approvals ",null,null,null,"Claims","Network","Black listed optical shops","One stop shop","Route of communication"]
["Services","Time frame","Needed documents","Route For Each Service","Needed documents"]
["Hospitals: All daycare & inpatient admissions","2 hours","Medical report mentioning : \n1- Diagnosis\n2- onset date of symptoms\n3- Treatment plan/procedure\nHospital name\nMembership card\n\n","If consultation is done inside or outside the network, \napproval must be issued ","Receipt\nHospital's Invoice breakdown \nMedical report mentioning diagnosis and procedure performed\nDischarge report\nDoctor's receipt","attached","certain optical shops (attached) covered by direct billing",null,"med.alex@medmark.eg"]
["Radiology Center:\nMRI\nColored doppler\nCT scan\nDoppler\n3D ultrasound\nAll types of endoscopy\nScans with contrast\nEcho\nUltrasound if at the same doctor's clinic\n","2 hours","Red form mentioning symptoms \nand requested scan\nMembership card\n\n","If consultation is done inside network, radiological tests can be done within the same facility or in scan center within the network directly using the form (cannot be done in a different hospital)\nIf consultation is done outside network, approval can be issued directed to a scan center within the network (not hospital)",null,null,null,"if started consultation in a facility,"]
["Lab Tests:\nTumor markers (CA15.3, CEA, CA 125, PSA\nHepatitis: HBAB, HCV AB, HB, HB AG\nPCR\nHormones: (Progesterone, FSH, LH, Estrogen)\n\n\n",null,"Yellow form mentioning symptoms\nand requested lab tests\nMembership card","If consultation is done inside network, lab tests can be done within the same facility or in scan center within the network directly using the form (cannot be done in a different hospital)\nIf consultation is done outside network, approval can be issued directed to a labr within the network (not hospital)",null,null,null,"can continue all services in the same facility"]
["Pharmacies: \n",null,null,"can be dispensed directly using claim form\nexcept for vitamins must issue prior approval\nand medications above 400 EGP\n"]
["Chronic Medication: \ndispened monthly for more than 2 months","5 working days","Prescription mentioning diagnosis\nand mentioning it is a monthly medication\nLab test results/Scans report\n","Prior approval must be issued "]
["Maternity ( After Maternity Activation):\n","2 hours",null,null,"Copy of ultrasound report or lab test result\nor medical report from treating doctor mentioning the pregnancy start date\nFor delivery:\nDetailed hospital's breakdown\nstamped Doctor's invoice and signed\nDetailed discharge report"]
["Dental: \n","2 hours","If covered in scheme, it is covered upon prior approval within specific providers/clinic\nservices covered based on TOB",null,"Detailed receipt of payment mentioning procedure done\nor detailed prescription mentioning amount paid and procedure done"]
["Chemotherapy&Radiotherapy Centers: \n","2 hours","Prescription mentioning diagnosis\nTreatment plan\n\n","prior approval must be issued \nif consultation is within or outside the network"]
["Physiotherapy Centers:\n","2 hours","Prescription mentioning diagnosis\nTreatment plan\nOnset date of symptoms\nScan report\n","Prior approval required"]