{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1-1","1-2","1-3","1-4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"1-1","index":0,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,7],[2,0,2,1],[2,3,2,7],[3,0,3,1],[3,3,3,7],[4,0,4,1],[4,3,4,7],[5,0,5,1],[5,3,5,7],[6,0,6,1],[6,3,6,7],[13,10,14,10],[7,0,7,1],[7,3,7,7],[9,5,9,7],[10,0,10,1],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[13,5,13,6],[13,7,14,7]]}
[]
["المجموعة",null,null,"زجاج"]
["كود المجموعة",null,null,{"$f":"VLOOKUP(D2,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["اسم الصنف",null,null,"طقم زجاج"]
["Barcode",null,null,{"$f":"IF(D6>0,(TEXT(LEFT(C8,3),\"#000\"))&(TEXT(RIGHT(C8,LEN(C8)-4),\"#000\"))&99&TEXT(D3,\"#00\")&TEXT(D6,\"#000\"),\"\")","v":{"$error":"#REF!"}}]
["كود الصنف",null,{"$f":"D3&\"-\"&D6","v":{"$error":"#REF!"}},"2"]
["العدد فى الكرتونة",null,null,3]
["المورد",null,{"$f":"VLOOKUP(D8,#REF!,2,FALSE)","v":{"$error":"#REF!"}}," "]
[]
[null,null,null,null,null,"الرصيد"]
["الرئيسية",null,null,null,null,"عدد","أخر سعر","اجمالى جم"]
["الكود التالى",{"$f":"MAX(IF('[1]اجمالى المخزن'!$B$13:$B$1652=$D$3,'[1]اجمالى المخزن'!$C$13:$C$1652))+1","v":{"$error":"#REF!"}},null,null,null,{"$f":"D152-F152","v":182},{"$f":"IFERROR(INDEX(E16:E152,MATCH(9.99999999999999E+307,E16:E152)),0)","v":100},{"$f":"F12*G12","v":18200}]
[]
["التاريخ","مسلسل الأذن","البيان","اضافة",null,"خصم",null,"سعر البيع",null,null,"الرصيد عدد"]
[null,null,null,"عدد","سعر","عدد","سعر",null,"اجمالى أضافة","اجمالى خصم"]
[null,null,null,null,null,null,null,null,{"$f":"D16*E16","v":0},{"$f":"F16*G16","v":0},{"$f":"D16","v":0}]
["2018-01-01",5,"  أذن  رقم رصيد افتتاجى 2018",228,97.5,null,0,null,22230,0,{"$f":"K16+D17-F17","v":228}]
["2018-01-08",15," أذن مرتجعات رقم 282",null,null,-30,97.5,107.5,0,-2925,258]
["2018-01-08",16," أذن مرتجعات رقم 0013319",0,null,-3,97.5,162,0,-292.5,261]
["2018-01-18",38,"  أذن  رقم 240",null,null,257,97.5,98,0,25057.5,4]
["2018-03-10",228,"عميل نقدى أذن  رقم 293",null,null,1,97.5,97.5,0,97.5,3]
["2018-03-15",299,"عميل نقدى أذن  رقم 299",null,null,1,97.5,97,0,97.5,2]
["01/01/208","100","رصيد بداية المدة",200,100,20,100,100,20000,2000,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,{"$f":"D80*E80","v":0},{"$f":"F80*G80","v":0},182]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K80+D81-F81","v":182}]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,{"$f":"D144*E144","v":0},{"$f":"F144*G144","v":0},182]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K144+D145-F145","v":182}]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,null,null,null,null,null,0,0,182]
[null,null,null,{"$f":"SUM(D16:D151)","v":428},null,{"$f":"SUM(F16:F151)","v":246}," ",null,{"$f":"SUM(I16:I151)","v":42230},{"$f":"SUM(J16:J151)","v":24035}]

