{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ارقام","البيانات"],"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":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["اسم المكتب","رقم الكتاب","تاريخ الكتاب","عدد الكتب","المبلغ",null,null,null,null,null,null,null,"اول تاريخ الايفاد","اخر تاريخ الايفاد"]
["مكتب رقم1",193,"2024-03-15",{"$f":"COUNTIF(البيانات!$Q$2:$Q$8150,B2)","v":7},{"$f":"SUM((البيانات!$P$2:$P$19999=A2)*(البيانات!$Q$2:$Q$19999=B2)*(البيانات!$R$2:$R$19999=C2)*البيانات!$W$2:$W$19999)","v":854},null,null,null,null,null,null,null,{"$f":"MIN(IF(A2=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-02-26"},{"$f":"MAX(IF(A2=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-02-28"}]
["مكتب رقم2",200,"2024-03-20",{"$f":"COUNTIF(البيانات!$Q$2:$Q$8150,B3)","v":10},{"$f":"SUM((البيانات!$P$2:$P$19999=A3)*(البيانات!$Q$2:$Q$19999=B3)*(البيانات!$R$2:$R$19999=C3)*البيانات!$W$2:$W$19999)","v":1238},null,null,null,null,null,null,null,{"$f":"MIN(IF(A3=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-02-29"},{"$f":"MAX(IF(A3=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-03-01"}]
["مكتب رقم10",205,"2024-03-20",{"$f":"COUNTIF(البيانات!$Q$2:$Q$8150,B4)","v":7},{"$f":"SUM((البيانات!$P$2:$P$19999=A4)*(البيانات!$Q$2:$Q$19999=B4)*(البيانات!$R$2:$R$19999=C4)*البيانات!$W$2:$W$19999)","v":1400},null,null,null,null,null,null,null,{"$f":"MIN(IF(A4=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-03-01"},{"$f":"MAX(IF(A4=البيانات!$P$2:$P$8623,البيانات!$C$2:$C$8623))","v":"2024-03-01"}]

{"sheet":"البيانات","index":1,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"تاريخ الايفاد",null,null,null,null,null,null,null,null,null,"الكمية","الغرامة",null,"اسم المكتب","رقم الكتاب","تاريخ الكتاب",null,null,null,null,"المبلغ"]
[null,null,"2024-02-26",null,null,null,null,null,null,null,null,null,30,1,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-26",null,null,null,null,null,null,null,null,null,31,2,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-27",null,null,null,null,null,null,null,null,null,32,5,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-27",null,null,null,null,null,null,null,null,null,30,1,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-28",null,null,null,null,null,null,null,null,null,32,0,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-28",null,null,null,null,null,null,null,null,null,33,0,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-28",null,null,null,null,null,null,null,null,null,34,6,null,"مكتب رقم1",193,"2024-03-15",null,null,null,null,122]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,29,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,122]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,28,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,122]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,30,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,122]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,30,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,122]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,32,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,33,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,34,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,29,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-02-29",null,null,null,null,null,null,null,null,null,28,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,30,0,null,"مكتب رقم2",200,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,30,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,32,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,33,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,34,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,125]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,29,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,300]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,28,0,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,300]
[null,null,"2024-03-01",null,null,null,null,null,null,null,null,null,30,11,null,"مكتب رقم10",205,"2024-03-20",null,null,null,null,300]