{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["فواتير","الداتا"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","التاريخ","كود الصنف","اسم الصنف","السعر","الكمية","الاجمالى","ضريبة المبيعات ال 14%","رصيد اخر المده","المخزون"]
[1,"2022-08-02"]
[1,"2022-08-02",12,"بيبى جوى 4",220,50,11000,1540.0000000000002]
[1,"2022-08-02",null,"","",2,54,7.5600000000000005]
[1,"2022-08-02",15,"صابون جلسرين",15,5,75,10.500000000000002,null,1000]
[1,"2022-08-02",15,"صابون جلسرين",15,5,30,4.2,null,1000]
[1,"2022-08-02",14,"صابون مطهر",12,3,36,5.0400000000000009,null,1000]
[1,"2022-08-02",17,"fril",26,22,572,80.080000000000013,null,10000]
[1,"2022-08-02",18,"friltr",27,4,108,15.120000000000001,null,1000]
[1,"2022-08-02",14,"صابون مطهر",12,null,0,0,null,10000]
[1,"2022-08-02",null,"صابون جلسرين",15,null,null,0,null,1000]
[1,"2022-08-02",null,"صابون جلسرين",15,null,null,0,null,1000]
[1,"2022-08-02",null,null,null,null,null,null,null,10000]
[1,"2022-08-02",null,null,null,null,null,null,"المطلوب جمع القيم منه",1]
[1,"2022-08-02",null,null,null,null,null,null,"عند تحقيق شرط توافق الاسم يتم جمع العمود باكمله ",1000]
[1,"2022-08-02",null,"",null,null,null,null,"وارجاع قيمه كل صنف فى خانة رصيد اول المده  الموجوده ",2]
[1,"2022-08-02",null,"",null,null,null,null,"فى شيت \"الداتا \" بتوافق كود الصنف اول الاسم ",1000]
[3183,"2022-08-02",null,null,null,null,null,null,"ودالة فى الاكسيل لخصم المبيعات تلك من اجمالى المخزون وارجاع الباقى فى نفس المكان"]
[3183,"2022-08-02",1,"فلوكاموكس",25,2,50,7.0000000000000009]
[3183,"2022-08-02",9,"بيبى جوى 1",250,2,500,70]
[3183,"2022-08-02",12,"بيبى جوى 4",220,3,660,92.4]
[3183,"2022-08-02",18,"friltr",27,44,null,0]
[3183,"2022-08-02",13,"بيبى جوى 5",210,4,840,117.60000000000001]
[3183,"2022-08-02",7,"امينو",250,3,750,105.00000000000001]
[3183,"2022-08-02",16,"بلسم ",25,5,125,17.5]
[3183,"2022-08-02",14,"صابون مطهر",12,4,48,6.7200000000000006]
[3183,"2022-08-02",5,"ديستاميثازورن",10,9,90,12.600000000000001]
[3183,"2022-08-02",3,"فولتارين",10,12,120,16.8]
[3183,"2022-08-02"]
[3183,"2022-08-02"]
[3183,"2022-08-02"]
[3183,"2022-08-02",null,""]
[3183,"2022-08-02",null,""]

{"sheet":"الداتا","index":1,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["code","اسم الصنف","تاريخ انتهاء الصلاحية","السعر للوحده","باقى على الصلاحية",null,null,"رقم فاتورة التوريد","تاريخ الانتاج","الداخل الى المخزن","الخارج من المخزن","رصيد اخر المده","قيمة المخزون الحالى","قيمة المباع","اجمالى الصنف","العجز"]
[1,"فلوكاموكس","2019-09-30",25,{"$f":"C2-I2","v":312},null,null,null,"2018-11-22",4000,3200,null,{"$f":"L2*D2","v":0},{"$f":"K2*D2","v":80000},{"$f":"N2+M2","v":80000},{"$f":"O2-(N2+M2)","v":0}]
[2,"اوجمانتين","2019-10-01",90,312,null,null,null,"2018-11-23",3000,4000,null,0,null,{"$f":"N3+M3","v":0}]
[3,"فولتارين","2019-10-02",10,312,null,null,null,"2018-11-24",3000,4000,null,0,null,0]
[4,"ديكلاك صوديوم","2018-10-03",15,251,null,null,null,"2018-01-25",3000,4000,null,0,null,0]
[5,"ديستاميثازورن","2019-10-04",10,312,null,null,null,"2018-11-26",3000,4000,null,0,null,0]
[6,"كريم حلاقة","2019-10-05",20,312,null,null,null,"2018-11-27",3000,4000,null,0,null,0]
[7,"امينو","2019-10-06",250,312,null,null,null,"2018-11-28",3000,4000,null,0,null,0]
[8,"زينك","2019-10-07",20,312,null,null,null,"2018-11-29",3000,4000,null,0,null,0]
[9,"بيبى جوى 1","2019-10-08",250,312,null,null,null,"2018-11-30",3000,4000,null,0,null,0]
[10,"بيبى جوى 2","2019-10-09",240,312,null,null,null,"2018-12-01",3000,4000,null,0,null,0]
[11,"بيبى جوى 3","2019-10-10",230,312,null,null,null,"2018-12-02",3000,4000,null,0,null,0]
[12,"بيبى جوى 4","2019-10-11",220,312,null,null,null,"2018-12-03",3000,4000,null,0,null,0]
[13,"بيبى جوى 5","2019-10-12",210,312,null,null,null,"2018-12-04",3000,4000,null,0,null,0]
[14,"صابون مطهر","2019-10-13",12,312,null,null,null,"2018-12-05",3000,4000,null,0,null,0]
[15,"صابون جلسرين","2019-10-14",15,312,null,null,null,"2018-12-06",3000,4000,null,0,null,0]
[17,"معجون","2019-10-16",26,312,null,null,null,"2018-12-08",3000,4000,null,0,null,0]
[18,"فرشة سوفت","2019-10-17",10,312,null,null,null,"2018-12-09",3000,4000,null,0,null,0]
[19,"فرشة هارد","2019-10-18",15,312,null,null,null,"2018-12-10",3000,4000,null,0,null,0]
[20,null,null,null,0]