{"sheet":"1-2","index":1,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,7],[2,0,2,1],[2,3,2,7],[3,0,3,1],[3,3,3,7],[4,0,4,1],[4,3,4,7],[5,0,5,1],[5,3,5,7],[6,0,6,1],[6,3,6,7],[13,10,14,10],[7,0,7,1],[7,3,7,7],[9,5,9,7],[10,0,10,1],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[13,5,13,6],[13,7,14,7]]}
[]
["المجموعة",null,null,"زجاج"]
["كود المجموعة",null,null,{"$f":"VLOOKUP(D2,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["اسم الصنف",null,null,"طقم خزف"]
["Barcode",null,null,{"$f":"IF(D6>0,(TEXT(LEFT(C8,3),\"#000\"))&(TEXT(RIGHT(C8,LEN(C8)-4),\"#000\"))&99&TEXT(D3,\"#00\")&TEXT(D6,\"#000\"),\"\")","v":{"$error":"#REF!"}}]
["كود الصنف",null,{"$f":"D3&\"-\"&D6","v":{"$error":"#REF!"}},"5"]
["العدد فى الكرتونة",null,null,12]
["المورد",null,{"$f":"VLOOKUP(D8,#REF!,2,FALSE)","v":{"$error":"#REF!"}}," "]
[]
[null,null,null,null,null,"الرصيد"]
["الرئيسية",null,null,null,null,"عدد","أخر سعر","اجمالى جم"]
["الكود التالى",{"$f":"MAX(IF('[1]اجمالى المخزن'!$B$13:$B$1652=$D$3,'[1]اجمالى المخزن'!$C$13:$C$1652))+1","v":{"$error":"#REF!"}},null,null,null,{"$f":"D152-F152","v":576},{"$f":"IFERROR(INDEX(E16:E152,MATCH(9.99999999999999E+307,E16:E152)),0)","v":100},{"$f":"F12*G12","v":57600}]
[]
["التاريخ","مسلسل الأذن","البيان","اضافة",null,"خصم",null,"سعر البيع",null,null,"الرصيد عدد"]
[null,null,null,"عدد","سعر","عدد","سعر",null,"اجمالى أضافة","اجمالى خصم"]
[null,null,null,null,null,null,null,null,{"$f":"D16*E16","v":0},{"$f":"F16*G16","v":0},{"$f":"D16","v":0}]
["2018-01-01",3,"  أذن  رقم رصيد افتتاجى 2018",476,48,null,0,null,22848,0,{"$f":"K16+D17-F17","v":476}]
["2018-01-17",35,"أذن  رقم 249",null,null,12,48,63,0,576,464]
["2018-01-13",76," أذن  رقم 555 - 559",null,null,6,48,57,0,288,458]
["2018-02-06",99," أذن  رقم 268 - 269",null,null,36,48,50,0,1728,422]
["2018-02-07",100," الهنا أذن  رقم 701 - 702",120,48,null,0,null,5760,0,542]
["2018-02-08",102," عميل أذن  رقم 270 - 271",null,null,120,48,50,0,5760,422]
["2018-02-17",122," أذن  رقم 583 - 585",null,null,1,48,94.47,0,48,421]
["2018-02-17",128," أذن  رقم 593 - 594",null,null,1,48,94.47,0,48,420]
["2018-02-18",142,"  أذن  رقم 608 - 610",null,null,2,48,94.47,0,96,418]
["2018-02-21",157," أذن  رقم 1079 - 1082",null,null,10,48,94.5,0,480,408]
["2018-02-24",167," أذن  رقم 1085 - 1089",null,null,12,48,66,0,576,396]
["01/01/208","100","رصيد بداية المدة",200,100,20,100,100,20000,2000,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,{"$f":"D80*E80","v":0},{"$f":"F80*G80","v":0},576]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K80+D81-F81","v":576}]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,{"$f":"D144*E144","v":0},{"$f":"F144*G144","v":0},576]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K144+D145-F145","v":576}]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,null,null,null,null,null,0,0,576]
[null,null,null,{"$f":"SUM(D16:D151)","v":796},null,{"$f":"SUM(F16:F151)","v":220}," ",null,{"$f":"SUM(I16:I151)","v":48608},{"$f":"SUM(J16:J151)","v":11600}]

