{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Master Data","Deductions1","Deductions2","Deductions3","GA 55A","Tax Calculator By Ashwini"],"not_rendered":{"images":1,"macros":1,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Master Data","index":0,"n_rows":105,"n_cols":43,"rows_kept":105,"merged":[[0,0,0,16],[1,0,1,16]]}
["All Staff IT Calculator 2024-25 By Ashwini Kumar Excel"]
["Office Name - www.ashwinisharma.com"]
[]
["Sr.No.","Employee Name","Post","PAN No.","Basic March 24","HRA %","Bonus Month","DA Arrear","Surrender Month","CCA Amount","Washing All. Amount","Handi.All. Ammout","Oth. All. 1","Oth.All. 2","Oth.Income","Bank interest Amount","FD & other interest"]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[{"$f":"IF(B6=\"\",\"\",ROW()-5)","v":1},"Ashwini Kumar 1","Lecturer","AAAAA5921A",{"v":51400,"d":"₹51,400.00"},{"v":0.1,"d":"10%"},12,"Yes","2024-03-01",{"$nulls":32},1,"2024-03-01"]
[{"$f":"IF(B7=\"\",\"\",ROW()-5)","v":2},"Arun Kumar","Teacher","AAAAA5922A",{"v":49900,"d":"₹49,900.00"},{"v":0.2,"d":"20%"},10,"No","2024-03-01",{"$nulls":32},2,"2024-04-01"]
[3,"Dhirendra Kumar","Lecturer","AAAAA5923A",{"v":52900,"d":"₹52,900.00"},{"v":0.1,"d":"10%"},12,"Yes","2024-12-01",{"$nulls":32},3,"2024-05-01"]
[4,"Ashwini Kumar 4",{"$nulls":39},4,"2024-06-01"]
[5,"Ashwini Kumar 5",{"$nulls":39},5,"2024-07-01"]
[6,"Ashwini Kumar 6",{"$nulls":39},6,"2024-08-01"]
[7,"Ashwini Kumar 7",{"$nulls":39},7,"2024-09-01"]
[8,"Ashwini Kumar 8",{"$nulls":39},8,"2024-10-01"]
[9,"Ashwini Kumar 9",{"$nulls":39},9,"2024-11-01"]
[10,"Ashwini Kumar 10",{"$nulls":39},10,"2024-12-01"]
[11,"Ashwini Kumar 11",{"$nulls":39},11,"2025-01-01"]
[12,"Ashwini Kumar 12",{"$nulls":39},12,"2025-02-01"]
[13,"Ashwini Kumar 13"]
[14,"Ashwini Kumar 14"]
[15,"Ashwini Kumar 15"]
[16,"Ashwini Kumar 16"]
[17,"Ashwini Kumar 17"]
[18,"Ashwini Kumar 18"]
[19,"Ashwini Kumar 19"]
[20,"Ashwini Kumar 20"]
[21,"Ashwini Kumar 21"]
[22,"Ashwini Kumar 22"]
[23,"Ashwini Kumar 23"]
[24,"Ashwini Kumar 24"]
[25,"Ashwini Kumar 25"]
[26,"Ashwini Kumar 26"]
[27,"Ashwini Kumar 27"]
[28,"Ashwini Kumar 28"]
[29,"Ashwini Kumar 29"]
[30,"Ashwini Kumar 30"]
[31,"Ashwini Kumar 31"]
[32,"Ashwini Kumar 32"]
[33,"Ashwini Kumar 33"]
[34,"Ashwini Kumar 34"]
[35,"Ashwini Kumar 35"]
[36,"Ashwini Kumar 36"]
[37,"Ashwini Kumar 37"]
[38,"Ashwini Kumar 38"]
[39,"Ashwini Kumar 39"]
[40,"Ashwini Kumar 40"]
[41,"Ashwini Kumar 41"]
[42,"Ashwini Kumar 42"]
[43,"Ashwini Kumar 43"]
[44,"Ashwini Kumar 44"]
[45,"Ashwini Kumar 45"]
[46,"Ashwini Kumar 46"]
[47,"Ashwini Kumar 47"]
[48,"Ashwini Kumar 48"]
[49,"Ashwini Kumar 49"]
[50,"Ashwini Kumar 50"]
[51,"Ashwini Kumar 51"]
[52,"Ashwini Kumar 52"]
[53,"Ashwini Kumar 53"]
[54,"Ashwini Kumar 54"]
[55,"Ashwini Kumar 55"]
[56,"Ashwini Kumar 56"]
[57,"Ashwini Kumar 57"]
[58,"Ashwini Kumar 58"]
[59,"Ashwini Kumar 59"]
[60,"Ashwini Kumar 60"]
[61,"Ashwini Kumar 61"]
[62,"Ashwini Kumar 62"]
[63,"Ashwini Kumar 63"]
[64,"Ashwini Kumar 64"]
[65,"Ashwini Kumar 65"]
[{"$f":"IF(B71=\"\",\"\",ROW()-5)","v":66},"Ashwini Kumar 66"]
[67,"Ashwini Kumar 67"]
[68,"Ashwini Kumar 68"]
[69,"Ashwini Kumar 69"]
[70,"Ashwini Kumar 70"]
[71,"Ashwini Kumar 71"]
[72,"Ashwini Kumar 72"]
[73,"Ashwini Kumar 73"]
[74,"Ashwini Kumar 74"]
[75,"Ashwini Kumar 75"]
[76,"Ashwini Kumar 76"]
[77,"Ashwini Kumar 77"]
[78,"Ashwini Kumar 78"]
[79,"Ashwini Kumar 79"]
[80,"Ashwini Kumar 80"]
[81,"Ashwini Kumar 81"]
[82,"Ashwini Kumar 82"]
[83,"Ashwini Kumar 83"]
[84,"Ashwini Kumar 84"]
[85,"Ashwini Kumar 85"]
[86,"Ashwini Kumar 86"]
[87,"Ashwini Kumar 87"]
[88,"Ashwini Kumar 88"]
[89,"Ashwini Kumar 89"]
[90,"Ashwini Kumar 90"]
[91,"Ashwini Kumar 91"]
[92,"Ashwini Kumar 92"]
[93,"Ashwini Kumar 93"]
[94,"Ashwini Kumar 94"]
[95,"Ashwini Kumar 95"]
[96,"Ashwini Kumar 96"]
[97,"Ashwini Kumar 97"]
[98,"Ashwini Kumar 98"]
[99,"Ashwini Kumar 99"]
[100,"Ashwini Kumar 100"]

