{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["شباط","آذار"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"شباط","index":0,"n_rows":10,"n_cols":24,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,5,0,7],[0,18,0,19],[0,15,0,16],[0,9,0,11]]}
[null,null,null,null,null,null,null,null,null," أدخل كلمة البحث  ",null,null,null,null,null,"            عدد المشتركين",null,{"$f":"COUNT(A4:A10)","v":7},{"$f":"SUM(V4:V10)","v":1520000},null," شباط ",null,"✓"]
[null,null,""]
["الرقم","الإسم","هاتف","رقم المشترك","تاريخ الإشتراك","المنطقة","الشارع","البناية","البناية","الطابق","A","B","C","D","E","سعر B","سعر A","سعر الوحدة","المتأخرات","المبلغ المدفوع","تاريخ الدفعة","المبلغ المطلوب","مدفوع / غير","الاشتراك"]
[1,"محمد",null,null,null,null,null,null,null,null,null,10,520,300,{"$f":"SUM(M4-N4)","v":220},{"$f":"IF(L4=0,0,IF(L4<=5.5,150000,IF(L4<=10.5,230000,IF(L4<=15.5,300000,IF(L4<=20.5,350000,IF(L4<=25.5,400000,IF(L4<=30.5,450000,IF(L4<=35.5,500000,IF(L4<=40.5,550000,IF(L4<=45.5,600000,IF(L4<=50.5,650000,IF(L4<=55.5,700000,IF(L4<=60.5,750000)))))))))))))","v":230000},{"$f":"SUM(K4*150000/2.5)","v":0},{"$f":"SUM(O4*4000)","v":880000},null,500000,"2021-10-10",{"$f":"SUM(P4+Q4+R4+S4+X4)-T4","v":640000},{"$f":"IF(V4<=0,\"مدفوع\",\"غير مدفوع\")","v":"غير مدفوع"},30000]
[2,"زاهر",null,null,null,null,null,null,null,null,null,6,null,null,{"$f":"SUM(M5-N5)","v":0},{"$f":"IF(L5=0,0,IF(L5<=5.5,150000,IF(L5<=10.5,230000,IF(L5<=15.5,300000,IF(L5<=20.5,350000,IF(L5<=25.5,400000,IF(L5<=30.5,450000,IF(L5<=35.5,500000,IF(L5<=40.5,550000,IF(L5<=45.5,600000,IF(L5<=50.5,650000,IF(L5<=55.5,700000,IF(L5<=60.5,750000)))))))))))))","v":230000},{"$f":"SUM(K5*150000/2.5)","v":0},{"$f":"SUM(O5*4000)","v":0},null,null,null,{"$f":"SUM(P5+Q5+R5+S5+X5)-T5","v":260000},"غير مدفوع",30000]
[3,"إسماعيل",null,null,null,null,null,null,null,null,null,3,600,200,400,{"$f":"IF(L6=0,0,IF(L6<=5.5,150000,IF(L6<=10.5,230000,IF(L6<=15.5,300000,IF(L6<=20.5,350000,IF(L6<=25.5,400000,IF(L6<=30.5,450000,IF(L6<=35.5,500000,IF(L6<=40.5,550000,IF(L6<=45.5,600000,IF(L6<=50.5,650000,IF(L6<=55.5,700000,IF(L6<=60.5,750000)))))))))))))","v":150000},0,1600000,null,1780000,"2021-10-22",0,"مدفوع",30000]
[4,"عمر",null,null,null,null,null,null,null,null,null,5,null,null,0,150000,0,0,null,null,null,180000,"غير مدفوع",30000]
[5,"جميل",null,null,null,null,null,null,null,null,null,3,null,null,0,150000,0,0,null,180000,"2021-10-13",0,"مدفوع",30000]
[6,"إبراهيم",null,null,null,null,null,null,null,null,null,5,null,null,0,150000,0,0,null,null,null,180000,"غير مدفوع",30000]
[7,"سمير",null,null,null,null,null,null,null,null,null,6,null,null,0,230000,0,0,null,null,null,260000,"غير مدفوع",30000]

