{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Main Sheet","Data","الغاء","مدخل 1","مدخل 2","التعديلات","مكرر","التحصيل","التقارير"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Main Sheet","index":0,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,7,3,11]]}
[]
[]
[]
[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,"عند مشاركة ملف العمل لايتم غلق اى من TABS مثل ( DATA FILTER - Conditional formating…........ الخ )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عندفتح الملف فى كل مره يفتح على صفحة القائمة الرئيسية"]

{"sheet":"Data","index":1,"n_rows":14,"n_cols":55,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sr","شهر الاصدار","إصدار/إلغاء","يوجد مرتد / لا يوجد","كومنت","الفرع","System2","Account","Insurance Type","Insurance CO","Policy.No","Customer Name","Brand","الموديل","Model","نوع السيارة","سنة الصنع","Chassis","الموتور","Plate ","لصالح بنك ","اليورو","D","M","Y","D2","M3","Y4","مبلغ التأمين","القسط الاساسى","القسط الأجمالى","تامين العميل","تامين العميل فى الريكوست","سداد العميل فى الريكوست","عموله شركه التامين","ايراد المتابعه","Standard or Top2","loction","contact per","Sales Man","الوثيقة","تاريخ الأدخال","تاريخ التحرير","شهر التحرير","تاريخ الإلغاء ","يوجد مرتد / لا يوجد","تاريخ الإيصال","السداد","العنوان","الوظيفه",5,"Tel2","BLACK LIST",1,2]
[1,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين","التجمع",null,"تجديدات","سيارات","GIG","P-28-2020-MOT-MOTGD-1360","ايمن محمد محمود السيد عوض 1","نقل","BMW",530,"U",2019,"WE82621",13475485,0,"العميل","NON",27,10,2020,26,10,2021,1305000,52225.86,55463,55463,55463,4.2500383141762452E-2,null,0,4.2500383141762452E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-01","2020-10-27",11,null,null,null,null,"8اش_لطفى حسونه_الدقى الجيزه"]
[2,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين",null,null,"تجديدات","سيارات","TAKAFUL","P/MOT/CPM/05/2020/29571","عبد الحميد فتحى عبد الحميد محمد 1","نقل","BMW","X1","U",2020,"5P12615",34285775,0,"العميل","NON",27,10,2020,4,11,2021,657000,26313,28120,28120,27923,4.2500761035007613E-2,null,-197,4.2800608828006091E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-01","2020-10-27",11,null,null,null,null,"31ش_صالح صبحى_حلوان"]
[3,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين","التجمع",null,"تجديدات","سيارات","GIG","P-28-2020-MOT-MOTGD-1361","ماهر سليمان بشاره شنوده 1","نقل","BMW","X1","U",2020,"5P12695",34305775,0,"العميل","NON",22,10,2020,21,10,2021,657000,26220.2,27923,27923,27923,4.2500761035007613E-2,null,0,4.2500761035007613E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-02","2020-10-22",11,null,null,null,null,"27ش_الوجوه_الترعه البولاقيه_شبرا",null,null,null,null,"عوض"]
[4,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين",null,null,"تجديدات","سيارات","MISR","P/MOC/PRV/003/2020/1300","فاديه عاطف محمد فتح الله2","نقل","BMW",318,"U",2017,"5G02551","F6041510","ه ط ه 968","العميل","NON",22,10,2020,22,10,2021,399600,16919.259999999998,17982,17982,17982,4.4999999999999998E-2,null,0,4.4999999999999998E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-02","2020-10-28",11,null,null,null,null,"5مجموعه31_الرحاب_التجمع الاول",null,null,null,null,"عوض"]
[5,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين",null,null,"تجديدات","سيارات","MISR","P/MOC/PRV/003/2020/1309","احمد السيد احمد سميه11 ","نقل","BMW","X3","U",2017,"LV33963",1119664,"س م ب 3143","العميل","NON",18,10,2020,18,10,2021,812250,32536.83,34521,34521,30460,3.7500769467528471E-2,null,-4061,4.2500461680517083E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-02","2020-10-28",11,null,null,null,null,"16ش_العقبه_كليوباترا_سيدى جابر_اسكندريه"]
[6,"2020-11-01","اصدار",null," يوجد ريكوست + طلب تامين +بطاقه + صوره وثيقه + رخصه",null,null,"تجديدات","سيارات","GIG","P-28-2020-MOT-MOTGD-1366","طارق عصام خميس رفاعي  1","نقل","BMW",320,"U",2020,"FH42562","h2383439",0,"س ص د 3696","NON",9,10,2020,8,10,2021,810000,32359.95,34425,34425,34425,4.2500000000000003E-2,null,0,4.2500000000000003E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-05","2020-11-02",11]
[7,"2020-11-01","اصدار",null," يوجد ريكوست + طلب تامين +بطاقه + صوره وثيقه + رخصه",null,null,"تجديدات","سيارات","MISR","P/MOC/PRV/003/2020/1352","رولا احمد جمال الدين محرم 1","نقل","BMW","X3","U",2016,"K84122","A7651158",0,"العميل","NON",3,11,2020,3,11,2021,620000,24821.06,26350,26350,21700,3.5000000000000003E-2,null,-4650,4.2500000000000003E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-05","2020-11-03",11]
[8,"2020-11-01","اصدار",null," يوجد ريكوست + طلب تامين +بطاقه + صوره وثيقه + رخصه",null,null,"تجديدات","سيارات","TAKAFUL","P/MOT/CPM/05/2020/29576","حسين عبد الله العلايلى 1","نقل","BMW","X1","U",2018,"ED46528","G450H551",0,"العميل","NON",1,11,2020,2,11,2021,550000,20723,22199,22199,22000,0.04,null,-199,4.0361818181818179E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-05","2020-11-01",11]
[9,"2020-11-01","اصدار",null,"يوجد ريكوست + طلب تامين + صوره وثيقه + بطاقه رخصه","مدينه نصر",24245,"تجديدات","سيارات","GIG","P-2-2020-MOT-MOTGD-3715","يوسف ايمن سيد حلمى 1","نقل","BMW","X3","U",2019,"LB20021",23295378,"ع ن ا 836","العميل","NON",30,10,2020,29,10,2021,1080000,38143,40500,40500,38340,3.5499999999999997E-2,null,-2160,3.7499999999999999E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-09","2020-11-04",11,null,null,null,null,"221تجمع 5_غرب الجولف_ثان القاهره الجديبده",null,null,null,null,"عوض"]
[10,"2020-11-01","اصدار",null,"يوجد ريكوست + طلب تامين + صوره وثيقه + بطاقه رخصه",null,null,"تجديدات","سيارات","MISR","P/MOC/PRV/003/2020/1356","محمود محمد محمود خميس 1","نقل","BMW",520,"U",2020,"WC18653","F0213210",0,"بنك الأمارات دبى الوطنى","NON",18,11,2020,18,11,2021,1000000,40071.29,42500,42500,37500,3.7499999999999999E-2,null,-5000,4.2500000000000003E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-09","2020-11-04",11,null,null,null,null,"ق253_الجولف المتميز_التجمع الخامس",null,null,null,null,"عوض"]
[11,"2020-11-01","اصدار",null," يوجد ريكوست + طلب تامين +بطاقه + صوره وثيقه + رخصه",null,null,"تجديدات","سيارات","GIG","P-28-2020-MOT-MOTGD-1363","مصطفى محمد ابراهيم الشناوى 1","نقل","BMW",520,"U",2017,"0GA01310","A1771508",0,"العميل","NON",30,10,2020,29,10,2021,760500,30188,32125,32125,32125,4.2241946088099933E-2,null,0,4.2241946088099933E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-05","2020-11-01",11,null,null,null,null,"94ش_احمد عرابى_المهندسين_العجوزه"]
[12,"2020-11-01","اصدار",null," يوجد ريكوست + طلب تامين +بطاقه + صوره وثيقه + رخصه",null,null,"تجديدات","سيارات","MISR","P/MOC/PRV/003/2020/1322","محمد ابراهيم محمود يس 1","نقل","BMW","X6","U",2018,"R97134",20901820,"ق ق ف 862","بنك قطر الوطنى الاهلى _مصر","NON",5,11,2020,5,11,2021,1250000,50104.34,53125,53125,46875,3.7499999999999999E-2,null,-6250,4.2500000000000003E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-05","2020-11-01",11,null,null,null,null,"78ش_عمار بن ياسر_النزهه"]
[13,"2020-11-01","اصدار",null,"يوجد ريكويست +صوره وثيقه+صورة بطاقه + طلب تامين",null,null,"تجديدات","سيارات","TAKAFUL","P/MOT/CPM/05/2019/11361/R1","دارا ايهاب نجاد عبد الفتاح السياسى 1","نقل","MINI COOPER","COOPER","U",2020,"3L08116",31325760,0,"العميل","NON",13,11,2020,12,11,2021,684000,24171,25650,25650,25650,3.7499999999999999E-2,null,0,3.7499999999999999E-2,"تجديدات","تجديدات","تجديدات","تجديد","2020-11-12","2020-11-10",11,null,null,null,null,"10مربع1156_احمد اسماعيل_النزهه",null,null,null,"عوض"]

{"sheet":"الغاء","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"مدخل 1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"مدخل 2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"التعديلات","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"مكرر","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"التحصيل","index":7,"n_rows":15,"n_cols":42,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["سيريال","شهر الاصدار","إصدار/إلغاء","يوجد مرتد / لا يوجد","كومنت","الفرع","System2","Account","Insurance Type","Insurance CO","Policy.No","Customer Name","Brand","الموديل","Model","نوع السيارة","سنة الصنع","Chassis","الموتور","اليورو","D","M","Y","D2","M3","Y4","مبلغ التأمين","القسط الاساسى","القسط الأجمالى","تامين العميل","تامين العميل فى الريكوست","سداد العميل فى الريكوست","عموله شركه التامين","ايراد المتابعه","loction","contact per","Sales Man","الوثيقة","تاريخ الأدخال","تاريخ التحرير","شهر التحرير","تاريخ الإلغاء "]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Main Sheet'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"التقارير","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}