{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","ورقة2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"ورقة1","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["م","التاريخ","الاسم","العنوان","رقم\n الفوج","التليفون","أسماء المتسابقين","درجة الاجادة","درجات رفع","المجموع"]
[1,"2020-03-14","مدرس 1","كرداسة",1,1111111111,"تلميذ 1",10,null,{"$f":"SUM(H3:I3)","v":10}]
[2,"2020-03-14","مدرس 1","كرداسة",1,1111111111,"تلميذ 2",5,2,{"$f":"SUM(H4:I4)","v":7}]
[3,"2020-03-14","مدرس 1","كرداسة",1,1111111111,"تلميذ 3",7,null,7]
[4,"2020-03-14","مدرس 2","كرداسة",2,2222222222,"تلميذ 4",8,null,8]
[5,"2020-03-14","مدرس 2","كرداسة",2,2222222222,"تلميذ 5",4,3,7]
[6,"2020-03-14","مدرس 2","كرداسة",2,2222222222,"تلميذ 6",2,null,2]
[7,"2020-03-14","مدرس 2","كرداسة",2,2222222222,"تلميذ 7",9,null,9]
[8,"2020-03-14","مدرس 3","كرداسة",3,3333333333,"تلميذ 8",7,null,7]
[9,"2020-03-14","مدرس 3","كرداسة",3,3333333333,"تلميذ 9",9,null,9]
[10,"2020-03-14","مدرس 3","كرداسة",3,3333333333,"تلميذ 10",10,null,10]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"ورقة2","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,6,10,9]]}
["تاريخ الفوج","2020-03-07",null,"رقم الفوج",2]
["عنوان المدرس","كرداسة",null,"اسم المدرس","مدرس 2",null,"في شيت ورقة2 يتم جلب البيانات على رقم الفوج ادخلنا رقم الفوج 2 قمت باحضار بيانات فوج رقم 2 وهم اربع طلاب جاء طلاب احرين يودن الاشتراك في هذا الفوج وهو التلميذ 11 اود عمل كود ترحيل يرحل التلميذ 11 الى شيت ورقة1 الى فوج 2 بمعنى يدرج صف جديد ويضع الاسم الجديد مع بيانات المدرس وشكرا لحسن تعاونكم معنا كتمنين لكم دوام الصحة والعافية "]
["رقم التليفون",2222222222]
[]
["م","أسماء المتسابقين","درجة الاجادة","درجات رفع","المجموع"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":1},"تلميذ 4",8,null,8]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":2},"تلميذ 5",4,3,7]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":3},"تلميذ 6",2,null,2]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":4},"تلميذ 7",9,null,9]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":5},"تلميذ 11",5,2,7]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":""}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,$B$6:B13))","v":""}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,$B$6:B14))","v":""}]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,$B$6:B15))","v":""}]