{"sheet":"Deductions1","index":1,"n_rows":104,"n_cols":38,"rows_kept":104,"merged":[[0,0,0,20],[1,0,1,20],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,2,20]]}
["All Staff IT Calculator 2024-25 By Ashwini Kumar Excel"]
[{"$f":"'Master Data'!A2","v":"Office Name - www.ashwinisharma.com"}]
["Sr.No.","Employee Name","SI","GPF/\nGPF2004 (other than Slab)","GIS","Hitkari Nidhi","LIC from Salary","Other Ded1","Other Ded2","Tax Deduction"]
[{"$nulls":9},"2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01"]
[{"$f":"IF('Master Data'!A6=\"\",\"\",'Master Data'!A6)","v":1},{"$f":"IF('Master Data'!B6=\"\",\"\",'Master Data'!B6)","v":"Ashwini Kumar 1"},3000,null,700,250,{"$nulls":30},1,"2024-03-01"]
[{"$f":"IF('Master Data'!A7=\"\",\"\",'Master Data'!A7)","v":2},{"$f":"IF('Master Data'!B7=\"\",\"\",'Master Data'!B7)","v":"Arun Kumar"},5000,8000,1400,500,{"$nulls":30},2,"2024-04-01"]
[{"$f":"IF('Master Data'!A8=\"\",\"\",'Master Data'!A8)","v":3},{"$f":"IF('Master Data'!B8=\"\",\"\",'Master Data'!B8)","v":"Dhirendra Kumar"},7000,null,2100,{"$nulls":31},3,"2024-05-01"]
[{"$f":"IF('Master Data'!A9=\"\",\"\",'Master Data'!A9)","v":4},{"$f":"IF('Master Data'!B9=\"\",\"\",'Master Data'!B9)","v":"Ashwini Kumar 4"},{"$nulls":3},500,{"$nulls":30},4,"2024-06-01"]
[{"$f":"IF('Master Data'!A10=\"\",\"\",'Master Data'!A10)","v":5},{"$f":"IF('Master Data'!B10=\"\",\"\",'Master Data'!B10)","v":"Ashwini Kumar 5"},{"$nulls":34},5,"2024-07-01"]
[{"$f":"IF('Master Data'!A11=\"\",\"\",'Master Data'!A11)","v":6},{"$f":"IF('Master Data'!B11=\"\",\"\",'Master Data'!B11)","v":"Ashwini Kumar 6"},{"$nulls":34},6,"2024-08-01"]
[{"$f":"IF('Master Data'!A12=\"\",\"\",'Master Data'!A12)","v":7},{"$f":"IF('Master Data'!B12=\"\",\"\",'Master Data'!B12)","v":"Ashwini Kumar 7"},{"$nulls":34},7,"2024-09-01"]
[{"$f":"IF('Master Data'!A13=\"\",\"\",'Master Data'!A13)","v":8},{"$f":"IF('Master Data'!B13=\"\",\"\",'Master Data'!B13)","v":"Ashwini Kumar 8"},{"$nulls":34},8,"2024-10-01"]
[{"$f":"IF('Master Data'!A14=\"\",\"\",'Master Data'!A14)","v":9},{"$f":"IF('Master Data'!B14=\"\",\"\",'Master Data'!B14)","v":"Ashwini Kumar 9"},{"$nulls":34},9,"2024-11-01"]
[{"$f":"IF('Master Data'!A15=\"\",\"\",'Master Data'!A15)","v":10},{"$f":"IF('Master Data'!B15=\"\",\"\",'Master Data'!B15)","v":"Ashwini Kumar 10"},{"$nulls":34},10,"2024-12-01"]
[{"$f":"IF('Master Data'!A16=\"\",\"\",'Master Data'!A16)","v":11},{"$f":"IF('Master Data'!B16=\"\",\"\",'Master Data'!B16)","v":"Ashwini Kumar 11"},{"$nulls":34},11,"2025-01-01"]
[{"$f":"IF('Master Data'!A17=\"\",\"\",'Master Data'!A17)","v":12},{"$f":"IF('Master Data'!B17=\"\",\"\",'Master Data'!B17)","v":"Ashwini Kumar 12"},{"$nulls":34},12,"2025-02-01"]
[{"$f":"IF('Master Data'!A18=\"\",\"\",'Master Data'!A18)","v":13},{"$f":"IF('Master Data'!B18=\"\",\"\",'Master Data'!B18)","v":"Ashwini Kumar 13"}]
[{"$f":"IF('Master Data'!A19=\"\",\"\",'Master Data'!A19)","v":14},{"$f":"IF('Master Data'!B19=\"\",\"\",'Master Data'!B19)","v":"Ashwini Kumar 14"}]
[{"$f":"IF('Master Data'!A20=\"\",\"\",'Master Data'!A20)","v":15},{"$f":"IF('Master Data'!B20=\"\",\"\",'Master Data'!B20)","v":"Ashwini Kumar 15"}]
[{"$f":"IF('Master Data'!A21=\"\",\"\",'Master Data'!A21)","v":16},{"$f":"IF('Master Data'!B21=\"\",\"\",'Master Data'!B21)","v":"Ashwini Kumar 16"}]
[{"$f":"IF('Master Data'!A22=\"\",\"\",'Master Data'!A22)","v":17},{"$f":"IF('Master Data'!B22=\"\",\"\",'Master Data'!B22)","v":"Ashwini Kumar 17"}]
[{"$f":"IF('Master Data'!A23=\"\",\"\",'Master Data'!A23)","v":18},{"$f":"IF('Master Data'!B23=\"\",\"\",'Master Data'!B23)","v":"Ashwini Kumar 18"}]
[{"$f":"IF('Master Data'!A24=\"\",\"\",'Master Data'!A24)","v":19},{"$f":"IF('Master Data'!B24=\"\",\"\",'Master Data'!B24)","v":"Ashwini Kumar 19"}]
[{"$f":"IF('Master Data'!A25=\"\",\"\",'Master Data'!A25)","v":20},{"$f":"IF('Master Data'!B25=\"\",\"\",'Master Data'!B25)","v":"Ashwini Kumar 20"}]
[{"$f":"IF('Master Data'!A26=\"\",\"\",'Master Data'!A26)","v":21},{"$f":"IF('Master Data'!B26=\"\",\"\",'Master Data'!B26)","v":"Ashwini Kumar 21"}]
[{"$f":"IF('Master Data'!A27=\"\",\"\",'Master Data'!A27)","v":22},{"$f":"IF('Master Data'!B27=\"\",\"\",'Master Data'!B27)","v":"Ashwini Kumar 22"}]
[{"$f":"IF('Master Data'!A28=\"\",\"\",'Master Data'!A28)","v":23},{"$f":"IF('Master Data'!B28=\"\",\"\",'Master Data'!B28)","v":"Ashwini Kumar 23"}]
[{"$f":"IF('Master Data'!A29=\"\",\"\",'Master Data'!A29)","v":24},{"$f":"IF('Master Data'!B29=\"\",\"\",'Master Data'!B29)","v":"Ashwini Kumar 24"}]
[{"$f":"IF('Master Data'!A30=\"\",\"\",'Master Data'!A30)","v":25},{"$f":"IF('Master Data'!B30=\"\",\"\",'Master Data'!B30)","v":"Ashwini Kumar 25"}]
[{"$f":"IF('Master Data'!A31=\"\",\"\",'Master Data'!A31)","v":26},{"$f":"IF('Master Data'!B31=\"\",\"\",'Master Data'!B31)","v":"Ashwini Kumar 26"}]
[{"$f":"IF('Master Data'!A32=\"\",\"\",'Master Data'!A32)","v":27},{"$f":"IF('Master Data'!B32=\"\",\"\",'Master Data'!B32)","v":"Ashwini Kumar 27"}]
[{"$f":"IF('Master Data'!A33=\"\",\"\",'Master Data'!A33)","v":28},{"$f":"IF('Master Data'!B33=\"\",\"\",'Master Data'!B33)","v":"Ashwini Kumar 28"}]
[{"$f":"IF('Master Data'!A34=\"\",\"\",'Master Data'!A34)","v":29},{"$f":"IF('Master Data'!B34=\"\",\"\",'Master Data'!B34)","v":"Ashwini Kumar 29"}]
[{"$f":"IF('Master Data'!A35=\"\",\"\",'Master Data'!A35)","v":30},{"$f":"IF('Master Data'!B35=\"\",\"\",'Master Data'!B35)","v":"Ashwini Kumar 30"}]
[{"$f":"IF('Master Data'!A36=\"\",\"\",'Master Data'!A36)","v":31},{"$f":"IF('Master Data'!B36=\"\",\"\",'Master Data'!B36)","v":"Ashwini Kumar 31"}]
[{"$f":"IF('Master Data'!A37=\"\",\"\",'Master Data'!A37)","v":32},{"$f":"IF('Master Data'!B37=\"\",\"\",'Master Data'!B37)","v":"Ashwini Kumar 32"}]
[{"$f":"IF('Master Data'!A38=\"\",\"\",'Master Data'!A38)","v":33},{"$f":"IF('Master Data'!B38=\"\",\"\",'Master Data'!B38)","v":"Ashwini Kumar 33"}]
[{"$f":"IF('Master Data'!A39=\"\",\"\",'Master Data'!A39)","v":34},{"$f":"IF('Master Data'!B39=\"\",\"\",'Master Data'!B39)","v":"Ashwini Kumar 34"}]
[{"$f":"IF('Master Data'!A40=\"\",\"\",'Master Data'!A40)","v":35},{"$f":"IF('Master Data'!B40=\"\",\"\",'Master Data'!B40)","v":"Ashwini Kumar 35"}]
[{"$f":"IF('Master Data'!A41=\"\",\"\",'Master Data'!A41)","v":36},{"$f":"IF('Master Data'!B41=\"\",\"\",'Master Data'!B41)","v":"Ashwini Kumar 36"}]
[{"$f":"IF('Master Data'!A42=\"\",\"\",'Master Data'!A42)","v":37},{"$f":"IF('Master Data'!B42=\"\",\"\",'Master Data'!B42)","v":"Ashwini Kumar 37"}]
[{"$f":"IF('Master Data'!A43=\"\",\"\",'Master Data'!A43)","v":38},{"$f":"IF('Master Data'!B43=\"\",\"\",'Master Data'!B43)","v":"Ashwini Kumar 38"}]
[{"$f":"IF('Master Data'!A44=\"\",\"\",'Master Data'!A44)","v":39},{"$f":"IF('Master Data'!B44=\"\",\"\",'Master Data'!B44)","v":"Ashwini Kumar 39"}]
[{"$f":"IF('Master Data'!A45=\"\",\"\",'Master Data'!A45)","v":40},{"$f":"IF('Master Data'!B45=\"\",\"\",'Master Data'!B45)","v":"Ashwini Kumar 40"}]
[{"$f":"IF('Master Data'!A46=\"\",\"\",'Master Data'!A46)","v":41},{"$f":"IF('Master Data'!B46=\"\",\"\",'Master Data'!B46)","v":"Ashwini Kumar 41"}]
[{"$f":"IF('Master Data'!A47=\"\",\"\",'Master Data'!A47)","v":42},{"$f":"IF('Master Data'!B47=\"\",\"\",'Master Data'!B47)","v":"Ashwini Kumar 42"}]
[{"$f":"IF('Master Data'!A48=\"\",\"\",'Master Data'!A48)","v":43},{"$f":"IF('Master Data'!B48=\"\",\"\",'Master Data'!B48)","v":"Ashwini Kumar 43"}]
[{"$f":"IF('Master Data'!A49=\"\",\"\",'Master Data'!A49)","v":44},{"$f":"IF('Master Data'!B49=\"\",\"\",'Master Data'!B49)","v":"Ashwini Kumar 44"}]
[{"$f":"IF('Master Data'!A50=\"\",\"\",'Master Data'!A50)","v":45},{"$f":"IF('Master Data'!B50=\"\",\"\",'Master Data'!B50)","v":"Ashwini Kumar 45"}]
[{"$f":"IF('Master Data'!A51=\"\",\"\",'Master Data'!A51)","v":46},{"$f":"IF('Master Data'!B51=\"\",\"\",'Master Data'!B51)","v":"Ashwini Kumar 46"}]
[{"$f":"IF('Master Data'!A52=\"\",\"\",'Master Data'!A52)","v":47},{"$f":"IF('Master Data'!B52=\"\",\"\",'Master Data'!B52)","v":"Ashwini Kumar 47"}]
[{"$f":"IF('Master Data'!A53=\"\",\"\",'Master Data'!A53)","v":48},{"$f":"IF('Master Data'!B53=\"\",\"\",'Master Data'!B53)","v":"Ashwini Kumar 48"}]
[{"$f":"IF('Master Data'!A54=\"\",\"\",'Master Data'!A54)","v":49},{"$f":"IF('Master Data'!B54=\"\",\"\",'Master Data'!B54)","v":"Ashwini Kumar 49"}]
[{"$f":"IF('Master Data'!A55=\"\",\"\",'Master Data'!A55)","v":50},{"$f":"IF('Master Data'!B55=\"\",\"\",'Master Data'!B55)","v":"Ashwini Kumar 50"}]
[{"$f":"IF('Master Data'!A56=\"\",\"\",'Master Data'!A56)","v":51},{"$f":"IF('Master Data'!B56=\"\",\"\",'Master Data'!B56)","v":"Ashwini Kumar 51"}]
[{"$f":"IF('Master Data'!A57=\"\",\"\",'Master Data'!A57)","v":52},{"$f":"IF('Master Data'!B57=\"\",\"\",'Master Data'!B57)","v":"Ashwini Kumar 52"}]
[{"$f":"IF('Master Data'!A58=\"\",\"\",'Master Data'!A58)","v":53},{"$f":"IF('Master Data'!B58=\"\",\"\",'Master Data'!B58)","v":"Ashwini Kumar 53"}]
[{"$f":"IF('Master Data'!A59=\"\",\"\",'Master Data'!A59)","v":54},{"$f":"IF('Master Data'!B59=\"\",\"\",'Master Data'!B59)","v":"Ashwini Kumar 54"}]
[{"$f":"IF('Master Data'!A60=\"\",\"\",'Master Data'!A60)","v":55},{"$f":"IF('Master Data'!B60=\"\",\"\",'Master Data'!B60)","v":"Ashwini Kumar 55"}]
[{"$f":"IF('Master Data'!A61=\"\",\"\",'Master Data'!A61)","v":56},{"$f":"IF('Master Data'!B61=\"\",\"\",'Master Data'!B61)","v":"Ashwini Kumar 56"}]
[{"$f":"IF('Master Data'!A62=\"\",\"\",'Master Data'!A62)","v":57},{"$f":"IF('Master Data'!B62=\"\",\"\",'Master Data'!B62)","v":"Ashwini Kumar 57"}]
[{"$f":"IF('Master Data'!A63=\"\",\"\",'Master Data'!A63)","v":58},{"$f":"IF('Master Data'!B63=\"\",\"\",'Master Data'!B63)","v":"Ashwini Kumar 58"}]
[{"$f":"IF('Master Data'!A64=\"\",\"\",'Master Data'!A64)","v":59},{"$f":"IF('Master Data'!B64=\"\",\"\",'Master Data'!B64)","v":"Ashwini Kumar 59"}]
[{"$f":"IF('Master Data'!A65=\"\",\"\",'Master Data'!A65)","v":60},{"$f":"IF('Master Data'!B65=\"\",\"\",'Master Data'!B65)","v":"Ashwini Kumar 60"}]
[{"$f":"IF('Master Data'!A66=\"\",\"\",'Master Data'!A66)","v":61},{"$f":"IF('Master Data'!B66=\"\",\"\",'Master Data'!B66)","v":"Ashwini Kumar 61"}]
[{"$f":"IF('Master Data'!A67=\"\",\"\",'Master Data'!A67)","v":62},{"$f":"IF('Master Data'!B67=\"\",\"\",'Master Data'!B67)","v":"Ashwini Kumar 62"}]
[{"$f":"IF('Master Data'!A68=\"\",\"\",'Master Data'!A68)","v":63},{"$f":"IF('Master Data'!B68=\"\",\"\",'Master Data'!B68)","v":"Ashwini Kumar 63"}]
[{"$f":"IF('Master Data'!A69=\"\",\"\",'Master Data'!A69)","v":64},{"$f":"IF('Master Data'!B69=\"\",\"\",'Master Data'!B69)","v":"Ashwini Kumar 64"}]
[{"$f":"IF('Master Data'!A70=\"\",\"\",'Master Data'!A70)","v":65},{"$f":"IF('Master Data'!B70=\"\",\"\",'Master Data'!B70)","v":"Ashwini Kumar 65"}]
[{"$f":"IF('Master Data'!A71=\"\",\"\",'Master Data'!A71)","v":66},{"$f":"IF('Master Data'!B71=\"\",\"\",'Master Data'!B71)","v":"Ashwini Kumar 66"}]
[{"$f":"IF('Master Data'!A72=\"\",\"\",'Master Data'!A72)","v":67},{"$f":"IF('Master Data'!B72=\"\",\"\",'Master Data'!B72)","v":"Ashwini Kumar 67"}]
[{"$f":"IF('Master Data'!A73=\"\",\"\",'Master Data'!A73)","v":68},{"$f":"IF('Master Data'!B73=\"\",\"\",'Master Data'!B73)","v":"Ashwini Kumar 68"}]
[{"$f":"IF('Master Data'!A74=\"\",\"\",'Master Data'!A74)","v":69},{"$f":"IF('Master Data'!B74=\"\",\"\",'Master Data'!B74)","v":"Ashwini Kumar 69"}]
[{"$f":"IF('Master Data'!A75=\"\",\"\",'Master Data'!A75)","v":70},{"$f":"IF('Master Data'!B75=\"\",\"\",'Master Data'!B75)","v":"Ashwini Kumar 70"}]
[{"$f":"IF('Master Data'!A76=\"\",\"\",'Master Data'!A76)","v":71},{"$f":"IF('Master Data'!B76=\"\",\"\",'Master Data'!B76)","v":"Ashwini Kumar 71"}]
[{"$f":"IF('Master Data'!A77=\"\",\"\",'Master Data'!A77)","v":72},{"$f":"IF('Master Data'!B77=\"\",\"\",'Master Data'!B77)","v":"Ashwini Kumar 72"}]
[{"$f":"IF('Master Data'!A78=\"\",\"\",'Master Data'!A78)","v":73},{"$f":"IF('Master Data'!B78=\"\",\"\",'Master Data'!B78)","v":"Ashwini Kumar 73"}]
[{"$f":"IF('Master Data'!A79=\"\",\"\",'Master Data'!A79)","v":74},{"$f":"IF('Master Data'!B79=\"\",\"\",'Master Data'!B79)","v":"Ashwini Kumar 74"}]
[{"$f":"IF('Master Data'!A80=\"\",\"\",'Master Data'!A80)","v":75},{"$f":"IF('Master Data'!B80=\"\",\"\",'Master Data'!B80)","v":"Ashwini Kumar 75"}]
[{"$f":"IF('Master Data'!A81=\"\",\"\",'Master Data'!A81)","v":76},{"$f":"IF('Master Data'!B81=\"\",\"\",'Master Data'!B81)","v":"Ashwini Kumar 76"}]
[{"$f":"IF('Master Data'!A82=\"\",\"\",'Master Data'!A82)","v":77},{"$f":"IF('Master Data'!B82=\"\",\"\",'Master Data'!B82)","v":"Ashwini Kumar 77"}]
[{"$f":"IF('Master Data'!A83=\"\",\"\",'Master Data'!A83)","v":78},{"$f":"IF('Master Data'!B83=\"\",\"\",'Master Data'!B83)","v":"Ashwini Kumar 78"}]
[{"$f":"IF('Master Data'!A84=\"\",\"\",'Master Data'!A84)","v":79},{"$f":"IF('Master Data'!B84=\"\",\"\",'Master Data'!B84)","v":"Ashwini Kumar 79"}]
[{"$f":"IF('Master Data'!A85=\"\",\"\",'Master Data'!A85)","v":80},{"$f":"IF('Master Data'!B85=\"\",\"\",'Master Data'!B85)","v":"Ashwini Kumar 80"}]
[{"$f":"IF('Master Data'!A86=\"\",\"\",'Master Data'!A86)","v":81},{"$f":"IF('Master Data'!B86=\"\",\"\",'Master Data'!B86)","v":"Ashwini Kumar 81"}]
[{"$f":"IF('Master Data'!A87=\"\",\"\",'Master Data'!A87)","v":82},{"$f":"IF('Master Data'!B87=\"\",\"\",'Master Data'!B87)","v":"Ashwini Kumar 82"}]
[{"$f":"IF('Master Data'!A88=\"\",\"\",'Master Data'!A88)","v":83},{"$f":"IF('Master Data'!B88=\"\",\"\",'Master Data'!B88)","v":"Ashwini Kumar 83"}]
[{"$f":"IF('Master Data'!A89=\"\",\"\",'Master Data'!A89)","v":84},{"$f":"IF('Master Data'!B89=\"\",\"\",'Master Data'!B89)","v":"Ashwini Kumar 84"}]
[{"$f":"IF('Master Data'!A90=\"\",\"\",'Master Data'!A90)","v":85},{"$f":"IF('Master Data'!B90=\"\",\"\",'Master Data'!B90)","v":"Ashwini Kumar 85"}]
[{"$f":"IF('Master Data'!A91=\"\",\"\",'Master Data'!A91)","v":86},{"$f":"IF('Master Data'!B91=\"\",\"\",'Master Data'!B91)","v":"Ashwini Kumar 86"}]
[{"$f":"IF('Master Data'!A92=\"\",\"\",'Master Data'!A92)","v":87},{"$f":"IF('Master Data'!B92=\"\",\"\",'Master Data'!B92)","v":"Ashwini Kumar 87"}]
[{"$f":"IF('Master Data'!A93=\"\",\"\",'Master Data'!A93)","v":88},{"$f":"IF('Master Data'!B93=\"\",\"\",'Master Data'!B93)","v":"Ashwini Kumar 88"}]
[{"$f":"IF('Master Data'!A94=\"\",\"\",'Master Data'!A94)","v":89},{"$f":"IF('Master Data'!B94=\"\",\"\",'Master Data'!B94)","v":"Ashwini Kumar 89"}]
[{"$f":"IF('Master Data'!A95=\"\",\"\",'Master Data'!A95)","v":90},{"$f":"IF('Master Data'!B95=\"\",\"\",'Master Data'!B95)","v":"Ashwini Kumar 90"}]
[{"$f":"IF('Master Data'!A96=\"\",\"\",'Master Data'!A96)","v":91},{"$f":"IF('Master Data'!B96=\"\",\"\",'Master Data'!B96)","v":"Ashwini Kumar 91"}]
[{"$f":"IF('Master Data'!A97=\"\",\"\",'Master Data'!A97)","v":92},{"$f":"IF('Master Data'!B97=\"\",\"\",'Master Data'!B97)","v":"Ashwini Kumar 92"}]
[{"$f":"IF('Master Data'!A98=\"\",\"\",'Master Data'!A98)","v":93},{"$f":"IF('Master Data'!B98=\"\",\"\",'Master Data'!B98)","v":"Ashwini Kumar 93"}]
[{"$f":"IF('Master Data'!A99=\"\",\"\",'Master Data'!A99)","v":94},{"$f":"IF('Master Data'!B99=\"\",\"\",'Master Data'!B99)","v":"Ashwini Kumar 94"}]
[{"$f":"IF('Master Data'!A100=\"\",\"\",'Master Data'!A100)","v":95},{"$f":"IF('Master Data'!B100=\"\",\"\",'Master Data'!B100)","v":"Ashwini Kumar 95"}]
[{"$f":"IF('Master Data'!A101=\"\",\"\",'Master Data'!A101)","v":96},{"$f":"IF('Master Data'!B101=\"\",\"\",'Master Data'!B101)","v":"Ashwini Kumar 96"}]
[{"$f":"IF('Master Data'!A102=\"\",\"\",'Master Data'!A102)","v":97},{"$f":"IF('Master Data'!B102=\"\",\"\",'Master Data'!B102)","v":"Ashwini Kumar 97"}]
[{"$f":"IF('Master Data'!A103=\"\",\"\",'Master Data'!A103)","v":98},{"$f":"IF('Master Data'!B103=\"\",\"\",'Master Data'!B103)","v":"Ashwini Kumar 98"}]
[{"$f":"IF('Master Data'!A104=\"\",\"\",'Master Data'!A104)","v":99},{"$f":"IF('Master Data'!B104=\"\",\"\",'Master Data'!B104)","v":"Ashwini Kumar 99"}]
[{"$f":"IF('Master Data'!A105=\"\",\"\",'Master Data'!A105)","v":100},{"$f":"IF('Master Data'!B105=\"\",\"\",'Master Data'!B105)","v":"Ashwini Kumar 100"}]

