{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["التسعير","DataBase","References"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":33,"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":"التسعير","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["تقرير تراكمي بكميات الفراولة المستلمة من المورديين موسم 2021/2020"]
[null,null,null,null,"التــــــــــــــــاريـــــــــــــخ",null,null,null,null,null,null,"2020-12-02","محمود سالم محمد جبه"]
["م","القطاع","الكود","المزرعة","مــــــــــن","إلــــــــــى","فستيفال خام","فستيفال مجهز","أصناف خام","أصناف مجهز"]
[{"$f":"IF(ISBLANK(B4),\"\",SUBTOTAL(3,$B$4:B4))","v":1},"Q","02A",{"$f":"IFERROR(IF(B4=\"b\",VLOOKUP(C4,مزارع_البحيرة,2,FALSE),IF(B4=\"q\",VLOOKUP(C4,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2020-12-01","2020-12-15",7,{"$f":"+G4+2","v":9},6.5,{"$f":"I4+2","v":8.5}]
[{"$f":"IF(ISBLANK(B5),\"\",SUBTOTAL(3,$B$4:B5))","v":2},"Q","02A",{"$f":"IFERROR(IF(B5=\"b\",VLOOKUP(C5,مزارع_البحيرة,2,FALSE),IF(B5=\"q\",VLOOKUP(C5,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2020-12-16","2020-12-31",6.5,{"$f":"+G5+2","v":8.5},6,{"$f":"I5+2","v":8},null,{"$f":"VLOOKUP(IF(AND(E4:E7<=L2,F4:F7<=L2,D4:D7=M2),TRUE),D4:J7,4,TRUE)","v":{"$error":"#N/A"}}]
[{"$f":"IF(ISBLANK(B6),\"\",SUBTOTAL(3,$B$4:B6))","v":3},"Q","02A",{"$f":"IFERROR(IF(B6=\"b\",VLOOKUP(C6,مزارع_البحيرة,2,FALSE),IF(B6=\"q\",VLOOKUP(C6,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2021-01-01","2021-01-15",7.5,9.5,7,9]
[{"$f":"IF(ISBLANK(B7),\"\",SUBTOTAL(3,$B$4:B7))","v":4},"Q","02A",{"$f":"IFERROR(IF(B7=\"b\",VLOOKUP(C7,مزارع_البحيرة,2,FALSE),IF(B7=\"q\",VLOOKUP(C7,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2021-01-16","2021-01-31",8,10,8.5,10.5]
[{"$f":"IF(ISBLANK(B8),\"\",SUBTOTAL(3,$B$4:B8))","v":5},"Q","02B",{"$f":"IFERROR(IF(B8=\"b\",VLOOKUP(C8,مزارع_البحيرة,2,FALSE),IF(B8=\"q\",VLOOKUP(C8,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"سمير سيف الدين محمد"},"2020-12-01","2020-12-15",4.5,6.5,7.25,9.25,{"$f":"ROW(التسعير!$C$4:$C$44)","v":4}]
[{"$f":"IF(ISBLANK(B9),\"\",SUBTOTAL(3,$B$4:B9))","v":6},"Q","02B",{"$f":"IFERROR(IF(B9=\"b\",VLOOKUP(C9,مزارع_البحيرة,2,FALSE),IF(B9=\"q\",VLOOKUP(C9,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"سمير سيف الدين محمد"},"2020-12-16","2020-12-31",5.75,7.75,9.25,11.25]
[{"$f":"IF(ISBLANK(B10),\"\",SUBTOTAL(3,$B$4:B10))","v":7},"Q","02B","سمير سيف الدين محمد","2021-01-01","2021-01-15",9.25,11.25,8.75,10.75]
[{"$f":"IF(ISBLANK(B11),\"\",SUBTOTAL(3,$B$4:B11))","v":8},"Q","02B","سمير سيف الدين محمد","2021-01-16","2021-01-31",11,13,10.5,12.5]
[{"$f":"IF(ISBLANK(B12),\"\",SUBTOTAL(3,$B$4:B12))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B13),\"\",SUBTOTAL(3,$B$4:B13))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B14),\"\",SUBTOTAL(3,$B$4:B14))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B15),\"\",SUBTOTAL(3,$B$4:B15))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B16),\"\",SUBTOTAL(3,$B$4:B16))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B17),\"\",SUBTOTAL(3,$B$4:B17))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B18),\"\",SUBTOTAL(3,$B$4:B18))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B19),\"\",SUBTOTAL(3,$B$4:B19))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B20),\"\",SUBTOTAL(3,$B$4:B20))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B21),\"\",SUBTOTAL(3,$B$4:B21))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B22),\"\",SUBTOTAL(3,$B$4:B22))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B23),\"\",SUBTOTAL(3,$B$4:B23))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B24),\"\",SUBTOTAL(3,$B$4:B24))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B25),\"\",SUBTOTAL(3,$B$4:B25))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B26),\"\",SUBTOTAL(3,$B$4:B26))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B27),\"\",SUBTOTAL(3,$B$4:B27))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B28),\"\",SUBTOTAL(3,$B$4:B28))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B29),\"\",SUBTOTAL(3,$B$4:B29))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B30),\"\",SUBTOTAL(3,$B$4:B30))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B31),\"\",SUBTOTAL(3,$B$4:B31))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B32),\"\",SUBTOTAL(3,$B$4:B32))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B33),\"\",SUBTOTAL(3,$B$4:B33))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B34),\"\",SUBTOTAL(3,$B$4:B34))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B35),\"\",SUBTOTAL(3,$B$4:B35))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B36),\"\",SUBTOTAL(3,$B$4:B36))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B37),\"\",SUBTOTAL(3,$B$4:B37))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B38),\"\",SUBTOTAL(3,$B$4:B38))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B39),\"\",SUBTOTAL(3,$B$4:B39))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B40),\"\",SUBTOTAL(3,$B$4:B40))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B41),\"\",SUBTOTAL(3,$B$4:B41))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B42),\"\",SUBTOTAL(3,$B$4:B42))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B43),\"\",SUBTOTAL(3,$B$4:B43))","v":""},null,null,""]
[{"$f":"IF(ISBLANK(B44),\"\",SUBTOTAL(3,$B$4:B44))","v":""},null,null,""]

{"sheet":"DataBase","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["م","رقم النقلة","القطاع","الكود","المزرعة","التاريخ","الصنف","صافي وزن\nالنقلة","سعر الكيلو","مستحقات المورد"]
[{"$f":"IF(ISBLANK(B2),\"\",SUBTOTAL(3,$B$2:B2))","v":1},101,"Q","02a",{"$f":"IFERROR(IF(C2=\"b\",VLOOKUP(D2,مزارع_البحيرة,2,FALSE),IF(C2=\"q\",VLOOKUP(D2,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2021-01-15","فستيفال خام",1.5,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E2,IF($F2>=التسعير!$E$4:$E$1100,IF($F2<=التسعير!$F$4:$F$1100,1))),0),MATCH($G2,التسعير!$G$3:$J$3,0)),\"\")","v":7.5},{"$f":"IFERROR(DataBase!$H2*1000*DataBase!$I2,\"\")","v":11250}]
[{"$f":"IF(ISBLANK(B3),\"\",SUBTOTAL(3,$B$2:B3))","v":2},102,"Q","02B","سمير سيف الدين محمد","2021-01-15","فستيفال مجهز",1.365,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$44,SMALL(IF((التسعير!$C$4:$C$44=DataBase!D3)*(التسعير!$E$4:$E$44<=DataBase!F3)*(التسعير!$F$4:$F$44>=DataBase!F3),ROW(التسعير!C4:$C$44)-ROW(التسعير!C4)+1),1),MATCH(DataBase!G3,التسعير!G3:J3,0)),\"\")","v":11.25},{"$f":"IFERROR(DataBase!$H3*1000*DataBase!$I3,\"\")","v":15356.25}]
[{"$f":"IF(ISBLANK(B4),\"\",SUBTOTAL(3,$B$2:B4))","v":3},102,"Q","02a","محمد جمال الحمصاني","2021-01-08","أصناف خام",1.25,null,{"$f":"IFERROR(DataBase!$H4*1000*DataBase!$I4,\"\")","v":0}]
[{"$f":"IF(ISBLANK(B5),\"\",SUBTOTAL(3,$B$2:B5))","v":4},103,"Q","02A","محمد جمال الحمصاني","2021-01-10","فستيفال مجهز",1.6539999999999999,null,{"$f":"IFERROR(DataBase!$H5*1000*DataBase!$I5,\"\")","v":0}]
[{"$f":"IF(ISBLANK(B6),\"\",SUBTOTAL(3,$B$2:B6))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E6,\n     IF($F6>=التسعير!$E$4:$E$1100,IF($F6<=التسعير!$F$4:$F$1100,1))),0),MATCH($G6,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H6*1000*DataBase!$I6,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B7),\"\",SUBTOTAL(3,$B$2:B7))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E7,\n     IF($F7>=التسعير!$E$4:$E$1100,IF($F7<=التسعير!$F$4:$F$1100,1))),0),MATCH($G7,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H7*1000*DataBase!$I7,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B8),\"\",SUBTOTAL(3,$B$2:B8))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E8,\n     IF($F8>=التسعير!$E$4:$E$1100,IF($F8<=التسعير!$F$4:$F$1100,1))),0),MATCH($G8,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H8*1000*DataBase!$I8,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B9),\"\",SUBTOTAL(3,$B$2:B9))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E9,\n     IF($F9>=التسعير!$E$4:$E$1100,IF($F9<=التسعير!$F$4:$F$1100,1))),0),MATCH($G9,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H9*1000*DataBase!$I9,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B10),\"\",SUBTOTAL(3,$B$2:B10))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E10,\n     IF($F10>=التسعير!$E$4:$E$1100,IF($F10<=التسعير!$F$4:$F$1100,1))),0),MATCH($G10,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H10*1000*DataBase!$I10,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B11),\"\",SUBTOTAL(3,$B$2:B11))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E11,\n     IF($F11>=التسعير!$E$4:$E$1100,IF($F11<=التسعير!$F$4:$F$1100,1))),0),MATCH($G11,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H11*1000*DataBase!$I11,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B12),\"\",SUBTOTAL(3,$B$2:B12))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E12,\n     IF($F12>=التسعير!$E$4:$E$1100,IF($F12<=التسعير!$F$4:$F$1100,1))),0),MATCH($G12,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H12*1000*DataBase!$I12,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B13),\"\",SUBTOTAL(3,$B$2:B13))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E13,\n     IF($F13>=التسعير!$E$4:$E$1100,IF($F13<=التسعير!$F$4:$F$1100,1))),0),MATCH($G13,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H13*1000*DataBase!$I13,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B14),\"\",SUBTOTAL(3,$B$2:B14))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E14,\n     IF($F14>=التسعير!$E$4:$E$1100,IF($F14<=التسعير!$F$4:$F$1100,1))),0),MATCH($G14,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H14*1000*DataBase!$I14,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B15),\"\",SUBTOTAL(3,$B$2:B15))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E15,\n     IF($F15>=التسعير!$E$4:$E$1100,IF($F15<=التسعير!$F$4:$F$1100,1))),0),MATCH($G15,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H15*1000*DataBase!$I15,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B16),\"\",SUBTOTAL(3,$B$2:B16))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E16,\n     IF($F16>=التسعير!$E$4:$E$1100,IF($F16<=التسعير!$F$4:$F$1100,1))),0),MATCH($G16,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H16*1000*DataBase!$I16,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B17),\"\",SUBTOTAL(3,$B$2:B17))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E17,\n     IF($F17>=التسعير!$E$4:$E$1100,IF($F17<=التسعير!$F$4:$F$1100,1))),0),MATCH($G17,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H17*1000*DataBase!$I17,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B18),\"\",SUBTOTAL(3,$B$2:B18))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E18,\n     IF($F18>=التسعير!$E$4:$E$1100,IF($F18<=التسعير!$F$4:$F$1100,1))),0),MATCH($G18,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H18*1000*DataBase!$I18,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B19),\"\",SUBTOTAL(3,$B$2:B19))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E19,\n     IF($F19>=التسعير!$E$4:$E$1100,IF($F19<=التسعير!$F$4:$F$1100,1))),0),MATCH($G19,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H19*1000*DataBase!$I19,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B20),\"\",SUBTOTAL(3,$B$2:B20))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E20,\n     IF($F20>=التسعير!$E$4:$E$1100,IF($F20<=التسعير!$F$4:$F$1100,1))),0),MATCH($G20,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H20*1000*DataBase!$I20,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B21),\"\",SUBTOTAL(3,$B$2:B21))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E21,\n     IF($F21>=التسعير!$E$4:$E$1100,IF($F21<=التسعير!$F$4:$F$1100,1))),0),MATCH($G21,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H21*1000*DataBase!$I21,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B22),\"\",SUBTOTAL(3,$B$2:B22))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E22,\n     IF($F22>=التسعير!$E$4:$E$1100,IF($F22<=التسعير!$F$4:$F$1100,1))),0),MATCH($G22,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H22*1000*DataBase!$I22,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B23),\"\",SUBTOTAL(3,$B$2:B23))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E23,\n     IF($F23>=التسعير!$E$4:$E$1100,IF($F23<=التسعير!$F$4:$F$1100,1))),0),MATCH($G23,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H23*1000*DataBase!$I23,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B24),\"\",SUBTOTAL(3,$B$2:B24))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E24,\n     IF($F24>=التسعير!$E$4:$E$1100,IF($F24<=التسعير!$F$4:$F$1100,1))),0),MATCH($G24,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H24*1000*DataBase!$I24,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B25),\"\",SUBTOTAL(3,$B$2:B25))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E25,\n     IF($F25>=التسعير!$E$4:$E$1100,IF($F25<=التسعير!$F$4:$F$1100,1))),0),MATCH($G25,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H25*1000*DataBase!$I25,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B26),\"\",SUBTOTAL(3,$B$2:B26))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E26,\n     IF($F26>=التسعير!$E$4:$E$1100,IF($F26<=التسعير!$F$4:$F$1100,1))),0),MATCH($G26,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H26*1000*DataBase!$I26,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B27),\"\",SUBTOTAL(3,$B$2:B27))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E27,\n     IF($F27>=التسعير!$E$4:$E$1100,IF($F27<=التسعير!$F$4:$F$1100,1))),0),MATCH($G27,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H27*1000*DataBase!$I27,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B28),\"\",SUBTOTAL(3,$B$2:B28))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E28,\n     IF($F28>=التسعير!$E$4:$E$1100,IF($F28<=التسعير!$F$4:$F$1100,1))),0),MATCH($G28,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H28*1000*DataBase!$I28,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B29),\"\",SUBTOTAL(3,$B$2:B29))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E29,\n     IF($F29>=التسعير!$E$4:$E$1100,IF($F29<=التسعير!$F$4:$F$1100,1))),0),MATCH($G29,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H29*1000*DataBase!$I29,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B30),\"\",SUBTOTAL(3,$B$2:B30))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E30,\n     IF($F30>=التسعير!$E$4:$E$1100,IF($F30<=التسعير!$F$4:$F$1100,1))),0),MATCH($G30,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H30*1000*DataBase!$I30,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B31),\"\",SUBTOTAL(3,$B$2:B31))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E31,\n     IF($F31>=التسعير!$E$4:$E$1100,IF($F31<=التسعير!$F$4:$F$1100,1))),0),MATCH($G31,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H31*1000*DataBase!$I31,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B32),\"\",SUBTOTAL(3,$B$2:B32))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E32,\n     IF($F32>=التسعير!$E$4:$E$1100,IF($F32<=التسعير!$F$4:$F$1100,1))),0),MATCH($G32,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H32*1000*DataBase!$I32,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B33),\"\",SUBTOTAL(3,$B$2:B33))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E33,\n     IF($F33>=التسعير!$E$4:$E$1100,IF($F33<=التسعير!$F$4:$F$1100,1))),0),MATCH($G33,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H33*1000*DataBase!$I33,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B34),\"\",SUBTOTAL(3,$B$2:B34))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E34,\n     IF($F34>=التسعير!$E$4:$E$1100,IF($F34<=التسعير!$F$4:$F$1100,1))),0),MATCH($G34,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H34*1000*DataBase!$I34,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B35),\"\",SUBTOTAL(3,$B$2:B35))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E35,\n     IF($F35>=التسعير!$E$4:$E$1100,IF($F35<=التسعير!$F$4:$F$1100,1))),0),MATCH($G35,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H35*1000*DataBase!$I35,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B36),\"\",SUBTOTAL(3,$B$2:B36))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E36,\n     IF($F36>=التسعير!$E$4:$E$1100,IF($F36<=التسعير!$F$4:$F$1100,1))),0),MATCH($G36,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H36*1000*DataBase!$I36,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B37),\"\",SUBTOTAL(3,$B$2:B37))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E37,\n     IF($F37>=التسعير!$E$4:$E$1100,IF($F37<=التسعير!$F$4:$F$1100,1))),0),MATCH($G37,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H37*1000*DataBase!$I37,\"\")","v":""}]
[{"$f":"IF(ISBLANK(B38),\"\",SUBTOTAL(3,$B$2:B38))","v":""},null,null,null,"",null,null,null,{"$f":"IFERROR(INDEX(التسعير!$G$4:$J$1100,MATCH(1,IF(التسعير!$D$4:$D$1100=$E38,\n     IF($F38>=التسعير!$E$4:$E$1100,IF($F38<=التسعير!$F$4:$F$1100,1))),0),MATCH($G38,التسعير!$G$3:$J$3,0)),\"\")","v":""},{"$f":"IFERROR(DataBase!$H38*1000*DataBase!$I38,\"\")","v":""}]
[]
["-","-","-","-","-","-",null,{"$f":"SUBTOTAL(9,DataBase!$H$2:$H$38)","v":5.7690000000000001},{"$f":"J40/H40","v":4611.9344773790954},{"$f":"SUBTOTAL(9,DataBase!$J$2:$J$38)","v":26606.25}]
[null,null,null,null,null,null,null,null,"متوسط سعر الكيلو"]

{"sheet":"References","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["القطاع",null,"B","إسم المزرعة",null,"Q","إسم المزرعة",null,"الصنف"]
["B",null,"01A","سيد إسماعيل",null,"02A","محمد جمال الحمصاني",null,"فستيفال خام"]
["Q",null,"01B","محمود أحمد الشربيني",null,"02B","سمير سيف الدين محمد",null,"فستيفال مجهز"]
[null,null,"01C","سليمان أحمدمحمود",null,"02C","عبد الكريم سليمان السنوسي",null,"أصناف خام"]
[null,null,null,null,null,null,null,null,"أصناف مجهز"]
[null,null,null,null,null,null,null,null,"-"]