{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["الرئسية","ابراهيم","محمود","صلاح","محمد","ربيع"],"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":"الرئسية","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ابراهيم","index":1,"n_rows":313,"n_cols":9,"rows_kept":313,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["الاسم","إبراهيم"]
["محمد"]
["الإجمالي",{"$f":"SUM(I10:I30)","v":540},null,{"$f":"TODAY()","v":"2019-03-19"}]
["السحب"]
[{"$f":"IF(B5>=3,\"الباقي الي\",IF(B5<=-1,\"الباقي علي\"\"\"))","v":"الباقي الي"},{"$f":"B3-B4","v":540}]
[]
[null,null,null,"اريد كود يقوم بهذا العمل--- حساب ساعات العمل -- بحيث ان يتم محاسبة العميل   من خلال ساعات العمل"]
[]
[null,"ملحوظة","حضور","التاريخ","وقت البدء","وقت الانتهاء","مجموع الوقت","سعر الساعة","القيمة"]
[null,null,"ابراهيم","2019-02-23","8ص","8م",12,10,120]
[null,null,"ابراهيم","2019-02-24","9ص","9م",12,10,120]
[null,null,"غياب","2019-02-25","10م","8م",10,10,100]
[null,null,"ابراهيم","2019-02-26","11ص","10م",11,10,110]
[null,null,"غياب","2019-02-27","12ص","9م",9,10,90]
[null,null,"ابراهيم","2019-02-28","09:04:58","8م",null,10]
[null,null,"غياب","2019-03-02","08:48:21","8م",null,10]
[null,null,"ابراهيم","2019-03-03","10:37:40","9م",null,10]
[null,null,"غياب","2019-03-04","11:17:58","10م",null,10]
[null,null,"غياب","2019-03-04","08:55:25","11م",null,10]
[null,null,"ابراهيم","2019-03-06","07:21:52","750م",null,10]
[null,null,"غياب","2019-03-07","05:39:25","850م",null,10]
[null,null,"ابراهيم","2019-03-09","15:59:03","950م",null,10]
[null,null,"ابراهيم","2019-03-10","11:43:31","1050م",null,10]
[null,null,"غياب","2019-03-11","09:24:01","11م",null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5,"2019-02-02"]

{"sheet":"محمود","index":2,"n_rows":313,"n_cols":8,"rows_kept":313,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["الاسم","محمود",null,null,null,null,"الاسم"]
["محمد",null,null,null,null,null,"الإجمالي"]
["الإجمالي",600,null,null,null,null,"السحب"]
["السحب",{"$f":"SUM(F:F)","v":600},null,null,null,null,"الباقي"]
[{"$f":"IF(B5>=3,\"الباقي الي\",IF(B5<=-1,\"الباقي علي\"\"\"))","v":false},{"$f":"B3-B4","v":0}]
[]
[]
[]
[null,"ملحوظة","حضور","التاريخ","الوقت","السحب",null," "]
[null,null,"محمود","2019-02-23","14:31:20",300,null,100]
[null,null,"غياب","2019-02-24","18:42:55",null,null,"غياب"]
[null,null,"غياب","2019-02-25","18:36:31",null,null,"غياب"]
[null,null,"غياب","2019-02-26","10:43:41",null,null,"غياب"]
[null,null,"غياب","2019-02-28","21:05:05",null,null,"غياب"]
[null,null,"محمود","2019-03-12","10:37:56",null,null,100]
[null,null,"محمود","2019-03-13","19:10:02",null,null,100]
[null,null,"محمود","2019-03-14","11:20:34",300,null,100]
[null,null,"محمود","2019-03-16","10:46:01",null,null,100]
[null,null,"محمود","2019-03-17","10:48:18",null,null,100]
[null,null,"غياب","2019-03-18","10:49:00",null,null,"غياب"]
[null,null,"محمود","2019-03-19","12:02:15",null,null,100]
[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,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,5,"2019-02-02"]

{"sheet":"صلاح","index":3,"n_rows":313,"n_cols":8,"rows_kept":313,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["الاسم","صلاح",null,null,null,null,"الاسم"]
["محمد",null,null,null,null,null,"الإجمالي"]
["الإجمالي",300,null,null,null,null,"السحب"]
["السحب",{"$f":"SUM(F:F)","v":500},null,null,null,null,"الباقي"]
[{"$f":"IF(B5>=3,\"الباقي الي\",IF(B5<=-1,\"الباقي علي\"\"\"))","v":"الباقي علي\""},{"$f":"B3-B4","v":-200}]
[]
[]
[]
[null,"ملحوظة","حضور","التاريخ","الوقت","السحب",null," "]
[null,null,"صلاح","2019-03-07","17:39:06",500,null,75]
[null,null,"صلاح","2019-03-07","17:39:09",null,null,75]
[null,null,"صلاح","2019-03-18","10:19:15",null,null,75]
[null,null,"صلاح","2019-03-19","10:43:22",null,null,75]
[]
[]
[]
[]
[]
[]
[]
[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,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,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5,"2019-02-02"]

{"sheet":"محمد","index":4,"n_rows":313,"n_cols":8,"rows_kept":313,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["الاسم","محمد",null,null,null,null,"الاسم"]
["محمد",null,null,null,null,null,"الإجمالي"]
["الإجمالي",250,null,null,null,null,"السحب"]
["السحب",{"$f":"SUM(F:F)","v":100},null,null,null,null,"الباقي"]
[{"$f":"IF(B5>=3,\"الباقي الي\",IF(B5<=-1,\"الباقي علي\"\"\"))","v":"الباقي الي"},{"$f":"B3-B4","v":150}]
[]
[]
[]
[null,"ملحوظة","حضور","التاريخ","الوقت","السحب",null," "]
[null,null,"محمد","2019-02-23","14:31:29",null,null,25]
[null,null,"غياب","2019-02-24","18:43:28",null,null,"غياب"]
[null,null,"محمد","2019-02-26","10:43:08",null,null,25]
[null,null,"محمد","2019-02-27","09:35:27",null,null,25]
[null,null,"محمد","2019-03-02","20:48:04",100,null,25]
[null,null,"محمد","2019-03-03","09:37:35",null,null,25]
[null,null,"غياب","2019-03-07","17:38:42",null,null,"غياب"]
[null,null,"محمد","2019-03-09","15:58:15",null,null,25]
[null,null,"محمد","2019-03-10","11:44:09",null,null,25]
[null,null,"محمد","2019-03-11","09:24:09",null,null,25]
[null,null,"محمد","2019-03-12","09:56:13",null,null,25]
[null,null,"محمد","2019-03-13","19:10:44",null,null,25]
[null,null,"محمد","2019-03-14","11:20:46",null,null,25]
[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,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5,"2019-02-02"]

{"sheet":"ربيع","index":5,"n_rows":313,"n_cols":8,"rows_kept":313,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["الاسم","ربيع",null,null,null,null,"الاسم"]
["محمد",null,null,null,null,null,"الإجمالي"]
["الإجمالي",420,null,null,null,null,"السحب"]
["السحب",{"$f":"SUM(F:F)","v":380},null,null,null,null,"الباقي"]
[{"$f":"IF(B5>=3,\"الباقي الي\",IF(B5<=-1,\"الباقي علي\"\"\"))","v":"الباقي الي"},{"$f":"B3-B4","v":40}]
[]
[]
[]
[null,"ملحوظة","حضور","التاريخ","الوقت","السحب",null," "]
[null,null,"ربيع","2019-02-25","18:36:57",null,null,60]
[null,null,"غياب","2019-02-26","10:43:27",null,null,"غياب"]
[null,null,"ربيع","2019-02-27","09:35:07",null,null,60]
[null,null,"ربيع","2019-02-28","21:04:48",180,null,60]
[null,null,"ربيع","2019-03-02","20:47:55",null,null,60]
[null,null,"غياب","2019-03-03","09:37:59",null,null,"غياب"]
[null,null,"ربيع","2019-03-04","20:55:17",null,null,60]
[null,null,"ربيع","2019-03-06","19:21:41",null,null,60]
[null,null,"غياب","2019-03-07","17:38:13",200,null,"غياب"]
[null,null,"غياب","2019-03-09","15:58:40",null,null,"غياب"]
[null,null,"ربيع","2019-03-10","11:43:52",null,null,60]
[null,null,"غياب","2019-03-11","09:23:40",null,null,"غياب"]
[null,null,"غياب","2019-03-12","09:56:37",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,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,5,"2019-02-02"]