{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["امر الشغل","البيانات الرئيسية"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,2,5],[10,6,11,6],[10,8,11,8],[10,15,11,15],[10,11,11,11],[10,12,11,12],[10,13,11,13],[10,14,11,14],[3,2,8,12],[10,10,11,10],[10,9,11,9],[10,2,10,5]]}
[]
[null,null,"إدارة المشتريات"]
[]
[null,null,"مجال العمل من الخلية  c13 الى الخلية P50 المطلوب عند ادخال اسم السائق الي الخلية C13  وتكون الخلية i13 تحتوي على بيانات يتم تظليل الخلايا من D إلى P بلون ما وإذا تم كتابة بيان في الخلية I14  يتم تظليلها بنفس اللون سواء تم كتابة اسم نفس السائق في العمود C او  لا ويستمر التظليل بنفس اللون كلما تم كتابة بيان في العمود i  سواء C فارغة أو بنفس الاسم  .... وبمجرد كتابة اسم سائق جديد يتم تظليل خلايا من D:p  بلون مختلف بنفس الشروط السابقة وهكذا "]
[]
[]
[]
[]
[]
[]
[null,null,"بيانات",null,null,null,"م","رقم الاسالية","الكود","الصنف"]
[null,null,"السائق","رقم السائق",null,null,null,"Item No."]
[null,null,"أحمد",4,null,null,{"$f":"IF(NOT(ISBLANK(I13)),COUNTA(I13:I$13),\"\")","v":1},null,"4545","كارتون"]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I14)),COUNTA(I$13:I14),\"\")","v":2},null,"332","كاوتش"]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I15)),COUNTA(I$13:I15),\"\")","v":3},null,"1013","زجاج"]
[null,null,"خالد",null,null,null,{"$f":"IF(NOT(ISBLANK(I16)),COUNTA(I$13:I16),\"\")","v":4},null,"1520","علب"]
[null,null,"خالد",null,null,null,{"$f":"IF(NOT(ISBLANK(I17)),COUNTA(I$13:I17),\"\")","v":5},null,"111","تمور"]
[null,null,"خالد",null,null,null,null,null,"147","فاكهة"]
[null,null,"ياسر",null,null,null,null,null,"159","خشب"]
[null,null,"حسين",null,null,null,null,null,"143","سمك"]
[null,null,"حسين",null,null,null,null,null,"157","تونة"]
[null,null,"حسين",null,null,null,{"$f":"IF(NOT(ISBLANK(I22)),COUNTA(I$13:I22),\"\")","v":10},null,"144","سلمون"]
[null,null,"حسين",null,null,null,{"$f":"IF(NOT(ISBLANK(I23)),COUNTA(I$13:I23),\"\")","v":11},null,"122","أجبان"]
[null,null,"حسين",null,null,null,{"$f":"IF(NOT(ISBLANK(I24)),COUNTA(I$13:I24),\"\")","v":12},null,"111","تمور"]
[null,null,"ماجد",null,null,null,{"$f":"IF(NOT(ISBLANK(I25)),COUNTA(I$13:I25),\"\")","v":13},null,"1458","فواكهة"]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I26)),COUNTA(I$13:I26),\"\")","v":14},null,"147666","خضروات"]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I27)),COUNTA(I$13:I27),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I28)),COUNTA(I$13:I28),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I29)),COUNTA(I$13:I29),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I30)),COUNTA(I$13:I30),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I31)),COUNTA(I$13:I31),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I32)),COUNTA(I$13:I32),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I33)),COUNTA(I$13:I33),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I34)),COUNTA(I$13:I34),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I35)),COUNTA(I$13:I35),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I36)),COUNTA(I$13:I36),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(I37)),COUNTA(I$13:I37),\"\")","v":""}]

{"sheet":"البيانات الرئيسية","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"بيانات أمر الشراء الرئيسية"]
[]
[null,"رقم التشغيلة",null,"batch no."]
[null,"التاريخ",null,"date"]
[null,"المنتج",null,"product"]
[null,"رقم المنتج",null,"item no."]
[null,"الكمية",null,"quantity"]
[null,"المواصفات",null,"specs."]