{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["استعلام","الصندوق","المشرق","مصرف أبو ظبى ","الاهلى المتحد","مصر"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"استعلام","index":0,"n_rows":93,"n_cols":9,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[null,null,"البيـــــــــــــــــــــــــــان "]
[null,null,"محمد السيد محمد جبر "]
[null,"شركة كونكورد للخرسانة الجاهزة "]
[null,"م","البيـــــــــــــــــــــــــــان ","مدين","دائن","الرصيد","التاريخ","ملاحظات","اسم ورقة العمل"]
[null,{"$f":"IF(C5=\"\",\"\",MAX($B$4:B4)+1)","v":1},"محمد السيد محمد جبر ",null,20000,113921,"2020-03-02",null,"الصندوق"]
[null,{"$f":"IF(C6=\"\",\"\",MAX($B$4:B5)+1)","v":2},"محمد السيد محمد جبر ",null,20000,1742,"2020-03-05",377,"الصندوق"]
[null,{"$f":"IF(C7=\"\",\"\",MAX($B$4:B6)+1)","v":3},"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377,"المشرق"]
[null,{"$f":"IF(C8=\"\",\"\",MAX($B$4:B7)+1)","v":4},"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377,"مصرف أبو ظبى "]
[null,{"$f":"IF(C9=\"\",\"\",MAX($B$4:B8)+1)","v":5},"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377,"الاهلى المتحد"]
[null,{"$f":"IF(C10=\"\",\"\",MAX($B$4:B9)+1)","v":6},"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377,"مصر"]
[null,{"$f":"IF(C11=\"\",\"\",MAX($B$4:B10)+1)","v":""}]
[null,{"$f":"IF(C12=\"\",\"\",MAX($B$4:B11)+1)","v":""}]
[null,{"$f":"IF(C13=\"\",\"\",MAX($B$4:B12)+1)","v":""}]
[null,{"$f":"IF(C14=\"\",\"\",MAX($B$4:B13)+1)","v":""}]
[null,{"$f":"IF(C15=\"\",\"\",MAX($B$4:B14)+1)","v":""}]
[null,{"$f":"IF(C16=\"\",\"\",MAX($B$4:B15)+1)","v":""}]
[null,{"$f":"IF(C17=\"\",\"\",MAX($B$4:B16)+1)","v":""}]
[null,{"$f":"IF(C18=\"\",\"\",MAX($B$4:B17)+1)","v":""}]
[null,{"$f":"IF(C19=\"\",\"\",MAX($B$4:B18)+1)","v":""}]
[null,{"$f":"IF(C20=\"\",\"\",MAX($B$4:B19)+1)","v":""}]
[null,{"$f":"IF(C21=\"\",\"\",MAX($B$4:B20)+1)","v":""}]
[null,{"$f":"IF(C22=\"\",\"\",MAX($B$4:B21)+1)","v":""}]
[null,{"$f":"IF(C23=\"\",\"\",MAX($B$4:B22)+1)","v":""}]
[null,{"$f":"IF(C24=\"\",\"\",MAX($B$4:B23)+1)","v":""}]
[null,{"$f":"IF(C25=\"\",\"\",MAX($B$4:B24)+1)","v":""}]
[null,{"$f":"IF(C26=\"\",\"\",MAX($B$4:B25)+1)","v":""}]
[null,{"$f":"IF(C27=\"\",\"\",MAX($B$4:B26)+1)","v":""}]
[null,{"$f":"IF(C28=\"\",\"\",MAX($B$4:B27)+1)","v":""}]
[null,{"$f":"IF(C29=\"\",\"\",MAX($B$4:B28)+1)","v":""}]
[null,{"$f":"IF(C30=\"\",\"\",MAX($B$4:B29)+1)","v":""}]
[null,{"$f":"IF(C31=\"\",\"\",MAX($B$4:B30)+1)","v":""}]
[null,{"$f":"IF(C32=\"\",\"\",MAX($B$4:B31)+1)","v":""}]
[null,{"$f":"IF(C33=\"\",\"\",MAX($B$4:B32)+1)","v":""}]
[null,{"$f":"IF(C34=\"\",\"\",MAX($B$4:B33)+1)","v":""}]
[null,{"$f":"IF(C35=\"\",\"\",MAX($B$4:B34)+1)","v":""}]
[null,{"$f":"IF(C36=\"\",\"\",MAX($B$4:B35)+1)","v":""}]
[null,{"$f":"IF(C37=\"\",\"\",MAX($B$4:B36)+1)","v":""}]
[null,{"$f":"IF(C38=\"\",\"\",MAX($B$4:B37)+1)","v":""}]
[null,{"$f":"IF(C39=\"\",\"\",MAX($B$4:B38)+1)","v":""}]
[null,{"$f":"IF(C40=\"\",\"\",MAX($B$4:B39)+1)","v":""}]
[null,{"$f":"IF(C41=\"\",\"\",MAX($B$4:B40)+1)","v":""}]
[null,{"$f":"IF(C42=\"\",\"\",MAX($B$4:B41)+1)","v":""}]
[null,{"$f":"IF(C43=\"\",\"\",MAX($B$4:B42)+1)","v":""}]
[null,{"$f":"IF(C44=\"\",\"\",MAX($B$4:B43)+1)","v":""}]
[null,{"$f":"IF(C45=\"\",\"\",MAX($B$4:B44)+1)","v":""}]
[null,{"$f":"IF(C46=\"\",\"\",MAX($B$4:B45)+1)","v":""}]
[null,{"$f":"IF(C47=\"\",\"\",MAX($B$4:B46)+1)","v":""}]
[null,{"$f":"IF(C48=\"\",\"\",MAX($B$4:B47)+1)","v":""}]
[null,{"$f":"IF(C49=\"\",\"\",MAX($B$4:B48)+1)","v":""}]
[null,{"$f":"IF(C50=\"\",\"\",MAX($B$4:B49)+1)","v":""}]
[null,{"$f":"IF(C51=\"\",\"\",MAX($B$4:B50)+1)","v":""}]
[null,{"$f":"IF(C52=\"\",\"\",MAX($B$4:B51)+1)","v":""}]
[null,{"$f":"IF(C53=\"\",\"\",MAX($B$4:B52)+1)","v":""}]
[null,{"$f":"IF(C54=\"\",\"\",MAX($B$4:B53)+1)","v":""}]
[null,{"$f":"IF(C55=\"\",\"\",MAX($B$4:B54)+1)","v":""}]
[null,{"$f":"IF(C56=\"\",\"\",MAX($B$4:B55)+1)","v":""}]
[null,{"$f":"IF(C57=\"\",\"\",MAX($B$4:B56)+1)","v":""}]
[null,{"$f":"IF(C58=\"\",\"\",MAX($B$4:B57)+1)","v":""}]
[null,{"$f":"IF(C59=\"\",\"\",MAX($B$4:B58)+1)","v":""}]
[null,{"$f":"IF(C60=\"\",\"\",MAX($B$4:B59)+1)","v":""}]
[null,{"$f":"IF(C61=\"\",\"\",MAX($B$4:B60)+1)","v":""}]
[null,{"$f":"IF(C62=\"\",\"\",MAX($B$4:B61)+1)","v":""}]
[null,{"$f":"IF(C63=\"\",\"\",MAX($B$4:B62)+1)","v":""}]
[null,{"$f":"IF(C64=\"\",\"\",MAX($B$4:B63)+1)","v":""}]
[null,{"$f":"IF(C65=\"\",\"\",MAX($B$4:B64)+1)","v":""}]
[null,{"$f":"IF(C66=\"\",\"\",MAX($B$4:B65)+1)","v":""}]
[null,{"$f":"IF(C67=\"\",\"\",MAX($B$4:B66)+1)","v":""}]
[null,{"$f":"IF(C68=\"\",\"\",MAX($B$4:B67)+1)","v":""}]
[null,{"$f":"IF(C69=\"\",\"\",MAX($B$4:B68)+1)","v":""}]
[null,{"$f":"IF(C70=\"\",\"\",MAX($B$4:B69)+1)","v":""}]
[null,{"$f":"IF(C71=\"\",\"\",MAX($B$4:B70)+1)","v":""}]
[null,{"$f":"IF(C72=\"\",\"\",MAX($B$4:B71)+1)","v":""}]
[null,{"$f":"IF(C73=\"\",\"\",MAX($B$4:B72)+1)","v":""}]
[null,{"$f":"IF(C74=\"\",\"\",MAX($B$4:B73)+1)","v":""}]
[null,{"$f":"IF(C75=\"\",\"\",MAX($B$4:B74)+1)","v":""}]
[null,{"$f":"IF(C76=\"\",\"\",MAX($B$4:B75)+1)","v":""}]
[null,{"$f":"IF(C77=\"\",\"\",MAX($B$4:B76)+1)","v":""}]
[null,{"$f":"IF(C78=\"\",\"\",MAX($B$4:B77)+1)","v":""}]
[null,{"$f":"IF(C79=\"\",\"\",MAX($B$4:B78)+1)","v":""}]
[null,{"$f":"IF(C80=\"\",\"\",MAX($B$4:B79)+1)","v":""}]
[null,{"$f":"IF(C81=\"\",\"\",MAX($B$4:B80)+1)","v":""}]
[null,{"$f":"IF(C82=\"\",\"\",MAX($B$4:B81)+1)","v":""}]
[null,{"$f":"IF(C83=\"\",\"\",MAX($B$4:B82)+1)","v":""}]
[null,{"$f":"IF(C84=\"\",\"\",MAX($B$4:B83)+1)","v":""}]
[null,{"$f":"IF(C85=\"\",\"\",MAX($B$4:B84)+1)","v":""}]
[null,{"$f":"IF(C86=\"\",\"\",MAX($B$4:B85)+1)","v":""}]
[null,{"$f":"IF(C87=\"\",\"\",MAX($B$4:B86)+1)","v":""}]
[null,{"$f":"IF(C88=\"\",\"\",MAX($B$4:B87)+1)","v":""}]
[null,{"$f":"IF(C89=\"\",\"\",MAX($B$4:B88)+1)","v":""}]
[null,{"$f":"IF(C90=\"\",\"\",MAX($B$4:B89)+1)","v":""}]
[null,{"$f":"IF(C91=\"\",\"\",MAX($B$4:B90)+1)","v":""}]
[null,{"$f":"IF(C92=\"\",\"\",MAX($B$4:B91)+1)","v":""}]
[null,{"$f":"IF(C93=\"\",\"\",MAX($B$4:B92)+1)","v":""}]

{"sheet":"الصندوق","index":1,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان بنك الاهلى المتحد"]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,1,"رصيد الخزينة 3/1 صباحا",null,null,500000,43891]
[{"$f":"IF(C4=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C4:C$724,'[1]مصرف أبو ظبى '!C4),\"\")","v":""},2,"ابراهيم عمر",null,400000,100000,"2020-03-01"]
[{"$f":"IF(C5=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C5:C$724,'[1]مصرف أبو ظبى '!C5),\"\")","v":""},3,"وارد بيع خردة ",100000,null,200000,43892]
[{"$f":"IF(C6=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C6:C$724,'[1]مصرف أبو ظبى '!C6),\"\")","v":""},4,"حسنى كمال رسلان",null,30000,170000,"2020-03-02"]
[{"$f":"IF(C7=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C7:C$724,'[1]مصرف أبو ظبى '!C7),\"\")","v":""},5,"محمد مجدى محمد القناوي",null,15000,155000,"2020-03-02"]
[{"$f":"IF(C8=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C8:C$724,'[1]مصرف أبو ظبى '!C8),\"\")","v":""},6,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,133921,"2020-03-02"]
[{"$f":"IF(C9=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C9:C$724,'[1]مصرف أبو ظبى '!C9),\"\")","v":""},7,"محمد السيد محمد جبر ",null,20000,113921,"2020-03-02"]
[{"$f":"IF(C10=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C10:C$724,'[1]مصرف أبو ظبى '!C10),\"\")","v":""},8,"عهدة محمد أحمد فؤاد ",null,40000,73921,"2020-03-02","شامله عموله البنك"]
[{"$f":"IF(C11=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C11:C$724,'[1]مصرف أبو ظبى '!C11),\"\")","v":""},9,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,43921,43892]
[{"$f":"IF(C12=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C12:C$724,'[1]مصرف أبو ظبى '!C12),\"\")","v":""},10,"طباعة لوحات كفر البطيخ / نبيل البلتاجى",null,75,43846,"2020-03-02"]
[{"$f":"IF(C13=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C13:C$724,'[1]مصرف أبو ظبى '!C13),\"\")","v":""},11,"شركة كونكورد للخرسانة الجاهزة",null,2000,41846,"2020-03-02"]
[{"$f":"IF(C14=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C14:C$724,'[1]مصرف أبو ظبى '!C14),\"\")","v":""},12,"رد عهدة م.معتز مدفوعة الى اسامة شومان 1/25",null,2035,39811,"2020-03-02"]
[{"$f":"IF(C15=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C15:C$724,'[1]مصرف أبو ظبى '!C15),\"\")","v":""},13,"سحب بشيك من مصرف أبو ظبى ",200000,null,239811,43892]
[{"$f":"IF(C16=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C16:C$724,'[1]مصرف أبو ظبى '!C16),\"\")","v":""},14,"رد باقى من استخراج سجل تجاري ",10,null,239821,"2020-03-02"]
[{"$f":"IF(C17=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C17:C$724,'[1]مصرف أبو ظبى '!C17),\"\")","v":""},15,"ابراهيم عمر",null,200000,39821,43892]
[{"$f":"IF(C18=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C18:C$724,'[1]مصرف أبو ظبى '!C18),\"\")","v":""},16,"شركة كونكورد للخرسانة الجاهزة",null,2000,37821,"2020-03-02"]
[{"$f":"IF(C19=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C19:C$724,'[1]مصرف أبو ظبى '!C19),\"\")","v":""},17,"سحب بشيك من بنك مصر ",50000,null,87821,"2020-03-02"]
[{"$f":"IF(C20=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C20:C$724,'[1]مصرف أبو ظبى '!C20),\"\")","v":""},null,"رصيد ابوظبى 2020/3/4م ",null,null,{"$f":"F19+D20-E20","v":87821}]
[{"$f":"IF(C21=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C21:C$724,'[1]مصرف أبو ظبى '!C21),\"\")","v":""},null,"حسنى كمال رسلان",null,30000,57821,"2020-03-05",272]
[{"$f":"IF(C22=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C22:C$724,'[1]مصرف أبو ظبى '!C22),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,15000,42821,"2020-03-05",373]
[{"$f":"IF(C23=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C23:C$724,'[1]مصرف أبو ظبى '!C23),\"\")","v":""},null,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,21742,"2020-03-05",376]
[{"$f":"IF(C24=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C24:C$724,'[1]مصرف أبو ظبى '!C24),\"\")","v":""},null,"محمد السيد محمد جبر ",null,20000,1742,"2020-03-05",377]
[{"$f":"IF(C25=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C25:C$724,'[1]مصرف أبو ظبى '!C25),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,40000,-38258,"2020-03-05",378]
[{"$f":"IF(C26=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C26:C$724,'[1]مصرف أبو ظبى '!C26),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,-68258]
[{"$f":"IF(C27=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C27:C$724,'[1]مصرف أبو ظبى '!C27),\"\")","v":""},null,"ابراهيم عمر",150000,null,81742]
[{"$f":"IF(C28=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C28:C$724,'[1]مصرف أبو ظبى '!C28),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,-18258,"2020-03-09"]
[{"$f":"IF(C29=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C29:C$724,'[1]مصرف أبو ظبى '!C29),\"\")","v":""},null,"ابراهيم عمر",null,45000,-63258]
[{"$f":"IF(C30=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C30:C$724,'[1]مصرف أبو ظبى '!C30),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,80000,-143258,"2020-03-11"]
[{"$f":"IF(C31=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C31:C$724,'[1]مصرف أبو ظبى '!C31),\"\")","v":""},null,"محمد مجدى محمد القناوي",10000,null,-133258]
[{"$f":"IF(C32=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C32:C$724,'[1]مصرف أبو ظبى '!C32),\"\")","v":""},null,"رد مبلغ محجوز تم حجزه لتغطية وعموله خطاب ضمان بيجام ولم \nيتم خصمه من البنك حتى تاريخه",560000,null,426742]
[{"$f":"IF(C33=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C33:C$724,'[1]مصرف أبو ظبى '!C33),\"\")","v":""},null,"أنور عبدالله / الخزينة",null,200000,226742,"2020-03-16"]
[{"$f":"IF(C34=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C34:C$724,'[1]مصرف أبو ظبى '!C34),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,null,226742]
[{"$f":"IF(C35=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C35:C$724,'[1]مصرف أبو ظبى '!C35),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,126742,"2020-03-17"]
[{"$f":"IF(C36=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C36:C$724,'[1]مصرف أبو ظبى '!C36),\"\")","v":""},null,"الرصيد 3/17",null,null,126742]
[{"$f":"IF(C37=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C37:C$724,'[1]مصرف أبو ظبى '!C37),\"\")","v":""},null,"تحويل من مارينا ",1408466,null,1535208]
[{"$f":"IF(C38=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C38:C$724,'[1]مصرف أبو ظبى '!C38),\"\")","v":""},null,"هانى محمد محمد الجوهري",null,30000,1505208,"2020-03-18",384]
[{"$f":"IF(C39=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C39:C$724,'[1]مصرف أبو ظبى '!C39),\"\")","v":""},null,"سحب شيك للخزينة / أنور عبدالله ",null,100000,1405208,"2020-03-18",385]
[{"$f":"IF(C40=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C40:C$724,'[1]مصرف أبو ظبى '!C40),\"\")","v":""},null,"سحب شيك للخزينة / أحمد جاد ",null,120000,1285208,"2020-03-18",386]
[{"$f":"IF(C41=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C41:C$724,'[1]مصرف أبو ظبى '!C41),\"\")","v":""},null,"أحمد محمود عبدالرحيم قبيصى دفعة من مواسير بيجام",null,200000,1085208,"2020-03-18",432]
[{"$f":"IF(C42=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C42:C$724,'[1]مصرف أبو ظبى '!C42),\"\")","v":""},null,"سحب بشيك حاتم بيومى / الخزينة ",null,500000,585208,"2020-03-19",389]
[{"$f":"IF(C43=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C43:C$724,'[1]مصرف أبو ظبى '!C43),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,485208,"2020-03-19",390]
[{"$f":"IF(C44=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C44:C$724,'[1]مصرف أبو ظبى '!C44),\"\")","v":""},null,"طارق عبدالعزيز أحمد عامر - شركة آل عامر ",null,150000,335208,"2020-03-20"]
[{"$f":"IF(C45=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!#REF!),\"\")","v":""},null,"ياسر عرفه محمد (مركز بيتى للدهانات)",null,70000,265208,"2020-03-20",379]
[{"$f":"IF(C46=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!C45),\"\")","v":""},null,"محمد أحمد عبدالسلام / نجارة وحداده سموحه",null,100000,165208,"2020-03-22",392]
[{"$f":"IF(C47=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C46:C$724,'[1]مصرف أبو ظبى '!C46),\"\")","v":""},null,"شيك أنور عبدالله / الخزينة ",null,200000,-34792,"2020-03-23"]
[null,null,"صرف شيك أنور عبدالله / الخزينة ",null,80000,-114792,"2020-03-24",393]
[null,null,"صرف بشيك أنور عبدالله ",null,20000,-134792,"2020-03-25"]
[null,null,"علاء محمد الغريب عطيه",null,405,-135197]
[null,null,"رد مبلغ محجوز تحت حساب خطابات الضمان ",53744.74,null,-81452.260000000009]
[null,null,"تجديد خطاب ضمان دفعة مقدمة عملية اكتوبر اوراسكوم واتش ايه",null,6020,-87472.260000000009]
[null,null,"تحويل من بيجام دفعة مقدمة ",2000000,null,1912527.74,"2020-04-16","تحويل"]
[null,null,"علاء محمد الغريب عطيه",null,200000,1712527.74,"2020-04-22",404]
[null,null,"إبراهيم محمد عمر ",null,100000,1612527.74,"2020-04-22",405]
[null,null,"راضى على الدين ",null,50000,1562527.74,"2020-04-22",406]
[null,null,"محمد ربيعى ",null,35000,1527527.74,"2020-04-22",407]
[null,null,"محمود زارع ",null,35000,1492527.74,"2020-04-22",408]
[null,null,"حسن عوف ",null,83000,1409527.74,"2020-04-22",409]
[null,null,"شركة عمرو / مصنع ستار جى ار بى ",null,200000,1209527.74,"2020-04-22",410]
[null,null,"تحويل الى شركة النصر للمسبوكات ",null,1275000,-65472.260000000009,"2020-04-22","تحويل"]
[null,null,"مصاريف بنكية رسوم كشوف حسابات",null,120,-65592.260000000009]

{"sheet":"المشرق","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان بنك الاهلى المتحد"]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,582000]
[{"$f":"IF(C4=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C4:C$724,'[1]مصرف أبو ظبى '!C4),\"\")","v":""},1," تحت حساب خطابات ضمان دفعة مقدمة عملية طره",null,62000,{"$f":"F3+D4-E4","v":520000},"2020-03-02"]
[{"$f":"IF(C5=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C5:C$724,'[1]مصرف أبو ظبى '!C5),\"\")","v":""},null,"رصيد الاهلى المتحد بعد عمل خطابات الضمان ",null,null,520000]
[{"$f":"IF(C6=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C6:C$724,'[1]مصرف أبو ظبى '!C6),\"\")","v":""},null,"أحمد عبدالنبى / شيك للخزينه / السيوف وتغطية شيك ",null,370000,150000,"2020-03-05",6803316]
[{"$f":"IF(C7=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C7:C$724,'[1]مصرف أبو ظبى '!C7),\"\")","v":""},null,"رصيد 5/3",null,null,150000]
[{"$f":"IF(C8=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C8:C$724,'[1]مصرف أبو ظبى '!C8),\"\")","v":""},null,"سحب بشيك حاتم بيومى / ايداع بنك المؤسسة العربية",null,65000,85000,"2020-03-08",6803317]
[{"$f":"IF(C9=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C9:C$724,'[1]مصرف أبو ظبى '!C9),\"\")","v":""},null,"الرصيد 3/6",null,null,85000]
[{"$f":"IF(C10=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C10:C$724,'[1]مصرف أبو ظبى '!C10),\"\")","v":""},null,"صرف بشيك أنور عبدالله ",null,50000,35000,"2020-03-11"]
[{"$f":"IF(C11=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C11:C$724,'[1]مصرف أبو ظبى '!C11),\"\")","v":""},null,"رصيد ما قبله 3/1",null,null,830000]
[{"$f":"IF(C12=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C12:C$724,'[1]مصرف أبو ظبى '!C12),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,25000,{"$f":"F11+D12-E12","v":805000},"2020-03-02"]
[{"$f":"IF(C13=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C13:C$724,'[1]مصرف أبو ظبى '!C13),\"\")","v":""},null,"أنور عبدالله / م.ابراهيم المترو",null,200000,605000,"2020-03-02"]
[{"$f":"IF(C14=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C14:C$724,'[1]مصرف أبو ظبى '!C14),\"\")","v":""},null,"حمد عبدالعاطى / غفرة القناطر 2 شهر",null,9000,596000,"2020-03-02"]
[{"$f":"IF(C15=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C15:C$724,'[1]مصرف أبو ظبى '!C15),\"\")","v":""},null,"رصيد مصرف أبو ظبى 2020/3/2",null,null,596000]
[{"$f":"IF(C16=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C16:C$724,'[1]مصرف أبو ظبى '!C16),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,200000,396000,"2020-03-10"]
[{"$f":"IF(C17=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C17:C$724,'[1]مصرف أبو ظبى '!C17),\"\")","v":""},null,"ابراهيم عمر",null,50000,346000]
[{"$f":"IF(C18=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C18:C$724,'[1]مصرف أبو ظبى '!C18),\"\")","v":""},null,"علاء محمد الغريب ",null,50000,296000,"2020-03-04"]
[{"$f":"IF(C19=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C19:C$724,'[1]مصرف أبو ظبى '!C19),\"\")","v":""},null,"محمد محرم / عهدة أشرف إسماعيل ",null,34400,261600,"2020-03-04"]
[{"$f":"IF(C20=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C20:C$724,'[1]مصرف أبو ظبى '!C20),\"\")","v":""},null,"رصيد ابوظبى 2020/3/4م ",null,null,261600]
[{"$f":"IF(C21=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C21:C$724,'[1]مصرف أبو ظبى '!C21),\"\")","v":""},null,"حسنى كمال رسلان",null,30000,231600,"2020-03-05",272]
[{"$f":"IF(C22=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C22:C$724,'[1]مصرف أبو ظبى '!C22),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,15000,216600,"2020-03-05",373]
[{"$f":"IF(C23=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C23:C$724,'[1]مصرف أبو ظبى '!C23),\"\")","v":""},null,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,195521,"2020-03-05",376]
[{"$f":"IF(C24=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C24:C$724,'[1]مصرف أبو ظبى '!C24),\"\")","v":""},null,"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377]
[{"$f":"IF(C25=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C25:C$724,'[1]مصرف أبو ظبى '!C25),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,40000,135521,"2020-03-05",378]
[{"$f":"IF(C26=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C26:C$724,'[1]مصرف أبو ظبى '!C26),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,105521]
[{"$f":"IF(C27=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C27:C$724,'[1]مصرف أبو ظبى '!C27),\"\")","v":""},null,"ابراهيم عمر",150000,null,255521]
[{"$f":"IF(C28=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C28:C$724,'[1]مصرف أبو ظبى '!C28),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,155521,"2020-03-09"]
[{"$f":"IF(C29=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C29:C$724,'[1]مصرف أبو ظبى '!C29),\"\")","v":""},null,"ابراهيم عمر",null,45000,110521]
[{"$f":"IF(C30=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C30:C$724,'[1]مصرف أبو ظبى '!C30),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,80000,30521,"2020-03-11"]
[{"$f":"IF(C31=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C31:C$724,'[1]مصرف أبو ظبى '!C31),\"\")","v":""},null,"محمد مجدى محمد القناوي",10000,null,40521]
[{"$f":"IF(C32=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C32:C$724,'[1]مصرف أبو ظبى '!C32),\"\")","v":""},null,"رد مبلغ محجوز تم حجزه لتغطية وعموله خطاب ضمان بيجام ولم \nيتم خصمه من البنك حتى تاريخه",560000,null,600521]
[{"$f":"IF(C33=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C33:C$724,'[1]مصرف أبو ظبى '!C33),\"\")","v":""},null,"أنور عبدالله / الخزينة",null,200000,400521,"2020-03-16"]
[{"$f":"IF(C34=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C34:C$724,'[1]مصرف أبو ظبى '!C34),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,null,400521]
[{"$f":"IF(C35=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C35:C$724,'[1]مصرف أبو ظبى '!C35),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,300521,"2020-03-17"]
[{"$f":"IF(C36=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C36:C$724,'[1]مصرف أبو ظبى '!C36),\"\")","v":""},null,"الرصيد 3/17",null,null,300521]
[{"$f":"IF(C37=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C37:C$724,'[1]مصرف أبو ظبى '!C37),\"\")","v":""},null,"تحويل من مارينا ",1408466,null,1708987]
[{"$f":"IF(C38=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C38:C$724,'[1]مصرف أبو ظبى '!C38),\"\")","v":""},null,"هانى محمد محمد الجوهري",null,30000,1678987,"2020-03-18",384]
[{"$f":"IF(C39=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C39:C$724,'[1]مصرف أبو ظبى '!C39),\"\")","v":""},null,"سحب شيك للخزينة / أنور عبدالله ",null,100000,1578987,"2020-03-18",385]
[{"$f":"IF(C40=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C40:C$724,'[1]مصرف أبو ظبى '!C40),\"\")","v":""},null,"سحب شيك للخزينة / أحمد جاد ",null,120000,1458987,"2020-03-18",386]
[{"$f":"IF(C41=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C41:C$724,'[1]مصرف أبو ظبى '!C41),\"\")","v":""},null,"أحمد محمود عبدالرحيم قبيصى دفعة من مواسير بيجام",null,200000,1258987,"2020-03-18",432]
[{"$f":"IF(C42=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C42:C$724,'[1]مصرف أبو ظبى '!C42),\"\")","v":""},null,"سحب بشيك حاتم بيومى / الخزينة ",null,500000,758987,"2020-03-19",389]
[{"$f":"IF(C43=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C43:C$724,'[1]مصرف أبو ظبى '!C43),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,658987,"2020-03-19",390]
[{"$f":"IF(C44=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C44:C$724,'[1]مصرف أبو ظبى '!C44),\"\")","v":""},null,"طارق عبدالعزيز أحمد عامر - شركة آل عامر ",null,150000,508987,"2020-03-20"]
[{"$f":"IF(C45=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!#REF!),\"\")","v":""},null,"ياسر عرفه محمد (مركز بيتى للدهانات)",null,70000,438987,"2020-03-20",379]
[{"$f":"IF(C46=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!C45),\"\")","v":""},null,"محمد أحمد عبدالسلام / نجارة وحداده سموحه",null,100000,338987,"2020-03-22",392]
[{"$f":"IF(C47=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C46:C$724,'[1]مصرف أبو ظبى '!C46),\"\")","v":""},null,"شيك أنور عبدالله / الخزينة ",null,200000,138987,"2020-03-23"]
[null,null,"صرف شيك أنور عبدالله / الخزينة ",null,80000,58987,"2020-03-24",393]
[null,null,"صرف بشيك أنور عبدالله ",null,20000,38987,"2020-03-25"]
[null,null,"علاء محمد الغريب عطيه",null,405,38582]
[null,null,"رد مبلغ محجوز تحت حساب خطابات الضمان ",53744.74,null,92326.739999999991]
[null,null,"تجديد خطاب ضمان دفعة مقدمة عملية اكتوبر اوراسكوم واتش ايه",null,6020,86306.739999999991]
[null,null,"تحويل من بيجام دفعة مقدمة ",2000000,null,2086306.74,"2020-04-16","تحويل"]
[null,null,"علاء محمد الغريب عطيه",null,200000,1886306.74,"2020-04-22",404]
[null,null,"إبراهيم محمد عمر ",null,100000,1786306.74,"2020-04-22",405]
[null,null,"راضى على الدين ",null,50000,1736306.74,"2020-04-22",406]
[null,null,"محمد ربيعى ",null,35000,1701306.74,"2020-04-22",407]
[null,null,"محمود زارع ",null,35000,1666306.74,"2020-04-22",408]
[null,null,"حسن عوف ",null,83000,1583306.74,"2020-04-22",409]
[null,null,"شركة عمرو / مصنع ستار جى ار بى ",null,200000,1383306.74,"2020-04-22",410]
[null,null,"تحويل الى شركة النصر للمسبوكات ",null,1275000,108306.73999999999,"2020-04-22","تحويل"]
[null,null,"مصاريف بنكية رسوم كشوف حسابات",null,120,108186.73999999999]

{"sheet":"مصرف أبو ظبى ","index":3,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,1,0,6],[75,2,75,7]]}
[null,"بيــــــــــــــان مصرف أبو ظبى "]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,830000]
[{"$f":"IF(C4=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C4:C$724,'[1]مصرف أبو ظبى '!C4),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,25000,{"$f":"F3+D4-E4","v":805000},"2020-03-02"]
[{"$f":"IF(C5=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C5:C$724,'[1]مصرف أبو ظبى '!C5),\"\")","v":""},null,"أنور عبدالله / م.ابراهيم المترو",null,200000,605000,"2020-03-02"]
[{"$f":"IF(C6=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C6:C$724,'[1]مصرف أبو ظبى '!C6),\"\")","v":""},null,"حمد عبدالعاطى / غفرة القناطر 2 شهر",null,9000,596000,"2020-03-02"]
[{"$f":"IF(C7=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C7:C$724,'[1]مصرف أبو ظبى '!C7),\"\")","v":""},null,"رصيد مصرف أبو ظبى 2020/3/2",null,null,596000]
[{"$f":"IF(C8=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C8:C$724,'[1]مصرف أبو ظبى '!C8),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,200000,396000,"2020-03-10"]
[{"$f":"IF(C9=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C9:C$724,'[1]مصرف أبو ظبى '!C9),\"\")","v":""},null,"ابراهيم عمر",null,50000,346000]
[{"$f":"IF(C10=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C10:C$724,'[1]مصرف أبو ظبى '!C10),\"\")","v":""},null,"علاء محمد الغريب ",null,50000,296000,"2020-03-04"]
[{"$f":"IF(C11=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C11:C$724,'[1]مصرف أبو ظبى '!C11),\"\")","v":""},null,"محمد محرم / عهدة أشرف إسماعيل ",null,34400,261600,"2020-03-04"]
[{"$f":"IF(C12=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C12:C$724,'[1]مصرف أبو ظبى '!C12),\"\")","v":""},null,"رصيد ابوظبى 2020/3/4م ",null,null,261600]
[{"$f":"IF(C13=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C13:C$724,'[1]مصرف أبو ظبى '!C13),\"\")","v":""},null,"حسنى كمال رسلان",null,30000,231600,"2020-03-05",272]
[{"$f":"IF(C14=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C14:C$724,'[1]مصرف أبو ظبى '!C14),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,15000,216600,"2020-03-05",373]
[{"$f":"IF(C15=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C15:C$724,'[1]مصرف أبو ظبى '!C15),\"\")","v":""},null,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,195521,"2020-03-05",376]
[{"$f":"IF(C16=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C16:C$724,'[1]مصرف أبو ظبى '!C16),\"\")","v":""},null,"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377]
[{"$f":"IF(C17=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C17:C$724,'[1]مصرف أبو ظبى '!C17),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,40000,135521,"2020-03-05",378]
[{"$f":"IF(C18=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C18:C$724,'[1]مصرف أبو ظبى '!C18),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,105521]
[{"$f":"IF(C19=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C19:C$724,'[1]مصرف أبو ظبى '!C19),\"\")","v":""},null,"ابراهيم عمر",150000,null,255521]
[{"$f":"IF(C20=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C20:C$724,'[1]مصرف أبو ظبى '!C20),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,155521,"2020-03-09"]
[{"$f":"IF(C21=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C21:C$724,'[1]مصرف أبو ظبى '!C21),\"\")","v":""},null,"ابراهيم عمر",null,45000,110521]
[{"$f":"IF(C22=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C22:C$724,'[1]مصرف أبو ظبى '!C22),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,80000,30521,"2020-03-11"]
[{"$f":"IF(C23=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C23:C$724,'[1]مصرف أبو ظبى '!C23),\"\")","v":""},null,"محمد مجدى محمد القناوي",10000,null,40521]
[{"$f":"IF(C24=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C24:C$724,'[1]مصرف أبو ظبى '!C24),\"\")","v":""},null,"رد مبلغ محجوز تم حجزه لتغطية وعموله خطاب ضمان بيجام ولم \nيتم خصمه من البنك حتى تاريخه",560000,null,600521]
[{"$f":"IF(C25=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C25:C$724,'[1]مصرف أبو ظبى '!C25),\"\")","v":""},null,"أنور عبدالله / الخزينة",null,200000,400521,"2020-03-16"]
[{"$f":"IF(C26=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C26:C$724,'[1]مصرف أبو ظبى '!C26),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,null,400521]
[{"$f":"IF(C27=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C27:C$724,'[1]مصرف أبو ظبى '!C27),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,300521,"2020-03-17"]
[{"$f":"IF(C28=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C28:C$724,'[1]مصرف أبو ظبى '!C28),\"\")","v":""},null,"الرصيد 3/17",null,null,300521]
[{"$f":"IF(C29=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C29:C$724,'[1]مصرف أبو ظبى '!C29),\"\")","v":""},null,"تحويل من مارينا ",1408466,null,1708987,null,null,null,null,null,null,null,{"$f":"F29+I3","v":1708987}]
[{"$f":"IF(C30=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C30:C$724,'[1]مصرف أبو ظبى '!C30),\"\")","v":""},null,"هانى محمد محمد الجوهري",null,30000,1678987,"2020-03-18",384]
[{"$f":"IF(C31=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C31:C$724,'[1]مصرف أبو ظبى '!C31),\"\")","v":""},null,"سحب شيك للخزينة / أنور عبدالله ",null,100000,1578987,"2020-03-18",385]
[{"$f":"IF(C32=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C32:C$724,'[1]مصرف أبو ظبى '!C32),\"\")","v":""},null,"سحب شيك للخزينة / أحمد جاد ",null,120000,1458987,"2020-03-18",386]
[{"$f":"IF(C33=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C33:C$724,'[1]مصرف أبو ظبى '!C33),\"\")","v":""},null,"أحمد محمود عبدالرحيم قبيصى دفعة من مواسير بيجام",null,200000,1258987,"2020-03-18",432]
[{"$f":"IF(C34=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C34:C$724,'[1]مصرف أبو ظبى '!C34),\"\")","v":""},null,"سحب بشيك حاتم بيومى / الخزينة ",null,500000,758987,"2020-03-19",389]
[{"$f":"IF(C35=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C35:C$724,'[1]مصرف أبو ظبى '!C35),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,658987,"2020-03-19",390]
[{"$f":"IF(C36=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C36:C$724,'[1]مصرف أبو ظبى '!C36),\"\")","v":""},null,"طارق عبدالعزيز أحمد عامر - شركة آل عامر ",null,150000,508987,"2020-03-20"]
[{"$f":"IF(C37=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C37:C$724,'[1]مصرف أبو ظبى '!C37),\"\")","v":""},null,"ياسر عرفه محمد (مركز بيتى للدهانات)",null,70000,438987,"2020-03-20",379]
[{"$f":"IF(C38=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C38:C$724,'[1]مصرف أبو ظبى '!C38),\"\")","v":""},null,"محمد أحمد عبدالسلام / نجارة وحداده سموحه",null,100000,338987,"2020-03-22",392]
[{"$f":"IF(C39=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C39:C$724,'[1]مصرف أبو ظبى '!C39),\"\")","v":""},null,"شيك أنور عبدالله / الخزينة ",null,200000,138987,"2020-03-23"]
[{"$f":"IF(C40=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C40:C$724,'[1]مصرف أبو ظبى '!C40),\"\")","v":""},null,"صرف شيك أنور عبدالله / الخزينة ",null,80000,58987,"2020-03-24",393]
[{"$f":"IF(C41=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C41:C$724,'[1]مصرف أبو ظبى '!C41),\"\")","v":""},null,"صرف بشيك أنور عبدالله ",null,20000,38987,"2020-03-25"]
[{"$f":"IF(C42=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C42:C$724,'[1]مصرف أبو ظبى '!C42),\"\")","v":""},null,"علاء محمد الغريب عطيه",null,405,38582]
[{"$f":"IF(C43=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C43:C$724,'[1]مصرف أبو ظبى '!C43),\"\")","v":""},null,"رد مبلغ محجوز تحت حساب خطابات الضمان ",53744.74,null,92326.739999999991]
[{"$f":"IF(C44=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C44:C$724,'[1]مصرف أبو ظبى '!C44),\"\")","v":""},null,"تجديد خطاب ضمان دفعة مقدمة عملية اكتوبر اوراسكوم واتش ايه",null,6020,86306.739999999991]
[{"$f":"IF(C45=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!C45),\"\")","v":""},null,"تحويل من بيجام دفعة مقدمة ",2000000,null,2086306.74,"2020-04-16","تحويل"]
[{"$f":"IF(C46=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C46:C$724,'[1]مصرف أبو ظبى '!C46),\"\")","v":""},null,"علاء محمد الغريب عطيه",null,200000,1886306.74,"2020-04-22",404]
[{"$f":"IF(C47=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C47:C$724,'[1]مصرف أبو ظبى '!C47),\"\")","v":""},null,"إبراهيم محمد عمر ",null,100000,1786306.74,"2020-04-22",405]
[{"$f":"IF(C48=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C48:C$724,'[1]مصرف أبو ظبى '!C48),\"\")","v":""},null,"راضى على الدين ",null,50000,1736306.74,"2020-04-22",406]
[{"$f":"IF(C49=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C49:C$724,'[1]مصرف أبو ظبى '!C49),\"\")","v":""},null,"محمد ربيعى ",null,35000,1701306.74,"2020-04-22",407]
[{"$f":"IF(C50=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C50:C$724,'[1]مصرف أبو ظبى '!C50),\"\")","v":""},null,"محمود زارع ",null,35000,1666306.74,"2020-04-22",408]
[{"$f":"IF(C51=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C51:C$724,'[1]مصرف أبو ظبى '!C51),\"\")","v":""},null,"حسن عوف ",null,83000,1583306.74,"2020-04-22",409]
[{"$f":"IF(C52=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C52:C$724,'[1]مصرف أبو ظبى '!C52),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,200000,1383306.74,"2020-04-22",410]
[{"$f":"IF(C53=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C53:C$724,'[1]مصرف أبو ظبى '!C53),\"\")","v":""},null,"تحويل الى شركة النصر للمسبوكات ",null,1275000,108306.73999999999,"2020-04-22","تحويل"]
[{"$f":"IF(C54=[1]استعلام!$B$3,COUNTIF('[1]مصرف أبو ظبى '!$C54:C$724,'[1]مصرف أبو ظبى '!C54),\"\")","v":""},null,"مصاريف بنكية رسوم كشوف حسابات",null,120,108186.73999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"بيـــــــــــــــــان خاص بالفريحة "]
[null,null,"البيــــــــــــــــــان ","ما تم تحصيله ","المصروفات المباشرة","الرصيد","التاريخ"]
[null,null,"وارد شيك دفعة مقدمة بنى عبس ",4001364,null,{"$f":"D78","v":4001364}]
[null,null,"وارد شيك دفعة مقدمة قرية إبراهيم حسن ",7486822,null,{"$f":"F78+D79-E79","v":11488186}]
[null,null,"وارد شيك دفعة مقدمة منشأة الامير ",6057918,null,{"$f":"F79+D80-E80","v":17546104}]
[null,null,"مصاريف خطابات الضمان الابتدائى 3 مشروعات ",null,8210,17537894]
[null,null,"محجوز غطاء ضمان نهائى 3 مشروعات الفرايحة ",null,877305.2,16660588.800000001]
[null,null,"عمولات اصدار خطابات ضمان نهائى الفرايحة 3مشروعات ",null,140456.84,16520131.960000001]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية بنى عبس ",null,{"$f":"D78*0.05","v":200068.2},16320063.760000002]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية إبراهيم حسن ",null,{"$f":"D79*0.05","v":374341.10000000003},15945722.660000002]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية منشأة الامير",null,{"$f":"D80*0.05","v":302895.90000000002},15642826.760000002]
[null,null,"عمولات اصدار خطابات ضمان الدفعة المقدمة الفرايحة 3مشروعات ",null,210553.25,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]

{"sheet":"الاهلى المتحد","index":4,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان بنك الاهلى المتحد"]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,582000]
[{"$f":"IF(C4=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C4:C$724,'[1]مصرف أبو ظبى '!C4),\"\")","v":""},1," تحت حساب خطابات ضمان دفعة مقدمة عملية طره",null,62000,{"$f":"F3+D4-E4","v":520000},"2020-03-02"]
[{"$f":"IF(C5=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C5:C$724,'[1]مصرف أبو ظبى '!C5),\"\")","v":""},null,"رصيد الاهلى المتحد بعد عمل خطابات الضمان ",null,null,520000]
[{"$f":"IF(C6=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C6:C$724,'[1]مصرف أبو ظبى '!C6),\"\")","v":""},null,"أحمد عبدالنبى / شيك للخزينه / السيوف وتغطية شيك ",null,370000,150000,"2020-03-05",6803316]
[{"$f":"IF(C7=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C7:C$724,'[1]مصرف أبو ظبى '!C7),\"\")","v":""},null,"رصيد 5/3",null,null,150000]
[{"$f":"IF(C8=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C8:C$724,'[1]مصرف أبو ظبى '!C8),\"\")","v":""},null,"سحب بشيك حاتم بيومى / ايداع بنك المؤسسة العربية",null,65000,85000,"2020-03-08",6803317]
[{"$f":"IF(C9=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C9:C$724,'[1]مصرف أبو ظبى '!C9),\"\")","v":""},null,"الرصيد 3/6",null,null,85000]
[{"$f":"IF(C10=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C10:C$724,'[1]مصرف أبو ظبى '!C10),\"\")","v":""},null,"صرف بشيك أنور عبدالله ",null,50000,35000,"2020-03-11"]
[{"$f":"IF(C11=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C11:C$724,'[1]مصرف أبو ظبى '!C11),\"\")","v":""},null,"رصيد ما قبله 3/1",null,null,830000]
[{"$f":"IF(C12=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C12:C$724,'[1]مصرف أبو ظبى '!C12),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,25000,{"$f":"F11+D12-E12","v":805000},"2020-03-02"]
[{"$f":"IF(C13=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C13:C$724,'[1]مصرف أبو ظبى '!C13),\"\")","v":""},null,"أنور عبدالله / م.ابراهيم المترو",null,200000,605000,"2020-03-02"]
[{"$f":"IF(C14=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C14:C$724,'[1]مصرف أبو ظبى '!C14),\"\")","v":""},null,"حمد عبدالعاطى / غفرة القناطر 2 شهر",null,9000,596000,"2020-03-02"]
[{"$f":"IF(C15=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C15:C$724,'[1]مصرف أبو ظبى '!C15),\"\")","v":""},null,"رصيد مصرف أبو ظبى 2020/3/2",null,null,596000]
[{"$f":"IF(C16=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C16:C$724,'[1]مصرف أبو ظبى '!C16),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,200000,396000,"2020-03-10"]
[{"$f":"IF(C17=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C17:C$724,'[1]مصرف أبو ظبى '!C17),\"\")","v":""},null,"ابراهيم عمر",null,50000,346000]
[{"$f":"IF(C18=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C18:C$724,'[1]مصرف أبو ظبى '!C18),\"\")","v":""},null,"علاء محمد الغريب ",null,50000,296000,"2020-03-04"]
[{"$f":"IF(C19=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C19:C$724,'[1]مصرف أبو ظبى '!C19),\"\")","v":""},null,"محمد محرم / عهدة أشرف إسماعيل ",null,34400,261600,"2020-03-04"]
[{"$f":"IF(C20=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C20:C$724,'[1]مصرف أبو ظبى '!C20),\"\")","v":""},null,"رصيد ابوظبى 2020/3/4م ",null,null,261600]
[{"$f":"IF(C21=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C21:C$724,'[1]مصرف أبو ظبى '!C21),\"\")","v":""},null,"حسنى كمال رسلان",null,30000,231600,"2020-03-05",272]
[{"$f":"IF(C22=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C22:C$724,'[1]مصرف أبو ظبى '!C22),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,15000,216600,"2020-03-05",373]
[{"$f":"IF(C23=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C23:C$724,'[1]مصرف أبو ظبى '!C23),\"\")","v":""},null,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,195521,"2020-03-05",376]
[{"$f":"IF(C24=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C24:C$724,'[1]مصرف أبو ظبى '!C24),\"\")","v":""},null,"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377]
[{"$f":"IF(C25=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C25:C$724,'[1]مصرف أبو ظبى '!C25),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,40000,135521,"2020-03-05",378]
[{"$f":"IF(C26=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C26:C$724,'[1]مصرف أبو ظبى '!C26),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,105521]
[{"$f":"IF(C27=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C27:C$724,'[1]مصرف أبو ظبى '!C27),\"\")","v":""},null,"ابراهيم عمر",150000,null,255521]
[{"$f":"IF(C28=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C28:C$724,'[1]مصرف أبو ظبى '!C28),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,155521,"2020-03-09"]
[{"$f":"IF(C29=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C29:C$724,'[1]مصرف أبو ظبى '!C29),\"\")","v":""},null,"ابراهيم عمر",null,45000,110521]
[{"$f":"IF(C30=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C30:C$724,'[1]مصرف أبو ظبى '!C30),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,80000,30521,"2020-03-11"]
[{"$f":"IF(C31=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C31:C$724,'[1]مصرف أبو ظبى '!C31),\"\")","v":""},null,"محمد مجدى محمد القناوي",10000,null,40521]
[{"$f":"IF(C32=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C32:C$724,'[1]مصرف أبو ظبى '!C32),\"\")","v":""},null,"رد مبلغ محجوز تم حجزه لتغطية وعموله خطاب ضمان بيجام ولم \nيتم خصمه من البنك حتى تاريخه",560000,null,600521]
[{"$f":"IF(C33=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C33:C$724,'[1]مصرف أبو ظبى '!C33),\"\")","v":""},null,"أنور عبدالله / الخزينة",null,200000,400521,"2020-03-16"]
[{"$f":"IF(C34=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C34:C$724,'[1]مصرف أبو ظبى '!C34),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,null,400521]
[{"$f":"IF(C35=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C35:C$724,'[1]مصرف أبو ظبى '!C35),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,300521,"2020-03-17"]
[{"$f":"IF(C36=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C36:C$724,'[1]مصرف أبو ظبى '!C36),\"\")","v":""},null,"الرصيد 3/17",null,null,300521]
[{"$f":"IF(C37=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C37:C$724,'[1]مصرف أبو ظبى '!C37),\"\")","v":""},null,"تحويل من مارينا ",1408466,null,1708987]
[{"$f":"IF(C38=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C38:C$724,'[1]مصرف أبو ظبى '!C38),\"\")","v":""},null,"هانى محمد محمد الجوهري",null,30000,1678987,"2020-03-18",384]
[{"$f":"IF(C39=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C39:C$724,'[1]مصرف أبو ظبى '!C39),\"\")","v":""},null,"سحب شيك للخزينة / أنور عبدالله ",null,100000,1578987,"2020-03-18",385]
[{"$f":"IF(C40=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C40:C$724,'[1]مصرف أبو ظبى '!C40),\"\")","v":""},null,"سحب شيك للخزينة / أحمد جاد ",null,120000,1458987,"2020-03-18",386]
[{"$f":"IF(C41=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C41:C$724,'[1]مصرف أبو ظبى '!C41),\"\")","v":""},null,"أحمد محمود عبدالرحيم قبيصى دفعة من مواسير بيجام",null,200000,1258987,"2020-03-18",432]
[{"$f":"IF(C42=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C42:C$724,'[1]مصرف أبو ظبى '!C42),\"\")","v":""},null,"سحب بشيك حاتم بيومى / الخزينة ",null,500000,758987,"2020-03-19",389]
[{"$f":"IF(C43=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C43:C$724,'[1]مصرف أبو ظبى '!C43),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,658987,"2020-03-19",390]
[{"$f":"IF(C44=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C44:C$724,'[1]مصرف أبو ظبى '!C44),\"\")","v":""},null,"طارق عبدالعزيز أحمد عامر - شركة آل عامر ",null,150000,508987,"2020-03-20"]
[{"$f":"IF(C45=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!#REF!),\"\")","v":""},null,"ياسر عرفه محمد (مركز بيتى للدهانات)",null,70000,438987,"2020-03-20",379]
[{"$f":"IF(C46=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C45:C$724,'[1]مصرف أبو ظبى '!C45),\"\")","v":""},null,"محمد أحمد عبدالسلام / نجارة وحداده سموحه",null,100000,338987,"2020-03-22",392]
[{"$f":"IF(C47=[1]استعلام!$C$5,COUNTIF('[1]مصرف أبو ظبى '!$C46:C$724,'[1]مصرف أبو ظبى '!C46),\"\")","v":""},null,"شيك أنور عبدالله / الخزينة ",null,200000,138987,"2020-03-23"]
[null,null,"صرف شيك أنور عبدالله / الخزينة ",null,80000,58987,"2020-03-24",393]
[null,null,"صرف بشيك أنور عبدالله ",null,20000,38987,"2020-03-25"]
[null,null,"علاء محمد الغريب عطيه",null,405,38582]
[null,null,"رد مبلغ محجوز تحت حساب خطابات الضمان ",53744.74,null,92326.739999999991]
[null,null,"تجديد خطاب ضمان دفعة مقدمة عملية اكتوبر اوراسكوم واتش ايه",null,6020,86306.739999999991]
[null,null,"تحويل من بيجام دفعة مقدمة ",2000000,null,2086306.74,"2020-04-16","تحويل"]
[null,null,"علاء محمد الغريب عطيه",null,200000,1886306.74,"2020-04-22",404]
[null,null,"إبراهيم محمد عمر ",null,100000,1786306.74,"2020-04-22",405]
[null,null,"راضى على الدين ",null,50000,1736306.74,"2020-04-22",406]
[null,null,"محمد ربيعى ",null,35000,1701306.74,"2020-04-22",407]
[null,null,"محمود زارع ",null,35000,1666306.74,"2020-04-22",408]
[null,null,"حسن عوف ",null,83000,1583306.74,"2020-04-22",409]
[null,null,"شركة عمرو / مصنع ستار جى ار بى ",null,200000,1383306.74,"2020-04-22",410]
[null,null,"تحويل الى شركة النصر للمسبوكات ",null,1275000,108306.73999999999,"2020-04-22","تحويل"]
[null,null,"مصاريف بنكية رسوم كشوف حسابات",null,120,108186.73999999999]

{"sheet":"مصر","index":5,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,1,0,6],[75,2,75,7]]}
[null,"بيــــــــــــــان مصرف أبو ظبى "]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,830000]
[{"$f":"IF(C4=[1]استعلام!$B$3,COUNTIF([1]مصر!$C4:C$724,[1]مصر!C4),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,25000,{"$f":"F3+D4-E4","v":805000},"2020-03-02"]
[{"$f":"IF(C5=[1]استعلام!$B$3,COUNTIF([1]مصر!$C5:C$724,[1]مصر!C5),\"\")","v":""},null,"أنور عبدالله / م.ابراهيم المترو",null,200000,605000,"2020-03-02"]
[{"$f":"IF(C6=[1]استعلام!$B$3,COUNTIF([1]مصر!$C6:C$724,[1]مصر!C6),\"\")","v":""},null,"حمد عبدالعاطى / غفرة القناطر 2 شهر",null,9000,596000,"2020-03-02"]
[{"$f":"IF(C7=[1]استعلام!$B$3,COUNTIF([1]مصر!$C7:C$724,[1]مصر!C7),\"\")","v":""},null,"رصيد مصرف أبو ظبى 2020/3/2",null,null,596000]
[{"$f":"IF(C8=[1]استعلام!$B$3,COUNTIF([1]مصر!$C8:C$724,[1]مصر!C8),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,200000,396000,"2020-03-10"]
[{"$f":"IF(C9=[1]استعلام!$B$3,COUNTIF([1]مصر!$C9:C$724,[1]مصر!C9),\"\")","v":""},null,"ابراهيم عمر",null,50000,346000]
[{"$f":"IF(C10=[1]استعلام!$B$3,COUNTIF([1]مصر!$C10:C$724,[1]مصر!C10),\"\")","v":""},null,"علاء محمد الغريب ",null,50000,296000,"2020-03-04"]
[{"$f":"IF(C11=[1]استعلام!$B$3,COUNTIF([1]مصر!$C11:C$724,[1]مصر!C11),\"\")","v":""},null,"محمد محرم / عهدة أشرف إسماعيل ",null,34400,261600,"2020-03-04"]
[{"$f":"IF(C12=[1]استعلام!$B$3,COUNTIF([1]مصر!$C12:C$724,[1]مصر!C12),\"\")","v":""},null,"رصيد ابوظبى 2020/3/4م ",null,null,261600]
[{"$f":"IF(C13=[1]استعلام!$B$3,COUNTIF([1]مصر!$C13:C$724,[1]مصر!C13),\"\")","v":""},null,"حسنى كمال رسلان",null,30000,231600,"2020-03-05",272]
[{"$f":"IF(C14=[1]استعلام!$B$3,COUNTIF([1]مصر!$C14:C$724,[1]مصر!C14),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,15000,216600,"2020-03-05",373]
[{"$f":"IF(C15=[1]استعلام!$B$3,COUNTIF([1]مصر!$C15:C$724,[1]مصر!C15),\"\")","v":""},null,"محمود السيد محمد عبدالمجيد (حفر العاصمة)",null,21079,195521,"2020-03-05",376]
[{"$f":"IF(C16=[1]استعلام!$B$3,COUNTIF([1]مصر!$C16:C$724,[1]مصر!C16),\"\")","v":""},null,"محمد السيد محمد جبر ",null,20000,175521,"2020-03-05",377]
[{"$f":"IF(C17=[1]استعلام!$B$3,COUNTIF([1]مصر!$C17:C$724,[1]مصر!C17),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,40000,135521,"2020-03-05",378]
[{"$f":"IF(C18=[1]استعلام!$B$3,COUNTIF([1]مصر!$C18:C$724,[1]مصر!C18),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,30000,105521]
[{"$f":"IF(C19=[1]استعلام!$B$3,COUNTIF([1]مصر!$C19:C$724,[1]مصر!C19),\"\")","v":""},null,"ابراهيم عمر",150000,null,255521]
[{"$f":"IF(C20=[1]استعلام!$B$3,COUNTIF([1]مصر!$C20:C$724,[1]مصر!C20),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,155521,"2020-03-09"]
[{"$f":"IF(C21=[1]استعلام!$B$3,COUNTIF([1]مصر!$C21:C$724,[1]مصر!C21),\"\")","v":""},null,"ابراهيم عمر",null,45000,110521]
[{"$f":"IF(C22=[1]استعلام!$B$3,COUNTIF([1]مصر!$C22:C$724,[1]مصر!C22),\"\")","v":""},null,"محمد مجدى محمد القناوي",null,80000,30521,"2020-03-11"]
[{"$f":"IF(C23=[1]استعلام!$B$3,COUNTIF([1]مصر!$C23:C$724,[1]مصر!C23),\"\")","v":""},null,"محمد مجدى محمد القناوي",10000,null,40521]
[{"$f":"IF(C24=[1]استعلام!$B$3,COUNTIF([1]مصر!$C24:C$724,[1]مصر!C24),\"\")","v":""},null,"رد مبلغ محجوز تم حجزه لتغطية وعموله خطاب ضمان بيجام ولم \nيتم خصمه من البنك حتى تاريخه",560000,null,600521]
[{"$f":"IF(C25=[1]استعلام!$B$3,COUNTIF([1]مصر!$C25:C$724,[1]مصر!C25),\"\")","v":""},null,"أنور عبدالله / الخزينة",null,200000,400521,"2020-03-16"]
[{"$f":"IF(C26=[1]استعلام!$B$3,COUNTIF([1]مصر!$C26:C$724,[1]مصر!C26),\"\")","v":""},null,"عهدة محمد أحمد فؤاد ",null,null,400521]
[{"$f":"IF(C27=[1]استعلام!$B$3,COUNTIF([1]مصر!$C27:C$724,[1]مصر!C27),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,300521,"2020-03-17"]
[{"$f":"IF(C28=[1]استعلام!$B$3,COUNTIF([1]مصر!$C28:C$724,[1]مصر!C28),\"\")","v":""},null,"الرصيد 3/17",null,null,300521]
[{"$f":"IF(C29=[1]استعلام!$B$3,COUNTIF([1]مصر!$C29:C$724,[1]مصر!C29),\"\")","v":""},null,"تحويل من مارينا ",1408466,null,1708987,null,null,null,null,null,null,null,{"$f":"F29+I3","v":1708987}]
[{"$f":"IF(C30=[1]استعلام!$B$3,COUNTIF([1]مصر!$C30:C$724,[1]مصر!C30),\"\")","v":""},null,"هانى محمد محمد الجوهري",null,30000,1678987,"2020-03-18",384]
[{"$f":"IF(C31=[1]استعلام!$B$3,COUNTIF([1]مصر!$C31:C$724,[1]مصر!C31),\"\")","v":""},null,"سحب شيك للخزينة / أنور عبدالله ",null,100000,1578987,"2020-03-18",385]
[{"$f":"IF(C32=[1]استعلام!$B$3,COUNTIF([1]مصر!$C32:C$724,[1]مصر!C32),\"\")","v":""},null,"سحب شيك للخزينة / أحمد جاد ",null,120000,1458987,"2020-03-18",386]
[{"$f":"IF(C33=[1]استعلام!$B$3,COUNTIF([1]مصر!$C33:C$724,[1]مصر!C33),\"\")","v":""},null,"أحمد محمود عبدالرحيم قبيصى دفعة من مواسير بيجام",null,200000,1258987,"2020-03-18",432]
[{"$f":"IF(C34=[1]استعلام!$B$3,COUNTIF([1]مصر!$C34:C$724,[1]مصر!C34),\"\")","v":""},null,"سحب بشيك حاتم بيومى / الخزينة ",null,500000,758987,"2020-03-19",389]
[{"$f":"IF(C35=[1]استعلام!$B$3,COUNTIF([1]مصر!$C35:C$724,[1]مصر!C35),\"\")","v":""},null,"سحب بشيك أنور عبدالله / الخزينة",null,100000,658987,"2020-03-19",390]
[{"$f":"IF(C36=[1]استعلام!$B$3,COUNTIF([1]مصر!$C36:C$724,[1]مصر!C36),\"\")","v":""},null,"طارق عبدالعزيز أحمد عامر - شركة آل عامر ",null,150000,508987,"2020-03-20"]
[{"$f":"IF(C37=[1]استعلام!$B$3,COUNTIF([1]مصر!$C37:C$724,[1]مصر!C37),\"\")","v":""},null,"ياسر عرفه محمد (مركز بيتى للدهانات)",null,70000,438987,"2020-03-20",379]
[{"$f":"IF(C38=[1]استعلام!$B$3,COUNTIF([1]مصر!$C38:C$724,[1]مصر!C38),\"\")","v":""},null,"محمد أحمد عبدالسلام / نجارة وحداده سموحه",null,100000,338987,"2020-03-22",392]
[{"$f":"IF(C39=[1]استعلام!$B$3,COUNTIF([1]مصر!$C39:C$724,[1]مصر!C39),\"\")","v":""},null,"شيك أنور عبدالله / الخزينة ",null,200000,138987,"2020-03-23"]
[{"$f":"IF(C40=[1]استعلام!$B$3,COUNTIF([1]مصر!$C40:C$724,[1]مصر!C40),\"\")","v":""},null,"صرف شيك أنور عبدالله / الخزينة ",null,80000,58987,"2020-03-24",393]
[{"$f":"IF(C41=[1]استعلام!$B$3,COUNTIF([1]مصر!$C41:C$724,[1]مصر!C41),\"\")","v":""},null,"صرف بشيك أنور عبدالله ",null,20000,38987,"2020-03-25"]
[{"$f":"IF(C42=[1]استعلام!$B$3,COUNTIF([1]مصر!$C42:C$724,[1]مصر!C42),\"\")","v":""},null,"علاء محمد الغريب عطيه",null,405,38582]
[{"$f":"IF(C43=[1]استعلام!$B$3,COUNTIF([1]مصر!$C43:C$724,[1]مصر!C43),\"\")","v":""},null,"رد مبلغ محجوز تحت حساب خطابات الضمان ",53744.74,null,92326.739999999991]
[{"$f":"IF(C44=[1]استعلام!$B$3,COUNTIF([1]مصر!$C44:C$724,[1]مصر!C44),\"\")","v":""},null,"تجديد خطاب ضمان دفعة مقدمة عملية اكتوبر اوراسكوم واتش ايه",null,6020,86306.739999999991]
[{"$f":"IF(C45=[1]استعلام!$B$3,COUNTIF([1]مصر!$C45:C$724,[1]مصر!C45),\"\")","v":""},null,"تحويل من بيجام دفعة مقدمة ",2000000,null,2086306.74,"2020-04-16","تحويل"]
[{"$f":"IF(C46=[1]استعلام!$B$3,COUNTIF([1]مصر!$C46:C$724,[1]مصر!C46),\"\")","v":""},null,"علاء محمد الغريب عطيه",null,200000,1886306.74,"2020-04-22",404]
[{"$f":"IF(C47=[1]استعلام!$B$3,COUNTIF([1]مصر!$C47:C$724,[1]مصر!C47),\"\")","v":""},null,"إبراهيم محمد عمر ",null,100000,1786306.74,"2020-04-22",405]
[{"$f":"IF(C48=[1]استعلام!$B$3,COUNTIF([1]مصر!$C48:C$724,[1]مصر!C48),\"\")","v":""},null,"راضى على الدين ",null,50000,1736306.74,"2020-04-22",406]
[{"$f":"IF(C49=[1]استعلام!$B$3,COUNTIF([1]مصر!$C49:C$724,[1]مصر!C49),\"\")","v":""},null,"محمد ربيعى ",null,35000,1701306.74,"2020-04-22",407]
[{"$f":"IF(C50=[1]استعلام!$B$3,COUNTIF([1]مصر!$C50:C$724,[1]مصر!C50),\"\")","v":""},null,"محمود زارع ",null,35000,1666306.74,"2020-04-22",408]
[{"$f":"IF(C51=[1]استعلام!$B$3,COUNTIF([1]مصر!$C51:C$724,[1]مصر!C51),\"\")","v":""},null,"حسن عوف ",null,83000,1583306.74,"2020-04-22",409]
[{"$f":"IF(C52=[1]استعلام!$B$3,COUNTIF([1]مصر!$C52:C$724,[1]مصر!C52),\"\")","v":""},null,"شركة عمرو / مصنع ستار جى ار بى ",null,200000,1383306.74,"2020-04-22",410]
[{"$f":"IF(C53=[1]استعلام!$B$3,COUNTIF([1]مصر!$C53:C$724,[1]مصر!C53),\"\")","v":""},null,"تحويل الى شركة النصر للمسبوكات ",null,1275000,108306.73999999999,"2020-04-22","تحويل"]
[{"$f":"IF(C54=[1]استعلام!$B$3,COUNTIF([1]مصر!$C54:C$724,[1]مصر!C54),\"\")","v":""},null,"مصاريف بنكية رسوم كشوف حسابات",null,120,108186.73999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"بيـــــــــــــــــان خاص بالفريحة "]
[null,null,"البيــــــــــــــــــان ","ما تم تحصيله ","المصروفات المباشرة","الرصيد","التاريخ"]
[null,null,"وارد شيك دفعة مقدمة بنى عبس ",4001364,null,{"$f":"D78","v":4001364}]
[null,null,"وارد شيك دفعة مقدمة قرية إبراهيم حسن ",7486822,null,{"$f":"F78+D79-E79","v":11488186}]
[null,null,"وارد شيك دفعة مقدمة منشأة الامير ",6057918,null,{"$f":"F79+D80-E80","v":17546104}]
[null,null,"مصاريف خطابات الضمان الابتدائى 3 مشروعات ",null,8210,17537894]
[null,null,"محجوز غطاء ضمان نهائى 3 مشروعات الفرايحة ",null,877305.2,16660588.800000001]
[null,null,"عمولات اصدار خطابات ضمان نهائى الفرايحة 3مشروعات ",null,140456.84,16520131.960000001]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية بنى عبس ",null,{"$f":"D78*0.05","v":200068.2},16320063.760000002]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية إبراهيم حسن ",null,{"$f":"D79*0.05","v":374341.10000000003},15945722.660000002]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية منشأة الامير",null,{"$f":"D80*0.05","v":302895.90000000002},15642826.760000002]
[null,null,"عمولات اصدار خطابات ضمان الدفعة المقدمة الفرايحة 3مشروعات ",null,210553.25,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]
[null,null,null,null,null,15432273.510000002]