{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DATA","TEST","تجربتي"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"DATA","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["التاجر","شراء/بيع","الكمية","السعر","عمود وسيط","A","السعر",{"$f":"INDEX($A$2:$E$20,MATCH(MAX(E2:E20),E2:E20,0),MATCH($G$1,$A$1:$E$1,0))","v":7.1}]
["A","شراء",15,7.1,{"$f":"SUMIFS($C$2:$C$20,$A$2:$A$20,$F$1,$D$2:$D$20,D2)","v":91},{"$f":"IF(A2=\"محمد\",D2,\"\")","v":""}]
["B","شراء",12,1.3,{"$f":"SUMIFS($C$2:$C$20,$A$2:$A$20,$F$1,$D$2:$D$20,D3)","v":0}]
["C","شراء",4,5,0]
["C","بيع",10,9,0]
["A","شراء",20,2.5,20]
["B","بيع",38,5.5,0]
["C","شراء",6,5,0]
["A","بيع",10,7.1,91]
["C","شراء",10,9,0]
["A","بيع",30,7.1,91]
["B","بيع",4,1.3,0]
["A","شراء",30,1.7,30]
["A","بيع",10,2.8,10]
["C","بيع",10,5,0]
["B","شراء",32,5.5,0]
["B","بيع",34,1.3,0]
["A","شراء",36,7.1,91]
["B","شراء",17,2.5,20]
["محمد","بيع",15,4,0]

{"sheet":"TEST","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,0,5,1],[7,1,7,6]]}
["التاجر","شراء","بيع","إجمالي الكمية","السعر","شراء","بيع"]
["A",{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A2,DATA!$B$2:$B$1995,$B$1)","v":101},{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A2,DATA!$B$2:$B$1995,$C$1)","v":50},{"$f":"SUM(B2:C2)","v":151},7.1,{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A2),--(DATA!$B$2:$B$18=$B$1),--(DATA!$D$2:$D$18=$E2),DATA!$C$2:$C$18)","v":51},{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A2),--(DATA!$B$2:$B$18=$C$1),--(DATA!$D$2:$D$18=$E2),DATA!$C$2:$C$18)","v":40}]
["B",{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A3,DATA!$B$2:$B$1995,$B$1)","v":61},{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A3,DATA!$B$2:$B$1995,$C$1)","v":76},{"$f":"SUM(B3:C3)","v":137},5.5,{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A3),--(DATA!$B$2:$B$18=$B$1),--(DATA!$D$2:$D$18=$E3),DATA!$C$2:$C$18)","v":32},{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A3),--(DATA!$B$2:$B$18=$C$1),--(DATA!$D$2:$D$18=$E3),DATA!$C$2:$C$18)","v":38}]
["C",{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A4,DATA!$B$2:$B$1995,$B$1)","v":20},{"$f":"SUMIFS(DATA!$C$2:$C$1995,DATA!$A$2:$A$1995,TEST!$A4,DATA!$B$2:$B$1995,$C$1)","v":20},40,5,{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A4),--(DATA!$B$2:$B$18=$B$1),--(DATA!$D$2:$D$18=$E4),DATA!$C$2:$C$18)","v":10},{"$f":"SUMPRODUCT(--(DATA!$A$2:$A$18=$A4),--(DATA!$B$2:$B$18=$C$1),--(DATA!$D$2:$D$18=$E4),DATA!$C$2:$C$18)","v":10}]
[]
["الصيغة المكتوبة في الخلية E3"]
[]
[null,"ترجع أكثر رقم تكرر في عمود السعر مقابل الإسم محمد دون الإلتفات لإجمالي الكمية"]

{"sheet":"تجربتي","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["التاجر","شراء/بيع","الكمية","السعر","عمود وسيط","محمد","السعر",{"$f":"INDEX($A$2:$E$20,MATCH(MAX(E2:E20),E2:E20,0),MATCH($G$1,$A$1:$E$1,0))","v":5.5}]
["أحمد","شراء",10,7.1,{"$f":"SUMIFS($C$2:$C$20,$A$2:$A$20,$F$1,$D$2:$D$20,D2)","v":0},{"$f":"IF(A2=\"محمد\",D2,\"\")","v":""}]
["محمد","شراء",12,1.3,{"$f":"SUMIFS($C$2:$C$20,$A$2:$A$20,$F$1,$D$2:$D$20,D3)","v":50}]
["محمود","شراء",4,5,0]
["محمود","بيع",10,9,0]
["أحمد","شراء",20,2.5,17]
["محمد","بيع",38,5.5,70]
["محمود","شراء",6,5,0]
["أحمد","بيع",10,7.1,0]
["محمود","شراء",10,9,0]
["أحمد","بيع",30,7.1,0]
["محمد","بيع",4,1.3,50]
["أحمد","شراء",30,1.7,0]
["أحمد","بيع",10,2.8,0]
["محمود","بيع",10,5,0]
["محمد","شراء",32,5.5,70]
["محمد","بيع",34,1.3,50]
["أحمد","شراء",36,7.1,0]
["محمد","شراء",17,2.5,17]
["محمد","بيع",15,4,15]