{"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":false,"merged":[]}
["م","النوع","سعر القطعة"]
[1,"ممحاة",3]
[2,"قلم",4]
[3,"مشرط",3]
[4,"أوراق مقوى",6]
[5,"قلم حبر",3]
[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":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,1,9,2],[2,6,2,8],[3,6,3,8],[8,1,8,2],[2,1,2,2],[3,1,3,2],[24,2,24,6],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[23,2,23,6]]}
[]
[]
[]
[]
[]
[null,"التاريخ:",{"$f":"TODAY()","v":"2021-04-07"}]
[null,"رقم التسلسل:",2]
[]
[null,"الصنف",null,null,"السعر",null,"العدد",null,"المجموع"]
[null,"ورق ملون",null,null,{"$f":"IFERROR(VLOOKUP(B10,Menu!$B:$C,2,FALSE),\"\")","v":2.5},null,1,null,{"$f":"IFERROR(SUM(E10*G10),\"\")","v":2.5},null,null,"المطلوب: في حالة وجود صفوف فارغة في الصنف والسعر والعدد والمجموع لا يتم ترحيل البيانات إلى شيت DB"]
[null,"قلم رصاص",null,null,{"$f":"IFERROR(VLOOKUP(B11,Menu!$B:$C,2,FALSE),\"\")","v":4},null,2,null,{"$f":"IFERROR(SUM(E11*G11),\"\")","v":8},null,null,"والإكتفاء بترحيل البيانات التي تم تسجيلها فقط "]
[null,"أوراق مقوى",null,null,{"$f":"IFERROR(VLOOKUP(B12,Menu!$B:$C,2,FALSE),\"\")","v":6},null,88,null,528]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Menu!$B:$C,2,FALSE),\"\")","v":""},null,null,null,""]
[]
[null,null,null,null,"المجموع",null,{"$f":"SUM(G10:G19)","v":91},null,{"$f":"SUM(I10:I19)","v":538.5}]
[]
[]
[null,null,"الملاحظات"]
[null,null,"السعر الإجمالي بعد التخفيض"]

{"sheet":"DB","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["التاريخ","رقم التسلسل","الصنف","السعر","العدد","المجموع","الملاحظات"]
[0,0]
["2021-04-07",1,"مثبت الطاولة",9,1,9,"لا تتوفر ملاحظات "]
["2021-04-07",1,"مشرط",3,2,6]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]
["2021-04-07",1]