{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FIN","HR","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"FIN","index":0,"n_rows":44,"n_cols":37,"rows_kept":44,"cut":false,"hidden":false,"merged":[[8,0,8,3],[8,4,8,36],[2,17,2,18],[2,32,2,36],[3,14,3,15],[3,35,3,36],[4,5,5,30],[4,31,4,33],[4,35,4,36],[26,31,26,33],[26,35,26,36],[30,0,30,3],[30,4,30,36],[24,17,24,18],[24,32,24,36],[25,14,25,15],[25,35,25,36],[26,5,27,30]]}
[]
[" "]
[null,"سيد سعيد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1/9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayed said"]
[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,null,"Location :Finance"]
[null,"الادارة",null,null,null,"عن الفترة من 15 / 4 / 2019    الى    14 / 5  / 2019",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,"Managment"]
[]
[]
["م ","الاســـــــــــــــــــــــــــــم","رقم العامل","الوظيفة",15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"الاجمالى","ملاحـــــــــــــظات"]
["الحسابات   (    1    )"]
[1,"محمد ثروت ",770,"رئيس حسابات",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,1,1,1,1,1,null,{"$f":"SUM(E10:AI10)","v":17}]
[2,"محمود علي ",90,"محاسب",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,{"$f":"SUM(E11:AI11)","v":16}]
[3,"مرعى مراد ",330,"محاسب",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,{"$f":"SUM(E12:AI12)","v":16}]
[4,"محمد محمد ",712,"محاسب",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,16]
[5,"محمد الصاوى",931,"محاسب",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,16]
[6,"احمد محمد",1168,"محاسب",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,16]
[7,"ابراهيم عاشور",1327,"مدير حسابات",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,16]
[8,"بلال محمد ",1826,"محاسب تكاليف",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,1,1,1,null,{"$f":"SUM(E17:AI17)","v":16}]
[9,"زكى اسماعيل",1854,"محاسب موردين",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,0,"غ","غ","غ","غ",null,{"$f":"SUM(E18:AI18)","v":12}]
[10,"حسن محمود ",1574,"عملاء",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,"م","م","م","م","م",null,{"$f":"SUM(E19:AI19)","v":12}]
[11,"احمد محمود ",1689,"تحصيلات",1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,null,0,0,0,0,0,0,0,0,1,1,1,1,0,null,16]
[]
[]
[]
[" "]
[null,"سيد سعيد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1/13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayed said"]
[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,null,"Location :Finance"]
[null,"الادارة",null,null,null,"عن الفترة من 15 / 4 / 2019    الى    14 / 5  / 2019",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,"Managment"]
[]
[]
["م ","الاســـــــــــــــــــــــــــــم","رقم العامل","الوظيفة",15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"الاجمالى","ملاحـــــــــــــظات"]
["الحسابات   (    2    )"]
[1,"الشناوي سالمان",{"$f":"+C10*2-9","v":1531},"رئيس حسابات",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E32:AI32)","v":13}]
[2,"كامل عوض",{"$f":"+C11*2-9","v":171},"محاسب",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:AI33)","v":4}]
[3,"عبد المحسن مراد",651,"محاسب",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E34:AI34)","v":13}]
[4,"صلاح الدين كمال",1415,"محاسب",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,15]
[5," عبدالخالق النجار",1853,"محاسب",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,"ت",1,1,1,0,0,0,0,null,12]
[6," محمود قبلان",2327,"محاسب",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,13]
[7," جابر احمد",2645,"مدير حسابات",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,"م",1,1,0,0,0,0,null,12]
[8,"معتز محمد",3643,"محاسب",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,13]
[9,"محسن جلال",3699,"محاسب",null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,13]
[10,"محمود حسن ",3139,"محاسب تكاليف",null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,13]
[11," على سليم",3369,"محاسب موردين",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,13]
[12,"حسن محمد",657,"عملاء",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E43:AI43)","v":13}]
[13,"عبد الرحيم عبد المولى",3392,"تحصيلات",0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,1,1,1,1,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E44:AI44)","v":13}]

