{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Menu","Main","DB"],"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":"Menu","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["م","النوع","سعر القطعة"]
[1,"ممحاة",3]
[2,"قلم",4]
[3,"مشرط",3]
[4,"أوراق مقوى",6]
[5,"قلم حبر"]
[6,"قلم رصاص",4]
[7,"دفتر ملاحظات",1.8]
[8,"شنطة",4]
[9,"ورق ملون",2.5]
[10,"ورق A4",4]
[11,"ورق A3",4]
[12,"حامل الأقلام",3]
[13,"تغيير صمام الأزرار",7]
[14,"مثبت الطاولة",9]
[15,"طاولة خشبية",6]
[16,"طاولة حديد",3]
[17,"سبورة عادية",2]
[18,"سبورة الكترونية",32]
[19,"شاشة لمس",8]

{"sheet":"Main","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,4,2,5],[3,4,3,5],[2,1,2,2],[3,1,3,2]]}
[]
[]
[]
[]
[]
[null,"التاريخ:","2020-08-15"]
[null,"رقم التسلسل:",2]
[]
[null,"الصنف","السعر","العدد","المجموع"]
[null,"ممحاة",4,5,{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",PRODUCT(C10,D10))","v":20},null,null,null,"المطلوب: في حالة وجود صفوف فارغة في الصنف والسعر والعدد والمجموع لا يتم ترحيل البيانات إلى شيت DB"]
[null,"قلم",5,2,{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",PRODUCT(C11,D11))","v":10},null,null,null,"والإكتفاء بترحيل البيانات التي تم تسجيلها فقط "]
[null,"قلم",5,12,60]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Menu!$B:$C,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(SUM(D13*E13),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Menu!$B:$C,2,FALSE),\"\")","v":""},"",""]
[null,null,null,null,""]
[null,null,null,"المجموع",{"$f":"SUM(E10:E19)","v":90},{"$f":"SUM(F10:F19)","v":0}]
[]
[]
[null,null,"الملاحظات"]
[null,null,"السعر الإجمالي بعد التخفيض"]

{"sheet":"DB","index":2,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["#","التاريخ","رقم التسلسل","الصنف","السعر","العدد","المجموع","الملاحظات"]
[1,"2020-08-15",2,"ممحاة",4,5,20]
[2,"2020-08-15",2,"قلم",5,2,10]
[3,"2020-08-15",2,"قلم",5,12,60]
[null,null,null,null,"TOTAL",null,{"$f":"SUM(G2:G4)","v":90}]