{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["السجل","بطاقة الموظف","بطاقة كل الموظفين","احتساب عدد الساعات"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,9,5,11]]}
["ت","اسم الموظف","القسم","نوع الخروج","التاريخ","وقت الخروج","وقت العودة","الفرق"]
[1,"محمد1","المالي","زمنية","2025-01-01","10:30:00","23:30:00",0.54166666666666663]
[2,"محمد2","الإدارة","زمنية","2025-02-01","10:30:00","11:30:00",4.1666666666666685E-2]
[3,"محمد1","المالي","زمنية","2025-02-03","08:00:00","21:00:00",0.54166666666666674,null,null,"معادلة لاحتساب الفرق"]
[4,"محمد4","المكتب الخاص","واجب","2025-02-01","10:30:00","12:00:00",6.25E-2,null,null,"من وقت الخروج الى وقت العودة حسب التاريخ"]
[5,"محمد4","المكتب الخاص","واجب","2025-02-02","10:30:00","12:00:00",6.25E-2,null,"مع الترحيل الى شيت احتساب عدد الساعات    بان الموظف لديه اكثر من سبع ساعات خروج (زمنية)  على أساس كل شهر"]
[6,"محمد1","المالي","مرضية","2025-02-05","09:45:00","11:00:00",5.2083333333333315E-2]
[7,"محمد4","المكتب الخاص","واجب","2025-02-03","10:30:00","12:00:00",6.25E-2]
[8,"محمد4","المكتب الخاص","واجب","2025-02-04","10:30:00","12:00:00",6.25E-2]
[9,"محمد4","المكتب الخاص","زمنية","2025-02-05","10:30:00","12:00:00",6.25E-2]
[10,"محمد10","الإنتاج","واجب","2025-01-01","10:30:00","11:59:00",6.1805555555555558E-2]
[11,"محمد1","المالي","زمنية","2025-02-06","13:30:00","14:10:00",2.777777777777779E-2]
[12,"محمد2","الإدارة","زمنية","2025-02-02","10:30:00","11:45:00",5.2083333333333315E-2]
[13,"محمد2","الإدارة","واجب","2025-02-03","10:30:00","11:45:00",5.2083333333333315E-2]
[14,"محمد2","الإدارة","واجب","2025-02-04","10:30:00","11:45:00",5.2083333333333315E-2]
[15,"محمد3","المخازن","واجب","2025-02-01","10:30ص","12:00:00",6.25E-2]
[16,"محمد3","المخازن","واجب","2025-02-02","10:30ص","12:00:00",6.25E-2]
[17,"محمد3","المخازن","واجب","2025-02-03","10:30ص","12:00:00",6.25E-2]
[18,"محمد1","المالي","زمنية","2025-02-07","11:30:00","12:00:00",2.0833333333333315E-2]
[19,"محمد1","المالي","واجب","2025-02-10","11:55:00","13:30:00",6.597222222222221E-2]
[20,"محمد1","المالي","واجب","2025-02-11","14:30:00","15:00:00",2.083333333333337E-2]
[21,"محمد1","المالي","واجب","2025-02-12","14:30:00","15:00:00",2.083333333333337E-2]
[22,"محمد1","المالي","زمنية","2025-02-13","14:30:00","15:00:00",2.083333333333337E-2]
[23,"محمد2","الإدارة","واجب","2025-02-06","10:30:00","11:45:00",5.2083333333333315E-2]
[24,"محمد2","الإدارة","مرضية","2025-02-10","12:30:00","14:30:00",8.3333333333333259E-2]
[25,"محمد2","الإدارة","زمنية","2025-02-12","13:45:00","14:30:00",3.125E-2]
[26,"محمد10","الإنتاج","زمنية","2025-02-01","09:00:00","13:30:00",0.1875]
[27,"محمد10","الإنتاج","زمنية","2025-02-02","09:00:00","13:30:00",0.1875]
[28,"محمد10","الإنتاج","زمنية","2025-02-03","09:00:00","13:30:00",0.1875]
[29,"محمد10","الإنتاج","زمنية","2025-02-04","09:00:00","13:30:00",0.1875]

{"sheet":"بطاقة الموظف","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["من تاريخ","الى تاريخ","اسم الموظف","نوع الخروج",null,null,null,null,"التاريخ","التاريخ","اسم الموظف","نوع الخروج"]
["2025-01-01","2025-02-28","محمد1","زمنية",null,null,null,null,{"$f":"\">=\"&A2","v":">=45658"},{"$f":"\"<=\"&B2","v":"<=45716"},{"$f":"C2","v":"محمد1"},{"$f":"D2","v":"زمنية"}]
[]
[null,null,null,"مجموع عدد الساعات والدقائق",1.1527777777777777]
["القسم","نوع الخروج","التاريخ","وقت الخروج","وقت العودة","الفرق"]
[1,"محمد1","2025-01-01","10:30:00","23:30:00",0.54166666666666663]
[3,"محمد1","2025-02-03","08:00:00","21:00:00",0.54166666666666674]
[11,"محمد1","2025-02-06","13:30:00","14:10:00",2.777777777777779E-2]
[18,"محمد1","2025-02-07","11:30:00","12:00:00",2.0833333333333315E-2]
[22,"محمد1","2025-02-13","14:30:00","15:00:00",2.083333333333337E-2]

{"sheet":"بطاقة كل الموظفين","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["اسم الموظف","القسم","مجموع عدد الساعات والدقائق (الزمنية)"]
["محمد1","المالي"]
["محمد2","الإدارة"]
["محمد4","المكتب الخاص"]
["محمد10","الإنتاج"]
["محمد3","المخازن"]

{"sheet":"احتساب عدد الساعات","index":3,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["اسم الموظف","القسم","نوع الحركة (زمنية)","إجمالي عدد الساعات","الشهر","عدد الأيام والساعات المتبقية",null,null,"اسم الموظف","القسم","نوع الخروج","عدد الساعات","الشهر","عدد الأيام"]
["محمد1",null,"زمنية",1.1527777777777777,null,"4 ساعة 1 يوم "]
["محمد2","القسم","زمنية",0.125,"الشهر","3 ساعة 0 يوم "]
["محمد4","الإنتاج","زمنية",6.25E-2,"شباط","2 ساعة 0 يوم "]
["محمد10",null,"زمنية",0.75,null,"18 ساعة 0 يوم "]
["محمد10",null,"زمنية",0.75,null,"0 يوم 18 ساعة"]