{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Item_List","purchases","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"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":"Item_List","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,6,0,7]]}
["Item ID","Item Description","Last Unit Cost","Last Unit Cost With Data","التغير في الاسعار","تاريخ تحديث الاسعار","التكلفه مع تحديث الاسعار حسب التاريخ",null,"حفظ نسخة من المعادلة  بدون  تاريخ","حفظ نسخة من المعادلة  بين تاريخين"]
["C001","كيس  ابيض صغير",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A2)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A2)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C2-D2,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B2))))","v":"2023-04-08"},"من تاريخ","الي تاريخ",{"$f":"1/(1/LOOKUP(9^9,(Data!$E$2:$E$8981)/((Data!$C$2:$C$8981=A2))))","v":{"$error":"#DIV/0!"}},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A2)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0}]
["C002","كيس احمر صغير",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A3)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A3)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C3-D3,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B3))))","v":"2023-04-08"},"2022-06-09","2023-04-08",null,{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A3)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0}]
["C003","كيس اصفر صغير",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A4)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A4)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C4-D4,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B4))))","v":"2023-04-08"}]
["C004","كيس اخضر صغير",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A5)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A5)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C5-D5,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B5))))","v":"2023-04-08"},null,null,"سعر غير محدث او لم يتغير"]
["C005","كيس اسود صغير",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A6)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A6)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C6-D6,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B6))))","v":"2023-04-08"},null,null,"سعر محدث خلال اسيوع"]
["C006","كيس  ابيض كبير محمل",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A7)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A7)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C7-D7,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B7))))","v":"2023-04-08"}]
["C007","كيس احمر كبير محمل",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A8)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A8)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C8-D8,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B8))))","v":"2023-04-08"}]
["C008","كيس اصفر كبير محمل",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A9)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A9)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C9-D9,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B9))))","v":"2023-04-08"}]
["C009","كيس اخضر كبير محمل",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A10)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A10)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C10-D10,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B10))))","v":"2023-04-08"}]
["C010","كيس اسود كبير محمل",{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A11)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"LOOKUP(2,1/((Data!$C$2:$C$8981=A11)*(Data!$B$2:$B$8981>=$G$3)*(Data!$B$2:$B$8981<=$H$3)),Data!$E$2:$E$8981)","v":0},{"$f":"IFERROR(C11-D11,\"\")","v":0},{"$f":"1/(1/LOOKUP(9^9,(Data!$B$2:$B$8981)/((Data!$D$2:$D$8981=B11))))","v":"2023-04-08"}]

{"sheet":"purchases","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,3],[7,4,9,10],[10,4,11,10],[12,4,13,10]]}
["التاريخ ","2023-04-08","تحديث اسعار رقم",3]
[]
["تحديث اسعار الخامات"]
[]
["كود الصنف","اسم الصنف","السعر السابق غير شامل ","السعر الحالى غير شامل"]
["C001",{"$f":"IFERROR(VLOOKUP(A6,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس  ابيض صغير"},{"$f":"IFERROR(VLOOKUP(A6,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C002",{"$f":"IFERROR(VLOOKUP(A7,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس احمر صغير"},{"$f":"IFERROR(VLOOKUP(A7,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C003",{"$f":"IFERROR(VLOOKUP(A8,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اصفر صغير"},{"$f":"IFERROR(VLOOKUP(A8,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0},null,"المطلوب في حالة الترحيل وسعر الالصنف الجديد غير مكتوب لا يتم الترحيل  ويعطي رسالة تنبيه"]
["C004",{"$f":"IFERROR(VLOOKUP(A9,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اخضر صغير"},{"$f":"IFERROR(VLOOKUP(A9,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C005",{"$f":"IFERROR(VLOOKUP(A10,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اسود صغير"},{"$f":"IFERROR(VLOOKUP(A10,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C006",{"$f":"IFERROR(VLOOKUP(A11,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس  ابيض كبير محمل"},{"$f":"IFERROR(VLOOKUP(A11,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0},null,"لانه في حالة الترحيل و السعر الحالي  غير مكتوب يعدل القيمه ب صفر  وهذه مشكلة"]
["C007",{"$f":"IFERROR(VLOOKUP(A12,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس احمر كبير محمل"},{"$f":"IFERROR(VLOOKUP(A12,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C008",{"$f":"IFERROR(VLOOKUP(A13,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اصفر كبير محمل"},{"$f":"IFERROR(VLOOKUP(A13,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0},null,"مع العلم ممكن تغير الاسعار لا يكون لكل الاصناف"]
["C009",{"$f":"IFERROR(VLOOKUP(A14,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اخضر كبير محمل"},{"$f":"IFERROR(VLOOKUP(A14,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]
["C010",{"$f":"IFERROR(VLOOKUP(A15,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":"كيس اسود كبير محمل"},{"$f":"IFERROR(VLOOKUP(A15,Item_List!$A$2:$C$8995,COLUMN(),0),\"\")","v":0}]

{"sheet":"Data","index":2,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["purchases No","Date","Item ID","Item Description","Last Unit Cost"]
[1,"2022-06-09","C001","كيس  ابيض كبير",10]
[1,"2022-06-09","C002","كيس احمر كبير",10]
[1,"2022-06-09","C003","كيس اصفر كبير",10]
[1,"2022-06-09","C004","كيس اخضر كبير",10]
[1,"2022-06-09","C005","كيس اسود كبير",10]
[1,"2022-06-09","C006","كيس  ابيض صغير",7.5]
[1,"2022-06-09","C007","كيس احمر صغير",7.5]
[1,"2022-06-09","C008","كيس اصفر صغير",7.5]
[1,"2022-06-09","C009","كيس اخضر صغير",7.5]
[1,"2022-06-09","C010","كيس اسود صغير",7.5]
[2,"2023-04-08","C001","كيس  ابيض صغير"]
[2,"2023-04-08","C002","كيس احمر صغير"]
[2,"2023-04-08","C003","كيس اصفر صغير"]
[2,"2023-04-08","C004","كيس اخضر صغير"]
[2,"2023-04-08","C005","كيس اسود صغير"]
[2,"2023-04-08","C006","كيس  ابيض كبير محمل"]
[2,"2023-04-08","C007","كيس احمر كبير محمل"]
[2,"2023-04-08","C008","كيس اصفر كبير محمل"]
[2,"2023-04-08","C009","كيس اخضر كبير محمل"]
[2,"2023-04-08","C010","كيس اسود كبير محمل"]
[2,"2023-04-08"]