{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ابراهيم البدري","باسم عادل","محمود الشحات","محمد ناصر","الرئسية","قاعدة_لتصدير","شرح_استخدام_البرنامج"],"not_rendered":{"charts":0,"images":3,"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":"ابراهيم البدري","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,7],[1,4,1,7],[1,11,3,11],[2,5,2,7]]}
[null,"حساب  / ابراهيم البدري",null,null,"الإجمالي كله",null,null,null,{"$f":"SUM(H5:H1048575)","v":258.33333333333326},null,{"$f":"COUNTIF(A5:A1048575,$A$3 &\"*\")","v":2}]
["غياب",8.3333333333333304,"اضفط علي هذا الشخص",null,"سحب",null,null,null,{"$f":"SUM(L5:L1048575)","v":50},null,{"$f":"COUNTIF(A5:A1048576,$A$2 &\"*\")","v":1},"سحب يومي"]
["حضور",null,null,null,"الحساب صفر",{"$f":"IF(I3>1,\"الباقي إلي \"&B1,IF(I3<0,\"الباقي علي \"&B1,\"حساب غير نشط\"))","v":"الباقي إلي حساب  / ابراهيم البدري"},null,null,{"$f":"I1-I2","v":208.33333333333326}]
["الاسم","التاريخ","وقت حضور","وقت الانصراف","مجموع دقيقة","عدد الساعات","سعر الساعة","القيمه","السعر بالتفقيط","وقت الانتهاء","ملحوظة"]
["حضور","2023-3-09-الخميس","10:25:00","22:25:00",720,12,8.3333333333333304,99.999999999999972,"فقط : مائة جنيه فقطُ لا غيرَ","وقت الانتهاء",null,null,{"$f":"IF(L5<>\"\",IF(M5=\"\",NOW(),M5),\"\")","v":""}]
["غياب","2023-3-10-الجمعة","14:27:00",null,0,null,8.3333333333333304,null,null,"وقت الانتهاء",null,50,{"$f":"IF(L6<>\"\",IF(M6=\"\",NOW(),M6),\"\")","v":"2023-03-10T14:28:05.960"}]
["حضور","2023-3-11-السبت","03:02:00","22:02:00",{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",IF(AND(C7=\"\",D7<>\"\"),K9,IF(AND(D7=\"\",C7<>\"\"),K7,(D7-C7+(D7<C7))*1440)))","v":1140},{"$f":"IF(D7>0,E7/60,\"\")","v":19},8.3333333333333304,{"$f":"IF(D7>0,F7*G7,\"\")","v":158.33333333333329},{"$f":" IF(D7>0,  \"فقط : \" & ArbNum2Text(H7),\"\")","v":"فقط : مائة وثمانية وخمسونَ جنيهاً وثلاثة وثلاثونَ قرشاً فقطُ لا غيرَ"},"وقت الانتهاء",null,null,{"$f":"IF(L7<>\"\",IF(M7=\"\",NOW(),M7),\"\")","v":""}]

