{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الرئيسية","طباعة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":10,"n_cols":47,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,6,6,13],[6,14,6,21],[6,22,6,29],[6,30,6,37],[6,38,6,45]]}
[]
[]
[]
[]
[]
[]
[null,"الاسم",null,null,null,null,"الأحد",null,null,null,null,null,null,null,"الإثنين",null,null,null,null,null,null,null,"الثلاثاء",null,null,null,null,null,null,null,"الأربعاء",null,null,null,null,null,null,null,"الخميس",null,null,null,null,null,null,null,"COUNTA"]
[null,"موظف1",null,null,null,"الأول","1/1","1/1","1/2","1/2",null,null,null,null,"1/1","1/1",null,"1/2","1/2",null,null,null,"1/1","1/1",null,"1/2","1/2",null,null,null,"1/1",null,"1/2",null,"1/2",null,"1/2",null,null,null,null,"1/2","1/2",null,"1/1","1/1",{"$f":"COUNTA(G8:AT8)","v":20}]
[null,"موظف2",null,null,null,"الثانى","5/4","9/1",null,"5/4","9/1",null,"5/4","9/1","5/4","9/1",null,"5/4","9/1",null,"5/4","9/1","5/4","9/1",null,"5/4","9/1",null,"5/4","9/1","5/4","9/1",null,"5/4","9/1",null,"5/4","9/1","5/4","9/1",null,"5/4","9/1",null,"5/4","9/1",{"$f":"COUNTA(G9:AT9)","v":30}]
[null,"موظف3",null,null,null,"الثالث","9/1","9/1","9/1","9/1","9/1","9/1",null,"9/1","9/1","9/1","9/1","9/1","9/1","9/1",null,"9/1","9/1","9/1","9/1","9/1","9/1","9/1",null,"9/1","9/1","9/1","9/1","9/1","9/1","9/1",null,"9/1","9/1","9/1","9/1","9/1","9/1","9/1",null,"9/1",35]

{"sheet":"طباعة","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,2]]}
["إختيار الموظف",null,null,null,null,"معادلة",null,null,null,"مقارنة النتائج من الورقة الرئيسية"]
["موظف1",null,null,null,null,{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),6)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),6))","v":"الأول"},null,null,null,{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),47)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),47))","v":20},"بالنسبة للشرطين الأول أوالثانى لا يزيد عدد الحصص عن 25 حصة أسبوعيا"]
[null,null,null,null,null,null,"معادلة أ / عبدالله بشير2",{"$f":"IF(OR(F2=\"الأول\",F2=\"الثانى\"),IF(SUMPRODUCT(--(B7:I11<>0),--(B7:I11<>\"\"))>=25,25,SUMPRODUCT(--(B7:I11<>0),--(B7:I11<>\"\"))),IF(F2=\"الثالث\",SUMPRODUCT(--(B7:I11<>0),--(B7:I11<>\"\")),\"\"))","v":20},null,null,"أما لو أقل فيستحق العدد الفعلى"]
[null,null,null,null,null,null,null,25,null,null,"بالنسبة للشرط الثالث فيستحق العدد الفعلى كاملا"]
[]
["اليوم","حصة1","حصة2","حصة3","حصة4","حصة5","حصة6","حصة7","حصة8","المتوقع"]
["الأحد",{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),7)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),7))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),8)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),8))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),9)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),9))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),10)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),10))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),11)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),11))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),12)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),12))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),13)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),13))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),14)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),14))","v":""},20,"موظف1 أقل من 25 وبالتالى الناتج = 20 وهو المطلوب"]
["الإثنين",{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),15)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),15))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),16)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),16))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),17)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),17))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),18)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),18))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),19)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),19))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),20)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),20))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),21)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),21))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),22)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),22))","v":""},25,"موظف2 أكبر من 25 والمطلوب 25 فقط وهو المطلوب"]
["الثلاثاء",{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),23)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),23))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),24)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),24))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),25)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),25))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),26)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),26))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),27)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),27))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),28)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),28))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),29)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),29))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),30)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),30))","v":""},35,"أما عن الشرط الثالث فيعطى العدد الفعلى وهو 35"]
["الأربعاء",{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),31)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),31))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),32)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),32))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),33)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),33))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),34)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),34))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),35)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),35))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),36)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),36))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),37)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),37))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),38)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),38))","v":""}]
["الخميس",{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),39)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),39))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),40)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),40))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),41)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),41))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),42)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),42))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),43)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),43))","v":"1/2"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),44)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),44))","v":""},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),45)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),45))","v":"1/1"},{"$f":"IF(INDEX(mayrange,MATCH($A2,mynames,0),46)=\"\",\"\",INDEX(mayrange,MATCH($A2,mynames,0),46))","v":"1/1"}]