{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["بيانات الصندوق","ورقة الطباعة","ورقة1","المشتركين","معلومات المشتركين","الإشتراكات الشهرية والسنوية","القروض","تسديد القروض","المصاريف","كشف اجمالي","بيانات فردية","معلومات"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,0,7],[2,5,3,6],[9,5,9,6],[5,5,5,6],[5,7,5,8],[7,5,7,6],[7,7,7,8],[9,7,9,8],[11,5,11,6],[11,7,11,8],[16,1,17,2],[16,3,17,3],[17,5,17,6],[17,7,17,8],[15,5,15,6],[15,7,15,8],[13,5,13,6],[13,7,13,8]]}
[null,null,"بيانات الصندوق العامة 1424هـ"]
[]
[null,"الاشتراكات الشهرية","المدفوع","المتبقي",null,"الاشتركات السنوية",null,"المدفوع","المتبقي"]
[null,"محرم",{"$f":"'الإشتراكات الشهرية والسنوية'!E65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!F65","v":0},null,null,null,{"$f":"'الإشتراكات الشهرية والسنوية'!C65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!D65","v":0}]
[null,"صفر",{"$f":"'الإشتراكات الشهرية والسنوية'!G65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!H65","v":0}]
[null,"ربيع الاول",{"$f":"'الإشتراكات الشهرية والسنوية'!I65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!J65","v":0},null,"الاشتراكات الشهرية الموجودة",null,{"$f":"'الإشتراكات الشهرية والسنوية'!$AC$65","v":0}]
[null,"ربيع الثاني",{"$f":"'الإشتراكات الشهرية والسنوية'!K65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!L65","v":0}]
[null,"جمادى الاولى",{"$f":"'الإشتراكات الشهرية والسنوية'!M65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!N65","v":0},null,"الاشتراكات الشهرية المتبقية",null,{"$f":"'الإشتراكات الشهرية والسنوية'!$AD$65","v":0}]
[null,"جمادى الثانية",{"$f":"'الإشتراكات الشهرية والسنوية'!O65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!P65","v":0}]
[null,"رجب",{"$f":"'الإشتراكات الشهرية والسنوية'!Q65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!R65","v":0},null,"المبالغ المقترضة",null,{"$f":"القروض!$E$34","v":0}]
[null,"شعبان",{"$f":"'الإشتراكات الشهرية والسنوية'!S65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!T65","v":0}]
[null,"رمضان",{"$f":"'الإشتراكات الشهرية والسنوية'!U65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!V65","v":0},null,"المبالغ المقترضة المسددة",null,{"$f":"'تسديد القروض'!$AI$33","v":0}]
[null,"شوال",{"$f":"'الإشتراكات الشهرية والسنوية'!W65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!X65","v":0}]
[null,"ذو القعدة",{"$f":"'الإشتراكات الشهرية والسنوية'!Y65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!Z65","v":0},null,"المبالغ المقترضة المتبقية",null,{"$f":"H10-H12","v":0}]
[null,"ذو الحجة",{"$f":"'الإشتراكات الشهرية والسنوية'!AA65","v":0},{"$f":"'الإشتراكات الشهرية والسنوية'!AB65","v":0}]
[null,null,null,null,null,"المصروفات",null,{"$f":"المصاريف!$D$69","v":0}]
[null,"المبالغ الموجودة في الصندوق",null,{"$f":"'كشف اجمالي'!$C$11","v":0}]
[null,null,null,null,null,"المبالغ المخرجة من الصندوق",null,{"$f":"H10+H16-(H12)","v":0}]