{"sheet":"1-3","index":2,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,7],[2,0,2,1],[2,3,2,7],[3,0,3,1],[3,3,3,7],[4,0,4,1],[4,3,4,7],[5,0,5,1],[5,3,5,7],[6,0,6,1],[6,3,6,7],[13,10,14,10],[7,0,7,1],[7,3,7,7],[9,5,9,7],[10,0,10,1],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[13,5,13,6],[13,7,14,7]]}
[]
["المجموعة",null,null,"زجاج"]
["كود المجموعة",null,null,{"$f":"VLOOKUP(D2,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["اسم الصنف",null,null,"طقم ستانلس"]
["Barcode",null,null,{"$f":"IF(D6>0,(TEXT(LEFT(C8,3),\"#000\"))&(TEXT(RIGHT(C8,LEN(C8)-4),\"#000\"))&99&TEXT(D3,\"#00\")&TEXT(D6,\"#000\"),\"\")","v":{"$error":"#REF!"}}]
["كود الصنف",null,{"$f":"D3&\"-\"&D6","v":{"$error":"#REF!"}},"7"]
["العدد فى الكرتونة",null,null,18]
["المورد",null,{"$f":"VLOOKUP(D8,#REF!,2,FALSE)","v":{"$error":"#REF!"}}," "]
[]
[null,null,null,null,null,"الرصيد"]
["الرئيسية",null,null,null,null,"عدد","أخر سعر","اجمالى جم"]
["الكود التالى",{"$f":"MAX(IF('[1]اجمالى المخزن'!$B$13:$B$1652=$D$3,'[1]اجمالى المخزن'!$C$13:$C$1652))+1","v":{"$error":"#REF!"}},null,null,null,{"$f":"D152-F152","v":-185},{"$f":"IFERROR(INDEX(E16:E152,MATCH(9.99999999999999E+307,E16:E152)),0)","v":100},{"$f":"F12*G12","v":-18500}]
[]
["التاريخ","مسلسل الأذن","البيان","اضافة",null,"خصم",null,"سعر البيع",null,null,"الرصيد عدد"]
[null,null,null,"عدد","سعر","عدد","سعر",null,"اجمالى أضافة","اجمالى خصم"]
[null,null,null,null,null,null,null,null,{"$f":"D16*E16","v":0},{"$f":"F16*G16","v":0},{"$f":"D16","v":0}]
["2018-01-01",3,"  أذن  رقم رصيد افتتاجى 2018",-299,9.8403179190751402,null,0,null,-2942.255057803467,0,{"$f":"K16+D17-F17","v":-299}]
["2018-02-05",94," أذن  رقم 263 - 265",null,null,6,9.8403179190751402,21,0,59.041907514450841,-305]
["2018-02-21",157," أذن  رقم 1079 - 1082",null,null,12,9.8403179190751402,20,0,118.08381502890168,-317]
["2018-03-03",233," أذن  رقم 626 - 634",null,null,24,9.8403179190751402,15.95,0,236.16763005780336,-341]
["2018-07-28",664,"  أذن  رقم 1146 - 1150",null,null,24,9.8403179190751402,23.95,0,236.16763005780336,-365]
["01/01/208","100","رصيد بداية المدة",200,100,20,100,100,20000,2000,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,{"$f":"D80*E80","v":0},{"$f":"F80*G80","v":0},-185]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K80+D81-F81","v":-185}]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,{"$f":"D144*E144","v":0},{"$f":"F144*G144","v":0},-185]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K144+D145-F145","v":-185}]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,null,null,null,null,null,0,0,-185]
[null,null,null,{"$f":"SUM(D16:D151)","v":-99},null,{"$f":"SUM(F16:F151)","v":86}," ",null,{"$f":"SUM(I16:I151)","v":17057.744942196532},{"$f":"SUM(J16:J151)","v":2649.4609826589594}]

