{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["توزيع المبالغ","تجميع المبالغ","ورقة3"],"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":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["عدد الأشهر",5,null,"عدد الأيام",15,null,null,null," حسب عدد الشهور",null,null,null,null,null,null,null,null," "]
["تبدأ من شهر","2022-12-01",null,null,null,null,"اختيار عدد الأيام "]
["تنتهى في شهر",{"$f":"EDATE(B2-1,B1)","v":"2023-04-30"},null,null,"اختبار عدد الشهور الموزعة"]
[]
[]
["م",{"$f":"$B$2","v":"2022-12-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(A$6,1),B6+$E$1)","v":"2022-12-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(B$6,1),C6+$E$1)","v":"2023-01-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(C$6,1),D6+$E$1)","v":"2023-01-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(D$6,1),E6+$E$1)","v":"2023-02-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(E$6,1),F6+$E$1)","v":"2023-02-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(F$6,1),G6+$E$1)","v":"2023-03-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(G$6,1),H6+$E$1)","v":"2023-03-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(H$6,1),I6+$E$1)","v":"2023-04-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(I$6,1),J6+$E$1)","v":"2023-04-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(J$6,1),K6+$E$1)","v":"2023-05-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(K$6,1),L6+$E$1)","v":"2023-05-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(L$6,1),M6+$E$1)","v":"2023-06-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(M$6,1),N6+$E$1)","v":"2023-06-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(N$6,1),O6+$E$1)","v":"2023-07-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(O$6,1),P6+$E$1)","v":"2023-07-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(P$6,1),Q6+$E$1)","v":"2023-08-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(Q$6,1),R6+$E$1)","v":"2023-08-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(R$6,1),S6+$E$1)","v":"2023-09-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(S$6,1),T6+$E$1)","v":"2023-09-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(T$6,1),U6+$E$1)","v":"2023-10-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(U$6,1),V6+$E$1)","v":"2023-10-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(V$6,1),W6+$E$1)","v":"2023-11-01"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(W$6,1),X6+$E$1)","v":"2023-11-16"},{"$f":"IF(MOD(COLUMN(),2)=0,EDATE(X$6,1),Y6+$E$1)","v":"2023-12-01"}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]

{"sheet":"تجميع المبالغ","index":1,"n_rows":26,"n_cols":41,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,1,6],[3,0,3,1]]}
["اللى عليه الدور",null,null,null,null,null,"توزيعة المبلغ","الاسم","المبلغ","الاسم","المبلغ","الاسم","المبلغ","الاسم","المبلغ"]
["الاسم",null,"المبلغ",{"$f":"SUM(I2+K2+M2+O2)","v":0},"شهر الصرف",null,null,{"$f":"IFERROR(TRIM(LEFT(B2,FIND(\"+\",B2)-1)),\"\")","v":""},0,{"$f":"TRIM(Q2)","v":""},0,{"$f":"IFERROR(TRIM(S2),\"\")","v":""},0,null,null,null,{"$f":"IFERROR(LEFT(R2,FIND(\"+\",R2)-1),\"\")","v":""},{"$f":"IFERROR(TRIM(MID(B2,FIND(\"+\",B2)+1,100)),\"\")","v":""},{"$f":"IFERROR(MID(R2,FIND(\"+\",R2)+1,100),\"\")","v":""}]
[]
["بيانات الجمعية",null,"عدد شهور الجمعية",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,"","",""]
["م","الاسم","الحالة","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","","",""]
["","سعيد ","اللى عليه الدور",100]
["","عادل","لم يحن الصرف",100]
["","محمود","لم يحن الصرف",100]
["","سعيد ","لم يحن الصرف",100]
["","عادل","لم يحن الصرف",100]
["","محمد + محمود","لم يحن الصرف",100]
["","سعيد ","لم يحن الصرف",100]
["","هانى + رضا + شريف","لم يحن الصرف",100]
["","عادل","لم يحن الصرف",100]
["","سعيد ","لم يحن الصرف",100]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}