{"sheet":"Deductions2","index":2,"n_rows":104,"n_cols":20,"rows_kept":104,"merged":[[0,0,0,19],[1,0,1,19]]}
["All Staff IT Calculator 2024-25 By Ashwini Kumar Excel"]
[{"$f":"'Master Data'!A2","v":"Office Name - www.ashwinisharma.com"}]
[]
["Sr.No.","Employee Name","HRA","Income from house property","Home Loan Interest","Home Loan Premium","LIC (other than Salary","PLI","Tution Fees","ULIP","NSC","NSC Interest","PPF","NSS","Sukanya Scheme","Equity Link Saving Scheme","Defferred Annuty","EPEF (80CCD1)","80CCC","Other Diposite In Section 80C"]
[{"$f":"IF('Master Data'!A6=\"\",\"\",'Master Data'!A6)","v":1},{"$f":"IF('Master Data'!B6=\"\",\"\",'Master Data'!B6)","v":"Ashwini Kumar 1"}]
[{"$f":"IF('Master Data'!A7=\"\",\"\",'Master Data'!A7)","v":2},{"$f":"IF('Master Data'!B7=\"\",\"\",'Master Data'!B7)","v":"Arun Kumar"}]
[{"$f":"IF('Master Data'!A8=\"\",\"\",'Master Data'!A8)","v":3},{"$f":"IF('Master Data'!B8=\"\",\"\",'Master Data'!B8)","v":"Dhirendra Kumar"}]
[{"$f":"IF('Master Data'!A9=\"\",\"\",'Master Data'!A9)","v":4},{"$f":"IF('Master Data'!B9=\"\",\"\",'Master Data'!B9)","v":"Ashwini Kumar 4"}]
[{"$f":"IF('Master Data'!A10=\"\",\"\",'Master Data'!A10)","v":5},{"$f":"IF('Master Data'!B10=\"\",\"\",'Master Data'!B10)","v":"Ashwini Kumar 5"}]
[{"$f":"IF('Master Data'!A11=\"\",\"\",'Master Data'!A11)","v":6},{"$f":"IF('Master Data'!B11=\"\",\"\",'Master Data'!B11)","v":"Ashwini Kumar 6"}]
[{"$f":"IF('Master Data'!A12=\"\",\"\",'Master Data'!A12)","v":7},{"$f":"IF('Master Data'!B12=\"\",\"\",'Master Data'!B12)","v":"Ashwini Kumar 7"}]
[{"$f":"IF('Master Data'!A13=\"\",\"\",'Master Data'!A13)","v":8},{"$f":"IF('Master Data'!B13=\"\",\"\",'Master Data'!B13)","v":"Ashwini Kumar 8"}]
[{"$f":"IF('Master Data'!A14=\"\",\"\",'Master Data'!A14)","v":9},{"$f":"IF('Master Data'!B14=\"\",\"\",'Master Data'!B14)","v":"Ashwini Kumar 9"}]
[{"$f":"IF('Master Data'!A15=\"\",\"\",'Master Data'!A15)","v":10},{"$f":"IF('Master Data'!B15=\"\",\"\",'Master Data'!B15)","v":"Ashwini Kumar 10"}]
[{"$f":"IF('Master Data'!A16=\"\",\"\",'Master Data'!A16)","v":11},{"$f":"IF('Master Data'!B16=\"\",\"\",'Master Data'!B16)","v":"Ashwini Kumar 11"}]
[{"$f":"IF('Master Data'!A17=\"\",\"\",'Master Data'!A17)","v":12},{"$f":"IF('Master Data'!B17=\"\",\"\",'Master Data'!B17)","v":"Ashwini Kumar 12"}]
[{"$f":"IF('Master Data'!A18=\"\",\"\",'Master Data'!A18)","v":13},{"$f":"IF('Master Data'!B18=\"\",\"\",'Master Data'!B18)","v":"Ashwini Kumar 13"}]
[{"$f":"IF('Master Data'!A19=\"\",\"\",'Master Data'!A19)","v":14},{"$f":"IF('Master Data'!B19=\"\",\"\",'Master Data'!B19)","v":"Ashwini Kumar 14"}]
[{"$f":"IF('Master Data'!A20=\"\",\"\",'Master Data'!A20)","v":15},{"$f":"IF('Master Data'!B20=\"\",\"\",'Master Data'!B20)","v":"Ashwini Kumar 15"}]
[{"$f":"IF('Master Data'!A21=\"\",\"\",'Master Data'!A21)","v":16},{"$f":"IF('Master Data'!B21=\"\",\"\",'Master Data'!B21)","v":"Ashwini Kumar 16"}]
[{"$f":"IF('Master Data'!A22=\"\",\"\",'Master Data'!A22)","v":17},{"$f":"IF('Master Data'!B22=\"\",\"\",'Master Data'!B22)","v":"Ashwini Kumar 17"}]
[{"$f":"IF('Master Data'!A23=\"\",\"\",'Master Data'!A23)","v":18},{"$f":"IF('Master Data'!B23=\"\",\"\",'Master Data'!B23)","v":"Ashwini Kumar 18"}]
[{"$f":"IF('Master Data'!A24=\"\",\"\",'Master Data'!A24)","v":19},{"$f":"IF('Master Data'!B24=\"\",\"\",'Master Data'!B24)","v":"Ashwini Kumar 19"}]
[{"$f":"IF('Master Data'!A25=\"\",\"\",'Master Data'!A25)","v":20},{"$f":"IF('Master Data'!B25=\"\",\"\",'Master Data'!B25)","v":"Ashwini Kumar 20"}]
[{"$f":"IF('Master Data'!A26=\"\",\"\",'Master Data'!A26)","v":21},{"$f":"IF('Master Data'!B26=\"\",\"\",'Master Data'!B26)","v":"Ashwini Kumar 21"}]
[{"$f":"IF('Master Data'!A27=\"\",\"\",'Master Data'!A27)","v":22},{"$f":"IF('Master Data'!B27=\"\",\"\",'Master Data'!B27)","v":"Ashwini Kumar 22"}]
[{"$f":"IF('Master Data'!A28=\"\",\"\",'Master Data'!A28)","v":23},{"$f":"IF('Master Data'!B28=\"\",\"\",'Master Data'!B28)","v":"Ashwini Kumar 23"}]
[{"$f":"IF('Master Data'!A29=\"\",\"\",'Master Data'!A29)","v":24},{"$f":"IF('Master Data'!B29=\"\",\"\",'Master Data'!B29)","v":"Ashwini Kumar 24"}]
[{"$f":"IF('Master Data'!A30=\"\",\"\",'Master Data'!A30)","v":25},{"$f":"IF('Master Data'!B30=\"\",\"\",'Master Data'!B30)","v":"Ashwini Kumar 25"}]
[{"$f":"IF('Master Data'!A31=\"\",\"\",'Master Data'!A31)","v":26},{"$f":"IF('Master Data'!B31=\"\",\"\",'Master Data'!B31)","v":"Ashwini Kumar 26"}]
[{"$f":"IF('Master Data'!A32=\"\",\"\",'Master Data'!A32)","v":27},{"$f":"IF('Master Data'!B32=\"\",\"\",'Master Data'!B32)","v":"Ashwini Kumar 27"}]
[{"$f":"IF('Master Data'!A33=\"\",\"\",'Master Data'!A33)","v":28},{"$f":"IF('Master Data'!B33=\"\",\"\",'Master Data'!B33)","v":"Ashwini Kumar 28"}]
[{"$f":"IF('Master Data'!A34=\"\",\"\",'Master Data'!A34)","v":29},{"$f":"IF('Master Data'!B34=\"\",\"\",'Master Data'!B34)","v":"Ashwini Kumar 29"}]
[{"$f":"IF('Master Data'!A35=\"\",\"\",'Master Data'!A35)","v":30},{"$f":"IF('Master Data'!B35=\"\",\"\",'Master Data'!B35)","v":"Ashwini Kumar 30"}]
[{"$f":"IF('Master Data'!A36=\"\",\"\",'Master Data'!A36)","v":31},{"$f":"IF('Master Data'!B36=\"\",\"\",'Master Data'!B36)","v":"Ashwini Kumar 31"}]
[{"$f":"IF('Master Data'!A37=\"\",\"\",'Master Data'!A37)","v":32},{"$f":"IF('Master Data'!B37=\"\",\"\",'Master Data'!B37)","v":"Ashwini Kumar 32"}]
[{"$f":"IF('Master Data'!A38=\"\",\"\",'Master Data'!A38)","v":33},{"$f":"IF('Master Data'!B38=\"\",\"\",'Master Data'!B38)","v":"Ashwini Kumar 33"}]
[{"$f":"IF('Master Data'!A39=\"\",\"\",'Master Data'!A39)","v":34},{"$f":"IF('Master Data'!B39=\"\",\"\",'Master Data'!B39)","v":"Ashwini Kumar 34"}]
[{"$f":"IF('Master Data'!A40=\"\",\"\",'Master Data'!A40)","v":35},{"$f":"IF('Master Data'!B40=\"\",\"\",'Master Data'!B40)","v":"Ashwini Kumar 35"}]
[{"$f":"IF('Master Data'!A41=\"\",\"\",'Master Data'!A41)","v":36},{"$f":"IF('Master Data'!B41=\"\",\"\",'Master Data'!B41)","v":"Ashwini Kumar 36"}]
[{"$f":"IF('Master Data'!A42=\"\",\"\",'Master Data'!A42)","v":37},{"$f":"IF('Master Data'!B42=\"\",\"\",'Master Data'!B42)","v":"Ashwini Kumar 37"}]
[{"$f":"IF('Master Data'!A43=\"\",\"\",'Master Data'!A43)","v":38},{"$f":"IF('Master Data'!B43=\"\",\"\",'Master Data'!B43)","v":"Ashwini Kumar 38"}]
[{"$f":"IF('Master Data'!A44=\"\",\"\",'Master Data'!A44)","v":39},{"$f":"IF('Master Data'!B44=\"\",\"\",'Master Data'!B44)","v":"Ashwini Kumar 39"}]
[{"$f":"IF('Master Data'!A45=\"\",\"\",'Master Data'!A45)","v":40},{"$f":"IF('Master Data'!B45=\"\",\"\",'Master Data'!B45)","v":"Ashwini Kumar 40"}]
[{"$f":"IF('Master Data'!A46=\"\",\"\",'Master Data'!A46)","v":41},{"$f":"IF('Master Data'!B46=\"\",\"\",'Master Data'!B46)","v":"Ashwini Kumar 41"}]
[{"$f":"IF('Master Data'!A47=\"\",\"\",'Master Data'!A47)","v":42},{"$f":"IF('Master Data'!B47=\"\",\"\",'Master Data'!B47)","v":"Ashwini Kumar 42"}]
[{"$f":"IF('Master Data'!A48=\"\",\"\",'Master Data'!A48)","v":43},{"$f":"IF('Master Data'!B48=\"\",\"\",'Master Data'!B48)","v":"Ashwini Kumar 43"}]
[{"$f":"IF('Master Data'!A49=\"\",\"\",'Master Data'!A49)","v":44},{"$f":"IF('Master Data'!B49=\"\",\"\",'Master Data'!B49)","v":"Ashwini Kumar 44"}]
[{"$f":"IF('Master Data'!A50=\"\",\"\",'Master Data'!A50)","v":45},{"$f":"IF('Master Data'!B50=\"\",\"\",'Master Data'!B50)","v":"Ashwini Kumar 45"}]
[{"$f":"IF('Master Data'!A51=\"\",\"\",'Master Data'!A51)","v":46},{"$f":"IF('Master Data'!B51=\"\",\"\",'Master Data'!B51)","v":"Ashwini Kumar 46"}]
[{"$f":"IF('Master Data'!A52=\"\",\"\",'Master Data'!A52)","v":47},{"$f":"IF('Master Data'!B52=\"\",\"\",'Master Data'!B52)","v":"Ashwini Kumar 47"}]
[{"$f":"IF('Master Data'!A53=\"\",\"\",'Master Data'!A53)","v":48},{"$f":"IF('Master Data'!B53=\"\",\"\",'Master Data'!B53)","v":"Ashwini Kumar 48"}]
[{"$f":"IF('Master Data'!A54=\"\",\"\",'Master Data'!A54)","v":49},{"$f":"IF('Master Data'!B54=\"\",\"\",'Master Data'!B54)","v":"Ashwini Kumar 49"}]
[{"$f":"IF('Master Data'!A55=\"\",\"\",'Master Data'!A55)","v":50},{"$f":"IF('Master Data'!B55=\"\",\"\",'Master Data'!B55)","v":"Ashwini Kumar 50"}]
[{"$f":"IF('Master Data'!A56=\"\",\"\",'Master Data'!A56)","v":51},{"$f":"IF('Master Data'!B56=\"\",\"\",'Master Data'!B56)","v":"Ashwini Kumar 51"}]
[{"$f":"IF('Master Data'!A57=\"\",\"\",'Master Data'!A57)","v":52},{"$f":"IF('Master Data'!B57=\"\",\"\",'Master Data'!B57)","v":"Ashwini Kumar 52"}]
[{"$f":"IF('Master Data'!A58=\"\",\"\",'Master Data'!A58)","v":53},{"$f":"IF('Master Data'!B58=\"\",\"\",'Master Data'!B58)","v":"Ashwini Kumar 53"}]
[{"$f":"IF('Master Data'!A59=\"\",\"\",'Master Data'!A59)","v":54},{"$f":"IF('Master Data'!B59=\"\",\"\",'Master Data'!B59)","v":"Ashwini Kumar 54"}]
[{"$f":"IF('Master Data'!A60=\"\",\"\",'Master Data'!A60)","v":55},{"$f":"IF('Master Data'!B60=\"\",\"\",'Master Data'!B60)","v":"Ashwini Kumar 55"}]
[{"$f":"IF('Master Data'!A61=\"\",\"\",'Master Data'!A61)","v":56},{"$f":"IF('Master Data'!B61=\"\",\"\",'Master Data'!B61)","v":"Ashwini Kumar 56"}]
[{"$f":"IF('Master Data'!A62=\"\",\"\",'Master Data'!A62)","v":57},{"$f":"IF('Master Data'!B62=\"\",\"\",'Master Data'!B62)","v":"Ashwini Kumar 57"}]
[{"$f":"IF('Master Data'!A63=\"\",\"\",'Master Data'!A63)","v":58},{"$f":"IF('Master Data'!B63=\"\",\"\",'Master Data'!B63)","v":"Ashwini Kumar 58"}]
[{"$f":"IF('Master Data'!A64=\"\",\"\",'Master Data'!A64)","v":59},{"$f":"IF('Master Data'!B64=\"\",\"\",'Master Data'!B64)","v":"Ashwini Kumar 59"}]
[{"$f":"IF('Master Data'!A65=\"\",\"\",'Master Data'!A65)","v":60},{"$f":"IF('Master Data'!B65=\"\",\"\",'Master Data'!B65)","v":"Ashwini Kumar 60"}]
[{"$f":"IF('Master Data'!A66=\"\",\"\",'Master Data'!A66)","v":61},{"$f":"IF('Master Data'!B66=\"\",\"\",'Master Data'!B66)","v":"Ashwini Kumar 61"}]
[{"$f":"IF('Master Data'!A67=\"\",\"\",'Master Data'!A67)","v":62},{"$f":"IF('Master Data'!B67=\"\",\"\",'Master Data'!B67)","v":"Ashwini Kumar 62"}]
[{"$f":"IF('Master Data'!A68=\"\",\"\",'Master Data'!A68)","v":63},{"$f":"IF('Master Data'!B68=\"\",\"\",'Master Data'!B68)","v":"Ashwini Kumar 63"}]
[{"$f":"IF('Master Data'!A69=\"\",\"\",'Master Data'!A69)","v":64},{"$f":"IF('Master Data'!B69=\"\",\"\",'Master Data'!B69)","v":"Ashwini Kumar 64"}]
[{"$f":"IF('Master Data'!A70=\"\",\"\",'Master Data'!A70)","v":65},{"$f":"IF('Master Data'!B70=\"\",\"\",'Master Data'!B70)","v":"Ashwini Kumar 65"}]
[{"$f":"IF('Master Data'!A71=\"\",\"\",'Master Data'!A71)","v":66},{"$f":"IF('Master Data'!B71=\"\",\"\",'Master Data'!B71)","v":"Ashwini Kumar 66"}]
[{"$f":"IF('Master Data'!A72=\"\",\"\",'Master Data'!A72)","v":67},{"$f":"IF('Master Data'!B72=\"\",\"\",'Master Data'!B72)","v":"Ashwini Kumar 67"}]
[{"$f":"IF('Master Data'!A73=\"\",\"\",'Master Data'!A73)","v":68},{"$f":"IF('Master Data'!B73=\"\",\"\",'Master Data'!B73)","v":"Ashwini Kumar 68"}]
[{"$f":"IF('Master Data'!A74=\"\",\"\",'Master Data'!A74)","v":69},{"$f":"IF('Master Data'!B74=\"\",\"\",'Master Data'!B74)","v":"Ashwini Kumar 69"}]
[{"$f":"IF('Master Data'!A75=\"\",\"\",'Master Data'!A75)","v":70},{"$f":"IF('Master Data'!B75=\"\",\"\",'Master Data'!B75)","v":"Ashwini Kumar 70"}]
[{"$f":"IF('Master Data'!A76=\"\",\"\",'Master Data'!A76)","v":71},{"$f":"IF('Master Data'!B76=\"\",\"\",'Master Data'!B76)","v":"Ashwini Kumar 71"}]
[{"$f":"IF('Master Data'!A77=\"\",\"\",'Master Data'!A77)","v":72},{"$f":"IF('Master Data'!B77=\"\",\"\",'Master Data'!B77)","v":"Ashwini Kumar 72"}]
[{"$f":"IF('Master Data'!A78=\"\",\"\",'Master Data'!A78)","v":73},{"$f":"IF('Master Data'!B78=\"\",\"\",'Master Data'!B78)","v":"Ashwini Kumar 73"}]
[{"$f":"IF('Master Data'!A79=\"\",\"\",'Master Data'!A79)","v":74},{"$f":"IF('Master Data'!B79=\"\",\"\",'Master Data'!B79)","v":"Ashwini Kumar 74"}]
[{"$f":"IF('Master Data'!A80=\"\",\"\",'Master Data'!A80)","v":75},{"$f":"IF('Master Data'!B80=\"\",\"\",'Master Data'!B80)","v":"Ashwini Kumar 75"}]
[{"$f":"IF('Master Data'!A81=\"\",\"\",'Master Data'!A81)","v":76},{"$f":"IF('Master Data'!B81=\"\",\"\",'Master Data'!B81)","v":"Ashwini Kumar 76"}]
[{"$f":"IF('Master Data'!A82=\"\",\"\",'Master Data'!A82)","v":77},{"$f":"IF('Master Data'!B82=\"\",\"\",'Master Data'!B82)","v":"Ashwini Kumar 77"}]
[{"$f":"IF('Master Data'!A83=\"\",\"\",'Master Data'!A83)","v":78},{"$f":"IF('Master Data'!B83=\"\",\"\",'Master Data'!B83)","v":"Ashwini Kumar 78"}]
[{"$f":"IF('Master Data'!A84=\"\",\"\",'Master Data'!A84)","v":79},{"$f":"IF('Master Data'!B84=\"\",\"\",'Master Data'!B84)","v":"Ashwini Kumar 79"}]
[{"$f":"IF('Master Data'!A85=\"\",\"\",'Master Data'!A85)","v":80},{"$f":"IF('Master Data'!B85=\"\",\"\",'Master Data'!B85)","v":"Ashwini Kumar 80"}]
[{"$f":"IF('Master Data'!A86=\"\",\"\",'Master Data'!A86)","v":81},{"$f":"IF('Master Data'!B86=\"\",\"\",'Master Data'!B86)","v":"Ashwini Kumar 81"}]
[{"$f":"IF('Master Data'!A87=\"\",\"\",'Master Data'!A87)","v":82},{"$f":"IF('Master Data'!B87=\"\",\"\",'Master Data'!B87)","v":"Ashwini Kumar 82"}]
[{"$f":"IF('Master Data'!A88=\"\",\"\",'Master Data'!A88)","v":83},{"$f":"IF('Master Data'!B88=\"\",\"\",'Master Data'!B88)","v":"Ashwini Kumar 83"}]
[{"$f":"IF('Master Data'!A89=\"\",\"\",'Master Data'!A89)","v":84},{"$f":"IF('Master Data'!B89=\"\",\"\",'Master Data'!B89)","v":"Ashwini Kumar 84"}]
[{"$f":"IF('Master Data'!A90=\"\",\"\",'Master Data'!A90)","v":85},{"$f":"IF('Master Data'!B90=\"\",\"\",'Master Data'!B90)","v":"Ashwini Kumar 85"}]
[{"$f":"IF('Master Data'!A91=\"\",\"\",'Master Data'!A91)","v":86},{"$f":"IF('Master Data'!B91=\"\",\"\",'Master Data'!B91)","v":"Ashwini Kumar 86"}]
[{"$f":"IF('Master Data'!A92=\"\",\"\",'Master Data'!A92)","v":87},{"$f":"IF('Master Data'!B92=\"\",\"\",'Master Data'!B92)","v":"Ashwini Kumar 87"}]
[{"$f":"IF('Master Data'!A93=\"\",\"\",'Master Data'!A93)","v":88},{"$f":"IF('Master Data'!B93=\"\",\"\",'Master Data'!B93)","v":"Ashwini Kumar 88"}]
[{"$f":"IF('Master Data'!A94=\"\",\"\",'Master Data'!A94)","v":89},{"$f":"IF('Master Data'!B94=\"\",\"\",'Master Data'!B94)","v":"Ashwini Kumar 89"}]
[{"$f":"IF('Master Data'!A95=\"\",\"\",'Master Data'!A95)","v":90},{"$f":"IF('Master Data'!B95=\"\",\"\",'Master Data'!B95)","v":"Ashwini Kumar 90"}]
[{"$f":"IF('Master Data'!A96=\"\",\"\",'Master Data'!A96)","v":91},{"$f":"IF('Master Data'!B96=\"\",\"\",'Master Data'!B96)","v":"Ashwini Kumar 91"}]
[{"$f":"IF('Master Data'!A97=\"\",\"\",'Master Data'!A97)","v":92},{"$f":"IF('Master Data'!B97=\"\",\"\",'Master Data'!B97)","v":"Ashwini Kumar 92"}]
[{"$f":"IF('Master Data'!A98=\"\",\"\",'Master Data'!A98)","v":93},{"$f":"IF('Master Data'!B98=\"\",\"\",'Master Data'!B98)","v":"Ashwini Kumar 93"}]
[{"$f":"IF('Master Data'!A99=\"\",\"\",'Master Data'!A99)","v":94},{"$f":"IF('Master Data'!B99=\"\",\"\",'Master Data'!B99)","v":"Ashwini Kumar 94"}]
[{"$f":"IF('Master Data'!A100=\"\",\"\",'Master Data'!A100)","v":95},{"$f":"IF('Master Data'!B100=\"\",\"\",'Master Data'!B100)","v":"Ashwini Kumar 95"}]
[{"$f":"IF('Master Data'!A101=\"\",\"\",'Master Data'!A101)","v":96},{"$f":"IF('Master Data'!B101=\"\",\"\",'Master Data'!B101)","v":"Ashwini Kumar 96"}]
[{"$f":"IF('Master Data'!A102=\"\",\"\",'Master Data'!A102)","v":97},{"$f":"IF('Master Data'!B102=\"\",\"\",'Master Data'!B102)","v":"Ashwini Kumar 97"}]
[{"$f":"IF('Master Data'!A103=\"\",\"\",'Master Data'!A103)","v":98},{"$f":"IF('Master Data'!B103=\"\",\"\",'Master Data'!B103)","v":"Ashwini Kumar 98"}]
[{"$f":"IF('Master Data'!A104=\"\",\"\",'Master Data'!A104)","v":99},{"$f":"IF('Master Data'!B104=\"\",\"\",'Master Data'!B104)","v":"Ashwini Kumar 99"}]
[{"$f":"IF('Master Data'!A105=\"\",\"\",'Master Data'!A105)","v":100},{"$f":"IF('Master Data'!B105=\"\",\"\",'Master Data'!B105)","v":"Ashwini Kumar 100"}]

