{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["كشف حساب العمال (2)","تسجيل المصاريف العام (3)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":23,"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":"كشف حساب العمال (2)","index":0,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["الأسبوع","الأسبوع","اسم العامل","التصنيف","المحاسب","اليوم","التاريخ","بيان","ملاحظات"]
[{"$f":"\">=\"&A3","v":">=44203"},{"$f":"\"<=\"&B3","v":"<=44203"}]
["2021-01-07","2021-01-07"]
["اجمالي الستحق",{"$f":"SUM(O7:O1048576)","v":155526}]
["اجمالي المصاريف",{"$f":"SUM(B7:B1048576)","v":132110}]
["الرصيد",{"$f":"B4-B5","v":23416},null,null,null,null,null,null,{"$f":"SUM(I7:I1048576)","v":4660},null,null,{"$f":"SUM(L7:M1048576)","v":9012.875}]
["الأسبوع","المصاريف","المحاسب","اليوم","التاريخ","بيان","ملاحظات","الأسبوع","الإنتاج","سعر الوحدة","الإجمالي","الشاي","إضافات","خصومات","المستحق","بيان","ملاحظات","التاريخ","اسم العميل","الواصل","المحاسب","اليوم","بيان"]
["2021-01-07",3000,"احمد خالد","الجمعة","2021-01-01","-","-","2021-01-07",623,24,14952,2500,50,0,17502,"-","-"]
["2021-01-07",null,"احمد خالد","الجمعة","2021-01-01","-","-","2021-01-07",229.5,30.75,7057.125,0,0.875,0,7058,"-","-"]
["2021-01-07",6000,"احمد خالد","الجمعة","2021-01-01","كمال محمد","-","2021-01-07",727,11,7997,1200,0,0,9197,"-","-"]
["2021-01-07",2000,"احمد خالد","الجمعة","2021-01-01","-","-","2021-01-07",102,14,1428,0,0,0,1428,"-","-"]
["2021-01-07",400,"احمد خالد","السبت","2021-01-02","-","-","2021-01-07",727,4.25,3089.75,300,1311,0.75,4700,"-","-"]
["2021-01-07",3000,"احمد خالد","السبت","2021-01-02","سعيد رمضان","-","2021-01-07",102,6,612,0,0,2,610,"-","-"]
["2021-01-07",10000,"احمد خالد","السبت","2021-01-02","يوسف خالد","-","2021-01-07",361,25,9025,1750,0,0,10775,"-","-"]
["2021-01-07",2000,"احمد خالد","السبت","2021-01-02","-","-","2021-01-07",123.5,30,3705,0,0,0,3705,"-","-"]
["2021-01-07",1500,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",265,25,6625,1550,100,0,8275,"-","-"]
["2021-01-07",2000,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",106,30,3180,0,0,0,3180,"-","-"]
["2021-01-07",1300,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",4,2300,9200,250,0,0,9450,"-","-"]
["2021-01-07",null,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",4,340,1360,0,0,0,1360,"-","-"]
["2021-01-07",200,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",4,340,1360,0,0,0,1360,"-","-"]
["2021-01-07",200,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",4,90,360,0,0,0,360,"-","-"]
["2021-01-07",2000,"عثمان خالد","السبت","2021-01-02","سعيد رمضان","-","2021-01-07",1,1800,1800,0,0,0,1800,"-","-"]
["2021-01-07",4000,"عثمان خالد","السبت","2021-01-02","سعيد رمضان","-","2021-01-07",1,2200,2200,0,0,0,2200,"-","-"]
["2021-01-07",300,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,1750,1750,0,0,0,1750,"-","-"]
["2021-01-07",300,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,500,500,0,0,0,500,"-","-"]
["2021-01-07",800,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,300,300,0,0,0,300,"-","-"]
["2021-01-07",100,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,1000,1000,0,0,0,1000,"-","-"]
["2021-01-07",600,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,135,135,0,0,0,135,"-","-"]
["2021-01-07",1000,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,4200,4200,0,0,0,4200,"-","-"]
["2021-01-07",600,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,900,900,0,0,0,900,"-","-"]
["2021-01-07",245,"عثمان خالد","السبت","2021-01-02","عصافير","-","2021-01-07",1,0,0,0,0,0,0,"-","-"]
["2021-01-07",500,"عثمان خالد","السبت","2021-01-02","-","-","2021-01-07",1,3325,3325,0,0,0,3325,"-","-"]
["2021-01-07",200,"احمد خالد","الأحد","2021-01-03","عربية","-","2021-01-07",6,116.5,699,1,0,100,600,"عثمان خالد","-"]
["2021-01-07",1700,"احمد خالد","الأحد","2021-01-03","-","-","2021-01-07",6,95,570,0,0,0,570,"-","-"]
["2021-01-07",500,"احمد خالد","الأحد","2021-01-03","-","-","2021-01-07",6,95,570,0,0,20,550,"-","-"]
["2021-01-07",null,"احمد خالد","الأحد","2021-01-03","-","-","2021-01-07",1,80,80,0,0,0,80,"-","-"]
["2021-01-07",2000,"عثمان خالد","الأحد","2021-01-03","-","-","2021-01-07",1248,47,58656,0,0,0,58656,"يوسف خالد","-"]
["2021-01-07",1500,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",1200,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",null,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",null,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",200,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",400,"عثمان خالد","الأحد","2021-01-03","-","-"]
["2021-01-07",2000,"احمد خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",1500,"احمد خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",1500,"احمد خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",300,"احمد خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",4000,"احمد خالد","الإثنين","2021-01-04","كمال محمد","-"]
["2021-01-07",1500,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",1300,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",1000,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",2000,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",4000,"عثمان خالد","الإثنين","2021-01-04","كمال محمد","-"]
["2021-01-07",100,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",400,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",400,"عثمان خالد","الإثنين","2021-01-04","-","-"]
["2021-01-07",120,"احمد خالد","الثلاثاء","2021-01-05","اجندات ورق","-"]
["2021-01-07",2000,"احمد خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",400,"احمد خالد","الثلاثاء","2021-01-05","اسطنبة","-"]
["2021-01-07",160,"احمد خالد","الثلاثاء","2021-01-05","2فرلادة شبك","-"]
["2021-01-07",1000,"احمد خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",1500,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",1200,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",1000,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",2000,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
["2021-01-07",2955,"احمد خالد","الأربعاء","2021-01-06","-","-"]
["2021-01-07",2000,"احمد خالد","الأربعاء","2021-01-06","لله","-"]
["2021-01-07",1500,"عثمان خالد","الأربعاء","2021-01-06","-","-"]
["2021-01-07",5480,"عثمان خالد","الأربعاء","2021-01-06","-","-"]
["2021-01-07",200,"احمد خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",600,"احمد خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",16560,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",6125,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",4000,"عثمان خالد","الخميس","2021-01-07","كمال محمد","-"]
["2021-01-07",760,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",660,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",1000,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",260,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",370,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",80,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",350,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",900,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",1200,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",300,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",750,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",135,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",600,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",600,"عثمان خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",300,"احمد خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",400,"احمد خالد","الخميس","2021-01-07","-","-"]
["2021-01-07",4000,"احمد خالد","الخميس","2021-01-07","كمال محمد","-"]
["2021-01-07",900,"احمد خالد","الخميس","2021-01-07","قسط","-"]

{"sheet":"تسجيل المصاريف العام (3)","index":1,"n_rows":142,"n_cols":15,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["عمود1","الشهر","الأسبوع","التصنيف","اسم العامل","المصاريف","المحاسب","اليوم","التاريخ","بيان","ملاحظات","فارغ","المستحق"]
[null,null,"حاج تامر في الحساب",{"$f":"IF(OR(E7=\"حمراء صباحية\",E7=\"حمراء مسائية\",E7=\"محمد يحيي\"),\"الحمراء والخضراء\",IF(OR(E7=\"طفلة ورملة\"),\"طفلة ورملة\",IF(OR(E7=\"هاني كشف\",E7=\"عيد بدر\",E7=\"حريق\",E7=\"محمد سالم\",E7=\"حسنين نظافة\",E7=\"خليل الغفير\",E7=\"رجب كوتش\",E7=\"نصر صالح\",E7=\"الادارة\",E7=\"عثمان خالد\"),\"مصاريف اسبوعية\",IF(OR(E7=\"بجوار 1\",E7=\"بجوار 2\",E7=\"احمد رمضان\",E7=\"سعيد خلي\",E7=\"لودار\"),\"خط وخلي\",IF(E7=\"مازيوت\",\"مازيوت\",IF(OR(E7=\"مصاريف عمومية\",E7=\"حنفي الكنتيل\",E7=\"نظافة سيور\",E7=\"يوميات\",E7=\"سير البوكس\"),\"مصاريف متغيرة\",IF(OR(E7=\"فيصل الخراط\",),\"اكسسسوار\",)))))))","v":0},"حاج تامر في الحساب",1700,350,"في الحساب",1350,"تصحيح مع الزاما","2019-12-12"]
[null,null,"حاج تامر نقدا",0,"حاج تامر نقدا",null,"-","-","-","-","-"]
[null,null,"حاج تامر مرحل",0,"حاج تامر مرحل",82715,"-","-","-","-","-"]
[null,null,"حاج تامر مؤجل",0,"حاج تامر مؤجل",3000,"-","-","-","-","-"]
[null,null,"إيرادات لم تحصل بعد",0,"إيرادات لم تحصل بعد",197530,"-","-","-","-","-"]
[null,null,"احمد خالد نقدا",0,"احمد خالد نقدا",160000,"-","-","-","-","-"]
[null,null,"احمد خالد مسحوبات",0,"احمد خالد مسحوبات",400,"-","-","-","-","-"]
[null,null,"عثمان خالد",0,"عثمان خالد00",44150,"-","-","-","-","-"]
[null,null,"يوسف خالد",0,"يوسف خالد",null,"-","-","-","-","-"]
[null,null,"مصاريف جديدة",0,"مصاريف جديدة",47140,"-","-","-","-","-"]
[null,null,"خزنتة المصنع",0,"خزنتة المصنع",20150,"-","-","-","-","-"]
[null,null,"ارضيات",0,"ارضيات",1000,"-","-","-","-","-"]
[null,null,"رصيد الكارت",0,"رصيد الكارت",3000,"-","-","-","-","-"]
[null,null,"نصر صالح0",0,"0نصر صالح",4585,"-","-","-","-","-"]
[null,null,"محمود جمعة",0,"ياسر خالد",23615,"-","-","-","-","-"]
[null,null,"حمدان مزراعة",0,"أملاك",null,"-","-","-","-","-"]
[null,null,"حاج مجدي كمال",0,"محسن عامر",2000,"-","-","-","-","-"]
[null,null,"طحونة",0,"طحونة",null,"-","-","-","-","-"]
[null,null,"2021-01-07",{"$f":"IF(OR(E25=\"حمراء صباحية\",E25=\"حمراء مسائية\",E25=\"محمد يحيي\",E25=\"حمراء انقاذ\"),\"الحمراء والخضراء\",IF(OR(E25=\"طفلة ورملة\"),\"طفلة ورملة\",IF(OR(E25=\"هاني كشف\",E25=\"عيد بدر\",E25=\"حريق\",E25=\"محمد سالم\",E25=\"صبري نظافة\",E25=\"خليل الغفير\",E25=\"رجب كوتش\",E25=\"نصر صالح\",E25=\"الادارة\",E25=\"عثمان خالد\"),\"مصاريف اسبوعية\",IF(OR(E25=\"بجوار 1\",E25=\"بجوار 2\",E25=\"بجوار 3\",E25=\"احمد رمضان\",E25=\"سعيد خلي\",E25=\"لودار\"),\"خط وخلي\",IF(E25=\"مازيوت\",\"مازيوت\",IF(OR(E25=\"مصاريف عمومية\",E25=\"حنفي الكنتيل\",E25=\"نظافة سيور\",E25=\"يوميات\",E25=\"سير البوكس\",E25=\"عبده محاره\"),\"مصاريف متغيرة\",IF(OR(E25=\"فيصل الخراط\",E25=\"ابوسلام اكسسوار\",E25=\"ابوعزوز اكسسوار\",E25=\"محمود اكسسوار\",E25=\"وحيد الجرونسي\",E25=\"رضا مواتير\"),\"اكسسسوار\",IF(OR(E25=\"كهربائي\",E25=\"فاتورة كهرباء\",E25=\"الايجار الشهري\",E25=\"تامنينات\",E25=\"ضريبة مبيعات\",E25=\"ضريبة عامة\"),\"مصاريف شهرية\",))))))))","v":"الحمراء والخضراء"},"حمراء صباحية",3000,"احمد خالد","الجمعة","2021-01-01","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","حريق",null,"احمد خالد","الجمعة","2021-01-01","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",6000,"احمد خالد","الجمعة","2021-01-01","كمال محمد","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",2000,"احمد خالد","الجمعة","2021-01-01","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","صبري نظافة",400,"احمد خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",3000,"احمد خالد","السبت","2021-01-02","سعيد رمضان","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",10000,"احمد خالد","السبت","2021-01-02","يوسف خالد","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",2000,"احمد خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","محمد يحيي",1500,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء صباحية",2000,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","خط وخلي","احمد رمضان",1300,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","خط وخلي","سعيد خلي",null,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","يوميات",200,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","يوميات",200,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","خط وخلي","لودار",2000,"عثمان خالد","السبت","2021-01-02","سعيد رمضان","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",4000,"عثمان خالد","السبت","2021-01-02","سعيد رمضان","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 1",300,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 2",300,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","محمد سالم",800,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","نظافة سيور",100,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","عيد بدر",600,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","حريق",1000,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","هاني كشف",600,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",245,"عثمان خالد","السبت","2021-01-02","عصافير","-"]
[null,null,"2021-01-07","اكسسسوار","وحيد الجرونسي",500,"عثمان خالد","السبت","2021-01-02","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",200,"احمد خالد","الأحد","2021-01-03","عربية","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",1700,"احمد خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","خليل الغفير",500,"احمد خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07",0,null,null,"احمد خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","محمد يحيي",2000,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء صباحية",1500,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","خط وخلي","احمد رمضان",1200,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","خط وخلي","سعيد خلي",null,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","خط وخلي","لودار",null,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 1",200,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","عيد بدر",400,"عثمان خالد","الأحد","2021-01-03","-","-"]
[null,null,"2021-01-07","اكسسسوار","محمود اكسسوار",2000,"احمد خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","اكسسسوار","فيصل الخراط",1500,"احمد خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",1500,"احمد خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","حريق",300,"احمد خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",4000,"احمد خالد","الإثنين","2021-01-04","كمال محمد","-"]
[null,null,"2021-01-07","الحمراء والخضراء","محمد يحيي",1500,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء صباحية",1300,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","خط وخلي","احمد رمضان",1000,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","خط وخلي","لودار",2000,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",4000,"عثمان خالد","الإثنين","2021-01-04","كمال محمد","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 1",100,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 2",400,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","هاني كشف",400,"عثمان خالد","الإثنين","2021-01-04","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",120,"احمد خالد","الثلاثاء","2021-01-05","اجندات ورق","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","حريق",2000,"احمد خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",400,"احمد خالد","الثلاثاء","2021-01-05","اسطنبة","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",160,"احمد خالد","الثلاثاء","2021-01-05","2فرلادة شبك","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",1000,"احمد خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","محمد يحيي",1500,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء صباحية",1200,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","خط وخلي","احمد رمضان",1000,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","خط وخلي","لودار",2000,"عثمان خالد","الثلاثاء","2021-01-05","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",2955,"احمد خالد","الأربعاء","2021-01-06","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",2000,"احمد خالد","الأربعاء","2021-01-06","لله","-"]
[null,null,"2021-01-07","الحمراء والخضراء","محمد يحيي",1500,"عثمان خالد","الأربعاء","2021-01-06","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء صباحية",5480,"عثمان خالد","الأربعاء","2021-01-06","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","مصاريف عمومية",200,"احمد خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","صبري نظافة",600,"احمد خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07",{"$f":"IF(OR(E89=\"حمراء صباحية\",E89=\"حمراء مسائية\",E89=\"محمد يحيي\",E89=\"حمراء انقاذ\"),\"الحمراء والخضراء\",IF(OR(E89=\"طفلة ورملة\"),\"طفلة ورملة\",IF(OR(E89=\"هاني كشف\",E89=\"عيد بدر\",E89=\"حريق\",E89=\"محمد سالم\",E89=\"صبري نظافة\",E89=\"خليل الغفير\",E89=\"رجب كوتش\",E89=\"نصر صالح\",E89=\"الادارة\",E89=\"عثمان خالد\"),\"مصاريف اسبوعية\",IF(OR(E89=\"بجوار 1\",E89=\"بجوار 2\",E89=\"بجوار 3\",E89=\"احمد رمضان\",E89=\"سعيد خلي\",E89=\"لودار\"),\"خط وخلي\",IF(E89=\"مازيوت\",\"مازيوت\",IF(OR(E89=\"مصاريف عمومية\",E89=\"حنفي الكنتيل\",E89=\"نظافة سيور\",E89=\"يوميات\",E89=\"سير البوكس\",E89=\"عبده محاره\"),\"مصاريف متغيرة\",IF(OR(E89=\"فيصل الخراط\",E89=\"ابوسلام اكسسوار\",E89=\"ابوعزوز اكسسوار\",E89=\"محمود اكسسوار\",E89=\"وحيد الجرونسي\",E89=\"رضا مواتير\"),\"اكسسسوار\",IF(OR(E89=\"كهربائي\",E89=\"فاتورة كهرباء\",E89=\"الايجار الشهري\",E89=\"تامنينات\",E89=\"ضريبة مبيعات\",E89=\"ضريبة عامة\"),\"مصاريف شهرية\",))))))))","v":"الحمراء والخضراء"},"محمد يحيي",16560,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","خط وخلي","احمد رمضان",6125,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",4000,"عثمان خالد","الخميس","2021-01-07","كمال محمد","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 1",760,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","خط وخلي","بجوار 2",660,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","محمد سالم",1000,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","نظافة سيور",260,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","يوميات",370,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","يوميات",80,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","يوميات",350,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","حريق",900,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","عيد بدر",1200,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","رجب كوتش",300,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","هاني كشف",750,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف متغيرة","حنفي الكنتيل",135,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","عثمان خالد",600,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","خط وخلي","سعيد خلي",600,"عثمان خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","الحمراء والخضراء","حمراء مسائية",300,"احمد خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","خط وخلي","سعيد خلي",400,"احمد خالد","الخميس","2021-01-07","-","-"]
[null,null,"2021-01-07","طفلة ورملة","طفلة ورملة",4000,"احمد خالد","الخميس","2021-01-07","كمال محمد","-"]
[null,null,"2021-01-07","مصاريف اسبوعية","نصر صالح",900,"احمد خالد","الخميس","2021-01-07","قسط","-"]
[]
[]
[null,"الشهر","الأسبوع","التصنيف","اسم العامل",null,"الإنتاج","سعر الوحدة","الإجمالي","الشاي","إضافات","خصومات","المستحق","بيان","ملاحظات"]
[null,"سبتمبر","2021-01-07",{"$f":"IF(OR(E113=\"حمراء صباحية\",E113=\"حمراء مسائية\",E113=\"محمد يحيي\",E113=\"حمراء انقاذ\"),\"الحمراء والخضراء\",IF(OR(E113=\"طفلة ورملة\"),\"طفلة ورملة\",IF(OR(E113=\"هاني كشف\",E113=\"عيد بدر\",E113=\"حريق\",E113=\"محمد سالم\",E113=\"صبري نظافة\",E113=\"خليل الغفير\",E113=\"رجب كوتش\",E113=\"نصر صالح\",E113=\"الادارة\",E113=\"عثمان خالد\"),\"مصاريف اسبوعية\",IF(OR(E113=\"بجوار 1\",E113=\"بجوار 2\",E113=\"بجوار 3\",E113=\"احمد رمضان\",E113=\"سعيد خلي\",E113=\"لودار\"),\"خط وخلي\",IF(E113=\"مازيوت\",\"مازيوت\",IF(OR(E113=\"مصاريف عمومية\",E113=\"حنفي الكنتيل\",E113=\"نظافة سيور\",E113=\"يوميات\",E113=\"سير البوكس\",E113=\"عبده محاره\"),\"مصاريف متغيرة\",IF(OR(E113=\"فيصل الخراط\",E113=\"ابوسلام اكسسوار\",E113=\"ابوعزوز اكسسوار\",E113=\"محمود اكسسوار\",E113=\"وحيد الجرونسي\",E113=\"رضا مواتير\"),\"اكسسسوار\",IF(OR(E113=\"كهربائي\",E113=\"فاتورة كهرباء\",E113=\"الايجار الشهري\",E113=\"تامنينات\",E113=\"ضريبة مبيعات\",E113=\"ضريبة عامة\"),\"مصاريف شهرية\",))))))))","v":"الحمراء والخضراء"},"محمد يحيي",null,623,24,{"$f":"H113*G113","v":14952},2500,50,0,{"$f":"(I113+J113+K113)-L113","v":17502},"-","-"]
[null,"سبتمبر","2021-01-07","الحمراء والخضراء","محمد يحيي",null,229.5,30.75,7057.125,0,0.875,0,7058,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","احمد رمضان",null,727,11,7997,1200,0,0,9197,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","احمد رمضان",null,102,14,1428,0,0,0,1428,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","سعيد خلي",null,727,4.25,3089.75,300,1311,0.75,4700,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","سعيد خلي",null,102,6,612,0,0,2,610,"-","-"]
[null,"سبتمبر","2021-01-07","الحمراء والخضراء","حمراء صباحية",null,361,25,9025,1750,0,0,10775,"-","-"]
[null,"سبتمبر","2021-01-07","الحمراء والخضراء","حمراء صباحية",null,123.5,30,3705,0,0,0,3705,"-","-"]
[null,"سبتمبر","2021-01-07","الحمراء والخضراء","حمراء مسائية",null,265,25,6625,1550,100,0,8275,"-","-"]
[null,"سبتمبر","2021-01-07","الحمراء والخضراء","حمراء مسائية",null,106,30,3180,0,0,0,3180,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","لودار",null,4,2300,{"$f":"H123*G123","v":9200},250,0,0,9450,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","بجوار 2",null,4,340,{"$f":"H124*G124","v":1360},0,0,0,1360,"-","-"]
[null,"سبتمبر","2021-01-07","خط وخلي","بجوار 1",null,4,340,{"$f":"H125*G125","v":1360},0,0,0,1360,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","نظافة سيور",null,4,90,360,0,0,0,360,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","محمد سالم",null,1,1800,1800,0,0,0,1800,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","عيد بدر",null,1,2200,2200,0,0,0,2200,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","هاني كشف",null,1,1750,1750,0,0,0,1750,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","خليل الغفير",null,1,500,500,0,0,0,500,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","رجب كوتش",null,1,300,300,0,0,0,300,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","صبري نظافة",null,1,1000,1000,0,0,0,1000,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","حنفي الكنتيل",null,1,135,135,0,0,0,135,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","حريق",null,1,4200,4200,0,0,0,4200,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","نصر صالح",null,1,900,900,0,0,0,900,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","الادارة",null,1,0,0,0,0,0,0,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","مصاريف عمومية",null,1,3325,3325,0,0,0,3325,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف اسبوعية","عثمان خالد",null,6,116.5,699,1,0,100,600,"عثمان خالد","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","يوميات",null,6,95,570,0,0,0,570,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","يوميات",null,6,95,570,0,0,20,550,"-","-"]
[null,"سبتمبر","2021-01-07","مصاريف متغيرة","يوميات",null,1,80,80,0,0,0,80,"-","-"]
[null,"مارس","2021-01-07","طفلة ورملة","طفلة ورملة",null,1248,47,58656,0,0,0,58656,"يوسف خالد","-"]