{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Salary","Sal_Comul","All","Sheet16","Q6","Q1","AgeYR","MandF","Sum_SAL_M","tst1"],"not_rendered":{"charts":6,"images":1,"macros":1,"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":"Salary","index":0,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,19,2,19],[1,20,2,21],[3,19,4,19],[3,20,4,21],[1,22,2,23],[3,22,4,23]]}
[]
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد","سنوات الدراسة","الوظيفه","مجال الوظيفه","الراتب عند التعيين","سنة التعيين",null,"سنة التعيين","سنوات الخدمة",null,"÷2","الراتب الحالي","العمر الحالي بالسنةفقط","الترثة( الترفيع)",null,"عدد الكلي للاناث","مجموع الراتب الذكور عند اول تعيين",null,"متوسط الحسابي للراتب الحالي"]
[1,"احمد","صباغ","ذكر",19027,15,"مدير","انتاج",14250,98,"1998","1998-01-01",{"$f":"YEAR(TODAY())-(YEAR(L3))","v":21},{"$f":"M3/2","v":10.5},{"$f":"ROUNDDOWN(N3,0)","v":10},{"$f":"Sal_Comul!AX3","v":50602.398544406497},{"$f":"DATEDIF(E3,NOW(),\"y\")","v":67},{"$f":"IF(ISEVEN(M3)=FALSE,2019,2020)","v":2019}]
[2,"سامر","المصري","ذكر",21328,16,"مندوب","تسويق",10050,98,"1998","1998-01-01",21,{"$f":"M4/2","v":10.5},{"$f":"ROUNDDOWN(N4,0)","v":10},{"$f":"Sal_Comul!AX4","v":35688.007394476168},{"$f":"DATEDIF(E4,NOW(),\"y\")","v":61},{"$f":"IF(ISEVEN(M4)=FALSE,2019,2020)","v":2019},null,{"$f":"MandF!G5","v":9},{"$f":"Sum_SAL_M!N7","v":122531.25},null,{"$f":"AVERAGE(P3:P22)","v":47245.146185393831}]
[3,"اية","سليمان","أنثى",13998,12,"مندوب","تسويق",7500,95,"1995","1995-01-01",24,12,12,{"$f":"Sal_Comul!AX5","v":29029.797059685843},81,2020]
[4,"محمد","علواني","ذكر",17325,12,"أمين صندوق","مشتريات",7687.5,94,"1994","1994-01-01",25,12.5,12,{"$f":"Sal_Comul!AX6","v":32433.540764933994},72,2019]
[5,"رعد","المحمد","ذكر",21444,15,"عامل","انتاج",8700,94,"1994","1994-01-01",25,12.5,12,{"$f":"Sal_Comul!AX7","v":36705.275402266765},60,2019]
[6,"آمنة","سعدات","أنثى",22669,16,"كاتب","مشتريات",8700,93,"1993","1993-01-01",26,13,13,{"$f":"Sal_Comul!AX8","v":36705.275402266765},57,2020]
[7,"سمية","محمد","أنثى",22426,16,"مندوب","تسويق",12750,93,1993,"1993-01-01",26,13,13,{"$f":"Sal_Comul!AX9","v":53792.213951597856},58,2020]
[8,"فاطمة","الكحيل","أنثى",24909,12,"عامل","انتاج",6075,93,"1993","1993-01-01",26,13,13,{"$f":"Sal_Comul!AX10","v":25630.407823996622},51,2020]
[9,"جمال","عثمان","ذكر",22687,19,"مدير","مشتريات",18125,92,1992,"1992-01-01",27,13.5,13,{"$f":"Sal_Comul!AX11","v":83351.562892647431},57,2019]
[10,"سامر","علواني","ذكر",22456,19,"مدير","تسويق",17187.5,92,1992,"1992-01-01",27,13.5,13,{"$f":"Sal_Comul!AX12","v":79040.275156820877},58,2019]
[11,"عائشة","الطويل","أنثى",13938,8,"عامل","انتاج",4050,92,1992,"1992-01-01",27,13.5,13,{"$f":"Sal_Comul!AX13","v":18624.763018770882},81,2019]
[12,"ماجد","درغام","ذكر",17705,12,"أمين صندوق","تسويق",7687.5,91,1991,"1991-01-01",28,14,14,{"$f":"Sal_Comul!AX14","v":35352.559433778057},71,2020]
[13,"ثائر","المحمد","ذكر",21829,16,"مدير","تسويق",13718.75,90,1990,"1990-01-01",29,14.5,14,{"$f":"Sal_Comul!AX15","v":68766.476482346116},59,2019]
[14,"سامي","الفارابي","ذكر",22518,14,"عامل","انتاج",9450,90,1990,"1990-01-01",29,14.5,14,{"$f":"Sal_Comul!AX16","v":47368.98061107393},57,2019]
[15,"سميرة","المحجوب","أنثى",23640,12,"مندوب","تسويق",6937.5,87,1987,"1987-01-01",32,16,16,{"$f":"Sal_Comul!AX17","v":37904.583096123242},54,2020]
[16,"فاطمة","خالد","أنثى",18641,16,"مندوب","تسويق",6262.5,87,1987,"1987-01-01",32,16,16,{"$f":"Sal_Comul!AX18","v":34216.569605689634},68,2020]
[17,"دانة","سليمان","أنثى",25068,16,"مدير","تسويق",16500,86,1986,"1986-01-01",33,16.5,16,{"$f":"Sal_Comul!AX19","v":98265.070556220075},50,2019]
[18,"باسمة","قدري","أنثى",14844,12,"كاتب","مشتريات",4312.5,82,1982,"1982-01-01",37,18.5,18,{"$f":"Sal_Comul!AX20","v":30513.872699323147},78,2019]
[19,"اسماعيل","امجد","ذكر",12454,15,"مندوب","تسويق",5625,82,1982,"1982-01-01",37,18.5,18,{"$f":"Sal_Comul!AX21","v":39800.703520856274},85,2019]
[20,"محمد","عوض","ذكر",23751,16,"مدير","انتاج",10050,81,1981,"1981-01-01",38,19,19,{"$f":"Sal_Comul!AX22","v":71110.590290596519},54,2020]

{"sheet":"Sal_Comul","index":1,"n_rows":26,"n_cols":57,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,3,1,3],[0,4,1,4],[0,5,1,5]]}
[null,null,null,"years Srvs","Copy No only","PVR",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,1980,{"$f":"J2+1","v":1981},{"$f":"K2+1","v":1982},1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,{"$f":"AC2+1","v":2000},2001,2002,2003,2004,2005,2006,2007,2008,{"$f":"AM2+1","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,null,"ترقية"]
[14250,98,"1/1/1998",24,10,{"$f":"Yearly_Rate(A3,0.09,E3)","v":33734.932362937696},null,14250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14250,{"$f":"AB3","v":14250},15532.5,{"$f":"AD3+(AD3*0.5)","v":23298.75},{"$f":"AE3","v":23298.75},{"$f":"AF3+(AF3*0.09)","v":25395.637500000001},{"$f":"AG3","v":25395.637500000001},{"$f":"AH3+(AH3*0.09)","v":27681.244875},{"$f":"AI3","v":27681.244875},{"$f":"AJ3+(AJ3*0.09)","v":30172.556913749999},{"$f":"AK3","v":30172.556913749999},{"$f":"AL3+(AL3*0.09)","v":32888.087035987497},{"$f":"AM3","v":32888.087035987497},{"$f":"AN3+(AN3*0.09)","v":35848.014869226368},{"$f":"AO3","v":35848.014869226368},{"$f":"AP3+(AP3*0.09)","v":39074.336207456741},{"$f":"AQ3","v":39074.336207456741},{"$f":"AR3+(AR3*0.09)","v":42591.026466127849},{"$f":"AS3","v":42591.026466127849},{"$f":"AT3+(AT3*0.09)","v":46424.218848079356},{"$f":"AU3","v":46424.218848079356},{"$f":"AV3+(AV3*0.09)","v":50602.398544406497},{"$f":"AW3","v":50602.398544406497},null,{"$f":"IF(AX3=AW3,$AX$2,\"2020\")","v":2019},null,33734.932362937696,{"$f":"IF(AX3=BB3,TRUE,FALSE)","v":false},{"$f":"TRUNC(AX3,2)=TRUNC(BB3,2)","v":false},{"$f":"ROUNDDOWN(AX3,2)=ROUNDDOWN(BB3,2)","v":false}]
[10050,98,"1/1/1998",21,10,{"$f":"Yearly_Rate(A4,0.09,E4)","v":23792.004929650797},null,10050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10050,{"$f":"AB4","v":10050},10954.5,{"$f":"AD4+(AD4*0.5)","v":16431.75},{"$f":"AE4","v":16431.75},{"$f":"AF4+(AF4*0.09)","v":17910.607499999998},{"$f":"AG4","v":17910.607499999998},{"$f":"AH4+(AH4*0.09)","v":19522.562174999999},{"$f":"AI4","v":19522.562174999999},{"$f":"AJ4+(AJ4*0.09)","v":21279.592770749998},{"$f":"AK4","v":21279.592770749998},{"$f":"AL4+(AL4*0.09)","v":23194.756120117498},{"$f":"AM4","v":23194.756120117498},{"$f":"AN4+(AN4*0.09)","v":25282.284170928073},{"$f":"AO4","v":25282.284170928073},{"$f":"AP4+(AP4*0.09)","v":27557.6897463116},{"$f":"AQ4","v":27557.6897463116},{"$f":"AR4+(AR4*0.09)","v":30037.881823479645},{"$f":"AS4","v":30037.881823479645},{"$f":"AT4+(AT4*0.09)","v":32741.291187592815},{"$f":"AU4","v":32741.291187592815},{"$f":"AV4+(AV4*0.09)","v":35688.007394476168},35688.007394476168,null,{"$f":"IF(AX4=AW4,$AX$2,\"2020\")","v":2019},null,23792.004929650797,{"$f":"IF(AX4=BB4,TRUE,FALSE)","v":false},{"$f":"TRUNC(AX4,2)=TRUNC(BB4,2)","v":false},{"$f":"ROUNDDOWN(AX4,2)=ROUNDDOWN(BB4,2)","v":false}]
[7500,95,"1/1/1995",24,12,21094.985863371727,null,7500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7500,{"$f":"Y5","v":7500},{"$f":"Z5+(Z5*0.09)","v":8175},{"$f":"AA5","v":8175},{"$f":"AB5+(AB5*0.09)","v":8910.75},8910.75,13366.125,13366.125,14569.07625,{"$f":"AG5","v":14569.07625},{"$f":"AH5+(AH5*0.09)","v":15880.2931125},{"$f":"AI5","v":15880.2931125},{"$f":"AJ5+(AJ5*0.09)","v":17309.519492625001},{"$f":"AK5","v":17309.519492625001},{"$f":"AL5+(AL5*0.09)","v":18867.376246961252},{"$f":"AM5","v":18867.376246961252},{"$f":"AN5+(AN5*0.09)","v":20565.440109187766},{"$f":"AO5","v":20565.440109187766},{"$f":"AP5+(AP5*0.09)","v":22416.329719014666},{"$f":"AQ5","v":22416.329719014666},{"$f":"AR5+(AR5*0.09)","v":24433.799393725985},{"$f":"AS5","v":24433.799393725985},{"$f":"AT5+(AT5*0.09)","v":26632.841339161325},{"$f":"AU5","v":26632.841339161325},{"$f":"AV5+(AV5*0.09)","v":29029.797059685843},29029.797059685843,null,2019,null,21094.985863371727,false,false,false]
[7687.5,94,"1/1/1994",25,12,21622.360509956019,null,7687.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7687.5,{"$f":"X6","v":7687.5},{"$f":"Y6+(Y6*0.09)","v":8379.375},{"$f":"Z6","v":8379.375},{"$f":"AA6+(AA6*0.09)","v":9133.5187499999993},{"$f":"AB6","v":9133.5187499999993},9955.5354374999988,14933.303156249998,14933.303156249998,16277.300440312498,{"$f":"AG6","v":16277.300440312498},{"$f":"AH6+(AH6*0.09)","v":17742.257479940621},{"$f":"AI6","v":17742.257479940621},{"$f":"AJ6+(AJ6*0.09)","v":19339.060653135275},{"$f":"AK6","v":19339.060653135275},{"$f":"AL6+(AL6*0.09)","v":21079.576111917449},{"$f":"AM6","v":21079.576111917449},{"$f":"AN6+(AN6*0.09)","v":22976.73796199002},{"$f":"AO6","v":22976.73796199002},{"$f":"AP6+(AP6*0.09)","v":25044.644378569123},{"$f":"AQ6","v":25044.644378569123},{"$f":"AR6+(AR6*0.09)","v":27298.662372640345},{"$f":"AS6","v":27298.662372640345},{"$f":"AT6+(AT6*0.09)","v":29755.541986177977},{"$f":"AU6","v":29755.541986177977},{"$f":"AV6+(AV6*0.09)","v":32433.540764933994},32433.540764933994,null,2019,null,21622.360509956019,false,false,false]
[8700,94,"1/1/1994",25,12,24470.183601511202,null,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8700,{"$f":"X7","v":8700},{"$f":"Y7+(Y7*0.09)","v":9483},{"$f":"Z7","v":9483},{"$f":"AA7+(AA7*0.09)","v":10336.469999999999},{"$f":"AB7","v":10336.469999999999},11266.7523,16900.12845,16900.12845,18421.140010499999,{"$f":"AG7","v":18421.140010499999},{"$f":"AH7+(AH7*0.09)","v":20079.042611444998},{"$f":"AI7","v":20079.042611444998},{"$f":"AJ7+(AJ7*0.09)","v":21886.156446475048},{"$f":"AK7","v":21886.156446475048},{"$f":"AL7+(AL7*0.09)","v":23855.910526657801},{"$f":"AM7","v":23855.910526657801},{"$f":"AN7+(AN7*0.09)","v":26002.942474057003},{"$f":"AO7","v":26002.942474057003},{"$f":"AP7+(AP7*0.09)","v":28343.207296722132},{"$f":"AQ7","v":28343.207296722132},{"$f":"AR7+(AR7*0.09)","v":30894.095953427124},{"$f":"AS7","v":30894.095953427124},{"$f":"AT7+(AT7*0.09)","v":33674.564589235568},{"$f":"AU7","v":33674.564589235568},{"$f":"AV7+(AV7*0.09)","v":36705.275402266765},36705.275402266765,null,2019,null,24470.183601511202,false,false,false]
[8700,93,"1/1/1993",26,13,26672.500125647213,null,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8700,{"$f":"W8","v":8700},{"$f":"X8+(X8*0.09)","v":9483},{"$f":"Y8","v":9483},{"$f":"Z8+(Z8*0.09)","v":10336.469999999999},{"$f":"AA8","v":10336.469999999999},{"$f":"AB8+(AB8*0.09)","v":11266.7523},11266.7523,16900.12845,16900.12845,18421.140010499999,{"$f":"AG8","v":18421.140010499999},{"$f":"AH8+(AH8*0.09)","v":20079.042611444998},{"$f":"AI8","v":20079.042611444998},{"$f":"AJ8+(AJ8*0.09)","v":21886.156446475048},{"$f":"AK8","v":21886.156446475048},{"$f":"AL8+(AL8*0.09)","v":23855.910526657801},{"$f":"AM8","v":23855.910526657801},{"$f":"AN8+(AN8*0.09)","v":26002.942474057003},{"$f":"AO8","v":26002.942474057003},{"$f":"AP8+(AP8*0.09)","v":28343.207296722132},{"$f":"AQ8","v":28343.207296722132},{"$f":"AR8+(AR8*0.09)","v":30894.095953427124},{"$f":"AS8","v":30894.095953427124},{"$f":"AT8+(AT8*0.09)","v":33674.564589235568},{"$f":"AU8","v":33674.564589235568},{"$f":"AV8+(AV8*0.09)","v":36705.275402266765},36705.275402266765,null,2019,null,26672.500125647213,false,false,false]
[12750,93,"1/1/1993",26,13,39089.008804827812,null,12750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12750,{"$f":"W9","v":12750},{"$f":"X9+(X9*0.09)","v":13897.5},{"$f":"Y9","v":13897.5},{"$f":"Z9+(Z9*0.09)","v":15148.275},{"$f":"AA9","v":15148.275},{"$f":"AB9+(AB9*0.09)","v":16511.619749999998},16511.619749999998,24767.429624999997,24767.429624999997,26996.498291249998,{"$f":"AG9","v":26996.498291249998},{"$f":"AH9+(AH9*0.09)","v":29426.183137462496},{"$f":"AI9","v":29426.183137462496},{"$f":"AJ9+(AJ9*0.09)","v":32074.539619834122},{"$f":"AK9","v":32074.539619834122},{"$f":"AL9+(AL9*0.09)","v":34961.248185619195},{"$f":"AM9","v":34961.248185619195},{"$f":"AN9+(AN9*0.09)","v":38107.760522324927},{"$f":"AO9","v":38107.760522324927},{"$f":"AP9+(AP9*0.09)","v":41537.45896933417},{"$f":"AQ9","v":41537.45896933417},{"$f":"AR9+(AR9*0.09)","v":45275.830276574241},{"$f":"AS9","v":45275.830276574241},{"$f":"AT9+(AT9*0.09)","v":49350.655001465922},{"$f":"AU9","v":49350.655001465922},{"$f":"AV9+(AV9*0.09)","v":53792.213951597856},53792.213951597856,null,2019,null,39089.008804827812,false,false,false]
[6075,93,"1/1/1993",26,13,18624.7630187709,null,6075,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6075,{"$f":"W10","v":6075},{"$f":"X10+(X10*0.09)","v":6621.75},{"$f":"Y10","v":6621.75},{"$f":"Z10+(Z10*0.09)","v":7217.7075000000004},{"$f":"AA10","v":7217.7075000000004},{"$f":"AB10+(AB10*0.09)","v":7867.3011750000005},7867.3011750000005,11800.951762500001,11800.951762500001,12863.037421125,{"$f":"AG10","v":12863.037421125},{"$f":"AH10+(AH10*0.09)","v":14020.71078902625},{"$f":"AI10","v":14020.71078902625},{"$f":"AJ10+(AJ10*0.09)","v":15282.574760038613},{"$f":"AK10","v":15282.574760038613},{"$f":"AL10+(AL10*0.09)","v":16658.006488442086},{"$f":"AM10","v":16658.006488442086},{"$f":"AN10+(AN10*0.09)","v":18157.227072401874},{"$f":"AO10","v":18157.227072401874},{"$f":"AP10+(AP10*0.09)","v":19791.377508918042},{"$f":"AQ10","v":19791.377508918042},{"$f":"AR10+(AR10*0.09)","v":21572.601484720664},{"$f":"AS10","v":21572.601484720664},{"$f":"AT10+(AT10*0.09)","v":23514.135618345525},{"$f":"AU10","v":23514.135618345525},{"$f":"AV10+(AV10*0.09)","v":25630.407823996622},25630.407823996622,null,2019,null,18624.7630187709,false,false,false]
[18125,92,"1/1/1992",27,13,55567.70859509836,null,18125,null,null,null,null,null,null,null,null,null,null,null,null,null,18125,{"$f":"V11","v":18125},{"$f":"W11+(W11*0.09)","v":19756.25},{"$f":"X11","v":19756.25},{"$f":"Y11+(Y11*0.09)","v":21534.3125},{"$f":"Z11","v":21534.3125},{"$f":"AA11+(AA11*0.09)","v":23472.400624999998},{"$f":"AB11","v":23472.400624999998},25584.916681249997,38377.375021874992,38377.375021874992,41831.338773843738,{"$f":"AG11","v":41831.338773843738},{"$f":"AH11+(AH11*0.09)","v":45596.159263489673},{"$f":"AI11","v":45596.159263489673},{"$f":"AJ11+(AJ11*0.09)","v":49699.813597203742},{"$f":"AK11","v":49699.813597203742},{"$f":"AL11+(AL11*0.09)","v":54172.796820952077},{"$f":"AM11","v":54172.796820952077},{"$f":"AN11+(AN11*0.09)","v":59048.348534837765},{"$f":"AO11","v":59048.348534837765},{"$f":"AP11+(AP11*0.09)","v":64362.699902973167},{"$f":"AQ11","v":64362.699902973167},{"$f":"AR11+(AR11*0.09)","v":70155.342894240748},{"$f":"AS11","v":70155.342894240748},{"$f":"AT11+(AT11*0.09)","v":76469.323754722413},{"$f":"AU11","v":76469.323754722413},{"$f":"AV11+(AV11*0.09)","v":83351.562892647431},83351.562892647431,null,2019,null,55567.70859509836,{"$f":"IF(AX11=BB11,TRUE,FALSE)","v":false},false,false]
[17187.5,92,"1/1/1992",27,13,52693.516771213959,null,17187.5,null,null,null,null,null,null,null,null,null,null,null,null,null,17187.5,{"$f":"V12","v":17187.5},{"$f":"W12+(W12*0.09)","v":18734.375},{"$f":"X12","v":18734.375},{"$f":"Y12+(Y12*0.09)","v":20420.46875},{"$f":"Z12","v":20420.46875},{"$f":"AA12+(AA12*0.09)","v":22258.310937499999},{"$f":"AB12","v":22258.310937499999},24261.558921874999,36392.338382812501,36392.338382812501,39667.648837265624,{"$f":"AG12","v":39667.648837265624},{"$f":"AH12+(AH12*0.09)","v":43237.737232619533},{"$f":"AI12","v":43237.737232619533},{"$f":"AJ12+(AJ12*0.09)","v":47129.133583555289},{"$f":"AK12","v":47129.133583555289},{"$f":"AL12+(AL12*0.09)","v":51370.755606075269},{"$f":"AM12","v":51370.755606075269},{"$f":"AN12+(AN12*0.09)","v":55994.123610622046},{"$f":"AO12","v":55994.123610622046},{"$f":"AP12+(AP12*0.09)","v":61033.59473557803},{"$f":"AQ12","v":61033.59473557803},{"$f":"AR12+(AR12*0.09)","v":66526.618261780051},{"$f":"AS12","v":66526.618261780051},{"$f":"AT12+(AT12*0.09)","v":72514.013905340253},{"$f":"AU12","v":72514.013905340253},{"$f":"AV12+(AV12*0.09)","v":79040.275156820877},79040.275156820877,null,2019,null,52693.516771213959,false,false,false]
[4050,92,"1/1/1992",27,13,12416.508679180599,null,4050,null,null,null,null,null,null,null,null,null,null,null,null,null,4050,{"$f":"V13","v":4050},{"$f":"W13+(W13*0.09)","v":4414.5},{"$f":"X13","v":4414.5},{"$f":"Y13+(Y13*0.09)","v":4811.8050000000003},{"$f":"Z13","v":4811.8050000000003},{"$f":"AA13+(AA13*0.09)","v":5244.8674500000006},{"$f":"AB13","v":5244.8674500000006},5716.9055205000004,8575.3582807500006,8575.3582807500006,9347.1405260175015,{"$f":"AG13","v":9347.1405260175015},{"$f":"AH13+(AH13*0.09)","v":10188.383173359076},{"$f":"AI13","v":10188.383173359076},{"$f":"AJ13+(AJ13*0.09)","v":11105.337658961393},{"$f":"AK13","v":11105.337658961393},{"$f":"AL13+(AL13*0.09)","v":12104.818048267918},{"$f":"AM13","v":12104.818048267918},{"$f":"AN13+(AN13*0.09)","v":13194.25167261203},{"$f":"AO13","v":13194.25167261203},{"$f":"AP13+(AP13*0.09)","v":14381.734323147113},{"$f":"AQ13","v":14381.734323147113},{"$f":"AR13+(AR13*0.09)","v":15676.090412230353},{"$f":"AS13","v":15676.090412230353},{"$f":"AT13+(AT13*0.09)","v":17086.938549331084},{"$f":"AU13","v":17086.938549331084},{"$f":"AV13+(AV13*0.09)","v":18624.763018770882},18624.763018770882,null,2019,null,12416.508679180599,false,false,false]
[7687.5,91,"1/1/1991",28,14,25689.526521878754,null,7687.5,null,null,null,null,null,null,null,null,null,null,null,null,7687.5,{"$f":"U14","v":7687.5},{"$f":"V14+(V14*0.09)","v":8379.375},{"$f":"W14","v":8379.375},{"$f":"X14+(X14*0.09)","v":9133.5187499999993},{"$f":"Y14","v":9133.5187499999993},{"$f":"Z14+(Z14*0.09)","v":9955.5354374999988},{"$f":"AA14","v":9955.5354374999988},{"$f":"AB14+(AB14*0.09)","v":10851.533626874998},10851.533626874998,16277.300440312498,16277.300440312498,17742.257479940621,{"$f":"AG14","v":17742.257479940621},{"$f":"AH14+(AH14*0.09)","v":19339.060653135275},{"$f":"AI14","v":19339.060653135275},{"$f":"AJ14+(AJ14*0.09)","v":21079.576111917449},{"$f":"AK14","v":21079.576111917449},{"$f":"AL14+(AL14*0.09)","v":22976.73796199002},{"$f":"AM14","v":22976.73796199002},{"$f":"AN14+(AN14*0.09)","v":25044.644378569123},{"$f":"AO14","v":25044.644378569123},{"$f":"AP14+(AP14*0.09)","v":27298.662372640345},{"$f":"AQ14","v":27298.662372640345},{"$f":"AR14+(AR14*0.09)","v":29755.541986177977},{"$f":"AS14","v":29755.541986177977},{"$f":"AT14+(AT14*0.09)","v":32433.540764933994},{"$f":"AU14","v":32433.540764933994},{"$f":"AV14+(AV14*0.09)","v":35352.559433778057},35352.559433778057,null,2019,null,25689.526521878754,false,false,false]
[13718.75,90,"1/1/1990",29,14,45844.317654897452,null,13718.75,null,null,null,null,null,null,null,null,null,null,null,13718.75,{"$f":"T15","v":13718.75},{"$f":"U15+(U15*0.09)","v":14953.4375},{"$f":"V15","v":14953.4375},{"$f":"W15+(W15*0.09)","v":16299.246875000001},{"$f":"X15","v":16299.246875000001},{"$f":"Y15+(Y15*0.09)","v":17766.179093750001},{"$f":"Z15","v":17766.179093750001},{"$f":"AA15+(AA15*0.09)","v":19365.135212187502},{"$f":"AB15","v":19365.135212187502},21107.997381284378,31661.996071926565,31661.996071926565,34511.575718399959,{"$f":"AG15","v":34511.575718399959},{"$f":"AH15+(AH15*0.09)","v":37617.617533055956},{"$f":"AI15","v":37617.617533055956},{"$f":"AJ15+(AJ15*0.09)","v":41003.203111030991},{"$f":"AK15","v":41003.203111030991},{"$f":"AL15+(AL15*0.09)","v":44693.491391023781},{"$f":"AM15","v":44693.491391023781},{"$f":"AN15+(AN15*0.09)","v":48715.905616215925},{"$f":"AO15","v":48715.905616215925},{"$f":"AP15+(AP15*0.09)","v":53100.337121675359},{"$f":"AQ15","v":53100.337121675359},{"$f":"AR15+(AR15*0.09)","v":57879.367462626142},{"$f":"AS15","v":57879.367462626142},{"$f":"AT15+(AT15*0.09)","v":63088.510534262496},{"$f":"AU15","v":63088.510534262496},{"$f":"AV15+(AV15*0.09)","v":68766.476482346116},68766.476482346116,null,2019,null,45844.317654897452,false,false,false]
[9450,90,"1/1/1990",29,14,31579.32040738266,null,9450,null,null,null,null,null,null,null,null,null,null,null,9450,{"$f":"T16","v":9450},{"$f":"U16+(U16*0.09)","v":10300.5},{"$f":"V16","v":10300.5},{"$f":"W16+(W16*0.09)","v":11227.545},{"$f":"X16","v":11227.545},{"$f":"Y16+(Y16*0.09)","v":12238.02405},{"$f":"Z16","v":12238.02405},{"$f":"AA16+(AA16*0.09)","v":13339.4462145},{"$f":"AB16","v":13339.4462145},14539.996373804999,21809.994560707499,21809.994560707499,23772.894071171173,{"$f":"AG16","v":23772.894071171173},{"$f":"AH16+(AH16*0.09)","v":25912.454537576577},{"$f":"AI16","v":25912.454537576577},{"$f":"AJ16+(AJ16*0.09)","v":28244.575445958468},{"$f":"AK16","v":28244.575445958468},{"$f":"AL16+(AL16*0.09)","v":30786.587236094729},{"$f":"AM16","v":30786.587236094729},{"$f":"AN16+(AN16*0.09)","v":33557.380087343256},{"$f":"AO16","v":33557.380087343256},{"$f":"AP16+(AP16*0.09)","v":36577.544295204149},{"$f":"AQ16","v":36577.544295204149},{"$f":"AR16+(AR16*0.09)","v":39869.523281772519},{"$f":"AS16","v":39869.523281772519},{"$f":"AT16+(AT16*0.09)","v":43457.780377132047},{"$f":"AU16","v":43457.780377132047},{"$f":"AV16+(AV16*0.09)","v":47368.98061107393},47368.98061107393,null,2019,null,31579.32040738266,false,false,false]
[6937.5,87,"1/1/1987",32,16,27543.9970498496,null,6937.5,null,null,null,null,null,null,null,null,6937.5,{"$f":"Q17","v":6937.5},{"$f":"R17+(R17*0.09)","v":7561.875},{"$f":"S17","v":7561.875},{"$f":"T17+(T17*0.09)","v":8242.4437500000004},{"$f":"U17","v":8242.4437500000004},{"$f":"V17+(V17*0.09)","v":8984.2636875000007},{"$f":"W17","v":8984.2636875000007},{"$f":"X17+(X17*0.09)","v":9792.8474193750008},{"$f":"Y17","v":9792.8474193750008},{"$f":"Z17+(Z17*0.09)","v":10674.20368711875},{"$f":"AA17","v":10674.20368711875},{"$f":"AB17+(AB17*0.09)","v":11634.882018959437},11634.882018959437,17452.323028439154,17452.323028439154,19023.032100998676,{"$f":"AG17","v":19023.032100998676},{"$f":"AH17+(AH17*0.09)","v":20735.104990088555},{"$f":"AI17","v":20735.104990088555},{"$f":"AJ17+(AJ17*0.09)","v":22601.264439196526},{"$f":"AK17","v":22601.264439196526},{"$f":"AL17+(AL17*0.09)","v":24635.378238724214},{"$f":"AM17","v":24635.378238724214},{"$f":"AN17+(AN17*0.09)","v":26852.562280209393},{"$f":"AO17","v":26852.562280209393},{"$f":"AP17+(AP17*0.09)","v":29269.292885428236},{"$f":"AQ17","v":29269.292885428236},{"$f":"AR17+(AR17*0.09)","v":31903.529245116777},{"$f":"AS17","v":31903.529245116777},{"$f":"AT17+(AT17*0.09)","v":34774.84687717729},{"$f":"AU17","v":34774.84687717729},{"$f":"AV17+(AV17*0.09)","v":37904.583096123242},37904.583096123242,null,2019,null,27543.9970498496,false,false,false]
[6262.5,87,"1/1/1987",32,16,24864.040580134504,null,6262.5,null,null,null,null,null,null,null,null,6262.5,{"$f":"Q18","v":6262.5},{"$f":"R18+(R18*0.09)","v":6826.125},{"$f":"S18","v":6826.125},{"$f":"T18+(T18*0.09)","v":7440.4762499999997},{"$f":"U18","v":7440.4762499999997},{"$f":"V18+(V18*0.09)","v":8110.1191124999996},{"$f":"W18","v":8110.1191124999996},{"$f":"X18+(X18*0.09)","v":8840.0298326249995},{"$f":"Y18","v":8840.0298326249995},{"$f":"Z18+(Z18*0.09)","v":9635.6325175612492},{"$f":"AA18","v":9635.6325175612492},{"$f":"AB18+(AB18*0.09)","v":10502.839444141762},10502.839444141762,15754.259166212643,15754.259166212643,17172.14249117178,{"$f":"AG18","v":17172.14249117178},{"$f":"AH18+(AH18*0.09)","v":18717.63531537724},{"$f":"AI18","v":18717.63531537724},{"$f":"AJ18+(AJ18*0.09)","v":20402.22249376119},{"$f":"AK18","v":20402.22249376119},{"$f":"AL18+(AL18*0.09)","v":22238.422518199695},{"$f":"AM18","v":22238.422518199695},{"$f":"AN18+(AN18*0.09)","v":24239.880544837666},{"$f":"AO18","v":24239.880544837666},{"$f":"AP18+(AP18*0.09)","v":26421.469793873057},{"$f":"AQ18","v":26421.469793873057},{"$f":"AR18+(AR18*0.09)","v":28799.402075321632},{"$f":"AS18","v":28799.402075321632},{"$f":"AT18+(AT18*0.09)","v":31391.348262100579},{"$f":"AU18","v":31391.348262100579},{"$f":"AV18+(AV18*0.09)","v":34216.569605689634},34216.569605689634,null,2019,null,24864.040580134504,false,false,false]
[16500,86,"1/1/1986",33,16,65510.04703748013,null,16500,null,null,null,null,null,null,null,16500,{"$f":"P19","v":16500},{"$f":"Q19+(Q19*0.09)","v":17985},{"$f":"R19","v":17985},{"$f":"S19+(S19*0.09)","v":19603.650000000001},{"$f":"T19","v":19603.650000000001},{"$f":"U19+(U19*0.09)","v":21367.978500000001},{"$f":"V19","v":21367.978500000001},{"$f":"W19+(W19*0.09)","v":23291.096565},{"$f":"X19","v":23291.096565},{"$f":"Y19+(Y19*0.09)","v":25387.29525585},{"$f":"Z19","v":25387.29525585},{"$f":"AA19+(AA19*0.09)","v":27672.1518288765},{"$f":"AB19","v":27672.1518288765},30162.645493475386,45243.968240213078,45243.968240213078,49315.925381832254,{"$f":"AG19","v":49315.925381832254},{"$f":"AH19+(AH19*0.09)","v":53754.358666197157},{"$f":"AI19","v":53754.358666197157},{"$f":"AJ19+(AJ19*0.09)","v":58592.250946154898},{"$f":"AK19","v":58592.250946154898},{"$f":"AL19+(AL19*0.09)","v":63865.55353130884},{"$f":"AM19","v":63865.55353130884},{"$f":"AN19+(AN19*0.09)","v":69613.453349126634},{"$f":"AO19","v":69613.453349126634},{"$f":"AP19+(AP19*0.09)","v":75878.664150548037},{"$f":"AQ19","v":75878.664150548037},{"$f":"AR19+(AR19*0.09)","v":82707.743924097362},{"$f":"AS19","v":82707.743924097362},{"$f":"AT19+(AT19*0.09)","v":90151.440877266126},{"$f":"AU19","v":90151.440877266126},{"$f":"AV19+(AV19*0.09)","v":98265.070556220075},98265.070556220075,null,2019,null,65510.04703748013,false,false,false]
[4312.5,82,"1/1/1982",37,18,20342.581799548789,null,4312.5,null,null,null,4312.5,{"$f":"L20","v":4312.5},{"$f":"M20+(M20*0.09)","v":4700.625},{"$f":"N20","v":4700.625},{"$f":"O20+(O20*0.09)","v":5123.6812499999996},{"$f":"P20","v":5123.6812499999996},{"$f":"Q20+(Q20*0.09)","v":5584.8125624999993},{"$f":"R20","v":5584.8125624999993},{"$f":"S20+(S20*0.09)","v":6087.4456931249988},{"$f":"T20","v":6087.4456931249988},{"$f":"U20+(U20*0.09)","v":6635.3158055062486},{"$f":"V20","v":6635.3158055062486},{"$f":"W20+(W20*0.09)","v":7232.4942280018113},{"$f":"X20","v":7232.4942280018113},{"$f":"Y20+(Y20*0.09)","v":7883.4187085219746},{"$f":"Z20","v":7883.4187085219746},{"$f":"AA20+(AA20*0.09)","v":8592.9263922889531},{"$f":"AB20","v":8592.9263922889531},9366.2897675949589,14049.434651392439,14049.434651392439,15313.883770017759,{"$f":"AG20","v":15313.883770017759},{"$f":"AH20+(AH20*0.09)","v":16692.133309319357},{"$f":"AI20","v":16692.133309319357},{"$f":"AJ20+(AJ20*0.09)","v":18194.425307158101},{"$f":"AK20","v":18194.425307158101},{"$f":"AL20+(AL20*0.09)","v":19831.923584802331},{"$f":"AM20","v":19831.923584802331},{"$f":"AN20+(AN20*0.09)","v":21616.79670743454},{"$f":"AO20","v":21616.79670743454},{"$f":"AP20+(AP20*0.09)","v":23562.308411103648},{"$f":"AQ20","v":23562.308411103648},{"$f":"AR20+(AR20*0.09)","v":25682.916168102976},{"$f":"AS20","v":25682.916168102976},{"$f":"AT20+(AT20*0.09)","v":27994.378623232245},{"$f":"AU20","v":27994.378623232245},{"$f":"AV20+(AV20*0.09)","v":30513.872699323147},30513.872699323147,null,2019,null,20342.581799548789,false,false,false]
[5625,82,"1/1/1982",37,18,26533.802347237553,null,5625,null,null,null,5625,{"$f":"L21","v":5625},{"$f":"M21+(M21*0.09)","v":6131.25},{"$f":"N21","v":6131.25},{"$f":"O21+(O21*0.09)","v":6683.0625},{"$f":"P21","v":6683.0625},{"$f":"Q21+(Q21*0.09)","v":7284.538125},{"$f":"R21","v":7284.538125},{"$f":"S21+(S21*0.09)","v":7940.1465562499998},{"$f":"T21","v":7940.1465562499998},{"$f":"U21+(U21*0.09)","v":8654.7597463125003},{"$f":"V21","v":8654.7597463125003},{"$f":"W21+(W21*0.09)","v":9433.688123480626},{"$f":"X21","v":9433.688123480626},{"$f":"Y21+(Y21*0.09)","v":10282.720054593883},{"$f":"Z21","v":10282.720054593883},{"$f":"AA21+(AA21*0.09)","v":11208.164859507333},{"$f":"AB21","v":11208.164859507333},12216.899696862993,18325.349545294488,18325.349545294488,19974.631004370993,{"$f":"AG21","v":19974.631004370993},{"$f":"AH21+(AH21*0.09)","v":21772.347794764381},{"$f":"AI21","v":21772.347794764381},{"$f":"AJ21+(AJ21*0.09)","v":23731.859096293174},{"$f":"AK21","v":23731.859096293174},{"$f":"AL21+(AL21*0.09)","v":25867.726414959558},{"$f":"AM21","v":25867.726414959558},{"$f":"AN21+(AN21*0.09)","v":28195.821792305916},{"$f":"AO21","v":28195.821792305916},{"$f":"AP21+(AP21*0.09)","v":30733.445753613451},{"$f":"AQ21","v":30733.445753613451},{"$f":"AR21+(AR21*0.09)","v":33499.455871438659},{"$f":"AS21","v":33499.455871438659},{"$f":"AT21+(AT21*0.09)","v":36514.40689986814},{"$f":"AU21","v":36514.40689986814},{"$f":"AV21+(AV21*0.09)","v":39800.703520856274},39800.703520856274,null,2019,null,26533.802347237553,false,false,false]
[10050,81,"1/1/1981",38,19,51673.695611166891,null,10050,null,null,10050,{"$f":"K22","v":10050},{"$f":"L22+(L22*0.09)","v":10954.5},{"$f":"M22","v":10954.5},{"$f":"N22+(N22*0.09)","v":11940.405000000001},{"$f":"O22","v":11940.405000000001},{"$f":"P22+(P22*0.09)","v":13015.041450000001},{"$f":"Q22","v":13015.041450000001},{"$f":"R22+(R22*0.09)","v":14186.3951805},{"$f":"S22","v":14186.3951805},{"$f":"T22+(T22*0.09)","v":15463.170746745},{"$f":"U22","v":15463.170746745},{"$f":"V22+(V22*0.09)","v":16854.85611395205},{"$f":"W22","v":16854.85611395205},{"$f":"X22+(X22*0.09)","v":18371.793164207735},{"$f":"Y22","v":18371.793164207735},{"$f":"Z22+(Z22*0.09)","v":20025.254548986431},{"$f":"AA22","v":20025.254548986431},{"$f":"AB22+(AB22*0.09)","v":21827.527458395209},21827.527458395209,32741.291187592811,32741.291187592811,35688.007394476161,{"$f":"AG22","v":35688.007394476161},{"$f":"AH22+(AH22*0.09)","v":38899.928059979015},{"$f":"AI22","v":38899.928059979015},{"$f":"AJ22+(AJ22*0.09)","v":42400.921585377124},{"$f":"AK22","v":42400.921585377124},{"$f":"AL22+(AL22*0.09)","v":46217.004528061065},{"$f":"AM22","v":46217.004528061065},{"$f":"AN22+(AN22*0.09)","v":50376.534935586562},{"$f":"AO22","v":50376.534935586562},{"$f":"AP22+(AP22*0.09)","v":54910.423079789354},{"$f":"AQ22","v":54910.423079789354},{"$f":"AR22+(AR22*0.09)","v":59852.361156970393},{"$f":"AS22","v":59852.361156970393},{"$f":"AT22+(AT22*0.09)","v":65239.073661097726},{"$f":"AU22","v":65239.073661097726},{"$f":"AV22+(AV22*0.09)","v":71110.590290596519},71110.590290596519,null,2019,null,51673.695611166891,false,false,false]
[100,null,null,null,3,{"$f":"Yearly_Rate(A23,0.09,E23)","v":129.50290000000001},null,100,null,null,100,{"$f":"K23","v":100},{"$f":"L23+(L23*0.09)","v":109},{"$f":"M23","v":109},{"$f":"N23+(N23*0.09)","v":118.81},{"$f":"O23","v":118.81},{"$f":"P23+(P23*0.09)","v":129.50290000000001},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,129.50290000000001,null,null,null,129.50290000000001,true,true,true]
[]
[10050,81,"1/1/1981",{"$error":"#VALUE!"},10.4,{"$f":"ROUNDDOWN(E25,0)","v":10}]
[null,null,null,null,null,{"$f":"A23*(1+0.09)^E23","v":129.50290000000001}]

{"sheet":"All","index":2,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"M3/2","v":12}]
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد","سنوات الدراسة","الوظيفه","مجال الوظيفه","الراتب عند التعيين","سنة التعيين",null,"سنة التعيين","سنوات الخدمة","علاوة الترفيع 9% كل عامين",null,null,"الراتب الحالي"]
[1,"احمد","صباغ","ذكر","1952-02-03",15,"مدير","انتاج",14250,98,"1998","1/1/1995",{"$f":"YEAR(TODAY())-(YEAR(L3))","v":24},{"$f":"(0.09*I3)","v":1282.5},{"$f":"N3*(0.5*M3)","v":15390},{"$f":"I3+(I3*EFFECT(EFFECT(0.09,0.5)*(M1),(M1)))","v":{"$error":"#NUM!"}},{"$f":"Sal_Comul!AX3","v":50602.398544406497}]
[2,"سامر","المصري","ذكر","1958-05-23",16,"مندوب","تسويق",10050,98,"1998","1/1/1998",{"$f":"YEAR(TODAY())-(YEAR(L4))","v":21},null,null,null,{"$f":"Sal_Comul!AX4","v":35688.007394476168}]
[3,"اية","سليمان","أنثى","1938-04-28",12,"مندوب","تسويق",7500,95,"1995","1/1/1995",24,null,null,null,{"$f":"Sal_Comul!AX5","v":29029.797059685843}]
[4,"محمد","علواني","ذكر","1947-06-07",12,"أمين صندوق","مشتريات",7687.5,94,"1994","1/1/1994",25,null,null,null,{"$f":"Sal_Comul!AX6","v":32433.540764933994}]
[5,"رعد","المحمد","ذكر","1958-09-16",15,"عامل","انتاج",8700,94,"1994","1/1/1994",25,null,null,null,{"$f":"Sal_Comul!AX7","v":36705.275402266765}]
[6,"آمنة","سعدات","أنثى","1962-01-23",16,"كاتب","مشتريات",8700,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX8","v":36705.275402266765}]
[7,"سمية","محمد","أنثى","1961-05-25",16,"مندوب","تسويق",12750,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX9","v":53792.213951597856}]
[8,"فاطمة","الكحيل","أنثى","1968-03-12",12,"عامل","انتاج",6075,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX10","v":25630.407823996622}]
[9,"جمال","عثمان","ذكر","1962-02-10",19,"مدير","مشتريات",18125,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX11","v":83351.562892647431}]
[10,"سامر","علواني","ذكر","1961-06-24",19,"مدير","تسويق",17187.5,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX12","v":79040.275156820877}]
[11,"عائشة","الطويل","أنثى","1938-02-27",8,"عامل","انتاج",4050,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX13","v":18624.763018770882}]
[12,"ماجد","درغام","ذكر","1948-06-21",12,"أمين صندوق","تسويق",7687.5,91,"1991","1/1/1991",28,null,null,null,{"$f":"Sal_Comul!AX14","v":35352.559433778057}]
[13,"ثائر","المحمد","ذكر","1959-10-06",16,"مدير","تسويق",13718.75,90,"1990","1/1/1990",29,null,null,null,{"$f":"Sal_Comul!AX15","v":68766.476482346116}]
[14,"سامي","الفارابي","ذكر","1961-08-25",14,"عامل","انتاج",9450,90,"1990","1/1/1990",29,null,null,null,{"$f":"Sal_Comul!AX16","v":47368.98061107393}]
[15,"سميرة","المحجوب","أنثى","1964-09-20",12,"مندوب","تسويق",6937.5,87,"1987","1/1/1987",32,null,null,null,{"$f":"Sal_Comul!AX17","v":37904.583096123242}]
[16,"فاطمة","خالد","أنثى","1951-01-13",16,"مندوب","تسويق",6262.5,87,"1987","1/1/1987",32,null,null,null,{"$f":"Sal_Comul!AX18","v":34216.569605689634}]
[17,"دانة","سليمان","أنثى","1968-08-18",16,"مدير","تسويق",16500,86,"1986","1/1/1986",33,null,null,null,{"$f":"Sal_Comul!AX19","v":98265.070556220075}]
[18,"باسمة","قدري","أنثى","1940-08-21",12,"كاتب","مشتريات",4312.5,82,"1982","1/1/1982",37,null,null,null,{"$f":"Sal_Comul!AX20","v":30513.872699323147}]
[19,"اسماعيل","امجد","ذكر","1934-02-04",15,"مندوب","تسويق",5625,82,"1982","1/1/1982",37,null,null,null,{"$f":"Sal_Comul!AX21","v":39800.703520856274}]
[20,"محمد","عوض","ذكر","1965-01-09",16,"مدير","انتاج",10050,81,"1981","1/1/1981",38,null,null,null,{"$f":"Sal_Comul!AX22","v":71110.590290596519}]
[]
[20,"محمد","عوض","ذكر",23751,16,"مدير","انتاج",10050,81,"1981","1/1/1981",{"$f":"IF(AND($B24<>\"\",$C24<>\"\"),DATEDIF($C24,TODAY(),\"y\"),\"\")","v":{"$error":"#VALUE!"}}]

{"sheet":"Sheet16","index":3,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of الراتب الحالي"]
["احمد صباغ",50602.398544406497]
["ذكر",50602.398544406497]
["اسماعيل امجد",39800.703520856274]
["ذكر",39800.703520856274]
["آمنة سعدات",36705.275402266765]
["أنثى",36705.275402266765]
["اية سليمان",29029.797059685843]
["أنثى",29029.797059685843]
["باسمة قدري",30513.872699323147]
["أنثى",30513.872699323147]
["ثائر المحمد",68766.476482346116]
["ذكر",68766.476482346116]
["جمال عثمان",83351.562892647431]
["ذكر",83351.562892647431]
["خديجة خالد",34216.569605689634]
["أنثى",34216.569605689634]
["دانة سليمان",98265.070556220075]
["أنثى",98265.070556220075]
["رعد المحمد",36705.275402266765]
["ذكر",36705.275402266765]
["سامر المصري",35688.007394476168]
["ذكر",35688.007394476168]
["سامر علواني",79040.275156820877]
["ذكر",79040.275156820877]
["سامي الفارابي",47368.98061107393]
["ذكر",47368.98061107393]
["سمية محمد",53792.213951597856]
["أنثى",53792.213951597856]
["سميرة المحجوب",37904.583096123242]
["أنثى",37904.583096123242]
["عائشة الطويل",18624.763018770882]
["أنثى",18624.763018770882]
["فاطمة الكحيل",25630.407823996622]
["أنثى",25630.407823996622]
["ماجد درغام",35352.559433778057]
["ذكر",35352.559433778057]
["محمد علواني",32433.540764933994]
["ذكر",32433.540764933994]
["محمد عوض",71110.590290596519]
["ذكر",71110.590290596519]
["Grand Total",944902.92370787647]

{"sheet":"Q6","index":4,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"M3/2","v":12}]
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد","سنوات الدراسة","الوظيفه","مجال الوظيفه","الراتب عند التعيين","سنة التعيين",null,"سنة التعيين","سنوات الخدمة","علاوة الترفيع 9% كل عامين",null,null,"الراتب الحالي",null,"الاسم","الاسم","الجنس","الراتب الحالي"]
[3,"اية","سليمان","أنثى","1938-04-28",12,"مندوب","تسويق",7500,95,"1995","1/1/1995",{"$f":"YEAR(TODAY())-(YEAR(L3))","v":24},null,null,null,{"$f":"Sal_Comul!AX5","v":29029.797059685843},null,"اية سليمان",{"$f":"B3&\" \"&C3","v":"اية سليمان"},"أنثى",29029.797059685843]
[6,"آمنة","سعدات","أنثى","1962-01-23",16,"كاتب","مشتريات",8700,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX8","v":36705.275402266765},null,"آمنة سعدات",{"$f":"B4&\" \"&C4","v":"آمنة سعدات"},"أنثى",36705.275402266765]
[7,"سمية","محمد","أنثى","1961-05-25",16,"مندوب","تسويق",12750,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX9","v":53792.213951597856},null,"سمية محمد","سمية محمد","أنثى",53792.213951597856]
[8,"فاطمة","الكحيل","أنثى","1968-03-12",12,"عامل","انتاج",6075,93,"1993","1/1/1993",26,null,null,null,{"$f":"Sal_Comul!AX10","v":25630.407823996622},null,"فاطمة الكحيل","فاطمة الكحيل","أنثى",25630.407823996622]
[11,"عائشة","الطويل","أنثى","1938-02-27",8,"عامل","انتاج",4050,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX13","v":18624.763018770882},null,"عائشة الطويل","عائشة الطويل","أنثى",18624.763018770882]
[15,"سميرة","المحجوب","أنثى","1964-09-20",12,"مندوب","تسويق",6937.5,87,"1987","1/1/1987",32,null,null,null,{"$f":"Sal_Comul!AX17","v":37904.583096123242},null,"سميرة المحجوب","سميرة المحجوب","أنثى",37904.583096123242]
[16,"خديجة","خالد","أنثى","1951-01-13",16,"مندوب","تسويق",6262.5,87,"1987","1/1/1987",32,null,null,null,{"$f":"Sal_Comul!AX18","v":34216.569605689634},null,"خديجة خالد","خديجة خالد","أنثى",34216.569605689634]
[17,"دانة","سليمان","أنثى","1968-08-18",16,"مدير","تسويق",16500,86,"1986","1/1/1986",33,null,null,null,{"$f":"Sal_Comul!AX19","v":98265.070556220075},null,"دانة سليمان","دانة سليمان","أنثى",98265.070556220075]
[18,"باسمة","قدري","أنثى","1940-08-21",12,"كاتب","مشتريات",4312.5,82,"1982","1/1/1982",37,null,null,null,{"$f":"Sal_Comul!AX20","v":30513.872699323147},null,"باسمة قدري","باسمة قدري","أنثى",30513.872699323147]
[1,"احمد","صباغ","ذكر","1952-02-03",15,"مدير","انتاج",14250,98,"1998","1/1/1995",24,{"$f":"(0.09*I12)","v":1282.5},{"$f":"N12*(0.5*M12)","v":15390},{"$f":"I12+(I12*EFFECT(EFFECT(0.09,0.5)*(M10),(M10)))","v":{"$error":"#NUM!"}},{"$f":"Sal_Comul!AX3","v":50602.398544406497},null,"احمد صباغ","احمد صباغ","ذكر",50602.398544406497]
[2,"سامر","المصري","ذكر","1958-05-23",16,"مندوب","تسويق",10050,98,"1998","1/1/1998",21,null,null,null,{"$f":"Sal_Comul!AX4","v":35688.007394476168},null,"سامر المصري","سامر المصري","ذكر",35688.007394476168]
[4,"محمد","علواني","ذكر","1947-06-07",12,"أمين صندوق","مشتريات",7687.5,94,"1994","1/1/1994",25,null,null,null,{"$f":"Sal_Comul!AX6","v":32433.540764933994},null,"محمد علواني","محمد علواني","ذكر",32433.540764933994]
[5,"رعد","المحمد","ذكر","1958-09-16",15,"عامل","انتاج",8700,94,"1994","1/1/1994",25,null,null,null,{"$f":"Sal_Comul!AX7","v":36705.275402266765},null,"رعد المحمد","رعد المحمد","ذكر",36705.275402266765]
[9,"جمال","عثمان","ذكر","1962-02-10",19,"مدير","مشتريات",18125,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX11","v":83351.562892647431},null,"جمال عثمان","جمال عثمان","ذكر",83351.562892647431]
[10,"سامر","علواني","ذكر","1961-06-24",19,"مدير","تسويق",17187.5,92,"1992","1/1/1992",27,null,null,null,{"$f":"Sal_Comul!AX12","v":79040.275156820877},null,"سامر علواني","سامر علواني","ذكر",79040.275156820877]
[12,"ماجد","درغام","ذكر","1948-06-21",12,"أمين صندوق","تسويق",7687.5,91,"1991","1/1/1991",28,null,null,null,{"$f":"Sal_Comul!AX14","v":35352.559433778057},null,"ماجد درغام","ماجد درغام","ذكر",35352.559433778057]
[13,"ثائر","المحمد","ذكر","1959-10-06",16,"مدير","تسويق",13718.75,90,"1990","1/1/1990",29,null,null,null,{"$f":"Sal_Comul!AX15","v":68766.476482346116},null,"ثائر المحمد","ثائر المحمد","ذكر",68766.476482346116]
[14,"سامي","الفارابي","ذكر","1961-08-25",14,"عامل","انتاج",9450,90,"1990","1/1/1990",29,null,null,null,{"$f":"Sal_Comul!AX16","v":47368.98061107393},null,"سامي الفارابي","سامي الفارابي","ذكر",47368.98061107393]
[19,"اسماعيل","امجد","ذكر","1934-02-04",15,"مندوب","تسويق",5625,82,"1982","1/1/1982",37,null,null,null,{"$f":"Sal_Comul!AX21","v":39800.703520856274},null,"اسماعيل امجد","اسماعيل امجد","ذكر",39800.703520856274]
[20,"محمد","عوض","ذكر","1965-01-09",16,"مدير","انتاج",10050,81,"1981","1/1/1981",38,null,null,null,{"$f":"Sal_Comul!AX22","v":71110.590290596519},null,"محمد عوض","محمد عوض","ذكر",71110.590290596519]
[]
[20,"محمد","عوض","ذكر",23751,16,"مدير","انتاج",10050,81,"1981","1/1/1981",{"$f":"IF(AND($B24<>\"\",$C24<>\"\"),DATEDIF($C24,TODAY(),\"y\"),\"\")","v":{"$error":"#VALUE!"}}]

{"sheet":"Q1","index":5,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,{"$f":"K3/2","v":10.5}]
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد","سنوات الدراسة","الوظيفه","مجال الوظيفه","الراتب عند التعيين","سنة التعيين","سنوات الخدمة",null,null,"علاوة الترفيع 9% كل عامين"]
[1,"احمد","صباغ","ذكر","1952-02-03",15,"مدير","انتاج",14250,"1/1/1998",{"$f":"YEAR(TODAY())-(YEAR(J3))","v":21},{"$f":"K3/2","v":10.5},{"$f":"ROUNDDOWN(L3,0)","v":10},{"$f":"Yearly_Rate(I3,0.09,M3)","v":33734.932362937696},{"$f":"N3*(0.5*K3)","v":354216.7898108458},{"$f":"I3+(I3*EFFECT(EFFECT(0.09,0.5)*(K1),(K1)))","v":{"$error":"#NUM!"}}]
[2,"سامر","المصري","ذكر","1958-05-23",16,"مندوب","تسويق",10050,"1/1/1998",{"$f":"YEAR(TODAY())-(YEAR(J4))","v":21},{"$f":"K4/2","v":10.5},{"$f":"ROUNDDOWN(L4,0)","v":10},{"$f":"Yearly_Rate(I4,0.09,M4)","v":23792.004929650797}]
[3,"اية","سليمان","أنثى","1938-04-28",12,"مندوب","تسويق",7500,"1/1/1995",24,12,12,21094.985863371727]
[4,"محمد","علواني","ذكر","1947-06-07",12,"أمين صندوق","مشتريات",7687.5,"1/1/1994",25,12.5,12,21622.360509956019]
[5,"رعد","المحمد","ذكر","1958-09-16",15,"عامل","انتاج",8700,"1/1/1994",25,12.5,12,24470.183601511202]
[6,"آمنة","سعدات","أنثى","1962-01-23",16,"كاتب","مشتريات",8700,"1/1/1993",26,13,13,26672.500125647213]
[7,"سمية","محمد","أنثى","1961-05-25",16,"مندوب","تسويق",12750,"1/1/1993",26,13,13,39089.008804827812]
[8,"فاطمة","الكحيل","أنثى","1968-03-12",12,"عامل","انتاج",6075,"1/1/1993",26,13,13,18624.7630187709]
[9,"جمال","عثمان","ذكر","1962-02-10",19,"مدير","مشتريات",18125,"1/1/1992",27,13.5,13,55567.70859509836]
[10,"سامر","علواني","ذكر","1961-06-24",19,"مدير","تسويق",17187.5,"1/1/1992",27,13.5,13,52693.516771213959]
[11,"عائشة","الطويل","أنثى","1938-02-27",8,"عامل","انتاج",4050,"1/1/1992",27,13.5,13,12416.508679180599]
[12,"ماجد","درغام","ذكر","1948-06-21",12,"أمين صندوق","تسويق",7687.5,"1/1/1991",28,14,14,25689.526521878754]
[13,"ثائر","المحمد","ذكر","1959-10-06",16,"مدير","تسويق",13718.75,"1/1/1990",29,14.5,14,45844.317654897452]
[14,"سامي","الفارابي","ذكر","1961-08-25",14,"عامل","انتاج",9450,"1/1/1990",29,14.5,14,31579.32040738266]
[15,"سميرة","المحجوب","أنثى","1964-09-20",12,"مندوب","تسويق",6937.5,"1/1/1987",32,16,16,27543.9970498496]
[16,"فاطمة","خالد","أنثى","1951-01-13",16,"مندوب","تسويق",6262.5,"1/1/1987",32,16,16,24864.040580134504]
[17,"دانة","سليمان","أنثى","1968-08-18",16,"مدير","تسويق",16500,"1/1/1986",33,16.5,16,65510.04703748013]
[18,"باسمة","قدري","أنثى","1940-08-21",12,"كاتب","مشتريات",4312.5,"1/1/1982",37,18.5,18,20342.581799548789]
[19,"اسماعيل","امجد","ذكر","1934-02-04",15,"مندوب","تسويق",5625,"1/1/1982",37,18.5,18,26533.802347237553]
[20,"محمد","عوض","ذكر","1965-01-09",16,"مدير","انتاج",10050,"1/1/1981",38,19,19,51673.695611166891]
[]
[20,"محمد","عوض","ذكر",23751,16,"مدير","انتاج",10050,81,{"$f":"IF(AND($B24<>\"\",$C24<>\"\"),DATEDIF($C24,TODAY(),\"y\"),\"\")","v":{"$error":"#VALUE!"}}]

{"sheet":"AgeYR","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,6,0,7]]}
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد",null,"Age By Years",null,"Exact Age (Y-M-D)"]
[1,"احمد","صباغ","ذكر","1952-02-03",{"$f":"NOW()","v":"2019-06-24T12:35:48.580"},{"$f":"INT((F2-E2)/365)","v":67},{"$f":"DATEDIF(E2,NOW(),\"y\")","v":67},{"$f":"DATEDIF(E2,TODAY(),\"Y\") & \" Years, \" & DATEDIF(E2,TODAY(),\"YM\") & \" Months, \" & DATEDIF(E2,TODAY(),\"MD\") & \" Days\"","v":"67 Years, 4 Months, 21 Days"}]
[2,"سامر","المصري","ذكر","1958-05-23",{"$f":"NOW()","v":"2019-06-24T12:35:48.580"},{"$f":"INT((F3-E3)/365)","v":61},{"$f":"DATEDIF(E3,NOW(),\"y\")","v":61},{"$f":"DATEDIF(E3,TODAY(),\"Y\") & \" Years, \" & DATEDIF(E3,TODAY(),\"YM\") & \" Months, \" & DATEDIF(E3,TODAY(),\"MD\") & \" Days\"","v":"61 Years, 1 Months, 1 Days"}]
[3,"اية","سليمان","أنثى","1938-04-28","2019-06-24T12:35:48.580",81,81,"81 Years, 1 Months, 27 Days"]
[4,"محمد","علواني","ذكر","1947-06-07","2019-06-24T12:35:48.580",72,72,"72 Years, 0 Months, 17 Days"]
[5,"رعد","المحمد","ذكر","1958-09-16","2019-06-24T12:35:48.580",60,60,"60 Years, 9 Months, 8 Days"]
[6,"آمنة","سعدات","أنثى","1962-01-23","2019-06-24T12:35:48.580",57,57,"57 Years, 5 Months, 1 Days"]
[7,"سمية","محمد","أنثى","1961-05-25","2019-06-24T12:35:48.580",58,58,"58 Years, 0 Months, 30 Days"]
[8,"فاطمة","الكحيل","أنثى","1968-03-12","2019-06-24T12:35:48.580",51,51,"51 Years, 3 Months, 12 Days"]
[9,"جمال","عثمان","ذكر","1962-02-10","2019-06-24T12:35:48.580",57,57,"57 Years, 4 Months, 14 Days"]
[10,"سامر","علواني","ذكر","1961-06-24","2019-06-24T12:35:48.580",58,58,"58 Years, 0 Months, 0 Days"]
[11,"عائشة","الطويل","أنثى","1938-02-27","2019-06-24T12:35:48.580",81,81,"81 Years, 3 Months, 28 Days"]
[12,"ماجد","درغام","ذكر","1948-06-21","2019-06-24T12:35:48.580",71,71,"71 Years, 0 Months, 3 Days"]
[13,"ثائر","المحمد","ذكر","1959-10-06","2019-06-24T12:35:48.580",59,59,"59 Years, 8 Months, 18 Days"]
[14,"سامي","الفارابي","ذكر","1961-08-25","2019-06-24T12:35:48.580",57,57,"57 Years, 9 Months, 30 Days"]
[15,"سميرة","المحجوب","أنثى","1964-09-20","2019-06-24T12:35:48.580",54,54,"54 Years, 9 Months, 4 Days"]
[16,"فاطمة","خالد","أنثى","1951-01-13","2019-06-24T12:35:48.580",68,68,"68 Years, 5 Months, 11 Days"]
[17,"دانة","سليمان","أنثى","1968-08-18","2019-06-24T12:35:48.580",50,50,"50 Years, 10 Months, 6 Days"]
[18,"باسمة","قدري","أنثى","1940-08-21","2019-06-24T12:35:48.580",78,78,"78 Years, 10 Months, 3 Days"]
[19,"اسماعيل","امجد","ذكر","1934-02-04","2019-06-24T12:35:48.580",85,85,"85 Years, 4 Months, 20 Days"]
[20,"محمد","عوض","ذكر","1965-01-09","2019-06-24T12:35:48.580",54,54,"54 Years, 5 Months, 15 Days"]

{"sheet":"MandF","index":7,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["التسلسل","الاسم","الكنية","الجنس"]
[1,"احمد","صباغ","ذكر"]
[2,"سامر","المصري","ذكر"]
[3,"اية","سليمان","أنثى",null,"عدد الذكور",{"$f":"COUNTIF($D$2:$D$21,\"ذكر\")","v":11},null,{"$f":"COUNTIF($D$2:$D$21,\"ذكر\")","v":11}]
[4,"محمد","علواني","ذكر",null,"عدد الاناث",{"$f":"COUNTIF($D$2:$D$21,\"أنثى\")","v":9}]
[5,"رعد","المحمد","ذكر"]
[6,"آمنة","سعدات","أنثى",null,"العدد الكلي",{"$f":"SUM(G4:G5)","v":20},{"$f":"G7=A21","v":true}]
[7,"سمية","محمد","أنثى"]
[8,"فاطمة","الكحيل","أنثى"]
[9,"جمال","عثمان","ذكر"]
[10,"سامر","علواني","ذكر"]
[11,"عائشة","الطويل","أنثى"]
[12,"ماجد","درغام","ذكر"]
[13,"ثائر","المحمد","ذكر"]
[14,"سامي","الفارابي","ذكر"]
[15,"سميرة","المحجوب","أنثى"]
[16,"فاطمة","خالد","أنثى"]
[17,"دانة","سليمان","أنثى"]
[18,"باسمة","قدري","أنثى"]
[19,"اسماعيل","امجد","ذكر"]
[20,"محمد","عوض","ذكر"]

{"sheet":"Sum_SAL_M","index":8,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[[16,13,16,15],[25,10,25,12],[23,8,24,8],[5,13,5,15],[6,13,6,15],[9,13,9,15],[10,13,10,15],[14,13,15,15],[13,13,13,15]]}
[]
["التسلسل","الاسم","الكنية","الجنس","تاريخ الميلاد","سنوات الدراسة","الوظيفه","مجال الوظيفه","الراتب عند التعيين","سنة التعيين"]
[1,"احمد","صباغ","ذكر","1952-02-03",15,"مدير","انتاج",14250,"1/1/1995"]
[2,"سامر","المصري","ذكر","1958-05-23",16,"مندوب","تسويق",10050,"1/1/1998"]
[3,"اية","سليمان","أنثى","1938-04-28",12,"مندوب","تسويق",7500,"1/1/1995"]
[4,"محمد","علواني","ذكر","1947-06-07",12,"أمين صندوق","مشتريات",7687.5,"1/1/1994",null,null,null,"مجموع الراتب الذكور عند اول تعيين"]
[5,"رعد","المحمد","ذكر","1958-09-16",15,"عامل","انتاج",8700,"1/1/1994",null,null,null,{"$f":"SUMIF(D3:D22,\"ذكر\",I3:I22)","v":122531.25}]
[6,"آمنة","سعدات","أنثى","1962-01-23",16,"كاتب","مشتريات",8700,"1/1/1993"]
[7,"سمية","محمد","أنثى","1961-05-25",16,"مندوب","تسويق",12750,"1/1/1993"]
[8,"فاطمة","الكحيل","أنثى","1968-03-12",12,"عامل","انتاج",6075,"1/1/1993",null,null,null,"مجموع الراتب الإناث عند اول تعيين"]
[9,"جمال","عثمان","ذكر","1962-02-10",19,"مدير","مشتريات",18125,"1/1/1992",null,null,null,{"$f":"SUMIF(D3:D22,\"أنثى\",I3:I22)","v":73087.5}]
[10,"سامر","علواني","ذكر","1961-06-24",19,"مدير","تسويق",17187.5,"1/1/1992"]
[11,"عائشة","الطويل","أنثى","1938-02-27",8,"عامل","انتاج",4050,"1/1/1992"]
[12,"ماجد","درغام","ذكر","1948-06-21",12,"أمين صندوق","تسويق",7687.5,"1/1/1991",null,null,null,"الراتب الكلي عند اول تعيين"]
[13,"ثائر","المحمد","ذكر","1959-10-06",16,"مدير","تسويق",13718.75,"1/1/1990",null,null,null,{"$f":"N11+N7","v":195618.75}]
[14,"سامي","الفارابي","ذكر","1961-08-25",14,"عامل","انتاج",9450,"1/1/1990"]
[15,"سميرة","المحجوب","أنثى","1964-09-20",12,"مندوب","تسويق",6937.5,"1/1/1987",null,null,null,{"$f":"N15=I24","v":true}]
[16,"فاطمة","خالد","أنثى","1951-01-13",16,"مندوب","تسويق",6262.5,"1/1/1987"]
[17,"دانة","سليمان","أنثى","1968-08-18",16,"مدير","تسويق",16500,"1/1/1986"]
[18,"باسمة","قدري","أنثى","1940-08-21",12,"كاتب","مشتريات",4312.5,"1/1/1982"]
[19,"اسماعيل","امجد","ذكر","1934-02-04",15,"مندوب","تسويق",5625,"1/1/1982"]
[20,"محمد","عوض","ذكر","1965-01-09",16,"مدير","انتاج",10050,"1/1/1981"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I3:I22)","v":195618.75}]
[]
[20,"محمد","عوض","ذكر",23751,16,"مدير","انتاج",10050,81,"For Test "]

{"sheet":"tst1","index":9,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":true,"merged":[[14,5,16,10],[0,11,2,19],[4,1,4,2],[6,5,11,12],[5,11,5,12],[12,5,12,12],[4,14,18,19]]}
[1000,"invest",null,1000,{"$f":"D1*(1+0.08)^3","v":1259.7120000000002},null,null,null,null,null,null,"Suppose you have $1,000.00 in an investment account. The account pays 8 percent interest and this interest is compounded annually. How much will the investment be worth at the end of three years? There are two ways to find the amount: \nUse a Fixed Formula\nCreate a Function Macro to Determine Compound Interest"]
[0.08,"intrest"]
[3,"pri",null,1000,{"$f":"D3+(D3*0.08)","v":1080},1000,{"$f":"E3+(E3*0.08)","v":1166.4000000000001},1000,{"$f":"G3+(G3*0.08)","v":1259.712}]
[]
[null,{"$f":"Yearly_Rate(A1,A2,A3)","v":1259.7120000000002},null,null,null,null,null,null,null,null,null,null,null,null," Cell     Value\n       --------------\n       A1     1000.00\n       A2         .08\n       A3        3.00\n These values represent the following:\nA1: Present value of the investment\nA2: Interest rate\nA3: Number of investment periods\nIn any blank cell, type the following formula\n=Yearly_Rate(A1,A2,A3)"]
[null,null,null,null,null,null,null,null,null,null,null,"Module"]
[null,null,null,null,null,"Function Yearly_Rate(PV As Double, R As Double, N As Double) As Double\n \n    Yearly_Rate = PV * (1 + R) ^ N 'Performs computation\n \nEnd Function\n"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"https://support.microsoft.com/sr-latn-me/help/141695/xl-how-to-calculate-compound-interest"]
[]
[null,null,null,null,null,"PV is present value, R is the interest rate, and N is the number of investment periods."]