{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Details","Form 16","Form 16 A.."],"not_rendered":{"images":8,"macros":1,"external_links":1,"defined_names":5,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":14,"n_cols":1,"rows_kept":14}
["ಮುಖ್ಯಾಂಶಗಳು"]
[]
["1. ಬಳಕೆದಾರರು ತಮ್ಮ ಕಂಪ್ಯೂಟರ್ ದಲ್ಲಿ Office 2007 ಇರುವದನ್ನು ಖಾತ್ರಿಪಡಿಸಿಕೊಳ್ಳಿ."]
["2. ಡಿಟೇಲ್ಸನಲ್ಲಿ ಮಾಹಿತಿ ತುಂಬಿದರೆ, ಪಾರ್ಮ 16 ಮತ್ತು ಪಾರ್ಮ 16A ಸಿದ್ದವಾಗುತ್ತದೆ."]
["4. ಕಾಲಮಿತಿ ಬಡ್ತಿ ಅಂದರೆ 10/15/20 ವರ್ಷದ ಬಡ್ತಿಯಿದ್ದಲ್ಲಿ, ಡಿಟೇಲ್ಸನಲ್ಲಿ ಕ್ರ.ಸಂ 13 ರಲ್ಲಿ ತುಂಬಿರಿ. ಕ್ರ.ಸಂ. 14 ರಲ್ಲಿ ಜಾರಿಯಾಗುವ "]
["     ದಿನಾಂಕ ಮತ್ತು ತಿಂಗಳು ನಮೂದಿಸಿರಿ."]
["5. ವರ್ಷದ ಮದ್ಯದಲ್ಲಿ ವರ್ಗಾವಣೆಯಾದವರಿಗೆ ಅನೂಕೂಲವಾಗಲು ಎಚ್.ಆರ್.ಎ ಮಾಹಿತಿ ತಿಂಗಳುವಾರು ಎ.ಬಿ.ಸಿ. ಗ್ರೇಡ್ ಆಯ್ಕೆಮಾಡಿರಿ."]
["6. ವಿಕಲಚೇತನರಿಗೆ ವಿಶೇಷವಾಗಿ ಇದನ್ನು ರಚಿಸಲಾಗಿದೆ. ಅಂದರೆ ವಿಕಲಚೇತನ Yes/ No ಎಂದು ಕ್ರ.ಸಂ. 16 & 21 ತುಂಬಿದರೆ ಅವರ ಸಂಚಾರಿ ಭತ್ಯೆ "]
["     ಲೆಕ್ಕಾಚಾರ ತಾನೆ ಮಾಡಿ ವೃತ್ತಿ ತೆರಿಗೆ ವಿನಾಯ್ತಿ ತೋರಿಸಿ, 80U, 10(14) ರಲ್ಲಿ ತೆರಿಗೆ ವಿನಾಯ್ತಿ ತೋರಿಸುತ್ತದೆ."]
["7. ಟ್ಯಾಕ್ಸೆಬಲ್ ಆದಾಯ 5 ಲಕ್ಷದೊಳಗೆ ಇದ್ದರೆ 0% ತೆರಿಗೆ, 5 ಲಕ್ಷದಿಂದ 10 ಲಕ್ಷದೊಳಗೆ ಇದ್ದರೆ 20% ಮತ್ತು "]
["        10 ಲಕ್ಷದಮೇಲಿದ್ದರೆ 30% ಲೆಕ್ಕಾಚಾರ ತಾನೆ ಮಾಡಿ ತೋರಿಸುತ್ತದೆ."]
["8. ಟ್ಯಾಕ್ಸೆಬಲ್ ಆದಾಯ 3.5 ಲಕ್ಷದೊಳಗೆ ಇದ್ದರೆ, U/S 87A ಅಡಿಯಲ್ಲಿ ರೂ 2,500 ವಿನಾಯ್ತಿ ಲೆಕ್ಕಾಚಾರ ತಾನೆ ನಿರ್ವಹಿಸುತ್ತದೆ."]
["9. ಉಳಿತಾಯ 1,50,000 ಮೀರಿದ್ದರೆ, 1,50,000 ಮಾತ್ರ ಪರಿಗಣಿಸುವ ವ್ಯವಸ್ಥೆ ಇದೆ."]
["10. ಖಾಸಗಿ ಅನುದಾನಿತ ಶಾಲಾ ಶಿಕ್ಷಕರಿಗೆ ಜಿ.ಐ.ಎಸ್. ಇರುವದಿಲ್ಲ. ಕ್ರ.ಸಂ. 18 ರಲ್ಲಿ Yes/ No ತುಂಬಿದರೆ ಸಾಕು ಲೆಕ್ಕಿಸುತ್ತದೆ. "]

