{"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(Tbl_Tas3eer[الكود])","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-06","فستيفال خام",1.5,{"$f":"INDEX(الأسعار,IF((Tbl_Tas3eer[الكود]=Table8[[#This Row],[الكود]])*(Tbl_Tas3eer[مــــــــــن]>=Table8[[#This Row],[التاريخ]])*(Tbl_Tas3eer[إلــــــــــى]<=Table8[[#This Row],[التاريخ]]),ROW(Tbl_Tas3eer[الكود])),MATCH(Table8[[#This Row],[الصنف]],Tbl_Tas3eer[#Headers],0))","v":7},{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":10500}]
[{"$f":"IF(ISBLANK(B3),\"\",SUBTOTAL(3,$B$2:B3))","v":2},102,"Q","02B",{"$f":"IFERROR(IF(C3=\"b\",VLOOKUP(D3,مزارع_البحيرة,2,FALSE),IF(C3=\"q\",VLOOKUP(D3,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"سمير سيف الدين محمد"},"2021-01-08","أصناف خام",1.365,{"$f":"INDEX(الأسعار,IF((Tbl_Tas3eer[الكود]=Table8[[#This Row],[الكود]])*(Tbl_Tas3eer[مــــــــــن]>=Table8[[#This Row],[التاريخ]])*(Tbl_Tas3eer[إلــــــــــى]<=Table8[[#This Row],[التاريخ]]),ROW(Tbl_Tas3eer[الكود])),MATCH(Table8[[#This Row],[الصنف]],Tbl_Tas3eer[#Headers],0))","v":6.5},{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":8872.5}]
[{"$f":"IF(ISBLANK(B4),\"\",SUBTOTAL(3,$B$2:B4))","v":3},102,"Q","02a",{"$f":"IFERROR(IF(C4=\"b\",VLOOKUP(D4,مزارع_البحيرة,2,FALSE),IF(C4=\"q\",VLOOKUP(D4,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"محمد جمال الحمصاني"},"2021-01-08","أصناف خام",1.25,{"$f":"INDEX(الأسعار,IF((Tbl_Tas3eer[الكود]=Table8[[#This Row],[الكود]])*(Tbl_Tas3eer[مــــــــــن]>=Table8[[#This Row],[التاريخ]])*(Tbl_Tas3eer[إلــــــــــى]<=Table8[[#This Row],[التاريخ]]),ROW(Tbl_Tas3eer[الكود])),MATCH(Table8[[#This Row],[الصنف]],Tbl_Tas3eer[#Headers],0))","v":6.5},{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":8125}]
[{"$f":"IF(ISBLANK(B5),\"\",SUBTOTAL(3,$B$2:B5))","v":4},103,"Q","02B",{"$f":"IFERROR(IF(C5=\"b\",VLOOKUP(D5,مزارع_البحيرة,2,FALSE),IF(C5=\"q\",VLOOKUP(D5,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":"سمير سيف الدين محمد"},"2021-01-10","فستيفال مجهز",1.6539999999999999,{"$f":"INDEX(الأسعار,IF((Tbl_Tas3eer[الكود]=Table8[[#This Row],[الكود]])*(Tbl_Tas3eer[مــــــــــن]>=Table8[[#This Row],[التاريخ]])*(Tbl_Tas3eer[إلــــــــــى]<=Table8[[#This Row],[التاريخ]]),ROW(Tbl_Tas3eer[الكود])),MATCH(Table8[[#This Row],[الصنف]],Tbl_Tas3eer[#Headers],0))","v":9},{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":14886}]
[{"$f":"IF(ISBLANK(B6),\"\",SUBTOTAL(3,$B$2:B6))","v":""},null,null,null,{"$f":"IFERROR(IF(C6=\"b\",VLOOKUP(D6,مزارع_البحيرة,2,FALSE),IF(C6=\"q\",VLOOKUP(D6,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B7),\"\",SUBTOTAL(3,$B$2:B7))","v":""},null,null,null,{"$f":"IFERROR(IF(C7=\"b\",VLOOKUP(D7,مزارع_البحيرة,2,FALSE),IF(C7=\"q\",VLOOKUP(D7,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B8),\"\",SUBTOTAL(3,$B$2:B8))","v":""},null,null,null,{"$f":"IFERROR(IF(C8=\"b\",VLOOKUP(D8,مزارع_البحيرة,2,FALSE),IF(C8=\"q\",VLOOKUP(D8,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B9),\"\",SUBTOTAL(3,$B$2:B9))","v":""},null,null,null,{"$f":"IFERROR(IF(C9=\"b\",VLOOKUP(D9,مزارع_البحيرة,2,FALSE),IF(C9=\"q\",VLOOKUP(D9,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B10),\"\",SUBTOTAL(3,$B$2:B10))","v":""},null,null,null,{"$f":"IFERROR(IF(C10=\"b\",VLOOKUP(D10,مزارع_البحيرة,2,FALSE),IF(C10=\"q\",VLOOKUP(D10,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B11),\"\",SUBTOTAL(3,$B$2:B11))","v":""},null,null,null,{"$f":"IFERROR(IF(C11=\"b\",VLOOKUP(D11,مزارع_البحيرة,2,FALSE),IF(C11=\"q\",VLOOKUP(D11,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B12),\"\",SUBTOTAL(3,$B$2:B12))","v":""},null,null,null,{"$f":"IFERROR(IF(C12=\"b\",VLOOKUP(D12,مزارع_البحيرة,2,FALSE),IF(C12=\"q\",VLOOKUP(D12,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B13),\"\",SUBTOTAL(3,$B$2:B13))","v":""},null,null,null,{"$f":"IFERROR(IF(C13=\"b\",VLOOKUP(D13,مزارع_البحيرة,2,FALSE),IF(C13=\"q\",VLOOKUP(D13,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B14),\"\",SUBTOTAL(3,$B$2:B14))","v":""},null,null,null,{"$f":"IFERROR(IF(C14=\"b\",VLOOKUP(D14,مزارع_البحيرة,2,FALSE),IF(C14=\"q\",VLOOKUP(D14,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B15),\"\",SUBTOTAL(3,$B$2:B15))","v":""},null,null,null,{"$f":"IFERROR(IF(C15=\"b\",VLOOKUP(D15,مزارع_البحيرة,2,FALSE),IF(C15=\"q\",VLOOKUP(D15,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B16),\"\",SUBTOTAL(3,$B$2:B16))","v":""},null,null,null,{"$f":"IFERROR(IF(C16=\"b\",VLOOKUP(D16,مزارع_البحيرة,2,FALSE),IF(C16=\"q\",VLOOKUP(D16,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B17),\"\",SUBTOTAL(3,$B$2:B17))","v":""},null,null,null,{"$f":"IFERROR(IF(C17=\"b\",VLOOKUP(D17,مزارع_البحيرة,2,FALSE),IF(C17=\"q\",VLOOKUP(D17,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B18),\"\",SUBTOTAL(3,$B$2:B18))","v":""},null,null,null,{"$f":"IFERROR(IF(C18=\"b\",VLOOKUP(D18,مزارع_البحيرة,2,FALSE),IF(C18=\"q\",VLOOKUP(D18,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B19),\"\",SUBTOTAL(3,$B$2:B19))","v":""},null,null,null,{"$f":"IFERROR(IF(C19=\"b\",VLOOKUP(D19,مزارع_البحيرة,2,FALSE),IF(C19=\"q\",VLOOKUP(D19,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B20),\"\",SUBTOTAL(3,$B$2:B20))","v":""},null,null,null,{"$f":"IFERROR(IF(C20=\"b\",VLOOKUP(D20,مزارع_البحيرة,2,FALSE),IF(C20=\"q\",VLOOKUP(D20,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B21),\"\",SUBTOTAL(3,$B$2:B21))","v":""},null,null,null,{"$f":"IFERROR(IF(C21=\"b\",VLOOKUP(D21,مزارع_البحيرة,2,FALSE),IF(C21=\"q\",VLOOKUP(D21,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B22),\"\",SUBTOTAL(3,$B$2:B22))","v":""},null,null,null,{"$f":"IFERROR(IF(C22=\"b\",VLOOKUP(D22,مزارع_البحيرة,2,FALSE),IF(C22=\"q\",VLOOKUP(D22,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B23),\"\",SUBTOTAL(3,$B$2:B23))","v":""},null,null,null,{"$f":"IFERROR(IF(C23=\"b\",VLOOKUP(D23,مزارع_البحيرة,2,FALSE),IF(C23=\"q\",VLOOKUP(D23,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B24),\"\",SUBTOTAL(3,$B$2:B24))","v":""},null,null,null,{"$f":"IFERROR(IF(C24=\"b\",VLOOKUP(D24,مزارع_البحيرة,2,FALSE),IF(C24=\"q\",VLOOKUP(D24,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B25),\"\",SUBTOTAL(3,$B$2:B25))","v":""},null,null,null,{"$f":"IFERROR(IF(C25=\"b\",VLOOKUP(D25,مزارع_البحيرة,2,FALSE),IF(C25=\"q\",VLOOKUP(D25,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B26),\"\",SUBTOTAL(3,$B$2:B26))","v":""},null,null,null,{"$f":"IFERROR(IF(C26=\"b\",VLOOKUP(D26,مزارع_البحيرة,2,FALSE),IF(C26=\"q\",VLOOKUP(D26,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B27),\"\",SUBTOTAL(3,$B$2:B27))","v":""},null,null,null,{"$f":"IFERROR(IF(C27=\"b\",VLOOKUP(D27,مزارع_البحيرة,2,FALSE),IF(C27=\"q\",VLOOKUP(D27,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B28),\"\",SUBTOTAL(3,$B$2:B28))","v":""},null,null,null,{"$f":"IFERROR(IF(C28=\"b\",VLOOKUP(D28,مزارع_البحيرة,2,FALSE),IF(C28=\"q\",VLOOKUP(D28,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B29),\"\",SUBTOTAL(3,$B$2:B29))","v":""},null,null,null,{"$f":"IFERROR(IF(C29=\"b\",VLOOKUP(D29,مزارع_البحيرة,2,FALSE),IF(C29=\"q\",VLOOKUP(D29,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B30),\"\",SUBTOTAL(3,$B$2:B30))","v":""},null,null,null,{"$f":"IFERROR(IF(C30=\"b\",VLOOKUP(D30,مزارع_البحيرة,2,FALSE),IF(C30=\"q\",VLOOKUP(D30,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B31),\"\",SUBTOTAL(3,$B$2:B31))","v":""},null,null,null,{"$f":"IFERROR(IF(C31=\"b\",VLOOKUP(D31,مزارع_البحيرة,2,FALSE),IF(C31=\"q\",VLOOKUP(D31,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B32),\"\",SUBTOTAL(3,$B$2:B32))","v":""},null,null,null,{"$f":"IFERROR(IF(C32=\"b\",VLOOKUP(D32,مزارع_البحيرة,2,FALSE),IF(C32=\"q\",VLOOKUP(D32,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B33),\"\",SUBTOTAL(3,$B$2:B33))","v":""},null,null,null,{"$f":"IFERROR(IF(C33=\"b\",VLOOKUP(D33,مزارع_البحيرة,2,FALSE),IF(C33=\"q\",VLOOKUP(D33,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B34),\"\",SUBTOTAL(3,$B$2:B34))","v":""},null,null,null,{"$f":"IFERROR(IF(C34=\"b\",VLOOKUP(D34,مزارع_البحيرة,2,FALSE),IF(C34=\"q\",VLOOKUP(D34,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B35),\"\",SUBTOTAL(3,$B$2:B35))","v":""},null,null,null,{"$f":"IFERROR(IF(C35=\"b\",VLOOKUP(D35,مزارع_البحيرة,2,FALSE),IF(C35=\"q\",VLOOKUP(D35,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B36),\"\",SUBTOTAL(3,$B$2:B36))","v":""},null,null,null,{"$f":"IFERROR(IF(C36=\"b\",VLOOKUP(D36,مزارع_البحيرة,2,FALSE),IF(C36=\"q\",VLOOKUP(D36,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B37),\"\",SUBTOTAL(3,$B$2:B37))","v":""},null,null,null,{"$f":"IFERROR(IF(C37=\"b\",VLOOKUP(D37,مزارع_البحيرة,2,FALSE),IF(C37=\"q\",VLOOKUP(D37,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[{"$f":"IF(ISBLANK(B38),\"\",SUBTOTAL(3,$B$2:B38))","v":""},null,null,null,{"$f":"IFERROR(IF(C38=\"b\",VLOOKUP(D38,مزارع_البحيرة,2,FALSE),IF(C38=\"q\",VLOOKUP(D38,مزارع_القليوبية,2,FALSE),\"\")),\"\")","v":""},null,null,null,null,{"$f":"Table8[[#This Row],[صافي وزن\nالنقلة]]*1000*Table8[[#This Row],[سعر الكيلو]]","v":0}]
[]
["-","-","-","-","-","-",null,{"$f":"SUBTOTAL(9,Table8[صافي وزن\nالنقلة])","v":5.7690000000000001},{"$f":"J40/H40","v":7346.7672040214939},{"$f":"SUBTOTAL(9,Table8[مستحقات المورد])","v":42383.5}]
[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,"-"]