{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["الرئيسية","قائمة الموظفين","Input","Data","يناير","فبراير","مارس","ابريل","مايو","يونيو","يوليو","اغسطس","سبتمبر","اكتوبر","نوفمبر","ديسمبر"],"not_rendered":{"charts":0,"images":4,"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":"الرئيسية","index":0,"n_rows":15,"n_cols":27,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"يناير",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"فبراير",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مارس",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ابريل",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مايو",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"يونيو",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"يوليو",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"اغسطس",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"سبتمبر",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"اكتوبر",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"نوفمبر",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ديسمبر",12]

{"sheet":"قائمة الموظفين","index":1,"n_rows":151,"n_cols":22,"rows_kept":151,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,20,0,21]]}
["الكود","الاسم","الوظيفه","الاساسى","التامين",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"رصيد الاجازات"]
[null,null,null,null,"الثابت","المتغير","اجر اليوم","اجر الساعه","اضافى 1","اضافى2","عطلات","الحافز","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","قرض","اعتيادى 21","عارضه 6"]
[100001,"احمد امام","مدير ادارى",3000,750,750,{"$f":"SUM(D3+F3+E3)/30","v":150},{"$f":"G3/8","v":18.75},{"$f":"H3*1.5","v":28.125},{"$f":"H3*2","v":37.5},{"$f":"H3*2","v":37.5},1000,100,600,250,150,100,50,50,{"$f":"12000-Input!AB37","v":12000},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B3,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\")))=0,\"\",21-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B3,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\"))))","v":20},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B3,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\")))=0,\"\",6-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B3,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\"))))","v":4}]
[100002,"احمد السيد","امين مخزن ",2000,500,500,{"$f":"SUM(D4+F4+E4)/30","v":100},{"$f":"G4/8","v":12.5},{"$f":"H4*1.5","v":18.75},{"$f":"H4*2","v":25},{"$f":"H4*2","v":25},800,100,600,300,150,null,null,50,null,17,3]
[100003,"يسرى موافى","فنى ",1500,500,500,83.333333333333329,10.416666666666666,15.625,20.833333333333332,20.833333333333332,750,null,650,350,null,50,null,100,null,20,-1]
[100004,"صالح محمد ","عامل ",1800,null,null,60,7.5,11.25,15,15,1000,null,500,300,200,null,null,500,null,20,4]
[100005,"مراد الشافعى ","عامل ",1750,250,250,75,9.375,14.0625,18.75,18.75,500,100,200,100,null,50,null,100,null,"",""]
[100006,"محمد على ","مدير ادارى",1500,150,150,60,7.5,11.25,15,15,800,null,750,null,200,null,100,null,null,"",""]
[100007,"عبد الواحد السيد ","عامل ",4000,500,500,166.66666666666666,20.833333333333332,31.25,41.666666666666664,41.666666666666664,null,100,500,null,150,null,null,100,null,"",""]
[100008,"احمد فتحى ","مساعد فنى ",3000,400,400,126.66666666666667,15.833333333333334,23.75,31.666666666666668,31.666666666666668,500,200,100,100,100,50,50,50,null,"",""]
[100009,"احمد منصور","امين مخزن ",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100010,"محمد صلاح ","مساعد امين مخزن ",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100011,"احمد مصطفى ","مدير حسابات",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100012,"احمد سعيد","محاسب",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100013,"محمد رمضان","محاسب",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100014,"محمد شعبان","رئيس قسم ",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100015,"احمد كرم","مساعد فنى ",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100016,"اسامه محمود","مدير حسابات",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100017,"محمد الداخلى","مدير ادارى",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100018,"محمد عبد العزيز","مساعد امين مخزن ",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100019,"هانى محمد ","محاسب",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[100020,"محمد حقار","سائق",null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B35,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\")))=0,\"\",21-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B35,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\"))))","v":""},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B35,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\")))=0,\"\",6-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B35,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\"))))","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,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B67,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\")))=0,\"\",21-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B67,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\"))))","v":""},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B67,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\")))=0,\"\",6-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B67,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\"))))","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,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B99,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\")))=0,\"\",21-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B99,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\"))))","v":""},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B99,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\")))=0,\"\",6-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B99,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\"))))","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,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B131,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\")))=0,\"\",21-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B131,INDIRECT(\"'\"&Sheets&\"'!\"&\"O2:O1000\"))))","v":""},{"$f":"IF(SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B131,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\")))=0,\"\",6-SUMPRODUCT(SUMIF(INDIRECT(\"'\"&Sheets&\"'!\"&\"AC2:AC1000\"),$B131,INDIRECT(\"'\"&Sheets&\"'!\"&\"P2:P1000\"))))","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,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Input","index":2,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,1,7],[0,8,1,14],[0,0,1,1],[5,0,35,0]]}
[2020,null,"مدخلات شهر",null,null,null,null,null,"فبراير"]
[]
["الاسم",{"$f":"IFERROR(VLOOKUP(A6,'قائمة الموظفين'!A:C,2,0),\"\")","v":""}]
["الوظيفه",{"$f":"IFERROR(VLOOKUP(A6,'قائمة الموظفين'!A1:C1048575,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR($G37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,8,0),\"\")","v":""},null,null,{"$f":"IFERROR(IF(J37>2,-(J37-2)*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),0),\"\")","v":0},{"$f":"IFERROR($K37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,8,0),\"\")","v":""},{"$f":"IFERROR($L37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,9,0),\"\")","v":""},{"$f":"IFERROR($M37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,10,0),\"\")","v":""},{"$f":"IFERROR($N37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,11,0),\"\")","v":""},{"$f":"IFERROR($O37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"IFERROR($P37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"IFERROR(-$Q37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"IFERROR(-$R37*2*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"S37","v":0},0,0,0,0,0,{"$f":"Y37","v":0},{"$f":"IFERROR(Z37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"IFERROR(-AA37*VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'قائمة الموظفين'!$A$3:$V$500,20,0),\"\")","v":""}]
["الكود","اليوم","التــــــــــــاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]
[null,{"$f":"C6","v":"2020-02-01"},{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A1)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A1)))","v":"2020-02-01"},null,null,{"$f":"$E6-D6","v":0},{"$f":"IF($D6=9.25,F6+0.25,E6-D6)","v":0},{"$f":"IF($G6>=8,G6-8,0)","v":0},{"$f":"IF($D6>9.25,D6-9,0)","v":0},{"$f":"IF($I6>0,1,0)","v":0},{"$f":"IF($G6>=8,0,IF(G6=0,0,G6-8))","v":0},{"$f":"IF($H6>3,3,H6)","v":0},{"$f":"IF($H6>3,H6-3,0)","v":0},null,null,null,null,null,{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F6>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,{"$f":"IF(OR($D6=\"\",$E6=\"\"),\"\",$B$3)","v":""}]
[null,{"$f":"C7","v":"2020-02-02"},{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A2)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A2)))","v":"2020-02-02"},null,null,{"$f":"$E7-D7","v":0},{"$f":"IF($D7=9.25,F7+0.25,E7-D7)","v":0},{"$f":"IF($G7>=8,G7-8,0)","v":0},{"$f":"IF($D7>9.25,D7-9,0)","v":0},{"$f":"IF($I7>0,1,0)","v":0},{"$f":"IF($G7>=8,0,IF(G7=0,0,G7-8))","v":0},{"$f":"IF($H7>3,3,H7)","v":0},{"$f":"IF($H7>3,H7-3,0)","v":0},null,null,null,null,null,{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F7>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,{"$f":"IF(OR($D7=\"\",$E7=\"\"),\"\",$B$3)","v":""}]
[null,"2020-02-03",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A3)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A3)))","v":"2020-02-03"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F8>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-04",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A4)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A4)))","v":"2020-02-04"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F9>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-05",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A5)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A5)))","v":"2020-02-05"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F10>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-06",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A6)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A6)))","v":"2020-02-06"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F11>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-07",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A7)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A7)))","v":"2020-02-07"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F12>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-08",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A8)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A8)))","v":"2020-02-08"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F13>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-09",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A9)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A9)))","v":"2020-02-09"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F14>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-10",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A10)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A10)))","v":"2020-02-10"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F15>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-11",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A11)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A11)))","v":"2020-02-11"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F16>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-12",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A12)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A12)))","v":"2020-02-12"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F17>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-13",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A13)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A13)))","v":"2020-02-13"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F18>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-14",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A14)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A14)))","v":"2020-02-14"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F19>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-15",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A15)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A15)))","v":"2020-02-15"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F20>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-16",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A16)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A16)))","v":"2020-02-16"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F21>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-17",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A17)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A17)))","v":"2020-02-17"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F22>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-18",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A18)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A18)))","v":"2020-02-18"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F23>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-19",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A19)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A19)))","v":"2020-02-19"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F24>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-20",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A20)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A20)))","v":"2020-02-20"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F25>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-21",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A21)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A21)))","v":"2020-02-21"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F26>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-22",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A22)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A22)))","v":"2020-02-22"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F27>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-23",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A23)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A23)))","v":"2020-02-23"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F28>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-24",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A24)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A24)))","v":"2020-02-24"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F29>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-25",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A25)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A25)))","v":"2020-02-25"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F30>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-26",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A26)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A26)))","v":"2020-02-26"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F31>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-27",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A27)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A27)))","v":"2020-02-27"},null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0)","v":0},{"$f":"IF($F32>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0)","v":0},null,null,null,""]
[null,"2020-02-28",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A28)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A28)))","v":"2020-02-28"},null,null,{"$f":"IF(C33=\"\",\"\",$E33-D33)","v":0},{"$f":"IF($C33=\"\",\"\",IF($D33=9.25,F33+0.25,E33-D33))","v":0},{"$f":"IF($C33=\"\",\"\",IF($G33>=8,G33-8,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($D33>9.25,D33-9,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($I33>0,1,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($G33>=8,0,IF(G33=0,0,G33-8)))","v":0},{"$f":"IF($C33=\"\",\"\",IF($H33>3,3,H33))","v":0},{"$f":"IF($C33=\"\",\"\",IF($H33>3,H33-3,0))","v":0},null,null,null,null,null,{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0))","v":0},{"$f":"IF($C33=\"\",\"\",IF($F33>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0))","v":0},null,null,null,""]
[null,"2020-02-29",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A29)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A29)))","v":"2020-02-29"},null,null,{"$f":"IF(C34=\"\",\"\",$E34-D34)","v":0},{"$f":"IF($C34=\"\",\"\",IF($D34=9.25,F34+0.25,E34-D34))","v":0},{"$f":"IF($C34=\"\",\"\",IF($G34>=8,G34-8,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($D34>9.25,D34-9,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($I34>0,1,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($G34>=8,0,IF(G34=0,0,G34-8)))","v":0},{"$f":"IF($C34=\"\",\"\",IF($H34>3,3,H34))","v":0},{"$f":"IF($C34=\"\",\"\",IF($H34>3,H34-3,0))","v":0},null,null,null,null,null,{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0))","v":0},{"$f":"IF($C34=\"\",\"\",IF($F34>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0))","v":0},null,null,null,""]
[null,"",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A30)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A30)))","v":""},null,null,"","","","","","","","",null,null,null,null,null,{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0))","v":""},{"$f":"IF($C35=\"\",\"\",IF($F35>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0))","v":""},null,null,null,""]
[null,"",{"$f":"IF(MONTH(DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A31)))>VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),\"\",DATE($A$1,VLOOKUP($I$1,الرئيسية!$Z$4:$AA$15,2,0),ROWS($A$1:A31)))","v":""},null,null,"","","","","","","","",null,null,null,null,null,{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,13,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,14,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,15,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,16,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,17,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,18,0)/30,0))","v":""},{"$f":"IF($C36=\"\",\"\",IF($F36>=1,VLOOKUP($A$6,'قائمة الموظفين'!$A$3:$V$500,19,0)/30,0))","v":""},null,null,null,""]
[null,null,"عدد ايام الحضور",{"$f":"COUNTA(D6:D36)","v":0},{"$f":"COUNTA(E6:E36)","v":0},{"$f":"SUM(F6:F36)","v":0},{"$f":"SUM(G6:G36)-H37","v":0},{"$f":"SUM(H6:H36)","v":0},0,{"$f":"SUM(J6:J36)","v":0},0,0,0,null,0,0,0,0,{"$f":"SUM(S6:S36)","v":0},{"$f":"SUM(T6:T36)","v":0},0,0,0,0,0,0,{"$f":"SUM(AA6:AA36)","v":0},{"$f":"SUM(AB6:AB36)","v":0}]