{"sheet":"Deductions3","index":3,"n_rows":104,"n_cols":33,"rows_kept":104,"merged":[[0,0,0,13],[1,0,1,13]]}
["All Staff IT Calculator 2024-25 By Ashwini Kumar Excel"]
["Office Name - www.ashwinisharma.com"]
[]
["Sr.No.","Employee Name","80CCD(1)","80CCD(1B) (Max 50,000)","80 D (25000/\n50000 (Sr.Citi.)","80DD (75000/\n125000)","80DDB (40000/\n100000","80E","80G (50%/100%","80U (75000/ 125000","80GGA","80EE","80EEA","TDS/ Tax other than Salary"]
[{"$f":"IF('Master Data'!A6=\"\",\"\",'Master Data'!A6)","v":1},{"$f":"IF('Master Data'!B6=\"\",\"\",'Master Data'!B6)","v":"Ashwini Kumar 1"},{"$nulls":29},1,"2024-03-01"]
[{"$f":"IF('Master Data'!A7=\"\",\"\",'Master Data'!A7)","v":2},{"$f":"IF('Master Data'!B7=\"\",\"\",'Master Data'!B7)","v":"Arun Kumar"},{"$nulls":29},2,"2024-04-01"]
[{"$f":"IF('Master Data'!A8=\"\",\"\",'Master Data'!A8)","v":3},{"$f":"IF('Master Data'!B8=\"\",\"\",'Master Data'!B8)","v":"Dhirendra Kumar"},{"$nulls":29},3,"2024-05-01"]
[{"$f":"IF('Master Data'!A9=\"\",\"\",'Master Data'!A9)","v":4},{"$f":"IF('Master Data'!B9=\"\",\"\",'Master Data'!B9)","v":"Ashwini Kumar 4"},{"$nulls":29},4,"2024-06-01"]
[{"$f":"IF('Master Data'!A10=\"\",\"\",'Master Data'!A10)","v":5},{"$f":"IF('Master Data'!B10=\"\",\"\",'Master Data'!B10)","v":"Ashwini Kumar 5"},{"$nulls":29},5,"2024-07-01"]
[{"$f":"IF('Master Data'!A11=\"\",\"\",'Master Data'!A11)","v":6},{"$f":"IF('Master Data'!B11=\"\",\"\",'Master Data'!B11)","v":"Ashwini Kumar 6"},{"$nulls":29},6,"2024-08-01"]
[{"$f":"IF('Master Data'!A12=\"\",\"\",'Master Data'!A12)","v":7},{"$f":"IF('Master Data'!B12=\"\",\"\",'Master Data'!B12)","v":"Ashwini Kumar 7"},{"$nulls":29},7,"2024-09-01"]
[{"$f":"IF('Master Data'!A13=\"\",\"\",'Master Data'!A13)","v":8},{"$f":"IF('Master Data'!B13=\"\",\"\",'Master Data'!B13)","v":"Ashwini Kumar 8"},{"$nulls":29},8,"2024-10-01"]
[{"$f":"IF('Master Data'!A14=\"\",\"\",'Master Data'!A14)","v":9},{"$f":"IF('Master Data'!B14=\"\",\"\",'Master Data'!B14)","v":"Ashwini Kumar 9"},{"$nulls":29},9,"2024-11-01"]
[{"$f":"IF('Master Data'!A15=\"\",\"\",'Master Data'!A15)","v":10},{"$f":"IF('Master Data'!B15=\"\",\"\",'Master Data'!B15)","v":"Ashwini Kumar 10"},{"$nulls":29},10,"2024-12-01"]
[{"$f":"IF('Master Data'!A16=\"\",\"\",'Master Data'!A16)","v":11},{"$f":"IF('Master Data'!B16=\"\",\"\",'Master Data'!B16)","v":"Ashwini Kumar 11"},{"$nulls":29},11,"2025-01-01"]
[{"$f":"IF('Master Data'!A17=\"\",\"\",'Master Data'!A17)","v":12},{"$f":"IF('Master Data'!B17=\"\",\"\",'Master Data'!B17)","v":"Ashwini Kumar 12"},{"$nulls":29},12,"2025-02-01"]
[{"$f":"IF('Master Data'!A18=\"\",\"\",'Master Data'!A18)","v":13},{"$f":"IF('Master Data'!B18=\"\",\"\",'Master Data'!B18)","v":"Ashwini Kumar 13"}]
[{"$f":"IF('Master Data'!A19=\"\",\"\",'Master Data'!A19)","v":14},{"$f":"IF('Master Data'!B19=\"\",\"\",'Master Data'!B19)","v":"Ashwini Kumar 14"}]
[{"$f":"IF('Master Data'!A20=\"\",\"\",'Master Data'!A20)","v":15},{"$f":"IF('Master Data'!B20=\"\",\"\",'Master Data'!B20)","v":"Ashwini Kumar 15"}]
[{"$f":"IF('Master Data'!A21=\"\",\"\",'Master Data'!A21)","v":16},{"$f":"IF('Master Data'!B21=\"\",\"\",'Master Data'!B21)","v":"Ashwini Kumar 16"}]
[{"$f":"IF('Master Data'!A22=\"\",\"\",'Master Data'!A22)","v":17},{"$f":"IF('Master Data'!B22=\"\",\"\",'Master Data'!B22)","v":"Ashwini Kumar 17"}]
[{"$f":"IF('Master Data'!A23=\"\",\"\",'Master Data'!A23)","v":18},{"$f":"IF('Master Data'!B23=\"\",\"\",'Master Data'!B23)","v":"Ashwini Kumar 18"}]
[{"$f":"IF('Master Data'!A24=\"\",\"\",'Master Data'!A24)","v":19},{"$f":"IF('Master Data'!B24=\"\",\"\",'Master Data'!B24)","v":"Ashwini Kumar 19"}]
[{"$f":"IF('Master Data'!A25=\"\",\"\",'Master Data'!A25)","v":20},{"$f":"IF('Master Data'!B25=\"\",\"\",'Master Data'!B25)","v":"Ashwini Kumar 20"}]
[{"$f":"IF('Master Data'!A26=\"\",\"\",'Master Data'!A26)","v":21},{"$f":"IF('Master Data'!B26=\"\",\"\",'Master Data'!B26)","v":"Ashwini Kumar 21"}]
[{"$f":"IF('Master Data'!A27=\"\",\"\",'Master Data'!A27)","v":22},{"$f":"IF('Master Data'!B27=\"\",\"\",'Master Data'!B27)","v":"Ashwini Kumar 22"}]
[{"$f":"IF('Master Data'!A28=\"\",\"\",'Master Data'!A28)","v":23},{"$f":"IF('Master Data'!B28=\"\",\"\",'Master Data'!B28)","v":"Ashwini Kumar 23"}]
[{"$f":"IF('Master Data'!A29=\"\",\"\",'Master Data'!A29)","v":24},{"$f":"IF('Master Data'!B29=\"\",\"\",'Master Data'!B29)","v":"Ashwini Kumar 24"}]
[{"$f":"IF('Master Data'!A30=\"\",\"\",'Master Data'!A30)","v":25},{"$f":"IF('Master Data'!B30=\"\",\"\",'Master Data'!B30)","v":"Ashwini Kumar 25"}]
[{"$f":"IF('Master Data'!A31=\"\",\"\",'Master Data'!A31)","v":26},{"$f":"IF('Master Data'!B31=\"\",\"\",'Master Data'!B31)","v":"Ashwini Kumar 26"}]
[{"$f":"IF('Master Data'!A32=\"\",\"\",'Master Data'!A32)","v":27},{"$f":"IF('Master Data'!B32=\"\",\"\",'Master Data'!B32)","v":"Ashwini Kumar 27"}]
[{"$f":"IF('Master Data'!A33=\"\",\"\",'Master Data'!A33)","v":28},{"$f":"IF('Master Data'!B33=\"\",\"\",'Master Data'!B33)","v":"Ashwini Kumar 28"}]
[{"$f":"IF('Master Data'!A34=\"\",\"\",'Master Data'!A34)","v":29},{"$f":"IF('Master Data'!B34=\"\",\"\",'Master Data'!B34)","v":"Ashwini Kumar 29"}]
[{"$f":"IF('Master Data'!A35=\"\",\"\",'Master Data'!A35)","v":30},{"$f":"IF('Master Data'!B35=\"\",\"\",'Master Data'!B35)","v":"Ashwini Kumar 30"}]
[{"$f":"IF('Master Data'!A36=\"\",\"\",'Master Data'!A36)","v":31},{"$f":"IF('Master Data'!B36=\"\",\"\",'Master Data'!B36)","v":"Ashwini Kumar 31"}]
[{"$f":"IF('Master Data'!A37=\"\",\"\",'Master Data'!A37)","v":32},{"$f":"IF('Master Data'!B37=\"\",\"\",'Master Data'!B37)","v":"Ashwini Kumar 32"}]
[{"$f":"IF('Master Data'!A38=\"\",\"\",'Master Data'!A38)","v":33},{"$f":"IF('Master Data'!B38=\"\",\"\",'Master Data'!B38)","v":"Ashwini Kumar 33"}]
[{"$f":"IF('Master Data'!A39=\"\",\"\",'Master Data'!A39)","v":34},{"$f":"IF('Master Data'!B39=\"\",\"\",'Master Data'!B39)","v":"Ashwini Kumar 34"}]
[{"$f":"IF('Master Data'!A40=\"\",\"\",'Master Data'!A40)","v":35},{"$f":"IF('Master Data'!B40=\"\",\"\",'Master Data'!B40)","v":"Ashwini Kumar 35"}]
[{"$f":"IF('Master Data'!A41=\"\",\"\",'Master Data'!A41)","v":36},{"$f":"IF('Master Data'!B41=\"\",\"\",'Master Data'!B41)","v":"Ashwini Kumar 36"}]
[{"$f":"IF('Master Data'!A42=\"\",\"\",'Master Data'!A42)","v":37},{"$f":"IF('Master Data'!B42=\"\",\"\",'Master Data'!B42)","v":"Ashwini Kumar 37"}]
[{"$f":"IF('Master Data'!A43=\"\",\"\",'Master Data'!A43)","v":38},{"$f":"IF('Master Data'!B43=\"\",\"\",'Master Data'!B43)","v":"Ashwini Kumar 38"}]
[{"$f":"IF('Master Data'!A44=\"\",\"\",'Master Data'!A44)","v":39},{"$f":"IF('Master Data'!B44=\"\",\"\",'Master Data'!B44)","v":"Ashwini Kumar 39"}]
[{"$f":"IF('Master Data'!A45=\"\",\"\",'Master Data'!A45)","v":40},{"$f":"IF('Master Data'!B45=\"\",\"\",'Master Data'!B45)","v":"Ashwini Kumar 40"}]
[{"$f":"IF('Master Data'!A46=\"\",\"\",'Master Data'!A46)","v":41},{"$f":"IF('Master Data'!B46=\"\",\"\",'Master Data'!B46)","v":"Ashwini Kumar 41"}]
[{"$f":"IF('Master Data'!A47=\"\",\"\",'Master Data'!A47)","v":42},{"$f":"IF('Master Data'!B47=\"\",\"\",'Master Data'!B47)","v":"Ashwini Kumar 42"}]
[{"$f":"IF('Master Data'!A48=\"\",\"\",'Master Data'!A48)","v":43},{"$f":"IF('Master Data'!B48=\"\",\"\",'Master Data'!B48)","v":"Ashwini Kumar 43"}]
[{"$f":"IF('Master Data'!A49=\"\",\"\",'Master Data'!A49)","v":44},{"$f":"IF('Master Data'!B49=\"\",\"\",'Master Data'!B49)","v":"Ashwini Kumar 44"}]
[{"$f":"IF('Master Data'!A50=\"\",\"\",'Master Data'!A50)","v":45},{"$f":"IF('Master Data'!B50=\"\",\"\",'Master Data'!B50)","v":"Ashwini Kumar 45"}]
[{"$f":"IF('Master Data'!A51=\"\",\"\",'Master Data'!A51)","v":46},{"$f":"IF('Master Data'!B51=\"\",\"\",'Master Data'!B51)","v":"Ashwini Kumar 46"}]
[{"$f":"IF('Master Data'!A52=\"\",\"\",'Master Data'!A52)","v":47},{"$f":"IF('Master Data'!B52=\"\",\"\",'Master Data'!B52)","v":"Ashwini Kumar 47"}]
[{"$f":"IF('Master Data'!A53=\"\",\"\",'Master Data'!A53)","v":48},{"$f":"IF('Master Data'!B53=\"\",\"\",'Master Data'!B53)","v":"Ashwini Kumar 48"}]
[{"$f":"IF('Master Data'!A54=\"\",\"\",'Master Data'!A54)","v":49},{"$f":"IF('Master Data'!B54=\"\",\"\",'Master Data'!B54)","v":"Ashwini Kumar 49"}]
[{"$f":"IF('Master Data'!A55=\"\",\"\",'Master Data'!A55)","v":50},{"$f":"IF('Master Data'!B55=\"\",\"\",'Master Data'!B55)","v":"Ashwini Kumar 50"}]
[{"$f":"IF('Master Data'!A56=\"\",\"\",'Master Data'!A56)","v":51},{"$f":"IF('Master Data'!B56=\"\",\"\",'Master Data'!B56)","v":"Ashwini Kumar 51"}]
[{"$f":"IF('Master Data'!A57=\"\",\"\",'Master Data'!A57)","v":52},{"$f":"IF('Master Data'!B57=\"\",\"\",'Master Data'!B57)","v":"Ashwini Kumar 52"}]
[{"$f":"IF('Master Data'!A58=\"\",\"\",'Master Data'!A58)","v":53},{"$f":"IF('Master Data'!B58=\"\",\"\",'Master Data'!B58)","v":"Ashwini Kumar 53"}]
[{"$f":"IF('Master Data'!A59=\"\",\"\",'Master Data'!A59)","v":54},{"$f":"IF('Master Data'!B59=\"\",\"\",'Master Data'!B59)","v":"Ashwini Kumar 54"}]
[{"$f":"IF('Master Data'!A60=\"\",\"\",'Master Data'!A60)","v":55},{"$f":"IF('Master Data'!B60=\"\",\"\",'Master Data'!B60)","v":"Ashwini Kumar 55"}]
[{"$f":"IF('Master Data'!A61=\"\",\"\",'Master Data'!A61)","v":56},{"$f":"IF('Master Data'!B61=\"\",\"\",'Master Data'!B61)","v":"Ashwini Kumar 56"}]
[{"$f":"IF('Master Data'!A62=\"\",\"\",'Master Data'!A62)","v":57},{"$f":"IF('Master Data'!B62=\"\",\"\",'Master Data'!B62)","v":"Ashwini Kumar 57"}]
[{"$f":"IF('Master Data'!A63=\"\",\"\",'Master Data'!A63)","v":58},{"$f":"IF('Master Data'!B63=\"\",\"\",'Master Data'!B63)","v":"Ashwini Kumar 58"}]
[{"$f":"IF('Master Data'!A64=\"\",\"\",'Master Data'!A64)","v":59},{"$f":"IF('Master Data'!B64=\"\",\"\",'Master Data'!B64)","v":"Ashwini Kumar 59"}]
[{"$f":"IF('Master Data'!A65=\"\",\"\",'Master Data'!A65)","v":60},{"$f":"IF('Master Data'!B65=\"\",\"\",'Master Data'!B65)","v":"Ashwini Kumar 60"}]
[{"$f":"IF('Master Data'!A66=\"\",\"\",'Master Data'!A66)","v":61},{"$f":"IF('Master Data'!B66=\"\",\"\",'Master Data'!B66)","v":"Ashwini Kumar 61"}]
[{"$f":"IF('Master Data'!A67=\"\",\"\",'Master Data'!A67)","v":62},{"$f":"IF('Master Data'!B67=\"\",\"\",'Master Data'!B67)","v":"Ashwini Kumar 62"}]
[{"$f":"IF('Master Data'!A68=\"\",\"\",'Master Data'!A68)","v":63},{"$f":"IF('Master Data'!B68=\"\",\"\",'Master Data'!B68)","v":"Ashwini Kumar 63"}]
[{"$f":"IF('Master Data'!A69=\"\",\"\",'Master Data'!A69)","v":64},{"$f":"IF('Master Data'!B69=\"\",\"\",'Master Data'!B69)","v":"Ashwini Kumar 64"}]
[{"$f":"IF('Master Data'!A70=\"\",\"\",'Master Data'!A70)","v":65},{"$f":"IF('Master Data'!B70=\"\",\"\",'Master Data'!B70)","v":"Ashwini Kumar 65"}]
[{"$f":"IF('Master Data'!A71=\"\",\"\",'Master Data'!A71)","v":66},{"$f":"IF('Master Data'!B71=\"\",\"\",'Master Data'!B71)","v":"Ashwini Kumar 66"}]
[{"$f":"IF('Master Data'!A72=\"\",\"\",'Master Data'!A72)","v":67},{"$f":"IF('Master Data'!B72=\"\",\"\",'Master Data'!B72)","v":"Ashwini Kumar 67"}]
[{"$f":"IF('Master Data'!A73=\"\",\"\",'Master Data'!A73)","v":68},{"$f":"IF('Master Data'!B73=\"\",\"\",'Master Data'!B73)","v":"Ashwini Kumar 68"}]
[{"$f":"IF('Master Data'!A74=\"\",\"\",'Master Data'!A74)","v":69},{"$f":"IF('Master Data'!B74=\"\",\"\",'Master Data'!B74)","v":"Ashwini Kumar 69"}]
[{"$f":"IF('Master Data'!A75=\"\",\"\",'Master Data'!A75)","v":70},{"$f":"IF('Master Data'!B75=\"\",\"\",'Master Data'!B75)","v":"Ashwini Kumar 70"}]
[{"$f":"IF('Master Data'!A76=\"\",\"\",'Master Data'!A76)","v":71},{"$f":"IF('Master Data'!B76=\"\",\"\",'Master Data'!B76)","v":"Ashwini Kumar 71"}]
[{"$f":"IF('Master Data'!A77=\"\",\"\",'Master Data'!A77)","v":72},{"$f":"IF('Master Data'!B77=\"\",\"\",'Master Data'!B77)","v":"Ashwini Kumar 72"}]
[{"$f":"IF('Master Data'!A78=\"\",\"\",'Master Data'!A78)","v":73},{"$f":"IF('Master Data'!B78=\"\",\"\",'Master Data'!B78)","v":"Ashwini Kumar 73"}]
[{"$f":"IF('Master Data'!A79=\"\",\"\",'Master Data'!A79)","v":74},{"$f":"IF('Master Data'!B79=\"\",\"\",'Master Data'!B79)","v":"Ashwini Kumar 74"}]
[{"$f":"IF('Master Data'!A80=\"\",\"\",'Master Data'!A80)","v":75},{"$f":"IF('Master Data'!B80=\"\",\"\",'Master Data'!B80)","v":"Ashwini Kumar 75"}]
[{"$f":"IF('Master Data'!A81=\"\",\"\",'Master Data'!A81)","v":76},{"$f":"IF('Master Data'!B81=\"\",\"\",'Master Data'!B81)","v":"Ashwini Kumar 76"}]
[{"$f":"IF('Master Data'!A82=\"\",\"\",'Master Data'!A82)","v":77},{"$f":"IF('Master Data'!B82=\"\",\"\",'Master Data'!B82)","v":"Ashwini Kumar 77"}]
[{"$f":"IF('Master Data'!A83=\"\",\"\",'Master Data'!A83)","v":78},{"$f":"IF('Master Data'!B83=\"\",\"\",'Master Data'!B83)","v":"Ashwini Kumar 78"}]
[{"$f":"IF('Master Data'!A84=\"\",\"\",'Master Data'!A84)","v":79},{"$f":"IF('Master Data'!B84=\"\",\"\",'Master Data'!B84)","v":"Ashwini Kumar 79"}]
[{"$f":"IF('Master Data'!A85=\"\",\"\",'Master Data'!A85)","v":80},{"$f":"IF('Master Data'!B85=\"\",\"\",'Master Data'!B85)","v":"Ashwini Kumar 80"}]
[{"$f":"IF('Master Data'!A86=\"\",\"\",'Master Data'!A86)","v":81},{"$f":"IF('Master Data'!B86=\"\",\"\",'Master Data'!B86)","v":"Ashwini Kumar 81"}]
[{"$f":"IF('Master Data'!A87=\"\",\"\",'Master Data'!A87)","v":82},{"$f":"IF('Master Data'!B87=\"\",\"\",'Master Data'!B87)","v":"Ashwini Kumar 82"}]
[{"$f":"IF('Master Data'!A88=\"\",\"\",'Master Data'!A88)","v":83},{"$f":"IF('Master Data'!B88=\"\",\"\",'Master Data'!B88)","v":"Ashwini Kumar 83"}]
[{"$f":"IF('Master Data'!A89=\"\",\"\",'Master Data'!A89)","v":84},{"$f":"IF('Master Data'!B89=\"\",\"\",'Master Data'!B89)","v":"Ashwini Kumar 84"}]
[{"$f":"IF('Master Data'!A90=\"\",\"\",'Master Data'!A90)","v":85},{"$f":"IF('Master Data'!B90=\"\",\"\",'Master Data'!B90)","v":"Ashwini Kumar 85"}]
[{"$f":"IF('Master Data'!A91=\"\",\"\",'Master Data'!A91)","v":86},{"$f":"IF('Master Data'!B91=\"\",\"\",'Master Data'!B91)","v":"Ashwini Kumar 86"}]
[{"$f":"IF('Master Data'!A92=\"\",\"\",'Master Data'!A92)","v":87},{"$f":"IF('Master Data'!B92=\"\",\"\",'Master Data'!B92)","v":"Ashwini Kumar 87"}]
[{"$f":"IF('Master Data'!A93=\"\",\"\",'Master Data'!A93)","v":88},{"$f":"IF('Master Data'!B93=\"\",\"\",'Master Data'!B93)","v":"Ashwini Kumar 88"}]
[{"$f":"IF('Master Data'!A94=\"\",\"\",'Master Data'!A94)","v":89},{"$f":"IF('Master Data'!B94=\"\",\"\",'Master Data'!B94)","v":"Ashwini Kumar 89"}]
[{"$f":"IF('Master Data'!A95=\"\",\"\",'Master Data'!A95)","v":90},{"$f":"IF('Master Data'!B95=\"\",\"\",'Master Data'!B95)","v":"Ashwini Kumar 90"}]
[{"$f":"IF('Master Data'!A96=\"\",\"\",'Master Data'!A96)","v":91},{"$f":"IF('Master Data'!B96=\"\",\"\",'Master Data'!B96)","v":"Ashwini Kumar 91"}]
[{"$f":"IF('Master Data'!A97=\"\",\"\",'Master Data'!A97)","v":92},{"$f":"IF('Master Data'!B97=\"\",\"\",'Master Data'!B97)","v":"Ashwini Kumar 92"}]
[{"$f":"IF('Master Data'!A98=\"\",\"\",'Master Data'!A98)","v":93},{"$f":"IF('Master Data'!B98=\"\",\"\",'Master Data'!B98)","v":"Ashwini Kumar 93"}]
[{"$f":"IF('Master Data'!A99=\"\",\"\",'Master Data'!A99)","v":94},{"$f":"IF('Master Data'!B99=\"\",\"\",'Master Data'!B99)","v":"Ashwini Kumar 94"}]
[{"$f":"IF('Master Data'!A100=\"\",\"\",'Master Data'!A100)","v":95},{"$f":"IF('Master Data'!B100=\"\",\"\",'Master Data'!B100)","v":"Ashwini Kumar 95"}]
[{"$f":"IF('Master Data'!A101=\"\",\"\",'Master Data'!A101)","v":96},{"$f":"IF('Master Data'!B101=\"\",\"\",'Master Data'!B101)","v":"Ashwini Kumar 96"}]
[{"$f":"IF('Master Data'!A102=\"\",\"\",'Master Data'!A102)","v":97},{"$f":"IF('Master Data'!B102=\"\",\"\",'Master Data'!B102)","v":"Ashwini Kumar 97"}]
[{"$f":"IF('Master Data'!A103=\"\",\"\",'Master Data'!A103)","v":98},{"$f":"IF('Master Data'!B103=\"\",\"\",'Master Data'!B103)","v":"Ashwini Kumar 98"}]
[{"$f":"IF('Master Data'!A104=\"\",\"\",'Master Data'!A104)","v":99},{"$f":"IF('Master Data'!B104=\"\",\"\",'Master Data'!B104)","v":"Ashwini Kumar 99"}]
[{"$f":"IF('Master Data'!A105=\"\",\"\",'Master Data'!A105)","v":100},{"$f":"IF('Master Data'!B105=\"\",\"\",'Master Data'!B105)","v":"Ashwini Kumar 100"}]

