{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Purchases"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":1,"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":"Purchases","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"IFERROR(IF(Purchases[Item Name]=\"total purchases\",\" \",INDEX([1]!Material.Chart[Item Code],MATCH(Purchases[Item Name],[1]!Material.Chart[Item Name],0))),\"New Item\")","v":"New Item"},null,{"$f":"IF(Purchases[Item Name]=\"total purchases\",\" \",INDEX([1]!Material.Chart[Item Unit],MATCH(Purchases[Item Name],[1]!Material.Chart[Item Name],0)))","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX([1]!Material.Chart[[Item Category ]],MATCH(Purchases[Item Code],[1]!Material.Chart[Item Code],0)),\" \")","v":" "},{"$f":"IF(Purchases[Control]=\"المخزن الرئيسى\",IF(Purchases[Item Name]=\"total purchases\",\" \",INDEX([1]!Material.Chart[Cost Center],MATCH(Purchases[Item Code],[1]!Material.Chart[Item Code],0))),IF(Purchases[Control]=\"المعمل\",IF(Purchases[Item Name]=\"total purchases\",\" \",INDEX([1]!Material.Chart[Cost Center],MATCH(Purchases[Item Code],[1]!Material.Chart[Item Code],0))),\"المشتريات المباشرة\"))","v":{"$error":"#VALUE!"}},null,null,{"$f":"Purchases[[#This Row],[A.U.PRICE]]*Purchases[[#This Row],[Quantity]]","v":{"$error":"#VALUE!"}},{"$f":"IF(Purchases[Control]=\"المخزن الرئيسى\",IF(Purchases[Item Name]=\"total purchases\",\" \",INDEX([1]!Material.Chart[[Item Store ]],MATCH(Purchases[Item Code],[1]!Material.Chart[Item Code],0))),IF(Purchases[Control]=\"المعمل\",IF(Purchases[Item Name]=\"total purchases\",\" \",IF(Purchases[Control]=\"المشتريات المباشرة\",\" \",INDEX([1]!Material.Chart[[Item Store ]],MATCH(Purchases[Item Code],[1]!Material.Chart[Item Code],0)))),\"المشتريات المباشرة\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Purchases[Store Name]=\"المخزن الرئيسى\",\"المخزن الرئيسى\",IF(Purchases[Store Name]=\"المعمل\",\"المعمل\",\"المشتريات المباشرة\"))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"[1]Chart!$M$11","v":"2019-01-01"},{"$f":"IF(Purchases[[#This Row],[MONTHS]]>0,Purchases[MONTHS],C1)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[null,"MONTHS","Date","Item Code","Item Name","Item Unit","Item Category ","Cost Center","Quantity","A.U.PRICE","Value","WeareHouse  Iteme ","Store Name","Control"]
[null,"2018-12-01","2018-12-01",101001,"خميرة فورية جافة","كيلو","مواد جافة","Food",610,37.967213114754102,23160.000000000004,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",101002,"فرقع لوز كاراتيه","قطعة","مواد جافة","Food",4752,0.83330000000000015,3959.8416000000007,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",101003,"شيبسى","قطعة","مواد جافة","Food",1098,0.84688196721311471,929.87639999999999,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102001,"جبنة موتزاريلا مبشورة","كيلو","منتجات البان","Food",22252,46.526424591047999,1035306.0000000001,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102002,"جبنة موتزاريلا صوابع","كيلو","منتجات البان","Food",4242.13,51.373324949966182,217932.32297000004,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102003,"جبنة شيدر قوالب","كيلو","منتجات البان","Food",949.59800000000007,96.028248795806235,91188.233000000022,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102004,"جبنة رومى","كيلو","منتجات البان","Food",10.65,75.622403755868547,805.37860000000001,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102005,"جبنة فلامنك","كيلو","منتجات البان","Food",326.83890000000002,125.52602800401051,41026.788914199991,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102007,"جبنة كريمى","كيلو","منتجات البان","Food",151.6,63.957783641160951,9696,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102008,"زبادى","كيلو","منتجات البان","Food",3468,17.249489013840829,59821.227899999998,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102009,"كريمة لبانى","لتر","منتجات البان","Food",12051,55.905594556468309,673718.3199999996,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",102010,"حليب","لتر","منتجات البان","Food",19644,12.885100946854005,253114.92300000007,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,"2019-01-01","2018-12-01",102011,"زبدة صفراء","كيلو","منتجات البان","Food",1888.5,111.25205189303681,210099.5,"الرئيسى اغذية","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301001,"اكياس قمامة جامبو","كيلو","مواد و معدات نظافة","General",5,29,145,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301002,"اكياس قمامة وسط","كيلو","مواد و معدات نظافة","General",4585,28.874591057797165,132390,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301004,"مكنسة ارضية ناعمة","قطعة","مواد و معدات نظافة","General",228,8.2806894736842107,1887.9972,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301005,"شرشوبة موب صغيرة","قطعة","مواد و معدات نظافة","General",888,3.8716216216216219,3438.0000000000005,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301006,"شرشوبة موب عريضة","قطعة","مواد و معدات نظافة","General",333,25,8325,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301007,"مساحة ارضيات","قطعة","مواد و معدات نظافة","General",204,6.2352941176470589,1272,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]
[null,null,"2018-12-01",301008,"فرشاة تنظيف ارضيات","قطعة","مواد و معدات نظافة","General",17,13.529411764705884,230.00000000000003,"الرئيسى مواد و معدات نظافة","المخزن الرئيسى","المخزن الرئيسى"]