{"sheet":"Data","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["م","الحافز","الوظيفه","الراتب الاساسى","البدلات","الكود","الاسم","الوظيفه"]
[1,3000,"مدير ادارى",5000,"يستحق"]
[2,2000,"رئيس قسم ",4000,"لا يستحق",100001,"احمد امام","رئيس قسم "]
[3,1500,"فنى ",3500,null,100002,"احمد السيد","امين مخزن "]
[4,1200,"مساعد فنى ",3000,null,100003,"يسرى موافى","فنى "]
[5,1000,"عامل ",2800,null,100004,"صالح محمد ","عامل "]
[6,1500,"امين مخزن ",3400,null,100005,"مراد الشافعى ","عامل "]
[7,1100,"مساعد امين مخزن ",3000,null,100006,"محمد على ","مدير ادارى"]
[8,4000,"مدير حسابات",6000,null,100007,"عبد الواحد السيد ","عامل "]
[9,2800,"محاسب",3800,null,100008,"احمد فتحى ","مساعد فنى "]
[10,2500,"سائق",4200,null,100009,"احمد منصور","امين مخزن "]
[null,null,null,null,null,100010,"محمد صلاح ","مساعد امين مخزن "]
[null,null,null,null,null,100011,"احمد مصطفى ","مدير حسابات"]
[null,null,null,null,null,100012,"احمد سعيد","محاسب"]
[null,null,null,null,null,100013,"محمد رمضان","محاسب"]
[null,null,null,null,null,100014,"محمد شعبان","رئيس قسم "]
[null,null,null,null,null,100015,"احمد كرم","مساعد فنى "]
[null,null,null,null,null,100016,"اسامه محمود","مدير حسابات"]
[null,null,null,null,null,100017,"محمد الداخلى","مدير ادارى"]
[null,null,null,null,null,100018,"محمد عبد العزيز","مساعد امين مخزن "]
[null,null,null,null,null,100019,"هانى محمد ","محاسب"]
[null,null,null,null,null,100020,"محمد حقار","سائق"]

{"sheet":"يناير","index":4,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]
[100003,"2020-01-01","2020-01-01","10:20:00","18:35:00",0.34374999999999989,0.34374999999999989,0,0,0,-7.65625,0,0,null,null,7,null,null,0,0,0,0,0,0,0,null,null,null,"يسرى موافى"]
[null,"2020-01-02","2020-01-02","11:00:00","19:25:00",0.35069444444444448,0.35069444444444448,0,0,0,-7.6493055555555554,0,0,null,1,null,null,null,0,0,0,0,0,0,0,null,null,null,"يسرى موافى"]
[null,"2020-01-03","2020-01-03",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-04","2020-01-04",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-05","2020-01-05",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-06","2020-01-06",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-07","2020-01-07",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-08","2020-01-08",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-09","2020-01-09",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-10","2020-01-10",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-11","2020-01-11",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-12","2020-01-12",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-13","2020-01-13",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-14","2020-01-14",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-15","2020-01-15",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-16","2020-01-16",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-17","2020-01-17",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-18","2020-01-18",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-19","2020-01-19",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-20","2020-01-20",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-21","2020-01-21",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-22","2020-01-22",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-23","2020-01-23",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-24","2020-01-24",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-25","2020-01-25",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-26","2020-01-26",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-27","2020-01-27",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-28","2020-01-28",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-29","2020-01-29",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-30","2020-01-30",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-31","2020-01-31",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,null,"عدد ايام الحضور",2,2,0.69444444444444442,0.69444444444444442,0,0,0,-15.305555555555555,0,0,null,1,7,0,0,0,0,0,0,0,0,0,0,0,0]
[100004,"2020-01-01","2020-01-01","08:00:00","14:00:00",0.25000000000000006,0.25000000000000006,0,0,0,-7.75,0,0,null,1,2,null,null,0,0,0,0,0,0,0,null,null,null,"صالح محمد "]
[null,"2020-01-02","2020-01-02","08:20:00","12:30:00",0.1736111111111111,0.1736111111111111,0,0,0,-7.8263888888888893,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,"صالح محمد "]
[null,"2020-01-03","2020-01-03",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-04","2020-01-04",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-05","2020-01-05",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-06","2020-01-06",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-07","2020-01-07",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-08","2020-01-08",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-09","2020-01-09",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-10","2020-01-10",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-11","2020-01-11",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-12","2020-01-12",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-13","2020-01-13",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-14","2020-01-14",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-15","2020-01-15",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-16","2020-01-16",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-17","2020-01-17",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-18","2020-01-18",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-19","2020-01-19",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-20","2020-01-20",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-21","2020-01-21",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-22","2020-01-22",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-23","2020-01-23",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-24","2020-01-24",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-25","2020-01-25",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-26","2020-01-26",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-27","2020-01-27",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-28","2020-01-28",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-29","2020-01-29",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-30","2020-01-30",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-01-31","2020-01-31",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,null,"عدد ايام الحضور",2,2,0.42361111111111116,0.42361111111111116,0,0,0,-15.576388888888889,0,0,null,1,2,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"فبراير","index":5,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]
[100002,"2020-02-01","2020-02-01","09:00:00","16:00:00",0.29166666666666663,0.29166666666666663,0,0,0,-7.708333333333333,0,0,null,null,3,null,null,0,0,0,0,0,0,0,null,null,null,"احمد السيد"]
[null,"2020-02-02","2020-02-02","11:00:00","18:00:00",0.29166666666666669,0.29166666666666669,0,0,0,-7.708333333333333,0,0,null,4,null,null,null,0,0,0,0,0,0,0,null,null,null,"احمد السيد"]
[null,"2020-02-03","2020-02-03","08:30:00","12:00:00",0.14583333333333331,0.14583333333333331,0,0,0,-7.854166666666667,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,"احمد السيد"]
[null,"2020-02-04","2020-02-04","10:20:00","19:10:00",0.36805555555555558,0.36805555555555558,0,0,0,-7.6319444444444446,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,"احمد السيد"]
[null,"2020-02-05","2020-02-05",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-06","2020-02-06",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-07","2020-02-07",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-08","2020-02-08",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-09","2020-02-09",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-10","2020-02-10",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-11","2020-02-11",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-12","2020-02-12",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-13","2020-02-13",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-14","2020-02-14",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-15","2020-02-15",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-16","2020-02-16",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-17","2020-02-17",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-18","2020-02-18",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-19","2020-02-19",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-20","2020-02-20",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-21","2020-02-21",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-22","2020-02-22",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-23","2020-02-23",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-24","2020-02-24",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-25","2020-02-25",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-26","2020-02-26",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-27","2020-02-27",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-28","2020-02-28",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-02-29","2020-02-29",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"","",null,null,"","","","","","","","",null,null,null,null,null,"","","","","","","",null,null,null,""]
[null,"","",null,null,"","","","","","","","",null,null,null,null,null,"","","","","","","",null,null,null,""]
[null,null,"عدد ايام الحضور",4,4,1.0972222222222221,1.0972222222222221,0,0,0,-30.902777777777779,0,0,null,4,3,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"مارس","index":6,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]
[100001,"2020-03-01","2020-03-01",9,17,8,8,0,0,0,0,0,0,null,null,2,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-02","2020-03-02",9.25,17,7.75,8,0,0,0,0,0,0,null,1,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-03","2020-03-03",9.5,17,7.5,7.5,0,0.5,1,-0.5,0,0,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-04","2020-03-04",9,16.5,7.5,7.5,0,0,0,-0.5,0,0,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-05","2020-03-05",9,21,12,12,4,0,0,0,3,1,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-06","2020-03-06",9,18,9,9,1,0,0,0,1,0,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-07","2020-03-07",9.25,18,8.75,9,1,0,0,0,1,0,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-08","2020-03-08",9.5,18,8.5,8.5,0.5,0.5,1,0,0.5,0,null,null,null,null,null,3.3333333333333335,20,8.3333333333333339,5,3.3333333333333335,1.6666666666666667,1.6666666666666667,null,null,null,"احمد امام"]
[null,"2020-03-09","2020-03-09",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-10","2020-03-10",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-11","2020-03-11",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-12","2020-03-12",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-13","2020-03-13",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-14","2020-03-14",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-15","2020-03-15",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-16","2020-03-16",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-17","2020-03-17",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-18","2020-03-18",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-19","2020-03-19",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-20","2020-03-20",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-21","2020-03-21",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-22","2020-03-22",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-23","2020-03-23",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-24","2020-03-24",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-25","2020-03-25",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-26","2020-03-26",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-27","2020-03-27",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-28","2020-03-28",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-29","2020-03-29",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-30","2020-03-30",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,"2020-03-31","2020-03-31",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,""]
[null,null,"عدد ايام الحضور",8,8,69,63,6.5,1,2,-1,5.5,1,null,1,2,0,0,26.666666666666664,160,66.666666666666671,40,26.666666666666664,13.333333333333332,13.333333333333332,0,0,0]

{"sheet":"ابريل","index":7,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"مايو","index":8,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"يونيو","index":9,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"يوليو","index":10,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"اغسطس","index":11,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"سبتمبر","index":12,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"اكتوبر","index":13,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"نوفمبر","index":14,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]

{"sheet":"ديسمبر","index":15,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["الكود","اليوم","التاريخ","الحضور","الانصراف","عدد الساعات ","الفعلى","عدد الاضافى","التأخير\nساعات","عدد\nالتأخيرات","اجر الساعه","اضافى 1","اضافى2","عطلات","اعتيادى 21","عارضه 6","غياب باذن","غياب بدون اذن","بدل اغتراب ","بدل مواصلات","بدل وجبه","بدل غلاء معيشه","بدل موبايل","بدل ملبس","بدل طبيعة عمل","مكافات","جزاء","قرض"]