{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["سلطان","الجوهرة","البايونيه","الراكه","سعد","نايف","الدمام","الحزام","ناصر","منوع","سند قبض"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,7,2,10],[0,1,1,16]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-26"},"تاريخ الهجري",null,null,1,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,null,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":"A"},"مع المالك",504840071,{"$f":"IF(سلطان!$G6<$B$4,$B$4-سلطان!$G6,0)","v":8},null,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":"O6","v":1}]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"B"},"لا يوجد",538616819,{"$f":"IF(سلطان!$G7<$B$4,$B$4-سلطان!$G7,0)","v":0},null,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},{"$f":"O7","v":2}]
["A","مع المالك",504840071,{"$f":"IF(سلطان!$G8<$B$4,$B$4-سلطان!$G8,0)","v":67},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},3]
["c",null,null,{"$f":"IF(سلطان!$G9<$B$4,$B$4-سلطان!$G9,0)","v":43185},null," ",null," ",null,{"$f":"سلطان!$L9-سلطان!$K9","v":0},{"$f":"(سلطان!$L9/$Q$3)*سلطان!$I9","v":0},{"$f":"سلطان!$N9+سلطان!$M9","v":0},null,null,4,"فاضي",4,4]
["B","مع المالك",542179632,{"$f":"IF(سلطان!$G10<$B$4,$B$4-سلطان!$G10,0)","v":0},null,null,"2018-05-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,5]
["c",null,null,{"$f":"IF(سلطان!$G11<$B$4,$B$4-سلطان!$G11,0)","v":43185},null,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,6]
["B","مع المالك",506217530,{"$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,7]
["B","مع المالك",530127427,{"$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,8]
["B","مع المالك",503802665,{"$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,9]
["c",null,null,{"$f":"IF(سلطان!$G15<$B$4,$B$4-سلطان!$G15,0)","v":43185},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,10]
["c",null,null,{"$f":"IF(سلطان!$G16<$B$4,$B$4-سلطان!$G16,0)","v":43185},null,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,11]
["A","مع المالك",null,{"$f":"IF(سلطان!$G17<$B$4,$B$4-سلطان!$G17,0)","v":20},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,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,13]
["A","مع المالك",null,{"$f":"IF(سلطان!$G19<$B$4,$B$4-سلطان!$G19,0)","v":38},null,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,14]
["A","مع المالك",null,{"$f":"IF(سلطان!$G20<$B$4,$B$4-سلطان!$G20,0)","v":8},null,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,15]
["B","مع المالك",null,{"$f":"IF(سلطان!$G21<$B$4,$B$4-سلطان!$G21,0)","v":0},null,null,"2018-05-29","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,16]
["B","مع المالك",null,{"$f":"IF(سلطان!$G22<$B$4,$B$4-سلطان!$G22,0)","v":0},null,null,"2018-05-15","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,17]
["c",null,null,{"$f":"IF(سلطان!$G23<$B$4,$B$4-سلطان!$G23,0)","v":43185},null," ",null," ",null,{"$f":"سلطان!$L23-سلطان!$K23","v":0},{"$f":"(سلطان!$L23/$Q$3)*سلطان!$I23","v":0},{"$f":"سلطان!$N23+سلطان!$M23","v":0},null,null,18,"فاضي",18,18]
["c",null,null,{"$f":"IF(سلطان!$G24<$B$4,$B$4-سلطان!$G24,0)","v":43185},null,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,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,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,21]
["c",null,null,{"$f":"IF(سلطان!$G27<$B$4,$B$4-سلطان!$G27,0)","v":43185},null," ",null," ",null,{"$f":"سلطان!$L27-سلطان!$K27","v":0},{"$f":"(سلطان!$L27/$Q$3)*سلطان!$I27","v":0},{"$f":"سلطان!$N27+سلطان!$M27","v":0},null,null,"M1","فاضي",22,"M1"]
["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,"M2"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G29<$B$4,$B$4-سلطان!$G29,0)","v":69},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,"M3"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G30<$B$4,$B$4-سلطان!$G30,0)","v":97},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,"M4"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G31<$B$4,$B$4-سلطان!$G31,0)","v":69},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,"M5"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G32<$B$4,$B$4-سلطان!$G32,0)","v":9},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,"M6"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G33<$B$4,$B$4-سلطان!$G33,0)","v":485},null,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,"M7"]
["A","مع المالك",null,{"$f":"IF(سلطان!$G34<$B$4,$B$4-سلطان!$G34,0)","v":69},null,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,"M8"]
["B",null,null,null,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},null,null,null,0]

{"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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,2,null,null,null,"جوال=",null,null,null,null,null,"المحلات الفارغه"]
[{"$f":"IF(D5>0,\"A\",\"B\")","v":"A"},"تأمين","   رقم الجوال","عدد أيام تأخير","     ملاحظات","المدفوع","    تاريخ الانتهاء","      تاريخ ابتداءالايجار","     طريقة الدفع","         الباقي","المدفوع2","الإجمالي","ماء","     ألأيجار","    رقم الشقة","        اسم المستأجر","     الرقم"]
[{"$f":"IF(D6<1000,IF(D6>0,\"A\",\"B\"),\"c\")","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],[المدفوع2]]","v":13000},13500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,101,"محمود سامي كمال هنداوي",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"B"},1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":16000},16500,{"$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":2},null,null,"2018-03-24","2017-09-28",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":13000},13500,{"$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":18},null,null,"2018-03-08","2017-09-12",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":16000},16500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,106,"ديشان سوجيوانا سامبات وانياراشيج",6]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-21","2017-08-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":13000},13500,{"$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":70},null,null,"2018-01-15","2017-07-15",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16500},16000,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,202,"ماريون تيجاني",10]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-07-20","2017-08-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":13000},13500,{"$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":25},null,null,"2018-03-01","2017-09-05",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":16000},16500,{"$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":25},null,null,"2018-03-01",null,6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":15100},11400,{"$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],[المدفوع2]]","v":13000},13500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,301,"نقولا اسكندر شويري",17]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-20","2017-09-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$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":7},null,null,"2018-03-19","2017-09-23",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,303,"عمر ابراهيم عبدالرحمن الجلال",19]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":13000},13500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":26500},500,26000,304,"محمد عباس       كندي",20]
["c"," ",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,null,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","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]
["B",1000,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-03-27","2017-10-01",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,32000,306,"حمد علي صالح حمزة",22]
["c",null,null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":13500},14000,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":27500},500,27000,401,"بندر بن رافع بن عبدالله اللا حق القرني",25]
["B","بدون",null,{"$f":"IF(Table13[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-06","2017-08-06",6,{"$f":"Table13[[#This Row],[الإجمالي]]-Table13[[#This Row],[المدفوع2]]","v":500},32000,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":32500},500,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],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":13000},13500,{"$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],[المدفوع2]]","v":16000},16500,{"$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],[المدفوع2]]","v":14000},14500,{"$f":"Table13[[#This Row],[     ألأيجار]]+Table13[[#This Row],[ماء]]","v":28500},500,28000,406,"معجب بن محمد القحطاني",30]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13[المدفوع2])","v":447900},{"$f":"SUBTOTAL(109,Table13[الإجمالي])","v":855500},{"$f":"SUBTOTAL(109,Table13[ماء])","v":14500},{"$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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,3,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"},"بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,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<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"B"},"بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,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":265},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]
["c",null,null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["c",null,null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["B","بدون تأمين",null,{"$f":"IF(Table134[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-09-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]
["B",null,null,null,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":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,3,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":"A"},null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":25},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<1000,IF(D7>0,\"A\",\"B\"),\"c\")","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,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":68},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":9},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]
["B",1000,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":0},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},null,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]
["c",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["c",null,null,{"$f":"IF(Table13412[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13412[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["B",null,null,null,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}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"سعد","index":4,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,5,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"},500,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-01",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":28.611111111111111},null,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":10300},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":10300},300,10000,101,"مارتيس سيلفان دانيل",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"A"},null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":15},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-03-11",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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}]
["B",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-06-01",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":40.625},3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":14625},{"$f":"(Table1348910[[#This Row],[الإجمالي]]/$Q$3)*Table1348910[[#This Row],[     طريقة الدفع]]","v":4875},{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":19500},null,19500,103,"المريت ديلا نافاريت",{"$f":"Q7+1","v":3}]
["A",1000,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":46},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":1341.6666666666667},"2018-02-08",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":29.166666666666668},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},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-07-03",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":14.236111111111111},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,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-07-03",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":21.180555555555557},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},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-06-20",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":23.958333333333332},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,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-06-20",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":11.458333333333334},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,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2019-01-15",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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]
["B",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2019-01-15",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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]
["c",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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":15},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":318.75},"2018-03-11",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":21.25},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,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-03-31",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":19.074074074074073},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]
["c",null,null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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":15},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},"2018-03-11",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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":2},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":42.916666666666664},"2018-03-24",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":21.458333333333332},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]
["c"," ",null,{"$f":"IF(Table1348910[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348910[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":0},null,{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":0},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":108},null,{"$f":"IF(Table1348910[[#This Row],[عدد أيام تأخير]]>0,Table1348910[[#This Row],[عدد أيام تأخير]]*Table1348910[[#This Row],[ايجار يومي]],0)","v":2790},"2017-12-08",{"$f":"Table1348910[[#This Row],[         الباقي]]/360","v":25.833333333333332},3,{"$f":"Table1348910[[#This Row],[الإجمالي]]-Table1348910[[#This Row],[المطلوب]]","v":9300},3000,{"$f":"Table1348910[[#This Row],[     ألأيجار]]+Table1348910[[#This Row],[ماء]]","v":12300},300,12000,302,"راشد غفور",18]
[{"$f":"IF(D25<1000,IF(D25>0,\"A\",\"B\"),\"c\")","v":"B"},null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1348910[المطلوب])","v":115933.33333333333},{"$f":"SUBTOTAL(109,Table1348910[الإجمالي])","v":208400},{"$f":"SUBTOTAL(109,Table1348910[ماء])","v":2900},{"$f":"SUBTOTAL(109,Table1348910[[     ألأيجار]])","v":205500}]
[{"$f":"IF(D26<1000,IF(D26>0,\"A\",\"B\"),\"c\")","v":"B"}]
[{"$f":"IF(D27<1000,IF(D27>0,\"A\",\"B\"),\"c\")","v":"B"}]
[{"$f":"IF(D28<1000,IF(D28>0,\"A\",\"B\"),\"c\")","v":"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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,6,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"},null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-03-26",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":15.555555555555555},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<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"B"},null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-05-01",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":50},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":34},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":736.66666666666674},"2018-02-20",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":21.666666666666668},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}]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-05",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":23.333333333333332},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":50},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1333.3333333333335},"2018-02-04",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":26.666666666666668},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]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-16",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":20},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,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-06-30",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":19.777777777777779},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,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0}," ",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":16.666666666666668},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]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-03-29",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":21.666666666666668},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,9,"علوي محمد حسن مديحج",9]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1007650},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":23.333333333333332},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]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1151600},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":26.666666666666668},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":67},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1340},"2018-01-18",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":20},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]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":863700},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":20},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]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":863700},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":20},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]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":863700},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":20},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]
["c",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1151600},null,{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":26.666666666666668},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]
["B",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-04-02",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":15},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":9},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":195},"2018-03-17",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":21.666666666666668},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,18,"سيرتين بيرتين جان سيروموني",18]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":52},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1560},"2018-02-02",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":30},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":27},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":675},"2018-02-27",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":25},1,{"$f":"Table13489[[#This Row],[الإجمالي]]-Table13489[[#This Row],[المطلوب]]","v":8250},{"$f":"(Table13489[[#This Row],[الإجمالي]]/$Q$3)*Table13489[[#This Row],[     طريقة الدفع]]","v":750},{"$f":"Table13489[[#This Row],[     ألأيجار]]+Table13489[[#This Row],[ماء]]","v":9000},null,9000,20,"جوس راجبان راجبان",20]
["A",null,null,{"$f":"IF(Table13489[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489[[#This Row],[    تاريخ الانتهاء]],0)","v":37},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":616.66666666666674},"2018-02-17",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":16.666666666666668},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":82},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":1366.6666666666667},"2018-01-03",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":16.666666666666668},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":303},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":8080},"2017-05-27",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":26.666666666666668},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":118},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":4588.8888888888887},"2017-11-28",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":38.888888888888886},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,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-05-03",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":33.333333333333336},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},null,{"$f":"IF(Table13489[[#This Row],[عدد أيام تأخير]]>0,Table13489[[#This Row],[عدد أيام تأخير]]*Table13489[[#This Row],[ايجار يومي]],0)","v":0},"2018-05-16",{"$f":"Table13489[[#This Row],[     ألأيجار]]/360","v":30.555555555555557},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]
["B",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13489[المطلوب])","v":30476.666666666668},{"$f":"SUBTOTAL(109,Table13489[الإجمالي])","v":225520},{"$f":"SUBTOTAL(109,Table13489[ماء])","v":0},{"$f":"SUBTOTAL(109,Table13489[[     ألأيجار]])","v":225520}]
["B"]
["B"]
["B"]

{"sheet":"الدمام","index":6,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,1,16],[2,7,2,10]]}
[]
[]
["A",{"$f":"TODAY()","v":"2018-03-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",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":204},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":5440},"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":14},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":247.33333333333334},"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":43185},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":43185},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":15},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":225},"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":1},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":17.666666666666668},"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":43185},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":43185},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":43185},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":30},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":530},"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":43185},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":43185},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":762935},null,{"$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,202,"فاضي",15]
["A","بدون تأمين",null,{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":156},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":3536},"2017-10-21",{"$f":"Table134895[[#This Row],[الإجمالي]]/360","v":22.666666666666668},1,{"$f":"Table134895[[#This Row],[الإجمالي]]-Table134895[[#This Row],[المطلوب]]","v":7480},{"$f":"(Table134895[[#This Row],[الإجمالي]]/$Q$3)*Table134895[[#This Row],[     طريقة الدفع]]","v":680},{"$f":"Table134895[[#This Row],[     ألأيجار]]+Table134895[[#This Row],[ماء]]","v":8160},null,8160,203,"ارفد فاندشال ابراهيم كنومال",16]
["c",null," ",{"$f":"IF(Table134895[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table134895[[#This Row],[    تاريخ الانتهاء]],0)","v":43185}," ",{"$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":43185}," ",{"$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]
["B","بدون تأمين",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-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":43185},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},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},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":43185},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":43185},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":8},null,{"$f":"IF(Table134895[[#This Row],[عدد أيام تأخير]]>0,Table134895[[#This Row],[عدد أيام تأخير]]*Table134895[[#This Row],[ايجار يومي]],0)","v":213.33333333333334},"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":43185},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":9920},{"$f":"SUBTOTAL(109,Table134895[الإجمالي])","v":86520},{"$f":"SUBTOTAL(109,Table134895[ماء])","v":0},{"$f":"SUBTOTAL(109,Table134895[[     ألأيجار]])","v":86520}]

