{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المبيعات","المخازن"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":100,"n_cols":19,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[1,2,3,2],[1,0,3,0],[1,3,3,3],[4,0,6,0],[4,2,6,2],[4,3,6,3],[1,1,3,1],[4,1,6,1]]}
["كود العملية","التاريخ","الزبون","اجمالي المبلغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Helper column"]
[1,"2019-01-01","احمد ",{"$f":"SUM(G4:M4)","v":2600},null,"السلعة",1001,1002,1003,1004,null,null,null,null,"السلعة",1004,null,null,{"$f":"IF(F2=\"\",\"\",SUMPRODUCT(--($G2:$M2=$P$6)*$G3:$M3))","v":5}]
[null,null,null,null,null,"الكمية",1,2,5,5,null,null,null,null,"الكمية",8,null,null,{"$f":"IF(F3=\"\",\"\",SUMPRODUCT(--($G3:$M3=$P$6)*$G4:$M4))","v":0}]
[null,null,null,null,null,"السعر",{"$f":"VLOOKUP(G2,المخازن!$A$2:$C$6,2,FALSE)*G3","v":200},{"$f":"VLOOKUP(H2,المخازن!$A$2:$C$6,2,FALSE)*H3","v":400},{"$f":"VLOOKUP(I2,المخازن!$A$2:$C$6,2,FALSE)*I3","v":1000},{"$f":"VLOOKUP(J2,المخازن!$A$2:$C$6,2,FALSE)*J3","v":1000},null,null,null,null,null,null,null,null,0]
[2,"2019-01-02","ناصر",{"$f":"SUM(G7:M7)","v":4000},null,"السلعة",2001,1001,2005,1003,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"الكمية",1,2,3,6,null,null,null,null,"السلعة",1004,null,null,0]
[null,null,null,null,null,"السعر",{"$f":"VLOOKUP(G5,المخازن!$A$2:$C$14,2,FALSE)*G6","v":600},{"$f":"VLOOKUP(H5,المخازن!$A$2:$C$14,2,FALSE)*H6","v":400},{"$f":"VLOOKUP(I5,المخازن!$A$2:$C$14,2,FALSE)*I6","v":1800},{"$f":"VLOOKUP(J5,المخازن!$A$2:$C$14,2,FALSE)*J6","v":1200},null,null,null,null,"الكمية",{"$f":"SUM(S2:S100)","v":8},null,null,0]
[2,"2019-01-03","نعيم",{"$f":"SUM(G10:M10)","v":9400},null,"السلعة",2002,2003,2004,2005,1001,1004,1003,null,null,null,null,null,3]
[null,null,null,null,null,"الكمية",1,2,3,6,2,3,6,null,null,null,null,null,0]
[null,null,null,null,null,"السعر",{"$f":"VLOOKUP(G8,المخازن!$A$2:$C$14,2,FALSE)*G9","v":600},{"$f":"VLOOKUP(H8,المخازن!$A$2:$C$14,2,FALSE)*H9","v":1200},{"$f":"VLOOKUP(I8,المخازن!$A$2:$C$14,2,FALSE)*I9","v":1800},{"$f":"VLOOKUP(J8,المخازن!$A$2:$C$14,2,FALSE)*J9","v":3600},{"$f":"VLOOKUP(K8,المخازن!$A$2:$C$14,2,FALSE)*K9","v":400},{"$f":"VLOOKUP(L8,المخازن!$A$2:$C$14,2,FALSE)*L9","v":600},{"$f":"VLOOKUP(M8,المخازن!$A$2:$C$14,2,FALSE)*M9","v":1200},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"by formula",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F67=\"\",\"\",SUMPRODUCT(--($G67:$M67=$P$6)*$G68:$M68))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"المخازن","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["كود السلعة","سعر السلعة","اجمالي المخزون"]
[1001,200,5]
[1002,200,11]
[1003,200,4]
[1004,200,2]
[1005,200,10]
[2001,600,15]
[2002,600,12]
[2003,600,5]
[2004,600,4]
[2005,600,5]
[2006,600,4]
[2007,600,21]
[2008,600,6]