{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["العقود"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":10,"defined_names":212,"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":10,"n_cols":430,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,3,0,7]]}
[]
[]
["م","اسم البائع","اسم المشتري","الكفيل2","جوال","نوع السياره","الموديل","الهيكل","سعر البيع","سعرالشراء","المربح","المقدم","القسط","عدد الاقساط","نوع السداد","اجمالي الواصل مع المقدم","الخصومات","المتبقي ","الطايف","تاريخ بداية الاستحقاق ( م )","تاريخ نهاية الاستحقاق ( م )","المبلغ بدون مقدم","حالة العميل","تكلفة السياره","عدد الاقساط الواصله",null,"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,"تاريخ",121,"تاريخ",122,"تاريخ",123,"تاريخ",124,"تاريخ",125,"تاريخ",126,"تاريخ",127,"تاريخ",128,"تاريخ",129,"تاريخ",130,"تاريخ",131,"تاريخ",132,"تاريخ",133,"تاريخ",134,"تاريخ",135,"تاريخ",136,"تاريخ",137,"تاريخ",138,"تاريخ",139,"تاريخ",140,"تاريخ",141,"تاريخ",142,"تاريخ",143,"تاريخ",144,"تاريخ",145,"تاريخ",146,"تاريخ",147,"تاريخ",148,"تاريخ",149,"تاريخ",150,"تاريخ",151,"تاريخ",152,"تاريخ",153,"تاريخ",154,"تاريخ",155,"تاريخ",156,"تاريخ",157,"تاريخ",158,"تاريخ",159,"تاريخ",160,"تاريخ",161,"تاريخ",162,"تاريخ",163,"تاريخ",164,"تاريخ",165,"تاريخ",166,"تاريخ",167,"تاريخ",168,"تاريخ",169,"تاريخ",170,"تاريخ",171,"تاريخ",172,"تاريخ",173,"تاريخ",174,"تاريخ",175,"تاريخ",176,"تاريخ",177,"تاريخ",178,"تاريخ",179,"تاريخ",180,"تاريخ",181,"تاريخ",182,"تاريخ",183,"تاريخ",184,"تاريخ",185,"تاريخ",186,"تاريخ",187,"تاريخ",188,"تاريخ",189,"تاريخ",190,"تاريخ",191,"تاريخ",192,"تاريخ",193,"تاريخ",194,"تاريخ",195,"تاريخ",196,"تاريخ",197,"تاريخ",198,"تاريخ",199,"تاريخ",200,"تاريخ",201,"تاريخ",202,"تاريخ"]
[1167,null,null,null,null,"اكسنت  ",2018,null,75000,45000,{"$f":"I4-J4-Q4","v":30000},null,1500,{"$f":"IFERROR((V4/M4),\"\")","v":50},null,{"$f":"SUM(AA4+AC4+AE4+AG4+AI4+AK4+AM4+AO4+AQ4+AS4+AW4+AY4+BA4+BE4+BG4+BI4+BK4+BM4+BO4+BQ4+BS4+BU4+BW4+BY4+CA4+CC4+CE4+CG4+CI4+CK4+CM4+CO4+CQ4+CS4+CU4+CW4+CY4+DA4+DE4+DG4+DI4+DK4+DM4+DQ4+DS4+DU4+DW4+DY4+EA4+EC4+EE4+EG4+EI4+EK4+EM4+EO4+EQ4+ES4+EU4+EW4+EY4+FA4+FC4+FE4+FG4+FI4+FK4+FM4+FO4+FQ4+FS4+FU4+FW4+FY4+GA4+GC4+GE4+GG4+GI4+GK4+GM4+GO4+GQ4+GS4+GU4+GW4+GY4+HA4+HC4+HG4+HI4+HK4+HM4+HO4+HS4+HQ4+HU4+HW4+HY4+IA4+IC4+IE4+IG4+II4+IK4+IM4+IO4+IQ4+IS4+IU4+IW4+IY4+JA4+JC4+JE4+JG4+JI4+JK4+JM4+JO4+JQ4+JS4+JU4+JW4+JY4+KA4+KC4+KE4+KG4+KI4+KK4+KM4+KO4+KQ4+KS4+KU4+KW4+KY4+LA4+LC4+LE4+LG4+LI4+LK4+LM4+LO4+LQ4+LS4+LU4+LW4+LY4+MA4+MC4+ME4+MG4+MI4+MK4+MM4+MO4+MQ4+MS4+MU4+MW4+MY4+NA4+NC4+NE4+NG4+NI4+NK4+NM4+NO4+NQ4+NS4+NU4+NW4+NY4+OA4+OC4+OE4+OG4+OI4+OK4+OM4+OO4+OQ4+OS4+OU4+OW4+OY4+PA4+PC4+PE4+PG4+PI4+PK4+AU4+BC4+DC4+DO4+HE4+PM4)+Q4+L4","v":6000},null,{"$f":"I4-P4","v":69000},{"$f":"IFERROR(IF($B4=\"\",\"\",$M4*IF(DATEDIF($Z4,TODAY(),\"m\")>$N4,$N4,DATEDIF($Z4,TODAY(),\"m\"))-$P4+L4),\"\")","v":""},"2019-02-27",{"$f":"IF(T4=\"\",\"\",EOMONTH(T4,N4-1))","v":"2023-03-31"},{"$f":"I4-L4","v":75000},{"$f":"IFERROR(IF(AND(R4=S4,(R4+S4)>0),\"كامل المبلغ طايف علي العميل\",IF(AND(S4<R4,(S4>0)),\"العميل متأخر عن السداد\",IF(AND(R4=S4,(R4+S4)=0),\"خالص\",IF(AND(S4<R4,(S4<0)),\"تم السداد مبكر\",IF(AND(S4=0,(R4<=I4)),\"العميل منتظم بالسداد\",\"\"))))),\"\")","v":""},40000,{"$f":"COUNTA(AA4:HY4)-SUM(IF(TypeCell(AA4:HY4)=7,1,0))","v":4},{"$f":"IF(T4=\"\",\"\",DATE(YEAR(T4),MONTH(T4)-1,DAY(T4)))","v":"2019-01-27"},1500,"2019-02-28",1500,"2019-03-30",1500,"2019-05-01",1500,"2019-05-30"]
[1168,null,null,null,null,"يارس",2018,null,65000,45000,{"$f":"I5-J5-Q5","v":20000},null,2000,{"$f":"IFERROR((V5/M5),\"\")","v":32.5},null,8000,null,{"$f":"I5-P5","v":57000},"","2019-01-14","2021-08-31",{"$f":"I5-L5","v":65000},"",35000,{"$f":"COUNTA(AA5:HY5)-SUM(IF(TypeCell(AA5:HY5)=7,1,0))","v":4},"2018-12-14",2000,"2019-01-18",2000,"2019-02-27",2000,"2019-04-21",2000,"2019-04-21"]
[1169,null,null,null,null,"يارس",2018,null,90000,50000,{"$f":"I6-J6-Q6","v":40000},null,1500,{"$f":"IFERROR((V6/M6),\"\")","v":60},null,7500,null,{"$f":"I6-P6","v":82500},"","2019-01-27","2023-12-31",{"$f":"I6-L6","v":90000},"",45000,{"$f":"COUNTA(AA6:HY6)-SUM(IF(TypeCell(AA6:HY6)=7,1,0))","v":5},"2018-12-27",1500,"2019-01-30",1500,"2018-02-27",1500,"2019-03-30",1500,"2019-05-01",1500,"2019-05-30"]
[1170,null,null,null,null,"صني",2019,null,75000,44000,{"$f":"I7-J7-Q7","v":31000},0,1500,{"$f":"IFERROR((V7/M7),\"\")","v":50},null,4500,null,{"$f":"I7-P7","v":70500},"","2019-02-27",{"$f":"IF(T7=\"\",\"\",EOMONTH(T7,N7-1))","v":"2023-03-31"},{"$f":"I7-L7","v":75000},"",37000,{"$f":"COUNTA(AA7:HY7)-SUM(IF(TypeCell(AA7:HY7)=7,1,0))","v":3},"2019-01-27",1500,"2019-04-06",1500,"2019-04-06",1500,"2019-05-19"]
[466,null,null,"سعيد حماد عيد البذالي","0527295077","اكورد",2015,null,200000,130000,70000,0,2000,100,null,4000,null,196000,"","2019-04-27","2027-07-31",200000,"",100000,{"$f":"COUNTA(AA8:HY8)-SUM(IF(TypeCell(AA8:HY8)=7,1,0))","v":2},"2019-03-27",2000,"2019-05-23",2000,"2019-05-30"]
[467,null,null,null,null,"اكسبلور",2015,null,200000,130000,70000,0,2000,100,null,4000,null,196000,"","2019-04-27","2027-07-31",200000,"",104500,{"$f":"COUNTA(AA9:HY9)-SUM(IF(TypeCell(AA9:HY9)=7,1,0))","v":2},"2019-03-27",2000,"2019-05-23",2000,"2019-05-30"]
[468,null,null,null,null,"ازيرا + سنتافي","2013+2018",null,440000,260000,180000,null,4000,110,null,8000,null,432000,"","2019-04-27","2028-05-31",440000,"",198700,{"$f":"COUNTA(AA10:HY10)-SUM(IF(TypeCell(AA10:HY10)=7,1,0))","v":2},"2019-03-27",4000,"2019-05-23",4000,"2019-05-30"]