{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["معلومات أولية","حساب الجمعية4"],"not_rendered":{"charts":0,"images":0,"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":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"عدد الافراد",{"$f":"'حساب الجمعية4'!A1","v":30}]
[null,"القسط الشهرى",2000]
[null,"المبلغ لكل فرد",{"$f":"C2*C3","v":60000}]
[null,"تاريخ البداية","2019-01-01"]

{"sheet":"حساب الجمعية4","index":1,"n_rows":164,"n_cols":63,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
[30]
[]
[null,null,"اجمالى تحصيل الشهر",{"$f":"SUM(D11:D11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AJ11:AJ11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["يمكنك التبديل من هنا",null,"استلم دفعة اولى"]
[null,null,"استلم دفعة ثانية"]
[null,null,"استلم دفعة ثالثة"]
[null,null,"نقدية جاهزة لم تسلم حتى الآن",{"$f":"D3-SUM(D4:D6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ3-SUM(AJ4:AJ6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"مثبقى له",{"$f":"IF(D4=\"\",\"\",'معلومات أولية'!C4-SUM(D4:D6))","v":""},{"$f":"IF(E4=\"\",\"\",'معلومات أولية'!D4-SUM(E4:E6))","v":""},{"$f":"IF(F4=\"\",\"\",'معلومات أولية'!E4-SUM(F4:F6))","v":""},{"$f":"IF(G4=\"\",\"\",'معلومات أولية'!F4-SUM(G4:G6))","v":""},{"$f":"IF(H4=\"\",\"\",'معلومات أولية'!G4-SUM(H4:H6))","v":""},{"$f":"IF(I4=\"\",\"\",'معلومات أولية'!H4-SUM(I4:I6))","v":""},{"$f":"IF(J4=\"\",\"\",'معلومات أولية'!I4-SUM(J4:J6))","v":""},{"$f":"IF(K4=\"\",\"\",'معلومات أولية'!J4-SUM(K4:K6))","v":""},{"$f":"IF(L4=\"\",\"\",'معلومات أولية'!K4-SUM(L4:L6))","v":""},{"$f":"IF(M4=\"\",\"\",'معلومات أولية'!L4-SUM(M4:M6))","v":""},{"$f":"IF(N4=\"\",\"\",'معلومات أولية'!M4-SUM(N4:N6))","v":""},{"$f":"IF(O4=\"\",\"\",'معلومات أولية'!N4-SUM(O4:O6))","v":""},{"$f":"IF(P4=\"\",\"\",'معلومات أولية'!O4-SUM(P4:P6))","v":""},{"$f":"IF(Q4=\"\",\"\",'معلومات أولية'!P4-SUM(Q4:Q6))","v":""},{"$f":"IF(R4=\"\",\"\",'معلومات أولية'!Q4-SUM(R4:R6))","v":""},{"$f":"IF(S4=\"\",\"\",'معلومات أولية'!R4-SUM(S4:S6))","v":""},{"$f":"IF(T4=\"\",\"\",'معلومات أولية'!S4-SUM(T4:T6))","v":""},{"$f":"IF(U4=\"\",\"\",'معلومات أولية'!T4-SUM(U4:U6))","v":""},{"$f":"IF(V4=\"\",\"\",'معلومات أولية'!U4-SUM(V4:V6))","v":""},{"$f":"IF(W4=\"\",\"\",'معلومات أولية'!V4-SUM(W4:W6))","v":""},{"$f":"IF(X4=\"\",\"\",'معلومات أولية'!W4-SUM(X4:X6))","v":""},{"$f":"IF(Y4=\"\",\"\",'معلومات أولية'!X4-SUM(Y4:Y6))","v":""},{"$f":"IF(Z4=\"\",\"\",'معلومات أولية'!Y4-SUM(Z4:Z6))","v":""},{"$f":"IF(AA4=\"\",\"\",'معلومات أولية'!Z4-SUM(AA4:AA6))","v":""},{"$f":"IF(AB4=\"\",\"\",'معلومات أولية'!AA4-SUM(AB4:AB6))","v":""},{"$f":"IF(AC4=\"\",\"\",'معلومات أولية'!AB4-SUM(AC4:AC6))","v":""},{"$f":"IF(AD4=\"\",\"\",'معلومات أولية'!AC4-SUM(AD4:AD6))","v":""},{"$f":"IF(AE4=\"\",\"\",'معلومات أولية'!AD4-SUM(AE4:AE6))","v":""},{"$f":"IF(AF4=\"\",\"\",'معلومات أولية'!AE4-SUM(AF4:AF6))","v":""},{"$f":"IF(AG4=\"\",\"\",'معلومات أولية'!AF4-SUM(AG4:AG6))","v":""},{"$f":"IF(AH4=\"\",\"\",'معلومات أولية'!AG4-SUM(AH4:AH6))","v":""},{"$f":"IF(AI4=\"\",\"\",'معلومات أولية'!AH4-SUM(AI4:AI6))","v":""},{"$f":"IF(AJ4=\"\",\"\",'معلومات أولية'!AI4-SUM(AJ4:AJ6))","v":""},{"$f":"IF(AK4=\"\",\"\",'معلومات أولية'!AJ4-SUM(AK4:AK6))","v":""},{"$f":"IF(AL4=\"\",\"\",'معلومات أولية'!AK4-SUM(AL4:AL6))","v":""},{"$f":"IF(AM4=\"\",\"\",'معلومات أولية'!AL4-SUM(AM4:AM6))","v":""},{"$f":"IF(AN4=\"\",\"\",'معلومات أولية'!AM4-SUM(AN4:AN6))","v":""},{"$f":"IF(AO4=\"\",\"\",'معلومات أولية'!AN4-SUM(AO4:AO6))","v":""},{"$f":"IF(AP4=\"\",\"\",'معلومات أولية'!AO4-SUM(AP4:AP6))","v":""},{"$f":"IF(AQ4=\"\",\"\",'معلومات أولية'!AP4-SUM(AQ4:AQ6))","v":""},{"$f":"IF(AR4=\"\",\"\",'معلومات أولية'!AQ4-SUM(AR4:AR6))","v":""},{"$f":"IF(AS4=\"\",\"\",'معلومات أولية'!AR4-SUM(AS4:AS6))","v":""},{"$f":"IF(AT4=\"\",\"\",'معلومات أولية'!AS4-SUM(AT4:AT6))","v":""},{"$f":"IF(AU4=\"\",\"\",'معلومات أولية'!AT4-SUM(AU4:AU6))","v":""},{"$f":"IF(AV4=\"\",\"\",'معلومات أولية'!AU4-SUM(AV4:AV6))","v":""},{"$f":"IF(AW4=\"\",\"\",'معلومات أولية'!AV4-SUM(AW4:AW6))","v":""},{"$f":"IF(AX4=\"\",\"\",'معلومات أولية'!AW4-SUM(AX4:AX6))","v":""},{"$f":"IF(AY4=\"\",\"\",'معلومات أولية'!AX4-SUM(AY4:AY6))","v":""},{"$f":"IF(AZ4=\"\",\"\",'معلومات أولية'!AY4-SUM(AZ4:AZ6))","v":""},{"$f":"IF(BA4=\"\",\"\",'معلومات أولية'!AZ4-SUM(BA4:BA6))","v":""},{"$f":"IF(BB4=\"\",\"\",'معلومات أولية'!BA4-SUM(BB4:BB6))","v":""},{"$f":"IF(BC4=\"\",\"\",'معلومات أولية'!BB4-SUM(BC4:BC6))","v":""},{"$f":"IF(BD4=\"\",\"\",'معلومات أولية'!BC4-SUM(BD4:BD6))","v":""},{"$f":"IF(BE4=\"\",\"\",'معلومات أولية'!BD4-SUM(BE4:BE6))","v":""},{"$f":"IF(BF4=\"\",\"\",'معلومات أولية'!BE4-SUM(BF4:BF6))","v":""},{"$f":"IF(BG4=\"\",\"\",'معلومات أولية'!BF4-SUM(BG4:BG6))","v":""},{"$f":"IF(BH4=\"\",\"\",'معلومات أولية'!BG4-SUM(BH4:BH6))","v":""},{"$f":"IF(BI4=\"\",\"\",'معلومات أولية'!BH4-SUM(BI4:BI6))","v":""},{"$f":"IF(BJ4=\"\",\"\",'معلومات أولية'!BI4-SUM(BJ4:BJ6))","v":""},{"$f":"IF(BK4=\"\",\"\",'معلومات أولية'!BJ4-SUM(BK4:BK6))","v":""}]
[]
[null,"ر.م","الاسم",{"$f":"'معلومات أولية'!C5","v":"2019-01-01"},{"$f":"IF(COUNT($A$10:D10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(D10),MONTH(D10)+1,1))","v":"2019-02-01"},{"$f":"IF(COUNT($A$10:E10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(E10),MONTH(E10)+1,1))","v":"2019-03-01"},{"$f":"IF(COUNT($A$10:F10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(F10),MONTH(F10)+1,1))","v":"2019-04-01"},{"$f":"IF(COUNT($A$10:G10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(G10),MONTH(G10)+1,1))","v":"2019-05-01"},{"$f":"IF(COUNT($A$10:H10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(H10),MONTH(H10)+1,1))","v":"2019-06-01"},{"$f":"IF(COUNT($A$10:I10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(I10),MONTH(I10)+1,1))","v":"2019-07-01"},{"$f":"IF(COUNT($A$10:J10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(J10),MONTH(J10)+1,1))","v":"2019-08-01"},{"$f":"IF(COUNT($A$10:K10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(K10),MONTH(K10)+1,1))","v":"2019-09-01"},{"$f":"IF(COUNT($A$10:L10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(L10),MONTH(L10)+1,1))","v":"2019-10-01"},{"$f":"IF(COUNT($A$10:M10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(M10),MONTH(M10)+1,1))","v":"2019-11-01"},{"$f":"IF(COUNT($A$10:N10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(N10),MONTH(N10)+1,1))","v":"2019-12-01"},{"$f":"IF(COUNT($A$10:O10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(O10),MONTH(O10)+1,1))","v":"2020-01-01"},{"$f":"IF(COUNT($A$10:P10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(P10),MONTH(P10)+1,1))","v":"2020-02-01"},{"$f":"IF(COUNT($A$10:Q10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Q10),MONTH(Q10)+1,1))","v":"2020-03-01"},{"$f":"IF(COUNT($A$10:R10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(R10),MONTH(R10)+1,1))","v":"2020-04-01"},{"$f":"IF(COUNT($A$10:S10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(S10),MONTH(S10)+1,1))","v":"2020-05-01"},{"$f":"IF(COUNT($A$10:T10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(T10),MONTH(T10)+1,1))","v":"2020-06-01"},{"$f":"IF(COUNT($A$10:U10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(U10),MONTH(U10)+1,1))","v":"2020-07-01"},{"$f":"IF(COUNT($A$10:V10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(V10),MONTH(V10)+1,1))","v":"2020-08-01"},{"$f":"IF(COUNT($A$10:W10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(W10),MONTH(W10)+1,1))","v":"2020-09-01"},{"$f":"IF(COUNT($A$10:X10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(X10),MONTH(X10)+1,1))","v":"2020-10-01"},{"$f":"IF(COUNT($A$10:Y10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Y10),MONTH(Y10)+1,1))","v":"2020-11-01"},{"$f":"IF(COUNT($A$10:Z10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Z10),MONTH(Z10)+1,1))","v":"2020-12-01"},{"$f":"IF(COUNT($A$10:AA10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AA10),MONTH(AA10)+1,1))","v":"2021-01-01"},{"$f":"IF(COUNT($A$10:AB10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AB10),MONTH(AB10)+1,1))","v":"2021-02-01"},{"$f":"IF(COUNT($A$10:AC10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AC10),MONTH(AC10)+1,1))","v":"2021-03-01"},{"$f":"IF(COUNT($A$10:AD10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AD10),MONTH(AD10)+1,1))","v":"2021-04-01"},{"$f":"IF(COUNT($A$10:AE10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AE10),MONTH(AE10)+1,1))","v":"2021-05-01"},{"$f":"IF(COUNT($A$10:AF10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AF10),MONTH(AF10)+1,1))","v":"2021-06-01"},{"$f":"IF(COUNT($A$10:AG10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AG10),MONTH(AG10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AH10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AH10),MONTH(AH10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AI10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AI10),MONTH(AI10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AJ10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AJ10),MONTH(AJ10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AK10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AK10),MONTH(AK10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AL10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AL10),MONTH(AL10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AM10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AM10),MONTH(AM10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AN10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AN10),MONTH(AN10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AO10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AO10),MONTH(AO10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AP10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AP10),MONTH(AP10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AQ10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AQ10),MONTH(AQ10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AR10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AR10),MONTH(AR10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AS10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AS10),MONTH(AS10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AT10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AT10),MONTH(AT10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AU10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AU10),MONTH(AU10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AV10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AV10),MONTH(AV10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AW10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AW10),MONTH(AW10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AX10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AX10),MONTH(AX10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AY10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AY10),MONTH(AY10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:AZ10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AZ10),MONTH(AZ10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BA10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BA10),MONTH(BA10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BB10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BB10),MONTH(BB10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BC10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BC10),MONTH(BC10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BD10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BD10),MONTH(BD10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BE10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BE10),MONTH(BE10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BF10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BF10),MONTH(BF10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BG10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BG10),MONTH(BG10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BH10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BH10),MONTH(BH10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BI10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BI10),MONTH(BI10)+1,1))","v":""},{"$f":"IF(COUNT($A$10:BJ10)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BJ10),MONTH(BJ10)+1,1))","v":""}]
[null,39]
[null,27]
[null,23]
[null,23]
[null,37]
[null,10]
[null,46]
[null,30]
[null,40]
[null,48]
[null,47]
[null,39]
[null,8]
[null,30]
[null,42]
[null,49]
[null,4]
[null,1]
[null,19]
[null,47]
[null,3]
[null,28]
[null,2]
[null,3]
[null,29]
[null,17]
[null,31]
[null,3]
[null,48]
[null,28]
[null,18]
[null,13]
[null,40]
[null,9]
[null,23]
[null,28]
[null,18]
[null,18]
[null,36]
[null,32]
[null,32]
[null,5]
[null,22]
[null,16]
[null,35]
[null,24]
[null,15]
[null,4]
[null,34]
[null,47]
[null,42]
[null,24]
[null,32]
[null,35]
[null,44]
[null,46]
[null,39]
[null,24]
[null,18]
[null,46]
[null,13]
[null,10]
[null,31]
[null,14]
[null,1]
[null,23]
[null,24]
[null,3]
[null,23]
[null,14]
[null,18]
[null,28]
[null,40]
[null,1]
[null,2]
[null,48]
[null,45]
[null,35]
[null,4]
[null,38]
[null,16]
[null,24]
[null,46]
[null,49]
[null,47]
[null,21]
[null,48]
[null,6]
[null,6]
[null,23]
[null,22]
[null,2]
[null,46]
[null,38]
[null,45]
[null,11]
[null,28]
[null,24]
[null,2]
[null,20]
[null,7]
[null,17]
[null,29]
[null,28]
[null,1]
[null,31]
[null,42]
[null,22]
[null,2]
[null,12]
[null,36]
[null,13]
[null,6]
[null,8]
[null,22]
[null,29]
[null,41]
[null,30]
[null,19]
[null,42]
[null,17]
[null,29]
[null,46]
[null,7]
[null,46]
[null,8]
[null,32]
[null,12]
[null,34]
[null,11]
[null,28]
[null,33]
[null,35]
[null,20]
[null,42]
[null,5]
[null,28]
[null,41]
[null,6]
[null,49]
[null,2]
[null,35]
[null,11]
[null,21]
[null,39]
[null,46]
[null,12]
[null,24]
[null,33]
[null,36]
[null,46]
[null,42]
[null,12]
[null,1]