{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"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":"ورقة1","index":0,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,7],[21,0,21,3],[21,5,21,7],[18,0,18,1],[18,3,18,4],[18,6,18,7],[19,0,19,1],[19,3,19,4],[19,6,19,7],[17,0,17,1],[17,3,17,4],[17,6,17,7],[0,0,0,6],[0,7,0,8],[14,0,14,2],[14,4,14,5],[16,0,16,1],[16,3,16,4],[16,6,16,7],[0,11,0,13],[12,0,12,2],[12,4,12,5],[13,0,13,2],[13,4,13,5]]}
["حضور  وانصراف الموظف (نموذج )  لشهر  ديسمبر  2024م",null,null,null,null,null,null,"مجموع الساعات",null,null,null,null,null,null,null,null,null,233.333333333333]
["اليوم","التاريخ ( ميلادي)","التاريخ ( هجري)","الساعات اليومية","حضور","إنصراف","عدد الساعات","دقيقة","ساعة","إجمالي التأخير",null,"غياب ومتأخرات","متأخرات","غياب","المسموحة","إجمالي ساعات الحضور",null,"الراتب الأساسي","الراتب اليومي","الراتب بالساعة","الرتب بعد الخصم"]
[{"$f":"B3","v":"2024-12-08"},"2024-12-08",{"$f":"B3","v":"2024-12-08"},9,"09:27","18:17",{"$f":"F3-E3","v":"08:50:00"},{"$f":"MINUTE(G3)","v":50},{"$f":"HOUR(G3)","v":8},{"$f":"P3-G3","v":"00:10:00"},null,{"$f":"IF(D3=8,4,9)-(HOUR(G3)+(MINUTE(G3)/60))","v":0.16666666666666607},{"$f":"IF(L3=4.5,0,L3)","v":0.16666666666666607},{"$f":"IF(L3=4.5,4.5,0)","v":0},"00:00:00","09:00:00",null,7000,{"$f":"R3/30","v":233.33333333333334},{"$f":"S3/9","v":25.925925925925927},221.66666666666669]
["2024-12-09","2024-12-09","2024-12-09",9,"09:30:00","18:30","09:00:00",0,9,"00:00:00",null,0,0,0,"00:00:00","09:00:00",null,null,null,null,210]
["2024-12-10","2024-12-10","2024-12-10",9,"09:18:00","17:33","08:15:00",15,8,"00:45:00",null,0.75,0.75,0,"00:00:00","09:00:00",null,null,null,null,186.66666666666669]
["2024-12-11","2024-12-11","2024-12-11",9,"09:18:00","19:08","09:50:00",50,9,-3.4722222222222154E-2,null,-0.83333333333333393,-0.83333333333333393,0,"00:00:00","09:00:00",null,null,null,null,186.66666666666669]
["2024-12-12","2024-12-12","2024-12-12",9,"09:04:00","17:46","08:42:00",42,8,"00:18:00",null,0.30000000000000071,0.30000000000000071,0,"00:00:00","09:00:00",null,null,null,null,233.33333333333334]
["2024-12-15","2024-12-15","2024-12-15",9,"09:45:00","16:31","06:46:00",46,6,"02:14:00",null,2.2333333333333334,2.2333333333333334,0,"00:00:00","09:00:00",null,null,null,null,210]
["2024-12-16","2024-12-16","2024-12-16",9,"10:00:00","16:31","06:31:00",31,6,"02:29:00",null,2.4833333333333334,2.4833333333333334,0,"00:00:00","09:00:00",null,null,null,null,175]
["2024-12-17","2024-12-17","2024-12-17",9,"09:00","16:58","07:58:00",58,7,"01:02:00",null,1.0333333333333332,1.0333333333333332,0,"00:00:00","09:00:00",null,null,null,null,233.33333333333334]
["2024-12-18","2024-12-18","2024-12-18",9,"09:44:00","17:40","07:56:00",56,7,"01:04:00",null,1.0666666666666664,1.0666666666666664,0,"00:00:00","09:00:00",null,null,null,null,198.33333333333334]
["2024-12-19","2024-12-19","2024-12-19",9,"09:37:00","08:56:00",-2.8472222222222232E-2,{"$error":"#NUM!"},{"$error":"#NUM!"},"09:41:00",null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"00:00:00","09:00:00",null,null,null,null,175]
["مجموع ساعات العمل الرسمية",null,null,{"$f":"SUM(D3:D12)","v":90},"مجموع ساعات العمل الفعلية",null,{"$f":"SUM(G3:G12)","v":3.0465277777777775},{"$f":"SUM(H3:H12)","v":{"$error":"#NUM!"}},{"$f":"SUM(I3:I12)","v":{"$error":"#NUM!"}},{"$f":"SUM(J3:J12)","v":0.70347222222222228},null,{"$f":"SUM(L3:L12)","v":{"$error":"#NUM!"}},{"$f":"SUM(M3:M12)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(O3:O12)","v":"00:00:00"},{"$f":"SUM(P3:P12)","v":3.75}]
[]
[]
[]
["المتأخرات ( بالساعة )",null,{"$f":"M13","v":{"$error":"#NUM!"}},"الغياب باسـتئذان",null,0,"ساعات الخصم",null,0,null,null,null,{"$f":"H13/60","v":{"$error":"#NUM!"}},{"$f":"INT(M17)","v":{"$error":"#NUM!"}},{"$f":"IF(O18=4.5,0,O18)","v":{"$error":"#NUM!"}},{"$f":"SUM(O18,G13)+F17+C18","v":{"$error":"#NUM!"}}]
["المتأخرات المسموح بها",null,{"$f":"O13","v":"00:00:00"},"الغياب بدون استئذان",null,0,"الراتب / الساعة",null,7000,null,null,null,{"$f":"(M17-N17)*60","v":{"$error":"#NUM!"}},{"$f":"I13+N17","v":{"$error":"#NUM!"}},{"$f":"M18/60+N18","v":{"$error":"#NUM!"}}]
["المتأخرات المحسوبة",null,"0","مجموع الغيـاب",null,0,"عدد ساعات الحضور",null,{"$f":"G13","v":3.0465277777777775},null,null,null,null," "]
["مجوع ساعات الغياب والتأخير",null,{"$f":"C19+F19","v":0},"الخصم من الراتب",null,{"$f":"I18-I20","v":{"$error":"#NUM!"}},"صافي الراتب",null,{"$f":"I18/D13*P17","v":{"$error":"#NUM!"}},null,null,"العطل الأسبوعية","إجازات بمقابل","استئذان دخول او خروج",null,{"$f":"I18/D13*G13+L21+M21+N21","v":2933.2484567901233}]
["ملاحظة : في حالة زيادة عدد ساعات العمل عن ساعات العمل المطلوبة يحتسب ساعات تطوعية بدون مقابل",null,null,null,null,null,null,null,null,null,null,{"$f":"8*S3","v":1866.6666666666667},{"$f":"3*S3","v":700},{"$f":"5*T3","v":129.62962962962965}]
["اعتماد المتابعة ",null,null,null,null,"توقيع الموظف على المراجعة "]