{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info","الصندوق","مصرف أبو ظبى ","الاهلى المتحد","المشرق","مصر"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Info","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"شركة كونكورد للخرسانة الجاهزة ",null,null,null,null,null,null,null,"A2"]
[null,"م","البيـــــــــــــــــــــــــــان ","مدين","دائن","الرصـــــــــيد ","التاريخ","ملاحظات","Sheet_Name"]
[null,1,"A2",416,80,336,"2020-02-03",null,"الصندوق",null,null,null,"Choose name then Press Run"]
[null,2,"A2",206,201,5,"2020-02-03",null,"مصرف أبو ظبى "]
[null,3,"A2",829,75,754,"2020-04-03",null,"مصرف أبو ظبى "]
[null,4,"A2",847,419,428,null,null,"الاهلى المتحد"]
[null,5,"A2",331,186,145,"2020-02-03",null,"الاهلى المتحد"]
[null,6,"A2",690,258,432,"2020-10-03",null,"الاهلى المتحد"]
[null,7,"A2",267,75,192,null,null,"المشرق"]
[null,8,"A2",650,139,511,"2020-02-03",null,"مصر"]
[null,"المجموع",null,4236,1433,2803]

{"sheet":"الصندوق","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"بيــــــــــــــان حركة الخزينة "]
[null,"م","البيـــــــــــــــــــــــــــان ","مدين","دائن","الرصـــــــــيد ","التاريخ","ملاحظات"]
[null,1,"رصيد الخزينة 3/1 صباحا",null,null,500000,"2020-03-01"]
[null,2,"A1",727,130,{"$f":"SUM(F3,D4,E4)","v":500857},"2020-03-01"]
[null,3,"A2",416,80,{"$f":"SUM(F4,D5,E5)","v":501353},"2020-03-02"]
[null,4,"A3",924,333,502610,"2020-03-02"]
[null,5,"A4",653,206,503469,"2020-03-02"]
[null,6,"A5",616,173,504258,"2020-03-02"]
[null,7,"A6",118,458,504834,"2020-03-02"]
[null,8,"A7",318,127,505279,"2020-03-02","شامله عموله البنك"]
[null,9,"A8",651,218,506148,"2020-03-02"]
[null,10,"A9",350,221,506719,"2020-03-02"]
[null,11,"A10",446,349,507514,"2020-03-02"]
[null,12,"A11",268,267,508049,"2020-03-02"]
[null,13,"A12",244,257,508550,"2020-03-02"]
[null,14,"A13",215,80,508845,"2020-03-02"]
[null,15,"A14",697,409,509951,"2020-03-02"]
[null,16,"A15",309,150,510410,"2020-03-02"]
[null,17,"A16",433,351,511194,"2020-03-02"]

{"sheet":"مصرف أبو ظبى ","index":2,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان مصرف أبو ظبى "]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,830000]
[{"$f":"IF(C4=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C4:C$724,'مصرف أبو ظبى '!C4),\"\")","v":""},null,"A1",670,286,{"$f":"SUM(F3,D4,E4)","v":830956},"2020-03-02"]
[{"$f":"IF(C5=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C5:C$724,'مصرف أبو ظبى '!C5),\"\")","v":""},null,"A2",206,201,{"$f":"SUM(F4,D5,E5)","v":831363},"2020-03-02"]
[{"$f":"IF(C6=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C6:C$724,'مصرف أبو ظبى '!C6),\"\")","v":""},null,"A3",106,194,831663,"2020-03-02"]
[{"$f":"IF(C7=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C7:C$724,'مصرف أبو ظبى '!C7),\"\")","v":""},null,"A4",802,62,832527]
[{"$f":"IF(C8=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C8:C$724,'مصرف أبو ظبى '!C8),\"\")","v":""},null,"A1",338,295,833160,"2020-03-10"]
[{"$f":"IF(C9=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C9:C$724,'مصرف أبو ظبى '!C9),\"\")","v":""},null,"A6",415,399,833974]
[{"$f":"IF(C10=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C10:C$724,'مصرف أبو ظبى '!C10),\"\")","v":""},null,"A7",711,331,835016,"2020-03-04"]
[{"$f":"IF(C11=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C11:C$724,'مصرف أبو ظبى '!C11),\"\")","v":""},null,"A2",829,75,835920,"2020-03-04"]
[{"$f":"IF(C12=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C12:C$724,'مصرف أبو ظبى '!C12),\"\")","v":""},null,"A9",811,94,836825]
[{"$f":"IF(C13=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C13:C$724,'مصرف أبو ظبى '!C13),\"\")","v":""},null,"A10",670,224,837719,"2020-03-05",272]
[{"$f":"IF(C14=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C14:C$724,'مصرف أبو ظبى '!C14),\"\")","v":""},null,"A11",264,162,838145,"2020-03-05",373]
[{"$f":"IF(C15=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C15:C$724,'مصرف أبو ظبى '!C15),\"\")","v":""},null,"A12",824,291,839260,"2020-03-05",376]
[{"$f":"IF(C16=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C16:C$724,'مصرف أبو ظبى '!C16),\"\")","v":""},null,"A13",579,418,840257,"2020-03-05",377]
[{"$f":"IF(C17=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C17:C$724,'مصرف أبو ظبى '!C17),\"\")","v":""},null,"A14",115,395,840767,"2020-03-05",378]
[{"$f":"IF(C18=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C18:C$724,'مصرف أبو ظبى '!C18),\"\")","v":""},null,"A15",572,472,841811]
[{"$f":"IF(C19=Info!$B$1,COUNTIF('مصرف أبو ظبى '!$C19:C$724,'مصرف أبو ظبى '!C19),\"\")","v":""},null,"A16",217,312,842340]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"غطاء خطاب ضمان دفعة مقدمة قرية منشأة الامير",null,{"$f":"D80*0.05","v":0},{"$f":"F85+D86-E86","v":0}]
[null,null,"عمولات اصدار خطابات ضمان الدفعة المقدمة الفرايحة 3مشروعات ",null,210553.25,-210553.25]
[null,null,null,null,null,-210553.25]
[null,null,null,null,null,-210553.25]
[null,null,null,null,null,-210553.25]
[null,null,null,null,null,-210553.25]
[null,null,null,null,null,-210553.25]

{"sheet":"الاهلى المتحد","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان بنك الاهلى المتحد"]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,582000]
[{"$f":"IF(C4=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C4:C$724,'مصرف أبو ظبى '!C4),\"\")","v":""},1,"A1",808,349,{"$f":"SUM(F3,D4,E4)","v":583157},"2020-03-02"]
[{"$f":"IF(C5=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C5:C$724,'مصرف أبو ظبى '!C5),\"\")","v":2},null,"A2",847,419,{"$f":"SUM(F4,D5,E5)","v":584423}]
[{"$f":"IF(C6=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C6:C$724,'مصرف أبو ظبى '!C6),\"\")","v":""},null,"A3",373,210,585006,"2020-03-05",6803316]
[{"$f":"IF(C7=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C7:C$724,'مصرف أبو ظبى '!C7),\"\")","v":""},null,"A4",133,83,585222]
[{"$f":"IF(C8=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C8:C$724,'مصرف أبو ظبى '!C8),\"\")","v":""},null,"A5",768,429,586419,"2020-03-08",6803317]
[{"$f":"IF(C9=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C9:C$724,'مصرف أبو ظبى '!C9),\"\")","v":""},null,"A6",461,81,586961]
[{"$f":"IF(C10=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C10:C$724,'مصرف أبو ظبى '!C10),\"\")","v":""},null,"A7",125,404,587490,"2020-03-11"]
[null,null,"A8",853,314,588657]
[{"$f":"IF(C12=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C12:C$724,'مصرف أبو ظبى '!C12),\"\")","v":""},null,"A9",150,424,589231,"2020-03-02"]
[{"$f":"IF(C13=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C13:C$724,'مصرف أبو ظبى '!C13),\"\")","v":1},null,"A2",331,186,589748,"2020-03-02"]
[{"$f":"IF(C14=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C14:C$724,'مصرف أبو ظبى '!C14),\"\")","v":""},null,"A14",808,283,590839,"2020-03-02"]
[{"$f":"IF(C15=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C15:C$724,'مصرف أبو ظبى '!C15),\"\")","v":""},null,"A12",774,339,591952]
[{"$f":"IF(C16=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C16:C$724,'مصرف أبو ظبى '!C16),\"\")","v":1},null,"A2",690,258,592900,"2020-03-10"]
[{"$f":"IF(C17=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C17:C$724,'مصرف أبو ظبى '!C17),\"\")","v":""},null,"A14",906,62,593868]
[{"$f":"IF(C18=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C18:C$724,'مصرف أبو ظبى '!C18),\"\")","v":""},null,"A15",213,112,594193,"2020-03-04"]
[{"$f":"IF(C19=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C19:C$724,'مصرف أبو ظبى '!C19),\"\")","v":""},null,"A16",999,70,595262,"2020-03-04"]

{"sheet":"المشرق","index":4,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"بيــــــــــــــان بنك الاهلى المتحد"]
[null,"م","البيــــــــــــــــان ","مدين","دائن","الرصيد"]
[null,null,"رصيد ما قبله 3/1",null,null,582000]
[{"$f":"IF(C4=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C4:C$724,'مصرف أبو ظبى '!C4),\"\")","v":""},1,"A1",405,175,{"$f":"SUM(F3,D4,E4)","v":582580},"2020-03-02"]
[{"$f":"IF(C5=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C5:C$724,'مصرف أبو ظبى '!C5),\"\")","v":2},null,"A2",267,75,{"$f":"SUM(F4,D5,E5)","v":582922}]
[{"$f":"IF(C6=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C6:C$724,'مصرف أبو ظبى '!C6),\"\")","v":""},null,"A3",782,158,583862,"2020-03-05",6803316]
[{"$f":"IF(C7=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C7:C$724,'مصرف أبو ظبى '!C7),\"\")","v":""},null,"A4",701,207,584770]
[{"$f":"IF(C8=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C8:C$724,'مصرف أبو ظبى '!C8),\"\")","v":""},null,"A5",171,239,585180,"2020-03-08",6803317]
[{"$f":"IF(C9=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C9:C$724,'مصرف أبو ظبى '!C9),\"\")","v":""},null,"A6",410,436,586026]
[{"$f":"IF(C10=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C10:C$724,'مصرف أبو ظبى '!C10),\"\")","v":""},null,"A7",932,340,587298,"2020-03-11"]
[{"$f":"IF(C11=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C11:C$724,'مصرف أبو ظبى '!C11),\"\")","v":""},null,"A8",524,495,588317]
[{"$f":"IF(C12=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C12:C$724,'مصرف أبو ظبى '!C12),\"\")","v":""},null,"A9",683,340,589340,"2020-03-02"]
[{"$f":"IF(C13=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C13:C$724,'مصرف أبو ظبى '!C13),\"\")","v":""},null,"A10",738,163,590241,"2020-03-02"]
[{"$f":"IF(C14=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C14:C$724,'مصرف أبو ظبى '!C14),\"\")","v":""},null,"A11",236,89,590566,"2020-03-02"]
[{"$f":"IF(C15=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C15:C$724,'مصرف أبو ظبى '!C15),\"\")","v":""},null,"A12",138,259,590963]
[{"$f":"IF(C16=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C16:C$724,'مصرف أبو ظبى '!C16),\"\")","v":""},null,"A13",387,482,591832,"2020-03-10"]
[{"$f":"IF(C17=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C17:C$724,'مصرف أبو ظبى '!C17),\"\")","v":""},null,"A14",461,469,592762]
[{"$f":"IF(C18=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C18:C$724,'مصرف أبو ظبى '!C18),\"\")","v":""},null,"A15",582,316,593660,"2020-03-04"]
[{"$f":"IF(C19=Info!$C$3,COUNTIF('مصرف أبو ظبى '!$C19:C$724,'مصرف أبو ظبى '!C19),\"\")","v":""},null,"A16",775,94,594529,"2020-03-04"]

{"sheet":"مصر","index":5,"n_rows":92,"n_cols":8,"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=Info!$B$1,COUNTIF(مصر!$C4:C$724,مصر!C4),\"\")","v":""},null,"A1",265,451,{"$f":"SUM(F3,D4,E4)","v":830716},"2020-03-02"]
[{"$f":"IF(C5=Info!$B$1,COUNTIF(مصر!$C5:C$724,مصر!C5),\"\")","v":""},null,"A2",650,139,{"$f":"SUM(F4,D5,E5)","v":831505},"2020-03-02"]
[{"$f":"IF(C6=Info!$B$1,COUNTIF(مصر!$C6:C$724,مصر!C6),\"\")","v":""},null,"A3",757,458,832720,"2020-03-02"]
[{"$f":"IF(C7=Info!$B$1,COUNTIF(مصر!$C7:C$724,مصر!C7),\"\")","v":""},null,"A4",292,340,833352]
[{"$f":"IF(C8=Info!$B$1,COUNTIF(مصر!$C8:C$724,مصر!C8),\"\")","v":""},null,"A5",941,224,834517,"2020-03-10"]
[{"$f":"IF(C9=Info!$B$1,COUNTIF(مصر!$C9:C$724,مصر!C9),\"\")","v":""},null,"A6",813,386,835716]
[{"$f":"IF(C10=Info!$B$1,COUNTIF(مصر!$C10:C$724,مصر!C10),\"\")","v":""},null,"a55",625,355,836696,"2020-03-04"]
[{"$f":"IF(C11=Info!$B$1,COUNTIF(مصر!$C11:C$724,مصر!C11),\"\")","v":""},null,"A8",617,275,837588,"2020-03-04"]
[{"$f":"IF(C12=Info!$B$1,COUNTIF(مصر!$C12:C$724,مصر!C12),\"\")","v":""},null,"A9",460,63,838111]
[{"$f":"IF(C13=Info!$B$1,COUNTIF(مصر!$C13:C$724,مصر!C13),\"\")","v":""},null,"A10",797,279,839187,"2020-03-05",272]
[{"$f":"IF(C14=Info!$B$1,COUNTIF(مصر!$C14:C$724,مصر!C14),\"\")","v":""},null,"A11",352,438,839977,"2020-03-05",373]
[{"$f":"IF(C15=Info!$B$1,COUNTIF(مصر!$C15:C$724,مصر!C15),\"\")","v":""},null,"A12",388,109,840474,"2020-03-05",376]
[{"$f":"IF(C16=Info!$B$1,COUNTIF(مصر!$C16:C$724,مصر!C16),\"\")","v":""},null,"A13",943,311,841728,"2020-03-05",377]
[{"$f":"IF(C17=Info!$B$1,COUNTIF(مصر!$C17:C$724,مصر!C17),\"\")","v":""},null,"A14",129,143,842000,"2020-03-05",378]
[{"$f":"IF(C18=Info!$B$1,COUNTIF(مصر!$C18:C$724,مصر!C18),\"\")","v":""},null,"A15",242,390,842632]
[{"$f":"IF(C19=Info!$B$1,COUNTIF(مصر!$C19:C$724,مصر!C19),\"\")","v":""},null,"A16",209,349,843190]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]