{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["التوقيع","ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,10,14,11],[14,13,14,14],[14,16,14,17],[14,19,14,20],[15,10,15,11],[15,13,15,14],[15,16,15,17],[15,19,15,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"/","دوام",null,"ع-","اعتيادية بدون راتب",null,"م","اجازة مرضية"]
[null,"غ","غياب",null,"ع","اجازة اعتيادية",null,"س","استراحة"]
[null,"و","واجب",null,"د","دورة",null,"عط","عطلة رسمية",null,"م. البصمة",null,null,"م.الادارة",null,null,"م.شعبة معمل غاز الحلة",null,null,"مدير الفرع"]

{"sheet":"ورقة1","index":1,"n_rows":16,"n_cols":40,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,10,0,16],[0,17,0,21],[0,22,0,24],[1,0,1,4]]}
[null,null,null,null,null,null,null,null,null,null,"استمارة الدوام الشهري لشهر ",null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,"مركز الكلفة"]
["الشركة العامة",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23432]
[null,null,null,{"$f":"D4","v":""},{"$f":"E4","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["ت","اسم الموظف","رقم الموظف",{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:D1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:D1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:E1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:E1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:F1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:F1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:G1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:G1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:H1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:H1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:I1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:I1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:J1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:J1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:K1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:K1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:L1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:L1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:M1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:M1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:N1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:N1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:O1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:O1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:P1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:P1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Q1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Q1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:R1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:R1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:S1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:S1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:T1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:T1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:U1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:U1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:V1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:V1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:W1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:W1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:X1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:X1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Y1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Y1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Z1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:Z1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AA1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AA1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AB1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AB1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AC1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AC1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AD1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AD1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AE1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AE1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AF1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AF1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AG1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AG1))),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AH1)))>VLOOKUP($R$1,$AM$5:$AN$16,2,0),\"\",DATE($W$1,VLOOKUP($R$1,$AM$5:$AN$16,2,0),COLUMNS($D$1:AH1))),\"\")","v":""},"مجموع","الملاحظات"]
[{"$f":"IF(B5=\"\",\"\",MAX($A$4:A4)+1)","v":1},"موظف1",431,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","ع","/","/","/","/","/","ع","/","/","/","/","/","/","/",{"$f":"IF(B5=\"\",\"\",COUNTIF(D5:AH5,\"ع\"))","v":2},null,null,null,"كانون الثّاني",1]
[{"$f":"IF(B6=\"\",\"\",MAX($A$4:A5)+1)","v":2},"موظف2",562,"/","/","/","/","/","/","/","/","/","ع","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"IF(B6=\"\",\"\",COUNTIF(D6:AH6,\"ع\"))","v":1},null,null,null,"شباط",2]
[{"$f":"IF(B7=\"\",\"\",MAX($A$4:A6)+1)","v":3},"موظف3",243,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",0,null,null,null,"آذار",3]
[{"$f":"IF(B8=\"\",\"\",MAX($A$4:A7)+1)","v":4},"موظف4",344,"xx","/","/","/","/","/","/","/","/","/","/","/","/","ع","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",1,null,null,null,"نيسان",4]
[{"$f":"IF(B9=\"\",\"\",MAX($A$4:A8)+1)","v":""},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","ع","/","/","/","/","/","/","/","/","/","/","/","/","/","",null,null,null,"أيّار",5]
[{"$f":"IF(B10=\"\",\"\",MAX($A$4:A9)+1)","v":""},null,null,"/","/","ع","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","ع","/","/","/","/","/","/","ع","/","/","/","/","",null,null,null,"حزيران",6]
[{"$f":"IF(B11=\"\",\"\",MAX($A$4:A10)+1)","v":""},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","",null,null,null,"تمّـوز",7]
[{"$f":"IF(B12=\"\",\"\",MAX($A$4:A11)+1)","v":""},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","",null,null,null,"آب",8]
[{"$f":"IF(B13=\"\",\"\",MAX($A$4:A12)+1)","v":""},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","",null,null,null,"أيلول",9]
[{"$f":"IF(B14=\"\",\"\",MAX($A$4:A13)+1)","v":""},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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"كانون الأوّل",12]