{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Pay","Developer's desk","Information & Rules","ENTRY","G.A. 55","COMPUTATION","HRA","16 NO.","89(1)form","Form10E"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":47,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pay","index":0,"n_rows":86,"n_cols":31,"rows_kept":86,"cut":false,"hidden":true,"merged":[[4,1,4,8],[0,4,0,5],[1,1,1,8],[1,25,3,27],[2,1,2,8],[3,1,3,8],[5,1,5,2],[5,4,5,5],[5,7,5,8],[6,1,6,2],[6,4,6,5],[6,7,6,8],[7,1,7,2],[7,3,7,8],[7,25,8,27],[8,1,8,2],[8,4,8,5],[8,7,8,8],[40,10,40,18],[40,19,40,25],[40,26,40,29],[9,1,9,2],[9,4,9,5],[9,7,9,8],[10,1,10,2],[10,4,10,5],[11,1,11,3],[11,5,11,8],[41,7,41,8],[86,1,87,2],[15,5,15,7],[24,1,24,4],[24,5,24,8]]}
[]
[null,"Presented By :- VIJAY RANWA, TEACHER, GSS DHANERU"]
[null,"7th Pay Commission Calculator- http://www.vijayranwa.jimdo.com"]
[null,"SALARY Calculator of 7'th Pay Commission"]
[]
[null,"Name of employee :-",null,"VIJAY RANWA","vijay ranwa",null,null,"fot; j.koka"]
[null,"Designation of employee :-",null,"TEACHER","teacher",null,null,"v/;kid",null,"Fix Pay"]
[null,"Name of Department / Office :-",null,"GOVT SEC SCHOOL DHANERU"]
[null,"Existing Runnning Pay Band :-",null,null,"9300-34800 (PB-2)",null,null,"VIJAYSALASAR2011@GMAIL.COM"]
[null,"Grade Pay :-",null,null,{"$f":"ENTRY!C15","v":4200},null,null,"WHAT. 9828113904"]
[null,"Fix Pay /Regular Pay :-",null,null,"Regular"]
[null,"7th Pay Calculations Option Date",null,null,"2016-01-01","Present Pay (6th) Calculations"]
[null,"31 Dec. 2015 Basic",null,null,{"$f":"'G.A. 55'!C15","v":21930}]
[null,"7th pay (Oct 2017 Basic)",2.57,{"$f":"IF(AND(E11=J7),\"0\",E13*C14)","v":56360.1},{"$f":"ROUND(D14,0)","v":56360}]
[null,"Basic Acco.to Matrix",null,null,{"$f":"IF(AND(E11=J7),F44,E45)","v":57200}]
[null,"New Basic",null,null,{"$f":"E15","v":57200},"Basic 1 JAN. 2016",null,null,{"$f":"E13","v":21930}]
[null,"DA 5%",null,{"$f":"IF(AND(D11=J7),\"0\",E16*C17/100)","v":0},{"$f":"ROUND(D17,0)","v":0},null,125,{"$f":"I16*G17/100","v":27412.5},{"$f":"ROUND(H17,0)","v":27413}]
[null,"Basic +DA",null,null,{"$f":"SUM(E16:E17)","v":57200},null,null,null,{"$f":"SUM(I16:I17)","v":49343}]
[null,"HRA",8,{"$f":"IF(AND(D11=J7),\"0\",E16*C19/100)","v":4576},{"$f":"ROUND(D19,0)","v":4576},10,null,{"$f":"I16*F19/100","v":2193},{"$f":"ROUND(H19,0)","v":2193}]
[null,"CCA",null,null,{"$f":"C20","v":0},"CCA",null,null,{"$f":"H20","v":0}]
[null,"Washing All.",null,null,{"$f":"C21","v":0},"Washing All.",null,null,{"$f":"H21","v":0}]
[null,"Ph.  Allowace",null,null,{"$f":"C22","v":0},"Ph.  Allowace",null,null,{"$f":"H22","v":0}]
[null,"OTHER",null,null,{"$f":"C23","v":0},"OTHER",null,null,{"$f":"H23","v":0}]
[null,"Gross Pay",null,null,{"$f":"SUM(E18:E23)","v":61776},null,null,null,{"$f":"SUM(I18:I23)","v":51536}]
[null,"DEDUCTION",null,null,null,"DEDUCTION"]
[null,"NPS Ded.",10,{"$f":"IF(AND(D11=J7),\"0\",IF(AND(D28>0),0,E18*C26/100))","v":5720},{"$f":"IF(AND(D26=\"\"),\"0\",ROUND(D26,0))","v":5720},"NPS Ded.",10,{"$f":"IF(AND(D11=J7),\"0\",IF(AND(H28>0),0,I18*G26/100))","v":4934.3},{"$f":"IF(AND(H26=\"\"),\"0\",ROUND(H26,0))","v":4934}]
[null,"SI Ded",2650,null,{"$f":"C27","v":2650},"SI Ded.",null,2650,{"$f":"H27","v":2650}]
[null,"GPF",null,null,{"$f":"C28","v":0},"GPF",null,null,{"$f":"IF(AND(I9=\"\"),\"\",IF(AND(I9=\"GPF\"),H28,IF(AND(I9=\"NPS\"),\"0\")))","v":""}]
[null,"RPMF",null,null,{"$f":"C29","v":0},"RPMF",null,null,{"$f":"IF(AND(I9=\"\"),\"\",IF(AND(I9=\"GPF\"),H29,IF(AND(I9=\"NPS\"),\"0\")))","v":""}]
[null,"LIC",null,null,{"$f":"C30","v":0},"LIC",null,null,{"$f":"H30","v":0}]
[null,"Income Tax",null,null,{"$f":"C31","v":0},"Income Tax",null,null,{"$f":"H31","v":0}]
[null,"Other Ded.",null,null,0,"Other Ded.",null,null,{"$f":"H32","v":0}]
[null,"Total Deduction",null,null,{"$f":"SUM(E26:E32)","v":8370},"Total Deduction",null,null,{"$f":"SUM(I26:I32)","v":7584}]
[null,"Net Pay",null,null,{"$f":"E24-E33","v":53406},"Net Pay",null,null,{"$f":"I24-I33","v":43952}]
[]
[null,null,null,null,null,"Difference",{"$f":"E34-I34","v":9454},{"$f":"G36","v":9454}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"PB-1",null,null,null,null,null,null,null,null,"PB-3",null,null,null,null,null,null,"PB-4"]
[null,null,null,null,null,{"$f":"E10","v":4200},null,"PB2",null,null,1700,1750,1900,2000,"2400A","2400B","2400C","2800A","2800B","5400B",6000,6600,6800,7200,7600,8200,8700,8900,9500,10000]
[null,null,null,null,null,null,4200,4800,3600,"5400A",1,2,3,4,5,6,7,8,9,14,15,16,17,18,19,20,21,22,23,24]
[null,null,null,{"$f":"F44","v":26500},{"$f":"E14","v":56360},{"$f":"IF($F$42=4200,G44,IF($F$42=4800,H44,IF($F$42=\"5400A\",J44,IF($F$42=3600,I44,IF($F$42=1700,K44,IF($F$42=1750,L44,IF($F$42=1900,M44,IF($F$42=2000,N44,IF($F$42=\"2400A\",O44,IF($F$42=\"2400B\",P44,IF($F$42=\"2400C\",Q44,IF($F$42=\"2800A\",R44,IF($F$42=\"2800B\",S44,IF($F$42=\"5400B\",T44,IF($F$42=6000,U44,IF($F$42=6600,V44,IF($F$42=6800,W44,IF($F$42=7200,X44,IF($F$42=7600,Y44,IF($F$42=8200,Z44,IF($F$42=8700,AA44,IF($F$42=8900,IF($F$42=9500,AC44,IF($F$42=10000,AD44,\"\"))))))))))))))))))))))))","v":26500},26500,31100,23700,39300,12400,12600,12800,13500,14600,15100,15700,18500,20100,39300,42500,47200,49700,52800,58000,62300,86200,90800,102100,104200]
[null,null,null,37800,{"$f":"IF(AND(E44<=F44),F44,INDEX($D$44:$D$83,MATCH(E44,$F$44:$F$83)+(LOOKUP(E44,$F$44:$F$83)<>E44)))","v":57200},{"$f":"IF($F$42=4200,G45,IF($F$42=4800,H45,IF($F$42=\"5400A\",J45,IF($F$42=3600,I45,IF($F$42=1700,K45,IF($F$42=1750,L45,IF($F$42=1900,M45,IF($F$42=2000,N45,IF($F$42=\"2400A\",O45,IF($F$42=\"2400B\",P45,IF($F$42=\"2400C\",Q45,IF($F$42=\"2800A\",R45,IF($F$42=\"2800B\",S45,IF($F$42=\"5400B\",T45,IF($F$42=6000,U45,IF($F$42=6600,V45,IF($F$42=6800,W45,IF($F$42=7200,X45,IF($F$42=7600,Y45,IF($F$42=8200,Z45,IF($F$42=8700,AA45,IF($F$42=8900,IF($F$42=9500,AC45,IF($F$42=10000,AD45,\"\"))))))))))))))))))))))))","v":37800},37800,44300,33800,53100,17700,17900,18200,19200,20800,21500,22400,25300,28700,56100,60700,67300,71000,75300,79900,88900,123100,129700,145800,148800]
[null,null,{"$f":"IF(AND(E44<=F44),F44,INDEX($D$44:$D$83,MATCH(E44,$F$44:$F$83)+(LOOKUP(E44,$F$44:$F$83)<>E44)))","v":57200},38900,null,38900,38900,45600,34800,54700,18200,18400,18700,19800,21400,22100,23100,27100,29600,57800,62500,69300,73100,77600,82300,91600,126800,133600,150200,153300]
[null,null,null,40100,null,40100,40100,47000,35800,56300,18700,19000,19300,20400,22000,22800,23800,27900,30500,59500,64400,71400,75300,79900,84800,94300,130600,137600,154700,157900]
[null,null,null,41300,null,41300,41300,48400,36900,58000,19300,19600,19900,21000,22700,23500,24500,28700,31400,61300,66300,73500,77600,82300,87300,97100,134500,141700,159300,162600]
[null,null,null,42500,null,42500,42500,49900,38000,59700,19900,20200,20500,21600,23400,24200,25200,29600,32300,63100,68300,75700,79900,84800,89900,100000,138500,146000,164100,167500]
[null,null,null,43800,null,43800,43800,51400,39100,61500,20500,20800,21100,22200,24100,24900,26000,30500,33300,65000,70300,78000,82300,87300,92600,103000,142700,150400,169000,172500]
[null,null,null,45100,null,45100,45100,52900,40300,63300,21100,21400,21700,22900,24800,25600,26800,31400,34300,67000,72400,80300,84800,89900,95400,106100,147000,154900,174100,177700]
[null,null,null,46500,null,46500,46500,54500,41500,65200,21700,22000,22400,23600,25500,26400,27600,32300,35300,69000,74600,82700,87300,92600,98300,109300,151400,159500,179300,183000]
[null,null,null,47900,null,47900,47900,56100,42700,67200,22400,22700,23100,24300,26300,27200,28200,33300,36400,71100,76800,85200,89900,95400,101200,112600,155900,164300,184700,188500]
[null,null,null,49300,null,49300,49300,57800,44000,69200,23100,23400,23800,25000,27100,28000,29300,34300,37500,73200,79100,87800,92600,98300,104200,116000,160600,169200,190200,194200]
[null,null,null,50800,null,50800,50800,59500,45300,71300,23800,24100,24500,25800,27900,28800,30200,35300,38600,75400,81500,90400,95400,101200,107300,119500,165400,174300,195900,200000]
[null,null,null,52300,null,52300,52300,61300,46700,73400,24500,24800,25200,26600,28700,29700,31100,36400,39800,77700,83900,93100,98300,104200,110500,123100,170400,179500,201800,206000]
[null,null,null,53900,null,53900,53900,63100,48100,75600,25200,25500,26000,27400,29600,30600,32000,37500,41000,80000,86400,95900,101200,107300,113800,126800,175500,184900,207900,212200]
[null,null,null,55500,null,55500,55500,65000,49500,77900,26000,26300,26800,28200,30500,31500,33000,38600,42200,82400,89000,98800,104200,110500,117200,130600,180800,190400,214100,218600]
[null,null,null,57200,null,57200,57200,67000,51000,80200,26800,27100,27600,29000,31400,32400,34000,39800,43500,84900,91700,101800,107300,113800,120700,134500,186200,196100]
[null,null,null,58900,null,58900,58900,69000,52500,82600,27600,27900,28400,29900,32300,33400,35000,41000,44800,87400,94500,104900,110500,117200,124300,138500,191800,202000]
[null,null,null,60700,null,60700,60700,71100,54100,85100,28400,28700,29300,30800,33300,34400,36100,42200,46100,90000,97300,108000,113800,120700,128000,142700,197600,208100]
[null,null,null,62500,null,62500,62500,73200,55700,87700,29300,29600,30200,31700,34300,35400,37200,43500,47500,92700,100200,111200,117200,124300,131800,147000,203500]
[null,null,null,64400,null,64400,64400,75400,57400,90300,30200,30500,31100,32700,35300,36500,38300,44800,48900,95500,103200,114500,120700,128000,135800,151400]
[null,null,null,66300,null,66300,66300,77700,59100,93000,31100,31400,32000,33700,36400,37600,39400,46100,50400,98400,106300,117900,124300,131800,139900,155900]
[null,null,null,68300,null,68300,68300,80000,60900,95800,32000,32300,33000,34700,37500,38700,40600,47500,51900,101400,109500,121400,128000,135800,144100,160600]
[null,null,null,70300,null,70300,70300,82400,62700,98700,33000,33300,34000,35700,38600,39900,41800,48900,53500,104400,112800,125000,131800,139900,148400,165400]
[null,null,null,72400,null,72400,72400,84900,64600,101700,34000,34300,35000,36800,39800,41100,43300,50400,55100,107500,116200,128800,135800,144100,152900,170400]
[null,null,null,74600,null,74600,74600,87400,66500,104800,35000,35300,36100,37900,41000,42300,44400,51900,56800,110700,119700,132700,139900,148400,157500,175500]
[null,null,null,76800,null,76800,76800,90000,68500,107900,36100,36400,37200,39000,42200,43600,45700,53500,58500,114000,123300,136700,144100,152900,162200,180800]
[null,null,null,79100,null,79100,79100,92700,70600,111100,37200,37500,38300,40200,43500,44900,47100,55100,60300,117400,127000,140800,148400,157500,167100,186200]
[null,null,null,81500,null,81500,81500,95500,72700,114400,38300,38600,39400,41400,44800,46200,48500,56800,62100,120900,130800,145000,152900,162200,172100,191800]
[null,null,null,83900,null,83900,83900,98400,74900,117800,39400,39800,40600,42600,46100,47600,50000,58500,64000,124500,134700,149400,157500,167100,177300,197600]
[null,null,null,86400,null,86400,86400,101400,77100,121300,40600,41000,41800,43900,47500,49000,51500,60300,65900,128200,138700,153900,162200,172100,182600,203500]
[null,null,null,89000,null,89000,89000,104400,79400,124900,41800,42200,43100,45200,48900,50500,53000,62100,67900,132000,142900,158500,167100,177300,188100]
[null,null,null,91700,null,91700,91700,107500,81800,128600,43100,43500,44400,46600,50400,52000,54600,64000,69900,136000,147200,163300,172100,182600,193700]
[null,null,null,94500,null,94500,94500,110700,84300,132500,44400,44800,45700,48000,51900,53600,56200,65900,72000,140100,151600,168200,177300,188100,199500]
[null,null,null,97300,null,97300,97300,114000,86800,136500,45700,46100,47100,49400,53500,55200,57900,67900,74200,144300,156100,173200,182600,193700]
[null,null,null,100200,null,100200,100200,117400,89400,140600,47100,47500,48500,50900,55100,56900,59600,69900,76400,148600,160800,178400,188100,199500]
[null,null,null,103200,null,103200,103200,120900,92100,144800,48500,48900,50000,52400,56800,58600,61400,72000,78700,153100,165600,183800,193700]
[null,null,null,106300,null,106300,106300,124500,94900,149100,50000,50400,51500,54000,58500,60400,63200,74200,81100,157700,170600,189300,199500]
[null,null,null,109500,null,109500,109500,128200,97700,153600,51500,51900,53000,55600,60300,62200,65100,76400,83500,162400,175700,195000]
[null,null,null,112800,null,{"$f":"IF($F$42=4200,G82,IF($F$42=4800,H82,IF($F$42=\"5400A\",J82,IF($F$42=3600,I82,IF($F$42=1700,K82,IF($F$42=1750,L82,IF($F$42=1900,M82,IF($F$42=2000,N82,IF($F$42=\"2400A\",O82,IF($F$42=\"2400B\",P82,IF($F$42=\"2400C\",Q82,IF($F$42=\"2800A\",R82,IF($F$42=\"2800B\",S82,IF($F$42=\"5400B\",T82,IF($F$42=6000,U82,IF($F$42=6600,V82,IF($F$42=6800,W82,IF($F$42=7200,X82,IF($F$42=7600,Y82,IF($F$42=8200,Z82,IF($F$42=8700,AA82,IF($F$42=8900,IF($F$42=9500,AC82,IF($F$42=10000,AD82,\"\"))))))))))))))))))))))))","v":112800},112800,132000,100600,158200,53000,53500,54600,57300,62100,64100,67100,78700,86000,167300,181000]
[null,null,null,116200,null,116200,116200,136000,103600,162900,54600,55100,56200,59000,64000,66000,69100,81100,88600,172300,186400]
[]
[null,null,null,null,null,null,null,2,3,4,5,9,"9A","9B",10,"10A",11,12,14,15,15,16,17,18,19,20,21,22,23,"23A",24]
[null,null,null,null,null,null,null,"L-1","L-2","L-3","L-4","L-5","L-6","L-7","L-8","L-9","L-10","L-11","L-12","L-13","L-14","L-15","L-16","L-17","L-18","L-19","L-20","L-21","L-22","L-23","L-24"]

{"sheet":"Developer's desk","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,7,19,8],[19,2,19,5],[19,0,19,1],[19,9,19,12],[18,0,18,12],[0,0,0,12],[2,0,2,12],[3,0,3,12],[4,1,4,12],[5,1,5,12],[17,0,17,12],[1,0,1,12],[15,1,15,12],[10,1,10,12],[11,1,11,12],[13,1,13,12],[14,1,14,12],[16,1,16,12],[6,1,6,12],[7,1,7,12],[8,0,8,12],[9,0,9,12],[12,1,12,12]]}
["FROM THE DEVELOPER'S DESK"]
["If you have Hindi font problem, then first you should install Hindi font KRUTI DEV 010  in your computer."]
["vk;dj x.kuk ds fy, ;g odZcqd dsoy jktLFkku jkT; ds deZpkfj;ksa ds fy, rS;kj dh x;h gSA"]
["bl odZcqd esa fuEu lqfo/kk,a miYkC/k gSa&"]
[null,"¼v½ th,&55 ,oa vk;dj x.kuk 'khV dk vkWVkstusjs'ku"]
[null,"¼c½ QkWeZ 16 dk vkWVkstusjs'ku"]
[null,"¼l½ /kkjk 89(1) ds vUrxZr iwoZ o\"kksZa ds ,fj;j ij iznÙk NwV dh x.kuk ,oa QkWeZ 10E dk vkWVkstusjs'ku"]
[null,"¼n½ edku fdjk;k NwV dh x.kuk ,oa edku fdjk;k jlhn dk vkWVkstujs'ku"]
["xr o\"kZ dbZ USERS }kjk eglwl dh x;h dfe;ksa ,oa fn, x, lq>koksa dk vf/kdre lekos'k djds iqu% vki yksxksa dh lqfo/kk ds fy, bls izLrqr fd;k tk jgk gSA "]
["How to use this Software"]
[null,"loZizFke www.vijayranwa.jimdo.com  ls u;k ,oa viMsVsM 'khV MkmuyksM djsasaA mlds ckn vkidks ftrusa dkfeZdksa dh vk;dj x.kuk djuh gS] Save As ds }kjk mruh gh ,Dly izksxzke 'khV dks muds uke ls vyx vyx Qkby esa  Save  dj ysosaA"]
["Entry","vki bl ,Dly izksxzke esa Entry 'khV esa lko/kkuhiwoZd vuykWd lsy tks lQsn dyj esa gSa] dsoy mUgha dks Hkjuk gSaA vkxs dh 'khVs vkWVksa tujsV gSaA os lHkh ykWd gSaA ogk ij vkidks dqN ugh djuk gSaA flQZ A4 lkbZt esa fizUV fudkyuk gSaA"]
["HRA","10% HRA ds fy, Metro ,oa 20% HRA ds fy, Non-metro dks Entry Sheet ij C12 esa lysDV djsaA ;fn vki edku fdjk, HkÙks ij VSDl dh NwV pkgrs gSa rks ENTRY SHEET esa lsy C21 esa ekfld Hkqxrku fd, x;s fdjk, dh jkf'k fy[ksaA lsy D21 vf/kdre NwV ds fy, ftruk ekfld fdjk;k Hkjuk gS oks jkf'k fn[kkrk gSA"]
["GA 55","blds vykok vxj vki GA-55 esa dksbZ cnyko djuk pkgrs gks rks GA-55 'khV esa dj ldrs gksaA vki eSU;qyh MkVk fQM Hkh dj ldrsa gSa vkSj gVk Hkh ldrsa gSaA"]
["7th Pay Commission",";g izksxzke NBsa vkSj lkrosa nksuksa osrueku dks /;ku esa j[k dj cuk;k x;k gSaA bl izksxzke esa vkidks lkrosa osrueku dk osru ftl ekg lss cukuk gS ml ekg dk p;u Entry 'khV ij djsaA"]
["FROM No. - 16","bl 'khV esa GA 55 rFkk Computation Sheet dk Data Lor% vk;sxkA bl 'khV esa vkidks Edit dh vuqefr ugha gSA tks Hkh ifjorZu djuk gS GA55 rFkk Entry Sheet 'khV esa gh djsA NPS Employee ds fy, ldy vk; esa Govt. Contribution Pension Fund dh jkf'k tksM+ nh x;h gSA"]
["Print","GA55A & Computation Sheet isij lkbt A4 ij Page Setup fd;k gqvk gSA lh/ks nksuksa 'khV dk vkxsa ihNs fizaV ysaA 16 ua- QkeZ dks rhu ist esa lsV fd;k gqvk gSaA vki mldk rhu ist esa fizUV ys ldrsa gSaA"]
[";g ,Dly izksaxzke lHkh dkfeZdksa ds fy, leku :i ls rS;kj fd;k x;k gSA ladyu ,oa x.kuk esa iw.kZ lko/kkuh j[kh xbZ gSA fQj Hkh =qfV ;k fdlh Hkh izdkj dh fofHkUurk dh fLFkfr esa vk;dj foHkkx ds fu;e gh ekU; gSA rS;kjdrkZ dk dksbZ mÙkjnkf;Ro ugha gksxkA"]
["dksbZ leL;k ;k lq>ko gks rks vkidk gkfnZd Lokxr gSA bl ,Dly 'khV esa tc Hkh dksbZ vko';d la'kks/ku gksrk gSa] rks bldk viMsV izksxzke ges'kk uhps fy[kh osclkbZV ls u;k MkmuyksM djds bLrseky djsaA vki eq>s uhps fy[ks bZ&esy ,oa okV~lvi ij lEidZ dj ldrs gSaA"]
["E Mail ID -",null,"vijaysalasar2011@gmail.com",null,null,null,null,9828113904,null,"www.vijayranwa.jimdo.com"]

{"sheet":"Information & Rules","index":2,"n_rows":117,"n_cols":2,"rows_kept":117,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1]]}
[null,"Auto Income Tax Calculator       By - Vijay Ranwa, Teacher"]
["                                                For the Financial year 2017- 18, ASSESSMENT YEAR 2018-19                                                       .                      "]
["                  Brief detail of Information and RULES for(Rates,Deductions,Exemption etc.)                                                                             "]
[null," Follow theTax Rules & Informations (where applicable). "]
[1,"New Tax  Rates  for Financial-Year 2017-18, Assessment Year  2018-2019"]
[2,"Some  Exempted Receipts / Special allowances &  Perquisite which are not chargable to tax"]
[3,"Some Exempted Income ( to be shown while Return filing) "]
[4,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S"]
["I","HRA exemption-u/s 10(13A)"]
["II","Transport allowance"]
["III","Reimbursement of Medical bills "]
["IV"," u/s(5) LTA  Exemption "]
["V"," u/s 24  and 80EE Exemption for interest on housing loan."]
["VI","u/s 80CCE & 80CCD Maximum Exemption "]
["VII","Rajiv Gandhi Equity Savings Scheme "]
["VIII","u/s 80D Medical Insurance"]
["IX","u/s 80DD Deduction in respect of medical treatment of handicapped dependents"]
["X","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases"]
["XI","u/s 80E Interest repayment on education loan"]
["XII","u/s 80G Donations given for certain charities "]
["XIII","u/s 80GG If Assesse is not getting  HRA,  but living in rented house,"]
["XIV","u/s 80U If assesse have a permanent physical disability "]
["XV","u/s 80TTA Deduction on interest on saving bank accounts."]
[5," KNOW MORE about DEDUCTION under Section 80-C"]
["a","Qualifying Investments u/s 80CCE"]
["b","Provident Fund (PF) & Voluntary Provident Fund (VPF) "]
["c","Life Insurance Premiums & Unit linked Insurance Plan (ULIP)"]
["d","Public Provident Fund (PPF):"]
["e","National Savings Certificate (NSC):"]
["f","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home "]
["g","Tuition  fees  for 2 children "]
["h","Equity Linked Savings Scheme (ELSS)"]
["i","5-Yr bank fixed deposits (FDs)  or 5-Yr post office time deposit (POTD)"]
["j","Pension Funds or Pension Policies "]
["k","Sukanya Samridhi Account"]
["l","Infrastructure Bonds: NABARD rural bonds:"]
["m","Senior Citizen Savings Scheme 2004 (SCSS)"]
[6,"I M P O R T A N T -  A D V I S ES"]
[null," As per finance Finance Act  2017 - TAX  RATES  For Financial Year 2017-18 & Assesment Year 2018-19 "]
[null,"                                                For MALE ASSESSE  "]
[null,"   Net Income Range                                                   Income Tax Rates"]
[null,"  Up to ₹ 2,50,000                                                                    NIL"]
[null,"  2,50,001 to ₹ 5,00,000                                       5% on Total Income (-) ₹ 2,50,000"]
[null,"  ₹ 5,00,001 to ₹ 10,00,000                                ₹12,500+20% of Total Income (-) ₹5,00,000"]
[null,"  More than ₹ 10.00,000                                   ₹1,12,500+30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 2500/-  for assessee with Income range upto ₹ 3,50,000 )"]
[null,"                                     For  FEMALE  ASSESSE ( same tax slab as Male Assesse)"]
[null,"     Net Income Range                                                 Income Tax Rates"]
[null,"   Up to ₹2,50,000                                                           NIL"]
[null,"   ₹250,001 to ₹5,00,000                                            5% of Total Income (-) ₹2,50,000"]
[null,"   ₹5,00,001 to ₹10,00,000                                   ₹12,500 + 20% of Total Income (-) ₹5,00,000"]
[null,"   More than ₹10.00,000                                     ₹1,12,500 + 30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹2500/-  for assessee with Income range upto ₹ 3,50,000)"]
[null,"     For SENIOR CITIZEN  ASSESSE (Above 60 Year ) attaining the age during the year "]
[null,"       Net Income Range                                              Income Tax Rates"]
[null,"    Up to  ₹3,00,000                                                           NIL"]
[null,"    ₹3,00,001 to 5,00,000                                           5% of Total Income(-) ₹3,00,000"]
[null,"    ₹5,00,001 to 10,00,000                                         ₹10,000 +20% of Total Income (-) ₹5,00,000"]
[null,"    More than ₹10.00,000                                         ₹1,10,000 + 30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 2500/-  for assessee with Income range upto ₹ 3,50,000)"]
[null,"    For VERY SENIOR CITIZEN  ASSESSE (Above 80 Year ) attaining the age during the year "]
[null,"      Net Income Range                                              Income Tax Rates"]
[null,"    Up to ₹5,00,000                                                           NIL"]
[null,"    ₹5,00,001 to ₹10,00,000                                         20% of Total Income (-) ₹10,00,000"]
[null,"    More than ₹10,00,000                                         ₹1,00,000 +30% of Total Income (-) ₹10,00,000"]
[null,"Note: 1. Education Cess is 2% & Secondary and Higher education Cess is 1% of income tax from all Assesse.                                                                                                                                                            .        2. Surcharge on income tax @10% for income above 50 Lakh & 15% for income above 1crore  "]
[null," Some  Exempted Receipts /Special allowances &  Perquisite which are not chargable to tax are  "]
[null," Exempted Receipts - 1.  Medical Reimbursement (Max Rs15000/- Per annum)    2.  L.T.A (as per Rule)                                                            "]
[null,"Special allowances Exempted u/s 10(14)                                                                                                                                                                                                                                                                      1. Uniform Allowance (granted to meet the expenditure incurred on purchase or maintenance of uniform to be worn during performance of Official Duty)                                                                     2. Helper Allowance ( granted to meet exependiture incurred on helper for performance of official duty)                                                                                                                                                   3. Academic Allowance (granted for encouraging academic, research & training pursuits) including Newspaper, Generals etc.)                                                                                                              4. Children Education Allowance ( ₹100 P.M. per child / (₹300 for hostel expenditure) Max of 2 children)                                                                                                                                                   5. Convayance allowance ( granted to meet the expenditure incurred on convayance, while performing official duty.                                                                                                                                 .   ( Expenditure incured for covering journey between office and residence is not treated as expenditure in performance of official duty. ) "]
[null," Deduction available u/s -16                                                                                                                                                                                                                                                                          1. Entertainment allowance (for Govt Employees) Max  ₹5000/-                                                                                                                                                                                                                           2. Professional tax - Professional tax paid by employee is deducted from Gross salary."]
[null," Perquisite not chargable to tax"]
[null," Free food and beverage 1. Food and non-alcoholic beverages provided in working hours in remote area or an offshore instalation are exempted to tax                                                                                                                                    2. Tea, coffee or non-alcoholic beverages and snaks in working hours are tax free perquisites.                                                                                                                                                                           3. Meals (Lunch and / or dinner) in office hours is not taxable. If cost to the employeris  ₹50 (or Less) per meal.  "]
[null," Some Exempted Income are ( to be shown while Return filing) "]
[null,"         1.  Withdrawal / Maturity / Interest received from PF,PPF,Sukanya Samridhi Account, Life Insurance policy, Agriculture. (Max up to ₹5000/- )"]
[null,"         2    Long Term Capital Gain From Shares"]
[null,"         3    Dividend on shares in companies"]
[null,"         4.    Interest on Saving Bank & Post Office A/c up to  ₹ 10,000/- ( Sec-80TTE)"]
[null,"Please Note :"]
[null,"(i) Interest earned from all sources are to be included. All interest (including saving Bank A/C (above ₹10,000), FD income are fully taxable)."]
[null,"(II) As per clarification from IT department, all perquisites such as rent-free accommodation, company provided car, free or concessional education facilities, employee stock option plan, free club membership, company provided credit card, gift vouchers, meal coupons, hotel stay beyond 15 days, are fully taxable. "]
[null,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S  for"]
["I"," House Rent Allowance exemption-10(13A) = Least amount of anyone (i) 40% of Salary (50%, if house situated in Mumbai, Calcutta, Delhi or Madras)                                                                                                                                                                                              or (ii) Actual HRA Recived                                                                                                                                                                                                                                                        .                          or (iii) Rent paid minus 10% of salary * Salary= Basic + DA (if part of retirement benefit) + Turnover based Commission                                       Note i. Fully Taxable, if HRA is received by an employee who is living in his own house or if he does not pay any rent                                                                                                                                                          ii. It is mandatory for employee to report PAN of the landlord to the employer if rent paid is more than ₹ 1,00,000 [Circular No. 08 /2013 dated 10th October, 2013]. (In case the landlord does not have PAN, employee should submit a declaration stating the same along with the landlord’s details.)"]
["II       ","Transport allowance is exempt up to ₹1600/- per month during the month (₹ 3,200 per month for blind and handicapped employees) .                                                                                                                                                      Transport Allowance is granted to an employee to meet expenditure on commuting between place of residence and place of duty"]
["III","Reimbursement of Medical bills(on producing of Bills) are exempt for self and dependent family, up to ₹15,000/- per annum "]
["IV"," u/s(5) LTA is exempt to the tune of economy class Train/ Air /Recognised public Transport fare for the family to any destination in India, by the shortest route.                                                                                                                   LTA can be claimed twice in a block of 4 calendar yea₹ The current block is from 01.01.2014 to 31.12.2017. For claim, it is must to provide originals tickets etc."]
["   V(a) New Change","u/s 24 and 80 EE There is an Exemption for interest on housing loan.(for Self occupied Residence). If the loan was taken before Apr 1, 1999 exemption is limited to ₹30,000/- per year. If the loan was taken after Apr 1, 1999 exemption is limited to ₹2,00,000/- per year if the house is self-occupied; There is no limit if the house is rented out\nThis exemption is available on accrual basis, which means if interest has accrued, you can claim exemption, irrespective of whether you've paid it or not..                                                                                                                               80EE In finance bill 2016 (an additional rebate of ₹.50.000/- was given to those assesse, who purchase self ocupied single house after 01/04/2016 with maximum value of ₹ 60 Lacs and sanctioned home loan up to 35 Lacs.)                         "]
["      (b)","If you have rented out your house, Whole the interest will be eligible for deduction. (after deducting property tax and standard maintenance expenses from rent recived)."]
["VI","u/s 80CCE- Maximum Exemption up to  ₹1,50,000/-  Investments up to ₹1.5 lac in PF, VPF, PPF, Employee contribution in NPS,Insurance Premium, Housing loan principal repayment, NSC, ELSS, long term bank Fixed Deposit, Post Office Term Deposit, etc. are deductible from the taxable income. There is no limit on individual items, (for example) all 1.5 lac can be invested in NSC or PPF etc.  "]
["VII    ","u/s 80CCD(1):  The Finance Act, 2015 provides that contribution made by the Central Government or any other employer to NPS shall be excluded while computing the limit of Rs1,50,000.The contribution by the employee to the NPS will be subject to the limit of ₹1,50,000.                                                                                                                                                                                                                                                                                                                                                Section 80CCD: Additional Contribution to New Pension Scheme (NPS) - It will provide an additional deduction of upto ₹ 50,000 over and above the limit of ₹ 1.50 lakh in respect of contributions made to NPS under Section 80CCD(1).                                                                                                                                                                                                                                                                                                                                                                                                                      Section 80CCD (2):  Contribution to Pension Account (by Employer) - Deduction available for the amount paid or deposited by the employer of the assessee in a pension scheme notified or as may be notified by the Central Government subject to a maximum of 10% of salary in the financial year\n\n"]
["VIII","u/s 80CCG - Rajiv Gandhi Equity Savings Scheme exemption available for investment in stock markets (direct equity). Avaialble only for those with gross income less than 12 lacs and only for first time investors in stock market. Exemption available at 50% of investment subject to maximum of ₹50,000/- invested. Investments are locked-in for three years"]
["IX     ","u/s 80D Medical Insurance Premium (such as Mediclaim & Critical illness Cover with contribution in CGHS & Preventive Health Check up Upto INR.5000/-) Premium is exempt up to INR.55,000/ per year (₹25,000/- for self,spouse and children ) (₹25,000/- or ₹30,000/- for Parents) If Parents are Senior Citizen (above 60 years of age), Exempted premium up to ₹30,000/0 oterwise upto ₹.25,000/-.                               For Very Senior Citizen (Age 80+) - (In case of no Mediclaim) Any payment made on account of Medical expenditure in respect of very senior citizens will be allowed as deduction u/s 80D of a maximum of ₹30,000/-"]
["X    ","u/s 80DD Deduction in respect of medical treatment of handicapped dependents is limited to ₹75,000/- per year if the disability is less than 80% and Rs1,25,000/- per year if the disability is more than 80%"]
["XI      ","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases for the assesse or dependent can be claimed up to ₹40,000/- per year. If the person being treated is a senior citizen (Age 60-80Yrs), the exemption can go up to ₹60,000/-. If the person is very senior citizen (Age 80+), the exemption can go up to ₹ 80,000/- but any amount received under Medical Insurance Policy will be reduced from the amount of deduction allowed. The Diseases and ailments specified under rule 11DD are.                                                                                                                                                                                                            (1) Neurological diseases being demetia, dystonia musculorum deformans, motor neuron disease, ataxia, chorea, hemiballismus, aphasia and parkisons disease, (2) cancer, (3) AIDS, (4)Chronic renal failure, (5) hemophilia, and (6) thalassaemia.                                                                                                                                                                                                             Note:The assessee will be required to obtain a prescription/Certificate from a specialist doctor whether from Govt or Pvt. for the purpose of availing this deduction. "]
["XII","u/s 80E Interest repayment on education loan (taken for higher education from a university of self & dependents) is completely tax exempt"]
["XIII","u/s 80G Donations given for certain charities are tax exempt.NGO,Trust etc. are exempt to the tune of 50%, whereas Govt funds are 100%. "]
["XIV         New","u/s 80GG If you are not getting  HRA, but living in rented house, an exemption is available. This will be calculated as minimum of (25% of total income or rent paid - 10% of total income or ₹ 60,000/- per year)"]
["XV","u/s 80U who suffers from not less than 40 per cent of any disability is eligible for deduction to the extent of ₹ 75,000/- and in case of severe disability to the extent of ₹ 1,25,000/-"]
["XVI","u/s 80TTA introduced through Finance Act, 2012. Section 80TTA provides a deduction of up to ₹10,000 on your income from interest on saving bank accounts."]
[null,"                                       KNOW MORE about DEDUCTION under Section 80-C and chapter VIA "]
[null,"Section 80C of the Income Tax Act allows certain investments and expenditure to be deduct from total income - One must plan investments well and spread it out across the various instruments specified under this section to avail maximum tax benefit. There are no sub-limits and is irrespective of how much you earn and under which tax bracket you fall. Most of the Income Tax payee try to save tax by saving under Section 80C of the Income Tax Act.  However, it is important to know the Section in total. so that one can make best use of the options available for deduction under income tax Act. One important point to note that one can not only save tax by undertaking the specified investments, but some expenditure which you normally incur can also give you the tax exemptions."]
[null,"                                         Qualifying Investments u/s 80CCE are"]
["a","Provident Fund (PF) & Voluntary Provident Fund (VPF) PF is automatically deducted from your salary. your contribution [12% of Basic] (i.e., employee’s contribution) is counted towards section 80C investments. You also have the option to contribute additional amounts through voluntary contributions (VPF). Current rate of interest is 8.5% per annum (p.a.) and is tax-free.\n\n\n\n\n"]
["b","Life Insurance Premiums: Any amount that you pay towards life insurance premium in Life Insurance Corporation (LIC) or any other Insurance CO.for yourself, your spouse or your children can also be included in Section 80C deduction. If you are paying premium for more than one insurance policy, all the premiums will be included. also premium paid for ULIP will also be treated as Premium paid for Life Insurance Policies.                                                                                                                                                                                                                                                                                                                                                                                          Unit linked Insurance Plan : ULIP stands for Unit linked Saving Schemes. ULIPs cover Life insurance with benefits of equity investments.They have attracted the attention of investors and tax-savers not only because they help us save tax but they also perform well to give decent returns in the long-term.\nIMP : Total Amount Received at Maturity, Survival Benefits, , Withdrawl in Insurance Policies is Tax Free and fully exempteed u/s 10(10D)."]
["c","Public Provident Fund (PPF): Among all the assured returns small saving schemes, Public Provident Fund (PPF) is one of the best. Current rate of interest is 8% tax-free and the normal maturity period is 15 years Minimum amount of contribution is ₹500 and maximum is ₹1,50,000.(New Change) from Finance Act  2014\n\n"]
["d","National Savings Certificate (NSC): National Savings Certificate (NSC) is a 5-Yr small savings instrument eligible for section 80C tax benefit. Rate of interest is  8.58% compounded half-yearly, i.e. If you invest ₹100, it becomes ₹150.90 after five years. The interest accrued every year is liable to tax (i.e. to be included in your taxable income) but the interest is also deemed to be reinvested and thus eligible for section 80C deduction."]
["e","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home Loan The Equated Monthly Installment (EMI) that you pay every month to repay your home loan consists of two components – Principal and Interest.The principal component of the EMI qualifies for deduction under Sec 80C. Even the interest component can save you significant income tax – but that would be under Section 24 of the Income Tax Act. The amount you pay as stamp duty when you buy a house, and the amount you pay for the registration of the documents of the house can be claimed as deduction under section 80C in the year of purchase of the house.\n\n"]
["f","Tuition  fees  for 2 children  Apart form the above major investments expenses for children’s education (Only Tution Fee (for which you need receipts)), can be claimed as deductions under Sec 80C."]
["g","Equity Linked Savings Scheme (ELSS): There are some mutual fund (MF) schemes specially created for offering you tax savings, and these are called Equity Linked Savings Scheme, or ELSS. The investments that you make in ELSS are eligible for deduction under Sec 80C.\n\n"]
["h","5-Yr bank fixed deposits (FDs): Tax-saving fixed deposits (FDs) of scheduled banks with tenure of 5 years are also entitled for section 80C deduction.                                                                                                                    5-Yr post office time deposit (POTD) scheme: POTDs are similar to bank fixed deposits. Although available for varying time duration like one year, two year, three year and five year, only 5-Yr post-office time deposit (POTD) – which currently offers 7.5 per cent rate of interest –qualifies for tax saving under section 80C. Effective rate works out to be 7.71% per annum (p.a.) as the rate of interest is compounded quarterly but paid annually. The Interest is entirely taxable.\n\n\n\n"]
["i","Pension Funds or Pension Policies – Section 80CCC: This section – Sec 80CCC – stipulates that an investment in pension funds is eligible for deduction from your income. Section 80CCC investment limit is clubbed with the limit of Section 80C – it means that the total deduction available for 80CCC and 80C is ₹1.5 Lakh.This also means that your investment in pension funds upto ₹1.5 Lakh can be claimed as deduction u/s 80CCC. However, as mentioned earlier, the total deduction u/s 80C and 80CCC can not exceed  ₹1.5 Lakh.\n\n\n"]
["j","Infrastructure Bonds: These are also popularly called Infra Bonds. These are issued by infrastructure companies, and not the government. The amount that you invest in these bonds can also be included in Sec 80C deductions.                                                                                                                                                                \nNABARD rural bonds: There are two types of Bonds issued by NABARD (National Bank for Agriculture and Rural Development): NABARD Rural Bonds and Bhavishya Nirman Bonds (BNB). Out of these two, only NABARD Rural Bonds qualify under section 80C.\n\n"]
["k","Senior Citizen Savings Scheme 2004 (SCSS): A recent addition to section 80C list, Senior Citizen Savings Scheme (SCSS) is the most lucrative scheme among all the small savings schemes but is meant only for senior citizens. Current rate of interest is 9% per annum payable quarterly. Please note that the interest is payable quarterly instead of compounded quarterly. Thus, unclaimed interest on these deposits won’t earn any further interest. Interest income is chargeable to tax.\n\n\n\n"]
["l","Sukanya Samridhi Account : Contribution made in a financial year in Sukanya Samriddhi Account will also be eligible for income tax exemption under Section 80C up to a maximum of ₹ 1,50,000/-  "]
[null,"I M P O R T A N T -  A D V I S ES"]
[null," Mostly people gives estimated declaration at year starting to minimise their Tax Liabilities but could not save up to last and face heavy burden in last months. Many of us start looking for investment avenues only in February or March, just before the Financial Year is getting over. This is a big mistake! One, you would end up investing your money without putting proper thought to it. And secondly, you would end up losing the interest / appreciation for the whole year. Instead, decide where you want to make the investments, and start investing right from the beginning of the financial year – from April. so it is advisable to save from start on monthly basis through Bank ECS as a SIP . This way, you would not only make informed decisions, but would also earn the interest for the full year from April to March. \n\n\n"]
[null," C A L L      :  VIJAY  RANWA         P h :  98 28 11 39 04 ,  9024228324 or M a i l -----  vranwa81@gmail.com"]
[null,"                                                                                                                                                                                                                                  TOP"]

{"sheet":"ENTRY","index":3,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,5,66,11],[22,5,23,11],[24,5,25,11],[43,5,43,11],[27,5,29,11],[31,5,32,11],[1,10,1,11],[3,5,3,6],[3,7,3,8],[4,5,4,8],[1,5,1,8],[64,1,64,3],[33,1,33,2],[63,2,63,3],[38,5,41,11],[54,5,55,11],[57,5,58,11],[44,5,45,11],[34,5,36,11],[47,5,52,11],[60,5,62,11],[64,5,64,11],[11,3,12,3],[25,1,25,2],[13,3,17,3],[9,5,9,8],[11,5,11,8],[18,5,20,11],[11,9,11,11],[12,9,12,11],[13,9,13,11],[21,5,21,8],[21,9,21,11],[17,9,17,11],[14,5,14,8],[16,5,16,8],[17,5,17,8],[12,5,12,8],[5,10,5,11],[5,5,5,7],[2,10,2,11],[2,5,2,8],[3,9,3,11],[13,5,13,8],[1,1,1,3],[3,1,3,3],[10,2,10,3],[7,5,7,11],[10,5,10,8],[6,1,6,3],[6,5,6,11],[8,5,8,8],[8,9,8,11],[9,9,9,11],[10,9,10,11],[2,1,2,3],[5,1,5,3],[4,9,4,10],[4,2,4,3]]}
[]
[null,"INCOME TAX CALCULATION FOR FINANCIAL YEAR 2017-2018 & Assessment year 2018-19",null,null,null,{"$f":"TODAY()","v":"2017-12-28"},null,null,null,null,"WHATSAPP NO. - 9828113904"]
[null,"DEVELOPED BY VIJAY RANWA - TEACHER, GOVT. SECONDARY SCHOOL",null,null,null,"WWW.GSSAMARPURA.JIMDO.COM",null,null,null,null,"www.vijayranwa.jimdo.com"]
[null,"   DHANERU, SRIDUNGARGARH (BIKANER) Mo.- 9828113904",null,null,null,null,null,null,null,"leL;k vkus ij व्हाट्सएप्प ij lEidZ djsaA"]
[null,"As per the Finance Bill, 2017","Mail ID :- vijaysalasar2011@gmail.com"]
[null,"Enter the Data in                      Other cells will calculate data & Tax automatically.       ",null,null,null,"LAST UPDATED",null,null,"2017-12-25"]
[null,"Employee's Details",null,null,null,"Employer / DDO Details"]
[null,"Name Of Employee","VIJAY",null,null,"16 No. Form  rS;kj djus ds fy, fuEu dkWyeks dh iwfrZ djsaA"]
[null,"Designation"," TEACHER",null,null,"DDO Code",null,null,null,26339]
[null,"PAN No. -","efnps7790b",null,null,"Designation",null,null,null,"HEADMASTER"]
[null,"Name of the Office"," GOVT SECONDARY SCHOOLDHANERU (BIKANER)",null,null,"Office Name",null,null,null,"GOVT HIGHER SECONDARY SCHOOL AMARPURA"]
[null,"Location of Residence","Non-Metro",null,null,"Office Place",null,null,null,"AMARPURA"]
[null,"If you live Metro select this list city","Bikaner",null,null,"TAN No.",null,null,null,"2015V"]
[null,{"$f":"\"Mr.\"&'G.A. 55'!D4&\" Your Basic Pay in March 2017\"","v":"Mr.VIJAY Your Basic Pay in March 2017"},21290,"edku fdjk;k NwV ds fy, jlhn dh vko';drk",null,"Name",null,null,null,"ALTAF AHAMAD KHAN"]
[null,"INPUT GRADE  PAY",4200,null,null,"Father's Name"]
[null,"जिस माह मे सातवें वेतन आयोग का फिटमेंट हुआ उसका चयन करे l ",11]
[null,"जीपीएफ़ (GPF), एनपीएस (NPS) मे से कार्मिक अपना वर्ग चुनें l ","NPS",null,null,"PAN No.",null,null,null,"BPGLP1184D"]
[null,"राज्य बीमा की कटौती स्लेब से अलग है तो लिखे अन्यथा खाली छोड़ दें (SI) ",2650,null,null,"Place",null,null,null,"BIKANER"]
[null,"bUkde VSDl dh ekfld dVkSrh ¼tks osru ls gks jgh gS½",1000,{"$f":"IF('G.A. 55'!E26=0,0,HRA!J14)","v":103827},null," ;fn bl वित्तीय o\"kZ esa vkidks ,sfj;j feyk gS rks /kkjk 89 ds rgr vki ml jkf'k ij NwV ds gdnkj gks mlds fy, vki US89 'khV ij tkdj form 10E dks Hkjus ds fy, ,fj;j dh jkf'k dks fiNys fofr; o\"kksZa esa lek;kstu djus ds fy, vko';d dkWyeksa dh iwfrZ djsaA"]
[null,"lefiZr vodk'k dk osru fy;k gS rks vkgj.k fd;s x;s ekg dk p;u djsa",0,{"$f":"HRA!J10","v":0}]
[null,"HRA NwV ds fy, ekfld fdjk;k Hkqxrku dh jkf'k",null,{"$f":"CONCATENATE(ROUND(D19/12, 0),\"/-  Monthly\")","v":"8652/-  Monthly"}]
[null,"edku ekfyd dk uke"]
[null,"euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxZr ¼ vf/kdre lhek : 5000 ½",null,null,null,"vkidks ftrus dkfeZdksa dh vk;dj x.kuk djuh gS] loZizFke mruh ckj odZcqd dks muds uke ls Save As dj ysosaA"]
[null,"vU; HkŸksa tks /kkjk 10(14) ds vUrxZr dj eqDr gSA"]
[null,"O;o;k; dj /kkjk 16 ¼iii½ ds vUrxZr ",null,"HRA",null,"is eSustj ls th-,- 55 fudkydj vFkok is iksfLVax ls Gross Salary, Total Deduction, Net Payment dk feyku dj ysosaA"]
[null,"OTHER INCOME",null,{"$f":"'G.A. 55'!E26","v":37975}]
[null,"x`g lEifr ls izkIr fdjk;k & vk;",null,{"$f":"C21*12","v":0}]
[null,"x`gdj ",null,"CPF",null,"vkidks dsoy ENTRY  Sheet esa MkVk Hkjuk gSA vU; SHEET Automatic complete gks tk;sxh vr% ogka fdlh çdkj dk ifjorZu ugha gksxkA vki G.A.55 'khV esa bPNkuqlkj ifjorZu dj ldrs gksA"]
[null,"jk\"Vªh; cpr i= ij vnr C;kt",null,{"$f":"'G.A. 55'!I26","v":66022}]
[null,"cSad o iksLV vkWfQl esa cpr [kkrs ij izkIr C;kt",null,{"$f":"IF(C30<10001, C30, 10000)","v":0}]
[null,"FDR ,oa RD ls izkIr C;kt"]
[null,"Bonds ls C;kt",null,"Tax Deposited",null,"HRA o vU; vk;dj lEcfU/kr fu;eksa ds fy, vki Website ls Income Tax Software ds lkFk Rule File Hkh Download dj voyksdu dj ldrs gksA"]
[null,"vU; vk;",null,{"$f":"'G.A. 55'!R26","v":12000}]
[null,"INVESTMENTS"]
[null,"x`g _.k fdLr ewy",null,null,null," NPS esa Government contribution की राशि पहले आप की कुल आय में जुड़ेगी फिर यह राशि  US80CCD(2) के तहत छूट योग्य होगीA और यह छूट US 80CCE के तहत मिलने वाली 1.5 लाख की छूट के अलावा होगीA"]
[null,"x`g _.k fdLr C;kt",null,"Taxable Amt"]
[null,"US 80 EE",null,{"$f":"COMPUTATION!M40","v":606920}]
[null,"thou chek dh ekfld izhfe;e ¼tks osru ls dkVk x;k½"]
[null,"thou chek dh okf\"kZd izhfe;e ¼tks vkids }kjk tek djok;k x;k½",null,"GPF",null,";fn vki edku fdjk, HkÙks ij VSDl dh NwV pkgrs gSa rks lsy C20 esa vkidks ekfld Hkqxrku fd, x;s fdjk, dh jkf'k fy[kuh gSA lsy D20 vkidks feyus okyh vf/kdre NwV ds fy, ekfld fdjk;k Hkjus dh jkf'k crk,xhA lsy D19 vkidks ml jkf'k ij feyus okyh NwV dh jkf'k crk,xhA lsy D25 esa ml jkf'k dk izn'kZu gksrk gS ftl ij vki vf/kdre NwV ys ldrs gksA ;g vf/kdre NwV vkidks feyus okys edku fdjk, HkÙks dh okf\"kZd jkf'k ds cjkcj gksxhA"]
[null,"ih-,y-vkbZ-  (PLI)",null,{"$f":"COMPUTATION!G22","v":""}]
[null,"V~;w'ku Qhl ¼nks cPpksa ds fy,½"]
[null,"E;wpy Q.M (MUTUAL FUND)"]
[null,";w- ,y- vkbZ- ih-@okf\"kZd Iyku (ULIP)"]
[null,"jk\"Vªh; cpr i= (NSC)",null,null,null,"GA55A & Computation Sheet isij lkbt A4 ij Page Setup fd;k gqvk gSA lh/ks nksuksa 'khV dk vkxsa ihNs fizaV ysaA"]
[null,"uohu isa'ku ;kstuk esa osru ds vykok fd;k x;k va'knku ¼vf/kdre 50000)",null,null,null,"uohu isa'ku ;kstuk esa osru ls 10% vfuok;Z  va'knku ij /kkjk 80CCD(1B) ds rgr NwV feyrh gSA ¼vf/kdre 50000½ ;fn avkius blds vykok 150000 dh cpr iwjh dj yh gSA"]
[null,"yksd Hkfo\"; fuf/k (PPF)"]
[null,"isa'ku Iyku gsrq va'knku ¼/kkjk 80CCC½",null,"Gross Pay"]
[null,"ukckMZ }kjk vf/klwfpr ckW.M~l",null,{"$f":"COMPUTATION!M4","v":770988},null,"Hello-Friends\nI prepared a Calculator on  Excel Sheet as an Auto Tax Calculator to Calculate the tax, G.A.- 55, Assessment, form 10E  & 16 No. forms automatically in minutes for filling the ITR.\nI distributed this Calculator to all the staff to understand the Tax Calculation & other aspects.\nI tried to make this simple excel calculator as a Software.                 "]
[null,"LFkfxr okf\"kZdh"]
[null,"lqdU;k lef) ;kstuk esa fuos'k"]
[null,"fe;knh tek cSad o iksLV vkWfQl esa 5 o\"kZ ;k vf/kd"]
[]
[null,"US 80GG ¼Hkqxrku fd, x, Hkou fdjk;s ds ckjs es dVkSrh] vf/kdre 24000½",null,{"$f":"IF('G.A. 55'!E26>0, 0,C53)","v":0}]
[null,"US 80GGA ¼vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl gsrq fn;k x;k nku½"]
[null,"fpfdRlk chek izhfe;e ¼/kkjk 80D½",null,null,null,"This tax calculator will help you to calculate the Income Tax and clear any related rule in very less time & less efforts."]
[null,"fodykax vkfJrksa ds fpfdRlk mipkj  ¼/kkjk 80DD½"]
[null,"fof'k\"V jksxksa ds mipkj gsrq dVkSrh 80DDB ¼vf/kdre 40000 :½"]
[null,"mPp f'k{kk gsrq fy, _.k dk C;kt ¼/kkjk 80E½",null,null,null,"If satisfied you this software share your friends.\n"]
[null,"dsUnz o jkT; ljdkj dks fn;k x;k nku ¼d Js.kh esa 100% US 80G½",null,{"$f":"C59+C60/2","v":0}]
[null,"eafnj] efLtn vkSj xkS'kkyk esa fn;k x;k nku ¼[k Js.kh esa 50% US 80G½"]
[null,"LFkkbZ :i ls 'kkjhfjd vleFkZrrk ¼/kkjk 80U½",null,null,null,";g odZcqd f'k{kdksa dh mi;ksfxrk ds fy, rS;kj dh xbZ gSA ladyu ,oa x.kuk esa iw.kZ lko/kkuh j[khs xbZ gSA fQj Hkh =qfV ;k fdlh Hkh izdkj dh fofHkUurk dh fLFkfr esa vk;dj foHkkx ds fu;e gh ekU; gSA rS;kjdrkZ dk dksbZ mRrjnkf;Ro ugha gksxkA"]
[null,"/kkjk 89 ds rgr jkgr",{"$f":"Form10E!L27","v":0}]
[null,{"$f":"COMPUTATION!A50","v":"Income Tax Payable"},{"$f":"COMPUTATION!M50","v":22901}]
[null,{"$f":"\"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  \"&COMPUTATION!L25","v":"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  98042"},{"$f":"\"Investable Amount = \"&(150000-COMPUTATION!M25)","v":"Investable Amount = 51958"}]
[null,"fot; j.koka] v/;kid jktdh; ek/;fed fo|ky;] /kus: chdkusj jkt0\neks0&9828113904,   email- vijaysalasar2011@gmail.com",null,null,null,"fdlh Hkh izdkj dh rduhdh leL;k@lq>ko ds fy, bZesy djsa& vijaysalasar2011@gmail.com  "]
[]
[null,"THIS SHEET IS COMPLETE","GO To G.A. 55",null,null,";g odZcqd gssamarpura.jimdo.com and vijayranwa.jimdo.com ij miyC/k gSA"]

