{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ابراهيم سعيد","احمد علي","Repport"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,8,18,10],[19,3,19,4],[19,6,19,7],[19,8,19,10],[0,4,0,6],[1,4,1,6],[7,2,7,3],[7,4,7,5],[18,2,19,2],[18,6,18,7]]}
[null,null,null,null,"بيان راتب شهر نوفمبر    2019"]
[null,null,null,null,"أ. ابراهيم سعيد "]
[]
[null,null,"ساعة الحضور ","10:00:00","ساعة الانصراف","18:00:00","البيان","الايام ","القيمة"]
[null,null,"أجر الساعة:",{"$f":"D9/208","v":4.8076923076923075},"مدة السماح:","01:00:00","جزاء",0,{"$f":"H5*D9/30","v":0}]
[null,null,"الأضافي",1,"التأخير ",{"$f":"D5*1","v":4.8076923076923075},"غياب بأذن",0,{"$f":"H6*D9/30","v":0}]
[null,null,null,null,null,null,"غياب بدون اذن",0,{"$f":"H7*D9/25","v":0}]
[null,null,"المستحقات ",null,"الاستقطاعات ",null,"خصم تأخير ",0,{"$f":"H8*D9/30","v":0}]
[null,null,"الراتب ",1000,"تأمينات",0]
[null,null,"الاضافي ",{"$f":"I56","v":0},"سلف",0,"OT اجمالي",{"$f":"G56","v":"00:00:00"},null,null,4378.93]
[null,null,"البدلات ",0,"عهد ",0,"(OV) اجمالي",{"$f":"E56+F56","v":"00:00:00"},null,null,{"$f":"K10*10/100","v":437.89300000000003}]
[null,null,null,null,"جزاء",{"$f":"I5","v":0},"الصافي ساعه",{"$f":"H10-H11","v":"00:00:00"}]
[null,null,null,null,"غياب بأذن",{"$f":"I6","v":0},"صافي قيمة ",{"$f":"I56-H56","v":0}]
[null,null,null,null,"غياب بدون اذن",{"$f":"I7","v":0}]
[null,null,null,null,"خصم تأخير ",{"$f":"I8","v":0}]
[null,null,null,null,"قيمة ساعات التأخير",{"$f":"H56","v":0}]
[null,null,null,null,"تليفون ","Tel1"]
[null,null,"Total",{"$f":"SUM(D9:D17)","v":1000},"Total",{"$f":"SUM(F9:F17)","v":0}]
[null,null,"صافي الراتب الشهري",null,null,null,"اسم المستلم "]
[null,null,null,{"$f":"D18-F18","v":1000},null,null,"التوقيع "]
[]
[]
[]
[null,"التاريخ","الحضور ","الانصراف","تأخير عن الحضور","مغادرة مبكرة","الساعات الاضافية ","قيمة التأخير ","قمية الاضافي","الصافي","ملاحظات"]
["الأربعاء","2019-12-25","10:00:00","18:00:00",{"$f":"IF((C25-$D$4)<=$F$5,0,C25-$D$4)","v":"00:00:00"},{"$f":"IF(($F$4-D25)<0,0,$F$4-D25)","v":"00:00:00"},{"$f":"IF((D25-$F$4)<0,0,D25-$F$4)","v":"00:00:00"},{"$f":"(E25+F25)*24*$F$6","v":0},{"$f":"G25*24*$D$6*$D$5","v":0},{"$f":"I25-H25","v":0}]
["الخميس","2019-12-26","10:00:00","18:00:00",{"$f":"IF((C26-$D$4)<=$F$5,0,C26-$D$4)","v":"00:00:00"},"00:00:00","00:00:00",{"$f":"(E26+F26)*24*$F$6","v":0},{"$f":"G26*24*$D$6*$D$5","v":0},{"$f":"I26-H26","v":0}]
["الجمعة","2019-12-27","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2019-12-28","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2019-12-29","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2019-12-30","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2019-12-31","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-01","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-02","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-03","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-04","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-05","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-06","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-07","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-08","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-09","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-10","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-11","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-12","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-13","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-14","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-15","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-16","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-17","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-18","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-19","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-20","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-21","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-22","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-23","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-24","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
[null,null,null,null,{"$f":"SUM(E25:E55)","v":"00:00:00"},"00:00:00","00:00:00",0,0,0]

{"sheet":"احمد علي","index":1,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,8,18,10],[19,3,19,4],[19,6,19,7],[19,8,19,10],[0,4,0,6],[1,4,1,6],[7,2,7,3],[7,4,7,5],[18,2,19,2],[18,6,18,7]]}
[null,null,null,null,"بيان راتب شهر نوفمبر    2019"]
[null,null,null,null,"أ. احمد على "]
[]
[null,null,"ساعة الحضور ","10:00:00","ساعة الانصراف","18:00:00","البيان","الايام ","القيمة"]
[null,null,"أجر الساعة:",{"$f":"D9/208","v":9.615384615384615},"مدة السماح:","01:00:00","جزاء",0,{"$f":"H5*D9/30","v":0}]
[null,null,"الأضافي",1,"التأخير ",{"$f":"D5*1","v":9.615384615384615},"غياب بأذن",0,{"$f":"H6*D9/30","v":0}]
[null,null,null,null,null,null,"غياب بدون اذن",0,{"$f":"H7*D9/25","v":0}]
[null,null,"المستحقات ",null,"الاستقطاعات ",null,"خصم تأخير ",0,{"$f":"H8*D9/30","v":0}]
[null,null,"الراتب ",2000,"تأمينات",0]
[null,null,"الاضافي ",{"$f":"I56","v":0},"سلف",0,"OT اجمالي",{"$f":"G56","v":"00:00:00"}]
[null,null,"البدلات ",0,"عهد ",0,"(OV) اجمالي",{"$f":"E56+F56","v":"00:00:00"}]
[null,null,null,null,"جزاء",{"$f":"I5","v":0},"الصافي ساعه",{"$f":"H10-H11","v":"00:00:00"}]
[null,null,null,null,"غياب بأذن",{"$f":"I6","v":0},"صافي قيمة ",{"$f":"I56-H56","v":0}]
[null,null,null,null,"غياب بدون اذن",{"$f":"I7","v":0}]
[null,null,null,null,"خصم تأخير ",{"$f":"I8","v":0}]
[null,null,null,null,"قيمة ساعات التأخير",{"$f":"H56","v":0}]
[null,null,null,null,"تليفون ","Tel2"]
[null,null,"Total",{"$f":"SUM(D9:D17)","v":2000},"Total",{"$f":"SUM(F9:F17)","v":0}]
[null,null,"صافي الراتب الشهري",null,null,null,"اسم المستلم "]
[null,null,null,{"$f":"D18-F18","v":2000},null,null,"التوقيع "]
[]
[]
[]
[null,"التاريخ","الحضور ","الانصراف","تأخير عن الحضور","مغادرة مبكرة","الساعات الاضافية ","قيمة التأخير ","قمية الاضافي","الصافي","ملاحظات"]
["الأربعاء","2019-12-25","10:00:00","18:00:00",{"$f":"IF((C25-$D$4)<=$F$5,0,C25-$D$4)","v":"00:00:00"},{"$f":"IF(($F$4-D25)<0,0,$F$4-D25)","v":"00:00:00"},{"$f":"IF((D25-$F$4)<0,0,D25-$F$4)","v":"00:00:00"},{"$f":"(E25+F25)*24*$F$6","v":0},{"$f":"G25*24*$D$6*$D$5","v":0},{"$f":"I25-H25","v":0}]
["الخميس","2019-12-26","10:00:00","18:00:00",{"$f":"IF((C26-$D$4)<=$F$5,0,C26-$D$4)","v":"00:00:00"},"00:00:00","00:00:00",{"$f":"(E26+F26)*24*$F$6","v":0},{"$f":"G26*24*$D$6*$D$5","v":0},{"$f":"I26-H26","v":0}]
["الجمعة","2019-12-27","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2019-12-28","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2019-12-29","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2019-12-30","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2019-12-31","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-01","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-02","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-03","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-04","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-05","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-06","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-07","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-08","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-09","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-10","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-11","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-12","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-13","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-14","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-15","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-16","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-17","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["السبت","2020-01-18","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأحد","2020-01-19","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الإثنين","2020-01-20","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الثلاثاء","2020-01-21","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الأربعاء","2020-01-22","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الخميس","2020-01-23","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
["الجمعة","2020-01-24","10:00:00","18:00:00","00:00:00","00:00:00","00:00:00",0,0,0]
[null,null,null,null,{"$f":"SUM(E25:E55)","v":"00:00:00"},"00:00:00","00:00:00",0,0,0]

{"sheet":"Repport","index":2,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[[16,10,16,15]]}
[null,"رواتب العاملين عن شهر 11/2019"]
[]
["عدد","الاسم","الراتب ","البدلات ","التأمينات ","ساعات التأخير ","قيمة الاضافي","الساعات الاضافية","جزاء","غياب بأذن","غياب بدون اذن","خصم التأخير ","السلف","العهد","تليفون","الصافي"]
[1,"أ. ابراهيم سعيد ",1000,0,0,4.8076923076923075,0,1,0,0,0,0,0,0,"Tel1",1000]
[2,"أ. احمد على ",2000,0,0,9.615384615384615,0,1,0,0,0,0,0,0,"Tel2",2000]
[null,"المجموع",3000,0,0,14.423076923076923,0,2,0,0,0,0,0,0,null,3000]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"م"]