{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["list","دفتراليومية","تقرير الخزينة","تقرير الموردين الاعمال","تقرير موردين الالات","تقرير المشتريات والمواد خام","تقرير موردين الصناعية","تقرير موردين الالات ","تقرير موردين الخامات "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"list","index":0,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"اسم الموردين",null,"أسماء الالات ",null,"الأصناف المخازن",null,"رقم العقار",null,"الوحدة",null,"الاعمال",null,"اتوجيه محاسبى"]
[null,"رضا",null,"جرار صغير ",null,"زلط",null,"رقم1",null,"طن",null,"نقل رمل",null,"إيداع"]
[null,"إبراهيم",null,"جرار بمفطورة",null,"رمل",null,"رقم2",null,"عدد",null,"احضار مياه",null,"مورد"]
[null,"محمود",null,"بلدوزر كبير",null,"اسمنت",null,"رقم3",null,"لتر",null,"بناء"]
[null,"محمد",null,"لودر",null,"جبس ",null,"رقم4",null,null,null,"صب"]
[null,0,null,"كساحة",null,null,null,"رقم5",null,null,null,"محارة"]
[null,null,null,null,null,null,null,null,null,null,null,"تسوية"]

{"sheet":"دفتراليومية","index":1,"n_rows":37,"n_cols":28,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"رقم السند","التاريخ","البيان والشرح","الرصيد العهدة","إيداع نقدية","صرف نقدية","المصروف","اسم المورد","اسم المورد","المكان","الاعمال","المقاس","الفئة","القيمة","اسم المورد","الاعمال","اسم  المعدة","عددساعات / النقلة","الفئة","القيمة","المكان","اسم المورد","الأصناف","الوحدة","الكمية","السعر","القيمة"]
[null,100,"2020-01-01","بفابلابل",{"$f":"0+F5-G5","v":500},500,null,"إيداع",0,"رضا","رقم1","بناء",5,100,{"$f":"+N5*M5","v":500},"رضا","نقل رمل","جرار صغير ",5,100,{"$f":"+S5*T5","v":500},"رقم1","رضا","زلط","طن",20,250,{"$f":"+Z5+AA5","v":270}]
[null,"0102","2020-02-05","سداد",{"$f":"+E5+F6-G6","v":380},null,120,"مورد","رضا","إبراهيم","رقم2","صب",7,320,{"$f":"+N6*M6","v":2240},"إبراهيم","نقل رمل","جرار بمفطورة",8,200,{"$f":"+S6*T6","v":1600},"رقم2","إبراهيم","رمل","طن",200,150,{"$f":"+Z6+AA6","v":350}]
[null,101,"2020-03-11","بفابلابل",{"$f":"+E6+F7-G7","v":881},501,null,"إيداع",0,"محمود","رقم3","محارة",10,500,5000,"محمود","احضار مياه","بلدوزر كبير",7,300,2100,"رقم3","محمود","اسمنت","طن",300,350,650]
[null,"0103","2020-04-15","سداد",760,null,121,"مورد","رضا","محمد","رقم4","بناء",50,706.66666666666697,35333.33333333335,"محمد","تسوية","لودر",5,100,500,"رقم4","محمد","جبس ","طن",500,350,850]
[null,102,"2020-05-20","بفابلابل",1262,502,null,"إيداع",0,"رضا","رقم5","صب",52.5,906.66666666666697,47600.000000000015,"رضا","نقل رمل","كساحة",8,200,1600,"رقم5","رضا","رمل","طن",300,400,700]
[null,"0104","2020-06-24","سداد",1140,null,122,"مورد","رضا","إبراهيم","رقم6","محارة",66.3,1106.6666666666699,73372.000000000218,"إبراهيم","نقل رمل","جرار صغير ",7,300,2100,"رقم1","إبراهيم","اسمنت","طن",500,450,950]
[null,103,"2020-07-29","بفابلابل",1643,503,null,"إيداع",0,"محمود","رقم7","بناء",80.099999999999994,1306.6666666666699,104664.00000000025,"محمود","احضار مياه","جرار بمفطورة",5,100,500,"رقم2","محمود","جبس ","طن",22,500,522]
[null,104,"2020-07-30","بفابلابل",1520,null,123,"مورد","رضا","محمد","رقم8","صب",93.9,1506.6666666666699,141476.00000000032,"محمد","تسوية","بلدوزر كبير",8,200,1600,"رقم3","محمد","رمل","طن",520,550,1070]
[null,105,"2020-07-31","بفابلابل",2024,504,null,"إيداع",0,"رضا","رقم9","محارة",107.7,1706.6666666666699,183808.00000000035,"رضا","نقل رمل","لودر",7,300,2100,"رقم4","رضا","اسمنت","طن",360,600,960]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]
[null,null,null,null,2024]