{"sheet":"آذار","index":1,"n_rows":10,"n_cols":24,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,5,0,7],[0,9,0,11],[0,15,0,16],[0,18,0,19]]}
[null,null,null,null,null,null,null,null,null," أدخل كلمة البحث  ",null,null,null,null,null,"            عدد المشتركين",null,{"$f":"COUNT(A4:A10)","v":7},{"$f":"SUM(V4:V10)","v":3040000},null," شباط ",null,"✓"]
[null,null,""]
["الرقم","الإسم","هاتف","رقم المشترك","تاريخ الإشتراك","المنطقة","الشارع","البناية","البناية","الطابق","A","B","C","D","E","سعر B","سعر A","سعر الوحدة","المتأخرات","المبلغ المدفوع","تاريخ الدفعة","المبلغ المطلوب","مدفوع / غير","الاشتراك"]
[1,"محمد",null,null,null,null,null,null,null,null,null,10,520,300,{"$f":"SUM(M4-N4)","v":220},{"$f":"IF(L4=0,0,IF(L4<=5.5,150000,IF(L4<=10.5,230000,IF(L4<=15.5,300000,IF(L4<=20.5,350000,IF(L4<=25.5,400000,IF(L4<=30.5,450000,IF(L4<=35.5,500000,IF(L4<=40.5,550000,IF(L4<=45.5,600000,IF(L4<=50.5,650000,IF(L4<=55.5,700000,IF(L4<=60.5,750000)))))))))))))","v":230000},{"$f":"SUM(K4*150000/2.5)","v":0},{"$f":"SUM(O4*4000)","v":880000},{"$f":"شباط!V4","v":640000},500000,"2021-10-10",{"$f":"SUM(P4+Q4+R4+S4+X4)-T4","v":1280000},{"$f":"IF(V4<=0,\"مدفوع\",\"غير مدفوع\")","v":"غير مدفوع"},30000]
[2,"زاهر",null,null,null,null,null,null,null,null,null,6,null,null,{"$f":"SUM(M5-N5)","v":0},{"$f":"IF(L5=0,0,IF(L5<=5.5,150000,IF(L5<=10.5,230000,IF(L5<=15.5,300000,IF(L5<=20.5,350000,IF(L5<=25.5,400000,IF(L5<=30.5,450000,IF(L5<=35.5,500000,IF(L5<=40.5,550000,IF(L5<=45.5,600000,IF(L5<=50.5,650000,IF(L5<=55.5,700000,IF(L5<=60.5,750000)))))))))))))","v":230000},0,0,{"$f":"شباط!V5","v":260000},null,null,{"$f":"SUM(P5+Q5+R5+S5+X5)-T5","v":520000},"غير مدفوع",30000]
[3,"إسماعيل",null,null,null,null,null,null,null,null,null,3,600,200,400,{"$f":"IF(L6=0,0,IF(L6<=5.5,150000,IF(L6<=10.5,230000,IF(L6<=15.5,300000,IF(L6<=20.5,350000,IF(L6<=25.5,400000,IF(L6<=30.5,450000,IF(L6<=35.5,500000,IF(L6<=40.5,550000,IF(L6<=45.5,600000,IF(L6<=50.5,650000,IF(L6<=55.5,700000,IF(L6<=60.5,750000)))))))))))))","v":150000},0,1600000,{"$f":"شباط!V6","v":0},1780000,"2021-10-22",0,"مدفوع",30000]
[4,"عمر",null,null,null,null,null,null,null,null,null,5,null,null,0,150000,0,0,{"$f":"شباط!V7","v":180000},null,null,360000,"غير مدفوع",30000]
[5,"جميل",null,null,null,null,null,null,null,null,null,3,null,null,0,150000,0,0,{"$f":"شباط!V8","v":0},180000,"2021-10-13",0,"مدفوع",30000]
[6,"إبراهيم",null,null,null,null,null,null,null,null,null,5,null,null,0,150000,0,0,{"$f":"شباط!V9","v":180000},null,null,360000,"غير مدفوع",30000]
[7,"سمير",null,null,null,null,null,null,null,null,null,6,null,null,0,230000,0,0,{"$f":"شباط!V10","v":260000},null,null,520000,"غير مدفوع",30000]