{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["معلومات أولية","حساب الجمعية4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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,"عدد الافراد",15]
[null,"القسط الشهرى",2000]
[null,"المبلغ لكل فرد",{"$f":"C2*C3","v":30000}]
[null,"تاريخ البداية","2019-01-01"]

{"sheet":"حساب الجمعية4","index":1,"n_rows":69,"n_cols":63,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,2,1,15]]}
[]
[]
[null,null,"اجمالى تحصيل الشهر",{"$f":"SUM(D10:D10)","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(AJ10:AJ10)","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,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$9:D9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(D9),MONTH(D9)+1,1))","v":"2019-02-01"},{"$f":"IF(COUNT($A$9:E9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(E9),MONTH(E9)+1,1))","v":"2019-03-01"},{"$f":"IF(COUNT($A$9:F9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(F9),MONTH(F9)+1,1))","v":"2019-04-01"},{"$f":"IF(COUNT($A$9:G9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(G9),MONTH(G9)+1,1))","v":"2019-05-01"},{"$f":"IF(COUNT($A$9:H9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(H9),MONTH(H9)+1,1))","v":"2019-06-01"},{"$f":"IF(COUNT($A$9:I9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(I9),MONTH(I9)+1,1))","v":"2019-07-01"},{"$f":"IF(COUNT($A$9:J9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(J9),MONTH(J9)+1,1))","v":"2019-08-01"},{"$f":"IF(COUNT($A$9:K9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(K9),MONTH(K9)+1,1))","v":"2019-09-01"},{"$f":"IF(COUNT($A$9:L9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(L9),MONTH(L9)+1,1))","v":"2019-10-01"},{"$f":"IF(COUNT($A$9:M9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(M9),MONTH(M9)+1,1))","v":"2019-11-01"},{"$f":"IF(COUNT($A$9:N9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(N9),MONTH(N9)+1,1))","v":"2019-12-01"},{"$f":"IF(COUNT($A$9:O9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(O9),MONTH(O9)+1,1))","v":"2020-01-01"},{"$f":"IF(COUNT($A$9:P9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(P9),MONTH(P9)+1,1))","v":"2020-02-01"},{"$f":"IF(COUNT($A$9:Q9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Q9),MONTH(Q9)+1,1))","v":"2020-03-01"},{"$f":"IF(COUNT($A$9:R9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(R9),MONTH(R9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:S9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(S9),MONTH(S9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:T9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(T9),MONTH(T9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:U9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(U9),MONTH(U9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:V9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(V9),MONTH(V9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:W9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(W9),MONTH(W9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:X9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(X9),MONTH(X9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:Y9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Y9),MONTH(Y9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:Z9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(Z9),MONTH(Z9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AA9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AA9),MONTH(AA9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AB9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AB9),MONTH(AB9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AC9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AC9),MONTH(AC9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AD9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AD9),MONTH(AD9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AE9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AE9),MONTH(AE9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AF9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AF9),MONTH(AF9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AG9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AG9),MONTH(AG9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AH9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AH9),MONTH(AH9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AI9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AI9),MONTH(AI9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AJ9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AJ9),MONTH(AJ9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AK9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AK9),MONTH(AK9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AL9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AL9),MONTH(AL9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AM9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AM9),MONTH(AM9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AN9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AN9),MONTH(AN9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AO9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AO9),MONTH(AO9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AP9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AP9),MONTH(AP9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AQ9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AQ9),MONTH(AQ9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AR9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AR9),MONTH(AR9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AS9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AS9),MONTH(AS9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AT9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AT9),MONTH(AT9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AU9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AU9),MONTH(AU9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AV9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AV9),MONTH(AV9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AW9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AW9),MONTH(AW9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AX9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AX9),MONTH(AX9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AY9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AY9),MONTH(AY9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:AZ9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(AZ9),MONTH(AZ9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BA9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BA9),MONTH(BA9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BB9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BB9),MONTH(BB9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BC9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BC9),MONTH(BC9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BD9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BD9),MONTH(BD9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BE9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BE9),MONTH(BE9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BF9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BF9),MONTH(BF9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BG9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BG9),MONTH(BG9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BH9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BH9),MONTH(BH9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BI9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BI9),MONTH(BI9)+1,1))","v":""},{"$f":"IF(COUNT($A$9:BJ9)>='معلومات أولية'!$C$2,\"\",DATE(YEAR(BJ9),MONTH(BJ9)+1,1))","v":""}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]