{"sheet":"تقرير الخزينة","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,"رقم السند","المصروف","اسم المورد"]
[]
[]
[]
["رقم السند","التاريخ","البيان والشرح","الرصيد العهدة","إيداع نقدية","صرف نقدية","المصروف","اسم المورد"]
[100,"2020-01-01","بفابلابل",500,500,null,"إيداع",0]
["0102","2020-02-05","سداد",380,null,120,"مورد","رضا"]
[101,"2020-03-11","بفابلابل",881,501,null,"إيداع",0]
["0103","2020-04-15","سداد",760,null,121,"مورد","رضا"]
[102,"2020-05-20","بفابلابل",1262,502,null,"إيداع",0]
["0104","2020-06-24","سداد",1140,null,122,"مورد","رضا"]
[103,"2020-07-29","بفابلابل",1643,503,null,"إيداع",0]
[104,"2020-07-30","بفابلابل",1520,null,123,"مورد","رضا"]
[105,"2020-07-31","بفابلابل",2024,504,null,"إيداع",0]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]
[null,null,null,2024]

{"sheet":"تقرير الموردين الاعمال","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"اسم المورد","المكان","الاعمال"]
[]
[]
[]
[]
[]
[null,"اسم المورد","المكان","الاعمال","المقاس","الفئة","القيمة"]
[null,"رضا","رقم1","بناء",5,100,500]
[null,"إبراهيم","رقم2","صب",7,320,2240]
[null,"محمود","رقم3","محارة",10,500,5000]
[null,"محمد","رقم4","بناء",50,706.66666666666697,35333.33333333335]
[null,"رضا","رقم5","صب",52.5,906.66666666666697,47600.000000000015]
[null,"إبراهيم","رقم6","محارة",66.3,1106.6666666666699,73372.000000000218]
[null,"محمود","رقم7","بناء",80.099999999999994,1306.6666666666699,104664.00000000025]
[null,"محمد","رقم8","صب",93.9,1506.6666666666699,141476.00000000032]
[null,"رضا","رقم9","محارة",107.7,1706.6666666666699,183808.00000000035]

{"sheet":"تقرير موردين الالات","index":4,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"اسم المورد","الاعمال","اسم  المعدة"]
[null,"إبراهيم","نقل رمل","جرار صغير "]
[]
[]
[]
[]
[null,"اسم المورد","الاعمال","اسم  المعدة","عددساعات / النقلة","الفئة","القيمة","المكان"]
[null,"إبراهيم","نقل رمل","جرار صغير ",7,300,2100,"رقم1"]

{"sheet":"تقرير المشتريات والمواد خام","index":5,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["اسم المورد","الأصناف"]
[null,"زلط"]
[]
[]
[]
[]
["اسم المورد","الأصناف","الوحدة","الكمية","السعر","القيمة"]
["رضا","زلط","طن",20,250,270]

{"sheet":"تقرير موردين الصناعية","index":6,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,3,2,5],[4,6,4,11],[5,6,5,11],[3,6,3,13]]}
["رقم السند","التاريخ","البيان والشرح","صرف نقدية","اسم المورد","اسم المورد","المكان","الاعمال"]
[]
[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,{"$f":"0+D11-K11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L11+D12-K12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L12+D13-K13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"تقرير موردين الالات ","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"تقرير موردين الخامات ","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}