{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["data","search"],"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":"data","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,8,1,9]]}
[]
["casID","Name","start date","start time","end date","end time","Customer lot number",null,"ملاحظات"]
[1001,"Rhea Madsen","2022-07-01","07:45:00","2022-07-03","08:30:00",1,null,1,"البيانات عادتنا متداخله والترتيب هنا للتوضيح فقط"]
[1001,"Rhea Madsen","2022-07-03","08:30:00","2022-07-05","08:00:00",2,null,2,"كل نهاية تشغيلة للعميل هى نفسها بداية التشغيلة التالية لنفس العمل"]
[1001,"Rhea Madsen","2022-07-05","08:00:00","2022-07-06","16:00:00",3,null,3,"كل عميل له مسلسل تشغيل مستقل"]
[1001,"Rhea Madsen","2022-07-06","16:00:00","2022-07-09","10:00:00",4,null,4,"الجدول قابل للتمدد لمئات العملاء والاف التشغيلات"]
[1005,"John Brown","2020-07-01","08:00:00","2022-07-02","09:00:00",1,null,null,"Notes"]
[1005,"John Brown","2022-07-02","09:00:00","2022-07-02","11:00:00",2,null,1,"Each end of a batch for the customer is the same as the beginning of the next batch for the same work"]
[1005,"John Brown","2022-07-02","11:00:00","2022-07-04","14:00:00",3]
[1005,"John Brown","2022-07-04","14:00:00","2022-07-07","09:00:00",4,null,2,"Each customer has an independent running sequence"]
[1005,"John Brown","2022-07-07","09:00:00","2022-07-08","08:00:00",5]
[1003,"Brett Broyles","2020-07-02","07:45:51","2022-07-03","07:00:00",1,null,3,"The table can be extended to hundreds of customers and thousands of operations"]
[1003,"Brett Broyles","2022-07-03","07:00:00","2022-07-05","04:00:00",2]
[1003,"Brett Broyles","2022-07-05","04:00:00","2022-07-07","13:00:00",3,null,4,"Our data is usually overlapping and the order here is for illustration only"]
[1005,"John Brown","2022-07-08","08:00:00","2022-07-12","05:00:00",6]
[1005,"John Brown","2022-07-12","05:00:00","2022-07-15","04:00:00",7]
[1003,"Brett Broyles","2022-07-07","13:00:00","2022-07-09","13:00:00",4]
[]
[]
[]
[]
[1005,"John Brown","2022-07-12","05:00:00","2022-07-15","04:00:00",7]

{"sheet":"search","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,0,20,3],[20,4,23,4],[5,0,5,3],[1,0,1,3],[5,4,8,4],[13,0,13,3],[13,4,16,4]]}
[null,null,null,null,null,null,"The possibilities to be searched for"]
["search terms",null,null,null,null,null,"الاحتمالات المطلوب البحث على اساسها"]
["casID","Name","Date","time"]
[1003,null,"2022-07-08","09:01:00",null,null,"المطلوب عمل كود VBA لزر البحث الموجود ويقوم بالاحتمالات الاتية"]
[null,null,null,null,null,null,"It is required to make a VBA code for the existing search button and it does the following possibilities:"]
["search result",null,null,null,"first case",null,"الحالة الاولى - ان يكون التاريخ والوقت يقع داخل نطاق البحث وفى هذه الحاله يتم "]
[null,null,null,null,null,null,"ارجاع رقم التشغيلة من البيانات و يتم كتابة داخل نطاق البحث"]
["casID","Customer operating number","status",null,null,null,"The first case - that the date and time fall within the scope of the search, and in this case it is done"]
[1003,4,"search scope",null,null,null,"Return the batch number from the data and it is written within the search scope"]
[]
[]
[]
[]
["search result",null,null,null,"The second case",null,"الحالة الثانية - ان يكون التاريخ سابق للتواريخ المسجله وفى هذه الحاله يتم كتابة "]
[null,null,null,null,null,null,"التاريخ قديم"]
["casID","Customer operating number","status",null,null,null,"The second case - if the date is earlier than the dates recorded in this case, it is written"]
[]
[]
[]
[]
["search result",null,null,null,"The third case",null,"الحالة الثالثة - ان يكون التاريخ حديث لكن غير مسجل فى قاعدة البيانات وفى هذه "]
[null,null,null,null,null,null,"الحاله يتم ارجاع اكبر رقم تشغيله لهذا العميل +1 وكتابة ادخال جديد"]
["casID","Customer operating number","status",null,null,null,"The third case - the date should be recent but not registered in the database"]
[null,null,null,null,null,null,"In the case, the largest operating number for this customer is returned +1 and a new entry is written"]
[]
[]
[]
[]
[null,null,null,null,null,null,"ملحوظه قاعدة البيانات (DATA)قابله لاضافة صفوف قد تصل 50000 صف من العمليات اوكثر"]
[]
[]
[null,null,null,null,null,null,"Note: The database (DATA) is capable of adding rows that may reach 50,000 rows of operations or more"]