{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAB LOSS SHEET","BASIC PAY SHEET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"SAB LOSS SHEET","index":0,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,0,29,10],[31,1,32,11],[31,0,32,0],[0,0,0,11],[2,0,2,3],[4,0,4,17],[27,0,27,10],[28,0,28,10],[1,0,1,3]]}
["SAB LOSS CALCULATION SHEET FOR BSNL JTO / JE"]
["ENTER YOUR CADER WHILE JOINING IN BSNL (JTO/JAO/JE)",null,null,null,"JAO"]
["ENTER YOUR YEAR OF JOINING IN BSNL ",null,null,null,2008]
[]
["YEAR WISE SAB LOSS"]
["YEAR","BASIC PAY AMT","DA IN PERCENTAGE %","DA AMT","ACTUAL SAB % RECEIVED ","MONTHLY SAB AMOUNT RECEIVED","YEARLY SAB AMOUNT RECEIVED","ACCUMULATED SAB AMOUNT FROM DATE OF JOINING","BALANCE SAB % TO BE RECEIVED ","MONTHLY SAB AMOUNT LOSS","YEARLY SAB AMOUNT LOSS","CUMULATIVE SAB AMT LOSS","PRESENT YEAR INTEREST LOSS","ACCUMULATED LOSSES FROM DATE OF JOINING","YEARLY SAB AMOUNT LOSS FROM 01-01-2007","CUMULATIVE SAB AMT LOSS FROM 01-01-2007","PRESENT YEAR INTEREST LOSS FROM 01-01-2007","ACCUMULATED LOSSES FROM 01-01-2007"]
[2002,0,41,{"$f":"($B7*$C7)/100","v":0},16.8,{"$f":"($B7+$D7)*$E7/100","v":0},{"$f":"$F7*12","v":0},{"$f":"G7","v":0},{"$f":"30-E7","v":13.2},{"$f":"($B7+$D7)*$I7/100","v":0},{"$f":"$J7*12","v":0},{"$f":"$K7","v":0},{"$f":"0","v":0},{"$f":"$K7","v":0}]
[2003,0,43,{"$f":"($B8*$C8)/100","v":0},16.8,{"$f":"($B8+$D8)*$E8/100","v":0},{"$f":"$F8*12","v":0},{"$f":"$G8+$H7+($H7*8.5/100)","v":0},{"$f":"30-E8","v":13.2},{"$f":"($B8+$D8)*$I8/100","v":0},{"$f":"$J8*12","v":0},{"$f":"$K8+$N7","v":0},{"$f":"$N7*8.5/100","v":0},{"$f":"($K8+$N7)+$N7*8.5/100","v":0}]
[2004,0,45,0,16.8,{"$f":"($B9+$D9)*$E9/100","v":0},0,{"$f":"$G9+$H8+($H8*8.5/100)","v":0},13.2,0,0,0,0,0]
[2005,0,52,0,16.8,0,0,0,13.2,0,0,0,0,0]
[2006,0,60,0,16.8,0,0,0,13.2,0,0,0,0,0]
[2007,0,0,0,16.8,0,0,0,13.2,0,0,0,0,0,{"$f":"K12","v":0},{"$f":"$O12","v":0},{"$f":"0","v":0},{"$f":"O12","v":0}]
[2008,22820,5.8,1323.56,16.8,4056.1180800000002,48673.416960000002,48673.416960000002,13.2,3186.9499200000005,38243.399040000004,38243.399040000004,0,38243.399040000004,{"$f":"K13","v":38243.399040000004},{"$f":"$O13+$R12","v":38243.399040000004},{"$f":"R12*8.5/100","v":0},{"$f":"(O13+R12)+R12*8.5/100","v":38243.399040000004}]
[2009,23510,18.5,4349.3500000000004,16.8,4680.3708000000006,56164.449600000007,108975.10700160002,13.2,3677.4341999999997,44129.210399999996,82372.60944,3250.6889184000006,85623.298358400003,{"$f":"K14","v":44129.210399999996},{"$f":"$O14+$R13","v":82372.60944},{"$f":"R13*8.5/100","v":3250.6889184000006},85623.298358400003]
[2010,24220,35,8477,16.8,5493.0959999999995,65917.152000000002,184155.14309673602,13.2,4316.0039999999999,51792.047999999995,137415.34635840001,7277.9803604640001,144693.326718864,51792.047999999995,137415.34635840001,7277.9803604640001,144693.326718864]
[2011,24950,45,11227.5,16.8,6077.82,72933.84,272742.1702599586,13.2,4775.43,57305.16,201998.48671886401,12298.93277110344,214297.41948996743,57305.16,201998.48671886401,12298.93277110344,214297.41948996743]
[2012,26470,56.7,15008.49,16.8,6968.3863199999996,83620.635840000003,379545.89057205507,13.2,5475.16068,65701.928159999996,279999.34764996741,18215.280656647232,298214.62830661464,65701.928159999996,279999.34764996741,18215.280656647232,298214.62830661464]
[2013,27270,78.900000000000006,21516.03,16.8,8196.0530400000007,98352.636480000016,510159.92775067978,13.2,6439.7559599999986,77277.071519999983,375491.69982661464,25348.243406062244,400839.94323267689,77277.071519999983,375491.69982661464,25348.243406062244,400839.94323267689]
[2014,28090,91.3,25646.17,16.8,{"$f":"($B19+$D19)*$E19/100","v":9027.6765599999999},108332.11872,661855.64032948762,13.2,7093.1744399999989,85118.093279999986,485958.03651267686,34071.395174777535,520029.4316874544,85118.093279999986,485958.03651267686,34071.395174777535,520029.4316874544]
[2015,28940,102.6,29692.44,16.8,{"$f":"($B20+$D20)*$E20/100","v":9850.2499200000002},118202.99904,836316.3687974941,13.2,7739.4820799999998,92873.78495999999,612903.21664745442,44202.501693433624,657105.71834088804,92873.78495999999,612903.21664745442,44202.501693433624,657105.71834088804]
[2016,29810,115,34281.5,19.8,{"$f":"($B21+$D21)*$E21/100","v":12690.117},152281.40400000001,1059684.6641452811,11.2,7178.2479999999996,86138.975999999995,743244.69434088806,55853.986058975483,799098.68039986352,86138.975999999995,743244.69434088806,55853.986058975483,799098.68039986352]
[2017,31630,112.4,35552.120000000003,21.8,{"$f":"($B22+$D22)*$E22/100","v":14645.702160000001},175748.42592000001,{"$f":"$G22+$H21+($H21*8.5/100)","v":1325506.2865176301},8.1999999999999993,5508.9338399999997,66107.206080000004,865205.88647986355,67923.387833988396,933129.27431385196,66107.206080000004,865205.88647986355,67923.387833988396,933129.27431385196]
[2018,32580,122.5,39910.5,21.8,{"$f":"($B23+$D23)*$E23/100","v":15802.929000000002},189635.14800000002,1627809.4688716286,8.1999999999999993,5944.2209999999995,71330.652000000002,1004459.926313852,79315.988316677423,1083775.9146305295,71330.652000000002,1004459.926313852,79315.988316677423,1083775.9146305295]
[2019,33560,147.82,49608.392,21.8,{"$f":"($B24+$D24)*$E24/100","v":18130.709456000001},217568.51347200002,1983741.787197717,8.1999999999999993,6819.8081439999987,81837.697727999985,1165613.6123585294,92120.952743595,1257734.5651021244,81837.697727999985,1165613.6123585294,92120.952743595,1257734.5651021244]
[2020,34570,160.69999999999999,55553.99,21.8,19647.02982,235764.35784000001,2388124.1969495229,8.1999999999999993,7390.1671799999986,88682.00615999999,1346416.5712621245,106907.43803368056,1453324.0092958051,88682.00615999999,1346416.5712621245,106907.43803368056,1453324.0092958051]
[]
[]
["ELIGIBLE TOTAL SAB AMOUNT WITH 30% SAB FROM DATE OF JOINING **",null,null,null,null,null,null,null,null,null,null,{"$f":"H25+N25","v":3841448.2062453283},"LOSSES",{"$f":"L28-L30","v":1453324.0092958054}]
["ELIGIBLE TOTAL SAB AMOUNT WITH 30% SAB FROM DATE OF JOINING (W.E.F 2ND PRC i.e 01-01-2007) **",null,null,null,null,null,null,null,null,null,null,{"$f":"H25+R25","v":3841448.2062453283},"LOSSES",{"$f":"L29-L30","v":1453324.0092958054}]
["ACTUAL ACCUMULATED SAB AMOUNT FROM DATE OF JOINING WITH REDUCED SAB  **",null,null,null,null,null,null,null,null,null,null,{"$f":"H25","v":2388124.1969495229}]
[]
["NOTE  **","ABOVE CALCULATIONS ARE INDICATIVE ONLY AS APPROXIMATIONS DONE LIKE PAY INCREASE HAPPENS FROM JAN OF EACH YEAR, INCREMENT INCREASE DUE TO REGULAR PROMOTION NOT INCLUDED AND SAB INCREASE TAKEN FOR ENTIRE YEAR INSTEAD OF FROM ACTUAL DATE OF IMPLEMENTATION"]

