{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Supply Request"],"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":"Supply Request","index":0,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,11,12,11],[36,6,36,8],[0,1,2,3],[7,1,7,2],[8,1,8,2],[3,1,5,8],[11,5,11,6],[11,1,12,1],[11,3,12,3],[11,2,12,2],[11,4,12,4],[9,5,9,8],[8,5,8,8],[10,5,10,8],[9,1,9,2],[10,1,10,2],[46,4,46,8],[11,7,12,7],[11,8,12,8],[42,1,42,8],[44,1,44,8],[40,1,40,8],[41,1,41,8],[39,1,39,3],[39,4,39,7],[37,1,37,3],[38,1,38,3],[36,1,36,3],[38,6,38,8]]}
[{"$f":"IF(E1=\"\",\"\",ROW()-3)","v":""}]
[]
[]
[null,"أمــــــر تـوريد (   إبتدائي      - إضافة      - تعديل      - إلغاء      )"]
[]
[]
[null,"    التــــــاريــــــــــــــــــــــــــــــــــــــــــــــخ :           ",null,null,null,"رقم أمر التوريد","رقم طلبية\n المندوب","كود المندوب"]
[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,"سعر اللسته","السعر \nقطعى - الخصم",null,null,"نسبة الخصم",null,null,"محمد احمد محمد",null,"الدفع مع المسئول بالمصنع"]
[null,null,null,null,null,"م / ق","كرتونه",null,null,null,null,null,null,null,"ماجد صبحى هرمينا",null,"تم دفع مبلغ (                 ) والباقى نقدى مع السيارة"]
[null,{"$f":"IF(D14=\"\",\"\",ROW()-13)","v":""},null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C14,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C14,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C14,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F14*H14)-(F14*H14)*#REF!,\"\")","v":""},null,null,null,null,null,"محمد مخلص"]
[null,{"$f":"IF(D15=\"\",\"\",ROW()-13)","v":""},null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C15,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C15,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C15,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F15*H15)-(F15*H15)*#REF!,\"\")","v":""},null,null,null,null,null,"ياسر محمود شرف"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C16,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C16,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C16,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F16*H16)-(F16*H16)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد محمد على الشوربجى"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C17,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C17,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C17,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F17*H17)-(F17*H17)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد بدر الدين محمود"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C18,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C18,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C18,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F18*H18)-(F18*H18)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد سعيد زكى"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C19,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C19,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C19,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F19*H19)-(F19*H19)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد محمد احمد سالم"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C20,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C20,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C20,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F20*H20)-(F20*H20)*#REF!,\"\")","v":""},null,null,null,null,null,"محمد فوزى  فتحى احمد"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C21,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C21,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C21,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F21*H21)-(F21*H21)*#REF!,\"\")","v":""},null,null,null,null,null,"إكرامى فتحى حافظ"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C22,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C22,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C22,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F22*H22)-(F22*H22)*#REF!,\"\")","v":""},null,null,null,null,null,"شريف ضاحى غانم"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C23,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C23,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C23,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F23*H23)-(F23*H23)*#REF!,\"\")","v":""},null,null,null,null,null,"محمد عبدالستار"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C24,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C24,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C24,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F24*H24)-(F24*H24)*#REF!,\"\")","v":""},null,null,null,null,null,"علاء حسين عبدالعزيز"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C25,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C25,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C25,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F25*H25)-(F25*H25)*#REF!,\"\")","v":""},null,null,null,null,null,"محمد سمير محمد عبدالقوى"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C26,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C26,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C26,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F26*H26)-(F26*H26)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد مصطفى عبدالله"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C27,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C27,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C27,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F27*H27)-(F27*H27)*#REF!,\"\")","v":""},null,null,null,null,null,"اسامة ابو الخير صادق"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C28,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C28,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C28,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F28*H28)-(F28*H28)*#REF!,\"\")","v":""},null,null,null,null,null,"محمود عبدالمحسن"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C29,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C29,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C29,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F29*H29)-(F29*H29)*#REF!,\"\")","v":""},null,null,null,null,null,"كريم على زغلول"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C30,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C30,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C30,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F30*H30)-(F30*H30)*#REF!,\"\")","v":""},null,null,null,null,null,"عبدالحفيظ خلاف"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C31,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C31,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C31,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F31*H31)-(F31*H31)*#REF!,\"\")","v":""},null,null,null,null,null,"هيثم صلاح رشدى"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C32,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C32,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C32,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F32*H32)-(F32*H32)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد مبروك عبدالرؤوف"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C33,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C33,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C33,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F33*H33)-(F33*H33)*#REF!,\"\")","v":""},null,null,null,null,null,"احمد محمد اسماعيل"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C34,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C34,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C34,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F34*H34)-(F34*H34)*#REF!,\"\")","v":""},null,null,null,null,null,"محمود راشد ابراهيم"]
[null,"",null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C35,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(D$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($C35,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(E$12,#REF!,0)),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($C35,INDEX(#REF!,,MATCH($C$12,#REF!,0)),0),MATCH(H$12,#REF!,0)),\"\")","v":""},{"$f":"IFERROR((F35*H35)-(F35*H35)*#REF!,\"\")","v":""},null,null,null,null,null,"محمد سيد طه عثمان"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد سيد ابو الوفا"]
[null,null,null,null,"          الإجمالى بعد ضريبة القيمة المضافة ( 14 % ) /",null,{"$f":"SUBTOTAL(9,I14:I35)","v":0},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,{"$f":"G37","v":0},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,null,null,"محمد عاطف عبدالفتح"]
[null,"                .......................................................................................................................................................................................................................................................................................................................................................................................                                                     "]