{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":28,"n_cols":35,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,1,{"$f":"B1+1","v":2},3,{"$f":"D1+1","v":4},{"$f":"E1+1","v":5},{"$f":"F1+1","v":6},{"$f":"G1+1","v":7},{"$f":"H1+1","v":8},{"$f":"I1+1","v":9},{"$f":"J1+1","v":10},{"$f":"K1+1","v":11},{"$f":"L1+1","v":12},{"$f":"M1+1","v":13},{"$f":"N1+1","v":14},{"$f":"O1+1","v":15},{"$f":"P1+1","v":16},{"$f":"Q1+1","v":17},{"$f":"R1+1","v":18},{"$f":"S1+1","v":19},{"$f":"T1+1","v":20},{"$f":"U1+1","v":21},{"$f":"V1+1","v":22},{"$f":"W1+1","v":23},{"$f":"X1+1","v":24},{"$f":"Y1+1","v":25},{"$f":"Z1+1","v":26},{"$f":"AA1+1","v":27},{"$f":"AB1+1","v":28},{"$f":"AC1+1","v":29},{"$f":"AD1+1","v":30},{"$f":"AE1+1","v":31},"المعادلة",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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B3:$AF3=\"غياب\",$B$1:$AF$1),IF($B3:$AF3=\"\",$B$1:$AF$1)))>=7,COUNTIF($B3:$AF3,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","v":"إنذار بالفصل بسبب الغيابات"},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,null,null,null,null,null,null,{"$f":"IF(OR(MAX(FREQUENCY(IF($B4:$AF4=\"غياب\",$B$1:$AF$1),IF($B4:$AF4=\"\",$B$1:$AF$1)))>=7,COUNTIF($B4:$AF4,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","v":""}]
["موظف 2",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(OR(MAX(FREQUENCY(IF($B5:$AF5=\"غياب\",$B$1:$AF$1),IF($B5:$AF5=\"\",$B$1:$AF$1)))>=7,COUNTIF($B5:$AF5,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B6:$AF6=\"غياب\",$B$1:$AF$1),IF($B6:$AF6=\"\",$B$1:$AF$1)))>=7,COUNTIF($B6:$AF6,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B7:$AF7=\"غياب\",$B$1:$AF$1),IF($B7:$AF7=\"\",$B$1:$AF$1)))>=7,COUNTIF($B7:$AF7,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B8:$AF8=\"غياب\",$B$1:$AF$1),IF($B8:$AF8=\"\",$B$1:$AF$1)))>=7,COUNTIF($B8:$AF8,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B9:$AF9=\"غياب\",$B$1:$AF$1),IF($B9:$AF9=\"\",$B$1:$AF$1)))>=7,COUNTIF($B9:$AF9,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B10:$AF10=\"غياب\",$B$1:$AF$1),IF($B10:$AF10=\"\",$B$1:$AF$1)))>=7,COUNTIF($B10:$AF10,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B11:$AF11=\"غياب\",$B$1:$AF$1),IF($B11:$AF11=\"\",$B$1:$AF$1)))>=7,COUNTIF($B11:$AF11,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B12:$AF12=\"غياب\",$B$1:$AF$1),IF($B12:$AF12=\"\",$B$1:$AF$1)))>=7,COUNTIF($B12:$AF12,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B13:$AF13=\"غياب\",$B$1:$AF$1),IF($B13:$AF13=\"\",$B$1:$AF$1)))>=7,COUNTIF($B13:$AF13,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B14:$AF14=\"غياب\",$B$1:$AF$1),IF($B14:$AF14=\"\",$B$1:$AF$1)))>=7,COUNTIF($B14:$AF14,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B15:$AF15=\"غياب\",$B$1:$AF$1),IF($B15:$AF15=\"\",$B$1:$AF$1)))>=7,COUNTIF($B15:$AF15,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B16:$AF16=\"غياب\",$B$1:$AF$1),IF($B16:$AF16=\"\",$B$1:$AF$1)))>=7,COUNTIF($B16:$AF16,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B17:$AF17=\"غياب\",$B$1:$AF$1),IF($B17:$AF17=\"\",$B$1:$AF$1)))>=7,COUNTIF($B17:$AF17,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B18:$AF18=\"غياب\",$B$1:$AF$1),IF($B18:$AF18=\"\",$B$1:$AF$1)))>=7,COUNTIF($B18:$AF18,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B19:$AF19=\"غياب\",$B$1:$AF$1),IF($B19:$AF19=\"\",$B$1:$AF$1)))>=7,COUNTIF($B19:$AF19,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B20:$AF20=\"غياب\",$B$1:$AF$1),IF($B20:$AF20=\"\",$B$1:$AF$1)))>=7,COUNTIF($B20:$AF20,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B21:$AF21=\"غياب\",$B$1:$AF$1),IF($B21:$AF21=\"\",$B$1:$AF$1)))>=7,COUNTIF($B21:$AF21,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B22:$AF22=\"غياب\",$B$1:$AF$1),IF($B22:$AF22=\"\",$B$1:$AF$1)))>=7,COUNTIF($B22:$AF22,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B23:$AF23=\"غياب\",$B$1:$AF$1),IF($B23:$AF23=\"\",$B$1:$AF$1)))>=7,COUNTIF($B23:$AF23,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B24:$AF24=\"غياب\",$B$1:$AF$1),IF($B24:$AF24=\"\",$B$1:$AF$1)))>=7,COUNTIF($B24:$AF24,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B25:$AF25=\"غياب\",$B$1:$AF$1),IF($B25:$AF25=\"\",$B$1:$AF$1)))>=7,COUNTIF($B25:$AF25,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B26:$AF26=\"غياب\",$B$1:$AF$1),IF($B26:$AF26=\"\",$B$1:$AF$1)))>=7,COUNTIF($B26:$AF26,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B27:$AF27=\"غياب\",$B$1:$AF$1),IF($B27:$AF27=\"\",$B$1:$AF$1)))>=7,COUNTIF($B27:$AF27,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","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,{"$f":"IF(OR(MAX(FREQUENCY(IF($B28:$AF28=\"غياب\",$B$1:$AF$1),IF($B28:$AF28=\"\",$B$1:$AF$1)))>=7,COUNTIF($B28:$AF28,\"غياب\")>=15),\"إنذار بالفصل بسبب الغيابات\",\"\")","v":""}]