{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["البيانات","تقرير"],"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":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,0,1,0],[0,5,1,5]]}
["التاريخ","المبيعات",null,"المشتريات",null,"المصروف","النقد"]
[null,"المبلغ","الكمية","المبلغ","الكمية",null,1000]
["2022-02-23",390,3,700,7,10,{"$f":"G2+B3-D3-F3","v":680}]
["2022-02-24",590,5,null,null,47,{"$f":"G3+B4-D4-F4","v":1223}]
["2022-02-25",230,2,400,4,23,1030]
[null,null,null,null,null,null,1030]
[null,null,null,null,null,null,1030]
[null,null,null,null,null,null,1030]
[null,null,null,null,null,null,1030]
[null,null,null,null,null,null,1030]

{"sheet":"تقرير","index":1,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4],[3,10,3,12],[4,10,4,12],[0,5,0,6],[1,0,1,2],[1,3,1,5],[1,6,1,8],[2,10,2,12],[1,9,1,12]]}
[null,null,null,null,null,{"$f":"I1-1","v":"2022-02-23"},null,"الى","2022-02-24","يوم",{"$f":"F1","v":"2022-02-23"},{"$f":"IF(F1<>I1,\"و\",\"\")","v":"و"},{"$f":"IF(F1<>I1,I1,\"\")","v":"2022-02-24"}]
["البيع",null,null,"الشراء",null,null,"الرصيد",null,null,"المعلقات"]
["المبلغ","الكمية","السعر","المبلغ","الكمية","العدل","الصندوق ","البنك","الاجمالي ","المبلغ","الايضاح"]
[{"$f":"SUMPRODUCT(--((البيانات!$A$2:$A$9999<=I1)*(البيانات!$A$2:$A$9999>=F1)),البيانات!$B$2:$B$9999)","v":980},{"$f":"SUMPRODUCT(--((البيانات!$A$2:$A$9999<=I1)*(البيانات!$A$2:$A$9999>=F1)),البيانات!$C$2:$C$9999)","v":8},{"$f":"A4/B4","v":122.5},{"$f":"SUMPRODUCT(--((البيانات!$A$2:$A$9999<=I1)*(البيانات!$A$2:$A$9999>=F1)),البيانات!$D$2:$D$9999)","v":700},{"$f":"SUMPRODUCT(--((البيانات!$A$2:$A$9999<=I1)*(البيانات!$A$2:$A$9999>=F1)),البيانات!$E$2:$E$9999)","v":7},{"$f":"D4/E4","v":100},{"$f":"LOOKUP(99999,البيانات!G:G,البيانات!G:G)","v":1030},500,{"$f":"H4++G4","v":1530},10,"مواصلات"]
[{"$f":"SUM(A4:A4)","v":980},{"$f":"SUM(B4:B4)","v":8},{"$f":"SUM(C4)","v":122.5},{"$f":"SUM(D4:D4)","v":700},{"$f":"SUM(E4:E4)","v":7},{"$f":"SUM(F4)","v":100},{"$f":"SUM(G4:G4)","v":1030},{"$f":"SUM(H4:H4)","v":500},{"$f":"SUM(I4:I4)","v":1530},{"$f":"SUM(J4:J4)","v":10},"الإجمالي"]