{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["السجل","جرد"],"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":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["ت","اسم الموظف","القسم","نوع الخروج","التاريخ","وقت الخروج","وقت العودة","مدة الخروج","الشهر","السنة"]
[1,"محمد1","المالي","زمنية","2025-01-01","10:30:00","11:30:00",{"$f":"TEXT(G2-F2, \"h:m\")","v":"1:0"},{"$f":"TEXT(E2,\"mmmm\")","v":"كانون الثاني"},"2025"]
[2,"محمد2","الإدارة","زمنية","2025-02-01","10:30:00","11:30:00",{"$f":"TEXT(G3-F3, \"h:m\")","v":"1:0"},{"$f":"TEXT(E3,\"mmmm\")","v":"شباط"},"2025"]
[3,"محمد1","المالي","زمنية","2025-02-03","10:30:00","11:30:00","1:0","شباط","2025"]
[4,"محمد4","المكتب الخاص","واجب","2025-02-01","10:30:00","12:00:00","1:30","شباط","2025"]
[5,"محمد4","المكتب الخاص","واجب","2025-02-02","10:30:00","12:00:00","1:30","شباط","2025"]
[6,"محمد1","المالي","زمنية","2025-02-05","10:30:00","11:30:00","1:0","شباط","2025"]
[7,"محمد4","المكتب الخاص","واجب","2025-02-03","10:30:00","12:00:00","1:30","شباط","2025"]
[8,"محمد4","المكتب الخاص","واجب","2025-02-04","10:30:00","12:00:00","1:30","شباط","2025"]
[9,"محمد4","المكتب الخاص","زمنية","2025-02-05","10:30:00","12:00:00","1:30","شباط","2025"]
[10,"محمد10","الإنتاج","واجب","2025-01-01","10:30:00","11:59:00","1:29","كانون الثاني","2025"]
[11,"محمد1","المالي","زمنية","2025-02-06","10:30:00","11:30:00","1:0","شباط","2025"]
[12,"محمد2","الإدارة","زمنية","2025-02-02","10:30:00","11:45:00","1:15","شباط","2025"]
[13,"محمد2","الإدارة","واجب","2025-02-03","10:30:00","11:45:00","1:15","شباط","2025"]
[14,"محمد2","الإدارة","واجب","2025-02-04","10:30:00","11:45:00","1:15","شباط","2025"]
[15,"محمد3","المخازن","واجب","2025-02-01","10:30:00","12:00:00","1:30","شباط","2025"]
[16,"محمد3","المخازن","واجب","2025-02-02","10:30:00","12:00:00","1:30","شباط","2025"]
[17,"محمد3","المخازن","واجب","2025-02-03","10:30:00","12:00:00","1:30","شباط","2025"]
[18,"محمد1","المالي","زمنية","2025-02-07","10:30:00","11:30:00","1:0","شباط","2025"]
[19,"محمد1","المالي","زمنية","2025-02-10","10:30:00","11:30:00","1:0","شباط","2025"]
[20,"محمد1","المالي","زمنية","2025-02-11","10:30:00","11:30:00","1:0","شباط","2025"]
[21,"محمد1","المالي","زمنية","2025-02-12","10:30:00","11:30:00","1:0","شباط","2025"]
[22,"محمد1","المالي","زمنية","2025-02-13","10:30:00","11:30:00","1:0","شباط","2025"]
[23,"محمد2","الإدارة","واجب","2025-02-06","10:30:00","11:45:00","1:15","شباط","2025"]
[24,"محمد2","الإدارة","مرضية","2025-02-10","12:30:00","14:30:00","2:0","شباط","2025"]
[25,"محمد2","الإدارة","زمنية","2025-02-12","13:45:00","14:30:00","0:45","شباط","2025"]
[26,"محمد10","الإنتاج","زمنية","2025-02-01","09:00:00","13:30:00","4:30","شباط","2025"]
[27,"محمد10","الإنتاج","زمنية","2025-02-02","09:00:00","13:30:00","4:30","شباط","2025"]
[28,"محمد10","الإنتاج","زمنية","2025-02-03","09:00:00","13:30:00","4:30","شباط","2025"]
[29,"محمد10","الإنتاج","زمنية","2025-02-04","09:00:00","13:30:00","4:30","شباط","2025"]
[30,"محمد1","المالي","تاخيرية","2025-03-01","09:00:00","09:15:00","0:15","آذار","2025"]
[31,"محمد1","المالي","مرضية","2025-03-02","09:00:00","10:00:00","1:0","آذار","2025"]

{"sheet":"جرد","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["نوع الخروج","الشهر","السنة"]
["زمنية","شباط",2025,null,null,null,null,"ترحيل أسماء الموظفين بدون تكرار "]
[]
["ت","اسم الموظف","القسم","مجموع عدد الساعات","بالايام","المدور/ساعة",null,"استدعاء البيانات حسب الشروط (نوع الخروج + الشهر + السنة)"]
[1,"محمد1","المالي",8,1,1,null,"احتساب كل 7 ساعات خروج زمنية تحتسب يوم إجازة"]
[2,"محمد10","الإنتاج",18,2,4,null,"فاذا كان عدد ساعات الخروج (6) ساعات يكون مدور على الشهر اللي يليه"]
[null,null,null,null,null,null,null,"واذا كان عدد ساعات الخروج (10) ساعات يحتسب يوم إجازة  والباقي (4) ساعات مدور"]
[null,null,null,null,null,null,null,"وكل عدد ساعات التأخيرية (7) ساعات يحتسب يوم إجازة واذا أقل من (7) ساعات تجمع الساعات في عمود المدور"]
[]
[null,null,null,null,null,null,null,"ذكرت بعض النتائج المطلوبة"]