{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BOARD","AML-Members","AML-Clients"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"BOARD","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,3,0]]}
["DATE","2022-01-14"]
["EXCELL NAME","SHEET NAME"]
["Aml sheet","AML-Clients"]
[null,"AML-Members"]

{"sheet":"AML-Members","index":1,"n_rows":15,"n_cols":44,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Ref Number ","Created By ggggg"]
[]
[]
[null,"POLICY ID","CLIENT NAME","MEMBER NAME","CARD NO","EMPLOYEE CODE","GENDER","AGE","BATCH RECEIVING DATE","BATCH ID","PARENT ID","BATCH TYPE","PROVIDER TYPE NAME","PROVIDER ENG NAME","PROVIDER ID","CLAIM CODE","PARENT CLAIM SET RESUB","SERVICE DATE","DESCRIPTION","MEDICAL OPERATION","APPROVAL ID","SERVICE NAME","ACT ID","ACT NAME","PROVIDER MEMO","MEMBER MEMO","TYPE OF FUND","MAX ANNUAL","ISSUANCE DATE","DUE DATE","REJECTED MEMO","QUANTITY","CLAIMED AMOUNT","TOTALGROSS","ORIGINAL PRICE","AFTER DISCOUNT","AFTER COPAY","ROVIDER DUE VALUE","APPROVED AMOUNT","DEDUCTED AMOUNT","COPAYMENT AMOUNT","DISCOUNT AMOUNT","DEBIT VALUE","POLICY PAYEMENT"]
["TRUE",576,"sdfg","Esraa Adel Zakaria",456564555,null,"Female",40,"2021-11-15",7457575,"(blank)","Provider batch","QWEDQa","Asdas",7458474,"151555-1","(blank)","2021-10-11",null,"(blank)","(blank)",null,26543025,null,null,"(blank)","Ceiling",1000000,"2021-11-29","2021-12-30","(blank)",1,130,130,130,130,130,130,130,0,0,0,0,130]
["TRUE",576,"sdfg","Esraa Adel Zakaria",456564555,null,"Female",40,"2021-11-15",7457575,"(blank)","Provider batch","Dasd","Sdasd",7458474,"151555-2","(blank)","2021-10-18",null,"(blank)","(blank)",null,26543027,null,null,"(blank)","Ceiling",1000000,"2021-11-29","2021-12-30","(blank)",1,130,130,130,130,130,130,130,0,0,0,0,130]
["TRUE",576,"ssdfg","Nada Hussein El-Sayed",456564555,null,"Female",40,"2021-09-15",7457575,"(blank)","Provider batch","asd","Asdas",7458474,"151555-3","(blank)","2021-08-11",null,"(blank)","(blank)",null,26680591,null,null,"(blank)","Ceiling",1000000,"2021-12-06","2021-10-30","(blank)",1,47,47,0,47,47,47,47,0,0,0,0,47]
["TRUE",576,"sdfgs","Nada Hussein El-Sayed",456564555,null,"Female",40,"2021-09-15",7457575,"(blank)","Provider batch","ASD","Asdas",7458474,"151555-4","(blank)","2021-08-11",null,"(blank)","(blank)",null,25691236,null,null,"(blank)","Ceiling",1000000,"2021-12-06","2021-10-30","(blank)",1,16,16,16,16,16,16,16,0,0,0,0,16]
["TRUE",576,"fgsdf","Nada Hussein El-Sayed",456564555,null,"Female",40,"2021-09-15",7457575,"(blank)","Provider batch","ASD","Asdas",7458474,"151555-5","(blank)","2021-08-11",null,"(blank)","(blank)",null,25691234,null,null,"(blank)","Ceiling",1000000,"2021-12-06",44499,"(blank)",1,16,16,16,16,16,16,16,0,0,0,0,16]
["TRUE",576,"sdfgsd","Nada Hussein El-Sayed",456564555,null,"Female",40,"2021-09-15",7457575,"(blank)","Provider batch","asd","Dasd",7458474,"151555-6","(blank)","2021-08-11",null,"(blank)","(blank)",null,25691233,null,null,"(blank)","Ceiling",1000000,"2021-12-06",44499,"(blank)",1,19,19,19,19,19,19,19,0,0,0,0,19]
["TRUE",576,"gsdfg","Eman Magdy Ezzat",456564555,null,"Female",40,"2021-11-14",7457575,"(blank)","Provider batch","ASD","dASD",7458474,"151555-7","(blank)","2021-10-02",null,"(blank)","(blank)",null,26487850,null,null,"(blank)","Ceiling",1000000,"2021-11-30","2021-12-29","(blank)",1,75,75,75,75,75,75,75,0,0,0,0,75]
["TRUE",576,"sd","Yassmine Essam Elgahawy",456564555,null,"Female",40,"2021-11-07",7457575,"(blank)","Provider batch","asd","Asdas",7458474,"151555-8","(blank)","2021-10-12",null,"(blank)",2707983,null,26459826,null,null,"(blank)","Ceiling",1000000,"2021-11-30","2021-12-22","(blank)",6,120,720,120,720,720,720,720,0,0,0,0,720]
["TRUE",576,"sdfg","Kinda Baher Mohsen",456564555,null,"Female",40,"2021-11-15",7457575,"(blank)","Provider batch","ASD","Dasd",7458474,"151555-9","(blank)","2021-10-09",null,"(blank)","(blank)",null,26543038,null,null,"(blank)","Ceiling",1000000,"2021-11-29","2021-12-30","(blank)",1,130,130,130,130,130,130,130,0,0,0,0,130]
["TRUE",576,"dfg","Celia Baher Mohsen",456564555,null,"Female",40,"2021-11-15",7457575,"(blank)","Provider batch","asd","Asdas",7458474,"151555-10","(blank)","2021-10-09",null,"(blank)","(blank)",null,26543039,null,null,"(blank)","Ceiling",1000000,"2021-11-29","2021-12-30","(blank)",1,130,130,130,130,130,130,130,0,0,0,0,130]
["Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,813,1413,766,1413,1413,1413,1413,0,0,0,0,1413]

{"sheet":"AML-Clients","index":2,"n_rows":305,"n_cols":5,"rows_kept":305,"cut":false,"hidden":false,"merged":[[302,0,302,4],[301,0,301,4],[299,0,299,2]]}
[]
[null,null,null,"القاهرة في","2022-01-14"]
[]
["Dears\\ XCSDFSD"]
["تحية طيبة و بعد ،"]
["  مرفق ادناه بيان بأوامر الدفع بعد المراجعة و التدقيق للمطالبات المقدمة و المطلوب سدادها من سيادتكم :"]
[]
[]
[" Provider Name "," Provider Type","Due Date"," Batch ID ","Approved amount for ASDFAS"]
["asA","d","2021-12-22",117556,720]
["asA","a","2021-12-29",118013,75]
["Asas","d","2021-10-30",115437,98]
["AS","d","2021-12-30",118126,520]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Grand Total",null,null,"4 POs",1413]
[]
["  الرجاء من سيادتكم سرعة سداد المبالغ اعلاه حرصا على العلاقة مع السادة مقدمي الخدمات الطبية وعدم  تأثر مستوى الخدمة المقدمة"]
["  للسادة المستفيدين مؤكدين لسيادتكم حرصنا الدائم لخدمتكم و خدمة المستفيدين ."]
[]
[null,null,null,null," ادارة التشغيــــل"]