{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setting","تقريرالصرف","الصرف"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":4,"defined_names":13,"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":"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":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,0,4,17],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,9,6,11],[6,12,6,14],[6,15,6,17]]}
["شركة مسطاح للنقليات",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mstah Transport Company"]
["ادارة الباصات",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus management"]
["الخدمات",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services"]
["المستودع",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stores"]
["تقرير الصرف"]
[]
["مسلسل","التاريخ","رقم الفاتورة","رقم الصنف","اسم الصنف","الوحدة","سعر الوحده","الكمية","القيمة","امين المستودع",null,null,"المستلم",null,null,"رئيس القسم"]
[null,null,null,null,null,null,null,null,null,"رقم الوظيفي","الرتبة","الاسم","رقم الوظيفي","الرتبة","الاسم","رقم الوظيفي","الرتبة","الاسم"]

{"sheet":"الصرف","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,4,26,6],[28,0,28,1],[28,2,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,3],[27,0,27,1],[27,2,27,3],[27,4,27,6],[4,0,4,6],[5,1,5,2],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[24,0,24,1],[24,2,24,5],[26,0,26,1],[26,2,26,3]]}
["شركة مسطاح للنقليات",null,null,null,null,null,"Mstah Transport Company"]
["ادارة الباصات",null,null,null,null,null,"Bus management"]
["الخدمات",null,null,null,null,null,"Services"]
["المستودع",null,null,null,null,null,"Stores"]
["سند الصرف"]
["التـــاريـخ :",{"$f":"TODAY()","v":"2020-01-31"},null,null,"فاتـــورة ",200001,"NO"]
["مسلسل","رقم الصنف","اسم الصنف","الوحدة","سعر الوحده","الكمية","القيمة"]
["S.r","Item No","Item name","Unit","Unit Price","Qty.","Amount"]
[1,{"$f":"IFERROR(VLOOKUP(A9,'[3]بيانات الاصناف'!A9:C612,2,FALSE),\"\")","v":1},{"$f":"IFERROR(VLOOKUP(B9,'[3]بيانات الاصناف'!B9:C612,2,FALSE),\"\")","v":"شاي ليبتون"},{"$f":"IFERROR(VLOOKUP(C9,'[3]بيانات الاصناف'!C9:D612,2,FALSE),\"\")","v":"عدد"},{"$f":"IFERROR(VLOOKUP(D9,'[3]بيانات الاصناف'!D9:E612,2,FALSE),\"\")","v":13},null,{"$f":"IF(F9>0,E9*F9,\"\")","v":""}]
[{"$f":"IF(B10<>\"\",A9+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B10,'[3]بيانات الاصناف'!B10:D613,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C10,'[3]بيانات الاصناف'!C10:D613,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D10,'[3]بيانات الاصناف'!D10:E613,2,FALSE),\"\")","v":""},null,{"$f":"IF(F10>0,E10*F10,\"\")","v":""}]
[{"$f":"IF(B11<>\"\",A10+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B11,'[3]بيانات الاصناف'!B11:D614,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C11,'[3]بيانات الاصناف'!C11:D614,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,'[3]بيانات الاصناف'!D11:E614,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B12<>\"\",A11+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B12,'[3]بيانات الاصناف'!B12:D615,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C12,'[3]بيانات الاصناف'!C12:D615,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D12,'[3]بيانات الاصناف'!D12:E615,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B13<>\"\",A12+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B13,'[3]بيانات الاصناف'!B13:D616,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C13,'[3]بيانات الاصناف'!C13:D616,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D13,'[3]بيانات الاصناف'!D13:E616,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B14<>\"\",A13+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B14,'[3]بيانات الاصناف'!B14:D617,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C14,'[3]بيانات الاصناف'!C14:D617,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D14,'[3]بيانات الاصناف'!D14:E617,2,FALSE),\"\")","v":""},null,""]
["","",{"$f":"IFERROR(VLOOKUP(B15,'[3]بيانات الاصناف'!B15:D618,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C15,'[3]بيانات الاصناف'!C15:D618,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D15,'[3]بيانات الاصناف'!D15:E618,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B16<>\"\",A15+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B16,'[3]بيانات الاصناف'!B16:D619,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C16,'[3]بيانات الاصناف'!C16:D619,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D16,'[3]بيانات الاصناف'!D16:E619,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B17<>\"\",A16+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B17,'[3]بيانات الاصناف'!B17:D620,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C17,'[3]بيانات الاصناف'!C17:D620,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D17,'[3]بيانات الاصناف'!D17:E620,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B18<>\"\",A17+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B18,'[3]بيانات الاصناف'!B18:D621,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C18,'[3]بيانات الاصناف'!C18:D621,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D18,'[3]بيانات الاصناف'!D18:E621,2,FALSE),\"\")","v":""},null,""]
["",null,{"$f":"IFERROR(VLOOKUP(B19,'[3]بيانات الاصناف'!B19:D622,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C19,'[3]بيانات الاصناف'!C19:D622,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D19,'[3]بيانات الاصناف'!D19:E622,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B20<>\"\",A19+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B20,'[3]بيانات الاصناف'!B20:D623,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C20,'[3]بيانات الاصناف'!C20:D623,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D20,'[3]بيانات الاصناف'!D20:E623,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B21<>\"\",A20+1,\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B21,'[3]بيانات الاصناف'!B21:D624,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C21,'[3]بيانات الاصناف'!C21:D624,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D21,'[3]بيانات الاصناف'!D21:E624,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B22<>\"\",A21+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B22,'[3]بيانات الاصناف'!B22:D625,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,'[3]بيانات الاصناف'!C22:D625,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D22,'[3]بيانات الاصناف'!D22:E625,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B23<>\"\",A22+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B23,'[3]بيانات الاصناف'!B23:D626,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,'[3]بيانات الاصناف'!C23:D626,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D23,'[3]بيانات الاصناف'!D23:E626,2,FALSE),\"\")","v":""},null,""]
[{"$f":"IF(B24<>\"\",A23+1,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B24,'[3]بيانات الاصناف'!B24:D627,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C24,'[3]بيانات الاصناف'!C24:D627,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D24,'[3]بيانات الاصناف'!D24:E627,2,FALSE),\"\")","v":""},null,""]
["إجمالى القيمة",null,{"$f":"cur(G25,\"درهم\",\"فلس\")","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(G9:G24)","v":0}]
[]
["امين المستودع",null,"المستلم",null,"رئيس القسم"]
[1,null,1,null,1]
[{"$f":"VLOOKUP(A28,'[3]بيانات الموظف'!B8:E304,2,FALSE)","v":"كاتب"},null,{"$f":"VLOOKUP(C28,'[3]بيانات الموظف'!B8:G304,2,FALSE)","v":"كاتب"},null,{"$f":"VLOOKUP(E28,'[3]بيانات الموظف'!B8:J304,2,FALSE)","v":"كاتب"}]
[{"$f":"VLOOKUP(A28,'[3]بيانات الموظف'!B9:E305,3,FALSE)","v":"محمد احمد"},null,{"$f":"VLOOKUP(C28,'[3]بيانات الموظف'!B9:G305,3,FALSE)","v":"محمد احمد"},null,null,{"$f":"VLOOKUP(E28,'[3]بيانات الموظف'!B9:J305,3,FALSE)","v":"محمد احمد"}]