{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":[" DBase","Salary Sheets","Rules"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":" DBase","index":0,"n_rows":16,"n_cols":95,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,2,{"$f":"C1+1","v":3},11,{"$f":"E1+1","v":12},{"$f":"F1+1","v":13},{"$f":"G1+1","v":14},{"$f":"H1+1","v":15},{"$f":"I1+1","v":16},{"$f":"J1+1","v":17},{"$f":"K1+1","v":18},{"$f":"L1+1","v":19},{"$f":"M1+1","v":20},{"$f":"N1+1","v":21},{"$f":"O1+1","v":22},{"$f":"P1+1","v":23},{"$f":"Q1+1","v":24},{"$f":"R1+1","v":25},{"$f":"S1+1","v":26},{"$f":"T1+1","v":27},{"$f":"U1+1","v":28},{"$f":"V1+1","v":29},{"$f":"W1+1","v":30},{"$f":"X1+1","v":31},{"$f":"Y1+1","v":32},{"$f":"Z1+1","v":33},{"$f":"AA1+1","v":34},{"$f":"AB1+1","v":35},{"$f":"AC1+1","v":36},{"$f":"AD1+1","v":37},{"$f":"AE1+1","v":38},{"$f":"AF1+1","v":39},{"$f":"AG1+1","v":40},{"$f":"AH1+1","v":41},{"$f":"AI1+1","v":42},{"$f":"AJ1+1","v":43},{"$f":"AK1+1","v":44},{"$f":"AL1+1","v":45},{"$f":"AM1+1","v":46},47,{"$f":"AO1+1","v":48},{"$f":"AP1+1","v":49},{"$f":"AQ1+1","v":50},{"$f":"AR1+1","v":51},{"$f":"AS1+1","v":52},{"$f":"AT1+1","v":53},{"$f":"AU1+1","v":54},{"$f":"AV1+1","v":55},{"$f":"AW1+1","v":56},{"$f":"AX1+1","v":57},{"$f":"AY1+1","v":58},{"$f":"AZ1+1","v":59},{"$f":"BA1+1","v":60},{"$f":"BB1+1","v":61},{"$f":"BC1+1","v":62},{"$f":"BD1+1","v":63},{"$f":"BE1+1","v":64},{"$f":"BF1+1","v":65},{"$f":"BG1+1","v":66},{"$f":"BH1+1","v":67},{"$f":"BI1+1","v":68},{"$f":"BJ1+1","v":69},{"$f":"BK1+1","v":70},{"$f":"BL1+1","v":71},{"$f":"BM1+1","v":72},{"$f":"BN1+1","v":73},{"$f":"BO1+1","v":74},{"$f":"BP1+1","v":75},{"$f":"BQ1+1","v":76},{"$f":"BR1+1","v":77},{"$f":"BS1+1","v":78},{"$f":"BT1+1","v":79},{"$f":"BU1+1","v":80},{"$f":"BV1+1","v":81},{"$f":"BW1+1","v":82},{"$f":"BX1+1","v":83},{"$f":"BY1+1","v":84},{"$f":"BZ1+1","v":85},{"$f":"CA1+1","v":86},{"$f":"CB1+1","v":87},{"$f":"CC1+1","v":88},{"$f":"CD1+1","v":89},{"$f":"CE1+1","v":90},{"$f":"CF1+1","v":91},{"$f":"CG1+1","v":92},{"$f":"CH1+1","v":93},{"$f":"CI1+1","v":94},{"$f":"CJ1+1","v":95},{"$f":"CK1+1","v":96},{"$f":"CL1+1","v":97},{"$f":"CM1+1","v":98},{"$f":"CN1+1","v":99}]
[null,null,null,null,"استحقاقات",null,null,null,null,null,null,null,null,null,"نسبة الحافز x (مرتب اساسى + علاوات مضمومة)",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,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,"الرقم الثابت ","رقم الحساب","الاسم","مرتب اساسي","بدل خطر","بدل ندرة","بدل انتقال","مصاريف انتقال","غلاء معيشة إضافى","غلاء معيشه اصلى","مصاريف اعاشة","نوبتجيات","جهود غير عادية","حوافز","منحة عيد عمال","منحة 2019 من الدولة","منحة 2020 من الدولة","علاوات مضمومه","علاوات غير مضمومه","علاوة استثنائية 2018","بـدل  وجبة","قيمة اضافى","بدل تفرغ","بدل تمثيل","بدل كمبيوتر","بدل سفر","بدل طبيعة عمل","بدل صرافة","بـدل  وجبة  - دفعات","قيمة اضافى  - دفعات","بدل اجر مقابل","فروق بدلات","فروق بدل انتقال","فروق حوافز","بدل سماعة","مبالغ خصمت بالزيادة","بدل مرور","جهود غير عادية غير منسبة","بدل إقامة اضافي","منحة 2021 من الدولة","جملة الاستحقاقات","الصافى","صندوق زمالة","نقابه عمال بناء","كسب عمل","خصم ساعات انصراف","فاتوره فودافون","المساهمة التـكـافـليـة","قانون 4 لعام 2021","مبالغ صرفت بالزياده","قسط شقق عاملين","تبرع مستشفى 57357","اثاث","بريميوم كارد","اشتراك اتوبيس","فاتوره اتصالات","مده سابقه","سلفه عمره وحج","ناوباى - NowPay","١ - سلفه صندوق","البنك اهلى المصرى","نفقات","تبرع مستشفى ابو الريش","فاتوره أورانج","تسويه ضرائب مدينه","قسط تامين جماعى","دفعات","مساهمة العاملين فى العلاج","جزاءات مقسطة","نقابات مهنيه تجاريين","اقساط رحلات ١","فرق البنك اهلى المصرى","بنك ناصر اجتماعى","تبرع مستشفى اورام","تبرع مؤسسة مصر الخير","فرق استقطاعات اخري","تبرع مؤسسة مجدى يعقوب","متجمد النفقه الشرعيه","فرق مده سابقه","تبرع المعهد القومى للكلى","فرق نفقات","سلفه علاج","فرق اثاث","صندوق تامين العاملين اقساط","مبالغ سددتها الشركة عن العامل","شيخوخة وعجز حصة عامل","نظام مكافأة حصة عامل","تامين مرض حصة عامل   (صحى )","إجمالى تأمينات العامل","إجمالى تأمينات الشركة","إجمالى استقطاعات وتأمينات","الحالة الاجتماعية",null,"نسبة الحافز"]
[1,1,null,"Name _1",841.3,226.81,350,60,600,6,4,500,350,{"$f":"IF(Y4=0,45%*(E4+S4),IF(Y4=100,60%*(E4+S4),IF(Y4=150,65%*(E4+S4),IF(Y4=200,70%*(E4+S4),\"خطأ\"))))","v":625.82850000000008},{"$f":"CQ4*(E4+S4)","v":2781.46},10,31.83,56.76,549.42999999999995,177.4,190,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,77.984999999999999,{"$f":"SUM(E4:AO4)","v":7438.8034999999991},5680.3,8,3,192.41,0,451.74,61.97,3.07,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,528.91999999999996,58.77,58.77,646.46,955,2321.65,"متزوج ويعول اثنين",null,2]
[2,2,null,"Name _2",1474.43,0,0,80,0,6,4,0,0,1034.1630000000002,4596.2800000000007,10,56.28,100.36,823.71,319.8,190,120,322.17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,128.8674,{"$f":"SUM(E5:AO5)","v":9266.0604000000003},6580.4,8,3,572.51,0,55.06,71.44,3.54,433.57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,729,81,81,891,1316.25,3354.37,"متزوج ويعول اثنين",null,2]
[3,4,null,"Name _3",1615.77,302.86,0,80,0,6,4,0,0,1114.7670000000001,4954.5200000000004,10,60.67,108.19,861.49,320.75,190,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,138.91199999999998,9767.9290000000001,6932.7,8,3,655.23,0,91.52,75.13,3.72,0,399.63,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,729,81,81,891,1316.25,3453.48,"متزوج ويعول اثنين",null,2]
[4,5,null,"Name _4",1280.96,113.4,0,0,300,6,4,0,0,886.62149999999997,3940.54,10,45.09,86.05,689.31,270.5,190,760,1841.37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,110.48219999999999,10534.323699999999,6916.6,0,3,811.52,0,412.75,82.74,4.0999999999999996,0,0,0,318.45,32.28,4,502.71,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,729,81,81,891,1316.25,4378.8,"متزوج ويعول اثنين",null,2]
[5,7,null,"Name _5",450.17,134.31,0,40,0,0,4,0,0,376.71750000000003,1674.3000000000002,10,30.29,34.17,386.98,131.44,200,220,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,46.942799999999998,3739.3203000000003,3055.3,0,3,18.920000000000002,0,37.76,31.26,1.55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,291.01,32.33,32.33,355.67,525.41999999999996,973.58,"اعزب",null,2]
[6,12,null,"Name _6",1644.71,0,0,125,0,6,4,0,0,1567.0260000000001,5223.42,10,63.96,114.06,967,341.96,180,0,0,396.57,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,146.45099999999999,10890.156999999996,4964.1000000000004,0,3,825.09,0,134.61000000000001,84.1,4.16,0,0,0,83.25,0,4,43.92,3.9,3087.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,729,81,81,891,1316.25,6480.78,"متزوج ويعول اثنين",null,2]
[7,13,null,"Name _7",530.30999999999995,226.81,600,80,0,6,4,0,560,460.82249999999999,2048.1,10,25.08,44.72,493.74,152.53,190,200,57.42,226.81,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57.423599999999993,6048.7660999999998,3901.5,0,3,179.47,0,103.36,49.76,2.46,0,0,100,109.27,0,0,0,0,0,709.69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,492.32,54.7,54.7,601.72,888.91,2747.64,"متزوج ويعول اثنين",null,2]
[8,14,null,"Name _8",378.54,0,0,40,0,4,4,0,0,390.83850000000001,1737.06,10,25.37,37.93,489.99,141.99,190,0,0,161.4,0,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,48.702600000000004,3689.8211000000001,3018.25,8,3,13.67,0,0,30.5,1.51,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,302.86,33.65,33.65,370.16,546.82000000000005,973.66,"متزوج ويعول واحد",null,2]
[9,15,null,"Name _9",224.61,0,0,60,0,6,4,0,100,283.45049999999998,1259.78,10,39.01,36.49,405.28,126.64,200,120,57.4,0,0,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35.320799999999998,3007.9812999999999,2456,0,3,3.12,0,51.3,25.34,1.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,237.64,26.4,26.4,290.44,429.07,803.52,"متزوج ويعول اثنين",null,2]
[10,17,null,"Name _10",797.46,0,0,60,0,6,4,0,0,599.63400000000001,2665.04,10,32.630000000000003,58.19,535.05999999999995,178.73,190,0,0,0,0,50,0,40,0,0,0,0,0,0,0,0,0,0,0,0,74.720999999999989,5301.4649999999983,2244.5,0,3,90.93,0,0,42.98,2.13,0,0,0,0,0,0,0,0,0,0,208.33,1800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,437.04,48.56,48.56,534.16,789.1,3470.63,"متزوج ويعول اثنين",null,2]
[11,18,null,"Name _11",924.11,0,0,60,240,6,4,0,0,703.00350000000003,3124.46,10,38.26,68.23,638.12,200.56,190,20,21.9,0,0,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,87.601799999999997,6386.2453000000005,4115.8,0,3,148.62,0,37.76,51.77,2.56,0,0,0,0,0,4,0,16.45,0,0,208.33,0,740,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,505.44,56.16,56.16,617.76,912.61,2742.86,"متزوج ويعول اثنين",null,2]
[12,19,null,"Name _12",796.57,0,0,0,0,6,4,0,0,638.76150000000007,2838.94,10,34.76,61.99,622.9,185.17,190,0,0,226.81,0,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,79.596600000000009,5745.4981000000007,4421.6000000000004,0,3,118.82,0,0,46.37,2.2999999999999998,0,0,0,166.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,480.2,53.36,53.36,586.91999999999996,867.03,1790.94,"متزوج ويعول اثنين",null,2]
[13,20,null,"Name _13",644.21,67.150000000000006,0,0,300,6,4,0,0,513.59400000000005,2282.6400000000003,10,26.12,49.84,497.11,161.13,200,760,1066.6500000000001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,63.999000000000002,6652.4430000000011,4244.5,0,3,221.95,0,409.48,55.27,2.74,0,0,0,0,0,4,489.18,7,0,0,0,285,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,473.47,52.61,52.61,578.69000000000005,854.89,2941.2,"متزوج ويعول اثنين",null,2]

