{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["سلطان","الجوهرة","البايونيه","الراكه","سعد","نايف","ناصر","الدمام","المتأخرين"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":26,"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":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,1,null,"سلطان",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,null,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"A"},"مع المالك",null,{"$f":"IF(سلطان!$G6<$B$4,$B$4-سلطان!$G6,0)","v":12},"لم يجدد التعاقد",null,"2018-03-18","2017-09-21",6,{"$f":"سلطان!$L6-سلطان!$K6","v":9100},{"$f":"(سلطان!$L6/$Q$3)*سلطان!$I6","v":9100},{"$f":"سلطان!$N6+سلطان!$M6","v":18200},1200,17000,1,"عصام الجمل",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"B"},"لا يوجد",null,{"$f":"IF(سلطان!$G7<$B$4,$B$4-سلطان!$G7,0)","v":0}," ",null,"2018-05-16","2018-02-16",3,{"$f":"سلطان!$L7-سلطان!$K7","v":8325},{"$f":"(سلطان!$L7/$Q$3)*سلطان!$I7","v":2775},{"$f":"سلطان!$N7+سلطان!$M7","v":11100},600,10500,2,"مبارك حسين",{"$f":"Q6+1","v":2}]
["A","مع المالك",null,{"$f":"IF(سلطان!$G8<$B$4,$B$4-سلطان!$G8,0)","v":71},null,null,"2018-01-18","2017-08-23",6,{"$f":"سلطان!$L8-سلطان!$K8","v":6300},{"$f":"(سلطان!$L8/$Q$3)*سلطان!$I8","v":6300},{"$f":"سلطان!$N8+سلطان!$M8","v":12600},600,12000,3,"عصام الجمل",{"$f":"Q7+1","v":3}]
["A",null,null,{"$f":"IF(سلطان!$G9<$B$4,$B$4-سلطان!$G9,0)","v":43189}," "," ",null," ",null,{"$f":"سلطان!$L9-سلطان!$K9","v":0},{"$f":"(سلطان!$L9/$Q$3)*سلطان!$I9","v":0},{"$f":"سلطان!$N9+سلطان!$M9","v":0},null,null,4,"فاضي",4]
["A","مع المالك",null,{"$f":"IF(سلطان!$G10<$B$4,$B$4-سلطان!$G10,0)","v":54},null,null,"2018-02-04","2017-11-07",3,{"$f":"سلطان!$L10-سلطان!$K10","v":13575},{"$f":"(سلطان!$L10/$Q$3)*سلطان!$I10","v":4525},{"$f":"سلطان!$N10+سلطان!$M10","v":18100},600,17500,5,"محمد جليل احمد",5]
["A",null,null,{"$f":"IF(سلطان!$G11<$B$4,$B$4-سلطان!$G11,0)","v":43189}," ",null,null,null,null,{"$f":"سلطان!$L11-سلطان!$K11","v":18100},{"$f":"(سلطان!$L11/$Q$3)*سلطان!$I11","v":0},{"$f":"سلطان!$N11+سلطان!$M11","v":18100},600,17500,6,"فاضي",6]
["B","مع المالك",null,{"$f":"IF(سلطان!$G12<$B$4,$B$4-سلطان!$G12,0)","v":0},null,null,"2018-04-15",null,3,{"$f":"سلطان!$L12-سلطان!$K12","v":13125},{"$f":"(سلطان!$L12/$Q$3)*سلطان!$I12","v":4375},{"$f":"سلطان!$N12+سلطان!$M12","v":17500},null,17500,7,"خالد رمزي",7]
["B","مع المالك",null,{"$f":"IF(سلطان!$G13<$B$4,$B$4-سلطان!$G13,0)","v":0},null,null,"2018-06-15","2017-12-19",6,{"$f":"سلطان!$L13-سلطان!$K13","v":8300},{"$f":"(سلطان!$L13/$Q$3)*سلطان!$I13","v":8300},{"$f":"سلطان!$N13+سلطان!$M13","v":16600},600,16000,8,"عبدالجبار خان",8]
["B","مع المالك",null,{"$f":"IF(سلطان!$G14<$B$4,$B$4-سلطان!$G14,0)","v":0},null,null,"2018-05-29","2017-12-02",6,{"$f":"سلطان!$L14-سلطان!$K14","v":8800},{"$f":"(سلطان!$L14/$Q$3)*سلطان!$I14","v":8800},{"$f":"سلطان!$N14+سلطان!$M14","v":17600},600,17000,9,"كونسيري سوزان",9]
["A",null,null,{"$f":"IF(سلطان!$G15<$B$4,$B$4-سلطان!$G15,0)","v":43189},null,null,null,null,null,{"$f":"سلطان!$L15-سلطان!$K15","v":0},{"$f":"(سلطان!$L15/$Q$3)*سلطان!$I15","v":0},{"$f":"سلطان!$N15+سلطان!$M15","v":0},null,null,10,"فاضي",10]
["A",null,null,{"$f":"IF(سلطان!$G16<$B$4,$B$4-سلطان!$G16,0)","v":43189}," ",null,null,null,null,{"$f":"سلطان!$L16-سلطان!$K16","v":0},{"$f":"(سلطان!$L16/$Q$3)*سلطان!$I16","v":0},{"$f":"سلطان!$N16+سلطان!$M16","v":0},null,null,11,"فاضي",11]
["A","مع المالك",null,{"$f":"IF(سلطان!$G17<$B$4,$B$4-سلطان!$G17,0)","v":24},null,null,"2018-03-06","2017-12-06",3,{"$f":"سلطان!$L17-سلطان!$K17","v":12450},{"$f":"(سلطان!$L17/$Q$3)*سلطان!$I17","v":4150},{"$f":"سلطان!$N17+سلطان!$M17","v":16600},600,16000,12,"حماد صالح ",12]
["B","مع المالك",null,{"$f":"IF(سلطان!$G18<$B$4,$B$4-سلطان!$G18,0)","v":0},null,null,"2018-06-28","2017-07-08",6,{"$f":"سلطان!$L18-سلطان!$K18","v":9300},{"$f":"(سلطان!$L18/$Q$3)*سلطان!$I18","v":9300},{"$f":"سلطان!$N18+سلطان!$M18","v":18600},600,18000,13,"وقار جويد محمد",13]
["A","مع المالك",null,{"$f":"IF(سلطان!$G19<$B$4,$B$4-سلطان!$G19,0)","v":42},"باقي 2700",null,"2018-02-16","2017-08-23",3,{"$f":"سلطان!$L19-سلطان!$K19","v":13950},{"$f":"(سلطان!$L19/$Q$3)*سلطان!$I19","v":4650},{"$f":"سلطان!$N19+سلطان!$M19","v":18600},600,18000,14,"شريف السيد متولى عدوى",14]
["A","مع المالك",null,{"$f":"IF(سلطان!$G20<$B$4,$B$4-سلطان!$G20,0)","v":12},"300 باقي",null,"2018-03-18","2017-03-29",6,{"$f":"سلطان!$L20-سلطان!$K20","v":9300},{"$f":"(سلطان!$L20/$Q$3)*سلطان!$I20","v":9300},{"$f":"سلطان!$N20+سلطان!$M20","v":18600},600,18000,15,"مانيش امباداس سونا واني",15]
["A","مع المالك",null,{"$f":"IF(سلطان!$G21<$B$4,$B$4-سلطان!$G21,0)","v":28},null,null,"2018-03-02","2017-09-05",6,{"$f":"سلطان!$L21-سلطان!$K21","v":9050},{"$f":"(سلطان!$L21/$Q$3)*سلطان!$I21","v":9050},{"$f":"سلطان!$N21+سلطان!$M21","v":18100},600,17500,16,"محمد مزار الدين",16]
["A","مع المالك",null,{"$f":"IF(سلطان!$G22<$B$4,$B$4-سلطان!$G22,0)","v":41},null,null,"2018-02-17","2017-11-19",3,{"$f":"سلطان!$L22-سلطان!$K22","v":13950},{"$f":"(سلطان!$L22/$Q$3)*سلطان!$I22","v":4650},{"$f":"سلطان!$N22+سلطان!$M22","v":18600},600,18000,17,"اقبال احمد سيد",17]
["A",null,null,{"$f":"IF(سلطان!$G23<$B$4,$B$4-سلطان!$G23,0)","v":43189}," "," ",null," ",null,{"$f":"سلطان!$L23-سلطان!$K23","v":0},{"$f":"(سلطان!$L23/$Q$3)*سلطان!$I23","v":0},{"$f":"سلطان!$N23+سلطان!$M23","v":0},null,null,18,"فاضي",18]
["A",null,null,{"$f":"IF(سلطان!$G24<$B$4,$B$4-سلطان!$G24,0)","v":43189}," ",null,null,null,null,{"$f":"سلطان!$L24-سلطان!$K24","v":0},{"$f":"(سلطان!$L24/$Q$3)*سلطان!$I24","v":0},{"$f":"سلطان!$N24+سلطان!$M24","v":0},null,null,19,"فاضي",19]
["B","مع المالك",null,{"$f":"IF(سلطان!$G25<$B$4,$B$4-سلطان!$G25,0)","v":0},null,null,"29/8/1439","29/5/1439",3,{"$f":"سلطان!$L25-سلطان!$K25","v":12750},{"$f":"(سلطان!$L25/$Q$3)*سلطان!$I25","v":4250},{"$f":"سلطان!$N25+سلطان!$M25","v":17000},0,17000,20,"محمد امام نضير",20]
["B","مع المالك",null,{"$f":"IF(سلطان!$G26<$B$4,$B$4-سلطان!$G26,0)","v":0},null,null,"2018-04-17","2017-10-22",6,{"$f":"سلطان!$L26-سلطان!$K26","v":10050},{"$f":"(سلطان!$L26/$Q$3)*سلطان!$I26","v":10050},{"$f":"سلطان!$N26+سلطان!$M26","v":20100},600,19500,21,"البيرتو بال ماريس ديليرا",21]
["A",null,null,{"$f":"IF(سلطان!$G27<$B$4,$B$4-سلطان!$G27,0)","v":43189}," "," ",null," ",null,{"$f":"سلطان!$L27-سلطان!$K27","v":0},{"$f":"(سلطان!$L27/$Q$3)*سلطان!$I27","v":0},{"$f":"سلطان!$N27+سلطان!$M27","v":0},null,null,"M1","فاضي",22]
["B","مع المالك",null,{"$f":"IF(سلطان!$G28<$B$4,$B$4-سلطان!$G28,0)","v":0},null,null,"2018-07-28","2017-08-07",6,{"$f":"سلطان!$L28-سلطان!$K28","v":30000},{"$f":"(سلطان!$L28/$Q$3)*سلطان!$I28","v":30000},{"$f":"سلطان!$N28+سلطان!$M28","v":60000},null,60000,"M2"," بدر خالد القلعي",23]
["A","مع المالك",null,{"$f":"IF(سلطان!$G29<$B$4,$B$4-سلطان!$G29,0)","v":73},null,null,"2018-01-16","2017-07-23",6,{"$f":"سلطان!$L29-سلطان!$K29","v":30000},{"$f":"(سلطان!$L29/$Q$3)*سلطان!$I29","v":30000},{"$f":"سلطان!$N29+سلطان!$M29","v":60000},null,60000,"M3","سليمان بن ابراهيم بن محمد الرميخاني",24]
["A","مع المالك",null,{"$f":"IF(سلطان!$G30<$B$4,$B$4-سلطان!$G30,0)","v":101},null,null,"2017-12-19","2017-06-25",6,{"$f":"سلطان!$L30-سلطان!$K30","v":31000},{"$f":"(سلطان!$L30/$Q$3)*سلطان!$I30","v":31000},{"$f":"سلطان!$N30+سلطان!$M30","v":62000},2000,60000,"M4","عصام الجمل",25]
["A","مع المالك",null,{"$f":"IF(سلطان!$G31<$B$4,$B$4-سلطان!$G31,0)","v":73},null,null,"2018-01-16","2017-07-23",6,{"$f":"سلطان!$L31-سلطان!$K31","v":36000},{"$f":"(سلطان!$L31/$Q$3)*سلطان!$I31","v":36000},{"$f":"سلطان!$N31+سلطان!$M31","v":72000},2000,70000,"M5","عبدالعزيز عبدالله الغفيلي",26]
["A","مع المالك",null,{"$f":"IF(سلطان!$G32<$B$4,$B$4-سلطان!$G32,0)","v":13},null,null,"2018-03-17","2017-12-17",3,{"$f":"سلطان!$L32-سلطان!$K32","v":15000},{"$f":"(سلطان!$L32/$Q$3)*سلطان!$I32","v":5000},{"$f":"سلطان!$N32+سلطان!$M32","v":20000},null,20000,"M6","علي بن عبدالحميد بن علي المبيوق",27]
["A","مع المالك",null,{"$f":"IF(سلطان!$G33<$B$4,$B$4-سلطان!$G33,0)","v":489},"معلق ايجارة",null,"2016-11-26","2016-08-29",3,{"$f":"سلطان!$L33-سلطان!$K33","v":15000},{"$f":"(سلطان!$L33/$Q$3)*سلطان!$I33","v":5000},{"$f":"سلطان!$N33+سلطان!$M33","v":20000},null,20000,"M7","يوسف عبدالله علي اليوسف",28]
["A","مع المالك",null,{"$f":"IF(سلطان!$G34<$B$4,$B$4-سلطان!$G34,0)","v":73},"باقي1500",null,"2018-01-16","2017-10-19",3,{"$f":"سلطان!$L34-سلطان!$K34","v":15000},{"$f":"(سلطان!$L34/$Q$3)*سلطان!$I34","v":5000},{"$f":"سلطان!$N34+سلطان!$M34","v":20000},null,20000,"M8","هاشم عبدالله الناصر",29]
[null,null,null,{"$f":"J35","v":348425},null,null," ",null,null,{"$f":"SUBTOTAL(109,سلطان!$J$6:$J$34)","v":348425},{"$f":"SUBTOTAL(109,سلطان!$K$6:$K$34)","v":241575},{"$f":"SUBTOTAL(109,سلطان!$L$6:$L$34)","v":590000},{"$f":"SUBTOTAL(109,سلطان!$M$6:$M$34)","v":13000},{"$f":"SUBTOTAL(109,سلطان!$N$6:$N$34)","v":577000}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"الجوهرة","index":1,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"الجوهرة",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,2,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"B"},1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-13","2018-01-17",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,101,"محمود سامي كمال هنداوي",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"A"},1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":3},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,102,"كريسوبي موريس ريموند تراترات",{"$f":"Q6+1","v":2}]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-09","2017-07-19",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,103,"وئل فتحي بوغولة",{"$f":"Q7+1","v":3}]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":6},null,null,"2018-03-24","2017-09-28",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,104,"حافظ بو بكر كشكار",4]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":22},null,null,"2018-03-08","2017-09-12",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,105,"عادل ابوبكر الحيدري",5]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-19","2017-10-05",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,106,"ديشان سوجيوانا سامبات وانياراشيج",6]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":64},null,null,"2018-01-25","2017-08-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,107,"سهيل يحي بحمد",7]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-24","2018-03-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},13250,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,108,"فتحي سمير محمد فتحي عرفات",8]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-03-31","2017-10-05",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,201,"كالانا سامباث جودابيتيا غادباج",9]
["A"," ",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},"مع سهيل",null,null,null,6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,202,"ماريون تيجاني",10]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":64},null,null,"2018-01-25","2017-08-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,203,"طارق دسوقى بكر درويش",11]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-27","2018-02-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,204,"حمدي يونساسماعيل علي",12]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":29},null,null,"2018-03-01","2017-09-05",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,205,"سالم توفيق علي الخالدي",13]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-22","2018-02-27",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,206,"ريتشارد فينبلس",14]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-30","2018-01-03",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,207,"أحمد صلاح حسن سر حان",15]
["A"," ",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},"مع سهيل",null,null," ",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,208,"اريك فرجر",16]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-20","2017-12-25",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,301,"نقولا اسكندر شويري",17]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":33},null,null,"2018-02-25","2017-09-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,302,"وليد حمدى حامد عبدالغفار",18]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":11},null,null,"2018-03-19","2017-09-23",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,303,"عمر ابراهيم عبدالرحمن الجلال",19]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":3},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,304,"محمد عباس       كندي",20]
["A"," ",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":"2018-03-30"},null,null,null,null,null,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":0},null,null,305,"فاضي",21]
["A",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":3},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,306,"حمد علي صالح حمزة",22]
["A",null,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,"2017-12-25",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,307,"فاضي",23]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-14","2018-01-17",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,308,"محمد عبد اموجود عبد اغفار العفناوى",24]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-25","2017-10-30",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13750},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13750},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":27500},500,27000,401,"بندر بن رافع بن عبدالله اللا حق القرني",25]
["A"," ",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},"مع سهيل",null,null,null,6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16000},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16000},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32000},null,32000,402,"محمد محمود الحاج",26]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-28","2018-02-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,403,"خالد الطاهر قاسمي",27]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-15","2017-11-19",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":13250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":13250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,404,"يوسف نقولا متري",28]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-24","2018-03-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":16250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":16250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,405,"عمر فتح المعالج",29]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-21","2018-01-25",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المطلوب]]","v":14250},{"$f":"(Table13[[#This Row],[الإجمالي]]/$Q$3)*Table13[[#This Row],[     طريقة الدفع]]","v":14250},{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":28500},500,28000,406,"معجب بن محمد القحطاني",30]
[null,null,null,{"$f":"Table13[[#Totals],[         الباقي]]","v":427500},null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13[[         الباقي]])","v":427500},{"$f":"SUBTOTAL(109,Table13[المطلوب])","v":427500},{"$f":"SUBTOTAL(109,Table13[الإجمالي])","v":855000},{"$f":"SUBTOTAL(109,Table13[ماء])","v":14000},{"$f":"SUBTOTAL(109,Table13[[     ألأيجار]])","v":841000}]

{"sheet":"البايونيه","index":2,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"البايونيه",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,3,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"B"},"بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"باقي 600",null,"2018-08-20","2017-09-01",12,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":10600},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":10600},600,10000,1,"ملوين و التر داليما",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"B"},"بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"باقي 600",null,"2018-10-19","2017-10-30",12,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":10600},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":10600},600,10000,2,"سيد محمد بانا",{"$f":"Q6+1","v":2}]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-14"," ",6,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":6300},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":6300},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":12600},600,12000,3,"مانوج تايبارامبو سيفاداس",{"$f":"Q7+1","v":3}]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-15","2017-09-21",{"$f":"246.769811320755/30","v":8.2256603773584995},{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":3333.9999999999918},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":7266.0000000000082},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":10600},600,10000,4,"مجاهد علي محمد",4]
["A","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":269},null,null,"2017-07-04"," ",12,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":13200},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":13200},200,13000,5,"صديق مباكران",5]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-10","2017-11-14",6,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":6300},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":6300},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":12600},600,12000,6,"داس ناريان ناير",6]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-24","2017-10-29",6,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":5300},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":5300},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":10600},600,10000,7,"عبدالودود محمد علي",7]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-22","2018-01-26",6,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":6300},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":6300},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":12600},600,12000,8,"عبدالقادر حسن باقيس",8]
["A",null,null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":0},null,null,"M1","فاضي",9]
["A",null,null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":0},null,null,"M2","فاضي",10]
["A","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":29},"يتحمل جميع الخدمات",null,"2018-03-01","2017-09-01",6,{"$f":"Table134[[#This Row],[الإجمالي]]-Table134[[#This Row],[المطلوب]]","v":78000},{"$f":"(Table134[[#This Row],[الإجمالي]]/$Q$3)*Table134[[#This Row],[     طريقة الدفع]]","v":78000},{"$f":"Table134[[#This Row],[     ألأيجار]]+Table134[[#This Row],[ماء]]","v":156000},null,156000,"الثقبه","شركة سارة المتحدة(يحيي السخاوي)",11]
["A",null,null,{"$f":"Table134[[#Totals],[المطلوب]]","v":143866},null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table134[المطلوب])","v":143866},{"$f":"SUBTOTAL(109,Table134[الإجمالي])","v":249400},{"$f":"SUBTOTAL(109,Table134[ماء])","v":4400},{"$f":"SUBTOTAL(109,Table134[[     ألأيجار]])","v":245000}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"الراكه","index":3,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"الراكه",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,3,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"A"},null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":29},null,null,"2018-03-01",null,12,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":22600},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":22600},600,22000,1,"إبراهيم المهنا",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"B"},null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-24",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20600},600,20000,2,"محمد",{"$f":"Q6+1","v":2}]
["B",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"يتحمل كهرباء الماتور",null,"2018-06-17",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10000},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10000},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20000},null,20000,3,"مازن وهيب حمزه",{"$f":"Q7+1","v":3}]
["A",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":72},null,null,"2018-01-17",null,12,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":23300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":23300},300,23000,4,"ناصر مروان حمود",4]
["B",1000,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-25",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20600},600,20000,5,"ارشاد علي محمد عثمان",5]
["A",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":13},null,null,"2018-03-17",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20600},600,20000,6,"رانجيت ناير",6]
["B",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-11",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20600},600,20000,7,"نزار مهدى خان",7]
["A",1000,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":2},null,null,"2018-03-28",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":10300},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":20600},600,20000,8,"اوفايل كاروناي فاروق",8]
["B",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"باقي 500",null,"2018-04-28",null,6,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":5250},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":5250},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":10500},500,10000,9,"محمد قاسم شيخ علي",9]
["A",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":0},null,null,null,null,10]
["A",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13412[[#This Row],[الإجمالي]]-Table13412[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13412[[#This Row],[الإجمالي]]/$Q$3)*Table13412[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13412[[#This Row],[     ألأيجار]]+Table13412[[#This Row],[ماء]]","v":0},null,null,null,null,11]
["A",null,null,{"$f":"Table13412[[#Totals],[المطلوب]]","v":112650},null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13412[المطلوب])","v":112650},{"$f":"SUBTOTAL(109,Table13412[الإجمالي])","v":179400},{"$f":"SUBTOTAL(109,Table13412[ماء])","v":4400},{"$f":"SUBTOTAL(109,Table13412[[     ألأيجار]])","v":175000},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B",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":"#REF!","v":{"$error":"#REF!"}}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"سعد","index":4,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"سعد",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,5,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"A"},1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":33},null,null,"2018-02-25","2017-11-28",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":9975},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":3325},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":13300},300,13000,101,"ابنوسيدبين مسحليحات",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"A"},null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":19},null,null,"2018-03-11","2017-03-23",12,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":17000},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":17000},null,17000,102,"احمد عبد الرحيم",{"$f":"Q6+1","v":2}]
["A",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":24},null,null,"2018-03-06","2017-12-07",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":16125},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":5375},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":21500},500,21000,103,"المريت ديلا نافاريت",{"$f":"Q7+1","v":3}]
["A",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":50},null,null,"2018-02-08","2017-11-11",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":10500},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":3500},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":14000},null,14000,104,"فيسينت مير جاميو",4]
["B",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"له 250",null,"2018-07-03","2017-07-13",6,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":5125},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":5125},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":10250},250,10000,105,"عبيداوي ابو لا كاندي",5]
["B",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-03","2017-07-13",6,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":7625},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":7625},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":15250},250,15000,106,"عبيداوي ابو لا كاندي",6]
["B",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"باقي 2750",null,"2018-06-20","2017-09-26",6,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":8625},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":8625},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":17250},250,17000,107,"حسين صديق",7]
["B",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-20","2017-09-26",6,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":4125},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":4125},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":8250},250,8000,108,"حسين صديق",8]
["B",2000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2019-01-15","2018-01-27",12,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":36500},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":36500},500,36000,201,"l b c express",9]
["A",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null," ",null,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":0},null,null,202,"l b c express",10]
["A",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":0},null,null,203,"فاضي",11]
["A",500,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":19},null,null,"2018-03-11","2017-09-14",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":7650},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":2550},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":10200},200,10000,204,"جاريل ماني كادو استاسيو",12]
["B",500,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-03-31","2017-12-03",4,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":6866.6666666666661},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":3433.3333333333335},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":10300},300,10000,205,"عبدالسلام  كوتيكودين",13]
["A",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null," ",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":0},null,null,206,"فاضي",14]
["A"," ",null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":19},null,null,"2018-03-11","2017-03-23",12,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":17000},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":17000},0,17000,207,"احمد عبد الرحيم",15]
["A",500,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":6},null,null,"2018-03-24","2017-12-26",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":7725},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":2575},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":10300},300,10000,208,"حمزة صابر محمد صابر",16]
["A"," ",null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},"  ",null,null," ",null,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":0},0,null,301,"فاضي",17]
["A",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":112},null,null,"2017-12-08","2017-09-11",3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":9225},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":3075},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":12300},300,12000,302,"راشد غفور",18]
["A",null,null,{"$f":"Table1348910[[#Totals],[المطلوب]]","v":119833.33333333333},null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1348910[المطلوب])","v":119833.33333333333},{"$f":"SUBTOTAL(109,Table1348910[الإجمالي])","v":213400},{"$f":"SUBTOTAL(109,Table1348910[ماء])","v":3400},{"$f":"SUBTOTAL(109,Table1348910[[     ألأيجار]])","v":210000}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"نايف","index":5,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"نايف",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,6,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"A"},null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":5},null,null,"2018-03-25","2017-12-26",3,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":4200},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":1400},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":5600},null,5600,1,"جويل سار اندينا",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"B"},null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-01","2017-08-01",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":16500},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":1500},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":18000},null,18000,2,"غوبال كريشنان ناير",{"$f":"Q6+1","v":2}]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":67},"باقي  300",null,"2018-01-22","2017-09-25",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":7150},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":650},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7800},null,7800,3,"دبيدار زايد",{"$f":"Q7+1","v":3}]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":23},null,null,"2018-03-07","2018-02-05",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":7700},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":700},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":8400},null,8400,4,"محمد عقيل ناشر",4]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":54},null,null,"2018-02-04","2018-01-05",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,5,"حنيف الله سيد جان",5]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":12},"بدون كهرباء",null,"2018-03-18","2018-01-18",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":6600},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":600},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7200},null,7200,6,"باتيل عبدالمجيد بهايجي",6]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"بدون كهرباء",null,"2018-06-30","2018-01-03",6,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":3560},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":3560},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7120},null,7120,7,"محمد ارشد",7]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0}," ",null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":5500},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":500},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":6000},null,6000,8," فاضي",8]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":30}," ",null,"2018-02-28","2018-01-30",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":7700},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":700},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":8400},null,8400,9,"علوي محمد حسن مديحج",9]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":7700},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":700},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":8400},null,8400,10,"فاضي",10]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,11,"فاضي",11]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":71}," ",null,"2018-01-18","2017-10-21",3,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":5400},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":1800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7200},null,7200,12,"تانوير عباس",12]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":6600},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":600},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7200},null,7200,13,"فاضي",13]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":6600},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":600},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7200},null,7200,14,"فاضي",14]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0}," ",null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":6600},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":600},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":7200},null,7200,15,"فاضي",15]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null," "," ",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,16,"فاضي",16]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":26},null,null,"2018-03-04","2018-02-02",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":4950},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":450},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":5400},null,5400,17,"محمد عوض القرادي",17]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":41},null,null,"2018-02-17","2018-01-18",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,18,"سيرتين بيرتين جان سيروموني",18]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":56},"بدون كهرباء",null,"2018-02-02","2018-01-03",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":9900},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":900},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":10800},null,10800,19,"جوني جوزيف راج",19]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":31},"بدون كهرباء","750 شهريا","2018-02-27","2017-12-28",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,20,"جوس راجبان راجبان",20]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":41},null,null,"2018-02-17","2017-10-29",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":5500},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":500},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":6000},null,6000,21,"عوض الله بن مرزوق ",21]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":86},null,null,"2018-01-03","2017-12-04",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":5500},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":500},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":6000},null,6000,22,"محمد بن مزين غنام السبيعي",22]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":307}," ",null,"2017-05-27","2017-04-27",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9600},null,9600,23,"حلمي عبدالقوي صالح بن هرهره",23]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":122},"باقي 220",null,"2017-11-28","2017-10-30",1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":12833.333333333334},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":1166.6666666666667},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":14000},null,14000,"M1","علي بن مشلح بن مقحم الصعيري المطيري",24]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-05-03","2017-11-06",3,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":9000},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":3000},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":12000},null,12000,"M2","عبدالعزيز ابراهيم عبدالمحس",25]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},"باقي 1900",null,"2018-05-16","2017-11-19",6,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":5500},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":5500},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":11000},null,11000,"M3","سارة بنت عبدالحميد بن المبيوق",26]
["A",null,null,{"$f":"Table13489[[#Totals],[المطلوب]]","v":30726.666666666668},null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13489[المطلوب])","v":30726.666666666668},{"$f":"SUBTOTAL(109,Table13489[الإجمالي])","v":228520},{"$f":"SUBTOTAL(109,Table13489[ماء])","v":0},{"$f":"SUBTOTAL(109,Table13489[[     ألأيجار]])","v":228520}]
["B"]
["B"]
["B"]

