{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["محمد","محمود","ابراهيم","عادل","رضا","بحث"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الاسم","محمد"]
[null,"الرصيد",{"$f":"SUM(C6:C12)","v":14}]
[]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":1},"كراسة 100 ورقة",2,null,null,"تم السداد"]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":2},"كراسة 200 ورقة",2,null,null,"باقى حساب"]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":3},"كراسة 150 ورقة",2,null,null,"تم سداد جزء"]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":4},"كراسة 50 ورقة",2,null,null,"متبقى 100 جـ"]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":5},"كراسة 10 ورقة",2,null,null,"تم السداد"]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":6},"كراسة 100 ورقة",2,null,null,"باقى حساب"]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":7},"كراسة 100 ورقة",2,null,null,"تم سداد جزء"]

{"sheet":"محمود","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الاسم","احمد"]
[null,"الرصيد",{"$f":"SUM(C6:C12)","v":30}]
[]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":1},"كشكول سلك",5,null,null,"كمية قلية"]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":2},"كشكول عادى",5,null,null,"محجوز منه "]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":3},"كشكول سلك 100 ورقة",5,null,null,"النسخ غير كافية"]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":4},"رزمة ورقة 80 حرام",5,null,null,"تم السداد"]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":5},"رزمة ورقة 60 حرام",5,null,null,"تم السداد"]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":6},"رزمة ورقة 70 حرام",5,null,null,"تم السداد"]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":""}]

{"sheet":"ابراهيم","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الاسم","ابراهيم"]
[null,"الرصيد",{"$f":"SUM(C6:C12)","v":6}]
[]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":1},"قلم حاف",3]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":2},"قلم رصاص",3]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":""}]

{"sheet":"عادل","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الاسم","عادل"]
[null,"الرصيد",{"$f":"SUM(C6:C12)","v":0}]
[]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":""}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":""}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":""}]

{"sheet":"رضا","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الاسم","رضا"]
[null,"الرصيد",{"$f":"SUM(C6:C12)","v":0}]
[]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$6:B6))","v":""}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$6:B7))","v":""}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$6:B8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$6:B9))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$6:B10))","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$6:B11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$6:B12))","v":""}]

{"sheet":"بحث","index":5,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,6,15,7]]}
[]
[null,"الاسم","محمد",null,null,null,null,null,"محمد",null,"الاسم","محمد"]
[null,"الرصيد",null,null,null,null,null,null,"محمود",null,"الرصيد",14]
[null,null,null,null,null,null,null,null,"ابراهيم"]
["م","البيان","المبلغ","التليفون","الاميل","ملاحظات",null,null,"عادل","م","البيان","المبلغ","التليفون","الاميل","ملاحظات"]
[null,null,null,null,null,null,null,null,"رضا",1,"كراسة 100 ورقة",2,null,null,"تم السداد"]
[null,null,null,null,null,null,null,null,null,2,"كراسة 200 ورقة",2,null,null,"باقى حساب"]
[null,null,null,null,null,null,"السلام عليكم ورحمة الله وبركاته بعد اذنكم ممكن كود بحث عند الاختيار من القائمة المنسدلة عن اسم مثلا اسم محمد يجلب بيانات محمد من شيت محمد ومعها خانة الرصيد وهكذا عند اختيار اى اسم يجلب بيانات الاسم وهذا نموذج للمطلوب",null,null,3,"كراسة 150 ورقة",2,null,null,"تم سداد جزء"]
[null,null,null,null,null,null,null,null,null,4,"كراسة 50 ورقة",2,null,null,"متبقى 100 جـ"]
[null,null,null,null,null,null,null,null,null,5,"كراسة 10 ورقة",2,null,null,"تم السداد"]
[null,null,null,null,null,null,null,null,null,6,"كراسة 100 ورقة",2,null,null,"باقى حساب"]
[null,null,null,null,null,null,null,null,null,7,"كراسة 100 ورقة",2,null,null,"تم سداد جزء"]