{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":65,"n_cols":43,"rows_kept":65,"cut":false,"hidden":false,"merged":[[6,0,6,5]]}
[null,null,null,"عند كتابة الرقم هنا المطلوب يتن عمل تصفية متقدمة في الجدول ادناه "]
[]
[]
["رقم ","حالة أمر الشغل",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(A5=\"\",\"\",IF(F9=\"\",\"\",IF(F9>0,\" تحت التشغيل \",IF(F9=0,\"منتهي\"))))","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,"مصاريف تشكيل "]
[{"$f":"IF(A5=\"\",\"\",K14)","v":""},{"$f":"IF(A5=\"\",\"\",M14)","v":""},{"$f":"IF(A5=\"\",\"\",A9-B9)","v":""},{"$f":"IF(A5=\"\",\"\",L14)","v":""},{"$f":"IF(A5=\"\",\"\",N14)","v":""},{"$f":"IF(A5=\"\",\"\",C9-D9-E9)","v":""}]
[]
[]
[]
[]
[null,false,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I16:I65)","v":6100},7200,17550,7200,3900,350,26350,512.72,null,{"$f":"SUBTOTAL(9,R16:R65)","v":252259.84999999998}]
["تاريخ","الحركة ","بيــــــــــــــــــان","اسم المورد","السريال ","نوع السند","رقم السند","الكمية ","صافي الكمية ","كمية مسدد بها مصروف سحب","صادر","وارد منتج تام ","مردود خامة ","وارد هالك","قيمة سحب","السعر ","القيمة ","قيمة الخامة "]
["2020-03-15","صرف خامة ","هاي","على ",15,"صرف",150,1200,{"$f":"IF(B16=$AQ$4,H16,IF(B16=$AQ$8,0,H16*-1))","v":1200},{"$f":"IF(B16=$AQ$8,H16,0)","v":0},{"$f":"IF(B16=$AQ$4,H16,0)","v":1200},{"$f":"IF(B16=$AQ$6,H16,0)","v":0},{"$f":"IF(B16=$AQ$5,H16,0)","v":0},{"$f":"IF(B16=$AQ$7,H16,0)","v":0},{"$f":"IF(B16=$AQ$8,H16*P16,0)","v":0},20,{"$f":"IF(E16=\"\",\"\",H16*P16)","v":24000},{"$f":"IF(E16=\"\",\"\",IF(B16=$AQ$4,Q16,IF(B16=$AQ$8,0,IF(B16=$AQ$6,0,IF(B16=$AQ$7,0,Q16*-1)))))","v":24000}]
["2020-03-16","صرف خامة ","ناشف","على ",15,"صرف",150,800,800,0,800,0,0,0,0,17,13600,13600]
["2020-03-15","صرف خامة ","اوميا","على ",15,"صرف",150,300,300,0,300,0,0,0,0,4.5,1350,1350]
["2020-03-18","مردود خامة ","هاي","على ",15,"اضافة",220,130,-130,0,0,0,130,0,0,20,2600,-2600]
["2020-03-18","مردود خامة ","ناشف","على ",15,"اضافة",220,60,-60,0,0,0,60,0,0,17,1020,-1020]
["2020-03-18","مردود خامة ","اوميا","على ",15,"اضافة",220,10,-10,0,0,0,10,0,0,4.5,45,-45]
["2020-03-20","مصاريف تشكيل ","سحب","على ",15,"قيد",453,2000,0,2000,0,0,0,0,8000,4,8000,0]
["2020-03-21","وارد منتج تام","بكر","على ",15,"اضافة",221,2000,-2000,0,0,2000,0,0,0,20.8,41600,0]
["2020-03-22","وارد هالك","هالك","على ",15,"اضافة",222,100,-100,0,0,0,0,100,0,16.8,1680,0]
["2020-01-01","صرف خامة ","لو","سيد",16,"صرف",151,2500,2500,0,2500,0,0,0,0,21,52500,52500]
["2020-01-01","صرف خامة ","طري","سيد",16,"صرف",151,1500,1500,0,1500,0,0,0,0,18,27000,27000]
["2020-01-01","صرف خامة ","اوميا","سيد",16,"صرف",151,250,250,0,250,0,0,0,0,4.5,1125,1125]
["2020-01-05","مردود خامة ","لو","سيد",16,"اضافة",123,200,-200,0,0,0,200,0,0,21,4200,-4200]
["2020-01-06","مردود خامة ","طري","سيد",16,"اضافة",123,100,-100,0,0,0,100,0,0,18,1800,-1800]
["2020-01-07","مردود خامة ","اوميا","سيد",16,"اضافة",123,50,-50,0,0,0,50,0,0,4.5,225,-225]
["2020-01-10","مصاريف تشكيل ","سحب","سيد",16,"قيد",220,1200,0,1200,0,0,0,0,3600,3,3600,0]
["2020-10-01","وارد منتج تام","كيس","سيد",16,"اضافة",124,1200,-1200,0,0,1200,0,0,0,22.08,26495.999999999996,0]
["2020-10-10","صرف خامة ","هيفي","على ",17,"صرف",230,3000,3000,0,3000,0,0,0,0,23,69000,69000]
["2020-10-11","صرف خامة ","لو","على ",17,"صرف",230,1500,1500,0,1500,0,0,0,0,22,33000,33000]
["2020-10-11","صرف خامة ","طري","على ",17,"صرف",230,1000,1000,0,1000,0,0,0,0,18,18000,18000]
["2020-10-10","مصاريف تشكيل ","سحب","على ",17,"قيد",1234,2500,0,2500,0,0,0,0,8750,3.5,8750,0]
["2020-10-10","وارد منتج تام","كيس هيفي ","على ",17,"اضافة",225,2500,-2500,0,0,2500,0,0,0,25.32,63300,0]
["2020-10-01","وارد هالك","هالك هيفي ","على ",17,"اضافة",226,150,-150,0,0,0,0,150,0,21.82,3273,0]
["2020-09-28","صرف خامة ","لو","صفر",18,"صرف",229,3000,3000,0,3000,0,0,0,0,19,57000,57000]
["2020-09-28","صرف خامة ","طري","صفر",18,"صرف",229,2000,2000,0,2000,0,0,0,0,17,34000,34000]
["2020-09-28","صرف خامة ","اوميا","صفر",18,"صرف",229,500,500,0,500,0,0,0,0,4.5,2250,2250]
["2028-09-01","مردود خامة ","طري","صفر",18,"اضافة",125,500,-500,0,0,0,500,0,0,17,8500,-8500]
["2020-10-01","مصاريف تشكيل ","سحب","صفر",18,"قيد",223,1500,0,1500,0,0,0,0,6000,4,6000,0]
["2020-10-01","وارد منتج تام","بكر","صفر",18,"اضافة",126,1500,-1500,0,0,1500,0,0,0,20.95,31425,0]
["2020-10-01","وارد هالك","هالك","صفر",18,"اضافة",126,100,-100,0,0,0,0,100,0,16.95,1695,0]
["2020-10-02","مردود خامة ","هيفي","على ",17,"اضافة",127,1553.27,-1553.27,0,0,0,1553.27,0,0,23,35725.21,-35725.21]
["2020-10-02","مردود خامة ","لو","على ",17,"اضافة",127,777.2,-777.2,0,0,0,777.2,0,0,22,17098.400000000001,-17098.400000000001]
["2020-10-02","مردود خامة ","طري","على ",17,"اضافة",127,519.53,-519.53,0,0,0,519.53,0,0,18,9351.5399999999991,-9351.5399999999991]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,"",""]