{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"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":"Sheet1","index":0,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"التاريخ","رقم الاذن","كود الصنف","اسم الصنف","رقم الصنف","الكميه","السعر","التكلفه","كود الجهة","اسم الجهة"]
[null,null,"2025-06-18",1410,19,"زيت",null,15,9500,{"$f":"H4*I4","v":142500},16,"مكتب العريش"]
[null,null,"2025-06-18",1410,1,"سكر",null,48,1180,{"$f":"H5*I5","v":56640},16,"مكتب العريش"]
[null,null,"2025-06-18",1412,2,"شاى",null,20,2900,58000,16,"مكتب العريش"]
[null,null,"2025-06-18",1412,17,"شاى فتله",null,3,8400,25200,16,"مكتب العريش"]
[null,null,"2025-06-18",1412,16,"حلاوه",null,5,2100,10500,16,"مكتب العريش"]
[null,null,"2025-06-18",1412,85,"مربى",null,1,2100,2100,16,"مكتب العريش"]
[null,null,"2025-06-18",1412,18,"سكر",null,4,2600,10400,16,"مكتب العريش"]
[null,null,"2025-06-18",1515,90,"شاى",null,2,3800,7600,16,"مكتب العريش"]
[null,null,"2025-06-18",1515,89,"زيت",null,1,7200,7200,16,"مكتب العريش"]
[null,null,"2025-06-18",1515,88,"جبنه",null,5,8200,41000,16,"مكتب العريش"]
[null,null,"2025-06-18",1515,91,"جبنه",null,3,4450,13350,16,"مكتب العريش"]
[null,null,"2025-06-18",1516,97,"طحينه",null,46,1650,75900,16,"مكتب العريش"]
[null,null,"2025-06-18",1718,67,"خل",null,6,500,3000,12,"مكتب السيد"]
[null,null,"2025-06-20",1414,67,"خل",null,6,1200,7200,7,"مكتب حسنى"]
[null,null,"2025-06-20",1415,22,"جبنه",null,15,7700,115500,7,"السيد عبده"]
[null,null,"2025-06-20",1416,15,"سكر",null,3,19800,59400,7,"السيد عبده"]
[null,null,"2025-06-24",1415,66,"زيت",null,10,300,3000,15,"مكتب الدقى"]
[null,null,"2025-06-24",1415,82,"سكر",null,1,400,400,15,"مكتب الدقى"]
[null,null,"2025-06-24",1418,70,"زيت",null,6,250,1500,15,"مكتب الدقى"]
[null,null,"2025-06-24",1418,69,{"$f":"IFERROR(VLOOKUP(E23,[1]الاصناف!$A:$E,2,0),\"\")","v":"شميز صينى"},null,6,300,1800,15,"مكتب الدقى",{"$f":"IF(COUNTIFS(L$4:L23,L23,D$4:D23,D23)=1,D23,\"\")","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,8,8,8],[27,4,27,5],[29,4,29,5],[6,4,8,4],[6,5,8,5],[6,6,6,7],[7,6,8,6],[7,7,8,7],[1,4,1,5],[1,6,1,8],[2,4,2,5],[2,6,2,8],[3,4,3,5],[3,6,3,8]]}
[]
[null,null,null,null,"اسـم العميل ",null,"مكتب العريش"]
[]
[]
[]
[]
[null,null,null,null,"م","التاريخ","المبلغ",null,"البيان"]
[null,null,null,null,null,null,"مسدد","مستحق","فاتوره الشركه / البيان"]
[]
[null,null,null,null,null,null,0,43110,"رصيد مرحل"]
[null,null,null,null,1]
[null,null,null,null,2,{"$f":"IFERROR(VLOOKUP($C11,'[2]Sheet1 (2)'!$F$5:$L$1003,3,1),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP($C11,'[2]Sheet1 (2)'!$F$5:$Q$1003,10,1),\"\")","v":""}]
[null,null,null,null,3,{"$f":"IFERROR(VLOOKUP($C12,'[2]Sheet1 (2)'!$F$5:$L$1003,3,1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C12,'[2]Sheet1 (2)'!$F$5:$L$1003,4,1),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($C12,'[2]Sheet1 (2)'!$F$5:$Q$1003,10,1),\"\")","v":""}]
[null,null,null,null,4,{"$f":"IFERROR(VLOOKUP($C13,'[2]Sheet1 (2)'!$F$5:$L$1003,3,1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C13,'[2]Sheet1 (2)'!$F$5:$L$1003,4,1),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($C13,'[2]Sheet1 (2)'!$F$5:$Q$1003,10,1),\"\")","v":""}]
[null,null,null,null,5,{"$f":"IFERROR(VLOOKUP($C14,'[2]Sheet1 (2)'!$F$5:$L$1003,3,1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C14,'[2]Sheet1 (2)'!$F$5:$L$1003,4,1),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($C14,'[2]Sheet1 (2)'!$F$5:$Q$1003,10,1),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($C16,'[2]Sheet1 (2)'!$F$5:$L$1003,3,1),\" \")","v":" "},null,null,{"$f":"IFERROR(VLOOKUP($C16,'[2]Sheet1 (2)'!$F$5:$Q$1003,10,1),\"\")","v":""}]
[null,null,null,null,1,null,null,null,1410]
[null,null,null,null,2,null,null,null,1412]
[null,null,null,null,3,null,null,null,1515]
[null,null,null,null,4,null,null,null,1516]
[null,null,null,null,5]
[null,null,null,null,6]
[null,null,null,null,7]
[null,null,null,null,8]
[null,null,null,null,9]
[null,null,null,null,10]
[]
[null,null,null,null,"الاجمالى",null,{"$f":"SUM(G10:G26)","v":0},{"$f":"SUM(H10:H26)","v":43110}]
[]
[null,null,null,null,"الفرق",null,{"$f":"IF(G28>H28,G28-H28,0)","v":0},{"$f":"+H28-G28","v":43110}]