{"sheet":"Details","index":1,"n_rows":68,"n_cols":106,"rows_kept":68,"merged":[[0,0,0,9],[1,2,1,9],[2,2,2,5],[3,2,3,3],[3,5,3,6],[3,8,3,9],[4,2,4,9],[5,2,5,9],[6,2,6,5],[7,2,7,5],[8,2,8,3],[9,2,9,9],[24,0,25,0],[24,2,25,2],[26,6,26,7],[31,2,31,3],[32,2,32,4],[33,2,33,4],[34,2,34,3]]}
["Employees Payment Details for I T Calculation",{"$nulls":9},{"$f":"C11","v":62600},null,null,200,250,300,350,400,450,500,600,700,800,900,1050,1200,1350,1500,1700,null,300,{"$nulls":3},350,{"$nulls":3},400,{"$nulls":3},450,{"$nulls":3},500,{"$nulls":3},600,{"$nulls":5},700,{"$nulls":5},800,{"$nulls":5},900,{"$nulls":5},1050,{"$nulls":5},1200,{"$nulls":5},1350,{"$nulls":6},1500,{"$nulls":3},1700]
["1. Name of Employee",null,"ಶ್ರೀನಿವಾಸ ಹೆಚ್.ಟಿ.",{"$nulls":7},{"$f":"K1","v":62600},{"$f":"IF(D18=\"Mar\",K1+K14,IF(D18=\"Apl\",K1,IF(D18=\"May\",K1,IF(D18=\"Jun\",K1,IF(D18=\"Jul\",K1,IF(D18=\"Aug\",K1,IF(D18=\"Sep\",K1,IF(D18=\"Oct\",K1,IF(D18=\"Nov\",K1,IF(D18=\"Dec\",K1,IF(D18=\"Jan\",K1,IF(D18=\"Feb\",K1))))))))))))","v":62600},{"$f":"IF(K2<18600,O3,IF(K2<20400,P3,IF(K2<22400,Q3,IF(K2<24600,R3,IF(K2<27000,S3,IF(K2<29600,T3,IF(K2<32600,U3,IF(K2<36000,V3,IF(K2<39800,W3,IF(K2<46400,X3,IF(K2<51400,Y3,IF(K2<62600,Z3,IF(K2<72500,AA3,IF(K2<83900,AB3,IF(K2<97100,AC3,IF(K2<112100,AD3,IF(K2<128900,AE3,IF(K2<150600,AF3,))))))))))))))))))","v":1650},"17000-400-18600-450-20400-500-22400-550-24600-600-27000-650--28950",9600,9800,10000,{"$f":"Q2+200","v":10200},{"$f":"R2+200","v":10400},10600,10800,11000,{"$f":"V2+200","v":11200},11400,11600,11800,{"$f":"Z2+200","v":12000},{"$f":"AA2+250","v":12250},{"$f":"AB2+250","v":12500},12750,13000,{"$f":"AE2+300","v":13300},{"$f":"AF2+300","v":13600},13900,14200,{"$f":"AI2+350","v":14550},{"$f":"AJ2+350","v":14900},15250,15600,{"$f":"AM2+400","v":16000},{"$f":"AN2+400","v":16400},16800,17200,{"$f":"AQ2+450","v":17650},{"$f":"AR2+450","v":18100},18550,19000,{"$f":"AU2+500","v":19500},{"$f":"AV2+500","v":20000},20500,{"$f":"AX2+500","v":21000},{"$f":"AY2+600","v":21600},{"$f":"AZ2+600","v":22200},22800,23400,24000,24600,{"$f":"BE2+700","v":25300},{"$f":"BF2+700","v":26000},{"$f":"BG2+700","v":26700},{"$f":"BH2+700","v":27400},28100,28800,{"$f":"BK2+800","v":29600},{"$f":"BL2+800","v":30400},31200,32000,32800,33600,{"$f":"BQ2+900","v":34500},{"$f":"BR2+900","v":35400},{"$f":"BS2+900","v":36300},{"$f":"BT2+900","v":37200},38100,39000,{"$f":"BW2+1050","v":40050},41100,42150,43200,44250,45300,{"$f":"CC2+1200","v":46500},{"$f":"CD2+1200","v":47700},48900,50100,51300,52500,{"$f":"CI2+1350","v":53850},{"$f":"CJ2+1350","v":55200},56550,57900,59250,60600,62100,63600,66600,68100,69600,71300,73000]
["2. Designation,",null,"ದೈಹಿಕ ಶಿಕ್ಷಣ ಶಿಕ್ಷಕರು(ಗ್ರೇಡ್-1)",{"$nulls":7},{"$f":"K2","v":62600},{"$f":"IF(D18=\"Mar\",K2+L15,IF(D18=\"Apl\",K2+K14,IF(D18=\"May\",K2,IF(D18=\"Jun\",K2,IF(D18=\"Jul\",K2,IF(D18=\"Aug\",K2,IF(D18=\"Sep\",K2,IF(D18=\"Oct\",K2,IF(D18=\"Nov\",K2,IF(D18=\"Dec\",K2,IF(D18=\"Jan\",K2,IF(D18=\"Feb\",K2))))))))))))","v":62600},{"$f":"IF(K3<18600,O3,IF(K3<20400,P3,IF(K3<22400,Q3,IF(K3<24600,R3,IF(K3<27000,S3,IF(K3<29600,T3,IF(K3<32600,U3,IF(K3<36000,V3,IF(K3<39800,W3,IF(K3<46400,X3,IF(K3<51400,Y3,IF(K3<62600,Z3,IF(K3<72500,AA3,IF(K3<83900,AB3,IF(K3<97100,AC3,IF(K3<112100,AD3,IF(K3<128900,AE3,IF(K3<150600,AF3,))))))))))))))))))","v":1650},"18600-450-20400-500-22400-550-24600-600-27000-650--29600-750-32600",400,450,500,550,600,650,750,850,950,1100,1250,1450,1650,1900,2200,2500,2800,3100]
["3. PAN Number/ KGID No.",null,"AXTPS4023M",null,"KGID No.",1260321,null,"Aadhar",497378753229,null,{"$f":"K3","v":62600},{"$f":"IF(D18=\"Mar\",K3+L15,IF(D18=\"Apl\",K3+L15,IF(D18=\"May\",K3+K14,IF(D18=\"Jun\",K3,IF(D18=\"Jul\",K3,IF(D18=\"Aug\",K3,IF(D18=\"Sep\",K3,IF(D18=\"Oct\",K3,IF(D18=\"Nov\",K3,IF(D18=\"Dec\",K3,IF(D18=\"Jan\",K3,IF(D18=\"Feb\",K3))))))))))))","v":62600},{"$f":"IF(K4<18600,O3,IF(K4<20400,P3,IF(K4<22400,Q3,IF(K4<24600,R3,IF(K4<27000,S3,IF(K4<29600,T3,IF(K4<32600,U3,IF(K4<36000,V3,IF(K4<39800,W3,IF(K4<46400,X3,IF(K4<51400,Y3,IF(K4<62600,Z3,IF(K4<72500,AA3,IF(K4<83900,AB3,IF(K4<97100,AC3,IF(K4<112100,AD3,IF(K4<128900,AE3,IF(K4<150600,AF3,))))))))))))))))))","v":1650},"19950-450-20400-500-22400-550-24600-600-27000-650-29600-750-32600-850-36000-950-37900",17000,{"$f":"O4+400","v":17400},{"$f":"P4+400","v":17800},18200,18600,{"$f":"S4+450","v":19050},{"$f":"T4+450","v":19500},19950,{"$f":"V4+450","v":20400},{"$f":"W4+500","v":20900},{"$f":"X4+500","v":21400},21900,22400,{"$f":"AA4+550","v":22950},{"$f":"AB4+550","v":23500},24050,24600,{"$f":"AE4+600","v":25200},{"$f":"AF4+600","v":25800},26400,27000,{"$f":"AI4+650","v":27650},{"$f":"AJ4+650","v":28300},28950,29600,{"$f":"AM4+750","v":30350},{"$f":"AN4+750","v":31100},31850,32600,{"$f":"AQ4+850","v":33450},{"$f":"AR4+850","v":34300},35150,36000,{"$f":"AU4+950","v":36950},{"$f":"AV4+950","v":37900},38850,39800,{"$f":"AY4+1100","v":40900},{"$f":"AZ4+1100","v":42000},43100,44200,45300,46400,{"$f":"BE4+1250","v":47650},{"$f":"BF4+1250","v":48900},50150,51400,52650,53900,{"$f":"BK4+1450","v":55350},{"$f":"BL4+1450","v":56800},58250,59700,61150,62600,{"$f":"BQ4+1650","v":64250},{"$f":"BR4+1650","v":65900},67550,69200,70850,72500,{"$f":"BW4+1900","v":74400},{"$f":"BX4+1900","v":76300},78200,80100,82000,83900,{"$f":"CC4+2200","v":86100},{"$f":"CD4+2200","v":88300},90500,92700,94900,97100,{"$f":"CI4+2500","v":99600},{"$f":"CJ4+2500","v":102100},104600,107100,109600,112100,{"$f":"CO4+2800","v":114900},{"$f":"CP4+2800","v":117700},120500,123300,126100,128900,{"$f":"CU4+3100","v":132000},{"$f":"CV4+3100","v":135100},138200,141300,144400,147500,150600]
["4. Residential Address.",null,"2718 E BLOCK, KANAKADASANAGARA MYSORE",{"$nulls":7},{"$f":"IF(C14=\"Jan\",C11,IF(C14=\"Jul\",C11+C15))","v":62600},{"$f":"IF(D18=\"Mar\",K4+L15,IF(D18=\"Apl\",K4+L15,IF(D18=\"May\",K4+L15,IF(D18=\"Jun\",K4+K14,IF(D18=\"Jul\",K4,IF(D18=\"Aug\",K4,IF(D18=\"Sep\",K4,IF(D18=\"Oct\",K4,IF(D18=\"Nov\",K4,IF(D18=\"Dec\",K4,IF(D18=\"Jan\",K4,IF(D18=\"Feb\",K4))))))))))))","v":62600},{"$f":"IF(K5<18600,O3,IF(K5<20400,P3,IF(K5<22400,Q3,IF(K5<24600,R3,IF(K5<27000,S3,IF(K5<29600,T3,IF(K5<32600,U3,IF(K5<36000,V3,IF(K5<39800,W3,IF(K5<46400,X3,IF(K5<51400,Y3,IF(K5<62600,Z3,IF(K5<72500,AA3,IF(K5<83900,AB3,IF(K5<97100,AC3,IF(K5<112100,AD3,IF(K5<128900,AE3,IF(K5<150600,AF3,))))))))))))))))))","v":1650},"21400-500-22400-550-24600-600-27000-650-29600-750-32600-850-36000-950-39800-1100-42000"]
["5. Office Address.",null,"GJC(HS) KARIMUDDANAHALLI, HUNSUR TQ.",{"$nulls":7},{"$f":"K5","v":62600},{"$f":"IF(D18=\"Mar\",K5+L15,IF(D18=\"Apl\",K5+L15,IF(D18=\"May\",K5+L15,IF(D18=\"Jun\",K5+L15,IF(D18=\"Jul\",K5+K14,IF(D18=\"Aug\",K5,IF(D18=\"Sep\",K5,IF(D18=\"Oct\",K5,IF(D18=\"Nov\",K5,IF(D18=\"Dec\",K5,IF(D18=\"Jan\",K5,IF(D18=\"Feb\",K5))))))))))))","v":62600},{"$f":"IF(K6<18600,O3,IF(K6<20400,P3,IF(K6<22400,Q3,IF(K6<24600,R3,IF(K6<27000,S3,IF(K6<29600,T3,IF(K6<32600,U3,IF(K6<36000,V3,IF(K6<39800,W3,IF(K6<46400,X3,IF(K6<51400,Y3,IF(K6<62600,Z3,IF(K6<72500,AA3,IF(K6<83900,AB3,IF(K6<97100,AC3,IF(K6<112100,AD3,IF(K6<128900,AE3,IF(K6<150600,AF3,))))))))))))))))))","v":1650},"23500-550-22400-550-24600-600-27000-650-29600-750-32600-850-36000-950-39800-1100-46400-1250-47650"]
["6. Name of Controlling Authority.",null,"NANJUSNDAIAH",{"$nulls":7},{"$f":"K6","v":62600},{"$f":"IF(D18=\"Mar\",K6+L15,IF(D18=\"Apl\",K6+L15,IF(D18=\"May\",K6+L15,IF(D18=\"Jun\",K6+L15,IF(D18=\"Jul\",K6+L15,IF(D18=\"Aug\",K6+K14,IF(D18=\"Sep\",K6,IF(D18=\"Oct\",K6,IF(D18=\"Nov\",K6,IF(D18=\"Dec\",K6,IF(D18=\"Jan\",K6,IF(D18=\"Feb\",K6))))))))))))","v":62600},{"$f":"IF(K7<18600,O3,IF(K7<20400,P3,IF(K7<22400,Q3,IF(K7<24600,R3,IF(K7<27000,S3,IF(K7<29600,T3,IF(K7<32600,U3,IF(K7<36000,V3,IF(K7<39800,W3,IF(K7<46400,X3,IF(K7<51400,Y3,IF(K7<62600,Z3,IF(K7<72500,AA3,IF(K7<83900,AB3,IF(K7<97100,AC3,IF(K7<112100,AD3,IF(K7<128900,AE3,IF(K7<150600,AF3,))))))))))))))))))","v":1650},"25800-600-27000-650-29600-750-32600-850-36000-950-39800-1100-46400-1250-51400"]
["7. Designation of Controlling Authority.",null,"SENIOR ASSISTANT TEACHER",{"$nulls":7},{"$f":"K7","v":62600},{"$f":"IF(D18=\"Mar\",K7+L15,IF(D18=\"Apl\",K7+L15,IF(D18=\"May\",K7+L15,IF(D18=\"Jun\",K7+L15,IF(D18=\"Jul\",K7+L15,IF(D18=\"Aug\",K7+L15,IF(D18=\"Sep\",K8+K14,IF(D18=\"Oct\",K7,IF(D18=\"Nov\",K7,IF(D18=\"Dec\",K7,IF(D18=\"Jan\",K7,IF(D18=\"Feb\",K7))))))))))))","v":62600},{"$f":"IF(K8<18600,O3,IF(K8<20400,P3,IF(K8<22400,Q3,IF(K8<24600,R3,IF(K8<27000,S3,IF(K8<29600,T3,IF(K8<32600,U3,IF(K8<36000,V3,IF(K8<39800,W3,IF(K8<46400,X3,IF(K8<51400,Y3,IF(K8<62600,Z3,IF(K8<72500,AA3,IF(K8<83900,AB3,IF(K88<97100,AC3,IF(K8<112100,AD3,IF(K8<128900,AE3,IF(K8<150600,AF3,))))))))))))))))))","v":1650},"27650-650-29600-750-32600-850-36000-950-39800-1100-46400-1250-52650"]
["8. TAN number.",{"$nulls":9},{"$f":"K8","v":62600},{"$f":"IF(D18=\"Mar\",K8+L15,IF(D18=\"Apl\",K8+L15,IF(D18=\"May\",K8+L15,IF(D18=\"Jun\",K8+L15,IF(D18=\"Jul\",K8+L15,IF(D18=\"Aug\",K8+L15,IF(D18=\"Sep\",K8+L15,IF(D18=\"Oct\",K8+K14,IF(D18=\"Nov\",K8,IF(D18=\"Dec\",K8,IF(D18=\"Jan\",K8,IF(D18=\"Feb\",K8))))))))))))","v":62600},{"$f":"IF(K9<18600,O3,IF(K9<20400,P3,IF(K9<22400,Q3,IF(K9<24600,R3,IF(K9<27000,S3,IF(K9<29600,T3,IF(K9<32600,U3,IF(K9<36000,V3,IF(K9<39800,W3,IF(K9<46400,X3,IF(K9<51400,Y3,IF(K9<62600,Z3,IF(K9<72500,AA3,IF(K9<83900,AB3,IF(K9<97100,AC3,IF(K9<112100,AD3,IF(K9<128900,AE3,IF(K9<150600,AF3,))))))))))))))))))","v":1650},"30350-750-32600-850-36000-950-39800-1100-46400-1250-53900-1450-58250"]
["9. Scale of Employee.",null,"43100-1100-46400-1250-53900-1450-62600-1650-72500-1900-83900",{"$nulls":7},{"$f":"K9","v":62600},{"$f":"IF(D18=\"Mar\",K9+L15,IF(D18=\"Apl\",K9+L15,IF(D18=\"May\",K9+L15,IF(D18=\"Jun\",K9+L15,IF(D18=\"Jul\",K9+L15,IF(D18=\"Aug\",K9+L15,IF(D18=\"Sep\",K9+L15,IF(D18=\"Oct\",K9+L15,IF(D18=\"Nov\",K9+K14,IF(D18=\"Dec\",K9,IF(D18=\"Jan\",K9,IF(D18=\"Feb\",K9))))))))))))","v":62600},{"$f":"IF(K10<18600,O3,IF(K10<20400,P3,IF(K10<22400,Q3,IF(K10<24600,R3,IF(K10<27000,S3,IF(K10<29600,T3,IF(K10<32600,U3,IF(K10<36000,V3,IF(K10<39800,W3,IF(K10<46400,X3,IF(K10<51400,Y3,IF(K10<62600,Z3,IF(K10<72500,AA3,IF(K10<83900,AB3,IF(K10<97100,AC3,IF(K10<112100,AD3,IF(K10<128900,AE3,IF(K10<150600,AF3,))))))))))))))))))","v":1650},"33450-850-36000-950-39800-1100-46400-1250-53900-1450-62600"]
["10. Your Basic Pay as on March.",null,62600,null,"Month","G P F","K G I D","L I C","I T","HRA",{"$f":"IF(C14=\"Jan\",C11+C15,IF(C14=\"Jul\",K10))","v":64250},{"$f":"IF(D18=\"Mar\",K10+L15,IF(D18=\"Apl\",K10+L15,IF(D18=\"May\",K10+L15,IF(D18=\"Jun\",K10+L15,IF(D18=\"Jul\",K10+L15,IF(D18=\"Aug\",K10+L15,IF(D18=\"Sep\",K10+L15,IF(D18=\"Oct\",K10+L15,IF(D18=\"Nov\",K10+L15,IF(D18=\"Dec\",K10+K14,IF(D18=\"Jan\",K10,IF(D18=\"Feb\",K10))))))))))))","v":62600},{"$f":"IF(K11<18600,O3,IF(K11<20400,P3,IF(K11<22400,Q3,IF(K11<24600,R3,IF(K11<27000,S3,IF(K11<29600,T3,IF(K11<32600,U3,IF(K11<36000,V3,IF(K11<39800,W3,IF(K11<46400,X3,IF(K11<51400,Y3,IF(K11<62600,Z3,IF(K11<72500,AA3,IF(K11<83900,AB3,IF(K11<97100,AC3,IF(K11<112100,AD3,IF(K11<128900,AE3,IF(K11<150600,AF3,))))))))))))))))))","v":1650},"36000-950-39800-1100-46400-1250-53900-1450-62600-1650-67550"]
["11.Whether you claiming Uniforn Allowance ",null,"No",null,"Mar",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"K11","v":64250},{"$f":"IF(D18=\"Mar\",K11+L15,IF(D18=\"Apl\",K11+L15,IF(D18=\"May\",K11+L15,IF(D18=\"Jun\",K11+L15,IF(D18=\"Jul\",K11+L15,IF(D18=\"Aug\",K11+L15,IF(D18=\"Sep\",K11+L15,IF(D18=\"Oct\",K11+L15,IF(D18=\"Nov\",K11+L15,IF(D18=\"Dec\",K11+L15,IF(D18=\"Jan\",K11+K14,IF(D18=\"Feb\",K11))))))))))))","v":64250},{"$f":"IF(K12<18600,O3,IF(K12<20400,P3,IF(K12<22400,Q3,IF(K12<24600,R3,IF(K12<27000,S3,IF(K12<29600,T3,IF(K12<32600,U3,IF(K12<36000,V3,IF(K12<39800,W3,IF(K12<46400,X3,IF(K12<51400,Y3,IF(K12<62600,Z3,IF(K12<72500,AA3,IF(K12<83900,AB3,IF(K12<97100,AC3,IF(K12<112100,AD3,IF(K12<128900,AE3,IF(K12<150600,AF3,))))))))))))))))))","v":1650},"37900-950-39800-1100-46400-1250-53900-1450-62600-1650-70850"]
["12. Type of Increment / Additional Increment",null,"Regular",null,"Apl",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11,IF(C14=\"Mar\",C11+C15,IF(C14=\"Apl\",C11+C15,IF(C14=\"May\",C11+C15,IF(C14=\"Jun\",C11+C15,IF(C14=\"Jul\",C11+C15,IF(C14=\"Aug\",C11+C15,IF(C14=\"Sep\",C11+C15,IF(C14=\"Oct\",C11+C15,IF(C14=\"Nov\",C11+C15,IF(C14=\"Dec\",C11+C15,IF(C14=\"Jan\",C11+C15,IF(C14=\"Feb\",C11+C15)))))))))))))","v":64250},{"$f":"IF(D18=\"Mar\",K12+L15,IF(D18=\"Apl\",K12+L15,IF(D18=\"May\",K12+L15,IF(D18=\"Jun\",K12+L15,IF(D18=\"Jul\",K12+L15,IF(D18=\"Aug\",K12+L15,IF(D18=\"Sep\",K12+L15,IF(D18=\"Oct\",K12+L15,IF(D18=\"Nov\",K12+L15,IF(D18=\"Dec\",K12+L15,IF(D18=\"Jan\",K12+L15,IF(D18=\"Feb\",K12+K14))))))))))))","v":64250},{"$f":"IF(K13<18600,O3,IF(K13<20400,P3,IF(K13<22400,Q3,IF(K13<24600,R3,IF(K13<27000,S3,IF(K13<29600,T3,IF(K13<32600,U3,IF(K13<36000,V3,IF(K13<39800,W3,IF(K13<46400,X3,IF(K13<51400,Y3,IF(K13<62600,Z3,IF(K13<72500,AA3,IF(K13<83900,AB3,IF(K13<97100,AC3,IF(K13<112100,AD3,IF(K13<128900,AE3,IF(K13<150600,AF3,))))))))))))))))))","v":1650},"40900-1100-46400-1250-53900-1450-62600-1650-72500-1900-78200"]
["13. Regular Increment Month ",null,"Jan",null,"May",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"ROUND(L15/30*(30-C18+1),0)","v":0},{"$f":"IF(D18=\"Mar\",K2+K14,IF(D18=\"Apl\",K2+K14,IF(D18=\"May\",K4+K14,IF(D18=\"jun\",K5+K14,IF(D18=\"Jul\",K6+K14,IF(D18=\"Aug\",K7+K14,IF(D18=\"Sep\",K8+K14,IF(D18=\"Oct\",K9+K14,IF(D18=\"Nov\",K10+K14,IF(D18=\"Dec\",K11+K14,IF(D18=\"Jan\",K12+K14,IF(D18=\"Feb\",K13+K14))))))))))))","v":64250},null,"43100-1100-46400-1250-53900-1450-62600-1650-72500-1900-83900"]
["14. Rate of Increment.",null,{"$f":"IF(C11<18600,O3,IF(C11<20400,P3,IF(C11<22400,Q3,IF(C11<24600,R3,IF(C11<27000,S3,IF(C11<29600,T3,IF(C11<32600,U3,IF(C11<36000,V3,IF(C11<39800,W3,IF(C11<46400,X3,IF(C11<53900,Y3,IF(C11<62600,Z3,IF(C11<72500,AA3,IF(C11<83900,AB3,IF(C11<97100,AC3,IF(C11<112100,AD3,IF(C11<128900,AE3,IF(C11<150600,AF3,))))))))))))))))))","v":1650},null,"Jun",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Feb\",C11-C15,C11)","v":62600},{"$f":"IF(C17=\"Yes\",L16,IF(C17=\"No\",0))","v":0},null,"45300-1100-46400-1250-53900-1450-62600-1650-72500-1900-83900-2200-88300"]
["15. If there is Stagnation Increment select rate of increment",null,2700,null,"Jul",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11-C15,C11)","v":62600},{"$f":"IF(D18=\"Mar\",M2,IF(D18=\"Apl\",M3,IF(D18=\"May\",M4,IF(D18=\"jun\",M5,IF(D18=\"Jul\",M6,IF(D18=\"Aug\",M7,IF(D18=\"Sep\",M8,IF(D18=\"Oct\",M9,IF(D18=\"Nov\",M10,IF(D18=\"Dec\",M11,IF(D18=\"Jan\",M12,IF(D18=\"Feb\",M13))))))))))))","v":1650},null,"48900-1250-53900-1450-62600-1650-72500-1900-83900-2200-92700"]
["16. Is there 10/15/20 years Increment./ Add Increment?",null,"No",null,"Aug",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C","C A",{"$f":"IF(C10=N2,\"17000\",IF(C10=N3,\"18600\",IF(C10=N4,\"19950\",IF(C10=N5,\"21400\",IF(C10=N6,\"23500\",IF(C10=N7,\"25800\",IF(C10=N8,\"27650\",IF(C10=N9,\"30350\",IF(C10=N10,\"33450\",IF(C10=N11,\"36000\",IF(C10=N12,\"37900\",IF(C10=N13,\"40900\",IF(C10=N14,\"43100\",IF(C10=N15,\"45300\",IF(C10=N16,\"48900\",IF(C10=N18,\"56800\",IF(C10=N19,\"61150\",IF(C10=N20,\"67750\",IF(C10=N21,\"70850\",IF(C10=N22,\"74400\",IF(C10=N23,\"82000\",IF(C10=N24,\"90500\",IF(C10=N25,\"97100\",IF(C10=N26,\"104600\"))))))))))))))))))))))))","v":"43100"},null,"52650-1250-53900-1450-62600-1650-72500-1900-83900-2200-97100"]
["17. If yes, Effective Date and Month.",null,20,"Feb","Sep",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11,IF(C14=\"May\",C11,IF(C14=\"Jun\",C11,IF(C14=\"Jul\",C11,IF(C14=\"Aug\",C11,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},0,null,"56800-1450-62600-1650-72500-1900-83900-2200-97100-2500-99600"]
["18. Whether you belong to  Single child holder OR         ",null,"No",null,"Oct",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11,IF(C14=\"May\",C11,IF(C14=\"Jun\",C11,IF(C14=\"Jul\",C11,IF(C14=\"Aug\",C11,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},650,null,"61150-1450-62600-1650-72500-1900-83900-2200-97100-2500-102100"]
["        Handicapped person.",{"$nulls":3},"Nov",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11,IF(C14=\"Jul\",C11,IF(C14=\"Aug\",C11,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},850,null,"67550-1650-72500-1900-83900-2200-97100-2500-104600"]
["19. Whether you belong to New Pension Scheme.",null,"No",null,"Dec",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11,IF(C14=\"Aug\",C11,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},950,null,"70850-1650-72500-1900-83900-2200-97100-2500-107100"]
["20. Whether you are Govt Employee or Private Employee",null,"Govt",null,"Jan",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1100,null,"74400-1900-83900-2200-97100-2500-109600"]
["21. Which group you belong to (A,B,C,D)",null,"B",null,"Feb",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1272,"d":"1,272"},0,"C",{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1250,null,"82000-1900-83900-2200-97100-2500-112100-2800-117100"]
["22. C.C.A. rate (if you are in A and B cadre city)",null,450,{"$nulls":7},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1400,null,"90500-2200-97100-2500-112100-2800-123300"]
["23. Have you belong to Small Family Norms (SFN)                     (mention your Increment rate)",null,0,{"$nulls":7},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11+C16,IF(C14=\"Nov\",C11,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1450,null,"97100-2500-112100-2800-128900-3100-141300"]
[{"$nulls":10},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11+C16,IF(C14=\"Nov\",C11+C16,IF(C14=\"Dec\",C11,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1650,null,"104600-2500-112100-2800-128900-3100-150600"]
["24. Are you Handicapped person?",null,"No",{"$nulls":7},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11+C16,IF(C14=\"Nov\",C11+C16,IF(C14=\"Dec\",C11+C16,IF(C14=\"Jan\",C11,IF(C14=\"Feb\",C11))))))))))))","v":62600},1700]
["25. Are you claimimng Medical Allowance.",null,"No",{"$nulls":7},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11+C16,IF(C14=\"Nov\",C11+C16,IF(C14=\"Dec\",C11+C16,IF(C14=\"Jan\",C11+C16,IF(C14=\"Feb\",C11+C16))))))))))))","v":65300},2150]
["26. Do you want you claim H.R.A. deduction in income tax",null,"No",{"$nulls":7},{"$f":"IF(C14=\"Mar\",C11+C16,IF(C14=\"Apl\",C11+C16,IF(C14=\"May\",C11+C16,IF(C14=\"Jun\",C11+C16,IF(C14=\"Jul\",C11+C16,IF(C14=\"Aug\",C11+C16,IF(C14=\"Sep\",C11+C16,IF(C14=\"Oct\",C11+C16,IF(C14=\"Nov\",C11+C16,IF(C14=\"Dec\",C11+C16,IF(C14=\"Jan\",C11+C16,IF(C14=\"Feb\",C11+C16))))))))))))","v":65300},2200]
["27. If yes, Actual your house rent per month.",null,{"v":8250,"d":"8,250"},{"$nulls":8},2500]
["29. Surrender-which month you claimed.",null,"Nil",{"$nulls":8},2700]
["30. Employees Date of Birth",null,"2019-10-21",{"$nulls":8},2800]
["31. Bank Savings A/C Number",null,{"v":35218478899,"d":"035218478899"},{"$nulls":8},2900]
["32. IFSC Code",null,"SBIN0001730",{"$nulls":8},3100]
["33. Is there any Agricultural Income.",null,{"v":0,"d":"Rs. 0"},{"$nulls":8},3300]
["For more details contact : hucheshpk@gmail.com,   mob : 9844025347",{"$nulls":10},3550]
[{"$nulls":11},3750]
[{"$nulls":11},3800]
[{"$nulls":11},3950]
[{"$nulls":11},4150]
[{"$nulls":11},4350]
[{"$nulls":11},4400]
[{"$nulls":11},5000]
[{"$nulls":11},5300]
[{"$nulls":11},5400]
[{"$nulls":11},5450]
[{"$nulls":11},5600]
[{"$nulls":11},5700]
[{"$nulls":11},6000]
[{"$nulls":11},6200]
[{"$nulls":11},6600]
[{"$nulls":11},6850]
[{"$nulls":11},6900]
[{"$nulls":11},7500]
[{"$nulls":11},7800]
[{"$nulls":11},7900]
[{"$nulls":11},8100]
[{"$nulls":11},8400]
[{"$nulls":11},8700]
[{"$nulls":11},9300]
[{"$nulls":11},9400]
[{"$nulls":11},10000]
[{"$nulls":11},10300]
[{"$nulls":11},10600]
[{"$nulls":11},10900]
[{"$nulls":11},11800]
[{"$nulls":11},12400]
[{"$nulls":11},15500]

{"sheet":"Form 16","index":2,"n_rows":78,"n_cols":20,"rows_kept":78,"merged":[[1,0,77,0],[1,1,1,17],[2,14,2,15],[3,1,3,2],[3,3,3,8],[3,14,3,17],[4,1,4,2],[4,3,4,7],[4,9,4,12],[4,14,4,17],[6,1,7,1],[6,2,6,10],[6,11,6,17],[37,2,37,3],[37,4,37,5],[37,6,37,8],[37,11,37,12],[38,11,38,12],[39,5,39,7],[39,9,39,12],[39,14,39,15],[40,12,40,13],[40,15,40,16],[41,2,41,11],[41,12,41,13],[41,15,41,16],[41,17,44,17],[42,12,42,13],[42,15,44,16],[43,12,43,13],[44,12,44,13],[45,12,45,13],[45,15,45,16],[46,12,46,13],[46,15,46,16],[47,6,47,11],[47,12,47,13],[47,15,47,16],[48,7,48,10],[48,12,48,13],[48,15,48,16],[49,7,49,10],[49,12,49,13],[49,15,49,16],[50,12,50,13],[50,15,50,16],[51,12,51,13],[51,15,51,16],[52,6,52,9],[52,12,52,13],[52,15,52,16],[53,12,53,13],[53,15,53,16],[54,12,54,13],[54,15,54,16],[55,12,55,13],[55,15,55,16],[56,8,56,9],[56,12,56,13],[56,15,56,16],[57,5,57,7],[57,12,57,13],[57,15,57,16],[58,12,58,13],[58,15,58,16],[59,12,59,16],[76,3,76,4],[77,3,77,4]]}
[]
["KARUNADU DIVYANGA NAUKARAR SANGHA         ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ     KARUNADU DIVYANGA NAUKARAR SANGHA         ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ   KARUNADU DIVYANGA NAUKARAR SANGHA         ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ","DETAILS OF SALARY & DEDUCTIONS for the Financial Year of 2019- 20 A.Y.2020-21"]
[null,"Name :",{"$f":"Details!C2","v":"ಶ್ರೀನಿವಾಸ ಹೆಚ್.ಟಿ."},{"$nulls":6},"Designation : ",{"$f":"Details!C3","v":"ದೈಹಿಕ ಶಿಕ್ಷಣ ಶಿಕ್ಷಕರು(ಗ್ರೇಡ್-1)"},null,null,"KGID No.",{"$f":"Details!F4","v":1260321}]
[null,"Permnent  Address:",null,{"$f":"Details!C5","v":"2718 E BLOCK, KANAKADASANAGARA MYSORE"},{"$nulls":5},"Office Address",{"$nulls":3},"TAN No",{"$f":"Details!C9","v":0},{"$nulls":3},{"$f":"IF(Details!C12=\"Yes\",300,IF(Details!C12=\"No\",0))","v":0},{"$f":"Details!C25","v":0}]
[null,"Aadhar No.",null,{"$f":"Details!I4","v":497378753229},{"$nulls":5},{"$f":"Details!C6","v":"GJC(HS) KARIMUDDANAHALLI, HUNSUR TQ."},{"$nulls":3},"PAN No",{"$f":"Details!C4","v":"AXTPS4023M"},{"$nulls":3},{"$f":"S4+T4","v":0}]
[null,null,"Scale",{"$f":"Details!C10","v":"43100-1100-46400-1250-53900-1450-62600-1650-72500-1900-83900"},{"$nulls":15},10]
[null,"Month YEAR","SALARY",{"$nulls":8},"DEDUCTIONS"]
[null,null,"PAY","Char All","D A","HRA","MA","PHA","S F N + Unu All"," CCA","TOTAL","P T","G P F","K G I D","L I C","NPS","GIS /FBF","I T ",null,{"$f":"IF(Details!C23=\"A\",480,IF(Details!C23=\"B\",360,IF(Details!C23=\"C\",240,IF(Details!C23=\"D\",120))))","v":360}]
[null,"2019-03-01",{"$f":"IF(Details!C13=\"Regular\",Details!L2,IF(Details!C13=\"Stagnation\",Details!K18))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C9)*S9%,0)","v":{"v":2348,"d":"2,348"}},{"$f":"ROUND(IF(Details!J13=\"A\",(C10)*24%,IF(Details!J13=\"B\",(C10)*16%,IF(Details!J13=\"C\",(C10)*8%))),0)","v":{"v":5008,"d":"5,008"}},{"$f":"IF(Details!C28=\"Yes\",200,IF(Details!C28=\"No\",0))","v":0},{"$f":"ROUND(IF(Details!C27=\"Yes\",(C9+D9)*6%,IF(Details!C27=\"No\",0)),0)","v":0},{"$f":"S5","v":0},{"$f":"IF(Details!J12=\"A\",Details!C24,IF(Details!J12=\"B\",Details!C24,IF(Details!J12=\"C\",0)))","v":0},{"$f":"C9+D9+E9+F9+G9+H9+I9+J9","v":{"v":69956,"d":"69,956"}},{"$f":"IF(Details!C19=\"Yes\",0,IF(Details!C19=\"No\",200))","v":200},{"$f":"IF(Details!C21=\"No\",Details!F12,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G12","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H12","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C9+E9)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I12","v":0},3.75]
[null,"2019-04-01",{"$f":"IF(Details!C13=\"Regular\",Details!L3,IF(Details!C13=\"Stagnation\",Details!K19))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C10)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J13=\"A\",(C10)*24%,IF(Details!J13=\"B\",(C10)*16%,IF(Details!J13=\"C\",(C10)*8%))),0)","v":{"v":5008,"d":"5,008"}},{"$f":"G9","v":0},{"$f":"ROUND(IF(Details!C27=\"Yes\",(C10+D10)*6%,IF(Details!C27=\"No\",0)),0)","v":0},{"$f":"I9","v":0},{"$f":"IF(Details!J13=\"A\",Details!C24,IF(Details!J13=\"B\",Details!C24,IF(Details!J13=\"C\",0)))","v":0},{"$f":"C10+D10+E10+F10+G10+H10+I10+J10","v":{"v":71677,"d":"71,677"}},{"$f":"L9","v":200},{"$f":"IF(Details!C21=\"No\",Details!F13,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G13","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H13","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C10+E10)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I13","v":0},6.5]
[null,"2019-05-01",{"$f":"IF(Details!C13=\"Regular\",Details!L4,IF(Details!C13=\"Stagnation\",Details!K20))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C11)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J14=\"A\",(C11)*24%,IF(Details!J14=\"B\",(C11)*16%,IF(Details!J14=\"C\",(C11)*8%))),0)","v":{"v":5008,"d":"5,008"}},{"$f":"G10","v":0},{"$f":"ROUND(IF(Details!C27=\"Yes\",(C11+D11)*6%,IF(Details!C27=\"No\",0)),0)","v":0},{"$f":"I10","v":0},{"$f":"IF(Details!J14=\"A\",Details!C24,IF(Details!J14=\"B\",Details!C24,IF(Details!J14=\"C\",0)))","v":0},{"v":71677,"d":"71,677"},{"$f":"L10","v":200},{"$f":"IF(Details!C21=\"No\",Details!F14,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G14","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H14","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C11+E11)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I14","v":0},11.25]
[null,"2019-06-01",{"$f":"IF(Details!C13=\"Regular\",Details!L5,IF(Details!C13=\"Stagnation\",Details!K21))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C12)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J15=\"A\",(C12)*24%,IF(Details!J15=\"B\",(C12)*16%,IF(Details!J15=\"C\",(C12)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C12+D12)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J14=\"A\",Details!C24,IF(Details!J15=\"B\",Details!C24,IF(Details!J15=\"C\",0)))","v":0},{"v":71677,"d":"71,677"},200,{"$f":"IF(Details!C21=\"No\",Details!F15,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G15","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H15","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C12+E12)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I15","v":0},2.75]
[null,"2019-07-01",{"$f":"IF(Details!C13=\"Regular\",Details!L6,IF(Details!C13=\"Stagnation\",Details!K22))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C13)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J16=\"A\",(C13)*24%,IF(Details!J16=\"B\",(C13)*16%,IF(Details!J16=\"C\",(C13)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C13+D13)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J16=\"A\",Details!C24,IF(Details!J16=\"B\",Details!C24,IF(Details!J16=\"C\",0)))","v":0},{"v":71677,"d":"71,677"},200,{"$f":"IF(Details!C21=\"No\",Details!F16,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G16","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H16","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C13+E13)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I16","v":0},4.75]
[null,"2019-08-01",{"$f":"IF(Details!C13=\"Regular\",Details!L7,IF(Details!C13=\"Stagnation\",Details!K23))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C14)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J17=\"A\",(C14)*24%,IF(Details!J17=\"B\",(C14)*16%,IF(Details!J17=\"C\",(C14)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C14+D14)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J17=\"A\",Details!C24,IF(Details!J17=\"B\",Details!C24,IF(Details!J17=\"C\",0)))","v":0},{"v":71677,"d":"71,677"},200,{"$f":"IF(Details!C21=\"No\",Details!F17,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G17","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H17","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C14+E14)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I17","v":0}]
[null,"2019-09-01",{"$f":"IF(Details!C13=\"Regular\",Details!L8,IF(Details!C13=\"Stagnation\",Details!K24))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C15)*S10%,0)","v":{"v":4069,"d":"4,069"}},{"$f":"ROUND(IF(Details!J18=\"A\",(C15)*24%,IF(Details!J18=\"B\",(C15)*16%,IF(Details!J18=\"C\",(C15)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C15+D15)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J18=\"A\",Details!C24,IF(Details!J18=\"B\",Details!C24,IF(Details!J18=\"C\",0)))","v":0},{"v":71677,"d":"71,677"},200,{"$f":"IF(Details!C21=\"No\",Details!F18,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G18","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H18","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C15+E15)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I18","v":0}]
[null,"2019-10-01",{"$f":"IF(Details!C13=\"Regular\",Details!L9,IF(Details!C13=\"Stagnation\",Details!K25))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C16)*S11%,0)","v":{"v":7043,"d":"7,043"}},{"$f":"ROUND(IF(Details!J19=\"A\",(C16)*24%,IF(Details!J19=\"B\",(C16)*16%,IF(Details!J19=\"C\",(C16)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C16+D16)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J19=\"A\",Details!C24,IF(Details!J19=\"B\",Details!C24,IF(Details!J19=\"C\",0)))","v":0},{"v":74651,"d":"74,651"},200,{"$f":"IF(Details!C21=\"No\",Details!F19,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G19","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H19","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C16+E16)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I19","v":0}]
[null,"2019-11-01",{"$f":"IF(Details!C13=\"Regular\",Details!L10,IF(Details!C13=\"Stagnation\",Details!K26))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C17)*S11%,0)","v":{"v":7043,"d":"7,043"}},{"$f":"ROUND(IF(Details!J20=\"A\",(C17)*24%,IF(Details!J20=\"B\",(C17)*16%,IF(Details!J20=\"C\",(C17)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C17+D17)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J20=\"A\",Details!C24,IF(Details!J20=\"B\",Details!C24,IF(Details!J20=\"C\",0)))","v":0},{"v":74651,"d":"74,651"},200,{"$f":"IF(Details!C21=\"No\",Details!F20,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G20","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H20","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C17+E17)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I20","v":0},"Jan",{"$f":"Details!K1","v":62600}]
[null,"2019-12-01",{"$f":"IF(Details!C13=\"Regular\",Details!L11,IF(Details!C13=\"Stagnation\",Details!K27))","v":{"v":62600,"d":"62,600"}},0,{"$f":"ROUND((C18)*S11%,0)","v":{"v":7043,"d":"7,043"}},{"$f":"ROUND(IF(Details!J21=\"A\",(C18)*24%,IF(Details!J21=\"B\",(C18)*16%,IF(Details!J21=\"C\",(C18)*8%))),0)","v":{"v":5008,"d":"5,008"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C18+D18)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J21=\"A\",Details!C24,IF(Details!J21=\"B\",Details!C24,IF(Details!J21=\"C\",0)))","v":0},{"v":74651,"d":"74,651"},200,{"$f":"IF(Details!C21=\"No\",Details!F21,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G21","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H21","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C18+E18)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I21","v":0},"Feb",{"$f":"Details!L1","v":0}]
[null,"2020-01-01",{"$f":"IF(Details!C13=\"Regular\",Details!L12,IF(Details!C13=\"Stagnation\",Details!K28))","v":{"v":64250,"d":"64,250"}},0,{"$f":"ROUND((C19)*S11%,0)","v":{"v":7228,"d":"7,228"}},{"$f":"ROUND(IF(Details!J22=\"A\",(C19)*24%,IF(Details!J22=\"B\",(C19)*16%,IF(Details!J22=\"C\",(C19)*8%))),0)","v":{"v":5140,"d":"5,140"}},{"$f":"G18","v":0},{"$f":"ROUND(IF(Details!C27=\"Yes\",(C19+D19)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J22=\"A\",Details!C24,IF(Details!J22=\"B\",Details!C24,IF(Details!J22=\"C\",0)))","v":0},{"v":76618,"d":"76,618"},200,{"$f":"IF(Details!C21=\"No\",Details!F22,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G22","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H22","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C19+E19)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"IF(Details!C22=\"Govt\",T8,IF(Details!C22=\"Private\",T6))","v":360},{"$f":"Details!I22","v":0}]
[null,"2020-02-01",{"$f":"IF(Details!C13=\"Regular\",Details!L13,IF(Details!C13=\"Stagnation\",Details!K29))","v":{"v":64250,"d":"64,250"}},0,{"$f":"ROUND((C20)*S11%,0)","v":{"v":7228,"d":"7,228"}},{"$f":"ROUND(IF(Details!J23=\"A\",(C20)*24%,IF(Details!J23=\"B\",(C20)*16%,IF(Details!J23=\"C\",(C20)*8%))),0)","v":{"v":5140,"d":"5,140"}},0,{"$f":"ROUND(IF(Details!C27=\"Yes\",(C20+D20)*6%,IF(Details!C27=\"No\",0)),0)","v":0},0,{"$f":"IF(Details!J23=\"A\",Details!C24,IF(Details!J23=\"B\",Details!C24,IF(Details!J23=\"C\",0)))","v":0},{"v":76618,"d":"76,618"},200,{"$f":"IF(Details!C21=\"No\",Details!F23,IF(Details!C21=\"Yes\",\"0\"))","v":{"v":2000,"d":"2,000"}},{"$f":"Details!G23","v":{"v":2000,"d":"2,000"}},{"$f":"Details!H23","v":{"v":1272,"d":"1,272"}},{"$f":"ROUND(IF(Details!C21=\"Yes\",(C20+E20)*10%,IF(Details!C21=\"No\",0)),0)","v":0},{"$f":"Q19","v":360},{"$f":"Details!I23","v":0},null,{"$f":"ROUND((C9*S12%),0)","v":1722}]
[null,"D.A.Diff Jan",0,0,{"$f":"T23","v":{"v":5166,"d":"5,166"}},{"$f":"ROUND(C21*15%,0)","v":0},0,0,0,0,{"$f":"SUM(C21:J21)","v":{"v":5166,"d":"5,166"}},0,0,0,0,{"$f":"ROUND(IF(Details!C21=\"Yes\",(C21+E21)*10%,IF(Details!C21=\"No\",0)),0)","v":0},0,0,null,{"$f":"ROUND((Details!K15*S12%),0)","v":1722}]
[null,"D.A.Diff Jul",0,0,{"$f":"T27","v":{"v":8922,"d":"8,922"}},{"$f":"ROUND(C22*15%,0)","v":0},0,0,0,0,{"v":8922,"d":"8,922"},0,0,0,0,{"$f":"ROUND(IF(Details!C21=\"Yes\",(C22+E22)*10%,IF(Details!C21=\"No\",0)),0)","v":0},0,0,null,{"$f":"ROUND((Details!K16*S12%),0)","v":1722}]
[null,"Surrender",{"$f":"ROUND(IF(Details!C31=\"Nil\",0,IF(Details!C31=\"Mar\",C9/2,IF(Details!C31=\"Apr\",C10/2,IF(Details!C31=\"May\",C11/2,IF(Details!C31=\"Jun\",C12/2,IF(Details!C31=\"Jul\",C13/2,IF(Details!C31=\"Aug\",C14/2,IF(Details!C31=\"Sep\",C15/2,IF(Details!C31=\"Oct\",C16/2,IF(Details!C31=\"Nov\",C17/2,IF(Details!C31=\"Dec\",C18/2,IF(Details!C31=\"Jan\",C19/2,IF(Details!C31=\"Feb\",C20/2))))))))))))),0)","v":0},{"$f":"ROUND(IF(Details!C31=\"Nil\",0,IF(Details!C31=\"Mar\",D9/2,IF(Details!C31=\"Apr\",D10/2,IF(Details!C31=\"May\",D11/2,IF(Details!C31=\"Jun\",D12/2,IF(Details!C31=\"Jul\",D13/2,IF(Details!C31=\"Aug\",D14/2,IF(Details!C31=\"Sep\",D15/2,IF(Details!C31=\"Oct\",D16/2,IF(Details!C31=\"Nov\",D17/2,IF(Details!C31=\"Dec\",D18/2,IF(Details!C31=\"Jan\",D19/2,IF(Details!C31=\"Feb\",D20/2))))))))))))),0)","v":0},{"$f":"ROUND(IF(Details!C31=\"Nil\",0,IF(Details!C31=\"Mar\",E9/2,IF(Details!C31=\"Apr\",E10/2,IF(Details!C31=\"May\",E11/2,IF(Details!C31=\"Jun\",E12/2,IF(Details!C31=\"Jul\",E13/2,IF(Details!C31=\"Aug\",E14/2,IF(Details!C31=\"Sep\",E15/2,IF(Details!C31=\"Oct\",E16/2,IF(Details!C31=\"Nov\",E17/2,IF(Details!C31=\"Dec\",E18/2,IF(Details!C31=\"Jan\",E19/2,IF(Details!C31=\"Feb\",E20/2))))))))))))),0)","v":0},{"$f":"ROUND(IF(Details!C31=\"Nil\",0,IF(Details!C31=\"Mar\",F9/2,IF(Details!C31=\"Apr\",F10/2,IF(Details!C31=\"May\",F11/2,IF(Details!C31=\"Jun\",F12/2,IF(Details!C31=\"Jul\",F13/2,IF(Details!C31=\"Aug\",F14/2,IF(Details!C31=\"Sep\",F15/2,IF(Details!C31=\"Oct\",F16/2,IF(Details!C31=\"Nov\",F17/2,IF(Details!C31=\"Dec\",F18/2,IF(Details!C31=\"Jan\",F19/2,IF(Details!C31=\"Feb\",F20/2))))))))))))),0)","v":0},0,0,0,{"$f":"IF(C23>1,J20/2,IF(C23<1,\"0\"))","v":"0"},0,0,0,0,0,0,0,0,null,{"$f":"SUM(T20:T22)","v":5166}]
[null,"Surender DA",0,0,{"$f":"IF(Details!C31=\"Nil\",0,IF(Details!C31=\"Mar\",C23*S12%,IF(Details!C31=\"Apr\",0,IF(Details!C31=\"May\",0,IF(Details!C31=\"Jun\",0,IF(Details!C31=\"Jul\",C23*S13%,IF(Details!C31=\"Aug\",C23*S13%,IF(Details!C31=\"Sep\",C23*S13%,IF(Details!C31=\"Oct\",0,IF(Details!C31=\"Nov\",0,IF(Details!C31=\"Dec\",0,IF(Details!C31=\"Jan\",0,IF(Details!C31=\"Feb\",0)))))))))))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND((C13*S13%),0)","v":2974}]
[null,"Arrears",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND((C14*S13%),0)","v":2974}]
[null,"Others",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND((C15*S13%),0)","v":2974}]
[null,null,{"$f":"C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26","v":{"v":754500,"d":"754,500"}},0,{"$f":"E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26","v":{"v":76435,"d":"76,435"}},{"$f":"F9+F10+F11+F12+F13+F14+F15+F16+F17+F18+F19+F20+F21+F22+F23+F24+F25+F26","v":{"v":60360,"d":"60,360"}},0,0,0,0,{"v":891295,"d":"891,295"},{"v":2400,"d":"2,400"},{"v":24000,"d":"24,000"},{"v":24000,"d":"24,000"},{"v":15264,"d":"15,264"},0,{"v":4320,"d":"4,320"},0,null,{"$f":"SUM(T24:T26)","v":8922}]
[null,"1. Gross Total salary.",{"$nulls":15},{"$f":"K27","v":{"v":891295,"d":"891,295"}}]
[null,"2. Agricultural Income",{"$nulls":15},{"$f":"Details!C35","v":0},{"v":9,"d":"रु 9"}]
[null,"3. Other Income",{"$nulls":15},0]
[null,"4. Standard Deduction U/C 16.(40,000/-)",{"$nulls":15},{"v":50000,"d":"50,000"}]
[null,"5. Total Income",{"$nulls":15},{"$f":"R28+R29+R30-R31","v":{"v":841295,"d":"841,295"}},{"$f":"ROUND(IF(S29>=1000000,112500+(S29-1000000)*30%,IF(S29>=500000,12500+(S29-500000)*20%,IF(S29>=250000,(S29-250000)*5%,IF(S29<250000,0)))),0)","v":{"v":0,"d":"रु 0"}}]
[null,"6. Less : HRA U/S 10 (13A)",null,null,"Actual HRA received",null,null,{"$f":"F9+F10+F11+F12+F13+F14+F15+F16+F17+F18+F19+F20","v":{"v":60360,"d":"60,360"}},"Rent paid in excess of 10% of salary",{"$nulls":3},{"$f":"T37","v":{"v":99000,"d":"99,000"}},"40% of Basic Pay",null,{"$f":"ROUND((C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20)*40%,0)","v":{"v":301800,"d":"301,800"}},"Eligible HRA",{"$f":"IF(Details!C29=\"Yes\",S33,IF(Details!C29=\"No\",0))","v":0},{"$f":"IF(H33<M33,H33,IF(M33<P33,M33,IF(P325<H33,P33)))","v":60360}]
[null,"7. DEDUCTION P.T.",{"$nulls":14},{"$f":"L27","v":{"v":2400,"d":"रु 2,400"}},{"$f":"R32-R33-Q34","v":{"v":838895,"d":"838,895"}},null,{"$f":"H33","v":{"v":60360,"d":"60,360"}}]
[null,"8. House Property Interest payable on barrowed capital U/S 24",{"$nulls":14},0,{"$f":"IF(Q35>=200000,\"200000\",IF(Q35<200000,Q35))","v":0},null,{"$f":"Details!C30*12","v":99000}]
[null,"8. Income chargable under the head \"Salaries\" ",{"$nulls":15},{"$f":"R34-R35","v":{"v":838895,"d":"838,895"}},null,{"$f":"IF(T34-T35<1,0,IF(T34-T35>1,T34-T35))","v":0}]
[null,"9. Saving Bank Interest. / NSC Accrued Interest. / Infr Structure Bond Interest. ",{"$nulls":17},{"$f":"IF(T35-T36<1,0,IF(T35-T36>1,T35-T36))","v":{"v":99000,"d":"99,000"}}]
[null,null,0,null,0,null,0,{"$nulls":3},"Total",{"$f":"C38+E38+G38","v":{"v":0,"d":"Rs. 0"}},{"$nulls":5},{"$f":"R36+L38","v":{"v":838895,"d":"838,895"}}]
[null,"10. Deduction U/S 80C K.G.I.D.",null,null,{"$f":"N27","v":{"v":24000,"d":"24,000"}},"L.I.C",{"$f":"O27","v":{"v":15264,"d":"15,264"}},"G.P.F.",{"$f":"M27","v":{"v":24000,"d":"24,000"}},"G.I.S./ F.B.F",{"$f":"Q27","v":{"v":4320,"d":"4,320"}},"Tution Fee",null,null,"Private Insurance"]
[{"$nulls":3},"P.L.I",0,"Sukanya Samruddi Yojane",{"$nulls":3},"Housing Loan Principle Amt",{"$nulls":4},"Othres"]
[{"$nulls":12},"Amount",null,null,"Eligible Amt"]
[null,null,"80C- L.I.C.,G.P.F.,P.L.I.,G.I.S.,Debenturs,mutual funds other savings.",{"$nulls":9},{"$f":"E39+G39+I39+K39+N39+Q39+E40+I40+N40+Q40","v":{"v":67584,"d":"67,584"}},null,null,{"$f":"IF(M42>=150000,\"150000\",IF(M42>1,M42,IF(M42<1,\"0\")))","v":{"v":67584,"d":"67,584"}},null,{"$f":"P43","v":{"v":67584,"d":"67,584"}}]
[null,null,"80CCC Payment in respect Pension Fund",{"$nulls":9},0,null,null,{"$f":"IF(P42+M43+M44+M45>=200000,\"200000\",IF(P42+M43+M44++M45<=200000,P42+M43+M44+M45))","v":{"v":67584,"d":"67,584"}},{"$nulls":3},{"$f":"Details!C30*12","v":99000}]
[null,null,"80CCD(1) - Contribution to pension scheme of Central Government",{"$nulls":9},0,{"$nulls":5},{"$f":"IF(Details!C27=\"Yes\",38400,IF(Details!C27=\"No\",0))","v":0}]
[null,null,"80CCD(1B) - Contribution to pension scheme of Central Government by employee",{"$nulls":9},{"$f":"IF(Details!C21=\"Yes\",P27,IF(Details!C21=\"No\",0))","v":0},{"$nulls":6},{"$f":"ROUND((C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20)*10%,0)","v":81685}]
[null,null,"80CCD(2) - Contribution to pension scheme of Central Government by employer",{"$nulls":9},0,null,null,{"$f":"IF(M46>=75000,\"75000\",IF(M46<75000,M46,IF(M46=0,\"0\")))","v":0},null,{"$f":"P46","v":0}]
[null,null,"80CCG - Investment made under an equity savings scheme",{"$nulls":9},0,null,null,{"$f":"IF(M47>=25000,\"25000\",IF(M47<25000,M47,IF(M47=0,\"0\")))","v":0},null,0]
[null,null,"80D -Health insurance Premium",{"$nulls":3},"Self and family including senior citizen parents",{"$nulls":5},0,null,null,{"$f":"IF(M48>=S48,S48,IF(M48<S48,M48))","v":0},null,0,{"$f":"IF(G48=\"Select\",0,IF(G48=\"Self and Family\",25000,IF(G48=\"Prents\",30000,IF(G48=\"Prents(senior citizen)\",50000,IF(G48=\"Self and family including parents\",55000,IF(G48=\"Self and family including senior citizen parents\",60000))))))","v":60000},{"$f":"T43-T45","v":17315}]
[null,null,"80DD - Dependent person with Disability",{"$nulls":4},"Dependent person with disability",{"$nulls":4},0,null,null,{"$f":"IF(M49>=S49,S49,IF(M49<S49,M49))","v":0},null,0,{"$f":"IF(H49=\"Select\",0,IF(H49=\"Dependent person with disability\",75000,IF(H49=\"Dependent person with sever disability\",125000)))","v":{"v":75000,"d":"75,000"}},0]
[null,null,"80DDB - Medical Treatment of Specified Disease",{"$nulls":4},"Self or dependent",{"$nulls":4},0,null,null,{"$f":"IF(M50>=S50,S50,IF(M50<S50,M50))","v":0},null,{"$f":"P50","v":0},{"$f":"IF(H50=\"Select\",0,IF(H50=\"Self or dependent\",40000,IF(H50=\"Senior citizen Self or dependent\",60000,IF(H50=\"Super senior citizen Self or dependent\",80000))))","v":40000}]
[null,null,"80E - Interest on loan taken for higher education",{"$nulls":9},0,null,null,{"$f":"IF(M51>=R28,R28,IF(M51<R28,M51))","v":0},null,0]
[null,null,"80EE - Interest on loan taken for residential house property",{"$nulls":9},0,null,null,{"$f":"IF(M52>=50000,\"50000\",IF(M52>1,M52,IF(M52<1,\"0\")))","v":"0"},null,"0"]
[null,null,"80G - Donations to certain funds, ",{"$nulls":9},0,null,null,{"$f":"M53","v":0},null,0,{"$f":"ROUND(K14/30,0)+M53","v":{"v":2389,"d":"2,389"}}]
[null,null,"80GG - Rent paid",{"$nulls":9},0,null,null,{"$f":"IF(M54>=60000,\"60000\",IF(M54>1,M54,IF(M54<1,\"0\")))","v":"0"},null,"0"]
[null,null,"80GGA - Certain donations for scientific research or rural development",{"$nulls":9},0,null,null,{"$f":"IF(M55>=R28,R28,IF(M55<R28,M55))","v":0},null,0]
[null,null,"80GGC - Donation to Political party",{"$nulls":9},0,null,null,{"$f":"IF(M56>=R28,R28,IF(M56<R28,M56))","v":0},null,0]
[null,null,"80TTA - Income from Interest on saving bank Accounts",{"$nulls":5},"Select",{"$nulls":3},{"$f":"L38","v":0},null,null,{"$f":"S57","v":0},null,0,{"$f":"IF(I57=\"Select\",0,IF(I57=\"Citizen\",10000,IF(I57=\"Senior Citizen\",50000)))","v":0}]
[null,null,"80U- Person with disability",null,null,"Self with Disability",{"$nulls":6},0,null,null,{"$f":"IF(Details!C27=\"Yes\",S58,IF(Details!C27=\"No\",0))","v":0},null,{"$f":"IF(Details!C27=\"Yes\",P58,IF(Details!C27=\"No\",0))","v":0},{"$f":"IF(F58=\"Select\",0,IF(F58=\"Self with sever Disability\",125000,IF(F58=\"Self with Disability\",75000)))","v":75000}]
[null,null,"10(14) Travelling Allowance for P.W.D. person",{"$nulls":9},{"$f":"H27","v":0},null,null,{"$f":"IF(M59>=38400,\"38400\",IF(M59>1,M59,IF(M59<1,\"0\")))","v":"0"},null,{"$f":"P59","v":"0"}]
[{"$nulls":12},"Total Amount",{"$nulls":4},{"$f":"R42+R43+R44+R45+R46+R47+R48+R49+R50+R51+R52+R53+R54+R55+R56+R57+R58+R59","v":{"v":67584,"d":"67,584"}},{"$f":"P60+J61","v":{"v":0,"d":"रु 0"}}]
[null,"11. TOTAL TAXABLE  INCOME",{"$nulls":14},{"$f":"IF(S60<1,\"0\",IF(S60>=200000,\"200000\",IF(S60<200000,S60)))","v":"0"},{"$f":"IF(S62<1,\"0\",IF(S62>0,S62))","v":{"v":771311,"d":"771,311"}},{"$f":"P61+J62","v":{"v":0,"d":"रु 0"}}]
[null,"12. TOTAL TAX",{"$nulls":15},{"$f":"IF(S63<1,\"0\",IF(S63>1,S63))","v":{"v":66762,"d":"66,762"}},{"$f":"R38-R60","v":{"v":771311,"d":"771,311"}}]
[null,"13. Less Income Under Section 10(1) (Agricultural Income)",{"$nulls":15},{"$f":"S32","v":0},{"$f":"ROUND(IF(R61>=1000000,112500+(R61-1000000)*30%,IF(R61>=500000,12500+(R61-500000)*20%,IF(R61>=250000,(R61-250000)*5%))),0)","v":66762}]
[null,"14. Tax",{"$nulls":15},{"$f":"IF(S64<1,\"0\",IF(S64>=1,S64))","v":{"v":66762,"d":"66,762"}},{"$f":"R62-R63","v":{"v":66762,"d":"रु 66,762"}}]
[null,"15. Rebata U/S 87A",{"$nulls":15},{"$f":"ROUND(IF(R61<=250000,\"0\",IF(R61<=500000,(R61-250000)*5%,IF(R61<=500000,\"12500\",IF(R61>=500000,\"0\")))),0)","v":0}]
[null,"16. Net Tax",{"$nulls":15},{"$f":"R64-R65","v":{"v":66762,"d":"66,762"}}]
[null,"15. Edn Cess 4%",{"$nulls":15},{"$f":"ROUND(R66*4%,0)","v":{"v":2670,"d":"2,670"}}]
[null,"16. Less Income Under Section 89 (Salary Arrears/ Advance)",{"$nulls":15},0]
[null,"17. TOTAL TAX",{"$nulls":15},{"$f":"R66+R67-R68","v":{"v":69432,"d":"69,432"}}]
[null,"18. TAX ADVANCE PAID.",{"$nulls":15},{"$f":"R27","v":0}]
[null,"19. PAYABLE TAX / REFUNDABLE AMT.",{"$nulls":15},{"$f":"R69-R70","v":{"v":69432,"d":"69,432"}}]
[null,"20. TAX IN WORDS.",null,null,{"$f":"SpellNumber(R69)","v":{"$error":"#VALUE!"}},{"$nulls":14},10]
[]
[]
[]
[{"$nulls":7},"Sign of Employee",{"$nulls":5},"Sign of Employer"]
[null,null,"Place : ","Dharwad",{"$nulls":3},{"$f":"C3","v":"ಶ್ರೀನಿವಾಸ ಹೆಚ್.ಟಿ."},{"$nulls":5},{"$f":"Details!C7","v":"NANJUSNDAIAH"}]
[null,null,"Date   :",{"$f":"TODAY()","v":"2020-01-21"},{"$nulls":3},{"$f":"K3","v":"ದೈಹಿಕ ಶಿಕ್ಷಣ ಶಿಕ್ಷಕರು(ಗ್ರೇಡ್-1)"},{"$nulls":5},{"$f":"Details!C8","v":"SENIOR ASSISTANT TEACHER"}]

{"sheet":"Form 16 A..","index":3,"n_rows":64,"n_cols":9,"rows_kept":64,"merged":[[0,0,63,0],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,3],[3,4,3,7],[4,1,4,3],[4,4,4,7],[5,1,5,3],[6,1,6,3],[6,4,6,7],[7,1,7,2],[8,1,8,2],[9,1,10,3],[9,5,9,6],[11,1,11,7],[18,1,18,3],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,8,29,10],[29,12,29,13],[30,8,30,10],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,1,40,4],[41,1,41,3],[42,1,42,3],[43,1,43,4],[44,1,44,2],[47,1,47,2],[48,1,48,4],[49,1,49,2],[52,2,52,7],[53,5,53,7],[54,5,54,7],[55,5,55,7],[56,5,56,7],[57,5,57,7],[58,1,58,2],[59,2,59,7],[62,4,62,7]]}
["KARUNADU DIVYANGA NAUKARAR SANGHA - ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ - KARUNADU DIVYANGA NAUKARAR SANGHA - ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ - KARUNADU DIVYANGA NAUKARAR SANGHA - ಕರುನಾಡು ದಿವ್ಯಾಂಗ ನೌಕರರ ಸಂಘ","FORM NO 16"]
[null,"(See Rule 31 (1) (a))"]
[null,"Certified under 203 of Income Tax Act 1961 for Tax deducted at Source from Income Chargable under the head \"Salaries\""]
[null,"NAME & ADDRESS OF THE EMPLOYER",null,null,"NAME & DESIGNATION OF THE EMPLOYEE"]
[null,{"$f":"Details!C7","v":"NANJUSNDAIAH"},null,null,{"$f":"'Form 16'!C3","v":"ಶ್ರೀನಿವಾಸ ಹೆಚ್.ಟಿ."}]
[null,{"$f":"Details!C8","v":"SENIOR ASSISTANT TEACHER"},{"$nulls":3},{"$f":"'Form 16'!K3","v":"ದೈಹಿಕ ಶಿಕ್ಷಣ ಶಿಕ್ಷಕರು(ಗ್ರೇಡ್-1)"},"KGID No.",{"$f":"Details!F4","v":1260321}]
[null,{"$f":"E7","v":"GJC(HS) KARIMUDDANAHALLI, HUNSUR TQ."},null,null,{"$f":"'Form 16'!J5","v":"GJC(HS) KARIMUDDANAHALLI, HUNSUR TQ."}]
[null,"PAN No",null,"TAN No","PAN No","Aadhar No","IFSC Code","Saving A/C Number"]
[{"$nulls":3},{"$f":"'Form 16'!O4","v":0},{"$f":"'Form 16'!O5","v":"AXTPS4023M"},{"$f":"'Form 16'!D5","v":497378753229},{"$f":"Details!C34","v":"SBIN0001730"},{"$f":"Details!C33","v":{"v":35218478899,"d":"035218478899"}}]
[null,"TDS Circle where Annual Return / statement under section 206 to be filed   I.T.O. - III Hubli",null,null,"Date of Birth of Employee","Period",null,"Assessment Year"]
[{"$nulls":4},{"$f":"Details!C32","v":"2019-10-21"},"From                                 01/ April / 2019","To                      31/ March / 2020","2020-21"]
[null,"Details of salary paid and any other income and Tax deducted"]
[null,1,"Gross Salary",{"$nulls":4},{"$f":"'Form 16'!C27","v":{"v":754500,"d":"754,500"}},{"$f":"'Form 16'!D27+'Form 16'!E27+'Form 16'!F27+'Form 16'!G27+'Form 16'!H27+'Form 16'!I27+'Form 16'!J27","v":{"v":136795,"d":"136,795"}}]
[null,2,"Allowance not exempt",{"$nulls":4},{"$f":"I13-I14","v":{"v":136795,"d":"136,795"}},{"$f":"'Form 16'!P59","v":"0"}]
[null,3,"Less : Allowance to the extent exmpt under section 10",{"$nulls":4},{"$f":"'Form 16'!R63","v":0}]
[null,4,"Balance (1-2-3)",{"$nulls":4},{"$f":"H13-H14-H15","v":{"v":617705,"d":"617,705"}}]
[null,"4.a","House Property Interest payable on barrowed capital U/S 24",{"$nulls":4},{"$f":"'Form 16'!R35","v":0}]
[null,5,"Deductions : a) Tax on employment U/s 16(III)"]
[null,"                       b) Entertainment allowance U/s 16(II)"]
[null,6,"Agregate of 4 (a+b)",{"$nulls":4},{"$f":"H17+H18+H19","v":0}]
[null,7," Income Chargable under the head 'SALARIES' (4-6)",{"$nulls":4},{"$f":"H16-H20","v":{"v":617705,"d":"617,705"}}]
[null,8,"Deduction under chapter VI A"]
[null,null,"80C- L.I.C.,G.P.F.,P.L.I.,G.I.S.,Debenturs,mutual funds other savings.",{"$nulls":4},{"$f":"'Form 16'!R42","v":{"v":67584,"d":"67,584"}}]
[null,null,"80CCC Payment in respect Pension Fund",{"$nulls":4},{"$f":"'Form 16'!R43","v":0}]
[null,null,"80CCD(1) - Contribution to pension scheme of Central Government",{"$nulls":4},{"$f":"'Form 16'!R44","v":0}]
[null,null,"80CCD(1B) - Contribution to pension scheme of Central Government by employee",{"$nulls":4},{"$f":"'Form 16'!R45","v":0}]
[null,null,"80CCD(2) - Contribution to pension scheme of Central Government by employer",{"$nulls":4},{"$f":"'Form 16'!R46","v":0}]
[null,null,"80CCG - Investment made under an equity savings scheme",{"$nulls":4},{"$f":"'Form 16'!R47","v":0}]
[null,null,"80D -Health insurance Premium",{"$nulls":4},{"$f":"'Form 16'!R48","v":0}]
[null,null,"80DD - Dependent person with Disability",{"$nulls":4},{"$f":"'Form 16'!R49","v":0}]
[null,null,"80DDB - Medical Treatment of Specified Disease",{"$nulls":4},{"$f":"'Form 16'!R50","v":0}]
[null,null,"80E - Interest on loan taken for higher education",{"$nulls":4},{"$f":"'Form 16'!R51","v":0}]
[null,null,"80EE - Interest on loan taken for residential house property",{"$nulls":4},{"$f":"'Form 16'!R52","v":"0"}]
[null,null,"80G - Donations to certain funds, charitable institutions, etc",{"$nulls":4},{"$f":"'Form 16'!R53","v":0}]
[null,null,"80GG - Rent paid",{"$nulls":4},{"$f":"'Form 16'!R54","v":"0"}]
[null,null,"80GGA - Certain donations for scientific research or rural development",{"$nulls":4},{"$f":"'Form 16'!R55","v":0}]
[null,null,"80GGC - Donation to Political party",{"$nulls":4},{"$f":"'Form 16'!R56","v":0}]
[null,null,"80TTA - Income from Interest on saving bank Accounts",{"$nulls":4},{"$f":"'Form 16'!R57","v":0}]
[null,null,"80U- Person with disability",{"$nulls":4},{"$f":"'Form 16'!R58","v":0}]
[null,null,"10(14) Travelling Allowance for P.W.D. person",{"$nulls":4},{"$f":"'Form 16'!R59","v":"0"}]
[null,"9. Agregate of Tax Rebate & Relief",{"$nulls":5},{"$f":"H23+H24+H25+H26+H27+H28+H29+H30+H31+H32+H33+H34+H35+H36+H37+H38+H39+H40","v":{"v":67584,"d":"67,584"}}]
[null,"10.Total Taxable Income (8-10+12)",{"$nulls":5},{"$f":"'Form 16'!R61","v":{"v":771311,"d":"771,311"}}]
[null,"11. Tax On Total Income",{"$nulls":5},{"$f":"'Form 16'!R62","v":{"v":66762,"d":"66,762"}}]
[null,"12. Less Income Under Section 10(1) (Agricultural Income)",{"$nulls":5},{"$f":"'Form 16'!R63","v":0}]
[null,"13. Tax",{"$nulls":5},{"$f":"'Form 16'!R64","v":{"v":66762,"d":"66,762"}}]
[null,"14. Rebata U/S 87A",{"$nulls":5},{"$f":"'Form 16'!R65","v":0}]
[null,"15.  Net Tax",{"$nulls":5},{"$f":"'Form 16'!R66","v":{"v":66762,"d":"66,762"}}]
[null,"16.  Edn Cess 4%",{"$nulls":5},{"$f":"'Form 16'!R67","v":{"v":2670,"d":"2,670"}}]
[null,"17. Less Income Under Section 89 (Salary Arrears/ Advance)",{"$nulls":5},{"$f":"'Form 16'!R68","v":0}]
[null,"18.  Agregate Total Tax ",{"$nulls":5},{"$f":"'Form 16'!R69","v":{"v":69432,"d":"69,432"}}]
[null,"19. Total Tax Paid",{"$nulls":5},{"$f":"'Form 16'!R70","v":0}]
[null,"20. Refund/ Balance Tax",{"$nulls":5},{"$f":"'Form 16'!R71","v":{"v":69432,"d":"69,432"}}]
[null,null,"DETAILS OF TAX DEDUCTION AND DEPOSITED IN TO CENTRAL GOVT.ACCOUNT"]
[null,null,"Quarter","Amount","Date of Payment","Bank Name & Branch"]
[null,null,1,{"$f":"Details!I12+Details!I13+Details!I14","v":0}]
[null,null,2,{"$f":"Details!I15+Details!I16+Details!I17","v":0}]
[null,null,3,{"$f":"Details!I18+Details!I19+Details!I20","v":0}]
[null,null,4,{"$f":"Details!I21+Details!I22+Details!I23","v":0}]
[null,"Certified that a sum of",null,{"$f":"H50","v":{"v":69432,"d":"रु 69,432"}},{"$f":"SpellNumber(D59)","v":{"$error":"#VALUE!"}}]
[null,null,"has been deducted at source and paid to the credit of the central Govt. further certified that above information is true and correct as per records."]
[]
[]
[null,null,"Place  :",null,"             Sign of the person responsible for deduction of Tax "]
[null,null,"Date    :",{"$f":"TODAY()","v":"2020-01-21"},null,{"$f":"B5","v":"NANJUSNDAIAH"},{"$f":"B6","v":"SENIOR ASSISTANT TEACHER"}]