{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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","index":0,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"المطلوب عمل زر نقل الصفوف التي تحتوي على كلمة خالص فقط اى ملف اكسيل آخر باسم أرشيف بشرط ان يكون الزر محمي بكلمة مرور وشرط آخر ان ينقل القيم دون المعادلات"]
[]
[]
["العميل","دخول","السعر","ف شحن","المنطقة","ف ش","مرسل الى","الحالة","مرتجع","مؤجل","دفعات","ملاحظات","خالص","بتاريخ"]
["عميل 1","2018-03-24",500,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":40},"الشروق",40,"احمد ايمن","تم","","",null,"تعديل سعر بعد540","خالص","2018-04-04"]
["عميل 1","2018-03-24",1300,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"كفر الشيخ",55,"سحر عابدين","مرتجع",1300,"",null,"","خالص","2018-04-04"]
["عميل 1","2018-03-24",600,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"شرقية",55,"محمد طه","تم","","",null,null,"خالص","2018-04-04"]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"دقهلية",55,"احمد إبراهيم","تم","","",3000,"دفعة"]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"البحيرة",55,"ياسر محمد","مرتجع",450,"",null,"","خالص","2018-04-04"]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":90},"الاقصر",90,"أحلام عياد","تم","","",1200,"دفعة","خالص","2018-04-04"]
["عميل 2","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"الغربية",55,"سارة إبراهيم","تم","","",null,"","خالص","2018-04-04"]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"المعادي",35,"عبدالله الشريف","تم","","",null,"","خالص","2018-04-04"]
["عميل 3","2018-03-24",430,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"شبرا",35,"ليديا عبدالسيد","تم","","",null,""]
["عميل 1","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"دقهلية",55,"محمد عادل","مرتجع",450,"",null,"","خالص","2018-04-04"]
["عميل 1","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"البحيرة",55,"هبة عادل","مرتجع",450,"",null,"","خالص","2018-04-04"]
["عميل 1","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":80},"اسيوط",80,"مصطفى ربيع","تم","","",null,""]
["عميل 1","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"دمياط",55,"ام وفاء","مرتجع",450,"",null,"","خالص","2018-04-04"]
["عميل 1","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"شبرا الخيمة",35,"ام عمر","تم","","",null,"","خالص","2018-04-04"]
["عميل 1","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"المرج",35,"حمادة صابر","مؤجل","","",null,""]
["عميل 4","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"دقهلية",55,"أسماء عبدالله","تم","","",null,""]
["عميل 4","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"اسكندرية",55,"محمد رمضان","تم","","",null,"","خالص","2018-04-04"]
["عميل 4","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"الغورية",35,"محمد سامي","تم","","",null,"","خالص","2018-04-04"]
["عميل 4","2018-03-24",1100,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"الغربية",55,"هانم محمود","تم","","",null,"","خالص","2018-04-11"]
["عميل 4","2018-03-24",500,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"المحلة",55,"محمود غانم","تم","","",null,"","خالص","2018-04-04"]
["عميل 4","2018-03-24",250,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"دمياط",55,"ندى الديب","تم","","",5000,"دفعة"]
["عميل 4","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"دار السلام",35,"مصطفى عادل","مؤجل","","",null,""]
["عميل 4","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"الهرم",35,"حسام خليل","تم","","",null,"","خالص","2018-04-04"]
["عميل 4","2018-03-24",550,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"ع شمس",35,"ام كريم","تم","","",null,"","خالص","2018-04-04"]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"المحلة",55,"ام علي","تم","","",null,""]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":55},"دقهلية",55,"امين تهامي","تم","","",null,""]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"اسكندرية",55,"شيرين الصغير","مرتجع",450,"",null,""]
["عميل 2","2018-03-24",450,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":35},"المرج",35,"عمر يوسف","تم","","",null,""]
["عميل 2","2018-03-24",950,{"$f":"IF(الجدول2[[#This Row],[الحالة]]=\"تم\",الجدول2[[#This Row],[ف ش]],IF(الجدول2[[#This Row],[الحالة]]=\"مرتجع\",0,IF(الجدول2[[#This Row],[الحالة]]=\"مؤجل\",0,\"\")))","v":0},"الغردقة",90,"محمد مصطفى","مرتجع",950,"",null,""]