{"sheet":"Salary Sheets","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,5,7,9],[7,2,7,3],[1,7,1,8],[51,5,51,8],[57,5,57,8],[13,5,13,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[20,5,20,8],[14,5,14,8],[54,5,54,8],[53,5,53,8],[15,5,15,8],[55,5,55,8],[56,5,56,8],[16,5,16,8],[17,5,17,8],[18,5,18,8],[19,5,19,8],[32,5,32,8],[21,5,21,8],[22,5,22,8],[23,5,23,8],[24,5,24,8],[25,5,25,8],[26,5,26,8],[27,5,27,8],[28,5,28,8],[29,5,29,8],[30,5,30,8],[31,5,31,8],[44,5,44,8],[33,5,33,8],[34,5,34,8],[35,5,35,8],[36,5,36,8],[37,5,37,8],[38,5,38,8],[39,5,39,8],[40,5,40,8],[41,5,41,8],[42,5,42,8],[43,5,43,8],[52,5,52,8],[45,5,45,8],[46,5,46,8],[47,5,47,8],[48,5,48,8],[49,5,49,8],[50,5,50,8]]}
[null,"القاهرة في :",{"$f":"TODAY()","v":"2021-07-14"}]
[null,null,null,"مفردات الدخل الشهرى عن شهر",null,null,null,{"$f":"TODAY()","v":"2021-07-14"}]
[]
[null,"للسيد/ ",{"$f":"VLOOKUP($K$4,' DBase'!$B:$CO,3,0)","v":"Name _1"},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,"الاستقطاعات"]
[11,null,"مرتب اساسي",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A9,0)","v":500},null,"صندوق زمالة",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O9,0)","v":0},null,null,null,null,50]
[{"$f":"A9+1","v":12},null,"بدل خطر",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A10,0)","v":350},null,"نقابه عمال بناء",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O10,0)","v":0},null,null,null,null,{"$f":"O9+1","v":51}]
[13,null,"بدل ندرة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A11,0)","v":625.82850000000008},null,"كسب عمل",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O11,0)","v":0},null,null,null,null,{"$f":"O10+1","v":52}]
[14,null,"بدل انتقال",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A12,0)","v":2781.46},null,"خصم ساعات انصراف",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O12,0)","v":0},null,null,null,null,53]
[15,null,"مصاريف انتقال",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A13,0)","v":10},null,"فاتوره فودافون",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O13,0)","v":0},null,null,null,null,54]
[16,null,"غلاء معيشة إضافى",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A14,0)","v":31.83},null,"المساهمة التـكـافـليـة",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O14,0)","v":0},null,null,null,null,55]
[17,null,"غلاء معيشه اصلى",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A15,0)","v":56.76},null,"قانون 4 لعام 2021",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O15,0)","v":0},null,null,null,null,56]
[18,null,"مصاريف اعاشة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A16,0)","v":549.42999999999995},null,"مبالغ صرفت بالزياده",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O16,0)","v":0},null,null,null,null,57]
[19,null,"نوبتجيات",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A17,0)","v":177.4},null,"قسط شقق عاملين",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O17,0)","v":0},null,null,null,null,58]
[20,null,"جهود غير عادية",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A18,0)","v":190},null,"تبرع مستشفى 57357",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O18,0)","v":0},null,null,null,null,59]
[21,null,"حوافز",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A19,0)","v":0},null,"اثاث",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O19,0)","v":0},null,null,null,null,60]
[22,null,"منحة عيد عمال",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A20,0)","v":0},null,"بريميوم كارد",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O20,0)","v":0},null,null,null,null,61]
[23,null,"منحة 2019 من الدولة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A21,0)","v":0},null,"اشتراك اتوبيس",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O21,0)","v":0},null,null,null,null,62]
[24,null,"منحة 2020 من الدولة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A22,0)","v":0},null,"فاتوره اتصالات",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O22,0)","v":0},null,null,null,null,63]
[25,null,"علاوات مضمومه",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A23,0)","v":0},null,"مده سابقه",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O23,0)","v":0},null,null,null,null,64]
[26,null,"علاوات غير مضمومه",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A24,0)","v":0},null,"سلفه عمره وحج",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O24,0)","v":0},null,null,null,null,65]
[27,null,"علاوة استثنائية 2018",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A25,0)","v":0},null,"ناوباى - NowPay",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O25,0)","v":0},null,null,null,null,66]
[28,null,"بـدل  وجبة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A26,0)","v":0},null,"١ - سلفه صندوق",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O26,0)","v":0},null,null,null,null,67]
[29,null,"قيمة اضافى",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A27,0)","v":0},null,"البنك اهلى المصرى",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O27,0)","v":0},null,null,null,null,68]
[30,null,"بدل تفرغ",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A28,0)","v":0},null,"نفقات",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O28,0)","v":0},null,null,null,null,69]
[31,null,"بدل تمثيل",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A29,0)","v":0},null,"تبرع مستشفى ابو الريش",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O29,0)","v":0},null,null,null,null,70]
[32,null,"بدل كمبيوتر",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A30,0)","v":0},null,"فاتوره أورانج",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O30,0)","v":0},null,null,null,null,71]
[33,null,"بدل سفر",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A31,0)","v":0},null,"تسويه ضرائب مدينه",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O31,0)","v":0},null,null,null,null,72]
[34,null,"بدل طبيعة عمل",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A32,0)","v":0},null,"قسط تامين جماعى",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O32,0)","v":0},null,null,null,null,73]
[35,null,"بدل صرافة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A33,0)","v":0},null,"دفعات",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O33,0)","v":0},null,null,null,null,74]
[36,null,"بـدل  وجبة  - دفعات",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A34,0)","v":0},null,"مساهمة العاملين فى العلاج",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O34,0)","v":0},null,null,null,null,75]
[37,null,"قيمة اضافى  - دفعات",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A35,0)","v":0},null,"جزاءات مقسطة",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O35,0)","v":0},null,null,null,null,76]
[38,null,"بدل اجر مقابل",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A36,0)","v":0},null,"نقابات مهنيه تجاريين",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O36,0)","v":0},null,null,null,null,77]
[39,null,"فروق بدلات",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A37,0)","v":0},null,"اقساط رحلات ١",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O37,0)","v":0},null,null,null,null,78]
[40,null,"فروق بدل انتقال",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A38,0)","v":77.984999999999999},null,"فرق البنك اهلى المصرى",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O38,0)","v":0},null,null,null,null,79]
[41,null,"فروق حوافز",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A39,0)","v":7438.8034999999991},null,"بنك ناصر اجتماعى",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O39,0)","v":0},null,null,null,null,80]
[42,null,"بدل سماعة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A40,0)","v":5680.3},null,"تبرع مستشفى اورام",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O40,0)","v":0},null,null,null,null,81]
[43,null,"مبالغ خصمت بالزيادة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A41,0)","v":8},null,"تبرع مؤسسة مصر الخير",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O41,0)","v":0},null,null,null,null,82]
[44,null,"بدل مرور",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A42,0)","v":3},null,"فرق استقطاعات اخري",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O42,0)","v":0},null,null,null,null,83]
[45,null,"جهود غير عادية غير منسبة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A43,0)","v":192.41},null,"تبرع مؤسسة مجدى يعقوب",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O43,0)","v":0},null,null,null,null,84]
[46,null,"بدل إقامة اضافي",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A44,0)","v":0},null,"متجمد النفقه الشرعيه",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O44,0)","v":0},null,null,null,null,85]
[47,null,"منحة 2021 من الدولة",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CO,'Salary Sheets'!A45,0)","v":451.74},null,"فرق مده سابقه",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O45,0)","v":528.91999999999996},null,null,null,null,86]
[48,null,"اجمالى الاستحقاقات",{"$f":"VLOOKUP(K$4,' DBase'!$B:$CH,'Salary Sheets'!A46,0)","v":61.97},null,"تبرع المعهد القومى للكلى",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O46,0)","v":58.77},null,null,null,null,87]
[null,null,"حصة تأمينات الشركة",{"$f":"J57","v":{"$error":"#REF!"}},null,"فرق نفقات",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O47,0)","v":58.77},null,null,null,null,88]
[null,null,"الاجمالى الاستحقاقات وحصة تأمينات الشركة",{"$f":"D47+D46","v":{"$error":"#REF!"}},null,"سلفه علاج",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O48,0)","v":646.46},null,null,null,null,89]
[null,null,"الصافى",{"$f":"D48-J58","v":{"$error":"#REF!"}},null,"فرق اثاث",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O49,0)","v":955},null,null,null,null,90]
[null,null,null,null,null,"صندوق تامين العاملين اقساط",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O50,0)","v":2321.65},null,null,null,null,91]
[null,null,null,null,null,"مبالغ سددتها الشركة عن العامل",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O50,0)","v":2321.65}]
[null,null,null,null,null,"اجمالى الاستقطاعات",null,null,null,{"$f":"SUM(J9:J51)","v":6891.2199999999993}]
[null,null,null,null,null,"شيخوخة وعجز حصة عامل",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O53,0)","v":{"$error":"#REF!"}},null,null,null,null,93]
[null,null,null,null,null,"نظام مكافأة حصة عامل",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O54,0)","v":{"$error":"#REF!"}},null,null,null,null,94]
[null,null,null,null,null,"تامين مرض حصة عامل   (صحى )",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O55,0)","v":{"$error":"#REF!"}},null,null,null,null,95]
[null,null,null,null,null,"اجمالى  حصة تأمينات العامل",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O56,0)","v":{"$error":"#REF!"}},null,null,null,null,96]
[null,null,null,null,null,"حصة تأمينات الشركة",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O57,0)","v":{"$error":"#REF!"}},null,null,null,null,97]
[null,null,null,null,null,"اجمالى الاستقطاعات والتأمينات",null,null,null,{"$f":"VLOOKUP(K$4,' DBase'!$B:$CN,O58,0)","v":{"$error":"#REF!"}},null,null,null,null,98]

