{"text_format":"1","workbook":"xlsx","n_sheets":3,"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":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["رقم طلب الشراء","رقم ح المشترى","اسم المشترى","رقم المنتج","اسم المنتج","نوع الطلب","كميه الطلب","وحدة الوزن","رقم مخزن البيع"]
[1,1000,"احمد",10,"تتت","شحن لمخزن عميل",10000,"كيلو",20000]
[1,1000,"احمد",20,"تللل","شحن لمخزن عميل",20000,"لتر",20000]
[1,1000,"احمد",30,"نمن","شحن لمخزن عميل",3000,"طن",20000]
[2,2000,"محمد",10,"تتت","شحن لمقر العميل مباشر",10000,"كيلو",10000]
[2,2000,"محمد",20,"تللل","شحن لمقر العميل مباشر",20000,"لتر",10000]
[2,2000,"محمد",30,"نمن","شحن لمقر العميل مباشر",3000,"طن",10000]
[3,3000,"على",10,"تتت","شحن لمخزن تابع لنا",10000,"كيلو",60000]
[3,3000,"على ",20,"تللل","شحن لمخزن تابع لنا",20000,"لتر",60000]
[3,8000,"احمد",30,"نمن","شحن لمخزن تابع لنا",6000,"لتر",60000]
[4,4000,"اشرف",10,"سيس","شحن لمخزن عميل",500000,"كيلو",100]
[5,5000,"شريف",10,"فقل","شحن لمخزن عميل",6000,"لتر",200]
[6,6000,"ادهم",10,"ثقفثق","شحن لمخزن تابع لنا",6000,"طن",300]
[7,7000,"محمد",10,"تتت","شحن لمخزن عميل",10000,"كيلو",40000]
[7,7000,"محمد",20,"تللل","شحن لمخزن عميل",20000,"لتر",40000]
[7,7000,"محمد",30,"نمن","شحن لمخزن عميل",3000,"طن",40000]
[7,7000,"محمد",40,"ثقفثق","شحن لمخزن عميل",40000,"كيلو",40000]
[8,7000,"مهند",30,"غغ","شحن لمقر العميل مباشر",6000,"لتر",50000]
[8,8000,"احمد",20,"تللل","شحن لمقر العميل مباشر",20000,"طن",50000]
[8,8000,"احمد",30,"نمن","شحن لمقر العميل مباشر",3000,"كيلو",50000]
[8,8000,"احمد",40,"ثقفثق","شحن لمقر العميل مباشر",40000,"لتر",50000]

{"sheet":"المنفذ","index":1,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","حالة الفاتورة","نوع الفاتورة","نوع المنتج","رقم ح المشترى","اسم المشترى","رقم مخزن الصرف","رقم المنتج","اسم المنتج","كميه الفاتورة","وحدة الوزن","نوع الطلب","رقم مخزن المشترى","رقم الطلب","كمية الطلب","رقم مستند الاستلام","رقم المخزن الرئيسى","رقم موقع التوصيل للعميل"]
[15,"تم التسليم","بيع","سائل صب",1000,"احمد",50,"تتت",null,20,"كيلو","بيع",50,1,10000,60,25,2]
[15,"تحت التجهيز","بيع","عدد",1000,"احمد",50,"تللل",null,12,"لتر","تحويل لمخزن عميل",60,1,20000,60,26,2]
[15,"تحت التجهيز","بيع","مجمد",1000,"احمد",50,"نمن",null,14,"طن","تحويل مخزن خاص",70,1,3000,70,24,2]
[15,"تم الاستلام","مرتجع",null,1000,"احمد",12,"تتت",null,16,"كيلو",null,80,1,4000,70,24,2]
[15,"بالطريق","مرتجع",null,1000,"احمد",12,"تللل",null,18,"لتر",null,90,1,500,70,23,2]
[16,"تحت التجهيز","تحويل مخزنى",null,2000,"محمد",null,"نمن",null,20,"طن",null,100,2,10000,60,23,2]
[16,"تم الاستلام","تحويل مخزنى",null,2000,"محمد",null,"تتت",null,35,"كيلو",null,110,2,20000,60,22,2]
[16,"بالطريق","تحويل مخزنى",null,2000,"محمد",null,"تللل",null,65,"لتر",null,120,2,3000,60,22,2]
[17,null,"بيع",null,3000,"على",null,"نمن",null,75,"طن",null,130,2,4000,60,12,2]
[17,null,"بيع",null,3000,"على ",null,"سيس",null,95,"كيلو",null,140,2,500,60,21,2]
[17,null,"بيع",null,3000,"على ",null,"فقل",null,25,"لتر",null,150,2,7500,60,21,2]
[18,null,"تحويل مخزنى",null,4000,"اشرف",null,"ثقفثق",null,31,"طن",null,160,3,10000,60,20,2]
[19,null,"بيع",null,5000,"شريف",null,"تتت",null,12,"كيلو",null,170,3,20000,60,26,2]
[20,null,"تحويل مخزنى",null,6000,"محمد",null,"تللل",null,17,"لتر",null,180,4,500000,60,19,2]
[20,null,"تحويل مخزنى",null,7000,"محمد",null,30,null,44.653846153846203,"طن",null,190,4,500000,60,19,2]
[20,null,"تحويل مخزنى",null,7000,"محمد",null,30,null,46.252747252747298,"كيلو",null,200,4,500000,60,18,2]
[21,null,"بيع",null,7000,"مهند",null,30,"غغ",47.8516483516484,"لتر","شحن لمقر العميل مباشر",210,5,80,60,18,2]
[21,null,"بيع",null,7000,"احمد",null,30,null,49.450549450549502,"طن",null,220,5,6000,60,17,2]
[21,null,"بيع",null,8000,"احمد",null,30,null,51.049450549450597,"كيلو",null,230,5,6000,60,16,2]
[21,null,"بيع",null,8000,"احمد",null,30,"نمن",52.648351648351699,"لتر","شحن لمخزن تابع لنا",240,5,6000,60,16,2]
[33,null,"بيع",null,1200,"سالم",null,70,null,52.648351648351699,"لتر","شحن لمخزن تابع لنا",800,88,500,44,76,90]
[]
[]
[null,"ملاحظة"]
[null,"سيتم مقارنة الصفوف في صفحة (المطلوب) و (المنفذ) بناء على ما يأتي :"]
[null,"1  (رقم ح المشترى) متطابق في الصفحتين"]
[null,"2  (اسم المشتري) متطابق في الصفحتين"]
[null,"3  (رقم المنتج) متطابق في الصفحتين"]
[null,"4  (اسم المنتج) متطابق في الصفحتين"]
[null,"5  (نكمية الطلب) متطابق في الصفحتين"]
[null,"إذا انطبقت هذه الشروط الخمسة في الشيتين سيتم تسجيل البيانات في صفحة الخلاصة"]
[null,"وبالرجوع إلى الصفحتين أولى والثانية ستجد الاسطر المتطابقة تم تلوينها باللون الأخضر"]
[null,"في صفحة الخلاصة قم بالضغط على زر التنفيذ وانتظر النتيجة"]
[null,"تحياتي"]
[null,null,"أبوعيد من حضرموت اليمن"]

{"sheet":"الخلاصة","index":2,"n_rows":3,"n_cols":27,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,26]]}
["المطلوب",null,null,null,null,null,null,null,null,"المنفذ"]
["رقم طلب الشراء","رقم ح المشترى","اسم المشترى","رقم المنتج","اسم المنتج","نوع الطلب","كميه الطلب","وحدة الوزن","رقم مخزن البيع","رقم الفاتورة","حالة الفاتورة","نوع الفاتورة","نوع المنتج","رقم ح المشترى","اسم المشترى","رقم مخزن الصرف","رقم المنتج","اسم المنتج","كميه الفاتورة","وحدة الوزن","نوع الطلب","رقم مخزن المشترى","رقم الطلب","كمية الطلب","رقم مستند الاستلام","رقم المخزن الرئيسى","رقم موقع التوصيل للعميل"]
[3,8000,"احمد",30,"نمن","شحن لمخزن تابع لنا",6000,"لتر",60000,21,null,"بيع",null,8000,"احمد",null,30,"نمن",52.648351648351699,"لتر","شحن لمخزن تابع لنا",240,5,6000,60,16,2]