{"sheet":"BASIC PAY SHEET","index":1,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["YEAR","BP FOR JTO/JAO JTO/JAO YOJ 2002","BP FOR JTO/JAO JTO/JAO YOJ 2003","BP FOR JTO/JAO YOJ 2004","BP FOR JTO/JAO YOJ 2005","BP FOR JTO/JAO YOJ 2006","BP FOR JTO/JAO YOJ 2007","BP FOR JTO/JAO YOJ 2008","BP FOR JTO/JAO YOJ 2009","BP FOR JTO/JAO YOJ 2010","BP FOR JTO/JAO YOJ 2011","BP FOR JTO/JAO YOJ 2012","BP FOR JTO/JAO YOJ 2013","BP FOR JTO/JAO YOJ 2014","BP FOR JTO/JAO YOJ 2015","BP FOR JTO/JAO YOJ 2016","BP FOR JTO/JAO YOJ 2017","BP FOR JTO/JAO YOJ 2018","BP FOR JTO/JAO YOJ 2019","BP FOR JTO/JAO YOJ 2020",null,null,"YEAR","DA IN PERCENTAGE %"]
[2002,9850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2002,41]
[2003,10100,9850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2003,43]
[2004,10350,10100,9850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2004,45]
[2005,10600,10350,10100,9850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2005,52]
[2006,10850,10600,10350,10100,9850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2006,60]
[2007,25270,24589,23310,22750,22190,22820,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2007,0]
[2008,26040,25330,24730,23440,23550,23510,22820,0,0,0,0,0,0,0,0,0,0,0,0,null,null,2008,5.8]
[2009,26820,26090,25480,24870,24260,24220,23510,19020,0,0,0,0,0,0,0,0,0,0,0,null,null,2009,18.5]
[2010,27620,26880,26250,25620,25740,24950,24220,19600,16400,0,0,0,0,0,0,0,0,0,0,null,null,2010,35]
[2011,28450,27690,27040,26390,26520,26470,24950,20190,16900,16400,0,0,0,0,0,0,0,0,0,null,null,2011,45]
[2012,32765,29380,27860,27190,27320,27270,26470,20800,17410,16900,16400,0,0,0,0,0,0,0,0,null,null,2012,56.7]
[2013,33750,30270,29560,28010,28140,28090,27270,22070,17940,17410,16900,16400,0,0,0,0,0,0,0,null,null,2013,78.900000000000006]
[2014,34760,31180,30450,29720,28990,28940,28090,22740,19040,17940,17410,16900,16400,0,0,0,0,0,0,null,null,2014,91.3]
[2015,35810,32120,31370,30620,30760,29810,28940,23430,19620,19040,17940,17410,16900,16400,0,0,0,0,0,null,null,2015,102.6]
[2016,36890,33090,32320,31540,31690,31630,29810,24140,20210,19620,19040,17940,17410,16900,16400,0,0,0,0,null,null,2016,115]
[2017,39240,35110,33290,32490,32650,32580,31630,24870,20820,20210,19620,19040,17940,17410,16900,16400,0,0,0,null,null,2017,112.4]
[2018,40420,36170,35320,33470,33630,33560,32580,26390,21450,20820,20210,19620,19040,17940,17410,16900,16400,0,0,null,null,2018,122.5]
[2019,41640,37260,36380,35510,34640,34570,33560,27190,22760,21450,20820,20210,19620,19040,17940,17410,16900,16400,0,null,null,2019,147.82]
[2020,42890,38380,37480,36580,36750,35610,34570,28010,23450,22760,21450,20820,20210,19620,19040,17940,17410,16900,16400,null,null,2020,160.69999999999999]
[]
["YEAR","BP FOR JE JE YOJ 2002","BP FOR JE YOJ 2003","BP FOR JE YOJ 2004","BP FOR JE YOJ 2005","BP FOR JE YOJ 2006","BP FOR JE YOJ 2007","BP FOR JE YOJ 2008","BP FOR JE YOJ 2009","BP FOR JE YOJ 2010","BP FOR JE YOJ 2011","BP FOR JE YOJ 2012","BP FOR JE YOJ 2013","BP FOR JE YOJ 2014","BP FOR JE YOJ 2015","BP FOR JE YOJ 2016","BP FOR JE YOJ 2017","BP FOR JE YOJ 2018","BP FOR JE YOJ 2019","BP FOR JE YOJ 2020"]
[2002,7100]
[2003,7300,7100]
[2004,7500,7300,7100]
[2005,7700,7500,7300,7100]
[2006,7900,7700,7500,7300,7100]
[2007,18860,17840,17380,16920,16430,14010]
[2008,19430,18380,17910,17430,16930,14440,14010]
[2009,20630,18940,18450,17960,17440,14890,14440,14010]
[2010,21250,19510,19010,18500,17970,15340,14890,14440,14010]
[2011,21890,20710,19590,19060,18510,15810,15340,14890,14440,13600]
[2012,22550,21340,20790,19640,19070,16290,15810,15340,14890,14010,13600]
[2013,23230,21990,21420,20840,19650,16780,16290,15810,15340,14440,14010,13600]
[2014,24650,23330,22070,21470,20850,17290,16780,16290,15810,14890,14440,14010,13600]
[2015,25390,24030,22740,22120,21480,18350,17290,16780,16290,15340,14890,14440,14010,13600]
[2016,26160,24760,24140,22790,22130,18910,18350,17290,16780,15810,15340,14890,14440,14010,13600]
[2017,26950,25510,24870,24190,22800,19480,19480,18350,17290,16290,15810,15340,15340,14440,14010,13600]
[2018,27760,26280,25620,24920,23490,20070,20070,19480,18350,17290,16290,15810,15810,14890,14440,14010,13600]
[2019,28600,27070,26390,25670,24200,20680,20680,20070,18910,18350,17290,16290,16290,15340,14890,14440,14410,13600]
[2020,29460,27890,27190,26450,24930,21310,21310,20680,19480,18910,18350,17290,17290,15810,15340,14890,14440,14410,13600]