{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["استمارة","ايصال قسط"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[[8,25,8,28],[11,23,11,24],[10,25,10,28],[11,25,11,28],[20,25,20,28],[0,27,0,28],[0,24,0,26],[1,25,1,26],[1,27,1,28],[6,25,6,28],[4,21,4,23],[4,1,4,2],[6,1,6,2],[10,1,11,2],[8,1,8,2],[4,3,4,5],[4,10,4,11],[6,3,6,11],[8,3,8,4],[8,6,8,13],[10,9,10,13],[10,3,10,8],[11,3,11,8],[11,9,11,13],[6,15,6,16],[8,15,8,16],[20,1,21,2],[14,21,14,23],[16,1,16,2],[16,25,16,28],[18,1,18,2],[18,25,18,28],[14,1,14,2],[20,3,20,8],[20,9,20,13],[21,3,21,8],[21,9,21,13],[21,25,21,28],[21,23,21,24],[1,8,1,9],[14,3,14,5],[14,10,14,11],[16,3,16,11],[18,3,18,4],[18,6,18,13],[24,2,24,5],[24,6,24,7],[34,1,34,2],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,1,32,5],[25,6,32,7],[10,15,10,16],[16,15,16,16],[18,15,18,16],[20,15,20,16],[37,10,37,11]]}
[null,null,"        form      printed"]
[null,null,null,"2018-05-09T17:11:19.260",null,null,null,null,"اسـتـمـارة عمـيل",null,null,null,null,"كود",101]
[]
[]
[null,"اسم العميل",null,"كريم محمد شعبان السيد مصطفى",null,null," النوع","ذكر",28,"رقم قومى",null,null,"تاريخ صدور",null,"تاريخ ميلاد","1989-05-18"]
[]
[null,"العنوان",null,"مساكن الامام الشافعى خلف المدرسة امام صيدلية النقيب بلوك 10 الدور الرابع",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," النوع","",{"$error":"#VALUE!"},"رقم قومى",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,1,"mobile huawei مستعمل",null,null,null," -",null,1,2000,2000,200,210,1800]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"",null,null,null,null,null,null,null,null,0,null,0,0]
[null,"إجمـــالـى",null,null,null,null,null,null,1,null,2000,200,210,1800]
[]
[null,"تاريخ القرض",null,"2018-05-07","طريقة السداد","شهرى","مدة سماح",8,"حالته","مفتوح"," قيمة القسط",185,"اخر قسط",185,"تحديد قسط",5]
[null,"رقم",1," عــدد الاقسـاط",12,"نســبة",0.25,null,"ارباح",null,"قيمة التمويل",1800,"قيمة القرض",null,"إجمالى"]
[]
[null,null,"رقم القسط","تاريخ الاستحقاق","القسط",null,"اصل","مصاريف",null,"قيمة مسددة","حـالة الســداد",null,null,"تاريخ السداد","قيمة غـير مسـددة",null,"تأخير"]
[null,null,1,"2018-06-15",210,null,150,60,null,null,null,null,null,null,"",null,0]
[null,null,2,"2018-07-15",210,null,150,60,null,null,null,null,null,null,"",null,0]
[null,null,3,"2018-08-15",210,null,150,60,null,null,null,null,null,null,"",null,0]
[null,null,4,"2018-09-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,5,"2018-10-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,6,"2018-11-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,7,"2018-12-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,8,"2019-01-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,9,"2019-02-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,10,"2019-03-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,11,"2019-04-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,12,"2019-05-15",210,null,150,60,null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,"","",0,null,"","",null,null,"","",null,null,"",null,0]
[null,null,null,null,2520,null,1800,720,null,807,null,1713,null,null,0,null,0]

{"sheet":"ايصال قسط","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[14,3,14,5],[2,2,2,7],[4,3,4,7],[12,3,12,7],[35,3,35,5],[37,3,37,7],[16,3,16,7],[23,2,23,7],[25,3,25,7],[33,3,33,7]]}
[null,null,null,"tama   tanfeth   alsadad"]
[]
[null,null,"ايصال سداد اقساط"]
[]
[null,null,"اسـم العـميل",{"$f":"استمارة!D5","v":"كريم محمد شعبان السيد مصطفى"}]
[]
[null,null,"كــود العـميل",{"$f":"استمارة!O2","v":101}]
[]
[null,null,"قيمة القسط",{"$f":"IF(H19>D19,VLOOKUP(D19,استمارة!$C$39:$E$62,3,0),استمارة!L63)","v":210}]
[]
[null,null,"قيمة مسددة",210,null,{"$f":"IF(D11=\"\",\"\",IF(D11<D9,\"جـزئى\",\"\"))","v":""}]
[]
[null,null,"مبلغـا وقـدره","فقط ثلاثمائة جنيه"]
[]
[null,null,"تاريخ الاستحقاق",{"$f":"VLOOKUP(D19,استمارة!$C$39:$E$62,2,0)","v":"2018-06-15"}]
[]
[null,null,"تاريخ السداد",{"$f":"IF(D9=0,\"\",NOW( ))","v":"2018-05-09T17:17:58.280"}]
[]
[null,null,"رقم القسط",{"$f":"IF(H19=0,\"\",COUNTA(استمارة!J39:J62)+1)","v":1},null,"عدد الاقساط",null,{"$f":"استمارة!E36","v":12}]
[]
[]
[]
[]
[null,null,"ايصال سداد اقساط"]
[]
[null,null,"اسـم العـميل",{"$f":"D5","v":"كريم محمد شعبان السيد مصطفى"}]
[]
[null,null,"كــود العـميل",{"$f":"D7","v":101}]
[]
[null,null,"قيمة القسط",{"$f":"D9","v":210},null,{"$f":"VLOOKUP(D40,استمارة!C39:H62,5,0)","v":150},null,{"$f":"VLOOKUP(D40,استمارة!C39:H62,6,0)","v":60}]
[]
[null,null,"قيمة مسددة",{"$f":"D11","v":210}]
[]
[null,null,"مبلغـا وقـدره",{"$f":"D13","v":"فقط ثلاثمائة جنيه"}]
[]
[null,null,"تاريخ الاستحقاق",{"$f":"D15","v":"2018-06-15"}]
[]
[null,null,"تاريخ السداد",{"$f":"D17","v":"2018-05-09T17:17:58.280"}]
[]
[null,null,"رقم القسط",{"$f":"D19","v":1},null,"عدد الاقساط",null,{"$f":"H19","v":12}]