{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["العقود","كشف عميل"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":9,"defined_names":269,"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":182,"n_cols":147,"rows_kept":182,"cut":false,"hidden":false,"merged":[[0,0,0,23],[0,30,0,31],[0,35,0,41]]}
["CUSTOMER BOOKING DETAILS",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,{"$f":"TODAY()","v":"2019-03-09"}]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,25,26,27]
["م","رقم العقد","اسم البائع","اسم المشتري","جوال المشتري","الكفيل1","جوال","الكفيل2","جوال","ملاحظات العقد","نوع السياره","الموديل","الهيكل","تاريخ البيع","سعر البيع","سعرالشراء","المربح","المقدم","القسط","عدد الاقساط","نوع السداد","الواصل","الخصومات","المتبقي ","الحال","تاريخ بداية الاستحقاق","تاريخ نهاية الاستحقاق",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120]
[1,{"$f":"IF(A4=\"\",\"\",A4+100)","v":101},"احمد خالد","عبد الرزاق عبد الله ",null,null,null,null,null,"تم الاتفاق علي منح المشتري "]
[2,{"$f":"IF(A5=\"\",\"\",A5+100)","v":102},"السيد علي","محمود محمد",null,null,null,null,null,"تم الاتفاق علي منح المشتري "]
[3,103,"وليد محمد","مصطفي محمد",null,null,null,null,null,"تم الاتفاق علي منح المشتري"]
[4,104,"السيد علي","احمد علي",null,null,null,null,null,"تم الاتفاق علي منح المشتري "]
[5,105,"احمد خالد","خالد زكريا",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,{"$f":"IF(A64=\"\",\"\",A64+100)","v":""}]
[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,{"$f":"IF(A128=\"\",\"\",A128+100)","v":""}]
[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,{"$f":"IF(Z181=\"\",\"\",EOMONTH(Z181,T181-1))","v":""}]
[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,""]

{"sheet":"كشف عميل","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,7,5,7],[1,8,5,8]]}
[{"$f":"\"كشف حساب \"&\" / \"&\"\"&L2","v":"كشف حساب  / "},null,null,null,null,null,null,null,null,null,null,"احمد خالد"]
[null,null,null,null,null,null,{"$f":"SUMIF(E9:E74,\">=\"&start_1,B9:B74)-SUMIF(E9:E74,\">\"&end,B9:B74)","v":0},null,{"$f":"TODAY()","v":"2019-03-09"},null,"المشتري",""]
[]
[]
[null,null,{"$f":"SUMIF(H9:H200,\"خصم\",B9:B200)","v":0},{"$f":"SUMIFS(D9:D100,E9:E100,\">=\"&start_1,E9:E100,\">\"&end)","v":0}]
[null,null,{"$f":"SUM(L9:L199)","v":0}]
[]
["م","القسط المدفوع",null,null,"تاريخ الاستحقاق","تاريخ السداد",null,"نوع السداد"]