{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Sheet1","index":0,"n_rows":12,"n_cols":33,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,3,1,9]]}
[]
[null,null,null,"EMPLOYEE SALARY SHEET"]
[]
["S.NO","Employee Name",null,"Basic Pay","DA","Bonus","Special Pay","Gross Salary","EPF WAGES","EPS Wages","EPF","EPS","Difference","PF Admin","EDLI","EDLI Admin","Total Employer PF","Employee ESI","Employer ESI","GTI","Deductions","Net Taxable salary","Tax on salary","rebate","After Rebate","EC & SHEC","total tax payable","Monthly TDS","taX ","Cess","Net Salary","Monthly CTC","Annual CTC"]
[1,"P",null,5000,{"$f":"10%*D5","v":500},{"$f":"ROUND(1/3*(D5+E5),0)","v":1833},{"$f":"E5*2","v":1000},{"$f":"D5+E5+F5+G5","v":8333},{"$f":"D5+E5","v":5500},{"$f":"MIN(D5+E5,15000)","v":5500},{"$f":"12%*I5","v":660},{"$f":"ROUND(8.33%*J5,0)","v":458},{"$f":"K5-L5","v":202},{"$f":"ROUND(1.1%*(D5+E5),)","v":61},{"$f":"ROUND(0.5%*MIN(D5+E5,15000),0)","v":28},{"$f":"ROUND(0.01%*MIN(D5+E5,15000),0)","v":1},{"$f":"K5+M5","v":862},{"$f":"ROUND(1.75%*H5,0)","v":146},{"$f":"ROUND(4.75%*H5,0)","v":396},{"$f":"H5*12","v":99996},{"$f":"K5*12","v":7920},{"$f":"T5-U5","v":92076},{"$f":"IF(V5<=250000,0,IF(V5<=500000,10%*(V5-250000),IF(V5<=1000000,20%*(V5-500000)+25000,30%*(V5-1000000)+125000)))","v":0},{"$f":"IF(V5<=250000,0,IF(V5<=500000,2000,0))","v":0},{"$f":"W5-X5","v":0},{"$f":"Y5*3%","v":0},{"$f":"Z5+Y5","v":0},{"$f":"AA5/12","v":0},{"$f":"ROUND(AB5/103*100,)","v":0},{"$f":"AB5-AC5","v":0},{"$f":"H5-K5-R5","v":7527},{"$f":"H5+Q5+S5","v":9591},{"$f":"AF5*12","v":115092}]
[{"$f":"A5+1","v":2},"Q",null,100000,{"$f":"10%*D6","v":10000},{"$f":"ROUND(1/3*(D6+E6),0)","v":36667},{"$f":"E6*2","v":20000},{"$f":"D6+E6+F6+G6","v":166667},{"$f":"D6+E6","v":110000},{"$f":"MIN(D6+E6,15000)","v":15000},{"$f":"12%*I6","v":13200},{"$f":"ROUND(8.33%*J6,0)","v":1250},{"$f":"K6-L6","v":11950},{"$f":"ROUND(1.1%*(D6+E6),)","v":1210},{"$f":"ROUND(0.5%*MIN(D6+E6,15000),0)","v":75},{"$f":"ROUND(0.01%*MIN(D6+E6,15000),0)","v":2},{"$f":"K6+M6","v":25150},{"$f":"IF(H6>15000,0,1.75%*H6)","v":0},{"$f":"ROUND(IF(H6>15000,0,4.75%*H6),0)","v":0},{"$f":"H6*12","v":2000004},{"$f":"K6*12","v":158400},{"$f":"T6-U6","v":1841604},{"$f":"ROUND(IF(V6<=250000,0,IF(V6<=500000,10%*(V6-250000),IF(V6<=1000000,20%*(V6-500000)+25000,30%*(V6-1000000)+125000))),0)","v":377481},{"$f":"IF(V6<=250000,0,IF(V6<=500000,2000,0))","v":0},{"$f":"ROUND(W6-X6,0)","v":377481},{"$f":"ROUND(Y6*3%,0)","v":11324},{"$f":"B5:B10+[1]Sheet1!$B$3=Z6+Y6","v":{"$error":"#VALUE!"}},{"$f":"ROUND(AA6/12,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(AB6/103*100,)","v":{"$error":"#VALUE!"}},{"$f":"AB6-AC6","v":{"$error":"#VALUE!"}},{"$f":"H6-K6-R6","v":153467},{"$f":"H6+Q6+S6","v":191817},{"$f":"AF6*12","v":2301804}]
[{"$f":"A6+1","v":3},"R",null,40000,4000,14667,8000,66667,44000,15000,5280,1250,4030,484,75,2,9310,{"$f":"IF(H7>15000,0,1.75%*H7)","v":0},{"$f":"ROUND(IF(H7>15000,0,4.75%*H7),0)","v":0},800004,{"$f":"K7*12","v":63360},736644,{"$f":"ROUND(IF(V7<=250000,0,IF(V7<=500000,10%*(V7-250000),IF(V7<=1000000,20%*(V7-500000)+25000,30%*(V7-1000000)+125000))),0)","v":72329},0,{"$f":"ROUND(W7-X7,0)","v":72329},{"$f":"ROUND(Y7*3%,0)","v":2170},{"$f":"Z7+Y7","v":74499},{"$f":"ROUND(AA7/12,0)","v":6208},6027,181,61387,75977,911724]
[4,"S",null,3000,300,1100,600,5000,3300,3300,396,275,121,36,17,0,517,{"$f":"ROUND(IF(H8>15000,0,1.75%*H8),0)","v":88},238,60000,4752,55248,{"$f":"IF(V8<=250000,0,IF(V8<=500000,10%*(V8-250000),IF(V8<=1000000,20%*(V8-500000)+25000,30%*(V8-1000000)+125000)))","v":0},0,{"$f":"W8-X8","v":0},0,0,0,0,0,4516,5755,69060]
[5,"T",null,20000,2000,7333,4000,33333,22000,15000,2640,1250,1390,242,75,2,4030,0,0,399996,31680,368316,{"$f":"ROUND(IF(V9<=250000,0,IF(V9<=500000,10%*(V9-250000),IF(V9<=1000000,20%*(V9-500000)+25000,30%*(V9-1000000)+125000))),0)","v":11832},2000,9832,295,10127,844,819,25,30693,37363,448356]
[6,"U",null,6000,600,2200,1200,10000,6600,6600,792,550,242,73,33,1,1034,175.00000000000003,475,120000,9504,110496,0,0,0,{"$f":"Y10*3%","v":0},0,{"$f":"AA10/12","v":0},0,0,9033,11509,138108]
[]
[null,"TOTAL",null,{"$f":"SUM(D5:D10)","v":174000},17400,63800,34800,290000,191400,60400,22968,5033,17935,2106,303,8,40903,409,1109,null,null,null,null,null,null,null,null,null,null,null,266623,332012,{"$f":"SUM(AG5:AG10)","v":3984144}]