{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["f7","غياب الحصص"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":19,"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":"f7","index":0,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,3,10,6],[11,3,11,6],[18,3,18,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[16,3,16,6],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[4,1,4,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[26,2,26,4],[2,1,2,12],[17,3,17,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[24,2,24,4],[25,2,25,4],[22,5,22,12],[21,2,21,4],[21,5,21,12],[23,5,23,12],[24,5,24,12],[25,5,25,12],[26,5,26,12],[20,1,20,12],[28,1,28,12],[3,1,3,12],[6,1,6,2],[6,3,6,12],[4,11,4,12],[4,8,4,9],[22,2,22,4],[23,2,23,4],[0,14,0,15],[4,4,4,7],[11,7,11,12],[18,7,18,10],[18,11,18,12],[7,7,10,7],[18,13,18,15],[1,1,1,12],[0,1,0,12],[10,1,10,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"أيام العطل",null,"من","الأول",2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ح",2,"إلى","الثاني",2019]
[null,"تقرير معلم",null,null,null,null,null,null,null,null,null,null,null,null,"ثن",1,null,null,2020]
[null,{"$f":"$Q$1&\" \"&TEXT($D$10,\"dd-mm-yyyy\")&\"  \"&$Q$2&\" \"&TEXT($D$11,\"dd-mm-yyyy\")","v":"من 26-02-2019  إلى 13-06-2019"},null,null,null,null,null,null,null,null,null,null,null,null,"ثل",2,null,null,2021]
[null,"الفصل الدراسي ",null,"الثاني","العام الدراسي",null,null,null,2018,null,"-",2019,null,null,"ر",0,null,null,2022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خ",0,null,null,2023]
[null,"اسم المعلم :",null,"معلم 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024]
[1,"الرقم المالي",null,null,null,null,null,"الحصص","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس",null,null,null,null,null,2025]
[2,"الرقم الوطني",null,null,null,null,null,null,16,"؟","؟","؟","؟"]
[3,"تاريخ البداية",null,"2019-02-26",null,null,null,null,2,2,1,1,2]
[4,"تاريخ النهاية",null,"2019-06-13",null,null,null,null,{"$f":"I9*I10","v":32},{"$f":"J9*J10","v":{"$error":"#VALUE!"}},{"$f":"K9*K10","v":{"$error":"#VALUE!"}},{"$f":"L9*L10","v":{"$error":"#VALUE!"}},{"$f":"M9*M10","v":{"$error":"#VALUE!"}}]
[5,"عدد الحصص في الاسبوع",null,{"$f":"I10+J10+K10+L10+M10","v":8},null,null,null,"غياب المعلم "]
[null,"مجموع حصص الفصل",null,null,null,null,null,{"$f":"IF($D$5=$R$1,\"سبتمبر\",\"فبراير\")","v":"فبراير"},{"$f":"(LEN($F$23)-LEN(SUBSTITUTE($F$23,$I$8,\"\")))/LEN($I$8)","v":0},{"$f":"(LEN($F$23)-LEN(SUBSTITUTE($F$23,$J$8,\"\")))/LEN($J$8)","v":0},{"$f":"(LEN($F$23)-LEN(SUBSTITUTE($F$23,$K$8,\"\")))/LEN($K$8)","v":0},{"$f":"(LEN($F$23)-LEN(SUBSTITUTE($F$23,$L$8,\"\")))/LEN($L$8)","v":0},{"$f":"(LEN($F$23)-LEN(SUBSTITUTE($F$23,$M$8,\"\")))/LEN($M$8)","v":0}]
[null,"القيمة في الاسبوع",null,{"$f":"D12*15","v":120},null,null,null,{"$f":"IF($D$5=$R$1,\"أكتوبر\",\"مارس\")","v":"مارس"},{"$f":"(LEN($F$24)-LEN(SUBSTITUTE($F$24,$I$8,\"\")))/LEN($I$8)","v":2},{"$f":"(LEN($F$24)-LEN(SUBSTITUTE($F$24,$J$8,\"\")))/LEN($J$8)","v":0},{"$f":"(LEN($F$24)-LEN(SUBSTITUTE($F$24,$K$8,\"\")))/LEN($K$8)","v":1},{"$f":"(LEN($F$24)-LEN(SUBSTITUTE($F$24,$L$8,\"\")))/LEN($L$8)","v":0},{"$f":"(LEN($F$24)-LEN(SUBSTITUTE($F$24,$M$8,\"\")))/LEN($M$8)","v":0}]
[null,"القيمة الاجمالية في الفصل",null,null,null,null,null,{"$f":"IF($D$5=$R$1,\"نوفمبر\",\"أبريل\")","v":"أبريل"},{"$f":"(LEN($F$25)-LEN(SUBSTITUTE($F$25,$I$8,\"\")))/LEN($I$8)","v":2},{"$f":"(LEN($F$25)-LEN(SUBSTITUTE($F$25,$J$8,\"\")))/LEN($J$8)","v":0},{"$f":"(LEN($F$25)-LEN(SUBSTITUTE($F$25,$K$8,\"\")))/LEN($K$8)","v":1},{"$f":"(LEN($F$25)-LEN(SUBSTITUTE($F$25,$L$8,\"\")))/LEN($L$8)","v":0},{"$f":"(LEN($F$25)-LEN(SUBSTITUTE($F$25,$M$8,\"\")))/LEN($M$8)","v":0}]
[null,"حصص الاحتياط",null,null,null,null,null,{"$f":"IF($D$5=$R$1,\"ديسمبر\",\"مايو\")","v":"مايو"},{"$f":"(LEN($F$26)-LEN(SUBSTITUTE($F$26,$I$8,\"\")))/LEN($I$8)","v":0},{"$f":"(LEN($F$26)-LEN(SUBSTITUTE($F$26,$J$8,\"\")))/LEN($J$8)","v":0},{"$f":"(LEN($F$26)-LEN(SUBSTITUTE($F$26,$K$8,\"\")))/LEN($K$8)","v":0},{"$f":"(LEN($F$26)-LEN(SUBSTITUTE($F$26,$L$8,\"\")))/LEN($L$8)","v":1},{"$f":"(LEN($F$26)-LEN(SUBSTITUTE($F$26,$M$8,\"\")))/LEN($M$8)","v":1}]
[null,"اجمالي حصص الغياب",null,{"$f":"L19","v":20},null,null,null,{"$f":"IF($D$5=$R$1,\"يناير\",\"يونيو\")","v":"يونيو"},{"$f":"(LEN($F$27)-LEN(SUBSTITUTE($F$27,$I$8,\"\")))/LEN($I$8)","v":1},{"$f":"(LEN($F$27)-LEN(SUBSTITUTE($F$27,$J$8,\"\")))/LEN($J$8)","v":1},{"$f":"(LEN($F$27)-LEN(SUBSTITUTE($F$27,$K$8,\"\")))/LEN($K$8)","v":2},{"$f":"(LEN($F$27)-LEN(SUBSTITUTE($F$27,$L$8,\"\")))/LEN($L$8)","v":1},{"$f":"(LEN($F$27)-LEN(SUBSTITUTE($F$27,$M$8,\"\")))/LEN($M$8)","v":0}]
[null,"صافي الحصص",null,null,null,null,null,"المجموع",{"$f":"SUM(I13:I17)","v":5},{"$f":"SUM(J13:J17)","v":1},{"$f":"SUM(K13:K17)","v":4},{"$f":"SUM(L13:L17)","v":2},{"$f":"SUM(M13:M17)","v":1}]
[null,"صافي القيمة",null,null,null,null,null,"عدد حصص الغياب",null,null,null,{"$f":"IFERROR((I18*I10)+(J18*J10)+(K18*K10)+(L18*L10)+(M18*M10),\"\")","v":20}]
[]
[null,"غياب المعلم بالتفصيل"]
[null,"شهر الغياب","أيام الغياب",null,null,"أسماء أيام الغياب"]
[{"$f":"IF(D5=$R$1,9,2)","v":2},{"$f":"IF($D$5=$R$1,\"سبتمبر\",\"فبراير\")","v":"فبراير"},{"$f":"IFERROR(IF($D$5=\"الأول\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A23&$I$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35),IF($D$5=\"الثاني\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A23&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35))),\"-\")","v":"-"},null,null,{"$f":"IF($D$5=$R$1,Salim_Extarct($I$5,C23,\"([1-3]?\\d+)\",A23,\"  - \"),IF($D$5=$R$2,Salim_Extarct($L$5,C23,\"([1-3]?\\d+)\",A23,\"  - \")))","v":""}]
[{"$f":"IF(D5=$R$1,10,3)","v":3},{"$f":"IF($D$5=$R$1,\"أكتوبر\",\"مارس\")","v":"مارس"},{"$f":"IFERROR(IF($D$5=\"الأول\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A24&$I$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35),IF($D$5=\"الثاني\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A24&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35))),\"-\")","v":"12 -10 -3 "},null,null,{"$f":"IF($D$5=$R$1,Salim_Extarct($I$5,C24,\"([1-3]?\\d+)\",A24,\"  - \"),IF($D$5=$R$2,Salim_Extarct($L$5,C24,\"([1-3]?\\d+)\",A24,\"  - \")))","v":"الأحد  - الأحد  - الثلاثاء"}]
[{"$f":"IF(D5=$R$1,11,4)","v":4},{"$f":"IF($D$5=$R$1,\"نوفمبر\",\"أبريل\")","v":"أبريل"},{"$f":"IFERROR(IF($D$5=\"الأول\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A25&$I$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35),IF($D$5=\"الثاني\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A25&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35))),\"-\")","v":"28 -21 -9 "},null,null,{"$f":"IF($D$5=$R$1,Salim_Extarct($I$5,C25,\"([1-3]?\\d+)\",A25,\"  - \"),IF($D$5=$R$2,Salim_Extarct($L$5,C25,\"([1-3]?\\d+)\",A25,\"  - \")))","v":"الثلاثاء  - الأحد  - الأحد"}]
[{"$f":"IF(D5=$R$1,12,5)","v":5},{"$f":"IF($D$5=$R$1,\"ديسمبر\",\"مايو\")","v":"مايو"},{"$f":"IFERROR(IF($D$5=\"الأول\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A26&$I$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35),IF($D$5=\"الثاني\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A26&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35))),\"-\")","v":"8 -2 "},null,null,{"$f":"IF($D$5=$R$1,Salim_Extarct($I$5,C26,\"([1-3]?\\d+)\",A26,\"  - \"),IF($D$5=$R$2,Salim_Extarct($L$5,C26,\"([1-3]?\\d+)\",A26,\"  - \")))","v":"الخميس  - الأربعاء"}]
[{"$f":"IF(D5=$R$1,1,6)","v":6},{"$f":"IF($D$5=$R$1,\"يناير\",\"يونيو\")","v":"يونيو"},{"$f":"IFERROR(IF($D$5=\"الأول\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A27&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35),IF($D$5=\"الثاني\",INDEX('غياب الحصص'!$C$5:$AK$1588,INDEX(MATCH($D$7&A27&$L$5,'غياب الحصص'!$C$5:$C$1588&'غياب الحصص'!$AN$5:$AN$1588&'غياب الحصص'!$AO$5:$AO$8091,0),0),35))),\"-\")","v":"23 -18 -17 -12 -11 "},null,null,{"$f":"IF($D$5=$R$1,Salim_Extarct($L$5,C27,\"([1-3]?\\d+)\",A27,\"  - \"),IF($D$5=$R$2,Salim_Extarct($L$5,C27,\"([1-3]?\\d+)\",A27,\"  - \")))","v":"الثلاثاء  - الأربعاء  - الإثنين  - الثلاثاء  - الأحد"}]
[]
[null,"توقيع المعلم:................................................................."]

{"sheet":"غياب الحصص","index":1,"n_rows":28,"n_cols":41,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,40]]}
[]
[null,"غياب الحصص"]
[]
[null,"الرقم","اسم المعلم","الصفة","الفترة ","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","أيام الغياب","أيام الغياب بالحروف","عدد أيام الغياب","غياب شهر","عمود1"]
[null,{"$f":"IF(C5<>\"\",SUBTOTAL(3,$C$5:C5),\"\")","v":1},"معلم 1",{"$f":"IFERROR(VLOOKUP(C5,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C5,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F5:AJ5,\"غ\",\" -\",1,4)","v":"26 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F5:AJ5,\"غ\")","v":1},2,2019]
[null,{"$f":"IF(C6<>\"\",SUBTOTAL(3,$C$5:C6),\"\")","v":2},"معلم 3",{"$f":"IFERROR(VLOOKUP(C6,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C6,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F6:AJ6,\"غ\",\" -\",1,4)","v":"26 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F6:AJ6,\"غ\")","v":1},2,2019]
[null,{"$f":"IF(C7<>\"\",SUBTOTAL(3,$C$5:C7),\"\")","v":3},"معلم 6",{"$f":"IFERROR(VLOOKUP(C7,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C7,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F7:AJ7,\"غ\",\" -\",1,4)","v":"28 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F7:AJ7,\"غ\")","v":1},2,2019]
[null,{"$f":"IF(C8<>\"\",SUBTOTAL(3,$C$5:C8),\"\")","v":4},"معلم 1",{"$f":"IFERROR(VLOOKUP(C8,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C8,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F8:AJ8,\"غ\",\" -\",1,4)","v":"25 -20 -17 -6 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"أربعة أيام"},{"$f":"COUNTIF(F8:AJ8,\"غ\")","v":4},3,2019]
[null,{"$f":"IF(C9<>\"\",SUBTOTAL(3,$C$5:C9),\"\")","v":5},"معلم 3",{"$f":"IFERROR(VLOOKUP(C9,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C9,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F9:AJ9,\"غ\",\" -\",1,4)","v":"25 -12 -4 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"ثلاثة أيام"},{"$f":"COUNTIF(F9:AJ9,\"غ\")","v":3},3,2019]
[null,{"$f":"IF(C10<>\"\",SUBTOTAL(3,$C$5:C10),\"\")","v":6},"معلم 4",{"$f":"IFERROR(VLOOKUP(C10,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C10,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F10:AJ10,\"غ\",\" -\",1,4)","v":"12 -10 -3 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"ثلاثة أيام"},{"$f":"COUNTIF(F10:AJ10,\"غ\")","v":3},3,2019]
[null,{"$f":"IF(C11<>\"\",SUBTOTAL(3,$C$5:C11),\"\")","v":7},"معلم 6",{"$f":"IFERROR(VLOOKUP(C11,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C11,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,"غ",{"$f":"Alsqr(F11:AJ11,\"غ\",\" -\",1,4)","v":"31 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F11:AJ11,\"غ\")","v":1},3,2019]
[null,{"$f":"IF(C12<>\"\",SUBTOTAL(3,$C$5:C12),\"\")","v":8},"معلم 1",{"$f":"IFERROR(VLOOKUP(C12,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C12,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F12:AJ12,\"غ\",\" -\",1,4)","v":"29 -23 -21 -16 -11 -8 -1 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"سبعة أيام"},{"$f":"COUNTIF(F12:AJ12,\"غ\")","v":7},4,2019]
[null,{"$f":"IF(C13<>\"\",SUBTOTAL(3,$C$5:C13),\"\")","v":9},"معلم 2",{"$f":"IFERROR(VLOOKUP(C13,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C13,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F13:AJ13,\"غ\",\" -\",1,4)","v":"24 -22 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يومـــان"},{"$f":"COUNTIF(F13:AJ13,\"غ\")","v":2},4,2019]
[null,{"$f":"IF(C14<>\"\",SUBTOTAL(3,$C$5:C14),\"\")","v":10},"معلم 3",{"$f":"IFERROR(VLOOKUP(C14,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C14,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F14:AJ14,\"غ\",\" -\",1,4)","v":"22 -16 -11 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"ثلاثة أيام"},{"$f":"COUNTIF(F14:AJ14,\"غ\")","v":3},4,2019]
[null,{"$f":"IF(C15<>\"\",SUBTOTAL(3,$C$5:C15),\"\")","v":11},"معلم 4",{"$f":"IFERROR(VLOOKUP(C15,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C15,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F15:AJ15,\"غ\",\" -\",1,4)","v":"28 -21 -9 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"ثلاثة أيام"},{"$f":"COUNTIF(F15:AJ15,\"غ\")","v":3},4,2019]
[null,{"$f":"IF(C16<>\"\",SUBTOTAL(3,$C$5:C16),\"\")","v":12},"معلم 5",{"$f":"IFERROR(VLOOKUP(C16,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C16,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F16:AJ16,\"غ\",\" -\",1,4)","v":"10 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F16:AJ16,\"غ\")","v":1},4,2019]
[null,{"$f":"IF(C17<>\"\",SUBTOTAL(3,$C$5:C17),\"\")","v":13},"معلم 6",{"$f":"IFERROR(VLOOKUP(C17,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C17,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F17:AJ17,\"غ\",\" -\",1,4)","v":"23 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F17:AJ17,\"غ\")","v":1},4,2019]
[null,{"$f":"IF(C18<>\"\",SUBTOTAL(3,$C$5:C18),\"\")","v":14},"معلم 1",{"$f":"IFERROR(VLOOKUP(C18,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C18,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F18:AJ18,\"غ\",\" -\",1,4)","v":"8 -7 -2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"ثلاثة أيام"},{"$f":"COUNTIF(F18:AJ18,\"غ\")","v":3},5,2019]
[null,{"$f":"IF(C19<>\"\",SUBTOTAL(3,$C$5:C19),\"\")","v":15},"معلم 2",{"$f":"IFERROR(VLOOKUP(C19,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C19,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F19:AJ19,\"غ\",\" -\",1,4)","v":"6 -2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يومـــان"},{"$f":"COUNTIF(F19:AJ19,\"غ\")","v":2},5,2019]
[null,{"$f":"IF(C20<>\"\",SUBTOTAL(3,$C$5:C20),\"\")","v":16},"معلم 3",{"$f":"IFERROR(VLOOKUP(C20,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C20,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F20:AJ20,\"غ\",\" -\",1,4)","v":"8 -7 -6 -2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"أربعة أيام"},{"$f":"COUNTIF(F20:AJ20,\"غ\")","v":4},5,2019]
[null,{"$f":"IF(C21<>\"\",SUBTOTAL(3,$C$5:C21),\"\")","v":17},"معلم 4",{"$f":"IFERROR(VLOOKUP(C21,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C21,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F21:AJ21,\"غ\",\" -\",1,4)","v":"8 -2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يومـــان"},{"$f":"COUNTIF(F21:AJ21,\"غ\")","v":2},5,2019]
[null,{"$f":"IF(C22<>\"\",SUBTOTAL(3,$C$5:C22),\"\")","v":18},"معلم 5",{"$f":"IFERROR(VLOOKUP(C22,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F22:AJ22,\"غ\",\" -\",1,4)","v":"2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F22:AJ22,\"غ\")","v":1},5,2019]
[null,{"$f":"IF(C23<>\"\",SUBTOTAL(3,$C$5:C23),\"\")","v":19},"معلم 6",{"$f":"IFERROR(VLOOKUP(C23,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F23:AJ23,\"غ\",\" -\",1,4)","v":"8 -2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يومـــان"},{"$f":"COUNTIF(F23:AJ23,\"غ\")","v":2},5,2019]
[null,{"$f":"IF(C24<>\"\",SUBTOTAL(3,$C$5:C24),\"\")","v":20},"معلم 6",{"$f":"IFERROR(VLOOKUP(C24,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C24,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F24:AJ24,\"غ\",\" -\",1,4)","v":"2 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يوم واحد"},{"$f":"COUNTIF(F24:AJ24,\"غ\")","v":1},5,2019]
[null,{"$f":"IF(C25<>\"\",SUBTOTAL(3,$C$5:C25),\"\")","v":21},"معلم 1",{"$f":"IFERROR(VLOOKUP(C25,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C25,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F25:AJ25,\"غ\",\" -\",1,4)","v":"30 -25 -17 -10 -9 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"خمسة أيام"},{"$f":"COUNTIF(F25:AJ25,\"غ\")","v":5},6,2019]
[null,{"$f":"IF(C26<>\"\",SUBTOTAL(3,$C$5:C26),\"\")","v":22},"معلم 3",{"$f":"IFERROR(VLOOKUP(C26,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C26,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F26:AJ26,\"غ\",\" -\",1,4)","v":"24 -23 -20 -13 -9 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"خمسة أيام"},{"$f":"COUNTIF(F26:AJ26,\"غ\")","v":5},6,2019]
[null,{"$f":"IF(C27<>\"\",SUBTOTAL(3,$C$5:C27),\"\")","v":23},"معلم 4",{"$f":"IFERROR(VLOOKUP(C27,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C27,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F27:AJ27,\"غ\",\" -\",1,4)","v":"23 -18 -17 -12 -11 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"خمسة أيام"},{"$f":"COUNTIF(F27:AJ27,\"غ\")","v":5},6,2019]
[null,{"$f":"IF(C28<>\"\",SUBTOTAL(3,$C$5:C28),\"\")","v":24},"معلم 5",{"$f":"IFERROR(VLOOKUP(C28,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],53,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C28,[1]!البياناتالاساسية[[الاسم رباعي]:[الرقم الوطني]],55,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,{"$f":"Alsqr(F28:AJ28,\"غ\",\" -\",1,4)","v":"19 -9 "},{"$f":"IF(أرشيف_الغياب[[#This Row],[أيام الغياب]]=\"\",\"\",elaiam(أرشيف_الغياب[[#This Row],[عدد أيام الغياب]]))","v":"يومـــان"},{"$f":"COUNTIF(F28:AJ28,\"غ\")","v":2},6,2019]