{"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,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":"2020-07-01"},{"$f":"E4","v":"2020-07-02"},"2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31"]
["ت","اسم الموظف","رقم الموظف",{"$f":"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":"2020-07-01"},{"$f":"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":"2020-07-02"},{"$f":"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":"2020-07-03"},{"$f":"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":"2020-07-04"},{"$f":"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":"2020-07-05"},{"$f":"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":"2020-07-06"},{"$f":"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":"2020-07-07"},{"$f":"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":"2020-07-08"},{"$f":"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":"2020-07-09"},{"$f":"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":"2020-07-10"},{"$f":"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":"2020-07-11"},{"$f":"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":"2020-07-12"},{"$f":"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":"2020-07-13"},{"$f":"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":"2020-07-14"},{"$f":"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":"2020-07-15"},{"$f":"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":"2020-07-16"},{"$f":"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":"2020-07-17"},{"$f":"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":"2020-07-18"},{"$f":"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":"2020-07-19"},{"$f":"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":"2020-07-20"},{"$f":"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":"2020-07-21"},{"$f":"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":"2020-07-22"},{"$f":"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":"2020-07-23"},{"$f":"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":"2020-07-24"},{"$f":"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":"2020-07-25"},{"$f":"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":"2020-07-26"},{"$f":"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":"2020-07-27"},{"$f":"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":"2020-07-28"},{"$f":"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":"2020-07-29"},{"$f":"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":"2020-07-30"},{"$f":"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":"2020-07-31"},"مجموع","الملاحظات"]
[{"$f":"ROW(A5)-4","v":1},"موظف3",243,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D5:AH5,\"ع\")","v":0},null,null,null,"كانون الثّاني",1]
[{"$f":"ROW(A6)-4","v":2},"موظف4",344,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D6:AH6,\"ع\")","v":0},null,null,null,"شباط",2]
[{"$f":"ROW(A7)-4","v":3},"موظف1",431,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D7:AH7,\"ع\")","v":0},null,null,null,"آذار",3]
[{"$f":"ROW(A8)-4","v":4},"موظف2",562,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D8:AH8,\"ع\")","v":0},null,null,null,"نيسان",4]
[{"$f":"ROW(A9)-4","v":5},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D9:AH9,\"ع\")","v":0},null,null,null,"أيّار",5]
[{"$f":"ROW(A10)-4","v":6},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D10:AH10,\"ع\")","v":0},null,null,null,"حزيران",6]
[{"$f":"ROW(A11)-4","v":7},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D11:AH11,\"ع\")","v":0},null,null,null,"تمّـوز",7]
[{"$f":"ROW(A12)-4","v":8},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D12:AH12,\"ع\")","v":0},null,null,null,"آب",8]
[{"$f":"ROW(A13)-4","v":9},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D13:AH13,\"ع\")","v":0},null,null,null,"أيلول",9]
[{"$f":"ROW(A14)-4","v":10},null,null,"/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/","/",{"$f":"COUNTIF(D14:AH14,\"ع\")","v":0},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]