{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["day","التقرير"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"day","index":0,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,6,1,8],[1,2,2,2],[1,1,2,1],[1,0,2,0],[1,3,2,3],[1,20,1,22],[1,11,1,13],[1,23,2,23],[1,24,2,24],[1,9,1,10],[1,14,1,18]]}
[]
["التاريخ","المورد","الفاتورة","البيان","صندوق الريال",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,100,null,null,5000,3000]
["2020-10-26","الشلوي",1320,"شراء من الشلوي",null,null,null,null,null,null,null,null,1000,30,null,null,null,null,null,null,{"$f":"U4+V5-W5","v":130},{"$f":"N5","v":30},{"$f":"K5","v":0},{"$f":"X4+E5-F5","v":5000},{"$f":"Y4+G5+H5-I5","v":3000}]
["2020-10-26","الشلوي",1320,"سداد الشلوي",null,1000,null,null,null,null,null,1000,null,null,null,null,null,null,null,null,{"$f":"U5+V6-W6","v":130},{"$f":"N6","v":0},{"$f":"K6","v":0},{"$f":"X5+E6-F6","v":4000},{"$f":"Y5+G6+H6-I6","v":3000}]
["2020-10-26",null,null,"المبيعات اليومية",1100,null,null,500,null,1600,30,null,null,null,null,null,null,null,null,null,100,0,30,5100,3500]
["2020-10-26",null,null,"سداد هاتف ف/ 5",null,null,null,null,100,null,null,null,null,null,null,100,null,null,null,null,100,0,0,5100,3400]
["2020-10-26",null,null,"راتب الموظف",null,1500,null,null,null,null,null,null,null,null,null,null,null,1500,null,null,100,0,0,3600,3400]
["2020-10-26",null,null,"بوفية ف/ 17",null,50,null,null,null,null,null,null,null,null,null,null,null,null,50,null,100,0,0,3550,3400]
["2020-10-26","الشلوي",1600,"شراء من الحسام",null,null,null,null,null,null,null,null,500,15,null,null,null,null,null,null,{"$f":"U10+V11-W11","v":115},{"$f":"N11","v":15},{"$f":"K11","v":0},{"$f":"X10+E11-F11","v":3550},{"$f":"Y10+G11+H11-I11","v":3400}]
["2020-10-26","الشلوي",1600,"سداد الحسام",null,500,null,null,null,null,null,500,null,null,null,null,null,null,null,null,115,0,0,3050,3400]
["2020-10-26",null,null,"مرتجع اليومية",null,600,null,null,null,-600,-12,null,null,null,null,null,null,null,null,null,127,0,-12,2450,3400]

{"sheet":"التقرير","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7],[8,0,8,3],[2,0,2,3],[2,5,2,7]]}
["2020-10-26","تقرير يومية"]
["اريد قائمة منسدلة تظهر لي الشهر كامل او تجلب لي التاريخ من ورقة التسجيل (day)"]
["المبيعات",null,null,null,null,"المصروفات"]
["النوع","ريال","عدد","البيان",null,"النوع","المبلغ","البيان"]
["المبيعات اليومية",{"$f":"VLOOKUP($A$1,day!$A$5:$S$13,10,1)","v":-600},"اريد دالة تحدد نوع البيع سواء كان مبيعات او مرتجع",null,null,"ايجار ",{"$f":"VLOOKUP($A$1,day!$A$5:$S$13,15,0)","v":0},"اريدة دالة تظهر مبلغ وشرح المصروف اذا تحقق شرط التسجيل بعمود المصروف"]
["مرتجع المبيعات",{"$f":"VLOOKUP($A$1,day!$A$5:$S$13,10,1)","v":-600}," وان يتم جمع اكثر من مبيعات يومية ",null,null,"هاتف",{"$f":"VLOOKUP(A1,day!A5:S13,16,0)","v":0}]
[null,null,"اذا سجل بنفس التاريخ ",null,null,"كهرباء",{"$f":"_xll.XLOOKUP($A$1,day!$A$5:$A$13,day!P6:P14)","v":0}]
[null,null,null,null,null,"رواتب",{"$f":"_xll.XLOOKUP($A$1,day!$A$5:$A$13,day!P7:P15)","v":0}]
["المشتريات",null,null,null,null,"متنوعة",{"$f":"VLOOKUP($A$1,day!$A$5:$S$13,19,1)","v":0}]
["التسلسل","ريال","عدد","البيان"]
[1,null,null,{"$f":"VLOOKUP($A$1,day!$A$5:$S$10,2,0)&\" فاتورة رقم \"&VLOOKUP($A$1,day!$A$5:$S$10,3,0)","v":"الشلوي فاتورة رقم 1320"}]
[2,null,null,"اريدة لايكرر أسماء الموردين "]
[null,null,null,"وان يتسجلوا بالتسلسل اذا كان هناك مشتريات من اكثر من مورد بنفس اليوم"]
[]
[]
[null,"التقرير يعتمد على اذا سجلت تاريخ اليومية بالعمود A1 يعطيني تفصيلها بالتقرير"]