{"sheet":"ورقة الطباعة","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة1","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,3,2,9]]}
[null,null,null,"الصندوق التعاوني"]

{"sheet":"المشتركين","index":3,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,9,10,9],[6,9,7,9],[0,1,0,8],[1,1,1,8],[38,1,38,2],[37,1,37,2],[32,1,32,2],[34,1,34,2],[35,1,35,2],[2,2,3,2],[31,1,31,3],[9,8,10,8],[36,1,36,2],[4,5,4,7],[5,5,5,7],[25,3,26,3],[2,5,3,5],[2,6,3,9],[2,1,3,1],[22,3,23,3],[25,1,26,1],[25,2,26,2],[22,1,23,1],[19,2,20,2],[19,3,20,3],[47,6,47,8],[40,1,40,9],[44,3,44,4],[33,1,33,2],[44,6,44,8],[12,8,13,8],[15,9,16,9],[12,9,13,9],[28,1,29,2],[28,3,29,3],[22,2,23,2],[19,1,20,1]]}
[null,"الصندوق التعاوني "]
[null,"المعلومات الكاملة للمشتركين بالصندوق "]
[null,"رقم المشترك",null,null,null,"اسم المشترك",{"$f":"VLOOKUP(C3,معلومات,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"قيمة السهم الشهري",500]
[]
[null,"المدفوعات الشهرية","المدفوع","المتبقي",null,"تسديد الأقساط","المدفوع",null,"قيمة ",{"$f":"IF(ISNA(VLOOKUP(C3,القرض,7,FALSE)),\"0\",VLOOKUP(C3,القرض,7,FALSE))","v":"0"}]
[null,"محرم",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,5,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,5,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,6,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,6,FALSE))","v":"0"},null,"القسط 1",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,5,FALSE)),\"\",VLOOKUP(C3,التسديد,5,FALSE))","v":0},null,"القسط الشهري"]
[null,"صفر",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,7,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,7,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,8,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,8,FALSE))","v":"0"},null,"القسط 2",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,6,FALSE)),\"\",VLOOKUP(C3,التسديد,6,FALSE))","v":0}]
[null,"ربيع الاول",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,9,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,9,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,10,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,10,FALSE))","v":"0"},null,"القسط 3",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,7,FALSE)),\"\",VLOOKUP(C3,التسديد,7,FALSE))","v":0},null,"المبلغ المقترض",{"$f":"IF(ISNA(VLOOKUP(C3,القرض,4,FALSE)),\"0\",VLOOKUP(C3,القرض,4,FALSE))","v":"0"}]
[null,"ربيع الثاني",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,11,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,11,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,12,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,12,FALSE))","v":"0"},null,"القسط 4",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,8,FALSE)),\"\",VLOOKUP(C3,التسديد,8,FALSE))","v":0}]
[null,"جمادى الاولى",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,13,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,13,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,14,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,14,FALSE))","v":"0"},null,"القسط 5",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,9,FALSE)),\"\",VLOOKUP(C3,التسديد,9,FALSE))","v":0}]
[null,"جمادى الثانية",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,15,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,15,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,16,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,16,FALSE))","v":"0"},null,"القسط 6",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,10,FALSE)),\"\",VLOOKUP(C3,التسديد,10,FALSE))","v":0},null,"الاقساط المسددة",{"$f":"$G$38","v":0}]
[null,"رجب",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,17,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,17,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,18,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,18,FALSE))","v":"0"},null,"القسط 7",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,11,FALSE)),\"\",VLOOKUP(C3,التسديد,11,FALSE))","v":0}]
[null,"شعبان",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,19,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,19,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,20,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,20,FALSE))","v":"0"},null,"القسط 8",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,12,FALSE)),\"\",VLOOKUP(C3,التسديد,12,FALSE))","v":0}]
[null,"رمضان",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,21,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,21,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,22,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,22,FALSE))","v":"0"},null,"القسط 9",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,13,FALSE)),\"\",VLOOKUP(C3,التسديد,13,FALSE))","v":0},null,"المبلغ المتبقي ",{"$f":"J10-J13","v":0}]
[null,"شوال",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,23,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,23,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,24,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,24,FALSE))","v":"0"},null,"القسط 10",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,14,FALSE)),\"\",VLOOKUP(C3,التسديد,14,FALSE))","v":0},null,"من القرض"]
[null,"ذو القعدة",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,25,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,25,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,26,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,26,FALSE))","v":"0"},null,"القسط 11",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,15,FALSE)),\"\",VLOOKUP(C3,التسديد,15,FALSE))","v":0}]
[null,"ذو الحجة",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,27,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,27,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,28,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,28,FALSE))","v":"0"},null,"القسط 12",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,16,FALSE)),\"\",VLOOKUP(C3,التسديد,16,FALSE))","v":0}]
[null,"المجموع",{"$f":"SUM(C8:C19)","v":0},{"$f":"SUM(D8:D19)","v":0},null,"القسط 13",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,17,FALSE)),\"\",VLOOKUP(C3,التسديد,17,FALSE))","v":0}]
[null,null,null,null,null,"القسط 14",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,18,FALSE)),\"\",VLOOKUP(C3,التسديد,18,FALSE))","v":0}]
[null,null,null,null,null,"القسط 15",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,19,FALSE)),\"\",VLOOKUP(C3,التسديد,19,FALSE))","v":0}]
[null,"الاشتراك السنوي",{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,3,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,3,FALSE))","v":"0"},{"$f":"IF(ISNA(VLOOKUP(C3,الاشتراكات,4,FALSE)),\"0\",VLOOKUP(C3,الاشتراكات,4,FALSE))","v":"0"},null,"القسط 16",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,20,FALSE)),\"\",VLOOKUP(C3,التسديد,20,FALSE))","v":0}]
[null,null,null,null,null,"القسط 17",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,21,FALSE)),\"\",VLOOKUP(C3,التسديد,21,FALSE))","v":0}]
[null,null,null,null,null,"القسط 18",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,22,FALSE)),\"\",VLOOKUP(C3,التسديد,22,FALSE))","v":0}]
[null,"المجموع الكلي",{"$f":"SUM(C20,C23)","v":0},{"$f":"SUM(D20,D23)","v":0},null,"القسط 19",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,23,FALSE)),\"\",VLOOKUP(C3,التسديد,23,FALSE))","v":0}]
[null,null,null,null,null,"القسط 20",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,24,FALSE)),\"\",VLOOKUP(C3,التسديد,24,FALSE))","v":0}]
[null,null,null,null,null,"القسط 21",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,25,FALSE)),\"\",VLOOKUP(C3,التسديد,25,FALSE))","v":0}]
[null,"مجموع المبالغ المطلوبة من المشترك",null,{"$f":"J10+D26+I39-G38","v":0},null,"القسط 22",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,26,FALSE)),\"\",VLOOKUP(C3,التسديد,26,FALSE))","v":0}]
[null,null,null,null,null,"القسط 23",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,27,FALSE)),\"\",VLOOKUP(C3,التسديد,27,FALSE))","v":0}]
[null,null,null,null,null,"القسط 24",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,28,FALSE)),\"\",VLOOKUP(C3,التسديد,28,FALSE))","v":0}]
[null,"بيانات مختصرة عن الصندوق",null,null,null,"القسط 25",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,29,FALSE)),\"\",VLOOKUP(C3,التسديد,29,FALSE))","v":0}]
[null,"الاشتراكات الشهرية والسنوية المدفوعة",null,{"$f":"'الإشتراكات الشهرية والسنوية'!$AC$65","v":0},null,"القسط 26",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,30,FALSE)),\"\",VLOOKUP(C3,التسديد,30,FALSE))","v":0}]
[null,"الاشتراكات الشهرية والسنوية المتبقية",null,{"$f":"'الإشتراكات الشهرية والسنوية'!$AD$65","v":0},null,"القسط 27",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,31,FALSE)),\"\",VLOOKUP(C3,التسديد,31,FALSE))","v":0}]
[null,"مجموع المصاريف",null,{"$f":"المصاريف!$D$69","v":0},null,"القسط 28",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,32,FALSE)),\"\",VLOOKUP(C3,التسديد,32,FALSE))","v":0}]
[null,"المبالغ المقترضة من الصندوق",null,{"$f":"القروض!$E$34","v":0},null,"القسط 29",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,33,FALSE)),\"\",VLOOKUP(C3,التسديد,33,FALSE))","v":0}]
[null,"مجموع القروض المسددة",null,{"$f":"'تسديد القروض'!$AI$33","v":0},null,"القسط 30",{"$f":"IF(ISNA(VLOOKUP(C3,التسديد,34,FALSE)),\"\",VLOOKUP(C3,التسديد,34,FALSE))","v":0}]
[null,"مجموع المبالغ المخرجة والمتبقية لم تسدد",null,{"$f":"SUM(D34:D36)","v":0},null,"المجموع",{"$f":"SUM(G8:G37)","v":0}]
[null,"مجموع المبالغ المتبقية في الصندوق ",null,{"$f":"SUM(D33+D37-(D35+D36))","v":0}]
[]
[null,"عزيزي المشترك نرجو منك المسارعة بتسديد ماعليك من الديون حتى نتمكن من خدمة جميع المشتركين"]
[]
[]
[]
[null,null,null,"المسئول عن الصندوق",null,"الاسم /"]
[]
[]
[null,null,null,null,null,"التوقيع /"]