{"sheet":"الحزام","index":7,"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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,8,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":"c"},null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  1","فاضي",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"c"},null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":2500},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":2500},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":5000},null,5000,"محل رقم  2","شيخه ناصر قاسي القحطاني",{"$f":"Q6+1","v":2}]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":20000},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":20000},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":40000},null,40000,"محل رقم 3 ","عماد احمد صالح الغامدي",{"$f":"Q7+1","v":3}]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,"2017-12-26",6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":25000},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":25000},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":50000},null,50000,"محل رقم  4","ماهر بن عبدالعزيز بن تاصر العقيل",4]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null," ",6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  5","فاضي",5]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null," ",6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":22500},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":22500},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":45000},null,45000,"محل رقم  6","زياد بن عبدالعزيزبن عبجالله الملحم",6]
["B",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-12","2018-02-17",6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":35000},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":35000},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":70000},null,70000,"محل رقم  7","زياد بن عبدالعزيزبن عبجالله الملحم",7]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  8","عبير بنت عبدالخالق سعيد الغامدي",8]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  9","عبير بنت عبدالخالق سعيد الغامدي",9]
["c",null,null,{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  10","عبير بنت عبدالخالق سعيد الغامدي",10]
["c",null," ",{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0},null,null,"محل رقم  11","عبير بنت عبدالخالق سعيد الغامدي",11]
["c",null," ",{"$f":"IF(Table1348956[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,6,{"$f":"Table1348956[[#This Row],[الإجمالي]]-Table1348956[[#This Row],[المطلوب]]","v":0},{"$f":"(Table1348956[[#This Row],[الإجمالي]]/$Q$3)*Table1348956[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956[[#This Row],[     ألأيجار]]+Table1348956[[#This Row],[ماء]]","v":0}]
["B",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1348956[المطلوب])","v":105000},{"$f":"SUBTOTAL(109,Table1348956[الإجمالي])","v":210000},{"$f":"SUBTOTAL(109,Table1348956[ماء])","v":0},{"$f":"SUBTOTAL(109,Table1348956[[     ألأيجار]])","v":210000}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"ناصر","index":8,"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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,9,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"},1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-06",null,6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":9500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":9500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":19000},null,19000,1,"سيرش شندرا بحرة",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"A"},1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":7},null,null,"2018-03-19",null,6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":9500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":9500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":19000},null,19000,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",null,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}]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,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]
["B",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2019-03-21",null,6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":9500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":9500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":19000},null,19000,5,"نيهرو سيغالي نيتاجي",5]
["B",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-09-13",null,null,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":19000},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":19000},null,19000,6,"شاندرا سكار",6]
["B",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-08-05",null,6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":9500},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":9500},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":19000},null,19000,7,"جيش غوبتا سومش",7]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["B",1000,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-09-21",null,6,{"$f":"Table13489567[[#This Row],[الإجمالي]]-Table13489567[[#This Row],[المطلوب]]","v":10750},{"$f":"(Table13489567[[#This Row],[الإجمالي]]/$Q$3)*Table13489567[[#This Row],[     طريقة الدفع]]","v":10750},{"$f":"Table13489567[[#This Row],[     ألأيجار]]+Table13489567[[#This Row],[ماء]]","v":21500},1500,20000,9,"ابراهيم محمد الشافعي",9]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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,"فاضي",10]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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,11,"فاضي",11]
["B","بدون",null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-21",null,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":67},null,null,"2018-01-18",null,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]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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]
["c",null,null,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},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,{"$f":"IF(Table13489567[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table13489567[[#This Row],[    تاريخ الانتهاء]],0)","v":186},null,null,"2017-09-21",null,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]
["B",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table13489567[المطلوب])","v":113600},{"$f":"SUBTOTAL(109,Table13489567[الإجمالي])","v":248600},{"$f":"SUBTOTAL(109,Table13489567[ماء])","v":3600},{"$f":"SUBTOTAL(109,Table13489567[[     ألأيجار]])","v":245000}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"منوع","index":9,"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-26"},"تاريخ الهجري",null,null,null,null,null,null,null,null,null,null,null,null,"الشقق الفارغه",12]
["A",{"$f":"TODAY()","v":"2018-03-26"},"الموافق",null,null,10,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"},null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-04-20","2017-04-30",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":105000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":105000},null,105000,"شقة /ابوظبي","محمد عنبر اردني",1]
[{"$f":"IF(D7<1000,IF(D7>0,\"A\",\"B\"),\"c\")","v":"A"},null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":303},null,null,"2017-05-27","2016-06-06",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":10000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":10000},null,10000,"قرطبة/2","  عبدالرحمن عبدالرحيم السيد",{"$f":"Q6+1","v":2}]
["A",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":142},null,null,"2017-11-04","2016-11-15",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":20000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":20000},null,20000,"قرطبة/3","  احمد عبدالرحيم السيد",{"$f":"Q7+1","v":3}]
["B",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,10000,"2019-02-06",null,null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":0},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":10000},null,10000,"قرطبة/4","محمد سليمان",4]
["c",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":43185},null,null,null,null,null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":0},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":0},null,null,"قرطبة/1","فاضي",5]
["A",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":186},null,null,"2017-09-21","2016-10-02",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":7000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":7000},null,7000,"سعي","عبداللة عامر الخالدي",6]
["A",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":186},null,null,"2017-09-21","2017-03-29",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":20000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":20000},null,20000,"محلات","  محمد سليمان السيد",7]
["B",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-15","2017-12-19",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":280000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":280000},280000,null,"شقة تركيا /10","لولوة هزاع الدوسري",8]
["B",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":0},null,null,"2018-06-15","2017-12-19",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":230000},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":230000},null,230000,"محلات","زيد بن عباس بن عجير العتيبي",9]
["A",null,null,{"$f":"IF(Table1348956711[[#This Row],[    تاريخ الانتهاء]]<$B$4,$B$4-Table1348956711[[#This Row],[    تاريخ الانتهاء]],0)","v":39},null,null,"2018-02-15","2017-02-26",null,{"$f":"Table1348956711[[#This Row],[الإجمالي]]-Table1348956711[[#This Row],[المطلوب]]-Table1348956711[[#This Row],[المدفوع]]","v":9150},{"$f":"(Table1348956711[[#This Row],[الإجمالي]]/$Q$3)*Table1348956711[[#This Row],[     طريقة الدفع]]","v":0},{"$f":"Table1348956711[[#This Row],[     ألأيجار]]+Table1348956711[[#This Row],[ماء]]","v":9150},null,9150,"سعي","عبداللة سعود العميري",10]
["B",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1348956711[المطلوب])","v":0},{"$f":"SUBTOTAL(109,Table1348956711[الإجمالي])","v":691150},{"$f":"SUBTOTAL(109,Table1348956711[ماء])","v":280000},{"$f":"SUBTOTAL(109,Table1348956711[[     ألأيجار]])","v":411150}]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]
["B"]

{"sheet":"سند قبض","index":10,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,8,18,9],[18,1,18,3],[8,8,10,9],[8,6,10,7],[15,8,15,9],[16,8,16,9],[9,4,9,5],[9,1,9,2],[10,4,10,5],[10,1,10,2],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[14,6,14,7],[11,0,11,5],[12,0,12,5],[7,8,7,9],[7,6,7,7],[7,0,7,5],[8,2,8,5],[16,6,16,7],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[11,6,11,7],[12,6,12,7],[13,6,13,7],[15,6,15,7],[6,6,6,8],[2,3,3,5],[0,3,1,5],[2,7,2,8],[3,7,3,8],[4,6,4,8],[4,3,5,5]]}
[null,null,null,"سند قبض"]
[]
[null,null,null,"Receipt Vouchrt",null,null,null,{"$f":"TODAY()","v":"2018-03-26"},null,"تاريخ السند",null,null,null,null,null,"سلطان",1]
[null,null,null,null,null,null,null,{"$f":"H3","v":"2018-03-26"},null,"الموافق",null,null,null,null,null,"الجوهرة",2]
[null,null,null,32,null,null,null,null,null,"الرقم الضريبي",null,null,null,null,null,"البايونيه",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الراكه",4]
["البايونيه","عقار",3,"شقه رقم",{"$f":"B28","v":0},"جوال",{"$f":"O28","v":"مانوج تايبارامبو سيفاداس"},null,null,"استلمنا من :",null,null,{"$f":"M28","v":12000},"ايجار سنوي",null,"سعد",5,null,{"$f":"IFERROR(VLOOKUP(A7,P3:Q12,2,),0)","v":3}]
["البيان Description",null,null,null,null,null,"النوع Type",null,"المبلغ Amount",null,null,null,{"$f":"M7/12","v":1000},"شهري",null,"نايف",6]
[{"$f":"M28","v":12000},"الايجار السنوي","دفعه من الايجار",null,null,null,"الايجار",null,1000,null,null,null,{"$f":"M7/366","v":32.786885245901637},"يومي",null,"الدمام",7]
[{"$f":"DATE(YEAR(D10)+M11,MONTH(D10)+M12,DAY(D10)+M13)","v":"2018-06-12"},"الي تاريخ",null,{"$f":"F28","v":"2018-05-14"},"وذلك للفترة من تاريخ ",null,null,null,null,null,null,null,{"$f":"I9/M9","v":30.500000000000004},"باليوم",null,"الحزام",8]
[{"$f":"A10","v":"2018-06-12"},"TO",null,{"$f":"D10","v":"2018-05-14"},"FROM",null,null,null,null,null,null,{"$f":"M7*M11","v":0},{"$f":"DATEDIF(1,M10,\"y\")","v":0},"سنه",null,"ناصر",9]
["المياة وكهرباء",null,null,null,null,null,"المياة",null,0,null,null,{"$f":"M8*M12","v":0},{"$f":"DATEDIF(1,M10,\"yM\")","v":0},"شهر",null,"منوع",10]
["التأمين",null,null,null,null,null,"قبض التأمين",null,0,null,null,{"$f":"M9*M13","v":950.81967213114751},{"$f":"DATEDIF(1,M10,\"MD\")+O13","v":29},"يوم"]
["اتعاب المكتب",null,null,null,null,null,"السعي",null,0,null,null,{"$f":"SUM(L11:L13)","v":950.81967213114751}]
["صيانه",null,null,null,null,null,"صيانه",null,0,null,null,{"$f":"L14-I9","v":-49.180327868852487}]
["مبلغ الضريبة",null,null,null,null,null,"القيمه المضافه",null,0]
[{"$f":"IF(I17=0,\"\",CONCATENATE(\"فقط\",\"  \",sformatnumber(I17),\" ريالاً \",IF(ISERROR(FIND(\".\",I17)),\" \",\"و\"),IF(ISERROR(FIND(\".\",I17)),\" \",CONCATENATE(sformatnumber(IF(LEN(RIGHT(I17,LEN(I17)-FIND(\".\",I17)))=1,RIGHT(I17,LEN(I17)-FIND(\".\",I17))*10,RIGHT(I17,LEN(I17)-FIND(\".\",I17)))),\" هللة \")),\" لا غیر\"))","v":"فقط  الف ريالاً    لا غیر"},null,null,null,null,null,"المجموع Total",null,{"$f":"SUM(I9:J16)","v":1000}]
[]
[null,"التوقيع Sign",null,null,null,null,null,null,"الختم"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"'\",A7,\"'\",\"!\",\"A1:IQ9999\")","v":"'البايونيه'!A1:IQ9999"},null,"النطاق"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(C7,INDEX(INDIRECT(K23),,15),0)","v":8},null,"الصف"]
[null,null,null,null,null,null,null,null,{"$f":"K25+3","v":7},null,{"$f":"MATCH(H4,INDEX(INDIRECT(K23),15,),0)","v":4},null,"العمود"]
[null,null,null,null,null,null,null,null,{"$f":"ADDRESS(K24,I25,4)","v":"G8"},null,{"$f":"ADDRESS(K24,K25,4)","v":"D8"}]
[]
[{"$f":"INDEX(INDIRECT($K$23),$K$24,COLUMN()+$K$25-3)","v":"بدون تأمين"},0,{"$f":"INDEX(INDIRECT($K$23),$K$24,COLUMN()+$K$25-3)","v":0},{"$f":"INDEX(INDIRECT($K$23),$K$24,COLUMN()+$K$25-3)","v":0},0,"2018-05-14"," ",6,6300,6300,12600,600,12000,3,"مانوج تايبارامبو سيفاداس"]