{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","salim","كشف الاقساط "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Sheet1","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["الاسم","المبلغ",null,"الاسم","المبلغ",null,"COUNT_UNIQUE"]
["علاء خير",100,null,{"$f":"IF(ROWS($D$2:D2)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A1)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"نزار عامر"},{"$f":"IF($D2=\"\",\"\",SUMIF($A$2:$A$17,$D2,$B$2:$B$17))","v":1500},null,{"$f":"SUM((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*1)","v":12}]
["كاتيا الحجلي",50,null,{"$f":"IF(ROWS($D$2:D3)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A2)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"علاء خير"},{"$f":"IF($D3=\"\",\"\",SUMIF($A$2:$A$17,$D3,$B$2:$B$17))","v":1080}]
["تامر الحمرا",700,null,{"$f":"IF(ROWS($D$2:D4)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A3)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"ابراهيم القدور"},800]
["علاء خير",800,null,{"$f":"IF(ROWS($D$2:D5)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A4)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"تامر الحمرا"},700]
["غزل سابق",400,null,{"$f":"IF(ROWS($D$2:D6)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A5)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"غزل سابق"},400]
["ابراهيم القدور",300,null,{"$f":"IF(ROWS($D$2:D7)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A6)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"كاتيا الحجلي"},250]
["كاتيا الحجلي",200,null,{"$f":"IF(ROWS($D$2:D8)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A7)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"شادي سابق"},250]
["آية شرف",100,null,{"$f":"IF(ROWS($D$2:D9)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A8)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"نضال القيس"},200]
["جنى عماشة",150,null,{"$f":"IF(ROWS($D$2:D10)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A9)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"جنى عماشة"},150]
["لين بدرالدين",10,null,{"$f":"IF(ROWS($D$2:D11)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A10)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"آية شرف"},100]
["نزار عامر",1500,null,{"$f":"IF(ROWS($D$2:D12)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A11)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"حنين رافع"},100]
["علاء خير",180,null,{"$f":"IF(ROWS($D$2:D13)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A12)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":"لين بدرالدين"},10]
["حنين رافع",100,null,{"$f":"IF(ROWS($D$2:D14)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A13)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":""},""]
["نضال القيس",200,null,{"$f":"IF(ROWS($D$2:D15)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A14)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":""},""]
["شادي سابق",250,null,{"$f":"IF(ROWS($D$2:D16)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A15)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":""},""]
["ابراهيم القدور",500,null,{"$f":"IF(ROWS($D$2:D17)>$G$2,\"\",INDEX($A$2:$A$17,MATCH(LARGE((MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),ROWS($A$1:A16)),(MATCH($A$2:$A$17,$A$2:$A$17,0)=ROW($A$2:$A$17)-ROW($A$2)+1)*(SUMIF($A$2:$A$17,$A$2:$A$17,$B$2:$B$17)-ROW($A$2:$A$17)/1000),0)))","v":""}]

{"sheet":"salim","index":1,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"COUNT_UNIQUE","الاسم ","مبلغ القسط","البملغ الكلي للقسط","الباقي بالذمة","المرحلة الدراسية","اسم المدرسة"]
[null,null,null,null,null,null,6,"t",33445566,null,null,null,null,null,null,null,"t",33445566]
[null,null,null,null,null,null,null,"y",390000,null,null,null,null,null,null,null,"y",390000]
[null,null,null,null,null,null,null,"c",56000,null,null,null,null,null,null,null,"c",56000]
[null,null,null,null,null,null,null,"a",3000,null,null,null,null,null,null,null,"a",3000]
[null,null,null,null,null,null,null,"d",2000,null,null,null,null,null,null,null,"d",2000]
[null,null,null,null,null,null,null,"r",23,null,null,null,null,null,null,null,"r",23]

{"sheet":"كشف الاقساط ","index":2,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["هنا يكون ترقيم تلقائي","الاسم ","مبلغ القسط","البملغ الكلي للقسط","الباقي بالذمة","المرحلة الدراسية","اسم المدرسة"]