{"sheet":"GA 55A","index":4,"n_rows":30,"n_cols":37,"rows_kept":30,"merged":[[0,0,0,23],[1,2,1,22],[3,1,3,3],[3,4,3,8],[3,10,3,11],[3,12,3,15],[3,17,3,18],[3,19,3,22],[19,30,19,33],[28,0,28,2],[28,22,28,23],[29,6,29,17]]}
[{"$f":"'Master Data'!A2","v":"Office Name - www.ashwinisharma.com"}]
["Emp No.",1,"Salary and Deduction Detail for FY : 2024-25"]
[]
[null,"Name of Employee-",null,null,{"$f":"VLOOKUP($B$2,Master_Data,2,0)","v":"Ashwini Kumar 1"},{"$nulls":5},"Post",null,{"$f":"VLOOKUP($B$2,Master_Data,3,0)","v":"Lecturer"},{"$nulls":4},"PAN No.",null,{"$f":"VLOOKUP($B$2,Master_Data,4,0)","v":"AAAAA5921A"}]
[]
["Month & Year","Basic Pay","DA","HRA","Bonus","Wash Allowance","Handi. Allowance","CCA Allowance","Other Allowance","Gross Salary","SIP","SI Loan","SI Loan Interest","GPF/\nGPF2004","GPF Loan","RGHS","GIS","LIC","Hitkari Nidhi","Other Ded1","Other Ded2","ITAX","Total Deduction","NET Payment"]
["2024-03-01",{"$f":"VLOOKUP($B$2,Master_Data,5,0)","v":{"v":51400,"d":"51,400"}},{"$f":"IFERROR(ROUND(B7*50%,0),0)","v":{"v":25700,"d":"25,700"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B7*9%,B7*18%),0)","v":{"v":4626,"d":"4,626"}},null,{"$f":"VLOOKUP($B$2,Master_Data,11,0)","v":0},{"$f":"VLOOKUP($B$2,Master_Data,12,0)","v":0},{"$f":"VLOOKUP($B$2,Master_Data,10,0)","v":0},{"$f":"VLOOKUP($B$2,Master_Data,13,0)","v":0},{"$f":"SUM(B7:I7)","v":{"v":81726,"d":"81,726"}},{"$f":"VLOOKUP($B$2,Ded_1,3,0)","v":{"v":3000,"d":"3,000"}},null,null,{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B7<23101,1450,IF(B7<28501,1625,IF(B7<38501,2100,IF(B7<51501,2850,IF(B7<62001,3575,IF(B7<72001,4200,IF(B7<80001,4800,IF(B7<116001,6150,IF(B7<167001,8900,10500))))))))))","v":{"v":2850,"d":"2,850"}},null,{"$f":"IF(B7<18001,265,IF(B7<33501,440,IF(B7<54001,658,875)))","v":658},null,{"$f":"VLOOKUP($B$2,Ded_1,7,0)","v":0},null,{"$f":"VLOOKUP($B$2,Ded_1,8,0)","v":0},{"$f":"VLOOKUP($B$2,Ded_1,9,0)","v":0},{"$f":"VLOOKUP($B$2,Ded_1,10,0)","v":0},{"$f":"SUM(K7:V7)","v":{"v":6508,"d":"6,508"}},{"$f":"J7-W7","v":{"v":75218,"d":"75,218"}},{"$nulls":6},"2024-03-01",{"$f":"B7","v":{"v":51400,"d":"51,400"}},{"v":0.5,"d":"50%"},{"$f":"C7","v":{"v":25700,"d":"25,700"}}]
["2024-04-01",{"$f":"B7","v":{"v":51400,"d":"51,400"}},{"$f":"IFERROR(ROUND(B7*50%,0),0)","v":{"v":25700,"d":"25,700"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B8*9%,B8*18%),0)","v":{"v":4626,"d":"4,626"}},null,{"$f":"F7","v":0},{"$f":"G7","v":0},{"$f":"H7","v":0},{"$f":"I7","v":0},{"v":81726,"d":"81,726"},{"$f":"K7","v":{"v":3000,"d":"3,000"}},{"$f":"L7","v":0},{"$f":"M7","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B8<23101,1450,IF(B8<28501,1625,IF(B8<38501,2100,IF(B8<51501,2850,IF(B8<62001,3575,IF(B8<72001,4200,IF(B8<80001,4800,IF(B8<116001,6150,IF(B8<167001,8900,10500))))))))))","v":{"v":2850,"d":"2,850"}},{"$f":"O7","v":0},{"$f":"IF(B8<18001,265,IF(B8<33501,440,IF(B8<54001,658,875)))","v":658},{"$f":"VLOOKUP($B$2,Ded_1,5,0)","v":700},{"$f":"R7","v":0},null,{"$f":"T7","v":0},{"$f":"U7","v":0},{"$f":"VLOOKUP($B$2,Ded_1,11,0)","v":0},{"v":7208,"d":"7,208"},{"v":74518,"d":"74,518"},{"$nulls":6},"2024-04-01",{"$f":"B7","v":{"v":51400,"d":"51,400"}},{"v":0.5,"d":"50%"},{"v":25700,"d":"25,700"}]
["2024-05-01",{"$f":"B7","v":{"v":51400,"d":"51,400"}},{"$f":"IFERROR(ROUND(B9*50%,0),0)","v":{"v":25700,"d":"25,700"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B9*9%,B9*18%),0)","v":{"v":4626,"d":"4,626"}},null,{"$f":"F8","v":0},{"$f":"G8","v":0},{"$f":"H8","v":0},{"$f":"I8","v":0},{"v":81726,"d":"81,726"},{"$f":"K8","v":{"v":3000,"d":"3,000"}},{"$f":"L8","v":0},{"$f":"M8","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B9<23101,1450,IF(B9<28501,1625,IF(B9<38501,2100,IF(B9<51501,2850,IF(B9<62001,3575,IF(B9<72001,4200,IF(B9<80001,4800,IF(B9<116001,6150,IF(B9<167001,8900,10500))))))))))","v":{"v":2850,"d":"2,850"}},{"$f":"O8","v":0},{"$f":"IF(B9<18001,265,IF(B9<33501,440,IF(B9<54001,658,875)))","v":658},null,{"$f":"R8","v":0},null,{"$f":"T8","v":0},{"$f":"U8","v":0},{"$f":"VLOOKUP($B$2,Ded_1,12,0)","v":0},{"v":6508,"d":"6,508"},{"v":75218,"d":"75,218"},{"$nulls":6},"2024-05-01",{"$f":"B9","v":{"v":51400,"d":"51,400"}},{"v":0.5,"d":"50%"},{"v":25700,"d":"25,700"}]
["2024-06-01",{"$f":"B9","v":{"v":51400,"d":"51,400"}},{"$f":"IFERROR(ROUND(B10*50%,0),0)","v":{"v":25700,"d":"25,700"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B10*9%,B10*18%),0)","v":{"v":4626,"d":"4,626"}},null,{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0},{"$f":"I9","v":0},{"v":81726,"d":"81,726"},{"$f":"K9","v":{"v":3000,"d":"3,000"}},{"$f":"L9","v":0},{"$f":"M9","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B10<23101,1450,IF(B10<28501,1625,IF(B10<38501,2100,IF(B10<51501,2850,IF(B10<62001,3575,IF(B10<72001,4200,IF(B10<80001,4800,IF(B10<116001,6150,IF(B10<167001,8900,10500))))))))))","v":{"v":2850,"d":"2,850"}},{"$f":"O9","v":0},{"$f":"IF(B10<18001,265,IF(B10<33501,440,IF(B10<54001,658,875)))","v":658},null,{"$f":"R9","v":0},null,{"$f":"T9","v":0},{"$f":"U9","v":0},{"$f":"VLOOKUP($B$2,Ded_1,13,0)","v":0},{"v":6508,"d":"6,508"},{"v":75218,"d":"75,218"},{"$nulls":6},"2024-06-01",{"v":51400,"d":"51,400"},{"v":0.5,"d":"50%"},{"v":25700,"d":"25,700"}]
["2024-07-01",{"$f":"IFERROR(MROUND(B10*1.03,100),0)","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B11*50%,0),0)","v":{"v":26450,"d":"26,450"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B11*9%,B11*18%),0)","v":{"v":4761,"d":"4,761"}},null,{"$f":"F10","v":0},{"$f":"G10","v":0},{"$f":"H10","v":0},{"$f":"I10","v":0},{"v":84111,"d":"84,111"},{"$f":"K10","v":{"v":3000,"d":"3,000"}},{"$f":"L10","v":0},{"$f":"M10","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B11<23101,1450,IF(B11<28501,1625,IF(B11<38501,2100,IF(B11<51501,2850,IF(B11<62001,3575,IF(B11<72001,4200,IF(B11<80001,4800,IF(B11<116001,6150,IF(B11<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O10","v":0},{"$f":"IF(B11<18001,265,IF(B11<33501,440,IF(B11<54001,658,875)))","v":658},null,{"$f":"R10","v":0},null,{"$f":"T10","v":0},{"$f":"U10","v":0},{"$f":"VLOOKUP($B$2,Ded_1,14,0)","v":0},{"v":7233,"d":"7,233"},{"v":76878,"d":"76,878"},{"$nulls":6},"2024-07-01",{"v":52900,"d":"52,900"},{"v":0.5,"d":"50%"},{"v":26450,"d":"26,450"},{"$f":"ROUND(AF11/2*3%,0)","v":794},null,{"$f":"VLOOKUP($B$2,Master_Data,5,0)","v":51400}]
["2024-08-01",{"$f":"B11","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B12*50%,0),0)","v":{"v":26450,"d":"26,450"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B12*9%,B12*18%),0)","v":{"v":4761,"d":"4,761"}},null,{"$f":"F11","v":0},{"$f":"G11","v":0},{"$f":"H11","v":0},{"$f":"I11","v":0},{"v":84111,"d":"84,111"},{"$f":"K11","v":{"v":3000,"d":"3,000"}},{"$f":"L11","v":0},{"$f":"M11","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B12<23101,1450,IF(B12<28501,1625,IF(B12<38501,2100,IF(B12<51501,2850,IF(B12<62001,3575,IF(B12<72001,4200,IF(B12<80001,4800,IF(B12<116001,6150,IF(B12<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O11","v":0},{"$f":"IF(B12<18001,265,IF(B12<33501,440,IF(B12<54001,658,875)))","v":658},null,{"$f":"R11","v":0},null,{"$f":"T11","v":0},{"$f":"U11","v":0},{"$f":"VLOOKUP($B$2,Ded_1,15,0)","v":0},{"v":7233,"d":"7,233"},{"v":76878,"d":"76,878"},{"$nulls":6},"2024-08-01",{"v":52900,"d":"52,900"},{"v":0.5,"d":"50%"},{"v":26450,"d":"26,450"},{"$f":"ROUND(AF12/2*3%,0)","v":794}]
["2024-09-01",{"$f":"B12","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B13*50%,0),0)","v":{"v":26450,"d":"26,450"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B13*9%,B13*18%),0)","v":{"v":4761,"d":"4,761"}},null,{"$f":"F12","v":0},{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0},{"v":84111,"d":"84,111"},{"$f":"K12","v":{"v":3000,"d":"3,000"}},{"$f":"L12","v":0},{"$f":"M12","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B13<23101,1450,IF(B13<28501,1625,IF(B13<38501,2100,IF(B13<51501,2850,IF(B13<62001,3575,IF(B13<72001,4200,IF(B13<80001,4800,IF(B13<116001,6150,IF(B13<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O12","v":0},{"$f":"IF(B13<18001,265,IF(B13<33501,440,IF(B13<54001,658,875)))","v":658},null,{"$f":"R12","v":0},null,{"$f":"T12","v":0},{"$f":"U12","v":0},{"$f":"VLOOKUP($B$2,Ded_1,16,0)","v":0},{"v":7233,"d":"7,233"},{"v":76878,"d":"76,878"},{"$nulls":6},"2024-09-01",{"v":52900,"d":"52,900"},{"v":0.5,"d":"50%"},{"v":26450,"d":"26,450"},794]
["2024-10-01",{"$f":"B13","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B14*50%,0),0)","v":{"v":26450,"d":"26,450"}},{"$f":"ROUND(IF(VLOOKUP($B$2,Master_Data,6,0)=10%,B14*9%,B14*18%),0)","v":{"v":4761,"d":"4,761"}},null,{"$f":"F13","v":0},{"$f":"G13","v":0},{"$f":"H13","v":0},{"$f":"I13","v":0},{"v":84111,"d":"84,111"},{"$f":"K13","v":{"v":3000,"d":"3,000"}},{"$f":"L13","v":0},{"$f":"M13","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B14<23101,1450,IF(B14<28501,1625,IF(B14<38501,2100,IF(B14<51501,2850,IF(B14<62001,3575,IF(B14<72001,4200,IF(B14<80001,4800,IF(B14<116001,6150,IF(B14<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O13","v":0},{"$f":"IF(B14<18001,265,IF(B14<33501,440,IF(B14<54001,658,875)))","v":658},null,{"$f":"R13","v":0},null,{"$f":"T13","v":0},{"$f":"U13","v":0},{"$f":"VLOOKUP($B$2,Ded_1,17,0)","v":0},{"v":7233,"d":"7,233"},{"v":76878,"d":"76,878"},{"$nulls":6},"2024-10-01",{"v":52900,"d":"52,900"},{"v":0.5,"d":"50%"},{"v":26450,"d":"26,450"},794]
["2024-11-01",{"$f":"B14","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B15*53%,0),0)","v":{"v":28037,"d":"28,037"}},{"$f":"ROUND(VLOOKUP($B$2,Master_Data,6,0)*B15,0)","v":{"v":5290,"d":"5,290"}},null,{"$f":"F14","v":0},{"$f":"G14","v":0},{"$f":"H14","v":0},{"$f":"I14","v":0},{"v":86227,"d":"86,227"},{"$f":"K14","v":{"v":3000,"d":"3,000"}},{"$f":"L14","v":0},{"$f":"M14","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B15<23101,1450,IF(B15<28501,1625,IF(B15<38501,2100,IF(B15<51501,2850,IF(B15<62001,3575,IF(B15<72001,4200,IF(B15<80001,4800,IF(B15<116001,6150,IF(B15<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O14","v":0},{"$f":"IF(B15<18001,265,IF(B15<33501,440,IF(B15<54001,658,875)))","v":658},null,{"$f":"R14","v":0},null,{"$f":"T14","v":0},{"$f":"U14","v":0},{"$f":"VLOOKUP($B$2,Ded_1,18,0)","v":0},{"v":7233,"d":"7,233"},{"v":78994,"d":"78,994"},{"$nulls":6},"2024-11-01",{"v":52900,"d":"52,900"},{"v":0.53,"d":"53%"},{"v":28037,"d":"28,037"}]
["2024-12-01",{"$f":"B15","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B16*53%,0),0)","v":{"v":28037,"d":"28,037"}},{"$f":"ROUND(VLOOKUP($B$2,Master_Data,6,0)*B16,0)","v":{"v":5290,"d":"5,290"}},null,{"$f":"F15","v":0},{"$f":"G15","v":0},{"$f":"H15","v":0},{"$f":"I15","v":0},{"v":86227,"d":"86,227"},{"$f":"K15","v":{"v":3000,"d":"3,000"}},{"$f":"L15","v":0},{"$f":"M15","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B16<23101,1450,IF(B16<28501,1625,IF(B16<38501,2100,IF(B16<51501,2850,IF(B16<62001,3575,IF(B16<72001,4200,IF(B16<80001,4800,IF(B16<116001,6150,IF(B16<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O15","v":0},{"$f":"IF(B16<18001,265,IF(B16<33501,440,IF(B16<54001,658,875)))","v":658},null,{"$f":"R15","v":0},{"$f":"VLOOKUP($B$2,Ded_1,6,0)","v":250},{"$f":"T15","v":0},{"$f":"U15","v":0},{"$f":"VLOOKUP($B$2,Ded_1,19,0)","v":0},{"v":7483,"d":"7,483"},{"v":78744,"d":"78,744"},{"$nulls":6},"2024-12-01",{"v":52900,"d":"52,900"},{"v":0.53,"d":"53%"},{"v":28037,"d":"28,037"}]
["2025-01-01",{"$f":"B16","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B17*53%,0),0)","v":{"v":28037,"d":"28,037"}},{"$f":"ROUND(VLOOKUP($B$2,Master_Data,6,0)*B17,0)","v":{"v":5290,"d":"5,290"}},null,{"$f":"F16","v":0},{"$f":"G16","v":0},{"$f":"H16","v":0},{"$f":"I16","v":0},{"v":86227,"d":"86,227"},{"$f":"K16","v":{"v":3000,"d":"3,000"}},{"$f":"L16","v":0},{"$f":"M16","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B17<23101,1450,IF(B17<28501,1625,IF(B17<38501,2100,IF(B17<51501,2850,IF(B17<62001,3575,IF(B17<72001,4200,IF(B17<80001,4800,IF(B17<116001,6150,IF(B17<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O16","v":0},{"$f":"IF(B17<18001,265,IF(B17<33501,440,IF(B17<54001,658,875)))","v":658},null,{"$f":"R16","v":0},null,{"$f":"T16","v":0},{"$f":"U16","v":0},{"$f":"VLOOKUP($B$2,Ded_1,20,0)","v":0},{"v":7233,"d":"7,233"},{"v":78994,"d":"78,994"},{"$nulls":6},"2025-01-01",{"v":52900,"d":"52,900"},{"v":0.53,"d":"53%"},{"v":28037,"d":"28,037"}]
["2025-02-01",{"$f":"B17","v":{"v":52900,"d":"52,900"}},{"$f":"IFERROR(ROUND(B18*53%,0),0)","v":{"v":28037,"d":"28,037"}},{"$f":"VLOOKUP($B$2,Master_Data,6,0)*B18","v":{"v":5290,"d":"5,290"}},null,{"$f":"F17","v":0},{"$f":"G17","v":0},{"$f":"H17","v":0},{"$f":"I17","v":0},{"v":86227,"d":"86,227"},{"$f":"K17","v":{"v":3000,"d":"3,000"}},{"$f":"L17","v":0},{"$f":"M17","v":0},{"$f":"IF(VLOOKUP($B$2,Ded_1,4,0)>0,VLOOKUP($B$2,Ded_1,4,0),IF(B18<23101,1450,IF(B18<28501,1625,IF(B18<38501,2100,IF(B18<51501,2850,IF(B18<62001,3575,IF(B18<72001,4200,IF(B18<80001,4800,IF(B18<116001,6150,IF(B18<167001,8900,10500))))))))))","v":{"v":3575,"d":"3,575"}},{"$f":"O17","v":0},{"$f":"IF(B18<18001,265,IF(B18<33501,440,IF(B18<54001,658,875)))","v":658},null,{"$f":"R17","v":0},null,{"$f":"T17","v":0},{"$f":"U17","v":0},{"$f":"VLOOKUP($B$2,Ded_1,21,0)","v":0},{"v":7233,"d":"7,233"},{"v":78994,"d":"78,994"},{"$nulls":6},"2025-02-01",{"v":52900,"d":"52,900"},{"v":0.53,"d":"53%"},{"v":28037,"d":"28,037"}]
["DA Arrear Jan 24 to Feb 24",null,{"$f":"SUM(AF7*4%,AF8*4%)","v":{"v":4112,"d":"4,112"}},{"$nulls":6},{"v":4112,"d":"4,112"},null,0,null,{"$f":"IF(C19=\"\",\"\",C19)","v":{"v":4112,"d":"4,112"}},{"$nulls":8},{"v":4112,"d":"4,112"},0]
["Bonus",{"$nulls":3},{"$f":"IF(VLOOKUP($B$2,Master_Data,7,0)=\"\",\"\",ROUND(6774/12*VLOOKUP($B$2,Master_Data,7,0),0))","v":{"v":6774,"d":"6,774"}},{"$nulls":4},{"v":6774,"d":"6,774"},{"$nulls":3},{"$f":"IFERROR(ROUND(E20*25%,0),0)","v":{"v":1694,"d":"1,694"}},{"$nulls":8},{"v":1694,"d":"1,694"},{"v":5080,"d":"5,080"}]
["Surrender",{"$f":"IFERROR(ROUND(VLOOKUP(VLOOKUP($B$2,Master_Data,9,0),$AE$7:$AI$18,2,0)/2,0),0)","v":25700},{"$f":"IFERROR(ROUND(B21*VLOOKUP(VLOOKUP($B$2,Master_Data,9,0),$AE$7:$AI$18,3,0),0),0)","v":{"v":12850,"d":"12,850"}},{"$nulls":6},{"v":38550,"d":"38,550"},{"$nulls":12},0,{"v":38550,"d":"38,550"}]
["DA Arrear Jul 24 to Oct 24",null,{"$f":"SUM(AF11*3%,AF12*3%,AF13*3%,AF14*3%)","v":{"v":6348,"d":"6,348"}},{"$nulls":6},{"v":6348,"d":"6,348"},{"$nulls":3},{"$f":"IF(C22=\"\",\"\",C22)","v":{"v":6348,"d":"6,348"}},{"$nulls":8},{"v":6348,"d":"6,348"},0]
["Fixation Arrear",{"$nulls":8},0,{"$nulls":12},0,0]
["Salary Arrear1",{"$nulls":8},0,{"$nulls":12},0,0]
["Salary Arrear2",{"$nulls":8},0,{"$nulls":12},0,0,null,{"$f":"VLOOKUP($B$2,Master_Data,5,0)","v":51400}]
["Surrender DA Arrear",null,{"$f":"IF(VLOOKUP($B$2,Master_Data,9,0)=AE11,AI11,IF(VLOOKUP($B$2,Master_Data,9,0)=AE12,AI12,IF(VLOOKUP($B$2,Master_Data,9,0)=AE13,AI13,IF(VLOOKUP($B$2,Master_Data,9,0)=AE14,AI14,0))))","v":0},{"$nulls":6},0,{"$nulls":12},0,0]
["Total",{"$f":"SUM(B7:B26)","v":{"v":654500,"d":"654,500"}},{"v":344058,"d":"344,058"},{"v":58708,"d":"58,708"},{"v":6774,"d":"6,774"},0,0,0,0,{"v":1064040,"d":"1,064,040"},{"v":36000,"d":"36,000"},0,0,{"v":52154,"d":"52,154"},0,{"v":7896,"d":"7,896"},700,0,250,0,0,0,{"v":97000,"d":"97,000"},{"v":967040,"d":"967,040"}]
[]
["Signature Of Employee",{"$nulls":21},"Signature Of DDO"]
[{"$nulls":6},"Software Prepared By Ashwini Kumar : 9166023711 www.ashwinisharma.com"]

{"sheet":"Tax Calculator By Ashwini","index":5,"n_rows":70,"n_cols":24,"rows_kept":70,"merged":[[0,0,0,14],[1,0,1,2],[1,6,1,11],[2,1,2,2],[2,3,2,6],[2,7,2,8],[2,9,2,11],[2,12,2,13],[3,1,3,13],[4,1,4,13],[5,1,5,13],[6,0,9,0],[6,1,6,12],[6,14,8,14],[7,1,7,12],[8,1,8,12],[9,1,9,13],[10,1,10,13],[11,0,14,0],[11,1,11,7],[11,8,11,11],[11,12,11,13],[11,14,13,14],[12,1,13,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,13],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,13],[14,1,14,13],[15,1,15,13],[16,1,16,13],[17,1,17,13],[18,1,18,14],[19,2,19,5],[19,6,19,7],[19,9,19,12],[19,14,28,14],[20,2,20,5],[20,6,20,7],[20,9,20,12],[21,2,21,5],[21,6,21,7],[21,9,21,12],[22,2,22,5],[22,6,22,7],[22,9,22,12],[23,2,23,5],[23,6,23,7],[23,9,23,12],[24,2,24,5],[24,6,24,7],[24,9,24,12],[25,2,25,5],[25,6,25,7],[25,9,25,12],[26,2,26,5],[26,6,26,7],[26,9,26,12],[27,2,27,5],[27,6,27,7],[27,8,28,8],[27,9,28,12],[27,13,28,13],[28,2,28,5],[28,6,28,7],[29,1,29,13],[30,2,30,13],[31,2,31,13],[32,1,32,13],[33,1,33,14],[34,2,34,13],[35,2,35,13],[36,2,36,13],[37,2,37,13],[38,2,38,13],[39,2,39,13],[40,2,40,13],[41,2,41,13],[42,2,42,13],[43,2,43,13],[44,2,44,13],[45,1,45,13],[46,1,46,13],[47,1,47,13],[48,1,48,13],[49,0,61,0],[49,1,49,14],[50,1,50,10],[50,11,50,13],[51,1,51,4],[51,5,51,7],[51,8,51,10],[51,11,51,12],[51,17,51,18],[52,1,52,3],[52,5,52,6],[52,8,52,9],[52,11,52,12],[52,17,52,18],[53,1,53,3],[53,5,53,6],[53,8,53,9],[53,11,53,12],[53,17,53,18],[54,1,54,3],[54,5,54,6],[54,8,54,9],[54,11,54,12],[54,17,54,18],[55,1,56,3],[55,4,56,4],[55,5,56,6],[55,7,56,7],[55,8,56,9],[55,10,56,10],[55,11,55,12],[55,17,55,18],[56,11,56,12],[57,2,57,12],[58,2,58,12],[59,2,59,13],[60,2,60,13],[61,1,61,13],[62,1,62,13],[63,1,63,13],[64,0,66,0],[64,1,64,14],[67,0,67,13],[69,0,69,4],[69,5,69,12],[69,13,69,14]]}
[{"$f":"'Master Data'!A2","v":"Office Name - www.ashwinisharma.com"}]
["Employee No.",null,null,{"$f":"IF('GA 55A'!B2=\"\",\"\",'GA 55A'!B2)","v":1},null,null,"INCOME TAX CALCULATION FORM FY 2024-25",{"$nulls":5},{"$f":"IF(O2=\"New Regime\",1,2)","v":1},"Select Regime","New Regime"]
[1,"Name -",null,{"$f":"VLOOKUP(D2,Master_Data,2,0)","v":"Ashwini Kumar 1"},{"$nulls":3},"Post -",null,{"$f":"VLOOKUP(D2,Master_Data,3,0)","v":"Lecturer"},null,null,"PAN No.- ",null,{"$f":"VLOOKUP(D2,Master_Data,4,0)","v":"AAAAA5921A"}]
[2,"Total salary received in Financial Year 2024-25",{"$nulls":12},{"$f":"IF('GA 55A'!J27=\"\",\"\",'GA 55A'!J27)","v":{"v":1064040,"d":"₹1,064,040.00"}}]
[3,"House rent, under section 10 (13-A) and other allowances under section 10 (14) which are tax free -",{"$nulls":12},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,3,0),0)","v":0}]
[4,"Balance (2-3)",{"$nulls":12},{"$f":"IF(M2=2,O4-O5,O4)","v":{"v":1064040,"d":"₹1,064,040.00"}}]
[5,{"$f":"IF(M2=1,\"Standard Deduction Maxium 75000 Section 16 (i a)\",\"(I)Standard Deduction Maxium 50000 Section 16 (i a)\")","v":"Standard Deduction Maxium 75000 Section 16 (i a)"},{"$nulls":11},{"$f":"IF(M2=1,75000,50000)","v":{"v":75000,"d":"75,000.00"}}]
[null,"(II) Entertainment Allowance under Section 16(ii) Maxium 5000",{"$nulls":11},{"v":0,"d":"0.00"}]
[null,"(III)Business tax under section 16 (iii)",{"$nulls":11},{"v":0,"d":"0.00"}]
[null,"Total 5",{"$nulls":12},{"$f":"SUM(N7:N9)","v":{"v":75000,"d":"₹75,000.00"}}]
[6,"Balance(4-5)",{"$nulls":12},{"$f":"O6-O10","v":{"v":989040,"d":"₹989,040.00"}}]
[7,"(A) Income from house property (1) Nil for own use",{"$nulls":6},"(2) Rent received Rs.",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,4,0),0)","v":{"v":0,"d":"0.00"}}]
[null,"(B) Subtract",null,null,"30% of rent",null,"Home Loan Interest",null,"House Tax",null,"Sum 7 (B)"]
[{"$nulls":4},{"$f":"ROUND($M$12*0.3,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,5,0),0)","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},null,{"$f":"SUM(E14:J14)","v":{"v":0,"d":"0.00"}}]
[null,"Balance - / + (of 7(A) and 7(B)",{"$nulls":12},{"$f":"IF(M2=2,$M$12-$K$14,0)","v":0}]
[8,"Total Balance - / + (6 & 7)",{"$nulls":12},{"$f":"$O$11+$O$15","v":{"v":989040,"d":"₹989,040.00"}}]
[9,"Other Income",{"$nulls":12},{"$f":"SUM(VLOOKUP(D2,Master_Data,15,0),VLOOKUP(D2,Master_Data,16,0),VLOOKUP(D2,Master_Data,17,0))","v":0}]
[10,"Gross Income (Sum 8+9)",{"$nulls":12},{"$f":"SUM(O16:O17)","v":{"v":989040,"d":"₹989,040.00"}}]
[11,"Deductions - Section US 80C, 80CCC, 80CCD(1) (A) Maximum limit Rs 150000 (section 80CCE), other than section 80CCD(2)"]
[null,1,"SI (State Insurance)",{"$nulls":3},{"$f":"IF(M2=2,'GA 55A'!K27,0)","v":{"v":0,"d":"0.00"}},null,11,"EPEF (80CCD1)",{"$nulls":3},{"$f":"VLOOKUP(D2,Ded_2,18,0)","v":{"v":0,"d":"0.00"}}]
[null,2,"LIC",{"$nulls":3},{"$f":"IF(M2=2,SUM('GA 55A'!R27,VLOOKUP(D2,Ded_2,7,0)),0)","v":{"v":0,"d":"0.00"}},null,12,"Contribution for pension plan (80CCC)",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,19,0),0)","v":{"v":0,"d":"0.00"}}]
[null,3,"GPF 2024/ GPF",{"$nulls":3},{"$f":"IF(M2=2,'GA 55A'!N27,0)","v":{"v":0,"d":"0.00"}},null,13,"Interest on national savings certificate",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,12,0),0)","v":{"v":0,"d":"0.00"}}]
[null,4,"National Savings Certificate",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,11,0),0)","v":{"v":0,"d":"0.00"}},null,14,"Tution Fees",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,9,0),0)","v":{"v":0,"d":"0.00"}}]
[null,5,"Public Provident Fund (PPF)",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,13,0),0)","v":{"v":0,"d":"0.00"}},null,15,"Equity Link Saving Scheme",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,16,0),0)","v":{"v":0,"d":"0.00"}}]
[null,6,"National Savings Scheme (NSS)",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,14,0),0)","v":{"v":0,"d":"0.00"}},null,16,"Defferred Annuty",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,17,0),0)","v":{"v":0,"d":"0.00"}}]
[null,7,"GIS",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_1,5,0),0)","v":{"v":0,"d":"0.00"}},null,17,"PLI",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,8,0),0)","v":{"v":0,"d":"0.00"}}]
[null,8,"ULIP/Annual Plan",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,10,0),0)","v":{"v":0,"d":"0.00"}},null,18,"Other deposits under section 80C",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,20,0),0)","v":{"v":0,"d":"0.00"}}]
[null,9,"Home Loan Premium",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,6,0),0)","v":{"v":0,"d":"0.00"}},null,19,"Total from 1 to 18",{"$nulls":3},{"$f":"IF(M2=2,SUM(G20:H29,N20:N27),N20)","v":{"v":0,"d":"0.00"}}]
[null,10,"Deposit in Sukanya Scheme",{"$nulls":3},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_2,15,0),0)","v":{"v":0,"d":"0.00"}}]
[null,"Maximum deduction amount up to Rs 150000 ",{"$nulls":12},{"$f":"IF($N$28<150001,ROUND($N$28,0),150000)","v":0}]
[null,"(B)","Deduct Section 80CCD(2) amount of pension contribution by the employer (10% of maximum salary)",{"$nulls":11},{"$f":"IF(M2=1,N20,0)","v":0}]
[null,"(C)","Deduct additional contribution in Section 80CCD (1B) New Pension Scheme (maximum Rs 50000)",{"$nulls":11},{"$f":"VLOOKUP(D2,Ded_3,4,0)","v":0}]
[null,"Total of 11 (A+B+C)",{"$nulls":12},{"$f":"SUM(O30:O32)","v":0}]
[12,"Other Deductions"]
[null,1,"Section 80 D, Medical Insurance (Rs 25000 for self, spouse and children and parents, Rs 50000 for senior citizens)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,5,0),0)","v":0}]
[null,2,"Section 80DD Medical treatment of disabled dependents (max Rs 75,000 and 80% or more disability Rs 125,000)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,6,0),0)","v":0}]
[null,3,"Section 80 DDB Deduction for treatment of specified diseases (maximum Rs 40,000, Rs 100,000 for senior citizens)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,7,0),0)","v":0}]
[null,4,"Section 80 E Interest on loan taken for higher education",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,8,0),0)","v":0}]
[null,5,"Section 80 G Donations to charitable institutions etc. (100% in category A and 50% in category B)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,9,0),0)","v":0}]
[null,6,"Section 80 U In case of permanent physical disability (maximum Rs. 75,000 and Rs. 125,000 as per Act 1995)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,10,0),0)","v":0}]
[null,7,"Section 80 TTA Maximum exemption on interest on savings account Rs. 10,000 U/S 194(IA)",{"$nulls":11},{"$f":"IF('Master Data'!P6=\"\",0,IF(M2=2,IF(VLOOKUP(D2,Master_Data,16,0)=10000,10000,VLOOKUP(D2,Master_Data,16,0)-10000),0))","v":0}]
[null,8,"Section 80 TTB Maximum exemption on all types of interest to senior citizens – Rs. 50,000 U/S 194(A)"]
[null,9,"Section 80 GGA Donations made for approved scientific, social, rural development etc.",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,11,0),0)","v":0}]
[null,10,"US 80 EE (Home Loan interest for first time house buyer)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,12,0),0)","v":0}]
[null,11,"US 80EEA (Home Loan interest for Affordable home buyer .Loan sanction from 01-04-2019)",{"$nulls":11},{"$f":"IF(M2=2,VLOOKUP(D2,Ded_3,13,0),0)","v":0}]
[null,"Total 12 (1 to 11)",{"$nulls":12},{"$f":"IF(M2=2,SUM(O35:O45),0)","v":0}]
[13,"Total Deductions (11+12)",{"$nulls":12},{"$f":"IF(M2=2,SUM(O33,O46),O33)","v":0}]
[14,"Taxable Income (10-13)",{"$nulls":12},{"$f":"SUM(O18-O47)","v":{"v":989040,"d":"₹989,040.00"}}]
[15,"Rounding off the amount of total income (in multiples of ten) Section 288 A",{"$nulls":12},{"$f":"ROUND($O$48,-1)","v":{"v":989040,"d":"₹989,040.00"}}]
[16,"Calculation of Income Tax"]
[null,"Old Tax Regime Slabs",{"$nulls":9},"New Tax Regime Slabs (for all)",null,null,"Tax Calculation",{"$nulls":8},"difference"]
[null,"Individual tax payer",{"$nulls":3},"Sr. Citizen (60 to 80 years)",null,null,"80 years of age or older",null,null,"up to 300000",null,"NIL",0,null,null,"net taxable income",null,{"$f":"O49","v":{"v":989040,"d":"989040.00"}},null,700000,null,{"$f":"IF($T$52>$V$52,T52-V52,0)","v":289040}]
[null,"up to 250000",null,null,"NIL","up to 300000",null,"NIL","up to 300000",null,"NIL","300001 to 700000",null,{"v":0.05,"d":"5%"},{"$f":"IF(M2=1,ROUND(IF(O49<300001,0,IF(O49>700000,20000,((O49-300001)*0.05))),0),0)","v":{"v":20000,"d":"₹20,000.00"}},null,null,"normal tax",null,{"$f":"O58","v":{"v":48904,"d":"48904.00"}},null,0,null,{"$f":"IF($T$52>$V$52,T53-V53,0)","v":48904}]
[null,"250001 to 500000",null,null,{"v":0.05,"d":"5%"},"300001 to 50000",null,{"v":0.05,"d":"5%"},"300001 to 50000",null,"NIL","700001 to 1000000",null,{"v":0.1,"d":"10%"},{"$f":"IF(M2=2,ROUND(IF(O49<250001,0,IF(O49>500000,12500,((O49-250000)*0.05))),0),ROUND(IF(O49<700001,0,IF(O49>1000000,30000,((O49-700000)*0.1))),0))","v":{"v":28904,"d":"₹28,904.00"}},null,null,"cess",null,{"$f":"O61","v":{"v":1956,"d":"1956.00"}},null,null,"marginal relief",{"$f":"IF(X53>X52,X53-X52,0)","v":0}]
[null,"500001 to 1000000",null,null,{"v":0.2,"d":"20%"},"500001 to 1000000",null,{"v":0.2,"d":"20%"},"500001 to 1000000",null,{"v":0.2,"d":"20%"},"1000001 to 1200000",null,{"v":0.15,"d":"15%"},{"$f":"IF(M2=2,ROUND(IF(O49<500001,0,IF(O49>1000000,100000,((O49-500000)*0.2))),0),ROUND(IF(O49<1000001,0,IF(O49>1200000,30000,((O49-1000000)*0.15))),0))","v":0},null,null,"surcharge"]
[null,"More than 1000000",null,null,{"v":0.3,"d":"30%"},"More than 1000000",null,{"v":0.3,"d":"30%"},"More than 1000000",null,{"v":0.3,"d":"30%"},"1200001 to 1500000",null,{"v":0.2,"d":"20%"},{"$f":"IF(M2=2,ROUND(IF(O49<1000001,0,((O49-1000000)*0.3)),0),ROUND(IF(O49<1200001,0,IF(O49>1500000,60000,((O49-1200000)*0.2))),0))","v":0},null,null,"toatal tax",null,{"$f":"SUM(T52:T55)","v":{"v":1039900,"d":"1039900.00"}},null,null,"net tax",{"$f":"T53-X54","v":{"v":48904,"d":"48904.00"}}]
[{"$nulls":11},"More than 1500000",null,{"v":0.3,"d":"30%"},{"$f":"IF(M2=1,ROUND(IF(O49<1500001,0,(O49-1500000)*0.3),0),0)","v":0}]
[null,1,"Total Income Tax",{"$nulls":10},"115BAC(1)",{"$f":"SUM(O52:O57)","v":{"v":48904,"d":"₹48,904.00"}}]
[null,2,"Old Tax Regime - Exemption Section 87(A) (Exemption of income tax on taxable income of Rs. 2.50 lakh to Rs. 5 lakh up to a maximum of Rs. 12500)   New Tax Regime - Exemption Section 87(A) (Exemption of income tax on taxable income of Rs. 3 lakh to Rs. 7 lakh up to maximum of Rs. 25000) & Marginal relief benefit under section 115BAC(1)",{"$nulls":10},{"$f":"IF(M2=1,IF(X54=\"\",\"\",X54),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(M2=2,IF(O49>500000,0,IF(O58<12501,O58,12500)),IF(N59>0,N59,IF(O49>700000,0,IF(O58<25001,O58,25000))))","v":0}]
[null,3,"Balance Income Tax (1-2)",{"$nulls":11},{"$f":"O58-O59","v":{"v":48904,"d":"₹48,904.00"}}]
[null,4,"Education cess 2% and surcharge for higher education 2% (total 4%)",{"$nulls":11},{"$f":"ROUND(O60*0.04,0)","v":{"v":1956,"d":"₹1,956.00"}}]
[null,"Total Income Tax (3+4)",{"$nulls":12},{"$f":"SUM(O60:O61)","v":{"v":50860,"d":"₹50,860.00"}}]
[17,"Reduce :- Relief under section 89",{"$nulls":12},0]
[18,"Total Income Tax Balance",{"$nulls":12},{"$f":"O62-O63","v":{"v":50860,"d":"₹50,860.00"}}]
[19,"Income tax deduction details (TDS And apart from monthly salary)"]
[null,"2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","TDS and Ot.","Total tax"]
[null,{"$f":"VLOOKUP(D2,Ded_1,10,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,11,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,12,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,13,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,14,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,15,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,16,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,17,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,18,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,19,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,20,0)","v":0},{"$f":"VLOOKUP(D2,Ded_1,21,0)","v":0},{"$f":"VLOOKUP(D2,Ded_3,14,0)","v":0},{"$f":"SUM(B67:N67)","v":0}]
[{"$f":"IF(O64>O67,\"Income Tax Payable\",IF(O64<O67,\"Income Tax Refundable\",\"Income Tax No Need\"))","v":"Income Tax Payable"},{"$nulls":13},{"$f":"O64-O67","v":{"v":50860,"d":"₹50,860.00"}}]
[]
["Signature Of Employee",{"$nulls":4},"Prepared By Ashwini Kumar : 9166023711 www.ashwinisharma.com",{"$nulls":7},"Signature Of DDO"]