{"sheet":"Rules","index":2,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":true,"merged":[[14,7,14,9],[2,7,2,8],[2,9,7,9],[11,7,11,9],[10,7,10,9],[13,7,13,9]]}
["مصاريف انتقال","مصاريف اعاشة","منحة عيد العمال","اجمالى"]
[]
[null,null,null,null,null,null,null,"الجهود تم حسابها بدلالة( بدل التمثيل) ",null,"النسبة x ( الاساسى+العلاوات المضمومة)"]
[null,null,null,null,null,null,null,"بدل التمثيل","نسبة الجهود"]
[null,null,null,7757.41,null,null,null,0,0.45]
[null,null,"شيخوخة وعجز حصة عامل ",0.01,"جملة الاستحقاقات",null,null,100,0.6]
[null,null,null,{"$f":"D6*D5","v":77.574100000000001},null,null,null,150,0.65]
[null,null,null,null,null,null,null,200,0.7]
[]
[]
[null,null,null,null,null,null,null,"المساهمة التكافلية"]
[null,null,null,null,null,null,null,"جملة المستحق-(الضريبة + التأمينات + الزمالة )  * 1%"]
[]
[null,null,null,null,null,null,null,"قانون 4 لسنة 2021"]
[null,null,null,null,null,null,null,"جملة المستحق-(الضريبة + التأمينات + الزمالة+المساهمة التكافلية )  * 0.0005"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,1,null,null,{"$f":"IF($I25<>\"\",INDEX(DATA,MATCH($I25,NUM,0),COLUMN()-8),\"\")","v":350}]