{"sheet":"1-4","index":3,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,7],[2,0,2,1],[2,3,2,7],[3,0,3,1],[3,3,3,7],[4,0,4,1],[4,3,4,7],[5,0,5,1],[5,3,5,7],[6,0,6,1],[6,3,6,7],[13,10,14,10],[7,0,7,1],[7,3,7,7],[9,5,9,7],[10,0,10,1],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,4],[13,5,13,6],[13,7,14,7]]}
[]
["المجموعة",null,null,"بورسلين"]
["كود المجموعة",null,null,{"$f":"VLOOKUP(D2,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["اسم الصنف",null,null,"طقم نحاس"]
["Barcode",null,null,{"$f":"IF(D6>0,(TEXT(LEFT(C8,3),\"#000\"))&(TEXT(RIGHT(C8,LEN(C8)-4),\"#000\"))&99&TEXT(D3,\"#00\")&TEXT(D6,\"#000\"),\"\")","v":{"$error":"#REF!"}}]
["كود الصنف",null,{"$f":"D3&\"-\"&D6","v":{"$error":"#REF!"}},"2"]
["العدد فى الكرتونة",null,null,9]
["المورد",null,{"$f":"VLOOKUP(D8,#REF!,2,FALSE)","v":{"$error":"#REF!"}}," "]
[]
[null,null,null,null,null,"الرصيد"]
["الرئيسية",null,null,null,null,"عدد","أخر سعر","اجمالى جم"]
["الكود التالى",{"$f":"MAX(IF('[1]اجمالى المخزن'!$B$13:$B$1652=$D$3,'[1]اجمالى المخزن'!$C$13:$C$1652))+1","v":{"$error":"#REF!"}},null,null,null,{"$f":"D152-F152","v":148},{"$f":"IFERROR(INDEX(E16:E152,MATCH(9.99999999999999E+307,E16:E152)),0)","v":100},{"$f":"F12*G12","v":14800}]
[]
["التاريخ","مسلسل الأذن","البيان","اضافة",null,"خصم",null,"سعر البيع",null,null,"الرصيد عدد"]
[null,null,null,"عدد","سعر","عدد","سعر",null,"اجمالى أضافة","اجمالى خصم"]
[null,null,null,null,null,null,null,null,{"$f":"D16*E16","v":0},{"$f":"F16*G16","v":0},{"$f":"D16","v":0}]
["2018-01-01",6,"  أذن  رقم رصيد افتتاجى 2018",0,19.402101291485781,null,0,null,0,0,{"$f":"K16+D17-F17","v":0}]
["2018-01-03",10,"أذن  رقم 4039",64,10,null,0,null,640,0,64]
["2018-01-18",39," أذن  رقم 251",null,null,4,10,15,0,40,60]
["2018-01-04",70," أذن  رقم 1063 - 1068",null,null,60,10,15,0,600,0]
["2018-03-04",243," أذن  رقم 286 - 287",null,null,32,10,15,0,320,-32]
["01/01/208","100","رصيد بداية المدة",200,100,20,100,100,20000,2000,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,{"$f":"D80*E80","v":0},{"$f":"F80*G80","v":0},148]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K80+D81-F81","v":148}]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,{"$f":"D144*E144","v":0},{"$f":"F144*G144","v":0},148]
[null,null,null,null,null,null,null,null,0,0,{"$f":"K144+D145-F145","v":148}]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,null,null,null,null,null,0,0,148]
[null,null,null,{"$f":"SUM(D16:D151)","v":264},null,{"$f":"SUM(F16:F151)","v":116}," ",null,{"$f":"SUM(I16:I151)","v":20640},{"$f":"SUM(J16:J151)","v":2960}]