{"sheet":"ناصر","index":6,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"ناصر",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,9,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6>0,\"A\",\"B\")","v":"A"},1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":48},null,null,"2018-02-10","2017-08-16",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":10250},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":10250},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":20500},500,20000,1,"فيجا يا كومارسوبر اما نيان",1]
[{"$f":"IF(D7>0,\"A\",\"B\")","v":"A"},1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":11},null,null,"2018-03-19","2017-09-22",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":11500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":11500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":23000},500,22500,2,"فينكاتيسوارلو فيماساني",{"$f":"Q6+1","v":2}]
["B",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2019-02-07","2018-02-17",12,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":18600},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":18600},600,18000,3,"نيليش كيشور ايلاني",{"$f":"Q7+1","v":3}]
["A",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":50},null,null,"2018-02-08","2017-08-14",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":8750},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":8750},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":17500},500,17000,4,"سوبراتو ادهيكاري",4]
["A",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":38},null,null,"2018-02-20","2017-08-26",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":10250},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":10250},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":20500},500,20000,5,"نيهرو سيغالي نيتاجي",5]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,6,"فاضي",6]
["A",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":48},null,null,"2018-02-10","2017-08-16",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":11250},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":11250},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":22500},500,22000,7,"جيش غوبتا سومش",7]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":500},500,null,8,"فاضي",8]
["A"," ",null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":2},"دفع 6000 باقي 5750",null,"2018-03-28","2017-10-01",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":11750},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":11750},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":23500},500,23000,9,"ابراهيم محمد الشافعي",9]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,9,"فاضي",10]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,10,"فاضي",11]
["B"," ",null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-21","2018-01-21",null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":20500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":20500},500,20000,12,"ناجي مسعد احمد المضرحي",12]
["A","بدون",null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":71},null,null,"2018-01-18","2017-07-24",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":20000},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":20000},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":40000},0,40000,"M1","محمودعبدالله الحجازي",13]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,"M2","فاضي",14]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,"M3","فاضي",15]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,null,null,null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":0},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":0},null,null,"M4","فاضي",16]
["A",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":190},null,null,"2017-09-21","2017-03-28",6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":17500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":17500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":35000},0,35000,"M5","أحمد محمد العميري",17]
["A",null,null,{"$f":"Table13489567[[#Totals],[المطلوب]]","v":119850},null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13489567[المطلوب])","v":119850},{"$f":"SUBTOTAL(109,Table13489567[الإجمالي])","v":242100},{"$f":"SUBTOTAL(109,Table13489567[ماء])","v":4600},{"$f":"SUBTOTAL(109,Table13489567[[     ألأيجار]])","v":237500}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"الدمام","index":7,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[null,"أملاك الخبر للعقار                                                                                                                                "]
[]
["A",{"$f":"TODAY()","v":"2018-03-30"},"تاريخ الهجري",null,null,null,null,"بناية عبد الرحيم شارع الأمير الدمام",null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-30"},"الموافق",null,null,7,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المطلوب دفعه","    تاريخ الانتهاء","ايجار يومي","     طريقة الدفع","         الباقي","المطلوب","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6<1000,IF(D6>0,\"A\",\"B\"),\"c\")","v":"B"},150,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-01",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":16.666666666666668},2,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5000},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":1000},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6000},null,6000,"G-1","عبدالله مون نصيراول حق",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"A"},"بدون تأمين",null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":208},"شامل مياة وكهرباء",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":5546.666666666667},"2017-09-03",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":26.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":9600},null,9600,"G-2","نوشاد عبد الصمد",{"$f":"Q6+1","v":2}]
["A",250,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":18},"باقي 160",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":318},"2018-03-12",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":17.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5830},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":530},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6360},null,6360,"G-3","محمد ثاقب محمد عاصف خان",3]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,"G-4","فاضي",4]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,"G-5","فاضي",5]
["B",300,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-18",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":14.333333333333334},3,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":3870},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":1290},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":5160},null,5160,"G-6","محمد شريف عبدالغني",6]
["A",250,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":19},553043849,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":285},"2018-03-11",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":15},2,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":4500},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":900},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":5400},null,5400,101,"محمد عزيزالدين",7]
["A",270,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":5},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":88.333333333333343},"2018-03-25",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":17.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5830},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":530},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6360},null,6360,102,"شاجو جليل",8]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,103,"فاضي",9]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,104,"فاضي",10]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,105,"فاضي",11]
["A",270,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":34},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":600.66666666666674},"2018-02-24",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":17.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5830},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":530},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6360},null,6360,106,"نرول حقي رحمن",12]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,107,"فاضي",13]
["B",300,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-01",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":15},3,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":4050},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":1350},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":5400},null,5400,201,"مايش كومار غوبتا",14]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,202,"فاضي",15]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},"باقي 4000",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,203,"فاضي",16]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189}," ",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,204,"فاضي",17]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189}," ",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,205,"فاضي",18]
["A","بدون تأمين",null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":4},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":70.666666666666671},"2018-03-26",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":17.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5830},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":530},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6360},null,6360,206,"عامر سلام محمد عبدالسلام",19]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,207,"فاضي",20]
["B",200,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":0}," ",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-01",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":15},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":4950},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":450},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":5400},null,5400,301,"زيشان حافيظ الله",21]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,302,"فاضي",22]
["B",300,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-01",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":17.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":5830},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":530},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":6360},null,6360,303,"رنجان  بالا",23]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,304,"فاضي",24]
["A","بدون تأمين",null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":12},"شامل مياة وكهرباء",{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":320},"2018-03-18",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":26.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":8800},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":800},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":9600},null,9600,305,"رشيد محمود محمد ",25]
["c",null,null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43189},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":0},null,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":0},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":0},null,null,306,"فاضي",26]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table134895[المطلوب])","v":9240},{"$f":"SUBTOTAL(109,Table134895[الإجمالي])","v":78360},{"$f":"SUBTOTAL(109,Table134895[ماء])","v":0},{"$f":"SUBTOTAL(109,Table134895[[     ألأيجار]])","v":78360}]

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