{"sheet":"HR","index":1,"n_rows":34,"n_cols":37,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,17,2,18],[2,32,2,36],[3,14,3,15],[3,35,3,36],[4,5,5,30],[4,31,4,33],[4,35,4,36],[8,0,8,3],[8,4,8,36],[20,17,20,18],[20,32,20,36],[21,14,21,15],[21,35,21,36],[22,5,23,30],[22,31,22,33],[22,35,22,36],[26,0,26,3],[26,4,26,36]]}
[]
[" "]
[null,"سيد سعيد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1/9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayed said"]
[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,null,"Location :HR"]
[null,"الادارة",null,null,null,"عن الفترة من 15 / 4 / 2019    الى    14 / 5  / 2019",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,"Managment"]
[]
[]
["م ","الاســـــــــــــــــــــــــــــم","رقم العامل","الوظيفة",15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"الاجمالى","ملاحـــــــــــــظات"]
["الحسابات   (    1    )"]
[1,"سمير حسين ",99,"رئيس موراد بشرية",0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,1,1,1,1,1,null,{"$f":"SUM(E10:AI10)","v":14}]
[2,"تامر خميس ",200,"موظف",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,{"$f":"SUM(E11:AI11)","v":12}]
[3,"حسام جعفر ",204,"موظف",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,{"$f":"SUM(E12:AI12)","v":12}]
[4,"ايمن عبدالمعز",308,"موظف",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,12]
[5,"إبراهيم أحمد ",1423,"تعينات",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,12]
[6,"خليل عبد الوارث",1427,"استمارات",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,12]
[7,"احمد محمد ابراهيم ",3011,"تدريب",0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,null,1,1,1,1,0,0,0,0,0,1,1,1,1,null,12]
[]
[]
[]
[" "]
[null,"سيد سعيد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1/13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayed said"]
[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,null,"Location :Finance"]
[null,"الادارة",null,null,null,"عن الفترة من 15 / 4 / 2019    الى    14 / 5  / 2019",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,"Managment"]
[]
[]
["م ","الاســـــــــــــــــــــــــــــم","رقم العامل","الوظيفة",15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"الاجمالى","ملاحـــــــــــــظات"]
["الحسابات   (    2    )"]
[1,"مجدي عبدالعظيم",325,"مدير موراد بشرية",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E28:AI28)","v":11}]
[2,"علام احمد",412,"موظف",null,null,null,null,null,null,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,"غ","غ","غ","م","م",1,null,{"$f":"SUM(E29:AI29)","v":8}]
[3,"احمد ابراهيم ",1418,"موظف",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,{"$f":"SUM(E30:AI30)","v":11}]
[4,"محمد خلاف",1421,"تدريب",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,11]
[5,"هانى عبد الهادى",3125,"تعينات",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,11]
[6,"شعبان عبد الله",3244,"استمارات",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,11]
[7,"أحمد مصطفى",3333,"استقالات",1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,1,null,0,0,0,0,1,1,1,1,1,0,0,0,0,null,11]

{"sheet":"Sheet2","index":2,"n_rows":50,"n_cols":36,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[49,0,49,3]]}
[]
[]
["م","اسم الموظف","رقم الموظف","الوظيفة",15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"الاجمالى"]
[1,"محمود علي ",90]
[2,"سمير حسين ",99]
[3,"كامل عوض",171]
[4,"تامر خميس ",200]
[5,"حسام جعفر ",204]
[6,"صلاح الدين كمال",256]
[7,"ايمن عبدالمعز",308]
[8,"مجدي عبدالعظيم",325]
[9,"مرعى مراد ",330]
[10,"علام احمد",412]
[11,"عبد المحسن مراد",651]
[12,"حسن محمد",657]
[13,"محمد محمد ",712]
[14,"محمد ثروت ",770]
[15,"محمد الصاوى",931]
[16,"احمد محمد",1168]
[17,"ابراهيم عاشور",1327]
[18,"احمد ابراهيم ",1418]
[19,"محمد خلاف",1421]
[20,"إبراهيم أحمد ",1423]
[21,"خليل عبد الوارث",1427]
[22,"الشناوي سالمان",1531]
[23,"حسن محمود ",1574]
[24,"احمد محمود ",1689]
[25,"بلال محمد ",1826]
[26," عبدالخالق النجار",1853]
[27,"زكى اسماعيل",1854]
[28," محمود قبلان",2327]
[29," جابر احمد",2645]
[30,"احمد محمد ابراهيم ",3011]
[31,"هانى عبد الهادى",3125]
[32,"محمود حسن ",3139]
[33,"شعبان عبد الله",3244]
[34,"أحمد مصطفى",3333]
[35," على سليم",3369]
[36,"عبد الرحيم عبد المولى",3392]
[37,"معتز محمد",3643]
[38,"محسن جلال",3699]
[]
[]
[]
[]
["اجمالى الحضور",null,null,null,{"$f":"COUNTIF(E4:E45,\"1\")","v":0},{"$f":"COUNTIF(F4:F45,\"1\")","v":0},0]
["اجمالى الماموريه",null,null,null,{"$f":"COUNTIF(E4:E41,\"م\")","v":0},{"$f":"COUNTIF(F4:F41,\"م\")","v":0},0]
["اجمالى الاجازات",null,null,null,{"$f":"COUNTIF(E4:E41,0)","v":0},{"$f":"COUNTIF(F4:F41,0)","v":0},0]
["اجمالى الغياب",null,null,null,{"$f":"COUNTIF(E4:E41,\"غ\")","v":0},{"$f":"COUNTIF(F4:F41,\"غ\")","v":0},0]
["الاجمالى",null,null,null,{"$f":"E46+E47+E48+E49","v":0},{"$f":"F46+F47+F48+F49","v":0},0]