{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","المساعد"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["م","كود الطالب","اسم الطالب","حالة الحضور"]
[1,100,"ابراهيم جليل بابو","حاضر"]
[2,101,"أحمد عمادالدين بابكر","حاضر"]
[3,102,"اسماعيل عبدالحكيم الحلقى","حاضر"]
[4,103,"ايهم عبدالحليم ","حاضر"]
[5,104,"بلال عبدالرحمن","حاضر"]
[6,105,"تميم احمد عبدالقادر","حاضر"]
[7,106,"حجاب تركى الدوسرى","حاضر"]
[8,107,"حمد عبدالرحيم اصغر","حاضر"]
[9,108,"خالد على ناصر القحطانى","حاضر"]
[10,109,"عبدالرحمن محمد ناجى ","حاضر"]
[11,110,"عبدالله احمد عبدالله","حاضر"]
[12,111,"عبدالله حمد ملهيه","حاضر"]
[13,112,"علي سعيد المسعودي","حاضر"]
[14,113,"علي فرج المري","حاضر"]
[15,114,"عمر عبدالعزيز","حاضر"]
[16,115,"عمرو محمد بني عيسى","حاضر"]
[17,116,"مانع خالد الخوار","حاضر"]
[18,117,"محمد اشرف","حاضر"]
[19,118,"محمد خالد الحداد","حاضر"]
[20,119,"محمد دلول","حاضر"]
[21,120,"محمد سامر","حاضر"]
[22,121,"محمد عفان","حاضر"]
[23,122,"محمد فخرى","حاضر"]
[24,123,"محمد فهد المظفر","حاضر"]
[25,124,"محمدسليم بنعبدالله","حاضر"]
[26,125,"يوسف عبدالعزيز اليافعي","حاضر"]
[27,126,"حمدان سالم الاحبابى","حاضر"]

{"sheet":"Sheet2","index":1,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["م","كود الطالب","اسم الطالب","حالة الحضور","التاريخ","الوقت","الشهر"]
[1,102,"اسماعيل عبدالحكيم الحلقى","غ","2023-03-17","10:55:42","مارس"]
[2,106,"حجاب تركى الدوسرى","غ","2023-03-17","11:03:39","مارس"]
[3,107,"حمد عبدالرحيم اصغر","غ","2023-03-17","11:05:27","مارس"]
[4,111,"عبدالله حمد ملهيه","غ","2023-03-17","11:07:27","مارس"]
[5,104,"بلال عبدالرحمن","غ","2023-03-17","12:12:00","مارس"]
[6,109,"عبدالرحمن محمد ناجى ","غ","2023-03-17","12:12:02","مارس"]
[7,117,"محمد اشرف","غ","2023-03-17","12:12:43","مارس"]
[8,119,"محمد دلول","غ","2023-03-17","12:15:44","مارس"]
[9,121,"محمد عفان","غ","2023-03-17","12:15:46","مارس"]
[10,124,"محمدسليم بنعبدالله","غ","2023-03-17","12:15:49","مارس"]
[11,100,"ابراهيم جليل بابو","غ","2023-03-17","12:17:54","مارس"]
[12,125,"يوسف عبدالعزيز اليافعي","غ","2023-03-18","08:58:47","مارس"]
[13,103,"ايهم عبدالحليم ","غ","2023-03-18","09:39:53","مارس"]
[15,104,"بلال عبدالرحمن","غ","2023-03-18","09:41:25","مارس"]
[16,106,"حجاب تركى الدوسرى","غ","2023-03-18","09:41:25","مارس"]
[18,108,"خالد على ناصر القحطانى","غ","2023-03-18","09:41:54","مارس"]
[17,114,"عمر عبدالعزيز","غ","2023-03-18","09:43:05","مارس"]
[18,105,"تميم احمد عبدالقادر","غ","2023-03-18","10:05:46","مارس"]

{"sheet":"Sheet3","index":2,"n_rows":34,"n_cols":35,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,3,3,26],[5,1,6,1],[5,2,6,2]]}
[null,null,null,null,null,null,null,null,3,{"$f":"INDEX(المساعد!$E$2:$E$13,I1)","v":"2023-03-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"أريد أن أعمل كود لجلب الغياب ووضع علامة مقابل اسم الطالب في اليوم الذي غاب فيه"]
[]
[null,null,null,{"$f":"TEXT(J1,\"mmm / yyyy\")","v":"مارس / 2023"}]
[]
[null,"كود الطالب","اسم الطالب",{"$f":"TEXT(D7,\"ddd\")","v":"الأربعاء"},{"$f":"TEXT(E7,\"ddd\")","v":"الخميس"},"الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","مجموع"]
[null,null,null,{"$f":"J1","v":"2023-03-01"},{"$f":"IF(D7=\"\",\"\",IF(EOMONTH($J$1,0)>=D7+1,D7+1,\"\"))","v":"2023-03-02"},"2023-03-03","2023-03-04","2023-03-05","2023-03-06","2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11","2023-03-12","2023-03-13","2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18","2023-03-19","2023-03-20","2023-03-21","2023-03-22","2023-03-23","2023-03-24","2023-03-25","2023-03-26","2023-03-27","2023-03-28","2023-03-29","2023-03-30","2023-03-31","غ"]
[null,100,{"$f":"IFERROR(VLOOKUP(B8,Sheet1!$B$2:$D$28,2,0),\"\")","v":"ابراهيم جليل بابو"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS($D8:$AH8,\"غ\")","v":0}]
[null,101,{"$f":"IFERROR(VLOOKUP(B9,Sheet1!$B$2:$D$28,2,0),\"\")","v":"أحمد عمادالدين بابكر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS($D9:$AH9,\"غ\")","v":0}]
[null,102,{"$f":"IFERROR(VLOOKUP(B10,Sheet1!$B$2:$D$28,2,0),\"\")","v":"اسماعيل عبدالحكيم الحلقى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,103,{"$f":"IFERROR(VLOOKUP(B11,Sheet1!$B$2:$D$28,2,0),\"\")","v":"ايهم عبدالحليم "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,104,{"$f":"IFERROR(VLOOKUP(B12,Sheet1!$B$2:$D$28,2,0),\"\")","v":"بلال عبدالرحمن"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,105,{"$f":"IFERROR(VLOOKUP(B13,Sheet1!$B$2:$D$28,2,0),\"\")","v":"تميم احمد عبدالقادر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,106,{"$f":"IFERROR(VLOOKUP(B14,Sheet1!$B$2:$D$28,2,0),\"\")","v":"حجاب تركى الدوسرى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,107,{"$f":"IFERROR(VLOOKUP(B15,Sheet1!$B$2:$D$28,2,0),\"\")","v":"حمد عبدالرحيم اصغر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,108,{"$f":"IFERROR(VLOOKUP(B16,Sheet1!$B$2:$D$28,2,0),\"\")","v":"خالد على ناصر القحطانى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,109,{"$f":"IFERROR(VLOOKUP(B17,Sheet1!$B$2:$D$28,2,0),\"\")","v":"عبدالرحمن محمد ناجى "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,110,{"$f":"IFERROR(VLOOKUP(B18,Sheet1!$B$2:$D$28,2,0),\"\")","v":"عبدالله احمد عبدالله"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,111,{"$f":"IFERROR(VLOOKUP(B19,Sheet1!$B$2:$D$28,2,0),\"\")","v":"عبدالله حمد ملهيه"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,112,{"$f":"IFERROR(VLOOKUP(B20,Sheet1!$B$2:$D$28,2,0),\"\")","v":"علي سعيد المسعودي"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,113,{"$f":"IFERROR(VLOOKUP(B21,Sheet1!$B$2:$D$28,2,0),\"\")","v":"علي فرج المري"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,114,{"$f":"IFERROR(VLOOKUP(B22,Sheet1!$B$2:$D$28,2,0),\"\")","v":"عمر عبدالعزيز"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,115,{"$f":"IFERROR(VLOOKUP(B23,Sheet1!$B$2:$D$28,2,0),\"\")","v":"عمرو محمد بني عيسى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,116,{"$f":"IFERROR(VLOOKUP(B24,Sheet1!$B$2:$D$28,2,0),\"\")","v":"مانع خالد الخوار"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,117,{"$f":"IFERROR(VLOOKUP(B25,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد اشرف"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,118,{"$f":"IFERROR(VLOOKUP(B26,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد خالد الحداد"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,119,{"$f":"IFERROR(VLOOKUP(B27,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد دلول"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,120,{"$f":"IFERROR(VLOOKUP(B28,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد سامر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,121,{"$f":"IFERROR(VLOOKUP(B29,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد عفان"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,122,{"$f":"IFERROR(VLOOKUP(B30,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد فخرى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,123,{"$f":"IFERROR(VLOOKUP(B31,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمد فهد المظفر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,124,{"$f":"IFERROR(VLOOKUP(B32,Sheet1!$B$2:$D$28,2,0),\"\")","v":"محمدسليم بنعبدالله"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,125,{"$f":"IFERROR(VLOOKUP(B33,Sheet1!$B$2:$D$28,2,0),\"\")","v":"يوسف عبدالعزيز اليافعي"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,126,{"$f":"IFERROR(VLOOKUP(B34,Sheet1!$B$2:$D$28,2,0),\"\")","v":"حمدان سالم الاحبابى"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"المساعد","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["الحالة","الكود",null,null,"التاريخ"]
["حاضر","ح",null,null,"2023-01-01"]
["غائب","غ",null,null,"2023-02-01"]
["إجازة","إ",null,null,"2023-03-01"]
[null,null,null,null,"2023-04-01"]
[null,null,null,null,"2023-05-01"]
[null,null,null,null,"2023-06-01"]
[null,null,null,null,"2023-07-01"]
[null,null,null,null,"2023-08-01"]
[null,null,null,null,"2023-09-01"]
[null,null,null,null,"2023-10-01"]
[null,null,null,null,"2023-11-01"]
[null,null,null,null,"2023-12-01"]