{"sheet":"باسم عادل","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,7],[1,4,1,7],[1,11,3,11],[2,5,2,7]]}
[null,"حساب  / باسم عادل",null,null,"الإجمالي كله",null,null,null,{"$f":"SUM(H5:H1048575)","v":191.71295759500001},null,{"$f":"COUNTIF(A5:A1048575,$A$3 &\"*\")","v":5}]
["غياب",2.7777777000000001,"اضغط علي هذا الشخص",null,"سحب",null,null,null,{"$f":"SUM(L5:L1048575)","v":70},null,{"$f":"COUNTIF(A5:A1048576,$A$2 &\"*\")","v":1},"سحب يومي"]
["حضور",null,null,null,"الحساب صفر",{"$f":"IF(I3>1,\"الباقي إلي \"&B1,IF(I3<0,\"الباقي علي \"&B1,\"حساب غير نشط\"))","v":"الباقي إلي حساب  / باسم عادل"},null,null,{"$f":"I1-I2","v":121.71295759500001}]
["الاسم","التاريخ","وقت حضور","وقت الانصراف","مجموع دقيقة","عدد الساعات","سعر الساعة","القيمه","السعر بالتفقيط","وقت الانتهاء","ملحوظة"]
["حضور","2023-3-05-الأحد","10:00:00","22:00:00",719.99999999999989,11.999999999999998,2.7777777000000001,33.333332399999996,"فقط : ثلاثة وثلاثونَ جنيهاً وثلاثة وثلاثونَ قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,null,{"$f":"IF(L5<>\"\",IF(M5=\"\",NOW(),M5),\"\")","v":""}]
["حضور","2023-3-05-الأحد","10:00:00","22:01:00",720.99999999999989,12.016666666666664,2.7777777000000001,33.379628694999994,"فقط : ثلاثة وثلاثونَ جنيهاً وثمانية وثلاثونَ قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,null,""]
["غياب","2023-3-05-الأحد","10:01:00",null,0,null,2.7777777000000001,null,null,"وقت الانتهاء",null,null,""]
["حضور","2023-3-07-الثلاثاء","09:44:00","21:44:00",720,12,2.7777777000000001,33.333332400000003,"فقط : ثلاثة وثلاثونَ جنيهاً وثلاثة وثلاثونَ قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,50,"2023-03-07T09:45:25.750"]
["حضور","2023-3-09-الخميس","09:19:00","23:19:00",839.99999999999989,13.999999999999998,2.7777777000000001,38.888887799999999,"فقط : ثمانية وثلاثونَ جنيهاً وتسعة وثمانونَ قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,20,"2023-03-09T10:19:52.290"]
["حضور","2023-3-11-السبت","03:01:00","22:01:00",1140,19,2.7777777000000001,52.777776299999999,"فقط : اثنانِ وخمسونَ جنيهاً وثمانية وسبعونَ قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,null,""]
[null,null,null,null,{"$f":"IF(AND(C11=\"\",D11=\"\"),\"\",IF(AND(C11=\"\",D11<>\"\"),K13,IF(AND(D11=\"\",C11<>\"\"),K11,(D11-C11+(D11<C11))*1440)))","v":""},{"$f":"IF(D11>0,E11/60,\"\")","v":""},2.7777777000000001,null,null,"وقت الانتهاء",null,null,""]

{"sheet":"محمود الشحات","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,7],[1,4,1,7],[1,11,3,11],[2,5,2,7]]}
[null,"حساب  / محمود الشحات",null,null,"الإجمالي كله",null,null,null,{"$f":"SUM(H5:H1048575)","v":375.00000000000006},null,{"$f":"COUNTIF(A5:A1048575,$A$3 &\"*\")","v":2}]
["غياب",12.5,"اضغط علي هذا الشخص",null,"سحب",null,null,null,{"$f":"SUM(L5:L1048575)","v":50},null,{"$f":"COUNTIF(A5:A1048576,$A$2 &\"*\")","v":1},"سحب يومي"]
["حضور",null,null,null,"الحساب صفر",{"$f":"IF(I3>1,\"الباقي إلي \"&B1,IF(I3<0,\"الباقي علي \"&B1,\"حساب غير نشط\"))","v":"الباقي إلي حساب  / محمود الشحات"},null,null,{"$f":"I1-I2","v":325.00000000000006}]
["الاسم","التاريخ","وقت حضور","وقت الانصراف","مجموع دقيقة","عدد الساعات","سعر الساعة","القيمه","السعر بالتفقيط","وقت الانتهاء","ملحوظة"]
["حضور","2023-3-09-الخميس","10:23:00","22:23:00",720,12,12.5,150,"فقط : مائة وخمسونَ جنيهاً فقطُ لا غيرَ","وقت الانتهاء",null,50,{"$f":"IF(L5<>\"\",IF(M5=\"\",NOW(),M5),\"\")","v":"2023-03-09T10:23:50.120"}]
["غياب","2023-3-10-الجمعة","14:27:00",null,0,null,12.5,null,null,"وقت الانتهاء",null,null,{"$f":"IF(L6<>\"\",IF(M6=\"\",NOW(),M6),\"\")","v":""}]
["حضور","2023-3-11-السبت","03:59:00","21:59:00",{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",IF(AND(C7=\"\",D7<>\"\"),K9,IF(AND(D7=\"\",C7<>\"\"),K7,(D7-C7+(D7<C7))*1440)))","v":1080.0000000000002},{"$f":"IF(D7>0,E7/60,\"\")","v":18.000000000000004},12.5,{"$f":"IF(D7>0,F7*G7,\"\")","v":225.00000000000006},{"$f":" IF(D7>0,  \"فقط : \" & ArbNum2Text(H7),\"\")","v":"فقط : مائتان وخمسة وعشرونَ جنيهاً فقطُ لا غيرَ"},"وقت الانتهاء",null,null,{"$f":"IF(L7<>\"\",IF(M7=\"\",NOW(),M7),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C8=\"\",D8=\"\"),\"\",IF(AND(C8=\"\",D8<>\"\"),K10,IF(AND(D8=\"\",C8<>\"\"),K8,(D8-C8+(D8<C8))*1440)))","v":""},{"$f":"IF(D8>0,E8/60,\"\")","v":""},12.5,null,null,"وقت الانتهاء",null,null,{"$f":"IF(L8<>\"\",IF(M8=\"\",NOW(),M8),\"\")","v":""}]

{"sheet":"محمد ناصر","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,7],[1,4,1,7],[1,11,3,11],[2,5,2,7]]}
[null,"حساب  / محمد ناصر",null,null,"الإجمالي كله",null,null,null,{"$f":"SUM(H5:H1048575)","v":458.47222222222206},null,{"$f":"COUNTIF(A5:A1048575,$A$3 &\"*\")","v":4}]
["غياب",8.3333333333333304,"اضغط علي هذا الشخص",null,"سحب",null,null,null,{"$f":"SUM(L5:L1048575)","v":150},null,{"$f":"COUNTIF(A5:A1048576,$A$2 &\"*\")","v":2},"سحب يومي"]
["حضور",null,null,null,"الحساب صفر",{"$f":"IF(I3>1,\"الباقي إلي \"&B1,IF(I3<0,\"الباقي علي \"&B1,\"حساب غير نشط\"))","v":"الباقي إلي حساب  / محمد ناصر"},null,null,{"$f":"I1-I2","v":308.47222222222206}]
["الاسم","التاريخ","وقت حضور","وقت الانصراف","مجموع دقيقة","عدد الساعات","سعر الساعة","القيمه","السعر بالتفقيط","وقت الانتهاء","ملحوظة"]
["حضور","2023-3-05-الأحد","10:03:00","22:03:00",720,12,8.3333333333333304,99.999999999999972,"فقط : مائة جنيه فقطُ لا غيرَ","وقت الانتهاء",null,null,{"$f":"IF(L5<>\"\",IF(M5=\"\",NOW(),M5),\"\")","v":""}]
["حضور","2023-3-07-الثلاثاء","09:46:00","21:46:00",719.99999999999989,11.999999999999998,8.3333333333333304,99.999999999999943,"فقط : مائة جنيه فقطُ لا غيرَ","وقت الانتهاء",null,100,"2023-03-07T09:46:18.760"]
["غياب","2023-3-10-الجمعة","14:28:00",null,{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",IF(AND(C7=\"\",D7<>\"\"),K9,IF(AND(D7=\"\",C7<>\"\"),K7,(D7-C7+(D7<C7))*1440)))","v":0},{"$f":"IF(D7>0,E7/60,\"\")","v":""},8.3333333333333304,{"$f":"IF(D7>0,F7*G7,\"\")","v":""},{"$f":" IF(D7>0,  \"فقط : \" & ArbNum2Text(H7),\"\")","v":""},"وقت الانتهاء",null,null,""]
["حضور","2023-3-09-الخميس","10:24:00","22:25:00",721,12.016666666666667,8.3333333333333304,100.13888888888886,"فقط : مائة جنيه وأربعة عشر قرشاً فقطُ لا غيرَ","وقت الانتهاء",null,50,"2023-03-09T10:25:14.910"]
["غياب","2023-3-10-الجمعة","14:28:00",null,0,null,8.3333333333333304,null,null,"وقت الانتهاء",null,null,""]
["حضور","2023-3-11-السبت","03:00:00","22:00:00",{"$f":"IF(AND(C10=\"\",D10=\"\"),\"\",IF(AND(C10=\"\",D10<>\"\"),K12,IF(AND(D10=\"\",C10<>\"\"),K10,(D10-C10+(D10<C10))*1440)))","v":1140},{"$f":"IF(D10>0,E10/60,\"\")","v":19},8.3333333333333304,{"$f":"IF(D10>0,F10*G10,\"\")","v":158.33333333333329},{"$f":" IF(D10>0,  \"فقط : \" & ArbNum2Text(H10),\"\")","v":"فقط : مائة وثمانية وخمسونَ جنيهاً وثلاثة وثلاثونَ قرشاً فقطُ لا غيرَ"},"وقت الانتهاء",null,null,""]

{"sheet":"الرئسية","index":4,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"TODAY()","v":"2023-03-11"}]
[null,null,null,null,null,null,"ابراهيم البدري","yiyuoiyu"]
[null,null,null,null,"اضغط علي هذا الشخص",null,"باسم عادل","باسم عادل",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ISERROR(FIND(\"/\",T4))","v":true}]
[null,null,null,null,null,null,"محمود الشحات","محمود الشحات",null,null,null,null,null,null,null,null,null,null,null,"محمود الشحات"]
[null,null,null,null,null,null,"محمد ناصر","محمد ناصر"]

{"sheet":"قاعدة_لتصدير","index":5,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,11,3,11],[0,1,0,3],[0,4,0,7],[1,4,1,7],[2,5,2,7]]}
[null,null,null,null,"الإجمالي كله",null,null,null,{"$f":"SUM(H5:H1048575)","v":0},null,{"$f":"COUNTIF(A5:A1048575,$A$3 &\"*\")","v":0}]
["غياب",12.5,"اضغط  علي هذا الشخص",null,"سحب",null,null,null,{"$f":"SUM(L5:L1048575)","v":0},null,{"$f":"COUNTIF(A5:A1048576,$A$2 &\"*\")","v":0},"سحب يومي"]
["حضور",null,null,null,"الحساب صفر",{"$f":"IF(I3>1,\"الباقي إلي \"&B1,IF(I3<0,\"الباقي علي \"&B1,\"حساب غير نشط\"))","v":"حساب غير نشط"},null,null,{"$f":"I1-I2","v":0}]
["الاسم","التاريخ","وقت حضور","وقت الانصراف","مجموع دقيقة","عدد الساعات","سعر الساعة","القيمه","السعر بالتفقيط","وقت الانتهاء","ملحوظة"]
[null,null,null,null,{"$f":"IF(AND(C5=\"\",D5=\"\"),\"\",IF(AND(C5=\"\",D5<>\"\"),K7,IF(AND(D5=\"\",C5<>\"\"),K5,(D5-C5+(D5<C5))*1440)))","v":""},{"$f":"IF(D5>0,E5/60,\"\")","v":""},12.5,null,null,"وقت الانتهاء",null,null,{"$f":"IF(L5<>\"\",IF(M5=\"\",NOW(),M5),\"\")","v":""}]

{"sheet":"شرح_استخدام_البرنامج","index":6,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,"اختار  حضور اوغياب من عمود a    البرنامج يقوم بإدخال الوقت والتاريخ تلقائي",null,null,null,null,null,1,"وقت الضور"]
[]
[2,"إضغط Shift + Ctrl + حرف الكاف لإدخال الوقت الحالي",null,null,null,null,null,2,"وقت الانصراف"]
[]
[3,"في  B2 يتم كتابة سعر الساعه المتفق عليها .... مثلاً  سعر الساعة 12 جنية يبقي ال 12 ساعة ب 150 جنية"]
[]
[4,"السحب الليومي  للموظف يتم كتابته في عمود  L  "]