{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setting","الوارد","تقريرالوارد"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":0,"comments":1,"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":"Setting","index":0,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["النوع","المشروبات","الساندوتشات","الوجبات",null,null,null,null,null,null,null,"أرقام الترابيزات","أسماء الويتر"]
["المشروبات","حاجة ساقعة","كبدة","طاجن بامية بالضانى",null,null,null,null,null,null,null,1,"محمد سعيد"]
["الساندوتشات","شاى",null,null,null,null,null,null,null,null,null,2,"أحمد مرسى"]
["الوجبات","شاى فتلة",null,null,null,null,null,null,null,null,null,3,"فرج المصرى"]
[null,"قهوة",null,null,null,null,null,null,null,null,null,4,"أشرف عبد الفتاح"]
[null,"نسكافيه",null,null,null,null,null,null,null,null,null,5,"وليد رمضان"]
[null,"ينسون",null,null,null,null,null,null,null,null,null,6,"وائل فراج"]
[null,"حلبة",null,null,null,null,null,null,null,null,null,7,"رضا شرف"]
[null,"شاى بحليب",null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,33]
[]
[null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,66]

{"sheet":"الوارد","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[26,0,26,1],[26,4,26,5],[27,0,27,1],[27,4,27,5],[28,0,28,1],[28,4,28,5],[4,0,4,6],[5,1,5,2],[23,0,23,1],[23,2,23,5],[25,0,25,1],[25,4,25,5]]}
[]
[]
[]
[]
["سند الوارد"]
["التـــاريـخ :",{"$f":"TODAY()","v":"2021-06-20"},null,null,"فاتـــورة ",100001,"NO"]
["مسلسل","رقم الصنف","اسم الصنف","الوحدة","سعر الوحده","الكمية","القيمة"]
["S.r","Item No","Item name",null,"Unit Price","Qty.","Amount"]
[1,1,{"$f":"IFERROR(VLOOKUP(B9,'[1]بيانات الاصناف'!B9:D612,2,FALSE),\"\")","v":"شاي ليبتون"},{"$f":"IFERROR(VLOOKUP(C9,'[1]بيانات الاصناف'!C9:D612,2,FALSE),\"\")","v":"عدد"},{"$f":"IFERROR(VLOOKUP(D9,'[1]بيانات الاصناف'!D9:E612,2,FALSE),\"\")","v":1},9,{"$f":"IF(F9>0,E9*F9,\"\")","v":9}]
[{"$f":"IF(B10<>\"\",A9+1,\"\")","v":2},3,{"$f":"IFERROR(VLOOKUP(B10,'[1]بيانات الاصناف'!B10:D613,2,FALSE),\"\")","v":"حليب ابو قوس"},{"$f":"IFERROR(VLOOKUP(C10,'[1]بيانات الاصناف'!C10:D613,2,FALSE),\"\")","v":"عدد"},{"$f":"IFERROR(VLOOKUP(D10,'[1]بيانات الاصناف'!D10:E613,2,FALSE),\"\")","v":1},2,{"$f":"IF(F10>0,E10*F10,\"\")","v":2}]
[{"$f":"IF(B11<>\"\",A10+1,\"\")","v":3},4,{"$f":"IFERROR(VLOOKUP(B11,'[1]بيانات الاصناف'!B11:D614,2,FALSE),\"\")","v":"شاي زعتر"},{"$f":"IFERROR(VLOOKUP(C11,'[1]بيانات الاصناف'!C11:D614,2,FALSE),\"\")","v":"عدد"},{"$f":"IFERROR(VLOOKUP(D11,'[1]بيانات الاصناف'!D11:E614,2,FALSE),\"\")","v":1},2,{"$f":"IF(F11>0,E11*F11,\"\")","v":2}]
[4,6,{"$f":"IFERROR(VLOOKUP(B12,'[1]بيانات الاصناف'!B12:D615,2,FALSE),\"\")","v":"زعفران"},{"$f":"IFERROR(VLOOKUP(C12,'[1]بيانات الاصناف'!C12:D615,2,FALSE),\"\")","v":"عدد"},{"$f":"IFERROR(VLOOKUP(D12,'[1]بيانات الاصناف'!D12:E615,2,FALSE),\"\")","v":0.5},2,1]
["",null,{"$f":"IFERROR(VLOOKUP(B13,'[1]بيانات الاصناف'!B13:D616,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C13,'[1]بيانات الاصناف'!C13:D616,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D13,'[1]بيانات الاصناف'!D13:E616,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B14,'[1]بيانات الاصناف'!B14:D617,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C14,'[1]بيانات الاصناف'!C14:D617,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D14,'[1]بيانات الاصناف'!D14:E617,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B15,'[1]بيانات الاصناف'!B15:D618,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C15,'[1]بيانات الاصناف'!C15:D618,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D15,'[1]بيانات الاصناف'!D15:E618,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B16,'[1]بيانات الاصناف'!B16:D619,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C16,'[1]بيانات الاصناف'!C16:D619,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D16,'[1]بيانات الاصناف'!D16:E619,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B17,'[1]بيانات الاصناف'!B17:D620,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C17,'[1]بيانات الاصناف'!C17:D620,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D17,'[1]بيانات الاصناف'!D17:E620,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B18,'[1]بيانات الاصناف'!B18:D621,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C18,'[1]بيانات الاصناف'!C18:D621,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D18,'[1]بيانات الاصناف'!D18:E621,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B19,'[1]بيانات الاصناف'!B19:D622,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C19,'[1]بيانات الاصناف'!C19:D622,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D19,'[1]بيانات الاصناف'!D19:E622,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B20,'[1]بيانات الاصناف'!B20:D623,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C20,'[1]بيانات الاصناف'!C20:D623,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D20,'[1]بيانات الاصناف'!D20:E623,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B21,'[1]بيانات الاصناف'!B21:D624,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C21,'[1]بيانات الاصناف'!C21:D624,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D21,'[1]بيانات الاصناف'!D21:E624,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B22<>\"\",A21+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B22,'[1]بيانات الاصناف'!B22:D625,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,'[1]بيانات الاصناف'!C22:D625,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D22,'[1]بيانات الاصناف'!D22:E625,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B23<>\"\",#REF!+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B23,'[1]بيانات الاصناف'!B23:D626,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,'[1]بيانات الاصناف'!C23:D626,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D23,'[1]بيانات الاصناف'!D23:E626,2,FALSE),\"\")","v":""},null,""]
["إجمالى القيمة",null,{"$f":"NoToTxt(G24,\"درهم\",\"فلس\")","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(G9:G23)","v":14}]
[]
["امين المستودع",null,null,null,"رئيس القسم"]
[4333,null,null,null,6666]
[{"$f":"IFERROR(VLOOKUP(A27,'[2]بيانات الموظف'!B9:G1000,2),\"\")","v":"عامل"},null,null,null,{"$f":"IFERROR(VLOOKUP(E27,'[2]بيانات الموظف'!B9:G1000,2),\"\")","v":"مدير"}]
[{"$f":"IFERROR(VLOOKUP(A27,'[2]بيانات الموظف'!B9:G1000,3),\"\")","v":"غابا"},null,null,null,{"$f":"IFERROR(VLOOKUP(E27,'[2]بيانات الموظف'!B9:G1001,3),\"\")","v":"احمد"}]
[null,null,null,null,"اسم الصنف","شاي ليبتون",4,6,"زعفران","عدد"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"اسم الصنف","شاي ليبتون","إجمالى القيمة",null,{"$error":"#NAME?"}]
[]
[null,null,null,null,"اسم الصنف","شاي ليبتون","امين المستودع"]
[null,null,null,null,"اسم الصنف","شاي ليبتون",4333]
[null,null,null,null,"اسم الصنف","شاي ليبتون","عامل"]
[null,null,null,null,"اسم الصنف","شاي ليبتون","غابا"]

{"sheet":"تقريرالوارد","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,9,6,11],[6,12,6,14],[5,0,5,14]]}
[]
[]
[]
[]
[]
["الوارد"]
["مسلسل","التاريخ","رقم الفاتورة","رقم الصنف","اسم الصنف","الوحدة","سعر الوحده","الكمية","القيمة","امين المستودع",null,null,"رئيس القسم"]
["S.r",null,null,"Item No","Item name",null,"Unit Price","Qty.","Amount","رقم الوظيفي","الرتبة","الاسم","رقم الوظيفي","الرتبة","الاسم"]
[1,"2019-01-17",100001,1,"شاي ليبتون","عدد",1,100,{"$f":"H9*G9","v":100}]
[1,"2019-01-18",100002,1,"شاي ليبتون","عدد",1,9,{"$f":"H10*G10","v":9}]
[2,"2019-01-19",100003,3,"حليب ابو قوس","عدد",1,2,2]
[3,"2019-01-20",100004,4,"شاي زعتر","عدد",1,2,2]