{"sheet":"معلومات المشتركين","index":4,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,2,5]]}
["قائمة المشتركين "]
[]
[]
["رقم المشنرك","اسم المشترك","العنوان","هاتف المنزل","الهاتف الجوال","الملاحظات"]
[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]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]

{"sheet":"الإشتراكات الشهرية والسنوية","index":5,"n_rows":65,"n_cols":30,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,28,2,29],[2,12,2,13],[2,14,2,15],[2,24,2,25],[2,26,2,27],[2,16,2,17],[2,18,2,19],[2,0,3,0],[2,22,2,23],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[64,0,64,1],[0,8,1,21],[2,2,2,3],[2,1,3,1],[2,20,2,21]]}
[null,null,null,null,null,null,null,null,"الأشتراكات الشهرية "]
[]
["رقم المشترك","اسم المشترك","الاشتراك السنوي",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,"المجموع"]
[null,null,"المدفوع ","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع","المتبقي","المدفوع ","المتبقي"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5+E5+G5+I5+K5+M5+O5+Q5+S5+U5+W5+Y5+AA5)","v":0},{"$f":"SUM(D5+F5+H5+J5+L5+N5+P5+R5+T5+V5+X5+Z5+AB5)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6+E6+G6+I6+K6+M6+O6+Q6+S6+U6+W6+Y6+AA6)","v":0},{"$f":"SUM(D6+F6+H6+J6+L6+N6+P6+R6+T6+V6+X6+Z6+AB6)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,{"$f":"'معلومات المشتركين'!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,{"$f":"'معلومات المشتركين'!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,{"$f":"'معلومات المشتركين'!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,{"$f":"'معلومات المشتركين'!B14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[11,{"$f":"'معلومات المشتركين'!B15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[12,{"$f":"'معلومات المشتركين'!B16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[13,{"$f":"'معلومات المشتركين'!B17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[14,{"$f":"'معلومات المشتركين'!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[15,{"$f":"'معلومات المشتركين'!B19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[16,{"$f":"'معلومات المشتركين'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[17,{"$f":"'معلومات المشتركين'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[18,{"$f":"'معلومات المشتركين'!B22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[19,{"$f":"'معلومات المشتركين'!B23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[20,{"$f":"'معلومات المشتركين'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[21,{"$f":"'معلومات المشتركين'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[22,{"$f":"'معلومات المشتركين'!B26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[23,{"$f":"'معلومات المشتركين'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[24,{"$f":"'معلومات المشتركين'!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[25,{"$f":"'معلومات المشتركين'!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[26,{"$f":"'معلومات المشتركين'!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[27,{"$f":"'معلومات المشتركين'!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[28,{"$f":"'معلومات المشتركين'!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[29,{"$f":"'معلومات المشتركين'!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[30,{"$f":"'معلومات المشتركين'!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[31,{"$f":"'معلومات المشتركين'!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[32,{"$f":"'معلومات المشتركين'!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[33,{"$f":"'معلومات المشتركين'!B37","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[34,{"$f":"'معلومات المشتركين'!B38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[35,{"$f":"'معلومات المشتركين'!B39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[36,{"$f":"'معلومات المشتركين'!B40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[37,{"$f":"'معلومات المشتركين'!B41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[38,{"$f":"'معلومات المشتركين'!B42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[39,{"$f":"'معلومات المشتركين'!B43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[40,{"$f":"'معلومات المشتركين'!B44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[41,{"$f":"'معلومات المشتركين'!B45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[42,{"$f":"'معلومات المشتركين'!B46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[43,{"$f":"'معلومات المشتركين'!B47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[44,{"$f":"'معلومات المشتركين'!B48","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[45,{"$f":"'معلومات المشتركين'!B49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[46,{"$f":"'معلومات المشتركين'!B50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[47,{"$f":"'معلومات المشتركين'!B51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[48,{"$f":"'معلومات المشتركين'!B52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[49,{"$f":"'معلومات المشتركين'!B53","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[50,{"$f":"'معلومات المشتركين'!B54","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[51,{"$f":"'معلومات المشتركين'!B55","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[52,{"$f":"'معلومات المشتركين'!B56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[53,{"$f":"'معلومات المشتركين'!B57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[54,{"$f":"'معلومات المشتركين'!B58","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[55,{"$f":"'معلومات المشتركين'!B59","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[56,{"$f":"'معلومات المشتركين'!B60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[57,{"$f":"'معلومات المشتركين'!B61","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[58,{"$f":"'معلومات المشتركين'!B62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[59,{"$f":"'معلومات المشتركين'!B63","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[60,{"$f":"'معلومات المشتركين'!B64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["المجموع",null,{"$f":"SUM(C5:C64)","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]

{"sheet":"القروض","index":6,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,0,4,0],[33,1,33,3],[0,1,1,7],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,5],[3,6,4,6],[3,7,4,7]]}
[null,"كشف بالقروض خلال عام "]
[]
[]
["التسلسل","رقم المشترك","اسم المشترك","تاريخ القرض","قــيــمـــــــــــة الـــقــــــــــــــــــــــــــــرض",null,"اسم القارض","قيمة السداد الشهرية"]
[null,null,null,null,"رقماً","كتابتاً"]
[1,null,{"$f":"IF(ISNA(VLOOKUP(B6,معلومات,2,FALSE)),\"\",VLOOKUP(B6,معلومات,2,FALSE))","v":""}]
[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,""]
[null,"مجموع قيمة القروض الهذا العام 1424هـ",null,null,{"$f":"SUM(E6:E33)","v":0}]

{"sheet":"تسديد القروض","index":7,"n_rows":33,"n_cols":36,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,1],[2,34,2,35],[2,3,3,3],[0,8,1,21],[2,0,3,0],[2,1,3,1],[2,2,3,2]]}
[null,null,null,null,null,null,null,null,"تسديد القروض "]
[]
["رقم المشترك","اسم المشترك","المبلغ المقترض","القسط الشهري","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","القسط ","المجموع"]
[null,null,null,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,"المدفوع ","المتبقي"]
[null,{"$f":"القروض!C6","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E5:AH5)","v":0},{"$f":"C5-AI5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:AH6)","v":0},{"$f":"C6-AI6","v":0}]
[{"$f":"القروض!B8","v":0},{"$f":"القروض!C8","v":""},{"$f":"القروض!E8","v":0},{"$f":"القروض!H8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B9","v":0},{"$f":"القروض!C9","v":""},{"$f":"القروض!E9","v":0},{"$f":"القروض!H9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B10","v":0},{"$f":"القروض!C10","v":""},{"$f":"القروض!E10","v":0},{"$f":"القروض!H10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B11","v":0},{"$f":"القروض!C11","v":""},{"$f":"القروض!E11","v":0},{"$f":"القروض!H11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B12","v":0},{"$f":"القروض!C12","v":""},{"$f":"القروض!E12","v":0},{"$f":"القروض!H12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B13","v":0},{"$f":"القروض!C13","v":""},{"$f":"القروض!E13","v":0},{"$f":"القروض!H13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B14","v":0},{"$f":"القروض!C14","v":""},{"$f":"القروض!E14","v":0},{"$f":"القروض!H14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B15","v":0},{"$f":"القروض!C15","v":""},{"$f":"القروض!E15","v":0},{"$f":"القروض!H15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B16","v":0},{"$f":"القروض!C16","v":""},{"$f":"القروض!E16","v":0},{"$f":"القروض!H16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B17","v":0},{"$f":"القروض!C17","v":""},{"$f":"القروض!E17","v":0},{"$f":"القروض!H17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B18","v":0},{"$f":"القروض!C18","v":""},{"$f":"القروض!E18","v":0},{"$f":"القروض!H18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B19","v":0},{"$f":"القروض!C19","v":""},{"$f":"القروض!E19","v":0},{"$f":"القروض!H19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B20","v":0},{"$f":"القروض!C20","v":""},{"$f":"القروض!E20","v":0},{"$f":"القروض!H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B21","v":0},{"$f":"القروض!C21","v":""},{"$f":"القروض!E21","v":0},{"$f":"القروض!H21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B22","v":0},{"$f":"القروض!C22","v":""},{"$f":"القروض!E22","v":0},{"$f":"القروض!H22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B23","v":0},{"$f":"القروض!C23","v":""},{"$f":"القروض!E23","v":0},{"$f":"القروض!H23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B24","v":0},{"$f":"القروض!C24","v":""},{"$f":"القروض!E24","v":0},{"$f":"القروض!H24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B25","v":0},{"$f":"القروض!C25","v":""},{"$f":"القروض!E25","v":0},{"$f":"القروض!H25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B26","v":0},{"$f":"القروض!C26","v":""},{"$f":"القروض!E26","v":0},{"$f":"القروض!H26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B27","v":0},{"$f":"القروض!C27","v":""},{"$f":"القروض!E27","v":0},{"$f":"القروض!H27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B28","v":0},{"$f":"القروض!C28","v":""},{"$f":"القروض!E28","v":0},{"$f":"القروض!H28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B29","v":0},{"$f":"القروض!C29","v":""},{"$f":"القروض!E29","v":0},{"$f":"القروض!H29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B30","v":0},{"$f":"القروض!C30","v":""},{"$f":"القروض!E30","v":0},{"$f":"القروض!H30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B31","v":0},{"$f":"القروض!C31","v":""},{"$f":"القروض!E31","v":0},{"$f":"القروض!H31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B32","v":0},{"$f":"القروض!C32","v":""},{"$f":"القروض!E32","v":0},{"$f":"القروض!H32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"القروض!B33","v":0},{"$f":"القروض!C33","v":""},{"$f":"القروض!E33","v":0},{"$f":"القروض!H33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["المجاميع ",null,{"$f":"SUM(C5:C32)","v":0},null,{"$f":"SUM(E5:E32)","v":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,0,0,0]

{"sheet":"المصاريف","index":8,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,0,68,2],[0,2,1,3]]}
[null,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]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
["المجموع المصروف خلال هذا العام",null,null,{"$f":"SUM(D4:D59)","v":0}]

{"sheet":"كشف اجمالي","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,2,2]]}
[]
[null,"المجاميع الكلية خلال عام "]
[]
[null,"مجموع المبالغ الداخلة والخارجة","القيمة"]
[null,"الاشتراكات الشهرية والسنوية المدفوعة",{"$f":"'الإشتراكات الشهرية والسنوية'!$AC$65","v":0}]
[null,"الاشتراكات الشهرية والسنوية المتبقية",{"$f":"'الإشتراكات الشهرية والسنوية'!$AD$65","v":0}]
[null,"مجموع المصاريف",{"$f":"المصاريف!$D$69","v":0}]
[null,"المبالغ المقترضة من الصندوق",{"$f":"القروض!$E$34","v":0}]
[null,"مجموع القروض المسددة",{"$f":"'تسديد القروض'!$AI$33","v":0}]
[null,"مجموع المبالغ المخرجة والمتبقية لم تسدد",{"$f":"SUM(C6:C8)","v":0}]
[null,"مجموع المبالغ المتبقية في الصندوق ",{"$f":"SUM(C5+C9-(C7+C8))","v":0}]

{"sheet":"بيانات فردية","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,2,8],[3,1,4,8],[18,6,19,6],[18,7,19,8],[12,6,13,6],[12,7,13,8],[15,7,16,8],[6,1,7,2],[6,3,7,4],[18,3,19,4],[5,1,5,8],[15,1,16,6],[18,1,19,2],[21,1,22,2],[21,3,22,4],[9,1,10,2],[9,3,10,8],[12,1,13,2],[12,3,13,4]]}
[]
[null,"الصندوق التعاوني "]
[]
[null,"كشف حساب الصندوق التعاوني للافراد المشتركين خلال هذا العام "]
[]
[null,"اكتب رقم العضو أو اختر اسمه من القائمة حتى تتمكن من أظهار بياناته",null,11]
[null,"  رقم العضو",1,1]
[]
[]
[null,"اسم العضو",null,{"$f":"IF(ISNA(VLOOKUP(D7,معلومات,2,FALSE)),\"\",VLOOKUP(D7,معلومات,2,FALSE))","v":0},null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(C10,معلومات,2,FALSE)),\"\",VLOOKUP(C10,معلومات,2,FALSE))","v":""}]
[]
[]
[null,"مجموع الإشتراكات المدفوعة",null,{"$f":"IF(ISNA(VLOOKUP(D7,الاشتراكات,29,FALSE)),\"0\",VLOOKUP(D7,الاشتراكات,29,FALSE))","v":0},null,null,"المتبقية",{"$f":"IF(ISNA(VLOOKUP(D7,الاشتراكات,30,FALSE)),\"0\",VLOOKUP(D7,الاشتراكات,30,FALSE))","v":0}]
[]
[]
[null,"المبالغ المقترضة من الصندوق خلال هذا العام ",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D7,القرض,4,FALSE)),\"0\",VLOOKUP(D7,القرض,4,FALSE))","v":"0"}]
[]
[]
[null,"القروض المسددة",null,{"$f":"IF(ISNA(VLOOKUP(D7,التسديد,35,FALSE)),\"0\",VLOOKUP(D7,التسديد,35,FALSE))","v":"0"},null,null,"المتبقية",{"$f":"H16-D19","v":0}]
[]
[]
[null,"مجموع المبالغ المتبقية",null,{"$f":"H13+H19","v":0}]

{"sheet":"معلومات","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[2,2,14,8]]}