{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["التكويد","المبيعات اليوميه","اجمالى المبيعات","رصيد البضاعه","الموردين","العملاء"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"التكويد","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["الكود","الصنف"]
[1,"lnb واحد مخرج"]
[2,"lnb اثنين مخرج"]
[3,"lnb اربعه مخرج"]
[4,"lnb ثمانيه مخرج"]
[5,"سلك 20 يارده اسود"]
[6,"سلك 30 يارده اسود"]
[7,"سلك 50 يارده اسود"]
[8,"سلك 100 يارده اسود"]
[9,"سلك 20 يارده ابيض"]
[10,"سلك 30 يارده ابيض"]
[11,"سلك 50 يارده ابيض"]
[12,"سلك 100 يارده ابيض"]
[13,"طبق 70 سم"]
[14,"طبق 80 سم"]
[15,"طبق 100 سم"]
[16,"كابل 1×1"]
[17,"كابل 1×2"]
[18,"كابل 1×3"]
[19,"كابل hd"]
[20,"ريموت عادى"]
[21,"ريموت شعبى"]
[22,"ريموت hd"]
[23,"ريموت تلفزيون"]
[24,"حامل شاشه 32 مصرى"]
[25,"حامل شاشه 39 مصرى"]
[26,"حامل شاشه 50 مصرى"]
[27,"حامل شاشه 32 مستورد"]
[28,"حامل شاشه 39 مستورد"]
[29,"حامل شاشه 50 مستورد"]

{"sheet":"المبيعات اليوميه","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["رقم الصنف","الصنف","المبلغ","التاريخ","ملاحظات"]
[null,{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2,aly,2,0))","v":""}]
[null,{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,aly,2,0))","v":""}]
[null,{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,aly,2,0))","v":""}]
[null,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,aly,2,0))","v":""}]
[null,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,aly,2,0))","v":""}]
[null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,aly,2,0))","v":""}]
[null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,aly,2,0))","v":""}]
[null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,aly,2,0))","v":""}]
[null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,aly,2,0))","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,aly,2,0))","v":""}]
[null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,aly,2,0))","v":""}]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,aly,2,0))","v":""}]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,aly,2,0))","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,aly,2,0))","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,aly,2,0))","v":""}]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,aly,2,0))","v":""}]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,aly,2,0))","v":""}]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,aly,2,0))","v":""}]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,aly,2,0))","v":""}]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,aly,2,0))","v":""}]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,aly,2,0))","v":""}]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,aly,2,0))","v":""}]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,aly,2,0))","v":""}]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,aly,2,0))","v":""}]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,aly,2,0))","v":""}]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,aly,2,0))","v":""}]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,aly,2,0))","v":""}]
[null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,aly,2,0))","v":""}]
[null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,aly,2,0))","v":""}]

{"sheet":"اجمالى المبيعات","index":2,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["رقم ","الصنف","المبلغ","التاريخ","ملاحظات"]
[1,"lnb واحد مخرج",14,"2020-12-15","a"]
[1,"lnb واحد مخرج",14,"2020-12-15","a"]
[1,"lnb واحد مخرج",14,"2020-12-15","a"]
[2,"lnb اثنين مخرج",14,"2020-12-16","b"]
[2,"lnb اثنين مخرج",14,"2020-12-16","b"]
[2,"lnb اثنين مخرج",14,"2020-12-17"]
[2,"lnb اثنين مخرج",14,"2020-12-16","b"]
[3,"lnb اربعه مخرج",12,"2020-12-17","c"]
[3,"lnb اربعه مخرج",12,"2020-12-17","c"]
[3,"lnb اربعه مخرج",12,"2020-12-17","c"]
[4,"lnb ثمانيه مخرج",47,"2020-12-18","d"]
[4,"lnb ثمانيه مخرج",47,"2020-12-18","d"]
[5,"سلك 20 يارده اسود",48,"2020-12-19","e"]
[5,"سلك 20 يارده اسود",48,"2020-12-19","e"]
[6,"سلك 30 يارده اسود",417,"2020-12-20","f"]
[6,"سلك 30 يارده اسود",417,"2020-12-20","f"]
[7,"سلك 50 يارده اسود",12,"2020-12-21","g"]
[7,"سلك 50 يارده اسود",12,"2020-12-21","g"]
[8,"سلك 100 يارده اسود",47,"2020-12-22","h"]
[8,"سلك 100 يارده اسود",47,"2020-12-22","h"]
[9,"سلك 20 يارده ابيض",48,"2020-12-23","i"]
[9,"سلك 20 يارده ابيض",48,"2020-12-23","i"]
[12,"سلك 100 يارده ابيض",100,"2020-12-24","fgn"]
[12,"سلك 100 يارده ابيض",100,"2020-12-24","fgn"]
[1,"lnb واحد مخرج"]
[1,"lnb واحد مخرج"]

{"sheet":"رصيد البضاعه","index":3,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["رقم الصنف","الكميه","السعر","الاجمالى","البيان","المورد","التاريخ","ملاحظات"]

{"sheet":"الموردين","index":4,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,5,3,5],[0,1,0,2],[1,1,1,4],[2,2,3,2],[2,0,3,0],[2,4,3,4],[2,1,3,1],[2,3,3,3]]}
["التاريخ"]
["المورد"]
["رقم الصنف","الكميه","السعر","الاجمالى","البيان","ملاحظات"]
[]
[1,12,null,null,{"$f":"VLOOKUP(A5,aly,2,0)","v":"lnb واحد مخرج"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"}]

{"sheet":"العملاء","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}