{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["بيانات","ورقة1","بحث عن الافراد"],"not_rendered":{"charts":0,"images":3,"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":"بيانات","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["الحسابات","نوع السند","marhla","mblgh",null,null,null,null,"علي ناصر"]
["الايرادات","قبض","الاول ابتدائي ",900000,null,null,"محمد ",{"$f":"--ISNUMBER(IFERROR(SEARCH($I$1,G2,1),\"\"))","v":0},{"$f":"IF(H2=1,COUNTIF($H$2:H2,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I2),$I$2:$I$20,0)),\"\")","v":"علي ناصر"}]
["الصندوق","ذمم","الثاني ابتدائي ",900000,null,null,"كريم",{"$f":"--ISNUMBER(IFERROR(SEARCH($I$1,G3,1),\"\"))","v":0},{"$f":"IF(H3=1,COUNTIF($H$2:H3,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I3),$I$2:$I$20,0)),\"\")","v":""}]
["الذمم",null,"الثالث ابتدائي ",900000,null,null,"اسعد ",0,{"$f":"IF(H4=1,COUNTIF($H$2:H4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I4),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الرابع ابتدائي ",900000,null,null,"اسعد حسن",0,{"$f":"IF(H5=1,COUNTIF($H$2:H5,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I5),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الخامس ابتدائي ",950000,null,null,"علي ناصر",1,{"$f":"IF(H6=1,COUNTIF($H$2:H6,1),\"\")","v":1},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I6),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"السادس ابتدائي ",950000,null,null,"عبد المطلب عبد القهار",0,{"$f":"IF(H7=1,COUNTIF($H$2:H7,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I7),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الاول متوسط ",1000000,null,null,"حسين حسن ",0,{"$f":"IF(H8=1,COUNTIF($H$2:H8,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I8),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الثاني متوسط ",1000000,null,null,"محمد صلاح",0,{"$f":"IF(H9=1,COUNTIF($H$2:H9,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I9),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الثالث متوسط ",1050000,null,null,"كمال عبد السميع",0,{"$f":"IF(H10=1,COUNTIF($H$2:H10,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I10),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الرابع اعدادي ",1350000,null,null,"حسين حسن ",0,{"$f":"IF(H11=1,COUNTIF($H$2:H11,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I11),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"الخامس اعدادي ",1350000,null,null,"محمد صلاح",0,{"$f":"IF(H12=1,COUNTIF($H$2:H12,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I12),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,"السادس اعدادي ",2000000,null,null,"كمال عبد السميع",0,{"$f":"IF(H13=1,COUNTIF($H$2:H13,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I13),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"حسين حسن ",0,{"$f":"IF(H14=1,COUNTIF($H$2:H14,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I14),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"محمد صلاح",0,{"$f":"IF(H15=1,COUNTIF($H$2:H15,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I15),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"كمال عبد السميع",0,{"$f":"IF(H16=1,COUNTIF($H$2:H16,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I16),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"حسين حسن ",0,{"$f":"IF(H17=1,COUNTIF($H$2:H17,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I17),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"كريم",0,{"$f":"IF(H18=1,COUNTIF($H$2:H18,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I18),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"اسعد ",0,{"$f":"IF(H19=1,COUNTIF($H$2:H19,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I19),$I$2:$I$20,0)),\"\")","v":""}]
[null,null,null,null,null,null,"اسعد حسن",0,{"$f":"IF(H20=1,COUNTIF($H$2:H20,1),\"\")","v":""},{"$f":"IFERROR(INDEX($G$2:$G$20,MATCH(ROWS($I$2:I20),$I$2:$I$20,0)),\"\")","v":""}]

{"sheet":"ورقة1","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"علي نوري خضير",null,"مبلغ القسط الواصل","اسم المدرسة","المرحلة","المبلغ الكلي للقسط","مجموع مادفعه من اقساط","الباقي بالذمة"]
[null,null,null,{"$f":"VLOOKUP($B$4,#REF!,COLUMNS($H$1:H1)+2,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($B$4,#REF!,COLUMNS($H$1:H1)+5,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($B$4,#REF!,COLUMNS($H$1:H1)+6,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($B$4,#REF!,COLUMNS($H$1:H1)+7,0)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,$B$4,#REF!)","v":{"$error":"#REF!"}},{"$f":"G5-H5","v":{"$error":"#REF!"}}]

{"sheet":"بحث عن الافراد","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"حس"]
[null,"رقم الوصل","التاريخ","القسط المدفوع","المدرسة","المرحلة","القسط الكلي","مجموع مادفعه","الباقي"]