{"sheet":"G.A. 55","index":4,"n_rows":32,"n_cols":34,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,20],[3,1,3,2],[3,19,3,20],[3,3,3,7],[3,11,3,15],[3,8,3,10],[3,16,3,18],[1,1,1,20],[5,0,6,0],[5,1,6,1],[4,1,4,20],[26,21,31,23],[19,21,25,23],[28,13,28,18],[28,7,28,10],[5,8,5,18],[27,13,27,16],[5,20,6,20],[0,21,5,23],[5,19,6,19],[27,1,27,2],[5,2,5,6],[5,7,6,7],[26,1,26,2]]}
[null,{"$f":"\" Office of the  \"&ENTRY!C11","v":" Office of the   GOVT SECONDARY SCHOOLDHANERU (BIKANER)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"आप जीपीएफ़ कटौती मे बदलाव करना चाहते हो तो इच्छित माह मे कटौती की राशि लिखे l सेवानिवृति के कारण कार्मिक की कटौती बंद करनी है तो संबंधित माह के आगे कॉलम मे लिखी राशि DELETE  करे l",null,null,null,null,null,null,null,{"$f":"ENTRY!C20","v":0},{"$f":"IF(AD1=0,0,IF(AD1<=3,3,IF(AD1<=6,1,IF(AD1<=9,2,IF(AD1<=12,3,0)))))","v":0},{"$f":"ENTRY!C16","v":11}]
[null,"Salary and Deduction Detail for FY 2017-2018 & Assessment Year 2018-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C16","v":11},{"$f":"IF(AD1=0,0,IF(AD1<4,1,IF(AD1>9,1,0)))","v":0}]
[]
[null,"Name",null,{"$f":"UPPER(ENTRY!C8)","v":"VIJAY"},null,null,null,null,"Designation",null,null,{"$f":"UPPER(ENTRY!C9)","v":" TEACHER"},null,null,null,null,"PAN NO.",null,null,{"$f":"UPPER(ENTRY!C10)","v":"EFNPS7790B"},null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC2>10,AD4>9),C17/2-C15/2,0)","v":0},{"$f":"IF(OR(AD1=10,AD1=11,AD1=12,AD1=1,AD1=2),(C19/2-C20),0)","v":0},{"$f":"IF(OR(AD1=10,AD1=11,AD1=12,AD1=1,AD1=2),ROUND(D19/2,0)-ROUND(D20,0))","v":false},{"$f":"AD4+AE4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ENTRY!C12=\"METRO\", 20,10)","v":10},null,null,{"$f":"IF(AD1=0,0,IF(AD1=3,D19,VLOOKUP(AD1,A9:D19,4,FALSE)))/2","v":0}]
["S. No.","MONTH","Allowance",null,null,null,null,"Gross Amount","Deductions",null,null,null,null,null,null,null,null,null,null,"Net Payment","Bill/TV No. & Date",null,null,null,null,null,null,null,null,{"$f":"IF(AD1=0,0,VLOOKUP(AD1,AG8:AH20,2,FALSE))","v":0}]
[null,null,"BASIC","DA","HRA ","CCA","Other",null,"NPS","GPF","GPF LOAN","RPMF","SI","SI Loan","HFRH","LIC","GI Pre.","INCOME TAX","TOTAL",null,null,"MONTH",null,"GPF DEDU."]
[3,"2017-03-01",{"$f":"ENTRY!C14","v":21290},{"$f":"ROUND(C8*132%, 0)","v":28103},{"$f":"IF(ENTRY!C$12=\"metro\",C8*20%,IF(ENTRY!C$12=\"Non-Metro\",C8*10%, \"\"))","v":2129},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C8<=7000,190,IF(C8<=9000,300,480)),IF(C8<=7000,70,IF(C8<=9000,130,240))),\"\")","v":""},null,{"$f":"SUM(C8:G8)","v":51522},{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C8+D8)*10%,0),\"\")","v":4939},{"$f":"IF(ENTRY!C17=\"GPF\",W8,\"\")","v":""},null,{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C8<=7000,199,IF(C8<=13000,331,IF(C8<=21000,496,660))), \"\")","v":""},{"$f":"AB8","v":2650},null,{"$f":"IF(E8=\"\",IF(C8<13000,ROUND(C8*0.75%,0),IF(C8<19000,ROUND(C8*1.5%,0),ROUND(C8*2%,0))),\"\")","v":""},{"$f":"ENTRY!C38","v":0},null,{"$f":"ENTRY!C19","v":1000},{"$f":"SUM(I8:R8)","v":8589},{"$f":"H8-S8","v":42933},null,{"$f":"B8","v":"2017-03-01"},{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C8<=9000,500,IF(C8<=11000,650,IF(C8<=15000,1100,IF(C8<=20000,1450,IF(C8<=24000,2100, IF(C8<=28000,3300,IF(C8<=31000,4100,IF(C8<=45000,5200,IF(C8<=65000,5700,6200))))))))),\"\")","v":""},0,{"$f":"IF(X8=\"\",\"\",IF(X8=0,W8,X8))","v":""},{"$f":"IF(ENTRY!C18=\"\",\"\",ENTRY!C18)","v":2650},{"$f":"IF(C8<=8500,400,IF(C8<=11000,550,IF(C8<=18000,1100,IF(C8<=28000,1550,2650))))","v":1550},{"$f":"IF(Z8=\"\",0,IF(Z8>0,Z8,AA8))","v":2650}]
[4,"2017-04-01",{"$f":"C8","v":21290},{"$f":"ROUND(C9*136%, 0)","v":28954},{"$f":"IF(ENTRY!C$12=\"metro\",C9*20%,IF(ENTRY!C$12=\"Non-Metro\",C9*10%, \"\"))","v":2129},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C9<=7000,190,IF(C9<=9000,300,480)),IF(C9<=7000,70,IF(C9<=9000,130,240))),\"\")","v":""},{"$f":"IF(G8>0,G8,\"\")","v":""},{"$f":"SUM(C9:G9)","v":52373},{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C9+D9)*10%,0),\"\")","v":5024},{"$f":"IF(J8=\"\",\"\",IF(J8>W9,J8,W9))","v":""},{"$f":"IF(K8>0,K8,\"\")","v":""},{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C9<=7000,199,IF(C9<=13000,331,IF(C9<=21000,496,660))), \"\")","v":""},{"$f":"M8","v":2650},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"IF(E9=\"\",IF(C9<13000,ROUND(C9*0.75%,0),IF(C9<19000,ROUND(C9*1.5%,0),ROUND(C9*2%,0))),\"\")","v":""},{"$f":"IF(P8>0,P8,\"\")","v":""},253,{"$f":"R8","v":1000},{"$f":"SUM(I9:R9)","v":8927},43446,null,{"$f":"B9","v":"2017-04-01"},{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C9<=9000,500,IF(C9<=11000,650,IF(C9<=15000,1100,IF(C9<=20000,1450,IF(C9<=24000,2100, IF(C9<=28000,3300,IF(C9<=31000,4100,IF(C9<=45000,5200,IF(C9<=65000,5700,6200))))))))),\"\")","v":""},{"$f":"X8","v":0},{"$f":"IF(X9=\"\",\"\",IF(X9=0,W9,X9))","v":""},null,null,null,null,null,null,null,4,136]
[5,"2017-05-01",{"$f":"C9","v":21290},28954,{"$f":"IF(ENTRY!C$12=\"metro\",C10*20%,IF(ENTRY!C$12=\"Non-Metro\",C10*10%, \"\"))","v":2129},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C10<=7000,190,IF(C10<=9000,300,480)),IF(C10<=7000,70,IF(C10<=9000,130,240))),\"\")","v":""},{"$f":"IF(G9>0,G9,\"\")","v":""},{"$f":"SUM(C10:G10)","v":52373},{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C10+D10)*10%,0),\"\")","v":5024},{"$f":"IF(J9=\"\",\"\",IF(J9>W10,J9,W10))","v":""},{"$f":"K9","v":""},{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C10<=7000,205,IF(C10<=13000,341,IF(C10<=21000,511,680))), \"\")","v":""},{"$f":"M9","v":2650},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"IF(E10=\"\",IF(C10<13000,ROUND(C10*0.75%,0),IF(C10<19000,ROUND(C10*1.5%,0),ROUND(C10*2%,0))),\"\")","v":""},{"$f":"P9","v":""},null,{"$f":"R9","v":1000},8674,43699,null,"2017-05-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C10<=9000,500,IF(C10<=11000,650,IF(C10<=15000,1100,IF(C10<=20000,1450,IF(C10<=24000,2100, IF(C10<=28000,3300,IF(C10<=31000,4100,IF(C10<=45000,5200,IF(C10<=65000,5700,6200))))))))),\"\")","v":""},{"$f":"X9","v":0},"",null,null,null,null,null,null,null,{"$f":"AG9+1","v":5},136]
[6,"2017-06-01",{"$f":"C10","v":21290},28954,{"$f":"IF(ENTRY!C$12=\"metro\",C11*20%,IF(ENTRY!C$12=\"Non-Metro\",C11*10%, \"\"))","v":2129},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C11<=7000,190,IF(C11<=9000,300,480)),IF(C11<=7000,70,IF(C11<=9000,130,240))),\"\")","v":""},"",52373,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C11+D11)*10%,0),\"\")","v":5024},"","",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C11<=7000,205,IF(C11<=13000,341,IF(C11<=21000,511,680))), \"\")","v":""},2650,"",{"$f":"IF(E11=\"\",IF(C11<13000,ROUND(C11*0.75%,0),IF(C11<19000,ROUND(C11*1.5%,0),ROUND(C11*2%,0))),\"\")","v":""},"",null,1000,8674,43699,null,"2017-06-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C11<=9000,500,IF(C11<=11000,650,IF(C11<=15000,1100,IF(C11<=20000,1450,IF(C11<=24000,2100, IF(C11<=28000,3300,IF(C11<=31000,4100,IF(C11<=45000,5200,IF(C11<=65000,5700,6200))))))))),\"\")","v":""},0,"",null,null,null,null,null,null,null,{"$f":"AG10+1","v":6},136]
[7,"2017-07-01",{"$f":"ROUNDUP(ROUND(1.03*C11, 0),-1)","v":21930},29825,{"$f":"IF(ENTRY!C$12=\"metro\",C12*20%,IF(ENTRY!C$12=\"Non-Metro\",C12*10%, \"\"))","v":2193},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C12<=7000,190,IF(C12<=9000,300,480)),IF(C12<=7000,70,IF(C12<=9000,130,240))),\"\")","v":""},"",53948,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C12+D12)*10%,0),\"\")","v":5176},"","",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C12<=7000,205,IF(C12<=13000,341,IF(C12<=21000,511,680))), \"\")","v":""},2650,"",{"$f":"IF(E12=\"\",IF(C12<13000,ROUND(C12*0.75%,0),IF(C12<19000,ROUND(C12*1.5%,0),ROUND(C12*2%,0))),\"\")","v":""},"",null,1000,8826,45122,null,"2017-07-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C12<=9000,500,IF(C12<=11000,650,IF(C12<=15000,1100,IF(C12<=20000,1450,IF(C12<=24000,2100, IF(C12<=28000,3300,IF(C12<=31000,4100,IF(C12<=45000,5200,IF(C12<=65000,5700,6200))))))))),\"\")","v":""},0,"",null,null,null,null,null,null,null,7,136]
[8,"2017-08-01",{"$f":"C12","v":21930},29825,{"$f":"IF(ENTRY!C$12=\"metro\",C13*20%,IF(ENTRY!C$12=\"Non-Metro\",C13*10%, \"\"))","v":2193},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C13<=7000,190,IF(C13<=9000,300,480)),IF(C13<=7000,70,IF(C13<=9000,130,240))),\"\")","v":""},"",53948,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C13+D13)*10%,0),\"\")","v":5176},"","",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C13<=7000,205,IF(C13<=13000,341,IF(C13<=21000,511,680))), \"\")","v":""},2650,"",{"$f":"IF(E13=\"\",IF(C13<13000,ROUND(C13*0.75%,0),IF(C13<19000,ROUND(C13*1.5%,0),ROUND(C13*2%,0))),\"\")","v":""},"",null,1000,8826,45122,null,"2017-08-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C13<=9000,500,IF(C13<=11000,650,IF(C13<=15000,1100,IF(C13<=20000,1450,IF(C13<=24000,2100, IF(C13<=28000,3300,IF(C13<=31000,4100,IF(C13<=45000,5200,IF(C13<=65000,5700,6200))))))))),\"\")","v":""},0,"",null,null,null,null,null,null,null,8,136]
[9,"2017-09-01",{"$f":"C13","v":21930},29825,{"$f":"IF(ENTRY!C$12=\"metro\",C14*20%,IF(ENTRY!C$12=\"Non-Metro\",C14*10%, \"\"))","v":2193},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C14<=7000,190,IF(C14<=9000,300,480)),IF(C14<=7000,70,IF(C14<=9000,130,240))),\"\")","v":""},"",53948,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C14+D14)*10%,0),\"\")","v":5176},"","",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C14<=7000,205,IF(C14<=13000,341,IF(C14<=21000,511,680))), \"\")","v":""},2650,{"$f":"N13","v":""},"","",null,1000,8826,45122,null,"2017-09-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C14<=9000,500,IF(C14<=11000,650,IF(C14<=15000,1100,IF(C14<=20000,1450,IF(C14<=24000,2100, IF(C14<=28000,3300,IF(C14<=31000,4100,IF(C14<=45000,5200,IF(C14<=65000,5700,6200))))))))),\"\")","v":""},0,"",null,null,null,null,null,null,null,9,136]
[10,"2017-10-01",{"$f":"C14","v":21930},{"$f":"ROUND(C15*139%, 0)","v":30483},{"$f":"IF(ENTRY!C$12=\"metro\",C15*20%,IF(ENTRY!C$12=\"Non-Metro\",C15*10%, \"\"))","v":2193},{"$f":"IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C15<=7000,190,IF(C15<=9000,300,480)),IF(C15<=7000,70,IF(C15<=9000,130,240))),\"\")","v":""},"",54606,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C15+D15)*10%,0),\"\")","v":5241},"","",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C15<=7000,205,IF(C15<=13000,341,IF(C15<=21000,511,680))), \"\")","v":""},2650,"","","",null,1000,8891,45715,null,"2017-10-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(C15<=9000,500,IF(C15<=11000,650,IF(C15<=15000,1100,IF(C15<=20000,1450,IF(C15<=24000,2100, IF(C15<=28000,3300,IF(C15<=31000,4100,IF(C15<=45000,5200,IF(C15<=65000,5700,6200))))))))),\"\")","v":""},0,"",null,null,null,{"$f":"23950-9220","v":14730},null,null,null,10,139]
[11,"2017-11-01",{"$f":"IF(ENTRY!C$16=11,Pay!E$16,C15)","v":57200},{"$f":"IF(ENTRY!C$16=11,ROUND(C16*5%,0),ROUND(C16*139%,0))","v":2860},{"$f":"IF(ENTRY!C$16=11,IF(ENTRY!C$12=\"metro\",C16*16%,IF(ENTRY!C$12=\"Non-Metro\",C16*8%, \"\")),IF(ENTRY!C$12=\"non-eligible\",\"\",ROUND(C16*AA$5%,0)))","v":4576},{"$f":"IF(AF$1=11,IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C16<=23100,620,1000),IF(C16<=23100,320,620)),\"\"),F15)","v":""},"",64636,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C16+D16)*10%,0),\"\")","v":6006},"","",{"$f":"IF(ENTRY!C$17=\"GPF\",IF(ENTRY!C$16=11,IF(C16<=18000,205,IF(C16<=33500,341,IF(C16<=54000,511,680))),IF(C16<=7000,205,IF(C16<=13000,341,IF(C16<=21000,511,680)))),L15)","v":""},2650,"","","",null,1000,9656,54980,null,"2017-11-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(ENTRY!C$16=11,IF(C16<=23100,500,IF(C16<=28500,650,IF(C16<=38500,1100,IF(C16<=51500,1450,IF(C16<=62000,2100, IF(C16<=72000,3300,IF(C16<=80000,4100,IF(C16<=116000,5200,IF(C16<=167000,5700,6200))))))))),W15),\"\")","v":""},0,"",null,null,null,null,null,null,null,11,{"$f":"IF(AF$1=11,5,139)","v":5}]
[12,"2017-12-01",{"$f":"IF(ENTRY!C$16=12,Pay!E$16,C16)","v":57200},{"$f":"IF(OR(ENTRY!C$16=12,,ENTRY!C$16=11),ROUND(C17*5%,0),ROUND(C17*139%,0))","v":2860},{"$f":"IF(OR(ENTRY!C$16=12,ENTRY!C$16=11),IF(ENTRY!C$12=\"metro\",C17*16%,IF(ENTRY!C$12=\"Non-Metro\",C17*8%,\"\")),IF(ENTRY!C$12=\"non-eligible\",\"\",ROUND(C17*AA$5%,0)))","v":4576},{"$f":"IF(AF$1=12,IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C17<=23100,620,1000),IF(C17<=23100,320,620)),\"\"),F16)","v":""},"",64636,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C17+D17)*10%,0),\"\")","v":6006},"","",{"$f":"IF(ENTRY!C$16=12,IF(ENTRY!C$17=\"GPF\",IF(C17<=18000,205,IF(C17<=33500,341,IF(C17<=54000,511,680))),\"\"),L16)","v":""},2650,"","","",null,{"$f":"R16","v":1000},9656,54980,null,"2017-12-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(ENTRY!C$16=12,IF(C17<=23100,500,IF(C17<=28500,650,IF(C17<=38500,1100,IF(C17<=51500,1450,IF(C17<=62000,2100, IF(C17<=72000,3300,IF(C17<=80000,4100,IF(C17<=116000,5200,IF(C17<=167000,5700,6200))))))))),W16),\"\")","v":""},0,"",null,null,null,null,null,null,null,12,{"$f":"IF(OR(AF1=11,AF$1=12),5,139)","v":5}]
[1,"2018-01-01",{"$f":"IF(ENTRY!C$16=1,Pay!E$16,C17)","v":57200},{"$f":"IF(OR(ENTRY!C$16=12,ENTRY!C$16=11,ENTRY!C$16=1),ROUND(C18*5%,0),ROUND(C18*139%,0))","v":2860},{"$f":"IF(OR(ENTRY!C$16=1,ENTRY!C$16=12,ENTRY!C$16=11),IF(ENTRY!C$12=\"metro\",C18*16%,IF(ENTRY!C$12=\"Non-Metro\",C18*8%, \"\")),IF(ENTRY!C$12=\"non-eligible\",\"\",ROUND(C18*AA$5%,0)))","v":4576},{"$f":"IF(AF$1=1,IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C18<=23100,620,1000),IF(C18<=23100,320,620)),\"\"),F17)","v":""},"",64636,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C18+D18)*10%,0),\"\")","v":6006},"","",{"$f":"IF(ENTRY!C$16=1,IF(ENTRY!C$17=\"GPF\",IF(C18<=18000,205,IF(C18<=33500,341,IF(C18<=54000,511,680))),\"\"),L17)","v":""},2650,"","","",null,{"$f":"R17","v":1000},9656,54980,null,"2018-01-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(ENTRY!C$16=1,IF(C18<=23100,500,IF(C18<=28500,650,IF(C18<=38500,1100,IF(C18<=51500,1450,IF(C18<=62000,2100, IF(C18<=72000,3300,IF(C18<=80000,4100,IF(C18<=116000,5200,IF(C18<=167000,5700,6200))))))))),W17),\"\")","v":""},0,"",null,null,null,null,null,null,null,1,{"$f":"IF(OR(AF$1=1,AF1=11,AF1=12),5,139)","v":5}]
[2,"2018-02-01",{"$f":"IF(ENTRY!C$16=2,Pay!E$16,C18)","v":57200},{"$f":"IF(ENTRY!C$16<=12,ROUND(C19*5%,0),ROUND(C19*139%,0))","v":2860},{"$f":"IF(OR(ENTRY!C$16=2,ENTRY!C$16<=12),IF(ENTRY!C$12=\"metro\",C19*16%,IF(ENTRY!C$12=\"Non-Metro\",C19*8%, \"\")),IF(ENTRY!C$12=\"non-eligible\",\"\",ROUND(C19*AA$5%,0)))","v":4576},{"$f":"IF(AF$1=2,IF(ENTRY!$C$12=\"metro\",IF(ENTRY!$C$13=\"Jaipur\",IF(C19<=23100,620,1000),IF(C19<=23100,320,620)),\"\"),F18)","v":""},"",64636,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((C19+D19)*10%,0),\"\")","v":6006},"","",{"$f":"IF(ENTRY!C$16=2,IF(ENTRY!C$17=\"GPF\",IF(C19<=18000,210,IF(C19<=33500,349,IF(C19<=54000,522,695))),\"\"),L18)","v":""},2650,"","","",null,{"$f":"R18","v":1000},9656,54980,null,"2018-02-01",{"$f":"IF(ENTRY!C$17=\"GPF\", IF(ENTRY!C$16=2,IF(C19<=23100,500,IF(C19<=28500,650,IF(C19<=38500,1100,IF(C19<=51500,1450,IF(C19<=62000,2100, IF(C19<=72000,3300,IF(C19<=80000,4100,IF(C19<=116000,5200,IF(C19<=167000,5700,6200))))))))),W18),\"\")","v":""},0,"",null,null,null,null,null,null,null,2,{"$f":"IF(OR(AF$1=1,AF1=11,AF1=12,AF1=2),5,139)","v":5}]
[null,"Surrender",{"$f":"IF(AD1=0,0,IF(AD1=3,C19,VLOOKUP(AD1,A9:C19,3,FALSE)))/2","v":0},{"$f":"ROUND(C20*AD6/100,0)","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0,null,"यदि आप सेवानिवृति के कारण कार्मिक की SI कटौती बंद करना चाहते है तो ENTRY  शीट मे CELL  C18  मे लिखी राशि DELETE  करे l",null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(OR(AF$1=1,AF1=11,AF1=12,AF1=2,AF1=3),5,139)","v":5}]
[null,"DA Arrear 136%",null,{"$f":"(D9-D8)*3","v":2553},null,null,null,2553,{"$f":"IF(ENTRY!C17=\"NPS\",ROUND((ROUND(136%*C8,0)-ROUND(132%*C8,0))*10%,0)*3,0)","v":255},{"$f":"IF(ENTRY!$C$17=\"GPF\",D21,\"\")","v":""},null,null,null,null,null,null,null,null,255,2298,null,null,null,null,null,null,null,null,null,null,{"$f":"12816-1198","v":11618}]
[null,"DA Arrear 139% ",null,{"$f":"3*(D15-D14)+IF(AD1=0,0,IF(AND(AD1>6,AD1<10),ROUND(C20*0.03,0),0))","v":1974},null,null,null,1974,{"$f":"IF(ENTRY!$C$17=\"NPS\",ROUND((ROUND(139%*C12,0)-ROUND(136%*C12,0))*10%,0)*3,0)","v":198},{"$f":"IF(ENTRY!$C$17=\"GPF\",D22,\"\")","v":""},null,null,null,null,null,null,null,null,198,1776]
[null,"Bonus",null,null,null,null,{"$f":"IF(ENTRY!C15>4800, \"\", 6774)","v":6774},6774,null,null,null,null,null,null,null,null,null,null,0,6774]
[null,"Fixation Arrear",{"$f":"IF(ENTRY!C16=\"NO\",0,IF(ENTRY!C16=11,(C16-C15),IF(ENTRY!C16=12,(C17-C15)*2,IF(ENTRY!C16=1,(C18-C15)*3,IF(ENTRY!C16=2,(C19-C15)*4,\"\"))))+AD4)","v":35270},{"$f":"IF(ENTRY!C16=\"NO\",0,IF(ENTRY!C16=11,(D16-D15),IF(ENTRY!C16=12,(D17-D15)*2,IF(ENTRY!C16=1,(D18-D15)*3,IF(ENTRY!C16=2,(D19-D15)*4,\"\"))))+AE4)","v":-27623},{"$f":"IF(ENTRY!C12=\"non-eligible\",0,IF(ENTRY!$C$16=11,(E16-E15),IF(ENTRY!$C$16=12,(E17-E15)*2,IF(ENTRY!$C$16=1,(E18-E15)*3,IF(ENTRY!$C$16=2,(E19-E15)*4,0)))))","v":2383},{"$f":"IF(OR(ENTRY!C12=\"non-metro\",ENTRY!C12=\"non-eligible\"),0,IF(ENTRY!$C$16=11,(F16-F15),IF(ENTRY!$C$16=12,(F17-F15)*2,IF(ENTRY!$C$16=1,(F18-F15)*3,IF(ENTRY!$C$16=2,(F19-F15)*4,\"\")))))","v":0},null,10030,{"$f":"IF(ENTRY!$C$17=\"NPS\", IF(ENTRY!C16=11,ROUND(((C16+D16)-(C15+D15))*10%,0),IF(ENTRY!C16=12,ROUND(((C17+D17)-(C15+D15))*10%,0)*2,IF(ENTRY!C16=1,ROUND(((C18+D18)-(C15+D15))*10%,0)*3,IF(ENTRY!C16=2,ROUND(((C19+D19)-(C15+D15))*10%,0)*4,\"\")))),\"\")","v":765},{"$f":"IF(ENTRY!C17=\"GPF\",IF(ENTRY!$C$16=11,(J16-J15),IF(ENTRY!$C$16=12,(J17-J15)*2,IF(ENTRY!$C$16=1,(J18-J15)*3,IF(ENTRY!$C$16=2,(J19-J15)*4,\"\")))),\"\")","v":""},null,{"$f":"IF(ENTRY!M$17=\"GPF\", IF(ENTRY!$C$16=11,(L16-L15),IF(ENTRY!$C$16=12,(L17-L15)*2,IF(ENTRY!$C$16=1,(L18-L15)*3,IF(ENTRY!$C$16=2,(L19-L15)*4,\"\")))),\"\")","v":""},null,null,null,null,null,null,765,9265]
[null,"Other Arre.",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Total",{"$f":"SUM(C8:C25)","v":436950},{"$f":"SUM(D8:D25)","v":223267},37975,0,6774,704966,66022,0,0,0,31800,0,0,0,253,12000,110075,{"$f":"(SUM(T8:T25))","v":594891}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"आपको बोनस नहीं मिला है तो सेल G23  मे लिखी राशि डिलीट कर दें l"]
[]
[null,null,null,null,null,null,null,"gLrk{kj deZpkjh",null,null,null,null,null,"gLrk{kj vkgj.k ,oa forj.k vf/kdkjh"]
[]
[]
["VR","VR"]

{"sheet":"COMPUTATION","index":5,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[[22,18,25,22],[49,0,49,11],[51,11,51,12],[27,1,27,7],[28,0,36,0],[28,1,28,12],[29,1,29,11],[30,1,30,11],[31,1,31,11],[32,1,32,11],[33,1,33,11],[34,1,34,11],[35,1,35,11],[36,1,36,11],[39,1,39,11],[27,8,27,9],[54,1,54,12],[55,1,55,12],[40,0,44,0],[41,1,41,11],[42,1,42,11],[44,1,44,11],[43,7,43,10],[43,1,43,4],[43,5,43,6],[45,1,45,11],[46,1,46,11],[40,1,40,7],[47,0,48,0],[47,1,48,3],[47,4,47,5],[47,6,47,7],[48,6,48,7],[47,10,47,11],[48,10,48,11],[48,4,48,5],[52,11,52,12],[51,3,51,4],[50,1,50,3],[50,4,50,5],[16,2,16,5],[16,8,16,10],[17,2,17,5],[15,0,27,0],[19,2,19,5],[16,12,23,12],[25,12,26,12],[12,1,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[18,2,18,5],[18,8,18,10],[11,0,13,0],[11,1,11,11],[14,1,14,11],[15,1,15,12],[0,0,0,12],[1,0,1,12],[2,9,2,10],[9,1,10,2],[9,3,9,5],[9,8,9,9],[4,1,4,11],[5,1,5,11],[6,1,6,9],[6,10,6,11],[9,10,9,11],[10,3,10,5],[10,8,10,9],[10,10,10,11],[7,1,7,11],[8,0,10,0],[8,1,8,7],[8,8,8,9],[8,10,8,11],[2,4,2,7],[3,8,3,10],[3,1,3,5],[3,6,3,7],[3,18,6,21],[56,9,56,12],[56,1,56,7],[21,2,21,5],[27,10,27,11],[2,1,2,3],[9,6,9,7],[10,6,10,7],[21,8,21,10],[22,2,22,5],[22,8,22,10],[23,2,23,5],[23,8,23,10],[19,8,19,10],[20,2,20,5],[20,8,20,10],[25,1,25,10],[26,1,26,10],[17,8,17,10],[37,1,37,11],[24,2,24,5],[24,7,24,10],[38,1,38,11]]}
[{"$f":"'G.A. 55'!B1","v":" Office of the   GOVT SECONDARY SCHOOLDHANERU (BIKANER)"}]
["vk;dj x.kuk izi= foRrh; o\"kZ 2017&2018 ¼dj fu/kkZj.k o\"kZ 2018&2019½"]
[1,"uke deZpkjh %",null,null,{"$f":"'G.A. 55'!D4","v":"VIJAY"},null,null,null," in %",{"$f":"'G.A. 55'!L4","v":" TEACHER"},null,"PAN NO :-",{"$f":"'G.A. 55'!T4","v":"EFNPS7790B"}]
[2,"osru en esa vk; ¼HkÙkksa lfgr½",null,null,null,null,{"$f":"'G.A. 55'!H26","v":704966},null,{"$f":" IF(ENTRY!C17=\"GPF\",  \"\", \"(+ Govt. Contri. towards NPS)\")","v":"(+ Govt. Contri. towards NPS)"},null,null,{"$f":" IF(ENTRY!C17=\"NPS\", L17,\"\")","v":66022},{"$f":"G4+L17","v":770988},null,null,null,null,null,{"$f":"IF(L4=\"\",\"\",\"ljdkj }kjk ,uih,l esa tks jkf'k tek djokbZ xbZ gSa] og jkf'k ;gk¡ ldy vk; esa tksM+h xbZ gSaA\")","v":"ljdkj }kjk ,uih,l esa tks jkf'k tek djokbZ xbZ gSa] og jkf'k ;gk¡ ldy vk; esa tksM+h xbZ gSaA"}]
[3,"x`g fdjk;k] HkÙkk /kkjk 10¼13&A½ ds vUrxZr ,oa /kkjk 10¼14½ ds vUrxZr vU; HkÙks tks dj eqDÙk gSA",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!D20+ENTRY!C24","v":0}]
[4,"                                                              'ks\"k ¼2&3½",null,null,null,null,null,null,null,null,null,null,{"$f":"M4-M5","v":770988}]
[5," ¼i½euksjatu HkÙkk /kkjk 16 ¼ii½ ds vUrxZr ¼ vf/kdre lhek : 5000 ½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C23","v":0}]
[6,"                                                           'ks\"k ¼4&5½",null,null,null,null,null,null,null,null,null,null,{"$f":"M6-M7","v":770988}]
[7,"¼v½ x`g lEifÙk ls vk;% ¼1½ Lo;a ds mi;ksx esa &'kwU;",null,null,null,null,null,null,"¼2½ izkIr fdjk;k #-",null,{"$f":"ENTRY!C27","v":0},null,{"$f":"M8+K9","v":770988}]
[null,"¼c½ ?kVk;sa ",null,"ejEer fdjk;s dk 30%",null,null,"x`g _.k ij C;kt",null," x`gdj ",null,"  ;ksx 7¼c½"]
[null,null,null,{"$f":"ROUND((K9-I11)*0.3,0)","v":0},null,null,{"$f":"ENTRY!C36","v":0},null,{"$f":"ENTRY!C28","v":0},null,{"$f":"D11+G11+I11","v":0},null,{"$f":"M9-K11","v":770988}]
[8,"vU; óksrksa ls vk; %&"]
[null,"NSC ij C;kt",null,null,"FDR ls C;kt",null,"Bonds ls C;kt",null,"cpr [kkrs ij C;kt",null,"vU; vk;"]
[null,{"$f":"ENTRY!C29","v":0},null,null,{"$f":"ENTRY!C31","v":0},null,{"$f":"ENTRY!C32","v":0},null,{"$f":"ENTRY!C30","v":0},null,{"$f":"ENTRY!C33","v":0}]
[9,"ldy dqy vk;                                                            ;ksx ¼7$8½",null,null,null,null,null,null,null,null,null,null,{"$f":"M11+B14+E14+G14+I14+K14","v":770988}]
[10,"(A)?kVkbZ;s v/;k; VIA ds vUrxZr dVkSSfr;k¡ %& Section US 80C, 80CCC,80CCD (1) Maximum Limit 150000.00)"]
[null,"(i)","jkT; chek (SI)",null,null,null,{"$f":"'G.A. 55'!M26","v":31800},"(x)","uohu isa'ku ;kstuk esa va'knku CPF",null,null,{"$f":"IF(ENTRY!C17=\"GPF\",0,'G.A. 55'!I26)","v":66022}]
[null,"(ii)","thou chek izhfe;e (LIC)",null,null,null,{"$f":"ENTRY!C39+'G.A. 55'!P26","v":0},"(xi)","isa'ku Iyku gsrq va'knku ¼80ccc½",null,null,{"$f":"ENTRY!C47","v":0}]
[null,"(iii)","jk\"Vªh; cpr i= (NSC)",null,null,null,{"$f":"ENTRY!C44","v":0},"(xii)","jk\"Vªh; cpr i= ij vnÙk C;kt",null,null,{"$f":"ENTRY!C29","v":0}]
[null,"(iv)","yksd Hkfo\"; fuf/k (PPF)",null,null,null,{"$f":"ENTRY!C46","v":0},"(xiii)","V~;w'ku Qhl ¼nks cPpksa ds fy,½",null,null,{"$f":"ENTRY!C41","v":0}]
[null,"(v)","E;qpqvy QaM (MF)",null,null,null,{"$f":"ENTRY!C42","v":0},"(xiv)","ukckMZ }kjk vf/klwfpr ckW.M~l",null,null,{"$f":"ENTRY!C48","v":0}]
[null,"(vi)","lkekU; izko/kk;h fuf/k (GPF)",null,null,null,{"$f":"IF(ENTRY!C17=\"GPF\", 'G.A. 55'!J26,\"\")","v":""},"(xv)","lqdU;k le`f) [kkrs esa fuos'k",null,null,{"$f":"ENTRY!C50","v":0}]
[null,"(vii)","lkeqfgd chek izhfe;e(G.Ins.)",null,null,null,220,"(xvi)","ih-,y-vkbZ- (PLI)",null,null,{"$f":"ENTRY!C40","v":0},null,null,null,null,null,null,{"$f":"IF(L26=\"\",\"\",\"ljdkj }kjk ,uih,l esa tek djkbZ xbZ jkf'k ldy vk; esa tksM+h xbZ Fkh] vr% vc ogh jkf'k bl dkWye esa /kkjk 80lhlhMh¼2½ ds rgr i`Fkd NwV esa n'kkZ;h xbZ gSaA ;g jkf'k 80lh dh fyfeV 150000 ls vfrfjDr vk;dj NwV ds nk;jsa esa vkrh gSaA\")","v":"ljdkj }kjk ,uih,l esa tek djkbZ xbZ jkf'k ldy vk; esa tksM+h xbZ Fkh] vr% vc ogh jkf'k bl dkWye esa /kkjk 80lhlhMh¼2½ ds rgr i`Fkd NwV esa n'kkZ;h xbZ gSaA ;g jkf'k 80lh dh fyfeV 150000 ls vfrfjDr vk;dj NwV ds nk;jsa esa vkrh gSaA"}]
[null,"(viii)",";w- ,y- vkbZ- ih- (ULIP)",null,null,null,{"$f":"ENTRY!C43","v":0},"(xvii)","fe;knh tek 5 o\"kZ ;k vf/kd",null,null,{"$f":"ENTRY!C51","v":0}]
[null,"(ix)","x`g _.k fdLr (CAPITAL)",null,null,null,{"$f":"ENTRY!C35","v":0},";ksx ( i ls xvii )",null,null,null,{"$f":"SUM(G17:G25)+SUM(L17:L24)","v":98042},{"$f":"IF(L25<150001, L25, 150000)","v":98042},null,null,{"$f":"IF(L25>150000,L25-150000,0)","v":0},{"$f":"IF(L17>0,MIN(L17,P25),0)","v":0}]
[null,"(B) ?kVkbZ;s /kkjk 80CCE] 80CCD(2) ljdkj }kjk isa'ku ;kstuk esa va'knku¼osru dk 10%)",null,null,null,null,null,null,null,null,null,{"$f":"L4","v":66022},null,null,null,null,{"$f":"ENTRY!C45","v":0}]
[null,"(C) ?kVkbZ;s /kkjk 80CCD(1B) Loa }kjk uohu isa'ku ;kstuk esa va'knku ¼vf/kdre 50000)",null,null,null,null,null,null,null,null,null,{"$f":"IF(Q27>50000,50000,Q27)","v":0},null,null,null,null,{"$f":"Q25+Q26","v":0}]
[null,"Qualifying Amount US80CCE",null,null,null,null,null,null,{"$f":"IF('G.A. 55'!I7=\"CPF\", \"+US 80CCD(2)\", \"\")","v":""},null,";ksx 10(A+B+C)",null,{"$f":"SUM(M25,L26,L27)","v":164064}]
[11," vU; dVkSfr;k¡ %&"]
[null,"1- /kkjk 80D fpfdRlk chek izhfe;e ¼vf/kdre nks cPpksa ds fy, :25000]ekrk&firk ds fy, :25000 lhfu;j flVhtu :30000½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C55","v":0}]
[null,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% fodykaxrk ij 125]000½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C56","v":0}]
[null,"3- /kkjk 80DDB fof'k\"V jksxksa ds mipkj gsrq dVkSrh ¼vf/kdre :40]000] lhfu;j flVhtu gsrq : 60]000½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C57","v":0}]
[null,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C58","v":0}]
[null,"5- /kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!D59","v":0}]
[null,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrk dh n'kk esa ¼vf/kdre 75000 rFkk  80% ij 125000½",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C61","v":0}]
[null,"7- /kkjk 80 TTA cpr [kkrs ij izkIr C;kt vf/kdre :- 10,000 (194(IA))",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!D30","v":0}]
[null,"dqy ;ksx 11 ¼ 1 ls 7 rd ½",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M30:M36)","v":0}]
[12,"dqy dVkSrh ( 10 + 11)",null,null,null,null,null,null,null,null,null,null,{"$f":"M28+M37","v":164064}]
[13,"dj ;ksX; vk; ( 9 - 12 )",null,null,null,null,null,null,null,null,null,null,{"$f":"(M15-M38)","v":606924}]
[14,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(M39,-1)","v":606920}]
[15," vk;dj dh x.kuk ",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(M40<=250000,0,IF(M40<=500000,(M40-250000)*0.05,IF(M40<=1000000,12500+(M40-500000)*0.2,IF(M40>1000000,112500+(M40-1000000)*0.3,\"0\")))),0)","v":33884}]
[null,"NwV &/kkjk 87¼A½ ds vUrxZr ¼3.5 yk[k rd dh dj ;ksX; vk; gksus ij NwV :- 2500 rd½",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M40>350000,0,IF(M41<2501,M41,2500))","v":0}]
[null," 'ks\"k vk;dj ",null,null,null,null,null,null,null,null,null,null,{"$f":"M41-M42","v":33884}]
[null,"f'k{kk midj  2%",null,null,null,{"$f":"ROUND((M43*0.02),0)","v":678},null,"lSd.Mjh vkSj mPp f'k{kk vf/kHkkj 1%",null,null,null,{"$f":"ROUND((M43*0.01),0)","v":339},{"$f":"F44+L44","v":1017}]
[null,"                                                             dqy vk;dj ¼3$4½",null,null,null,null,null,null,null,null,null,null,{"$f":"M43+M44","v":34901}]
[16,"?kVkb;s  %& jkgr /kkjk 89 ds rgr ",null,null,null,null,null,null,null,null,null,null,{"$f":"ENTRY!C62","v":0}]
[17,"dqy vk;dj ns;rk",null,null,null,null,null,null,null,null,null,null,{"$f":"M45-M46","v":34901}]
[18," vk;dj dVkSrh\n dk fooj.k",null,null,"flrEcj 2017rd",null,"fnlEcj 2017 rd",null,"tuojh 2018","Qjojh 2018",",fj;j ls VhMh,l"]
[null,null,null,null,{"$f":"SUM('G.A. 55'!R8:R14)","v":7000},null,{"$f":"SUM('G.A. 55'!R15:R17)+E49","v":10000},null,{"$f":"'G.A. 55'!R18","v":1000},{"$f":"'G.A. 55'!R19","v":1000},{"$f":"SUM('G.A. 55'!R20:R25)","v":0},null,{"$f":"'G.A. 55'!R26","v":12000}]
[{"$f":"IF(M47>M49,\"Income Tax Payable\",IF(M47<M49,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M47>M49,M47-M49,M49-M47)","v":22901}]
[]
[null,"Date :-",null,{"$f":"TODAY()","v":"2017-12-28"},null,null,null,null,null,null,null,"(Signature of Employee)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"E3","v":"VIJAY"}]
[]
[null,"Prepared by : VIJAY RANWA TEACHER,  "]
[null,"Govt Secondary School  Dhaneru, BIKANER     Mo. +919024228324"]
[null,"Email- vijaysalasar2011@gmail.com",null,null,null,null,null,null,null,"www.gssamarpura.jimdo.com"]

{"sheet":"HRA","index":6,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,5,15,10],[17,6,17,9],[8,13,8,20],[41,1,41,21],[38,1,38,21],[40,1,40,21],[39,1,39,21],[33,1,33,21],[34,1,34,21],[35,1,35,21],[36,1,36,21],[37,1,37,21],[32,1,32,21],[13,13,13,15],[17,19,17,21],[9,14,9,20],[0,12,0,21],[2,12,2,21],[15,13,15,15],[21,1,21,7],[31,1,31,21],[22,1,30,7],[0,1,0,10],[1,1,1,10],[24,12,24,21],[13,6,13,8],[2,1,2,10],[3,6,4,9],[5,6,6,9],[8,6,8,8],[9,6,9,8],[12,6,12,8]]}
[null,"THIS SOFTWARE MADE BY VIJAY RANWA",null,null,null,null,null,null,null,null,null,null,"RECEIPT OF HOUSE RENT"]
[null," TEACHER GOVT SECONDARY SCHOOL DHANERU, BIKANER"]
[null,"PARTIAL HRA EXEMPTION WORK SHEET",null,null,null,null,null,null,null,null,null,null,"(Under section 1 (13-A) of Income Tax Act)"]
[null,"MONTHS","\"Y\"","Basic Pay.","HRA",null,"Please select months by typing \"Y\" "]
[null,"MARCH 17","Y",{"$f":"IF(C5=\"Y\",'G.A. 55'!C8+ROUND((136%*'G.A. 55'!C8),0),\"0\")","v":50244},{"$f":"IF(C5=\"Y\",'G.A. 55'!E8,\"0\")","v":2129},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date :-",{"$f":"TODAY()","v":"2017-12-28"}]
[null,"APRIL 17","Y",{"$f":"IF(C6=\"Y\",'G.A. 55'!C9+ROUND((136%*'G.A. 55'!C9),0),\"0\")","v":50244},{"$f":"IF(C6=\"Y\",'G.A. 55'!E9,\"0\")","v":2129},null,"After selecting months, give rent paid amount. "]
[null,"MAY 17","Y",{"$f":"IF(C7=\"Y\",'G.A. 55'!C10+ROUND((136%*'G.A. 55'!C10),0),\"0\")","v":50244},{"$f":"IF(C7=\"Y\",'G.A. 55'!E10,\"0\")","v":2129},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\" I Owner     \", UPPER(ENTRY!C22))","v":" I Owner     "}]
[null,"JUNE 17","Y",{"$f":"IF(C8=\"Y\",'G.A. 55'!C11+ROUND((136%*'G.A. 55'!C11),0),\"0\")","v":50244},{"$f":"IF(C8=\"Y\",'G.A. 55'!E11,\"0\")","v":2129},null,null,null,null,null,null,null,null,null,{"$f":"\"           Received with Thanks from    \"&ENTRY!C8&\"\"","v":"           Received with Thanks from    VIJAY"}]
[null,"JULY 17","Y",{"$f":"IF(C9=\"Y\",'G.A. 55'!C12+ROUND((139%*'G.A. 55'!C12),0),\"0\")","v":52413},{"$f":"IF(C9=\"Y\",'G.A. 55'!E12,\"0\")","v":2193},null,"RENT PAID AMOUNT MONTHLY",null,null,{"$f":"ENTRY!C21","v":0},null,null,null,{"$f":"\"Address   :-  \"&ENTRY!C11","v":"Address   :-   GOVT SECONDARY SCHOOLDHANERU (BIKANER)"}]
[null,"AUGUST 17","Y",{"$f":"IF(C10=\"Y\",'G.A. 55'!C13+ROUND((139%*'G.A. 55'!C13),0),\"0\")","v":52413},{"$f":"IF(C10=\"Y\",'G.A. 55'!E13,\"0\")","v":2193},null,"HRA EXEMPTION AMOUNT",null,null,{"$f":"IF((J9*12)>D17*10%, MIN(ROUND(J9*12-(D17)*10%,0),J13),0)","v":0},null,null,null,"The sum of RS. -",{"$f":"IF(OR(LEN(FLOOR(N27,1))=13,FLOOR(N27,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(N27>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(O16),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(N27),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(N27),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(N27,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",N27,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\" Paise\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\" Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE($N$27,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\" Paise\",\"\")))))))","v":"Out of range"}]
[null,"SEPTEMBER 17","Y",{"$f":"IF(C11=\"Y\",'G.A. 55'!C14+ROUND((139%*'G.A. 55'!C14),0),\"0\")","v":52413},{"$f":"IF(C11=\"Y\",'G.A. 55'!E14,\"0\")","v":2193},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Towards the rent per Month  of  Rs. =   \",N26, \"/-   From  April  2017   To   March 2018\")","v":"Towards the rent per Month  of  Rs. =   0/-   From  April  2017   To   March 2018"}]
[null,"OCTOBER 17","Y",{"$f":"IF(C12=\"Y\",'G.A. 55'!C15+ROUND((139%*'G.A. 55'!C15),0),\"0\")","v":52413},{"$f":"IF(C12=\"Y\",'G.A. 55'!E15,\"0\")","v":2193},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total Rs.    \",N26* 12, \"/-     Balance Rs.  \",N26* O29, \"/-          And  advance Rs.   \",N26*O30,\"/-\")","v":"Total Rs.    0/-     Balance Rs.  0/-          And  advance Rs.   0/-"}]
[null,"NOVEMBER 17","Y",{"$f":"IF(C13=\"Y\",'G.A. 55'!C16+ROUND((5%*'G.A. 55'!C16),0),\"0\")","v":60060},{"$f":"IF(C13=\"Y\",'G.A. 55'!E16,\"0\")","v":4576},null,"Max. HRA exemption amount ",null,null,{"$f":"E19","v":37975}]
[null,"DECEMBER 17","Y",{"$f":"IF(C14=\"Y\",'G.A. 55'!C17+ROUND((5%*'G.A. 55'!C17),0),\"0\")","v":60060},{"$f":"IF(C14=\"Y\",'G.A. 55'!E17,\"0\")","v":4576},null,"Rent receipt required for max. exemption",null,null,{"$f":"ROUND(((10%*D19)+E19),0)","v":103827},{"$f":"ROUND(J14/C17, 0)","v":8652},null,null,{"$f":"CONCATENATE(\"Rs.  =  \",N27, \"/-\")","v":"Rs.  =  0/-"}]
[null,"JANUARY 18","Y",{"$f":"IF(C15=\"Y\",'G.A. 55'!C18+ROUND((5%*'G.A. 55'!C18),0),\"0\")","v":60060},{"$f":"IF(C15=\"Y\",'G.A. 55'!E18,\"0\")","v":4576},"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN USE THIS SHEET"]
[null,"FEBRUARY 18","Y",{"$f":"IF(C16=\"Y\",'G.A. 55'!C19+ROUND((5%*'G.A. 55'!C19),0),\"0\")","v":60060},{"$f":"IF(C16=\"Y\",'G.A. 55'!E19,\"0\")","v":4576},null,null,null,null,null,null,null,null,"Period: 01-04-2017 to 31-03-2018"]
[null,null,{"$f":"COUNTIF(C5:C16, \"Y\")","v":12},{"$f":"ROUND((SUM(D5:D16)),0)","v":650868},{"$f":"ROUND((SUM(E5:E16)),0)","v":35592}]
[null,null,null,{"$f":"'G.A. 55'!C24+'G.A. 55'!C25+'G.A. 55'!D24+'G.A. 55'!D25","v":7647},{"$f":"'G.A. 55'!E24+'G.A. 55'!E25","v":2383},null,"रसीद प्रिंट करने के लिए सीधा प्रिंट कमांड दें ।",null,null,null,null,null,null,null,null,null,null,null,null,"(Signature of House Owner)"]
[null,null,null,{"$f":"D17+D18","v":658515},{"$f":"E17+E18","v":37975}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N26*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01",{"$f":"V5-N28","v":271}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(O28, 30)","v":1},{"$f":"IF(N29>=15,(O28-N29)/30+1,(O28-N29)/30)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12-O29","v":3}]
[]
[null," मकान किराया भत्ता (HRA)  की छूट"]
[null,"यदि कोई कर्मचारी स्वयं के मकान में रहता हैं अथवा अथवा अन्य किसी के मकान में रहता है जिसके लिये उसके द्वारा कोई भी राशि किराये के रूप में भुगतान नहीं की जा रही है तो मकान किराया भत्ता पूर्णतः कर योग्य होगा। यदि कोई कर्मचारी किराये के मकान में रह रहा है तो कर्मचारी को मकान किराया भत्ते में निम्न में से सबसे कम राशि की छूट दी जावेगी।"]
[null,"1.    वर्ष के दौरान प्राप्त वास्तविक मकान किराया भत्ता"]
[null,"2.    वेतन (BP+DA) के 10% से अधिक चुकाया गया मकान किराया"]
[null,"3.    वेतन का (BP+DA) 40%  से अधिक चुकाया गया मकान किराया"]
[null,"NOTE :  मकान किराये में छूट हेतु वेतन से अभिप्राय मूल वेतन, मंहगाई भत्ते के योग से है।"]
[null,"Remarks about HRA"]
[null,"1. Though incurring actual expenditure on payment of rent is a pre-requisite for claiming deduction under section 10(13A), it has been decided as an administrative measure that salaried employee drawing house rent allowance up to 3000 per month will be exempted from production of rent receipt. It may, however be noted that this concession is only for purpose of Tax deduction at source, and in the regular assessment of the employee, the Assessing Officer will be free make such enquiry as he deems fit for the purpose of satisfying himself that the employee has incurred actual expenditure on payment of rent."]
[null,"2.  यदि कर्मचारी द्वारा प्रतिवर्ष 1 लाख से अधिक मकान किराया चुकाया जाता है तो ऐसी स्थिति में उसे मकान मालिक का पेन नम्बर नियोक्ता को उपलब्ध कराना आवश्यक है। और यदि मकान मालिक के पास पेन नंबर उपलब्ध नहीं है तो मकान मालिक से इस आशय की घोषणा मय मकान मालिक के नाम एवं पता सहित प्राप्त कर नियोक्ता को उपलब्ध करानी होगी।"]
[null,"3.   मकान किराये की छूट हेतु किरायानामा की प्रति नियोक्ता का उपलब्ध कराये जाने का कोई प्रावधान नहीं है।"]
[null,"As per new circular of CBDT vide its Circlular No. 08/2013 F.No. 275/192/2013-IT(B) dated 10.10.2013 if you are a salaried and claiming HRA (House Rent Allowance exemption and the rent paid by you is more than Rs.1 Lakh per year then it is compulsory to provide PAN (Permanent Account Number) of your Landlord. Earlier the limit was capped Rs.15,000 per month as against the current limit of Rs.8,333 per month PAN of landlord is not necessary if assessee is paying rent below Rs.8,333/- per month. However, in that case it is always recommended that rent is paid either by cheque or bank transfer which will be a record for the assessee. Also, in case the Assessing Officer demands proofs, bank entries will prove to be a better substitute than rent receipts."]

{"sheet":"16 NO.","index":7,"n_rows":138,"n_cols":10,"rows_kept":138,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[8,0,8,2],[8,3,8,4],[8,5,8,7],[8,8,8,10],[12,0,12,10],[9,0,9,4],[9,5,9,6],[9,7,9,10],[4,0,4,4],[4,5,4,10],[5,5,5,10],[6,5,6,10],[7,0,7,2],[7,3,7,4],[7,5,7,7],[7,8,7,10],[6,0,6,4],[5,0,5,4],[105,5,105,6],[118,5,118,6],[118,7,118,8],[93,5,93,6],[121,0,121,4],[114,1,114,4],[115,1,115,4],[116,1,116,4],[117,1,117,4],[118,1,118,4],[119,5,119,6],[119,7,119,8],[115,7,115,8],[116,5,116,6],[116,7,116,8],[114,5,114,6],[114,7,114,8],[100,5,100,6],[98,3,98,4],[103,5,103,6],[92,7,102,8],[120,0,120,2],[120,3,120,4],[106,1,106,4],[13,1,13,3],[13,5,13,7],[13,8,13,10],[14,1,14,3],[14,5,14,7],[14,8,14,10],[10,1,10,4],[10,5,11,6],[10,7,10,8],[10,9,10,10],[11,1,11,2],[11,7,11,8],[11,9,11,10],[17,1,17,3],[17,5,17,7],[17,8,17,10],[18,0,18,3],[18,5,18,7],[18,8,18,10],[15,1,15,3],[15,5,15,7],[15,8,15,10],[16,1,16,3],[16,5,16,7],[16,8,16,10],[23,1,23,2],[23,5,23,7],[23,8,23,10],[24,1,24,2],[24,5,24,7],[24,8,24,10],[19,0,19,10],[20,0,20,10],[21,0,22,0],[21,1,22,2],[21,3,21,10],[22,5,22,7],[22,8,22,10],[27,1,27,2],[27,5,27,7],[27,8,27,10],[28,1,28,2],[28,5,28,7],[28,8,28,10],[25,1,25,2],[25,5,25,7],[25,8,25,10],[26,1,26,2],[26,5,26,7],[26,8,26,10],[31,1,31,2],[31,5,31,7],[31,8,31,10],[32,1,32,2],[32,5,32,7],[32,8,32,10],[29,1,29,2],[29,5,29,7],[29,8,29,10],[30,1,30,2],[30,5,30,7],[30,8,30,10],[35,1,35,2],[35,5,35,7],[35,8,35,10],[36,1,36,2],[36,5,36,7],[36,8,36,10],[33,1,33,2],[33,5,33,7],[33,8,33,10],[34,1,34,2],[34,5,34,7],[34,8,34,10],[39,0,39,10],[40,0,41,0],[40,1,41,2],[40,3,40,10],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[37,1,37,2],[37,3,37,10],[38,0,38,10],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,1,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[50,1,50,2],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,1,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[52,1,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,1,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[55,1,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,10],[59,1,59,3],[59,9,59,10],[60,0,60,1],[60,2,60,4],[60,5,60,10],[56,1,56,2],[56,3,56,10],[57,0,57,10],[59,5,59,8],[65,0,65,1],[65,4,65,10],[66,0,66,1],[66,2,66,3],[66,5,66,10],[67,0,67,10],[61,2,61,6],[61,7,61,10],[62,0,62,10],[63,0,63,10],[64,0,64,1],[64,2,64,3],[64,4,64,10],[65,2,65,3],[68,0,68,10],[69,0,69,4],[69,5,69,6],[69,7,72,8],[69,9,82,10],[70,0,70,4],[70,5,70,6],[71,0,71,4],[71,5,71,6],[72,0,72,4],[77,5,77,6],[78,0,78,4],[78,5,79,6],[78,7,78,8],[79,0,79,4],[80,0,80,1],[80,2,80,4],[80,5,80,6],[72,5,72,6],[73,0,73,4],[73,5,76,6],[73,7,73,8],[74,0,74,4],[74,7,77,8],[75,0,75,2],[75,3,75,4],[76,0,76,2],[77,0,77,2],[81,0,81,1],[81,2,81,4],[81,5,81,6],[82,0,82,4],[82,5,90,6],[82,7,82,8],[83,0,83,4],[83,7,86,8],[88,0,88,4],[88,7,90,8],[88,9,88,10],[89,0,89,4],[89,9,90,10],[90,0,90,4],[96,5,96,6],[97,5,97,6],[104,7,104,8],[98,5,98,6],[99,5,99,6],[92,5,92,6],[91,0,91,4],[91,5,91,6],[91,7,91,8],[94,5,94,6],[95,5,95,6],[99,3,99,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[93,3,93,4],[92,2,104,2],[91,9,91,10],[83,9,83,10],[84,0,84,4],[84,9,87,10],[85,0,85,3],[86,0,86,3],[87,0,87,3],[87,7,87,8],[106,9,106,10],[92,0,106,0],[104,3,104,4],[92,3,92,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[104,9,104,10],[101,5,101,6],[102,5,102,6],[105,1,105,4],[105,9,105,10],[106,5,106,6],[106,7,106,8],[104,5,104,6],[107,7,107,9],[108,0,108,10],[110,5,110,6],[113,5,113,6],[113,7,113,8],[110,7,110,8],[111,5,111,6],[111,7,111,8],[112,5,112,6],[112,7,112,8],[109,0,109,4],[109,5,109,6],[109,7,109,8],[110,9,117,10],[131,9,131,10],[132,0,132,1],[132,2,132,4],[132,5,132,10],[123,5,123,6],[123,7,123,8],[123,9,123,10],[124,0,124,4],[124,5,124,6],[124,7,124,8],[124,9,124,10],[125,0,125,4],[125,5,125,6],[125,7,125,8],[125,9,125,10],[131,1,131,3],[129,0,129,4],[128,0,128,8],[121,9,121,10],[122,0,122,4],[122,9,122,10],[123,0,123,4],[122,7,122,8],[118,9,118,10],[119,0,119,4],[109,9,109,10],[117,5,117,6],[110,1,110,4],[111,1,111,4],[112,1,112,4],[113,1,113,4],[119,9,119,10],[120,5,120,6],[117,7,117,8],[115,5,115,6],[120,9,120,10],[120,7,120,8],[137,0,137,1],[137,2,137,3],[137,5,137,10],[136,0,136,1],[136,4,136,10],[126,5,126,6],[126,7,126,8],[126,9,126,10],[127,0,127,4],[127,5,127,6],[127,7,127,8],[127,9,127,10],[134,0,134,10],[128,9,128,10],[129,9,129,10],[126,0,126,4],[130,0,130,10],[136,2,136,3],[135,0,135,1],[135,2,135,3],[135,4,135,10],[133,2,133,4],[133,5,133,10],[131,5,131,8]]}
["FORM NO. 16"]
["[(See Rule 31(1)(a)]"]
["PART-A"]
["Certificate under section 203 of the income-tax act, 1961 for Tax deducted at source on Salary."]
["Name and address of the Employer",null,null,null,null,"Name and adress of the Employee"]
[{"$f":"ENTRY!J14","v":"ALTAF AHAMAD KHAN"},null,null,null,null,{"$f":"COMPUTATION!E3","v":"VIJAY"}]
[{"$f":"ENTRY!J12","v":"AMARPURA"},null,null,null,null,{"$f":"COMPUTATION!J3","v":" TEACHER"}]
["PAN of the Deductor",null,null,"TAN of  the Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$f":"ENTRY!J17","v":"BPGLP1184D"},null,null,{"$f":"ENTRY!J13","v":"2015V"},null,{"$f":"COMPUTATION!M3","v":"EFNPS7790B"}]
["CIT (TDS)",null,null,null,null,"Assess. Year",null,"Peroid with the Employer"]
["Adress","The Commissioner of Income Tax, Bikaner",null,null,null,"2018-19",null,"From",null,"To"]
["City","BIKANER",null,"PIN Code",334001,null,null,"01-4-2017",null,"31-03-2018"]
["Summary of amount paid/credited and tax deducted at source thereon in respect of the employee"]
["Quarters","Receipt Numbers of original quarterly statements of TDS under sub-secion (3) of section 200",null,null,"Amount paid/ credited","Amount of tax deducted (Rs.)",null,null,"Amount of tax deposited/ remitted (Rs.)"]
["Ist",null,null,null,{"$f":"SUM('G.A. 55'!R8:R10)","v":3000},{"$f":"IF(E15=\"\",\"NIL\", E15)","v":3000},null,null,{"$f":"F15","v":3000}]
["IInd",null,null,null,{"$f":"SUM('G.A. 55'!R11:R13)","v":3000},{"$f":"IF(E16=\"\",\"NIL\", E16)","v":3000},null,null,{"$f":"F16","v":3000}]
["IIIrd",null,null,null,{"$f":"SUM('G.A. 55'!R14:R16)","v":3000},{"$f":"IF(E17=\"\",\"NIL\", E17)","v":3000},null,null,{"$f":"F17","v":3000}]
["IVth",null,null,null,{"$f":"SUM('G.A. 55'!R17:R25)","v":3000},{"$f":"IF(E18=\"\",\"NIL\", E18)","v":3000},null,null,{"$f":"F18","v":3000}]
["TOTAL",null,null,null,{"$f":"SUM(E15:E18)","v":12000},{"$f":"SUM(F15:F18)","v":12000},null,null,{"$f":"SUM(I15:I18)","v":12000}]
["I. Details of tax deducted and deposited in the Central Government account through book adjustment"]
["(The Deductor to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
["S.N.","Tax Deposited in respect of the deductee (Rs)",null,"Book identification number (BIN)"]
[null,null,null,"Receipt numbers of form No. 24G","DDO serial number in Form No. 24G","Date of transfer voucher (dd/mm/yyyy)",null,null,"Status of matching with Form No. 24G"]
[1,{"$f":"'G.A. 55'!R8","v":1000},null,null,null,null,null,null,{"$f":"IF(D24>\"0\",\"Yes\",\"-\")","v":"-"}]
[2,{"$f":"'G.A. 55'!R9","v":1000},null,null,null,null,null,null,{"$f":"IF(D25>\"0\",\"Yes\",\"-\")","v":"-"}]
[3,{"$f":"'G.A. 55'!R10","v":1000},null,null,null,null,null,null,"-"]
[4,{"$f":"'G.A. 55'!R11","v":1000},null,null,null,null,null,null,"-"]
[5,{"$f":"'G.A. 55'!R12","v":1000},null,null,null,null,null,null,"-"]
[6,{"$f":"'G.A. 55'!R13","v":1000},null,null,null,null,null,null,"-"]
[7,{"$f":"'G.A. 55'!R14","v":1000},null,null,null,null,null,null,"-"]
[8,{"$f":"'G.A. 55'!R15","v":1000},null,null,null,null,null,null,"-"]
[9,{"$f":"'G.A. 55'!R16","v":1000},null,null,null,null,null,null,"-"]
[10,{"$f":"'G.A. 55'!R17","v":1000},null,null,null,null,null,null,"-"]
[11,{"$f":"'G.A. 55'!R18","v":1000},null,null,null,null,null,null,"-"]
[12,{"$f":"'G.A. 55'!R19","v":1000},null,null,null,null,null,null,"-"]
[13,{"$f":"'G.A. 55'!R20","v":0},null,null,null,null,null,null,"-"]
[14,{"$f":"'G.A. 55'!R24+'G.A. 55'!R25","v":0},null,null,null,null,null,null,"-"]
["Total",{"$f":"SUM(B24:B37)","v":12000}]
["II. Details of Tax deducted and deposited in Central Government Account through Challan. "]
["(The deducter to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
["S.N.","Tax Deposited in respect on of the deductee (Rs)",null,"Challan identification number (CIN)"]
[null,null,null,"BSR code of the Bank Branch",null,"Date on which tax deposited (dd/mm/yyyy)",null,"Challan Serial Number",null,"Status of matching with OLTAS"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
["Total",{"$f":"SUM(B43:B56)","v":0}]
[":: 2 ::"]
["Verification"]
["I",{"$f":"A6&\",\"","v":"ALTAF AHAMAD KHAN,"},null,null,"Son/Daughter of ",{"$f":"ENTRY!J15","v":0},null,null,null,"working in the "]
["capacity of ",null,{"$f":"ENTRY!J10","v":"HEADMASTER"},null,null,"(designation) do hereby certify that a sum of "]
["Rs.",{"$f":"I19","v":12000},{"$f":"IF(OR(LEN(FLOOR(B62,1))=13,FLOOR(B62,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B62>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B62,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",B62,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\" Paise\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\" Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\" Paise\",\"\")))))))","v":"Twelve Thousand  Rupees"},null,null,null,null,"(in words) has been deducted "]
["and deposited to the credit of the Central Govt.. I further certify that the information given above is true, complete and "]
["correct and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
["Place",null,{"$f":"ENTRY!J18","v":"BIKANER"}]
["Date",null,{"$f":"TODAY()","v":"2017-12-28"},null,"Signature of person responsible for deduction of tax"]
["Designation",null,{"$f":"ENTRY!J10","v":"HEADMASTER"},null,"Full name",{"$f":"A6","v":"ALTAF AHAMAD KHAN"}]
["PART- B (Annexure)"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
["1. Gross salary"]
["(a) Salary as per provisions contained in section 17(1)",null,null,null,null,{"$f":"COMPUTATION!M4","v":770988}]
["(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)"]
["(c) Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",null,null,null,null,0]
["(d) Total  (a+b+c)",null,null,null,null,null,null,{"$f":"F71+F72+F73","v":770988}]
["2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
["Allowance",null,null,"Rs."]
["House Rent Allow. US10 (13 A)",null,null,{"$f":"IF(E77=\"0\",\"\",'G.A. 55'!E26)","v":37975},{"$f":"ENTRY!D20","v":0}]
["US10 (14)",null,null,null,{"$f":"ENTRY!C24","v":0},{"$f":"E77+E78","v":0}]
["3. Balance (1 - 2)",null,null,null,null,null,null,{"$f":"H74-F78","v":770988}]
["4. Deductions: U/s 16"]
["(a)",null,"Entertainment allowance",null,null,{"$f":"COMPUTATION!M7","v":0}]
["(b)",null,"Tax on employment",null,null,0]
["5. Aggregate of 4 (a) and (b)",null,null,null,null,null,null,{"$f":"F81+F82","v":0}]
["6. Income chargeable under the head \"salaries\" (3-5)",null,null,null,null,null,null,null,null,{"$f":"H79-H83","v":770988}]
["7. Add: Any other income reported by employee "]
["Income",null,null,null,"Rs"]
["From House Property",null,null,null,{"$f":"COMPUTATION!K9-COMPUTATION!K11","v":0}]
["Saving Bank A/C interest",null,null,null,{"$f":"SUM(COMPUTATION!B14:L14)","v":0},null,null,{"$f":"E87+E88","v":0}]
["8. Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"J84+H88","v":770988}]
["9. Deductions under Chapter VI A"]
["(A) Section 80C, 80CCC and 80CCD"]
["(a) Section 80C",null,null,null,null,null,null,"Gross Amount",null,"Deductible Amount"]
["A",1,"(A)","GPF",null,{"$f":"COMPUTATION!G22","v":""}]
[null,2,null,"State Insurance",null,{"$f":"COMPUTATION!G17","v":31800}]
[null,3,null,"Gr. Acc. Insurance",null,{"$f":"COMPUTATION!G23","v":220}]
[null,4,null,"LIC + ULIP + PLI",null,{"$f":"COMPUTATION!G18+COMPUTATION!G24+COMPUTATION!L23","v":0}]
[null,5,null,"PPF",null,{"$f":"COMPUTATION!G20","v":0}]
[null,6,null,"Home Loan Installment (Capital)",null,{"$f":"COMPUTATION!G25","v":0}]
[null,7,null,"Notified Bond Of NABARD",null,{"$f":"COMPUTATION!L21","v":0}]
[null,8,null,"Pension Plan (US80ccc+US 80CCD)(1)",null,{"$f":"COMPUTATION!L17+COMPUTATION!L18","v":66022}]
[null,9,null,"Tution Fee",null,{"$f":"COMPUTATION!L20","v":0}]
[null,10,null,"NSC + Interest on NSC",null,{"$f":"COMPUTATION!L19+COMPUTATION!G19","v":0}]
[null,11,null,"Sukanya Samridhi A/C",null,{"$f":"COMPUTATION!L22","v":0}]
[null,12,null,"Fixed Deposit above 5 years",null,{"$f":"COMPUTATION!L24","v":0}]
[null,13,null,"Mutual Fund",null,{"$f":"COMPUTATION!G21","v":0},null,{"$f":"SUM(F91:F105)","v":98042},null,{"$f":"IF(H105<=150000, H105, 150000)","v":98042}]
[null,"(B) Section 80CCD(2)",null,null,null,{"$f":"COMPUTATION!L26","v":66022}]
[null,"(C) Section 80CCD(1B)  (RS.-50000/-)",null,null,null,{"$f":"COMPUTATION!L27","v":0},null,{"$f":"J105+F106+F107","v":164064},null,{"$f":"H107","v":164064}]
[null,null,null,null,null,null,null,"………………… 3"]
[":: 3 ::"]
["(B) Other Sections (e.g. 80E, 80G etc.) under Chapter VIA",null,null,null,null,"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
[1,"U/S 80D",null,null,null,{"$f":"COMPUTATION!M30","v":0},null,{"$f":"F111","v":0}]
[2,"U/S 80DD",null,null,null,{"$f":"COMPUTATION!M31","v":0},null,0]
[3,"U/S 80DDB",null,null,null,{"$f":"COMPUTATION!M32","v":0},null,0]
[4,"U/S 80E",null,null,null,{"$f":"COMPUTATION!M33","v":0},null,0]
[5,"U/S 80G",null,null,null,{"$f":"COMPUTATION!M34","v":0},null,0]
[6,"U/S 80GG",null,null,null,null,null,0]
[7,"U/S 80GGA",null,null,null,null,null,0]
[8,"U/S 80U",null,null,null,{"$f":"COMPUTATION!M35","v":0},null,0]
[9,"US 80TTA [Exempt Saving Bank Int. Max. RS. 10,000/-]",null,null,null,{"$f":"COMPUTATION!I14","v":0},null,{"$f":"COMPUTATION!M36","v":0},null,{"$f":"ROUND((H111+H112+H113+H114+H115+H116+H117+H118+H119),0)","v":0}]
["10. Aggregate of deductible amount under chapter VIA ",null,null,null,null,null,null,null,null,{"$f":"ROUND((J107+J119),0)","v":164064}]
["11. Total income (8-10)",null,null,"(Roundup Figures of Rs 10)",null,null,null,null,null,{"$f":"ROUND((J89-J120),-1)","v":606920}]
["12. Tax on total income",null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(J121<=250000,0,IF(J121<=500000,(J121-250000)*0.05,IF(J121<=1000000,12500+(J121-500000)*0.2,IF(J121>1000000,112500+(J121-1000000)*0.3,\"0\")))),0)","v":33884}]
["13. Rebate U/s 87 A (Taxable Income below Rs. 5,00,000/-)",null,null,null,null,null,null,{"$f":"COMPUTATION!M42","v":0}]
["14. Tax payable (12-13)",null,null,null,null,null,null,null,null,{"$f":"J122-H123","v":33884}]
["15. Education cess @ 3% (on tax computed at S.No. 12)",null,null,null,null,null,null,null,null,{"$f":"ROUND((J124*0.02),0)+ROUND((J124*0.01),0)","v":1017}]
["16. Tax payable (14+15) [Round off U/s 288 B]",null,null,null,null,null,null,null,null,{"$f":"J124+J125","v":34901}]
["17. Less:- Relief under section 89 (Attach Form 10E)",null,null,null,null,null,null,null,null,{"$f":"COMPUTATION!M46","v":0}]
["18. Tax payable (14-15)",null,null,null,null,null,null,null,null,{"$f":"J126-J127","v":34901}]
["19. Tax deducted at source u/s 192 (1)",null,null,null,null,null,null,null,null,{"$f":"COMPUTATION!M49","v":12000}]
[{"$f":"IF(J128>J129,\"Income Tax Payable\",IF(J128<J129,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},null,null,null,null,null,null,null,null,{"$f":"IF(J128>J129,J128-J129,J129-J128)","v":22901}]
["Verification"]
["I",{"$f":"A6&\",\"","v":"ALTAF AHAMAD KHAN,"},null,null,"Son/Daughter of ",{"$f":"F60","v":0},null,null,null,"working in the "]
["capacity of ",null,{"$f":"ENTRY!J10","v":"HEADMASTER"},null,null,"(designation) do hereby certify that a sum of "]
["Rs.",{"$f":"I19","v":12000},{"$f":"IF(OR(LEN(FLOOR(B62,1))=13,FLOOR(B62,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B62>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B62),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B62),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B62,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",B62,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\" Paise\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\" Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\" Paise\",\"\")))))))","v":"Twelve Thousand  Rupees"},null,null,"(in words) has beeen deducted and deposited to the "]
[" credit of the Central Government. I further certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
["Place",null,{"$f":"C65","v":"BIKANER"}]
["Date",null,{"$f":"TODAY()","v":"2017-12-28"},null,"Signature of person responsible for deduction of tax"]
["Designation",null,{"$f":"C133","v":"HEADMASTER"},null,"Full name",{"$f":"A6","v":"ALTAF AHAMAD KHAN"}]

{"sheet":"89(1)form","index":8,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,0,4,10],[5,0,5,10],[4,11,4,13],[15,3,15,6],[10,0,10,2],[11,0,11,2],[12,3,12,6],[13,3,13,6],[14,3,14,6],[12,0,12,2],[13,0,13,2],[14,0,14,2],[6,0,9,2],[15,11,15,13],[6,11,9,13],[15,7,15,10],[0,20,0,26],[1,20,6,26],[0,0,0,13],[0,16,1,19],[1,0,1,2],[1,3,1,13],[2,0,2,2],[2,3,2,13],[3,16,5,19],[3,0,3,2],[3,3,3,6],[3,7,3,10],[3,11,3,13],[5,11,5,13],[6,3,9,6],[6,7,9,10],[15,0,15,2],[10,3,10,6],[11,3,11,6],[8,16,10,19],[10,11,10,13],[11,11,11,13],[12,11,12,13],[13,11,13,13],[12,16,14,19],[14,11,14,13],[12,7,12,10],[13,7,13,10],[14,7,14,10],[10,7,10,10],[11,7,11,10]]}
["CALCULATION OF SALARY ARREAR RELIEF UNDER SECTION 89 (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1- loZizFke vius ,fj;j dks xr foÙkh; o\"kksZa ds vuqlkj foHkkftr djsaA",null,null,null,"धारा US 89 की छूट का नियम "]
["NAME",null,null,{"$f":"COMPUTATION!E3","v":"VIJAY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           यदि कर्मचारी को गत वर्ष का कोई एरियर इस वर्ष मेँ प्राप्त हुआ है तो वह गत वर्ष में कर योग्य होगा बर्शते वह राशि उपार्जित होने वाले वर्ष में पहले ही कर योग्य न की गई हो तो एरियर पर धारा 89 की छूट का दावा किया जा सकता है I"]
["ADDRESS",null,null,{"$f":"ENTRY!C11","v":" GOVT SECONDARY SCHOOLDHANERU (BIKANER)"}]
["PAN",null,null,{"$f":"'16 NO.'!F9","v":"EFNPS7790B"},null,null,null,"CATEGORY",null,null,null,"Indian Resident",null,null,null,null,"2- vc lEcfU/kr foÙkh; o\"kksZa ds QkWeZ 16 vFkok ITR ls dj ;ksX; vk; dks lEcfU/kr lsYl esa Hkjuk gSA"]
["Total Taxable Income including Arrear Received in FY 2017-18",null,null,null,null,null,null,null,null,null,null,{"$f":"COMPUTATION!M40","v":606920}]
[" Year-wise Breakup of Arrears received and taxable income "]
["Financial Year",null,null,"Taxable Income of the relevant F.Y. without the arrears or advance (Rs.)",null,null,null,"Amount of Arrears or Advance  received against each Financial Year (Rs.)",null,null,null,"Total Taxable Income of the relevant F.Y. with the arrears or advance (Rs.)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3- dj ;ksX; vk; og vk; gS ftl ij ml foÙkh; o\"kZ esa fu/kkZfjr vk;dj nj ls vk;dj dh x.kuk dh tkrh gSA "]
[]
["2016-17",null,null,null,null,null,null,null,null,null,null,{"$f":"D11+H11","v":0}]
["2015-16",null,null,null,null,null,null,null,null,null,null,0]
["2014-15",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"4- vc bl QkWeZ esa lEcfU/kr foÙkh; o\"kZ  dh dj ;ksX; vk; ,oa ml o\"kZ ls lEcfU/kr ,fj;j dh jkf'k HkjsaA /;ku jgs foÙkh; o\"kZ 2017&18 ds fy, Hkjh x;h dj ;ksX; vk; esa lEiw.kZ ,fj;j dh jkf'k tqMh gksA "]
["2013-14",null,null,null,null,null,null,null,null,null,null,0]
["2012-13",null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,{"$f":"SUM(D11:G15)","v":0},null,null,null,{"$f":"SUM(H11:K15)","v":0},null,null,null,0]

{"sheet":"Form10E","index":9,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,0,38,7],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[34,12,34,13],[36,0,36,1],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[35,10,35,11],[35,12,35,13],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[32,12,32,13],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[30,12,30,13],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[20,0,20,10],[20,11,20,13],[21,0,21,10],[21,11,21,13],[22,0,22,10],[22,11,22,13],[26,0,26,10],[26,11,26,13],[28,0,28,13],[0,0,0,13],[1,0,1,13],[2,0,2,2],[2,3,2,13],[12,0,12,13],[13,0,13,13],[16,10,16,13],[18,0,18,13],[19,0,19,10],[19,11,19,13],[9,0,9,10],[9,11,9,13],[10,0,10,10],[10,11,10,13],[11,0,11,10],[11,11,11,13],[15,1,15,2],[43,0,43,1],[44,0,44,1],[45,6,45,7],[3,0,3,2],[3,3,3,13],[4,0,4,2],[4,3,4,7],[4,8,4,9],[40,0,40,1],[41,0,41,1],[42,0,42,1],[4,10,4,13],[5,0,5,13],[6,0,6,13],[7,0,7,10],[7,11,7,13],[8,0,8,10],[8,11,8,13],[23,0,23,10],[23,11,23,13],[24,0,24,10],[24,11,24,13],[25,0,25,10],[25,11,25,13]]}
["FORM NO. 10 E (See rule 21AA)"]
["Form for furnishing particulars of income undr scetion 192(2A) for year ending 31st March 2018 for claiming relief under section 89(1) by a Government servant or an employee in a company, co-operative society, local authority, university, institution, association or body."]
["Name",null,null,{"$f":"PROPER(IF('89(1)form'!D2=\"\",\"\",'89(1)form'!D2))","v":"Vijay"}]
["Address",null,null,{"$f":"PROPER(IF('89(1)form'!D3=\"\",\"\",'89(1)form'!D3))","v":" Govt Secondary Schooldhaneru (Bikaner)"}]
["PAN",null,null,{"$f":"UPPER(IF('89(1)form'!D4=\"\",\"\",'89(1)form'!D4))","v":"EFNPS7790B"},null,null,null,null,"Status",null,"Indian Resident "]
[]
["Particulars of Income referred to in rule 21A of the Income tax Rules, 1962, during the previous year relevant to assessment year 2018-19"]
["1. (a) Salary received in arrears or in advance during 2017-18 in accordance with the provision of sub-rule (2) of rule 21A",null,null,null,null,null,null,null,null,null,null,{"$f":"'89(1)form'!H16","v":0}]
["(b) Payment in the nature of gratuity in respect of past services, extending over a period of not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["(c) Payment in the nature of compensation from the employer or former employer at or in connection with termination of employment after continuous service of not less than 3 years in accordance with the provisions of sub-rule (4) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["(d) Payment in commutation of pension in accordance with the provisions of sub-rule (5) of rule 21A",null,null,null,null,null,null,null,null,null,null,"Not applicable "]
["2. Detailed particulars of payments referred to above may be given in Annexure I, II, IIA, III or IV as the case may be ",null,null,null,null,null,null,null,null,null,null,"Annexure- I"]
["Verification "]
["I do hereby declare that what is stated above is true to the best of my knowledge and belief. Verified today "]
[]
["Date:",{"$f":"TODAY()","v":"2017-12-28"}]
[null,null,null,null,null,null,null,null,null,null,"Signature of the employee"]
[]
["ANNEXURE - I"]
["1. Total net taxable Income excluding Salary received in Arrears or advance ",null,null,null,null,null,null,null,null,null,null,{"$f":"L22-L21","v":606920}]
["2. salary received in arrears or advance",null,null,null,null,null,null,null,null,null,null,{"$f":"L8","v":0}]
["3. Total Income (as increased by salary received in arrears or advance) (Add item 1 and item 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"'89(1)form'!L5","v":606920}]
["4. Tax on total income (as per item 3)",null,null,null,null,null,null,null,null,null,null,{"$f":"COMPUTATION!M45","v":34901}]
["5. Tax on total income (as per item 1)",null,null,null,null,null,null,null,null,null,null,{"$f":"K48","v":34901}]
["6. Tax on salary received in arrears or advance (Difference of item 4 and item 5)",null,null,null,null,null,null,null,null,null,null,{"$f":"L23-L24","v":0}]
["7. Tax computed in accordance with Table \"A\" (Brought from column 7 of Table \"A\")",null,null,null,null,null,null,null,null,null,null,{"$f":"M37","v":0}]
["8. Relief under section 89 (1) (Indicate the difference between the amounts mentioned against items 6 and 7)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8>0, L25-L26, 0)","v":0}]
[]
["TABLE \"A\"  (See item 7 of Annexure I)"]
["Previous Year(s)",null,"Total Net Taxable income of the relevant previous year ",null,"salary received in arrears or advance relating to the relevant previous year as mentioned in col. (1)",null,"Total income (as increased by salry received in arrears or advance) or the relevant previous year mentioned in col. (1) (Add col. 2 and 3)",null,"Tax on total income (as per col. 2)",null,"Tax on total income (as per col. 4)",null,"Difference in tax (Amount under col. 6 minus amount under col. 5)"]
[1,null,2,null,3,null,4,null,5,null,6,null,7]
["2012-13",null,{"$f":"ROUND('89(1)form'!D15, -1)","v":0},null,{"$f":"ROUND('89(1)form'!H15, -1)","v":0},null,{"$f":"C32+E32","v":0},null,{"$f":"SUM(I41:J41)","v":0},null,{"$f":"SUM(K41:L41)","v":0},null,{"$f":"K32-I32","v":0}]
["2013-14",null,{"$f":"ROUND('89(1)form'!D14, -1)","v":0},null,{"$f":"ROUND('89(1)form'!H14, -1)","v":0},null,{"$f":"C33+E33","v":0},null,{"$f":"SUM(I42:J42)","v":0},null,{"$f":"SUM(K42:L42)","v":0},null,{"$f":"K33-I33","v":0}]
["2014-15",null,{"$f":"ROUND('89(1)form'!D13, -1)","v":0},null,{"$f":"ROUND('89(1)form'!H13, -1)","v":0},null,{"$f":"C34+E34","v":0},null,{"$f":"SUM(I43:J43)","v":0},null,{"$f":"SUM(K43:L43)","v":0},null,{"$f":"K34-I34","v":0}]
["2015-16",null,{"$f":"ROUND('89(1)form'!D12, -1)","v":0},null,{"$f":"ROUND('89(1)form'!H12, 0)","v":0},null,{"$f":"C35+E35","v":0},null,{"$f":"SUM(I44:J44)","v":0},null,{"$f":"SUM(K44:L44)","v":0},null,{"$f":"K35-I35","v":0}]
["2016-17",null,{"$f":"ROUND('89(1)form'!D11, -1)","v":0},null,{"$f":"ROUND('89(1)form'!H11, -1)","v":0},null,{"$f":"C36+E36","v":0},null,{"$f":"SUM(I45:J45)","v":0},null,{"$f":"SUM(K45:L45)","v":0},null,{"$f":"K36-I36","v":0}]
["Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M32+M33+M34+M35+M36","v":0}]
[]
[]
[]
["2012-13",null,null,null,null,null,null,null,{"$f":"IF(C32>1000000, 130000+(C32-1000000)*0.3, IF(C32>500000, 30000+(C32-500000)*0.2, IF(C32>200000, (C32-200000)*0.1, 0)))","v":0},{"$f":"ROUND(I41*0.03, 0)","v":0},{"$f":"IF(G32>1000000, 130000+(G32-1000000)*0.3, IF(G32>500000, 30000+(G32-500000)*0.2, IF(G32>200000, (G32-200000)*0.1, 0)))","v":0},{"$f":"ROUND(K41*0.03, 0)","v":0}]
["2013-14",null,null,null,null,null,null,null,{"$f":"IF(C33>1000000, 130000+(C33-1000000)*0.3, IF(C33>500000, 30000+(C33-500000)*0.2, IF(C33>220000, (C33-220000)*0.1, 0)))","v":0},0,{"$f":"IF(G33>1000000, 130000+(G33-1000000)*0.3, IF(G33>500000, 30000+(G33-500000)*0.2, IF(G33>220000, (G33-220000)*0.1, 0)))","v":0},{"$f":"ROUND(K42*0.03, 0)","v":0}]
["2014-15",null,null,null,null,null,null,null,{"$f":"IF(C34>1000000, 125000+(C34-1000000)*0.3, IF(C34>500000, 25000+(C34-500000)*0.2, IF(C34>270000, (C34-270000)*0.1, 0)))","v":0},0,{"$f":"IF(G34>1000000, 125000+(G34-1000000)*0.3, IF(G34>500000, 25000+(G34-500000)*0.2, IF(G34>270000, (G34-270000)*0.1, 0)))","v":0},{"$f":"ROUND(K43*0.03, 0)","v":0}]
["2015-16",null,null,null,null,null,null,null,{"$f":"IF(C35>1000000, 125000+(C35-1000000)*0.3, IF(C35>500000, 25000+(C35-500000)*0.2, IF(C35>270000, (C35-270000)*0.1, 0)))","v":0},0,{"$f":"IF(G35>1000000, 125000+(G35-1000000)*0.3, IF(G35>500000, 25000+(G35-500000)*0.2, IF(G35>270000, (G35-270000)*0.1, 0)))","v":0},{"$f":"ROUND(K44*0.03, 0)","v":0}]
["2016-17",null,null,null,null,null,null,null,{"$f":"IF(C36>1000000, 125000+(C36-1000000)*0.3, IF(C36>500000, 25000+(C36-500000)*0.2, IF(C36>300000, (C36-300000)*0.1, 0)))","v":0},0,{"$f":"IF(G36>1000000, 125000+(G36-1000000)*0.3, IF(G36>500000, 25000+(G36-500000)*0.2, IF(G36>300000, (G36-300000)*0.1, 0)))","v":0},{"$f":"ROUND(K45*0.03, 0)","v":0}]
[null,null,null,null,null,null,{"$f":"'89(1)form'!L5-L8","v":606920},null,{"$f":"IF(G46>1000000, 125000+(G46-1000000)*0.3, IF(G46>500000, 12500+(G46-500000)*0.2, IF(G46>250000, (G46-250000)*0.05, 0)))","v":33884},1017]
[null,null,null,null,null,null,null,null,{"$f":"IF(G46<350001, 2500, 0)","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"IF(I46>I47, I46-I47, 0)","v":33884},{"$f":"ROUND(I48*0.03, 0)","v":1017},{"$f":"ROUND(I48+J48, 0)","v":34901}]