{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DATA","اليومية","العملاء","بيانات"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["اسم العميل","التاريخ","رقم السند","البيان","المبلغ","اجمالي الفاتورة","الدفعه","البنك","مرتجع","خصم","الاجمالي","عدد القطع","اسم البنك","مصروف","سلف","المنطقة","تصنيف رئيسي","تصنيف فرعي","Column1","تصنيف رئيسي 1","الدفعه 1","دفعات مورد","دفعات زبائن","يوم التحصيل","ملاحظات","المتبقي"]
["عمرو شبين","2019-07-18",null,"فاتورة",100,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D6:E7,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D6:E15,2,0),\"0\")","v":50},{"$f":"IFERROR(VLOOKUP(\"بنك\",D6:E15,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D6:E15,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"خصم\",D6:E15,2,0),\"0\")","v":10},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D6:E15,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D6:E15,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A6,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A6,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"IFERROR(VLOOKUP(A6,بيانات[#All],7,0),\"\")","v":"جملة"},null,{"$f":"IFERROR(VLOOKUP(A6,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"G6","v":50},{"$f":"IFERROR(VLOOKUP(\"مورد\",T6:U6,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"زبون\",T6:U6,2,0),\"0\")","v":50}]
["عمرو شبين","2019-07-18",null,"دفعه",50,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D7:E8,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D7:E8,2,0),\"0\")","v":50},{"$f":"IFERROR(VLOOKUP(\"بنك\",D7:E8,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D7:E8,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"خصم\",D7:E8,2,0),\"0\")","v":"0"},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D7:E8,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D7:E8,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A7,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A7,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"IFERROR(VLOOKUP(A7,بيانات[#All],7,0),\"\")","v":"جملة"},null,{"$f":"IFERROR(VLOOKUP(A7,بيانات[#All],6,0),\"\")","v":"زبون"},50,"0",50]
["عمرو شبين","2019-07-18",null,"بنك",10,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D8:E10,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D8:E10,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"بنك\",D8:E10,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D8:E10,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"خصم\",D8:E10,2,0),\"0\")","v":10},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D8:E10,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D8:E10,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A8,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A8,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"IFERROR(VLOOKUP(A8,بيانات[#All],7,0),\"\")","v":"جملة"},null,{"$f":"IFERROR(VLOOKUP(A8,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"G8","v":"0"},{"$f":"IFERROR(VLOOKUP(\"مورد\",T8:U8,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"زبون\",T8:U8,2,0),\"0\")","v":"0"}]
["عمرو شبين","2019-07-18",null,"خصم",10,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D9:E12,2,0),\"0\")","v":1000},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D9:E12,2,0),\"0\")","v":500},{"$f":"IFERROR(VLOOKUP(\"بنك\",D9:E12,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D9:E12,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"خصم\",D9:E12,2,0),\"0\")","v":10},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D9:E12,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D9:E12,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A9,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A9,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"IFERROR(VLOOKUP(A9,بيانات[#All],7,0),\"\")","v":"جملة"},null,{"$f":"IFERROR(VLOOKUP(A9,بيانات[#All],6,0),\"\")","v":"زبون"},500,"0",500]
["عمرو شبين","2019-07-18",null,"مرتجع",10,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D10:E14,2,0),\"0\")","v":1000},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D10:E14,2,0),\"0\")","v":500},{"$f":"IFERROR(VLOOKUP(\"بنك\",D10:E14,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D10:E14,2,0),\"0\")","v":10},{"$f":"IFERROR(VLOOKUP(\"خصم\",D10:E14,2,0),\"0\")","v":100},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D10:E14,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D10:E14,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A10,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A10,بيانات[#All],6,0),\"\")","v":"زبون"},{"$f":"IFERROR(VLOOKUP(A10,بيانات[#All],7,0),\"\")","v":"جملة"},null,{"$f":"IFERROR(VLOOKUP(A10,بيانات[#All],6,0),\"\")","v":"زبون"},500,"0",500]
["عمرو شبين مورد","2019-07-18",null,"فاتورة",1000,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D11:E16,2,0),\"0\")","v":1000},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D11:E16,2,0),\"0\")","v":500},{"$f":"IFERROR(VLOOKUP(\"بنك\",D11:E16,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D11:E16,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"خصم\",D11:E16,2,0),\"0\")","v":100},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D11:E16,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D11:E16,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A11,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A11,بيانات[#All],6,0),\"\")","v":"مورد"},{"$f":"IFERROR(VLOOKUP(A11,بيانات[#All],7,0),\"\")","v":"بدون"},null,{"$f":"IFERROR(VLOOKUP(A11,بيانات[#All],6,0),\"\")","v":"مورد"},500,500,"0"]
["عمرو شبين مورد","2019-07-18",null,"دفعه",500,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D12:E18,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D12:E18,2,0),\"0\")","v":500},{"$f":"IFERROR(VLOOKUP(\"بنك\",D12:E18,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D12:E18,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"خصم\",D12:E18,2,0),\"0\")","v":100},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D12:E18,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D12:E18,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A12,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A12,بيانات[#All],6,0),\"\")","v":"مورد"},{"$f":"IFERROR(VLOOKUP(A12,بيانات[#All],7,0),\"\")","v":"بدون"},null,{"$f":"IFERROR(VLOOKUP(A12,بيانات[#All],6,0),\"\")","v":"مورد"},500,500,"0"]
["عمرو شبين مورد","2019-07-18",null,"بنك",100,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D13:E20,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D13:E20,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"بنك\",D13:E20,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D13:E20,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"خصم\",D13:E20,2,0),\"0\")","v":100},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D13:E20,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D13:E20,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A13,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A13,بيانات[#All],6,0),\"\")","v":"مورد"},{"$f":"IFERROR(VLOOKUP(A13,بيانات[#All],7,0),\"\")","v":"بدون"},null,{"$f":"IFERROR(VLOOKUP(A13,بيانات[#All],6,0),\"\")","v":"مورد"},"0","0","0"]
["عمرو شبين مورد","2019-07-18",null,"خصم",100,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D14:E22,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D14:E22,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"بنك\",D14:E22,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D14:E22,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"خصم\",D14:E22,2,0),\"0\")","v":100},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D14:E22,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D14:E22,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A14,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A14,بيانات[#All],6,0),\"\")","v":"مورد"},{"$f":"IFERROR(VLOOKUP(A14,بيانات[#All],7,0),\"\")","v":"بدون"},null,{"$f":"IFERROR(VLOOKUP(A14,بيانات[#All],6,0),\"\")","v":"مورد"},"0","0","0"]
["عمرو شبين مورد","2019-07-18",null,"مرتجع",100,{"$f":"IFERROR(VLOOKUP(\"فاتورة\",D15:E24,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"دفعه\",D15:E24,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"بنك\",D15:E24,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"مرتجع\",D15:E24,2,0),\"0\")","v":100},{"$f":"IFERROR(VLOOKUP(\"خصم\",D15:E24,2,0),\"0\")","v":"0"},null,null,null,{"$f":"IFERROR(VLOOKUP(\"مصروف\",D15:E24,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(\"سلف\",D15:E24,2,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(A15,بيانات[#All],3,0),\"\")","v":"شبين"},{"$f":"IFERROR(VLOOKUP(A15,بيانات[#All],6,0),\"\")","v":"مورد"},{"$f":"IFERROR(VLOOKUP(A15,بيانات[#All],7,0),\"\")","v":"بدون"},null,{"$f":"IFERROR(VLOOKUP(A15,بيانات[#All],6,0),\"\")","v":"مورد"},"0","0","0"]

{"sheet":"اليومية","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"العملاء","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of اجمالي الفاتورة","Sum of الدفعه","Sum of البنك","Sum of مرتجع","Sum of خصم"]
["عمرو شبين",2100,1100,130,40,130]
["عمرو شبين مورد",1000,1000,300,500,400]
["Grand Total",3100,2100,430,540,530]

{"sheet":"بيانات","index":3,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"فاتورة"]
["اسم العميل","التليفون","العنوان","يوم التحصيل","اسم المندوب","تصنيف رئيسي","تصنيف فرعي",null,null,null,null,null,null,null,"دفعه"]
["عمرو شبين",1,"شبين","السبت","المكتب","زبون","جملة",null,null,null,null,null,null,null,"بنك"]
["عمرو شبين مورد",1,"شبين","الجمعه","بدون","مورد","بدون",null,null,null,null,null,null,null,"مصروف"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خصم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مرتجع"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"سلف"]